Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
S'totan
Impen Reloaded xXPlease Pandemic Citizens Reloaded Alliance.Xx
34
|
Posted - 2013.07.21 13:01:00 -
[1] - Quote
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 and a drop down menu for the T2 item and corresponding T1 item.
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
Impen Reloaded xXPlease Pandemic Citizens Reloaded Alliance.Xx
34
|
Posted - 2013.07.21 15:08:00 -
[2] - Quote
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
Middle Eastern Oil Conglomerate
0
|
Posted - 2013.07.21 18:03:00 -
[3] - Quote
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
Black Rebel Rifter Club The Devil's Tattoo
2
|
Posted - 2013.07.21 20:48:00 -
[4] - Quote
You do know that you can call more than one item in an XML call? |
S'totan
Impen Reloaded xXPlease Pandemic Citizens Reloaded Alliance.Xx
34
|
Posted - 2013.07.22 02:04:00 -
[5] - Quote
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? |
Rutger Janssen
Xanadu
95
|
Posted - 2013.07.22 08:31:00 -
[6] - Quote
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®ionlimit=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®ionlimit=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. |
S'totan
Impen Reloaded xXPlease Pandemic Citizens Reloaded Alliance.Xx
34
|
Posted - 2013.07.23 11:50:00 -
[7] - Quote
=importXml("http://api.eve-central.com/api/marketstat?&typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40®ionlimit=10000002","//sell/min")
This formula only pulls the first typeid in the specific block i put it in. |
Rutger Janssen
Xanadu
95
|
Posted - 2013.07.23 12:10:00 -
[8] - Quote
select the cell and press ctrl+shift+e |
S'totan
Impen Reloaded xXPlease Pandemic Citizens Reloaded Alliance.Xx
34
|
Posted - 2013.07.23 12:22:00 -
[9] - Quote
That is awesome. you are amazing in my book starting right now. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |