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.
 

Trying to build industry spreadsheet, refresh failure?

Author
Lister Vindaloo
5 Tons of Flax
#1 - 2015-04-30 01:46:55 UTC
HI
I spent last night putting together a spreadsheet to get market data and calculate profits in Jita, Amarr and Dodi, im using excel and i am using:

http://api.eve-marketdata.com/api/item_prices2.xml?

char_name=demo&type_ids=30311,30310,30303,30309,30308,34,38,39,40,30375,30376,30370,30371,30373,30374

,30377,30378&solarsystem_ids=30000142,30002659,30002187&buysell=b

To get the data table, which i have loaded into the second sheet, my first sheet then draws price information from this table and does the calculations.

The table loads fine the first time, but when i click on the refresh to update the data i get an error

'The following data range failed to refresh:emd_Map'

if i click on continue to refresh all, i get the same error except it increments to :emd_Map1, and so on until it reaches emd_Map5 after which it stops and gives me the errors, 'No elements mapped' and 'No data was imported or only some of the data was imported'

Could anyone suggest what i am doing wrong?

This is my first attempt at using imported data in a spreadsheet, so im hoping it's a simple rookie error