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.

 

 

Is anyone working on Rutgers & Army yet? Interested in how that comes out.

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 !!!

Roughshod31 great prediction on Fla and NC. Still can't wait to see tonights. Thanks for the winners.

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

rough - man just when I think I got it .. just not sure how I am so off on Yds ...  Course only a few points off from you ( Rutger 24 Army 16) but, still want to be absolutly correct with you on the spreadsheet formulas ... Must be the new tweek you added ??

 

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

I got the same final score and agree that it is a no play.
However, my total yards and YPPT for each team are slightly different.

hey lou, when I try to paste special, all the numbers still come out in one cell. I might be highlighting the wrong thing because I am just highlighting the entire row of numbers, for example, Rutger's offensive stats. How are you highlighting the game you want.

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

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

I get 259 for RUT and 263 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.

Yea I must not be doing something right because when I highlight the team stats, all the numbers are jumbled into one cell even if I use paste special -->HTML.

rm beat me to the punch.

[Quote: Originally Posted by rkydkydoc]

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.

what someone should do is just upload their spreadsheet to a file sharing place like sendspace and then post a link in the forum so anyone can download it.

I dont understand the difficulty of pasting into excel.  It is mind boggling.  For those that cant perform a simple copy/paste...

Awesome idea, willowtip.

Ok I am looking at the NO Miami game and even though your numbers say one this what about Injuries?
Miami has secondary QB up against Brees?  How can your formula account for that?  Did I miss some thing?

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

158.8     191.7

YDS Pass

192.3225.3

YPPT

1212.7

               

Yea I know how to copy and paste but when I paste all the numbers are in one cell. what am I doing wrong?

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 ....

Hi Roughshod.  I like your model, and I've played around with your numbers and formulas a little.  Can you explain how you came up with your final calculations a little clearer?  It appears to me that the SOS isn't properly accounted for since you can get the same score no matter what number you plug in there.