{"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 2020 Studierendenschaft HTW Dresden",null,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J53","v":60775},{"$f":"'Detailblatt I'!K53","v":1312.48},{"$f":"D3-C3","v":-59462.52},{"$f":"'Detailblatt I'!M53","v":258820},{"$f":"'Detailblatt I'!N53","v":52278.74},{"$f":"(F3-G3)","v":206541.26}]
["Beitragseinnahmen der Studierenden",null,{"$f":"'Detailblatt II'!F16","v":145500},{"$f":"'Detailblatt II'!G16","v":92746},{"$f":"D4-C4","v":-52754},{"$f":"'Detailblatt II'!I16","v":0},{"$f":"'Detailblatt II'!J16","v":0},{"$f":"(F4-G4)","v":0}]
["Zinsen",null,{"$f":"'Detailblatt II'!F20","v":0},{"$f":"'Detailblatt II'!G20","v":0},0,{"$f":"'Detailblatt II'!I20","v":0},{"$f":"'Detailblatt II'!J20","v":0},{"$f":"(F5-G5)","v":0}]
["Entnahme (=Einnahme) Ansparen (=Ausgabe)","von Vermögen",{"$f":"IF((Beitragsermittlung!B16)-('Detailblatt II'!F14+'Detailblatt II'!F15)>0,(Beitragsermittlung!B16)-('Detailblatt II'!F14+'Detailblatt II'!F15),0)","v":26705},0,-26705,0,{"$f":"'Detailblatt II'!G21","v":0},{"$f":"(F6-G6)","v":0}]
["angeordnete Vermögensänderung lt. FO",null,{"$f":"Beitragsermittlung!B14","v":0},null,0,{"$f":"'Detailblatt II'!I19","v":0},null,{"$f":"(F7-G7)","v":0}]
["Zurückführung an Studierende (StuRa)",null,25840,{"$f":"C8","v":25840},{"$f":"D8-C8","v":0}]
[]
["Gesamt:",null,{"$f":"SUM(C3:C9)","v":258820},119898.48,-138921.51999999999,{"$f":"SUM(F3:F9)","v":258820},52278.74,206541.26]
["Berechnung des Semesterbeitrag:"]
[null,"Planausgaben:",{"$f":"F10","v":258820},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":60775}]
["-","Zurückführung:",{"$f":"C8+C9","v":25840}]
["-","Vermögensänderung",{"$f":"C7","v":0}]
["=","Gesamt:",{"$f":"C12-C13-C14-C15-F6","v":172205}]
["/","Beitragszahlungen/Jahr:",{"$f":"'Detailblatt II'!D14+('Detailblatt II'!D15/6*4)","v":7284}]
["=","Stud./Semester:",{"$f":"IF((C16-'Detailblatt II'!F13)/Deckblatt!C17<0,0,(C16-'Detailblatt II'!F13)/Deckblatt!C17)","v":19.811230093355299},"Anzusetzender Semesterbeitrag:",null,{"$f":"ROUND((C18*2),0)/2","v":20}]

{"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":232980}]
["verfügbare finanzielle Mittel",{"$f":"'fortgeschr. Mittel+Konto'!D9","v":133211.55999999997}]
["Obergrenze finanzielle Mittel",{"$f":"IF(B3<B4,B3,B4)","v":133211.55999999997}]
[]
["Vorgesehene Vermögenssenkung wegen zu hoher verfügbarer finanzieller Mittel",{"$f":"IF(Beitragsermittlung!B4>Deckblatt!F10-Deckblatt!F6,Beitragsermittlung!B4-Beitragsermittlung!B5,0)","v":0}]
["Mindestreserve",{"$f":"Mindestreserve!D17","v":121710}]
["(Verfügbare finanzielle Mittel nach Vermögensenkung)",{"$f":"B4-B7","v":133211.55999999997}]
["Untergrenze für verfügbare finanzielle Mittel durch Bemessung an der Mindestreserve wird erreicht",{"$f":"IF(B5<B8,B8,B5)","v":133211.55999999997}]
["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'!F13)),Deckblatt!F10-Deckblatt!F6-(Deckblatt!C3+Deckblatt!C5+Deckblatt!C8+Deckblatt!C9+'Detailblatt II'!F13),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'!F13)","v":144305}]

{"sheet":"fortgeschr. Mittel+Konto","index":3,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[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],[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],[6,6,6,7],[23,6,23,7],[22,6,22,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]]}
["Fortgeschriebene finanzielle Mittel + Bankkontostand",null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2020}]
[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":"2188.92+49+7.57+895692.44+60000","v":957937.92999999993}]
["-","abzgl. voraussichtliche Ausgaben",null,{"$f":"I24*(-1)","v":-702746.1},null,"2.","Finanzbeschlüsse aktuell noch nicht bezahlt in Summe",null,0]
["-","nachrangig verwendbares Vorjahresbudget",null,{"$f":"'Detailblatt I'!P53*(-1)-'Detailblatt I'!Q53*(-1)","v":-37610.660000000003}]
["-","Zurückführung an Studierende gesamt",null,{"$f":"SUM(Deckblatt!C8:C9)*-1","v":-25840},null,"3.","Schulungen/Konferenzen (KoSe)",null,0]
["-","Beitragseinnahmen anteilig WS 20/21 für 2021",null,{"$f":"-90312.5-1312.48+33095.37","v":-58529.609999999993},null,"4.","voraussichtliche AE",null,0]
["=","verfügbare finanzielle Mittel",null,{"$f":"D4+D5+D6+D7+D8","v":133211.55999999997},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,{"$f":"702922.5-176.4","v":702746.1}]
[]
[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.","Ausgaben der FSRä",null,0]
[null,null,null,null,null,"=","Gesamtsumme:",null,{"$f":"SUM(I3:I23)","v":702746.1}]

{"sheet":"Mindestreserve","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,3,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],[10,3,10,4],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,4],[10,0,10,2],[9,0,9,2],[8,0,8,2],[9,3,9,4],[8,3,8,4],[5,3,5,4],[6,3,6,4],[4,3,4,4],[16,0,16,2],[11,0,11,4],[15,0,15,2],[14,0,14,2],[16,3,16,4],[15,3,15,4],[14,3,14,4],[13,3,13,4],[12,3,12,4],[13,0,13,2],[12,0,12,2]]}
["Mindestreserve",null,null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2020},"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":119560}]
["…aktuell ohne Belegung…"]
["…aktuell ohne Belegung…",null,null,"------"]
["Referat Finanzen"]
["Kontoführungsgebühren",null,null,{"$f":"Finanzen!G3","v":400}]
["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'!F14","v":700}]
["…aktuell ohne Belegung…",null,null,"------"]
["…aktuell ohne Belegung…",null,null,"------"]
["Gesamt:",null,null,{"$f":"SUM(D5:E16)","v":121710}]

{"sheet":"Detailblatt I","index":5,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,18,1,18],[2,0,2,18],[3,0,3,18],[36,0,36,18],[21,0,21,18],[0,16,1,16],[6,14,9,14],[0,5,1,8],[0,4,1,4],[0,0,1,3],[4,1,4,8],[28,1,28,8],[27,1,27,8],[26,1,26,8],[25,1,25,8],[24,1,24,8],[34,1,34,8],[33,1,33,8],[31,1,31,8],[30,1,30,8],[29,1,29,8],[32,1,32,8],[35,0,35,8],[40,0,40,8],[4,12,4,14],[0,9,0,11],[0,12,0,14],[39,1,39,8],[17,1,17,8],[16,1,16,8],[15,1,15,8],[22,1,22,8],[14,1,14,8],[23,1,23,8],[18,1,18,8],[20,0,20,8],[19,1,19,8],[37,1,37,8],[0,15,1,15],[0,17,1,17],[5,1,9,1],[13,1,13,8],[11,1,11,8],[10,1,10,8],[9,2,9,8],[5,2,5,8],[7,12,9,12],[8,2,8,8],[7,2,7,8],[6,2,6,8],[12,1,12,8],[38,1,38,8],[52,0,52,8],[45,0,45,8],[51,0,51,8],[47,1,47,8],[48,1,48,8],[49,1,49,8],[50,1,50,8],[46,0,46,18],[51,15,51,16],[47,9,50,11],[42,15,43,18],[41,0,41,18],[37,15,40,18],[37,9,39,11],[43,12,43,14],[42,12,42,13],[42,9,43,11],[43,0,43,4],[44,9,44,11],[44,0,44,7],[43,7,43,8],[43,5,43,6],[42,0,42,4]]}
["Detailblatt I",null,null,null,"Jahr -",2020,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,395.98,{"$f":"K6","v":395.98}]
[4120,null,"Gehälter",null,null,null,null,null,null,null,null,null,119560,33860.75,{"$f":"M7-SUM(N7:N10)+L6","v":78171.95}]
[4130,null,"gesetzl. sozial. Aufw.",null,null,null,null,null,null,null,null,null,null,7579.85]
[4138,null,"Beitrag BG",null,null,null,null,null,null,null,null,null,null,0]
[4956,null,"Acon GmbH (Lohnabr.)",null,null,null,null,null,null,null,null,null,null,343.43]
[4110,"(AE) Aufwandsentschädigungen",null,null,null,null,null,null,null,null,null,null,16000,3376.71,{"$f":"M11-N11","v":12623.29}]
[4640,"Kaffee & Verpflegung",null,null,null,null,null,null,null,null,null,null,1200,404.16,795.83999999999992]
[4670,"Allgemeine Reisekosten (die keiner Veranstaltung zugeordnet sind)",null,null,null,null,null,null,null,null,null,null,500,0,{"$f":"M13-N13","v":500}]
[4909,"Sprecherinnen und Sprecher",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,200,1.7,198.3,10,{"$f":"IF(O15<0,IF(P15>0,IF((O15*(-1))>P15,P15,O15*(-1)),0),0)","v":0},{"$f":"IF(OR(Q15>P15,O15+P15<0),makro1(),ROUNDDOWN(P15-Q15,-1))","v":10},{"$f":"IF(O15>0,ROUNDDOWN(O15,-1),0)","v":190}]
[4943,"Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,2000,791.88,1208.1199999999999,0,{"$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":0},{"$f":"IF(O16>0,ROUNDDOWN(O16,-1),0)","v":1200}]
[4944,"Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,500,0,500,640,0,{"$f":"IF(OR(Q17>P17,O17+P17<0),makro1(),ROUNDDOWN(P17-Q17,-1))","v":640},{"$f":"IF(O17>0,ROUNDDOWN(O17,-1),0)","v":500}]
[4945,"Durchführung Konferenzen",null,null,null,null,null,null,null,{"$f":"Konferenzen!C7","v":44525},{"$f":"Konferenzen!D7","v":0},{"$f":"K18-J18","v":-44525},{"$f":"Konferenzen!F7","v":47275},{"$f":"Konferenzen!G7","v":0},47275,{"$f":"Konferenzen!I7","v":2000},{"$f":"Konferenzen!J7","v":0},{"$f":"Konferenzen!K7","v":2000},{"$f":"Konferenzen!L7","v":1500}]
[4950,"Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,1500,0,1500,10,{"$f":"IF(O19<0,IF(P19>0,IF((O19*(-1))>P19,P19,O19*(-1)),0),0)","v":0},{"$f":"IF(OR(Q19>P19,O19+P19<0),makro1(),ROUNDDOWN(P19-Q19,-1))","v":10},{"$f":"IF(O19>0,ROUNDDOWN(O19,-1),0)","v":1500}]
[4989,"Ersatz- und Neuanschaffung",null,null,null,null,null,null,null,null,null,null,2000,410.04,1589.96,1910,0,{"$f":"IF(OR(Q20>P20,O20+P20<0),makro1(),ROUNDDOWN(P20-Q20,-1))","v":1910},{"$f":"IF(O20>0,ROUNDDOWN(O20,-1),0)","v":1580}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J20)","v":44525},{"$f":"SUM(K6:K20)","v":395.98},-44129.02,{"$f":"SUM(M6:M20)","v":190735},46768.52,144362.46,{"$f":"SUM(P15:P20)","v":4570},{"$f":"SUM(Q15:Q20)","v":0},{"$f":"SUM(R15:R20)","v":4570},{"$f":"SUM(S15:S20)","v":6470}]
["Referate"]
["4955/4970","Finanzen",null,null,null,null,null,null,null,{"$f":"Finanzen!D6","v":0},{"$f":"Finanzen!E6","v":0},{"$f":"K23-J23","v":0},{"$f":"Finanzen!G6","v":1650},{"$f":"Finanzen!H6","v":769.14},{"$f":"M23-N23","v":880.86}]
[4961,"Hochschulpolitik",null,null,null,null,null,null,null,{"$f":"Hochschulpolitik!C8","v":0},{"$f":"Hochschulpolitik!D8","v":0},{"$f":"K24-J24","v":0},{"$f":"Hochschulpolitik!F8","v":850},{"$f":"Hochschulpolitik!G8","v":150},700,{"$f":"Hochschulpolitik!I8","v":770},{"$f":"Hochschulpolitik!J8","v":0},{"$f":"Hochschulpolitik!K8","v":770},{"$f":"Hochschulpolitik!L8","v":700}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C7","v":0},{"$f":"Internationales!D7","v":0},0,{"$f":"Internationales!F7","v":700},{"$f":"Internationales!G7","v":50},650,{"$f":"Internationales!I7","v":0},{"$f":"Internationales!J7","v":0},{"$f":"Internationales!K7","v":0},{"$f":"Internationales!L7","v":400}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C14","v":12800},{"$f":"Kultur!D14","v":802.5},-11997.5,{"$f":"Kultur!F14","v":17700},{"$f":"Kultur!G14","v":651.32999999999993},17048.669999999998,{"$f":"Kultur!I14","v":1760},{"$f":"Kultur!J14","v":0},{"$f":"Kultur!K14","v":1760},{"$f":"Kultur!L14","v":17040}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C9","v":500},{"$f":"Öffentlichkeitsarbeit!D9","v":60},-440,{"$f":"Öffentlichkeitsarbeit!F9","v":2900},{"$f":"Öffentlichkeitsarbeit!G9","v":1011.16},1888.8400000000001,{"$f":"Öffentlichkeitsarbeit!I9","v":2600},{"$f":"Öffentlichkeitsarbeit!J9","v":0},{"$f":"Öffentlichkeitsarbeit!K9","v":2600},{"$f":"Öffentlichkeitsarbeit!L9","v":1870}]
[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":2250},{"$f":"Qualitätsmanagement!G6","v":0},2250,{"$f":"Qualitätsmanagement!I6","v":2190},{"$f":"Qualitätsmanagement!J6","v":0},{"$f":"Qualitätsmanagement!K6","v":2190},{"$f":"Qualitätsmanagement!L6","v":2000}]
[4966,"Soziales",null,null,null,null,null,null,null,{"$f":"Soziales!C8","v":0},{"$f":"Soziales!D8","v":0},0,{"$f":"Soziales!F8","v":15650},{"$f":"Soziales!G8","v":0},15650,{"$f":"Soziales!I8","v":1020},{"$f":"Soziales!J8","v":0},{"$f":"Soziales!K8","v":1020},{"$f":"Soziales!L8","v":450}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C9","v":0},{"$f":"Sport!D9","v":0},0,{"$f":"Sport!F9","v":500},{"$f":"Sport!G9","v":0},500,{"$f":"Sport!I9","v":1050},{"$f":"Sport!J9","v":0},{"$f":"Sport!K9","v":1050},{"$f":"Sport!L9","v":500}]
[4968,"Studium",null,null,null,null,null,null,null,{"$f":"Studium!C6","v":0},{"$f":"Studium!D6","v":0},0,{"$f":"Studium!F6","v":200},{"$f":"Studium!G6","v":0},200,{"$f":"Studium!I6","v":0},{"$f":"Studium!J6","v":0},{"$f":"Studium!K6","v":0},{"$f":"Studium!L6","v":0}]
[4969,"Studentische Selbstverwaltung & Organisation",null,null,null,null,null,null,null,{"$f":"'Studentische Verwaltung'!C15","v":1300},{"$f":"'Studentische Verwaltung'!D15","v":54},-1246,{"$f":"'Studentische Verwaltung'!F15","v":3835},{"$f":"'Studentische Verwaltung'!G15","v":168.09},3666.91,{"$f":"'Studentische Verwaltung'!I15","v":18140},{"$f":"'Studentische Verwaltung'!J15","v":9.3400000000000034},{"$f":"'Studentische Verwaltung'!K15","v":18130},{"$f":"'Studentische Verwaltung'!L15","v":3670}]
[4946,"Personal",null,null,null,null,null,null,null,{"$f":"Personal!C21","v":1650},{"$f":"'Studentische Verwaltung'!D16","v":0},{"$f":"K33-J33","v":-1650},{"$f":"Personal!F21","v":8350},{"$f":"'Studentische Verwaltung'!G16","v":0},{"$f":"M33-N33","v":8350},{"$f":"Personal!I21","v":1970},{"$f":"'Studentische Verwaltung'!J16","v":0},{"$f":"Personal!K21","v":1970},{"$f":"Personal!L21","v":8100}]
["----","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(J23:J35)","v":16250},{"$f":"SUM(K23:K35)","v":916.5},{"$f":"SUM(L23:L35)","v":-15333.5},{"$f":"SUM(M23:M35)","v":54585},{"$f":"SUM(N23:N35)","v":2799.72},51785.279999999999,{"$f":"SUM(P24:P33)","v":29500},{"$f":"SUM(Q24:Q33)","v":9.3400000000000034},{"$f":"SUM(R24:R33)","v":29490},{"$f":"SUM(S24:S33)","v":34730}]
["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":"M38-N38","v":0}]
["----","Wahlausschuss der Studentinnen- und Studentenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M39-N39","v":0}]
[4941,"(HFA) Härtefallausschuss der Studentinnen- & Studentenschaft",null,null,null,null,null,null,null,null,null,null,3000,1460,{"$f":"M40-N40","v":1540}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M38:M40)","v":3000},{"$f":"SUM(N38:N40)","v":1460},{"$f":"SUM(O38:O40)","v":1540}]
[]
["Anzahl der Studierenden im:",null,null,null,null,"WiSe","20/21","SoSe",2020]
["gesamt:",null,null,null,null,4650,null,4100]
["#4942 Absicherung Teilnahme BuFaTas lt. Finanzordnung:",null,null,null,null,null,null,null,0.5,null,null,null,{"$f":"ROUND(($F$44+$H$44)*$I$45,-2)","v":4400},0,{"$f":"M45-N45","v":4400},3550,{"$f":"IF(O45<0,IF(P45>0,IF((O45*(-1))>P45,P45,O45*(-1)),0),0)","v":0},{"$f":"IF(OR(Q45>P45,O45+P45<0),makro1(),ROUNDDOWN(P45-Q45,-1))","v":3550},{"$f":"IF(O45>0,ROUNDDOWN(O45,-1),0)","v":4400}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M45:M45)","v":4400},{"$f":"SUM(N45:N45)","v":0},{"$f":"SUM(O45:O45)","v":4400},{"$f":"SUM(P45)","v":3550},{"$f":"SUM(Q45)","v":0},{"$f":"SUM(R45:R45)","v":3550},{"$f":"SUM(S45)","v":4400}]
["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":"M48-N48","v":0}]
["----","Konferenz Sächsischer Studierendenschaft",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I6","v":2000},{"$f":"'Detailblatt II'!J6","v":0},{"$f":"M49-N49","v":2000}]
["----","Interessenvertretungen der Studentinnen- und Studentenschaft ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I11","v":4100},{"$f":"'Detailblatt II'!J11","v":1250.5},{"$f":"M50-N50","v":2849.5}]
["----","weitere Interessenvertetungen",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M51-N51","v":0}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M48:M51)","v":6100},{"$f":"SUM(N48:N51)","v":1250.5},{"$f":"SUM(O48:O51)","v":4849.5}]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J46,J41,J36,J21)","v":60775},{"$f":"SUM(K46,K41,K36,K21)","v":1312.48},{"$f":"SUM(L46,L41,L36,L21)","v":-59462.52},{"$f":"SUM(M52,M46,M41,M36,M21)","v":258820},{"$f":"SUM(N52,N46,N41,N36,N21)","v":52278.74},{"$f":"SUM(O52,O46,O41,O36,O21)","v":206937.24},{"$f":"SUM(P21,P36,P46)","v":37620},{"$f":"SUM(Q46,Q36,Q21)","v":9.3400000000000034},{"$f":"SUM(R46,R36,R21)","v":37610},{"$f":"SUM(S46,S36,S21)","v":45600}]

{"sheet":"Detailblatt II","index":6,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,8,0,10],[0,2,1,3],[0,0,1,0],[0,4,1,4],[0,1,1,1],[0,5,0,7],[22,0,22,4],[21,3,21,4],[15,3,15,4],[10,3,10,4],[3,0,3,3],[4,0,4,3],[5,3,5,4],[12,2,14,2],[19,0,19,3],[20,0,20,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[18,0,18,4],[17,0,17,4]]}
["Detailblatt II","Jahr -",{"$f":"'Detailblatt I'!F1","v":2020},null,"Häufigkeit","Einnahmen",null,null,"Ausgaben"]
[null,null,null,null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Konferenz Sächsischer Studierendenschaften"]
["Finanzvereinbarung",null,null,null,1,0,0,{"$f":"G4-F4","v":0},1350,0,{"$f":"I4-J4","v":1350}]
["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},2000,0,2000]
["Interessenvertretungen der Studentinnen- und Studentenschaften"]
["faranto e.V.",null,null,null,null,0,0,{"$f":"G8-F8","v":0},600,0,{"$f":"I8-J8","v":600}]
["freier zusammenschluss von studentInnenschaften (fzs) e.V.",null,null,null,1,0,0,{"$f":"G9-F9","v":0},3500,1250.5,{"$f":"I9-J9","v":2249.5}]
["weitere",null,null,null,null,0,0,{"$f":"G10-F10","v":0},0,0,{"$f":"I10-J10","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F8:F10)","v":0},{"$f":"SUM(G8:G10)","v":0},0,4100,1250.5,2849.5]
["Beitragseinnahmen"]
["Anteilig WS 19/20",18,"x Studierende",4649,1,{"$f":"ROUND((($B$13*$D$13)/6)*2,-2)","v":27900},27894,{"$f":"G13-F13","v":-6},0,0,{"$f":"I13-J13","v":0}]
["SoSe 20",15.5,null,4184,1,{"$f":"ROUND($B$14*$D$14,-2)","v":64900},64852,{"$f":"G14-F14","v":-48},0,0,{"$f":"I14-J14","v":0}]
["Anteilig WS 20/21",17,null,4650,1,{"$f":"ROUND((($B$15*$D$15)/6)*4,-2)","v":52700},0,{"$f":"G15-F15","v":-52700},0,0,{"$f":"I15-J15","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F13:F15)","v":145500},{"$f":"SUM(G13:G15)","v":92746},{"$f":"SUM(H13:H15)","v":-52754},0,0,0]
["Vermögen"]
["Verfügbare finanzielle Mittel",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D9","v":133211.55999999997},null,{"$f":"G18-F18","v":-133211.55999999997},0,0,{"$f":"I18-J18","v":0}]
["angeordnete Vermögensänderung lt. FO",null,null,null,null,{"$f":"Deckblatt!C7","v":0},null,0,{"$f":"IF(F18<Mindestreserve!D17,Mindestreserve!D17-F18,0)","v":0},null,{"$f":"I19-J19","v":0}]
["Zinsen auf Vermögen",null,null,null,null,0,0,0,0,0,{"$f":"I20-J20","v":0}]
["geplante Veränderung des Vermögens Ansparen/Entnahme",null,null,null,null,{"$f":"Deckblatt!C6*(-1)","v":-26705},0,26705,{"$f":"Deckblatt!F6","v":0},0,{"$f":"I21-J21","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F18:F21)","v":106506.55999999997},0,-106506.55999999997,0,0,0]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F16,F11,F6)","v":145500},{"$f":"SUM(G16,G11,G6)","v":92746},{"$f":"SUM(H16,H11,H6)","v":-52754},{"$f":"SUM(I16,I11,I6)","v":6100},{"$f":"SUM(J16,J11,J6)","v":1250.5},4849.5]

{"sheet":"Konferenzen","index":7,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,8,4,11],[5,8,5,11],[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[6,0,6,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7]]}
["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},1000,{"$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":1000},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["BuFaTa / FSR",0.5,0,0,{"$f":"D4-C4","v":0},1000,0,{"$f":"F4-G4","v":1000},1000,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":1000},1000,{"$f":"(D4-G4+J4)-(C4-F4)","v":1000}]
["BuFaK WiSo 2020 (einmalig!)",1,44525,0,{"$f":"D5-C5","v":-44525},45525,0,{"$f":"F5-G5","v":45525},null,null,null,null,{"$f":"(D5-G5+J5)-(C5-F5)","v":1000}]
["CoCo-Pauschale",1,0,0,{"$f":"D6-C6","v":0},250,0,{"$f":"F6-G6","v":250},null,null,null,null,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C6)","v":44525},0,-44525,{"$f":"SUM(F3:F6)","v":47275},0,47275,{"$f":"SUM(I3:I6)","v":2000},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":2000},{"$f":"SUM(L3:L6)","v":1500},2750]

{"sheet":"Personal","index":8,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[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],[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]]}
["Schulungen","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Akkreditierung / Qualitätsmanagement",1,0,0,{"$f":"D3-C3","v":0},2500,0,{"$f":"F3-G3","v":2500},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":2500},{"$f":"(D3-G3+J3)-(C3-F3)","v":2500}]
["Sozialberatung (BaföG, Jobberatung) / Soziales",1,0,0,{"$f":"D4-C4","v":0},50,0,{"$f":"F4-G4","v":50},150,{"$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":150},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":50},{"$f":"(D4-G4+J4)-(C4-F4)","v":50}]
["Schulungen studentische und akademische\nSelbstverwaltung (Studienprüfungsordnung) / Studium",1,0,0,0,100,0,100,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},100,100]
["Prüfungsangelegenheiten / Studium",1,0,0,0,50,0,50,150,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":150},50,50]
["pol. Bildung, Antidiskriminierung, Gender- / Hochschulpolitik",1,0,0,0,150,0,150,150,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":150},150,150]
["Konstituierungsseminar (KoSe) / StuRa",1,0,0,0,500,0,500,770,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":770},500,500]
["Lern- und Informationsseminar (LuISe) / StuRa",1,0,0,0,2500,0,2500,0,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":0},2500,2500]
["Study Night o.ä.",1,250,0,-250,550,0,550,500,0,{"$f":"IF(OR(J10>I10,H10+I10<0),makro1(),ROUNDDOWN(I10-J10,-1))","v":500},550,300]
["CLearance And Rapprochement (CLARA) / StuRa",1,0,0,0,50,0,50,100,0,{"$f":"IF(OR(J11>I11,H11+I11<0),makro1(),ROUNDDOWN(I11-J11,-1))","v":100},50,50]
["Veranstaltung zur fachlichen Weiterbildung / Studium",1,1400,0,-1400,1500,0,1500,0,0,{"$f":"IF(OR(J12>I12,H12+I12<0),makro1(),ROUNDDOWN(I12-J12,-1))","v":0},1500,100]
["CoCo-Pauschale",1,0,0,0,250,0,250]
["Zwischensumme:",null,{"$f":"SUM(C3:C13)","v":1650},{"$f":"SUM(D3:D13)","v":0},-1650,8200,0,8200,{"$f":"SUM(I3:I13)","v":1820},{"$f":"SUM(J3:J13)","v":0},{"$f":"SUM(K3:K13)","v":1820},{"$f":"SUM(L3:L13)","v":7950},{"$f":"(D14-G14+J14)-(C14-F14)","v":6550}]
[]
["Wahlen","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","§5 Abs.4 S.2 FO"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Informationen zu Wahlen",2,0,0,{"$f":"D18-C18","v":0},150,0,{"$f":"F18-G18","v":150},150,{"$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":150},{"$f":"IF(H18>0,ROUNDDOWN(H18,-1),0)","v":150},{"$f":"(D18-G18+J18)-(C18-F18)","v":150}]
["Zwischensumme:",null,{"$f":"C18","v":0},0,0,150,0,150,{"$f":"SUM(I18)","v":150},{"$f":"SUM(J18)","v":0},{"$f":"SUM(K18)","v":150},{"$f":"SUM(L18)","v":150},150]
[]
["Gesamtsumme:",null,{"$f":"SUM(C14+C19)","v":1650},{"$f":"SUM(D14+D19)","v":0},-1650,8350,0,8350,{"$f":"SUM(I14+I19)","v":1970},0,1970,8100,{"$f":"(D21-G21+J21)-(C21-F21)","v":6700}]

{"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},400,358.59,{"$f":"G3-H3","v":41.410000000000025}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1000,410.55,{"$f":"G4-H4","v":589.45000000000005}]
["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,1650,769.14,880.86000000000013]

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

{"sheet":"Internationales","index":11,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,12,1,12],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,5,0,7],[6,0,6,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,8,1,8],[5,8,5,11]]}
["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"]
["Erasmus Student Network",null,0,0,{"$f":"D3-C3","v":0},350,0,{"$f":"F3-G3","v":350},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":350},{"$f":"(D3-G3+J3)-(C3-F3)","v":350}]
["DAAD Mitgliedsbeitrag",1,0,0,{"$f":"D4-C4","v":0},50,50,{"$f":"F4-G4","v":0},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":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["Internationaler Tag",1,0,0,{"$f":"D5-C5","v":0},50,0,{"$f":"F5-G5","v":50},0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},50,50]
["CoCo-Pauschale",null,0,0,{"$f":"D6-C6","v":0},250,0,{"$f":"F6-G6","v":250}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C6)","v":0},0,0,700,50,650,{"$f":"SUM(I3:I6)","v":0},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":0},{"$f":"SUM(L3:L6)","v":400},{"$f":"(D7-G7+J7)-(C7-F7)","v":650}]

{"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)",1,500,0,{"$f":"D3-C3","v":-500},1000,0,{"$f":"F3-G3","v":1000},510,{"$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":510},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":1000},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Kino in der Hochschule",null,200,67.5,-132.5,600,244.82,355.18,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":350},{"$f":"(D4-G4+J4)-(C4-F4)","v":222.68}]
["Rockkonzert",1,500,0,-500,1000,0,1000,650,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":650},1000,{"$f":"(D5-G5+J5)-(C5-F5)","v":500}]
["Spieleabende",2,0,0,{"$f":"D6-C6","v":0},0,0,{"$f":"F6-G6","v":0},150,{"$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":150},0,{"$f":"(D6-G6+J6)-(C6-F6)","v":0}]
["Dies Academicus",1,0,0,0,0,0,0,350,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":350},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":0},0]
["LAN-Partys",1,600,0,-600,600,0,600,100,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":100},600,0]
["Fakfeste & Sommerfeste",null,1000,585,{"$f":"D9-C9","v":-415},1500,266.63,{"$f":"F9-G9","v":1233.3699999999999},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":1230},{"$f":"(D9-G9+J9)-(C9-F9)","v":818.37}]
["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,3500,0,{"$f":"D11-C11","v":-3500},4500,0,{"$f":"F11-G11","v":4500},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":4500},{"$f":"(D11-G11+J11)-(C11-F11)","v":1000}]
["CoCo-Pauschale",null,0,0,{"$f":"D12-C12","v":0},0,0,{"$f":"F12-G12","v":0}]
["Teambuilding (Gruppenkuscheln?)",1,3000,150,-2850,4500,139.88,4360.12,0,0,{"$f":"IF(OR(J13>I13,H13+I13<0),makro1(),ROUNDDOWN(I13-J13,-1))","v":0},4360,1510.12]
["Gesamtsumme:",null,{"$f":"SUM(C3:C13)","v":12800},802.5,-11997.5,17700,651.32999999999993,17048.669999999998,{"$f":"SUM(I3:I13)","v":1760},0,1760,17040,{"$f":"(D14-G14+J14)-(C14-F14)","v":5051.17}]

{"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},450,0,{"$f":"F3-G3","v":450},850,{"$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":850},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":450},{"$f":"(D3-G3+J3)-(C3-F3)","v":450}]
["Hochschulveranstaltungen",2,0,0,0,200,0,200,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":200},{"$f":"(D4-G4+J4)-(C4-F4)","v":200}]
["Werbemittel",null,0,0,0,1250,240.04,1009.96,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},1000,1009.96]
["Interessiertengrillen",2,0,0,0,0,0,0,250,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":250},0,0]
["CoCo-Pauschale",null,0,0,0,0,0,0]
["Merchandise u.ä.",null,500,60,-440,1000,771.12,228.88,1500,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":1500},220,-211.12]
["Gesamtsumme:",null,{"$f":"SUM(C3:C8)","v":500},60,-440,2900,1011.16,1888.8400000000001,2600,0,2600,1870,1448.8400000000001]

{"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},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}]
["Erstsemestereinführung (ESE)",1,0,0,{"$f":"D4-C4","v":0},2000,0,{"$f":"F4-G4","v":2000},2190,{"$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":2190},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":2000},{"$f":"(D4-G4+J4)-(C4-F4)","v":2000}]
["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,2250,0,2250,2190,0,2190,2000,2000]

{"sheet":"Soziales","index":15,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,12,1,12],[7,0,7,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],[6,8,6,11],[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},200,0,{"$f":"F3-G3","v":200},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":200},{"$f":"(D3-G3+J3)-(C3-F3)","v":200}]
["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},820,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":820},{"$f":"IF(H5>0,ROUNDDOWN(H5,-1),0)","v":150},{"$f":"(D5-G5+J5)-(C5-F5)","v":150}]
["Finanzielle Nothilfe (Covid-19)",null,0,0,{"$f":"D6-C6","v":0},15000,0,{"$f":"F6-G6","v":15000}]
["CoCo-Pauschale",null,0,0,0,200,0,200]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},0,0,15650,0,15650,1020,0,1020,450,15650]

{"sheet":"Sport","index":16,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[8,0,8,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7]]}
["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"]
["Truniere, Preise, Beiträge",null,0,0,{"$f":"D3-C3","v":0},250,0,{"$f":"F3-G3","v":250},600,{"$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":600},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":250},{"$f":"(D3-G3+J3)-(C3-F3)","v":250}]
["Startgebühren",1,0,0,0,100,0,100,300,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":300},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":100},{"$f":"(D4-G4+J4)-(C4-F4)","v":100}]
["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]
["Hochschulsportfest",1,0,0,0,150,0,150,150,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":150},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":150},150]
["CoCo-Pauschale",null,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":0},0,0]
["Gesamtsumme:",null,{"$f":"SUM(C3:C8)","v":0},0,0,500,0,500,{"$f":"SUM(I3:I8)","v":1050},{"$f":"SUM(J3:J8)","v":0},{"$f":"SUM(K3:K8)","v":1050},{"$f":"SUM(L3:L8)","v":500},500]

{"sheet":"Studium","index":17,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[4,8,4,11],[5,0,5,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7]]}
["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}]
["Systemakkreditierung, was nun?",null,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},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["CoCo-Pauschale",null,0,0,{"$f":"D5-C5","v":0},200,0,{"$f":"F5-G5","v":200}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,200,0,200,{"$f":"SUM(I3:I5)","v":0},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":0},{"$f":"SUM(L3:L5)","v":0},200]

{"sheet":"Studentische Verwaltung","index":18,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[14,0,14,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7]]}
["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},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}]
["Domains",null,0,0,{"$f":"D4-C4","v":0},50,59.34,{"$f":"F4-G4","v":-9.3400000000000034},30,9.3400000000000034,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":20},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":0}]
["Beitrag Gruppenausweis für Jugendherbergen",1,0,0,0,35,0,35,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},30,35]
["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,300,54,-246,200,0,200,80,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":80},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":200},-46]
["Dienste für elektronische Datenverarbeitung ",null,0,0,{"$f":"D8-C8","v":0},1000,9.48,{"$f":"F8-G8","v":990.52},0,{"$f":"IF(H8<0,IF(I8>0,IF((H8*(-1))>I8,I8,H8*(-1)),0),0)","v":0},{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":0},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":990},{"$f":"(D8-G8+J8)-(C8-F8)","v":990.52}]
["Anschaffungen zwecks Umstrukturierung StuRa",null,0,0,0,0,0,0,15000,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":15000},0,0]
["andauernde Betreuung Server durch Externe",null,0,0,{"$f":"D10-C10","v":0},0,0,{"$f":"F10-G10","v":0},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":0},{"$f":"(D10-G10+J10)-(C10-F10)","v":0}]
["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,250,0,250,190,0,{"$f":"IF(OR(J12>I12,H12+I12<0),makro1(),ROUNDDOWN(I12-J12,-1))","v":190},250,250]
["Studienmaterial (z.B. Bautabellen, Laborkittel, etc.)",null,1000,0,{"$f":"D13-C13","v":-1000},1500,0,{"$f":"F13-G13","v":1500},0,{"$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":0},{"$f":"IF(H13>0,ROUNDDOWN(H13,-1),0)","v":1500},{"$f":"(D13-G13+J13)-(C13-F13)","v":500}]
["laufende Kosten für Druck, samt Nebenkosten",null,0,0,0,700,99.27,600.73,340,0,{"$f":"IF(OR(J14>I14,H14+I14<0),makro1(),ROUNDDOWN(I14-J14,-1))","v":340},600,600.73]
["Gesamtsumme:",null,{"$f":"SUM(C3:C14)","v":1300},54,-1246,3835,168.09,3666.91,{"$f":"SUM(I3:I14)","v":18140},{"$f":"SUM(J3:J14)","v":9.3400000000000034},{"$f":"SUM(K3:K14)","v":18130},{"$f":"SUM(L3:L14)","v":3670},2430.25]