{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Arkusz1","dane"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":60,"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":"Arkusz1","index":0,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,4,2,7]]}
[]
["Problem kolejkowania zadań",null,null,null,"harmonogram zadań",null,null,null,"dziś",null,"1. W Solverze wykonano obliczenia i ustalono"]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-06-24"},null,"minimalny czas opóźnień = 38 dni oraz max = 87."]
["zadanie","czas potrzebny na wykonanie zadania","Termin (liczba dni od dzisiaj)",null,"porządek wykonywania zadań","poczatek zadania","koniec zadania","termin oddania zadania","opóźnienie zadania",null,"2. Za pomocą sumulacji Monte Carlo utworzono wykres rozkładu"]
[1,9,32,null,4,{"$f":"I3","v":"2017-06-24"},{"$f":"F5+VLOOKUP(E5,$A$5:$C$10,2)-1","v":"2017-07-11"},{"$f":"$I$3+VLOOKUP(E5,$A$5:$C$10,3)","v":"2017-07-15"},{"$f":"IF(G5>H5,G5-H5,0)","v":0},null,"empirycznego liczby dni opóźnień."]
[2,7,29,null,3,{"$f":"G5+1","v":"2017-07-12"},"2017-07-20",{"$f":"$I$3+VLOOKUP(E6,$A$5:$C$10,3)","v":"2017-07-16"},{"$f":"IF(G6>H6,G6-H6,0)","v":4}]
[3,9,22,null,5,{"$f":"G6+1","v":"2017-07-21"},"2017-07-29","2017-07-31",0,null,"3. Zmień dane w tabeli zadań /B5:C10/ i oblicz za pomocą"]
[4,18,21,null,2,"2017-07-30","2017-08-05","2017-07-23",13,null,"Solvera nowe min. i max."]
[5,9,37,null,6,"2017-08-06","2017-08-11","2017-07-22",20]
[6,6,28,null,1,"2017-08-12","2017-08-20","2017-07-26",25,null,"4. Zmień w kodzie makra obszar tabeli, na podstawie"]
[null,null,null,null,null,null,null,"razem",{"$f":"SUM(I5:I10)","v":62},null,"której powstaje wykres."]
[]
[]
[null,null,"min",38,75,{"$f":"D14*E14","v":2850}]
[null,null,null,39,57,{"$f":"D15*E15","v":2223}]
[null,null,null,40,99,3960]
[null,null,null,41,null,0]
[null,null,null,42,22,924]
[null,null,null,43,97,4171]
[null,null,null,44,56,2464]
[null,null,null,45,81,3645]
[null,null,null,46,196,9016]
[null,null,null,47,224,10528]
[null,null,null,48,107,5136]
[null,null,null,49,110,5390]
[null,null,null,50,89,4450]
[null,null,null,51,163,8313]
[null,null,null,52,80,4160]
[null,null,null,53,238,12614]
[null,null,null,54,466,25164]
[null,null,null,55,299,16445]
[null,null,null,56,313,17528]
[null,null,null,57,214,12198]
[null,null,null,58,436,25288]
[null,null,null,59,288,16992]
[null,null,null,60,363,21780]
[null,null,null,61,513,31293]
[null,null,null,62,635,39370]
[null,null,null,63,258,16254]
[null,null,null,64,565,36160]
[null,null,null,65,320,20800]
[null,null,null,66,287,18942]
[null,null,null,67,435,29145]
[null,null,null,68,132,8976]
[null,null,null,69,511,35259]
[null,null,null,70,207,14490]
[null,null,null,71,287,20377]
[null,null,null,72,285,20520]
[null,null,null,73,115,8395]
[null,null,null,74,367,27158]
[null,null,null,75,119,8925]
[null,null,null,76,346,26296]
[null,null,null,77,159,12243]
[null,null,null,78,30,2340]
[null,null,null,79,100,7900]
[null,null,null,80,76,6080]
[null,null,null,81,45,3645]
[null,null,null,82,34,2788]
[null,null,null,83,27,2241]
[null,null,null,84,null,0]
[null,null,null,85,26,2210]
[null,null,null,86,23,1978]
[null,null,"max",87,25,2175]
[null,null,null,null,null,{"$f":"SUM(F14:F63)","v":621199}]
[null,null,null,null,"srednia",{"$f":"F64/10000","v":62.119900000000001}]

{"sheet":"dane","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["zadanie","czas potrzebny na wykonanie zadania","Termin (liczba dni od dzisiaj)"]
[1,9,32]
[2,7,29]
[3,9,22]
[4,18,21]
[5,9,37]
[6,6,28]