{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BELEGLISTE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"BELEGLISTE","index":0,"n_rows":154,"n_cols":30,"rows_kept":154,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,8,0,9],[6,6,6,7],[6,9,6,10],[9,8,11,8],[4,9,4,10],[2,5,2,12],[8,0,11,0],[8,1,11,1],[8,6,8,11],[8,12,11,12],[9,2,11,2],[9,3,11,3],[9,4,11,4],[9,5,11,5],[9,6,11,6],[9,7,11,7],[2,14,12,14],[80,3,80,4],[80,6,80,7],[80,10,80,11],[9,9,11,9],[9,10,11,10],[9,11,11,11],[77,3,77,4],[77,6,77,7],[77,10,77,11]]}
["Belegliste für den ",null,null,null,null,null,null,"vom",null,null,null,null,null,null,"Diese Felder sind zu befüllen","Belegliste für den ","Zwischenverwendungsnachweis","Verwendungsnachweis"]
[]
["Antragstellerin / Antragsteller (Name, Vorname):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Informationen/Hinweise können Sie Zellen mit einem roten Dreieck in der oberen rechten Ecke entnehmen. Wenn Sie mit dem Mauszeiger auf das Dreieck zeigen, können Sie sich den hinterlegten Text anzeigen lassen.\nFormatierung kann angepasst werden, jedoch ist dann ggf. die Einstellung für den Drucker anzupassen!"]
[]
["Aktenzeichen",null,null,"NWE-",null,null,null,null,null,null,null,null,null,null,null,"Aktenzeichen Jahr","-23","-24","-25","-26","-27","-28","-29","-30","-31","-32","-33"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aktenzeichen lfd. Nr","-001","-002","-003","-004","-005","-006","-007","-008","-009","-010","-011","-012","-013","-014"]
["Durchführungszeitraum laut Zuwendungs-/Änderungsbescheid (von - bis)",null,null,null,null,null,null,null,"-"]
[]
["Beleg Nr.","Kostengruppe (falls vorhanden)",null,null,"Ich bin / Wir sind vorsteuerabzugsberechtigt  ","ja","Ausgaben in Euro",null,null,null,null,null,"Bearbeitungsspalte der\nBewilligungsbehörde",null,null,"vorsteuerabzugsberechtigt","ja","nein"]
[null,null,"Datum der\nRechnung","Datum  der   Zahlung","Rechnungsaussteller","Rechnungsgegenstand","Gesamt-\nbetrag","nicht\nförderfähig","brutto","USt","netto","zuwendungs-\nfähig"]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,"USt-Satz",null,"Umsatzsteuersatz in %",0,7,19,9.9,8.4,6.1,5.5]
[1,null,null,null,null,null,null,null,{"$f":"IF(G14>0,G14-H14,\"\")","v":""},{"$f":"IF(G14>0,I14-K14,\"\")","v":""},{"$f":"IF(G14>0,ROUND((I14/(1+N14/100)),2),\"\")","v":""},{"$f":"IF($F$9=\"ja\",K14,I14)","v":""}]
[{"$f":"A14+1","v":2},null,null,null,null,null,null,null,{"$f":"IF(G15>0,G15-H15,\"\")","v":""},{"$f":"IF(G15>0,I15-K15,\"\")","v":""},{"$f":"IF(G15>0,ROUND((I15/(1+N15/100)),2),\"\")","v":""},{"$f":"IF($F$9=\"ja\",K15,I15)","v":""},null,null,"Excel-Datei der Bewilligungsbehörde per Mail zusenden"]
[{"$f":"A15+1","v":3},null,null,null,null,null,null,null,"","","",""]
[4,null,null,null,null,null,null,null,"","","",""]
[5,null,null,null,null,null,null,null,"","","",""]
[6,null,null,null,null,null,null,null,"","","",""]
[7,null,null,null,null,null,null,null,"","","","",null,null,{"$f":"IF(AND($F$9=\"nein\",L20<I20),\"Fehler ! Nicht vorsteuerabzugsberechtigt, aber USt berücksichtigt\",\"\")","v":""}]
[8,null,null,null,null,null,null,null,"","","","",null,null,""]
[9,null,null,null,null,null,null,null,"","","","",null,null,""]
[10,null,null,null,null,null,null,null,"","","","",null,null,""]
[11,null,null,null,null,null,null,null,"","","","",null,null,""]
[12,null,null,null,null,null,null,null,"","","","",null,null,""]
[13,null,null,null,null,null,null,null,"","","","",null,null,""]
[14,null,null,null,null,null,null,null,"","","","",null,null,""]
[15,null,null,null,null,null,null,null,"","","","",null,null,""]
[16,null,null,null,null,null,null,null,"","","","",null,null,""]
[17,null,null,null,null,null,null,null,"","","","",null,null,""]
[18,null,null,null,null,null,null,null,"","","","",null,null,""]
[19,null,null,null,null,null,null,null,"","","","",null,null,""]
[20,null,null,null,null,null,null,null,"","","","",null,null,""]
[21,null,null,null,null,null,null,null,"","","","",null,null,""]
[22,null,null,null,null,null,null,null,"","","","",null,null,""]
[23,null,null,null,null,null,null,null,"","","","",null,null,""]
[24,null,null,null,null,null,null,null,"","","","",null,null,""]
[25,null,null,null,null,null,null,null,"","","","",null,null,""]
[{"$f":"A38+1","v":26},null,null,null,null,null,null,null,"","","","",null,null,""]
[{"$f":"A39+1","v":27},null,null,null,null,null,null,null,"","","","",null,null,""]
[{"$f":"A40+1","v":28},null,null,null,null,null,null,null,"","","","",null,null,""]
[{"$f":"A41+1","v":29},null,null,null,null,null,null,null,"","","","",null,null,""]
[null,{"$f":"\"SUMME Beleg Nr. \"&A14&\" bis \"&A42","v":"SUMME Beleg Nr. 1 bis 29"},null,null,null,null,{"$f":"SUM(G14:G42)","v":0},{"$f":"SUM(H14:H42)","v":0},0,0,0,0]
[]
[{"$f":"A42+1","v":30},null,null,null,null,null,null,null,{"$f":"IF(G45>0,G45-H45,\"\")","v":""},{"$f":"IF(G45>0,I45-K45,\"\")","v":""},{"$f":"IF(G45>0,ROUND((I45/(1+N45/100)),2),\"\")","v":""},{"$f":"IF($F$9=\"ja\",K45,I45)","v":""},null,null,{"$f":"IF(AND($F$9=\"nein\",L45<I45),\"Fehler ! Nicht vorsteuerabzugsberechtigt, aber USt berücksichtigt\",\"\")","v":""}]
[{"$f":"A45+1","v":31},null,null,null,null,null,null,null,"","","","",null,null,""]
[32,null,null,null,null,null,null,null,"","","","",null,null,""]
[33,null,null,null,null,null,null,null,"","","","",null,null,""]
[34,null,null,null,null,null,null,null,"","","","",null,null,""]
[35,null,null,null,null,null,null,null,"","","","",null,null,""]
[36,null,null,null,null,null,null,null,"","","","",null,null,""]
[37,null,null,null,null,null,null,null,"","","","",null,null,""]
[38,null,null,null,null,null,null,null,"","","","",null,null,""]
[39,null,null,null,null,null,null,null,"","","","",null,null,""]
[40,null,null,null,null,null,null,null,"","","","",null,null,""]
[41,null,null,null,null,null,null,null,"","","","",null,null,""]
[42,null,null,null,null,null,null,null,"","","","",null,null,""]
[43,null,null,null,null,null,null,null,"","","","",null,null,""]
[44,null,null,null,null,null,null,null,"","","","",null,null,""]
[45,null,null,null,null,null,null,null,"","","","",null,null,""]
[46,null,null,null,null,null,null,null,"","","","",null,null,""]
[47,null,null,null,null,null,null,null,"","","","",null,null,""]
[48,null,null,null,null,null,null,null,"","","","",null,null,""]
[49,null,null,null,null,null,null,null,"","","","",null,null,""]
[50,null,null,null,null,null,null,null,"","","","",null,null,""]
[51,null,null,null,null,null,null,null,"","","","",null,null,""]
[52,null,null,null,null,null,null,null,"","","","",null,null,""]
[53,null,null,null,null,null,null,null,"","","","",null,null,""]
[54,null,null,null,null,null,null,null,"","","","",null,null,""]
[55,null,null,null,null,null,null,null,"","","","",null,null,""]
[56,null,null,null,null,null,null,null,"","","","",null,null,""]
[57,null,null,null,null,null,null,null,"","","","",null,null,""]
[58,null,null,null,null,null,null,null,"","","","",null,null,""]
[null,{"$f":"\"SUMME Beleg Nr. \"&A14&\" bis \"&A73","v":"SUMME Beleg Nr. 1 bis 58"},null,null,null,null,{"$f":"G43+SUM(G45:G73)","v":0},{"$f":"H43+SUM(H45:H73)","v":0},0,0,0,0,null,null,""]
[]
[null,"laut Zuwendungs-/Änderungsbescheid(en)",null,null,null,null,"laut Auszahlungsbescheid(en)",null,null,null,null,null,null,null,"Ab hier nicht ausdrucken"]
[null,"im laufenden Haushaltsjahr",null,null,{"$f":"IF(I1>0,I1,\"\")","v":""}]
[null,"bewilligt ",null,null,null,"ausgezahlt",null,null,null,"verbleiben",{"$f":"D78-G78","v":0}]
[]
[null,"in der Gesamtlaufzeit"]
[null,"bewilligt",null,null,null,"ausgezahlt",null,null,null,"verbleiben",{"$f":"D81-G81","v":0}]
[]
[]
["Hilfestellung für Auszahlungsantrag Nr. 3 Finanzierungsplan/ Beantragte Förderung"]
["a)","Gesamtausgaben",null,null,null,null,{"$f":"G74","v":0}]
["b)","Nicht zuwendungsfähige Ausgaben",null,null,null,null,{"$f":"IF($F$9=\"nein\",H74,H74+J74)","v":0},"laut",{"$f":"B76","v":"laut Zuwendungs-/Änderungsbescheid(en)"}]
["c)","Leistungen Dritter",null,null,null,null,null,"Belegliste","stehen maximal zur Verfügung"]
["d)","zuwendungsfähige Ausgaben",null,null,null,null,{"$f":"G85-G86-G87","v":0},{"$f":"L74","v":0},{"$f":"IF(L89<>0,ROUND((I89/L89),2),\"\")","v":""}]
["e)","Beantragte Auszahlung",null,null,{"$f":"IF(G89>I89,\"laut Zelle I93 zu hoch! Zelle G93 manuell ändern!\",\"\")","v":""},null,{"$f":"ROUND((G88*L89),2)","v":0},{"$f":"ROUND((H88*L89),2)","v":0},{"$f":"K78","v":0},null,null,null,"Fördersatz",null,null,0.25,0.4,0.5,0.6,0.75,1]
["f)","sonstige beantragte/bewilligte öffentliche Förderung"]
["g)","Eigenmittel",null,null,null,null,{"$f":"H88-G89-G90","v":0}]
[]
[]
["Hilfestellung für Auszahlungsantrag Nr. 4. Zahlenmäßiger Nachweis "]
[]
[null,"Darstellung der Ausgaben",null,null,"Betrag in €","davon zuwendungsfähig in €"]
[null,{"$f":"IF(B14<>0,\"Kostengruppe\"&\" \"&B14,\"Summe Belegliste\")","v":"Summe Belegliste"},null,null,{"$f":"IF(B14<>0,G14,$G$74)","v":0},{"$f":"IF(B14<>0,L14,$L$74)","v":0}]
[null,{"$f":"IF(B15<>0,\"Kostengruppe\"&\" \"&B15,\"Summe Belegliste\")","v":"Summe Belegliste"},null,null,{"$f":"IF(B15<>0,G15,$G$74)","v":0},{"$f":"IF(B15<>0,L15,$L$74)","v":0},null,null,null,null,null,null,{"$f":"\"Vorsicht\"&\" \"&B76&\" \"&\"stehen maximal zur Verfügung (Zelle E88)\"","v":"Vorsicht laut Zuwendungs-/Änderungsbescheid(en) stehen maximal zur Verfügung (Zelle E88)"}]
[null,"Summe Belegliste",null,null,0,0,null,null,"als davon zuwendungsfähig in €",null,null,{"$f":"IF(L74>I88,I88,L74)","v":0}]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,{"$f":"IF(B45<>0,\"Kostengruppe\"&\" \"&B45,\"Summe Belegliste\")","v":"Summe Belegliste"},null,null,{"$f":"IF(B45<>0,G45,$G$74)","v":0},{"$f":"IF(B45<>0,L45,$L$74)","v":0}]
[null,{"$f":"IF(B46<>0,\"Kostengruppe\"&\" \"&B46,\"Summe Belegliste\")","v":"Summe Belegliste"},null,null,{"$f":"IF(B46<>0,G46,$G$74)","v":0},{"$f":"IF(B46<>0,L46,$L$74)","v":0}]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]
[null,"Summe Belegliste",null,null,0,0]