sven_bohikus

Well you got me, I'm stumped. I'd try PMing Morionic, he's pretty good at sheets and may have an idea. nope, I'm stumped too. Your code is correct. I even tried downloading your spreadsheet, pasting my code into it, and it still doesn't work. So clearly there's something wrong with your spreadsheet itself, since the rest of mine is fine. Try making a new spreadsheet If that doesn't work, click my siggy, go to the sample spreadsheet, copy it to your account, delete everything on my spreadsheet then recreate your spreadsheet from scratch again. Hi again guys - I think I might have a solution to your problem. It depends on the locate that the google account was created in. Sometimes instead of commas to parse elements in formulas you need to use semicolons. This is not clearly documented in the GoogleDocs Docs - but I ran into this one time before with someone trying to use my spreadsheets. Basically, in some countries comma is used as a decimal point - therefore it cant be used to parse elements in formulae. Replace all your comma with semicolons and see what happens. Cheers!

Try the Quincy C/C++ compiler and development environment. Its small, has a number of important libraries included, and is portable (can be run from a usb drive). The MinGW compiler is included with the installer. Its only 18mb and really is worth a look. Don't be worried about the fact that it hasn't been updated in a while. Not much has changed that would be of consequence to someone who is just learning. http://www.codecutter.net/tools/quincy/

Actually I found that delivering the choc-ice (during the quest) was much easier if I just ran up to the monkey gate and got caught. I woke up in jail - had lots of time to refreeze the ice, transform and escape. Also, I used the highest level ice spell and sometimes froze it twice in a row for good measure.

I'm always impressed when I see other people's RuneScape related Google docs and they mention this post as how they got started. This is looking a little old and creaky now but still seems to be helping people. One thing I thought I should mention, something that took me a while to figure out. If you are in another country where the comma is used instead of a decimal point (ie 3,14 for PI rather than 3.14) then you will be using a SEMICOLON to separate elements in your IF statements instead of COMMAS. That took ages to realize and only occurred when someone from Portugal created a new document with my instructions and pasted my IF's into their document. Good luck to everyone who continues to make and use Google docs!

For it to be fair to those who missed the first bonus weekend it would need to be exactly the same. Anything less is unfair and generally indefensible.

All set up to make 4k granite lobs, 2k bunyips and fruitbats and 750 lava titans Shards already banked. After that - about 3k sundry potions - unfs already made for all. Then Crafting 1k air battlestaves. Finally go Ill go chinning the rest of the time. Mostly things I was going to do anyways - about 2.5m spent on shards. I collected the bananas and granite myself last week.

I have timed it - including fast banking as needed - rates are in the 95-115k an hour range. It's much faster when you aren't failing at all. Also you never need food and if you wear a bow with no ammo you won't ever get into combat. I wear an amulet of nature and do farm runs as needed. I get 1 ranarr seed or better approximately every 10k of experience. It adds up.

At 95 thieving - with Ardy Cape 3 AND Gloves of Silence - I ~never~ fail at Master Farmers. I'm going to say it again in case someone thinks its a typo. I NEVER fail. Ever.

Its funny how young people mock eachother for their choices in online entertainment. I once caught an 8th grader playing some game where you have a pony and you brush and feed it. I watched her play it and she showed me all the upgrades and the various horses or ponies she had. She was enjoying it and clearly had put a lot of time into it. I do tell people that I play Runescape, I also tell them that I've been ranked in the top 15k for the last few years. And for what its worth I give all ballistic hell back to anyone who tries to tell me WoW is any better.

For my time - the #1 gem spot is the wall safes in the Rogue's Den. Also Kurask for noted pineapples - not that anyone is going to run off and kill Kurasks just because of that.

I started off with Excel and it does work - but it wasn't easy to share with others. You use the 'get external data' function of excel and it creates an entire sheet of the imported HTML. You can then reference the cells in the new sheet using regular Excel formulas. Some reference links on Excel and web data are available here: http://www.exceluser.com/explore/webqueries_1.htm http://support.microsoft.com/kb/165499

I think you already found this other thread but I will link it here: How to use Google Docs to extract GE prices ~By Brainymidget http://forum.tip.it/viewtopic.php?f=180&t=782319

Hey cool! You guys did it! :thumbsup: I couldn't figure out how I was going to parse the GE database output, but I'm glad someone else did. Excellent work guys! \

My name 'Sven Bohikus' is an old joke name we used to make about the big swedish (not swedish but descendants of) farmer boys we'd see around the rural areas of Wisconsin when I was a kid. You'd be driving along and see a big hulky blonde guy riding a tractor and you'd say 'Look there goes Sven Bohikus!' No insult is intended to anyone swedish - though I must say this commercial is very funny and topical -