{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["RunSimul","MCS","SSP","PERT","HelpFunc","PDFs","eMax","PDFPlot"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":17,"comments":1,"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":"RunSimul","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["pRisk"]
[]
["Parameter","Value"]
["Number of simulations",3000]
["Cell to analyse",{"$f":"RndNormal(RAND(),0,1)","v":-0.25321760579334562}]
["Plot","pdf"]
["Result: Mean",-1.2166940419362315E-3]
["Result: SD",1.0036943728516836]
["Result: Min",-3.4332032203674316]
["Result: Max",4.107541561126709]

{"sheet":"MCS","index":1,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Activity","L","M","H","Start","Duration","End",null,"Formulas, Start"]
[null,null,null,null,null,null,null,null,{"$f":"showformula(E2)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"showformula(E3)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"showformula(E67)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"showformula(E68)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"showformula(E69)","v":""}]

{"sheet":"SSP","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Activity","L","M","H","mi","si2","EiF","ViF",null,"Formula ViF"]
[null,null,null,null,{"$f":"(B2+4*C2+D2)/6","v":0},{"$f":"((E2-B2)*(D2-E2)/7)","v":0},null,null,null,{"$f":"showformula(H2)","v":""}]
[null,null,null,null,0,0,null,null,null,{"$f":"showformula(H3)","v":""}]
[null,null,null,null,0,0,null,null,null,""]
[null,null,null,null,0,0,null,null,null,""]
[null,null,null,null,0,0,null,null,null,""]
[null,null,null,null,0,0,null,null,null,""]
[null,null,null,null,{"$f":"(B8+4*C8+D8)/6","v":0},{"$f":"((E8-B8)*(D8-E8)/7)","v":0},null,null,null,""]
[null,null,null,null,{"$f":"(B9+4*C9+D9)/6","v":0},{"$f":"((E9-B9)*(D9-E9)/7)","v":0},null,null,null,""]
[null,null,null,null,{"$f":"(B10+4*C10+D10)/6","v":0},{"$f":"((E10-B10)*(D10-E10)/7)","v":0},null,null,null,""]
[null,null,null,null,{"$f":"(B11+4*C11+D11)/6","v":0},{"$f":"((E11-B11)*(D11-E11)/7)","v":0},null,null,null,""]
[]
[null,null,null,null,null,null,"E(Final)=",{"$f":"G11","v":0}]
[null,null,null,null,null,null,"SD(Final)=",{"$f":"SQRT(H11)","v":0}]
[]
["Specification for Succesive Schedue Planning"]

{"sheet":"PERT","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Activity","L","M","H","mi","si2","In crit. Path","E","V"]
[null,null,null,null,{"$f":"(B2+4*C2+D2)/6","v":0},{"$f":"((E2-B2)*(D2-E2)/7)","v":0},null,{"$f":"E2*G2","v":0},{"$f":"F2*G2","v":0}]
[null,null,null,null,{"$f":"(B3+4*C3+D3)/6","v":0},{"$f":"((E3-B3)*(D3-E3)/7)","v":0},null,0,{"$f":"F3*G3","v":0}]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,null,0,0]
[]
[]
[]
[null,null,null,null,null,null,"Sum",{"$f":"SUM(H2:H13)","v":0},{"$f":"SUM(I2:I13)","v":0},{"$f":"SQRT(I14)","v":0}]

{"sheet":"HelpFunc","index":4,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"cdfnormal(6,5,3)","v":0.6305585503578186}]

{"sheet":"PDFs","index":5,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["mu",180]
["sigma",3]
[]
[]
["x","PDFNormal","normdist"]
[170,{"$f":"pdfnormal(A6,mu,sigma)","v":5.1409301337065633E-4},{"$f":"NORMDIST(A6,mu,sigma,TRUE)","v":4.2906033319683703E-4}]
[{"$f":"A6+1","v":171},{"$f":"pdfnormal(A7,mu,sigma)","v":1.4772828459534576E-3},{"$f":"NORMDIST(A7,mu,sigma,TRUE)","v":1.3498980316300933E-3}]
[{"$f":"A7+1","v":172},{"$f":"pdfnormal(A8,mu,sigma)","v":3.7986621158640839E-3},{"$f":"NORMDIST(A8,mu,sigma,TRUE)","v":3.8303805675897356E-3}]
[173,{"$f":"pdfnormal(A9,mu,sigma)","v":8.7406299462511813E-3},{"$f":"NORMDIST(A9,mu,sigma,TRUE)","v":9.8153286286453353E-3}]
[174,{"$f":"pdfnormal(A10,mu,sigma)","v":1.7996989349078837E-2},{"$f":"NORMDIST(A10,mu,sigma,TRUE)","v":2.2750131948179191E-2}]
[175,{"$f":"pdfnormal(A11,mu,sigma)","v":3.3159047206399464E-2},{"$f":"NORMDIST(A11,mu,sigma,TRUE)","v":4.7790352272814703E-2}]
[176,{"$f":"pdfnormal(A12,mu,sigma)","v":5.4670026445340456E-2},{"$f":"NORMDIST(A12,mu,sigma,TRUE)","v":9.1211219725867876E-2}]
[177,{"$f":"pdfnormal(A13,mu,sigma)","v":8.0656910464757189E-2},{"$f":"NORMDIST(A13,mu,sigma,TRUE)","v":0.15865525393145699}]
[178,{"$f":"pdfnormal(A14,mu,sigma)","v":0.10648267153294896},{"$f":"NORMDIST(A14,mu,sigma,TRUE)","v":0.25249253754692291}]
[179,{"$f":"pdfnormal(A15,mu,sigma)","v":0.12579441280520154},{"$f":"NORMDIST(A15,mu,sigma,TRUE)","v":0.36944134018176361}]
[180,{"$f":"pdfnormal(A16,mu,sigma)","v":0.13298076391220093},{"$f":"NORMDIST(A16,mu,sigma,TRUE)","v":0.5}]
[181,{"$f":"pdfnormal(A17,mu,sigma)","v":0.12579441280520154},{"$f":"NORMDIST(A17,mu,sigma,TRUE)","v":0.63055865981823644}]
[182,{"$f":"pdfnormal(A18,mu,sigma)","v":0.10648267153294896},{"$f":"NORMDIST(A18,mu,sigma,TRUE)","v":0.74750746245307709}]
[183,{"$f":"pdfnormal(A19,mu,sigma)","v":8.0656910464757189E-2},{"$f":"NORMDIST(A19,mu,sigma,TRUE)","v":0.84134474606854304}]
[184,{"$f":"pdfnormal(A20,mu,sigma)","v":5.4670026445340456E-2},{"$f":"NORMDIST(A20,mu,sigma,TRUE)","v":0.90878878027413212}]
[185,{"$f":"pdfnormal(A21,mu,sigma)","v":3.3159047206399464E-2},{"$f":"NORMDIST(A21,mu,sigma,TRUE)","v":0.9522096477271853}]
[186,{"$f":"pdfnormal(A22,mu,sigma)","v":1.7996989349078837E-2},{"$f":"NORMDIST(A22,mu,sigma,TRUE)","v":0.97724986805182079}]
[187,{"$f":"pdfnormal(A23,mu,sigma)","v":8.7406299462511813E-3},{"$f":"NORMDIST(A23,mu,sigma,TRUE)","v":0.99018467137135469}]
[188,{"$f":"pdfnormal(A24,mu,sigma)","v":3.7986621158640839E-3},{"$f":"NORMDIST(A24,mu,sigma,TRUE)","v":0.99616961943241022}]
[189,{"$f":"pdfnormal(A25,mu,sigma)","v":1.4772828459534576E-3},{"$f":"NORMDIST(A25,mu,sigma,TRUE)","v":0.9986501019683699}]
[190,{"$f":"pdfnormal(A26,mu,sigma)","v":5.1409301337065633E-4},{"$f":"NORMDIST(A26,mu,sigma,TRUE)","v":0.99957093966680322}]
[]
[]
[]
["L",2]
["M",3]
["H",4]
[null,"PERT","Triangular"]
[{"$f":"L","v":2},{"$f":"pdfpert(A34,L,M,H)","v":0},{"$f":"pdftriangular(A34,L,M,H)","v":0}]
[{"$f":"A34+(H-L)/10","v":2.2000000000000002},{"$f":"pdfpert(A35,L,M,H)","v":0.12150005874038484},{"$f":"pdftriangular(A35,L,M,H)","v":0.20000004768371582}]
[{"$f":"A35+(H-L)/10","v":2.4000000000000004},{"$f":"pdfpert(A36,L,M,H)","v":0.38400016021729605},{"$f":"pdftriangular(A36,L,M,H)","v":0.40000009536743164}]
[{"$f":"A36+(H-L)/10","v":2.6000000000000005},{"$f":"pdfpert(A37,L,M,H)","v":0.66149991926549501},{"$f":"pdftriangular(A37,L,M,H)","v":0.59999990463256836}]
[{"$f":"A37+(H-L)/10","v":2.8000000000000007},{"$f":"pdfpert(A38,L,M,H)","v":0.86400001716613495},{"$f":"pdftriangular(A38,L,M,H)","v":0.79999995231628418}]
[{"$f":"A38+(H-L)/10","v":3.0000000000000009},{"$f":"pdfpert(A39,L,M,H)","v":0.93750005587935781},{"$f":"pdftriangular(A39,L,M,H)","v":1}]
[{"$f":"A39+(H-L)/10","v":3.2000000000000011},{"$f":"pdfpert(A40,L,M,H)","v":0.86400001716613495},{"$f":"pdftriangular(A40,L,M,H)","v":0.79999995231628418}]
[{"$f":"A40+(H-L)/10","v":3.4000000000000012},{"$f":"pdfpert(A41,L,M,H)","v":0.66149991926549501},{"$f":"pdftriangular(A41,L,M,H)","v":0.59999990463256836}]
[{"$f":"A41+(H-L)/10","v":3.6000000000000014},{"$f":"pdfpert(A42,L,M,H)","v":0.38400016021729605},{"$f":"pdftriangular(A42,L,M,H)","v":0.40000009536743164}]
[{"$f":"A42+(H-L)/10","v":3.8000000000000016},{"$f":"pdfpert(A43,L,M,H)","v":0.12150005874038484},{"$f":"pdftriangular(A43,L,M,H)","v":0.20000004768371582}]
[{"$f":"A43+(H-L)/10","v":4.0000000000000018},{"$f":"pdfpert(A44,L,M,H)","v":0},{"$f":"pdftriangular(A44,L,M,H)","v":0}]

{"sheet":"eMax","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["mu1",10]
["mu2",11]
["sigma1",2]
["sigma2",2]
[]
["eMax",{"$f":"emax(mu1_,sigma1^2,mu2_,sigma2^2)","v":11.69817066192627},{"$f":"_xlfn.FORMULATEXT(B6)","v":"=emax(mu1_,sigma1^2,mu2_,sigma2^2)"}]
["varMax",{"$f":"varmax(mu1_,sigma1^2,mu2_,sigma2^2)","v":2.8143420219421391},{"$f":"_xlfn.FORMULATEXT(B7)","v":"=varmax(mu1_,sigma1^2,mu2_,sigma2^2)"}]
["SDMax",{"$f":"SQRT(B7)","v":1.6776000780704974},"=SQRT(B7)"]
["eMin",{"$f":"emin(mu1_,sigma1^2,mu2_,sigma2^2)","v":9.3018293380737305},{"$f":"_xlfn.FORMULATEXT(B9)","v":"=emin(mu1_,sigma1^2,mu2_,sigma2^2)"}]

{"sheet":"PDFPlot","index":7,"n_rows":104,"n_cols":2,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["x","Probability density function"]
[-3.7328755855560303,0]
[-3.7328755855560303,0]
[-3.6687471866607666,0]
[-3.6046187877655029,0]
[-3.5404906272888184,0]
[-3.4763622283935547,0]
[-3.412233829498291,3.3333332976326346E-4]
[-3.3481054306030273,0]
[-3.2839772701263428,0]
[-3.2198488712310791,3.3333332976326346E-4]
[-3.1557204723358154,0]
[-3.0915920734405518,6.6666665952652693E-4]
[-3.0274636745452881,3.3333332976326346E-4]
[-2.9633355140686035,9.9999993108212948E-4]
[-2.8992071151733398,3.3333332976326346E-4]
[-2.8350787162780762,3.3333332976326346E-4]
[-2.7709503173828125,6.6666665952652693E-4]
[-2.7068221569061279,9.9999993108212948E-4]
[-2.6426937580108643,2.0000000949949026E-3]
[-2.5785653591156006,3.3333332976326346E-4]
[-2.5144369602203369,2.0000000949949026E-3]
[-2.4503087997436523,6.6666665952652693E-4]
[-2.3861804008483887,1.3333333190530539E-3]
[-2.322052001953125,2.0000000949949026E-3]
[-2.2579236030578613,1.3333333190530539E-3]
[-2.1937952041625977,3.0000002589076757E-3]
[-2.1296670436859131,3.0000002589076757E-3]
[-2.0655386447906494,1.6666667070239782E-3]
[-2.0014102458953857,1.6666667070239782E-3]
[-1.9372819662094116,4.0000001899898052E-3]
[-1.8731535673141479,2.333333482965827E-3]
[-1.8090252876281738,3.3333336468786001E-3]
[-1.7448968887329102,6.3333339057862759E-3]
[-1.6807684898376465,6.6666672937572002E-3]
[-1.6166402101516724,8.6666671559214592E-3]
[-1.5525118112564087,9.6666673198342323E-3]
[-1.4883835315704346,9.6666673198342323E-3]
[-1.4242551326751709,8.0000003799796104E-3]
[-1.3601268529891968,1.100000087171793E-2]
[-1.2959984540939331,1.0000000707805157E-2]
[-1.231870174407959,1.2666667811572552E-2]
[-1.1677417755126953,1.5333334915339947E-2]
[-1.1036133766174316,1.3000001199543476E-2]
[-1.0394850969314575,1.1666667647659779E-2]
[-0.97535675764083862,1.5333334915339947E-2]
[-0.91122841835021973,1.7000000923871994E-2]
[-0.84710001945495605,1.33333345875144E-2]
[-0.78297168016433716,1.8666667863726616E-2]
[-0.71884334087371826,2.1333334967494011E-2]
[-0.65471500158309937,1.900000125169754E-2]
[-0.59058666229248047,2.5000002235174179E-2]
[-0.52645832300186157,2.6333335787057877E-2]
[-0.46232998371124268,2.3000001907348633E-2]
[-0.39820164442062378,2.3666668683290482E-2]
[-0.3340732753276825,2.6000002399086952E-2]
[-0.2699449360370636,1.900000125169754E-2]
[-0.2058165967464447,2.6000002399086952E-2]
[-0.14168825745582581,2.733333595097065E-2]
[-7.7559903264045715E-2,2.7000002562999725E-2]
[-1.3431561179459095E-2,2.5333335623145103E-2]
[5.0696782767772675E-2,2.3666668683290482E-2]
[0.11482512950897217,2.9000002890825272E-2]
[0.17895346879959106,2.4000002071261406E-2]
[0.24308182299137115,2.4000002071261406E-2]
[0.30721017718315125,2.2666668519377708E-2]
[0.37133851647377014,2.1000001579523087E-2]
[0.43546685576438904,2.3666668683290482E-2]
[0.49959519505500793,2.5333335623145103E-2]
[0.56372356414794922,2.2666668519377708E-2]
[0.62785190343856812,1.9666668027639389E-2]
[0.69198024272918701,1.8000001087784767E-2]
[0.75610858201980591,1.8666667863726616E-2]
[0.8202369213104248,2.200000174343586E-2]
[0.8843652606010437,1.8333334475755692E-2]
[0.9484935998916626,2.0000001415610313E-2]
[1.0126219987869263,1.4000001363456249E-2]
[1.0767502784729004,1.3666667975485325E-2]
[1.1408786773681641,1.3666667975485325E-2]
[1.2050069570541382,9.6666673198342323E-3]
[1.2691353559494019,1.0333334095776081E-2]
[1.333263635635376,1.100000087171793E-2]
[1.3973920345306396,1.2666667811572552E-2]
[1.4615204334259033,7.0000006817281246E-3]
[1.5256487131118774,5.6666671298444271E-3]
[1.5897771120071411,5.6666671298444271E-3]
[1.6539053916931152,6.0000005178153515E-3]
[1.7180337905883789,5.6666671298444271E-3]
[1.782162070274353,5.3333337418735027E-3]
[1.8462904691696167,5.3333337418735027E-3]
[1.9104187488555908,5.6666671298444271E-3]
[1.9745471477508545,3.6666670348495245E-3]
[2.0386755466461182,2.0000000949949026E-3]
[2.1028039455413818,2.333333482965827E-3]
[2.1669321060180664,2.6666668709367514E-3]
[2.2310605049133301,3.3333336468786001E-3]
[2.2951889038085938,3.0000002589076757E-3]
[2.3593173027038574,1.3333333190530539E-3]
[2.423445463180542,1.3333333190530539E-3]
[2.4875738620758057,3.3333332976326346E-4]
[2.5517022609710693,6.6666665952652693E-4]
[2.615830659866333,9.9999993108212948E-4]
[2.6799588203430176,6.6666665952652693E-4]
[3.9625258445739746,6.6666665952652693E-4]