{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Titelblatt","Personalkosten Plan","Personalkosten Ist","Sachkosten Plan","Sachkosten Ist","Investitionen Plan","Investitionen Ist","Maschinenstundensatz Plan","Maschinenstundensatz Ist"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":7,"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":"Titelblatt","index":0,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[46,0,46,7],[45,0,45,7],[41,0,41,7],[42,0,42,7],[0,1,0,4],[2,1,2,4],[43,0,43,7],[15,1,15,2],[44,0,44,7],[15,5,15,8],[39,4,39,8],[24,0,37,2]]}
["Projektbezeichnung (Kurztitel)"]
[]
["Einrichtung/Name"]
[]
["Geschäftszeichen Abt08 sofern bereits bekannt:"]
["Jahressumsatz (Haupt-) Antragsteller","Plan","Ist"]
["(Angabe entfällt bei universitären Antragstellern)"]
[]
["Projektdauer von - bis"]
["Projektdauer in Monaten:",24,null,null,"ja"]
[null,null,null,null,"nein"]
["Vorsteuerabzug möglich?","ja"]
[]
["Overhead wird geltend gemacht?","nein"]
[]
["Ausgaben",null,null,null,"Einnahmen                                 "," HINWEIS: Nicht anzuführen ist die bei der A8 Gesundheit, Pflege und Wissenschaft beantragte Förderung"]
[null,"PLAN","IST","Delta ",null,null,null,"PLAN","IST"]
["Personalkosten:",{"$f":"'Personalkosten Plan'!$O$85","v":0},{"$f":"+'Personalkosten Ist'!S85","v":0},{"$f":"IF(C18>0,1-(+C18/B18),\"-\")","v":"-"},"auszahlende Stelle","Art der Einnahme (Zutreffendes auswählen)","Status (zutreffendes auswählen)"]
["Overhead - 20%; Basis: Personalkosten:",{"$f":"IF($B$14=\"ja\",B18*0.2,\"\")","v":""},{"$f":"IF($B$14=\"ja\",C18*0.2,\"\")","v":""},{"$error":"#VALUE!"},null,"Eigenleistung","beantragt",0,0]
["Sachkosten:",{"$f":"'Sachkosten Plan'!D206","v":0},{"$f":"+'Sachkosten Ist'!J206","v":0},{"$f":"IF(C20>0,1-(+C20/B20),\"-\")","v":"-"},null,"Eigenleistung","beantragt",0,0]
["Investitionen:",{"$f":"'Investitionen Plan'!H27","v":0},{"$f":"+'Investitionen Ist'!J27","v":0},{"$f":"IF(C21>0,1-(+C21/B21),\"-\")","v":"-"},null,"Eigenleistung","beantragt",0,0]
["Maschinenstundensatz:",{"$f":"'Maschinenstundensatz Plan'!E38","v":0},{"$f":"+'Maschinenstundensatz Ist'!G37","v":0},"-",null,"Eigenleistung","beantragt",0,0]
["Summe Ausgaben",{"$f":"SUM(B18:B22)","v":0},{"$f":"SUM(C18:C22)","v":0},"-",null,"Eigenleistung","beantragt",0,0]
[null,null,null,null,null,"Eigenleistung","beantragt",0,0]
["Datenschutzrechtliche Bestimmungen \n1. Die Förderungswerberin/Der Förderungswerber nimmt zur Kenntnis, dass der Förderungsgeber ermächtigt ist, alle im Förderungsantrag enthaltenen, die Förderungswerberinnen/Förderungswerber und Förderungsnehmerinnen/Förderungsnehmer betreffenden personenbezogenen Daten gemäß Art. 6 Abs. 1 lit. b Datenschutz-Grundverordnung für Zwecke der Anbahnung und des Abschlusses des Förderungsvertrages automationsunterstützt zu verarbeiten. \n2. Die gemäß Z 1 verarbeiteten Daten werden in Anlehnung an die steuerrechtlichen Vorgaben sieben Jahre gespeichert. \n3. Die Förderungswerberin/Der Förderungswerbers nimmt zur Kenntnis, dass auf der Datenschutz-Informationsseite des Förderungsgebers (https://datenschutz.stmk.gv.at) alle relevanten Informationen insbesondere zu folgenden sie/ihn betreffenden Punkten veröffentlicht sind:\n• zu den ihr/ihm zustehenden Rechten auf Auskunft, Berichtigung, Löschung, Einschränkung der Verarbeitung, Widerruf und Widerspruch sowie auf Datenübertragbarkeit; \n• zum dem ihr/ihm zustehenden Beschwerderecht bei der Österreichischen Datenschutzbehörde; \n• zum Verantwortlichen der Verarbeitung und zum Datenschutzbeauftragten.",null,null,null,null,"Eigenleistung","beantragt",0,0]
[null,null,null,null,null,"Eigenleistung","beantragt",0,0]
[null,null,null,null,null,"Eigenleistung","beantragt",0,0]
[null,null,null,null,null,"Eigenleistung","beantragt",0,0]
[null,null,null,null,"Summe Einnahmen",null,null,{"$f":"SUM(H19:H28)","v":0},{"$f":"SUM(I19:I28)","v":0}]
[null,null,null,null,"zu finanzierender Betrag = Ausgaben - Einnahmen:",null,null,{"$f":"B23-H29","v":0},{"$f":"+C23-I29","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Datum und firmenmäßige Fertigung"]
[]
["- Bei Antragstellung sind die Plankosten mit den zugehörigen gelben Tabellenrasterblättern auszufüllen."]
["- Im Falle einer Förderungsgenehmigung sind im Rahmen der Projektabrechnung die Istwerte in den zugehörigen grünen Tabellenraterblättern zu ergänzen."]
["- Die rechtlichen Rahmenbedingungen für die Anrechenbarkeit von Kosten bildet die Förderungsvereinbarung samt den zugehörigen Anhängen sowie allfälligen Merkblättern zur Abrechnung",null,null,null,"maximal mögliche Förderquote / Förderung"]
["-  Anerkannt werden nur Kosten für vollständig und ordnungsgemäß beendete Projekte (ausgenommen Teilabrechnungen), das Erreichen der maximal anrechenbaren Kosten allein ist nicht ausreichend."]
["- Förderbar (anrechenbar) sind nur die lt. Förderungszusage genehmigten und dem Projekt tatsächlich zuordenbaren bezahlten Netto- bzw. Bruttobeträge. Sowohl das Rechnungs- als auch das Zahlungsdatum muss dabei innerhalb des Förderungszeitraumes liegen und sind bei der Abrechnung detailliert (auch Teilzahlungen) anzuführen. Teilrechnungen sind entsprechend zu kennzeichnen.",null,null,null,"Das Projekt ist einzuteilen in den Bereich/die Bereiche (in %; siehe …)"]
["- Grundsätzlich ist die Abrechnung in elektronischer Form vorzulegen, sofern im Förderungsvertrag nicht anders definiert – Abrechnungsmodalitäten werden in Punkt 1.3. des Förderungsvertrages definiert. Orgiginalbelege sind nur auf Verlangen vorzulegen."]
[null,null,null,null,null,null,"%"]
[]
["Eigenleistung","beantragt"]
["Förderung","zugesagt"]
["Sponsoring"]

{"sheet":"Personalkosten Plan","index":1,"n_rows":100,"n_cols":17,"rows_kept":100,"cut":false,"hidden":false,"merged":[[92,0,92,14],[87,0,87,14],[88,0,88,14],[89,0,89,14],[90,0,90,14],[91,0,91,14],[0,0,0,1],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,3,3,3],[2,14,3,14],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,4,2,6],[2,7,3,7],[2,8,3,8],[2,9,3,9]]}
["Personalkosten Plan"]
[]
["lfd. Nr.","Name","Funktion","Karrierestatus (Zutreffendes auswählen)","Beschäftigungszeitraum",null,null,"Bruttogehalt monatlich","Bruttogehalt inkl. LNK (51%)","Beschäftigung in h/Woche","DN ist nur für dieses Projekt tätig?","monatlicher Stundenteiler","Stundensatz","geplante Beschäftigung im Projekt (in h)","Kosten"]
[null,null,null,null,"von","bis","in Monaten"]
[1,null,null,null,null,null,{"$f":"IF(OR(E5=\"\",F5=\"\"),0,ROUND((DAYS360(E5,F5,TRUE)+IF(AND(DAY(F5)>=28,MONTH(F5)=2),30-DAY((F5)),0)+1)/30,2))","v":0},null,{"$f":"H5*1.51","v":0},null,"ja",{"$f":"IF(K5=\"nein\",ROUND((42*J5/12),2),\"\")","v":""},{"$f":"IF(K5=\"nein\",I5/L5,\"\")","v":""},null,{"$f":"IF(K5=\"ja\",I5*G5,M5*N5)","v":0},null,"ja"]
[2,null,null,null,null,null,{"$f":"IF(OR(E6=\"\",F6=\"\"),0,ROUND((DAYS360(E6,F6,TRUE)+IF(AND(DAY(F6)>=28,MONTH(F6)=2),30-DAY((F6)),0)+1)/30,2))","v":0},null,{"$f":"H6*1.51","v":0},null,"ja","",{"$f":"IF(K6=\"nein\",I6/L6,\"\")","v":""},null,{"$f":"IF(K6=\"ja\",I6*G6,M6*N6)","v":0},null,"nein"]
[3,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[4,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[5,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[6,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[7,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[8,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[9,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[10,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[11,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[12,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[13,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[14,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[15,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[16,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[17,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[18,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[19,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[20,null,null,null,null,null,0,null,0,null,"ja",{"$f":"IF(K24=\"nein\",ROUND((42*J24/12),2),\"\")","v":""},{"$f":"IF(K24=\"nein\",I24/L24,\"\")","v":""},null,{"$f":"IF(K24=\"ja\",I24*G24,M24*N24)","v":0}]
[21,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[22,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[23,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[24,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[25,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[26,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[27,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[28,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[29,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[30,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[31,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[32,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[33,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[34,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[35,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[36,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[37,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[38,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[39,null,null,null,null,null,{"$f":"IF(OR(E43=\"\",F43=\"\"),0,ROUND((DAYS360(E43,F43,TRUE)+IF(AND(DAY(F43)>=28,MONTH(F43)=2),30-DAY((F43)),0)+1)/30,2))","v":0},null,0,null,"ja",{"$f":"IF(K43=\"nein\",ROUND((42*J43/12),2),\"\")","v":""},{"$f":"IF(K43=\"nein\",I43/L43,\"\")","v":""},null,{"$f":"IF(K43=\"ja\",I43*G43,M43*N43)","v":0}]
[40,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[41,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[42,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[43,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[44,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[45,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[46,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[47,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[48,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[49,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[50,null,null,null,null,null,{"$f":"IF(OR(E54=\"\",F54=\"\"),0,ROUND((DAYS360(E54,F54,TRUE)+IF(AND(DAY(F54)>=28,MONTH(F54)=2),30-DAY((F54)),0)+1)/30,2))","v":0},null,{"$f":"H54*1.51","v":0},null,"ja",{"$f":"IF(K54=\"nein\",ROUND((42*J54/12),2),\"\")","v":""},{"$f":"IF(K54=\"nein\",I54/L54,\"\")","v":""},null,{"$f":"IF(K54=\"ja\",I54*G54,M54*N54)","v":0}]
[51,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[52,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[53,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[54,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[55,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[56,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[57,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[58,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[59,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[60,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[61,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[62,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[63,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[64,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[65,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[66,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[67,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[68,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[69,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[70,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[71,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[72,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[73,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[74,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[75,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[76,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[77,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[78,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[79,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[80,null,null,null,null,null,0,null,0,null,"ja","","",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O5:O84)","v":0}]
["Wenn Sie mehr als 20 Zeilen benötigen, drücken Sie den + Button links außen. Um diese Funktion zu nutzen, müssen Sie gegebenenfalls Makros zulassen, sofern diese durch Ihre Sicherheitseinstellungen gesperrt sind."]
[]
["Personalkosten"]
["-       Es werden nur Personalkosten anerkannt, die innerhalb des Förderzeitraumes liegen."]
["-       Beschäftigungszeiträume, die ein Jahr überschreiten, sind mit dem laufenden Jahr abzugrenzen. In der neuen Zeile ist der Beschäftigungszeitraum des Folgejahres einzutragen. Leistete man z.B. für die Monate April 2014 bis Februar 2015 Projektarbeit, so ist der Beschäftigungszeitraum mit „1.4.14“ bis „31.12.14“ und in einer weiteren Zeile mit „1.1.15“ bis „28.2.15“ anzugeben."]
["-       Ändert sich das Gehalt, so ist dafür im Belegsverzeichnis ein neuer Eintrag (in einer neuen Zeile) zu tätigen."]
["-       Die Summe der Projekt-Arbeitszeit muss durch eine detaillierte Stundenaufstellung nachgewiesen werden. Die Stundenaufstellung hat den Namen desjenigen, der Projektarbeitszeit verrechnet, den Tag, an dem Projektarbeitszeit geleistet wurde, den Zeitraum (Projekt-Arbeit von/bis), die sich aus dem Zeitraum ergebende Arbeitsdauer (in Stunden und Minuten) und die Beschreibung der Tätigkeit für die Projekt-Arbeit zu enthalten. Für die verrechnete Projekt-Arbeitszeit ist jeweils eine Monats-Summe zu bilden.","Senior Postdoc"]
["-       Ändert sich das Ausmaß der Beschäftigung, ist dafür ein neuer Eintrag zu tätigen ","Postdoc"]
[null,"Postdoc"]
[]
[null,"Senior Postdoc"]
[null,"Postdoc"]
[null,"DoktorandIn"]
[null,"Student. MitarbeiterIn"]
[null,"sonstige MitarbeiterIn"]

{"sheet":"Personalkosten Ist","index":2,"n_rows":101,"n_cols":20,"rows_kept":101,"cut":false,"hidden":false,"merged":[[2,18,3,18],[93,0,93,14],[2,14,3,14],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,7,3,7],[87,0,87,14],[89,0,89,14],[90,0,90,14],[91,0,91,14],[92,0,92,14],[2,17,3,17],[2,15,3,15],[88,0,88,14],[2,16,3,16],[0,0,0,1],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,4,2,6],[2,3,3,3]]}
["Personalkosten Ist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ja"]
["lfd. Nr.","Name","Funktion","Karrierestatus (Zutreffendes auswählen)","Beschäftigungszeitraum",null,null,"Bruttogehalt monatlich","Bruttogehalt inkl. LNK","Beschäftigung in h/Woche","DN ist nur für dieses Projekt tätig?","monatlicher Stundenteiler","Stundensatz","Ist-Beschäftigung im Projekt (in h)","Kosten","Istkosten lt. Lohnkonto","Differenz ","Prüfungsanmerkungen","anerkannte Kosten","nein"]
[null,null,null,null,"von","bis","in Monaten"]
[1,null,null,null,null,null,{"$f":"IF(OR(E5=\"\",F5=\"\"),0,ROUND((DAYS360(E5,F5,TRUE)+IF(AND(DAY(F5)>=28,MONTH(F5)=2),30-DAY((F5)),0)+1)/30,2))","v":0},null,{"$f":"H5*1.51","v":0},null,"ja",{"$f":"IF(K5=\"nein\",ROUND((42*J5/12),2),\"\")","v":""},{"$f":"IF(K5=\"nein\",I5/L5,\"\")","v":""},null,{"$f":"IF(K5=\"ja\",I5*G5,M5*N5)","v":0},null,{"$f":"+P5-O5","v":0},null,{"$f":"+O5","v":0}]
[2,null,null,null,null,null,0,null,{"$f":"H6*1.51","v":0},null,"ja",{"$f":"IF(K6=\"nein\",ROUND((42*J6/12),2),\"\")","v":""},{"$f":"IF(K6=\"nein\",I6/L6,\"\")","v":""},null,0,null,0,null,{"$f":"+O6","v":0}]
[3,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[4,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[5,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[6,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[7,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[8,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[9,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[10,null,null,null,null,null,{"$f":"IF(OR(E14=\"\",F14=\"\"),0,ROUND((DAYS360(E14,F14,TRUE)+IF(AND(DAY(F14)>=28,MONTH(F14)=2),30-DAY((F14)),0)+1)/30,2))","v":0},null,{"$f":"H14*1.51","v":0},null,"ja",{"$f":"IF(K14=\"nein\",ROUND((42*J14/12),2),\"\")","v":""},{"$f":"IF(K14=\"nein\",I14/L14,\"\")","v":""},null,{"$f":"IF(K14=\"ja\",I14*G14,M14*N14)","v":0},null,0,null,0]
[11,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[12,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[13,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[14,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[15,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[16,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[17,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[18,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[19,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[20,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[21,null,null,null,null,null,0,null,0,null,"ja",{"$f":"IF(K25=\"nein\",ROUND((42*J25/12),2),\"\")","v":""},{"$f":"IF(K25=\"nein\",I25/L25,\"\")","v":""},null,{"$f":"IF(K25=\"ja\",I25*G25,M25*N25)","v":0},null,0,null,0]
[22,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[23,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[24,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[25,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[26,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[27,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[28,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[29,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[30,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[31,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[32,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[33,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[34,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[35,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[36,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[37,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[38,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[39,null,null,null,null,null,{"$f":"IF(OR(E43=\"\",F43=\"\"),0,ROUND((DAYS360(E43,F43,TRUE)+IF(AND(DAY(F43)>=28,MONTH(F43)=2),30-DAY((F43)),0)+1)/30,2))","v":0},null,0,null,"ja",{"$f":"IF(K43=\"nein\",ROUND((42*J43/12),2),\"\")","v":""},{"$f":"IF(K43=\"nein\",I43/L43,\"\")","v":""},null,{"$f":"IF(K43=\"ja\",I43*G43,M43*N43)","v":0},null,0,null,0]
[40,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[41,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[42,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[43,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[44,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[45,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[46,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[47,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[48,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[49,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[50,null,null,null,null,null,{"$f":"IF(OR(E54=\"\",F54=\"\"),0,ROUND((DAYS360(E54,F54,TRUE)+IF(AND(DAY(F54)>=28,MONTH(F54)=2),30-DAY((F54)),0)+1)/30,2))","v":0},null,{"$f":"H54*1.51","v":0},null,"ja",{"$f":"IF(K54=\"nein\",ROUND((42*J54/12),2),\"\")","v":""},{"$f":"IF(K54=\"nein\",I54/L54,\"\")","v":""},null,{"$f":"IF(K54=\"ja\",I54*G54,M54*N54)","v":0},null,{"$f":"+P54-O54","v":0},null,{"$f":"+O54","v":0}]
[51,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[52,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[53,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[54,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[55,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[56,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[57,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[58,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[59,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[60,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[61,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[62,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[63,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[64,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[65,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[66,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[67,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[68,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[69,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[70,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[71,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[72,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[73,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[74,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[75,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[76,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[77,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[78,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[79,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[80,null,null,null,null,null,0,null,0,null,"ja","","",null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O5:O84)","v":0},{"$f":"SUM(P5:P84)","v":0},{"$f":"SUM(Q5:Q84)","v":0},null,{"$f":"SUM(S5:S84)","v":0}]
["Wenn Sie mehr als 20 Zeilen benötigen, drücken Sie den + Button links außen. Um diese Funktion zu nutzen, müssen Sie gegenenfalls Makros zulassen, sofern diese durch Ihre Sicherheitseinstellungen gesperrt sind."]
[]
["Personalkosten"]
["- Die Berechnung der Personalkosten erfolgt automatisch durch Multiplikation des Bruttogehalts mit dem Faktor 1,51. Damit sollen Lohnnebenkosten und Sonderzahlungen anteilsmäßig berücksichtigt werden. Für Fälle, in denen es zu größeren Abweichungen zu den tatsächlichen Kosten lt. Lohnkonto kommt, besteht die Möglichkeit, in  Spalte P die tatsächlichen Kosten lt. Lohnkonto direkt einzutragen. Das Lohnkonto ist der Abrechnung beizulegen. "]
["-       Es werden nur Personalkosten anerkannt, die innerhalb des Förderzeitraumes liegen."]
["-       Beschäftigungszeiträume, die ein Jahr überschreiten, sind mit dem laufenden Jahr abzugrenzen. In der neuen Zeile ist der Beschäftigungszeitraum des Folgejahres einzutragen. Leistete man z.B. für die Monate April 2014 bis Februar 2015 Projektarbeit, so ist der Beschäftigungszeitraum mit „1.4.14“ bis „31.12.14“ und in einer weiteren Zeile mit „1.1.15“ bis „28.2.15“ anzugeben."]
["-       Ändert sich das Gehalt, so ist dafür im Belegsverzeichnis ein neuer Eintrag (in einer neuen Zeile) zu tätigen."]
["-       Die Summe der Projekt-Arbeitszeit muss durch eine detaillierte Stundenaufstellung nachgewiesen werden. Die Stundenaufstellung hat den Namen desjenigen, der Projektarbeitszeit verrechnet, den Tag, an dem Projektarbeitszeit geleistet wurde, den Zeitraum (Projekt-Arbeit von/bis), die sich aus dem Zeitraum ergebende Arbeitsdauer (in Stunden und Minuten) und die Beschreibung der Tätigkeit für die Projekt-Arbeit zu enthalten. Für die verrechnete Projekt-Arbeitszeit ist jeweils eine Monats-Summe zu bilden.","Senior Postdoc"]
["-       Ändert sich das Ausmaß der Beschäftigung, ist dafür ein neuer Eintrag zu tätigen ","Postdoc"]
[null,"DoktorandIn"]
[null,"sonstige wissenschaftliche MitarbeiterIn"]
[null,"Senior Postdoc"]
[null,"Postdoc"]
[null,"DoktorandIn"]
[null,"Student. MitarbeiterIn"]
[null,"sonstige MitarbeiterIn"]

{"sheet":"Sachkosten Plan","index":3,"n_rows":208,"n_cols":5,"rows_kept":208,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,1],[207,0,207,5]]}
["Sachkosten Plan"]
[]
["Vorsteuerabzug",null,{"$f":"Titelblatt!B12","v":"ja"}]
[]
["lfd. Nr.","Bezeichnung","Kosten brutto","Kosten netto","Ust.-Satz"]
[1,null,null,{"$f":"(IF($C$3=\"ja\",C6/(1+E6),\"\"))","v":0},0.2]
[2,null,null,0,0.2]
[3,null,null,0,0.2]
[4,null,null,0,0.2]
[5,null,null,0,0.2]
[6,null,null,0,0.2]
[7,null,null,0,0.2]
[8,null,null,0,0.2]
[9,null,null,0,0.2]
[10,null,null,0,0.2]
[11,null,null,0,0.2]
[12,null,null,0,0.2]
[13,null,null,0,0.2]
[14,null,null,0,0.2]
[15,null,null,0,0.2]
[16,null,null,0,0.2]
[17,null,null,0,0.2]
[18,null,null,0,0.2]
[19,null,null,0,0.2]
[20,null,null,0,0.2]
[21,null,null,0,0.2]
[22,null,null,0,0.2]
[23,null,null,0,0.2]
[24,null,null,0,0.2]
[25,null,null,0,0.2]
[26,null,null,0,0.2]
[27,null,null,0,0.2]
[28,null,null,0,0.2]
[29,null,null,0,0.2]
[30,null,null,0,0.2]
[31,null,null,0,0.2]
[32,null,null,0,0.2]
[33,null,null,0,0.2]
[34,null,null,0,0.2]
[35,null,null,0,0.2]
[36,null,null,0,0.2]
[37,null,null,0,0.2]
[38,null,null,0,0.2]
[39,null,null,0,0.2]
[40,null,null,0,0.2]
[41,null,null,0,0.2]
[42,null,null,0,0.2]
[43,null,null,0,0.2]
[44,null,null,0,0.2]
[45,null,null,0,0.2]
[46,null,null,0,0.2]
[47,null,null,0,0.2]
[48,null,null,0,0.2]
[49,null,null,0,0.2]
[50,null,null,0,0.2]
[51,null,null,0,0.2]
[52,null,null,0,0.2]
[53,null,null,0,0.2]
[54,null,null,0,0.2]
[55,null,null,0,0.2]
[56,null,null,0,0.2]
[57,null,null,0,0.2]
[58,null,null,0,0.2]
[59,null,null,0,0.2]
[60,null,null,{"$f":"(IF($C$3=\"ja\",C65/(1+E65),\"\"))","v":0},0.2]
[61,null,null,{"$f":"(IF($C$3=\"ja\",C66/(1+E66),\"\"))","v":0},0.2]
[62,null,null,0,0.2]
[63,null,null,0,0.2]
[64,null,null,0,0.2]
[65,null,null,0,0.2]
[66,null,null,0,0.2]
[67,null,null,0,0.2]
[68,null,null,0,0.2]
[69,null,null,0,0.2]
[70,null,null,0,0.2]
[71,null,null,0,0.2]
[72,null,null,0,0.2]
[73,null,null,0,0.2]
[74,null,null,0,0.2]
[75,null,null,0,0.2]
[76,null,null,0,0.2]
[77,null,null,0,0.2]
[78,null,null,0,0.2]
[79,null,null,0,0.2]
[80,null,null,0,0.2]
[81,null,null,0,0.2]
[82,null,null,0,0.2]
[83,null,null,0,0.2]
[84,null,null,0,0.2]
[85,null,null,0,0.2]
[86,null,null,0,0.2]
[87,null,null,0,0.2]
[88,null,null,0,0.2]
[89,null,null,0,0.2]
[90,null,null,0,0.2]
[91,null,null,0,0.2]
[92,null,null,0,0.2]
[93,null,null,0,0.2]
[94,null,null,0,0.2]
[95,null,null,0,0.2]
[96,null,null,0,0.2]
[97,null,null,0,0.2]
[98,null,null,0,0.2]
[99,null,null,0,0.2]
[100,null,null,{"$f":"(IF($C$3=\"ja\",C105/(1+E105),\"\"))","v":0},0.2]
[101,null,null,{"$f":"(IF($C$3=\"ja\",C106/(1+E106),\"\"))","v":0},0.2]
[102,null,null,0,0.2]
[103,null,null,0,0.2]
[104,null,null,0,0.2]
[105,null,null,0,0.2]
[106,null,null,0,0.2]
[107,null,null,0,0.2]
[108,null,null,0,0.2]
[109,null,null,0,0.2]
[110,null,null,0,0.2]
[111,null,null,0,0.2]
[112,null,null,0,0.2]
[113,null,null,0,0.2]
[114,null,null,0,0.2]
[115,null,null,0,0.2]
[116,null,null,0,0.2]
[117,null,null,0,0.2]
[118,null,null,0,0.2]
[119,null,null,0,0.2]
[120,null,null,0,0.2]
[121,null,null,0,0.2]
[122,null,null,0,0.2]
[123,null,null,0,0.2]
[124,null,null,0,0.2]
[125,null,null,0,0.2]
[126,null,null,0,0.2]
[127,null,null,0,0.2]
[128,null,null,0,0.2]
[129,null,null,0,0.2]
[130,null,null,0,0.2]
[131,null,null,0,0.2]
[132,null,null,0,0.2]
[133,null,null,0,0.2]
[134,null,null,0,0.2]
[135,null,null,0,0.2]
[136,null,null,0,0.2]
[137,null,null,0,0.2]
[138,null,null,0,0.2]
[139,null,null,0,0.2]
[140,null,null,0,0.2]
[141,null,null,0,0.2]
[142,null,null,0,0.2]
[143,null,null,0,0.2]
[144,null,null,0,0.2]
[145,null,null,0,0.2]
[146,null,null,0,0.2]
[147,null,null,0,0.2]
[148,null,null,0,0.2]
[149,null,null,0,0.2]
[150,null,null,0,0.2]
[151,null,null,0,0.2]
[152,null,null,0,0.2]
[153,null,null,0,0.2]
[154,null,null,0,0.2]
[155,null,null,0,0.2]
[156,null,null,0,0.2]
[157,null,null,0,0.2]
[158,null,null,0,0.2]
[159,null,null,0,0.2]
[160,null,null,0,0.2]
[161,null,null,0,0.2]
[162,null,null,0,0.2]
[163,null,null,0,0.2]
[164,null,null,0,0.2]
[165,null,null,{"$f":"(IF($C$3=\"ja\",C170/(1+E170),\"\"))","v":0},0.2]
[166,null,null,0,0.2]
[167,null,null,0,0.2]
[168,null,null,0,0.2]
[169,null,null,0,0.2]
[170,null,null,0,0.2]
[171,null,null,0,0.2]
[172,null,null,0,0.2]
[173,null,null,0,0.2]
[174,null,null,0,0.2]
[175,null,null,0,0.2]
[176,null,null,0,0.2]
[177,null,null,0,0.2]
[178,null,null,0,0.2]
[179,null,null,0,0.2]
[180,null,null,0,0.2]
[181,null,null,0,0.2]
[182,null,null,0,0.2]
[183,null,null,0,0.2]
[184,null,null,0,0.2]
[185,null,null,0,0.2]
[186,null,null,0,0.2]
[187,null,null,0,0.2]
[188,null,null,0,0.2]
[189,null,null,0,0.2]
[190,null,null,0,0.2]
[191,null,null,0,0.2]
[192,null,null,0,0.2]
[193,null,null,0,0.2]
[194,null,null,0,0.2]
[195,null,null,0,0.2]
[196,null,null,0,0.2]
[197,null,null,0,0.2]
[198,null,null,0,0.2]
[199,null,null,0,0.2]
[200,null,null,0,0.2]
[null,null,null,{"$f":"IF(C3=\"ja\",SUM(D6:D205),SUM(C6:C205))","v":0}]
[]
["Wenn Sie mehr als 20 Zeilen benötigen, drücken Sie den + Button links außen. Um diese Funktion zu nutzen, müssen Sie gegenenfalls Makros zulassen, sofern diese durch Ihre Sicherheitseinstellungen gesperrt sind."]

{"sheet":"Sachkosten Ist","index":4,"n_rows":208,"n_cols":10,"rows_kept":208,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,2],[207,0,207,6]]}
["Sachkosten Ist"]
[]
["Vorsteuerabzug",null,null,null,null,{"$f":"Titelblatt!B12","v":"ja"}]
[]
["lfd. Nr.","interne Belegnr.","Bezeichnung","Rechnungsdatum","Zahlungsdatum","Kosten brutto (abzgl. Skonto)","Kosten netto (abzgl. Skonto)","Ust.-Satz","Prüfungsanmerkungen","anerkannte Kosten"]
[1,null,null,null,null,null,{"$f":"(IF($F$3=\"ja\",F6/(1+H6),\"\"))","v":0},0.2,null,{"$f":"IF($F$3=\"ja\",G6,F6)","v":0}]
[2,null,null,null,null,null,{"$f":"(IF($F$3=\"ja\",F7/(1+H7),\"\"))","v":0},0.2,null,{"$f":"IF($F$3=\"ja\",G7,F7)","v":0}]
[3,null,null,null,null,null,0,0.2,null,0]
[4,null,null,null,null,null,0,0.2,null,0]
[5,null,null,null,null,null,0,0.2,null,0]
[6,null,null,null,null,null,0,0.2,null,0]
[7,null,null,null,null,null,0,0.2,null,0]
[8,null,null,null,null,null,0,0.2,null,0]
[9,null,null,null,null,null,0,0.2,null,0]
[10,null,null,null,null,null,0,0.2,null,0]
[11,null,null,null,null,null,0,0.2,null,0]
[12,null,null,null,null,null,0,0.2,null,0]
[13,null,null,null,null,null,0,0.2,null,0]
[14,null,null,null,null,null,0,0.2,null,0]
[15,null,null,null,null,null,0,0.2,null,0]
[16,null,null,null,null,null,0,0.2,null,0]
[17,null,null,null,null,null,0,0.2,null,0]
[18,null,null,null,null,null,0,0.2,null,0]
[19,null,null,null,null,null,0,0.2,null,0]
[20,null,null,null,null,null,0,0.2,null,0]
[21,null,null,null,null,null,0,0.2,null,0]
[22,null,null,null,null,null,0,0.2,null,0]
[23,null,null,null,null,null,0,0.2,null,0]
[24,null,null,null,null,null,0,0.2,null,0]
[25,null,null,null,null,null,0,0.2,null,0]
[26,null,null,null,null,null,0,0.2,null,0]
[27,null,null,null,null,null,0,0.2,null,0]
[28,null,null,null,null,null,0,0.2,null,0]
[29,null,null,null,null,null,0,0.2,null,0]
[30,null,null,null,null,null,0,0.2,null,0]
[31,null,null,null,null,null,0,0.2,null,0]
[32,null,null,null,null,null,0,0.2,null,0]
[33,null,null,null,null,null,0,0.2,null,0]
[34,null,null,null,null,null,0,0.2,null,0]
[35,null,null,null,null,null,0,0.2,null,0]
[36,null,null,null,null,null,0,0.2,null,0]
[37,null,null,null,null,null,0,0.2,null,0]
[38,null,null,null,null,null,0,0.2,null,0]
[39,null,null,null,null,null,0,0.2,null,0]
[40,null,null,null,null,null,0,0.2,null,0]
[41,null,null,null,null,null,0,0.2,null,0]
[42,null,null,null,null,null,0,0.2,null,0]
[43,null,null,null,null,null,0,0.2,null,0]
[44,null,null,null,null,null,0,0.2,null,0]
[45,null,null,null,null,null,0,0.2,null,0]
[46,null,null,null,null,null,0,0.2,null,0]
[47,null,null,null,null,null,0,0.2,null,0]
[48,null,null,null,null,null,0,0.2,null,0]
[49,null,null,null,null,null,0,0.2,null,0]
[50,null,null,null,null,null,0,0.2,null,0]
[51,null,null,null,null,null,0,0.2,null,0]
[52,null,null,null,null,null,0,0.2,null,0]
[53,null,null,null,null,null,0,0.2,null,0]
[54,null,null,null,null,null,0,0.2,null,0]
[55,null,null,null,null,null,0,0.2,null,0]
[56,null,null,null,null,null,0,0.2,null,0]
[57,null,null,null,null,null,0,0.2,null,0]
[58,null,null,null,null,null,0,0.2,null,0]
[59,null,null,null,null,null,0,0.2,null,0]
[60,null,null,null,null,null,0,0.2,null,0]
[61,null,null,null,null,null,0,0.2,null,0]
[62,null,null,null,null,null,0,0.2,null,0]
[63,null,null,null,null,null,0,0.2,null,0]
[64,null,null,null,null,null,0,0.2,null,0]
[65,null,null,null,null,null,0,0.2,null,0]
[66,null,null,null,null,null,{"$f":"(IF($F$3=\"ja\",F71/(1+H71),\"\"))","v":0},0.2,null,{"$f":"IF($F$3=\"ja\",G71,F71)","v":0}]
[67,null,null,null,null,null,0,0.2,null,0]
[68,null,null,null,null,null,0,0.2,null,0]
[69,null,null,null,null,null,0,0.2,null,0]
[70,null,null,null,null,null,0,0.2,null,0]
[71,null,null,null,null,null,0,0.2,null,0]
[72,null,null,null,null,null,0,0.2,null,0]
[73,null,null,null,null,null,0,0.2,null,0]
[74,null,null,null,null,null,0,0.2,null,0]
[75,null,null,null,null,null,0,0.2,null,0]
[76,null,null,null,null,null,0,0.2,null,0]
[77,null,null,null,null,null,0,0.2,null,0]
[78,null,null,null,null,null,0,0.2,null,0]
[79,null,null,null,null,null,0,0.2,null,0]
[80,null,null,null,null,null,0,0.2,null,0]
[81,null,null,null,null,null,0,0.2,null,0]
[82,null,null,null,null,null,0,0.2,null,0]
[83,null,null,null,null,null,0,0.2,null,0]
[84,null,null,null,null,null,0,0.2,null,0]
[85,null,null,null,null,null,0,0.2,null,0]
[86,null,null,null,null,null,0,0.2,null,0]
[87,null,null,null,null,null,0,0.2,null,0]
[88,null,null,null,null,null,0,0.2,null,0]
[89,null,null,null,null,null,0,0.2,null,0]
[90,null,null,null,null,null,0,0.2,null,0]
[91,null,null,null,null,null,0,0.2,null,0]
[92,null,null,null,null,null,0,0.2,null,0]
[93,null,null,null,null,null,0,0.2,null,0]
[94,null,null,null,null,null,0,0.2,null,0]
[95,null,null,null,null,null,0,0.2,null,0]
[96,null,null,null,null,null,0,0.2,null,0]
[97,null,null,null,null,null,0,0.2,null,0]
[98,null,null,null,null,null,0,0.2,null,0]
[99,null,null,null,null,null,0,0.2,null,0]
[100,null,null,null,null,null,0,0.2,null,0]
[101,null,null,null,null,null,0,0.2,null,0]
[102,null,null,null,null,null,0,0.2,null,0]
[103,null,null,null,null,null,0,0.2,null,0]
[104,null,null,null,null,null,0,0.2,null,0]
[105,null,null,null,null,null,0,0.2,null,0]
[106,null,null,null,null,null,0,0.2,null,0]
[107,null,null,null,null,null,0,0.2,null,0]
[108,null,null,null,null,null,0,0.2,null,0]
[109,null,null,null,null,null,0,0.2,null,0]
[110,null,null,null,null,null,0,0.2,null,0]
[111,null,null,null,null,null,0,0.2,null,0]
[112,null,null,null,null,null,0,0.2,null,0]
[113,null,null,null,null,null,0,0.2,null,0]
[114,null,null,null,null,null,0,0.2,null,0]
[115,null,null,null,null,null,0,0.2,null,0]
[116,null,null,null,null,null,0,0.2,null,0]
[117,null,null,null,null,null,0,0.2,null,0]
[118,null,null,null,null,null,0,0.2,null,0]
[119,null,null,null,null,null,0,0.2,null,0]
[120,null,null,null,null,null,0,0.2,null,0]
[121,null,null,null,null,null,0,0.2,null,0]
[122,null,null,null,null,null,0,0.2,null,0]
[123,null,null,null,null,null,0,0.2,null,0]
[124,null,null,null,null,null,0,0.2,null,0]
[125,null,null,null,null,null,0,0.2,null,0]
[126,null,null,null,null,null,0,0.2,null,0]
[127,null,null,null,null,null,0,0.2,null,0]
[128,null,null,null,null,null,0,0.2,null,0]
[129,null,null,null,null,null,0,0.2,null,0]
[130,null,null,null,null,null,0,0.2,null,{"$f":"IF($F$3=\"ja\",G135,F135)","v":0}]
[131,null,null,null,null,null,0,0.2,null,0]
[132,null,null,null,null,null,0,0.2,null,0]
[133,null,null,null,null,null,0,0.2,null,0]
[134,null,null,null,null,null,0,0.2,null,0]
[135,null,null,null,null,null,0,0.2,null,0]
[136,null,null,null,null,null,0,0.2,null,0]
[137,null,null,null,null,null,0,0.2,null,0]
[138,null,null,null,null,null,0,0.2,null,0]
[139,null,null,null,null,null,0,0.2,null,0]
[140,null,null,null,null,null,0,0.2,null,0]
[141,null,null,null,null,null,0,0.2,null,0]
[142,null,null,null,null,null,0,0.2,null,0]
[143,null,null,null,null,null,0,0.2,null,0]
[144,null,null,null,null,null,0,0.2,null,0]
[145,null,null,null,null,null,0,0.2,null,0]
[146,null,null,null,null,null,0,0.2,null,0]
[147,null,null,null,null,null,0,0.2,null,0]
[148,null,null,null,null,null,0,0.2,null,0]
[149,null,null,null,null,null,0,0.2,null,0]
[150,null,null,null,null,null,0,0.2,null,0]
[151,null,null,null,null,null,0,0.2,null,0]
[152,null,null,null,null,null,0,0.2,null,0]
[153,null,null,null,null,null,0,0.2,null,0]
[154,null,null,null,null,null,0,0.2,null,0]
[155,null,null,null,null,null,0,0.2,null,0]
[156,null,null,null,null,null,0,0.2,null,0]
[157,null,null,null,null,null,0,0.2,null,0]
[158,null,null,null,null,null,0,0.2,null,0]
[159,null,null,null,null,null,0,0.2,null,0]
[160,null,null,null,null,null,0,0.2,null,0]
[161,null,null,null,null,null,0,0.2,null,0]
[162,null,null,null,null,null,0,0.2,null,0]
[163,null,null,null,null,null,0,0.2,null,0]
[164,null,null,null,null,null,0,0.2,null,0]
[165,null,null,null,null,null,0,0.2,null,0]
[166,null,null,null,null,null,0,0.2,null,0]
[167,null,null,null,null,null,0,0.2,null,0]
[168,null,null,null,null,null,0,0.2,null,0]
[169,null,null,null,null,null,0,0.2,null,0]
[170,null,null,null,null,null,0,0.2,null,0]
[171,null,null,null,null,null,0,0.2,null,0]
[172,null,null,null,null,null,0,0.2,null,0]
[173,null,null,null,null,null,0,0.2,null,0]
[174,null,null,null,null,null,0,0.2,null,0]
[175,null,null,null,null,null,0,0.2,null,0]
[176,null,null,null,null,null,0,0.2,null,0]
[177,null,null,null,null,null,0,0.2,null,0]
[178,null,null,null,null,null,0,0.2,null,0]
[179,null,null,null,null,null,0,0.2,null,0]
[180,null,null,null,null,null,0,0.2,null,0]
[181,null,null,null,null,null,0,0.2,null,0]
[182,null,null,null,null,null,0,0.2,null,0]
[183,null,null,null,null,null,0,0.2,null,0]
[184,null,null,null,null,null,0,0.2,null,0]
[185,null,null,null,null,null,0,0.2,null,0]
[186,null,null,null,null,null,0,0.2,null,0]
[187,null,null,null,null,null,0,0.2,null,0]
[188,null,null,null,null,null,0,0.2,null,0]
[189,null,null,null,null,null,0,0.2,null,0]
[190,null,null,null,null,null,0,0.2,null,0]
[191,null,null,null,null,null,0,0.2,null,0]
[192,null,null,null,null,null,0,0.2,null,0]
[193,null,null,null,null,null,0,0.2,null,0]
[194,null,null,null,null,null,0,0.2,null,{"$f":"IF($F$3=\"ja\",G199,F199)","v":0}]
[195,null,null,null,null,null,0,0.2,null,0]
[196,null,null,null,null,null,0,0.2,null,0]
[197,null,null,null,null,null,0,0.2,null,0]
[198,null,null,null,null,null,0,0.2,null,0]
[199,null,null,null,null,null,{"$f":"(IF($F$3=\"ja\",F204/(1+H204),\"\"))","v":0},0.2,null,0]
[200,null,null,null,null,null,0,0.2,null,0]
[null,null,null,null,null,null,{"$f":"IF(F3=\"ja\",SUM(G6:G205),SUM(F6:F205))","v":0},null,null,{"$f":"SUM(J6:J205)","v":0}]
[]
["Wenn Sie mehr als 20 Zeilen benötigen, drücken Sie den + Button links außen. Um diese Funktion zu nutzen, müssen Sie gegenenfalls Makros zulassen, sofern diese durch Ihre Sicherheitseinstellungen gesperrt sind."]

{"sheet":"Investitionen Plan","index":5,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,1],[3,0,3,1]]}
["Investitionen Plan"]
[]
["Projektdauer in Monaten",null,null,null,{"$f":"Titelblatt!B10","v":24}]
["Vorsteuerabzug",null,null,null,{"$f":"Titelblatt!B12","v":"ja"}]
[]
["lfd. Nr.","Bezeichnung","Nutzungsdauer in Jahren","Nutzungsdauer in Monaten","Anschaffungs-kosten brutto","Anschaffungs-kosten netto","Ust.-Satz","zu fördernder Wert"]
[1,null,null,{"$f":"C7*12","v":0},null,{"$f":"(IF($E$4=\"ja\",E7/(1+G7),\"\"))","v":0},0.2,{"$f":"IF(D7<>0,IF($E$4=\"nein\",E7/I7*$E$3,F7/I7*$E$3),\"\")","v":""},{"$f":"IF(D7<=$E$3,$E$3,D7)","v":24}]
[2,null,null,{"$f":"C8*12","v":0},null,{"$f":"(IF($E$4=\"ja\",E8/(1+G8),\"\"))","v":0},0.2,{"$f":"IF(D8<>0,IF($E$4=\"nein\",E8/I8*$E$3,F8/I8*$E$3),\"\")","v":""},{"$f":"IF(D8<=$E$3,$E$3,D8)","v":24}]
[3,null,null,0,null,0,0.2,"",24]
[4,null,null,0,null,0,0.2,"",24]
[5,null,null,0,null,0,0.2,"",24]
[6,null,null,0,null,0,0.2,"",24]
[7,null,null,0,null,0,0.2,"",24]
[8,null,null,0,null,0,0.2,"",24]
[9,null,null,0,null,0,0.2,"",24]
[10,null,null,0,null,0,0.2,"",24]
[11,null,null,0,null,0,0.2,"",24]
[12,null,null,0,null,0,0.2,"",24]
[13,null,null,0,null,0,0.2,"",24]
[14,null,null,0,null,0,0.2,"",24]
[15,null,null,0,null,0,0.2,"",24]
[16,null,null,0,null,0,0.2,"",24]
[17,null,null,0,null,0,0.2,"",24]
[18,null,null,0,null,0,0.2,"",24]
[19,null,null,0,null,0,0.2,"",24]
[20,null,null,0,null,0,0.2,"",24]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H26)","v":0}]

{"sheet":"Investitionen Ist","index":6,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,1],[3,0,3,1]]}
["Investitionen Ist"]
[]
["Projektdauer in Monaten",null,null,null,{"$f":"Titelblatt!B10","v":24}]
["Vorsteuerabzug",null,null,null,{"$f":"Titelblatt!B12","v":"ja"}]
[]
["lfd. Nr.","Bezeichnung","Nutzungsdauer in Jahren","Nutzungsdauer in Monaten","Anschaffungs-kosten brutto","Anschaffungs-kosten netto","Ust.-Satz","zu fördernder Wert","Prüfungsanmerkungen","anerkannte Kosten"]
[1,null,null,{"$f":"C7*12","v":0},null,{"$f":"(IF($E$4=\"ja\",E7/(1+G7),\"\"))","v":0},0.2,{"$f":"IF(D7<>0,IF($E$4=\"nein\",E7/K7*$E$3,F7/K7*$E$3),\"\")","v":""},null,{"$f":"+H7","v":""},{"$f":"IF(D7<=$E$3,$E$3,D7)","v":24}]
[2,null,null,{"$f":"C8*12","v":0},null,{"$f":"(IF($E$4=\"ja\",E8/(1+G8),\"\"))","v":0},0.2,{"$f":"IF(D8<>0,IF($E$4=\"nein\",E8/K8*$E$3,F8/K8*$E$3),\"\")","v":""},null,{"$f":"+H8","v":""},{"$f":"IF(D8<=$E$3,$E$3,D8)","v":24}]
[3,null,null,0,null,0,0.2,"",null,"",24]
[4,null,null,0,null,0,0.2,"",null,"",24]
[5,null,null,0,null,0,0.2,"",null,"",24]
[6,null,null,0,null,0,0.2,"",null,"",24]
[7,null,null,0,null,0,0.2,"",null,"",24]
[8,null,null,0,null,0,0.2,"",null,"",24]
[9,null,null,0,null,0,0.2,"",null,"",24]
[10,null,null,0,null,0,0.2,"",null,"",24]
[11,null,null,0,null,0,0.2,"",null,"",24]
[12,null,null,0,null,0,0.2,"",null,"",24]
[13,null,null,0,null,0,0.2,"",null,"",24]
[14,null,null,0,null,0,0.2,"",null,"",24]
[15,null,null,0,null,0,0.2,"",null,"",24]
[16,null,null,0,null,0,0.2,"",null,"",24]
[17,null,null,0,null,0,0.2,"",null,"",24]
[18,null,null,0,null,0,0.2,"",null,"",24]
[19,null,null,0,null,0,0.2,"",null,"",24]
[20,null,null,0,null,0,0.2,"",null,"",24]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H26)","v":0},null,{"$f":"SUM(J7:J26)","v":0}]

{"sheet":"Maschinenstundensatz Plan","index":7,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,1],[39,0,40,4]]}
["Maschinenstundensatz Plan"]
[]
[]
["Kalkulation in Stunden (Die Berechnung des Maschinenstundensatzes muss beigelegt werden)"]
[]
[]
["lfd. Nr.","Bezeichnung der F&E-Infrastruktur ","Maschinen-stundensatz (EUR)","Nutzungsdauer im Berichtszeitraum (Stunden)","Nutzungs-\nKosten"]
[1,null,null,null,{"$f":"IF(ISERROR(C8*D8),\" \",(C8*D8))","v":0}]
[2,null,null,null,0]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
[11,null,null,null,0]
[12,null,null,null,0]
[13,null,null,null,0]
[14,null,null,null,0]
[15,null,null,null,0]
[16,null,null,null,0]
[17,null,null,null,0]
[18,null,null,null,0]
[19,null,null,null,0]
[20,null,null,null,0]
[21,null,null,null,0]
[22,null,null,null,0]
[23,null,null,null,0]
[24,null,null,null,0]
[25,null,null,null,0]
[26,null,null,null,0]
[27,null,null,null,0]
[28,null,null,null,0]
[29,null,null,null,0]
[30,null,null,null,0]
[null,null,null,null,{"$f":"SUM(E8:E37)","v":0}]
[]
["Nutzungsdauer im Berichtszeitraum (Stunden): Der Nachweis der projektrelevanten Maschinenstunden ist zB durch ein Maschinenstundenbuch zu erbringen."]

{"sheet":"Maschinenstundensatz Ist","index":8,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,1],[38,0,39,4]]}
["Maschinenstundensatz Ist"]
[]
[]
["Kalkulation in Stunden (Die Berechnung des Maschinenstundensatzes muss beigelegt werden)"]
[]
["lfd. Nr.","Bezeichnung der F&E-Infrastruktur ","Maschinenstundensatz (EUR)","Nutzungsdauer im Berichtszeitraum (Stunden)","Nutzungs-\nKosten","Prüfungsanmerkungen","anerkannte Kosten"]
[1,null,null,null,{"$f":"IF(ISERROR(C7*D7),\" \",(C7*D7))","v":0},null,{"$f":"+E7","v":0}]
[2,null,null,null,0,null,{"$f":"+E8","v":0}]
[3,null,null,null,0,null,0]
[4,null,null,null,0,null,0]
[5,null,null,null,0,null,0]
[6,null,null,null,0,null,0]
[7,null,null,null,0,null,0]
[8,null,null,null,0,null,0]
[9,null,null,null,0,null,0]
[10,null,null,null,0,null,0]
[11,null,null,null,0,null,0]
[12,null,null,null,0,null,0]
[13,null,null,null,0,null,0]
[14,null,null,null,0,null,0]
[15,null,null,null,0,null,0]
[16,null,null,null,0,null,0]
[17,null,null,null,0,null,0]
[18,null,null,null,0,null,0]
[19,null,null,null,0,null,0]
[20,null,null,null,0,null,0]
[21,null,null,null,0,null,0]
[22,null,null,null,0,null,0]
[23,null,null,null,0,null,0]
[24,null,null,null,0,null,0]
[25,null,null,null,0,null,0]
[26,null,null,null,0,null,0]
[27,null,null,null,0,null,0]
[28,null,null,null,0,null,0]
[29,null,null,null,0,null,0]
[30,null,null,null,0,null,0]
[null,null,null,null,{"$f":"SUM(E7:E36)","v":0},null,{"$f":"SUM(G7:G36)","v":0}]
[]
["Nutzungsdauer im Berichtszeitraum (Stunden): Der Nachweis der projektrelevanten Maschinenstunden ist zB durch ein Maschinenstundenbuch zu erbringen."]