Currently, i have one spreadsheet for my trader in Dodixie which has the price of an item to sell in Dodoxie and the price of that item selling in Jita, and compares the two to see the profit, as shown below:
In the above table i am able to sell the Amarr Fuel Block Blueprint for 12.5m ISK in Dodixie and it sells for 12.0m ISK in Jita, allowing me to make a profit before fees / taxes / hauling costs of 500k ISK, or a margin of 4% - not very good. The Arbitrator Blueprint though is much better . . . . . but sells very slowly! And the spreadsheet goes on for many rows and there is another one for Hek.
As an aside, i also have a column indicating how many items trade each day.
The spreadsheet allows me to input the number to buy in Jita and so calculates the cost of my purchases and the expected profits to be made after all costs. Another part of the spreadsheet then calculates the hauling cost and so showing me my total expected profits - most recent summary is below:
The items on each spreadsheet are also on my quickbars.
Up until now i would manually type in all the Dodixie/Hek and Jita prices for items that i had completely sold out of in Dodixie/Hek - which was somewhat boring.
I was aware that Eve-Central could display the data but i was not sure how to access this on my spreadsheets (Excel 2007).
The data on Eve-central is only as good as the players contributing - so i suspect very timely and accurate for Jita but perhaps not as good elsewhere. I don't know if the data will be timely enough to get accurate prices for Dodixie and Hek.
But now my eyes have been opened to getting the Jita prices at least onto my spreadsheet.
One of Steve's posts goes through importing XML data to allow Jita prices from Eve-Central to appear on my spreadsheet (at least that is what i think i happening). Steve provides an example spreadsheet which i used and added to.
Hence, i now only have to update my prices for Dodixie and Hek - a big time saving on my daily routine! The Jita prices now come automatically from Eve-Central to my spreadsheets.
And the Jita data has also been added to my manufacturing spreadsheets.