In this guide, I’ll teach you how to create your own spreadsheet for all your indy needs, anything from T1 frigates to titans and everything in-between. Note that a lot of this you may not understand and I will try to explain everything as simply as I can so both spreadsheet vets and noobs can understand it. This will specifically be for Google sheets as all of my experience is there. I will constantly be referring to a personal spreadsheet with screenshots for a visual explanation as some people learn better that way, I’ll also make a step by step guide for a simple spreadsheet for those that learn by doing. Disclaimer; if it feels as if I’m talking to you like a child, I apologise, I would just like to make everything as clear as I can so everyone is able to do it and learn.

Firstly you will want to open up a brand new google sheet with a plan of what you want to make. You can do this by going to the Google homepage and in the top right corner there are a load of dots, click that and then click on drive as shown below; Note that you will need a Gmail to be able to do this.

This will bring up your drive, from here you can simply click new and select google sheet in the top left. You can start by giving you spreadsheet a name if you wish by double-clicking the current name.

Now that you have a spreadsheet set up and your ready to start making it you're going to want to create a data pool. What I mean by a data pool is something that everything else can refer to when you create your formula’s, for an example the minerals each ore gives or the jita price of each mineral as shown here.

What you do with this data and how you manipulate it determines how easy a spreadsheet is to use or look at and what the outcome will be. As you can see I have the price for each mineral here, and the way I manipulate this will, in turn, show the mineral price of each ship I can build or in other words how much it would cost for me to build the ship if I were to buy the minerals. This can be further manipulated by adding more data.

To pull the data as shown above I use a simple tool from evepraisal.com that I will link here. You simply install it and you can use it as an add on in your google sheets; you can turn this on by going to Add-ons at the top of the sheet and clicking manage add-ons, this will pull up a box and you should see the add-on there, click manage and then ‘use in this document’ as shown below.

This adds a simple formula that will save you hours of frustration and hair pulling and allow you to pull data from evepraisal.com directly, checking the price of anything you want in your spreadsheet… given it’s spelt correctly, the formula is as shown =EVEPRAISAL_ITEM(A1), The cell in the ‘( )’ will hold the name of the item you want the jita price for. For example =EVEPRAISAL_ITEM(A25), and rather than the formula you see here the data you have requested will be shown in the cell you put this in, like so.

Note that pulling too much data from an external source like this will cause unnecessary load times and lag in your spreadsheet, so try to pull only what you need to try not to pull the same thing more than once. You are able to refer back to the same pull as many times as you need.