{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MPV 2017"],"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":"MPV 2017","index":0,"n_rows":67,"n_cols":32,"rows_kept":67,"cut":false,"hidden":false,"merged":[[67,1,67,2],[67,3,67,4],[67,5,67,8],[67,9,67,10],[34,0,34,10],[63,2,63,4],[64,2,64,3],[66,1,66,2],[66,3,66,4],[66,5,66,9],[25,29,26,29],[25,30,26,30],[25,31,26,31],[30,16,31,16],[30,17,31,17],[30,18,31,18],[30,19,31,19],[30,22,31,30],[30,31,31,31],[20,29,21,29],[20,30,21,30],[20,31,21,31],[25,16,26,16],[25,17,26,17],[25,18,26,18],[25,19,26,19],[25,22,26,22],[25,24,26,24],[25,26,26,28],[20,23,21,23],[20,24,21,24],[20,25,21,25],[20,26,21,26],[20,27,21,27],[20,28,21,28],[20,16,21,16],[20,17,21,17],[20,18,21,18],[20,19,21,19],[20,21,21,21],[20,22,21,22],[15,24,16,24],[15,25,16,25],[15,26,16,26],[15,28,16,28],[15,30,16,30],[15,31,16,31],[15,16,16,16],[15,17,16,17],[15,18,16,18],[15,19,16,19],[15,21,16,21],[15,22,16,22],[10,31,11,31],[10,16,11,16],[10,17,11,17],[10,18,11,18],[10,19,11,19],[10,21,11,21],[10,22,11,22],[10,24,11,24],[10,25,11,25],[10,26,11,26],[10,28,11,28],[10,30,11,30],[0,5,0,7],[1,5,1,10],[2,5,2,7],[3,5,4,10],[4,0,5,1],[5,5,5,10]]}
[null,null,null,null,"Erkenningsnr.:"]
[null,null,null,null,"SHM:"]
[null,null,null,null,"Dossiernummer:"]
[null,null,null,null,"Project:"]
["MPV 2017"]
[null,null,null,null,"Aannemer:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KLASSIEKE FORMULE",null,"p","=","P","x",null,"a","x","s"," +","b"," x","i"," x","i 2021"," +","c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMSCHAKELINGSFORMULE",null,null,null,null,null,null,null,null,"S",null,null,null,"I",null,"I 2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEEN PRIJSHERZIENING"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p","=",{"$f":"O50","v":0},"x",null,{"$f":"O39","v":0},"x",{"$f":"O42","v":0}," +",{"$f":"O40","v":0}," x",{"$f":"IF(OR(O37=\"KLASSIEKE FORMULE\",O44=\"\"),1,O44)","v":1}," x",{"$f":"O46","v":0}," +",{"$f":"O41","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":"IF(O43=\"\",1,O43)","v":1},null,null,null,{"$f":"IF(OR(O37=\"KLASSIEKE FORMULE\",O45=\"\"),1,O45)","v":1},null,{"$f":"IF(O47=\"\",1,O47)","v":1}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p","=",{"$f":"O50","v":0},"x",null,{"$f":"O39","v":0},"x",{"$f":"ROUND(X16/X17,5)","v":0}," +",{"$f":"O40","v":0}," x",{"$f":"ROUND(AB16/AB17,5)","v":1}," x",{"$f":"ROUND(AD16/AD17,5)","v":0}," +",{"$f":"O41","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p","=",{"$f":"O50","v":0},"x",null,null,{"$f":"ROUND(V21*X21,5)","v":0},null," +",null,{"$f":"ROUND(Z21*AB21*AD21,5)","v":0},null,null,null," +",{"$f":"O41","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p","=",{"$f":"O50","v":0},"x",null,null,{"$f":"ROUND(W26+AA26+AF26,5)","v":0}]
[]
[]
[]
["MAANDELIJKSE BEREKENING VAN DE PRIJSHERZIENING \nEN VAN DE TE FACTUREREN BETALING IN MINDERING"]
["Rubriek prijsherziening en betalingsmodaliteiten van het VM/B 2017, 2de deel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bereken hieronder uw prijsherziening*:"]
[null,null,null,"Opdrachtbedrag (incl. korting):",null,null,null,null,"Datum opening bieding:",null,null,null,null,"Kies een formule:","KLASSIEKE FORMULE",null,{"$f":"IF(O37=\"OMSCHAKELINGSFORMULE\",\"p = P x (a x s/S + b x i/I x i 2021/I 2021 + c)\",\"p = P x (a x s/S + b x i 2021/I 2021 + c)\")","v":"p = P x (a x s/S + b x i 2021/I 2021 + c)"}]
[null,null,null,"Goedgekeurde VA's:",null,null,null,null,"Korting:"]
[null,null,null,"Korting op VA's:",{"$f":"E38*J38","v":0},null,null,null,null,null,null,null,null,"a =",null,null,"a = lonen"]
[null,null,null,"Totaal:",{"$f":"IF(E37+E38-E39=0,\"\",E37+E38-E39)","v":""},null,null,null,"x 95% =",{"$f":"IF(E40=\"\",\"\",E40*95%)","v":""},"(= Limiet)",null,null,"b =",null,null,"b = materialen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"c =",null,null,"c = vast deel niet vatbaar voor herziening"]
[null,null,null,null,"Maandperiode nr. ",null,"van",null,"tot",null,null,null,null,"s =",null,null,"s = indexcijfer loon geldig op het moment van de herziening"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"S =",null,null,"S = indexcijfer loon geldig 10 kalenderdagen voor de uiterste indieningsdatum van de offerte"]
[null,null,null,null,null,null,null,null,"Totaal uitgevoerde werken op het einde van de beschouwde maandperiode:",null,"(= A)",null,null,{"$f":"IF(O37=\"KLASSIEKE FORMULE\",\"\",\"i =\")","v":""},15,null,{"$f":"IF(O37=\"OMSCHAKELINGSFORMULE\", \"i = het indexcijfer materiaal geldig de kalendermaand vóór het moment van de omschakeling\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Bedrag A, incl. eventuele korting: ",{"$f":"J44-(J44*J38)","v":0},null,null,null,{"$f":"IF(O37=\"KLASSIEKE FORMULE\",\"\",\"I =\")","v":""},17,null,{"$f":"IF(O37=\"OMSCHAKELINGSFORMULE\", \"I = het indexcijfer materiaal m.b.t. de kalendermaand voor de uiterste indieningsdatum van de offerte\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Toestand op het einde van de vorige maandperiode:",null,null,null,null,"i 2021 =",null,null,"i 2021 = indexcijfer materiaal geldig de kalendermaand vóór het moment van de herziening"]
[null,null,null,null,null,null,null,null,"Prestaties van de beschouwde maandperiode:",null,"(= P)",null,null,"I 2021 =",null,null,{"$f":"IF(O37=\"KLASSIEKE FORMULE\",\"I 2021 = indexcijfer materiaal geldig vóór de uiterste indieningsdatum van de offerte\",\"I 2021 = indexcijfer materiaal geldig de kalendermaand vóór het moment van de omschakeling\")","v":"I 2021 = indexcijfer materiaal geldig vóór de uiterste indieningsdatum van de offerte"}]
[null,null,null,null,null,null,null,null,"Bedrag P, incl. eventuele korting: ",{"$f":"J47-(J47*J38)","v":0},null,null,null,"Prijsherzieningscoëfficiënt =",{"$f":"IF(O37=\"GEEN PRIJSHERZIENING\",\"2\",W31)","v":0}]
["PRIJSHERZIENING "]
[null,null,null,null,null,null,null,null,"Prijsherzieningscoëfficiënt*:",{"$f":"O48","v":0},null,null,null,"P =",{"$f":"J48","v":0},null,"P = bedrag vorderingsstaat"]
[null,null,null,null,null,null,null,null,"Prijsherziening:",{"$f":"IF(NOT(O37=\"GEEN PRIJSHERZIENING\"),J48*(J50-1),0)","v":0},null,null,null,"p =",{"$f":"S31*W31","v":0},null,"p = de te betalen som"]
[]
["FACTUURBEDRAG ",null,null,null,null,null,null,null,null,null,null,null,null,"Prijsherziening =",{"$f":"O51-O50","v":0},null,"(p - P)"]
[null,null,null,null,null,null,null,null,"Bedrag P, incl. eventuele korting:",{"$f":"J48","v":0},"(= P)"]
[null,null,null,null,null,null,null,null,"Prijsherziening:",{"$f":"J51","v":0}]
[null,null,null,null,null,null,null,null,"Totaal:",{"$f":"J54+J55","v":0},null,null,null,null,"*zie VM/B2017 punt 7.2 berekeningswijze van de prijsherziening"]
[null,null,null,null,null,null,null,null,"Als bedrag A (incl. korting) > bedrag Limiet:"]
[null,null,null,null,null,null,null,null,"limitering (=A, incl. korting) - limiet:",{"$f":"IF(J45>J40,J45-J40,0)","v":0}]
[null,null,null,null,null,null,null,null,"limitering (=A, incl. korting) - limiet (geplafonneerd op P):",{"$f":"IF(J58>J48,J48,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"CORRECT BEDRAG =",{"$f":"IF(J59=0,J56-J58,J56-J59)","v":0}]
[]
[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"]