{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Hinweise","Deckblatt","Beitragsermittlung","Berechnung Lohnkosten","Überprüfung Beitragserhebung","fortgeschr. Mittel+Konto","Mindestreserve","Detailblatt I","Detailblatt II","Finanzen","Hochschulpolitik","Internationales","Kultur","Öffentlichkeitsarbeit","Qualitätsmanagement","Soziales","Sport","Studium","Verwaltung@","Personal"],"not_rendered":{"charts":0,"images":1,"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":"Hinweise","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,4,0],[2,1,4,6]]}
["Hinweise:"]
[]
["-","Positionen mit 0,00€ nicht löschen, sondern bestehen lassen -> es könnte sein, dass diese Posten in den folgenden Jahren wieder benötigt werden und auch damit nicht in Vergessenheit gerät, was es mal gab"]
[]
[]
[]
["-","Die Summe der fortgeschriebenen finanziellen Mittel müssen immer manuell ins Deckblatt des nächsten Haushaltsjahres eingetragen werden."]
["-","Die Auflistung der fortgeschriebenen finanziellen Mittel im Detailblatt 1 und in den einzelnen Referaten dient als Übersicht, welcher Betrag übernommen werden muss. "]
[]
["-","Somit bildet die Spalte \"Übertrag ins nächste HH-Jahr\" des jeweiligen Jahres das \"Nachrangig verwendbares Vj.-Budget\" des nächsten Jahres."]
["-","Die Spalte \"Zurückführung\" errechnet sich aus dem nicht verwendeten \"Nachrangigen Vj..-Budget\" und gilt immer für das nächste Jahr."]
[]
[]
[]
["-","WICHTIG:"]
[null,"Der Haushaltsplan des Vorjahres, welcher maßgeblich für die Zahlen des neu geplanten Haushaltsplans ist, muss nach Abschluss des ersten Quartals endgültig auf die IST-Werte angepasst werden."]
[null,"Daraus sollte sich der erste Nachtragshaushalt ergeben, woraus sich wiederum eine Anpassung des Semesterbeitrags für das WS ergeben könnte."]
[]
[null,"Für die Ermittlung der angeordneten Vermögensänderung des StuRa werden die geplanten Einnahmen als Obergrenze zu Grunde gelegt. Als Einnahmen werden dabei die vom Deckblatt berücksichtigt."]
[null,"Die Einnahmen aus der Selbstverwaltung, die Zinsen und die Beitragseinnahmen der Studierenden abzüglich der Zurückführung an Studierende."]
[null,"Den daraus ermittelten Einnahmen werden die noch verfügbaren finanziellen Mittel entgegengestellt, sind diese größer als die geplanten Einnahmen, so ergibt sich die Vermögensänderung auf der Einnahmenseite."]
[null,"Für die Ermittlung der angeordneten Vermögensänderung des StuRa auf der Ausgabenseite, werden die verfügbaren finanziellen Mittel mit der Mindestreserve verglichen. "]
[null,"Sind diese kleiner als die Mindestreserve, so bildet die Differenz den Betrag der Vermögensänderung."]

{"sheet":"Deckblatt","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,11,0],[15,4,15,6],[17,3,17,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[2,0,2,1]]}
["Haushaltsplan Student:innenschaft HTW Dresden",2026,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J57","v":44450},{"$f":"'Detailblatt I'!K57","v":0},{"$f":"D3-C3","v":-44450},{"$f":"'Detailblatt I'!M57","v":333706},{"$f":"'Detailblatt I'!N57","v":0},{"$f":"(F3-G3)","v":333706}]
["Beitragseinnahmen der Studentinnen",null,{"$f":"'Detailblatt II'!F26","v":223000},{"$f":"'Detailblatt II'!G26","v":41175.333333333336},-181824.66666666666,{"$f":"'Detailblatt II'!I26","v":0},{"$f":"'Detailblatt II'!J26","v":0},{"$f":"(F4-G4)","v":0}]
["Zinsen",null,{"$f":"'Detailblatt II'!F30","v":3000},{"$f":"'Detailblatt II'!G30","v":0},-3000,{"$f":"'Detailblatt II'!I30","v":800},{"$f":"'Detailblatt II'!J30","v":0},{"$f":"(F5-G5)","v":800}]
["Entnahme (=Einnahme) & Ansparen (=Ausgabe) \nvon Vermögen",null,{"$f":"IF((Beitragsermittlung!B16)-('Detailblatt II'!F24+'Detailblatt II'!F25)>0,(Beitragsermittlung!B16)-('Detailblatt II'!F24+'Detailblatt II'!F25),0)","v":586},0,-586,0,{"$f":"'Detailblatt II'!G31","v":0},{"$f":"(F6-G6)","v":0}]
["angeordnete Vermögensänderung lt. FO",null,{"$f":"Beitragsermittlung!B14","v":0},null,0,{"$f":"'Detailblatt II'!I29","v":0},null,{"$f":"(F7-G7)","v":0}]
["Zurückführung an Studentinnen (StuRa)",null,63470,{"$f":"C8","v":63470},0]
[]
["Gesamt:",null,{"$f":"SUM(C3:C9)","v":334506},{"$f":"SUM(D3:D9)","v":104645.33333333334},-229860.66666666666,334506,0,334506]
["Berechnung des Semesterbeitrages:"]
[null,"Planausgaben:",{"$f":"F10","v":334506},null,"In Zeile F6 (Ansparung) manuell einzutragen:",null,null,{"$f":"IF(Deckblatt!C10-Deckblatt!F10>0,Deckblatt!C10-Deckblatt!F10+F6,IF(C10=F10,\"Haushaltsplan ist ausgeglichen!\",\"Haushaltsplan ist nicht ausgeglichen!\"))","v":"Haushaltsplan ist ausgeglichen!"}]
["-","Planeinnahmen:",{"$f":"C3+C5","v":47450}]
["-","Zurückführung:",{"$f":"C8+C9","v":63470}]
["-","Vermögensänderung",{"$f":"C7","v":0}]
["=","Gesamt:",{"$f":"C12-C13-C14-C15-F6","v":223586}]
["/","Beitragszahlungen/Jahr:",{"$f":"'Detailblatt II'!D24+('Detailblatt II'!D25/6*4)","v":7400}]
["=","Stud./Semester:",{"$f":"IF((C16-'Detailblatt II'!F23)/Deckblatt!C17<0,0,(C16-'Detailblatt II'!F23)/Deckblatt!C17)","v":24.57918918918919},"Anzusetzender Semesterbeitrag:",null,{"$f":"ROUND((C18*2),0)/2","v":24.5}]

{"sheet":"Beitragsermittlung","index":2,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Ermittlung des Beitrages in Bezug auf die angeordnete Vermögensänderung"]
[]
["Geplante Einnahmen",{"$f":"Deckblatt!F10-Deckblatt!C8-Deckblatt!C9-Deckblatt!F6","v":271036}]
["verfügbare finanzielle Mittel",{"$f":"'fortgeschr. Mittel+Konto'!D9","v":244627.63999999966}]
["Obergrenze finanzielle Mittel",{"$f":"IF(B3<B4,B3,B4)","v":244627.63999999966}]
[]
["Vorgesehene Vermögenssenkung wegen zu hoher verfügbarer finanzieller Mittel",{"$f":"IF(Beitragsermittlung!B4>Deckblatt!F10-Deckblatt!F6,Beitragsermittlung!B4-Beitragsermittlung!B5,0)","v":0}]
["Mindestreserve",{"$f":"Mindestreserve!D18","v":152910}]
["(Verfügbare finanzielle Mittel nach Vermögenssenkung)",{"$f":"B4-B7","v":244627.63999999966}]
["Untergrenze für verfügbare finanzielle Mittel durch Bemessung an der Mindestreserve wird erreicht",{"$f":"IF(B5<B8,B8,B5)","v":244627.63999999966}]
["beabsichtigte Senkung der verfügbaren finanziellen Mittel",{"$f":"B4-B10","v":0}]
[]
["Obergrenze für verpflichtende Vermögenssenkung entgegen der (negativen) Erhebung von Beiträgen",{"$f":"IF(Beitragsermittlung!B11>(Deckblatt!F10-Deckblatt!F6-(Deckblatt!C3+Deckblatt!C5+Deckblatt!C8+Deckblatt!C9+'Detailblatt II'!F23)),Deckblatt!F10-Deckblatt!F6-(Deckblatt!C3+Deckblatt!C5+Deckblatt!C8+Deckblatt!C9+'Detailblatt II'!F23),Beitragsermittlung!B11)","v":0}]
["Vermögenssenkung wegen übermäßig verfügbarer finanzieller Mittel ohne negativen Semesterbeitrag",{"$f":"IF(B13<0,0,B13)","v":0}]
[]
["restlich zu vereinnahmender Semesterbeitrag ab dem nächsten Sommersemester",{"$f":"(Deckblatt!F3+Deckblatt!F5+Deckblatt!F7+Deckblatt!F4)-(Deckblatt!C13+Deckblatt!C14+Deckblatt!C15+'Detailblatt II'!F23)","v":181886}]

{"sheet":"Berechnung Lohnkosten","index":3,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,4],[2,7,2,8],[2,10,2,11]]}
["Berechnung der anfallenden Lohnkosten in Abhängigkeit der besetzten Stellen"]
[]
["langfristige Stellen",null,null,null,null,null,null,"mittelfristige Stellen",null,null,"Besetzungsgrad mittelfristige Stellen"]
[null,"Fina. u. Verw.","Assi. d. GF.","Assi. d. GF","Einarb. Assi. d. GF",null,null,null,null,null,"max. mögliche Stellen h/M",{"$f":"6*40","v":240}]
["TVL (50%)","E7 Stufe 4","E9b Stufe 4","E9b Stufe 3","E9b Stufe 4",null,null,null,null,null,"geschaffene Stellen h/M",240]
["Vertragsdauer","unbefristet","01.2026 - 10.2026","11.2026 - 12.2026","11.2026 - 12.2026",null,null,"Brutto je Stunde",13.98,null,"„Schaffungsgrad“",{"$f":"L5/L4","v":1}]
["Bruttoverdienst",{"$f":"3678.84*(3/4)","v":2759.13},{"$f":"4366.72*(3/4)","v":3275.04},{"$f":"3925.17*(3/4)","v":2943.8775000000001},{"$f":"4366.72/2","v":2183.36},null,null,"Brutto pro Monat",{"$f":"I6*40","v":559.20000000000005},null,"voraussichtlicher Besetzungsgrad",0.8]
[null,null,null,null,null,null,null,null,null,null,"entspricht besetzte Stellen h/M",{"$f":"L7*L5","v":192}]
["Nebenkosten",null,null,null,null,null,null,"Nebenkosten"]
["Rentenversicherung",{"$f":"B7*0.0863","v":238.11291900000001},{"$f":"C7*0.09","v":294.75360000000001},{"$f":"D7*0.09","v":264.94897500000002},196.50239999999999,null,null,"15% Rentenvers. Pauschal",{"$f":"I$7*0.15","v":83.88000000000001}]
["Arbeitslosenversicherung",{"$f":"B7*0.0132","v":36.420515999999999},{"$f":"C7*0.013","v":42.575519999999997},{"$f":"D7*0.013","v":38.270407499999997},28.383680000000002,null,null,"13% Krankenvers. Pauschal",{"$f":"I$7*0.13","v":72.696000000000012}]
["Krankenversicherung",{"$f":"B7*0.0941","v":259.63413300000002},{"$f":"C7*0.093","v":304.57871999999998},{"$f":"D7*0.093","v":273.78060750000003},203.05248,null,null,"2% Steuerpauschale",{"$f":"I$7*0.02","v":11.184000000000001}]
["Pflegeversicherung",{"$f":"B7*0.0134","v":36.972342000000005},{"$f":"C7*0.013","v":42.575519999999997},{"$f":"D7*0.013","v":38.270407499999997},28.383680000000002,null,null,"0,9% Umlage 1 U1",{"$f":"I$7*0.009","v":5.0327999999999999}]
["Umlage U1",{"$f":"B7*0.02","v":55.182600000000001},{"$f":"C7*0.02","v":65.500799999999998},{"$f":"D7*0.02","v":58.877549999999999},43.667200000000001,null,null,"0,29% Umlage 2 U2",{"$f":"I$7*0.0029","v":1.62168}]
["Umlage U2",{"$f":"B7*0.0019","v":5.2423470000000005},{"$f":"C7*0.012","v":39.30048},{"$f":"D7*0.012","v":35.326529999999998},26.200320000000001,null,null,"0,06% Umlage 3 U3",{"$f":"I$7*0.0006","v":0.33551999999999998}]
["Umlage U3",{"$f":"B7*0.0042","v":11.588346},{"$f":"C7*0.0043","v":14.082672000000001},{"$f":"D7*0.0043","v":12.65867325},9.3884480000000003,null,null,"1,3% Unfallversicherung",{"$f":"I$7*0.013","v":7.2696000000000005}]
["Unfallversicherung (BG)",{"$f":"B7*0.015","v":41.386949999999999},{"$f":"C7*0.015","v":49.125599999999999},{"$f":"D7*0.015","v":44.158162499999996},32.750399999999999]
["Summe Lohnnebenk. ",{"$f":"SUM(B10:B17)","v":684.54015300000003},{"$f":"SUM(C10:C17)","v":852.49291199999993},{"$f":"SUM(D10:D17)","v":766.29131325000014},568.32860800000003,null,null,"Summe Lohnnebenk. ",{"$f":"SUM(I10:I16)","v":182.01960000000003}]
[]
["Bruttolohnkosten monatl.",{"$f":"B7+B18","v":3443.670153},{"$f":"C7+C18","v":4127.5329119999997},{"$f":"D7+D18","v":3710.1688132500003},{"$f":"E7+E18","v":2751.6886080000004},null,null,"Bruttolohnkosten monatl.",{"$f":"I18+I7","v":741.21960000000013}]
["Jahressonderzahlung",{"$f":"B20*0.8814","v":3035.2508728541998},{"$f":"C20*0.7435*(10/12)","v":2557.35060006},{"$f":"D20*0.7435*(2/12)","v":459.75175210856253},{"$f":"E20*0.7435*(2/12)","v":340.98008000800007}]
[]
[]
[]
["Bruttolohnkosten jährl.",{"$f":"B20*12+B21","v":44359.292708854206},{"$f":"C20*10+C21","v":43832.679720059998},{"$f":"D20*2+D21","v":7880.0893786085635},{"$f":"E20*2+E21","v":5844.357296008001},null,null,null,{"$f":"(I20*(L8/40))*12","v":42694.248960000004},null,"Kosten Lohnbüro jährl.",3000]
[]
["Jahresgesamtkosten",{"$f":"B25+C25+D25+E25+I25+L25","v":147610.66806353079}]

{"sheet":"Überprüfung Beitragserhebung","index":4,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,1,17,8],[20,1,20,8],[25,1,25,8],[28,1,28,8],[0,0,1,3],[0,4,1,4],[0,5,1,8],[2,1,2,8],[12,1,12,8]]}
["Überprüfung der Beitragserhebung während des laufenden Kalenderjahres",null,null,null,"Jahr -",{"$f":"Deckblatt!B1","v":2026},null,null,null,"Wintersemester"]
[]
["Sachkontonr."]
[1200,"Bankbestand"]
[1210,"Bank Zinsaktiv"]
[1220,"Paypal-Konto"]
[1000,"Kassenbestände"]
[1010,"Kasse Kino-Eintritt"]
[1020,"Kasse Kino-Snack"]
["1368&1369","Corona-Fonds (verrechnet)"]
[1591,"Semesterticket"]
[1734,"sonstige notwendige Bereinigungen (Kautionen)"]
[null,"Geldbestand",null,null,null,null,null,null,null,{"$f":"SUM(J4:J12)","v":0}]
[null,"Mindestreserve",null,null,null,null,null,null,null,{"$f":"-(Mindestreserve!$D$18)","v":-152910}]
[null,"Planausgaben",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$O$57)","v":-333706}]
[null,"nachrangig verwendbares Vorjahresbudget",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$P$57)","v":-67210}]
[null,"->davon verwendet",null,null,null,null,null,null,null,{"$f":"'Detailblatt I'!$Q$57","v":0}]
[null,"bereinigter Geldbestand",null,null,null,null,null,null,null,{"$f":"SUM(J13:J17)","v":-553826}]
[null,"Planeinnahmen",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$L$57)","v":44450}]
[null,"voraussichtliche Beitragseinnahmen",null,null,null,null,null,null,null,{"$f":"-('Detailblatt II'!$H$25)","v":78400}]
[null,"voraussichtlicher bereinigter Geldbestand",null,null,null,null,null,null,null,{"$f":"SUM(J18:J20)","v":-430976}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand",null,null,null,null,null,null,null,{"$f":"J18+J19","v":-509376}]
[null,"neuer Semesterbeitrag",null,null,null,null,null,null,null,{"$f":"ROUNDUP(-(J22/'Detailblatt II'!$D$25/4*6)/5,1)*5","v":159.5}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand bei 50% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J18+J19/2","v":-531601}]
[null,"neuer Semesterbeitrag bei Erfüllung von 50% der Planeinnahmen",null,null,null,null,null,null,null,{"$f":"ROUNDUP(-(J24/'Detailblatt II'!$D$25/4*6)/5,1)*5","v":166.50000000000003}]
[null,"voraussichtlicher bereinigter Geldbestand bei 50% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J24+J20","v":-453201}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand bei 25% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J18+J19/4","v":-542713.5}]
[null,"neuer Semesterbeitrag bei Erfüllung von 25% der Planeinnahmen",null,null,null,null,null,null,null,{"$f":"ROUNDUP(-(J27/'Detailblatt II'!$D$25/4*6)/5,1)*5","v":170}]
[null,"voraussichtlicher bereinigter Geldbestand bei 25% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J27+J20","v":-464313.5}]

{"sheet":"fortgeschr. Mittel+Konto","index":5,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,6,21,7],[23,6,23,7],[24,6,24,7],[16,8,17,8],[18,5,19,5],[18,6,19,7],[18,8,19,8],[20,6,20,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,5,17,5],[16,6,17,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[2,8,3,8],[4,5,5,5],[4,6,5,7],[4,8,5,8],[6,6,6,7],[0,0,1,1],[0,2,1,2],[0,3,1,3],[1,6,1,7],[2,5,3,5],[2,6,3,7]]}
["Fortgeschriebene finanzielle Mittel + Bankkontostand",null,"Jahr -",{"$f":"Deckblatt!B1","v":2026}]
[null,null,null,null,null,"Nr.","voraussichtliche Ausgaben",null,"Saldo"]
[null,"Position","erstellt am:","2025-11-12",null,"1.","Personal (Okt.+Nov.+Dez. inkl. 13.Gehalt, ACON, Finanzamt)",null,55000]
[null,"Bank-/Kassenbestand bei Haushaltsplanerstellung",null,{"$f":"13983.57+75+75+31+50+96546.63+1404550.17+4293.91","v":1519605.2799999998}]
["-","abzgl. voraussichtliche Ausgaben in",{"$f":"D1-1","v":2025},{"$f":"I25*(-1)","v":-1102597.6400000001},null,"2.","Finanzbeschlüsse aktuell noch nicht bezahlt in Summe",null,{"$f":"1700+2000+700+200+400+30+2800","v":7830}]
["-","nachrangig verwendbares Vorjahresbudget",null,{"$f":"'Detailblatt I'!P57*(-1)-'Detailblatt I'!Q57*(-1)","v":-67210}]
["-","Zurückführung an Student:innen gesamt",null,{"$f":"SUM(Deckblatt!C8:C9)*-1","v":-63470},null,"3.","Schulungen/Konferenzen (KoSe)",null,0]
["-","Beitragseinnahmen anteilig WS 24/25 für 2025",null,{"$f":"'Detailblatt II'!F23*-1","v":-41700},null,"4.","voraussichtliche AE",null,10000]
["=","verfügbare finanzielle Mittel",null,{"$f":"D4+D5+D6+D7+D8","v":244627.63999999966},null,"5.","offene Härtefallanträge",null,0]
[null,null,null,null,null,"6.","Software-Abos (AGENDA etc.)",null,{"$f":"89.25*3","v":267.75}]
[null,null,null,null,null,"7.","Kosten für Wartung (Drucker etc.)",null,130]
[null,null,null,null,null,"8.","Kontoführung",null,{"$f":"3*20","v":60}]
[null,null,null,null,null,"9.","Kino in der HTW & Co.",null,84]
[null,null,null,null,null,"10.","Kosten für Wahlen",null,0]
[null,null,null,null,null,"11.","Kaffeebestellung(en)",null,320]
[null,null,null,null,null,"12.","Ersatz- & Neuanschaffung",null,500]
[null,null,null,null,null,"13.","wahrscheinlich noch zu beschließende Finanzanträge ",null,1000]
[]
[null,null,null,null,null,"14.","Semesterticket Konto 1591 & 1592",null,{"$f":"71061.6+956344.29","v":1027405.89}]
[]
[null,null,null,null,null,"15.","Konto 1704",null,0]
[null,null,null,null,null,"16.","Konto 1450 (-)",null,0]
[null,null,null,null,null,"17.","Kaution 1734",null,0]
[null,null,null,null,null,"18.","Nothilfefonds saldiert",null,0]
[null,null,null,null,null,"=","Gesamtsumme:",null,{"$f":"SUM(I3:I24)","v":1102597.6400000001}]

{"sheet":"Mindestreserve","index":6,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,0,15,2],[15,3,15,4],[16,0,16,2],[16,3,16,4],[17,0,17,2],[17,3,17,4],[12,0,12,4],[13,0,13,2],[13,3,13,4],[14,0,14,2],[14,3,14,4],[9,0,9,2],[9,3,9,4],[10,0,10,2],[10,3,10,4],[11,0,11,2],[11,3,11,4],[6,0,6,2],[6,3,6,4],[7,0,7,2],[7,3,7,4],[8,0,8,4],[3,0,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[0,0,1,2],[0,3,1,3],[0,4,1,4],[0,5,0,9],[1,6,2,9],[2,0,2,2],[2,3,2,4]]}
["Mindestreserve",null,null,"Jahr -",{"$f":"Deckblatt!B1","v":2026},"Berechnungsgrundlage ist die aktuelle Finanzordnung (FO)"]
[null,null,null,null,null,null,"- alle vertraglich festgeschriebenen Vereinbarungen müssen durch die Kapitalreserve abgedeckt sein"]
["vertragliche Vereinbarungen",null,null,"Planausgaben"]
["Student:innenrat"]
["Lohnkosten (Detailblatt I - Zelle M7)",null,null,{"$f":"'Detailblatt I'!M6","v":150000}]
["Korrektur für \"SHK\"-Stellen",null,null,0]
["…aktuell ohne Belegung…",null,null,"------"]
["…aktuell ohne Belegung…",null,null,"------"]
["Referat Finanzen"]
["Kontoführungsgebühren",null,null,{"$f":"Finanzen!G3","v":600}]
["Buchhaltungssoftware AGENDA",null,null,{"$f":"Finanzen!G4","v":1100}]
["…aktuell ohne Belegung…",null,null,"------"]
["Referat Selbstverwaltung & Organisation"]
["Domains",null,null,{"$f":"'Verwaltung@'!F4","v":80}]
["laufende Kosten für Druck",null,null,{"$f":"'Verwaltung@'!F13","v":550}]
["Simkarten",null,null,{"$f":"'Verwaltung@'!F3","v":180}]
["Versicherung Beachvolleyballplätze",null,null,{"$f":"'Verwaltung@'!F6","v":400}]
["Gesamt:",null,null,{"$f":"SUM(D5:E17)","v":152910}]

{"sheet":"Detailblatt I","index":7,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,8],[50,0,50,18],[51,1,51,8],[51,9,55,11],[51,15,55,18],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,0,55,8],[45,0,45,18],[46,0,46,4],[46,9,49,11],[46,12,47,14],[46,15,47,18],[47,0,47,4],[47,5,47,6],[47,7,47,8],[48,0,48,7],[49,0,49,8],[41,1,41,8],[41,9,44,11],[41,15,44,18],[42,1,42,8],[43,1,43,8],[44,0,44,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,0,39,8],[40,0,40,18],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[21,1,21,8],[22,1,22,8],[23,1,23,8],[24,0,24,8],[25,0,25,18],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[15,1,15,8],[14,1,14,8],[3,1,3,8],[3,12,3,14],[4,1,10,1],[4,2,4,8],[5,2,5,8],[5,14,10,14],[6,2,6,8],[6,12,10,12],[7,2,7,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[0,15,1,15],[0,16,1,16],[0,17,1,17],[0,18,1,18],[2,0,2,18],[0,0,1,3],[0,4,1,4],[0,5,1,8],[0,9,0,11],[0,12,0,14]]}
["Detailblatt I",null,null,null,"Jahr -",{"$f":"Deckblatt!B1","v":2026},null,null,null,"Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr"]
[null,null,null,null,null,null,null,null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung der Studentinnenschaft HTW Dresden"]
["Sachkontonr."]
[2749,"Angestellte","AAG (Aufwendungsausgleichsgesetz)",null,null,null,null,null,null,null,0,{"$f":"K5","v":0}]
[4120,null,"Gehälter ",null,null,null,null,null,null,null,null,null,150000,0,{"$f":"M6-SUM(N6:N11)+L5","v":150000}]
[4121,null,"Lohnsteuer",null,null,null,null,null,null,null,null,null,null,0]
[4170,null,"Vermögenswirksame Leistungen",null,null,null,null,null,null,null,null,null,null,0]
[4130,null,"gesetzliche soziale Aufwendungen",null,null,null,null,null,null,null,null,null,null,0]
[4138,null,"Beitrag Berufsgenossenschaft",null,null,null,null,null,null,null,null,null,null,0]
[4956,null,"Lohnbüro",null,null,null,null,null,null,null,null,null,null,0]
[4110,"Aufwandsentschädigungen Exekutive",null,null,null,null,null,null,null,null,null,null,35000,0,{"$f":"M12-N12","v":35000}]
[null,"Aufwandsentschädigungen Legislative",null,null,null,null,null,null,null,null,null,null,9000,0,9000]
[4640,"Kaffee und Verpflegung",null,null,null,null,null,null,null,null,null,null,1700,0,1700]
[null,"Verbrauchsgüter",null,null,null,null,null,null,null,null,null,null,300,0,{"$f":"M15-N15","v":300}]
[4670,"Allgemeine Reisekosten (keiner Veranstaltung zugeordnet)",null,null,null,null,null,null,null,null,null,null,500,0,500]
[null,"Karten Semesterticket",null,null,null,null,null,null,null,null,null,null,200,0,200]
[null,"Rückerstattung Semesterticket für studienbedingte Aufenthalte",null,null,null,null,null,null,null,null,null,null,6100,0,{"$f":"M18-N18","v":6100}]
[4930,"Büro- und Verbrauchsmaterialien",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M19-N19","v":0},50,{"$f":"IF(O19<0,IF(P19>0,IF((O19*(-1))>P19,P19,O19*(-1)),0),0)","v":0},{"$f":"IF(OR(Q19>P19,O19+P19<0),MAKRO1(),ROUNDDOWN(P19-Q19,-1))","v":50},{"$f":"IF(O19>0,ROUNDDOWN(O19,-1),0)","v":0}]
[4943,"Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,2000,0,{"$f":"M20-N20","v":2000},2000,{"$f":"IF(O20<0,IF(P20>0,IF((O20*(-1))>P20,P20,O20*(-1)),0),0)","v":0},{"$f":"IF(OR(Q20>P20,O20+P20<0),MAKRO1(),ROUNDDOWN(P20-Q20,-1))","v":2000},{"$f":"IF(O20>0,ROUNDDOWN(O20,-1),0)","v":2000}]
[4944,"Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,3500,0,{"$f":"M21-N21","v":3500},250,{"$f":"IF(O21<0,IF(P21>0,IF((O21*(-1))>P21,P21,O21*(-1)),0),0)","v":0},{"$f":"IF(OR(Q21>P21,O21+P21<0),MAKRO1(),ROUNDDOWN(P21-Q21,-1))","v":250},{"$f":"IF(O21>0,ROUNDDOWN(O21,-1),0)","v":3500}]
[4945,"Durchführung Konferenzen",null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!F21","v":1500},{"$f":"'Detailblatt II'!G21","v":0},{"$f":"'Detailblatt II'!H21","v":-1500},{"$f":"'Detailblatt II'!I21","v":3500},{"$f":"'Detailblatt II'!J21","v":0},{"$f":"'Detailblatt II'!K21","v":3500},{"$f":"'Detailblatt II'!L21","v":3500},{"$f":"'Detailblatt II'!M21","v":0},{"$f":"'Detailblatt II'!N21","v":3500},{"$f":"'Detailblatt II'!O21","v":3500}]
[4950,"Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,3000,0,{"$f":"M23-N23","v":3000},3000,{"$f":"IF(O23<0,IF(P23>0,IF((O23*(-1))>P23,P23,O23*(-1)),0),0)","v":0},{"$f":"IF(OR(Q23>P23,O23+P23<0),MAKRO1(),ROUNDDOWN(P23-Q23,-1))","v":3000},{"$f":"IF(O23>0,ROUNDDOWN(O23,-1),0)","v":3000}]
[4989,"Ersatz- und Neuanschaffung",null,null,null,null,null,null,null,null,null,null,5000,0,{"$f":"M24-N24","v":5000},1070,{"$f":"IF(O24<0,IF(P24>0,IF((O24*(-1))>P24,P24,O24*(-1)),0),0)","v":0},{"$f":"IF(OR(Q24>P24,O24+P24<0),MAKRO1(),ROUNDDOWN(P24-Q24,-1))","v":1070},{"$f":"IF(O24>0,ROUNDDOWN(O24,-1),0)","v":5000}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J5:J24)","v":1500},0,-1500,219800,0,219800,{"$f":"SUM(P19:P24)","v":9870},{"$f":"SUM(Q19:Q24)","v":0},{"$f":"SUM(R19:R24)","v":9870},{"$f":"SUM(S19:S24)","v":17000}]
["Referate"]
[4960,"Finanzen",null,null,null,null,null,null,null,{"$f":"Finanzen!D8","v":0},{"$f":"Finanzen!E8","v":0},{"$f":"K27-J27","v":0},{"$f":"Finanzen!G8","v":3250},{"$f":"Finanzen!H8","v":0},{"$f":"M27-N27","v":3250}]
[4961,"Hochschulpolitik",null,null,null,null,null,null,null,{"$f":"Hochschulpolitik!C9","v":1400},{"$f":"Hochschulpolitik!D9","v":0},-1400,{"$f":"Hochschulpolitik!F9","v":4300},{"$f":"Hochschulpolitik!G9","v":0},4300,{"$f":"Hochschulpolitik!I9","v":3090},{"$f":"Hochschulpolitik!J9","v":0},{"$f":"Hochschulpolitik!K9","v":3090},{"$f":"Hochschulpolitik!L9","v":4300}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C6","v":0},{"$f":"Internationales!D6","v":0},0,{"$f":"Internationales!F6","v":1350},{"$f":"Internationales!G6","v":0},1350,{"$f":"Internationales!I6","v":100},{"$f":"Internationales!J6","v":0},{"$f":"Internationales!K6","v":100},{"$f":"Internationales!L6","v":1100}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C15","v":26850},{"$f":"Kultur!D15","v":0},-26850,{"$f":"Kultur!F15","v":28400},{"$f":"Kultur!G15","v":0},28400,{"$f":"Kultur!I15","v":18930},{"$f":"Kultur!J15","v":0},{"$f":"Kultur!K15","v":18930},{"$f":"Kultur!L15","v":28150}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C7","v":0},{"$f":"Öffentlichkeitsarbeit!D7","v":0},0,{"$f":"Öffentlichkeitsarbeit!F7","v":8750},{"$f":"Öffentlichkeitsarbeit!G7","v":0},8750,{"$f":"Öffentlichkeitsarbeit!I7","v":3060},{"$f":"Öffentlichkeitsarbeit!J7","v":0},{"$f":"Öffentlichkeitsarbeit!K7","v":3060},{"$f":"Öffentlichkeitsarbeit!L7","v":8500}]
[4965,"Qualitätsmanagement",null,null,null,null,null,null,null,{"$f":"Qualitätsmanagement!C6","v":1500},{"$f":"Qualitätsmanagement!D6","v":0},-1500,{"$f":"Qualitätsmanagement!F6","v":3250},{"$f":"Qualitätsmanagement!G6","v":0},3250,{"$f":"Qualitätsmanagement!I6","v":900},{"$f":"Qualitätsmanagement!J6","v":0},{"$f":"Qualitätsmanagement!K6","v":900},{"$f":"Qualitätsmanagement!L6","v":3000}]
[4966,"Soziales",null,null,null,null,null,null,null,{"$f":"Soziales!C6","v":0},{"$f":"Soziales!D6","v":0},0,{"$f":"Soziales!F6","v":1050},{"$f":"Soziales!G6","v":0},1050,{"$f":"Soziales!I6","v":800},{"$f":"Soziales!J6","v":0},{"$f":"Soziales!K6","v":800},{"$f":"Soziales!L6","v":800}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C11","v":3500},{"$f":"Sport!D11","v":0},-3500,{"$f":"Sport!F11","v":5450},{"$f":"Sport!G11","v":0},5450,{"$f":"Sport!I11","v":6200},{"$f":"Sport!J11","v":0},{"$f":"Sport!K11","v":6200},{"$f":"Sport!L11","v":5200}]
[4968,"Studium",null,null,null,null,null,null,null,{"$f":"Studium!C6","v":0},{"$f":"Studium!D6","v":0},0,{"$f":"Studium!F6","v":1250},{"$f":"Studium!G6","v":0},1250,{"$f":"Studium!I6","v":1250},{"$f":"Studium!J6","v":0},{"$f":"Studium!K6","v":1250},{"$f":"Studium!L6","v":1250}]
[4969,"Studentische Verwaltung",null,null,null,null,null,null,null,{"$f":"'Verwaltung@'!C17","v":9700},{"$f":"'Verwaltung@'!D17","v":0},-9700,{"$f":"'Verwaltung@'!F17","v":27126},{"$f":"'Verwaltung@'!G17","v":0},27126,{"$f":"'Verwaltung@'!I17","v":9860},{"$f":"'Verwaltung@'!J17","v":0},{"$f":"'Verwaltung@'!K17","v":9860},{"$f":"'Verwaltung@'!L17","v":26870}]
[4946,"Personal",null,null,null,null,null,null,null,{"$f":"Personal!C21","v":0},{"$f":"Personal!D21","v":0},0,{"$f":"Personal!F21","v":11900},{"$f":"Personal!G21","v":0},11900,{"$f":"Personal!I21","v":7120},{"$f":"Personal!J21","v":0},{"$f":"Personal!K21","v":7120},{"$f":"Personal!L21","v":11650}]
["----","Ausschüsse des Studentinnenrates",null,null,null,null,null,null,null,0,0,0,0,0,0]
["----","weitere Vertretungen",null,null,null,null,null,null,null,0,0,0,0,0,0]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J27:J39)","v":42950},0,-42950,96076,0,96076,{"$f":"SUM(P28:P37)","v":51310},{"$f":"SUM(Q28:Q37)","v":0},{"$f":"SUM(R28:R37)","v":51310},{"$f":"SUM(S28:S37)","v":90820}]
["Ausschüsse der Studentinnenschaft"]
["----","weitere Ausschüsse der Student:innenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M42-N42","v":0}]
["----","Wahlausschuss der Student:innenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M43-N43","v":0}]
[4941,"Härtefallausschuss der Student:innenschaft",null,null,null,null,null,null,null,null,null,null,6000,0,{"$f":"M44-N44","v":6000}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M42:M44)","v":6000},{"$f":"SUM(N42:N44)","v":0},{"$f":"SUM(O42:O44)","v":6000}]
[]
["Anzahl der Studentinnen im:",null,null,null,null,"WiSe","26/27","SoSe",26]
["gesamt:",null,null,null,null,{"$f":"'Detailblatt II'!D25","v":4800},null,{"$f":"'Detailblatt II'!D24","v":4200}]
["#4942 Absicherung Teilnahme BuFaTas lt. Finanzordnung:",null,null,null,null,null,null,null,0.75,null,null,null,{"$f":"ROUND(($F$48+$H$48)*$I$49,-2)","v":6800},0,{"$f":"M49-N49","v":6800},6030,{"$f":"IF(O49<0,IF(P49>0,IF((O49*(-1))>P49,P49,O49*(-1)),0),0)","v":0},{"$f":"IF(OR(Q49>P49,O49+P49<0),MAKRO1(),ROUNDDOWN(P49-Q49,-1))","v":6030},{"$f":"IF(O49>0,ROUNDDOWN(O49,-1),0)","v":6800}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M49:M49)","v":6800},0,6800,6030,0,6030,6800]
["Vertretungen der Student:innen"]
["----","Vertretungen der Student:innen in der Hochschule",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M52-N52","v":0}]
["----","Konferenz Sächsischer Studierendenschaft",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I6","v":3000},{"$f":"'Detailblatt II'!J6","v":0},{"$f":"M53-N53","v":3000}]
["----","Interessenvertretungen der Student:innenschaft ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I16","v":2030},{"$f":"'Detailblatt II'!J16","v":0},{"$f":"M54-N54","v":2030}]
["----","weitere Interessenvertetungen",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M55-N55","v":0}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M52:M55)","v":5030},{"$f":"SUM(N52:N55)","v":0},{"$f":"SUM(O52:O55)","v":5030}]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J56,J50,J45,J40,J25)","v":44450},0,-44450,333706,0,333706,{"$f":"SUM(P25,P40,P50,P45,P56)","v":67210},{"$f":"SUM(Q50,Q40,Q25,Q45,Q56)","v":0},{"$f":"SUM(R50,R40,R25,R45,R56)","v":67210},{"$f":"SUM(S50,S40,S25,S45,S56)","v":114620}]

{"sheet":"Detailblatt II","index":8,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,3,31,4],[32,0,32,4],[21,0,21,15],[22,2,24,2],[25,3,25,4],[26,0,26,15],[27,0,27,4],[16,0,16,15],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,3,20,4],[11,0,11,3],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,3,15,4],[6,0,6,15],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[0,15,1,15],[2,0,2,15],[3,0,3,3],[4,0,4,3],[5,3,5,4],[0,8,0,10],[0,11,1,11],[0,12,1,12],[0,13,1,13],[0,14,1,14],[0,0,1,0],[0,1,1,1],[0,2,1,3],[0,4,1,4],[0,5,0,7]]}
["Detailblatt II","Jahr -",{"$f":"Deckblatt!B1","v":2026},null,"Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,null,null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Konferenz Sächsischer Studierendenschaften - Konto: 4981"]
["Verein zur Unterstützung der Konferenz Sächsischer Studierendenschaften e.V.",null,null,null,1,0,0,{"$f":"G4-F4","v":0},{"$f":"2500","v":2500},0,{"$f":"I4-J4","v":2500}]
["Weitere Förderung der KSS",null,null,null,1,0,0,{"$f":"G5-F5","v":0},{"$f":"500","v":500},0,{"$f":"I5-J5","v":500}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F4:F5)","v":0},0,0,3000,0,3000]
["Interessenvertretungen der Studentinnenschaften - Konto: 4982"]
["faranto e.V. und Erasmus Student Network",null,null,null,null,0,0,{"$f":"G8-F8","v":0},1200,0,{"$f":"I8-J8","v":1200}]
["bundesweite Interessenvertretungen (z.B. fzs etc.)",null,null,null,1,0,0,{"$f":"G9-F9","v":0},500,0,500]
["Bundesverband Ausländischer Studierender e. V.",null,null,null,1,0,0,{"$f":"G10-F10","v":0},100,0,100]
["Deutscher Akademischer Austausch Dienst e. V. ",null,null,null,1,0,0,0,60,0,60]
["Konferenz der Informatikfachschaften e. V. ",null,null,null,1,0,0,0,60,0,60]
["Konferenz der Geodäsie Studierenden e. V.",null,null,null,1,0,0,0,50,0,50]
["Bundesfachschaft Landschaft e. V.",null,null,null,1,0,0,0,60,0,60]
["weitere (ABS, bpm )",null,null,null,null,0,0,{"$f":"G15-F15","v":0},0,0,0]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F8:F15)","v":0},0,0,2030,0,2030]
["Durchführung Konferenzen - Konto: 4945"]
["O.S.T. Offenes Studierendentreffen (Bereich Bund/Land) /Hochschulpolitik",null,null,null,1,0,0,{"$f":"G18-F18","v":0},500,0,{"$f":"I18-J18","v":500},500,{"$f":"IF(K18<0,IF(L18>0,IF((K18*(-1))>L18,L18,K18*(-1)),0),0)","v":0},{"$f":"IF(OR(M18>L18,K18+L18<0),MAKRO1(),ROUNDDOWN(L18-M18,-1))","v":500},{"$f":"IF(K18>0,ROUNDDOWN(K18,-1),0)","v":500},{"$f":"(G18-J18+M18)-(F18-I18)","v":500}]
["BuFaTa",null,null,null,null,1500,0,{"$f":"G19-F19","v":-1500},2000,0,{"$f":"I19-J19","v":2000},2000,{"$f":"IF(K19<0,IF(L19>0,IF((K19*(-1))>L19,L19,K19*(-1)),0),0)","v":0},{"$f":"IF(OR(M19>L19,K19+L19<0),MAKRO1(),ROUNDDOWN(L19-M19,-1))","v":2000},{"$f":"IF(K19>0,ROUNDDOWN(K19,-1),0)","v":2000},{"$f":"(G19-J19+M19)-(F19-I19)","v":500}]
["weitere Konferenzen",null,null,null,null,0,0,{"$f":"G20-F20","v":0},1000,0,{"$f":"I20-J20","v":1000},1000,{"$f":"IF(K20<0,IF(L20>0,IF((K20*(-1))>L20,L20,K20*(-1)),0),0)","v":0},{"$f":"IF(OR(M20>L20,K20+L20<0),MAKRO1(),ROUNDDOWN(L20-M20,-1))","v":1000},{"$f":"IF(K20>0,ROUNDDOWN(K20,-1),0)","v":1000}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F18:F20)","v":1500},0,-1500,{"$f":"SUM(I18:I20)","v":3500},0,3500,3500,0,3500,3500,{"$f":"(G21-J21+M21)-(F21-I21)","v":2000}]
["Beitragseinnahmen"]
["Anteilig WS 25/26",26,"x Student:innen",4810,1,{"$f":"ROUND((($B$23*$D$23)/6)*2,-2)","v":41700},{"$f":"123526/6*2","v":41175.333333333336},{"$f":"G23-F23","v":-524.66666666666424},0,0,{"$f":"I23-J23","v":0}]
["SoSe 26",24.5,null,4200,1,{"$f":"ROUND($B$24*$D$24,-2)","v":102900},null,{"$f":"G24-F24","v":-102900},0,0,{"$f":"I24-J24","v":0}]
["Anteilig WS 26/27",24.5,null,4800,1,{"$f":"ROUND((($B$25*$D$25)/6)*4,-2)","v":78400},null,{"$f":"G25-F25","v":-78400},0,0,{"$f":"I25-J25","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F23:F25)","v":223000},41175.333333333336,-181824.66666666666,0,0,0]
["Vermögen"]
["Verfügbare finanzielle Mittel",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D9","v":244627.63999999966},null,{"$f":"G28-F28","v":-244627.63999999966},0,0,{"$f":"I28-J28","v":0}]
["angeordnete Vermögensänderung lt. FO",null,null,null,null,{"$f":"Deckblatt!C7","v":0},null,{"$f":"G29-F29","v":0},{"$f":"IF(F28<Mindestreserve!D18,Mindestreserve!D18-F28,0)","v":0},null,{"$f":"I29-J29","v":0}]
["Zinsen auf Vermögen",null,null,null,null,3000,0,{"$f":"G30-F30","v":-3000},800,0,{"$f":"I30-J30","v":800}]
["geplante Veränderung des Vermögens Ansparen/Entnahme",null,null,null,null,{"$f":"Deckblatt!C6*(-1)","v":-586},0,{"$f":"G31-F31","v":586},{"$f":"Deckblatt!F6","v":0},0,{"$f":"I31-J31","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F28:F31)","v":247041.63999999966},0,-247041.63999999966,800,0,800]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F26,F21,F16,F6)","v":224500},41175.333333333336,-183324.66666666666,8530,0,8530,3500,0,3500,3500,{"$f":"(G33-J33+M33)-(F33-I33)","v":-174794.66666666666}]

{"sheet":"Finanzen","index":9,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,2,1,2],[0,3,0,5],[0,6,0,8],[7,0,7,2]]}
["Referat Finanzen",null,"Häufigkeit","Einnahmen",null,null,"Ausgaben"]
[null,null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Kontoführung mit Onlinebanking","Sachkonto: 4970",12,0,0,{"$f":"E3-D3","v":0},600,0,{"$f":"G3-H3","v":600}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1100,0,{"$f":"G4-H4","v":1100}]
["Nebenkosten Zahlungsverkehr","Sachkonto: 4972",null,0,0,0,1100,0,{"$f":"G5-H5","v":1100}]
["Förderverein Student:innenschaft HTWD",null,1,0,0,0,200,0,{"$f":"G6-H6","v":200}]
["CoCo-Pauschale",null,null,0,0,{"$f":"E7-D7","v":0},250,0,{"$f":"G7-H7","v":250}]
["Gesamtsumme:",null,null,{"$f":"SUM(D3:D7)","v":0},0,0,3250,0,3250]

{"sheet":"Hochschulpolitik","index":10,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[7,8,7,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Hochschulpolitik","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Aktionstage gegen Sexismus und Homophobie",1,0,0,{"$f":"D3-C3","v":0},100,0,{"$f":"F3-G3","v":100},100,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":100},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":100},{"$f":"(D3-G3+J3)-(C3-F3)","v":100}]
["Aktionen, Festivals und Demonstrationen",null,0,0,0,1000,0,1000,1000,0,{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":1000},1000,{"$f":"(D4-G4+J4)-(C4-F4)","v":1000}]
["studentischer Hochschulrat/Hochschulversammlung",1,1400,0,-1400,1500,0,1500,990,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":990},1500,{"$f":"(D5-G5+J5)-(C5-F5)","v":100}]
["Förderverein HTW Dresden - Mitgliedsbeitrag",1,0,0,0,150,0,150,0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":0},150,{"$f":"(D6-G6+J6)-(C6-F6)","v":150}]
["politische Bildung / Umweltbildung",null,0,0,0,1300,0,1300,1000,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":1000},1300,{"$f":"(D7-G7+J7)-(C7-F7)","v":1300}]
["CoCo-Pauschale",null,0,0,0,250,0,250,null,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":0},250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C8)","v":1400},0,-1400,4300,0,4300,3090,0,3090,4300,{"$f":"(D9-G9+J9)-(C9-F9)","v":2900}]

{"sheet":"Internationales","index":11,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[4,8,4,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Internationales","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Internationaler Tag",1,0,0,{"$f":"D3-C3","v":0},100,0,{"$f":"F3-G3","v":100},100,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":100},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":100},{"$f":"(D3-G3+J3)-(C3-F3)","v":100}]
["Informations- und und Unterstützungsveranstaltungen zu Auslandsstudien",2,0,0,{"$f":"D4-C4","v":0},1000,0,{"$f":"F4-G4","v":1000},0,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":0},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":1000},{"$f":"(D4-G4+J4)-(C4-F4)","v":1000}]
["CoCo-Pauschale",null,0,0,{"$f":"D5-C5","v":0},250,0,{"$f":"F5-G5","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,1350,0,1350,100,0,100,1100,{"$f":"(D6-G6+J6)-(C6-F6)","v":1350}]

{"sheet":"Kultur","index":12,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[13,8,13,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Kultur","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Kino in der Hochschule",null,800,0,{"$f":"D3-C3","v":-800},800,0,{"$f":"F3-G3","v":800},540,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":540},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":800},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Erstifahrten",null,4000,0,-4000,4000,0,4000,4000,0,{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":4000},4000,0]
["Semestereröffnungspartys (SEP)",2,5000,0,-5000,5000,0,5000,2630,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":2630},5000,0]
["Semesterabschlussfeier (SAF)",2,4500,0,-4500,4500,0,4500,2270,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":2270},4500,0]
["Weihnachtsfeiern",null,3000,0,-3000,3500,0,3500,3460,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":3460},3500,500]
["Fakultätsfeste & Sommerfeste",null,7100,0,-7100,7600,0,7600,3780,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":3780},7600,500]
["LAN-Partys",null,250,0,-250,250,0,250,250,0,{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":250},250,0]
["Musikveranstaltung",1,250,0,-250,250,0,250,250,0,{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":250},250,0]
["Literatur",null,150,0,-150,250,0,250,250,0,{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":250},250,100]
["Spieleabende",2,300,0,-300,500,0,500,500,0,{"$f":"IF(OR(J12>I12,H12+I12<0),MAKRO1(),ROUNDDOWN(I12-J12,-1))","v":500},500,200]
["Vernetzung von Student:innen der Hochschule",null,1500,0,-1500,1500,0,1500,1000,0,{"$f":"IF(OR(J13>I13,H13+I13<0),MAKRO1(),ROUNDDOWN(I13-J13,-1))","v":1000},1500,0]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C14)","v":26850},0,-26850,28400,0,28400,18930,0,18930,28150,{"$f":"(D15-G15+J15)-(C15-F15)","v":1550}]

{"sheet":"Öffentlichkeitsarbeit","index":13,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[6,0,6,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Öffentlichkeitsarbeit","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Hochschul- und Vorstellungsveranstaltungen",null,0,0,{"$f":"D3-C3","v":0},500,0,{"$f":"F3-G3","v":500},500,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":500},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Werbemittel (Kulis, Plakate etc.)",null,0,0,{"$f":"D4-C4","v":0},3000,0,{"$f":"F4-G4","v":3000},2560,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":2560},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":3000},{"$f":"(D4-G4+J4)-(C4-F4)","v":3000}]
["Beutel Erstsemestereinführung (ESE Beutel)",null,0,0,{"$f":"D5-C5","v":0},5000,0,{"$f":"F5-G5","v":5000},0,{"$f":"IF(H5<0,IF(I5>0,IF((H5*(-1))>I5,I5,H5*(-1)),0),0)","v":0},{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":0},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":5000},{"$f":"(D5-G5+J5)-(C5-F5)","v":5000}]
["CoCo-Pauschale",null,0,0,{"$f":"D6-C6","v":0},250,0,{"$f":"F6-G6","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C6)","v":0},0,0,8750,0,8750,3060,0,3060,8500,{"$f":"(D7-G7+J7)-(C7-F7)","v":8750}]

{"sheet":"Qualitätsmanagement","index":14,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[4,8,4,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Qualitätsmanagement","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Veranstaltung Erstsemestereinführung (ESE)",1,1500,0,{"$f":"D3-C3","v":-1500},3000,0,{"$f":"F3-G3","v":3000},900,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":900},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":3000},{"$f":"(D3-G3+J3)-(C3-F3)","v":1500}]
["Systemakkreditierung",null,0,0,{"$f":"D4-C4","v":0},0,0,{"$f":"F4-G4","v":0},0,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":0},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["CoCo-Pauschale",null,0,0,{"$f":"D5-C5","v":0},250,0,{"$f":"F5-G5","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":1500},0,-1500,3250,0,3250,900,0,900,3000,{"$f":"(D6-G6+J6)-(C6-F6)","v":1750}]

{"sheet":"Soziales","index":15,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[4,8,4,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Soziales","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Informationsveranstaltungen und Beratungen zu sozialen Belangen",null,0,0,{"$f":"D3-C3","v":0},300,0,{"$f":"F3-G3","v":300},300,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":300},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":300},{"$f":"(D3-G3+J3)-(C3-F3)","v":300}]
["Vortrag Mietrecht",2,0,0,{"$f":"D4-C4","v":0},500,0,{"$f":"F4-G4","v":500},500,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":500},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":500},{"$f":"(D4-G4+J4)-(C4-F4)","v":500}]
["CoCo-Pauschale",null,0,0,{"$f":"D5-C5","v":0},250,0,{"$f":"F5-G5","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,1050,0,1050,800,0,800,800,{"$f":"(D6-G6+J6)-(C6-F6)","v":1050}]

{"sheet":"Sport","index":16,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[9,8,9,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Sport","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Turniere, Preise, Beiträge",null,300,0,{"$f":"D3-C3","v":-300},800,0,{"$f":"F3-G3","v":800},500,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":500},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":800},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Nikolausvolleyballturnier",1,200,0,-200,300,0,300,1000,0,{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":1000},300,100]
["Startgebühren",null,0,0,0,600,0,600,200,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":200},600,600]
["Beachfeier",null,1000,0,-1000,1000,0,1000,1000,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":1000},1000,0]
["Gesundheitsmanagement ",1,0,0,0,0,0,0,500,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":500},0,0]
["Ausflüge",1,0,0,0,0,0,0,500,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":500},0,0]
["Sportevents (Eislaufen, Lasertag, Trampolinpark)",null,2000,0,-2000,2500,0,2500,2500,0,{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":2500},2500,500]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C10)","v":3500},0,-3500,5450,0,5450,6200,0,6200,5200,{"$f":"(D11-G11+J11)-(C11-F11)","v":1950}]

{"sheet":"Studium","index":17,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[4,8,4,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Studium","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Veranstaltung lange Nacht des Studierens",1,0,0,{"$f":"D3-C3","v":0},500,0,{"$f":"F3-G3","v":500},500,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":500},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Rechtskosten Prüfungsangelegenheiten",null,0,0,{"$f":"D4-C4","v":0},750,0,{"$f":"F4-G4","v":750},750,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":750},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":750},{"$f":"(D4-G4+J4)-(C4-F4)","v":750}]
["CoCo-Pauschale",null,0,0,{"$f":"D5-C5","v":0},{"$f":"250-250","v":0},0,{"$f":"F5-G5","v":0}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,1250,0,1250,1250,0,1250,1250,{"$f":"(D6-G6+J6)-(C6-F6)","v":1250}]

{"sheet":"Verwaltung@","index":18,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[15,8,15,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Verwaltung","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig \nverwendbares \nVj. Budget","davon verwendet","Zuführung \"Fortgeschr. \nfinanz. Mittel\"","Übertrag ins \nnächste HH-\nJahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Simkarten",null,0,0,{"$f":"D3-C3","v":0},180,0,{"$f":"F3-G3","v":180},80,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":80},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":180},{"$f":"(D3-G3+J3)-(C3-F3)","v":180}]
["Domains",null,0,0,{"$f":"D4-C4","v":0},80,0,{"$f":"F4-G4","v":80},60,0,{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":60},80,80]
["Beitrag Gruppenausweis für Jugendherbergen",1,0,0,{"$f":"D5-C5","v":0},26,0,{"$f":"F5-G5","v":26},20,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":20},20,26]
["Versicherung Beachvolleyballplätze",null,0,0,{"$f":"D6-C6","v":0},400,0,{"$f":"F6-G6","v":400},140,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":140},400,400]
["Aufbau drittes Feld Beachvolleyballplätze",null,6000,0,-6000,6000,0,6000,6000,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":6000},6000,0]
["Dienste für elektronische Datenverarbeitung ",null,0,0,0,15000,0,{"$f":"F8-G8","v":15000},0,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":0},15000,15000]
["andauernde Betreuung Server durch Externe",null,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":0},0,0]
["Zugangskarten Verwaltungsräume",null,0,0,0,330,0,330,0,0,{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":0},330,330]
["Büromaterial und -ausstattung",null,0,0,{"$f":"D11-C11","v":0},600,0,600,390,0,{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":390},600,600]
["Getränkeautomat",null,1000,0,-1000,900,0,900,320,0,{"$f":"IF(OR(J12>I12,H12+I12<0),MAKRO1(),ROUNDDOWN(I12-J12,-1))","v":320},900,-100]
["laufende Kosten für Druck, samt Nebenkosten",null,0,0,0,550,0,550,150,0,{"$f":"IF(OR(J13>I13,H13+I13<0),MAKRO1(),ROUNDDOWN(I13-J13,-1))","v":150},550,550]
["Studienmaterial (z. B. Laborkittel)",null,2700,0,-2700,2700,0,2700,2700,0,{"$f":"IF(OR(J14>I14,H14+I14<0),MAKRO1(),ROUNDDOWN(I14-J14,-1))","v":2700},2700,0]
["Canva Pro",null,0,0,{"$f":"D15-C15","v":0},110,0,{"$f":"F15-G15","v":110},0,{"$f":"IF(H15<0,IF(I15>0,IF((H15*(-1))>I15,I15,H15*(-1)),0),0)","v":0},{"$f":"IF(OR(J15>I15,H15+I15<0),MAKRO1(),ROUNDDOWN(I15-J15,-1))","v":0},{"$f":"IF(H15>0,ROUNDDOWN(H15,-1),0)","v":110},{"$f":"(D15-G15+J15)-(C15-F15)","v":110}]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C16)","v":9700},0,-9700,27126,0,27126,9860,0,9860,26870,{"$f":"(D17-G17+J17)-(C17-F17)","v":17426}]

{"sheet":"Personal","index":19,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[12,0,12,12],[19,8,19,11],[20,0,20,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[2,0,2,12],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8]]}
["Referat Personal","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Schulungen"]
["Akkreditierung / Qualitätsmanagement",null,0,0,{"$f":"D4-C4","v":0},1800,0,{"$f":"F4-G4","v":1800},1800,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":1800},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":1800},{"$f":"(D4-G4+J4)-(C4-F4)","v":1800}]
["Veranstaltung zu Erste Hilfe / Qualitästmanagement",null,0,0,{"$f":"D5-C5","v":0},500,0,{"$f":"F5-G5","v":500},500,{"$f":"IF(H5<0,IF(I5>0,IF((H5*(-1))>I5,I5,H5*(-1)),0),0)","v":0},{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":500},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":500},{"$f":"(D5-G5+J5)-(C5-F5)","v":500}]
["Sozialberatung (BAföG, Jobberatung) / Soziales",null,0,0,0,250,0,250,250,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":250},250,250]
["studentische und akademische Selbstverwaltung (Studienprüfungsordnung) / Studium",null,0,0,0,100,0,100,100,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":100},100,100]
["Prüfungsangelegenheiten / Studium",null,0,0,0,250,0,250,250,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":250},250,250]
["pol. Bildung, Antidiskriminierung, Gleichstellung / Hochschulpolitik",null,0,0,0,100,0,100,100,0,{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":100},100,100]
["Serverbetreuung / Administration und Rechentechnik",null,0,0,{"$f":"D10-C10","v":0},1000,0,{"$f":"F10-G10","v":1000},0,{"$f":"IF(H10<0,IF(I10>0,IF((H10*(-1))>I10,I10,H10*(-1)),0),0)","v":0},{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":0},{"$f":"IF(H10>0,ROUNDDOWN(H10,-1),0)","v":1000},{"$f":"(D10-G10+J10)-(C10-F10)","v":1000}]
["interne Seminare (KoSe, LuISe, ClaRa)",3,0,0,0,1150,0,1150,820,0,{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":820},1150,1150]
["Veranstaltung zur fachlichen Weiterbildung / \nStudium",null,0,0,0,250,0,250,250,0,{"$f":"IF(OR(J12>I12,H12+I12<0),MAKRO1(),ROUNDDOWN(I12-J12,-1))","v":250},250,250]
["Allgemeines"]
["Informationen zu Kandidierenden",null,0,0,{"$f":"D14-C14","v":0},0,0,{"$f":"F14-G14","v":0},0,{"$f":"IF(H14<0,IF(I14>0,IF((H14*(-1))>I14,I14,H14*(-1)),0),0)","v":0},{"$f":"IF(OR(J14>I14,H14+I14<0),MAKRO1(),ROUNDDOWN(I14-J14,-1))","v":0},{"$f":"IF(H14>0,ROUNDDOWN(H14,-1),0)","v":0},{"$f":"(D14-G14+J14)-(C14-F14)","v":0}]
["auswärtige Arbeitstreffen und Tagungen",null,0,0,{"$f":"D15-C15","v":0},2000,0,2000,2000,0,{"$f":"IF(OR(J15>I15,H15+I15<0),MAKRO1(),ROUNDDOWN(I15-J15,-1))","v":2000},2000,2000]
["Integration (Veranstaltungen zum internen Zusammenhalt)",null,0,0,{"$f":"D16-C16","v":0},500,0,500,340,0,{"$f":"IF(OR(J16>I16,H16+I16<0),MAKRO1(),ROUNDDOWN(I16-J16,-1))","v":340},500,500]
["StuRa Vollversammlung",2,0,0,{"$f":"D17-C17","v":0},1000,0,{"$f":"F17-G17","v":1000},0,0,{"$f":"IF(OR(J17>I17,H17+I17<0),MAKRO1(),ROUNDDOWN(I17-J17,-1))","v":0},1000,1000]
["StuRa Bekleidung",null,0,0,0,2000,0,2000,150,0,{"$f":"IF(OR(J18>I18,H18+I18<0),MAKRO1(),ROUNDDOWN(I18-J18,-1))","v":150},2000,2000]
["Kennenlern-Veranstaltungen ",2,0,0,0,750,0,750,560,0,{"$f":"IF(OR(J19>I19,H19+I19<0),MAKRO1(),ROUNDDOWN(I19-J19,-1))","v":560},750,750]
["CoCo-Pauschale",null,0,0,{"$f":"D20-C20","v":0},250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C4:C20)","v":0},0,0,11900,0,11900,7120,0,7120,11650,{"$f":"(D21-G21+J21)-(C21-F21)","v":11900}]