| . : 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 22, 2008 11:43 pm  | |
      IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8    | It'd been awhile since I'd done anything with excel. If you go here, you can download a spreadsheet document I wrote up this afternoon for summoning. The first four pages are devoted to gold, green, crimson, and blue charms, respectively. The fifth page lets you put in some information, specifically your summoning level and the number of each type of charm you have, and gives you some useful information in exchange. The first four pages all follow the same format; please note that the formulas are not protected, so be careful where you click (nothing on these pages requires you to add anything). Specifically, these pages list each creature you can summon, as well as the required level and ingredients. It also tells you the experience you can get, as well as how many shards are required, how much those shards will cost ("base cost"), how much you can get back from alching the pouch, and how much GP you will lose per pouch after alching with nature runes at 310gp. As a final touch, these pages also include how much experience you gain per 1gp spent ("XP-per-GP") and how much gold you spend per 1xp gained ("GP-per-XP"). The formulas for these two last columns take alchemy into account. For the fifth page, there are five cells which require you to input information:  From that, the spreadsheet knows how many of each charm you have, and what your summoning level is (that one goes in the very bottom cell). Based on your level, the spreadsheet will select information from the previous four pages which is best suited to conserving how much you spend on raising the skill. Specifically, it lists a recommended creature per charm, that creature's required summoning ingredient, and computes four totals for you (total experience to be gained, total shards required, the base cost of using all your charms, and the cost after you have high-alched your resulting pouches, assuming a cost of 310gp per nature rune). The fifth page also lists the XP-per-GP and GP-per-XP ratios for the recommended creatures it lists. PS: Please be careful where you click. See that box up there that says "Arctic Bear"? It actually says: "=IF(B6>=Gold!A11,Gold!B11,IF(B6>=Gold!A9,Gold!B9,IF(B6>=Gold!A8,Gold!B8,IF(B6>=Gold!A7,Gold!B7,IF(B6>= Gold!A6,Gold!B6,IF(B6>=Gold!A4,Gold!B4,IF(B6>=Gold!A3,Gold!B3,IF(B6>=Gold!A2,Gold!B2,"false"))))))))" If you erase that, you're in a pickle. --------------------  |
Posted: February 22, 2008 11:46 pm | |
| IRC Nickname: Group: Guests Posts: Member No.: 0 Joined: January 1, 1970 Total Events Attended: 1 | Nice work tbh mate.. I might use these Sheets  Dallar -------------------- |
Posted: February 23, 2008 03:05 am | |
 IRC Nickname: Mr Glennfase Group: Emeritus Posts: 3064 Member No.: 39 Joined: December 30, 2007 Total Events Attended: 220 | That is nothing short of awesome. I'll try that out sometime. -------------------- That's Mr. Glennfase to you. Ex-Warlord/Council  |
Posted: February 23, 2008 03:17 am | |
 IRC Nickname: karel Group: Emeritus Posts: 1021 Member No.: 57 Joined: December 31, 2007 Total Events Attended: 89 | Got no idea what this summoning stuff means -------------------- Sig? |
Posted: February 23, 2008 03:29 am | |
 IRC Nickname: Indivi2you Group: Elite Guardian Posts: 5361 Member No.: 43 Joined: December 30, 2007 Total Events Attended: 623 | I heard you talking about it, I'll make sure i try it out when i get back into summoning. But for now, im getting the lvls off ToG lol. ~Saad -------------------- The First, The Last, and the Only ~FLO Never say never, because limits, like fears, are often just an illusion. ~Michael Jordan      |
Posted: February 23, 2008 03:59 am | |
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Updated with a much more user-friendly version.  -------------------- |
Posted: February 23, 2008 04:42 am | |
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Updated again, I think I'm done tweaking for now.  -------------------- |
Why waste a snowday?