{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Zadanie 1","Zadanie 2","Zadanie 3","Zadanie 4, 5","Zadanie 6","Zadanie 7","Wykresy"],"not_rendered":{"charts":5,"images":5,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Zadanie 1","index":0,"n_rows":7,"n_cols":6,"rows_kept":7,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Obszar","Grunty orne","Łąki i pastwiska","Lasy","Inne"]
[null,"Europa Zachodnia",{"v":0.248,"d":"24.80%"},{"v":0.185,"d":"18.50%"},{"v":0.292,"d":"29.20%"},{"v":0.275,"d":"27.50%"}]
[null,"Australia",{"v":0.058,"d":"5.80%"},{"v":0.585,"d":"58.50%"},{"v":0.058,"d":"5.80%"},{"v":0.299,"d":"29.90%"}]
[null,"ZSRR",{"v":0.104,"d":"10.40%"},{"v":0.167,"d":"16.70%"},{"v":0.408,"d":"40.80%"},{"v":0.321,"d":"32.10%"}]

{"sheet":"Zadanie 2","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,1,1,5]],"flags":["formulas_cached_only"]}
[]
[null,"Wykorzystanie różnych rodzajów energii na przykładzie Francji (w procencie ogólnie zużytej energii)"]
[]
[]
[null,"Rodzaj energii",1960,1970,1980,1990]
[null,"Energia nuklearna",{"v":0,"d":"0.00"},{"v":0.8,"d":"0.80"},{"v":10.8,"d":"10.80"},{"v":12.2,"d":"12.20"}]
[null,"Energia wodna",{"v":10.5,"d":"10.50"},{"v":8.3,"d":"8.30"},{"v":8.4,"d":"8.40"},{"v":22.2,"d":"22.20"}]
[null,"Gaz",{"v":3.4,"d":"3.40"},{"v":6.2,"d":"6.20"},{"v":13.2,"d":"13.20"},{"v":12.3,"d":"12.30"}]
[null,"Ropa naftowa",{"v":31.4,"d":"31.40"},{"v":59,"d":"59.00"},{"v":50.2,"d":"50.20"},{"v":42.3,"d":"42.30"}]
[null,"Węgiel",{"v":54.7,"d":"54.70"},{"v":25.7,"d":"25.70"},{"v":17.4,"d":"17.40"},{"v":11,"d":"11.00"}]

{"sheet":"Zadanie 3","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
["Id_prac","Nazwisko","Produkt","Sprzedał szt.","Cena za szt.","Razem"]
[1,"Nowak","Drukarka",12,{"v":430,"d":"430 zł"},{"v":5160,"d":"5,160 zł"}]
[1,"Nowak","Mikrofon",25,{"v":12,"d":"12 zł"},{"v":300,"d":"300 zł"}]
[1,"Nowak","Monitor",10,{"v":980,"d":"980 zł"},{"v":9800,"d":"9,800 zł"}]
[1,"Nowak","Mysz",50,{"v":23,"d":"23 zł"},{"v":1150,"d":"1,150 zł"}]
[2,"Kowalski","Drukarka",18,{"v":430,"d":"430 zł"},{"v":7740,"d":"7,740 zł"}]
[2,"Kowalski","Mikrofon",24,{"v":12,"d":"12 zł"},{"v":288,"d":"288 zł"}]
[2,"Kowalski","Monitor",12,{"v":980,"d":"980 zł"},{"v":11760,"d":"11,760 zł"}]
[2,"Kowalski","Mysz",35,{"v":23,"d":"23 zł"},{"v":805,"d":"805 zł"}]
[3,"Świder","Drukarka",4,{"v":430,"d":"430 zł"},{"v":1720,"d":"1,720 zł"}]
[3,"Świder","Mikrofon",40,{"v":12,"d":"12 zł"},{"v":480,"d":"480 zł"}]
[3,"Świder","Monitor",30,{"v":980,"d":"980 zł"},{"v":29400,"d":"29,400 zł"}]
[3,"Świder","Mysz",30,{"v":23,"d":"23 zł"},{"v":690,"d":"690 zł"}]
[4,"Baran","Drukarka",7,{"v":430,"d":"430 zł"},{"v":3010,"d":"3,010 zł"}]
[4,"Baran","Mikrofon",10,{"v":12,"d":"12 zł"},{"v":120,"d":"120 zł"}]
[4,"Baran","Monitor",14,{"v":980,"d":"980 zł"},{"v":13720,"d":"13,720 zł"}]
[4,"Baran","Mysz",16,{"v":23,"d":"23 zł"},{"v":368,"d":"368 zł"}]
[5,"Janik","Drukarka",9,{"v":430,"d":"430 zł"},{"v":3870,"d":"3,870 zł"}]
[5,"Janik","Mikrofon",32,{"v":12,"d":"12 zł"},{"v":384,"d":"384 zł"}]
[5,"Janik","Monitor",18,{"v":980,"d":"980 zł"},{"v":17640,"d":"17,640 zł"}]
[5,"Janik","Mysz",25,{"v":23,"d":"23 zł"},{"v":575,"d":"575 zł"}]

{"sheet":"Zadanie 4, 5","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"merged":[[0,4,0,5],[1,4,1,5],[2,4,2,5],[4,1,4,3],[12,5,12,7],[13,5,13,7]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"Razem >= 2000 zł premia:",null,{"v":0.2,"d":"20%"}]
[{"$nulls":4},"Razem < 2000 zł premia:",null,{"v":0.1,"d":"10%"}]
[{"$nulls":4},"Podatek:",null,{"v":0.19,"d":"19%"}]
[]
[null,"Wartość sprzedaży w I kwartale"]
["Pracownik","Styczeń","Luty","Marzec","Razem","Płaca zasadnicza","Premia","Płaca brutto","Płaca netto"]
["Koniuszko Marian",{"v":990,"d":"990.00 zł"},{"v":458,"d":"458.00 zł"},{"v":744,"d":"744.00 zł"},{"v":2192,"d":"2,192.00 zł"},{"v":1100,"d":"1,100.00 zł"},{"v":220,"d":"220.00 zł"},{"v":1320,"d":"1,320.00 zł"},{"v":1069.2,"d":"1,069.20 zł"}]
["Żydkiewicz Jacek",{"v":865,"d":"865.00 zł"},{"v":687,"d":"687.00 zł"},{"v":459,"d":"459.00 zł"},{"v":2011,"d":"2,011.00 zł"},{"v":1200,"d":"1,200.00 zł"},{"v":240,"d":"240.00 zł"},{"v":1440,"d":"1,440.00 zł"},{"v":1166.4,"d":"1,166.40 zł"}]
["Anioł Stanisław",{"v":586,"d":"586.00 zł"},{"v":445,"d":"445.00 zł"},{"v":754,"d":"754.00 zł"},{"v":1785,"d":"1,785.00 zł"},{"v":1200,"d":"1,200.00 zł"},{"v":120,"d":"120.00 zł"},{"v":1320,"d":"1,320.00 zł"},{"v":1069.2,"d":"1,069.20 zł"}]
["Balcerek Józef",{"v":870,"d":"870.00 zł"},{"v":445,"d":"445.00 zł"},{"v":832,"d":"832.00 zł"},{"v":2147,"d":"2,147.00 zł"},{"v":1340,"d":"1,340.00 zł"},{"v":268,"d":"268.00 zł"},{"v":1608,"d":"1,608.00 zł"},{"v":1302.48,"d":"1,302.48 zł"}]
["Kotek Zygmunt",{"v":699,"d":"699.00 zł"},{"v":755,"d":"755.00 zł"},{"v":745,"d":"745.00 zł"},{"v":2199,"d":"2,199.00 zł"},{"v":1020,"d":"1,020.00 zł"},{"v":204,"d":"204.00 zł"},{"v":1224,"d":"1,224.00 zł"},{"v":991.44,"d":"991.44 zł"}]
["Winnicki Jan",{"v":502,"d":"502.00 zł"},{"v":489,"d":"489.00 zł"},{"v":733,"d":"733.00 zł"},{"v":1724,"d":"1,724.00 zł"},{"v":1260,"d":"1,260.00 zł"},{"v":126,"d":"126.00 zł"},{"v":1386,"d":"1,386.00 zł"},{"v":1122.66,"d":"1,122.66 zł"}]
[{"$nulls":5},"Minimalna płaca netto:",null,null,{"v":991.44,"d":"991.44 zł"}]
[{"$nulls":5},"Maksymalna płaca netto:",null,null,{"v":1302.48,"d":"1,302.48 zł"}]

{"sheet":"Zadanie 6","index":4,"n_rows":20,"n_cols":16,"rows_kept":20,"flags":["formulas_cached_only"]}
["Ułóż tabelę i narysuj wykres funkcji",{"$nulls":10},"Na jednym układzie współrzędnych narysuj wykresy funkcji trygonometrycznych: "]
[]
["LINIOWA",{"$nulls":6},"KWADRATOWA",{"$nulls":3},"SIN x, COS x, sin2 x + cos2 x"]
["POTĘGA (lub ^)",{"$nulls":6},"y = 2x2 - 5x + 1"]
["Ułóż tabelę dla funkcji",null,"y = 2x - 1",{"$nulls":4},"gdy x należy do <-2; 4>",{"$nulls":3},"w przedziale (0;2π)"]
["narysuj wykres tej funkcji w przedziale <-4,4>",{"$nulls":6},"Wykres: XY punktowy w kolorze czeronym"]
[{"$nulls":7},"Tło wykresu: żółte"]
[]
["x","y = 2x - 1",{"$nulls":5},"x","y = 2x2 - 5x + 1",null,null,"wsp. A","x = a * pi()","sin(x)","cos(x)","y=sin2(x) + cos2(x)"]
[-4,{"$nulls":6},-2,{"$nulls":3},0,{"v":0,"d":"0.00"}]
[-3,{"$nulls":6},-1.5,{"$nulls":3},0.2]
[{"$nulls":11},0.4]
[{"$nulls":11},0.6]
[{"$nulls":11},0.8]
[{"$nulls":11},1]
[{"$nulls":11},1.2]
[{"$nulls":11},1.4]
[{"$nulls":11},1.6]
[{"$nulls":11},1.8]
[{"$nulls":11},2]

{"sheet":"Zadanie 7","index":5,"n_rows":54,"n_cols":8,"rows_kept":54,"flags":["formulas_cached_only"]}
["Narysuj odpowiednie wykresy do poszczególnych danych"]
[{"$nulls":7},"(umieść je po prawej stronie tabeli)"]
[null,"Wykres funkcji y = x4- 5x2",null,"LINIOWY"]
[null,"x","y= x4-5x2"]
[null,-2.5,7.8125]
[null,-2,-4]
[null,-1.5,-6.1875]
[null,-1,-4]
[null,-0.5,-1.1875]
[null,0,0]
[null,0.5,-1.1875]
[null,1,-4]
[null,1.5,-6.1875]
[null,2,-4]
[null,2.5,7.8125]
[]
[null,"Porównanie cen artykułów"]
[null,"Lata","Książki","Płyty DVD","KOMBI"]
[null,"2000 r.",{"v":22,"d":"22.00 zł"},{"v":10,"d":"10.00 zł"}]
[null,"2001 r.",{"v":24,"d":"24.00 zł"},{"v":8,"d":"8.00 zł"}]
[null,"2002 r.",{"v":25,"d":"25.00 zł"},{"v":6,"d":"6.00 zł"}]
[null,"2003 r.",{"v":26,"d":"26.00 zł"},{"v":5.5,"d":"5.50 zł"}]
[null,"2004 r.",{"v":25,"d":"25.00 zł"},{"v":4.8,"d":"4.80 zł"}]
[null,"2005 r.",{"v":30,"d":"30.00 zł"},{"v":5,"d":"5.00 zł"}]
[null,"średnia",{"v":25.333333333333332,"d":"25.33 zł"},{"v":6.55,"d":"6.55 zł"}]
[]
[null,"Wydatki w tygodniu"]
[null,"Dzień","Kwota","KOŁOWY"]
[null,"Pn",20]
[null,"Wt",30]
[null,"Śr",50]
[null,"Cz",25]
[null,"Pt",15]
[null,"So",40]
[null,"N",20]
[null,"Razem",200]
[]
["Struktura wydatków w miesiącu IX 2003 roku"]
[null,"Osoba","% wydatków","RADAROWY"]
[null,"Tata",{"v":0.35,"d":"35%"}]
[null,"Mama",{"v":0.4,"d":"40%"}]
[null,"Jaś",{"v":0.08,"d":"8%"}]
[null,"Małgosia",{"v":0.1,"d":"10%"}]
[null,"Marysia",{"v":0.07,"d":"7%"}]
[null,"Razem",{"v":1,"d":"100%"}]
[]
["Wzrost Jacka w dniu jego urodzin"]
[null,"Lata","Wzrost","KOLUMNOWY"]
[null,10,130]
[null,11,131]
[null,12,133]
[null,13,135]
[null,14,140]
[null,15,155]

{"sheet":"Wykresy","index":6,"n_rows":72,"n_cols":4,"rows_kept":72,"hidden":true,"flags":["formulas_cached_only"]}
{"$rows_empty":71}
[{"$nulls":3},"2019-03-05"]