{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Masterlist 2015","print list","Flight schedule Odd 1-9","Labels 1-9","Flight schedule Even 10-18","Labels Even 10-18","Lookup Handicaps Red","sample sheet - printable list"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":25,"comments":5,"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":"Masterlist 2015","index":0,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["ID","Last Name","First Name","Full Name","MF","Handicap","Shotgun April 9","PLHCP 1-9","PLHCP 10-18"]
[1,"Aaron","Frank",{"$f":"CONCATENATE(C2, \" \", B2)","v":"Frank Aaron"},"M",null,null,{"$f":"IFERROR(IF(E2=\"M\",VLOOKUP($F2,M1RedPLHCP,2),VLOOKUP($F2,W1RedPLHCP,2)),\"\")","v":""},{"$f":"IFERROR(IF($E2=\"M\",VLOOKUP($F2,M10RedPLHCP,2),VLOOKUP($F2,W10RedPLHCP,2)),\"\")","v":""}]
[2,"Anderson","David","David Anderson","M",null,null,"",""]
[3,"Applegate","Ellen","Ellen Applegate","F",27.9,"yes",18,18]
[4,"Bagley","Ken","Ken Bagley","M",22.3,null,10,10]
[5,"Burrows","Mike","Mike Burrows","M",20.399999999999999,"yes",9,9]
[6,"Clark","John","John Clark","M",28.1,null,13,13]
[7,"Callahan","Annie","Annie Callahan","F",24,"yes",15,16]
[8,"Chandler","Sheri","Sheri Chandler","F",24.7,"yes",16,16]
[9,"Conroy","Marc","Marc Conroy","M",24.5,null,11,11]
[10,"Davis","Janet","Janet Davis","F",24.9,null,16,16]
[11,"Daniel","Brett","Brett Daniel","M",26.7,"yes",12,12]
[12,"Day","Steve","Steve Day","M",28.2,null,13,13]
[13,"Denham","Mary","Mary Denham","F",23.7,null,15,16]
[14,"Dodge","Kathy","Kathy Dodge","F",23.9,"yes",15,16]
[15,"Douglass","Angela","Angela Douglass","F",28.5,"yes",18,19]
[16,"Evans","Justin","Justin Evans","M",13.4,"yes",5,5]
[17,"Fernandez","Manny","Manny Fernandez","M",23.7,null,11,10]
[18,"Fisher","Heather","Heather Fisher","F",28.5,"yes",18,19]
[19,"Fitch","Deborah","Deborah Fitch","F",24.6,"yes",16,16]
[20,"Forbes","Richard","Richard Forbes","M",20.2,null,9,9]
[21,"Ford","Chris","Chris Ford","M",26.5,"yes",12,12]
[22,"Gallagher","Daniel","Daniel Gallagher","M",26.4,"yes",12,12]
[23,"Garcia","Alan","Alan Garcia","M",23.5,null,10,10]
[24,"Gibson","Justin","Justin Gibson","M",22.9,null,10,10]
[25,"Goldberg","Beth Ann","Beth Ann Goldberg","F",43,"yes",26,27]
[26,"Hall","Molly","Molly Hall","F",29.6,null,19,19]
[27,"Hamilton","Dan","Dan Hamilton","M",25,null,11,11]
[28,"Hunt","Charlie","Charlie Hunt","M",32,null,15,15]
[29,"Ipsen","Julie","Julie Ipsen","F",31.8,"yes",20,21]
[30,"Johnson","Leann","Leann Johnson","F",36,null,23,23]
[31,"Johnson","Regina","Regina Johnson","F",28.8,null,18,19]
[32,"Johnson","Karl","Karl Johnson","M",36,null,17,16]
[33,"King","Molly",{"$f":"CONCATENATE(C34, \" \", B34)","v":"Molly King"},"F",36.4,"yes",{"$f":"IFERROR(IF(E34=\"M\",VLOOKUP($F34,M1RedPLHCP,2),VLOOKUP($F34,W1RedPLHCP,2)),\"\")","v":23},{"$f":"IFERROR(IF($E34=\"M\",VLOOKUP($F34,M10RedPLHCP,2),VLOOKUP($F34,W10RedPLHCP,2)),\"\")","v":23}]
[34,"Lee","David","David Lee","M",29.1,null,13,13]
[35,"Martinez","Mary","Mary Martinez","F",14,"yes",9,9]
[36,"Matthews","Andrew","Andrew Matthews","M",19,"yes",8,8]
[37,"McPherson","Lora","Lora McPherson","F",18.5,null,12,12]
[38,"Moore","Scott","Scott Moore","M",25,null,11,11]
[39,"Murray","Mike","Mike Murray","M",21.4,"yes",9,9]
[40,"Niemeyer","Diana","Diana Niemeyer","F",20.3,"yes",13,13]
[41,"O'Sullivan","Amy","Amy O'Sullivan","F",22.5,null,14,15]
[42,"Palmer","Pat","Pat Palmer","M",36,"yes",17,16]
[43,"Peterson","Emilia","Emilia Peterson","F",44,null,27,27]
[44,"Price","Shaun","Shaun Price","M",43,null,21,20]
[45,"Riggs","Andy","Andy Riggs","M",36,"yes",17,16]
[46,"Rodriguez","Kevin","Kevin Rodriguez","M",36,"yes",17,16]
[47,"Schmidt","Tom","Tom Schmidt","M",27.1,null,12,12]
[48,"Schultz","Nick","Nick Schultz","M",18.399999999999999,"yes",8,8]
[49,"Wood","Harry","Harry Wood","M",17.899999999999999,"yes",8,8]
[50,"Young","Dave","Dave Young","M",24,"yes",11,11]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null,{"$f":"CONCATENATE(C66, \" \", B66)","v":" "}]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]

{"sheet":"print list","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Shotgun April 9"]
["ID","Full Name","MF","Handicap","Shotgun April 9","PLHCP 1-9"]
[16,"Justin Evans","M",13.4,"yes",5]
[49,"Harry Wood","M",17.899999999999999,"yes",8]
[48,"Nick Schultz","M",18.399999999999999,"yes",8]
[36,"Andrew Matthews","M",19,"yes",8]
[5,"Mike Burrows","M",20.399999999999999,"yes",9]
[39,"Mike Murray","M",21.4,"yes",9]
[2,"David Anderson","M",21.5,"yes",9]
[50,"Dave Young","M",24,"yes",11]
[1,"Frank Aaron","M",24.3,"yes",11]
[22,"Daniel Gallagher","M",26.4,"yes",12]
[21,"Chris Ford","M",26.5,"yes",12]
[11,"Brett Daniel","M",26.7,"yes",12]
[42,"Pat Palmer","M",36,"yes",17]
[45,"Andy Riggs","M",36,"yes",17]
[46,"Kevin Rodriguez","M",36,"yes",17]
[35,"Mary Martinez","F",14,"yes",9]
[40,"Diana Niemeyer","F",20.3,"yes",13]
[7,"Annie Callahan","F",22.9,"yes",14]
[14,"Kathy Dodge","F",23.9,"yes",15]
[19,"Deborah Fitch","F",24.6,"yes",16]
[8,"Sheri Chandler","F",24.7,"yes",16]
[3,"Ellen Applegate","F",27.9,"yes",18]
[15,"Angela Douglass","F",28.5,"yes",18]
[18,"Heather Fisher","F",28.5,"yes",18]
[29,"Julie Ipsen","F",31.8,"yes",20]
[33,"Molly King","F",36.4,"yes",23]
[25,"Beth Ann Goldberg","F",43,"yes",26]

{"sheet":"Flight schedule Odd 1-9","index":2,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,10,2,11]]}
["Flight schedule Shotgun Greensome - Holes 1-9",null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-04-13"},null,null,null,null,null,"Terminology used:"]
[null,null,0.6,null,null,0.4,null,null,null,null,null,null,null,"Shotgun"]
["No 1","Player 1","HCP1","No 2","Player 2","HCP2","Extra Strokes","Point score",null,null,"Game Scores",null,null,"Greensome"]
["Hole 1","Flight 1",null,null,null,null,null,null,null,null,"Winning",{"$f":"MAX(L5:L24)","v":39},"Rank"]
[null,{"$f":"IFERROR(VLOOKUP($A5,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D5,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D5,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D5>=1,(C5*$C$2)+(F5*$F$2),C5)","v":""},null,null,null,"Flight 1",{"$f":"H7","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L5,$L$5:$L$14),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A6,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D6,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D6,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D6>=1,(C6*$C$2)+(F6*$F$2),C6)","v":""},null,null,null,"Flight 2",{"$f":"H11","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L6,$L$5:$L$14)+COUNTIF(L$5:L5,L6),\"\")","v":""}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H5:H6)<=0,\"\",SUM(H5:H6))","v":""},null,null,"Flight 3",{"$f":"H15","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L7,$L$5:$L$14)+COUNTIF(L$5:L6,L7),\"\")","v":""}]
["Hole 2","Flight 2",null,null,null,null,null,null,null,null,"Flight 4",{"$f":"H19","v":39},{"$f":"IFERROR(_xlfn.RANK.EQ(L8,$L$5:$L$14)+COUNTIF(L$5:L7,L8),\"\")","v":1}]
[7,{"$f":"IFERROR(VLOOKUP($A9,Masterlist,4,FALSE),\"\")","v":"Annie Callahan"},{"$f":"IFERROR(VLOOKUP($A9,Masterlist,8,FALSE),\"\")","v":15},42,{"$f":"IFERROR(VLOOKUP($D9,Masterlist,4,FALSE),\"\")","v":"Pat Palmer"},{"$f":"IFERROR(VLOOKUP($D9,Masterlist,8,FALSE),\"\")","v":17},{"$f":"IF(D9>=1,(C9*$C$2)+(F9*$F$2),C9)","v":15.8},null,null,null,"Flight 5",{"$f":"H23","v":34},{"$f":"IFERROR(_xlfn.RANK.EQ(L9,$L$5:$L$14)+COUNTIF(L$5:L8,L9),\"\")","v":4}]
[14,{"$f":"IFERROR(VLOOKUP($A10,Masterlist,4,FALSE),\"\")","v":"Kathy Dodge"},{"$f":"IFERROR(VLOOKUP($A10,Masterlist,8,FALSE),\"\")","v":15},45,{"$f":"IFERROR(VLOOKUP($D10,Masterlist,4,FALSE),\"\")","v":"Andy Riggs"},{"$f":"IFERROR(VLOOKUP($D10,Masterlist,8,FALSE),\"\")","v":17},{"$f":"IF(D10>=1,(C10*$C$2)+(F10*$F$2),C10)","v":15.8},null,null,null,"Flight 6",{"$f":"H27","v":35},{"$f":"IFERROR(_xlfn.RANK.EQ(L10,$L$5:$L$14)+COUNTIF(L$5:L9,L10),\"\")","v":3}]
[null,{"$f":"IFERROR(VLOOKUP($A11,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,Masterlist,7,FALSE),\"\")","v":""},null,"Totaal",null,null,{"$f":"IF(SUM(H9:H10)<=0,\"\",SUM(H9:H10))","v":""},null,null,"Flight 7",{"$f":"H31","v":38},{"$f":"IFERROR(_xlfn.RANK.EQ(L11,$L$5:$L$14)+COUNTIF(L$5:L10,L11),\"\")","v":2}]
["Hole 3","Flight 3",null,null,null,null,null,null,null,null,"Flight 8",{"$f":"H35","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L12,$L$5:$L$14)+COUNTIF(L$5:L11,L12),\"\")","v":""}]
[5,{"$f":"IFERROR(VLOOKUP($A13,Masterlist,4,FALSE),\"\")","v":"Mike Burrows"},{"$f":"IFERROR(VLOOKUP($A13,Masterlist,8,FALSE),\"\")","v":9},19,{"$f":"IFERROR(VLOOKUP($D13,Masterlist,4,FALSE),\"\")","v":"Deborah Fitch"},{"$f":"IFERROR(VLOOKUP($D13,Masterlist,8,FALSE),\"\")","v":16},{"$f":"IF(D13>=1,(C13*$C$2)+(F13*$F$2),C13)","v":11.8},null,null,null,"Flight 9",{"$f":"H39","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L13,$L$5:$L$14)+COUNTIF(L$5:L12,L13),\"\")","v":""}]
[8,{"$f":"IFERROR(VLOOKUP($A14,Masterlist,4,FALSE),\"\")","v":"Sheri Chandler"},{"$f":"IFERROR(VLOOKUP($A14,Masterlist,8,FALSE),\"\")","v":16},46,{"$f":"IFERROR(VLOOKUP($D14,Masterlist,4,FALSE),\"\")","v":"Kevin Rodriguez"},{"$f":"IFERROR(VLOOKUP($D14,Masterlist,8,FALSE),\"\")","v":17},{"$f":"IF(D14>=1,(C14*$C$2)+(F14*$F$2),C14)","v":16.399999999999999},null,null,null,"Flight 10",{"$f":"H43","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L14,$L$5:$L$14)+COUNTIF(L$5:L13,L14),\"\")","v":""}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H13:H14)<=0,\"\",SUM(H13:H14))","v":""}]
["Hole 4","Flight 4"]
[36,{"$f":"IFERROR(VLOOKUP($A17,Masterlist,4,FALSE),\"\")","v":"Andrew Matthews"},{"$f":"IFERROR(VLOOKUP($A17,Masterlist,8,FALSE),\"\")","v":8},15,{"$f":"IFERROR(VLOOKUP($D17,Masterlist,4,FALSE),\"\")","v":"Angela Douglass"},{"$f":"IFERROR(VLOOKUP($D17,Masterlist,8,FALSE),\"\")","v":18},{"$f":"IF(D17>=1,(C17*$C$2)+(F17*$F$2),C17)","v":12},19]
[48,{"$f":"IFERROR(VLOOKUP($A18,Masterlist,4,FALSE),\"\")","v":"Nick Schultz"},{"$f":"IFERROR(VLOOKUP($A18,Masterlist,8,FALSE),\"\")","v":8},3,{"$f":"IFERROR(VLOOKUP($D18,Masterlist,4,FALSE),\"\")","v":"Ellen Applegate"},{"$f":"IFERROR(VLOOKUP($D18,Masterlist,8,FALSE),\"\")","v":18},{"$f":"IF(D18>=1,(C18*$C$2)+(F18*$F$2),C18)","v":12},20]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H17:H18)<=0,\"\",SUM(H17:H18))","v":39}]
["Hole 5","Flight 5"]
[11,{"$f":"IFERROR(VLOOKUP($A21,Masterlist,4,FALSE),\"\")","v":"Brett Daniel"},{"$f":"IFERROR(VLOOKUP($A21,Masterlist,8,FALSE),\"\")","v":12},18,{"$f":"IFERROR(VLOOKUP($D21,Masterlist,4,FALSE),\"\")","v":"Heather Fisher"},{"$f":"IFERROR(VLOOKUP($D21,Masterlist,8,FALSE),\"\")","v":18},{"$f":"IF(D21>=1,(C21*$C$2)+(F21*$F$2),C21)","v":14.399999999999999},16]
[39,{"$f":"IFERROR(VLOOKUP($A22,Masterlist,4,FALSE),\"\")","v":"Mike Murray"},{"$f":"IFERROR(VLOOKUP($A22,Masterlist,8,FALSE),\"\")","v":9},29,{"$f":"IFERROR(VLOOKUP($D22,Masterlist,4,FALSE),\"\")","v":"Julie Ipsen"},{"$f":"IFERROR(VLOOKUP($D22,Masterlist,8,FALSE),\"\")","v":20},{"$f":"IF(D22>=1,(C22*$C$2)+(F22*$F$2),C22)","v":13.399999999999999},18]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H21:H22)<=0,\"\",SUM(H21:H22))","v":34}]
["Hole 6","Flight 6"]
[2,{"$f":"IFERROR(VLOOKUP($A25,Masterlist,4,FALSE),\"\")","v":"David Anderson"},{"$f":"IFERROR(VLOOKUP($A25,Masterlist,8,FALSE),\"\")","v":""},33,{"$f":"IFERROR(VLOOKUP($D25,Masterlist,4,FALSE),\"\")","v":"Molly King"},{"$f":"IFERROR(VLOOKUP($D25,Masterlist,8,FALSE),\"\")","v":23},{"$f":"IF(D25>=1,(C25*$C$2)+(F25*$F$2),C25)","v":{"$error":"#VALUE!"}},20]
[21,{"$f":"IFERROR(VLOOKUP($A26,Masterlist,4,FALSE),\"\")","v":"Chris Ford"},{"$f":"IFERROR(VLOOKUP($A26,Masterlist,8,FALSE),\"\")","v":12},25,{"$f":"IFERROR(VLOOKUP($D26,Masterlist,4,FALSE),\"\")","v":"Beth Ann Goldberg"},{"$f":"IFERROR(VLOOKUP($D26,Masterlist,8,FALSE),\"\")","v":26},{"$f":"IF(D26>=1,(C26*$C$2)+(F26*$F$2),C26)","v":17.600000000000001},15]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H25:H26)<=0,\"\",SUM(H25:H26))","v":35}]
["Hole 7","Flight 7"]
[50,{"$f":"IFERROR(VLOOKUP($A29,Masterlist,4,FALSE),\"\")","v":"Dave Young"},{"$f":"IFERROR(VLOOKUP($A29,Masterlist,8,FALSE),\"\")","v":11},22,{"$f":"IFERROR(VLOOKUP($D29,Masterlist,4,FALSE),\"\")","v":"Daniel Gallagher"},{"$f":"IFERROR(VLOOKUP($D29,Masterlist,8,FALSE),\"\")","v":12},{"$f":"IF(D29>=1,(C29*$C$2)+(F29*$F$2),C29)","v":11.4},19]
[1,{"$f":"IFERROR(VLOOKUP($A30,Masterlist,4,FALSE),\"\")","v":"Frank Aaron"},{"$f":"IFERROR(VLOOKUP($A30,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D30,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D30,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D30>=1,(C30*$C$2)+(F30*$F$2),C30)","v":""},19]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H29:H30)<=0,\"\",SUM(H29:H30))","v":38}]
["Hole 8","Flight 8"]
[null,{"$f":"IFERROR(VLOOKUP($A33,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A33,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D33,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D33,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D33>=1,(C33*$C$2)+(F33*$F$2),C33)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A34,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A34,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D34,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D34,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D34>=1,(C34*$C$2)+(F34*$F$2),C34)","v":""}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H33:H34)<=0,\"\",SUM(H33:H34))","v":""}]
["Hole 9","Flight 9"]
[null,{"$f":"IFERROR(VLOOKUP($A37,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A37,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D37,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D37,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D37>=1,(C37*$C$2)+(F37*$F$2),C37)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A38,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A38,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D38,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D38,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D38>=1,(C38*$C$2)+(F38*$F$2),C38)","v":""}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H37:H38)<=0,\"\",SUM(H37:H38))","v":""}]
["Hole ","Flight 10"]
[null,{"$f":"IFERROR(VLOOKUP($A41,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A41,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D41,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D41,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D41>=1,(C41*$C$2)+(F41*$F$2),C41)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A42,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A42,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D42,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D42,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D42>=1,(C42*$C$2)+(F42*$F$2),C42)","v":""}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H41:H42)<=0,\"\",SUM(H41:H42))","v":""}]

{"sheet":"Labels 1-9","index":3,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Hole","Flight ","Player 1","Player 2","Strokes","Extra Strokes"]
[{"$f":"'Flight schedule Odd 1-9'!A4","v":"Hole 1"},{"$f":"'Flight schedule Odd 1-9'!B4","v":"Flight 1"},{"$f":"'Flight schedule Odd 1-9'!B5","v":""},{"$f":"'Flight schedule Odd 1-9'!E5","v":""},{"$f":"'Flight schedule Odd 1-9'!G5","v":""},{"$f":"IFERROR(IF(E2<=0,\"\",ROUND(E2,0)),\"\")","v":""}]
[{"$f":"'Flight schedule Odd 1-9'!A4","v":"Hole 1"},{"$f":"'Flight schedule Odd 1-9'!B4","v":"Flight 1"},{"$f":"'Flight schedule Odd 1-9'!B6","v":""},{"$f":"'Flight schedule Odd 1-9'!E6","v":""},{"$f":"'Flight schedule Odd 1-9'!G6","v":""},{"$f":"IFERROR(IF(E3<=0,\"\",ROUND(E3,0)),\"\")","v":""}]
[{"$f":"'Flight schedule Odd 1-9'!A8","v":"Hole 2"},{"$f":"'Flight schedule Odd 1-9'!B8","v":"Flight 2"},{"$f":"'Flight schedule Odd 1-9'!B9","v":"Annie Callahan"},{"$f":"'Flight schedule Odd 1-9'!E9","v":"Pat Palmer"},{"$f":"'Flight schedule Odd 1-9'!G9","v":15.8},16]
[{"$f":"'Flight schedule Odd 1-9'!A8","v":"Hole 2"},{"$f":"'Flight schedule Odd 1-9'!B8","v":"Flight 2"},{"$f":"'Flight schedule Odd 1-9'!B10","v":"Kathy Dodge"},{"$f":"'Flight schedule Odd 1-9'!E10","v":"Andy Riggs"},{"$f":"'Flight schedule Odd 1-9'!G10","v":15.8},16]
[{"$f":"'Flight schedule Odd 1-9'!A12","v":"Hole 3"},{"$f":"'Flight schedule Odd 1-9'!B12","v":"Flight 3"},{"$f":"'Flight schedule Odd 1-9'!B13","v":"Mike Burrows"},{"$f":"'Flight schedule Odd 1-9'!E13","v":"Deborah Fitch"},{"$f":"'Flight schedule Odd 1-9'!G13","v":11.8},12]
[{"$f":"'Flight schedule Odd 1-9'!A12","v":"Hole 3"},{"$f":"'Flight schedule Odd 1-9'!B12","v":"Flight 3"},{"$f":"'Flight schedule Odd 1-9'!B14","v":"Sheri Chandler"},{"$f":"'Flight schedule Odd 1-9'!E14","v":"Kevin Rodriguez"},{"$f":"'Flight schedule Odd 1-9'!G14","v":16.399999999999999},16]
[{"$f":"'Flight schedule Odd 1-9'!A16","v":"Hole 4"},{"$f":"'Flight schedule Odd 1-9'!B16","v":"Flight 4"},{"$f":"'Flight schedule Odd 1-9'!B17","v":"Andrew Matthews"},{"$f":"'Flight schedule Odd 1-9'!E17","v":"Angela Douglass"},{"$f":"'Flight schedule Odd 1-9'!G17","v":12},12]
[{"$f":"'Flight schedule Odd 1-9'!A16","v":"Hole 4"},{"$f":"'Flight schedule Odd 1-9'!B16","v":"Flight 4"},{"$f":"'Flight schedule Odd 1-9'!B18","v":"Nick Schultz"},{"$f":"'Flight schedule Odd 1-9'!E18","v":"Ellen Applegate"},{"$f":"'Flight schedule Odd 1-9'!G18","v":12},12]
[{"$f":"'Flight schedule Odd 1-9'!A20","v":"Hole 5"},{"$f":"'Flight schedule Odd 1-9'!B20","v":"Flight 5"},{"$f":"'Flight schedule Odd 1-9'!B21","v":"Brett Daniel"},{"$f":"'Flight schedule Odd 1-9'!E21","v":"Heather Fisher"},{"$f":"'Flight schedule Odd 1-9'!G21","v":14.399999999999999},14]
[{"$f":"'Flight schedule Odd 1-9'!A20","v":"Hole 5"},{"$f":"'Flight schedule Odd 1-9'!B20","v":"Flight 5"},{"$f":"'Flight schedule Odd 1-9'!B22","v":"Mike Murray"},{"$f":"'Flight schedule Odd 1-9'!E22","v":"Julie Ipsen"},{"$f":"'Flight schedule Odd 1-9'!G22","v":13.399999999999999},13]
[{"$f":"'Flight schedule Odd 1-9'!A24","v":"Hole 6"},{"$f":"'Flight schedule Odd 1-9'!B24","v":"Flight 6"},{"$f":"'Flight schedule Odd 1-9'!B25","v":"David Anderson"},{"$f":"'Flight schedule Odd 1-9'!E25","v":"Molly King"},{"$f":"'Flight schedule Odd 1-9'!G25","v":{"$error":"#VALUE!"}},""]
[{"$f":"'Flight schedule Odd 1-9'!A24","v":"Hole 6"},{"$f":"'Flight schedule Odd 1-9'!B24","v":"Flight 6"},{"$f":"'Flight schedule Odd 1-9'!B26","v":"Chris Ford"},{"$f":"'Flight schedule Odd 1-9'!E26","v":"Beth Ann Goldberg"},{"$f":"'Flight schedule Odd 1-9'!G26","v":17.600000000000001},18]
[{"$f":"'Flight schedule Odd 1-9'!A28","v":"Hole 7"},{"$f":"'Flight schedule Odd 1-9'!B28","v":"Flight 7"},{"$f":"'Flight schedule Odd 1-9'!B29","v":"Dave Young"},{"$f":"'Flight schedule Odd 1-9'!E29","v":"Daniel Gallagher"},{"$f":"'Flight schedule Odd 1-9'!G29","v":11.4},11]
[{"$f":"'Flight schedule Odd 1-9'!A28","v":"Hole 7"},{"$f":"'Flight schedule Odd 1-9'!B28","v":"Flight 7"},{"$f":"'Flight schedule Odd 1-9'!B30","v":"Frank Aaron"},{"$f":"'Flight schedule Odd 1-9'!E30","v":""},{"$f":"'Flight schedule Odd 1-9'!G30","v":""},""]
[{"$f":"'Flight schedule Odd 1-9'!A32","v":"Hole 8"},{"$f":"'Flight schedule Odd 1-9'!B32","v":"Flight 8"},{"$f":"'Flight schedule Odd 1-9'!B33","v":""},{"$f":"'Flight schedule Odd 1-9'!E33","v":""},{"$f":"'Flight schedule Odd 1-9'!G33","v":""},""]
[{"$f":"'Flight schedule Odd 1-9'!A32","v":"Hole 8"},{"$f":"'Flight schedule Odd 1-9'!B32","v":"Flight 8"},{"$f":"'Flight schedule Odd 1-9'!B34","v":""},{"$f":"'Flight schedule Odd 1-9'!E34","v":""},{"$f":"'Flight schedule Odd 1-9'!G34","v":""},""]
[{"$f":"'Flight schedule Odd 1-9'!A36","v":"Hole 9"},{"$f":"'Flight schedule Odd 1-9'!B36","v":"Flight 9"},{"$f":"'Flight schedule Odd 1-9'!B37","v":""},{"$f":"'Flight schedule Odd 1-9'!E37","v":""},{"$f":"'Flight schedule Odd 1-9'!G37","v":""},""]
[{"$f":"'Flight schedule Odd 1-9'!A36","v":"Hole 9"},{"$f":"'Flight schedule Odd 1-9'!B36","v":"Flight 9"},{"$f":"'Flight schedule Odd 1-9'!B38","v":""},{"$f":"'Flight schedule Odd 1-9'!E38","v":""},{"$f":"'Flight schedule Odd 1-9'!G38","v":""},""]
[{"$f":"'Flight schedule Odd 1-9'!A40","v":"Hole "},{"$f":"'Flight schedule Odd 1-9'!B40","v":"Flight 10"},{"$f":"'Flight schedule Odd 1-9'!B41","v":""},{"$f":"'Flight schedule Odd 1-9'!E41","v":""},{"$f":"'Flight schedule Odd 1-9'!G41","v":""},""]
[{"$f":"'Flight schedule Odd 1-9'!A40","v":"Hole "},{"$f":"'Flight schedule Odd 1-9'!B40","v":"Flight 10"},{"$f":"'Flight schedule Odd 1-9'!B42","v":""},{"$f":"'Flight schedule Odd 1-9'!E42","v":""},{"$f":"'Flight schedule Odd 1-9'!G42","v":""},""]

{"sheet":"Flight schedule Even 10-18","index":4,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,10,2,11]]}
["FlightIndeling Shotgun Match play - Holes 10-18",null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-04-13"},null,null,null,null,null,"Terminology used:"]
[null,null,0.6,null,null,0.4,null,null,null,null,null,null,null,"Shotgun"]
["No 1","Player 1","HCP1","No 2","PLayer 2","HCP2","Extra Strokes","Point score",null,null,"Game Scores",null,null,"Greensome"]
["Hole 10","Flight 1",null,null,null,null,null,null,null,null,"Winning",{"$f":"MAX(L5:L24)","v":39},"Rank"]
[16,{"$f":"IFERROR(VLOOKUP($A5,Masterlist,4,FALSE),\"\")","v":"Justin Evans"},{"$f":"IFERROR(VLOOKUP($A5,Masterlist,8,FALSE),\"\")","v":5},35,{"$f":"IFERROR(VLOOKUP($D5,Masterlist,4,FALSE),\"\")","v":"Mary Martinez"},{"$f":"IFERROR(VLOOKUP($D5,Masterlist,8,FALSE),\"\")","v":9},{"$f":"IF(D5>=1,(C5*$C$2)+(F5*$F$2),C5)","v":6.6},18,null,null,"Flight 1",{"$f":"H7","v":36},{"$f":"IFERROR(_xlfn.RANK.EQ(L5,$L$5:$L$14),\"\")","v":2}]
[40,{"$f":"IFERROR(VLOOKUP($A6,Masterlist,4,FALSE),\"\")","v":"Diana Niemeyer"},{"$f":"IFERROR(VLOOKUP($A6,Masterlist,8,FALSE),\"\")","v":13},49,{"$f":"IFERROR(VLOOKUP($D6,Masterlist,4,FALSE),\"\")","v":"Harry Wood"},{"$f":"IFERROR(VLOOKUP($D6,Masterlist,8,FALSE),\"\")","v":8},{"$f":"IF(D6>=1,(C6*$C$2)+(F6*$F$2),C6)","v":11},18,null,null,"Flight 2",{"$f":"H11","v":31},{"$f":"IFERROR(_xlfn.RANK.EQ(L6,$L$5:$L$14)+COUNTIF(L$5:L5,L6),\"\")","v":6}]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H5:H6)<=0,\"\",SUM(H5:H6))","v":36},null,null,"Flight 3",{"$f":"H15","v":19},{"$f":"IFERROR(_xlfn.RANK.EQ(L7,$L$5:$L$14)+COUNTIF(L$5:L6,L7),\"\")","v":7}]
["Hole 11","Flight 2",null,null,null,null,null,null,null,null,"Flight 4",{"$f":"H19","v":35},{"$f":"IFERROR(_xlfn.RANK.EQ(L8,$L$5:$L$14)+COUNTIF(L$5:L7,L8),\"\")","v":4}]
[48,{"$f":"IFERROR(VLOOKUP($A9,Masterlist,4,FALSE),\"\")","v":"Nick Schultz"},{"$f":"IFERROR(VLOOKUP($A9,Masterlist,8,FALSE),\"\")","v":8},15,{"$f":"IFERROR(VLOOKUP($D9,Masterlist,4,FALSE),\"\")","v":"Angela Douglass"},{"$f":"IFERROR(VLOOKUP($D9,Masterlist,8,FALSE),\"\")","v":18},{"$f":"IF(D9>=1,(C9*$C$2)+(F9*$F$2),C9)","v":12},12,null,null,"Flight 5",{"$f":"H23","v":34},{"$f":"IFERROR(_xlfn.RANK.EQ(L9,$L$5:$L$14)+COUNTIF(L$5:L8,L9),\"\")","v":5}]
[36,{"$f":"IFERROR(VLOOKUP($A10,Masterlist,4,FALSE),\"\")","v":"Andrew Matthews"},{"$f":"IFERROR(VLOOKUP($A10,Masterlist,8,FALSE),\"\")","v":8},19,{"$f":"IFERROR(VLOOKUP($D10,Masterlist,4,FALSE),\"\")","v":"Deborah Fitch"},{"$f":"IFERROR(VLOOKUP($D10,Masterlist,8,FALSE),\"\")","v":16},{"$f":"IF(D10>=1,(C10*$C$2)+(F10*$F$2),C10)","v":11.2},19,null,null,"Flight 6",{"$f":"H27","v":36},{"$f":"IFERROR(_xlfn.RANK.EQ(L10,$L$5:$L$14)+COUNTIF(L$5:L9,L10),\"\")","v":3}]
[null,{"$f":"IFERROR(VLOOKUP($A11,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,Masterlist,8,FALSE),\"\")","v":""},null,"Total",null,null,{"$f":"IF(SUM(H9:H10)<=0,\"\",SUM(H9:H10))","v":31},null,null,"Flight 7",{"$f":"H31","v":39},{"$f":"IFERROR(_xlfn.RANK.EQ(L11,$L$5:$L$14)+COUNTIF(L$5:L10,L11),\"\")","v":1}]
["Hole 12","Flight 3",null,null,null,null,null,null,null,null,"Flight 8",{"$f":"H35","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L12,$L$5:$L$14)+COUNTIF(L$5:L11,L12),\"\")","v":""}]
[5,{"$f":"IFERROR(VLOOKUP($A13,Masterlist,4,FALSE),\"\")","v":"Mike Burrows"},{"$f":"IFERROR(VLOOKUP($A13,Masterlist,8,FALSE),\"\")","v":9},8,{"$f":"IFERROR(VLOOKUP($D13,Masterlist,4,FALSE),\"\")","v":"Sheri Chandler"},{"$f":"IFERROR(VLOOKUP($D13,Masterlist,8,FALSE),\"\")","v":16},{"$f":"IF(D13>=1,(C13*$C$2)+(F13*$F$2),C13)","v":11.8},10,null,null,"Flight 9",{"$f":"H39","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L13,$L$5:$L$14)+COUNTIF(L$5:L12,L13),\"\")","v":""}]
[39,{"$f":"IFERROR(VLOOKUP($A14,Masterlist,4,FALSE),\"\")","v":"Mike Murray"},{"$f":"IFERROR(VLOOKUP($A14,Masterlist,8,FALSE),\"\")","v":9},3,{"$f":"IFERROR(VLOOKUP($D14,Masterlist,4,FALSE),\"\")","v":"Ellen Applegate"},{"$f":"IFERROR(VLOOKUP($D14,Masterlist,8,FALSE),\"\")","v":18},{"$f":"IF(D14>=1,(C14*$C$2)+(F14*$F$2),C14)","v":12.6},9,null,null,"Flight 10",{"$f":"H43","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L14,$L$5:$L$14)+COUNTIF(L$5:L13,L14),\"\")","v":""}]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H13:H14)<=0,\"\",SUM(H13:H14))","v":19}]
["Hole 13","Flight 4"]
[2,{"$f":"IFERROR(VLOOKUP($A17,Masterlist,4,FALSE),\"\")","v":"David Anderson"},{"$f":"IFERROR(VLOOKUP($A17,Masterlist,8,FALSE),\"\")","v":""},15,{"$f":"IFERROR(VLOOKUP($D17,Masterlist,4,FALSE),\"\")","v":"Angela Douglass"},{"$f":"IFERROR(VLOOKUP($D17,Masterlist,8,FALSE),\"\")","v":18},{"$f":"IF(D17>=1,(C17*$C$2)+(F17*$F$2),C17)","v":{"$error":"#VALUE!"}},20]
[50,{"$f":"IFERROR(VLOOKUP($A18,Masterlist,4,FALSE),\"\")","v":"Dave Young"},{"$f":"IFERROR(VLOOKUP($A18,Masterlist,8,FALSE),\"\")","v":11},18,{"$f":"IFERROR(VLOOKUP($D18,Masterlist,4,FALSE),\"\")","v":"Heather Fisher"},{"$f":"IFERROR(VLOOKUP($D18,Masterlist,8,FALSE),\"\")","v":18},{"$f":"IF(D18>=1,(C18*$C$2)+(F18*$F$2),C18)","v":13.8},15]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H17:H18)<=0,\"\",SUM(H17:H18))","v":35}]
["Hole 14","Flight 5"]
[22,{"$f":"IFERROR(VLOOKUP($A21,Masterlist,4,FALSE),\"\")","v":"Daniel Gallagher"},{"$f":"IFERROR(VLOOKUP($A21,Masterlist,8,FALSE),\"\")","v":12},29,{"$f":"IFERROR(VLOOKUP($D21,Masterlist,4,FALSE),\"\")","v":"Julie Ipsen"},{"$f":"IFERROR(VLOOKUP($D21,Masterlist,8,FALSE),\"\")","v":20},{"$f":"IF(D21>=1,(C21*$C$2)+(F21*$F$2),C21)","v":15.2},16]
[21,{"$f":"IFERROR(VLOOKUP($A22,Masterlist,4,FALSE),\"\")","v":"Chris Ford"},{"$f":"IFERROR(VLOOKUP($A22,Masterlist,8,FALSE),\"\")","v":12},33,{"$f":"IFERROR(VLOOKUP($D22,Masterlist,4,FALSE),\"\")","v":"Molly King"},{"$f":"IFERROR(VLOOKUP($D22,Masterlist,8,FALSE),\"\")","v":23},{"$f":"IF(D22>=1,(C22*$C$2)+(F22*$F$2),C22)","v":16.399999999999999},18]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H21:H22)<=0,\"\",SUM(H21:H22))","v":34}]
["Hole 15","Flight 6"]
[11,{"$f":"IFERROR(VLOOKUP($A25,Masterlist,4,FALSE),\"\")","v":"Brett Daniel"},{"$f":"IFERROR(VLOOKUP($A25,Masterlist,8,FALSE),\"\")","v":12},25,{"$f":"IFERROR(VLOOKUP($D25,Masterlist,4,FALSE),\"\")","v":"Beth Ann Goldberg"},{"$f":"IFERROR(VLOOKUP($D25,Masterlist,8,FALSE),\"\")","v":26},{"$f":"IF(D25>=1,(C25*$C$2)+(F25*$F$2),C25)","v":17.600000000000001},17]
[42,{"$f":"IFERROR(VLOOKUP($A26,Masterlist,4,FALSE),\"\")","v":"Pat Palmer"},{"$f":"IFERROR(VLOOKUP($A26,Masterlist,8,FALSE),\"\")","v":17},null,{"$f":"IFERROR(VLOOKUP($D26,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D26,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D26>=1,(C26*$C$2)+(F26*$F$2),C26)","v":17},19]
[null,{"$f":"IFERROR(VLOOKUP($A27,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A27,Masterlist,8,FALSE),\"\")","v":""},null,"Total",null,null,{"$f":"IF(SUM(H25:H26)<=0,\"\",SUM(H25:H26))","v":36}]
["Hole 16","Flight 7"]
[45,{"$f":"IFERROR(VLOOKUP($A29,Masterlist,4,FALSE),\"\")","v":"Andy Riggs"},{"$f":"IFERROR(VLOOKUP($A29,Masterlist,8,FALSE),\"\")","v":17},46,{"$f":"IFERROR(VLOOKUP($D29,Masterlist,4,FALSE),\"\")","v":"Kevin Rodriguez"},{"$f":"IFERROR(VLOOKUP($D29,Masterlist,8,FALSE),\"\")","v":17},{"$f":"IF(D29>=1,(C29*$C$2)+(F29*$F$2),C29)","v":17},19]
[null,{"$f":"IFERROR(VLOOKUP($A30,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A30,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D30,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D30,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D30>=1,(C30*$C$2)+(F30*$F$2),C30)","v":""},20]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H29:H30)<=0,\"\",SUM(H29:H30))","v":39}]
["Hole 17","Flight 8"]
[null,{"$f":"IFERROR(VLOOKUP($A33,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A33,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D33,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D33,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D33>=1,(C33*$C$2)+(F33*$F$2),C33)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A34,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A34,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D34,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D34,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D34>=1,(C34*$C$2)+(F34*$F$2),C34)","v":""}]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H33:H34)<=0,\"\",SUM(H33:H34))","v":""}]
["Hole 18","Flight 9"]
[null,{"$f":"IFERROR(VLOOKUP($A37,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A37,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D37,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D37,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D37>=1,(C37*$C$2)+(F37*$F$2),C37)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A38,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A38,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D38,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D38,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D38>=1,(C38*$C$2)+(F38*$F$2),C38)","v":""}]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H37:H38)<=0,\"\",SUM(H37:H38))","v":""}]
["Hole ","Flight 10"]
[null,{"$f":"IFERROR(VLOOKUP($A41,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A41,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D41,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D41,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D41>=1,(C41*$C$2)+(F41*$F$2),C41)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A42,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A42,Masterlist,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D42,Masterlist,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D42,Masterlist,8,FALSE),\"\")","v":""},{"$f":"IF(D42>=1,(C42*$C$2)+(F42*$F$2),C42)","v":""}]
[null,null,null,null,"Total",null,null,{"$f":"IF(SUM(H41:H42)<=0,\"\",SUM(H41:H42))","v":""}]

{"sheet":"Labels Even 10-18","index":5,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Hole","Flight ","Player 1","Player 2","Strokes","Extra Strokes"]
[{"$f":"'Flight schedule Even 10-18'!A4","v":"Hole 10"},{"$f":"'Flight schedule Even 10-18'!B4","v":"Flight 1"},{"$f":"'Flight schedule Even 10-18'!B5","v":"Justin Evans"},{"$f":"'Flight schedule Even 10-18'!E5","v":"Mary Martinez"},{"$f":"'Flight schedule Even 10-18'!G5","v":6.6},{"$f":"IFERROR(IF(E2<0,\"\",ROUND(E2,0)),\"\")","v":7}]
[{"$f":"'Flight schedule Even 10-18'!A4","v":"Hole 10"},{"$f":"'Flight schedule Even 10-18'!B4","v":"Flight 1"},{"$f":"'Flight schedule Even 10-18'!B6","v":"Diana Niemeyer"},{"$f":"'Flight schedule Even 10-18'!E6","v":"Harry Wood"},{"$f":"'Flight schedule Even 10-18'!G6","v":11},{"$f":"IFERROR(IF(E3<0,\"\",ROUND(E3,0)),\"\")","v":11}]
[{"$f":"'Flight schedule Even 10-18'!A8","v":"Hole 11"},{"$f":"'Flight schedule Even 10-18'!B8","v":"Flight 2"},{"$f":"'Flight schedule Even 10-18'!B9","v":"Nick Schultz"},{"$f":"'Flight schedule Even 10-18'!E9","v":"Angela Douglass"},{"$f":"'Flight schedule Even 10-18'!G9","v":12},12]
[{"$f":"'Flight schedule Even 10-18'!A8","v":"Hole 11"},{"$f":"'Flight schedule Even 10-18'!B8","v":"Flight 2"},{"$f":"'Flight schedule Even 10-18'!B10","v":"Andrew Matthews"},{"$f":"'Flight schedule Even 10-18'!E10","v":"Deborah Fitch"},{"$f":"'Flight schedule Even 10-18'!G10","v":11.2},11]
[{"$f":"'Flight schedule Even 10-18'!A12","v":"Hole 12"},{"$f":"'Flight schedule Even 10-18'!B12","v":"Flight 3"},{"$f":"'Flight schedule Even 10-18'!B13","v":"Mike Burrows"},{"$f":"'Flight schedule Even 10-18'!E13","v":"Sheri Chandler"},{"$f":"'Flight schedule Even 10-18'!G13","v":11.8},12]
[{"$f":"'Flight schedule Even 10-18'!A12","v":"Hole 12"},{"$f":"'Flight schedule Even 10-18'!B12","v":"Flight 3"},{"$f":"'Flight schedule Even 10-18'!B14","v":"Mike Murray"},{"$f":"'Flight schedule Even 10-18'!E14","v":"Ellen Applegate"},{"$f":"'Flight schedule Even 10-18'!G14","v":12.6},13]
[{"$f":"'Flight schedule Even 10-18'!A16","v":"Hole 13"},{"$f":"'Flight schedule Even 10-18'!B16","v":"Flight 4"},{"$f":"'Flight schedule Even 10-18'!B17","v":"David Anderson"},{"$f":"'Flight schedule Even 10-18'!E17","v":"Angela Douglass"},{"$f":"'Flight schedule Even 10-18'!G17","v":{"$error":"#VALUE!"}},""]
[{"$f":"'Flight schedule Even 10-18'!A16","v":"Hole 13"},{"$f":"'Flight schedule Even 10-18'!B16","v":"Flight 4"},{"$f":"'Flight schedule Even 10-18'!B18","v":"Dave Young"},{"$f":"'Flight schedule Even 10-18'!E18","v":"Heather Fisher"},{"$f":"'Flight schedule Even 10-18'!G18","v":13.8},14]
[{"$f":"'Flight schedule Even 10-18'!A20","v":"Hole 14"},{"$f":"'Flight schedule Even 10-18'!B20","v":"Flight 5"},{"$f":"'Flight schedule Even 10-18'!B21","v":"Daniel Gallagher"},{"$f":"'Flight schedule Even 10-18'!E21","v":"Julie Ipsen"},{"$f":"'Flight schedule Even 10-18'!G21","v":15.2},15]
[{"$f":"'Flight schedule Even 10-18'!A20","v":"Hole 14"},{"$f":"'Flight schedule Even 10-18'!B20","v":"Flight 5"},{"$f":"'Flight schedule Even 10-18'!B22","v":"Chris Ford"},{"$f":"'Flight schedule Even 10-18'!E22","v":"Molly King"},{"$f":"'Flight schedule Even 10-18'!G22","v":16.399999999999999},16]
[{"$f":"'Flight schedule Even 10-18'!A24","v":"Hole 15"},{"$f":"'Flight schedule Even 10-18'!B24","v":"Flight 6"},{"$f":"'Flight schedule Even 10-18'!B25","v":"Brett Daniel"},{"$f":"'Flight schedule Even 10-18'!E25","v":"Beth Ann Goldberg"},{"$f":"'Flight schedule Even 10-18'!G25","v":17.600000000000001},18]
[{"$f":"'Flight schedule Even 10-18'!A24","v":"Hole 15"},{"$f":"'Flight schedule Even 10-18'!B24","v":"Flight 6"},{"$f":"'Flight schedule Even 10-18'!B26","v":"Pat Palmer"},{"$f":"'Flight schedule Even 10-18'!E26","v":""},{"$f":"'Flight schedule Even 10-18'!G26","v":17},17]
[{"$f":"'Flight schedule Even 10-18'!A28","v":"Hole 16"},{"$f":"'Flight schedule Even 10-18'!B28","v":"Flight 7"},{"$f":"'Flight schedule Even 10-18'!B29","v":"Andy Riggs"},{"$f":"'Flight schedule Even 10-18'!E29","v":"Kevin Rodriguez"},{"$f":"'Flight schedule Even 10-18'!G29","v":17},17]
[{"$f":"'Flight schedule Even 10-18'!A28","v":"Hole 16"},{"$f":"'Flight schedule Even 10-18'!B28","v":"Flight 7"},{"$f":"'Flight schedule Even 10-18'!B30","v":""},{"$f":"'Flight schedule Even 10-18'!E30","v":""},{"$f":"'Flight schedule Even 10-18'!G30","v":""},""]
[{"$f":"'Flight schedule Even 10-18'!A32","v":"Hole 17"},{"$f":"'Flight schedule Even 10-18'!B32","v":"Flight 8"},{"$f":"'Flight schedule Even 10-18'!B33","v":""},{"$f":"'Flight schedule Even 10-18'!E33","v":""},{"$f":"'Flight schedule Even 10-18'!G33","v":""},""]
[{"$f":"'Flight schedule Even 10-18'!A32","v":"Hole 17"},{"$f":"'Flight schedule Even 10-18'!B32","v":"Flight 8"},{"$f":"'Flight schedule Even 10-18'!B34","v":""},{"$f":"'Flight schedule Even 10-18'!E34","v":""},{"$f":"'Flight schedule Even 10-18'!G34","v":""},""]
[{"$f":"'Flight schedule Even 10-18'!A36","v":"Hole 18"},{"$f":"'Flight schedule Even 10-18'!B36","v":"Flight 9"},{"$f":"'Flight schedule Even 10-18'!B37","v":""},{"$f":"'Flight schedule Even 10-18'!E37","v":""},{"$f":"'Flight schedule Even 10-18'!G37","v":""},""]
[{"$f":"'Flight schedule Even 10-18'!A36","v":"Hole 18"},{"$f":"'Flight schedule Even 10-18'!B36","v":"Flight 9"},{"$f":"'Flight schedule Even 10-18'!B38","v":""},{"$f":"'Flight schedule Even 10-18'!E38","v":""},{"$f":"'Flight schedule Even 10-18'!G38","v":""},""]
[{"$f":"'Flight schedule Even 10-18'!A40","v":"Hole "},{"$f":"'Flight schedule Even 10-18'!B40","v":"Flight 10"},{"$f":"'Flight schedule Even 10-18'!B41","v":""},{"$f":"'Flight schedule Even 10-18'!E41","v":""},{"$f":"'Flight schedule Even 10-18'!G41","v":""},""]
[{"$f":"'Flight schedule Even 10-18'!A40","v":"Hole "},{"$f":"'Flight schedule Even 10-18'!B40","v":"Flight 10"},{"$f":"'Flight schedule Even 10-18'!B42","v":""},{"$f":"'Flight schedule Even 10-18'!E42","v":""},{"$f":"'Flight schedule Even 10-18'!G42","v":""},""]

{"sheet":"Lookup Handicaps Red","index":6,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4],[0,6,0,7],[0,9,0,10]]}
["Red Men 1-9",null,null,"Red Women 1-9",null,null,"Rood Men 10-18",null,null,"Red Women 10-18"]
["Exact HCP","PL HCP",null,"Exact HCP","PL HCP",null,"Exact HCP","PL HCP",null,"Exact HCP","PL HCP"]
[11.5,4,null,11.5,7,null,11.5,4,null,11.5,8]
[12,5,null,11.6,8,null,11.9,5,null,12.5,9]
[14,6,null,13.2,9,null,13.9,6,null,14.1,10]
[15.9,7,null,14.8,10,null,15.9,7,null,15.7,11]
[17.8,8,null,16.5,11,null,17.899999999999999,8,null,17.3,12]
[19.8,9,null,18.100000000000001,12,null,19.899999999999999,9,null,18.899999999999999,13]
[21.7,10,null,19.7,13,null,21.9,10,null,20.5,14]
[23.6,11,null,21.3,14,null,24,11,null,22.1,15]
[25.5,12,null,23,15,null,26,12,null,23.7,16]
[27.5,13,null,24.6,16,null,28,13,null,25.3,17]
[29.4,14,null,26.2,17,null,30,14,null,26.9,18]
[31.3,15,null,27.9,18,null,32,15,null,28.5,19]
[33.299999999999997,16,null,29.5,19,null,34.1,16,null,30.1,20]
[35.200000000000003,17,null,31.1,20,null,37,17,null,31.7,21]
[37,18,null,32.700000000000003,21,null,38,18,null,33.299999999999997,22]
[39,19,null,34.4,22,null,40,19,null,34.9,23]
[41,20,null,36,23,null,42,20,null,37,24]
[43,21,null,38,24,null,44,21,null,39,25]
[45,22,null,40,25,null,46,22,null,41,26]
[47,23,null,42,26,null,48,23,null,43,27]
[49,24,null,44,27,null,50,24,null,45,28]
[51,25,null,46,28,null,52,25,null,47,29]
[53,26,null,48,29,null,54,26,null,49,30]
[null,null,null,50,30,null,null,null,null,51,31]
[null,null,null,52,31,null,null,null,null,53,32]
[null,null,null,54,32]

{"sheet":"sample sheet - printable list","index":7,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Shotgun Game [date]"]
["ID","Full Name","MF","Handicap","Shotgun [date]","PLHCP 10-18",null,"ID","Full Name","MF","Handicap","Shotgun [date]","PLHCP 10-18"]
[35,"Mary Martinez","F",14,"yes",9,null,16,"Justin Evans","M",13.4,"yes",5]
[40,"Diana Niemeyer","F",20.3,"yes",13,null,49,"Helen Wood","M",17.899999999999999,"yes",8]
[14,"Kathy Dodge","F",23.9,"yes",16,null,48,"Nick Schultz","M",18.399999999999999,"yes",8]
[19,"Deborah Fitch","F",24.6,"yes",16,null,36,"Andrew Matthews","M",19,"yes",8]
[8,"Sheri Chandler","F",24.7,"yes",16,null,5,"Mike Burrows","M",20.399999999999999,"yes",9]
[3,"Ellen Applegate","F",27.9,"yes",18,null,39,"Mike Murray","M",21.4,"yes",9]
[15,"Angela Douglass","F",28.5,"yes",19,null,2,"David Anderson","M",21.5,"yes",9]
[18,"Heather Fisher","F",28.5,"yes",19,null,50,"Dave Young","M",24,"yes",11]
[29,"Julie Ipsen","F",31.8,"yes",21,null,22,"Daniel Gallagher","M",26.4,"yes",12]
[33,"Molly King","F",36.4,"yes",23,null,21,"Chris Ford","M",26.5,"yes",12]
[25,"Beth Ann Goldberg","F",43,"yes",27,null,11,"Brett Daniel","M",26.7,"yes",12]
[16,"Justin Evans","M",13.4,"yes",5,null,42,"Pat Palmer","M",36,"yes",16]
[49,"Helen Wood","M",17.899999999999999,"yes",8,null,45,"Andy Riggs","M",36,"yes",16]
[48,"Nick Schultz","M",18.399999999999999,"yes",8,null,46,"Kevin Rodriguez","M",36,"yes",16]
[36,"Andrew Matthews","M",19,"yes",8]
[5,"Mike Burrows","M",20.399999999999999,"yes",9]
[39,"Mike Murray","M",21.4,"yes",9]
[2,"David Anderson","M",21.5,"yes",9]
[50,"Dave Young","M",24,"yes",11]
[22,"Dorothy Gallagher","M",26.4,"yes",12]
[21,"Chris Ford","M",26.5,"yes",12]
[11,"Brett Daniel","M",26.7,"yes",12]
[42,"Pat Palmer","M",36,"yes",16]
[45,"Andy Riggs","M",36,"yes",16]
[46,"Kevin Rodriguez","M",36,"yes",16]