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.
 

T2 Manufacturing spreadsheet (with components)

First post
Author
Previous Topic Next Topic
Nalha Saldana
Aliastra
Gallente Federation
#1 - 2015-03-10 13:49:30 UTC
Over some time I've been working on this spreadsheet that can calculate the profit of t2 production. With the discovery of fuzzworks api i can now calculate all component manufacturing without having to write in like a hundred numbers which made it so much better.

Example Cheetah production:
Cheetah spreadsheet (google docs)

Example Vargur production:
Vargur spreadsheet (google docs)

Empty base version for your own calculations, always start with this one or its easy to mess up your inputs:
Empty t2 production sheet (google docs)

Unfortunently i havent found a way to import manufacturing or science times and the products output count (like 100 per R.A.M. or ammo) into a spreadsheet so those will have to be put in manually for now.

Have any suggestions?
Is it too difficult to understand something?
Are any numbers incorrect? They should all be 100% correct if you put in the right numbers.
Charlie Nonoke
Blue Republic
RvB - BLUE Republic
#2 - 2015-03-10 23:30:44 UTC  |  Edited by: Charlie Nonoke
For industry times, get the industryActivity.xls or .sql entries from Steve's website.
https://www.fuzzwork.co.uk/dump/
Choose the latest expansion, which is the tiamat subfolder.

You'll see your blueprint, its typeID, and then the time for the activity type.
Type 1 is manufacturing, and 8 is invention.
Times are base, and you need to apply skill reductions.


I would also have a sheet purely on api pulls so you can gather as many items as you can, and do the relevant vlookup on your main page.

It seems you need one entire spreadsheet for just ONE item based on your method.
What if you wanted to find out which T2 item is profitable this week, or the next month?
You can totally make a universal sheet, and have every single T2 inventable in a list there. It's possible, and I have made something similar to that.

Just some constructive criticism for you. =p
Nalha Saldana
Aliastra
Gallente Federation
#3 - 2015-03-11 06:30:23 UTC
Charlie Nonoke wrote:
For industry times, get the industryActivity.xls or .sql entries from Steve's website.
https://www.fuzzwork.co.uk/dump/
Choose the latest expansion, which is the tiamat subfolder.

You'll see your blueprint, its typeID, and then the time for the activity type.
Type 1 is manufacturing, and 8 is invention.
Times are base, and you need to apply skill reductions.


I would also have a sheet purely on api pulls so you can gather as many items as you can, and do the relevant vlookup on your main page.

It seems you need one entire spreadsheet for just ONE item based on your method.
What if you wanted to find out which T2 item is profitable this week, or the next month?
You can totally make a universal sheet, and have every single T2 inventable in a list there. It's possible, and I have made something similar to that.

Just some constructive criticism for you. =p


Thanks for some great ideas, I just have a few problems.

I cant add industryActivity.xls.bz2 to my spreadsheet without having it locally on my computer can i? All my info is based of xml's that are web based and are always updated by respective owner, is there any way to get this info wihtout downloading files to link up?

I have no idea how to design a sheet like that tbh but I'm working on a Java program that does it way better.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-03-11 13:08:28 UTC
https://www.fuzzwork.co.uk/dump/latest/ is always pointing at the latest version Smile

Yes, you'd need to download the sheet, unzip it (bzip2 would work) then import it into google docs.


For a java version, I'd suggest the sqlite db. You may want to hack it down in size though, if you don't need things like universe data, or the translation tables.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter