{"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":[[2,1,4,6],[2,0,4,0],[0,0,0,1]]}
["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":[[17,3,17,4],[10,0,11,0],[15,4,15,6],[9,0,9,1],[0,2,0,4],[0,5,0,7],[0,0,1,1],[4,0,4,1],[3,0,3,1],[2,0,2,1],[7,0,7,1],[6,0,6,1],[8,0,8,1]]}
["Haushaltsplan 2022 Studierendenschaft HTW Dresden",null,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J55","v":26100},{"$f":"'Detailblatt I'!K55","v":28},{"$f":"D3-C3","v":-26072},{"$f":"'Detailblatt I'!M55","v":259076},{"$f":"'Detailblatt I'!N55","v":813.19},{"$f":"(F3-G3)","v":258262.81}]
["Beitragseinnahmen der Studierenden",null,{"$f":"'Detailblatt II'!F18","v":201900},{"$f":"'Detailblatt II'!G18","v":129807},{"$f":"D4-C4","v":-72093},{"$f":"'Detailblatt II'!I18","v":0},{"$f":"'Detailblatt II'!J18","v":0},{"$f":"(F4-G4)","v":0}]
["Zinsen",null,{"$f":"'Detailblatt II'!F22","v":0},{"$f":"'Detailblatt II'!G22","v":0},0,{"$f":"'Detailblatt II'!I22","v":0},{"$f":"'Detailblatt II'!J22","v":0},{"$f":"(F5-G5)","v":0}]
["Entnahme (=Einnahme) Ansparen (=Ausgabe)","von Vermögen",{"$f":"IF((Beitragsermittlung!B16)-('Detailblatt II'!F16+'Detailblatt II'!F17)>0,(Beitragsermittlung!B16)-('Detailblatt II'!F16+'Detailblatt II'!F17),0)","v":0},0,0,224,{"$f":"'Detailblatt II'!G23","v":0},{"$f":"(F6-G6)","v":224}]
["angeordnete Vermögensänderung lt. FO",null,{"$f":"Beitragsermittlung!B14","v":0},null,0,{"$f":"'Detailblatt II'!I21","v":0},null,{"$f":"(F7-G7)","v":0}]
["Zurückführung an Studierende (StuRa)",null,31300,{"$f":"C8","v":31300},{"$f":"D8-C8","v":0}]
[]
["Gesamt:",null,{"$f":"SUM(C3:C9)","v":259300},161135,-98165,{"$f":"SUM(F3:F9)","v":259300},813.19,258486.81]
["Berechnung des Semesterbeitrag:"]
[null,"Planausgaben:",{"$f":"F10","v":259300},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":26100}]
["-","Zurückführung:",{"$f":"C8+C9","v":31300}]
["-","Vermögensänderung",{"$f":"C7","v":0}]
["=","Gesamt:",{"$f":"C12-C13-C14-C15-F6","v":201676}]
["/","Beitragszahlungen/Jahr:",{"$f":"'Detailblatt II'!D16+('Detailblatt II'!D17/6*4)","v":7533.3333333333339}]
["=","Stud./Semester:",{"$f":"IF((C16-'Detailblatt II'!F15)/Deckblatt!C17<0,0,(C16-'Detailblatt II'!F15)/Deckblatt!C17)","v":22.974690265486725},"Anzusetzender Semesterbeitrag:",null,{"$f":"ROUND((C18*2),0)/2","v":23}]

{"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":227776}]
["verfügbare finanzielle Mittel",{"$f":"'fortgeschr. Mittel+Konto'!D9","v":117160.43000000002}]
["Obergrenze finanzielle Mittel",{"$f":"IF(B3<B4,B3,B4)","v":117160.43000000002}]
[]
["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":101950}]
["(Verfügbare finanzielle Mittel nach Vermögensenkung)",{"$f":"B4-B7","v":117160.43000000002}]
["Untergrenze für verfügbare finanzielle Mittel durch Bemessung an der Mindestreserve wird erreicht",{"$f":"IF(B5<B8,B8,B5)","v":117160.43000000002}]
["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'!F15)),Deckblatt!F10-Deckblatt!F6-(Deckblatt!C3+Deckblatt!C5+Deckblatt!C8+Deckblatt!C9+'Detailblatt II'!F15),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'!F15)","v":173076}]

{"sheet":"fortgeschr. Mittel+Konto","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,6,6,7],[24,6,24,7],[23,6,23,7],[4,5,5,5],[15,6,15,7],[10,6,10,7],[9,6,9,7],[8,6,8,7],[7,6,7,7],[14,6,14,7],[13,6,13,7],[12,6,12,7],[11,6,11,7],[4,8,5,8],[4,6,5,7],[0,3,1,3],[0,0,1,1],[0,2,1,2],[1,6,1,7],[2,8,3,8],[2,5,3,5],[2,6,3,7],[16,8,17,8],[16,6,17,7],[16,5,17,5],[21,6,21,7],[20,6,20,7],[18,8,19,8],[18,6,19,7],[18,5,19,5]]}
["Fortgeschriebene finanzielle Mittel + Bankkontostand",null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2022}]
[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":"1994.99+283079.76+60000+1676.21","v":346750.96}]
["-","abzgl. voraussichtliche Ausgaben",null,{"$f":"I25*(-1)","v":-111170.53},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":-58520}]
["-","Zurückführung an Studierende gesamt",null,{"$f":"SUM(Deckblatt!C8:C9)*-1","v":-31300},null,"3.","Schulungen/Konferenzen (KoSe)",null,0]
["-","Beitragseinnahmen anteilig WS 21/22 für 2022",null,{"$f":"'Detailblatt II'!F15*-1","v":-28600},null,"4.","voraussichtliche AE",null,0]
["=","verfügbare finanzielle Mittel",null,{"$f":"D4+D5+D6+D7+D8","v":117160.43000000002},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,83853]
[]
[null,null,null,null,null,"15.","Konto 1704",null,7725.52]
[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.009999999995}]
[null,null,null,null,null,"=","Gesamtsumme:",null,{"$f":"SUM(I3:I24)","v":111170.53}]

{"sheet":"Mindestreserve","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,2],[12,0,12,4],[16,0,16,2],[15,0,15,2],[17,3,17,4],[16,3,16,4],[15,3,15,4],[14,3,14,4],[13,3,13,4],[14,0,14,2],[13,0,13,2],[11,3,11,4],[6,0,6,2],[7,0,7,2],[8,0,8,4],[11,0,11,2],[10,0,10,2],[9,0,9,2],[10,3,10,4],[9,3,9,4],[6,3,6,4],[7,3,7,4],[0,0,1,2],[0,3,1,3],[0,4,1,4],[0,5,0,9],[2,0,2,2],[2,3,2,4],[1,6,2,9],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[3,0,3,4]]}
["Mindestreserve",null,null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2022},"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":150000}]
["Korrektur für \"SHK\"-Stellen",null,null,-50000]
["…aktuell ohne Belegung…"]
["…aktuell ohne Belegung…",null,null,"------"]
["Referat Finanzen"]
["Kontoführungsgebühren",null,null,{"$f":"Finanzen!G3","v":500}]
["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":50}]
["laufende Kosten (Druck, Wartung)",null,null,{"$f":"'Studentische Verwaltung'!F16","v":400}]
["…aktuell ohne Belegung…",null,null,"------"]
["…aktuell ohne Belegung…",null,null,"------"]
["Gesamt:",null,null,{"$f":"SUM(D5:E17)","v":101950}]

{"sheet":"Detailblatt I","index":5,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":false,"merged":[[44,12,44,13],[44,9,45,11],[45,0,45,4],[46,9,46,11],[46,0,46,7],[45,7,45,8],[45,5,45,6],[44,0,44,4],[40,1,40,8],[54,0,54,8],[47,0,47,8],[53,0,53,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[48,0,48,18],[53,15,53,16],[49,9,52,11],[44,15,45,18],[43,0,43,18],[39,15,42,18],[39,9,41,11],[45,12,45,14],[0,15,1,15],[0,17,1,17],[5,1,11,1],[15,1,15,8],[13,1,13,8],[12,1,12,8],[11,2,11,8],[5,2,5,8],[7,12,11,12],[10,2,10,8],[7,2,7,8],[6,2,6,8],[14,1,14,8],[37,0,37,8],[42,0,42,8],[4,12,4,14],[0,9,0,11],[0,12,0,14],[41,1,41,8],[19,1,19,8],[18,1,18,8],[17,1,17,8],[24,1,24,8],[16,1,16,8],[25,1,25,8],[20,1,20,8],[22,0,22,8],[21,1,21,8],[39,1,39,8],[27,1,27,8],[26,1,26,8],[36,1,36,8],[35,1,35,8],[33,1,33,8],[32,1,32,8],[31,1,31,8],[34,1,34,8],[38,0,38,18],[9,2,9,8],[8,2,8,8],[0,18,1,18],[2,0,2,18],[3,0,3,18],[23,0,23,18],[0,16,1,16],[6,14,11,14],[0,5,1,8],[0,4,1,4],[0,0,1,3],[4,1,4,8],[30,1,30,8],[29,1,29,8],[28,1,28,8]]}
["Detailblatt I",null,null,null,"Jahr -",2022,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,0,{"$f":"K6","v":0}]
[4120,null,"Gehälter",null,null,null,null,null,null,null,null,null,150000,0,{"$f":"M7-SUM(N7:N12)+L6","v":149512.07}]
[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,487.93]
[4138,null,"Beitrag BG",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,20000,0,{"$f":"M13-N13","v":20000}]
[4640,"Kaffee & Verpflegung",null,null,null,null,null,null,null,null,null,null,1200,0,1200]
[4670,"Allgemeine Reisekosten (die keiner Veranstaltung zugeordnet sind)",null,null,null,null,null,null,null,null,null,null,500,0,500]
[4909,"Vorstand der Geschäftsführung",null,null,null,null,null,null,null,null,null,null,0,0,0]
[4930,"Büro- und Verbrauchsmaterialien",null,null,null,null,null,null,null,null,null,null,100,0,100,40,{"$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":40},{"$f":"IF(O17>0,ROUNDDOWN(O17,-1),0)","v":100}]
[4943,"Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,1000,0,1000,340,{"$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":340},{"$f":"IF(O18>0,ROUNDDOWN(O18,-1),0)","v":1000}]
[4944,"Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,250,0,250,250,0,{"$f":"IF(OR(Q19>P19,O19+P19<0),makro1(),ROUNDDOWN(P19-Q19,-1))","v":250},{"$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},2500,{"$f":"Konferenzen!I6","v":500},{"$f":"Konferenzen!J6","v":0},{"$f":"Konferenzen!K6","v":500},{"$f":"Konferenzen!L6","v":500}]
[4950,"Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,9000,0,9000,6000,{"$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":6000},{"$f":"IF(O21>0,ROUNDDOWN(O21,-1),0)","v":9000}]
[4989,"Ersatz- und Neuanschaffung",null,null,null,null,null,null,null,null,null,null,3000,0,3000,1590,0,{"$f":"IF(OR(Q22>P22,O22+P22<0),makro1(),ROUNDDOWN(P22-Q22,-1))","v":1590},{"$f":"IF(O22>0,ROUNDDOWN(O22,-1),0)","v":3000}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J22)","v":2000},0,-2000,187550,487.93,187062.07,{"$f":"SUM(P17:P22)","v":8720},{"$f":"SUM(Q17:Q22)","v":0},{"$f":"SUM(R17:R22)","v":8720},{"$f":"SUM(S17:S22)","v":13850}]
["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":1750},{"$f":"Finanzen!H6","v":325.26},{"$f":"M25-N25","v":1424.74}]
[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":450},{"$f":"Hochschulpolitik!G8","v":0},450,{"$f":"Hochschulpolitik!I8","v":700},{"$f":"Hochschulpolitik!J8","v":0},{"$f":"Hochschulpolitik!K8","v":700},{"$f":"Hochschulpolitik!L8","v":450}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C6","v":0},{"$f":"Internationales!D6","v":0},0,{"$f":"Internationales!F6","v":350},{"$f":"Internationales!G6","v":0},350,{"$f":"Internationales!I6","v":50},{"$f":"Internationales!J6","v":0},{"$f":"Internationales!K6","v":50},{"$f":"Internationales!L6","v":100}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C14","v":17400},{"$f":"Kultur!D14","v":0},-17400,{"$f":"Kultur!F14","v":19550},{"$f":"Kultur!G14","v":0},19550,{"$f":"Kultur!I14","v":10160},{"$f":"Kultur!J14","v":0},{"$f":"Kultur!K14","v":10160},{"$f":"Kultur!L14","v":19300}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C9","v":500},{"$f":"Öffentlichkeitsarbeit!D9","v":28},-472,{"$f":"Öffentlichkeitsarbeit!F9","v":5800},{"$f":"Öffentlichkeitsarbeit!G9","v":0},5800,{"$f":"Öffentlichkeitsarbeit!I9","v":2580},{"$f":"Öffentlichkeitsarbeit!J9","v":0},{"$f":"Öffentlichkeitsarbeit!K9","v":2580},{"$f":"Öffentlichkeitsarbeit!L9","v":5550}]
[4965,"Qualitätsmanagement",null,null,null,null,null,null,null,{"$f":"Qualitätsmanagement!C6","v":0},{"$f":"Qualitätsmanagement!D6","v":0},0,{"$f":"Qualitätsmanagement!F6","v":750},{"$f":"Qualitätsmanagement!G6","v":0},750,{"$f":"Qualitätsmanagement!I6","v":730},{"$f":"Qualitätsmanagement!J6","v":0},{"$f":"Qualitätsmanagement!K6","v":730},{"$f":"Qualitätsmanagement!L6","v":500}]
[4966,"Soziales",null,null,null,null,null,null,null,{"$f":"Soziales!C7","v":0},{"$f":"Soziales!D7","v":0},0,{"$f":"Soziales!F7","v":600},{"$f":"Soziales!G7","v":0},600,{"$f":"Soziales!I7","v":550},{"$f":"Soziales!J7","v":0},{"$f":"Soziales!K7","v":550},{"$f":"Soziales!L7","v":350}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C12","v":2200},{"$f":"Sport!D12","v":0},-2200,{"$f":"Sport!F12","v":4250},{"$f":"Sport!G12","v":0},4250,{"$f":"Sport!I12","v":700},{"$f":"Sport!J12","v":0},{"$f":"Sport!K12","v":700},{"$f":"Sport!L12","v":3200}]
[4968,"Studium",null,null,null,null,null,null,null,{"$f":"Studium!C8","v":0},{"$f":"Studium!D8","v":0},0,{"$f":"Studium!F8","v":1500},{"$f":"Studium!G8","v":0},1500,{"$f":"Studium!I8","v":0},{"$f":"Studium!J8","v":0},{"$f":"Studium!K8","v":0},{"$f":"Studium!L8","v":1250}]
[4969,"Studentische Selbstverwaltung & Organisation",null,null,null,null,null,null,null,{"$f":"'Studentische Verwaltung'!C17","v":4000},{"$f":"'Studentische Verwaltung'!D17","v":0},-4000,{"$f":"'Studentische Verwaltung'!F17","v":15226},{"$f":"'Studentische Verwaltung'!G17","v":0},15226,{"$f":"'Studentische Verwaltung'!I17","v":28150},{"$f":"'Studentische Verwaltung'!J17","v":0},{"$f":"'Studentische Verwaltung'!K17","v":28150},{"$f":"'Studentische Verwaltung'!L17","v":15220}]
[4946,"Personal",null,null,null,null,null,null,null,{"$f":"Personal!C21","v":0},{"$f":"'Studentische Verwaltung'!D18","v":0},{"$f":"K35-J35","v":0},{"$f":"Personal!F21","v":5200},{"$f":"'Studentische Verwaltung'!G18","v":0},5200,{"$f":"Personal!I21","v":4310},{"$f":"'Studentische Verwaltung'!J18","v":0},{"$f":"Personal!K21","v":4310},{"$f":"Personal!L21","v":4950}]
["----","Ausschüsse des Studentinnen- und Studentenrates",null,null,null,null,null,null,null,0,0,0,0,0,0]
["----","weitere Vertretungen",null,null,null,null,null,null,null,0,0,0,0,0,0]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J25:J37)","v":24100},{"$f":"SUM(K25:K37)","v":28},{"$f":"SUM(L25:L37)","v":-24072},{"$f":"SUM(M25:M37)","v":55426},{"$f":"SUM(N25:N37)","v":325.26},55100.74,{"$f":"SUM(P26:P35)","v":47930},{"$f":"SUM(Q26:Q35)","v":0},{"$f":"SUM(R26:R35)","v":47930},{"$f":"SUM(S26:S35)","v":50870}]
["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,0,{"$f":"M42-N42","v":5000}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M40:M42)","v":5000},{"$f":"SUM(N40:N42)","v":0},{"$f":"SUM(O40:O42)","v":5000}]
[]
["Anzahl der Studierenden im:",null,null,null,null,"WiSe","22/23","SoSe",2022]
["gesamt:",null,null,null,null,{"$f":"'Detailblatt II'!D17","v":4700},null,{"$f":"'Detailblatt II'!D16","v":4400}]
["#4942 Absicherung Teilnahme BuFaTas lt. Finanzordnung:",null,null,null,null,null,null,null,0.5,null,null,null,{"$f":"ROUND(($F$46+$H$46)*$I$47,-2)","v":4600},0,{"$f":"M47-N47","v":4600},1870,{"$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":1870},{"$f":"IF(O47>0,ROUNDDOWN(O47,-1),0)","v":4600}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M47:M47)","v":4600},{"$f":"SUM(N47:N47)","v":0},{"$f":"SUM(O47:O47)","v":4600},{"$f":"SUM(P47)","v":1870},{"$f":"SUM(Q47)","v":0},{"$f":"SUM(R47:R47)","v":1870},{"$f":"SUM(S47)","v":4600}]
["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":2100},{"$f":"'Detailblatt II'!J6","v":0},{"$f":"M51-N51","v":2100}]
["----","Interessenvertretungen der Studentinnen- und Studentenschaft ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I13","v":4400},{"$f":"'Detailblatt II'!J13","v":0},{"$f":"M52-N52","v":4400}]
["----","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":6500},{"$f":"SUM(N50:N53)","v":0},{"$f":"SUM(O50:O53)","v":6500}]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J48,J43,J38,J23)","v":26100},{"$f":"SUM(K48,K43,K38,K23)","v":28},{"$f":"SUM(L48,L43,L38,L23)","v":-26072},{"$f":"SUM(M54,M48,M43,M38,M23)","v":259076},{"$f":"SUM(N54,N48,N43,N38,N23)","v":813.19},{"$f":"SUM(O54,O48,O43,O38,O23)","v":258262.81},{"$f":"SUM(P23,P38,P48)","v":58520},{"$f":"SUM(Q48,Q38,Q23)","v":0},{"$f":"SUM(R48,R38,R23)","v":58520},{"$f":"SUM(S48,S38,S23)","v":69320}]

{"sheet":"Detailblatt II","index":6,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,4],[23,3,23,4],[17,3,17,4],[12,3,12,4],[3,0,3,3],[4,0,4,3],[5,3,5,4],[14,2,16,2],[21,0,21,3],[22,0,22,3],[7,0,7,3],[10,0,10,3],[11,0,11,3],[20,0,20,4],[19,0,19,4],[8,0,8,3],[9,0,9,3],[0,8,0,10],[0,2,1,3],[0,0,1,0],[0,4,1,4],[0,1,1,1],[0,5,0,7]]}
["Detailblatt II","Jahr -",{"$f":"'Detailblatt I'!F1","v":2022},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},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},{"$f":"650","v":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},2100,0,2100]
["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,0,{"$f":"I10-J10","v":3500}]
["BAS e.V.",null,null,null,1,0,0,{"$f":"G11-F11","v":0},100,0,{"$f":"I11-J11","v":100}]
["weitere (ABS, bpm )",null,null,null,null,0,0,{"$f":"G12-F12","v":0},0,0,{"$f":"I12-J12","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F8:F12)","v":0},0,0,4400,0,4400]
["Beitragseinnahmen"]
["Anteilig WS 21/22",17.5,"x Studierende",4908,1,{"$f":"ROUND((($B$15*$D$15)/6)*2,-2)","v":28600},28630,{"$f":"G15-F15","v":30},0,0,{"$f":"I15-J15","v":0}]
["SoSe 22",23,null,4400,1,{"$f":"ROUND($B$16*$D$16,-2)","v":101200},101177,{"$f":"G16-F16","v":-23},0,0,{"$f":"I16-J16","v":0}]
["Anteilig WS 22/23",23,null,4700,1,{"$f":"ROUND((($B$17*$D$17)/6)*4,-2)","v":72100},0,{"$f":"G17-F17","v":-72100},0,0,{"$f":"I17-J17","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F15:F17)","v":201900},{"$f":"SUM(G15:G17)","v":129807},{"$f":"SUM(H15:H17)","v":-72093},0,0,0]
["Vermögen"]
["Verfügbare finanzielle Mittel",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D9","v":117160.43000000002},null,{"$f":"G20-F20","v":-117160.43000000002},0,0,{"$f":"I20-J20","v":0}]
["angeordnete Vermögensänderung lt. FO",null,null,null,null,{"$f":"Deckblatt!C7","v":0},null,0,{"$f":"IF(F20<Mindestreserve!D18,Mindestreserve!D18-F20,0)","v":0},null,{"$f":"I21-J21","v":0}]
["Zinsen auf Vermögen",null,null,null,null,0,0,0,0,0,{"$f":"I22-J22","v":0}]
["geplante Veränderung des Vermögens Ansparen/Entnahme",null,null,null,null,{"$f":"Deckblatt!C6*(-1)","v":0},0,0,{"$f":"Deckblatt!F6","v":224},0,{"$f":"I23-J23","v":224}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F20:F23)","v":117160.43000000002},0,-117160.43000000002,224,0,224]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F18,F13,F6)","v":201900},129807,-72093,6500,0,6500]

{"sheet":"Konferenzen","index":7,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[4,8,4,11],[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11]]}
["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",0.5,0,0,{"$f":"D4-C4","v":0},0,0,{"$f":"F4-G4","v":0},0,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":0},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,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,750,0,750,500,0,500,500,750]

{"sheet":"Personal","index":8,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,11,16,11],[15,12,16,12],[15,0,16,0],[15,1,16,1],[15,2,15,4],[15,5,15,7],[15,8,16,8],[15,9,16,9],[20,0,20,1],[19,0,19,12],[0,10,1,10],[0,11,1,11],[0,12,1,12],[12,8,12,11],[13,0,13,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[14,0,14,12],[18,0,18,1],[15,10,16,10]]}
["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",null,0,0,{"$f":"D3-C3","v":0},1000,0,{"$f":"F3-G3","v":1000},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":1000},{"$f":"(D3-G3+J3)-(C3-F3)","v":1000}]
["Sozialberatung (BaföG, Jobberatung) / Soziales",null,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}]
["studentische und akademische\nSelbstverwaltung (Studienprüfungsordnung) / Studium",null,0,0,0,100,0,100,100,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":100},100,100]
["Prüfungsangelegenheiten / Studium",null,0,0,0,50,0,50,50,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":50},50,50]
["pol. Bildung, Antidiskriminierung, Gleichstellung / Hochschulpolitik",null,0,0,0,100,0,100,100,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":100},100,100]
["Konstituierungsseminar (KoSe) / StuRa (Präsidium)",1,0,0,0,2500,0,2500,160,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":160},2500,2500]
["Lern- und Informationsseminar (LuISe) / Personal",1,0,0,0,500,0,500,750,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":750},500,500]
["Clearance and Rapprochement (CLARA) / StuRa (Kanzlei)",1,0,0,0,50,0,50,0,0,{"$f":"IF(OR(J10>I10,H10+I10<0),makro1(),ROUNDDOWN(I10-J10,-1))","v":0},50,50]
["Veranstaltung zur fachlichen Weiterbildung / Studium",null,0,0,{"$f":"D11-C11","v":0},250,0,{"$f":"F11-G11","v":250},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":250},{"$f":"(D11-G11+J11)-(C11-F11)","v":250}]
["Rekrutierungsgrillen / Personal",1,0,0,0,250,0,250,0,0,{"$f":"IF(OR(J12>I12,H12+I12<0),makro1(),ROUNDDOWN(I12-J12,-1))","v":0},250,250]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Zwischensumme:",null,{"$f":"SUM(C3:C13)","v":0},0,0,5100,0,5100,4210,0,4210,4850,{"$f":"(D14-G14+J14)-(C14-F14)","v":5100}]
[]
["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",null,0,0,{"$f":"D18-C18","v":0},100,0,{"$f":"F18-G18","v":100},100,{"$f":"IF(H18<0,IF(I18>0,IF((H18*(-1))>I18,I18,H18*(-1)),0),0)","v":0},{"$f":"IF(OR(J18>I18,H18+I18<0),makro1(),ROUNDDOWN(I18-J18,-1))","v":100},{"$f":"IF(H18>0,ROUNDDOWN(H18,-1),0)","v":100},{"$f":"(D18-G18+J18)-(C18-F18)","v":100}]
["Zwischensumme:",null,{"$f":"C18","v":0},0,0,100,0,100,{"$f":"SUM(I18)","v":100},{"$f":"SUM(J18)","v":0},{"$f":"SUM(K18)","v":100},{"$f":"SUM(L18)","v":100},100]
[]
["Gesamtsumme:",null,{"$f":"SUM(C14+C19)","v":0},{"$f":"SUM(D14+D19)","v":0},0,5200,0,5200,{"$f":"SUM(I14+I19)","v":4310},0,4310,4950,{"$f":"(D21-G21+J21)-(C21-F21)","v":5200}]

{"sheet":"Finanzen","index":9,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,2],[0,0,1,0],[0,2,1,2],[0,6,0,8],[0,3,0,5]]}
["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},500,243.15,{"$f":"G3-H3","v":256.85000000000002}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1000,82.11,{"$f":"G4-H4","v":917.89}]
["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},0,0,1750,325.26,1424.74]

{"sheet":"Hochschulpolitik","index":10,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,0,7,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11]]}
["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},0,0,{"$f":"F3-G3","v":0},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":0},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Aktionstage gegen Sexismus und Homophobie",1,0,0,{"$f":"D4-C4","v":0},100,0,{"$f":"F4-G4","v":100},100,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},100,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":100},100,100]
["Förderverein HTW Dresden - Mitgliedsbeitrag",1,0,0,{"$f":"D6-C6","v":0},150,0,{"$f":"F6-G6","v":150},0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},150,150]
["politische Bildung / Umweltbildung",null,0,0,{"$f":"D7-C7","v":0},100,0,{"$f":"F7-G7","v":100},400,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":400},100,100]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},0,0,450,0,450,700,0,700,450,450]

{"sheet":"Internationales","index":11,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,8,1,8],[4,8,4,11],[0,12,1,12],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,5,0,7]]}
["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,0,{"$f":"F3-G3","v":50},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":50},{"$f":"(D3-G3+J3)-(C3-F3)","v":50}]
["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},0,0,350,0,350,50,0,50,100,{"$f":"(D6-G6+J6)-(C6-F6)","v":350}]

{"sheet":"Kultur","index":12,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,12,1,12],[13,0,13,1],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[11,8,11,11]]}
["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,2000,0,{"$f":"D3-C3","v":-2000},2000,0,{"$f":"F3-G3","v":2000},610,{"$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":610},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":2000},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Kino in der Hochschule",null,800,0,-800,800,0,800,200,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":800},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["Musikveranstaltung",1,500,0,-500,500,0,500,450,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":450},500,{"$f":"(D5-G5+J5)-(C5-F5)","v":0}]
["Spieleabende",2,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},100,{"$f":"(D6-G6+J6)-(C6-F6)","v":100}]
["Dies Academicus",1,0,0,0,300,0,300,300,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":300},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":300},300]
["LAN-Partys",null,600,0,-600,600,0,600,0,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":0},600,0]
["Fakultätsfeste & Sommerfeste",null,4500,0,{"$f":"D9-C9","v":-4500},5000,0,{"$f":"F9-G9","v":5000},2500,{"$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":2500},{"$f":"IF(H9>0,ROUNDDOWN(H9,-1),0)","v":5000},{"$f":"(D9-G9+J9)-(C9-F9)","v":500}]
["Erstifahrten",null,3500,0,{"$f":"D10-C10","v":-3500},4000,0,{"$f":"F10-G10","v":4000},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":4000},{"$f":"(D10-G10+J10)-(C10-F10)","v":500}]
["Weihnachtsfeiern",null,3000,0,{"$f":"D11-C11","v":-3000},3500,0,{"$f":"F11-G11","v":3500},3500,{"$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":3500},{"$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}]
["Vernetzung von Studierenden der Hochschule",null,2500,0,-2500,2500,0,2500,2500,0,{"$f":"IF(OR(J13>I13,H13+I13<0),makro1(),ROUNDDOWN(I13-J13,-1))","v":2500},2500,0]
["Gesamtsumme:",null,{"$f":"SUM(C3:C13)","v":17400},0,-17400,19550,0,19550,{"$f":"SUM(I3:I13)","v":10160},0,10160,19300,{"$f":"(D14-G14+J14)-(C14-F14)","v":2150}]

{"sheet":"Öffentlichkeitsarbeit","index":13,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,12,1,12],[8,0,8,1],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7]]}
["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},0,0,{"$f":"F3-G3","v":0},400,{"$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":400},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":0},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Hochschulveranstaltungen",2,0,0,0,200,0,200,200,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 (Kullis, Beutel, Plakate)",null,0,0,0,4600,0,4600,730,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":730},4600,4600]
["Veranstaltung zur Vorstellung",1,0,0,0,250,0,250,250,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":250},250,250]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Merchandise u.ä.",null,500,28,-472,500,0,500,1000,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":1000},500,28]
["Gesamtsumme:",null,{"$f":"SUM(C3:C8)","v":500},28,-472,5800,0,5800,2580,0,2580,5550,5328]

{"sheet":"Qualitätsmanagement","index":14,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,12,1,12],[5,0,5,1],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[4,8,4,11]]}
["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},0,0,{"$f":"F3-G3","v":0},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":0},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Veranstaltung Erstsemestereinführung (ESE)",1,0,0,{"$f":"D4-C4","v":0},500,0,{"$f":"F4-G4","v":500},480,{"$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":480},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":500},{"$f":"(D4-G4+J4)-(C4-F4)","v":500}]
["CoCo-Pauschale",null,0,0,{"$f":"D5-C5","v":0},250,0,{"$f":"F5-G5","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},{"$f":"SUM(D3:D5)","v":0},0,750,0,750,730,0,730,500,500]

{"sheet":"Soziales","index":15,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,12,1,12],[6,0,6,1],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[5,8,5,11]]}
["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},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":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},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":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,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,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C6)","v":0},0,0,600,0,600,550,0,550,350,600]

{"sheet":"Sport","index":16,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,8,10,11],[11,0,11,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11]]}
["Referat Sport","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Turniere, Preise, Beiträge",null,0,0,{"$f":"D3-C3","v":0},500,0,{"$f":"F3-G3","v":500},500,{"$f":"IF(H3<0,IF(I3>0,IF((H3*(-1))>I3,I3,H3*(-1)),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),makro1(),ROUNDDOWN(I3-J3,-1))","v":500},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Startgebühren",1,0,0,0,200,0,200,200,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,0,0,0,0,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},0,0]
["sächsische Beachmeisterschaften",1,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},0,0]
["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},300,0,{"$f":"F8-G8","v":300},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":100}]
["Hochschulsportfest",1,0,0,0,0,0,0,0,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},0]
["Sportevents (Eislaufen, Lasertag, Trampolinpark)",null,2000,0,{"$f":"D10-C10","v":-2000},2500,0,{"$f":"F10-G10","v":2500},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":2500},{"$f":"(D10-G10+J10)-(C10-F10)","v":500}]
["CoCo-Pauschale",null,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C11)","v":2200},0,-2200,4250,0,4250,{"$f":"SUM(I3:I11)","v":700},{"$f":"SUM(J3:J11)","v":0},{"$f":"SUM(K3:K11)","v":700},{"$f":"SUM(L3:L11)","v":3200},{"$f":"(D12-G12+J12)-(C12-F12)","v":2050}]

{"sheet":"Studium","index":17,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,8,6,11],[7,0,7,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11]]}
["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},500,0,{"$f":"F4-G4","v":500},0,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":0},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":500},{"$f":"(D4-G4+J4)-(C4-F4)","v":500}]
["Systemakkreditierung, was nun?",null,0,0,{"$f":"D5-C5","v":0},0,0,{"$f":"F5-G5","v":0},0,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}]
["Rechtskosten Prüfungsangelegenheiten",null,0,0,{"$f":"D6-C6","v":0},750,0,{"$f":"F6-G6","v":750},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":750},{"$f":"(D6-G6+J6)-(C6-F6)","v":750}]
["CoCo-Pauschale",null,0,0,{"$f":"D7-C7","v":0},250,0,{"$f":"F7-G7","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},0,0,1500,0,1500,0,0,0,1250,1500]

{"sheet":"Studentische Verwaltung","index":18,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11]]}
["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},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}]
["Domains",null,0,0,{"$f":"D4-C4","v":0},50,0,{"$f":"F4-G4","v":50},0,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":50},{"$f":"(D4-G4+J4)-(C4-F4)","v":50}]
["Beitrag Gruppenausweis für Jugendherbergen",1,0,0,0,26,0,26,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},20,26]
["Labeldrucker (für die ISIC-Ausweise)",1,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},0,0]
["Vertrieb ISIC",null,0,0,0,0,0,0,0,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":0},0]
["Dienste für elektronische Datenverarbeitung ",null,0,0,{"$f":"D8-C8","v":0},5000,0,{"$f":"F8-G8","v":5000},15000,{"$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":15000},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":5000},{"$f":"(D8-G8+J8)-(C8-F8)","v":5000}]
["Anschaffungen zwecks Umstrukturierung StuRa",null,0,0,0,1000,0,1000,1000,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":1000},1000,1000]
["andauernde Betreuung Server durch Externe",null,0,0,{"$f":"D10-C10","v":0},2400,0,{"$f":"F10-G10","v":2400},2400,{"$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":2400},{"$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,0,0,0,0,0,0,{"$f":"IF(OR(J11>I11,H11+I11<0),makro1(),ROUNDDOWN(I11-J11,-1))","v":0},0,0]
["Büromaterial und -ausstattung",null,0,0,0,500,0,500,410,0,{"$f":"IF(OR(J12>I12,H12+I12<0),makro1(),ROUNDDOWN(I12-J12,-1))","v":410},500,500]
["Studienmaterial (z.B. Bautabellen, Laborkittel, etc.)",null,2500,0,-2500,2500,0,2500,0,0,{"$f":"IF(OR(J13>I13,H13+I13<0),makro1(),ROUNDDOWN(I13-J13,-1))","v":0},2500,0]
["Getränkeautomat",null,1500,0,{"$f":"D14-C14","v":-1500},1300,0,{"$f":"F14-G14","v":1300},0,{"$f":"IF(H14<0,IF(I14>0,IF((H14*(-1))>I14,I14,H14*(-1)),0),0)","v":0},{"$f":"IF(OR(J14>I14,H14+I14<0),makro1(),ROUNDDOWN(I14-J14,-1))","v":0},{"$f":"IF(H14>0,ROUNDDOWN(H14,-1),0)","v":1300},{"$f":"(D14-G14+J14)-(C14-F14)","v":-200}]
["Projekt \"How to StuRa\" (Dokumentation)",null,0,0,0,2000,0,2000,9000,{"$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":9000},{"$f":"IF(H15>0,ROUNDDOWN(H15,-1),0)","v":2000},{"$f":"(D15-G15+J15)-(C15-F15)","v":2000}]
["laufende Kosten für Druck, samt Nebenkosten",null,0,0,0,400,0,400,290,0,{"$f":"IF(OR(J16>I16,H16+I16<0),makro1(),ROUNDDOWN(I16-J16,-1))","v":290},400,400]
["Gesamtsumme:",null,{"$f":"SUM(C3:C16)","v":4000},0,-4000,15226,0,15226,{"$f":"SUM(I3:I16)","v":28150},{"$f":"SUM(J3:J16)","v":0},{"$f":"SUM(K3:K16)","v":28150},{"$f":"SUM(L3:L16)","v":15220},11226]