{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Formulier","Stuf voor UI","Activiteiten","Materiaal","Masten","Armaturen","Electronica","Netbeheer","Indexering","Output"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":159,"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":"Formulier","index":0,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,20,49,21],[3,5,3,6],[4,5,4,6],[5,5,5,6],[8,5,8,6],[22,5,22,6],[34,5,34,6],[13,5,13,6],[11,10,14,12],[18,9,20,12]]}
[null,"Rekenmodel bij het convenant \"Landelijke normering Lichtmastschaden\" 2024 versie 3.11.0"]
[]
[null,"Claim",null,null,null,null,null,null,"Opties"]
[null,null,"Claimant naam",null,null,null,null,null,null,null,"Verkeerstechnisch veiligstellen"]
[null,null,"Claimt namens",null,null,null,null,null,null,null,"Af-/aansluiten netbeheerder"]
[null,null,"Kenmerk van claimant",null,null,null,null,null,null,null,"Netbeheerder"]
[null,null,"Object eigenaar",null,null,null,null,null,null,null,"Inspecteur"]
[null,null,"Datum schade",null,null,null,null,null,null,null,"Verkeersmaatregelen"]
[null,null,"Locatie",null,null,null,null,null,null,null,"WION procedure (KLIC)"]
[null,null,null,null,null,null,null,null,null,null,"Vervuilde Grond Procedure"]
[null,null,"Activiteit"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"OpmerkingBORange","v":""}]
[null,"Lichtmast"]
[null,null,"Nummer / kenmerk"]
[null,null,"Hoogte lichtpunt (meter)"]
[null,null,"Model"]
[null,null,"Materiaal",null,null,null,null,null,"Bijzonderheden"]
[null,null,"Coating",null,null,null,null,null,null,"Toelichting"]
[null,null,"Uithouder(s)"]
[null,null,"Terugplaatsen/vervangen borden"]
[]
[null,"Armatuur",null,null,null,null,null,null,null,null,null,"Prijs"]
[null,null,"Merk en type",null,null,null,null,null,null,{"$f":"IF(PrijsBijzonderheden > 0,\"Specificeer deze post nader in een aparte bijlage.\",\"\")","v":""}]
[null,null,"Model categorie"]
[null,null,"Lichtsoort"]
[null,null,{"$f":"PromptVermLumen","v":"Lichtstroom (lm)"},null,null,null,null,null,"Calculatie"]
[null,null,"Aantal armaturen te vervangen",null,null,null,null,null,null,"Veiligstellen",null,null,{"$f":"VeiligstellenInclusief","v":138.01341799785391}]
[null,null,null,null,null,null,null,null,null,"Schadeherstel",null,null,{"$f":"SchadeherstelInclusief","v":225.84013854194274}]
[null,"Electronica",null,null,null,null,null,null,null,"Schadevaststelling",null,null,{"$f":"SchadevaststellingInclusief","v":180.6721108335542}]
[null,null,"Soort",null,null,null,null,null,null,"Verkeersmaatregelen",null,null,{"$f":"VerkeersmaatregelenInclusief","v":0}]
[null,null,null,null,null,null,null,null,null,"Materiaal",null,null,{"$f":"MateriaalInclusief","v":41.158976958525351}]
[null,null,null,null,null,null,null,null,null,"Netbeheerder",null,null,{"$f":"NetbeheerderInclusief","v":0}]
[null,null,null,null,null,null,null,null,null,"Overige",null,null,{"$f":"OverigeInclusief","v":0}]
[null,null,null,null,null,null,null,null,null,"totaal",null,null,{"$f":"SUM(M27:M33)","v":585.68464433187626}]
[null,"Standaard output map"]
[null,"Invoerscherm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PrijsBijzonderheden > 0,\"Specificeer deze post nader in een aparte bijlage.\",\"\")","v":""}]

{"sheet":"Stuf voor UI","index":1,"n_rows":37,"n_cols":41,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,"Masten",null,null,null,null,null,null,null,"Armaturen"]
[null,"Lengte","Hoogtecategorie","Materiaal","Model","Coating","Uithouder","Uitzetter opties",null,"Armatuurtype","Lichtsoort","Vermogens\nconventioneel","Lichtstroom LED","Opties","Prompt Vermoden / Lichtstroom",null,"Activiteit","Partij","Inspecteur","Verkeersmaatregelen","Verkeersmaatregelen Opties","Bebording","Bebording Opties","Afkoppelen","Afkoppelen Opties","WION","WION Opties","Veiligstellen","Veiligstellen Opties","Netbeheerder","Vervuilde Grond","VervuildeGrond Opties","Aantal armaturen vervangen","Aantal armaturen numeriek","UserInterface","Electronica",null,"Opmerking Botsabsorber","Opmerking vervuilde Grond Procedure"]
[1,"< 5",1,"Aluminium","Historisch","Nee",{"$f":"IF(MastModelKeus=3,H3,\"\")","v":""},"Enkel kort  < 1,5 m",null,{"$f":"Armaturen!B6","v":"Paaltop functioneel"},"Conventioneel","?","?","?",null,null,"Mast Rechtzetten","Provincie","Niet van toepassing",{"$f":"IF(IsOptieActiewagen,U3,\"\")","v":"Niet van toepassing"},"Niet van toepassing",{"$f":"IF(IsOptieBorden,W3,\"\")","v":""},"Niet van toepassing",{"$f":"IF(IsOptieAfkoppelen,Y3,\"\")","v":""},"Niet van toepassing",{"$f":"IF(IsOptieWION,AA3,\"\")","v":""},"Niet van toepassing",{"$f":"IF(IsOptieVeiligstellen,AC3,\"\")","v":"Niet van toepassing"},"Niet van toepassing",{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,1),\"\")","v":""},{"$f":"IF(IsOptieVervuildeGrond,AF3,\"\")","v":""},"Niet van toepassing",{"$f":"IF(OR(ActiviteitKeus=1,ActiviteitKeus=4),\"\",1)","v":1},{"$f":"IF(OR(ActiviteitKeus=1,ActiviteitKeus=4),0,1)","v":1},"Classic","Niet van Toepassing",null,"Bij claimen van een botsabsorber is een foto van de genomen verkeersmaatregelen (inclusief botsabsorber) en/of andere bewijsmaterialen vereist.","De kosten van een Vervuilde Grond Procedure dienen separaat geclaimd te worden."]
[2,"5",2,"Staal","Paaltop","Ja",{"$f":"IF(MastModelKeus=3,H4,\"\")","v":""},"Enkel Lang  > 1,5 m",null,{"$f":"Armaturen!B7","v":"Paaltop decoratief"},"LED",{"$f":"Armaturen!C$5","v":"24-26 W"},{"$f":"Armaturen!C$15","v":"1000-2000"},{"$f":"IF((LichtsoortKeus=1),L4,M4)","v":"1000-2000"},null,null,"Rechtzetten + Armatuur vervangen","Gemeente",{"$f":"IF(PartijKeus<3,\"Ja\",\"Nee\")","v":"Ja"},{"$f":"IF(OR(IsOptieVMGemeenteweg,IsOptieVMProvincieweg),U4,\"\")","v":"Standaard"},"Standaard","","1 Statisch bord",{"$f":"IF(IsOptieAfkoppelen,Y4,\"\")","v":""},"1 gang",{"$f":"IF(IsOptieWION,AA4,\"\")","v":""},"Ja",{"$f":"IF(IsOptieVeiligstellen,AC4,\"\")","v":"Gecombineerd met herstel"},"Gecombineerd met herstel",{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,2),\"\")","v":""},{"$f":"IF(IsOptieVervuildeGrond,AF4,\"\")","v":""},"Quick Scan",{"$f":"IF(OR(ActiviteitKeus=1,ActiviteitKeus=4),\"\",IF(UithouderKeus>2,2,\"\"))","v":""},{"$f":"IF(OR(ActiviteitKeus=1,ActiviteitKeus=4),0,IF(UithouderKeus>2,2,0))","v":0},"Userform",{"$f":"IF(IsOptieElectronica,\"Online connectiviteit\",\"\")","v":"Online connectiviteit"},null,"Bij claimen van Bijzondere Verkeersmaatregelen zijn specificatie en foto's vereist."]
[3,"6",2,"Gietijzer","Uithouder",null,{"$f":"IF(MastModelKeus=3,H5,\"\")","v":""},"Dubbel kort < 1,5 m",null,{"$f":"Armaturen!B8","v":"Koffer functioneel"},null,{"$f":"Armaturen!D$5","v":"32-42 W"},{"$f":"Armaturen!D$15","v":"2000-4000"},{"$f":"IF((LichtsoortKeus=1),L5,M5)","v":"2000-4000"},null,null,"Armatuur vervangen","Aannemer",null,{"$f":"IF(IsOptieActiewagen,U5,\"\")","v":"Actiewagen"},"Actiewagen","","2 Statische borden",{"$f":"IF(IsOptieAfkoppelen,Y5,\"\")","v":""},"2 gangen",null,null,{"$f":"IF(IsOptieVeiligstellen,AC5,\"\")","v":"Los van herstel"},"Los van herstel",{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,3),\"\")","v":""},{"$f":"IF(IsOptieVervuildeGrond,AF5,\"\")","v":""},"Procedure incl. Quick Scan",{"$f":" IF(UithouderKeus  > 2,AK5,\"\")","v":""},null,null,{"$f":"IF(IsOptieElectronica,\"Online connectiviteit + sensor\",\"\")","v":"Online connectiviteit + sensor"},null,null,94109]
[4,"7",2,null,"Design",null,{"$f":"IF(MastModelKeus=3,H6,\"\")","v":""},"Dubbel Lang > 1,5 m",null,{"$f":"Armaturen!B9","v":"Koffer decoratief"},"LED_max",{"$f":"Armaturen!E$5","v":"50-70 W"},{"$f":"Armaturen!E$15","v":"4000-6000"},{"$f":"IF((LichtsoortKeus=1),L6,M6)","v":"4000-6000"},null,null,"Mast vervangen",null,null,{"$f":"IF(IsOptieBotsabsorber,U6,\"\")","v":"Botsabsorber"},"Botsabsorber","","3 Statische borden",null,null,null,null,null,null,{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,4),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(VervuildeGrondKeus=3,AM3,\"\")","v":""},null,93963]
[5,"8",3,null,null,null,null,null,null,{"$f":"Armaturen!B10","v":"Design"},{"$f":"IF(ArmatuurModelKeus<3,3,IF(ArmatuurModelKeus=3,4,IF(ArmatuurModelKeus=6,4,5)))","v":3},{"$f":"Armaturen!F$5","v":"100-150 W"},{"$f":"Armaturen!F$15","v":"6000-8000"},{"$f":"IF((LichtsoortKeus=1),L7,IF(LED_max>3,M7,\" \"))","v":" "},null,null,"Mast en Armatuur vervangen",null,null,{"$f":"IF(AND(IsOptieActiewagen,IsOptieBotsabsorber),U7,\"\")","v":"Botsabsorber + Actiewagen"},"Botsabsorber + Actiewagen","","Dynamische borden",null,null,null,null,null,null,{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,5),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR(VerkeersmaatregelKeus=4,VerkeersmaatregelKeus=5),AL3,IF(VerkeersmaatregelKeus=7,AL4,\"\"))","v":""}]
[6,9,3,null,null,null,null,null,null,{"$f":"Armaturen!B11","v":"Historisch"},null,{"$f":"Armaturen!G$5","v":"250-400 W"},{"$f":"Armaturen!G$15","v":"> 8000"},{"$f":"IF((LichtsoortKeus=1),L8,IF(LED_max=5,M8,\" \"))","v":" "},null,null,null,null,null,{"$f":"IF(IsOptieVerkeersregelaars,U8,\"\")","v":"Inzet Verkeersregelaars"},"Inzet Verkeersregelaars","","Statische en dynamische borden",null,null,null,null,null,null,{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,6),\"\")","v":""}]
[7,10,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IsOptieBijzVerkMaatr,U9,\"\")","v":""},"Bijzondere verkeersmaatregelen",null,null,null,null,null,null,null,null,{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,7),\"\")","v":""}]
[8,11,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(IsOptieAfkoppelen,Afkoppelkeus>1),INDEX(Netbeheerders,8),\"\")","v":""}]
[9,">11",5]
[]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1,null,1,null,1,null,1,1,null,null,{"$f":"IF(AH4>0,2,IF(AH3>0,1,0))","v":1}]
[null,2,{"$f":"INDEX(MasthoogtenRange, Lengtekeus, 2)","v":2},null,null,null,{"$f":"MAX(UithouderKeusTmp,1)","v":1},null,null,null,null,"Keus","Default","Vermogen",null,null,null,null,null,{"$f":"MAX(UKVerkeersmaatregel,1)","v":1},null,{"$f":"MAX(UKBebording,1)","v":1},null,{"$f":"MAX(UKAfkoppelen,1)","v":1},null,{"$f":"MAX(UKWION,1)","v":1},null,{"$f":"MAX(UKVeiligstellen,1)","v":1},null,{"$f":"MAX(UKNetbeheerder,1)","v":1},{"$f":"MAX(UKVervGrond,1)","v":1},null,null,1,1]
["Gekozen: ",{"$f":"C14","v":2},null,1,2,1,{"$f":"IF(MastModelKeus=3,G14,1)","v":1},null,null,1,2,6,{"$f":"HoogteKeus","v":2},{"$f":"IF(VermogenKeus=1,VermogenDefault,VermogenKeus-1)","v":5},{"$f":"IF(LichtsoortKeus=1,\"Vermogen (W)\",IF(LichtsoortKeus=2,\"Lichtstroom (lm)\",\" \"))","v":"Lichtstroom (lm)"},null,2,2,1,{"$f":"IF(INDEX(VerkeersmaatregelRange,T14,) > \"\",T14, 1)","v":1},null,{"$f":"IF(INDEX(BebordingRange,V14,) > \"\",V14, 1)","v":1},null,{"$f":"IF(INDEX(AfkoppelenRange,X14,) > \"\",X14, 1)","v":1},null,{"$f":"IF(INDEX(WIONRange,Z14,) > \"\",Z14, 1)","v":1},null,{"$f":"IF(INDEX(VeiligstellenRange,AB14,) > \"\",AB14, 1)","v":1},{"$f":"ROUND(SUM(Activiteiten!C8:K55)+SUM(Activiteiten!M8:Q29)+SUM(Activiteiten!M33:Q33)+SUM(Activiteiten!M39:Q48) +SUM(Activiteiten!M54:Q55)+SUM(ArrayBorden) +SUM(EengangRange) +SUM(TweegangRange)+SUM(ArrayMasten)+SUM(ArrayCoating)+SUM(ArrayUithouders)+SUM(Armaturen!C6:G11)+SUM(Armaturen!C16:G21),0)","v":94109},{"$f":"IF(INDEX(Netbeheerders,AD14,) > \"\",AD14, 1)","v":1},{"$f":"IF(INDEX(VervuildeGrondRange,AE14,) > \"\",AE14, 1)","v":1},null,null,{"$f":"MIN(AantalArmaturenDefault,UKAantalArmaturen)","v":1},1,1]
[]
["Verwerking",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Groene velden",null,"beveiligen tegen 0 waarden vanuit het userform"]
[]
[]
[]
[]
["Om te schakelen tussen 'Classic' en 'Userform'",null,null,null,"Classic","Userform"]
["PrijsBijz",{"$f":"IF(UserInterfaceKeus=1,PrijsBijzClassic,PrijsBijzUserform)","v":0},null,null,{"$f":"PrijsBijzonderheden","v":0},0]
["rDefOutputfolder",{"$f":"IF(UserInterfaceKeus=1,E34,F34)","v":"StandaardOutputFolder"},null,null,"StandaardOutputFolder","DefaultOutputFolder"]
["rKenmerkVeld",{"$f":"IF(UserInterfaceKeus=1,E35,F35)","v":"ClaimnummerRange"},null,null,"ClaimnummerRange","OpKenmerk"]
["rArmatuurKenmerk",{"$f":"IF(UserInterfaceKeus=1,E36,F36)","v":"ArmatuurMerkTypeRange"},null,null,"ArmatuurMerkTypeRange","OpArmatuurMerk"]
["rOutputWorksheet",{"$f":"IF(UserInterfaceKeus=1,E37,F37)","v":"Output"},null,null,"Output","Output"]

{"sheet":"Activiteiten","index":2,"n_rows":59,"n_cols":31,"rows_kept":59,"cut":false,"hidden":true,"merged":[[2,23,3,23],[5,0,5,16],[2,22,3,22],[2,9,3,9],[2,10,3,10],[2,2,3,2],[2,5,3,5],[2,4,3,4],[2,8,3,8],[2,6,3,6],[2,7,3,7],[2,21,3,21],[2,3,3,3],[50,12,50,16],[35,12,35,16],[36,12,36,16],[2,19,3,19],[2,20,3,20],[29,12,29,16],[37,12,37,16]]}
[null,"kolomnummer",3,4,5,6,7,8,9,10,11,10,13,14,15,16,17]
[null,"categorie",1,2,3,4,5,1,2,3,4,null,1,2,3,4,5]
[null,null,"Rechtzetten","Rechtzetten & Arm. Wisselen","Armatuur wisselen","Mast wisselen","Mast en Arm. wisselen","Provincie","Gemeente","Aannemer","Toekomst",null,null,null,null,null,null,null,null,"Activiteit","Partij","Is Optie Ja/Nee","Keuze: Ja/Nee","Tarief"]
["Hoofdindeling","Component",null,null,null,null,null,null,null,null,null,null,"<5","5, 6, 7","8, 9","10, 11","> 11",null,null,null,null,null,null,null,null,null,null,null,null,"Waarde","Kolom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Act",{"$f":"IF(VerwerkingKeus=1,ActiviteitKeus,ActiviteitKoppeling)","v":2},{"$f":"Act+2","v":4}]
["Vaste kosten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partij",{"$f":"IF(VerwerkingKeus=1,PartijKeus,PartijKoppeling)","v":2},{"$f":"Partij+7","v":9}]
["Veiligstellen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoogte",{"$f":"IF(VerwerkingKeus=1,HoogteKeus,HoogteKoppeling)","v":2},{"$f":"Hoogte+12","v":14}]
["Veiligstellen","Intake en administratieve verwerking door de gemeente",1,1,1,1,1,1,1,null,null,null,20,20,20,20,20,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,null,{"$f":"T8*U8*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":20}]
["Veiligstellen","Intake en administratieve verwerking door de aannemer",1,1,1,1,1,1,1,1,null,null,15,15,15,15,15,null,null,1,1,null,null,15]
["Veiligstellen","Aanrijkosten aannemer",1,1,1,1,1,1,1,1,null,null,70,70,70,70,70,null,null,1,1,null,null,70]
["Veiligstellen","Fotografisch vastleggen van de schade en invullen schadeopnameformulier",1,1,1,1,1,1,1,1,null,null,5,5,5,5,5,null,null,1,1,null,null,5]
["Veiligstellen","Verkeerstechnisch veiligstellen",null,1,1,1,1,1,1,1,null,null,40,45,50,55,65,null,null,1,1,{"$f":"T12*U12","v":1},{"$f":"MAX(VeiligstellenKeus -2,0)","v":0},{"$f":"IsOptieVeiligstellen*W12*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0},null,"Alleen van toepassing als optie 'Los van herstel' gekozen is"]
["Veiligstellen","Elektrisch veiligstellen",null,null,null,1,1,1,1,1,null,null,25,25,25,25,25,null,null,0,1,{"$f":"T13*U13","v":0},null,{"$f":"IsOptieVeiligstellen*V13*W12*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0},null,"Is afhankelijk van al dan niet verkeerstechnisch veiligstellen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A7","v":"Veiligstellen"},null,null,null,null,null,{"$f":"SUM(X8:X14)","v":110}]
["Schadeherstel"]
["Schadeherstel","Technisch werkvoorbereiding door aannemer",null,1,1,1,1,1,1,1,null,null,45,45,45,45,45,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,null,{"$f":"T16*U16*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":45}]
["Schadeherstel","Ter plaatse gaan van personeel en materiaal",1,1,1,1,1,1,1,1,null,null,60,60,60,60,60,null,null,1,1,null,null,60]
["Schadeherstel","Openbreken van de bodembedekking",null,null,null,1,1,1,1,1,null,null,5,5,5,5,5,null,null,0,1,null,null,0]
["Schadeherstel","Rechtzetten mast",1,1,null,null,null,1,1,1,null,null,25,50,75,100,125,null,null,1,1,null,null,50]
["Schadeherstel","Verwijderen lichtmast",null,null,null,1,1,1,1,1,null,null,20,25,30,50,75,null,null,0,1,null,null,0]
["Schadeherstel","Monteren of overzetten lamp en armatuur",null,1,1,1,1,1,1,1,null,null,25,25,25,25,25,null,null,1,1,null,null,25]
["Sohadeherstel","Plaatsen van de lichtmast",null,null,null,1,1,1,1,1,null,null,40,60,75,125,125,null,null,0,1,null,null,0]
["Schadeherstel","Monteren bedrading",null,null,null,1,1,1,1,1,null,null,15,15,15,15,15,null,null,0,1,null,null,0]
["Schadeherstel","Afvullen van de lichtmast met zand onder het zekeringluik",null,null,null,1,1,1,1,1,null,null,5,5,5,5,5,null,null,0,1,null,null,0]
["Schadeherstel","Aanbrengen objectnummer",null,null,null,1,1,1,1,1,null,null,5,5,5,5,5,null,null,0,1,null,null,0]
["Schadeherstel","Afvoeren van beschadigd materiaal",null,null,null,1,1,1,1,1,null,null,20,20,30,40,50,null,null,0,1,null,null,0]
["Schadeherstel","Muteren beheerbestand gemeente",null,null,1,1,1,1,1,1,null,null,15,15,15,15,15,null,null,0,1,null,null,0]
["Schadeherstel","Opzichter gemeente/directievoerder checkt uitvoering werkzaamheden",null,1,1,1,1,null,1,null,null,null,25,25,25,25,25,null,null,1,1,null,{"$f":"IF(VerwerkingKeus=1,InspecteurKeus-1,0)","v":0},{"$f":"T28*U28*W28*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Schadeherstel","Inspecteur provinciale weg (Kantonier)",1,1,1,1,1,1,null,null,null,null,100,100,100,100,100,null,null,1,0,null,{"$f":"IF(VerwerkingKeus=1,InspecteurKeus-1,0)","v":0},{"$f":"T29*U29*W29*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Schadeherstel","Terugplaatsen of vervangen van bebording aan lichtmast",null,null,null,1,1,1,1,1,null,null,{"$f":"IsOptieBorden*INDEX(ArrayBorden,BebordingKeus)","v":0},null,null,null,null,null,null,0,1,{"$f":"T30*U30","v":0},null,{"$f":"M30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A15","v":"Schadeherstel"},null,null,null,null,null,{"$f":"SUM(X16:X31)","v":180}]
["Schadevaststelling"]
["Schadevaststellingskosten","Vaste post schadevaststelling",1,1,1,1,1,1,1,1,null,null,144,144,144,144,144,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,false,{"$f":"T33*U33*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":144}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A32","v":"Schadevaststelling"},null,null,null,null,null,{"$f":"SUM(X33:X34)","v":144}]
["Materiaal"]
["Levering Materiaal","Lichtmast",null,null,null,1,1,1,1,1,null,null,{"$f":"Totaal_Mast","v":0},null,null,null,null,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":0},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,null,{"$f":"T36*U36*M36","v":0}]
["Levering Materiaal","Armatuur (inclusief verwijderingsbijdrage)",null,1,1,null,1,1,1,1,null,null,{"$f":"Totaal_Armatuur","v":0},null,null,null,null,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,null,{"$f":"T37*U37*M37","v":0}]
["Levering Materiaal","Electronica",null,1,1,1,1,1,1,1,null,null,{"$f":"Totaal_Electronica","v":0},null,null,null,null,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,null,{"$f":"T38*U38*M38","v":0}]
["Vast materiaal","Aansluitkast",null,null,null,1,1,1,1,1,null,null,40,40,40,40,40,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":0},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,null,{"$f":"T39*U39*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Vast materiaal","Klein materiaal",null,1,1,1,1,1,1,1,null,null,30,30,30,30,30,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},null,null,{"$f":"T40*U40*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A35","v":"Materiaal"},null,null,null,null,null,{"$f":"SUM(X36:X41)","v":30}]
["Verkeersmaatregelen"]
["Veiligstellen en herstel","Verkeersmaatregelen gemeenteweg",null,1,1,1,1,null,1,1,null,null,null,60,60,60,60,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColHoogte)),0,T43*U43)","v":1},{"$f":"IF(VerkeersmaatregelKeus>1,1,0)","v":0},{"$f":"IsOptieVMGemeenteweg*W43*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Veiligstellen en herstel","Verkeersmaatregelen provinciale weg",1,1,1,1,1,1,null,null,null,null,null,100,100,100,100,null,null,1,0,0,{"$f":"IF(VerkeersmaatregelKeus>1,1,0)","v":0},{"$f":"IsOptieVMProvincieweg*W44*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Veiligstellen en herstel","Inzet Actiewagen",1,1,1,1,1,1,1,1,null,null,100,100,100,100,100,null,null,1,1,1,{"$f":"IF(OR(VerkeersmaatregelKeus=3, VerkeersmaatregelKeus=5),1,0)","v":0},{"$f":"IsOptieActiewagen*W45*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Veiligstellen en herstel","Inzet Botsabsorber",null,1,1,1,1,1,1,1,null,null,null,450,450,450,450,null,null,1,1,1,{"$f":"IF(OR(VerkeersmaatregelKeus=4, VerkeersmaatregelKeus=5),1,0)","v":0},{"$f":"IsOptieBotsabsorber*W46*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Veiligstellen en herstel","Inzet Verkeersregelaars",1,1,1,1,1,1,1,1,null,null,100,100,100,100,100,null,null,1,1,1,{"$f":"IF(VerkeersmaatregelKeus=6,1,0)","v":0},{"$f":"IsOptieVerkeersregelaars*W47*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Veiligstellen en herstel","Bijzondere verkeersmaatregelen",1,1,1,1,1,1,null,null,null,null,900,900,900,900,900,null,null,1,0,0,{"$f":"IF(VerkeersmaatregelKeus=7,1,0)","v":0},{"$f":"IsOptieBijzVerkMaatr*W48*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A42","v":"Verkeersmaatregelen"},null,null,null,null,null,{"$f":"SUM(X43:X49)","v":0}]
["Netbeheerder"]
["Schadeherstel","Af - en aansluiten netwerk",null,null,null,1,1,1,1,1,null,null,{"$f":"NetbeheerTarief","v":0},null,null,null,null,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":0},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},{"$f":"T51*U51","v":0},null,{"$f":"IsOptieAfkoppelen*NetbeheerTarief","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A50","v":"Netbeheerder"},null,null,null,null,null,{"$f":"SUM(X51:X52)","v":0}]
["Bijzondere kosten"]
["Heraansluiting","Kosten meldingsprocedure netwerkbeheerder WION (Klic melding)",null,null,null,1,1,1,1,1,null,null,{"$f":"45*IndexArbeid","v":56.460034635485684},56.460034635485684,56.460034635485684,56.460034635485684,56.460034635485684,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":0},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},{"$f":"T54*U54","v":0},{"$f":"MAX(WIONKeus-1,0)","v":0},{"$f":"IsOptieWION*W54*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
["Schadeherstel","Vervuilde Grond procedure Quick Scan ",null,null,null,1,1,1,1,1,null,null,56.460034635485684,56.460034635485684,56.460034635485684,56.460034635485684,56.460034635485684,null,null,{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColAct)),0,1)","v":0},{"$f":"IF(ISBLANK(INDEX(ArrayActiviteiten,ROW(),ColPartij)),0,1)","v":1},{"$f":"T55*U55","v":0},{"$f":"IF(VervuildeGrondKeus>1,1,0)","v":0},{"$f":"IsOptieVervuildeGrond*W55*INDEX(ArrayActiviteiten,ROW(),ColHoogte)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PrijsBijz","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A53","v":"Bijzondere kosten"},null,null,null,null,null,{"$f":"SUM(X54:X57)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal",null,null,null,null,null,{"$f":"SUM(Y8:Y57)","v":464}]

{"sheet":"Materiaal","index":3,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Materiaal"]
[]
[null,null,"Ja/Nee","Hoogte","Model","Materiaal","Lichtsoort","Lichtstroom/ Vermogen","Aantal","Type","Kosten","Totaal"]
[null,"Mast",{"$f":"MastJaNee","v":0},{"$f":"HoogteKeus","v":2},{"$f":"MastModelKeus","v":2},{"$f":"MateriaalKeus","v":1},null,null,null,null,{"$f":"INDEX(ArrayMasten,MateriaalKeus,(HoogteKeus-1)*4+MastModelKeus)","v":295},{"$f":"C4*K4","v":0}]
[null,"Coating",{"$f":"CoatingKeus-1","v":0},null,null,null,null,null,null,null,{"$f":"C5*INDEX(ArrayCoating,,HoogteKeus)","v":0},{"$f":"C4*C5*K5","v":0}]
[null,"Uithouder",{"$f":"IF(MastModelKeus=3,1,0)","v":0},null,{"$f":"UithouderKeus","v":1},null,null,null,null,null,{"$f":"IF(UithouderKeus,INDEX(ArrayUithouders,UithouderKeus,),0)","v":75},{"$f":"C4*C6*K6","v":0},null,"regel","kolom","prijs"]
[null,"Armatuur",{"$f":"ArmatuurJaNee","v":1},null,{"$f":"ArmatuurModelKeus","v":1},null,{"$f":"LichtsoortKeus","v":2},{"$f":"VermogenFinal","v":5},{"$f":"AantalArmaturenKeus","v":1},null,{"$f":"IF(C7,INDEX(ArrayArmaturen,1+(G7-1)*10+E7,H7),0)","v":0},{"$f":"I7*K7","v":0},null,{"$f":"E7+1+(G7-1)*10","v":12},{"$f":"H7","v":5},{"$f":"INDEX(ArrayArmaturen,N7,O7)","v":0}]
[null,"Electronica",null,null,null,null,null,null,null,{"$f":"ElectronicaKeus","v":1},{"$f":"INDEX(ArrayElectronica,J8,)","v":0},{"$f":"K8/1.37196589861751","v":0}]
[]
[null,"Totaal Mast",{"$f":"SUM(L4:L6)","v":0}]
[null,"Totaal Armatuur",{"$f":"L7","v":0}]
[null,"Totaal Electronica",{"$f":"L8","v":0}]

{"sheet":"Masten","index":4,"n_rows":26,"n_cols":35,"rows_kept":26,"cut":false,"hidden":true,"merged":[[3,18,3,21],[2,0,2,1],[3,2,3,5],[3,6,3,9],[3,10,3,13],[3,14,3,17]]}
["Masten"]
[]
["Hoogte categorie",null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5]
[null,null,"< 5 m",null,null,null,"5 - 7 m",null,null,null,"8 en 9 m",null,null,null,"9-11 m",null,null,null,"> 11 m"]
[null,null,"Historisch","Paaltop","Uithouder","Design","Historisch","Paaltop","Uithouder","Design","Historisch","Paaltop","Uithouder","Design","Historisch","Paaltop","Uithouder","Design","Historisch","Paaltop","Uithouder","Design",null,null,null,null,null,null,null,null,null,null,null,"X","Y"]
[1,"Alu",null,215,215,1000,null,295,295,1200,null,545,545,1400,null,685,685,1600,null,985,985,1800,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X_offset+(AA8-1)*4+AB8","v":-4},{"$f":"Y_offset+AC8","v":0}]
[2,"Staal",null,210,210,1000,null,300,290,1200,null,480,470,1400,null,625,610,1600,null,880,870,1800]
[3,"Gietijzer",1300,510,510,1000,1800,null,1500,1200,2000,null,2000,1400,null,null,2000,1600,null,null,null,1800]
[]
["Coating"]
[null,"Hoogte",1,2,3,4,5]
[null,"Prijs",50,75,100,115,135]
[]
["Uithouders"]
[1,"Enkel kort",75]
[2,"Enkel Lang",85]
[3,"Dubbel kort",185]
[4,"Dubbel Lang",200]
[]
["Borden"]
[1,"Geen",0]
[2,"Statisch 1",5]
[3,"Statisch 2",10]
[4,"Statisch 3",15]
[5,"Dynamisch",10]
[6,"Sta & Dyn",15]

{"sheet":"Armaturen","index":5,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Armaturen"]
[]
[null,"Conventioneel"]
[null,null,1,2,3,4,5]
[null,"Vermogen (W)","24-26 W","32-42 W","50-70 W","100-150 W","250-400 W"]
[1,"Paaltop functioneel",225,280,330,380,430]
[2,"Paaltop decoratief",225,280,330,380,430,null,"even duur als functioneel"]
[3,"Koffer functioneel",265,280,330,380,430]
[4,"Koffer decoratief",265,280,330,380,430,null,"even duur als functioneel"]
[5,"Design",1000,1000,1000,1000,1000]
[6,"Historisch",850,850,850,850,850]
[]
[null,"LED"]
[null,null,1,2,3,4,5]
[null,"Lichtstroom (lm)","1000-2000","2000-4000","4000-6000","6000-8000","> 8000"]
[1,{"$f":"B6","v":"Paaltop functioneel"},200,250,300,0,0,null,"grijze velden: niet van toepassing"]
[2,{"$f":"B7","v":"Paaltop decoratief"},300,350,400,0,0]
[3,"Koffer functioneel",200,250,300,350,0]
[4,"Koffer decoratief",300,350,400,450,1100]
[5,"Design",700,800,900,1000,1100]
[6,"Historisch",1500,1500,1750,1900,0]

{"sheet":"Electronica","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Elektronica"]
[]
[null,"Soort","Prijs (2024)"]
[1,{"$f":"INDEX(ElectronicaRange,1,)","v":"Niet van Toepassing"},0]
[2,"Online connectiviteit",245]
[3,"Online connectiviteit + sensor",265]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Netbeheer","index":7,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Netbeheer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Datum laatste aanpassing tarieven",null,null,null,"2024-02-19"]
[]
[null,null,null,null,null,null,null,null,null,null,"2017 (geindexeerd)"]
[null,"Naam","1 gang","2 gangen",null,"Gekozen Tarief",null,null,null,null,"Naam","1 gang","2 gangen"]
[null," ",0,0,1,{"$f":"IF(Afkoppelkeus=2,INDEX(EengangRange,NetbeheerderKeus),IF(Afkoppelkeus=3,INDEX(TweegangRange,NetbeheerderKeus),0))","v":0},null,null,null,null," ",0,0]
[null,"Eigen net / 16C",186.7572478998232,186.7572478998232,2,null,null,null,null,null,"Eigen net / 16C",128.63,128.63]
[null,"Coteq Elektriciteit",344.72,344.72,3,null,null,null,null,null,"Coteq Elektriciteit",344.72,344.72]
[null,"Enexis",169.79,293.17,4,null,null,null,null,null,"Enduris",351.92,351.92]
[null,"Liander",360.09,447.25,5,null,null,null,null,null,"Enexis",135.83000000000001,164.64]
[null,"Rendo Netwerken",184.32,315,6,null,null,null,null,null,"Liander",378.67,652.39]
[null,"Stedin",255.16,510.32,7,null,null,null,null,null,"Rendo Netwerken",315.89999999999998,445.56]
[null,"Westland Infra",171,304,8,null,null,null,null,null,"Stedin",249.02,499.07]
[null,null,null,null,null,null,null,null,null,null,"Westland Infra",242.84,242.84]
[]
[]
[null,null,null,null,null,null,null,null,null,null,2023]
[null,null,null,null,null,null,null,null,null,null,"Naam","1 gang","2 gangen"]
[null,null,null,null,null,null,null,null,null,null," ",0,0]
[null,null,null,null,null,null,null,null,null,null,"Eigen net / 16C",148.85,148.85]
[null,null,null,null,null,null,null,null,null,null,"Coteq Elektriciteit",344.72,344.72]
[null,null,null,null,null,null,null,null,null,null,"Enexis",164.84,284.63]
[null,null,null,null,null,null,null,null,null,null,"Liander",344.44,429.06]
[null,null,null,null,null,null,null,null,null,null,"Rendo Netwerken",184.32,315]
[null,null,null,null,null,null,null,null,null,null,"Stedin",247.73,495.46]
[null,null,null,null,null,null,null,null,null,null,"Westland Infra",171,304]

{"sheet":"Indexering","index":8,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Indexering"]
[null,"Index jaar",2024,2024,2024,null,null,null,"Calculatie 2024"]
[null,"Index nummer",1,2,3,4,5,null,"Index","2023 convenant","CBS\ndecember 2022","CBS\ndecember 2023","verhoging tov dec 2022","2024 convenant"]
[null,"Index naam","Arbeid","Materiaal","Netbeheer","Geen","Geen",null,"Arbeid",1.1727799142421464,1.246,1.3330000000000002,{"$f":"L4/K4","v":1.0698234349919744},{"$f":"J4*M4","v":1.2546674363441264}]
[null,"Index waarde",{"$f":"N4","v":1.2546674363441264},{"$f":"N5","v":1.3719658986175116},1,1,1,null,"Materiaal",1.399346543778802,1.431,1.403,{"$f":"L5/K5","v":0.98043326345213133},{"$f":"J5*M5","v":1.3719658986175116}]
[]
[]
[null,null,"Index","kosten excl index","inclusief index"]
[null,"Veiligstellen",1,{"$f":"Veiligstellen","v":110},{"$f":"D9*LOOKUP(C9,IndexNummers,IndexWaarden)","v":138.01341799785391}]
[null,"Schadeherstel",1,{"$f":"Schadeherstel","v":180},225.84013854194274]
[null,"Schadevaststelling",1,{"$f":"Schadevaststelling","v":144},180.6721108335542]
[null,"Verkeersmaatregelen",1,{"$f":"Verkeersmaatregelen","v":0},0]
[null,"Netbeheerder",3,{"$f":"Netbeheerder","v":0},0]
[null,"Materiaal",2,{"$f":"Materiaal","v":30},41.158976958525351]
[null,"Overige",3,{"$f":"Overige","v":0},0]
[]
[null,null,null,null,{"$f":"SUM(E9:E16)","v":585.68464433187626}]
[]
[null,"Laatste aanpassing ",null,"2023-02-27"]

{"sheet":"Output","index":9,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":true,"merged":[[1,1,2,1],[45,4,50,7]]}
[null,null,null,"Claim"]
[null,null,null,null,null,"Claimant naam",null,{"$f":"OpClaimant","v":""}]
[null,null,null,null,null,"Claimt namens",null,{"$f":"OpNamens","v":""}]
[null,null,null,null,null,"Kenmerk van claimant",null,{"$f":"OpKenmerk","v":""}]
[null,null,null,null,null,"Object eigenaar",null,{"$f":"INDEX(PartijRange,PartijKeus,)","v":"Gemeente"}]
[null,null,null,null,null,"Datum schade",null,{"$f":"OpDatum","v":"00:00:00"}]
[null,null,null,null,null,"Locatie",null,{"$f":"OpLocatie","v":0}]
[]
[null,null,null,null,null,"Activiteit",null,{"$f":"INDEX(ActiviteitRange,ActiviteitKeus,)","v":"Rechtzetten + Armatuur vervangen"}]
[]
[null,null,null,"Lichtmast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output Folder",null,""]
[null,null,null,null,null,"Nummer / kenmerk",null,{"$f":"OpNummer","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Claimant",null,""]
[null,null,null,null,null,"Hoogte lichtpunt (m)",null,{"$f":"INDEX(LengteRange,Lengtekeus,)","v":"5"},null,null,null,null,null,null,null,null,null,null,null,null,"Namens",null,""]
[null,null,null,null,null,"Model",null,{"$f":"INDEX(MastModelRange,MastModelKeus,)","v":"Paaltop"},null,null,null,null,null,null,null,null,null,null,null,null,"Kenmerk",null,""]
[null,null,null,null,null,"Materiaal",null,{"$f":"INDEX(MateriaalRange,MateriaalKeus,)","v":"Aluminium"},null,null,null,null,null,null,null,null,null,null,null,null,"Datum"]
[null,null,null,null,null,"Coating",null,{"$f":"INDEX(NeeJaRange,CoatingKeus,)","v":"Nee"},null,null,null,null,null,null,null,null,null,null,null,null,"Locatie"]
[null,null,null,null,null,"Uithouder(s)",null,{"$f":"INDEX(UithouderRange,UithouderKeus,)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Nummer"]
[null,null,null,null,null,"Terugplaatsen vervangen borden",null,{"$f":"INDEX(BebordingRange,BebordingKeus,)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"ArmatuurMerk",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BijzToelichting"]
[null,null,null,"Armatuur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BijzPrijs",null,0]
[null,null,null,null,null,"Merk en type",null,{"$f":"OpArmatuurMerk","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Electronica"]
[null,null,null,null,null,"Model categorie",null,{"$f":"INDEX(ArmatuurModelRange,ArmatuurModelKeus,)","v":"Paaltop functioneel"}]
[null,null,null,null,null,"Lichtsoort",null,{"$f":"INDEX(LichtsoortRange,LichtsoortKeus,)","v":"LED"}]
[null,null,null,null,null,{"$f":"IF(LichtsoortKeus = 1, \"Vermogen (W)\",\"Lichtstroom (lm)\")","v":"Lichtstroom (lm)"},null,{"$f":"INDEX(VermogenOptieRange,VermogenFinal + 1,)","v":" "}]
[null,null,null,null,null,"Aantal vervangen",null,{"$f":"IFERROR(INDEX(AantalArmaturenRange,AantalArmaturenKeus,),0)","v":1}]
[]
[null,null,null,"Electronica"]
[null,null,null,null,null,"Soort",null,{"$f":"INDEX(ElectronicaRange,ElectronicaKeus,)","v":"Niet van Toepassing"}]
[]
[null,null,null,"Opties"]
[null,null,null,null,null,"Verkeerstechnisch veiligstellen",null,{"$f":"INDEX(VeiligstellenRange,VeiligstellenKeus,)","v":"Niet van toepassing"}]
[null,null,null,null,null,"Af-/aansluiten netbeheerder",null,{"$f":"INDEX(AfkoppelenRange,Afkoppelkeus,)","v":""},null,null,null,null,{"$f":"IF(OpmerkingBORange>\"\",\"Zie specificatie en foto in bijlage\",\"\")","v":""}]
[null,null,null,null,null,"Netbeheerder",null,{"$f":"INDEX(NetbeheerRange,NetbeheerderKeus,)","v":""}]
[null,null,null,null,null,"Inspecteur",null,{"$f":"INDEX(InspecteurRange,InspecteurKeus,)","v":"Niet van toepassing"},null,null,null,null,{"$f":"IF(OpmerkingVGPRange>\"\", \"Wordt separaat geclaimd\",\"\")","v":""}]
[null,null,null,null,null,"Verkeersmaatregelen",null,{"$f":"INDEX(VerkeersmaatregelRange,VerkeersmaatregelKeus,)","v":"Niet van toepassing"}]
[null,null,null,null,null,"WION procedure (KLIC)",null,{"$f":"INDEX(WIONRange,WIONKeus,)","v":""}]
[null,null,null,null,null,"Vervuilde grond procedure",null,{"$f":"INDEX(VervuildeGrondRange,VervuildeGrondKeus,)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stuf voor UI'!$AC$15<>'Stuf voor UI'!$AM$5,\"Eigen risico\",\"\")","v":""}]
[]
[]
[null,null,null,"Bijzonderheden",null,null,null,null,null,"Calculatie"]
[null,null,null,null,"Prijs",null,null,{"$f":"PrijsBijz","v":0},null,null,"Veiligstellen",null,{"$f":"VeiligstellenInclusief","v":138.01341799785391}]
[null,null,null,null,"Toelichting",null,null,null,null,null,"Schadeherstel",null,{"$f":"SchadeherstelInclusief","v":225.84013854194274}]
[null,null,null,null,{"$f":"OpBijzToelichting","v":0},null,null,null,null,null,"Schadevaststelling",null,{"$f":"SchadevaststellingInclusief","v":180.6721108335542}]
[null,null,null,null,null,null,null,null,null,null,"Verkeersmaatregelen",null,{"$f":"VerkeersmaatregelenInclusief","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Materiaal",null,{"$f":"MateriaalInclusief","v":41.158976958525351}]
[null,null,null,null,null,null,null,null,null,null,"Netbeheer",null,{"$f":"NetbeheerderInclusief","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Overige",null,{"$f":"OverigeInclusief","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Totaal",null,{"$f":"TotaalInclusief","v":585.68464433187626}]