{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["analiza struktury","analiza dynamiki"],"not_rendered":{"charts":0,"images":0,"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":"analiza struktury","index":0,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,3,0,8],[1,3,1,6],[3,7,3,8],[2,7,2,8],[2,3,2,6],[3,3,3,6],[23,0,23,3],[24,0,24,3],[27,0,27,3],[1,7,1,8],[8,3,8,6],[4,3,4,6],[8,7,8,8],[7,7,7,8],[6,7,6,8],[5,7,5,8],[4,7,4,8],[5,3,5,6],[6,3,6,6],[7,3,7,6],[23,6,23,9],[33,0,33,3],[32,0,32,3],[30,0,30,3],[24,6,24,9],[26,6,26,9],[27,6,27,9],[29,6,29,9],[29,0,29,3],[26,0,26,3],[30,6,30,9]]}
["DATA","ZYSK",null,"LISTA UTWORZONYCH FUNKCJI",null,null,null,null,null,null,null,"(x-xśr)^3"]
["2020-02-01",134,null,"NAZWA MIARY",null,null,null,"KOMENDA FUNKCJI",null,null,null,{"$f":"(B2-$E$24)^3","v":-64}]
["2020-02-02",123,null,"średnia ",null,null,null,"SREDNIA",null,null,null,-3375]
["2020-02-03",131,null,"wariancja",null,null,null,"WAR",null,null,null,-343]
["2020-02-04",156,null,"odchylenie standardowe",null,null,null,"ODC",null,null,null,5832]
["2020-02-05",128,null,"współczynnik zmienności",null,null,null,"WSPZMIEN",null,null,null,-1000]
["2020-02-06",144,null,"trzeci moment centralny zestandaryzowany",null,null,null,"TRZECIMOM",null,null,null,216]
["2020-02-07",179,null,"współczynnik asymetrii",null,null,null,"WSPASYMETRII",null,null,null,68921]
["2020-02-08",125,null,"rozstęp",null,null,null,"ROZSTEP",null,null,null,-2197]
["2020-02-09",111,null,null,null,null,null,null,null,null,null,-19683]
["2020-02-10",149,null,null,null,null,null,null,null,null,null,1331]
[]
["n",10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["średnia ",null,null,null,{"$f":"AVERAGE(B2:B11)","v":138},null,"trzeci moment centralny zestandaryzowany",null,null,null,{"$f":"SUM(L2:L11)/B13","v":4963.8}]
["średnia ",null,null,null,null,null,"trzeci moment centralny zestandaryzowany"]
[]
["wariancja",null,null,null,{"$f":"_xlfn.VAR.P(B2:B11)","v":345},null,"współczynnik asymetrii",null,null,null,{"$f":"K24/(E30)^3","v":0.77461451751777455}]
["wariancja",null,null,null,null,null,"współczynnik asymetrii"]
[]
["odchylenie standardowe",null,null,null,{"$f":"_xlfn.STDEV.P(B2:B11)","v":18.574175621006709},null,"rozstęp",null,null,null,{"$f":"MAX(B2:B11)-MIN(B2:B11)","v":68}]
["odchylenie standardowe",null,null,null,null,null,"rozstęp"]
[]
["współczynnik zmienności",null,null,null,{"$f":"(E30/E24)*100","v":13.459547551454138}]
["współczynnik zmienności"]

{"sheet":"analiza dynamiki","index":1,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,0,1,0],[0,6,0,11],[1,6,1,9],[1,10,1,11],[2,6,2,9],[2,10,2,11],[3,6,3,9],[3,10,3,11],[4,6,4,9],[4,10,4,11],[21,0,21,1],[21,3,21,4],[10,12,10,13],[5,6,5,9],[5,10,5,11],[6,6,6,9],[6,10,6,11],[7,10,7,11],[8,10,8,11],[7,6,7,9],[8,6,8,9],[10,0,10,1],[10,3,10,4],[10,6,10,7],[10,9,10,10]]}
["MODEL","ROK 2017",null,"ROK 2018",null,null,"LISTA UTWORZONYCH FUNKCJI"]
[null,"q0","p0","qt","pt",null,"NAZWA MIARY",null,null,null,"KOMENDA FUNKCJI"]
["A350",240,300,190,250,null,"indeks wartości",null,null,null,"Iw"]
["A400",160,450,230,350,null,"indeks cen Laspayresa",null,null,null,"IpL"]
["A500",70,600,90,550,null,"indesk ilości Laspayresa",null,null,null,"IqL"]
[null,null,null,null,null,null,"indeks cen Paaschego",null,null,null,"IpP"]
[null,null,null,null,null,null,"indeks ilości Paaschego",null,null,null,"IqP"]
[null,null,null,null,null,null,"indeks cen Fishera",null,null,null,"IpF"]
[null,null,null,null,null,null,"indeks ilości Fishera",null,null,null,"IqF"]
[]
["indeks wartości",null,null,"indeks cen Laspayresa",null,null,"indeks ilości Laspayresa",null,null,"indeks cen Paaschego",null,null,"indeks ilości Paaschego"]
["qtpt","p0q0",null,"q0pt","q0p0",null,"qtp0","q0p0",null,"qtpt","qtp0",null,"qtpt","q0pt"]
[{"$f":"D3*E3","v":47500},{"$f":"B3*C3","v":72000},null,{"$f":"B3*E3","v":60000},{"$f":"B3*C3","v":72000},null,{"$f":"D3*C3","v":57000},{"$f":"B3*C3","v":72000},null,{"$f":"D3*E3","v":47500},{"$f":"D3*C3","v":57000},null,{"$f":"D3*E3","v":47500},{"$f":"B3*E3","v":60000}]
[{"$f":"D4*E4","v":80500},{"$f":"B4*C4","v":72000},null,{"$f":"B4*E4","v":56000},{"$f":"B4*C4","v":72000},null,{"$f":"D4*C4","v":103500},{"$f":"B4*C4","v":72000},null,{"$f":"D4*E4","v":80500},{"$f":"D4*C4","v":103500},null,{"$f":"D4*E4","v":80500},{"$f":"B4*E4","v":56000}]
[{"$f":"D5*E5","v":49500},{"$f":"B5*C5","v":42000},null,{"$f":"B5*E5","v":38500},{"$f":"B5*C5","v":42000},null,{"$f":"D5*C5","v":54000},{"$f":"B5*C5","v":42000},null,{"$f":"D5*E5","v":49500},{"$f":"D5*C5","v":54000},null,{"$f":"D5*E5","v":49500},{"$f":"B5*E5","v":38500}]
[]
[{"$f":"SUM(A13:A15)","v":177500},{"$f":"SUM(B13:B15)","v":186000},null,{"$f":"SUM(D13:D15)","v":154500},{"$f":"SUM(E13:E15)","v":186000},null,{"$f":"SUM(G13:G15)","v":214500},{"$f":"SUM(H13:H15)","v":186000},null,{"$f":"SUM(J13:J15)","v":177500},{"$f":"SUM(K13:K15)","v":214500},null,{"$f":"SUM(M13:M15)","v":177500},{"$f":"SUM(N13:N15)","v":154500}]
["Iw",{"$f":"A17/B17","v":0.95430107526881724},null,"IpL",{"$f":"D17/E17","v":0.83064516129032262},null,"IqL",{"$f":"G17/H17","v":1.153225806451613},null,"IpP",{"$f":"J17/K17","v":0.82750582750582746},null,"IqP",{"$f":"M17/N17","v":1.1488673139158576}]
["Iw",null,null,"IpL",null,null,"IqL",null,null,"IpP",null,null,"IqP"]
[]
[]
["indeks ilości Fishera",null,null,"indeks ilości Fishera"]
["IqF",{"$f":"SQRT(H18*N18)","v":1.1510444972269809},null,"IpF",{"$f":"SQRT(E18*K18)","v":0.82907400849216106}]
["IqF",null,null,"IpF"]