Theo Ramone
School of Applied Knowledge Caldari State
0
|
Posted - 2012.08.15 20:01:00 -
[1] - Quote
A bit of an open ended question here I realize. let me briefly describe my goal, my methods thus far (Which have ultimately failed) and perhaps someone can get me headed in the right direction.
Without getting into the nuts and bolts, I want to create a spreadsheet listing a few price metrics for lots of items. Lets say that I have the ability to manufacture 1000 ammo types. I want a sheet that has the following columns....
Ore price, for all ores. Preferably across 4 major hubs as well as sell min and sell median. Ammo prices, preferably across 4 hubs, sell min/ave as well as buy max/median.
Then a few little easy calcs in the cells to figure out whats going to be the best ammo to make for any given time.
Heres where I encounter troubles.
If I use Excel I dont know how to bulk import lots of information. The only way I know to do an import xml is to actually go through the process of creating an importxml function for every item id, then drag the results I desire into the cell I wish to display it in. This is all done through the steps laid out in the second post here. http://community.eveonline.com/ingameboard.asp?a=topic&threadID=1512263
While this is a great approach for a small set of items, the thought of setting up these queries hundreds or even thousands of times makes me feel a bit ill and begin wondering if I can suck start my shotgun.
On to Google Docs. I try an =importxml statement and it works wonderfully. I try an importxml with mutiple type ids, again no major problems until I reach roughly 25-30 typeid's in the import query statement. At that point it simply fails, with an "Error: Data temporarily unavailable" error. Google Docs is limited to 50 imports so 50*25 = 1250. Thats a fair amount under what I would like to perform.
So my first question is is there anything wrong in my methods, such that can I bump Google Docs to pull the data when an import statement has hundreds of thousands of typeid's in it? Also, is there a way to bulk build the imports in Excel without having to manually step through the importxml process for every item ID? If I could just type in the =importxml statement into an Excel cell and have it function as it does with Google Docs that would be ideal.
And my second question is provided there is no solution with Google Docs or Excel from above, what other methods or approaches should I be using to accomplish this?
tl;dr: Theo is learning data manipulation via importxml, and needs help.
Thanks for reading, I know its long! |