{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TEICHLISTE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"TEICHLISTE","index":0,"n_rows":46,"n_cols":21,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,7,2,8],[42,4,43,4],[42,2,43,2],[42,3,43,3],[0,0,0,1],[2,2,2,3],[2,4,2,6]]}
["Anlage Teichliste",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel-Datei der Bewilligungsbehörde per Mail zusenden",null,"= Eingabefeld"]
[]
[null,"Interne Bezeichnung","Größe der funktionellen Einheit",null,"Lage der funktionellen Einheit",null,null,"Modul\n(mind. Modul 1:0,1 ha, Modul 2: 0,05 ha)",null,null,null,null,null,"Mindestgröße"]
["Lfd. Nr.","Teichname / Nummer etc.\n(betriebsinterne Bezeichnung)","beantragte Fläche in ha","festgestellte Fläche in ha","Gemarkung","Schlagnr. / Flurnr.","Teilschlag / Flurstücknr.","beantragt","festgestellt",null,null,null,null,"Modul 1","Modul 2"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H5=\"Modul 1\",C5>=0.1),C5,\"\")","v":""},{"$f":"IF(AND(H5=\"Modul 2\",C5>=0.05),C5,\"\")","v":""},{"$f":"IF(AND(I5=\"Modul 1\",D5>=0.1),D5,\"\")","v":""},{"$f":"IF(AND(I5=\"Modul 2\",D5>=0.05),D5,\"\")","v":""},{"$f":"IF(AND(H5=\"Modul 1\",C5<0.1),\" nicht erreicht\",\"erreicht\")","v":"erreicht"},{"$f":"IF(AND(H5=\"Modul 2\",C5<0.05),\"Mindestgröße nicht erreicht\",\"erreicht\")","v":"erreicht"}]
[{"$f":"IF($A$5>0,A5+1,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(H6=\"Modul 1\",C6>=0.1),C6,\"\")","v":""},{"$f":"IF(AND(H6=\"Modul 2\",C6>=0.05),C6,\"\")","v":""},{"$f":"IF(AND(I6=\"Modul 1\",D6>=0.1),D6,\"\")","v":""},{"$f":"IF(AND(I6=\"Modul 2\",D6>=0.05),D6,\"\")","v":""},{"$f":"IF(AND(H6=\"Modul 1\",C6<0.1),\" nicht erreicht\",\"erreicht\")","v":"erreicht"},{"$f":"IF(AND(H6=\"Modul 2\",C6<0.05),\"Mindestgröße nicht erreicht\",\"erreicht\")","v":"erreicht"},null,"Rechenhilfe"]
[{"$f":"IF($A$5>0,A6+1,\"\")","v":""},null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht",null,1,"m²","=",1E-4,"ha"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht",null,10000,"m²","=",{"$f":"ROUND((Q8/10000),4)","v":1},"ha"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht",null,1,"km²","=",100,"ha"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht",null,0.01,"km²","=",{"$f":"ROUND((Q11*100),4)","v":1},"ha"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht",null,1,"a","=",0.01,"ha"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht",null,100,"a","=",{"$f":"ROUND((Q14/100),4)","v":1},"ha"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
["",null,null,null,null,null,null,null,null,"","","","","erreicht","erreicht"]
[null,null,{"$f":"SUM(J5:J28)","v":0},{"$f":"SUM(L5:L28)","v":0},"Gesamtfläche Modul 1",null,null,{"$f":"ROUNDDOWN((C29*900),2)","v":0},{"$f":"ROUNDDOWN((D29*900),2)","v":0}]
[{"$f":"IF(C31>0,ROUNDUP((C30/C31),2),\"\")","v":""},{"$f":"IF(AND(C31>0,A30>20%),\"Anteil Modul 2 an Gesamtfläche zu hoch! Maximal 20%\",\"Anteil Modul 2 an Gesamtfläche\")","v":"Anteil Modul 2 an Gesamtfläche"},{"$f":"SUM(K5:K28)","v":0},{"$f":"SUM(M5:M28)","v":0},"Gesamtfläche Modul 2",null,null,{"$f":"ROUNDDOWN((C30*1200),2)","v":0},{"$f":"ROUNDDOWN((D30*1200),2)","v":0}]
[null,null,{"$f":"SUM(C29:C30)","v":0},{"$f":"SUM(D29:D30)","v":0},"Gesamtfläche Modul 1 und 2",null,null,{"$f":"SUM(H29:H30)","v":0},{"$f":"SUM(I29:I30)","v":0}]
["Mit meinen Angaben, bestätige ich, dass von der beantragten funktionellen Einheit mindestens 80% Wasserfläche sind",null,null,null,null,null,null,"€ beantragt/Jahr","€ festgestellt/Jahr"]
[]
[]
[null,"Anzahl Jahre",null,"siehe EMFAF-G Ausgleich Nr. 2.4 Geplanter Durchführungszeitraum "]
[null,null,"Modul 1","Modul 2","Modul 1 + 2"]
[null,"Gesamtkosten",{"$f":"H29","v":0},{"$f":"H30","v":0},{"$f":"H31","v":0}]
[null,"nicht zuwendungsfähige Kosten",0,0,{"$f":"SUM(C38:D38)","v":0}]
[null,"Leistungen Dritter",0,0,{"$f":"SUM(C39:D39)","v":0}]
[null,"zuwendungsfähige Ausgaben",{"$f":"C37-C38-C39","v":0},{"$f":"D37-D38-D39","v":0},0]
[null,"Fördersatz","900 Euro/ha","1.200 Euro/ha","Festbetrag"]
[null,"Beantragte Förderung",{"$f":"C40","v":0},{"$f":"D40","v":0},0]
[null,"Sonstige beantragte / bewilligte öffentliche Förderung durch",null,null,{"$f":"SUM(C43:D43)","v":0}]
[]
[null,"Eigenanteil",{"$f":"C40-C42-C43","v":0},{"$f":"D40-D42-D43","v":0},0]
[null,null,{"$f":"IF(C45<0,\"Beantragte Förderung ist zu reduzieren!\",\"\")","v":""},{"$f":"IF(D45<0,\"Beantragte Förderung ist zu reduzieren!\",\"\")","v":""},""]