The EvE Online Production Calculator spreadsheet is designed to give you a helping hand when producing items in the EvE universe.
It gives you a quick overview of materials required, production cost and expected profit.

I play EvE in windowed mode so I can easily interact with my Desktop while the game is running. I installed Power Menu to give MS Windows the ability to keep a window "Always on top".

<MicrosoftRantOfTheDay>Kind of ridicules that Windows does not have an option to keep "a window always on top" but I guess it is more important to add useless fluff to an operating system instead of productivity enhancing features.</MicrosoftRantOfTheDay>

Anyway, the screenshot below gives you an idea how I use my spreadsheet, because I run in windowed mode I can use the EvE interface and my spreadsheet at the same time.


I will explain how to use the spreadsheet by calculating the production cost and profit of a "Scourge heavy missile"
The scourge heavy missile blueprint provides me with the following information which I enter into the spreadsheet.

• Units produced per run 100
• Production time per run: 3minutes 38 seconds. Enter this in HH:MM:SS format like 0:3:38
• Resources required per run 2x Nocxium and 813x Tritanium

Next enter the current market price for the resources required to produce the item.
Nocxium is currently sold for 69.68 ISK per unit and Tritanium for 4.10 ISK per unit.
Hint: You can right click on the resource name inside the blue print window and select "View Market Details".

Almost done, the Factory Installation Cost and Factory Cost per Hour can be found on the page where you select the assembly line. Your sales TAX and broker fee can be found in your wallet under "Orders".
Keep in mind that these values are BEFORE your skill is applied and the actual values will slightly differ. I contacted CCP and asked them for the exact formula used to calculate the discount but I have not heard back from them.
I know it somehow applies your standing to the cost but I am not sure how it is done.
This is not a big deal because the quote generated by the spreadsheet will be off by a few ISK in your favor. You can use the "Adjust Cost" field to enter the difference between the quote generated by EvE and the spreadsheet to get an exact quote.

The last bit of information required is the amount of units you intend to produce and your estimated sales price. I am going to produce 20000 Units and will attempt to sell them for at least 44.50 ISK per unit.

After entering the above information the spreadsheet will calculate my resources required, resource volume in m³, estimated production time, production cost, profit and production runs. Production runs is an important number because 1 production run of scourge missiles will produce 100 missiles. So this value tells me that I need to set my production run value to 200 for the factory to make 20000 units of scourge missiles.

Notes:

• The field next to Sales Tax will display the calculated TAX value in ISK based on the TAX value entered in percent.It does not take skill into the equation because the formula used is unknown to me
• The field next to Broker Fee will display the calculated fee in ISK based on the fee value entered. It does not take skill into the equation because the formula used is unknown to me
• The "Adjust Cost" field can be used to adjust the total production cost up or down. This is useful if you purchase resources from multiple merchants for a different cost per unit and/or if you would like to adjust the calculated TAX and broker fee.
  For Example: If the "Production Cost" value calculated by the spreadsheet is 1500ISK higher then the value generated by EvE you would enter -1500 into the "Adjust Cost" field. The value entered is then applied to the cost and profit calculations
• Please use the Contac link in the main menu to report any issues or if you happen to know the factory cost formula

Download
This file requires OpenOffice, the Free and Open Productivity Suite. Download here

EvE Online Production Calculator Spreadsheet

Almost forgot ... ISK donations accepted by Ion Dex

 

No Comments yet .....