{"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":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,10],[13,7,13,10],[0,4,0,7],[32,0,32,10]]}
[5,null,null,null,{"$f":"Tabelle3!A2","v":"Kaltenleutgeben"}]
[null,"Abschluss",null,null,null,null,"Budget","MFP"]
["VHH"," Ende 2018","Ende 2019"," Ende 2020"," Ende 2021"," Ende 2022"," Ende 2023"," Ende 2024"," Ende 2025"," Ende 2026"," Ende 2027"]
[]
["A.II Anlagevermögen",0,{"$f":"Tabelle3!G2","v":58483531.539999999},{"$f":"Tabelle3!G3","v":58371613.850000001},{"$f":"Tabelle3!G4","v":57915377.939999998},{"$f":"Tabelle3!G5","v":57593363},{"$f":"Tabelle3!G6","v":60680263},{"$f":"Tabelle3!G7","v":63719963},{"$f":"Tabelle3!G8","v":65564863},{"$f":"Tabelle3!G9","v":64822763},{"$f":"Tabelle3!G10","v":64006963}]
["sonstige",{"$f":"B8-B7-B5","v":0},{"$f":"C8-C7-C5","v":2303172.2300000042},{"$f":"D8-D7-D5","v":2724162.1300000027},{"$f":"E8-E7-E5","v":2602443.5899999961},{"$f":"F8-F7-F5","v":2804280},{"$f":"G8-G7-G5","v":2604066.4200000018},{"$f":"H8-H7-H5","v":2629066.4200000018},{"$f":"I8-I7-I5","v":2643166.4200000018},2662566.4200000018,{"$f":"K8-K7-K5","v":2676566.4200000018}]
["B.III Geld",0,{"$f":"Tabelle3!H2","v":2761831.32},{"$f":"Tabelle3!H3","v":2560061.7999999998},{"$f":"Tabelle3!H4","v":3405699.46},{"$f":"Tabelle3!H5","v":3686787},{"$f":"Tabelle3!H6","v":1147387},{"$f":"Tabelle3!H7","v":744687},{"$f":"Tabelle3!H8","v":520187},{"$f":"Tabelle3!H9","v":212487},{"$f":"Tabelle3!H10","v":387}]
["Summe Aktiva",{"$f":"B12","v":0},{"$f":"C12","v":63548535.090000004},{"$f":"D12","v":63655837.780000001},{"$f":"E12","v":63923520.989999995},{"$f":"F12","v":64084430},{"$f":"G12","v":64431716.420000002},67093716.420000002,68728216.420000002,67697816.420000002,{"$f":"K12","v":66683916.420000002}]
[]
["C+D Nettovermögen (EK)",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":60156671},{"$f":"Tabelle3!I6+Tabelle3!J6","v":59883871},{"$f":"Tabelle3!I7+Tabelle3!J7","v":59564271},{"$f":"Tabelle3!I8+Tabelle3!J8","v":59181571},{"$f":"Tabelle3!I9+Tabelle3!J9","v":58766871},{"$f":"Tabelle3!I10+Tabelle3!J10","v":58305271}]
["E+F Fremdkapital",{"$f":"B26","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":3927759},{"$f":"Tabelle3!K6+Tabelle3!L6","v":4547845.42},{"$f":"Tabelle3!K7+Tabelle3!L7","v":7529445.4199999999},{"$f":"Tabelle3!K8+Tabelle3!L8","v":9546645.4199999999},{"$f":"Tabelle3!K9+Tabelle3!L9","v":8930945.4199999999},{"$f":"Tabelle3!K10+Tabelle3!L10","v":8378645.4199999999}]
["Summe Passiva",{"$f":"SUM(B10:B11)","v":0},63548535.090000004,{"$f":"SUM(D10:D11)","v":63655837.780000001},{"$f":"SUM(E10:E11)","v":63923520.989999995},{"$f":"SUM(F10:F11)","v":64084430},{"$f":"SUM(G10:G11)","v":64431716.420000002},{"$f":"SUM(H10:H11)","v":67093716.420000002},{"$f":"SUM(I10:I11)","v":68728216.420000002},67697816.420000002,{"$f":"SUM(K10:K11)","v":66683916.420000002}]
[]
[null,null,null,null,null,null,"Budget","MFP"]
["EHH:",2018,2019,2020,2021,2022,2023,2024,2025,2026,2027]
["SA0",0,{"$f":"Tabelle3!M2","v":0},{"$f":"Tabelle3!M3","v":0},{"$f":"Tabelle3!M4","v":422461},{"$f":"Tabelle3!M5","v":405835},{"$f":"Tabelle3!M6","v":-272800},{"$f":"Tabelle3!M7","v":-319600},{"$f":"Tabelle3!M8","v":-382700},{"$f":"Tabelle3!M9","v":-414700},{"$f":"Tabelle3!M10","v":-461600}]
["MVAG 2226 (Afa+Rückst)",null,{"$f":"Tabelle3!Q2","v":0},{"$f":"Tabelle3!Q3","v":847742.17},{"$f":"Tabelle3!Q4","v":899783.52},{"$f":"Tabelle3!Q5","v":982281},{"$f":"Tabelle3!Q6","v":920100},{"$f":"Tabelle3!Q7","v":889900},{"$f":"Tabelle3!Q8","v":854700},{"$f":"Tabelle3!Q9","v":841700},{"$f":"Tabelle3!Q10","v":835400}]
["FHH:"]
["SA2 (investiver HH)",null,null,null,null,{"$f":"Tabelle3!O5","v":-652789},{"$f":"Tabelle3!O6","v":-4007000},{"$f":"Tabelle3!O7","v":-3929600},{"$f":"Tabelle3!O8","v":-2699600},{"$f":"Tabelle3!O9","v":-99600},{"$f":"Tabelle3!O10","v":-19600}]
["SA4 (Finanzierungstätigkeit)",null,null,null,null,{"$f":"Tabelle3!P5","v":-366490},{"$f":"Tabelle3!P6","v":823800},{"$f":"Tabelle3!P7","v":2981600},{"$f":"Tabelle3!P8","v":2017200},{"$f":"Tabelle3!P9","v":-615700},{"$f":"Tabelle3!P10","v":-552300}]
["SA5 (Eigene ZMB Veränd)",null,null,null,null,{"$f":"F19+F20+Tabelle3!N5","v":408157},{"$f":"G19+G20+Tabelle3!N6","v":-2539400},{"$f":"H19+H20+Tabelle3!N7","v":-402700},{"$f":"I19+I20+Tabelle3!N8","v":-224500},{"$f":"J19+J20+Tabelle3!N9","v":-307700},{"$f":"K19+K20+Tabelle3!N10","v":-212100}]
["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.93212091034080169},{"$f":"E10/E12","v":0.93464275441502087},0.93870962104211586,0.92941604426064428,0.88777718955279772,0.86109569086355753,0.86807631483130776,{"$f":"K10/K12","v":0.87435282944048776}]
["FK Quote",null,null,{"$f":"D11/D12","v":6.7879089659198269E-2},{"$f":"E11/E12","v":6.5357245584979157E-2},6.1290378957884153E-2,7.0583955739355733E-2,0.11222281044720223,0.13890430913644244,{"$f":"J11/J12","v":0.13192368516869218},0.12564717055951224]
[null,0,1,2,3,4,5,6,7,8,9]
[null,null,null,null,"Gew. Jahr",4]
["Kurzbefund Zukunftsplanung:"]
["idF. n. angefr."]
[]
[null,null,null,"Aktiva","Passiva"]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B7:K7,0))","v":3686787},{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B11:K11,0))","v":3927759}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B6:K6,0))","v":2804280},{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B10:K10,0))","v":60156671}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B5:K5,0))","v":57593363}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B16:K16,0))","v":405835}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B15:K15,0))","v":2022}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B28:K28,0))","v":0.93870962104211586}]
[null,null,null,{"$f":"SUM(IF(Tabelle1!$B$30:$K$30=Tabelle1!$F$31,Tabelle1!B29:K29,0))","v":6.1290378957884153E-2}]

{"sheet":"Tabelle2","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[7,null,{"$f":"\"Haushaltsanalyse \" & Tabelle3!A2","v":"Haushaltsanalyse Kaltenleutgeben"}]
[]
["Jahr",{"$f":"Tabelle1!D40","v":2022}]
["Nachhaltigkeitspotential SA0",{"$f":"Tabelle1!D39","v":405835}]
["8-Jahresmittel SA0",{"$f":"SUM(Tabelle3!M2:M9)/8","v":-70188}]
["Abweichung",{"$f":"B4-B5","v":476023}]
[]
["Nettoverm-Qu%",{"$f":"Tabelle1!D41","v":0.93870962104211586}]
["Fremdk-Qu%",{"$f":"Tabelle1!D42","v":6.1290378957884153E-2}]
[]
["Anlagevermögen",{"$f":"Tabelle1!D38","v":57593363}]
["Fremdkapital",{"$f":"Tabelle1!E36","v":3927759}]

{"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,4,57593363,3686787,59163985,992686,3292761,634998,405835,1427436,-652789,-366490,982281]
["Kaltenleutgeben",35,28,30603,2023,3,{"$f":"G5-O6-Q6","v":60680263},{"$f":"H5+N6+O6+P6","v":1147387},{"$f":"I5+M6","v":58891185},{"$f":"J5","v":992686},{"$f":"K5+P6","v":4116561},431284.42,-272800,643800,-4007000,823800,920100]
["Kaltenleutgeben",36,29,30603,2024,3,{"$f":"G6-O7-Q7","v":63719963},{"$f":"H6+N7+O7+P7","v":744687},{"$f":"I6+M7","v":58571585},{"$f":"J6","v":992686},{"$f":"K6+P7","v":7098161},431284.42,-319600,545300,-3929600,2981600,889900,""]
["Kaltenleutgeben",37,30,30603,2025,3,65564863,520187,58188885,992686,9115361,431284.42,-382700,457900,-2699600,2017200,854700,""]
["Kaltenleutgeben",38,31,30603,2026,3,64822763,212487,57774185,992686,8499661,431284.42,-414700,407600,-99600,-615700,841700,""]
["Kaltenleutgeben",38,31,30603,2027,3,{"$f":"G9-O10-Q10","v":64006963},{"$f":"H9+N10+O10+P10","v":387},{"$f":"I9+M10","v":57312585},992686,7947361,431284.42,-461600,359800,-19600,-552300,835400]
[]
[]
[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":60156671}]
[null,null,null,null,null,null,null,null,0,{"$f":"SUM(I13:I17)/4","v":59538459.537500001}]