{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["KALIBRATOR","WYKRESY","INFO-1","INFO-2","RAPORT","Tabela"],"not_rendered":{"charts":1,"images":12,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"KALIBRATOR","index":0,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,3,22,4],[22,1,23,1],[22,2,23,2],[21,5,23,7],[14,1,14,4],[19,5,19,6],[18,1,18,3],[15,1,15,3],[16,1,16,3],[13,5,14,7],[9,5,11,7],[27,5,34,7],[25,5,26,7],[17,5,17,6],[18,5,18,6]]}
["kALIBRACJA1"]
[null,"KALIBRACJA OPRYSKIWACZA SADOWNICZEGO"]
[]
[null,"Oblicz optymalną dawkę cieczy dla danego sadu"]
[null,"Wysokość koron drzew - W [m]"]
[null,"Szerokość koron drzew - S [m]"]
[null,"Rozstawa rzędów drzew - R [m]"]
[null,"Optymalna dawka cieczy [L/ha]",null,null,{"$f":"IF(E7=\"\",\"\",E5*E6*330/E7)","v":""}]
[]
[null,"Wprowadź dane:",null,null,null,"* Wprowadź dawkę optymalną, obliczoną powyżej lub dobraną samodzielnie"]
[null,"Dawka cieczy * [L/ha]"]
[null,"Rozstawa rzędów drzew - R [m]"]
[null,"Liczba pracujących rozpylaczy [szt]"]
[null,"Prędkość robocza ** [km/h]",null,null,null,"** Wprowadź tylko jeśli \nprędkość jest znana\n(np. odczyt z tachometru)"]
[null,"Jeśli prędkość robocza nie jest znana ustal ją mierząc czas przejazdu opryskiwacza:"]
[null,"Bieg przekładni ciągnika"]
[null,"Obroty silnika [obr/min]"]
[null,"Długość odcinka pomiarowego - D [m]"]
[null,"Czas przejazdu [s]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Ustalona prędkość robocza [km/h]",null,null,{"$f":"IF(E14>0,E14,IF(E19>0,E18/E19*3.6,\"\"))","v":""},{"$f":"IF(AND(E14>0,E18+E19>0),\"Wyczyść wprowadzoną powyżej wartość prędkości roboczej !\",\"\")","v":""}]
[null,"Wymagany wydatek rozpylaczy [L/min]",null,null,{"$f":"IF(OR(E20=\"\",E13=\"\"),\"\",E11*E12*E20/600/E13)","v":""}]
[null,"Dobierz rozpylacze i ciśnienie cieczy ***",null,null,null,"*** Tabela zawiera ciśnienia nominalne. Należy je zweryfikować mierząc \nwydatek rozpylaczy."]
[null,"Rozmiar rozpylaczy ISO","Ciśnienie [bar]","Wielkość kropel"]
[null,null,null,"Rozpylacze standardowe","Rozpylacze eżektorowe"]
[null,"01",{"$f":"WYKRESY!N28","v":""},{"$f":"IF(C25=\"\",\"\",IF(C25<3,\"DROBNE\",\"BARDZO DROBNE\"))","v":""},{"$f":"IF(C25=\"\",\"\",IF(C25<6,\"EKSTR. GRUBE\",IF(C25>16,\"ŚREDNIE\",IF(AND(C25>=6,C25<8),\"BARDZO GRUBE\",\"GRUBE\"))))","v":""}]
[null,"015",{"$f":"WYKRESY!N29","v":""},{"$f":"IF(C26=\"\",\"\",IF(C26<4,\"DROBNE\",\"BARDZO DROBNE\"))","v":""},{"$f":"IF(C26=\"\",\"\",IF(C26<6,\"EKSTR. GRUBE\",IF(C26>18,\"ŚREDNIE\",IF(AND(C26>=6,C26<9),\"BARDZO GRUBE\",\"GRUBE\"))))","v":""},"            Zalecany zakres ciśnień \nw celu uzyskania dobrej jakości rozpylania: 5-15 bar."]
[null,"02",{"$f":"WYKRESY!N30","v":""},{"$f":"IF(C27=\"\",\"\",IF(C27<5,\"DROBNE\",\"BARDZO DROBNE\"))","v":""},{"$f":"IF(C27=\"\",\"\",IF(C27<9,\"EKSTR. GRUBE\",IF(C27>14,\"GRUBE\",\"BARDZO GRUBE\")))","v":""}]
[null,"025",{"$f":"WYKRESY!N31","v":""},{"$f":"IF(C28=\"\",\"\",IF(C28<7,\"DROBNE\",\"BARDZO DROBNE\"))","v":""},{"$f":"IF(C28=\"\",\"\",IF(C28<14,\"EKSTR. GRUBE\",IF(C28>19.5,\"GRUBE\",\"BARDZO GRUBE\")))","v":""},"            Jeśli prędkość wiatru przekracza 2 m/s to ze względu na ryzyko znoszenia cieczy użytkowej i pogorszenie warunków nanoszenia cieczy na  rośliny wybierz typ i rozmiar rozpylaczy produkujących krople GRUBE lub B. GRUBE."]
[null,"03",{"$f":"WYKRESY!N32","v":""},{"$f":"IF(C29=\"\",\"\",IF(C29<10,\"DROBNE\",\"BARDZO DROBNE\"))","v":""},{"$f":"IF(C29=\"\",\"\",IF(C29<12,\"EKSTR. GRUBE\",IF(C29>18,\"GRUBE\",\"BARDZO GRUBE\")))","v":""}]
[null,"04",{"$f":"WYKRESY!N33","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30<15,\"DROBNE\",\"BARDZO DROBNE\"))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30<14,\"EKSTR. GRUBE\",\"BARDZO GRUBE\"))","v":""}]
[null,"05",{"$f":"WYKRESY!N34","v":""},{"$f":"IF(C31=\"\",\"\",IF(C31<15,\"DROBNE\",\"BARDZO DROBNE\"))","v":""},{"$f":"IF(C31=\"\",\"\",IF(C31<16,\"EKSTR. GRUBE\",\"BARDZO GRUBE\"))","v":""}]
[null,"06",{"$f":"WYKRESY!N35","v":""},"",{"$f":"IF(C32=\"\",\"\",IF(C32<18,\"EKSTR. GRUBE\",\"BARDZO GRUBE\"))","v":""}]

{"sheet":"WYKRESY","index":1,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"bar","01","015","02","025","03","04","05","06"]
[null,2,0.32,0.48,0.65,0.81,0.97,1.29,1.61,1.93]
[null,3,0.39,0.59,0.8,0.99,1.19,1.58,1.97,2.36]
[null,4,0.45,0.68,0.92,1.1499999999999999,1.37,1.82,2.2799999999999998,2.73]
[null,5,0.51,0.76,1.01,1.28,1.52,2.02,2.5,3.05]
[null,6,0.55000000000000004,0.83,1.1100000000000001,1.4,1.64,2.21,2.74,3.34]
[null,7,0.6,0.9,1.19,1.52,1.79,2.37,2.96,3.61]
[null,8,0.64,0.96,1.27,1.62,1.91,2.5299999999999998,3.17,3.86]
[null,9,0.68,1.02,1.35,1.71,2.0299999999999998,2.68,3.36,4.09]
[null,10,0.72,1.07,1.42,1.81,2.14,2.83,3.54,4.32]
[null,11,0.75,1.1299999999999999,1.49,1.9,2.2400000000000002,2.97,3.71,4.5199999999999996]
[null,12,0.78,1.18,1.56,1.98,2.34,3.1,3.88,4.72]
[null,13,0.82,1.22,1.62,2.06,2.44,3.23,4.04,4.91]
[null,14,0.85,1.27,1.68,2.14,2.5299999999999998,3.35,4.1900000000000004,5.0999999999999996]
[null,15,0.88,1.31,1.74,2.2200000000000002,2.62,3.47,4.34,5.28]
[null,16,0.91,1.36,1.8,2.29,2.7,3.58,4.4800000000000004,5.45]
[null,17,0.93,1.4,1.86,2.36,2.79,3.69,4.62,5.62]
[null,18,0.96,1.44,1.91,2.4300000000000002,2.87,3.8,4.75,5.78]
[null,19,0.99,1.48,1.96,2.4900000000000002,2.94,3.9,4.88,5.94]
[null,20,1.01,1.52,2.0099999999999998,2.56,3.02,4,5.01,6.09]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"p=b√(q/a)"]
[null,null,null,null,null,null,null,null,null,{"$f":"KALIBRATOR!E21","v":""}]
[null,null,null,null,null,null,null,null,null,"q","a","b","p","<2,95-20,049>"]
[null,null,null,null,null,null,null,null,"01",{"$f":"J26","v":""},0.22550000000000001,0.50190000000000001,{"$f":"IF(J28=\"\",\"\",(J28/K28)^(1/L28))","v":""},{"$f":"IF(AND(M28>=2.95,M28<=20.049),M28,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"015",{"$f":"J26","v":""},0.34010000000000001,0.49930000000000002,{"$f":"IF(J29=\"\",\"\",(J29/K29)^(1/L29))","v":""},""]
[null,null,null,null,null,null,null,null,"02",{"$f":"J26","v":""},0.46300000000000002,0.48880000000000001,"",""]
[null,null,null,null,null,null,null,null,"025",{"$f":"J26","v":""},0.57320000000000004,0.49940000000000001,"",""]
[null,null,null,null,null,null,null,null,"03",{"$f":"J26","v":""},0.68759999999999999,0.49330000000000002,"",""]
[null,null,null,null,null,null,null,null,"04",{"$f":"J26","v":""},0.91739999999999999,0.49059999999999998,"",""]
[null,null,null,null,null,null,null,null,"05",{"$f":"J26","v":""},1.1405000000000001,0.4929,"",""]
[null,null,null,null,null,null,null,null,"06",{"$f":"J26","v":""},1.3654999999999999,0.49930000000000002,"",""]

{"sheet":"INFO-1","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,15]]}
[]
[null,"Dawkę cieczy dobierz odpowiednio do rodzaju sadu i fazy rozwoju (stanu ulistnienia) roślin."]

{"sheet":"INFO-2","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"Tabela wydatków cieczy [L/min] z rozpylaczy w standardzie ISO\nPoniższe dane dotyczą wydatków nominalnych, tzn. uzyskiwanych przy podanym ciśnieniu cieczy, mierzonym bezpośrednio przezd rozpylaczem. Jeśli ciśnienie  odczytywane na manometrze opryskiwacza mierzone jest w innym miejscu (np. na zaworze regulacyjnym) to jego poprawność należy zweryfikować mierząc wydatek cieczy z użyciem wyskalowanego naczynia. "]

{"sheet":"RAPORT","index":4,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,3,23,3],[22,1,23,1],[22,2,23,2],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[15,1,15,3],[16,1,16,3],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[7,1,7,4]]}
["KALIBRACJA1"]
[null,"RAPORT Z KALIBRACJI OPRYSKIWACZA SADOWNICZEGO "]
[null,null,null,null,"Uzupełnij dane w ramkach"]
[null,"Miejsce:"]
[null,"Data:"]
[null,"Operator:"]
[null,"Opryskiwacz:"]
[null," - Identyfikator (np. numer seryjny)"]
[null," - Typ (zawieszany/zaczepiany)"]
[null," - Pojemność zbiornika [L]"]
[null," - Rodzaj (konwencjonalny/deflektorowy)"]
[null," - Liczba pracujących rozpylaczy [szt]",null,null,null,{"$f":"IF(KALIBRATOR!E13=\"\",\"\",KALIBRATOR!E13)","v":""}]
[null,"Dawka cieczy [L/ha]",null,null,null,{"$f":"IF(KALIBRATOR!E11=\"\",\"\",KALIBRATOR!E11)","v":""}]
[null,"Rozstawa rzędów drzew [m]",null,null,null,{"$f":"IF(KALIBRATOR!E12=\"\",\"\",KALIBRATOR!E12)","v":""}]
[null,"Prędkość robocza wg. tachometru [km/h]",null,null,null,{"$f":"IF(KALIBRATOR!E14=\"\",\"\",KALIBRATOR!E14)","v":""}]
[null,"Bieg przekładni ciągnika",null,null,null,{"$f":"IF(KALIBRATOR!E16=\"\",\"\",KALIBRATOR!E16)","v":""}]
[null,"Obroty silnika [obr/min]",null,null,null,{"$f":"IF(KALIBRATOR!E17=\"\",\"\",KALIBRATOR!E17)","v":""}]
[null,"Długość odcinka pomiarowego [m]",null,null,null,{"$f":"IF(KALIBRATOR!E18=\"\",\"\",KALIBRATOR!E18)","v":""}]
[null,"Czas przejazdu opryskiwacza [s]",null,null,null,{"$f":"IF(KALIBRATOR!E19=\"\",\"\",KALIBRATOR!E19)","v":""}]
[null,"Prędkość robocza wg. pomiaru [km/h]",null,null,null,{"$f":"KALIBRATOR!E20","v":""}]
[null,"Wymagany wydatek rozpylaczy [L/min]",null,null,null,{"$f":"KALIBRATOR!E21","v":""}]
[null,"Wybrane rozpylacze i ciśnienia:"]
[null,"Rozmiar rozpylaczy ISO","Ciśnienie nominalne [bar]","Ciśnienie zweryfikowane [bar]"]
[]
[null,"01",{"$f":"WYKRESY!N28","v":""}]
[null,"015",{"$f":"WYKRESY!N29","v":""}]
[null,"02",{"$f":"WYKRESY!N30","v":""}]
[null,"025",{"$f":"WYKRESY!N31","v":""}]
[null,"03",{"$f":"WYKRESY!N32","v":""},null,"Inny rozpylacz: "]
[null,"04",{"$f":"WYKRESY!N33","v":""},null,"Typ"]
[null,"05",{"$f":"WYKRESY!N34","v":""},null,"Rozmiar"]
[null,"06",{"$f":"WYKRESY!N35","v":""},null,"Ciśnienie [bar]"]

{"sheet":"Tabela","index":5,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":true,"merged":[[10,2,10,9],[10,1,11,1]]}
[]
[null,null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,18,20]
[null,"01",0.32,0.39,0.45,0.51,0.55000000000000004,0.6,0.64,0.68,0.72,0.75,0.78,0.82,0.85,0.88,0.91,0.93,0.96,0.99,1.01]
[null,15,0.48,0.59,0.68,0.76,0.83,0.9,0.96,1.02,1.07,1.1299999999999999,1.18,1.22,1.27,1.31,1.36,1.4,1.44,1.48,1.52]
[null,2,0.65,0.8,0.92,1.01,1.1100000000000001,1.19,1.27,1.35,1.42,1.49,1.56,1.62,1.68,1.74,1.8,1.86,1.91,1.96,2.0099999999999998]
[null,25,0.81,0.99,1.1499999999999999,1.28,1.4,1.52,1.62,1.71,1.81,1.9,1.98,2.06,2.14,2.2200000000000002,2.29,2.36,2.4300000000000002,2.4900000000000002,2.56]
[null,3,0.97,1.19,1.37,1.52,1.64,1.79,1.91,2.0299999999999998,2.14,2.2400000000000002,2.34,2.44,2.5299999999999998,2.62,2.7,2.79,2.87,2.94,3.02]
[null,4,1.29,1.58,1.82,2.02,2.21,2.37,2.5299999999999998,2.68,2.83,2.97,3.1,3.23,3.35,3.47,3.58,3.69,3.8,3.9,4]
[null,5,1.61,1.97,2.2799999999999998,2.5,2.74,2.96,3.17,3.36,3.54,3.71,3.88,4.04,4.1900000000000004,4.34,4.4800000000000004,4.62,4.75,4.88,5.01]
[]
[null,"Ciśnienie\n[bar]","Rozmiar rozpylacza wg. ISO"]
[null,null,"01","015","02","025","03","04","05","06"]
[null,2,0.32,0.48,0.65,0.81,0.97,1.29,1.61,1.93]
[null,3,0.39,0.59,0.8,0.99,1.19,1.58,1.97,2.36]
[null,4,0.45,0.68,0.92,1.1499999999999999,1.37,1.82,2.2799999999999998,2.73]
[null,5,0.51,0.76,1.01,1.28,1.52,2.02,2.5,3.05]
[null,6,0.55000000000000004,0.83,1.1100000000000001,1.4,1.64,2.21,2.74,3.34]
[null,7,0.6,0.9,1.19,1.52,1.79,2.37,2.96,3.61]
[null,8,0.64,0.96,1.27,1.62,1.91,2.5299999999999998,3.17,3.86]
[null,9,0.68,1.02,1.35,1.71,2.0299999999999998,2.68,3.36,4.09]
[null,10,0.72,1.07,1.42,1.81,2.14,2.83,3.54,4.32]
[null,11,0.75,1.1299999999999999,1.49,1.9,2.2400000000000002,2.97,3.71,4.5199999999999996]
[null,12,0.78,1.18,1.56,1.98,2.34,3.1,3.88,4.72]
[null,13,0.82,1.22,1.62,2.06,2.44,3.23,4.04,4.91]
[null,14,0.85,1.27,1.68,2.14,2.5299999999999998,3.35,4.1900000000000004,5.0999999999999996]
[null,15,0.88,1.31,1.74,2.2200000000000002,2.62,3.47,4.34,5.28]
[null,16,0.91,1.36,1.8,2.29,2.7,3.58,4.4800000000000004,5.45]
[null,17,0.93,1.4,1.86,2.36,2.79,3.69,4.62,5.62]
[null,18,0.96,1.44,1.91,2.4300000000000002,2.87,3.8,4.75,5.78]
[null,19,0.99,1.48,1.96,2.4900000000000002,2.94,3.9,4.88,5.94]
[null,20,1.01,1.52,2.0099999999999998,2.56,3.02,4,5.01,6.09]