{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Übersicht Verbrauchsmaterial","Übersicht Reisekosten","AZA Jahr 1","AZA Jahr 2","AZA Jahr 3","Ausgabebedarf"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Übersicht Verbrauchsmaterial","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,8,4,10],[26,2,26,3],[11,2,12,2],[11,3,12,3],[1,6,1,7],[2,8,2,10],[11,5,12,5],[11,6,11,8],[11,4,12,4],[11,9,12,9],[6,7,6,10]]}
[]
[null,null,"Übersicht Ausgabenermittlung zum Arbeits-, Zeit- und Ausgabenplan: "]
[]
[]
[]
[{"$nulls":7},"Antragsteller/in"]
[]
[null,null,"Verbrauchsmaterial"]
[]
[]
[]
[null,null,"Arbeits-paket","Bezeichnung","Anzahl","Einzelpreis",null,null,null,"Gesamt"]
[{"$nulls":6},2023,2024,2025]
[{"$nulls":9},{"$f":"SUM(G14:I14)","v":0}]
[{"$nulls":9},{"$f":"SUM(G15:I15)","v":0}]
[{"$nulls":9},{"$f":"SUM(G16:I16)","v":0}]
[{"$nulls":9},{"$f":"SUM(G17:I17)","v":0}]
[{"$nulls":9},{"$f":"SUM(G18:I18)","v":0}]
[{"$nulls":9},{"$f":"SUM(G19:I19)","v":0}]
[{"$nulls":9},{"$f":"SUM(G20:I20)","v":0}]
[{"$nulls":9},{"$f":"SUM(G21:I21)","v":0}]
[{"$nulls":9},{"$f":"SUM(G22:I22)","v":0}]
[{"$nulls":9},{"$f":"SUM(G23:I23)","v":0}]
[{"$nulls":9},{"$f":"SUM(G24:I24)","v":0}]
[{"$nulls":9},{"$f":"SUM(G25:I25)","v":0}]
[{"$nulls":9},{"$f":"SUM(G26:I26)","v":0}]
[null,null,"Summe Sachausgaben:",null,null,null,{"$f":"SUM(G14:G26)","v":0},{"$f":"SUM(H14:H26)","v":0},{"$f":"SUM(I14:I26)","v":0},{"$f":"SUM(G27:I27)","v":0}]

{"sheet":"Übersicht Reisekosten","index":1,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,2,26,3],[1,6,1,7],[2,8,2,10],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,11,8],[11,9,12,9],[6,7,6,10],[4,8,4,10]]}
[]
[null,null,"Übersicht Ausgabenermittlung zum Arbeits-, Zeit- und Ausgabenplan: "]
[]
[]
[]
[{"$nulls":7},"Antragsteller/in"]
[]
[null,null,"Reisekosten"]
[]
[]
[]
[null,null,"Arbeits-paket","Bezeichnung","Anzahl","Einzelpreis",null,null,null,"Gesamt"]
[{"$nulls":6},2023,2024,2025]
[{"$nulls":9},{"$f":"SUM(G14:I14)","v":0}]
[{"$nulls":9},{"$f":"SUM(G15:I15)","v":0}]
[{"$nulls":9},{"$f":"SUM(G16:I16)","v":0}]
[{"$nulls":9},{"$f":"SUM(G17:I17)","v":0}]
[{"$nulls":9},{"$f":"SUM(G18:I18)","v":0}]
[{"$nulls":9},{"$f":"SUM(G19:I19)","v":0}]
[{"$nulls":9},{"$f":"SUM(G20:I20)","v":0}]
[{"$nulls":9},{"$f":"SUM(G21:I21)","v":0}]
[{"$nulls":9},{"$f":"SUM(G22:I22)","v":0}]
[{"$nulls":9},{"$f":"SUM(G23:I23)","v":0}]
[{"$nulls":9},{"$f":"SUM(G24:I24)","v":0}]
[{"$nulls":9},{"$f":"SUM(G25:I25)","v":0}]
[{"$nulls":9},{"$f":"SUM(G26:I26)","v":0}]
[null,null,"Summe Reisekosten:",null,null,null,{"$f":"SUM(G14:G26)","v":0},{"$f":"SUM(H14:H26)","v":0},{"$f":"SUM(I14:I26)","v":0},{"$f":"SUM(G27:I27)","v":0}]

{"sheet":"AZA Jahr 1","index":2,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[16,7,16,8],[17,7,17,8],[16,5,16,6],[30,7,30,8],[15,2,15,4],[15,5,15,6],[15,7,15,8],[23,5,23,6],[24,5,24,6],[22,5,22,6],[26,5,26,6],[25,5,25,6],[20,7,20,8],[18,5,18,6],[19,5,19,6],[18,7,18,8],[3,14,3,15],[5,14,5,15],[14,7,14,8],[13,5,13,6],[14,5,14,6],[31,2,31,4],[26,2,26,4],[24,2,24,4],[25,2,25,4],[31,5,31,6],[30,5,30,6],[29,5,29,6],[32,5,32,6],[34,2,34,4],[33,5,33,11],[17,5,17,6],[18,2,18,4],[19,2,19,4],[34,10,34,11],[34,5,34,9],[23,2,23,4],[22,2,22,4],[29,2,29,4],[30,2,30,4],[20,2,20,4],[20,5,20,6],[33,2,33,4],[32,2,32,4],[0,10,0,13],[0,1,0,9],[1,14,1,15],[21,2,21,4],[17,2,17,4],[16,2,16,4],[13,2,13,4],[14,2,14,4],[11,13,11,15],[6,4,6,6],[11,2,12,4],[11,5,11,11],[12,5,12,6],[12,7,12,8],[13,7,13,8],[21,7,21,8],[19,7,19,8],[32,7,32,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[28,7,28,8],[29,7,29,8],[27,7,27,8],[31,7,31,8]]}
[null,"Anlage 4 zum Antrag",{"$nulls":8},"Arbeits-, Zeit- und Ausgabenplan (AZA)\nFF HAW-Kooperation"]
[]
[]
[]
[{"$nulls":14},"Antragsteller/in"]
[]
[null,null,"Kalenderjahr",null,"Projektarbeiten von / bis"]
[null,null,2023,null,null,null,"2023-12-31",null,null,"für jedes Kalenderjahr ist ein AZA auszufüllen"]
[]
[]
[]
[null,null,"Erläuterung zur Planung \n(z.B. Arbeitspaket)",null,null,"Personalangaben                                                     ",{"$nulls":7},"Ausgabegruppen            "]
[{"$nulls":5},"Entgelt-gruppe             (TV-L)",null,"Stellen-anteil             (in %)",null,"ausschl. Beschäf-tigung im Vorhaben (ja / nein)","Stunden-satz","Stunden gesamt",null,"Personal-ausgaben","Verbrauchsmaterial","Reisekosten"]
[{"$nulls":13},{"$f":"K14*L14","v":0}]
[{"$nulls":13},{"$f":"K15*L15","v":0}]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":5},"Zwischensumme",{"$nulls":7},{"$f":"SUM(N14:N33)","v":0},{"$f":"SUM(O14:O33)","v":0},{"$f":"SUM(P14:P33)","v":0}]
[{"$nulls":5},"GESAMTBETRAG",{"$nulls":4},{"$f":"SUM(N35:P35)","v":0},null,null,{"$f":"SUM(N34:N34)","v":0},{"$f":"O34","v":0},{"$f":"P34","v":0}]

{"sheet":"AZA Jahr 2","index":3,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,2,13,4],[13,5,13,6],[13,7,13,8],[0,1,0,9],[0,10,0,13],[11,2,12,4],[11,5,11,11],[11,13,11,15],[12,5,12,6],[12,7,12,8],[1,14,1,15],[3,14,3,15],[5,14,5,15],[6,4,6,6],[14,2,14,4],[14,5,14,6],[14,7,14,8],[15,2,15,4],[15,5,15,6],[15,7,15,8],[17,2,17,4],[17,5,17,6],[17,7,17,8],[16,2,16,4],[16,5,16,6],[16,7,16,8],[22,2,22,4],[22,5,22,6],[22,7,22,8],[18,2,18,4],[18,5,18,6],[18,7,18,8],[19,2,19,4],[19,5,19,6],[19,7,19,8],[20,2,20,4],[20,5,20,6],[20,7,20,8],[21,2,21,4],[21,7,21,8],[23,2,23,4],[23,5,23,6],[23,7,23,8],[24,2,24,4],[24,5,24,6],[24,7,24,8],[30,2,30,4],[30,5,30,6],[30,7,30,8],[25,2,25,4],[25,5,25,6],[25,7,25,8],[26,2,26,4],[26,5,26,6],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,2,29,4],[29,5,29,6],[29,7,29,8],[31,2,31,4],[31,5,31,6],[31,7,31,8],[32,2,32,4],[32,5,32,6],[32,7,32,8],[33,2,33,4],[33,5,33,11],[34,2,34,4],[34,5,34,9],[34,10,34,11]]}
[null,"Anlage 4 zum Antrag",{"$nulls":8},"Arbeits-, Zeit- und Ausgabenplan (AZA)\nFF HAW-Kooperation"]
[]
[]
[]
[{"$nulls":14},"Antragsteller/in"]
[]
[null,null,"Kalenderjahr",null,"Projektarbeiten von / bis"]
[null,null,2024,null,"2024-01-01",null,"2024-12-31",null,null,"für jedes Kalenderjahr ist ein AZA auszufüllen"]
[]
[]
[]
[null,null,"Erläuterung zur Planung \n(z.B. Arbeitspaket)",null,null,"Personalangaben                                                     ",{"$nulls":7},"Ausgabegruppen            "]
[{"$nulls":5},"Entgelt-gruppe             (TV-L)",null,"Stellen-anteil             (in %)",null,"ausschl. Beschäf-tigung im Vorhaben (ja / nein)","Stunden-satz","Stunden gesamt",null,"Personal-ausgaben","Verbrauchsmaterial","Reisekosten"]
[{"$nulls":13},{"$f":"K14*L14","v":0}]
[{"$nulls":13},{"$f":"K15*L15","v":0}]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":5},"Zwischensumme",{"$nulls":7},{"$f":"SUM(N14:N33)","v":0},{"$f":"SUM(O14:O33)","v":0},{"$f":"SUM(P14:P33)","v":0}]
[{"$nulls":5},"GESAMTBETRAG",{"$nulls":4},{"$f":"SUM(N35:P35)","v":0},null,null,{"$f":"SUM(N34:N34)","v":0},{"$f":"O34","v":0},{"$f":"P34","v":0}]

{"sheet":"AZA Jahr 3","index":4,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,2,13,4],[13,5,13,6],[13,7,13,8],[0,1,0,9],[0,10,0,13],[11,2,12,4],[11,5,11,11],[11,13,11,15],[12,5,12,6],[12,7,12,8],[1,14,1,15],[3,14,3,15],[5,14,5,15],[6,4,6,6],[14,2,14,4],[14,5,14,6],[14,7,14,8],[15,2,15,4],[15,5,15,6],[15,7,15,8],[16,2,16,4],[16,5,16,6],[16,7,16,8],[17,2,17,4],[17,5,17,6],[17,7,17,8],[22,2,22,4],[22,5,22,6],[22,7,22,8],[18,2,18,4],[18,5,18,6],[18,7,18,8],[19,2,19,4],[19,5,19,6],[19,7,19,8],[20,2,20,4],[20,5,20,6],[20,7,20,8],[21,2,21,4],[21,7,21,8],[23,2,23,4],[23,5,23,6],[23,7,23,8],[24,2,24,4],[24,5,24,6],[24,7,24,8],[30,2,30,4],[30,5,30,6],[30,7,30,8],[25,2,25,4],[25,5,25,6],[25,7,25,8],[26,2,26,4],[26,5,26,6],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,2,29,4],[29,5,29,6],[29,7,29,8],[31,2,31,4],[31,5,31,6],[31,7,31,8],[32,2,32,4],[32,5,32,6],[32,7,32,8],[33,2,33,4],[33,5,33,11],[34,2,34,4],[34,5,34,9],[34,10,34,11]]}
[null,"Anlage 4 zum Antrag",{"$nulls":8},"Arbeits-, Zeit- und Ausgabenplan (AZA)\nFF HAW-Kooperation"]
[]
[]
[]
[{"$nulls":14},"Antragsteller/in"]
[]
[null,null,"Kalenderjahr",null,"Projektarbeiten von / bis"]
[null,null,2025,null,"2025-01-01",{"$nulls":4},"für jedes Kalenderjahr ist ein AZA auszufüllen"]
[]
[]
[]
[null,null,"Erläuterung zur Planung \n(z.B. Arbeitspaket)",null,null,"Personalangaben                                                     ",{"$nulls":7},"Ausgabegruppen            "]
[{"$nulls":5},"Entgelt-gruppe             (TV-L)",null,"Stellen-anteil             (in %)",null,"ausschl. Beschäf-tigung im Vorhaben (ja / nein)","Stunden-satz","Stunden gesamt",null,"Personal-ausgaben","Verbrauchsmaterial","Reisekosten"]
[{"$nulls":13},{"$f":"K14*L14","v":0}]
[{"$nulls":13},{"$f":"K15*L15","v":0}]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":5},"Zwischensumme",{"$nulls":7},{"$f":"SUM(N14:N33)","v":0},{"$f":"SUM(O14:O33)","v":0},{"$f":"SUM(P14:P33)","v":0}]
[{"$nulls":5},"GESAMTBETRAG",{"$nulls":4},{"$f":"SUM(N35:P35)","v":0},null,null,{"$f":"SUM(N34:N34)","v":0},{"$f":"O34","v":0},{"$f":"P34","v":0}]

{"sheet":"Ausgabebedarf","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,8],[16,5,16,8],[4,7,4,9],[21,2,21,4],[7,1,7,6],[27,2,27,9],[2,7,2,9],[17,2,17,4],[6,6,6,9],[18,2,18,4]]}
[null,"Anlage 4 zum Antrag                  Fokus Forschung HAW-Kooperation \n                                                         (FF HAW-Kooperation) "]
[]
[]
[]
[]
[{"$nulls":6},"Antragsteller/in"]
[]
[null,"Ermittlung des Ausgabebedarfs"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"1. Jahr","2. Jahr","3. Jahr","GESAMT"]
[null,null,"Fördersatz",0.9,null,2023,2024,2025]
[{"$nulls":5},"Alle Beträge in EURO"]
[null,null,"Personalausgaben",null,null,{"$f":"'AZA Jahr 1'!N34","v":0},{"$f":"'AZA Jahr 2'!N34","v":0},{"$f":"'AZA Jahr 3'!N34","v":0},{"$f":"SUM(F18:H18)","v":0}]
[null,null,"Verbrauchsmaterial",null,null,{"$f":"'AZA Jahr 1'!O35","v":0},{"$f":"'AZA Jahr 2'!O35","v":0},{"$f":"'AZA Jahr 3'!O35","v":0},{"$f":"SUM(F19:H19)","v":0}]
[null,null,"Reisekosten",null,null,{"$f":"'AZA Jahr 1'!P35","v":0},{"$f":"'AZA Jahr 2'!P35","v":0},{"$f":"'AZA Jahr 3'!P35","v":0},{"$f":"SUM(F20:H20)","v":0}]
[]
[null,null,"ZUWENDUNG",null,null,{"$f":"SUM(F18:F20)*$D$16","v":0},{"$f":"SUM(G18:G20)*$D$16","v":0},0,0]