1

(9 replies, posted in Guides and Resources)

Golden One wrote:
Luraz wrote:

I noticed an error in how it calculates mineral cost on the production sheet.

if you tell the sheet your making an item that takes 1 Isopropentol it should take the current price of HDT and multiple it by the amount of HDT you need to make 1 Isopropentol.

when you do this, your sheet says it will cost you 31 nic even.

my sheet tells me its 33.28


I used 52 HDT per Isopropentol at a cost of .64 per HDT.

52 * .64 = 33.28

I think your sheet is rounding down each calculation it needs to compute the mineral cost.

so unless I'm missing something this isn't intended.

I put in .64 for the cost of HDT and 50/52=0.9615 as your refining ratio and I get an estimated cost of 34 NIC.

34 instead of 33.28 is indeed a rounding error.  I could have carried more precision, but I went with neatness instead.


ah ok, i was using 1.04 as my refining ratio.

2

(9 replies, posted in Guides and Resources)

Good sheet. Its obvious you spent a lot of time on it.

I use my own excel sheet for my production but tonight I decided to use yours as well to get some data my sheet doesnt have currently.

I noticed an error in how it calculates mineral cost on the production sheet.

if you tell the sheet your making an item that takes 1 Isopropentol it should take the current price of HDT and multiple it by the amount of HDT you need to make 1 Isopropentol.

when you do this, your sheet says it will cost you 31 nic even.

my sheet tells me its 33.28


I used 52 HDT per Isopropentol at a cost of .64 per HDT.

52 * .64 = 33.28

I think your sheet is rounding down each calculation it needs to compute the mineral cost.

so unless I'm missing something this isn't intended.