{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Stats","Track"],"not_rendered":{"macros":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Stats","index":0,"n_rows":17,"n_cols":18,"rows_kept":17,"merged":[[0,0,0,2]]}
["MATCH STATISTICS"]
[]
["Match","Player 1","Player 2",{"$nulls":14},"Match"]
["Serve Statistics",{"$nulls":16},"1st Set"]
["Aces",{"$f":"IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(Aces=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(Aces=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(Aces=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(Aces=\"yes\"))))))","v":0},{"$f":"IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(Aces=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(Aces=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(Aces=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(Aces=\"yes\"))))))","v":0},{"$nulls":14},"2nd Set"]
["Double Faults",{"$f":"IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(First=\"no\")*(Second=\"no\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(First=\"no\")*(Second=\"no\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(First=\"no\")*(Second=\"no\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(First=\"no\")*(Second=\"no\"))))))","v":0},{"$f":"IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(First=\"no\")*(Second=\"no\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(First=\"no\")*(Second=\"no\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(First=\"no\")*(Second=\"no\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(First=\"no\")*(Second=\"no\"))))))","v":0},{"$nulls":14},"3rd Set"]
["1st serve %",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=1))/SUMPRODUCT((Server=1)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=2))/SUMPRODUCT((Server=1)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=3))/SUMPRODUCT((Server=1)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(First=\"yes\")/SUMPRODUCT((Server=1)*1)))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=1))/SUMPRODUCT((Server=2)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=2))/SUMPRODUCT((Server=2)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=3))/SUMPRODUCT((Server=2)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(First=\"yes\")/SUMPRODUCT((Server=2)*1)))))),\"None\")","v":"None"}]
["1st serve points Won",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=1)*(setn=1))/SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=1)*(setn=2))/SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=1)*(setn=3))/SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=1))/SUMPRODUCT((Server=1)*(First=\"yes\")))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=2)*(setn=1))/SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=2)*(setn=2))/SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=2)*(setn=3))/SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=2))/SUMPRODUCT((Server=2)*(First=\"yes\")))))),\"None\")","v":"None"}]
["Break Points Saved",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=1)*(setn=1))/SUMPRODUCT((Server=1)*(BP=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=1)*(setn=2))/SUMPRODUCT((Server=1)*(BP=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=1)*(setn=2))/SUMPRODUCT((Server=1)*(BP=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=1))/SUMPRODUCT((Server=1)*(BP=\"yes\")))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=2)*(setn=1))/SUMPRODUCT((Server=2)*(BP=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=2)*(setn=2))/SUMPRODUCT((Server=2)*(BP=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=2)*(setn=2))/SUMPRODUCT((Server=2)*(BP=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=2))/SUMPRODUCT((Server=2)*(BP=\"yes\")))))),\"None\")","v":"None"}]
["Return Statistics"]
["1st Return points Won",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=1)*(setn=1)/(SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=1)))),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=1)*(setn=2)/(SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=2)))),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=1)*(setn=3)/(SUMPRODUCT((Server=2)*(First=\"yes\")*(setn=3)))),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(First=\"yes\")*(winner=1)/(SUMPRODUCT((Server=2)*(First=\"yes\")))))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=2)*(setn=1)/(SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=1)))),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=2)*(setn=2)/(SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=2)))),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=2)*(setn=3)/(SUMPRODUCT((Server=1)*(First=\"yes\")*(setn=3)))),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(First=\"yes\")*(winner=2)/(SUMPRODUCT((Server=1)*(First=\"yes\")))))))),\"None\")","v":"None"}]
["2nd Return points Won",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(Second=\"yes\")*(winner=1)*(setn=1))/(SUMPRODUCT((Server=2)*(Second=\"yes\")*(setn=1))),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(Second=\"yes\")*(winner=1)*(setn=2))/(SUMPRODUCT((Server=2)*(Second=\"yes\")*(setn=2))),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(Second=\"yes\")*(winner=1)*(setn=3))/(SUMPRODUCT((Server=2)*(Second=\"yes\")*(setn=3))),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(Second=\"yes\")*(winner=1))/(SUMPRODUCT((Server=2)*(Second=\"yes\"))))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(Second=\"yes\")*(winner=2)*(setn=1))/(SUMPRODUCT((Server=1)*(Second=\"yes\")*(setn=1))),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(Second=\"yes\")*(winner=2)*(setn=2))/(SUMPRODUCT((Server=1)*(Second=\"yes\")*(setn=2))),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(Second=\"yes\")*(winner=2)*(setn=3))/(SUMPRODUCT((Server=1)*(Second=\"yes\")*(setn=3))),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(Second=\"yes\")*(winner=2))/(SUMPRODUCT((Server=1)*(Second=\"yes\"))))))),\"None\")","v":"None"}]
["Break Points Won",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=1)*(setn=1))/SUMPRODUCT((Server=2)*(BP=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=1)*(setn=2))/SUMPRODUCT((Server=2)*(BP=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=1)*(setn=3))/SUMPRODUCT((Server=2)*(BP=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(BP=\"yes\")*(winner=1))/SUMPRODUCT((Server=2)*(BP=\"yes\")))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=2)*(setn=1))/SUMPRODUCT((Server=1)*(BP=\"yes\")*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=2)*(setn=2))/SUMPRODUCT((Server=1)*(BP=\"yes\")*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=2)*(setn=3))/SUMPRODUCT((Server=1)*(BP=\"yes\")*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(BP=\"yes\")*(winner=2))/SUMPRODUCT((Server=1)*(BP=\"yes\")))))),\"None\")","v":"None"}]
["Points Statistics"]
["Total Service Points Won",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(winner=1)*(setn=1))/SUMPRODUCT((Server=1)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(winner=1)*(setn=2))/SUMPRODUCT((Server=1)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(winner=1)*(setn=3))/SUMPRODUCT((Server=1)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(winner=1))/SUMPRODUCT((Server=1)*1))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(winner=2)*(setn=1))/SUMPRODUCT((Server=2)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(winner=2)*(setn=2))/SUMPRODUCT((Server=2)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(winner=2)*(setn=3))/SUMPRODUCT((Server=2)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(winner=2))/SUMPRODUCT((Server=2)*1))))),\"None\")","v":"None"}]
["Total Return Points Won",{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=2)*(winner=1)*(setn=1))/SUMPRODUCT((Server=2)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=2)*(winner=1)*(setn=2))/SUMPRODUCT((Server=2)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=2)*(winner=1)*(setn=3))/SUMPRODUCT((Server=2)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=2)*(winner=1))/SUMPRODUCT((Server=2)*1))))),\"None\")","v":"None"},{"$f":"IFERROR(IF(A3=\"1st Set\",SUMPRODUCT((Server=1)*(winner=2)*(setn=1))/SUMPRODUCT((Server=1)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((Server=1)*(winner=2)*(setn=2))/SUMPRODUCT((Server=1)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((Server=1)*(winner=2)*(setn=3))/SUMPRODUCT((Server=1)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((Server=1)*(winner=2))/SUMPRODUCT((Server=1)*1))))),\"None\")","v":"None"}]
["Total Points Won",{"$f":"IF(A3=\"1st Set\",SUMPRODUCT((winner=1)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((winner=1)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((winner=1)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((winner=1)*1)))))","v":0},{"$f":"IF(A3=\"1st Set\",SUMPRODUCT((winner=2)*(setn=1)),IF(A3=\"2nd Set\",SUMPRODUCT((winner=2)*(setn=2)),IF(A3=\"3rd Set\",SUMPRODUCT((winner=2)*(setn=3)),IF(A3=\"Match\",SUMPRODUCT((winner=2)*1)))))","v":0}]

{"sheet":"Track","index":1,"n_rows":1,"n_cols":7,"rows_kept":1}
["Server","Ace","1st Serve","2nd Serve","Break Point ","Winner","Set"]