{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Voorblad","Home","Blanco","Inkoop","Instellingen"],"not_rendered":{"charts":0,"images":8,"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":"Voorblad","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,1,6,5]]}
[]
[]
[]
[null,"Werkt de bovenstaande knop niet, dan moet je eerst de onderstaande stappen doorlopen om de macro's te deblokkeren."]
[]
[null,"Dit bestand bevat macro's"]
[null,"In nieuwere versies van Excel is door Microsoft een extra beveiliging geplaatst op het openen van bestanden met macro’s. \nNaast dat macro's erg nuttig kunnen zijn worden ze ook misbruikt voor malware en ransomware. Door de macro's standaard te blokkeren wil Microsoft de strijd aan gaan tegen cybercriminaliteit."]
[null,"Dit Exceldocument bevat macro's om een goede werking van het bestand te garanderen. Deblokkeren van het bestand doet u als volgt:"]
[]
[null,"Stap 1. Blokkade opheffen",null,null,"Stap 2. Macro's inschakelen"]
[null,"a.","U moet het bestand opslaan op een lokale harde schijf (of OneDrive). ",null,"Nadat je de blokkering van het Excelbestand hebt opgeheven, is het (vaak) ook nog nodig om de macro’s in te schakelen."]
[null,"b.","Open Windows Verkenner en zoek het bestand op. "]
[null,"c.","Klik vervolgens met de rechtermuisknop op het bestand en kies Eigenschappen in het contextmenu. \nOnderaan het tabblad Algemeen ziet u een sectie Beveiliging. Schakel het selectievakje Blokkering opheffen in. \n",null,"a.","Dit zie je doordat je een pop-up krijgt met de melding: ‘Microsoft Office heeft een mogelijk beveiligingsprobleem geïdentificeerd.’ of door een gele balk bovenin je Excelbestand met daarin de tekst: ‘BEVEILIGINGSWAARSCHUWING \nMacro’s zijn uitgeschakeld.’ Zie ook afbeeldingen 2 en 3."]
[null,null,"En klik op OK. Zie ook afbeelding 1",null,"b.","In deze gevallen kun je de macro’s inschakelen door op de knop ‘Macro’s inschakelen’ te klikken in het pop-up scherm, of \nop de knop ‘Inhoud inschakelen’ in de gele balk"]
[null,null,"Wanneer u nu het bestand (opnieuw) opent zullen de macro's in het bestand werkzaam zijn."]
[null,null,"Afbeelding 1",null,null,"Afbeelding 2                                                                                                    Afbeelding 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Deze handleiding is ook terug te lezen via deze link."]

{"sheet":"Home","index":1,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kostprijsberekeningen"]
[]
[]
[null,"Artikel",null,"Kostprijs"]
[null,"Nummer","Omschrijving","Materiaal","Arbeid","Totaal"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7,null,null,null,null,null,null,null,null,"Bestand aanpassen of"]
[null,8,null,null,null,null,null,null,null,null,"een bestand op maat?"]
[null,9,null,null,null,null,null,null,null,null,"Neem contact op via:"]
[null,10]
[null,11,null,null,null,null,null,null,null,"*","info@terzake-excel.nl"]
[null,12,null,null,null,null,null,null,null,"(","0317 200 009"]
[null,13]
[null,14]
[null,15]

{"sheet":"Blanco","index":2,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":true,"merged":[[2,2,2,4]]}
[null,"Kostprijsberekening"]
[]
[null,"Artikel"]
[]
[null,"Onderdelen","Aantal","Eenheid","Prijs"]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B6,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B6,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C6","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B7,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B7,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C7","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B8,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B8,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C8","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B9,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B9,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C9","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B10,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B10,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C10","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B11,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B11,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C11","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B12,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B12,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C12","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B13,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B13,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C13","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B14,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B14,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C14","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B15,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B15,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C15","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B16,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B16,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C16","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B17,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B17,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C17","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B18,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B18,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C18","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B19,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B19,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C19","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B20,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B20,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C20","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B21,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B21,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C21","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B22,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B22,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C22","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B23,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B23,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C23","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B24,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B24,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C24","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B25,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B25,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C25","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B26,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B26,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C26","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B27,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B27,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C27","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B28,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B28,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C28","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B29,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B29,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C29","v":0}]
[null,null,null,{"$f":"_xlfn.XLOOKUP($B30,Inkoop!$B$4:$B$199,Inkoop!$C$4:$C$199,\"\",0)","v":0},{"$f":"_xlfn.XLOOKUP($B30,Inkoop!$B$4:$B$199,Inkoop!$D$4:$D$199)*$C30","v":0}]
[null,"Materiaalkosten totaal",null,null,{"$f":"SUM(E6:E30)","v":0}]
[null,"Arbeid",null,null,{"$f":"IF(D32=\"uur\",C32*Instellingen!F3,(Instellingen!F3/60*C32))","v":0}]
[]
[null,"Totale kostprijs",null,null,{"$f":"E31+E32","v":0}]

{"sheet":"Inkoop","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Inkoopprijzen"]
[]
[null,"Materiaal","Meeteenheid","Prijs per eenheid"]

{"sheet":"Instellingen","index":4,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Instellingen"]
[]
[null,"Meeteenheden",null,null,"Uurloon",null,null,null,"Bereken cm2/m2"]
[null,"Meter","m",null,null,null,null,null,"Lengte",100,"cm",null,{"$f":"IF(K4=\"m\",J4,IF(K4=\"cm\",J4/100,IF(K4=\"mm\",J4/1000,0)))","v":1}]
[null,null,"cm",null,null,null,null,null,"Breedte",100,"cm",null,{"$f":"IF(K5=\"m\",J5,IF(K5=\"cm\",J5/100,IF(K5=\"mm\",J5/1000,0)))","v":1}]
[null,null,"mm",null,null,null,null,null,null,{"$f":"M6","v":1},"m2",null,{"$f":"IF(K6=\"m2\",M4*M5,(M4*M5*10000))","v":1}]
[null,"Vierkante meter","m2"]
[null,null,"cm2",null,null,null,null,null,"Bereken cm3/m3"]
[null,"Kubieke meter","m3",null,null,null,null,null,"Lengte ",0,"cm",null,{"$f":"IF(K9=\"m\",J9,IF(K9=\"cm\",J9/100,IF(K9=\"mm\",J9/1000,0)))","v":0}]
[null,null,"cm3",null,null,null,null,null,"Breedte",0,"cm",null,{"$f":"IF(K10=\"m\",J10,IF(K10=\"cm\",J10/100,IF(K10=\"mm\",J10/1000,0)))","v":0}]
[null,"Inhoud","l",null,null,null,null,null,"Hoogte",0,"cm",null,{"$f":"IF(K11=\"m\",J11,IF(K11=\"cm\",J11/100,IF(K11=\"mm\",J11/1000,0)))","v":0}]
[null,null,"cl",null,null,null,null,null,null,{"$f":"M12","v":0},"m3",null,{"$f":"IF(K12=\"m3\",M9*M10*M11,(M9*M10*M11*1000000))","v":0}]
[null,null,"ml"]
[null,"Gewicht","kg"]
[null,null,"g"]
[null,null,"mg"]
[null,"Tijd","uur"]
[null,null,"minuut"]
[null,null,"stuk"]