User:Alsang/Sandbox: Difference between revisions

no edit summary
No edit summary
No edit summary
(30 intermediate revisions by the same user not shown)
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"
! 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}}
|2-
|{{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
904

edits