{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Scores","Stand"],"not_rendered":{"images":7,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Scores","index":0,"n_rows":59,"n_cols":15,"rows_kept":59,"merged":[[2,3,2,4],[2,7,2,9],[3,12,3,13],[4,12,4,13],[11,14,13,14],[16,14,18,14],[21,14,23,14],[26,14,28,14],[31,14,33,14],[36,14,38,14],[41,14,43,14],[46,14,48,14],[51,14,53,14],[56,14,58,14]]}
[]
[]
[]
[{"$nulls":3},230,"Hcp Basis",{"$nulls":6},10,"Aantal Teams"]
[{"$nulls":3},80,"Hcp Percentage",{"$nulls":6},5,"Aantal Games"]
[{"$nulls":3},64,"Hcp Max."]
[]
[]
[]
[{"$nulls":4},"TEAM","GEM","Verschil","HCP","1e GAME","2e GAME","3e GAME","4e GAME","5e GAME","SERIE SCRATCH","TEAM TOTAAL"]
[3,{"$nulls":3},"NAAM TEAM",null,null,{"$f":"SUM(H12:H14)","v":192},{"$f":"IF(I14<>\"\",I12+I13+I14+$H11,0)","v":0},{"$f":"IF(J14<>\"\",J12+J13+J14+$H11,0)","v":0},{"$f":"IF(K14<>\"\",K12+K13+K14+$H11,0)","v":0},{"$f":"IF(L14<>\"\",L12+L13+L14+$H11,0)","v":0},0]
[4,{"$nulls":3},"NAAM SPELER",null,{"$f":"ROUNDDOWN((($D$4-F12)*$D$5)/100,0)","v":184},{"$f":"IF(G12>$D$6,$D$6,G12)","v":64},{"$nulls":5},{"$f":"SUM(I12:M12)","v":0},{"$f":"SUM(I11:M11)","v":0}]
[5,{"$nulls":3},"NAAM SPELER",null,{"$f":"ROUNDDOWN((($D$4-F13)*$D$5)/100,0)","v":184},{"$f":"IF(G13>$D$6,$D$6,G13)","v":64},{"$nulls":5},{"$f":"SUM(I13:M13)","v":0}]
[6,{"$nulls":3},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I14:M14)","v":0}]
[7]
[8,{"$nulls":3},"NAAM TEAM",null,null,{"$f":"SUM(H17:H19)","v":192},{"$f":"IF(I19<>\"\",I17+I18+I19+$H16,0)","v":0},{"$f":"IF(J19<>\"\",J17+J18+J19+$H16,0)","v":0},{"$f":"IF(K19<>\"\",K17+K18+K19+$H16,0)","v":0},{"$f":"IF(L19<>\"\",L17+L18+L19+$H16,0)","v":0},0]
[9,{"$nulls":3},"NAAM SPELER",null,184,{"$f":"IF(G17>$D$6,$D$6,G17)","v":64},{"$nulls":5},{"$f":"SUM(I17:M17)","v":0},{"$f":"SUM(I16:M16)","v":0}]
[10,{"$nulls":3},"NAAM SPELER",null,184,{"$f":"IF(G18>$D$6,$D$6,G18)","v":64},{"$nulls":5},{"$f":"SUM(I18:M18)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I19:M19)","v":0}]
[]
[{"$nulls":4},"NAAM TEAM",null,null,{"$f":"SUM(H22:H24)","v":192},{"$f":"IF(I24<>\"\",I22+I23+I24+$H21,0)","v":0},{"$f":"IF(J24<>\"\",J22+J23+J24+$H21,0)","v":0},{"$f":"IF(K24<>\"\",K22+K23+K24+$H21,0)","v":0},{"$f":"IF(L24<>\"\",L22+L23+L24+$H21,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G22>$D$6,$D$6,G22)","v":64},{"$nulls":5},{"$f":"SUM(I22:M22)","v":0},{"$f":"SUM(I21:M21)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G23>$D$6,$D$6,G23)","v":64},{"$nulls":5},{"$f":"SUM(I23:M23)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I24:M24)","v":0}]
[]
[{"$nulls":4},"NAAM TEAM",null,null,{"$f":"SUM(H27:H29)","v":192},{"$f":"IF(I29<>\"\",I27+I28+I29+$H26,0)","v":0},{"$f":"IF(J29<>\"\",J27+J28+J29+$H26,0)","v":0},{"$f":"IF(K29<>\"\",K27+K28+K29+$H26,0)","v":0},{"$f":"IF(L29<>\"\",L27+L28+L29+$H26,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G27>$D$6,$D$6,G27)","v":64},{"$nulls":5},{"$f":"SUM(I27:M27)","v":0},{"$f":"SUM(I26:M26)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G28>$D$6,$D$6,G28)","v":64},{"$nulls":5},{"$f":"SUM(I28:M28)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I29:M29)","v":0}]
[{"$nulls":6},184]
[{"$nulls":4},"NAAM TEAM",null,184,{"$f":"SUM(H32:H34)","v":192},{"$f":"IF(I34<>\"\",I32+I33+I34+$H31,0)","v":0},{"$f":"IF(J34<>\"\",J32+J33+J34+$H31,0)","v":0},{"$f":"IF(K34<>\"\",K32+K33+K34+$H31,0)","v":0},{"$f":"IF(L34<>\"\",L32+L33+L34+$H31,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G32>$D$6,$D$6,G32)","v":64},{"$nulls":5},{"$f":"SUM(I32:M32)","v":0},{"$f":"SUM(I31:M31)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G33>$D$6,$D$6,G33)","v":64},{"$nulls":5},{"$f":"SUM(I33:M33)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I34:M34)","v":0}]
[]
[{"$nulls":4},"NAAM TEAM",null,null,{"$f":"SUM(H37:H39)","v":192},{"$f":"IF(I39<>\"\",I37+I38+I39+$H36,0)","v":0},{"$f":"IF(J39<>\"\",J37+J38+J39+$H36,0)","v":0},{"$f":"IF(K39<>\"\",K37+K38+K39+$H36,0)","v":0},{"$f":"IF(L39<>\"\",L37+L38+L39+$H36,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G37>$D$6,$D$6,G37)","v":64},{"$nulls":5},{"$f":"SUM(I37:M37)","v":0},{"$f":"SUM(I36:M36)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G38>$D$6,$D$6,G38)","v":64},{"$nulls":5},{"$f":"SUM(I38:M38)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I39:M39)","v":0}]
[]
[{"$nulls":4},"NAAM TEAM",null,null,{"$f":"SUM(H42:H44)","v":192},{"$f":"IF(I44<>\"\",I42+I43+I44+$H41,0)","v":0},{"$f":"IF(J44<>\"\",J42+J43+J44+$H41,0)","v":0},{"$f":"IF(K44<>\"\",K42+K43+K44+$H41,0)","v":0},{"$f":"IF(L44<>\"\",L42+L43+L44+$H41,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G42>$D$6,$D$6,G42)","v":64},{"$nulls":5},{"$f":"SUM(I42:M42)","v":0},{"$f":"SUM(I41:M41)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G43>$D$6,$D$6,G43)","v":64},{"$nulls":5},{"$f":"SUM(I43:M43)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I44:M44)","v":0}]
[]
[{"$nulls":4},"NAAM TEAM",null,null,{"$f":"SUM(H47:H49)","v":192},{"$f":"IF(I49<>\"\",I47+I48+I49+$H46,0)","v":0},{"$f":"IF(J49<>\"\",J47+J48+J49+$H46,0)","v":0},{"$f":"IF(K49<>\"\",K47+K48+K49+$H46,0)","v":0},{"$f":"IF(L49<>\"\",L47+L48+L49+$H46,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G47>$D$6,$D$6,G47)","v":64},{"$nulls":5},{"$f":"SUM(I47:M47)","v":0},{"$f":"SUM(I46:M46)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G48>$D$6,$D$6,G48)","v":64},{"$nulls":5},{"$f":"SUM(I48:M48)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I49:M49)","v":0}]
[]
[{"$nulls":4},"NAAM TEAM",null,null,{"$f":"SUM(H52:H54)","v":192},{"$f":"IF(I54<>\"\",I52+I53+I54+$H51,0)","v":0},{"$f":"IF(J54<>\"\",J52+J53+J54+$H51,0)","v":0},{"$f":"IF(K54<>\"\",K52+K53+K54+$H51,0)","v":0},{"$f":"IF(L54<>\"\",L52+L53+L54+$H51,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G52>$D$6,$D$6,G52)","v":64},{"$nulls":5},{"$f":"SUM(I52:M52)","v":0},{"$f":"SUM(I51:M51)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G53>$D$6,$D$6,G53)","v":64},{"$nulls":5},{"$f":"SUM(I53:M53)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I54:M54)","v":0}]
[]
[{"$nulls":4},"NAAM TEAM",null,null,{"$f":"SUM(H57:H59)","v":192},{"$f":"IF(I59<>\"\",I57+I58+I59+$H56,0)","v":0},{"$f":"IF(J59<>\"\",J57+J58+J59+$H56,0)","v":0},{"$f":"IF(K59<>\"\",K57+K58+K59+$H56,0)","v":0},{"$f":"IF(L59<>\"\",L57+L58+L59+$H56,0)","v":0},0]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G57>$D$6,$D$6,G57)","v":64},{"$nulls":5},{"$f":"SUM(I57:M57)","v":0},{"$f":"SUM(I56:M56)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,{"$f":"IF(G58>$D$6,$D$6,G58)","v":64},{"$nulls":5},{"$f":"SUM(I58:M58)","v":0}]
[{"$nulls":4},"NAAM SPELER",null,184,64,{"$nulls":5},{"$f":"SUM(I59:M59)","v":0}]

{"sheet":"Stand","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"hidden":true}
["PLAATS","TEAMNAAM","SCORE"]
[{"$f":"IF($B2<>\"NAAM TEAM\",1,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B3<>\"NAAM TEAM\",2,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B4<>\"NAAM TEAM\",3,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B5<>\"NAAM TEAM\",4,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B6<>\"NAAM TEAM\",5,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B7<>\"NAAM TEAM\",6,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B8<>\"NAAM TEAM\",7,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B9<>\"NAAM TEAM\",8,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B10<>\"NAAM TEAM\",9,\"\")","v":""},"NAAM TEAM",0]
[{"$f":"IF($B11<>\"NAAM TEAM\",10,\"\")","v":""},"NAAM TEAM",0]