{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Invulschema"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Invulschema","index":0,"n_rows":140,"n_cols":18,"rows_kept":140,"cut":false,"hidden":false,"merged":[[23,14,23,15],[24,14,24,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[20,14,20,15],[5,3,5,11],[6,3,6,11],[7,3,7,11],[21,14,21,15],[22,14,22,15],[13,14,13,15],[14,14,14,15],[12,14,12,15],[11,14,11,15],[15,14,15,15]]}
[null,null,null,null,null,null,null," ",null,null,null,null," "]
[]
[null,null,"SLOOP HULPSCHEMA 2020",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Invulschema!H85","v":"Datum: 4 januari 2021 (week: 2) "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MENU"]
[null,null,"Projectomschrijving "]
[null,null,"Projectnummer "]
[null,null,"Opdrachtgever "]
[]
[null,null," "]
[]
[null,null," SVMS007. materiaal *","vrije tekst","eenheid","R-ladder","fictieve korting \n(€)","minimale eis %","aangeboden %","meerwaarde duurzaamheid (%)","meerwaarde duurzaamheid (€)","gerealiseerd %","Δ %","correctie-\nfactor","malus \n(€)"]
[null,null,"* kies materiaal uit tabel ",null,"* tabel ","* kies uit R-ladder tabel "]
[null," ",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(H14=\"\",\"\",IF(OR(I14<0,I14<H14),\"\",(100-SUMSQ((100-(100*I14))/((100-(100*H14))/10)))/100)),\"\")","v":""},{"$f":"IFERROR(IF(G14=\"\",\"\",J14*G14),\"\")","v":""},null,{"$f":"IFERROR(IF(G14=\"\",\"\",IF(L14=\"\",\"\",IF((I14<0),\"\",IF(I14=\"\",\"\",IF(J14=\"\",\"\",L14-I14))))),\"\")","v":""},{"$f":"IFERROR(IF($M14=\"\",\"\",INDEX($N$58:$N$79,MATCH($M14,$M$58:$M$79,-1))),\"\")","v":""},{"$f":"IFERROR(IF(K14=\"\",\"\",IF(L14=\"\",\"\",N14*G14)),\"\")","v":""}]
[null," ",null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(G15=\"\",\"\",J15*G15),\"\")","v":""},null,{"$f":"IFERROR(IF(G15=\"\",\"\",IF(L15=\"\",\"\",IF((I15<0),\"\",IF(I15=\"\",\"\",IF(J15=\"\",\"\",L15-I15))))),\"\")","v":""},{"$f":"IFERROR(IF($M15=\"\",\"\",INDEX($N$58:$N$79,MATCH($M15,$M$58:$M$79,-1))),\"\")","v":""},{"$f":"IFERROR(IF(K15=\"\",\"\",IF(L15=\"\",\"\",N15*G15)),\"\")","v":""}]
[null,"  ",null,null,null,null,null,null,null,"","",null,"","",""]
[null," ",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(H17=\"\",\"\",IF(OR(I17<0,I17<H17),\"\",(100-SUMSQ((100-(100*I17))/((100-(100*H17))/10)))/100)),\"\")","v":""},"",null,"","",""]
[null," ",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(H18=\"\",\"\",IF(OR(I18<0,I18<H18),\"\",(100-SUMSQ((100-(100*I18))/((100-(100*H18))/10)))/100)),\"\")","v":""},"",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,null,null,"","",null,"","",""]
[null," ",null,null,null,null,null,null,null,"","",null,"","",""]
[]
[null,null,"Totaal:",null,null,null,{"$f":"SUM(G14:G23)","v":0}," "," ",{"$f":"IFERROR(+K25/G25,\"\")","v":""},{"$f":"SUM(K14:K23)","v":0}," "," "," ",{"$f":"SUM(O14:O23)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null," "]
[]
[]
[]
[null,null," "]
[]
[null,null,"Handleiding:","Sla het bestand op onder een eigen naam en vul de algemeen gegevens van het project in"]
[null,null,null,"Kies uit de tabel de materialen voor de EMVI, de minimale eis % met de eenheid"]
[null,null,null,"Vul in: ","- de fictieve korting per materiaal"]
[null,null,null," ","- het aangenoden % om de meerwaarde van de duurzaamheid te berekenen"]
[null,null,null," ","- het gerealiseerde % om de malus te berekenen"]
[]
[]
[]
[]
[null,null,"disclaimer",null,null,null,"SloopCirculair.nl is een instrument van BouwCirculair",null,null,null,null,null,null,"right to copy © 2020 - BouwCirculair"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Invulschema!C90","v":"Versie 1.2 "}]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,null,"tabel",null,null,null,null,null,null,null,null,"tabel"]
[null,null,"Product",null,"Eenheid",null,"R-ladder",null,null,null,null,null,"Δ MKI","correctie-\nfactor"]
[null,null,"1. Beton",null,"m1",null,"R1: Refuse en rethink ",null,null,null,null,null,0,0]
[null,null,"2. Metselwerk",null,"m2",null,"R2: Reduce",null,null,null,null,null,0,0]
[null,null,"3. Asfaltpuin, Asfaltpuin teerhoudend (TAG)",null,"m3",null,"R3: Reuse",null,null,null,null,null," "," "]
[null,null,"4. Mengpuin",null,"stuk",null,"R4: Repair en remanufacture",null,null,null,null,null,-0.01,-0.05]
[null,null,"5. Kalkzandsteen",null,"ton",null,"R5: Recycle - upcycle",null,null,null,null,null," "," "]
[null,null,"6. Gipshoudend materiaal",null," ",null,"R5: Recycle - downcycle",null,null,null,null,null,-0.02,-0.1]
[null,null,"7. Gasbeton",null,null,null,"R6: Recover"," ",null,null,null,null," "," "]
[null,null,"8. A-hout",null,null,null," "," ",null,null,null,null,-0.03,-0.15]
[null,null,"9. B- hout",null,null,null," "," ",null,null,null,null," "," "]
[null,null,"10. C-Hout",null,null,null," "," ",null,null,null,null,-0.04,-0.2]
[null,null,"11. Non-ferromagnetische metalen (Aluminium, Koper, Lood, Zink, Brons, Messing, Tin)",null,null,null," "," ",null,null,null,null," "," "]
[null,null,"12. Ferromagnetische metalen (IJzer, staal)",null,null,null," "," ",null,null,null,null,-0.05,-0.25]
[null,null,"13. Glas",null,null,null," "," ",null,null,null,null," "," "]
[null,null,"14. Vloerbedekking nylon (PA), zeil (PVC)",null,null,null," "," ",null,null,null,null,-0.06,-0.3]
[null,null,"15. Isolatiemateriaal Steenwol, Glaswol, Polystyreen (PS), Polyurethaan (PUR)",null,null,null," "," ",null,null,null,null," "," "]
[null,null,"16. Dakbedekking bitumineus",null,null,null," "," ",null,null,null,null,-7.0000000000000007E-2,-0.35]
[null,null,"17. Dakbedekking teerhoudend",null,null,null," "," ",null,null,null,null," "," "]
[null,null,"18. Gemengd bouw- en sloopafval",null,null,null," "," ",null,null,null,null,-0.08,-0.4]
[null,null,"19. Kunststoffen",null,null,null," "," ",null,null,null,null," "," "]
[null,null,"20. Groen afval",null,null,null," "," ",null,null,null,null,-0.09,-0.45]
[null,null,"99. Overig",null,null,null," "," ",null,null,null,null," "," "]
[null,null,null,null,null,null," "," ",null,null,null,null,-0.1,-0.5]
[null,null," ",null,null,null," "," ",null,null,null,null," "," "]
[null,null," ",null,null,null," "," "]
[]
[]
[]
[null,null,"DATUM",null,null,null,"WEEK",{"$f":"\"Datum: \"&TEXT(WERKDATUM,\"d;@\")&TEXT(WERKDATUM,\" mmmm \")&YEAR(WERKDATUM)&\" (week: \"&WEEKNUM(WERKDATUM)&\") \"","v":"Datum: 4 januari 2021 (week: 2) "}]
[null,null,{"$f":"TODAY()","v":"2021-01-04"},null,null,null,{"$f":"WEEKNUM(WERKDATUM)","v":2}]
[]
[]
[null,null,"VERSIEBEHEER"]
[null,null,"Versie 1.2 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1. Beton",null,null,"1. A-hout"]
[null,null,"2. Metselwerk",null,null,"2. Asfaltpuin, Asfaltpuin teerhoudend (TAG)"]
[null,null,"3. Asfaltpuin, Asfaltpuin teerhoudend (TAG)",null,null,"3. Beton"]
[null,null,"4. Mengpuin",null,null,"4. B- hout"]
[null,null,"5. Kalkzandsteen",null,null,"5. C-Hout"]
[null,null,"6. Gipshoudend materiaal",null,null,"6. Dakbedekking bitumineus"]
[null,null,"7. Gasbeton",null,null,"7. Dakbedekking teerhoudend"]
[null,null,"8. A-hout",null,null,"8. Ferromagnetische metalen (IJzer, staal)"]
[null,null,"9. B- hout",null,null,"9. Gasbeton"]
[null,null,"10. C-Hout",null,null,"10. Gemengd bouw- en sloopafval"]
[null,null,"11. Non-ferromagnetische metalen (Aluminium, Koper, Lood, Zink, Brons, Messing, Tin)",null,null,"11. Gipshoudend materiaal"]
[null,null,"12. Ferromagnetische metalen (IJzer, staal)",null,null,"12. Glas"]
[null,null,"13. Glas",null,null,"13. Groen afval"]
[null,null,"14. Vloerbedekking nylon (PA), zeil (PVC)",null,null,"14. Isolatiemateriaal Steenwol, Glaswol, Polystyreen (PS), Polyurethaan (PUR)"]
[null,null,"15. Isolatiemateriaal Steenwol, Glaswol, Polystyreen (PS), Polyurethaan (PUR)",null,null,"15. Kalkzandsteen"]
[null,null,"16. Dakbedekking bitumineus",null,null,"16. Kunststoffen"]
[null,null,"17. Dakbedekking teerhoudend",null,null,"17. Mengpuin"]
[null,null,"18. Gemengd bouw- en sloopafval",null,null,"18. Metselwerk"]
[null,null,"19. Kunststoffen",null,null,"19. Non-ferromagnetische metalen (Aluminium, Koper, Lood, Zink, Brons, Messing, Tin)"]
[null,null,"20. Groen afval",null,null,"20. Vloerbedekking nylon (PA), zeil (PVC)"]
[null,null,"99. Overig",null,null,"99. Overig"]