{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["EingabeMaske","Berechnung und Ergebnis","Vergleichsfaktoren 2023 (2)","Vergleichsdaten LGMB 2023","GebStandard","RND","Indizes 2022 Schätzung 2023","Indizes 2023 Schätzung 2024","Indizes 2024 Schätzung 2025","RND nach ImmoWertV","Werte Neu"],"not_rendered":{"charts":5,"images":5,"macros":1,"external_links":0,"defined_names":432,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"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, Version 4 - LGMB 2023, Stand 11.2024","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":2024}]
["Merkmale des Wertermittlungsobjekts",null,"Eingabeschranken"]
["Wertermittlungsstichtag (WST):",null,"01.01.2010 bis heute","2023-07-04"]
["Index nach Marktsegment zum Wertermittlungsstichtag (2010 =100):",null,null,{"$f":"'Indizes 2024 Schätzung 2025'!X18","v":{"$error":"#N/A"}}]
[]
[]
["Grundstücksgröße (GG):",null,"30 m² bis 500.000 m²",1000]
["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,1960]
["Gesamtnutzungsdauer (GND):",null,"aus Standardstufe berechnet",80]
["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)-D26)>RND!F31,D27-(YEAR(D15)-D26),RND!F31),IF(RND!F31>D27*30%,RND!F31,D27*30%)),1)","v":24}]
[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.3}]
["Bodenrichtwert (BRW), maßgeblich ist der BRW zum 01.01.2022 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 2023 (2)'!A8:I3024,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 2023 (2)'!A8:I3024,8),0)","v":0}]
["Stichtag des Richtwertes:",null,null,"2022-01-01"]
["Index nach Marktsegment 01.01.2022 (2010 = 100):",null,null,{"$f":"'Indizes 2024 Schätzung 2025'!Z18","v":{"$error":"#N/A"}}]
["Marktsegment",null,null,{"$f":"VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2023 (2)'!A8:I3024,6)","v":0}]
["Sachwertfaktor des Richtwertgrundstücks",null,null,{"$f":"VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2023 (2)'!A8:I3024,9)","v":0}]
["Gebäudestandardstufe (GST):",null,null,3]
["Gesamtnutzungsdauer (GND):",80,null,1]
["Restnutzungsdauer (RND):",53,"relative RND:",{"$f":"ROUND(B47/B46,4)","v":0.66249999999999998}]
["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 2023"]

{"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, Version 4 - LGMB 2023, Stand 11.2024"}]
["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":"2023-07-04"}]
[{"$f":"EingabeMaske!A19","v":"Grundstücksgröße (GG):"},null,null,{"$f":"ROUND(EingabeMaske!D19,0)","v":1000}]
["Miteigentumsanteil:",null,null,{"$f":"ROUND(EingabeMaske!D25,4)","v":0.16669999999999999}]
["Baujahr (BJ):",null,null,{"$f":"EingabeMaske!D26","v":1960}]
[{"$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":80}]
["Restnutzungsdauer (RND):",null,null,{"$f":"ROUND(EingabeMaske!D28,1)","v":24}]
[null,null,"relative RND:",{"$f":"EingabeMaske!D29","v":0.3}]
["Bodenrichtwert (BWN), letzter Bodenrichtwert (01.01.2022):",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":"2022-01-01"}]
["Index nach Marktsegment zum 01.01.2022 (2010 =100):",null,null,{"$f":"ROUND(EingabeMaske!D42,0)","v":{"$error":"#N/A"}}]
["Sachwertfaktor des Richtwertgrundstücks",null,null,{"$f":"EingabeMaske!D44","v":0}]
["Gebäudestandardstufe (GST) (beeinflusst für die Nutzungsdauer):",null,null,3]
["Gesamtnutzungsdauer (GND):",80,null,1]
["Restnutzungsdauer (RND):",53,"relative RND:",{"$f":"EingabeMaske!D47","v":0.66249999999999998}]
["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 2023"}]
[null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner, Version 4 - LGMB 2023, Stand 11.2024"}]
["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":1000}]
["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":500.1}]
[]
["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":500.1}]
["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 LGMB 2023'!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":500.1}]
["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 LGMB 2023'!B$33*D$11^2+'Vergleichsdaten LGMB 2023'!B$34*D$11+'Vergleichsdaten LGMB 2023'!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.3}]
["relative Restnutzungsdauer des Richtwertobjekts",null,"/",{"$f":"D31","v":0.66249999999999998}]
[null,null,"x",{"$f":"ROUND(D72/D73,3)","v":0.45300000000000001}]
["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 LGMB 2023'!B102*D12^2+'Vergleichsdaten LGMB 2023'!B103*D12+'Vergleichsdaten LGMB 2023'!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 LGMB 2023'!B$137*D13^'Vergleichsdaten LGMB 2023'!B$138,'Vergleichsdaten LGMB 2023'!B$144*D13^4+'Vergleichsdaten LGMB 2023'!B$145*D13^3+'Vergleichsdaten LGMB 2023'!B$146*D13^2+'Vergleichsdaten LGMB 2023'!B$147*D13+'Vergleichsdaten LGMB 2023'!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 2023"}]
[null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner, Version 4 - LGMB 2023, Stand 11.2024"}]
[]
["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":"2023-07-04"},null,{"$f":"EingabeMaske!D16","v":{"$error":"#N/A"}}]
["UKWst(RWO):",{"$f":"EingabeMaske!D41","v":"2022-01-01"},"/",{"$f":"EingabeMaske!D42","v":{"$error":"#N/A"}}]
[null,null,"x",{"$f":"ROUND(D101/D102,2)","v":{"$error":"#N/A"}}]
["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 2023"}]

{"sheet":"Vergleichsfaktoren 2023 (2)","index":2,"n_rows":3024,"n_cols":9,"rows_kept":3024,"cut":false,"hidden":true,"merged":[]}
[null,"Vergleichsfaktoren (VF) für Wohnungseigentume im Weiterverkauf"]
[null,null,null,"Stichtag ","2022-01-01"]
[null,"Modell s. LGMB 2022, Kap. 4.4.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(D8)&\" / \"&TRIM(C8)&\" / \"&TRIM(E8)","v":" /  / "}]
[{"$f":"TRIM(D9)&\" / \"&TRIM(C9)&\" / \"&TRIM(E9)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D73)&\" / \"&TRIM(C73)&\" / \"&TRIM(E73)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D137)&\" / \"&TRIM(C137)&\" / \"&TRIM(E137)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D201)&\" / \"&TRIM(C201)&\" / \"&TRIM(E201)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D265)&\" / \"&TRIM(C265)&\" / \"&TRIM(E265)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D329)&\" / \"&TRIM(C329)&\" / \"&TRIM(E329)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D393)&\" / \"&TRIM(C393)&\" / \"&TRIM(E393)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D457)&\" / \"&TRIM(C457)&\" / \"&TRIM(E457)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D521)&\" / \"&TRIM(C521)&\" / \"&TRIM(E521)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D585)&\" / \"&TRIM(C585)&\" / \"&TRIM(E585)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D649)&\" / \"&TRIM(C649)&\" / \"&TRIM(E649)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D713)&\" / \"&TRIM(C713)&\" / \"&TRIM(E713)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D777)&\" / \"&TRIM(C777)&\" / \"&TRIM(E777)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D841)&\" / \"&TRIM(C841)&\" / \"&TRIM(E841)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D905)&\" / \"&TRIM(C905)&\" / \"&TRIM(E905)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D969)&\" / \"&TRIM(C969)&\" / \"&TRIM(E969)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1033)&\" / \"&TRIM(C1033)&\" / \"&TRIM(E1033)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1097)&\" / \"&TRIM(C1097)&\" / \"&TRIM(E1097)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1161)&\" / \"&TRIM(C1161)&\" / \"&TRIM(E1161)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1225)&\" / \"&TRIM(C1225)&\" / \"&TRIM(E1225)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1289)&\" / \"&TRIM(C1289)&\" / \"&TRIM(E1289)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1353)&\" / \"&TRIM(C1353)&\" / \"&TRIM(E1353)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1417)&\" / \"&TRIM(C1417)&\" / \"&TRIM(E1417)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1481)&\" / \"&TRIM(C1481)&\" / \"&TRIM(E1481)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1545)&\" / \"&TRIM(C1545)&\" / \"&TRIM(E1545)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1609)&\" / \"&TRIM(C1609)&\" / \"&TRIM(E1609)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1673)&\" / \"&TRIM(C1673)&\" / \"&TRIM(E1673)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1737)&\" / \"&TRIM(C1737)&\" / \"&TRIM(E1737)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1801)&\" / \"&TRIM(C1801)&\" / \"&TRIM(E1801)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1865)&\" / \"&TRIM(C1865)&\" / \"&TRIM(E1865)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1929)&\" / \"&TRIM(C1929)&\" / \"&TRIM(E1929)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D1993)&\" / \"&TRIM(C1993)&\" / \"&TRIM(E1993)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2057)&\" / \"&TRIM(C2057)&\" / \"&TRIM(E2057)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2121)&\" / \"&TRIM(C2121)&\" / \"&TRIM(E2121)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2185)&\" / \"&TRIM(C2185)&\" / \"&TRIM(E2185)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2249)&\" / \"&TRIM(C2249)&\" / \"&TRIM(E2249)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2313)&\" / \"&TRIM(C2313)&\" / \"&TRIM(E2313)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2377)&\" / \"&TRIM(C2377)&\" / \"&TRIM(E2377)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2441)&\" / \"&TRIM(C2441)&\" / \"&TRIM(E2441)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2505)&\" / \"&TRIM(C2505)&\" / \"&TRIM(E2505)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2569)&\" / \"&TRIM(C2569)&\" / \"&TRIM(E2569)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2633)&\" / \"&TRIM(C2633)&\" / \"&TRIM(E2633)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2697)&\" / \"&TRIM(C2697)&\" / \"&TRIM(E2697)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2761)&\" / \"&TRIM(C2761)&\" / \"&TRIM(E2761)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2825)&\" / \"&TRIM(C2825)&\" / \"&TRIM(E2825)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2889)&\" / \"&TRIM(C2889)&\" / \"&TRIM(E2889)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D2953)&\" / \"&TRIM(C2953)&\" / \"&TRIM(E2953)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D3017)&\" / \"&TRIM(C3017)&\" / \"&TRIM(E3017)","v":" /  / "}]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[" /  / "]
[{"$f":"TRIM(D3024)&\" / \"&TRIM(C3024)&\" / \"&TRIM(E3024)","v":" /  / "}]

{"sheet":"Vergleichsdaten LGMB 2023","index":3,"n_rows":227,"n_cols":8,"rows_kept":227,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"EingabeMaske!A57","v":"Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarktbericht 2023"}]
[]
["Sachwertfaktoren für Wohnungseigentume",null,null,null,null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner, Version 4 - LGMB 2023, Stand 11.2024"}]
[]
["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","2022-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":44562},{"$f":"C9","v":43831},{"$f":"D9","v":43831},43831,43831,43831,43831]
[]
["Marktsegment",{"$f":"VLOOKUP(EingabeMaske!B$11,'Vergleichsfaktoren 2023 (2)'!A8:I3024,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},5.1744999999999999E-2,1.127E-3,3.1480000000000002E-3,2.8679999999999999E-3,1.8814999999999998E-2,2.341E-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.32814399999999999,0.24501700000000001,0,0]
["c",false,-0.14093,-0.122651,-5.4819E-2,-6.4602999999999994E-2,-0.114165,-0.222828]
["d",false,{"$f":"7.02613*10^-5","v":7.0261300000000004E-5},{"$f":"1.62422*10^-4","v":1.6242200000000001E-4},{"$f":"1.50877*10^-4","v":1.50877E-4},{"$f":"1.58545*10^-4","v":1.5854500000000001E-4},{"$f":"1.30094*10^-4","v":1.30094E-4},{"$f":"1.5964*10^-4","v":1.5964000000000001E-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.73174019195252804},{"$f":"D13*D7^D14*D8^D15*D17^(D16*D10)","v":0.9295804727867707},1.2198740132731547,1.3841437984491158,1.4454001435241297,1.7982926873389926]
["gerundet auf 2 Stellen",{"$f":"ROUND(B19,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(C19,2)","v":0.73},{"$f":"ROUND(D19,2)","v":0.93},1.22,1.38,1.45,1.8]
[]
[]
["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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Anpassung an die Mietsituation",null,null,null,"UK"]
[null,"unvermietet","Kennziffer",1,1]
[null,"vermietet","Kennziffer",2,0.93]

{"sheet":"GebStandard","index":4,"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 4 ImmoWertV,\n\nStufen 1 + 2 Ergänzungen durch Sprengnetter"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner, Version 4 - LGMB 2023, Stand 11.2024"}]
[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]","80",null,"80",null,"80",null,"80",null,80]
[null,"Gesamtnutzungsdauer (Jahre):",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":80},null,"Standardstufe (gewogen):",null,{"$f":"(1*C23+2*E23+3*G23+4*I23+5*K23)","v":3}]

{"sheet":"RND","index":5,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,31,3],[31,5,31,7],[32,0,32,4],[32,5,32,8],[25,0,30,0],[25,5,25,8],[26,1,26,4],[26,5,26,8],[27,1,27,4],[27,5,27,7],[28,1,28,8],[29,1,29,4],[29,5,29,7],[30,5,30,7],[24,11,24,15],[13,0,15,9],[16,0,16,9],[17,0,17,4],[17,5,17,7],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,8],[24,0,24,8],[9,0,9,4],[9,5,9,7],[10,0,10,4],[10,5,10,7],[11,0,11,4],[11,5,11,7],[6,0,6,4],[6,5,6,7],[7,0,7,4],[7,5,7,7],[8,0,8,4],[8,5,8,7],[3,0,3,4],[3,5,3,7],[4,0,4,4],[4,5,4,7],[5,0,5,4],[5,5,5,7],[0,29,2,29],[0,0,0,9],[1,0,1,9],[2,5,2,7],[2,0,2,4]]}
["Modell zur Ermittlung der Restnutzungsdauer für Wohngebäude bei Modernisierungen (Anlage 2 ImmoWertV) "]
[]
["Modernisierungselemente",null,null,null,null,"max. Punkte",null,null,"tats. Punkte"," Kommentar"]
["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(I5>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(I6>3,\"TILT max. 2 \",2)","v":2},null,null,null,null,70,3]
["Modernisierung der Heizungsanlage",null,null,null,null,{"$f":"IF(I7>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(I9>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<>\"\",I12=0),\"Einblenden\",\"Ausblenden\")","v":"Einblenden"}]
["Wesentliche Verbesserung der Grundrissgestaltung",null,null,null,null,2]
["Summe",null,null,null,null,{"$f":"SUM(F4:F11)","v":20},null,null,{"$f":"SUM(I4:I11)","v":0},null,null,{"$f":"IF(I12>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(I12<>\"\",F19<=I12,H19>=I12,I12<1),I12,IF((F19<=I12)*OR(H19>=I12),I12,0))","v":0},null,null,"≤ 1 Punkt",1.2500000000000001E-2,2.625,152.5,60,24,{"$f":"IF(AND(I12<2,L28>(P19-1)),1,0)","v":1}]
["kleine Modernisierung im Rahmen der Instandhaltung",null,null,null,null,2,"-",5,{"$f":"IF(AND(I12<>\"\",F20<=I12,H20>=I12,I12<1),I12,IF(AND(J23<>\"\",F20<=J23,H20>=J23),J23,IF((F20<=I12)*OR(H20>=I12),I12,0)))","v":0},null,null,"4 Punkte",7.3000000000000001E-3,1.577,111.33,40,0,{"$f":"IF(AND(I20<>0,L28>(P20-1)),1,0)","v":0}]
["mittlerer Modernisierungsgrad",null,null,null,null,6,"-",10,{"$f":"IF(AND(I12<>\"\",F21<=I12,H21>=I12,I12<1),I12,IF((F21<=I12)*OR(H21>=I12),I12,0))","v":0},null,null,"8 Punkte",5.0000000000000001E-3,1.1000000000000001,100,20,0,{"$f":"IF(AND(I21<>0,L28>(P21-1)),1,0)","v":0}]
["überwiegend modernisiert",null,null,null,null,11,"-",17,{"$f":"IF(AND(I12<>\"\",F22<=I12,H22>=I12<1),,IF((F22<=I12)*OR(H22>=I12),I12,0))","v":0},null,null,"13 Punkte",3.3E-3,0.73499999999999999,95.28,15,0,{"$f":"IF(AND(I22<>0,L28>(P22-1)),1,0)","v":0}]
["umfassend modernisiert",null,null,null,null,18,"-",20,{"$f":"IF(AND(I12<>\"\",F23<=I12,H23>=I12,I12<1),I12,IF((F23<=I12)*OR(H23>=I12),I12,0))","v":0},null,null,"≥ 18 Punkte",2E-3,0.44,94.2,10,0,{"$f":"IF(AND(I23<>0,L28>(P23-1)),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe",{"$f":"SUM(Q19:Q23)","v":24},{"$f":"SUM(R19:R23)","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":2023},null,null,null,null,null,36]
[null,"Baujahr",null,null,null,{"$f":"EingabeMaske!D26","v":1960},null,null,null,null,null,"Berechnung des relativen Gebäudealters (Alter/GNDx100):"]
[null,"tatsächliches Alter",null,null,null,{"$f":"F26-F27","v":63},null,null,"Jahre",null,null,60,"%"]
[null,"Bestimmung der Restnutzungsdauer nach ImmoWertV"]
[null,"Gesamtnutzungsdauer (80 Jahre)",null,null,null,{"$f":"EingabeMaske!D27","v":80},null,null,"Jahre"]
[null,"Restnutzungsdauer nach ImmoWertV",null,null,null,{"$f":"'RND nach ImmoWertV'!B15","v":24},null,null,"Jahre"]
[null,"lineare Alterswertminderung",null,null,null,{"$f":"ROUND((F30-F31)/F30*100,0)","v":70},null,null,"%"]

{"sheet":"Indizes 2022 Schätzung 2023","index":6,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":true,"merged":[[14,21,14,22],[15,21,15,22],[16,21,16,22],[17,21,17,22],[7,19,7,20],[8,19,8,20],[10,21,10,22],[11,21,11,22],[12,21,12,22],[13,21,13,22]]}
["     Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2023",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EingabeMaske!E1","v":"WE-Rechner, Version 4 - LGMB 2023, Stand 11.2024"}]
[]
[]
[]
[]
[]
[]
[null,"Indizes jeweils zum 1.1. des Jahres, für Rechner des LfSt inkl. Schätzung 1.1.2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marktsegment","Stichtag",null,{"$f":"DATE(T10,1,1)","v":"2023-01-01"},{"$f":"DATE(U10,1,1)","v":"2024-01-01"},"Stichtag Richtwert"]
[null,"Preisindex für Wohnungseigentume (Weiterverkäufe)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Schätzung","Schätzung",null,{"$f":"EingabeMaske!D43","v":0},{"$f":"EingabeMaske!D15","v":"2023-07-04"},null,"Tage","Tage","2022-01-01"]
[null,"Markt-segment",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,null,null,{"$f":"YEAR(T9)","v":2023},{"$f":"T10+1","v":2024},{"$f":"_xlfn.DAYS(T9,V8)","v":184},{"$f":"_xlfn.DAYS(W8,V8)","v":365},{"$f":"YEAR(X9)","v":2022}]
[null,1,100,85.793650793650798,88.862433862433861,92.116402116402114,98.253968253968253,97.394179894179914,101.94444444444446,113.16137566137567,118.25396825396825,126.7989417989418,138.49206349206352,158.94179894179896,176.74708994708996,196.11428571428573,{"$f":"P11","v":196.11428571428573},null,1,{"$f":"ROUND(HLOOKUP(T$10,$C$10:$Q$17,2),1)","v":196.1},{"$f":"ROUND(HLOOKUP(U$10,$C$10:$Q$17,2),1)","v":196.1},{"$f":"T11+(U11-T11)*$V$10/$W$10","v":196.1},null,{"$f":"HLOOKUP($X$10,$E$10:$Q$17,2)","v":176.74708994708996}]
[null,2,100,99.247121346324192,98.051372896368477,99.247121346324192,98.815323294951284,102.43578387953943,105.82373782108061,111.61426040744023,119.2648361381754,127.59078830823741,139.88042515500442,156.00088573959258,173.22187776793623,190.96767050487159,{"$f":"P12","v":190.96767050487159},null,2,{"$f":"ROUND(HLOOKUP(T$10,$C$10:$Q$17,3),1)","v":191},{"$f":"ROUND(HLOOKUP(U$10,$C$10:$Q$17,3),1)","v":191},{"$f":"T12+(U12-T12)*$V$10/$W$10","v":191},null,{"$f":"HLOOKUP($X$10,$E$10:$Q$17,3)","v":173.22187776793623}]
[null,3,100,99.641475610906667,105.71752052080383,108.20832153976789,112.01056703462591,114.97311067081802,123.12482309651853,131.40862345504294,142.126615718464,150.69346164732519,167.27049721671852,189.67827153505047,213.98320596282664,232.09963204075854,232.09963204075854,null,3,{"$f":"ROUND(HLOOKUP(T$10,$C$10:$Q$17,4),1)","v":232.1},{"$f":"ROUND(HLOOKUP(U$10,$C$10:$Q$17,4),1)","v":232.1},232.1,null,{"$f":"HLOOKUP($X$10,$E$10:$Q$17,4)","v":213.98320596282664}]
[null,4,100,102.35121234386482,105.81373989713447,110.92946362968405,116.10947832476121,123.58559882439384,131.26377663482737,143.99338721528289,157.21895664952243,174.4489346069067,193.8280675973549,221.62013225569436,248.91293166789131,272.93277002204263,272.93277002204263,null,4,{"$f":"ROUND(HLOOKUP(T$10,$C$10:$Q$17,5),1)","v":272.89999999999998},{"$f":"ROUND(HLOOKUP(U$10,$C$10:$Q$17,5),1)","v":272.89999999999998},{"$f":"T14+(U14-T14)*$V$10/$W$10","v":272.89999999999998},null,{"$f":"HLOOKUP($X$10,$E$10:$Q$17,5)","v":248.91293166789131}]
[null,5,100,103.47150259067357,109.64470762398224,115.92894152479644,124.30792005921541,132.08734270910435,142.68689859363434,153.84900074019242,166.49888971132492,183.51591413767579,203.10880829015539,225.37379718726868,242.9385640266469,258.07549962990379,258.07549962990379,null,5,{"$f":"ROUND(HLOOKUP(T$10,$C$10:$Q$17,6),1)","v":258.10000000000002},{"$f":"ROUND(HLOOKUP(U$10,$C$10:$Q$17,6),1)","v":258.10000000000002},258.10000000000002,null,{"$f":"HLOOKUP($X$10,$E$10:$Q$17,6)","v":242.9385640266469}]
[null,6,100,103.10262529832937,108.34659241580482,117.83346592415805,126.98886237072395,138.37178467250067,151.63086714399364,167.73402280562186,182.98196764783879,199.87403871652086,218.40360647043221,245.37258021744896,269.8907451604349,294,294,null,6,{"$f":"ROUND(HLOOKUP(T$10,$C$10:$Q$17,7),1)","v":294},{"$f":"ROUND(HLOOKUP(U$10,$C$10:$Q$17,7),1)","v":294},294,null,{"$f":"HLOOKUP($X$10,$E$10:$Q$17,7)","v":269.8907451604349}]
[null,"Ø RLP",100,101.75438596491229,105.47049441786282,110.39872408293461,115.99681020733652,122.39234449760765,131.81818181818181,143.62041467304624,156.64274322169061,171.90590111642746,189.76874003189795,211.69059011164276,231.18341307814993,247.80861244019138,247.80861244019138,null,"Ø RLP",{"$f":"ROUND(HLOOKUP(T$10,$C$10:$Q$17,8),1)","v":247.8},{"$f":"ROUND(HLOOKUP(U$10,$C$10:$Q$17,8),1)","v":247.8},247.8,null,{"$f":"HLOOKUP($X$10,$E$10:$Q$17,8)","v":231.18341307814993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S9","v":0},null,"=",{"$f":"ROUND(VLOOKUP(S9,S11:V17,4),1)","v":{"$error":"#N/A"}},null,{"$f":"ROUND(VLOOKUP(S9,S11:X17,6),1)","v":{"$error":"#N/A"}}]
[null,"© Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz, Stand März 2023"]
[null,"vgl. LGMB 2023, Abschnitt 4.6.1 und 4.6.2 "]
[]
[null,null,"Die derzeit unklar Situation am Immobilienmarkt erschwert eine Prognose zum 01.01.2023."]
[null,null,"Immer mehr Meldungen und Anzeichen sind zu erkennen, dass der Markt im Umbruch ist."]
[null,null,"Daher ist es in diesem Ausnahmenfall angebracht, von der vereinbarten Rechenformel *1)"]
[null,null,"nach Dr. Gante (Sprengnetter) abzuweichen."]
[null,null,"Die Prognose wurder daher um die Hälfte des prognostizierten Wachstums,"]
[null,null,"sachverständig durch Herr Christian Paulik verringert."]
[null,null,"Die Schätzung für 01.01.2023 beeinflußt durch die Glättung  den Wert zum aktuellen Stichtag 01.01.2022."]
[null,null,"Die Schätzung findet des Weiteren Anwendung im EFH-/WE-Rechner."]
[]
[null,"*1)"]
[null,null,"Statistisches Verfahren der Glättung",null,null,null,null,null,null,null,"Stand des Verfahrens 30.7.2019"]
[null,null," A   Prognose: durch Extrapolation über 5 Einzel-Preissteigerungsraten (d.h. aus 6 Jahren)"]
[null,null,"Das Verfahren \"Extrapolation mittels Preissteigerungsraten x letztem Wert\" wurde 2019 "]
[null,null,"in Fulda von Dr. Gante (Fa. Sprengnetter) vorgestellt."]
[null,null,"Es ist eines von vielen in Frage kommenden Verfahren, es erscheint für "]
[null,null,"Immobilienpreiszeitreihen besonders geeignet."]
[null,null,"Beispiel",null,null,"Preissteigerungsraten",null,null,null,"Extrapolation"]
[null,null,"Klasse 1","2015 / 2014","2016 / 2015","2017 / 2016","2018 / 2017","2019 / 2018","2020/2019","I 2019","I 2020"]
[null,null,null,1.0549999999999999,0.99526066350710896,1.1317460317460317,1.1079943899018232,1.0253164556962027,"1,059 *)","x   168,8","= 178,7 **)"]
[null,null,"*)   Prognose der Preissteigerungsrate "]
[null,null," = (letzte  + Mittelwert letzte 3 Jahre + Mittelwert letzte 5 Jahre) / 3"]
[null,null,"="," (1,025 +(1,025+1,108+1,132)/3 +( 1,025+1,108+1,132+0,995+1,055)/5) / 3  =  1,059"]
[]
[null,null,"**)  Prognose des künftigen Index 2020"]
[null,null," = letzter (ungeglätteter) Index 2019 x prognost. Preissteigerungsrate 2020/2019  "]
[null,null,null,null,null,"=","168.8 x 1,059 = 178,7"]

{"sheet":"Indizes 2023 Schätzung 2024","index":7,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":true,"merged":[[14,22,14,23],[15,22,15,23],[16,22,16,23],[17,22,17,23],[7,20,7,21],[8,20,8,21],[10,22,10,23],[11,22,11,23],[12,22,12,23],[13,22,13,23]]}
["Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2023"]
[{"$f":"EingabeMaske!E1","v":"WE-Rechner, Version 4 - LGMB 2023, Stand 11.2024"}]
[]
[]
[]
[]
[]
[null,"Indizes jeweils zum 1.1. des Jahres, für Rechner des LfSt inkl. Schätzung 1.1.2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marktsegment","Stichtag",null,{"$f":"DATE(U10,1,1)","v":"2023-01-01"},{"$f":"DATE(V10,1,1)","v":"2024-01-01"},"Stichtag Richtwert"]
[null,"Preisindex für Wohnungseigentume (Weiterverkäufe)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schätzung","Schätzung",null,{"$f":"EingabeMaske!D43","v":0},{"$f":"EingabeMaske!D15","v":"2023-07-04"},null,"Tage","Tage","2022-01-01"]
[null,"Markt-segment",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,null,null,{"$f":"YEAR(U9)","v":2023},{"$f":"U10+1","v":2024},{"$f":"_xlfn.DAYS(U9,W8)","v":184},{"$f":"_xlfn.DAYS(X8,W8)","v":365},{"$f":"YEAR(Y9)","v":2022}]
[null,1,100,85.793650793650798,88.862433862433861,92.116402116402114,98.253968253968253,97.394179894179914,101.94444444444446,113.16137566137567,118.25396825396825,126.7989417989418,138.49206349206352,158.94179894179896,186,167,151,{"$f":"Q11","v":151},null,1,{"$f":"ROUND(HLOOKUP(U$10,$C$10:$R$17,2),1)","v":167},{"$f":"ROUND(HLOOKUP(V$10,$C$10:$R$17,2),1)","v":151},{"$f":"U11+(V11-U11)*$W$10/$X$10","v":158.93424657534246},null,{"$f":"HLOOKUP($Y$10,$E$10:$Q$17,2)","v":186}]
[null,2,100,99.247121346324192,98.051372896368477,99.247121346324192,98.815323294951284,102.43578387953943,105.82373782108061,111.61426040744023,119.2648361381754,127.59078830823741,139.88042515500442,157,181,195,176,{"$f":"Q12","v":176},null,2,{"$f":"ROUND(HLOOKUP(U$10,$C$10:$R$17,3),1)","v":195},{"$f":"ROUND(HLOOKUP(V$10,$C$10:$R$17,3),1)","v":176},{"$f":"U12+(V12-U12)*$W$10/$X$10","v":185.42191780821918},null,{"$f":"HLOOKUP($Y$10,$E$10:$Q$17,3)","v":181}]
[null,3,100,99.641475610906667,105.71752052080383,108.20832153976789,112.01056703462591,114.97311067081802,123.12482309651853,131.40862345504294,142.126615718464,150.69346164732519,167.27049721671852,188,230,234,211,211,null,3,{"$f":"ROUND(HLOOKUP(U$10,$C$10:$R$17,4),1)","v":234},{"$f":"ROUND(HLOOKUP(V$10,$C$10:$R$17,4),1)","v":211},222.40547945205481,null,{"$f":"HLOOKUP($Y$10,$E$10:$Q$17,4)","v":230}]
[null,4,100,102.35121234386482,105.81373989713447,110.92946362968405,116.10947832476121,123.58559882439384,131.26377663482737,143.99338721528289,157.21895664952243,174.4489346069067,193.8280675973549,223,263,257,231,231,null,4,{"$f":"ROUND(HLOOKUP(U$10,$C$10:$R$17,5),1)","v":257},{"$f":"ROUND(HLOOKUP(V$10,$C$10:$R$17,5),1)","v":231},{"$f":"U14+(V14-U14)*$W$10/$X$10","v":243.8931506849315},null,{"$f":"HLOOKUP($Y$10,$E$10:$Q$17,5)","v":263}]
[null,5,100,103.47150259067357,109.64470762398224,115.92894152479644,124.30792005921541,132.08734270910435,142.68689859363434,153.84900074019242,166.49888971132492,183.51591413767579,203.10880829015539,227,253,250,225,225,null,5,{"$f":"ROUND(HLOOKUP(U$10,$C$10:$R$17,6),1)","v":250},{"$f":"ROUND(HLOOKUP(V$10,$C$10:$R$17,6),1)","v":225},237.39726027397259,null,{"$f":"HLOOKUP($Y$10,$E$10:$Q$17,6)","v":253}]
[null,6,100,103.10262529832937,108.34659241580482,117.83346592415805,126.98886237072395,138.37178467250067,151.63086714399364,167.73402280562186,182.98196764783879,199.87403871652086,218.40360647043221,245.37258021744896,276,267,240,240,null,6,{"$f":"ROUND(HLOOKUP(U$10,$C$10:$R$17,7),1)","v":267},{"$f":"ROUND(HLOOKUP(V$10,$C$10:$R$17,7),1)","v":240},253.38904109589041,null,{"$f":"HLOOKUP($Y$10,$E$10:$Q$17,7)","v":276}]
[null,"Ø RLP",100,101.75438596491229,105.47049441786282,110.39872408293461,115.99681020733652,122.39234449760765,131.81818181818181,143.62041467304624,156.64274322169061,171.90590111642746,189.76874003189795,213,240,239,215,215,null,"Ø RLP",{"$f":"ROUND(HLOOKUP(U$10,$C$10:$R$17,8),1)","v":239},{"$f":"ROUND(HLOOKUP(V$10,$C$10:$R$17,8),1)","v":215},226.90136986301371,null,{"$f":"HLOOKUP($Y$10,$E$10:$Q$17,8)","v":240}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T9","v":0},null,"=",{"$f":"ROUND(VLOOKUP(T9,T11:W17,4),1)","v":{"$error":"#N/A"}},null,{"$f":"ROUND(VLOOKUP(T9,T11:Y17,6),1)","v":{"$error":"#N/A"}}]
[null,"© Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz, Stand Juli 2023"]
[null,"vgl. LGMB 2023, Abschnitt 4.6.1 und 4.6.2 "]

{"sheet":"Indizes 2024 Schätzung 2025","index":8,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":true,"merged":[[14,23,14,24],[15,23,15,24],[16,23,16,24],[17,23,17,24],[7,21,7,22],[8,21,8,22],[10,23,10,24],[11,23,11,24],[12,23,12,24],[13,23,13,24]]}
["Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2023"]
[{"$f":"EingabeMaske!E1","v":"WE-Rechner, Version 4 - LGMB 2023, Stand 11.2024"}]
[]
[]
[]
[]
[]
[null,"Indizes jeweils zum 1.1. des Jahres, für Rechner des LfSt inkl. Schätzung 1.1.2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marktsegment","Stichtag",null,{"$f":"DATE(V10,1,1)","v":"2023-01-01"},{"$f":"DATE(W10,1,1)","v":"2024-01-01"},"Stichtag Richtwert"]
[null,"Preisindex für Wohnungseigentume (Weiterverkäufe)",null,null,null,null,null,null,null,null,null,null,null,null,"Stichtag Richtwert",null,null,"Schätzung OGA","LfST",null,{"$f":"EingabeMaske!D43","v":0},{"$f":"EingabeMaske!D15","v":"2023-07-04"},null,"Tage","Tage","2022-01-01"]
[null,"Markt-segment",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,null,null,{"$f":"YEAR(V9)","v":2023},{"$f":"V10+1","v":2024},{"$f":"_xlfn.DAYS(V9,X8)","v":184},{"$f":"_xlfn.DAYS(Y8,X8)","v":365},{"$f":"YEAR(Z9)","v":2022}]
[null,1,100,85.793650793650798,88.862433862433861,92.116402116402114,98.253968253968253,97.394179894179914,101.94444444444446,113.16137566137567,118.25396825396825,126.7989417989418,138.49206349206352,158.94179894179896,186,167,186,{"$f":"Q11","v":186},{"$f":"R11","v":186},null,1,{"$f":"ROUND(HLOOKUP(V$10,$C$10:$S$17,2),1)","v":167},{"$f":"ROUND(HLOOKUP(W$10,$C$10:$S$17,2),1)","v":186},{"$f":"V11+(W11-V11)*$X$10/$Y$10","v":176.57808219178082},null,{"$f":"HLOOKUP($Z$10,$E$10:$Q$17,2)","v":186}]
[null,2,100,99.247121346324192,98.051372896368477,99.247121346324192,98.815323294951284,102.43578387953943,105.82373782108061,111.61426040744023,119.2648361381754,127.59078830823741,139.88042515500442,157,181,194,192,{"$f":"Q12","v":192},192,null,2,{"$f":"ROUND(HLOOKUP(V$10,$C$10:$S$17,3),1)","v":194},{"$f":"ROUND(HLOOKUP(W$10,$C$10:$S$17,3),1)","v":192},{"$f":"V12+(W12-V12)*$X$10/$Y$10","v":192.99178082191781},null,{"$f":"HLOOKUP($Z$10,$E$10:$Q$17,3)","v":181}]
[null,3,100,99.641475610906667,105.71752052080383,108.20832153976789,112.01056703462591,114.97311067081802,123.12482309651853,131.40862345504294,142.126615718464,150.69346164732519,167.27049721671852,188,230,233,230,230,230,null,3,{"$f":"ROUND(HLOOKUP(V$10,$C$10:$S$17,4),1)","v":233},{"$f":"ROUND(HLOOKUP(W$10,$C$10:$S$17,4),1)","v":230},231.48767123287672,null,{"$f":"HLOOKUP($Z$10,$E$10:$Q$17,4)","v":230}]
[null,4,100,102.35121234386482,105.81373989713447,110.92946362968405,116.10947832476121,123.58559882439384,131.26377663482737,143.99338721528289,157.21895664952243,174.4489346069067,193.8280675973549,223,263,256,231,231,231,null,4,{"$f":"ROUND(HLOOKUP(V$10,$C$10:$S$17,5),1)","v":256},{"$f":"ROUND(HLOOKUP(W$10,$C$10:$S$17,5),1)","v":231},{"$f":"V14+(W14-V14)*$X$10/$Y$10","v":243.39726027397259},null,{"$f":"HLOOKUP($Z$10,$E$10:$Q$17,5)","v":263}]
[null,5,100,103.47150259067357,109.64470762398224,115.92894152479644,124.30792005921541,132.08734270910435,142.68689859363434,153.84900074019242,166.49888971132492,183.51591413767579,203.10880829015539,227,253,248,227,227,227,null,5,{"$f":"ROUND(HLOOKUP(V$10,$C$10:$S$17,6),1)","v":248},{"$f":"ROUND(HLOOKUP(W$10,$C$10:$S$17,6),1)","v":227},237.41369863013699,null,{"$f":"HLOOKUP($Z$10,$E$10:$Q$17,6)","v":253}]
[null,6,100,103.10262529832937,108.34659241580482,117.83346592415805,126.98886237072395,138.37178467250067,151.63086714399364,167.73402280562186,182.98196764783879,199.87403871652086,218.40360647043221,245.37258021744896,276,263,248,248,248,null,6,{"$f":"ROUND(HLOOKUP(V$10,$C$10:$S$17,7),1)","v":263},{"$f":"ROUND(HLOOKUP(W$10,$C$10:$S$17,7),1)","v":248},255.43835616438355,null,{"$f":"HLOOKUP($Z$10,$E$10:$Q$17,7)","v":276}]
[null,"Ø RLP",100,101.75438596491229,105.47049441786282,110.39872408293461,115.99681020733652,122.39234449760765,131.81818181818181,143.62041467304624,156.64274322169061,171.90590111642746,189.76874003189795,213,240,237,214,214,214,null,"Ø RLP",{"$f":"ROUND(HLOOKUP(V$10,$C$10:$S$17,8),1)","v":237},{"$f":"ROUND(HLOOKUP(W$10,$C$10:$S$17,8),1)","v":214},225.40547945205481,null,{"$f":"HLOOKUP($Z$10,$E$10:$Q$17,8)","v":240}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U9","v":0},null,"=",{"$f":"ROUND(VLOOKUP(U9,U11:X17,4),1)","v":{"$error":"#N/A"}},null,{"$f":"ROUND(VLOOKUP(U9,U11:Z17,6),1)","v":{"$error":"#N/A"}}]
[null,"© Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz, Stand Juli 2024"]
[null,"vgl. LGMB 2023, Abschnitt 4.6.1 und 4.6.2 "]

{"sheet":"RND nach ImmoWertV","index":9,"n_rows":15,"n_cols":31,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
["Restnutzungsdauer bei Modernisierung nach ImmoWertV"]
[null,null,null,null,null,null,null,null,null,"a",1.25,1.25,1.0767,0.90329999999999999,0.73,0.67249999999999999,0.61499999999999999,0.5575,0.5,0.46600000000000003,0.432,0.39800000000000002,0.36399999999999999,0.33,0.30399999999999999,0.27800000000000002,0.252,0.22600000000000001,0.2,0.2,0.2]
[null,null,null,null,null,null,null,null,null,"b",2.625,2.625,2.2757000000000001,1.9262999999999999,1.577,1.4578,1.3385,1.2193000000000001,1.1000000000000001,1.0269999999999999,0.95399999999999996,0.88100000000000001,0.80800000000000005,0.73499999999999999,0.67600000000000005,0.61699999999999999,0.55800000000000005,0.499,0.44,0.44,0.44]
[null,null,null,null,null,null,null,null,null,"c",1.5249999999999999,1.5249999999999999,1.3877999999999999,1.2504999999999999,1.1133,1.085,1.0567,1.0283,1,0.99060000000000004,0.98109999999999997,0.97170000000000001,0.96220000000000006,0.95279999999999998,0.9506,0.94850000000000001,0.94630000000000003,0.94420000000000004,0.94199999999999995,0.94199999999999995,0.94199999999999995]
[null,null,null,null,null,null,null,null,null,"ab rel. Alter",60,60,55,55,40,35,30,25,20,19,18,17,16,15,14,13,12,11,10,10,10]
[]
[null,"Ergebnis",null,null,null,null,null,"Vorgaben"]
[null,"RND","Pkte","abger. Pkte","RND","aufger. Pkte","RND","GND","Alter","rel. Alter [%]",0,{"$f":"K9+1","v":1},{"$f":"L9+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[1,{"$f":"ROUND(E10+(C10-D10)*(G10-E10),0)","v":19},{"$f":"RND!I12","v":0},{"$f":"ROUNDDOWN(C10,0)","v":0},{"$f":"IF($J10=0,0,HLOOKUP(D10,$K$9:$AE$10,$A10+1,0))","v":18.64},{"$f":"ROUNDUP(C10,0)","v":0},{"$f":"IF($J10=0,0,HLOOKUP(F10,$K$9:$AE$10,$A10+1,0))","v":18.64},{"$f":"RND!F30","v":80},{"$f":"RND!F28","v":63},{"$f":"IF(H10=0,0,I10/H10*100)","v":78.75},{"$f":"ROUND(IF(($J10>=K$6)*($H10>=$I10),K$3*$I10^2/$H10-K$4*$I10+K$5*$H10,IF(($J10>=K$6)*($H10<$I10),K$3*$H10^2/$H10-K$4*$H10+K$5*$H10,$H10-$I10)),2)","v":18.64},{"$f":"ROUND(IF(($J10>=L$6)*($H10>=$I10),L$3*$I10^2/$H10-L$4*$I10+L$5*$H10,IF(($J10>=L$6)*($H10<$I10),L$3*$H10^2/$H10-L$4*$H10+L$5*$H10,$H10-$I10)),2)","v":18.64},21.07,23.5,25.93,28.32,30.72,33.11,35.51,37.67,39.82,41.98,44.13,46.29,48.54,50.8,53.05,55.31,57.56,57.56,57.56]
[]
[null,"Mindestrestnutzungsdauer:"]
[null,{"$f":"30%*H10","v":24}]
[null,"maßgeblich:"]
[null,{"$f":"IF(B13>B10,B13,B10)","v":24},"Jahre"]

{"sheet":"Werte Neu","index":10,"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]