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 PRODUCTION SPREADSHEET!
Author
Previous Topic Next Topic
S'totan
Republic Military School
Minmatar Republic
#1 - 2013-07-21 13:01:14 UTC  |  Edited by: S'totan
HI there Fellow Evedudes.

I am currently building a spreadsheet for T2 production that shows you how much Advanced Moon Material, Minerals, and PI you need to buy based on how many Items/Ships you intend to build.

I would appreciate feedback to help develop this into something that manufacturers such as myself can find useful in the ever so useless information sources that are currently available.

On this sheet the only fields that you need to(have the ability to) interact with is the ME level of the item/ship BPC you are building from, the number of items you wish to build, the price you will sell it at, and a drop down menu for the T2 item and corresponding T1 item. Bascially anything highlighted in Teal is editable.

IF you find this helpful and would like me to add a specific T2 item to the spreadsheet please send me a mail in game.

https://docs.google.com/spreadsheet/ccc?key=0ArEhqXPA-PBndFAwRHNIdE8yVllSSXUzclJkNHNZUlE#gid=2

Enjoy and please leave feedback.

If you have ANY questions about T2 production please evemail me.
S'totan
Republic Military School
Minmatar Republic
#2 - 2013-07-21 15:08:19 UTC
Unfortunately Google docs only lets me import 50 item prices, that it why you have to input the sell price of the item that you want to build.
Mrs MonkeyBoi
Brutor Tribe
Minmatar Republic
#3 - 2013-07-21 18:03:58 UTC
Good idea, but this has already been done. there's tons of programs & spreadsheets publicly available already. I built my own extensive sheets a couple years back just to find this out. Look up a program called "eve isk per hour" That should help you out and save a lot of time and energy on your part. I hope this helps...
laassaalos Kiblos
Koshaku
#4 - 2013-07-21 20:48:37 UTC
You do know that you can call more than one item in an XML call?
S'totan
Republic Military School
Minmatar Republic
#5 - 2013-07-22 02:04:41 UTC  |  Edited by: S'totan
laassaalos Kiblos wrote:
You do know that you can call more than one item in an XML call?


obviously i dont, I never took a class in excel. Care to explain?

This is the formula that i am using to import specific prices
=importXml("http://api.eve-central.com/api/marketstat?&typeid=34&regionlimit=10000002","//sell/min")
Rutger Janssen
Chanuur
The Initiative.
#6 - 2013-07-22 08:31:39 UTC  |  Edited by: Rutger Janssen
S'totan wrote:
laassaalos Kiblos wrote:
You do know that you can call more than one item in an XML call?


obviously i dont, I never took a class in excel. Care to explain?

This is the formula that i am using to import specific prices
=importXml("http://api.eve-central.com/api/marketstat?&typeid=34&regionlimit=10000002","//sell/min")

=importXml("http://api.eve-central.com/api/marketstat?&typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&regionlimit=10000002","//sell/min")

or more dynamically:

=importXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN("&typeid=",$D39:$D53),"//sell/min")
where D39:D53 contain the ids you want. (This is just for Jita)

I even import all prices on 1 page and get the values from there. That way you can import about 100+ items per fetch.

Couple of random things(some of which I did):

- In my opinion, there are enough tools/website that tell you what materials you need. A spreadsheet that gives you requirements for multiple blueprints at the same time is more usefull.
- Make different sheets for different types, separate sheet for PI, t2 components, t1 ships. To keep an overview of the different steps. A seperate summary page can combine the different sheets to a clean list.
- Consider whether you want to support build to stock and/or build to demand.
- Import assets to view stock?
- Write an sql query to get all the data you need from datadumps and just copy/paste the result in a seperate sheet. By taking everything into account from the start, you save a lot of time in long run, but:
- Once you do a lot of processing, things can get slow :(
S'totan
Republic Military School
Minmatar Republic
#7 - 2013-07-23 11:50:32 UTC
=importXml("http://api.eve-central.com/api/marketstat?&typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&regionlimit=10000002","//sell/min")

This formula only pulls the first typeid in the specific block i put it in.
Rutger Janssen
Chanuur
The Initiative.
#8 - 2013-07-23 12:10:14 UTC
select the cell and press ctrl+shift+e
S'totan
Republic Military School
Minmatar Republic
#9 - 2013-07-23 12:22:47 UTC
That is awesome. you are amazing in my book starting right now.