| Line 1: |
Line 1: |
| − | {{TOC right}}
| |
| | This is an attempt at directly comparing the profitability of [[Preserves Jar]]s and [[Keg]]s, based on processing time instead of increase in value. Couldn't find a way to merge wikitables, so had to "borrow" a page on [https://www.mediawiki.org/wiki/MediaWiki 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 [[mediawikiwiki:Extension:Cargo|Cargo]] or [[mediawikiwiki:Extension:DynamicPageList3|DPL]] would have been real handy, so that is something to think about for future games. | | This is an attempt at directly comparing the profitability of [[Preserves Jar]]s and [[Keg]]s, based on processing time instead of increase in value. Couldn't find a way to merge wikitables, so had to "borrow" a page on [https://www.mediawiki.org/wiki/MediaWiki 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 [[mediawikiwiki:Extension:Cargo|Cargo]] or [[mediawikiwiki:Extension:DynamicPageList3|DPL]] would have been real handy, so that is something to think about for future games. |
| | | | |
| − | <code><nowiki>{{ #arraydefine: array name | array values | delimiter (defaults to comma) | options }}</nowiki></code><br/>
| |
| − | <code><nowiki>{{#arrayprint:key|delimiter|pattern|subject|options}}</nowiki></code><br/>
| |
| − | <code><nowiki>{{#expr: expression }}</nowiki></code><br/>
| |
| − | <code><nowiki>{{#ifexpr: expression | value if true | value if false }}</nowiki></code><br/>
| |
| − | <code><nowiki>{{#iferror: test string | value if error | value if correct }}</nowiki></code><br/>
| |
| − |
| |
| − | ==Tests==
| |
| − | ====Simple test====
| |
| − | {{ #arraydefine: test | 25 }}
| |
| − | {{ #arrayprint: test }} <br/>
| |
| − | {{ #expr:{{ #arrayprint: test }}/2}}
| |
| − |
| |
| − | ====Multiple array test====
| |
| − | {{ #arraydefine: a | 25 }}
| |
| − | {{ #arraydefine: b | 50 }}
| |
| − | {{#ifexpr: {{ #arrayprint: a }} > {{ #arrayprint: b }} | a is bigger than b | a is smaller than b }}
| |
| − |
| |
| − | {{ #arraydefine: a | 100 }}
| |
| − | {{ #arraydefine: b | 50 }}
| |
| − | {{#ifexpr: {{ #arrayprint: a }} > {{ #arrayprint: b }} | a is bigger than b | a is smaller than b }}
| |
| − |
| |
| − | {{ #arraydefine: jarday | 300 }}
| |
| − | {{ #arraydefine: kegday | 400 }}
| |
| − | {{#ifexpr: {{ #arrayprint: jarday }} > {{ #arrayprint: kegday }} | The preserves jar is most profitable | The keg is most profitable }}
| |
| − |
| |
| − | {{ #arraydefine: jarday | 1300 }}
| |
| − | {{ #arraydefine: kegday | 1301 }}
| |
| − | {{#iferror: {{#ifexpr: {{ #arrayprint: jarday }} > {{ #arrayprint: kegday }} }} | MOTHER OF GOD, THERE WAS AN ERROR!!!1!! | {{#ifexpr: {{ #arrayprint: jarday }} > {{ #arrayprint: kegday }} | The preserves jar is +{{ #expr: ({{#arrayprint: jarday }}-{{#arrayprint: kegday }}) / {{#arrayprint: kegday }} *100 round 2 }}% more profitable | The keg is +{{ #expr: ({{#arrayprint: kegday }}-{{#arrayprint: jarday }}) / {{#arrayprint: jarday }} *100 round 2 }}% more profitable }} }}
| |
| − |
| |
| − | {{ #arraydefine: jarday | 350 }}
| |
| − | {{ #arraydefine: kegday | 400 }}
| |
| − | Most profitable in g/day: {{#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 }}% }} }}
| |
| − |
| |
| − | ====Array-function test====
| |
| − | {{ #arraydefine: jarday | 251 }}
| |
| − | {{ #arraydefine: kegday | 250 }}
| |
| − | {{ #arraydefine: dayprofitXXX | {{#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 }}% }} }} }}
| |
| − | {{ #arrayprint: dayprofitXXX }}
| |
| − |
| |
| − | {{ #arraydefine: dayprofit | {{#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 }}% }} }} }}
| |
| − |
| |
| − | ===Small-ish table test===
| |
| − | {| class="wikitable sortable" style="text-align: right;"
| |
| − | |-
| |
| − | !style="position: sticky; top: 0;"|Input Item
| |
| − | !style="position: sticky; top: 0;"|Type
| |
| − | !style="position: sticky; top: 0;"|Quality
| |
| − | !style="position: sticky; top: 0;"|Input Item Sell Price
| |
| − | !style="position: sticky; top: 0;"|Processed in [[File:Preserves Jar.png|12px|Preserves Jar|link=]] Sell Price
| |
| − | !style="position: sticky; top: 0;"|Approximate g/day in [[File:Preserves Jar.png|12px|Preserves Jar|link=]] <sup>[[#Notes|[1]]]</sup>
| |
| − | !style="position: sticky; top: 0;"|Processed in [[File:Keg.png|12px|Keg|link=]] Sell Price
| |
| − | !style="position: sticky; top: 0;"|Approximate g/day in [[File:Keg.png|12px|Keg|link=]] <sup>[[#Notes|[1]]]</sup>
| |
| − | !style="position: sticky; top: 0;"|Most Profitable in g/day
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Amaranth}}
| |
| − | |style="text-align: left;"|Veg
| |
| − | |data-sort-value="0" style="text-align: left;"|Regular
| |
| − | |MOTHER||490||{{ #arraydefine: jarday | 130||print}}||471||{{ #arraydefine: kegday | 82||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Amaranth}}
| |
| − | |style="text-align: left;"|Veg
| |
| − | |data-sort-value="1" style="text-align: left;"|[[File:Silver Quality.png|16px|link=]] Silver
| |
| − | |(N/A)||490||{{ #arraydefine: jarday | 114||print}}||471||{{ #arraydefine: kegday | 70||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Amaranth}}
| |
| − | |style="text-align: left;"|Veg
| |
| − | |data-sort-value="2" style="text-align: left;"|[[File:Gold Quality.png|16px|link=]] Gold
| |
| − | | Even||490||{{ #arraydefine: jarday | 98||print}}||471||{{ #arraydefine: kegday | 59||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Amaranth}}
| |
| − | |style="text-align: left;"|Veg
| |
| − | |data-sort-value="3" style="text-align: left;"|[[File:Iridium Quality.png|16px|link=]] Iridium
| |
| − | |38||490||{{ #arraydefine: jarday | 64||print}}||471||{{ #arraydefine: kegday | 38||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Ancient Fruit}}
| |
| − | |style="text-align: left;"|Fruit
| |
| − | |data-sort-value="0" style="text-align: left;"|Regular
| |
| − | |605||1610||{{ #arraydefine: jarday | 402||print}}||2310||{{ #arraydefine: kegday | 274||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Ancient Fruit}}
| |
| − | |style="text-align: left;"|Fruit
| |
| − | |data-sort-value="1" style="text-align: left;"|[[File:Silver Quality.png|16px|link=]] Silver
| |
| − | |755||1610||{{ #arraydefine: jarday | 342||print}}||2310||{{ #arraydefine: kegday | 250||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Ancient Fruit}}
| |
| − | |style="text-align: left;"|Fruit
| |
| − | |data-sort-value="2" style="text-align: left;"|[[File:Gold Quality.png|16px|link=]] Gold
| |
| − | |907||1610||{{ #arraydefine: jarday | 282||print}}||2310||{{ #arraydefine: kegday | 224||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |-
| |
| − | |style="text-align: left;"|{{name|Ancient Fruit}}
| |
| − | |style="text-align: left;"|Fruit
| |
| − | |data-sort-value="3" style="text-align: left;"|[[File:Iridium Quality.png|16px|link=]] Iridium
| |
| − | |1210||1610||{{ #arraydefine: jarday | 160||print}}||2310||{{ #arraydefine: kegday | 176||print}}
| |
| − | |{{User:Pangaea/Template jarkegprofit|jarday={{#arrayprint: jarday}}|kegday={{#arrayprint: kegday}} }}
| |
| − | |}
| |
| − |
| |
| − | <!--
| |
| − | {{ #arraydefine: dayprofit | {{#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 }}% }} }} }}
| |
| − | -->
| |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − | ==The full table==
| |
| | {| class="wikitable sortable" style="text-align: right;" | | {| class="wikitable sortable" style="text-align: right;" |
| | |- | | |- |