I'd like to make a very detailed spreadsheet for 1-99 in all skills and I know the hiscores lookup and ge price lookup formulae for google docs but there is a limit of 50 external lookups that can be used and I need a LOT of item prices. I only have open office and microsoft excel starter but if you know the formulae for other versions please post them.

I use the search GE results page; it is accurate to about 100 gp. Just click data from web and put in the address then you can manipulate the data in excel; I put everything on a seperate worksheet.

I don't think either excel starter or open office have that ability :( I've tried with open office to import external data but it never wants to accept the url

 

EDiT: And its useless without a hiscores lookup aswell

Which excel version are you using?

I use Excel 2010 professional I think, I am not familiar with google but can you reference other documents with it? You could get your 50 links then it would count as one in another sheet.

That's a good idea. I don't know if it's possible but I'll research it. If not i can just include large buyable skill costs like prayer,construction, herblore.

It works! I love you

If you're interesting, the formula is =importrange("0AjYYOmjSUrCwdDhXT0pIdUWVlZ1JzeU6E0TUN0VG9xM3c&hl", "sheet1!A1")

 

 

0AjYYOmjSUrCwdDhXT0pIUWVlZ1J7fzeUE0pUN0VG9xM3c&hl"

is the part of the document's url that appears between /ccc?key= and =en_US#gid=1