{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Masterlist 2015","Flight schema oneven 1-9","Etiketten 1-9","Flight schema Even 10-18","Etiketten Even 10-18","Lookup Handicaps Rood","voobeeld - printbare lijst"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":25,"comments":3,"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","Voornaam","Achternaam","Volledige naam","MV","Handicap","Shotgun [datum]","PLHCP 1-9","PLHCP 10-18"]
[1,"Adorp","Freek",{"$f":"CONCATENATE(C2, \" \", B2)","v":"Freek Adorp"},"M",null,"ja",{"$f":"IFERROR(IF($E2=\"M\",VLOOKUP($F2,HRoodPLHCP,2),VLOOKUP($F2,DRoodPLHCP,2)),\"\")","v":""},{"$f":"IFERROR(IF($E2=\"M\",VLOOKUP($F2,H10RoodPLHCP,2),VLOOKUP($F2,D10RoodPLHCP,2)),\"\")","v":""}]
[2,"Aikema","Dirk",{"$f":"CONCATENATE(C3, \" \", B3)","v":"Dirk Aikema"},"M",null,null,{"$f":"IFERROR(IF($E3=\"M\",VLOOKUP($F3,HRoodPLHCP,2),VLOOKUP($F3,DRoodPLHCP,2)),\"\")","v":""},{"$f":"IFERROR(IF($E3=\"M\",VLOOKUP($F3,H10RoodPLHCP,2),VLOOKUP($F3,D10RoodPLHCP,2)),\"\")","v":""}]
[3,"Arends","Ellen",{"$f":"CONCATENATE(C4, \" \", B4)","v":"Ellen Arends"},"V",27.9,"ja",{"$f":"IFERROR(IF($E4=\"M\",VLOOKUP($F4,HRoodPLHCP,2),VLOOKUP($F4,DRoodPLHCP,2)),\"\")","v":18},{"$f":"IFERROR(IF($E4=\"M\",VLOOKUP($F4,H10RoodPLHCP,2),VLOOKUP($F4,D10RoodPLHCP,2)),\"\")","v":18}]
[4,"Berg, van der","Karel",{"$f":"CONCATENATE(C5, \" \", B5)","v":"Karel Berg, van der"},"M",22.3,"ja",{"$f":"IFERROR(IF($E5=\"M\",VLOOKUP($F5,HRoodPLHCP,2),VLOOKUP($F5,DRoodPLHCP,2)),\"\")","v":10},{"$f":"IFERROR(IF($E5=\"M\",VLOOKUP($F5,H10RoodPLHCP,2),VLOOKUP($F5,D10RoodPLHCP,2)),\"\")","v":10}]
[5,"Bruin, de","Michael",{"$f":"CONCATENATE(C6, \" \", B6)","v":"Michael Bruin, de"},"M",20.399999999999999,"ja",{"$f":"IFERROR(IF($E6=\"M\",VLOOKUP($F6,HRoodPLHCP,2),VLOOKUP($F6,DRoodPLHCP,2)),\"\")","v":9},{"$f":"IFERROR(IF($E6=\"M\",VLOOKUP($F6,H10RoodPLHCP,2),VLOOKUP($F6,D10RoodPLHCP,2)),\"\")","v":9}]
[6,"Clevering","Jan",{"$f":"CONCATENATE(C7, \" \", B7)","v":"Jan Clevering"},"M",28.1,null,{"$f":"IFERROR(IF($E7=\"M\",VLOOKUP($F7,HRoodPLHCP,2),VLOOKUP($F7,DRoodPLHCP,2)),\"\")","v":13},{"$f":"IFERROR(IF($E7=\"M\",VLOOKUP($F7,H10RoodPLHCP,2),VLOOKUP($F7,D10RoodPLHCP,2)),\"\")","v":13}]
[7,"Claassen","Annie",{"$f":"CONCATENATE(C8, \" \", B8)","v":"Annie Claassen"},"V",24,"ja",{"$f":"IFERROR(IF($E8=\"M\",VLOOKUP($F8,HRoodPLHCP,2),VLOOKUP($F8,DRoodPLHCP,2)),\"\")","v":15},{"$f":"IFERROR(IF($E8=\"M\",VLOOKUP($F8,H10RoodPLHCP,2),VLOOKUP($F8,D10RoodPLHCP,2)),\"\")","v":16}]
[8,"Cohen","Sandra",{"$f":"CONCATENATE(C9, \" \", B9)","v":"Sandra Cohen"},"V",24.7,"ja",{"$f":"IFERROR(IF($E9=\"M\",VLOOKUP($F9,HRoodPLHCP,2),VLOOKUP($F9,DRoodPLHCP,2)),\"\")","v":16},{"$f":"IFERROR(IF($E9=\"M\",VLOOKUP($F9,H10RoodPLHCP,2),VLOOKUP($F9,D10RoodPLHCP,2)),\"\")","v":16}]
[9,"Davids","Mark",{"$f":"CONCATENATE(C10, \" \", B10)","v":"Mark Davids"},"M",24.5,null,{"$f":"IFERROR(IF($E10=\"M\",VLOOKUP($F10,HRoodPLHCP,2),VLOOKUP($F10,DRoodPLHCP,2)),\"\")","v":11},{"$f":"IFERROR(IF($E10=\"M\",VLOOKUP($F10,H10RoodPLHCP,2),VLOOKUP($F10,D10RoodPLHCP,2)),\"\")","v":11}]
[10,"Dekker","Janet",{"$f":"CONCATENATE(C11, \" \", B11)","v":"Janet Dekker"},"V",24.9,null,{"$f":"IFERROR(IF($E11=\"M\",VLOOKUP($F11,HRoodPLHCP,2),VLOOKUP($F11,DRoodPLHCP,2)),\"\")","v":16},{"$f":"IFERROR(IF($E11=\"M\",VLOOKUP($F11,H10RoodPLHCP,2),VLOOKUP($F11,D10RoodPLHCP,2)),\"\")","v":16}]
[11,"Doornbos","Bart",{"$f":"CONCATENATE(C12, \" \", B12)","v":"Bart Doornbos"},"M",26.7,"ja",{"$f":"IFERROR(IF($E12=\"M\",VLOOKUP($F12,HRoodPLHCP,2),VLOOKUP($F12,DRoodPLHCP,2)),\"\")","v":12},{"$f":"IFERROR(IF($E12=\"M\",VLOOKUP($F12,H10RoodPLHCP,2),VLOOKUP($F12,D10RoodPLHCP,2)),\"\")","v":12}]
[12,"Drenth","Steven",{"$f":"CONCATENATE(C13, \" \", B13)","v":"Steven Drenth"},"M",28.2,null,{"$f":"IFERROR(IF($E13=\"M\",VLOOKUP($F13,HRoodPLHCP,2),VLOOKUP($F13,DRoodPLHCP,2)),\"\")","v":13},{"$f":"IFERROR(IF($E13=\"M\",VLOOKUP($F13,H10RoodPLHCP,2),VLOOKUP($F13,D10RoodPLHCP,2)),\"\")","v":13}]
[13,"Dijkema","Marie",{"$f":"CONCATENATE(C14, \" \", B14)","v":"Marie Dijkema"},"V",23.7,null,{"$f":"IFERROR(IF($E14=\"M\",VLOOKUP($F14,HRoodPLHCP,2),VLOOKUP($F14,DRoodPLHCP,2)),\"\")","v":15},{"$f":"IFERROR(IF($E14=\"M\",VLOOKUP($F14,H10RoodPLHCP,2),VLOOKUP($F14,D10RoodPLHCP,2)),\"\")","v":16}]
[14,"Dijkstra","Kim",{"$f":"CONCATENATE(C15, \" \", B15)","v":"Kim Dijkstra"},"V",23.9,"ja",{"$f":"IFERROR(IF($E15=\"M\",VLOOKUP($F15,HRoodPLHCP,2),VLOOKUP($F15,DRoodPLHCP,2)),\"\")","v":15},{"$f":"IFERROR(IF($E15=\"M\",VLOOKUP($F15,H10RoodPLHCP,2),VLOOKUP($F15,D10RoodPLHCP,2)),\"\")","v":16}]
[15,"Edinga","Angela",{"$f":"CONCATENATE(C16, \" \", B16)","v":"Angela Edinga"},"V",28.5,"ja",{"$f":"IFERROR(IF($E16=\"M\",VLOOKUP($F16,HRoodPLHCP,2),VLOOKUP($F16,DRoodPLHCP,2)),\"\")","v":18},{"$f":"IFERROR(IF($E16=\"M\",VLOOKUP($F16,H10RoodPLHCP,2),VLOOKUP($F16,D10RoodPLHCP,2)),\"\")","v":19}]
[16,"Eggens","Julius",{"$f":"CONCATENATE(C17, \" \", B17)","v":"Julius Eggens"},"M",13.4,"ja",{"$f":"IFERROR(IF($E17=\"M\",VLOOKUP($F17,HRoodPLHCP,2),VLOOKUP($F17,DRoodPLHCP,2)),\"\")","v":5},{"$f":"IFERROR(IF($E17=\"M\",VLOOKUP($F17,H10RoodPLHCP,2),VLOOKUP($F17,D10RoodPLHCP,2)),\"\")","v":5}]
[17,"Feiken","Martin",{"$f":"CONCATENATE(C18, \" \", B18)","v":"Martin Feiken"},"M",23.7,null,{"$f":"IFERROR(IF($E18=\"M\",VLOOKUP($F18,HRoodPLHCP,2),VLOOKUP($F18,DRoodPLHCP,2)),\"\")","v":11},{"$f":"IFERROR(IF($E18=\"M\",VLOOKUP($F18,H10RoodPLHCP,2),VLOOKUP($F18,D10RoodPLHCP,2)),\"\")","v":10}]
[18,"Fischer","Sofie",{"$f":"CONCATENATE(C19, \" \", B19)","v":"Sofie Fischer"},"V",28.5,"ja",{"$f":"IFERROR(IF($E19=\"M\",VLOOKUP($F19,HRoodPLHCP,2),VLOOKUP($F19,DRoodPLHCP,2)),\"\")","v":18},{"$f":"IFERROR(IF($E19=\"M\",VLOOKUP($F19,H10RoodPLHCP,2),VLOOKUP($F19,D10RoodPLHCP,2)),\"\")","v":19}]
[19,"Feikema","Emmy",{"$f":"CONCATENATE(C20, \" \", B20)","v":"Emmy Feikema"},"V",24.6,"ja",{"$f":"IFERROR(IF($E20=\"M\",VLOOKUP($F20,HRoodPLHCP,2),VLOOKUP($F20,DRoodPLHCP,2)),\"\")","v":16},{"$f":"IFERROR(IF($E20=\"M\",VLOOKUP($F20,H10RoodPLHCP,2),VLOOKUP($F20,D10RoodPLHCP,2)),\"\")","v":16}]
[20,"Folkerts","Rob",{"$f":"CONCATENATE(C21, \" \", B21)","v":"Rob Folkerts"},"M",20.2,null,{"$f":"IFERROR(IF($E21=\"M\",VLOOKUP($F21,HRoodPLHCP,2),VLOOKUP($F21,DRoodPLHCP,2)),\"\")","v":9},{"$f":"IFERROR(IF($E21=\"M\",VLOOKUP($F21,H10RoodPLHCP,2),VLOOKUP($F21,D10RoodPLHCP,2)),\"\")","v":9}]
[21,"Franken","Chris",{"$f":"CONCATENATE(C22, \" \", B22)","v":"Chris Franken"},"M",26.5,"ja",{"$f":"IFERROR(IF($E22=\"M\",VLOOKUP($F22,HRoodPLHCP,2),VLOOKUP($F22,DRoodPLHCP,2)),\"\")","v":12},{"$f":"IFERROR(IF($E22=\"M\",VLOOKUP($F22,H10RoodPLHCP,2),VLOOKUP($F22,D10RoodPLHCP,2)),\"\")","v":12}]
[22,"Geertjes","Daan",{"$f":"CONCATENATE(C23, \" \", B23)","v":"Daan Geertjes"},"M",26.4,"ja",{"$f":"IFERROR(IF($E23=\"M\",VLOOKUP($F23,HRoodPLHCP,2),VLOOKUP($F23,DRoodPLHCP,2)),\"\")","v":12},{"$f":"IFERROR(IF($E23=\"M\",VLOOKUP($F23,H10RoodPLHCP,2),VLOOKUP($F23,D10RoodPLHCP,2)),\"\")","v":12}]
[23,"Grave","Ab",{"$f":"CONCATENATE(C24, \" \", B24)","v":"Ab Grave"},"M",23.5,null,{"$f":"IFERROR(IF($E24=\"M\",VLOOKUP($F24,HRoodPLHCP,2),VLOOKUP($F24,DRoodPLHCP,2)),\"\")","v":10},{"$f":"IFERROR(IF($E24=\"M\",VLOOKUP($F24,H10RoodPLHCP,2),VLOOKUP($F24,D10RoodPLHCP,2)),\"\")","v":10}]
[24,"Groen","Jan",{"$f":"CONCATENATE(C25, \" \", B25)","v":"Jan Groen"},"M",22.9,null,{"$f":"IFERROR(IF($E25=\"M\",VLOOKUP($F25,HRoodPLHCP,2),VLOOKUP($F25,DRoodPLHCP,2)),\"\")","v":10},{"$f":"IFERROR(IF($E25=\"M\",VLOOKUP($F25,H10RoodPLHCP,2),VLOOKUP($F25,D10RoodPLHCP,2)),\"\")","v":10}]
[25,"Groot, de","Anneke",{"$f":"CONCATENATE(C26, \" \", B26)","v":"Anneke Groot, de"},"V",43,"ja",{"$f":"IFERROR(IF($E26=\"M\",VLOOKUP($F26,HRoodPLHCP,2),VLOOKUP($F26,DRoodPLHCP,2)),\"\")","v":26},{"$f":"IFERROR(IF($E26=\"M\",VLOOKUP($F26,H10RoodPLHCP,2),VLOOKUP($F26,D10RoodPLHCP,2)),\"\")","v":27}]
[26,"Haas","Marieke",{"$f":"CONCATENATE(C27, \" \", B27)","v":"Marieke Haas"},"V",29.6,null,{"$f":"IFERROR(IF($E27=\"M\",VLOOKUP($F27,HRoodPLHCP,2),VLOOKUP($F27,DRoodPLHCP,2)),\"\")","v":19},{"$f":"IFERROR(IF($E27=\"M\",VLOOKUP($F27,H10RoodPLHCP,2),VLOOKUP($F27,D10RoodPLHCP,2)),\"\")","v":19}]
[27,"Hesseling","Alex",{"$f":"CONCATENATE(C28, \" \", B28)","v":"Alex Hesseling"},"M",25,null,{"$f":"IFERROR(IF($E28=\"M\",VLOOKUP($F28,HRoodPLHCP,2),VLOOKUP($F28,DRoodPLHCP,2)),\"\")","v":11},{"$f":"IFERROR(IF($E28=\"M\",VLOOKUP($F28,H10RoodPLHCP,2),VLOOKUP($F28,D10RoodPLHCP,2)),\"\")","v":11}]
[28,"Hilbrands","Chris",{"$f":"CONCATENATE(C29, \" \", B29)","v":"Chris Hilbrands"},"M",32,null,{"$f":"IFERROR(IF($E29=\"M\",VLOOKUP($F29,HRoodPLHCP,2),VLOOKUP($F29,DRoodPLHCP,2)),\"\")","v":15},{"$f":"IFERROR(IF($E29=\"M\",VLOOKUP($F29,H10RoodPLHCP,2),VLOOKUP($F29,D10RoodPLHCP,2)),\"\")","v":15}]
[29,"Idema","Julia",{"$f":"CONCATENATE(C30, \" \", B30)","v":"Julia Idema"},"V",31.8,"ja",{"$f":"IFERROR(IF($E30=\"M\",VLOOKUP($F30,HRoodPLHCP,2),VLOOKUP($F30,DRoodPLHCP,2)),\"\")","v":20},{"$f":"IFERROR(IF($E30=\"M\",VLOOKUP($F30,H10RoodPLHCP,2),VLOOKUP($F30,D10RoodPLHCP,2)),\"\")","v":21}]
[30,"Jansen","Lea",{"$f":"CONCATENATE(C31, \" \", B31)","v":"Lea Jansen"},"V",36,null,{"$f":"IFERROR(IF($E31=\"M\",VLOOKUP($F31,HRoodPLHCP,2),VLOOKUP($F31,DRoodPLHCP,2)),\"\")","v":23},{"$f":"IFERROR(IF($E31=\"M\",VLOOKUP($F31,H10RoodPLHCP,2),VLOOKUP($F31,D10RoodPLHCP,2)),\"\")","v":23}]
[31,"Janssen","Rachel",{"$f":"CONCATENATE(C32, \" \", B32)","v":"Rachel Janssen"},"V",28.8,null,{"$f":"IFERROR(IF($E32=\"M\",VLOOKUP($F32,HRoodPLHCP,2),VLOOKUP($F32,DRoodPLHCP,2)),\"\")","v":18},{"$f":"IFERROR(IF($E32=\"M\",VLOOKUP($F32,H10RoodPLHCP,2),VLOOKUP($F32,D10RoodPLHCP,2)),\"\")","v":19}]
[32,"Jensing","Ken",{"$f":"CONCATENATE(C33, \" \", B33)","v":"Ken Jensing"},"M",36,null,{"$f":"IFERROR(IF($E33=\"M\",VLOOKUP($F33,HRoodPLHCP,2),VLOOKUP($F33,DRoodPLHCP,2)),\"\")","v":17},{"$f":"IFERROR(IF($E33=\"M\",VLOOKUP($F33,H10RoodPLHCP,2),VLOOKUP($F33,D10RoodPLHCP,2)),\"\")","v":16}]
[33,"Koning","Maaike",{"$f":"CONCATENATE(C34, \" \", B34)","v":"Maaike Koning"},"V",36.4,"ja",{"$f":"IFERROR(IF($E34=\"M\",VLOOKUP($F34,HRoodPLHCP,2),VLOOKUP($F34,DRoodPLHCP,2)),\"\")","v":23},{"$f":"IFERROR(IF($E34=\"M\",VLOOKUP($F34,H10RoodPLHCP,2),VLOOKUP($F34,D10RoodPLHCP,2)),\"\")","v":23}]
[34,"Lamein","Anton",{"$f":"CONCATENATE(C35, \" \", B35)","v":"Anton Lamein"},"M",29.1,null,{"$f":"IFERROR(IF($E35=\"M\",VLOOKUP($F35,HRoodPLHCP,2),VLOOKUP($F35,DRoodPLHCP,2)),\"\")","v":13},{"$f":"IFERROR(IF($E35=\"M\",VLOOKUP($F35,H10RoodPLHCP,2),VLOOKUP($F35,D10RoodPLHCP,2)),\"\")","v":13}]
[35,"Meijer","Wies",{"$f":"CONCATENATE(C36, \" \", B36)","v":"Wies Meijer"},"V",14,"ja",{"$f":"IFERROR(IF($E36=\"M\",VLOOKUP($F36,HRoodPLHCP,2),VLOOKUP($F36,DRoodPLHCP,2)),\"\")","v":9},{"$f":"IFERROR(IF($E36=\"M\",VLOOKUP($F36,H10RoodPLHCP,2),VLOOKUP($F36,D10RoodPLHCP,2)),\"\")","v":9}]
[36,"Middel","Arie",{"$f":"CONCATENATE(C37, \" \", B37)","v":"Arie Middel"},"M",19,"ja",{"$f":"IFERROR(IF($E37=\"M\",VLOOKUP($F37,HRoodPLHCP,2),VLOOKUP($F37,DRoodPLHCP,2)),\"\")","v":8},{"$f":"IFERROR(IF($E37=\"M\",VLOOKUP($F37,H10RoodPLHCP,2),VLOOKUP($F37,D10RoodPLHCP,2)),\"\")","v":8}]
[37,"Mollema","Laura",{"$f":"CONCATENATE(C38, \" \", B38)","v":"Laura Mollema"},"V",18.5,null,{"$f":"IFERROR(IF($E38=\"M\",VLOOKUP($F38,HRoodPLHCP,2),VLOOKUP($F38,DRoodPLHCP,2)),\"\")","v":12},{"$f":"IFERROR(IF($E38=\"M\",VLOOKUP($F38,H10RoodPLHCP,2),VLOOKUP($F38,D10RoodPLHCP,2)),\"\")","v":12}]
[38,"Mulder","Piet",{"$f":"CONCATENATE(C39, \" \", B39)","v":"Piet Mulder"},"M",25,null,{"$f":"IFERROR(IF($E39=\"M\",VLOOKUP($F39,HRoodPLHCP,2),VLOOKUP($F39,DRoodPLHCP,2)),\"\")","v":11},{"$f":"IFERROR(IF($E39=\"M\",VLOOKUP($F39,H10RoodPLHCP,2),VLOOKUP($F39,D10RoodPLHCP,2)),\"\")","v":11}]
[39,"Nieborg","Michiel",{"$f":"CONCATENATE(C40, \" \", B40)","v":"Michiel Nieborg"},"M",21.4,"ja",{"$f":"IFERROR(IF($E40=\"M\",VLOOKUP($F40,HRoodPLHCP,2),VLOOKUP($F40,DRoodPLHCP,2)),\"\")","v":9},{"$f":"IFERROR(IF($E40=\"M\",VLOOKUP($F40,H10RoodPLHCP,2),VLOOKUP($F40,D10RoodPLHCP,2)),\"\")","v":9}]
[40,"Niemeyer","Diane",{"$f":"CONCATENATE(C41, \" \", B41)","v":"Diane Niemeyer"},"V",20.3,"ja",{"$f":"IFERROR(IF($E41=\"M\",VLOOKUP($F41,HRoodPLHCP,2),VLOOKUP($F41,DRoodPLHCP,2)),\"\")","v":13},{"$f":"IFERROR(IF($E41=\"M\",VLOOKUP($F41,H10RoodPLHCP,2),VLOOKUP($F41,D10RoodPLHCP,2)),\"\")","v":13}]
[41,"Oosterhof","Floor",{"$f":"CONCATENATE(C42, \" \", B42)","v":"Floor Oosterhof"},"V",22.5,null,{"$f":"IFERROR(IF($E42=\"M\",VLOOKUP($F42,HRoodPLHCP,2),VLOOKUP($F42,DRoodPLHCP,2)),\"\")","v":14},{"$f":"IFERROR(IF($E42=\"M\",VLOOKUP($F42,H10RoodPLHCP,2),VLOOKUP($F42,D10RoodPLHCP,2)),\"\")","v":15}]
[42,"Medema","Pat",{"$f":"CONCATENATE(C43, \" \", B43)","v":"Pat Medema"},"M",36,"ja",{"$f":"IFERROR(IF($E43=\"M\",VLOOKUP($F43,HRoodPLHCP,2),VLOOKUP($F43,DRoodPLHCP,2)),\"\")","v":17},{"$f":"IFERROR(IF($E43=\"M\",VLOOKUP($F43,H10RoodPLHCP,2),VLOOKUP($F43,D10RoodPLHCP,2)),\"\")","v":16}]
[43,"Menkema","Valerie",{"$f":"CONCATENATE(C44, \" \", B44)","v":"Valerie Menkema"},"V",44,null,{"$f":"IFERROR(IF($E44=\"M\",VLOOKUP($F44,HRoodPLHCP,2),VLOOKUP($F44,DRoodPLHCP,2)),\"\")","v":27},{"$f":"IFERROR(IF($E44=\"M\",VLOOKUP($F44,H10RoodPLHCP,2),VLOOKUP($F44,D10RoodPLHCP,2)),\"\")","v":27}]
[44,"Niehof","Daan",{"$f":"CONCATENATE(C45, \" \", B45)","v":"Daan Niehof"},"M",43,null,{"$f":"IFERROR(IF($E45=\"M\",VLOOKUP($F45,HRoodPLHCP,2),VLOOKUP($F45,DRoodPLHCP,2)),\"\")","v":21},{"$f":"IFERROR(IF($E45=\"M\",VLOOKUP($F45,H10RoodPLHCP,2),VLOOKUP($F45,D10RoodPLHCP,2)),\"\")","v":20}]
[45,"Prins","Bert",{"$f":"CONCATENATE(C46, \" \", B46)","v":"Bert Prins"},"M",36,"ja",{"$f":"IFERROR(IF($E46=\"M\",VLOOKUP($F46,HRoodPLHCP,2),VLOOKUP($F46,DRoodPLHCP,2)),\"\")","v":17},{"$f":"IFERROR(IF($E46=\"M\",VLOOKUP($F46,H10RoodPLHCP,2),VLOOKUP($F46,D10RoodPLHCP,2)),\"\")","v":16}]
[46,"Ridder","Kevin",{"$f":"CONCATENATE(C47, \" \", B47)","v":"Kevin Ridder"},"M",36,"ja",{"$f":"IFERROR(IF($E47=\"M\",VLOOKUP($F47,HRoodPLHCP,2),VLOOKUP($F47,DRoodPLHCP,2)),\"\")","v":17},{"$f":"IFERROR(IF($E47=\"M\",VLOOKUP($F47,H10RoodPLHCP,2),VLOOKUP($F47,D10RoodPLHCP,2)),\"\")","v":16}]
[47,"Schmidt","Tom",{"$f":"CONCATENATE(C48, \" \", B48)","v":"Tom Schmidt"},"M",27.1,null,{"$f":"IFERROR(IF($E48=\"M\",VLOOKUP($F48,HRoodPLHCP,2),VLOOKUP($F48,DRoodPLHCP,2)),\"\")","v":12},{"$f":"IFERROR(IF($E48=\"M\",VLOOKUP($F48,H10RoodPLHCP,2),VLOOKUP($F48,D10RoodPLHCP,2)),\"\")","v":12}]
[48,"Stoppels","Jasper",{"$f":"CONCATENATE(C49, \" \", B49)","v":"Jasper Stoppels"},"M",18.399999999999999,"ja",{"$f":"IFERROR(IF($E49=\"M\",VLOOKUP($F49,HRoodPLHCP,2),VLOOKUP($F49,DRoodPLHCP,2)),\"\")","v":8},{"$f":"IFERROR(IF($E49=\"M\",VLOOKUP($F49,H10RoodPLHCP,2),VLOOKUP($F49,D10RoodPLHCP,2)),\"\")","v":8}]
[49,"Visser","Thijs",{"$f":"CONCATENATE(C50, \" \", B50)","v":"Thijs Visser"},"M",17.899999999999999,"ja",{"$f":"IFERROR(IF($E50=\"M\",VLOOKUP($F50,HRoodPLHCP,2),VLOOKUP($F50,DRoodPLHCP,2)),\"\")","v":8},{"$f":"IFERROR(IF($E50=\"M\",VLOOKUP($F50,H10RoodPLHCP,2),VLOOKUP($F50,D10RoodPLHCP,2)),\"\")","v":8}]
[50,"Wieringa","Hugo",{"$f":"CONCATENATE(C51, \" \", B51)","v":"Hugo Wieringa"},"M",24,"ja",{"$f":"IFERROR(IF($E51=\"M\",VLOOKUP($F51,HRoodPLHCP,2),VLOOKUP($F51,DRoodPLHCP,2)),\"\")","v":11},{"$f":"IFERROR(IF($E51=\"M\",VLOOKUP($F51,H10RoodPLHCP,2),VLOOKUP($F51,D10RoodPLHCP,2)),\"\")","v":11}]
[null,null,null,{"$f":"CONCATENATE(C52, \" \", B52)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C53, \" \", B53)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C54, \" \", B54)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C55, \" \", B55)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C56, \" \", B56)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C57, \" \", B57)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C58, \" \", B58)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C59, \" \", B59)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C60, \" \", B60)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C61, \" \", B61)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C62, \" \", B62)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C63, \" \", B63)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C64, \" \", B64)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C65, \" \", B65)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C66, \" \", B66)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C67, \" \", B67)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C68, \" \", B68)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C69, \" \", B69)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C70, \" \", B70)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C71, \" \", B71)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C72, \" \", B72)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C73, \" \", B73)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C74, \" \", B74)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C75, \" \", B75)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C76, \" \", B76)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C77, \" \", B77)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C78, \" \", B78)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C79, \" \", B79)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C80, \" \", B80)","v":" "}]
[null,null,null,{"$f":"CONCATENATE(C81, \" \", B81)","v":" "}]

{"sheet":"Flight schema oneven 1-9","index":1,"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-20"},null,null,null,null,null,"Gebruikte termen:"]
[null,null,0.6,null,null,0.4,null,null,null,null,null,null,null,"Shotgun"]
["No 1","Speler 1","HCP1","No 2","Speler 2","HCP2","Slagen Mee","Punten",null,null,"Wedstrijd scores",null,null,"Greensome"]
["Hole 1","Flight 1",null,null,null,null,null,null,null,null,"Gewonnen",{"$f":"MAX(L5:L24)","v":0},"Rangschikking"]
[null,{"$f":"IFERROR(VLOOKUP($A5,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D5,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D5,Masterlijst,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,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D6,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D6,Masterlijst,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":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L8,$L$5:$L$14)+COUNTIF(L$5:L7,L8),\"\")","v":""}]
[7,{"$f":"IFERROR(VLOOKUP($A9,Masterlijst,4,FALSE),\"\")","v":"Annie Claassen"},{"$f":"IFERROR(VLOOKUP($A9,Masterlijst,8,FALSE),\"\")","v":15},42,{"$f":"IFERROR(VLOOKUP($D9,Masterlijst,4,FALSE),\"\")","v":"Pat Medema"},{"$f":"IFERROR(VLOOKUP($D9,Masterlijst,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":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L9,$L$5:$L$14)+COUNTIF(L$5:L8,L9),\"\")","v":""}]
[14,{"$f":"IFERROR(VLOOKUP($A10,Masterlijst,4,FALSE),\"\")","v":"Kim Dijkstra"},{"$f":"IFERROR(VLOOKUP($A10,Masterlijst,8,FALSE),\"\")","v":15},45,{"$f":"IFERROR(VLOOKUP($D10,Masterlijst,4,FALSE),\"\")","v":"Bert Prins"},{"$f":"IFERROR(VLOOKUP($D10,Masterlijst,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":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L10,$L$5:$L$14)+COUNTIF(L$5:L9,L10),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A11,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,Masterlijst,7,FALSE),\"\")","v":""},null,"Totaal",null,null,{"$f":"IF(SUM(H9:H10)<=0,\"\",SUM(H9:H10))","v":""},null,null,"Flight 7",{"$f":"H31","v":""},{"$f":"IFERROR(_xlfn.RANK.EQ(L11,$L$5:$L$14)+COUNTIF(L$5:L10,L11),\"\")","v":""}]
["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,Masterlijst,4,FALSE),\"\")","v":"Michael Bruin, de"},{"$f":"IFERROR(VLOOKUP($A13,Masterlijst,8,FALSE),\"\")","v":9},19,{"$f":"IFERROR(VLOOKUP($D13,Masterlijst,4,FALSE),\"\")","v":"Emmy Feikema"},{"$f":"IFERROR(VLOOKUP($D13,Masterlijst,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,Masterlijst,4,FALSE),\"\")","v":"Sandra Cohen"},{"$f":"IFERROR(VLOOKUP($A14,Masterlijst,8,FALSE),\"\")","v":16},46,{"$f":"IFERROR(VLOOKUP($D14,Masterlijst,4,FALSE),\"\")","v":"Kevin Ridder"},{"$f":"IFERROR(VLOOKUP($D14,Masterlijst,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,Masterlijst,4,FALSE),\"\")","v":"Arie Middel"},{"$f":"IFERROR(VLOOKUP($A17,Masterlijst,8,FALSE),\"\")","v":8},15,{"$f":"IFERROR(VLOOKUP($D17,Masterlijst,4,FALSE),\"\")","v":"Angela Edinga"},{"$f":"IFERROR(VLOOKUP($D17,Masterlijst,8,FALSE),\"\")","v":18},{"$f":"IF(D17>=1,(C17*$C$2)+(F17*$F$2),C17)","v":12}]
[48,{"$f":"IFERROR(VLOOKUP($A18,Masterlijst,4,FALSE),\"\")","v":"Jasper Stoppels"},{"$f":"IFERROR(VLOOKUP($A18,Masterlijst,8,FALSE),\"\")","v":8},3,{"$f":"IFERROR(VLOOKUP($D18,Masterlijst,4,FALSE),\"\")","v":"Ellen Arends"},{"$f":"IFERROR(VLOOKUP($D18,Masterlijst,8,FALSE),\"\")","v":18},{"$f":"IF(D18>=1,(C18*$C$2)+(F18*$F$2),C18)","v":12}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H17:H18)<=0,\"\",SUM(H17:H18))","v":""}]
["Hole 5","Flight 5"]
[11,{"$f":"IFERROR(VLOOKUP($A21,Masterlijst,4,FALSE),\"\")","v":"Bart Doornbos"},{"$f":"IFERROR(VLOOKUP($A21,Masterlijst,8,FALSE),\"\")","v":12},18,{"$f":"IFERROR(VLOOKUP($D21,Masterlijst,4,FALSE),\"\")","v":"Sofie Fischer"},{"$f":"IFERROR(VLOOKUP($D21,Masterlijst,8,FALSE),\"\")","v":18},{"$f":"IF(D21>=1,(C21*$C$2)+(F21*$F$2),C21)","v":14.399999999999999}]
[39,{"$f":"IFERROR(VLOOKUP($A22,Masterlijst,4,FALSE),\"\")","v":"Michiel Nieborg"},{"$f":"IFERROR(VLOOKUP($A22,Masterlijst,8,FALSE),\"\")","v":9},29,{"$f":"IFERROR(VLOOKUP($D22,Masterlijst,4,FALSE),\"\")","v":"Julia Idema"},{"$f":"IFERROR(VLOOKUP($D22,Masterlijst,8,FALSE),\"\")","v":20},{"$f":"IF(D22>=1,(C22*$C$2)+(F22*$F$2),C22)","v":13.399999999999999}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H21:H22)<=0,\"\",SUM(H21:H22))","v":""}]
["Hole 6","Flight 6"]
[6,{"$f":"IFERROR(VLOOKUP($A25,Masterlijst,4,FALSE),\"\")","v":"Jan Clevering"},{"$f":"IFERROR(VLOOKUP($A25,Masterlijst,8,FALSE),\"\")","v":13},33,{"$f":"IFERROR(VLOOKUP($D25,Masterlijst,4,FALSE),\"\")","v":"Maaike Koning"},{"$f":"IFERROR(VLOOKUP($D25,Masterlijst,8,FALSE),\"\")","v":23},{"$f":"IF(D25>=1,(C25*$C$2)+(F25*$F$2),C25)","v":17}]
[21,{"$f":"IFERROR(VLOOKUP($A26,Masterlijst,4,FALSE),\"\")","v":"Chris Franken"},{"$f":"IFERROR(VLOOKUP($A26,Masterlijst,8,FALSE),\"\")","v":12},25,{"$f":"IFERROR(VLOOKUP($D26,Masterlijst,4,FALSE),\"\")","v":"Anneke Groot, de"},{"$f":"IFERROR(VLOOKUP($D26,Masterlijst,8,FALSE),\"\")","v":26},{"$f":"IF(D26>=1,(C26*$C$2)+(F26*$F$2),C26)","v":17.600000000000001}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H25:H26)<=0,\"\",SUM(H25:H26))","v":""}]
["Hole 7","Flight 7"]
[50,{"$f":"IFERROR(VLOOKUP($A29,Masterlijst,4,FALSE),\"\")","v":"Hugo Wieringa"},{"$f":"IFERROR(VLOOKUP($A29,Masterlijst,8,FALSE),\"\")","v":11},22,{"$f":"IFERROR(VLOOKUP($D29,Masterlijst,4,FALSE),\"\")","v":"Daan Geertjes"},{"$f":"IFERROR(VLOOKUP($D29,Masterlijst,8,FALSE),\"\")","v":12},{"$f":"IF(D29>=1,(C29*$C$2)+(F29*$F$2),C29)","v":11.4}]
[1,{"$f":"IFERROR(VLOOKUP($A30,Masterlijst,4,FALSE),\"\")","v":"Freek Adorp"},{"$f":"IFERROR(VLOOKUP($A30,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D30,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D30,Masterlijst,8,FALSE),\"\")","v":""},{"$f":"IF(D30>=1,(C30*$C$2)+(F30*$F$2),C30)","v":""}]
[null,null,null,null,"Totaal",null,null,{"$f":"IF(SUM(H29:H30)<=0,\"\",SUM(H29:H30))","v":""}]
["Hole 8","Flight 8"]
[null,{"$f":"IFERROR(VLOOKUP($A33,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A33,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D33,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D33,Masterlijst,8,FALSE),\"\")","v":""},{"$f":"IF(D33>=1,(C33*$C$2)+(F33*$F$2),C33)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A34,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A34,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D34,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D34,Masterlijst,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,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A37,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D37,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D37,Masterlijst,8,FALSE),\"\")","v":""},{"$f":"IF(D37>=1,(C37*$C$2)+(F37*$F$2),C37)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A38,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A38,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D38,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D38,Masterlijst,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,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A41,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D41,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D41,Masterlijst,8,FALSE),\"\")","v":""},{"$f":"IF(D41>=1,(C41*$C$2)+(F41*$F$2),C41)","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($A42,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A42,Masterlijst,8,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($D42,Masterlijst,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D42,Masterlijst,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":"Etiketten 1-9","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Hole","Flight ","Speler 1","Speler 2","Strokes","Extra Slagen"]
[{"$f":"'Flight schema oneven 1-9'!A4","v":"Hole 1"},{"$f":"'Flight schema oneven 1-9'!B4","v":"Flight 1"},{"$f":"'Flight schema oneven 1-9'!B5","v":""},{"$f":"'Flight schema oneven 1-9'!E5","v":""},{"$f":"'Flight schema oneven 1-9'!G5","v":""},{"$f":"IFERROR(IF(E2<=0,\"\",ROUND(E2,0)),\"\")","v":""}]
[{"$f":"'Flight schema oneven 1-9'!A4","v":"Hole 1"},{"$f":"'Flight schema oneven 1-9'!B4","v":"Flight 1"},{"$f":"'Flight schema oneven 1-9'!B6","v":""},{"$f":"'Flight schema oneven 1-9'!E6","v":""},{"$f":"'Flight schema oneven 1-9'!G6","v":""},{"$f":"IFERROR(IF(E3<=0,\"\",ROUND(E3,0)),\"\")","v":""}]
[{"$f":"'Flight schema oneven 1-9'!A8","v":"Hole 2"},{"$f":"'Flight schema oneven 1-9'!B8","v":"Flight 2"},{"$f":"'Flight schema oneven 1-9'!B9","v":"Annie Claassen"},{"$f":"'Flight schema oneven 1-9'!E9","v":"Pat Medema"},{"$f":"'Flight schema oneven 1-9'!G9","v":15.8},16]
[{"$f":"'Flight schema oneven 1-9'!A8","v":"Hole 2"},{"$f":"'Flight schema oneven 1-9'!B8","v":"Flight 2"},{"$f":"'Flight schema oneven 1-9'!B10","v":"Kim Dijkstra"},{"$f":"'Flight schema oneven 1-9'!E10","v":"Bert Prins"},{"$f":"'Flight schema oneven 1-9'!G10","v":15.8},16]
[{"$f":"'Flight schema oneven 1-9'!A12","v":"Hole 3"},{"$f":"'Flight schema oneven 1-9'!B12","v":"Flight 3"},{"$f":"'Flight schema oneven 1-9'!B13","v":"Michael Bruin, de"},{"$f":"'Flight schema oneven 1-9'!E13","v":"Emmy Feikema"},{"$f":"'Flight schema oneven 1-9'!G13","v":11.8},12]
[{"$f":"'Flight schema oneven 1-9'!A12","v":"Hole 3"},{"$f":"'Flight schema oneven 1-9'!B12","v":"Flight 3"},{"$f":"'Flight schema oneven 1-9'!B14","v":"Sandra Cohen"},{"$f":"'Flight schema oneven 1-9'!E14","v":"Kevin Ridder"},{"$f":"'Flight schema oneven 1-9'!G14","v":16.399999999999999},16]
[{"$f":"'Flight schema oneven 1-9'!A16","v":"Hole 4"},{"$f":"'Flight schema oneven 1-9'!B16","v":"Flight 4"},{"$f":"'Flight schema oneven 1-9'!B17","v":"Arie Middel"},{"$f":"'Flight schema oneven 1-9'!E17","v":"Angela Edinga"},{"$f":"'Flight schema oneven 1-9'!G17","v":12},12]
[{"$f":"'Flight schema oneven 1-9'!A16","v":"Hole 4"},{"$f":"'Flight schema oneven 1-9'!B16","v":"Flight 4"},{"$f":"'Flight schema oneven 1-9'!B18","v":"Jasper Stoppels"},{"$f":"'Flight schema oneven 1-9'!E18","v":"Ellen Arends"},{"$f":"'Flight schema oneven 1-9'!G18","v":12},12]
[{"$f":"'Flight schema oneven 1-9'!A20","v":"Hole 5"},{"$f":"'Flight schema oneven 1-9'!B20","v":"Flight 5"},{"$f":"'Flight schema oneven 1-9'!B21","v":"Bart Doornbos"},{"$f":"'Flight schema oneven 1-9'!E21","v":"Sofie Fischer"},{"$f":"'Flight schema oneven 1-9'!G21","v":14.399999999999999},14]
[{"$f":"'Flight schema oneven 1-9'!A20","v":"Hole 5"},{"$f":"'Flight schema oneven 1-9'!B20","v":"Flight 5"},{"$f":"'Flight schema oneven 1-9'!B22","v":"Michiel Nieborg"},{"$f":"'Flight schema oneven 1-9'!E22","v":"Julia Idema"},{"$f":"'Flight schema oneven 1-9'!G22","v":13.399999999999999},13]
[{"$f":"'Flight schema oneven 1-9'!A24","v":"Hole 6"},{"$f":"'Flight schema oneven 1-9'!B24","v":"Flight 6"},{"$f":"'Flight schema oneven 1-9'!B25","v":"Jan Clevering"},{"$f":"'Flight schema oneven 1-9'!E25","v":"Maaike Koning"},{"$f":"'Flight schema oneven 1-9'!F25","v":23},23]
[{"$f":"'Flight schema oneven 1-9'!A24","v":"Hole 6"},{"$f":"'Flight schema oneven 1-9'!B24","v":"Flight 6"},{"$f":"'Flight schema oneven 1-9'!B26","v":"Chris Franken"},{"$f":"'Flight schema oneven 1-9'!E26","v":"Anneke Groot, de"},{"$f":"'Flight schema oneven 1-9'!G26","v":17.600000000000001},18]
[{"$f":"'Flight schema oneven 1-9'!A28","v":"Hole 7"},{"$f":"'Flight schema oneven 1-9'!B28","v":"Flight 7"},{"$f":"'Flight schema oneven 1-9'!B29","v":"Hugo Wieringa"},{"$f":"'Flight schema oneven 1-9'!E29","v":"Daan Geertjes"},{"$f":"'Flight schema oneven 1-9'!G29","v":11.4},11]
[{"$f":"'Flight schema oneven 1-9'!A28","v":"Hole 7"},{"$f":"'Flight schema oneven 1-9'!B28","v":"Flight 7"},{"$f":"'Flight schema oneven 1-9'!B30","v":"Freek Adorp"},{"$f":"'Flight schema oneven 1-9'!E30","v":""},{"$f":"'Flight schema oneven 1-9'!G30","v":""},""]
[{"$f":"'Flight schema oneven 1-9'!A32","v":"Hole 8"},{"$f":"'Flight schema oneven 1-9'!B32","v":"Flight 8"},{"$f":"'Flight schema oneven 1-9'!B33","v":""},{"$f":"'Flight schema oneven 1-9'!E33","v":""},{"$f":"'Flight schema oneven 1-9'!G33","v":""},""]
[{"$f":"'Flight schema oneven 1-9'!A32","v":"Hole 8"},{"$f":"'Flight schema oneven 1-9'!B32","v":"Flight 8"},{"$f":"'Flight schema oneven 1-9'!B34","v":""},{"$f":"'Flight schema oneven 1-9'!E34","v":""},{"$f":"'Flight schema oneven 1-9'!G34","v":""},""]
[{"$f":"'Flight schema oneven 1-9'!A36","v":"Hole 9"},{"$f":"'Flight schema oneven 1-9'!B36","v":"Flight 9"},{"$f":"'Flight schema oneven 1-9'!B37","v":""},{"$f":"'Flight schema oneven 1-9'!E37","v":""},{"$f":"'Flight schema oneven 1-9'!G37","v":""},""]
[{"$f":"'Flight schema oneven 1-9'!A36","v":"Hole 9"},{"$f":"'Flight schema oneven 1-9'!B36","v":"Flight 9"},{"$f":"'Flight schema oneven 1-9'!B38","v":""},{"$f":"'Flight schema oneven 1-9'!E38","v":""},{"$f":"'Flight schema oneven 1-9'!G38","v":""},""]
[{"$f":"'Flight schema oneven 1-9'!A40","v":"Hole "},{"$f":"'Flight schema oneven 1-9'!B40","v":"Flight 10"},{"$f":"'Flight schema oneven 1-9'!B41","v":""},{"$f":"'Flight schema oneven 1-9'!E41","v":""},{"$f":"'Flight schema oneven 1-9'!G41","v":""},""]
[{"$f":"'Flight schema oneven 1-9'!A40","v":"Hole "},{"$f":"'Flight schema oneven 1-9'!B40","v":"Flight 10"},{"$f":"'Flight schema oneven 1-9'!B42","v":""},{"$f":"'Flight schema oneven 1-9'!E42","v":""},{"$f":"'Flight schema oneven 1-9'!G42","v":""},""]

{"sheet":"Flight schema Even 10-18","index":3,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,10,2,11]]}
["FlightIndeling Shotgun Greensome - Holes 10-18",null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-04-20"},null,null,null,null,null,"Gebruikte begrippen:"]
[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":"Julius Eggens"},{"$f":"IFERROR(VLOOKUP($A5,Masterlist,8,FALSE),\"\")","v":5},35,{"$f":"IFERROR(VLOOKUP($D5,Masterlist,4,FALSE),\"\")","v":"Wies Meijer"},{"$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":"Diane Niemeyer"},{"$f":"IFERROR(VLOOKUP($A6,Masterlist,8,FALSE),\"\")","v":13},49,{"$f":"IFERROR(VLOOKUP($D6,Masterlist,4,FALSE),\"\")","v":"Thijs Visser"},{"$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":"Jasper Stoppels"},{"$f":"IFERROR(VLOOKUP($A9,Masterlist,8,FALSE),\"\")","v":8},15,{"$f":"IFERROR(VLOOKUP($D9,Masterlist,4,FALSE),\"\")","v":"Angela Edinga"},{"$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":"Arie Middel"},{"$f":"IFERROR(VLOOKUP($A10,Masterlist,8,FALSE),\"\")","v":8},19,{"$f":"IFERROR(VLOOKUP($D10,Masterlist,4,FALSE),\"\")","v":"Emmy Feikema"},{"$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":"Michael Bruin, de"},{"$f":"IFERROR(VLOOKUP($A13,Masterlist,8,FALSE),\"\")","v":9},8,{"$f":"IFERROR(VLOOKUP($D13,Masterlist,4,FALSE),\"\")","v":"Sandra Cohen"},{"$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":"Michiel Nieborg"},{"$f":"IFERROR(VLOOKUP($A14,Masterlist,8,FALSE),\"\")","v":9},3,{"$f":"IFERROR(VLOOKUP($D14,Masterlist,4,FALSE),\"\")","v":"Ellen Arends"},{"$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":"Dirk Aikema"},{"$f":"IFERROR(VLOOKUP($A17,Masterlist,8,FALSE),\"\")","v":""},15,{"$f":"IFERROR(VLOOKUP($D17,Masterlist,4,FALSE),\"\")","v":"Angela Edinga"},{"$f":"IFERROR(VLOOKUP($D17,Masterlist,8,FALSE),\"\")","v":18},17,20]
[50,{"$f":"IFERROR(VLOOKUP($A18,Masterlist,4,FALSE),\"\")","v":"Hugo Wieringa"},{"$f":"IFERROR(VLOOKUP($A18,Masterlist,8,FALSE),\"\")","v":11},18,{"$f":"IFERROR(VLOOKUP($D18,Masterlist,4,FALSE),\"\")","v":"Sofie Fischer"},{"$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":"Daan Geertjes"},{"$f":"IFERROR(VLOOKUP($A21,Masterlist,8,FALSE),\"\")","v":12},29,{"$f":"IFERROR(VLOOKUP($D21,Masterlist,4,FALSE),\"\")","v":"Julia Idema"},{"$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 Franken"},{"$f":"IFERROR(VLOOKUP($A22,Masterlist,8,FALSE),\"\")","v":12},33,{"$f":"IFERROR(VLOOKUP($D22,Masterlist,4,FALSE),\"\")","v":"Maaike Koning"},{"$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":"Bart Doornbos"},{"$f":"IFERROR(VLOOKUP($A25,Masterlist,8,FALSE),\"\")","v":12},25,{"$f":"IFERROR(VLOOKUP($D25,Masterlist,4,FALSE),\"\")","v":"Anneke Groot, de"},{"$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 Medema"},{"$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":"Bert Prins"},{"$f":"IFERROR(VLOOKUP($A29,Masterlist,8,FALSE),\"\")","v":17},46,{"$f":"IFERROR(VLOOKUP($D29,Masterlist,4,FALSE),\"\")","v":"Kevin Ridder"},{"$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":"Etiketten Even 10-18","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Hole","Flight ","Speler 1","Speler 2","Slagen","Slagen Mee"]
[{"$f":"'Flight schema Even 10-18'!A4","v":"Hole 10"},{"$f":"'Flight schema Even 10-18'!B4","v":"Flight 1"},{"$f":"'Flight schema Even 10-18'!B5","v":"Julius Eggens"},{"$f":"'Flight schema Even 10-18'!E5","v":"Wies Meijer"},{"$f":"'Flight schema Even 10-18'!G5","v":6.6},{"$f":"IFERROR(IF(E2<0,\"\",ROUND(E2,0)),\"\")","v":7}]
[{"$f":"'Flight schema Even 10-18'!A4","v":"Hole 10"},{"$f":"'Flight schema Even 10-18'!B4","v":"Flight 1"},{"$f":"'Flight schema Even 10-18'!B6","v":"Diane Niemeyer"},{"$f":"'Flight schema Even 10-18'!E6","v":"Thijs Visser"},{"$f":"'Flight schema Even 10-18'!G6","v":11},{"$f":"IFERROR(IF(E3<0,\"\",ROUND(E3,0)),\"\")","v":11}]
[{"$f":"'Flight schema Even 10-18'!A8","v":"Hole 11"},{"$f":"'Flight schema Even 10-18'!B8","v":"Flight 2"},{"$f":"'Flight schema Even 10-18'!B9","v":"Jasper Stoppels"},{"$f":"'Flight schema Even 10-18'!E9","v":"Angela Edinga"},{"$f":"'Flight schema Even 10-18'!G9","v":12},12]
[{"$f":"'Flight schema Even 10-18'!A8","v":"Hole 11"},{"$f":"'Flight schema Even 10-18'!B8","v":"Flight 2"},{"$f":"'Flight schema Even 10-18'!B10","v":"Arie Middel"},{"$f":"'Flight schema Even 10-18'!E10","v":"Emmy Feikema"},{"$f":"'Flight schema Even 10-18'!G10","v":11.2},11]
[{"$f":"'Flight schema Even 10-18'!A12","v":"Hole 12"},{"$f":"'Flight schema Even 10-18'!B12","v":"Flight 3"},{"$f":"'Flight schema Even 10-18'!B13","v":"Michael Bruin, de"},{"$f":"'Flight schema Even 10-18'!E13","v":"Sandra Cohen"},{"$f":"'Flight schema Even 10-18'!G13","v":11.8},12]
[{"$f":"'Flight schema Even 10-18'!A12","v":"Hole 12"},{"$f":"'Flight schema Even 10-18'!B12","v":"Flight 3"},{"$f":"'Flight schema Even 10-18'!B14","v":"Michiel Nieborg"},{"$f":"'Flight schema Even 10-18'!E14","v":"Ellen Arends"},{"$f":"'Flight schema Even 10-18'!G14","v":12.6},13]
[{"$f":"'Flight schema Even 10-18'!A16","v":"Hole 13"},{"$f":"'Flight schema Even 10-18'!B16","v":"Flight 4"},{"$f":"'Flight schema Even 10-18'!B17","v":"Dirk Aikema"},{"$f":"'Flight schema Even 10-18'!E17","v":"Angela Edinga"},{"$f":"'Flight schema Even 10-18'!G17","v":17},17]
[{"$f":"'Flight schema Even 10-18'!A16","v":"Hole 13"},{"$f":"'Flight schema Even 10-18'!B16","v":"Flight 4"},{"$f":"'Flight schema Even 10-18'!B18","v":"Hugo Wieringa"},{"$f":"'Flight schema Even 10-18'!E18","v":"Sofie Fischer"},{"$f":"'Flight schema Even 10-18'!G18","v":13.8},14]
[{"$f":"'Flight schema Even 10-18'!A20","v":"Hole 14"},{"$f":"'Flight schema Even 10-18'!B20","v":"Flight 5"},{"$f":"'Flight schema Even 10-18'!B21","v":"Daan Geertjes"},{"$f":"'Flight schema Even 10-18'!E21","v":"Julia Idema"},{"$f":"'Flight schema Even 10-18'!G21","v":15.2},15]
[{"$f":"'Flight schema Even 10-18'!A20","v":"Hole 14"},{"$f":"'Flight schema Even 10-18'!B20","v":"Flight 5"},{"$f":"'Flight schema Even 10-18'!B22","v":"Chris Franken"},{"$f":"'Flight schema Even 10-18'!E22","v":"Maaike Koning"},{"$f":"'Flight schema Even 10-18'!G22","v":16.399999999999999},16]
[{"$f":"'Flight schema Even 10-18'!A24","v":"Hole 15"},{"$f":"'Flight schema Even 10-18'!B24","v":"Flight 6"},{"$f":"'Flight schema Even 10-18'!B25","v":"Bart Doornbos"},{"$f":"'Flight schema Even 10-18'!E25","v":"Anneke Groot, de"},{"$f":"'Flight schema Even 10-18'!G25","v":17.600000000000001},18]
[{"$f":"'Flight schema Even 10-18'!A24","v":"Hole 15"},{"$f":"'Flight schema Even 10-18'!B24","v":"Flight 6"},{"$f":"'Flight schema Even 10-18'!B26","v":"Pat Medema"},{"$f":"'Flight schema Even 10-18'!E26","v":""},{"$f":"'Flight schema Even 10-18'!G26","v":17},17]
[{"$f":"'Flight schema Even 10-18'!A28","v":"Hole 16"},{"$f":"'Flight schema Even 10-18'!B28","v":"Flight 7"},{"$f":"'Flight schema Even 10-18'!B29","v":"Bert Prins"},{"$f":"'Flight schema Even 10-18'!E29","v":"Kevin Ridder"},{"$f":"'Flight schema Even 10-18'!G29","v":17},17]
[{"$f":"'Flight schema Even 10-18'!A28","v":"Hole 16"},{"$f":"'Flight schema Even 10-18'!B28","v":"Flight 7"},{"$f":"'Flight schema Even 10-18'!B30","v":""},{"$f":"'Flight schema Even 10-18'!E30","v":""},{"$f":"'Flight schema Even 10-18'!G30","v":""},""]
[{"$f":"'Flight schema Even 10-18'!A32","v":"Hole 17"},{"$f":"'Flight schema Even 10-18'!B32","v":"Flight 8"},{"$f":"'Flight schema Even 10-18'!B33","v":""},{"$f":"'Flight schema Even 10-18'!E33","v":""},{"$f":"'Flight schema Even 10-18'!G33","v":""},""]
[{"$f":"'Flight schema Even 10-18'!A32","v":"Hole 17"},{"$f":"'Flight schema Even 10-18'!B32","v":"Flight 8"},{"$f":"'Flight schema Even 10-18'!B34","v":""},{"$f":"'Flight schema Even 10-18'!E34","v":""},{"$f":"'Flight schema Even 10-18'!G34","v":""},""]
[{"$f":"'Flight schema Even 10-18'!A36","v":"Hole 18"},{"$f":"'Flight schema Even 10-18'!B36","v":"Flight 9"},{"$f":"'Flight schema Even 10-18'!B37","v":""},{"$f":"'Flight schema Even 10-18'!E37","v":""},{"$f":"'Flight schema Even 10-18'!G37","v":""},""]
[{"$f":"'Flight schema Even 10-18'!A36","v":"Hole 18"},{"$f":"'Flight schema Even 10-18'!B36","v":"Flight 9"},{"$f":"'Flight schema Even 10-18'!B38","v":""},{"$f":"'Flight schema Even 10-18'!E38","v":""},{"$f":"'Flight schema Even 10-18'!G38","v":""},""]
[{"$f":"'Flight schema Even 10-18'!A40","v":"Hole "},{"$f":"'Flight schema Even 10-18'!B40","v":"Flight 10"},{"$f":"'Flight schema Even 10-18'!B41","v":""},{"$f":"'Flight schema Even 10-18'!E41","v":""},{"$f":"'Flight schema Even 10-18'!G41","v":""},""]
[{"$f":"'Flight schema Even 10-18'!A40","v":"Hole "},{"$f":"'Flight schema Even 10-18'!B40","v":"Flight 10"},{"$f":"'Flight schema Even 10-18'!B42","v":""},{"$f":"'Flight schema Even 10-18'!E42","v":""},{"$f":"'Flight schema Even 10-18'!G42","v":""},""]

{"sheet":"Lookup Handicaps Rood","index":5,"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]]}
["Rood Heren 1-9",null,null,"Rood Dames 1-9",null,null,"Rood Men 10-18",null,null,"Rood Dames 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":"voobeeld - printbare lijst","index":6,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Shotgun Wedstrijd [date]"]
["ID","Volledige Naam","DH","Handicap","Shotgun [datum]","PLHCP 10-18",null,"ID","Volledige Naam","DH","Handicap","Shotgun [datum]","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]