User:Alsang/Sandbox: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
No edit summary |
No edit summary |
||
(30 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Invoking Module== |
|||
What I want the SMW table to look like |
|||
{{#invoke:Sandbox/User:Alsang/PotionList|main}} |
|||
==Copying output of module from debug== |
|||
Potions per hour assumes 40 seconds resupply between each batch of 12 potions. |
|||
{| class="wikitable sortable" |
{| class="wikitable sortable" |
||
! Level !! Potion !! Reagents (plus bottle) !! colspan="10" | Buy Value !! colspan="10" | Sell Value !! colspan="10" | Profit !! colspan="10" | Profit/hr !! XP !! XP/hr !! colspan="10" | Profit/XP !! KP/hr !! KP |
|||
! rowspan="2" | Level |
|||
! rowspan="2" | Potion |
|||
! colspan="2" | Reagents (plus bottle) |
|||
! colspan="10" rowspan="2" | Total Cost |
|||
! colspan="10" rowspan="2" | Sell Value |
|||
! colspan="10" rowspan="2" | Profit |
|||
! rowspan="2" | XP |
|||
! rowspan="2" | KP |
|||
! colspan="10" rowspan="2" | coins per XP |
|||
! rowspan="2" | XP/hr |
|||
! rowspan="2" | KP/hr |
|||
|- |
|- |
||
| [[File:Alchemist small icon.png|15px]] 12 || {{plink|3 Minute Potion Fear}} || {{plink|Veined Globeplant}}<br> {{plink|Faded Dandelion}}<br> || {{Currency cell|807}} || {{Currency cell|715}} || {{Currency cell|-92}} || {{Currency cell|-20918}} || {{formatnum:148}} || {{formatnum:33650}} || {{Currency cell|-0.63}} || {{formatnum:1.4}}% || {{formatnum:3.18}} |
|||
! Primary |
|||
! Secondary |
|||
|- |
|- |
||
| [[File:Alchemist small icon.png|15px]] 95 || {{plink|6 Minute Potion Fear}} || {{plink|Sunshine Dandelion}}<br> {{plink|Violet Globeplant}}<br> || {{Currency cell|5570}} || {{Currency cell|3090}} || {{Currency cell|-2480}} || {{Currency cell|-563874}} || {{formatnum:850}} || {{formatnum:193263}} || {{Currency cell|-2.92}} || {{formatnum:1.4}}% || {{formatnum:3.18}} |
|||
|- |
|- |
||
| [[File:Alchemist small icon.png|15px]] 104 || {{plink|9 Minute Potent Potion Fear}} || {{plink|Glutinous Sucker}}<br> {{plink|Squishy Toad's Eye}}<br> || {{Currency cell|967}} || {{Currency cell|3470}} || {{Currency cell|2503}} || {{Currency cell|270324}} || {{formatnum:2100}} || {{formatnum:226800}} || {{Currency cell|1.19}} || {{formatnum:3}}% || {{formatnum:3.24}} |
|||
| |
|- |
||
|{{plink|20% Potion Healing}} |
|||
| [[File:Alchemist small icon.png|15px]] 209 || {{plink|12 Minute Potion Fear}} || {{plink|Streaky Dandelion}}<br> {{plink|Brilliant Globeplant}}<br> || {{Currency cell|13310}} || {{Currency cell|5950}} || {{Currency cell|-7360}} || {{Currency cell|-1673432}} || {{formatnum:6784}} || {{formatnum:1542467}} || {{Currency cell|-1.09}} || {{formatnum:1.4}}% || {{formatnum:3.18}} |
|||
|{{plink|Brown Kelp}} |
|||
|- |
|||
|{{plink|Creamy Wallplant}} |
|||
| [[File:Alchemist small icon.png|15px]] 238 || {{plink|15 Minute Potent Potion Fear}} || {{plink|Sucky Sucker}}<br> {{plink|Bright Toad's Eye}}<br> || {{Currency cell|24320}} || {{Currency cell|12900}} || {{Currency cell|-11420}} || {{Currency cell|-1233360}} || Unknown || Unknown || colspan="10" | Unknown || {{formatnum:3}}% || {{formatnum:3.24}} |
|||
|{{Currency cell|912}} |
|||
|{{Currency cell|640}} |
|||
|{{Currency cell|-272}} |
|||
|112 |
|||
|0.5% |
|||
|{{Currency cell|-2.43}} |
|||
|33,500 |
|||
|3.14 |
|||
|} |
|} |
||
What info do I need, to be able to find the right pages |
|||
*category potion |
|||
*has a recipe |
|||
*is not passive (depends) |
|||
What information do I need to be able to fill out the table |
|||
*name for ilink |
|||
*level |
|||
*xp of final step |
|||
*kp of final step |
|||
*duration - for calculating potions/hr, for xp/hr and kp/hr |
|||
*preparation used, from which I get: |
|||
**reagents used |
|||
***name of first reagent for ilink |
|||
***name of second reagent for ilink |
|||
***price of first reagent |
|||
***price of second reagent |
|||
**xp of first step |
|||
**kp of first step |
|||
**duration of first step, feed into above calculation for potions/hr |
|||
*sell value, combined with price of 2x reagent plus bottls to get total cost |
Revision as of 14:32, 27 November 2024
Invoking Module
Copying output of module from debug
Potions per hour assumes 40 seconds resupply between each batch of 12 potions.
Level | Potion | Reagents (plus bottle) | Buy Value | Sell Value | Profit | Profit/hr | XP | XP/hr | Profit/XP | KP/hr | KP | |||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 3 Minute Potion Fear | Veined Globeplant Faded Dandelion |
807 | 715 | -92 | -20 | 918 | 148 | 33,650 | -0.63 | 1.4% | 3.18 | ||||||||||||||||||||||||||||||||||||||||||||
95 | 6 Minute Potion Fear | Sunshine Dandelion Violet Globeplant |
5 | 570 | 3 | 90 | -2 | 480 | -563 | 874 | 850 | 193,263 | -2.92 | 1.4% | 3.18 | |||||||||||||||||||||||||||||||||||||||||
104 | 9 Minute Potent Potion Fear | Glutinous Sucker Squishy Toad's Eye |
967 | 3 | 470 | 2 | 503 | 270 | 324 | 2,100 | 226,800 | 1.19 | 3% | 3.24 | ||||||||||||||||||||||||||||||||||||||||||
209 | 12 Minute Potion Fear | Streaky Dandelion Brilliant Globeplant |
13 | 310 | 5 | 950 | -7 | 360 | -1 | 673 | 432 | 6,784 | 1,542,467 | -1.09 | 1.4% | 3.18 | ||||||||||||||||||||||||||||||||||||||||
238 | 15 Minute Potent Potion Fear | Sucky Sucker Bright Toad's Eye |
24 | 320 | 12 | 900 | -11 | 420 | -1 | 233 | 360 | Unknown | Unknown | Unknown | 3% | 3.24 |