Could someone post the overall hit and strand rate formulas? I keep messing up the parentheses.
Announcement
Collapse
No announcement yet.
Baseball HQ Pitching Logs
Collapse
X

H% > http://www.baseballhq.com/overview/g...pc/index.html
(H  HR) / ((IP x 2.82) + H  K  HR)
S% > http://www.baseballhq.com/overview/g...pc/index.html
(H + BB  ER) / (H + BB  HR)
Comment

Originally posted by jstarr82This is the formula I have to calculate PQS score. What do I add into the formula to add the caveat if less than 5 innings, all the other data doesnt matter and PQS is an automatic 0?
Basically I've just nested another IF statement around your original statement. It says that if IP (E21) is less than 6, you get a 0. Otherwise the other part of the IF statement gets calculated, and that's your original formula. The parts I added are in bold, including that extra close parentheses at the end.
Comment

Essentially you want to replace each cell reference with a range reference, where the range is a group of cells for however many games you want the rolling rate to cover. Generally five in the PQS logs. So, for example, assuming row 8 was your current row and was the fifth game for that pitcher,
=(F4:F8+H4:H8G4:G8)/(F4:F8+H4:H8J4:J8)
As you drag this formula down the column, Excel should automagically adjust the ranges to refer to the immediately preceding five games.
Comment

I've updated my spreadsheet to have all the necessary pitching benchmarks as well as month specific PQS scores. (I know it's all available in HQ, but I like tracking my players and inputting their stats after each start). I'm having trouble with my month specific data when trying to use the Nested IF statement I created. Does anyone think they can lend me a hand?
Comment
Comment