Baseball HQ Pitching Logs

[Bronx Bombers]

Could someone post the overall hit and strand rate formulas? I keep messing up the parentheses.

[Randall@HQ]

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)

[Bronx Bombers]

Thanks Randall, what I mean is that I need the proper way to format this formula in excel for the rolling overall hit and strand rates.

[Bronx Bombers]

This 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?

=IF(E21>=6,1,0)+IF(F21<=E21,1,0)+IF(2*H21<=I21,1,0 )+IF(I21>=E21-2,1,0)+IF(J21<=1,1,0)

[NICK@HQ]

This 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?

=IF(E21<5, 0, IF(E21>=6,1,0)+IF(F21<=E21,1,0)+IF(2*H21<=I21,1,0 )+IF(I21>=E21-2,1,0)+IF(J21<=1,1,0)) <-- Don't forget this extra one at the end.

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.

[Bronx Bombers]

Thanks Nick

[Bronx Bombers]

Right now this is the formula I use for Strand Rate. How can I convert it to make it be a rolling overall calculation as shown in the PQS logs?

=(F4+H4-G4)/(F4+H4-J4)

[Randall@HQ]

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:H8-G4:G8)/(F4:F8+H4:H8-J4:J8)

As you drag this formula down the column, Excel should automagically adjust the ranges to refer to the immediately preceding five games.

[Bronx Bombers]

Randalll,
I'm trying to make it a rolling total. I can't figure out how to place the sum function in this formula to properly calculate.

[DeanW]

jstarr,

I think a macro would be a much better way to approach this. If you can bear with me, I might be able to put something together and post it by tonight sometime.

Dean

[Bronx Bombers]

I can certainly bear with you. I know nothing in the macro department.

[DeanW]

I have the hit rate piece done. I need to put this aside for a bit, though, but I still hope to finish it up later tonight.

[DeanW]

jstarr,

If you send me a "Private Message" with your e-mail address in it, I'll e-mail you a copy of what I came up with and you can try it out.

DeanW

[Bronx Bombers]

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?

[cwhenning]

My new glasses haven't arrived yet.

I can't seem to find the link to the PQS files from the Home page. I was able to download using the link in this forum.