{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ReadMe","LPERT","ModulePERT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"ModulePERT","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":"ReadMe","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,2,40,7],[15,1,15,8]]}
["Generating the PERT Schedule"]
[]
["Step 1","On the LPERT sheet, define the PM Model Structure"]
[null,"and name it as PERTSIM. The structure is expected to contain:"]
[]
[null,null,"Column A:","Activity IDs (A,B,C,...,Z,AA,AB,AC,...,AZ,...)"]
[null,null,"Column B:","Activity description"]
[null,null,"Column C:","Immediate predecessors separated with a comma (if any)"]
[null,null,"   Note: If there is no predecessor, leave the cell empty."]
[null,null,"Column D:","Activity optimistic completion times (a)"]
[null,null,"Column E:","Activity most likely completion times (m)"]
[null,null,"Column F:","Activity pessimistic completion times (b)"]
[null,null,"Row 1:","A header, describing the columns (do not include it within"]
[null,null,null,"the PERT-named range)."]
[]
[null,"Here's an example of such a structure (with name PERT boxed):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 2","To generate a random PERT schedule, execute the macPERTSim macro."]
[null,"Invoke the {Data orTools} | Macro | macPERTSim | Run command"]
[null,"or (in this workbook) click this button:"]
[]
[]
[]
[]
[]
[]
[null,null,"Jerzy J Letkowski"]

{"sheet":"LPERT","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Task ID","Description","iPreds","a","m","b"]
["A","Excavating",null,5,7,12]
["B","Pouring Foundation","A",2,3,5]
["C","Outside Plumbing","A",6,8,14]
["D","Framing","B",12,16,22]
["E","Inside Plumbing","D",10,12,18]
["F","Wiring","D",9,13,20]
["G","Roofing","D",5,8,16]
["H","Brickwork","B",9,14,18]
["I","Plumbing Inspection","C,E",1,2,5]
["J","Shingling","G",2,4,10]
["K","Covering Walls","F,I,J",3,5,10]
["L","Interior Finishing","K",9,12,14]
["M","Exterior Finishing","H,G",7,10,16]
["N","Landscaping","M",8,11,20]