View source for Calculator:Magic/Mage Training Arena

<!--- This page was created by myself to determine the best item to get. --->
<!--- I have added annotations to most of this calculator about how I got to each conclusion. --->
<!--- If you wish to make amendments to my workings, read the annotations before hand to double check your work. --->
<!--- You should then add an extra comment with your "EDIT:", then your reason, then amend my code. --->
<!--- If you follow these guidelines, I will take into account your argument and if correct, leave the code. --->
<!--- Else, I shall change the code back to what I had originally thought correct. --->
== Mage Training Arena calculator ==

The table below shows costs of each Mage Training Arena puzzle and using live data from the [[Grand Exchange Market Watch]], calculates the most profitable prize for the Mage Training Arena.

====Rune Prices====

* [[File:Law rune.png]] A [[Law Rune]] costs {{GEPrice|Law rune}} coins.

* [[File:Nature rune.png]] A [[Nature Rune]] costs {{GEPrice|Nature rune}} coins.

* [[File:Cosmic rune.png]] A [[Cosmic Rune]] costs {{GEPrice|Cosmic rune}} coins.

===Point Calculations===
====Telekinetic Theatre====
<!--- The figures here are calculated as follows: --->
<!--- RUNES PER PUZZLE --->
<!--- Average moves per puzzle is 8.3, as there are 10 puzzles, with a total of 83 moves. --->
<!--- After every 5 puzzles, the user is given 10 law runes. This divided by 5 = 2. Making the average moves 6.3. --->
<!--- PIZAZZ PER PUZZLE --->
<!--- You earn 2 Pizazz points per puzzle, and 8 bonus points every 5 puzzles. This makes it 3.6 Pizazz per puzzle. --->
* ''Calculations are based on using a Staff of Air.''
* ''Based on completing 5 puzzles for bonus Law Runes and Pizazz points.''
* ''If puzzles are not completed in sets of 5, calculations may be wrong.''
:{| class="wikitable sortable"
! Rune Needed || Recommended Staff || Rune Price || Avg. Runes/Puzzle || Pizzazz Points/Puzzle || Runes/Point || Cost/Point
|-
<!-- Telekinetic Theatre Table -->
| [[File:Law rune.png|Law Rune]] [[Law Rune|Law Rune]] || [[File:Staff of Air.png|link=Staff of Air]] [[Staff of Air|Staff of Air]] || {{:Exchange:Law rune|View=price}} || 6.3 || 3.6 || 1.75 || {{Coins|Amount = {{:Exchange:Law rune|View=price}}*1.75 }}
|}

====Alchemist's Playground====
<!--- The figures here are calculated as follows: --->
<!--- RUNES PER DEPOSIT --->
<!--- Average alchs per deposit is 3.3, as it is calculated on 30gp alch, and you need 100gp to deposit. --->
<!--- This does not include free alch, as the price of these vary, and would be impossible to calculate. --->
<!--- PIZAZZ PER Deposit --->
<!--- You earn 1 Pizazz points per 100gp deposited, you earn no bonuses on this puzzle. --->
* ''Calculations are based on using a Staff of Fire.''
* ''Based on casting alchemy only on 30gp items, and not including free alchs.''
* ''If you cast alchemy on an item that is less than 30gp, or is free, figures may be wrong.''
:{| class="wikitable sortable"
! Rune Needed || Recommended Staff || Rune Price || Runes/Deposit || Pizzazz Points/Deposit || Runes/Point || Cost/Point
|-
<!-- Alchemist's Playground Table -->
| [[File:Nature rune.png|Nature rune]] [[Nature rune|Nature rune]] || [[File:Staff of fire.png|link=Staff of fire]] [[Staff of fire|Staff of Fire]] || {{:Exchange:Nature rune|View=price}} || 3.3 || 1 || 3.3 || {{Coins|Amount = {{:Exchange:Nature rune|View=price}}*3.3 -10}}
|}

====Enchanting Chamber====
<!--- The figures here are calculated as follows: --->
<!--- PIZAZZ PER DEPOSIT --->
<!--- Each bonus enchant gives 1 Pizazz point. It is based on bonus enchantments only, as stated. --->
<!--- Each level of enchantment gives 1 more Pizazz point. Each enchant costs 1 rune. --->
<!--- 1 / bonus point + enchant level point = Runes/Point. --->
* ''Calculations are based on using the appropriate staff for the enchantment.''
* ''Based on casting enchantments only on bonus items, and not including Dragonstones.''
* ''If you cast alchemy on an item that is not a bonus item, or a Dragonstone figures may be wrong.''
:{| class="wikitable sortable"
!Level || Rune Needed || Recommended Staff || Rune Price || Pizzazz Points/Enchant || Runes/Point || Cost/Point
|-
<!-- Enchanting Chamber -->

<!--- Sapphire --->
| Sapphire || [[File:Cosmic rune.png|Cosmic rune]] [[Cosmic rune|Cosmic rune]] || [[File:Staff of water.png|link=Staff of water]] [[Staff of water|Staff of Water]] || {{:Exchange:Cosmic rune|View=price}} || 2 || 0.5 || {{Coins|Amount = {{:Exchange:Cosmic rune|View=price}}*0.5}}
|-

<!--- Emerald --->
| Emerald || [[File:Cosmic rune.png|Cosmic rune]] [[Cosmic rune|Cosmic rune]] || [[File:Staff of Air.png|link=Staff of Air]] [[Staff of Air|Staff of Air]] || {{:Exchange:Cosmic rune|View=price}} || 3 || 0.3 || {{Coins|Amount = {{:Exchange:Nature rune|View=price}}*0.3}}
|-

<!--- Ruby --->
| Ruby || [[File:Cosmic rune.png|Cosmic rune]] [[Cosmic rune|Cosmic rune]] || [[File:Staff of fire.png|link=Staff of fire]] [[Staff of fire|Staff of Fire]] || {{:Exchange:Cosmic rune|View=price}} || 4 || 0.25 || {{Coins|Amount = {{:Exchange:Cosmic rune|View=price}}*0.25}}
|-
| Diamond || [[File:Cosmic rune.png|Cosmic rune]] [[Cosmic rune|Cosmic rune]] || [[File:Staff of earth.png|link=Staff of earth]] [[Staff of earth|Staff of Earth]] || {{:Exchange:Cosmic rune|View=price}} || 5 || 0.2 || {{Coins|Amount = {{:Exchange:Cosmic rune|View=price}}*0.2}}
|-

<!--- Dragonstone --->
| Dragonstone || [[File:Cosmic rune.png|Cosmic rune]] [[Cosmic rune|Cosmic rune]] || [[File:Mud battlestaff.png|link=Mud battlestaff]] [[Mud battlestaff|Mud Battlestaff]] || {{:Exchange:Cosmic rune|View=price}} || 6 || 0.16 || {{Coins|Amount = {{:Exchange:Cosmic rune|View=price}}*0.16}}
|-

<!--- Onyx --->
| Onyx || [[File:Cosmic rune.png|Cosmic rune]] [[Cosmic rune|Cosmic rune]] || [[File:Lava battlestaff.png|link=Lava battlestaff]] [[Lava battlestaff|Lava Battlestaff]] || {{:Exchange:Cosmic rune|View=price}} || 7 || 0.14 || {{Coins|Amount = {{:Exchange:Cosmic rune|View=price}}*0.14}}
|}

====Creature Graveyard====
<!--- The figures here are calculated as follows: --->
<!--- RUNES PER DEPOSIT --->
<!--- The spell turns any bones in the inventory to fruit. --->
<!--- As you need 16 for 1 Pizazz, this can be achieved with 1 cast. --->
<!--- PIZAZZ PER Deposit --->
<!--- You earn 1 Pizazz points per 16 fruit deposited, you earn no bonuses on this puzzle. --->
* ''Calculations are based on using a Mud Battlestaff.''
* ''Based on casting Bones to Bananas/Peaches with a set of bones which will fill the inventory.''
* ''If you cast Bones to Bananas/Peaches on a bones that don't fill your inventory with fruits, figures may be wrong.''
:{| class="wikitable sortable"
! Rune Needed || Recommended Staff || Rune Price || Runes/Deposit || Pizzazz Points/Deposit || Runes/Point || Cost/Point
|-
<!-- Creature Graveyard Table -->
| [[File:Nature rune.png|Nature rune]] [[Nature rune|Nature rune]] || [[File:Mud battlestaff.png|link=Mud battlestaff]] [[Mud battlestaff|Mud Battlestaff]] || {{:Exchange:Nature rune|View=price}} || 1 || 1 || 1 || {{Coins|Amount = {{:Exchange:Nature rune|View=price}}}}
|}


===Profit Margins===
<!--- The figures here are calculated as follows: --->
<!--- Telekinetic points: Telekinetic points required * 1.75. (1.75 is the amount of runes/Pizazz point) --->
<!--- Alchemy points: Alchemy points required * 3.3. (3.3 is the amount of runes/Pizazz point) --->
<!--- Enchantment points: Enchantment points required * 0.14. (0.14 is the amount of runes/Pizazz point) --->
<!--- Graveyard points: Graveyard points required * 1. (1 is the amount of runes/Pizazz point) --->
* ''These prices are based on Onyx enchantments being used. If using a lesser enchantment, profit will be slightly less.''
* ''For the wand calculations, the previous level wand is required. The exchange price is used for these. If making the wands yourself, profit will be slightly higher.''
:{| class="wikitable sortable"
! Reward || Tele Points || Alch Points || Ench Points || GY Points || Profit || Profit/Point
|-

<!-- Beginner Wand -->
| [[File:Beginner wand.png|Beginner wand]] [[Beginner wand|Beginner Wand]] || 30 || 30 || 300 || 30 || {{Coins|Amount = {{#expr:( ({{:Exchange:Beginner wand|View=price}} -{{:Exchange:Law rune|View=price}}*52.5 -{{:Exchange:Nature rune|View=price}}*99 -{{:Exchange:Cosmic rune|View=price}}*42 -{{:Exchange:Nature rune|View=price}}*30) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Beginner wand|View=price}} -{{:Exchange:Law rune|View=price}}*52.5 -{{:Exchange:Nature rune|View=price}}*99 -{{:Exchange:Cosmic rune|View=price}}*42 -{{:Exchange:Nature rune|View=price}}*30) round 2 )}} / 390 round 2}}
|-

<!--- Apprentice Wand --->
| [[File:Apprentice wand.png|Apprentice wand]] [[Apprentice wand|Apprentice Wand]] || 60 || 60 || 600 || 60 || {{Coins|Amount = {{#expr:( ({{:Exchange:Apprentice wand|View=price}} -{{:Exchange:Law rune|View=price}}*105 -{{:Exchange:Nature rune|View=price}}*198 -{{:Exchange:Cosmic rune|View=price}}*84 -{{:Exchange:Nature rune|View=price}}*60) -{{:Exchange:Beginner wand|View=price}} round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Apprentice wand|View=price}} -{{:Exchange:Law rune|View=price}}*105 -{{:Exchange:Nature rune|View=price}}*198 -{{:Exchange:Cosmic rune|View=price}}*84 -{{:Exchange:Nature rune|View=price}}*60) -{{:Exchange:Beginner wand|View=price}} round 2 )}} / 780 round 2}}
|-

<!--- Teacher Wand --->
| [[File:Teacher wand.png|Teacher wand]] [[Teacher wand|Teacher Wand]] || 150 || 200 || 1500 || 150 || {{Coins|Amount = {{#expr:( ({{:Exchange:Teacher wand|View=price}} -{{:Exchange:Law rune|View=price}}*262.5 -{{:Exchange:Nature rune|View=price}}*660 -{{:Exchange:Cosmic rune|View=price}}*210 -{{:Exchange:Nature rune|View=price}}*150 -{{:Exchange:Apprentice wand|View=price}}) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Teacher wand|View=price}} -{{:Exchange:Law rune|View=price}}*262.5 -{{:Exchange:Nature rune|View=price}}*660 -{{:Exchange:Cosmic rune|View=price}}*210 -{{:Exchange:Nature rune|View=price}}*150 -{{:Exchange:Apprentice wand|View=price}}) round 2 )}} / 2000 round 2}}
|-

<!--- Master Wand --->
| [[File:Master wand.png|Master wand]] [[Master wand|Master Wand]] || 240 || 240 || 2400 || 240 || {{Coins|Amount = {{#expr:( ({{:Exchange:Master wand|View=price}} -{{:Exchange:Law rune|View=price}}*420 -{{:Exchange:Nature rune|View=price}}*792 -{{:Exchange:Cosmic rune|View=price}}*336 -{{:Exchange:Nature rune|View=price}}*240 -{{:Exchange:Teacher wand|View=price}}) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Master wand|View=price}} -{{:Exchange:Law rune|View=price}}*420 -{{:Exchange:Nature rune|View=price}}*792 -{{:Exchange:Cosmic rune|View=price}}*336 -{{:Exchange:Nature rune|View=price}}*240 -{{:Exchange:Teacher wand|View=price}}) round 2 )}} / 3120 round 2}}
|-

<!--- Infinity Hat --->
| [[File:Infinity hat.png|Infinity hat]] [[Infinity hat|Infinity Hat]] || 350 || 400 || 3000 || 350 || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity hat|View=price}} -{{:Exchange:Law rune|View=price}}*612.5 -{{:Exchange:Nature rune|View=price}}*1320 -{{:Exchange:Cosmic rune|View=price}}*420 -{{:Exchange:Nature rune|View=price}}*350) round 2 )}} }} || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity hat|View=price}} -{{:Exchange:Law rune|View=price}}*612.5 -{{:Exchange:Nature rune|View=price}}*1320 -{{:Exchange:Cosmic rune|View=price}}*420 -{{:Exchange:Nature rune|View=price}}*350))}} /4100 round 2}}
|-
| [[File:Infinity top.png|Infinity top]] [[Infinity top|Infinity Top]] || 400 || 450 || 4000 || 400 || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity top|View=price}} -{{:Exchange:Law rune|View=price}}*787.5 -{{:Exchange:Nature rune|View=price}}*1485 -{{:Exchange:Cosmic rune|View=price}}*560 -{{:Exchange:Nature rune|View=price}}*400) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity top|View=price}} -{{:Exchange:Law rune|View=price}}*787.5 -{{:Exchange:Nature rune|View=price}}*1485 -{{:Exchange:Cosmic rune|View=price}}*560 -{{:Exchange:Nature rune|View=price}}*400) round 2)}} / 5250 round 2}}
|-

<!--- Infinity Bottom --->
| [[File:Infinity bottoms.png|Infinity bottoms]] [[Infinity bottoms|Infinity Bottoms]] || 450 || 500 || 5000 || 450 || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity bottoms|View=price}} -{{:Exchange:Law rune|View=price}}*787.5 -{{:Exchange:Nature rune|View=price}}*1650 -{{:Exchange:Cosmic rune|View=price}}*700 -{{:Exchange:Nature rune|View=price}}*450) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity bottoms|View=price}} -{{:Exchange:Law rune|View=price}}*787.5 -{{:Exchange:Nature rune|View=price}}*1650 -{{:Exchange:Cosmic rune|View=price}}*700 -{{:Exchange:Nature rune|View=price}}*450) round 2 )}} / 6400 round 2}}
|-

<!--- Infinity Boots --->
| [[File:Infinity boots.png|Infinity boots]] [[Infinity boots|Infinity Boots]] || 120 || 120 || 1200 || 120 || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity boots|View=price}} -{{:Exchange:Law rune|View=price}}*210 -{{:Exchange:Nature rune|View=price}}*396 -{{:Exchange:Cosmic rune|View=price}}*168 -{{:Exchange:Nature rune|View=price}}*480) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity boots|View=price}} -{{:Exchange:Law rune|View=price}}*210 -{{:Exchange:Nature rune|View=price}}*396 -{{:Exchange:Cosmic rune|View=price}}*168 -{{:Exchange:Nature rune|View=price}}*480) round 2 )}} / 1560 round 2}}
|-

<!--- Infinity Gloves --->
| [[File:Infinity gloves.png|Infinity gloves]] [[Infinity gloves|Infinity Gloves]] || 175 || 225 || 1500 || 175 || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity gloves|View=price}} -{{:Exchange:Law rune|View=price}}*306.25 -{{:Exchange:Nature rune|View=price}}*742.5 -{{:Exchange:Cosmic rune|View=price}}*210 -{{:Exchange:Nature rune|View=price}}*175) round 3 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Infinity gloves|View=price}} -{{:Exchange:Law rune|View=price}}*306.25 -{{:Exchange:Nature rune|View=price}}*742.5 -{{:Exchange:Cosmic rune|View=price}}*210 -{{:Exchange:Nature rune|View=price}}*175) round 3 )}} / 2075 round 2 }}
|-

<!--- Mage's Book --->
| [[File:Mages' book.png|Mage's book]] [[Mages' book|Mage's Book]] || 500 || 550 || 6000 || 500 || {{Coins|Amount = {{#expr:( ({{:Exchange:Mages' book|View=price}} -{{:Exchange:Law rune|View=price}}*875 -{{:Exchange:Nature rune|View=price}}*1815 -{{:Exchange:Cosmic rune|View=price}}*840 -{{:Exchange:Nature rune|View=price}}*500) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Mages' book|View=price}} -{{:Exchange:Law rune|View=price}}*875 -{{:Exchange:Nature rune|View=price}}*1815 -{{:Exchange:Cosmic rune|View=price}}*840 -{{:Exchange:Nature rune|View=price}}*500) round 2 )}} / 7550 round 2 }}
|-

<!--- Battlestaff --->
| [[File:Staff.png|Battlestaff]] [[Battlestaff|Battlestaff]] || 1 || 2 || 20 || 2 || {{Coins|Amount = {{#expr:( ({{:Exchange:Battlestaff|View=price}} -{{:Exchange:Law rune|View=price}}*1.75 -{{:Exchange:Nature rune|View=price}}*6.6-{{:Exchange:Cosmic rune|View=price}}*2.8 -{{:Exchange:Nature rune|View=price}}*2) round 2 )}}}} || {{Coins|Amount = {{#expr:( ({{:Exchange:Battlestaff|View=price}} -{{:Exchange:Law rune|View=price}}*1.75 -{{:Exchange:Nature rune|View=price}}*6.6-{{:Exchange:Cosmic rune|View=price}}*2.8 -{{:Exchange:Nature rune|View=price}}*2) round 2 )}} / 25 round 2 }}
|}
[[Category:Calculators]]
[[Category:Calculators that need to be checked]]