Jump to content

User:Pangaea/Artisan Jars vs Kegs: Difference between revisions

From Stardew Valley Wiki
← Older editNewer edit →
imported>Pangaea
Darnit, doesn't look like it works correctly without a template, function is only run once, and therefore doesn't replace values
imported>Pangaea
Function works, but that isn't feasible in every cell
Line 72: Line 72:
|data-sort-value="2" style="text-align: left;"|[[File:Gold Quality.png|16px|link=]] Gold
|data-sort-value="2" style="text-align: left;"|[[File:Gold Quality.png|16px|link=]] Gold
|247||490||{{ #arraydefine: jarday | 98||print}}||471||{{ #arraydefine: kegday | 59||print}}
|247||490||{{ #arraydefine: jarday | 98||print}}||471||{{ #arraydefine: kegday | 59||print}}
|{{#iferror: {{#ifexpr: {{ #arrayprint: jarday }} > {{ #arrayprint: kegday }} }} | MOTHER OF GOD, THERE WAS AN ERROR!!!1!! | {{#ifexpr: {{ #arrayprint: jarday }} > {{ #arrayprint: kegday }} | [[File:Preserves Jar.png|x24px|link=]] at +{{ #expr: ({{#arrayprint: jarday }}-{{#arrayprint: kegday }}) / {{#arrayprint: kegday }} *100 round 2 }}% | [[File:Keg.png|x24px|link=]] at +{{ #expr: ({{#arrayprint: kegday }}-{{#arrayprint: jarday }}) / {{#arrayprint: jarday }} *100 round 2 }}% }} }}
|-
|-
|style="text-align: left;"|{{name|Amaranth}}
|style="text-align: left;"|{{name|Amaranth}}
Line 77: Line 78:
|data-sort-value="3" style="text-align: left;"|[[File:Iridium Quality.png|16px|link=]] Iridium
|data-sort-value="3" style="text-align: left;"|[[File:Iridium Quality.png|16px|link=]] Iridium
|330||490||{{ #arraydefine: jarday | 64||print}}||471||{{ #arraydefine: kegday | 38||print}}
|330||490||{{ #arraydefine: jarday | 64||print}}||471||{{ #arraydefine: kegday | 38||print}}
|{{#iferror: {{#ifexpr: {{ #arrayprint: jarday }} > {{ #arrayprint: kegday }} }} | MOTHER OF GOD, THERE WAS AN ERROR!!!1!! | {{#ifexpr: {{ #arrayprint: jarday }} > {{ #arrayprint: kegday }} | [[File:Preserves Jar.png|x24px|link=]] at +{{ #expr: ({{#arrayprint: jarday }}-{{#arrayprint: kegday }}) / {{#arrayprint: kegday }} *100 round 2 }}% | [[File:Keg.png|x24px|link=]] at +{{ #expr: ({{#arrayprint: kegday }}-{{#arrayprint: jarday }}) / {{#arrayprint: jarday }} *100 round 2 }}% }} }}
|-
|-
|style="text-align: left;"|{{name|Ancient Fruit}}
|style="text-align: left;"|{{name|Ancient Fruit}}

Revision as of 21:03, 9 September 2022

This is an attempt at directly comparing the profitability of Preserves Jars and Kegs, based on processing time instead of increase in value. Couldn't find a way to merge wikitables, so had to "borrow" a page on MediaWiki since they have visual editing capability there, which makes it much easier to mass edit tables in this fashion by outright deleting a few columns and creating new ones. Sadly it didn't work to copy back in whole columns, so seems like the rest of the process must be done manually. This is where Cargo or DPL would have been real handy, so that is something to think about for future games.

{{ #arraydefine: array name | array values | delimiter (defaults to comma) | options }}
{{#arrayprint:key|delimiter|pattern|subject|options}}
{{#expr: expression }}
{{#ifexpr: expression | value if true | value if false }}
{{#iferror: test string | value if error | value if correct }}

Tests

Simple test

25
12.5

Multiple array test

a is smaller than b


a is bigger than b


The keg is most profitable


The keg is +0.08% more profitable


Most profitable in g/day: at +14.29%

Array-function test

at +0.4%


Small-ish table test

Input Item Type Quality Input Item Sell Price Processed in Preserves Jar Sell Price Approximate g/day in Preserves Jar [1] Processed in Keg Sell Price Approximate g/day in Keg [1] Most Profitable
Amaranth Veg Regular 165 490 130 471 82 at +0.4%
Amaranth Veg Silver 205 490 114 471 70 at +0.4%
Amaranth Veg Gold 247 490 98 471 59 at +66.1%
Amaranth Veg Iridium 330 490 64 471 38 at +68.42%
Ancient Fruit Fruit Regular 605 1610 402 2310 274
Ancient Fruit Fruit Silver 755 1610 342 2310 250
Ancient Fruit Fruit Gold 907 1610 282 2310 224
Ancient Fruit Fruit Iridium 1210 1610 160 2310 176




The full table

Input Item Type Quality Input Item Sell Price Processed in Preserves Jar Sell Price Approximate g/day in Preserves Jar [1] Processed in Keg Sell Price Approximate g/day in Keg [1]
Amaranth Veg Regular 165 490 130 471 82
Amaranth Veg Silver 205 490 114 471 70
Amaranth Veg Gold 247 490 98 471 59
Amaranth Veg Iridium 330 490 64 471 38
Ancient Fruit Fruit Regular 605 1610 402 2310 274
Ancient Fruit Fruit Silver 755 1610 342 2310 250
Ancient Fruit Fruit Gold 907 1610 282 2310 224
Ancient Fruit Fruit Iridium 1210 1610 160 2310 176
Apple Fruit Regular 110 350 96 420 50
Apple Fruit Silver 137 350 85 420 45
Apple Fruit Gold 165 350 74 420 42
Apple Fruit Iridium 220 350 53 420 32
Apricot Fruit Regular 55 210 62 210 26
Apricot Fruit Silver 68 210 58 210 22
Apricot Fruit Gold 82 210 51 210 21
Apricot Fruit Iridium 110 210 40 210 16
Artichoke Veg Regular 176 518 138 504 88
Artichoke Veg Silver 220 518 120 504 75
Artichoke Veg Gold 264 518 102 504 64
Artichoke Veg Iridium 352 518 67 504 40
Banana Fruit Regular 165 490 130 630 75
Banana Fruit Silver 205 490 114 630 69
Banana Fruit Gold 247 490 98 630 61
Banana Fruit Iridium 330 490 64 630 48
Beet Veg Regular 110 350 96 315 54
Beet Veg Silver 137 350 85 315 48
Beet Veg Gold 165 350 74 315 40
Beet Veg Iridium 220 350 53 315 26
Blackberry [2] Fruit Regular 20 126 43 84 10
Blackberry [2] Fruit Silver 25 126 40 84 10
Blackberry [2] Fruit Gold 30 126 38 84 8
Blackberry [2] Fruit Iridium 40 126 35 84 6
Blackberry Fruit Regular 22 126 42 84 10
Blackberry Fruit Iridium 44 126 34 84 6
Blackberry [2] with Bear's Knowledge Fruit Regular 60 126 27 84 3
Blackberry [2] with Bear's Knowledge Fruit Silver 75 126 21 84 2
Blackberry [2] with Bear's Knowledge Fruit Gold 90 126 14 84 -2
Blackberry [2] with Bear's Knowledge Fruit Iridium 120 126 3 84 -6
Blackberry with Bear's Knowledge Fruit Regular 66 126 24 84 3
Blackberry with Bear's Knowledge Fruit Iridium 132 126 -3 84 -8
Blueberry Fruit Regular 55 210 62 210 26
Blueberry Fruit Silver 68 210 58 210 22
Blueberry Fruit Gold 82 210 51 210 21
Blueberry Fruit Iridium 110 210 40 210 16
Bok Choy Veg Regular 88 294 83 252 43
Bok Choy Veg Silver 110 294 74 252 38
Bok Choy Veg Gold 132 294 66 252 32
Bok Choy Veg Iridium 176 294 48 252 21
Cactus Fruit [2] Fruit Regular 75 280 82 315 38
Cactus Fruit [2] Fruit Silver 93 280 75 315 35
Cactus Fruit [2] Fruit Gold 112 280 67 315 32
Cactus Fruit [2] Fruit Iridium 150 280 53 315 27
Cactus Fruit Fruit Regular 82 280 80 315 37
Cactus Fruit Fruit Silver 102 280 72 315 34
Cactus Fruit Fruit Gold 123 280 62 315 30
Cactus Fruit Fruit Iridium 165 280 46 315 24
Cauliflower Veg Regular 192 560 147 550 96
Cauliflower Veg Silver 239 560 128 550 83
Cauliflower Veg Gold 288 560 109 550 70
Cauliflower Veg Iridium 385 560 70 550 45
Cherry Fruit Regular 88 294 83 336 40
Cherry Fruit Silver 110 294 74 336 37
Cherry Fruit Gold 132 294 66 336 32
Cherry Fruit Iridium 176 294 48 336 26
Coconut [2] Fruit Regular 100 350 101 420 51
Coconut [2] Fruit Silver 125 350 90 420 48
Coconut [2] Fruit Gold 150 350 80 420 43
Coconut [2] Fruit Iridium 200 350 61 420 35
Coffee Bean [3] Seed Regular 75 [5] N/A N/A 150 1000
Coffee Bean [3] Seed Silver 90 [5] N/A N/A 150 800
Coffee Bean [3] Seed Gold 110 [5] N/A N/A 150 533
Coffee Bean [3] Seed Iridium 150 [5] N/A N/A 150 0
Corn Veg Regular 55 210 62 156 27
Corn Veg Silver 68 210 58 156 24
Corn Veg Gold 82 210 51 156 19
Corn Veg Iridium 110 210 40 156 13
Cranberries Fruit Regular 82 280 80 315 37
Cranberries Fruit Silver 102 280 72 315 34
Cranberries Fruit Gold 123 280 62 315 30
Cranberries Fruit Iridium 165 280 46 315 24
Crystal Fruit [2] Fruit Regular 150 490 136 630 77
Crystal Fruit [2] Fruit Silver 187 490 122 630 70
Crystal Fruit [2] Fruit Gold 225 490 106 630 66
Crystal Fruit [2] Fruit Iridium 300 490 77 630 53
Eggplant Veg Regular 66 238 69 189 58
Eggplant Veg Silver 82 238 62 189 53
Eggplant Veg Gold 99 238 56 189 50
Eggplant Veg Iridium 132 238 43 189 40
Fiddlehead Fern Veg Regular 99 322 90 282 50
Fiddlehead Fern Veg Silver 123 322 80 282 43
Fiddlehead Fern Veg Gold 148 322 70 282 35
Fiddlehead Fern Veg Iridium 198 322 50 282 22
Garlic Veg Regular 66 238 69 189 34
Garlic Veg Silver 82 238 62 189 29
Garlic Veg Gold 99 238 56 189 24
Garlic Veg Iridium 132 238 43 189 16
Ginger [2] Forage Regular 60 238 72 N/A N/A
Grape [2] Fruit Regular 80 294 86 336 42
Grape [2] Fruit Silver 100 294 78 336 38
Grape [2] Fruit Gold 120 294 70 336 35
Grape [2] Fruit Iridium 160 294 54 336 29
Grape Fruit Regular 88 294 83 336 40
Grape Fruit Silver 110 294 74 336 37
Grape Fruit Gold 132 294 66 336 32
Grape Fruit Iridium 176 294 48 336 26
Green Bean Veg Regular 44 182 56 126 22
Green Bean Veg Silver 55 182 51 126 19
Green Bean Veg Gold 66 182 46 126 16
Green Bean Veg Iridium 88 182 38 126 10
Honey - Blue Jazz [4] Honey Regular 200 N/A N/A 280 213
Honey - Fairy Rose [4] Honey Regular 680 N/A N/A 280 -1067
Honey - Poppy [4] Honey Regular 380 N/A N/A 280 -267
Honey - Summer Spangle [4] Honey Regular 280 N/A N/A 280 0
Honey - Sunflower [4] Honey Regular 260 N/A N/A 280 53
Honey - Tulip [4] Honey Regular 160 N/A N/A 280 320
Honey - Wild [4] Honey Regular 100 N/A N/A 280 480
Hops Veg Regular 27 140 45 420 280
Hops Veg Silver 34 140 43 420 275
Hops Veg Gold 40 140 40 420 270
Hops Veg Iridium 55 140 34 420 259
Hot Pepper Fruit Regular 44 182 56 168 19
Hot Pepper Fruit Silver 55 182 51 168 18
Hot Pepper Fruit Gold 66 182 46 168 16
Hot Pepper Fruit Iridium 88 182 38 168 13
Kale Veg Regular 121 378 102 345 59
Kale Veg Silver 150 378 91 345 53
Kale Veg Gold 181 378 78 345 43
Kale Veg Iridium 242 378 54 345 27
Mango Fruit Regular 143 434 117 546 64
Mango Fruit Silver 178 434 102 546 59
Mango Fruit Gold 214 434 88 546 53
Mango Fruit Iridium 286 434 59 546 42
Melon Fruit Regular 275 770 198 1050 125
Melon Fruit Silver 343 770 171 1050 114
Melon Fruit Gold 412 770 144 1050 102
Melon Fruit Iridium 550 770 88 1050 80
Orange Fruit Regular 110 350 96 420 50
Orange Fruit Silver 137 350 85 420 45
Orange Fruit Gold 165 350 74 420 42
Orange Fruit Iridium 220 350 53 420 32
Parsnip Veg Regular 38 168 53 109 19
Parsnip Veg Silver 47 168 48 109 16
Parsnip Veg Gold 57 168 45 109 14
Parsnip Veg Iridium 77 168 37 109 8
Peach Fruit Regular 154 462 123 588 69
Peach Fruit Silver 192 462 109 588 64
Peach Fruit Gold 231 462 93 588 58
Peach Fruit Iridium 308 462 62 588 45
Pineapple Fruit Regular 330 910 232 1260 149
Pineapple Fruit Silver 412 910 200 1260 136
Pineapple Fruit Gold 495 910 166 1260 123
Pineapple Fruit Iridium 660 910 101 1260 96
Pomegranate Fruit Regular 154 462 123 588 69
Pomegranate Fruit Silver 192 462 109 588 64
Pomegranate Fruit Gold 231 462 93 588 58
Pomegranate Fruit Iridium 308 462 62 588 45
Potato Veg Regular 88 294 83 252 43
Potato Veg Silver 110 294 74 252 38
Potato Veg Gold 132 294 66 252 32
Potato Veg Iridium 176 294 48 252 21
Pumpkin Veg Regular 352 966 246 1008 174
Pumpkin Veg Silver 440 966 211 1008 152
Pumpkin Veg Gold 528 966 176 1008 128
Pumpkin Veg Iridium 704 966 106 1008 82
Qi Fruit Fruit Regular 1 72 29 4 0
Radish Veg Regular 99 322 90 282 50
Radish Veg Silver 123 322 80 282 43
Radish Veg Gold 148 322 70 282 35
Radish Veg Iridium 198 322 50 282 22
Red Cabbage Veg Regular 286 798 205 819 142
Red Cabbage Veg Silver 357 798 176 819 123
Red Cabbage Veg Gold 429 798 147 819 104
Red Cabbage Veg Iridium 572 798 91 819 66
Rhubarb Fruit Regular 242 686 178 924 109
Rhubarb Fruit Silver 302 686 154 924 99
Rhubarb Fruit Gold 363 686 130 924 90
Rhubarb Fruit Iridium 484 686 82 924 70
Salmonberry [2] Fruit Regular 5 84 32 21 3
Salmonberry [2] Fruit Silver 6 84 32 21 3
Salmonberry [2] Fruit Gold 7 84 30 21 2
Salmonberry [2] Fruit Iridium 10 84 30 21 2
Salmonberry Fruit Regular 5 84 32 21 3
Salmonberry Fruit Iridium 11 84 29 21 2
Salmonberry [2] with Bear's Knowledge Fruit Regular 15 84 27 21 2
Salmonberry [2] with Bear's Knowledge Fruit Silver 18 84 27 21 0
Salmonberry [2] with Bear's Knowledge Fruit Gold 21 84 26 21 0
Salmonberry [2] with Bear's Knowledge Fruit Iridium 30 84 22 21 -2
Salmonberry with Bear's Knowledge Fruit Regular 16 84 27 21 2
Salmonberry with Bear's Knowledge Fruit Iridium 33 84 21 21 -2
Spice Berry [2] Fruit Regular 80 294 86 336 42
Spice Berry [2] Fruit Silver 100 294 78 336 38
Spice Berry [2] Fruit Gold 120 294 70 336 35
Spice Berry [2] Fruit Iridium 160 294 54 336 29
Starfruit Fruit Regular 825 2170 538 3150 373
Starfruit Fruit Silver 1030 2170 456 3150 339
Starfruit Fruit Gold 1237 2170 373 3150 306
Starfruit Fruit Iridium 1650 2170 208 3150 240
Strawberry Fruit Regular 132 406 110 504 59
Strawberry Fruit Silver 165 406 96 504 54
Strawberry Fruit Gold 198 406 83 504 50
Strawberry Fruit Iridium 264 406 58 504 38
Taro Root Veg Regular 110 350 96 315 54
Taro Root Veg Silver 137 350 85 315 48
Taro Root Veg Gold 165 350 74 315 40
Taro Root Veg Iridium 220 350 53 315 26
Tea Leaves Veg Regular 55 210 62 140 755
Tomato Veg Regular 66 238 69 189 34
Tomato Veg Silver 82 238 62 189 29
Tomato Veg Gold 99 238 56 189 24
Tomato Veg Iridium 132 238 43 189 16
Unmilled Rice Veg Regular 33 154 48 93 16
Unmilled Rice Veg Silver 40 154 46 93 14
Unmilled Rice Veg Gold 49 154 42 93 11
Unmilled Rice Veg Iridium 66 154 35 93 8
Wheat Veg Regular 27 140 45 280 232
Wheat Veg Silver 34 140 43 280 226
Wheat Veg Gold 40 140 40 280 219
Wheat Veg Iridium 55 140 34 280 206
Wild Plum [2] Fruit Regular 80 294 86 336 42
Wild Plum [2] Fruit Silver 100 294 78 336 38
Wild Plum [2] Fruit Gold 120 294 70 336 35
Wild Plum [2] Fruit Iridium 160 294 54 336 29
Yam Veg Regular 176 518 138 504 88
Yam Veg Silver 220 518 120 504 75
Yam Veg Gold 264 518 102 504 64
Yam Veg Iridium 352 518 67 504 40
Albacore Roe [3] Roe Regular 67 187 48 N/A N/A
Anchovy Roe [3] Roe Regular 45 126 32 N/A N/A
Blobfish Roe [3] Roe Regular 280 784 202 N/A N/A
Blue Discus Roe [3] Roe Regular 90 252 66 N/A N/A
Bream Roe [3] Roe Regular 52 145 37 N/A N/A
Bullhead Roe [3] Roe Regular 67 187 48 N/A N/A
Carp Roe [3] Roe Regular 45 126 32 N/A N/A
Catfish Roe [3] Roe Regular 130 364 94 N/A N/A
Chub Roe [3] Roe Regular 55 154 40 N/A N/A
Cockle Roe [3] Roe Regular 55 154 40 N/A N/A
Crab Roe [3] Roe Regular 80 224 58 N/A N/A
Crayfish Roe [3] Roe Regular 67 187 48 N/A N/A
Dorado Roe [3] Roe Regular 80 224 58 N/A N/A
Eel Roe [3] Roe Regular 72 201 51 N/A N/A
Flounder Roe [3] Roe Regular 80 224 58 N/A N/A
Ghostfish Roe [3] Roe Regular 52 145 37 N/A N/A
Halibut Roe [3] Roe Regular 70 196 51 N/A N/A
Herring Roe [3] Roe Regular 45 126 32 N/A N/A
Ice Pip Roe [3] Roe Regular 280 784 202 N/A N/A
Largemouth Bass Roe [3] Roe Regular 80 224 58 N/A N/A
Lava Eel Roe [3] Roe Regular 380 1064 274 N/A N/A
Lingcod Roe [3] Roe Regular 90 252 66 N/A N/A
Lionfish Roe [3] Roe Regular 80 224 58 N/A N/A
Lobster Roe [3] Roe Regular 90 252 66 N/A N/A
Midnight Carp Roe [3] Roe Regular 105 294 75 N/A N/A
Mussel Roe [3] Roe Regular 45 126 32 N/A N/A
Octopus Roe [3] Roe Regular 105 294 75 N/A N/A
Oyster Roe [3] Roe Regular 50 140 37 N/A N/A
Perch Roe [3] Roe Regular 57 159 42 N/A N/A
Periwinkle Roe [3] Roe Regular 40 112 29 N/A N/A
Pike Roe [3] Roe Regular 80 224 58 N/A N/A
Pufferfish Roe [3] Roe Regular 130 364 94 N/A N/A
Rainbow Trout Roe [3] Roe Regular 62 173 45 N/A N/A
Red Mullet Roe [3] Roe Regular 67 187 48 N/A N/A
Red Snapper Roe [3] Roe Regular 55 154 40 N/A N/A
Salmon Roe [3] Roe Regular 67 187 48 N/A N/A
Sandfish Roe [3] Roe Regular 67 187 48 N/A N/A
Sardine Roe [3] Roe Regular 50 140 37 N/A N/A
Scorpion Carp Roe [3] Roe Regular 105 294 75 N/A N/A
Sea Cucumber Roe [3] Roe Regular 67 187 48 N/A N/A
Sea Urchin Roe [3] Roe Regular 110 308 80 N/A N/A
Shad Roe [3] Roe Regular 60 168 43 N/A N/A
Shrimp Roe [3] Roe Regular 60 168 43 N/A N/A
Slimejack Roe [3] Roe Regular 80 224 58 N/A N/A
Smallmouth Bass Roe [3] Roe Regular 55 154 40 N/A N/A
Snail Roe [3] Roe Regular 62 173 45 N/A N/A
Spook Fish Roe [3] Roe Regular 140 392 101 N/A N/A
Stingray Roe [3] Roe Regular 120 336 86 N/A N/A
Stonefish Roe [3] Roe Regular 180 504 130 N/A N/A
Sturgeon Roe [3] Roe Regular 130 700 152 N/A N/A
Sunfish Roe [3] Roe Regular 45 126 32 N/A N/A
Super Cucumber Roe [3] Roe Regular 155 434 112 N/A N/A
Tiger Trout Roe [3] Roe Regular 105 294 75 N/A N/A
Tilapia Roe [3] Roe Regular 67 187 48 N/A N/A
Tuna Roe [3] Roe Regular 80 224 58 N/A N/A
Void Salmon Roe [3] Roe Regular 105 294 75 N/A N/A
Walleye Roe [3] Roe Regular 82 229 59 N/A N/A
Woodskip Roe [3] Roe Regular 67 187 48 N/A N/A


Notes

  1. Each day has 1600 minutes of processing time. From 2am to 6am, machines process at 100 minutes per hour. For the rest of the day, machines process at 60 minutes per hour.
    So, (4 × 100) + (20 × 60) = 1600 minutes of processing time per day.
  2. Foraged item that does not benefit from the Tiller Profession
  3. Does not benefit from the Tiller Profession
  4. Does not benefit from the Tiller Profession, but input item does benefit from the Artisan Profession
  5. Making coffee requires 5 beans
Retrieved from "https://stardew.fastobject.net/index.php?title=User:Pangaea/Artisan_Jars_vs_Kegs&oldid=123094"