Profit calculating spreadsheet

Bill Gates RJ: Bill Gates CO: Bill Gates Post Rating: 1 + / - Total Posts: 19 Karma: 17 Joined: Apr 6, 2012	Posted on May 5, 2012 This spreadsheet will let you calculate any sort-of profit plans for your company: http://dl.dropbox.com/u/35740829/ProfitCalc.xlsx It takes into account the "Economies of Scale Bonus" for both the materials and the cash cost, so that it's extremely accurate, if not exact to EoS. I'm lazy so at the moment it only supports 3 different materials: You can literally copy and paste the material blocks to create more if needed, then simply add another + to the "Cost of materials" cell to add the total of material 4, 5, etc.
Josh R RJ: Josh CO: Josh Post Rating: 0 + / - Total Posts: 15 Karma: 14 Joined: Apr 3, 2012	Posted on May 5, 2012 Thanks for posting this. One possible typo: when I look at the formula for the "Adjusted EoS Quantity", it looks like it uses cell G17, the actual cost per unit, instead of cell G16, the EoS bonus. I'm viewing this in Google Docs, so perhaps something got changes in the translation.
Bill Gates RJ: Bill Gates CO: Bill Gates Post Rating: 0 + / - Total Posts: 19 Karma: 17 Joined: Apr 6, 2012	Posted on May 6, 2012 Oh crap, I'm an idiot, when I was experimenting with it, I was using halite which is 100 wholesale... so G17 is basically the same as G16. Anyway, should be fixed now, I've fixed the cells and resynced to my dropbox

You need to register or login to post a reply.