Hey Box,
I noticed that between your PR vs L/R and mine are completely different.
<table x:str="" style="border-collapse: collapse; width: 239pt;" border="0" cellpadding="0" cellspacing="0" width="319"><col style="width: 145pt;" width="193"> <col style="width: 26pt;" width="35"> <col style="width: 24pt;" width="32"> <col style="width: 44pt;" width="59"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 145pt;" height="17" width="193"> </td> <td style="width: 26pt;" width="35">OU</td> <td style="width: 24pt;" width="32">Line</td> <td class="xl27" style="width: 44pt;" width="59">MY LINE</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">ST LOUIS at</td> <td x:num="" align="right">9</td> <td x:num="" align="right">165</td> <td class="xl27" x:str=""> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="height: 13.5pt;" height="18">NY METS</td> <td class="xl26"> </td> <td class="xl26" x:num="" align="right">-175</td> <td class="xl28" x:num="-140.76887500000004" align="right">-141</td> </tr> </tbody></table>
Mine is the following:
<table x:str="" style="border-collapse: collapse; width: 340pt;" border="0" cellpadding="0" cellspacing="0" width="452"><col style="width: 32pt;" width="42"> <col style="width: 53pt;" width="70"> <col style="width: 53pt;" span="2" width="71"> <col style="width: 56pt;" width="74"> <col style="width: 45pt;" width="60"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl34" style="height: 12.75pt; width: 32pt;" height="17" width="42">PR</td> <td class="xl35" style="width: 53pt;" width="70">Opp. (L/R)</td> <td class="xl36" style="width: 53pt;" width="71">PR vs. L/R</td> <td class="xl36" style="width: 53pt;" width="71">
</td> <td class="xl32" style="width: 56pt;" width="74">Pitcher PR</td> <td class="xl36" style="width: 45pt;" width="60">SYSTEM</td> <td class="xl33" style="width: 48pt;" width="64">Diff/Value</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" x:num="254.52500000000001" height="17">255</td> <td class="xl25">
</td> <td class="xl26" x:num="264.41750000000002" align="right">264</td> <td class="xl26">
</td> <td x:num="" align="right">281.8</td> <td class="xl26" x:num="271.37049999999999" x:fmla="=(C2*6+E2*4)/10" align="right">271</td> <td class="xl24"> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl29" style="height: 13.5pt;" x:num="300.0625" height="18">300</td> <td class="xl30">L</td> <td class="xl31" x:num="305.56562500000001" align="right">306</td> <td class="xl31">H</td> <td x:num="" align="right">322</td> <td class="xl31" x:num="312.13937499999997" x:fmla="=(C3*6+E3*4)/10" align="right">312</td> <td class="xl27" x:num="-40.768875000000037" x:fmla="=F2-F3" align="right">-41</td> </tr> </tbody></table>
Yours is the following:
<table x:str="" style="border-collapse: collapse; width: 340pt;" border="0" cellpadding="0" cellspacing="0" width="452"><col style="width: 32pt;" width="42"> <col style="width: 53pt;" width="70"> <col style="width: 53pt;" span="2" width="71"> <col style="width: 56pt;" width="74"> <col style="width: 45pt;" width="60"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl34" style="height: 12.75pt; width: 32pt;" height="17" width="42">PR</td> <td class="xl35" style="width: 53pt;" width="70">Opp. (L/R)</td> <td class="xl36" style="width: 53pt;" width="71">PR vs. L/R</td> <td class="xl36" style="width: 53pt;" width="71">
</td> <td class="xl32" style="width: 56pt;" width="74">Pitcher PR</td> <td class="xl36" style="width: 45pt;" width="60">SYSTEM</td> <td class="xl33" style="width: 48pt;" width="64">Diff/Value</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" x:num="254.52500000000001" height="17">255</td> <td class="xl25">
</td> <td class="xl26" x:num="" align="right">263</td> <td class="xl26">
</td> <td x:num="" align="right">280.9</td> <td class="xl26" x:num="270.16" x:fmla="=(C2*6+E2*4)/10" align="right">270</td> <td class="xl24"> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl29" style="height: 13.5pt;" x:num="" height="18">206</td> <td class="xl30">L</td> <td class="xl31" x:num="190.48" align="right">190</td> <td class="xl31">H</td> <td x:num="" align="right">322</td> <td class="xl31" x:num="243.08800000000002" x:fmla="=(C3*6+E3*4)/10" align="right">243</td> <td class="xl27" x:num="27.071999999999946" x:fmla="=F2-F3" align="right">27</td> </tr> </tbody></table>
Any ideas? If im a pest just tell me... Was just wondering whats happening. And maybe thats why most of us are getting different lines then you.
Bonez
I noticed that between your PR vs L/R and mine are completely different.
<table x:str="" style="border-collapse: collapse; width: 239pt;" border="0" cellpadding="0" cellspacing="0" width="319"><col style="width: 145pt;" width="193"> <col style="width: 26pt;" width="35"> <col style="width: 24pt;" width="32"> <col style="width: 44pt;" width="59"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 145pt;" height="17" width="193"> </td> <td style="width: 26pt;" width="35">OU</td> <td style="width: 24pt;" width="32">Line</td> <td class="xl27" style="width: 44pt;" width="59">MY LINE</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">ST LOUIS at</td> <td x:num="" align="right">9</td> <td x:num="" align="right">165</td> <td class="xl27" x:str=""> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="height: 13.5pt;" height="18">NY METS</td> <td class="xl26"> </td> <td class="xl26" x:num="" align="right">-175</td> <td class="xl28" x:num="-140.76887500000004" align="right">-141</td> </tr> </tbody></table>
Mine is the following:
<table x:str="" style="border-collapse: collapse; width: 340pt;" border="0" cellpadding="0" cellspacing="0" width="452"><col style="width: 32pt;" width="42"> <col style="width: 53pt;" width="70"> <col style="width: 53pt;" span="2" width="71"> <col style="width: 56pt;" width="74"> <col style="width: 45pt;" width="60"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl34" style="height: 12.75pt; width: 32pt;" height="17" width="42">PR</td> <td class="xl35" style="width: 53pt;" width="70">Opp. (L/R)</td> <td class="xl36" style="width: 53pt;" width="71">PR vs. L/R</td> <td class="xl36" style="width: 53pt;" width="71">
</td> <td class="xl32" style="width: 56pt;" width="74">Pitcher PR</td> <td class="xl36" style="width: 45pt;" width="60">SYSTEM</td> <td class="xl33" style="width: 48pt;" width="64">Diff/Value</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" x:num="254.52500000000001" height="17">255</td> <td class="xl25">
</td> <td class="xl26" x:num="264.41750000000002" align="right">264</td> <td class="xl26">
</td> <td x:num="" align="right">281.8</td> <td class="xl26" x:num="271.37049999999999" x:fmla="=(C2*6+E2*4)/10" align="right">271</td> <td class="xl24"> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl29" style="height: 13.5pt;" x:num="300.0625" height="18">300</td> <td class="xl30">L</td> <td class="xl31" x:num="305.56562500000001" align="right">306</td> <td class="xl31">H</td> <td x:num="" align="right">322</td> <td class="xl31" x:num="312.13937499999997" x:fmla="=(C3*6+E3*4)/10" align="right">312</td> <td class="xl27" x:num="-40.768875000000037" x:fmla="=F2-F3" align="right">-41</td> </tr> </tbody></table>
Yours is the following:
<table x:str="" style="border-collapse: collapse; width: 340pt;" border="0" cellpadding="0" cellspacing="0" width="452"><col style="width: 32pt;" width="42"> <col style="width: 53pt;" width="70"> <col style="width: 53pt;" span="2" width="71"> <col style="width: 56pt;" width="74"> <col style="width: 45pt;" width="60"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl34" style="height: 12.75pt; width: 32pt;" height="17" width="42">PR</td> <td class="xl35" style="width: 53pt;" width="70">Opp. (L/R)</td> <td class="xl36" style="width: 53pt;" width="71">PR vs. L/R</td> <td class="xl36" style="width: 53pt;" width="71">
</td> <td class="xl32" style="width: 56pt;" width="74">Pitcher PR</td> <td class="xl36" style="width: 45pt;" width="60">SYSTEM</td> <td class="xl33" style="width: 48pt;" width="64">Diff/Value</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" x:num="254.52500000000001" height="17">255</td> <td class="xl25">
</td> <td class="xl26" x:num="" align="right">263</td> <td class="xl26">
</td> <td x:num="" align="right">280.9</td> <td class="xl26" x:num="270.16" x:fmla="=(C2*6+E2*4)/10" align="right">270</td> <td class="xl24"> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl29" style="height: 13.5pt;" x:num="" height="18">206</td> <td class="xl30">L</td> <td class="xl31" x:num="190.48" align="right">190</td> <td class="xl31">H</td> <td x:num="" align="right">322</td> <td class="xl31" x:num="243.08800000000002" x:fmla="=(C3*6+E3*4)/10" align="right">243</td> <td class="xl27" x:num="27.071999999999946" x:fmla="=F2-F3" align="right">27</td> </tr> </tbody></table>
Any ideas? If im a pest just tell me... Was just wondering whats happening. And maybe thats why most of us are getting different lines then you.
Bonez
You're not being a pest, you are bringing valid concerns, and I want these things addressed. So far, the concerns have been things I have already figured out, and will figure out solutions for when I can sit down. Right now, still on my laptop, my office is not set up yet where I can sit down and really look at this excel sheet and write formulas.
There are a few quirky things that I havent explained much yet because I will cover it all when I get a chance to write it all out.
NY Mets are one of those teams like Chi Whitesox that are having issues with alphabetization.
They are grabbing another teams power ranking that is close to them aplhabetically.
You have to manually put in Whitesox and Mets power ranking, otherwise u will be playing the whitesox everyday because they are grabbing Bostons PR, and fading the Mets everyday because they are grabbing someone elses
Chi Whitesox and NY Mets have to be updated manually (because the "Chi" and "NY" are causing alphabetization problems with the VLOOKUP charts) and then NOT SAVED, otherwise u will lose the formula and that cell wont update, it will stay whatever power ranking u inserted, and when u update tomorrow and that line is reserved from pirates at nationals, depending on which line they update to the pirates or nationals wont have a formula to grab their power ranking, it will have the power ranking u manually typed in for the whitesox or mets because u saved ur session
Another problem I have found is when u right click and hit refresh, sometimes the word "Splits" inserts some new rows in the web query, and knocks every teams power ranking down 1 or 2 rows. When you refresh web queries, they need to be refreshed one at a time, and be sure the formay stays the same. When it updates, the entire stat section should take up the same amount of room, and same cells that it did before. The only thing that should change is the order of the teams. If when you hit refresh, it looks like new cells have been inserted, the stats are now "longer" in length, and it is off alignment with the other ones to it's left and right, you need to refresh again and again until the size, format, shape etc gets back to the same size as the others.
Alignment is everything. The excel sheet doesnt know that it's grabbing the Detroit Tigers batting stats, all it knows is to grab the stats from cell A3 for example. If you do a web refresh, and some extra lines are inserted and the cells get off alignment, you will see errors, or a couple of ur rankings may get messed up.
There are a few quirky things that I havent explained much yet because I will cover it all when I get a chance to write it all out.
NY Mets are one of those teams like Chi Whitesox that are having issues with alphabetization.
They are grabbing another teams power ranking that is close to them aplhabetically.
You have to manually put in Whitesox and Mets power ranking, otherwise u will be playing the whitesox everyday because they are grabbing Bostons PR, and fading the Mets everyday because they are grabbing someone elses
Chi Whitesox and NY Mets have to be updated manually (because the "Chi" and "NY" are causing alphabetization problems with the VLOOKUP charts) and then NOT SAVED, otherwise u will lose the formula and that cell wont update, it will stay whatever power ranking u inserted, and when u update tomorrow and that line is reserved from pirates at nationals, depending on which line they update to the pirates or nationals wont have a formula to grab their power ranking, it will have the power ranking u manually typed in for the whitesox or mets because u saved ur session
Another problem I have found is when u right click and hit refresh, sometimes the word "Splits" inserts some new rows in the web query, and knocks every teams power ranking down 1 or 2 rows. When you refresh web queries, they need to be refreshed one at a time, and be sure the formay stays the same. When it updates, the entire stat section should take up the same amount of room, and same cells that it did before. The only thing that should change is the order of the teams. If when you hit refresh, it looks like new cells have been inserted, the stats are now "longer" in length, and it is off alignment with the other ones to it's left and right, you need to refresh again and again until the size, format, shape etc gets back to the same size as the others.
Alignment is everything. The excel sheet doesnt know that it's grabbing the Detroit Tigers batting stats, all it knows is to grab the stats from cell A3 for example. If you do a web refresh, and some extra lines are inserted and the cells get off alignment, you will see errors, or a couple of ur rankings may get messed up.
