{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Herleitung Preise","Beispiel a)","Beispiel b)"],"not_rendered":{"images":2,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Herleitung Preise","index":0,"n_rows":35,"n_cols":5,"rows_kept":35,"merged":[[8,0,8,2],[8,3,8,5],[9,0,9,2],[9,3,9,5],[10,0,10,2],[10,3,10,5],[11,0,11,2],[11,3,11,5],[12,0,12,2],[12,3,12,5],[13,0,13,2],[13,3,13,5]]}
[]
[]
["Auftragsänderung bzw. Preisanpassung von Rahmenvereinbarungen gem. § 313 BGB sowie § 132 GWB"]
[]
["Bitte bei der Dateneingabe bzw. der Ermittlung der neuen Angebotspreise unbedingt die Kommentare der einzelnen Zellen beachten!"]
["In den Tabellenregistern finden Sie Beispiele zur Herleitung!"]
[]
[]
["Vergabenummer:"]
["Vertragspartner:"]
["Vertragsbeginn:"]
["Angebotspreis bei Vertragsbeginn [Euro]:"]
["Datum der letzten Preisanpassung:"]
["Letzter aktualisierter Angebotspreis [Euro]:"]
[]
["Monat /Jahr","Preisindex\n[Punkte]","Veränderung\nPreisindex zum Vormonat\n[Punkte]","Veränderung\n[%]\nAnzeige gerundet","Angebotspreis\n[Euro]\nErmittelt mit ungerundeten Werten"]
["2021-02-01",{"v":110,"d":"110.0"},"-","-"]
["2021-03-01",110.6,{"$f":"B18-B17","v":{"v":0.5999999999999943,"d":"0.6"}},{"$f":"C18/B17","v":{"v":0.005454545454545403,"d":"0.55%"}},{"v":0,"d":"0.00"}]
["2021-04-01",110.8,{"$f":"B19-B18","v":{"v":0.20000000000000284,"d":"0.2"}},{"$f":"C19/B18","v":{"v":1.8083182640144923E-3,"d":"0.18%"}},{"$f":"E18+E18*D19","v":{"v":0,"d":"0.00"}}]
["2021-05-01",111.1,{"v":0.29999999999999716,"d":"0.3"},{"v":2.7075812274367974E-3,"d":"0.27%"},{"$f":"E19+E19*D20","v":{"v":0,"d":"0.00"}}]
["2021-06-01",111.3,{"v":0.20000000000000284,"d":"0.2"},{"v":0.001800180018001826,"d":"0.18%"},{"v":0,"d":"0.00"}]
["2021-07-01",111.6,{"v":0.29999999999999716,"d":"0.3"},{"v":2.695417789757387E-3,"d":"0.27%"},{"$f":"E21+E21*D22","v":{"v":0,"d":"0.00"}}]
["2021-08-01",111.9,{"v":0.30000000000001137,"d":"0.3"},{"v":0.002688172043010855,"d":"0.27%"},{"v":0,"d":"0.00"}]
["2021-09-01",112.2,{"v":0.29999999999999716,"d":"0.3"},{"v":2.6809651474530576E-3,"d":"0.27%"},{"v":0,"d":"0.00"}]
["2021-10-01",112.3,{"v":0.09999999999999432,"d":"0.1"},{"v":8.9126559714789941E-4,"d":"0.09%"},{"v":0,"d":"0.00"}]
["2021-11-01",112.5,{"v":0.20000000000000284,"d":"0.2"},{"v":0.001780943900267167,"d":"0.18%"},{"v":0,"d":"0.00"}]
["2021-12-01",112.6,{"$f":"B27-B26","v":{"v":0.09999999999999432,"d":"0.1"}},{"$f":"C27/B26","v":{"v":8.8888888888883841E-4,"d":"0.09%"}},{"$f":"E26+E26*D27","v":{"v":0,"d":"0.00"}}]
["2022-01-01",112.1,-0.5,{"v":-0.004440497335701599,"d":"-0.44%"},{"v":0,"d":"0.00"}]
["2022-02-01",112.4,{"$f":"B29-B28","v":{"v":0.30000000000001137,"d":"0.3"}},{"$f":"C29/B28","v":{"v":0.002676181980374767,"d":"0.27%"}},{"$f":"E28+E28*D29","v":{"v":0,"d":"0.00"}}]
["2022-03-01",112.8,{"$f":"B30-B29","v":{"v":0.3999999999999915,"d":"0.4"}},{"$f":"C30/B29","v":{"v":3.5587188612098883E-3,"d":"0.36%"}},{"$f":"E29+E29*D30","v":{"v":0,"d":"0.00"}}]
["2022-04-01",113.3,{"$f":"B31-B30","v":0.5},{"$f":"C31/B30","v":{"v":0.004432624113475178,"d":"0.44%"}},{"$f":"E30+E30*D31","v":{"v":0,"d":"0.00"}}]
["2022-05-01",113.9,{"$f":"B32-B31","v":{"v":0.6000000000000085,"d":"0.6"}},{"$f":"C32/B31","v":{"v":0.005295675198587895,"d":"0.53%"}},{"$f":"E31+E31*D32","v":{"v":0,"d":"0.00"}}]
[]
["Datenquelle: ",null,"Abteilung 12 „Andere Waren- und Dienstleistungen“ (Veränderungsrate zum Vormonat in %) des statistischen Bundesamtes (www.destatis.de)"]
["Link:",null,"Verbraucherpreisindex: Gesamtindex und 12 Abteilungen - Statistisches Bundesamt (destatis.de)"]

{"sheet":"Beispiel a)","index":1,"n_rows":35,"n_cols":5,"rows_kept":35,"merged":[[8,0,8,2],[8,3,8,5],[9,0,9,2],[9,3,9,5],[10,0,10,2],[10,3,10,5],[11,0,11,2],[11,3,11,5],[12,0,12,2],[12,3,12,5],[13,0,13,2],[13,3,13,5]]}
[]
[]
["Auftragsänderung bzw. Preisanpassung von Rahmenvereinbarungen gem. § 313 BGB sowie § 132 GWB"]
[]
["Bitte bei der Dateneingabe bzw. der Ermittlung der neuen Angebotspreise unbedingt die Kommentare der einzelnen Zellen beachten!"]
["In den Tabellenregistern finden Sie Beispiele zur Herleitung!"]
[]
[]
["Vergabenummer:",null,null,"XXXXXXX"]
["Vertragspartner:",null,null,"Harvesterbetrieb Holzmann"]
["Vertragsbeginn:",null,null,"2021-06-01"]
["Angebotspreis bei Vertragsbeginn [Euro]:",null,null,{"v":225,"d":"225.00 €"}]
["Datum der letzten Preisanpassung:",null,null,"-"]
["Letzter aktualisierter Angebotspreis [Euro]:",null,null,"-"]
[]
["Monat /Jahr","Preisindex\n[Punkte]","Veränderung\nPreisindex zum Vormonat\n[Punkte]","Veränderung\n[%]\nAnzeige gerundet","Angebotspreis\n[Euro]\nErmittelt mit ungerundeten Werten"]
["2021-02-01",{"v":110,"d":"110.0"},"-","-"]
["2021-03-01",110.6,{"$f":"B18-B17","v":{"v":0.5999999999999943,"d":"0.6"}},{"$f":"C18/B17","v":{"v":0.005454545454545403,"d":"0.55%"}},{"$f":"E17+E17*D18","v":{"v":0,"d":"0.00"}}]
["2021-04-01",110.8,{"$f":"B19-B18","v":{"v":0.20000000000000284,"d":"0.2"}},{"$f":"C19/B18","v":{"v":1.8083182640144923E-3,"d":"0.18%"}},{"$f":"E18+E18*D19","v":{"v":0,"d":"0.00"}}]
["2021-05-01",111.1,{"v":0.29999999999999716,"d":"0.3"},{"v":2.7075812274367974E-3,"d":"0.27%"},{"v":0,"d":"0.00"}]
["2021-06-01",111.3,{"v":0.20000000000000284,"d":"0.2"},{"v":0.001800180018001826,"d":"0.18%"},{"v":225,"d":"225.00"}]
["2021-07-01",111.6,{"v":0.29999999999999716,"d":"0.3"},{"v":2.695417789757387E-3,"d":"0.27%"},{"v":225.6064690026954,"d":"225.61"}]
["2021-08-01",111.9,{"v":0.30000000000001137,"d":"0.3"},{"v":0.002688172043010855,"d":"0.27%"},{"v":226.21293800539084,"d":"226.21"}]
["2021-09-01",112.2,{"v":0.29999999999999716,"d":"0.3"},{"v":2.6809651474530576E-3,"d":"0.27%"},{"v":226.81940700808624,"d":"226.82"}]
["2021-10-01",112.3,{"v":0.09999999999999432,"d":"0.1"},{"v":8.9126559714789941E-4,"d":"0.09%"},{"v":227.02156334231805,"d":"227.02"}]
["2021-11-01",112.5,{"v":0.20000000000000284,"d":"0.2"},{"v":0.001780943900267167,"d":"0.18%"},{"v":227.42587601078165,"d":"227.43"}]
["2021-12-01",112.6,{"v":0.09999999999999432,"d":"0.1"},{"v":8.8888888888883841E-4,"d":"0.09%"},{"v":227.62803234501345,"d":"227.63"}]
["2022-01-01",112.1,-0.5,{"v":-0.004440497335701599,"d":"-0.44%"},{"v":226.61725067385441,"d":"226.62"}]
["2022-02-01",112.4,{"$f":"B29-B28","v":{"v":0.30000000000001137,"d":"0.3"}},{"$f":"C29/B28","v":{"v":0.002676181980374767,"d":"0.27%"}},{"$f":"E28+E28*D29","v":{"v":227.22371967654985,"d":"227.22"}}]
["2022-03-01",112.8,{"$f":"B30-B29","v":{"v":0.3999999999999915,"d":"0.4"}},{"$f":"C30/B29","v":{"v":3.5587188612098883E-3,"d":"0.36%"}},{"$f":"E29+E29*D30","v":{"v":228.03234501347706,"d":"228.03"}}]
["2022-04-01",113.3,{"$f":"B31-B30","v":0.5},{"$f":"C31/B30","v":{"v":0.004432624113475178,"d":"0.44%"}},{"$f":"E30+E30*D31","v":{"v":229.0431266846361,"d":"229.04"}}]
["2022-05-01",113.9,{"v":0.6000000000000085,"d":"0.6"},{"v":0.005295675198587895,"d":"0.53%"},{"v":230.25606469002693,"d":"230.26"}]
[]
["Datenquelle: ",null,"Abteilung 12 „Andere Waren- und Dienstleistungen“ (Veränderungsrate zum Vormonat in %) des statistischen Bundesamtes (www.destatis.de)"]
["Link:",null,"Verbraucherpreisindex: Gesamtindex und 12 Abteilungen - Statistisches Bundesamt (destatis.de)"]

{"sheet":"Beispiel b)","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"merged":[[8,0,8,2],[8,3,8,5],[9,0,9,2],[9,3,9,5],[10,0,10,2],[10,3,10,5],[11,0,11,2],[11,3,11,5],[12,0,12,2],[12,3,12,5],[13,0,13,2],[13,3,13,5]]}
[]
[]
["Auftragsänderung bzw. Preisanpassung von Rahmenvereinbarungen gem. § 313 BGB sowie § 132 GWB"]
[]
["Bitte bei der Dateneingabe bzw. der Ermittlung der neuen Angebotspreise unbedingt die Kommentare der einzelnen Zellen beachten!"]
["In den Tabellenregistern finden Sie Beispiele zur Herleitung!"]
[]
[]
["Vergabenummer:",null,null,"XXXXXXX"]
["Vertragspartner:",null,null,"Holzrückeunternehmen Eichmann"]
["Vertragsbeginn:",null,null,"2021-02-01"]
["Angebotspreis bei Vertragsbeginn [Euro]:",null,null,{"v":84.5,"d":"84.50 €"}]
["Datum der letzten Preisanpassung:",null,null,"2022-02-01"]
["Letzter aktualisierter Angebotspreis [Euro]:",null,null,{"v":86.23,"d":"86.23 €"}]
[]
["Monat /Jahr","Preisindex\n[Punkte]","Veränderung\nPreisindex zum Vormonat\n[Punkte]","Veränderung\n[%]\nAnzeige gerundet","Angebotspreis\n[Euro]\nErmittelt mit ungerundeten Werten"]
["2021-02-01",{"v":110,"d":"110.0"},"-","-"]
["2021-03-01",110.6,{"$f":"B18-B17","v":{"v":0.5999999999999943,"d":"0.6"}},{"$f":"C18/B17","v":{"v":0.005454545454545403,"d":"0.55%"}},{"$f":"E17+E17*D18","v":{"v":0,"d":"0.00"}}]
["2021-04-01",110.8,{"$f":"B19-B18","v":{"v":0.20000000000000284,"d":"0.2"}},{"$f":"C19/B18","v":{"v":1.8083182640144923E-3,"d":"0.18%"}},{"$f":"E18+E18*D19","v":{"v":0,"d":"0.00"}}]
["2021-05-01",111.1,{"v":0.29999999999999716,"d":"0.3"},{"v":2.7075812274367974E-3,"d":"0.27%"},{"v":0,"d":"0.00"}]
["2021-06-01",111.3,{"v":0.20000000000000284,"d":"0.2"},{"v":0.001800180018001826,"d":"0.18%"},{"v":0,"d":"0.00"}]
["2021-07-01",111.6,{"v":0.29999999999999716,"d":"0.3"},{"v":2.695417789757387E-3,"d":"0.27%"},{"v":0,"d":"0.00"}]
["2021-08-01",111.9,{"v":0.30000000000001137,"d":"0.3"},{"v":0.002688172043010855,"d":"0.27%"},{"v":0,"d":"0.00"}]
["2021-09-01",112.2,{"v":0.29999999999999716,"d":"0.3"},{"v":2.6809651474530576E-3,"d":"0.27%"},{"v":0,"d":"0.00"}]
["2021-10-01",112.3,{"v":0.09999999999999432,"d":"0.1"},{"v":8.9126559714789941E-4,"d":"0.09%"},{"v":0,"d":"0.00"}]
["2021-11-01",112.5,{"v":0.20000000000000284,"d":"0.2"},{"v":0.001780943900267167,"d":"0.18%"},{"v":0,"d":"0.00"}]
["2021-12-01",112.6,{"v":0.09999999999999432,"d":"0.1"},{"v":8.8888888888883841E-4,"d":"0.09%"},{"v":0,"d":"0.00"}]
["2022-01-01",112.1,-0.5,{"v":-0.004440497335701599,"d":"-0.44%"},{"v":0,"d":"0.00"}]
["2022-02-01",112.4,{"$f":"B29-B28","v":{"v":0.30000000000001137,"d":"0.3"}},{"$f":"C29/B28","v":{"v":0.002676181980374767,"d":"0.27%"}},86.23]
["2022-03-01",112.8,{"$f":"B30-B29","v":{"v":0.3999999999999915,"d":"0.4"}},{"$f":"C30/B29","v":{"v":3.5587188612098883E-3,"d":"0.36%"}},{"v":86.53686832740213,"d":"86.54"}]
["2022-04-01",113.3,{"$f":"B31-B30","v":0.5},{"$f":"C31/B30","v":{"v":0.004432624113475178,"d":"0.44%"}},{"$f":"E30+E30*D31","v":{"v":86.9204537366548,"d":"86.92"}}]
["2022-05-01",113.9,{"$f":"B32-B31","v":{"v":0.6000000000000085,"d":"0.6"}},{"$f":"C32/B31","v":{"v":0.005295675198587895,"d":"0.53%"}},{"$f":"E31+E31*D32","v":{"v":87.38075622775801,"d":"87.38"}}]
[]
["Datenquelle: ",null,"Abteilung 12 „Andere Waren- und Dienstleistungen“ (Veränderungsrate zum Vormonat in %) des statistischen Bundesamtes (www.destatis.de)"]
["Link:",null,"Verbraucherpreisindex: Gesamtindex und 12 Abteilungen - Statistisches Bundesamt (destatis.de)"]