EVE Technology Lab

Hey there,

My spreadsheet setup is fairly simple:

- I Imported a recent list with item names and their respective typeIDs to one tab (or "sheet"), just for reference.

- I customized fuzzysteve's script, removing a few lines to limit the data it pulls from eve-central (I wanted only buy max, sell min, and their respective volumes). Didn't mess up with anything other than that.

- On another tab (let's call it the "Prices" tab), I created a list of relevant, handpicked typeIDs, all in the same column, all copy/pasted from the first tab.

- I Entered the "loadSystemPrices" function in a cell on the Prices tab, indicating the correct range of rows of the typeID column.

That was working well, showing me the prices and volume of the items I wanted. But as I increased the amount of typeIDs it simply stopped filling all the rows/cells. In my case, it was working alright for exactly 454 items. Now I have 455 rows of typeIDs, but the function will only cover up to the 454th item.

No matter what typeID or how many typeIDs I add after that, the function will only bring me data up to row 454. I'm fairly noob at this, and finding that custom script was a godsend after weeks struggling to find a workaround for importXML. But to be honest I really want to expand the list – 454 items are too few among the thousands of EVE's items.

So I have a few questions:

- Is there a way to fix that? How?

- Did I hit a "maximum number" of typeIDs/rows, limited by either the function or eve-central?

One last thing, I actually have 3 cells running the loadSystemPrices function: one for Jita ("=loadSystemPrices(D3:D458)"), one for Amarr ("=loadSystemPrices(D3:D458,30002187)") and one for Dodixie ("=loadSystemPrices(D3:D458,30002659)"). That would "triple" the number of values returned, but oddly enough even if I delete one of them (in the hopes of freeing "typeID space", if that makes any sense heh), the first function still won't go past 454 rows.

Also, I tried a noobish, rubberband workaround by repeating the function on the cell where it stopped working, in order to try and "extend" the number of rows. It didn't work, and gave me this error message:

"ERROR TypeError: Cannot find function forEach in object 24531. (line 15)."

Any help with this would be apreciated. Thanks a lot o7

Feng

*edit: got the Jita function cell range right to avoid confusion