{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Infos zur Holzpartie","Angebotsdaten","Angebotsvergleich","Betriebsübersicht","Holzpreise","Tabelle1","Hilfe"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":32,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Infos zur Holzpartie","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,8],[19,0,19,8],[1,0,1,8],[4,0,4,8],[5,0,5,8]]}
[null,"Landesforstdienst Tirol"]
["Angebotsvergleich-Informationen zur Holzpartie"]
["Baumart","Fichte","Tanne","Lärche","Weißkiefer","Zirbe","sonst. Nadelholz","Laubholz 1","Laubholz 2"]
["Partiemenge m³"]
["Variante 1"]
["Güteklassenverteilung in %"]
["Blochholz B"]
["Blochholz C"]
["Blochholz B/C"]
["Blochholz CX"]
["Blochholz B/C/CX"]
["Langholz B/C"]
["Brennholz weich"]
["Brennholz hart"]
["Sonstiges"]
["Industrieholz 1"]
["Industrieholz 2"]
["Summe",{"$f":"IF(B11 <> \"\",SUM(B11,B12:B17),SUM(B9,B12:B17))","v":0},{"$f":"IF(C11 <> \"\",SUM(C11,C12:C17),SUM(C9,C12:C17))","v":0},0,0,0,0,0,0]
[]
["Stärkeklassen in % (Blochholz)"]
["D 1a"]
["D 1b"]
["D 2a- D 3b"]
["D4"]
["D5"]
["D6"]
["Summe",{"$f":"SUM(B21:B26)","v":0},{"$f":"SUM(C21:C26)","v":0},0,0,0,0,0,0]

{"sheet":"Angebotsdaten","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,1],[6,1,6,2],[7,1,7,2],[0,1,0,6],[10,0,10,1],[8,1,8,2],[9,0,9,6],[1,0,1,6],[3,1,3,2],[4,1,4,2],[5,1,5,2],[2,0,2,6]]}
[null,"Landesforstdienst Tirol"]
["Angebotsvergleich-Angebotsdaten"]
["Basisdaten Angebot"]
[null,"Name des Käufers",null,"Ust% (bei Bruttopreisangabe)","Vorrückung €/fm","Schlägerung+\nLieferung € /fm","Bemerkung"]
["Angebot 1"]
["Angebot 2"]
["Angebot 3"]
["Angebot 4"]
["Angebot 5"]
[null,null,null,null,null,null,null,"Varianten gesamt"]
["Preistabelle",null,null,null,null,null,null,1]
["Baumart/Sortiment/Güte/Stärkeklasse",null,{"$f":"IF($B$5<>\"\",$B$5,\"\")","v":""},{"$f":"IF($B$6<>\"\",$B$6,\"\")","v":""},{"$f":"IF($B$7<>\"\",$B$7,\"\")","v":""},{"$f":"IF($B$8<>\"\",$B$8,\"\")","v":""},{"$f":"IF($B$9<>\"\",$B$9,\"\")","v":""},"Adressen"]

{"sheet":"Angebotsvergleich","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,0,5,3],[8,0,8,3],[9,0,9,3],[7,0,7,3],[6,0,6,3],[0,0,0,1],[0,2,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,3]]}
[null,null,"Landesforstdienst Tirol"]
["Angebotsvergleich - Auswertung der Preisangebote"]
["Variante 1"]
["Baumart/Sortiment/Güte/Stärkeklasse"]
[]
["Umsatzsteuer\n(Industrie- und Rundholz mit Ust. laut Angabe,\nBrennholz mit 13% Ust.)"]
["Angebotssumme netto"]
["Vorrückung"]
["Schlägerung+ Lieferung"]
["Deckungsbeitrag (Erntekostenfreier Erlös)"]

{"sheet":"Betriebsübersicht","index":3,"n_rows":65,"n_cols":4,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["Baumart","Güte","Stärkeklassen",{"$f":"CONCATENATE(A1,\"/\",B1,\" \",C1)","v":"Baumart/Güte Stärkeklassen"}]
["Fichte","Blochholz B","D1a",{"$f":"CONCATENATE(A2,\"/\",B2,\" \",C2)","v":"Fichte/Blochholz B D1a"}]
["Fichte","Blochholz B","D 1b","Fichte/Blochholz B D 1b"]
["Fichte","Blochholz B","D 2a- D 3b","Fichte/Blochholz B D 2a- D 3b"]
["Fichte","Blochholz B","D4","Fichte/Blochholz B D4"]
["Fichte","Blochholz B","D5","Fichte/Blochholz B D5"]
["Fichte","Blochholz B","D6","Fichte/Blochholz B D6"]
["Fichte","Blochholz C","D 1a","Fichte/Blochholz C D 1a"]
["Fichte","Blochholz C","D 1b","Fichte/Blochholz C D 1b"]
["Fichte","Blochholz C","D 2a- D 3b","Fichte/Blochholz C D 2a- D 3b"]
["Fichte","Blochholz C","D4","Fichte/Blochholz C D4"]
["Fichte","Blochholz C","D5","Fichte/Blochholz C D5"]
["Fichte","Blochholz C","D6","Fichte/Blochholz C D6"]
["Fichte","Blochholz CX","D 1a","Fichte/Blochholz CX D 1a"]
["Fichte","Blochholz CX","D 1b","Fichte/Blochholz CX D 1b"]
["Fichte","Blochholz CX","D 2a- D 3b","Fichte/Blochholz CX D 2a- D 3b"]
["Fichte","Blochholz CX","D4","Fichte/Blochholz CX D4"]
["Fichte","Blochholz CX","D5","Fichte/Blochholz CX D5"]
["Fichte","Blochholz CX","D6","Fichte/Blochholz CX D6"]
["Fichte","BlochholzB/C","D 1a","Fichte/BlochholzB/C D 1a"]
["Fichte","BlochholzB/C","D 1b","Fichte/BlochholzB/C D 1b"]
["Fichte","BlochholzB/C","D 2a- D 3b","Fichte/BlochholzB/C D 2a- D 3b"]
["Fichte","BlochholzB/C","D4","Fichte/BlochholzB/C D4"]
["Fichte","BlochholzB/C","D5","Fichte/BlochholzB/C D5"]
["Fichte","BlochholzB/C","D6","Fichte/BlochholzB/C D6"]
["Fichte","Blochholz B/C/CX","D 1a","Fichte/Blochholz B/C/CX D 1a"]
["Fichte","Blochholz B/C/CX","D 1b","Fichte/Blochholz B/C/CX D 1b"]
["Fichte","Blochholz B/C/CX","D 2a- D 3b","Fichte/Blochholz B/C/CX D 2a- D 3b"]
["Fichte","Blochholz B/C/CX","D4","Fichte/Blochholz B/C/CX D4"]
["Fichte","Blochholz B/C/CX","D5","Fichte/Blochholz B/C/CX D5"]
["Fichte","Blochholz B/C/CX","D6","Fichte/Blochholz B/C/CX D6"]
["Fichte","Langholz B","D 1a","Fichte/Langholz B D 1a"]
["Fichte","Langholz B","D 1b","Fichte/Langholz B D 1b"]
["Fichte","Langholz B","D 2a- D 3b","Fichte/Langholz B D 2a- D 3b"]
["Fichte","Langholz B","D4","Fichte/Langholz B D4"]
["Fichte","Langholz B","D5","Fichte/Langholz B D5"]
["Fichte","Langholz B","D6","Fichte/Langholz B D6"]
["Fichte","Langholz C","D 1a","Fichte/Langholz C D 1a"]
["Fichte","Langholz C","D 1b","Fichte/Langholz C D 1b"]
["Fichte","Langholz C","D 2a- D 3b","Fichte/Langholz C D 2a- D 3b"]
["Fichte","Langholz C","D4","Fichte/Langholz C D4"]
["Fichte","Langholz C","D5","Fichte/Langholz C D5"]
["Fichte","Langholz C","D6","Fichte/Langholz C D6"]
["Fichte","Langholz CX","D 1a","Fichte/Langholz CX D 1a"]
["Fichte","Langholz CX","D 1b","Fichte/Langholz CX D 1b"]
["Fichte","Langholz CX","D 2a- D 3b","Fichte/Langholz CX D 2a- D 3b"]
["Fichte","Langholz CX","D4","Fichte/Langholz CX D4"]
["Fichte","Langholz CX","D5","Fichte/Langholz CX D5"]
["Fichte","Langholz CX","D6","Fichte/Langholz CX D6"]
["Fichte","Langholz","D 1a","Fichte/Langholz D 1a"]
["Fichte","Langholz","D 1b","Fichte/Langholz D 1b"]
["Fichte","Langholz","D 2a- D 3b","Fichte/Langholz D 2a- D 3b"]
["Fichte","Langholz","D4","Fichte/Langholz D4"]
["Fichte","Langholz","D5","Fichte/Langholz D5"]
["Fichte","Langholz","D6","Fichte/Langholz D6"]
["Fichte","Langholz B/C/CX","D 1a","Fichte/Langholz B/C/CX D 1a"]
["Fichte","Langholz B/C/CX","D 1b","Fichte/Langholz B/C/CX D 1b"]
["Fichte","Langholz B/C/CX","D 2a- D 3b","Fichte/Langholz B/C/CX D 2a- D 3b"]
["Fichte","Langholz B/C/CX","D4","Fichte/Langholz B/C/CX D4"]
["Fichte","Langholz B/C/CX","D5","Fichte/Langholz B/C/CX D5"]
["Fichte","Langholz B/C/CX","D6","Fichte/Langholz B/C/CX D6"]
["Fichte","Brennholz weich",null,"Fichte/Brennholz weich "]
["Fichte","Brennholz hart",null,{"$f":"CONCATENATE(A63,\"/\",B63,\" \",C63)","v":"Fichte/Brennholz hart "}]
["Fichte","Industrieholz 1",null,{"$f":"CONCATENATE(A64,\"/\",B64,\" \",C64)","v":"Fichte/Industrieholz 1 "}]
["Fichte","Industrieholz 2",null,{"$f":"CONCATENATE(A65,\"/\",B65,\" \",C65)","v":"Fichte/Industrieholz 2 "}]

{"sheet":"Holzpreise","index":4,"n_rows":741,"n_cols":4,"rows_kept":741,"cut":false,"hidden":true,"merged":[]}
[1,"Fichte Blochholz B",90,120]
[2,"Fichte Blochholz C",60,95]
[3,"Fichte Blochholz B/C",60,120]
[4,"Fichte Blochholz CX",38,85]
[5,"Fichte Blochholz B/C/CX",60,95]
[6,"Fichte Blochholz B D 1a",30,95]
[7,"Fichte Blochholz B D 1b",30,95]
[8,"Fichte Blochholz B D 2a- D 3b",90,120]
[9,"Fichte Blochholz B D4",86,120]
[10,"Fichte Blochholz B D5",75,120]
[11,"Fichte Blochholz B D6",66,120]
[12,"Fichte Blochholz C D 1a",30,95]
[13,"Fichte Blochholz C D 1b",30,95]
[14,"Fichte Blochholz C D 2a- D 3b",60,95]
[15,"Fichte Blochholz C D4",56,95]
[16,"Fichte Blochholz C D5",45,95]
[17,"Fichte Blochholz C D6",36,95]
[18,"Fichte Blochholz B/C D 1a",30,95]
[19,"Fichte Blochholz B/C D 1b",30,95]
[20,"Fichte Blochholz B/C D 2a- D 3b",60,120]
[21,"Fichte Blochholz B/C D4",56,120]
[22,"Fichte Blochholz B/C D5",45,120]
[23,"Fichte Blochholz B/C D6",36,120]
[24,"Fichte Blochholz CX D 1a",15,78]
[25,"Fichte Blochholz CX D 1b",15,78]
[26,"Fichte Blochholz CX D 2a- D 3b",38,85]
[27,"Fichte Blochholz CX D4",34,85]
[28,"Fichte Blochholz CX D5",23,85]
[29,"Fichte Blochholz CX D6",14,85]
[30,"Fichte Blochholz B/C/CX D 1a",22,88]
[31,"Fichte Blochholz B/C/CX D 1b",22,88]
[32,"Fichte Blochholz B/C/CX D 2a- D 3b",60,95]
[33,"Fichte Blochholz B/C/CX D4",56,95]
[34,"Fichte Blochholz B/C/CX D5",45,95]
[35,"Fichte Blochholz B/C/CX D6",36,95]
[36,"Fichte Langholz B/C",70,120]
[37,"Fichte Brennholz weich",10,42]
[38,"Fichte Brennholz hart"]
[39,"Fichte Sonstiges",1,200]
[40,"Fichte Industrieholz 1",5,60]
[41,"Fichte Industrieholz 2",5,60]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tanne"]
[101,"Tanne Blochholz B",70,100]
[102,"Tanne Blochholz C",50,85]
[103,"Tanne Blochholz B/C",65,109]
[104,"Tanne Blochholz CX",40,82]
[105,"Tanne Blochholz B/C/CX",45,96]
[106,"Tanne Blochholz B D 1a",30,74]
[107,"Tanne Blochholz B D 1b",30,74]
[108,"Tanne Blochholz B D 2a- D 3b",70,100]
[109,"Tanne Blochholz B D4",66,100]
[110,"Tanne Blochholz B D5",55,100]
[111,"Tanne Blochholz B D6",46,100]
[112,"Tanne Blochholz C D 1a",28,56]
[113,"Tanne Blochholz C D 1b",28,56]
[114,"Tanne Blochholz C D 2a- D 3b",50,85]
[115,"Tanne Blochholz C D4",46,85]
[116,"Tanne Blochholz C D5",35,85]
[117,"Tanne Blochholz C D6",26,85]
[118,"Tanne Blochholz B/C D 1a",25,74]
[119,"Tanne Blochholz B/C D 1b",25,74]
[120,"Tanne Blochholz B/C D 2a- D 3b",65,109]
[121,"Tanne Blochholz B/C D4",61,109]
[122,"Tanne Blochholz B/C D5",50,109]
[123,"Tanne Blochholz B/C D6",41,109]
[124,"Tanne Blochholz CX D 1a",22,50]
[125,"Tanne Blochholz CX D 1b",22,50]
[126,"Tanne Blochholz CX D 2a- D 3b",40,82]
[127,"Tanne Blochholz CX D4",36,82]
[128,"Tanne Blochholz CX D5",25,82]
[129,"Tanne Blochholz CX D6",16,82]
[130,"Tanne Blochholz B/C/CX D 1a",25,70]
[131,"Tanne Blochholz B/C/CX D 1b",25,70]
[132,"Tanne Blochholz B/C/CX D 2a- D 3b",45,96]
[133,"Tanne Blochholz B/C/CX D4",41,96]
[134,"Tanne Blochholz B/C/CX D5",30,96]
[135,"Tanne Blochholz B/C/CX D6",21,96]
[136,"Tanne Langholz B/C",55,120]
[137,"Tanne Brennholz weich",10,42]
[138,"Tanne Brennholz hart"]
[139,"Tanne Sonstiges",1,200]
[140,"Tanne Industrieholz 1",5,42]
[141,"Tanne Industrieholz 2",5,42]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Lärche"]
[201,"Lärche Blochholz B",100,150]
[202,"Lärche Blochholz C",70,125]
[203,"Lärche Blochholz B/C",80,142]
[204,"Lärche Blochholz CX",60,110]
[205,"Lärche Blochholz B/C/CX",70,142]
[206,"Lärche Blochholz B D 1a",35,90]
[207,"Lärche Blochholz B D 1b",35,90]
[208,"Lärche Blochholz B D 2a- D 3b",100,150]
[209,"Lärche Blochholz B D4",96,150]
[210,"Lärche Blochholz B D5",85,150]
[211,"Lärche Blochholz B D6",76,150]
[212,"Lärche Blochholz C D 1a",25,70]
[213,"Lärche Blochholz C D 1b",25,70]
[214,"Lärche Blochholz C D 2a- D 3b",70,125]
[215,"Lärche Blochholz C D4",66,125]
[216,"Lärche Blochholz C D5",55,125]
[217,"Lärche Blochholz C D6",46,125]
[218,"Lärche Blochholz B/C D 1a",30,90]
[219,"Lärche Blochholz B/C D 1b",30,90]
[220,"Lärche Blochholz B/C D 2a- D 3b",80,142]
[221,"Lärche Blochholz B/C D4",76,142]
[222,"Lärche Blochholz B/C D5",65,142]
[223,"Lärche Blochholz B/C D6",56,142]
[224,"Lärche Blochholz CX D 1a",20,60]
[225,"Lärche Blochholz CX D 1b",20,60]
[226,"Lärche Blochholz CX D 2a- D 3b",60,110]
[227,"Lärche Blochholz CX D4",56,110]
[228,"Lärche Blochholz CX D5",45,110]
[229,"Lärche Blochholz CX D6",36,110]
[230,"Lärche Blochholz B/C/CX D 1a",25,70]
[231,"Lärche Blochholz B/C/CX D 1b",25,70]
[232,"Lärche Blochholz B/C/CX D 2a- D 3b",70,142]
[233,"Lärche Blochholz B/C/CX D4",66,142]
[234,"Lärche Blochholz B/C/CX D5",55,142]
[235,"Lärche Blochholz B/C/CX D6",46,142]
[236,"Lärche Langholz B/C",85,130]
[237,"Lärche Brennholz weich",10,42]
[238,"Lärche Brennholz hart"]
[239,"Lärche Sonstiges",1,200]
[240,"Lärche Industrieholz 1",5,42]
[241,"Lärche Industrieholz 2",5,42]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Weißkiefer"]
[301,"Weißkiefer Blochholz B",50,80]
[302,"Weißkiefer Blochholz C",35,66]
[303,"Weißkiefer Blochholz B/C",42,79]
[304,"Weißkiefer Blochholz CX",30,67]
[305,"Weißkiefer Blochholz B/C/CX",40,78]
[306,"Weißkiefer Blochholz B D 1a",35,60]
[307,"Weißkiefer Blochholz B D 1b",35,60]
[308,"Weißkiefer Blochholz B D 2a- D 3b",50,80]
[309,"Weißkiefer Blochholz B D4",46,80]
[310,"Weißkiefer Blochholz B D5",35,80]
[311,"Weißkiefer Blochholz B D6",26,80]
[312,"Weißkiefer Blochholz C D 1a",25,52]
[313,"Weißkiefer Blochholz C D 1b",25,52]
[314,"Weißkiefer Blochholz C D 2a- D 3b",35,66]
[315,"Weißkiefer Blochholz C D4",31,66]
[316,"Weißkiefer Blochholz C D5",20,66]
[317,"Weißkiefer Blochholz C D6",11,66]
[318,"Weißkiefer Blochholz B/C D 1a",30,57]
[319,"Weißkiefer Blochholz B/C D 1b",30,57]
[320,"Weißkiefer Blochholz B/C D 2a- D 3b",42,79]
[321,"Weißkiefer Blochholz B/C D4",38,79]
[322,"Weißkiefer Blochholz B/C D5",27,79]
[323,"Weißkiefer Blochholz B/C D6",18,79]
[324,"Weißkiefer Blochholz CX D 1a",20,46]
[325,"Weißkiefer Blochholz CX D 1b",20,46]
[326,"Weißkiefer Blochholz CX D 2a- D 3b",30,67]
[327,"Weißkiefer Blochholz CX D4",26,67]
[328,"Weißkiefer Blochholz CX D5",15,67]
[329,"Weißkiefer Blochholz CX D6",6,67]
[330,"Weißkiefer Blochholz B/C/CX D 1a",25,48]
[331,"Weißkiefer Blochholz B/C/CX D 1b",25,48]
[332,"Weißkiefer Blochholz B/C/CX D 2a- D 3b",40,78]
[333,"Weißkiefer Blochholz B/C/CX D4",36,78]
[334,"Weißkiefer Blochholz B/C/CX D5",25,78]
[335,"Weißkiefer Blochholz B/C/CX D6",16,78]
[336,"Weißkiefer Langholz B/C"]
[337,"Weißkiefer Brennholz weich",10,42]
[338,"Weißkiefer Brennholz hart"]
[339,"Weißkiefer Sonstiges",1,200]
[340,"Weißkiefer Industrieholz 1",5,42]
[341,"Weißkiefer Industrieholz 2",5,42]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Zirbe"]
[401,"Zirbe Blochholz B",85,300]
[402,"Zirbe Blochholz C",70,200]
[403,"Zirbe Blochholz B/C",80,300]
[404,"Zirbe Blochholz CX",50,200]
[405,"Zirbe Blochholz B/C/CX",60,250]
[406,"Zirbe Blochholz B D 1a",65,200]
[407,"Zirbe Blochholz B D 1b",65,200]
[408,"Zirbe Blochholz B D 2a- D 3b",85,300]
[409,"Zirbe Blochholz B D4",81,300]
[410,"Zirbe Blochholz B D5",70,300]
[411,"Zirbe Blochholz B D6",61,300]
[412,"Zirbe Blochholz C D 1a",55,150]
[413,"Zirbe Blochholz C D 1b",55,150]
[414,"Zirbe Blochholz C D 2a- D 3b",70,200]
[415,"Zirbe Blochholz C D4",66,200]
[416,"Zirbe Blochholz C D5",55,200]
[417,"Zirbe Blochholz C D6",46,200]
[418,"Zirbe Blochholz B/C D 1a",60,200]
[419,"Zirbe Blochholz B/C D 1b",60,200]
[420,"Zirbe Blochholz B/C D 2a- D 3b",80,300]
[421,"Zirbe Blochholz B/C D4",76,300]
[422,"Zirbe Blochholz B/C D5",65,300]
[423,"Zirbe Blochholz B/C D6",56,300]
[424,"Zirbe Blochholz CX D 1a",45,130]
[425,"Zirbe Blochholz CX D 1b",45,130]
[426,"Zirbe Blochholz CX D 2a- D 3b",50,200]
[427,"Zirbe Blochholz CX D4",46,200]
[428,"Zirbe Blochholz CX D5",35,200]
[429,"Zirbe Blochholz CX D6",26,200]
[430,"Zirbe Blochholz B/C/CX D 1a",47,130]
[431,"Zirbe Blochholz B/C/CX D 1b",47,130]
[432,"Zirbe Blochholz B/C/CX D 2a- D 3b",60,250]
[433,"Zirbe Blochholz B/C/CX D4",56,250]
[434,"Zirbe Blochholz B/C/CX D5",45,250]
[435,"Zirbe Blochholz B/C/CX D6",36,250]
[436,"Zirbe Langholz B/C"]
[437,"Zirbe Brennholz weich",10,42]
[438,"Zirbe Brennholz hart"]
[439,"Zirbe Sonstiges"]
[440,"Zirbe Industrieholz 1"]
[441,"Zirbe Industrieholz 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Nadelholz"]
[501,"sonst. Nadelholz Blochholz B",50,150]
[502,"sonst. Nadelholz Blochholz C",35,125]
[503,"sonst. Nadelholz Blochholz B/C",42,142]
[504,"sonst. Nadelholz Blochholz CX",30,110]
[505,"sonst. Nadelholz Blochholz B/C/CX",40,142]
[506,"sonst. Nadelholz Blochholz B D 1a",35,90]
[507,"sonst. Nadelholz Blochholz B D 1b",35,90]
[508,"sonst. Nadelholz Blochholz B D 2a- D 3b",50,150]
[509,"sonst. Nadelholz Blochholz B D4",46,150]
[510,"sonst. Nadelholz Blochholz B D5",35,150]
[511,"sonst. Nadelholz Blochholz B D6",26,150]
[512,"sonst. Nadelholz Blochholz C D 1a",25,70]
[513,"sonst. Nadelholz Blochholz C D 1b",25,70]
[514,"sonst. Nadelholz Blochholz C D 2a- D 3b",35,125]
[515,"sonst. Nadelholz Blochholz C D4",31,125]
[516,"sonst. Nadelholz Blochholz C D5",20,125]
[517,"sonst. Nadelholz Blochholz C D6",11,125]
[518,"sonst. Nadelholz Blochholz B/C D 1a",30,90]
[519,"sonst. Nadelholz Blochholz B/C D 1b",30,90]
[520,"sonst. Nadelholz Blochholz B/C D 2a- D 3b",42,142]
[521,"sonst. Nadelholz Blochholz B/C D4",38,142]
[522,"sonst. Nadelholz Blochholz B/C D5",27,142]
[523,"sonst. Nadelholz Blochholz B/C D6",18,142]
[524,"sonst. Nadelholz Blochholz CX D 1a",20,60]
[525,"sonst. Nadelholz Blochholz CX D 1b",20,60]
[526,"sonst. Nadelholz Blochholz CX D 2a- D 3b",30,110]
[527,"sonst. Nadelholz Blochholz CX D4",26,110]
[528,"sonst. Nadelholz Blochholz CX D5",15,110]
[529,"sonst. Nadelholz Blochholz CX D6",6,110]
[530,"sonst. Nadelholz Blochholz B/C/CX D 1a",25,70]
[531,"sonst. Nadelholz Blochholz B/C/CX D 1b",25,70]
[532,"sonst. Nadelholz Blochholz B/C/CX D 2a- D 3b",40,142]
[533,"sonst. Nadelholz Blochholz B/C/CX D4",36,142]
[534,"sonst. Nadelholz Blochholz B/C/CX D5",25,142]
[535,"sonst. Nadelholz Blochholz B/C/CX D6",16,142]
[536,"sonst. Nadelholz Langholz B/C",55,130]
[537,"sonst. Nadelholz Brennholz weich",10,42]
[538,"sonst. Nadelholz Brennholz hart"]
[539,"sonst. Nadelholz Sonstiges",1,200]
[540,"sonst. Nadelholz Industrieholz 1",5,42]
[541,"sonst. Nadelholz Industrieholz 2",5,42]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Laubholz 1"]
[601,"Laubholz 1 Blochholz B",75,135]
[602,"Laubholz 1 Blochholz C",60,80]
[603,"Laubholz 1 Blochholz B/C",60,125]
[604,"Laubholz 1 Blochholz CX",45,70]
[605,"Laubholz 1 Blochholz B/C/CX",55,100]
[606,"Laubholz 1 Blochholz B D 1a"]
[607,"Laubholz 1 Blochholz B D 1b"]
[608,"Laubholz 1 Blochholz B D 2a- D 3b",75,135]
[609,"Laubholz 1 Blochholz B D4",74,135]
[610,"Laubholz 1 Blochholz B D5",60,135]
[611,"Laubholz 1 Blochholz B D6",50,135]
[612,"Laubholz 1 Blochholz C D 1a"]
[613,"Laubholz 1 Blochholz C D 1b"]
[614,"Laubholz 1 Blochholz C D 2a- D 3b",60,80]
[615,"Laubholz 1 Blochholz C D4",56,80]
[616,"Laubholz 1 Blochholz C D5",45,80]
[617,"Laubholz 1 Blochholz C D6",36,80]
[618,"Laubholz 1 Blochholz B/C D 1a"]
[619,"Laubholz 1 Blochholz B/C D 1b"]
[620,"Laubholz 1 Blochholz B/C D 2a- D 3b",60,125]
[621,"Laubholz 1 Blochholz B/C D4",56,125]
[622,"Laubholz 1 Blochholz B/C D5",45,125]
[623,"Laubholz 1 Blochholz B/C D6",36,125]
[624,"Laubholz 1 Blochholz CX D 1a"]
[625,"Laubholz 1 Blochholz CX D 1b"]
[626,"Laubholz 1 Blochholz CX D 2a- D 3b",45,70]
[627,"Laubholz 1 Blochholz CX D4",41,70]
[628,"Laubholz 1 Blochholz CX D5",30,70]
[629,"Laubholz 1 Blochholz CX D6",21,70]
[630,"Laubholz 1 Blochholz B/C/CX D 1a"]
[631,"Laubholz 1 Blochholz B/C/CX D 1b"]
[632,"Laubholz 1 Blochholz B/C/CX D 2a- D 3b",55,100]
[633,"Laubholz 1 Blochholz B/C/CX D4",51,100]
[634,"Laubholz 1 Blochholz B/C/CX D5",40,100]
[635,"Laubholz 1 Blochholz B/C/CX D6",31,100]
[636,"Laubholz 1 Langholz B/C"]
[637,"Laubholz 1 Brennholz weich"]
[638,"Laubholz 1 Brennholz hart",12,65]
[639,"Laubholz 1 Sonstiges"]
[640,"Laubholz 1 Industrieholz 1",15,64]
[641,"Laubholz 1 Industrieholz 2",15,64]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Laubholz 2"]
[701,"Laubholz 2 Blochholz B",75,135]
[702,"Laubholz 2 Blochholz C",60,80]
[703,"Laubholz 2 Blochholz B/C",60,125]
[704,"Laubholz 2 Blochholz CX",45,70]
[705,"Laubholz 2 Blochholz B/C/CX",55,100]
[706,"Laubholz 2 Blochholz B D 1a"]
[707,"Laubholz 2 Blochholz B D 1b"]
[708,"Laubholz 2 Blochholz B D 2a- D 3b",75,135]
[709,"Laubholz 2 Blochholz B D4",74,135]
[710,"Laubholz 2 Blochholz B D5",60,135]
[711,"Laubholz 2 Blochholz B D6",50,135]
[712,"Laubholz 2 Blochholz C D 1a"]
[713,"Laubholz 2 Blochholz C D 1b"]
[714,"Laubholz 2 Blochholz C D 2a- D 3b",60,80]
[715,"Laubholz 2 Blochholz C D4",56,80]
[716,"Laubholz 2 Blochholz C D5",45,80]
[717,"Laubholz 2 Blochholz C D6",36,80]
[718,"Laubholz 2 Blochholz B/C D 1a"]
[719,"Laubholz 2 Blochholz B/C D 1b"]
[720,"Laubholz 2 Blochholz B/C D 2a- D 3b",60,125]
[721,"Laubholz 2 Blochholz B/C D4",56,125]
[722,"Laubholz 2 Blochholz B/C D5",45,125]
[723,"Laubholz 2 Blochholz B/C D6",36,125]
[724,"Laubholz 2 Blochholz CX D 1a"]
[725,"Laubholz 2 Blochholz CX D 1b"]
[726,"Laubholz 2 Blochholz CX D 2a- D 3b",45,70]
[727,"Laubholz 2 Blochholz CX D4",41,70]
[728,"Laubholz 2 Blochholz CX D5",30,70]
[729,"Laubholz 2 Blochholz CX D6",21,70]
[730,"Laubholz 2 Blochholz B/C/CX D 1a"]
[731,"Laubholz 2 Blochholz B/C/CX D 1b"]
[732,"Laubholz 2 Blochholz B/C/CX D 2a- D 3b",55,100]
[733,"Laubholz 2 Blochholz B/C/CX D4",51,100]
[734,"Laubholz 2 Blochholz B/C/CX D5",40,100]
[735,"Laubholz 2 Blochholz B/C/CX D6",31,100]
[736,"Laubholz 2 Langholz B/C"]
[737,"Laubholz 2 Brennholz weich"]
[738,"Laubholz 2 Brennholz hart",12,65]
[739,"Laubholz 2 Sonstiges"]
[740,"Laubholz 2 Industrieholz 1",15,64]
[741,"Laubholz 2 Industrieholz 2",15,64]

{"sheet":"Tabelle1","index":5,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[1,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Werte(\",$A1,\") = \")","v":"Werte(1) = "},{"$f":"CONCATENATE(\"\"\"#\",B1,\"#\"\"\")","v":"\"#3#\""}]
[2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Werte(\",$A2,\") = \")","v":"Werte(2) = "},{"$f":"CONCATENATE(\"\"\"#\",B2,\"#\"\"\")","v":"\"#3#\""}]
[3,"1#2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(3) = ","\"#1#2#\""]
[4,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(4) = ","\"#5#\""]
[5,"1#2#3#4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(5) = ","\"#1#2#3#4#\""]
[6,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(6) = ","\"#18#\""]
[7,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(7) = ","\"#19#\""]
[8,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(8) = ","\"#20#\""]
[9,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(9) = ","\"#21#\""]
[10,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(10) = ","\"#22#\""]
[11,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(11) = ","\"#23#\""]
[12,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(12) = ","\"#18#\""]
[13,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(13) = ","\"#19#\""]
[14,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(14) = ","\"#20#\""]
[15,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(15) = ","\"#21#\""]
[16,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(16) = ","\"#22#\""]
[17,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(17) = ","\"#23#\""]
[18,"6#12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(18) = ","\"#6#12#\""]
[19,"7#13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(19) = ","\"#7#13#\""]
[20,"8#14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(20) = ","\"#8#14#\""]
[21,"9#15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(21) = ","\"#9#15#\""]
[22,"10#16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(22) = ","\"#10#16#\""]
[23,"11#17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(23) = ","\"#11#17#\""]
[24,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(24) = ","\"#30#\""]
[25,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(25) = ","\"#31#\""]
[26,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(26) = ","\"#32#\""]
[27,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(27) = ","\"#33#\""]
[28,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(28) = ","\"#34#\""]
[29,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(29) = ","\"#35#\""]
[30,"6#12#18#24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(30) = ","\"#6#12#18#24#\""]
[31,"7#13#19#25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(31) = ","\"#7#13#19#25#\""]
[32,"8#14#20#26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(32) = ","\"#8#14#20#26#\""]
[33,"9#15#21#27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(33) = ","\"#9#15#21#27#\""]
[34,"10#16#22#28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(34) = ","\"#10#16#22#28#\""]
[35,"11#17#23#29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(35) = ","\"#11#17#23#29#\""]
[36,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(36) = ","\"#0#\""]
[37,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(37) = ","\"#0#\""]
[38,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(38) = ","\"#0#\""]
[39,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(39) = ","\"#0#\""]
[40,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(40) = ","\"#0#\""]
[41,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte(41) = ","\"#0#\""]

{"sheet":"Hilfe","index":6,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Anleitung zum Register \"Info zur Holzpartie\""]
["Auf diesem Register müssen die grundsätzlichen Parameter wie Holzmenge je Baumart, Sortimentsverteilung und allfällige Stärkeklassenverteilungen erfasst werden. Fehlt die Holzmenge oder ergeben die eingegebenen Anteile nicht 100% erhält man eine Fehlermeldung!\nDabei können auch unterschiedliche Varianten (= Schätzungen) erfasst werden, um dann die Auswirkung dieser Unterschiede auf den Ertrag dargestellt zu bekommen."]
["Die Sortimente B und C bzw. B/C können alternativ erfasst werden. Ebenso kann CX in Kombination mit den Sortimenten B,C, oder B/C getrennt erfasst werden oder das Mischsortiment B/C/CX eingegeben werden.\nDas Sortiment  \"Brennholz hart\" ist nur für Laubholz verfügbar, das Sortiment \"Sonstiges\" kann für beliebige andere Sortiment verwendet werden.\nDie erfasste Sortimentsverteilung muss 100% ergeben!"]
["Die Eingabe der  Stärkeklassen für die Blochholzanteile ist optional je Baumart. Diese Option ist für stärkeklassenbezogene Angebote gedacht.\n Wenn ein Stärkeklassenfeld erfasst wurde, muss die Summe aller Stärkeklassen einer Baumart 100% ergeben! Die Sortimente Langholz B/C, Brennholz weich und hart, Sonstiges und Industrieholz 1 und 2 werden nicht in die Stärkeklassenverteilung einbezogen."]
["Sobald im Register \"Angebotsdaten\" Daten erfasst werden, erscheint  am Register \"Infos zur Holzpartie\" ein Knopf  \"Tabellenblatt zur Bearbeitung freigeben(Angebotsdaten und Angebotsvergleich löschen)\". \nNunmehr können im Register \"Infos zur Holzpartie\" nur mehr bestehende Werte verändert werden. Der Knopf  \"Tabellenblatt zur Bearbeitung freigeben(Angebotsdaten und Angebotsvergleich löschen)\" muss dafür nicht gedrückt werden. Es entstehen keien neuen Kombinationen, die Ergebnisse werden automatisch korrigiert.\nNeue zusätzliche Werte können nur erfasst werden, nachdem der Knopf  \"Tabellenblatt zur Bearbeitung freigeben(Angebotsdaten und Angebotsvergleich löschen)\" gedrückt wurde.  Dabei werden die erfassten Daten auf den Registern  \"Angebotsdaten\" und \"Angebotsvergleich\" gelöscht, da neue Kombinationen und damit neue Ergebnisse entstehen!"]
["Unter dem Formular kann über den Knopf \"Variante 2 ergänzen\" eine zusätzliche Schätzvariante für die gleiche Holzpartie angelegt werden. Dabei können die ursprünglichen Daten übernommen  oder eine leere Variante generiert werden.  Dies ist in weiterer Folge für beliebig viele Varianten möglich."]
["Mit dem Knopf \"Varianten löschen\", der immer unter der Variante 1 zu finden ist, werden alle Varianten gelöscht!"]
[]
["Anleitung zum Register \"Angebotsdaten\""]
["In diesem Register müssen die Preise der ausgewiesenen Sortimente/Stärkeklassen je Baumart erfasst werden.\nDafür können maximal 5 Anbieter (=Käufer) angegeben werden. Sollte der Angebotsvergleich für mehr Angebote benötigt werden, so müssen diese auf mehrere Dateien aufgeteilt werden."]
["Neben den Holzpreisen kann angegeben werden, ob die angebotenen Preise eines Anbieters Bruttopreise sind, zusätzlich können optional Erntekosten erfasst werden (Vorrückung, Schlägerung und Lieferung)"]
["Über den Knopf \"Preistabelle auf Basis des Reiters \"Infos zur Holzpartie\" erstellen bzw. aktualisieren\" wird eine Preistabelle erstellt, in der für jede vorkommende Kombination aus Holzart, Sortiment/Güte und Stärkeklasse eine eigene Zeile in dieser Preistabelle erzeugt wird.\n"]
[]
["Für jeden eingetragenen Käufer ist eine eigene Spalte in dieser Preistabelle vorgesehen.\n In der Zeile müssen die Angebotspreise der einzelnen Anbieter eingetragen werden. Über das Komentarfeld der jeweiligen Gruppierung wird angezeigt, in welchen Varianten die generierte Kombination vorkommt.\nBei erfolgter Preiseingabe werden Zellen  innerhalb eines Käufers gelb markiert, für die auf Grund der schon getätigten Preiseingaben eine Eingabe für unlogisch erachtet scheint.\nAlle notwendigen Preise müssen ausgefüllt werden, damit ein Angebotsvergleich erstellt werden kann, sonst erhält man eine Fehlermeldung!"]
[]
["Nach Befüllen der Preistabelle kann zum Tabellenblatt \"Angebotsvergleich\" gewechselt werden"]
["Falls die Eingaben in den Angebotsdaten geändert werden sollten, muss der Knopf \"Tabellenblatt zur Bearbeitung freigeben (Angebotsvergleich löschen)\" gedrückt werden. Das Datenblatt Angebotsdaten kann nun bearbeitet werden. Die Daten im Angebotsvergleich werden wieder gelöscht."]
["Anleitung zum Register Angebotsvergleich"]
["Durch das Klicken auf den Knopf \"Angebote-Auswerten erstellen bzw. aktualisieren\" werden die Agebotsdaten vom vorherigen Register automatisch berechnet und aufgelistet. Die Auflistung erfolgt von der Bruttosumme über den Abzug der Mehrwertsteuer und der Erntekosten bis hin zum Erntekostenfreien Erlös als Ergebnis."]
[]
["Um Änderungen im Angebotsvergleich zu erreichen müssen diese im entsprechenden Tabellenblatt vorgenommen werden. Änderungen im Tabellenblatt \"Angebotsdaten\" können über eine Korrektur und erneutes Anklicken von \"Angebote-Auswertung erstellen bzw. aktualisieren\" erreicht werden. Um Änderungen im Tabellenblatt \"Infos zur Holzpartie\" zu erhalten müssen die bisherigen Daten gelöscht und neu eingegeben werden. Dazu ist \"Datenblatt zur Bearbeitung freigeben\" am Tabellenblatt \"Infos zur Holzpartie\" anzuklicken und die korrigierten Daten erneut einzugeben."]