{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["V02"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"V02","index":0,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[7,14,7,17],[52,1,52,5],[42,1,42,5],[13,1,13,6],[12,1,12,6],[18,1,18,6],[20,1,20,6],[21,1,21,6],[22,1,22,6],[17,2,17,6],[23,1,23,6],[27,1,27,6],[28,1,28,6],[31,2,31,6],[30,2,30,6],[10,10,10,12],[55,3,55,5],[56,3,56,4],[58,6,58,7],[4,0,5,2],[4,6,4,7],[6,6,6,7],[9,0,9,6],[9,7,9,12],[44,1,44,2],[46,5,46,6],[47,5,47,6],[50,5,50,6],[49,5,49,6],[29,1,29,6],[34,1,34,6],[32,2,32,6],[0,6,0,7],[2,6,2,7],[1,6,1,12],[3,6,3,12],[5,6,5,12],[59,11,59,12],[59,9,59,10],[59,2,59,5],[58,9,58,12],[58,2,58,3],[59,6,59,8]]}
[null,null,null,null,null,"Erkenningsnr.:"]
[null,null,null,null,null,"SHM:"]
[null,null,null,null,null,"Dossiernummer:",null,null,null,"Uitgestelde werken",null,"                                                 VM/B gecombineerd dossier"]
[null,null,null,null,null,"Project:"]
["VO2 2017",null,null,null,null,"Opening bieding:"]
[null,null,null,null,null,"Aannemer:"]
[null,null,null,null,null,"Aanvangsdatum werken:"]
[]
[]
["EINDAFREKENING",null,null,null,null,null,null,"De cijfers in onderstaande kolommen, moeten al afgerond zijn op twee decimalen bij ingave!"]
[null,null,null,null,null,null,null,null,null,"BOUW","INFRASTRUCTUUR"]
[null,null,null,null,null,null,null,null,null,null,"Subsidie VMSW","Eigen rekening SHM","Andere partijen"]
["I.","OPDRACHTBEDRAG (incl. korting):",null,null,null,null,null,{"$f":"J13+K13+L13+M13","v":0},null,0,null,null,null,null,"OPDRACHTBEDRAG (incl. korting):"]
["II.","WIJZIGING(EN) NA BESTELLING:",null,null,null,null,null,null,null,null,null,null,null,null,"WAARBORG VO7:"]
[null,"•","Saldo staat VO4",null,null,null,null,{"$f":"J15+K15+L15+M15","v":0}]
[null,"•","Eventuele korting:",null,null,"%",null,{"$f":"J16+K16+L16+M16","v":0},"(-)",{"$f":"(J15/100)*E16","v":0},{"$f":"(K15/100)*E16","v":0},{"$f":"(L15/100)*E16","v":0},{"$f":"(M15/100)*E16","v":0}]
[null,null,null,null,null,null,null,{"$f":"J17+K17+L17+M17","v":0},null,{"$f":"J15-J16","v":0},{"$f":"K15-K16","v":0},{"$f":"L15-L16","v":0},{"$f":"M15-M16","v":0}]
[null,"•","Volume van de werken bij het verstrijken van de contractuele uitvoeringstermijn:",null,null,null,null,{"$f":"J18+K18+L18+M18","v":0}]
["III.","WAARDEVERMINDERING VO5",null,null,null,null,null,{"$f":"J19+K19+L19+M19","v":0},"(-)"]
[]
["IV.","TOTAAL PRIJSHERZIENINGEN:",null,null,null,null,null,{"$f":"J21+K21+L21+M21","v":0},"(+)"]
["V.","ALLERLEI (onderworpen aan de btw)",null,null,null,null,null,{"$f":"J22+K22+L22+M22","v":0},"(+)",0]
["VI.","TOTAALBEDRAG (onderworpen aan de btw)",null,null,null,null,null,null,null,{"$f":"J13+J17-J19+J21+J22","v":0},{"$f":"K13+K17-K19+K21+K22","v":0},{"$f":"L13+L17-L19+L21+L22","v":0},{"$f":"M13+M17-M19+M21+M22","v":0}]
["VII.","BOETE EN ANDERE GELDSTRAFFEN"]
[null,"•","Boetes",null,null,null,null,{"$f":"J25+K25+L25+M25","v":0}]
[null,"•","Andere geldstraffen",null,null,null,null,{"$f":"J26+K26+L26+M26","v":0}]
[null,null,null,null,null,null,null,{"$f":"J27+K27+L27+M27","v":0},"(-)",{"$f":"J25+J26","v":0},{"$f":"K25+K26","v":0},{"$f":"L25+L26","v":0},{"$f":"M25+M26","v":0}]
["VIII.","ALLERLEI (niet onderworpen aan de btw)",null,null,null,null,null,{"$f":"J28+K28+L28+M28","v":0},"(+)",0]
["IX.","EINDBEDRAG VAN DE OPDRACHT (btw niet inbegrepen)",null,null,null,null,null,{"$f":"J29+K29+L29+M29","v":0},null,{"$f":"J23-J27+J28","v":0},0,{"$f":"L23-L27+L28","v":0},{"$f":"M23-M27+M28","v":0}]
["X.","VOORLOPIGE AFHOUDING"]
[null,"•","Waarborg in orde brengen van niet conform bevonden werken (VO6)",null,null,null,null,{"$f":"J31+K31+L31+M31","v":0}]
[null,"•","Waarborg uitvoering van de uitgestelde werken        (VO7 Uitgestelde werken)",null,null,null,null,{"$f":"J32+K32+L32+M32","v":0}]
[null,"•","Saldo onderhoudwerken (VO7 Onderhoudswerken)",null,null,null,null,{"$f":"J33+K33+L33+M33","v":0},"(+)"]
[null,"•","Totaal VO6 + VO7",null,null,null,null,{"$f":"J34+K34+L34+M34","v":0},null,{"$f":"J31+J32+J33","v":0},{"$f":"K31+K32+K33","v":0},0,{"$f":"M31+M32+M33","v":0}]
["XI.","SOM DIE NU TE BETALEN IS AAN DE AANNEMER"]
[null,"•","Totaal rubriek VI",null,null,null,null,{"$f":"J36+K36+L36+M36","v":0},null,{"$f":"J23","v":0},{"$f":"K23","v":0},{"$f":"L23","v":0},{"$f":"M23","v":0}]
[null,"•","Voorlopige afhouding rubriek X",null,null,null,"(-)",0,"(-)",{"$f":"J34","v":0},{"$f":"K34","v":0},{"$f":"L34","v":0},{"$f":"M34","v":0}]
[null,"•","Blijft",null,null,null,null,0,null,{"$f":"J36-J37","v":0},{"$f":"K36-K37","v":0},{"$f":"L36-L37","v":0},{"$f":"M36-M37","v":0}]
[null,"•","Totaal al gefactureerd",null,null,null,"(-)",0,"(-)"]
[null,"•","Blijft",null,null,null,null,0,null,{"$f":"J38-J39","v":0},{"$f":"K38-K39","v":0},{"$f":"L38-L39","v":0},{"$f":"M38-M39","v":0}]
[null,"•","Boeten geldstraffen rubriek VII",null,null,null,"(-)",0,null,{"$f":"J27","v":0},0,0,{"$f":"M27","v":0}]
[null,"•","Allerlei volgens rubriek VIII",null,null,null,"(+)",0,null,0,0,0,{"$f":"M28","v":0}]
[null,"Saldo (excl. btw)",null,null,null,null,null,0,null,{"$f":"J40-J41+J42","v":0},{"$f":"K40-K41+K42","v":0},{"$f":"L40-L41+L42","v":0},{"$f":"M40-M41+M42","v":0}]
[]
["XII.","BEREKENING btw",null,null,null,null,null,{"$f":"SUM(H47:H51)","v":0},"(+)",{"$f":"((J47/100)*6)+((J48/100)*21)","v":0},{"$f":"((K50/100)*6)+((K51/100)*21)","v":0},{"$f":"((L50/100)*6)+((L51/100)*21)","v":0},{"$f":"((M50/100)*6)+((M51/100)*21)","v":0}]
[null,"•","Bouw"]
[null,null,"Aandeel saldo aan 6% btw",null,null,null,null,{"$f":"J47/100*6","v":0},null,null," -"," -"," -"]
[null,null,"Aandeel saldo aan 21% btw",null,null,null,null,{"$f":"J48/100*21","v":0},null,null," -"," -"," -"]
[null,"•","Infrastructuur"]
[null,null,"Aandeel saldo aan 6% btw",null,null,null,null,{"$f":"SUM(K50:M50)/100*6","v":0},null," -"]
[null,null,"Aandeel saldo aan 21% btw",null,null,null,null,{"$f":"SUM(K51:M51)/100*21","v":0},null," -"]
[]
[null,"Nu te betalen saldo (incl. btw)",null,null,null,null,null,{"$f":"J53+K53+L53+M53","v":0},null,{"$f":"J43+SUM(J45)","v":0},{"$f":"K43+K45","v":0},{"$f":"L43+L45","v":0},{"$f":"M43+M45","v":0}]
[]
[]
[null,null,"Opgemaakt in"]
[null,null,"op",null,null,"in vier exemplaren."]
[]
[null,null,"De ontwerper \n",null,null,null,"De aannemer \n(of zijn afgevaardigde)",null,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."]