Thai_tong Posted August 13, 2011 Share Posted August 13, 2011 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. Link to comment Share on other sites More sharing options...
VARN Posted August 13, 2011 Share Posted August 13, 2011 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. Link to comment Share on other sites More sharing options...
Thai_tong Posted August 13, 2011 Author Share Posted August 13, 2011 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 Link to comment Share on other sites More sharing options...
Thai_tong Posted August 14, 2011 Author Share Posted August 14, 2011 Which excel version are you using? Link to comment Share on other sites More sharing options...
VARN Posted August 14, 2011 Share Posted August 14, 2011 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. Link to comment Share on other sites More sharing options...
Thai_tong Posted August 15, 2011 Author Share Posted August 15, 2011 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. Link to comment Share on other sites More sharing options...
Thai_tong Posted August 17, 2011 Author Share Posted August 17, 2011 It works! I love youIf 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now