{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["EingabeMaske","Berechnung und Ergebnis","Vergleichsdaten 2021","Vergleichsdaten 2022","Vergleichsfaktoren 2021 (2)","Vergleichsdaten 2023","GebStandard","RND","modifizierte RND","Werte","Werte 2"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":1,"defined_names":411,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EingabeMaske","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[25,9,25,11],[27,9,27,11],[30,9,30,12],[31,9,31,11],[35,0,35,4],[35,8,35,12],[26,0,26,2],[25,0,25,2],[26,9,26,10],[3,0,3,4],[12,10,12,12],[11,1,11,3],[4,0,4,4],[5,0,5,4],[8,0,8,3],[12,1,13,3],[12,0,13,0],[14,9,14,11],[20,1,20,2],[23,9,23,11],[24,9,24,11],[15,9,15,11],[16,9,16,11],[18,9,18,11],[20,9,20,11],[21,9,21,11],[19,0,19,2],[19,9,19,11],[22,5,22,7],[17,9,17,10]]}
[null,null,null,"EFH-Rechner, Version 1 - 2023",null,null,null,null,null,null,null,null,{"$f":"D1","v":"EFH-Rechner, Version 1 - 2023"}]
[]
[]
["Vergleichswertberechnung für Einfamilienwohnhäuser mittels Vergleichswertfaktoren des Landesgrundstücksmarktberichtes 2021"]
["gem. § 182 Abs.2 BewG i. V. m. § 183 BewG. ",null,"Carport"]
[]
["Bitte Hinweise in den Kommentarfeldern in Spalte \"E\" beachten.",null,null,null,null,null,null,null,null,"keine Angabe"]
["Eingabefelder blau","Berechnungsfelder rot"]
[]
["Angaben zum Wertermittlungsobjekt",null,null,null,null,null,null,null,null,"Angaben zum Richtwertobjekt"]
[]
["Adresse und Ort:","Musterstraße 13, 00000 Musterstadt"]
["Gemeinde / Gemarkung / Landkreis bzw. Stadt:"," /  / ",null,null,null,null,null,null,null,"Gemeinde / Gemarkung / Landkreis bzw. Stadt:",{"$f":"B13","v":" /  / "},null,"Bobenheim-Roxheim - Roxheim"]
[null,null,null,null,null,null,null,"1960-01-01",null,"Marktsegment",null,null,{"$f":"ROUND(VLOOKUP(EingabeMaske!B13,'Vergleichsfaktoren 2021 (2)'!A8:I3023,6,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Stichtag:",null,null,"2020-01-01"]
["Wertermittlungsstichtag (WST):",null,null,"2020-01-01",null,null,null,{"$f":"IF(D16>TODAY(),\"plausibel ?\",IF(D16<H14,\"plausibel ?\",\" \"))","v":" "},{"$f":"(YEAR(D16)+1)","v":2021},"Index nach Marktsegment 01.01.2020 (2010 = 100):",null,null,{"$f":"IF(YEAR(D16)=2022,'Vergleichsdaten 2022'!J297,IF(YEAR(D16)>=2023,'Vergleichsdaten 2023'!J185,'Vergleichsdaten 2021'!J171))","v":0}]
["Index nach Marktsegment (2010 = 100)",null,{"$f":"IF(D16>TODAY(),\"Datum liegt in der Zukunft\",\"\")","v":""},{"$f":"IF(YEAR(D16)=2022,'Vergleichsdaten 2022'!I297,IF(YEAR(D16)>=2023,'Vergleichsdaten 2023'!I185,'Vergleichsdaten 2021'!I171))","v":0},null,null,null,null,null,"Vergleichsfaktor (Haustyp freistehend)",null,null,{"$f":"ROUND(VLOOKUP(EingabeMaske!B13,'Vergleichsfaktoren 2021 (2)'!A8:I3023,8,FALSE),0)","v":0}]
["Haustyp",null,null,"freistehend",null,null,null,null,null,{"$f":"IF('Vergleichsdaten 2022'!J37=1,\"Vergleichsfaktor (\"&M17&\" €/m² x 1,00)\", \"Vergeichsfaktor (Haustyp \"&D18\n&\") [(\"&M17&\" €/m² x \"&'Vergleichsdaten 2022'!J37&\") x \"&'Vergleichsdaten 2022'!I38&\" / \"&'Vergleichsdaten 2022'!B12& \"]\")","v":"Vergleichsfaktor (0 €/m² x 1,00)"},null,null,{"$f":"M17*'Vergleichsdaten 2022'!J37*'Vergleichsdaten 2022'!I38/'Vergleichsdaten 2022'!B12","v":{"$error":"#NUM!"}}]
["gesamte Grundstücksgröße (gGG):",null,null,500,null,null,null,{"$f":"IF(D19<0.0000001,\"plausibel ?\",IF(D19>3000,\"plausibel ?\",\" \"))","v":" "},null,"Grundstücksgröße (GG):",null,null,{"$f":"'Vergleichsdaten 2022'!B11","v":500}]
["Fall 3: Eine Aufteilung in selbstständig verwertbare und baulich nutzbare Teilflächen ist nicht möglich. Die mittlere Tiefe des Grundstücks liegt unter 40 m. Eintrag auf 0 setzen.",null,null,0,null,null,null,{"$f":"LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!N2:N4)","v":""},null,"bebaute Grundstücksteilfläche bei möglicher separater Verwertbarkeit",null,null,"keine Angabe"]
["Gebäudestandardstufe (GST): \ngemäß Erklärung, hilfsweise Schätzung","siehe Berechnungshilfe Blatt \"GebStandard\" ",null,{"$f":"GebStandard!I25","v":3},null,null,null,null,null,"Gebäudestandardstufe (GST):",null,null,{"$f":"'Vergleichsdaten 2022'!B6","v":3}]
["Wohnfläche (WF):",null,null,145,null,null,null,null,null,"Wohnfläche (WF):",null,null,{"$f":"'Vergleichsdaten 2022'!B3","v":145}]
["Baujahr (BJ):",null,null,2005,null,{"$f":"IF(D23>=1960,\"\",IF((D23<1960)*(RND!F35<>\"ja\"),\"Das tatsächliche Baujahr liegt vor 1960. Dies erfordert eine Prüfung, ob durch Modernisierungsmaßnahmen der letzten 10 Jahre das Baujahr fiktiv mindestens auf das Jahr 1960 verjüngt wird (siehe Tabelle RND).\",IF((D23<1960)*(RND!F35=\"ja\"),IF(RND!F34<1960,\"Das fiktive Baujahr liegt unter 1960. Das Objekt ist im Sachwertverfahren zu bewerten!\",\"\"))))","v":""},null,null,null,"Baujahr (BJ):",null,null,{"$f":"J7","v":"keine Angabe"}]
["Gesamtnutzungsdauer (GND):",null,null,{"$f":"ROUND(5*D21+55,0)","v":70},null,null,null,null,null,"Gesamtnutzungsdauer (GND):",null,null,{"$f":"'Vergleichsdaten 2022'!B7","v":70}]
["Restnutzungsdauer (RND):",null,null,{"$f":"ROUND(IF((RND!F35=\"nein\")*(D24-(YEAR(D16)-D23)>= D24*30%),D24-(YEAR(D16)-D23),IF((RND!F35=\"ja\")*(RND!F32>=D24*30%),RND!F32,D24*30%)),0)","v":55},null,null,null,{"$f":"IF(OR(D25<=15,D25=D24),\"plausibel ?\",\" \")","v":" "},null,"Restnutzungsdauer (RND):",null,null,{"$f":"'Vergleichsdaten 2022'!B8","v":55}]
["Bodenrichtwert (BRW) 01.01.2020\ngemäß Liegenschaftskarte/Geodatenserver RP\n(Auf ältere Stichtage erfolgt programmgesteuert eine Umrechnung mittels eines Indexes.)",null,null,300,null,null,null,{"$f":"IF(D26<5,\"plausibel ?\",IF(D26>1000,\"plausibel ?\",\" \"))","v":" "},null,"Bodenrichtwert (BRW),\nmaßgeblich ist der BRW zum 01.01.2020\ngemäß Liegenschaftskarte/Geodatenserver RP",null,null,{"$f":"'Berechnung und Ergebnis'!F31","v":0}]
["falls im Bodenrichtwert enthalten: Angabe der Grundstücksgröße des Bodenrichtwerts",null,null,500,null,null,null,null,null,{"$f":"IF('Vergleichsdaten 2022'!J37=1,\"Sachwertfaktor\",\"Sachwertfaktor (Sachwertfaktor bei Haustyp freistehend = \"&'Vergleichsdaten 2022'!B12&\")\")","v":"Sachwertfaktor"},null,null,{"$f":"'Vergleichsdaten 2022'!I38","v":{"$error":"#NUM!"}}]
["Außen- und Nebenanlagen (Zeitwert): \nmindestens Erschließung",null,null,{"$f":"ROUND('Berechnung und Ergebnis'!F92*'Berechnung und Ergebnis'!F99/'Berechnung und Ergebnis'!F100*EingabeMaske!D22*4%,-2)","v":{"$error":"#NUM!"}},null,null,null,{"$f":"IF(D28<0,\"plausibel ?\",IF(D28>100000,\"plausibel ?\",\" \"))","v":{"$error":"#NUM!"}},null,"Außen- und Nebenanlagen (Zeitwert):",null,null,0]
["Nebengebäude",null,"Sonstiges (freie Eingabe)",0,null,null,null,null,null,"Nebengebäude",null,null,0]
[]
["Umrechnungskoeffizient aufgrund der Berücksichtigung von Einliegerwohnungen",null,null,null,null,null,null,null,null,"Umrechnungskoeffizient aufgrund der Berücksichtigung von Einliegerwohnungen"]
["FELW:",null,null,1,null,null,null,null,null,"FELW:",null,null,1]
[]
[]
[]
["     Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2021",null,null,null,null,null,null,null,{"$f":"A36","v":"     Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2021"}]

{"sheet":"Berechnung und Ergebnis","index":1,"n_rows":130,"n_cols":6,"rows_kept":130,"cut":false,"hidden":false,"merged":[[3,0,3,5],[4,0,4,5],[2,0,2,5],[5,1,5,5],[47,0,47,5],[15,1,15,4],[16,1,16,4],[21,1,21,4],[11,0,11,4],[17,1,17,4],[125,3,125,5],[36,0,36,5],[54,0,54,5],[19,1,19,3],[38,0,38,5],[71,0,71,5],[103,0,103,5],[94,0,94,5],[98,1,98,3],[120,0,120,3],[123,0,123,5],[87,0,87,5],[112,0,112,3],[114,0,114,5],[118,0,119,3],[45,0,45,3]]}
[null,null,null,null,null,{"$f":"EingabeMaske!D1","v":"EFH-Rechner, Version 1 - 2023"}]
[]
["Vergleichswertberechnung für Ein-/Zweifamilienwohnhäuser mittels Vergleichswertfaktoren des Landesgrundstücksmarktberichtes 2021"]
["gem. § 182 Abs.2 BewG i. V. m. § 183 BewG. "]
[]
["Bezeichnung des Wertermittlungsobjekts\nder Bewertung nach § 183 BewG",{"$f":"EingabeMaske!B12","v":"Musterstraße 13, 00000 Musterstadt"}]
[]
["Angaben zum Wertermittlungsobjekt (WO)"]
[]
["Wertermittlungsstichtag (WST):",null,null,{"$f":"EingabeMaske!H16","v":" "},null,{"$f":"EingabeMaske!D16","v":"2020-01-01"}]
["gesamte Grundstücksgröße (gGG):",null,null,{"$f":"EingabeMaske!H19","v":" "},null,{"$f":"ROUND(EingabeMaske!D19,0)","v":500}]
["bei Aufteilung des Grundstücks in Bewertungsteilflächen: Grundstücksteilfläche (überbaute Fläche zzgl. Umgriffsfläche):",null,null,null,null,{"$f":"LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!C2:C4)","v":0}]
["Gebäudestandardstufe (GST): ","(gemäß Erklärung, hilfsweise Schätzung)",null,null,null,{"$f":"ROUND(EingabeMaske!D21,2)","v":3}]
["Wohnfläche (WF):",null,null,null,null,{"$f":"ROUND(EingabeMaske!D22,0)","v":145}]
["Baujahr (BJ):",null,null,null,null,{"$f":"EingabeMaske!D23","v":2005}]
["Gesamtnutzungsdauer (GND):","(austattungsbezogene GND gemäß der Sachwertrichtlinie)",null,null,null,{"$f":"ROUND(EingabeMaske!D24,0)","v":70}]
["Restnutzungsdauer (RND):",{"$f":"IF(F17>ROUND(0.3*F16,0),\"\",\"(in Anlehnung an § 185 Abs. 3 BewG: mind. 30% der GND)\")","v":""},null,null,null,{"$f":"ROUND(EingabeMaske!D25,0)","v":55}]
["Bodenrichtwert (BRW) 01.01.2020:","(auf abweichende Stichtage erfolgt programmgesteuert eine Umrechnung mittels Indizes)",null,null,null,{"$f":"ROUND(EingabeMaske!D26,0)","v":300}]
["Grundstücksgröße des Bodenrichtwerts:",null,null,null,null,{"$f":"ROUND(EingabeMaske!D27,0)","v":500}]
["Außen und Nebenanlagen (Zeitwert):","(mind. Erschließung; pauschal werden 4% des Gebäudewerts angesetzt)",null,null,null,{"$f":"EingabeMaske!D28","v":{"$error":"#NUM!"}}]
["Nebengebäude:",null,null,null,null,{"$f":"EingabeMaske!D29","v":0}]
["Bodenwertanteil (BWA) je m² Wohnfläche:",{"$f":"\"[ \"&ROUND(IF(F12>0,F12,F11),2)&\" m² x \"&F18&\" €/m² (ohne Größenanpassung) / \"&F14&\" m² ]\"","v":"[ 500 m² x 300 €/m² (ohne Größenanpassung) / 145 m² ]"},null,null,null,{"$f":"ROUND(IF(F12>0,F18*F12/F14,F18*F11/F14),2)","v":1034.48}]
[]
["Angaben zum Richtwertgrundstück (RWG)",null,null,null,null," "]
[null,null,null,null,null," "]
["Grundstücksgröße (GG):",null,null,null,null,{"$f":"EingabeMaske!M19","v":500}]
["Gebäudestandardstufe (GST):",null,null,null,null,{"$f":"EingabeMaske!M21","v":3}]
["Wohnfläche (WF):",null,null,null,null,{"$f":"EingabeMaske!M22","v":145}]
["Gesamtnutzungsdauer (GND):",null,null,null,null,{"$f":"EingabeMaske!M24","v":70}]
["Restnutzungsdauer (RND):",null,null,null,null,{"$f":"EingabeMaske!M25","v":55}]
["Bodenwertniveau (BWN):",null,null,null,null,{"$f":"ROUND(VLOOKUP(EingabeMaske!B13,'Vergleichsfaktoren 2021 (2)'!A8:I3023,7,FALSE),2)","v":0}]
["Vergleichsfaktor [Richtwert (RW)]: (je m² Wohnfläche)",{"$f":"IF('Vergleichsdaten 2022'!J37=1,\"\", \"[(\"&EingabeMaske!M17&\" €/m² x \"&'Vergleichsdaten 2022'!J37&\") x \"&'Vergleichsdaten 2022'!I38&\" / \"&'Vergleichsdaten 2022'!B12&\"]\")","v":""},null,null,null,{"$f":"EingabeMaske!M18","v":{"$error":"#NUM!"}}]
["Sachwertfaktor des Richtwertgrundstücks:",{"$f":"IF('Vergleichsdaten 2022'!J37=1,\"\",\"(Sachwertfaktor bei Haustyp freistehend = \"&'Vergleichsdaten 2022'!B12&\" )\")","v":""},null,null,null,{"$f":"'Vergleichsdaten 2022'!I38","v":{"$error":"#NUM!"}}]
[]
["Bodenwertanteil (BWA): (je m² Wohnfläche)",null,null," ",null,{"$f":"ROUND(F31*'Vergleichsdaten 2022'!B11/'Vergleichsdaten 2022'!B3,2)","v":0}]
[]
["Die vorliegenden Vergleichsfaktoren wurden vom oberen Gutachterausschuss für jede Gemarkung abgeleitet und beziehen sich auf die Merkmale für ein sog. Richtwertgrundstück.\nUm die Vergleichsfaktoren (im Weiteren als Richtwert bezeichnet) an das konkrete Wertermittlungsobjekt anzupassen, werden die seitens des OGA empfohlenen Anpassungsfaktoren und Umrechnungskoeffizienten zur Schätzung der Zu- und Abschläge angewandt. Diese wurden zum Teil vom OGA selbst abgeleitet bzw. der einschlägigen Literatur entnommen und entsprechend dem Bewertungsgesetz seitens des Landesamt für Steuern angepasst."]
["Berechnung des Vergleichswertes"]
["1. Berücksichtigung des Bodenwertanteils des Wertermittlungsobjekts (RW1)"]
["Bodenwertanteil des Wertermittlungsobjekts pro m² Wf"]
["Bodenwert pro m²",null,null,null,null,{"$f":"F18","v":300}]
["Grundstücksgröße",null,null,null,"x",{"$f":"IF(F12>0,F12,F11)","v":500}]
["Anpassung an die Grundstücksgröße",{"$f":"IF(EingabeMaske!D27=0,\"\",\"[ UK WO bei \"&F42&\" m²: \"&ROUND(LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!E2:E4),2)&\" / UK BRW bei \" &F19&\" m²: \"&ROUND(LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!F2:F4),2)&\" ]\")","v":"[ UK WO bei 500 m²: 1 / UK BRW bei 500 m²: 1 ]"},null,null,"x",{"$f":"ROUND(LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!G2:G4),2)","v":1}]
["Wohnfläche",null,null,null," /",{"$f":"EingabeMaske!D22","v":145}]
["Bodenwertanteil des Wertermittlungsobjekts pro m² Wf (ggf. nach Grundstücksgröße angepasst)",null,null,null,"=",{"$f":"ROUND(F41*F42*F43/F44,2)","v":1034.48}]
["(Die Umrechnungskoeffizienten zur Grundstücksgrößenanpassung wurden anhand der vom OGA zur Verfügung gestellten Formel ermittelt und können geringfügig von der veröffentlichen Tabelle im LGMB 2019 abweichen.)"]
["Ermittlung des Richtwertes mit dem Bodenwertanteil des Wertermittlungsobjekts"]
["Ausgangswert ist hier der Vergleichsfaktor (RW) des RWG. Dessen Bodenwertanteil wird ersetzt durch den Bodenwertanteil des individuellen Wertermittlungsobjektes."]
["Richtwert pro m² Wf",null,null,null,null,{"$f":"F32","v":{"$error":"#NUM!"}}]
["Sachwertfaktor",null,null,null," /",{"$f":"F33","v":{"$error":"#NUM!"}}]
["Richtwert ohne Marktanpassung",null,null,null,"=",{"$f":"ROUND(F49/F50,2)","v":{"$error":"#NUM!"}}]
["Bodenwertanteil des Wertermittlungsobjekts pro m² Wf",null,null,null,"+",{"$f":"F45","v":1034.48}]
["Bodenwertanteil des Richtwertobjekts",null,null,null," -",{"$f":"F35","v":0}]
["Anfangswert (RW0):",null,null,null,"=",{"$f":"ROUND(F51+F52-F53,2)","v":{"$error":"#NUM!"}}]
[]
[]
["Sachwertfaktor [SWF(WO)]:",null,null,null,"x",{"$f":"'Vergleichsdaten 2022'!B38","v":{"$error":"#NUM!"}}]
[]
["Zwischenergebnis (RW1):",null,null,null,"=",{"$f":"ROUND(F57*F54,2)","v":{"$error":"#NUM!"}}]
[]
[]
["2. Anpassung an den Gebäudestandard (RW2)"]
["Herauslösen des Gebäudewertanteils aus (RW1)",null,null,null,null,{"$f":"F59","v":{"$error":"#NUM!"}}]
["Zwischenergebnis [RW1(BW)]:",{"$f":"\"[ \"&F52&\" €/m² x \"&F57&\" ]\"","v":{"$error":"#NUM!"}},null,null,"-",{"$f":"ROUND(F45*F57,2)","v":{"$error":"#NUM!"}}]
["Zwischenergebnis [RW1(Geb)]:",null,null,null,"=",{"$f":"ROUND(F59-F64,2)","v":{"$error":"#NUM!"}}]
[]
["Anpassung an den Gebäudestandard"]
["UKGST(WO):",{"$f":"\"[ bei Gebäudestandard: \"&EingabeMaske!D21&\" ]\"","v":"[ bei Gebäudestandard: 3 ]"},null,null,"x",{"$f":"ROUND('Vergleichsdaten 2022'!C48+'Berechnung und Ergebnis'!F13*'Vergleichsdaten 2022'!C49+'Vergleichsdaten 2022'!C50*'Berechnung und Ergebnis'!F13^2+'Vergleichsdaten 2022'!C51*'Berechnung und Ergebnis'!F13^3+'Vergleichsdaten 2022'!C52*'Berechnung und Ergebnis'!F13^4,3)","v":1.276}]
["UKGST(RWG):",{"$f":"\"[ bei Gebäudestandard: \"&F27&\" ]\"","v":"[ bei Gebäudestandard: 3 ]"},null,null," /",{"$f":"ROUND('Vergleichsdaten 2022'!C48+'Vergleichsdaten 2022'!C49*'Vergleichsdaten 2022'!B6+'Vergleichsdaten 2022'!C50*'Vergleichsdaten 2022'!B6^2+'Vergleichsdaten 2022'!C51*'Vergleichsdaten 2022'!B6^3+'Vergleichsdaten 2022'!C52*'Vergleichsdaten 2022'!B6^4,3)","v":1.276}]
["Zwischenergebnis [RW2(Geb)]:",null,null,null,"=",{"$f":"ROUND(F68/F69*'Berechnung und Ergebnis'!F65,2)","v":{"$error":"#NUM!"}}]
[]
["3. Anpassung an die Restnutzungsdauer"]
["Zwischenergebnis [RW2(Geb)]:",null,null,null,null,{"$f":"F70","v":{"$error":"#NUM!"}}]
["Zwischenergebnis [Restwert (WO)]:","[gem. Alterswertminderungsfunktion des OGA]",null,null,"x",{"$f":"ROUND(IF(F17/F16=1,1,'Vergleichsdaten 2022'!C70*(F17/F16)^2+F17/F16*'Vergleichsdaten 2022'!C71),4)","v":0.81869999999999998}]
["Zwischenergebnis [Restwert (RWG)]:","[gem. Alterswertminderungsfunktion des OGA]",null,null," /",{"$f":"ROUND('Vergleichsdaten 2022'!C70*('Vergleichsdaten 2022'!B8/'Vergleichsdaten 2022'!B7)^2+'Vergleichsdaten 2022'!C71*'Vergleichsdaten 2022'!B8/'Vergleichsdaten 2022'!B7,4)","v":0.81869999999999998}]
[]
["Zwischenergebnis [RW3(Geb)]:",null,null,null,"=",{"$f":"ROUND(F70*F74/F75,2)","v":{"$error":"#NUM!"}}]
[]
[]
["4. Anpassung an die Wohnfläche (WF)"]
["Zwischenergebnis [RW3(Geb)]:",null,null,null,null,{"$f":"F77","v":{"$error":"#NUM!"}}]
["UKWF(WO):",{"$f":"\"[ bei Wohnfläche: \"&F14&\" m² ]\"","v":"[ bei Wohnfläche: 145 m² ]"},null,null," x",{"$f":"ROUND('Vergleichsdaten 2022'!C80*LN('Berechnung und Ergebnis'!F14)+'Vergleichsdaten 2022'!C81,2)","v":1}]
["UKWF(RWG):",{"$f":"\"[ bei Wohnfläche: \"&F28&\" m² ]\"","v":"[ bei Wohnfläche: 145 m² ]"},null,null," /",1]
[]
["Zwischenergebnis [RW4(Geb)]:",null,null,null,"=",{"$f":"ROUND(F77*(F82/F83),2)","v":{"$error":"#NUM!"}}]
[]
[]
["5. Zuschlag zur Berücksichtigung von Einliegerwohnungen (ELW) (RW5)\n(nur am Gebäudewertanteil)"]
["Zwischenergebnis [RW4(Geb)]:",null,null,null,null,{"$f":"F85","v":{"$error":"#NUM!"}}]
["FELW:",{"$f":"IF(F90=1,\"\",IF(F90=1.05,\"[ bei ELW zu max. 1/3 der WF der Hauptwohnung:]\",IF(F90=1.07,\"[ bei ELW über 1/3 bis zu 2/3 der WF der Hauptwohnung)\")))","v":""},null,null," x",{"$f":"ROUND(EingabeMaske!D32,2)","v":1}]
[]
["Zwischenergebnis [RW5(Geb)]:",null,null,null,"=",{"$f":"ROUND(F85*F90,2)","v":{"$error":"#NUM!"}}]
[]
[]
["6. Berücksichtigung der veränderten Wertverhältnisse zwischen dem Richtwertstichtag und dem Wertermittlungsstichtag (RW6)"]
["Zwischenergebnis [RW5(Geb)]:",null,null,null,null,{"$f":"F92","v":{"$error":"#NUM!"}}]
["Zwischenergebnis [RW1(BW)]:",null,null,null,"+",{"$f":"F64","v":{"$error":"#NUM!"}}]
["Gesamtwert [RW1(BW) + RW5(Geb)]",null,null,null,"=",{"$f":"ROUND(F96+F97,2)","v":{"$error":"#NUM!"}}]
["UK Wertermittlungsstichtag (Index):",null,null,null," x",{"$f":"EingabeMaske!D17","v":0}]
["UK Richtwertstichtag (Index):",null,null,null," /",{"$f":"EingabeMaske!M16","v":0}]
["Zwischenergebnis (RW6): ",null,null,null,null,{"$f":"ROUND(F98*F99/F100,2)","v":{"$error":"#NUM!"}}]
[]
[]
["7. Zuschläge für Außenanlagen (z.B. Erschließung/Befestigung) und Nebengebäude (z.B. Stellplätze, Garagen und Carports)\n(Zeitwerte)"]
["Zwischenergebnis (RW6): ",null,null,null,null,{"$f":"F101","v":{"$error":"#NUM!"}}]
["bauliche und nichtbauliche Außenanlagen (€/m² Wohnfläche)",{"$f":"\"[ \"&EingabeMaske!D28&\" €/m²  / \"&F14&\" m² ]\"","v":{"$error":"#NUM!"}},null,null,"+",{"$f":"ROUND(F20/F14,2)","v":{"$error":"#NUM!"}}]
["untergeordnete Nebengebäude (€/m² Wohnfläche)",{"$f":"\"[ \"&EingabeMaske!D29&\" €/m² / \"&F14&\" m² ]\"","v":"[ 0 €/m² / 145 m² ]"},null,null,"+",{"$f":"ROUND(F21/F14,2)","v":0}]
[]
["Zwischenergebnis (RW7):",null,null,null,"=",{"$f":"ROUND(F105+F106+F107,2)","v":{"$error":"#NUM!"}}]
[]
["Wohnfäche",null,null,null,"x",{"$f":"F14","v":145}]
[]
["vorläufiger Vergleichswert (vVW) ",null,null,null,"=",{"$f":"ROUND(F109*F111,2)","v":{"$error":"#NUM!"}}]
[]
["8. Berücksichtigung der restlichen Fläche des Grundstücks"]
[]
[{"$f":"IF(B117=0,\"\",LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!I2:I4))","v":""},{"$f":"F11-F42","v":0},"x",{"$f":"F18","v":300},"=",{"$f":"ROUND(B117*D117,2)","v":0}]
[{"$f":"IF(B117=0,\"\",LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!J2:J4))","v":""},{"$f":"IF(EingabeMaske!D27=0,\"\",IF((F118>0.3)*(B117>0),\"[ UK WO bei \"&B117&\" m²: \"&ROUND(LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!L2:L4),2)&\" / UK BRW bei \" &F19&\" m²: \"&ROUND(LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!F2:F4),2)&\" ]\",\"\"))","v":""},null,null,"x",{"$f":"ROUND(LOOKUP(EingabeMaske!A20,Bewertungsgrundstück,'Werte 2'!M2:M4),2)","v":0}]
[{"$f":"IF(EingabeMaske!D27=0,\"\",IF(F118>0.3,\"(Die Umrechnungskoeffizienten zur Grundstücksgrößenanpassung wurden anhand der Formel des OGA ermittelt und können geringfügig von der Tabelle des Landesgrundstücksmarktberichts 2017 abweichen.)\",\"\"))","v":""},null,null,null,"=",{"$f":"ROUND(F117*F118,2)","v":0}]
[null,null,null,null,"+",{"$f":"F113","v":{"$error":"#NUM!"}}]
["Vergleichswert (VW) ",null,null,null,"=",{"$f":"ROUND(F113+F119,2)","v":{"$error":"#NUM!"}}]
[]
[]
[{"$f":"IF((F11*F18+20000)>=F121,\"Der vorläufige Vergleichswert ist kleiner/gleich dem Bodenwert (unter der Fiktion unbebaut). Eingaben bitte auf Plausibiltät (insbesondere zur RND) überprüfen!\",\"\")","v":{"$error":"#NUM!"}}]
[]
["Vergleichswert (gerundet)",null,null,{"$f":"ROUND(F121,-3)","v":{"$error":"#NUM!"}}]
[]
[]
[]
[{"$f":"EingabeMaske!A36","v":"     Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2021"}]

{"sheet":"Vergleichsdaten 2021","index":2,"n_rows":171,"n_cols":10,"rows_kept":171,"cut":false,"hidden":true,"merged":[]}
["     Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2021",null,null,null,"EFH-Rechner, Version 2.2 - 2021"]
[]
[]
[]
["Berücksichtigung der Wertverhältnisse zwischen dem Richtwertstichtag und dem Wertermittlungsstichtag"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2023,{"$f":"(G7-G8)*$B$15/365+G8","v":152},"2022-01-01","2022-12-31",152,{"$f":"ROUND(IF(YEAR($B$6)+1=C7,D7,0),2)","v":0}]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2022,152,"2021-01-01","2021-12-31",152,{"$f":"ROUND(IF(YEAR($B$6)+1=C8,D8,0),2)","v":0}]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2021,{"$f":"(G9-G10)*$B$15/365+G10","v":142.02739726027397},"2020-01-01","2020-12-31",152,142.03]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2020,133.02465753424659,"2019-01-01","2019-12-31",142,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2019,{"$f":"(G11-G12)*$B$15/365+G12","v":125.02191780821917},"2018-01-01","2018-12-31",133,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2018,118.01917808219179,"2017-01-01","2017-12-31",125,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2017,112.01643835616439,"2016-01-01","2016-12-31",118,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2016,109.00821917808219,"2015-01-01","2015-12-31",112,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2015,108.0027397260274,"2014-01-01","2014-12-31",109,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2014,106.0054794520548,"2013-01-01","2013-12-31",108,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2013,104.0054794520548,"2012-01-01","2012-12-31",106,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2012,101.00821917808219,"2011-01-01","2011-12-31",104,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H24)","v":142.03}]
[]
[]
[null,"Bei Indexfortschreibung muss in folgenden Feldern der anderen Tabellenblätter eine Anpassung erfolgen:"]
[null,"EingabeMaske, Kommentare in E9 und E10 sowie Formel in Feld A 10"]
[null,"Berechnung und Ergebnis, Formeln in Feld C75 und Feld D 75"]
[]
[]
["Marktsegment 1"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2023,{"$f":"(G35-G36)*$B$15/365+G36","v":140},"2022-01-01","2022-12-31",140,{"$f":"ROUND(IF(YEAR($B$6)+1=C35,D35,0),2)","v":0}]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2022,140,"2021-01-01","2021-12-31",140,{"$f":"ROUND(IF(YEAR($B$6)+1=C36,D36,0),2)","v":0}]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2021,{"$f":"(G37-G38)*$B$15/365+G38","v":133.01917808219179},"2020-01-01","2020-12-31",140,{"$f":"ROUND(IF(YEAR($B$6)+1=C37,D37,0),2)","v":133.02000000000001}]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2020,{"$f":"(G38-G39)*$B$15/365+G39","v":123.02739726027397},"2019-01-01","2019-12-31",133,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2019,{"$f":"(G39-G40)*$B$15/365+G40","v":116.01917808219179},"2018-01-01","2018-12-31",123,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2018,{"$f":"(G40-G41)*$B$15/365+G41","v":109.01917808219179},"2017-01-01","2017-12-31",116,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2017,105.01095890410959,"2016-01-01","2016-12-31",109,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2016,101.01095890410959,"2015-01-01","2015-12-31",105,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2015,100.0027397260274,"2014-01-01","2014-12-31",101,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2014,100,"2013-01-01","2013-12-31",100,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2013,100,"2012-01-01","2012-12-31",100,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2012,99.0027397260274,"2011-01-01","2011-12-31",100,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2011,99.9972602739726,"2010-01-01","2010-12-31",99,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B34-DATE(YEAR(B34)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H35:H52)","v":133.02000000000001},{"$f":"IF(EingabeMaske!M$14=1,H53,0)","v":0},{"$f":"IF(EingabeMaske!M$14=1,G38,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B34","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 2"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2023,{"$f":"(G58-G59)*$B$15/365+G59","v":144},"2022-01-01","2022-12-31",144,{"$f":"ROUND(IF(YEAR($B$6)+1=C58,D58,0),2)","v":0}]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2022,144,"2021-01-01","2021-12-31",144,{"$f":"ROUND(IF(YEAR($B$6)+1=C59,D59,0),2)","v":0}]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2021,{"$f":"(G60-G61)*$B$15/365+G61","v":136.02191780821917},"2020-01-01","2020-12-31",144,{"$f":"ROUND(IF(YEAR($B$6)+1=C60,D60,0),2)","v":136.02000000000001}]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2020,{"$f":"(G61-G62)*$B$15/365+G62","v":129.01917808219179},"2019-01-01","2019-12-31",136,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2019,{"$f":"(G62-G63)*$B$15/365+G63","v":123.01643835616439},"2018-01-01","2018-12-31",129,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2018,{"$f":"(G63-G64)*$B$15/365+G64","v":117.01643835616439},"2017-01-01","2017-12-31",123,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2017,112.01369863013699,"2016-01-01","2016-12-31",117,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2016,108.01095890410959,"2015-01-01","2015-12-31",112,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2015,105.00821917808219,"2014-01-01","2014-12-31",108,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2014,104.0027397260274,"2013-01-01","2013-12-31",105,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2013,103.0027397260274,"2012-01-01","2012-12-31",104,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2012,101.0054794520548,"2011-01-01","2011-12-31",103,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B57-DATE(YEAR(B57)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H58:H75)","v":136.02000000000001},{"$f":"IF(EingabeMaske!M$14=2,H76,0)","v":0},{"$f":"IF(EingabeMaske!M$14=2,G61,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B57","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 3"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2023,{"$f":"(G81-G82)*$B$15/365+G82","v":161},"2022-01-01","2022-12-31",161,{"$f":"ROUND(IF(YEAR($B$6)+1=C81,D81,0),2)","v":0}]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2022,161,"2021-01-01","2021-12-31",161,{"$f":"ROUND(IF(YEAR($B$6)+1=C82,D82,0),2)","v":0}]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2021,{"$f":"(G83-G84)*$B$15/365+G84","v":149.03287671232877},"2020-01-01","2020-12-31",161,{"$f":"ROUND(IF(YEAR($B$6)+1=C83,D83,0),2)","v":149.03}]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2020,{"$f":"(G84-G85)*$B$15/365+G85","v":140.02465753424659},"2019-01-01","2019-12-31",149,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2019,{"$f":"(G85-G86)*$B$15/365+G86","v":130.02739726027397},"2018-01-01","2018-12-31",140,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2018,{"$f":"(G86-G87)*$B$15/365+G87","v":121.02465753424657},"2017-01-01","2017-12-31",130,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2017,114.01917808219179,"2016-01-01","2016-12-31",121,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2016,111.00821917808219,"2015-01-01","2015-12-31",114,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2015,109.0054794520548,"2014-01-01","2014-12-31",111,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2014,107.0054794520548,"2013-01-01","2013-12-31",109,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2013,104.00821917808219,"2012-01-01","2012-12-31",107,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2012,102.0054794520548,"2011-01-01","2011-12-31",104,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B80-DATE(YEAR(B80)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H81:H98)","v":149.03},{"$f":"IF(EingabeMaske!M$14=3,H99,0)","v":0},{"$f":"IF(EingabeMaske!M$14=3,G84,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B80","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 4"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2023,{"$f":"(G104-G105)*$B$15/365+G105","v":164},"2022-01-01","2022-12-31",164,{"$f":"ROUND(IF(YEAR($B$6)+1=C104,D104,0),2)","v":0}]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2022,164,"2021-01-01","2021-12-31",164,{"$f":"ROUND(IF(YEAR($B$6)+1=C105,D105,0),2)","v":0}]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2021,{"$f":"(G106-G107)*$B$15/365+G107","v":158.01643835616437},"2020-01-01","2020-12-31",164,{"$f":"ROUND(IF(YEAR($B$6)+1=C106,D106,0),2)","v":158.02000000000001}]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2020,{"$f":"(G107-G108)*$B$15/365+G108","v":152.01643835616437},"2019-01-01","2019-12-31",158,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2019,{"$f":"(G108-G109)*$B$15/365+G109","v":142.02739726027397},"2018-01-01","2018-12-31",152,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2018,{"$f":"(G109-G110)*$B$15/365+G110","v":130.03287671232877},"2017-01-01","2017-12-31",142,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2017,121.02465753424657,"2016-01-01","2016-12-31",130,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2016,114.01917808219179,"2015-01-01","2015-12-31",121,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2015,110.01095890410959,"2014-01-01","2014-12-31",114,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2014,106.01095890410959,"2013-01-01","2013-12-31",110,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2013,105.0027397260274,"2012-01-01","2012-12-31",106,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2012,102.00821917808219,"2011-01-01","2011-12-31",105,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B103-DATE(YEAR(B103)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H104:H121)","v":158.02000000000001},{"$f":"IF(EingabeMaske!M$14=4,H122,0)","v":0},{"$f":"IF(EingabeMaske!M$14=4,G107,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B103","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 5"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2023,{"$f":"(G127-G128)*$B$15/365+G128","v":191},"2022-01-01","2022-12-31",191,{"$f":"ROUND(IF(YEAR($B$6)+1=C127,D127,0),2)","v":0}]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2022,191,"2021-01-01","2021-12-31",191,{"$f":"ROUND(IF(YEAR($B$6)+1=C128,D128,0),2)","v":0}]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2021,{"$f":"(G129-G130)*$B$15/365+G130","v":181.02739726027397},"2020-01-01","2020-12-31",191,{"$f":"ROUND(IF(YEAR($B$6)+1=C129,D129,0),2)","v":181.03}]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2020,{"$f":"(G130-G131)*$B$15/365+G131","v":168.03561643835616},"2019-01-01","2019-12-31",181,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2019,{"$f":"(G131-G132)*$B$15/365+G132","v":156.03287671232877},"2018-01-01","2018-12-31",168,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2018,{"$f":"(G132-G133)*$B$15/365+G133","v":143.03561643835616},"2017-01-01","2017-12-31",156,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2017,133.02739726027397,"2016-01-01","2016-12-31",143,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2016,124.02465753424657,"2015-01-01","2015-12-31",133,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2015,119.01369863013699,"2014-01-01","2014-12-31",124,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2014,114.01369863013699,"2013-01-01","2013-12-31",119,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2013,109.01369863013699,"2012-01-01","2012-12-31",114,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2012,104.01369863013699,"2011-01-01","2011-12-31",109,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2011,100.01095890410959,"2010-01-01","2010-12-31",104,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B126-DATE(YEAR(B126)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H127:H144)","v":181.03},{"$f":"IF(EingabeMaske!M$14=5,H145,0)","v":0},{"$f":"IF(EingabeMaske!M$14=5,G130,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B126","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 6"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2023,{"$f":"(G150-G151)*$B$15/365+G151","v":197},"2022-01-01","2022-12-31",197,{"$f":"ROUND(IF(YEAR($B$6)+1=C150,D150,0),2)","v":0}]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2022,197,"2021-01-01","2021-12-31",197,{"$f":"ROUND(IF(YEAR($B$6)+1=C151,D151,0),2)","v":0}]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2021,{"$f":"(G152-G153)*$B$15/365+G153","v":183.03835616438357},"2020-01-01","2020-12-31",197,{"$f":"ROUND(IF(YEAR($B$6)+1=C152,D152,0),2)","v":183.04}]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2020,{"$f":"(G153-G154)*$B$15/365+G154","v":172.03013698630136},"2019-01-01","2019-12-31",183,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2019,{"$f":"(G154-G155)*$B$15/365+G155","v":160.03287671232877},"2018-01-01","2018-12-31",172,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2018,{"$f":"(G155-G156)*$B$15/365+G156","v":148.03287671232877},"2017-01-01","2017-12-31",160,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2017,135.03561643835616,"2016-01-01","2016-12-31",148,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2016,127.02191780821917,"2015-01-01","2015-12-31",135,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2015,120.01917808219179,"2014-01-01","2014-12-31",127,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2014,113.01917808219179,"2013-01-01","2013-12-31",120,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2013,106.01917808219179,"2012-01-01","2012-12-31",113,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2012,101.01369863013699,"2011-01-01","2011-12-31",106,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B149-DATE(YEAR(B149)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H150:H167)","v":183.04},{"$f":"IF(EingabeMaske!M$14=6,H168,0)","v":0},{"$f":"IF(EingabeMaske!M$14=6,G153,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B149","v":"2020-01-01"},"2020-01-01"]
[]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(I53+I76+I99+I122+I145+I168,0)","v":0},{"$f":"ROUND(J53+J76+J99+J122+J145+J168,0)","v":0}]

{"sheet":"Vergleichsdaten 2022","index":3,"n_rows":297,"n_cols":11,"rows_kept":297,"cut":false,"hidden":true,"merged":[]}
[{"$f":"EingabeMaske!A36","v":"     Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2021"},null,null,null,{"$f":"EingabeMaske!D1","v":"EFH-Rechner, Version 1 - 2023"}]
[]
["Wohnfläche",145]
["Gebäudesachwert ohne Außenanlagen und"]
["Nebengebäude zum Stichtag 1.1.2020",{"$f":"B3*EingabeMaske!M17/B12","v":{"$error":"#DIV/0!"}},null,{"$f":"B5*J37","v":{"$error":"#DIV/0!"}}]
["Gebäudestandard",3]
["Gesamtnutzungsdauer (GND)",70]
["Restnutzungsdauer (RND)",55]
["Zeitwert der Außen- und Nebenanlagen",0]
["Zeitwert der Außen- und Nebenanlagen",0]
["Grundstücksgröße",500]
["Sachwertfaktor (freistehend)",{"$f":"ROUND(VLOOKUP(EingabeMaske!B13,'Vergleichsfaktoren 2021 (2)'!A8:I3023,9,FALSE),2)","v":0}]
[]
["1) Die Alterswertminderung des Herstellungswertes des Gebäudes ist bereits im Gebäudesachwert enthalten."]
[]
[null,"WO",null,null,null,null,null,null,"Richtwert"]
["Objektart","EFH / ZFH",null,null,null,null,null,null,{"$f":"B17","v":"EFH / ZFH"}]
["Bodenwertniveau",{"$f":"EingabeMaske!D26","v":300},40,70,120,210,210,430,{"$f":"EingabeMaske!M26","v":0}]
["vorläufiger Sachwert",{"$f":"'Berechnung und Ergebnis'!F54*'Berechnung und Ergebnis'!F14","v":{"$error":"#NUM!"}},{"$f":"$B19","v":{"$error":"#NUM!"}},{"$f":"$B19","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"EingabeMaske!M17/B12*J37*B3","v":{"$error":"#DIV/0!"}}]
["Stichtag","2020-01-01","2020-01-01","2020-01-01","2020-01-01","2020-01-01","2020-01-01","2020-01-01",{"$f":"B20","v":"2020-01-01"}]
["Stichtag als Zahl",{"$f":"B20","v":43831},43831,43831,43831,43831,43831,43831,43831]
[]
["Marktsegment",{"$f":"EingabeMaske!M14","v":0},1,2,3,4,5,6,0]
["a",{"$f":"IF(B$23=C$23,C24,IF(B$23=D$23,D24,IF(B$23=E$23,E24,IF(B$23=F$23,F24,IF(B$23=G$23,G24,IF(B$23=H$23,H24))))))","v":false},0.98918899999999998,0.36445100000000002,0.47468500000000002,0.23200499999999999,0.23200499999999999,1.1272660000000001,false]
["b",{"$f":"IF(B$23=C$23,C25,IF(B$23=D$23,D25,IF(B$23=E$23,E25,IF(B$23=F$23,F25,IF(B$23=G$23,G25,IF(B$23=H$23,H25))))))","v":false},9.3283000000000005E-2,9.5379000000000005E-2,6.5542000000000003E-2,0.12125900000000001,0.12125900000000001,7.5494000000000006E-2,false]
["c",{"$f":"IF(B$23=C$23,C26,IF(B$23=D$23,D26,IF(B$23=E$23,E26,IF(B$23=F$23,F26,IF(B$23=G$23,G26,IF(B$23=H$23,H26))))))","v":false},-0.219502,-0.22378200000000001,-0.27983400000000003,-0.21038499999999999,-0.21038499999999999,-0.272897,false]
["d",{"$f":"IF(B$23=C$23,C27,IF(B$23=D$23,D27,IF(B$23=E$23,E27,IF(B$23=F$23,F27,IF(B$23=G$23,G27,IF(B$23=H$23,H27))))))","v":false},{"$f":"5.0203*10^-5","v":5.0203E-5},{"$f":"7.5872*10^-5","v":7.5872000000000008E-5},{"$f":"9.13511*10^-5","v":9.1351099999999993E-5},{"$f":"8.25108*10^-5","v":8.251080000000001E-5},{"$f":"8.25108*10^-5","v":8.251080000000001E-5},{"$f":"7.35282*10^-5","v":7.3528200000000005E-5},false]
["e",{"$f":"IF(B$23=C$23,C28,IF(B$23=D$23,D28,IF(B$23=E$23,E28,IF(B$23=F$23,F28,IF(B$23=G$23,G28,IF(B$23=H$23,H28))))))","v":false},2.7182818283999999,2.7182818283999999,2.7182818283999999,2.7182818283999999,2.7182818283999999,2.7182818283999999,false]
[]
["Sachwertfaktor",{"$f":"B24*B18^B25*B19^B26*B28^(B27*B21)","v":{"$error":"#NUM!"}},{"$f":"C24*C18^C25*C19^C26*C28^(C27*C21)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"I24*I18^I25*I19^I26*I28^(I27*I21)","v":{"$error":"#NUM!"}}]
["gerundet auf 2 Stellen",{"$f":"ROUND(B30,2)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
["Doppelhaushäfte / Reihenendhaus",{"$f":"ROUND((10.7016*B18^0.1647*B19^-0.2522)-(9.8596*B18^0.1844*B19^-0.2537),2)","v":{"$error":"#NUM!"}},0.94,null,null,null,null,"Doppelhaushäfte / Reihenendhaus",{"$f":"ROUND((10.7016*I18^0.1647*I19^-0.2522)-(9.8596*I18^0.1844*I19^-0.2537),2)","v":{"$error":"#DIV/0!"}},0.94,"(Faktor DHH)"]
[null,{"$f":"B31+B33","v":{"$error":"#NUM!"}},null,null,null,null,null,null,{"$f":"I31+I33","v":{"$error":"#NUM!"}}]
["Reihenmittelhaus",{"$f":"ROUND((16.6179*B18^0.284*B19^-0.334)-(9.8596*B18^0.1844*B19^-0.2537),2)","v":{"$error":"#NUM!"}},0.88,null,null,null,null,"Reihenmittelhaus",{"$f":"ROUND((16.6179*I18^0.284*I19^-0.334)-(9.8596*I18^0.1844*I19^-0.2537),2)","v":{"$error":"#DIV/0!"}},0.88,"(Faktor RMH)"]
[null,{"$f":"B31+B35","v":{"$error":"#NUM!"}},null,null,null,null,null,null,{"$f":"I31+I35","v":{"$error":"#NUM!"}}]
["Haustyp",{"$f":"IF(EingabeMaske!D18='Vergleichsdaten 2022'!A33,B33,IF(EingabeMaske!D18='Vergleichsdaten 2022'!A35,B35,0))","v":0},{"$f":"ROUND(IF(EingabeMaske!D18='Vergleichsdaten 2022'!A33,'Vergleichsdaten 2022'!C33,IF(EingabeMaske!D18='Vergleichsdaten 2022'!A35,'Vergleichsdaten 2022'!C35,1)),2)","v":1},null,null,null,null,"Haustyp",{"$f":"IF(EingabeMaske!D18='Vergleichsdaten 2022'!H33,I33,IF(EingabeMaske!D18='Vergleichsdaten 2022'!H35,I35,0))","v":0},{"$f":"ROUND(IF(EingabeMaske!D18='Vergleichsdaten 2022'!H33,'Vergleichsdaten 2022'!J33,IF(EingabeMaske!D18='Vergleichsdaten 2022'!H35,'Vergleichsdaten 2022'!J35,1)),2)","v":1}]
[null,{"$f":"B37+B31","v":{"$error":"#NUM!"}},null,null,null,null,null,null,{"$f":"I37+I31","v":{"$error":"#NUM!"}},"SWF bei ",{"$f":"EingabeMaske!D18","v":"freistehend"}]
[]
[]
[]
["Umrechnungskoeffizienten Gebäudestandard (UKGS)"]
[]
[null,"GS-Stufe",1,2,3,4,5]
[null,"UKGS",1,1.111,1.276,1.5389999999999999,1.925]
[null,"Kontrolle",{"$f":"$C$48+$C$49*C44+$C$50*C44^2+$C$51*C44^3+$C$52*C44^4","v":1.0000000000000002},{"$f":"$C$48+$C$49*D44+$C$50*D44^2+$C$51*D44^3+$C$52*D44^4","v":1.11099996},{"$f":"$C$48+$C$49*E44+$C$50*E44^2+$C$51*E44^3+$C$52*E44^4","v":1.2759997600000001},{"$f":"$C$48+$C$49*F44+$C$50*F44^2+$C$51*F44^3+$C$52*F44^4","v":1.5389992000000001},{"$f":"$C$48+$C$49*G44+$C$50*G44^2+$C$51*G44^3+$C$52*G44^4","v":1.924998}]
[]
["UKGS=a+b*GS+c*GS²+d*GS³+e*GS4","a=",0.88]
[null,"b=",0.15024999999999999]
[null,"c=",-4.4708329999999998E-2]
[null,"d=",1.525E-2]
[null,"e=",-7.9166999999999996E-4]
[]
[]
[null,null,3,{"$f":"EingabeMaske!D21","v":3}]
[]
[]
[null,null,{"$f":"C48+C49*C55+C50*C55^2+C51*C55^3+C52*C55^4","v":1.2759997600000001},{"$f":"C48+C49*C55+C50*C55^2+C51*C55^3+C52*C55^4","v":1.2759997600000001}]
[]
[]
[]
[]
[]
[]
["Alterswertminderung"]
[]
["RW = a*RND(%)² + b*RND(%)"]
[]
[]
[null,"a=",-0.1977725722]
[null,"b=",1.1973121607999999]
[]
[]
[]
[]
["Umrechnungskoeffizienten Wohnfläche"]
[null,null,null,null,"WF","UKWF","Kontrolle"]
["UKWF = a*ln(WF) + b",null,null,null,50,1.2806696527899999,{"$f":"$C$80*LN(E78)+$C$81","v":1.2806696528727608}]
[null,null,null,null,60,1.23260765223,{"$f":"$C$80*LN(E79)+$C$81","v":1.232607652310959}]
[null,"a=",-0.26361117909999998,null,70,1.1919718097600001,1.1919718098426286]
[null,"b=",2.3119226500000001,null,80,1.1567714418999999,1.1567714419860133]
[null,null,null,null,90,1.12572251699,1.1257225170786567]
[null,null,null,null,100,1.09794830723,1.097948307315513]
[null,null,null,null,110,1.0728234783499999,1.0728234784370618]
[null,null,null,null,120,1.0498863066599999,1.0498863067537112]
[null,null,null,null,130,1.0287861541100001,1.0287861542055337]
[null,null,null,null,140,1.00925046419,1.009250464285381]
[null,null,null,null,145,1,1.000000000093757]
[null,null,null,null,150,0.99106317199000005,0.99106317208321104]
[null,null,null,null,160,0.97405009632999995,0.9740500964287655]
[null,null,null,null,170,0.95806876828999998,0.95806876838924349]
[null,null,null,null,180,0.94300117142999995,0.94300117152140883]
[null,null,null,null,190,0.92874844747999996,0.92874844757169095]
[null,null,null,null,200,0.91522696165999995,0.91522696175826534]
[null,null,null,null,210,0.90236532895999999,0.90236532905307887]
[null,null,null,null,220,0.89010213278000005,0.89010213287981421]
[null,null,null,null,230,0.87838415124000002,0.87838415133544334]
[null,null,null,null,240,0.86716496109999996,0.86716496119646336]
[null,null,null,null,250,0.85640382698999995,0.85640382708776519]
[null,null,null,null,260,0.84606480854999999,0.84606480864828582]
[null,null,null,null,270,0.83611603618999997,0.83611603628910669]
[null,null,null,null,280,0.82652911863,0.82652911872813339]
[null,null,null,null,290,0.81727865444000003,0.81727865453650916]
[null,null,null,null,300,0.80834182642999997,0.8083418265259632]
[]
[]
[]
["Marktanpassung SMK"]
[]
["kSMK=a*BW+b"]
[]
[null,"a=",-5.1660360000000002E-4,null,"BW","kSMK"]
[null,"b=",1.0080835560000001,null,20,1]
[null,null,null,null,50,0.98]
[null,null,null,null,100,0.96]
[null,null,null,null,150,0.93]
[null,null,null,null,200,0.9]
[null,null,null,null,250,0.88]
[null,null,null,null,300,0.85]
[null,null,null,null,350,0.83]
[null,null,null,null,400,0.8]
[null,null,null,null,450,0.78]
[null,null,null,null,500,0.75]
[null,null,null,null,550,0.72]
[null,null,null,null,600,0.7]
[]
[]
[]
[]
[]
["Berücksichtigung der Wertverhältnisse zwischen dem Richtwertstichtag und dem Wertermittlungsstichtag"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2023,{"$f":"(G133-G134)*$B$141/365+G134","v":177},"2022-01-01","2022-12-31",177,{"$f":"ROUND(IF(YEAR($B$132)+1=C133,D133,0),2)","v":0}]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2022,161.04383561643834,"2021-01-01","2021-12-31",177,{"$f":"ROUND(IF(YEAR($B$132)+1=C134,D134,0),2)","v":0}]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2021,{"$f":"(G135-G136)*$B$141/365+G136","v":146.04109589041096},"2020-01-01","2020-12-31",161,146.04]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2020,134.03287671232877,"2019-01-01","2019-12-31",146,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2019,{"$f":"(G137-G138)*$B$141/365+G138","v":125.02465753424657},"2018-01-01","2018-12-31",134,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2018,118.01917808219179,"2017-01-01","2017-12-31",125,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2017,112.01643835616439,"2016-01-01","2016-12-31",118,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2016,109.00821917808219,"2015-01-01","2015-12-31",112,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2015,108.0027397260274,"2014-01-01","2014-12-31",109,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2014,106.0054794520548,"2013-01-01","2013-12-31",108,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2013,104.0054794520548,"2012-01-01","2012-12-31",106,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2012,101.00821917808219,"2011-01-01","2011-12-31",104,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B132-DATE(YEAR(B132)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H133:H150)","v":146.04}]
[]
[]
[null,"Bei Indexfortschreibung muss in folgenden Feldern der anderen Tabellenblätter eine Anpassung erfolgen:"]
[null,"EingabeMaske, Kommentare in E9 und E10 sowie Formel in Feld A 10"]
[null,"Berechnung und Ergebnis, Formeln in Feld C75 und Feld D 75"]
[]
[]
["Marktsegment 1"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2023,{"$f":"(G161-G162)*$B$141/365+G162","v":164},"2022-01-01","2022-12-31",164,{"$f":"ROUND(IF(YEAR($B$132)+1=C161,D161,0),2)","v":0}]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2022,151.03561643835616,"2021-01-01","2021-12-31",164,{"$f":"ROUND(IF(YEAR($B$132)+1=C162,D162,0),2)","v":0}]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2021,{"$f":"(G163-G164)*$B$141/365+G164","v":138.03561643835616},"2020-01-01","2020-12-31",151,{"$f":"ROUND(IF(YEAR($B$132)+1=C163,D163,0),2)","v":138.04}]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2020,{"$f":"(G164-G165)*$B$141/365+G165","v":125.03561643835616},"2019-01-01","2019-12-31",138,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2019,{"$f":"(G165-G166)*$B$141/365+G166","v":116.02465753424657},"2018-01-01","2018-12-31",125,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2018,{"$f":"(G166-G167)*$B$141/365+G167","v":109.01917808219179},"2017-01-01","2017-12-31",116,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2017,105.01095890410959,"2016-01-01","2016-12-31",109,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2016,101.01095890410959,"2015-01-01","2015-12-31",105,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2015,100.0027397260274,"2014-01-01","2014-12-31",101,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2014,100,"2013-01-01","2013-12-31",100,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2013,100,"2012-01-01","2012-12-31",100,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2012,99.0027397260274,"2011-01-01","2011-12-31",100,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2011,99.9972602739726,"2010-01-01","2010-12-31",99,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B160-DATE(YEAR(B160)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H161:H178)","v":138.04},{"$f":"IF(EingabeMaske!M$14=1,H179,0)","v":0},{"$f":"IF(EingabeMaske!M$14=1,G164,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B160","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 2"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2023,{"$f":"(G184-G185)*$B$141/365+G185","v":169},"2022-01-01","2022-12-31",169,{"$f":"ROUND(IF(YEAR($B$132)+1=C184,D184,0),2)","v":0}]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2022,156.03561643835616,"2021-01-01","2021-12-31",169,{"$f":"ROUND(IF(YEAR($B$132)+1=C185,D185,0),2)","v":0}]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2021,{"$f":"(G186-G187)*$B$141/365+G187","v":143.03561643835616},"2020-01-01","2020-12-31",156,{"$f":"ROUND(IF(YEAR($B$132)+1=C186,D186,0),2)","v":143.04}]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2020,{"$f":"(G187-G188)*$B$141/365+G188","v":132.03013698630136},"2019-01-01","2019-12-31",143,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2019,{"$f":"(G188-G189)*$B$141/365+G189","v":123.02465753424657},"2018-01-01","2018-12-31",132,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2018,{"$f":"(G189-G190)*$B$141/365+G190","v":117.01643835616439},"2017-01-01","2017-12-31",123,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2017,112.01369863013699,"2016-01-01","2016-12-31",117,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2016,108.01095890410959,"2015-01-01","2015-12-31",112,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2015,105.00821917808219,"2014-01-01","2014-12-31",108,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2014,104.0027397260274,"2013-01-01","2013-12-31",105,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2013,103.0027397260274,"2012-01-01","2012-12-31",104,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2012,101.0054794520548,"2011-01-01","2011-12-31",103,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B183-DATE(YEAR(B183)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H184:H201)","v":143.04},{"$f":"IF(EingabeMaske!M$14=2,H202,0)","v":0},{"$f":"IF(EingabeMaske!M$14=2,G187,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B183","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 3"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2023,{"$f":"(G207-G208)*$B$141/365+G208","v":189},"2022-01-01","2022-12-31",189,{"$f":"ROUND(IF(YEAR($B$132)+1=C207,D207,0),2)","v":0}]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2022,172.04657534246576,"2021-01-01","2021-12-31",189,{"$f":"ROUND(IF(YEAR($B$132)+1=C208,D208,0),2)","v":0}]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2021,{"$f":"(G209-G210)*$B$141/365+G210","v":155.04657534246576},"2020-01-01","2020-12-31",172,{"$f":"ROUND(IF(YEAR($B$132)+1=C209,D209,0),2)","v":155.05000000000001}]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2020,{"$f":"(G210-G211)*$B$141/365+G211","v":141.03835616438357},"2019-01-01","2019-12-31",155,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2019,{"$f":"(G211-G212)*$B$141/365+G212","v":130.03013698630136},"2018-01-01","2018-12-31",141,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2018,{"$f":"(G212-G213)*$B$141/365+G213","v":121.02465753424657},"2017-01-01","2017-12-31",130,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2017,114.01917808219179,"2016-01-01","2016-12-31",121,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2016,111.00821917808219,"2015-01-01","2015-12-31",114,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2015,109.0054794520548,"2014-01-01","2014-12-31",111,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2014,107.0054794520548,"2013-01-01","2013-12-31",109,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2013,104.00821917808219,"2012-01-01","2012-12-31",107,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2012,102.0054794520548,"2011-01-01","2011-12-31",104,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B206-DATE(YEAR(B206)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H207:H224)","v":155.05000000000001},{"$f":"IF(EingabeMaske!M$14=3,H225,0)","v":0},{"$f":"IF(EingabeMaske!M$14=3,G210,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B206","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 4"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2023,{"$f":"(G230-G231)*$B$141/365+G231","v":211},"2022-01-01","2022-12-31",211,{"$f":"ROUND(IF(YEAR($B$132)+1=C230,D230,0),2)","v":0}]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2022,189.06027397260274,"2021-01-01","2021-12-31",211,{"$f":"ROUND(IF(YEAR($B$132)+1=C231,D231,0),2)","v":0}]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2021,{"$f":"(G232-G233)*$B$141/365+G233","v":170.05205479452056},"2020-01-01","2020-12-31",189,{"$f":"ROUND(IF(YEAR($B$132)+1=C232,D232,0),2)","v":170.05}]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2020,{"$f":"(G233-G234)*$B$141/365+G234","v":155.04109589041096},"2019-01-01","2019-12-31",170,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2019,{"$f":"(G234-G235)*$B$141/365+G235","v":142.03561643835616},"2018-01-01","2018-12-31",155,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2018,{"$f":"(G235-G236)*$B$141/365+G236","v":130.03287671232877},"2017-01-01","2017-12-31",142,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2017,121.02465753424657,"2016-01-01","2016-12-31",130,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2016,114.01917808219179,"2015-01-01","2015-12-31",121,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2015,110.01095890410959,"2014-01-01","2014-12-31",114,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2014,106.01095890410959,"2013-01-01","2013-12-31",110,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2013,105.0027397260274,"2012-01-01","2012-12-31",106,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2012,102.00821917808219,"2011-01-01","2011-12-31",105,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B229-DATE(YEAR(B229)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H230:H247)","v":170.05},{"$f":"IF(EingabeMaske!M$14=4,H248,0)","v":0},{"$f":"IF(EingabeMaske!M$14=4,G233,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B229","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 5"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2023,{"$f":"(G253-G254)*$B$141/365+G254","v":229},"2022-01-01","2022-12-31",229,{"$f":"ROUND(IF(YEAR($B$132)+1=C253,D253,0),2)","v":0}]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2022,207.06027397260274,"2021-01-01","2021-12-31",229,{"$f":"ROUND(IF(YEAR($B$132)+1=C254,D254,0),2)","v":0}]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2021,{"$f":"(G255-G256)*$B$141/365+G256","v":188.05205479452056},"2020-01-01","2020-12-31",207,{"$f":"ROUND(IF(YEAR($B$132)+1=C255,D255,0),2)","v":188.05}]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2020,{"$f":"(G256-G257)*$B$141/365+G257","v":170.04931506849314},"2019-01-01","2019-12-31",188,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2019,{"$f":"(G257-G258)*$B$141/365+G258","v":156.03835616438357},"2018-01-01","2018-12-31",170,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2018,{"$f":"(G258-G259)*$B$141/365+G259","v":143.03561643835616},"2017-01-01","2017-12-31",156,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2017,133.02739726027397,"2016-01-01","2016-12-31",143,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2016,124.02465753424657,"2015-01-01","2015-12-31",133,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2015,119.01369863013699,"2014-01-01","2014-12-31",124,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2014,114.01369863013699,"2013-01-01","2013-12-31",119,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2013,109.01369863013699,"2012-01-01","2012-12-31",114,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2012,104.01369863013699,"2011-01-01","2011-12-31",109,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2011,100.01095890410959,"2010-01-01","2010-12-31",104,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B252-DATE(YEAR(B252)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H252:H270)","v":188.05},{"$f":"IF(EingabeMaske!M$14=5,H271,0)","v":0},{"$f":"IF(EingabeMaske!M$14=5,G256,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B252","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 6"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2023,{"$f":"(G276-G277)*$B$141/365+G277","v":214},"2022-01-01","2022-12-31",214,{"$f":"ROUND(IF(YEAR($B$132)+1=C276,D276,0),2)","v":0}]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2022,201.03561643835616,"2021-01-01","2021-12-31",214,{"$f":"ROUND(IF(YEAR($B$132)+1=C277,D277,0),2)","v":0}]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2021,{"$f":"(G278-G279)*$B$141/365+G279","v":187.03835616438357},"2020-01-01","2020-12-31",201,{"$f":"ROUND(IF(YEAR($B$132)+1=C278,D278,0),2)","v":187.04}]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2020,{"$f":"(G279-G280)*$B$141/365+G280","v":174.03561643835616},"2019-01-01","2019-12-31",187,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2019,{"$f":"(G280-G281)*$B$141/365+G281","v":160.03835616438357},"2018-01-01","2018-12-31",174,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2018,{"$f":"(G281-G282)*$B$141/365+G282","v":148.03287671232877},"2017-01-01","2017-12-31",160,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2017,135.03561643835616,"2016-01-01","2016-12-31",148,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2016,127.02191780821917,"2015-01-01","2015-12-31",135,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2015,120.01917808219179,"2014-01-01","2014-12-31",127,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2014,113.01917808219179,"2013-01-01","2013-12-31",120,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2013,106.01917808219179,"2012-01-01","2012-12-31",113,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2012,101.01369863013699,"2011-01-01","2011-12-31",106,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B275-DATE(YEAR(B275)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H276:H293)","v":187.04},{"$f":"IF(EingabeMaske!M$14=6,H294,0)","v":0},{"$f":"IF(EingabeMaske!M$14=6,G279,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B275","v":"2020-01-01"},"2020-01-01"]
[]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(I179+I202+I225+I248+I271+I294,0)","v":0},{"$f":"ROUND(J179+J202+J225+J248+J271+J294,0)","v":0}]

{"sheet":"Vergleichsfaktoren 2021 (2)","index":4,"n_rows":3023,"n_cols":9,"rows_kept":3023,"cut":false,"hidden":true,"merged":[]}
[null,"Vergleichsfaktoren (VF) für mit freistehenden Einfamilienwohnhäusern bebaute Grundstücke "]
[null,null,null,"Stichtag ","2020-01-01"]
[null," Modell s. LGMB 2021, Kap. 3.6.1.1 - © Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz"]
[null,"Kurzbeschreibung des Richtwertgrundstücks: Größe 500 m², mittlerer Standard, freistehend KG+EG+ausgeb. DG, Wohnfäche 145 m², Alter 15 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.","RW €/m² Wohnfl.","SWF"]
[{"$f":"TRIM(D8)&\" / \"&TRIM(C8)&\" / \"&TRIM(E8)","v":"0 / 0 / 0"},0,0,0,0,0,0,null,0]
[{"$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(D3023)&\" / \"&TRIM(C3023)&\" / \"&TRIM(E3023)","v":" /  / "}]

{"sheet":"Vergleichsdaten 2023","index":5,"n_rows":185,"n_cols":10,"rows_kept":185,"cut":false,"hidden":true,"merged":[]}
[{"$f":"EingabeMaske!A36","v":"     Quelle: Oberer Gutachterausschuss für Grundstückswerte Rheinland-Pfalz gem. Landesgrundstückmarkbericht 2021"},null,null,null,{"$f":"EingabeMaske!D1","v":"EFH-Rechner, Version 1 - 2023"}]
[]
[]
[]
["Berücksichtigung der Wertverhältnisse zwischen dem Richtwertstichtag und dem Wertermittlungsstichtag"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B$6-DATE(YEAR(B$6)-1,12,31.25)","v":1},2025,180.03287671232877,"2024-01-01","2024-12-31",192,{"$f":"ROUND(IF(YEAR($B$6)+1=C7,D7,0),2)","v":0}]
[null,{"$f":"B$6-DATE(YEAR(B$6)-1,12,31.25)","v":1},2024,192,"2023-01-01","2023-12-31",192,0]
[null,1,2023,180.03287671232877,"2022-01-01","2022-12-31",192,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2022,163.04657534246576,"2021-01-01","2021-12-31",180,{"$f":"ROUND(IF(YEAR($B$6)+1=C10,D10,0),2)","v":0}]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2021,147.04383561643834,"2020-01-01","2020-12-31",163,147.04]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2020,134.03561643835616,"2019-01-01","2019-12-31",147,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2019,125.02465753424657,"2018-01-01","2018-12-31",134,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2018,118.01917808219179,"2017-01-01","2017-12-31",125,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2017,112.01643835616439,"2016-01-01","2016-12-31",118,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2016,109.00821917808219,"2015-01-01","2015-12-31",112,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2015,108.0027397260274,"2014-01-01","2014-12-31",109,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2014,106.0054794520548,"2013-01-01","2013-12-31",108,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2013,104.0054794520548,"2012-01-01","2012-12-31",106,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2012,101.00821917808219,"2011-01-01","2011-12-31",104,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B6-DATE(YEAR(B6)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H26)","v":147.04}]
[]
[]
[null,"Bei Indexfortschreibung muss in folgenden Feldern der anderen Tabellenblätter eine Anpassung erfolgen:"]
[null,"EingabeMaske, Kommentare in E9 und E10 sowie Formel in Feld A 10"]
[null,"Berechnung und Ergebnis, Formeln in Feld C75 und Feld D 75"]
[]
[]
["Marktsegment 1"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B$36-DATE(YEAR(B$36)-1,12,31.25)","v":1},2025,173.04657534246576,"2024-01-01","2024-12-31",190,{"$f":"ROUND(IF(YEAR($B$6)+1=C37,D37,0),2)","v":0}]
[null,{"$f":"B$36-DATE(YEAR(B$36)-1,12,31.25)","v":1},2024,190,"2023-01-01","2023-12-31",190,0]
[null,1,2023,173.04657534246576,"2022-01-01","2022-12-31",190,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2022,156.04657534246576,"2021-01-01","2021-12-31",173,{"$f":"ROUND(IF(YEAR($B$6)+1=C40,D40,0),2)","v":0}]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2021,138.04931506849314,"2020-01-01","2020-12-31",156,{"$f":"ROUND(IF(YEAR($B$6)+1=C41,D41,0),2)","v":138.05000000000001}]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2020,125.03561643835616,"2019-01-01","2019-12-31",138,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2019,116.02465753424657,"2018-01-01","2018-12-31",125,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2018,109.01917808219179,"2017-01-01","2017-12-31",116,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2017,105.01095890410959,"2016-01-01","2016-12-31",109,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2016,101.01095890410959,"2015-01-01","2015-12-31",105,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2015,100.0027397260274,"2014-01-01","2014-12-31",101,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2014,100,"2013-01-01","2013-12-31",100,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2013,100,"2012-01-01","2012-12-31",100,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2012,99.0027397260274,"2011-01-01","2011-12-31",100,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2011,99.9972602739726,"2010-01-01","2010-12-31",99,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B36-DATE(YEAR(B36)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H37:H56)","v":138.05000000000001},{"$f":"IF(EingabeMaske!M$14=1,H57,0)","v":0},{"$f":"IF(EingabeMaske!N$14=1,G42,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B36","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 2"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B$61-DATE(YEAR(B$61)-1,12,31.25)","v":1},2025,175.03835616438357,"2024-01-01","2024-12-31",189,{"$f":"ROUND(IF(YEAR($B$6)+1=C62,D62,0),2)","v":0}]
[null,{"$f":"B$61-DATE(YEAR(B$61)-1,12,31.25)","v":1},2024,189,"2023-01-01","2023-12-31",189,0]
[null,1,2023,175.03835616438357,"2022-01-01","2022-12-31",189,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2022,159.04383561643834,"2021-01-01","2021-12-31",175,{"$f":"ROUND(IF(YEAR($B$6)+1=C65,D65,0),2)","v":0}]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2021,143.04383561643834,"2020-01-01","2020-12-31",159,{"$f":"ROUND(IF(YEAR($B$6)+1=C66,D66,0),2)","v":143.04}]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2020,132.03013698630136,"2019-01-01","2019-12-31",143,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2019,123.02465753424657,"2018-01-01","2018-12-31",132,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2018,117.01643835616439,"2017-01-01","2017-12-31",123,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2017,112.01369863013699,"2016-01-01","2016-12-31",117,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2016,108.01095890410959,"2015-01-01","2015-12-31",112,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2015,105.00821917808219,"2014-01-01","2014-12-31",108,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2014,104.0027397260274,"2013-01-01","2013-12-31",105,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2013,103.0027397260274,"2012-01-01","2012-12-31",104,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2012,101.0054794520548,"2011-01-01","2011-12-31",103,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B61-DATE(YEAR(B61)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H62:H81)","v":143.04},{"$f":"IF(EingabeMaske!M$14=2,H82,0)","v":0},{"$f":"IF(EingabeMaske!N$14=2,G67,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B61","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 3"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B$86-DATE(YEAR(B$86)-1,12,31.25)","v":1},2025,196.04657534246576,"2024-01-01","2024-12-31",213,{"$f":"ROUND(IF(YEAR($B$6)+1=C87,D87,0),2)","v":0}]
[null,{"$f":"B$86-DATE(YEAR(B$86)-1,12,31.25)","v":1},2024,213,"2023-01-01","2023-12-31",213,0]
[null,1,2023,196.04657534246576,"2022-01-01","2022-12-31",213,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2022,177.05205479452056,"2021-01-01","2021-12-31",196,{"$f":"ROUND(IF(YEAR($B$6)+1=C90,D90,0),2)","v":0}]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2021,156.05753424657533,"2020-01-01","2020-12-31",177,{"$f":"ROUND(IF(YEAR($B$6)+1=C91,D91,0),2)","v":156.06}]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2020,141.04109589041096,"2019-01-01","2019-12-31",156,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2019,130.03013698630136,"2018-01-01","2018-12-31",141,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2018,121.02465753424657,"2017-01-01","2017-12-31",130,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2017,114.01917808219179,"2016-01-01","2016-12-31",121,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2016,111.00821917808219,"2015-01-01","2015-12-31",114,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2015,109.0054794520548,"2014-01-01","2014-12-31",111,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2014,107.0054794520548,"2013-01-01","2013-12-31",109,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2013,104.00821917808219,"2012-01-01","2012-12-31",107,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2012,102.0054794520548,"2011-01-01","2011-12-31",104,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B86-DATE(YEAR(B86)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H87:H106)","v":156.06},{"$f":"IF(EingabeMaske!M$14=3,H107,0)","v":0},{"$f":"IF(EingabeMaske!N$14=3,G92,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B86","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 4"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B$111-DATE(YEAR(B$111)-1,12,31.25)","v":1},2025,190.05479452054794,"2024-01-01","2024-12-31",210,{"$f":"ROUND(IF(YEAR($B$6)+1=C112,D112,0),2)","v":0}]
[null,{"$f":"B$111-DATE(YEAR(B$111)-1,12,31.25)","v":1},2024,210,"2023-01-01","2023-12-31",210,0]
[null,1,2023,190.05479452054794,"2022-01-01","2022-12-31",210,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2022,170.05479452054794,"2021-01-01","2021-12-31",190,{"$f":"ROUND(IF(YEAR($B$6)+1=C115,D115,0),2)","v":0}]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2021,155.04109589041096,"2020-01-01","2020-12-31",170,{"$f":"ROUND(IF(YEAR($B$6)+1=C116,D116,0),2)","v":155.04}]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2020,152.00821917808219,"2019-01-01","2019-12-31",155,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2019,142.02739726027397,"2018-01-01","2018-12-31",152,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2018,130.03287671232877,"2017-01-01","2017-12-31",142,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2017,121.02465753424657,"2016-01-01","2016-12-31",130,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2016,114.01917808219179,"2015-01-01","2015-12-31",121,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2015,110.01095890410959,"2014-01-01","2014-12-31",114,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2014,106.01095890410959,"2013-01-01","2013-12-31",110,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2013,105.0027397260274,"2012-01-01","2012-12-31",106,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2012,102.00821917808219,"2011-01-01","2011-12-31",105,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2011,100.0054794520548,"2010-01-01","2010-12-31",102,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B111-DATE(YEAR(B111)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H112:H131)","v":155.04},{"$f":"IF(EingabeMaske!M$14=4,H132,0)","v":0},{"$f":"IF(EingabeMaske!N$14=4,G117,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B111","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 5"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B$136-DATE(YEAR(B$136)-1,12,31.25)","v":1},2025,225.03561643835616,"2024-01-01","2024-12-31",238,{"$f":"ROUND(IF(YEAR($B$6)+1=C137,D137,0),2)","v":0}]
[null,{"$f":"B$136-DATE(YEAR(B$136)-1,12,31.25)","v":1},2024,238,"2023-01-01","2023-12-31",238,0]
[null,1,2023,225.03561643835616,"2022-01-01","2022-12-31",238,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2022,208.04657534246576,"2021-01-01","2021-12-31",225,{"$f":"ROUND(IF(YEAR($B$6)+1=C140,D140,0),2)","v":0}]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2021,189.05205479452056,"2020-01-01","2020-12-31",208,{"$f":"ROUND(IF(YEAR($B$6)+1=C141,D141,0),2)","v":189.05}]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2020,170.05205479452056,"2019-01-01","2019-12-31",189,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2019,156.03835616438357,"2018-01-01","2018-12-31",170,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2018,143.03561643835616,"2017-01-01","2017-12-31",156,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2017,133.02739726027397,"2016-01-01","2016-12-31",143,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2016,124.02465753424657,"2015-01-01","2015-12-31",133,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2015,119.01369863013699,"2014-01-01","2014-12-31",124,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2014,114.01369863013699,"2013-01-01","2013-12-31",119,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2013,109.01369863013699,"2012-01-01","2012-12-31",114,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2012,104.01369863013699,"2011-01-01","2011-12-31",109,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2011,100.01095890410959,"2010-01-01","2010-12-31",104,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B136-DATE(YEAR(B136)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H136:H156)","v":189.05},{"$f":"IF(EingabeMaske!M$14=5,H157,0)","v":0},{"$f":"IF(EingabeMaske!N$14=5,G142,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B136","v":"2020-01-01"},"2020-01-01"]
[]
["Marktsegment 6"]
[null,{"$f":"EingabeMaske!D$16","v":"2020-01-01"},null,null,"Interpolation!",null,null,"Ergänzung "]
[null,{"$f":"B$161-DATE(YEAR(B$161)-1,12,31.25)","v":1},2025,222.04931506849314,"2024-01-01","2024-12-31",240,{"$f":"ROUND(IF(YEAR($B$6)+1=C162,D162,0),2)","v":0}]
[null,{"$f":"B$161-DATE(YEAR(B$161)-1,12,31.25)","v":1},2024,240,"2023-01-01","2023-12-31",240,0]
[null,1,2023,222.04931506849314,"2022-01-01","2022-12-31",240,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2022,205.04657534246576,"2021-01-01","2021-12-31",222,{"$f":"ROUND(IF(YEAR($B$6)+1=C165,D165,0),2)","v":0}]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2021,186.05205479452056,"2020-01-01","2020-12-31",205,{"$f":"ROUND(IF(YEAR($B$6)+1=C166,D166,0),2)","v":186.05}]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2020,174.03287671232877,"2019-01-01","2019-12-31",186,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2019,160.03835616438357,"2018-01-01","2018-12-31",174,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2018,148.03287671232877,"2017-01-01","2017-12-31",160,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2017,135.03561643835616,"2016-01-01","2016-12-31",148,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2016,127.02191780821917,"2015-01-01","2015-12-31",135,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2015,120.01917808219179,"2014-01-01","2014-12-31",127,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2014,113.01917808219179,"2013-01-01","2013-12-31",120,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2013,106.01917808219179,"2012-01-01","2012-12-31",113,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2012,101.01369863013699,"2011-01-01","2011-12-31",106,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2011,100.0027397260274,"2010-01-01","2010-12-31",101,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2010,99.0027397260274,"2009-01-01","2009-12-31",100,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2009,98.0027397260274,"2008-01-01","2008-12-31",99,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2008,95.008219178082186,"2007-01-01","2007-12-31",98,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2007,92.008219178082186,"2006-01-01","2006-12-31",95,0]
[null,{"$f":"B161-DATE(YEAR(B161)-1,12,31.25)","v":1},2006,null,"2005-01-01","2005-12-31",92,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H162:H181)","v":186.05},{"$f":"IF(EingabeMaske!M$14=6,H182,0)","v":0},{"$f":"IF(EingabeMaske!N$14=6,G167,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B161","v":"2020-01-01"},"2020-01-01"]
[]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(I57+I82+I107+I132+I157+I182,0)","v":0},{"$f":"ROUND(J57+J82+J107+J132+J157+J182,0)","v":0}]

{"sheet":"GebStandard","index":6,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,6,1,10],[24,1,24,3]]}
[null,"Gebäudestandards und Wägungsanteile für Ein- und Zweifamilienhäuser, Stufen 1-5 gemäß Anlage 2 der SW-RL"]
[]
[]
[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},1,0,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},1,0,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},1,0,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; Weichholztreppen in einfacher Art und Ausführung; kein Trittschallschutz",null,"Holzbalkendecken mit Füllung, Kappendecken; Stahl- oder Hartholztreppen in einfacher Art und Ausführung",null,"Beton- und Holzbalkendecken mit Tritt- und Luftschallschutz (z. B. schwimmender Estrich); geradläufige Treppen aus Stahlbeton oder Stahl, Harfentreppe, Trittschallschutz",null,"Decken mit größerer Spannweite, Deckenverkleidung (Holzpaneele/Kasseten); gewendelte Treppen aus Stahlbeton oder Stahl, Hartholztreppenanlage in besserer Art und Ausführung",null,"Decken mit großen Spannweiten, Deckenvertäfelungen (Edelholz, Metall); breite Stahlbeton-, Metall- oder Holztreppenanlage mit hochwertigem Geländer",null,null,{"$f":"IF(N14=TRUE,1,0)","v":0},{"$f":"IF(O14=TRUE,1,0)","v":0},1,0,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},1,0,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},1,0,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},1,0,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},1,0,0]
[null,"6%",{"$f":"ROUND($B22/$S22*N21,4)","v":0},null,{"$f":"ROUND($B22/$S22*O21,4)","v":0},null,{"$f":"ROUND($B22/$S22*P21,4)","v":0.06},null,{"$f":"ROUND($B22/$S22*Q21,4)","v":0},null,{"$f":"ROUND($B22/$S22*R21,4)","v":0},null,null,false,false,true,false,false,{"$f":"COUNTIF(N22:R22,TRUE)","v":1}]
[null,"Summe",{"$f":"SUM(C6:C22)","v":0},null,{"$f":"SUM(E6:E22)","v":0},null,{"$f":"SUM(G6:G22)","v":1},null,{"$f":"SUM(I6:I22)","v":0},null,{"$f":"SUM(K6:K22)","v":0}]
[null,"GND [Jahre]",60,null,65,null,70,null,75,null,80]
[null,"Gesamtnutzungsdauer (Jahre, gewogen):",null,null,{"$f":"ROUND((C$24*C$23+E$24*E$23+G$24*G$23+I$24*I$23+K$24*K$23),1)","v":70},null,"Standardstufe (gewogen):",null,{"$f":"(1*C23+2*E23+3*G23+4*I23+5*K23)","v":3}]

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

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

{"sheet":"Werte","index":9,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Garage"]
["Doppelgarage"]
["Carport"]
["Carport und Garage"]
["Sonstiges (freie Eingabe)"]
[]
[]
["freistehend"]
["Doppelhaushäfte / Reihenendhaus"]
["Reihenmittelhaus"]

{"sheet":"Werte 2","index":10,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Bewertungsgrundstück","WO gesamt","WO","BRW","UK WO","UK RW",null,null,null,null,"Restfläche"]
["Fall 1: Eine Aufteilung in selbstständig verwertbare und baulich nutzbare Teilflächen ist möglich. Die Teilfläche des bebauten Grundstücksteils (überbaute Fläche zzgl. Umgriffsfläche) beträgt:",{"$f":"EingabeMaske!D19","v":500},{"$f":"EingabeMaske!D20","v":0},{"$f":"EingabeMaske!D27","v":500},{"$f":"IF(C2*D2>0,1.7*C2^(-0.0855),\"\")","v":""},{"$f":"IF(C2*D2>0,1.7*D2^(-0.0855),\"\")","v":""},{"$f":"IF(C2*D2>0,E2/F2,1)","v":1},{"$f":"B2-C2","v":500},"selbstständig verwertbare Teilfläche","Anpassung an die Grundstücksgröße",{"$f":"IF(C2=0,0,B2-C2)","v":0},{"$f":"IF(C2*D2>0,1.7*K2^(-0.0855),\"\")","v":""},{"$f":"IF(C2*D2>0,L2/F2,1)","v":1},{"$f":"IF(EingabeMaske!D20=0,\"Angabe der Fläche erforderlich\",\"\")","v":"Angabe der Fläche erforderlich"}]
["Fall 2: Die mittlere Grundstückstiefe liegt über 40 m. Eine Aufteilung in selbstständig verwertbare und baulich nutzbare Teilflächen ist nicht möglich. Die Fläche bis zu 40 m Tiefe (Vorderland) beträgt:",{"$f":"EingabeMaske!D19","v":500},{"$f":"EingabeMaske!D20","v":0},{"$f":"EingabeMaske!D27","v":500},{"$f":"IF(C3*D3>0,1.7*C3^(-0.0855),\"\")","v":""},{"$f":"IF(C3*D3>0,1.7*D3^(-0.0855),\"\")","v":""},{"$f":"IF(C3*D3>0,E3/F3,1)","v":1},{"$f":"B3-C3","v":500},"Hinterlandfläche","Wertfaktor für Hinterland",{"$f":"IF(C3=0,0,B3-C3)","v":0},{"$f":"IF(C3*D3>0,1.7*K3^(-0.0855),\"\")","v":""},0.25,{"$f":"IF(EingabeMaske!D20=0,\"Angabe der Fläche erforderlich\",\"\")","v":"Angabe der Fläche erforderlich"}]
["Fall 3: Eine Aufteilung in selbstständig verwertbare und baulich nutzbare Teilflächen ist nicht möglich. Die mittlere Tiefe des Grundstücks liegt unter 40 m. Eintrag auf 0 setzen.",{"$f":"EingabeMaske!D19","v":500},0,{"$f":"EingabeMaske!D27","v":500},{"$f":"IF(D4>0,1.7*B4^(-0.0855),\"\")","v":0.99927951831873274},{"$f":"IF(D4>0,1.7*D4^(-0.0855),\"\")","v":0.99927951831873274},{"$f":"IF(D4>0,E4/F4,1)","v":1},{"$f":"0","v":0},null,null,0,null,null,{"$f":"IF(EingabeMaske!D20>0,\"Eintag auf 0 m² setzen\",\"\")","v":""}]