{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,10],[13,7,13,10],[0,4,0,7],[33,0,33,10]]}
[5,null,null,null,{"$f":"Tabelle3!A2","v":"Kaltenleutgeben"}]
[null,"Abschluss",null,null,null,null,"Budget","MFP"]
["VHH"," Ende 2017","Ende 2018"," Ende 2019"," Ende 2020"," Ende 2021"," Ende 2022"," Ende 2023"," Ende 2024"," Ende 2025"," Ende 2026"]
[]
["A.II Anlagevermögen",0,0,{"$f":"Tabelle3!G2","v":58483531.539999999},{"$f":"Tabelle3!G3","v":58371613.850000001},{"$f":"Tabelle3!G4","v":57915377.939999998},{"$f":"Tabelle3!G5","v":58066177.939999998},{"$f":"Tabelle3!G6","v":60866277.939999998},{"$f":"Tabelle3!G7","v":60791619.899999999},{"$f":"Tabelle3!G8","v":60052661.859999999},{"$f":"Tabelle3!G9","v":59327303.82}]
["sonstige",{"$f":"B8-B7-B5","v":0},{"$f":"C8-C7-C5","v":0},{"$f":"D8-D7-D5","v":2303172.2300000042},{"$f":"E8-E7-E5","v":2724162.1300000027},{"$f":"F8-F7-F5","v":2602443.5899999961},{"$f":"G8-G7-G5","v":2975079.6699999943},{"$f":"H8-H7-H5","v":1995379.6699999943},{"$f":"I8-I7-I5","v":2331737.7099999934},2975495.7499999925,{"$f":"K8-K7-K5","v":2893153.7899999917}]
["B.III Geld",0,0,{"$f":"Tabelle3!H2","v":2761831.32},{"$f":"Tabelle3!H3","v":2560061.7999999998},{"$f":"Tabelle3!H4","v":3405699.46},{"$f":"Tabelle3!H5","v":3079799.46},{"$f":"Tabelle3!H6","v":753899.46},{"$f":"Tabelle3!H7","v":1036899.46},{"$f":"Tabelle3!H8","v":1260099.46},{"$f":"Tabelle3!H9","v":1443499.46}]
["Summe Aktiva",{"$f":"B12","v":0},{"$f":"C12","v":0},{"$f":"D12","v":63548535.090000004},{"$f":"E12","v":63655837.780000001},{"$f":"F12","v":63923520.989999995},{"$f":"G12","v":64121057.069999993},63615557.069999993,64160257.069999993,64288257.069999993,{"$f":"K12","v":63663957.069999993}]
[]
["C+D Nettovermögen (EK)",0,0,{"$f":"Tabelle3!I2+Tabelle3!J2","v":58916573.960000001},{"$f":"Tabelle3!I3+Tabelle3!J3","v":59334937.460000001},{"$f":"Tabelle3!I4+Tabelle3!J4","v":59745655.729999997},{"$f":"Tabelle3!I5+Tabelle3!J5","v":60012455.729999997},{"$f":"Tabelle3!I6+Tabelle3!J6","v":59872455.729999997},{"$f":"Tabelle3!I7+Tabelle3!J7","v":59791055.729999997},{"$f":"Tabelle3!I8+Tabelle3!J8","v":59647355.729999997},{"$f":"Tabelle3!I9+Tabelle3!J9","v":59451755.729999997}]
["E+F Fremdkapital",{"$f":"B27","v":0},{"$f":"C27","v":0},{"$f":"Tabelle3!K2+Tabelle3!L2","v":4631961.1300000008},{"$f":"Tabelle3!K3+Tabelle3!L3","v":4320900.32},{"$f":"Tabelle3!K4+Tabelle3!L4","v":4177865.26},{"$f":"Tabelle3!K5+Tabelle3!L5","v":4108601.34},{"$f":"Tabelle3!K6+Tabelle3!L6","v":3743101.34},{"$f":"Tabelle3!K7+Tabelle3!L7","v":4369201.34},{"$f":"Tabelle3!K8+Tabelle3!L8","v":4640901.34},{"$f":"Tabelle3!K9+Tabelle3!L9","v":4212201.34}]
["Summe Passiva",{"$f":"SUM(B10:B11)","v":0},0,{"$f":"SUM(D10:D11)","v":63548535.090000004},{"$f":"SUM(E10:E11)","v":63655837.780000001},{"$f":"SUM(F10:F11)","v":63923520.989999995},{"$f":"SUM(G10:G11)","v":64121057.069999993},{"$f":"SUM(H10:H11)","v":63615557.069999993},{"$f":"SUM(I10:I11)","v":64160257.069999993},64288257.069999993,{"$f":"SUM(K10:K11)","v":63663957.069999993}]
[]
[null,null,null,null,null,null,"Budget","MFP"]
[null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
["EHH:",2017,2018,"Jahr 2019","Jahr 2020","Jahr 2021","Jahr 2022","Jahr 2023","Jahr 2024","Jahr 2025","Jahr 2026"]
["SA0",0,0,{"$f":"Tabelle3!M2","v":0},{"$f":"Tabelle3!M3","v":0},{"$f":"Tabelle3!M4","v":422461},{"$f":"Tabelle3!M5","v":266800},{"$f":"Tabelle3!M6","v":-140000},{"$f":"Tabelle3!M7","v":-81400},{"$f":"Tabelle3!M8","v":-143700},{"$f":"Tabelle3!M9","v":-195600}]
["MVAG 2226 Afa",null,null,{"$f":"Tabelle3!Q2","v":0},{"$f":"Tabelle3!Q3","v":847742.17},{"$f":"Tabelle3!Q4","v":899783.52},{"$f":"Tabelle3!Q5","v":921700},{"$f":"Tabelle3!Q6","v":917300},{"$f":"Tabelle3!Q7","v":791458.04},{"$f":"Tabelle3!Q8","v":756458.04},{"$f":"Tabelle3!Q9","v":743558.04}]
["FHH:"]
["SA2 (investiver HH)",null,null,null,null,null,{"$f":"Tabelle3!O5","v":-1072500},{"$f":"Tabelle3!O6","v":-3717400},{"$f":"Tabelle3!O7","v":-716800},{"$f":"Tabelle3!O8","v":-17500},{"$f":"Tabelle3!O9","v":-18200}]
["SA4 (Finanzierungstätigkeit)",null,null,null,null,null,{"$f":"Tabelle3!P5","v":-365500},{"$f":"Tabelle3!P6","v":626100},{"$f":"Tabelle3!P7","v":271700},{"$f":"Tabelle3!P8","v":-428700},{"$f":"Tabelle3!P9","v":-398700}]
["SA5 (Eigene ZMB Veränd)",null,null,null,null,null,{"$f":"G20+G21+Tabelle3!N5","v":-325900},{"$f":"H20+H21+Tabelle3!N6","v":-2325900},{"$f":"I20+I21+Tabelle3!N7","v":283000},{"$f":"J20+J21+Tabelle3!N8","v":223200},{"$f":"K20+K21+Tabelle3!N9","v":183400}]
["alte VRV:"]
["Querschnitt Saldo1",null,0,0]
["Querschnitt Saldo 2",null,0,0]
["Quscherschnitt Saldo 4",null,0,0]
["Schuldennachweis Schuldenstand Jahresende",0,0]
[]
["EK Quote",null,null,{"$f":"D10/D12","v":0.92711144130324907},{"$f":"E10/E12","v":0.93212091034080169},0.93464275441502087,0.93592430431215912,0.94116059793548235,0.93190174822346616,0.92781105676971809,{"$f":"K10/K12","v":0.93383695368843345}]
["FK Quote",null,null,{"$f":"D11/D12","v":7.2888558696750927E-2},{"$f":"E11/E12","v":6.7879089659198269E-2},6.5357245584979157E-2,6.4075695687840911E-2,5.8839402064517682E-2,6.8098251776533919E-2,{"$f":"J11/J12","v":7.2188943230281924E-2},6.6163046311566637E-2]
[null,0,1,2,3,4,5,6,7,8,9]
[null,null,null,null,"Gew. Jahr",{"$f":"A1","v":5}]
["Kurzbefund Zukunftsplanung:"]
["idF. n. angefr."]
[]
[null,null,null,"Aktiva","Passiva"]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B7:K7,0))","v":3079799.46},{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B11:K11,0))","v":4108601.34}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B6:K6,0))","v":2975079.6699999943},{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B10:K10,0))","v":60012455.729999997}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B5:K5,0))","v":58066177.939999998}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B17:K17,0))","v":266800}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B15:K15,0))","v":2022}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B29:K29,0))","v":0.93592430431215912}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$31:$K$31=Tabelle1!$F$32,Tabelle1!B30:K30,0))","v":6.4075695687840911E-2}]

{"sheet":"Tabelle2","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[5,null,{"$f":"\"Haushaltsanalyse \" & Tabelle3!A2","v":"Haushaltsanalyse Kaltenleutgeben"}]
[]
["Jahr",{"$f":"Tabelle1!D41","v":2022}]
["Nachhaltigkeitspotential SA0",{"$f":"Tabelle1!D40","v":266800}]
["8-Jahresmittel SA0",{"$f":"SUM(Tabelle3!M2:M9)/8","v":16070.125}]
["Abweichung",{"$f":"B4-B5","v":250729.875}]
[]
["Nettoverm-Qu%",{"$f":"Tabelle1!D42","v":0.93592430431215912}]
["Fremdk-Qu%",{"$f":"Tabelle1!D43","v":6.4075695687840911E-2}]
[]
["Anlagevermögen",{"$f":"Tabelle1!D39","v":58066177.939999998}]
["Fremdkapital",{"$f":"Tabelle1!E37","v":4108601.34}]

{"sheet":"Tabelle3","index":2,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["GemName","ID","WP_submissionn","GKz","Jahr","DS_Art","anlagev","geldv","nettov","sonderp","langfr","kurzfr","SA0","SA1","SA2","SA4","abschr2226","bemerkung"]
["Kaltenleutgeben",32,9,31713,2019,4,58483531.539999999,2761831.32,58102341.68,814232.28,4218285.6900000004,413675.44,0,null,null,null,0,""]
["Kaltenleutgeben",57,20,30603,2020,4,58371613.850000001,2560061.7999999998,58333588.43,1001349.03,3801337.79,519562.53,null,null,null,null,{"$f":"882358.28-34616.11","v":847742.17},916974.39,{"$f":"Q3-R3","v":-69232.219999999972}]
["Kaltenleutgeben",60,23,30603,2021,4,57915377.939999998,3405699.46,58756049.43,989606.3,3746580.84,431284.42,422461,1337681.75,-463943.11,-69263.92,{"$f":"-37720.98+937504.5","v":899783.52},975225.48,{"$f":"Q4-R4","v":-75441.959999999963}]
["Kaltenleutgeben",34,26,30603,2022,3,{"$f":"G4-O5-Q5","v":58066177.939999998},{"$f":"H4+N5+O5+P5","v":3079799.46},{"$f":"I4+M5","v":59022849.43},989606.3,{"$f":"K4+P4","v":3677316.92},431284.42,266800,1112100,-1072500,-365500,921700]
["Kaltenleutgeben",35,28,30603,2023,3,{"$f":"G5-O6-Q6","v":60866277.939999998},{"$f":"H5+N6+O6+P6","v":753899.46},{"$f":"I5+M6","v":58882849.43},989606.3,{"$f":"K5+P5","v":3311816.92},431284.42,-140000,765400,-3717400,626100,917300]
["Kaltenleutgeben",36,29,30603,2024,3,60791619.899999999,1036899.46,58801449.43,989606.3,3937916.92,431284.42,-81400,728100,-716800,271700,{"$f":"866900+S4","v":791458.04},""]
["Kaltenleutgeben",37,30,30603,2025,3,60052661.859999999,1260099.46,58657749.43,989606.3,4209616.92,431284.42,-143700,669400,-17500,-428700,{"$f":"831900+S4","v":756458.04},""]
["Kaltenleutgeben",38,31,30603,2026,3,59327303.82,1443499.46,58462149.43,989606.3,3780916.92,431284.42,-195600,600300,-18200,-398700,{"$f":"819000+S4","v":743558.04},""]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"I2+J2","v":58916573.960000001}]
[null,null,null,null,null,null,null,null,{"$f":"I3+J3","v":59334937.460000001}]
[null,null,null,null,null,null,null,null,59745655.729999997]
[null,null,null,null,null,null,null,null,{"$f":"I5+J5","v":60012455.729999997}]
[null,null,null,null,null,null,null,null,0,{"$f":"SUM(I13:I17)/4","v":59502405.719999999}]