{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Hinweise","Deckblatt","Beitragsermittlung","fortgeschr. Mittel+Konto","Mindestreserve","Detailblatt I","Detailblatt II","Konferenzen","Personal","Finanzen","Hochschulpolitik","Internationales","Kultur","Öffentlichkeitsarbeit","Qualitätsmanagement","Soziales","Sport","Studium","Studentische Verwaltung"],"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 das 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":[[0,0,1,1],[0,2,0,4],[0,5,0,7],[2,0,2,1],[3,0,3,1],[4,0,4,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,11,0],[15,4,15,6],[17,3,17,4]]}
["Haushaltsplan 2021 Studierendenschaft HTW Dresden",null,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J55","v":13283.3333333333},{"$f":"'Detailblatt I'!K55","v":11030.6},{"$f":"D3-C3","v":-2252.73333333333},{"$f":"'Detailblatt I'!M55","v":215426},{"$f":"'Detailblatt I'!N55","v":136229.76},{"$f":"(F3-G3)","v":79196.24}]
["Beitragseinnahmen der Studierenden",null,{"$f":"'Detailblatt II'!F17","v":160800},{"$f":"'Detailblatt II'!G17","v":160691.34},{"$f":"D4-C4","v":-108.660000000003},{"$f":"'Detailblatt II'!I17","v":0},{"$f":"'Detailblatt II'!J17","v":0},{"$f":"(F4-G4)","v":0}]
["Zinsen",null,{"$f":"'Detailblatt II'!F21","v":0},{"$f":"'Detailblatt II'!G21","v":0},{"$f":"D5-C5","v":0},{"$f":"'Detailblatt II'!I21","v":0},{"$f":"'Detailblatt II'!J21","v":0},{"$f":"(F5-G5)","v":0}]
["Entnahme (=Einnahme) Ansparen (=Ausgabe)","von Vermögen",{"$f":"IF((Beitragsermittlung!B16)-('Detailblatt II'!F15+'Detailblatt II'!F16)>0,(Beitragsermittlung!B16)-('Detailblatt II'!F15+'Detailblatt II'!F16),0)","v":6742.66666666666},0,{"$f":"D6-C6","v":-6742.66666666666},0,{"$f":"'Detailblatt II'!G22","v":0},{"$f":"(F6-G6)","v":0}]
["angeordnete Vermögensänderung lt. FO",null,{"$f":"Beitragsermittlung!B14","v":0},null,{"$f":"D7-C7","v":0},{"$f":"'Detailblatt II'!I20","v":0},null,{"$f":"(F7-G7)","v":0}]
["Zurückführung an Studierende (StuRa)",null,34600,{"$f":"C8","v":34600},{"$f":"D8-C8","v":0}]
[]
["Gesamt:",null,{"$f":"SUM(C3:C9)","v":215426},{"$f":"SUM(D3:D9)","v":206321.94},{"$f":"SUM(E3:E9)","v":-9104.05999999999},{"$f":"SUM(F3:F9)","v":215426},{"$f":"SUM(G3:G9)","v":136229.76},{"$f":"SUM(H3:H9)","v":79196.24}]
["Berechnung des Semesterbeitrag:"]
[null,"Planausgaben:",{"$f":"F10","v":215426},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":13283.3333333333}]
["-","Zurückführung:",{"$f":"C8+C9","v":34600}]
["-","Vermögensänderung",{"$f":"C7","v":0}]
["=","Gesamt:",{"$f":"C12-C13-C14-C15-F6","v":167542.666666667}]
["/","Beitragszahlungen/Jahr:",{"$f":"'Detailblatt II'!D15+('Detailblatt II'!D16/6*4)","v":7608}]
["=","Stud./Semester:",{"$f":"IF((C16-'Detailblatt II'!F14)/Deckblatt!C17<0,0,(C16-'Detailblatt II'!F14)/Deckblatt!C17)","v":18.394146512443},"Anzusetzender Semesterbeitrag:",null,{"$f":"ROUND((C18*2),0)/2","v":18.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":180826}]
["verfügbare finanzielle Mittel",{"$f":"'fortgeschr. Mittel+Konto'!D9","v":103496.01}]
["Obergrenze finanzielle Mittel",{"$f":"IF(B3<B4,B3,B4)","v":103496.01}]
[]
["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!D17","v":102250}]
["(Verfügbare finanzielle Mittel nach Vermögensenkung)",{"$f":"B4-B7","v":103496.01}]
["Untergrenze für verfügbare finanzielle Mittel durch Bemessung an der Mindestreserve wird erreicht",{"$f":"IF(B5<B8,B8,B5)","v":103496.01}]
["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'!F14)),Deckblatt!F10-Deckblatt!F6-(Deckblatt!C3+Deckblatt!C5+Deckblatt!C8+Deckblatt!C9+'Detailblatt II'!F14),Beitragsermittlung!B11)","v":0}]
["Vermögenssenkung wegen übermäßig verfügbarer finanzieller Mittel ohne negativem 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'!F14)","v":139942.666666667}]

{"sheet":"fortgeschr. Mittel+Konto","index":3,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,2,1,2],[0,3,1,3],[1,6,1,7],[2,5,3,5],[2,6,3,7],[2,8,3,8],[4,5,5,5],[4,6,5,7],[4,8,5,8],[6,6,6,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,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],[16,8,17,8],[18,5,19,5],[18,6,19,7],[18,8,19,8],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7]]}
["Fortgeschriebene finanzielle Mittel + Bankkontostand",null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2021}]
[null,null,null,null,null,"Nr.","voraussichtliche Ausgaben",null,"Saldo"]
[null,"Position","erstellt am:","Saldo",null,"1.","Personal (Nov.+Dez. inkl. 13.Gehalt, ACON, Finanzamt)",null,0]
[null,"Bank-/Kassenbestand bei Haushaltsplanerstellung",null,{"$f":"2155.92+124+82.57+163812.02+60000+1462.39","v":227636.9}]
["-","abzgl. voraussichtliche Ausgaben",null,{"$f":"I24*(-1)","v":-30574.45},null,"2.","Finanzbeschlüsse aktuell noch nicht bezahlt in Summe",null,0]
["-","nachrangig verwendbares Vorjahresbudget",null,{"$f":"'Detailblatt I'!P55*(-1)-'Detailblatt I'!Q55*(-1)","v":-31366.44}]
["-","Zurückführung an Studierende gesamt",null,{"$f":"SUM(Deckblatt!C8:C9)*-1","v":-34600},null,"3.","Schulungen/Konferenzen (KoSe)",null,0]
["-","Beitragseinnahmen anteilig WS 20/21 für 2021",null,{"$f":"'Detailblatt II'!F14*-1","v":-27600},null,"4.","voraussichtliche AE",null,0]
["=","verfügbare finanzielle Mittel",null,{"$f":"D4+D5+D6+D7+D8","v":103496.01},null,"5.","offene Härtefallanträge",null,0]
[null,null,null,null,null,"6.","Software-Abos (AGENDA etc.)",null,0]
[null,null,null,null,null,"7.","Kosten für Wartung (Drucker etc.)",null,0]
[null,null,null,null,null,"8.","Kontoführung",null,0]
[null,null,null,null,null,"9.","Kino in der HTW & Co.",null,0]
[null,null,null,null,null,"10.","Kosten für Wahlen",null,0]
[null,null,null,null,null,"11.","Kaffeebestellung(en)",null,0]
[null,null,null,null,null,"12.","Ersatz- & Neuanschaffung",null,0]
[null,null,null,null,null,"13.","wahrscheinlich noch zu beschließende Finanzanträge ",null,0]
[]
[null,null,null,null,null,"14.","Semesterticket Konto 1591 & 1592",null,0]
[]
[null,null,null,null,null,"15.","Konto 1704",null,10842.82]
[null,null,null,null,null,"16.","Konto 1450 (-)",null,-4736.56]
[null,null,null,null,null,"17.","Nothilfefonds saldiert",null,24468.19]
[null,null,null,null,null,"=","Gesamtsumme:",null,{"$f":"SUM(I3:I23)","v":30574.45}]

{"sheet":"Mindestreserve","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[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],[3,0,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2],[6,3,6,4],[7,0,7,4],[8,0,8,2],[8,3,8,4],[9,0,9,2],[9,3,9,4],[10,0,10,2],[10,3,10,4],[11,0,11,4],[12,0,12,2],[12,3,12,4],[13,0,13,2],[13,3,13,4],[14,0,14,2],[14,3,14,4],[15,0,15,2],[15,3,15,4],[16,0,16,2],[16,3,16,4]]}
["Mindestreserve",null,null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2021},"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"]
["Studentinnen- und Studentenrat"]
["Lohnkosten (Detailblatt I - Zelle M7)",null,null,{"$f":"'Detailblatt I'!M7","v":100000}]
["…aktuell ohne Belegung…"]
["…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":1000}]
["…aktuell ohne Belegung…",null,null,"------"]
["Referat Selbstverwaltung & Organisation"]
["Domains",null,null,{"$f":"'Studentische Verwaltung'!F4","v":150}]
["laufende Kosten (Druck, Wartung)",null,null,{"$f":"'Studentische Verwaltung'!F15","v":500}]
["…aktuell ohne Belegung…",null,null,"------"]
["…aktuell ohne Belegung…",null,null,"------"]
["Gesamt:",null,null,{"$f":"SUM(D5:E16)","v":102250}]

{"sheet":"Detailblatt I","index":5,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,1,3],[0,4,1,4],[0,5,1,8],[0,9,0,11],[0,12,0,14],[0,15,1,15],[0,16,1,16],[0,17,1,17],[0,18,1,18],[2,0,2,18],[3,0,3,18],[4,1,4,8],[4,12,4,14],[5,1,11,1],[5,2,5,8],[6,2,6,8],[6,14,11,14],[7,2,7,8],[7,12,11,12],[8,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,0,22,8],[23,0,23,18],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,0,37,8],[38,0,38,18],[39,1,39,8],[39,9,41,11],[39,15,42,18],[40,1,40,8],[41,1,41,8],[42,0,42,8],[43,0,43,18],[44,0,44,4],[44,9,45,11],[44,12,44,13],[44,15,45,18],[45,0,45,4],[45,5,45,6],[45,7,45,8],[45,12,45,14],[46,0,46,7],[46,9,46,11],[47,0,47,8],[48,0,48,18],[49,1,49,8],[49,9,52,11],[50,1,50,8],[51,1,51,8],[52,1,52,8],[53,0,53,8],[53,15,53,16],[54,0,54,8]]}
["Detailblatt I",null,null,null,"Jahr -",2021,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 Studentinnen- und Studentenschaft HTW Dresden"]
["Studentinnen- und Studentenrat"]
["Sachkontonr."]
[2749,"Angestellte","AAG",null,null,null,null,null,null,null,10806.6,{"$f":"K6","v":10806.6}]
[4120,null,"Gehälter",null,null,null,null,null,null,null,null,null,100000,48404.73,{"$f":"M7-SUM(N7:N12)+L6","v":12781.25}]
[4121,null,"Lohnsteuer",null,null,null,null,null,null,null,null,null,null,17703.12]
[4170,null,"Vermögenswirksame Leistungen",null,null,null,null,null,null,null,null,null,null,79.8]
[4130,null,"gesetzl. sozial. Aufw.",null,null,null,null,null,null,null,null,null,null,31028.11]
[4138,null,"Beitrag BG",null,null,null,null,null,null,null,null,null,null,278.84]
[4956,null,"Lohnbüro",null,null,null,null,null,null,null,null,null,null,530.75]
[4110,"(AE) Aufwandsentschädigungen",null,null,null,null,null,null,null,null,null,null,28000,20992,{"$f":"M13-N13","v":7008}]
[4640,"Kaffee & Verpflegung",null,null,null,null,null,null,null,null,null,null,1200,707.75,{"$f":"M14-N14","v":492.25}]
[4670,"Allgemeine Reisekosten (die keiner Veranstaltung zugeordnet sind)",null,null,null,null,null,null,null,null,null,null,800,588,{"$f":"M15-N15","v":212}]
[4909,"Vorstand der Geschäftsführung",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M16-N16","v":0}]
[4930,"Büro- und Verbrauchsmaterialien",null,null,null,null,null,null,null,null,null,null,100,55.69,{"$f":"M17-N17","v":44.31},170,{"$f":"IF(O17<0,IF(P17>0,IF((O17*(-1))>P17,P17,O17*(-1)),0),0)","v":0},{"$f":"IF(OR(Q17>P17,O17+P17<0),MAKRO1(),ROUNDDOWN(P17-Q17,-1))","v":170},{"$f":"IF(O17>0,ROUNDDOWN(O17,-1),0)","v":40}]
[4943,"Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,500,151.5,{"$f":"M18-N18","v":348.5},900,{"$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":900},{"$f":"IF(O18>0,ROUNDDOWN(O18,-1),0)","v":340}]
[4944,"Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,250,0,{"$f":"M19-N19","v":250},500,{"$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":500},{"$f":"IF(O19>0,ROUNDDOWN(O19,-1),0)","v":250}]
[4945,"Durchführung Konferenzen",null,null,null,null,null,null,null,2000,{"$f":"Konferenzen!D6","v":0},{"$f":"K20-J20","v":-2000},2500,{"$f":"Konferenzen!G6","v":0},{"$f":"M20-N20","v":2500},1500,{"$f":"Konferenzen!J6","v":0},{"$f":"Konferenzen!K6","v":1500},{"$f":"Konferenzen!L6","v":500}]
[4950,"Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,6000,0,{"$f":"M21-N21","v":6000},1170,{"$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":1170},{"$f":"IF(O21>0,ROUNDDOWN(O21,-1),0)","v":6000}]
[4989,"Ersatz- und Neuanschaffung",null,null,null,null,null,null,null,null,null,null,3000,1401.99,{"$f":"M22-N22","v":1598.01},1210,{"$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":1210},{"$f":"IF(O22>0,ROUNDDOWN(O22,-1),0)","v":1590}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J22)","v":2000},{"$f":"SUM(K6:K22)","v":10806.6},{"$f":"SUM(L6:L22)","v":8806.6},{"$f":"SUM(M6:M22)","v":142350},{"$f":"SUM(N6:N22)","v":121922.28},{"$f":"SUM(O6:O22)","v":31234.32},{"$f":"SUM(P17:P22)","v":5450},{"$f":"SUM(Q17:Q22)","v":0},{"$f":"SUM(R17:R22)","v":5450},{"$f":"SUM(S17:S22)","v":8720}]
["Referate"]
[4960,"Finanzen",null,null,null,null,null,null,null,{"$f":"Finanzen!D6","v":0},{"$f":"Finanzen!E6","v":0},{"$f":"K25-J25","v":0},{"$f":"Finanzen!G6","v":1850},{"$f":"Finanzen!H6","v":1399.72},{"$f":"M25-N25","v":450.28}]
[4961,"Hochschulpolitik",null,null,null,null,null,null,null,{"$f":"Hochschulpolitik!C8","v":0},{"$f":"Hochschulpolitik!D8","v":0},{"$f":"K26-J26","v":0},{"$f":"Hochschulpolitik!F8","v":850},{"$f":"Hochschulpolitik!G8","v":150},{"$f":"M26-N26","v":700},{"$f":"Hochschulpolitik!I8","v":700},{"$f":"Hochschulpolitik!J8","v":0},{"$f":"Hochschulpolitik!K8","v":700},{"$f":"Hochschulpolitik!L8","v":700}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C6","v":0},{"$f":"Internationales!D6","v":0},{"$f":"K27-J27","v":0},{"$f":"Internationales!F6","v":350},{"$f":"Internationales!G6","v":50},{"$f":"M27-N27","v":300},{"$f":"Internationales!I6","v":50},{"$f":"Internationales!J6","v":0},{"$f":"Internationales!K6","v":50},{"$f":"Internationales!L6","v":50}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C14","v":8933.33333333333},{"$f":"Kultur!D14","v":110},{"$f":"K28-J28","v":-8823.33333333333},{"$f":"Kultur!F14","v":11150},{"$f":"Kultur!G14","v":744.1},{"$f":"M28-N28","v":10405.9},{"$f":"Kultur!I14","v":11040},{"$f":"Kultur!J14","v":10.28},{"$f":"Kultur!K14","v":11020},{"$f":"Kultur!L14","v":10160}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C9","v":750},{"$f":"Öffentlichkeitsarbeit!D9","v":60},{"$f":"K29-J29","v":-690},{"$f":"Öffentlichkeitsarbeit!F9","v":2850},{"$f":"Öffentlichkeitsarbeit!G9","v":13.5},{"$f":"M29-N29","v":2836.5},{"$f":"Öffentlichkeitsarbeit!I9","v":1710},{"$f":"Öffentlichkeitsarbeit!J9","v":0},{"$f":"Öffentlichkeitsarbeit!K9","v":1710},{"$f":"Öffentlichkeitsarbeit!L9","v":2580}]
[4965,"Qualitätsmanagement",null,null,null,null,null,null,null,{"$f":"Qualitätsmanagement!C6","v":0},{"$f":"Qualitätsmanagement!D6","v":0},{"$f":"K30-J30","v":0},{"$f":"Qualitätsmanagement!F6","v":5000},{"$f":"Qualitätsmanagement!G6","v":4010.3},{"$f":"M30-N30","v":989.7},{"$f":"Qualitätsmanagement!I6","v":0},{"$f":"Qualitätsmanagement!J6","v":0},{"$f":"Qualitätsmanagement!K6","v":0},{"$f":"Qualitätsmanagement!L6","v":730}]
[4966,"Soziales",null,null,null,null,null,null,null,{"$f":"Soziales!C8","v":200},{"$f":"Soziales!D8","v":0},{"$f":"K31-J31","v":-200},{"$f":"Soziales!F8","v":800},{"$f":"Soziales!G8","v":0},{"$f":"M31-N31","v":800},{"$f":"Soziales!I8","v":450},{"$f":"Soziales!J8","v":0},{"$f":"Soziales!K8","v":450},{"$f":"Soziales!L8","v":550}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C11","v":200},{"$f":"Sport!D11","v":0},{"$f":"K32-J32","v":-200},{"$f":"Sport!F11","v":1850},{"$f":"Sport!G11","v":0},{"$f":"M32-N32","v":1850},{"$f":"Sport!I11","v":500},{"$f":"Sport!J11","v":0},{"$f":"Sport!K11","v":500},{"$f":"Sport!L11","v":700}]
[4968,"Studium",null,null,null,null,null,null,null,{"$f":"Studium!C7","v":0},{"$f":"Studium!D7","v":0},{"$f":"K33-J33","v":0},{"$f":"Studium!F7","v":250},{"$f":"Studium!G7","v":0},{"$f":"M33-N33","v":250},{"$f":"Studium!I7","v":550},{"$f":"Studium!J7","v":0},{"$f":"Studium!K7","v":550},{"$f":"Studium!L7","v":0}]
[4969,"Studentische Selbstverwaltung & Organisation",null,null,null,null,null,null,null,{"$f":"'Studentische Verwaltung'!C16","v":1200},{"$f":"'Studentische Verwaltung'!D16","v":54},{"$f":"K34-J34","v":-1146},{"$f":"'Studentische Verwaltung'!F16","v":29626},{"$f":"'Studentische Verwaltung'!G16","v":2096.96},{"$f":"M34-N34","v":27529.04},{"$f":"'Studentische Verwaltung'!I16","v":2680},{"$f":"'Studentische Verwaltung'!J16","v":633.28},{"$f":"'Studentische Verwaltung'!K16","v":2040},{"$f":"'Studentische Verwaltung'!L16","v":28150}]
[4946,"Personal",null,null,null,null,null,null,null,{"$f":"Personal!C20","v":0},{"$f":"'Studentische Verwaltung'!D17","v":0},{"$f":"K35-J35","v":0},{"$f":"Personal!F20","v":5200},{"$f":"'Studentische Verwaltung'!G17","v":0},{"$f":"M35-N35","v":5200},{"$f":"Personal!I20","v":4950},{"$f":"'Studentische Verwaltung'!J17","v":0},{"$f":"Personal!K20","v":4900},{"$f":"Personal!L20","v":4310}]
["----","Ausschüsse des Studentinnen- und Studentenrates",null,null,null,null,null,null,null,0,0,{"$f":"K36-J36","v":0},0,0,{"$f":"M36-N36","v":0}]
["----","weitere Vertretungen",null,null,null,null,null,null,null,0,0,{"$f":"K37-J37","v":0},0,0,{"$f":"M37-N37","v":0}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J25:J37)","v":11283.3333333333},{"$f":"SUM(K25:K37)","v":224},{"$f":"SUM(L25:L37)","v":-11059.3333333333},{"$f":"SUM(M25:M37)","v":59776},{"$f":"SUM(N25:N37)","v":8464.58},{"$f":"SUM(O25:O37)","v":51311.42},{"$f":"SUM(P26:P35)","v":22630},{"$f":"SUM(Q26:Q35)","v":643.56},{"$f":"SUM(R26:R35)","v":21920},{"$f":"SUM(S26:S35)","v":47930}]
["Ausschüsse der Studentinnen- und Studentenschaft"]
["----","weitere Ausschüsse der Studentinnen- und Studentenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M40-N40","v":0}]
["----","Wahlausschuss der Studentinnen- und Studentenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M41-N41","v":0}]
[4941,"(HFA) Härtefallausschuss der Studentinnen- & Studentenschaft",null,null,null,null,null,null,null,null,null,null,5000,1447.6,{"$f":"M42-N42","v":3552.4}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M40:M42)","v":5000},{"$f":"SUM(N40:N42)","v":1447.6},{"$f":"SUM(O40:O42)","v":3552.4}]
[]
["Anzahl der Studierenden im:",null,null,null,null,"WiSe","21/22","SoSe",2021]
["gesamt:",null,null,null,null,4700,null,4200]
["#4942 Absicherung Teilnahme BuFaTas lt. Finanzordnung:",null,null,null,null,null,null,null,0.5,null,null,null,2000,128.25,{"$f":"M47-N47","v":1871.75},3930,{"$f":"IF(O47<0,IF(P47>0,IF((O47*(-1))>P47,P47,O47*(-1)),0),0)","v":0},{"$f":"IF(OR(Q47>P47,O47+P47<0),MAKRO1(),ROUNDDOWN(P47-Q47,-1))","v":3930},{"$f":"IF(O47>0,ROUNDDOWN(O47,-1),0)","v":1870}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M47:M47)","v":2000},{"$f":"SUM(N47:N47)","v":128.25},{"$f":"SUM(O47:O47)","v":1871.75},{"$f":"SUM(P47)","v":3930},{"$f":"SUM(Q47)","v":0},{"$f":"SUM(R47:R47)","v":3930},{"$f":"SUM(S47)","v":1870}]
["Vertretungen der Studentinnen und Studenten"]
["----","Vertretungen der Studentinnen und Studenten in der Hochschule",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M50-N50","v":0}]
["----","Konferenz Sächsischer Studierendenschaft",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I6","v":2000},{"$f":"'Detailblatt II'!J6","v":1378.05},{"$f":"M51-N51","v":621.95}]
["----","Interessenvertretungen der Studentinnen- und Studentenschaft ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I12","v":4300},{"$f":"'Detailblatt II'!J12","v":2889},{"$f":"M52-N52","v":1411}]
["----","weitere Interessenvertetungen",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M53-N53","v":0}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M50:M53)","v":6300},{"$f":"SUM(N50:N53)","v":4267.05},{"$f":"SUM(O50:O53)","v":2032.95}]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J48,J43,J38,J23)","v":13283.3333333333},{"$f":"SUM(K48,K43,K38,K23)","v":11030.6},{"$f":"SUM(L48,L43,L38,L23)","v":-2252.73333333333},{"$f":"SUM(M54,M48,M43,M38,M23)","v":215426},{"$f":"SUM(N54,N48,N43,N38,N23)","v":136229.76},{"$f":"SUM(O54,O48,O43,O38,O23)","v":90002.84},{"$f":"SUM(P23,P38,P48)","v":32010},{"$f":"SUM(Q48,Q38,Q23)","v":643.56},{"$f":"SUM(R48,R38,R23)","v":31300},{"$f":"SUM(S48,S38,S23)","v":58520}]

{"sheet":"Detailblatt II","index":6,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,3],[0,4,1,4],[0,5,0,7],[0,8,0,10],[3,0,3,3],[4,0,4,3],[5,3,5,4],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,3,11,4],[13,2,15,2],[16,3,16,4],[18,0,18,4],[19,0,19,4],[20,0,20,3],[21,0,21,3],[22,3,22,4],[23,0,23,4]]}
["Detailblatt II","Jahr -",{"$f":"'Detailblatt I'!F1","v":2021},null,"Häufigkeit","Einnahmen",null,null,"Ausgaben"]
[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":"1350+23.4","v":1373.4},1373.4,{"$f":"I4-J4","v":0}]
["Förderung der KSS (so auch Domain kss-sachsen.de)",null,null,null,1,0,0,{"$f":"G5-F5","v":0},{"$f":"650-23.4","v":626.6},4.65,{"$f":"I5-J5","v":621.95}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F4:F5)","v":0},{"$f":"SUM(G4:G5)","v":0},{"$f":"SUM(H4:H5)","v":0},{"$f":"SUM(I4:I5)","v":2000},{"$f":"SUM(J4:J5)","v":1378.05},{"$f":"SUM(K4:K5)","v":621.95}]
["Interessenvertretungen der Studentinnen- und Studentenschaften - Konto: 4982"]
["faranto e.V.",null,null,null,null,0,0,{"$f":"G8-F8","v":0},600,0,{"$f":"I8-J8","v":600}]
["Erasmus Student Network",null,null,null,null,0,0,{"$f":"G9-F9","v":0},200,0,{"$f":"I9-J9","v":200}]
["freier zusammenschluss von studentInnenschaften (fzs) e.V.",null,null,null,1,0,0,{"$f":"G10-F10","v":0},3500,2889,{"$f":"I10-J10","v":611}]
["weitere",null,null,null,null,0,0,{"$f":"G11-F11","v":0},0,0,{"$f":"I11-J11","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F8:F11)","v":0},{"$f":"SUM(G8:G11)","v":0},{"$f":"SUM(H8:H11)","v":0},{"$f":"SUM(I8:I11)","v":4300},{"$f":"SUM(J8:J11)","v":2889},{"$f":"SUM(K8:K11)","v":1411}]
["Beitragseinnahmen"]
["Anteilig WS 20/21",17,"x Studierende",4862,1,{"$f":"ROUND((($B$14*$D$14)/6)*2,-2)","v":27600},27551.34,{"$f":"G14-F14","v":-48.6599999999999},0,0,{"$f":"I14-J14","v":0}]
["SoSe 21",17.5,null,4336,1,{"$f":"ROUND($B$15*$D$15,-2)","v":75900},75880,{"$f":"G15-F15","v":-20},0,0,{"$f":"I15-J15","v":0}]
["Anteilig WS 21/22",17.5,null,4908,1,{"$f":"ROUND((($B$16*$D$16)/6)*4,-2)","v":57300},57260,{"$f":"G16-F16","v":-40},0,0,{"$f":"I16-J16","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F14:F16)","v":160800},{"$f":"SUM(G14:G16)","v":160691.34},{"$f":"SUM(H14:H16)","v":-108.66},{"$f":"SUM(I14:I16)","v":0},{"$f":"SUM(J14:J16)","v":0},{"$f":"SUM(K14:K16)","v":0}]
["Vermögen"]
["Verfügbare finanzielle Mittel",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D9","v":103496.01},null,{"$f":"G19-F19","v":-103496.01},0,0,{"$f":"I19-J19","v":0}]
["angeordnete Vermögensänderung lt. FO",null,null,null,null,{"$f":"Deckblatt!C7","v":0},null,{"$f":"G20-F20","v":0},{"$f":"IF(F19<Mindestreserve!D17,Mindestreserve!D17-F19,0)","v":0},null,{"$f":"I20-J20","v":0}]
["Zinsen auf Vermögen",null,null,null,null,0,0,{"$f":"G21-F21","v":0},0,0,{"$f":"I21-J21","v":0}]
["geplante Veränderung des Vermögens Ansparen/Entnahme",null,null,null,null,{"$f":"Deckblatt!C6*(-1)","v":-6742.66666666666},0,{"$f":"G22-F22","v":6742.66666666666},{"$f":"Deckblatt!F6","v":0},0,{"$f":"I22-J22","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F19:F22)","v":96753.3433333334},{"$f":"SUM(G19:G22)","v":0},{"$f":"SUM(H19:H22)","v":-96753.3433333334},{"$f":"SUM(I19:I22)","v":0},{"$f":"SUM(J19:J22)","v":0},{"$f":"SUM(K19:K22)","v":0}]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F17,F12,F6)","v":160800},{"$f":"SUM(G17,G12,G6)","v":160691.34},{"$f":"SUM(H17,H12,H6)","v":-108.66},{"$f":"SUM(I17,I12,I6)","v":6300},{"$f":"SUM(J17,J12,J6)","v":4267.05},{"$f":"SUM(K17,K12,K6)","v":2032.95}]

{"sheet":"Konferenzen","index":7,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[4,8,4,11],[5,0,5,1]]}
["Konferenzen","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"]
["O.S.T. (Bereich Bund/Land) / Hochschulpolitik",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}]
["BuFaTa / FSR",0.5,0,0,{"$f":"D4-C4","v":0},0,0,{"$f":"F4-G4","v":0},1000,{"$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":1000},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["CoCo-Pauschale",1,0,0,{"$f":"D5-C5","v":0},250,0,{"$f":"F5-G5","v":250},null,null,null,null,{"$f":"(D5-G5+J5)-(C5-F5)","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},{"$f":"SUM(D3:D5)","v":0},{"$f":"SUM(E3:E5)","v":0},{"$f":"SUM(F3:F5)","v":750},{"$f":"SUM(G3:G5)","v":0},{"$f":"SUM(H3:H5)","v":750},{"$f":"SUM(I3:I5)","v":1500},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":1500},{"$f":"SUM(L3:L5)","v":500},{"$f":"(D6-G6+J6)-(C6-F6)","v":750}]

{"sheet":"Personal","index":8,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[11,8,11,11],[12,0,12,1],[13,0,13,12],[14,0,15,0],[14,1,15,1],[14,2,14,4],[14,5,14,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[17,0,17,1],[18,0,18,12],[19,0,19,1]]}
["Schulungen","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"]
["Akkreditierung / Qualitätsmanagement",1,0,0,{"$f":"D3-C3","v":0},2500,0,{"$f":"F3-G3","v":2500},2500,{"$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":2500},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":2500},{"$f":"(D3-G3+J3)-(C3-F3)","v":2500}]
["Sozialberatung (BaföG, Jobberatung) / Soziales",1,0,0,{"$f":"D4-C4","v":0},50,0,{"$f":"F4-G4","v":50},50,{"$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":50},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":50},{"$f":"(D4-G4+J4)-(C4-F4)","v":50}]
["Schulungen studentische und akademische\nSelbstverwaltung (Studienprüfungsordnung) / Studium",1,0,0,{"$f":"D5-C5","v":0},100,0,{"$f":"F5-G5","v":100},100,{"$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":100},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":100},{"$f":"(D5-G5+J5)-(C5-F5)","v":100}]
["Prüfungsangelegenheiten / Studium",1,0,0,{"$f":"D6-C6","v":0},50,0,{"$f":"F6-G6","v":50},50,{"$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":50},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":50},{"$f":"(D6-G6+J6)-(C6-F6)","v":50}]
["pol. Bildung, Antidiskriminierung, Gender- / Hochschulpolitik",1,0,0,{"$f":"D7-C7","v":0},100,0,{"$f":"F7-G7","v":100},150,{"$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":150},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":100},{"$f":"(D7-G7+J7)-(C7-F7)","v":100}]
["Konstituierungsseminar (KoSe) / StuRa",1,0,0,{"$f":"D8-C8","v":0},750,581.2,{"$f":"F8-G8","v":168.8},0,{"$f":"IF(H8<0,IF(I8>0,IF((H8*(-1))>I8,I8,H8*(-1)),0),0)","v":0},{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":0},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":160},{"$f":"(D8-G8+J8)-(C8-F8)","v":168.8}]
["Lern- und Informationsseminar (LuISe) / StuRa",1,0,0,{"$f":"D9-C9","v":0},750,0,{"$f":"F9-G9","v":750},1000,{"$f":"IF(H9<0,IF(I9>0,IF((H9*(-1))>I9,I9,H9*(-1)),0),0)","v":0},{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":1000},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":750},{"$f":"(D9-G9+J9)-(C9-F9)","v":750}]
["CLearance And Rapprochement (CLARA) / StuRa",1,0,0,{"$f":"D10-C10","v":0},50,95.06,{"$f":"F10-G10","v":-45.06},50,{"$f":"IF(H10<0,IF(I10>0,IF((H10*(-1))>I10,I10,H10*(-1)),0),0)","v":45.06},{"$f":"IF(OR(J10>I10,H10+I10<0),MAKRO1(),ROUNDDOWN(I10-J10,-1))","v":0},{"$f":"IF(H10>0,ROUNDDOWN(H10,-1),0)","v":0},{"$f":"(D10-G10+J10)-(C10-F10)","v":0}]
["Veranstaltung zur fachlichen Weiterbildung / Studium",1,0,0,{"$f":"D11-C11","v":0},500,0,{"$f":"F11-G11","v":500},900,{"$f":"IF(H11<0,IF(I11>0,IF((H11*(-1))>I11,I11,H11*(-1)),0),0)","v":0},{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":900},{"$f":"IF(H11>0,ROUNDDOWN(H11,-1),0)","v":500},{"$f":"(D11-G11+J11)-(C11-F11)","v":500}]
["CoCo-Pauschale",1,0,0,{"$f":"D12-C12","v":0},250,0,{"$f":"F12-G12","v":250}]
["Zwischensumme:",null,{"$f":"SUM(C3:C12)","v":0},{"$f":"SUM(D3:D12)","v":0},{"$f":"SUM(E3:E12)","v":0},{"$f":"SUM(F3:F12)","v":5100},{"$f":"SUM(G3:G12)","v":676.26},{"$f":"SUM(H3:H12)","v":4423.74},{"$f":"SUM(I3:I12)","v":4800},{"$f":"SUM(J3:J12)","v":45.06},{"$f":"SUM(K3:K12)","v":4750},{"$f":"SUM(L3:L12)","v":4210},{"$f":"(D13-G13+J13)-(C13-F13)","v":4468.8}]
[]
["Wahlen","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"]
["Informationen zu Wahlen",2,0,0,{"$f":"D17-C17","v":0},100,0,{"$f":"F17-G17","v":100},150,{"$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":150},{"$f":"IF(H17>0,ROUNDDOWN(H17,-1),0)","v":100},{"$f":"(D17-G17+J17)-(C17-F17)","v":100}]
["Zwischensumme:",null,{"$f":"C17","v":0},{"$f":"D17","v":0},{"$f":"E17","v":0},{"$f":"F17","v":100},{"$f":"G17","v":0},{"$f":"H17","v":100},{"$f":"SUM(I17)","v":150},{"$f":"SUM(J17)","v":0},{"$f":"SUM(K17)","v":150},{"$f":"SUM(L17)","v":100},{"$f":"(D18-G18+J18)-(C18-F18)","v":100}]
[]
["Gesamtsumme:",null,{"$f":"SUM(C13+C18)","v":0},{"$f":"SUM(D13+D18)","v":0},{"$f":"SUM(E13+E18)","v":0},{"$f":"SUM(F13+F18)","v":5200},{"$f":"SUM(G13+G18)","v":676.26},{"$f":"SUM(H13+H18)","v":4523.74},{"$f":"SUM(I13+I18)","v":4950},{"$f":"SUM(J13+J18)","v":45.06},{"$f":"SUM(K13+K18)","v":4900},{"$f":"SUM(L13+L18)","v":4310},{"$f":"(D20-G20+J20)-(C20-F20)","v":4568.8}]

{"sheet":"Finanzen","index":9,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,2,1,2],[0,3,0,5],[0,6,0,8],[5,0,5,2]]}
["Referat Finanzen",null,"Häufigkeit","Einnahmen",null,null,"Ausgaben"]
[null,null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Kontoführung mit online-banking","Sachkonto: 4970",12,0,0,{"$f":"E3-D3","v":0},600,414.4,{"$f":"G3-H3","v":185.6}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1000,985.32,{"$f":"G4-H4","v":14.68}]
["CoCo-Pauschale",null,null,0,0,{"$f":"E5-D5","v":0},250,0,{"$f":"G5-H5","v":250}]
["Gesamtsumme:",null,null,{"$f":"SUM(D3:D5)","v":0},{"$f":"SUM(E3:E5)","v":0},{"$f":"SUM(F3:F5)","v":0},{"$f":"SUM(G3:G5)","v":1850},{"$f":"SUM(H3:H5)","v":1399.72},{"$f":"SUM(I3:I5)","v":450.28}]

{"sheet":"Hochschulpolitik","index":10,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[7,0,7,1]]}
["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"]
["\"festival contre le rasism\"",1,0,0,{"$f":"D3-C3","v":0},100,0,{"$f":"F3-G3","v":100},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":100},{"$f":"(D3-G3+J3)-(C3-F3)","v":100}]
["Aktionstage gegen Sexismus und Homophobie",1,0,0,{"$f":"D4-C4","v":0},100,0,{"$f":"F4-G4","v":100},100,{"$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":100},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":100},{"$f":"(D4-G4+J4)-(C4-F4)","v":100}]
["Aktionen, Festivals und Demonstrationen",null,0,0,{"$f":"D5-C5","v":0},100,0,{"$f":"F5-G5","v":100},150,{"$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":150},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":100},{"$f":"(D5-G5+J5)-(C5-F5)","v":100}]
["Förderverein HTW Dresden - Mitgliedsbeitrag",1,0,0,{"$f":"D6-C6","v":0},150,150,{"$f":"F6-G6","v":0},0,{"$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":0},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":0},{"$f":"(D6-G6+J6)-(C6-F6)","v":0}]
["politische Bildung / Umweltbildung",null,0,0,{"$f":"D7-C7","v":0},400,0,{"$f":"F7-G7","v":400},450,{"$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":450},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":400},{"$f":"(D7-G7+J7)-(C7-F7)","v":400}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},{"$f":"SUM(D3:D7)","v":0},{"$f":"SUM(E3:E7)","v":0},{"$f":"SUM(F3:F7)","v":850},{"$f":"SUM(G3:G7)","v":150},{"$f":"SUM(H3:H7)","v":700},{"$f":"SUM(I3:I7)","v":700},{"$f":"SUM(J3:J7)","v":0},{"$f":"SUM(K3:K7)","v":700},{"$f":"SUM(L3:L7)","v":700},{"$f":"(D8-G8+J8)-(C8-F8)","v":700}]

{"sheet":"Internationales","index":11,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[4,8,4,11],[5,0,5,1]]}
["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"]
["DAAD Mitgliedsbeitrag",1,0,0,{"$f":"D3-C3","v":0},50,50,{"$f":"F3-G3","v":0},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":0},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Internationaler Tag",1,0,0,{"$f":"D4-C4","v":0},50,0,{"$f":"F4-G4","v":50},50,{"$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":50},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":50},{"$f":"(D4-G4+J4)-(C4-F4)","v":50}]
["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},{"$f":"SUM(D3:D5)","v":0},{"$f":"SUM(E3:E5)","v":0},{"$f":"SUM(F3:F5)","v":350},{"$f":"SUM(G3:G5)","v":50},{"$f":"SUM(H3:H5)","v":300},{"$f":"SUM(I3:I5)","v":50},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":50},{"$f":"SUM(L3:L5)","v":50},{"$f":"(D6-G6+J6)-(C6-F6)","v":300}]

{"sheet":"Kultur","index":12,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[11,8,11,11],[13,0,13,1]]}
["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"]
["Semestereröffnungspartys (SEP)",2,1000,0,{"$f":"D3-C3","v":-1000},1000,385.62,{"$f":"F3-G3","v":614.38},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":610},{"$f":"(D3-G3+J3)-(C3-F3)","v":-385.62}]
["Kino in der Hochschule",null,{"$f":"400-400*(2/3)","v":133.333333333333},0,{"$f":"D4-C4","v":-133.333333333333},{"$f":"600-600*2/3","v":200},0,{"$f":"F4-G4","v":200},350,{"$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":350},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":200},{"$f":"(D4-G4+J4)-(C4-F4)","v":66.6666666666666}]
["Rockkonzert",1,500,0,{"$f":"D5-C5","v":-500},500,48.2,{"$f":"F5-G5","v":451.8},1000,{"$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":1000},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":450},{"$f":"(D5-G5+J5)-(C5-F5)","v":-48.2}]
["Spieleabende",2,0,0,{"$f":"D6-C6","v":0},100,0,{"$f":"F6-G6","v":100},0,{"$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":0},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":100},{"$f":"(D6-G6+J6)-(C6-F6)","v":100}]
["Dies Academicus",1,0,0,{"$f":"D7-C7","v":0},300,0,{"$f":"F7-G7","v":300},0,{"$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":300},{"$f":"(D7-G7+J7)-(C7-F7)","v":300}]
["LAN-Partys",1,300,110,{"$f":"D8-C8","v":-190},300,310.28,{"$f":"F8-G8","v":-10.28},600,{"$f":"IF(H8<0,IF(I8>0,IF((H8*(-1))>I8,I8,H8*(-1)),0),0)","v":10.28},{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":580},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":0},{"$f":"(D8-G8+J8)-(C8-F8)","v":-190}]
["Fakfeste & Sommerfeste",null,2500,0,{"$f":"D9-C9","v":-2500},2500,0,{"$f":"F9-G9","v":2500},1230,{"$f":"IF(H9<0,IF(I9>0,IF((H9*(-1))>I9,I9,H9*(-1)),0),0)","v":0},{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":1230},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":2500},{"$f":"(D9-G9+J9)-(C9-F9)","v":0}]
["Erstifahrten",null,0,0,{"$f":"D10-C10","v":0},0,0,{"$f":"F10-G10","v":0},3500,{"$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":3500},{"$f":"IF(H10>0,ROUNDDOWN(H10,-1),0)","v":0},{"$f":"(D10-G10+J10)-(C10-F10)","v":0}]
["Weihnachtsfeiern",null,3000,0,{"$f":"D11-C11","v":-3000},3500,0,{"$f":"F11-G11","v":3500},0,{"$f":"IF(H11<0,IF(I11>0,IF((H11*(-1))>I11,I11,H11*(-1)),0),0)","v":0},{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":0},{"$f":"IF(H11>0,ROUNDDOWN(H11,-1),0)","v":3500},{"$f":"(D11-G11+J11)-(C11-F11)","v":500}]
["CoCo-Pauschale",null,0,0,{"$f":"D12-C12","v":0},250,0,{"$f":"F12-G12","v":250}]
["Teambuilding (Gruppenkuscheln?)",1,1500,0,{"$f":"D13-C13","v":-1500},2500,0,{"$f":"F13-G13","v":2500},4360,{"$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":4360},{"$f":"IF(H13>0,ROUNDDOWN(H13,-1),0)","v":2500},{"$f":"(D13-G13+J13)-(C13-F13)","v":1000}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C13)","v":8933.33333333333},{"$f":"SUM(D3:D13)","v":110},{"$f":"SUM(E3:E13)","v":-8823.33333333333},{"$f":"SUM(F3:F13)","v":11150},{"$f":"SUM(G3:G13)","v":744.1},{"$f":"SUM(H3:H13)","v":10405.9},{"$f":"SUM(I3:I13)","v":11040},{"$f":"SUM(J3:J13)","v":10.28},{"$f":"SUM(K3:K13)","v":11020},{"$f":"SUM(L3:L13)","v":10160},{"$f":"(D14-G14+J14)-(C14-F14)","v":1592.84666666667}]

{"sheet":"Öffentlichkeitsarbeit","index":13,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[8,0,8,1]]}
["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"]
["Druck Hochschul-ABC (Anteilig)",1,0,0,{"$f":"D3-C3","v":0},400,0,{"$f":"F3-G3","v":400},450,{"$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":450},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":400},{"$f":"(D3-G3+J3)-(C3-F3)","v":400}]
["Hochschulveranstaltungen",2,0,0,{"$f":"D4-C4","v":0},200,0,{"$f":"F4-G4","v":200},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":200},{"$f":"(D4-G4+J4)-(C4-F4)","v":200}]
["Werbemittel",null,0,0,{"$f":"D5-C5","v":0},750,13.5,{"$f":"F5-G5","v":736.5},840,{"$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":840},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":730},{"$f":"(D5-G5+J5)-(C5-F5)","v":736.5}]
["Interessiertengrillen",2,0,0,{"$f":"D6-C6","v":0},250,0,{"$f":"F6-G6","v":250},0,{"$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":0},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":250},{"$f":"(D6-G6+J6)-(C6-F6)","v":250}]
["CoCo-Pauschale",null,0,0,{"$f":"D7-C7","v":0},250,0,{"$f":"F7-G7","v":250}]
["Merchandise u.ä.",null,750,60,{"$f":"D8-C8","v":-690},1000,0,{"$f":"F8-G8","v":1000},220,{"$f":"IF(H8<0,IF(I8>0,IF((H8*(-1))>I8,I8,H8*(-1)),0),0)","v":0},{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":220},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":1000},{"$f":"(D8-G8+J8)-(C8-F8)","v":310}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C8)","v":750},{"$f":"SUM(D3:D8)","v":60},{"$f":"SUM(E3:E8)","v":-690},{"$f":"SUM(F3:F8)","v":2850},{"$f":"SUM(G3:G8)","v":13.5},{"$f":"SUM(H3:H8)","v":2836.5},{"$f":"SUM(I3:I8)","v":1710},{"$f":"SUM(J3:J8)","v":0},{"$f":"SUM(K3:K8)","v":1710},{"$f":"SUM(L3:L8)","v":2580},{"$f":"(D9-G9+J9)-(C9-F9)","v":2146.5}]

{"sheet":"Qualitätsmanagement","index":14,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[4,8,4,11],[5,0,5,1]]}
["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",2,0,0,{"$f":"D3-C3","v":0},250,0,{"$f":"F3-G3","v":250},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":250},{"$f":"(D3-G3+J3)-(C3-F3)","v":250}]
["Erstsemestereinführung (ESE)",1,0,0,{"$f":"D4-C4","v":0},4500,4010.3,{"$f":"F4-G4","v":489.7},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":480},{"$f":"(D4-G4+J4)-(C4-F4)","v":489.7}]
["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},{"$f":"SUM(D3:D5)","v":0},{"$f":"SUM(E3:E5)","v":0},{"$f":"SUM(F3:F5)","v":5000},{"$f":"SUM(G3:G5)","v":4010.3},{"$f":"SUM(H3:H5)","v":989.7},{"$f":"SUM(I3:I5)","v":0},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":0},{"$f":"SUM(L3:L5)","v":730},{"$f":"SUM(M3:M5)","v":739.7}]

{"sheet":"Soziales","index":15,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[5,8,5,11],[6,8,6,11],[7,0,7,1]]}
["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"]
["Projekt \"Studieren mit Kind\"",null,0,0,{"$f":"D3-C3","v":0},200,0,{"$f":"F3-G3","v":200},200,{"$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":200},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":200},{"$f":"(D3-G3+J3)-(C3-F3)","v":200}]
["Projekt Studieren mit Beeinträchtigung",null,200,0,{"$f":"D4-C4","v":-200},200,0,{"$f":"F4-G4","v":200},100,{"$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":100},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":200},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["Veranstaltungen zu sozialen Belangen",2,0,0,{"$f":"D5-C5","v":0},150,0,{"$f":"F5-G5","v":150},150,{"$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":150},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":150},{"$f":"(D5-G5+J5)-(C5-F5)","v":150}]
["Finanzielle Nothilfe (Covid-19)",null,0,0,{"$f":"D6-C6","v":0},0,0,{"$f":"F6-G6","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":200},{"$f":"SUM(D3:D7)","v":0},{"$f":"SUM(E3:E7)","v":-200},{"$f":"SUM(F3:F7)","v":800},{"$f":"SUM(G3:G7)","v":0},{"$f":"SUM(H3:H7)","v":800},{"$f":"SUM(I3:I7)","v":450},{"$f":"SUM(J3:J7)","v":0},{"$f":"SUM(K3:K7)","v":450},{"$f":"SUM(L3:L7)","v":550},{"$f":"(D8-G8+J8)-(C8-F8)","v":600}]

{"sheet":"Sport","index":16,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[10,0,10,1]]}
["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},250,{"$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":250},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Startgebühren",1,0,0,{"$f":"D4-C4","v":0},200,0,{"$f":"F4-G4","v":200},100,{"$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":100},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":200},{"$f":"(D4-G4+J4)-(C4-F4)","v":200}]
["Drachenbootrennen",1,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}]
["sächsische Beachmeisterschaften",1,0,0,{"$f":"D6-C6","v":0},0,0,{"$f":"F6-G6","v":0},0,{"$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":0},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":0},{"$f":"(D6-G6+J6)-(C6-F6)","v":0}]
["Gesundheitsmanagement ",1,0,0,{"$f":"D7-C7","v":0},500,0,{"$f":"F7-G7","v":500},0,{"$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},0,{"$f":"(D7-G7+J7)-(C7-F7)","v":500}]
["Ausflüge",1,200,0,{"$f":"D8-C8","v":-200},400,0,{"$f":"F8-G8","v":400},0,{"$f":"IF(H8<0,IF(I8>0,IF((H8*(-1))>I8,I8,H8*(-1)),0),0)","v":0},{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":0},0,{"$f":"(D8-G8+J8)-(C8-F8)","v":200}]
["Hochschulsportfest",1,0,0,{"$f":"D9-C9","v":0},0,0,{"$f":"F9-G9","v":0},150,{"$f":"IF(H9<0,IF(I9>0,IF((H9*(-1))>I9,I9,H9*(-1)),0),0)","v":0},{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":150},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":0},{"$f":"(D9-G9+J9)-(C9-F9)","v":0}]
["CoCo-Pauschale",null,0,0,{"$f":"D10-C10","v":0},250,0,{"$f":"F10-G10","v":250},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},0,{"$f":"(D10-G10+J10)-(C10-F10)","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C10)","v":200},{"$f":"SUM(D3:D10)","v":0},{"$f":"SUM(E3:E10)","v":-200},{"$f":"SUM(F3:F10)","v":1850},{"$f":"SUM(G3:G10)","v":0},{"$f":"SUM(H3:H10)","v":1850},{"$f":"SUM(I3:I10)","v":500},{"$f":"SUM(J3:J10)","v":0},{"$f":"SUM(K3:K10)","v":500},{"$f":"SUM(L3:L10)","v":700},{"$f":"(D11-G11+J11)-(C11-F11)","v":1650}]

{"sheet":"Studium","index":17,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[5,8,5,11],[6,0,6,1]]}
["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"]
["Kompetenzorientiertes Prüfen",null,0,0,{"$f":"D3-C3","v":0},0,0,{"$f":"F3-G3","v":0},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":0},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Study Night o.ä.",1,0,0,{"$f":"D4-C4","v":0},0,0,{"$f":"F4-G4","v":0},550,{"$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":550},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["Systemakkreditierung, was nun?",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},{"$f":"SUM(D3:D6)","v":0},{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":250},{"$f":"SUM(G3:G6)","v":0},{"$f":"SUM(H3:H6)","v":250},{"$f":"SUM(I3:I6)","v":550},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":550},{"$f":"SUM(L3:L6)","v":0},{"$f":"(D7-G7+J7)-(C7-F7)","v":250}]

{"sheet":"Studentische Verwaltung","index":18,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[15,0,15,1]]}
["Referat Verwaltung","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"]
["Telefon",null,0,0,{"$f":"D3-C3","v":0},50,0,{"$f":"F3-G3","v":50},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":50},{"$f":"(D3-G3+J3)-(C3-F3)","v":50}]
["Domains",null,0,0,{"$f":"D4-C4","v":0},150,141.19,{"$f":"F4-G4","v":8.81},30,{"$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":30},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":8.81}]
["Beitrag Gruppenausweis für Jugendherbergen (DJH)",1,0,0,{"$f":"D5-C5","v":0},26,26,{"$f":"F5-G5","v":0},30,{"$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":30},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":0},{"$f":"(D5-G5+J5)-(C5-F5)","v":0}]
["Labeldrucker (für die ISIC-Ausweise)",1,0,0,{"$f":"D6-C6","v":0},0,0,{"$f":"F6-G6","v":0},0,{"$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":0},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":0},{"$f":"(D6-G6+J6)-(C6-F6)","v":0}]
["Vertrieb ISIC",null,200,54,{"$f":"D7-C7","v":-146},0,0,{"$f":"F7-G7","v":0},200,{"$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":200},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":0},{"$f":"(D7-G7+J7)-(C7-F7)","v":-146}]
["Dienste für elektronische Datenverarbeitung ",null,0,0,{"$f":"D8-C8","v":0},15000,0,{"$f":"F8-G8","v":15000},900,{"$f":"IF(H8<0,IF(I8>0,IF((H8*(-1))>I8,I8,H8*(-1)),0),0)","v":0},{"$f":"IF(OR(J8>I8,H8+I8<0),MAKRO1(),ROUNDDOWN(I8-J8,-1))","v":900},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":15000},{"$f":"(D8-G8+J8)-(C8-F8)","v":15000}]
["Anschaffungen zwecks Umstrukturierung StuRa",null,0,0,{"$f":"D9-C9","v":0},1000,0,{"$f":"F9-G9","v":1000},0,{"$f":"IF(H9<0,IF(I9>0,IF((H9*(-1))>I9,I9,H9*(-1)),0),0)","v":0},{"$f":"IF(OR(J9>I9,H9+I9<0),MAKRO1(),ROUNDDOWN(I9-J9,-1))","v":0},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":1000},{"$f":"(D9-G9+J9)-(C9-F9)","v":1000}]
["andauernde Betreuung Server durch Externe",null,0,0,{"$f":"D10-C10","v":0},2400,0,{"$f":"F10-G10","v":2400},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":2400},{"$f":"(D10-G10+J10)-(C10-F10)","v":2400}]
["Beiträge/Gebühren",null,0,0,{"$f":"D11-C11","v":0},0,0,{"$f":"F11-G11","v":0},0,{"$f":"IF(H11<0,IF(I11>0,IF((H11*(-1))>I11,I11,H11*(-1)),0),0)","v":0},{"$f":"IF(OR(J11>I11,H11+I11<0),MAKRO1(),ROUNDDOWN(I11-J11,-1))","v":0},{"$f":"IF(H11>0,ROUNDDOWN(H11,-1),0)","v":0},{"$f":"(D11-G11+J11)-(C11-F11)","v":0}]
["Büromaterial und -ausstattung",null,0,0,{"$f":"D12-C12","v":0},500,86.7,{"$f":"F12-G12","v":413.3},250,{"$f":"IF(H12<0,IF(I12>0,IF((H12*(-1))>I12,I12,H12*(-1)),0),0)","v":0},{"$f":"IF(OR(J12>I12,H12+I12<0),MAKRO1(),ROUNDDOWN(I12-J12,-1))","v":250},{"$f":"IF(H12>0,ROUNDDOWN(H12,-1),0)","v":410},{"$f":"(D12-G12+J12)-(C12-F12)","v":413.3}]
["Studienmaterial (z.B. Bautabellen, Laborkittel, etc.)",null,1000,0,{"$f":"D13-C13","v":-1000},1000,1633.28,{"$f":"F13-G13","v":-633.28},700,{"$f":"IF(H13<0,IF(I13>0,IF((H13*(-1))>I13,I13,H13*(-1)),0),0)","v":633.28},{"$f":"IF(OR(J13>I13,H13+I13<0),MAKRO1(),ROUNDDOWN(I13-J13,-1))","v":60},{"$f":"IF(H13>0,ROUNDDOWN(H13,-1),0)","v":0},{"$f":"(D13-G13+J13)-(C13-F13)","v":-1000}]
["Projekt \"How to StuRa\"",null,0,0,0,9000,0,{"$f":"F14-G14","v":9000},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},9000,{"$f":"(D14-G14+J14)-(C14-F14)","v":9000}]
["laufende Kosten für Druck, samt Nebenkosten",null,0,0,{"$f":"D15-C15","v":0},500,209.79,{"$f":"F15-G15","v":290.21},470,{"$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":470},{"$f":"IF(H15>0,ROUNDDOWN(H15,-1),0)","v":290},{"$f":"(D15-G15+J15)-(C15-F15)","v":290.21}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C15)","v":1200},{"$f":"SUM(D3:D15)","v":54},{"$f":"SUM(E3:E15)","v":-1146},{"$f":"SUM(F3:F15)","v":29626},{"$f":"SUM(G3:G15)","v":2096.96},{"$f":"SUM(H3:H15)","v":27529.04},{"$f":"SUM(I3:I15)","v":2680},{"$f":"SUM(J3:J15)","v":633.28},{"$f":"SUM(K3:K15)","v":2040},{"$f":"SUM(L3:L15)","v":28150},{"$f":"(D16-G16+J16)-(C16-F16)","v":27016.32}]