Monte Carlo analysis is an enhancement to CPM and PERT methods built into MS Project. It enables project manager to run statistical simulation of possible project outcomes based on optimistic, pessimistic and most likely estimates.
When I am running the macro, I keep getting told that "The value is not valid.": Tasks(t).Number1 = SpearmanRankCorrelation(ProjectDuration, TmpVec, NN) Please help. Would be great if I could get it working.