Back to Topic Index
Why waste a snowday?
By Eregion2 on 22/02/2008
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.
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.
By Sygelig on 22/02/2008
Nice work tbh mate.. I might use these Sheets 
Dallar
Dallar
By ArSeNaLfAn32 on 23/02/2008
That is nothing short of awesome. I'll try that out sometime.
By Karel Dude on 23/02/2008
Got no idea what this summoning stuff means
By Indivi2you on 23/02/2008
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
~Saad
By Eregion2 on 23/02/2008
Updated with a much more user-friendly version. 
By Eregion2 on 23/02/2008
Back to Topic Index