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.
 

need help with pi spreadsheet
Author
Previous Topic Next Topic
loard doktor
tradersbear
#1 - 2012-08-10 04:21:33 UTC
Ive tried to find a spreadsheet that does what I want, but cant find it, so im trying to make my own. Im using open office, but im a noob at spreadsheets. I thought id ask for some help for this.

First off, Ive been trying to find some place that will tell me how much you need of each level to produce the items for the next level and how much you get.

If I remember correctly (I tried this game last year but my ONBOARD video card wasnt good enough and I had to wait until I could get a video card that could handle it (yes onboard vids cards always suck)), it takes 3000 t0 things to get 20 t1's. after that my memory gets a big foggy.

The next thing Im trying to find out is if Im doing it right. What im setting up is the initial reading will have all t0's stuff bought, then remove the ones I want to gather. This will give me a better idea of the true value of each area and how much I can make on each one.

So heres the set up Im looking at. Would you take the t0 and multiply it times 3000 then devide it by the 20 items for the t1 to see the value of the t1? In this area is there a way in open office to set a column to have a formula rather than having to do it for all 100 lines?

After this, what would be the numbers needed to caluclate the prices of higher tier items?

Thanks for the help.
Nebu Retski
Lead Farmers
#2 - 2012-08-10 08:33:45 UTC
Check out Planetary Commodities on the uniwiki.
3000 t0 = 20 t1 => t1 = (3000/20) t0 (simple math it's not that hard Roll)

To add a formula into a spreadsheet -> start the content of a cell with =
For example, lets put the buy price of t0 item into cell A1 and the sell price into cell B1.
=B1-(3000/20)*A1 <- put that into cell C1
C1 will now contain what the profit of producing t1 from t0 is. Basically (3000/20)*A1 gives you the value of the t1 based on the price you paid for the t0. This is not including POCO taxes nor does it include sales taxes and broker fees. For that you will need to adjust the formula I gave you accordingly.

I suggest you read up a bit on PI on the uniwiki and brush up on your math before you actually start doing because if it's really that hard for you to figure out how to calculate the value of your t1 products then you're gonna be in a world of pain if you move up actually profitable endeavours.
Rengerel en Distel
#3 - 2012-08-10 11:20:40 UTC
https://forums.eveonline.com/default.aspx?g=posts&t=141962&find=unread

don't feel like relinking everything, so maybe just read the other thread still on the first page ...

With the increase in shiptoasting, the Report timer needs to be shortened.
loard doktor
tradersbear
#4 - 2012-08-10 13:58:26 UTC
thanks for the help