{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Uitleg","Materialen","Isolatie","Totaal score"],"not_rendered":{"charts":0,"images":101,"macros":1,"external_links":3,"defined_names":187,"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":"Uitleg","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,2,34,9],[15,2,15,8],[16,2,16,8],[17,2,17,8],[31,2,31,9],[24,2,24,3],[24,4,24,9],[25,2,25,3],[25,4,25,9],[22,2,22,9],[11,2,11,8],[10,2,10,8],[35,2,35,9],[9,7,9,8],[27,1,27,6],[27,7,27,8],[33,7,33,8],[29,2,29,9],[30,2,30,9],[23,2,23,9],[19,2,19,8],[28,2,28,9],[14,2,14,8]]}
[]
[null,null,null,null,null,null,null,null,"BREEAM-NL Nieuwbouw"]
[]
[null,null,null,null,null,null,null,null,"Uitleg"]
[]
[null,null,null,null,null,null,null,null,"BRL 2014 v1.01 - MAT 5: rekentool"]
[]
[null,"Let op: deze rekentool MAT 5 is t.b.v de BRL 2014 v1.xx. Voor voorgaande versie van de BRL is een andere rekentool beschikbaar op www.breeam.nl"]
[]
[null,"Berekening procedure voor de bouwmaterialen van de hoofdbouwdelen (A-F) op tabblad ''Materialen''"]
[null,"1.","Kies uit de lijst van opties in het drop-down box per hoofdbouwdeel het aantal elementen dat u wilt invoeren en klik daarna op de Select-knop."]
[null,null,"Indien het hoofdbouwdeel niet aanwezig is selecteert u '0 '. "]
[]
[null,"Door de gebruiker gedefinieerde element - volume"]
[null," a. ","Voor alle aanwezige elementen, de namen van het materiaal soorten in de desbetreffende cel van de kolom 'materiaal types'."]
[null," b. ","Vul het volume van elke afzonderlijke soort materiaal in de desbetreffende cel van de kolom 'volume van relevante materialen aanwezig'."]
[null," c. ","Voer het totale volume van het materiaal soorten in de cel 'totaal volume element'."]
[null," d. ","Vul het volume van elk materiaal dat voldoet aan ofwel Tier 1, 2, 3 of 4, naargelang het geval. Ten minste 80% van het totale volume moeten voldoen aan een of meer Tiers om punten voor het element te krijgen."]
[]
[null,"4.","Zodra alle gegevens correct zijn ingevoerd en in overeenstemming met de eisen, zal het programma het totaal aantal behaalde punten berekenen en dit vertalen naar het aantal toe te kennen credits."]
[]
[null,"De volgende schaal wordt gebruikt om credits voor de bouwmaterialen bij nieuwbouw en grote renovatieprojecten:"]
[null,"a. ","15 punten - 4 credits (of 3 credits op basis van alle materialen en 1 credit gebaseerd voor isolatiemateriaal)"]
[null,"b.","11,25 punten - 3 credits"]
[null,"c.","7,5 punten - 2 credits",null,"Opmerking: Het aantal benodigde punten is afhankelijk van het aantal ingevoerde hoofdbouwdelen"]
[null,"d.","3,75 punten - 1 credit",null,"Deze rekentool berekent automatisch het aantal benodigde punten in het tabblad 'Materialen'"]
[]
[null,"Berekening procedure voor de isolatiematerialen op tabblad \"Isolatie\""]
[null,"1. ","Vul de oppervlakte en dikte van de verschillende isolatiematerialen toegepast in de bouwkundige (gebouw envelope)."]
[null,"2. ","Vul de geschatte omvang van isolatiematerialen gebruikt voor de installatie (bv. isolatie van de leidingen)."]
[null,"3. ","Gebruik de dropbox om te selecteren hoe de Tier overeenstemming wordt vastgesteld, op basis van volume of % van isolatiematerialen.       "]
[null,"4. ","Vul het % of volume van elk isolatiemateriaal gebruikt is dat compatibel is met de verantwoordelijke herkomst Tier niveau 1, 2 of 3."]
[]
[null,"De algemene Mat 5 score"]
[null,null,"De \"Totaal score\" tabblad toont het totaal aantal toegekende Mat 5 credits. "]
[null,null,"Let op: MAT 5 vereist tevens dat 100% van het gebruikt hout duurzaam is geproduceerd, zie de criteria-eisen in de beoordelinsgrichtlijn."]

{"sheet":"Materialen","index":1,"n_rows":480,"n_cols":20,"rows_kept":480,"cut":false,"hidden":false,"merged":[[120,12,127,13],[143,6,144,6],[119,12,119,13],[281,2,288,3],[127,7,127,9],[186,12,193,13],[185,2,192,3],[213,4,213,5],[281,11,289,11],[269,3,269,13],[239,12,239,13],[247,4,247,5],[267,7,267,9],[215,3,215,13],[226,3,226,13],[181,7,181,9],[162,11,170,11],[151,11,159,11],[159,7,159,9],[139,7,139,9],[162,12,162,13],[174,12,181,13],[118,3,118,13],[151,12,151,13],[131,2,138,3],[444,12,451,13],[432,12,432,13],[443,2,450,3],[451,7,451,9],[442,3,442,13],[451,4,451,5],[443,11,451,11],[440,7,440,9],[440,4,440,5],[433,12,440,13],[432,11,440,11],[292,3,292,13],[312,3,312,13],[301,7,301,9],[305,6,306,6],[347,2,354,3],[322,2,322,4],[294,12,301,13],[324,12,324,13],[401,11,417,11],[173,12,173,13],[293,2,300,3],[324,11,332,11],[335,11,343,11],[301,4,301,5],[345,2,345,4],[346,3,346,13],[314,12,321,13],[343,7,343,9],[336,12,343,13],[323,3,323,13],[334,3,334,13],[335,12,335,13],[321,4,321,5],[343,4,343,5],[313,2,320,3],[313,12,313,13],[311,2,311,4],[335,2,342,3],[321,7,321,9],[324,2,331,3],[400,3,400,13],[333,2,333,4],[387,2,387,4],[375,7,375,9],[347,12,347,13],[332,4,332,5],[325,12,332,13],[366,3,366,13],[368,12,375,13],[388,3,388,13],[379,12,386,13],[376,2,376,4],[377,3,377,13],[378,11,386,11],[378,2,385,3],[367,2,374,3],[344,2,344,4],[375,4,375,5],[386,4,386,5],[359,6,360,6],[1,12,1,13],[3,12,3,13],[5,12,5,13],[441,2,441,4],[398,2,398,4],[432,2,439,3],[409,7,409,9],[401,2,408,3],[332,7,332,9],[24,12,31,13],[77,12,77,13],[78,12,85,13],[96,3,96,13],[95,2,95,4],[35,6,36,6],[97,2,104,3],[98,12,105,13],[42,3,42,13],[53,3,53,13],[105,4,105,5],[270,11,278,11],[278,7,278,9],[108,12,108,13],[127,4,127,5],[151,2,158,3],[203,2,203,4],[205,12,205,13],[278,4,278,5],[270,2,277,3],[257,2,257,4],[258,3,258,13],[171,2,171,4],[236,2,236,4],[247,7,247,9],[268,2,268,4],[239,2,246,3],[260,12,267,13],[259,11,267,11],[63,2,63,4],[51,4,51,5],[170,4,170,5],[85,4,85,5],[129,2,129,4],[159,4,159,5],[161,3,161,13],[65,12,65,13],[108,2,115,3],[51,7,51,9],[160,2,160,4],[62,7,62,9],[54,11,62,11],[119,11,127,11],[106,2,106,4],[107,3,107,13],[109,12,116,13],[108,11,116,11],[130,3,130,13],[150,3,150,13],[116,7,116,9],[131,12,131,13],[132,12,139,13],[97,11,105,11],[117,2,117,4],[116,4,116,5],[73,4,73,5],[217,12,224,13],[193,7,193,9],[213,7,213,9],[206,12,213,13],[205,11,213,11],[170,7,170,9],[193,4,193,5],[185,12,185,13],[197,6,198,6],[181,4,181,5],[204,3,204,13],[173,11,181,11],[182,2,182,4],[216,11,224,11],[184,3,184,13],[97,12,97,13],[119,2,126,3],[214,2,214,4],[163,12,170,13],[152,12,159,13],[172,3,172,13],[16,12,18,12],[16,13,18,13],[259,12,259,13],[23,11,39,11],[54,12,54,13],[224,7,224,9],[162,2,169,3],[21,2,21,4],[74,2,74,4],[52,2,52,4],[54,2,61,3],[22,3,22,13],[43,11,51,11],[43,12,43,13],[31,7,31,9],[41,2,41,4],[23,12,23,13],[55,12,62,13],[23,2,30,3],[44,12,51,13],[105,7,105,9],[128,2,128,4],[173,2,180,3],[43,2,50,3],[413,6,414,6],[399,2,399,4],[389,12,389,13],[429,7,429,9],[409,4,409,5],[419,2,419,4],[420,3,420,13],[402,12,409,13],[216,2,223,3],[227,12,227,13],[225,2,225,4],[227,11,235,11],[290,2,290,4],[267,4,267,5],[251,6,252,6],[238,3,238,13],[240,12,247,13],[271,12,278,13],[270,12,270,13],[279,2,279,4],[281,12,281,13],[280,3,280,13],[228,12,235,13],[235,7,235,9],[479,14,480,14],[479,4,480,7],[479,8,480,8],[477,4,477,7],[421,2,428,3],[429,4,429,5],[421,11,429,11],[430,2,430,4],[431,3,431,13],[443,12,443,13],[422,12,429,13],[421,12,421,13],[452,2,452,4],[289,7,289,9],[62,4,62,5],[65,2,72,3],[64,3,64,13],[65,11,73,11],[73,7,73,9],[66,12,73,13],[401,12,401,13],[355,7,355,9],[367,12,367,13],[355,4,355,5],[348,12,355,13],[378,12,378,13],[365,2,365,4],[389,11,397,11],[367,11,375,11],[389,2,396,3],[397,7,397,9],[386,7,386,9],[397,4,397,5],[347,11,363,11],[390,12,397,13],[149,2,149,4],[139,4,139,5],[31,4,31,5],[313,11,321,11],[259,2,266,3],[75,2,75,4],[85,7,85,9],[77,2,84,3],[77,11,93,11],[76,3,76,13],[89,6,90,6],[183,2,183,4],[282,12,289,13],[293,12,293,13],[237,2,237,4],[205,2,212,3],[227,2,234,3],[224,4,224,5],[235,4,235,5],[216,12,216,13],[131,11,147,11],[185,11,201,11],[239,11,255,11],[293,11,309,11],[291,2,291,4],[289,4,289,5],[20,2,20,4],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[17,8,18,8],[14,9,14,10],[16,7,16,10],[16,6,18,6],[16,2,18,3],[16,4,18,5],[17,10,18,10],[17,7,18,7],[17,9,18,9],[14,3,14,5],[12,3,12,5],[19,2,19,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"BRL-2010 v2.0"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Materialen"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAT 5 - rekentool"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maak keuze in gebouwtypen:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kantoren",null,"Maak keuze in assessment"]
[null,null,null,null,null,null,null,null,null,"Elementen aanwezig:",null,null,{"$f":"IF(asstype=1,\"\",D457)","v":0},null,null,null,"Retail",null,"Nieuwbouw"]
[null,null,"Assessment type:","Nieuwbouw en/of renovatie",null,null,null,null,null,"Credits beschikbaar",null,null,"Punten benodigd",null,null,null,"Industriele gebouwen"]
[null,null,null,null,null,null,null,null,null,1,null,null,{"$f":"G461","v":0},null,null,null,"Scholen "]
[null,null,"Gebouwnaam:","….",null,null,null,null,null,2,null,null,{"$f":"G462","v":0},null,null,null,"Woningen",null,2]
[null,null,null,null,null,null,null,null,null,3,null,null,{"$f":"G463","v":0}]
[null,null,"Registratienummer:","….",null,null,null,null,null,4,null,null,{"$f":"G464","v":0}]
[]
[null,null,"Element",null,"Materiaal types",null,"Volume van relevante materialen aanwezig","Volume van materialen in overeenstemming met Tier niveau",null,null,null,null,"% van totaal welke overeenkomt met Tier 1-4          (min. 80%)","Totaal Punten / Element"]
[null,null,null,null,null,null,null,"Tier 1         ","Tier 2","Tier 3","Tier 4",null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,3,2,1.5,1]
[null,null,"HOOFDBOUWDEEL A",null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T25=1,K32=\"\"),0,IF(OR(NOT(C24=\"\")),0,IF(ISERROR(M33),\"0\",M33)))","v":0},{"$f":"N33","v":0},null,{"$f":"0","v":0},{"$f":"IF(asstype=2,0,1)","v":0}]
[null,null,"ELEMENT 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq1>=3,0,1)","v":1},0,null,"Please select amount required:","Volume"]
[null,null,null,{"$f":"IF(AND(O33>=1,type1=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O33>=1,type1=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,0,null,0,"Percentage"]
[null,null,{"$f":"IF(SUM(G24:G31)=0,\"\",IF(T25=1,IF(T25+K32=1,\"Voer totaal volume element in\",IF((T25+G32+K32)=1,\"Voer totaal volume element in\",IF(ISERROR(C33),\"Voer totaal volume element in\",IF(OR(G24>K32,G25>K32,G26>K32,G27>K32,G28>K32,G29>K32,G30>K32,G31>K32),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G24:G31)>K32,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T25=2,IF(SUM(G24:G31)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G24>100,G25>100,G26>100,G27>100,G28>100,G29>100,G30>100,G31>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G24:G31)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H40+I40+J40+K40)>=3,3,SUM(H40+I40+J40+K40))","v":0},null,null,{"$f":"IF(SUM(H24:K24)>G24,\"1\",\"0\")","v":"0"},1,0,null,1]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T25=1,K32=\"\"),C24,+IF(G33>(K32+K52+K63+K74),C24,(IF(M33<80,\"geen punten, totaal is < 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H25:K25)>G25,\"1\",\"0\")","v":"0"},1,0,null,2,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,0,null,3]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,0,null,4,{"$f":"IF(freq1=3,1,IF(freq1=4,2,IF(freq1=5,3,IF(freq1=6,4,1))))","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,0,null,2]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Totaal % type element beoordeeld",null,{"$f":"IFERROR(SUM(H24:K31)/K32,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,0]
[null,null,{"$f":"IF(G32=0,\"0\",IF(T25=2,\"0\",IF(T25=1,(G32/100)*100,IF(T25=2,(G32/100)*100))))","v":0},{"$f":"G32","v":"0"},null,"Total",{"$f":"IF(SUM(K32,K52,K63,K74)=0,\"1\",SUM(K32,K52,K63,K74))","v":"1"},{"$f":"SUM(H24:H31,H44:H51,H55:H62,H66:H73)","v":0},{"$f":"SUM(I24:I31,I44:I51,I55:I62,I66:I73)","v":0},{"$f":"SUM(J24:J31,J44:J51,J55:J62,J66:J73)","v":0},{"$f":"SUM(K24:K31,K44:K51,K55:K62,K66:K73)","v":0},null,{"$f":"SUM(H34:K34)","v":0},{"$f":"IF(M21<80,0,IF(O33>0,0,IF(M21>100,0,IF(M21>=80,L24,IF(M21<80,0)))))","v":0},{"$f":"O24+O25+O26+O27+O28+O29+O30+O31","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H33+G33=0,\"0\",(H33/G33)*100)","v":0},{"$f":"IF(I33+G33=0,\"0\",(I33/G33)*100)","v":0},{"$f":"IF(J33+G33=0,\"0\",(J33/G33)*100)","v":0},{"$f":"IF(K33+G33=0,\"0\",(K33/G33)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T25=1,((G33/100)*80))","v":0.8},"% of 80",{"$f":"(H34/80)*100","v":0},{"$f":"(I34/80)*100","v":0},{"$f":"(J34/80)*100","v":0},{"$f":"(K34/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H35>100,\"100\",H35)","v":0},{"$f":"IF(I35>100,\"100\",I35)","v":0},{"$f":"IF(J35>100,\"100\",J35)","v":0},{"$f":"IF(K35>100,\"100\",K35)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H36+I36+J36+K36=0,0,100-(H36))","v":0},{"$f":"IF(I36+H36+J36+K36=0,0,100-(I36+H36))","v":0},{"$f":"IF(J36+I36+H36+K36=0,0,100-(H36+J36+I36))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I36>I37,I37,I36)","v":0},{"$f":"IF(J36>J37,J37,J36)","v":0},{"$f":"IF(K36>K37,K37,K36)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J38+I36+H36>=100,0,K38)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H33=0,0,0.01*(H36*H41))","v":0},{"$f":"IF(I33=0,0,0.01*(I38*I41))","v":0},{"$f":"IF(J33=0,0,0.01*(J38*J41))","v":0},{"$f":"IF(K33=0,0,0.01*(K39*K41))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,"Total",null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq1>=4,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume "]
[null,null,null,{"$f":"IF(AND(O52>=1,type2=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O52>=1,type2=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G44:G51)=0,\"\",IF(T45=1,IF(T45+K52=1,\"Voer totaal volume element in\",IF((T45+G52+K52)=1,\"Voer totaal volume element in\",IF(ISERROR(C33),\"Voer totaal volume element in\",IF(OR(G44>K52,G45>K52,G46>K52,G47>K52,G48>K52,G49>K52,G50>K52,G51>K52),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G44:G51)>K52,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T45=2,IF(SUM(G44:G51)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G44>100,G45>100,G46>100,G47>100,G48>100,G49>100,G50>100,G51>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G44:G51)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H44:K44)>G44,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H45:K45)>G45,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % type element beoordeeld",null,{"$f":"IFERROR(SUM(H44:K51)/SUM(K52),\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O44+O45+O46+O47+O48+O49+O50+O51","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq1>=5,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume "]
[null,null,null,{"$f":"IF(AND(O63>=1,type3=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O63>=1,type3=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G55:G62)=0,\"\",IF(T56=1,IF(T56+K63=1,\"Voer totaal volume element in\",IF((T56+G63+K63)=1,\"Voer totaal volume element in\",IF(ISERROR(C33),\"Voer totaal volume element in\",IF(OR(G55>K63,G56>K63,G57>K63,G58>K63,G59>K63,G60>K63,G61>K63,G62>K63),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G55:G62)>K63,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T56=2,IF(SUM(G55:G62)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G55>100,G56>100,G57>100,G58>100,G59>100,G60>100,G61>100,G62>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G55:G62)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H55:K55)>G55,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H56:K56)>G56,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % type element beoordeeld",null,{"$f":"IFERROR(SUM(H55:K62)/SUM(K63),\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O55+O56+O57+O58+O59+O60+O61+O62","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq1>=6,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O74>=1,type4=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O74>=1,type4=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G66:G73)=0,\"\",IF(T67=1,IF(T67+K74=1,\"Voer totaal volume element in\",IF((T67+G74+K74)=1,\"Voer totaal volume element in\",IF(ISERROR(C33),\"Voer totaal volume element in\",IF(OR(G66>K74,G67>K74,G68>K74,G69>K74,G70>K74,G71>K74,G72>K74,G73>K74),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G66:G73)>K74,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T67=2,IF(SUM(G66:G73)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G66>100,G67>100,G68>100,G69>100,G70>100,G71>100,G72>100,G73>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G66:G73)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H66:K66)>G66,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H67:K67)>G67,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % type element beoordeeld",null,{"$f":"IFERROR(SUM(H66:K73)/SUM(K74),\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O66+O67+O68+O69+O70+O71+O72+O73","v":0},1,{"$f":"1","v":1}]
[null,null,"HOOFDBOUWDEEL B",null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T78=1,K86=\"\"),0,IF(OR(NOT(C77=\"\")),0,IF(ISERROR(M87),\"0\",M87)))","v":0},{"$f":"N87","v":0},null,{"$f":"0","v":0},{"$f":"IF(asstype=2,0,1)","v":0},null,"Please select amount required:","Volume"]
[null,null,"ELEMENT 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq2>=3,0,1)","v":1},0,null,0,"Percentage"]
[null,null,null,{"$f":"IF(AND(O87>=1,type5=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O87>=1,type5=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq2>=3,0,1)","v":1},0,null,1]
[null,null,{"$f":"IF(SUM(G78:G85)=0,\"\",IF(T78=1,IF(T78+K86=1,\"Voer totaal volume element in\",IF((T78+G86+K86)=1,\"Voer totaal volume element in\",IF(ISERROR(C87),\"Voer totaal volume element in\",IF(OR(G78>K86,G79>K86,G80>K86,G81>K86,G82>K86,G83>K86,G84>K86,G85>K86),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G78:G85)>K86,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T78=2,IF(SUM(G78:G85)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G78>100,G79>100,G80>100,G81>100,G82>100,G83>100,G84>100,G85>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G78:G85)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H94+I94+J94+K94)>=3,3,SUM(H94+I94+J94+K94))","v":0},null,null,{"$f":"IF(SUM(H78:K78)>G78,\"1\",\"0\")","v":"0"},{"$f":"IF(freq2>=3,0,1)","v":1},0,null,2,1]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T79=1,K86=\"\"),C78,+IF(G87>K86,C78,(IF(M87<80,\"geen punten,totaal is\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H79:K79)>G79,\"1\",\"0\")","v":"0"},{"$f":"IF(freq2>=3,0,1)","v":1},0,null,3]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",{"$f":"IF(freq2>=3,0,1)","v":1},0,null,4,{"$f":"IF(freq2=3,1,IF(freq2=4,2,IF(freq2=5,3,IF(freq2=6,4,1))))","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,0,null,2]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H78:K85)/K86,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,0]
[null,null,{"$f":"IF(G86=0,\"0\",IF(T78=2,\"0\",IF(T78=1,(G86/100)*100,IF(T78=2,(G86/100)*100))))","v":0},{"$f":"G86","v":"0"},null,"Total",{"$f":"IF(SUM(K86,K106,K117,K128)=0,\"1\",SUM(K86,K106,K117,K128))","v":"1"},{"$f":"SUM(H78:H85,H98:H105,H109:H116,H120:H127)","v":0},{"$f":"SUM(I78:I85,I98:I105,I109:I116,I120:I127)","v":0},{"$f":"SUM(J78:J85,J98:J105,J109:J116,J120:J127)","v":0},{"$f":"SUM(K78:K85,K98:K105,K109:K116,K120:K127)","v":0},null,{"$f":"SUM(H88:K88)","v":0},{"$f":"IF(M75<80,0,IF(O87>0,0,IF(M75>100,0,IF(M75>=80,L78,IF(M75<80,0)))))","v":0},{"$f":"O78+O79+O80+O81+O82+O83+O84+O85","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H87+G87=0,\"0\",(H87/G87)*100)","v":0},{"$f":"IF(I87+G87=0,\"0\",(I87/G87)*100)","v":0},{"$f":"IF(J87+G87=0,\"0\",(J87/G87)*100)","v":0},{"$f":"IF(K87+G87=0,\"0\",(K87/G87)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T79=1,((G87/100)*80))","v":false},"% of 80",{"$f":"(H88/80)*100","v":0},{"$f":"(I88/80)*100","v":0},{"$f":"(J88/80)*100","v":0},{"$f":"(K88/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H89>100,\"100\",H89)","v":0},{"$f":"IF(I89>100,\"100\",I89)","v":0},{"$f":"IF(J89>100,\"100\",J89)","v":0},{"$f":"IF(K89>100,\"100\",K89)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H90+I90+J90+K90=0,0,100-(H90))","v":0},{"$f":"IF(I90+H90+J90+K90=0,0,100-(I90+H90))","v":0},{"$f":"IF(J90+I90+H90+K90=0,0,100-(H90+J90+I90))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I90>I91,I91,I90)","v":0},{"$f":"IF(J90>J91,J91,J90)","v":0},{"$f":"IF(K90>K91,K91,K90)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J92+I90+H90>=100,0,K92)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H87=0,0,0.01*(H90*H95))","v":0},{"$f":"IF(I87=0,0,0.01*(I92*I95))","v":0},{"$f":"IF(J87=0,0,0.01*(J92*J95))","v":0},{"$f":"IF(K87=0,0,0.01*(K93*K95))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,"Total",null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq2>=4,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O106>=1,type6=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O106>=1,type6=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G98:G105)=0,\"\",IF(T99=1,IF(T99+K106=1,\"Voer totaal volume element in\",IF((T99+G106+K106)=1,\"Voer totaal volume element in\",IF(ISERROR(C87),\"Voer totaal volume element in\",IF(OR(G98>K106,G99>K106,G100>K106,G101>K106,G102>K106,G103>K106,G104>K106,G105>K106),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G98:G105)>K106,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T99=2,IF(SUM(G98:G105)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G98>100,G99>100,G100>100,G101>100,G102>100,G103>100,G104>100,G105>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G98:G105)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H98:K98)>G98,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H99:K99)>G99,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",{"$f":"IF(freq2>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",{"$f":"IF(freq2>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",{"$f":"IF(freq2>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",{"$f":"IF(freq2>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H98:K105)/K106,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O98+O99+O100+O101+O102+O103+O104+O105","v":0},{"$f":"IF(freq2>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq2>=5,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O117>=1,type7=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O117>=1,type7=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G109:G116)=0,\"\",IF(T110=1,IF(T110+K117=1,\"Voer totaal volume element in\",IF((T110+G117+K117)=1,\"Voer totaal volume element in\",IF(ISERROR(C87),\"Voer totaal volume element in\",IF(OR(G109>K117,G110>K117,G111>K117,G112>K117,G113>K117,G114>K117,G115>K117,G116>K117),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G109:G116)>K117,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T110=2,IF(SUM(G109:G116)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G109>100,G110>100,G111>100,G112>100,G113>100,G114>100,G115>100,G116>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G109:G116)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H109:K109)>G109,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H110:K110)>G110,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",{"$f":"IF(freq2>=5,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",{"$f":"IF(freq2>=5,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H109:K116)/K117,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O109+O110+O111+O112+O113+O114+O115+O116","v":0},{"$f":"IF(freq2>=5,0,1)","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq2>=6,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O128>=1,type8=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O128>=1,type8=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G120:G127)=0,\"\",IF(T121=1,IF(T121+K128=1,\"Voer totaal volume element in\",IF((T121+G128+K128)=1,\"Voer totaal volume element in\",IF(ISERROR(C87),\"Voer totaal volume element in\",IF(OR(G120>K128,G121>K128,G122>K128,G123>K128,G124>K128,G125>K128,G126>K128,G127>K128),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G120:G127)>K128,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T121=2,IF(SUM(G120:G127)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G120>100,G121>100,G122>100,G123>100,G124>100,G125>100,G126>100,G127>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G120:G127)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H120:K120)>G120,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H121:K121)>G121,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H120:K127)/K128,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O120+O121+O122+O123+O124+O125+O126+O127","v":0},1,{"$f":"1","v":1}]
[null,null,"HOOFDBOUWDEEL C",null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T133=1,K140=\"\"),0,IF(OR(NOT(C131=\"\")),0,IF(ISERROR(M141),0,M141)))","v":0},{"$f":"N141","v":0},null,{"$f":"IF(freq3>=3,0,1)","v":1},{"$f":"IF(asstype=2,0,1)","v":0},null,"Please select amount required;"]
[null,null,"ELEMENT 1",null,null,null,null,null,null,null,null,null,null,null,null,1,0,null,0,"Volume"]
[null,null,"",{"$f":"IF(AND(O141>=1,type9=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O141>=1,type9=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,0,null,2,"Percentage"]
[null,null,{"$f":"IF(SUM(G132:G139)=0,\"\",IF(T133=1,IF(T133+K140=1,\"Voer totaal volume element in\",IF((T133+G140+K140)=1,\"Voer totaal volume element in\",IF(ISERROR(C141),\"Voer totaal volume element in\",IF(OR(G132>K140,G133>K140,G134>K140,G135>K140,G136>K140,G137>K140,G138>K140,G139>K140),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G132:G139)>K140,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T133=2,IF(SUM(G132:G139)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G132>100,G133>100,G134>100,G135>100,G136>100,G137>100,G138>100,G139>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G132:G139)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H148+I148+J148+K148)>=3,3,SUM(H148+I148+J148+K148))","v":0},null,null,{"$f":"IF(SUM(H132:K132)>G132,\"1\",\"0\")","v":"0"},1,0,null,3]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T133=1,K140=\"\"),C132,+IF(G141>K140,C132,(IF(M141<80,\"geen punten, totaal is\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H133:K133)>G133,\"1\",\"0\")","v":"0"},1,0,null,4,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H134:K134)>G134,\"1\",\"0\")","v":"0"},1,0]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,0,null,null,{"$f":"IF(freq3=3,1,IF(freq3=4,2,IF(freq3=5,3,IF(freq3=6,4,1))))","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,0,null,2]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H132:K139)/K140,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,0]
[null,null,{"$f":"IF(G140=0,\"0\",IF(OR(T133=1,T133=3),\"0\",IF(T133=2,(G140/100)*100,IF(OR(T133=1,T133=3),(G140/100)*100))))","v":"0"},{"$f":"G140","v":"0"},null,"Total",{"$f":"IF(SUM(K140,K160,K171,K182)=0,\"1\",SUM(K140,K160,K171,K182))","v":"1"},{"$f":"SUM(H132:H139,H152:H159,H163:H170,H174:H181)","v":0},{"$f":"SUM(I132:I139,I152:I159,I163:I170,I174:I181)","v":0},{"$f":"SUM(J132:J139,J152:J159,J163:J170,J174:J181)","v":0},{"$f":"SUM(K132:K139,K152:K159,K163:K170,K174:K181)","v":0},null,{"$f":"SUM(H142:K142)","v":0},{"$f":"IF(M129<80,0,IF(O141>0,0,IF(M129>100,0,IF(M129>=80,L132,IF(M129<80,0)))))","v":0},{"$f":"O132+O133+O134+O135+O136+O137+O138+O139","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H141+G141=0,\"0\",(H141/G141)*100)","v":0},{"$f":"IF(I141+G141=0,\"0\",(I141/G141)*100)","v":0},{"$f":"IF(J141+G141=0,\"0\",(J141/G141)*100)","v":0},{"$f":"IF(K141+G141=0,\"0\",(K141/G141)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T133=2,((G141/100)*80))","v":false},"% of 80",{"$f":"(H142/80)*100","v":0},{"$f":"(I142/80)*100","v":0},{"$f":"(J142/80)*100","v":0},{"$f":"(K142/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H143>100,\"100\",H143)","v":0},{"$f":"IF(I143>100,\"100\",I143)","v":0},{"$f":"IF(J143>100,\"100\",J143)","v":0},{"$f":"IF(K143>100,\"100\",K143)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H144+I144+J144+K144=0,0,100-(H144))","v":0},{"$f":"IF(I144+H144+J144+K144=0,0,100-(I144+H144))","v":0},{"$f":"IF(J144+I144+H144+K144=0,0,100-(H144+J144+I144))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I144>I145,I145,I144)","v":0},{"$f":"IF(J144>J145,J145,J144)","v":0},{"$f":"IF(K144>K145,K145,K144)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J146+I144+H144>=100,0,K146)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H141=0,0,0.01*(H144*H149))","v":0},{"$f":"IF(I141=0,0,0.01*(I146*I149))","v":0},{"$f":"IF(J141=0,0,0.01*(J146*J149))","v":0},{"$f":"IF(K141=0,0,0.01*(K147*K149))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq3>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,{"$f":"IF(AND(O160>=1,type10=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O160>=1,type10=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Volume"]
[null,null,{"$f":"IF(SUM(G152:G159)=0,\"\",IF(T154=1,IF(T154+K160=1,\"Voer totaal volume element in\",IF((T154+G160+K160)=1,\"Voer totaal volume element in\",IF(ISERROR(C141),\"Voer totaal volume element in\",IF(OR(G152>K160,G153>K160,G154>K160,G155>K160,G156>K160,G157>K160,G158>K160,G159>K160),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G152:G159)>K160,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T154=2,IF(SUM(G152:G159)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G152>100,G153>100,G154>100,G155>100,G156>100,G157>100,G158>100,G159>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G152:G159)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H152:K152)>G152,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H153:K153)>G153,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H152:K159)/K160,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O152+O153+O154+O155+O156+O157+O158+O159","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq3>=5,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,{"$f":"IF(AND(O171>=1,type11=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O171>=1,type11=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Volume"]
[null,null,{"$f":"IF(SUM(G163:G170)=0,\"\",IF(T165=1,IF(T165+K171=1,\"Voer totaal volume element in\",IF((T165+G171+K171)=1,\"Voer totaal volume element in\",IF(ISERROR(C141),\"Voer totaal volume element in\",IF(OR(G163>K171,G164>K171,G165>K171,G166>K171,G167>K171,G168>K171,G169>K171,G170>K171),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G163:G170)>K171,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T165=2,IF(SUM(G163:G170)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G163>100,G164>100,G165>100,G166>100,G167>100,G168>100,G169>100,G170>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G163:G170)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H163:K163)>G163,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H164:K164)>G164,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H163:K170)/K171,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O163+O164+O165+O166+O167+O168+O169+O170","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq3>=6,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O182>=1,type12=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O182>=1,type12=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G174:G181)=0,\"\",IF(T176=1,IF(T176+K182=1,\"Voer totaal volume element in\",IF((T176+G182+K182)=1,\"Voer totaal volume element in\",IF(ISERROR(C141),\"Voer totaal volume element in\",IF(OR(G174>K182,G175>K182,G176>K182,G177>K182,G178>K182,G179>K182,G180>K182,G181>K182),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G174:G181)>K182,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T176=2,IF(SUM(G174:G181)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G174>100,G175>100,G176>100,G177>100,G178>100,G179>100,G180>100,G181>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G174:G181)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H174:K174)>G174,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H175:K175)>G175,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H174:K181)/K182,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O174+O175+O176+O177+O178+O179+O180+O181","v":0},1,{"$f":"1","v":1}]
[null,null,"HOOFDBOUWDEEL D",null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T187=1,K194=\"\"),0,IF(OR(NOT(C185=\"\")),0,IF(ISERROR(M195),0,M195)))","v":0},{"$f":"N195","v":0},null,{"$f":"0","v":0},{"$f":"IF(asstype=2,0,1)","v":0},null,"Please select amount required;"]
[null,null,"ELEMENT 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq4>=3,0,1)","v":1},0,null,0,"Volume"]
[null,null,null,{"$f":"IF(AND(O195>=1,type13=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O195>=1,type13=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,0,null,2,"Percentage"]
[null,null,{"$f":"IF(SUM(G186:G193)=0,\"\",IF(T187=1,IF(T187+K194=1,\"Voer totaal volume element in\",IF((T187+G194+K194)=1,\"Voer totaal volume element in\",IF(ISERROR(C195),\"Voer totaal volume element in\",IF(OR(G186>K194,G187>K194,G188>K194,G189>K194,G190>K194,G191>K194,G192>K194,G193>K194),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G186:G193)>K194,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T187=2,IF(SUM(G186:G193)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G186>100,G187>100,G188>100,G189>100,G190>100,G191>100,G192>100,G193>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G186:G193)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H202+I202+J202+K202)>=3,3,SUM(H202+I202+J202+K202))","v":0},null,null,{"$f":"IF(SUM(H186:K186)>G186,\"1\",\"0\")","v":"0"},1,0,null,3]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T187=1,K194=\"\"),C186,+IF(G195>K194,C186,(IF(M195<80,\"geen punten, totaal is\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H187:K187)>G187,\"1\",\"0\")","v":"0"},1,0,null,4,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,0,null,null,{"$f":"IF(freq4=3,1,IF(freq4=4,2,IF(freq4=5,3,IF(freq4=6,4,1))))","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,0,null,2]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H186:K193)/K194,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,0]
[null,null,{"$f":"IF(G194=0,\"0\",IF(OR(T187=1,T187=3),\"0\",IF(T187=2,(G194/100)*100,IF(OR(T187=1,T187=3),(G194/100)*100))))","v":"0"},{"$f":"G194","v":"0"},null,"Total",{"$f":"IF(SUM(K194,K214,K225,K236)=0,\"1\",SUM(K194,K214,K225,K236))","v":"1"},{"$f":"SUM(H186:H193,H206:H213,H217:H224,H228:H235)","v":0},{"$f":"SUM(I186:I193,I206:I213,I217:I224,I228:I235)","v":0},{"$f":"SUM(J186:J193,J206:J213,J217:J224,J228:J235)","v":0},{"$f":"SUM(K186:K193,K206:K213,K217:K224,K228:K235)","v":0},null,{"$f":"SUM(H196:K196)","v":0},{"$f":"IF(M183<80,0,IF(O195>0,\"0\",IF(M183>100,0,IF(M183>=80,L186,IF(M183<80,0)))))","v":0},{"$f":"O186+O187+O188+O189+O190+O191+O192+O193","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H195+G195=0,\"0\",(H195/G195)*100)","v":0},{"$f":"IF(I195+G195=0,\"0\",(I195/G195)*100)","v":0},{"$f":"IF(J195+G195=0,\"0\",(J195/G195)*100)","v":0},{"$f":"IF(K195+G195=0,\"0\",(K195/G195)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T187=2,((G195/100)*80))","v":false},"% of 80",{"$f":"(H196/80)*100","v":0},{"$f":"(I196/80)*100","v":0},{"$f":"(J196/80)*100","v":0},{"$f":"(K196/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H197>100,\"100\",H197)","v":0},{"$f":"IF(I197>100,\"100\",I197)","v":0},{"$f":"IF(J197>100,\"100\",J197)","v":0},{"$f":"IF(K197>100,\"100\",K197)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H198+I198+J198+K198=0,0,100-(H198))","v":0},{"$f":"IF(I198+H198+J198+K198=0,0,100-(I198+H198))","v":0},{"$f":"IF(J198+I198+H198+K198=0,0,100-(H198+J198+I198))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I198>I199,I199,I198)","v":0},{"$f":"IF(J198>J199,J199,J198)","v":0},{"$f":"IF(K198>K199,K199,K198)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J200+I198+H198>=100,0,K200)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H195=0,0,0.01*(H198*H203))","v":0},{"$f":"IF(I195=0,0,0.01*(I200*I203))","v":0},{"$f":"IF(J195=0,0,0.01*(J200*J203))","v":0},{"$f":"IF(K195=0,0,0.01*(K201*K203))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq4>=4,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O214>=1,type14=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O214>=1,type14=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G206:G213)=0,\"\",IF(T208=1,IF(T208+K214=1,\"Voer totaal volume element in\",IF((T208+G214+K214)=1,\"Voer totaal volume element in\",IF(ISERROR(C195),\"Voer totaal volume element in\",IF(OR(G206>K214,G207>K214,G208>K214,G209>K214,G210>K214,G211>K214,G212>K214,G213>K214),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G206:G213)>K214,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T208=2,IF(SUM(G206:G213)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G206>100,G207>100,G208>100,G209>100,G210>100,G211>100,G212>100,G213>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G206:G213)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H206:K206)>G206,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H207:K207)>G207,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H206:K213)/K214,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O206+O207+O208+O209+O210+O211+O212+O213","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq4>=5,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O225>=1,type15=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O225>=1,type15=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percenatage"]
[null,null,{"$f":"IF(SUM(G217:G224)=0,\"\",IF(T219=1,IF(T219+K225=1,\"Voer totaal volume element in\",IF((T219+G225+K225)=1,\"Voer totaal volume element in\",IF(ISERROR(C195),\"Voer totaal volume element in\",IF(OR(G217>K225,G218>K225,G219>K225,G220>K225,G221>K225,G222>K225,G223>K225,G224>K225),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G217:G224)>K225,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T219=2,IF(SUM(G217:G224)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G217>100,G218>100,G219>100,G220>100,G221>100,G222>100,G223>100,G224>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G217:G224)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H217:K217)>G217,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H218:K218)>G218,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H217:K224)/K225,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O217+O218+O219+O220+O221+O222+O223+O224","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq4>=6,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O236>=1,type16=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O236>=1,type16=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G228:G235)=0,\"\",IF(T230=1,IF(T230+K236=1,\"Voer totaal volume element in\",IF((T230+G236+K236)=1,\"Voer totaal volume element in\",IF(ISERROR(C195),\"Voer totaal volume element in\",IF(OR(G228>K236,G229>K236,G230>K236,G231>K236,G232>K236,G234>K236,G234>K236,G235>K236),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G228:G235)>K236,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T230=2,IF(SUM(G228:G235)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G228>100,G229>100,G230>100,G231>100,G232>100,G233>100,G234>100,G235>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G228:G235)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H228:K228)>G228,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H229:K229)>G229,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H228:K235)/K236,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O228+O229+O230+O231+O232+O233+O234+O235","v":0},1,{"$f":"1","v":1}]
[null,null,"HOOFDBOUWDEEL E",null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T241=1,K248=\"\"),0,IF(OR(NOT(C239=\"\")),0,IF(ISERROR(M249),\"0\",M249)))","v":0},{"$f":"N249","v":0},null,{"$f":"0","v":0},{"$f":"IF(asstype=2,0,1)","v":0},null,"Please select amount required:"]
[null,null,"ELEMENT 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq5>=3,0,1)","v":1},0,null,0,"Volume"]
[null,null,null,{"$f":"IF(AND(O249>=1,type17=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O249>=1,type17=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,0,null,2,"Percentage"]
[null,null,{"$f":"IF(SUM(G240:G247)=0,\"\",IF(T241=1,IF(T241+K248=1,\"Voer totaal volume element in\",IF((T241+G248+K248)=1,\"Voer totaal volume element in\",IF(ISERROR(C249),\"Voer totaal volume element in\",IF(OR(G240>K248,G241>K248,G242>K248,G243>K248,G244>K248,G245>K248,G246>K248,G247>K248),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G240:G247)>K248,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T241=2,IF(SUM(G240:G247)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G240>100,G241>100,G242>100,G243>100,G244>100,G245>100,G246>100,G247>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G240:G247)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H256+I256+J256+K256)>=3,3,SUM(H256+I256+J256+K256))","v":0},null,null,{"$f":"IF(SUM(H240:K240)>G240,\"1\",\"0\")","v":"0"},1,0,null,3]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T241=1,K248=\"\"),C240,+IF(G249>K248,C240,(IF(M249<80,\"geen punten, totaal is\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H241:K241)>G241,\"1\",\"0\")","v":"0"},1,0,null,4,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,0,null,null,{"$f":"IF(freq5=3,1,IF(freq5=4,2,IF(freq5=5,3,IF(freq5=6,4,1))))","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,0,null,2]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H240:K247)/K248,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,0]
[null,null,{"$f":"IF(G248=0,\"0\",IF(OR(T241=1,T241=3),\"0\",IF(T241=2,(G248/100)*100,IF(OR(T241=1,T241=3),(G248/100)*100))))","v":"0"},{"$f":"G248","v":"0"},null,"Total",{"$f":"IF(SUM(K248,K268,K279,K290)=0,\"1\",SUM(K248,K268,K279,K290))","v":"1"},{"$f":"SUM(H240:H247,H260:H267,H271:H278,H282:H289)","v":0},{"$f":"SUM(I240:I247,I260:I267,I271:I278,I282:I289)","v":0},{"$f":"SUM(J240:J247,J260:J267,J271:J278,J282:J289)","v":0},{"$f":"SUM(K240:K247,K260:K267,K271:K278,K282:K289)","v":0},null,{"$f":"SUM(H250:K250)","v":0},{"$f":"IF(M237<80,0,IF(O249>0,0,IF(M237>100,0,IF(M237>=80,L240,IF(M237<80,0)))))","v":0},{"$f":"O240+O241+O242+O243+O244+O245+O246+O247","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H249+G249=0,\"0\",(H249/G249)*100)","v":0},{"$f":"IF(I249+G249=0,\"0\",(I249/G249)*100)","v":0},{"$f":"IF(J249+G249=0,\"0\",(J249/G249)*100)","v":0},{"$f":"IF(K249+G249=0,\"0\",(K249/G249)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T241=2,((G249/100)*80))","v":false},"% of 80",{"$f":"(H250/80)*100","v":0},{"$f":"(I250/80)*100","v":0},{"$f":"(J250/80)*100","v":0},{"$f":"(K250/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H251>100,\"100\",H251)","v":0},{"$f":"IF(I251>100,\"100\",I251)","v":0},{"$f":"IF(J251>100,\"100\",J251)","v":0},{"$f":"IF(K251>100,\"100\",K251)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H252+I252+J252+K252=0,0,100-(H252))","v":0},{"$f":"IF(I252+H252+J252+K252=0,0,100-(I252+H252))","v":0},{"$f":"IF(J252+I252+H252+K252=0,0,100-(H252+J252+I252))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I252>I253,I253,I252)","v":0},{"$f":"IF(J252>J253,J253,J252)","v":0},{"$f":"IF(K252>K253,K253,K252)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J254+I252+H252>=100,0,K254)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H249=0,0,0.01*(H252*H257))","v":0},{"$f":"IF(I249=0,0,0.01*(I254*I257))","v":0},{"$f":"IF(J249=0,0,0.01*(J254*J257))","v":0},{"$f":"IF(K249=0,0,0.01*(K255*K257))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq5>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,{"$f":"IF(AND(O268>=1,type18=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O268>=1,type18=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1}]
[null,null,{"$f":"IF(SUM(G260:G267)=0,\"\",IF(T262=1,IF(T262+K268=1,\"Voer totaal volume element in\",IF((T262+G268+K268)=1,\"Voer totaal volume element in\",IF(ISERROR(C249),\"Voer totaal volume element in\",IF(OR(G260>K268,G261>K268,G262>K268,G263>K268,G264>K268,G265>K268,G266>K268,G267>K268),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G260:G267)>K268,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T262=2,IF(SUM(G260:G267)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G260>100,G261>100,G262>100,G263>100,G264>100,G265>100,G266>100,G267>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G260:G267)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H260:K260)>G260,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H261:K261)>G261,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H260:K267)/K268,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O260+O261+O262+O263+O264+O265+O266+O267","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq5>=5,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O279>=1,type19=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O279>=1,type19=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G271:G278)=0,\"\",IF(T273=1,IF(T273+K279=1,\"Voer totaal volume element in\",IF((T273+G279+K279)=1,\"Voer totaal volume element in\",IF(ISERROR(C249),\"Voer totaal volume element in\",IF(OR(G271>K279,G272>K279,G273>K279,G274>K279,G275>K279,G276>K279,G277>K279,G278>K279),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G271:G278)>K279,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T273=2,IF(SUM(G271:G278)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G271>100,G272>100,G273>100,G274>100,G275>100,G276>100,G277>100,G278>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G271:G278)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H271:K271)>G271,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H272:K272)>G272,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H271:K278)/K279,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O271+O272+O273+O274+O275+O276+O277+O278","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq5>=6,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,{"$f":"IF(AND(O290>=1,type20=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O290>=1,type20=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Volume"]
[null,null,{"$f":"IF(SUM(G282:G289)=0,\"\",IF(T284=1,IF(T284+K290=1,\"Voer totaal volume element in\",IF((T284+G290+K290)=1,\"Voer totaal volume element in\",IF(ISERROR(C249),\"Voer totaal volume element in\",IF(OR(G282>K290,G283>K290,G284>K290,G285>K290,G286>K290,G287>K290,G288>K290,G289>K290),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G282:G289)>K290,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T284=2,IF(SUM(G282:G289)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G282>100,G283>100,G284>100,G285>100,G286>100,G287>100,G288>100,G289>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G282:G289)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H282:K282)>G282,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H283:K283)>G283,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H282:K289)/K290,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O282+O283+O284+O285+O286+O287+O288+O289","v":0},1,{"$f":"1","v":1}]
[null,null,"HOOFDBOUWDEEL F",null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T295=1,K302=\"\"),0,IF(OR(NOT(C293=\"\")),0,IF(ISERROR(M303),\"0\",M303)))","v":0},{"$f":"N303","v":0},null,{"$f":"0","v":0},{"$f":"IF(asstype=2,0,1)","v":0},null,"Please select amount required:"]
[null,null,"ELEMENT 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq6>=3,0,1)","v":1},0,null,0,"Volume"]
[null,null,null,{"$f":"IF(AND(O303>=1,type21=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O303>=1,type21=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,0,null,2,"Percentage"]
[null,null,{"$f":"IF(SUM(G294:G301)=0,\"\",IF(T295=1,IF(T295+K302=1,\"Voer totaal volume element in\",IF((T295+G302+K302)=1,\"Voer totaal volume element in\",IF(ISERROR(C303),\"Voer totaal volume element in\",IF(OR(G294>K302,G295>K302,G296>K302,G297>K302,G298>K302,G299>K302,G300>K302,G301>K302),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G294:G301)>K302,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T295=2,IF(SUM(G294:G301)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G294>100,G295>100,G296>100,G297>100,G298>100,G299>100,G300>100,G301>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G294:G301)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H310+I310+J310+K310)>=3,3,SUM(H310+I310+J310+K310))","v":0},null,null,{"$f":"IF(SUM(H294:K294)>G294,\"1\",\"0\")","v":"0"},1,0,null,3]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T295=1,K302=\"\"),C294,+IF(G303>K302,C294,(IF(M303<80,\"geen punten, totaal is\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H295:K295)>G295,\"1\",\"0\")","v":"0"},1,0,null,4,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,0,null,null,{"$f":"IF(freq6=3,1,IF(freq6=4,2,IF(freq6=5,3,IF(freq6=6,4,1))))","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,0,null,2]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H294:K301)/K302,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,0]
[null,null,{"$f":"IF(G302=0,\"0\",IF(OR(T295=1,T295=3),\"0\",IF(T295=2,(G302/100)*100,IF(OR(T295=1,T295=3),(G302/100)*100))))","v":"0"},{"$f":"G302","v":"0"},null,"Total",{"$f":"IF(SUM(K302,K322,K333,K344)=0,\"1\",SUM(K302,K322,K333,K344))","v":"1"},{"$f":"SUM(H294:H301,H314:H321,H325:H332,H336:H343)","v":0},{"$f":"SUM(I294:I301,I314:I321,I325:I332,I336:I343)","v":0},{"$f":"SUM(J294:J301,J314:J321,J325:J332,J336:J343)","v":0},{"$f":"SUM(K294:K301,K314:K321,K325:K332,K336:K343)","v":0},null,{"$f":"SUM(H304:K304)","v":0},{"$f":"IF(M291<80,0,IF(O303>0,0,IF(M291>100,0,IF(M291>=80,L294,IF(M291<80,0)))))","v":0},{"$f":"O294+O295+O296+O297+O298+O299+O300+O301","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H303+G303=0,\"0\",(H303/G303)*100)","v":0},{"$f":"IF(I303+G303=0,\"0\",(I303/G303)*100)","v":0},{"$f":"IF(J303+G303=0,\"0\",(J303/G303)*100)","v":0},{"$f":"IF(K303+G303=0,\"0\",(K303/G303)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T295=2,((G303/100)*80))","v":false},"% of 80",{"$f":"(H304/80)*100","v":0},{"$f":"(I304/80)*100","v":0},{"$f":"(J304/80)*100","v":0},{"$f":"(K304/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H305>100,\"100\",H305)","v":0},{"$f":"IF(I305>100,\"100\",I305)","v":0},{"$f":"IF(J305>100,\"100\",J305)","v":0},{"$f":"IF(K305>100,\"100\",K305)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H306+I306+J306+K306=0,0,100-(H306))","v":0},{"$f":"IF(I306+H306+J306+K306=0,0,100-(I306+H306))","v":0},{"$f":"IF(J306+I306+H306+K306=0,0,100-(H306+J306+I306))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I306>I307,I307,I306)","v":0},{"$f":"IF(J306>J307,J307,J306)","v":0},{"$f":"IF(K306>K307,K307,K306)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J308+I306+H306>=100,0,K308)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H303=0,0,0.01*(H306*H311))","v":0},{"$f":"IF(I303=0,0,0.01*(I308*I311))","v":0},{"$f":"IF(J303=0,0,0.01*(J308*J311))","v":0},{"$f":"IF(K303=0,0,0.01*(K309*K311))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,"ELEMENT 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq6>=4,0,1)","v":1},{"$f":"1","v":1}]
[null,null,null,{"$f":"IF(AND(O322>=1,type22=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O322>=1,type22=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Volume"]
[null,null,{"$f":"IF(SUM(G314:G321)=0,\"\",IF(T316=1,IF(T316+K322=1,\"Voer totaal volume element in\",IF((T316+G322+K322)=1,\"Voer totaal volume element in\",IF(ISERROR(C303),\"Voer totaal volume element in\",IF(OR(G314>K322,G315>K322,G316>K322,G317>K322,G318>K322,G319>K322,G320>K322,G321>K322),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G314:G321)>K322,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T316=2,IF(SUM(G314:G321)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G314>100,G315>100,G316>100,G317>100,G318>100,G319>100,G320>100,G321>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G314:G321)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H314:K314)>G314,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H315:K315)>G315,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H314:K321)/K322,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O314+O315+O316+O317+O318+O319+O320+O321","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq6>=5,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O333>=1,type23=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O333>=1,type23=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G325:G332)=0,\"\",IF(T327=1,IF(T327+K333=1,\"Voer totaal volume element in\",IF((T327+G333+K333)=1,\"Voer totaal volume element in\",IF(ISERROR(C303),\"Voer totaal volume element in\",IF(OR(G325>K333,G326>K333,G327>K333,G328>K333,G329>K333,G330>K333,G331>K333,G332>K333),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G325:G332)>K333,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T327=2,IF(SUM(G325:G332)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G325>100,G326>100,G327>100,G328>100,G329>100,G330>100,G331>100,G332>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G325:G332)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H325:K325)>G325,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H326:K326)>G326,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H325:K332)/K333,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O325+O326+O327+O328+O329+O330+O331+O332","v":0},1,{"$f":"1","v":1}]
[null,null,"ELEMENT 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq6>=6,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O344>=1,type24=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O344>=1,type24=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G336:G343)=0,\"\",IF(T338=1,IF(T338+K344=1,\"Voer totaal volume element in\",IF((T338+G344+K344)=1,\"Voer totaal volume element in\",IF(ISERROR(C303),\"Voer totaal volume element in\",IF(OR(G336>K344,G337>K344,G338>K344,G339>K344,G340>K344,G341>K344,G342>K344,G343>K344),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G336:G343)>K344,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T338=2,IF(SUM(G336:G343)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G336>100,G337>100,G338>100,G339>100,G340>100,G341>100,G342>100,G343>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G336:G343)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H336:K336)>G336,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H337:K337)>G337,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H336:K343)/K344,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O336+O337+O338+O339+O340+O341+O342+O343","v":0},1,{"$f":"1","v":1}]
[null,null,null,null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T349=1,K356=\"\"),0,IF(OR(NOT(D347=\"\"),NOT(C348=\"\"),NOT(M349=\"\")),0,IF(ISERROR(M357),\"0\",M357)))","v":0},{"$f":"N357","v":0},null,{"$f":"0","v":0},{"$f":"IF(asstype=2,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq7>=3,0,1)","v":1},0,null,"Please select amount required;","Volume"]
[null,null,null,{"$f":"IF(AND(O357>=1,type25=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O357>=1,type25=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,0,null,0,"Percentage"]
[null,null,{"$f":"IF(SUM(G348:G355)=0,\"\",IF(T349=1,IF(T349+K356=1,\"Voer totaal volume element in\",IF((T349+G356+K356)=1,\"Voer totaal volume element in\",IF(ISERROR(C357),\"Voer totaal volume element in\",IF(OR(G348>K356,G349>K356,G350>K356,G351>K356,G352>K356,G353>K356,G354>K356,G355>K356),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G348:G355)>K356,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T349=2,IF(SUM(G348:G355)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G348>100,G349>100,G350>100,G351>100,G352>100,G353>100,G354>100,G355>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G348:G355)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H364+I364+J364+K364)>=3,3,SUM(H364+I364+J364+K364))","v":0},null,null,{"$f":"IF(SUM(H348:K348)>G348,\"1\",\"0\")","v":"0"},1,0,null,1]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T349=1,K356=\"\"),C348,+IF(G357>K356,C348,(IF(M357<80,\"geen punten, totaal is\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H349:K349)>G349,\"1\",\"0\")","v":"0"},1,0,null,2,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,0,null,3]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,0,null,4,{"$f":"IF(freq7=3,1,IF(freq7=4,2,IF(freq7=5,3,IF(freq7=6,4,1))))","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,0,null,2]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,0]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H348:K355)/K356,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,0]
[null,null,{"$f":"IF(G356=0,\"0\",IF(T349=2,\"0\",IF(T349=1,(G356/100)*100,IF(T349=2,(G356/100)*100))))","v":0},{"$f":"G356","v":"0"},null,"Total",{"$f":"IF(SUM(K356,K376,K387,K398)=0,\"1\",SUM(K356,K376,K387,K398))","v":"1"},{"$f":"SUM(H348:H355,H368:H375,H379:H386,H390:H397)","v":0},{"$f":"SUM(I348:I355,I368:I375,I379:I386,I390:I397)","v":0},{"$f":"SUM(J348:J355,J368:J375,J379:J386,J390:J397)","v":0},{"$f":"SUM(K348:K355,K368:K375,K379:K386,K390:K397)","v":0},null,{"$f":"SUM(H358:K358)","v":0},{"$f":"IF(M345<80,0,IF(O357>0,0,IF(M345>100,0,IF(M345>=80,L348,IF(M345<80,0)))))","v":0},{"$f":"O348+O349+O350+O351+O352+O353+O354+O355","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H357+G357=0,\"0\",(H357/G357)*100)","v":0},{"$f":"IF(I357+G357=0,\"0\",(I357/G357)*100)","v":0},{"$f":"IF(J357+G357=0,\"0\",(J357/G357)*100)","v":0},{"$f":"IF(K357+G357=0,\"0\",(K357/G357)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T349=1,((G357/100)*80))","v":0.8},"% of 80",{"$f":"(H358/80)*100","v":0},{"$f":"(I358/80)*100","v":0},{"$f":"(J358/80)*100","v":0},{"$f":"(K358/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H359>100,\"100\",H359)","v":0},{"$f":"IF(I359>100,\"100\",I359)","v":0},{"$f":"IF(J359>100,\"100\",J359)","v":0},{"$f":"IF(K359>100,\"100\",K359)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H360+I360+J360+K360=0,0,100-(H360))","v":0},{"$f":"IF(I360+H360+J360+K360=0,0,100-(I360+H360))","v":0},{"$f":"IF(J360+I360+H360+K360=0,0,100-(H360+J360+I360))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I360>I361,I361,I360)","v":0},{"$f":"IF(J360>J361,J361,J360)","v":0},{"$f":"IF(K360>K361,K361,K360)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J362+I360+H360>=100,0,K362)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H357=0,0,0.01*(H360*H365))","v":0},{"$f":"IF(I357=0,0,0.01*(I362*I365))","v":0},{"$f":"IF(J357=0,0,0.01*(J362*J365))","v":0},{"$f":"IF(K357=0,0,0.01*(K363*K365))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,"Total",null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq7>=4,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O376>=1,type26=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O376>=1,type26=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G368:G375)=0,\"\",IF(T369=1,IF(T369+K376=1,\"Voer totaal volume element in\",IF((T369+G376+K376)=1,\"Voer totaal volume element in\",IF(ISERROR(C357),\"Voer totaal volume element in\",IF(OR(G368>K376,G369>K376,G370>K376,G371>K376,G372>K376,G373>K376,G374>K376,G375>K376),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G368:G375)>K376,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T369=2,IF(SUM(G368:G375)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G368>100,G369>100,G370>100,G371>100,G372>100,G373>100,G374>100,G375>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G368:G375)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H368:K368)>G368,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H369:K369)>G369,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H368:K375)/K376,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O368+O369+O370+O371+O372+O373+O374+O375","v":0},1,{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq7>=5,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O387>=1,type27=1),\"ERROR! Volume of tier cannot be greater than volume of individual material.\",+IF(AND(O387>=1,type27=2),\"ERROR! The % compliant with each tier must be entered as a % of the total element assessed, the total % compliant cannot be greater than the total % of the individual material.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G379:G386)=0,\"\",IF(T380=1,IF(T380+K387=1,\"Voer totaal volume element in\",IF((T380+G387+K387)=1,\"Voer totaal volume element in\",IF(ISERROR(C357),\"Voer totaal volume element in\",IF(OR(G379>K387,G380>K387,G381>K387,G382>K387,G383>K387,G384>K387,G385>K387,G386>K387),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G379:G386)>K387,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T380=2,IF(SUM(G379:G386)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G379>100,G380>100,G381>100,G382>100,G383>100,G384>100,G385>100,G386>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G379:G386)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H379:K379)>G379,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H380:K380)>G380,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H379:K386)/K387,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O379+O380+O381+O382+O383+O384+O385+O386","v":0},1,{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq7>=6,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O398>=1,type28=1),\"ERROR! Volume of tier cannot be greater than volume of individual material.\",+IF(AND(O398>=1,type28=2),\"ERROR! The % compliant with each tier must be entered as a % of the total element assessed, the total % compliant cannot be greater than the total % of the individual material.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G390:G397)=0,\"\",IF(T391=1,IF(T391+K398=1,\"Voer totaal volume element in\",IF((T391+G398+K398)=1,\"Voer totaal volume element in\",IF(ISERROR(C357),\"Voer totaal volume element in\",IF(OR(G390>K398,G391>K398,G392>K398,G393>K398,G394>K398,G395>K398,G396>K398,G397>K398),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G390:G397)>K398,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T391=2,IF(SUM(G390:G397)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G390>100,G391>100,G392>100,G393>100,G394>100,G395>100,G396>100,G397>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G390:G397)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H390:K390)>G390,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T391=1,K398=\"\"),C390,+IF(#REF!>K398,C390,(IF(#REF!<80,\"geen punten,\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H391:K391)>G391,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H390:K397)/K398,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O390+O391+O392+O393+O394+O395+O396+O397","v":0},1,{"$f":"1","v":1}]
[null,null,null,null,null,"Selecteer het aantal elementen die u wenst in te voeren (en klik op 'select'):",null,null,null,null,null,null,{"$f":"IF(AND(T402=1,K410=\"\"),0,IF(OR(NOT(D401=\"\")),0,IF(ISERROR(M411),\"0\",M411)))","v":0},{"$f":"N411","v":0},null,{"$f":"0","v":0},{"$f":"0","v":0},null,"Please select amount required;","Volume"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq8>=3,0,1)","v":1},{"$f":"0","v":0},null,0,"Percentage"]
[null,null,null,{"$f":"IF(AND(O411>=1,type29=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O411>=1,type29=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"0","v":0},null,1]
[null,null,{"$f":"IF(SUM(G402:G409)=0,\"\",IF(T402=1,IF(T402+K410=1,\"Voer totaal volume element in\",IF((T402+G410+K410)=1,\"Voer totaal volume element in\",IF(ISERROR(C411),\"Voer totaal volume element in\",IF(OR(G402>K410,G403>K410,G404>K410,G405>K410,G406>K410,G407>K410,G408>K410,G409>K410),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G402:G409)>K410,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T402=2,IF(SUM(G402:G409)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G402>100,G403>100,G404>100,G405>100,G406>100,G407>100,G408>100,G409>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G402:G409)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,{"$f":"IF(SUM(H418+I418+J418+K418)>=3,3,SUM(H418+I418+J418+K418))","v":0},null,null,{"$f":"IF(SUM(H402:K402)>G402,\"1\",\"0\")","v":"0"},1,{"$f":"0","v":0},null,2,1]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,{"$f":"IF(AND(T402=1,K410=\"\"),C402,+IF(G411>K410,C402,(IF(M411<80,\"geen punten, totaal is\n< 80%\",\"\"))))","v":""},null,{"$f":"IF(SUM(H403:K403)>G403,\"1\",\"0\")","v":"0"},1,{"$f":"0","v":0},null,3]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"0","v":0},null,4,{"$f":"IF(freq8=3,1,IF(freq8=4,2,IF(freq8=5,3,IF(freq8=6,4,1))))","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"0","v":0}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"0","v":0},null,2]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"0","v":0}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"0","v":0}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"0","v":0}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H402:K409)/K410,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,null,1,{"$f":"0","v":0}]
[null,null,{"$f":"IF(G410=0,\"0\",IF(T402=2,\"0\",IF(T402=1,(G410/100)*100,IF(T402=2,(G410/100)*100))))","v":0},{"$f":"G410","v":"0"},null,"Total",{"$f":"IF(SUM(K410,K430,K441,K452)=0,\"1\",SUM(K410,K430,K441,K452))","v":"1"},{"$f":"SUM(H402:H409,H422:H429,H433:H440,H444:H451)","v":0},{"$f":"SUM(I402:I409,I422:I429,I433:I440,I444:I451)","v":0},{"$f":"SUM(J402:J409,J422:J429,J433:J440,J444:J451)","v":0},{"$f":"SUM(K402:K409,K422:K429,K433:K440,K444:K451)","v":0},null,{"$f":"SUM(H412:K412)","v":0},{"$f":"IF(M399<80,0,IF(O411>0,0,IF(M399>100,0,IF(M399>=80,L402,IF(M399<80,0)))))","v":0},{"$f":"O402+O403+O404+O405+O406+O407+O408+O409","v":0},{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Percentage",{"$f":"IF(H411+G411=0,\"0\",(H411/G411)*100)","v":0},{"$f":"IF(I411+G411=0,\"0\",(I411/G411)*100)","v":0},{"$f":"IF(J411+G411=0,\"0\",(J411/G411)*100)","v":0},{"$f":"IF(K411+G411=0,\"0\",(K411/G411)*100)","v":0},null,100,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,{"$f":"IF(T402=1,((G411/100)*80))","v":0.8},"% of 80",{"$f":"(H412/80)*100","v":0},{"$f":"(I412/80)*100","v":0},{"$f":"(J412/80)*100","v":0},{"$f":"(K412/80)*100","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Limiter",{"$f":"IF(H413>100,\"100\",H413)","v":0},{"$f":"IF(I413>100,\"100\",I413)","v":0},{"$f":"IF(J413>100,\"100\",J413)","v":0},{"$f":"IF(K413>100,\"100\",K413)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H414+I414+J414+K414=0,0,100-(H414))","v":0},{"$f":"IF(I414+H414+J414+K414=0,0,100-(I414+H414))","v":0},{"$f":"IF(J414+I414+H414+K414=0,0,100-(H414+J414+I414))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I414>I415,I415,I414)","v":0},{"$f":"IF(J414>J415,J415,J414)","v":0},{"$f":"IF(K414>K415,K415,K414)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J416+I414+H414>=100,0,K416)","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,"Scores",{"$f":"IF(H411=0,0,0.01*(H414*H419))","v":0},{"$f":"IF(I411=0,0,0.01*(I416*I419))","v":0},{"$f":"IF(J411=0,0,0.01*(J416*J419))","v":0},{"$f":"IF(K411=0,0,0.01*(K417*K419))","v":0},null,null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,3,2,1.5,1,"Total",null,null,null,{"$f":"1","v":1},{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq8>=4,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O430>=1,type30=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O430>=1,type30=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G422:G429)=0,\"\",IF(T423=1,IF(T423+K430=1,\"Voer totaal volume element in\",IF((T423+G430+K430)=1,\"Voer totaal volume element in\",IF(ISERROR(C411),\"Voer totaal volume element in\",IF(OR(G422>K430,G423>K430,G424>K430,G425>K430,G426>K430,G427>K430,G428>K430,G429>K430),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G422:G429)>K430,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T423=2,IF(SUM(G422:G429)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G422>100,G423>100,G424>100,G425>100,G426>100,G427>100,G428>100,G429>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G422:G429)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H422:K422)>G422,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H423:K423)>G423,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H422:K429)/K430,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O422+O423+O424+O425+O426+O427+O428+O429","v":0},1,{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq8>=5,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O441>=1,type31=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O441>=1,type31=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G433:G440)=0,\"\",IF(T434=1,IF(T434+K441=1,\"Voer totaal volume element in\",IF((T434+G441+K441)=1,\"Voer totaal volume element in\",IF(ISERROR(C411),\"Voer totaal volume element in\",IF(OR(G433>K441,G434>K441,G435>K441,G436>K441,G437>K441,G438>K441,G439>K441,G440>K441),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G433:G440)>K441,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T434=2,IF(SUM(G433:G440)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G433>100,G434>100,G435>100,G436>100,G437>100,G438>100,G439>100,G440>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G433:G440)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H433:K433)>G433,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H434:K434)>G434,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H433:K440)/K441,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O433+O434+O435+O436+O437+O438+O439+O440","v":0},1,{"$f":"1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(freq8>=6,0,1)","v":1},{"$f":"1","v":1},null,null,"Volume"]
[null,null,null,{"$f":"IF(AND(O452>=1,type32=1),\"ERROR! Volume van de tier kan niet groter zijn dan het volume van het individuele materiaal.\",+IF(AND(O452>=1,type32=2),\"ERROR! Het tier % moet ingevoerd worden als % van het totaal te beoordelen element, het totale tier % kan niet groter zijn dan het totaal % van het individuele materiaal.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"1","v":1},null,null,"Percentage"]
[null,null,{"$f":"IF(SUM(G444:G451)=0,\"\",IF(T445=1,IF(T445+K452=1,\"Voer totaal volume element in\",IF((T445+G452+K452)=1,\"Voer totaal volume element in\",IF(ISERROR(C411),\"Voer totaal volume element in\",IF(OR(G444>K452,G445>K452,G446>K452,G447>K452,G448>K452,G449>K452,G450>K452,G451>K452),\"Volume van individuele materialen kan niet hoger zijn dan het totale volume van het element\",IF(SUM(G444:G451)>K452,\"Totaal volume van de materialen kan niet hoger zijn dan het totale volume van het element\",\"\"))))),IF(T445=2,IF(SUM(G444:G451)<80,\"ERROR! Een minimum van 80% van het totale element moet worden beoordeeld, herberekenen of neem contact op de DGBC.\",IF(OR(G444>100,G445>100,G446>100,G447>100,G448>100,G449>100,G450>100,G451>100),\"Percentage van het individuele materiaal kan niet 100% zijn\",IF(SUM(G444:G451)>100,\"Totaal percentage van het element kan niet meer zijn dan 100%\",\"\"))))))","v":""},null,"Mat 1",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H444:K444)>G444,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 2",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H445:K445)>G445,\"1\",\"0\")","v":"0"},1,{"$f":"1","v":1},null,null,1]
[null,null,null,null,"Mat 3",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 4",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat5",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 6",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 7",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Mat 8",null,null,null,null,null,null,null,null,null,"0",1,{"$f":"1","v":1}]
[null,null,null,null,"Totaal % element beoordeeld",null,{"$f":"IFERROR(SUM(H444:K451)/K452,\"0\")","v":"0"},"Totaal volume element",null,null,null,null,null,null,{"$f":"O444+O445+O446+O447+O448+O449+O450+O451","v":0},1,{"$f":"1","v":1}]
[]
[]
[]
[null,null,"FOR NEW BUILD"]
[null,null,"Present",{"$f":"COUNTIF(D461:D468,1)","v":0},"Volume","Points required:","1 Credits","2 credits","3 credits","4 credits","for 8 elements (constant):"]
[null,null,"Not Present",{"$f":"COUNTIF(D461:D468,0)","v":8},"Percentage","(greater than)",{"$f":"(D457/D470)*4.999","v":0},{"$f":"(D457/D470)*9.999","v":0},{"$f":"(D457/D470)*14.9999","v":0},{"$f":"(D457/D470)*19.9999","v":0},18]
[]
[null,null,"total",{"$f":"SUM(D457:D458)","v":8},null,null,0,0]
[null,null,"FRAME",{"$f":"IF(asstype=2,IF(freq1>=3,1,0),0)","v":0},{"$f":"IF(asstype=2,1,0)","v":1},null,{"$f":"G458","v":0},1]
[null,null,"GROUND FLOOR",{"$f":"IF(asstype=2,IF(freq2>=3,1,0),0)","v":0},1,null,{"$f":"H458","v":0},2]
[null,null,"UPPER FLOORS",{"$f":"IF(asstype=2,IF(freq3>=3,1,0),0)","v":0},1,null,{"$f":"IF(asstype=3,\"N/A\",I458)","v":0},3]
[null,null,"ROOF",{"$f":"IF(asstype=2,IF(freq4>=3,1,0),0)","v":0},1,null,{"$f":"J458","v":0},4]
[null,null,"EXTERNAL WALLS",{"$f":"IF(asstype=2,IF(freq5>=3,1,0),0)","v":0},1]
[null,null,"INTERNAL WALLS",{"$f":"IF(asstype=2,IF(freq6>=3,1,0),0)","v":0},1]
[null,null,"FOUNDATIONS/SUB",{"$f":"IF(asstype=2,IF(freq7>=3,1,0),0)","v":0},1,null,"EDWIN VAN NOORT DECEMBER 2014 (NVT)"]
[null,null,"STAIRCASE",{"$f":"IF(freq8>=3,1,0)","v":0},{"$f":"1","v":1},null,"CORRECTIEFACTOR BREEAM-NL 2014 (NVT)",null,null,1]
[null,null,null,null,null,null,"AANTAL ELEMENTEN MINDER IN BRL 2014 (NVT)",null,null,2]
[null,null,"Total elements of \ntype assessed",{"$f":"SUM(E461:E468)","v":8}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Totaal behaalde punten",null,null,null,{"$f":"(N21+N75+N129+N183+N237+N291+N345+N399)*J468","v":0}]
[]
[null,null,null,null,"TOTAAL CREDITS BEHAALD",null,null,null,{"$f":"IF(I478=0,0,IF(asstype=2,VLOOKUP(I478,G460:H464,2,TRUE),0))","v":0}]

{"sheet":"Isolatie","index":2,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[9,2,9,5],[39,4,39,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5],[48,3,48,5],[49,3,49,5],[50,3,50,5],[51,3,51,5],[52,3,52,5],[53,3,53,5],[65,3,65,5],[54,3,54,5],[55,3,55,5],[63,3,63,5],[64,3,64,5],[56,3,56,5],[57,3,57,5],[58,3,58,5],[62,3,62,5],[59,3,59,5],[60,3,60,5],[61,3,61,5],[70,4,70,7],[66,3,66,5],[67,3,67,5],[68,4,68,7],[69,4,69,7]]}
[]
[null,null,null,null,null,null,null,null,"BREEAM-NL Nieuwbouw"]
[]
[null,null,null,null,null,null,null,null,"Isolatie"]
[]
[null,null,null,null,null,null,null,null,"BRL 2014 v1.01 - MAT 5: rekentool"]
[]
[]
[]
[null,null,"TOTAAL CREDITS BEHAALD",null,null,null,{"$f":"I71","v":0}]
[]
[null,null,"Isolatie - volumes"]
[null,null,null,"isolatietypes","oppervlakte (m2) ","dikte                (m¹)","volume      (m³)"]
[null,null,"Isolatie gebouw",null,null,null,null,null,null,null,null,null,null,null,"A+ (3 Points)"]
[null,null,"Iso 1",null,null,null,{"$f":"E15*F15","v":0},null,null,null,null,null,null,null,"A (2 Points)",null,1]
[null,null,"Iso 2",null,null,null,0,null,null,null,null,null,null,null,"B (1 Point)",null,6]
[null,null,"Iso 3",null,null,null,0,null,null,null,null,null,null,null,"C (0.5 Points)",null,6]
[null,null,"Iso 4",null,null,null,0,null,null,null,null,null,null,null,"D (0.25 Points)",null,6]
[null,null,"Iso 5",null,null,null,0,null,null,null,null,null,null,null,"E (0 Points)",null,6]
[null,null,"Iso 6",null,null,null,0,null,null,null,null,null,null,null,null,null,3]
[null,null,"Iso 7",null,null,null,0,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 8",null,null,null,0,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 9",null,null,null,{"$f":"E23*F23","v":0},null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 10",null,null,null,{"$f":"E24*F24","v":0},null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 11",null,null,null,{"$f":"E25*F25","v":0},null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 12",null,null,null,{"$f":"E26*F26","v":0},null,null,null,null,null,null,null,null,null,6]
[null,null,"Isolatie installaties",null,"volume      (m³)"]
[null,null,"Iso 13",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 14",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 15",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 16",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 17",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 18",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 19",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 20",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 21",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 22",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 23",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Iso 24",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,"Totaal volume isolatie (m³)",null,{"$f":"IF(SUM(E15:E39)=0,\"0\",(SUM(E28:E39)+(SUM(G15:G26))))","v":"0"}]
[]
[]
[null,null,"Isolatie - verantwoorde herkomst"]
[null,null,null,"Beoordelen op basis van (selecteer uit het drop down menu):",null,null,"volume      (m³)",{"$f":"IF(M47=1,\"volume isolatie  \nmet\nTier 1,2 or 3\",+IF(M47=2,\"% isolatie met Tier 1,2 or 3\"))","v":"volume isolatie  \nmet\nTier 1,2 or 3"},"in overeenstemming (%)"]
[null,null,"Iso 1",{"$f":"IF(D15=\"\",\"\",D15)","v":""},null,null,{"$f":"G15","v":0},null,{"$f":"IF(AND($M$47=1,H45>G15),\"Volume tier kan niet hoger zijn dan het totaal volume\",IF(AND($M$47=2,H45>100),\"Maximaal percentage is 100\",IF(ISERROR(IF($M$47=1,((G15/$G$40)*(H45/G15)),((G15/$G$40)*(H45/100)))),0,IF($M$47=1,((G15/$G$40)*(H45/G15)),((G15/$G$40)*(H45/100))))))","v":0},null,null,null,"Volume"]
[null,null,"Iso 2",{"$f":"IF(D16=\"\",\"\",D16)","v":""},null,null,0,null,0,null,null,null,"Percentage"]
[null,null,"Iso 3","",null,null,0,null,0,null,null,null,1]
[null,null,"Iso 4","",null,null,0,null,0]
[null,null,"Iso 5","",null,null,0,null,0]
[null,null,"Iso 6","",null,null,0,null,0]
[null,null,"Iso 7","",null,null,0,null,0]
[null,null,"Iso 8","",null,null,0,null,0]
[null,null,"Iso 9","",null,null,0,null,0]
[null,null,"Iso 10","",null,null,0,null,0]
[null,null,"Iso 11","",null,null,0,null,0]
[null,null,"Iso 12","",null,null,0,null,0]
[null,null,"Iso 13",{"$f":"IF(D28=\"\",\"\",D28)","v":""},null,null,{"$f":"E28","v":0},null,{"$f":"IF(AND($M$47=1,H57>E28),\"Volume tier kan niet hoger zijn dan het totaal volume\",IF(AND($M$47=2,H57>100),\"Maximaal percentage is 100\",IF(ISERROR(IF($M$47=1,((E28/$G$40)*(H57/E28)),((E28/$G$40)*(H57/100)))),0,IF($M$47=1,((E28/$G$40)*(H57/E28)),((E28/$G$40)*(H57/100))))))","v":0}]
[null,null,"Iso 14",{"$f":"IF(D29=\"\",\"\",D29)","v":""},null,null,{"$f":"E29","v":0},null,{"$f":"IF(AND($M$47=1,H58>E29),\"Volume tier kan niet hoger zijn dan het totaal volume\",IF(AND($M$47=2,H58>100),\"Maximaal percentage is 100\",IF(ISERROR(IF($M$47=1,((E29/$G$40)*(H58/E29)),((E29/$G$40)*(H58/100)))),0,IF($M$47=1,((E29/$G$40)*(H58/E29)),((E29/$G$40)*(H58/100))))))","v":0}]
[null,null,"Iso 15","",null,null,0,null,0]
[null,null,"Iso 16","",null,null,0,null,0]
[null,null,"Iso 17","",null,null,0,null,0]
[null,null,"Iso 18","",null,null,0,null,0]
[null,null,"Iso 19","",null,null,0,null,0]
[null,null,"Iso 20","",null,null,0,null,0]
[null,null,"Iso 21","",null,null,0,null,0]
[null,null,"Iso 22","",null,null,0,null,0]
[null,null,"Iso 23","",null,null,0,null,0]
[null,null,"Iso 24","",null,null,0,null,0]
[null,null,null,null,"Totaal volume isolatie (m3)",null,null,null,{"$f":"G40","v":"0"}]
[null,null,null,null,"Totaal % isolatie met verantwoorde herkomst",null,null,null,{"$f":"IF(ISERROR(SUM(I45:I68)),0,SUM(I45:I68))","v":0}]
[null,null,null,null,"BREEAM-NL credits behaald",null,null,null,{"$f":"IF(I70>=0.799999,1,0)","v":0}]

{"sheet":"Totaal score","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,5],[13,3,13,5]]}
[]
[null,null,null,null,null,null,null,null,"BREEAM-NL Nieuwbouw en Renovatie"]
[]
[null,null,null,null,null,null,null,null,"Totaal score"]
[]
[null,null,null,null,null,null,null,null,"BRL 2014 v1.01 - MAT 5: rekentool"]
[]
[]
[]
[]
[]
[null,null,"A-F ","verantwoorde herkomst materialen hoofdbouwdelen",null,null,{"$f":"Materialen!I480","v":0}]
[]
[null,null,null,"schilisolatie en isolatie van installatieonderdelen",null,null,{"$f":"Isolatie!G10","v":0}]
[]
[null,null,"TOTAAL CREDITS BEHAALD",null,null,null,{"$f":"IF((G12+G14)>4,4,G12+G14)","v":0}]