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)
Announcement
Collapse
No announcement yet.
Baseball HQ Pitching Logs
Collapse
X
-
Guest replied
-
Could someone post the overall hit and strand rate formulas? I keep messing up the parentheses.
Leave a comment:
-
Guest repliedOriginally posted by Randall@HQHmm. I think I misplaced some parentheses. Try something like this
=(COUNTIF(A2:A7,0)+COUNTIF(A2:A7,1))/COUNTA(A2:A7)
=COUNTIF(A2:A7,"<2")/COUNTA(A2:A7)
Leave a comment:
-
I believe they're normally updated daily, but we're apparently not quite there yet as we ramp up our in-season content, data feeds, etc.
Leave a comment:
-
Originally posted by AllenHThe logs that are up don't look complete. I couldn't find either Lidle or Suppan's first start, for example.
Leave a comment:
-
Guest repliedHmm. I think I misplaced some parentheses. Try something like this
=(COUNTIF(A2:A7,0)+COUNTIF(A2:A7,1))/COUNTA(A2:A7)
Leave a comment:
-
It's stating that I'm entering too few arguments for the function.
Leave a comment:
-
Guest repliedbrute force...where Z1:Z50 is the range containing all of the pitcher's PQS scores
=((COUNTIF(Z1:Z50),4)+(COUNTIF(Z1:Z50),5))/COUNTA(Z1:Z50) <--this is DOM%
=((COUNTIF(Z1:Z50),0)+(COUNTIF(Z1:Z50),1))/COUNTA(Z1:Z50) <-- this is DIS%
Leave a comment:
-
I guess the best way to explain is to tell you my circumstances for using this. I simply want to keep a log of the pitchers on my team's PQS weekly. I'm basically looking to duplicate the report the baseball HQ produced but customized for my team with the ability to manually enter the stats associated before the end of the week.
The first thing:
1. The formula to input in excel to calculate dom/dis split?Last edited by Bronx Bombers; 04-11-2006, 01:06 PM.
Leave a comment:
-
Guest repliedThe logs that are up don't look complete. I couldn't find either Lidle or Suppan's first start, for example.
Leave a comment:
-
I'd be willing, but I need to know what in particular you're trying to calculate.
Leave a comment:
-
Originally posted by jstarr82I'm specifically looking for the formulas built into excel to compute the values. PQS, rolling averages, etc.
Leave a comment:
-
I'm specifically looking for the formulas built into excel to compute the values. PQS, rolling averages, etc.
Leave a comment:
Leave a comment: