| | Farming Herb Calculator |  |
|
|
|
| Author | Message |
|---|
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Farming Herb Calculator Mon Oct 08, 2012 12:19 am | |
| I've made this all by myself, but if you guys would like to log any of your personal herb runs (on your own personal spreadsheet of course) I would be interested in retrieving that data so we can make my calculator become more accurate. Anyways, here it is, all you need to do is plug in the two values at the top where the cells are a solid color. Enjoy and have fun  (CURRENTLY ONLY WORKS FOR SNAPDRAGONS, TORSTOLS, DWARF WEED, LANTADYME, RANARR, TOADFLAX, AVANTOE AND FELLSTALK) Newest Version: https://docs.google.com/spreadsheet/ccc?key=0AkhcUesnaDordGhMTFRhNkJwWnZyVzh2Mk1yd1BXaVEThanks to Mikey for the help.
Last edited by Hop a on Wed Oct 31, 2012 3:54 am; edited 2 times in total | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 12:30 am | |
| Oops, had it set to view. Now try. | |
|
| | |
Barca
Soulgazer
Posts : 13652
Join date : 2010-06-23
Location : Sweden
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 12:31 am | |
| I always do dis when i buy more seeds  Anywayz, nice work hopa. Im sure a few newbfarmers will find this helpfull | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 1:17 am | |
| Thank ya  It took me way longer than it should have hehehehe... Been an effort since I started my Snapdragon runs to make everything come out good. Finally found out how to make it retrieve live data, and that was kind of the last piece I needed. | |
|
| | |
Cream
Turoth
Posts : 350
Join date : 2011-01-20
Location : Trinidad & Tobago
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 2:04 am | |
| This is pretty cool  Too bad I just keep all that info in my head  | |
|
| | |
Amy
Abyssal Demon
Posts : 1360
Join date : 2011-06-18
Location : London, England
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 10:21 am | |
| at a first glance itooks great! wil give it a proper go when i buy more seeds!  | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 8:06 pm | |
| Stupid thing wont gather live data, but my excel spreadsheet will.
Anyone got any idea on how to make it gather live GE information? (in google docs) | |
|
| | |
MikeyzDragon
Skeletal Wyvern
Posts : 642
Join date : 2009-12-27
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 8:10 pm | |
| checking
open it up you dope
EDIT: I can do it. too hard to explain.
also, issue with gdocs is that they restrict on how often the prices update. so they take forever the more you automate. | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Mon Oct 08, 2012 11:52 pm | |
| Figures, anyways I'll add you in so you got full access. (What I had done with excel is use data from runescape wikia, since for some reason it wouldn't load information from the GE database, the information is in the Hidden documents (should be 8 sheets)) Anyways see what you can do. | |
|
| | |
MikeyzDragon
Skeletal Wyvern
Posts : 642
Join date : 2009-12-27
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 5:47 am | |
| You can easily get them from the GE database. Just have to know where to look. Example: http://services.runescape.com/m=itemdb_rs/Clean_avantoe/viewitem.ws?obj=261clean avantoe direct link a fun command that imports everything in the page source with certain tags: =importXML("http://services.runescape.com/m=itemdb_rs/Clean_avantoe/viewitem.ws?obj=261"; "//td") First thing that shows up is the GE price for the Clean Avantoe Herb in the first column that you post that command in. Breakdown of that command: importXML tells google that it's gathering info from a page. The link tells it where to go. the //td tells it to grab all the data within tags. Thankfully jagex didn't screw up their coding like they usually do with all their pages (WHICH IS WHY IT LOADS SO SLOW AND LAGS).
So all in all, find the object number. Easily find this by looking at the page source then ctrl + f the name of the seed/herb and the link to that object will be there. | LOLLLLLLLLLLLLLL html tags work with this forum | |
|
| | |
MikeyzDragon
Skeletal Wyvern
Posts : 642
Join date : 2009-12-27
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 5:50 am | |
| - Code:
-
You can easily get them from the GE database. Just have to know where to look.
Example:
http://services.runescape.com/m=itemdb_rs/Clean_avantoe/viewitem.ws?obj=261
clean avantoe direct link a fun command that imports everything in the page source with certain tags:
=importXML("http://services.runescape.com/m=itemdb_rs/Clean_avantoe/viewitem.ws?obj=261"; "//td")
First thing that shows up is the GE price for the Clean Avantoe Herb in the first column that you post that command in.
Breakdown of that command: importXML tells google that it's gathering info from a page. The link tells it where to go. the //td tells it to grab all the data within <td> tags. Thankfully jagex didn't screw up their coding like they usually do with all their pages (WHICH IS WHY IT LOADS SO SLOW AND LAGS).
So all in all, find the object number. Easily find this by looking at the page source then ctrl + f the name of the seed/herb and the link to that object will be there.
LOLLLLLLLLLLLLLL html tags work with this forum lmfaooooooooooo HTML codes for TD work in the forum post. I died. EDIT: I'll just do it since I'm bored lol. EDIT: why would you bother with grimeyyyyyyyy you lost moneyyyyyyyyyyyyyy | |
|
| | |
MikeyzDragon
Skeletal Wyvern
Posts : 642
Join date : 2009-12-27
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 6:46 am | |
| | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 4:27 pm | |
| Cause Grimy is for lazy farmers. I always clean mine!@@@ And thank ya sir! And yes, html works in here Just check out my Event log (scrolling text ) I'll fiddle with formulas so the other herbs can be calculated as well (No way in hell I'll farm them though lol). | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 4:30 pm | |
| IF ANY OF YOU KEEP A FARMING LOG I WOULD BE INTERESTED IN HAVING YOUR DATA!!! PLEASE AND THANK YOU! | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 4:38 pm | |
| Also, let me edit it plox mikey. | |
|
| | |
Cream
Turoth
Posts : 350
Join date : 2011-01-20
Location : Trinidad & Tobago
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 4:59 pm | |
| Are you just trying to find the average herb yield for different herb boosts? | |
|
| | |
Agile Darth
Desert Strykewyrm
Posts : 710
Join date : 2010-10-22
Location : Carnegie, Pennsylvania
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 6:42 pm | |
| | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Tue Oct 09, 2012 7:15 pm | |
| - Cream wrote:
- Are you just trying to find the average herb yield for different herb boosts?
No, main purpose is to try to calculate how much profit a certain type of crop will yield in a certain amount of seeds. Also, to see if there's a significant difference of herb yields between the types of crop (but that's not the main purpose of it). Here's the newest version of it: https://docs.google.com/spreadsheet/ccc?key=0AkhcUesnaDordGhMTFRhNkJwWnZyVzh2Mk1yd1BXaVE | |
|
| | |
Amy
Abyssal Demon
Posts : 1360
Join date : 2011-06-18
Location : London, England
| | Subject: Re: Farming Herb Calculator Thu Oct 11, 2012 12:32 pm | |
| Really useful, was very helpful! 1 tiny thing to nit pick at... you spelt lantadyme wrong but yeah, great job hop! | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Thu Oct 11, 2012 2:44 pm | |
| Oh that's bad. I'll see if it was only in one spot or just me misspelling things. | |
|
| | |
MikeyzDragon
Skeletal Wyvern
Posts : 642
Join date : 2009-12-27
| | Subject: Re: Farming Herb Calculator Thu Oct 11, 2012 5:07 pm | |
| | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Fri Oct 12, 2012 12:05 pm | |
| *cough* and mikey *cough* | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Thu Oct 18, 2012 9:40 pm | |
| | |
|
| | |
Hopalong
Soulgazer
Posts : 3196
Join date : 2009-10-27
Location : Mission Viejo, California
| | Subject: Re: Farming Herb Calculator Tue Oct 23, 2012 3:03 am | |
| More data added, formulas fixed that were broken, good way to end the day. | |
|
| | |
Barca
Soulgazer
Posts : 13652
Join date : 2010-06-23
Location : Sweden
| | Subject: Re: Farming Herb Calculator Tue Oct 23, 2012 5:40 am | |
| - Hop a wrote:
- More data added, formulas fixed that were broken, good way to end the day.
Played cw while you fixed it? | |
|
| | |
Sponsored content
| | Subject: Re: Farming Herb Calculator | |
| |
|
| | |
| | Farming Herb Calculator | |
|
