These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Some More Google Spreadsheet Help

Author
Jeremy Kamira
#1 - 2014-12-24 06:05:59 UTC
Gotta run so il make this short. I am still learning some of the formatting for spreadsheets so im sorry if this is a nooby question

Here is my current formula

=ImportXML("https://api.eveonline.com/char/charactersheet.xml.aspx?vcode="&API!B5&"&keyid="&API!B4&"&characterid="&Basilisk!B4&"","eveapi/result/rowset//row[@typeid=3306]/@level")

This takes my API key that is stored on other pages, and finds the current level of the type ID of 3306, which is Medium energy Turret. What i want this to do is reference a cell for the type id instead of typing it in. I guessed and tried

rowset//row[typeid="&B1&"]/@level")
rowset//row[typeid="B1"]/@level")
rowset//row[typeid=&B1&]/@level")

I was thinking that i might have to do a "join" thing, i am not that familiar with it yet. If it indeed this, could somebody give me a hand?
quikfingrs
Salamander Researches And Industries
#2 - 2014-12-24 10:03:53 UTC  |  Edited by: quikfingrs
Jeremy Kamira wrote:
Gotta run so il make this short. I am still learning some of the formatting for spreadsheets so im sorry if this is a nooby question

Here is my current formula

=ImportXML("https://api.eveonline.com/char/charactersheet.xml.aspx?vcode="&API!B5&"&keyid="&API!B4&"&characterid="&Basilisk!B4&"","eveapi/result/rowset//row[@typeid=3306]/@level")

This takes my API key that is stored on other pages, and finds the current level of the type ID of 3306, which is Medium energy Turret. What i want this to do is reference a cell for the type id instead of typing it in. I guessed and tried

rowset//row[typeid="&B1&"]/@level")
rowset//row[typeid="B1"]/@level")
rowset//row[typeid=&B1&]/@level")

I was thinking that i might have to do a "join" thing, i am not that familiar with it yet. If it indeed this, could somebody give me a hand?




=ImportXML("http://api.eve-central.com/api/marketstat?&v="&JOIN(",",$D5:$D159); "/sell/min")

something like that :)

the d column would be full of all the item ids only, but at the moment eve central is not working and hasnt bene fo rhte last 24 hrs solid :(,

yopu can use http://api.eve-marketdata.com and get the formula from hter ebut the market data is a day old so not really good for uptodate manufacturing costs :(, also steves eve-central google docs script works ace but is only region wide prices so if lookign for a specific station/system it wont work, aparantly you can pull the same data of crest or you can get uptodate market info of it aswel but u need to get a auth crest thingy wich i havent a clue what to do there sorry :( trying to work that one out at the mo myself
Jeremy Kamira
#3 - 2014-12-24 20:03:19 UTC
quikfingrs wrote:
Jeremy Kamira wrote:
Gotta run so il make this short. I am still learning some of the formatting for spreadsheets so im sorry if this is a nooby question

Here is my current formula

=ImportXML("https://api.eveonline.com/char/charactersheet.xml.aspx?vcode="&API!B5&"&keyid="&API!B4&"&characterid="&Basilisk!B4&"","eveapi/result/rowset//row[@typeid=3306]/@level")

This takes my API key that is stored on other pages, and finds the current level of the type ID of 3306, which is Medium energy Turret. What i want this to do is reference a cell for the type id instead of typing it in. I guessed and tried

rowset//row[typeid="&B1&"]/@level")
rowset//row[typeid="B1"]/@level")
rowset//row[typeid=&B1&]/@level")

I was thinking that i might have to do a "join" thing, i am not that familiar with it yet. If it indeed this, could somebody give me a hand?




=ImportXML("http://api.eve-central.com/api/marketstat?&v="&JOIN(",",$D5:$D159); "/sell/min")

something like that :)

the d column would be full of all the item ids only, but at the moment eve central is not working and hasnt bene fo rhte last 24 hrs solid :(,

yopu can use http://api.eve-marketdata.com and get the formula from hter ebut the market data is a day old so not really good for uptodate manufacturing costs :(, also steves eve-central google docs script works ace but is only region wide prices so if lookign for a specific station/system it wont work, aparantly you can pull the same data of crest or you can get uptodate market info of it aswel but u need to get a auth crest thingy wich i havent a clue what to do there sorry :( trying to work that one out at the mo myself



I'm not really getting what you are meaning.
quikfingrs
Salamander Researches And Industries
#4 - 2014-12-25 13:54:43 UTC
Ok my bad drunk and typing on a i phone, 😆 got mixed up in other posts I had been reading and got confused to what u were actualy asking it seems doh!!!


I take it looking at ure formula.. Ure cross referencing ure char skills to items in ure sheet to see what skill level you have against that item ID ? And instead of manually inputting the item ids you want it to look at a column and come back with skill levels of all times in that column?
Omega Flames
Caldari Provisions
Caldari State
#5 - 2014-12-25 15:11:21 UTC
You may not be able to reference other cells in that particular part of the ImportXML function. One thing you might try is have 2 columns for your skill data. The first pulls a list of typeids and the second a list of levels, then do a VLOOKUP for each typeid/level you wish to use
Jeremy Kamira
#6 - 2014-12-25 16:57:00 UTC
Omega Flames wrote:
You may not be able to reference other cells in that particular part of the ImportXML function. One thing you might try is have 2 columns for your skill data. The first pulls a list of typeids and the second a list of levels, then do a VLOOKUP for each typeid/level you wish to use


That is actually what i just did. Thanks for the help though!