Monte Carlo Simulation of Sales Pipeline Projected Yield

function RunMonteCarloSim(total, runs) {
var sheet = SpreadsheetApp.getActiveSheet();
var row = 4;
for (var i = 0; i < runs; i++) {
var monteOutput = sheet.getRange(“L” + row);
var trialSum = sheet.getRange(total);
monteOutput.setValue(trialSum.getValue());
row = 1 + row;
}
}
RunMonteCarloSim(‘J24’,1000);

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Andrew Parker

Andrew Parker

“Seeing ourselves clearly is the project of a lifetime.” -The Nix