| . : News : . | . : Message of the Week : . |
You are currently viewing an archive of the Wilderness Guardians clan's IPB1 forums.
These forums were used by WG from 2008 to 2011, and now exist for historical and achival purposes only. For the clan's current forums, CLICK HERE. |
"You are a Wilderness Guardian. That northern wasteland; that land of blood, desolation and death is your dominion. Tonight we are going home." ~His Lordship |
|---|---|---|
| War Alert: OFF | Raid Alert: OFF | |
PM a WG Official |
||
Posted: February 17, 2009 04:43 am  | |||||
      IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8    | I'm taking an Excel class this semester; as a way to practice I'm getting back into making RS spreadsheets to help calculate stuff. If you can think of something that can be done with a spreadsheet related to RS that you'd find useful, just post and I'll see if I can do it. I'm experimenting with importing market data off the web, but it's still a little kinky (I can work with it but it's not as smooth as I'd like). This will also require that you have Excel 2007 for optimal results. I haven't looked at high scores stuff yet, that's already easy to get elsewhere. Current Projects: Summoning Guide: Will calculate the best cost-effect use of your charms based on your level using the latest GE data. Most of the theory-work is done, but this will probably take me the longest to complete because of all the different things that go into it (secondary ingredients for every pouch ... *twitches*). Completed Projects: Barrows Calculator: (link) Plug in what you got from the chest and this sheet will appraise your earnings. F2p Combat Gear: (link) Compare combat items and decide what your best f2p raid/war setup can be. Herblore Cost Calculator: (link) Requested by Evil. Calculates average GP per XP loss ratio for five different potions. Ranarr Farming Index: (link) Personal project; calculates a couple useful statistics related to ranarr-herb growing. --------------------  | ||||
Posted: February 17, 2009 09:49 am | |||||
 IRC Nickname: Jesseh Group: Guest Posts: 2670 Member No.: 297 Joined: March 8, 2008 Total Events Attended: 222 | They would be really helpful guides Wayne, good luck  --------------------   17/6/08--> 12/9/08--> 29/11/08--> 5/1/09--> 2/3/09(Left)--> 19/7/09(Rejoin)--> 2/8/09
| ||||
Posted: February 17, 2009 01:59 pm | |||||
 IRC Nickname: Hyperion Group: Ex-Member Posts: 1636 Member No.: 978 Joined: June 23, 2008 Total Events Attended: 141 | !charm 68 500 600 340 100 There we go, i just completed your summoning guide. --------------------    Dragon boots:29 Whips:2 | ||||
Posted: February 17, 2009 02:25 pm | |||||
 IRC Nickname: Dnovelta Group: Emeritus Posts: 2750 Member No.: 130 Joined: January 20, 2008 Total Events Attended: 137 | Can I get a copy of that Rannar guide? --------------------   | ||||
Posted: February 17, 2009 02:42 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 |
I'm pretty sure that tells you how to get the highest experience per charm, not on an xp:gp ratio.  I'm a miser with summoning so that's my only interest, lol.I'll upload the Ranarr Guide after some fine tuning; maybe half an hour. -------------------- | ||||
Posted: February 17, 2009 03:53 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Download Link: http://www.megaupload.com/?d=KTQRXQ1Y Ranarr Farming Calculator:  How this works is you just plug in how many herbs you got from your ranarr plants and the spreadsheet will automatically calculate your income (based on the market average) based on the following qualifiers:  "Weighted" is the average yield per plant including any that died. "Unweighted" ignores dead plants (zeros) and gives you the average yield per plant which survived. "Deaths" calculates the percentage of plants which have died each trip (ignoring Trollheim herbs, since they can't die). Since this is formatted as a table, to begin a new row simply go to the last cell in the last existing record (this would be in the "Income" column, the cell directly above the double underline) and press the Tab key on your keyboard. This will automatically begin a new record. All of these calculations have been tweaked to ignore blank cells, so DO NOT enter zeros in cells where you did not plant anything! The spreadsheet will read those zeros as plant deaths, which is bad. The data currently in the spreadsheet is just as an example and should be removed. IMPORTANT: To update the price data, go to DATA on the office ribbon (Excel 2007) and click "Refresh All" in the Connections group. This will probably delay your computer for a few seconds while the five web queries update. -------------------- | ||||
Posted: February 17, 2009 04:08 pm | |||||
| IRC Nickname: Dnovelta Group: Emeritus Posts: 2750 Member No.: 130 Joined: January 20, 2008 Total Events Attended: 137 | That is so totally awesome...would actually help me decide whether or not it's a decent source of income for me. Let me know when you've uploaded it. Here's a suggestion for another spreadsheet, but it might be pretty tasking. It would tackle the whole deal of how many prayer potions to bring to certain training spots (Chaos Tunnels, Armored Zombies (for lazy people)). You'd have to take into account prayer levels, bonuses from gear (I would just use the most standard setups for the spreadsheet, seeing as there could be limitless combination of setups). If you wanted to go even further, calculate how many super/pure sets would work with that amount of prayer potions and such. It would be a lot of work, but I think a lot of people would find that useful. -------------------- | ||||
Posted: February 17, 2009 05:25 pm | |||||
 IRC Nickname: Sithofwookie Group: Ex-Member Posts: 2842 Member No.: 815 Joined: June 11, 2008 Total Events Attended: 48 | Wayne, you sir are a genius. I'm looking forward to that Barrows Calculator  --------------------  | ||||
Posted: February 17, 2009 06:51 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 |
I'm not sure what to use as a frame of reference for that.  -------------------- | ||||
Posted: February 17, 2009 07:35 pm | |||||
 IRC Nickname: Ret[Keith] Group: Emeritus Posts: 2049 Member No.: 86 Joined: January 1, 2008 Total Events Attended: 82 |
 -------------------- Best Firemaker in WG no lie   <--- rofl1st joined WG: October 18th, 2005. Ex-WG mod, OPH winner  ^My original idea (U GOIN DOWN TWIZ)^ 189th person to get "100" firemaking Hash Unit, Tun Unit, C-Unit    | ||||
Posted: February 17, 2009 08:11 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Download Link: http://www.megaupload.com/?d=T3BH1FUR Barrows Calculator:  This is very straight forward. Just put in what you get and you get a dollar amount back. Enter the number of times you looted the chest in the first column and you'll get (1) a total income figure for the whole trip, and (2) average income per chest. If you don't get anything for one of the items, or don't particularly care about keeping track of the little stuff, just enter zeros. You can select from a drop-down list for both the First Item and Second Item columns, so there's no worries about typos. This calculator DOES NOT take into account materials (such as food, potions, or runes) used during your barrows run; it just gives you a total based on current market averages. There are two hidden worksheets that you don't have to worry about. Since this is formatted as a table, to begin a new row simply go to the last cell in the last existing record (this would be in the "Income" column, the cell directly above the double underline) and press the Tab key on your keyboard. This will automatically begin a new record. IMPORTANT: To update the price data, go to DATA on the office ribbon (Excel 2007) and click "Refresh All" in the Connections group. This will probably delay your computer for a few minutes while the 32 web queries update. If you enter an item and the calculation is obviously off, it's probably because the price of the item has gone from the millions to the hundred thousands, or vice-versa. To correct this follow these steps:
| ||||
Posted: March 5, 2009 07:39 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Download Link: http://www.megaupload.com/?d=ET2XEYU9 F2p Gear Calculator:  I've compiled the more common f2p combat gear for all three attack types as well as FoG gear and set them up in a calculator. You can compare up to three items individually, or make up three different full setups and compare their total bonuses. Kind of useful to easily see just how much of a difference some equipment makes. I've ignored weapons except for: rune scimitar, maple shortbow, and staff of fire. If there's a reason to have other weapons on the list just let me know and I'll add them in. There are two hidden spreadsheets just with data you can ignore, and there's nothing you have to keep updated like with the barrows spreadsheet. Cheers! -------------------- | ||||
Posted: March 5, 2009 07:47 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Working on updating the Barrows Calculator after using it a bit myself. // edit // Updated. Now you just enter the data when you leave instead of doing each run individually. -------------------- | ||||
Posted: March 17, 2009 07:31 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Download Link: http://www.megaupload.com/?d=X88KN5ZP Herblore Costs Calculator:  Evil asked for this one, so it's tailored for him specifically. The spreadsheets use web queries to use the latest market data from RuneHQ. You can delimit what resources you buy and at what price (minimum, average, maximum). You can do the same with the finished potions you plan to sell, and the spreadsheet will calculate your average GP loss per XP gained. The chart is dynamic, so it will change immediately to reflect your selections. The spreadsheet also collects the percentage rise/fall of any of the items involved over the past week and month, to keep you better informed (no point in investing in super defense potions the week I made this spreadsheet, for example). Overall I'm really pleased with how this one worked out.  Kudos to Evil for the request.IMPORTANT: To update the price data, go to DATA on the office ribbon (Excel 2007) and click "Refresh All" in the Connections group. This will probably delay your computer for a minute while the seventeen web queries update. -------------------- | ||||
Posted: March 17, 2009 07:46 pm | |||||
| IRC Nickname: Rexibit0 Group: Guest Posts: 91 Member No.: 1765 Joined: March 15, 2009 Total Events Attended: 2 | Very nice stuff Eregion2. --------------------  | ||||
Posted: March 17, 2009 07:58 pm | |||||
| IRC Nickname: Group: Elite Guardian Posts: 7306 Member No.: 47 Joined: December 30, 2007 Total Events Attended: 343 | Waiting on the Summoning calc -------------------- July 5, 2007 - June 27, 2011 | ||||
Posted: March 17, 2009 08:21 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 |
You might be waiting until doomsday.  I'll try and get back on it, lol.That many web queries seriously is like ... I dunno ...  -------------------- | ||||
Posted: March 17, 2009 08:24 pm | |||||
| IRC Nickname: Group: Banned Posts: 2447 Member No.: 114 Joined: January 8, 2008 Total Events Attended: 149 | Keep in mind for herblore, the (3) pots generally don't sell at high. About half the time, the (4) will sell at high, or you may have to put them at medium. -------------------- | ||||
Posted: March 18, 2009 02:16 am | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | True, but the price per dose is fixed for (1), (2), (3), and (4) doses. The calculations will still be right on even after combining them. (3) is just easier to compare instead of converting the prices for the rest of the stuff. -------------------- | ||||
Posted: March 19, 2009 06:43 pm | |||||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 |
Alright, I've officially launched Operation Summoning Calculator.  There's several things I want to be able to do with it now though, so it'll take more work than planned. Also, we haven't completely covered macros yet in class, and I have a feeling they'll be very useful for this, so the finished version might not be available for 2-3 weeks after I've finished everything else. But I'm on it! -------------------- | ||||
Help Me Help You!, With Excel!