{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Anleitung","Start","Daten","Neue Parzellen","Betrieblicher Nährstoffeinsatz","P2O5 Düngung","P2O5 Bedarf","N-Bedarf","N-Düngebedarf 1-8"],"not_rendered":{"charts":0,"images":43,"macros":1,"external_links":0,"defined_names":12,"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":"Anleitung","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,1,2,1]]}
[]
[null,"Aufgabenliste\n\n1. Bezeichnung \"Düngejahr\" oder \"Erntejahr\": wenn Entscheidung, dann anpassen. C. Huth: Abklären\n\n2. Deckelung der möglichen Eingaben (N bzw. P2O5) über 3-Jahresgaben, bei \"restliche Flächen\" über feste Obergrenzen.\n     Falls noch kein Düngebedarf ermittelt wurde und/oder die Daten noch nicht übertragen wurden, steht die Obergrenze auf Null.\n\n3. Die Angaben vom P2O5-Blatt gehen in die gesamtbetriebliche Nährstoffbilanzierung mit ein.\n\n4. \"Neue Parzellen P2O5\":    Parzelle schon vorhanden bei \"N\": Warnung und in \"N\" per Abfrage löschen oder bei P2O5 nicht eintragen\n    \"Neue Parzellen-N\":            Parzelle schon bei P2O5 vorhanden, dann Meldung und nicht mehr bei N eintragbar.\n\n5. P2O5: Bedarf wird nach P2O5-Düngung übertragen.\n\n6. Neues Blatt \"Start\" als Startseite: zwischen den einzelnen Excel-Blättern kann nur noch per Schaltknopf hin und zurück gesprungen werden.\n\n7. N- und P2O5-Düngung: Datumsfeld vor Düngemittel-Name eingefügt.\n\n8. Rot hinterlegte Felder: dort stehen alte (bereits vorhandene) Eintragungen, die nach div. Änderung ungültig wurden: sind von Hand zu ändern.\n\n9. Startseite: \n     -   N-Bilanzierung (kg/ha) wird zusätzlich nach \"mineralisch\" und \"organisch\" getrennt angezeigt\n     -   die gesamtbetrieblichen Daten werden erst angezeigt, wenn rechts im Feld \"Ertragsrebfläche\" ein Wert ausgewiesen wird\n\n\n\n\n    Rot: noch offen        Grün: ist erledigt             Blau: Änderung seit letzter Fassung           Violett: Frage"]

{"sheet":"Start","index":1,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,4,11,6],[1,19,1,20],[9,11,9,12],[10,11,10,12],[9,4,9,6],[10,4,10,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DLR Rheinpfalz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version:","1.0.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand:","2021-01-15"]
[null,null,null,null,"Betrieblicher Nährstoffeinsatz für Ertragsanlagen im Weinbau"]
[]
[]
[]
[]
[null,null,null,"Betriebsname","Weingut Mustermann",null,null,null,null,null,"Düngejahr:",2021,null,null,null,null,"Gesamtrebfläche (ha):",35]
[null,null,null,"Strasse Hausnr.","Riesling-Weg 1",null,null,null,null,null,"Beginn und Ende des Düngejahres:","1. Jan - 31. Dez",null,null,null,null,"davon NICHT im Ertrag stehend (ha):",1]
[null,null,null,"PLZ Ort","67435 Neustadt/Wstr.",null,null,null,null,null,null,{"$f":"DATEVALUE(\"1.1.\" & L10)","v":44197},{"$f":"DATEVALUE(\"31.12.\" & L10)","v":44561},null,null,null,"Ertragsrebfläche (ha):",{"$f":"IF(OR(ISBLANK(R10),ISBLANK(R11)),\"\",R10-R11)","v":34}]
[]
[null,null,null,null,null,null,null,null,null,"Summe*:",null,"Gesamt-N (kg):",{"$f":"IF(R12=\"\",\"\",IF(COUNT('Betrieblicher Nährstoffeinsatz'!M20:M42,'P2O5 Düngung'!M20:M33)=0,\"\",SUM('Betrieblicher Nährstoffeinsatz'!M20:M42,'P2O5 Düngung'!M20:M33)))","v":652.695652173913}]
[null,null,null,null,null,null,null,null,null,null,null,"N (kg/ha):",{"$f":"IF(OR(M14=\"\",R12=\"\"),\"\",M14/R12)","v":19.196930946291559}]
[null,null,null,null,null,null,null,null,null,null,null,"mineralisch N (kg/ha):",{"$f":"IF(R12=\"\",\"\",IF(COUNT('Betrieblicher Nährstoffeinsatz'!M20:M42,'P2O5 Düngung'!M20:M33)=0,\"\",IF(N16<=0,0,(SUMIF('Betrieblicher Nährstoffeinsatz'!P20:P42,\"mineralisch\",'Betrieblicher Nährstoffeinsatz'!M20:M42)+SUMIF('P2O5 Düngung'!P20:P33,\"mineralisch\",'P2O5 Düngung'!M20:M33))/R12)))","v":0},{"$f":"IF(COUNT('Betrieblicher Nährstoffeinsatz'!M20:M42,'P2O5 Düngung'!M20:M33)=0,\"\",SUMIF('Betrieblicher Nährstoffeinsatz'!P20:P42,\"mineralisch\",'Betrieblicher Nährstoffeinsatz'!F20:F42)+SUMIF('P2O5 Düngung'!P20:P20,\"mineralisch\",'P2O5 Düngung'!F20:F33))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"organisch N (kg/ha):",{"$f":"IF(R12=\"\",\"\",IF(COUNT('Betrieblicher Nährstoffeinsatz'!M20:M42,'P2O5 Düngung'!M20:M33)=0,\"\",IF(N17<=0,0,(SUMIF('Betrieblicher Nährstoffeinsatz'!P20:P42,\"organisch\",'Betrieblicher Nährstoffeinsatz'!M20:M42)+SUMIF('P2O5 Düngung'!P20:P33,\"organisch\",'P2O5 Düngung'!M20:M33))/R12)))","v":19.196930946291559},{"$f":"IF(COUNT('Betrieblicher Nährstoffeinsatz'!M20:M42,'P2O5 Düngung'!M20:M33)=0,\"\",SUMIF('Betrieblicher Nährstoffeinsatz'!P20:P42,\"organisch\",'Betrieblicher Nährstoffeinsatz'!F20:F42)+SUMIF('P2O5 Düngung'!P20:P20,\"organisch\",'P2O5 Düngung'!F20:F33))","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,"N-verfügbar (kg):",{"$f":"IF(R12=\"\",\"\",IF(COUNT('Betrieblicher Nährstoffeinsatz'!O20:O42,'P2O5 Düngung'!O20:O33)=0,\"\",SUM('Betrieblicher Nährstoffeinsatz'!O20:O42,'P2O5 Düngung'!O20:O33)))","v":61.741480611045823}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamt-P2O5 (kg):",{"$f":"IF(R12=\"\",\"\",IF(COUNT('Betrieblicher Nährstoffeinsatz'!N20:N42,'P2O5 Düngung'!N20:N33)=0,\"\",SUM('Betrieblicher Nährstoffeinsatz'!N20:N42,'P2O5 Düngung'!N20:N33)))","v":202.86486486486487}]
[]
[]
[]
[null,null,null,null,"P2O5 (Phosphat)",null,null,null,null,null,null,null,null,null,null,"N (Stickstoff)"]

{"sheet":"Daten","index":2,"n_rows":33,"n_cols":28,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,3,0,6],[0,9,0,11],[0,14,0,16]]}
[null,null,null,"Faktor im Anrechnungsjahr [%]",null,null,null,null,"Liste der Düngemittel (%) ","für N-Düngung",null,null,null,null,"für P2O5-Düngung",null,null,null,"-------------   Eigene Düngemittel"]
["Gruppe  ","  Produkt","N kg/t m³","aktuell","Jahr 2","Jahr 3","Jahr 4","lfd","Name","N-Gesamt","P2O5-Gesamt","N-verfügbar",null,"Name","N-Gesamt","P2O5-Gesamt","N-verfügbar",null,"Name","N-Gesamt","P2O5-Gesamt","N-verfügbar",null,"BEW","Nr Blatt","min BEW","max BEW"]
[null,null,null,null,null,null,null,1,"Stickstoffmagnesia, Nitromag",22,0,22,"mineralisch","Diammonphosphat",18,46,18,"mineralisch",null,null,null,null,null,{"$f":"Z3 & \"-\" & AA3","v":"1-8"},9,1,8,9]
["Reststoffe Weinbereitung","Trester 40 % TM (t)",7.4,0.1,0.1,0,0,2,"Kalkammonsalpeter",27,0,27,"mineralisch","Superphosphat",0,18,0,"mineralisch",null,null,null,null,null,{"$f":"Z4 & \"-\" & AA4","v":"9-16"},10,{"$f":"Z3+8","v":9},{"$f":"AA3+8","v":16}]
[null,"Trester 40 % TM (m³)",3.7,0.1,0.1,0,0,3,"Ammonsulfatsalpeter",26,0,26,"mineralisch","Triple-Superphosphat",0,50,0,"mineralisch",null,null,null,null,null,"17-24",11,{"$f":"Z4+8","v":17},24]
[null,"Mosttrub flüssig (m³)",5,0.8,0.1,0,0,4,"Kalksalpeter",16,0,16,"mineralisch","Novaphos; Cederan",0,23,0,"mineralisch",null,null,null,null,null,"25-32",12,25,32]
[null,"Weinhefe flüssig 20 % TM (m³)",8,0.8,0.1,0,0,5,"Schwefelsaures Ammoniak",21,0,21,"mineralisch","Rohphosphat (Öko)",0,31,0,"mineralisch",null,null,null,null,null,"33-40",13,33,40]
[null,"Weinhefe filtriert 40 % TM (t)",16,0.8,0.1,0,0,6,"Harnstoff",46,0,46,"mineralisch","Cederan P 23",0,23,0,"mineralisch",null,null,null,null,null,"41-48",14,41,48]
[null,"Weinhefe filtriert 40 % TM (m³)",11,0.8,0.1,0,0,7,"Ammonnitrat-Harnstofflösung (AHL)",28,0,28,"mineralisch","Stroh",0.5,0.3,0,"organisch",null,null,null,null,null,"49-56",15,49,56]
[null,"Filtrationskieselgur 40 % TM (t)",6.4,0.8,0.1,0,0,8,"Basamon stabil; Alzon",27,0,27,"mineralisch","Rindermist (25 % TS)",0.65,0.4,0.16,"organisch",null,null,null,null,null,"57-64",16,57,64]
[null,"Eigenes Produkt (Reststoffe)",null,{"$f":"D4","v":0.1},{"$f":"E4","v":0.1},{"$f":"F4","v":0},{"$f":"G4","v":0},9,"Entec 26",26,0,26,"mineralisch","Schweinemist (25 % TS)",0.98000000000000009,0.82,0.28999999999999998,"organisch",null,null,null,null,null,"65-72",17,65,72]
[null,null,null,null,null,null,null,10,"Diammonphosphat",18,46,18,"mineralisch","Schafmist (30 % TS)",0.55000000000000004,0.32,0.13999999999999999,"organisch",null,null,null,null,null,"73-80",18,73,80]
["Sonstige","Streuwiese 86 % TM (t)",11,0.03,0.03,0,0,11,"Stroh",0.5,0.3,0,"organisch","Pferdemist (30 % TS)",0.5,0.38,0.13,"organisch",null,null,null,null,null,"81-88",19,81,88]
[null,"Stroh 90 % TM (t)",5,0.02,0,0,0,12,"Rindermist (25 % TS)",0.65,0.4,0.16,"organisch","Geflügelmist (50 %TS)",2.2000000000000002,1.8,1.1400000000000001,"organisch",null,null,null,null,null,"89-96",20,89,96]
[null,"Eigenes Produkt (Sonstige)",null,{"$f":"D14","v":0.02},{"$f":"E14","v":0},{"$f":"F14","v":0},{"$f":"G14","v":0},13,"Schweinemist (25 % TS)",0.98000000000000009,0.82,0.28999999999999998,"organisch","Baumrinde (1m3 = 0,4 t)",0.3,0.1,0,"organisch",null,null,null,null,null,"97-104",21,97,104]
[null,null,null,null,null,null,null,14,"Schafmist (30 % TS)",0.55000000000000004,0.32,0.13999999999999999,"organisch","Rindenkompost ",0.3,0.1,0,"organisch",null,null,null,null,null,"105-112",22,105,112]
["Kompost, Pflanzenhilfstoffe","Grünschnittkompost 64 % TM (t)",6.5,0.03,0.04,0.03,0.03,15,"Pferdemist (30 % TS)",0.5,0.38,0.13,"organisch","Bio(abfall)kompost (52 % TS) ",0.9,0.48,0.1,"organisch",null,null,null,null,null,"113-120",23,113,120]
[null,"Bioabfallkompost 52 % TM (t)",9,0.05,0.04,0.03,0.03,16,"Geflügelmist (50 %TS)",2.2000000000000002,1.8,1.1400000000000001,"organisch","Grünschnittkompost (64 % TS) ",0.65,0.32,0.04,"organisch",null,null,null,null,null,"121-128",24,121,128]
[null,"Holzhäcksel > 40 mm (t)",4,0,0,0,0,17,"Baumrinde (1m3 = 0,4 t)",0.3,0.1,0,"organisch","Holzhäcksel > 40 mm ",0.4,0.1,"n.n","organisch",null,null,null,null,null,"129-136",25,129,136]
[null,"Eigenes Produkt (Kompost)",null,{"$f":"D17","v":0.03},{"$f":"E17","v":0.04},{"$f":"F17","v":0.03},{"$f":"G17","v":0.03},18,"Rindenkompost ",0.3,0.1,0,"organisch","Vinasse",5.2,0.5,0,"organisch",null,null,null,null,null,"137-144",26,137,144]
[null,null,null,null,null,null,null,19,"Bio(abfall)kompost (52 % TS) ",0.9,0.48,0.1,"organisch","Rizinussschrot",6,2.5,0,"organisch",null,null,null,null,null,"145-152",27,{"$f":"Z20+8","v":145},152]
["Festmist","Rindermist 25 % TM (t)",6.5,0.25,0.1,0,0,20,"Grünschnittkompost (64 % TS) ",0.65,0.32,0.04,"organisch","Haarmehlpellets",14,0.9,0,"organisch",null,null,null,null,null,"153-160",28,153,160]
[null,"Schweinemist 25 % TM (t)",9.8000000000000007,0.3,0.1,0,0,21,"Holzhäcksel > 40 mm ",0.4,0.1,"n.n","organisch","Rapsschrot",5.8,2.5,0,"organisch",null,null,null,null,null,"161-168",29,161,168]
[null,"Schafmist 25 % TM (t)",5.5,0.25,0.1,0,0,22,"Vinasse",5.2,0.5,0,"organisch","Trester  (1 t = 2m3)",0.74,0.22999999999999998,6.9999999999999993E-2,"organisch",null,null,null,null,null,"169-176",30,169,176]
[null,"Pferdemist 25 % TM (t)",5,0.25,0.1,0,0,23,"Rizinussschrot",6,2.5,0,"organisch","Tresterkompost  (40 % TS)",1.2,0.5,0,"organisch",null,null,null,null,null,"177-184",31,177,184]
[null,"Hühnermist 50 % TM (t)",22,0.3,0.1,0,0,24,"Haarmehlpellets",14,0.9,0,"organisch","Weinhefe (30 % TM)   (1 t = 1m3)",5.33,0.3,0.06,"organisch",null,null,null,null,null,"185-192",32,185,192]
[null,"Eigenes Produkt (Festmist)",null,{"$f":"D25","v":0.25},{"$f":"E25","v":0.1},{"$f":"F25","v":0},{"$f":"G25","v":0},25,"Rapsschrot",5.8,2.5,0,"organisch","Mosttrub, flüssig     (1 t = 1m3)",0.5,0.03,0,"organisch",null,null,null,null,null,"193-200",33,193,200]
[null,null,null,null,null,null,null,26,"Trester  (1 t = 2m3)",0.74,0.22999999999999998,6.9999999999999993E-2,"organisch","Filtrationskieselgur  (40 % TS)",0.64,0.1,0,"organisch"]
[null,null,null,null,null,null,null,27,"Tresterkompost  (40 % TS)",1.2,0.5,0,"organisch","Wein/Schlempe ohne Hefe",0.02,0.02,0,"organisch"]
[null,null,null,null,null,null,null,28,"Weinhefe (30 % TM)   (1 t = 1m3)",5.33,0.3,0.06,"organisch"]
[null,null,null,null,null,null,null,29,"Mosttrub, flüssig     (1 t = 1m3)",0.5,0.03,0,"organisch"]
[null,null,null,null,null,null,null,30,"Filtrationskieselgur  (40 % TS)",0.64,0.1,0,"organisch"]
[null,null,null,null,null,null,null,31,"Wein/Schlempe ohne Hefe",0.02,0.02,0,"organisch"]

{"sheet":"Neue Parzellen","index":3,"n_rows":1003,"n_cols":4,"rows_kept":1003,"cut":false,"hidden":true,"merged":[]}
[]
[]
["lfd","BEW","Betriebsinterne Parzellenbezeichnung","Parzellen-\ngröße (ha)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]

{"sheet":"Betrieblicher Nährstoffeinsatz","index":4,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":true,"merged":[[18,0,19,0],[18,1,19,3],[18,4,19,4],[18,5,19,5],[1,15,1,16],[18,12,18,14],[18,6,18,7],[2,2,2,3],[3,2,3,3],[4,2,4,3],[20,4,22,4],[23,4,25,4],[26,4,28,4],[29,4,31,4],[32,4,34,4]]}
["Betrieblicher Nährstoffeinsatz für Ertragsanlagen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       DLR Rheinpfalz"]
[null,"Betriebsname",{"$f":"IF(ISBLANK(Start!E10),\"\",Start!E10)","v":"Weingut Mustermann"},null,null,null,null,null,null,null,null,null,null,null,null,"Version:",{"$f":"Start!U3","v":"1.0.0"}]
[null,"Strasse Hausnr.",{"$f":"IF(ISBLANK(Start!E11),\"\",Start!E11)","v":"Riesling-Weg 1"},null,null,null,null,null,null,null,null,null,null,null,null,"     Stand:    ",{"$f":"Start!U4","v":"2021-01-15"}]
[null,"PLZ Ort",{"$f":"IF(ISBLANK(Start!E12),\"\",Start!E12)","v":"67435 Neustadt/Wstr."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Düngejahr:",{"$f":"IF(ISBLANK(Start!L10),\"\",Start!L10)","v":2021}]
[]
[]
[]
[]
[]
[null,null,"Datum der Erstellung / Unterschrift:","2021-03-28"]
[null,null,null,null,"______________________________________________"]
[]
[]
[]
[]
["BEW","betriebsinterne Parzellenbezeichnung",null,null,"Bemerkung","Parzellen-\ngröße (ha)","N-Düngebedarf (kg/ha)",null,"Ausbring-","Düngemittel"," N","Düngemittel","Betrieblicher Nährstoffeinsatz pro Parzelle"]
[null,null,null,null,null,null,"3-Jahresgabe","1-Jahresgabe","datum","Name","(kg/ha)","(kg/Parzelle)","Gesamt-N (kg)","Gesamt-Phosphat (kg)","N verfügbar (kg)"]
[1,"Obere Nußbiene (4468) RIESLING",null,null,"Trester-Dreijahresgabe",0.9,150,50,"2021-03-29","Trester  (1 t = 2m3)",150,{"$f":"IF(OR(J21=\"\",K21=\"\"),\"\",K21*F21/VLOOKUP(J21,Düngung,2,0)*100)","v":18243.243243243243},{"$f":"IF(OR(J21=\"\",K21=\"\",F21=\"\"),\"\",IF(VLOOKUP(J21,Düngung,2,0)<=0,0,L21*VLOOKUP(J21,Düngung,2,0)/100))","v":135},{"$f":"IF(OR(J21=\"\",L21=\"\"),\"\",L21*VLOOKUP(J21,Düngung,3,0)/100)","v":41.95945945945946},{"$f":"IF(OR(J21=\"\",M21=\"\"),\"\",L21*VLOOKUP(J21,Düngung,4,0)/100)","v":12.770270270270268},{"$f":"IF(OR(J21=\"\",K21=\"\"),\"\",VLOOKUP(J21,Düngung,5,FALSE))","v":"organisch"}]
[1,"Obere Nußbiene (4468) RIESLING___2",null,null,null,0.9,150,50,null,null,null,"","","","",""]
[1,"Obere Nußbiene (4468) RIESLING___3",null,null,null,0.9,150,50,null,null,null,"","","","",""]
[1,"Untere Nußbiene (4400) GEWÜRZTRAMINER",null,null,"Trester-Dreijahresgabe",0.3,150,50,null,{"$f":"IF(ISBLANK(J21),\"\",J21)","v":"Trester  (1 t = 2m3)"},{"$f":"IF(ISBLANK(K21),\"\",K21)","v":150},6081.0810810810817,45,13.986486486486488,4.256756756756757,"organisch"]
[1,"Untere Nußbiene (4400) GEWÜRZTRAMINER___2",null,null,null,0.3,150,50,null,"","","","","","",""]
[1,"Untere Nußbiene (4400) GEWÜRZTRAMINER___3",null,null,null,0.3,150,50,null,"","","","","","",""]
[1,"Untere Nußbiene (4403) SPÄTBURGUNDER",null,null,"Trester-Dreijahresgabe",0.6,150,50,null,{"$f":"IF(ISBLANK(J24),\"\",J24)","v":"Trester  (1 t = 2m3)"},{"$f":"IF(ISBLANK(K24),\"\",K24)","v":150},12162.162162162163,90,27.972972972972975,8.513513513513514,"organisch"]
[1,"Untere Nußbiene (4403) SPÄTBURGUNDER___2",null,null,null,0.6,150,50,null,"","","","","","",""]
[1,"Untere Nußbiene (4403) SPÄTBURGUNDER___3",null,null,null,0.6,150,50,null,"","","","","","",""]
[2,"Im Glockenzehnt (9970) GOLDMUSKATELLER",null,null,"Trester-Dreijahresgabe",0.4,150,50,"29,03.2021","Trester  (1 t = 2m3)",150,8108.1081081081084,60,18.648648648648649,5.6756756756756745,"organisch"]
[2,"Im Glockenzehnt (9970) GOLDMUSKATELLER___2",null,null,null,0.4,150,50,null,null,null,"","","","",""]
[2,"Im Glockenzehnt (9970) GOLDMUSKATELLER___3",null,null,null,0.4,150,50,null,null,null,"","","","",""]
[2,"Im Glockenzehnt (9982) REGENT",null,null,"Trester-Dreijahresgabe",0.8,150,50,null,{"$f":"IF(ISBLANK(J30),\"\",J30)","v":"Trester  (1 t = 2m3)"},{"$f":"IF(ISBLANK(K30),\"\",K30)","v":150},16216.216216216217,120,37.297297297297298,11.351351351351349,"organisch"]
[2,"Im Glockenzehnt (9982) REGENT___2",null,null,null,0.8,150,50,null,"","","","","","",""]
[2,"Im Glockenzehnt (9982) REGENT___3",null,null,null,0.8,150,50,null,"","","","","","",""]
[]
[null,null,null,null,"auszuweisende Flächen:",{"$f":"IF(SUM(F19:F36)=0,\"\",SUM(F19:F36)/3)","v":3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"kg/Restfläche"]
[null,null,null,null,"restliche Flächen:",{"$f":"IF(Start!R12=\"\",\"\",Start!R12-SUM(F37))","v":31},null,null,null,null,null,{"$f":"IF(OR(J40=\"\",K40=\"\",F40=\"\"),\"\",IF(VLOOKUP(J40,Düngung,2,0)<=0,K40*F40/VLOOKUP(J40,Düngung,3,0)*100,K40*F40/VLOOKUP(J40,Düngung,2,0)*100))","v":""},{"$f":"IF(OR(J40=\"\",K40=\"\",F40=\"\"),\"\",IF(VLOOKUP(J40,Düngung,2,0)<=0,0,L40*VLOOKUP(J40,Düngung,2,0)/100))","v":""},{"$f":"IF(OR(J40=\"\",L40=\"\"),\"\",L40*VLOOKUP(J40,Düngung,3,0)/100)","v":""},{"$f":"IF(OR(J40=\"\",M40=\"\"),\"\",L40*VLOOKUP(J40,Düngung,4,0)/100)","v":""},{"$f":"IF(OR(J40=\"\",K40=\"\"),\"\",VLOOKUP(J40,Düngung,5,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(F40=\"\",\"\",F40)","v":31},null,null,null,null,null,{"$f":"IF(OR(J41=\"\",K41=\"\",F41=\"\"),\"\",IF(VLOOKUP(J41,Düngung,2,0)<=0,K41*F41/VLOOKUP(J41,Düngung,3,0)*100,K41*F41/VLOOKUP(J41,Düngung,2,0)*100))","v":""},{"$f":"IF(OR(J41=\"\",K41=\"\",F41=\"\"),\"\",IF(VLOOKUP(J41,Düngung,2,0)<=0,0,L41*VLOOKUP(J41,Düngung,2,0)/100))","v":""},{"$f":"IF(OR(J41=\"\",L41=\"\"),\"\",L41*VLOOKUP(J41,Düngung,3,0)/100)","v":""},{"$f":"IF(OR(J41=\"\",M41=\"\"),\"\",L41*VLOOKUP(J41,Düngung,4,0)/100)","v":""},""]
[null,null,null,null,null,{"$f":"IF(F41=\"\",\"\",F41)","v":31}]
[null,null,null,null,null,{"$f":"IF(F42=\"\",\"\",F42)","v":31}]

{"sheet":"P2O5 Düngung","index":5,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[[18,0,19,0],[18,1,19,3],[18,4,19,4],[18,5,19,5],[1,15,1,16],[18,12,18,14],[18,6,18,7],[20,4,22,4],[23,4,25,4]]}
["Betrieblicher P2O5-Einsatz für Ertragsanlagen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       DLR Rheinpfalz"]
["Betriebsname",{"$f":"IF(ISBLANK(Start!E10),\"\",Start!E10)","v":"Weingut Mustermann"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Version:",{"$f":"'Betrieblicher Nährstoffeinsatz'!Q3","v":"1.0.0"}]
["Strasse Hausnr.",{"$f":"IF(ISBLANK(Start!E11),\"\",Start!E11)","v":"Riesling-Weg 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,"     Stand:    ",{"$f":"'Betrieblicher Nährstoffeinsatz'!Q4","v":"2021-01-15"}]
["PLZ Ort",{"$f":"IF(ISBLANK(Start!E12),\"\",Start!E12)","v":"67435 Neustadt/Wstr."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Düngejahr:",{"$f":"IF(ISBLANK(Start!L10),\"\",Start!L10)","v":2021}]
[]
[]
[]
[]
[]
[null,null,"Datum der Erstellung / Unterschrift:","2021-03-28"]
[null,null,null,null,"______________________________________________"]
[]
[]
[]
[]
["Schlagbezeichnung","betriebsinterne Parzellenbezeichnung",null,null,"Bemerkung","Parzellen-\ngröße (ha)","P-Düngebedarf (kg/ha)",null,"Ausbring-","Düngemittel","P2O5","Düngemittel","Betrieblicher Nährstoffeinsatz pro Parzelle"]
[null,null,null,null,null,null,"3-Jahresgabe","1-Jahresgabe","datum","Name","(kg/ha)","(kg/Parzelle)","Gesamt-N (kg)","Gesamt-Phosphat (kg)","N verfügbar (kg)"]
["Am Eberacker","8480 - Weißburgunder",null,null,"Trester-Dreijahresgabe",0.7,0,0,"2021-03-29","Trester  (1 t = 2m3)",30,{"$f":"IF(OR(J21=\"\",K21=\"\"),\"\",K21*F21/VLOOKUP(J21,DüngungP,3,0)*100)","v":9130.434782608696},{"$f":"IF(OR(J21=\"\",K21=\"\",F21=\"\"),\"\",IF(VLOOKUP(J21,DüngungP,2,0)<=0,0,L21*VLOOKUP(J21,DüngungP,2,0)/100))","v":67.565217391304344},{"$f":"IF(OR(J21=\"\",L21=\"\"),\"\",L21*VLOOKUP(J21,DüngungP,3,0)/100)","v":21},{"$f":"IF(OR(J21=\"\",M21=\"\"),\"\",L21*VLOOKUP(J21,DüngungP,4,0)/100)","v":6.391304347826086},{"$f":"IF(OR(J21=\"\",K21=\"\"),\"\",VLOOKUP(J21,Düngung,5,FALSE))","v":"organisch"}]
["Am Eberacker","8480 - Weißburgunder___2",null,null,null,0.7,0,0,null,null,null,"","","","",""]
["Am Eberacker","8480 - Weißburgunder___3",null,null,null,0.7,0,0,null,null,null,"","","","",""]
["Im Glockenzehnt","9976 - Riesling",null,null,"Trester-Dreijahresgabe",1.4,0,0,"2021-03-29","Trester  (1 t = 2m3)",30,18260.869565217392,135.13043478260869,42,12.782608695652172,"organisch"]
["Im Glockenzehnt","9976 - Riesling___2",null,null,null,1.4,0,0,null,null,null,"","","","",""]
["Im Glockenzehnt","9976 - Riesling___3",null,null,null,1.4,0,0,null,null,null,"","","","",""]
[]
[null,null,null,null,"auszuweisende Flächen:",{"$f":"IF(SUM(F19:F27)=0,\"\",SUM(F19:F27)/3)","v":2.0999999999999996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"kg/Restfläche"]
[null,null,null,null,"restliche Flächen:",{"$f":"IF(Start!R12=\"\",\"\",Start!R12-SUM(F28))","v":31.9},null,null,null,null,null,{"$f":"IF(OR(J31=\"\",K31=\"\"),\"\",K31*F31/VLOOKUP(J31,DüngungP,3,0)*100)","v":""},{"$f":"IF(OR(J31=\"\",K31=\"\",F31=\"\"),\"\",IF(VLOOKUP(J31,DüngungP,2,0)<=0,0,L31*VLOOKUP(J31,DüngungP,2,0)/100))","v":""},{"$f":"IF(OR(J31=\"\",L31=\"\"),\"\",L31*VLOOKUP(J31,DüngungP,3,0)/100)","v":""},{"$f":"IF(OR(J31=\"\",M31=\"\"),\"\",L31*VLOOKUP(J31,DüngungP,4,0)/100)","v":""},{"$f":"IF(OR(J31=\"\",K31=\"\"),\"\",VLOOKUP(J31,Düngung,5,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(F31=\"\",\"\",F31)","v":31.9},null,null,null,null,null,{"$f":"IF(OR(J32=\"\",K32=\"\"),\"\",K32*F32/VLOOKUP(J32,DüngungP,3,0)*100)","v":""},{"$f":"IF(OR(J32=\"\",K32=\"\",F32=\"\"),\"\",IF(VLOOKUP(J32,DüngungP,2,0)<=0,0,L32*VLOOKUP(J32,DüngungP,2,0)/100))","v":""},{"$f":"IF(OR(J32=\"\",L32=\"\"),\"\",L32*VLOOKUP(J32,DüngungP,3,0)/100)","v":""},{"$f":"IF(OR(J32=\"\",M32=\"\"),\"\",L32*VLOOKUP(J32,DüngungP,4,0)/100)","v":""},{"$f":"IF(OR(J32=\"\",K32=\"\"),\"\",VLOOKUP(J32,Düngung,5,FALSE))","v":""}]

{"sheet":"P2O5 Bedarf","index":6,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":true,"merged":[[8,4,8,5],[9,3,10,3],[9,4,10,4],[9,5,10,5],[8,6,9,8]]}
["Phosphat-Düngebedarfsermittlung für Ertragsanlagen",null,null,null,null,null,null,null,null,"        DLR Rheinpfalz"]
[null,null,null,null,null,null,null,null,null,"Version:",{"$f":"'Betrieblicher Nährstoffeinsatz'!Q3","v":"1.0.0"}]
[null,"Betriebsname  ",{"$f":"IF(Start!E10=\"\",\"\",Start!E10)","v":"Weingut Mustermann"},null,null,null,null,null,null,"     Stand:",{"$f":"'Betrieblicher Nährstoffeinsatz'!Q4","v":"2021-01-15"}]
[null,"Strasse Hausnr.  ",{"$f":"IF(Start!E11=\"\",\"\",Start!E11)","v":"Riesling-Weg 1"}]
[null,"PLZ Ort  ",{"$f":"IF(Start!E12=\"\",\"\",Start!E12)","v":"67435 Neustadt/Wstr."},null,null,null,"Düngejahr:",{"$f":"IF(ISBLANK(Start!L10),\"\",Start!L10)","v":2021}]
[]
[]
[]
[null,null,null,null,"Bodenuntersuchung nach CAL\nBodentiefe 0-30 cm",null,"P2O5  Düngebedarf pro Jahr"]
[null,null,null,"Parzellen-größe\n(ha)","Jahr\n der Unter-suchung","P2O5\nin mg/100g\nBoden"]
["lfd","Schlagbezeichnung","Parzellenbezeichung (kein Pflichtfeld)",null,null,null,"(kg/Parzelle)","(kg/ha)","im Schlag (kg/ha)"]
[1,"Am Eberacker","8480 - Weißburgunder",0.7,2019,56,{"$f":"IF(OR(D12=\"\",H12=\"\"),\"\",D12*H12)","v":0},{"$f":"IF(F12=\"\",\"\",IF(F12<12,30,IF(F12<=20,15,0)))","v":0},{"$f":"IF(SUMIF(B12:B30,B12,J12:J30)=0,\"\",SUMIF((B12:B30),B12,G12:G30)/SUMIF(B12:B30,B12,J12:J30))","v":0},{"$f":"IF(F12=\"\",\"\",D12)","v":0.7}]
[{"$f":"A12+1","v":2},"Im Glockenzehnt","9976 - Riesling",1.4,2019,38,{"$f":"IF(OR(D13=\"\",H13=\"\"),\"\",D13*H13)","v":0},{"$f":"IF(F13=\"\",\"\",IF(F13<12,30,IF(F13<=20,15,0)))","v":0},{"$f":"IF(B13=B12,\"\",IF(SUMIF(B12:B30,B13,J12:J30)=0,\"\",SUMIF((B12:B30),B13,G12:G30)/SUMIF(B12:B30,B13,J12:J30)))","v":0},{"$f":"IF(F13=\"\",\"\",D13)","v":1.4}]
[{"$f":"A13+1","v":3},null,null,null,null,null,"","",{"$f":"IF(B14=B13,\"\",IF(SUMIF(B12:B30,B14,J12:J30)=0,\"\",SUMIF((B12:B30),B14,G12:G30)/SUMIF(B12:B30,B14,J12:J30)))","v":""},""]
[4,null,null,null,null,null,"","",{"$f":"IF(B15=B14,\"\",IF(SUMIF(B12:B30,B15,J12:J30)=0,\"\",SUMIF((B12:B30),B15,G12:G30)/SUMIF(B12:B30,B15,J12:J30)))","v":""},""]
[5,null,null,null,null,null,"","",{"$f":"IF(B16=B15,\"\",IF(SUMIF(B12:B30,B16,J12:J30)=0,\"\",SUMIF((B12:B30),B16,G12:G30)/SUMIF(B12:B30,B16,J12:J30)))","v":""},""]
[6,null,null,null,null,null,"","",{"$f":"IF(B17=B16,\"\",IF(SUMIF(B12:B30,B17,J12:J30)=0,\"\",SUMIF((B12:B30),B17,G12:G30)/SUMIF(B12:B30,B17,J12:J30)))","v":""},""]
[7,null,null,null,null,null,"","",{"$f":"IF(B18=B17,\"\",IF(SUMIF(B12:B30,B18,J12:J30)=0,\"\",SUMIF((B12:B30),B18,G12:G30)/SUMIF(B12:B30,B18,J12:J30)))","v":""},""]
[8,null,null,null,null,null,{"$f":"IF(OR(D19=\"\",H19=\"\"),\"\",D19*H19)","v":""},{"$f":"IF(F19=\"\",\"\",IF(F19<12,30,IF(F19<=20,15,0)))","v":""},{"$f":"IF(B19=B18,\"\",IF(SUMIF(B12:B30,B19,J12:J30)=0,\"\",SUMIF((B12:B30),B19,G12:G30)/SUMIF(B12:B30,B19,J12:J30)))","v":""},""]
[9,null,null,null,null,null,"","",{"$f":"IF(B20=B19,\"\",IF(SUMIF(B12:B30,B20,J12:J30)=0,\"\",SUMIF((B12:B30),B20,G12:G30)/SUMIF(B12:B30,B20,J12:J30)))","v":""},""]
[10,null,null,null,null,null,{"$f":"IF(OR(D21=\"\",H21=\"\"),\"\",D21*H21)","v":""},{"$f":"IF(F21=\"\",\"\",IF(F21<12,30,IF(F21<=20,15,0)))","v":""},{"$f":"IF(B21=B20,\"\",IF(SUMIF(B12:B30,B21,J12:J30)=0,\"\",SUMIF((B12:B30),B21,G12:G30)/SUMIF(B12:B30,B21,J12:J30)))","v":""},""]
[11,null,null,null,null,null,"","",{"$f":"IF(B22=B21,\"\",IF(SUMIF(B12:B30,B22,J12:J30)=0,\"\",SUMIF((B12:B30),B22,G12:G30)/SUMIF(B12:B30,B22,J12:J30)))","v":""},""]
[12,null,null,null,null,null,"","",{"$f":"IF(B23=B22,\"\",IF(SUMIF(B12:B30,B23,J12:J30)=0,\"\",SUMIF((B12:B30),B23,G12:G30)/SUMIF(B12:B30,B23,J12:J30)))","v":""},""]
[13,null,null,null,null,null,"","",{"$f":"IF(B24=B23,\"\",IF(SUMIF(B12:B30,B24,J12:J30)=0,\"\",SUMIF((B12:B30),B24,G12:G30)/SUMIF(B12:B30,B24,J12:J30)))","v":""},""]
[14,null,null,null,null,null,{"$f":"IF(OR(D25=\"\",H25=\"\"),\"\",D25*H25)","v":""},{"$f":"IF(F25=\"\",\"\",IF(F25<12,30,IF(F25<=20,15,0)))","v":""},{"$f":"IF(B25=B24,\"\",IF(SUMIF(B12:B30,B25,J12:J30)=0,\"\",SUMIF((B12:B30),B25,G12:G30)/SUMIF(B12:B30,B25,J12:J30)))","v":""},""]
[15,null,null,null,null,null,"","",{"$f":"IF(B26=B25,\"\",IF(SUMIF(B12:B30,B26,J12:J30)=0,\"\",SUMIF((B12:B30),B26,G12:G30)/SUMIF(B12:B30,B26,J12:J30)))","v":""},""]
[16,null,null,null,null,null,{"$f":"IF(OR(D27=\"\",H27=\"\"),\"\",D27*H27)","v":""},{"$f":"IF(F27=\"\",\"\",IF(F27<12,30,IF(F27<=20,15,0)))","v":""},{"$f":"IF(B27=B26,\"\",IF(SUMIF(B12:B30,B27,J12:J30)=0,\"\",SUMIF((B12:B30),B27,G12:G30)/SUMIF(B12:B30,B27,J12:J30)))","v":""},{"$f":"IF(F27=\"\",\"\",D27)","v":""}]
[17,null,null,null,null,null,{"$f":"IF(OR(D28=\"\",H28=\"\"),\"\",D28*H28)","v":""},{"$f":"IF(F28=\"\",\"\",IF(F28<12,30,IF(F28<=20,15,0)))","v":""},{"$f":"IF(B28=B27,\"\",IF(SUMIF(B12:B30,B28,J12:J30)=0,\"\",SUMIF((B12:B30),B28,G12:G30)/SUMIF(B12:B30,B28,J12:J30)))","v":""},{"$f":"IF(F28=\"\",\"\",D28)","v":""}]
[18,null,null,null,null,null,{"$f":"IF(OR(D29=\"\",H29=\"\"),\"\",D29*H29)","v":""},{"$f":"IF(F29=\"\",\"\",IF(F29<12,30,IF(F29<=20,15,0)))","v":""},{"$f":"IF(B29=B28,\"\",IF(SUMIF(B12:B30,B29,J12:J30)=0,\"\",SUMIF((B12:B30),B29,G12:G30)/SUMIF(B12:B30,B29,J12:J30)))","v":""},{"$f":"IF(F29=\"\",\"\",D29)","v":""}]
[{"$f":"A29+1","v":19},null,null,null,null,null,{"$f":"IF(OR(D30=\"\",H30=\"\"),\"\",D30*H30)","v":""},{"$f":"IF(F30=\"\",\"\",IF(F30<12,30,IF(F30<=20,15,0)))","v":""},{"$f":"IF(B30=B29,\"\",IF(SUMIF(B12:B30,B30,J12:J30)=0,\"\",SUMIF((B12:B30),B30,G12:G30)/SUMIF(B12:B30,B30,J12:J30)))","v":""},{"$f":"IF(F30=\"\",\"\",D30)","v":""}]

{"sheet":"N-Bedarf","index":7,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,0,0,2],[5,6,5,7],[6,3,6,5],[7,7,7,8]]}
["Stickstoff-Düngebedarfsermittlung für Ertragsanlagen im Weinbau"]
[null,"Betrieb:","Düngejahr:"]
["Betriebsname",{"$f":"IF(ISBLANK('Betrieblicher Nährstoffeinsatz'!C3),\"\",'Betrieblicher Nährstoffeinsatz'!C3)","v":"Weingut Mustermann"},{"$f":"IF(ISBLANK('Betrieblicher Nährstoffeinsatz'!O7),\"\",'Betrieblicher Nährstoffeinsatz'!O7)","v":2021}]
["Strasse Hausnr.",{"$f":"IF(ISBLANK('Betrieblicher Nährstoffeinsatz'!C4),\"\",'Betrieblicher Nährstoffeinsatz'!C4)","v":"Riesling-Weg 1"}]
["PLZ Ort",{"$f":"IF(ISBLANK('Betrieblicher Nährstoffeinsatz'!C5),\"\",'Betrieblicher Nährstoffeinsatz'!C5)","v":"67435 Neustadt/Wstr."}]
[null,null,null,null,null,null,"    DLR Rheinpfalz"]
[null,null,null,"N-Düngebedarf (kg N/ha)",null,null,"Version:",{"$f":"'Betrieblicher Nährstoffeinsatz'!Q3","v":"1.0.0"}]
["Bewirtschaftungs-\neinheit","Bezeichnung","Bemerkung","maximal","abzüglich\norganisch","nachzu-\nführen","     Stand:",{"$f":"'Betrieblicher Nährstoffeinsatz'!Q4","v":"2021-01-15"}]
["BEW 1",null,null,{"$f":"'N-Düngebedarf 1-8'!F42","v":50},{"$f":"IF(AND('N-Düngebedarf 1-8'!F67=\"\",'N-Düngebedarf 1-8'!F68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!F67:F68))","v":""},{"$f":"IF(D9=\"\",\"\",IF(E9=\"\",D9,MAX(0,D9-E9)))","v":50}]
["BEW 2",null,null,{"$f":"'N-Düngebedarf 1-8'!G42","v":50},{"$f":"IF(AND('N-Düngebedarf 1-8'!G67=\"\",'N-Düngebedarf 1-8'!G68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!G67:G68))","v":""},{"$f":"IF(D10=\"\",\"\",IF(E10=\"\",D10,MAX(0,D10-E10)))","v":50}]
["BEW 3",null,null,{"$f":"'N-Düngebedarf 1-8'!H42","v":""},{"$f":"IF(AND('N-Düngebedarf 1-8'!H67=\"\",'N-Düngebedarf 1-8'!H68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!H67:H68))","v":""},{"$f":"IF(D11=\"\",\"\",IF(E11=\"\",D11,MAX(0,D11-E11)))","v":""}]
["BEW 4",null,null,{"$f":"'N-Düngebedarf 1-8'!I42","v":""},{"$f":"IF(AND('N-Düngebedarf 1-8'!I67=\"\",'N-Düngebedarf 1-8'!I68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!I67:I68))","v":""},""]
["BEW 5",null,null,{"$f":"'N-Düngebedarf 1-8'!J42","v":""},{"$f":"IF(AND('N-Düngebedarf 1-8'!J67=\"\",'N-Düngebedarf 1-8'!J68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!J67:J68))","v":""},""]
["BEW 6",null,null,{"$f":"'N-Düngebedarf 1-8'!K42","v":""},{"$f":"IF(AND('N-Düngebedarf 1-8'!K67=\"\",'N-Düngebedarf 1-8'!K68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!K67:K68))","v":""},""]
["BEW 7",null,null,{"$f":"'N-Düngebedarf 1-8'!L42","v":""},{"$f":"IF(AND('N-Düngebedarf 1-8'!L67=\"\",'N-Düngebedarf 1-8'!L68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!L67:L68))","v":""},""]
["BEW 8",null,null,{"$f":"'N-Düngebedarf 1-8'!M42","v":""},{"$f":"IF(AND('N-Düngebedarf 1-8'!M67=\"\",'N-Düngebedarf 1-8'!M68=\"\"),\"\",SUM('N-Düngebedarf 1-8'!M67:M68))","v":""},""]

{"sheet":"N-Düngebedarf 1-8","index":8,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":true,"merged":[[4,11,5,11],[10,0,10,2],[10,3,10,4],[5,0,5,1],[7,0,7,2],[7,3,7,4],[4,7,5,7],[15,0,15,2],[15,3,15,4],[11,0,11,2],[11,3,11,4],[11,5,13,5],[4,0,4,2],[4,5,5,5],[4,6,5,6],[4,3,6,4],[11,9,13,9],[13,0,13,2],[13,3,13,4],[11,6,13,6],[20,3,20,4],[21,3,21,4],[19,0,21,0],[19,3,19,4],[29,12,34,12],[32,1,32,2],[33,1,34,1],[27,0,28,2],[27,5,28,5],[29,11,34,11],[27,6,28,6],[29,0,34,0],[29,1,29,2],[29,5,34,5],[29,6,34,6],[30,1,30,2],[31,1,31,2],[27,10,28,10],[27,11,28,11],[27,12,28,12],[16,5,25,5],[16,6,25,6],[51,9,52,9],[51,10,52,10],[51,11,52,11],[51,7,52,7],[51,8,52,8],[45,0,45,2],[45,3,45,12],[16,3,16,4],[22,3,22,4],[24,3,24,4],[27,9,28,9],[27,8,28,8],[29,7,34,7],[27,7,28,7],[29,10,34,10],[51,12,52,12],[40,3,40,9],[35,10,37,10],[35,11,37,11],[35,12,37,12],[35,9,37,9],[24,0,25,0],[29,8,34,8],[29,9,34,9],[41,0,41,2],[41,3,41,4],[35,7,37,7],[35,0,37,0],[35,5,37,5],[35,6,37,6],[43,0,43,2],[35,8,37,8],[38,0,38,2],[39,0,39,2],[43,3,43,4],[42,0,42,2],[42,3,42,4],[4,12,5,12],[11,10,13,10],[11,11,13,11],[11,12,13,12],[16,10,25,10],[16,11,25,11],[16,12,25,12],[4,9,5,9],[22,0,23,0],[23,3,23,4],[4,10,5,10],[11,7,13,7],[11,8,13,8],[16,7,25,7],[18,3,18,4],[25,3,25,4],[12,0,12,2],[12,3,12,4],[4,8,5,8],[8,3,8,4],[16,8,25,8],[16,9,25,9],[17,3,17,4],[16,0,18,0],[61,0,61,2],[57,3,57,4],[58,3,58,4],[59,3,59,4],[54,3,54,4],[56,3,56,4],[54,0,55,2],[61,3,61,6],[51,5,52,5],[51,6,52,6],[52,0,52,1],[51,0,51,2],[51,3,53,4],[76,9,76,11],[74,6,74,8],[75,6,75,8],[76,6,76,8],[62,11,62,12],[62,7,62,9],[63,7,63,9],[68,3,68,9],[69,0,69,2],[69,3,69,4],[66,0,66,2],[67,0,67,2],[63,11,63,12],[71,0,71,2],[73,3,73,5],[73,6,73,8],[73,9,73,11],[74,3,74,5],[75,3,75,5],[76,3,76,5],[74,9,74,11],[75,9,75,11],[77,9,77,11],[78,9,78,11],[79,9,79,11],[80,9,80,11],[81,9,81,11],[77,3,77,5],[78,3,78,5],[79,3,79,5],[80,3,80,5],[81,3,81,5],[77,6,77,8],[78,6,78,8],[79,6,79,8],[80,6,80,8],[81,6,81,8]]}
["Hinweise zur Bedienung der Excel-Anwendung:"]
["1. Anwahl Bewirtschaftungseinheit: Die Bewirtschaftungseinheit (z. B. Feld \"BEW 1\") anklicken. Die Spalte färbt sich leuchtend grün."]
["2. Auswahl N-Zu- und Abschläge: Die N-Zu- und N-Abschläge durch anklicken des gewünschten Feldes übertragen (z. B. \"+ 20\")!"]
[]
["Stickstoff-Düngebedarfsermittlung für Ertragsanlagen im Weinbau",null,null,"Zu- und Abschläge\n(kg Rein-N/ha)\n6 6 6",null,"BEW 1","BEW 2","BEW 3","BEW 4","BEW 5","BEW 6","BEW 7","BEW 8"]
[{"$f":"\"Betrieb: \" & IF(ISBLANK(Start!E10),\"\",Start!E10)","v":"Betrieb: Weingut Mustermann"},null,{"$f":"\"Düngejahr: \" & IF(ISBLANK(Start!L10),\"\",Start!L10)","v":"Düngejahr: 2021"}]
[]
["Ausgangswert bei einem Traubenertrag von 7 bis 14 t/ha",null,null,"+ 40",null,40,40,40,40,40,40,40,40]
["Traubenertrag",null,"> 14 t/ha","+ 10"]
[]
["Rebenwachstum"]
["stark",null,null,"- 30",null,0,0]
["ausgeglichen (normal, mittel)",null,null," +/- 0"]
["schwach",null,null," + 30*"]
[]
["Humusgehalt in 0 bis 30 cm Bodentiefe [in %]"]
["Leichte Böden \n(S und l‘S)",null,"unter 1,5 % ","+ 20*",null,20,20]
[null,null,"1,5 bis 2,5 % "," +/- 0"]
[null,null,"über 2,5 % ","- 40"]
["Mittlere bis schwere Böden \n(lS, sL, uL, t‘L, tL, lT und T)",null,"unter 1,8 % ","+ 20*"]
[null,null,"1,8 bis 3,0 % "," +/- 0"]
[null,null,"über 3,0 % ","- 40"]
["Steinhaltige Böden \n(ab 20 % Steine)",null,"unter 4,0 % "," +/- 0"]
[null,null,"über 4,0 % ","- 40"]
["Skelettreiche Böden \n(ab 50 % Steine)",null,"unter 7,0 % "," +/- 0*"]
[null,null,"ab 7,0 %","- 40"]
[]
["Bodenpflege",null,null,"jede","jede",0,0,0,0,0,1,0,0]
[null,null,null,"2. Gasse","Gasse"]
["Dauerbegrünung mit \nGräsern und anderen \nNichtleguminosen","Einsaat auf im Vorfeld offengehaltenem Boden",null,"+ 20   ","+ 40   ",0,0]
[null,"Einsaat nach vorherigem Begrünungsumbruch",null,"+/- 0   ","+/- 0   "]
[null,"Etablierte Dauerbegrünung",null,"+/- 0   ","+/- 0   "]
[null,"Stören einer Dauerbegrünung",null,"- 15   ","- 30   "]
[null,"Umbruch","nach   5 Jahren","- 20   ","- 40   "]
[null,null,"nach 10 Jahren","- 40   ","- 80   "]
["Dauerbegrünungen \nmit Leguminosen","Walzen/Mulchen","ab       50 % Leguminosen-Anteil","- 10   ","- 20   "]
[null,"Umbruch","unter 50 % Leguminosen-Anteil","- 25   ","- 50   "]
[null,"Umbruch","ab       50 % Leguminosen-Anteil","- 50   ","- 100   "]
["Offenhalten über Sommer (Umbruch Herbst-/Winterbegrünung)",null,null,"- 10   ","- 20   ",-10,-10]
["Abdeckung zur Schonung der Bodenwasservorräte (Rinde, Stroh, Holzhäcksel)",null,null,"- 10   ","- 20   "]
[null,null,null,"*Humusversorgung verbessern (Beratungsmaterial)"]
["Ein-Jahresgabe (kg N/ha)",null,null,"max. 80 kg N/ha",null,{"$f":"IF(AND(ISBLANK(F9),ISBLANK(F12),ISBLANK(F17),ISBLANK(F30),ISBLANK(F36),ISBLANK(F39),ISBLANK(F40),F44=\"\"),\"\",IF(AND(ISBLANK(F9),ISBLANK(F12),ISBLANK(F17),ISBLANK(F30),ISBLANK(F36),ISBLANK(F39),ISBLANK(F40),F44<>\"\"),40-IF(F44=\"\",0,F44),MAX(0,MIN(80,SUM(F30:F40,F17,F12,F9,F8)-IF(F44=\"\",0,F44)))))","v":50},{"$f":"IF(AND(ISBLANK(G9),ISBLANK(G12),ISBLANK(G17),ISBLANK(G30),ISBLANK(G36),ISBLANK(G39),ISBLANK(G40),G44=\"\"),\"\",IF(AND(ISBLANK(G9),ISBLANK(G12),ISBLANK(G17),ISBLANK(G30),ISBLANK(G36),ISBLANK(G39),ISBLANK(G40),G44<>\"\"),40-IF(G44=\"\",0,G44),MAX(0,MIN(80,SUM(G30:G40,G17,G12,G9,G8)-IF(G44=\"\",0,G44)))))","v":50},"","","","","",""]
["Drei-Jahresgabe (kg N/ha)",null,null,"max. 240 kg N/ha",null,{"$f":"IF(F42=\"\",\"\",(F42-SUM(F67:F68))*3)","v":150},{"$f":"IF(G42=\"\",\"\",(G42-SUM(G67:G68))*3)","v":150},"","","","","",""]
["N-Anteil aus organischer Düngung",null,null,null,null,{"$f":"F70","v":""},{"$f":"G70","v":""},"","","","","",""]
[]
["Ort, Datum, Unterschrift des Betriebsinhabers: "]
["Organisches Modul"]
["1. Anwahl Bewirtschaftungseinheit: Die Bewirtschaftungseinheit (z. B. Feld \"BEW 1\") anklicken. Die Spalte färbt sich leuchtend grün."]
["2. Anwahl Jahreszahl:  Die Jahreszahl (Feld \"2018\") anklicken. Die Zelle rechts daneben färbt sich leuchtend grün."]
["3. Ausbringmenge: Die Ausbringmenge im Feld rechts neben der Jahreszahl in der korrekten Einheit (t oder m³) eintragen"]
["4. Auswahl Düngung: Grünes Feld bei Kompost, etc. am rechten Rand (Pfeil) anwählen, Düngerart auswählen (z. B. \"Holzhächsel\")"]
["Stickstoff-Düngebedarfsermittlung für Ertragsanlagen im Weinbau",null,null,"Ausbringmenge\nin t (m³) / ha\n6 6 6",null,"BEW 1","BEW 2","BEW 3","BEW 4","BEW 5","BEW 6","BEW 7","BEW 8"]
[{"$f":"\"Betrieb: \" & IF(ISBLANK(Start!E10),\"\",Start!E10)","v":"Betrieb: Weingut Mustermann"},null,{"$f":"\"Düngejahr: \" & IF(ISBLANK(Start!L10),\"\",Start!L10)","v":"Düngejahr: 2021"}]
[]
["Organische Düngung"]
[]
["aktuelles Jahr",null,{"$f":"IF(ISBLANK(Start!L10),\"\",Start!L10)","v":2021}]
[null,null,{"$f":"IF(C57=\"\",\"\",C57-1)","v":2020}]
[null,null,{"$f":"IF(C57=\"\",\"\",C57-2)","v":2019}]
[null,null,{"$f":"IF(C57=\"\",\"\",C57-3)","v":2018}]
[]
["Düngung"]
["Kompost,\nPflanzenhilfsstoffe",null," ",null,null,null,null,null,null,null,null,"Reststoffe\nWeinbereitung"]
["Festmist",null,null,null,null,null,null,null,null,null,null,"Sonstige"]
[]
["Anzurechnende Menge (Rein-N kg/ha)",null,null,null,null,0,0,0,1,0,1]
["aus organischer Düngung des aktuellen Jahres (geplant)",null,null,null,null,null,{"$f":"IF(ISBLANK(G57),\"\",G57)","v":""},"","","","","",""]
[{"$f":"\"aus organischer Düngung der Vorjahre \" & C60 & \" - \" & C58","v":"aus organischer Düngung der Vorjahre 2018 - 2020"},null,null,null,null,{"$f":"IF(AND(ISBLANK(F58),ISBLANK(F59),ISBLANK(F60)),\"\",SUM(F58:F60))","v":""},"","","","","","",""]
[]
["aus organischer Dügung gesamt",null,null,null,null,{"$f":"IF(AND(F67=\"\",F68=\"\"),\"\",SUM(F67:F68))","v":""},{"$f":"IF(AND(G67=\"\",G68=\"\"),\"\",SUM(G67:G68))","v":""},"","","","","",""]
[]
["Art der organischen Düngung"]
[]
[null,null,{"$f":"C57","v":2021},{"$f":"IF(C74=\"\",\"\",C74-1)","v":2020},null,null,{"$f":"IF(C74=\"\",\"\",D74-1)","v":2019},null,null,{"$f":"IF(C74=\"\",\"\",G74-1)","v":2018}]
["Bewirtschaftungs-",{"$f":"F52","v":"BEW 1"}]
["einheit",{"$f":"G52","v":"BEW 2"}]
[null,{"$f":"H52","v":"BEW 3"}]
[null,{"$f":"I52","v":"BEW 4"}]
[null,{"$f":"J52","v":"BEW 5"}]
[null,{"$f":"K52","v":"BEW 6"}]
[null,{"$f":"L52","v":"BEW 7"}]
[null,{"$f":"M52","v":"BEW 8"}]