{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["blad 1","blad 2","printblad","Grafiek omzet","Grafiek afzet"],"not_rendered":{"charts":8,"images":0,"macros":1,"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":"blad 1","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,2,10,3],[12,2,12,3],[13,2,13,3],[5,2,5,4],[7,2,7,3],[8,2,8,3],[9,2,9,3]]}
[]
[]
[null,null,"Naam"]
[null,null,"Klas"]
[]
[null,null,"Verwachtte aantal verkochte broodjes 850 de prijs per broodje € 2,50"]
[]
[null,null,"omzet"]
[null,null,"inkoopwaarde van de omzet",null,1275]
[null,null,"personeelskosten",null,120]
[null,null,"overige kosten",null,250]
[]
[null,null,"brutowinst"]
[null,null,"nettowinst"]

{"sheet":"blad 2","index":1,"n_rows":49,"n_cols":24,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,2,48,3],[2,4,2,6],[3,4,3,6],[5,2,5,14],[7,9,22,14],[7,2,22,7],[24,2,39,7],[24,9,39,14],[41,2,41,14],[44,2,44,14],[47,2,47,14],[42,2,42,3],[45,2,45,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"maak keuze"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"maart"]
[null,null,"Kandidaatnaam:",null,{"$f":"'blad 1'!D3","v":0},null,null,null,null,null,null,null,null,null,"blad 2",null,null,null,null,null,null,null,null,"april"]
[null,null,"Kandidaatnummer:",null,{"$f":"'blad 1'!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mei"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"juni"]
[null,null,"Bedrijfsresultaten over de maanden maart - november 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"juli"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"augustus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"september"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oktober"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"november"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"vraag a  In welke maand heeft Outdoor evenveel omgezet voor het vrijgezellenfeest als voor de teambuilding?"]
[null,null,"maak keuze"]
[]
[null,null,"vraag b  In welke maand heeft Outdoor de meeste arrangementen verkocht?  "]
[null,null,"maak keuze"]
[]
[null,null,"vraag c  In welke maand waren de inkomsten van Outdoor het laagst?  "]
[null,null,"maak keuze"]

{"sheet":"printblad","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,3,18,4],[19,3,19,4],[20,3,20,4],[13,2,13,3],[11,2,11,3],[16,2,16,4],[12,2,12,3],[5,2,5,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[]
[]
[null,null,{"$f":"'blad 1'!C3","v":"Naam"},{"$f":"'blad 1'!D3","v":0}]
[null,null,{"$f":"'blad 1'!C4","v":"Klas"},{"$f":"'blad 1'!D4","v":0}]
[]
[null,null,{"$f":"'blad 1'!C6","v":"Verwachtte aantal verkochte broodjes 850 de prijs per broodje € 2,50"}]
[]
[null,null,{"$f":"'blad 1'!C8","v":"omzet"},null,{"$f":"'blad 1'!E8","v":0}]
[null,null,{"$f":"'blad 1'!C9","v":"inkoopwaarde van de omzet"},null,{"$f":"'blad 1'!E9","v":1275}]
[null,null,{"$f":"'blad 1'!C10","v":"personeelskosten"},null,{"$f":"'blad 1'!E10","v":120}]
[null,null,{"$f":"'blad 1'!C11","v":"overige kosten"},null,{"$f":"'blad 1'!E11","v":250}]
[]
[null,null,{"$f":"'blad 1'!C13","v":"brutowinst"},null,{"$f":"'blad 1'!E13","v":0}]
[null,null,{"$f":"'blad 1'!C14","v":"nettowinst"},null,{"$f":"'blad 1'!E14","v":0}]
[]
[]
[null,null,{"$f":"'blad 2'!C6","v":"Bedrijfsresultaten over de maanden maart - november 2021"}]
[]
[null,null,"vraag a",{"$f":"'blad 2'!C43","v":"maak keuze"}]
[null,null,"vraag b",{"$f":"'blad 2'!C46","v":"maak keuze"}]
[null,null,"vraag c",{"$f":"'blad 2'!C49","v":"maak keuze"}]

{"sheet":"Grafiek omzet","index":3,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,5]]}
[]
[]
[null,null,null,null,null,null,null,"Toch voor kinderfeest ipv bedrijfsfeest gekozen, omdat bedrijfsfeest ook teambuilding is"]
[]
[null,"omzet per arrangement",null,null,null,null,null,"December - januari-Februari dicht"]
[]
[null,null,"teambuiding","vrijgezellenfeest","kinderfeestje"]
[]
[null,"maart",{"$f":"SUM(C20*25)*16","v":22600},{"$f":"SUM(D20*15)*24","v":27000},{"$f":"SUM(E20*10)*26","v":8320}]
[null,"april",{"$f":"SUM(C20*25)*22","v":31075},{"$f":"SUM(D20*15)*22","v":24750},{"$f":"SUM(E20*10)*52","v":16640}]
[null,"mei",{"$f":"SUM(C20*25)*31","v":43787.5},{"$f":"SUM(D20*15)*20","v":22500},{"$f":"SUM(E20*10)*31","v":9920}]
[null,"juni",{"$f":"SUM(C20*25)*26","v":36725},{"$f":"SUM(D20*15)*26","v":29250},{"$f":"SUM(E20*10)*26","v":8320}]
[null,"juli",{"$f":"SUM(C20*22500/C20/15.8)*15.8","v":22500},{"$f":"SUM(D20*15)*20","v":22500},{"$f":"SUM(E20*10)*15","v":4800}]
[null,"augustus",{"$f":"SUM(C20*25)*8","v":11300},{"$f":"SUM(D20*15)*28","v":31500},{"$f":"SUM(E20*10)*12","v":3840}]
[null,"september",{"$f":"SUM(C20*25)*26","v":36725},{"$f":"SUM(D20*15)*26","v":29250},{"$f":"SUM(E20*10)*45","v":14400}]
[null,"oktober",{"$f":"SUM(C20*25)*18","v":25425},{"$f":"SUM(D20*15)*18","v":20250},{"$f":"SUM(E20*10)*18","v":5760}]
[null,"november",{"$f":"SUM(C20*25)*12","v":16950},{"$f":"SUM(D20*15)*12","v":13500},{"$f":"SUM(E20*10)*12","v":3840}]
[]
[]
[null,null,56.5,75,32]

{"sheet":"Grafiek afzet","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,5]]}
[]
[]
[null,null,null,null,null,null,null,"Toch voor kinderfeest ipv bedrijfsfeest gekozen, omdat bedrijfsfeest ook teambuilding is"]
[]
[null,"Afzet per arrangement",null,null,null,null,null,"December - januari-Februari dicht"]
[]
[null,null,"teambuiding","vrijgezellenfeest","kinderfeestje"]
[]
[null,"maart",{"$f":"SUM(C20*25)*16","v":400},{"$f":"SUM(D20*15)*24","v":360},{"$f":"SUM(E20*10)*26","v":260},{"$f":"SUM(C9:E9)","v":1020}]
[null,"april",{"$f":"SUM(C20*25)*26","v":650},{"$f":"SUM(D20*15)*22","v":330},{"$f":"SUM(E20*10)*55","v":550},{"$f":"SUM(C10:E10)","v":1530}]
[null,"mei",{"$f":"SUM(C20*25)*31","v":775},{"$f":"SUM(D20*15)*20","v":300},{"$f":"SUM(E20*10)*31","v":310},1385]
[null,"juni",{"$f":"SUM(C20*25)*26","v":650},{"$f":"SUM(D20*15)*26","v":390},{"$f":"SUM(E20*10)*26","v":260},1300]
[null,"juli",{"$f":"SUM(C20*25)*15.8","v":395},{"$f":"SUM(D20*15)*20","v":300},{"$f":"SUM(E20*10)*15","v":150},845]
[null,"augustus",{"$f":"SUM(C20*25)*7","v":175},{"$f":"SUM(D20*15)*25","v":375},{"$f":"SUM(E20*10)*9","v":90},640]
[null,"september",{"$f":"SUM(C20*25)*24","v":600},{"$f":"SUM(D20*15)*26","v":390},{"$f":"SUM(E20*10)*45","v":450},1440]
[null,"oktober",{"$f":"SUM(C20*25)*18","v":450},{"$f":"SUM(D20*15)*18","v":270},{"$f":"SUM(E20*10)*18","v":180},900]
[null,"november",{"$f":"SUM(C20*25)*14","v":350},{"$f":"SUM(D20*15)*18","v":270},{"$f":"SUM(E20*10)*12","v":120},740]
[]
[]
[null,null,1,1,1]