Announcement

Collapse
No announcement yet.

Baseball HQ Pitching Logs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Comment


    • #17
      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


      • #18
        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.

        Comment


        • #19
          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)

          Comment


          • #20
            Originally posted by jstarr82
            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.
            MiLBAnalysis.com / @NickRichardsHQ

            Comment


            • #21
              Thanks Nick

              Comment


              • #22
                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)

                Comment


                • #23
                  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.

                  Comment


                  • #24
                    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.

                    Comment


                    • #25
                      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

                      Comment


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

                        Comment


                        • #27
                          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.

                          Comment


                          • #28
                            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

                            Comment


                            • #29
                              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


                              • #30
                                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.
                                Nothing left to do but smile, smile, smile

                                Comment

                                Working...
                                X