{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Rok","L1","L2","Oceny_koncowe"],"not_rendered":{"defined_names":4,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Rok","index":0,"n_rows":41,"n_cols":15,"rows_kept":41}
["Rok: EF_DU_07",{"$nulls":3}," "]
["Przedmiot: KOMPATYBILNOŚĆ ELEKTROMAGNETYCZNA SYSTEMÓW TELEINFORMATYCZNYCH"]
["Typ: Wykład"]
["L.p.","Nazwisko","Imię","nr albumu","Lab","Gr","SP1","SP2","SP3","SP4","SP5","SP6","KOL1","KOL2","ZAL"]
[1,"Bielak","Mateusz",148772,1]
[2,"Bielech","Kacper",148774,1]
[3,"Ćmil","Michał",148792,1]
[4,"Grocholski","Mirosław",162528,1]
[5,"Grzybowski","Bartosz",148814,1]
[6,"Indyk","Michał",148818,1]
[7,"Kochmański","Michał",148835,1]
[8,"Kołodziej","Damian",148836,1]
[9,"Kostka","Stanisław",130379,1]
[10,"Kuzara","Michał",148850,1]
[11,"Strzępek","Kamil",147009,1]
[12,"Sudek","Bartosz",148901,1]
[13,"Szymański","Piotr",148905,1]
[14,"Żaczek","Sławomir",133021,1]
[15,"Żurek","Mariusz",130405,1]
[16,"Czernecki","Bartosz",148790,2]
[17,"Jaracz","Marcin",146962,2]
[18,"Łokaj","Łukasz",143957,2]
[19,"Miazga","Michał",143965,2]
[20,"Nabożny","Paweł",143971,2]
[21,"Nowicki","Przemysław",143978,2]
[22,"Smalara","Krzysztof",144023,2]
[23,"Stanisławczyk","Tomasz",127257,2]
[24,"Stępień","Igor",137509,2]
[25,"Świerk","Kacper",148907,2]
[26,"Wróbel","Damian",148923,2]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]

{"sheet":"L1","index":1,"n_rows":140,"n_cols":32,"rows_kept":140}
["LABORATORIUM",{"$nulls":19},"SP_WSP=",0.3,"KL_PTS=",7,"KL_WSP=",0.5,"ZAL_WSP=",0.5]
["Nr","Nazwisko","Imię","W","C","L","G","BHP","Cw1","Cw2","Cw3","Cw4","Cw5","Cw6","Spr1, max 6","Spr2, max 6","Spr3, max 6","Spr4, max 6","Spr5, max 6","Spr6, max 6","Wsp spr, max 1","Wsp spr+SP_WSP","Kol,max KL_PTS","Ocena Kol, <0,5>","Ocena Kol + KL_WSP","Ocena ważona, max 5","Ocena zaokr.","Ocena ogr. Dol","Ocena ogr. Gora","Ocena z ZAL_WSP","Ocena zaokr.","Ocena bez uwzgl. Obecn."]
[1,"Bielak","Mateusz",1,1,1,null,1,1,1,1,1,1,1,{"$nulls":6},{"$f":"(O3/6+P3/6+Q3/6+R3/6+S3/6+T3/6)/6","v":0},{"$f":"U3+$V$1","v":0.3},{"$f":"OFFSET(W20,0,W20)","v":0},{"$f":"5*W3/$X$1","v":0},{"$f":"X3+$Z$1","v":0.5},{"$f":"V3*Y3","v":0.15},{"$f":"MROUND(Z3,0.5)","v":0},{"$f":"IF(AA3<=2.5,2,AA3)","v":2},{"$f":"IF(AB3>=5,5,AB3)","v":2},{"$f":"AC3-$AB$1*(W20-1)","v":2},{"$f":"IF(AND(AC3>=3,AD3<3),3,AD3)","v":2},{"$f":"IF(AE3<=2.5,2,AE3)","v":2}]
[2,"Bielech","Kacper",1,1,1,1,1,1,1,1,1,1,1,5.5,5,5,4,5,4,0.7916666666666666,1.0916666666666666,{"$f":"OFFSET(W21,0,W21)","v":7},{"$f":"5*W4/$X$1","v":5},{"$f":"X4+$Z$1","v":5.5},{"$f":"V4*Y4","v":6.004166666666666},{"$f":"MROUND(Z4,0.5)","v":6},6,{"$f":"IF(AB4>=5,5,AB4)","v":5},{"$f":"AC4-$AB$1*(W21-1)","v":5},{"$f":"IF(AND(AC4>=3,AD4<3),3,AD4)","v":5},5]
[3,"Ćmil","Michał",1,1,1,1,1,1,1,1,1,1,1,5.5,5,5,4,5,4,0.7916666666666666,1.0916666666666666,7,5,5.5,6.004166666666666,6,6,5,5,5,5]
[4,"Grocholski","Mirosław",1,1,1,2,1,1,1,1,1,1,1,5,5.5,5.5,4.5,5,5,0.8472222222222222,1.1472222222222221,7,5,5.5,6.309722222222222,6.5,6.5,5,5,5,5]
[5,"Grzybowski","Bartosz",1,1,1,"E",1,1,1,1,1,1,1,{"$nulls":6},0,0.3,0,0,0.5,0.15,0,2,2,2,2,2]
[6,"Indyk","Michał",1,1,1,1,1,1,1,1,1,1,1,5.5,5,5,4,5,4,0.7916666666666666,1.0916666666666666,6,4.285714285714286,4.785714285714286,5.224404761904761,5,5,5,5,5,5]
[7,"Kochmański","Michał",1,1,1,2,1,1,1,1,1,1,1,5,5.5,5.5,4.5,5,5,0.8472222222222222,1.1472222222222221,7,5,5.5,6.309722222222222,6.5,6.5,5,5,5,5]
[8,"Kołodziej","Damian",1,1,1,2,1,1,1,1,1,1,1,5,5.5,5.5,4.5,5,5,0.8472222222222222,1.1472222222222221,6,4.285714285714286,4.785714285714286,5.490277777777777,5.5,5.5,5,5,5,5]
[9,"Kostka","Stanisław",1,1,1,3,1,1,1,1,1,1,1,4.5,5,5,4,4,4,0.7361111111111112,1.0361111111111112,6,4.285714285714286,4.785714285714286,4.958531746031746,5,5,5,5,5,5]
[10,"Kuzara","Michał",1,1,1,2,1,1,1,1,1,1,1,5,5.5,5.5,4.5,5,5,0.8472222222222222,1.1472222222222221,7,5,5.5,6.309722222222222,6.5,6.5,5,5,5,5]
[11,"Strzępek","Kamil",1,1,1,3,1,1,1,1,1,1,1,4.5,5,5,4,4,4,{"$f":"(O13/6+P13/6+Q13/6+R13/6+S13/6+T13/6)/6","v":0.7361111111111112},{"$f":"U13+$V$1","v":1.0361111111111112},7,{"$f":"5*W13/$X$1","v":5},{"$f":"X13+$Z$1","v":5.5},{"$f":"V13*Y13","v":5.698611111111112},{"$f":"MROUND(Z13,0.5)","v":5.5},{"$f":"IF(AA13<=2.5,2,AA13)","v":5.5},{"$f":"IF(AB13>=5,5,AB13)","v":5},{"$f":"AC13-$AB$1*(W30-1)","v":5},{"$f":"IF(AND(AC13>=3,AD13<3),3,AD13)","v":5},{"$f":"IF(AE13<=2.5,2,AE13)","v":5}]
[12,"Sudek","Bartosz",1,1,1,1,1,1,1,1,1,1,1,5.5,5,5,4,5,4,0.7916666666666666,1.0916666666666666,7,5,5.5,6.004166666666666,6,6,5,5,5,5]
[13,"Szymański","Piotr",1,1,1,1,1,1,1,1,1,1,1,5.5,5,5,4,5,4,0.7916666666666666,1.0916666666666666,5,3.5714285714285716,4.071428571428571,4.444642857142856,4.5,4.5,4.5,4.5,4.5,4.5]
[14,"Żaczek","Sławomir",1,1,1,3,1,1,1,1,1,1,1,4.5,5,5,4,4,4,0.7361111111111112,1.0361111111111112,4,2.857142857142857,3.357142857142857,3.478373015873016,3.5,3.5,3.5,3.5,3.5,3.5]
[15,"Żurek","Mariusz",1,1,1,3,1,1,1,1,1,1,1,4.5,5,5,4,4,4,0.7361111111111112,1.0361111111111112,6,4.285714285714286,4.785714285714286,4.958531746031746,5,5,5,5,5,5]
[]
[{"$nulls":19},"Nr","Nazwisko","Imię","Nr Zal.","Kol1, max 7","Kol2, max 7","Kol3, max 7"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Bielak"},{"$f":"C3","v":"Mateusz"},1]
[{"$nulls":19},{"$f":"A4","v":2},"Bielech","Kacper",1,7]
[{"$nulls":19},{"$f":"A5","v":3},"Ćmil","Michał",1,7]
[{"$nulls":19},{"$f":"A6","v":4},"Grocholski","Mirosław",1,7]
[{"$nulls":19},{"$f":"A7","v":5},"Grzybowski","Bartosz",1]
[{"$nulls":19},{"$f":"A8","v":6},"Indyk","Michał",1,6]
[{"$nulls":19},{"$f":"A9","v":7},"Kochmański","Michał",1,7]
[{"$nulls":19},{"$f":"A10","v":8},"Kołodziej","Damian",1,6]
[{"$nulls":19},{"$f":"A11","v":9},{"$f":"B11","v":"Kostka"},"Stanisław",1,6]
[{"$nulls":19},{"$f":"A12","v":10},"Kuzara","Michał",1,7]
[{"$nulls":19},{"$f":"A13","v":11},"Strzępek","Kamil",1,7]
[{"$nulls":19},{"$f":"A14","v":12},{"$f":"B14","v":"Sudek"},"Bartosz",1,7]
[{"$nulls":19},{"$f":"A15","v":13},{"$f":"B15","v":"Szymański"},{"$f":"C15","v":"Piotr"},1,5]
[{"$nulls":19},{"$f":"A16","v":14},{"$f":"B16","v":"Żaczek"},{"$f":"C16","v":"Sławomir"},1,4]
[{"$nulls":19},{"$f":"A17","v":15},{"$f":"B17","v":"Żurek"},{"$f":"C17","v":"Mariusz"},1,6]
[]
[{"$nulls":19},"EE_DI_03_2016","L_04"]
[{"$nulls":19},"Nr","Nazwisko","Imię","Wsp spr, %","Ocena Kol, %","OCENA KOŃCOWA Z LAB"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Bielak"},{"$f":"C3","v":"Mateusz"},{"$f":"U3*100","v":0},{"$f":"X3/5*100","v":0},{"$f":"IF(COUNTBLANK(H3:T3),2,AF3)","v":2}]
[{"$nulls":19},{"$f":"A4","v":2},"Bielech","Kacper",79.16666666666666,100,5]
[{"$nulls":19},{"$f":"A5","v":3},"Ćmil","Michał",79.16666666666666,100,5]
[{"$nulls":19},{"$f":"A6","v":4},"Grocholski","Mirosław",84.72222222222221,100,5]
[{"$nulls":19},{"$f":"A7","v":5},"Grzybowski","Bartosz",0,0,2]
[{"$nulls":19},{"$f":"A8","v":6},"Indyk","Michał",79.16666666666666,85.71428571428571,5]
[{"$nulls":19},{"$f":"A9","v":7},"Kochmański","Michał",84.72222222222221,100,5]
[{"$nulls":19},{"$f":"A10","v":8},"Kołodziej","Damian",84.72222222222221,85.71428571428571,5]
[{"$nulls":19},{"$f":"A11","v":9},{"$f":"B11","v":"Kostka"},"Stanisław",73.61111111111111,85.71428571428571,5]
[{"$nulls":19},{"$f":"A12","v":10},"Kuzara","Michał",84.72222222222221,100,5]
[{"$nulls":19},{"$f":"A13","v":11},"Strzępek","Kamil",73.61111111111111,100,5]
[{"$nulls":19},{"$f":"A14","v":12},"Sudek","Bartosz",79.16666666666666,100,5]
[{"$nulls":19},{"$f":"A15","v":13},{"$f":"B15","v":"Szymański"},"Piotr",{"$f":"U15*100","v":79.16666666666666},71.42857142857143,4.5]
[{"$nulls":19},{"$f":"A16","v":14},"Żaczek","Sławomir",73.61111111111111,57.14285714285714,3.5]
[{"$nulls":19},{"$f":"A17","v":15},"Żurek","Mariusz",73.61111111111111,85.71428571428571,{"$f":"IF(COUNTBLANK(H17:T17),2,AF17)","v":5}]
[]
["ĆWICZENIA",{"$nulls":21},"KL_PTS=",10,"KL_WSP=",0.5,"ZAL_WSP=",0.5]
["Nr","Nazwisko","Imię","W","C","L","G",{"$nulls":15},"Kol,max KL_PTS","Ocena Kol, <0,5>","Ocena Kol + KL_WSP","Ocena ważona, max 5","Ocena zaokr.","Ocena ogr. Dol","Ocena ogr. Gora","Ocena z ZAL_WSP","Ocena zaokr.","OCENA KOŃCOWA Z ĆW"]
[{"$f":"A3","v":1},"Bielak","Mateusz",1,1,1,0,{"$nulls":15},{"$f":"OFFSET(W73,0,W73)","v":0},{"$f":"5*W56/$X$54","v":0},{"$f":"X56+$Z$54","v":0.5},{"$f":"Y56*1","v":0.5},{"$f":"MROUND(Z56,0.5)","v":0.5},{"$f":"IF(AA56<=2.5,2,AA56)","v":2},{"$f":"IF(AB56>=5,5,AB56)","v":2},{"$f":"AC56-$AB$54*(W73-1)","v":2},{"$f":"IF(AND(AC56>=3,AD56<3),3,AD56)","v":2},{"$f":"IF(AE56<=2.5,2,AE56)","v":2}]
[{"$f":"A4","v":2},{"$f":"B4","v":"Bielech"},"Kacper",1,1,1,1,{"$nulls":15},{"$f":"OFFSET(W74,0,W74)","v":0},{"$f":"5*W57/$X$54","v":0},{"$f":"X57+$Z$54","v":0.5},{"$f":"Y57*1","v":0.5},0.5,2,2,{"$f":"AC57-$AB$54*(W74-1)","v":2},2,2]
[3,{"$f":"B5","v":"Ćmil"},"Michał",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[4,{"$f":"B6","v":"Grocholski"},"Mirosław",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[5,{"$f":"B7","v":"Grzybowski"},"Bartosz",1,1,1,"E",{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[6,{"$f":"B8","v":"Indyk"},"Michał",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[7,{"$f":"B9","v":"Kochmański"},"Michał",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[8,{"$f":"B10","v":"Kołodziej"},"Damian",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[9,{"$f":"B11","v":"Kostka"},"Stanisław",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[10,{"$f":"B12","v":"Kuzara"},"Michał",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[11,{"$f":"B13","v":"Strzępek"},"Kamil",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[12,{"$f":"B14","v":"Sudek"},"Bartosz",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[13,{"$f":"B15","v":"Szymański"},"Piotr",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[14,{"$f":"B16","v":"Żaczek"},"Sławomir",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[15,{"$f":"B17","v":"Żurek"},"Mariusz",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[]
[{"$nulls":19},"Nr","Nazwisko","Imię","Nr Zal.","Kol1, max 10","Kol2, max 10","Kol3, max 10"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Bielak"},{"$f":"C3","v":"Mateusz"},1]
[{"$nulls":19},{"$f":"A4","v":2},"Bielech","Kacper",1]
[{"$nulls":19},{"$f":"A5","v":3},"Ćmil","Michał",1]
[{"$nulls":19},{"$f":"A6","v":4},"Grocholski","Mirosław",1]
[{"$nulls":19},{"$f":"A7","v":5},"Grzybowski","Bartosz",1]
[{"$nulls":19},{"$f":"A8","v":6},"Indyk","Michał",1]
[{"$nulls":19},{"$f":"A9","v":7},"Kochmański","Michał",1]
[{"$nulls":19},{"$f":"A10","v":8},"Kołodziej","Damian",1]
[{"$nulls":19},{"$f":"A11","v":9},"Kostka","Stanisław",1]
[{"$nulls":19},{"$f":"A12","v":10},"Kuzara","Michał",1]
[{"$nulls":19},{"$f":"A13","v":11},"Strzępek","Kamil",1]
[{"$nulls":19},{"$f":"A14","v":12},"Sudek","Bartosz",1]
[{"$nulls":19},{"$f":"A15","v":13},"Szymański","Piotr",1]
[{"$nulls":19},{"$f":"A16","v":14},"Żaczek","Sławomir",1]
[{"$nulls":19},{"$f":"A17","v":15},"Żurek","Mariusz",1]
[]
["EGZAMIN",{"$nulls":21},"KL_PTS=",10,"KL_WSP=",0.5,"ZAL_WSP=",0.5]
["Nr","Nazwisko","Imię","W","C","L","G",{"$nulls":15},"Kol,max KL_PTS","Ocena Kol, <0,5>","Ocena Kol + KL_WSP","Ocena ważona, max 5","Ocena zaokr.","Ocena ogr. Dol","Ocena ogr. Gora","Ocena z ZAL_WSP","Ocena zaokr.","OCENA KOŃCOWA Z EGZ"]
[{"$f":"A3","v":1},"Bielak","Mateusz",1,1,1,0,{"$nulls":15},{"$f":"OFFSET(W108,0,W108)","v":0},{"$f":"5*W91/$X$54","v":0},{"$f":"X91+$Z$54","v":0.5},{"$f":"Y91*1","v":0.5},{"$f":"MROUND(Z91,0.5)","v":0.5},{"$f":"IF(AA91<=2.5,2,AA91)","v":2},{"$f":"IF(AB91>=5,5,AB91)","v":2},{"$f":"AC91-$AB$54*(W108-1)","v":2},{"$f":"IF(AND(AC91>=3,AD91<3),3,AD91)","v":2},{"$f":"IF(AE91<=2.5,2,AE91)","v":2}]
[{"$f":"A4","v":2},"Bielech","Kacper",1,1,1,1,{"$nulls":15},0,{"$f":"5*W92/$X$54","v":0},{"$f":"X92+$Z$54","v":0.5},{"$f":"Y92*1","v":0.5},0.5,2,2,{"$f":"AC92-$AB$54*(W109-1)","v":2},2,2]
[{"$f":"A5","v":3},"Ćmil","Michał",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A6","v":4},"Grocholski","Mirosław",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A7","v":5},"Grzybowski","Bartosz",1,1,1,"E",{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A8","v":6},"Indyk","Michał",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A9","v":7},"Kochmański","Michał",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A10","v":8},"Kołodziej","Damian",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A11","v":9},"Kostka","Stanisław",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A12","v":10},"Kuzara","Michał",1,1,1,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A13","v":11},"Strzępek","Kamil",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A14","v":12},"Sudek","Bartosz",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A15","v":13},"Szymański","Piotr",1,1,1,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A16","v":14},"Żaczek","Sławomir",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A17","v":15},"Żurek","Mariusz",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[]
[{"$nulls":19},"Nr","Nazwisko","Imię","Nr Zal.","Kol1, max 10","Kol2, max 10","Kol3, max 10"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Bielak"},{"$f":"C3","v":"Mateusz"},1]
[{"$nulls":19},{"$f":"A4","v":2},"Bielech","Kacper",1]
[{"$nulls":19},{"$f":"A5","v":3},"Ćmil","Michał",1]
[{"$nulls":19},{"$f":"A6","v":4},"Grocholski","Mirosław",1]
[{"$nulls":19},{"$f":"A7","v":5},"Grzybowski","Bartosz",1]
[{"$nulls":19},{"$f":"A8","v":6},"Indyk","Michał",1]
[{"$nulls":19},{"$f":"A9","v":7},"Kochmański","Michał",1]
[{"$nulls":19},{"$f":"A10","v":8},"Kołodziej","Damian",1]
[{"$nulls":19},{"$f":"A11","v":9},"Kostka","Stanisław",1]
[{"$nulls":19},{"$f":"A12","v":10},"Kuzara","Michał",1]
[{"$nulls":19},{"$f":"A13","v":11},"Strzępek","Kamil",1]
[{"$nulls":19},{"$f":"A14","v":12},"Sudek","Bartosz",1]
[{"$nulls":19},{"$f":"A15","v":13},"Szymański","Piotr",1]
[{"$nulls":19},{"$f":"A16","v":14},"Żaczek","Sławomir",1]
[{"$nulls":19},{"$f":"A17","v":15},"Żurek","Mariusz",1]
[]
["OCENA KOŃCOWA Z TO"]
["Nr","Nazwisko","Imię","ZW","LAB","ĆW","EGZ","ZAL"]
[{"$f":"A3","v":1},{"$f":"B3","v":"Bielak"},{"$f":"C3","v":"Mateusz"},{"$f":"IF(AND(E126>=4.5,F126>=4.5),1,0)","v":0},{"$f":"Y38","v":2},{"$f":"AF56","v":2},{"$f":"IF(D126=0,AF91,MROUND((E126+F126)/2,0.5))","v":2},{"$f":"IF(AND(E126>=3,F126>=3,G126>=3),MROUND((E126+F126+G126)/3,0.5),2)","v":2}]
[{"$f":"A4","v":2},"Bielech","Kacper",{"$f":"IF(AND(E127>=4.5,F127>=4.5),1,0)","v":0},{"$f":"Y39","v":5},{"$f":"AF57","v":2},{"$f":"IF(D127=0,AF92,MROUND((E127+F127)/2,0.5))","v":2},{"$f":"IF(AND(E127>=3,F127>=3,G127>=3),MROUND((E127+F127+G127)/3,0.5),2)","v":2}]
[{"$f":"A5","v":3},"Ćmil","Michał",0,5,2,2,2]
[{"$f":"A6","v":4},"Grocholski","Mirosław",0,5,2,2,2]
[{"$f":"A7","v":5},"Grzybowski","Bartosz",0,2,2,2,2]
[{"$f":"A8","v":6},"Indyk","Michał",0,5,2,2,2]
[{"$f":"A9","v":7},"Kochmański","Michał",0,5,2,2,2]
[{"$f":"A10","v":8},"Kołodziej","Damian",0,5,2,2,2]
[{"$f":"A11","v":9},"Kostka","Stanisław",0,5,2,2,2]
[{"$f":"A12","v":10},"Kuzara","Michał",0,5,2,2,2]
[{"$f":"A13","v":11},"Strzępek","Kamil",0,5,2,2,2]
[{"$f":"A14","v":12},"Sudek","Bartosz",0,5,2,2,2]
[{"$f":"A15","v":13},"Szymański","Piotr",0,4.5,2,2,2]
[{"$f":"A16","v":14},"Żaczek","Sławomir",0,3.5,2,2,2]
[{"$f":"A17","v":15},"Żurek","Mariusz",0,5,2,2,2]

{"sheet":"L2","index":2,"n_rows":140,"n_cols":32,"rows_kept":140}
["LABORATORIUM",{"$nulls":19},"SP_WSP=",0.3,"KL_PTS=",7,"KL_WSP=",0.5,"ZAL_WSP=",0.5]
["Nr","Nazwisko","Imię","W","C","L","G","BHP","Cw1","Cw2","Cw3","Cw4","Cw5","Cw6","Spr1, max 6","Spr2, max 6","Spr3, max 6","Spr4, max 6","Spr5, max 6","Spr6, max 6","Wsp spr, max 1","Wsp spr+SP_WSP","Kol,max KL_PTS","Ocena Kol, <0,5>","Ocena Kol + KL_WSP","Ocena ważona, max 5","Ocena zaokr.","Ocena ogr. Dol","Ocena ogr. Gora","Ocena z ZAL_WSP","Ocena zaokr.","Ocena bez uwzg. Obecn."]
[1,"Czernecki","Bartosz",1,1,2,"E",1,1,1,1,1,1,1,{"$nulls":6},{"$f":"(O3/6+P3/6+Q3/6+R3/6+S3/6+T3/6)/6","v":0},{"$f":"U3+$V$1","v":0.3},{"$f":"OFFSET(W20,0,W20)","v":0},{"$f":"5*W3/$X$1","v":0},{"$f":"X3+$Z$1","v":0.5},{"$f":"V3*Y3","v":0.15},{"$f":"MROUND(Z3,0.5)","v":0},{"$f":"IF(AA3<=2.5,2,AA3)","v":2},{"$f":"IF(AB3>=5,5,AB3)","v":2},{"$f":"AC3-$AB$1*(W20-1)","v":2},{"$f":"IF(AND(AC3>=3,AD3<3),3,AD3)","v":2},{"$f":"IF(AE3<=2.5,2,AE3)","v":2}]
[2,"Jaracz","Marcin",1,1,1,3,1,1,1,1,1,1,1,4.5,5,5,4,4,4,0.7361111111111112,1.0361111111111112,7,5,5.5,5.698611111111112,5.5,5.5,5,5,5,5]
[3,"Łokaj","Łukasz",1,1,2,3,1,1,1,1,1,1,1,5,4,4,4,4.5,4,0.7083333333333334,1.0083333333333333,7,5,5.5,5.545833333333333,5.5,5.5,5,5,5,5]
[4,"Miazga","Michał",1,1,2,"E",1,1,1,1,1,1,1,{"$nulls":6},0,0.3,0,0,0.5,0.15,0,2,2,2,2,2]
[5,"Nabożny","Paweł",1,1,2,1,1,1,1,1,1,1,1,5,4.5,5,5,4,4,0.763888888888889,1.0638888888888889,5,3.5714285714285716,4.071428571428571,4.331547619047619,4.5,4.5,4.5,4.5,4.5,4.5]
[6,"Nowicki","Przemysław",1,1,2,3,1,1,1,1,1,1,1,5,4,4,4,4.5,4,0.7083333333333334,1.0083333333333333,4,2.857142857142857,3.357142857142857,3.385119047619048,3.5,3.5,3.5,3.5,3.5,3.5]
[7,"Smalara","Krzysztof",1,1,2,1,1,1,1,1,1,1,1,5,4.5,5,5,4,4,0.763888888888889,1.0638888888888889,4.5,3.2142857142857144,3.7142857142857144,3.9515873015873018,4,4,4,4,4,4]
[8,"Stanisławczyk","Tomasz",1,1,2,3,1,1,1,1,1,1,1,5,4,4,4,4.5,4,0.7083333333333334,1.0083333333333333,4,2.857142857142857,3.357142857142857,3.385119047619048,3.5,3.5,3.5,3.5,3.5,3.5]
[9,"Stępień","Igor",1,1,2,1,1,1,1,1,1,1,1,5,4.5,5,5,4,4,0.763888888888889,1.0638888888888889,7,5,5.5,5.851388888888889,6,6,5,5,5,5]
[10,"Świerk","Kacper",1,1,2,2,1,1,1,1,1,1,1,4.5,4,3.5,4,4,3.5,0.6527777777777778,0.9527777777777777,5,3.5714285714285716,4.071428571428571,3.879166666666666,4,4,4,4,4,4]
[11,"Wróbel","Damian",1,1,2,2,1,1,1,1,1,1,1,4.5,4,3.5,4,4,3.5,0.6527777777777778,0.9527777777777777,5,3.5714285714285716,4.071428571428571,3.879166666666666,4,4,4,4,4,4]
[]
[]
[]
[]
[]
[{"$nulls":19},"Nr","Nazwisko","Imię","Nr Zal.","Kol1, max 7","Kol2, max 7","Kol3, max 7"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Czernecki"},{"$f":"C3","v":"Bartosz"},1]
[{"$nulls":19},2,"Jaracz","Marcin",1,7]
[{"$nulls":19},3,"Łokaj","Łukasz",1,7]
[{"$nulls":19},4,"Miazga","Michał",1]
[{"$nulls":19},5,"Nabożny","Paweł",1,5]
[{"$nulls":19},6,"Nowicki","Przemysław",1,4]
[{"$nulls":19},7,"Smalara","Krzysztof",1,4.5]
[{"$nulls":19},8,"Stanisławczyk","Tomasz",1,4]
[{"$nulls":19},9,"Stępień","Igor",1,7]
[{"$nulls":19},10,"Świerk","Kacper",1,5]
[{"$nulls":19},11,"Wróbel","Damian",1,5]
[{"$nulls":19},0,0,0,1]
[{"$nulls":19},{"$f":"A15","v":0},{"$f":"B15","v":0},{"$f":"C15","v":0},1]
[{"$nulls":19},{"$f":"A16","v":0},0,0,1]
[{"$nulls":19},{"$f":"A17","v":0},{"$f":"B17","v":0},{"$f":"C17","v":0},1]
[]
[{"$nulls":19},"EE_DI_03_2016","L_04"]
[{"$nulls":19},"Nr","Nazwisko","Imię","Wsp spr, %","Ocena Kol, %","OCENA KOŃCOWA Z LAB"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Czernecki"},{"$f":"C3","v":"Bartosz"},{"$f":"U3*100","v":0},{"$f":"X3/5*100","v":0},{"$f":"IF(COUNTBLANK(H3:T3),2,AF3)","v":2}]
[{"$nulls":19},2,"Jaracz","Marcin",73.61111111111111,100,5]
[{"$nulls":19},3,"Łokaj","Łukasz",70.83333333333334,100,5]
[{"$nulls":19},4,"Miazga","Michał",0,0,2]
[{"$nulls":19},5,"Nabożny","Paweł",76.3888888888889,71.42857142857143,4.5]
[{"$nulls":19},6,"Nowicki","Przemysław",70.83333333333334,57.14285714285714,3.5]
[{"$nulls":19},7,"Smalara","Krzysztof",76.3888888888889,64.28571428571429,4]
[{"$nulls":19},8,"Stanisławczyk","Tomasz",70.83333333333334,57.14285714285714,3.5]
[{"$nulls":19},9,"Stępień","Igor",76.3888888888889,100,5]
[{"$nulls":19},10,"Świerk","Kacper",65.27777777777779,71.42857142857143,4]
[{"$nulls":19},11,"Wróbel","Damian",65.27777777777779,71.42857142857143,4]
[{"$nulls":19},0,0,0,0,0,2]
[{"$nulls":19},{"$f":"A15","v":0},{"$f":"B15","v":0},{"$f":"C15","v":0},0,0,{"$f":"IF(COUNTBLANK(I15:T15),2,AF15)","v":2}]
[{"$nulls":19},{"$f":"A16","v":0},{"$f":"B16","v":0},{"$f":"C16","v":0},{"$f":"U16*100","v":0},0,{"$f":"IF(COUNTBLANK(I16:T16),2,AF16)","v":2}]
[{"$nulls":19},{"$f":"A17","v":0},{"$f":"B17","v":0},{"$f":"C17","v":0},{"$f":"U17*100","v":0},0,{"$f":"IF(COUNTBLANK(H17:T17),2,AF17)","v":2}]
[]
["ĆWICZENIA",{"$nulls":21},"KL_PTS=",10,"KL_WSP=",0.5,"ZAL_WSP=",0.5]
["Nr","Nazwisko","Imię","W","C","L","G",{"$nulls":15},"Kol,max KL_PTS","Ocena Kol, <0,5>","Ocena Kol + KL_WSP","Ocena ważona, max 5","Ocena zaokr.","Ocena ogr. Dol","Ocena ogr. Gora","Ocena z ZAL_WSP","Ocena zaokr.","OCENA KOŃCOWA Z ĆW"]
[{"$f":"A3","v":1},"Czernecki","Bartosz",1,1,2,"E",{"$nulls":15},{"$f":"OFFSET(W73,0,W73)","v":0},{"$f":"5*W56/$X$54","v":0},{"$f":"X56+$Z$54","v":0.5},{"$f":"Y56*1","v":0.5},{"$f":"MROUND(Z56,0.5)","v":0.5},{"$f":"IF(AA56<=2.5,2,AA56)","v":2},{"$f":"IF(AB56>=5,5,AB56)","v":2},{"$f":"AC56-$AB$54*(W73-1)","v":2},{"$f":"IF(AND(AC56>=3,AD56<3),3,AD56)","v":2},{"$f":"IF(AE56<=2.5,2,AE56)","v":2}]
[{"$f":"A4","v":2},"Jaracz","Marcin",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[3,"Łokaj","Łukasz",1,1,2,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[4,"Miazga","Michał",1,1,2,"E",{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[5,"Nabożny","Paweł",1,1,2,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[6,"Nowicki","Przemysław",1,1,2,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[7,"Smalara","Krzysztof",1,1,2,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[8,"Stanisławczyk","Tomasz",1,1,2,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[9,"Stępień","Igor",1,1,2,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[10,"Świerk","Kacper",1,1,2,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[11,"Wróbel","Damian",1,1,2,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[0,0,0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A15","v":0},{"$f":"B15","v":0},0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A16","v":0},{"$f":"B16","v":0},0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A17","v":0},{"$f":"B17","v":0},0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[]
[{"$nulls":19},"Nr","Nazwisko","Imię","Nr Zal.","Kol1, max 10","Kol2, max 10","Kol3, max 10"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Czernecki"},{"$f":"C3","v":"Bartosz"},1]
[{"$nulls":19},2,"Jaracz","Marcin",1]
[{"$nulls":19},3,"Łokaj","Łukasz",1]
[{"$nulls":19},4,"Miazga","Michał",1]
[{"$nulls":19},5,"Nabożny","Paweł",1]
[{"$nulls":19},6,"Nowicki","Przemysław",1]
[{"$nulls":19},7,"Smalara","Krzysztof",1]
[{"$nulls":19},8,"Stanisławczyk","Tomasz",1]
[{"$nulls":19},9,"Stępień","Igor",1]
[{"$nulls":19},10,"Świerk","Kacper",1]
[{"$nulls":19},11,"Wróbel","Damian",1]
[{"$nulls":19},0,0,0,1]
[{"$nulls":19},{"$f":"A15","v":0},{"$f":"B15","v":0},{"$f":"C15","v":0},1]
[{"$nulls":19},{"$f":"A16","v":0},0,0,1]
[{"$nulls":19},{"$f":"A17","v":0},{"$f":"B17","v":0},{"$f":"C17","v":0},1]
[]
["EGZAMIN",{"$nulls":21},"KL_PTS=",10,"KL_WSP=",0.5,"ZAL_WSP=",0.5]
["Nr","Nazwisko","Imię","W","C","L","G",{"$nulls":15},"Kol,max KL_PTS","Ocena Kol, <0,5>","Ocena Kol + KL_WSP","Ocena ważona, max 5","Ocena zaokr.","Ocena ogr. Dol","Ocena ogr. Gora","Ocena z ZAL_WSP","Ocena zaokr.","OCENA KOŃCOWA Z EGZ"]
[{"$f":"A3","v":1},"Czernecki","Bartosz",1,1,2,"E",{"$nulls":15},{"$f":"OFFSET(W108,0,W108)","v":0},{"$f":"5*W91/$X$54","v":0},{"$f":"X91+$Z$54","v":0.5},{"$f":"Y91*1","v":0.5},{"$f":"MROUND(Z91,0.5)","v":0.5},{"$f":"IF(AA91<=2.5,2,AA91)","v":2},{"$f":"IF(AB91>=5,5,AB91)","v":2},{"$f":"AC91-$AB$54*(W108-1)","v":2},{"$f":"IF(AND(AC91>=3,AD91<3),3,AD91)","v":2},{"$f":"IF(AE91<=2.5,2,AE91)","v":2}]
[{"$f":"A4","v":2},"Jaracz","Marcin",1,1,1,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[3,"Łokaj","Łukasz",1,1,2,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[4,"Miazga","Michał",1,1,2,"E",{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[5,"Nabożny","Paweł",1,1,2,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[6,"Nowicki","Przemysław",1,1,2,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[7,"Smalara","Krzysztof",1,1,2,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[8,"Stanisławczyk","Tomasz",1,1,2,3,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[9,"Stępień","Igor",1,1,2,1,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[10,"Świerk","Kacper",1,1,2,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[11,"Wróbel","Damian",1,1,2,2,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[0,0,0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A15","v":0},{"$f":"B15","v":0},0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A16","v":0},{"$f":"B16","v":0},0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[{"$f":"A17","v":0},{"$f":"B17","v":0},0,0,0,0,0,{"$nulls":15},0,0,0.5,0.5,0.5,2,2,2,2,2]
[]
[{"$nulls":19},"Nr","Nazwisko","Imię","Nr Zal.","Kol1, max 10","Kol2, max 10","Kol3, max 10"]
[{"$nulls":19},{"$f":"A3","v":1},{"$f":"B3","v":"Czernecki"},{"$f":"C3","v":"Bartosz"},1]
[{"$nulls":19},2,"Jaracz","Marcin",1]
[{"$nulls":19},3,"Łokaj","Łukasz",1]
[{"$nulls":19},4,"Miazga","Michał",1]
[{"$nulls":19},5,"Nabożny","Paweł",1]
[{"$nulls":19},6,"Nowicki","Przemysław",1]
[{"$nulls":19},7,"Smalara","Krzysztof",1]
[{"$nulls":19},8,"Stanisławczyk","Tomasz",1]
[{"$nulls":19},9,"Stępień","Igor",1]
[{"$nulls":19},10,"Świerk","Kacper",1]
[{"$nulls":19},11,"Wróbel","Damian",1]
[{"$nulls":19},0,0,0,1]
[{"$nulls":19},{"$f":"A15","v":0},{"$f":"B15","v":0},{"$f":"C15","v":0},1]
[{"$nulls":19},{"$f":"A16","v":0},0,0,1]
[{"$nulls":19},{"$f":"A17","v":0},{"$f":"B17","v":0},{"$f":"C17","v":0},1]
[]
["OCENA KOŃCOWA Z TO"]
["Nr","Nazwisko","Imię","ZW","LAB","ĆW","EGZ","ZAL"]
[{"$f":"A3","v":1},"Czernecki","Bartosz",{"$f":"IF(AND(E126>=4.5,F126>=4.5),1,0)","v":0},{"$f":"Y38","v":2},{"$f":"AF56","v":2},{"$f":"IF(D126=0,AF91,MROUND((E126+F126)/2,0.5))","v":2},{"$f":"IF(AND(E126>=3,F126>=3,G126>=3),MROUND((E126+F126+G126)/3,0.5),2)","v":2}]
[2,"Jaracz","Marcin",{"$f":"IF(AND(E127>=4.5,F127>=4.5),1,0)","v":0},{"$f":"Y39","v":5},2,2,2]
[3,"Łokaj","Łukasz",0,5,2,2,2]
[4,"Miazga","Michał",0,2,2,2,2]
[5,"Nabożny","Paweł",0,4.5,2,2,2]
[6,"Nowicki","Przemysław",0,3.5,2,2,2]
[7,"Smalara","Krzysztof",0,4,2,2,2]
[8,"Stanisławczyk","Tomasz",0,3.5,2,2,2]
[9,"Stępień","Igor",0,5,2,2,2]
[10,"Świerk","Kacper",0,4,2,2,2]
[11,"Wróbel","Damian",0,4,2,2,2]
[0,0,0,0,2,2,2,2]
[{"$f":"A15","v":0},{"$f":"B15","v":0},0,0,{"$f":"Y50","v":2},{"$f":"AF68","v":2},{"$f":"IF(D138=0,AF103,MROUND((E138+F138)/2,0.5))","v":2},{"$f":"IF(AND(E138>=3,F138>=3,G138>=3),MROUND((E138+F138+G138)/3,0.5),2)","v":2}]
[{"$f":"A16","v":0},{"$f":"B16","v":0},0,0,2,2,2,2]
[{"$f":"A17","v":0},{"$f":"B17","v":0},{"$f":"C17","v":0},0,2,2,2,2]

{"sheet":"Oceny_koncowe","index":3,"n_rows":32,"n_cols":12,"rows_kept":32}
["EFDU-Kompatybilność elektromagnetyczna  - wyniki zaliczenia z dnia 6 lutego 2020"]
[]
["W kwewsti wyjaśnień, wglądu do parc, poprawy oceny zapraszam w poniedziałek 10.02.2020 o 12.00"]
[]
["L,p,","Nazwiko","Imię","ZAL-I","Punkty","Zal-II","Lab","Wyklad","Usos",null,"Punkatacja"]
[{"$nulls":10},"30-28",5]
[{"$f":"1","v":1},null,null,2,{"$nulls":6},"27,5-25",4.5]
[{"$f":"A7+1","v":2},null,null,5,25.5,4.5,5,"w","5.0",null,"24,5-22",4]
[{"$f":"A8+1","v":3},null,null,5,25.5,4.5,5,"w","5.0",null,"21,5-19",3.5]
[4,null,null,5,26,4.5,4.5,"w","5.0",null,"18,5-15",3]
[5,null,null,"E",null,"E","E"]
[6,null,null,5,26,4.5,5,"w","5.0"]
[7,null,null,5,27,4.5,4.5,"w","5.0"]
[8,null,null,5,20,3.5,4.5,null,4.5]
[9,null,null,5,20.5,3.5,4.5,null,4.5]
[10,null,null,5,22,3.5,4.5,"w",4.5]
[11,null,null,5,20,3.5,4.5,null,4.5]
[12,null,null,5,25,4.5,5,"w","5.0"]
[13,null,null,4.5,22,4,5,null,4.5]
[14,null,null,3.5,22,4,4.5,null,"4.0"]
[15,null,null,5,22,3.5,4.5,null,4.5]
[16,null,null,"E",null,"E","E"]
[17,null,null,5,23,4,4.5,"w",4.5]
[18,null,null,5,23.5,4,4,"w","4.5"]
[19,null,null,"E",null,"E","E"]
[20,null,null,4.5,21.5,3.5,4.5,"w","4.0"]
[21,null,null,3.5,24,4,4,"w","4.0"]
[22,null,null,4,20,3.5,4.5,"w","4.0"]
[23,null,null,3.5,25,4.5,4,null,"4.0"]
[24,null,null,5,20.5,3.5,4.5,"w","4.5"]
[25,null,null,4,19.5,3.5,4.5,null,"4.0"]
[26,null,null,4,28,5,4.5,null,"4.5"]