Guys, I must have missed it somewhere along the 1,300 posts and can't seem to find it, but what are the CAT ranges for M1-M5 and P1-P5 and what do they mean? I know they are referencing O/U's but wasn't sure on the ranges...
all of the cat's are in a tab in the master (red tab CAT Ranges)
they are all listed below as well. easiest part is if you dont like my ranges just put new ones in that tab in the area you want to change and than delete all the info in the master relating to them and run the macro for that one and you get the results using your own numbers
i have time for a few more question, that i'll be out for a while
<table style="border-collapse: collapse; width: 320pt;" width="427" border="0" cellpadding="0" cellspacing="0"><col style="width: 80pt;" width="107"> <col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt; width: 80pt;" width="107" height="20">Type</td> <td style="width: 48pt;" width="64">
</td> <td class="xl95" style="width: 48pt;" width="64">Low</td> <td class="xl95" style="width: 48pt;" width="64">High</td> <td class="xl95" style="width: 48pt;" width="64">ABV</td> <td class="xl95" style="width: 48pt;" width="64">ABV</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">LM CATS</td> <td class="xl95">1</td> <td class="xl95">1</td> <td class="xl95">9</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl95">10</td> <td class="xl95">14</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl95">15</td> <td class="xl95">20</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl95">21</td> <td class="xl95">100</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">ERA CATS</td> <td class="xl95">1</td> <td class="xl95">0</td> <td class="xl95">1</td> <td class="xl95">HVEM</td> <td class="xl95">HVEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl95">1.00001</td> <td class="xl95">2</td> <td class="xl95">HVAM</td> <td class="xl95">HVAP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl95">2.000001</td> <td class="xl95">3</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl95">3.000001</td> <td class="xl95">4</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl95">4.000001</td> <td class="xl95">10</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">WHIP CATS</td> <td class="xl95">1</td> <td class="xl95">0</td> <td class="xl95">0.075</td> <td class="xl95">HVWM</td> <td class="xl95">HVWP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl95">0.076</td> <td class="xl95">0.15</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl95">0.151</td> <td class="xl95">0.2251</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl95">0.2252</td> <td class="xl95">0.3</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl95">0.3001</td> <td class="xl95">10</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">LINE RANGE CATS</td> <td class="xl95">1</td> <td class="xl95">100</td> <td class="xl95">115</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl95">116</td> <td class="xl95">125</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl95">126</td> <td class="xl95">140</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl95">141</td> <td class="xl95">160</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl95">161</td> <td class="xl95">180</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">6</td> <td class="xl95">181</td> <td class="xl95">220</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">7</td> <td class="xl95">221</td> <td class="xl95">1000</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">OU ERA DIFF</td> <td class="xl95">1</td> <td class="xl95">0</td> <td class="xl97">1.00</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl95">1.01</td> <td class="xl97">2.00</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl95">2.01</td> <td class="xl97">3.00</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl95">3.01</td> <td class="xl97">4.00</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl95">4.01</td> <td class="xl97">5.00</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">6</td> <td class="xl95">5.01</td> <td class="xl97">15.00</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">HUMIDITY</td> <td class="xl95">1</td> <td class="xl95">0</td> <td class="xl95">24</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl95">25</td> <td class="xl95">34</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl95">35</td> <td class="xl95">45</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl95">46</td> <td class="xl95">52</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl95">53</td> <td class="xl95">67</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">6</td> <td class="xl95">68</td> <td class="xl95">78</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">7</td> <td class="xl95">79</td> <td class="xl95">88</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">8</td> <td class="xl95">89</td> <td class="xl95">1000</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">TEMPERATURE</td> <td class="xl95">1</td> <td class="xl95">0</td> <td class="xl95">47</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl95">47.00001</td> <td class="xl95">57</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl95">57.00001</td> <td class="xl95">66</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl95">66.00001</td> <td class="xl95">70</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl95">70.00001</td> <td class="xl95">79</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">6</td> <td class="xl95">79.00001</td> <td class="xl95">84</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">7</td> <td class="xl95">84.00001</td> <td class="xl95">95</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">8</td> <td class="xl95">95.00001</td> <td class="xl95">150</td> <td class="xl95">
</td> <td class="xl95">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl95">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">STD DEV</td> <td class="xl95">1</td> <td class="xl98">0.000</td> <td class="xl98">0.490</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl98">0.500</td> <td class="xl98">0.990</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl98">1.000</td> <td class="xl98">1.990</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl98">2.000</td> <td class="xl98">2.990</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl98">3.000</td> <td class="xl98">100.000</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl95">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">GAME WHIP</td> <td class="xl95">1</td> <td class="xl98">0.000</td> <td class="xl98">2.440</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">2</td> <td class="xl98">2.450</td> <td class="xl98">2.535</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">3</td> <td class="xl98">2.536</td> <td class="xl98">2.760</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">4</td> <td class="xl98">2.761</td> <td class="xl98">2.932</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl96" style="height: 15pt;" height="20">
</td> <td class="xl95">5</td> <td class="xl98">2.933</td> <td class="xl98">3.074</td> <td>
</td> <td>
</td> </tr> </tbody></table>