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.