Stardew Valley Wiki

User:Pangaea/Artisan Jars vs Kegs

< User:Pangaea
Revision as of 21:03, 9 September 2022 by Pangaea (talk | contribs) (Function works, but that isn't feasible in every cell)

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   Sell Price Approximate g/day in   [1] Processed in   Sell Price Approximate g/day in   [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   Sell Price Approximate g/day in   [1] Processed in   Sell Price Approximate g/day in   [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://stardewvalleywiki.com/mediawiki/index.php?title=User:Pangaea/Artisan_Jars_vs_Kegs&oldid=141601"