{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Hinweise","Deckblatt","Beitragsermittlung","fortgeschr. Mittel+Konto","Detailblatt I","Detailblatt II","Mindestreserve","Schulungen & Konferenzen","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":29,"n_cols":2,"rows_kept":29,"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."]
[]
[]
["-","Bezüglich der Fachschaftsräte:"]
["-","Die Zuführung der Gelder der FSR in \"Fortgeschriebene finanzielle Mittel\" erfolgt aufgrund deren Haushaltsplänen, ebenso wie die der \"angeordneten Vermögensänderung\"."]
["-","Die Beträge werden in Summe im Detailblatt 1 bei den jeweiligen FSR eingetragen und automatisch auf das Deckblatt übernommen."]
[]
["-","ACHTUNG:"]
[null,"Der Betrag aus der Zeile R52 vom Detailblatt 1 wird in der Summe R60 berücksichtigt."]
[]
["-","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 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 2019 Studierendenschaft HTW Dresden",null,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J60","v":8300},{"$f":"'Detailblatt I'!K60","v":0},{"$f":"D3-C3","v":-8300},{"$f":"'Detailblatt I'!M60","v":177235},{"$f":"'Detailblatt I'!N60","v":0},{"$f":"(F3-G3)","v":177235}]
["Beitragseinnahmen der Studierenden",null,{"$f":"'Detailblatt II'!F16","v":155400},{"$f":"'Detailblatt II'!G16","v":0},{"$f":"D4-C4","v":-155400},{"$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":210.10000000000582},{"$f":"'Detailblatt II'!J21","v":0},-210.10000000000582,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,2524.9,{"$f":"C8","v":2524.9},{"$f":"D8-C8","v":0}]
["Zurückführung an Studierende (FSR)",null,{"$f":"SUM('Detailblatt I'!R44:R51)","v":10800},{"$f":"C9","v":10800},{"$f":"D9-C9","v":0}]
["Gesamt:",null,{"$f":"SUM(C3:C9)","v":177235},13324.9,-163910.1,177235,0,177235]
["Berechnung des Semesterbeitrag:"]
[null,"Planausgaben:",{"$f":"F10","v":177235},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":8300}]
["-","Zurückführung:",{"$f":"C8+C9","v":13324.9}]
["-","Vermögensänderung",{"$f":"C7","v":0}]
["=","Gesamt:",{"$f":"C12-C13-C14-C15-F6","v":155610.1}]
["/","Studenten/Jahr:",{"$f":"'Detailblatt II'!D14+('Detailblatt II'!D15/6*4)","v":7058.6666666666661}]
["=","Stud./Semester:",{"$f":"IF((C16-'Detailblatt II'!F13)/Deckblatt!C17<0,0,(C16-'Detailblatt II'!F13)/Deckblatt!C17)","v":18.035998299962223},"Anzusetzender Semesterbeitrag:",null,{"$f":"ROUND((C18*2),0)/2","v":18}]

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

{"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":2019}]
[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,10770.82]
[null,"Bank-/Kassenbestand bei Haushaltsplanerstellung",null,188814.02]
["-","abzgl. voraussichtliche Ausgaben",null,{"$f":"I24*(-1)","v":-55729.64},null,"2.","Finanzbeschlüsse aktuell noch nicht bezahlt in Summe",null,1783.67]
["-","nachrangig verwendbares Vorjahresbudget",null,{"$f":"'Detailblatt I'!P60*(-1)","v":-28980}]
["-","Zurückführung an Studierende gesamt",null,{"$f":"SUM(Deckblatt!C8:C9)*-1","v":-13324.9},null,"3.","Schulungen/Konferenzen (KoSe)",null,{"$f":"400+500","v":900}]
["-","Beitragseinnahmen anteilig WS 18/19",null,{"$f":"'Detailblatt II'!F13*-1","v":-28300},null,"4.","voraussichtliche AE",null,5500]
["=","verfügbare finanzielle Mittel",null,{"$f":"D4+D5+D6+D7+D8","v":62479.48000000001},null,"5.","offene Härtefallanträge",null,0]
[null,null,null,null,null,"6.","Software-Abos (AGENDA etc.)",null,{"$f":"82.11+110","v":192.11}]
[null,null,null,null,null,"7.","Kosten für Wartung (Drucker etc.)",null,100]
[null,null,null,null,null,"8.","Kontoführung",null,15]
[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,1000]
[]
[null,null,null,null,null,"14.","Mittel aller FSR in Summe\nlt. Kontenblatt",null,35468.04]
[]
[null,null,null,null,null,"15.",null,null,0]
[null,null,null,null,null,"16.",null,null,0]
[null,null,null,null,null,"17.",null,null,0]
[null,null,null,null,null,"=","Gesamtsumme:",null,{"$f":"SUM(I3:I23)","v":55729.64}]

{"sheet":"Detailblatt I","index":4,"n_rows":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":false,"merged":[[41,15,42,18],[0,18,1,18],[2,0,2,18],[3,0,3,18],[35,0,35,18],[21,0,21,18],[40,0,40,18],[36,15,39,18],[36,9,38,11],[0,16,1,16],[6,14,9,14],[0,5,1,8],[0,4,1,4],[41,0,41,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],[33,1,33,8],[32,1,32,8],[31,1,31,8],[30,1,30,8],[29,1,29,8],[49,1,49,4],[46,1,46,4],[50,7,50,8],[50,5,50,6],[49,7,49,8],[49,5,49,6],[47,5,47,6],[46,7,46,8],[46,5,46,6],[47,7,47,8],[47,1,47,4],[48,1,48,4],[48,7,48,8],[48,5,48,6],[50,1,50,4],[34,0,34,8],[39,0,39,8],[4,12,4,14],[0,9,0,11],[0,12,0,14],[38,1,38,8],[17,1,17,8],[16,1,16,8],[15,1,15,8],[14,1,14,8],[22,1,22,8],[13,1,13,8],[23,1,23,8],[18,1,18,8],[20,0,20,8],[19,1,19,8],[0,15,1,15],[0,17,1,17],[5,1,9,1],[12,1,12,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],[59,0,59,8],[52,0,52,8],[58,0,58,8],[51,4,51,7],[51,0,51,2],[54,1,54,8],[55,1,55,8],[56,1,56,8],[57,1,57,8],[53,0,53,18],[58,15,58,16],[54,9,57,11],[51,9,51,11],[42,7,42,8],[42,5,42,6],[36,1,36,8],[37,1,37,8],[42,12,42,14],[41,12,41,13],[41,9,42,11],[42,0,42,4],[44,1,44,4],[45,1,45,4],[43,1,43,4],[45,7,45,8],[45,5,45,6],[44,7,44,8],[44,5,44,6],[43,7,43,8],[43,5,43,6]]}
["Detailblatt I",null,null,null,"Jahr -",2019,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,86000,0,{"$f":"M7-SUM(N7:N10)+L6","v":86000}]
[4130,null,"gesetzl. sozial. Aufw.",null,null,null,null,null,null,null,null,null,null,0]
[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,0]
[4110,"(AE) Aufwandsentschädigungen",null,null,null,null,null,null,null,null,null,null,10000,0,{"$f":"M11-N11","v":10000}]
[4640,"Kaffee & Verpflegung",null,null,null,null,null,null,null,null,null,null,1000,0,1000]
[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,300,0,300,300,{"$f":"IF(O14<0,IF(P14>0,IF((O14*(-1))>P14,P14,O14*(-1)),0),0)","v":0},{"$f":"IF(OR(Q14>P14,O14+P14<0),makro1(),ROUNDDOWN(P14-Q14,-1))","v":300},{"$f":"IF(O14>0,ROUNDDOWN(O14,-1),0)","v":300}]
[4943,"Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,1500,0,1500,740,{"$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":740},{"$f":"IF(O15>0,ROUNDDOWN(O15,-1),0)","v":1500}]
[4944,"Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,700,0,700,360,0,{"$f":"IF(OR(Q16>P16,O16+P16<0),makro1(),ROUNDDOWN(P16-Q16,-1))","v":360},{"$f":"IF(O16>0,ROUNDDOWN(O16,-1),0)","v":700}]
[4945,"Durchführung Konferenzen",null,null,null,null,null,null,null,null,null,null,{"$f":"'Schulungen & Konferenzen'!F19","v":2500},{"$f":"'Schulungen & Konferenzen'!G19","v":0},2500,{"$f":"'Schulungen & Konferenzen'!I19","v":1500},{"$f":"'Schulungen & Konferenzen'!J19","v":0},{"$f":"'Schulungen & Konferenzen'!K19","v":1500},{"$f":"'Schulungen & Konferenzen'!L19","v":2000}]
[4946,"Durchführung Schulungen",null,null,null,null,null,null,null,null,null,null,{"$f":"'Schulungen & Konferenzen'!F12","v":5500},{"$f":"'Schulungen & Konferenzen'!G12","v":0},5500,{"$f":"'Schulungen & Konferenzen'!I12","v":3530},{"$f":"'Schulungen & Konferenzen'!J12","v":0},{"$f":"'Schulungen & Konferenzen'!K12","v":3530},{"$f":"'Schulungen & Konferenzen'!L12","v":5250}]
[4950,"Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,500,0,500,500,{"$f":"IF(O19<0,IF(P19>0,IF((O19*(-1))>P19,P19,O19*(-1)),0),0)","v":0},{"$f":"IF(OR(Q19>P19,O19+P19<0),makro1(),ROUNDDOWN(P19-Q19,-1))","v":500},{"$f":"IF(O19>0,ROUNDDOWN(O19,-1),0)","v":500}]
[4989,"Ersatz- und Neuanschaffung",null,null,null,null,null,null,null,null,null,null,4000,0,4000,1330,0,{"$f":"IF(OR(Q20>P20,O20+P20<0),makro1(),ROUNDDOWN(P20-Q20,-1))","v":1330},{"$f":"IF(O20>0,ROUNDDOWN(O20,-1),0)","v":4000}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6)","v":0},{"$f":"SUM(L6)","v":0},{"$f":"SUM(M6:M20)","v":112000},{"$f":"SUM(N6:N20)","v":0},{"$f":"SUM(O6:O20)","v":112000},{"$f":"SUM(P14:P20)","v":8260},{"$f":"SUM(Q14:Q20)","v":0},{"$f":"SUM(R14:R20)","v":8260},{"$f":"SUM(S14:S20)","v":14250}]
["Referate"]
["4955/4970","Finanzen",null,null,null,null,null,null,null,{"$f":"Finanzen!D5","v":0},{"$f":"Finanzen!E5","v":0},{"$f":"K23-J23","v":0},{"$f":"Finanzen!G5","v":1400},{"$f":"Finanzen!H5","v":0},{"$f":"M23-N23","v":1400}]
[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":1750},{"$f":"Hochschulpolitik!G8","v":0},1750,{"$f":"Hochschulpolitik!I8","v":3000},{"$f":"Hochschulpolitik!J8","v":0},{"$f":"Hochschulpolitik!K8","v":3000},{"$f":"Hochschulpolitik!L8","v":1750}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C7","v":0},{"$f":"Internationales!D7","v":0},0,{"$f":"Internationales!F7","v":850},{"$f":"Internationales!G7","v":0},850,{"$f":"Internationales!I7","v":1000},{"$f":"Internationales!J7","v":0},{"$f":"Internationales!K7","v":1000},{"$f":"Internationales!L7","v":400}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C10","v":7500},{"$f":"Kultur!D10","v":0},-7500,{"$f":"Kultur!F10","v":11700},{"$f":"Kultur!G10","v":0},11700,{"$f":"Kultur!I10","v":5950},{"$f":"Kultur!J10","v":0},{"$f":"Kultur!K10","v":5950},{"$f":"Kultur!L10","v":11700}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C8","v":500},{"$f":"Öffentlichkeitsarbeit!D8","v":0},-500,{"$f":"Öffentlichkeitsarbeit!F8","v":3600},{"$f":"Öffentlichkeitsarbeit!G8","v":0},3600,{"$f":"Öffentlichkeitsarbeit!I8","v":1660},{"$f":"Öffentlichkeitsarbeit!J8","v":0},{"$f":"Öffentlichkeitsarbeit!K8","v":1660},{"$f":"Öffentlichkeitsarbeit!L8","v":3600}]
[4965,"Qualitätsmanagement",null,null,null,null,null,null,null,{"$f":"Qualitätsmanagement!C4","v":0},{"$f":"Qualitätsmanagement!D4","v":0},0,{"$f":"Qualitätsmanagement!F4","v":500},{"$f":"Qualitätsmanagement!G4","v":0},500,{"$f":"Qualitätsmanagement!I4","v":0},{"$f":"Qualitätsmanagement!J4","v":0},{"$f":"Qualitätsmanagement!K4","v":0},{"$f":"Qualitätsmanagement!L4","v":0}]
[4966,"Soziales",null,null,null,null,null,null,null,{"$f":"Soziales!C7","v":0},{"$f":"Soziales!D7","v":0},0,{"$f":"Soziales!F7","v":1500},{"$f":"Soziales!G7","v":0},1500,{"$f":"Soziales!I7","v":200},{"$f":"Soziales!J7","v":0},{"$f":"Soziales!K7","v":200},{"$f":"Soziales!L7","v":1200}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C9","v":0},{"$f":"Sport!D9","v":0},0,{"$f":"Sport!F9","v":1250},{"$f":"Sport!G9","v":0},1250,{"$f":"Sport!I9","v":2190},{"$f":"Sport!J9","v":0},{"$f":"Sport!K9","v":2190},{"$f":"Sport!L9","v":1250}]
[4968,"Studium",null,null,null,null,null,null,null,{"$f":"Studium!C6","v":0},{"$f":"Studium!D6","v":0},0,{"$f":"Studium!F6","v":500},{"$f":"Studium!G6","v":0},500,{"$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'!C14","v":300},{"$f":"'Studentische Verwaltung'!D14","v":0},-300,{"$f":"'Studentische Verwaltung'!F14","v":18935},{"$f":"'Studentische Verwaltung'!G14","v":0},18935,{"$f":"'Studentische Verwaltung'!I14","v":2120},{"$f":"'Studentische Verwaltung'!J14","v":0},{"$f":"'Studentische Verwaltung'!K14","v":2120},{"$f":"'Studentische Verwaltung'!L14","v":18930}]
["----","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:J34)","v":8300},0,-8300,41985,0,41985,{"$f":"SUM(P24:P32)","v":16120},{"$f":"SUM(Q24:Q32)","v":0},{"$f":"SUM(R24:R32)","v":16120},{"$f":"SUM(S24:S32)","v":38830}]
["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":"M37-N37","v":0}]
["----","Wahlausschuss der Studentinnen- und Studentenschaft",null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"M38-N38","v":0}]
[4959,"(HFA) Härtefallausschuss der Studentinnen- & Studentenschaft",null,null,null,null,null,null,null,null,null,null,2000,0,{"$f":"M39-N39","v":2000}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M37:M39)","v":2000},{"$f":"SUM(N37:N39)","v":0},{"$f":"SUM(O37:O39)","v":2000}]
["Fachschaftsräte"]
["Anzahl der Studierenden im:",null,null,null,null,"WiSe","19/20","SoSe",2019,null,null,null,"Sockelbetrag p./Semester für FSR:",null,250,"Zuführung aus den Haushaltsplänen der FSR übernehmen. (inkl. Angeordnete Vermögensänderung)"]
["gesamt:",null,null,null,null,{"$f":"SUM(F44:G51)","v":4588},null,{"$f":"SUM(H44:I51)","v":4000},null,null,null,null,"Geld was den FSR \"zugeschrieben\" wird."]
[4901,"Bauingenieurwesen/Architektur",null,null,null,494,null,413,null,null,null,{"$f":"K44-J44","v":0},{"$f":"ROUND(($O$42*2)+((F44+H44)*$D$52),-2)","v":1200},0,{"$f":"M44-N44","v":1200},null,null,1150]
[4902,"Elektrotechnik",null,null,null,504,null,442,null,null,null,{"$f":"K45-J45","v":0},{"$f":"ROUND(($O$42*2)+((F45+H45)*$D$52),-2)","v":1200},0,{"$f":"M45-N45","v":1200},null,null,1150]
[4903,"Landbau/Umwelt/Chemie",null,null,null,703,null,609,null,null,null,0,1500,0,1500,null,null,400]
[4904,"Informatik/Mathematik",null,null,null,659,null,572,null,null,null,0,1400,0,1400,null,null,3000]
[4905,"Maschinenbau",null,null,null,703,null,603,null,null,null,0,1500,0,1500,null,null,1500]
[4906,"Geoinformation",null,null,null,330,null,293,null,null,null,0,1000,0,1000,null,null,1600]
[4907,"Wirtschaftswissenschaften",null,null,null,1097,null,994,null,null,null,0,2100,0,2100,null,null,800]
[4908,"Design",null,null,null,98,null,74,null,null,null,0,600,0,600,null,null,1200]
["Betrag für FSR:",null,null,0.75,"Absicherung Teilnahme BuFaTas:",null,null,null,0.5,null,null,null,{"$f":"ROUND(($F$43+$H$43)*$I$52,-2)","v":4300},0,4300,4600,{"$f":"IF(O52<0,IF(P52>0,IF((O52*(-1))>P52,P52,O52*(-1)),0),0)","v":0},{"$f":"IF(OR(Q52>P52,O52+P52<0),makro1(),ROUNDDOWN(P52-Q52,-1))","v":4600},{"$f":"IF(O52>0,ROUNDDOWN(O52,-1),0)","v":4300}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J44:J51)","v":0},{"$f":"SUM(K44:K51)","v":0},{"$f":"SUM(L44:L51)","v":0},{"$f":"SUM(M44:M52)","v":14800},{"$f":"SUM(N44:N52)","v":0},{"$f":"SUM(O44:O52)","v":14800},{"$f":"SUM(P52)","v":4600},{"$f":"SUM(Q52)","v":0},{"$f":"SUM(R44:R52)","v":15400},{"$f":"SUM(S52)","v":4300}]
["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":"M55-N55","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":"M56-N56","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":0},{"$f":"M57-N57","v":4100}]
["----","weitere Interessenvertetungen",null,null,null,null,null,null,null,null,null,null,350,0,{"$f":"M58-N58","v":350}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M55:M58)","v":6450},{"$f":"SUM(N55:N58)","v":0},{"$f":"SUM(O55:O58)","v":6450}]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J53,J40,J35,J21)","v":8300},{"$f":"SUM(K53,K40,K35,K21)","v":0},{"$f":"SUM(L53,L40,L35,L21)","v":-8300},{"$f":"SUM(M59,M53,M40,M35,M21)","v":177235},{"$f":"SUM(N59,N53,N40,N35,N21)","v":0},{"$f":"SUM(O59,O53,O40,O35,O21)","v":177235},{"$f":"SUM(P21,P35,P53)","v":28980},{"$f":"SUM(Q53,Q35,Q21)","v":0},{"$f":"R21+R35+R52","v":28980},{"$f":"SUM(S53,S35,S21)","v":57380}]

{"sheet":"Detailblatt II","index":5,"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":2019},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,0,{"$f":"I9-J9","v":3500}]
["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,0,4100]
["Beitragseinnahmen"]
["Anteilig WS 18/19",18.5,"x Studierende",4588,1,{"$f":"ROUND((($B$13*$D$13)/6)*2,-2)","v":28300},0,{"$f":"G13-F13","v":-28300},0,0,{"$f":"I13-J13","v":0}]
["SoSe 19",{"$f":"Deckblatt!F18","v":18},null,4000,1,{"$f":"ROUND($B$14*$D$14,-2)","v":72000},0,{"$f":"G14-F14","v":-72000},0,0,{"$f":"I14-J14","v":0}]
["Anteilig WS 19/20",{"$f":"Deckblatt!F18","v":18},null,4588,1,{"$f":"ROUND((($B$15*$D$15)/6)*4,-2)","v":55100},0,{"$f":"G15-F15","v":-55100},0,0,{"$f":"I15-J15","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F13:F15)","v":155400},{"$f":"SUM(G13:G15)","v":0},{"$f":"SUM(H13:H15)","v":-155400},0,0,0]
["Vermögen"]
["Verfügbare finanzielle Mittel",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D9","v":62479.48000000001},null,{"$f":"G18-F18","v":-62479.48000000001},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","v":210.10000000000582},0,-210.10000000000582,{"$f":"Deckblatt!F6","v":0},0,{"$f":"I21-J21","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F18:F21)","v":62689.580000000016},0,-62689.580000000016,0,0,0]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F16,F11,F6)","v":155400},{"$f":"SUM(G16,G11,G6)","v":0},{"$f":"SUM(H16,H11,H6)","v":-155400},{"$f":"SUM(I16,I11,I6)","v":6100},{"$f":"SUM(J16,J11,J6)","v":0},6100]

{"sheet":"Mindestreserve","index":6,"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":2019},"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,43000]
["…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'!F13","v":700}]
["…aktuell ohne Belegung…",null,null,"------"]
["…aktuell ohne Belegung…",null,null,"------"]
["Gesamt:",null,null,{"$f":"SUM(D5:E16)","v":45150}]

{"sheet":"Schulungen & Konferenzen","index":7,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,8,17,11],[0,12,1,12],[13,12,14,12],[12,0,12,12],[18,0,18,1],[0,1,1,1],[0,0,1,0],[0,2,0,4],[0,5,0,7],[11,0,11,1],[0,11,1,11],[13,0,14,0],[13,1,14,1],[13,2,13,4],[13,5,13,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[13,8,14,8],[13,9,14,9],[13,10,14,10],[10,8,10,11],[13,11,14,11]]}
["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",2,0,0,{"$f":"D3-C3","v":0},500,0,{"$f":"F3-G3","v":500},900,{"$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":900},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":500},{"$f":"(D3-G3+J3)-(C3-F3)","v":500}]
["Sozialberatung (BaföG, Jobberatung) / Soziales",1,0,0,{"$f":"D4-C4","v":0},150,0,{"$f":"F4-G4","v":150},300,{"$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":300},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":150},{"$f":"(D4-G4+J4)-(C4-F4)","v":150}]
["Schulungen studentische und akademische\nSelbstverwaltung (Studienprüfungsordnung) / Studium",1,0,0,0,200,0,200,400,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":400},200,200]
["Prüfungsangelegenheiten / Studium",1,0,0,0,150,0,150,300,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":300},150,150]
["pol. Bildung, Antidiskriminierung, Gender- / Hochschulpolitik",1,0,0,0,150,0,150,300,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":300},150,150]
["Konstituierungsseminar (KoSe) / StuRa",1,0,0,0,1000,0,1000,830,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":830},1000,1000]
["Lern- und Informationsseminar (LuISe) / StuRa",1,0,0,0,3000,0,3000,400,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":400},3000,3000]
["CLearance And Rapprochement (CLARA) / StuRa",1,0,0,0,100,0,100,100,0,{"$f":"IF(OR(J10>I10,H10+I10<0),makro1(),ROUNDDOWN(I10-J10,-1))","v":100},100,100]
["CoCo-Pauschale",1,0,0,0,250,0,250]
["Gesamtsumme:",null,{"$f":"SUM(C3:C11)","v":0},0,0,5500,0,5500,{"$f":"SUM(I3:I10)","v":3530},{"$f":"SUM(J3:J10)","v":0},{"$f":"SUM(K3:K10)","v":3530},{"$f":"SUM(L3:L10)","v":5250},5500]
[]
["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":"D16-C16","v":0},1000,0,{"$f":"F16-G16","v":1000},1500,{"$f":"IF(H16<0,IF(I16>0,IF((H16*(-1))>I16,I16,H16*(-1)),0),0)","v":0},{"$f":"IF(OR(J16>I16,H16+I16<0),makro1(),ROUNDDOWN(I16-J16,-1))","v":1500},{"$f":"IF(H16>0,ROUNDDOWN(H16,-1),0)","v":1000},{"$f":"(D16-G16+J16)-(C16-F16)","v":1000}]
["BuFaTa / FSR",0.5,0,0,{"$f":"D17-C17","v":0},1000,0,{"$f":"F17-G17","v":1000},0,0,{"$f":"IF(OR(J17>I17,H17+I17<0),makro1(),ROUNDDOWN(I17-J17,-1))","v":0},1000,{"$f":"(D17-G17+J17)-(C17-F17)","v":1000}]
["CoCo-Pauschale",1,0,0,{"$f":"D18-C18","v":0},500,0,{"$f":"F18-G18","v":500},null,null,null,null,500]
["Gesamtsumme:",null,{"$f":"SUM(C16:C18)","v":0},0,0,2500,0,2500,{"$f":"SUM(I16:I17)","v":1500},{"$f":"SUM(J16:J17)","v":0},{"$f":"SUM(K16:K17)","v":1500},{"$f":"SUM(L16:L17)","v":2000},2500]

{"sheet":"Finanzen","index":8,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,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,0,{"$f":"G3-H3","v":400}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1000,0,{"$f":"G4-H4","v":1000}]
["Gesamtsumme:",null,null,{"$f":"SUM(D3:D4)","v":0},0,0,1400,0,1400]

{"sheet":"Hochschulpolitik","index":9,"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},200,0,{"$f":"F3-G3","v":200},550,{"$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":550},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":200},{"$f":"(D3-G3+J3)-(C3-F3)","v":200}]
["Aktionstage gegen Sexismus und Homophobie",1,0,0,{"$f":"D4-C4","v":0},200,0,{"$f":"F4-G4","v":200},550,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":550},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":200},{"$f":"(D4-G4+J4)-(C4-F4)","v":200}]
["Aktionen, Festivals und Demonstrationen",null,0,0,{"$f":"D5-C5","v":0},300,0,{"$f":"F5-G5","v":300},750,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":750},300,300]
["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},900,0,{"$f":"F7-G7","v":900},1150,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":1150},900,900]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},0,0,1750,0,1750,3000,0,3000,1750,1750]

{"sheet":"Internationales","index":10,"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},300,0,{"$f":"F3-G3","v":300},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":300},{"$f":"(D3-G3+J3)-(C3-F3)","v":300}]
["DAAD Mitgliedsbeitrag",1,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}]
["Internationaler Tag",1,0,0,{"$f":"D5-C5","v":0},50,0,{"$f":"F5-G5","v":50},500,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":500},50,50]
["CoCo-Pauschale",null,0,0,{"$f":"D6-C6","v":0},450,0,{"$f":"F6-G6","v":450}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C6)","v":0},{"$f":"SUM(D3:D6)","v":0},{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":850},{"$f":"SUM(G3:G6)","v":0},{"$f":"SUM(H3:H6)","v":850},{"$f":"SUM(I3:I5)","v":1000},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":1000},{"$f":"SUM(L3:L5)","v":400},{"$f":"(D7-G7+J7)-(C7-F7)","v":850}]

{"sheet":"Kultur","index":11,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,12,1,12],[9,0,9,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 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öffnungsparty (SEP)",2,2000,0,{"$f":"D3-C3","v":-2000},2000,0,{"$f":"F3-G3","v":2000},2560,{"$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":2560},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":2000},{"$f":"(D3-G3+J3)-(C3-F3)","v":0}]
["Kino in der Hochschule",null,600,0,-600,800,0,800,500,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":500},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":800},{"$f":"(D4-G4+J4)-(C4-F4)","v":200}]
["Rockkonzert",1,2000,0,-2000,2000,0,2000,1440,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":1440},2000,0]
["Spieleabend",2,0,0,{"$f":"D6-C6","v":0},150,0,{"$f":"F6-G6","v":150},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},150,{"$f":"(D6-G6+J6)-(C6-F6)","v":150}]
["Dies Academicus",1,0,0,0,350,0,350,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":350},350]
["LAN-Partys",1,400,0,-400,400,0,400,560,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":560},400,0]
["Erstsemestereinführung (ESE) durch StuRa",1,2500,0,-2500,6000,0,6000,890,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":890},6000,3500]
["Gesamtsumme:",null,{"$f":"SUM(C3:C9)","v":7500},{"$f":"SUM(D3:D9)","v":0},{"$f":"SUM(E3:E9)","v":-7500},11700,0,11700,{"$f":"SUM(I3:I9)","v":5950},{"$f":"SUM(J3:J9)","v":0},{"$f":"SUM(K3:K9)","v":5950},{"$f":"SUM(L3:L9)","v":11700},{"$f":"(D10-G10+J10)-(C10-F10)","v":4200}]

{"sheet":"Öffentlichkeitsarbeit","index":12,"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]]}
["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},850,0,{"$f":"F3-G3","v":850},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":850},{"$f":"(D3-G3+J3)-(C3-F3)","v":850}]
["Hochschulveranstaltungen",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}]
["Werbemittel",null,0,0,{"$f":"D5-C5","v":0},1000,0,{"$f":"F5-G5","v":1000},1340,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":1340},1000,1000]
["Interessiertengrillen",2,0,0,{"$f":"D6-C6","v":0},250,0,{"$f":"F6-G6","v":250},0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},250,250]
["Merchandise",null,500,0,{"$f":"D7-C7","v":-500},1500,0,{"$f":"F7-G7","v":1500},320,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":320},1500,1000]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":500},0,-500,3600,0,3600,{"$f":"SUM(I3:I7)","v":1660},{"$f":"SUM(J3:J7)","v":0},{"$f":"SUM(K3:K7)","v":1660},{"$f":"SUM(L3:L7)","v":3600},3100]

{"sheet":"Qualitätsmanagement","index":13,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,12,1,12],[3,0,3,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],[2,8,2,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"]
["CoCo-Pauschale",null,0,0,{"$f":"D3-C3","v":0},500,0,{"$f":"F3-G3","v":500}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C3)","v":0},0,0,500,0,500,{"$f":"SUM(I3)","v":0},{"$f":"SUM(J3)","v":0},{"$f":"SUM(K3)","v":0},{"$f":"SUM(L3)","v":0},{"$f":"(D4-G4+J4)-(C4-F4)","v":500}]

{"sheet":"Soziales","index":14,"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},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}]
["Projekt Studieren mit Beeinträchtigung",null,0,0,{"$f":"D4-C4","v":0},200,0,{"$f":"F4-G4","v":200},0,{"$f":"IF(H4<0,IF(I4>0,IF((H4*(-1))>I4,I4,H4*(-1)),0),0)","v":0},{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":0},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":200},{"$f":"(D4-G4+J4)-(C4-F4)","v":200}]
["Veranstaltungen zu sozialen Belangen",2,0,0,{"$f":"D5-C5","v":0},1000,0,{"$f":"F5-G5","v":1000},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":1000},{"$f":"(D5-G5+J5)-(C5-F5)","v":1000}]
["CoCo-Pauschale",null,0,0,0,300,0,300]
["Gesamtsumme:",null,{"$f":"SUM(C3:C6)","v":0},{"$f":"SUM(D3:D6)","v":0},{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":1500},{"$f":"SUM(G3:G6)","v":0},{"$f":"SUM(H3:H6)","v":1500},{"$f":"SUM(I3:I6)","v":200},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":200},{"$f":"SUM(L3:L6)","v":1200},1500]

{"sheet":"Sport","index":15,"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"]
["Tuniere, Preise, Beiträge",null,0,0,{"$f":"D3-C3","v":0},800,0,{"$f":"F3-G3","v":800},1310,{"$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":1310},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":800},{"$f":"(D3-G3+J3)-(C3-F3)","v":800}]
["Startgebühren",1,0,0,0,300,0,300,580,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":580},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":300},{"$f":"(D4-G4+J4)-(C4-F4)","v":300}]
["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,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":150},150]
["Werbung",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,1250,0,1250,{"$f":"SUM(I3:I8)","v":2190},{"$f":"SUM(J3:J8)","v":0},{"$f":"SUM(K3:K8)","v":2190},{"$f":"SUM(L3:L8)","v":1250},1250]

{"sheet":"Studium","index":16,"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},500,0,{"$f":"F5-G5","v":500}]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,500,0,500,{"$f":"SUM(I3:I4)","v":0},{"$f":"SUM(J3:J4)","v":0},{"$f":"SUM(K3:K4)","v":0},{"$f":"SUM(L3:L4)","v":0},500]

{"sheet":"Studentische Verwaltung","index":17,"n_rows":14,"n_cols":13,"rows_kept":14,"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],[13,0,13,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,0,{"$f":"F4-G4","v":50},20,0,{"$f":"IF(OR(J4>I4,H4+I4<0),makro1(),ROUNDDOWN(I4-J4,-1))","v":20},{"$f":"IF(H4>0,ROUNDDOWN(H4,-1),0)","v":50},{"$f":"(D4-G4+J4)-(C4-F4)","v":50}]
["Informationen zu Wahlen",2,0,0,0,150,0,150,300,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":300},150,150]
["Beitrag Gruppenausweis für Jugendherbergen",1,0,0,0,35,0,35,30,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":30},30,35]
["Labeldrucker (für die ISIC-Ausweise)",1,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":0},0,0]
["Vertrieb ISIC",null,300,0,-300,250,0,250,600,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":600},{"$f":"IF(H8>0,ROUNDDOWN(H8,-1),0)","v":250},-50]
["Dienste für elektronische Datenverarbeitung",null,0,0,0,15000,0,15000,0,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":0},15000,15000]
["andauernde Betreuung Server durch Externe",null,0,0,{"$f":"D10-C10","v":0},2400,0,{"$f":"F10-G10","v":2400},0,{"$f":"IF(H10<0,IF(I10>0,IF((H10*(-1))>I10,I10,H10*(-1)),0),0)","v":0},{"$f":"IF(OR(J10>I10,H10+I10<0),makro1(),ROUNDDOWN(I10-J10,-1))","v":0},{"$f":"IF(H10>0,ROUNDDOWN(H10,-1),0)","v":2400},{"$f":"(D10-G10+J10)-(C10-F10)","v":2400}]
["Beiträge/Gebühren",null,0,0,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,460,0,{"$f":"IF(OR(J12>I12,H12+I12<0),makro1(),ROUNDDOWN(I12-J12,-1))","v":460},250,250]
["laufende Kosten für Druck, samt Nebenkosten",null,0,0,0,700,0,700,610,0,{"$f":"IF(OR(J13>I13,H13+I13<0),makro1(),ROUNDDOWN(I13-J13,-1))","v":610},700,700]
["Gesamtsumme:",null,{"$f":"SUM(C3:C13)","v":300},0,-300,18935,0,18935,{"$f":"SUM(I3:I13)","v":2120},{"$f":"SUM(J3:J13)","v":0},{"$f":"SUM(K3:K13)","v":2120},{"$f":"SUM(L3:L13)","v":18930},18635]