Power Point Standings Week 3

[RedPrideNation_RollPride]

Team. Total Pts. Avg.

Region A
1. Northumberland 46. 23
2. Colonial Beach 45. 22.5
3. Rappahannock. 67. 22.3
4. K&Q. 63. 21
5. Middlesex. 59. 19.67
6. Essex. 53. 17.67

Region B
1. Wm Campbell. 71. 23.67
2. Riverheads. 68. 22.67
3. Altavista. 59. 19.67
4. Sussex. 30. 15
5. Central Lunenburg. 37. 12.33

Region C
1. Galax. 66. 22
2. Narrows 61. 20.3
3. GW. 54. 18
4. Auburn. 53. 17.67
5. Covington 42. 14

Region D
1. Holston. 68. 22.67
2. PHGS. 64. 21.33
3. Grundy. 63. 21
4. Hurley. 54. 18
5. Chilhowie. 52. 17.33
5. Rural Retreat. 52. 17.33

This is what I have through week three. Let me know if I missed something. Please remember that the standings are always based on average so teams with only two games can be ahead of those with more total points.

 

[Gunz41]

How do you get 68 for Riverheads?

WL: 1-1 18 points, Glenvar 1-2 20 points, ER 0-2 18 points. 56 points total

 

[RedPrideNation_RollPride]

I have the entire 1A schedule loaded and assign 1 point for every opponent win. That would be worst case scenario for riders in the event of a loss when that game occurs. The power points for outcome of a game occur in the week the game takes place. The riders adjust in the sheet as opponents win total changes since it ties to the reference sheet I will explain in a second. It’s just easier for me on my spread sheet that way. I promise the math is correct since I have the whole season loaded.

The excel workbook is set up in three sheets. The primary sheet has the schedule and refers to the other two sheets. This sheet contains most of the math with totals for power points and riders.

On a second sheet, I am tracking every team that a 1A school plays in a reference table that loads those points into the main sheet. If there is a W for that game, then a multiplier doubles that number (2pts for every win of a defeated opponent). If the box contains an L it stays at 1X that win total.

There is a third sheet built within the workbook to track wins/losses by division. This is so the proper power points are assigned based on what division the opponent is in.

I hope that is as clear as mud but the long and short is, for every team Iisted there are “future” points if you will. These are guaranteed minimums based on the wins already gained by an upcoming opponent.

Let me know if any of that makes sense, lol.

 

[NND Sports Fan]

Just a reminder that Middlesex is ineligible for post season play

 

[RedPrideNation_RollPride]

Thank you, I need to remember that, lol. Someone hit me with that last week and I couldn’t remember who it was so I just went with the top 6 there so as to include the top 5 eligible for post season play. Honestly was just a little lazy for not going back to find the post. Thanks again

 

[MGF]

Thank you, I need to remember that, lol. Someone hit me with that last week and I couldn’t remember who it was so I just went with the top 6 there so as to include the top 5 eligible for post season play. Honestly was just a little lazy for not going back to find the post. Thanks again

So who sneaks in at the #6 spot in 1A if Middlesex is ineligible?

 

[RedPrideNation_RollPride]

As you asked this I went back and found another error. I was wondering why W&L wasn't in the mix as well and there it was. Here is the updated standings excluding Middlesex with their 19.67 avg:

1. Northumberland 2-0 23.00
2. Colonial Beach 2-0 22.50
3. Rappahannock 3-0 22.33
4. King & Queen 3-0 21.00
4. W&L 1-1 21.00
6. Essex 2-1 17.67
7. West Point 1-2 14.33
8. Mathews 1-2 14.00

I am sorry for overlooking W&L in the first one but completely did. Let me know if I missed anything else.

 

[RedPrideNation_RollPride]

I have another correction, this time in Region D:

1. Holston 3-0 22.67
2. PHGS 3-0 21.33
3. Grundy 3-0 21.00
4. Thomas Walker 2-0 20
5. Hurley 2-1 18.00
6. Honaker 2-1 16.67
7. Chilhowie 2-1 17.33
8. Rural Retreat 2-1 17.33

I had hide Thomas Walker on my sheet, lol. I apologize for not having my stuff together better but it will get better.

 

[NNDanalyst]

As you asked this I went back and found another error. I was wondering why W&L wasn't in the mix as well and there it was. Here is the updated standings excluding Middlesex with their 19.67 avg:

1. Northumberland 2-0 23.00
2. Colonial Beach 2-0 22.50
3. Rappahannock 3-0 22.33
4. King & Queen 3-0 21.00
4. W&L 1-1 21.00
6. Essex 2-1 17.67
7. West Point 1-2 14.33
8. Mathews 1-2 14.00

I am sorry for overlooking W&L in the first one but completely did. Let me know if I missed anything else.

Well here is my straight math with no future riders or anything like that. Just numbers as they are right now for Region A.

1. Rapp 3-0 20.00 (60pts)
2. K&Q 3-0 19.333 (58pts)
3. NHS 2-0 17.00 (34pts)
4. CB 2-0 16.00 (32pts
5. Essex 2-1 15.00 (45pts)
6. W&L 1-1 12.50 (25pts)
T7. WP 1-2 10.00 (30pts)
T7. Mathews 10.00 (30pts)

 

[The Gridiron Guru]

I would say the Analyst is correct on Region 1A. No way W&L has 42 points in two games with a 1-1 record for a 21.0 rating.

 

[RedPrideNation_RollPride]

I will not arguing he is correct if you go by the games played, but would you agree that W&L will play 5 teams that have multiple wins? If you answer yes then logically the minimum they will get from those games is 1 rider pt per opponent win. I just choose to include those now since that part is inevitable.

 

[The Gridiron Guru]

You do it your way

 

[RedPrideNation_RollPride]

It’s all good @The Gridiron Guru. I just don’t have the patience to track them individually each week.