{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["V03"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"V03","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,8,48,9],[48,5,48,7],[48,1,48,2],[48,3,48,4],[44,2,44,4],[45,2,45,3],[47,5,47,8],[47,3,47,4],[5,0,6,1],[5,5,5,6],[9,0,9,9],[31,3,32,3],[31,5,32,5],[31,7,32,7],[31,8,32,8],[35,3,36,3],[35,5,36,5],[35,7,36,7],[35,8,36,8],[47,1,47,2],[0,5,0,6],[3,5,3,6],[4,5,4,9],[1,5,1,9],[6,5,6,9],[2,5,2,6]]}
[null,null,null,null,"Erkenningsnr.:"]
[null,null,null,null,"SHM:"]
[null,null,null,null,"Dossiernummer:",null,null,null,"Uitgestelde werken:"]
[null,null,null,null,"Aandeel:",null,null,null," VM/B gecombineerd  dossier:",null,null,"Bouw"]
[null,null,null,null,"Project:",null,null,null,null,null,null,"Infrastructuur"]
["VO3 2017",null,null,null,"Opening bieding:"]
[null,null,null,null,"Aannemer:"]
[]
[]
["BEREKENING VAN TERMIJN EN BOETE DOOR LAATTIJDIGE UITVOERING"]
["(Artikel 86 van het Koninklijk Besluit van 14 januari 2013)"]
[]
[null,null,null,null,null,null,null,"Datum bestelbrief:"]
[null,null,null,null,null,null,null,"Contractuele aanvangsdatum:"]
[]
[null,null,null,null,null,null,null,"Oorspronkelijke uitvoeringstermijn:",null,"dagen"]
[null,null,null,null,null,null,null,"Som van alle toegestane wijzigingen van de termijn (overdracht van VO4):",null,"dagen"]
[null,null,null,null,null,null,null,"Totaal:",{"$f":"SUM(I16:I17)","v":0},"dagen"]
[null,null,null,null,null,null,null,"Contractuele voltooiingsdatum: ",{"$f":"I14+I18-1","v":-1}]
[null,null,null,null,null,null,null,"Als de werken voor of na deze contractuele datum werden voltooid"]
[null,null,null,null,null,null,null,"Voltooiingsdatum (volgens de brief waarmee de aannemer de VO vraagt): "]
[null,null,null,null,null,null,null,"Werkelijke voltooiingsdatum:"]
[]
[null,null,null,null,null,null,null,"Vertraging:",{"$f":"MAX(0,I22-I19)","v":1},"dagen (= n)"]
[null,null,null,null,null,null,null,"Oorspronkelijke uitvoeringstermijn x 0,7:",{"$f":"I16*0.7","v":0},"dagen (= N)"]
[null,null,null,null,null,null,null,"Opdrachtbedrag:",null,"(= M)"]
[null,null,null,null,null,null,null,"Maximum boetebedrag:",{"$f":"I26*5%","v":0},"(= 5% van M)"]
[]
[]
["Berekening van het boetebedrag volgens de vastgestelde vertraging"]
["1) gewoon geval"]
[null,null,null,"R = 0,45 x  ","M x n²","=",{"$f":"I26*I24*I24*0.45","v":0},"=",{"$f":"G32/G33","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"N²",null,{"$f":"I25*I25","v":0}]
[]
["2) opdrachten < 75.000 euro met waarde N < 150 "]
[null,null,null,"R = 0,45 x  ","M x n²","=",{"$f":"I26*I24*I24*0.45","v":0},"=",{"$f":"G36/G37","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"150 x N",null,{"$f":"I25*150","v":0}]
["Tellen niet mee:"]
[null,"1) vertragingsboete waarvan het totale bedrag per perceel < 75 euro"]
[null,"2) het gedeelte van de boete > 5% van het opdrachtbedrag"]
[]
[]
[null,null,null,null,null,null,null,"BOETEBEDRAG DOOR LAATTIJDIGE UITVOERING ="]
[]
[null,"Opgemaakt in"]
[null,"op",null,null,"in drie exemplaren."]
[]
[null,"De ontwerper \n",null,"De aannemer \n(of zijn afgevaardigde)",null,"De aanbestedende overheid,\n(handtekening van twee personen die voor de aanbestedende overheid verbintenissen kunnen aangaan)\n"]
[]
[]
["Tip: gebruik 'alt + enter' om binnen een cel naar een nieuwe regel te gaan."]