{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Aanvraagformulier videodiensten","Compatible videosystemen","Video Security Systeem","Zone ind. en actiename","Immix Videoprijslijst SMC 2024","Validatielijsten"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":14,"comments":1,"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":"Aanvraagformulier videodiensten","index":0,"n_rows":73,"n_cols":17,"rows_kept":73,"cut":false,"hidden":false,"merged":[[17,2,17,5],[0,0,0,8],[12,0,12,2],[12,3,12,5],[7,3,7,5],[6,8,6,9],[11,0,11,2],[6,3,6,5],[11,6,11,9],[7,0,7,2],[8,3,8,5],[6,6,6,7],[6,0,6,2],[10,0,10,2],[8,0,8,2],[12,8,12,9],[12,6,12,7],[8,8,8,9],[13,6,13,7],[13,8,13,9],[4,0,4,2],[5,0,5,2],[4,3,4,5],[5,3,5,5],[13,0,13,2],[9,3,9,5],[11,3,11,5],[8,6,8,7],[9,6,9,7],[10,3,10,5],[10,6,10,9],[9,8,9,9],[1,0,2,7],[4,6,4,7],[5,6,5,7],[4,8,4,9],[5,8,5,9],[67,0,67,5],[67,6,67,9],[28,8,28,9],[24,8,24,9],[27,8,27,9],[33,8,33,9],[66,4,66,5],[66,7,66,9],[40,8,40,9],[30,10,30,11],[46,0,51,5],[46,6,51,9],[31,8,31,9],[35,8,35,9],[72,0,73,9],[70,0,70,9],[71,0,71,9],[68,0,69,5],[68,6,69,9],[21,8,21,9],[22,8,22,9],[25,8,25,9],[43,0,44,9],[45,0,45,5],[21,3,21,6],[24,3,24,4],[27,3,27,4]]}
["Aanvraagformulier SMC IMMIX Videodiensten 2024 versie 2024 IM ",null,null,null,null,null,null,null,null,"V1.00"]
["Aanvraagformulier SMC Videodiensten mailen naar: isupport@smc-alarmcentrale.nl "]
[]
["RISICOADRES",null,null,null,null,null,"GEGEVENS INSTALLATEUR"]
["Naam:",null,null,null,null,null,"Naam installateur:"]
["Adres:",null,null,null,null,null,"Installateurnummer:"]
["Postcode:",null,null,null,null,null,"Naam monteur:"]
["Woonplaats:",null,null,null,null,null,"TECHNISCHE GEGEVENS (DVR / NVR / IP Camera)"]
["Telefoonnummer:",null,null,null,null,null,"Merk videosysteem:"]
["E-mail:",null,null,null,null,null,"Type:"]
["Contactpersoon:",null,null,null,null,null,"Video ontvangst keuze"]
["KvK-nummer (m.u.v. particulier):",null,null,null,null,null,"IMMIX compatible videosysteem"]
["Gekoppeld aan aansluitnr.   :"]
["Factuuradres                              : ",null,null,"Conform alarmaansluiting"]
["Invulformulier"]
["Op deze aanvraag zijn aparte contractuele afspraken van toepassing",null,null,null,null,null,null,"Keuze:",null,null,false,{"$f":"LEN(K16)","v":6}]
["Basis video aansluiting"]
["Aantal Camera's",null,{"$f":"IF(H18=\"> 80 camera's in overleg\",\"Neeem contact op met Customer Care\",\"\")","v":""},null,null,null,"Keuze: ","1-4 camera's",null,{"$f":"VLOOKUP(H18,Validatielijsten!A:B,2,FALSE)","v":375}]
["Is er een koppeling met een SMC inbraakabonnement met doormelding",null,null,null,null,null,"Keuze: ","Ja",null,{"$f":"IF(H19=\"nee\",300,0)","v":0}]
[]
["Opties",null,null,"Keuze"]
["- Afhandeling video-alarm",null,null,null,null,null,null,{"$f":"IF(M24<2,\"Prijs per minuut\",\"\")","v":"Prijs per minuut"},{"$f":"IF(M24<2,2.36,\"\")","v":2.36},null,false,{"$f":"LEN(K22)","v":6},2.36]
["- Minutenbundel videronde",null,null,"Nee","Kies uw bundel:",null,null,null,{"$f":"IF(M24<2,0,VLOOKUP(F23,Validatielijsten!E:F,2,FALSE))","v":0},null,{"$f":"IF(D23=\"Nee\",\"Onwaar\",\"Waar\")","v":"Onwaar"},{"$f":"LEN(K23)","v":6},{"$f":"IF(L23=6,0,VLOOKUP(F23,Validatielijsten!E:F,2,FALSE))","v":0},null,null,{"$f":"IF(L23=6,0,1)","v":0},{"$f":"IF(P23=1,F23,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D23=\"Ja\",1,0)","v":0},{"$f":"IF(F23>0,1,0)","v":0},{"$f":"K24+L24","v":0}]
["- Videoronde / surveillanceronde",null,null,"Aantal per week",null,null,null,{"$f":"IF(M27<2,\"Prijs per minuut\",\"\")","v":"Prijs per minuut"},{"$f":"IF(M27<2,2.36,\"\")","v":2.36},null,false,{"$f":"LEN(K25)","v":6},2.36]
["- Minutenbundel videoronde",null,null,"Nee","Kies uw bundel:",null,null,null,{"$f":"IF(M27<2,0,VLOOKUP(F26,Validatielijsten!E:F,2,FALSE))","v":0},null,{"$f":"IF(D26=\"Nee\",\"Onwaar\",\"Waar\")","v":"Onwaar"},{"$f":"LEN(K26)","v":6},{"$f":"IF(L26=6,0,VLOOKUP(F26,Validatielijsten!E:F,2,FALSE))","v":0},null,null,{"$f":"IF(L26=6,0,1)","v":0},{"$f":"IF(P26=1,F26,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D26=\"Ja\",1,0)","v":0},{"$f":"IF(F26>0,1,0)","v":0},{"$f":"K27+L27","v":0}]
["- Begeleid openen en sluiten",null,null,"Aantal per week",null,null,null,{"$f":"IF(M30<2,\"Prijs per minuut\",\"\")","v":"Prijs per minuut"},{"$f":"IF(M30<2,2.36,\"\")","v":2.36},null,false,{"$f":"LEN(K28)","v":6},2.36]
["- Minutenbundel BOS",null,null,"Nee","Kies uw bundel:",null,null,null,{"$f":"IF(M30<2,0,VLOOKUP(F29,Validatielijsten!E:F,2,FALSE))","v":0},null,{"$f":"IF(D29=\"Nee\",\"Onwaar\",\"Waar\")","v":"Onwaar"},{"$f":"LEN(K29)","v":6},{"$f":"IF(L29=6,0,VLOOKUP(F29,Validatielijsten!E:F,2,FALSE))","v":0},null,null,{"$f":"IF(L29=6,0,1)","v":0},{"$f":"IF(P29=1,F29,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=\"Ja\",1,0)","v":0},{"$f":"IF(F29>0,1,0)","v":0},{"$f":"K30+L30","v":0}]
[null,null,null,null,"Totaal bundel",{"$f":"Q31","v":0},null,null,null,null,{"$f":"IF(F31>10000,\"\",VLOOKUP(F31,Validatielijsten!M:N,2,FALSE)*F31)","v":0},null,null,{"$f":"F31*M22","v":0},null,{"$f":"SUM(P23:P29)","v":0},{"$f":"SUM(Q23:Q29)","v":0}]
[null,null,null,null,{"$f":"IF(F32=\"\",\"\",\"Bundelprijs\")","v":""},{"$f":"IF(F31=0,\"\",K31)","v":""},null,{"$f":"IF(F32=\"\",\"\",\"Uw bundelvoordeel\")","v":""},{"$f":"-IF(F31=0,0,N31-F32)","v":0},null,"Bundelprijs",null,null,"Brutoprijs"]
[]
["- Cameracheck / verbindingcheck",null,null,"Nee","Frequentie:","Anders",null,{"$f":"IF(D34=\"Nee\",\"\",VLOOKUP(F34,Validatielijsten!H:L,5,FALSE))","v":""},{"$f":"IF(D34=\"ja\",M34,0)","v":0},null,{"$f":"IF(D34=\"Nee\",\"Onwaar\",\"Waar\")","v":"Onwaar"},{"$f":"LEN(K34)","v":6},{"$f":"IF(L34=6,0,VLOOKUP(F34,Validatielijsten!H:K,4,FALSE))","v":0}]
[]
["- Sturingen",null,null,"Nee",null,null,null,{"$f":"IF(D36=\"Ja\",\"Prijs per sturing\",\"\")","v":""},{"$f":"IF(D36=\"Nee\",0,2.36)","v":0}]
[]
["Overige inzet"]
["- Videodienstverlening buiten standaard pakket",null,null,null,null,null,null,null,null,"Prijs in overleg"]
["- Inzet van video Artificial Intelligence oplossingen",null,null,null,null,null,null,null,null,"Prijs in overleg"]
["- Aanmaken plattegrond met cameraposities in Immix",null,null,null,null,"Keuze:","Nee","Eenmalig per locatie",{"$f":"M41","v":0},null,{"$f":"IF(G41=\"Nee\",\"Onwaar\",\"Waar\")","v":"Onwaar"},{"$f":"LEN(K41)","v":6},{"$f":"IF(L41=6,0,275)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J18+I23+I26+I29+I41+I34+J19+I32","v":375}]
[{"$f":"IF(L16=4,\"Het doel van het video security systeem en de contractuele afspraken zijn in een aparte overeenkomst opgenomen en dient samen met dit document te worden aangemeld bij SMC. Ondertekening door de klant is niet nodig.\",\"\")","v":""}]
[]
[{"$f":"IF(L16=4,\"\",\"Wat is het doel van het video security systeem?\")","v":"Wat is het doel van het video security systeem?"},null,null,null,null,null,"Opmerkingen"]
[]
[]
[]
[]
[]
[]
["Voorwaarden"]
[{"$f":"IF(L16=6,\"• Deze offerte is geldig gedurende 30 dagen na dagtekening. Acceptatie na retour en ontvangst van de getekende offerte.\",\"• Bij deze aanvraag hoort een aparte offerte waarin de geldigheidsduur is opgenomen. De offerte is bijgevoegd\")","v":"• Deze offerte is geldig gedurende 30 dagen na dagtekening. Acceptatie na retour en ontvangst van de getekende offerte."}]
[{"$f":"IF(L16=6,\"• Deze offerte is in het nieuwe jaar tot maximaal 1 februari geldig. Daarna gelden de tarieven voor het nieuwe jaar.\",\"• De offerte die bij deze aanvraag hoort is in het nieuwe jaar tot maximaal 1 februari geldig. Daarna gelden de tarieven voor het nieuwe jaar\")","v":"• Deze offerte is in het nieuwe jaar tot maximaal 1 februari geldig. Daarna gelden de tarieven voor het nieuwe jaar."}]
["• De videodienstverlening wordt opgestart na acceptatie SMC."]
["• Uw installateur overlegt het PvE, de plattegrond, het cameraplan, de zone indeling  en actiepatroon bij oplevering aan SMC"]
["• Wij gaan er vanuit dat de gegevens voor oplevering van de dienst correct zijn. "]
["• Klant geeft aan bij ondertekening van deze opdracht akkoord te gaan met het inkijken van beelden door SMC."]
["• Indien SMC ad-hoc in moet kijken, of als het aantal verwachte videomeldingen hoger is, zal dat op basis van nacalculatie gefactureerd worden."]
["• het tarief voor nacalculatie bij ad-hoc en/of overschrijding van de minutenbundel is € 2,36"]
["• SMC verklaart dat bij opslag van beelden, tenzij anders overeengekomen, de bewaartermijn van beeldmateriaal maximaal 28 dagen is."]
["• Op deze offerte zijn de Algemene Voorwaarden van Security Monitoring Centre B.V. van toepassing. Genoemde voorwaarden "]
["  zijn gedeponeerd bij de Kamer van Koophandel te Utrecht. Opdrachtgever verklaart met deze voorwaarden reeds bekend te zijn en ermee "]
["  akkoord te zijn. De Algemene Voorwaarden zijn tevens te vinden op www.smc-alarmcentrale.nl/formulieren."]
["Ondertekening",null,null,null,null,null,null,"Offertekenmerk:",{"$f":"D7","v":0},{"$f":"TODAY()","v":45464}]
["Aldus overeengekomen en getekend d.d.",null,null,null,{"$f":"TODAY()","v":"2024-06-21"},null,"te (plaats)"]
["Handtekening klant:",null,null,null,null,null,"Paraaf installateur:"]
[]
[]
["Vergeet niet het tabblad Video Security Systeem in te vullen!"]
["Onvolledige formulieren worden niet in behandeling genomen!"]
[{"$f":"IF(D7=\"\",\"\", \"Dank u wel voor uw opdracht!\")","v":""}]

{"sheet":"Compatible videosystemen","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Video Security Systeem","index":2,"n_rows":53,"n_cols":50,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,41,3,47],[12,41,12,47],[1,1,1,46],[11,1,11,3],[11,4,11,8],[11,9,11,11],[11,12,11,17],[11,18,11,20],[11,21,11,24],[6,7,6,47],[7,1,10,3],[7,4,10,8],[7,9,10,11],[7,12,10,17],[7,18,10,20],[7,21,9,24],[7,25,10,31],[7,32,10,40],[7,41,10,47],[11,25,11,31],[11,32,11,40],[11,41,11,47],[2,30,2,40],[2,41,2,47],[3,30,3,40],[4,30,4,40],[4,41,4,47],[10,21,10,24],[2,1,5,20],[2,21,5,29],[5,30,5,40],[5,41,5,47],[13,1,13,3],[13,4,13,8],[13,9,13,11],[13,12,13,17],[13,18,13,20],[13,21,13,24],[13,25,13,31],[13,32,13,40],[13,41,13,47],[12,1,12,3],[12,4,12,8],[12,9,12,11],[12,12,12,17],[12,18,12,20],[12,21,12,24],[12,25,12,31],[12,32,12,40],[14,1,14,3],[14,4,14,8],[14,9,14,11],[14,12,14,17],[14,18,14,20],[14,21,14,24],[14,25,14,31],[14,32,14,40],[14,41,14,47],[15,25,15,31],[15,32,15,40],[15,41,15,47],[16,1,16,3],[16,4,16,8],[16,9,16,11],[16,12,16,17],[16,18,16,20],[16,21,16,24],[16,25,16,31],[15,1,15,3],[15,4,15,8],[15,9,15,11],[15,12,15,17],[15,18,15,20],[15,21,15,24],[16,32,16,40],[16,41,16,47],[17,1,17,3],[17,4,17,8],[17,9,17,11],[17,12,17,17],[17,18,17,20],[17,21,17,24],[17,25,17,31],[17,32,17,40],[17,41,17,47],[18,1,18,3],[18,4,18,8],[18,9,18,11],[18,12,18,17],[18,18,18,20],[18,21,18,24],[18,25,18,31],[18,32,18,40],[18,41,18,47],[19,25,19,31],[19,32,19,40],[19,41,19,47],[20,1,20,3],[20,4,20,8],[20,9,20,11],[20,12,20,17],[20,18,20,20],[20,21,20,24],[20,25,20,31],[19,1,19,3],[19,4,19,8],[19,9,19,11],[19,12,19,17],[19,18,19,20],[19,21,19,24],[20,32,20,40],[20,41,20,47],[21,1,21,3],[21,4,21,8],[21,9,21,11],[21,12,21,17],[21,18,21,20],[21,21,21,24],[21,25,21,31],[21,32,21,40],[21,41,21,47],[22,1,22,3],[22,4,22,8],[22,9,22,11],[22,12,22,17],[22,18,22,20],[22,21,22,24],[22,25,22,31],[22,32,22,40],[22,41,22,47],[27,25,27,31],[27,32,27,40],[27,41,27,47],[28,1,28,3],[28,4,28,8],[28,9,28,11],[28,12,28,17],[28,18,28,20],[28,21,28,24],[28,25,28,31],[27,1,27,3],[27,4,27,8],[27,9,27,11],[27,12,27,17],[27,18,27,20],[27,21,27,24],[28,32,28,40],[28,41,28,47],[29,1,29,3],[29,4,29,8],[29,9,29,11],[29,12,29,17],[29,18,29,20],[29,21,29,24],[29,25,29,31],[29,32,29,40],[29,41,29,47],[30,1,30,3],[30,4,30,8],[30,9,30,11],[30,12,30,17],[30,18,30,20],[30,21,30,24],[30,25,30,31],[30,32,30,40],[30,41,30,47],[31,1,31,7],[31,8,31,12],[31,13,31,31],[31,32,31,40],[31,41,31,47],[32,1,32,7],[32,8,32,12],[32,13,32,31],[32,32,32,40],[32,41,32,47],[36,1,36,3],[36,4,36,26],[36,27,36,47],[37,1,37,3],[37,4,37,26],[37,27,37,47],[33,1,33,7],[33,8,33,47],[34,1,34,47],[35,1,35,3],[35,4,35,26],[35,27,35,47],[38,1,38,47],[39,1,39,3],[39,4,39,17],[40,1,40,3],[40,4,40,17],[40,18,42,47],[41,1,41,3],[41,4,41,17],[42,1,42,3],[42,4,42,17],[48,23,48,47],[49,1,49,47],[50,1,51,47],[52,1,52,47],[43,1,43,22],[43,23,43,47],[44,23,44,47],[45,23,45,47],[46,23,46,47],[47,23,47,47],[23,1,23,3],[23,4,23,8],[23,9,23,11],[23,12,23,17],[23,18,23,20],[23,21,23,24],[23,25,23,31],[23,32,23,40],[23,41,23,47],[24,1,24,3],[24,4,24,8],[24,9,24,11],[24,12,24,17],[24,18,24,20],[24,21,24,24],[24,25,24,31],[24,32,24,40],[24,41,24,47],[25,1,25,3],[25,4,25,8],[25,9,25,11],[25,12,25,17],[25,18,25,20],[25,21,25,24],[25,25,25,31],[25,32,25,40],[25,41,25,47],[26,1,26,3],[26,4,26,8],[26,9,26,11],[26,12,26,17],[26,18,26,20],[26,21,26,24],[26,25,26,31],[26,32,26,40],[26,41,26,47]]}
[]
[null,"Aanvraagformulier SMC IMMIX Videodiensten 2024 versie 2024 IM ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aanvraagformulier videodiensten'!J1","v":"V1.00"},"Ja"]
[null,"Plattegrond / schema",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," Naam installateur:",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"Nee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Naam klant:",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Aansluitnummer:",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Offerte",null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Aanvraagformulier videodiensten'!I66,\"  \",'Aanvraagformulier videodiensten'!J66)","v":"0  45464"}]
[null,"Camera's"]
[null,"Nr.",null,null,"Merk/type camera",null,null,null,null,"Firmware (versie)",null,null,"IP-adres / DYN-DNS",null,null,null,null,null,"Poort nr.",null,null,"PTZ",null,null,null,"Camera-benaming",null,null,null,null,null,null,"Gebruikersnaam",null,null,null,null,null,null,null,null,"Wachtwoord"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Ja/Nee)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,"NVR/DVR",null,null,null,null,null,null,"IP-adres:"]
[null,"NVR/DVR",null,null,null,null,null,null,"DYN-DNS"]
[null,"RTSP stream"]
[null,"Recordergegevens"]
[null,"Nr",null,null,"Naam",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serienummer"]
[null,1]
[null,2]
[null,"Sturingen"]
[null,"Nr",null,null,"Benaming sturing",null,null,null,null,null,null,null,null,null,null,null,null,null,"Verlichting"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Camera’s dienen ook in de nachtelijke uren kwalitatief goede beelden te produceren, zodat men ook dan personen en/of andere zaken in het detectiegebied kan waarnemen. Goede verlichting is daarom van essentieel belang!"]
[null,2]
[null,3]
[null,"Protocol video (tbv centralisten SMC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beknopte omschrijving protocol/uitvoering"]
[null,"Verficatie n.a.v. inbraakalarm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX45=2,\"JA\",\"NEE\")","v":"JA"},null,null,"Geef  de link aan tussen de Inbraakzone en de relevante camera’s",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,2]
[null,"Verificatie n.a.v. preventief overval alarmering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX46=2,\"JA\",\"NEE\")","v":"NEE"},null,null,"Dit kan/mag in een separate tabel worden aangeleverd. ",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,1]
[null,"Verificatie n.a.v. overvalalarm / Hulpaanvraag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX47=2,\"JA\",\"NEE\")","v":"NEE"},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,1]
[null,"Observatie/camerasurveillance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX48=2,\"JA\",\"NEE\")","v":"NEE"},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,1]
[null,"Toestemming LiveView (politie)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX49=2,\"JA\",\"NEE\")","v":"JA"},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,2]
[null,"Plattegrond"]
[null,"S.V.P separaat aanleveren"]
[]
[null,"Onvolledige formulieren worden niet in behandeling genomen!"]

{"sheet":"Zone ind. en actiename","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,2,7],[1,8,2,9],[4,1,4,9],[3,1,3,7]]}
[]
[null,"Invoer via tabblad \"Video Security Systeem\"",null,null,null,null,null,null,"Invoer door installateur / klant"]
[]
[null,"Zone indeling en actiename",null,null,null,null,null,null,"Behorend bij offerte:",{"$f":"CONCATENATE('Aanvraagformulier videodiensten'!I66,\"  \",'Aanvraagformulier videodiensten'!J66)","v":"0  45464"}]
[]
[null,"Camera nr.","Merk/type camera","Firmware (versie)","IP-adres / DYN-DNS","Poort nr.","PTZ","Camera-benaming","Inbraak zone(s)","Gewenste actiename door SMC"]
[null,1,{"$f":"'Video Security Systeem'!E12","v":0},{"$f":"'Video Security Systeem'!J12","v":0},{"$f":"'Video Security Systeem'!M12","v":0},{"$f":"'Video Security Systeem'!S12","v":0},{"$f":"'Video Security Systeem'!V12","v":0},{"$f":"'Video Security Systeem'!Z12","v":0}]
[null,2,{"$f":"'Video Security Systeem'!E13","v":0},{"$f":"'Video Security Systeem'!J13","v":0},{"$f":"'Video Security Systeem'!M13","v":0},{"$f":"'Video Security Systeem'!S13","v":0},{"$f":"'Video Security Systeem'!V13","v":0},{"$f":"'Video Security Systeem'!Z13","v":0}]
[null,3,{"$f":"'Video Security Systeem'!E14","v":0},{"$f":"'Video Security Systeem'!J14","v":0},{"$f":"'Video Security Systeem'!M14","v":0},{"$f":"'Video Security Systeem'!S14","v":0},{"$f":"'Video Security Systeem'!V14","v":0},{"$f":"'Video Security Systeem'!Z14","v":0}]
[null,4,{"$f":"'Video Security Systeem'!E15","v":0},{"$f":"'Video Security Systeem'!J15","v":0},{"$f":"'Video Security Systeem'!M15","v":0},{"$f":"'Video Security Systeem'!S15","v":0},{"$f":"'Video Security Systeem'!V15","v":0},{"$f":"'Video Security Systeem'!Z15","v":0}]
[null,5,{"$f":"'Video Security Systeem'!E16","v":0},{"$f":"'Video Security Systeem'!J16","v":0},{"$f":"'Video Security Systeem'!M16","v":0},{"$f":"'Video Security Systeem'!S16","v":0},{"$f":"'Video Security Systeem'!V16","v":0},{"$f":"'Video Security Systeem'!Z16","v":0}]
[null,6,{"$f":"'Video Security Systeem'!E17","v":0},{"$f":"'Video Security Systeem'!J17","v":0},{"$f":"'Video Security Systeem'!M17","v":0},{"$f":"'Video Security Systeem'!S17","v":0},{"$f":"'Video Security Systeem'!V17","v":0},{"$f":"'Video Security Systeem'!Z17","v":0}]
[null,7,{"$f":"'Video Security Systeem'!E18","v":0},{"$f":"'Video Security Systeem'!J18","v":0},{"$f":"'Video Security Systeem'!M18","v":0},{"$f":"'Video Security Systeem'!S18","v":0},{"$f":"'Video Security Systeem'!V18","v":0},{"$f":"'Video Security Systeem'!Z18","v":0}]
[null,8,{"$f":"'Video Security Systeem'!E19","v":0},{"$f":"'Video Security Systeem'!J19","v":0},{"$f":"'Video Security Systeem'!M19","v":0},{"$f":"'Video Security Systeem'!S19","v":0},{"$f":"'Video Security Systeem'!V19","v":0},{"$f":"'Video Security Systeem'!Z19","v":0}]
[null,9,{"$f":"'Video Security Systeem'!E20","v":0},{"$f":"'Video Security Systeem'!J20","v":0},{"$f":"'Video Security Systeem'!M20","v":0},{"$f":"'Video Security Systeem'!S20","v":0},{"$f":"'Video Security Systeem'!V20","v":0},{"$f":"'Video Security Systeem'!Z20","v":0}]
[null,10,{"$f":"'Video Security Systeem'!E21","v":0},{"$f":"'Video Security Systeem'!J21","v":0},{"$f":"'Video Security Systeem'!M21","v":0},{"$f":"'Video Security Systeem'!S21","v":0},{"$f":"'Video Security Systeem'!V21","v":0},{"$f":"'Video Security Systeem'!Z21","v":0}]
[null,11,{"$f":"'Video Security Systeem'!E22","v":0},{"$f":"'Video Security Systeem'!J22","v":0},{"$f":"'Video Security Systeem'!M22","v":0},{"$f":"'Video Security Systeem'!S22","v":0},{"$f":"'Video Security Systeem'!V22","v":0},{"$f":"'Video Security Systeem'!Z22","v":0}]
[null,12,{"$f":"'Video Security Systeem'!E23","v":0},{"$f":"'Video Security Systeem'!J23","v":0},{"$f":"'Video Security Systeem'!M23","v":0},{"$f":"'Video Security Systeem'!S23","v":0},{"$f":"'Video Security Systeem'!V23","v":0},{"$f":"'Video Security Systeem'!Z23","v":0}]
[null,13,{"$f":"'Video Security Systeem'!E24","v":0},{"$f":"'Video Security Systeem'!J24","v":0},{"$f":"'Video Security Systeem'!M24","v":0},{"$f":"'Video Security Systeem'!S24","v":0},{"$f":"'Video Security Systeem'!V24","v":0},{"$f":"'Video Security Systeem'!Z24","v":0}]
[null,14,{"$f":"'Video Security Systeem'!E25","v":0},{"$f":"'Video Security Systeem'!J25","v":0},{"$f":"'Video Security Systeem'!M25","v":0},{"$f":"'Video Security Systeem'!S25","v":0},{"$f":"'Video Security Systeem'!V25","v":0},{"$f":"'Video Security Systeem'!Z25","v":0}]
[null,15,{"$f":"'Video Security Systeem'!E26","v":0},{"$f":"'Video Security Systeem'!J26","v":0},{"$f":"'Video Security Systeem'!M26","v":0},{"$f":"'Video Security Systeem'!S26","v":0},{"$f":"'Video Security Systeem'!V26","v":0},{"$f":"'Video Security Systeem'!Z26","v":0}]
[null,16,{"$f":"'Video Security Systeem'!E27","v":0},{"$f":"'Video Security Systeem'!J27","v":0},{"$f":"'Video Security Systeem'!M27","v":0},{"$f":"'Video Security Systeem'!S27","v":0},{"$f":"'Video Security Systeem'!V27","v":0},{"$f":"'Video Security Systeem'!Z27","v":0}]
[null,17,{"$f":"'Video Security Systeem'!E28","v":0},{"$f":"'Video Security Systeem'!J28","v":0},{"$f":"'Video Security Systeem'!M28","v":0},{"$f":"'Video Security Systeem'!S28","v":0},{"$f":"'Video Security Systeem'!V28","v":0},{"$f":"'Video Security Systeem'!Z28","v":0}]
[null,18,{"$f":"'Video Security Systeem'!E29","v":0},{"$f":"'Video Security Systeem'!J29","v":0},{"$f":"'Video Security Systeem'!M29","v":0},{"$f":"'Video Security Systeem'!S29","v":0},{"$f":"'Video Security Systeem'!V29","v":0},{"$f":"'Video Security Systeem'!Z29","v":0}]
[null,19,{"$f":"'Video Security Systeem'!E30","v":0},{"$f":"'Video Security Systeem'!J30","v":0},{"$f":"'Video Security Systeem'!M30","v":0},{"$f":"'Video Security Systeem'!S30","v":0},{"$f":"'Video Security Systeem'!V30","v":0},{"$f":"'Video Security Systeem'!Z30","v":0}]
[null,20,{"$f":"'Video Security Systeem'!E31","v":0},{"$f":"'Video Security Systeem'!J31","v":0},{"$f":"'Video Security Systeem'!M31","v":0},{"$f":"'Video Security Systeem'!S31","v":0},{"$f":"'Video Security Systeem'!V31","v":0},{"$f":"'Video Security Systeem'!Z31","v":0}]
[]
[null,"* Stuur dit overzicht samen met de andere tabbladen en eventuele bijlage mee naar SMC"]

{"sheet":"Immix Videoprijslijst SMC 2024","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Validatielijsten","index":5,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["Standaard cam's","Kosten",null,null,"Minutenbundel;",null,null,"Frequentie",null,null,null,null,"Minutenbundel;"]
[1,null,null,null,"Bundel",null,null,"Wekelijks","25% van videoaansluiting",0.35,{"$f":"'Aanvraagformulier videodiensten'!J18*Validatielijsten!J2","v":131.25}," ","Bundel"]
["1-4 camera's",375,null,null,0,0,null,"Maandelijks","20% van videoaansluiting",0.2,{"$f":"'Aanvraagformulier videodiensten'!J18*Validatielijsten!J3","v":75}," ",0]
["1-8 camera's",525,null,null,100,231,{"$f":"F4/E4","v":2.31},"Anders",0,null,0,"In overleg",100,2.31]
["1-12 camera's",675,null,null,200,452,{"$f":"F5/E5","v":2.2599999999999998},null,null,null,null,null,200,2.2599999999999998]
["1-16 camera's",825,null,null,300,663,2.21,null,null,null,null,null,300,2.21]
["1-20 camera's",995,null,null,400,864,2.16,null,null,null,null,null,400,2.16]
["1-24 camera's",1120,null,null,500,1055,2.11,null,null,null,null,null,500,2.11]
["1-28 camera's",1245,null,null,1000,2060,2.06,null,null,null,null,null,600,2.11]
["1-32 camera's",1370,null,null,1500,3015,2.0099999999999998,null,null,null,null,null,700,2.11]
["1-48 camera's",1475,null,null,2000,3920,1.96,null,null,null,null,null,800,2.11]
["1-64 camera's",1925,null,null,2500,4775,1.91,null,null,null,null,null,900,2.11]
["1-80 camera's",2450,null,null,5000,9300,1.86,null,null,null,null,null,1000,2.06]
["> 80 camera's in overleg",0,null,null,10000,18500,1.85,null,null,null,null,null,1100,2.06]
[null,null,null,null,"> 10.000 in overleg",null,null,null,null,null,null,null,1200,2.06]
[null,null,null,null,null,null,null,null,null,null,null,null,1300,2.06]
[null,null,null,null,null,null,null,null,null,null,null,null,1400,2.06]
[null,null,null,null,null,null,null,null,null,null,null,null,1500,2.0099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,1600,2.0099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,1700,2.0099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,1800,2.0099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,1900,2.0099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,2000,1.96]
[null,null,null,null,null,null,null,null,null,null,null,null,2100,1.96]
[null,null,null,null,null,null,null,null,null,null,null,null,2200,1.96]
[null,null,null,null,null,null,null,null,null,null,null,null,2300,1.96]
[null,null,null,null,null,null,null,null,null,null,null,null,2400,1.96]
[null,null,null,null,null,null,null,null,null,null,null,null,2500,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,2600,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,2700,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,2800,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,2900,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3000,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3100,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3200,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3300,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3400,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3500,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3600,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3700,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3800,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,3900,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4000,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4100,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4200,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4300,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4400,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4500,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4600,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4700,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4800,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,4900,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,5000,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5100,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5200,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5300,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5400,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5500,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5600,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5700,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5800,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,5900,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6000,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6100,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6200,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6300,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6400,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6500,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6600,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6700,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6800,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,6900,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7000,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7100,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7200,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7300,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7400,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7500,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7600,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7700,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7800,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,7900,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8000,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8100,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8200,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8300,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8400,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8500,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8600,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8700,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8800,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,8900,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9000,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9100,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9200,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9300,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9400,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9500,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9600,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9700,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9800,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,9900,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,10000,1.85]