{"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":2,"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 PERT. 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 the PERT schedule, execute the macPERT macro."]
[null,"Invoke the {Data orTools} | Macro | macPERT | Run command"]
[null,"or (in this workbook) click this button:"]
[]
[]
[]
[]
[]
[]
[null,null,"Jerzy J Letkowski"]

{"sheet":"LPERT","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Task ID","Description","iPreds","a","m","b","avgDuration ","varDuration ","eStart","eFinish","lStart","lFinish","tSlack","fSlack","critTask ","critPath "]
["A","Excavating",null,5,7,12,{"$f":"ROUND((D2+4*E2+F2)/6,6)","v":7.5},{"$f":"ROUND(((F2-D2)/6)^2,6)","v":1.361111},0,{"$f":"G2+I2","v":7.5},{"$f":"L2-G2","v":1.0658141036401503E-14},{"$f":"MIN(K3,K4)","v":7.5000000000000107},{"$f":"K2-I2","v":1.0658141036401503E-14},{"$f":"MIN(I3,I4)-I2-G2","v":0},{"$f":"IF(ABS(M2)<=0.00001,\"Yes\",\"No\")","v":"Yes"},"Yes"]
["B","Pouring Foundation","A",2,3,5,{"$f":"ROUND((D3+4*E3+F3)/6,6)","v":3.1666669999999999},{"$f":"ROUND(((F3-D3)/6)^2,6)","v":0.25},{"$f":"MAX(J2)","v":7.5},{"$f":"G3+I3","v":10.666667},{"$f":"L3-G3","v":7.5000000000000107},{"$f":"MIN(K5,K9)","v":10.666667000000011},{"$f":"K3-I3","v":1.0658141036401503E-14},{"$f":"MIN(I5,I9)-I3-G3","v":0},{"$f":"IF(ABS(M3)<=0.00001,\"Yes\",\"No\")","v":"Yes"},"Yes"]
["C","Outside Plumbing","A",6,8,14,{"$f":"ROUND((D4+4*E4+F4)/6,6)","v":8.6666670000000003},{"$f":"ROUND(((F4-D4)/6)^2,6)","v":1.7777780000000001},{"$f":"MAX(J2)","v":7.5},{"$f":"G4+I4","v":16.166667},{"$f":"L4-G4","v":31.000000000000011},{"$f":"MIN(K10)","v":39.666667000000011},{"$f":"K4-I4","v":23.500000000000011},{"$f":"MIN(I10)-I4-G4","v":23.500000000000004},{"$f":"IF(ABS(M4)<=0.00001,\"Yes\",\"No\")","v":"No"},"No"]
["D","Framing","B",12,16,22,{"$f":"ROUND((D5+4*E5+F5)/6,6)","v":16.333333},{"$f":"ROUND(((F5-D5)/6)^2,6)","v":2.7777780000000001},{"$f":"MAX(J3)","v":10.666667},{"$f":"G5+I5","v":27},{"$f":"L5-G5","v":10.666667000000011},{"$f":"MIN(K6,K7,K8)","v":27.000000000000011},{"$f":"K5-I5","v":0},{"$f":"MIN(I6,I7,I8)-I5-G5","v":0},{"$f":"IF(ABS(M5)<=0.00001,\"Yes\",\"No\")","v":"Yes"},"Yes"]
["E","Inside Plumbing","D",10,12,18,{"$f":"ROUND((D6+4*E6+F6)/6,6)","v":12.666667},{"$f":"ROUND(((F6-D6)/6)^2,6)","v":1.7777780000000001},{"$f":"MAX(J5)","v":27},{"$f":"G6+I6","v":39.666667000000004},{"$f":"L6-G6","v":27.000000000000011},{"$f":"MIN(K10)","v":39.666667000000011},{"$f":"K6-I6","v":0},{"$f":"MIN(I10)-I6-G6","v":0},{"$f":"IF(ABS(M6)<=0.00001,\"Yes\",\"No\")","v":"Yes"},"Yes"]
["F","Wiring","D",9,13,20,{"$f":"ROUND((D7+4*E7+F7)/6,6)","v":13.5},{"$f":"ROUND(((F7-D7)/6)^2,6)","v":3.3611110000000002},{"$f":"MAX(J5)","v":27},{"$f":"G7+I7","v":40.5},{"$f":"L7-G7","v":28.500000000000014},{"$f":"MIN(K12)","v":42.000000000000014},{"$f":"K7-I7","v":1.5000000000000142},{"$f":"MIN(I12)-I7-G7","v":1.5000000000000071},{"$f":"IF(ABS(M7)<=0.00001,\"Yes\",\"No\")","v":"No"},"No"]
["G","Roofing","D",5,8,16,{"$f":"ROUND((D8+4*E8+F8)/6,6)","v":8.8333329999999997},{"$f":"ROUND(((F8-D8)/6)^2,6)","v":3.3611110000000002},{"$f":"MAX(J5)","v":27},{"$f":"G8+I8","v":35.833332999999996},{"$f":"L8-G8","v":28.000000000000011},{"$f":"MIN(K11,K14)","v":36.83333300000001},{"$f":"K8-I8","v":1.0000000000000107},{"$f":"MIN(I11,I14)-I8-G8","v":0},{"$f":"IF(ABS(M8)<=0.00001,\"Yes\",\"No\")","v":"No"},"No"]
["H","Brickwork","B",9,14,18,{"$f":"ROUND((D9+4*E9+F9)/6,6)","v":13.833333},{"$f":"ROUND(((F9-D9)/6)^2,6)","v":2.25},{"$f":"MAX(J3)","v":10.666667},{"$f":"G9+I9","v":24.5},{"$f":"L9-G9","v":23.000000000000011},{"$f":"MIN(K14)","v":36.83333300000001},{"$f":"K9-I9","v":12.33333300000001},{"$f":"MIN(I14)-I9-G9","v":11.333332999999996},{"$f":"IF(ABS(M9)<=0.00001,\"Yes\",\"No\")","v":"No"},"No"]
["I","Plumbing Inspection","C,E",1,2,5,{"$f":"ROUND((D10+4*E10+F10)/6,6)","v":2.3333330000000001},{"$f":"ROUND(((F10-D10)/6)^2,6)","v":0.44444400000000001},{"$f":"MAX(J4,J6)","v":39.666667000000004},{"$f":"G10+I10","v":42.000000000000007},{"$f":"L10-G10","v":39.666667000000011},{"$f":"MIN(K12)","v":42.000000000000014},{"$f":"K10-I10","v":0},{"$f":"MIN(I12)-I10-G10","v":0},{"$f":"IF(ABS(M10)<=0.00001,\"Yes\",\"No\")","v":"Yes"},"Yes"]
["J","Shingling","G",2,4,10,{"$f":"ROUND((D11+4*E11+F11)/6,6)","v":4.6666670000000003},{"$f":"ROUND(((F11-D11)/6)^2,6)","v":1.7777780000000001},{"$f":"MAX(J8)","v":35.833332999999996},{"$f":"G11+I11","v":40.5},{"$f":"L11-G11","v":37.33333300000001},{"$f":"MIN(K12)","v":42.000000000000014},{"$f":"K11-I11","v":1.5000000000000142},{"$f":"MIN(I12)-I11-G11","v":1.5000000000000107},{"$f":"IF(ABS(M11)<=0.00001,\"Yes\",\"No\")","v":"No"},"No"]
["K","Covering Walls","F,I,J",3,5,10,{"$f":"ROUND((D12+4*E12+F12)/6,6)","v":5.5},{"$f":"ROUND(((F12-D12)/6)^2,6)","v":1.361111},{"$f":"MAX(J7,J10,J11)","v":42.000000000000007},{"$f":"G12+I12","v":47.500000000000007},{"$f":"L12-G12","v":42.000000000000014},{"$f":"MIN(K13)","v":47.500000000000014},{"$f":"K12-I12","v":0},{"$f":"MIN(I13)-I12-G12","v":0},{"$f":"IF(ABS(M12)<=0.00001,\"Yes\",\"No\")","v":"Yes"},"Yes"]
["L","Interior Finishing","K",9,12,14,{"$f":"ROUND((D13+4*E13+F13)/6,6)","v":11.833333},{"$f":"ROUND(((F13-D13)/6)^2,6)","v":0.69444399999999995},{"$f":"MAX(J12)","v":47.500000000000007},{"$f":"G13+I13","v":59.33333300000001},{"$f":"L13-G13","v":47.500000000000014},{"$f":"J16","v":59.33333300000001},{"$f":"K13-I13","v":0},{"$f":"M13","v":0},{"$f":"IF(ABS(M13)<=0.00001,\"Yes\",\"No\")","v":"Yes"},"Yes"]
["M","Exterior Finishing","H,G",7,10,16,{"$f":"ROUND((D14+4*E14+F14)/6,6)","v":10.5},{"$f":"ROUND(((F14-D14)/6)^2,6)","v":2.25},{"$f":"MAX(J9,J8)","v":35.833332999999996},{"$f":"G14+I14","v":46.333332999999996},{"$f":"L14-G14","v":36.83333300000001},{"$f":"MIN(K15)","v":47.33333300000001},{"$f":"K14-I14","v":1.0000000000000142},{"$f":"MIN(I15)-I14-G14","v":0},{"$f":"IF(ABS(M14)<=0.00001,\"Yes\",\"No\")","v":"No"},"No"]
["N","Landscaping","M",8,11,20,{"$f":"ROUND((D15+4*E15+F15)/6,6)","v":12},{"$f":"ROUND(((F15-D15)/6)^2,6)","v":4},{"$f":"MAX(J14)","v":46.333332999999996},{"$f":"G15+I15","v":58.333332999999996},{"$f":"L15-G15","v":47.33333300000001},{"$f":"J16","v":59.33333300000001},{"$f":"K15-I15","v":1.0000000000000142},{"$f":"M15","v":1.0000000000000142},{"$f":"IF(ABS(M15)<=0.00001,\"Yes\",\"No\")","v":"No"},"No"]
[null,null,null,null,null,null,null,null,"E[PCT]",{"$f":"MAX(J2:J15)","v":59.33333300000001}]
[null,null,null,null,null,null,null,null,"var[PCT]",8.6666659999999993]