Discussions

Expand all | Collapse all

How to calculate strike rate (Win or Lose) for bids

  • 1.  How to calculate strike rate (Win or Lose) for bids

    Top
    Contributor
    Posted 03-19-2018 15:51
    Hi. New to QuickBase but couldn't find the answer to this.
    I have a table that lists bids that have been received. We have events called BDM Camp and I need to find a way to calculate when a BDM Camp is held, the ratio or percent of the bids that are Awarded, Lost or Cancelled. (I need to divide the number awarded or lost or cancelled into the total amount of bids that had BDM Camp)

    The bids are represented by a specific code for that Bid. The event is called BDM Camp and then results are a field called BDM Award Outcome (answers can be Awarded, Lost, Cancelled). I tried writing formulas, but I keep getting the notification that I am using "/" incorrect or Average incorrect.
    Any help is appreciated.


  • 2.  RE: How to calculate strike rate (Win or Lose) for bids

    Posted 03-19-2018 15:57
    Because you want to calculate three outcomes, I suggest making three formula % formula fields.

    The formula for [Awarded %] would be

    IF([Job Outcome] = "Awarded",1,0)

    and then similar for the others.

    Then the magic is that if you make a summary report all those 100% and 0% will average out.


  • 3.  RE: How to calculate strike rate (Win or Lose) for bids

    Top
    Contributor
    Posted 03-21-2018 20:21
    Thomas,  

    It looks like you have 2 tables, Camps and Bids.
    Each Camp has many Bids, correct?
    Any you track the 'status' of the bid on those records, correct?

    (If so, and I hope this is your set up)

    You will want to summarize 4 values from the [Bids] table up to the [Camp] table.
    # of Bids (this is a total, regardless of result/status)
    # of Bids Awarded (# where the status = "Awarded")
    # of Bids Lost
    # of Bids Cancelled

    Now for each camp you will have the 4 values needed to do any type of calculations or ratios.

    i.e. Won/Lost ratios, or % Won, etc.

    This also puts the 'reporting' on the level of the [Camp] table, and you can compare camps better.


  • 4.  RE: How to calculate strike rate (Win or Lose) for bids

    Top
    Contributor
    Posted 03-22-2018 19:24
    Thank you, both! These helped tremendously.