{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dateneingabe","Kennzahlen"],"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":"Dateneingabe","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,8],[13,5,13,8],[0,2,0,5]]}
[5,null,"Gemeindename"]
[null,"Rechnungsabschluss",null,null,"Budget","MHP"]
["VHH"," Ende 2020"," Ende 2021"," Ende 2022"," Ende 2023"," Ende 2024"," Ende 2025"," Ende 2026"," Ende 2027"]
[]
["A.II Anlagevermögen",10,11,12,{"$f":"D5-E18-E20","v":14},{"$f":"E5-F18-F20","v":15},14,13,12]
["sonstige",{"$f":"B8-B7-B5","v":1},{"$f":"C8-C7-C5","v":0},{"$f":"D8-D7-D5","v":0},0,1,3,3,3]
["B.III Geld",1,2,3,{"$f":"D7+E22","v":4},{"$f":"E7+F22","v":3},1,2,2]
["Summe Aktiva",{"$f":"B12","v":12},{"$f":"C12","v":13},{"$f":"D12","v":15},{"$f":"E12","v":18},19,18,18,{"$f":"I12","v":17}]
[]
["C+D Nettovermögen (EK)",7,8,9,{"$f":"D10+E17","v":9},{"$f":"E10+F17","v":8},6,7,7]
["E+F Fremdkapital",5,5,6,{"$f":"D11+E21","v":9},{"$f":"E11+F21","v":11},12,11,10]
["Summe Passiva",{"$f":"SUM(B10:B11)","v":12},{"$f":"SUM(C10:C11)","v":13},{"$f":"SUM(D10:D11)","v":15},{"$f":"SUM(E10:E11)","v":18},{"$f":"SUM(F10:F11)","v":19},{"$f":"SUM(G10:G11)","v":18},18,{"$f":"SUM(I10:I11)","v":17}]
[]
[null,null,null,null,"Budget","MFP"]
[null,2020,2021,2022,2023,2024,2025,2026,2027]
["aus dem EHH:"]
["SA0",2,2,1,0,-1,-2,1,0]
["MVAG 2226 Afa",null,null,null,1,1,1,1,1]
["aus dem FHH:"]
["SA2 (investiver HH)",null,null,null,-3,-2,0,0,0]
["SA4 (Finanzierungstätigkeit)",null,null,null,3,2,1,-1,-1]
["SA5 (Eigene ZMB Veränd)",null,null,null,1,-1,-2,1,0]
["alte VRV:"]
["Querschnitt Saldo1",0]
["Querschnitt Saldo 2",0]
["Quscherschnitt Saldo 4",0]
["Schuldennachweis Schuldenstand Jahresende"]
[]
["EK Quote",{"$f":"B10/B12","v":0.58333333333333337},{"$f":"C10/C12","v":0.61538461538461542},0.6,0.5,0.42105263157894735,0.33333333333333331,0.3888888888888889,{"$f":"I10/I12","v":0.41176470588235292}]
["FK Quote",{"$f":"B11/B12","v":0.41666666666666669},{"$f":"C11/C12","v":0.38461538461538464},0.4,0.5,0.57894736842105265,0.66666666666666663,{"$f":"H11/H12","v":0.61111111111111116},0.58823529411764708]
[null,2,3,4,5,6,7,8,9]
["Felder mit dieser Farbe mit Zahlen befüllen!",null,"Gew. Jahr",{"$f":"Kennzahlen!A1","v":5}]
[]
[]
[null,"Aktiva","Passiva"]
[null,{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B7:I7,0))","v":4},{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B11:I11,0))","v":9}]
[null,{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B6:I6,0))","v":0},{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B10:I10,0))","v":9}]
[null,{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B5:I5,0))","v":14}]
[null,{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B17:I17,0))","v":0}]
[null,{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B15:I15,0))","v":2023}]
[null,{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B29:I29,0))","v":0.5}]
[null,{"$f":"SUM(IF(Dateneingabe!$B$31:$I$31=Dateneingabe!$D$32,Dateneingabe!B30:I30,0))","v":0.5}]

{"sheet":"Kennzahlen","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[5,null,{"$f":"Dateneingabe!C1","v":"Gemeindename"}]
[]
["Jahr",{"$f":"Dateneingabe!B40","v":2023}]
["Nachhaltigkeitspotential SA0",{"$f":"Dateneingabe!B39","v":0}]
["8-Jahresmittel SA0",{"$f":"SUM(Dateneingabe!B17:I17)/8","v":0.375}]
["Abweichung",{"$f":"B4-B5","v":-0.375}]
[]
["Nettoverm-Qu%",{"$f":"Dateneingabe!B41","v":0.5}]
["Fremdk-Qu%",{"$f":"Dateneingabe!B42","v":0.5}]
[]
["Anlagevermögen",{"$f":"Dateneingabe!B38","v":14}]
["Fremdkapital",{"$f":"Dateneingabe!C36","v":9}]
[]
[null,"er"]