Template:Hxi Drop Rate: Difference between revisions
From HorizonXI Wiki
m (updated ASB link to link directly to drop rates sql) |
mNo edit summary |
||
| (8 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
<onlyinclude><includeonly>{{#ifeq:{{{asb}}}|false | <onlyinclude><includeonly>{{#if:{{#pos:{{{1|}}}|%}}|([[HorizonXI:Drop Rate Policy|{{ht|{{{1}}} HorizonXI Drop Rate|{{{1}}}}}]])|<!-- | ||
| {{Drop Rate|{{{1|}}}|{{{2|}}}}} | -->{{#ifeq:{{{asb}}}|false | ||
| {{Retail Drop Rate|{{{1|}}}|{{{2|}}}}} | |||
| {{#ifexpr:{{{2|0}}} < 25<!-- | | {{#ifexpr:{{{2|0}}} < 25<!-- | ||
sample size smaller than 25: display horizon | sample size smaller than 25: display horizon | ||
-->| <span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round | -->| <span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2|0}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span> | ||
| {{#ifexpr:{{{2|0}}} < 100<!-- | | {{#ifexpr:{{{2|0}}} < 100<!-- | ||
sample size smaller than 100: indications, display horizon | sample size smaller than 100: indications, display horizon | ||
-->| {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{asb}}})*100<!-- | -->| {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{asb}}})*100<!-- | ||
deviation from asb | deviation from asb | ||
-->| <span style="color: red">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. Horizon Drop Rate indicates a deviation but sample size is low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round | -->| <span style="color: red">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. Horizon Drop Rate indicates a deviation but sample size is low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span> <!-- | ||
no deviation from asb | no deviation from asb | ||
-->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round | -->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span>}}<!-- | ||
sample size smaller than 500: indications but display Hxi | sample size smaller than 500: indications but display Hxi | ||
--> | --> | ||
| Line 16: | Line 17: | ||
| {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{asb}}})*100<!-- | | {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{asb}}})*100<!-- | ||
deviation from asb | deviation from asb | ||
-->| <span style="color: purple">([[HorizonXI:Drop Rate Policy|{{ht|HorizonXI Drop Rate. Horizon Drop Rate indicates a deviation but sample size might still be low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round | -->| <span style="color: purple">([[HorizonXI:Drop Rate Policy|{{ht|HorizonXI Drop Rate. Horizon Drop Rate indicates a deviation but sample size might still be low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %). - ASB: {{#expr:{{{asb}}}*100 round 1}}%|{{#expr:{{{1|0}}}/{{{2}}}*100 round 1}}%|gray}}]])</span> <!-- | ||
no deviation from asb | no deviation from asb | ||
-->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. HorizonXI sample data agrees that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round | -->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. HorizonXI sample data agrees that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span>}}<!-- | ||
sample size larger than 500: just display horizon, dont care about ASB | sample size larger than 500: just display horizon, dont care about ASB | ||
-->| ([[HorizonXI:Drop Rate Policy|{{ht|{{{1}}}/{{{2}}}. High data; Drop Rate should be accurate.|{{#expr:{{{1}}} / {{{2}}} * 100 round | -->| ([[HorizonXI:Drop Rate Policy|{{ht|{{{1}}}/{{{2}}}. High data; Drop Rate should be accurate.|{{#expr:{{{1}}} / {{{2}}} * 100 round 1}}%}}]])}}}}}}}}}}</includeonly></onlyinclude> | ||
[[Category:Templates|{{PAGENAME}}]] | [[Category:Templates|{{PAGENAME}}]] | ||
| Line 26: | Line 27: | ||
Parameters | Parameters | ||
<pre> | <pre> | ||
{{Drop Rate|asb=|total drops|total kills}} | {{Hxi Drop Rate|asb=|total drops|total kills}} | ||
</pre> | </pre> | ||
* asb is the drop rate, written as a ratio a/b, from the [https:// | * asb is the drop rate, written as a ratio a/b, from the [https://raw.githubusercontent.com/AirSkyBoat/AirSkyBoat/staging/modules/era/sql/era_mob_droplist.sql Air Sky Boat Github Repository for drop rates]. <small>(A list of all zones can be found [https://github.com/AirSkyBoat/AirSkyBoat/blob/staging/documentation/ZoneIDs.txt here].)</small> | ||
* Setting asb to ''false'' will invoke | * Setting asb to ''false'' will invoke [[:Template:Retail Drop Rate]]. | ||
*if specifying a percentage value for the first unnamed parameter, then that percentage value will be displayed. Example: | |||
<pre>{{Hxi Drop Rate|22%}}</pre> | |||
{{Hxi Drop Rate|22%}} | |||
Logic: | Logic: | ||
| Line 39: | Line 44: | ||
===Examples=== | ===Examples=== | ||
* no sample returns: | |||
<pre>{{Hxi Drop Rate|asb=111/1000|0|0}} | |||
</pre> | |||
{{Hxi Drop Rate|asb=111/1000|0|0}} | |||
* sample size < 25: | * sample size < 25: | ||
<pre>{{Hxi Drop Rate|asb= | <pre>{{Hxi Drop Rate|asb=111/1000|1|10}}</pre> | ||
{{Hxi Drop Rate|asb= | {{Hxi Drop Rate|asb=111/1000|1|10}} | ||
* 25 < sample size < 100, hxi agrees with asb: | * 25 < sample size < 100, hxi agrees with asb: | ||
<pre>{{Hxi Drop Rate|asb= | <pre>{{Hxi Drop Rate|asb=111/1000|5|60}}</pre> | ||
{{Hxi Drop Rate|asb= | {{Hxi Drop Rate|asb=111/1000|5|60}} | ||
* 25 < sample size < 100, hxi deviates from asb: | * 25 < sample size < 100, hxi deviates from asb: | ||
<pre>{{Hxi Drop Rate|asb= | <pre>{{Hxi Drop Rate|asb=111/1000|30|60}}</pre> | ||
{{Hxi Drop Rate|asb= | {{Hxi Drop Rate|asb=111/1000|30|60}} | ||
* 100 < sample size < 500, hxi agrees with asb: | * 100 < sample size < 500, hxi agrees with asb: | ||
<pre>{{Hxi Drop Rate|asb= | <pre>{{Hxi Drop Rate|asb=111/1000|10|120}}</pre> | ||
{{Hxi Drop Rate|asb= | {{Hxi Drop Rate|asb=111/1000|10|120}} | ||
* 100 < sample size < 500, hxi deviates from asb: | * 100 < sample size < 500, hxi deviates from asb: | ||
<pre>{{Hxi Drop Rate|asb= | <pre>{{Hxi Drop Rate|asb=111/1000|93|120}}</pre> | ||
{{Hxi Drop Rate|asb= | {{Hxi Drop Rate|asb=111/1000|93|120}} | ||
* 500 < sample size: | * 500 < sample size: | ||
<pre>{{Hxi Drop Rate|asb= | <pre>{{Hxi Drop Rate|asb=111/1000|312|1500}}</pre> | ||
{{Hxi Drop Rate|asb= | {{Hxi Drop Rate|asb=111/1000|312|1500}} | ||
==Drop Rate Guidelines== | ==Drop Rate Guidelines== | ||
From [[Template:Drop Rate]] | From [[:Template:Retail Drop Rate]] | ||
''This section describes how the Drop Rate template works. If you are looking for rules and guidelines on use, see [[HorizonXI:Drop Rate Policy]].'' | ''This section describes how the Drop Rate template works. If you are looking for rules and guidelines on use, see [[HorizonXI:Drop Rate Policy]].'' | ||
Revision as of 16:06, 28 February 2024
Usage
Parameters
{{Hxi Drop Rate|asb=|total drops|total kills}}
- asb is the drop rate, written as a ratio a/b, from the Air Sky Boat Github Repository for drop rates. (A list of all zones can be found here.)
- Setting asb to false will invoke Template:Retail Drop Rate.
- if specifying a percentage value for the first unnamed parameter, then that percentage value will be displayed. Example:
{{Hxi Drop Rate|22%}}
(22%)
Logic:
- if sample size < 25: show asb
- if 25 < sample size < 100: show asb but hint with red brackets IF difference between horizon droprate and asb is larger than the confidence interval of the sample.
- if 100 < sample size < 500: show horizon but hint with purple brackets IF difference between horizon droprate and asb is larger than the confidence interval of the sample.
- if 500 < sample size: show horizon
Examples
- no sample returns:
{{Hxi Drop Rate|asb=111/1000|0|0}}
(11.1%)
- sample size < 25:
{{Hxi Drop Rate|asb=111/1000|1|10}}
(11.1%)
- 25 < sample size < 100, hxi agrees with asb:
{{Hxi Drop Rate|asb=111/1000|5|60}}
(11.1%)
- 25 < sample size < 100, hxi deviates from asb:
{{Hxi Drop Rate|asb=111/1000|30|60}}
(11.1%)
- 100 < sample size < 500, hxi agrees with asb:
{{Hxi Drop Rate|asb=111/1000|10|120}}
(11.1%)
- 100 < sample size < 500, hxi deviates from asb:
{{Hxi Drop Rate|asb=111/1000|93|120}}
(77.5%)
- 500 < sample size:
{{Hxi Drop Rate|asb=111/1000|312|1500}}
(20.8%)
Drop Rate Guidelines
From Template:Retail Drop Rate
This section describes how the Drop Rate template works. If you are looking for rules and guidelines on use, see HorizonXI:Drop Rate Policy.
- This template is used to collect and present drop rate data. It is intended to collect data from multiple users and keep a running total (new results are added to the existing totals rather than replacing them), thus becoming more accurate over time.
- The drop rate is rounded to the nearest tenth, with a hovertext that displays the exact number of drops and kills and a message describing the data's current reliablity.
- If the data is too low to be considered reliable (less than 25 kills), the drop rate will be colored gray and question marks (???) will be displayed instead of the drop rate. However, the drop rate can still be seen in the hovertext next to the number of drops and kills.
- If the data is low, but not completely unreliable (less than 500 kills), the drop rate will simply be colored gray.
- "100%" can be used as the "total drops" value to automatically display the drop rate as 100%.
