{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pop Calculator","Pop Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pop Calculator","index":0,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,1,23,20],[9,1,9,20],[0,1,0,20],[1,1,1,20],[13,11,13,12],[22,1,22,20],[2,1,2,20],[11,1,11,20],[15,1,15,20],[16,1,16,20],[17,1,17,20]]}
[null,"Carson Valley Womens Golf Club"]
[null,"Pop Calculator For"]
[null,"Carson Valley Golf Course"]
[null,"Hole",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,"Handicap",17,5,13,15,7,1,9,11,3,6,10,8,12,14,2,4,18,16]
[null,"Par",3,4,4,4,3,5,4,4,5,5,5,4,3,4,5,4,3,3,"Total"]
[null,"Pops (\u0097)",{"$f":"IF(varPlayerHandicap=\"\",\"\",VLOOKUP(C5,tblPops,5,FALSE))","v":""},"","","","","","","","","","","","","","","","","",{"$f":"SUM(C7:T7)","v":0}]
[null,"Max Score",{"$f":"IF(varPlayerHandicap=\"\",\"\",IF(C7=\"\",C6+2,C6+2+C7))","v":""},"","","","","","","","","","","","","","","","","",{"$f":"SUM(C8:T8)","v":0}]
[]
[null,"Max Score = Net Double Bogie = Par + 2 (double bogie) + pops"]
[]
[null,"To use this calculator you will need to know your Coures Handicap for the course being played. Enter it below : "]
[]
[null,null,null,null,null,null,null,"Your Course Handicap : "]
[]
[null,"IF you do not know your course handicap you may calculate it below if you know your USGA Handicap Index "]
[null,"and have access to the following coures information - Slope, Rating and Par."]
[null,"Once calculated, enter the Course Handicap, as calculated below, in the Your Course Handicap field (above). "]
[]
[null,null,null,"Handicap Index",null,null,"Course Slope",null,null,"Course Rating",null,null,"Course Par",null,null,"Course Handicap"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D21=\"\",G21=\"\",J21=\"\",M21=\"\"),\"\",(D21*(G21/113))+(J21-M21))","v":""}]
[]
[null,"All Other Golf Courses"]
[null,"Pops for Hole Handicap"]
[null,"Handicap",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,"Total"]
[null,"Pops (\u0097)",{"$f":"IF(varPlayerHandicap=\"\",\"\",VLOOKUP(C25,tblPops,5,FALSE))","v":""},"","","","","","","","","","","","","","","","","",{"$f":"SUM(C26:T26)","v":0}]

{"sheet":"Pop Table","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,{"$f":"IF(varPlayerHandicap=\"\",\"\",IF(varPlayerHandicap>18,18,varPlayerHandicap))","v":""},{"$f":"IF(C4<18,\"\",IF(varPlayerHandicap-C4<=18,varPlayerHandicap-C4,18))","v":{"$error":"#VALUE!"}},{"$f":"IF(C4<18,\"\",varPlayerHandicap-(C4+D4))","v":{"$error":"#VALUE!"}},44]
[null,1,{"$f":"IF($C$4=\"\",\"\",IF(B5<=$C$4,1,\"\"))","v":""},{"$f":"IF($D$4=\"\",\"\",IF(B5<=$D$4,1,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$4=\"\",\"\",IF(B5<=$E$4,1,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(SUM(C5:E5)=0,\"\",SUM(C5:E5))","v":{"$error":"#VALUE!"}}]
[null,2,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,3,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,4,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,5,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,6,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,7,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,8,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,9,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,10,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,11,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,12,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,13,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,14,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,15,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,16,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,17,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,18,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,{"$f":"SUM(F5:F22)","v":{"$error":"#VALUE!"}}]