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.
 

Nalha Saldana's Spreadsheet Emporium
Author
Previous Topic Next Topic
Nalha Saldana
Aliastra
Gallente Federation
#1 - 2012-11-22 12:18:42 UTC  |  Edited by: Nalha Saldana
When I started playing EVE for the first time it didnt take long before i made my first real spreadsheet ever.
Since then I've come a long way and now i make spreadsheets for anything I need organizing and I do this way better than back then.

Here are a few examples of sheets i made:

Mining OP organization - Communist style
https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdGR5MUJQcGkySThUWHJjTDJqTGFuckE

Trading efforts tracker (manual) - with automated corp wallet import on tab 2
https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdFYwOVU5eFZmZ3B2Wmh0YXVNTDFiY2c

Implant costs - Lists all available implants that boost your ability to fly ship and their costs
https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdGV0U3RUdWVzMFFtV0c2N3c4cG9SN0E

Booster Drugs infosheet - including prices, skills and side effects
https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdFdNUTRfMUdTTlNNU0hzQnhzV0dQWXc

Reaction spreadsheet - Shows profits of reactions in POSes, including moon mining.
https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdHJQSGNtMzk1bmpwOFZZZkdXOU53OGc

PI profit calculator - Shows how much you could make from PI depending on what planets you have available. Also lets you plan how to most efficiently set up your planets in the 2nd tab.
https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdFpUempHRXFKOFVhZGpPdHMxc3g0bmc

Feel free to copy these or parts of them, if you have any questions or want help with your spreadsheet ask away and I'll try to help as best as I can.

Want me to make you a spreadsheet for whatever purpose? Contact me ingame and we can discuss what you need and what it would cost, I'm not that expensive.
Cap James Tkirk
Baba Yagas
The Initiative.
#2 - 2012-11-22 18:15:37 UTC
thanks
Belvac
#3 - 2013-01-07 21:25:30 UTC
Hi,

On the Tracker spreadsheet, on the Automatic sheet how do I get the spreadsheet to download my orders and not the Corps orders?

Really great work by the way...If only I had the power of the spreadsheets, it would make my life in Eve that wee bit easier :)

Thanks in advance o/
Sidrat Flush
School of Applied Knowledge
#4 - 2013-01-07 21:59:26 UTC  |  Edited by: Sidrat Flush
Belvac wrote:
Hi,

On the Tracker spreadsheet, on the Automatic sheet how do I get the spreadsheet to download my orders and not the Corps orders?

Really great work by the way...If only I had the power of the spreadsheets, it would make my life in Eve that wee bit easier :)

Thanks in advance o/


You might want to try the link in my signature

Its time to stand up against the bad empire based CEO telling falsehoods about what new characters can accomplish and pushing them towards an in game experience of drudgery and loneliness keeping them in the shadow of ignorance for at nest their own profit at worse apathy towards all the experiences that Eve has to offer.
Belvac
#5 - 2013-01-07 22:19:11 UTC
Sorted...Friend of mine tweaked the sheet for me!
As for the links Sidrat Flush I'll take a look mate..Thanks for the support Big smile
Nalha Saldana
Aliastra
Gallente Federation
#6 - 2013-01-08 08:33:09 UTC
Belvac wrote:
Hi,

On the Tracker spreadsheet, on the Automatic sheet how do I get the spreadsheet to download my orders and not the Corps orders?

Really great work by the way...If only I had the power of the spreadsheets, it would make my life in Eve that wee bit easier :)

Thanks in advance o/



https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdHUwYjVnXzVoay1RZm5hMXRQRXY0aHc
Here is a sheet for personal API's, only works if the API Character: setting is set to a specific character and not ALL.
Rutger Janssen
Chanuur
The Initiative.
#7 - 2013-01-08 11:05:02 UTC  |  Edited by: Rutger Janssen
The reaction sheet is broke, the prices aren't fetch properly. Edit:nvm seems to be fixed

What I like to do with prices, is fetch them all on a seperate sheet and use offset/HLookup to look up the price where I need. That way you can have multiple columns with different pricing and with a dropdown I can select which of the prices to use.
Nalha Saldana
Aliastra
Gallente Federation
#8 - 2013-01-09 12:37:00 UTC
Rutger Janssen wrote:
The reaction sheet is broke, the prices aren't fetch properly. Edit:nvm seems to be fixed

What I like to do with prices, is fetch them all on a seperate sheet and use offset/HLookup to look up the price where I need. That way you can have multiple columns with different pricing and with a dropdown I can select which of the prices to use.


Yea sometimes there are minor issues from evecentral that breaks some prices, usually fixes itself in a few minutes.

Hmm good idea, i will experiment with it,
Annunaki soldier
Perkone
Caldari State
#9 - 2013-01-10 13:27:24 UTC
thanks was looking something for reaction and your's suited me perfect. (too noob to create my own need lessons for it Ugh )

Ride hard, live with passion 
Nalha Saldana
Aliastra
Gallente Federation
#10 - 2013-01-29 01:16:52 UTC  |  Edited by: Nalha Saldana
Created a new PI spreadsheet that needs beta testing, please try it out and tell me what you think!

https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdFpUempHRXFKOFVhZGpPdHMxc3g0bmc

You can use "file -> make a copy" to edit any numbers.

Edit: just realized i forgot taxes, I will add that in the next release.
Annunaki soldier
Perkone
Caldari State
#11 - 2013-01-29 01:40:33 UTC
yes you did. Looks good. I would love to see that the taxes can be edited to suit our pocos and if possible colour the highest profit

edit : Thanks for releasing them

Ride hard, live with passion 
Nalha Saldana
Aliastra
Gallente Federation
#12 - 2013-01-29 13:31:41 UTC
Annunaki soldier wrote:
yes you did. Looks good. I would love to see that the taxes can be edited to suit our pocos and if possible colour the highest profit

edit : Thanks for releasing them


Added taxes with a single Tax input that determines everything.

I cant color the highest one but it now tells you which one it is below the lists.
Nalha Saldana
Aliastra
Gallente Federation
#13 - 2013-01-30 00:43:32 UTC
Nalha Saldana wrote:
Created a new PI spreadsheet that needs beta testing, please try it out and tell me what you think!

https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdFpUempHRXFKOFVhZGpPdHMxc3g0bmc

You can use "file -> make a copy" to edit any numbers.

Edit: just realized i forgot taxes, I will add that in the next release.


Added a new tab that lets you plan planet setups and find the data you need to input in the main page.
It could be hard to understand for someone new to spreadsheets but its worth learning, its great imo.
Annunaki soldier
Perkone
Caldari State
#14 - 2013-01-30 11:12:24 UTC
thanks again.

Ride hard, live with passion 
Nalha Saldana
Aliastra
Gallente Federation
#15 - 2013-02-02 00:12:09 UTC
Nalha Saldana wrote:
Created a new PI spreadsheet that needs beta testing, please try it out and tell me what you think!

https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdFpUempHRXFKOFVhZGpPdHMxc3g0bmc

You can use "file -> make a copy" to edit any numbers.

Edit: just realized i forgot taxes, I will add that in the next release.


Now supports decimal number inputs in the Setup Planner.