So I’ve got my Google spreadsheet set up pulling data from eve-central .com. Now I realise that this tool is not as elegant as it could be but it’s used mainly to look at trends in the market an overview of what is profitable and what is marginal. So if you read back i did a post about the making of POS fuels. Good your back, happy with what i covered in the previous post(s). Obviously I could set out my spreadsheet to do all the work for me.
|Fuels||BPO ME 40||Jita Price||Build Cost 1 unit||Profit Loss|
I could have the spreadsheet in a neater format by just pulling all the information I needed from my main data of raw materials on my first page. But this was more to show you of what I did. What I did is hidden behind the numbers…..
So working out my build cost =((M2*L2)+(L3*M3)+(M4*L4)+(M5*L5)+(M6*L6)+(M11*L11)+(M12*L12)+(M7*L7))/40
If L is the BPO ME 40 column and Jita price is M, it’s really simple to just multiply the two together and then divide by 40 to get the cost of one block of fuel.
You can expand the sheet to meet your needs for example you could factor in the Tech II BPC costs in manufacturing from your invention skills etc. Set it up so at a glance you could see what decryptors make the most money on ship invention.
I Hope you find this rough guide useful.
See you on the other…….