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.
 

Compressed Ore to mineral spreadsheet help.
Author
Previous Topic Next Topic
Dawn Kugisa
Doomheim
#1 - 2016-05-08 09:03:38 UTC
I'm not sure what I'm doing wrong really , I'm trying to replicate the numbers I get in IPH but seem to be a 100-200isk off each time so not sure where I'm going wrong.

The spreadsheet is a simple formula so I assume I'm just missing something but say for Ark I would use .

=(sum(22000 trit*trit price ) + (2500 mex*mex price) + (320mega*mega price) ) /100 to get 1 raw Ark

I get like 5884 isk per unit with excel and 5691 @ 83.5 refine so not sure what the difference is as I've manually updated IPH to use the same min prices.

Otherwise if someone has one they would like to share that would be great too , it's for selling compressed ore but getting the mineral price for it not the compressed ore price which doesn't seem like it would be hard to do or find but I'm not having much luck.

Thanks.
Haffsol
#2 - 2016-05-08 09:46:51 UTC
Dawn Kugisa wrote:
=(sum(22000 trit*trit price ) + (2500 mex*mex price) + (320mega*mega price) ) /100 to get 1 raw Ark

Should be

=sum((22000 trit*trit price ) + (2500 mex*mex price) + (320mega*mega price) ) /100 to get 1 raw Ark :p

That's about the formula. As for what you want you should be more specific. I personally built my ss in a way that I input the blocks, edit a field with the yield and see minerals in the output. Doing the other way around (input minerals and have ores/blocks as output) can be quite trickier.
Dawn Kugisa
Doomheim
#3 - 2016-05-08 20:26:32 UTC
Yeah maybe I'll try your way , makes more sense . Basically want a spreadsheet that I can plunk compressed ore amounts in to and get the mineral value out of it at X refine rate.

Thanks for the help much appreciated.
Haffsol
#4 - 2016-05-08 22:56:35 UTC
In that case you son't need the "sum", it's a normal sum. As in

((a1*b1)+(a2*b2)+...(an*bn))*c1

where c1 is the field where you enter the yield and a and b are the ores and respective minerals amounts, pretty much as you did in your example above. Easier to do it than to explain it.