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

{"sheet":"Invoerblad","index":0,"n_rows":102,"n_cols":39,"rows_kept":102,"cut":false,"hidden":false,"merged":[[44,13,45,13],[1,6,1,8],[2,6,2,8],[3,6,3,8],[4,6,4,8],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[44,10,44,12],[9,2,10,2],[9,1,10,1],[6,4,6,8],[6,1,6,3],[29,14,29,16],[14,3,14,4],[12,3,12,4],[13,3,13,4],[11,3,11,4],[17,14,17,16],[9,3,10,4],[23,14,23,16]]}
[]
[null,null,null,"Voorronde PK:",null,null," "]
[null,null,null,"Data:",null,null," "]
[null,null,null,"Locatie:",null,null," "]
[null,null,null,"Wedstrijdleider:",null,null," "]
[]
[null,"UITSLUITEND DE GELE VLAKKEN INVULLEN !",null,null,"NAMEN INVULLEN VOLGENS DE UITNODIGING",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,"Deelnemers"]
[null,"Bondsnr","Naam","Vereniging",null,"te maken","aanvangs","Oficieel"]
[null,null,null,null,null,"car.","moy.","moyenne"]
[null,null," ",null,null,null,null," ",null,null,null,null,1,{"$f":"IF(E19>0,1,FALSE)","v":1},{"$f":"IF(E26>0,1,FALSE)","v":1},{"$f":"IF(E32>0,1,FALSE)","v":1},{"$f":"IF(E41>0,1,FALSE)","v":1},{"$f":"SUM(N12:Q12)","v":4},{"$f":"PRODUCT(F12,R12)","v":4}]
[null,null," ",null,null,null,null,null,null,null,null,null,2,{"$f":"IF(E20>0,1,FALSE)","v":1},{"$f":"IF(E28>0,1,FALSE)","v":1},{"$f":"IF(E35>0,1,FALSE)","v":1},{"$f":"IF(E39>0,1,FALSE)","v":1},{"$f":"SUM(N13:Q13)","v":4},{"$f":"PRODUCT(F13,R13)","v":4}]
[null,null," ",null,null,null,null,null,null,null,null,null,3,{"$f":"IF(E22>0,1,FALSE)","v":1},{"$f":"IF(E29>0,1,FALSE)","v":1},{"$f":"IF(E33>0,1,FALSE)","v":1},{"$f":"IF(E38>0,1,FALSE)","v":1},{"$f":"SUM(N14:Q14)","v":4},{"$f":"PRODUCT(F14,R14)","v":4}]
[null,null," ",null,null,null,null,null,null,null,null,null,4,{"$f":"IF(E23>0,1,FALSE)","v":1},{"$f":"IF(E25>0,1,FALSE)","v":1},{"$f":"IF(E36>0,1,FALSE)","v":1},{"$f":"IF(E42>0,1,FALSE)","v":1},{"$f":"SUM(N15:Q15)","v":4},{"$f":"PRODUCT(F15,R15)","v":4}]
[null,null," "]
[null,"Wedstrijden"," "]
[null,null,"Naam","Car.","Brt.","HS","Moy.","Pnt.",null,null,null,null,null,null,"partij moyenne"]
[null,null,{"$f":"C12","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D19/E19,3)","v":{"$error":"#VALUE!"}},{"$f":"V19","v":0},null,null,null,null,1,{"$f":"IF(H19>0,G19,0)","v":0},{"$f":"IF(H26>0,G26,0)","v":0},{"$f":"IF(H32>0,G32,0)","v":0},{"$f":"IF(H38>0,G38,0)","v":0},{"$f":"MAX(N19:Q19)","v":0},null,{"$f":"IF(D19=F12,1,0)","v":0},{"$f":"IF(D20<F13,1,0)","v":0},{"$f":"SUM(T19:U19)","v":0},null,1,"-",2]
[null,null,{"$f":"C13","v":" "}," ",{"$f":"E19","v":" "},null,{"$error":"#VALUE!"},{"$f":"V20","v":0},null,null,null,null,2,{"$f":"IF(H20>0,G20,0)","v":0},{"$f":"IF(H28>0,G28,0)","v":0},{"$f":"IF(H35>0,G35,0)","v":0},{"$f":"IF(H39>0,G39,0)","v":0},{"$f":"MAX(N20:Q20)","v":0},null,{"$f":"IF(D20=F13,1,0)","v":0},{"$f":"IF(D19<F12,1,0)","v":0},{"$f":"SUM(T20:U20)","v":0},null,3,"-",4]
[null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(H22>0,G22,0)","v":0},{"$f":"IF(H29>0,G29,0)","v":0},{"$f":"IF(H33>0,G33,0)","v":0},{"$f":"IF(H41>0,G41,0)","v":0},0,null,null,null,null,null,4,"-",1]
[null,null,{"$f":"C14","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D22/E22,3)","v":{"$error":"#VALUE!"}},{"$f":"V22","v":0},null,null,null,null,4,{"$f":"IF(H23>0,G23,0)","v":0},{"$f":"IF(H25>0,G25,0)","v":0},{"$f":"IF(H36>0,G36,0)","v":0},{"$f":"IF(H42>0,G42,0)","v":0},0,null,{"$f":"IF(D22=F14,1,0)","v":0},{"$f":"IF(D23<F15,1,0)","v":0},{"$f":"SUM(T22:U22)","v":0},null,2,"-",3]
[null,null,{"$f":"C15","v":" "}," ",{"$f":"E22","v":" "},null,{"$error":"#VALUE!"},{"$f":"V23","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D23=F15,1,0)","v":0},{"$f":"IF(D22<F14,1,0)","v":0},0,null,1,"-",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gewonnen",null,null,null,null,null,null,null,null,2,"-",4]
[null,null,{"$f":"C15","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D25/E25,3)","v":{"$error":"#VALUE!"}},{"$f":"V25","v":0},null,null,null,null,1,{"$f":"IF(H19>1,1,0)","v":0},{"$f":"IF(H26>1,1,0)","v":0},{"$f":"IF(H32>1,1,0)","v":0},{"$f":"IF(H38>1,1,0)","v":0},{"$f":"SUM(N25:Q25)","v":0},null,{"$f":"IF(D25=F15,1,0)","v":0},{"$f":"IF(D26<F12,1,0)","v":0},0,null,1,"-",2]
[null,null,{"$f":"C12","v":" "}," ",{"$f":"E25","v":" "},null,{"$error":"#VALUE!"},{"$f":"V26","v":0},null,null,null,null,2,{"$f":"IF(H20>1,1,0)","v":0},{"$f":"IF(H28>1,1,0)","v":0},{"$f":"IF(H35>1,1,0)","v":0},{"$f":"IF(H39>1,1,0)","v":0},{"$f":"SUM(N26:Q26)","v":0},null,{"$f":"IF(D26=F12,1,0)","v":0},{"$f":"IF(D25<F15,1,0)","v":0},0,null,3,"-",4]
[null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(H22>1,1,0)","v":0},{"$f":"IF(H29>1,1,0)","v":0},{"$f":"IF(H33>1,1,0)","v":0},{"$f":"IF(H41>1,1,0)","v":0},0]
[null,null,{"$f":"C13","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D28/E28,3)","v":{"$error":"#VALUE!"}},{"$f":"V28","v":0},null,null,null,null,4,{"$f":"IF(H23>1,1,0)","v":0},{"$f":"IF(H25>1,1,0)","v":0},{"$f":"IF(H36>1,1,0)","v":0},{"$f":"IF(H42>1,1,0)","v":0},0,null,{"$f":"IF(D28=F13,1,0)","v":0},{"$f":"IF(D29<F14,1,0)","v":0},0]
[null,null,{"$f":"C14","v":" "}," ",{"$f":"E28","v":" "},null,{"$error":"#VALUE!"},{"$f":"V29","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=F14,1,0)","v":0},{"$f":"IF(D28<F13,1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gelijk"]
[null,null,null,"Car.","Brt.","HS","Moy.","Pnt.",null,null,null,null,1,{"$f":"IF(H19=1,1,0)","v":0},{"$f":"IF(H26=1,1,0)","v":0},{"$f":"IF(H32=1,1,0)","v":0},{"$f":"IF(H38=1,1,0)","v":0},{"$f":"SUM(N31:Q31)","v":0}]
[null,null,{"$f":"C12","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D32/E32,3)","v":{"$error":"#VALUE!"}},{"$f":"V32","v":0},null,null,null,null,2,{"$f":"IF(H20=1,1,0)","v":0},{"$f":"IF(H28=1,1,0)","v":0},{"$f":"IF(H35=1,1,0)","v":0},{"$f":"IF(H39=1,1,0)","v":0},{"$f":"SUM(N32:Q32)","v":0},null,{"$f":"IF(D32=F12,1,0)","v":0},{"$f":"IF(D33<F14,1,0)","v":0},0]
[null,null,{"$f":"C14","v":" "}," ",{"$f":"E32","v":" "},null,{"$error":"#VALUE!"},{"$f":"V33","v":0},null,null,null,null,3,{"$f":"IF(H22=1,1,0)","v":0},{"$f":"IF(H29=1,1,0)","v":0},{"$f":"IF(H33=1,1,0)","v":0},{"$f":"IF(H41=1,1,0)","v":0},0,null,{"$f":"IF(D33=F14,1,0)","v":0},{"$f":"IF(D32<F12,1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(H23=1,1,0)","v":0},{"$f":"IF(H25=1,1,0)","v":0},{"$f":"IF(H36=1,1,0)","v":0},{"$f":"IF(H42=1,1,0)","v":0},0]
[null,null,{"$f":"C13","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D35/E35,3)","v":{"$error":"#VALUE!"}},{"$f":"V35","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D35=F13,1,0)","v":0},{"$f":"IF(D36<F15,1,0)","v":0},0]
[null,null,{"$f":"C15","v":" "}," ",{"$f":"E35","v":" "},null,{"$error":"#VALUE!"},{"$f":"V36","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D36=F15,1,0)","v":0},{"$f":"IF(D35<F13,1,0)","v":0},0]
[]
[null,null,{"$f":"C12","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D38/E38,3)","v":{"$error":"#VALUE!"}},{"$f":"V38","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D38=F12,1,0)","v":0},{"$f":"IF(D39<F13,1,0)","v":0},0]
[null,null,{"$f":"C13","v":" "}," ",{"$f":"E38","v":" "},null,{"$error":"#VALUE!"},{"$f":"V39","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D39=F13,1,0)","v":0},{"$f":"IF(D38<F12,1,0)","v":0},0]
[]
[null,null,{"$f":"C14","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D41/E41,3)","v":{"$error":"#VALUE!"}},{"$f":"V41","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=F14,1,0)","v":0},{"$f":"IF(D42<F15,1,0)","v":0},0]
[null,null,{"$f":"C15","v":" "}," ",{"$f":"E41","v":" "},null,{"$error":"#VALUE!"},{"$f":"V42","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D42=F15,1,0)","v":0},{"$f":"IF(D41<F14,1,0)","v":0},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Plaatsing ",null,null,"Rangking"]
[null,"Stand",null,"Car.","Brt.","HS","Moy.","Pnt.","% moy.","% carb.","Mp.","% moy.","% carb."]
[null,null,{"$f":"C12","v":" "},{"$f":"SUM(D19,D26,D32,D38)","v":0},{"$f":"SUM(E19,E26,E32,E38)","v":0},{"$f":"MAX(F19,F26,F32,F38)","v":0},{"$f":"ROUNDDOWN(D47/E47,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H19,H26,H32,H38)","v":0},{"$f":"IF(OR(ISBLANK(D47),ISBLANK(E47)),\"-\",IF(AND(H12=\"NEE\",G47/G12>1),100,ROUNDDOWN(G47/G12%,2)))","v":{"$error":"#DIV/0!"}},{"$f":"D47/S12","v":0},null,null,null,{"$f":"SUM(K47:M47)","v":0}]
[null,null,{"$f":"C13","v":" "},{"$f":"SUM(D20,D28,D35,D39)","v":0},{"$f":"SUM(E20,E28,E35,E39)","v":0},{"$f":"MAX(F20,F28,F35,F39)","v":0},{"$f":"ROUNDDOWN(D48/E48,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H20,H28,H35,H39)","v":0},{"$f":"IF(OR(ISBLANK(D48),ISBLANK(E48)),\"-\",IF(AND(H13=\"NEE\",G48/G13>1),100,ROUNDDOWN(G48/G13%,2)))","v":{"$error":"#DIV/0!"}},{"$f":"D48/S13","v":0},null,null,null,{"$f":"SUM(K48:M48)","v":0}]
[null,null,{"$f":"C14","v":" "},{"$f":"SUM(D22,D29,D33,D41)","v":0},{"$f":"SUM(E22,E29,E33,E41)","v":0},{"$f":"MAX(F22,F29,F33,F41)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H22,H29,H33,H41)","v":0},{"$f":"IF(OR(ISBLANK(D49),ISBLANK(E49)),\"-\",IF(AND(H14=\"NEE\",G49/G14>1),100,ROUNDDOWN(G49/G14%,2)))","v":{"$error":"#DIV/0!"}},{"$f":"D49/S14","v":0},null,null,null,{"$f":"SUM(K49:M49)","v":0}]
[null,null,{"$f":"C15","v":" "},{"$f":"SUM(D23,D25,D36,D42)","v":0},{"$f":"SUM(E23,E25,E36,E42)","v":0},{"$f":"MAX(F23,F25,F36,F42)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H23,H25,H36,H42)","v":0},{"$f":"IF(OR(ISBLANK(D50),ISBLANK(E50)),\"-\",IF(AND(H15=\"NEE\",G50/G15>1),100,ROUNDDOWN(G50/G15%,2)))","v":{"$error":"#DIV/0!"}},{"$f":"D50/S15","v":0},null,null,null,{"$f":"SUM(K50:M50)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Uitslagformulier","index":1,"n_rows":97,"n_cols":16,"rows_kept":97,"cut":false,"hidden":false,"merged":[[21,8,21,11],[22,8,26,11],[10,7,10,9],[11,7,11,9],[1,1,1,4],[11,2,11,6],[10,2,10,6],[1,5,1,9],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[27,7,27,8],[23,0,23,2],[24,0,24,2],[25,0,25,2],[19,4,19,7],[20,4,20,7],[21,4,21,7],[22,4,22,7],[23,4,23,7],[24,4,24,7],[25,4,25,7],[26,4,26,7],[19,0,19,2],[20,0,20,2],[22,0,22,2],[26,0,26,2]]}
[]
[null,"uitslagformulier voorronden",null,null,null,{"$f":"Invoerblad!G2","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plaatsing ",null,null,"Rangking"]
[null,"Bondsnr.","Naam","Gew.","Remise","Car.","Brt.","HS.","Pnt.","Moyenne","% Moy.","% carb.","Mp.","% moy.","% carb."]
[1,{"$f":"Invoerblad!B12","v":0},{"$f":"Invoerblad!C12","v":" "},{"$f":"Invoerblad!R25","v":0},{"$f":"Invoerblad!R31","v":0},{"$f":"Invoerblad!D47","v":0},{"$f":"Invoerblad!E47","v":0},{"$f":"Invoerblad!F47","v":0},{"$f":"Invoerblad!H47","v":0},{"$f":"Invoerblad!G47","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I47","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J47","v":0},{"$f":"Invoerblad!K47","v":0},{"$f":"Invoerblad!L47","v":0},{"$f":"Invoerblad!M47","v":0},{"$f":"Invoerblad!N47","v":0}]
[2,{"$f":"Invoerblad!B13","v":0},{"$f":"Invoerblad!C13","v":" "},{"$f":"Invoerblad!R26","v":0},{"$f":"Invoerblad!R32","v":0},{"$f":"Invoerblad!D48","v":0},{"$f":"Invoerblad!E48","v":0},{"$f":"Invoerblad!F48","v":0},{"$f":"Invoerblad!H48","v":0},{"$f":"Invoerblad!G48","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I48","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J48","v":0},{"$f":"Invoerblad!K48","v":0},{"$f":"Invoerblad!L48","v":0},{"$f":"Invoerblad!M48","v":0},{"$f":"Invoerblad!N48","v":0}]
[3,{"$f":"Invoerblad!B14","v":0},{"$f":"Invoerblad!C14","v":" "},{"$f":"Invoerblad!R27","v":0},{"$f":"Invoerblad!R33","v":0},{"$f":"Invoerblad!D49","v":0},{"$f":"Invoerblad!E49","v":0},{"$f":"Invoerblad!F49","v":0},{"$f":"Invoerblad!H49","v":0},{"$f":"Invoerblad!G49","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I49","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J49","v":0},{"$f":"Invoerblad!K49","v":0},{"$f":"Invoerblad!L49","v":0},{"$f":"Invoerblad!M49","v":0},{"$f":"Invoerblad!N49","v":0}]
[4,{"$f":"Invoerblad!B15","v":0},{"$f":"Invoerblad!C15","v":" "},{"$f":"Invoerblad!R28","v":0},{"$f":"Invoerblad!R34","v":0},{"$f":"Invoerblad!D50","v":0},{"$f":"Invoerblad!E50","v":0},{"$f":"Invoerblad!F50","v":0},{"$f":"Invoerblad!H50","v":0},{"$f":"Invoerblad!G50","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I50","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J50","v":0},{"$f":"Invoerblad!K50","v":0},{"$f":"Invoerblad!L50","v":0},{"$f":"Invoerblad!M50","v":0},{"$f":"Invoerblad!N50","v":0}]
[]
[null,null,"Naam vereniging",null,null,null,null,"Datum"]
[null,null,{"$f":"Invoerblad!G4","v":" "},null,null,null,null,{"$f":"Invoerblad!G3","v":" "}]
[]
["DIT FORMULIER DUIDELIJK INGEVULD EN VOORZIEN VAN DE HANDTEKENING "]
[]
["VAN EEN LID VAN DE ORGANISERENDE VERENIGING           BINNEN 3 DAGEN "]
[]
["NA AFLOOP VAN DE VOORWEDSTRIJDEN TOEZENDEN OF MAILEN AAN:  "]
["﻿ "]
["Wedstrijdleider PK Libre en bandstoten"]
["District Berkel & Slinge"]
[null,null,null,null,null,null,null,null,"Handtekening"]
["Johan Jansink",null,null,null,null,null,null,null,{"$f":"Invoerblad!G5","v":" "}]
["Veemarkt 11"]
["7121 AH  Aalten"]
["Tel: 0543-472292 / 06-40263789"]
["j.jansink2016@gmail.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"made by Marco Ubbink"]