{"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",2025,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J56","v":40750},{"$f":"'Detailblatt I'!K56","v":8816.6299999999992},{"$f":"D3-C3","v":-31933.370000000003},{"$f":"'Detailblatt I'!M56","v":317256},{"$f":"'Detailblatt I'!N56","v":80995.66},{"$f":"(F3-G3)","v":236260.34}]
["Beitragseinnahmen der Studentinnen",null,{"$f":"'Detailblatt II'!F26","v":223200},{"$f":"'Detailblatt II'!G26","v":36125.333333333336},-187074.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":0},{"$f":"'Detailblatt II'!G30","v":1574.45},1574.45,{"$f":"'Detailblatt II'!I30","v":0},{"$f":"'Detailblatt II'!J30","v":0},{"$f":"(F5-G5)","v":0}]
["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":0},0,0,6934,{"$f":"'Detailblatt II'!G31","v":0},{"$f":"(F6-G6)","v":6934}]
["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,60240,{"$f":"C8","v":60240},0]
[]
["Gesamt:",null,{"$f":"SUM(C3:C9)","v":324190},106756.41333333333,-217433.58666666664,324190,80995.66,243194.34]
["Berechnung des Semesterbeitrages:"]
[null,"Planausgaben:",{"$f":"F10","v":324190},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":40750}]
["-","Zurückführung:",{"$f":"C8+C9","v":60240}]
["-","Vermögensänderung",{"$f":"C7","v":0}]
["=","Gesamt:",{"$f":"C12-C13-C14-C15-F6","v":216266}]
["/","Beitragszahlungen/Jahr:",{"$f":"'Detailblatt II'!D24+('Detailblatt II'!D25/6*4)","v":7198.6666666666661}]
["=","Stud./Semester:",{"$f":"IF((C16-'Detailblatt II'!F23)/Deckblatt!C17<0,0,(C16-'Detailblatt II'!F23)/Deckblatt!C17)","v":25.027690313020933},"Anzusetzender Semesterbeitrag:",null,{"$f":"ROUND((C18*2),0)/2","v":25}]

{"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":257016}]
["verfügbare finanzielle Mittel",{"$f":"'fortgeschr. Mittel+Konto'!D9","v":237211.71999999974}]
["Obergrenze finanzielle Mittel",{"$f":"IF(B3<B4,B3,B4)","v":237211.71999999974}]
[]
["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":177910}]
["(Verfügbare finanzielle Mittel nach Vermögenssenkung)",{"$f":"B4-B7","v":237211.71999999974}]
["Untergrenze für verfügbare finanzielle Mittel durch Bemessung an der Mindestreserve wird erreicht",{"$f":"IF(B5<B8,B8,B5)","v":237211.71999999974}]
["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":180166}]

{"sheet":"Berechnung Lohnkosten","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,4],[2,6,2,7],[2,9,2,10],[2,12,2,13]]}
["Berechnung der anfallenden Lohnkosten in Abhängigkeit der besetzten Stellen"]
[]
["langfristige Stellen",null,null,null,null,null,"mittelfristige Stellen – vor SoSe 25",null,null,"mittelfristige Stellen – ab SoSe 25",null,null,"Besetzungsgrad mittelfristige Stellen"]
[null,"Fina. u. Verw.","Assi. d. GF.","Assi. d. GF","Einarb. Assi. d. GF",null,null,null,null,null,null,null,"max. mögliche Stellen h/M",{"$f":"20*40","v":800}]
["TVL (50%)","E7 Stufe 4","E9b Stufe 4","E9b Stufe 4","E9b Stufe 4",null,null,null,null,null,null,null,"geschaffene Stellen h/M",560]
["Vertragsdauer","unbefristet",2025,"01.2025 - 06.2025","07.2025 - 12.2025",null,"Brutto je Stunde",13.25,null,"Brutto je Stunde",13.98,null,"„Schaffungsgrad“",{"$f":"N5/N4","v":0.7}]
["Bruttoverdienst",{"$f":"3678.84/2","v":1839.42},{"$f":"4366.72/2","v":2183.36},{"$f":"4366.72/2","v":2183.36},{"$f":"4366.72/2","v":2183.36},null,"Brutto pro Monat",{"$f":"H6*40","v":530},null,"Brutto pro Monat",{"$f":"K6*40","v":559.20000000000005},null,"voraussichtlicher Besetzungsgrad",0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"entspricht besetzte Stellen h/M",{"$f":"N7*N5","v":336}]
["Nebenkosten",null,null,null,null,null,"Nebenkosten",null,null,"Nebenkosten"]
["Rentenversicherung",146.97999999999999,163.71,163.71,163.71,null,"15% Rentenvers. Pauschal",{"$f":"H$7*0.15","v":79.5},null,"15% Rentenvers. Pauschal",{"$f":"K$7*0.15","v":83.88000000000001}]
["Arbeitslosenversicherung",18.97,21.12,21.12,21.12,null,"13% Krankenvers. Pauschal",{"$f":"H$7*0.13","v":68.900000000000006},null,"13% Krankenvers. Pauschal",{"$f":"K$7*0.13","v":72.696000000000012}]
["Krankenversicherung",125.64,139.94,139.94,139.94,null,"2% Steuerpauschale",{"$f":"H$7*0.02","v":10.6},null,"2% Steuerpauschale",{"$f":"K$7*0.02","v":11.184000000000001}]
["Pflegeversicherung",16.2,18.04,18.04,18.04,null,"0,9% Umlage 1 U1",{"$f":"H$7*0.009","v":4.7699999999999996},null,"0,9% Umlage 1 U1",{"$f":"K$7*0.009","v":5.0327999999999999}]
["Umlage U1",31.61,35.21,35.21,35.21,null,"0,29% Umlage 2 U2",{"$f":"H$7*0.0029","v":1.5369999999999999},null,"0,29% Umlage 2 U2",{"$f":"K$7*0.0029","v":1.62168}]
["Umlage U2",5.53,6.16,6.16,6.16,null,"0,06% Umlage 3 U3",{"$f":"H$7*0.0006","v":0.31799999999999995},null,"0,06% Umlage 3 U3",{"$f":"K$7*0.0006","v":0.33551999999999998}]
["Umlage U3",2.37,2.64,2.64,2.64,null,"1,3% Unfallversicherung",{"$f":"H$7*0.013","v":6.89},null,"1,3% Unfallversicherung",{"$f":"K$7*0.013","v":7.2696000000000005}]
["Unfallversicherung (BG)",25.29,28.16,28.16,28.16]
["Summe Lohnnebenk. ",{"$f":"SUM(B10:B17)","v":372.59},{"$f":"SUM(C10:C17)","v":414.98},{"$f":"SUM(D10:D17)","v":414.98},{"$f":"SUM(E10:E17)","v":414.98},null,"Summe Lohnnebenk. ",{"$f":"SUM(H10:H16)","v":172.51500000000001},null,"Summe Lohnnebenk. ",{"$f":"SUM(K10:K16)","v":182.01960000000003}]
[]
["Bruttolohnkosten monatl.",{"$f":"B7+B18","v":2212.0100000000002},{"$f":"C7+C18","v":2598.34},{"$f":"D7+D18","v":2598.34},{"$f":"E7+E18","v":2598.34},null,"Bruttolohnkosten monatl.",{"$f":"H18+H7","v":702.51499999999999},null,"Bruttolohnkosten monatl.",{"$f":"K18+K7","v":741.21960000000013}]
["Jahressonderzahlung",{"$f":"B20*0.8814","v":1949.665614},{"$f":"C20*0.8814","v":2290.176876},{"$f":"D20*0.8814","v":2290.176876},{"$f":"E20*0.8814","v":2290.176876}]
[]
[]
[]
["Bruttolohnkosten jährl.",{"$f":"B20*12+B21","v":28493.785614000004},{"$f":"C20*12+C21","v":33470.256875999999},{"$f":"D20*6+D21","v":17880.216876000002},{"$f":"E20*6+E21","v":17880.216876000002},null,null,{"$f":"(H20*(N8/40))*3+H21","v":17703.378000000001},null,null,{"$f":"(K20*(N8/40))*9","v":56036.201760000018},null,"Kosten Lohnbüro jährl.",3000]
[]
["Jahresgesamtkosten",{"$f":"H25+B25+C25+E25+K25+N25+D25","v":174464.05600200003}]

{"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":2025},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":-177910}]
[null,"Planausgaben",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$O$56)","v":-236628.22999999998}]
[null,"nachrangig verwendbares Vorjahresbudget",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$P$56)","v":-63470}]
[null,"->davon verwendet",null,null,null,null,null,null,null,{"$f":"'Detailblatt I'!$Q$56","v":0}]
[null,"bereinigter Geldbestand",null,null,null,null,null,null,null,{"$f":"SUM(J13:J17)","v":-478008.23}]
[null,"Planeinnahmen",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$L$56)","v":31933.37}]
[null,"voraussichtliche Beitragseinnahmen",null,null,null,null,null,null,null,{"$f":"-('Detailblatt II'!$H$25)","v":77100}]
[null,"voraussichtlicher bereinigter Geldbestand",null,null,null,null,null,null,null,{"$f":"SUM(J18:J20)","v":-368974.86}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand",null,null,null,null,null,null,null,{"$f":"J18+J19","v":-446074.86}]
[null,"neuer Semesterbeitrag",null,null,null,null,null,null,null,{"$f":"ROUNDUP(-(J22/'Detailblatt II'!$D$25/4*6)/5,1)*5","v":150.5}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand bei 50% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J18+J19/2","v":-462041.54499999998}]
[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":156}]
[null,"voraussichtlicher bereinigter Geldbestand bei 50% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J24+J20","v":-384941.54499999998}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand bei 25% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J18+J19/4","v":-470024.88749999995}]
[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":158.5}]
[null,"voraussichtlicher bereinigter Geldbestand bei 25% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J27+J20","v":-392924.88749999995}]

{"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":2025}]
[null,null,null,null,null,"Nr.","voraussichtliche Ausgaben",null,"Saldo"]
[null,"Position","erstellt am:","2024-11-18",null,"1.","Personal (Okt.+Nov.+Dez. inkl. 13.Gehalt, ACON, Finanzamt)",null,45000]
[null,"Bank-/Kassenbestand bei Haushaltsplanerstellung",null,{"$f":"10912.12+191+155.33+31+66672.21+1221166.43+4230.97","v":1303359.0599999998}]
["-","abzgl. voraussichtliche Ausgaben in",{"$f":"D1-1","v":2024},{"$f":"I25*(-1)","v":-906337.34000000008},null,"2.","Finanzbeschlüsse aktuell noch nicht bezahlt in Summe",null,18517.28]
["-","nachrangig verwendbares Vorjahresbudget",null,{"$f":"'Detailblatt I'!P56*(-1)-'Detailblatt I'!Q56*(-1)","v":-63470}]
["-","Zurückführung an Student:innen gesamt",null,{"$f":"SUM(Deckblatt!C8:C9)*-1","v":-60240},null,"3.","Schulungen/Konferenzen (KoSe)",null,0]
["-","Beitragseinnahmen anteilig WS 24/25 für 2025",null,{"$f":"'Detailblatt II'!F23*-1","v":-36100},null,"4.","voraussichtliche AE",null,17000]
["=","verfügbare finanzielle Mittel",null,{"$f":"D4+D5+D6+D7+D8","v":237211.71999999974},null,"5.","offene Härtefallanträge",null,0]
[null,null,null,null,null,"6.","Software-Abos (AGENDA etc.)",null,270]
[null,null,null,null,null,"7.","Kosten für Wartung (Drucker etc.)",null,70]
[null,null,null,null,null,"8.","Kontoführung",null,120]
[null,null,null,null,null,"9.","Kino in der HTW & Co.",null,100]
[null,null,null,null,null,"10.","Kosten für Wahlen",null,0]
[null,null,null,null,null,"11.","Kaffeebestellung(en)",null,270]
[null,null,null,null,null,"12.","Ersatz- & Neuanschaffung",null,{"$f":"1020-192.84","v":827.16}]
[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":"74819.25+748343.65","v":823162.9}]
[]
[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":906337.34000000008}]

{"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":2025},"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":175000}]
["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@'!F14","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":177910}]

{"sheet":"Detailblatt I","index":7,"n_rows":56,"n_cols":20,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,8],[49,0,49,18],[50,1,50,8],[50,9,54,11],[50,15,54,18],[51,1,51,8],[52,1,52,8],[53,1,53,8],[54,0,54,8],[44,0,44,18],[45,0,45,4],[45,9,48,11],[45,12,46,14],[45,15,46,18],[46,0,46,4],[46,5,46,6],[46,7,46,8],[47,0,47,7],[48,0,48,8],[36,1,36,8],[37,1,37,8],[38,0,38,8],[39,0,39,18],[40,1,40,8],[40,9,43,11],[40,15,43,18],[41,1,41,8],[42,1,42,8],[43,0,43,8],[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,0,23,8],[24,0,24,18],[25,1,25,8],[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],[14,1,14,8],[15,1,15,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":2025},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,367.89,{"$f":"K5","v":367.89}]
[4120,null,"Gehälter ",null,null,null,null,null,null,null,null,null,175000,45249.61,{"$f":"M6-SUM(N6:N11)+L5","v":103225.29}]
[4121,null,"Lohnsteuer",null,null,null,null,null,null,null,null,null,null,2563.64]
[4170,null,"Vermögenswirksame Leistungen",null,null,null,null,null,null,null,null,null,null,0]
[4130,null,"gesetzl. sozial. Aufw.",null,null,null,null,null,null,null,null,null,null,22924.44]
[4138,null,"Beitrag BG (Berufsgenossenschaft)",null,null,null,null,null,null,null,null,null,null,266.08]
[4956,null,"Lohnbüro",null,null,null,null,null,null,null,null,null,null,1138.83]
[4110,"AE (Aufwandsentschädigungen)",null,null,null,null,null,null,null,null,null,null,20000,0,{"$f":"M12-N12","v":20000}]
[null,"Sitzungsgeld",null,null,null,null,null,null,null,null,null,null,18000,0,18000]
[4640,"Kaffee, Verpflegung & Verbrauchsgüter",null,null,null,null,null,null,null,null,null,null,1500,640.91,859.09]
[4670,"Allgemeine Reisekosten (keiner Veranstaltung zugeordnet)",null,null,null,null,null,null,null,null,null,null,500,0,500]
[4909,"Präsidium & Vorstand",null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Karten Semesterticket",null,null,null,null,null,null,null,null,null,null,200,0,200]
[4930,"Büro- und Verbrauchsmaterialien",null,null,null,null,null,null,null,null,null,null,100,0,100,100,{"$f":"IF(O18<0,IF(P18>0,IF((O18*(-1))>P18,P18,O18*(-1)),0),0)","v":0},{"$f":"IF(OR(Q18>P18,O18+P18<0),MAKRO1(),ROUNDDOWN(P18-Q18,-1))","v":100},{"$f":"IF(O18>0,ROUNDDOWN(O18,-1),0)","v":100}]
[4943,"Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,2000,0,2000,2000,{"$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":2000},{"$f":"IF(O19>0,ROUNDDOWN(O19,-1),0)","v":2000}]
[4944,"Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,250,0,250,250,{"$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":250},{"$f":"IF(O20>0,ROUNDDOWN(O20,-1),0)","v":250}]
[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},"← Zahlen auf Detailblatt 2 ändern!"]
[4950,"Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,3000,0,{"$f":"M22-N22","v":3000},3000,{"$f":"IF(O22<0,IF(P22>0,IF((O22*(-1))>P22,P22,O22*(-1)),0),0)","v":0},{"$f":"IF(OR(Q22>P22,O22+P22<0),MAKRO1(),ROUNDDOWN(P22-Q22,-1))","v":3000},{"$f":"IF(O22>0,ROUNDDOWN(O22,-1),0)","v":3000}]
[4989,"Ersatz- und Neuanschaffung",null,null,null,null,null,null,null,null,null,null,3000,1128.51,{"$f":"M23-N23","v":1871.49},2090,{"$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":2090},{"$f":"IF(O23>0,ROUNDDOWN(O23,-1),0)","v":1870}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J5:J23)","v":1500},367.89,-1132.1100000000001,227050,73912.02,153505.86999999997,{"$f":"SUM(P18:P23)","v":10940},{"$f":"SUM(Q18:Q23)","v":0},{"$f":"SUM(R18:R23)","v":10940},{"$f":"SUM(S18:S23)","v":10720}]
["Referate"]
[4960,"Finanzen",null,null,null,null,null,null,null,{"$f":"Finanzen!D8","v":0},{"$f":"Finanzen!E8","v":0},{"$f":"K26-J26","v":0},{"$f":"Finanzen!G8","v":3250},{"$f":"Finanzen!H8","v":882.93000000000006},{"$f":"M26-N26","v":2367.0699999999997}]
[4961,"Hochschulpolitik",null,null,null,null,null,null,null,{"$f":"Hochschulpolitik!C8","v":0},{"$f":"Hochschulpolitik!D8","v":0},0,{"$f":"Hochschulpolitik!F8","v":2500},{"$f":"Hochschulpolitik!G8","v":150},2350,{"$f":"Hochschulpolitik!I8","v":1000},{"$f":"Hochschulpolitik!J8","v":0},{"$f":"Hochschulpolitik!K8","v":1000},{"$f":"Hochschulpolitik!L8","v":2100}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C5","v":0},{"$f":"Internationales!D5","v":0},0,{"$f":"Internationales!F5","v":350},{"$f":"Internationales!G5","v":0},350,{"$f":"Internationales!I5","v":50},{"$f":"Internationales!J5","v":0},{"$f":"Internationales!K5","v":50},{"$f":"Internationales!L5","v":100}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C16","v":25450},{"$f":"Kultur!D16","v":8033.1900000000005},-17416.809999999998,{"$f":"Kultur!F16","v":27500},{"$f":"Kultur!G16","v":3800.87},23699.13,{"$f":"Kultur!I16","v":15390},{"$f":"Kultur!J16","v":0},{"$f":"Kultur!K16","v":15390},{"$f":"Kultur!L16","v":23430}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C8","v":0},{"$f":"Öffentlichkeitsarbeit!D8","v":0},0,{"$f":"Öffentlichkeitsarbeit!F8","v":7750},{"$f":"Öffentlichkeitsarbeit!G8","v":35.99},7714.01,{"$f":"Öffentlichkeitsarbeit!I8","v":2270},{"$f":"Öffentlichkeitsarbeit!J8","v":0},{"$f":"Öffentlichkeitsarbeit!K8","v":2270},{"$f":"Öffentlichkeitsarbeit!L8","v":7460}]
[4965,"Qualitätsmanagement",null,null,null,null,null,null,null,{"$f":"Qualitätsmanagement!C7","v":0},{"$f":"Qualitätsmanagement!D7","v":0},0,{"$f":"Qualitätsmanagement!F7","v":1250},{"$f":"Qualitätsmanagement!G7","v":0},1250,{"$f":"Qualitätsmanagement!I7","v":690},{"$f":"Qualitätsmanagement!J7","v":0},{"$f":"Qualitätsmanagement!K7","v":690},{"$f":"Qualitätsmanagement!L7","v":1000}]
[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":0},{"$f":"Soziales!J6","v":0},{"$f":"Soziales!K6","v":0},{"$f":"Soziales!L6","v":800}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C14","v":4100},{"$f":"Sport!D14","v":0},-4100,{"$f":"Sport!F14","v":6450},{"$f":"Sport!G14","v":0},6450,{"$f":"Sport!I14","v":3650},{"$f":"Sport!J14","v":0},{"$f":"Sport!K14","v":3650},{"$f":"Sport!L14","v":6200}]
[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":750},{"$f":"Studium!J6","v":0},{"$f":"Studium!K6","v":750},{"$f":"Studium!L6","v":1250}]
[4969,"Studentische Selbstverwaltung & Organisation",null,null,null,null,null,null,null,{"$f":"'Verwaltung@'!C17","v":9700},{"$f":"'Verwaltung@'!D17","v":415.55},-9284.4500000000007,{"$f":"'Verwaltung@'!F17","v":11586},{"$f":"'Verwaltung@'!G17","v":472.35},11113.65,{"$f":"'Verwaltung@'!I17","v":17960},{"$f":"'Verwaltung@'!J17","v":0},{"$f":"'Verwaltung@'!K17","v":17960},{"$f":"'Verwaltung@'!L17","v":4700}]
[4946,"Personal",null,null,null,null,null,null,null,{"$f":"Personal!C19","v":0},{"$f":"Personal!D19","v":0},0,{"$f":"Personal!F19","v":8250},{"$f":"Personal!G19","v":413.69},7836.31,{"$f":"Personal!I19","v":5150},{"$f":"Personal!J19","v":0},{"$f":"Personal!K19","v":5150},{"$f":"Personal!L19","v":7570}]
["----","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(J26:J38)","v":39250},8448.74,-30801.26,71186,5755.83,65430.17,{"$f":"SUM(P27:P36)","v":46910},{"$f":"SUM(Q27:Q36)","v":0},{"$f":"SUM(R27:R36)","v":46910},{"$f":"SUM(S27:S36)","v":54610}]
["Ausschüsse der Studentinnenschaft"]
["----","weitere Ausschüsse der Student:innenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M41-N41","v":0}]
["----","Wahlausschuss der Student:innenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M42-N42","v":0}]
[4941,"HFA (Härtefallausschuss der Student:innenschaft)",null,null,null,null,null,null,null,null,null,null,4500,921.84,{"$f":"M43-N43","v":3578.16}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M41:M43)","v":4500},{"$f":"SUM(N41:N43)","v":921.84},{"$f":"SUM(O41:O43)","v":3578.16}]
[]
["Anzahl der Studentinnen im:",null,null,null,null,"WiSe","25/26","SoSe",25]
["gesamt:",null,null,null,null,{"$f":"'Detailblatt II'!D25","v":4450},null,{"$f":"'Detailblatt II'!D24","v":4232}]
["#4942 Absicherung Teilnahme BuFaTas lt. Finanzordnung:",null,null,null,null,null,null,null,0.75,null,null,null,{"$f":"ROUND(($F$47+$H$47)*$I$48,-2)","v":6500},340,{"$f":"M48-N48","v":6160},5620,{"$f":"IF(O48<0,IF(P48>0,IF((O48*(-1))>P48,P48,O48*(-1)),0),0)","v":0},{"$f":"IF(OR(Q48>P48,O48+P48<0),MAKRO1(),ROUNDDOWN(P48-Q48,-1))","v":5620},{"$f":"IF(O48>0,ROUNDDOWN(O48,-1),0)","v":6160}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M48:M48)","v":6500},340,6160,5620,0,5620,6160]
["Vertretungen der Student:innen"]
["----","Vertretungen der Student:innen in der Hochschule",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M51-N51","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":5.97},{"$f":"M52-N52","v":2994.03}]
["----","Interessenvertretungen der Student:innenschaft ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I16","v":5020},{"$f":"'Detailblatt II'!J16","v":60},{"$f":"M53-N53","v":4960}]
["----","weitere Interessenvertetungen",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M54-N54","v":0}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M51:M54)","v":8020},{"$f":"SUM(N51:N54)","v":65.97},{"$f":"SUM(O51:O54)","v":7954.0300000000007}]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J55,J49,J44,J39,J24)","v":40750},8816.6299999999992,-31933.37,317256,80995.66,236628.22999999998,{"$f":"SUM(P24,P39,P49,P44,P55)","v":63470},{"$f":"SUM(Q49,Q39,Q24,Q44,Q55)","v":0},{"$f":"SUM(R49,R39,R24,R44,R55)","v":63470},{"$f":"SUM(S49,S39,S24,S44,S55)","v":71490}]

{"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":2025},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"]
["Finanzvereinbarung",null,null,null,1,0,0,{"$f":"G4-F4","v":0},{"$f":"2500","v":2500},0,{"$f":"I4-J4","v":2500}]
["Förderung der KSS (so auch Domain kss-sachsen.de)",null,null,null,1,0,0,{"$f":"G5-F5","v":0},{"$f":"500","v":500},5.97,{"$f":"I5-J5","v":494.03}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F4:F5)","v":0},0,0,3000,5.97,2994.0299999999997]
["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},3500,0,3500]
["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,50,0,50]
["Konferenz der Informatikfachschaften e. V. ",null,null,null,1,0,0,0,60,60,0]
["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,5020,60,4960]
["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,3500,0,3500,3500,0,3500,3500,{"$f":"(G21-J21+M21)-(F21-I21)","v":2000}]
["Beitragseinnahmen"]
["Anteilig WS 24/25",23,"x Student:innen",4712,1,{"$f":"ROUND((($B$23*$D$23)/6)*2,-2)","v":36100},{"$f":"108376/6*2","v":36125.333333333336},{"$f":"G23-F23","v":25.333333333335759},0,0,{"$f":"I23-J23","v":0}]
["SoSe 25",26,null,4232,1,{"$f":"ROUND($B$24*$D$24,-2)","v":110000},null,{"$f":"G24-F24","v":-110000},0,0,{"$f":"I24-J24","v":0}]
["Anteilig WS 25/26",26,null,4450,1,{"$f":"ROUND((($B$25*$D$25)/6)*4,-2)","v":77100},null,{"$f":"G25-F25","v":-77100},0,0,{"$f":"I25-J25","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F23:F25)","v":223200},36125.333333333336,-187074.66666666666,0,0,0]
["Vermögen"]
["Verfügbare finanzielle Mittel",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D9","v":237211.71999999974},null,{"$f":"G28-F28","v":-237211.71999999974},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,0,1574.45,{"$f":"G30-F30","v":1574.45},0,0,{"$f":"I30-J30","v":0}]
["geplante Veränderung des Vermögens Ansparen/Entnahme",null,null,null,null,{"$f":"Deckblatt!C6*(-1)","v":0},0,{"$f":"G31-F31","v":0},{"$f":"Deckblatt!F6","v":6934},0,{"$f":"I31-J31","v":6934}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F28:F31)","v":237211.71999999974},1574.45,-235637.26999999973,6934,0,6934]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F26,F21,F16,F6)","v":224700},36125.333333333336,-188574.66666666666,11520,65.97,11454.029999999999,3500,0,3500,3500,{"$f":"(G33-J33+M33)-(F33-I33)","v":-177120.63666666666}]

{"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,294.25,{"$f":"G3-H3","v":305.75}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1100,446.25,{"$f":"G4-H4","v":653.75}]
["Nebenkosten Zahlungsverkehr",null,null,0,0,0,1100,142.43,{"$f":"G5-H5","v":957.56999999999994}]
["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,882.93000000000006,2367.0699999999997]

{"sheet":"Hochschulpolitik","index":10,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,0,7,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[6,8,6,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,{"$f":"D4-C4","v":0},1000,0,{"$f":"F4-G4","v":1000},200,{"$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":200},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":1000},{"$f":"(D4-G4+J4)-(C4-F4)","v":1000}]
["Förderverein HTW Dresden - Mitgliedsbeitrag",1,0,0,{"$f":"D5-C5","v":0},150,150,{"$f":"F5-G5","v":0},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":0},{"$f":"(D5-G5+J5)-(C5-F5)","v":0}]
["politische Bildung / Umweltbildung",null,0,0,{"$f":"D6-C6","v":0},1000,0,{"$f":"F6-G6","v":1000},700,{"$f":"IF(H6<0,IF(I6>0,IF((H6*(-1))>I6,I6,H6*(-1)),0),0)","v":0},{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":700},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":1000},{"$f":"(D6-G6+J6)-(C6-F6)","v":1000}]
["CoCo-Pauschale",null,0,0,{"$f":"D7-C7","v":0},250,0,{"$f":"F7-G7","v":250},null,{"$f":"IF(H7<0,IF(I7>0,IF((H7*(-1))>I7,I7,H7*(-1)),0),0)","v":0},{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":0},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},0,0,2500,150,2350,1000,0,1000,{"$f":"SUM(L3:L6)","v":2100},{"$f":"(D8-G8+J8)-(C8-F8)","v":2350}]

{"sheet":"Internationales","index":11,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[3,8,3,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},50,{"$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":50},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":100},{"$f":"(D3-G3+J3)-(C3-F3)","v":100}]
["CoCo-Pauschale",null,0,0,{"$f":"D4-C4","v":0},250,0,{"$f":"F4-G4","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C4)","v":0},0,0,350,0,350,50,0,50,100,{"$f":"(D5-G5+J5)-(C5-F5)","v":350}]

{"sheet":"Kultur","index":12,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[14,8,14,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,353.5,{"$f":"D3-C3","v":-446.5},800,119.27,{"$f":"F3-G3","v":680.73},320,{"$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":320},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":680},{"$f":"(D3-G3+J3)-(C3-F3)","v":234.23000000000002}]
["Erstifahrten",null,3500,0,-3500,4000,0,4000,4000,0,{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":4000},4000,500]
["Semestereröffnungspartys (SEP)",2,5000,2615,-2385,5000,1921,3079,940,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":940},3070,694]
["Semesterabschlussfeier (SAF)",2,3600,1851.69,-1748.31,3600,507.64,3092.36,1380,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":1380},3090,1344.0500000000002]
["Bergfeste",null,0,0,0,0,0,0,1600,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":1600},0,0]
["Weihnachtsfeiern",null,3000,0,-3000,3500,0,3500,3340,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":3340},3500,500]
["Fakultätsfeste & Sommerfeste",null,7100,2802,-4298,7600,753.68,6846.32,2120,0,{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":2120},6840,2548.3200000000002]
["LAN-Partys",null,250,0,-250,250,0,250,750,0,{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":750},250,0]
["Musikveranstaltung",1,250,0,-250,250,0,250,500,0,{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":500},250,0]
["Literatur",null,150,0,-150,250,0,250,0,0,{"$f":"IF(OR(J12>I12,H12+I12<0),MAKRO1(),ROUNDDOWN(I12-J12,-1))","v":0},250,100]
["Spieleabende",2,300,0,-300,500,0,500,140,0,{"$f":"IF(OR(J13>I13,H13+I13<0),MAKRO1(),ROUNDDOWN(I13-J13,-1))","v":140},500,200]
["Vernetzung von Student:innen der Hochschule",null,1500,411,-1089,1500,499.28,1000.72,300,0,{"$f":"IF(OR(J14>I14,H14+I14<0),MAKRO1(),ROUNDDOWN(I14-J14,-1))","v":300},1000,-88.279999999999973]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C15)","v":25450},8033.1900000000005,-17416.809999999998,27500,3800.87,23699.13,15390,0,15390,23430,{"$f":"(D16-G16+J16)-(C16-F16)","v":6282.3200000000006}]

{"sheet":"Öffentlichkeitsarbeit","index":13,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[7,0,7,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},{"$f":"480+250","v":730},{"$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":730},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Werbemittel (Kulis, Beutel, Plakate, T-Shirts etc.)",null,0,0,{"$f":"D4-C4","v":0},7000,35.99,{"$f":"F4-G4","v":6964.01},330,{"$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":330},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":6960},{"$f":"(D4-G4+J4)-(C4-F4)","v":6964.01}]
["Werbemittel Änderung Logo 2023",null,0,0,{"$f":"D5-C5","v":0},0,0,{"$f":"F5-G5","v":0},1200,{"$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":1200},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":0},{"$f":"(D5-G5+J5)-(C5-F5)","v":0}]
["Merchandise u.ä.",null,0,0,{"$f":"D6-C6","v":0},0,0,{"$f":"F6-G6","v":0},10,{"$f":"IF(H6<0,IF(I6>0,IF((H6*(-1))>I6,I6,H6*(-1)),0),0)","v":0},{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":10},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":0},{"$f":"(D6-G6+J6)-(C6-F6)","v":0}]
["CoCo-Pauschale",null,0,0,{"$f":"D7-C7","v":0},250,0,{"$f":"F7-G7","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},0,0,7750,35.99,7714.01,2270,0,2270,7460,{"$f":"(D8-G8+J8)-(C8-F8)","v":7714.01}]

{"sheet":"Qualitätsmanagement","index":14,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[5,8,5,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 zu Erste Hilfe",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}]
["Veranstaltung Erstsemestereinführung (ESE)",1,0,0,{"$f":"D4-C4","v":0},500,0,{"$f":"F4-G4","v":500},190,{"$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":190},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":500},{"$f":"(D4-G4+J4)-(C4-F4)","v":500}]
["Systemakkreditierung",null,0,0,{"$f":"D5-C5","v":0},0,0,{"$f":"F5-G5","v":0},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":0},{"$f":"(D5-G5+J5)-(C5-F5)","v":0}]
["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,1250,0,1250,690,0,690,1000,{"$f":"(D7-G7+J7)-(C7-F7)","v":1250}]

{"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"]
["Beratungen",null,0,0,{"$f":"D3-C3","v":0},300,0,{"$f":"F3-G3","v":300},0,{"$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":0},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":300},{"$f":"(D3-G3+J3)-(C3-F3)","v":300}]
["Veranstaltungen zu sozialen Belangen",2,0,0,{"$f":"D4-C4","v":0},500,0,{"$f":"F4-G4","v":500},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":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,0,0,0,800,{"$f":"(D6-G6+J6)-(C6-F6)","v":1050}]

{"sheet":"Sport","index":16,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,1],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[12,8,12,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,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}]
["Nikolausvolleyballturnier",null,700,0,-700,1000,0,1000,410,0,{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":410},1000,300]
["Startgebühren",null,0,0,0,200,0,200,200,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":200},200,200]
["Drachenbootrennen",1,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":0},0,0]
["sächsische Beachmeisterschaften",1,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":0},0,0]
["Beachfeier",null,1000,0,-1000,1000,0,1000,0,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":0},1000,0]
["Gesundheitsmanagement ",1,0,0,0,500,0,500,500,0,{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":500},500,500]
["Ausflüge",1,400,0,-400,500,0,500,300,0,{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":300},500,100]
["Hochschulsportfest",1,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":0},0,0]
["Sportevents (Eislaufen, Lasertag, Trampolinpark)",null,2000,0,-2000,2500,0,2500,1740,0,{"$f":"IF(OR(J12>I12,H12+I12<0),MAKRO1(),ROUNDDOWN(I12-J12,-1))","v":1740},2500,500]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C13)","v":4100},0,-4100,6450,0,6450,3650,0,3650,6200,{"$f":"(D14-G14+J14)-(C14-F14)","v":2350}]

{"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},0,{"$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":0},{"$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,750,0,750,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 studentische Selbstverwaltung & Organisation","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,39.92,{"$f":"F3-G3","v":140.07999999999998},60,{"$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":60},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":140},{"$f":"(D3-G3+J3)-(C3-F3)","v":140.07999999999998}]
["Domains",null,0,0,{"$f":"D4-C4","v":0},80,13.95,{"$f":"F4-G4","v":66.05},60,0,{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":60},60,66.05]
["Beitrag Gruppenausweis für Jugendherbergen",1,0,0,{"$f":"D5-C5","v":0},26,0,{"$f":"F5-G5","v":26},0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":0},20,26]
["Versicherung Beachvolleyballplätze",null,0,0,0,400,259.39999999999998,0,0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":0},0,140.60000000000002]
["Aufbau drittes Feld Beachvolleyballplätze",null,6000,0,0,6000,0,0,0,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":0},0,0]
["Dienste für elektronische Datenverarbeitung ",null,0,0,{"$f":"D8-C8","v":0},0,0,{"$f":"F8-G8","v":0},15000,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":15000},0,0]
["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]
["Beiträge/Gebühren",null,0,0,0,0,0,0,230,0,{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":230},0,0]
["Büromaterial und -ausstattung",null,0,0,0,500,48.72,451.28,460,0,{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":460},450,451.28]
["Studienmaterial (z.B. Bautabellen, etc.)",null,700,0,-700,700,0,700,700,0,{"$f":"IF(OR(J12>I12,H12+I12<0),MAKRO1(),ROUNDDOWN(I12-J12,-1))","v":700},700,0]
["Getränkeautomat",null,1000,359.55,-640.45000000000005,900,55.02,844.98,380,0,{"$f":"IF(OR(J13>I13,H13+I13<0),MAKRO1(),ROUNDDOWN(I13-J13,-1))","v":380},840,204.53000000000003]
["laufende Kosten für Druck, samt Nebenkosten",null,0,0,0,550,55.34,494.65999999999997,100,0,{"$f":"IF(OR(J14>I14,H14+I14<0),MAKRO1(),ROUNDDOWN(I14-J14,-1))","v":100},490,494.65999999999997]
["Laborkittel An- & Verkauf",null,2000,56,-1944,2000,0,2000,970,0,{"$f":"IF(OR(J15>I15,H15+I15<0),MAKRO1(),ROUNDDOWN(I15-J15,-1))","v":970},2000,56]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C16)","v":9700},415.55,-3284.45,11586,472.35,4973.0499999999993,17960,0,17960,4700,{"$f":"(D17-G17+J17)-(C17-F17)","v":1829.2}]

{"sheet":"Personal","index":19,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,0,11,12],[17,8,17,11],[18,0,18,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}]
["Sozialberatung (BaföG, Jobberatung) / Soziales",null,0,0,0,250,0,250,180,0,{"$f":"IF(OR(J5>I5,H5+I5<0),MAKRO1(),ROUNDDOWN(I5-J5,-1))","v":180},250,250]
["studentische und akademische Selbstverwaltung (Studienprüfungsordnung) / Studium",null,0,0,0,100,0,100,100,0,{"$f":"IF(OR(J6>I6,H6+I6<0),MAKRO1(),ROUNDDOWN(I6-J6,-1))","v":100},100,100]
["Prüfungsangelegenheiten / Studium",null,0,0,0,250,0,250,250,0,{"$f":"IF(OR(J7>I7,H7+I7<0),MAKRO1(),ROUNDDOWN(I7-J7,-1))","v":250},250,250]
["pol. Bildung, Antidiskriminierung, Gleichstellung / Hochschulpolitik",null,0,0,0,100,0,100,100,0,{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":100},100,100]
["interne Seminare",1,0,0,0,1000,177.06,822.94,{"$f":"350+30","v":380},0,{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":380},820,822.94]
["Clearance and Rapprochement (CLARA) / \nStuRa (Kanzlei)",1,0,0,0,0,0,0,150,0,{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":150},0,0]
["Veranstaltung zur fachlichen Weiterbildung / \nStudium",null,0,0,0,250,0,250,250,0,{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":250},250,250]
["Allgemeines"]
["Informationen zu Kandidierenden",null,0,0,{"$f":"D13-C13","v":0},0,0,{"$f":"F13-G13","v":0},100,{"$f":"IF(H13<0,IF(I13>0,IF((H13*(-1))>I13,I13,H13*(-1)),0),0)","v":0},{"$f":"IF(OR(J13>I13,H13+I13<0),MAKRO1(),ROUNDDOWN(I13-J13,-1))","v":100},{"$f":"IF(H13>0,ROUNDDOWN(H13,-1),0)","v":0},{"$f":"(D13-G13+J13)-(C13-F13)","v":0}]
["auswärtige Arbeitstreffen und Tagungen",null,0,0,{"$f":"D14-C14","v":0},2000,0,2000,{"$f":"500+500","v":1000},{"$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":1000},{"$f":"IF(H14>0,ROUNDDOWN(H14,-1),0)","v":2000},{"$f":"(D14-G14+J14)-(C14-F14)","v":2000}]
["Integration (Veranstaltungen zum internen Zusammenhalt)",null,0,0,{"$f":"D15-C15","v":0},500,156,344,370,{"$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":370},{"$f":"IF(H15>0,ROUNDDOWN(H15,-1),0)","v":340},{"$f":"(D15-G15+J15)-(C15-F15)","v":344}]
["StuRa Bekleidung",null,0,0,0,1000,0,1000,0,{"$f":"IF(H16<0,IF(I16>0,IF((H16*(-1))>I16,I16,H16*(-1)),0),0)","v":0},{"$f":"IF(OR(J16>I16,H16+I16<0),MAKRO1(),ROUNDDOWN(I16-J16,-1))","v":0},{"$f":"IF(H16>0,ROUNDDOWN(H16,-1),0)","v":1000},{"$f":"(D16-G16+J16)-(C16-F16)","v":1000}]
["Kennenlern-Veranstaltungen ",2,0,0,0,750,80.63,669.37,470,{"$f":"IF(H17<0,IF(I17>0,IF((H17*(-1))>I17,I17,H17*(-1)),0),0)","v":0},{"$f":"IF(OR(J17>I17,H17+I17<0),MAKRO1(),ROUNDDOWN(I17-J17,-1))","v":470},{"$f":"IF(H17>0,ROUNDDOWN(H17,-1),0)","v":660},{"$f":"(D17-G17+J17)-(C17-F17)","v":669.37}]
["CoCo-Pauschale",null,0,0,{"$f":"D18-C18","v":0},250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C4:C18)","v":0},0,0,8250,413.69,7836.31,5150,0,5150,7570,{"$f":"(D19-G19+J19)-(C19-F19)","v":7836.31}]