{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["EVN","Berechnung"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"EVN","index":0,"n_rows":103,"n_cols":12,"rows_kept":103,"cut":false,"hidden":false,"merged":[[2,1,2,10],[3,1,3,10]]}
[]
[]
[null,"Endverwendungsnachweis"]
[null,"über getätigte Ausgaben im Rahmen der ESF-Teilaktion 23.10asz08.01.3."]
[]
[null,"I","Projektdaten"]
[]
[null,null,null,null,"Bezeichnung des Projektes:  ",{"$f":"IF(Berechnung!D5=\"\",\"\",Berechnung!D5)","v":""}]
[null,null,null,null,"Genehmigungszeitraum:  ",{"$f":"IF(Berechnung!$D6=\"\",\"\",Berechnung!$D6)","v":""},{"$f":"IF(Berechnung!$D7=\"\",\"\",\"bis\")","v":""},{"$f":"IF(Berechnung!$D7=\"\",\"\",Berechnung!$D7)","v":""}]
[null,null,null,null,"Projektleiter/-in:  ",{"$f":"IF(Berechnung!D8=\"\",\"\",Berechnung!D8)","v":""}]
[null,null,null,null,"EU-Registriernummer:  ",{"$f":"IF(Berechnung!D9=\"\",\"\",Berechnung!D9)","v":""}]
[null,null,null,null,"Antragstellende Einrichtung:  ",{"$f":"IF(Berechnung!D10=\"\",\"\",Berechnung!D10)","v":""}]
[]
[]
[]
[null,"II","Endverwendungsnachweis"]
[]
[null,"II.1","Höhe der Mittel gemäß Erstgenehmigung"]
[]
[null,null,null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"Summen",{"$f":"Berechnung!E18","v":0},{"$f":"Berechnung!F18","v":0},{"$f":"Berechnung!G18","v":0},{"$f":"Berechnung!H18","v":0},{"$f":"Berechnung!I18","v":0},{"$f":"Berechnung!J18","v":0},{"$f":"Berechnung!K18","v":0},{"$f":"Berechnung!L18","v":0},{"$f":"Berechnung!M18","v":0}]
[null,null,2016,{"$f":"Berechnung!E19","v":0},{"$f":"Berechnung!F19","v":0},{"$f":"Berechnung!G19","v":0},{"$f":"Berechnung!H19","v":0},{"$f":"Berechnung!I19","v":0},{"$f":"Berechnung!J19","v":0},{"$f":"Berechnung!K19","v":0},{"$f":"Berechnung!L19","v":0},{"$f":"Berechnung!M19","v":0}]
[null,null,2017,{"$f":"Berechnung!E20","v":0},{"$f":"Berechnung!F20","v":0},{"$f":"Berechnung!G20","v":0},{"$f":"Berechnung!H20","v":0},{"$f":"Berechnung!I20","v":0},{"$f":"Berechnung!J20","v":0},{"$f":"Berechnung!K20","v":0},{"$f":"Berechnung!L20","v":0},{"$f":"Berechnung!M20","v":0}]
[null,null,2018,{"$f":"Berechnung!E21","v":0},{"$f":"Berechnung!F21","v":0},{"$f":"Berechnung!G21","v":0},{"$f":"Berechnung!H21","v":0},{"$f":"Berechnung!I21","v":0},{"$f":"Berechnung!J21","v":0},{"$f":"Berechnung!K21","v":0},{"$f":"Berechnung!L21","v":0},{"$f":"Berechnung!M21","v":0}]
[null,null,2019,{"$f":"Berechnung!E22","v":0},{"$f":"Berechnung!F22","v":0},{"$f":"Berechnung!G22","v":0},{"$f":"Berechnung!H22","v":0},{"$f":"Berechnung!I22","v":0},{"$f":"Berechnung!J22","v":0},{"$f":"Berechnung!K22","v":0},{"$f":"Berechnung!L22","v":0},{"$f":"Berechnung!M22","v":0}]
[null,null,2020,{"$f":"Berechnung!E23","v":0},{"$f":"Berechnung!F23","v":0},{"$f":"Berechnung!G23","v":0},{"$f":"Berechnung!H23","v":0},{"$f":"Berechnung!I23","v":0},{"$f":"Berechnung!J23","v":0},{"$f":"Berechnung!K23","v":0},{"$f":"Berechnung!L23","v":0},{"$f":"Berechnung!M23","v":0}]
[null,null,2021,{"$f":"Berechnung!E24","v":0},{"$f":"Berechnung!F24","v":0},{"$f":"Berechnung!G24","v":0},{"$f":"Berechnung!H24","v":0},{"$f":"Berechnung!I24","v":0},{"$f":"Berechnung!J24","v":0},{"$f":"Berechnung!K24","v":0},{"$f":"Berechnung!L24","v":0},{"$f":"Berechnung!M24","v":0}]
[null,null,2022,{"$f":"Berechnung!E25","v":0},{"$f":"Berechnung!F25","v":0},{"$f":"Berechnung!G25","v":0},{"$f":"Berechnung!H25","v":0},{"$f":"Berechnung!I25","v":0},{"$f":"Berechnung!J25","v":0},{"$f":"Berechnung!K25","v":0},{"$f":"Berechnung!L25","v":0},{"$f":"Berechnung!M25","v":0}]
[null,null,2023,{"$f":"Berechnung!E26","v":0},{"$f":"Berechnung!F26","v":0},{"$f":"Berechnung!G26","v":0},{"$f":"Berechnung!H26","v":0},{"$f":"Berechnung!I26","v":0},{"$f":"Berechnung!J26","v":0},{"$f":"Berechnung!K26","v":0},{"$f":"Berechnung!L26","v":0},{"$f":"Berechnung!M26","v":0}]
[]
[null,"II.2","Nachbeantragung"]
[null,null,null,null,"Mittelnachbeantragung ist","nicht erfolgt."]
[]
[null,null,null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"Summen",{"$f":"Berechnung!E31","v":0},{"$f":"Berechnung!F31","v":0},{"$f":"Berechnung!G31","v":0},{"$f":"Berechnung!H31","v":0},{"$f":"Berechnung!I31","v":0},{"$f":"Berechnung!J31","v":0},{"$f":"Berechnung!K31","v":0},{"$f":"Berechnung!L31","v":0},{"$f":"Berechnung!M31","v":0}]
[null,null,2016,{"$f":"Berechnung!E32","v":0},{"$f":"Berechnung!F32","v":0},{"$f":"Berechnung!G32","v":0},{"$f":"Berechnung!H32","v":0},{"$f":"Berechnung!I32","v":0},{"$f":"Berechnung!J32","v":0},{"$f":"Berechnung!K32","v":0},{"$f":"Berechnung!L32","v":0},{"$f":"Berechnung!M32","v":0}]
[null,null,2017,{"$f":"Berechnung!E33","v":0},{"$f":"Berechnung!F33","v":0},{"$f":"Berechnung!G33","v":0},{"$f":"Berechnung!H33","v":0},{"$f":"Berechnung!I33","v":0},{"$f":"Berechnung!J33","v":0},{"$f":"Berechnung!K33","v":0},{"$f":"Berechnung!L33","v":0},{"$f":"Berechnung!M33","v":0}]
[null,null,2018,{"$f":"Berechnung!E34","v":0},{"$f":"Berechnung!F34","v":0},{"$f":"Berechnung!G34","v":0},{"$f":"Berechnung!H34","v":0},{"$f":"Berechnung!I34","v":0},{"$f":"Berechnung!J34","v":0},{"$f":"Berechnung!K34","v":0},{"$f":"Berechnung!L34","v":0},{"$f":"Berechnung!M34","v":0}]
[null,null,2019,{"$f":"Berechnung!E35","v":0},{"$f":"Berechnung!F35","v":0},{"$f":"Berechnung!G35","v":0},{"$f":"Berechnung!H35","v":0},{"$f":"Berechnung!I35","v":0},{"$f":"Berechnung!J35","v":0},{"$f":"Berechnung!K35","v":0},{"$f":"Berechnung!L35","v":0},{"$f":"Berechnung!M35","v":0}]
[null,null,2020,{"$f":"Berechnung!E36","v":0},{"$f":"Berechnung!F36","v":0},{"$f":"Berechnung!G36","v":0},{"$f":"Berechnung!H36","v":0},{"$f":"Berechnung!I36","v":0},{"$f":"Berechnung!J36","v":0},{"$f":"Berechnung!K36","v":0},{"$f":"Berechnung!L36","v":0},{"$f":"Berechnung!M36","v":0}]
[null,null,2021,{"$f":"Berechnung!E37","v":0},{"$f":"Berechnung!F37","v":0},{"$f":"Berechnung!G37","v":0},{"$f":"Berechnung!H37","v":0},{"$f":"Berechnung!I37","v":0},{"$f":"Berechnung!J37","v":0},{"$f":"Berechnung!K37","v":0},{"$f":"Berechnung!L37","v":0},{"$f":"Berechnung!M37","v":0}]
[null,null,2022,{"$f":"Berechnung!E38","v":0},{"$f":"Berechnung!F38","v":0},{"$f":"Berechnung!G38","v":0},{"$f":"Berechnung!H38","v":0},{"$f":"Berechnung!I38","v":0},{"$f":"Berechnung!J38","v":0},{"$f":"Berechnung!K38","v":0},{"$f":"Berechnung!L38","v":0},{"$f":"Berechnung!M38","v":0}]
[null,null,2023,{"$f":"Berechnung!E39","v":0},{"$f":"Berechnung!F39","v":0},{"$f":"Berechnung!G39","v":0},{"$f":"Berechnung!H39","v":0},{"$f":"Berechnung!I39","v":0},{"$f":"Berechnung!J39","v":0},{"$f":"Berechnung!K39","v":0},{"$f":"Berechnung!L39","v":0},{"$f":"Berechnung!M39","v":0}]
[]
[]
[null,null,"Abkürzungen:"]
[null,null,"PK PL","Personalkosten Projektleitung",null,null,"RK PL","Reisekosten Referenten"]
[null,null,"RK PL","Reisekosten Projektleitung",null,null,"Hon","Honorare Referenten"]
[null,null,"SK PL","Sachkosten Projektleitung",null,null,"RM","Raumanmietung"]
[null,null,"RK PL","Reisekosten Teilnehmer",null,null,"LLM","Lehr- und Lernmittel"]
[]
[]
[]
[]
[null,"II.2a","Summe der beantragten Mittel"]
[]
[null,null,null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"Summen",{"$f":"Berechnung!E44","v":0},{"$f":"Berechnung!F44","v":0},{"$f":"Berechnung!G44","v":0},{"$f":"Berechnung!H44","v":0},{"$f":"Berechnung!I44","v":0},{"$f":"Berechnung!J44","v":0},{"$f":"Berechnung!K44","v":0},{"$f":"Berechnung!L44","v":0},{"$f":"Berechnung!M44","v":0}]
[null,null,2016,{"$f":"Berechnung!E45","v":0},{"$f":"Berechnung!F45","v":0},{"$f":"Berechnung!G45","v":0},{"$f":"Berechnung!H45","v":0},{"$f":"Berechnung!I45","v":0},{"$f":"Berechnung!J45","v":0},{"$f":"Berechnung!K45","v":0},{"$f":"Berechnung!L45","v":0},{"$f":"Berechnung!M45","v":0}]
[null,null,2017,{"$f":"Berechnung!E46","v":0},{"$f":"Berechnung!F46","v":0},{"$f":"Berechnung!G46","v":0},{"$f":"Berechnung!H46","v":0},{"$f":"Berechnung!I46","v":0},{"$f":"Berechnung!J46","v":0},{"$f":"Berechnung!K46","v":0},{"$f":"Berechnung!L46","v":0},{"$f":"Berechnung!M46","v":0}]
[null,null,2018,{"$f":"Berechnung!E47","v":0},{"$f":"Berechnung!F47","v":0},{"$f":"Berechnung!G47","v":0},{"$f":"Berechnung!H47","v":0},{"$f":"Berechnung!I47","v":0},{"$f":"Berechnung!J47","v":0},{"$f":"Berechnung!K47","v":0},{"$f":"Berechnung!L47","v":0},{"$f":"Berechnung!M47","v":0}]
[null,null,2019,{"$f":"Berechnung!E48","v":0},{"$f":"Berechnung!F48","v":0},{"$f":"Berechnung!G48","v":0},{"$f":"Berechnung!H48","v":0},{"$f":"Berechnung!I48","v":0},{"$f":"Berechnung!J48","v":0},{"$f":"Berechnung!K48","v":0},{"$f":"Berechnung!L48","v":0},{"$f":"Berechnung!M48","v":0}]
[null,null,2020,{"$f":"Berechnung!E49","v":0},{"$f":"Berechnung!F49","v":0},{"$f":"Berechnung!G49","v":0},{"$f":"Berechnung!H49","v":0},{"$f":"Berechnung!I49","v":0},{"$f":"Berechnung!J49","v":0},{"$f":"Berechnung!K49","v":0},{"$f":"Berechnung!L49","v":0},{"$f":"Berechnung!M49","v":0}]
[null,null,2021,{"$f":"Berechnung!E50","v":0},{"$f":"Berechnung!F50","v":0},{"$f":"Berechnung!G50","v":0},{"$f":"Berechnung!H50","v":0},{"$f":"Berechnung!I50","v":0},{"$f":"Berechnung!J50","v":0},{"$f":"Berechnung!K50","v":0},{"$f":"Berechnung!L50","v":0},{"$f":"Berechnung!M50","v":0}]
[null,null,2022,{"$f":"Berechnung!E51","v":0},{"$f":"Berechnung!F51","v":0},{"$f":"Berechnung!G51","v":0},{"$f":"Berechnung!H51","v":0},{"$f":"Berechnung!I51","v":0},{"$f":"Berechnung!J51","v":0},{"$f":"Berechnung!K51","v":0},{"$f":"Berechnung!L51","v":0},{"$f":"Berechnung!M51","v":0}]
[null,null,2023,{"$f":"Berechnung!E52","v":0},{"$f":"Berechnung!F52","v":0},{"$f":"Berechnung!G52","v":0},{"$f":"Berechnung!H52","v":0},{"$f":"Berechnung!I52","v":0},{"$f":"Berechnung!J52","v":0},{"$f":"Berechnung!K52","v":0},{"$f":"Berechnung!L52","v":0},{"$f":"Berechnung!M52","v":0}]
[]
[null,"II.3","ausgegebene Mittel per HAMISSA-Auszahlung"]
[]
[null,null,null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"Summen",{"$f":"Berechnung!E57","v":0},{"$f":"Berechnung!F57","v":0},{"$f":"Berechnung!G57","v":0},{"$f":"Berechnung!H57","v":0},{"$f":"Berechnung!I57","v":0},{"$f":"Berechnung!J57","v":0},{"$f":"Berechnung!K57","v":0},{"$f":"Berechnung!L57","v":0},{"$f":"Berechnung!M57","v":0}]
[null,null,2016,{"$f":"Berechnung!E58","v":0},{"$f":"Berechnung!F58","v":0},{"$f":"Berechnung!G58","v":0},{"$f":"Berechnung!H58","v":0},{"$f":"Berechnung!I58","v":0},{"$f":"Berechnung!J58","v":0},{"$f":"Berechnung!K58","v":0},{"$f":"Berechnung!L58","v":0},{"$f":"Berechnung!M58","v":0}]
[null,null,2017,{"$f":"Berechnung!E59","v":0},{"$f":"Berechnung!F59","v":0},{"$f":"Berechnung!G59","v":0},{"$f":"Berechnung!H59","v":0},{"$f":"Berechnung!I59","v":0},{"$f":"Berechnung!J59","v":0},{"$f":"Berechnung!K59","v":0},{"$f":"Berechnung!L59","v":0},{"$f":"Berechnung!M59","v":0}]
[null,null,2018,{"$f":"Berechnung!E60","v":0},{"$f":"Berechnung!F60","v":0},{"$f":"Berechnung!G60","v":0},{"$f":"Berechnung!H60","v":0},{"$f":"Berechnung!I60","v":0},{"$f":"Berechnung!J60","v":0},{"$f":"Berechnung!K60","v":0},{"$f":"Berechnung!L60","v":0},{"$f":"Berechnung!M60","v":0}]
[null,null,2019,{"$f":"Berechnung!E61","v":0},{"$f":"Berechnung!F61","v":0},{"$f":"Berechnung!G61","v":0},{"$f":"Berechnung!H61","v":0},{"$f":"Berechnung!I61","v":0},{"$f":"Berechnung!J61","v":0},{"$f":"Berechnung!K61","v":0},{"$f":"Berechnung!L61","v":0},{"$f":"Berechnung!M61","v":0}]
[null,null,2020,{"$f":"Berechnung!E62","v":0},{"$f":"Berechnung!F62","v":0},{"$f":"Berechnung!G62","v":0},{"$f":"Berechnung!H62","v":0},{"$f":"Berechnung!I62","v":0},{"$f":"Berechnung!J62","v":0},{"$f":"Berechnung!K62","v":0},{"$f":"Berechnung!L62","v":0},{"$f":"Berechnung!M62","v":0}]
[null,null,2021,{"$f":"Berechnung!E63","v":0},{"$f":"Berechnung!F63","v":0},{"$f":"Berechnung!G63","v":0},{"$f":"Berechnung!H63","v":0},{"$f":"Berechnung!I63","v":0},{"$f":"Berechnung!J63","v":0},{"$f":"Berechnung!K63","v":0},{"$f":"Berechnung!L63","v":0},{"$f":"Berechnung!M63","v":0}]
[null,null,2022,{"$f":"Berechnung!E64","v":0},{"$f":"Berechnung!F64","v":0},{"$f":"Berechnung!G64","v":0},{"$f":"Berechnung!H64","v":0},{"$f":"Berechnung!I64","v":0},{"$f":"Berechnung!J64","v":0},{"$f":"Berechnung!K64","v":0},{"$f":"Berechnung!L64","v":0},{"$f":"Berechnung!M64","v":0}]
[null,null,2023,{"$f":"Berechnung!E65","v":0},{"$f":"Berechnung!F65","v":0},{"$f":"Berechnung!G65","v":0},{"$f":"Berechnung!H65","v":0},{"$f":"Berechnung!I65","v":0},{"$f":"Berechnung!J65","v":0},{"$f":"Berechnung!K65","v":0},{"$f":"Berechnung!L65","v":0},{"$f":"Berechnung!M65","v":0}]
[]
[null,"II.4","Restmittel"]
[]
[null,null,null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"Summen",{"$f":"Berechnung!E82","v":0},{"$f":"Berechnung!F82","v":0},{"$f":"Berechnung!G82","v":0},{"$f":"Berechnung!H82","v":0},{"$f":"Berechnung!I82","v":0},{"$f":"Berechnung!J82","v":0},{"$f":"Berechnung!K82","v":0},{"$f":"Berechnung!L82","v":0},{"$f":"Berechnung!M82","v":0}]
[null,null,2016,{"$f":"Berechnung!E83","v":0},{"$f":"Berechnung!F83","v":0},{"$f":"Berechnung!G83","v":0},{"$f":"Berechnung!H83","v":0},{"$f":"Berechnung!I83","v":0},{"$f":"Berechnung!J83","v":0},{"$f":"Berechnung!K83","v":0},{"$f":"Berechnung!L83","v":0},{"$f":"Berechnung!M83","v":0}]
[null,null,2017,{"$f":"Berechnung!E84","v":0},{"$f":"Berechnung!F84","v":0},{"$f":"Berechnung!G84","v":0},{"$f":"Berechnung!H84","v":0},{"$f":"Berechnung!I84","v":0},{"$f":"Berechnung!J84","v":0},{"$f":"Berechnung!K84","v":0},{"$f":"Berechnung!L84","v":0},{"$f":"Berechnung!M84","v":0}]
[null,null,2018,{"$f":"Berechnung!E85","v":0},{"$f":"Berechnung!F85","v":0},{"$f":"Berechnung!G85","v":0},{"$f":"Berechnung!H85","v":0},{"$f":"Berechnung!I85","v":0},{"$f":"Berechnung!J85","v":0},{"$f":"Berechnung!K85","v":0},{"$f":"Berechnung!L85","v":0},{"$f":"Berechnung!M85","v":0}]
[null,null,2019,{"$f":"Berechnung!E86","v":0},{"$f":"Berechnung!F86","v":0},{"$f":"Berechnung!G86","v":0},{"$f":"Berechnung!H86","v":0},{"$f":"Berechnung!I86","v":0},{"$f":"Berechnung!J86","v":0},{"$f":"Berechnung!K86","v":0},{"$f":"Berechnung!L86","v":0},{"$f":"Berechnung!M86","v":0}]
[null,null,2020,{"$f":"Berechnung!E87","v":0},{"$f":"Berechnung!F87","v":0},{"$f":"Berechnung!G87","v":0},{"$f":"Berechnung!H87","v":0},{"$f":"Berechnung!I87","v":0},{"$f":"Berechnung!J87","v":0},{"$f":"Berechnung!K87","v":0},{"$f":"Berechnung!L87","v":0},{"$f":"Berechnung!M87","v":0}]
[null,null,2021,{"$f":"Berechnung!E88","v":0},{"$f":"Berechnung!F88","v":0},{"$f":"Berechnung!G88","v":0},{"$f":"Berechnung!H88","v":0},{"$f":"Berechnung!I88","v":0},{"$f":"Berechnung!J88","v":0},{"$f":"Berechnung!K88","v":0},{"$f":"Berechnung!L88","v":0},{"$f":"Berechnung!M88","v":0}]
[null,null,2022,{"$f":"Berechnung!E89","v":0},{"$f":"Berechnung!F89","v":0},{"$f":"Berechnung!G89","v":0},{"$f":"Berechnung!H89","v":0},{"$f":"Berechnung!I89","v":0},{"$f":"Berechnung!J89","v":0},{"$f":"Berechnung!K89","v":0},{"$f":"Berechnung!L89","v":0},{"$f":"Berechnung!M89","v":0}]
[null,null,2023,{"$f":"Berechnung!E90","v":0},{"$f":"Berechnung!F90","v":0},{"$f":"Berechnung!G90","v":0},{"$f":"Berechnung!H90","v":0},{"$f":"Berechnung!I90","v":0},{"$f":"Berechnung!J90","v":0},{"$f":"Berechnung!K90","v":0},{"$f":"Berechnung!L90","v":0},{"$f":"Berechnung!M90","v":0}]
[]
[]
[]
[null,"___________________",null,null,null,"_____________________________________"]
[null,"Ort, Datum",null,null,null,"Unterschrift Projektleiter/in"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"gültig ab 12.04.2017"]

{"sheet":"Berechnung","index":1,"n_rows":94,"n_cols":222,"rows_kept":94,"cut":false,"hidden":false,"merged":[[9,3,9,8],[4,3,4,8],[5,3,5,8],[6,3,6,8],[7,3,7,8],[8,3,8,8]]}
[null,null,"EVN-Kontrolle/-Berechnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Die ist eine Datei der ESF-Gruppe."]
[null,null,null,null,null,"Bitte füllen Sie nur farbig unterlegte Zellen aus. Alle anderen sind gesperrt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"letzte Änderung am",null,"2017-02-10"]
[null,"I","Projektdaten",null,null,null,null,null,null,null,{"$f":"IF(P22=\"OK\",\"\",\"8-ung! Fehlermeldung! Beachte Spalte C!\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hinweise finden Sie in Datei ",null,"Hilfe_EVN.docx"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Die Hilfe-Datei liegt hier:",null,"ESF_2014_2020$ (\\\\lisaservfile.lisa.mk.lsa-net.de\\Z_Hilfedokumente\\Hilfe_EVN.docx"]
[null,null,"Bezeichnung des Projektes:  "]
[null,null,"Beginn der Maßnahme:  ",null,null,null,null,null,null,null,null,null,null,null,null,"Kontroll- & Überwachungsfelder"]
[null,null,"Projektende:  ",null,null,null,null,null,null,null,null,null,null,null,null,"bitte nicht verändern"]
[null,null,"Projektleiter/-in:  "]
[null,null,"EU-Rgistriernummer:  ",null,null,null,null,null,null,null,null,null,null,null,null,"Nachgenehmigung",null,null,"Restmittel negativ"]
[null,null,"Antragstellende Einrichtung:  ",null,null,null,null,null,null,null,null,null,null,null,null,"A",0,null,{"$f":"IF(E82<0,1,0)","v":0},{"$f":"IF(F82<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"IF(M31=0,0,1)","v":0},null,0,{"$f":"IF(F83<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"IF(Q10=Q11,\"OK\",\"Fehler\")","v":"OK"},null,0,{"$f":"IF(F84<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,"II","Endverwendungsnachweis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(F85<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(F86<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,"Bitte trage die Einzeldaten in die gelb unterlegten Felder ein. Alle anderen Daten berechnet Excel für Dich.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(F87<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(F88<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,"II.1","Antrag",null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe",null,null,null,null,null,0,{"$f":"IF(F89<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Summen",{"$f":"SUM(E19:E26)","v":0},{"$f":"SUM(F19:F26)","v":0},0,0,0,0,0,0,{"$f":"SUM(M19:M26)","v":0},null,null,null,null,null,0,{"$f":"IF(F90<0,1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,2016,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:L19)","v":0},null,null,null,null,null,0,{"$f":"IF(F91<0,1,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AB20=0,\"OK\",\"Fehler\")","v":"OK"}]
[null,null,null,2017,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:L20)","v":0},null,null,"Fehler",null,null,0,{"$f":"IF(F92<0,1,0)","v":0},0,0,0,0,0,0,0,{"$f":"COUNTIF(S10:AA20,1)","v":0}]
[null,null,{"$f":"IF(SUM(E19:L28)=M18,\"\",\"Fehler in II.1!\")","v":""},2018,null,null,null,null,null,null,null,null,0,null,null,"gesamt"]
[null,null,null,2019,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(SUM(P23:P29)=0,\"OK\",\"Fehler\")","v":"OK"}]
[null,null,null,2020,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(C21=\"\",0,1)","v":0}]
[null,null,null,2021,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:L24)","v":0},null,null,{"$f":"IF(C38=\"\",0,1)","v":0}]
[null,null,null,2022,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(C39=\"\",0,1)","v":0}]
[null,null,null,2023,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(C47=\"\",0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C60=\"\",0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C74=\"\",0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C84=\"\",0,1)","v":0}]
[null,"II.2","Nachbean-",null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"antragung","Summe",{"$f":"SUM(E32:E39)","v":0},{"$f":"SUM(F32:F39)","v":0},{"$f":"SUM(G32:G39)","v":0},0,0,0,0,0,0]
[null,null,null,2016,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:L32)","v":0}]
[null,null,null,2017,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:L33)","v":0}]
[null,null,null,2018,null,null,null,null,null,null,null,null,0]
[null,null,null,2019,null,null,null,null,null,null,null,null,0]
[null,null,null,2020,null,null,null,null,null,null,null,null,0]
[null,null,null,2021,null,null,null,null,null,null,null,null,{"$f":"SUM(E37:L37)","v":0}]
[null,null,{"$f":"IF(Q12=\"OK\",\"\",\"Fehler in II.2!\")","v":""},2022,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(SUM(E32:L41)=M31,\"\",\"Fehler in II.2!\")","v":""},2023,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,"II.2a","Summe der",null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"beantragten","Summe",{"$f":"SUM(E45:E52)","v":0},{"$f":"SUM(F45:F52)","v":0},{"$f":"SUM(G45:G52)","v":0},{"$f":"SUM(H45:H52)","v":0},0,0,0,0,0]
[null,null,"Mittel",2016,{"$f":"E32+E19","v":0},{"$f":"F32+F19","v":0},0,{"$f":"H32+H19","v":0},0,0,0,0,{"$f":"SUM(E45:L45)","v":0}]
[null,null,null,2017,{"$f":"E33+E20","v":0},0,0,{"$f":"H33+H20","v":0},0,0,0,0,{"$f":"SUM(E46:L46)","v":0}]
[null,null,{"$f":"IF(SUM(E45:L54)=M44,\"\",\"Fehler in II2a!\")","v":""},2018,{"$f":"E34+E21","v":0},0,0,{"$f":"H34+H21","v":0},0,0,0,0,0,null,null,"Hinweise für den Bearbeiter des EVN:"]
[null,null,null,2019,0,{"$f":"F35+F22","v":0},0,{"$f":"H35+H22","v":0},0,0,0,0,0,null,null,"♦ Das Blatt EVN ist geschützt, so dass darauf keine Veränderungen vorgenommen werden können."]
[null,null,null,2020,{"$f":"E36+E23","v":0},0,0,{"$f":"H36+H23","v":0},0,0,0,0,0,null,null,"   kein Passwort"]
[null,null,null,2021,{"$f":"E37+E24","v":0},0,0,{"$f":"H37+H24","v":0},0,0,0,0,0,null,null,"♦ Im Blatt Berechnung sind nur in den gelb unterlegten Zellen Veränderungen möglich."]
[null,null,null,2022,{"$f":"E38+E25","v":0},0,0,{"$f":"H38+H25","v":0},0,0,0,0,0,null,null,"   Alle anderen Zellen sind per Blattschutz gesperrt. kein Passwort"]
[null,null,null,2023,{"$f":"E39+E26","v":0},0,0,{"$f":"H39+H26","v":0},0,0,0,0,0]
[]
[]
[]
[null,"II.3","ausgegebene Mittel",null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,"Mittel per","Summe",{"$f":"SUM(E58:E65)","v":0},{"$f":"SUM(F58:F65)","v":0},{"$f":"SUM(G58:G65)","v":0},{"$f":"SUM(H58:H65)","v":0},0,0,0,0,{"$f":"SUM(M58:M65)","v":0}]
[null,null,"HAMISSA-",2016,null,null,null,null,null,null,null,null,{"$f":"SUM(E58:L58)","v":0}]
[null,null,"Auszahlung",2017,null,null,null,null,null,null,null,null,{"$f":"SUM(E59:L59)","v":0}]
[null,null,{"$f":"IF(SUM(E58:L67)=M57,\"\",\"Fehler in II.3!\")","v":""},2018,null,null,null,null,null,null,null,null,{"$f":"SUM(E60:L60)","v":0}]
[null,null,null,2019,null,null,null,null,null,null,null,null,0]
[null,null,null,2020,null,null,null,null,null,null,null,null,0]
[null,null,null,2021,null,null,null,null,null,null,null,null,0]
[null,null,null,2022,null,null,null,null,null,null,null,null,0]
[null,null,null,2023,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,"II.3a","ausgegebene Mittel",null,"Summe",{"$f":"SUM(F70:F77)","v":0},null,null,"II.3b","Differenz","Summe",{"$f":"SUM(L70:L77)","v":0}]
[null,null,"Mittel per",null,2016,null,null,null,null,"HAMISSA -",2016,{"$f":"M58-F70","v":0}]
[null,null,"efREporter-III-",null,2017,null,null,null,null,"efREporter",2017,{"$f":"M59-F71","v":0}]
[null,null,"Erfassung",null,2018,null,null,null,null,null,2018,{"$f":"M60-F72","v":0}]
[null,null,null,null,2019,null,null,null,null,null,2019,{"$f":"M61-F73","v":0}]
[null,null,{"$f":"IF(L69=0,\"\",\"Fehler in II.3a!\")","v":""},null,2020,null,null,null,null,null,2020,0]
[null,null,null,null,2021,null,null,null,null,null,2021,0]
[null,null,null,null,2022,null,null,null,null,null,2022,0]
[null,null,null,null,2023,null,null,null,null,null,2023,0]
[]
[]
[]
[null,"II.4","Restmittel",null,"PK PL","RK PL","SK PL","RK TN","RK Ref","Hon","RM","LLM","Summe"]
[null,null,null,"Summe",{"$f":"SUM(E83:E90)","v":0},{"$f":"SUM(F83:F90)","v":0},0,0,0,0,0,0,0]
[null,null,null,2016,{"$f":"E45-E58","v":0},{"$f":"F45-F58","v":0},0,{"$f":"H45-H58","v":0},0,0,0,0,{"$f":"SUM(E83:L83)","v":0}]
[null,null,{"$f":"IF(AB20=0,\"\",\"Fehler in II.4!\")","v":""},2017,{"$f":"E46-E59","v":0},0,0,{"$f":"H46-H59","v":0},0,0,0,0,{"$f":"SUM(E84:L84)","v":0}]
[null,null,{"$f":"IF(SUM(E83:L92)=M82,\"\",\"Fehler in II.4!\")","v":""},2018,{"$f":"E47-E60","v":0},0,0,{"$f":"H47-H60","v":0},0,0,0,0,0]
[null,null,null,2019,{"$f":"E48-E61","v":0},0,0,{"$f":"H48-H61","v":0},0,0,0,0,0]
[null,null,null,2020,{"$f":"E49-E62","v":0},0,0,{"$f":"H49-H62","v":0},0,0,0,0,0]
[null,null,null,2021,{"$f":"E50-E63","v":0},0,0,{"$f":"H50-H63","v":0},0,0,0,0,0]
[null,null,null,2022,{"$f":"E51-E64","v":0},0,0,{"$f":"H51-H64","v":0},0,0,0,0,0]
[null,null,null,2023,{"$f":"E52-E65","v":0},0,0,{"$f":"H52-H65","v":0},0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"gültig ab 12.04.2017"]