User:Jowjowjow/Sandboxxx

From Guild Wars 2 Wiki
Jump to navigationJump to search

=

that thing with droprate research table. https://wiki.guildwars2.com/index.php?title=Unsealed_Mist-Hardened_Lockbox/Drop_rate&action=edit https://wiki.guildwars2.com/index.php?search=Drop+rate+lookup+worth&title=Special:Search&profile=advanced&fulltext=1&ns0=1&ns10=1&searchToken=1ad1mi88lhn0aptz574i7ii92 https://wiki.guildwars2.com/wiki/Template:STDT https://wiki.guildwars2.com/wiki/Template:Container_research_summary_table https://wiki.guildwars2.com/wiki/Template:Drop_rate_lookup_worth_table https://wiki.guildwars2.com/wiki/Template:Drop_rate_lookup_worth

timestamp format: hh:mm, dd MM yyyy

Idea(s) for adding date filter: add date variable (yyyymmdd / stamp) to research line. Then in the summary add an optional date filter from-to. Don't suppose this can be done dynamic or must be put in a widget? e.g. hardcode in page or possibly url. Can date be extracted using regex?

Why use date (ranges): easier archive different festival years / checking for recent changes in drop rate - say, take data from the last x months/ 1 year vs all data.

Doesn't look like there's any way to extract the date from the string and convert it to a timestamp.

testing

This page is for recording the items obtained from Wintersday Gifts.

To contribute:

  • Record how many Wintersday Gift you have to start with, and then write down how many of each item you received after opening every bag.
  • Click here to start editing the data entry form.
  • Enter all of your drops.
  • Scroll down to the bottom and press "Submit data".
  • Depending on whether you have an account:
    • Logged in users will have their data submitted automatically.
    • Anonymous users will have to copy the output wikitext and paste it themselves onto this page, then press "Save page".
{{#if 17:55, 13 December 2022 (UTC) | | }} 1timestamp17:55, 13 December 2022 (UTC) 0timestamp0 {{ #arraydefine: fruits | apple, orange , banana,grape }} {{#arrayprint:fruits}} {{#invoke:String|match| abc123def456 |%d+}} {{#regex: foo 10$, Baa 21$, baa 3$ | /baa\s+\d+\s*\$/i }}
{{#if 17:55, 13 December 2022 (UTC) | | }} 1timestamp01:47, 04 January 2023 (UTC) 294timestamp0 {{ #arraydefine: fruits | apple, orange , banana,grape }} {{#arrayprint:fruits}} {{#invoke:String|match| abc123def456 |%d+}} {{#regex: foo 10$, Baa 21$, baa 3$ | /baa\s+\d+\s*\$/i }}
{{#if 17:55, 13 December 2022 (UTC) | | }} 1timestamp17:55, 13 December 2024 (UTC) 294timestamp0 {{ #arraydefine: fruits | apple, orange , banana,grape }} {{#arrayprint:fruits}} {{#invoke:String|match| abc123def456 |%d+}} {{#regex: foo 10$, Baa 21$, baa 3$ | /baa\s+\d+\s*\$/i }}
user timestamp Total Candy Cane Glass of Buttered Spirits Cup of Spiced Apple Cider Mug of Eggnog Snowflake Festive Golem Tonic Snowman Tonic Reindeer Tonic Choir Bell Angry Snowman Tonic Quartz Crystal Empyreal Fragment Festive Transom Ancient Mariner's Oilcloth Bag Enchanted Snowball Box Mini Infinirarium Mini Gift Skritt Mini Tiny Snowball Mini Toxx Recipe: Endless Plush Griffon Tonic Recipe: Endless Toy Golem Tonic Recipe: Endless Toy Soldier Tonic Recipe: Endless Toy Ventari Tonic Recipe: Endless Princess Doll Tonic Recipe: Tuning Icicle Recipe: Tin of Fruitcake Recipe: Peppermint Oil Recipe: Mintberry Swirl Ice Cream Recipe: Tropical Peppermint Cake Recipe: Peppermint Omnomberry Bar Giver's Candy Cane Axe Giver's Candy Cane Dagger Giver's Candy Cane Focus Giver's Candy Cane Greatsword Giver's Candy Cane Hammer Giver's Candy Cane Longbow Giver's Candy Cane Mace Giver's Candy Cane Pistol Giver's Candy Cane Rifle Giver's Candy Cane Scepter Giver's Candy Cane Shield Giver's Candy Cane Short Bow Giver's Candy Cane Staff Giver's Candy Cane Sword Giver's Candy Cane Torch Giver's Candy Cane Warhorn Wintersday Red Musical Bell Case Superior Sigil of Mischief Superior Sigil of Generosity Book of Festive Beverage Recipes Mini Ho-Ho-Tron Unbreakable Choir Bell (container) Mini Tiny Angry Snowball Charged Quartz Crystal Sealed Package of Snowballs Vial of Linseed Oil Rimed Verdant Wintersday Gift Mini Mystical Snowflake Mini Magical Reindeer Toy-Shell Infusion#itemct89426 Snow Diamond Infusion#itemct86405 Winter's Heart Infusion#itemct79978 Empyreal Star Endless Toymaker's Tonic Festively Wrapped Beverage Case Recipe: Light of Dwayna Recipe: Shadow of Grenth Mini Festive Golem Mini Snowman Enchanted Smiling Snowball Box Enchanted Snow Diamond Box
Adeira Tasharo 17:55, 13 December 2022 (UTC) 4 0 2 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Al3x3691 01:47, 04 January 2023 (UTC) 1000 294 241 259 271 820 8 12 8 12 18 43 71 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1
Adeira Tasharo 17:55, 13 December 2024 (UTC) 4 0 1 0 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Totals

The table below contains the complete data gathered by users from opening Wintersday Gifts.

Item Total count Average per bag
Bags opened
Total bags opened 1008 N/A
Common
Candy Cane.pngCandy Cane 294 0.292
Glass of Buttered Spirits.pngGlass of Buttered Spirits 244 0.242
Cup of Spiced Apple Cider.pngCup of Spiced Apple Cider 259 0.257
Mug of Eggnog.pngMug of Eggnog 276 0.274
Snowflake.pngSnowflake 826 0.819
Uncommon
Festive Golem Tonic.pngFestive Golem Tonic 8 0.008
Snowman Tonic.pngSnowman Tonic 12 0.012
Reindeer Tonic.pngReindeer Tonic 8 0.008
Choir Bell.pngChoir Bell 12 0.012
Angry Snowman Tonic.pngAngry Snowman Tonic 18 0.018
Quartz Crystal.pngQuartz Crystal 43 0.043
Empyreal Fragment.pngEmpyreal Fragment 71 0.07
Rare
Warmaster's Family Heirloom.pngFestive Transom 0 0
Ancient Mariner's Oilcloth Bag.pngAncient Mariner's Oilcloth Bag 0 0
Enchanted Snowball Box.pngEnchanted Snowball Box 0 0
Mini Infinirarium.pngMini Infinirarium 0 0
Mini Gift Skritt.pngMini Gift Skritt 0 0
Mini Tiny Snowball.pngMini Tiny Snowball 0 0
Mini Toxx.pngMini Toxx 0 0
Recipe sheet rare consumable 2.pngRecipe: Endless Plush Griffon Tonic 0 0
Recipe sheet rare consumable 2.pngRecipe: Endless Toy Golem Tonic 0 0
Recipe sheet rare consumable 2.pngRecipe: Endless Toy Soldier Tonic 0 0
Recipe sheet rare consumable 2.pngRecipe: Endless Toy Ventari Tonic 0 0
Recipe sheet rare consumable 2.pngRecipe: Endless Princess Doll Tonic 0 0
Recipe sheet masterwork consumable 1.pngRecipe: Tuning Icicle 0 0
Recipe sheet masterwork consumable 1.pngRecipe: Tin of Fruitcake 0 0
Recipe sheet masterwork consumable 1.pngRecipe: Peppermint Oil 0 0
Recipe sheet masterwork food.pngRecipe: Mintberry Swirl Ice Cream 1 0.001
Recipe sheet masterwork food.pngRecipe: Tropical Peppermint Cake 0 0
Recipe sheet masterwork food.pngRecipe: Peppermint Omnomberry Bar 0 0
Candy Cane Axe.pngGiver's Candy Cane Axe 0 0
Candy Cane Dagger.pngGiver's Candy Cane Dagger 0 0
Candy Cane Focus.pngGiver's Candy Cane Focus 0 0
Candy Cane Greatsword.pngGiver's Candy Cane Greatsword 0 0
Candy Cane Hammer.pngGiver's Candy Cane Hammer 0 0
Candy Cane Longbow.pngGiver's Candy Cane Longbow 0 0
Candy Cane Mace.pngGiver's Candy Cane Mace 0 0
Candy Cane Pistol.pngGiver's Candy Cane Pistol 0 0
Candy Cane Rifle.pngGiver's Candy Cane Rifle 1 0.001
Candy Cane Scepter.pngGiver's Candy Cane Scepter 0 0
Candy Cane Shield.pngGiver's Candy Cane Shield 0 0
Candy Cane Short Bow.pngGiver's Candy Cane Short Bow 0 0
Candy Cane Staff.pngGiver's Candy Cane Staff 0 0
Candy Cane Sword.pngGiver's Candy Cane Sword 0 0
Candy Cane Torch.pngGiver's Candy Cane Torch 1 0.001
Candy Cane Warhorn.pngGiver's Candy Cane Warhorn 0 0
Wintersday Red Musical Bell Case.pngWintersday Red Musical Bell Case 0 0
Superior Sigil of Mischief.pngSuperior Sigil of Mischief 0 0
Superior Sigil of Generosity.pngSuperior Sigil of Generosity 0 0
Memoirs of Captain Greywind.pngBook of Festive Beverage Recipes 0 0
Mini Ho-Ho-Tron.pngMini Ho-Ho-Tron 0 0
Choir Bell.pngUnbreakable Choir Bell 0 0
Mini Tiny Angry Snowball.pngMini Tiny Angry Snowball 0 0
Charged Quartz Crystal.pngCharged Quartz Crystal 0 0
Sealed Package of Snowballs.pngSealed Package of Snowballs 1 0.001
Fish Oil.pngVial of Linseed Oil 3 0.003
Rimed Verdant Wintersday Gift.pngRimed Verdant Wintersday Gift 1 0.001
Mini Mystical Snowflake.pngMini Mystical Snowflake 0 0
Mini Magical Reindeer.pngMini Magical Reindeer 0 0
Super Rare
Toy-Shell Infusion.pngToy-Shell Infusion (Healing Power) 0 0
Snow Diamond Infusion.pngSnow Diamond Infusion (Healing Power) 0 0
Winter's Heart Infusion.pngWinter's Heart Infusion (Healing Power) 0 0
Empyreal Star.pngEmpyreal Star 0 0
Endless Toymaker's Tonic.pngEndless Toymaker's Tonic 0 0
Festively Wrapped Beverage Case.pngFestively Wrapped Beverage Case 0 0
Recipe sheet ascended back.pngRecipe: Light of Dwayna 0 0
Recipe sheet ascended back.pngRecipe: Shadow of Grenth 0 0
Mini Festive Golem.pngMini Festive Golem 0 0
Mini Snowman.pngMini Snowman 0 0
Enchanted Smiling Snowball Box.pngEnchanted Smiling Snowball Box 0 0
Enchanted Snow Diamond Box.pngEnchanted Snow Diamond Box 1 0.001

With super rare drops

  • Based on the drop rate research including super rare drops, a Jowjowjow is currently worth (TP buy price) and (TP sell price).Disclaimer
Rate Drop TP buy price Subtotal
0.819 Snowflake.pngSnowflake ... ...
0.292 Candy Cane.pngCandy Cane ... ...
0.274 Mug of Eggnog.pngMug of Eggnog ... ...
0.257 Cup of Spiced Apple Cider.pngCup of Spiced Apple Cider ... ...
0.242 Glass of Buttered Spirits.pngGlass of Buttered Spirits ... ...
0.07 Empyreal Fragment.pngEmpyreal Fragment ... ...
0.043 Quartz Crystal.pngQuartz Crystal ... ...
0.018 Angry Snowman Tonic.pngAngry Snowman Tonic ... ...
0.012 Choir Bell.pngChoir Bell ... ...
0.012 Snowman Tonic.pngSnowman Tonic ... ...
0.008 Festive Golem Tonic.pngFestive Golem Tonic ... ...
0.008 Reindeer Tonic.pngReindeer Tonic ... ...
0.003 Fish Oil.pngVial of Linseed Oil ... ...
0.001 Enchanted Snow Diamond Box.pngEnchanted Snow Diamond Box ... ...
0.001 Candy Cane Rifle.pngGiver's Candy Cane Rifle ... ...
0.001 Candy Cane Torch.pngGiver's Candy Cane Torch ... ...
0.001 Recipe sheet masterwork food.pngRecipe: Mintberry Swirl Ice Cream ... ...
0.001 Rimed Verdant Wintersday Gift.pngRimed Verdant Wintersday Gift ... ...
0.001 Sealed Package of Snowballs.pngSealed Package of Snowballs ... ...
0 Ancient Mariner's Oilcloth Bag.pngAncient Mariner's Oilcloth Bag ... ...
0 Memoirs of Captain Greywind.pngBook of Festive Beverage Recipes ... ...
0 Charged Quartz Crystal.pngCharged Quartz Crystal ... ...
0 Empyreal Star.pngEmpyreal Star ... ...
0 Enchanted Smiling Snowball Box.pngEnchanted Smiling Snowball Box ... ...
0 Enchanted Snowball Box.pngEnchanted Snowball Box ... ...
0 Endless Toymaker's Tonic.pngEndless Toymaker's Tonic ... ...
0 Warmaster's Family Heirloom.pngFestive Transom ... ...
0 Festively Wrapped Beverage Case.pngFestively Wrapped Beverage Case ... ...
0 Candy Cane Axe.pngGiver's Candy Cane Axe ... ...
0 Candy Cane Dagger.pngGiver's Candy Cane Dagger ... ...
0 Candy Cane Focus.pngGiver's Candy Cane Focus ... ...
0 Candy Cane Greatsword.pngGiver's Candy Cane Greatsword ... ...
0 Candy Cane Hammer.pngGiver's Candy Cane Hammer ... ...
0 Candy Cane Longbow.pngGiver's Candy Cane Longbow ... ...
0 Candy Cane Mace.pngGiver's Candy Cane Mace ... ...
0 Candy Cane Pistol.pngGiver's Candy Cane Pistol ... ...
0 Candy Cane Scepter.pngGiver's Candy Cane Scepter ... ...
0 Candy Cane Shield.pngGiver's Candy Cane Shield ... ...
0 Candy Cane Short Bow.pngGiver's Candy Cane Short Bow ... ...
0 Candy Cane Staff.pngGiver's Candy Cane Staff ... ...
0 Candy Cane Sword.pngGiver's Candy Cane Sword ... ...
0 Candy Cane Warhorn.pngGiver's Candy Cane Warhorn ... ...
0 Mini Festive Golem.pngMini Festive Golem ... ...
0 Mini Gift Skritt.pngMini Gift Skritt ... ...
0 Mini Ho-Ho-Tron.pngMini Ho-Ho-Tron ... ...
0 Mini Infinirarium.pngMini Infinirarium ... ...
0 Mini Magical Reindeer.pngMini Magical Reindeer ... ...
0 Mini Mystical Snowflake.pngMini Mystical Snowflake ... ...
0 Mini Snowman.pngMini Snowman ... ...
0 Mini Tiny Angry Snowball.pngMini Tiny Angry Snowball ... ...
0 Mini Tiny Snowball.pngMini Tiny Snowball ... ...
0 Mini Toxx.pngMini Toxx ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Plush Griffon Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Princess Doll Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Toy Golem Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Toy Soldier Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Toy Ventari Tonic ... ...
0 Recipe sheet ascended back.pngRecipe: Light of Dwayna ... ...
0 Recipe sheet masterwork consumable 1.pngRecipe: Peppermint Oil ... ...
0 Recipe sheet masterwork food.pngRecipe: Peppermint Omnomberry Bar ... ...
0 Recipe sheet ascended back.pngRecipe: Shadow of Grenth ... ...
0 Recipe sheet masterwork consumable 1.pngRecipe: Tin of Fruitcake ... ...
0 Recipe sheet masterwork food.pngRecipe: Tropical Peppermint Cake ... ...
0 Recipe sheet masterwork consumable 1.pngRecipe: Tuning Icicle ... ...
0 Snow Diamond Infusion.pngSnow Diamond Infusion (Healing Power) ... ...
0 Superior Sigil of Generosity.pngSuperior Sigil of Generosity ... ...
0 Superior Sigil of Mischief.pngSuperior Sigil of Mischief ... ...
0 Toy-Shell Infusion.pngToy-Shell Infusion (Healing Power) ... ...
0 Choir Bell.pngUnbreakable Choir Bell ... ...
0 Winter's Heart Infusion.pngWinter's Heart Infusion (Healing Power) ... ...
0 Wintersday Red Musical Bell Case.pngWintersday Red Musical Bell Case ... ...
Grand total ...
Rate Drop TP sell price Subtotal
0.819 Snowflake.pngSnowflake ... ...
0.292 Candy Cane.pngCandy Cane ... ...
0.274 Mug of Eggnog.pngMug of Eggnog ... ...
0.257 Cup of Spiced Apple Cider.pngCup of Spiced Apple Cider ... ...
0.242 Glass of Buttered Spirits.pngGlass of Buttered Spirits ... ...
0.07 Empyreal Fragment.pngEmpyreal Fragment ... ...
0.043 Quartz Crystal.pngQuartz Crystal ... ...
0.018 Angry Snowman Tonic.pngAngry Snowman Tonic ... ...
0.012 Choir Bell.pngChoir Bell ... ...
0.012 Snowman Tonic.pngSnowman Tonic ... ...
0.008 Festive Golem Tonic.pngFestive Golem Tonic ... ...
0.008 Reindeer Tonic.pngReindeer Tonic ... ...
0.003 Fish Oil.pngVial of Linseed Oil ... ...
0.001 Enchanted Snow Diamond Box.pngEnchanted Snow Diamond Box ... ...
0.001 Candy Cane Rifle.pngGiver's Candy Cane Rifle ... ...
0.001 Candy Cane Torch.pngGiver's Candy Cane Torch ... ...
0.001 Recipe sheet masterwork food.pngRecipe: Mintberry Swirl Ice Cream ... ...
0.001 Rimed Verdant Wintersday Gift.pngRimed Verdant Wintersday Gift ... ...
0.001 Sealed Package of Snowballs.pngSealed Package of Snowballs ... ...
0 Ancient Mariner's Oilcloth Bag.pngAncient Mariner's Oilcloth Bag ... ...
0 Memoirs of Captain Greywind.pngBook of Festive Beverage Recipes ... ...
0 Charged Quartz Crystal.pngCharged Quartz Crystal ... ...
0 Empyreal Star.pngEmpyreal Star ... ...
0 Enchanted Smiling Snowball Box.pngEnchanted Smiling Snowball Box ... ...
0 Enchanted Snowball Box.pngEnchanted Snowball Box ... ...
0 Endless Toymaker's Tonic.pngEndless Toymaker's Tonic ... ...
0 Warmaster's Family Heirloom.pngFestive Transom ... ...
0 Festively Wrapped Beverage Case.pngFestively Wrapped Beverage Case ... ...
0 Candy Cane Axe.pngGiver's Candy Cane Axe ... ...
0 Candy Cane Dagger.pngGiver's Candy Cane Dagger ... ...
0 Candy Cane Focus.pngGiver's Candy Cane Focus ... ...
0 Candy Cane Greatsword.pngGiver's Candy Cane Greatsword ... ...
0 Candy Cane Hammer.pngGiver's Candy Cane Hammer ... ...
0 Candy Cane Longbow.pngGiver's Candy Cane Longbow ... ...
0 Candy Cane Mace.pngGiver's Candy Cane Mace ... ...
0 Candy Cane Pistol.pngGiver's Candy Cane Pistol ... ...
0 Candy Cane Scepter.pngGiver's Candy Cane Scepter ... ...
0 Candy Cane Shield.pngGiver's Candy Cane Shield ... ...
0 Candy Cane Short Bow.pngGiver's Candy Cane Short Bow ... ...
0 Candy Cane Staff.pngGiver's Candy Cane Staff ... ...
0 Candy Cane Sword.pngGiver's Candy Cane Sword ... ...
0 Candy Cane Warhorn.pngGiver's Candy Cane Warhorn ... ...
0 Mini Festive Golem.pngMini Festive Golem ... ...
0 Mini Gift Skritt.pngMini Gift Skritt ... ...
0 Mini Ho-Ho-Tron.pngMini Ho-Ho-Tron ... ...
0 Mini Infinirarium.pngMini Infinirarium ... ...
0 Mini Magical Reindeer.pngMini Magical Reindeer ... ...
0 Mini Mystical Snowflake.pngMini Mystical Snowflake ... ...
0 Mini Snowman.pngMini Snowman ... ...
0 Mini Tiny Angry Snowball.pngMini Tiny Angry Snowball ... ...
0 Mini Tiny Snowball.pngMini Tiny Snowball ... ...
0 Mini Toxx.pngMini Toxx ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Plush Griffon Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Princess Doll Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Toy Golem Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Toy Soldier Tonic ... ...
0 Recipe sheet rare consumable 2.pngRecipe: Endless Toy Ventari Tonic ... ...
0 Recipe sheet ascended back.pngRecipe: Light of Dwayna ... ...
0 Recipe sheet masterwork consumable 1.pngRecipe: Peppermint Oil ... ...
0 Recipe sheet masterwork food.pngRecipe: Peppermint Omnomberry Bar ... ...
0 Recipe sheet ascended back.pngRecipe: Shadow of Grenth ... ...
0 Recipe sheet masterwork consumable 1.pngRecipe: Tin of Fruitcake ... ...
0 Recipe sheet masterwork food.pngRecipe: Tropical Peppermint Cake ... ...
0 Recipe sheet masterwork consumable 1.pngRecipe: Tuning Icicle ... ...
0 Snow Diamond Infusion.pngSnow Diamond Infusion (Healing Power) ... ...
0 Superior Sigil of Generosity.pngSuperior Sigil of Generosity ... ...
0 Superior Sigil of Mischief.pngSuperior Sigil of Mischief ... ...
0 Toy-Shell Infusion.pngToy-Shell Infusion (Healing Power) ... ...
0 Choir Bell.pngUnbreakable Choir Bell ... ...
0 Winter's Heart Infusion.pngWinter's Heart Infusion (Healing Power) ... ...
0 Wintersday Red Musical Bell Case.pngWintersday Red Musical Bell Case ... ...
Grand total ...