Ronix Aideron
Ronix Aideron

New and not so new players like to ask the following questions:

  • How do I make ISK in industry, the market or activity X?
  • Does activity X make more or less money for the effort than Y?

The short answer is that there is no magic activity that everyone knows about that will make you wealthy in Eve. The long answer is ‘information’ is how you know if you will make money doing activity X in the game.  One of the best tools for showing information is using a spreadsheet. Organizing the information so you can understand what activities can make money is the purpose of the rest of this post.

Fundamentally spreadsheets are no different than using EFT or PYFA. These tools allow you to test fitting up a ship to see if it will ‘on paper’ fill the need you are looking for or test a theory. You don’t have to log into SISI or buy and loose dozens of ships in a fire before landing on a good fit.

gdocsGoogleDocs and Office Online allow you to theory craft activities within the game.  It can keep you from having to spend hours spending ISK and moving assets around to find out an activity is not profitable. The spreadsheet allows you to display a lot of information easily, and with formulas you can apply tests. These tests allow you to manipulate the information which allows you to make decisions. This information allows you to understand what skills/activities can make you a certain amount of ISK.

Questions these rules can allow you to answer:

  • Can making a specific item be profitable?
  • What cost reductions in the chain make the most impact?
  •  Can you scale up your activities and make exponentially more ISK?
  • How much volume do you need to achieve to make back your investment?

697Trigger Warning Spreadsheets in Space Follows!!!!

The main functions with this demonstration are created by Steve Ronuken. He shares his tools for free to the Eve community and the tools he has developed are straight-forward and powerful. Being able to re-use code gives non-developers like myself a leg up.  We can focus our time on how to use the information rather than trying to figure out the methods for gathering the information.

This is another reason why the community for Eve is so powerful.  Usually there is a team of people already working on a solution to a problem you are running into.  It is just a matter of finding that group within the community that can help you with a solution.

The example in this post walks you through how to pull market information into your Google Spreadsheet.  The market data is not real-time and uses the Eve-Central marketdata service. This is as an alternative to browsing the market within the game and manually entering the values into various cells. The formula allows you to look at a far larger number of items and locations than manually piloting around the universe. Below is the URL to a demo spreadsheet that I created using  Google Scripts function that Steve Ronuken wrote:

docs-icon1https://docs.google.com/spreadsheets/d/1GRlwfEbK5L3jyFUqLGG90njVOxuqJMQLfjPe_8Z4fz4/edit#gid=0

If you click on the tools menu and select Script Editor you will see the function. There is information within the comments on how to use the function in other ways and a link to a spreadsheet that Steve Ronuken created. The demonstration spreadsheet relies on three worksheets:

  • TypeID – This is a list of Item Names and the TypeID within Eve.  Anything that you want to lookup a price for needs to be in this list.  There is no specific order needed.
  • You can lookup the TypeID by going to the following URL: https://www.fuzzwork.co.uk/tools/api-typename-to-typeid/
  • ItemPrice – This is a worksheet that uses the function in the GoogleScript to lookup the various volume and pricing information in Jita for anything listed in the TypeID worksheet.
  • Demo – Where the magic is summarized and organized

The Demo worksheet has a couple of use cases for market information. The top example is a fairly complex manufacturing chain for creating a Synth Blue Pill Combat Booster and the second is a station trading example for two ship hulls.

Being able to leverage market data from eve-central allows the spreadsheet to stay ‘current’ with market trends.

isk

Using the manufacturing chain as an example you can see that potential gross for Synth Blue Pill is 170,000 ISK. This could be an activity that could merit further exploration.  In the lower right of the example you can see that running full time you will make 672 boosters a month which is a gross of 114,800,000 ISK which does appear even more promising.  We know that we need a POS to make combat boosters.  A month of fuel for a medium POS (the smallest needed to run reactions and a drug lab) is ~222,000,000 ISK per month.  That means you would loose money if all you did in one month is make Blue Pills.  This is not to say combat booster manufacturing is not profitable it just an example of how you can use market data to understand the costs associated with an activity.  You could work more numbers to see if another product is better or if you are profitable at a different scale.

The second example is straight forward.  How much is the margin for station trading ships at Jita.  I listed just the gross since you have to factor fees and taxes but, the formulas for doing so are public knowledge and very easy to enter into the spreadsheet.  This analysis can be extended by looking at the comments within the function.  The default system for the function is Jita. By passing the system and station information you can easily create a separate worksheet that has Dodixie or even a staging system and then do comparisons of buy and sell orders between systems.  Is someone offering a Jump Freighter service for your alliance or corp?  You can now use that to move profitable products into staging for a tidy sum and fill a need.

Do not fear the spreadsheet.  It is a tool just like many others used within the game.  Being able to use the tool will help you answer the questions that you have.

Steve Ronuken information:

https://www.fuzzwork.co.uk

The post that got me to be able to import data into GoogleSheets.

https://www.fuzzwork.co.uk/2014/09/12/google-docs-xml-api-nightmare-importxml/

Steve Ronuken’s Demo page.

https://docs.google.com/spreadsheets/d/1f9-4cb4Tx64Do-xmHhELSwZGahZ2mTTkV7mKDBRPrrY/edit?usp=sharing

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s