New YPPT Method

Jsan,

I have tried different ways to post mine but no luck.  What I do, to get the statfox sheet on my spreadsheet is to highlight and copy the game you want.  Then, when you go to paste it on the spreadsheet, I have to "paste special" then I click HTML format and it comes out fine.  Hope this helps.

lou Thanks .. Trying to get the data from with in the columns and run formula to calculate automatic ... Have you ran the numbers for the Rutgers game ??

Wanting to check and see if formula is working .. I came up with Rutgers 24 Army 16 w/HFA (3.5)

rough/rm2673/VGPop - wanted to check with you guys as well to see if you have had a chance to work on the Rutgers game and what your final talley is .. Almost finished with spread sheet that may help ...

rough - I know you have worked a new tweek to the system would like to learn what you did ... I can not figure it out with your FSU / UNC example .....

Thanks guys !!!

The System has Tonight's Game as a DEFINITE NO PLAY.

Rutgers   263 Yds.  10.6 YPPT   56 Plays  4.7 YPP   (22.5)

Army       260 Yds   20.1 YPPT   63 Plays  4.2 YPP   (15.2)

Adjusted Score

Rutgers     23

Army         14

GL

Using the original roughshod formula with no averaging double negatives and positives and with the orginal sos factor I got:

                    Yards        Yppt       Points    HFA      Points    Final

Rutgers       259.0        10.8       24.0      -1.75      22.2        21

Army           262.1        19.8       13.2      +1.75     15            14

Hey rm,  I highlight both teams stats, even though I'm not using certain stats, to get the ones you need, you have to.

Quote Originally Posted by Jsan:

I must be missing something on YDS ...  I am getting 279 for Rutgers and 291 for Army ... .. 

Jsan,

I got 260 yards for  Rutgers and 261.1 for Army.  These totals were before any SOS factor, which if you look at my previous post, wasn't much of a difference between these two teams.

rm beat me to the punch.

Sorry I missed that , you absolutley need to do that!

So it should readFSU 15.5 + -.85 =14.65 x .94 = 13.77

                         NC    13.8 + -1.35 =12.45 x 1.06 = 13.19

FSU 365/13.77 =26.5 ACTUAL/438yds 30pts

NC 339/13.19 = 25.7 ACTUAL 333yards 27 pts

I"ll MAKE CHANGES ON THE ABOVE POST

Still think the original method is pretty damn good lets put it to the test tonight

(38.5) RUT 104+149=253/12.82=19.7

(+10)  ARMY 203+90=293/13.68 = 21.41

ARMY wins outright? Line started at 40 Won with a teaser last night FSU +8.5 & OV 42. Liking Army + pts and the Under in another. Still like 10 pts at home too. Slow night tonight looking for a hockey play as well.

Gotcha there ncsutodd .... Thats why I cant understand where all the YDS differentials are being produced ... isnt everyone pulling the same data for yds ??

Rutgers #'s

YDS Rush

YDS Pass

YPPT

rm2673 ... Are you using the info from where ncsu said to get from ... Use that instead of the individual team stats .... copy/paste and whammo its there ....