hiringData = (await FileAttachment("payroll.csv").csv()).map(autoTypeExcel)
mrrActual = (await FileAttachment("mrrActual@1.csv").csv()).map(autoTypeExcel)
domain = [new Date(Date.UTC(2021, 0, 1)), new Date(Date.UTC(2022, 0, 1))]
asOf = new Date(Date.UTC(2021, 4, 25))
import {viewof hiring, payroll, summary as hiringSummary}
with {domain, asOf, hiringData as data}
from "433c356a8f929477"
mrr = mrrTarget.diff.map(({date, value}, i) => ({date, target: value, actual: mrrActual[i]?.value}))
mrrStart = mrrActual[0].value
import {chart as mrrSpline, flow as mrrTarget}
with {domain as timeDomain, mrrStart as start}
from "7fc65adc09109fe5"
vc = [{date: new Date(cashDate), value: cash * 1000}]
totalActual = rollupByMonth([vc, payroll.diff, mrrActual])
.filter(({date}) => date <= asOf)
totalActualCum = cumsum(totalActual)
totalTarget = rollupByMonth([vc, payroll.diff, mrrTarget.diff])
totalTargetCum = cumsum(totalTarget)
totalTargetActuals = zip({target: totalTargetCum, actual: totalActualCum})
import {TargetsVsActuals} from "@observablehq/targets-vs-actuals"
import {Table} from "@observablehq/table-validator"
import {longMonth, dateFormat, autoTypeExcel, rollupByMonth, zip, cumsum, zero}
from "@observablehq/cash-flow"
import {toc} from "@observablehq/templates-table-of-instructions"
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.
