Excel Formula for Computing NZAP?

cwhyte

I forgot how to do this in Excel (from a .csv file). Can someone send me the formula or post it here?

chris@chriswhyte.net

Thanks, Chris

HayesSanborn

This should do the trick, just adjust your range of cells. Just checked it on a spreadsheet I was using and it checks out.....

=SUM(BB6:BB13)/COUNTIF(BB6:BB13,">0")

cwhyte

Posted By Hayes Sanborn on 13 Oct 2010 04:55 PM

This should do the trick, just adjust your range of cells. Just checked it on a spreadsheet I was using and it checks out.....

=SUM(BB6:BB13)/COUNTIF(BB6:BB13,">0")

Yep, that's it. I don't know why I didn't do this in the first place but all I did was type, "how do you compute non-zero average power in excel" in google and the first hit gave the answer.

Coach Patrick

is this wiki worthy? if so, where to put it?

jburbatt

EN Power Training Resources would be where I'd look for it. Or whereever the TSS charts are (which I haven't found, hoping one day I'll need them )

dan_forbes

Posted By Jennifer Burbatt on 14 Oct 2010 08:59 AM

EN Power Training Resources would be where I'd look for it. Or whereever the TSS charts are (which I haven't found, hoping one day I'll need them )

That's funny, I haven't either and have given up!!