{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Berekening"],"not_rendered":{"images":5,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Berekening","index":0,"n_rows":31,"n_cols":18,"rows_kept":31,"merged":[[2,16,2,17],[17,11,17,12],[17,13,17,15]]}
[]
[]
[{"$nulls":3},"Aantal deelnemers",60,null,"Inkomsten",{"$f":"SUM((E3*E4)+E12)","v":{"v":2100,"d":"€2,100.00"}},{"$nulls":3},"Perc.","Bedrag",null,"Vast",null,"Opbouw inschrijfgeld"]
[{"$nulls":3},"Inschrijfgeld",{"v":35,"d":"€35.00"},{"$nulls":4},"1e Prijs",null,30,{"$f":"TRUNC(SUM(($H$5/200)*L4))","v":{"v":81,"d":"€81.00"}},null,{"v":80,"d":"€80.00"},null,"Inschrijfgeld",{"$f":"E4","v":{"v":35,"d":"€35.00"}}]
[{"$nulls":3},"Finale","NEE",null,"Beschikbaar prijzengeld",{"$f":"SUM(H3-H12)","v":{"v":540,"d":"€540.00"}},null,"2e Prijs",null,20,{"v":54,"d":"€54.00"},null,{"v":55,"d":"€55.00"},null,"Baanhuur",{"$f":"E7","v":{"v":17.5,"d":"€17.50"}}]
[{"$nulls":3},"Aantal finaleplaatsen",0,{"$nulls":4},"3e Prijs",null,16,{"v":43,"d":"€43.00"},null,{"v":42.5,"d":"€42.50"},null,"NBF adm.",{"$f":"SUM($E9/$E3)","v":{"v":3,"d":"€3.00"}}]
[{"$nulls":3},"Baanhuur p/u",{"v":17.5,"d":"€17.50"},null,"Baanhuur",{"$f":"SUM((E3+E6)*E7)","v":{"v":1050,"d":"€1,050.00"}},null,"4e Prijs",null,14,{"v":37,"d":"€37.00"},null,{"v":37.5,"d":"€37.50"},null,"NBF score",{"$f":"$E10","v":{"v":2,"d":"€2.00"}}]
[{"$nulls":3},"Drukkosten",{"v":10,"d":"€10.00"},null,"Drukkosten",{"$f":"E8","v":{"v":10,"d":"€10.00"}},null,"5e Prijs",null,11,{"v":29,"d":"€29.00"},null,{"v":30,"d":"€30.00"},null,"Organisatie",{"$f":"SUM(($E8+$E11)/$E3)","v":{"v":3.5,"d":"€3.50"}}]
[{"$nulls":3},"NBF Administratie",{"v":180,"d":"€180.00"},null,"NBF Administratie",{"$f":"E9","v":{"v":180,"d":"€180.00"}},null,"6e Prijs",null,9,{"v":24,"d":"€24.00"},null,{"v":25,"d":"€25.00"}]
[{"$nulls":3},"NBF Scoreverwerking pp",{"v":2,"d":"€2.00"},null,"NBF Scoreverwerking",{"$f":"SUM(E3*E10)","v":{"v":120,"d":"€120.00"}},null,"7e Prijs",null,0,0,null,0,null,"Prijzengeld pp",{"$f":"SUM($R4-(SUM(R5:R8)))","v":{"v":9,"d":"€9.00"}}]
[{"$nulls":3},"Kosten organisatie",{"v":200,"d":"€200.00"},null,"Kosten organisatie",{"$f":"E11","v":{"v":200,"d":"€200.00"}},null,"8e Prijs",null,0,0,null,0]
[{"$nulls":3},"Sponsoren",0,null,"Vaste uitgaven",{"$f":"SUM(H7:H11)","v":{"v":1560,"d":"€1,560.00"}},null,"9e Prijs",null,0,0,null,0]
[{"$nulls":9},"10e Prijs",null,0,0,null,0]
[]
[{"$nulls":11},"Controle","Controle",null,"Controle"]
[{"$nulls":11},{"$f":"SUM(L4:L13)/100","v":{"v":1,"d":"100%"}},{"$f":"SUM(M4:M13)*2","v":{"v":536,"d":"€536.00"}},null,{"$f":"SUM(O4:O13)*2","v":{"v":540,"d":"€540.00"}}]
[]
[{"$nulls":11},"OVERSCHRIJDING",null,"OVERSCHRIJDING"]
[null,"Geef de volgende velden zelf op:",null,"Aantal Deelnemers",null,"Het beschikbaar prijzengeld wordt berekend aan de hand "]
[{"$nulls":3},"Inschrijfgeld",null,"van de ingestelde variabelen."]
[{"$nulls":3},"Sponsorengeld (totaalbedrag)"]
[{"$nulls":3},"Baanhuur",null,"Bij 'Percentages' kunt u zelf de percentages aanpassen."]
[{"$nulls":3},"Drukkosten",null,"De bedragen worden naar beneden toe afgerond op hele euro's."]
[{"$nulls":3},"NBF Administratie",null,"Bij 'Vast' vult u zelf de bedragen in per plaats."]
[{"$nulls":3},"NBF Scoreverwerking (bedrag pp)",null,"Bij het instellen van het  prijzengeld wordt automatisch"]
[{"$nulls":3},"Kosten organisatie",null,"een overschrijding aangegeven wanneer dit het geval is."]
[]
[null,"Stel de volgende velden in:",null,"Finale (JA/NEE)",null,"Gebruik 'SAVE' voor opslaan en 'Print' voor opslaan als pdf"]
[{"$nulls":3},"Aantal finaleplaatsen (0, 8, 16 of 24)",null,"Gebruik 'Info' knop voor tonen/verbergen van deze instructies"]
[]
[{"$nulls":4},"© HW - Products / Versie 1.4  "]