{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Hinweise","Deckblatt","Detailblatt I","Detailblatt II","fortgeschr. Mittel+Konto","Kapitalreserve","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":3,"n_cols":2,"rows_kept":3,"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"]

{"sheet":"Deckblatt","index":1,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,0,10,0],[13,4,13,6],[8,0,8,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]]}
["Haushaltsplan 2018 StudentINNENschaft HTW Dresden",null,"Einnahmen",null,null,"Ausgaben"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Selbstverwaltung",null,{"$f":"'Detailblatt I'!J60","v":7250},{"$f":"'Detailblatt I'!K60-'Detailblatt I'!K53+'Detailblatt I'!T53","v":21299.47},{"$f":"D3-C3","v":14049.470000000001},{"$f":"'Detailblatt I'!M60","v":160736},{"$f":"'Detailblatt I'!N60","v":131373.35999999996},{"$f":"(F3-G3)","v":29362.640000000043}]
["Beitragseinnahmen der Studenten",null,{"$f":"'Detailblatt II'!F16","v":154200},{"$f":"'Detailblatt II'!G16","v":151237.5},{"$f":"D4-C4","v":-2962.5},{"$f":"'Detailblatt II'!I16","v":0},{"$f":"'Detailblatt II'!J16","v":3.33},{"$f":"(F4-G4)","v":-3.33}]
["Zinsen",null,{"$f":"'Detailblatt II'!F22","v":0},{"$f":"'Detailblatt II'!G22","v":0},0,{"$f":"'Detailblatt II'!I22","v":0},{"$f":"'Detailblatt II'!J22","v":0},{"$f":"(F5-G5)","v":0}]
["Entnahme(=Einnahme) Ansparen(=Ausgabe)","von Vermögen",{"$f":"'Detailblatt II'!I23","v":737},{"$f":"'Detailblatt II'!J23","v":0},-737,{"$f":"'Detailblatt II'!F23","v":0},{"$f":"'Detailblatt II'!G23","v":0},{"$f":"(F6-G6)","v":0}]
["angeordnete Vermögensänderung lt. FO",null,{"$f":"'Detailblatt II'!F21","v":0},null,0,{"$f":"'Detailblatt II'!I21","v":0},null,{"$f":"(F7-G7)","v":0}]
["Zurückführung an Studenten",null,{"$f":"'Detailblatt I'!R60","v":0},{"$f":"'Detailblatt I'!R60","v":0},{"$f":"D8-C8","v":0}]
["Gesamt:",null,{"$f":"SUM(C3:C8)","v":162187},172536.97,10349.970000000001,160736,131376.68999999994,29359.310000000041]
["Berechnung des Semesterbeitrag:"]
[null,"Planausgaben:",{"$f":"F9","v":160736}]
["-","Planeinnahmen:",{"$f":"C3","v":7250}]
["-","Entnahmen:",{"$f":"C6","v":737}]
["-","angeordnete VÄ Entnahme:",{"$f":"C7","v":0},null,"Letzte Aktualisierung (Datum/Uhrzeit):",null,null,{"$f":"TODAY()","v":"2019-05-17"},{"$f":"NOW()","v":43602.471432986109}]
["-","Zurückführung:",{"$f":"C8","v":0}]
["=","Gesamt:",{"$f":"C11-C12-C13-C14-C15","v":152749}]
["/","Studenten/Jahr:",{"$f":"'Detailblatt II'!D14+('Detailblatt II'!D15/6*4)","v":7466.6666666666661}]
["=","Stud./Semester:",{"$f":"(C16-'Detailblatt II'!F13)/C17","v":18.314598214285716},"Semesterbeitrag pro Student"]

{"sheet":"Detailblatt I","index":2,"n_rows":60,"n_cols":20,"rows_kept":60,"cut":false,"hidden":false,"merged":[[41,19,42,21],[0,18,1,18],[41,18,42,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],[54,9,57,11],[19,1,19,8],[33,1,33,8],[32,1,32,8],[31,1,31,8],[30,1,30,8],[29,1,29,8],[28,1,28,8],[27,1,27,8],[26,1,26,8],[25,1,25,8],[24,1,24,8],[41,9,42,11],[51,9,51,11],[42,0,42,4],[50,1,50,4],[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],[41,15,42,15],[41,16,42,16],[41,17,42,17],[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],[20,0,20,8],[34,0,34,8],[39,0,39,8],[4,12,4,14],[0,9,0,11],[0,12,0,14],[0,15,1,15],[0,17,1,17],[5,1,9,1],[12,1,12,8],[11,1,11,8],[38,1,38,8],[10,1,10,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],[9,2,9,8],[17,1,17,8],[16,1,16,8],[15,1,15,8],[14,1,14,8],[5,2,5,8],[7,12,9,12],[8,2,8,8],[7,2,7,8],[6,2,6,8],[42,12,42,14],[41,12,41,13],[22,1,22,8],[13,1,13,8],[23,1,23,8],[48,7,48,8],[48,5,48,6],[18,1,18,8],[43,5,43,6],[42,7,42,8],[42,5,42,6],[36,1,36,8],[37,1,37,8],[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]]}
["Detailblatt I",null,null,null,"Jahr -",2018,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"]
["Sachkonto"]
["2749","Angestellte","AAG",null,null,null,null,null,null,null,495.23,{"$f":"K6","v":495.23}]
["4120",null,"Gehälter",null,null,null,null,null,null,null,null,null,68250,56371.66,{"$f":"M7-SUM(N7:N10)+L6","v":-350.32999999999765}]
["4130",null,"gesetzl. sozial. Aufw.",null,null,null,null,null,null,null,null,null,null,11983.68]
["4138",null,"Beitrag BG",null,null,null,null,null,null,null,null,null,null,93.34]
["4956",null,"Acon GmbH (Lohnabr.)",null,null,null,null,null,null,null,null,null,null,646.88]
["4110","(AE) Aufwandsentschädigungen",null,null,null,null,null,null,null,null,null,null,18000,7229.34,{"$f":"M11-N11","v":10770.66}]
["4640","Kaffee & Verpflegung",null,null,null,null,null,null,null,null,null,null,1500,987.52,512.48]
["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,500,195.2,304.8,0,{"$f":"IF(O14<0,IF(P14>0,O14*(-1),0),0)","v":0},{"$f":"IF(OR(Q14>P14,O14+P14<0),makro1(),ROUNDDOWN(P14-Q14,-1))","v":0},{"$f":"IF(O14>0,ROUNDDOWN(O14,-1),0)","v":300}]
["4943","Teilnahme Konferenzen",null,null,null,null,null,null,null,null,null,null,1500,758.3,741.7,0,{"$f":"IF(O15<0,IF(P15>0,O15*(-1),0),0)","v":0},{"$f":"IF(OR(Q15>P15,O15+P15<0),makro1(),ROUNDDOWN(P15-Q15,-1))","v":0},{"$f":"IF(O15>0,ROUNDDOWN(O15,-1),0)","v":740}]
["4944","Teilnahme Schulungen",null,null,null,null,null,null,null,null,null,null,500,135,365,0,{"$f":"IF(O16<0,IF(P16>0,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":360}]
["4945","Durchführung Konferenzen",null,null,null,null,null,null,null,null,null,null,{"$f":"'Schulungen & Konferenzen'!F19","v":3000},{"$f":"'Schulungen & Konferenzen'!G19","v":1000},2000,null,null,{"$f":"'Schulungen & Konferenzen'!K19","v":0},{"$f":"'Schulungen & Konferenzen'!L19","v":1500}]
["4946","Durchführung Schulungen",null,null,null,null,null,null,null,null,null,null,{"$f":"'Schulungen & Konferenzen'!F12","v":4000},{"$f":"'Schulungen & Konferenzen'!G12","v":419.33},3580.67,null,null,{"$f":"'Schulungen & Konferenzen'!K12","v":0},{"$f":"'Schulungen & Konferenzen'!L12","v":3300}]
["4950","Rechts- und Beratungskosten",null,null,null,null,null,null,null,null,null,null,500,0,500,0,{"$f":"IF(O19<0,IF(P19>0,O19*(-1),0),0)","v":0},{"$f":"IF(OR(Q19>P19,O19+P19<0),makro1(),ROUNDDOWN(P19-Q19,-1))","v":0},{"$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,3012.75,987.25,0,{"$f":"IF(O20<0,IF(P20>0,O20*(-1),0),0)","v":0},{"$f":"IF(OR(Q20>P20,O20+P20<0),makro1(),ROUNDDOWN(P20-Q20,-1))","v":0},{"$f":"IF(O20>0,ROUNDDOWN(O20,-1),0)","v":980}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6)","v":495.23},{"$f":"SUM(L6)","v":495.23},{"$f":"SUM(M6:M20)","v":101750},{"$f":"SUM(N6:N20)","v":82833},{"$f":"SUM(O6:O20)","v":19412.230000000003},{"$f":"SUM(P15:P16,P19:P20)","v":0},{"$f":"SUM(Q15:Q16,Q19:Q20)","v":0},{"$f":"SUM(R15:R20)","v":0},{"$f":"SUM(S14:S20)","v":7680}]
["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":1376.42},{"$f":"M23-N23","v":23.579999999999927}]
[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":3500},{"$f":"Hochschulpolitik!G8","v":500},3000,null,null,{"$f":"Hochschulpolitik!K8","v":0},{"$f":"Hochschulpolitik!L8","v":3000}]
[4962,"Internationales",null,null,null,null,null,null,null,{"$f":"Internationales!C6","v":0},{"$f":"Internationales!D6","v":0},0,{"$f":"Internationales!F6","v":1050},{"$f":"Internationales!G6","v":85.18},964.81999999999994,null,null,{"$f":"Internationales!K6","v":0},{"$f":"Internationales!L6","v":960}]
[4963,"Kultur",null,null,null,null,null,null,null,{"$f":"Kultur!C10","v":6350},{"$f":"Kultur!D10","v":6595.55},245.55000000000018,{"$f":"Kultur!F10","v":16000},{"$f":"Kultur!G10","v":10586.95},5413.0499999999993,null,null,{"$f":"Kultur!K10","v":0},{"$f":"Kultur!L10","v":5440}]
[4964,"Öffentlichkeitsarbeit",null,null,null,null,null,null,null,{"$f":"Öffentlichkeitsarbeit!C8","v":600},{"$f":"Öffentlichkeitsarbeit!D8","v":464},-136,{"$f":"Öffentlichkeitsarbeit!F8","v":4700},{"$f":"Öffentlichkeitsarbeit!G8","v":3031.2799999999997},1668.7200000000003,null,null,{"$f":"Öffentlichkeitsarbeit!K8","v":0},{"$f":"Öffentlichkeitsarbeit!L8","v":1660}]
[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,null,null,{"$f":"Qualitätsmanagement!K4","v":0},{"$f":"Qualitätsmanagement!L4","v":0}]
[4966,"Soziales",null,null,null,null,null,null,null,{"$f":"Soziales!C6","v":0},{"$f":"Soziales!D6","v":0},0,{"$f":"Soziales!F6","v":1500},{"$f":"Soziales!G6","v":1000},500,null,null,{"$f":"Soziales!K6","v":0},{"$f":"Soziales!L6","v":200}]
[4967,"Sport",null,null,null,null,null,null,null,{"$f":"Sport!C9","v":0},{"$f":"Sport!D9","v":0},0,{"$f":"Sport!F9","v":2400},{"$f":"Sport!G9","v":239.67},2160.33,null,null,{"$f":"Sport!K9","v":0},{"$f":"Sport!L9","v":2150}]
[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,null,null,{"$f":"Studium!K6","v":0},{"$f":"Studium!L6","v":0}]
[4969,"Studentische Selbstverwaltung & Organisation",null,null,null,null,null,null,null,{"$f":"'Studentische Verwaltung'!C12","v":300},{"$f":"'Studentische Verwaltung'!D12","v":270},-30,{"$f":"'Studentische Verwaltung'!F12","v":2585},{"$f":"'Studentische Verwaltung'!G12","v":564.83000000000004},2020.17,null,null,{"$f":"'Studentische Verwaltung'!K12","v":0},{"$f":"'Studentische Verwaltung'!L12","v":1990}]
[null,"Ausschüsse des Studentinnen- und Studentenrates",null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!F9","v":0},{"$f":"'Detailblatt II'!G9","v":0},0,0,0,0]
[null,"weitere Vertretungen",null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!F10","v":0},{"$f":"'Detailblatt II'!G10","v":0},0,0,{"$f":"'Detailblatt II'!J10","v":0},0]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J23:J34)","v":7250},7329.55,79.550000000000182,34135,{"$f":"SUM(N23:N34)","v":17384.330000000002},16750.669999999998,null,null,{"$f":"SUM(R24:R32)","v":0},{"$f":"SUM(S24:S32)","v":15400}]
["Ausschüsse der Studentinnen- und Studentenschaft"]
[null,"weitere Ausschüsse der Studentinnen- und Studentenschaft",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M37-N37","v":0}]
[null,"Wahlausschuss der Studentinnen- und Studentenschaft",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M38-N38","v":0}]
[4959,"(HFA) Härtefallausschuss der Studentinnen- & Studentenschaft",null,null,null,null,null,null,null,null,null,null,3000,1418.9,{"$f":"M39-N39","v":1581.1}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M37:M39)","v":3000},{"$f":"SUM(N37:N39)","v":1418.9},{"$f":"SUM(O37:O39)","v":1581.1}]
["Fachschaftsräte"]
["Anzahl der StudentINNen im:",null,null,null,null,"WiSe","18/19","SoSe",2018,null,null,null,"Sockelbetrag für FSR:",null,250,"vorraus. vorh. Geldmittel zum Vorjahresende","finanzielle Reserve zum Jahresbeginn","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr","Korrekturrechnung der Einnahmen abzgl. Semesterbeiträge"]
["gesamt:",null,null,null,null,{"$f":"SUM(F44:G51)","v":4809},null,{"$f":"SUM(H44:I51)","v":4330},null,null,null,null,"Geld was den FSR \"zugeschrieben\" wird."]
["4901","Bauingenieurwesen/Architektur",null,null,null,507,null,485,null,null,3367.93,{"$f":"K44-J44","v":3367.93},{"$f":"ROUND(($O$42*2)+((F44+H44)*$D$52),-2)","v":1200},3359.14,{"$f":"M44-N44","v":-2159.14},{"$f":"944.38+4362.19-88.35-192.64-5+21","v":5041.579999999999},null,null,{"$f":"P44+K44-N44","v":5050.369999999999},{"$f":"K44-1010.5-574","v":1783.4299999999998}]
["4902","Elektrotechnik",null,null,null,545,null,469,null,null,6201.29,{"$f":"K45-J45","v":6201.29},{"$f":"ROUND(($O$42*2)+((F45+H45)*$D$52),-2)","v":1300},5689.47,{"$f":"M45-N45","v":-4389.47},4484.04,null,null,4995.8599999999997,{"$f":"K45-1067.5-597.25","v":4536.54}]
["4903","Landbau/Landespflege/Chemie",null,null,null,734,null,650,null,null,4021.95,4021.95,1500,3950.18,-2450.1799999999998,3987.9,null,null,4059.6700000000005,{"$f":"K46-1351-727.75","v":1943.1999999999998}]
["4904","Informatik/Mathematik",null,null,null,682,null,583,null,null,2124.14,2124.14,1400,1246.68,153.31999999999994,7333.31,null,null,8210.77,{"$f":"K47-1273-699.25","v":151.88999999999987}]
["4905","Maschinenbau",null,null,null,726,null,667,null,null,3546.14,3546.14,1500,3004.24,-1504.2399999999998,4999.37,null,null,5541.27,{"$f":"K48-1339-723.25","v":1483.8899999999999}]
["4906","Geoinformation",null,null,null,346,null,315,null,null,{"$f":"1232.58+769+480.25","v":2481.83},2481.83,1000,1943.34,-943.33999999999992,3209.8,null,null,3748.29,{"$f":"K49-769-480.25","v":1232.58}]
["4907","Wirtschaftswissenschaften",null,null,null,1187,null,1072,null,null,5403.66,5403.66,2200,5093.59,-2893.59,6866.28,null,null,7176.3499999999985,{"$f":"K50-2030.5-1030","v":2343.16}]
["4908","Gestaltung",null,null,null,82,null,89,null,null,1065,1065,600,739.06,-139.05999999999995,2398.9499999999998,null,null,2724.89,{"$f":"K51-383.5-373-308.5","v":0}]
["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":4600},0,4600,0,{"$f":"IF(O52<0,IF(P52>0,O52*(-1),0),0)","v":0},{"$f":"IF(OR(Q52>P52,O52+P52<0),makro1(),ROUNDDOWN(P52-Q52,-1))","v":0},{"$f":"IF(O52>0,ROUNDDOWN(O52,-1),0)","v":4600}]
["Zwischensumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J44:J51)","v":0},{"$f":"SUM(K44:K51)","v":28211.94},{"$f":"SUM(L44:L51)","v":28211.94},{"$f":"SUM(M44:M52)","v":15300},{"$f":"SUM(N44:N52)","v":25025.7},{"$f":"SUM(O44:O52)","v":-9725.7000000000007},{"$f":"SUM(P44:P51)","v":38321.229999999996},{"$f":"SUM(Q44:Q51)","v":0},{"$f":"SUM(R44:R51)","v":0},{"$f":"SUM(S44:S52)","v":46107.47},{"$f":"SUM(T44:T51)","v":13474.689999999997}]
["Vertretungen der Studentinnen und Studenten"]
[null,"Vertretungen der Studentinnen und Studenten in der Hochschule",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M55-N55","v":0}]
[null,"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":1520.49},{"$f":"M56-N56","v":479.51}]
[null,"Interessenvertretungen der Studentinnen- und Studentenschaft ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailblatt II'!I11","v":4201},{"$f":"'Detailblatt II'!J11","v":3190.94},{"$f":"M57-N57","v":1010.06}]
[null,"weitere Interessenvertetungen",null,null,null,null,null,null,null,null,null,null,350,null,{"$f":"M58-N58","v":350}]
["Zwischensumme:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M55:M58)","v":6551},{"$f":"SUM(N55:N58)","v":4711.43},{"$f":"SUM(O55:O58)","v":1839.57},"ohne die FSR Budget`s"]
["Gesamtsumme:",null,null,null,null,null,null,null,null,{"$f":"SUM(J23:J34,J37:J39,J44:J51,J55:J58)","v":7250},{"$f":"SUM(K6,K23:K34,K37:K39,K44:K51,K55:K58)","v":36036.720000000001},{"$f":"SUM(L6,L23:L34,L37:L39,L44:L51,L55:L58)","v":28786.719999999998},{"$f":"SUM(M6:M20,M23:M34,M37:M39,M44:M52,M55:M58)","v":160736},{"$f":"SUM(N6:N20,N23:N34,N37:N39,N44:N52,N55:N58)","v":131373.35999999996},{"$f":"SUM(O6:O20,O23:O34,O37:O39,O44:O51,O55:O58)","v":25257.87},{"$f":"P21","v":0},{"$f":"Q21","v":0},{"$f":"R21+R35+R53","v":0},{"$f":"SUM(S53,S35,S21)","v":69187.47}]

{"sheet":"Detailblatt II","index":3,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,0,3,3],[4,0,4,3],[18,0,18,4],[0,8,0,10],[0,2,1,3],[0,0,1,0],[0,4,1,4],[0,1,1,1],[0,5,0,7],[17,0,17,4],[24,0,24,4],[23,3,23,4],[15,3,15,4],[10,3,10,4],[5,3,5,4],[12,2,14,2],[21,0,21,3],[22,0,22,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[19,0,19,4],[20,0,20,4]]}
["Detailblatt II","Jahr -",{"$f":"'Detailblatt I'!F1","v":2018},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,null,{"$f":"G4-F4","v":0},1350,1193.5,{"$f":"I4-J4","v":156.5}]
["Förderung der KSS (so auch Domain kss-sachsen.de)",null,null,null,1,0,null,{"$f":"G5-F5","v":0},650,{"$f":"322.34+4.65","v":326.98999999999995},{"$f":"I5-J5","v":323.01000000000005}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F4:F5)","v":0},0,0,2000,1520.49,479.51000000000005]
["Interessenvertretungen der Studentinnen- und Studentenschaften"]
["faranto e.V.",null,null,null,null,0,null,{"$f":"G8-F8","v":0},600,514.44000000000005,{"$f":"I8-J8","v":85.559999999999945}]
["freier zusammenschluss von studentInnenschaften (fzs) e.V.",null,null,null,1,0,null,{"$f":"G9-F9","v":0},3600,2676.5,{"$f":"I9-J9","v":923.5}]
["weitere",null,null,null,null,0,null,{"$f":"G10-F10","v":0},1,0,{"$f":"I10-J10","v":1}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F8:F10)","v":0},0,0,4201,3190.94,1010.06]
["Beitragseinnahmen"]
["Anteilig WS 17/18",10,"x Studenten",{"$f":"'Detailblatt I'!F43","v":4809},1,{"$f":"ROUND((($B$13*$D$13)/6)*2,-2)","v":16000},16033.33,{"$f":"G13-F13","v":33.329999999999927},0,3.33,{"$f":"I13-J13","v":-3.33}]
["SoSe 18",18.5,null,4300,1,{"$f":"ROUND($B$14*$D$14,-2)","v":79600},77459.5,{"$f":"G14-F14","v":-2140.5},0,0,{"$f":"I14-J14","v":0}]
["Anteilig WS 18/19",18.5,null,4750,1,{"$f":"ROUND((($B$15*$D$15)/6)*4,-2)","v":58600},57744.67,{"$f":"G15-F15","v":-855.33000000000175},0,0,{"$f":"I15-J15","v":0}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F13:F15)","v":154200},151237.5,-2962.5000000000018,0,3.33,-3.33]
["Vermögen"]
["Verfügbare finanzielle Reserven",null,null,null,null,{"$f":"'fortgeschr. Mittel+Konto'!D7","v":149812.53},null,{"$f":"G18-F18","v":-149812.53},0,0,{"$f":"I18-J18","v":0}]
["Fortgeschriebene finanzielle Mittel",null,null,null,null,{"$f":"'Detailblatt I'!R60","v":0},null,0]
["Übertrag ins nächste HH-Jahr",null,null,null,null,{"$f":"'Detailblatt I'!S60","v":69187.47},null,-69187.47]
["angeordnete Vermögensänderung lt. FO",null,null,null,null,{"$f":"IF(F18>F16,F18-F16,0)","v":0},null,0,{"$f":"IF(F18<Kapitalreserve!D17,Kapitalreserve!D17-F18,0)","v":0},null,{"$f":"I21-J21","v":0}]
["Zinsen auf Vermögen",null,null,null,null,0,0,0,0,0,{"$f":"I22-J22","v":0}]
["geplante Veränderung des Vermögens",null,null,null,null,0,0,0,737,0,{"$f":"I23-J23","v":737}]
[null,null,null,"Zwischensumme:",null,{"$f":"SUM(F18:F23)","v":219000},0,-219000,737,0,737]
["Gesamtsumme:",null,null,null,null,{"$f":"SUM(F16,F11,F6)","v":154200},{"$f":"SUM(G16,G11,G6)","v":151237.5},-2962.5000000000018,{"$f":"SUM(I16,I11,I6)","v":6201},4714.76,1486.24]

{"sheet":"fortgeschr. Mittel+Konto","index":4,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,8,16,8],[15,6,16,7],[15,5,16,5],[19,6,19,7],[18,6,18,7],[17,6,17,7],[4,5,5,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],[21,6,21,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[14,6,14,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[20,6,20,7]]}
["Fortgeschriebene finanzielle Mittel + Bankkontostand",null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2018}]
[null,null,null,null,null,"Nr.","voraussichtliche Ausgaben",null,"Saldo"]
[null,"Zweck/Tätigkeit","erstellt am:","Saldo",null,"1.","Personal (Nov.+Dez. inkl. 13.Gehalt, ACON-Gebühren)",null,1000]
[null,"Bankkontostand bei Haushaltsplanerstellung",null,220000]
["-","abzgl. voraussichtliche Ausgaben",null,{"$f":"I22*(-1)","v":-1000},null,"2.","Finanzbeschlüsse aktuell noch nicht umgesetzt"]
["-","Übertrag ins nächste HH-Jahr",null,{"$f":"'Detailblatt I'!S60","v":69187.47}]
["=","ins nächste Jahr zu übernehmen",null,{"$f":"D4+D5-D6","v":149812.53},null,"3.","voraussichtliche AE"]
[null,null,null,null,null,"4.","offene Härtefallanträge"]
[null,null,null,null,null,"5.","Software-Abos (AGENDA etc.)"]
[null,null,null,null,null,"6.","Kosten für Wartung (Drucker etc.)"]
[null,null,null,null,null,"7.","Kontoführung"]
[null,null,null,null,null,"8.","Kino in der HTW & Co."]
[null,null,null,null,null,"9.","Kosten für Wahlen"]
[null,null,null,null,null,"10.","Kaffeebestellung(en)"]
[null,null,null,null,null,"11.","Ersatz- & Neuanschaffung"]
[null,null,null,null,null,"12.","wahrscheinlich noch zu beschließende Finanzanträge "]
[]
[null,null,null,null,null,"13."]
[null,null,null,null,null,"14."]
[null,null,null,null,null,"15."]
[null,null,null,null,null,"16."]
[null,null,null,null,null,"=","Gesamtsumme:",null,{"$f":"SUM(I3:I21)","v":1000}]

{"sheet":"Kapitalreserve","index":5,"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]]}
["Mindestkapitalreserve",null,null,"Jahr -",{"$f":"'Detailblatt I'!F1","v":2018},"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":68250}]
["…aktuell ohne Belegung…"]
["…aktuell ohne Belegung…"]
["Referat Finanzen"]
["Kontoführungsgebühren",null,null,{"$f":"Finanzen!G3","v":400}]
["Buchhaltungssoftware AGENDA",null,null,{"$f":"Finanzen!G4","v":1000}]
["…aktuell ohne Belegung…"]
["Referat Selbstverwaltung & Organisation"]
["Domains",null,null,{"$f":"'Studentische Verwaltung'!F4","v":50}]
["laufende Kosten (Druck, Wartung)",null,null,{"$f":"'Studentische Verwaltung'!F11","v":1000}]
["…aktuell ohne Belegung…"]
["…aktuell ohne Belegung…"]
["Gesamt:",null,null,{"$f":"SUM(D5:E7,D9:E11,D13:E16)","v":70700}]

{"sheet":"Schulungen & Konferenzen","index":6,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,9,14,9],[13,10,14,10],[10,8,10,11],[13,11,14,11],[17,8,17,11],[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]]}
["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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Akkreditierung / Qualitätsmanagement",2,0,0,{"$f":"D3-C3","v":0},900,0,{"$f":"F3-G3","v":900},0,{"$f":"IF(H3<0,IF(I3>0,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":900}]
["Sozialberatung (BaföG, Jobberatung) / Soziales",1,0,0,{"$f":"D4-C4","v":0},300,0,{"$f":"F4-G4","v":300},0,{"$f":"IF(H4<0,IF(I4>0,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":300}]
["Schulungen studentische und akademische\nSelbstverwaltung (Studienprüfungsordnung) / Studium",1,0,0,0,400,0,400,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},400]
["Prüfungsangelegenheiten / Studium",1,0,0,0,300,0,300,0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},300]
["pol. Bildung, Antidiskriminierung, Gender- / Hochschulpolitik",1,0,0,0,300,0,300,0,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":0},300]
["Konstituierungsseminar (KoSe) / StuRa",1,0,0,0,1000,399.25,600.75,0,0,{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":0},600]
["Lern- und Informationsseminar (LuISe) / StuRa",1,0,0,0,400,0,400,0,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":0},400]
["CLearance And Rapprochement (CLARA) / StuRa",1,0,0,0,100,0,100,0,0,{"$f":"IF(OR(J10>I10,H10+I10<0),makro1(),ROUNDDOWN(I10-J10,-1))","v":0},100]
["Quod licet Iovi, non licet bovi",1,0,0,0,300,20.079999999999998,279.92]
["Gesamtsumme:",null,{"$f":"SUM(C3:C11)","v":0},0,0,4000,419.33,3580.67,{"$f":"SUM(I3:I10)","v":0},{"$f":"SUM(J3:J10)","v":0},{"$f":"SUM(K3:K10)","v":0},{"$f":"SUM(L3:L10)","v":3300}]
[]
["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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["O.S.T. (Bereich Bund/Land) / Hochschulpolitik",1,0,0,{"$f":"D16-C16","v":0},1500,0,{"$f":"F16-G16","v":1500},0,{"$f":"IF(H16<0,IF(I16>0,H16*(-1),0),0)","v":0},{"$f":"IF(OR(J16>I16,H16+I16<0),makro1(),ROUNDDOWN(I16-J16,-1))","v":0},{"$f":"IF(H16>0,ROUNDDOWN(H16,-1),0)","v":1500}]
["BuFaTa / FSR",0.5,0,0,{"$f":"D17-C17","v":0},1000,1000,{"$f":"F17-G17","v":0},0,0,{"$f":"IF(OR(J17>I17,H17+I17<0),makro1(),ROUNDDOWN(I17-J17,-1))","v":0},0]
["Quod licet Iovi, non licet bovi",1,0,0,{"$f":"D18-C18","v":0},500,0,{"$f":"F18-G18","v":500}]
["Gesamtsumme:",null,{"$f":"SUM(C16:C18)","v":0},0,0,3000,1000,2000,{"$f":"SUM(I16:I17)","v":0},{"$f":"SUM(J16:J17)","v":0},{"$f":"SUM(K16:K17)","v":0},{"$f":"SUM(L16:L17)","v":1500}]

{"sheet":"Finanzen","index":7,"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,391.1,{"$f":"G3-H3","v":8.8999999999999773}]
["Buchhaltungssoftware AGENDA","Sachkonto: 4955",12,0,0,{"$f":"E4-D4","v":0},1000,985.32,{"$f":"G4-H4","v":14.67999999999995}]
["Gesamtsumme:",null,null,{"$f":"SUM(D3:D4)","v":0},0,0,1400,1376.42,23.579999999999927]

{"sheet":"Hochschulpolitik","index":8,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["\"festival contre le rasism\"",1,0,0,{"$f":"D3-C3","v":0},550,0,{"$f":"F3-G3","v":550},0,{"$f":"IF(H3<0,IF(I3>0,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":550}]
["Aktionstage gegen Sexismus und Homophobie",1,0,0,{"$f":"D4-C4","v":0},550,0,{"$f":"F4-G4","v":550},0,{"$f":"IF(H4<0,IF(I4>0,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":550}]
["Aktionen, Festivals und Demonstrationen",null,0,0,{"$f":"D5-C5","v":0},750,0,{"$f":"F5-G5","v":750},0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},750]
["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]
["politische Bildung / Umweltbildung",null,0,0,{"$f":"D7-C7","v":0},1500,350,{"$f":"F7-G7","v":1150},0,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":0},1150]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":0},0,0,3500,500,3000,0,0,0,3000]

{"sheet":"Internationales","index":9,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,5,0,7],[5,0,5,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,8,1,8]]}
["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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Erasmus Student Network",null,0,0,{"$f":"D3-C3","v":0},500,0,{"$f":"F3-G3","v":500},0,{"$f":"IF(H3<0,IF(I3>0,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":500}]
["DAAD Mitgliedsbeitrag",1,0,0,{"$f":"D4-C4","v":0},50,50,{"$f":"F4-G4","v":0},0,{"$f":"IF(H4<0,IF(I4>0,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":0}]
["Internationaler Tag",2,0,0,{"$f":"D5-C5","v":0},500,35.18,{"$f":"F5-G5","v":464.82},0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},460]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,1050,85.18,964.81999999999994,{"$f":"SUM(I3:I5)","v":0},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":0},{"$f":"SUM(L3:L5)","v":960}]

{"sheet":"Kultur","index":10,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Semestereröffnungsparty (SEP)",2,2000,2116,{"$f":"D3-C3","v":116},3000,560.35,{"$f":"F3-G3","v":2439.65},0,{"$f":"IF(H3<0,IF(I3>0,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":2430}]
["Kino in der Hochschule",null,550,1166,616,1200,928.07,271.92999999999995,0,{"$f":"IF(H4<0,IF(I4>0,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":270}]
["Rock am Pavillon (Erstival 2018)",1,1000,0,-1000,2650,1203.48,1446.52,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},1440]
["Dies Academicus",1,0,0,0,350,350,0,0,{"$f":"IF(H6<0,IF(I6>0,H6*(-1),0),0)","v":0},{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},{"$f":"IF(H6>0,ROUNDDOWN(H6,-1),0)","v":0}]
["LAN-Partys",2,300,433.09,133.08999999999997,800,234.97,565.03,0,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":0},560]
["Zuschuss SEP FSR",null,0,0,0,0,59.4,-59.4,0,{"$f":"IF(H8<0,IF(I8>0,H8*(-1),0),0)","v":0},{"$f":"IF(OR(J8>I8,H8+I8<0),makro1(),ROUNDDOWN(I8-J8,-1))","v":0},0]
["Erstsemestereinführung (ESE) durch StuRa",1,2500,2880.46,380.46000000000004,8000,7250.68,749.31999999999971,0,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":0},740]
["Gesamtsumme:",null,{"$f":"SUM(C3:C9)","v":6350},6595.55,245.55,16000,{"$f":"SUM(G3:G9)","v":10586.95},5413.05,{"$f":"SUM(I3:I9)","v":0},{"$f":"SUM(J3:J9)","v":0},{"$f":"SUM(K3:K9)","v":0},{"$f":"SUM(L3:L9)","v":5440}]

{"sheet":"Öffentlichkeitsarbeit","index":11,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Druck Hochschul-ABC (Anteilig)",1,0,0,{"$f":"D3-C3","v":0},833,833,{"$f":"F3-G3","v":0},0,{"$f":"IF(H3<0,IF(I3>0,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}]
["Hochschulveranstaltungen",null,0,0,{"$f":"D4-C4","v":0},0,0,{"$f":"F4-G4","v":0},0,{"$f":"IF(H4<0,IF(I4>0,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":0}]
["Werbemittel",null,0,0,{"$f":"D5-C5","v":0},1822,478.74,{"$f":"F5-G5","v":1343.26},0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},1340]
["Interessiertengrillen",2,0,0,{"$f":"D6-C6","v":0},245,244.42,{"$f":"F6-G6","v":0.58000000000001251},0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},0]
["Merchandise",null,600,464,{"$f":"D7-C7","v":-136},1800,1475.12,{"$f":"F7-G7","v":324.88000000000011},0,0,{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":0},320]
["Gesamtsumme:",null,{"$f":"SUM(C3:C7)","v":600},464,-136,4700,3031.2799999999997,1668.72,{"$f":"SUM(I3:I7)","v":0},{"$f":"SUM(J3:J7)","v":0},{"$f":"SUM(K3:K7)","v":0},{"$f":"SUM(L3:L7)","v":1660}]

{"sheet":"Qualitätsmanagement","index":12,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[[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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Quod licet Iovi, non licet bovi",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}]

{"sheet":"Soziales","index":13,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[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 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"]
[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,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}]
["Studenten gegen Blutkrebs AIAS Dresden e.V.",null,0,0,{"$f":"D4-C4","v":0},1000,1000,{"$f":"F4-G4","v":0},0,{"$f":"IF(H4<0,IF(I4>0,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":0}]
["Quod licet Iovi, non licet bovi",null,0,0,0,300,0,300]
["Gesamtsumme:",null,{"$f":"SUM(C3:C5)","v":0},0,0,1500,1000,500,{"$f":"SUM(I3:I5)","v":0},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":0},{"$f":"SUM(L3:L5)","v":200}]

{"sheet":"Sport","index":14,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Tuniere, Preise, Beiträge",null,0,0,{"$f":"D3-C3","v":0},1500,227.67,{"$f":"F3-G3","v":1272.33},0,{"$f":"IF(H3<0,IF(I3>0,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":1270}]
["Startgebühren",1,0,0,0,600,12,588,0,{"$f":"IF(H4<0,IF(I4>0,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":580}]
["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]
["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]
["Hochschulsportfest",1,0,0,0,300,0,300,0,{"$f":"IF(H7<0,IF(I7>0,H7*(-1),0),0)","v":0},{"$f":"IF(OR(J7>I7,H7+I7<0),makro1(),ROUNDDOWN(I7-J7,-1))","v":0},{"$f":"IF(H7>0,ROUNDDOWN(H7,-1),0)","v":300}]
["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]
["Gesamtsumme:",null,{"$f":"SUM(C3:C8)","v":0},0,0,2400,239.67,2160.33,{"$f":"SUM(I3:I8)","v":0},{"$f":"SUM(J3:J8)","v":0},{"$f":"SUM(K3:K8)","v":0},{"$f":"SUM(L3:L8)","v":2150}]

{"sheet":"Studium","index":15,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[5,0,5,1],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[4,8,4,11]]}
["Referat Studium","Häufigkeit","Einnahmen",null,null,"Ausgaben",null,null,"nachrangig verwendbares Vj. Budget","davon verwendet","Zuführung \"Fortgeschr. finanz. Mittel\"","Übertrag ins nächste HH-Jahr"]
[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,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}]
["Systemakkreditierung, was nun?",null,0,0,{"$f":"D4-C4","v":0},0,0,{"$f":"F4-G4","v":0},0,{"$f":"IF(H4<0,IF(I4>0,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":0}]
["Quod licet Iovi, non licet bovi",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}]

{"sheet":"Studentische Verwaltung","index":16,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[11,0,11,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"]
[null,null,"PLAN","IST","SALDO","PLAN","IST","SALDO"]
["Telefon",null,0,0,{"$f":"D3-C3","v":0},100,0,{"$f":"F3-G3","v":100},0,{"$f":"IF(H3<0,IF(I3>0,H3*(-1),0),0)","v":0},{"$f":"IF(OR(J3>I3,H3+I3<0),makro1(),ROUNDDOWN(I3-J3,-1))","v":0},{"$f":"IF(H3>0,ROUNDDOWN(H3,-1),0)","v":100}]
["Domains",null,0,0,{"$f":"D4-C4","v":0},50,23.25,{"$f":"F4-G4","v":26.75},0,{"$f":"IF(H4<0,IF(I4>0,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":20}]
["Werbung für Wahlen",2,0,0,0,300,0,300,0,0,{"$f":"IF(OR(J5>I5,H5+I5<0),makro1(),ROUNDDOWN(I5-J5,-1))","v":0},300]
["Beitrag Gruppenausweis für Jugendherbergen",1,0,0,0,35,26,9,0,0,{"$f":"IF(OR(J6>I6,H6+I6<0),makro1(),ROUNDDOWN(I6-J6,-1))","v":0},0]
["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]
["ISIC",null,300,270,-30,600,0,600,0,{"$f":"IF(H8<0,IF(I8>0,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":600}]
["Beiträge/Gebühren",null,0,0,0,0,0,0,0,0,{"$f":"IF(OR(J9>I9,H9+I9<0),makro1(),ROUNDDOWN(I9-J9,-1))","v":0},0]
["Büromaterial/-ausstattung",null,0,0,0,500,53.15,446.85,0,0,{"$f":"IF(OR(J10>I10,H10+I10<0),makro1(),ROUNDDOWN(I10-J10,-1))","v":0},440]
["laufende Kosten (Druck, Wartung)",null,0,0,0,1000,462.43,537.56999999999994,0,0,{"$f":"IF(OR(J11>I11,H11+I11<0),makro1(),ROUNDDOWN(I11-J11,-1))","v":0},530]
["Gesamtsumme:",null,{"$f":"SUM(C3:C11)","v":300},270,-30,2585,564.83000000000004,2020.1699999999998,{"$f":"SUM(I3:I11)","v":0},{"$f":"SUM(J3:J11)","v":0},{"$f":"SUM(K3:K11)","v":0},{"$f":"SUM(L3:L11)","v":1990}]