User:Alsang/Sandbox: Difference between revisions

From Brighter Shores Wiki
Jump to navigation Jump to search
Content added Content deleted
No edit summary
No edit summary
(29 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==


{| class="wikitable sortable"
{| class="wikitable sortable"
! Level !! Potion !! Reagents (plus bottle) !! colspan="10" | Buy Value !! colspan="10" | Sell Value !! colspan="10" | Profit !! XP !! KP !! colspan="10" | Profit/XP !! XP/hr !! KP/hr !! colspan="10" | Profit/hr
! 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}} || {{formatnum:148}} || {{formatnum:1.4}}% || {{Currency cell|-0.63}} || {{formatnum:33650}} || {{formatnum:3.18}} || {{Currency cell|-20918}}
! 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}} || {{formatnum:850}} || {{formatnum:1.4}}% || {{Currency cell|-2.92}} || {{formatnum:193263}} || {{formatnum:3.18}} || {{Currency cell|-563874}}
|-
|-
| [[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}} || {{formatnum:2100}} || {{formatnum:3}}% || {{Currency cell|1.19}} || {{formatnum:226800}} || {{formatnum:3.24}} || {{Currency cell|270324}}
|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}} || {{formatnum:6784}} || {{formatnum:1.4}}% || {{Currency cell|-1.09}} || {{formatnum:1542467}} || {{formatnum:3.18}} || {{Currency cell|-1673432}}
|{{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}} || Unknown || {{formatnum:3}}% || colspan="10" | Unknown || Unknown || {{formatnum:3.24}} || {{Currency cell|-1233360}}
|{{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:27, 27 November 2024

Invoking Module

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 KP/hr
12 3 Minute Potion Fear}} Veined Globeplant}}
{{plink|Faded Dandelion}}
807}} 715}} -92}} -20918}} {{formatnum:148}} {{formatnum:33650}} -0.63}} {{formatnum:1.4}}% {{formatnum:3.18}}
95 6 Minute Potion Fear}} Sunshine Dandelion}}
{{plink|Violet Globeplant}}
5570}} 3090}} -2480}} -563874}} {{formatnum:850}} {{formatnum:193263}} -2.92}} {{formatnum:1.4}}% {{formatnum:3.18}}
104 9 Minute Potent Potion Fear}} Glutinous Sucker}}
{{plink|Squishy Toad's Eye}}
967}} 3470}} 2503}} 270324}} {{formatnum:2100}} {{formatnum:226800}} 1.19}} {{formatnum:3}}% {{formatnum:3.24}}
209 12 Minute Potion Fear}} Streaky Dandelion}}
{{plink|Brilliant Globeplant}}
13310}} 5950}} -7360}} -1673432}} {{formatnum:6784}} {{formatnum:1542467}} -1.09}} {{formatnum:1.4}}% {{formatnum:3.18}}
238 15 Minute Potent Potion Fear}} Sucky Sucker}}
{{plink|Bright Toad's Eye}}
24320}} 12900}} -11420}} -1233360}} Unknown Unknown Unknown {{formatnum:3}}% {{formatnum:3.24}}

Copying output of module from debug

Level Potion Reagents (plus bottle) Buy Value Sell Value Profit XP KP Profit/XP XP/hr KP/hr Profit/hr
12 3 Minute Potion Fear Veined Globeplant
Faded Dandelion
807 Copper 715 Copper -92 Copper 148 1.4% -0.63 Copper 33,650 3.18 -20 Silver 918 Copper
95 6 Minute Potion Fear Sunshine Dandelion
Violet Globeplant
5 Silver 570 Copper 3 Silver 90 Copper -2 Silver 480 Copper 850 1.4% -2.92 Copper 193,263 3.18 -563 Silver 874 Copper
104 9 Minute Potent Potion Fear Glutinous Sucker
Squishy Toad's Eye
967 Copper 3 Silver 470 Copper 2 Silver 503 Copper 2,100 3% 1.19 Copper 226,800 3.24 270 Silver 324 Copper
209 12 Minute Potion Fear Streaky Dandelion
Brilliant Globeplant
13 Silver 310 Copper 5 Silver 950 Copper -7 Silver 360 Copper 6,784 1.4% -1.09 Copper 1,542,467 3.18 -1 Gold 673 Silver 432 Copper
238 15 Minute Potent Potion Fear Sucky Sucker
Bright Toad's Eye
24 Silver 320 Copper 12 Silver 900 Copper -11 Silver 420 Copper Unknown 3% Unknown Unknown 3.24 -1 Gold 233 Silver 360 Copper