{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ReadMe","LCPM","ModuleCPM"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"ModuleCPM","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":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,2,39,7],[11,1,11,7],[28,1,28,8],[29,1,29,8]]}
[]
[1,"On the LCPM sheet, define the PM Model Structure"]
[null,"and name it as CPM. The structure is expected to contain:"]
[]
[null,null,"Column 1:","Activity IDs (A,B,C,...,Z,AA,AB,AC,...,AZ,...)"]
[null,null,"Column 2:","Activity description"]
[null,null,"Column 3:","Immediate predecessors separated with a comma (if any)"]
[null,null,"Column 4:","Activity completion times"]
[null,null,"Row 1:","A header, describing the columns (do not include it within"]
[null,null,null,"the CPM-named range)."]
[]
[null,"Here's an example of such a structure:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: If there is a CPM structure on sheet LCPM, first delete it and then"]
[null,"define your own one (do not forget to rename the new structure)."]
[]
[2,"To generate the CPM schedule, execute the macCPM macro."]
[null,"Invoke the {Data or Tools} | Macro | macCPM | Run command, or"]
[null,"(in this workbook) click this button:"]
[]
[]
[]
[]
[]
[null,null,"Jerzy J Letkowski"]

{"sheet":"LCPM","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Task ID","Description","iPreds","Duration","eStart","eFinish","lStart","lFinish","tSlack","fSlack","Critical"]
["A","Excavating",null,5,0,{"$f":"E2+D2","v":5},{"$f":"H2-D2","v":0},{"$f":"MIN(G3,G4)","v":5},{"$f":"G2-E2","v":0},{"$f":"MIN(E3,E4)-E2-D2","v":0},{"$f":"IF(ABS(I2)<=0.00001,\"Yes\",\"No\")","v":"Yes"}]
["B","Pouring Foundation","A",2,{"$f":"MAX(F2)","v":5},{"$f":"E3+D3","v":7},{"$f":"H3-D3","v":5},{"$f":"MIN(G5,G9)","v":7},{"$f":"G3-E3","v":0},{"$f":"MIN(E5,E9)-E3-D3","v":0},{"$f":"IF(ABS(I3)<=0.00001,\"Yes\",\"No\")","v":"Yes"}]
["C","Outside Plumbing","A",6,{"$f":"MAX(F2)","v":5},{"$f":"E4+D4","v":11},{"$f":"H4-D4","v":23},{"$f":"MIN(G10)","v":29},{"$f":"G4-E4","v":18},{"$f":"MIN(E10)-E4-D4","v":18},{"$f":"IF(ABS(I4)<=0.00001,\"Yes\",\"No\")","v":"No"}]
["D","Framing","B",12,{"$f":"MAX(F3)","v":7},{"$f":"E5+D5","v":19},{"$f":"H5-D5","v":7},{"$f":"MIN(G6,G7,G8)","v":19},{"$f":"G5-E5","v":0},{"$f":"MIN(E6,E7,E8)-E5-D5","v":0},{"$f":"IF(ABS(I5)<=0.00001,\"Yes\",\"No\")","v":"Yes"}]
["E","Inside Plumbing","D",10,{"$f":"MAX(F5)","v":19},{"$f":"E6+D6","v":29},{"$f":"H6-D6","v":19},{"$f":"MIN(G10)","v":29},{"$f":"G6-E6","v":0},{"$f":"MIN(E10)-E6-D6","v":0},{"$f":"IF(ABS(I6)<=0.00001,\"Yes\",\"No\")","v":"Yes"}]
["F","Wiring","D",9,{"$f":"MAX(F5)","v":19},{"$f":"E7+D7","v":28},{"$f":"H7-D7","v":21},{"$f":"MIN(G12)","v":30},{"$f":"G7-E7","v":2},{"$f":"MIN(E12)-E7-D7","v":2},{"$f":"IF(ABS(I7)<=0.00001,\"Yes\",\"No\")","v":"No"}]
["G","Roofing","D",5,{"$f":"MAX(F5)","v":19},{"$f":"E8+D8","v":24},{"$f":"H8-D8","v":22},{"$f":"MIN(G11,G14)","v":27},{"$f":"G8-E8","v":3},{"$f":"MIN(E11,E14)-E8-D8","v":0},{"$f":"IF(ABS(I8)<=0.00001,\"Yes\",\"No\")","v":"No"}]
["H","Brickwork","B",9,{"$f":"MAX(F3)","v":7},{"$f":"E9+D9","v":16},{"$f":"H9-D9","v":18},{"$f":"MIN(G14)","v":27},{"$f":"G9-E9","v":11},{"$f":"MIN(E14)-E9-D9","v":8},{"$f":"IF(ABS(I9)<=0.00001,\"Yes\",\"No\")","v":"No"}]
["I","Plumbing Inspection","C,E",1,{"$f":"MAX(F4,F6)","v":29},{"$f":"E10+D10","v":30},{"$f":"H10-D10","v":29},{"$f":"MIN(G12)","v":30},{"$f":"G10-E10","v":0},{"$f":"MIN(E12)-E10-D10","v":0},{"$f":"IF(ABS(I10)<=0.00001,\"Yes\",\"No\")","v":"Yes"}]
["J","Shingling","G",2,{"$f":"MAX(F8)","v":24},{"$f":"E11+D11","v":26},{"$f":"H11-D11","v":28},{"$f":"MIN(G12)","v":30},{"$f":"G11-E11","v":4},{"$f":"MIN(E12)-E11-D11","v":4},{"$f":"IF(ABS(I11)<=0.00001,\"Yes\",\"No\")","v":"No"}]
["K","Covering Walls","F,I,J",3,{"$f":"MAX(F7,F10,F11)","v":30},{"$f":"E12+D12","v":33},{"$f":"H12-D12","v":30},{"$f":"MIN(G13)","v":33},{"$f":"G12-E12","v":0},{"$f":"MIN(E13)-E12-D12","v":0},{"$f":"IF(ABS(I12)<=0.00001,\"Yes\",\"No\")","v":"Yes"}]
["L","Interior Finishing","K",9,{"$f":"MAX(F12)","v":33},{"$f":"E13+D13","v":42},{"$f":"H13-D13","v":33},{"$f":"F16","v":42},{"$f":"G13-E13","v":0},{"$f":"I13","v":0},{"$f":"IF(ABS(I13)<=0.00001,\"Yes\",\"No\")","v":"Yes"}]
["M","Exterior Finishing","H,G",7,{"$f":"MAX(F9,F8)","v":24},{"$f":"E14+D14","v":31},{"$f":"H14-D14","v":27},{"$f":"MIN(G15)","v":34},{"$f":"G14-E14","v":3},{"$f":"MIN(E15)-E14-D14","v":0},{"$f":"IF(ABS(I14)<=0.00001,\"Yes\",\"No\")","v":"No"}]
["N","Landscaping","M",8,{"$f":"MAX(F14)","v":31},{"$f":"E15+D15","v":39},{"$f":"H15-D15","v":34},{"$f":"F16","v":42},{"$f":"G15-E15","v":3},{"$f":"I15","v":3},{"$f":"IF(ABS(I15)<=0.00001,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,"PCT",{"$f":"MAX(F2:F15)","v":42}]