These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Another profit calculating Google Sheet

Author
Previous Topic Next Topic
Fat Buddah
Federal Navy Academy
Gallente Federation
#1 - 2015-11-20 05:48:51 UTC
Hello,

Everyone's got one, yet I decided to make one of my own google spreadsheet to help me in manufacturing decisions.

https://docs.google.com/spreadsheets/d/1j3lC9-bLo-DvttRMcwk80FtLuoidpYBK5oungBcOTYU/edit?usp=sharing

Feature:

  • Imports Corp. blueprints
  • select the hub you are getting the raw materials from
  • choose whether you are buying the raw materials from the sell orders or from the buy orders
  • select the system you are going to run your job
  • select the trade hub for selling the product
  • calculates the materials cost, job cost, and potential profit


All feedback are welcomed.
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2015-11-22 12:14:10 UTC
Seems nice, some things which would be nice which I didn't find, maybe they are there:

1) What if I choose to manufacture the item in a pos/outpost, then I'd like to see a possibility to enter the 2% (or more) mat reduction somewhere
2) I couldn't find a place to enter the number of runs I want to make, this affects material savings a lot
3) # of items sold/day is better (IMO) than # of buy orders in telling whether you will have difficulties selling the product.
4) It should be possible to enter broker fee & sales tax to the equation as they may alter the profit a lot.
5) Ideally one would choose the exact station where one buys/sells + char API and the sheet would calculate the broker's fee automatically.

1), 2) and 4) are a must for any serious business. 3) and 5) are nice to have but something that one can live without.