Smuggler Archive
Thread: Smuggler Faction Selling Spreadsheet Opinions/review needed
Page 1 of 2
Rinia
Fri Jun 24, 2005 2:06 pm
#1
Ever find it to be a pain to calculate how much faction you need to buy so you'll have enough to sell to a customer? Ever wonder how much money you will make? I know when i first started selling faction i had a TERRIBLE time trying to figure that all out. Well... for all of you people having trouble, look no further.
Here it is, folks. I've been working for a while on this spreadsheet for the smuggler community (and myself 
). It's a very simple spreadsheet. You only need to insert two, yes TWO, numbers! Amount of faction requested by your client, and your charging price. The spreadsheet will tell you how much faction you need to buy, how many 100k/20k equitable trades you should make, and your net profit.
). It's a very simple spreadsheet. You only need to insert two, yes TWO, numbers! Amount of faction requested by your client, and your charging price. The spreadsheet will tell you how much faction you need to buy, how many 100k/20k equitable trades you should make, and your net profit.It IS based on the assumption that the smuggler selling faction is ranked at Colonel and requires Microsoft Excel to open.
If someone finds any flaws or has any suggestions feel free to PM me.
If it prompts you for a username and password you should be able to click cancel and have it open. This is only a temporary link until i have someone host it on a different server for me.
Message
Message Edited by Rinia on 06-25-2005 08:35 AM
MaxSteele
Fri Jun 24, 2005 2:21 pm
#2
It looks like it also assumes that you do not have the Inspiration buff and that you're Imperial. Rebels get a further faction point bonus.
Message Edited by MaxSteele on 06-24-2005 02:28 PM
Rinia
Fri Jun 24, 2005 2:28 pm
#3
MaxSteele wrote:
It looks like it also assumes that you have the Inspiration buff on, and that you're Imperial. Rebels get a further faction point bonus.
Inspiration buff, no. I did all calculations without an inspiration buff. 80 cpu from recruiters is what i found it cost. 100k for 1250FP. 20k for 250FP. It costs me 117.7 faction points to transfer 100 faction points to another player while i am ranked colonel.
Imperial yes. I AM imperial. however there is a slot where you can insert the cost per unit that you buy from the recruiter. As an imp, my exchange rate is 80 CPU. I'm not sure if its different for rebels but if it cost you say... 50 cpu for rebels you could easily insert that and it would be factored into the equation.
DeepProgress
Fri Jun 24, 2005 3:05 pm
#4
Also it doesn't look like the function for "actual price" uses the variable you put in for FP cost. It should look like this:
=((H18*1250)+(H20*250))*H11
=((H18*1250)+(H20*250))*H11
Message Edited by DeepProgress on 06-24-2005 03:07 PM
Rinia
Fri Jun 24, 2005 3:47 pm
#5
DeepProgress wrote:
Also it doesn't look like the function for "actual price" uses the variable you put in for FP cost. It should look like this:
=((H18*1250)+(H20*250))*H11
Message Edited by DeepProgress on 06-24-2005 03:07 PM
you are correct sir. problem fixed.
Rinia
Fri Jun 24, 2005 7:49 pm
#6
can anyone else check it out and let me know if they see any flaws or know of anything about rebel faction selling (if there is anything different from imp)
MaleusGaryn
Sat Jun 25, 2005 8:32 am
#7
What program do I need to open this up? And where can I download it if I need to?
ChuTneYuk
Sat Jun 25, 2005 8:35 am
#8
MaleusGaryn wrote:What program do I need to open this up? And where can I download it if I need to?
you need microsoft Excel dude.
i am not sure if there are any 'freeware' programs that you can download that also use the /.xls extension
Rinia
Sat Jun 25, 2005 8:36 am
#9
MaleusGaryn wrote:What program do I need to open this up? And where can I download it if I need to?
it requires microsoft excel to open it. as to where you can download that... im not sure. i bought the microsoft office package and it came with that.
ChuTneYuk
Sat Jun 25, 2005 8:37 am
#10
Oh and no-one has said it yet so:
Thank you very much for taking the time to build this spreadsheet. i know it will help a lot of ppl.
I currently use good old calc, but when i get excel installed, ill use your spread sheet.
thanks again, another example of the smuggler community awesomeness
Thank you very much for taking the time to build this spreadsheet. i know it will help a lot of ppl.
I currently use good old calc, but when i get excel installed, ill use your spread sheet.
thanks again, another example of the smuggler community awesomeness
MaleusGaryn
Sat Jun 25, 2005 8:41 am
#11
ChuTneYuk wrote:
Oh and no-one has said it yet so:
Thank you very much for taking the time to build this spreadsheet. i know it will help a lot of ppl.
I currently use good old calc, but when i get excel installed, ill use your spread sheet.
thanks again, another example of the smuggler community awesomeness
Agreed... I can't see it yet, but I'm sure I'll use it once I get Excel. Thanks!
Rinia
Sat Jun 25, 2005 11:35 am
#12
you're welcome guys. Spread the word about this too. i'm sure there are some bugs left in it and i'd like to get those worked out but i cant do it all by myself.
Rinia
Sat Jun 25, 2005 5:14 pm
#13
Jaspor wrote:
Very nice, thanks!Two things:1) Have you considered formatting the fields to have comma separators for numbers? (ie, 1,000,000 is a lot easier to read than 1000000, I think).2) Not sure if this is possible or not, but it would be nice if you could enter a number in the "Charge Price" field and have the "Credits Charged Per Unit" field update. Or all the rest of the fields, for that matter.Very nice though, good job!
i didnt think about that. i'll check and see if i can format the cells to do that.
as for the second item... that would require a second calculator. its possible though.
Page 1 of 2