It's almost a year old and not sure if it's set up correctly or not. If someone could advise I'd appreciate it.
Also if the spreadsheet is wrong can someone give it a work over or give suggestions to make one using the information on the CBb index page for Kenpom.
Appreciate it in advance from a not so tech kind of capper.
JR
JR,
sorry mate! I saw your post on my phone this weekend but wasn't able to go to that link from the phone. I finally got back to the computer and had a chance to check it out. Looks like this site is used for comparing teams in a hypothetical matchup. For instance, I could use this to get a predicted score between wyoming and Kansas. This is a cool site, but I dont think it will help with what we are doing. Thanks!
0
Quote Originally Posted by jrivers:
Guys,
All this talk is beyond my scope of comprehension and I really don't have a full grasp of the Kenpom system.
I found this while searching to get a better understanding. Can you advise if this spreadsheet would be of value or not to use.
It's almost a year old and not sure if it's set up correctly or not. If someone could advise I'd appreciate it.
Also if the spreadsheet is wrong can someone give it a work over or give suggestions to make one using the information on the CBb index page for Kenpom.
Appreciate it in advance from a not so tech kind of capper.
JR
JR,
sorry mate! I saw your post on my phone this weekend but wasn't able to go to that link from the phone. I finally got back to the computer and had a chance to check it out. Looks like this site is used for comparing teams in a hypothetical matchup. For instance, I could use this to get a predicted score between wyoming and Kansas. This is a cool site, but I dont think it will help with what we are doing. Thanks!
I show on KenPom the FanMatch score as Creighton 85-66 or SIU +19. SIU is the road team.
Does not qualify ... But This line is one of those too good to be true lines ... Creighton now - 14 at home vs a shit S ILL team too easy .. Leaning S ILL
0
Quote Originally Posted by trabs9:
I show on KenPom the FanMatch score as Creighton 85-66 or SIU +19. SIU is the road team.
Does not qualify ... But This line is one of those too good to be true lines ... Creighton now - 14 at home vs a shit S ILL team too easy .. Leaning S ILL
Does not qualify ... But This line is one of those too good to be true lines ... Creighton now - 14 at home vs a shit S ILL team too easy .. Leaning S ILL
Yep, did the math wrong. Thanks.
0
Quote Originally Posted by Upside:
Does not qualify ... But This line is one of those too good to be true lines ... Creighton now - 14 at home vs a shit S ILL team too easy .. Leaning S ILL
Does anyone have a list of official plays from yesterday?
Here is what I found
W&M +10 (RDT) L Iowa +2 (HDT) W outright OK +3 (HDT) W outright Brown +12.5 (RDT) W UL-MOn +6.5 (HDT) L Charlotte +5 (HDT) W Samford +3 (HDT) W BC+9 (HDT) W outright NM -3.5 (RFT) W Miss St +1.5 (HDT) W outright Umass pk (HFT) W MiaOH pk (HDA) W TennTech +11 (RDA) W Boise St -10.5 (HFT) L E. Wash -1.5 (RFN) L JMadison +4 (HDT) L Penn +1.5 (RDT) W outright LaSalle +2 (RDT) L IUPUI +7.5 (HDT) L LoyMary +10.5 (HDT) W Santa Clara +19 (RDN) W Detroit +4 (RDN) L UL-Laf -10.5 (HFA) L TCU +8 (RDA) W UC-Riv +6 (HDT) W outright Portland +24.5 (RDT) W
17-9 for the day with 6 outright dog winners. You guys let me know if I missed one
0
Does anyone have a list of official plays from yesterday?
Here is what I found
W&M +10 (RDT) L Iowa +2 (HDT) W outright OK +3 (HDT) W outright Brown +12.5 (RDT) W UL-MOn +6.5 (HDT) L Charlotte +5 (HDT) W Samford +3 (HDT) W BC+9 (HDT) W outright NM -3.5 (RFT) W Miss St +1.5 (HDT) W outright Umass pk (HFT) W MiaOH pk (HDA) W TennTech +11 (RDA) W Boise St -10.5 (HFT) L E. Wash -1.5 (RFN) L JMadison +4 (HDT) L Penn +1.5 (RDT) W outright LaSalle +2 (RDT) L IUPUI +7.5 (HDT) L LoyMary +10.5 (HDT) W Santa Clara +19 (RDN) W Detroit +4 (RDN) L UL-Laf -10.5 (HFA) L TCU +8 (RDA) W UC-Riv +6 (HDT) W outright Portland +24.5 (RDT) W
17-9 for the day with 6 outright dog winners. You guys let me know if I missed one
jrivers - If you click on beaver's comic pic, you'll get his personal cover's page. From there you can see everywhere he's posted. Start about Week 5 or 6 and start reading EVERY POST...tons of information and I'm sure you'll pick it up w/o a problem.
beaver/stiff/bobcat/flyerlax and the rest of you - awesome work. Please keep it up as I love the reads as well as the system!
Many thanks from the thousands of us that read but hardly ever post ;)
0
jrivers - If you click on beaver's comic pic, you'll get his personal cover's page. From there you can see everywhere he's posted. Start about Week 5 or 6 and start reading EVERY POST...tons of information and I'm sure you'll pick it up w/o a problem.
beaver/stiff/bobcat/flyerlax and the rest of you - awesome work. Please keep it up as I love the reads as well as the system!
Many thanks from the thousands of us that read but hardly ever post ;)
Does anyone have a list of official plays from yesterday?
Here is what I found
W&M +10 (RDT) L Iowa +2 (HDT) W outright OK +3 (HDT) W outright Brown +12.5 (RDT) W UL-MOn +6.5 (HDT) L Charlotte +5 (HDT) W Samford +3 (HDT) W BC+9 (HDT) W outright NM -3.5 (RFT) W Miss St +1.5 (HDT) W outright Umass pk (HFT) W MiaOH pk (HDA) W TennTech +11 (RDA) W Boise St -10.5 (HFT) L E. Wash -1.5 (RFN) L JMadison +4 (HDT) L Penn +1.5 (RDT) W outright LaSalle +2 (RDT) L IUPUI +7.5 (HDT) L LoyMary +10.5 (HDT) W Santa Clara +19 (RDN) W Detroit +4 (RDN) L UL-Laf -10.5 (HFA) L TCU +8 (RDA) W UC-Riv +6 (HDT) W outright Portland +24.5 (RDT) W
17-9 for the day with 6 outright dog winners. You guys let me know if I missed one
Yeah missed the Tcu, Loyla, Iowa, and Penn plays. What site you using for opening lines Beaver? I m going to start using that.
(went 12-9-1 pushing with Miami I locked in at -1)
0
Quote Originally Posted by beaverfan23:
Does anyone have a list of official plays from yesterday?
Here is what I found
W&M +10 (RDT) L Iowa +2 (HDT) W outright OK +3 (HDT) W outright Brown +12.5 (RDT) W UL-MOn +6.5 (HDT) L Charlotte +5 (HDT) W Samford +3 (HDT) W BC+9 (HDT) W outright NM -3.5 (RFT) W Miss St +1.5 (HDT) W outright Umass pk (HFT) W MiaOH pk (HDA) W TennTech +11 (RDA) W Boise St -10.5 (HFT) L E. Wash -1.5 (RFN) L JMadison +4 (HDT) L Penn +1.5 (RDT) W outright LaSalle +2 (RDT) L IUPUI +7.5 (HDT) L LoyMary +10.5 (HDT) W Santa Clara +19 (RDN) W Detroit +4 (RDN) L UL-Laf -10.5 (HFA) L TCU +8 (RDA) W UC-Riv +6 (HDT) W outright Portland +24.5 (RDT) W
17-9 for the day with 6 outright dog winners. You guys let me know if I missed one
Yeah missed the Tcu, Loyla, Iowa, and Penn plays. What site you using for opening lines Beaver? I m going to start using that.
(went 12-9-1 pushing with Miami I locked in at -1)
I've figured out a way to break out the KP spreads on a spreadsheet for easier analysis. It's a tad complex but will be very helpful on big cards like today.
Once I am done I will post a preliminary card based on Bookmaker lines from midnight last night. Those were the only lines I found posted that early.
I will also give instructions on how to get the spread broken out.
Sounds like this would be awesome! And to answer your question, I use the opening line....not the kenpom line
0
Quote Originally Posted by sscott999:
I've figured out a way to break out the KP spreads on a spreadsheet for easier analysis. It's a tad complex but will be very helpful on big cards like today.
Once I am done I will post a preliminary card based on Bookmaker lines from midnight last night. Those were the only lines I found posted that early.
I will also give instructions on how to get the spread broken out.
Sounds like this would be awesome! And to answer your question, I use the opening line....not the kenpom line
Guys, I think you should set some set of rules regarding the way of deciding which opening line should be compared to kenpom numbers. Obviously, everyone can use different book which could ultimately lead to everyone having different "official" plays hence to a chaos. As a bright example Washington vs Washington State
could be shown, the game at which Washington was opened as a -10,5 favourite at BetOnline, while it was opened -8,5 everywhere else. So for a person using BetOnline as a reference line, the system could produce different outcome than for a person using, say, Pinnacle numbers. I think this should be solved.
Other thing is deciding the percentage of public being on the same side like the kenpom system. What happens when the percentage of public on the same side is, say, 63% and is fluctuating so in a half and hour it's at 66%, then in another half an hour it drops to 64%? Where do you draw the line? I mean, at which moment do you say "ok, it's 66% so I exclude it"? Again, I assume that every person can pull the trigger at the moment he/she chooses so the system could produce different outcome for each person. I think that percetage of public should be incorporated to the system in a different way or one person should make the calls at a specific time, say, one hour before the start of a game.
0
Guys, I think you should set some set of rules regarding the way of deciding which opening line should be compared to kenpom numbers. Obviously, everyone can use different book which could ultimately lead to everyone having different "official" plays hence to a chaos. As a bright example Washington vs Washington State
could be shown, the game at which Washington was opened as a -10,5 favourite at BetOnline, while it was opened -8,5 everywhere else. So for a person using BetOnline as a reference line, the system could produce different outcome than for a person using, say, Pinnacle numbers. I think this should be solved.
Other thing is deciding the percentage of public being on the same side like the kenpom system. What happens when the percentage of public on the same side is, say, 63% and is fluctuating so in a half and hour it's at 66%, then in another half an hour it drops to 64%? Where do you draw the line? I mean, at which moment do you say "ok, it's 66% so I exclude it"? Again, I assume that every person can pull the trigger at the moment he/she chooses so the system could produce different outcome for each person. I think that percetage of public should be incorporated to the system in a different way or one person should make the calls at a specific time, say, one hour before the start of a game.
Here's my technique for breaking out the KP spreads. Very helpful for big days like Saturday.
I use Firefox and I know there is some difference in how Firefox deals with copied txt vs IE. But this may work in IE as well.
1) Highlight and copy the KP Fanmatch table.
2) When you Paste to Excel, you have to select Paste Special - Unicode Text. This will break out the data in columns. At this point you should see the Prediction columnin column C. If you DON'T pick Unicode Text, you will get a long string of text in a single cell.
3) The key to breaking out the numbers is the "-" between the scores. Clear out columns D, E, F, and G because this is where you will be adding formulas.
4) In column D enter the following formula (asuuming you are on row #4): =FIND("-",C4,1)-2, this locates the "-" then backs up 2 spaces to identify the first digit of the score prediction. The result will be a number like 16 or something meaning its the 16th character in the string.
5) In column E enter this formula:=MID(C4,D4,2), this returns the predicted score of the winning team.
6) In coumn F enter this formula: =MID(C4,D4+3,2), this returns the predicted score of the losing team.
7) In column G enter: =F4-E4, this gives you the KP line for KP's favored team.
A this point you can sort the data from column C through G, print it out and quickly look up KP lines on all favorites as you go through the opening lines.
This should save a lot of time on big play days and avoid calculation errors. Just make sure you watch for flips between the Fave and the Dog between KP and the opening line.
0
Here's my technique for breaking out the KP spreads. Very helpful for big days like Saturday.
I use Firefox and I know there is some difference in how Firefox deals with copied txt vs IE. But this may work in IE as well.
1) Highlight and copy the KP Fanmatch table.
2) When you Paste to Excel, you have to select Paste Special - Unicode Text. This will break out the data in columns. At this point you should see the Prediction columnin column C. If you DON'T pick Unicode Text, you will get a long string of text in a single cell.
3) The key to breaking out the numbers is the "-" between the scores. Clear out columns D, E, F, and G because this is where you will be adding formulas.
4) In column D enter the following formula (asuuming you are on row #4): =FIND("-",C4,1)-2, this locates the "-" then backs up 2 spaces to identify the first digit of the score prediction. The result will be a number like 16 or something meaning its the 16th character in the string.
5) In column E enter this formula:=MID(C4,D4,2), this returns the predicted score of the winning team.
6) In coumn F enter this formula: =MID(C4,D4+3,2), this returns the predicted score of the losing team.
7) In column G enter: =F4-E4, this gives you the KP line for KP's favored team.
A this point you can sort the data from column C through G, print it out and quickly look up KP lines on all favorites as you go through the opening lines.
This should save a lot of time on big play days and avoid calculation errors. Just make sure you watch for flips between the Fave and the Dog between KP and the opening line.
Does anyone have a list of official plays from yesterday?
Here is what I found
W&M +10 (RDT) L Iowa +2 (HDT) W outright OK +3 (HDT) W outright Brown +12.5 (RDT) W UL-MOn +6.5 (HDT) L Charlotte +5 (HDT) W Samford +3 (HDT) W BC+9 (HDT) W outright NM -3.5 (RFT) W Miss St +1.5 (HDT) W outright Umass pk (HFT) W MiaOH pk (HDA) W TennTech +11 (RDA) W Boise St -10.5 (HFT) L E. Wash -1.5 (RFN) L JMadison +4 (HDT) L Penn +1.5 (RDT) W outright LaSalle +2 (RDT) L IUPUI +7.5 (HDT) L LoyMary +10.5 (HDT) W Santa Clara +19 (RDN) W Detroit +4 (RDN) L UL-Laf -10.5 (HFA) L TCU +8 (RDA) W UC-Riv +6 (HDT) W outright Portland +24.5 (RDT) W
17-9 for the day with 6 outright dog winners. You guys let me know if I missed one
I threw out Boise because I saw them at 65%. I had Richmond in addition to your list though opened at -1 KP at +1. 18-8 for me yesterday.
0
Quote Originally Posted by beaverfan23:
Does anyone have a list of official plays from yesterday?
Here is what I found
W&M +10 (RDT) L Iowa +2 (HDT) W outright OK +3 (HDT) W outright Brown +12.5 (RDT) W UL-MOn +6.5 (HDT) L Charlotte +5 (HDT) W Samford +3 (HDT) W BC+9 (HDT) W outright NM -3.5 (RFT) W Miss St +1.5 (HDT) W outright Umass pk (HFT) W MiaOH pk (HDA) W TennTech +11 (RDA) W Boise St -10.5 (HFT) L E. Wash -1.5 (RFN) L JMadison +4 (HDT) L Penn +1.5 (RDT) W outright LaSalle +2 (RDT) L IUPUI +7.5 (HDT) L LoyMary +10.5 (HDT) W Santa Clara +19 (RDN) W Detroit +4 (RDN) L UL-Laf -10.5 (HFA) L TCU +8 (RDA) W UC-Riv +6 (HDT) W outright Portland +24.5 (RDT) W
17-9 for the day with 6 outright dog winners. You guys let me know if I missed one
I threw out Boise because I saw them at 65%. I had Richmond in addition to your list though opened at -1 KP at +1. 18-8 for me yesterday.
Here's my technique for breaking out the KP spreads. Very helpful for big days like Saturday.
I use Firefox and I know there is some difference in how Firefox deals with copied txt vs IE. But this may work in IE as well.
1) Highlight and copy the KP Fanmatch table.
2) When you Paste to Excel, you have to select Paste Special - Unicode Text. This will break out the data in columns. At this point you should see the Prediction columnin column C. If you DON'T pick Unicode Text, you will get a long string of text in a single cell.
3) The key to breaking out the numbers is the "-" between the scores. Clear out columns D, E, F, and G because this is where you will be adding formulas.
4) In column D enter the following formula (asuuming you are on row #4): =FIND("-",C4,1)-2, this locates the "-" then backs up 2 spaces to identify the first digit of the score prediction. The result will be a number like 16 or something meaning its the 16th character in the string.
5) In column E enter this formula:=MID(C4,D4,2), this returns the predicted score of the winning team.
6) In coumn F enter this formula: =MID(C4,D4+3,2), this returns the predicted score of the losing team.
7) In column G enter: =F4-E4, this gives you the KP line for KP's favored team.
A this point you can sort the data from column C through G, print it out and quickly look up KP lines on all favorites as you go through the opening lines.
This should save a lot of time on big play days and avoid calculation errors. Just make sure you watch for flips between the Fave and the Dog between KP and the opening line.
What also makes it easier for busy days is to export the opening lines from the covers page beaver mentioned, only available on day games, and join this data set with KenPom's data set via VLookUp function. Note, about 10-15% of the matches will be done manually still, because KenPom and Covers don't use the EXACT same name for a team (e.g. Oregon St. vs. Oregon State).
0
Quote Originally Posted by sscott999:
Here's my technique for breaking out the KP spreads. Very helpful for big days like Saturday.
I use Firefox and I know there is some difference in how Firefox deals with copied txt vs IE. But this may work in IE as well.
1) Highlight and copy the KP Fanmatch table.
2) When you Paste to Excel, you have to select Paste Special - Unicode Text. This will break out the data in columns. At this point you should see the Prediction columnin column C. If you DON'T pick Unicode Text, you will get a long string of text in a single cell.
3) The key to breaking out the numbers is the "-" between the scores. Clear out columns D, E, F, and G because this is where you will be adding formulas.
4) In column D enter the following formula (asuuming you are on row #4): =FIND("-",C4,1)-2, this locates the "-" then backs up 2 spaces to identify the first digit of the score prediction. The result will be a number like 16 or something meaning its the 16th character in the string.
5) In column E enter this formula:=MID(C4,D4,2), this returns the predicted score of the winning team.
6) In coumn F enter this formula: =MID(C4,D4+3,2), this returns the predicted score of the losing team.
7) In column G enter: =F4-E4, this gives you the KP line for KP's favored team.
A this point you can sort the data from column C through G, print it out and quickly look up KP lines on all favorites as you go through the opening lines.
This should save a lot of time on big play days and avoid calculation errors. Just make sure you watch for flips between the Fave and the Dog between KP and the opening line.
What also makes it easier for busy days is to export the opening lines from the covers page beaver mentioned, only available on day games, and join this data set with KenPom's data set via VLookUp function. Note, about 10-15% of the matches will be done manually still, because KenPom and Covers don't use the EXACT same name for a team (e.g. Oregon St. vs. Oregon State).
took Nebraska +14, figured Wisc couldnt score enough to beat anyone by 14, trying to watch some of that game, but man Wisconsin plays some horrible low scoring games. This will put you to sleep
0
took Nebraska +14, figured Wisc couldnt score enough to beat anyone by 14, trying to watch some of that game, but man Wisconsin plays some horrible low scoring games. This will put you to sleep
Here's my technique for breaking out the KP spreads. Very helpful for big days like Saturday.
I use Firefox and I know there is some difference in how Firefox deals with copied txt vs IE. But this may work in IE as well.
1) Highlight and copy the KP Fanmatch table.
2) When you Paste to Excel, you have to select Paste Special - Unicode Text. This will break out the data in columns. At this point you should see the Prediction columnin column C. If you DON'T pick Unicode Text, you will get a long string of text in a single cell.
3) The key to breaking out the numbers is the "-" between the scores. Clear out columns D, E, F, and G because this is where you will be adding formulas.
4) In column D enter the following formula (asuuming you are on row #4): =FIND("-",C4,1)-2, this locates the "-" then backs up 2 spaces to identify the first digit of the score prediction. The result will be a number like 16 or something meaning its the 16th character in the string.
5) In column E enter this formula:=MID(C4,D4,2), this returns the predicted score of the winning team.
6) In coumn F enter this formula: =MID(C4,D4+3,2), this returns the predicted score of the losing team.
7) In column G enter: =F4-E4, this gives you the KP line for KP's favored team.
A this point you can sort the data from column C through G, print it out and quickly look up KP lines on all favorites as you go through the opening lines.
This should save a lot of time on big play days and avoid calculation errors. Just make sure you watch for flips between the Fave and the Dog between KP and the opening line.
sscott.....thanks on busy days like Sat. it's crazy...And its possiblemissing A early game because your so busy.
0
Quote Originally Posted by sscott999:
Here's my technique for breaking out the KP spreads. Very helpful for big days like Saturday.
I use Firefox and I know there is some difference in how Firefox deals with copied txt vs IE. But this may work in IE as well.
1) Highlight and copy the KP Fanmatch table.
2) When you Paste to Excel, you have to select Paste Special - Unicode Text. This will break out the data in columns. At this point you should see the Prediction columnin column C. If you DON'T pick Unicode Text, you will get a long string of text in a single cell.
3) The key to breaking out the numbers is the "-" between the scores. Clear out columns D, E, F, and G because this is where you will be adding formulas.
4) In column D enter the following formula (asuuming you are on row #4): =FIND("-",C4,1)-2, this locates the "-" then backs up 2 spaces to identify the first digit of the score prediction. The result will be a number like 16 or something meaning its the 16th character in the string.
5) In column E enter this formula:=MID(C4,D4,2), this returns the predicted score of the winning team.
6) In coumn F enter this formula: =MID(C4,D4+3,2), this returns the predicted score of the losing team.
7) In column G enter: =F4-E4, this gives you the KP line for KP's favored team.
A this point you can sort the data from column C through G, print it out and quickly look up KP lines on all favorites as you go through the opening lines.
This should save a lot of time on big play days and avoid calculation errors. Just make sure you watch for flips between the Fave and the Dog between KP and the opening line.
sscott.....thanks on busy days like Sat. it's crazy...And its possiblemissing A early game because your so busy.
If you choose to make use of any information on this website including online sports betting services from any websites that may be featured on
this website, we strongly recommend that you carefully check your local laws before doing so.It is your sole responsibility to understand your local laws and observe them strictly.Covers does not provide
any advice or guidance as to the legality of online sports betting or other online gambling activities within your jurisdiction and you are responsible for complying with laws that are applicable to you in
your relevant locality.Covers disclaims all liability associated with your use of this website and use of any information contained on it.As a condition of using this website, you agree to hold the owner
of this website harmless from any claims arising from your use of any services on any third party website that may be featured by Covers.
Hot Forum Topics
