{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["IKW_I_Eingabe","IKW_I_Ansicht","IKW_II_Eingabe","IKW_II_Ansicht","Dokumentation","Information","Beispiel"],"not_rendered":{"defined_names":2,"comments":7},"read":"whole","date_system":"1900"}

{"sheet":"IKW_I_Eingabe","index":0,"n_rows":238,"n_cols":17,"rows_kept":238,"merged":[[0,6,0,9],[0,10,0,12],[2,6,2,13],[4,6,4,12],[20,13,20,14],[27,3,27,4],[30,1,30,2],[30,7,30,9],[30,13,30,15],[46,1,46,2],[46,7,46,9],[46,13,46,15],[48,1,48,2],[48,7,48,9],[48,13,48,15],[52,1,52,2],[52,7,52,9],[52,13,52,15],[56,1,56,2],[56,7,56,9],[56,13,56,15],[216,1,234,17]]}
[null,"W     e     r     t     ä     s     t     u     n     g","Lokalität >",null,null,"Besitz",{"$nulls":4},"RFA",{"$nulls":3},"Abt."]
[]
[null,"I n v e s t i t i o n s k a l k u l a t i o n","vom","Adresse",{"$nulls":10},"GK-RW"]
[]
[null,"Erst.:FAR Schmitz, LB Wald u. Holz NRW; LVFA Arnsberger Wald",{"$f":"TODAY()","v":"2014-01-07"},"Resultat",null,null,{"$f":"IF($C$170>0,\"Netto-Rendite je geäst.Erntebaum bis \"&C121,IF($C$170<0,\"Netto-Verlust je geäst.Erntebaum bis \"&C121,\"\"))","v":{"$error":"#VALUE!"}},{"$nulls":6},{"$f":"$C$170","v":{"$error":"#VALUE!"}},"GK-HW"]
[]
[null,"I. Bestand"]
[]
[null,"I A. Ist-Daten             E i n g a b e f o r m u l a r",{"$nulls":4},"I B. Soll-Daten",{"$nulls":6},"Eingabe erforderlich =","!"]
[]
[null,"Bestand                                                         [Baumart]",{"$nulls":4},"erwarteter BHD (d1,3) o. R. im Alter U                            [cm]",{"$nulls":9},"!"]
[]
[null,"Ertragsklasse                                                        [EKl.]",{"$nulls":4},"jährlicher BHD-Zuwachs bis Alter U                                [cm]",{"$nulls":9},"!"]
[]
[null,"Bestandesbegründung                                           [Jahr]",null,null,"!",null,"verbleibender Zeitraum bis Alter U                               [Jahre]",{"$nulls":8},{"$f":"IF($P$13=0,\"\",ROUNDUP(($P$11-$C$19)/$P$13,0))","v":""}]
[]
[null,"Aktuelle Bestandesaufnahme                                 [Jahr]",null,null,"!",null,"Resultierende Umtriebszeit                                        [Jahre]",{"$nulls":8},{"$f":"IF(OR($C$15=\"\",$C$17=\"\",$P$15=\"\"),\"\",$C$17-$C$15+$P$15)","v":""}]
[]
[null,"aktueller BHD der zu ästenden Bäume o. R.           [cm]",null,null,"!",null,"entspricht Kalenderjahr im Alter U                                [Jahr]",{"$nulls":8},{"$f":"IF($P$17=\"\",\"\",$C$15+$P$17)","v":""}]
[]
[null,"Abholzigkeit Güteklasse A (Durchmesser-Abnahme)  [cm / lfdm]",null,null,"!",null,"Ggf. abweichende Umtriebszeit         [U]",{"$nulls":6},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",\"\"))","v":""}]
[]
[null,"Abholzigkeit Güteklasse B (GKl. C =  AbhzkB+1cm)  [cm / lfdm]",null,null,"!",null,"= astfreie Schicht [cm]  /  BHD [cm]   /  Jahr",{"$nulls":6},{"$f":"(O23-C19)/2","v":{"v":0,"d":"0.00"}},{"$f":"IF($P$11=\"\",0,IF($P$23>$P$19,$P$11+($P$23-$P$19)*$P$13,IF($P$23<$P$19,$P$11+($P$23-$P$19)*$P$13,$P$11)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(AND($P$21=\"\",$P$19=\"\"),\"\",IF($P$21>0,$C$15+$P$21,$P$19))","v":""}]
[]
[]
[]
[]
[null,"II. Maßnahme","Stufe I",{"$f":"IF(OR($C$33=\"\",$C$37=\"\",$C$37=0),\"\",(($P$11+$C$21)-($C$37*$C$21))/2-((($C$19+$C$21)-($C$37*$C$21)+($C$33-$C$17)*$P$13)/2))","v":""},{"$f":"(($P$11+$C$21)-($C$37*$C$21))/2-((($C$19+$C$21)-($C$37*$C$21)+($C$33-$C$17)*$P$13)/2)","v":{"v":0,"d":"0.0"}},null,null,"Stufe II",{"$f":"IF(OR($H$33=\"\",$H$37=\"\",$H$37=0),\"\",(($P$11+$C$21)-($H$37*$C$21))/2-((($C$19+$C$21)-($H$37*$C$21)+($H$33-$C$17)*$P$13)/2))","v":""},{"$f":"IF($I$28<>\"\",\"cm\",\"\")","v":""},{"$nulls":3},"Stufe III",{"$f":"IF(OR($N$33=\"\",$N$37=\"\",$N$37=0),\"\",(($P$11+$C$21)-($N$37*$C$21))/2-((($C$19+$C$21)-($N$37*$C$21)+($N$33-$C$17)*$P$13)/2))","v":""},{"$f":"IF(OR($O$28<>\"\",$I$28<>\"\",$D$28<>\"\"),\"cm astfr. Schicht\",\"\")","v":""}]
[]
[]
[]
[]
[null,"Maßnahme-Ausführung                                         [Jahr]",null,null,"!",{"$nulls":3},"(!)",{"$f":"IF(AND($H$33=\"\",$C$33=\"\"),\"\",IF($H$33=\"\",$C$33,$H$33))","v":""},{"$nulls":4},"(!)",{"$f":"IF(AND($N$33=\"\",$J$33=\"\",$C$33=\"\"),\"\",IF($N$33=\"\",$J$33,$N$33))","v":""}]
[]
[null,"Ästungshöhe von ...                                                 [m]",{"v":0,"d":"0.0"},{"$nulls":4},{"$f":"$C$37","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"$H$37","v":{"v":0,"d":"0.0"}}]
[]
[null,"Ästungshöhe bis ...                                                  [m]",null,null,"!",{"$nulls":3},"!",{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"<=W e r t ?\",\"\")","v":""},{"$nulls":4},"!",{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"<=W e r t ?\",\"\")","v":""}]
[]
[null,"Baumabstand: (Optimale Verteilung; 3-Eckverband)                [m]",{"$nulls":4},"[n]",{"$f":"10000/($C$39^2*0.8660254)","v":{"$error":"#DIV/0!"}},"(errechn. Anzahl /ha)",{"$nulls":3},"[n]",{"$f":"10000/($C$39^2*0.8660254)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Anzahl zu ästender Bäume je ha                     [Stück / ha]",null,null,"!",{"$nulls":3},"(!)",{"$f":"IF(AND($H$41=\"\",$C$41=\"\"),\"\",IF($H$41=\"\",$C$41,$H$41))","v":""},{"$nulls":4},"(!)",{"$f":"IF(AND($N$41=\"\",$J$41=\"\",$C$41=\"\"),\"\",IF($N$41=\"\",$J$41,$N$41))","v":""}]
[]
[null,"Maßnahmefläche                                                    [ha]"]
[]
[null,"Beschreibung:[Maschineneinsatz  /  Werkzeug  /  Verfahren] "]
[]
[]
[]
[]
[]
[null,"Ggf. Behandlungsmittel [Produktbezeichng]  /   [Menge/Baum]"]
[]
[]
[]
[null,"Dokumentation der Realisierung: [Jahr]/[Bemerkung]"]
[]
[]
[]
[]
[]
[null,"III. Kosten"]
[null,"III A. Basisdaten","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Alternative 1: Entgelt / lfdm (aktuellerWert/Folgejahre) [€ / lfdm]",null,null,"[!]",{"$nulls":3},"[!]",{"$f":"IF($H$64=\"\",\"\",IF(AND($H$64>0,$J$84>0),$H$64*$J$84,IF($H$64>0,$H$64,\"\")))","v":""},{"$nulls":4},"[!]",{"$f":"IF($N$64=\"\",\"\",IF(AND($N$64>0,$P$84>0),$N$64*$P$84,IF($N$64>0,$N$64,\"\")))","v":""}]
[]
[null,"\"\" 2: Stundenlohn (Folgejahre: Lohn x Steigerungsfaktor [LSF]) [€/h]",null,null,"!",null,null,{"$f":"IF(AND($C$66>0,$J$84>0),$C$66*$J$84,IF($C$66>0,$C$66,\"\"))","v":""},"in Jahren",{"$f":"IF(AND($C$33>0,$J$33>0),$J$33-$C$33,\"\")","v":""},{"$nulls":3},{"$f":"IF(AND($C$66>0,$P$84>0),$C$66*$P$84,IF($C$66>0,$C$66,\"\"))","v":""},"in Jahren",{"$f":"IF(AND($C$33>0,$P$33>0),$P$33-$C$33,\"\")","v":""}]
[]
[null,"Erschwerniszuschlag   (ggf. Baumbesteigung )                           [%]"]
[]
[null,"Zeitvorgabe Arbeitskraft (GAZ)                       [min. / Baum]",null,{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":""},"!",{"$nulls":3},"(!)",{"$f":"IF(AND($H$70>0,$H$66>0,$H$64>0),\"Nicht 1: und 2:!!!\",\"\")","v":""},{"$nulls":4},"(!)",{"$f":"IF(AND($N$70>0,$N$66>0,$N$64>0),\"Nicht 1: und 2:!!!\",\"\")","v":""}]
[]
[null,"Verwaltungskostenzuschlag / Dokumentationskosten   [%]",{"$nulls":7},{"$f":"IF(H72<>\"\",H72,IF($C$72=\"\",\"\",$C$72))","v":""},{"$nulls":5},{"$f":"IF($N$72<>\"\",$N$72,IF($C$72=\"\",\"\",$C$72))","v":""}]
[]
[null,"Maschineneinsatz                                             [€ / MAS]"]
[]
[null,"Zeitvorgabe Maschineneinsatz (MAS)           [min. / Baum]",null,{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":""},{"$nulls":5},{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"Ästg.-Höhe?\",\"\")","v":""},{"$nulls":5},{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"Ästg.-Höhe?\",\"\")","v":""}]
[]
[null,"Werkzeug (Entschädigung / Abnutzung)                         [€ / h]"]
[]
[null,"Behandlungsmittel                                         [€ / Einheit]"]
[]
[null,"Zinssatz für Aufzinsung der Investitionskosten (p)      [%]",{"v":3,"d":"3.00"},null,"!",null,null,"Lohnsteigerung [%]",null,{"v":2.5,"d":"2.50"},"!",null,null,"Lohnsteigerung (p) [% / a]",null,{"$f":"IF($J$82>0,$J$82,0)","v":{"v":2.5,"d":"2.50"}}]
[]
[null,"Aufzinsungsfaktor (Askontierung; p = % Zinsen)           [(1+p)n]",{"$f":"IF(OR($C$82=\"\",$C$86=\"\"),\"\",(1+$C$82/100)^$C$86)","v":""},{"$nulls":4},{"$f":"IF(OR($J$41=\"\",$H$86=\"\"),\"\",(1+$J$86/100)^$H$86)","v":""},"[LSF]",{"$f":"IF(OR($J$41=\"\",$J$66=\"\"),\"\",(1+$J$82/100)^$J$66)","v":""},{"$nulls":3},{"$f":"IF(OR($J$41=\"\",$N$86=\"\"),\"\",(1+$P$86/100)^$N$86)","v":""},"[LSF]",{"$f":"IF(OR($P$41=\"\",$P$66=\"\"),\"\",(1+$P$82/100)^$P$66)","v":""}]
[]
[null,"Aufzinsungs-Zeitraum bis Alter U  (n)                   [Jahre]",{"$f":"IF(OR($C$15=\"\",$C$33=\"\",$P$23=\"\"),\"\",$P$23-$C$33)","v":""},{"$nulls":4},{"$f":"IF(OR($C$15=\"\",$J$33=\"\",$P$23=\"\"),\"\",$P$23-$J$33)","v":""},"zu  [%]",{"$f":"IF($C$82=\"\",\"\",$C$82)","v":{"v":3,"d":"3.00"}},{"$nulls":3},{"$f":"IF(OR($C$15=\"\",$P$33=\"\",$P$23=\"\"),\"\",$P$23-$P$33)","v":""},"zu  [%]",{"$f":"IF($C$82=\"\",\"\",$C$82)","v":{"v":3,"d":"3.00"}}]
[]
[]
[null,"III B. Kalkulation der Maßnahme","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Reine Arbeitskosten                                        [€ / Baum]",{"$f":"IF(AND($C$64=\"\",OR($C$66=\"\",$C$70=\"\")),\"\",IF(AND($C$64>0,$C$37>0),$C$37*$C$64,IF($C$68=\"\",($C$66/60)*$C$70,($C$66/60)*$C$70*(1+$C$68/100))))","v":""},{"$nulls":4},{"$f":"IF(AND($H$64=\"\",OR($H$66=\"\",$H$70=\"\")),\"\",IF(AND($H$64>0,$H$37>0),($H$37-$C$37)*$J$64,IF($H$68=\"\",($H$66/60)*$H$70,($H$66/60)*$H$70*(1+$H$68/100))))","v":""},{"$nulls":5},{"$f":"IF(AND($N$64=\"\",OR($N$66=\"\",$N$70=\"\")),\"\",IF(AND($N$64>0,$N$37>0),($N$37-$H$37)*$P$64,IF($N$68=\"\",($N$66/60)*$N$70,($N$66/60)*$N$70*(1+$N$68/100))))","v":""}]
[]
[null,"Verwaltungskosten / Dokumentation                 [€ / Baum]",{"$f":"IF(OR($C$72=\"\",$C$91=\"\"),\"\",($C$91/100)*$C$72)","v":""},{"$nulls":4},{"$f":"IF(OR($J$72=\"\",$H$91=\"\"),\"\",($H$91/100)*$J$72)","v":""},{"$nulls":5},{"$f":"IF(OR($P$72=\"\",$N$91=\"\"),\"\",($N$91/100)*$P$72)","v":""}]
[]
[null,"Maschineneinsatz                                           [€ / Baum]",{"$f":"IF(OR($C$74=\"\",$C$76=\"\"),\"\",($C$74/60)*$C$76)","v":""},{"$nulls":4},{"$f":"IF(OR($H$74=\"\",$H$76=\"\"),\"\",($H$74/60)*$H$76)","v":""},{"$nulls":5},{"$f":"IF(OR($N$74=\"\",$N$76=\"\"),\"\",($N$74/60)*$N$76)","v":""}]
[]
[null,"Werkzeug                                                      [€ / Baum]",{"$f":"IF(OR($C$70=\"\",$C$78=\"\"),\"\",($C$78/60)*$C$70)","v":""},{"$nulls":4},{"$f":"IF(OR($H$70=\"\",$H$78=\"\"),\"\",($H$78/60)*$H$70)","v":""},{"$nulls":5},{"$f":"IF(OR($N$70=\"\",$N$78=\"\"),\"\",($N$78/60)*$N$70)","v":""}]
[]
[null,"Behandlungsmittel                                          [€ / Baum]",{"$f":"IF(OR($C$51=\"\",$C$80=\"\"),\"\",$C$51*$C$80)","v":""},{"$nulls":4},{"$f":"IF(OR($H$51=\"\",$H$80=\"\"),\"\",$H$51*$H$80)","v":""},{"$nulls":5},{"$f":"IF(OR($N$51=\"\",$N$80=\"\"),\"\",$N$51*$N$80)","v":""}]
[]
[null,"Maßnahme insgesamt (unverzinst)                  [€ / Baum]",{"$f":"SUM($C$91,$C$93,$C$95,$C$97,$C$99)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"SUM($H$91,$H$93,$H$95,$H$97,$H$99)","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},{"$f":"SUM($N$91,$N$93,$N$95,$N$97,$N$99)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Maßnahme insgesamt (unverzinst)                        [€ / ha]",{"$f":"IF(OR($C$41=\"\",$C$101=\"\"),\"\",$C$101*$C$41)","v":""},{"$nulls":4},{"$f":"IF(OR($J$41=\"\",$H$101=\"\"),\"\",$H$101*$J$41)","v":""},{"$nulls":5},{"$f":"IF(OR($P$41=\"\",$N$101=\"\"),\"\",$N$101*$P$41)","v":""}]
[]
[null,"Zinskosten bis Alter U                                     [€ / Baum]",{"$f":"IF(OR($C$84=\"\",$C$101=\"\"),\"\",($C$101)*($C$84-1))","v":""},{"$nulls":4},{"$f":"IF(OR($H$84=\"\",$H$101=\"\"),\"\",($H$101)*($H$84-1))","v":""},{"$nulls":5},{"$f":"IF(OR($N$84=\"\",$N$101=\"\"),\"\",($N$101)*($N$84-1))","v":""}]
[]
[null,"Maßnahme 1 insgesamt (aufgezinst bis Alter U) [€ / Baum]",{"$f":"SUM($C$101,$C$105)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"SUM($H$101,$H$105)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 2)",{"$nulls":3},{"$f":"SUM($N$101,$N$105)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 3)"]
[]
[null,"Maßnahme insgesamt (aufgezinst bis Alter U)         [€ / ha]",{"$f":"IF(OR($C$107=\"\",$C$41=\"\"),\"\",$C$107*$C$41)","v":""},{"$nulls":4},{"$f":"IF(OR($H$107=\"\",$J$41=\"\"),\"\",$H$107*$J$41)","v":""},null,"\"\"        \"\"",{"$nulls":3},{"$f":"IF(OR($N$107=\"\",$P$41=\"\"),\"\",$N$107*$P$41)","v":""},null,"\"\"          \"\""]
[null,"III C. Gesamtkalkulation","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[null,"Gesamtkosten je ha (aufgezinst bis Alter U)               [€ / ha]",{"$f":"SUM($C$109)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"SUM($C$109,$H$109)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"SUM($C$109,$H$109,$N$109)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe III)"]
[]
[null,"Erwarteter Anteil geästeter Bäume mit Wertholz         [%]",{"v":75,"d":"75.0"},null,"!"]
[]
[null,"Erwartete Anzahl geästeter Bäume / ha mit Wertholz  [St.]",{"$f":"ROUNDDOWN(IF(OR($C$41=\"\",$C$113=\"\",$C$113=0),0,($C$41/100)*$C$113),0)","v":0}]
[]
[null,"Umlegung der Kosten je ha auf die erwartete Anzahl geästeter"]
[null,"Bäume mit Wertholzanteil (aufgezinst bis Alter U)    [€ /Baum]",{"$f":"IF(OR($C$111=\"\",$C$115=\"\",$C$115=0),\"\",$C$111/$C$115)","v":""},{"$nulls":4},{"$f":"IF(OR($H$111=\"\",$C$115=\"\",$C$115=0),\"\",$H$111/$C$115)","v":""},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"IF(OR($N$111=\"\",$C$115=\"\",$C$115=0),\"\",$N$111/$C$115)","v":""},null,"(insgesamt bis Stufe III)"]
[null,{"$f":"\"Diesen Betrag muß jeder der erwarteten \" &C115&\" Erntebäume min. zusätzlich erbringen!\"","v":"Diesen Betrag muß jeder der erwarteten 0 Erntebäume min. zusätzlich erbringen!"}]
[]
[null,"IV. Zu erwartende Sortierung und erzielbare Erlöse",{"$f":"IF(AND($N$37>0,$P$41>0,$N$91<>\"\"),\"Stufe III\",IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")))","v":""},{"$nulls":4},{"$f":"IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\"))","v":""},null,{"$f":"IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")","v":""},{"$nulls":3},"Ohne","W   e   r   t   ä   s   t   u   n   g"]
[null,"fm / Baum",{"$f":"IF($C$143>0,$C$129+$C$139+$C$149,$C$129+$C$139)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF($C$143>0,$H$129+$H$139+$H$149,$H$129+$H$139)","v":{"$error":"#VALUE!"}},null,{"$f":"IF($C$143>0,$J$129+$J$139+$J$149,$J$129+$J$139)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF($C$143>0,$N$129+$N$139+$N$149,$N$129+$N$139)","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,(($N$122-$C$122)/$C$122)*100,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,\"% Vol.-Diff.\",\"\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"\"Güte-Kl. A Länge                                    \"&$C$121&\"  [m]\"","v":"Güte-Kl. A Länge                                      [m]"},{"$f":"IF(AND($N$37=\"\",$H$37=\"\",$C$37=\"\"),0,IF(OR(N64>0,AND($N$37>0,$N$70>0)),$N$37,IF(OR(H64>0,AND($H$37>0,$H$70>0)),$H$37,IF(OR(C64>0,AND($C$37>0,$C$70>0)),$C$37,0))))","v":{"v":0,"d":"0.0"}},"A",{"$f":"IF(AND($H$121=$C$121,$H$168<>$C$168),\"??\",\"\")","v":""},null,null,{"$f":"IF(AND($H$37=\"\",$C$37=\"\"),0,IF(OR($H$64>0,AND($H$37>0,$H$70>0)),$H$37,IF(OR($C$64>0,AND($C$37>0,$C$70>0)),$C$37,0)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(AND($H$37=\"\",$C$37=\"\"),0,IF(OR($C$64>0,AND($C$37>0,$C$70>0)),$C$37,IF($C$37>0,$C$37,0)))","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"v":0,"d":"0.0"},null,"Abkürzg.-Verz."]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($O$23=\"\",$O$23=0),\"\",$O$23+$C$21-($C$123*0.5)*$C$21)","v":""},{"$nulls":4},{"$f":"IF($C$125=\"\",\"\",IF($H$123/2<=$C$123,($O$23+$C$21)-($H$123/2)*$C$21,($O$23+$C$21)-(($C$123*$C$21)+(($H$123/2-$C$123)*$C$23))))","v":""},null,{"$f":"IF($C$125=\"\",\"\",IF($J$123/2<=$C$123,($O$23+$C$21)-($J$123/2)*$C$21,($O$23+$C$21)-(($C$123*$C$21)+(($J$123/2-$C$123)*$C$23))))","v":""},{"$nulls":3},{"$f":"IF($C$125=\"\",\"\",IF($N$123/2<=$C$123,($O$23+$C$21)-($N$123/2)*$C$21,($O$23+$C$21)-(($C$123*$C$21)+(($N$123/2-$C$123)*$C$23))))","v":""},null,"GAZ"]
[]
[null,"                 Geästetes Holz (Wertholz-Stück)     [€ / Efm o. R.]",null,null,"!",null,null,{"$f":"$C$127","v":{"v":0,"d":"0.00 €"}},null,{"$f":"$C$127","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"$C$127","v":{"v":0,"d":"0.00 €"}},null,"Gesamt-Arbeitszeit"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(OR($C$123=\"\",$C$125=\"\"),\"\",($C$125/100*$C$125/100)/4*3.14159*$C$123)","v":""},{"$nulls":4},{"$f":"IF(OR($H$123=\"\",$H$125=\"\"),\"\",($H$125/100*$H$125/100)/4*3.14159*$H$123)","v":""},null,{"$f":"IF(OR($J$123=\"\",$J$125=\"\"),\"\",($J$125/100*$J$125/100)/4*3.14159*$J$123)","v":""},{"$nulls":3},{"$f":"IF(OR($N$123=\"\",$N$125=\"\"),\"\",($N$125/100*$N$125/100)/4*3.14159*$N$123)","v":""}]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$127=\"\",$C$129=\"\"),\"\",$C$127*$C$129)","v":""},{"$nulls":4},{"$f":"IF(OR($H$127=\"\",$H$129=\"\"),\"\",$H$127*$H$129)","v":""},null,{"$f":"IF(OR($J$127=\"\",$J$129=\"\"),\"\",$J$127*$J$129)","v":""},{"$nulls":3},{"$f":"IF(OR($N$127=\"\",$N$129=\"\"),\"\",$N$127*$N$129)","v":""}]
[]
[null,{"$f":"\"Güte-Kl. B Länge (Restlänge vor C-Stück) \"&$C$121&\" [m]\"","v":"Güte-Kl. B Länge (Restlänge vor C-Stück)  [m]"},null,"B",{"$nulls":3},{"$f":"IF(AND($C$123=\"\",$C$133=\"\"),\"\",IF(AND($C$123>0,OR($C$133=\"\",$C$133=0),OR($H$123=\"\",$H$123=0)),$C$123,IF($H$123>0,$C$123+$C$133-$H$123,$C$123+$C$133)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(AND($C$123=\"\",$C$133=\"\"),\"\",IF(AND($C$123>0,OR($C$133=\"\",$C$133=0),OR($J$123=\"\",$J$123=0)),$C$123,IF($J$123>0,$C$123+$C$133-$J$123,$C$123+$C$133)))","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(AND($C$123=\"\",$C$133=\"\"),\"\",IF(AND($C$123>0,OR($C$133=\"\",$C$133=0),OR($N$123=\"\",$N$123=0)),$C$123,IF($N$123>0,$C$123+$C$133-$N$123,$C$123+$C$133)))","v":{"v":0,"d":"0.0"}},null,"Stufe I-III in Minuten"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($C$133=\"\",$C$133=0),$C$125-(($C$123*0.5*$C$21)+0.01*0.5*($C$23)),$C$125-(($C$123*0.5*$C$21)+$C$133*0.5*($C$23)))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF($C$135=\"\",\"\",IF(($H$123+$H$133/2)>$C$123,($O$23+$C$21)-($C$123*$C$21)-($H$123-$C$123+$H$133/2)*$C$23,($O$23+$C$21)-($H$123+$H$133/2)*$C$21))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($C$135=\"\",\"\",IF(($J$123+$J$133/2)>$C$123,($O$23+$C$21)-($C$123*$C$21)-($J$123-$C$123+$J$133/2)*$C$23,($O$23+$C$21)-($J$123+$J$133/2)*$C$21))","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF($C$135=\"\",\"\",IF(($N$123+$N$133/2)>$C$123,($O$23+$C$21)-($C$123*$C$21)-($N$123-$C$123+$N$133/2)*$C$23,($O$23+$C$21)-($N$123+$N$133/2)*$C$21))","v":{"$error":"#VALUE!"}}]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",null,null,"!",null,null,{"$f":"$C$137","v":{"v":0,"d":"0.00 €"}},null,{"$f":"$C$137","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"$C$137","v":{"v":0,"d":"0.00 €"}},null,"d1,3   (= BHD)"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(AND($C$133=\"\",$C$135=\"\"),\"\",IF(OR($C$133=\"\",$C$133=0),0.00001,($C$135/100*$C$135/100)/4*3.14159*$C$133))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$133=\"\",$H$135=\"\"),\"\",($H$135/100*$H$135/100)/4*3.14159*$H$133)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$133=\"\",$J$135=\"\"),\"\",($J$135/100*$J$135/100)/4*3.14159*$J$133)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(OR($N$133=\"\",$N$135=\"\"),\"\",($N$135/100*$N$135/100)/4*3.14159*$N$133)","v":{"$error":"#VALUE!"}},null,"in 1,3m Höhe"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$137=\"\",$C$139=\"\"),\"\",$C$137*$C$139)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$137=\"\",$H$139=\"\"),\"\",$H$137*$H$139)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$137=\"\",$J$139=\"\"),\"\",$J$137*$J$139)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(OR($N$137=\"\",$N$139=\"\"),\"\",$N$137*$N$139)","v":{"$error":"#VALUE!"}},null,"Rm "]
[]
[null,{"$f":"\"Güte-Kl. C Länge                                    \"&$C$121&\"  [m]\"","v":"Güte-Kl. C Länge                                      [m]"},null,"C",{"$nulls":3},{"$f":"$C$143","v":{"v":0,"d":"0.0"}},null,{"$f":"$C$143","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"$C$143","v":{"v":0,"d":"0.0"}},null,"Radius in der"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($C$143=\"\",$C$143=0),\"\",$C$135-(($C$133*0.5)*$C$23)-(($C$143*0.5)*($C$23+1)))","v":""},{"$nulls":4},{"$f":"$C$145","v":""},null,{"$f":"$C$145","v":""},{"$nulls":3},{"$f":"$C$145","v":""},null,"Mitte d. A-Stamm-"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"$nulls":5},{"$f":"$C$147","v":{"v":0,"d":"0.00 €"}},null,{"$f":"$C$147","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"$C$147","v":{"v":0,"d":"0.00 €"}},null,"(Werholz)-stückes"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(OR($C$143=\"\",$C$145=\"\"),\"\",($C$145/100*$C$145/100)/4*3.14159*$C$143)","v":""},{"$nulls":4},{"$f":"IF(OR($N$143=\"\",$N$145=\"\"),\"\",($N$145/100*$N$145/100)/4*3.14159*$N$143)","v":""},null,{"$f":"IF(OR($N$143=\"\",$N$145=\"\"),\"\",($N$145/100*$N$145/100)/4*3.14159*$N$143)","v":""},{"$nulls":3},{"$f":"IF(OR($N$143=\"\",$N$145=\"\"),\"\",($N$145/100*$N$145/100)/4*3.14159*$N$143)","v":""},null,"lfm=lfd.Meter;fm=m³"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$147=\"\",$C$149=\"\"),\"\",$C$147*$C$149)","v":""},{"$nulls":4},{"$f":"IF(OR($H$147=\"\",$H$149=\"\"),\"\",$H$147*$H$149)","v":""},null,{"$f":"IF(OR($J$147=\"\",$J$149=\"\"),\"\",$J$147*$J$149)","v":""},{"$nulls":3},{"$f":"IF(OR($N$147=\"\",$N$149=\"\"),\"\",$N$147*$N$149)","v":""},null,"ZinF =Aufzinsg.=>U"]
[]
[]
[]
[null,"V. Wirtschaftlichkeit der Maßnahmen: Wertästung bis ",{"$f":"IF(AND($N$37>0,$P$41>0,$N$91<>\"\"),\"Stufe III\",IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")))","v":""},{"$nulls":4},{"$f":"IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\"))","v":""},null,{"$f":"IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")","v":""},{"$nulls":3},"Ohne Ästung!",null,"Zusammenstellung"]
[]
[null,"Durchschnittserlös                                            [€ / fm]",{"$f":"IF(C143>0,$C$164/($C$129+$C$139+$C$149),$C$164/($C$129+$C$139))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(H143>0,$H$164/($H$129+$H$139+$H$149),$H$164/($H$129+$H$139))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(J143>0,$J$164/($J$129+$J$139+$J$149),$J$164/($J$129+$J$139))","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(N143>0,$N$164/($N$129+$N$139+$N$149),$N$164/($N$129+$N$139))","v":{"$error":"#VALUE!"}},"ZinsF/LS",{"$f":"$C$84","v":""},{"$f":"$J$82","v":2.5}]
[null,"Güte-Kl. A Erlös / Baum                                            [€]",{"$f":"IF($C$131=\"\",\"\",$C$131)","v":""},{"$nulls":4},{"$f":"IF($H$131=\"\",\"\",$H$131)","v":""},null,{"$f":"IF($J$131=\"\",\"\",$J$131)","v":""},{"$nulls":3},{"$f":"IF($N$131=\"\",\"\",$N$131)","v":""},{"$f":"$C$127","v":{"v":0,"d":"0 €"}},{"$f":"$C$123&\"/  \"&$H$123&\" /  \"&$J$123&\" /\"&$N$123&\"m\"","v":"0/  0 /  0 /0m"},{"$f":"$D$123","v":"A"}]
[]
[null,"             B Erlös / Baum                                            [€]",{"$f":"IF($C$141=\"\",\"\",$C$141)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF($H$141=\"\",\"\",$H$141)","v":{"$error":"#VALUE!"}},null,{"$f":"IF($J$141=\"\",\"\",$J$141)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF($N$141=\"\",\"\",$N$141)","v":{"$error":"#VALUE!"}},{"$f":"$C$137","v":{"v":0,"d":"0 €"}},{"$f":"$C$133&\"/ \"&$H$133&\" / \"&$J$133&\" /\"&$N$133&\"m\"","v":"/ 0 / 0 /0m"},{"$f":"$D$133","v":"B"}]
[]
[null,"             C Erlös / Baum                                            [€]",{"$f":"IF($C$151=\"\",\"\",$C$151)","v":""},{"$nulls":4},{"$f":"IF($H$151=\"\",\"\",$H$151)","v":""},null,{"$f":"IF($J$151=\"\",\"\",$J$151)","v":""},{"$nulls":3},{"$f":"IF($N$151=\"\",\"\",$N$151)","v":""},{"$f":"$C$147","v":{"v":0,"d":"0 €"}},{"$f":"$C$143&\" /  \"&$H$143&\"  /  \"&$J$143&\"  /\"&$N$143&\"m\"","v":" /  0  /  0  /0m"},{"$f":"$D$143","v":"C"}]
[]
[null,"Gesamterlös / Baum                                     [€ / Baum]",{"$f":"IF(AND($C$158=\"\",$C$160=\"\",$C$162=\"\"),\"\",SUM($C$158,$C$160,$C$162))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(AND($H$158=\"\",$H$160=\"\",$H$162=\"\"),\"\",SUM($H$158,$H$160,$H$162))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND($J$158=\"\",$J$160=\"\",$J$162=\"\"),\"\",SUM($J$158,$J$160,$J$162))","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(AND($N$158=\"\",$N$160=\"\",$N$162=\"\"),\"\",SUM($N$158,$N$160,$N$162))","v":{"$error":"#VALUE!"}},"Bäume",{"$f":"$P$41&\" / \"&$J$41&\" / \"&$C$41&\" / \"&\"0St.\"","v":" /  /  / 0St."},{"$f":"$C$115","v":0}]
[]
[null,"Ertragswert (Mehrerlös: Baum geästet zu ungeastet)    [€ / Baum]",{"$f":"IF(OR($C$164=\"\",$N$164=\"\"),\"\",$C$164-$N$164)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$164=\"\",$N$164=\"\"),\"\",$H$164-$N$164)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($N$164=\"\",$J$164=\"\"),\"\",$J$164-$N$164)","v":{"$error":"#VALUE!"}},null,null,"Arbeitskraft / h",null,{"$f":"$C$66","v":{"v":0,"d":"0.00 €"}},{"$f":"$N$70&\"/  \"&$H$70&\" /  \"&$C$70& \" /0\"","v":"/   /   /0"},"GAZ"]
[]
[null,"abzgl. Ästungsaufwand (aufgezinst bis Alter U)      [€ / Baum]",{"$f":"IF(OR($N$111=\"\",$C$115=\"\",$C$115=0),\"\",$N$111/$C$115)","v":""},{"$nulls":4},{"$f":"IF(OR($H$111=\"\",$C$115=\"\",$C$115=0),\"\",$H$111/$C$115)","v":""},null,{"$f":"IF(OR($C$111=\"\",$C$115=\"\",$C$115=0),\"\",$C$111/$C$115)","v":""},null,null,"Rm /astfr.Schicht",null,{"$f":"$C$125/2","v":{"$error":"#VALUE!"}},{"$f":"IF(OR($C$19=\"\",$C$19=0,$O$23=\"\",$O$23=0),\"\",$O$168-(($C$19+$C$21)-($C$123/2)*$C$21)/2)","v":""},"cm"]
[]
[null,"= Mehrertrag je geästeter Erntebaum (netto)  [€ / Baum]",{"$f":"IF(OR($C$166=\"\",$C$168=\"\"),\"\",$C$166-$C$168)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$166=\"\",$H$168=\"\"),\"\",$H$166-$H$168)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$166=\"\",$J$168=\"\"),\"\",$J$166-$J$168)","v":{"$error":"#VALUE!"}},null,null,"Vol.: astig/astfr.",null,{"$f":"IF(OR($C$123=\"\",$O$168=\"\",$P$168=\"\"),\"\",(($O$168-$P$168)/100*($O$168-$P$168)/100)*3.14159*$C$123)","v":{"$error":"#VALUE!"}},{"$f":"$C$129-$O$170","v":{"$error":"#VALUE!"}},"fm"]
[]
[null,"Rentabilität aller Maßnahme(n) bis Stufe ...     [Faktor]",{"$f":"IF(OR($C$168=\"\",$C$170=\"\"),\"\",$C$170/$C$168)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$168=\"\",$H$170=\"\"),\"\",$H$170/$H$168)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$168=\"\",$J$170=\"\"),\"\",$J$170/$J$168)","v":{"$error":"#VALUE!"}},null,null," Vol.-%: \" \" / \" \"",null,{"$f":"$O$170/$C$129*100","v":{"$error":"#VALUE!"}},{"$f":"$P$170/$C$129*100","v":{"$error":"#VALUE!"}},"V%"]
[]
[null,"Grenzertrag der Ästungs-Stufe ...                   [€ / Baum]",{"$f":"IF(OR($C$170=\"\",$H$170=\"\"),\"\",$C$170-$H$170)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$170=\"\",$J$170=\"\"),\"\",$H$170-$J$170)","v":{"$error":"#VALUE!"}},null,{"$f":"$J$170","v":{"$error":"#VALUE!"}},null,null,"Kosten: lfm / fm",null,{"$f":"IF(OR($C$123=\"\",$C$168=\"\"),\"\",$C$168/$C$123)","v":""},{"$f":"IF(AND($C$129>0,$C$168>0),$C$168/$C$129,\"\")","v":{"$error":"#VALUE!"}},"€"]
[]
[null,"Rentabilität der Einzelmaßnahme: Stufe...       [Faktor]",{"$f":"IF(OR($C$168=\"\",$C$170=\"\"),\"\",$C$174/($C$168-$H$168))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$168=\"\",$H$170=\"\"),\"\",$H$174/($H$168-$J$168))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$168=\"\",$J$170=\"\"),\"\",$J$174/$J$168)","v":{"$error":"#VALUE!"}},null,null,"d1,3/astfr.Schicht",null,{"$f":"$O$23","v":{"v":0,"d":"0.0"}},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",($O$23-$C$19)/2))","v":""},"cm"]
[]
[]
[]
[null,"IV-1. Zu erwartende Sortierung und erzielbare Erlöse"]
[null,"IV-1 A1. Variante 3 mit Wertästung (nur Maßnahme 1)"]
[null,"GKl. A Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. A  Durchmesser o. R. [cm]",{"v":76,"d":"76.0"}]
[]
[null,"GKl. A Preis [€/Efm o. R.]",{"v":200,"d":"200.00 €"}]
[]
[null,"GKl. A Masse [Efm o. R.]",{"$f":"IF(OR($C$182=\"\",$C$184=\"\"),\"\",($C$184/100*$C$184/100)/4*3.14159*$C$182)","v":{"v":2.26822798,"d":"2.27"}}]
[]
[null,"GKl. A Erlös [€]",{"$f":"IF(OR($C$186=\"\",$C$188=\"\"),\"\",$C$186*$C$188)","v":{"v":453.64559599999995,"d":"453.65 €"}}]
[]
[null,"GKl. B Länge [m]",{"v":22,"d":"22.0"}]
[]
[null,"GKl. B  Durchmesser o. R. [cm]",{"v":60,"d":"60.0"}]
[]
[null,"GKl. B Preis [ €/ Efm o. R.]",{"v":96,"d":"96.00 €"}]
[]
[null,"GKl. B Masse [Efm o. R.]",{"$f":"IF(OR($C$192=\"\",$C$194=\"\"),\"\",($C$194/100*$C$194/100)/4*3.14159*$C$192)","v":{"v":6.220348199999999,"d":"6.22"}}]
[]
[null,"GKl. B Erlös [€]",{"$f":"IF(OR($C$196=\"\",$C$198=\"\"),\"\",$C$196*$C$198)","v":{"v":597.1534271999999,"d":"597.15 €"}}]
[]
[null,"GKl. C Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. C  Durchmesser o. R. [cm]",{"v":39,"d":"39.0"}]
[]
[null,"GKl. C Preis [€/Efm o. R.]",{"v":81.6,"d":"81.60 €"}]
[]
[null,"GKl. C Masse [Efm o. R.]",{"$f":"IF(OR($C$202=\"\",$C$204=\"\"),\"\",($C$204/100*$C$204/100)/4*3.14159*$C$202)","v":{"v":0.59729479875,"d":"0.60"}}]
[]
[null,"GKl. C Erlös [€]",{"$f":"IF(OR($C$206=\"\",$C$208=\"\"),\"\",$C$206*$C$208)","v":{"v":48.739255578,"d":"48.74 €"}}]
[]
[null,"Programmerstellung:"]
[]
[null,"K.-H. Schmitz; LB WuH NRW; LuVFA Arnsberger Wald -SPA Waldbau-"]
[]
[null,"Bemerkung"]
{"$rows_empty":21}
[null,"Platz für Anfügungen des Anwenders:"]

{"sheet":"IKW_I_Ansicht","index":1,"n_rows":238,"n_cols":17,"rows_kept":238,"merged":[[0,6,0,9],[0,10,0,12],[2,6,2,13],[4,6,4,12],[20,13,20,14],[27,3,27,4],[30,1,30,2],[30,7,30,9],[30,13,30,15],[46,1,46,2],[46,7,46,9],[46,13,46,15],[48,1,48,2],[48,7,48,9],[48,13,48,15],[52,1,52,2],[52,7,52,9],[52,13,52,15],[56,1,56,2],[56,7,56,9],[56,13,56,15],[216,1,234,17]]}
[null,"W     e     r     t     ä     s     t     u     n     g","Lokalität >",null,null,"Besitz",{"$f":"IF(IKW_I_Eingabe!G1=\"\",\"\",IKW_I_Eingabe!G1)","v":""},{"$f":"IF(IKW_I_Eingabe!H1=\"\",\"\",IKW_I_Eingabe!H1)","v":""},{"$f":"IF(IKW_I_Eingabe!I1=\"\",\"\",IKW_I_Eingabe!I1)","v":""},{"$f":"IF(IKW_I_Eingabe!J1=\"\",\"\",IKW_I_Eingabe!J1)","v":""},"RFA",null,null,{"$f":"IF(IKW_I_Eingabe!N1=\"\",\"\",IKW_I_Eingabe!N1)","v":""},"Abt.",{"$f":"IF(IKW_I_Eingabe!P1=\"\",\"\",IKW_I_Eingabe!P1)","v":""}]
[]
[null,"I n v e s t i t i o n s k a l k u l a t i o n","vom","Adresse",null,null,{"$f":"IF(IKW_I_Eingabe!G3=\"\",\"\",IKW_I_Eingabe!G3)","v":""},{"$f":"IF(IKW_I_Eingabe!H3=\"\",\"\",IKW_I_Eingabe!H3)","v":""},{"$f":"IF(IKW_I_Eingabe!I3=\"\",\"\",IKW_I_Eingabe!I3)","v":""},{"$f":"IF(IKW_I_Eingabe!J3=\"\",\"\",IKW_I_Eingabe!J3)","v":""},{"$f":"IF(IKW_I_Eingabe!K3=\"\",\"\",IKW_I_Eingabe!K3)","v":""},{"$f":"IF(IKW_I_Eingabe!L3=\"\",\"\",IKW_I_Eingabe!L3)","v":""},{"$f":"IF(IKW_I_Eingabe!M3=\"\",\"\",IKW_I_Eingabe!M3)","v":""},{"$f":"IF(IKW_I_Eingabe!N3=\"\",\"\",IKW_I_Eingabe!N3)","v":""},"GK-RW",{"$f":"IF(IKW_I_Eingabe!P3=\"\",\"\",IKW_I_Eingabe!P3)","v":""}]
[]
[null,"Erst.:FAR Schmitz, LB Wald u. Holz NRW; LVFA Arnsberger Wald",{"$f":"IF(IKW_I_Eingabe!C5=\"\",\"\",IKW_I_Eingabe!C5)","v":"2014-01-07"},"Resultat",null,null,{"$f":"IF(IKW_I_Eingabe!G5=\"\",\"\",IKW_I_Eingabe!G5)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!H5=\"\",\"\",IKW_I_Eingabe!H5)","v":""},{"$f":"IF(IKW_I_Eingabe!I5=\"\",\"\",IKW_I_Eingabe!I5)","v":""},{"$f":"IF(IKW_I_Eingabe!J5=\"\",\"\",IKW_I_Eingabe!J5)","v":""},{"$f":"IF(IKW_I_Eingabe!K5=\"\",\"\",IKW_I_Eingabe!K5)","v":""},{"$f":"IF(IKW_I_Eingabe!L5=\"\",\"\",IKW_I_Eingabe!L5)","v":""},{"$f":"IF(IKW_I_Eingabe!M5=\"\",\"\",IKW_I_Eingabe!M5)","v":""},{"$f":"IF(IKW_I_Eingabe!N5=\"\",\"\",IKW_I_Eingabe!N5)","v":{"$error":"#VALUE!"}},"GK-HW",{"$f":"IF(IKW_I_Eingabe!P5=\"\",\"\",IKW_I_Eingabe!P5)","v":""}]
[]
[null,"I. Bestand"]
[]
[null,"I A. Ist-Daten",{"$nulls":4},"I B. Soll-Daten",{"$nulls":6},"Ergänzungen möglich ="]
[]
[null,"Bestand                                                         [Baumart]",{"$f":"IF(IKW_I_Eingabe!C11=\"\",\"\",IKW_I_Eingabe!C11)","v":""},{"$nulls":3},"erwarteter BHD (d1,3) o. R. im Alter U                            [cm]",{"$nulls":8},{"$f":"IF(IKW_I_Eingabe!P11=\"\",\"\",IKW_I_Eingabe!P11)","v":""},"!"]
[]
[null,"Ertragsklasse                                                        [EKl.]",{"$f":"IF(IKW_I_Eingabe!C13=\"\",\"\",IKW_I_Eingabe!C13)","v":""},{"$nulls":3},"jährlicher BHD-Zuwachs bis Alter U                                [cm]",{"$nulls":8},{"$f":"IF(IKW_I_Eingabe!P13=\"\",\"\",IKW_I_Eingabe!P13)","v":""},"!"]
[]
[null,"Bestandesbegründung                                           [Jahr]",{"$f":"IF(IKW_I_Eingabe!C15=\"\",\"\",IKW_I_Eingabe!C15)","v":""},null,"!",null,"verbleibender Zeitraum bis Alter U                               [Jahre]",{"$nulls":8},{"$f":"IF(IKW_I_Eingabe!P15=\"\",\"\",IKW_I_Eingabe!P15)","v":""}]
[]
[null,"Aktuelle Bestandesaufnahme                                 [Jahr]",{"$f":"IF(IKW_I_Eingabe!C17=\"\",\"\",IKW_I_Eingabe!C17)","v":""},null,"!",null,"Resultierende Umtriebszeit                                        [Jahre]",{"$nulls":8},{"$f":"IF(IKW_I_Eingabe!P17=\"\",\"\",IKW_I_Eingabe!P17)","v":""}]
[]
[null,"aktueller BHD der zu ästenden Bäume o. R.             [cm]",{"$f":"IF(IKW_I_Eingabe!C19=\"\",\"\",IKW_I_Eingabe!C19)","v":""},null,"!",null,"entspricht Kalenderjahr im Alter U                                [Jahr]",{"$nulls":8},{"$f":"IF(IKW_I_Eingabe!P19=\"\",\"\",IKW_I_Eingabe!P19)","v":""}]
[]
[null,"Abholzigkeit Güteklasse A (Durchmesser-Abnahme)[cm / lfdm]",{"$f":"IF(IKW_I_Eingabe!C21=\"\",\"\",IKW_I_Eingabe!C21)","v":""},null,"!",null,"Ggf. abweichende Umtriebszeit         [U]",{"$nulls":6},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",\"\"))","v":""},null,{"$f":"IF(IKW_I_Eingabe!P21=\"\",\"\",IKW_I_Eingabe!P21)","v":""}]
[]
[null,"Abholzigkeit Güteklasse B (GKl. C =  AbhzkB+1cm)  [cm / lfdm]",{"$f":"IF(IKW_I_Eingabe!C23=\"\",\"\",IKW_I_Eingabe!C23)","v":""},null,"!",null,"= astfreie Schicht [cm]  /  BHD [cm]   /  Jahr",{"$nulls":6},{"$f":"IF(IKW_I_Eingabe!N23=\"\",\"\",IKW_I_Eingabe!N23)","v":{"v":0,"d":"0.00"}},{"$f":"IF(IKW_I_Eingabe!O23=\"\",\"\",IKW_I_Eingabe!O23)","v":{"v":0,"d":"0.0"}},{"$f":"IF(IKW_I_Eingabe!P23=\"\",\"\",IKW_I_Eingabe!P23)","v":""}]
[]
[]
[]
[]
[null,"II. Maßnahme","Stufe I",{"$f":"IF(IKW_I_Eingabe!D28=\"\",\"\",IKW_I_Eingabe!D28)","v":""},{"$f":"IF(IKW_I_Eingabe!E28=\"\",\"\",IKW_I_Eingabe!E28)","v":{"v":0,"d":"0.0"}},null,null,"Stufe II",{"$f":"IF(IKW_I_Eingabe!I28=\"\",\"\",IKW_I_Eingabe!I28)","v":""},{"$f":"IF($I$28<>\"\",\"cm\",\"\")","v":""},{"$nulls":3},"Stufe III",{"$f":"IF(IKW_I_Eingabe!O28=\"\",\"\",IKW_I_Eingabe!O28)","v":""},{"$f":"IF(IKW_I_Eingabe!P28=\"\",\"\",IKW_I_Eingabe!P28)","v":""}]
[]
[]
[]
[]
[null,"Maßnahme-Ausführung                                         [Jahr]",{"$f":"IF(IKW_I_Eingabe!C33=\"\",\"\",IKW_I_Eingabe!C33)","v":""},null,"!",null,null,{"$f":"IF(IKW_I_Eingabe!H33=\"\",\"\",IKW_I_Eingabe!H33)","v":""},"(!)",{"$f":"IF(IKW_I_Eingabe!J33=\"\",\"\",IKW_I_Eingabe!J33)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N33=\"\",\"\",IKW_I_Eingabe!N33)","v":""},"(!)",{"$f":"IF(IKW_I_Eingabe!P33=\"\",\"\",IKW_I_Eingabe!P33)","v":""}]
[]
[null,"Ästungshöhe von ...                                                 [m]",{"$f":"IF(IKW_I_Eingabe!C35=\"\",\"\",IKW_I_Eingabe!C35)","v":{"v":0,"d":"0.0"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H35=\"\",\"\",IKW_I_Eingabe!H35)","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N35=\"\",\"\",IKW_I_Eingabe!N35)","v":{"v":0,"d":"0.0"}}]
[]
[null,"Ästungshöhe bis ...                                                  [m]",{"$f":"IF(IKW_I_Eingabe!C37=\"\",\"\",IKW_I_Eingabe!C37)","v":""},null,"!",null,null,{"$f":"IF(IKW_I_Eingabe!H37=\"\",\"\",IKW_I_Eingabe!H37)","v":""},"!",{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"<=W e r t ?\",\"\")","v":"<=W e r t ?"},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N37=\"\",\"\",IKW_I_Eingabe!N37)","v":""},"!",{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"<=W e r t ?\",\"\")","v":"<=W e r t ?"}]
[]
[null,"Baumabstand: (Optimale Verteilung; 3-Eckverband)                [m]",{"$f":"IF(IKW_I_Eingabe!C39=\"\",\"\",IKW_I_Eingabe!C39)","v":""},{"$nulls":3},"[n]",{"$f":"IF(IKW_I_Eingabe!H39=\"\",\"\",IKW_I_Eingabe!H39)","v":{"$error":"#DIV/0!"}},"(errechn. Anzahl /ha)",{"$nulls":3},"[n]",{"$f":"IF(IKW_I_Eingabe!N39=\"\",\"\",IKW_I_Eingabe!N39)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Anzahl zu ästender Bäume je ha                     [Stück / ha]",{"$f":"IF(IKW_I_Eingabe!C41=\"\",\"\",IKW_I_Eingabe!C41)","v":""},null,"!",null,null,{"$f":"IF(IKW_I_Eingabe!H41=\"\",\"\",IKW_I_Eingabe!H41)","v":""},"(!)",{"$f":"IF(IKW_I_Eingabe!J41=\"\",\"\",IKW_I_Eingabe!J41)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N41=\"\",\"\",IKW_I_Eingabe!N41)","v":""},"(!)",{"$f":"IF(IKW_I_Eingabe!P41=\"\",\"\",IKW_I_Eingabe!P41)","v":""}]
[]
[null,"Maßnahmefläche                                                    [ha]"]
[]
[null,"Beschreibung:[Maschineneinsatz  /  Werkzeug  /  Verfahren] "]
[]
[]
[]
[]
[]
[null,"Ggf. Behandlungsmittel [Produktbezeichng] / [Menge/Baum]",{"$f":"IF(IKW_I_Eingabe!C51=\"\",\"\",IKW_I_Eingabe!C51)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H51=\"\",\"\",IKW_I_Eingabe!H51)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N51=\"\",\"\",IKW_I_Eingabe!N51)","v":""}]
[]
[]
[]
[null,"Dokumentation der Realisierung: [Jahr]/[Bemerkung]"]
[]
[]
[]
[]
[]
[null,"III. Kosten"]
[null,"III A. Basisdaten","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Alternative 1: Entgelt / lfdm (aktuellerWert/Folgejahre) [€ / lfdm]",{"$f":"IF(IKW_I_Eingabe!C64=\"\",\"\",IKW_I_Eingabe!C64)","v":""},null,"[!]",null,null,{"$f":"IF(IKW_I_Eingabe!H64=\"\",\"\",IKW_I_Eingabe!H64)","v":""},"[!]",{"$f":"IF(IKW_I_Eingabe!J64=\"\",\"\",IKW_I_Eingabe!J64)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N64=\"\",\"\",IKW_I_Eingabe!N64)","v":""},"[!]",{"$f":"IF(IKW_I_Eingabe!P64=\"\",\"\",IKW_I_Eingabe!P64)","v":""}]
[]
[null,"\"\" 2: Stundenlohn (Folgejahre: Lohn x Steigerungsfaktor [LSF]) [€/h]",{"$f":"IF(IKW_I_Eingabe!C66=\"\",\"\",IKW_I_Eingabe!C66)","v":""},null,"!",null,null,{"$f":"IF(IKW_I_Eingabe!H66=\"\",\"\",IKW_I_Eingabe!H66)","v":""},"in Jahren",{"$f":"IF(IKW_I_Eingabe!J66=\"\",\"\",IKW_I_Eingabe!J66)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N66=\"\",\"\",IKW_I_Eingabe!N66)","v":""},"in Jahren",{"$f":"IF(IKW_I_Eingabe!P66=\"\",\"\",IKW_I_Eingabe!P66)","v":""}]
[]
[null,"Erschwerniszuschlag   (ggf. Baumbesteigung)                            [%]",{"$f":"IF(IKW_I_Eingabe!C68=\"\",\"\",IKW_I_Eingabe!C68)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H68=\"\",\"\",IKW_I_Eingabe!H68)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N68=\"\",\"\",IKW_I_Eingabe!N68)","v":""}]
[]
[null,"Zeitvorgabe Arbeitskraft (GAZ)                       [min. / Baum]",{"$f":"IF(IKW_I_Eingabe!C70=\"\",\"\",IKW_I_Eingabe!C70)","v":""},{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":"H?"},"!",null,null,{"$f":"IF(IKW_I_Eingabe!H70=\"\",\"\",IKW_I_Eingabe!H70)","v":""},"(!)",{"$f":"IF(IKW_I_Eingabe!J70=\"\",\"\",IKW_I_Eingabe!J70)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N70=\"\",\"\",IKW_I_Eingabe!N70)","v":""},"(!)",{"$f":"IF(IKW_I_Eingabe!P70=\"\",\"\",IKW_I_Eingabe!P70)","v":""}]
[]
[null,"Verwaltungskostenzuschlag / Dokumentationskosten   [%]",{"$f":"IF(IKW_I_Eingabe!C72=\"\",\"\",IKW_I_Eingabe!C72)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H72=\"\",\"\",IKW_I_Eingabe!H72)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J72=\"\",\"\",IKW_I_Eingabe!J72)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N72=\"\",\"\",IKW_I_Eingabe!N72)","v":""},null,{"$f":"IF(IKW_I_Eingabe!P72=\"\",\"\",IKW_I_Eingabe!P72)","v":""}]
[]
[null,"Maschineneinsatz                                             [€ / MAS]",{"$f":"IF(IKW_I_Eingabe!C74=\"\",\"\",IKW_I_Eingabe!C74)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H74=\"\",\"\",IKW_I_Eingabe!H74)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N74=\"\",\"\",IKW_I_Eingabe!N74)","v":""}]
[]
[null,"Zeitvorgabe Maschineneinsatz (MAS)           [min. / Baum]",{"$f":"IF(IKW_I_Eingabe!C76=\"\",\"\",IKW_I_Eingabe!C76)","v":""},{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":"H?"},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!H76=\"\",\"\",IKW_I_Eingabe!H76)","v":""},null,{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"Ästg.-Höhe?\",\"\")","v":"Ästg.-Höhe?"},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N76=\"\",\"\",IKW_I_Eingabe!N76)","v":""},null,{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"Ästg.-Höhe?\",\"\")","v":"Ästg.-Höhe?"}]
[]
[null,"Werkzeug (Entschädigung / Abnutzung)                         [€ / h]",{"$f":"IF(IKW_I_Eingabe!C78=\"\",\"\",IKW_I_Eingabe!C78)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H78=\"\",\"\",IKW_I_Eingabe!H78)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N78=\"\",\"\",IKW_I_Eingabe!N78)","v":""}]
[]
[null,"Behandlungsmittel                                         [€ / Einheit]",{"$f":"IF(IKW_I_Eingabe!C80=\"\",\"\",IKW_I_Eingabe!C80)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H80=\"\",\"\",IKW_I_Eingabe!H80)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N80=\"\",\"\",IKW_I_Eingabe!N80)","v":""}]
[]
[null,"Zinssatz für Aufzinsung der Investitionskosten (p)      [%]",{"$f":"IF(IKW_I_Eingabe!C82=\"\",\"\",IKW_I_Eingabe!C82)","v":{"v":3,"d":"3.00"}},null,"!",null,null,"Lohnsteigerung [%]",null,{"$f":"IF(IKW_I_Eingabe!J82=\"\",\"\",IKW_I_Eingabe!J82)","v":{"v":2.5,"d":"2.50"}},"!",null,null,"Lohnsteigerung (p) [% / a]",null,{"$f":"IF(IKW_I_Eingabe!P82=\"\",\"\",IKW_I_Eingabe!P82)","v":{"v":2.5,"d":"2.50"}}]
[]
[null,"Aufzinsungsfaktor (Askontierung; p = % Zinsen)           [(1+p)n]",{"$f":"IF(IKW_I_Eingabe!C84=\"\",\"\",IKW_I_Eingabe!C84)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H84=\"\",\"\",IKW_I_Eingabe!H84)","v":""},"[LSF]",{"$f":"IF(IKW_I_Eingabe!J84=\"\",\"\",IKW_I_Eingabe!J84)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N84=\"\",\"\",IKW_I_Eingabe!N84)","v":""},"[LSF]",{"$f":"IF(IKW_I_Eingabe!P84=\"\",\"\",IKW_I_Eingabe!P84)","v":""}]
[]
[null,"Aufzinsungs-Zeitraum bis Alter U  (n)                   [Jahre]",{"$f":"IF(IKW_I_Eingabe!C86=\"\",\"\",IKW_I_Eingabe!C86)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H86=\"\",\"\",IKW_I_Eingabe!H86)","v":""},"zu  [%]",{"$f":"IF(IKW_I_Eingabe!J86=\"\",\"\",IKW_I_Eingabe!J86)","v":{"v":3,"d":"3.00"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N86=\"\",\"\",IKW_I_Eingabe!N86)","v":""},"zu  [%]",{"$f":"IF(IKW_I_Eingabe!P86=\"\",\"\",IKW_I_Eingabe!P86)","v":{"v":3,"d":"3.00"}}]
[]
[]
[null,"III B. Kalkulation der Maßnahme","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Reine Arbeitskosten                                        [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C91=\"\",\"\",IKW_I_Eingabe!C91)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H91=\"\",\"\",IKW_I_Eingabe!H91)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N91=\"\",\"\",IKW_I_Eingabe!N91)","v":""}]
[]
[null,"Verwaltungskosten / Dokumentation                 [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C93=\"\",\"\",IKW_I_Eingabe!C93)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H93=\"\",\"\",IKW_I_Eingabe!H93)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N93=\"\",\"\",IKW_I_Eingabe!N93)","v":""}]
[]
[null,"Maschineneinsatz                                           [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C95=\"\",\"\",IKW_I_Eingabe!C95)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H95=\"\",\"\",IKW_I_Eingabe!H95)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N95=\"\",\"\",IKW_I_Eingabe!N95)","v":""}]
[]
[null,"Werkzeug                                                      [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C97=\"\",\"\",IKW_I_Eingabe!C97)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H97=\"\",\"\",IKW_I_Eingabe!H97)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N97=\"\",\"\",IKW_I_Eingabe!N97)","v":""}]
[]
[null,"Behandlungsmittel                                          [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C99=\"\",\"\",IKW_I_Eingabe!C99)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H99=\"\",\"\",IKW_I_Eingabe!H99)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N99=\"\",\"\",IKW_I_Eingabe!N99)","v":""}]
[]
[null,"Maßnahme insgesamt (unverzinst)                  [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C101=\"\",\"\",IKW_I_Eingabe!C101)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H101=\"\",\"\",IKW_I_Eingabe!H101)","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N101=\"\",\"\",IKW_I_Eingabe!N101)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Maßnahme insgesamt (unverzinst)                        [€ / ha]",{"$f":"IF(IKW_I_Eingabe!C103=\"\",\"\",IKW_I_Eingabe!C103)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H103=\"\",\"\",IKW_I_Eingabe!H103)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N103=\"\",\"\",IKW_I_Eingabe!N103)","v":""}]
[]
[null,"Zinskosten bis Alter U                                     [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C105=\"\",\"\",IKW_I_Eingabe!C105)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H105=\"\",\"\",IKW_I_Eingabe!H105)","v":""},{"$nulls":5},{"$f":"IF(IKW_I_Eingabe!N105=\"\",\"\",IKW_I_Eingabe!N105)","v":""}]
[]
[null,"Maßnahme 1 insgesamt (aufgezinst bis Alter U) [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C107=\"\",\"\",IKW_I_Eingabe!C107)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H107=\"\",\"\",IKW_I_Eingabe!H107)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 2)",{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N107=\"\",\"\",IKW_I_Eingabe!N107)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 3)"]
[]
[null,"Maßnahme insgesamt (aufgezinst bis Alter U)         [€ / ha]",{"$f":"IF(IKW_I_Eingabe!C109=\"\",\"\",IKW_I_Eingabe!C109)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H109=\"\",\"\",IKW_I_Eingabe!H109)","v":""},null,"\"\"        \"\"",{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N109=\"\",\"\",IKW_I_Eingabe!N109)","v":""},null,"\"\"          \"\""]
[null,"III C. Gesamtkalkulation","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[null,"Gesamtkosten je ha (aufgezinst bis Alter U)               [€ / ha]",{"$f":"IF(IKW_I_Eingabe!C111=\"\",\"\",IKW_I_Eingabe!C111)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H111=\"\",\"\",IKW_I_Eingabe!H111)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N111=\"\",\"\",IKW_I_Eingabe!N111)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe III)"]
[]
[null,"Erwarteter Anteil geästeter Bäume mit Wertholz         [%]",{"$f":"IF(IKW_I_Eingabe!C113=\"\",\"\",IKW_I_Eingabe!C113)","v":{"v":75,"d":"75.0"}},null,"!"]
[]
[null,"Erwartete Anzahl geästeter Bäume / ha mit Wertholz  [St.]",{"$f":"IF(IKW_I_Eingabe!C115=\"\",\"\",IKW_I_Eingabe!C115)","v":0}]
[]
[null,"Umlegung der Kosten je ha auf die erwartete Anzahl geästeter"]
[null,"Bäume mit Wertholzanteil (aufgezinst bis Alter U)    [€ /Baum]",{"$f":"IF(IKW_I_Eingabe!C118=\"\",\"\",IKW_I_Eingabe!C118)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H118=\"\",\"\",IKW_I_Eingabe!H118)","v":""},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N118=\"\",\"\",IKW_I_Eingabe!N118)","v":""},null,"(insgesamt bis Stufe III)"]
[null,{"$f":"\"Diesen Betrag muß jeder der erwarteten \" &C115&\" Erntebäume min. zusätzlich erbringen!\"","v":"Diesen Betrag muß jeder der erwarteten 0 Erntebäume min. zusätzlich erbringen!"}]
[]
[null,"IV. Zu erwartende Sortierung und erzielbare Erlöse",{"$f":"IF(IKW_I_Eingabe!C121=\"\",\"\",IKW_I_Eingabe!C121)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H121=\"\",\"\",IKW_I_Eingabe!H121)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J121=\"\",\"\",IKW_I_Eingabe!J121)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N121=\"\",\"\",IKW_I_Eingabe!N121)","v":"Ohne"},"W   e   r   t   ä   s   t   u   n   g"]
[null,{"$f":"IF(IKW_I_Eingabe!B122=\"\",\"\",IKW_I_Eingabe!B122)","v":"fm / Baum"},{"$f":"IF(IKW_I_Eingabe!C122=\"\",\"\",IKW_I_Eingabe!C122)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H122=\"\",\"\",IKW_I_Eingabe!H122)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J122=\"\",\"\",IKW_I_Eingabe!J122)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N122=\"\",\"\",IKW_I_Eingabe!N122)","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,(($N$122-$C$122)/$C$122)*100,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,\"% Vol.-Diff.\",\"\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(IKW_I_Eingabe!B123=\"\",\"\",IKW_I_Eingabe!B123)","v":"Güte-Kl. A Länge                                      [m]"},{"$f":"IF(IKW_I_Eingabe!C123=\"\",\"\",IKW_I_Eingabe!C123)","v":{"v":0,"d":"0.0"}},"A",{"$f":"IF(AND($H$121=$C$121,$H$168<>$C$168),\"??\",\"\")","v":""},null,null,{"$f":"IF(IKW_I_Eingabe!H123=\"\",\"\",IKW_I_Eingabe!H123)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(IKW_I_Eingabe!J123=\"\",\"\",IKW_I_Eingabe!J123)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N123=\"\",\"\",IKW_I_Eingabe!N123)","v":{"v":0,"d":"0.0"}},null,"Abkürzg.-Verz."]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(IKW_I_Eingabe!C125=\"\",\"\",IKW_I_Eingabe!C125)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H125=\"\",\"\",IKW_I_Eingabe!H125)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J125=\"\",\"\",IKW_I_Eingabe!J125)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N125=\"\",\"\",IKW_I_Eingabe!N125)","v":""},null,"GAZ"]
[]
[null,"                 Geästetes Holz (Wertholz-Stück)     [€ / Efm o. R.]",{"$f":"IF(IKW_I_Eingabe!C127=\"\",\"\",IKW_I_Eingabe!C127)","v":""},null,"!",null,null,{"$f":"IF(IKW_I_Eingabe!H127=\"\",\"\",IKW_I_Eingabe!H127)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(IKW_I_Eingabe!J127=\"\",\"\",IKW_I_Eingabe!J127)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N127=\"\",\"\",IKW_I_Eingabe!N127)","v":{"v":0,"d":"0.00 €"}},null,"Gesamt-Ar-"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(IKW_I_Eingabe!C129=\"\",\"\",IKW_I_Eingabe!C129)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H129=\"\",\"\",IKW_I_Eingabe!H129)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J129=\"\",\"\",IKW_I_Eingabe!J129)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N129=\"\",\"\",IKW_I_Eingabe!N129)","v":""},null,"beits-Zeit für"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(IKW_I_Eingabe!C131=\"\",\"\",IKW_I_Eingabe!C131)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H131=\"\",\"\",IKW_I_Eingabe!H131)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J131=\"\",\"\",IKW_I_Eingabe!J131)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N131=\"\",\"\",IKW_I_Eingabe!N131)","v":""},null,"Ästungs-Stufe"]
[]
[null,{"$f":"IF(IKW_I_Eingabe!B133=\"\",\"\",IKW_I_Eingabe!B133)","v":"Güte-Kl. B Länge (Restlänge vor C-Stück)  [m]"},{"$f":"IF(IKW_I_Eingabe!C133=\"\",\"\",IKW_I_Eingabe!C133)","v":""},"B",{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!H133=\"\",\"\",IKW_I_Eingabe!H133)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(IKW_I_Eingabe!J133=\"\",\"\",IKW_I_Eingabe!J133)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N133=\"\",\"\",IKW_I_Eingabe!N133)","v":{"v":0,"d":"0.0"}},null,"I-III in Minuten"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(IKW_I_Eingabe!C135=\"\",\"\",IKW_I_Eingabe!C135)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H135=\"\",\"\",IKW_I_Eingabe!H135)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J135=\"\",\"\",IKW_I_Eingabe!J135)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N135=\"\",\"\",IKW_I_Eingabe!N135)","v":{"$error":"#VALUE!"}},null,"d1,3   (= BHD)"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"$f":"IF(IKW_I_Eingabe!C137=\"\",\"\",IKW_I_Eingabe!C137)","v":""},null,"!",null,null,{"$f":"IF(IKW_I_Eingabe!H137=\"\",\"\",IKW_I_Eingabe!H137)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(IKW_I_Eingabe!J137=\"\",\"\",IKW_I_Eingabe!J137)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N137=\"\",\"\",IKW_I_Eingabe!N137)","v":{"v":0,"d":"0.00 €"}},null,"Durchmesser"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(IKW_I_Eingabe!C139=\"\",\"\",IKW_I_Eingabe!C139)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H139=\"\",\"\",IKW_I_Eingabe!H139)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J139=\"\",\"\",IKW_I_Eingabe!J139)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N139=\"\",\"\",IKW_I_Eingabe!N139)","v":{"$error":"#VALUE!"}},null,"in 1,3m Höhe"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(IKW_I_Eingabe!C141=\"\",\"\",IKW_I_Eingabe!C141)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H141=\"\",\"\",IKW_I_Eingabe!H141)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J141=\"\",\"\",IKW_I_Eingabe!J141)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N141=\"\",\"\",IKW_I_Eingabe!N141)","v":{"$error":"#VALUE!"}},null,"Rm "]
[]
[null,{"$f":"IF(IKW_I_Eingabe!B143=\"\",\"\",IKW_I_Eingabe!B143)","v":"Güte-Kl. C Länge                                      [m]"},{"$f":"IF(IKW_I_Eingabe!C143=\"\",\"\",IKW_I_Eingabe!C143)","v":""},"C",{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!H143=\"\",\"\",IKW_I_Eingabe!H143)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(IKW_I_Eingabe!J143=\"\",\"\",IKW_I_Eingabe!J143)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N143=\"\",\"\",IKW_I_Eingabe!N143)","v":{"v":0,"d":"0.0"}},null,"Radius in der"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(IKW_I_Eingabe!C145=\"\",\"\",IKW_I_Eingabe!C145)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H145=\"\",\"\",IKW_I_Eingabe!H145)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J145=\"\",\"\",IKW_I_Eingabe!J145)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N145=\"\",\"\",IKW_I_Eingabe!N145)","v":""},null,"Mitte d. A-Stamm-"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"$f":"IF(IKW_I_Eingabe!C147=\"\",\"\",IKW_I_Eingabe!C147)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H147=\"\",\"\",IKW_I_Eingabe!H147)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(IKW_I_Eingabe!J147=\"\",\"\",IKW_I_Eingabe!J147)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N147=\"\",\"\",IKW_I_Eingabe!N147)","v":{"v":0,"d":"0.00 €"}},null,"(Werholz)-stückes"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(IKW_I_Eingabe!C149=\"\",\"\",IKW_I_Eingabe!C149)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H149=\"\",\"\",IKW_I_Eingabe!H149)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J149=\"\",\"\",IKW_I_Eingabe!J149)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N149=\"\",\"\",IKW_I_Eingabe!N149)","v":""},null,"lfm=lfd.Meter;fm=m³"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(IKW_I_Eingabe!C151=\"\",\"\",IKW_I_Eingabe!C151)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H151=\"\",\"\",IKW_I_Eingabe!H151)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J151=\"\",\"\",IKW_I_Eingabe!J151)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N151=\"\",\"\",IKW_I_Eingabe!N151)","v":""},null,"ZinF =Aufzinsg.=>U"]
[]
[]
[]
[null,"V. Wirtschaftlichkeit der Maßnahmen: Wertästung bis ",{"$f":"IF(IKW_I_Eingabe!C155=\"\",\"\",IKW_I_Eingabe!C155)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H155=\"\",\"\",IKW_I_Eingabe!H155)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J155=\"\",\"\",IKW_I_Eingabe!J155)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N155=\"\",\"\",IKW_I_Eingabe!N155)","v":"Ohne Ästung!"},null,"Zusammenstellung"]
[]
[null,"Durchschnittserlös                                            [€ / fm]",{"$f":"IF(IKW_I_Eingabe!C157=\"\",\"\",IKW_I_Eingabe!C157)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H157=\"\",\"\",IKW_I_Eingabe!H157)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J157=\"\",\"\",IKW_I_Eingabe!J157)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N157=\"\",\"\",IKW_I_Eingabe!N157)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!O157=\"\",\"\",IKW_I_Eingabe!O157)","v":"ZinsF/LS"},{"$f":"IF(IKW_I_Eingabe!P157=\"\",\"\",IKW_I_Eingabe!P157)","v":""},{"$f":"IF(IKW_I_Eingabe!Q157=\"\",\"\",IKW_I_Eingabe!Q157)","v":2.5}]
[null,"Güte-Kl. A Erlös / Baum                                            [€]",{"$f":"IF(IKW_I_Eingabe!C158=\"\",\"\",IKW_I_Eingabe!C158)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H158=\"\",\"\",IKW_I_Eingabe!H158)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J158=\"\",\"\",IKW_I_Eingabe!J158)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N158=\"\",\"\",IKW_I_Eingabe!N158)","v":""},{"$f":"IF(IKW_I_Eingabe!O158=\"\",\"\",IKW_I_Eingabe!O158)","v":{"v":0,"d":"0 €"}},{"$f":"IF(IKW_I_Eingabe!P158=\"\",\"\",IKW_I_Eingabe!P158)","v":"0/  0 /  0 /0m"},{"$f":"IF(IKW_I_Eingabe!Q158=\"\",\"\",IKW_I_Eingabe!Q158)","v":"A"}]
[]
[null,"             B Erlös / Baum                                            [€]",{"$f":"IF(IKW_I_Eingabe!C160=\"\",\"\",IKW_I_Eingabe!C160)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H160=\"\",\"\",IKW_I_Eingabe!H160)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J160=\"\",\"\",IKW_I_Eingabe!J160)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N160=\"\",\"\",IKW_I_Eingabe!N160)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!O160=\"\",\"\",IKW_I_Eingabe!O160)","v":{"v":0,"d":"0 €"}},{"$f":"IF(IKW_I_Eingabe!P160=\"\",\"\",IKW_I_Eingabe!P160)","v":"/ 0 / 0 /0m"},{"$f":"IF(IKW_I_Eingabe!Q160=\"\",\"\",IKW_I_Eingabe!Q160)","v":"B"}]
[]
[null,"             C Erlös / Baum                                            [€]",{"$f":"IF(IKW_I_Eingabe!C162=\"\",\"\",IKW_I_Eingabe!C162)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H162=\"\",\"\",IKW_I_Eingabe!H162)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J162=\"\",\"\",IKW_I_Eingabe!J162)","v":""},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N162=\"\",\"\",IKW_I_Eingabe!N162)","v":""},{"$f":"IF(IKW_I_Eingabe!O162=\"\",\"\",IKW_I_Eingabe!O162)","v":{"v":0,"d":"0 €"}},{"$f":"IF(IKW_I_Eingabe!P162=\"\",\"\",IKW_I_Eingabe!P162)","v":" /  0  /  0  /0m"},{"$f":"IF(IKW_I_Eingabe!Q162=\"\",\"\",IKW_I_Eingabe!Q162)","v":"C"}]
[]
[null,"Gesamterlös / Baum                                     [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C164=\"\",\"\",IKW_I_Eingabe!C164)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H164=\"\",\"\",IKW_I_Eingabe!H164)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J164=\"\",\"\",IKW_I_Eingabe!J164)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_I_Eingabe!N164=\"\",\"\",IKW_I_Eingabe!N164)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!O164=\"\",\"\",IKW_I_Eingabe!O164)","v":"Bäume"},{"$f":"IF(IKW_I_Eingabe!P164=\"\",\"\",IKW_I_Eingabe!P164)","v":" /  /  / 0St."},{"$f":"IF(IKW_I_Eingabe!Q164=\"\",\"\",IKW_I_Eingabe!Q164)","v":0}]
[]
[null,"Ertragswert (Mehrerlös: Baum geästet zu ungeastet)    [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C166=\"\",\"\",IKW_I_Eingabe!C166)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H166=\"\",\"\",IKW_I_Eingabe!H166)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J166=\"\",\"\",IKW_I_Eingabe!J166)","v":{"$error":"#VALUE!"}},null,null,"Arbeitskraft / h",null,{"$f":"IF(IKW_I_Eingabe!O166=\"\",\"\",IKW_I_Eingabe!O166)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(IKW_I_Eingabe!P166=\"\",\"\",IKW_I_Eingabe!P166)","v":"/   /   /0"},{"$f":"IF(IKW_I_Eingabe!Q166=\"\",\"\",IKW_I_Eingabe!Q166)","v":"GAZ"}]
[]
[null,"abzgl. Ästungsaufwand (aufgezinst bis Alter U)      [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C168=\"\",\"\",IKW_I_Eingabe!C168)","v":""},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H168=\"\",\"\",IKW_I_Eingabe!H168)","v":""},null,{"$f":"IF(IKW_I_Eingabe!J168=\"\",\"\",IKW_I_Eingabe!J168)","v":""},null,null,"Rm /astfr.Schicht",null,{"$f":"IF(IKW_I_Eingabe!O168=\"\",\"\",IKW_I_Eingabe!O168)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!P168=\"\",\"\",IKW_I_Eingabe!P168)","v":""},{"$f":"IF(IKW_I_Eingabe!Q168=\"\",\"\",IKW_I_Eingabe!Q168)","v":"cm"}]
[]
[null,"= Mehrertrag je geästeter Erntebaum (netto)  [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C170=\"\",\"\",IKW_I_Eingabe!C170)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H170=\"\",\"\",IKW_I_Eingabe!H170)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J170=\"\",\"\",IKW_I_Eingabe!J170)","v":{"$error":"#VALUE!"}},null,null,"Vol.: astig/astfr.",null,{"$f":"IF(IKW_I_Eingabe!O170=\"\",\"\",IKW_I_Eingabe!O170)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!P170=\"\",\"\",IKW_I_Eingabe!P170)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!Q170=\"\",\"\",IKW_I_Eingabe!Q170)","v":"fm"}]
[]
[null,"Rentabilität aller Maßnahme(n) bis Stufe ...     [Faktor]",{"$f":"IF(IKW_I_Eingabe!C172=\"\",\"\",IKW_I_Eingabe!C172)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H172=\"\",\"\",IKW_I_Eingabe!H172)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J172=\"\",\"\",IKW_I_Eingabe!J172)","v":{"$error":"#VALUE!"}},null,null," Vol.-%: \" \" / \" \"",null,{"$f":"IF(IKW_I_Eingabe!O172=\"\",\"\",IKW_I_Eingabe!O172)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!P172=\"\",\"\",IKW_I_Eingabe!P172)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!Q172=\"\",\"\",IKW_I_Eingabe!Q172)","v":"V%"}]
[]
[null,"Grenzertrag der Ästungs-Stufe ...                   [€ / Baum]",{"$f":"IF(IKW_I_Eingabe!C174=\"\",\"\",IKW_I_Eingabe!C174)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H174=\"\",\"\",IKW_I_Eingabe!H174)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J174=\"\",\"\",IKW_I_Eingabe!J174)","v":{"$error":"#VALUE!"}},null,null,"Kosten: lfm / fm",null,{"$f":"IF(IKW_I_Eingabe!O174=\"\",\"\",IKW_I_Eingabe!O174)","v":""},{"$f":"IF(IKW_I_Eingabe!P174=\"\",\"\",IKW_I_Eingabe!P174)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!Q174=\"\",\"\",IKW_I_Eingabe!Q174)","v":"€"}]
[]
[null,"Rentabilität der Einzelmaßnahme: Stufe...       [Faktor]",{"$f":"IF(IKW_I_Eingabe!C176=\"\",\"\",IKW_I_Eingabe!C176)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_I_Eingabe!H176=\"\",\"\",IKW_I_Eingabe!H176)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_I_Eingabe!J176=\"\",\"\",IKW_I_Eingabe!J176)","v":{"$error":"#VALUE!"}},null,null,"d1,3/astfr.Schicht",null,{"$f":"IF(IKW_I_Eingabe!O176=\"\",\"\",IKW_I_Eingabe!O176)","v":{"v":0,"d":"0.0"}},{"$f":"IF(IKW_I_Eingabe!P176=\"\",\"\",IKW_I_Eingabe!P176)","v":""},{"$f":"IF(IKW_I_Eingabe!Q176=\"\",\"\",IKW_I_Eingabe!Q176)","v":"cm"}]
[]
[]
[]
[null,"IV-1. Zu erwartende Sortierung und erzielbare Erlöse"]
[null,"IV-1 A1. Variante 3 mit Wertästung (nur Maßnahme 1)"]
[null,"GKl. A Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. A  Durchmesser o. R. [cm]",{"v":76,"d":"76.0"}]
[]
[null,"GKl. A Preis [€/Efm o. R.]",{"v":200,"d":"200.00 €"}]
[]
[null,"GKl. A Masse [Efm o. R.]",{"$f":"IF(OR($C$182=\"\",$C$184=\"\"),\"\",($C$184/100*$C$184/100)/4*3.14159*$C$182)","v":{"v":2.26822798,"d":"2.27"}}]
[]
[null,"GKl. A Erlös [€]",{"$f":"IF(OR($C$186=\"\",$C$188=\"\"),\"\",$C$186*$C$188)","v":{"v":453.64559599999995,"d":"453.65 €"}}]
[]
[null,"GKl. B Länge [m]",{"v":22,"d":"22.0"}]
[]
[null,"GKl. B  Durchmesser o. R. [cm]",{"v":60,"d":"60.0"}]
[]
[null,"GKl. B Preis [ €/ Efm o. R.]",{"v":96,"d":"96.00 €"}]
[]
[null,"GKl. B Masse [Efm o. R.]",{"$f":"IF(OR($C$192=\"\",$C$194=\"\"),\"\",($C$194/100*$C$194/100)/4*3.14159*$C$192)","v":{"v":6.220348199999999,"d":"6.22"}}]
[]
[null,"GKl. B Erlös [€]",{"$f":"IF(OR($C$196=\"\",$C$198=\"\"),\"\",$C$196*$C$198)","v":{"v":597.1534271999999,"d":"597.15 €"}}]
[]
[null,"GKl. C Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. C  Durchmesser o. R. [cm]",{"v":39,"d":"39.0"}]
[]
[null,"GKl. C Preis [€/Efm o. R.]",{"v":81.6,"d":"81.60 €"}]
[]
[null,"GKl. C Masse [Efm o. R.]",{"$f":"IF(OR($C$202=\"\",$C$204=\"\"),\"\",($C$204/100*$C$204/100)/4*3.14159*$C$202)","v":{"v":0.59729479875,"d":"0.60"}}]
[]
[null,"GKl. C Erlös [€]",{"$f":"IF(OR($C$206=\"\",$C$208=\"\"),\"\",$C$206*$C$208)","v":{"v":48.739255578,"d":"48.74 €"}}]
[]
[null,"Programmerstellung:"]
[]
[null,"K.-H. Schmitz; LB WuH NRW; LuVFA Arnsberger Wald -SPA Waldbau-"]
[]
[null,"Bemerkung"]
{"$rows_empty":21}
[null,"Platz für Anfügungen des Anwenders:"]

{"sheet":"IKW_II_Eingabe","index":2,"n_rows":238,"n_cols":17,"rows_kept":238,"merged":[[0,6,0,9],[0,10,0,12],[2,6,2,13],[4,6,4,12],[20,13,20,14],[27,3,27,4],[30,1,30,2],[30,7,30,9],[30,13,30,15],[46,1,46,2],[46,7,46,9],[46,13,46,15],[48,1,48,2],[48,7,48,9],[48,13,48,15],[52,1,52,2],[52,7,52,9],[52,13,52,15],[56,1,56,2],[56,7,56,9],[56,13,56,15],[216,1,234,17]]}
[null,"W     e     r     t     ä     s     t     u     n     g","Lokalität >",null,null,"Besitz",{"$nulls":4},"RFA",{"$nulls":3},"Abt."]
[]
[null,"I n v e s t i t i o n s k a l k u l a t i o n","vom","Adresse",{"$nulls":10},"GK-RW"]
[]
[null,"Erst.:FAR Schmitz, LB Wald u. Holz NRW; LVFA Arnsberger Wald",{"$f":"TODAY()","v":"2014-01-07"},"Resultat",null,null,{"$f":"IF($C$170>0,\"Netto-Rendite je geäst.Erntebaum bis \"&C121,IF($C$170<0,\"Netto-Verlust je geäst.Erntebaum bis \"&C121,\"\"))","v":{"$error":"#VALUE!"}},{"$nulls":6},{"$f":"$C$170","v":{"$error":"#VALUE!"}},"GK-HW"]
[]
[null,"I. Bestand"]
[]
[null,"I A. Ist-Daten             E i n g a b e f o r m u l a r",{"$nulls":4},"I B. Soll-Daten",{"$nulls":6},"Eingabe erforderlich =","!"]
[]
[null,"Bestand                                                         [Baumart]",{"$nulls":4},"erwarteter BHD (d1,3) o. R. im Alter U                            [cm]",{"$nulls":9},"!"]
[]
[null,"Ertragsklasse                                                        [EKl.]",{"$nulls":4},"jährlicher BHD-Zuwachs bis Alter U                                [cm]",{"$nulls":9},"!"]
[]
[null,"Bestandesbegründung                                           [Jahr]",null,null,"!",null,"verbleibender Zeitraum bis Alter U                               [Jahre]",{"$nulls":8},{"$f":"IF($P$13=0,\"\",ROUNDUP(($P$11-$C$19)/$P$13,0))","v":""}]
[]
[null,"Aktuelle Bestandesaufnahme                                 [Jahr]",null,null,"!",null,"Resultierende Umtriebszeit                                        [Jahre]",{"$nulls":8},{"$f":"IF(OR($C$15=\"\",$C$17=\"\",$P$15=\"\"),\"\",$C$17-$C$15+$P$15)","v":""}]
[]
[null,"aktueller BHD der zu ästenden Bäume o. R.             [cm]",null,null,"!",null,"entspricht Kalenderjahr im Alter U                                [Jahr]",{"$nulls":8},{"$f":"IF($P$17=\"\",\"\",$C$15+$P$17)","v":""}]
[]
[null,"Abholzigkeit Güteklasse A (Durchmesser-Abnahme)[cm / lfdm]",null,null,"!",null,"Ggf. abweichende Umtriebszeit         [U]",{"$nulls":6},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",\"\"))","v":""}]
[]
[null,"Abholzigkeit Güteklasse B (GKl. C =  AbhzkB+1cm)  [cm / lfdm]",null,null,"!",null,"= astfreie Schicht [cm]  /  BHD [cm]   /  Jahr",{"$nulls":6},{"$f":"(O23-C19)/2","v":{"v":0,"d":"0.00"}},{"$f":"IF($P$11=\"\",0,IF($P$23>$P$19,$P$11+($P$23-$P$19)*$P$13,IF($P$23<$P$19,$P$11+($P$23-$P$19)*$P$13,$P$11)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(AND($P$21=\"\",$P$19=\"\"),\"\",IF($P$21>0,$C$15+$P$21,$P$19))","v":""}]
[]
[]
[]
[]
[null,"II. Maßnahme","Stufe I",{"$f":"IF(OR($C$33=\"\",$C$37=\"\",$C$37=0),\"\",(($P$11+$C$21)-($C$37*$C$21))/2-((($C$19+$C$21)-($C$37*$C$21)+($C$33-$C$17)*$P$13)/2))","v":""},{"$f":"(($P$11+$C$21)-($C$37*$C$21))/2-((($C$19+$C$21)-($C$37*$C$21)+($C$33-$C$17)*$P$13)/2)","v":{"v":0,"d":"0.0"}},null,null,"Stufe II",{"$f":"IF(OR($H$33=\"\",$H$37=\"\",$H$37=0),\"\",(($P$11+$C$21)-($H$37*$C$21))/2-((($C$19+$C$21)-($H$37*$C$21)+($H$33-$C$17)*$P$13)/2))","v":""},{"$f":"IF($I$28<>\"\",\"cm\",\"\")","v":""},{"$nulls":3},"Stufe III",{"$f":"IF(OR($N$33=\"\",$N$37=\"\",$N$37=0),\"\",(($P$11+$C$21)-($N$37*$C$21))/2-((($C$19+$C$21)-($N$37*$C$21)+($N$33-$C$17)*$P$13)/2))","v":""},{"$f":"IF(OR($O$28<>\"\",$I$28<>\"\",$D$28<>\"\"),\"cm astfr. Schicht\",\"\")","v":""}]
[]
[]
[]
[]
[null,"Maßnahme-Ausführung                                         [Jahr]",null,null,"!",{"$nulls":3},"(!)",{"$f":"IF(AND($H$33=\"\",$C$33=\"\"),\"\",IF($H$33=\"\",$C$33,$H$33))","v":""},{"$nulls":4},"(!)",{"$f":"IF(AND($N$33=\"\",$J$33=\"\",$C$33=\"\"),\"\",IF($N$33=\"\",$J$33,$N$33))","v":""}]
[]
[null,"Ästungshöhe von ...                                                 [m]",{"v":0,"d":"0.0"},{"$nulls":4},{"$f":"$C$37","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"$H$37","v":{"v":0,"d":"0.0"}}]
[]
[null,"Ästungshöhe bis ...                                                  [m]",null,null,"!",{"$nulls":3},"!",{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"<=W e r t ?\",\"\")","v":""},{"$nulls":4},"!",{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"<=W e r t ?\",\"\")","v":""}]
[]
[null,"Baumabstand: (Optimale Verteilung; 3-Eckverband)                [m]",{"$nulls":4},"[n]",{"$f":"10000/($C$39^2*0.8660254)","v":{"$error":"#DIV/0!"}},"(errechn. Anzahl /ha)",{"$nulls":3},"[n]",{"$f":"10000/($C$39^2*0.8660254)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Anzahl zu ästender Bäume je ha                     [Stück / ha]",null,null,"!",{"$nulls":3},"(!)",{"$f":"IF(AND($H$41=\"\",$C$41=\"\"),\"\",IF($H$41=\"\",$C$41,$H$41))","v":""},{"$nulls":4},"(!)",{"$f":"IF(AND($N$41=\"\",$J$41=\"\",$C$41=\"\"),\"\",IF($N$41=\"\",$J$41,$N$41))","v":""}]
[]
[null,"Maßnahmefläche                                                    [ha]"]
[]
[null,"Beschreibung:[Maschineneinsatz  /  Werkzeug  /  Verfahren] "]
[]
[]
[]
[]
[]
[null,"Ggf. Behandlungsmittel [Produktbezeichng] / [Menge/Baum]"]
[]
[]
[]
[null,"Dokumentation der Realisierung: [Jahr]/[Bemerkung]"]
[]
[]
[]
[]
[]
[null,"III. Kosten"]
[null,"III A. Basisdaten","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Alternative 1: Entgelt / lfdm (aktuellerWert/Folgejahre) [€ / lfdm]",null,null,"[!]",{"$nulls":3},"[!]",{"$f":"IF(AND($H$64>0,$J$84>0),$H$64*$J$84,IF($H$64>0,$H$64,\"\"))","v":""},{"$nulls":4},"[!]",{"$f":"IF(AND($N$64>0,$P$84>0),$N$64*$P$84,IF($N$64>0,$N$64,\"\"))","v":""}]
[]
[null,"\"\" 2: Stundenlohn (Folgejahre: Lohn x Steigerungsfaktor [LSF]) [€/h]",null,null,"!",null,null,{"$f":"IF(AND($C$66>0,$J$84>0),$C$66*$J$84,IF($C$66>0,$C$66,\"\"))","v":""},"in Jahren",{"$f":"IF(AND($C$33>0,$J$33>0),$J$33-$C$33,\"\")","v":""},{"$nulls":3},{"$f":"IF(AND($C$66>0,$P$84>0),$C$66*$P$84,IF($C$66>0,$C$66,\"\"))","v":""},"in Jahren",{"$f":"IF(AND($C$33>0,$P$33>0),$P$33-$C$33,\"\")","v":""}]
[]
[null,"Erschwerniszuschlag   (ggf. Baumbesteigung)                            [%]"]
[]
[null,"Zeitvorgabe Arbeitskraft (GAZ)                       [min. / Baum]",null,{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":""},"!",{"$nulls":3},"(!)",{"$f":"IF(AND($H$70>0,$H$66>0,$H$64>0),\"Nicht 1: und 2:!!!\",\"\")","v":""},{"$nulls":4},"(!)",{"$f":"IF(AND($N$70>0,$N$66>0,$N$64>0),\"Nicht 1: und 2:!!!\",\"\")","v":""}]
[]
[null,"Verwaltungskostenzuschlag / Dokumentationskosten   [%]",{"$nulls":7},{"$f":"IF(H72<>\"\",H72,IF($C$72=\"\",\"\",$C$72))","v":""},{"$nulls":5},{"$f":"IF($N$72<>\"\",$N$72,IF($C$72=\"\",\"\",$C$72))","v":""}]
[]
[null,"Maschineneinsatz                                             [€ / MAS]"]
[]
[null,"Zeitvorgabe Maschineneinsatz (MAS)           [min. / Baum]",null,{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":""},{"$nulls":5},{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"Ästg.-Höhe?\",\"\")","v":""},{"$nulls":5},{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"Ästg.-Höhe?\",\"\")","v":""}]
[]
[null,"Werkzeug (Entschädigung / Abnutzung)                         [€ / h]"]
[]
[null,"Behandlungsmittel                                         [€ / Einheit]"]
[]
[null,"Zinssatz für Aufzinsung der Investitionskosten (p)      [%]",{"v":3,"d":"3.00"},null,"!",null,null,"Lohnsteigerung [%]",null,{"v":2.5,"d":"2.50"},"!",null,null,"Lohnsteigerung (p) [% / a]",null,{"$f":"IF($J$82>0,$J$82,0)","v":{"v":2.5,"d":"2.50"}}]
[]
[null,"Aufzinsungsfaktor (Askontierung; p = % Zinsen)           [(1+p)n]",{"$f":"IF(OR($C$82=\"\",$C$86=\"\"),\"\",(1+$C$82/100)^$C$86)","v":""},{"$nulls":4},{"$f":"IF(OR($J$41=\"\",$H$86=\"\"),\"\",(1+$J$86/100)^$H$86)","v":""},"[LSF]",{"$f":"IF(OR($J$41=\"\",$J$66=\"\"),\"\",(1+$J$82/100)^$J$66)","v":""},{"$nulls":3},{"$f":"IF(OR($J$41=\"\",$N$86=\"\"),\"\",(1+$P$86/100)^$N$86)","v":""},"[LSF]",{"$f":"IF(OR($P$41=\"\",$P$66=\"\"),\"\",(1+$P$82/100)^$P$66)","v":""}]
[]
[null,"Aufzinsungs-Zeitraum bis Alter U  (n)                   [Jahre]",{"$f":"IF(OR($C$15=\"\",$C$33=\"\",$P$23=\"\"),\"\",$P$23-$C$33)","v":""},{"$nulls":4},{"$f":"IF(OR($C$15=\"\",$J$33=\"\",$P$23=\"\"),\"\",$P$23-$J$33)","v":""},"zu  [%]",{"$f":"IF($C$82=\"\",\"\",$C$82)","v":{"v":3,"d":"3.00"}},{"$nulls":3},{"$f":"IF(OR($C$15=\"\",$P$33=\"\",$P$23=\"\"),\"\",$P$23-$P$33)","v":""},"zu  [%]",{"$f":"IF($C$82=\"\",\"\",$C$82)","v":{"v":3,"d":"3.00"}}]
[]
[]
[null,"III B. Kalkulation der Maßnahme","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Reine Arbeitskosten                                        [€ / Baum]",{"$f":"IF(AND($C$64=\"\",OR($C$66=\"\",$C$70=\"\")),\"\",IF(AND($C$64>0,$C$37>0),$C$37*$C$64,IF($C$68=\"\",($C$66/60)*$C$70,($C$66/60)*$C$70*(1+$C$68/100))))","v":""},{"$nulls":4},{"$f":"IF(AND($H$64=\"\",OR($H$66=\"\",$H$70=\"\")),\"\",IF(AND($H$64>0,$H$37>0),($H$37-$C$37)*$J$64,IF($H$68=\"\",($H$66/60)*$H$70,($H$66/60)*$H$70*(1+$H$68/100))))","v":""},{"$nulls":5},{"$f":"IF(AND($N$64=\"\",OR($N$66=\"\",$N$70=\"\")),\"\",IF(AND($N$64>0,$N$37>0),($N$37-$H$37)*$P$64,IF($N$68=\"\",($N$66/60)*$N$70,($N$66/60)*$N$70*(1+$N$68/100))))","v":""}]
[]
[null,"Verwaltungskosten / Dokumentation                 [€ / Baum]",{"$f":"IF(OR($C$72=\"\",$C$91=\"\"),\"\",($C$91/100)*$C$72)","v":""},{"$nulls":4},{"$f":"IF(OR($J$72=\"\",$H$91=\"\"),\"\",($H$91/100)*$J$72)","v":""},{"$nulls":5},{"$f":"IF(OR($P$72=\"\",$N$91=\"\"),\"\",($N$91/100)*$P$72)","v":""}]
[]
[null,"Maschineneinsatz                                           [€ / Baum]",{"$f":"IF(OR($C$74=\"\",$C$76=\"\"),\"\",($C$74/60)*$C$76)","v":""},{"$nulls":4},{"$f":"IF(OR($H$74=\"\",$H$76=\"\"),\"\",($H$74/60)*$H$76)","v":""},{"$nulls":5},{"$f":"IF(OR($N$74=\"\",$N$76=\"\"),\"\",($N$74/60)*$N$76)","v":""}]
[]
[null,"Werkzeug                                                      [€ / Baum]",{"$f":"IF(OR($C$70=\"\",$C$78=\"\"),\"\",($C$78/60)*$C$70)","v":""},{"$nulls":4},{"$f":"IF(OR($H$70=\"\",$H$78=\"\"),\"\",($H$78/60)*$H$70)","v":""},{"$nulls":5},{"$f":"IF(OR($N$70=\"\",$N$78=\"\"),\"\",($N$78/60)*$N$70)","v":""}]
[]
[null,"Behandlungsmittel                                          [€ / Baum]",{"$f":"IF(OR($C$51=\"\",$C$80=\"\"),\"\",$C$51*$C$80)","v":""},{"$nulls":4},{"$f":"IF(OR($H$51=\"\",$H$80=\"\"),\"\",$H$51*$H$80)","v":""},{"$nulls":5},{"$f":"IF(OR($N$51=\"\",$N$80=\"\"),\"\",$N$51*$N$80)","v":""}]
[]
[null,"Maßnahme insgesamt (unverzinst)                  [€ / Baum]",{"$f":"SUM($C$91,$C$93,$C$95,$C$97,$C$99)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"SUM($H$91,$H$93,$H$95,$H$97,$H$99)","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},{"$f":"SUM($N$91,$N$93,$N$95,$N$97,$N$99)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Maßnahme insgesamt (unverzinst)                        [€ / ha]",{"$f":"IF(OR($C$41=\"\",$C$101=\"\"),\"\",$C$101*$C$41)","v":""},{"$nulls":4},{"$f":"IF(OR($J$41=\"\",$H$101=\"\"),\"\",$H$101*$J$41)","v":""},{"$nulls":5},{"$f":"IF(OR($P$41=\"\",$N$101=\"\"),\"\",$N$101*$P$41)","v":""}]
[]
[null,"Zinskosten bis Alter U                                     [€ / Baum]",{"$f":"IF(OR($C$84=\"\",$C$101=\"\"),\"\",($C$101)*($C$84-1))","v":""},{"$nulls":4},{"$f":"IF(OR($H$84=\"\",$H$101=\"\"),\"\",($H$101)*($H$84-1))","v":""},{"$nulls":5},{"$f":"IF(OR($N$84=\"\",$N$101=\"\"),\"\",($N$101)*($N$84-1))","v":""}]
[]
[null,"Maßnahme 1 insgesamt (aufgezinst bis Alter U) [€ / Baum]",{"$f":"SUM($C$101,$C$105)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"SUM($H$101,$H$105)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 2)",{"$nulls":3},{"$f":"SUM($N$101,$N$105)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 3)"]
[]
[null,"Maßnahme insgesamt (aufgezinst bis Alter U)         [€ / ha]",{"$f":"IF(OR($C$107=\"\",$C$41=\"\"),\"\",$C$107*$C$41)","v":""},{"$nulls":4},{"$f":"IF(OR($H$107=\"\",$J$41=\"\"),\"\",$H$107*$J$41)","v":""},null,"\"\"        \"\"",{"$nulls":3},{"$f":"IF(OR($N$107=\"\",$P$41=\"\"),\"\",$N$107*$P$41)","v":""},null,"\"\"          \"\""]
[null,"III C. Gesamtkalkulation","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[null,"Gesamtkosten je ha (aufgezinst bis Alter U)               [€ / ha]",{"$f":"SUM($C$109)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"SUM($C$109,$H$109)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"SUM($C$109,$H$109,$N$109)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe III)"]
[]
[null,"Erwarteter Anteil geästeter Bäume mit Wertholz         [%]",{"v":75,"d":"75.0"},null,"!"]
[]
[null,"Erwartete Anzahl geästeter Bäume / ha mit Wertholz  [St.]",{"$f":"ROUNDDOWN(IF(OR($C$41=\"\",$C$113=\"\",$C$113=0),0,($C$41/100)*$C$113),0)","v":0}]
[]
[null,"Umlegung der Kosten je ha auf die erwartete Anzahl geästeter"]
[null,"Bäume mit Wertholzanteil (aufgezinst bis Alter U)    [€ /Baum]",{"$f":"IF(OR($C$111=\"\",$C$115=\"\",$C$115=0),\"\",$C$111/$C$115)","v":""},{"$nulls":4},{"$f":"IF(OR($H$111=\"\",$C$115=\"\",$C$115=0),\"\",$H$111/$C$115)","v":""},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"IF(OR($N$111=\"\",$C$115=\"\",$C$115=0),\"\",$N$111/$C$115)","v":""},null,"(insgesamt bis Stufe III)"]
[null,{"$f":"\"Diesen Betrag muß jeder der erwarteten \" &C115&\" Erntebäume min. zusätzlich erbringen!\"","v":"Diesen Betrag muß jeder der erwarteten 0 Erntebäume min. zusätzlich erbringen!"}]
[]
[null,"IV. Zu erwartende Sortierung und erzielbare Erlöse",{"$f":"IF(AND($N$37>0,$P$41>0,$N$91<>\"\"),\"Stufe III\",IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")))","v":""},{"$nulls":4},{"$f":"IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\"))","v":""},null,{"$f":"IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")","v":""},{"$nulls":3},"Ohne","W   e   r   t   ä   s   t   u   n   g"]
[null,"fm / Baum",{"$f":"IF($C$143>0,$C$129+$C$139+$C$149,$C$129+$C$139)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF($C$143>0,$H$129+$H$139+$H$149,$H$129+$H$139)","v":{"$error":"#VALUE!"}},null,{"$f":"IF($C$143>0,$J$129+$J$139+$J$149,$J$129+$J$139)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF($C$143>0,$N$129+$N$139+$N$149,$N$129+$N$139)","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,(($N$122-$C$122)/$C$122)*100,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,\"% Vol.-Diff.\",\"\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"\"Güte-Kl. A Länge                                    \"&$C$121&\"  [m]\"","v":"Güte-Kl. A Länge                                      [m]"},{"$f":"IF(AND($N$37=\"\",$H$37=\"\",$C$37=\"\"),0,IF(OR(N64>0,AND($N$37>0,$N$70>0)),$N$37,IF(OR(H64>0,AND($H$37>0,$H$70>0)),$H$37,IF(OR(C64>0,AND($C$37>0,$C$70>0)),$C$37,0))))","v":{"v":0,"d":"0.0"}},"A",{"$f":"IF(AND($H$121=$C$121,$H$168<>$C$168),\"??\",\"\")","v":""},null,null,{"$f":"IF(AND($H$37=\"\",$C$37=\"\"),0,IF(OR($H$64>0,AND($H$37>0,$H$70>0)),$H$37,IF(OR($C$64>0,AND($C$37>0,$C$70>0)),$C$37,0)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(AND($H$37=\"\",$C$37=\"\"),0,IF(OR($C$64>0,AND($C$37>0,$C$70>0)),$C$37,IF($C$37>0,$C$37,0)))","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"v":0,"d":"0.0"},null,"Abkürzg.-Verz."]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($O$23=\"\",$O$23=0),\"\",$O$23+$C$21-($C$123*0.5)*$C$21)","v":""},{"$nulls":4},{"$f":"IF($C$125=\"\",\"\",IF($H$123/2<=$C$123,($O$23+$C$21)-($H$123/2)*$C$21,($O$23+$C$21)-(($C$123*$C$21)+(($H$123/2-$C$123)*$C$23))))","v":""},null,{"$f":"IF($C$125=\"\",\"\",IF($J$123/2<=$C$123,($O$23+$C$21)-($J$123/2)*$C$21,($O$23+$C$21)-(($C$123*$C$21)+(($J$123/2-$C$123)*$C$23))))","v":""},{"$nulls":3},{"$f":"IF($C$125=\"\",\"\",IF($N$123/2<=$C$123,($O$23+$C$21)-($N$123/2)*$C$21,($O$23+$C$21)-(($C$123*$C$21)+(($N$123/2-$C$123)*$C$23))))","v":""},null,"GAZ"]
[]
[null,"                 Geästetes Holz (Wertholz-Stück)     [€ / Efm o. R.]",null,null,"!",null,null,{"$f":"$C$127","v":{"v":0,"d":"0.00 €"}},null,{"$f":"$C$127","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"$C$127","v":{"v":0,"d":"0.00 €"}},null,"Gesamt-Ar-"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(OR($C$123=\"\",$C$125=\"\"),\"\",($C$125/100*$C$125/100)/4*3.14159*$C$123)","v":""},{"$nulls":4},{"$f":"IF(OR($H$123=\"\",$H$125=\"\"),\"\",($H$125/100*$H$125/100)/4*3.14159*$H$123)","v":""},null,{"$f":"IF(OR($J$123=\"\",$J$125=\"\"),\"\",($J$125/100*$J$125/100)/4*3.14159*$J$123)","v":""},{"$nulls":3},{"$f":"IF(OR($N$123=\"\",$N$125=\"\"),\"\",($N$125/100*$N$125/100)/4*3.14159*$N$123)","v":""},null,"beits-Zeit für"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$127=\"\",$C$129=\"\"),\"\",$C$127*$C$129)","v":""},{"$nulls":4},{"$f":"IF(OR($H$127=\"\",$H$129=\"\"),\"\",$H$127*$H$129)","v":""},null,{"$f":"IF(OR($J$127=\"\",$J$129=\"\"),\"\",$J$127*$J$129)","v":""},{"$nulls":3},{"$f":"IF(OR($N$127=\"\",$N$129=\"\"),\"\",$N$127*$N$129)","v":""},null,"Ästungs-Stufe"]
[]
[null,{"$f":"\"Güte-Kl. B Länge (Restlänge vor C-Stück) \"&$C$121&\" [m]\"","v":"Güte-Kl. B Länge (Restlänge vor C-Stück)  [m]"},null,"B",{"$nulls":3},{"$f":"IF(AND($C$123=\"\",$C$133=\"\"),\"\",IF(AND($C$123>0,OR($C$133=\"\",$C$133=0),OR($H$123=\"\",$H$123=0)),$C$123,IF($H$123>0,$C$123+$C$133-$H$123,$C$123+$C$133)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(AND($C$123=\"\",$C$133=\"\"),\"\",IF(AND($C$123>0,OR($C$133=\"\",$C$133=0),OR($J$123=\"\",$J$123=0)),$C$123,IF($J$123>0,$C$123+$C$133-$J$123,$C$123+$C$133)))","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(AND($C$123=\"\",$C$133=\"\"),\"\",IF(AND($C$123>0,OR($C$133=\"\",$C$133=0),OR($N$123=\"\",$N$123=0)),$C$123,IF($N$123>0,$C$123+$C$133-$N$123,$C$123+$C$133)))","v":{"v":0,"d":"0.0"}},null,"I-III in Minuten"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($C$133=\"\",$C$133=0),$C$125-(($C$123*0.5*$C$21)+0.01*0.5*($C$23)),$C$125-(($C$123*0.5*$C$21)+$C$133*0.5*($C$23)))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF($C$135=\"\",\"\",IF(($H$123+$H$133/2)>$C$123,($O$23+$C$21)-($C$123*$C$21)-($H$123-$C$123+$H$133/2)*$C$23,($O$23+$C$21)-($H$123+$H$133/2)*$C$21))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($C$135=\"\",\"\",IF(($J$123+$J$133/2)>$C$123,($O$23+$C$21)-($C$123*$C$21)-($J$123-$C$123+$J$133/2)*$C$23,($O$23+$C$21)-($J$123+$J$133/2)*$C$21))","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF($C$135=\"\",\"\",IF(($N$123+$N$133/2)>$C$123,($O$23+$C$21)-($C$123*$C$21)-($N$123-$C$123+$N$133/2)*$C$23,($O$23+$C$21)-($N$123+$N$133/2)*$C$21))","v":{"$error":"#VALUE!"}},null,"d1,3   (= BHD)"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",null,null,"!",null,null,{"$f":"$C$137","v":{"v":0,"d":"0.00 €"}},null,{"$f":"$C$137","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"$C$137","v":{"v":0,"d":"0.00 €"}},null,"Durchmesser"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(AND($C$133=\"\",$C$135=\"\"),\"\",IF(OR($C$133=\"\",$C$133=0),0.00001,($C$135/100*$C$135/100)/4*3.14159*$C$133))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$133=\"\",$H$135=\"\"),\"\",($H$135/100*$H$135/100)/4*3.14159*$H$133)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$133=\"\",$J$135=\"\"),\"\",($J$135/100*$J$135/100)/4*3.14159*$J$133)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(OR($N$133=\"\",$N$135=\"\"),\"\",($N$135/100*$N$135/100)/4*3.14159*$N$133)","v":{"$error":"#VALUE!"}},null,"in 1,3m Höhe"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$137=\"\",$C$139=\"\"),\"\",$C$137*$C$139)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$137=\"\",$H$139=\"\"),\"\",$H$137*$H$139)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$137=\"\",$J$139=\"\"),\"\",$J$137*$J$139)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(OR($N$137=\"\",$N$139=\"\"),\"\",$N$137*$N$139)","v":{"$error":"#VALUE!"}},null,"Rm "]
[]
[null,{"$f":"\"Güte-Kl. C Länge                                    \"&$C$121&\"  [m]\"","v":"Güte-Kl. C Länge                                      [m]"},null,"C",{"$nulls":3},{"$f":"$C$143","v":{"v":0,"d":"0.0"}},null,{"$f":"$C$143","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"$C$143","v":{"v":0,"d":"0.0"}},null,"Radius in der"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($C$143=\"\",$C$143=0),\"\",$C$135-(($C$133*0.5)*$C$23)-(($C$143*0.5)*($C$23+1)))","v":""},{"$nulls":4},{"$f":"$C$145","v":""},null,{"$f":"$C$145","v":""},{"$nulls":3},{"$f":"$C$145","v":""},null,"Mitte d. A-Stamm-"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"$nulls":5},{"$f":"$C$147","v":{"v":0,"d":"0.00 €"}},null,{"$f":"$C$147","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"$C$147","v":{"v":0,"d":"0.00 €"}},null,"(Werholz)-stückes"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(OR($C$143=\"\",$C$145=\"\"),\"\",($C$145/100*$C$145/100)/4*3.14159*$C$143)","v":""},{"$nulls":4},{"$f":"IF(OR($N$143=\"\",$N$145=\"\"),\"\",($N$145/100*$N$145/100)/4*3.14159*$N$143)","v":""},null,{"$f":"IF(OR($N$143=\"\",$N$145=\"\"),\"\",($N$145/100*$N$145/100)/4*3.14159*$N$143)","v":""},{"$nulls":3},{"$f":"IF(OR($N$143=\"\",$N$145=\"\"),\"\",($N$145/100*$N$145/100)/4*3.14159*$N$143)","v":""},null,"lfm=lfd.Meter;fm=m³"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$147=\"\",$C$149=\"\"),\"\",$C$147*$C$149)","v":""},{"$nulls":4},{"$f":"IF(OR($H$147=\"\",$H$149=\"\"),\"\",$H$147*$H$149)","v":""},null,{"$f":"IF(OR($J$147=\"\",$J$149=\"\"),\"\",$J$147*$J$149)","v":""},{"$nulls":3},{"$f":"IF(OR($N$147=\"\",$N$149=\"\"),\"\",$N$147*$N$149)","v":""},null,"ZinF =Aufzinsg.=>U"]
[]
[]
[]
[null,"V. Wirtschaftlichkeit der Maßnahmen: Wertästung bis ",{"$f":"IF(AND($N$37>0,$P$41>0,$N$91<>\"\"),\"Stufe III\",IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")))","v":""},{"$nulls":4},{"$f":"IF(AND($H$37>0,$J$41>0,$H$91<>\"\"),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\"))","v":""},null,{"$f":"IF(AND($C$37>0,$C$41>0,$C$91<>\"\"),\"Stufe I\",\"\")","v":""},{"$nulls":3},"Ohne Ästung!",null,"Zusammenstellung"]
[]
[null,"Durchschnittserlös                                            [€ / fm]",{"$f":"IF(C143>0,$C$164/($C$129+$C$139+$C$149),$C$164/($C$129+$C$139))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(H143>0,$H$164/($H$129+$H$139+$H$149),$H$164/($H$129+$H$139))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(J143>0,$J$164/($J$129+$J$139+$J$149),$J$164/($J$129+$J$139))","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(N143>0,$N$164/($N$129+$N$139+$N$149),$N$164/($N$129+$N$139))","v":{"$error":"#VALUE!"}},"ZinsF/LS",{"$f":"$C$84","v":""},{"$f":"$J$82","v":2.5}]
[null,"Güte-Kl. A Erlös / Baum                                            [€]",{"$f":"IF($C$131=\"\",\"\",$C$131)","v":""},{"$nulls":4},{"$f":"IF($H$131=\"\",\"\",$H$131)","v":""},null,{"$f":"IF($J$131=\"\",\"\",$J$131)","v":""},{"$nulls":3},{"$f":"IF($N$131=\"\",\"\",$N$131)","v":""},{"$f":"$C$127","v":{"v":0,"d":"0 €"}},{"$f":"$C$123&\"/  \"&$H$123&\" /  \"&$J$123&\" /\"&$N$123&\"m\"","v":"0/  0 /  0 /0m"},{"$f":"$D$123","v":"A"}]
[]
[null,"             B Erlös / Baum                                            [€]",{"$f":"IF($C$141=\"\",\"\",$C$141)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF($H$141=\"\",\"\",$H$141)","v":{"$error":"#VALUE!"}},null,{"$f":"IF($J$141=\"\",\"\",$J$141)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF($N$141=\"\",\"\",$N$141)","v":{"$error":"#VALUE!"}},{"$f":"$C$137","v":{"v":0,"d":"0 €"}},{"$f":"$C$133&\"/ \"&$H$133&\" / \"&$J$133&\" /\"&$N$133&\"m\"","v":"/ 0 / 0 /0m"},{"$f":"$D$133","v":"B"}]
[]
[null,"             C Erlös / Baum                                            [€]",{"$f":"IF($C$151=\"\",\"\",$C$151)","v":""},{"$nulls":4},{"$f":"IF($H$151=\"\",\"\",$H$151)","v":""},null,{"$f":"IF($J$151=\"\",\"\",$J$151)","v":""},{"$nulls":3},{"$f":"IF($N$151=\"\",\"\",$N$151)","v":""},{"$f":"$C$147","v":{"v":0,"d":"0 €"}},{"$f":"$C$143&\" /  \"&$H$143&\"  /  \"&$J$143&\"  /\"&$N$143&\"m\"","v":" /  0  /  0  /0m"},{"$f":"$D$143","v":"C"}]
[]
[null,"Gesamterlös / Baum                                     [€ / Baum]",{"$f":"IF(AND($C$158=\"\",$C$160=\"\",$C$162=\"\"),\"\",SUM($C$158,$C$160,$C$162))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(AND($H$158=\"\",$H$160=\"\",$H$162=\"\"),\"\",SUM($H$158,$H$160,$H$162))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND($J$158=\"\",$J$160=\"\",$J$162=\"\"),\"\",SUM($J$158,$J$160,$J$162))","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(AND($N$158=\"\",$N$160=\"\",$N$162=\"\"),\"\",SUM($N$158,$N$160,$N$162))","v":{"$error":"#VALUE!"}},"Bäume",{"$f":"$P$41&\" / \"&$J$41&\" / \"&$C$41&\" / \"&\"0St.\"","v":" /  /  / 0St."},{"$f":"$C$115","v":0}]
[]
[null,"Ertragswert (Mehrerlös: Baum geästet zu ungeastet)    [€ / Baum]",{"$f":"IF(OR($C$164=\"\",$N$164=\"\"),\"\",$C$164-$N$164)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$164=\"\",$N$164=\"\"),\"\",$H$164-$N$164)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($N$164=\"\",$J$164=\"\"),\"\",$J$164-$N$164)","v":{"$error":"#VALUE!"}},null,null,"Arbeitskraft / h",null,{"$f":"$C$66","v":{"v":0,"d":"0.00 €"}},{"$f":"$N$70&\"/  \"&$H$70&\" /  \"&$C$70& \" /0\"","v":"/   /   /0"},"GAZ"]
[]
[null,"abzgl. Ästungsaufwand (aufgezinst bis Alter U)      [€ / Baum]",{"$f":"IF(OR($N$111=\"\",$C$115=\"\",$C$115=0),\"\",$N$111/$C$115)","v":""},{"$nulls":4},{"$f":"IF(OR($H$111=\"\",$C$115=\"\",$C$115=0),\"\",$H$111/$C$115)","v":""},null,{"$f":"IF(OR($C$111=\"\",$C$115=\"\",$C$115=0),\"\",$C$111/$C$115)","v":""},null,null,"Rm /astfr.Schicht",null,{"$f":"$C$125/2","v":{"$error":"#VALUE!"}},{"$f":"IF(OR($C$19=\"\",$C$19=0,$O$23=\"\",$O$23=0),\"\",$O$168-(($C$19+$C$21)-($C$123/2)*$C$21)/2)","v":""},"cm"]
[]
[null,"= Mehrertrag je geästeter Erntebaum (netto)  [€ / Baum]",{"$f":"IF(OR($C$166=\"\",$C$168=\"\"),\"\",$C$166-$C$168)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$166=\"\",$H$168=\"\"),\"\",$H$166-$H$168)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$166=\"\",$J$168=\"\"),\"\",$J$166-$J$168)","v":{"$error":"#VALUE!"}},null,null,"Vol.: astig/astfr.",null,{"$f":"IF(OR($C$123=\"\",$O$168=\"\",$P$168=\"\"),\"\",(($O$168-$P$168)/100*($O$168-$P$168)/100)*3.14159*$C$123)","v":{"$error":"#VALUE!"}},{"$f":"$C$129-$O$170","v":{"$error":"#VALUE!"}},"fm"]
[]
[null,"Rentabilität aller Maßnahme(n) bis Stufe ...     [Faktor]",{"$f":"IF(OR($C$168=\"\",$C$170=\"\"),\"\",$C$170/$C$168)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$168=\"\",$H$170=\"\"),\"\",$H$170/$H$168)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$168=\"\",$J$170=\"\"),\"\",$J$170/$J$168)","v":{"$error":"#VALUE!"}},null,null," Vol.-%: \" \" / \" \"",null,{"$f":"$O$170/$C$129*100","v":{"$error":"#VALUE!"}},{"$f":"$P$170/$C$129*100","v":{"$error":"#VALUE!"}},"V%"]
[]
[null,"Grenzertrag der Ästungs-Stufe ...                   [€ / Baum]",{"$f":"IF(OR($C$170=\"\",$H$170=\"\"),\"\",$C$170-$H$170)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$170=\"\",$J$170=\"\"),\"\",$H$170-$J$170)","v":{"$error":"#VALUE!"}},null,{"$f":"$J$170","v":{"$error":"#VALUE!"}},null,null,"Kosten: lfm / fm",null,{"$f":"IF(OR($C$123=\"\",$C$168=\"\"),\"\",$C$168/$C$123)","v":""},{"$f":"IF(AND($C$129>0,$C$168>0),$C$168/$C$129,\"\")","v":{"$error":"#VALUE!"}},"€"]
[]
[null,"Rentabilität der Einzelmaßnahme: Stufe...       [Faktor]",{"$f":"IF(OR($C$168=\"\",$C$170=\"\"),\"\",$C$174/($C$168-$H$168))","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(OR($H$168=\"\",$H$170=\"\"),\"\",$H$174/($H$168-$J$168))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR($J$168=\"\",$J$170=\"\"),\"\",$J$174/$J$168)","v":{"$error":"#VALUE!"}},null,null,"d1,3/astfr.Schicht",null,{"$f":"$O$23","v":{"v":0,"d":"0.0"}},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",($O$23-$C$19)/2))","v":""},"cm"]
[]
[]
[]
[null,"IV-1. Zu erwartende Sortierung und erzielbare Erlöse"]
[null,"IV-1 A1. Variante 3 mit Wertästung (nur Maßnahme 1)"]
[null,"GKl. A Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. A  Durchmesser o. R. [cm]",{"v":76,"d":"76.0"}]
[]
[null,"GKl. A Preis [€/Efm o. R.]",{"v":200,"d":"200.00 €"}]
[]
[null,"GKl. A Masse [Efm o. R.]",{"$f":"IF(OR($C$182=\"\",$C$184=\"\"),\"\",($C$184/100*$C$184/100)/4*3.14159*$C$182)","v":{"v":2.26822798,"d":"2.27"}}]
[]
[null,"GKl. A Erlös [€]",{"$f":"IF(OR($C$186=\"\",$C$188=\"\"),\"\",$C$186*$C$188)","v":{"v":453.64559599999995,"d":"453.65 €"}}]
[]
[null,"GKl. B Länge [m]",{"v":22,"d":"22.0"}]
[]
[null,"GKl. B  Durchmesser o. R. [cm]",{"v":60,"d":"60.0"}]
[]
[null,"GKl. B Preis [ €/ Efm o. R.]",{"v":96,"d":"96.00 €"}]
[]
[null,"GKl. B Masse [Efm o. R.]",{"$f":"IF(OR($C$192=\"\",$C$194=\"\"),\"\",($C$194/100*$C$194/100)/4*3.14159*$C$192)","v":{"v":6.220348199999999,"d":"6.22"}}]
[]
[null,"GKl. B Erlös [€]",{"$f":"IF(OR($C$196=\"\",$C$198=\"\"),\"\",$C$196*$C$198)","v":{"v":597.1534271999999,"d":"597.15 €"}}]
[]
[null,"GKl. C Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. C  Durchmesser o. R. [cm]",{"v":39,"d":"39.0"}]
[]
[null,"GKl. C Preis [€/Efm o. R.]",{"v":81.6,"d":"81.60 €"}]
[]
[null,"GKl. C Masse [Efm o. R.]",{"$f":"IF(OR($C$202=\"\",$C$204=\"\"),\"\",($C$204/100*$C$204/100)/4*3.14159*$C$202)","v":{"v":0.59729479875,"d":"0.60"}}]
[]
[null,"GKl. C Erlös [€]",{"$f":"IF(OR($C$206=\"\",$C$208=\"\"),\"\",$C$206*$C$208)","v":{"v":48.739255578,"d":"48.74 €"}}]
[]
[null,"Programmerstellung:"]
[]
[null,"K.-H. Schmitz; LB WuH NRW; LuVFA Arnsberger Wald -SPA Waldbau-"]
[]
[null,"Bemerkung"]
{"$rows_empty":21}
[null,"Platz für Anfügungen des Anwenders:"]

{"sheet":"IKW_II_Ansicht","index":3,"n_rows":238,"n_cols":17,"rows_kept":238,"merged":[[0,6,0,9],[0,10,0,12],[2,6,2,13],[4,6,4,12],[20,13,20,14],[27,3,27,4],[30,1,30,2],[30,7,30,9],[30,13,30,15],[46,1,46,2],[46,7,46,9],[46,13,46,15],[48,1,48,2],[48,7,48,9],[48,13,48,15],[52,1,52,2],[52,7,52,9],[52,13,52,15],[56,1,56,2],[56,7,56,9],[56,13,56,15],[216,1,234,17]]}
[null,"W     e     r     t     ä     s     t     u     n     g","Lokalität >",null,null,"Besitz",{"$f":"IF(IKW_II_Eingabe!G1=\"\",\"\",IKW_II_Eingabe!G1)","v":""},{"$f":"IF(IKW_I_Eingabe!H1=\"\",\"\",IKW_I_Eingabe!H1)","v":""},{"$f":"IF(IKW_I_Eingabe!I1=\"\",\"\",IKW_I_Eingabe!I1)","v":""},{"$f":"IF(IKW_I_Eingabe!J1=\"\",\"\",IKW_I_Eingabe!J1)","v":""},"RFA",null,null,{"$f":"IF(IKW_II_Eingabe!N1=\"\",\"\",IKW_II_Eingabe!N1)","v":""},"Abt.",{"$f":"IF(IKW_II_Eingabe!P1=\"\",\"\",IKW_II_Eingabe!P1)","v":""}]
[]
[null,"I n v e s t i t i o n s k a l k u l a t i o n","vom","Adresse",null,null,{"$f":"IF(IKW_II_Eingabe!G3=\"\",\"\",IKW_II_Eingabe!G3)","v":""},{"$f":"IF(IKW_I_Eingabe!H3=\"\",\"\",IKW_I_Eingabe!H3)","v":""},{"$f":"IF(IKW_I_Eingabe!I3=\"\",\"\",IKW_I_Eingabe!I3)","v":""},{"$f":"IF(IKW_I_Eingabe!J3=\"\",\"\",IKW_I_Eingabe!J3)","v":""},{"$f":"IF(IKW_I_Eingabe!K3=\"\",\"\",IKW_I_Eingabe!K3)","v":""},{"$f":"IF(IKW_I_Eingabe!L3=\"\",\"\",IKW_I_Eingabe!L3)","v":""},{"$f":"IF(IKW_I_Eingabe!M3=\"\",\"\",IKW_I_Eingabe!M3)","v":""},{"$f":"IF(IKW_I_Eingabe!N3=\"\",\"\",IKW_I_Eingabe!N3)","v":""},"GK-RW",{"$f":"IF(IKW_II_Eingabe!P3=\"\",\"\",IKW_II_Eingabe!P3)","v":""}]
[]
[null,"Erst.:FAR Schmitz, LB Wald u. Holz NRW; LVFA Arnsberger Wald",{"$f":"IF(IKW_II_Eingabe!C5=\"\",\"\",IKW_II_Eingabe!C5)","v":"2014-01-07"},"Resultat",null,null,{"$f":"IF(IKW_II_Eingabe!G5=\"\",\"\",IKW_II_Eingabe!G5)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_I_Eingabe!H5=\"\",\"\",IKW_I_Eingabe!H5)","v":""},{"$f":"IF(IKW_I_Eingabe!I5=\"\",\"\",IKW_I_Eingabe!I5)","v":""},{"$f":"IF(IKW_I_Eingabe!J5=\"\",\"\",IKW_I_Eingabe!J5)","v":""},{"$f":"IF(IKW_I_Eingabe!K5=\"\",\"\",IKW_I_Eingabe!K5)","v":""},{"$f":"IF(IKW_I_Eingabe!L5=\"\",\"\",IKW_I_Eingabe!L5)","v":""},{"$f":"IF(IKW_I_Eingabe!M5=\"\",\"\",IKW_I_Eingabe!M5)","v":""},{"$f":"IF(IKW_II_Eingabe!N5=\"\",\"\",IKW_II_Eingabe!N5)","v":{"$error":"#VALUE!"}},"GK-HW",{"$f":"IF(IKW_II_Eingabe!P5=\"\",\"\",IKW_II_Eingabe!P5)","v":""}]
[]
[null,"I. Bestand"]
[]
[null,"I A. Ist-Daten",{"$nulls":4},"I B. Soll-Daten"]
[]
[null,"Bestand                                                         [Baumart]",{"$f":"IF(IKW_II_Eingabe!C11=\"\",\"\",IKW_II_Eingabe!C11)","v":""},{"$nulls":3},"erwarteter BHD (d1,3) o. R. im Alter U                            [cm]",{"$nulls":8},{"$f":"IF(IKW_II_Eingabe!P11=\"\",\"\",IKW_II_Eingabe!P11)","v":""},"!"]
[]
[null,"Ertragsklasse                                                        [EKl.]",{"$f":"IF(IKW_II_Eingabe!C13=\"\",\"\",IKW_II_Eingabe!C13)","v":""},{"$nulls":3},"jährlicher BHD-Zuwachs bis Alter U                                [cm]",{"$nulls":8},{"$f":"IF(IKW_II_Eingabe!P13=\"\",\"\",IKW_II_Eingabe!P13)","v":""},"!"]
[]
[null,"Bestandesbegründung                                           [Jahr]",{"$f":"IF(IKW_II_Eingabe!C15=\"\",\"\",IKW_II_Eingabe!C15)","v":""},null,"!",null,"verbleibender Zeitraum bis Alter U                               [Jahre]",{"$nulls":8},{"$f":"IF(IKW_II_Eingabe!P15=\"\",\"\",IKW_II_Eingabe!P15)","v":""}]
[]
[null,"Aktuelle Bestandesaufnahme                                 [Jahr]",{"$f":"IF(IKW_II_Eingabe!C17=\"\",\"\",IKW_II_Eingabe!C17)","v":""},null,"!",null,"Resultierende Umtriebszeit                                        [Jahre]",{"$nulls":8},{"$f":"IF(IKW_II_Eingabe!P17=\"\",\"\",IKW_II_Eingabe!P17)","v":""}]
[]
[null,"aktueller BHD der zu ästenden Bäume o. R.             [cm]",{"$f":"IF(IKW_II_Eingabe!C19=\"\",\"\",IKW_II_Eingabe!C19)","v":""},null,"!",null,"entspricht Kalenderjahr im Alter U                                [Jahr]",{"$nulls":8},{"$f":"IF(IKW_II_Eingabe!P19=\"\",\"\",IKW_II_Eingabe!P19)","v":""}]
[]
[null,"Abholzigkeit Güteklasse A (Durchmesser-Abnahme)[cm / lfdm]",{"$f":"IF(IKW_II_Eingabe!C21=\"\",\"\",IKW_II_Eingabe!C21)","v":""},null,"!",null,"Ggf. abweichende Umtriebszeit         [U]",{"$nulls":6},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",\"\"))","v":""},null,{"$f":"IF(IKW_II_Eingabe!P21=\"\",\"\",IKW_II_Eingabe!P21)","v":""}]
[]
[null,"Abholzigkeit Güteklasse B (GKl. C =  AbhzkB+1cm)  [cm / lfdm]",{"$f":"IF(IKW_II_Eingabe!C23=\"\",\"\",IKW_II_Eingabe!C23)","v":""},null,"!",null,"= astfreie Schicht [cm]  /  BHD [cm]   /  Jahr",{"$nulls":6},{"$f":"IF(IKW_II_Eingabe!N23=\"\",\"\",IKW_II_Eingabe!N23)","v":{"v":0,"d":"0.00"}},{"$f":"IF(IKW_II_Eingabe!O23=\"\",\"\",IKW_II_Eingabe!O23)","v":{"v":0,"d":"0.0"}},{"$f":"IF(IKW_II_Eingabe!P23=\"\",\"\",IKW_II_Eingabe!P23)","v":""}]
[]
[]
[]
[]
[null,"II. Maßnahme","Stufe I",{"$f":"IF(IKW_II_Eingabe!D28=\"\",\"\",IKW_II_Eingabe!D28)","v":""},{"$f":"IF(IKW_I_Eingabe!E28=\"\",\"\",IKW_I_Eingabe!E28)","v":{"v":0,"d":"0.0"}},null,null,"Stufe II",{"$f":"IF(IKW_II_Eingabe!I28=\"\",\"\",IKW_II_Eingabe!I28)","v":""},{"$f":"IF($I$28<>\"\",\"cm\",\"\")","v":""},{"$nulls":3},"Stufe III",{"$f":"IF(IKW_II_Eingabe!O28=\"\",\"\",IKW_II_Eingabe!O28)","v":""},{"$f":"IF(IKW_II_Eingabe!P28=\"\",\"\",IKW_II_Eingabe!P28)","v":""}]
[]
[]
[]
[]
[null,"Maßnahme-Ausführung                                         [Jahr]",{"$f":"IF(IKW_II_Eingabe!C33=\"\",\"\",IKW_II_Eingabe!C33)","v":""},null,"!",null,null,{"$f":"IF(IKW_II_Eingabe!H33=\"\",\"\",IKW_II_Eingabe!H33)","v":""},"(!)",{"$f":"IF(IKW_II_Eingabe!J33=\"\",\"\",IKW_II_Eingabe!J33)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N33=\"\",\"\",IKW_II_Eingabe!N33)","v":""},"(!)",{"$f":"IF(IKW_II_Eingabe!P33=\"\",\"\",IKW_II_Eingabe!P33)","v":""}]
[]
[null,"Ästungshöhe von ...                                                 [m]",{"$f":"IF(IKW_II_Eingabe!C35=\"\",\"\",IKW_II_Eingabe!C35)","v":{"v":0,"d":"0.0"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H35=\"\",\"\",IKW_II_Eingabe!H35)","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N35=\"\",\"\",IKW_II_Eingabe!N35)","v":{"v":0,"d":"0.0"}}]
[]
[null,"Ästungshöhe bis ...                                                  [m]",{"$f":"IF(IKW_II_Eingabe!C37=\"\",\"\",IKW_II_Eingabe!C37)","v":""},null,"!",null,null,{"$f":"IF(IKW_II_Eingabe!H37=\"\",\"\",IKW_II_Eingabe!H37)","v":""},"!",{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"<=W e r t ?\",\"\")","v":"<=W e r t ?"},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N37=\"\",\"\",IKW_II_Eingabe!N37)","v":""},"!",{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"<=W e r t ?\",\"\")","v":"<=W e r t ?"}]
[]
[null,"Baumabstand: (Optimale Verteilung; 3-Eckverband)                [m]",{"$f":"IF(IKW_II_Eingabe!C39=\"\",\"\",IKW_II_Eingabe!C39)","v":""},{"$nulls":3},"[n]",{"$f":"IF(IKW_II_Eingabe!H39=\"\",\"\",IKW_II_Eingabe!H39)","v":{"$error":"#DIV/0!"}},"(errechn. Anzahl /ha)",{"$nulls":3},"[n]",{"$f":"IF(IKW_II_Eingabe!N39=\"\",\"\",IKW_II_Eingabe!N39)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Anzahl zu ästender Bäume je ha                     [Stück / ha]",{"$f":"IF(IKW_II_Eingabe!C41=\"\",\"\",IKW_II_Eingabe!C41)","v":""},null,"!",null,null,{"$f":"IF(IKW_II_Eingabe!H41=\"\",\"\",IKW_II_Eingabe!H41)","v":""},"(!)",{"$f":"IF(IKW_II_Eingabe!J41=\"\",\"\",IKW_II_Eingabe!J41)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N41=\"\",\"\",IKW_II_Eingabe!N41)","v":""},"(!)",{"$f":"IF(IKW_II_Eingabe!P41=\"\",\"\",IKW_II_Eingabe!P41)","v":""}]
[]
[null,"Maßnahmefläche                                                    [ha]"]
[]
[null,"Beschreibung:[Maschineneinsatz  /  Werkzeug  /  Verfahren] "]
[]
[]
[]
[]
[]
[null,"Ggf. Behandlungsmittel [Produktbezeichng] / [Menge/Baum]",{"$f":"IF(IKW_II_Eingabe!C51=\"\",\"\",IKW_II_Eingabe!C51)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H51=\"\",\"\",IKW_II_Eingabe!H51)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N51=\"\",\"\",IKW_II_Eingabe!N51)","v":""}]
[]
[]
[]
[null,"Dokumentation der Realisierung: [Jahr]/[Bemerkung]"]
[]
[]
[]
[]
[]
[null,"III. Kosten"]
[null,"III A. Basisdaten","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Alternative 1: Entgelt / lfdm (aktuellerWert/Folgejahre) [€ / lfdm]",{"$f":"IF(IKW_II_Eingabe!C64=\"\",\"\",IKW_II_Eingabe!C64)","v":""},null,"[!]",null,null,{"$f":"IF(IKW_II_Eingabe!H64=\"\",\"\",IKW_II_Eingabe!H64)","v":""},"[!]",{"$f":"IF(IKW_II_Eingabe!J64=\"\",\"\",IKW_II_Eingabe!J64)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N64=\"\",\"\",IKW_II_Eingabe!N64)","v":""},"[!]",{"$f":"IF(IKW_II_Eingabe!P64=\"\",\"\",IKW_II_Eingabe!P64)","v":""}]
[]
[null,"\"\" 2: Stundenlohn (Folgejahre: Lohn x Steigerungsfaktor [LSF]) [€/h]",{"$f":"IF(IKW_II_Eingabe!C66=\"\",\"\",IKW_II_Eingabe!C66)","v":""},null,"!",null,null,{"$f":"IF(IKW_II_Eingabe!H66=\"\",\"\",IKW_II_Eingabe!H66)","v":""},"in Jahren",{"$f":"IF(IKW_II_Eingabe!J66=\"\",\"\",IKW_II_Eingabe!J66)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N66=\"\",\"\",IKW_II_Eingabe!N66)","v":""},"in Jahren",{"$f":"IF(IKW_II_Eingabe!P66=\"\",\"\",IKW_II_Eingabe!P66)","v":""}]
[]
[null,"Erschwerniszuschlag   (ggf. Baumbesteigung)                            [%]",{"$f":"IF(IKW_II_Eingabe!C68=\"\",\"\",IKW_II_Eingabe!C68)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H68=\"\",\"\",IKW_II_Eingabe!H68)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N68=\"\",\"\",IKW_II_Eingabe!N68)","v":""}]
[]
[null,"Zeitvorgabe Arbeitskraft (GAZ)                       [min. / Baum]",{"$f":"IF(IKW_II_Eingabe!C70=\"\",\"\",IKW_II_Eingabe!C70)","v":""},{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":"H?"},"!",null,null,{"$f":"IF(IKW_II_Eingabe!H70=\"\",\"\",IKW_II_Eingabe!H70)","v":""},"(!)",{"$f":"IF(IKW_II_Eingabe!J70=\"\",\"\",IKW_II_Eingabe!J70)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N70=\"\",\"\",IKW_II_Eingabe!N70)","v":""},"(!)",{"$f":"IF(IKW_II_Eingabe!P70=\"\",\"\",IKW_II_Eingabe!P70)","v":""}]
[]
[null,"Verwaltungskostenzuschlag / Dokumentationskosten   [%]",{"$f":"IF(IKW_II_Eingabe!C72=\"\",\"\",IKW_II_Eingabe!C72)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H72=\"\",\"\",IKW_II_Eingabe!H72)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J72=\"\",\"\",IKW_II_Eingabe!J72)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N72=\"\",\"\",IKW_II_Eingabe!N72)","v":""},null,{"$f":"IF(IKW_II_Eingabe!P72=\"\",\"\",IKW_II_Eingabe!P72)","v":""}]
[]
[null,"Maschineneinsatz                                             [€ / MAS]",{"$f":"IF(IKW_II_Eingabe!C74=\"\",\"\",IKW_II_Eingabe!C74)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H74=\"\",\"\",IKW_II_Eingabe!H74)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N74=\"\",\"\",IKW_II_Eingabe!N74)","v":""}]
[]
[null,"Zeitvorgabe Maschineneinsatz (MAS)           [min. / Baum]",{"$f":"IF(IKW_II_Eingabe!C76=\"\",\"\",IKW_II_Eingabe!C76)","v":""},{"$f":"IF(AND(OR($C$70>0,$C$76>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":"H?"},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!H76=\"\",\"\",IKW_II_Eingabe!H76)","v":""},null,{"$f":"IF(AND(OR($H$70>0,$H$76>0,),OR($H$37=\"\",$H$37=0)),\"Ästg.-Höhe?\",\"\")","v":"Ästg.-Höhe?"},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N76=\"\",\"\",IKW_II_Eingabe!N76)","v":""},null,{"$f":"IF(AND(OR($N$70>0,$N$76>0,),OR($N$37=\"\",$N$37=0)),\"Ästg.-Höhe?\",\"\")","v":"Ästg.-Höhe?"}]
[]
[null,"Werkzeug (Entschädigung / Abnutzung)                         [€ / h]",{"$f":"IF(IKW_II_Eingabe!C78=\"\",\"\",IKW_II_Eingabe!C78)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H78=\"\",\"\",IKW_II_Eingabe!H78)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N78=\"\",\"\",IKW_II_Eingabe!N78)","v":""}]
[]
[null,"Behandlungsmittel                                         [€ / Einheit]",{"$f":"IF(IKW_II_Eingabe!C80=\"\",\"\",IKW_II_Eingabe!C80)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H80=\"\",\"\",IKW_II_Eingabe!H80)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N80=\"\",\"\",IKW_II_Eingabe!N80)","v":""}]
[]
[null,"Zinssatz für Aufzinsung der Investitionskosten (p)      [%]",{"$f":"IF(IKW_II_Eingabe!C82=\"\",\"\",IKW_II_Eingabe!C82)","v":{"v":3,"d":"3.00"}},null,"!",null,null,"Lohnsteigerung [%]",null,{"$f":"IF(IKW_II_Eingabe!J82=\"\",\"\",IKW_II_Eingabe!J82)","v":{"v":2.5,"d":"2.50"}},"!",null,null,"Lohnsteigerung (p) [% / a]",null,{"$f":"IF(IKW_II_Eingabe!P82=\"\",\"\",IKW_II_Eingabe!P82)","v":{"v":2.5,"d":"2.50"}}]
[]
[null,"Aufzinsungsfaktor (Askontierung; p = % Zinsen)           [(1+p)n]",{"$f":"IF(IKW_II_Eingabe!C84=\"\",\"\",IKW_II_Eingabe!C84)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H84=\"\",\"\",IKW_II_Eingabe!H84)","v":""},"[LSF]",{"$f":"IF(IKW_II_Eingabe!J84=\"\",\"\",IKW_II_Eingabe!J84)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N84=\"\",\"\",IKW_II_Eingabe!N84)","v":""},"[LSF]",{"$f":"IF(IKW_II_Eingabe!P84=\"\",\"\",IKW_II_Eingabe!P84)","v":""}]
[]
[null,"Aufzinsungs-Zeitraum bis Alter U  (n)                   [Jahre]",{"$f":"IF(IKW_II_Eingabe!C86=\"\",\"\",IKW_II_Eingabe!C86)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H86=\"\",\"\",IKW_II_Eingabe!H86)","v":""},"zu  [%]",{"$f":"IF(IKW_II_Eingabe!J86=\"\",\"\",IKW_II_Eingabe!J86)","v":{"v":3,"d":"3.00"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N86=\"\",\"\",IKW_II_Eingabe!N86)","v":""},"zu  [%]",{"$f":"IF(IKW_II_Eingabe!P86=\"\",\"\",IKW_II_Eingabe!P86)","v":{"v":3,"d":"3.00"}}]
[]
[]
[null,"III B. Kalkulation der Maßnahme","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Reine Arbeitskosten                                        [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C91=\"\",\"\",IKW_II_Eingabe!C91)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H91=\"\",\"\",IKW_II_Eingabe!H91)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N91=\"\",\"\",IKW_II_Eingabe!N91)","v":""}]
[]
[null,"Verwaltungskosten / Dokumentation                 [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C93=\"\",\"\",IKW_II_Eingabe!C93)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H93=\"\",\"\",IKW_II_Eingabe!H93)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N93=\"\",\"\",IKW_II_Eingabe!N93)","v":""}]
[]
[null,"Maschineneinsatz                                           [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C95=\"\",\"\",IKW_II_Eingabe!C95)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H95=\"\",\"\",IKW_II_Eingabe!H95)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N95=\"\",\"\",IKW_II_Eingabe!N95)","v":""}]
[]
[null,"Werkzeug                                                      [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C97=\"\",\"\",IKW_II_Eingabe!C97)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H97=\"\",\"\",IKW_II_Eingabe!H97)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N97=\"\",\"\",IKW_II_Eingabe!N97)","v":""}]
[]
[null,"Behandlungsmittel                                          [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C99=\"\",\"\",IKW_II_Eingabe!C99)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H99=\"\",\"\",IKW_II_Eingabe!H99)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N99=\"\",\"\",IKW_II_Eingabe!N99)","v":""}]
[]
[null,"Maßnahme insgesamt (unverzinst)                  [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C101=\"\",\"\",IKW_II_Eingabe!C101)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H101=\"\",\"\",IKW_II_Eingabe!H101)","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N101=\"\",\"\",IKW_II_Eingabe!N101)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Maßnahme insgesamt (unverzinst)                        [€ / ha]",{"$f":"IF(IKW_II_Eingabe!C103=\"\",\"\",IKW_II_Eingabe!C103)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H103=\"\",\"\",IKW_II_Eingabe!H103)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N103=\"\",\"\",IKW_II_Eingabe!N103)","v":""}]
[]
[null,"Zinskosten bis Alter U                                     [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C105=\"\",\"\",IKW_II_Eingabe!C105)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H105=\"\",\"\",IKW_II_Eingabe!H105)","v":""},{"$nulls":5},{"$f":"IF(IKW_II_Eingabe!N105=\"\",\"\",IKW_II_Eingabe!N105)","v":""}]
[]
[null,"Maßnahme 1 insgesamt (aufgezinst bis Alter U) [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C107=\"\",\"\",IKW_II_Eingabe!C107)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H107=\"\",\"\",IKW_II_Eingabe!H107)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 2)",{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N107=\"\",\"\",IKW_II_Eingabe!N107)","v":{"v":0,"d":"0.00 €"}},null,"(nur Maßnahme 3)"]
[]
[null,"Maßnahme insgesamt (aufgezinst bis Alter U)         [€ / ha]",{"$f":"IF(IKW_II_Eingabe!C109=\"\",\"\",IKW_II_Eingabe!C109)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H109=\"\",\"\",IKW_II_Eingabe!H109)","v":""},null,"\"\"        \"\"",{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N109=\"\",\"\",IKW_II_Eingabe!N109)","v":""},null,"\"\"          \"\""]
[null,"III C. Gesamtkalkulation","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[null,"Gesamtkosten je ha (aufgezinst bis Alter U)               [€ / ha]",{"$f":"IF(IKW_II_Eingabe!C111=\"\",\"\",IKW_II_Eingabe!C111)","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H111=\"\",\"\",IKW_II_Eingabe!H111)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N111=\"\",\"\",IKW_II_Eingabe!N111)","v":{"v":0,"d":"0.00 €"}},null,"(insgesamt bis Stufe III)"]
[]
[null,"Erwarteter Anteil geästeter Bäume mit Wertholz         [%]",{"$f":"IF(IKW_II_Eingabe!C113=\"\",\"\",IKW_II_Eingabe!C113)","v":{"v":75,"d":"75.0"}},null,"!"]
[]
[null,"Erwartete Anzahl geästeter Bäume / ha mit Wertholz  [St.]",{"$f":"IF(IKW_II_Eingabe!C115=\"\",\"\",IKW_II_Eingabe!C115)","v":0}]
[]
[null,"Umlegung der Kosten je ha auf die erwartete Anzahl geästeter"]
[null,"Bäume mit Wertholzanteil (aufgezinst bis Alter U)    [€ /Baum]",{"$f":"IF(IKW_II_Eingabe!C118=\"\",\"\",IKW_II_Eingabe!C118)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H118=\"\",\"\",IKW_II_Eingabe!H118)","v":""},null,"(insgesamt bis Stufe II)",{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N118=\"\",\"\",IKW_II_Eingabe!N118)","v":""},null,"(insgesamt bis Stufe III)"]
[null,{"$f":"\"Diesen Betrag muß jeder der erwarteten \" &C115&\" Erntebäume min. zusätzlich erbringen!\"","v":"Diesen Betrag muß jeder der erwarteten 0 Erntebäume min. zusätzlich erbringen!"}]
[]
[null,"IV. Zu erwartende Sortierung und erzielbare Erlöse",{"$f":"IF(IKW_II_Eingabe!C121=\"\",\"\",IKW_II_Eingabe!C121)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H121=\"\",\"\",IKW_II_Eingabe!H121)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J121=\"\",\"\",IKW_II_Eingabe!J121)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N121=\"\",\"\",IKW_II_Eingabe!N121)","v":"Ohne"},"W   e   r   t   ä   s   t   u   n   g"]
[null,{"$f":"IF(IKW_II_Eingabe!B122=\"\",\"\",IKW_II_Eingabe!B122)","v":"fm / Baum"},{"$f":"IF(IKW_II_Eingabe!C122=\"\",\"\",IKW_II_Eingabe!C122)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H122=\"\",\"\",IKW_II_Eingabe!H122)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J122=\"\",\"\",IKW_II_Eingabe!J122)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N122=\"\",\"\",IKW_II_Eingabe!N122)","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,(($N$122-$C$122)/$C$122)*100,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF((($N$122-$C$122)/$C$122)*100>2,\"% Vol.-Diff.\",\"\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(IKW_II_Eingabe!B123=\"\",\"\",IKW_II_Eingabe!B123)","v":"Güte-Kl. A Länge                                      [m]"},{"$f":"IF(IKW_II_Eingabe!C123=\"\",\"\",IKW_II_Eingabe!C123)","v":{"v":0,"d":"0.0"}},"A",{"$f":"IF(AND($H$121=$C$121,$H$168<>$C$168),\"??\",\"\")","v":""},null,null,{"$f":"IF(IKW_II_Eingabe!H123=\"\",\"\",IKW_II_Eingabe!H123)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(IKW_II_Eingabe!J123=\"\",\"\",IKW_II_Eingabe!J123)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N123=\"\",\"\",IKW_II_Eingabe!N123)","v":{"v":0,"d":"0.0"}},null,"Abkürzg.-Verz."]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(IKW_II_Eingabe!C125=\"\",\"\",IKW_II_Eingabe!C125)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H125=\"\",\"\",IKW_II_Eingabe!H125)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J125=\"\",\"\",IKW_II_Eingabe!J125)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N125=\"\",\"\",IKW_II_Eingabe!N125)","v":""},null,"GAZ"]
[]
[null,"                 Geästetes Holz (Wertholz-Stück)     [€ / Efm o. R.]",{"$f":"IF(IKW_II_Eingabe!C127=\"\",\"\",IKW_II_Eingabe!C127)","v":""},null,"!",null,null,{"$f":"IF(IKW_II_Eingabe!H127=\"\",\"\",IKW_II_Eingabe!H127)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(IKW_II_Eingabe!J127=\"\",\"\",IKW_II_Eingabe!J127)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N127=\"\",\"\",IKW_II_Eingabe!N127)","v":{"v":0,"d":"0.00 €"}},null,"Gesamt-Ar-"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(IKW_II_Eingabe!C129=\"\",\"\",IKW_II_Eingabe!C129)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H129=\"\",\"\",IKW_II_Eingabe!H129)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J129=\"\",\"\",IKW_II_Eingabe!J129)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N129=\"\",\"\",IKW_II_Eingabe!N129)","v":""},null,"beits-Zeit für"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(IKW_II_Eingabe!C131=\"\",\"\",IKW_II_Eingabe!C131)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H131=\"\",\"\",IKW_II_Eingabe!H131)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J131=\"\",\"\",IKW_II_Eingabe!J131)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N131=\"\",\"\",IKW_II_Eingabe!N131)","v":""},null,"Ästungs-Stufe"]
[]
[null,{"$f":"IF(IKW_II_Eingabe!B133=\"\",\"\",IKW_II_Eingabe!B133)","v":"Güte-Kl. B Länge (Restlänge vor C-Stück)  [m]"},{"$f":"IF(IKW_II_Eingabe!C133=\"\",\"\",IKW_II_Eingabe!C133)","v":""},"B",{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!H133=\"\",\"\",IKW_II_Eingabe!H133)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(IKW_II_Eingabe!J133=\"\",\"\",IKW_II_Eingabe!J133)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N133=\"\",\"\",IKW_II_Eingabe!N133)","v":{"v":0,"d":"0.0"}},null,"I-III in Minuten"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(IKW_II_Eingabe!C135=\"\",\"\",IKW_II_Eingabe!C135)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H135=\"\",\"\",IKW_II_Eingabe!H135)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J135=\"\",\"\",IKW_II_Eingabe!J135)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N135=\"\",\"\",IKW_II_Eingabe!N135)","v":{"$error":"#VALUE!"}},null,"d1,3   (= BHD)"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"$f":"IF(IKW_II_Eingabe!C137=\"\",\"\",IKW_II_Eingabe!C137)","v":""},null,"!",null,null,{"$f":"IF(IKW_II_Eingabe!H137=\"\",\"\",IKW_II_Eingabe!H137)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(IKW_II_Eingabe!J137=\"\",\"\",IKW_II_Eingabe!J137)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N137=\"\",\"\",IKW_II_Eingabe!N137)","v":{"v":0,"d":"0.00 €"}},null,"Durchmesser"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(IKW_II_Eingabe!C139=\"\",\"\",IKW_II_Eingabe!C139)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H139=\"\",\"\",IKW_II_Eingabe!H139)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J139=\"\",\"\",IKW_II_Eingabe!J139)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N139=\"\",\"\",IKW_II_Eingabe!N139)","v":{"$error":"#VALUE!"}},null,"in 1,3m Höhe"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(IKW_II_Eingabe!C141=\"\",\"\",IKW_II_Eingabe!C141)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H141=\"\",\"\",IKW_II_Eingabe!H141)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J141=\"\",\"\",IKW_II_Eingabe!J141)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N141=\"\",\"\",IKW_II_Eingabe!N141)","v":{"$error":"#VALUE!"}},null,"Rm "]
[]
[null,{"$f":"IF(IKW_II_Eingabe!B143=\"\",\"\",IKW_II_Eingabe!B143)","v":"Güte-Kl. C Länge                                      [m]"},{"$f":"IF(IKW_II_Eingabe!C143=\"\",\"\",IKW_II_Eingabe!C143)","v":""},"C",{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!H143=\"\",\"\",IKW_II_Eingabe!H143)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(IKW_II_Eingabe!J143=\"\",\"\",IKW_II_Eingabe!J143)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N143=\"\",\"\",IKW_II_Eingabe!N143)","v":{"v":0,"d":"0.0"}},null,"Radius in der"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(IKW_II_Eingabe!C145=\"\",\"\",IKW_II_Eingabe!C145)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H145=\"\",\"\",IKW_II_Eingabe!H145)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J145=\"\",\"\",IKW_II_Eingabe!J145)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N145=\"\",\"\",IKW_II_Eingabe!N145)","v":""},null,"Mitte d. A-Stamm-"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"$f":"IF(IKW_II_Eingabe!C147=\"\",\"\",IKW_II_Eingabe!C147)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H147=\"\",\"\",IKW_II_Eingabe!H147)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(IKW_II_Eingabe!J147=\"\",\"\",IKW_II_Eingabe!J147)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N147=\"\",\"\",IKW_II_Eingabe!N147)","v":{"v":0,"d":"0.00 €"}},null,"(Werholz)-stückes"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(IKW_II_Eingabe!C149=\"\",\"\",IKW_II_Eingabe!C149)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H149=\"\",\"\",IKW_II_Eingabe!H149)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J149=\"\",\"\",IKW_II_Eingabe!J149)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N149=\"\",\"\",IKW_II_Eingabe!N149)","v":""},null,"lfm=lfd.Meter;fm=m³"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(IKW_II_Eingabe!C151=\"\",\"\",IKW_II_Eingabe!C151)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H151=\"\",\"\",IKW_II_Eingabe!H151)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J151=\"\",\"\",IKW_II_Eingabe!J151)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N151=\"\",\"\",IKW_II_Eingabe!N151)","v":""},null,"ZinF =Aufzinsg.=>U"]
[]
[]
[]
[null,"V. Wirtschaftlichkeit der Maßnahmen: Wertästung bis ",{"$f":"IF(IKW_II_Eingabe!C155=\"\",\"\",IKW_II_Eingabe!C155)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H155=\"\",\"\",IKW_II_Eingabe!H155)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J155=\"\",\"\",IKW_II_Eingabe!J155)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N155=\"\",\"\",IKW_II_Eingabe!N155)","v":"Ohne Ästung!"},null,"Zusammenstellung"]
[]
[null,"Durchschnittserlös                                            [€ / fm]",{"$f":"IF(IKW_II_Eingabe!C157=\"\",\"\",IKW_II_Eingabe!C157)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H157=\"\",\"\",IKW_II_Eingabe!H157)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J157=\"\",\"\",IKW_II_Eingabe!J157)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N157=\"\",\"\",IKW_II_Eingabe!N157)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!O157=\"\",\"\",IKW_II_Eingabe!O157)","v":"ZinsF/LS"},{"$f":"IF(IKW_II_Eingabe!P157=\"\",\"\",IKW_II_Eingabe!P157)","v":""},{"$f":"IF(IKW_II_Eingabe!Q157=\"\",\"\",IKW_II_Eingabe!Q157)","v":2.5}]
[null,"Güte-Kl. A Erlös / Baum                                            [€]",{"$f":"IF(IKW_II_Eingabe!C158=\"\",\"\",IKW_II_Eingabe!C158)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H158=\"\",\"\",IKW_II_Eingabe!H158)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J158=\"\",\"\",IKW_II_Eingabe!J158)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N158=\"\",\"\",IKW_II_Eingabe!N158)","v":""},{"$f":"IF(IKW_II_Eingabe!O158=\"\",\"\",IKW_II_Eingabe!O158)","v":{"v":0,"d":"0 €"}},{"$f":"IF(IKW_II_Eingabe!P158=\"\",\"\",IKW_II_Eingabe!P158)","v":"0/  0 /  0 /0m"},{"$f":"IF(IKW_II_Eingabe!Q158=\"\",\"\",IKW_II_Eingabe!Q158)","v":"A"}]
[]
[null,"             B Erlös / Baum                                            [€]",{"$f":"IF(IKW_II_Eingabe!C160=\"\",\"\",IKW_II_Eingabe!C160)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H160=\"\",\"\",IKW_II_Eingabe!H160)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J160=\"\",\"\",IKW_II_Eingabe!J160)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N160=\"\",\"\",IKW_II_Eingabe!N160)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!O160=\"\",\"\",IKW_II_Eingabe!O160)","v":{"v":0,"d":"0 €"}},{"$f":"IF(IKW_II_Eingabe!P160=\"\",\"\",IKW_II_Eingabe!P160)","v":"/ 0 / 0 /0m"},{"$f":"IF(IKW_II_Eingabe!Q160=\"\",\"\",IKW_II_Eingabe!Q160)","v":"B"}]
[]
[null,"             C Erlös / Baum                                            [€]",{"$f":"IF(IKW_II_Eingabe!C162=\"\",\"\",IKW_II_Eingabe!C162)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H162=\"\",\"\",IKW_II_Eingabe!H162)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J162=\"\",\"\",IKW_II_Eingabe!J162)","v":""},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N162=\"\",\"\",IKW_II_Eingabe!N162)","v":""},{"$f":"IF(IKW_II_Eingabe!O162=\"\",\"\",IKW_II_Eingabe!O162)","v":{"v":0,"d":"0 €"}},{"$f":"IF(IKW_II_Eingabe!P162=\"\",\"\",IKW_II_Eingabe!P162)","v":" /  0  /  0  /0m"},{"$f":"IF(IKW_II_Eingabe!Q162=\"\",\"\",IKW_II_Eingabe!Q162)","v":"C"}]
[]
[null,"Gesamterlös / Baum                                     [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C164=\"\",\"\",IKW_II_Eingabe!C164)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H164=\"\",\"\",IKW_II_Eingabe!H164)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J164=\"\",\"\",IKW_II_Eingabe!J164)","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"IF(IKW_II_Eingabe!N164=\"\",\"\",IKW_II_Eingabe!N164)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!O164=\"\",\"\",IKW_II_Eingabe!O164)","v":"Bäume"},{"$f":"IF(IKW_II_Eingabe!P164=\"\",\"\",IKW_II_Eingabe!P164)","v":" /  /  / 0St."},{"$f":"IF(IKW_II_Eingabe!Q164=\"\",\"\",IKW_II_Eingabe!Q164)","v":0}]
[]
[null,"Ertragswert (Mehrerlös: Baum geästet zu ungeastet)    [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C166=\"\",\"\",IKW_II_Eingabe!C166)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H166=\"\",\"\",IKW_II_Eingabe!H166)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J166=\"\",\"\",IKW_II_Eingabe!J166)","v":{"$error":"#VALUE!"}},null,null,"Arbeitskraft / h",null,{"$f":"IF(IKW_II_Eingabe!O166=\"\",\"\",IKW_II_Eingabe!O166)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(IKW_II_Eingabe!P166=\"\",\"\",IKW_II_Eingabe!P166)","v":"/   /   /0"},{"$f":"IF(IKW_II_Eingabe!Q166=\"\",\"\",IKW_II_Eingabe!Q166)","v":"GAZ"}]
[]
[null,"abzgl. Ästungsaufwand (aufgezinst bis Alter U)      [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C168=\"\",\"\",IKW_II_Eingabe!C168)","v":""},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H168=\"\",\"\",IKW_II_Eingabe!H168)","v":""},null,{"$f":"IF(IKW_II_Eingabe!J168=\"\",\"\",IKW_II_Eingabe!J168)","v":""},null,null,"Rm /astfr.Schicht",null,{"$f":"IF(IKW_II_Eingabe!O168=\"\",\"\",IKW_II_Eingabe!O168)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!P168=\"\",\"\",IKW_II_Eingabe!P168)","v":""},{"$f":"IF(IKW_II_Eingabe!Q168=\"\",\"\",IKW_II_Eingabe!Q168)","v":"cm"}]
[]
[null,"= Mehrertrag je geästeter Erntebaum (netto)  [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C170=\"\",\"\",IKW_II_Eingabe!C170)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H170=\"\",\"\",IKW_II_Eingabe!H170)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J170=\"\",\"\",IKW_II_Eingabe!J170)","v":{"$error":"#VALUE!"}},null,null,"Vol.: astig/astfr.",null,{"$f":"IF(IKW_II_Eingabe!O170=\"\",\"\",IKW_II_Eingabe!O170)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!P170=\"\",\"\",IKW_II_Eingabe!P170)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!Q170=\"\",\"\",IKW_II_Eingabe!Q170)","v":"fm"}]
[]
[null,"Rentabilität aller Maßnahme(n) bis Stufe ...     [Faktor]",{"$f":"IF(IKW_II_Eingabe!C172=\"\",\"\",IKW_II_Eingabe!C172)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H172=\"\",\"\",IKW_II_Eingabe!H172)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J172=\"\",\"\",IKW_II_Eingabe!J172)","v":{"$error":"#VALUE!"}},null,null," Vol.-%: \" \" / \" \"",null,{"$f":"IF(IKW_II_Eingabe!O172=\"\",\"\",IKW_II_Eingabe!O172)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!P172=\"\",\"\",IKW_II_Eingabe!P172)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!Q172=\"\",\"\",IKW_II_Eingabe!Q172)","v":"V%"}]
[]
[null,"Grenzertrag der Ästungs-Stufe ...                   [€ / Baum]",{"$f":"IF(IKW_II_Eingabe!C174=\"\",\"\",IKW_II_Eingabe!C174)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H174=\"\",\"\",IKW_II_Eingabe!H174)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J174=\"\",\"\",IKW_II_Eingabe!J174)","v":{"$error":"#VALUE!"}},null,null,"Kosten: lfm / fm",null,{"$f":"IF(IKW_II_Eingabe!O174=\"\",\"\",IKW_II_Eingabe!O174)","v":""},{"$f":"IF(IKW_II_Eingabe!P174=\"\",\"\",IKW_II_Eingabe!P174)","v":{"$error":"#VALUE!"}},{"$f":"IF(IKW_II_Eingabe!Q174=\"\",\"\",IKW_II_Eingabe!Q174)","v":"€"}]
[]
[null,"Rentabilität der Einzelmaßnahme: Stufe...       [Faktor]",{"$f":"IF(IKW_II_Eingabe!C176=\"\",\"\",IKW_II_Eingabe!C176)","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$f":"IF(IKW_II_Eingabe!H176=\"\",\"\",IKW_II_Eingabe!H176)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(IKW_II_Eingabe!J176=\"\",\"\",IKW_II_Eingabe!J176)","v":{"$error":"#VALUE!"}},null,null,"d1,3/astfr.Schicht",null,{"$f":"IF(IKW_II_Eingabe!O176=\"\",\"\",IKW_II_Eingabe!O176)","v":{"v":0,"d":"0.0"}},{"$f":"IF(IKW_II_Eingabe!P176=\"\",\"\",IKW_II_Eingabe!P176)","v":""},{"$f":"IF(IKW_II_Eingabe!Q176=\"\",\"\",IKW_II_Eingabe!Q176)","v":"cm"}]
[]
[]
[]
[null,"IV-1. Zu erwartende Sortierung und erzielbare Erlöse"]
[null,"IV-1 A1. Variante 3 mit Wertästung (nur Maßnahme 1)"]
[null,"GKl. A Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. A  Durchmesser o. R. [cm]",{"v":76,"d":"76.0"}]
[]
[null,"GKl. A Preis [€/Efm o. R.]",{"v":200,"d":"200.00 €"}]
[]
[null,"GKl. A Masse [Efm o. R.]",{"$f":"IF(OR($C$182=\"\",$C$184=\"\"),\"\",($C$184/100*$C$184/100)/4*3.14159*$C$182)","v":{"v":2.26822798,"d":"2.27"}}]
[]
[null,"GKl. A Erlös [€]",{"$f":"IF(OR($C$186=\"\",$C$188=\"\"),\"\",$C$186*$C$188)","v":{"v":453.64559599999995,"d":"453.65 €"}}]
[]
[null,"GKl. B Länge [m]",{"v":22,"d":"22.0"}]
[]
[null,"GKl. B  Durchmesser o. R. [cm]",{"v":60,"d":"60.0"}]
[]
[null,"GKl. B Preis [ €/ Efm o. R.]",{"v":96,"d":"96.00 €"}]
[]
[null,"GKl. B Masse [Efm o. R.]",{"$f":"IF(OR($C$192=\"\",$C$194=\"\"),\"\",($C$194/100*$C$194/100)/4*3.14159*$C$192)","v":{"v":6.220348199999999,"d":"6.22"}}]
[]
[null,"GKl. B Erlös [€]",{"$f":"IF(OR($C$196=\"\",$C$198=\"\"),\"\",$C$196*$C$198)","v":{"v":597.1534271999999,"d":"597.15 €"}}]
[]
[null,"GKl. C Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. C  Durchmesser o. R. [cm]",{"v":39,"d":"39.0"}]
[]
[null,"GKl. C Preis [€/Efm o. R.]",{"v":81.6,"d":"81.60 €"}]
[]
[null,"GKl. C Masse [Efm o. R.]",{"$f":"IF(OR($C$202=\"\",$C$204=\"\"),\"\",($C$204/100*$C$204/100)/4*3.14159*$C$202)","v":{"v":0.59729479875,"d":"0.60"}}]
[]
[null,"GKl. C Erlös [€]",{"$f":"IF(OR($C$206=\"\",$C$208=\"\"),\"\",$C$206*$C$208)","v":{"v":48.739255578,"d":"48.74 €"}}]
[]
[null,"Programmerstellung:"]
[]
[null,"K.-H. Schmitz; LB WuH NRW; LuVFA Arnsberger Wald -SPA Waldbau-"]
[]
[null,"Bemerkung"]
{"$rows_empty":21}
[null,"Platz für Anfügungen des Anwenders:"]

{"sheet":"Dokumentation","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[1,2,1,4],[1,7,1,8],[2,1,2,4],[2,7,2,8],[3,4,3,5],[3,7,3,8]]}
["Dokumentation der Wertästung",{"$nulls":6},"Stand:"]
["Forstamt",{"$nulls":4},"Revier"]
["Besitz",{"$nulls":4},"PLZ / Ort"]
["Abt./Distrikt",null,null,"Gemeinde",null,null,"Gemarkung"]
[{"$nulls":6},"Flur-Stück(e)"]
["Maßnahme-Durchführung vom ...",{"$nulls":3},"bis ...",null,"Maßnahme-Fläche (ha)"]
["Höhe v. / b.",null,null,"Baumart / geästet insgesamt "]
["* dÄ_max / min = maximaler /minimaler Durchmesser im Ästungssegment (Dm zu Beginn / Ende der Ästungsstufe; cm o. R.) "]
["Lfd. Nr. /","Baumart","Koordinaten (mind. 7-stellig)",null,"BHD / d1,3","abw. Ästungshöhe (m)",null,"Ästungssegment-Dm"]
["Baum-Nr.","(Abkzg.)","Rechtswert","Hochwert","(cm o. R.)","von ... ","bis ... ","dÄ_max*","dÄ_min*"]

{"sheet":"Information","index":5,"n_rows":216,"n_cols":17,"rows_kept":216,"merged":[[0,6,0,9],[0,10,0,12],[2,6,2,13],[4,6,4,12],[20,13,20,14],[27,3,27,4],[30,1,30,2],[30,7,30,9],[30,13,30,15],[46,1,46,2],[46,7,46,9],[46,13,46,15],[48,1,48,2],[48,7,48,9],[48,13,48,15],[52,1,52,2],[52,7,52,9],[52,13,52,15],[56,1,56,2],[56,7,56,9],[56,13,56,15],[126,15,126,16],[132,15,132,16],[136,15,136,16],[142,15,142,16],[146,15,146,16],[216,1,234,17]]}
[null,"W     e     r     t     ä     s     t     u     n     g",{"$nulls":3},"Besitz","LB Wald u. Holz Nordrhein-Westfalen",{"$nulls":3},"RFA",null,null,"0904","Abt.","156 A2"]
[]
[null,"I n v e s t i t i o n s k a l k u l a t i o n","vom","Adresse",null,null,"LVFA Arnsberger Wald,  Obereimer 13,  59821 Arnsberg",{"$nulls":7},"GK-RW",2647530]
[]
[null,"Erst.:FAR Schmitz, LB Wald u. Holz NRW; LVFA Arnsberger Wald","2013-12-20","Resultat",null,null,"Netto-Rendite je geäst.Erntebaum bis Stufe III",{"$nulls":6},{"v":637.0087175675349,"d":"637.01 €"},"GK-HW",5698460]
[]
[null,"I. Bestand"]
[]
[null,"I A. Ist-Daten",{"$nulls":4},"I B. Soll-Daten"]
[]
[null,"Bestand                                                           [Baumart]","Bergahorn",{"$nulls":3},"erwarteter BHD (d1,3) o. R. im Alter U                           [cm]",{"$nulls":8},{"v":80,"d":"80.0"},"!"]
[]
[null,"Ertragsklasse                                                          [EKl.]","I,0",{"$nulls":3},"jährlicher BHD-Zuwachs bis Alter U                             [cm]",{"$nulls":8},0.8,"!"]
[]
[null,"Bestandesbegründung                                            [Jahr]",1986,null,"!",null,"verbleibender Zeitraum bis Alter U                               [Jahre]",{"$nulls":8},78]
[]
[null,"Aktuelle Bestandesaufnahme                                  [Jahr]",2012,null,"!",null,"Resultierende Umtriebszeit                                        [Jahre]",{"$nulls":8},104]
[]
[null,"aktueller BHD der zu ästenden Bäume o. R.             [cm]",{"v":18,"d":"18.0"},null,"!",null,"entspricht Kalenderjahr im Alter U                                [Jahr]",{"$nulls":8},2090]
[]
[null,"Abholzigkeit Güteklasse A (Durchmesser-Abnahme)[cm / lfdm]",0.3,null,"!",null,"Ggf. abweichende Umtriebszeit      [U]",{"$nulls":6},""]
[]
[null,"Abholzigkeit Güteklasse B (GKl. C =  AbhzkB+1cm)  [cm / lfdm]",0.8,null,"!",null,"= astfreie Schicht [cm]  /  BHD [cm]   /  Jahr",{"$nulls":6},{"v":31,"d":"31.00"},{"v":80,"d":"80.0"},2090]
[]
[]
[]
[]
[null,"II. Maßnahme","Stufe I",{"v":31,"d":"31.0"},{"v":31,"d":"31.0"},null,null,"Stufe II",{"v":29,"d":"29.0"},"cm",{"$nulls":3},"Stufe III",{"v":27,"d":"27.0"},"cm astfr. Schicht"]
[]
[]
[null,"Handästung vom Boden aus",{"$nulls":5},"Distel",{"$nulls":5},"SKT"]
[]
[null,"Maßnahme-Ausführung                             Stufe I.   [Jahr]",2012,null,"!",null,"II.",2017,"(!)",2017,null,null,"III.",2022,"(!)",2022]
[]
[null,"Ästungshöhe von ...                                                   [m]",{"v":0,"d":"0.0"},{"$nulls":4},2.5,{"$nulls":5},{"v":6,"d":"6.0"}]
[]
[null,"Ästungshöhe bis ...                                                   [m]",2.5,null,"!",null,null,{"v":6,"d":"6.0"},"!",{"$nulls":4},{"v":10,"d":"10.0"},"!"]
[]
[null,"Baumabstand: (Optimale Verteilung; 3-Eckverband)                [m]",{"v":18,"d":"18.00"},{"$nulls":3},"[n]",{"v":35.63890566127067,"d":"36"}]
[]
[null,"Anzahl zu ästender Bäume je ha                      [Stück / ha]",36,null,"!",null,null,33,"(!)",33,{"$nulls":3},30,"(!)",30]
[]
[null,"Maßnahmefläche                                                    [ha]",{"v":1,"d":"1.00"},{"$nulls":4},{"v":1,"d":"1.00"},{"$nulls":5},{"v":1,"d":"1.00"}]
[]
[null,"Beschreibung:[Maschineneinsatz  /  Werkzeug  /  Verfahren] ","1-Mann"]
[]
[null,"Ästung vom Boden aus; I. Stufe",{"$nulls":5},"II. Stufe; Distel",{"$nulls":5},"III. Stufe; SKT"]
[]
[null,"Stangen-Säge, 1,7m; ARS-Säge",{"$nulls":5},"Stangen-Säge, 1,7m; ARS-Säge",{"$nulls":5},"ARS-Säge"]
[]
[null,"Ggf. Behandlungsmittel                                        [Menge/Baum]",{"v":0,"d":"0.00"}]
[]
[]
[]
[null,"Dokumentation der Realisierung: [Jahr]/[Bemerkung]",2012]
[]
[null,"Die Maßnahme wurde wie geplant umgesetzt!"]
[]
[]
[]
[null,"III. Kosten"]
[null,"III A. Basisdaten","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Alternative 1: Entgelt / lfdm (aktuellerWert/Folgejahre) [€ / lfdm]",null,null,"[!]",{"$nulls":3},"[!]",{"$nulls":5},"[!]"]
[]
[null,"\"\" 2: Stundenlohn (Folgejahre: Lohn x Steigerungsfaktor [LSF]) [€/h]",{"v":37.2,"d":"37.20 €"},null,"!",null,null,{"v":42.08838551953124,"d":"42.09 €"},"in Jahren",5,{"$nulls":3},{"v":47.619145044104485,"d":"47.62 €"},"in Jahren",10]
[]
[null,"Erschwerniszuschlag   (ggf. Baumbesteigung)                         [%]"]
[]
[null,"Arbeitskraft (Gesamtarbeitszeit, GAZ)            [min. / Baum]",{"v":5,"d":"5.0"},null,"!",null,null,{"v":10,"d":"10.0"},"!",{"$nulls":4},{"v":20,"d":"20.0"},"!"]
[]
[null,"Verwaltungskostenzuschlag / Dokumentationskosten   [%]",{"v":30,"d":"30.0"},{"$nulls":6},{"v":30,"d":"30.0"},{"$nulls":5},{"v":30,"d":"30.0"}]
[]
[null,"Maschineneinsatz                                           [€ / MAS]"]
[]
[null,"Zeitvorgabe Maschineneinsatz (MAS)           [min. / Baum]"]
[]
[null,"Werkzeug (Entschädigung / Abnutzung)                         [€ / h]",{"v":3,"d":"3.00 €"},{"$nulls":4},{"v":3,"d":"3.00 €"},{"$nulls":5},{"v":3,"d":"3.00 €"}]
[]
[null,"Behandlungsmittel  (Wundverschluss etc.)             [€ / Einheit]"]
[]
[null,"Zinssatz für Aufzinsung der Investitionskosten (p)      [%]",{"v":3,"d":"3.00"},null,"!",null,null,"Lohnsteigerung [%]",null,{"v":2.5,"d":"2.50"},"!",null,null,"Lohnsteigerung (p) [% / a]",null,{"v":2.5,"d":"2.50"}]
[]
[null,"Aufzinsungsfaktor (Askontierung; p = % Zinsen)           [(1+p)n]",{"v":10.03005990803109,"d":"10.030"},{"$nulls":4},{"v":8.652017784567038,"d":"8.652"},"[LSF]",{"v":1.1314082128906247,"d":"1.131"},{"$nulls":3},{"v":7.46330654361554,"d":"7.463"},"[LSF]",{"v":1.280084544196357,"d":"1.280"}]
[]
[null,"Aufzinsungs-Zeitraum bis Alter U  (n)                   [Jahre]",78,{"$nulls":4},73,"zu  [%]",{"v":3,"d":"3.00"},{"$nulls":3},68,"zu  [%]",{"v":3,"d":"3.00"}]
[]
[]
[null,"III B. Kalkulation der Maßnahme","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Reine Arbeitskosten                                        [€ / Baum]",{"v":3.1,"d":"3.10 €"},{"$nulls":4},{"v":7.014730919921874,"d":"7.01 €"},{"$nulls":5},{"v":15.873048348034828,"d":"15.87 €"}]
[]
[null,"Verwaltungskosten / Dokumentation                 [€ / Baum]",{"v":0.9299999999999999,"d":"0.93 €"},{"$nulls":4},{"v":2.1044192759765625,"d":"2.10 €"},{"$nulls":5},{"v":4.7619145044104485,"d":"4.76 €"}]
[]
[null,"Maschineneinsatz                                           [€ / Baum]","",{"$nulls":4},"",{"$nulls":5},""]
[]
[null,"Werkzeug                                                      [€ / Baum]",{"v":0.25,"d":"0.25 €"},{"$nulls":4},{"v":0.5,"d":"0.50 €"},{"$nulls":5},{"v":1,"d":"1.00 €"}]
[]
[null,"Behandlungsmittel                                          [€ / Baum]","",{"$nulls":4},"",{"$nulls":5},""]
[]
[null,"Maßnahme insgesamt (unverzinst)                  [€ / Baum]",{"v":4.28,"d":"4.28 €"},{"$nulls":4},{"v":9.619150195898436,"d":"9.62 €"},{"$nulls":5},{"v":21.634962852445277,"d":"21.63 €"}]
[]
[null,"Maßnahme insgesamt (unverzinst)                        [€ / ha]",{"v":154.08,"d":"154.08 €"},{"$nulls":4},{"v":317.4319564646484,"d":"317.43 €"},{"$nulls":5},{"v":649.0488855733583,"d":"649.05 €"}]
[]
[null,"Zinskosten bis Alter U                                     [€ / Baum]",{"v":38.648656406373064,"d":"38.65 €"},{"$nulls":4},{"v":73.60590837143634,"d":"73.61 €"},{"$nulls":5},{"v":139.8333969750887,"d":"139.83 €"}]
[]
[null,"Maßnahme 1 insgesamt (aufgezinst bis Alter U) [€ / Baum]",{"v":42.928656406373065,"d":"42.93 €"},{"$nulls":4},{"v":83.22505856733478,"d":"83.23 €"},{"$nulls":5},{"v":161.468359827534,"d":"161.47 €"}]
[]
[null,"Maßnahme insgesamt (aufgezinst bis Alter U)         [€ / ha]",{"v":1545.4316306294304,"d":"1,545.43 €"},{"$nulls":4},{"v":2746.4269327220477,"d":"2,746.43 €"},{"$nulls":5},{"v":4844.050794826019,"d":"4,844.05 €"}]
[null,"III C. Gesamtkalkulation","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[null,"Gesamtkosten je ha (aufgezinst bis Alter U)               [€ / ha]",{"v":1545.4316306294304,"d":"1,545.43 €"},{"$nulls":4},{"v":4291.858563351478,"d":"4,291.86 €"},{"$nulls":5},{"v":9135.909358177498,"d":"9,135.91 €"}]
[]
[null,"Erwarteter Anteil geästeter Bäume mit Wertholz     [%]",{"v":75,"d":"75.0"},null,"!"]
[]
[null,"Erwartete Anzahl geästeter Bäume / ha mit Wertholz  [St.]",27]
[]
[null,"Umlegung der Kosten je ha auf die erwartete Anzahl geästeter"]
[null,"Bäume mit Wertholzanteil (aufgezinst bis Alter U)    [€ /Baum]",{"v":57.23820854183076,"d":"57.24 €"},{"$nulls":4},{"v":158.95772456857324,"d":"158.96 €"},{"$nulls":5},{"v":338.36701326583324,"d":"338.37 €"}]
[null,"Diesen Betrag müssen die geästeten Erntebäume min. zusätzlich erbringen!"]
[]
[null,"Zu erwartende Sortierung und erzielbare Erlöse","Stufe III",{"$nulls":4},"Stufe II",null,"Stufe I",{"$nulls":3},"Ohne","W  e  r  t  ä  s  t  u  n  g"]
[null,"fm / Baum",{"v":9.5714704720375,"d":"9.57"},{"$nulls":4},{"v":9.618892773087499,"d":"9.62"},null,{"v":9.645512594166405,"d":"9.65"},{"$nulls":3},{"v":9.644684245240626,"d":"9.64"},"",""]
[null,"Güte-Kl. A Länge                                    Stufe III  [m]",{"v":10,"d":"10.0"},"A","",null,null,{"v":6,"d":"6.0"},null,2.5,{"$nulls":3},{"v":0,"d":"0.0"},null,"Legende"]
[]
[null,"                 Durchmesser o. R.                                [cm]",78.8,{"$nulls":4},{"v":79.39999999999999,"d":"79.4"},null,{"v":79.925,"d":"79.9"},{"$nulls":3},{"v":80.3,"d":"80.30"},null,"Eingabe erforderlich =>","!"]
[]
[null,"                 Geästetes Holz (Wertholz-Stück)      [€ / Efm o. R.]",{"v":400,"d":"400.00 €"},null,"!",null,null,{"v":400,"d":"400.00 €"},null,{"v":400,"d":"400.00 €"},{"$nulls":3},{"v":400,"d":"400.00 €"},"Rm","Radius (Mitte A)"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"v":4.876878652399999,"d":"4.88"},{"$nulls":4},{"v":2.970857149859999,"d":"2.97"},null,{"v":1.2542809119652343,"d":"1.25"},{"$nulls":3},{"v":0,"d":"0.00"}]
[]
[null,"                 Erlös                                                      [€]",{"v":1950.7514609599998,"d":"1,950.75 €"},{"$nulls":4},{"v":1188.3428599439997,"d":"1,188.34 €"},null,{"v":501.7123647860937,"d":"501.71 €"},{"$nulls":3},{"v":0,"d":"0.00 €"}]
[]
[null,"Güte-Kl. B Länge (Restlänge vor C-Stück) Stufe III [m]",{"v":5,"d":"5.00"},"B","!",null,null,{"v":9,"d":"9.0"},null,12.5,{"$nulls":3},{"v":15,"d":"15.0"},"d1,3","Durchm. in 1,3m H"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"v":77.299996,"d":"77.30"},{"$nulls":4},{"v":77.8999985,"d":"77.90"},null,{"v":78.4249985,"d":"78.4"},{"$nulls":3},{"v":78.7999985,"d":"78.8"}]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"v":200,"d":"200.00 €"},null,"!",null,null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},{"$nulls":3},{"v":200,"d":"200.00 €"},"GAZ","Gesamtarbeitszeit"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"v":4.6929773420851971E-6,"d":"0.00"},{"$nulls":4},{"v":1.9064503098849015,"d":"1.91"},null,{"v":3.6229337719887034,"d":"3.62"},{"$nulls":3},{"v":4.8768833436104995,"d":"4.88"}]
[]
[null,"                 Erlös                                                      [€]",{"v":9.3859546841703939E-4,"d":"0.00 €"},{"$nulls":4},{"v":381.2900619769803,"d":"381.29 €"},null,{"v":724.5867543977407,"d":"724.59 €"},{"$nulls":3},{"v":975.3766687220999,"d":"975.38 €"}]
[]
[null,"Güte-Kl. C Länge                                    Stufe III  [m]",{"v":7,"d":"7.0"},"C",{"$nulls":3},{"v":7,"d":"7.0"},null,{"v":7,"d":"7.0"},{"$nulls":3},{"v":7,"d":"7.0"},"MAS","Arbeitstd. Maschine"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"v":70.99999199999999,"d":"71.0"},{"$nulls":4},{"v":70.99999199999999,"d":"71.0"},null,{"v":70.99999199999999,"d":"71.0"},{"$nulls":3},{"v":70.99999199999999,"d":"71.0"}]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"v":50,"d":"50.00 €"},{"$nulls":4},{"v":50,"d":"50.00 €"},null,{"v":50,"d":"50.00 €"},{"$nulls":3},{"v":50,"d":"50.00 €"},"LSF","Faktor Lohnsteigg."]
[]
[null,"                 Masse                                          [Efm o. R.]",{"v":2.771431533701942,"d":"2.77"},{"$nulls":4},{"v":2.771431533701942,"d":"2.77"},null,{"v":2.771431533701942,"d":"2.77"},{"$nulls":3},{"v":2.771431533701942,"d":"2.77"},null,"lfm= lfd. Meter"]
[]
[null,"                 Erlös                                                      [€]",{"v":138.57157668509709,"d":"138.57 €"},{"$nulls":4},{"v":138.57157668509709,"d":"138.57 €"},null,{"v":138.57157668509709,"d":"138.57 €"},{"$nulls":3},{"v":138.57157668509709,"d":"138.57 €"},null,"fm = Festmeter"]
[]
[]
[]
[null,"Wirtschaftlichkeit der Maßnahmen: Wertästung bis ","Stufe III",{"$nulls":4},"Stufe II",null,"Stufe I",{"$nulls":3},"Ohne Ästung!"]
[]
[null,"Durchschnittserlös                                            [€ / fm]",{"v":273.1744193685814,"d":"273.17 €"},{"$nulls":4},{"v":223.33151910002468,"d":"223.33 €"},null,{"v":178.44604875543985,"d":"178.45 €"},{"$nulls":3},{"v":145.64623231080017,"d":"145.65 €"},"ZinsF/LS",{"v":10.03005990803109,"d":"10.030"},2.5]
[null,"Güte-Kl. A Erlös / Baum                                            [€]",{"v":1950.7514609599998,"d":"1,950.75 €"},{"$nulls":4},{"v":1188.3428599439997,"d":"1,188.34 €"},null,{"v":501.7123647860937,"d":"501.71 €"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":400,"d":"400 €"},"10 /  6 /  2,5 /  0m","A"]
[]
[null,"             B Erlös / Baum                                            [€]",{"v":9.3859546841703939E-4,"d":"0.00 €"},{"$nulls":4},{"v":381.2900619769803,"d":"381.29 €"},null,{"v":724.5867543977407,"d":"724.59 €"},{"$nulls":3},{"v":975.3766687220999,"d":"975.38 €"},{"v":200,"d":"200 €"},"0,00001 / 4,00001 / 7,50001 / 10,00001m","B"]
[]
[null,"             C Erlös / Baum                                            [€]",{"v":138.57157668509709,"d":"138.57 €"},{"$nulls":4},{"v":138.57157668509709,"d":"138.57 €"},null,{"v":138.57157668509709,"d":"138.57 €"},{"$nulls":3},{"v":138.57157668509709,"d":"138.57 €"},{"v":50,"d":"50 €"},"7  /  7  /  7  /  7m","C"]
[]
[null,"Gesamterlös / Baum                                      [€ / Baum]",{"v":2519.47664025,"d":"2,519.48 €"},{"$nulls":4},{"v":2147.7567999519997,"d":"2,147.76 €"},null,{"v":1809.765516588828,"d":"1,809.77 €"},{"$nulls":3},{"v":1558.743664410625,"d":"1,558.74 €"},"Bäume","30 / 33 / 36 / 0St.",27]
[]
[null,"Ertragswert (Mehrerlös: Baum geästet zu ungeästet)    [€ / Baum]",{"v":960.7329758393751,"d":"960.73 €"},{"$nulls":4},{"v":589.0131355413748,"d":"589.01 €"},null,{"v":251.02185217820306,"d":"251.02 €"},null,null,"Arbeitskraft / h",null,{"v":37.2,"d":"37.20 €"},"20 /  10 /  5 /  0","min"]
[]
[null,"abzgl. Ästungsaufwand (aufgezinst bis Alter U)     [€ / Baum]",{"v":338.36701326583324,"d":"338.37 €"},{"$nulls":4},{"v":158.95772456857324,"d":"158.96 €"},null,{"v":57.23820854183076,"d":"57.24 €"},null,null,"Rm /astfr.Schicht",null,39.4,{"v":31,"d":"31.0"},"cm"]
[]
[null,"= Mehrertrag je geästeter Erntebaum  (net  [€ / Baum]",{"v":622.3659625735418,"d":"622.37 €"},{"$nulls":4},{"v":430.0554109728016,"d":"430.06 €"},null,{"v":193.7836436363723,"d":"193.78 €"},null,null,"Vol.: astig/astfr.",null,{"v":0.22167059039999992,"d":"0.22"},{"v":4.655208062,"d":"4.66"},"fm"]
[]
[null,"Rentabilität aller Maßnahmen bis Stufe ...       [Faktor]",{"v":1.8393222098295638,"d":"1.84"},{"$nulls":4},{"v":2.7054703515668326,"d":"2.71"},null,{"v":3.3855644432818255,"d":"3.39"},null,null," Vol.-%: \" \" / \" \"",null,{"v":4.5453374217320714,"d":"4.5"},{"v":95.45466257826793,"d":"95.5"},"V%"]
[]
[null,"Grenzertrag der Ästungs-Stufe ...                 [€ / Baum]",{"v":192.31055160074015,"d":"192.31 €"},{"$nulls":4},{"v":236.27176733642932,"d":"236.27 €"},null,{"v":193.7836436363723,"d":"193.78 €"},null,null,"Kosten: lfm / fm \"",null,{"v":33.836701326583324,"d":"33.84"},{"v":69.38188078543163,"d":"69.38"},"€"]
[]
[null,"Rentabilität der Einzelmaßnahme:   Stufe...     [Faktor]",{"v":1.071909670882482,"d":"1.07"},{"$nulls":4},{"v":2.3227771480382633,"d":"2.32"},null,{"v":3.3855644432818255,"d":"3.39"},null,null,"d1,3/astfr.Schicht",null,{"v":80,"d":"80.0"},{"v":31,"d":"31.0"},"cm"]
[]
[]
[]
[null,"IV-1. Zu erwartende Sortierung und erzielbare Erlöse"]
[null,"IV-1 A1. Variante 3 mit Wertästung (nur Maßnahme 1)"]
[null,"GKl. A Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. A  Durchmesser o. R. [cm]",{"v":76,"d":"76.0"}]
[]
[null,"GKl. A Preis [€/Efm o. R.]",{"v":200,"d":"200.00 €"}]
[]
[null,"GKl. A Masse [Efm o. R.]",{"v":2.26822798,"d":"2.27"}]
[]
[null,"GKl. A Erlös [€]",{"v":453.64559599999995,"d":"453.65 €"}]
[]
[null,"GKl. B Länge [m]",{"v":22,"d":"22.0"}]
[]
[null,"GKl. B  Durchmesser o. R. [cm]",{"v":60,"d":"60.0"}]
[]
[null,"GKl. B Preis [ €/ Efm o. R.]",{"v":96,"d":"96.00 €"}]
[]
[null,"GKl. B Masse [Efm o. R.]",{"v":6.220348199999999,"d":"6.22"}]
[]
[null,"GKl. B Erlös [€]",{"v":597.1534271999999,"d":"597.15 €"}]
[]
[null,"GKl. C Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. C  Durchmesser o. R. [cm]",{"v":39,"d":"39.0"}]
[]
[null,"GKl. C Preis [€/Efm o. R.]",{"v":81.6,"d":"81.60 €"}]
[]
[null,"GKl. C Masse [Efm o. R.]",{"v":0.59729479875,"d":"0.60"}]
[]
[null,"GKl. C Erlös [€]",{"v":48.739255578,"d":"48.74 €"}]
[]
[null,"Programmerstellung:"]
[]
[null,"K.-H. Schmitz; LB WuH NRW; LuVFA Arnsberger Wald -SPA Waldbau-"]
[]
[null,"Bemerkung"]

{"sheet":"Beispiel","index":6,"n_rows":214,"n_cols":17,"rows_kept":214,"merged":[[0,6,0,9],[0,10,0,12],[2,6,2,13],[4,6,4,12],[20,13,20,14],[27,3,27,4],[30,1,30,2],[30,7,30,9],[30,13,30,15],[46,1,46,2],[46,7,46,9],[46,13,46,15],[48,1,48,2],[48,7,48,9],[48,13,48,15],[52,1,52,2],[52,7,52,9],[52,13,52,15],[56,1,56,2],[56,7,56,9],[56,13,56,15],[214,1,232,17]]}
[null,"W     e     r     t     ä     s     t     u     n     g","Lokalität >",null,null,"Besitz","LB Wald u. Holz Nordrhein-Westfalen",{"$nulls":3},"RFA",null,null,"0904","Abt.","156 A2"]
[]
[null,"I n v e s t i t i o n s k a l k u l a t i o n","vom","Adresse",null,null,"LVFA Arnsberger Wald,  Obereimer 13,  59821 Arnsberg",{"$nulls":7},"GK-RW",2647530]
[]
[null,"Erst.:FAR Schmitz, LB Wald u. Holz NRW; LVFA Arnsberger Wald",{"$f":"TODAY()","v":"2014-01-07"},"Resultat",null,null,{"$f":"IF($C$168>0,\"Netto-Rendite je geäst.Erntebaum bis \"&C119,IF($C$168<0,\"Netto-Verlust je geäst.Erntebaum bis \"&C119,\"\"))","v":"Netto-Rendite je geäst.Erntebaum bis Stufe III"},{"$nulls":6},{"$f":"$C$168","v":{"v":622.3659625735418,"d":"622.37 €"}},"GK-HW",5698460]
[]
[null,"I. Bestand"]
[]
[null,"I A. Ist-Daten",{"$nulls":4},"I B. Soll-Daten",{"$nulls":6},"Eingabe erforderlich =","!"]
[]
[null,"Bestand                                                         [Baumart]","BAh",{"$nulls":3},"erwarteter BHD (d1,3) o. R. im Alter U                            [cm]",{"$nulls":8},{"v":80,"d":"80.0"},"!"]
[]
[null,"Ertragsklasse                                                        [EKl.]","I,0",{"$nulls":3},"jährlicher BHD-Zuwachs bis Alter U                                [cm]",{"$nulls":8},0.8,"!"]
[]
[null,"Bestandesbegründung                                           [Jahr]",1986,null,"!",null,"verbleibender Zeitraum bis Alter U                               [Jahre]",{"$nulls":8},{"$f":"IF($P$13=0,\"\",ROUNDUP(($P$11-$C$19)/$P$13,0))","v":78}]
[]
[null,"Aktuelle Bestandesaufnahme                                 [Jahr]",2012,null,"!",null,"Resultierende Umtriebszeit                                        [Jahre]",{"$nulls":8},{"$f":"IF(OR($C$15=\"\",$C$17=\"\",$P$15=\"\"),\"\",$C$17-$C$15+$P$15)","v":104}]
[]
[null,"aktueller BHD der zu ästenden Bäume o. R.             [cm]",{"v":18,"d":"18.0"},null,"!",null,"entspricht Kalenderjahr im Alter U                                [Jahr]",{"$nulls":8},{"$f":"IF($P$17=\"\",\"\",$C$15+$P$17)","v":2090}]
[]
[null,"Abholzigkeit Güteklasse A (Durchmesser-Abnahme)[cm / lfdm]",0.3,null,"!",null,"Ggf. abweichende Umtriebszeit         [U]",{"$nulls":6},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",\"\"))","v":""}]
[]
[null,"Abholzigkeit Güteklasse B (GKl. C =  AbhzkB+1cm)  [cm / lfdm]",0.8,null,"!",null,"= astfreie Schicht [cm]  /  BHD [cm]   /  Jahr",{"$nulls":6},{"$f":"(O23-C19)/2","v":{"v":31,"d":"31.00"}},{"$f":"IF($P$11=\"\",0,IF($P$23>$P$19,$P$11+($P$23-$P$19)*$P$13,IF($P$23<$P$19,$P$11+($P$23-$P$19)*$P$13,$P$11)))","v":{"v":80,"d":"80.0"}},{"$f":"IF(AND($P$21=\"\",$P$19=\"\"),\"\",IF($P$21>0,$C$15+$P$21,$P$19))","v":2090}]
[]
[]
[]
[]
[null,"II. Maßnahme","Stufe I",{"$f":"IF(OR($C$33=\"\",$C$37=\"\",$C$37=0),\"\",(($P$11+$C$21)-($C$37*$C$21))/2-((($C$19+$C$21)-($C$37*$C$21)+($C$33-$C$17)*$P$13)/2))","v":{"v":31,"d":"31.0"}},{"$f":"(($P$11+$C$21)-($C$37*$C$21))/2-((($C$19+$C$21)-($C$37*$C$21)+($C$33-$C$17)*$P$13)/2)","v":{"v":31,"d":"31.0"}},null,null,"Stufe II",{"$f":"IF(OR($H$33=\"\",$H$37=\"\",$H$37=0),\"\",(($P$11+$C$21)-($H$37*$C$21))/2-((($C$19+$C$21)-($H$37*$C$21)+($H$33-$C$17)*$P$13)/2))","v":{"v":29,"d":"29.0"}},{"$f":"IF($I$28<>\"\",\"cm\",\"\")","v":"cm"},{"$nulls":3},"Stufe III",{"$f":"IF(OR($N$33=\"\",$N$37=\"\",$N$37=0),\"\",(($P$11+$C$21)-($N$37*$C$21))/2-((($C$19+$C$21)-($N$37*$C$21)+($N$33-$C$17)*$P$13)/2))","v":{"v":27,"d":"27.0"}},{"$f":"IF(OR($O$28<>\"\",$I$28<>\"\",$D$28<>\"\"),\"cm astfr. Schicht\",\"\")","v":"cm astfr. Schicht"}]
[]
[]
[null,"Bodenästung",{"$nulls":5},"Distel",{"$nulls":5},"SKT"]
[]
[null,"Maßnahme-Ausführung                                         [Jahr]",2012,null,"!",null,null,2017,"(!)",{"$f":"IF(AND($H$33=\"\",$C$33=\"\"),\"\",IF($H$33=\"\",$C$33,$H$33))","v":2017},{"$nulls":3},2022,"(!)",{"$f":"IF(AND($N$33=\"\",$J$33=\"\",$C$33=\"\"),\"\",IF($N$33=\"\",$J$33,$N$33))","v":2022}]
[]
[null,"Ästungshöhe von ...                                                 [m]",{"v":0,"d":"0.0"},{"$nulls":4},{"$f":"$C$37","v":2.5},{"$nulls":5},{"$f":"$H$37","v":{"v":6,"d":"6.0"}}]
[]
[null,"Ästungshöhe bis ...                                                  [m]",2.5,{"$f":"IF(AND(OR($C$68>0,$C$74>0,),OR($C$37=\"\",$C$37=0)),\"??\",\"\")","v":""},"!",null,null,{"v":6,"d":"6.0"},"!",{"$f":"IF(AND(OR($H$68>0,$H$74>0,),OR($H$37=\"\",$H$37=0)),\"<=W e r t ?\",\"\")","v":""},{"$nulls":3},{"v":10,"d":"10.0"},"!",{"$f":"IF(AND(OR($N$68>0,$N$74>0,),OR($N$37=\"\",$N$37=0)),\"<=W e r t ?\",\"\")","v":""}]
[]
[null,"Baumabstand: (Optimale Verteilung; 3-Eckverband)                [m]",{"v":18,"d":"18.00"},{"$nulls":3},"[n]",{"$f":"10000/($C$39^2*0.8660254)","v":{"v":35.63890566127067,"d":"36"}},"(errechn. Anzahl /ha)",{"$nulls":3},"[n]",{"$f":"10000/($C$39^2*0.8660254)","v":{"v":35.63890566127067,"d":"36"}}]
[]
[null,"Anzahl zu ästender Bäume je ha                     [Stück / ha]",36,null,"!",null,null,33,"(!)",{"$f":"IF(AND($H$41=\"\",$C$41=\"\"),\"\",IF($H$41=\"\",$C$41,$H$41))","v":33},{"$nulls":3},30,"(!)",{"$f":"IF(AND($N$41=\"\",$J$41=\"\",$C$41=\"\"),\"\",IF($N$41=\"\",$J$41,$N$41))","v":30}]
[]
[null,"Maßnahmefläche                                                    [ha]",{"v":1,"d":"1.00"},{"$nulls":4},{"v":1,"d":"1.00"},{"$nulls":5},{"v":1,"d":"1.00"}]
[]
[null,"Beschreibung:[Maschineneinsatz  /  Werkzeug  /  Verfahren] ","1-Mann"]
[]
[null,"Ästung vom Boden aus; I. Stufe",{"$nulls":5},"II. Stufe; Distel",{"$nulls":5},"III. Stufe; SKT"]
[]
[null,"Stangen-Säge, 1,7m; ARS-Säge",{"$nulls":5},"Distel-Leiter, ARS-Säge",{"$nulls":5},"ARS-Säge"]
[]
[null,"Ggf. Behandlungsmittel [Produktbezeichng] / [Menge/Baum]"]
[]
[]
[]
[null,"Dokumentation der Realisierung: [Jahr]/[Bemerkung]","2012"]
[]
[null,"Die Maßnahme wurde wie geplant umgesetzt!"]
[]
[]
[]
[null,"III. Kosten"]
[null,"III A. Basisdaten","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Stundenlohn (Folgejahre: Lohn x Steigerungsfaktor [LSF])    [€ / h]",{"v":37.2,"d":"37.20 €"},null,"!",null,null,{"$f":"IF(AND($C$64>0,$J$82>0),$C$64*$J$82,IF($C$64>0,$C$64,\"\"))","v":{"v":42.08838551953124,"d":"42.09 €"}},"in Jahren",{"$f":"IF(AND($C$33>0,$J$33>0),$J$33-$C$33,\"\")","v":5},{"$nulls":3},{"$f":"IF(AND($C$64>0,$P$82>0),$C$64*$P$82,IF($C$64>0,$C$64,\"\"))","v":{"v":47.619145044104485,"d":"47.62 €"}},"in Jahren",{"$f":"IF(AND($C$33>0,$P$33>0),$P$33-$C$33,\"\")","v":10}]
[]
[null,"Erschwerniszuschlag   (f. Baumbesteigung; max. 56%)          [%]"]
[]
[null,"Zeitvorgabe Arbeitskraft (GAZ)                       [min. / Baum]",{"v":5,"d":"5.0"},{"$f":"IF(AND(OR($C$68>0,$C$74>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":""},"!",null,null,{"v":10,"d":"10.0"},"!",{"$f":"IF(AND(OR($H$68>0,$H$74>0,),OR($H$37=\"\",$H$37=0)),\"Ästg.-Höhe?\",\"\")","v":""},{"$nulls":3},{"v":20,"d":"20.0"},"!",{"$f":"IF(AND(OR($N$68>0,$N$74>0,),OR($N$37=\"\",$N$37=0)),\"Ästg.-Höhe?\",\"\")","v":""}]
[]
[null,"Verwaltungskostenzuschlag / Dokumentationskosten   [%]",{"v":30,"d":"30.0"},{"$nulls":6},{"$f":"IF(H70<>\"\",H70,IF($C$70=\"\",\"\",$C$70))","v":{"v":30,"d":"30.0"}},{"$nulls":5},{"$f":"IF($N$70<>\"\",$N$70,IF($C$70=\"\",\"\",$C$70))","v":{"v":30,"d":"30.0"}}]
[]
[null,"Maschineneinsatz                                             [€ / MAS]"]
[]
[null,"Zeitvorgabe Maschineneinsatz (MAS)           [min. / Baum]",null,{"$f":"IF(AND(OR($C$68>0,$C$74>0,),OR($C$37=\"\",$C$37=0)),\"H?\",\"\")","v":""},{"$nulls":5},{"$f":"IF(AND(OR($H$68>0,$H$74>0,),OR($H$37=\"\",$H$37=0)),\"Ästg.-Höhe?\",\"\")","v":""},{"$nulls":5},{"$f":"IF(AND(OR($N$68>0,$N$74>0,),OR($N$37=\"\",$N$37=0)),\"Ästg.-Höhe?\",\"\")","v":""}]
[]
[null,"Werkzeug (Entschädigung / Abnutzung)                         [€ / h]",{"v":3,"d":"3.00 €"},{"$nulls":4},{"v":3,"d":"3.00 €"},{"$nulls":5},{"v":3,"d":"3.00 €"}]
[]
[null,"Behandlungsmittel                                         [€ / Einheit]"]
[]
[null,"Zinssatz für Aufzinsung der Investitionskosten (p)      [%]",{"v":3,"d":"3.00"},null,"!",null,null,"Lohnsteigerung [%]",null,{"v":2.5,"d":"2.50"},"!",null,null,"Lohnsteigerung (p) [% / a]",null,{"$f":"IF($J$80>0,$J$80,0)","v":{"v":2.5,"d":"2.50"}}]
[]
[null,"Aufzinsungsfaktor (Askontierung; p = % Zinsen)           [(1+p)n]",{"$f":"IF(OR($C$80=\"\",$C$84=\"\"),\"\",(1+$C$80/100)^$C$84)","v":{"v":10.03005990803109,"d":"10.030"}},{"$nulls":4},{"$f":"IF(OR($J$41=\"\",$H$84=\"\"),\"\",(1+$J$84/100)^$H$84)","v":{"v":8.652017784567038,"d":"8.652"}},"[LSF]",{"$f":"IF(OR($J$41=\"\",$J$64=\"\"),\"\",(1+$J$80/100)^$J$64)","v":{"v":1.1314082128906247,"d":"1.131"}},{"$nulls":3},{"$f":"IF(OR($J$41=\"\",$N$84=\"\"),\"\",(1+$P$84/100)^$N$84)","v":{"v":7.46330654361554,"d":"7.463"}},"[LSF]",{"$f":"IF(OR($P$41=\"\",$P$64=\"\"),\"\",(1+$P$80/100)^$P$64)","v":{"v":1.280084544196357,"d":"1.280"}}]
[]
[null,"Aufzinsungs-Zeitraum bis Alter U  (n)                   [Jahre]",{"$f":"IF(OR($C$15=\"\",$C$33=\"\",$P$23=\"\"),\"\",$P$23-$C$33)","v":78},{"$nulls":4},{"$f":"IF(OR($C$15=\"\",$J$33=\"\",$P$23=\"\"),\"\",$P$23-$J$33)","v":73},"zu  [%]",{"$f":"IF($C$80=\"\",\"\",$C$80)","v":{"v":3,"d":"3.00"}},{"$nulls":3},{"$f":"IF(OR($C$15=\"\",$P$33=\"\",$P$23=\"\"),\"\",$P$23-$P$33)","v":68},"zu  [%]",{"$f":"IF($C$80=\"\",\"\",$C$80)","v":{"v":3,"d":"3.00"}}]
[]
[]
[null,"III B. Kalkulation der Maßnahme","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[]
[null,"Reine Arbeitskosten                                        [€ / Baum]",{"$f":"IF(OR($C$64=\"\",$C$68=\"\"),\"\",IF($C$66=\"\",($C$64/60)*$C$68,($C$64/60)*$C$68*(1+$C$66/100)))","v":{"v":3.1,"d":"3.10 €"}},{"$nulls":4},{"$f":"IF(OR($H$64=\"\",$H$68=\"\"),\"\",IF($H$66=\"\",($H$64/60)*$H$68,($H$64/60)*$H$68*(1+$H$66/100)))","v":{"v":7.014730919921874,"d":"7.01 €"}},{"$nulls":5},{"$f":"IF(OR($N$64=\"\",$N$68=\"\"),\"\",IF($N$66=\"\",($N$64/60)*$N$68,($N$64/60)*$N$68*(1+$N$66/100)))","v":{"v":15.873048348034828,"d":"15.87 €"}}]
[]
[null,"Verwaltungskosten / Dokumentation                 [€ / Baum]",{"$f":"IF(OR($C$70=\"\",$C$89=\"\"),\"\",($C$89/100)*$C$70)","v":{"v":0.9299999999999999,"d":"0.93 €"}},{"$nulls":4},{"$f":"IF(OR($J$70=\"\",$H$89=\"\"),\"\",($H$89/100)*$J$70)","v":{"v":2.1044192759765625,"d":"2.10 €"}},{"$nulls":5},{"$f":"IF(OR($P$70=\"\",$N$89=\"\"),\"\",($N$89/100)*$P$70)","v":{"v":4.7619145044104485,"d":"4.76 €"}}]
[]
[null,"Maschineneinsatz                                           [€ / Baum]",{"$f":"IF(OR($C$72=\"\",$C$74=\"\"),\"\",($C$72/60)*$C$74)","v":""},{"$nulls":4},{"$f":"IF(OR($H$72=\"\",$H$74=\"\"),\"\",($H$72/60)*$H$74)","v":""},{"$nulls":5},{"$f":"IF(OR($N$72=\"\",$N$74=\"\"),\"\",($N$72/60)*$N$74)","v":""}]
[]
[null,"Werkzeug                                                      [€ / Baum]",{"$f":"IF(OR($C$68=\"\",$C$76=\"\"),\"\",($C$76/60)*$C$68)","v":{"v":0.25,"d":"0.25 €"}},{"$nulls":4},{"$f":"IF(OR($H$68=\"\",$H$76=\"\"),\"\",($H$76/60)*$H$68)","v":{"v":0.5,"d":"0.50 €"}},{"$nulls":5},{"$f":"IF(OR($N$68=\"\",$N$76=\"\"),\"\",($N$76/60)*$N$68)","v":{"v":1,"d":"1.00 €"}}]
[]
[null,"Behandlungsmittel                                          [€ / Baum]",{"$f":"IF(OR($C$51=\"\",$C$78=\"\"),\"\",$C$51*$C$78)","v":""},{"$nulls":4},{"$f":"IF(OR($H$51=\"\",$H$78=\"\"),\"\",$H$51*$H$78)","v":""},{"$nulls":5},{"$f":"IF(OR($N$51=\"\",$N$78=\"\"),\"\",$N$51*$N$78)","v":""}]
[]
[null,"Maßnahme insgesamt (unverzinst)                  [€ / Baum]",{"$f":"SUM($C$89,$C$91,$C$93,$C$95,$C$97)","v":{"v":4.28,"d":"4.28 €"}},{"$nulls":4},{"$f":"SUM($H$89,$H$91,$H$93,$H$95,$H$97)","v":{"v":9.619150195898436,"d":"9.62 €"}},{"$nulls":5},{"$f":"SUM($N$89,$N$91,$N$93,$N$95,$N$97)","v":{"v":21.634962852445277,"d":"21.63 €"}}]
[]
[null,"Maßnahme insgesamt (unverzinst)                        [€ / ha]",{"$f":"IF(OR($C$41=\"\",$C$99=\"\"),\"\",$C$99*$C$41)","v":{"v":154.08,"d":"154.08 €"}},{"$nulls":4},{"$f":"IF(OR($J$41=\"\",$H$99=\"\"),\"\",$H$99*$J$41)","v":{"v":317.4319564646484,"d":"317.43 €"}},{"$nulls":5},{"$f":"IF(OR($P$41=\"\",$N$99=\"\"),\"\",$N$99*$P$41)","v":{"v":649.0488855733583,"d":"649.05 €"}}]
[]
[null,"Zinskosten bis Alter U                                     [€ / Baum]",{"$f":"IF(OR($C$82=\"\",$C$99=\"\"),\"\",($C$99)*($C$82-1))","v":{"v":38.648656406373064,"d":"38.65 €"}},{"$nulls":4},{"$f":"IF(OR($H$82=\"\",$H$99=\"\"),\"\",($H$99)*($H$82-1))","v":{"v":73.60590837143634,"d":"73.61 €"}},{"$nulls":5},{"$f":"IF(OR($N$82=\"\",$N$99=\"\"),\"\",($N$99)*($N$82-1))","v":{"v":139.8333969750887,"d":"139.83 €"}}]
[]
[null,"Maßnahme 1 insgesamt (aufgezinst bis Alter U) [€ / Baum]",{"$f":"SUM($C$99,$C$103)","v":{"v":42.928656406373065,"d":"42.93 €"}},{"$nulls":4},{"$f":"SUM($H$99,$H$103)","v":{"v":83.22505856733478,"d":"83.23 €"}},{"$nulls":5},{"$f":"SUM($N$99,$N$103)","v":{"v":161.468359827534,"d":"161.47 €"}}]
[]
[null,"Maßnahme insgesamt (aufgezinst bis Alter U)         [€ / ha]",{"$f":"IF(OR($C$105=\"\",$C$41=\"\"),\"\",$C$105*$C$41)","v":{"v":1545.4316306294304,"d":"1,545.43 €"}},{"$nulls":4},{"$f":"IF(OR($H$105=\"\",$J$41=\"\"),\"\",$H$105*$J$41)","v":{"v":2746.4269327220477,"d":"2,746.43 €"}},{"$nulls":5},{"$f":"IF(OR($N$105=\"\",$P$41=\"\"),\"\",$N$105*$P$41)","v":{"v":4844.050794826019,"d":"4,844.05 €"}}]
[null,"III C. Gesamtkalkulation","Stufe I",{"$nulls":4},"Stufe II",{"$nulls":5},"Stufe III"]
[null,"Gesamtkosten je ha (aufgezinst bis Alter U)               [€ / ha]",{"$f":"SUM($C$107)","v":{"v":1545.4316306294304,"d":"1,545.43 €"}},{"$nulls":4},{"$f":"SUM($C$107,$H$107)","v":{"v":4291.858563351478,"d":"4,291.86 €"}},{"$nulls":5},{"$f":"SUM($C$107,$H$107,$N$107)","v":{"v":9135.909358177498,"d":"9,135.91 €"}}]
[]
[null,"Erwarteter Anteil geästeter Bäume mit Wertholz         [%]",{"v":75,"d":"75.0"},null,"!"]
[]
[null,"Erwartete Anzahl geästeter Bäume / ha mit Wertholz  [St.]",{"$f":"ROUNDDOWN(IF(OR($C$41=\"\",$C$111=\"\",$C$111=0),0,($C$41/100)*$C$111),0)","v":27}]
[]
[null,"Umlegung der Kosten je ha auf die erwartete Anzahl geästeter"]
[null,"Bäume mit Wertholzanteil (aufgezinst bis Alter U)    [€ /Baum]",{"$f":"IF(OR($C$109=\"\",$C$113=\"\",$C$113=0),\"\",$C$109/$C$113)","v":{"v":57.23820854183076,"d":"57.24 €"}},{"$nulls":4},{"$f":"IF(OR($H$109=\"\",$C$113=\"\",$C$113=0),\"\",$H$109/$C$113)","v":{"v":158.95772456857324,"d":"158.96 €"}},{"$nulls":5},{"$f":"IF(OR($N$109=\"\",$C$113=\"\",$C$113=0),\"\",$N$109/$C$113)","v":{"v":338.36701326583324,"d":"338.37 €"}}]
[null,{"$f":"\"Diesen Betrag muß jeder der erwarteten \" &C113&\" Erntebäume min. zusätzlich erbringen!\"","v":"Diesen Betrag muß jeder der erwarteten 27 Erntebäume min. zusätzlich erbringen!"}]
[]
[null,"IV. Zu erwartende Sortierung und erzielbare Erlöse",{"$f":"IF(AND($N$37>0,$P$41>0,$N$68>0),\"Stufe III\",IF(AND($H$37>0,$J$41>0,$H$68>0),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$68>0),\"Stufe I\",\"\")))","v":"Stufe III"},{"$nulls":4},{"$f":"IF(AND($H$37>0,$J$41>0,$H$68>0),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$68>0),\"Stufe I\",\"\"))","v":"Stufe II"},null,{"$f":"IF(AND($C$37>0,$C$41>0,$C$68>0),\"Stufe I\",\"\")","v":"Stufe I"},{"$nulls":3},"Ohne","W   e   r   t   ä   s   t   u   n   g"]
[null,"fm / Baum",{"$f":"$C$127+$C$137+$C$147","v":{"v":9.5714704720375,"d":"9.57"}},{"$nulls":4},{"$f":"$H$127+$H$137+$H$147","v":{"v":9.618892773087499,"d":"9.62"}},null,{"$f":"$J$127+$J$137+$J$147","v":{"v":9.645512594166405,"d":"9.65"}},{"$nulls":3},{"$f":"$N$127+$N$137+$N$147","v":{"v":9.644684245240626,"d":"9.64"}},{"$f":"IF((($N$120-$C$120)/$C$120)*100>2,(($N$120-$C$120)/$C$120)*100,\"\")","v":""},{"$f":"IF((($N$120-$C$120)/$C$120)*100>2,\"% Vol.-Diff.\",\"\")","v":""}]
[null,{"$f":"\"Güte-Kl. A Länge                                    \"&$C$119&\"  [m]\"","v":"Güte-Kl. A Länge                                    Stufe III  [m]"},{"$f":"IF(AND($N$37=\"\",$H$37=\"\",$C$37=\"\"),0,IF(AND($N$37>0,$N$68>0),$N$37,IF(AND($H$37>0,$H$68>0),$H$37,IF(AND($C$37>0,$C$68>0),$C$37,0))))","v":{"v":10,"d":"10.0"}},"A",{"$f":"IF(AND($H$119=$C$119,$H$166<>$C$166),\"??\",\"\")","v":""},null,null,{"$f":"IF(AND($H$37=\"\",$C$37=\"\"),0,IF(AND($H$37>0,$H$68>0),$H$37,IF(AND($C$37>0,$C$68>0),$C$37,0)))","v":{"v":6,"d":"6.0"}},null,{"$f":"IF(AND($H$37=\"\",$C$37=\"\"),0,IF(AND($C$37>0,$C$68>0),$C$37,IF($C$37>0,$C$37,0)))","v":2.5},{"$nulls":3},{"v":0,"d":"0.0"},null,"Abkürzg.-Verz."]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($O$23=\"\",$O$23=0),\"\",$O$23+$C$21-($C$121*0.5)*$C$21)","v":78.8},{"$nulls":4},{"$f":"IF($C$123=\"\",\"\",IF($H$121/2<=$C$121,($O$23+$C$21)-($H$121/2)*$C$21,($O$23+$C$21)-(($C$121*$C$21)+(($H$121/2-$C$121)*$C$23))))","v":{"v":79.39999999999999,"d":"79.4"}},null,{"$f":"IF($C$123=\"\",\"\",IF($J$121/2<=$C$121,($O$23+$C$21)-($J$121/2)*$C$21,($O$23+$C$21)-(($C$121*$C$21)+(($J$121/2-$C$121)*$C$23))))","v":{"v":79.925,"d":"79.9"}},{"$nulls":3},{"$f":"IF($C$123=\"\",\"\",IF($N$121/2<=$C$121,($O$23+$C$21)-($N$121/2)*$C$21,($O$23+$C$21)-(($C$121*$C$21)+(($N$121/2-$C$121)*$C$23))))","v":{"v":80.3,"d":"80.30"}},null,"GAZ"]
[]
[null,"                 Geästetes Holz (Wertholz-Stück)     [€ / Efm o. R.]",{"v":400,"d":"400.00 €"},null,"!",null,null,{"$f":"$C$125","v":{"v":400,"d":"400.00 €"}},null,{"$f":"$C$125","v":{"v":400,"d":"400.00 €"}},{"$nulls":3},{"$f":"$C$125","v":{"v":400,"d":"400.00 €"}},null,"Gesamt-Ar-"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(OR($C$121=\"\",$C$123=\"\"),\"\",($C$123/100*$C$123/100)/4*3.14159*$C$121)","v":{"v":4.876878652399999,"d":"4.88"}},{"$nulls":4},{"$f":"IF(OR($H$121=\"\",$H$123=\"\"),\"\",($H$123/100*$H$123/100)/4*3.14159*$H$121)","v":{"v":2.970857149859999,"d":"2.97"}},null,{"$f":"IF(OR($J$121=\"\",$J$123=\"\"),\"\",($J$123/100*$J$123/100)/4*3.14159*$J$121)","v":{"v":1.2542809119652343,"d":"1.25"}},{"$nulls":3},{"$f":"IF(OR($N$121=\"\",$N$123=\"\"),\"\",($N$123/100*$N$123/100)/4*3.14159*$N$121)","v":{"v":0,"d":"0.00"}},null,"beits-Zeit für"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$125=\"\",$C$127=\"\"),\"\",$C$125*$C$127)","v":{"v":1950.7514609599998,"d":"1,950.75 €"}},{"$nulls":4},{"$f":"IF(OR($H$125=\"\",$H$127=\"\"),\"\",$H$125*$H$127)","v":{"v":1188.3428599439997,"d":"1,188.34 €"}},null,{"$f":"IF(OR($J$125=\"\",$J$127=\"\"),\"\",$J$125*$J$127)","v":{"v":501.7123647860937,"d":"501.71 €"}},{"$nulls":3},{"$f":"IF(OR($N$125=\"\",$N$127=\"\"),\"\",$N$125*$N$127)","v":{"v":0,"d":"0.00 €"}},null,"Ästungs-Stufe"]
[]
[null,{"$f":"\"Güte-Kl. B Länge (Restlänge vor C-Stück) \"&$C$119&\" [m]\"","v":"Güte-Kl. B Länge (Restlänge vor C-Stück) Stufe III [m]"},{"v":5,"d":"5.0"},"B","!",null,null,{"$f":"IF(AND($C$121=\"\",$C$131=\"\"),\"\",IF(AND($C$121>0,OR($C$131=\"\",$C$131=0),OR($H$121=\"\",$H$121=0)),$C$121,IF($H$121>0,$C$121+$C$131-$H$121,$C$121+$C$131)))","v":{"v":9,"d":"9.0"}},null,{"$f":"IF(AND($C$121=\"\",$C$131=\"\"),\"\",IF(AND($C$121>0,OR($C$131=\"\",$C$131=0),OR($J$121=\"\",$J$121=0)),$C$121,IF($J$121>0,$C$121+$C$131-$J$121,$C$121+$C$131)))","v":12.5},{"$nulls":3},{"$f":"IF(AND($C$121=\"\",$C$131=\"\"),\"\",IF(AND($C$121>0,OR($C$131=\"\",$C$131=0),OR($N$121=\"\",$N$121=0)),$C$121,IF($N$121>0,$C$121+$C$131-$N$121,$C$121+$C$131)))","v":{"v":15,"d":"15.0"}},null,"I-III in Minuten"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($C$131=\"\",$C$131=0),\"\",$C$123-(($C$121*0.5*$C$21)+$C$131*0.5*($C$23)))","v":{"v":75.3,"d":"75.30"}},{"$nulls":4},{"$f":"IF($C$133=\"\",\"\",IF(($H$121+$H$131/2)>$C$121,($O$23+$C$21)-($C$121*$C$21)-($H$121-$C$121+$H$131/2)*$C$23,($O$23+$C$21)-($H$121+$H$131/2)*$C$21))","v":{"v":76.89999999999999,"d":"76.90"}},null,{"$f":"IF($C$133=\"\",\"\",IF(($J$121+$J$131/2)>$C$121,($O$23+$C$21)-($C$121*$C$21)-($J$121-$C$121+$J$131/2)*$C$23,($O$23+$C$21)-($J$121+$J$131/2)*$C$21))","v":{"v":77.675,"d":"77.7"}},{"$nulls":3},{"$f":"IF($C$133=\"\",\"\",IF(($N$121+$N$131/2)>$C$121,($O$23+$C$21)-($C$121*$C$21)-($N$121-$C$121+$N$131/2)*$C$23,($O$23+$C$21)-($N$121+$N$131/2)*$C$21))","v":{"v":78.05,"d":"78.1"}},null,"d1,3   (= BHD)"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"v":200,"d":"200.00 €"},null,"!",null,null,{"$f":"$C$135","v":{"v":200,"d":"200.00 €"}},null,{"$f":"$C$135","v":{"v":200,"d":"200.00 €"}},{"$nulls":3},{"$f":"$C$135","v":{"v":200,"d":"200.00 €"}},null,"Durchmesser"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(OR($C$131=\"\",$C$133=\"\"),\"\",($C$133/100*$C$133/100)/4*3.14159*$C$131)","v":{"v":2.2266372553875,"d":"2.23"}},{"$nulls":4},{"$f":"IF(OR($H$131=\"\",$H$133=\"\"),\"\",($H$133/100*$H$133/100)/4*3.14159*$H$131)","v":{"v":4.180081058977499,"d":"4.18"}},null,{"$f":"IF(OR($J$131=\"\",$J$133=\"\"),\"\",($J$133/100*$J$133/100)/4*3.14159*$J$131)","v":{"v":5.923277117951171,"d":"5.92"}},{"$nulls":3},{"$f":"IF(OR($N$131=\"\",$N$133=\"\"),\"\",($N$133/100*$N$133/100)/4*3.14159*$N$131)","v":{"v":7.176729680990625,"d":"7.18"}},null,"in 1,3m Höhe"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$135=\"\",$C$137=\"\"),\"\",$C$135*$C$137)","v":{"v":445.3274510775,"d":"445.33 €"}},{"$nulls":4},{"$f":"IF(OR($H$135=\"\",$H$137=\"\"),\"\",$H$135*$H$137)","v":{"v":836.0162117954998,"d":"836.02 €"}},null,{"$f":"IF(OR($J$135=\"\",$J$137=\"\"),\"\",$J$135*$J$137)","v":{"v":1184.6554235902342,"d":"1,184.66 €"}},{"$nulls":3},{"$f":"IF(OR($N$135=\"\",$N$137=\"\"),\"\",$N$135*$N$137)","v":{"v":1435.345936198125,"d":"1,435.35 €"}},null,"Rm "]
[]
[null,{"$f":"\"Güte-Kl. C Länge                                    \"&$C$119&\"  [m]\"","v":"Güte-Kl. C Länge                                    Stufe III  [m]"},{"v":7,"d":"7.0"},"C",{"$nulls":3},{"$f":"$C$141","v":{"v":7,"d":"7.0"}},null,{"$f":"$C$141","v":{"v":7,"d":"7.0"}},{"$nulls":3},{"$f":"$C$141","v":{"v":7,"d":"7.0"}},null,"Radius in der"]
[]
[null,"                 Durchmesser o. R.                                [cm]",{"$f":"IF(OR($C$141=\"\",$C$141=0),\"\",$C$133-(($C$131*0.5)*$C$23)-(($C$141*0.5)*($C$23+1)))","v":{"v":67,"d":"67.0"}},{"$nulls":4},{"$f":"$C$143","v":{"v":67,"d":"67.0"}},null,{"$f":"$C$143","v":{"v":67,"d":"67.0"}},{"$nulls":3},{"$f":"$C$143","v":{"v":67,"d":"67.0"}},null,"Mitte d. A-Stamm-"]
[]
[null,"                 Preis                                         [€ / Efm o. R.]",{"v":50,"d":"50.00 €"},{"$nulls":4},{"$f":"$C$145","v":{"v":50,"d":"50.00 €"}},null,{"$f":"$C$145","v":{"v":50,"d":"50.00 €"}},{"$nulls":3},{"$f":"$C$145","v":{"v":50,"d":"50.00 €"}},null,"(Werholz)-stückes"]
[]
[null,"                 Masse                                          [Efm o. R.]",{"$f":"IF(OR($C$141=\"\",$C$143=\"\"),\"\",($C$143/100*$C$143/100)/4*3.14159*$C$141)","v":{"v":2.4679545642500003,"d":"2.47"}},{"$nulls":4},{"$f":"IF(OR($N$141=\"\",$N$143=\"\"),\"\",($N$143/100*$N$143/100)/4*3.14159*$N$141)","v":{"v":2.4679545642500003,"d":"2.47"}},null,{"$f":"IF(OR($N$141=\"\",$N$143=\"\"),\"\",($N$143/100*$N$143/100)/4*3.14159*$N$141)","v":{"v":2.4679545642500003,"d":"2.47"}},{"$nulls":3},{"$f":"IF(OR($N$141=\"\",$N$143=\"\"),\"\",($N$143/100*$N$143/100)/4*3.14159*$N$141)","v":{"v":2.4679545642500003,"d":"2.47"}},null,"lfm=lfd.Meter;fm=m³"]
[]
[null,"                 Erlös                                                      [€]",{"$f":"IF(OR($C$145=\"\",$C$147=\"\"),\"\",$C$145*$C$147)","v":{"v":123.39772821250001,"d":"123.40 €"}},{"$nulls":4},{"$f":"IF(OR($H$145=\"\",$H$147=\"\"),\"\",$H$145*$H$147)","v":{"v":123.39772821250001,"d":"123.40 €"}},null,{"$f":"IF(OR($J$145=\"\",$J$147=\"\"),\"\",$J$145*$J$147)","v":{"v":123.39772821250001,"d":"123.40 €"}},{"$nulls":3},{"$f":"IF(OR($N$145=\"\",$N$147=\"\"),\"\",$N$145*$N$147)","v":{"v":123.39772821250001,"d":"123.40 €"}},null,"ZinF =Aufzinsg.=>U"]
[]
[]
[]
[null,"V. Wirtschaftlichkeit der Maßnahmen: Wertästung bis ",{"$f":"IF(AND($N$37>0,$P$41>0,$N$68>0),\"Stufe III\",IF(AND($H$37>0,$J$41>0,$H$68>0),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$68>0),\"Stufe I\",\"\")))","v":"Stufe III"},{"$nulls":4},{"$f":"IF(AND($H$37>0,$J$41>0,$H$68>0),\"Stufe II\",IF(AND($C$37>0,$C$41>0,$C$68>0),\"Stufe I\",\"\"))","v":"Stufe II"},null,{"$f":"IF(AND($C$37>0,$C$41>0,$C$68>0),\"Stufe I\",\"\")","v":"Stufe I"},{"$nulls":3},"Ohne Ästung!",null,"Zusammenstellung"]
[]
[null,"Durchschnittserlös                                            [€ / fm]",{"$f":"IF(C141>0,$C$162/($C$127+$C$137+$C$147),$C$162/($C$127+$C$137))","v":{"v":263.22775038699706,"d":"263.23 €"}},{"$nulls":4},{"$f":"IF(H141>0,$H$162/($H$127+$H$137+$H$147),$H$162/($H$127+$H$137))","v":{"v":223.28524193150005,"d":"223.29 €"}},null,{"$f":"IF(J141>0,$J$162/($J$127+$J$137+$J$147),$J$162/($J$127+$J$137))","v":{"v":187.6277179590613,"d":"187.63 €"}},{"$nulls":3},{"$f":"IF(N141>0,$N$162/($N$127+$N$137+$N$147),$N$162/($N$127+$N$137))","v":{"v":161.6168683987576,"d":"161.62 €"}},"ZinsF/LS",{"$f":"$C$82","v":{"v":10.03005990803109,"d":"10.030"}},{"$f":"$J$80","v":2.5}]
[null,"Güte-Kl. A Erlös / Baum                                            [€]",{"$f":"IF($C$129=\"\",\"\",$C$129)","v":{"v":1950.7514609599998,"d":"1,950.75 €"}},{"$nulls":4},{"$f":"IF($H$129=\"\",\"\",$H$129)","v":{"v":1188.3428599439997,"d":"1,188.34 €"}},null,{"$f":"IF($J$129=\"\",\"\",$J$129)","v":{"v":501.7123647860937,"d":"501.71 €"}},{"$nulls":3},{"$f":"IF($N$129=\"\",\"\",$N$129)","v":{"v":0,"d":"0.00 €"}},{"$f":"$C$125","v":{"v":400,"d":"400 €"}},{"$f":"$C$121&\"/  \"&$H$121&\" /  \"&$J$121&\" / \"&$N$121&\"m\"","v":"10/  6 /  2,5 / 0m"},{"$f":"$D$121","v":"A"}]
[]
[null,"             B Erlös / Baum                                            [€]",{"$f":"IF($C$139=\"\",\"\",$C$139)","v":{"v":445.3274510775,"d":"445.33 €"}},{"$nulls":4},{"$f":"IF($H$139=\"\",\"\",$H$139)","v":{"v":836.0162117954998,"d":"836.02 €"}},null,{"$f":"IF($J$139=\"\",\"\",$J$139)","v":{"v":1184.6554235902342,"d":"1,184.66 €"}},{"$nulls":3},{"$f":"IF($N$139=\"\",\"\",$N$139)","v":{"v":1435.345936198125,"d":"1,435.35 €"}},{"$f":"$C$135","v":{"v":200,"d":"200 €"}},{"$f":"$C$131&\" / \"&$H$131&\" / \"&$J$131&\" / \"&$N$131&\"m\"","v":"5 / 9 / 12,5 / 15m"},{"$f":"$D$131","v":"B"}]
[]
[null,"             C Erlös / Baum                                            [€]",{"$f":"IF($C$149=\"\",\"\",$C$149)","v":{"v":123.39772821250001,"d":"123.40 €"}},{"$nulls":4},{"$f":"IF($H$149=\"\",\"\",$H$149)","v":{"v":123.39772821250001,"d":"123.40 €"}},null,{"$f":"IF($J$149=\"\",\"\",$J$149)","v":{"v":123.39772821250001,"d":"123.40 €"}},{"$nulls":3},{"$f":"IF($N$149=\"\",\"\",$N$149)","v":{"v":123.39772821250001,"d":"123.40 €"}},{"$f":"$C$145","v":{"v":50,"d":"50 €"}},{"$f":"$C$141&\"  /  \"&$H$141&\"  /  \"&$J$141&\"  /  \"&$N$141&\"m\"","v":"7  /  7  /  7  /  7m"},{"$f":"$D$141","v":"C"}]
[]
[null,"Gesamterlös / Baum                                       [€ / Baum]",{"$f":"IF(AND($C$156=\"\",$C$158=\"\",$C$160=\"\"),\"\",SUM($C$156,$C$158,$C$160))","v":{"v":2519.47664025,"d":"2,519.48 €"}},{"$nulls":4},{"$f":"IF(AND($H$156=\"\",$H$158=\"\",$H$160=\"\"),\"\",SUM($H$156,$H$158,$H$160))","v":{"v":2147.7567999519997,"d":"2,147.76 €"}},null,{"$f":"IF(AND($J$156=\"\",$J$158=\"\",$J$160=\"\"),\"\",SUM($J$156,$J$158,$J$160))","v":{"v":1809.765516588828,"d":"1,809.77 €"}},{"$nulls":3},{"$f":"IF(AND($N$156=\"\",$N$158=\"\",$N$160=\"\"),\"\",SUM($N$156,$N$158,$N$160))","v":{"v":1558.743664410625,"d":"1,558.74 €"}},"Bäume",{"$f":"$P$41&\" / \"&$J$41&\" / \"&$C$41&\" / \"&\"0St.\"","v":"30 / 33 / 36 / 0St."},{"$f":"$C$113","v":27}]
[]
[null,"Ertragswert (Mehrerlös: Baum geästet zu ungeastet)    [€ / Baum]",{"$f":"IF(OR($C$162=\"\",$N$162=\"\"),\"\",$C$162-$N$162)","v":{"v":960.7329758393751,"d":"960.73 €"}},{"$nulls":4},{"$f":"IF(OR($H$162=\"\",$N$162=\"\"),\"\",$H$162-$N$162)","v":{"v":589.0131355413748,"d":"589.01 €"}},null,{"$f":"IF(OR($N$162=\"\",$J$162=\"\"),\"\",$J$162-$N$162)","v":{"v":251.02185217820306,"d":"251.02 €"}},null,null,"Arbeitskraft / h",null,{"$f":"$C$64","v":{"v":37.2,"d":"37.20 €"}},{"$f":"$N$68&\"/  \"&$H$68&\" /  \"&$C$68& \" /0\"","v":"20/  10 /  5 /0"},"GAZ"]
[]
[null,"abzgl. Ästungsaufwand (aufgezinst bis Alter U)       [€ / Baum]",{"$f":"IF(OR($N$109=\"\",$C$113=\"\",$C$113=0),\"\",$N$109/$C$113)","v":{"v":338.36701326583324,"d":"338.37 €"}},{"$nulls":4},{"$f":"IF(OR($H$109=\"\",$C$113=\"\",$C$113=0),\"\",$H$109/$C$113)","v":{"v":158.95772456857324,"d":"158.96 €"}},null,{"$f":"IF(OR($C$109=\"\",$C$113=\"\",$C$113=0),\"\",$C$109/$C$113)","v":{"v":57.23820854183076,"d":"57.24 €"}},null,null,"Rm /astfr.Schicht",null,{"$f":"$C$123/2","v":39.4},{"$f":"IF(OR($C$19=\"\",$C$19=0,$O$23=\"\",$O$23=0),\"\",$O$166-(($C$19+$C$21)-($C$121/2)*$C$21)/2)","v":{"v":31,"d":"31.0"}},"cm"]
[]
[null,"= Mehrertrag je geästeter Erntebaum (netto)  [€ / Baum]",{"$f":"IF(OR($C$164=\"\",$C$166=\"\"),\"\",$C$164-$C$166)","v":{"v":622.3659625735418,"d":"622.37 €"}},{"$nulls":4},{"$f":"IF(OR($H$164=\"\",$H$166=\"\"),\"\",$H$164-$H$166)","v":{"v":430.0554109728016,"d":"430.06 €"}},null,{"$f":"IF(OR($J$164=\"\",$J$166=\"\"),\"\",$J$164-$J$166)","v":{"v":193.7836436363723,"d":"193.78 €"}},null,null,"Vol.: astig/astfr.",null,{"$f":"IF(OR($C$121=\"\",$O$166=\"\",$P$166=\"\"),\"\",(($O$166-$P$166)/100*($O$166-$P$166)/100)*3.14159*$C$121)","v":{"v":0.22167059039999992,"d":"0.22"}},{"$f":"$C$127-$O$168","v":{"v":4.655208062,"d":"4.66"}},"fm"]
[]
[null,"Rentabilität aller Maßnahme(n) bis Stufe ...     [Faktor]",{"$f":"IF(OR($C$166=\"\",$C$168=\"\"),\"\",$C$168/$C$166)","v":{"v":1.8393222098295638,"d":"1.84"}},{"$nulls":4},{"$f":"IF(OR($H$166=\"\",$H$168=\"\"),\"\",$H$168/$H$166)","v":{"v":2.7054703515668326,"d":"2.71"}},null,{"$f":"IF(OR($J$166=\"\",$J$168=\"\"),\"\",$J$168/$J$166)","v":{"v":3.3855644432818255,"d":"3.39"}},null,null," Vol.-%: \" \" / \" \"",null,{"$f":"$O$168/$C$127*100","v":{"v":4.5453374217320714,"d":"4.5"}},{"$f":"$P$168/$C$127*100","v":{"v":95.45466257826793,"d":"95.5"}},"V%"]
[]
[null,"Grenzertrag der Ästungs-Stufe ...                   [€ / Baum]",{"$f":"$C$168-$H$168","v":{"v":192.31055160074015,"d":"192.31 €"}},{"$nulls":4},{"$f":"$H$168-$J$168","v":{"v":236.27176733642932,"d":"236.27 €"}},null,{"$f":"$J$168","v":{"v":193.7836436363723,"d":"193.78 €"}},null,null,"Kosten: lfm / fm",null,{"$f":"IF(OR($C$121=\"\",$C$166=\"\"),\"\",$C$166/$C$121)","v":{"v":33.836701326583324,"d":"33.84"}},{"$f":"IF(AND($C$127>0,$C$166>0),$C$166/$C$127,\"\")","v":{"v":69.38188078543163,"d":"69.38"}},"€"]
[]
[null,"Rentabilität der Einzelmaßnahme: Stufe...       [Faktor]",{"$f":"IF(OR($C$166=\"\",$C$168=\"\"),\"\",$C$172/($C$166-$H$166))","v":{"v":1.071909670882482,"d":"1.07"}},{"$nulls":4},{"$f":"IF(OR($H$166=\"\",$H$168=\"\"),\"\",$H$172/($H$166-$J$166))","v":{"v":2.3227771480382633,"d":"2.32"}},null,{"$f":"IF(OR($J$166=\"\",$J$168=\"\"),\"\",$J$172/$J$166)","v":{"v":3.3855644432818255,"d":"3.39"}},null,null,"d1,3/astfr.Schicht",null,{"$f":"$O$23","v":{"v":80,"d":"80.0"}},{"$f":"IF(OR($C$19=\"\",$O$23=\"\"),\"\",IF(($O$23-$C$19)/2<20,\"Zu gering!\",($O$23-$C$19)/2))","v":{"v":31,"d":"31.0"}},"cm"]
[]
[]
[]
[null,"IV-1. Zu erwartende Sortierung und erzielbare Erlöse"]
[null,"IV-1 A1. Variante 3 mit Wertästung (nur Maßnahme 1)"]
[null,"GKl. A Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. A  Durchmesser o. R. [cm]",{"v":76,"d":"76.0"}]
[]
[null,"GKl. A Preis [€/Efm o. R.]",{"v":200,"d":"200.00 €"}]
[]
[null,"GKl. A Masse [Efm o. R.]",{"$f":"IF(OR($C$180=\"\",$C$182=\"\"),\"\",($C$182/100*$C$182/100)/4*3.14159*$C$180)","v":{"v":2.26822798,"d":"2.27"}}]
[]
[null,"GKl. A Erlös [€]",{"$f":"IF(OR($C$184=\"\",$C$186=\"\"),\"\",$C$184*$C$186)","v":{"v":453.64559599999995,"d":"453.65 €"}}]
[]
[null,"GKl. B Länge [m]",{"v":22,"d":"22.0"}]
[]
[null,"GKl. B  Durchmesser o. R. [cm]",{"v":60,"d":"60.0"}]
[]
[null,"GKl. B Preis [ €/ Efm o. R.]",{"v":96,"d":"96.00 €"}]
[]
[null,"GKl. B Masse [Efm o. R.]",{"$f":"IF(OR($C$190=\"\",$C$192=\"\"),\"\",($C$192/100*$C$192/100)/4*3.14159*$C$190)","v":{"v":6.220348199999999,"d":"6.22"}}]
[]
[null,"GKl. B Erlös [€]",{"$f":"IF(OR($C$194=\"\",$C$196=\"\"),\"\",$C$194*$C$196)","v":{"v":597.1534271999999,"d":"597.15 €"}}]
[]
[null,"GKl. C Länge [m]",{"v":5,"d":"5.0"}]
[]
[null,"GKl. C  Durchmesser o. R. [cm]",{"v":39,"d":"39.0"}]
[]
[null,"GKl. C Preis [€/Efm o. R.]",{"v":81.6,"d":"81.60 €"}]
[]
[null,"GKl. C Masse [Efm o. R.]",{"$f":"IF(OR($C$200=\"\",$C$202=\"\"),\"\",($C$202/100*$C$202/100)/4*3.14159*$C$200)","v":{"v":0.59729479875,"d":"0.60"}}]
[]
[null,"GKl. C Erlös [€]",{"$f":"IF(OR($C$204=\"\",$C$206=\"\"),\"\",$C$204*$C$206)","v":{"v":48.739255578,"d":"48.74 €"}}]
[]
[null,"Programmerstellung:"]
[]
[null,"K.-H. Schmitz; LB WuH NRW; LuVFA Arnsberger Wald -SPA Waldbau-"]
[]
[null,"Bemerkung"]