EVE Technology Lab

Hello there fellow capsuleers. I am in need of some help. I am trying to design myself a spreadsheet in Google Docs for my T2 production. But I am terrible with spreadsheets, never worked with one before so im crazy lost.

Anyhow, I want the Type IDs of all my components to be auto imported by one importxml function instead of having to do them all 1 for each cell, since you only can have a max of 50.

So my original function looks like this

=importxml(concatenate("http://www.evemarketeer.com/api/jita_info/",D5,"/xml");"//result/row/sell_lowest5")

That works great for just one cell. But I have over 100 cells that I need TypeIDs for, and rather than entering them all manually I want Google Docs to do it for me.

I know that I somehow should be able to use the &JOIN function but I have no fckin clue on how to do that.

I have another funtion that gets the prices for all the items once I have the TypeIDs, it looks like this:

=ImportXML("http://eve-marketdata.com/api/item_prices_jita.xml?type_ids="&JOIN(",",$B26:$B129), "/eve/price")


So my question is, how do I get the spreadsheet to import all the TypeIDs using only 1 function? I should be able too no?
Perhaps the answer is super obvious, but it´s 4 in the morning atm and Ive been poking around with this crap for the better part of 8 hours and can hardly stay awake.

Any help would be very welcome.

Thanks

Not sure if you saw it but here is some info.

http://eve-marketdata.com/developers/google_docs.php