{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Zapas_sym","Arkusz16","Moduł1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Moduł1","index":2,"reason":"part_missing"}],"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":"Zapas_sym","index":0,"n_rows":165,"n_cols":26,"rows_kept":165,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Q",15,"R",2,null,"Kz",80," Ku",1.5,"Kb",150]
["Dzień","Zapas pocz. ZP","Dostawa Q","Zapas po dostawie","L.los.","Zapotrz. P   ","Sprzedaż","Stracona sprz.","Zapas końc. ZK","L.los.","Czas dostawy","Dzień dostawy","Koszt dostawy","K. utrz. zapasu","K. braku zapasu","Koszty razem KR",null,null,"Zapotrzebowanie","Dni","Prawd.",0,"Czas dostawy","Dni","Prawd.",0]
[1,3,0,{"$f":"B4+C4","v":3},{"$f":"RAND()","v":0.5510697690991575},{"$f":"INDEX($S$4:$S$9,MATCH(E4,$V$3:$V$9))","v":1},{"$f":"MIN(D4,F4)","v":1},{"$f":"F4-G4","v":0},{"$f":"D4-G4","v":2},{"$f":"RAND()","v":2.6411854458437078E-2},{"$f":"IF(I4<=$E$2,INDEX($W$4:$W$7,MATCH(J4,$Z$3:$Z$7)),0)","v":1},{"$f":"IF(K4>0, K4+A4,0)","v":2},{"$f":"IF(C4>0,$H$2,0)","v":0},{"$f":"I4*$J$2","v":3},{"$f":"H4*$L$2","v":0},{"$f":"M4+N4+O4","v":3},null,null,0,45,{"$f":"T4/T$10","v":0.45},{"$f":"U4","v":0.45},1,20,{"$f":"X4/X$10","v":0.2},{"$f":"Y4","v":0.2}]
[{"$f":"A4+1","v":2},{"$f":"I4","v":2},{"$f":"IF(A5=L4,$C$2,0)+IF(A5=L3,$C$2,0)+IF(A5=L2,$C$2,0)+IF(A5=L1,$C$2,0)","v":15},{"$f":"B5+C5","v":17},0.78415128194833406,{"$f":"INDEX($S$4:$S$9,MATCH(E5,$V$3:$V$9))","v":2},{"$f":"MIN(D5,F5)","v":2},{"$f":"F5-G5","v":0},{"$f":"D5-G5","v":15},0.16567275021081018,{"$f":"IF(AND(I5<=$E$2,A5>L4),INDEX($W$4:$W$7,MATCH(J5,$Z$3:$Z$7)),0)","v":0},{"$f":"IF(K5>0, K5+A5,0)","v":0},{"$f":"IF(C5>0,$H$2,0)","v":80},{"$f":"I5*$J$2","v":22.5},{"$f":"H5*$L$2","v":0},{"$f":"M5+N5+O5","v":102.5},null,null,1,20,0.2,{"$f":"V4+U5","v":0.65},2,48,{"$f":"X5/X$10","v":0.48},{"$f":"Z4+Y5","v":0.67999999999999994}]
[{"$f":"A5+1","v":3},{"$f":"I5","v":15},{"$f":"IF(A6=L5,$C$2,0)+IF(A6=L4,$C$2,0)+IF(A6=L3,$C$2,0)+IF(A6=L2,$C$2,0)","v":0},15,0.4726613278526357,1,1,0,14,0.77084331021263641,{"$f":"IF(AND(I6<=$E$2,A6>L5,A6>L4),INDEX($W$4:$W$7,MATCH(J6,$Z$3:$Z$7)),0)","v":0},0,0,21,0,21,null,null,2,15,0.15,{"$f":"V5+U6","v":0.8},3,22,{"$f":"X6/X$10","v":0.22},{"$f":"Z5+Y6","v":0.89999999999999991}]
[4,14,{"$f":"IF(A7=L6,$C$2,0)+IF(A7=L5,$C$2,0)+IF(A7=L4,$C$2,0)+IF(A7=L3,$C$2,0)","v":0},14,0.41820372734175082,0,0,0,14,0.68936434426026016,{"$f":"IF(AND(I7<=$E$2,A7>L6,A7>L5,A7>L4),INDEX($W$4:$W$7,MATCH(J7,$Z$3:$Z$7)),0)","v":0},0,{"$f":"IF(C7>0,$H$2,0)","v":0},21,0,21,null,null,3,10,0.1,{"$f":"V6+U7","v":0.9},4,10,{"$f":"X7/X$10","v":0.1},{"$f":"Z6+Y7","v":0.99999999999999989}]
[5,14,0,14,0.65869137643440812,2,2,0,12,9.5700333534608273E-2,0,0,0,18,0,18,null,null,4,6,0.06,{"$f":"V7+U8","v":0.96}]
[6,12,0,12,0.6640071185551718,2,2,0,10,0.48998331506259185,0,0,0,15,0,15,null,null,5,4,0.04,{"$f":"V8+U9","v":1}]
[7,10,0,10,0.94216732340768428,4,4,0,6,0.8158708848168027,0,0,0,9,0,9,null,null,"RAZEM",{"$f":"SUM(T4:T9)","v":100},{"$f":"SUM(U4:U9)","v":1},null,null,{"$f":"SUM(X4:X9)","v":100},{"$f":"SUM(Y4:Y9)","v":0.99999999999999989}]
[8,6,0,6,0.5486901858621871,1,1,0,5,0.9065096289976915,0,0,0,7.5,0,7.5]
[9,5,0,5,0.36698738655764085,0,0,0,5,0.22550459495798536,0,0,0,7.5,0,7.5]
[10,5,0,5,0.46280355454937161,1,1,0,4,0.38343551624053518,0,0,0,6,0,6]
[11,4,0,4,0.760814122919795,2,2,0,2,0.86284699925549979,3,14,0,3,0,3]
[12,2,0,2,0.28562335873457323,0,0,0,2,0.31732103782473098,0,0,0,3,0,3]
[13,2,0,2,0.50305099968143729,1,1,0,1,9.9685260570665735E-2,0,0,0,1.5,0,1.5]
[14,1,15,16,0.921633188316754,4,4,0,12,0.1212848331295715,0,0,80,18,0,98]
[15,12,0,12,0.10709825848694687,0,0,0,12,0.40125703099885268,0,0,0,18,0,18]
[16,12,0,12,0.45067266396669026,1,1,0,11,0.81743680357752047,0,0,0,16.5,0,16.5]
[17,11,0,11,0.10896631939430579,0,0,0,11,0.92474669919292574,0,0,0,16.5,0,16.5]
[18,11,0,11,0.11924876501893866,0,0,0,11,0.35805367882889549,0,0,0,16.5,0,{"$f":"M21+N21+O21","v":16.5}]
[{"$f":"A21+1","v":19},11,0,11,0.63892710640181072,1,1,0,10,0.54063770716486892,0,0,0,15,0,{"$f":"M22+N22+O22","v":15}]
[{"$f":"A22+1","v":20},10,0,10,0.39911541539218931,0,0,0,10,0.50852567118695646,0,0,0,15,0,{"$f":"M23+N23+O23","v":15}]
[{"$f":"A23+1","v":21},{"$f":"I23","v":10},{"$f":"IF(A24=L23,$C$2,0)+IF(A24=L22,$C$2,0)+IF(A24=L21,$C$2,0)+IF(A24=L20,$C$2,0)","v":0},{"$f":"B24+C24","v":10},1.246224827735809E-2,{"$f":"INDEX($S$4:$S$9,MATCH(E24,$V$3:$V$9))","v":0},{"$f":"MIN(D24,F24)","v":0},{"$f":"F24-G24","v":0},{"$f":"D24-G24","v":10},0.50090168583932815,0,{"$f":"IF(K24>0, K24+A24,0)","v":0},{"$f":"IF(C24>0,$H$2,0)","v":0},15,{"$f":"H24*$L$2","v":0},{"$f":"M24+N24+O24","v":15}]
[22,10,0,10,0.72685148298510971,2,2,0,8,0.3011064546619221,0,0,0,12,0,12]
[23,8,0,8,0.9537666661008426,4,4,0,4,0.75533513564211452,0,0,0,6,0,6]
[24,4,0,4,0.41969168319746508,0,0,0,4,2.14483779048118E-2,0,0,0,6,0,6]
[25,4,0,4,0.27074625319575052,0,0,0,4,0.51812383933403705,0,0,0,6,0,6]
[26,4,0,4,0.33871829685672095,0,0,0,4,0.53170732772629281,0,0,0,6,0,6]
[27,4,0,4,0.20731746829737929,0,0,0,4,0.39209286361100437,0,0,0,6,0,6]
[28,4,0,4,0.43732214052399609,0,0,0,4,0.98052917376133186,0,0,0,6,0,6]
[29,4,0,4,0.22968984069547715,0,0,0,4,0.54115554150381506,0,0,0,6,0,6]
[30,4,0,4,0.8349212185282443,3,3,0,1,0.79963374687603572,3,33,0,1.5,0,1.5]
[31,1,0,1,0.58739797997611409,1,1,0,0,4.1210908129664214E-2,0,0,0,0,0,0]
[32,0,0,0,2.0445058684024686E-2,0,0,0,0,0.87068833667375989,0,0,0,0,0,0]
[33,0,15,15,0.48630829733939362,1,1,0,14,0.656163917219177,0,0,80,21,0,101]
[34,14,0,14,0.85542939444422339,3,3,0,11,0.3844484191565547,0,0,0,16.5,0,16.5]
[35,11,0,11,0.79018541463464276,2,2,0,9,0.99385961867515449,0,0,0,13.5,0,13.5]
[36,9,0,9,0.40624488850287543,0,0,0,9,0.76418789089817585,{"$f":"IF(AND(I39<=$E$2,A39>L38,A39>L37,A39>L36),INDEX($W$4:$W$7,MATCH(J39,$Z$3:$Z$7)),0)","v":0},0,0,13.5,0,13.5]
[37,9,0,9,0.35913536124605405,0,0,0,9,0.26261094832723997,0,0,0,13.5,0,13.5]
[38,9,0,9,0.68031792368143273,2,2,0,7,0.11411008746036222,0,0,0,10.5,0,10.5]
[39,7,0,7,0.50959921317342505,1,1,0,6,0.44899799415252239,0,0,0,9,0,9]
[40,6,0,6,0.5226577288182217,1,1,0,5,0.63832538644961256,0,0,0,7.5,0,7.5]
[41,5,0,5,0.30602112399171311,0,0,0,5,0.39157404076847957,0,0,0,7.5,0,7.5]
[42,5,0,5,0.2189878731543009,0,0,0,5,0.65908195344252152,0,0,0,7.5,0,7.5]
[43,5,0,5,0.52454778716609629,1,1,0,4,0.89720247560835653,0,0,0,6,0,6]
[44,4,0,4,0.94511242612822788,4,4,0,0,0.95999560285784247,4,48,0,0,0,0]
[45,0,0,0,0.29532381475612757,0,0,0,0,0.55470692309155389,0,0,0,0,0,0]
[46,0,0,0,0.18305143358365927,0,0,0,0,0.31838450811554697,0,0,0,0,0,0]
[47,0,0,0,0.57890935099185148,1,0,1,0,0.91414513998385627,0,0,0,0,150,150]
[48,0,15,15,0.6633674475249759,2,2,0,13,0.71120387414106068,0,0,80,19.5,0,99.5]
[49,13,0,13,0.20802440638323239,0,0,0,13,0.99706111038899092,0,0,0,19.5,0,19.5]
[50,13,0,13,0.1368993236552809,0,0,0,13,0.84072719553386588,0,0,0,19.5,0,19.5]
[51,13,0,13,0.53759867096373637,1,1,0,12,0.2057042589361715,0,0,0,18,0,18]
[52,12,0,12,0.66427359303151323,2,2,0,10,8.5615262691535632E-2,0,0,0,15,0,15]
[53,10,0,10,8.0460697846364893E-2,0,0,0,10,0.68920489802885621,0,0,0,15,0,15]
[54,10,0,10,3.6145240988805227E-4,0,0,0,10,0.65421781734600826,0,0,0,15,0,15]
[55,10,0,10,0.50599343453454615,1,1,0,9,0.44969668118563588,0,0,0,13.5,0,13.5]
[56,9,0,9,0.8951956935211266,3,3,0,6,0.56257745356844979,0,0,0,9,0,9]
[57,6,0,6,0.53353292455622858,1,1,0,5,0.65333736991757285,0,0,0,7.5,0,7.5]
[58,5,0,5,0.30370376130636623,0,0,0,5,7.328960437969767E-2,0,0,0,7.5,0,7.5]
[59,5,0,5,0.79563428279563086,2,2,0,3,0.3886861625846022,0,0,0,4.5,0,4.5]
[60,3,0,3,0.78860653645759093,2,2,0,1,0.66078084049125452,2,62,0,1.5,0,1.5]
[61,1,0,1,0.48966815426217991,1,1,0,0,0.93492274165305567,0,0,0,0,0,0]
[62,0,15,15,0.67415782951314041,2,2,0,13,0.23784678982311303,0,0,80,19.5,0,99.5]
[63,13,0,13,0.41688397615056971,0,0,0,13,0.18107985218627365,0,0,0,19.5,0,19.5]
[64,13,0,13,0.57424147283589699,1,1,0,12,0.27451634035864225,0,0,0,18,0,18]
[65,12,0,12,{"$f":"RAND()","v":0.46848642742057423},1,1,0,11,{"$f":"RAND()","v":0.89357720641290905},0,0,0,16.5,0,16.5]
[66,11,0,11,0.37963353073681549,0,0,0,11,0.70078979901349681,0,0,0,{"$f":"I69*$J$2","v":16.5},0,16.5]
[67,11,0,11,0.68740635958998542,2,2,0,9,0.87007410626259585,0,0,0,13.5,0,13.5]
[68,9,0,9,0.43598638876235696,0,0,0,9,0.68428061991710176,{"$f":"IF(AND(I71<=$E$2,A71>L70,A71>L69,A71>L68),INDEX($W$4:$W$7,MATCH(J71,$Z$3:$Z$7)),0)","v":0},0,0,13.5,0,13.5]
[69,9,0,9,0.14527478622164625,0,0,0,9,0.87680419716065783,0,0,0,13.5,0,13.5]
[70,9,0,9,0.20832485233389175,0,0,0,9,9.1838084978488332E-3,0,0,0,13.5,0,13.5]
[71,9,0,9,6.215171148826415E-2,0,0,0,9,8.2502710599521634E-2,0,0,0,13.5,0,13.5]
[72,9,0,9,0.50362387946759568,1,1,0,8,0.89553647256267199,0,0,0,12,0,12]
[73,8,0,8,0.10484488813090842,0,0,0,8,0.74975477374680333,0,0,0,12,0,12]
[74,8,0,8,6.1848830815015465E-2,0,0,0,8,6.9555803099763613E-2,0,0,0,12,0,12]
[75,8,0,8,7.023198202707992E-2,0,0,0,8,0.39172526832328058,0,0,0,12,0,12]
[76,8,0,8,0.16844610372563384,0,0,0,8,0.56792928597882708,0,0,0,12,0,12]
[77,8,0,8,0.40764116435443576,0,0,0,8,0.60962400164743558,0,0,0,12,0,12]
[78,8,0,8,0.23677604638248984,0,0,0,8,0.63082240462939387,0,0,0,12,0,12]
[79,8,0,8,0.22681649679426752,0,0,0,8,0.49868256248915022,0,0,0,12,0,12]
[80,8,0,8,0.27139230227780209,0,0,0,8,0.48204444992319662,0,0,0,12,0,12]
[81,8,0,8,0.37873344009166809,0,0,0,8,0.31235563396079535,0,0,0,12,0,12]
[82,8,0,8,0.53620779208694902,1,1,0,7,0.82600274832998744,0,0,0,10.5,0,10.5]
[83,7,0,7,0.61138508986505469,1,1,0,6,0.79679365335183883,0,0,0,9,0,9]
[84,6,0,6,3.5528798777831994E-2,0,0,0,6,0.18199186917081567,0,0,0,9,0,9]
[{"$f":"A87+1","v":85},{"$f":"I87","v":6},{"$f":"IF(A88=L87,$C$2,0)+IF(A88=L86,$C$2,0)+IF(A88=L85,$C$2,0)+IF(A88=L84,$C$2,0)","v":0},{"$f":"B88+C88","v":6},0.65994613991208262,{"$f":"INDEX($S$4:$S$9,MATCH(E88,$V$3:$V$9))","v":2},{"$f":"MIN(D88,F88)","v":2},{"$f":"F88-G88","v":0},{"$f":"D88-G88","v":4},0.7322878597203768,0,{"$f":"IF(K88>0, K88+A88,0)","v":0},{"$f":"IF(C88>0,$H$2,0)","v":0},6,{"$f":"H88*$L$2","v":0},{"$f":"M88+N88+O88","v":6}]
[86,4,0,4,0.40354333523398156,0,0,0,4,0.91791267032901724,0,0,0,6,0,6]
[87,4,0,4,0.53891521120945607,1,1,0,3,0.44522703932960406,0,0,0,4.5,0,4.5]
[88,3,0,3,0.85021877775104926,3,3,0,0,0.4191221372802012,2,90,0,0,0,0]
[89,0,0,0,0.88299367504932524,3,0,3,0,4.1101046259897744E-2,0,0,0,0,450,450]
[90,0,15,15,0.7632153227325903,2,2,0,13,0.49099823436304291,0,0,80,19.5,0,99.5]
[91,13,0,13,5.0263948218005283E-2,0,0,0,13,7.4357171297766311E-2,0,0,0,19.5,0,19.5]
[92,13,0,13,0.32749510578730756,0,0,0,13,0.61733198278037249,0,0,0,19.5,0,19.5]
[93,13,0,13,0.54848715811964355,1,1,0,12,0.43233338574215219,0,0,0,18,0,18]
[94,12,0,12,0.67166943396299095,2,2,0,10,0.12983492454443979,0,0,0,15,0,15]
[95,10,0,10,0.54445224498204359,1,1,0,9,0.62302380797186885,0,0,0,13.5,0,13.5]
[96,9,0,9,0.84079289936388901,3,3,0,6,0.27868972994314944,0,0,0,9,0,9]
[97,6,0,6,0.98331008928325148,5,5,0,1,0.51489687672401363,2,99,0,1.5,0,1.5]
[98,1,0,1,0.82728392662653716,3,1,2,0,0.91050280337063738,0,0,0,0,300,300]
[99,0,15,15,0.26145934500265,0,0,0,15,7.4940049979998591E-2,0,0,80,22.5,0,102.5]
[100,15,0,15,0.1057985016952353,0,0,0,15,0.26462954028599206,{"$f":"IF(AND(I103<=$E$2,A103>L102,A103>L101,A103>L100),INDEX($W$4:$W$7,MATCH(J103,$Z$3:$Z$7)),0)","v":0},0,0,22.5,0,22.5]
["Razem",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M4:M103)","v":560},{"$f":"SUM(N4:N103)","v":1098},{"$f":"SUM(O4:O103)","v":900},3191]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[]
[]
["Wyniki badań (każda grupa bada inne pary [Q,R])"]
[]
["Q",10,15]
["R",5,2]
[1,2168,2842.5]
[2,3595.5,3191]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
["średnia",{"$f":"AVERAGE(B112:B161)","v":2881.75},{"$f":"AVERAGE(C112:C161)","v":3016.75}]
["od.st",{"$f":"STDEV(B112:B161)","v":1009.3949301437966},{"$f":"STDEV(C112:C161)","v":246.42671324351181}]
[]
["Testy statystyczne i interpretacja wyników"]

{"sheet":"Arkusz16","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}