2f:T47f,md`### 2. Upload a CSV of salaries Use the File Attachment icon to replace \`hiring.csv\`.`30:T484,md`### 3. Upload a CSV of revenues Use the File Attachment icon to replace \`mrrActual@1.csv\`.`31:[{"id":"13da6ce89366d90aebc1d43a2a6ab58043b48d3093c74aa8a746e5fa179c4b5d414f35a7f16bf1a9a25b772ef2e3dc52c545e85f3109372920416ad9d356b3ca","href":"https://static.observableusercontent.com/files/13da6ce89366d90aebc1d43a2a6ab58043b48d3093c74aa8a746e5fa179c4b5d414f35a7f16bf1a9a25b772ef2e3dc52c545e85f3109372920416ad9d356b3ca","name":"payroll.csv","type":"text/csv","lastModified":1690624185231.667,"size":448},{"id":"21f6ce7ef6bd13d55dba9178755f64f081826d6afa3854ef6bba3848497933513748f5d6881f24cfb9751319e5f7dc9b20a29c6f2bb3bd605409b742fc9ee49d","href":"https://static.observableusercontent.com/files/21f6ce7ef6bd13d55dba9178755f64f081826d6afa3854ef6bba3848497933513748f5d6881f24cfb9751319e5f7dc9b20a29c6f2bb3bd605409b742fc9ee49d","name":"mrrActual@1.csv","type":"text/csv","lastModified":1690624185231.667,"size":95}] 2d:{"title":"Startup Operating Model","cells":[{"id":0,"value":"md`# Startup Operating Model\n\n${toc(instructions)}\n\nA simple operating model for a small company where the only significant expense is payroll, the key metric is growth of recurring revenue, and most cash is from venture capital. It’s optimized for quickly exploring different hypotheses about hiring and growth. This demonstrates how to combine pieces of several notebooks, including [Hiring Timeline](https://observablehq.com/@observablehq/hiring-timeline) and [Targets vs. Actuals](https://observablehq.com/@observablehq/targets-vs-actuals).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":165,"value":"md`### Payroll\n\n${hiringSummary}\n\nClick and drag to move the heads representing hiring dates. Drag down to below the axis to remove people, or click below the axis to add people.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"viewof hiring","pinned":false,"hidden":false,"mode":"ojs"},{"id":933,"value":"Plot.plot({\n height: 200,\n x: {tickFormat: dateFormat, label: null},\n y: {tickFormat: d3.format(\"$\"), label: \"Payroll / mo. (k)\", transform: d => d / 1000, reverse: true},\n color: {\n range: [\"#b44646\", \"steelblue\"],\n domain: [-1e-6, 1e-6],\n clamp: true\n },\n marks: [\n Plot.barY(payroll.diff.filter(({date}) => date <= asOf), {x: \"date\", y: \"value\", fill: \"value\"}),\n Plot.barY(payroll.diff.filter(({date}) => date > asOf), {x: \"date\", y: \"value\", stroke: \"black\"}),\n Plot.ruleY([0])\n ],\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":565,"value":"{\n const fDate = d3.utcFormat(\"%B %Y\");\n const fDollar = d3.format(\"$.3s\");\n const fPct = d3.format(\".0%\");\n \n const d0 = mrr[0].date\n const d1 = d3.greatest(mrr, d => d.actual && d.date).date\n const v0 = mrr[0].actual\n const v1 = d3.greatest(mrr, d => d.actual && d.date).actual\n \n const p = (v1 / v0) - 1\n \n return md`### Revenue\n\nSo far, actual monthly recurring revenue has gone ${p > 0 ? \"up\" : \"down\"} ${fPct(Math.abs(p))} from ${fDollar(v0)} in ${fDate(d0)} to ${fDollar(v1)} in ${fDate(d1)}.\n\nClick and drag the dots to change the shape of projected revenue. See how it compares to the actual figures from the attached CSV in the chart below.`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"mrrSpline","pinned":false,"hidden":false,"mode":"ojs"},{"id":32,"value":"TargetsVsActuals(mrr, {x: \"date\", target: \"target\", actual: \"actual\", y: { tickFormat: \"s\", label: \"Monthly recurring revenue vs. projected ($)\" }})","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"md`### Runway\nPayroll and revenue, combined with cash raised from venture capital, can give you a very rough sense of a “runway” until the company is out of money.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":278,"value":"viewof cash = Inputs.range([0, 1e3], {label: \"Cash ($k)\", step: 1, value: 160})","pinned":false,"hidden":false,"mode":"ojs"},{"id":679,"value":"viewof cashDate = Inputs.text({label: \"On\", type: \"date\", value: \"2021-01-01\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":866,"value":"zero(totalActualCum) ? md`The company ran out of money in ${longMonth(zero(totalActualCum))}.` : zero(totalTargetCum) ? md`Under these projections, the company will run out of money in ${longMonth(zero(totalTargetCum))}.` : md`Under these projections, the company will not run out of money within the time range.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":785,"value":"TargetsVsActuals(totalTargetActuals, {x: \"date\", target: \"target\", actual: \"actual\", y: { tickFormat: \"s\", label: \"Cash ($)\" }})","pinned":false,"hidden":false,"mode":"ojs"},{"id":349,"value":"instructions = md`---\n## How to show your current payroll and revenues\n\n### 1. Fork this template\nYour changes will not be saved until you fork.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1001,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"hiringData = (await FileAttachment(\"payroll.csv\").csv()).map(autoTypeExcel)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1101,"value":"md`The template expects four columns (though it’s fine if more are present): a unique _id_, a _date_ representing the employee’s start date (formatted like YYYY-MM-DD or M/D/YY), an annual _salary_ (formatted as a number without commas or dollar sign), and an optional _name_.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1006,"value":"Table(hiringData, {columnRules: {\n \"id\": d => Boolean(d) || \"each row needs a unique id\",\n \"date\": d => d instanceof Date || \"must be a date like YYYY-MM-DD or M/D/YY\",\n \"salary\": d => typeof d === \"number\" || d === null || \"must be a number without dollar signs or commas\",\n}})","pinned":false,"hidden":false,"mode":"ojs"},{"id":996,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"mrrActual = (await FileAttachment(\"mrrActual@1.csv\").csv()).map(autoTypeExcel)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1076,"value":"md`The chart expects two columns (though it’s fine if more are present): a _date_, formatted like YYYY-MM-DD or M/D/YY, and a _value_ (representing revenue), formatted without commas or other symbols (like $ or %), representing revenue for that month.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1012,"value":"Table(mrrActual, {columnRules: {\n \"date\": d => d instanceof Date || \"must be a date like YYYY-MM-DD or M/D/YY\",\n \"value\": d => typeof d === \"number\" || d === null || \"must be a number without dollar signs or commas\"\n}})","pinned":false,"hidden":false,"mode":"ojs"},{"id":988,"value":"md`### 4. Configure the date range`","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"domain = [new Date(Date.UTC(2021, 0, 1)), new Date(Date.UTC(2022, 0, 1))]","pinned":true,"hidden":false,"mode":"ojs"},{"id":796,"value":"asOf = new Date(Date.UTC(2021, 4, 25))","pinned":true,"hidden":false,"mode":"ojs"},{"id":71,"value":"md`---\n## Appendix\nThis section shows the code that pieces the data and charts together. You shouldn’t have to change it to use the template.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":155,"value":"md`Payroll is based on the [Hiring Timeline](https://next.observablehq.com/d/433c356a8f929477) component.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"import {viewof hiring, payroll, summary as hiringSummary} \nwith {domain, asOf, hiringData as data} \nfrom \"433c356a8f929477\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":146,"value":"md`Revenue is based on the [Targets vs. Actuals](https://next.observablehq.com/d/7dccacfec0508ffc) and [Draggable Cash Flow Curve\n](https://next.observablehq.com/d/7fc65adc09109fe5) components.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":211,"value":"mrr = mrrTarget.diff.map(({date, value}, i) => ({date, target: value, actual: mrrActual[i]?.value}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":228,"value":"mrrStart = mrrActual[0].value","pinned":true,"hidden":false,"mode":"ojs"},{"id":27,"value":"import {chart as mrrSpline, flow as mrrTarget} \nwith {domain as timeDomain, mrrStart as start} \nfrom \"7fc65adc09109fe5\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":361,"value":"md`Runway combines the Payroll and Revenue with one VC cash infusion.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":692,"value":"vc = [{date: new Date(cashDate), value: cash * 1000}]","pinned":true,"hidden":false,"mode":"ojs"},{"id":732,"value":"totalActual = rollupByMonth([vc, payroll.diff, mrrActual])\n .filter(({date}) => date <= asOf)","pinned":true,"hidden":false,"mode":"ojs"},{"id":746,"value":"totalActualCum = cumsum(totalActual)","pinned":true,"hidden":false,"mode":"ojs"},{"id":751,"value":"totalTarget = rollupByMonth([vc, payroll.diff, mrrTarget.diff])","pinned":true,"hidden":false,"mode":"ojs"},{"id":752,"value":"totalTargetCum = cumsum(totalTarget)","pinned":true,"hidden":false,"mode":"ojs"},{"id":764,"value":"totalTargetActuals = zip({target: totalTargetCum, actual: totalActualCum})","pinned":true,"hidden":false,"mode":"ojs"},{"id":25,"value":"import {TargetsVsActuals} from \"@observablehq/targets-vs-actuals\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1008,"value":"import {Table} from \"@observablehq/table-validator\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":953,"value":"import {longMonth, dateFormat, autoTypeExcel, rollupByMonth, zip, cumsum, zero} \nfrom \"@observablehq/cash-flow\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1089,"value":"import {toc} from \"@observablehq/templates-table-of-instructions\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}