{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["EingabeMaske","Berechnung und Ergebnis","Vergleichsfaktoren 2021 (2)","Vergleichsdaten 2021","Vergleichsdaten 2022","Vergleichsdaten 2023","GebStandard","RND","Vergleichsfaktoren","modifizierte RND","Info","Werte Neu"],"not_rendered":{"charts":5,"images":4,"macros":1,"external_links":0,"defined_names":449,"comments":2,"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":"EingabeMaske","index":0,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,5,3,5],[1,0,1,4],[31,0,31,4],[15,3,15,4],[3,0,3,4],[4,0,4,4],[2,0,2,3],[6,1,6,2],[29,0,29,1],[51,0,51,2],[11,0,11,4],[16,0,16,2],[8,1,8,3],[10,1,10,3],[30,0,30,2],[32,0,32,2],[39,0,39,2],[9,1,9,3]]}
[null,null,null,null,"WE-Rechner 1 - 2023","Bitte beachten Sie den jeweiligen Kommentar\nder Zellen der fünften Spalte (Spalte E).\n\nSofern nicht alle Kommentare gleichzeitig eingeblendet sind,\nhalten Sie die Maus-Positions-Marke (Cursor) über eine Zelle,\nin deren rechter oberer Ecke ein rotes Dreieck angezeigt wird."]
["Vergleichswertberechnung  \"Wohnungseigentum\""]
["gem. § 182 Abs.2 BewG i. V. m. § 183 BewG. "]
[]
[]
[]
["Eingabefelder blau","Berechnungsfelder rot",null,"Kommentar"]
[]
["Bezeichnung des Wertermittlungsobjekts der Bewertung nach § 183 BewG","53449 Bad Neuenahr, Musterstraße 2"]
["Liste der Vergleichsfaktoren",null,null,"Bobenheim-Roxheim - Roxheim"]
["Gemeinde / Gemarkung / Landkreis bzw. Stadt:"," /  / "]
[]
[null,null,null,{"$f":"(YEAR(D15)+1)","v":2021}]
["Merkmale des Wertermittlungsobjekts",null,"Eingabeschranken"]
["Wertermittlungsstichtag (WST):",null,"01.01.2009 bis heute","2020-01-01"]
["Index nach Marktsegment zum Wertermittlungsstichtag (2010 =100):",null,null,{"$f":"IF(YEAR(D15)=2022,'Vergleichsdaten 2022'!J393,IF(YEAR(D15)>=2023,'Vergleichsdaten 2023'!J184,'Vergleichsdaten 2021'!J170))","v":0}]
[]
[]
["Grundstücksgröße (GG):",null,"30 m² bis 500.000 m²",480]
["Gebäudestandardstufe (GST):",null,"siehe Berechnungshilfe Blatt \"GebStandard\", 1 bis 5",{"$f":"GebStandard!I25","v":3}]
["Wohnungsgröße [Wohnfläche (WF)]:",null,"15 bis 250 m²",100]
["Anzahl der Wohneinheiten in der Wohnanlage",null,"3 bis 500",10]
["Miteigentumsanteil (MA)",null,"Zähler",1]
[null,null,"Nenner",6]
[null,null,"in Prozent",{"$f":"IF(D23>=D24,\"Fehler\",ROUND(D23/D24,6))","v":0.16666700000000001}]
["Baujahr (BJ):",null,null,1990]
["Gesamtnutzungsdauer (GND):",null,"aus Standardstufe berechnet",{"$f":"ROUND($D$20*5+55,1)","v":70}]
["Restnutzungsdauer (RND):",null,"= GND ./. (ggf. fiktives) Alter;\nMindest-RND = 30% der GND",{"$f":"ROUND(IF(D27-(YEAR(D15)-D26)>= D27*30%,IF(D27-(YEAR(D15)-EingabeMaske!D26)>RND!F32,D27-(YEAR(D15)-D26),RND!F32),IF(RND!F32>D27*30%,RND!F32,D27*30%)),1)","v":40}]
[null,null,"relativ (RND/GND) in Prozent",{"$f":"IF(D28>D27,\"Fehler GND>RND\",ROUND(ROUND($D28,0)/ROUND(D$27,0),4))","v":0.57140000000000002}]
["Bodenrichtwert (BRW), maßgeblich ist der BRW zum 01.01.2020 gemäß Liegenschaftskarte/Geodatenserver RP",null,null,300,null,{"$f":"IF(D30>1500,\"Plausibel? Wurde nicht irrtümlich ein Geschäftslagenwert statt des Wohnlagewertes eingegeben?\",\"\")","v":""}]
[]
["Sondereigentume, Sondernutzungsrechte    (freie Eingaben)"]
["Garage",null,3,7000]
[]
[]
["Beschreibung des Richtwertobjekts (RWO)",null,null," "]
["Bezeichnung des herangezogenen Richtwertes"]
["(Gemeinde/Gemeindeteil/ggf. Kreismittel)",null,null,{"$f":"B11","v":" /  / "}]
["Bodenwertniveau (BWN):",null,null,{"$f":"VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2021 (2)'!A7:I3022,7)","v":0}]
["Vergleichsfaktor [Richtwert (RW)]:\naus den Kaufpreissammlungen der Gutachterausschüsse abgeleiteter Wert einer Wohnung,\ndie nach den wertbestimmenden Merkmalen\nmit der zu bewertenden Wohnung annährend vergleichbar ist\nDie wertbestimmenden Abweichungen werden in mehreren Rechenschritten entsprechend angepasst.",null,null,{"$f":"ROUND(VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2021 (2)'!A7:I3022,8),0)","v":0}]
["Stichtag des Richtwertes:",null,null,"2020-01-01"]
["Index nach Marktsegment 01.01.2020 (2020 = 100):",null,null,{"$f":"IF(YEAR(D15)=2022,'Vergleichsdaten 2022'!K393,IF(YEAR(D15)>=2023,'Vergleichsdaten 2023'!K184,'Vergleichsdaten 2021'!K170))","v":0}]
["Marktsegment",null,null,{"$f":"VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2021 (2)'!A7:I3022,6)","v":0}]
["Sachwertfaktor des Richtwertgrundstücks",null,null,{"$f":"VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2021 (2)'!A7:I3022,9)","v":0}]
["Gebäudestandardstufe (GST):",null,null,3]
["Gesamtnutzungsdauer (GND):","70 Jahre",null,1]
["Restnutzungsdauer (RND):","43 Jahre","relative RND:",{"$f":"ROUND(43/70,4)","v":0.61429999999999996}]
["Wohnungsgröße (WF):",null,null,80]
["Anzahl der Wohneinheiten (WE) in der Wohnanlage:",null,null,10]
["Grundstücksgröße (GG):",null,null,1300]
["Miteigentumsanteil (MA) in Prozent:",null,null,0.1]
["relativer Bodenwertanteil (BWA), je m² Wohnfläche:",null,null,{"$f":"ROUND(D39*D50/D49/D48,2)","v":0}]
[]
[]
[]
[]
["Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"]

{"sheet":"Berechnung und Ergebnis","index":1,"n_rows":116,"n_cols":4,"rows_kept":116,"cut":false,"hidden":false,"merged":[[1,0,1,3],[3,1,3,3],[17,0,17,2],[19,0,19,2],[118,1,118,3],[49,0,49,2],[35,0,35,2],[53,0,53,1],[54,0,54,1],[47,0,47,1],[42,0,42,1],[37,0,37,3],[100,1,100,2],[22,1,22,3],[120,1,120,3],[56,0,56,3],[69,0,69,3],[95,0,95,3],[62,0,62,1],[105,0,105,3]]}
[null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner 1 - 2023"}]
["Vergleichswertberechnung \"Wohnungseigentum\""]
[]
["Bezeichnung des Wertermittlungsobjekts der \nBewertung nach § 183 BewG:",{"$f":"EingabeMaske!B9","v":"53449 Bad Neuenahr, Musterstraße 2"}]
[]
["Merkmale des Wertermittlungsobjekts (WO)"]
[{"$f":"EingabeMaske!A15","v":"Wertermittlungsstichtag (WST):"},null,null,{"$f":"EingabeMaske!D15","v":"2020-01-01"}]
[{"$f":"EingabeMaske!A19","v":"Grundstücksgröße (GG):"},null,null,{"$f":"ROUND(EingabeMaske!D19,0)","v":480}]
["Miteigentumsanteil:",null,null,{"$f":"ROUND(EingabeMaske!D25,4)","v":0.16669999999999999}]
["Baujahr (BJ):",null,null,{"$f":"EingabeMaske!D26","v":1990}]
[{"$f":"EingabeMaske!A20","v":"Gebäudestandardstufe (GST):"},null,null,{"$f":"ROUND(EingabeMaske!D20,2)","v":3}]
["Wohnfläche (WF):",null,null,{"$f":"ROUND(EingabeMaske!D21,1)","v":100}]
["Anzahl der Wohneinheiten in der Wohnanlage",null,null,{"$f":"EingabeMaske!D22","v":10}]
[{"$f":"EingabeMaske!A27","v":"Gesamtnutzungsdauer (GND):"},null,null,{"$f":"ROUND(EingabeMaske!D27,1)","v":70}]
["Restnutzungsdauer (RND):",null,null,{"$f":"ROUND(EingabeMaske!D28,1)","v":40}]
[null,null,"relative RND:",{"$f":"EingabeMaske!D29","v":0.57140000000000002}]
["Bodenrichtwert (BWN), letzter Bodenrichtwert (01.01.2020):",null,null,{"$f":"ROUND(EingabeMaske!D30,0)","v":300}]
["Sondereigentume, Sondernutzungsrechte"]
["Sondernutzungsrechte Kfz-Unterbringung",null,null,{"$f":"EingabeMaske!D33","v":7000}]
[{"$f":"IF(EingabeMaske!A33<>0,EingabeMaske!A33,\"\")","v":"Garage"}]
["Beschreibung des Richtwertobjekts (RWO)",null,null," "]
["Bezeichnung des herangezogenen Richtwertes"]
["Gemeinde / Gemarkung / Landkreis bzw. Stadt:",{"$f":"EingabeMaske!D38","v":" /  / "}]
["Bodenwertniveau (BWN):",null,null,{"$f":"EingabeMaske!D39","v":0}]
["Vergleichsfaktor [Richtwert (RW)]:",null,null,{"$f":"EingabeMaske!D40","v":0}]
["Stichtag des Richtwertes:",null,null,{"$f":"EingabeMaske!D41","v":"2020-01-01"}]
["Index nach Marktsegment zum 01.01.2020 (2010 =100):",null,null,{"$f":"ROUND(EingabeMaske!D42,0)","v":0}]
["Sachwertfaktor des Richtwertgrundstücks",null,null,{"$f":"EingabeMaske!D44","v":0}]
["Gebäudestandardstufe (GST) (beeinflusst für die Nutzungsdauer):",null,null,3]
["Gesamtnutzungsdauer (GND):","70 Jahre",null,1]
["Restnutzungsdauer (RND):","43 Jahre","relative RND:",{"$f":"EingabeMaske!D47","v":0.61429999999999996}]
["Wohnungsgröße [Wohnfläche (WF)]:",null,null,80]
["Anzahl der Wohneinheiten (WE) in der Wohnanlage:",null,null,10]
["Grundstücksgröße (GG):",null,null,1300]
["Miteigentumsanteil (MA) in Prozent:",null,null,0.1]
["Bodenwertanteil (BWA) pro m² Wohnfläche:",null,null,{"$f":"ROUND(D24*D34/D33/D32,2)","v":0}]
[]
["Die vorliegenden Vergleichsfaktoren wurden vom oberen Gutachterausschuss RLP für ein sog. Richtwertgrundstück (= Standardgrundstück) abgeleitet.\nUm die Vergleichsfaktoren (im Weiteren als Richtwert bezeichnet) an das konkrete Wertermittlungsobjekt anzupassen, werden hierauf seitens des OGA nachfolgende Anpassungsfaktoren und Umrechnungskoeffizienten zur Schätzung der Zu- und Abschläge angewandt (vgl. § 12 ImmoWertV). Diese wurden zum Teil vom OGA selbst abgeleitet bzw. im Einzelfall der einschlägigen Literatur entnommen und entsprechend dem Bewertungsgesetz seitens des LfSt angepasst.\n"]
[{"$f":"EingabeMaske!A57","v":"Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"}]
[null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner 1 - 2023"}]
["Berechnung"]
["1. Berücksichtigung des Bodenwertanteils des Wertermittlungsobjekts (RW 1)"]
["Bodenwertanteil des Wertermittlungsobjekts pro m² Wf"]
["Bodenwert (BW):",null," ",{"$f":"D17","v":300}]
["Grundstücksgröße (GG):",null,"x",{"$f":"D8","v":480}]
["Wohnfläche (WF):",null,"/",{"$f":"D12","v":100}]
["Miteigentumsanteil:",null,"x",{"$f":"D9","v":0.16669999999999999}]
["Bodenwertanteil des Wertermittlungsobjekts [€/m² Wf]:",null,null,{"$f":"ROUND(D44*D45/D46*D47,2)","v":240.05}]
[]
["Ermittlung des Richtwertes mit dem Bodenwertanteil des Wertermittlungsobjekts"]
["Richtwert:",null,null,{"$f":"D25","v":0}]
["Sachwertfaktor:",null,"/",{"$f":"D28","v":0}]
[null,null,null,{"$f":"D51/D52","v":{"$error":"#DIV/0!"}}]
["Bodenwertanteil des Wertermittlungsobjekts [€/m² Wf]:",null,"+",{"$f":"D48","v":240.05}]
["Bodenwertanteil des Richtwertobjekts [€/m² Wf]:",null,"-",{"$f":"D36","v":0}]
[null,null,null,{"$f":"D53+D54-D55","v":{"$error":"#DIV/0!"}}]
["Ermittlung des Richtwertes (RW1)\nmit dem marktangepassten Bodenwertanteil des Wertermittlungsobjektes (WO)"]
["Sachwertfaktor [SWF(WO)]:",null,"x",{"$f":"ROUND('Vergleichsdaten 2022'!B20,2)","v":{"$error":"#DIV/0!"}}]
["Zwischenergebnis (RW1):",null,null,{"$f":"ROUND(D58*D56,2)","v":{"$error":"#DIV/0!"}}]
[]
["2. Anpassung an den Gebäudestandard (RW 2) "]
["Herausrechnen des Gebäudewertanteils aus  (RW1)"]
["Bodenwertanteil des Wertermittlungsobjekts [€/m² Wf]:",null,"-",{"$f":"D54","v":240.05}]
["Sachwertfaktor [SWF(WO)]:",null,"x",{"$f":"D58","v":{"$error":"#DIV/0!"}}]
["Bodenwertanteil am Richtwert [RW1(BW)]:",null,"-",{"$f":"ROUND(D63*D64,2)","v":{"$error":"#DIV/0!"}}]
["Zwischenergebnis [RW1(Geb)]:",null,null,{"$f":"ROUND(D59-D48*D58,2)","v":{"$error":"#DIV/0!"}}]
["UKGST:",null,"x",{"$f":"ROUND('Vergleichsdaten 2022'!B$33*D$11^2+'Vergleichsdaten 2022'!B$34*D$11+'Vergleichsdaten 2022'!B$35,3)","v":1}]
["Gebäudewertanteil, angepasst [RW2(Geb)]:",null,null,{"$f":"ROUND(D66*D67,2)","v":{"$error":"#DIV/0!"}}]
[]
["3. Anpassung an die Restnutzungsdauer (RW 3) "]
[]
["relative Restnutzungsdauer des Wertermittlungsobjekts",null,null,{"$f":"'Berechnung und Ergebnis'!D16","v":0.57140000000000002}]
["relative Restnutzungsdauer des Richtwertobjekts",null,"/",{"$f":"D31","v":0.61429999999999996}]
[null,null,"x",{"$f":"ROUND(D72/D73,3)","v":0.93}]
["Zwischenergebnis [RW3(Geb)]:",null,null,{"$f":"ROUND(D68*D74,2)","v":{"$error":"#DIV/0!"}}]
[]
["4. Anpassung an die Wohnungsgröße (RW 4)"]
[]
["UKWF(WO):",null,null,{"$f":"ROUND('Vergleichsdaten 2022'!B102*D12^2+'Vergleichsdaten 2022'!B103*D12+'Vergleichsdaten 2022'!B104,2)","v":1.01}]
["UKWF(RWO):",null,"/",1]
[null,null,"x",{"$f":"ROUND(D79/D80,3)","v":1.01}]
["Zwischenergebnis [RW4(Geb)]:",null,null,{"$f":"ROUND(D75*D81,2)","v":{"$error":"#DIV/0!"}}]
[]
["5. Anpassung an die Anzahl der Wohneinheiten (RW 5)"]
[]
["UKAWE(WO):",null,null,{"$f":"ROUND(IF(D13<=40,'Vergleichsdaten 2022'!B$137*D13^'Vergleichsdaten 2022'!B$138,'Vergleichsdaten 2022'!B$144*D13^4+'Vergleichsdaten 2022'!B$145*D13^3+'Vergleichsdaten 2022'!B$146*D13^2+'Vergleichsdaten 2022'!B$147*D13+'Vergleichsdaten 2022'!B$148),2)","v":1}]
["UKAWE(RWO):",null,"/",1]
[null,null,"x",{"$f":"ROUND(D86/D87,3)","v":1}]
["Zwischenergebnis/Übertrag [RW5(Geb)]:",null,null,{"$f":"ROUND(D82*D88,2)","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"EingabeMaske!A57","v":"Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"}]
[null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner 1 - 2023"}]
[]
["Zwischenergebnis/Übertrag [RW5(Geb)]:",null,null,{"$f":"D89","v":{"$error":"#DIV/0!"}}]
[]
["6. Berücksichtigung der veränderten Wertverhältnisse zwischen dem Richtwert-stichtag und dem Wertermittlungsstichtag (RW 6)"]
["Hinzurechnen des Bodenwertanteils"]
["Bodenwertanteil [RW1(BW)],\nvgl. die vorstehende Anpassung Gebäudestandard:",null,"+",{"$f":"D65","v":{"$error":"#DIV/0!"}}]
["Zwischenergebnis (RW6):",null,null,{"$f":"ROUND(D89+D98,2)","v":{"$error":"#DIV/0!"}}]
[]
["UKWst(WO):",{"$f":"EingabeMaske!D15","v":"2020-01-01"},null,{"$f":"EingabeMaske!D16","v":0}]
["UKWst(RWO):",{"$f":"EingabeMaske!D41","v":"2020-01-01"},"/",{"$f":"EingabeMaske!D42","v":0}]
[null,null,"x",{"$f":"ROUND(D101/D102,2)","v":{"$error":"#DIV/0!"}}]
["Zwischenergebnis (RW6):",null,null,{"$f":"ROUND(D99*D103,2)","v":{"$error":"#DIV/0!"}}]
[]
["7. Vorläufiger Vergleichswert, sonstige Unterschiede zwischen Richtwert und Bewertungsobjekt"]
["Wohnungsgröße",null,"x",{"$f":"D12","v":100}]
["vorläufige Vergleichswert",null,null,{"$f":"ROUND(D104*D107,2)","v":{"$error":"#DIV/0!"}}]
[]
["Sondereigentume, Sondernutzungsrechte"]
["Sondernutzungsrechte Kfz-Unterbringung",null,"+",{"$f":"D19","v":7000}]
[]
["Vergleichswert",null,null,{"$f":"ROUND(D108+D111,2)","v":{"$error":"#DIV/0!"}}]
[null,null,"gerundet",{"$f":"ROUND(D113,-3)","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"EingabeMaske!A57","v":"Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"}]

{"sheet":"Vergleichsfaktoren 2021 (2)","index":2,"n_rows":3022,"n_cols":9,"rows_kept":3022,"cut":false,"hidden":true,"merged":[[0,1,0,8],[1,1,1,8],[2,1,2,8],[3,1,3,8]]}
[null,"Richtwerte (RW) für Wohnungseigentume im Weiterverkauf"]
[null,"Stichtag 1.1.2020, Modell s. LGMB 2021, Kap. 3.6.1.2 - © Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz"]
[null,"Kurzbeschreibung des Richtwertobjekts: 10 Einheiten im Objekt, Grundstücksgröße 1.300 m², mittlerer Standard, Wohnfäche 80 m², Alter 27 Jahre "]
[null,"Hinweis: Sollte eine Gemarkung nicht nachgewiesen sein, kann eine vergleichbare Gemarkung desselben Marktsegments herangezogen werden. "]
["Ergänzung LfSt"]
["Gemeinde / Gemarkung / Landkreis bzw. Stadt","Nr.","Gemarkung","Gemeinde","Landkreis/kreisfreie Stadt","Markt-segment Nr.","BWN €/m² Grdst.fl.","VF €/m² Wohnfl.","SWF"]
[{"$f":"TRIM(D7)&\" / \"&TRIM(C7)&\" / \"&TRIM(E7)","v":" /  / "}]
[{"$f":"TRIM(D8)&\" / \"&TRIM(C8)&\" / \"&TRIM(E8)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D72)&\" / \"&TRIM(C72)&\" / \"&TRIM(E72)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D136)&\" / \"&TRIM(C136)&\" / \"&TRIM(E136)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D200)&\" / \"&TRIM(C200)&\" / \"&TRIM(E200)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D264)&\" / \"&TRIM(C264)&\" / \"&TRIM(E264)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D328)&\" / \"&TRIM(C328)&\" / \"&TRIM(E328)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D392)&\" / \"&TRIM(C392)&\" / \"&TRIM(E392)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D456)&\" / \"&TRIM(C456)&\" / \"&TRIM(E456)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D520)&\" / \"&TRIM(C520)&\" / \"&TRIM(E520)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D584)&\" / \"&TRIM(C584)&\" / \"&TRIM(E584)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D648)&\" / \"&TRIM(C648)&\" / \"&TRIM(E648)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D712)&\" / \"&TRIM(C712)&\" / \"&TRIM(E712)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D776)&\" / \"&TRIM(C776)&\" / \"&TRIM(E776)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D840)&\" / \"&TRIM(C840)&\" / \"&TRIM(E840)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D904)&\" / \"&TRIM(C904)&\" / \"&TRIM(E904)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D968)&\" / \"&TRIM(C968)&\" / \"&TRIM(E968)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1032)&\" / \"&TRIM(C1032)&\" / \"&TRIM(E1032)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1096)&\" / \"&TRIM(C1096)&\" / \"&TRIM(E1096)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1160)&\" / \"&TRIM(C1160)&\" / \"&TRIM(E1160)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1224)&\" / \"&TRIM(C1224)&\" / \"&TRIM(E1224)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1288)&\" / \"&TRIM(C1288)&\" / \"&TRIM(E1288)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1352)&\" / \"&TRIM(C1352)&\" / \"&TRIM(E1352)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1416)&\" / \"&TRIM(C1416)&\" / \"&TRIM(E1416)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1480)&\" / \"&TRIM(C1480)&\" / \"&TRIM(E1480)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1544)&\" / \"&TRIM(C1544)&\" / \"&TRIM(E1544)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1608)&\" / \"&TRIM(C1608)&\" / \"&TRIM(E1608)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1672)&\" / \"&TRIM(C1672)&\" / \"&TRIM(E1672)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1736)&\" / \"&TRIM(C1736)&\" / \"&TRIM(E1736)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1800)&\" / \"&TRIM(C1800)&\" / \"&TRIM(E1800)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1864)&\" / \"&TRIM(C1864)&\" / \"&TRIM(E1864)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1928)&\" / \"&TRIM(C1928)&\" / \"&TRIM(E1928)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1992)&\" / \"&TRIM(C1992)&\" / \"&TRIM(E1992)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2056)&\" / \"&TRIM(C2056)&\" / \"&TRIM(E2056)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2120)&\" / \"&TRIM(C2120)&\" / \"&TRIM(E2120)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2184)&\" / \"&TRIM(C2184)&\" / \"&TRIM(E2184)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2248)&\" / \"&TRIM(C2248)&\" / \"&TRIM(E2248)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2312)&\" / \"&TRIM(C2312)&\" / \"&TRIM(E2312)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2376)&\" / \"&TRIM(C2376)&\" / \"&TRIM(E2376)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2440)&\" / \"&TRIM(C2440)&\" / \"&TRIM(E2440)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2504)&\" / \"&TRIM(C2504)&\" / \"&TRIM(E2504)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2568)&\" / \"&TRIM(C2568)&\" / \"&TRIM(E2568)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2632)&\" / \"&TRIM(C2632)&\" / \"&TRIM(E2632)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2696)&\" / \"&TRIM(C2696)&\" / \"&TRIM(E2696)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2760)&\" / \"&TRIM(C2760)&\" / \"&TRIM(E2760)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2824)&\" / \"&TRIM(C2824)&\" / \"&TRIM(E2824)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2888)&\" / \"&TRIM(C2888)&\" / \"&TRIM(E2888)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2952)&\" / \"&TRIM(C2952)&\" / \"&TRIM(E2952)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D3016)&\" / \"&TRIM(C3016)&\" / \"&TRIM(E3016)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]

{"sheet":"Vergleichsdaten 2021","index":3,"n_rows":177,"n_cols":11,"rows_kept":177,"cut":false,"hidden":true,"merged":[]}
[]
["Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"]
[]
["Berücksichtigung der Wertverhältnisse zwischen dem Richtwertstichtag"]
[" und dem Wertermittlungsstichtag"]
["RLP"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2023,{"$f":"(G8-G9)*$B9/365+G9","v":208},"2022-01-01","2022-12-31",208,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C8,D8,0),2)","v":0}]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2022,{"$f":"(G9-G10)*$B11/365+G10","v":208},"2021-01-01","2021-12-31",208,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C9,D9,0),2)","v":0}]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2021,{"$f":"(G10-G11)*$B$16/365+G11","v":189.05205479452056},"2020-01-01","2020-12-31",208,"2021-01-01",189.05]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2020,{"$f":"(G11-G12)*$B12/365+G12","v":172.04657534246576},"2019-01-01","2019-12-31",189,"2020-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2019,157.04109589041096,"2018-01-01","2018-12-31",172,"2019-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2018,{"$f":"(G13-G14)*$B15/365+G14","v":144.03561643835616},"2017-01-01","2017-12-31",157,"2018-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2017,{"$f":"(G14-G15)*$B$16/365+G15","v":132.03287671232877},"2016-01-01","2016-12-31",144,"2017-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2016,{"$f":"(G15-G16)*$B16/365+G16","v":122.02739726027397},"2015-01-01","2015-12-31",132,"2016-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2015,{"$f":"(G16-G17)*$B17/365+G17","v":116.01643835616439},"2014-01-01","2014-12-31",122,"2015-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2014,{"$f":"(G17-G18)*$B$16/365+G18","v":110.01643835616439},"2013-01-01","2013-12-31",116,"2014-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2013,105.01369863013699,"2012-01-01","2012-12-31",110,"2013-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2012,102.00821917808219,"2011-01-01","2011-12-31",105,"2012-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,"2011-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I8:I25),0)","v":189}]
[]
["Anpassung an die Mietsituation",null,null,null,"UK"]
[null,"unvermietet","Kennziffer",1,1]
[null,"vermietet","Kennziffer",2,0.93]
[]
["Marktsegment 1"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2023,{"$f":"(G34-G35)*$B35/365+G35","v":140},"2022-01-01","2022-12-31",140,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C34,D34,0),2)","v":0}]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2022,{"$f":"(G35-G36)*$B37/365+G36","v":140},"2021-01-01","2021-12-31",140,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C35,D35,0),2)","v":0}]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2021,{"$f":"(G36-G37)*$B$16/365+G37","v":129.03013698630136},"2020-01-01","2020-12-31",140,"2021-01-01",129.03]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2020,{"$f":"(G37-G38)*$B38/365+G38","v":119.02739726027397},"2019-01-01","2019-12-31",129,"2020-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2019,112.01917808219179,"2018-01-01","2018-12-31",119,"2019-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2018,{"$f":"(G39-G40)*$B41/365+G40","v":106.01643835616439},"2017-01-01","2017-12-31",112,"2018-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2017,{"$f":"(G40-G41)*$B$16/365+G41","v":98.021917808219172},"2016-01-01","2016-12-31",106,"2017-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2016,{"$f":"(G41-G42)*$B42/365+G42","v":95.008219178082186},"2015-01-01","2015-12-31",98,"2016-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2015,{"$f":"(G42-G43)*$B43/365+G43","v":93.0054794520548},"2014-01-01","2014-12-31",95,"2015-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2014,{"$f":"(G43-G44)*$B$16/365+G44","v":93.9972602739726},"2013-01-01","2013-12-31",93,"2014-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2013,94,"2012-01-01","2012-12-31",94,"2013-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2012,93.0027397260274,"2011-01-01","2011-12-31",94,"2012-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2011,99.980821917808214,"2010-01-01","2010-12-31",93,"2011-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B33-DATE(YEAR(B33)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I34:I51),0)","v":129},{"$f":"IF(EingabeMaske!$D$43=1,'Vergleichsdaten 2021'!I52,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=1,G37,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 2"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2023,{"$f":"(G57-G58)*$B58/365+G58","v":162},"2022-01-01","2022-12-31",162,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C57,D57,0),2)","v":0}]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2022,{"$f":"(G58-G59)*$B60/365+G59","v":162},"2021-01-01","2021-12-31",162,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C58,D58,0),2)","v":0}]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2021,{"$f":"(G59-G60)*$B$16/365+G60","v":149.03561643835616},"2020-01-01","2020-12-31",162,"2021-01-01",149.04]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2020,{"$f":"(G60-G61)*$B61/365+G61","v":138.03013698630136},"2019-01-01","2019-12-31",149,"2020-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2019,129.02465753424659,"2018-01-01","2018-12-31",138,"2019-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2018,{"$f":"(G62-G63)*$B64/365+G63","v":121.02191780821917},"2017-01-01","2017-12-31",129,"2018-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2017,{"$f":"(G63-G64)*$B$16/365+G64","v":114.01917808219179},"2016-01-01","2016-12-31",121,"2017-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2016,{"$f":"(G64-G65)*$B65/365+G65","v":108.01643835616439},"2015-01-01","2015-12-31",114,"2016-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2015,{"$f":"(G65-G66)*$B66/365+G66","v":106.0054794520548},"2014-01-01","2014-12-31",108,"2015-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2014,{"$f":"(G66-G67)*$B$16/365+G67","v":106},"2013-01-01","2013-12-31",106,"2014-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2013,104.0054794520548,"2012-01-01","2012-12-31",106,"2013-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2012,100.01095890410959,"2011-01-01","2011-12-31",104,"2012-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2011,100,"2010-01-01","2010-12-31",100,"2011-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B56-DATE(YEAR(B56)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I57:I74),0)","v":149},{"$f":"IF(EingabeMaske!$D$43=2,'Vergleichsdaten 2021'!I75,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=2,G60,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 3"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2023,{"$f":"(G80-G81)*$B81/365+G81","v":180},"2022-01-01","2022-12-31",180,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C80,D80,0),2)","v":0}]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2022,{"$f":"(G81-G82)*$B83/365+G82","v":180},"2021-01-01","2021-12-31",180,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C81,D81,0),2)","v":0}]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2021,{"$f":"(G82-G83)*$B$16/365+G83","v":167.03561643835616},"2020-01-01","2020-12-31",180,"2021-01-01",167.04]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2020,{"$f":"(G83-G84)*$B84/365+G84","v":155.03287671232877},"2019-01-01","2019-12-31",167,"2020-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2019,143.03287671232877,"2018-01-01","2018-12-31",155,"2019-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2018,{"$f":"(G85-G86)*$B87/365+G86","v":132.03013698630136},"2017-01-01","2017-12-31",143,"2018-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2017,{"$f":"(G86-G87)*$B$16/365+G87","v":123.02465753424657},"2016-01-01","2016-12-31",132,"2017-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2016,{"$f":"(G87-G88)*$B88/365+G88","v":116.01917808219179},"2015-01-01","2015-12-31",123,"2016-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2015,{"$f":"(G88-G89)*$B89/365+G89","v":111.01369863013699},"2014-01-01","2014-12-31",116,"2015-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2014,{"$f":"(G89-G90)*$B$16/365+G90","v":107.01095890410959},"2013-01-01","2013-12-31",111,"2014-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2013,103.01095890410959,"2012-01-01","2012-12-31",107,"2013-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2012,102.0027397260274,"2011-01-01","2011-12-31",103,"2012-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,"2011-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B79-DATE(YEAR(B79)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I80:I97),0)","v":167},{"$f":"IF(EingabeMaske!$D$43=3,'Vergleichsdaten 2021'!I98,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=3,G83,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 4"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2023,{"$f":"(G103-G104)*$B104/365+G104","v":212},"2022-01-01","2022-12-31",212,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C103,D103,0),2)","v":0}]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2022,{"$f":"(G104-G105)*$B106/365+G105","v":212},"2021-01-01","2021-12-31",212,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C104,D104,0),2)","v":0}]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2021,{"$f":"(G105-G106)*$B$16/365+G106","v":193.05205479452056},"2020-01-01","2020-12-31",212,"2021-01-01",193.05]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2020,{"$f":"(G106-G107)*$B107/365+G107","v":176.04657534246576},"2019-01-01","2019-12-31",193,"2020-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2019,159.04657534246576,"2018-01-01","2018-12-31",176,"2019-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2018,{"$f":"(G108-G109)*$B110/365+G109","v":145.03835616438357},"2017-01-01","2017-12-31",159,"2018-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2017,{"$f":"(G109-G110)*$B$16/365+G110","v":132.03561643835616},"2016-01-01","2016-12-31",145,"2017-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2016,{"$f":"(G110-G111)*$B111/365+G111","v":123.02465753424657},"2015-01-01","2015-12-31",132,"2016-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2015,{"$f":"(G111-G112)*$B112/365+G112","v":116.01917808219179},"2014-01-01","2014-12-31",123,"2015-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2014,{"$f":"(G112-G113)*$B$16/365+G113","v":111.01369863013699},"2013-01-01","2013-12-31",116,"2014-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2013,107.01095890410959,"2012-01-01","2012-12-31",111,"2013-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2012,103.01095890410959,"2011-01-01","2011-12-31",107,"2012-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2011,100.00821917808219,"2010-01-01","2010-12-31",103,"2011-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B102-DATE(YEAR(B102)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I103:I120),0)","v":193},{"$f":"IF(EingabeMaske!$D$43=4,'Vergleichsdaten 2021'!I121,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=4,G106,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 5"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2023,{"$f":"(G126-G127)*$B127/365+G127","v":228},"2022-01-01","2022-12-31",228,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C126,D126,0),2)","v":0}]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2022,{"$f":"(G127-G128)*$B129/365+G128","v":228},"2021-01-01","2021-12-31",228,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C127,D127,0),2)","v":0}]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2021,{"$f":"(G128-G129)*$B$16/365+G129","v":204.06575342465754},"2020-01-01","2020-12-31",228,"2021-01-01",204.07]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2020,{"$f":"(G129-G130)*$B130/365+G130","v":183.05753424657533},"2019-01-01","2019-12-31",204,"2020-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2019,166.04657534246576,"2018-01-01","2018-12-31",183,"2019-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2018,{"$f":"(G131-G132)*$B133/365+G132","v":154.03287671232877},"2017-01-01","2017-12-31",166,"2018-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2017,{"$f":"(G132-G133)*$B$16/365+G133","v":143.03013698630136},"2016-01-01","2016-12-31",154,"2017-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2016,{"$f":"(G133-G134)*$B134/365+G134","v":132.03013698630136},"2015-01-01","2015-12-31",143,"2016-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2015,{"$f":"(G134-G135)*$B135/365+G135","v":123.02465753424657},"2014-01-01","2014-12-31",132,"2015-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2014,{"$f":"(G135-G136)*$B$16/365+G136","v":114.02465753424657},"2013-01-01","2013-12-31",123,"2014-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2013,107.01917808219179,"2012-01-01","2012-12-31",114,"2013-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2012,102.01369863013699,"2011-01-01","2011-12-31",107,"2012-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,"2011-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B125-DATE(YEAR(B125)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I126:I143),0)","v":204},{"$f":"IF(EingabeMaske!$D$43=5,'Vergleichsdaten 2021'!I144,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=5,G129,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
[]
["Marktsegment 6"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2023,{"$f":"(G150-G151)*$B151/365+G151","v":243},"2022-01-01","2022-12-31",243,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C150,D150,0),2)","v":0}]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2022,{"$f":"(G151-G152)*$B153/365+G152","v":243},"2021-01-01","2021-12-31",243,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C151,D151,0),2)","v":0}]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2021,{"$f":"(G152-G153)*$B$16/365+G153","v":223.05479452054794},"2020-01-01","2020-12-31",243,"2021-01-01",223.05]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2020,{"$f":"(G153-G154)*$B154/365+G154","v":207.04383561643834},"2019-01-01","2019-12-31",223,"2020-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2019,192.04109589041096,"2018-01-01","2018-12-31",207,"2019-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2018,{"$f":"(G155-G156)*$B157/365+G156","v":176.04383561643834},"2017-01-01","2017-12-31",192,"2018-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2017,{"$f":"(G156-G157)*$B$16/365+G157","v":157.05205479452056},"2016-01-01","2016-12-31",176,"2017-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2016,{"$f":"(G157-G158)*$B158/365+G158","v":143.03835616438357},"2015-01-01","2015-12-31",157,"2016-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2015,{"$f":"(G158-G159)*$B159/365+G159","v":130.03561643835616},"2014-01-01","2014-12-31",143,"2015-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2014,{"$f":"(G159-G160)*$B$16/365+G160","v":121.02465753424657},"2013-01-01","2013-12-31",130,"2014-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2013,109.03287671232877,"2012-01-01","2012-12-31",121,"2013-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2012,104.01369863013699,"2011-01-01","2011-12-31",109,"2012-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2011,100.01095890410959,"2010-01-01","2010-12-31",104,"2011-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I150:I167),0)","v":223},{"$f":"IF(EingabeMaske!$D$43=6,'Vergleichsdaten 2021'!I168,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=6,G153,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[null,null,null,null,null,null,null,null,null,{"$f":"J52+J75+J98+J121+J144+J168","v":0},{"$f":"K52+K75+K98+K121+K144+K168","v":0}]
[]
[]
[]
[]
["Anpassung an die Mietsituation",null,null,null,"UK"]
[null,"unvermietet","Kennziffer",1,1]
[null,"vermietet","Kennziffer",2,0.93]

{"sheet":"Vergleichsdaten 2022","index":4,"n_rows":400,"n_cols":11,"rows_kept":400,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"EingabeMaske!A57","v":"Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"}]
[]
["Sachwertfaktoren für Wohnungseigentume",null,null,null,null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner 1 - 2023"}]
[]
["Objektart","Wohnungseigentum"]
["Bodenwertniveau",{"$f":"EingabeMaske!D30","v":300},45,75,130,230,230,430]
["vorläufiger Sachwert",{"$f":"'Berechnung und Ergebnis'!D12*'Berechnung und Ergebnis'!D56","v":{"$error":"#DIV/0!"}},150000,150000,150000,150000,150000,150000]
["Stichtag","2020-01-01","2020-01-01","2020-01-01","2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Stichtag als Zahl",{"$f":"B9","v":43831},{"$f":"C9","v":43831},{"$f":"D9","v":43831},43831,43831,43831,43831]
[]
["Marktsegment",{"$f":"VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2021 (2)'!A7:I3022,6)","v":0},1,2,3,4,5,6]
["a",{"$f":"IF(B$12=C$12,C13,IF(B$12=D$12,D13,IF(B$12=E$12,E13,IF(B$12=F$12,F13,IF(B$12=G$12,G13,IF(B$12=H$12,H13))))))","v":false},1.5800209999999999E-2,9.5811999999999998E-3,7.0361399999999998E-3,1.506292E-2,1.506292E-2,1.288152E-2]
["b",{"$f":"IF(B$12=C$12,C14,IF(B$12=D$12,D14,IF(B$12=E$12,E14,IF(B$12=F$12,F14,IF(B$12=G$12,G14,IF(B$12=H$12,H14))))))","v":false},0.31835323999999998,0.26586795000000002,0.13237351999999999,6.9398699999999994E-2,6.9398699999999994E-2,7.6059420000000003E-2]
["c",false,-0.18530284,-0.11846822,-0.10712051,-7.8638810000000003E-2,-7.8638810000000003E-2,-0.22657313000000001]
["d",false,1.1197E-4,1.109E-4,1.3197999999999999E-4,1.1591000000000001E-4,1.1591000000000001E-4,1.6358E-4]
["e",false,2.7182818283999999,2.7182818283999999,2.7182818283999999,2.7182818283999999,2.7182818283999999,2.7182818283999999]
[]
["Sachwertfaktor",{"$f":"B13*B7^B14*B8^B15*B17^(B16*B10)","v":{"$error":"#DIV/0!"}},{"$f":"C13*C7^C14*C8^C15*C17^(C16*C10)","v":0.78928858684166758},{"$f":"D13*D7^D14*D8^D15*D17^(D16*D10)","v":0.95012346796714597},1.2162208870711133,1.3841408307503036,1.3841408307503036,1.783779372292271]
["gerundet auf 2 Stellen",{"$f":"ROUND(B19,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(C19,2)","v":0.79},{"$f":"ROUND(D19,2)","v":0.95},1.22,1.38,1.38,1.78]
[]
[]
["SWF=a*BW^b*vSW^c"]
["a=",1.1638999999999999]
["b=",0.27760000000000001]
["c=",-0.1193]
[]
[]
[]
["Umrechnungskoeffizienten Gebäudestandard (UKGS)"]
[]
[null,null,"GST","UK"]
["a=",3.0300000000000001E-2,1,{"$f":"B$33*C33^2+B$34*C33+B$35","v":0.80041000000000007}]
["b=",-2.1399999999999999E-2,1.5,0.82758500000000002]
["c=",0.79151000000000005,2,0.86991000000000007]
[null,null,2.5,0.92738500000000013]
[null,null,3,1.0000100000000001]
[null,null,3.5,1.0877850000000002]
[null,null,4,1.1907100000000002]
[null,2.5,4.5,1.3087849999999999]
[null,null,5,1.4420100000000002]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Umrechnungskoeffizienten rel. Restnutzungsdauer"]
[]
[null,null,"rel. RND [%]","UK"]
["a=",1.6289999999999999E-2,0,0]
["b=",0,10,0.16289999999999999]
[null,null,20,{"$f":"D63*2","v":0.32579999999999998}]
[null,null,30,{"$f":"D63*3","v":0.48869999999999997}]
[null,null,40,{"$f":"D63*4","v":0.65159999999999996}]
[null,null,50,{"$f":"D63*5","v":0.8145}]
[null,null,60,{"$f":"D63*6","v":0.97739999999999994}]
[null,null,70,{"$f":"D63*7","v":1.1402999999999999}]
[null,null,80,{"$f":"D63*8","v":1.3031999999999999}]
[null,null,90,{"$f":"D63*9","v":1.4661}]
[null,null,100,{"$f":"D63*10","v":1.629}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Umrechnungskoeffizienten Wohnungsgröße"]
[null,null,"WF [m²]","UK"]
["UKWF = a*ln(WF) + b",null,20,{"$f":"B$102*C100^2+B$103*C100+B$104","v":0.90467600000000004}]
[null,null,40,{"$f":"B$102*C101^2+B$103*C101+B$104","v":0.94731799999999999}]
["a=",-1.358E-5,60,0.97909599999999997]
["b=",2.9469000000000001E-3,80,1.0000100000000001]
["c=",0.85116999999999998,100,1.01006]
[null,null,120,1.0092460000000001]
[null,null,140,0.99756800000000001]
[null,null,160,0.97502599999999995]
[null,null,180,0.9416199999999999]
[null,null,200,0.89734999999999998]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Umrechnungskoeffizienten Anzahl der WE in der Anlage"]
[]
[null,null,"Anzahl WE","UK"]
["a",1.083059,3,{"$f":"IF(C137<=40,B$137*C137^B$138,B$144*C137^4+B$145*C137^3+B$146*C137^2+B$147*C137+B$148)","v":1.0426188910710146}]
["b",-3.4638000000000002E-2,6,1.0178845268819852]
[null,null,10,1.000032502913061]
[null,null,15,0.9860857131061177]
[null,null,20,0.97630842852715627]
[null,null,30,0.96269250264499595]
[null,null,40,0.95314716755364393]
["a",4.8317900000000004E-12,41,0.94962566287757222]
["b",-6.2977699999999999E-9,50,0.94659297743750004]
["c",2.9179999999999998E-6,60,0.94361110167840001]
["d",-5.6510000000000002E-4,75,0.93983725913671878]
["e",0.96831,90,0.93681273941190002]
[null,null,100,0.935165409]
[null,null,120,0.93263657341439998]
[null,null,140,0.93096389956640002]
[null,null,160,0.92996569597440004]
[null,null,180,0.92947882523040004]
[null,null,200,0.92935870399999998]
[null,null,220,0.92947930302240001]
[null,null,250,0.92988152343749997]
[null,null,300,0.93049770899999995]
[null,null,400,0.92978654399999994]
[null,null,500,0.93002562499999997]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Marktanpassung SMK"]
[]
["kSMK=a*BW+b"]
[null,null,"BW","kSMK","Kontrolle"]
["a=",-5.1660360000000002E-4,20,1,{"$f":"C191*$B$191+$B$192","v":0.99775148400000013}]
["b=",1.0080835560000001,50,0.98,0.98225337600000007]
[null,null,100,0.96,0.95642319600000014]
[null,null,150,0.93,0.93059301600000011]
[null,null,200,0.9,0.90476283600000007]
[null,null,250,0.88,0.87893265600000015]
[null,null,300,0.85,0.85310247600000011]
[null,null,350,0.83,0.82727229600000007]
[null,null,400,0.8,0.80144211600000004]
[null,null,450,0.78,0.77561193600000011]
[null,null,500,0.75,0.74978175600000008]
[null,0,550,0.72,0.72395157600000015]
[null,null,600,0.7,0.69812139600000012]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Berücksichtigung der Wertverhältnisse zwischen dem Richtwertstichtag"]
[" und dem Wertermittlungsstichtag"]
["RLP"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2023,{"$f":"(G231-G232)*$B232/365+G232","v":232},"2022-01-01","2022-12-31",232,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C231,D231,0),2)","v":0}]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2022,{"$f":"(G232-G233)*$B234/365+G233","v":211.05753424657533},"2021-01-01","2021-12-31",232,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C232,D232,0),2)","v":0}]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2021,{"$f":"(G233-G234)*$B$239/365+G234","v":189.06027397260274},"2020-01-01","2020-12-31",211,"2021-01-01",189.06]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2020,{"$f":"(G234-G235)*$B235/365+G235","v":172.04657534246576},"2019-01-01","2019-12-31",189,"2020-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2019,157.04109589041096,"2018-01-01","2018-12-31",172,"2019-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2018,{"$f":"(G236-G237)*$B238/365+G237","v":144.03561643835616},"2017-01-01","2017-12-31",157,"2018-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2017,{"$f":"(G237-G238)*$B$239/365+G238","v":132.03287671232877},"2016-01-01","2016-12-31",144,"2017-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2016,{"$f":"(G238-G239)*$B239/365+G239","v":122.02739726027397},"2015-01-01","2015-12-31",132,"2016-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2015,{"$f":"(G239-G240)*$B240/365+G240","v":116.01643835616439},"2014-01-01","2014-12-31",122,"2015-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2014,{"$f":"(G240-G241)*$B$239/365+G241","v":110.01643835616439},"2013-01-01","2013-12-31",116,"2014-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2013,105.01369863013699,"2012-01-01","2012-12-31",110,"2013-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2012,102.00821917808219,"2011-01-01","2011-12-31",105,"2012-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,"2011-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B230-DATE(YEAR(B230)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I231:I248),0)","v":189}]
[]
["Anpassung an die Mietsituation",null,null,null,"UK"]
[null,"unvermietet","Kennziffer",1,1]
[null,"vermietet","Kennziffer",2,0.93]
[]
["Marktsegment 1"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2023,{"$f":"(G257-G258)*$B258/365+G258","v":155},"2022-01-01","2022-12-31",155,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C257,D257,0),2)","v":0}]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2022,{"$f":"(G258-G259)*$B260/365+G259","v":148.01917808219179},"2021-01-01","2021-12-31",155,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C258,D258,0),2)","v":0}]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2021,{"$f":"(G259-G260)*$B$239/365+G260","v":137.03013698630136},"2020-01-01","2020-12-31",148,"2021-01-01",137.03]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2020,{"$f":"(G260-G261)*$B261/365+G261","v":127.02739726027397},"2019-01-01","2019-12-31",137,"2020-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2019,118.02465753424657,"2018-01-01","2018-12-31",127,"2019-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2018,{"$f":"(G262-G263)*$B264/365+G263","v":113.01369863013699},"2017-01-01","2017-12-31",118,"2018-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2017,{"$f":"(G263-G264)*$B$239/365+G264","v":102.03013698630137},"2016-01-01","2016-12-31",113,"2017-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2016,{"$f":"(G264-G265)*$B265/365+G265","v":97.013698630136986},"2015-01-01","2015-12-31",102,"2016-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2015,{"$f":"(G265-G266)*$B266/365+G266","v":97.9972602739726},"2014-01-01","2014-12-31",97,"2015-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2014,{"$f":"(G266-G267)*$B$239/365+G267","v":92.016438356164386},"2013-01-01","2013-12-31",98,"2014-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2013,89.008219178082186,"2012-01-01","2012-12-31",92,"2013-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2012,86.008219178082186,"2011-01-01","2011-12-31",89,"2012-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2011,99.961643835616442,"2010-01-01","2010-12-31",86,"2011-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B256-DATE(YEAR(B256)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I257:I274),0)","v":137},{"$f":"IF(EingabeMaske!D$43=1,'Vergleichsdaten 2022'!I275,0)","v":0},{"$f":"IF(EingabeMaske!D$43=1,G260,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B230","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 2"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2023,{"$f":"(G280-G281)*$B281/365+G281","v":160},"2022-01-01","2022-12-31",160,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C280,D280,0),2)","v":0}]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2022,{"$f":"(G281-G282)*$B283/365+G282","v":149.03013698630136},"2021-01-01","2021-12-31",160,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C281,D281,0),2)","v":0}]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2021,{"$f":"(G282-G283)*$B$239/365+G283","v":140.02465753424659},"2020-01-01","2020-12-31",149,"2021-01-01",140.02000000000001]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2020,{"$f":"(G283-G284)*$B284/365+G284","v":128.03287671232877},"2019-01-01","2019-12-31",140,"2020-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2019,119.02465753424657,"2018-01-01","2018-12-31",128,"2019-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2018,{"$f":"(G285-G286)*$B287/365+G286","v":112.01917808219179},"2017-01-01","2017-12-31",119,"2018-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2017,{"$f":"(G286-G287)*$B$239/365+G287","v":106.01643835616439},"2016-01-01","2016-12-31",112,"2017-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2016,{"$f":"(G287-G288)*$B288/365+G288","v":102.01095890410959},"2015-01-01","2015-12-31",106,"2016-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2015,{"$f":"(G288-G289)*$B289/365+G289","v":99.008219178082186},"2014-01-01","2014-12-31",102,"2015-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2014,{"$f":"(G289-G290)*$B$239/365+G290","v":99},"2013-01-01","2013-12-31",99,"2014-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2013,98.0027397260274,"2012-01-01","2012-12-31",99,"2013-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2012,98.9972602739726,"2011-01-01","2011-12-31",98,"2012-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2011,99.9972602739726,"2010-01-01","2010-12-31",99,"2011-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B279-DATE(YEAR(B279)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I280:I297),0)","v":140},{"$f":"IF(EingabeMaske!D$43=2,'Vergleichsdaten 2022'!I298,0)","v":0},{"$f":"IF(EingabeMaske!D$43=2,G283,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B230","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 3"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2023,{"$f":"(G303-G304)*$B304/365+G304","v":218},"2022-01-01","2022-12-31",218,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C303,D303,0),2)","v":0}]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2022,{"$f":"(G304-G305)*$B306/365+G305","v":189.07945205479453},"2021-01-01","2021-12-31",218,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C304,D304,0),2)","v":0}]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2021,{"$f":"(G305-G306)*$B$239/365+G306","v":167.06027397260274},"2020-01-01","2020-12-31",189,"2021-01-01",167.06]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2020,{"$f":"(G306-G307)*$B307/365+G307","v":151.04383561643834},"2019-01-01","2019-12-31",167,"2020-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2019,142.02465753424659,"2018-01-01","2018-12-31",151,"2019-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2018,{"$f":"(G308-G309)*$B310/365+G309","v":132.02739726027397},"2017-01-01","2017-12-31",142,"2018-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2017,{"$f":"(G309-G310)*$B$239/365+G310","v":123.02465753424657},"2016-01-01","2016-12-31",132,"2017-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2016,{"$f":"(G310-G311)*$B311/365+G311","v":115.02191780821917},"2015-01-01","2015-12-31",123,"2016-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2015,{"$f":"(G311-G312)*$B312/365+G312","v":112.00821917808219},"2014-01-01","2014-12-31",115,"2015-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2014,{"$f":"(G312-G313)*$B$239/365+G313","v":109.00821917808219},"2013-01-01","2013-12-31",112,"2014-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2013,106.00821917808219,"2012-01-01","2012-12-31",109,"2013-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2012,100.01643835616439,"2011-01-01","2011-12-31",106,"2012-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2011,100,"2010-01-01","2010-12-31",100,"2011-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B302-DATE(YEAR(B302)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I303:I320),0)","v":167},{"$f":"IF(EingabeMaske!D$43=3,'Vergleichsdaten 2022'!I321,0)","v":0},{"$f":"IF(EingabeMaske!D$43=3,G306,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B230","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 4"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2023,{"$f":"(G326-G327)*$B327/365+G327","v":233},"2022-01-01","2022-12-31",233,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C326,D326,0),2)","v":0}]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2022,{"$f":"(G327-G328)*$B329/365+G328","v":211.06027397260274},"2021-01-01","2021-12-31",233,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C327,D327,0),2)","v":0}]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2021,{"$f":"(G328-G329)*$B$239/365+G329","v":190.05753424657533},"2020-01-01","2020-12-31",211,"2021-01-01",190.06]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2020,{"$f":"(G329-G330)*$B330/365+G330","v":173.04657534246576},"2019-01-01","2019-12-31",190,"2020-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2019,156.04657534246576,"2018-01-01","2018-12-31",173,"2019-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2018,{"$f":"(G331-G332)*$B333/365+G332","v":142.03835616438357},"2017-01-01","2017-12-31",156,"2018-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2017,{"$f":"(G332-G333)*$B$239/365+G333","v":128.03835616438357},"2016-01-01","2016-12-31",142,"2017-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2016,{"$f":"(G333-G334)*$B334/365+G334","v":120.02191780821917},"2015-01-01","2015-12-31",128,"2016-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2015,{"$f":"(G334-G335)*$B335/365+G335","v":113.01917808219179},"2014-01-01","2014-12-31",120,"2015-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2014,{"$f":"(G335-G336)*$B$239/365+G336","v":108.01369863013699},"2013-01-01","2013-12-31",113,"2014-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2013,104.01095890410959,"2012-01-01","2012-12-31",108,"2013-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2012,102.0054794520548,"2011-01-01","2011-12-31",104,"2012-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,"2011-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B325-DATE(YEAR(B325)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I326:I343),0)","v":190},{"$f":"IF(EingabeMaske!D$43=4,'Vergleichsdaten 2022'!I344,0)","v":0},{"$f":"IF(EingabeMaske!D$43=4,G329,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B230","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 5"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2023,{"$f":"(G349-G350)*$B350/365+G350","v":245},"2022-01-01","2022-12-31",245,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C349,D349,0),2)","v":0}]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2022,{"$f":"(G350-G351)*$B352/365+G351","v":225.05479452054794},"2021-01-01","2021-12-31",245,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C350,D350,0),2)","v":0}]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2021,{"$f":"(G351-G352)*$B$239/365+G352","v":202.06301369863013},"2020-01-01","2020-12-31",225,"2021-01-01",202.06]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2020,{"$f":"(G352-G353)*$B353/365+G353","v":183.05205479452056},"2019-01-01","2019-12-31",202,"2020-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2019,166.04657534246576,"2018-01-01","2018-12-31",183,"2019-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2018,{"$f":"(G354-G355)*$B356/365+G355","v":153.03561643835616},"2017-01-01","2017-12-31",166,"2018-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2017,{"$f":"(G355-G356)*$B$239/365+G356","v":142.03013698630136},"2016-01-01","2016-12-31",153,"2017-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2016,{"$f":"(G356-G357)*$B357/365+G357","v":132.02739726027397},"2015-01-01","2015-12-31",142,"2016-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2015,{"$f":"(G357-G358)*$B358/365+G358","v":123.02465753424657},"2014-01-01","2014-12-31",132,"2015-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2014,{"$f":"(G358-G359)*$B$239/365+G359","v":116.01917808219179},"2013-01-01","2013-12-31",123,"2014-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2013,109.01917808219179,"2012-01-01","2012-12-31",116,"2013-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2012,103.01643835616439,"2011-01-01","2011-12-31",109,"2012-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2011,100.00821917808219,"2010-01-01","2010-12-31",103,"2011-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B348-DATE(YEAR(B348)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I349:I366),0)","v":202},{"$f":"IF(EingabeMaske!D$43=5,'Vergleichsdaten 2022'!I367,0)","v":0},{"$f":"IF(EingabeMaske!D$43=5,G352,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B230","v":"2020-01-01"},"2020-01-01"]
[]
[]
["Marktsegment 6"]
["Farblegende:",{"$f":"EingabeMaske!D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2023,{"$f":"(G373-G374)*$B374/365+G374","v":261},"2022-01-01","2022-12-31",261,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C373,D373,0),2)","v":0}]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2022,{"$f":"(G374-G375)*$B376/365+G375","v":240.05753424657533},"2021-01-01","2021-12-31",261,"2022-01-01",{"$f":"ROUND(IF(YEAR($B$230)+1=C374,D374,0),2)","v":0}]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2021,{"$f":"(G375-G376)*$B$239/365+G376","v":218.06027397260274},"2020-01-01","2020-12-31",240,"2021-01-01",218.06]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2020,{"$f":"(G376-G377)*$B377/365+G377","v":200.04931506849314},"2019-01-01","2019-12-31",218,"2020-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2019,183.04657534246576,"2018-01-01","2018-12-31",200,"2019-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2018,{"$f":"(G378-G379)*$B380/365+G379","v":168.04109589041096},"2017-01-01","2017-12-31",183,"2018-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2017,{"$f":"(G379-G380)*$B$239/365+G380","v":152.04383561643834},"2016-01-01","2016-12-31",168,"2017-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2016,{"$f":"(G380-G381)*$B381/365+G381","v":138.03835616438357},"2015-01-01","2015-12-31",152,"2016-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2015,{"$f":"(G381-G382)*$B382/365+G382","v":127.03013698630137},"2014-01-01","2014-12-31",138,"2015-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2014,{"$f":"(G382-G383)*$B$239/365+G383","v":118.02465753424657},"2013-01-01","2013-12-31",127,"2014-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2013,108.02739726027397,"2012-01-01","2012-12-31",118,"2013-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2012,103.01369863013699,"2011-01-01","2011-12-31",108,"2012-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2011,100.00821917808219,"2010-01-01","2010-12-31",103,"2011-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B372-DATE(YEAR(B372)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I373:I390),0)","v":218},{"$f":"IF(EingabeMaske!D$43=6,'Vergleichsdaten 2022'!I391,0)","v":0},{"$f":"IF(EingabeMaske!D$43=6,G376,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B230","v":"2020-01-01"},"2020-01-01"]
[null,null,null,null,null,null,null,null,null,{"$f":"J275+J298+J321+J344+J367+J391","v":0},{"$f":"K275+K298+K321+K344+K367+K391","v":0}]
[]
[]
[]
[]
["Anpassung an die Mietsituation",null,null,null,"UK"]
[null,"unvermietet","Kennziffer",1,1]
[null,"vermietet","Kennziffer",2,0.93]

{"sheet":"Vergleichsdaten 2023","index":5,"n_rows":184,"n_cols":11,"rows_kept":184,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"EingabeMaske!A57","v":"Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"}]
[]
["Berücksichtigung der Wertverhältnisse zwischen dem Richtwertstichtag"]
[" und dem Wertermittlungsstichtag"]
["RLP"]
["Farblegende:",{"$f":"EingabeMaske!$D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2025,{"$f":"(G8-G11)*$B11/365+G11","v":231.04657534246576},"2024-01-01","2024-12-31",248,"2025-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C8,D8,0),2)","v":0}]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2024,{"$f":"(G9-G10)*$B11/365+G10","v":248},"2023-01-01","2023-12-31",248,"2024-01-01"]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2023,231.04657534246576,"2022-01-01","2022-12-31",248,"2023-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C10,D10,0),2)","v":0}]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2022,212.05205479452056,"2021-01-01","2021-12-31",231,"2022-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2021,{"$f":"(G12-G13)*$B$18/365+G13","v":190.06027397260274},"2020-01-01","2020-12-31",212,"2021-01-01",190.06]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2020,{"$f":"(G13-G14)*$B14/365+G14","v":172.04931506849314},"2019-01-01","2019-12-31",190,"2020-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2019,157.04109589041096,"2018-01-01","2018-12-31",172,"2019-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2018,{"$f":"(G15-G16)*$B17/365+G16","v":144.03561643835616},"2017-01-01","2017-12-31",157,"2018-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2017,{"$f":"(G16-G17)*$B$18/365+G17","v":132.03287671232877},"2016-01-01","2016-12-31",144,"2017-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2016,{"$f":"(G17-G18)*$B18/365+G18","v":122.02739726027397},"2015-01-01","2015-12-31",132,"2016-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2015,{"$f":"(G18-G19)*$B19/365+G19","v":116.01643835616439},"2014-01-01","2014-12-31",122,"2015-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2014,{"$f":"(G19-G20)*$B$18/365+G20","v":110.01643835616439},"2013-01-01","2013-12-31",116,"2014-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2013,105.01369863013699,"2012-01-01","2012-12-31",110,"2013-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2012,102.00821917808219,"2011-01-01","2011-12-31",105,"2012-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,"2011-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B7-DATE(YEAR(B7)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I8:I27),0)","v":190}]
[]
[]
[]
[]
[]
["Marktsegment 1"]
["Farblegende:",{"$f":"EingabeMaske!$D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2025,{"$f":"(G36-G39)*$B39/365+G39","v":177.05205479452056},"2024-01-01","2024-12-31",196,"2025-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C36,D36,0),2)","v":0}]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2024,{"$f":"(G37-G38)*$B39/365+G38","v":196},"2023-01-01","2023-12-31",196,"2024-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C37,D37,0),2)","v":0}]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2023,177.05205479452056,"2022-01-01","2022-12-31",196,"2023-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2022,159.04931506849314,"2021-01-01","2021-12-31",177,"2022-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2021,{"$f":"(G40-G41)*$B$18/365+G41","v":138.05753424657533},"2020-01-01","2020-12-31",159,"2021-01-01",138.06]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2020,{"$f":"(G41-G42)*$B42/365+G42","v":127.03013698630137},"2019-01-01","2019-12-31",138,"2020-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2019,118.02465753424657,"2018-01-01","2018-12-31",127,"2019-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2018,{"$f":"(G43-G44)*$B45/365+G44","v":113.01369863013699},"2017-01-01","2017-12-31",118,"2018-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2017,{"$f":"(G44-G45)*$B$18/365+G45","v":102.03013698630137},"2016-01-01","2016-12-31",113,"2017-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2016,{"$f":"(G45-G46)*$B46/365+G46","v":97.013698630136986},"2015-01-01","2015-12-31",102,"2016-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2015,{"$f":"(G46-G47)*$B47/365+G47","v":97.9972602739726},"2014-01-01","2014-12-31",97,"2015-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2014,{"$f":"(G47-G48)*$B$18/365+G48","v":92.016438356164386},"2013-01-01","2013-12-31",98,"2014-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2013,89.008219178082186,"2012-01-01","2012-12-31",92,"2013-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2012,86.008219178082186,"2011-01-01","2011-12-31",89,"2012-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2011,99.961643835616442,"2010-01-01","2010-12-31",86,"2011-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B35-DATE(YEAR(B35)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I36:I55),0)","v":138},{"$f":"IF(EingabeMaske!$D$43=1,I56,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=1,G41,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 2"]
["Farblegende:",{"$f":"EingabeMaske!$D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2025,{"$f":"(G61-G64)*$B64/365+G64","v":173.04931506849314},"2024-01-01","2024-12-31",191,"2025-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C61,D61,0),2)","v":0}]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2024,{"$f":"(G62-G63)*$B64/365+G63","v":191},"2023-01-01","2023-12-31",191,"2024-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C62,D62,0),2)","v":0}]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2023,173.04931506849314,"2022-01-01","2022-12-31",191,"2023-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2022,156.04657534246576,"2021-01-01","2021-12-31",173,"2022-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2021,{"$f":"(G65-G66)*$B$18/365+G66","v":140.04383561643834},"2020-01-01","2020-12-31",156,"2021-01-01",140.04]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2020,{"$f":"(G66-G67)*$B67/365+G67","v":128.03287671232877},"2019-01-01","2019-12-31",140,"2020-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2019,119.02465753424657,"2018-01-01","2018-12-31",128,"2019-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2018,{"$f":"(G68-G69)*$B70/365+G69","v":112.01917808219179},"2017-01-01","2017-12-31",119,"2018-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2017,{"$f":"(G69-G70)*$B$18/365+G70","v":106.01643835616439},"2016-01-01","2016-12-31",112,"2017-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2016,{"$f":"(G70-G71)*$B71/365+G71","v":102.01095890410959},"2015-01-01","2015-12-31",106,"2016-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2015,{"$f":"(G71-G72)*$B72/365+G72","v":99.008219178082186},"2014-01-01","2014-12-31",102,"2015-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2014,{"$f":"(G72-G73)*$B$18/365+G73","v":99},"2013-01-01","2013-12-31",99,"2014-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2013,98.0027397260274,"2012-01-01","2012-12-31",99,"2013-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2012,98.9972602739726,"2011-01-01","2011-12-31",98,"2012-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2011,99.9972602739726,"2010-01-01","2010-12-31",99,"2011-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B60-DATE(YEAR(B60)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I61:I80),0)","v":140},{"$f":"IF(EingabeMaske!$D$43=2,I81,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=2,G66,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 3"]
["Farblegende:",{"$f":"EingabeMaske!$D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2025,{"$f":"(G86-G89)*$B89/365+G89","v":214.05205479452056},"2024-01-01","2024-12-31",233,"2025-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C86,D86,0),2)","v":0}]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2024,{"$f":"(G87-G88)*$B89/365+G88","v":233},"2023-01-01","2023-12-31",233,"2024-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C87,D87,0),2)","v":0}]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2023,214.05205479452056,"2022-01-01","2022-12-31",233,"2023-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2022,190.06575342465754,"2021-01-01","2021-12-31",214,"2022-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2021,{"$f":"(G90-G91)*$B$18/365+G91","v":167.06301369863013},"2020-01-01","2020-12-31",190,"2021-01-01",167.06]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2020,{"$f":"(G91-G92)*$B92/365+G92","v":151.04383561643834},"2019-01-01","2019-12-31",167,"2020-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2019,142.02465753424659,"2018-01-01","2018-12-31",151,"2019-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2018,{"$f":"(G93-G94)*$B95/365+G94","v":132.02739726027397},"2017-01-01","2017-12-31",142,"2018-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2017,{"$f":"(G94-G95)*$B$18/365+G95","v":123.02465753424657},"2016-01-01","2016-12-31",132,"2017-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2016,{"$f":"(G95-G96)*$B96/365+G96","v":115.02191780821917},"2015-01-01","2015-12-31",123,"2016-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2015,{"$f":"(G96-G97)*$B97/365+G97","v":112.00821917808219},"2014-01-01","2014-12-31",115,"2015-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2014,{"$f":"(G97-G98)*$B$18/365+G98","v":109.00821917808219},"2013-01-01","2013-12-31",112,"2014-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2013,106.00821917808219,"2012-01-01","2012-12-31",109,"2013-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2012,100.01643835616439,"2011-01-01","2011-12-31",106,"2012-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2011,100,"2010-01-01","2010-12-31",100,"2011-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B85-DATE(YEAR(B85)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I86:I105),0)","v":167},{"$f":"IF(EingabeMaske!$D$43=3,I106,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=3,G91,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 4"]
["Farblegende:",{"$f":"EingabeMaske!$D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2025,{"$f":"(G111-G114)*$B114/365+G114","v":245.96438356164384},"2024-01-01","2024-12-31",233,"2025-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C111,D111,0),2)","v":0}]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2024,{"$f":"(G112-G113)*$B114/365+G113","v":273},"2023-01-01","2023-12-31",273,"2024-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C112,D112,0),2)","v":0}]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2023,246.07397260273973,"2022-01-01","2022-12-31",273,"2023-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2022,218.07671232876712,"2021-01-01","2021-12-31",246,"2022-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2021,{"$f":"(G115-G116)*$B$18/365+G116","v":191.07397260273973},"2020-01-01","2020-12-31",218,"2021-01-01",191.07]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2020,{"$f":"(G116-G117)*$B117/365+G117","v":173.04931506849314},"2019-01-01","2019-12-31",191,"2020-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2019,156.04657534246576,"2018-01-01","2018-12-31",173,"2019-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2018,{"$f":"(G118-G119)*$B120/365+G119","v":142.03835616438357},"2017-01-01","2017-12-31",156,"2018-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2017,{"$f":"(G119-G120)*$B$18/365+G120","v":128.03835616438357},"2016-01-01","2016-12-31",142,"2017-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2016,{"$f":"(G120-G121)*$B121/365+G121","v":120.02191780821917},"2015-01-01","2015-12-31",128,"2016-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2015,{"$f":"(G121-G122)*$B122/365+G122","v":113.01917808219179},"2014-01-01","2014-12-31",120,"2015-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2014,{"$f":"(G122-G123)*$B$18/365+G123","v":108.01369863013699},"2013-01-01","2013-12-31",113,"2014-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2013,104.01095890410959,"2012-01-01","2012-12-31",108,"2013-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2012,102.0054794520548,"2011-01-01","2011-12-31",104,"2012-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,"2011-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B110-DATE(YEAR(B110)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I111:I130),0)","v":191},{"$f":"IF(EingabeMaske!D$43=4,I131,0)","v":0},{"$f":"IF(EingabeMaske!E$43=4,G116,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 5"]
["Farblegende:",{"$f":"EingabeMaske!$D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B$135-DATE(YEAR(B$135)-1,12,31.25)","v":1},2025,{"$f":"(G136-G139)*$B139/365+G139","v":235.02739726027397},"2024-01-01","2024-12-31",245,"2025-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C136,D136,0),2)","v":0}]
[null,{"$f":"B$135-DATE(YEAR(B$135)-1,12,31.25)","v":1},2024,{"$f":"(G137-G138)*$B139/365+G138","v":245},"2023-01-01","2023-12-31",245,"2024-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C137,D137,0),2)","v":0}]
[null,1,2023,235.02739726027397,"2022-01-01","2022-12-31",245,"2023-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2022,222.03561643835616,"2021-01-01","2021-12-31",235,"2022-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2021,{"$f":"(G140-G141)*$B$18/365+G141","v":203.05205479452056},"2020-01-01","2020-12-31",222,"2021-01-01",203.05]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2020,{"$f":"(G141-G142)*$B142/365+G142","v":183.05479452054794},"2019-01-01","2019-12-31",203,"2020-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2019,166.04657534246576,"2018-01-01","2018-12-31",183,"2019-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2018,{"$f":"(G143-G144)*$B145/365+G144","v":153.03561643835616},"2017-01-01","2017-12-31",166,"2018-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2017,{"$f":"(G144-G145)*$B$18/365+G145","v":142.03013698630136},"2016-01-01","2016-12-31",153,"2017-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2016,{"$f":"(G145-G146)*$B146/365+G146","v":132.02739726027397},"2015-01-01","2015-12-31",142,"2016-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2015,{"$f":"(G146-G147)*$B147/365+G147","v":123.02465753424657},"2014-01-01","2014-12-31",132,"2015-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2014,{"$f":"(G147-G148)*$B$18/365+G148","v":116.01917808219179},"2013-01-01","2013-12-31",123,"2014-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2013,109.01917808219179,"2012-01-01","2012-12-31",116,"2013-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2012,103.01643835616439,"2011-01-01","2011-12-31",109,"2012-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2011,100.00821917808219,"2010-01-01","2010-12-31",103,"2011-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B135-DATE(YEAR(B135)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I136:I155),0)","v":203},{"$f":"IF(EingabeMaske!$D$43=5,I156,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=5,G141,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[]
[]
["Marktsegment 6"]
["Farblegende:",{"$f":"EingabeMaske!$D$15","v":"2020-01-01"},null,null,"Interpolation!",null,"Index","Stichtag","Ergänzung "]
["Fester Wert",{"$f":"B$161-DATE(YEAR(B$161)-1,12,31.25)","v":1},2025,{"$f":"(G162-G165)*$B165/365+G165","v":270.06575342465754},"2024-01-01","2024-12-31",294,"2025-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C162,D162,0),2)","v":0}]
[null,{"$f":"B$161-DATE(YEAR(B$161)-1,12,31.25)","v":1},2024,{"$f":"(G163-G164)*$B165/365+G164","v":294},"2023-01-01","2023-12-31",294,"2024-01-01",{"$f":"ROUND(IF(YEAR($B$7)+1=C163,D163,0),2)","v":0}]
[null,1,2023,270.06575342465754,"2022-01-01","2022-12-31",294,"2023-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2022,245.06849315068493,"2021-01-01","2021-12-31",270,"2022-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2021,{"$f":"(G166-G167)*$B$18/365+G167","v":218.07397260273973},"2020-01-01","2020-12-31",245,"2021-01-01",218.07]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2020,{"$f":"(G167-G168)*$B168/365+G168","v":200.04931506849314},"2019-01-01","2019-12-31",218,"2020-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2019,183.04657534246576,"2018-01-01","2018-12-31",200,"2019-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2018,{"$f":"(G169-G170)*$B171/365+G170","v":168.04109589041096},"2017-01-01","2017-12-31",183,"2018-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2017,{"$f":"(G170-G171)*$B$18/365+G171","v":152.04383561643834},"2016-01-01","2016-12-31",168,"2017-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2016,{"$f":"(G171-G172)*$B172/365+G172","v":138.03835616438357},"2015-01-01","2015-12-31",152,"2016-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2015,{"$f":"(G172-G173)*$B173/365+G173","v":127.03013698630137},"2014-01-01","2014-12-31",138,"2015-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2014,{"$f":"(G173-G174)*$B$18/365+G174","v":118.02465753424657},"2013-01-01","2013-12-31",127,"2014-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2013,108.02739726027397,"2012-01-01","2012-12-31",118,"2013-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2012,103.01369863013699,"2011-01-01","2011-12-31",108,"2012-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2011,100.00821917808219,"2010-01-01","2010-12-31",103,"2011-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,"2010-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2009,99,"2008-01-01","2008-12-31",99,"2009-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2008,99.9972602739726,"2007-01-01","2007-12-31",99,"2008-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2007,98.0054794520548,"2006-01-01","2006-12-31",100,"2007-01-01",0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2006,0.26849315068493151,"2005-01-01","2005-12-31",98,"2006-01-01",0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I162:I181),0)","v":218},{"$f":"IF(EingabeMaske!$D$43=6,I182,0)","v":0},{"$f":"IF(EingabeMaske!$D$43=6,G167,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-01"},"2020-01-01"]
[null,null,null,null,null,null,null,null,null,{"$f":"J56+J81+J106+J131+J156+J182","v":0},{"$f":"K56+K81+K106+K131+K156+K182","v":0}]

{"sheet":"GebStandard","index":6,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,6,1,10],[24,1,24,3]]}
[null,"Gebäudestandards und Wägungsanteile für Mehrfamilienhäuser und Wohnhäuser mit Mischnutzung;\n\nStufen 3 - 5 gemäß Anlage 2 der SW-RL,\n\nStufen 1 + 2 Ergänzungen durch Sprengnetter"]
[null,null,null,null,null,null,{"$f":"EingabeMaske!A57","v":"Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2021"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner 1 - 2023"}]
[null,"Wägungsan- teile (∑100 %)","Stufe 1",null,"Stufe 2",null,"Stufe 3",null,"Stufe 4",null,"Stufe 5"]
[null,"Außenwände","Holzfachwerk, Ziegelmauerwerk; Fugenglattstrich, Putz, Verkleidung mit Faserzementplatten, Bitumenschindeln oder einfachen Kunststoffplatten; kein oder deutlich nicht zeitgemäßer Wärmeschutz (vor ca. 1980)",null,"ein-/zweischaliges Mauerwerk, z. B. Gitterziegel oder Hohlblocksteine; verputzt und gestrichen oder Holzverkleidung; nicht zeitgemäßer Wärmeschutz (vor ca. 1995)",null,"ein-/zweischaliges Mauerwerk, z. B. aus Leichtziegeln, Kalksandsteinen, Gasbetonsteinen; Edelputz; Wärmedämmverbundsystem oder Wärmedämmputz (nach ca. 1995)",null,"Verblendmauerwerk, zweischalig, hinterlüftet, Vorhangfassade (z. B. Naturschiefer); Wärmedämmung (nach ca. 2005)",null,"aufwendig gestaltete Fassaden mit konstruktiver Gliederung (Säulenstell-ungen, Erker etc.), Sichtbeton-Fertig-teile, Natursteinfassade, Elemente aus Kupfer-/Eloxalblech, mehrgeschoss. Glasfassaden; hochwertigste Dämmung",null,null,{"$f":"IF(N6=TRUE,1,0)","v":0},{"$f":"IF(O6=TRUE,1,0)","v":0},1,0,0]
[null,"23%",{"$f":"ROUND($B6/$S6*N5,4)","v":0},null,{"$f":"ROUND($B6/$S6*O5,4)","v":0},null,{"$f":"ROUND($B6/$S6*P5,4)","v":0.23},null,{"$f":"ROUND($B6/$S6*Q5,4)","v":0},null,{"$f":"ROUND($B6/$S6*R5,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N6:R6,TRUE)","v":1}]
[null,"Dach","Dachpappe, Faserzementplatten/ Wellplatten; keine bis geringe Dachdämmung",null,"einfache Betondachsteine oder Tondachziegel,  Bitumenschindeln; nicht zeitgemäße Dachdämmung (vor ca. 1995)",null,"Faserzement-Schindeln, beschichtete Betondachsteine und Tondachziegel, Folienabdichtung; Dachdämmung (nach ca. 1995)",null,"glasierte Tondachziegel, Flachdach- ausbildung tlw. als Dachterrassen; Konstruktion in Brettschichtholz, schweres Massivflachdach; besondere Dachformen, z. B. Mansarden-, Walmdach; Aufsparrendämmung, überdurchschn. Dämmung (nach ca. 2005)",null,"hochwertige Eindeckung z. B. aus Schiefer oder Kupfer, Dachbegrünung, befahrbares Flachdach; stark überdurchschnittliche Dämmung",null,null,{"$f":"IF(N8=TRUE,1,0)","v":0},{"$f":"IF(O8=TRUE,1,0)","v":0},{"$f":"IF(P8=TRUE,1,0)","v":1},{"$f":"IF(Q8=TRUE,1,0)","v":0},{"$f":"IF(R8=TRUE,1,0)","v":0}]
[null,"15%",{"$f":"ROUND($B8/$S8*N7,4)","v":0},null,{"$f":"ROUND($B8/$S8*O7,4)","v":0},null,{"$f":"ROUND($B8/$S8*P7,4)","v":0.15},null,{"$f":"ROUND($B8/$S8*Q7,4)","v":0},null,{"$f":"ROUND($B8/$S8*R7,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N8:R8,TRUE)","v":1}]
[null,"Fenster und Außentüren","Einfachverglasung; einfache Holztüren",null,"Zweifachverglasung (vor ca. 1995); Haustür mit nicht zeitgemäßem Wärmeschutz (vor ca. 1995)",null,"Zweifachverglasung (nach ca. 1995), Rollläden (manuell); Haustür mit zeitgemäßem Wärmeschutz (nach ca. 1995)",null,"Dreifachverglasung, Sonnenschutz- glas, aufwendigere Rahmen, Rollläden (elektr.); höherwertige Türanlagen z. B. mit Seitenteil, besonderer Einbruchschutz",null,"große feststehende Fensterflächen, Spezialverglasung (Schall- und Sonnenschutz); Außentüren in hochwertigen Materialien",null,null,{"$f":"IF(N10=TRUE,1,0)","v":0},{"$f":"IF(O10=TRUE,1,0)","v":0},{"$f":"IF(P10=TRUE,1,0)","v":1},{"$f":"IF(Q10=TRUE,1,0)","v":0},{"$f":"IF(R10=TRUE,1,0)","v":0}]
[null,"11%",{"$f":"ROUND($B10/$S10*N9,4)","v":0},null,{"$f":"ROUND($B10/$S10*O9,4)","v":0},null,{"$f":"ROUND($B10/$S10*P9,4)","v":0.11},null,{"$f":"ROUND($B10/$S10*Q9,4)","v":0},null,{"$f":"ROUND($B10/$S10*R9,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N10:R10,TRUE)","v":1}]
[null,"Innenwände und -türen","Fachwerkwände, einfache Putze/Lehmputze, einfache Kalkanstriche; Füllungstüren, gestrichen, mit einfachen Beschlägen ohne Dichtungen",null,"massive tragende Innenwände, nicht tragende Wände in Leichtbauweise   (z. B. Holzständerwände mit Gipskarton), Gipsdielen; leichte Türen, Stahlzargen",null,"nicht tragende Innenwände in massiver Ausführung bzw. mit Dämmmaterial gefüllte Ständerkonstruktionen; schwere Türen",null,"Sichtmauerwerk; Massivholztüren, Schiebetürelemente, Glastüren, strukturierte Türblätter",null,"gestaltete Wandabläufe (z. B. Pfeilervorlagen, abgesetzte oder geschwungene Wandpartien);  Brandschutzverkleidung; raumhohe aufwendige Türelemente",null,null,{"$f":"IF(N12=TRUE,1,0)","v":0},{"$f":"IF(O12=TRUE,1,0)","v":0},{"$f":"IF(P12=TRUE,1,0)","v":1},{"$f":"IF(Q12=TRUE,1,0)","v":0},{"$f":"IF(R12=TRUE,1,0)","v":0}]
[null,"11%",{"$f":"ROUND($B12/$S12*N11,4)","v":0},null,{"$f":"ROUND($B12/$S12*O11,4)","v":0},null,{"$f":"ROUND($B12/$S12*P11,4)","v":0.11},null,{"$f":"ROUND($B12/$S12*Q11,4)","v":0},null,{"$f":"ROUND($B12/$S12*R11,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N12:R12,TRUE)","v":1}]
[null,"Deckenkon- struktion","Holzbalkendecken ohne Füllung, Spalierputz",null,"Holzbalkendecken mit Füllung, Kappendecken",null,"Betondecken mit Tritt- und Luftschallschutz (z. B. schwimmender Estrich); einfacher Putz",null,"zusätzlich Deckenverkleidung",null,"Deckenvertäfelungen (Edelholz, Metall)",null,null,{"$f":"IF(N14=TRUE,1,0)","v":0},{"$f":"IF(O14=TRUE,1,0)","v":0},{"$f":"IF(P14=TRUE,1,0)","v":1},{"$f":"IF(Q14=TRUE,1,0)","v":0},{"$f":"IF(R14=TRUE,1,0)","v":0}]
[null,"11%",{"$f":"ROUND($B14/$S14*N13,4)","v":0},null,{"$f":"ROUND($B14/$S14*O13,4)","v":0},null,{"$f":"ROUND($B14/$S14*P13,4)","v":0.11},null,{"$f":"ROUND($B14/$S14*Q13,4)","v":0},null,{"$f":"ROUND($B14/$S14*R13,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N14:R14,TRUE)","v":1}]
[null,"Fußböden ","ohne Belag",null,"Linoleum-, Teppich-, Laminat- und PVC-Böden einfacher Art und Ausführung",null,"Linoleum-, Teppich-, Laminat- und PVC-Böden besserer Art und Ausführung, Fliesen, Kunststeinplatten",null,"Natursteinplatten, Fertigparkett, hochwertige Fliesen, Terrazzobelag, hochwertige Massivholzböden auf aufgedämmter Unterkonstruktion",null,"hochwertiges Parkett, hochwertige Natursteinplatten, hochwertige Edelholzböden auf gedämmter Unterkonstruktion",null,null,{"$f":"IF(N16=TRUE,1,0)","v":0},{"$f":"IF(O16=TRUE,1,0)","v":0},{"$f":"IF(P16=TRUE,1,0)","v":1},{"$f":"IF(Q16=TRUE,1,0)","v":0},{"$f":"IF(R16=TRUE,1,0)","v":0}]
[null,"5%",{"$f":"ROUND($B16/$S16*N15,4)","v":0},null,{"$f":"ROUND($B16/$S16*O15,4)","v":0},null,{"$f":"ROUND($B16/$S16*P15,4)","v":0.05},null,{"$f":"ROUND($B16/$S16*Q15,4)","v":0},null,{"$f":"ROUND($B16/$S16*R15,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N16:R16,TRUE)","v":1}]
[null,"Sanitärein- richtungen","einfaches Bad mit Stand-WC; Installation auf Putz, Ölfarbenanstrich, einfache PVC-Bodenbeläge",null,"1 Bad mit WC, Dusche oder Badewanne; einfache Wand- und Bodenfliesen, teilweise gefliest",null,"1 Bad mit WC je Wohneinheit; Dusche und  Badewanne;  Wand- und Bodenfliesen, raumhoch gefliest",null,"1 – 2 Bäder je Wohneinheit mit tlw. zwei Waschbecken, tlw. Bidet/ Urinal, Gäste-WC, bodengleiche Dusche; Wand- und Bodenfliesen jeweils in gehobener Qualität",null,"2 und mehr Bäder je Wohneinheit; hochwertige Wand- und Bodenplatten (oberflächenstrukturiert, Einzel- und Flächendekors)",null,null,{"$f":"IF(N18=TRUE,1,0)","v":0},{"$f":"IF(O18=TRUE,1,0)","v":0},{"$f":"IF(P18=TRUE,1,0)","v":1},{"$f":"IF(Q18=TRUE,1,0)","v":0},{"$f":"IF(R18=TRUE,1,0)","v":0}]
[null,"9%",{"$f":"ROUND($B18/$S18*N17,4)","v":0},null,{"$f":"ROUND($B18/$S18*O17,4)","v":0},null,{"$f":"ROUND($B18/$S18*P17,4)","v":0.09},null,{"$f":"ROUND($B18/$S18*Q17,4)","v":0},null,{"$f":"ROUND($B18/$S18*R17,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N18:R18,TRUE)","v":1}]
[null,"Heizung","Einzelöfen, Schwerkraftheizung",null,"Fern- oder Zentralheizung, einfache Warmluftheizung, einzelne Gasaußen-wandthermen, Nachtstromspeicher-, Fußbodenheizung (vor ca. 1995)",null,"elektronisch gesteuerte Fern- oder Zentralheizung, Niedertemperatur- oder Brennwertkessel",null,"Fußbodenheizung, Solarkollektoren für Warmwassererzeugung",null,"Solarkollektoren für Warmwassererzeugung und Heizung, Blockheizkraftwerk, Wärmepumpe, Hybrid-Systeme",null,null,{"$f":"IF(N20=TRUE,1,0)","v":0},{"$f":"IF(O20=TRUE,1,0)","v":0},{"$f":"IF(P20=TRUE,1,0)","v":1},{"$f":"IF(Q20=TRUE,1,0)","v":0},{"$f":"IF(R20=TRUE,1,0)","v":0}]
[null,"9%",{"$f":"ROUND($B20/$S20*N19,4)","v":0},null,{"$f":"ROUND($B20/$S20*O19,4)","v":0},null,{"$f":"ROUND($B20/$S20*P19,4)","v":0.09},null,{"$f":"ROUND($B20/$S20*Q19,4)","v":0},null,{"$f":"ROUND($B20/$S20*R19,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N20:R20,TRUE)","v":1}]
[null,"Sonstige technische Ausstattung","sehr wenige Steckdosen, Schalter und Sicherungen, kein Fehlerstromschutzschalter (FI-Schalter), Leitungen teilweise auf Putz",null,"wenige Steckdosen, Schalter und Sicherungen",null,"zeitgemäße Anzahl an Steckdosen und Lichtauslässen; Zählerschrank (ab ca. 1985) mit Unterverteilung und Kippsicherungen",null,"zahlreiche Steckdosen und Lichtaus- lässe, hochwertige Abdeckungen, de-zentrale Lüftung mit Wärme- tauscher, mehrere LAN- und Fernseh-anschlüsse, Personenaufzugsanlagen",null,"Video- und zentrale Alarmanlage, zentrale Lüftung mit Wärmetauscher, Klimaanlage, Bussystem; aufwendige Personenaufzugsanlagen",null,null,{"$f":"IF(N22=TRUE,1,0)","v":0},{"$f":"IF(O22=TRUE,1,0)","v":0},{"$f":"IF(P22=TRUE,1,0)","v":1},{"$f":"IF(Q22=TRUE,1,0)","v":0},{"$f":"IF(R22=TRUE,1,0)","v":0}]
[null,"6%",{"$f":"ROUND($B22/$S22*N21,4)","v":0},null,{"$f":"ROUND($B22/$S22*O21,4)","v":0},null,{"$f":"ROUND($B22/$S22*P21,4)","v":0.06},null,{"$f":"ROUND($B22/$S22*Q21,4)","v":0},null,{"$f":"ROUND($B22/$S22*R21,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N22:R22,TRUE)","v":1}]
[null,"Summe",{"$f":"SUM(C6:C22)","v":0},null,{"$f":"SUM(E6:E22)","v":0},null,{"$f":"SUM(G6:G22)","v":1},null,{"$f":"SUM(I6:I22)","v":0},null,{"$f":"SUM(K6:K22)","v":0}]
[null,"GND [Jahre]",60,null,65,null,70,null,75,null,80]
[null,"Gesamtnutzungsdauer (Jahre, gewogen):",null,null,{"$f":"ROUND((C$24*C$23+E$24*E$23+G$24*G$23+I$24*I$23+K$24*K$23),1)","v":70},null,"Standardstufe (gewogen):",null,{"$f":"(1*C23+2*E23+3*G23+4*I23+5*K23)","v":3}]

{"sheet":"RND","index":7,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,3],[32,5,32,7],[33,0,33,4],[33,5,33,8],[26,0,31,0],[26,5,26,8],[27,1,27,4],[27,5,27,8],[28,1,28,4],[28,5,28,7],[29,1,29,8],[30,1,30,4],[30,5,30,7],[31,5,31,7],[25,11,25,15],[14,0,16,9],[17,0,17,9],[18,0,18,4],[18,5,18,7],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,8],[25,0,25,8],[10,0,10,4],[10,5,10,7],[11,0,11,4],[11,5,11,7],[12,0,12,4],[12,5,12,7],[7,0,7,4],[7,5,7,7],[8,0,8,4],[8,5,8,7],[9,0,9,4],[9,5,9,7],[4,0,4,4],[4,5,4,7],[5,0,5,4],[5,5,5,7],[6,0,6,4],[6,5,6,7],[0,29,3,29],[0,0,0,9],[1,0,1,9],[2,1,2,4],[2,5,2,7],[2,9,3,9],[3,0,3,4],[3,5,3,7]]}
["Modell zur Ableitung der wirtschaftlichen Restnutzungsdauer für Wohngebäude unter Berücksichtigung von Modernisierungen\n(SW-RL Anl. 4) "]
["in Anlehung an Ein- und Zweifamilienhäuser"]
["Objekt",null,null,null,null,"Satz-Nr.",null,null,null," Kommentar"]
["Modernisierungselemente",null,null,null,null,"max. Punkte",null,null,"tats. Punkte"]
["Dacherneuerung inklusive Verbesserung der Wärmedämmung",null,null,null,null,4,null,null,null,null,60,1]
["Modernisierung der Fenster und Außentüren",null,null,null,null,{"$f":"IF(I6>3,\"TILT max. 2 \",2)","v":2},null,null,null,null,65,2]
["Modernisierung der Leitungssysteme (Strom, Gas, Wasser, Abwasser)",null,null,null,null,{"$f":"IF(I7>3,\"TILT max. 2 \",2)","v":2},null,null,null,null,70,3]
["Modernisierung der Heizungsanlage",null,null,null,null,{"$f":"IF(I8>3,\"TILT max. 2 \",2)","v":2},null,null,null,null,75,4]
["Wärmedämmung der Außenwände",null,null,null,null,4,null,null,null,null,80]
["Modernisierung von Bädern ",null,null,null,null,{"$f":"IF(I10>3,\"TILT max. 2 \",2)","v":2},null,null,null,null,90]
["Modernisierung des Innenausbaus, z.B. Decken, Fußböden, Treppen",null,null,null,null,2,null,null,null,null,null,{"$f":"IF(AND(I3<>\"\",I13=0),\"Einblenden\",\"Ausblenden\")","v":"Ausblenden"}]
["Wesentliche Verbesserung der Grundrissgestaltung",null,null,null,null,2]
["Summe",null,null,null,null,{"$f":"SUM(F5:F12)","v":20},null,null,{"$f":"SUM(I5:I12)","v":0},null,null,{"$f":"IF(I13>0,#REF!=0)","v":false}]
[]
["Liegen die Maßnahmen weiter zurück, ist zu prüfen, ob nicht ein geringerer als der maximale Tabellenwert anzusetzen ist.\nSofern nicht modernisierte Bauelemente noch zeitgemäßen Ansprüchen genügen, sind entsprechende Punkte zu vergeben."]
[]
[]
[]
["Modernisierungsgrad",null,null,null,null,"Punkte",null,null,null,null,null,"Modernisierungsgrad","a","b","c","ab einem relativen Alter [%] von *)",null,"Formel\nanwendbar"]
["nicht modernisiert",null,null,null,null,0,"-",1,{"$f":"IF(AND(I13<>\"\",F20<=I13,H20>=I13,I13<1),I13,IF((F20<=I13)*OR(H20>=I13),I13,0))","v":0},null,null,"≤ 1 Punkt",1.2500000000000001E-2,2.625,152.5,60,24,{"$f":"IF(AND(I13<2,L29>(P20-1)),1,0)","v":1}]
["kleine Modernisierung im Rahmen der Instandhaltung",null,null,null,null,2,"-",5,{"$f":"IF(AND(I13<>\"\",F21<=I13,H21>=I13,I13<1),I13,IF(AND(J24<>\"\",F21<=J24,H21>=J24),J24,IF((F21<=I13)*OR(H21>=I13),I13,0)))","v":0},null,null,"4 Punkte",7.3000000000000001E-3,1.577,111.33,40,0,{"$f":"IF(AND(I21<>0,L29>(P21-1)),1,0)","v":0}]
["mittlerer Modernisierungsgrad",null,null,null,null,6,"-",10,{"$f":"IF(AND(I13<>\"\",F22<=I13,H22>=I13,I13<1),I13,IF((F22<=I13)*OR(H22>=I13),I13,0))","v":0},null,null,"8 Punkte",5.0000000000000001E-3,1.1000000000000001,100,20,0,{"$f":"IF(AND(I22<>0,L29>(P22-1)),1,0)","v":0}]
["überwiegend modernisiert",null,null,null,null,11,"-",17,{"$f":"IF(AND(I13<>\"\",F23<=I13,H23>=I13<1),,IF((F23<=I13)*OR(H23>=I13),I13,0))","v":0},null,null,"13 Punkte",3.3E-3,0.73499999999999999,95.28,15,0,{"$f":"IF(AND(I23<>0,L29>(P23-1)),1,0)","v":0}]
["umfassend modernisiert",null,null,null,null,18,"-",20,{"$f":"IF(AND(I13<>\"\",F24<=I13,H24>=I13,I13<1),I13,IF((F24<=I13)*OR(H24>=I13),I13,0))","v":0},null,null,"≥ 18 Punkte",2E-3,0.44,94.2,10,0,{"$f":"IF(AND(I24<>0,L29>(P24-1)),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe",{"$f":"SUM(Q20:Q24)","v":24},{"$f":"SUM(R20:R24)","v":1}]
["Ermittlung der Restnutzungsdauer und des rechnerischen Baujahres",null,null,null,null,null,null,null,null,null,null,"Maximales tatsächliches Gebäudealter unter Berücksichtigung\nder gewählten Gesamtnutzungsdauer:"]
["Vorgaben","Stichtag",null,null,"nur das Jahr !",{"$f":"YEAR(EingabeMaske!D15)","v":2020},null,null,null,null,null,36]
[null,"Baujahr",null,null,null,{"$f":"EingabeMaske!D26","v":1990},null,null,null,null,null,"Berechnung des relativen Gebäudealters (Alter/GNDx100):"]
[null,"tatsächliches Alter",null,null,null,{"$f":"F27-F28","v":30},null,null,"Jahre",null,null,60,"%"]
[null,"Bestimmung der Restnutzungsdauer bei ausstattungsabhängiger Gesamtnutzungsdauer nach SW-RL Anlage 3 "]
[null,"Gesamtnutzungsdauer (60 - 80 Jahre)",null,null,null,{"$f":"EingabeMaske!D27","v":70},null,null,"Jahre"]
[null,"wirtschaftliche gerechnete Restnutzungsdauer nach SW-RL",null,null,null,{"$f":"ROUND('modifizierte RND'!D10,0)","v":40},null,null,"Jahre"]
[null,"lineare Alterswertminderung",null,null,null,{"$f":"ROUND((F31-F32)/F31*100,0)","v":43},null,null,"%"]

{"sheet":"Vergleichsfaktoren","index":8,"n_rows":272,"n_cols":6,"rows_kept":272,"cut":false,"hidden":true,"merged":[]}
["Nummer der Gemarkung"," Gemeinde / Gemarkung","Boden-wert - Niveau €/m²","Vergleichs-faktor         €/m² Wf","Sachwert-faktor           ø RLP","Regionaler Zu-/Abschlag"]
[119,"Altenkirchen (Ww) / Altenkirchen              ",85,1160,1.02,-0.03]
[4031,"Altrip / Altrip                    ",340,2335,1.45,0.02]
[3831,"Alzey / Alzey                     ",205,1685,1.28,0]
[1314,"Andernach / Andernach                 ",180,1650,1.24,0]
[5420,"Annweiler am Trifels / Annweiler                 ",160,1625,1.19,-0.03]
[5372,"Bad Bergzabern / Bad Bergzabern            ",235,1750,1.33,0]
[1151,"Bad Breisig / Niederbreisig             ",130,1460,1.1399999999999999,0.03]
[1152,"Bad Breisig / Oberbreisig               ",125,1440,1.1299999999999999,0.03]
[4351,"Bad Dürkheim / Bad Dürkheim              ",285,2190,1.39,7.0000000000000007E-2]
[4354,"Bad Dürkheim / Grethen                   ",200,1825,1.27,7.0000000000000007E-2]
[4355,"Bad Dürkheim / Hardenburg                ",160,1595,1.21,7.0000000000000007E-2]
[950,"Bad Ems / Ems                       ",85,1175,1.02,-0.02]
[326,"Bad Hönningen / Hönningen                 ",120,1380,1.1200000000000001,0]
[1942,"Bad Kreuznach / Bad Kreuznach Nord",170,1715,1.21,0]
[1976,"Bad Kreuznach / Bad Münster a.Stein       ",210,1775,1.29,0]
[1977,"Bad Kreuznach / Ebernburg                 ",180,1650,1.24,0]
[465,"Bad Marienberg (Ww) / Bad Marienberg            ",105,1305,1.08,0]
[1101,"Bad Neuenahr-Ahrweiler / Ahrweiler                 ",310,2220,1.41,0.03]
[1102,"Bad Neuenahr-Ahrweiler / Bad Neuenahr              ",320,2255,1.42,0.03]
[1104,"Bad Neuenahr-Ahrweiler / Lohrsdorf                 ",140,1675,1.1499999999999999,0.03]
[2043,"Bad Sobernheim / Sobernheim                ",75,1295,0.97,-0.02]
[2254,"Baumholder / Baumholder                ",40,670,0.85,-0.1]
[3964,"Beindersheim b.Frankenthal / Beindersheim              ",270,1965,1.37,0.01]
[5619,"Bellheim / Bellheim                  ",210,2015,1.26,0.01]
[1341,"Bendorf / Bendorf                   ",175,1625,1.23,0]
[1342,"Bendorf / Sayn                      ",165,1580,1.21,0]
[2432,"Bernkastel-Kues / Kues                      ",155,1870,1.1599999999999999,0.01]
[39,"Betzdorf / Betzdorf                  ",85,1160,1.02,-0.03]
[3522,"Bingen am Rhein / Bingen                    ",270,2180,1.36,0.02]
[3521,"Bingen am Rhein / Bingerbrück               ",150,1535,1.18,0.02]
[3525,"Bingen am Rhein / Büdesheim                 ",240,1925,1.33,0.02]
[2323,"Birkenfeld / Birkenfeld                ",43,865,0.85,-7.0000000000000007E-2]
[3977,"Birkenheide / Birkenheide               ",285,2100,1.39,0.01]
[2957,"Bitburg / Bitburg     ",105,1555,1.06,0.04]
[3951,"Bobenheim-Roxheim / Bobenheim                 ",265,2010,1.36,0.01]
[3952,"Bobenheim-Roxheim / Roxheim                   ",285,1835,1.41,0.01]
[4415,"Bockenheim a.d. Weinstr. / Kleinbockenheim           ",190,1695,1.25,0.01]
[3623,"Bodenheim / Bodenheim                 ",395,2565,1.5,0.03]
[4007,"Böhl-Iggelheim / Iggelheim                 ",275,2060,1.37,0.02]
[4573,"Bolanden / Bolanden                  ",95,1165,1.06,0.01]
[3052,"Bollendorf / Bollendorf                ",78,1625,0.96,7.0000000000000007E-2]
[1820,"Boppard / Boppard                   ",145,1495,1.17,-0.04]
[3596,"Budenheim / Budenheim                 ",440,2830,1.53,0.04]
[4444,"Carlsberg / Carlsberg                 ",120,1335,1.1200000000000001,0.01]
[1531,"Cochem / Cochem                    ",100,1275,1.06,-0.04]
[1533,"Cochem / Cond                      ",110,1555,1.06,-0.04]
[5321,"Dahn / Dahn                      ",100,1150,1.08,-0.03]
[3994,"Dannstadt-Schauernheim / Dannstadt                 ",275,2045,1.37,0.01]
[3350,"Daun / Daun                      ",80,1145,1,-0.02]
[3645,"Dexheim / Dexheim                   ",210,1775,1.29,0]
[775,"Diez / Diez                      ",100,1245,1.06,-0.02]
[4408,"Dirmstein / Dirmstein                 ",230,1875,1.32,0.01]
[4056,"Dudenhofen / Dudenhofen                ",315,2260,1.42,0.04]
[5466,"Edenkoben / Edenkoben                 ",245,1980,1.34,0.04]
[243,"Ehlscheid / Ehlscheid                 ",90,1135,1.05,0]
[4502,"Eisenberg (Pfalz) / Eisenberg                 ",130,1295,1.1499999999999999,-0.02]
[4503,"Eisenberg (Pfalz) / Stauf                     ",85,1175,1.02,-0.02]
[1803,"Emmelshausen / Emmelshausen              ",95,1200,1.05,-0.04]
[3603,"Essenheim / Essenheim                 ",420,2645,1.52,0.02]
[5330,"Fischbach bei Dahn / Fischbach                 ",70,865,1,-0.03]
[2610,"Föhren / Föhren                    ",110,1615,1.08,0.1]
[4204,"Frankenthal (Pfalz) / Flomersheim               ",270,2020,1.37,0]
[4202,"Frankenthal (Pfalz) / Frankenthal               ",310,1980,1.43,0]
[4201,"Frankenthal (Pfalz) / Mörsch                    ",260,1985,1.36,0]
[4369,"Freinsheim / Freinsheim                ",280,2540,1.35,0.06]
[3978,"Fußgönheim / Fußgönheim                ",265,2080,1.36,0.01]
[3568,"Gau-Algesheim / Gau-Algesheim             ",285,2100,1.39,0.01]
[3810,"Gau-Odernheim / Gau-Odernheim             ",150,1570,1.18,0]
[3542,"Gensingen / Gensingen                 ",165,1580,1.21,0]
[5631,"Germersheim / Germersheim               ",245,1835,1.35,0.03]
[5632,"Germersheim / Sondernheim               ",215,1775,1.3,0.03]
[4407,"Gerolsheim / Gerolsheim                ",210,1895,1.27,0.01]
[3308,"Gerolstein / Gerolstein                ",55,920,0.92,-0.02]
[4428,"Grünstadt / Sausenheim                ",275,1975,1.39,0.04]
[430,"Hachenburg / Hachenburg                ",120,1380,1.1200000000000001,0]
[5696,"Hagenbach / Hagenbach                 ",220,1825,1.3,0.01]
[4057,"Hanhofen / Hanhofen                  ",250,1990,1.34,0.04]
[2008,"Hargesheim / Hargesheim                ",140,1560,1.1499999999999999,-0.01]
[4058,"Harthausen / Harthausen                ",280,2115,1.38,0.04]
[4301,"Haßloch / Haßloch                   ",305,2250,1.41,0.06]
[5659,"Hatzenbühl / Hatzenbühl                ",140,1825,1.1299999999999999,0.03]
[5307,"Hauenstein / Hauenstein                ",90,1100,1.05,-0.03]
[3591,"Heidesheim am Rhein / Heidesheim                ",340,2365,1.45,0.04]
[2642,"Hermeskeil / Hermeskeil                ",75,1015,1,0.01]
[5527,"Herxheim bei Landau (Pf.) / Herxheim                  ",230,2030,1.3,0.04]
[675,"Höhr-Grenzhausen / Höhr                      ",125,1400,1.1299999999999999,0]
[2223,"Idar-Oberstein / Göttschied                ",60,905,0.94,-0.06]
[2225,"Idar-Oberstein / Idar-Oberstein            ",41,790,0.85,-0.06]
[3584,"Ingelheim am Rhein / Frei-Weinheim             ",290,2155,1.39,0.04]
[3583,"Ingelheim am Rhein / Nieder-Ingelheim          ",335,2340,1.44,0.04]
[3582,"Ingelheim am Rhein / Ober-Ingelheim            ",380,2515,1.48,0.04]
[5657,"Jockgrim / Jockgrim                  ",250,2175,1.33,0.03]
[5002,"Kaiserslautern / Dansenberg                ",205,1685,1.29,0.04]
[5003,"Kaiserslautern / Hohenecken                ",165,1405,1.24,0.04]
[5001,"Kaiserslautern / Kaiserslautern",180,1635,1.24,0.04]
[5007,"Kaiserslautern / Morlautern                ",155,1360,1.22,0.04]
[4371,"Kallstadt / Kallstadt                 ",240,2240,1.31,0.06]
[5671,"Kandel / Kandel                    ",270,2050,1.37,0.02]
[1758,"Kastellaun / Kastellaun                ",70,1105,0.96,-0.04]
[2614,"Kenn / Kenn                      ",200,1805,1.28,0.1]
[4577,"Kirchheimbolanden / Kirchheimbolanden         ",140,1480,1.1599999999999999,0.01]
[1415,"Koblenz / Arenberg                  ",220,1930,1.29,0]
[1416,"Koblenz / Ehrenbreitstein           ",185,1835,1.23,0]
[1405,"Koblenz / Güls                      ",235,1995,1.31,0]
[1419,"Koblenz / Horchheim                 ",205,1870,1.27,0]
[1409,"Koblenz / Kesselheim                ",185,1770,1.23,0]
[1401,"Koblenz / Koblenz",300,2260,1.39,0]
[1407,"Koblenz / Metternich                ",240,2070,1.31,0]
[1402,"Koblenz / Moselweiß                 ",235,1870,1.32,0]
[1411,"Koblenz / Neuendorf                 ",180,1650,1.24,0]
[1413,"Koblenz / Niederberg                ",165,1735,1.19,0]
[1418,"Koblenz / Pfaffendorf               ",233,2040,1.3,0]
[1406,"Koblenz / Rübenach                  ",205,1870,1.27,0]
[1410,"Koblenz / Wallersheim               ",190,1795,1.24,0]
[2769,"Konz / Könen                     ",120,1940,1.08,0.1]
[2771,"Konz / Konz                      ",155,1660,1.19,0.1]
[4755,"Kusel / Kusel                     ",85,1140,1.02,-0.05]
[962,"Lahnstein / Niederlahnstein           ",125,1375,1.1299999999999999,-0.02]
[961,"Lahnstein / Oberlahnstein             ",150,1485,1.18,-0.02]
[4322,"Lambrecht (Pfalz) / Lambrecht                 ",115,1310,1.1000000000000001,-0.03]
[3971,"Lambsheim / Lambsheim                 ",275,2245,1.36,0.01]
[5558,"Landau in der Pfalz / Godramstein               ",190,1775,1.25,7.0000000000000007E-2]
[5551,"Landau in der Pfalz / Landau                    ",275,2135,1.37,7.0000000000000007E-2]
[5554,"Landau in der Pfalz / Queichheim                ",230,1960,1.32,7.0000000000000007E-2]
[4870,"Landstuhl / Landstuhl                 ",130,1310,1.1599999999999999,0.04]
[1924,"Langenlonsheim / Langenlonsheim            ",190,1455,1.28,0]
[5202,"Lemberg / Lemberg                   ",65,970,0.95,-0.06]
[4021,"Limburgerhof / Limburgerhof              ",350,2220,1.47,0.06]
[5599,"Lingenfeld / Lingenfeld                ",235,2010,1.31,0.01]
[310,"Linz am Rhein / Linz a.Rh.                ",125,1705,1.1000000000000001,0]
[4159,"Ludwigshafen am Rhein / Edigheim                  ",250,1900,1.35,7.0000000000000007E-2]
[4157,"Ludwigshafen am Rhein / Friesenheim               ",290,2200,1.39,7.0000000000000007E-2]
[4156,"Ludwigshafen am Rhein / Ludwigshafen              ",440,2800,1.53,7.0000000000000007E-2]
[4153,"Ludwigshafen am Rhein / Maudach                   ",300,2240,1.4,7.0000000000000007E-2]
[4152,"Ludwigshafen am Rhein / Mundenheim                ",280,2100,1.39,7.0000000000000007E-2]
[4155,"Ludwigshafen am Rhein / Oggersheim                ",270,2050,1.37,7.0000000000000007E-2]
[4158,"Ludwigshafen am Rhein / Oppau                     ",300,2240,1.4,7.0000000000000007E-2]
[4151,"Ludwigshafen am Rhein / Rheingönheim              ",300,2450,1.39,7.0000000000000007E-2]
[4154,"Ludwigshafen am Rhein / Ruchheim                  ",280,2220,1.37,7.0000000000000007E-2]
[5331,"Ludwigswinkel / Ludwigswinkel             ",43,755,0.87,-0.03]
[5453,"Maikammer / Maikammer                 ",240,1995,1.33,7.0000000000000007E-2]
[3707,"Mainz / Bretzenheim               ",620,3375,1.67,7.0000000000000007E-2]
[3708,"Mainz / Drais                     ",650,3640,1.67,7.0000000000000007E-2]
[3705,"Mainz / Ebersheim                 ",475,2945,1.56,7.0000000000000007E-2]
[3709,"Mainz / Finthen                   ",560,3130,1.63,7.0000000000000007E-2]
[3710,"Mainz / Gonsenheim                ",570,3180,1.64,7.0000000000000007E-2]
[3704,"Mainz / Hechtsheim                ",575,3350,1.63,7.0000000000000007E-2]
[3703,"Mainz / Laubenheim                ",650,3640,1.67,7.0000000000000007E-2]
[37071,"Mainz / Lerchenberg (Bretzenheim)",620,3375,1.67,7.0000000000000007E-2]
[3701,"Mainz / Mainz",800,4250,1.75,7.0000000000000007E-2]
[3706,"Mainz / Marienborn                ",435,2640,1.54,7.0000000000000007E-2]
[3711,"Mainz / Mombach                   ",455,2875,1.55,7.0000000000000007E-2]
[3702,"Mainz / Weisenau                  ",475,2945,1.56,7.0000000000000007E-2]
[2503,"Manderscheid / Manderscheid              ",37,920,0.82,0.02]
[4572,"Marnheim / Marnheim                  ",85,970,1.05,0.01]
[3976,"Maxdorf / Maxdorf                   ",325,2255,1.43,0.01]
[1239,"Mayen / Mayen                     ",155,1535,1.19,0]
[4306,"Meckenheim / Meckenheim                ",305,2280,1.41,0.08]
[3638,"Mommenheim / Mommenheim                ",340,2305,1.45,0]
[705,"Montabaur / Horressen                 ",135,1445,1.1499999999999999,0]
[704,"Montabaur / Montabaur                 ",180,1650,1.24,0]
[2393,"Morbach / Morbach                   ",65,1385,0.92,-0.03]
[1330,"Mülheim-Kärlich / Mülheim                   ",185,1720,1.24,0]
[4016,"Mutterstadt / Mutterstadt               ",325,2100,1.45,0.04]
[3624,"Nackenheim / Nackenheim                ",320,2255,1.42,0.03]
[4026,"Neuhofen / Neuhofen                  ",315,1960,1.44,0.02]
[4254,"Neustadt an der Weinstr. / Diedesfeld                ",295,2700,1.36,0.04]
[4258,"Neustadt an der Weinstr. / Haardt                    ",345,2240,1.46,0.04]
[4256,"Neustadt an der Weinstr. / Hambach                   ",325,2300,1.43,0.04]
[4253,"Neustadt an der Weinstr. / Lachen-Speyerdorf         ",225,2260,1.28,0.04]
[4257,"Neustadt an der Weinstr. / Neustadt                  ",300,2195,1.4,0.04]
[355,"Neuwied / Heddesdorf                ",200,1730,1.27,0]
[356,"Neuwied / Heimbach                  ",175,1625,1.23,0]
[346,"Neuwied / Irlich                    ",190,1680,1.25,0]
[353,"Neuwied / Neuwied                   ",270,1890,1.38,0]
[348,"Neuwied / Niederbieber              ",155,1535,1.19,0]
[351,"Neuwied / Oberbieber                ",165,1580,1.21,0]
[3606,"Nieder-Olm / Nieder-Olm                ",295,2150,1.4,0.02]
[3636,"Nierstein / Nierstein                 ",320,2210,1.42,0]
[2763,"Nittel / Nittel                    ",185,2295,1.21,0.1]
[3604,"Ober-Olm / Ober-Olm                  ",320,2240,1.42,0.02]
[4413,"Obrigheim (Pfalz) / Obrigheim                 ",175,1975,1.2,0.01]
[5515,"Offenbach an der Queich / Offenbach                 ",225,1890,1.31,0.04]
[3646,"Oppenheim / Oppenheim                 ",295,2120,1.4,0]
[3891,"Osthofen / Osthofen                  ",155,1535,1.19,0]
[4926,"Otterbach / Otterbach                 ",125,1440,1.1299999999999999,0.03]
[4948,"Otterberg / Otterberg                 ",120,1415,1.1200000000000001,0.03]
[3751,"Partenheim / Partenheim                ",200,1730,1.27,0]
[5151,"Pirmasens / Pirmasens                 ",75,990,1,-0.06]
[5156,"Pirmasens / Winzeln                   ",95,1140,1.06,-0.06]
[1268,"Polch / Polch                     ",90,1175,1.04,0]
[4892,"Ramstein-Miesenbach / Ramstein                  ",160,1605,1.2,0.04]
[661,"Ransbach-Baumbach / Ransbach                  ",125,1400,1.1299999999999999,0]
[1117,"Remagen / Oberwinter                ",90,1405,1.02,0.03]
[1120,"Remagen / Remagen                   ",170,1805,1.2,0.03]
[241,"Rengsdorf / Rengsdorf                 ",140,1465,1.1599999999999999,0]
[291,"Rheinbreitbach / Rheinbreitbach            ",205,2100,1.25,0]
[5658,"Rheinzabern / Rheinzabern               ",230,2015,1.3,0.03]
[4631,"Rockenhausen / Rockenhausen              ",78,1105,1,-0.05]
[5287,"Rodalben / Rodalben                  ",70,1045,0.97,-0.06]
[4902,"Rodenbach / Rodenbach                 ",150,1395,1.2,0.04]
[4071,"Römerberg / Berghausen                ",350,2405,1.46,0.04]
[4072,"Römerberg / Heiligenstein             ",320,2270,1.42,0.04]
[4073,"Römerberg / Mechtersheim              ",265,1920,1.37,0.04]
[1996,"Rüdesheim / Rüdesheim                 ",155,1520,1.19,-0.01]
[5642,"Rülzheim / Rülzheim                  ",210,1995,1.27,0.03]
[2737,"Saarburg / Saarburg                  ",125,1860,1.1000000000000001,0.1]
[3752,"Saulheim / Nieder-Saulheim           ",255,1960,1.35,0]
[3753,"Saulheim / Ober-Saulheim             ",270,2020,1.37,0]
[4046,"Schifferstadt / Schifferstadt             ",310,2020,1.43,0.03]
[4819,"Schönenberg-Kübelberg / Schönenberg               ",78,1205,0.99,0]
[3565,"Schwabenheim an der Selz / Schwabenheim              ",280,2075,1.38,0.01]
[2612,"Schweich / Schweich                  ",230,2250,1.29,0.1]
[1712,"Simmern (Hunsrück) / Simmern                   ",85,1190,1.01,-0.04]
[1132,"Sinzig / Bodendorf                 ",155,1570,1.19,0.03]
[1131,"Sinzig / Sinzig                    ",155,1570,1.19,0.03]
[4101,"Speyer / Speyer                    ",380,2595,1.48,0.09]
[1907,"Stromberg / Stromberg                 ",140,1440,1.1599999999999999,-0.02]
[2363,"Thalfang / Thalfang                  ",38,1150,0.79,-0.03]
[2452,"Traben-Trarbach / Traben                    ",100,1270,1.06,0]
[2851,"Trier / Ehrang                    ",160,1750,1.2,0.1]
[2859,"Trier / Euren                     ",255,2105,1.35,0.1]
[2862,"Trier / Heiligkreuz               ",415,2905,1.5,0.1]
[2867,"Trier / Irsch                     ",220,2080,1.29,0.1]
[2864,"Trier / Kürenz                    ",260,2250,1.34,0.1]
[2863,"Trier / Olewig                    ",280,2345,1.37,0.1]
[2858,"Trier / Pallien                   ",280,2205,1.38,0.1]
[2852,"Trier / Pfalzel                   ",165,1765,1.2,0.1]
[2854,"Trier / Ruwer-Paulin              ",250,2210,1.33,0.1]
[2861,"Trier / St.Matthias               ",320,2505,1.41,0.1]
[2865,"Trier / Tarforst                  ",290,2385,1.38,0.1]
[2856,"Trier / Trier                     ",465,2955,1.55,0.1]
[2860,"Trier / Zewen                     ",250,2345,1.32,0.1]
[2796,"Trierweiler / Sirzenich                 ",210,2295,1.26,0.1]
[2795,"Trierweiler / Trierweiler               ",175,2120,1.2,0.1]
[4981,"Trippstadt / Trippstadt                ",130,1340,1.1499999999999999,0.02]
[3641,"Undenheim / Undenheim                 ",225,1835,1.31,0]
[292,"Unkel / Scheuren                  ",195,2045,1.23,0]
[293,"Unkel / Unkel                     ",170,1930,1.19,0]
[1353,"Vallendar / Mallendar                 ",245,2100,1.32,0]
[1352,"Vallendar / Vallendar                 ",190,1860,1.24,0]
[4336,"Wachenheim a.d. Weinstr. / Wachenheim                ",325,2300,1.43,0.04]
[3592,"Wackernheim / Wackernheim               ",350,2405,1.46,0.04]
[3510,"Waldalgesheim / Waldalgesheim             ",170,1315,1.25,0]
[5272,"Waldfischbach-Burgalben / Waldfischbach             ",60,950,0.93,-0.05]
[4833,"Waldmohr / Waldmohr                  ",100,1125,1.08,0]
[4036,"Waldsee / Waldsee                   ",305,2190,1.41,0.02]
[4901,"Weilerbach / Weilerbach                ",135,1330,1.17,0.04]
[4367,"Weisenheim am Sand / Weisenheim am Sand        ",275,2120,1.37,0.06]
[1326,"Weißenthurm / Weißenthurm               ",160,1505,1.21,0]
[549,"Westerburg / Westerburg                ",85,1155,1.03,0]
[4524,"Winnweiler / Winnweiler                ",100,1225,1.06,-0.04]
[636,"Wirges / Wirges                    ",120,1425,1.1100000000000001,0]
[65,"Wissen / Wissen                    ",60,1100,0.92,-0.03]
[2521,"Wittlich / Wittlich                  ",200,1770,1.27,0.03]
[3777,"Wöllstein / Wöllstein                 ",110,1325,1.0900000000000001,0]
[3904,"Worms / Abenheim                  ",180,1650,1.24,0]
[3903,"Worms / Herrnsheim                ",270,2020,1.37,0]
[3909,"Worms / Hochheim                  ",250,1935,1.34,0]
[3910,"Worms / Neuhausen                 ",215,1735,1.3,0]
[3905,"Worms / Pfeddersheim              ",205,1685,1.28,0]
[3913,"Worms / Pfiffligheim              ",215,1785,1.29,0]
[3902,"Worms / Rheindürkheim             ",145,1490,1.17,0]
[3912,"Worms / Weinsheim                 ",230,1915,1.31,0]
[3911,"Worms / Worms                     ",275,2105,1.37,0]
[3758,"Wörrstadt / Wörrstadt                 ",235,1870,1.32,0]
[5690,"Wörth am Rhein / Maximiliansau             ",280,2105,1.38,0.03]
[5616,"Zeiskam / Zeiskam                   ",160,1740,1.19,0.01]
[3608,"Zornheim / Zornheim                  ",280,2090,1.38,0.02]
[5107,"Zweibrücken / Bubenhausen-Ernstweiler   ",95,1240,1.05,-0.01]
[5101,"Zweibrücken / Zweibrücken               ",105,1235,1.08,-0.01]

{"sheet":"modifizierte RND","index":9,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":true,"merged":[[18,0,37,0],[18,6,37,6],[37,1,37,5],[13,0,13,6],[14,0,14,6],[15,0,16,0],[15,2,16,4],[15,6,16,6],[17,0,17,6],[8,22,14,22],[5,0,5,2],[5,5,5,6],[6,0,6,6],[7,5,7,6],[8,0,8,6],[8,16,11,16],[9,5,9,6],[10,0,12,6],[8,17,14,17],[8,18,14,18],[8,19,14,19],[8,20,14,20],[8,21,14,21],[4,0,4,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,2],[3,5,3,6]]}
["Ermittlung der modifizierten Restnutzungsdauer"]
["SW-Modell AGVGA NRW    -    Anlage 4"]
[]
[" tatsächliches Gebäudealter (Alter):",null,null,{"$f":"RND!F29","v":30},"     Jahre",{"$f":"IF(D4<0,\"Negative Jahre ???\",\"\")","v":""}]
[]
[" Modernisierungsgrad:",null,null,{"$f":"IF(RND!I13<>0,RND!I13,RND!I13)","v":0},"     Punkte",{"$f":"IF(D6=\"\",\"\",IF(D6<=K16,\"(Modernisierungsstufe 1)\",IF(D6<6,\"(Modernisierungsstufe 2)\",IF(AND(D6>5,D6<11),\"(Modernisierungsstufe 3)\",IF(AND(D6>10,D6<18),\"(Modernisierungsstufe 4)\",IF(D6>=K33,\"(Modernisierungsstufe 5)\",\"\"))))))","v":"(Modernisierungsstufe 1)"}]
[]
[" Gesamtnutzungsdauer (GND):",null,null,{"$f":"RND!F31","v":70},"     Jahre",null,null,null,null,null,"mögliche Gesamtnutzungsdauer:",null,null,null,"relatives Gebäudealter"]
[null,null,null,null,null,null,null,null,null,null,60,null,null,null,{"$f":"D4/D8","v":0.42857142857142855},null,"Alter für Formel\nmax. Alter der GND","Prüfung, ob Formel anwendbar\n( \"ab einem relativen Alter\")","Formel nicht anwendbar, daher Jahre durch Abzug\nRND=GND-Alter\naber max. 80 Jahre!","Formel anwendbar\n\nmod. RND in Jahren","modifizierte RND","interpoliert ?","GND - Alter ?"]
[" modifizierte Restnutzungsdauer:",null,null,{"$f":"IF(D6=0,D8-D4,IF(AND(D4=\"\",D6=\"\",D8=\"\"),\"\",IF(D4<>\"\",IF(D6=\"\",\"Punkte ?\",IF(D8=\"\",\"GND ?\",U34)),\"s.o.\")))","v":40},"    Jahre",null,null,null,null,null,65]
["Bei der angezeigten modifizierten Restnutzungsdauer handelt es sich um eine interpolierte, mathematisch berechnete Zahl !",null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,80]
["Tabelle zur Ermittlung der modifizierten Restnutzungsdauer",null,null,null,null,null,null,null,null,null,90,null,null,null,null,null,{"$f":"IF(D4>D8,D8,D4)","v":30}]
[null,null,null,null,null,null,null,null,null,null,"Modernisierungsgrad:",null,{"$f":"IF(D6=K16,1,IF(D6=K33,18,D6))","v":0},"a","b","c"]
["a  x  .",100,"  x  Alter ²  -  b  x  Alter  +  c  x  ",null,null,"GND",null,null,null,null,1,null,{"$f":"IF($D$6<=B20,D6,\"\")","v":0},{"$f":"IF($D$6<=B20,C20,\"\")","v":1.2500000000000001E-2},{"$f":"IF($D$6<=B20,D20,\"\")","v":2.625},{"$f":"IF($D$6<=B20,E20,\"\")","v":152.5},null,{"$f":"IF(M16=\"\",\"\",IF(AND($D$6<=B20,$O$9>=F20/100),\"JA\",\"NEIN\"))","v":"NEIN"},{"$f":"IF(R16=\"NEIN\",IF($D$4>80,80,$D$8-$Q$14),\"\")","v":40},{"$f":"IF(R16=\"JA\",$N$34*100/$D$8*$Q$14*$Q$14-($O$34*$Q$14)+($P$34*$D$8/100),\"\")","v":""},{"$f":"SUM(S16:T16)","v":40},{"$f":"IF(R16=\"JA\",IF(AND(OR($D$4=0,$D$4=5,$D$4=10,$D$4=15,$D$4=20,$D$4=25,$D$4=30,$D$4=35,$D$4=40,$D$4=45,$D$4=50,$D$4=55,$D$4=60,$D$4=60,$D$4=65,$D$4=70,$D$4=75,$D$4>=80),OR($D$6<2,$D$6=4,$D$6=8,$D$6=13,$D$6>17)),0,1),0)","v":0},{"$f":"IF(R16=\"NEIN\",1,0)","v":1}]
[null,"GND",null,null,null,100,null,null,null,null,2,null,{"$f":"IF($D$6=B21,B21,\"\")","v":""},{"$f":"IF($D$6=B21,C21,\"\")","v":""},{"$f":"IF($D$6=B21,D21,\"\")","v":""},{"$f":"IF($D$6=B21,E21,\"\")","v":""},null,{"$f":"IF(M17=\"\",\"\",IF(AND($D$6=B21,$O$9>=F21/100),\"JA\",\"NEIN\"))","v":""},{"$f":"IF(R17=\"NEIN\",$D$8-$D$4,\"\")","v":""},"",0,0,0]
["Die Restnutzungsdauer kann zwischen den Stufen durch Interpolation ermittelt werden.",null,null,null,null,null,null,null,null,null,3,null,"","","","",null,"","","",0,0,0]
[null,"Moder-\nnisierungs-\ngrad","a","b","c","ab einem relativen Alter (%)",null,null,null,null,4,null,"","","","",null,"","","",0,0,0]
[null,1,1.2500000000000001E-2,2.625,152.5,60,null,null,null,null,5,null,"","","","",null,"","","",0,0,0]
[null,2,{"$f":"ROUND(C20-(C20-C23)/3*1,4)","v":1.0800000000000001E-2},{"$f":"ROUND(D20-(D20-D23)/3*1,3)","v":2.2759999999999998},{"$f":"ROUND(E20-(E20-E23)/3*1,2)","v":138.78},{"$f":"ROUND(F20-(F20-F23)/3*1,0)","v":53},null,"Zeile 22, Spalte F:",null,null,6,null,"","","","",null,"","","",0,0,0]
[null,3,{"$f":"ROUND(C20-(C20-C23)/3*2,4)","v":8.9999999999999993E-3},{"$f":"ROUND(D20-(D20-D23)/3*2,3)","v":1.9259999999999999},{"$f":"ROUND(E20-(E20-E23)/3*2,2)","v":125.05},{"$f":"ROUND(F20-(F20-F23)/3*2,0)+1","v":48},null,"ein Jahr addiert,",null,null,7,null,"","","","",null,"","","",0,0,0]
[null,4,7.3000000000000001E-3,1.577,111.33,40,null,"da sonst die modifizierte",null,null,8,null,"","","","",null,"","","",0,0,0]
[null,5,{"$f":"ROUND(C23-(C23-C27)/4*1,4)","v":6.7000000000000002E-3},1.458,{"$f":"ROUND(E23-(E23-E27)/4*1,2)","v":108.5},{"$f":"ROUND(F23-(F23-F27)/4*1,0)","v":35},null,"RND bei Modernisierungspunkt 3",null,null,9,null,"","","","",null,"","","",0,0,0]
[null,6,{"$f":"ROUND(C23-(C23-C27)/4*2,4)","v":6.1999999999999998E-3},{"$f":"ROUND(D23-(D23-D27)/4*2,3)","v":1.339},{"$f":"ROUND(E23-(E23-E27)/4*2,24)","v":105.66500000000001},{"$f":"ROUND(F23-(F23-F27)/4*2,0)","v":30},null,"größer als bei Mod.Pkt 4 sein könnte",null,null,10,null,"","","","",null,"","","",0,0,0]
[null,7,{"$f":"ROUND(C23-(C23-C27)/4*3,4)","v":5.5999999999999999E-3},{"$f":"ROUND(D23-(D23-D27)/4*3,3)","v":1.2190000000000001},{"$f":"ROUND(E23-(E23-E27)/4*3,2)","v":102.83},{"$f":"ROUND(F23-(F23-F27)/4*3,0)","v":25},null,null,null,null,11,null,"","","","",null,"","","",0,0,0]
[null,8,5.0000000000000001E-3,1.1000000000000001,100,20,null,null,null,null,12,null,"","","","",null,"","","",0,0,0]
[null,9,{"$f":"ROUND(C27-(C27-C32)/5*1,4)","v":4.7000000000000002E-3},{"$f":"ROUND(D27-(D27-D32)/5*1,3)","v":1.0269999999999999},{"$f":"ROUND(E27-(E27-E32)/5*1,2)","v":99.06},{"$f":"ROUND(F27-(F27-F32)/5*1,0)","v":19},null,null,null,null,13,null,"","","","",null,"","","",0,0,0]
[null,10,{"$f":"ROUND(C27-(C27-C32)/5*2,4)","v":4.3E-3},{"$f":"ROUND(D27-(D27-D32)/5*2,3)","v":0.95399999999999996},{"$f":"ROUND(E27-(E27-E32)/5*2,2)","v":98.11},{"$f":"ROUND(F27-(F27-F32)/5*2,0)","v":18},null,null,null,null,14,null,"","","","",null,"","","",0,0,0]
[null,11,{"$f":"ROUND(C27-(C27-C32)/5*3,4)","v":4.0000000000000001E-3},{"$f":"ROUND(D27-(D27-D32)/5*3,3)","v":0.88100000000000001},{"$f":"ROUND(E27-(E27-E32)/5*3,2)","v":97.17},{"$f":"ROUND(F27-(F27-F32)/5*3,0)","v":17},null,null,null,null,15,null,"","","","",null,"","","",0,0,0]
[null,12,{"$f":"ROUND(C27-(C27-C32)/5*4,4)","v":3.5999999999999999E-3},{"$f":"ROUND(D27-(D27-D32)/5*4,3)","v":0.80800000000000005},{"$f":"ROUND(E27-(E27-E32)/5*4,2)","v":96.22},{"$f":"ROUND(F27-(F27-F32)/5*4,0)","v":16},null,null,null,null,16,null,"","","","",null,"","","",0,0,0]
[null,13,3.3E-3,0.73499999999999999,95.28,15,null,null,null,null,17,null,"","","","",null,"","","",0,0,0]
[null,14,{"$f":"ROUND(C32-(C32-C37)/5*1,4)","v":3.0000000000000001E-3},{"$f":"ROUND(D32-(D32-D37)/5*1,3)","v":0.67600000000000005},{"$f":"ROUND(E32-(E32-E37)/5*1,2)","v":95.06},{"$f":"ROUND(F32-(F32-F37)/5*1,0)","v":14},null,null,null,null,18,null,{"$f":"IF($D$6>=B37,D6,\"\")","v":""},{"$f":"IF($D$6>=B37,C37,\"\")","v":""},{"$f":"IF($D$6>=B37,D37,\"\")","v":""},{"$f":"IF($D$6>=B37,E37,\"\")","v":""},null,{"$f":"IF(M33=\"\",\"\",IF(AND($D$6>=B37,$O$9>=F37/100),\"JA\",\"NEIN\"))","v":""},"","",0,0,0]
[null,15,{"$f":"ROUND(C32-(C32-C37)/5*2,4)","v":2.8E-3},{"$f":"ROUND(D32-(D32-D37)/5*2,3)","v":0.61699999999999999},{"$f":"ROUND(E32-(E32-E37)/5*2,2)","v":94.85},{"$f":"ROUND(F32-(F32-F37)/5*2,0)","v":13},null,null,null,null,null,null,null,{"$f":"SUM(N16:N33)","v":1.2500000000000001E-2},{"$f":"SUM(O16:O33)","v":2.625},{"$f":"SUM(P16:P33)","v":152.5},null,null,null,null,{"$f":"SUM(U16:U33)","v":40},{"$f":"SUM(V16:V33)","v":0},{"$f":"SUM(W16:W33)","v":1}]
[null,16,{"$f":"ROUND(C32-(C32-C37)/5*3,4)","v":2.5000000000000001E-3},{"$f":"ROUND(D32-(D32-D37)/5*3,3)","v":0.55800000000000005},{"$f":"ROUND(E32-(E32-E37)/5*3,2)","v":94.63},{"$f":"ROUND(F32-(F32-F37)/5*3,0)","v":12},null,null,null,null,null,null,null,"a","b","c",null,null,null,null,null,{"$f":"IF(V34=0,\"\",\"  (interpoliert)\")","v":""},{"$f":"IF(W34=0,\"\",\" (GND - tats. Alter)\")","v":" (GND - tats. Alter)"}]
[null,17,{"$f":"ROUND(C32-(C32-C37)/5*4,4)","v":2.3E-3},{"$f":"ROUND(D32-(D32-D37)/5*4,3)","v":0.499},{"$f":"ROUND(E32-(E32-E37)/5*4,2)","v":94.42},{"$f":"ROUND(F32-(F32-F37)/5*4,0)","v":11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Text in RND:",{"$f":"IF(V35<>\"\",V35,W35)","v":" (GND - tats. Alter)"}]
[null,18,2E-3,0.44,94.2,10]

{"sheet":"Info","index":10,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["WE-Rechner RLP (MS-Excel 2007)"]
[]
["Update-Informationen"]
[]
["Version 1.0 - 2017   Stand 16.3.2017"]
["Neuprogrammierung nach dem Modell des LGMB 2017"]
[]
["Version 1.1 - 2017   Stand 10.4.2017"]
["● Blatt \"Berechnung und Ergebnis\", Zelle D65 - Berichtigung eines Rechenfehlers: Formelbezug D16 geändert in D17"]
["● Blatt \"EingabeMaske\", Zellen D30 und D31 - Öffnen der Obergrenze für Bodenwerte von 450 €/m² auf 900 €/m² mit Warnhinweis bei Werten über 450 €/m²"]
["● Blatt \"Vergleichsfaktoren\" - Zellen D211 und E211: Anhebung des Richtwertes für Mainz, Elsa-Brändström-Straße von 2.300 €/m² Wf auf 2.700 €/m²Wf mit entsprechender Anpassung des Sachwertfaktors von 1,37 auf 1,34"]
[]
["Version 1.2 - 2017   Stand 11.5.2017"]
["Blatt \"Vergleichsfaktoren\"  - Zellen D326 bis D335: Anhebung der Richtwerte für die Stadt Trier"]
["●  von 1.450 €/m² Wf auf 1.600 €/m²Wf mit entsprechender Anpassung des Sachwertfaktors von 1,07 auf 1,06"]
["●  von 1.870 €/m² Wf auf 2.060 €/m²Wf mit entsprechender Anpassung des Sachwertfaktors von 1,22 auf 1,20"]
["●  von 2.400 €/m² Wf auf 2.400 €/m²Wf mit entsprechender Anpassung des Sachwertfaktors von 1,36 auf 1,33"]
[]
["Version 1.3 - 2018   Stand 25.5.2018"]
["● Anpassung der Berechnung auf zwei Nachkommastellen (dadurch treten keine Differenzen zwischen  einer händischen und der Excel-Berechnung mehr auf)"]
["● Fortschreibung der Indexreihe zur Anpassung an die allgemeinen Wertverhältnisse: 1.1.2018: neu 160; 1.1.2017: 147 (vormals 140) unter Verwendung nachgelieferter Daten der Gutachterausschüsse "]
["● Korrektur des irrtümlich falschen Vergleichsfaktors Almersbach (Landkreis Altenkirchen)"]
[]
["Version 2.0 - 2019   Stand 7.3.2019"]
["● Blatt EingabeMaske:"]
["Wertermittlungsstichtag / Index - Berücksichtigung der unterschiedlichen Wertverhältnisse zum Stichtag der Richtwerte und dem Wertermittlungsstichtag: Erstmals werden optional regionale Indexreihen angeboten. Nach händischer Berechnung eines Umrechnungsko"]
["● Blatt Berechnung und Ergebnis: redaktionelle Änderungen "]
["● Blatt Vergleichsfaktoren: Neufassung/ Fortschreibung auf den Stichtag 1.1.2018 "]
["Neuberechnung auf Grundlage der Umrechnungskoeffizienten des LGMB 2019, Plausibilisierung unter Heranziehung von 857 Nachbewertungen von Kauffällen aus 2017 und 2018 und zusätzlich durch Vergleich mit den langjährigen mittleren Kaufpreisniveaus (Medianen)"]
["Neugliederung der Orte: Die Vergleichsfaktoren wurden erstmals auf Ebene der Gemarkungen abgeleitet; Voraussetzung: In der Kaufpreissammlung wurden seit dem Jahr 2010 zwanzig und mehr Kaufpreise mit Angabe des bereinigten Kaufpreises (€/m² Wohnfläche) erf"]
["Die Gliederung wurde von Gemeindeteilen auf Gemarkungen umgestellt, damit bei der Ermittlung der Vergleichsfaktoren das Niveau der Vergleichskauffälle (auf den Richtwertstichtag hochgerechnete Mediane) und die Ergebnisse der Nachbewertungen, den Modellerg"]
["Bodenwertniveaus: Die den gemarkungsweisen Vergleichsfaktoren zugeordneten durchschnittlichen Bodenwertniveaus wurden zum Stichtag 1.1.2018 neu ermittelt. Grundlage bildeten jeweils die zonalen Bodenrichtwerte in typischen Lagen, in Verbindung mit den in "]
["● Blatt Vergleichsdaten"]
["Sachwertfaktoren: Neue Koeffizienten für die Berechnung der landesdurchschnittlichen Sachwertfaktoren ((vgl. Abschnitt 6.8.5 im Landesgrundstücksmarktbericht 2019)."]
["Indexreihen: Neuberechnung/Fortschreibung nach Umstellung des statistischen Verfahrens. Erstmalige zusätzliche (optionale) regionale Differenzierung  (Abschnitt 6.5 des Landesgrundstücksmarktberichts 2019).  "]
[]
["Die vorliegenden Vergleichsfaktoren sind wegen der beschriebenen Weiterentwicklungen des Verfahrens nur bedingt mit den vorangegangenen Veröffentlichungen vergleichbar."]
[]
["Version 2.1 - 2019   Stand 4.4.2019"]
["● Blatt Vergleichsdaten"]
["Indexreihen: Fehlerberichtigung - Die regionalen Indexwerte wurden aufgrund eines Übertragungsfehlers bei den Gruppen 2-6 neu eingestellt (Die Tabelle im Druckexemplar auf Seite 322 des LGMB 2019 ist durch die berichtigte zu ersetzen, vgl. https://gutacht"]
[]
["Version 2.2 - 2019   Stand 18.7.2019"]
["● Blatt Vergleichsdaten"]
["Fortschreibung der Indexreihen nach neuem Verfahren: a) zum 1.1.2020 (Prognose erstmals per Mittelbildung der Preissteigerungsraten über 1, 3 und 5 Jahre, b) zum 1.1.2019 Glättung per gewogener Mittelbildung analog des Prognoseverfahrens. Zum 1.1.2018 Glä"]
[]
["Version 2.3 - 2019   Stand 22.7.2020"]
["● Blatt Vergleichsdaten"]
["Fortschreibung der Indexreihen analog dem Verfahren der Version 2.2"]

{"sheet":"Werte Neu","index":11,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Garage",7000]
["Doppelgarage",12000]
["Carport",4000]
["Carport und Garage",11000]
["Aussenstellplatz",3500]
["Sonstiges (freie Eingabe)",0]