It's BIGGER, it's BADDER...

[JRRRJ]

No, it's not a Mark 10 superhero killer, and you're not Mr. Incredible. It's just a (IMHO) better version of the per-40-minutes spreadsheet.

A couple of formatting changes to make it more readable and standardize the number of decimal points in the average columns. A fix for dividing by zero (and me a math major).

An assist-to-turnover ratio column.

For those playing along at home, I've put the raw data columns in red text. All the rest of the cells on the spreadsheet are now calculated from these 16 columns. (There's 17 colored red, but nothing else depends on the "GS" column.) So, with about 9.65 minutes work with the Season Box Score on the Season Statistics page at uconnhuskies.com, you can update it yourself and won't have to wait for me to do it. Though I will, eventually. And you can play what-if by modifying any of the red numbers to see what happens, if you're bored.

The new, improved spreadsheet can be found here.

Let me know if anything's wrong or missing.

 

[Icebear]

Stef now leads the team in 3pt %.

 

[JRRRJ]

For those not playing along at home, here's the up-to-date per-40-minute stats:

Name..... 40' FGM .FGA ..3FGM 3FGA FTM .FTA ..OR ..DR ..TR ...PF .AST ..TO .Blk .ST ..Pts
M-Lewis 16.45 8.39 15.56 4.38 8.88 2.37 2.74 2.98 5.29 .8.27 2.13 3.34 1.88 0.36 2.01 23.53
Dolson. 15.00 9.07 14.47 0.40 0.80 3.27 4.20 2.80 6.93 .9.73 3.00 4.93 3.27 2.00 1.73 21.80
Stewart 12.03 9.40 18.54 1.16 3.99 4.82 5.90 4.32 8.48 12.81 2.83 1.83 2.74 3.24 1.83 24.78
Faris.. 17.38 5.35 .9.96 1.84 4.32 2.30 3.05 2.53 4.78 .7.31 2.30 5.81 2.30 0.46 3.68 14.85
Hartley 13.55 5.54 12.99 2.21 6.94 2.21 3.32 1.55 3.69 .5.24 1.99 5.61 2.95 0.15 1.99 15.50
Banks... 8.98 6.24 13.04 2.01 5.79 2.56 3.68 0.67 3.34 .4.01 2.45 3.90 2.45 0.45 2.79 17.05
Tuck.... 7.40 5.95 13.92 0.95 3.11 2.43 4.05 2.97 5.95 .8.92 2.43 3.24 3.51 0.68 1.49 15.27
Doty... 10.48 3.44 .8.78 2.39 6.40 0.00 0.19 1.15 4.30 .5.44 2.10 5.73 3.25 0.67 3.25 9.26
MoJeff. 10.18 3.83 10.32 0.98 4.62 1.18 1.47 0.88 3.24 .4.13 3.64 4.23 3.05 0.00 1.67 9.83
Stokes.. 6.00 3.50 .6.00 0.00 0.00 1.50 3.17 3.67 9.17 12.83 2.50 2.17 2.50 4.33 0.67 8.50
Buck.... 2.58 3.11 .6.99 0.00 0.00 0.39 0.78 2.72 5.83 .8.54 5.05 2.72 3.11 3.50 1.17 6.60

The annoying extra periods in the table are because I can't figure out how to stop the BB software from removing all the "extra" spaces I put in to achieve straight columns. It apparently has been told to allow only one space between "words". So, we gots lotsa periods.

 

[Plumber Luigi]

Have you tried the code tag? Only problem is you can't use any other tags within the code block without showing them.

 

[JRRRJ]

Have you tried the code tag? Only problem is you can't use any other tags within the code block without showing them.

I'll give that a try next time.

Thanks.

 

[JRRRJ]

Have you tried the code tag? Only problem is you can't use any other tags within the code block without showing them.

Hmmm, why not now?

fff

 Testing
     Testing
          Testing
 
                vv     vv
             v     v v     v
          v          v        v
            v                v
               v          v
                  v    v
                     v

 

[HuskyNan]

Yo, JR, did you get my email?

For all you number addicts, JRRRJ (my big brother) will be at the NCAA tourney 1st & 2nd round at Gampel next month, in case you'd like to meet him. Tickets are on sale through the UConn box office.

 

[JRRRJ]

Yo, JR, did you get my email?

For all you number addicts, JRRRJ (my big brother) will be at the NCAA tourney 1st & 2nd round at Gampel next month, in case you'd like to meet him. Tickets are on sale through the UConn box office.

Yep, I got the mail. Was gonna respond when Colleen & I had the details worked out, but that hasn't happened yet, as we have house guests. The Nathan Hale is XPENSIVE.