Corrected per40 spreadsheet uploaded (again)(and again)

[JRRRJ]

Download it here.

If the spreadsheet you currently have contains 1.00 in the points per game column the third grid on the Per-40 page for every player and silly values in the points per40 in the second grid, you need to download the copy I just uploaded.

Sorry about that!

 

[Dugway]

Good afternoon,

The 'Efficiency' cell formula does the correct math, but then divides it all by the number of points.

Not certain if this what you intended?

 

[JRRRJ]

No, I did not intend that! The value is supposed to be divided by number of games. I thought I found all the places where Q and R were reversed in the formulae somehow, but I missed that one.

The corrected spreadsheet has been uploaded, again.

Thanks @Dugway !

 

[JRRRJ]

No, I did not intend that! The value is supposed to be divided by number of games. I thought I found all the places where Q and R were reversed in the formulae somehow, but I missed that one.

The corrected spreadsheet has been uploaded, again.

Thanks @Dugway !

And I only fixed half of the formula. I promise, the efficiency calculation is correct now.

But I can't make that promise for anything else, though they look OK. It's that kind of day