Unlisted
Edited
Jul 22, 2023
Insert cell
Insert cell
scenarios = {
const scenarios = [
{
name: "Vanilla",
budget: 118216,
grps: 58.44 + 86.34,
augShare: 0.4036
},
{
name: "Chocolate",
budget: 396222,
grps: 1560.6,
augShare: 0.4529
},
{
name: "Mixed",
budget: 514438,
grps: 1696.66,
augShare: 0.45
}
];

scenarios.push({
name: "Mixed calc",
budget: scenarios[0].budget + scenarios[1].budget,
grps: scenarios[0].grps + scenarios[1].grps,
augShare:
scenarios[0].augShare * augDaysShare +
scenarios[1].augShare * sepDaysShare
});

return scenarios;
}
Insert cell
Insert cell
augUnitCost = 0.96
Insert cell
sepUnitCost = 1.38
Insert cell
Insert cell
results = scenarios.map(({ name, budget, grps, augShare }) => {
const augGrps = augShare * grps
const sepGrps = grps - augGrps
const augCost = augUnitCost * augGrps
const sepCost = sepUnitCost * sepGrps
const totalCost = augCost + sepCost

return {
name,
budget,
grps,
augShare,

augGrps,
sepGrps,
// averageBudget: budget / mon,

augCost,
sepCost,
totalCost
// averageCost: totalCost / 2
};
})
Insert cell
Insert cell
augDays = 14
Insert cell
sepDays = 30
Insert cell
augDaysShare = augDays / (augDays + sepDays)
Insert cell
sepDaysShare = 1 - augDaysShare
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more