{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["EN_learn","TYP_1","TYP_2","TYP_3","PLEN_zadanie_TYP4"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":4,"comments":1,"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":"EN_learn","index":0,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
["CONVERSION"]
[]
["design an input cell accepting numbers 1-6"]
["desing an output cell showing texts  \"light air\", \"light breeze\", \"gentle breeze\", \"moderate\", \"fresh breeze\", \"strong breeze\" "]
["according to an input cell"]
["METOD 1 Function IF nested 6 times",null,null,null,"RESULT"]
[null,3,null,null,{"$f":"IF(B7=1,\"light air\",IF(B7=2,\"light breeze\",IF(B7=3,\"gentle breeze\",IF(B7=4,\"moderate\",IF(B7=5,\"fresh breeze\",IF(B7=6,\"strong breeze\",\"unrecognised\"))))))","v":"gentle breeze"}]
[null,null,"=IF(B6=1,\"light air\",IF(B6=2,\"light breeze\",IF(B6=3,\"gentle breeze\",IF(B6=4,\"moderate\",IF(B6=5,\"fresh breeze\",IF(B6=6,\"strong breeze\",\"unrecognised\"))))))"]
[]
["METOD 2 Function CHOOSE"]
[null,2,null,null,{"$f":"CHOOSE(B11,\"light air\", \"light breeze\", \"gentle breeze\", \"moderate\", \"fresh breeze\", \"strong breeze\")","v":"light breeze"}]
[null,null,"=CHOOSE(B9,\"light air\", \"light breeze\", \"gentle breeze\", \"moderate\", \"fresh breeze\", \"strong breeze\")"]
[]
["METOD 3a Function INDEX"]
[null,2,null,null,{"$f":"INDEX({\"light air\",\"light breeze\",\"gentle breeze\",\"moderate\",\"fresh breeze\",\"strong breeze\"},B15)","v":"light breeze"}]
[null,null,"=INDEX({\"light air\",\"light breeze\",\"gentle breeze\",\"moderate\",\"fresh breeze\",\"strong breeze\"},B12)"]
[]
["METOD 3b Function INDEX"]
[null,2,null,null,{"$f":"INDEX($D$22:$D$33,B19)","v":"light breeze"}]
[null,null,"=INDEX($D$17:$D$28,B15)"]
[]
[null,null,null,"light air"]
[null,null,null,"light breeze"]
[null,null,null,"gentle breeze"]
[null,null,null,"moderate"]
[null,null,null,"fresh breeze"]
[null,null,null,"strong breeze"]
[null,null,null,"near gale"]
[null,null,null,"gale"]
[null,null,null,"strong gale"]
[null,null,null,"storm"]
[null,null,null,"violent storm"]
[null,null,null,"hurricane"]
[]
["METOD 4a Function VLOOKUP"]
[null,2,null,null,{"$f":"VLOOKUP(B36,C39:D51,2,FALSE)","v":"light breeze"}]
[]
[null,null,"Number","Name"]
[null,null,0,"calm"]
[null,null,1,"light air"]
[null,null,2,"light breeze"]
[null,null,3,"gentle breeze"]
[null,null,4,"moderate"]
[null,null,5,"fresh breeze"]
[null,null,6,"strong breeze"]
[null,null,7,"near gale"]
[null,null,8,"gale"]
[null,null,9,"strong gale"]
[null,null,10,"storm"]
[null,null,11,"violent storm"]
[null,null,12,"hurricane"]
[]
["METOD 4a Function VLOOKUP almost identical as previous one, but no auxilery table for conversion)"]
[null,4,null,null,{"$f":"VLOOKUP(B54,{0,\"calm\",0;1,\"light air\",3;2,\"light breeze\",6;3,\"gentle breeze\",12;4,\"moderate\",20;5,\"fresh breeze\",30;6,\"strong breeze\",40;7,\"near gale\",51;8,\"gale\",62;9,\"strong gale\",75;10,\"storm\",88;11,\"violent storm\",102;12,\"hurricane\",118},2,FALSE)","v":"moderate"}]
[]
[]
["design an input cell accepting letters A-F"]
["desing an output cell showing texts \"calm\", \"light air\", \"light breeze\", \"gentle breeze\", \"moderate\", \"fresh breeze\", \"strong breeze\" "]
["according to an input cell"]
["METOD 1 Function IF nested 4 times"]
["…."]
[]
["METOD 4 Function VLOOKUP  (CHOOSE, INDEX are problematic in this case. These prefere integer values) "]
["….","M",null,null,{"$f":"VLOOKUP(B64,{\"A\",\"calm\";\"B\",\"light air\";\"C\",\"light breeze\";\"D\",\"gentle breeze\";\"E\",\"moderate\";\"F\",\"fresh breeze\";\"G\",\"strong breeze\";\"H\",\"near gale\";\"I\",\"gale\";\"J\",\"strong gale\";\"K\",\"storm\";\"L\",\"violent storm\";\"M\",\"hurricane\"},2,FALSE)","v":"hurricane"}]
[]
[]
[]
[]
["design an input cell accepting  wind velocity in kph"]
["desing an output cell showing the number in beaufort scale  "]
["desing an output cell showing the name of wind  in beaufort scale "]
["wind velocity",18,{"$f":"VLOOKUP($B$72,$C$77:$E$89,2,TRUE)","v":3},"=VLOOKUP($B$73,$C$78:$E$90,2,TRUE)"]
[null,null,{"$f":"VLOOKUP($B$72,$C$77:$E$89,3,TRUE)","v":"gentle breeze"},"=VLOOKUP($B$73,$C$78:$E$90,3,TRUE)"]
[]
[]
[null,null,"from kph",null,null,null,"od km/h","Stopien ","Name","Nazwa"]
[null,null,0,0,"calm",null,0,0,"calm","Cisza, Flauta"]
[null,null,3,1,"light air",null,1,0,"calm","Cisza, Flauta"]
[null,null,6,2,"light breeze",null,2,0,"calm","Cisza, Flauta"]
[null,null,12,3,"gentle breeze",null,3,1,"light air","Powiew"]
[null,null,20,4,"moderate",null,4,1,"light air","Powiew"]
[null,null,30,5,"fresh breeze",null,5,1,"light air","Powiew"]
[null,null,40,6,"strong breeze",null,6,2,"light breeze","Słaby wiatr"]
[null,null,51,7,"near gale",null,7,2,"light breeze","Słaby wiatr"]
[null,null,62,8,"gale",null,8,2,"light breeze","Słaby wiatr"]
[null,null,75,9,"strong gale",null,9,2,"light breeze","Słaby wiatr"]
[null,null,88,10,"storm",null,10,2,"light breeze","Słaby wiatr"]
[null,null,102,11,"violent storm",null,11,2,"light breeze","Słaby wiatr"]
[null,null,118,12,"hurricane",null,12,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,13,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,14,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,15,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,16,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,17,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,18,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,19,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,20,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,21,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,22,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,23,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,24,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,25,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,26,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,27,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,28,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,29,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,30,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,31,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,32,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,33,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,34,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,35,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,36,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,37,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,38,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,39,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null,null,null,40,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,41,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,42,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,43,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,44,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,45,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,46,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,47,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,48,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,49,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,50,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,51,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,52,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,53,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,54,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,55,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,56,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,57,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,58,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,59,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,60,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,61,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,62,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,63,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,64,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,65,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,66,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,67,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,68,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,69,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,70,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,71,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,72,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,73,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,74,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,75,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,76,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,77,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,78,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,79,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,80,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,81,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,82,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,83,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,84,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,85,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,86,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,87,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,88,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,89,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,90,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,91,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,92,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,93,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,94,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,95,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,96,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,97,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,98,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,99,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,100,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,101,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,102,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,103,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,104,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,105,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,106,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,107,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,108,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,109,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,110,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,111,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,112,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,113,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,114,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,115,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,116,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,117,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,118,12,"hurricane","Huragan"]
[null,null,null,null,null,null,119,12,"hurricane","Huragan"]
[null,null,null,null,null,null,120,12,"hurricane","Huragan"]
[null,null,null,null,null,null,121,12,"hurricane","Huragan"]
[null,null,null,null,null,null,122,12,"hurricane","Huragan"]
[null,null,null,null,null,null,123,12,"hurricane","Huragan"]
[null,null,null,null,null,null,124,12,"hurricane","Huragan"]
[null,null,null,null,null,null,125,12,"hurricane","Huragan"]
[null,null,null,null,null,null,126,12,"hurricane","Huragan"]

{"sheet":"TYP_1","index":1,"n_rows":211,"n_cols":14,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
["KONWERSJA",null,null,null,null,null,"TYP_1"]
["zaprojektuj komórkę wejścia akceptujacą wartości od 1 do 4",null,null,null,null,null,"konwertuj liczbę na tekst"]
["niech komórka po prawo wyświetla teksty  \"January\", \"February\", \"March\", \"April\" zależnie od komórek wejścia"]
["Metoda 1 funkcja JEŻELI użyta czterokrotnie"]
[]
[null,1,null,null,"=JEŻELI(B6=1;\"January\";JEŻELI(B6=2;\"February\";JEŻELI(B6=3;\"March\";JEŻELI(B6=4;\"April\";\"wrong\"))))"]
[]
["METODA 2 funkcja WYBIERZ"]
[null,2,null,null,"=WYBIERZ(B9;\"January\";\"February\";\"March\";\"April\";\"May\";\"June\")"]
[]
["METODA 3a Funkcja INDEKS"]
[null,2,null,null,"=INDEKS({\"January\";\"February\";\"March\";\"April\"};B12)"]
[]
["METODA 3b Funkcja INDEKS",null,null,null,null,null,null,null,null,"KONWERSJA"]
[null,2,null,null,"=INDEKS($D$18:$D$29;B15)",null,null,null,null,null,"na co?"]
[null,null,null,null,null,null,null,null,null,"co?","liczba","tekst "]
[null,null,null,"Name",null,null,null,null,null,"liczba","=WYBIERZ(","=INDEKS("]
[null,null,null,"January",null,null,null,null,null,"naturalna","=INDEKS(","=WYBIERZ("]
[null,null,null,"February",null,null,null,null,null,null,"=JEŻELI(","=WYSZUKAJ.PIONOWO"]
[null,null,null,"March",null,null,null,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
[null,null,null,"April",null,null,null,null,null,null,"=formuła matematyczna"]
[null,null,null,"May",null,null,null,null,null,null,"=SUMA.WARUNKÓW"]
[null,null,null,"June",null,null,null,null,null," tekst","=SUMA.WARUNKÓW","=WYSZUKAJ.PIONOWO"]
[null,null,null,"July",null,null,null,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
[null,null,null,"August",null,null,null,null,null,null,"=JEŻELI(","=INDEKS(PODAJ.POZYCJĘ"]
[null,null,null,"September",null,null,null,null,null,null,"=INDEKS(PODAJ.POZYCJĘ"]
[null,null,null,"October"]
[null,null,null,"November"]
[null,null,null,"December"]
[]
["METOD 4a Funkcja WYSZUKAJ.PIONOWO"]
[null,2,null,null,"=WYSZUKAJ.PIONOWO(B32;C35:D46;2;FAŁSZ)"]
[]
[null,null,"Number","Name","czeski","włoski","hiszpański","fiński","litewski","francuski"]
[null,null,1,"January","leden","gennaio","enero","tammikuu","Sausis","janvier"]
[null,null,2,"February","únor","febbraio","febrero","helmikuu","Vasaris","février"]
[null,null,3,"March","březen","marzo","marzo [marso]","maaliskuu","Kovas","mars"]
[null,null,4,"April","duben","aprile","abril","huhtikuu","Balandis","avril"]
[null,null,5,"May","květen","maggio","mayo [majo]","toukokuu","Geguže","mai"]
[null,null,6,"June","červen","giugno","junio","kesäkuu","Birželis","juin"]
[null,null,7,"July","červenec","luglio","julio","heinäkuu","Liepa","juillet"]
[null,null,8,"August","srpen","agosto","agosto","elokuu","Rugpjutis","août"]
[null,null,9,"September","září","settembre","septiembre","syyskuu","Rugsejis","septembre"]
[null,null,10,"October","říjen","ottobre","octubre","lokakuu","Spalis","octobre"]
[null,null,11,"November","listopad","novembre","noviembre","marraskuu","Lapkritis","novembre"]
[null,null,12,"December","prosinec","dicembre","diciembre","joulukuu","Gruodis","décembre"]
[]
["METODA 4b Funkcja Wyszukaj Pionowo prawie tak jak wyżej"]
[null,6,null,null,"=WYSZUKAJ.PIONOWO(B49;{1\\\"January\";2\\\"February\";3\\\"March\";4\\\"April\";5\\\"May\";6\\\"June\";7\\\"July\";8\\\"August\";9\\\"September\";10\\\"October\";11\\\"November\";12\\\"December\"};2;FAŁSZ)"]
[]
["zaprojektuj komórkę wejścia akceptujacą komórki od A do D"]
["niech komórka wyświetla teksty  \"January\", \"February\", \"March\", \"April\" zależnie od komórek wejścia"]
["Metoda 1 funkcja JEŻELI użyta czterokrotnie"]
["…."]
[]
["METODA 4b Funkcja WYSZUKAJ.PIONOWO  (CHOOSE, INDEX są problematyczne w tym przypadku, lepiej działa na liczbach całkowitych "]
["….","B",null,null,"=WYSZUKAJ.PIONOWO(B57;{\"A\"\\\"January\";\"B\"\\\"February\";\"C\"\\\"March\";\"D\"\\\"April\";\"E\"\\\"May\";\"F\"\\\"June\";\"G\"\\\"July\";\"H\"\\\"August\";\"I\"\\\"September\";\"J\"\\\"October\";\"K\"\\\"November\";\"L\"\\\"December\"};2;FAŁSZ)"]
["Zastosuj listę wartości dla powyższych żółtych pól"]
[]
["Metoda 4a","B"]
[]
[null,null,"Symbol","Name"]
[null,null,"  "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["zaprojektuj komórkę wyjścia z numerem w skali Beauforta zależnym od prędkości wiatru"]
["zaprojektuj komórkę wyjścia z nazwą wiatru w skali Beauforta zależną od prędkości wiatru"]
["prędkość wiatru km/h",18," ",{"$f":"VLOOKUP(B80,$C$85:$F$97,2,TRUE)","v":3}]
[null,null," ",{"$f":"VLOOKUP(B80,$C$85:$F$97,3,TRUE)","v":"gentle breeze"}]
[null,null," ",{"$f":"VLOOKUP(B80,$C$85:$F$97,4,TRUE)","v":"Łagodny wiatr"}]
["To nie jest zastosowanie biznesowe"]
[null,null,"od km/h","Stopien ","Name","Nazwa",null,null,null,null,"od km/h","Stopien ","Name","Nazwa"]
[null,null,0,0,"calm","Cisza, Flauta",null,null,null,null,0,0,"calm","Cisza, Flauta"]
[null,null,3,1,"light air","Powiew",null,null,null,null,1,0,"calm","Cisza, Flauta"]
[null,null,6,2,"light breeze","Słaby wiatr",null,null,null,null,2,0,"calm","Cisza, Flauta"]
[null,null,12,3,"gentle breeze","Łagodny wiatr",null,null,null,null,3,1,"light air","Powiew"]
[null,null,20,4,"moderate","Umiarkowany wiatr",null,null,null,null,4,1,"light air","Powiew"]
[null,null,30,5,"fresh breeze","Dość silny wiatr",null,null,null,null,5,1,"light air","Powiew"]
[null,null,40,6,"strong breeze","Silny wiatr",null,null,null,null,6,2,"light breeze","Słaby wiatr"]
[null,null,51,7,"near gale","Bardzo silny wiatr",null,null,null,null,7,2,"light breeze","Słaby wiatr"]
[null,null,62,8,"gale","Sztorm/Wicher",null,null,null,null,8,2,"light breeze","Słaby wiatr"]
[null,null,75,9,"strong gale","Silny sztorm",null,null,null,null,9,2,"light breeze","Słaby wiatr"]
[null,null,88,10,"storm","Bardzo silny sztorm",null,null,null,null,10,2,"light breeze","Słaby wiatr"]
[null,null,102,11,"violent storm","Gwałtowny sztorm",null,null,null,null,11,2,"light breeze","Słaby wiatr"]
[null,null,118,12,"hurricane","Huragan",null,null,null,null,12,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,null,null,null,null,13,3,"gentle breeze","Łagodny wiatr"]
[null,"źródło:","http://pl.wikipedia.org/wiki/Skala_Beauforta",null,null,null,null,null,null,null,14,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,null,null,null,null,15,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,null,null,null,null,16,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,null,null,null,null,17,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,null,null,null,null,18,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,null,null,null,null,19,3,"gentle breeze","Łagodny wiatr"]
[null,null,null,null,null,null,null,null,null,null,20,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,null,null,null,null,21,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,null,null,null,null,22,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,null,null,null,null,23,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,null,null,null,null,24,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,null,null,null,null,25,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null,null,null,null,null,null,null,26,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null," ",null,null,null,null,null,27,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null," ",null,null,null,null,null,28,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null," ",null,null,null,null,null,29,4,"moderate","Umiarkowany wiatr"]
[null,null,null,null," ",null,null,null,null,null,30,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,31,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,32,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,33,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,34,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,35,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,36,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,37,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,38,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,39,5,"fresh breeze","Dość silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,40,6,"strong breeze","Silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,41,6,"strong breeze","Silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,42,6,"strong breeze","Silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,43,6,"strong breeze","Silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,44,6,"strong breeze","Silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,45,6,"strong breeze","Silny wiatr"]
[null,null,null,null," ",null,null,null,null,null,46,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,47,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,48,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,49,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,50,6,"strong breeze","Silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,51,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,52,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,53,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,54,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,55,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,56,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,57,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,58,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,59,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,60,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,61,7,"near gale","Bardzo silny wiatr"]
[null,null,null,null,null,null,null,null,null,null,62,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,63,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,64,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,65,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,66,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,67,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,68,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,69,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,70,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,71,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,72,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,73,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,74,8,"gale","Sztorm/Wicher"]
[null,null,null,null,null,null,null,null,null,null,75,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,76,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,77,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,78,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,79,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,80,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,81,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,82,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,83,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,84,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,85,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,86,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,87,9,"strong gale","Silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,88,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,89,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,90,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,91,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,92,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,93,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,94,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,95,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,96,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,97,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,98,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,99,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,100,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,101,10,"storm","Bardzo silny sztorm"]
[null,null,null,null,null,null,null,null,null,null,102,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,103,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,104,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,105,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,106,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,107,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,108,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,109,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,110,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,111,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,112,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,113,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,114,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,115,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,116,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,117,11,"violent storm","Gwałtowny sztorm"]
[null,null,null,null,null,null,null,null,null,null,118,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,119,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,120,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,121,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,122,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,123,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,124,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,125,12,"hurricane","Huragan"]
[null,null,null,null,null,null,null,null,null,null,126,12,"hurricane","Huragan"]

{"sheet":"TYP_2","index":2,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,9,7,10]]}
["KONWERSJA"]
[]
[]
["TYP2"]
["zamiana liczby na liczbe"]
[]
[null,null,"uzupełnij brakujące komórki",null,null,null,null,null,null,null,null,"zastosuj jedną z poniższych formuł do policzenia kwartału na podstawie miesiąca"]
[null,null,null,null,null,null,null,null,null,"zaawansowane"]
[null,null,"Data","numer miesiąca","numer kwartału","numer kwartału","numer kwartału","numer kwartału","numer kwartału","numer kwartału","numer kwartału"]
[null,null,null,null,"WYBIERZ","INDEKS","JEŻELI","CZ.CAŁK.DZIELENIA","WYSZUKAJ.PIONOWO","WYSZUKAJ.PIONOWO","SUMA.WARUNKÓW"]
[null,null,{"$f":"\"9/9\"+0","v":"2016-09-09"},{"$f":"MONTH(C11)","v":9}]
[null,null,{"$f":"C11+49","v":"2016-10-28"},{"$f":"MONTH(C12)","v":10}]
[null,null,{"$f":"C12+49","v":"2016-12-16"},12]
[null,null,"2017-02-03",2]
[null,null,"2017-03-24",3,null,null,null,null,null,null,null,null,{"$f":"SUMIFS($N$21:$N$32,$M$21:$M$32,miesiąc)","v":0}]
[null,null,"2017-05-12",5,null,null,null,null,null,null,null,null,"=CZ.CAŁK.DZIELENIA(miesiąc-1;3)+1"]
[null,null,"2017-06-30",6]
[null,null,"2017-08-18",8,null,null,null,null,null,null,null,null,"=QUOTIENT w 2010 to =CZ.CAŁK.DZIELENIA("]
[null,null,"2017-10-06",10]
[null,null,"2017-11-24",11,null,null,null,null,null,null,null,null,"miesiąc","kwartał",null,null,"KONWERSJA"]
[null,null,"2018-01-12",1,null,null,null,null,null,null,null,null,1,1,null,null,null,"na co?"]
[null,null,"2018-03-02",3,null,null,null,null,null,null,null,null,2,1,null,null,"co?","liczba","tekst "]
[null,null,"2018-04-20",4,null,null,null,null,null,null,null,null,3,1,null,null,"liczba","=WYBIERZ(","=INDEKS("]
[null,null,"2018-06-08",6,null,null,null,null,null,null,null,null,4,2,null,null,"naturalna","=INDEKS(","=WYBIERZ("]
[null,null,"2018-07-27",7,null,null,null,null,null,null,null,null,5,2,null,null,null,"=JEŻELI(","=WYSZUKAJ.PIONOWO"]
[null,null,"2018-09-14",9,null,null,null,null,null,null,null,null,6,2,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
[null,null,{"$f":"C26+49","v":"2018-11-02"},11,null,null,null,null,null,null,null,null,7,3,null,null,null,"=formuła matematyczna"]
[null,null,"2018-12-21",12,null,null,null,null,null,null,null,null,8,3,null,null,null,"=SUMA.WARUNKÓW"]
[null,null,"2019-02-08",2,null,null,null,null,null,null,null,null,9,3,null,null," tekst","=SUMA.WARUNKÓW","=WYSZUKAJ.PIONOWO"]
[null,null,"2019-03-29",3,null,null,null,null,null,null,null,null,10,4,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
[null,null,"2019-05-17",5,null,null,null,null,null,null,null,null,11,4,null,null,null,"=JEŻELI(","=INDEKS(PODAJ.POZYCJĘ"]
[null,null,{"$f":"C31+49","v":"2019-07-05"},7,null,null,null,null,null,null,null,null,12,4,null,null,null,"=INDEKS(PODAJ.POZYCJĘ"]
[null,null,{"$f":"C32+49","v":"2019-08-23"},8]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"zaawansowane:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"tabela skrócona (leanowska) pod zastosowanie w rzadziej "]
[null,null,null,null,null,null,null,null,null,null,null,null,"spotykanym wywołaniu WYSZUKAJ.PIONOWO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"miesiąc","kwartał"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,4,2]
[null,null,null,null,null,null,null,null,null,null,null,null,7,3]
[null,null,null,null,null,null,null,null,null,null,null,null,10,4]

{"sheet":"TYP_3","index":3,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[13,4,16,10]]}
["KONWERSJA"]
["TYP 3"]
["konwertuj  tekst na liczbę"]
[]
["dla szukanych liczb na podatawie tekstów lub liczb można tak:"]
["METOD  Funkcja WYSZUKAJ.PIONOWO"]
[null,"John Deere",null,null,"=WYSZUKAJ.PIONOWO(B7;$C$23:$D$41;2;FAŁSZ)"]
[null,null,null,null,"=VLOOKUP(B7,$C$23:$D$41,2,FALSE)"]
[]
["dla szukanych liczb na podatawie tekstów, liczb można tak:"]
["Metoda ","Fendt",null,null,"=SUMA.WARUNKÓW($D$23:$D$41;$C$23:$C$41;B11)"]
[null,null,null,null,"=SUMIFS($D$23:$D$41;$C$23:$C$41,B11)"]
[]
["Metoda ","Gomsielmasz",null,null,"=JEŻELI(B14=C23;D23;JEŻELI(B14=C24;D24;JEŻELI(B14=C25;D25;JEŻELI(B14=C26;D26;JEŻELI(B14=C27;D27;JEŻELI(B14=C28;D28;JEŻELI(B14=C29;D29;JEŻELI(B14=C30;D30;JEŻELI(B14=C31;D31;JEŻELI(B14=C32;D32;JEŻELI(B14=C33;D33;JEŻELI(B14=C34;D34;JEŻELI(B14=C35;D35;JEŻELI(B14=C36;D36;JEŻELI(B14=C37;D37;JEŻELI(B14=C38;D38;JEŻELI(B14=C39;D39;JEŻELI(B14=C40;D40;JEŻELI(B14=C41;D41)))))))))))))))))))"]
[]
[]
[]
[]
["METOD  Funkcja INDEKS z podaj.pozycję"]
[null,"John Deere",null,null,"=INDEKS($D$23:$D$41;PODAJ.POZYCJĘ(B20;maszyny))"]
[null,null,null,null,"=INDEX($D$23:$D$41,MATCH(B20,maszyny))"]
[null,null,"MASZYNA","Czas jednostkowy"]
[null,null,"Bizon-New Holland","02:15:00"]
[null,null,"Case IH","01:00:00"]
[null,null,"Caterpillar","01:50:00",null,null,null,null,"KONWERSJA"]
[null,null,"Claas","01:40:00",null,null,null,null,null,"na co?"]
[null,null,"Clayson","01:15:00",null,null,null,null,"co?","liczba","tekst "]
[null,null,"Deutz-Fahr","02:30:00",null,null,null,null,"liczba","=WYBIERZ(","=INDEKS("]
[null,null,"Dronningborg","01:35:00",null,null,null,null,"naturalna","=INDEKS(","=WYBIERZ("]
[null,null,"Fendt","01:25:00",null,null,null,null,null,"=JEŻELI(","=WYSZUKAJ.PIONOWO"]
[null,null,"Fiatagri","02:20:00",null,null,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
[null,null,"Fortschritt","01:30:00",null,null,null,null,null,"=formuła matematyczna"]
[null,null,"Gomsielmasz","01:45:00",null,null,null,null,null,"=SUMA.WARUNKÓW"]
[null,null,"Jenisej","02:10:00",null,null,null,null," tekst","=SUMA.WARUNKÓW","=WYSZUKAJ.PIONOWO"]
[null,null,"John Deere","02:00:00",null,null,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
[null,null,"Laverda","02:05:00",null,null,null,null,null,"=JEŻELI(","=INDEKS(PODAJ.POZYCJĘ"]
[null,null,"Massey Ferguson","01:55:00",null,null,null,null,null,"=INDEKS(PODAJ.POZYCJĘ"]
[null,null,"MDW","01:20:00"]
[null,null,"New Holland","01:05:00"]
[null,null,"Rostsielmasz","02:25:00"]
[null,null,"Sampo","01:10:00"]
[]
[]
["non go zone"]
["Metoda 1","Jenisej",{"$f":"IF($B$45=C23,D23,IF($B$45=C24,D24,IF($B$45=C25,D25,IF($B$45=C26,D26,IF($B$45=C27,D27,IF($B$45=C28,D28,IF($B$45=C29,D29,IF($B$45=C30,D30,IF($B$45=C31,D31,IF($B$45=C32,D32,IF($B$45=C33,D33,IF($B$45=C34,D34,IF($B$45=C35,D35,IF($B$45=C36,D36,IF($B$45=C37,D37,IF($B$45=C38,D38,IF($B$45=C39,D39,IF($B$45=C40,D40,IF($B$45=C41,D41,\"Prrr!\")))))))))))))))))))","v":"02:10:00"},null,"=JEŻELI($B$38=C16;D16;JEŻELI($B$38=C17;D17;JEŻELI($B$38=C18;D18;JEŻELI($B$38=C19;D19;JEŻELI($B$38=C20;D20;JEŻELI($B$38=C21;D21;JEŻELI($B$38=C22;D22;JEŻELI($B$38=C23;D23;JEŻELI($B$38=C24;D24;JEŻELI($B$38=C25;D25;JEŻELI($B$38=C26;D26;JEŻELI($B$38=C27;D27;JEŻELI($B$38=C28;D28;JEŻELI($B$38=C29;D29;JEŻELI($B$38=C30;D30;JEŻELI($B$38=C31;D31;JEŻELI($B$38=C32;D32;JEŻELI($B$38=C33;D33;JEŻELI($B$38=C34;D34;\"Prrr!\")))))))))))))))))))"]
[null,null,null,null,"=IF($B$38=C16,D16,IF($B$38=C17,D17,IF($B$38=C18,D18,IF($B$38=C19,D19,IF($B$38=C20,D20,IF($B$38=C21,D21,IF($B$38=C22,D22,IF($B$38=C23,D23,IF($B$38=C24,D24,IF($B$38=C25,D25,IF($B$38=C26,D26,IF($B$38=C27,D27,IF($B$38=C28,D28,IF($B$38=C29,D29,IF($B$38=C30,D30,IF($B$38=C31,D31,IF($B$38=C32,D32,IF($B$38=C33,D33,IF($B$38=C34,D34,\"Prrr!\")))))))))))))))))))"]

{"sheet":"PLEN_zadanie_TYP4","index":4,"n_rows":51,"n_cols":39,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYP 4"]
[]
["chamber","address","experience",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zaspół adwokacki","adres","doświadczenie"]
["Federic Company","Skargi 19","3 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federic Company","Skargi 19","3 lata"]
["Lukas Company","Zabia 14","6 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company","Żabia 14","6 lat"]
["M&R Company","Piotrkowska 25","11 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company","Piotrkowska 25","11 lat"]
[]
[]
["Retreive data from lookup table above in columns address, experience lookup value is chamber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"uzupełnij brakujące pola za pomocą funkcji WYSZUKAJ.PIONOWO"]
["lub inną formułą odczytaną z tabelki",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lub inną formułą odczytaną z tabelki w żółtej sekcji"]
["metoda 1 TT","Vlookup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"metoda 1 TT","=WYSZUKAJ.PIONOWO"]
[]
["chamber","address","experience","kind of case","effectiveness","fare for service","days spent","dayly fare",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zaspół adwokacki","adres","doświadczenie","rodzaj","wynik","opłata","liczba dni ","dniówka"]
["M&R Company",null,null,"merchant","won",42000,21,{"$f":"F17/G17","v":2000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"nieruchomości","przegrana",7500,5,{"$f":"AF17/AG17","v":1500}]
["Lukas Company",null,null,"merchant","lost",13000,7,1857.1428571428571,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","przegrana",5000,3,1666.6666666666667]
["Lukas Company",null,null,"families","lost",1800,1,1800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","przegrana",4300,3,1433.3333333333333]
["Lukas Company",null,null,"families","won",1800,1,1800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"rodzinna","przegrana",1800,1,1800]
["Lukas Company",null,null,"merchant","won",25000,14,1785.7142857142858,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"rodzinna","przegrana",1500,1,1500,null,null,"KONWERSJA"]
["M&R Company",null,null,"estate ","won",3500,2,1750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"rodzinna","przegrana",2700,2,1350,null,null,null,"na co?"]
["M&R Company",null,null,"merchant","won",36000,21,1714.2857142857142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"gospodarcza","przegrana",13000,7,1857.1428571428571,null,null,"co?","liczba","tekst "]
["Lukas Company",null,null,"estate ","lost",5000,3,1666.6666666666667,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"gospodarcza","przegrana",22000,14,1571.4285714285713,null,null,"liczba","=WYBIERZ(","=INDEKS("]
["Federic Company",null,null,"estate ","won",5000,3,1666.6666666666667,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federic Company",null,null,"gospodarcza","przegrana",15000,10,1500,null,null,"naturalna","=INDEKS(","=WYBIERZ("]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=JEŻELI(","=WYSZUKAJ.PIONOWO"]
["metoda 2 TT","if",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"metoda 2 TT","=JEŻELI(",null,null,null,null,null,null,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=SUMA.WARUNKÓW"]
["chamber","address","experience","kind of case","effectiveness","fare for service","days spent","dayly fare",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zaspół adwokacki","adres","doświadczenie","rodzaj","wynik","opłata","liczba dni ","dniówka",null,null,null,"=formuła matematyczna"]
["M&R Company",null,null,"estate ","won",4800,3,{"$f":"F30/G30","v":1600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"nieruchomości","wygrana",5000,3,1666.6666666666667,null,null," tekst","=SUMA.WARUNKÓW","=WYSZUKAJ.PIONOWO"]
["Lukas Company",null,null,"merchant","lost",22000,14,1571.4285714285713,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",3000,2,1500,null,null,null,"=WYSZUKAJ.PIONOWO","=JEŻELI("]
["Lukas Company",null,null,"families","lost",1500,1,1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",6000,5,1200,null,null,null,"=JEŻELI(","=INDEKS(PODAJ.POZYCJĘ"]
["Lukas Company",null,null,"merchant","won",21000,14,1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",3500,2,1750,null,null,null,"=INDEKS(PODAJ.POZYCJĘ"]
["Lukas Company",null,null,"estate ","lost",7500,5,1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",4800,3,1600]
["M&R Company",null,null,"estate ","won",3000,2,1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"rodzinna","wygrana",1800,1,1800]
["M&R Company",null,null,"families","won",1500,1,1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"rodzinna","wygrana",1500,1,1500]
["Lukas Company",null,null,"families","won",1500,1,1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"rodzinna","wygrana",1500,1,1500]
["Federic Company",null,null,"families","won",2000,2,1000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federic Company",null,null,"rodzinna","wygrana",2500,2,1250]
[]
["metoda 3 TT","index(Match",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"metoda 3 TT","=INDEKS(PODAJ.POZYCJĘ",null,"ZAAWANSOWANE ! zrób na polecenie prowadzącego"]
[]
["chamber","address","experience","kind of case","effectiveness","fare for service","days spent","dayly fare",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zaspół adwokacki","adres","doświadczenie","rodzaj","wynik","opłata","liczba dni ","dniówka"]
["M&R Company",null,null,"merchant","lost",15000,10,{"$f":"F43/G43","v":1500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"nieruchomości","wygrana",5000,3,{"$f":"AF43/AG43","v":1666.6666666666667}]
["Lukas Company",null,null,"estate ","lost",4300,3,1433.3333333333333,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",3000,2,1500]
["Lukas Company",null,null,"families","lost",2700,2,1350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",6000,5,1200]
["Lukas Company",null,null,"families","won",2500,2,1250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",3500,2,1750]
["M&R Company",null,null,"families","won",2500,2,1250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"nieruchomości","wygrana",4800,3,1600]
["M&R Company",null,null,"families","won",1200,1,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"rodzinna","wygrana",1800,1,1800]
["Lukas Company",null,null,"estate ","won",6000,5,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M&R Company",null,null,"rodzinna","wygrana",1500,1,1500]
["Federic Company",null,null,"merchant","won",15000,14,1071.4285714285713,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lukas Company",null,null,"rodzinna","wygrana",1500,1,1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federic Company",null,null,"rodzinna","wygrana",2500,2,1250]