{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Analiza 1","Analiza 2","Analiza 3","Analiza 4","Analiza 5","Analiza 6","Analiza 7","Analiza 8","Kontrola","Klasifikacija"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Analiza 1","index":0,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,"P16 / P16S",null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Analiza 2","index":1,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,{"$f":"'Analiza 1'!ZielGroessenklasse","v":"P16 / P16S"},null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Analiza 3","index":2,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,{"$f":"'Analiza 1'!ZielGroessenklasse","v":"P16 / P16S"},null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Analiza 4","index":3,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,{"$f":"'Analiza 1'!ZielGroessenklasse","v":"P16 / P16S"},null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Analiza 5","index":4,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,{"$f":"'Analiza 1'!ZielGroessenklasse","v":"P16 / P16S"},null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Analiza 6","index":5,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,{"$f":"'Analiza 1'!ZielGroessenklasse","v":"P16 / P16S"},null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Analiza 7","index":6,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,{"$f":"'Analiza 1'!ZielGroessenklasse","v":"P16 / P16S"},null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Analiza 8","index":7,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,14,0,16],[1,0,1,7],[2,0,2,7],[3,6,3,7],[4,6,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,7],[8,1,8,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,11,15,16],[16,1,16,3],[16,5,16,6],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,6],[19,0,19,1],[19,5,19,6],[20,0,20,3],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,0,23,7],[24,0,24,7],[25,2,25,3],[25,5,25,7],[26,5,26,6],[27,5,27,6],[28,0,28,7],[29,1,29,7],[30,0,30,8],[26,0,27,0],[3,4,4,4],[8,4,22,4],[25,4,27,4],[0,8,29,8],[3,0,4,1],[3,2,4,3],[21,0,22,3]]}
["Kontrola kvaliteta drvne sečke",{"$nulls":10},"Sitna frakcija\n< 3,15 mm","Klasa",null,"proračun sadržaja vode"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4",{"$nulls":10},"[%]",null,null,"Min sadrzaj vode","Max sadrzaj vode","klasa"]
[{"$nulls":11},0,"F05 manuelno",null,"%","%"]
["Oznaka uzorka",{"$nulls":4},"Uzorak obradio",{"$nulls":5},0.050001,"F10 manuelno",null,1e-5,0.1,"M10"]
[{"$nulls":5},"Datum",{"$nulls":5},0.100001,"F15 manuelno",null,0.1001,0.15,"M15"]
[{"$nulls":11},0.150001,"F20 manuelno",null,0.1501,0.2,"M20"]
["Manuelno prosejavanje",null,"po uzoru na \nSPRS EN ISO 17827-1",null,null,"Predviđena klasa veličina frakcija:",null,{"$f":"'Analiza 1'!ZielGroessenklasse","v":"P16 / P16S"},null,null,null,0.200001,"F25 manuelno",null,0.2001,0.25,"M25"]
[{"$nulls":11},0.250001,"F30 manuelno",null,0.2501,0.3,"M30"]
["Sito","Težine  pojedinačnih određivanja",null,null,null,"Veličina čestica",null,"Rezultat",null,null,null,0.300001,"F30+ manuelno",null,0.3001,0.35,"M35"]
[null,"Prazno sito","deo uzorka 1","deo uzorka  2",null,"mm",null,"Udeo (m-%)",{"$nulls":6},0.3501,0.4,"M40"]
["mm","(g)","(g)","(g)",null,"< 3,15",null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",(C13-B13)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C13-$B13,$D13-$B13)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},null,null,null,"Lista za selekciju za nameravanu klasu veličina frakcija:","P16 / P16S",null,0.4001,0.45,"M45"]
["Ukupni uzorak",{"$nulls":4}," 3,15 do ",{"$f":"IF(H7=\"P16 / P16S\",16,IF(H7=\"P31 / P31S\",31.5,IF(H7=\"P45 / P45S\",45,\"---\")))","v":16},{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",(C14-B14)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C14-$B14,$D14-$B14)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P31 / P31S",null,0.4501,0.5,"M50"]
["Posuda za prihvat",{"$nulls":4},{"$f":"G12","v":16},100,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",(C15-B15)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C15-$B15,$D15-$B15)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":""},{"$nulls":4},"P45 / P45S",null,0.5001,0.55,"M55"]
["Sito 3,15 mm",{"$nulls":4},"> 100",null,{"$f":"IF(C16=\"\",\"---\",IF(D16=\"\",(C16-B16)/SUM($C$13-$B$13,$C$14-$B$14,$C$15-$B$15,$C$16),SUM($C16-$B16,$D16-$B16)/(SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))))","v":"---"},{"$nulls":6},0.5501,0.6,"M55+"]
[{"$f":"G12","v":16},{"$nulls":4},"Najduži komad (mm)",null,{"$f":"IF(AND(C18=\"\",D18=\"\"),\"---\",MAX(C18:D18))","v":"---"}]
["> 100 mm *",{"$nulls":4},"Max. površina poprečnog preseka (cm²)",null,{"$f":"IF(AND(C19=\"\",D19=\"\"),\"---\",MAX(C19:D19))","v":"---"},null,null,null,"Procena SRPS EN ISO 17225-1 / -4"]
["Prevelike veličine",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"N25","v":""},null,null,null,"P16S","P16","P31S","P31","P45S","P45"]
["Najduži komad (mm)",{"$nulls":4},"Klasifikacija po uzoru na SPRS EN ISO 17225-1:"]
["Max. površina poprečnog preseka (cm2)",{"$nulls":4},"Klasa veličina frakcija ",null,{"$f":"IF(H11=\"\",\"\",N27)","v":""},null,null,"Sitna frakcija",{"$f":"IF($H11<=0.15,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0},null,{"$f":"IF($H11<=0.1,1,0)","v":0}]
["Kontrola gubitaka u situ",null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",INT(1000*(SUM(C13-B13,C14-B14,C15-B15,C16)-C12)/C12)/1000,INT(1000*((((SUM($C$13-$B$13,$D$13-$B$13,$C$14-$B$14,$D$14-$B$14,$C$15-$B$15,$D$15-$B$15,$C$16-$B$16,$D$16-$B$16))-(SUM(C12:D12)))/(SUM(C12:D12)))))/1000))","v":""},{"$f":"IF(C20=\"\",\"\",IF(ABS(C20)<0.02,\"o.k.\",\"Preveliko odstupanje!\"))","v":""},null,"Sitna frakcija",null,{"$f":"IF(H11=\"\",\"\",VLOOKUP($H$11,$L$3:$M$9,2))","v":""},null,null,"Glavna frakcija",{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P16 / P16S\",IF($H12>=0.6,1,0),0)","v":1},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P31 / P31S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0},{"$f":"IF($H$7=\"P45 / P45S\",IF($H12>=0.6,1,0),0)","v":0}]
["*manuelno sortiranje",{"$nulls":4},{"$f":"N26","v":""},{"$nulls":4},"Preduga čestica",{"$f":"IF($H15=\"---\",1,IF($H15<=45,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=150,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=200,1,0))","v":1},{"$f":"IF($H15=\"---\",1,IF($H15<=350,1,0))","v":1}]
[{"$nulls":5},{"$f":"IF(OR(H17=\"n. kl.\",H19=\"n. kl.\"),\"n. kl.        neklasifikovan\",\"\")","v":""},{"$nulls":4},"Poprečni presek",{"$f":"IF($C19=\"---\",1,IF($C19<=2,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=4,1,0))","v":1},null,{"$f":"IF($C19=\"---\",1,IF($C19<=6,1,0))","v":1}]
[{"$nulls":10},"Krupna frakcija",{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.06,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""},{"$f":"IF((SUM(H13:H14))<=0.1,\"\",\"Moguće prekoračenje maksimalno dozvoljenog udela krupne frakcije\")","v":""}]
["Sadržaj vode (metod pećnice ) u skladu sa  SPRS EN ISO 18134-2",{"$nulls":9},"Klasa",{"$f":"IF((SUM(L18:L22)/COUNT(L18:L22))<1,\"n. kl.\",\"P16S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(M18:M22)/COUNT(M18:M22))<1,\"n. kl.\",\"P16 manuelno\")","v":"P16 manuelno"},{"$f":"IF((SUM(N18:N22)/COUNT(N18:N22))<1,\"n. kl.\",\"P31S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(O18:O22)/COUNT(O18:O22))<1,\"n. kl.\",\"P31 manuelno\")","v":"n. kl."},{"$f":"IF((SUM(P18:P22)/COUNT(P18:P22))<1,\"n. kl.\",\"P45S manuelno\")","v":"n. kl."},{"$f":"IF((SUM(Q18:Q22)/COUNT(Q18:Q22))<1,\"n. kl.\",\"P45 manuelno\")","v":"n. kl."}]
[{"$nulls":10},"17225-4-Klasa za izveštaj:",null,null,{"$f":"IF(H12=\"\",\"\",IF($L$24<>\"n. kl.\",$L$24,IF($N$24<>\"n. kl.\",$N$24,IF($P$24<>\"n. kl.\",$P$24,\"n. kl.\"))))","v":""}]
["Merenje","Pleh za pečenje","Pleh za pečenje sa",{"$nulls":7},"Napomena -prekoračenje grubih čestica",null,null,{"$f":"IF(N27=\"P16S manuelno\",L23,IF(N27=\"P16 manuelno\",M23,IF(N27=\"P31S manuelno\",N23,IF(N27=\"P31 manuelno\",O23,IF(N27=\"P45S manuelno\",P23,IF(N27=\"P45 manuelno\",Q23,IF(N27=\"P63 manuelno\",R23,\"\")))))))","v":""}]
[null,"prazan\n(g)","svež uzorak\n(g)","osušen uzorak\n(g)",null,"Sadržaj vode (m-%)",null,{"$f":"IF(OR(C28=\"\",C28=D28,D28>C28),\"\",1-((D28-B28)/(C28-B28)))","v":""},null,null,"17225-1-Klasa za izveštaj:",null,null,{"$f":"IF($L$24<>\"n. kl.\",$L$24,IF($M$24<>\"n. kl.\",$M$24,IF($N$24<>\"n. kl.\",$N$24,IF($O$24<>\"n. kl.\",$O$24,IF($P$24<>\"n. kl.\",$P$24,IF($Q$24<>\"n. kl.\",$Q$24,\"n. kl.\"))))))","v":"P16 manuelno"},{"$f":"IF($N25=\"P16S manuelno\",$L23,IF($N25=\"P16 manuelno\",$M23,IF($N25=\"P31S manuelno\",$N23,IF($N25=\"P31 manuelno\",$O23,IF($N25=\"P45S manuelno\",$P23,IF($N25=\"P45 manuelno\",$Q23,IF($N25=\"P63 manuelno\",$R23,\"\")))))))","v":""}]
[{"$nulls":5},"Klasa sečke u odnosu na sadržaj vode",null,{"$f":"IF(H27=\"\",\"\",VLOOKUP($H$27,$O$4:$Q$14,3))","v":""}]
[]
["Napomena"]
["Razvijeno od strane(HAWK) Getingen (visoka škola za primenjenu nauku). Sve informacije i proračuni su bez garancije."]

{"sheet":"Kontrola","index":8,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[5,0,5,2],[6,0,6,2],[7,1,7,2],[8,1,8,2],[11,1,11,2],[18,0,18,10],[21,0,21,10],[22,0,22,2],[23,1,23,11],[24,1,24,11],[25,1,25,11],[26,0,26,11],[10,0,11,0],[0,11,22,11],[2,0,3,10]]}
["Kontrola kvaliteta drvne sečke"]
["Pojednostavljene analize po uzoru na SRPS EN ISO 17225-4"]
[]
[]
["Uzorak-Br.",null,null,1,2,3,4,5,6,7,8]
["Oznaka",null,null,{"$f":"IF('Analiza 1'!C4=\"\",\"\",'Analiza 1'!C4)","v":""},{"$f":"IF('Analiza 2'!C4=\"\",\"\",'Analiza 2'!C4)","v":""},{"$f":"IF('Analiza 3'!C4=\"\",\"\",'Analiza 3'!C4)","v":""},{"$f":"IF('Analiza 4'!C4=\"\",\"\",'Analiza 4'!C4)","v":""},{"$f":"IF('Analiza 5'!C4=\"\",\"\",'Analiza 5'!C4)","v":""},{"$f":"IF('Analiza 6'!C4=\"\",\"\",'Analiza 6'!C4)","v":""},{"$f":"IF('Analiza 7'!C4=\"\",\"\",'Analiza 7'!C4)","v":""},{"$f":"IF('Analiza 8'!C4=\"\",\"\",'Analiza 8'!C4)","v":""}]
["Datum analize",null,null,{"$f":"IF('Analiza 1'!G5=\"\",\"\",'Analiza 1'!G5)","v":""},{"$f":"IF('Analiza 2'!G5=\"\",\"\",'Analiza 2'!G5)","v":""},{"$f":"IF('Analiza 3'!G5=\"\",\"\",'Analiza 3'!G5)","v":""},{"$f":"IF('Analiza 4'!G5=\"\",\"\",'Analiza 4'!G5)","v":""},{"$f":"IF('Analiza 5'!G5=\"\",\"\",'Analiza 5'!G5)","v":""},{"$f":"IF('Analiza 6'!G5=\"\",\"\",'Analiza 6'!G5)","v":""},{"$f":"IF('Analiza 7'!G5=\"\",\"\",'Analiza 7'!G5)","v":""},{"$f":"IF('Analiza 8'!G5=\"\",\"\",'Analiza 8'!G5)","v":""}]
["Frakcija","Veličina frakcije",null,"(m-%)","(m-%)","(m-%)","(m-%)","(m-%)","(m-%)","(m-%)","(m-%)"]
["Sitna frakcija","< 3,15 mm",null,{"$f":"'Analiza 1'!H11","v":""},{"$f":"'Analiza 2'!H11","v":""},{"$f":"'Analiza 3'!H11","v":""},{"$f":"'Analiza 4'!H11","v":""},{"$f":"'Analiza 5'!H11","v":""},{"$f":"'Analiza 6'!H11","v":""},{"$f":"'Analiza 7'!H11","v":""},{"$f":"'Analiza 8'!H11","v":""}]
["Glavna frakcija","3,15 mm do",{"$f":"'Analiza 1'!G12","v":16},{"$f":"'Analiza 1'!H12","v":""},{"$f":"'Analiza 2'!H12","v":""},{"$f":"'Analiza 3'!H12","v":""},{"$f":"'Analiza 4'!H12","v":""},{"$f":"'Analiza 5'!H12","v":""},{"$f":"'Analiza 6'!H12","v":""},{"$f":"'Analiza 7'!H12","v":""},{"$f":"'Analiza 8'!H12","v":""}]
["Gruba frakcija",{"$f":"C10","v":16},"100 mm",{"$f":"'Analiza 1'!H13","v":""},{"$f":"'Analiza 2'!H13","v":""},{"$f":"'Analiza 3'!H13","v":""},{"$f":"'Analiza 4'!H13","v":""},{"$f":"'Analiza 5'!H13","v":""},{"$f":"'Analiza 6'!H13","v":""},{"$f":"'Analiza 7'!H13","v":""},{"$f":"'Analiza 8'!H13","v":""}]
[null,"> 100 mm",null,{"$f":"'Analiza 1'!H14","v":"---"},{"$f":"'Analiza 2'!H14","v":"---"},{"$f":"'Analiza 3'!H14","v":"---"},{"$f":"'Analiza 4'!H14","v":"---"},{"$f":"'Analiza 5'!H14","v":"---"},{"$f":"'Analiza 6'!H14","v":"---"},{"$f":"'Analiza 7'!H14","v":"---"},{"$f":"'Analiza 8'!H14","v":"---"}]
["Veliki komad (mm)",null,null,{"$f":"'Analiza 1'!H15","v":"---"},{"$f":"'Analiza 2'!H15","v":"---"},{"$f":"'Analiza 3'!H15","v":"---"},{"$f":"'Analiza 4'!H15","v":"---"},{"$f":"'Analiza 5'!H15","v":"---"},{"$f":"'Analiza 6'!H15","v":"---"},{"$f":"'Analiza 7'!H15","v":"---"},{"$f":"'Analiza 8'!H15","v":"---"}]
["Max. površina poprečnog preseka(cm2)",null,null,{"$f":"'Analiza 1'!H16","v":"---"},{"$f":"'Analiza 2'!H16","v":"---"},{"$f":"'Analiza 3'!H16","v":"---"},{"$f":"'Analiza 4'!H16","v":"---"},{"$f":"'Analiza 5'!H16","v":"---"},{"$f":"'Analiza 6'!H16","v":"---"},{"$f":"'Analiza 7'!H16","v":"---"},{"$f":"'Analiza 8'!H16","v":"---"}]
["Klasifikacija veličine frakcija",null,null,{"$f":"'Analiza 1'!H17","v":""},{"$f":"'Analiza 2'!H17","v":""},{"$f":"'Analiza 3'!H17","v":""},{"$f":"'Analiza 4'!H17","v":""},{"$f":"'Analiza 5'!H17","v":""},{"$f":"'Analiza 6'!H17","v":""},{"$f":"'Analiza 7'!H17","v":""},{"$f":"'Analiza 8'!H17","v":""}]
["Klasifikacija po SRPS EN ISO 17225-1"]
["Klasifikacija veličine frakcija",null,null,{"$f":"'Analiza 1'!H19","v":""},{"$f":"'Analiza 2'!H19","v":""},{"$f":"'Analiza 3'!H19","v":""},{"$f":"'Analiza 4'!H19","v":""},{"$f":"'Analiza 5'!H19","v":""},{"$f":"'Analiza 6'!H19","v":""},{"$f":"'Analiza 7'!H19","v":""},{"$f":"'Analiza 8'!H19","v":""}]
["Klasifikacija sitne frakcije",null,null,{"$f":"'Analiza 1'!H20","v":""},{"$f":"'Analiza 2'!H20","v":""},{"$f":"'Analiza 3'!H20","v":""},{"$f":"'Analiza 4'!H20","v":""},{"$f":"'Analiza 5'!H20","v":""},{"$f":"'Analiza 6'!H20","v":""},{"$f":"'Analiza 7'!H20","v":""},{"$f":"'Analiza 8'!H20","v":""}]
[]
["Sadržaj vode",null,null,{"$f":"'Analiza 1'!H27","v":""},{"$f":"'Analiza 2'!H27","v":""},{"$f":"'Analiza 3'!H27","v":""},{"$f":"'Analiza 4'!H27","v":""},{"$f":"'Analiza 5'!H27","v":""},{"$f":"'Analiza 6'!H27","v":""},{"$f":"'Analiza 7'!H27","v":""},{"$f":"'Analiza 8'!H27","v":""}]
["Klasa sečke u odnosu na sadržaj vode",null,null,{"$f":"'Analiza 1'!H28","v":""},{"$f":"'Analiza 2'!H28","v":""},{"$f":"'Analiza 3'!H28","v":""},{"$f":"'Analiza 4'!H28","v":""},{"$f":"'Analiza 5'!H28","v":""},{"$f":"'Analiza 6'!H28","v":""},{"$f":"'Analiza 7'!H28","v":""},{"$f":"'Analiza 8'!H28","v":""}]
[]
["Napomena:",null,null,{"$f":"IF('Analiza 1'!B30=\"\",\"\",\"Pogledaj napomenu analize 1\")","v":""},{"$f":"IF('Analiza 2'!B30=\"\",\"\",\"Pogledaj napomenu analize 2\")","v":""},{"$f":"IF('Analiza 3'!B30=\"\",\"\",\"Pogledaj napomenu analize 3\")","v":""},{"$f":"IF('Analiza 4'!B30=\"\",\"\",\"Pogledaj napomenu analize 4\")","v":""},{"$f":"IF('Analiza 5'!B30=\"\",\"\",\"Pogledaj napomenu analize 5\")","v":""},{"$f":"IF('Analiza 6'!B30=\"\",\"\",\"Pogledaj napomenu analize 6\")","v":""},{"$f":"IF('Analiza 7'!B30=\"\",\"\",\"Pogledaj napomenu analize 7\")","v":""},{"$f":"IF('Analiza 8'!B30=\"\",\"\",\"Pogledaj napomenu analize 8\")","v":""}]
["     n. kl.    ","neklasifikovan"]
["     ---","neodređen"]
["Uputstvo: ","Prekoračenje maksimalno dozvoljenih Grubih frakcija je moguće, pogledati pojedinačne vrednosti.\nTabele primeniti samo za uzorke koji imaju istu Glavnu frakciju (prilagođene za uzorak 1)."]
[" Sve informacije i proračuni su bez garancije"]

{"sheet":"Klasifikacija","index":9,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,1],[6,2,6,3],[6,5,6,7],[7,2,7,3],[8,2,8,3],[9,0,9,1],[9,2,9,3],[10,0,10,1],[10,2,10,3],[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[13,0,13,1],[13,2,13,3],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3],[16,0,16,7],[17,0,17,7],[18,1,18,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[23,1,23,7],[24,1,24,7],[25,0,25,7],[26,0,26,7],[27,0,27,7],[28,0,28,7],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[31,0,31,1],[31,2,31,3],[32,0,32,1],[32,2,32,3],[33,0,33,1],[33,2,33,3],[34,0,34,1],[34,2,34,3],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,0,39,7],[21,0,22,0],[7,5,8,5],[7,6,8,6],[7,7,8,7],[0,8,39,8],[7,0,8,1],[29,4,38,7],[37,0,38,1]]}
["Kontrola kvaliteta drvne secke"]
["Pojednostavljene analize po uzoru na  SRPS EN ISO 17225-4"]
[]
["Kriterijumi za klasifikaciju klasa veličine frakcija drvne sečke"]
["posle manuelnog prosejavanja (po uzoru na SRPS EN ISO 17225-1 /-4)"]
[]
["Klasa a)",null,"Glavna frakcija",null,"Udeo sitne frakcije b)","Krupna frakcija"]
[null,null,"mm",null,"m-%","Krupna frakcija, m-%c) (dužina jedne čestice, mm)","max. dužina čestice, mm","max.površina poprečnog preseka, cm2 d)"]
[null,null,"(> 60 % mase)",null,"( < 3,15 mm)"]
["P16S manuelno",null,"3,15 mm < P ≤ 16 mm",null,"≤ 15 %","≤ 6 % > 31,5 mm","≤ 45 mm","≤ 2 cm2"]
["P16 manuelno",null,"3,15 mm < P ≤ 16 mm",null,"---","≤ 6 % > 31,5 mm","≤ 150 mm","---"]
["P31S manuelno",null,"3,15 mm < P ≤ 31,5 mm",null,"≤ 10 %","≤ 6 % > 45 mm","≤ 150 mm","≤ 4 cm2"]
["P31 manuelno",null,"3,15 mm < P ≤ 31,5 mm",null,"---","≤ 6 % > 45 mm","≤ 200 mm","---"]
["P45S manuelno",null,"3,15 mm < P ≤ 45 mm",null,"≤ 10 %","≤ 10 % > 63 mm","≤ 200 mm","≤ 6 cm2"]
["P45 manuelno",null,"3,15 mm < P ≤ 45 mm",null,"---","≤ 10 % > 63 mm","≤ 350 mm","---"]
["P63 manuelno",null,"3,15 mm < P ≤ 63 mm",null,"---","≤ 10 % > 100 mm","≤ 350 mm","---"]
[]
["Napomene:"]
["P","Klasa veličina frakcije, vezano za čestice, koje se uklapaju u otvore na situ odgovarajuće veličine. Masa stvarnih frakcija može odstupati od ove, naročito u pogledu dužine."]
["---","Nije definisano u SRPS EN ISO 17225-1 i -4"]
["a)","SRPS EN ISO 17225-1 ostale klase vodi na (P100 do P300)"]
["b)","Granice za udeo sitne frakcije navedene su samo u SRPS EN ISO 17225-4 ;"]
[null,"prema SRPS EN ISO 17225-1 sitna frakcija se odvojeno navodi"]
["c)","Kod manuelnog prosejavanja različite frakcije se ne razlikuju između gornje granice glavne frakcije i 100 mm. U slučaju prekoračenja u skladu sa granicom navedenom u SRPS EN ISO 17225-1 izdaje se odgovarajuća napomena"]
["d)","Poprečna površina se utvrđuje samo za čestice krupne frakcije"]
[]
["Kriterijumi za klasifikaciju klasa veličina frakcija drvne sečke "]
["posle manuelnog prosejavanja (kriterijumi identični sa SRPS EN ISO 17225-1 )"]
[]
["Klasa",null,"Sitna frakcija"]
[null,null,"< 3,15 mm (m-%)"]
["F05 manuelno",null,"≤ 5 %"]
["F10 manuelno",null,"≤ 10 %"]
["F15 manuelno",null,"≤ 15 %"]
["F20 manuelno",null,"≤ 20 %"]
["F25 manuelno",null,"≤ 25 %"]
["F30 manuelno",null,"≤ 30 %"]
["F30+ manuelno",null,"> 30 % maks.vrednost"]
[null,null,"se navodi"]
["Svi podaci su dati bez garancije"]