{"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 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,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,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 Studentinnenschaft HTW Dresden",2023,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J54","v":25950},{"$f":"'Detailblatt I'!K54","v":0},{"$f":"D3-C3","v":-25950},{"$f":"'Detailblatt I'!M54","v":260786},{"$f":"'Detailblatt I'!N54","v":0},{"$f":"(F3-G3)","v":260786}]
["Beitragseinnahmen der Student:innen",null,{"$f":"'Detailblatt II'!F24","v":184600},{"$f":"'Detailblatt II'!G24","v":26710.67},{"$f":"D4-C4","v":-157889.33},{"$f":"'Detailblatt II'!I24","v":0},{"$f":"'Detailblatt II'!J24","v":0},{"$f":"(F4-G4)","v":0}]
["Zinsen",null,{"$f":"'Detailblatt II'!F28","v":0},{"$f":"'Detailblatt II'!G28","v":0},{"$f":"D5-C5","v":0},{"$f":"'Detailblatt II'!I28","v":0},{"$f":"'Detailblatt II'!J28","v":0},{"$f":"(F5-G5)","v":0}]
["Entnahme (=Einnahme) & Ansparen (=Ausgabe) \nvon Vermögen",null,{"$f":"IF((Beitragsermittlung!B16)-('Detailblatt II'!F22+'Detailblatt II'!F23)>0,(Beitragsermittlung!B16)-('Detailblatt II'!F22+'Detailblatt II'!F23),0)","v":328.720000000001},0,{"$f":"D6-C6","v":-328.720000000001},0,{"$f":"'Detailblatt II'!G29","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'!I27","v":6542.71999999997},null,{"$f":"(F7-G7)","v":6542.71999999997}]
["Zurückführung an Student:innen (StuRa)",null,56450,{"$f":"C8","v":56450},{"$f":"D8-C8","v":0}]
[]
["Gesamt:",null,{"$f":"SUM(C3:C9)","v":267328.72},{"$f":"SUM(D3:D9)","v":83160.67},{"$f":"SUM(E3:E9)","v":-184168.05},{"$f":"SUM(F3:F9)","v":267328.72},{"$f":"SUM(G3:G9)","v":0},{"$f":"SUM(H3:H9)","v":267328.72}]
["Berechnung des Semesterbeitrag:"]
[null,"Planausgaben:",{"$f":"F10","v":267328.72},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":25950}]
["-","Zurückführung:",{"$f":"C8+C9","v":56450}]
["-","Vermögensänderung",{"$f":"C7","v":0}]
["=","Gesamt:",{"$f":"C12-C13-C14-C15-F6","v":184928.72}]
["/","Beitragszahlungen/Jahr:",{"$f":"'Detailblatt II'!D22+('Detailblatt II'!D23/6*4)","v":7250}]
["=","Stud./Semester:",{"$f":"IF((C16-'Detailblatt II'!F21)/Deckblatt!C17<0,0,(C16-'Detailblatt II'!F21)/Deckblatt!C17)","v":20.5694786206897},"Anzusetzender Semesterbeitrag:",null,{"$f":"ROUND((C18*2),0)/2","v":20.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":210878.72}]
["verfügbare finanzielle Mittel",{"$f":"'fortgeschr. Mittel+Konto'!D9","v":136217.28}]
["Obergrenze finanzielle Mittel",{"$f":"IF(B3<B4,B3,B4)","v":136217.28}]
[]
["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":142760}]
["(Verfügbare finanzielle Mittel nach Vermögensenkung)",{"$f":"B4-B7","v":136217.28}]
["Untergrenze für verfügbare finanzielle Mittel durch Bemessung an der Mindestreserve wird erreicht",{"$f":"IF(B5<B8,B8,B5)","v":142760}]
["beabsichtigte Senkung der verfügbaren finanziellen Mittel",{"$f":"B4-B10","v":-6542.71999999997}]
[]
["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'!F21)),Deckblatt!F10-Deckblatt!F6-(Deckblatt!C3+Deckblatt!C5+Deckblatt!C8+Deckblatt!C9+'Detailblatt II'!F21),Beitragsermittlung!B11)","v":-6542.71999999997}]
["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'!F21)","v":149128.72}]

{"sheet":"Berechnung Lohnkosten","index":3,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,3],[2,5,2,6],[2,8,2,9]]}
["Berechnung der anfallenden Lohnkosten in Abhängigkeit der besetzten Stellen"]
[]
["langfristige Stellen",null,null,null,null,"mittelfristige Stellen",null,null,"Besetzungsgrad mittelfristige Stellen"]
[null,"Fina. u. Verw.","Assi. d. GF.","IT Infr. ",null,null,null,null,"max. mögliche Stellen h/M",{"$f":"20*40","v":800}]
["TVL (50%)","E7 Stufe 3","E9b Stufe 3","E9b Stufe 3",null,null,null,null,"geschaffene Stellen h/M",615]
["Vertragsdauer","unbefristet","Bis 05.23","05.23-05.24",null,"Brutto je Stunde",12,null,"„Schaffungsgrad“",{"$f":"J5/J4","v":0.76875}]
["Bruttoverdienst",1580.42,1760.27,1760.27,null,"Brutto pro Monat",{"$f":"G6*40","v":480},null,"voraussichtlicher Besetzungsgrad",0.74]
[null,null,null,null,null,null,null,null,"entspricht besetzte Stellen h/M",{"$f":"J7*J5","v":455.1}]
["Nebenkosten",null,null,null,null,"Nebenkosten"]
["Rentenversicherung",146.98,163.71,163.71,null,"15% Rentenvers. Pauschal",{"$f":"G$7*0.15","v":72}]
["Arbeitslosenversicherung",18.97,21.12,21.12,null,"13% Krankenvers. Pauschal",{"$f":"G$7*0.13","v":62.4}]
["Krankenversicherung",125.64,139.94,139.94,null,"2% Steuerpauschale",{"$f":"G$7*0.02","v":9.6}]
["Pflegeversicherung",16.2,18.04,18.04,null,"0,9% Umlage 1 U1",{"$f":"G$7*0.009","v":4.32}]
["Umlage U1",31.61,35.21,35.21,null,"0,29% Umlage 2 U2",{"$f":"G$7*0.0029","v":1.392}]
["Umlage U2",5.53,6.16,6.16,null,"0,06% Umlage 3 U3",{"$f":"G$7*0.0006","v":0.288}]
["Umlage U3",2.37,2.64,2.64,null,"1,3% Unfallversicherung",{"$f":"G$7*0.013","v":6.24}]
["Unfallversicherung (BG)",25.29,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},null,"Summe Lohnnebenk. ",{"$f":"SUM(G10:G16)","v":156.24}]
[]
["Bruttolohnkosten monatl.",{"$f":"B7+B18","v":1953.01},{"$f":"C7+C18","v":2175.25},{"$f":"D7+D18","v":2175.25},null,"Bruttolohnkosten monatl.",{"$f":"G18+G7","v":636.24}]
["Jahressonderzahlung",{"$f":"B20*0.8814","v":1721.383014},0,{"$f":"D20*0.7435*(8/12)","v":1078.19891666667}]
[]
["Bruttolohnkosten jährl.",{"$f":"B20*12+B21","v":25157.503014},{"$f":"C20*4+C21","v":8701},{"$f":"D20*8+D21","v":18480.1989166667},null,null,{"$f":"G20*(J8/40)*12","v":86865.8472}]
[]
["Jahresgesamtkosten",{"$f":"G23+B23+C23+D23","v":139204.549130667}]

{"sheet":"Überprüfung Beitragserhebung","index":4,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,3],[0,4,1,4],[0,5,1,8],[2,1,2,8],[12,1,12,8],[17,1,17,8],[20,1,20,8],[25,1,25,8],[28,1,28,8]]}
["Überprüfung der Beitragserhebung während des laufenden Kalenderjahres",null,null,null,"Jahr -",{"$f":"Deckblatt!B1","v":2023},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":-142760}]
[null,"Planausgaben",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$O$54)","v":-260786}]
[null,"nachrangig verwendbares Vorjahresbudget",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$P$54)","v":-43690}]
[null,"->davon verwendet",null,null,null,null,null,null,null,{"$f":"'Detailblatt I'!$Q$54","v":0}]
[null,"bereinigter Geldbestand",null,null,null,null,null,null,null,{"$f":"SUM(J13:J17)","v":-447236}]
[null,"Planeinnahmen",null,null,null,null,null,null,null,{"$f":"-('Detailblatt I'!$L$54)","v":25950}]
[null,"vorraussichtliche Beitragseinnahmen",null,null,null,null,null,null,null,{"$f":"-('Detailblatt II'!$H$23)","v":51000}]
[null,"vorraussichtlicher bereinigter Geldbestand",null,null,null,null,null,null,null,{"$f":"SUM(J18:J20)","v":-370286}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand",null,null,null,null,null,null,null,{"$f":"J18+J19","v":-421286}]
[null,"neuer Semesterbeitrag",null,null,null,null,null,null,null,{"$f":"ROUNDUP(-(J22/'Detailblatt II'!$D$23/4*6)/5,1)*5","v":140.5}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand bei 50% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J18+J19/2","v":-434261}]
[null,"neuer Semesterbeitrag bei Erfüllung von 50% der Planeinnahmen",null,null,null,null,null,null,null,{"$f":"ROUNDUP(-(J24/'Detailblatt II'!$D$23/4*6)/5,1)*5","v":145}]
[null,"vorraussichtlicher bereinigter Geldbestand bei 50% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J24+J20","v":-383261}]
[null,"durch Semesterbeitrag auszugleichender Geldbestand bei 25% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J18+J19/4","v":-440748.5}]
[null,"neuer Semesterbeitrag bei Erfüllung von 25% der Planeinnahmen",null,null,null,null,null,null,null,{"$f":"ROUNDUP(-(J27/'Detailblatt II'!$D$23/4*6)/5,1)*5","v":147}]
[null,"vorraussichtlicher bereinigter Geldbestand bei 25% Planeinnahmen",null,null,null,null,null,null,null,{"$f":"J27+J20","v":-389748.5}]

{"sheet":"fortgeschr. Mittel+Konto","index":5,"n_rows":25,"n_cols":9,"rows_kept":25,"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],[23,6,23,7],[24,6,24,7]]}
["Fortgeschriebene finanzielle Mittel + Bankkontostand",null,"Jahr -",{"$f":"Deckblatt!B1","v":2023}]
[null,null,null,null,null,"Nr.","voraussichtliche Ausgaben",null,"Saldo"]
[null,"Position","erstellt am:","2023-01-21",null,"1.","Personal (Okt.+Nov.+Dez. inkl. 13.Gehalt, ACON, Finanzamt)",null,{"$f":"3000+700","v":3700}]
[null,"Bank-/Kassenbestand bei Haushaltsplanerstellung",null,{"$f":"1750+299920.8+60000+4335.39","v":366006.19}]
["-","abzgl. voraussichtliche Ausgaben in",{"$f":"D1-1","v":2022},{"$f":"I25*(-1)","v":-93848.91},null,"2.","Finanzbeschlüsse aktuell noch nicht bezahlt in Summe",null,{"$f":"15+50+80+100+200+145+120+15+10+10+90+90-25+9+50+15+40+150","v":1164}]
["-","nachrangig verwendbares Vorjahresbudget",null,{"$f":"'Detailblatt I'!P54*(-1)-'Detailblatt I'!Q54*(-1)","v":-43690}]
["-","Zurückführung an Student:innen gesamt",null,{"$f":"SUM(Deckblatt!C8:C9)*-1","v":-56450},null,"3.","Schulungen/Konferenzen (KoSe)",null,0]
["-","Beitragseinnahmen anteilig WS 22/23 für 2023",null,{"$f":"'Detailblatt II'!F21*-1","v":-35800},null,"4.","voraussichtliche AE",null,6000]
["=","verfügbare finanzielle Mittel",null,{"$f":"D4+D5+D6+D7+D8","v":136217.28},null,"5.","offene Härtefallanträge",null,305]
[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,100]
[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,62987.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,204]
[null,null,null,null,null,"18.","Nothilfefonds saldiert",null,{"$f":"66079.01-46691","v":19388.01}]
[null,null,null,null,null,"=","Gesamtsumme:",null,{"$f":"SUM(I3:I24)","v":93848.91}]

{"sheet":"Mindestreserve","index":6,"n_rows":18,"n_cols":7,"rows_kept":18,"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,2],[7,3,7,4],[8,0,8,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],[12,0,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],[17,0,17,2],[17,3,17,4]]}
["Mindestreserve",null,null,"Jahr -",{"$f":"Deckblatt!B1","v":2023},"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"]
["Studentinnenrat"]
["Lohnkosten (Detailblatt I - Zelle M7)",null,null,{"$f":"'Detailblatt I'!M6","v":140000}]
["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":1000}]
["…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@'!F15","v":400}]
["Simkarten",null,null,{"$f":"'Verwaltung@'!F3","v":180}]
["Versicherung Beachvolleyballplätze",null,null,{"$f":"'Verwaltung@'!F6","v":500}]
["Gesamt:",null,null,{"$f":"SUM(D5:E17)","v":142760}]

{"sheet":"Detailblatt I","index":7,"n_rows":54,"n_cols":20,"rows_kept":54,"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,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],[11,1,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,0,21,8],[22,0,22,18],[23,1,23,8],[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,0,36,8],[37,0,37,18],[38,1,38,8],[38,9,41,11],[38,15,41,18],[39,1,39,8],[40,1,40,8],[41,0,41,8],[42,0,42,18],[43,0,43,4],[43,9,46,11],[43,12,44,14],[43,15,44,18],[44,0,44,4],[44,5,44,6],[44,7,44,8],[45,0,45,7],[46,0,46,8],[47,0,47,18],[48,1,48,8],[48,9,52,11],[48,15,52,18],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,0,52,8],[53,0,53,8]]}
["Detailblatt I",null,null,null,"Jahr -",{"$f":"Deckblatt!B1","v":2023},null,null,null,"Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr"]
[null,null,null,null,null,null,null,null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung der Studentinnenschaft HTW Dresden"]
["Sachkontonr."]
[2749,"Angestellte","AAG (Aufwendungsausgleichsgesetz)",null,null,null,null,null,null,null,0,{"$f":"K5","v":0}]
[4120,null,"Gehälter ",null,null,null,null,null,null,null,null,null,140000,0,{"$f":"M6-SUM(N6:N11)+L5","v":140000}]
[4121,null,"Lohnsteuer",null,null,null,null,null,null,null,null,null,null,0]
[4170,null,"Vermögenswirksame Leistungen",null,null,null,null,null,null,null,null,null,null,0]
[4130,null,"gesetzl. sozial. Aufw.",null,null,null,null,null,null,null,null,null,null,0]
[4138,null,"Beitrag BG (Berufsgenossenschaft)",null,null,null,null,null,null,null,null,null,null,0]
[4956,null,"Lohnbüro",null,null,null,null,null,null,null,null,null,null,0]
[4110,"AE (Aufwandsentschädigungen)",null,null,null,null,null,null,null,null,null,null,25000,0,{"$f":"M12-N12","v":25000}]
[4640,"Kaffee, Verpflegung & Verbrauchsgüter",null,null,null,null,null,null,null,null,null,null,1200,0,{"$f":"M13-N13","v":1200}]
[4670,"Allgemeine Reisekosten (keiner Veranstaltung zugeordnet)",null,null,null,null,null,null,null,null,null,null,500,0,{"$f":"M14-N14","v":500}]
[4909,"Präsidium & Vorstand der Geschäftsführung",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M15-N15","v":0}]
[4930,"Büro- und Verbrauchsmaterialien",null,null,null,null,null,null,null,null,null,null,100,0,{"$f":"M16-N16","v":100},100,{"$f":"IF(O16<0,IF(P16>0,IF((O16*(-1))>P16,P16,O16*(-1)),0),0)","v":0},{"$f":"IF(OR(Q16>P16,O16+P16<0),MAKRO1(),ROUNDDOWN(P16-Q16,-1))","v":100},{"$f":"IF(O16>0,ROUNDDOWN(O16,-1),0)","v":100}]
[4943,"Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,1000,0,{"$f":"M17-N17","v":1000},690,{"$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":690},{"$f":"IF(O17>0,ROUNDDOWN(O17,-1),0)","v":1000}]
[4944,"Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,250,0,{"$f":"M18-N18","v":250},250,{"$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":250},{"$f":"IF(O18>0,ROUNDDOWN(O18,-1),0)","v":250}]
[4945,"Durchführung Konferenzen",null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!F19","v":0},{"$f":"'Detailblatt II'!G19","v":0},{"$f":"'Detailblatt II'!H19","v":0},{"$f":"'Detailblatt II'!I19","v":1500},{"$f":"'Detailblatt II'!J19","v":0},{"$f":"'Detailblatt II'!K19","v":1500},{"$f":"'Detailblatt II'!L19","v":0},{"$f":"'Detailblatt II'!M19","v":0},{"$f":"'Detailblatt II'!N19","v":0},{"$f":"'Detailblatt II'!O19","v":1500},"← Zahlen auf Detailblatt 2 ändern!"]
[4950,"Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,3000,0,{"$f":"M20-N20","v":3000},8410,{"$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":8410},{"$f":"IF(O20>0,ROUNDDOWN(O20,-1),0)","v":3000}]
[4989,"Ersatz- und Neuanschaffung",null,null,null,null,null,null,null,null,null,null,3000,0,{"$f":"M21-N21","v":3000},1470,{"$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":1470},{"$f":"IF(O21>0,ROUNDDOWN(O21,-1),0)","v":3000}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J5:J21)","v":0},{"$f":"SUM(K5:K21)","v":0},{"$f":"SUM(L5:L21)","v":0},{"$f":"SUM(M5:M21)","v":175550},{"$f":"SUM(N5:N21)","v":0},{"$f":"SUM(O5:O21)","v":175550},{"$f":"SUM(P16:P21)","v":10920},{"$f":"SUM(Q16:Q21)","v":0},{"$f":"SUM(R16:R21)","v":10920},{"$f":"SUM(S16:S21)","v":8850}]
["Referate"]
[4960,"Finanzen",null,null,null,null,null,null,null,{"$f":"Finanzen!D7","v":0},{"$f":"Finanzen!E7","v":0},{"$f":"K24-J24","v":0},{"$f":"Finanzen!G7","v":2850},{"$f":"Finanzen!H7","v":0},{"$f":"M24-N24","v":2850}]
[4961,"Hochschulpolitik",null,null,null,null,null,null,null,{"$f":"Hochschulpolitik!C8","v":0},{"$f":"Hochschulpolitik!D8","v":0},{"$f":"K25-J25","v":0},{"$f":"Hochschulpolitik!F8","v":1000},{"$f":"Hochschulpolitik!G8","v":0},{"$f":"M25-N25","v":1000},{"$f":"Hochschulpolitik!I8","v":100},{"$f":"Hochschulpolitik!J8","v":0},{"$f":"Hochschulpolitik!K8","v":100},{"$f":"Hochschulpolitik!L8","v":1000}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C5","v":0},{"$f":"Internationales!D5","v":0},{"$f":"K26-J26","v":0},{"$f":"Internationales!F5","v":300},{"$f":"Internationales!G5","v":0},{"$f":"M26-N26","v":300},{"$f":"Internationales!I5","v":50},{"$f":"Internationales!J5","v":0},{"$f":"Internationales!K5","v":50},{"$f":"Internationales!L5","v":50}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C15","v":19750},{"$f":"Kultur!D15","v":0},{"$f":"K27-J27","v":-19750},{"$f":"Kultur!F15","v":21600},{"$f":"Kultur!G15","v":0},{"$f":"M27-N27","v":21600},{"$f":"Kultur!I15","v":8800},{"$f":"Kultur!J15","v":0},{"$f":"Kultur!K15","v":8800},{"$f":"Kultur!L15","v":21350}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C9","v":500},{"$f":"Öffentlichkeitsarbeit!D9","v":0},{"$f":"K28-J28","v":-500},{"$f":"Öffentlichkeitsarbeit!F9","v":8100},{"$f":"Öffentlichkeitsarbeit!G9","v":0},{"$f":"M28-N28","v":8100},{"$f":"Öffentlichkeitsarbeit!I9","v":1220},{"$f":"Öffentlichkeitsarbeit!J9","v":0},{"$f":"Öffentlichkeitsarbeit!K9","v":1220},{"$f":"Öffentlichkeitsarbeit!L9","v":5850}]
[4965,"Qualitätsmanagement",null,null,null,null,null,null,null,{"$f":"Qualitätsmanagement!C7","v":0},{"$f":"Qualitätsmanagement!D7","v":0},{"$f":"K29-J29","v":0},{"$f":"Qualitätsmanagement!F7","v":1500},{"$f":"Qualitätsmanagement!G7","v":0},{"$f":"M29-N29","v":1500},{"$f":"Qualitätsmanagement!I7","v":310},{"$f":"Qualitätsmanagement!J7","v":0},{"$f":"Qualitätsmanagement!K7","v":310},{"$f":"Qualitätsmanagement!L7","v":1250}]
[4966,"Soziales",null,null,null,null,null,null,null,{"$f":"Soziales!C7","v":0},{"$f":"Soziales!D7","v":0},{"$f":"K30-J30","v":0},{"$f":"Soziales!F7","v":600},{"$f":"Soziales!G7","v":0},{"$f":"M30-N30","v":600},{"$f":"Soziales!I7","v":350},{"$f":"Soziales!J7","v":0},{"$f":"Soziales!K7","v":350},{"$f":"Soziales!L7","v":350}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C12","v":2200},{"$f":"Sport!D12","v":0},{"$f":"K31-J31","v":-2200},{"$f":"Sport!F12","v":4250},{"$f":"Sport!G12","v":0},{"$f":"M31-N31","v":4250},{"$f":"Sport!I12","v":3910},{"$f":"Sport!J12","v":0},{"$f":"Sport!K12","v":3910},{"$f":"Sport!L12","v":4000}]
[4968,"Studium",null,null,null,null,null,null,null,{"$f":"Studium!C7","v":0},{"$f":"Studium!D7","v":0},{"$f":"K32-J32","v":0},{"$f":"Studium!F7","v":1500},{"$f":"Studium!G7","v":0},{"$f":"M32-N32","v":1500},{"$f":"Studium!I7","v":1250},{"$f":"Studium!J7","v":0},{"$f":"Studium!K7","v":1250},{"$f":"Studium!L7","v":1250}]
[4969,"Studentische Selbstverwaltung & Organisation",null,null,null,null,null,null,null,{"$f":"'Verwaltung@'!C18","v":3500},{"$f":"'Verwaltung@'!D18","v":0},{"$f":"K33-J33","v":-3500},{"$f":"'Verwaltung@'!F18","v":23236},{"$f":"'Verwaltung@'!G18","v":0},{"$f":"M33-N33","v":23236},{"$f":"'Verwaltung@'!I18","v":11150},{"$f":"'Verwaltung@'!J18","v":0},{"$f":"'Verwaltung@'!K18","v":11150},{"$f":"'Verwaltung@'!L18","v":22480}]
[4946,"Personal",null,null,null,null,null,null,null,{"$f":"Personal!C18","v":0},{"$f":"Personal!D18","v":0},{"$f":"K34-J34","v":0},{"$f":"Personal!F18","v":5850},{"$f":"Personal!G18","v":0},{"$f":"M34-N34","v":5850},{"$f":"Personal!I18","v":3560},{"$f":"Personal!J18","v":0},{"$f":"Personal!K18","v":3560},{"$f":"Personal!L18","v":5600}]
["----","Ausschüsse des Studentinnenrates",null,null,null,null,null,null,null,0,0,{"$f":"K35-J35","v":0},0,0,{"$f":"M35-N35","v":0}]
["----","weitere Vertretungen",null,null,null,null,null,null,null,0,0,{"$f":"K36-J36","v":0},0,0,{"$f":"M36-N36","v":0}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J24:J36)","v":25950},{"$f":"SUM(K24:K36)","v":0},{"$f":"SUM(L24:L36)","v":-25950},{"$f":"SUM(M24:M36)","v":70786},{"$f":"SUM(N24:N36)","v":0},{"$f":"SUM(O24:O36)","v":70786},{"$f":"SUM(P25:P34)","v":30700},{"$f":"SUM(Q25:Q34)","v":0},{"$f":"SUM(R25:R34)","v":30700},{"$f":"SUM(S25:S34)","v":63180}]
["Ausschüsse der Studentinnenschaft"]
["----","weitere Ausschüsse der Studentinnenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M39-N39","v":0}]
["----","Wahlausschuss der Studentinnenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M40-N40","v":0}]
[4941,"HFA (Härtefallausschuss der Studentinnenschaft)",null,null,null,null,null,null,null,null,null,null,3100,0,{"$f":"M41-N41","v":3100}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M39:M41)","v":3100},{"$f":"SUM(N39:N41)","v":0},{"$f":"SUM(O39:O41)","v":3100}]
[]
["Anzahl der Student:innen im:",null,null,null,null,"WiSe","23/24","SoSe",23]
["gesamt:",null,null,null,null,{"$f":"'Detailblatt II'!D23","v":4500},null,{"$f":"'Detailblatt II'!D22","v":4250}]
["#4942 Absicherung Teilnahme BuFaTas lt. Finanzordnung:",null,null,null,null,null,null,null,0.5,null,null,null,{"$f":"ROUND(($F$45+$H$45)*$I$46,-2)","v":4400},0,{"$f":"M46-N46","v":4400},2070,{"$f":"IF(O46<0,IF(P46>0,IF((O46*(-1))>P46,P46,O46*(-1)),0),0)","v":0},{"$f":"IF(OR(Q46>P46,O46+P46<0),MAKRO1(),ROUNDDOWN(P46-Q46,-1))","v":2070},{"$f":"IF(O46>0,ROUNDDOWN(O46,-1),0)","v":4400}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M46:M46)","v":4400},{"$f":"SUM(N46:N46)","v":0},{"$f":"SUM(O46:O46)","v":4400},{"$f":"SUM(P46:P46)","v":2070},{"$f":"SUM(Q46:Q46)","v":0},{"$f":"SUM(R46:R46)","v":2070},{"$f":"SUM(S46:S46)","v":4400}]
["Vertretungen der Student:innen"]
["----","Vertretungen der Student:innen in der Hochschule",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M49-N49","v":0}]
["----","Konferenz Sächsischer Studierendenschaft",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I6","v":2100},{"$f":"'Detailblatt II'!J6","v":0},{"$f":"M50-N50","v":2100}]
["----","Interessenvertretungen der Studentinnenschaft ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I14","v":4850},{"$f":"'Detailblatt II'!J14","v":0},{"$f":"M51-N51","v":4850}]
["----","weitere Interessenvertetungen",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M52-N52","v":0}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M49:M52)","v":6950},{"$f":"SUM(N49:N52)","v":0},{"$f":"SUM(O49:O52)","v":6950}]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J53,J47,J42,J37,J22)","v":25950},{"$f":"SUM(K53,K47,K42,K37,K22)","v":0},{"$f":"SUM(L53,L47,L42,L37,L22)","v":-25950},{"$f":"SUM(M53,M47,M42,M37,M22)","v":260786},{"$f":"SUM(N53,N47,N42,N37,N22)","v":0},{"$f":"SUM(O53,O47,O42,O37,O22)","v":260786},{"$f":"SUM(P22,P37,P47,P42,P53)","v":43690},{"$f":"SUM(Q47,Q37,Q22,Q42,Q53)","v":0},{"$f":"SUM(R47,R37,R22,R42,R53)","v":43690},{"$f":"SUM(S47,S37,S22,S42,S53)","v":76430}]

{"sheet":"Detailblatt II","index":8,"n_rows":31,"n_cols":16,"rows_kept":31,"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],[0,11,1,11],[0,12,1,12],[0,13,1,13],[0,14,1,14],[0,15,1,15],[2,0,2,15],[3,0,3,3],[4,0,4,3],[5,3,5,4],[6,0,6,15],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,3,13,4],[14,0,14,15],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,3,18,4],[19,0,19,15],[20,2,22,2],[23,3,23,4],[24,0,24,15],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,3,29,4],[30,0,30,4]]}
["Detailblatt II","Jahr -",{"$f":"Deckblatt!B1","v":2023},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},1450,0,{"$f":"I4-J4","v":1450}]
["Förderung der KSS (so auch Domain kss-sachsen.de)",null,null,null,1,0,0,{"$f":"G5-F5","v":0},650,0,{"$f":"I5-J5","v":650}]
[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":2100},{"$f":"SUM(J4:J5)","v":0},{"$f":"SUM(K4:K5)","v":2100}]
["Interessenvertretungen der Student:innenschaften - Konto: 4982"]
["faranto e.V.",null,null,null,null,0,0,{"$f":"G8-F8","v":0},800,0,{"$f":"I8-J8","v":800}]
["Erasmus Student Network",null,null,null,null,0,0,{"$f":"G9-F9","v":0},400,0,{"$f":"I9-J9","v":400}]
["bundesweite Interessenvertretungen (z.B. fzs etc.)",null,null,null,1,0,0,{"$f":"G10-F10","v":0},3500,0,{"$f":"I10-J10","v":3500}]
["Bundesverband Ausländischer Studierender e.V.",null,null,null,1,0,0,{"$f":"G11-F11","v":0},100,0,{"$f":"I11-J11","v":100}]
["Deustcher Akademischer AustauschDienst e.V. ",null,null,null,1,0,0,0,50,0,{"$f":"I12-J12","v":50}]
["weitere (ABS, bpm )",null,null,null,null,0,0,{"$f":"G13-F13","v":0},0,0,{"$f":"I13-J13","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F8:F13)","v":0},{"$f":"SUM(G8:G13)","v":0},{"$f":"SUM(H8:H13)","v":0},{"$f":"SUM(I8:I13)","v":4850},{"$f":"SUM(J8:J13)","v":0},{"$f":"SUM(K8:K13)","v":4850}]
["Durchführung Konferenzen - Konto: 4945"]
["O.S.T. Offenes Studierendentreffen (Bereich Bund/Land) /Hochschulpolitik",null,null,null,1,0,0,{"$f":"G16-F16","v":0},500,0,{"$f":"I16-J16","v":500},0,{"$f":"IF(K16<0,IF(L16>0,IF((K16*(-1))>L16,L16,K16*(-1)),0),0)","v":0},{"$f":"IF(OR(M16>L16,K16+L16<0),MAKRO1(),ROUNDDOWN(L16-M16,-1))","v":0},{"$f":"IF(K16>0,ROUNDDOWN(K16,-1),0)","v":500},{"$f":"(G16-J16+M16)-(F16-I16)","v":500}]
["BuFaTa",null,null,null,null,0,0,{"$f":"G17-F17","v":0},0,0,{"$f":"I17-J17","v":0},0,{"$f":"IF(K17<0,IF(L17>0,IF((K17*(-1))>L17,L17,K17*(-1)),0),0)","v":0},{"$f":"IF(OR(M17>L17,K17+L17<0),MAKRO1(),ROUNDDOWN(L17-M17,-1))","v":0},{"$f":"IF(K17>0,ROUNDDOWN(K17,-1),0)","v":0},{"$f":"(G17-J17+M17)-(F17-I17)","v":0}]
["weitere Konferenzen",null,null,null,null,0,0,{"$f":"G18-F18","v":0},1000,0,{"$f":"I18-J18","v":1000},0,{"$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":0},{"$f":"IF(K18>0,ROUNDDOWN(K18,-1),0)","v":1000}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F16:F18)","v":0},{"$f":"SUM(G16:G18)","v":0},{"$f":"SUM(H16:H18)","v":0},{"$f":"SUM(I16:I18)","v":1500},{"$f":"SUM(J16:J18)","v":0},{"$f":"SUM(K16:K18)","v":1500},{"$f":"SUM(L16:L18)","v":0},{"$f":"SUM(M16:M18)","v":0},{"$f":"SUM(N16:N18)","v":0},{"$f":"SUM(O16:O18)","v":1500},{"$f":"(G19-J19+M19)-(F19-I19)","v":1500}]
["Beitragseinnahmen"]
["Anteilig WS 22/23",23,"x Studentinnen",4666,1,{"$f":"ROUND((($B$21*$D$21)/6)*2,-2)","v":35800},26710.67,{"$f":"G21-F21","v":-9089.33},0,0,{"$f":"I21-J21","v":0}]
["SoSe 23",23,null,4250,1,{"$f":"ROUND($B$22*$D$22,-2)","v":97800},0,{"$f":"G22-F22","v":-97800},0,0,{"$f":"I22-J22","v":0}]
["Anteilig WS 23/24",17,null,4500,1,{"$f":"ROUND((($B$23*$D$23)/6)*4,-2)","v":51000},0,{"$f":"G23-F23","v":-51000},0,0,{"$f":"I23-J23","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F21:F23)","v":184600},{"$f":"SUM(G21:G23)","v":26710.67},{"$f":"SUM(H21:H23)","v":-157889.33},{"$f":"SUM(I21:I23)","v":0},{"$f":"SUM(J21:J23)","v":0},{"$f":"SUM(K21:K23)","v":0}]
["Vermögen"]
["Verfügbare finanzielle Mittel",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D9","v":136217.28},null,{"$f":"G26-F26","v":-136217.28},0,0,{"$f":"I26-J26","v":0}]
["angeordnete Vermögensänderung lt. FO",null,null,null,null,{"$f":"Deckblatt!C7","v":0},null,{"$f":"G27-F27","v":0},{"$f":"IF(F26<Mindestreserve!D18,Mindestreserve!D18-F26,0)","v":6542.71999999997},null,{"$f":"I27-J27","v":6542.71999999997}]
["Zinsen auf Vermögen",null,null,null,null,0,0,{"$f":"G28-F28","v":0},0,0,{"$f":"I28-J28","v":0}]
["geplante Veränderung des Vermögens Ansparen/Entnahme",null,null,null,null,{"$f":"Deckblatt!C6*(-1)","v":-328.720000000001},0,{"$f":"G29-F29","v":328.720000000001},{"$f":"Deckblatt!F6","v":0},0,{"$f":"I29-J29","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F26:F29)","v":135888.56},{"$f":"SUM(G26:G29)","v":0},{"$f":"SUM(H26:H29)","v":-135888.56},{"$f":"SUM(I26:I29)","v":6542.71999999997},{"$f":"SUM(J26:J29)","v":0},{"$f":"SUM(K26:K29)","v":6542.71999999997}]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F24,F19,F14,F6)","v":184600},{"$f":"SUM(G24,G19,G14,G6)","v":26710.67},{"$f":"SUM(H24,H19,H14,H6)","v":-157889.33},{"$f":"SUM(I24,I19,I14,I6)","v":8450},{"$f":"SUM(J24,J19,J14,J6)","v":0},{"$f":"SUM(K24,K19,K14,K6)","v":8450},{"$f":"SUM(L24,L19,L14,L6)","v":0},{"$f":"SUM(M24,M19,M14,M6)","v":0},{"$f":"SUM(N24,N19,N14,N6)","v":0},{"$f":"SUM(O24,O19,O14,O6)","v":1500},{"$f":"(G31-J31+M31)-(F31-I31)","v":-149439.33}]

{"sheet":"Finanzen","index":9,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,2,1,2],[0,3,0,5],[0,6,0,8],[6,0,6,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,0,{"$f":"G3-H3","v":600}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1000,0,{"$f":"G4-H4","v":1000}]
["Nebenkosten Zahlungsverkehr",null,null,0,0,0,1000,0,{"$f":"G5-H5","v":1000}]
["CoCo-Pauschale",null,null,0,0,{"$f":"E6-D6","v":0},250,0,{"$f":"G6-H6","v":250}]
["Gesamtsumme:",null,null,{"$f":"SUM(D3:D6)","v":0},{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":0},{"$f":"SUM(G3:G6)","v":2850},{"$f":"SUM(H3:H6)","v":0},{"$f":"SUM(I3:I6)","v":2850}]

{"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],[6,8,6,11],[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"]
["Aktionstage gegen Sexismus und Homophobie",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}]
["Aktionen, Festivals und Demonstrationen",null,0,0,{"$f":"D4-C4","v":0},250,0,{"$f":"F4-G4","v":250},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":250},{"$f":"(D4-G4+J4)-(C4-F4)","v":250}]
["Förderverein HTW Dresden - Mitgliedsbeitrag",1,0,0,{"$f":"D5-C5","v":0},150,0,{"$f":"F5-G5","v":150},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":150},{"$f":"(D5-G5+J5)-(C5-F5)","v":150}]
["politische Bildung / Umweltbildung",null,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},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},{"$f":"SUM(D3:D7)","v":0},{"$f":"SUM(E3:E7)","v":0},{"$f":"SUM(F3:F7)","v":1000},{"$f":"SUM(G3:G7)","v":0},{"$f":"SUM(H3:H7)","v":1000},{"$f":"SUM(I3:I7)","v":100},{"$f":"SUM(J3:J7)","v":0},{"$f":"SUM(K3:K7)","v":100},{"$f":"SUM(L3:L7)","v":1000},{"$f":"(D8-G8+J8)-(C8-F8)","v":1000}]

{"sheet":"Internationales","index":11,"n_rows":5,"n_cols":13,"rows_kept":5,"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],[3,8,3,11],[4,0,4,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"]
["Internationaler Tag",1,0,0,{"$f":"D3-C3","v":0},50,0,{"$f":"F3-G3","v":50},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":50},{"$f":"(D3-G3+J3)-(C3-F3)","v":50}]
["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},{"$f":"SUM(D3:D4)","v":0},{"$f":"SUM(E3:E4)","v":0},{"$f":"SUM(F3:F4)","v":300},{"$f":"SUM(G3:G4)","v":0},{"$f":"SUM(H3:H4)","v":300},{"$f":"SUM(I3:I4)","v":50},{"$f":"SUM(J3:J4)","v":0},{"$f":"SUM(K3:K4)","v":50},{"$f":"SUM(L3:L4)","v":50},{"$f":"(D5-G5+J5)-(C5-F5)","v":300}]

{"sheet":"Kultur","index":12,"n_rows":15,"n_cols":13,"rows_kept":15,"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],[13,8,13,11],[14,0,14,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"]
["Kino in der Hochschule",null,800,0,{"$f":"D3-C3","v":-800},800,0,{"$f":"F3-G3","v":800},180,{"$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":180},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":800},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Erstifahrten",null,3500,0,{"$f":"D4-C4","v":-3500},4000,0,{"$f":"F4-G4","v":4000},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":4000},{"$f":"(D4-G4+J4)-(C4-F4)","v":500}]
["Semestereröffnungspartys (SEP)",2,3000,0,{"$f":"D5-C5","v":-3000},3000,0,{"$f":"F5-G5","v":3000},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":3000},{"$f":"(D5-G5+J5)-(C5-F5)","v":0}]
["Semesterabsch(l)ussfeier (SAF)",2,2600,0,{"$f":"D6-C6","v":-2600},2600,0,{"$f":"F6-G6","v":2600},1120,{"$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":1120},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":2600},{"$f":"(D6-G6+J6)-(C6-F6)","v":0}]
["Bergfeste",null,1000,0,{"$f":"D7-C7","v":-1000},1000,0,{"$f":"F7-G7","v":1000},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":1000},{"$f":"(D7-G7+J7)-(C7-F7)","v":0}]
["Weihnachtsfeiern",null,3000,0,{"$f":"D8-C8","v":-3000},3500,0,{"$f":"F8-G8","v":3500},3020,{"$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":3020},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":3500},{"$f":"(D8-G8+J8)-(C8-F8)","v":500}]
["Fakultätsfeste & Sommerfeste",null,3500,0,{"$f":"D9-C9","v":-3500},4000,0,{"$f":"F9-G9","v":4000},2240,{"$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":2240},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":4000},{"$f":"(D9-G9+J9)-(C9-F9)","v":500}]
["LAN-Partys",null,750,0,{"$f":"D10-C10","v":-750},750,0,{"$f":"F10-G10","v":750},540,{"$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":540},{"$f":"IF(H10>0,ROUNDDOWN(H10,-1),0)","v":750},{"$f":"(D10-G10+J10)-(C10-F10)","v":0}]
["Musikveranstaltung",1,500,0,{"$f":"D11-C11","v":-500},500,0,{"$f":"F11-G11","v":500},500,{"$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":500},{"$f":"IF(H11>0,ROUNDDOWN(H11,-1),0)","v":500},{"$f":"(D11-G11+J11)-(C11-F11)","v":0}]
["Spieleabende",2,0,0,{"$f":"D12-C12","v":0},100,0,{"$f":"F12-G12","v":100},100,{"$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":100},{"$f":"IF(H12>0,ROUNDDOWN(H12,-1),0)","v":100},{"$f":"(D12-G12+J12)-(C12-F12)","v":100}]
["Vernetzung von Student:innen der Hochschule",null,1100,0,{"$f":"D13-C13","v":-1100},1100,0,{"$f":"F13-G13","v":1100},1100,{"$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":1100},{"$f":"IF(H13>0,ROUNDDOWN(H13,-1),0)","v":1100},{"$f":"(D13-G13+J13)-(C13-F13)","v":0}]
["CoCo-Pauschale",null,0,0,{"$f":"D14-C14","v":0},250,0,{"$f":"F14-G14","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C14)","v":19750},{"$f":"SUM(D3:D14)","v":0},{"$f":"SUM(E3:E14)","v":-19750},{"$f":"SUM(F3:F14)","v":21600},{"$f":"SUM(G3:G14)","v":0},{"$f":"SUM(H3:H14)","v":21600},{"$f":"SUM(I3:I14)","v":8800},{"$f":"SUM(J3:J14)","v":0},{"$f":"SUM(K3:K14)","v":8800},{"$f":"SUM(L3:L14)","v":21350},{"$f":"(D15-G15+J15)-(C15-F15)","v":1850}]

{"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"]
["Hochschulveranstaltungen (Dies Academicus, Tag der offenen Tür, etc.)",null,0,0,{"$f":"D3-C3","v":0},500,0,{"$f":"F3-G3","v":500},500,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),MAKRO1(),ROUNDDOWN(I3-J3,-1))","v":500},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Werbemittel (Kulis, Beutel, Plakate, T-Shirts etc.)",null,0,0,{"$f":"D4-C4","v":0},4600,0,{"$f":"F4-G4","v":4600},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":4600},{"$f":"(D4-G4+J4)-(C4-F4)","v":4600}]
["Werbemittel Änderung Logo 2023",null,0,0,{"$f":"D5-C5","v":0},2000,0,{"$f":"F5-G5","v":2000}]
["Veranstaltungen zur Vorstellung",null,0,0,{"$f":"D6-C6","v":0},250,0,{"$f":"F6-G6","v":250},220,{"$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":220},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":250},{"$f":"(D6-G6+J6)-(C6-F6)","v":250}]
["Merchandise u.ä.",null,500,0,{"$f":"D7-C7","v":-500},500,0,{"$f":"F7-G7","v":500},500,{"$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":500},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":500},{"$f":"(D7-G7+J7)-(C7-F7)","v":0}]
["CoCo-Pauschale",null,0,0,{"$f":"D8-C8","v":0},250,0,{"$f":"F8-G8","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C8)","v":500},{"$f":"SUM(D3:D8)","v":0},{"$f":"SUM(E3:E8)","v":-500},{"$f":"SUM(F3:F8)","v":8100},{"$f":"SUM(G3:G8)","v":0},{"$f":"SUM(H3:H8)","v":8100},{"$f":"SUM(I3:I8)","v":1220},{"$f":"SUM(J3:J8)","v":0},{"$f":"SUM(K3:K8)","v":1220},{"$f":"SUM(L3:L8)","v":5850},{"$f":"(D9-G9+J9)-(C9-F9)","v":7600}]

{"sheet":"Qualitätsmanagement","index":14,"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 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},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}]
["Veranstaltung Erstsemestereinführung (ESE)",1,0,0,{"$f":"D4-C4","v":0},500,0,{"$f":"F4-G4","v":500},310,{"$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":310},{"$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},500,0,{"$f":"F5-G5","v":500},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":500},{"$f":"(D5-G5+J5)-(C5-F5)","v":500}]
["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":1500},{"$f":"SUM(G3:G6)","v":0},{"$f":"SUM(H3:H6)","v":1500},{"$f":"SUM(I3:I6)","v":310},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":310},{"$f":"SUM(L3:L6)","v":1250},{"$f":"(D7-G7+J7)-(C7-F7)","v":1500}]

{"sheet":"Soziales","index":15,"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 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},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}]
["Projekt Studieren mit Beeinträchtigung",null,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}]
["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}]
["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":600},{"$f":"SUM(G3:G6)","v":0},{"$f":"SUM(H3:H6)","v":600},{"$f":"SUM(I3:I6)","v":350},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":350},{"$f":"SUM(L3:L6)","v":350},{"$f":"(D7-G7+J7)-(C7-F7)","v":600}]

{"sheet":"Sport","index":16,"n_rows":12,"n_cols":13,"rows_kept":12,"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,8,10,11],[11,0,11,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},410,{"$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":410},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Startgebühren",null,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}]
["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},500,{"$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":500},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":500},{"$f":"(D7-G7+J7)-(C7-F7)","v":500}]
["Ausflüge",1,200,0,{"$f":"D8-C8","v":-200},300,0,{"$f":"F8-G8","v":300},300,{"$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":300},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":300},{"$f":"(D8-G8+J8)-(C8-F8)","v":100}]
["Hochschulsportfest",1,0,0,{"$f":"D9-C9","v":0},0,0,{"$f":"F9-G9","v":0},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":0},{"$f":"(D9-G9+J9)-(C9-F9)","v":0}]
["Sportevents (Eislaufen, Lasertag, Trampolinpark)",null,2000,0,{"$f":"D10-C10","v":-2000},2500,0,{"$f":"F10-G10","v":2500},2500,{"$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":2500},{"$f":"IF(H10>0,ROUNDDOWN(H10,-1),0)","v":2500},{"$f":"(D10-G10+J10)-(C10-F10)","v":500}]
["CoCo-Pauschale",null,0,0,{"$f":"D11-C11","v":0},250,0,{"$f":"F11-G11","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C11)","v":2200},{"$f":"SUM(D3:D11)","v":0},{"$f":"SUM(E3:E11)","v":-2200},{"$f":"SUM(F3:F11)","v":4250},{"$f":"SUM(G3:G11)","v":0},{"$f":"SUM(H3:H11)","v":4250},{"$f":"SUM(I3:I11)","v":3910},{"$f":"SUM(J3:J11)","v":0},{"$f":"SUM(K3:K11)","v":3910},{"$f":"SUM(L3:L11)","v":4000},{"$f":"(D12-G12+J12)-(C12-F12)","v":2050}]

{"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}]
["Veranstaltung lange Nacht des Studierens",1,0,0,{"$f":"D4-C4","v":0},500,0,{"$f":"F4-G4","v":500},500,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),MAKRO1(),ROUNDDOWN(I4-J4,-1))","v":500},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":500},{"$f":"(D4-G4+J4)-(C4-F4)","v":500}]
["Rechtskosten Prüfungsangelegenheiten",null,0,0,{"$f":"D5-C5","v":0},750,0,{"$f":"F5-G5","v":750},750,{"$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":750},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":750},{"$f":"(D5-G5+J5)-(C5-F5)","v":750}]
["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":1500},{"$f":"SUM(G3:G6)","v":0},{"$f":"SUM(H3:H6)","v":1500},{"$f":"SUM(I3:I6)","v":1250},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":1250},{"$f":"SUM(L3:L6)","v":1250},{"$f":"(D7-G7+J7)-(C7-F7)","v":1500}]

{"sheet":"Verwaltung@","index":18,"n_rows":18,"n_cols":13,"rows_kept":18,"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],[16,8,16,11],[17,0,17,1]]}
["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,0,{"$f":"F3-G3","v":180},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":180},{"$f":"(D3-G3+J3)-(C3-F3)","v":180}]
["Domains",null,0,0,{"$f":"D4-C4","v":0},80,0,{"$f":"F4-G4","v":80},20,{"$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":20},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":80},{"$f":"(D4-G4+J4)-(C4-F4)","v":80}]
["Beitrag Gruppenausweis für Jugendherbergen",1,0,0,{"$f":"D5-C5","v":0},26,0,{"$f":"F5-G5","v":26},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":20},{"$f":"(D5-G5+J5)-(C5-F5)","v":26}]
["Versicherung Beachvolleyballplätze",null,0,0,0,500,0,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":500}]
["Dienste für elektronische Datenverarbeitung ",null,0,0,{"$f":"D7-C7","v":0},15000,0,{"$f":"F7-G7","v":15000},5000,{"$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":5000},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":15000},{"$f":"(D7-G7+J7)-(C7-F7)","v":15000}]
["Anschaffungen zwecks Umstrukturierung StuRa",null,0,0,{"$f":"D8-C8","v":0},500,0,{"$f":"F8-G8","v":500},580,{"$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":580},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":500},{"$f":"(D8-G8+J8)-(C8-F8)","v":500}]
["andauernde Betreuung Server durch Externe",null,0,0,{"$f":"D9-C9","v":0},2400,0,{"$f":"F9-G9","v":2400},2400,{"$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":2400},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":2400},{"$f":"(D9-G9+J9)-(C9-F9)","v":2400}]
["Beiträge/Gebühren",null,0,0,{"$f":"D10-C10","v":0},0,0,{"$f":"F10-G10","v":0},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":0},{"$f":"(D10-G10+J10)-(C10-F10)","v":0}]
["Büromaterial und -ausstattung",null,0,0,{"$f":"D11-C11","v":0},500,0,{"$f":"F11-G11","v":500},30,{"$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":30},{"$f":"IF(H11>0,ROUNDDOWN(H11,-1),0)","v":500},{"$f":"(D11-G11+J11)-(C11-F11)","v":500}]
["Studienmaterial (z.B. Bautabellen, etc.)",null,700,0,{"$f":"D12-C12","v":-700},700,0,{"$f":"F12-G12","v":700},470,{"$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":470},{"$f":"IF(H12>0,ROUNDDOWN(H12,-1),0)","v":700},{"$f":"(D12-G12+J12)-(C12-F12)","v":0}]
["Getränkeautomat",null,1000,0,{"$f":"D13-C13","v":-1000},900,0,{"$f":"F13-G13","v":900},550,{"$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":550},{"$f":"IF(H13>0,ROUNDDOWN(H13,-1),0)","v":900},{"$f":"(D13-G13+J13)-(C13-F13)","v":-100}]
["Projekt \"How to StuRa\" (Dokumentation)",null,0,0,0,0,0,{"$f":"F14-G14","v":0},2000,{"$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":2000},{"$f":"IF(H14>0,ROUNDDOWN(H14,-1),0)","v":0},{"$f":"(D14-G14+J14)-(C14-F14)","v":0}]
["laufende Kosten für Druck, samt Nebenkosten",null,0,0,{"$f":"D15-C15","v":0},400,0,{"$f":"F15-G15","v":400},100,{"$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":100},{"$f":"IF(H15>0,ROUNDDOWN(H15,-1),0)","v":400},{"$f":"(D15-G15+J15)-(C15-F15)","v":400}]
["Laborkittel An- & Verkauf",null,1800,0,{"$f":"D16-C16","v":-1800},1800,0,{"$f":"F16-G16","v":1800},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":1800},{"$f":"(D16-G16+J16)-(C16-F16)","v":0}]
["CoCo-Pauschale",null,0,0,{"$f":"D17-C17","v":0},250,0,{"$f":"F17-G17","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C17)","v":3500},{"$f":"SUM(D3:D17)","v":0},{"$f":"SUM(E3:E17)","v":-3500},{"$f":"SUM(F3:F17)","v":23236},{"$f":"SUM(G3:G17)","v":0},{"$f":"SUM(H3:H17)","v":22736},{"$f":"SUM(I3:I17)","v":11150},{"$f":"SUM(J3:J17)","v":0},{"$f":"SUM(K3:K17)","v":11150},{"$f":"SUM(L3:L17)","v":22480},{"$f":"(D18-G18+J18)-(C18-F18)","v":19736}]

{"sheet":"Personal","index":19,"n_rows":18,"n_cols":13,"rows_kept":18,"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],[2,0,2,12],[12,0,12,12],[16,8,16,11],[17,0,17,1]]}
["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},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":1800},{"$f":"(D4-G4+J4)-(C4-F4)","v":1800}]
["Sozialberatung (BaföG, Jobberatung) / Soziales",null,0,0,{"$f":"D5-C5","v":0},50,0,{"$f":"F5-G5","v":50},50,{"$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":50},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":50},{"$f":"(D5-G5+J5)-(C5-F5)","v":50}]
["studentische und akademische Selbstverwaltung (Studienprüfungsordnung) / Studium",null,0,0,{"$f":"D6-C6","v":0},100,0,{"$f":"F6-G6","v":100},100,{"$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":100},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":100},{"$f":"(D6-G6+J6)-(C6-F6)","v":100}]
["Prüfungsangelegenheiten / Studium",null,0,0,{"$f":"D7-C7","v":0},50,0,{"$f":"F7-G7","v":50},50,{"$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":50},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":50},{"$f":"(D7-G7+J7)-(C7-F7)","v":50}]
["pol. Bildung, Antidiskriminierung, Gleichstellung / Hochschulpolitik",null,0,0,{"$f":"D8-C8","v":0},100,0,{"$f":"F8-G8","v":100},100,{"$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":100},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":100},{"$f":"(D8-G8+J8)-(C8-F8)","v":100}]
["Konstituierungsseminar (KoSe) / \nStuRa (Präsidium)",1,0,0,{"$f":"D9-C9","v":0},500,0,{"$f":"F9-G9","v":500},2410,{"$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":2410},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":500},{"$f":"(D9-G9+J9)-(C9-F9)","v":500}]
["Lern- und Informationsseminar (LuISe) / \nPersonal",1,0,0,{"$f":"D10-C10","v":0},500,0,{"$f":"F10-G10","v":500},500,{"$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":500},{"$f":"IF(H10>0,ROUNDDOWN(H10,-1),0)","v":500},{"$f":"(D10-G10+J10)-(C10-F10)","v":500}]
["Clearance and Rapprochement (CLARA) / \nStuRa (Kanzlei)",1,0,0,{"$f":"D11-C11","v":0},150,0,{"$f":"F11-G11","v":150},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":150},{"$f":"(D11-G11+J11)-(C11-F11)","v":150}]
["Veranstaltung zur fachlichen Weiterbildung / \nStudium",null,0,0,{"$f":"D12-C12","v":0},250,0,{"$f":"F12-G12","v":250},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":250},{"$f":"(D12-G12+J12)-(C12-F12)","v":250}]
["Allgemeines"]
["Informationen zu Kandidierenden",null,0,0,{"$f":"D14-C14","v":0},100,0,{"$f":"F14-G14","v":100},100,{"$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":100},{"$f":"IF(H14>0,ROUNDDOWN(H14,-1),0)","v":100},{"$f":"(D14-G14+J14)-(C14-F14)","v":100}]
["Klausur-Tagungen",2,0,0,{"$f":"D15-C15","v":0},500,0,{"$f":"F15-G15","v":500},0,{"$f":"IF(H15<0,IF(I15>0,IF((H15*(-1))>I15,I15,H15*(-1)),0),0)","v":0},{"$f":"IF(OR(J15>I15,H15+I15<0),MAKRO1(),ROUNDDOWN(I15-J15,-1))","v":0},{"$f":"IF(H15>0,ROUNDDOWN(H15,-1),0)","v":500},{"$f":"(D15-G15+J15)-(C15-F15)","v":500}]
["auswärtige Arbeitstreffen / Arbeitsfahrten",null,0,0,{"$f":"D16-C16","v":0},1500,0,{"$f":"F16-G16","v":1500},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":1500},{"$f":"(D16-G16+J16)-(C16-F16)","v":1500}]
["CoCo-Pauschale",null,0,0,{"$f":"D17-C17","v":0},250,0,{"$f":"F17-G17","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C4:C17)","v":0},{"$f":"SUM(D4:D17)","v":0},{"$f":"SUM(E4:E17)","v":0},{"$f":"SUM(F4:F17)","v":5850},{"$f":"SUM(G4:G17)","v":0},{"$f":"SUM(H4:H17)","v":5850},{"$f":"SUM(I4:I17)","v":3560},{"$f":"SUM(J4:J17)","v":0},{"$f":"SUM(K4:K17)","v":3560},{"$f":"SUM(L4:L17)","v":5600},{"$f":"(D18-G18+J18)-(C18-F18)","v":5850}]