{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Individual Scores","Team Scores","Team Scores (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Individual Scores","index":0,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Player Name","Handicap",null,"Camas Meadows","Day 1 Gross","Net",null,"Indian Creek","Day 2 Gross","Net",null,"Elk Ridge","Day 3 Gross","Net",null,"Par Total","Total Gross","Total net"]
["Lucas ",2,null,72,{"$f":"D2+B2","v":74},{"$f":"(E2-$B2)-D2","v":0},null,72,{"$f":"H2+B2","v":74},{"$f":"(I2-$B2)-H2","v":0},null,70,{"$f":"L2+B2","v":72},{"$f":"(M2-$B2)-L2","v":0},null,{"$f":"D2+H2+L2","v":214},{"$f":"M2+I2+E2","v":220},{"$f":"N2+J2+F2","v":0}]
["Matt",4,null,72,76,{"$f":"(E3-$B3)-D3","v":0},null,72,{"$f":"H3+B3","v":76},{"$f":"(I3-$B3)-H3","v":0},null,70,{"$f":"L3+B3","v":74},{"$f":"(M3-$B3)-L3","v":0},null,214,{"$f":"M3+I3+E3","v":226},{"$f":"N3+J3+F3","v":0}]
["Max",9,null,72,81,0,null,72,81,0,null,70,79,0,null,214,241,0]
["Chris",11,null,72,83,0,null,72,83,0,null,70,81,0,null,214,247,0]
["Jeff",11,null,72,83,0,null,72,83,0,null,70,81,0,null,214,247,0]
["Kent",12,null,72,84,0,null,72,84,0,null,70,82,0,null,214,250,0]
["DJ",18,null,72,90,0,null,72,90,0,null,70,88,0,null,214,268,0]
["Brandon",24,null,72,96,0,null,72,96,0,null,70,94,0,null,214,286,0]

{"sheet":"Team Scores","index":1,"n_rows":49,"n_cols":41,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,0,20],[37,1,37,20],[23,1,23,20],[14,23,14,40]]}
[null,"Camas Meadows - Day 1 Scores"]
[null,null,"Hole",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,"HDCP",7,13,9,3,15,1,11,17,5,12,6,2,16,8,14,4,18,10]
[null,"Player"]
["1A","Lucas ",2,3,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["2A","Matt",4,5,5,2,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["2A","Max",9,5,5,5,5,5,5,5,5,5,5,5,5,5,2,5,5,5,5]
["1A","Chris",11,5,5,5,5,5,5,5,2,5,5,5,5,5,5,5,5,5,5]
["1B","Jeff",11,5,5,5,3,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["2B","Kent",12,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["2B","DJ",18,5,5,3,5,2,5,5,5,5,5,5,5,5,5,5,5,5,5]
["1B","Brandon",24,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," DO not touch - Helper Columns"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,"Total",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["1A","Team 1 A  (Lucas/Chris)",null,{"$f":"MIN(IF($A$5:$A$12=$A17,D$28:D$35))","v":3},{"$f":"MIN(IF($A$5:$A$12=$A17,E$28:E$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A17,F$28:F$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,G$28:G$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,H$28:H$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A17,I$28:I$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,J$28:J$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,K$28:K$35))","v":2},{"$f":"MIN(IF($A$5:$A$12=$A17,L$28:L$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,M$28:M$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A17,N$28:N$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,O$28:O$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,P$28:P$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A17,Q$28:Q$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,R$28:R$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A17,S$28:S$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A17,T$28:T$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A17,U$28:U$35))","v":4},{"$f":"SUM(X17:AO17)","v":4},null,{"$f":"IF(D17<D18,1,0)","v":1},{"$f":"IF(E17<E18,1,0)","v":0},0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,1]
["2A","Team 2 A (Matt/Max)",null,{"$f":"MIN(IF($A$5:$A$12=$A18,D$28:D$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A18,E$28:E$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,F$28:F$35))","v":2},{"$f":"MIN(IF($A$5:$A$12=$A18,G$28:G$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A18,H$28:H$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,I$28:I$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A18,J$28:J$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,K$28:K$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,L$28:L$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A18,M$28:M$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,N$28:N$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A18,O$28:O$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A18,P$28:P$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,Q$28:Q$35))","v":1},{"$f":"MIN(IF($A$5:$A$12=$A18,R$28:R$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,S$28:S$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A18,T$28:T$35))","v":5},{"$f":"MIN(IF($A$5:$A$12=$A18,U$28:U$35))","v":5},{"$f":"SUM(X18:AO18)","v":2},null,{"$f":"IF(D18<D17,1,0)","v":0},{"$f":"IF(E18<E17,1,0)","v":0},1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,{"$f":"IF(U18<U19,1,0)","v":0}]
[]
["1B","Team 1 B (Jeff/Brandon)",null,{"$f":"MIN(IF($A$5:$A$12=$A20,D$28:D$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,E$28:E$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,F$28:F$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,G$28:G$35))","v":2},{"$f":"MIN(IF($A$5:$A$12=$A20,H$28:H$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,I$28:I$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,J$28:J$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,K$28:K$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,L$28:L$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,M$28:M$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,N$28:N$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,O$28:O$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,P$28:P$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,Q$28:Q$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,R$28:R$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,S$28:S$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,T$28:T$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A20,U$28:U$35))","v":4},{"$f":"SUM(X20:AO20)","v":1},null,{"$f":"IF(D20<D21,1,0)","v":0},{"$f":"IF(E20<E21,1,0)","v":0},{"$f":"IF(F20<F21,1,0)","v":0},{"$f":"IF(G20<G21,1,0)","v":1},{"$f":"IF(H20<H21,1,0)","v":0},{"$f":"IF(I20<I21,1,0)","v":0},{"$f":"IF(J20<J21,1,0)","v":0},{"$f":"IF(K20<K21,1,0)","v":0},{"$f":"IF(L20<L21,1,0)","v":0},{"$f":"IF(M20<M21,1,0)","v":0},{"$f":"IF(N20<N21,1,0)","v":0},{"$f":"IF(O20<O21,1,0)","v":0},{"$f":"IF(P20<P21,1,0)","v":0},{"$f":"IF(Q20<Q21,1,0)","v":0},{"$f":"IF(R20<R21,1,0)","v":0},{"$f":"IF(S20<S21,1,0)","v":0},{"$f":"IF(T20<T21,1,0)","v":0},{"$f":"IF(U20<U21,1,0)","v":0}]
["2B","Team 2 B (Kent/DJ)",null,{"$f":"MIN(IF($A$5:$A$12=$A21,D$28:D$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,E$28:E$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,F$28:F$35))","v":2},{"$f":"MIN(IF($A$5:$A$12=$A21,G$28:G$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,H$28:H$35))","v":1},{"$f":"MIN(IF($A$5:$A$12=$A21,I$28:I$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,J$28:J$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,K$28:K$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,L$28:L$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,M$28:M$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,N$28:N$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,O$28:O$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,P$28:P$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,Q$28:Q$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,R$28:R$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,S$28:S$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,T$28:T$35))","v":4},{"$f":"MIN(IF($A$5:$A$12=$A21,U$28:U$35))","v":4},{"$f":"SUM(X21:AO21)","v":2},null,{"$f":"IF(D21<D20,1,0)","v":0},{"$f":"IF(E21<E20,1,0)","v":0},{"$f":"IF(F21<F20,1,0)","v":1},{"$f":"IF(G21<G20,1,0)","v":0},{"$f":"IF(H21<H20,1,0)","v":1},{"$f":"IF(I21<I20,1,0)","v":0},{"$f":"IF(J21<J20,1,0)","v":0},{"$f":"IF(K21<K20,1,0)","v":0},{"$f":"IF(L21<L20,1,0)","v":0},{"$f":"IF(M21<M20,1,0)","v":0},{"$f":"IF(N21<N20,1,0)","v":0},{"$f":"IF(O21<O20,1,0)","v":0},{"$f":"IF(P21<P20,1,0)","v":0},{"$f":"IF(Q21<Q20,1,0)","v":0},{"$f":"IF(R21<R20,1,0)","v":0},{"$f":"IF(S21<S20,1,0)","v":0},{"$f":"IF(T21<T20,1,0)","v":0},0]
[]
[]
[null,"Camas Meadows - Day 1 (CALCULATIONS)"]
[null,null,"Hole",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,"HDCP",7,13,9,3,15,1,11,17,5,12,6,2,16,8,14,4,18,10]
[null,"Player"]
[null,"Lucas ",2,{"$f":"IF(D$3<=$C5,D5-1,D5)","v":3},{"$f":"IF(E$3<=$C5,E5-1,E5)","v":5},5,5,5,4,5,5,5,5,5,4,5,5,5,5,5,5]
[null,"Matt",4,{"$f":"IF(D$3<=$C6,D6-1,D6)","v":5},5,2,4,5,4,5,5,5,5,5,4,5,5,5,4,5,5]
[null,"Max",9,{"$f":"IF(D$3<=$C7,D7-1,D7)","v":4},5,4,4,5,4,5,5,4,5,4,4,5,1,5,4,5,5]
[null,"Chris",11,{"$f":"IF(D$3<=$C8,D8-1,D8)","v":4},5,4,4,5,4,4,2,4,5,4,4,5,4,5,4,5,4]
[null,"Jeff",11,{"$f":"IF(D$3<=$C9,D9-1,D9)","v":4},5,4,2,5,4,4,5,4,5,4,4,5,4,5,4,5,4]
[null,"Kent",12,{"$f":"IF(D$3<=$C10,D10-1,D10)","v":4},5,4,4,5,4,4,5,4,4,4,4,5,4,5,4,5,4]
[null,"DJ",18,{"$f":"IF(D$3<=$C11,D11-1,D11)","v":4},4,2,4,1,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,"Brandon",24,{"$f":"IF(D$3<=$C12,D12-1,D12)","v":4},4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[]
[]
[null,"Camas Meadows - Day 1 (Static takes into account HDCP for course)"]
[null,null,"Hole",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,"HDCP",7,13,9,3,15,1,11,17,5,12,6,2,16,8,14,4,18,10]
[null,"Player"]
[null,"Lucas ",2,null,null,null,null,null,1,null,null,null,null,null,1]
[null,"Matt",4,null,null,null,1,null,1,null,null,null,null,null,1,null,null,null,1]
[null,"Max",9,1,null,1,1,null,1,null,null,1,null,1,1,null,1,null,1]
[null,"Chris",11,1,null,1,1,null,1,1,null,1,null,1,1,null,1,null,1,null,1]
[null,"Jeff",11,1,null,1,1,null,1,1,null,1,null,1,1,null,1,null,1,null,1]
[null,"Kent",12,1,null,1,1,null,1,1,null,1,1,1,1,null,1,null,1,null,1]
[null,"DJ",18,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Brandon",24,1,1,1,2,1,2,1,1,2,1,2,2,1,1,1,2,1,1]

{"sheet":"Team Scores (2)","index":2,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,20],[13,1,13,20]]}
[null,"Camas Meadows - Day 1 Scores"]
[null,null,"Hole",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,"HDCP",7,13,9,3,15,1,11,17,5,12,6,2,16,8,14,4,18,10]
[null,"Player",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUT","IN","TOT"]
["1A","Lucas ",2,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,{"$f":"SUM(D5:L5)","v":36},{"$f":"SUM(M5:U5)","v":36},{"$f":"V5+W5","v":72}]
["2A","Matt",4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,{"$f":"SUM(D6:L6)","v":36},{"$f":"SUM(M6:U6)","v":36},{"$f":"V6+W6","v":72}]
["2A","Max",9,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,36,36,72]
["1A","Chris",11,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,36,36,72]
["1B","Jeff",11,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,36,36,72]
["2B","Kent",12,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,36,36,72]
["2B","DJ",18,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,36,36,72]
["1B","Brandon",24,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,36,36,72]
[]
[null,"Net Scores"]
[null,null,"Hole",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,"HDCP",7,13,9,3,15,1,11,17,5,12,6,2,16,8,14,4,18,10]
[null,"Player",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUT","IN","TOT"]
[null,"Lucas ",2,4,4,4,4,4,3,4,4,4,4,4,3,4,4,4,4,4,4,{"$f":"SUM(D18:L18)","v":35},{"$f":"SUM(M18:U18)","v":35},{"$f":"V18+W18","v":70}]
[null,"Matt",4,4,4,4,3,4,3,4,4,4,4,4,3,4,4,4,3,4,4,{"$f":"SUM(D19:L19)","v":34},{"$f":"SUM(M19:U19)","v":34},{"$f":"V19+W19","v":68}]
[null,"Max",9,3,4,3,3,4,3,4,4,3,4,3,3,4,3,4,3,4,4,31,32,63]
[null,"Chris",11,3,4,3,3,4,3,3,4,3,4,3,3,4,3,4,3,4,3,30,31,61]
[null,"Jeff",11,3,4,3,3,4,3,3,4,3,4,3,3,4,3,4,3,4,3,30,31,61]
[null,"Kent",12,3,4,3,3,4,3,3,4,3,3,3,3,4,3,4,3,4,3,30,30,60]
[null,"DJ",18,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,27,27,54]
[null,"Brandon",24,4,4,4,2,4,2,4,4,2,4,2,2,4,4,4,2,4,4,30,30,60]
[]
[null,"Teams",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,"Total"]
[null,"1A",null,3,4,3,3,4,3,3,4,3,4,3,3,4,3,4,3,4,3,2]
[null,"2A",null,3,4,3,3,4,3,4,4,3,4,3,3,4,3,4,3,4,4]
[]
[null,"1B",null,3,4,3,2,4,2,3,4,2,4,2,2,4,3,4,2,4,3,6]
[null,"2B",null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,7]