Template:Hxi Drop Rate: Difference between revisions

From HorizonXI Wiki
m (updated ASB link to link directly to drop rates sql)
m (reverting changes)
Tag: Manual revert
 
(11 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 0.1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 0.1}}%|gray}}]])</span>
-->| <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 0.1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 0.1}}%|gray}}]])</span> <!--
-->| <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 0.1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 0.1}}%|gray}}]])</span>}}<!--
-->|<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 0.1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %). - ASB: {{#expr:{{{asb}}}*100 round 0.1}}%|{{#expr:{{{1|0}}}/{{{2}}}*100 round 0.1}}%|gray}}]])</span> <!--
-->| <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 0.1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 0.1}}%|gray}}]])</span>}}<!--
-->|<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 0.1}}%}}]])}}}}}}}}</includeonly></onlyinclude>
-->| ([[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://github.com/AirSkyBoat/AirSkyBoat/blob/staging/sql/mob_droplist.sql Air Sky Boat Github Repository for drop rates].  
* 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 the old [[Template:Drop Rate]].  
* 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=100/1000|1|10}}</pre>
<pre>{{Hxi Drop Rate|asb=111/1000|1|10}}</pre>
{{Hxi Drop Rate|asb=100/1000|1|10}}
{{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=100/1000|5|60}}</pre>
<pre>{{Hxi Drop Rate|asb=111/1000|5|60}}</pre>
{{Hxi Drop Rate|asb=100/1000|5|60}}
{{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=100/1000|30|60}}</pre>
<pre>{{Hxi Drop Rate|asb=111/1000|30|60}}</pre>
{{Hxi Drop Rate|asb=100/1000|30|60}}
{{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=100/1000|10|120}}</pre>
<pre>{{Hxi Drop Rate|asb=111/1000|10|120}}</pre>
{{Hxi Drop Rate|asb=100/1000|10|120}}
{{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=100/1000|90|120}}</pre>
<pre>{{Hxi Drop Rate|asb=111/1000|93|120}}</pre>
{{Hxi Drop Rate|asb=100/1000|90|120}}
{{Hxi Drop Rate|asb=111/1000|93|120}}


* 500 < sample size:
* 500 < sample size:
<pre>{{Hxi Drop Rate|asb=100/1000|300|1500}}</pre>
<pre>{{Hxi Drop Rate|asb=111/1000|312|1500}}</pre>
{{Hxi Drop Rate|asb=100/1000|300|1500}}
{{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]].''

Latest revision as of 20:55, 26 October 2024

Usage

Parameters 

{{Hxi Drop Rate|asb=|total drops|total kills}}

{{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%.
Retrieved from "https://horizonffxi.wiki/w/index.php?title=Template:Hxi_Drop_Rate&oldid=72278"