31:T849,{ const gonnaMakeIt = Math.floor(exponentialDecay) <= step3Target && Math.floor(exponentialDecayUnknown) <= step3UnknownTarget; const date = `2020-${latestdata[0].split('/')[1]}-${ latestdata[0].split('/')[0] }`; const budget = `${MAX_ALLOWED_CASES - fourteenDayCountdownTotal} remaining cases before we blow the budget`; return html`

🍩🍩 We're good this notebook is no longer relevant! 🍩🍩

${daysUntilNextStep} days until step 3.1 (${moment( step3DateMaybe ).format('MMM Do')})

Numbers as of ${moment(date).format( "ddd, MMM Do" )}

${budget}

${latestdata[1]}

Net new cases

${latestdata[latestdata.length - 1]}

14 day rolling avg

${(pChange * 100).toFixed(2)}%

% change of cases

${latestUnknownData[1]}

Cases with no known source

${(pChangeUnknown * 100).toFixed(2)}%

% change of unknown cases

${exponentialDecay}

Projected 14 day avg

${exponentialDecayUnknown}

Projected cases with unknown source

${gonnaMakeIt ? "Yes" : "No"}

On target for step 3 avg of ${step3Target} with unknown cases <= ${step3UnknownTarget}?

`; }32:T461,// Here cause I learnt something about how to handle a streamed api response spreadsheet = { /*fetch(url) .then(d => { const reader = d.body.getReader(); return new ReadableStream({ start(controller) { return pump(); function pump() { return reader.read().then(({ done, value }) => { if (done) { controller.close(); return; } controller.enqueue(value); return pump(); }); } } }); }) .then(stream => new Response(stream)) .then(res => res.text().then(txt => { const parser = new DOMParser(); const node = parser.parseFromString(txt, "text/html"); const [t1, t2, ...tRest] = node.body.querySelectorAll('table'); const rows = t2.querySelectorAll('tr'); const data = [...rows] .slice(1) .map(row => { const tds = row.querySelectorAll('td'); return [tds[0].textContent, tds[2].textContent, tds[6].textContent]; }) .filter(items => items[2] !== ""); return data; }) )*/ }33:T424,html``34:[] 2f:{"title":"Vic Stage 4 Metro Lockdown","cells":[{"id":0,"value":"md`# Vic Stage 4 Metro Lockdown\nAre we on track for the next step in the roadmap?\n* Roadmap: https://www.coronavirus.vic.gov.au/coronavirus-covid-19-restrictions-roadmaps\n* Data sourced from [covid19data.com.au](https://www.covid19data.com.au/)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":248,"value":"md`\n## Modelling\nTo get projected value I take the percentage change from the last 2 values and extrapolate the final number out from the scheduled date in the roadmap.\n\nThis is called an [exponential decay](https://en.wikipedia.org/wiki/Exponential_decay) in the math world.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":319,"value":"tex`y=a(1-b)^x`","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"md`---\n## Appendix`","pinned":false,"hidden":false,"mode":"ojs"},{"id":539,"value":"MAX_ALLOWED_CASES = step3Target * 21","pinned":false,"hidden":false,"mode":"ojs"},{"id":312,"value":"exponentialDecay = (latestdata[2] * (1 - pChange) ** daysUntilNextStep).toFixed(\n 2\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":491,"value":"exponentialDecayUnknown = (\n latestUnknownData[2] *\n (1 - pChangeUnknown) ** daysUntilNextStep\n).toFixed(2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":144,"value":"projectedDecrease = {\n // Extrapolate percentage change across remaining days until step date\n // See exponentialDecay above for formula to do this\n const [, , val] = latestdata;\n let lastVal = val;\n\n const vals = Array(daysUntilNextStep)\n .fill('x')\n .map((acc, day, id, arr) => {\n const change = lastVal * (1 - Math.abs(pChange));\n lastVal = change;\n\n return change;\n }, []);\n\n return vals;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":509,"value":"projectedUnknownDecrease = {\n // Extrapolate percentage change across remaining days until step 2 date\n // See exponentialDecay above for formula to do this\n const [, , val] = latestUnknownData;\n let lastVal = val;\n\n const vals = Array(daysUntilNextStep)\n .fill('x')\n .map((acc, day, id, arr) => {\n const change = lastVal * (1 - Math.abs(pChangeUnknown));\n lastVal = change;\n\n return change;\n }, []);\n\n return vals;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":420,"value":"projectedDecreaseSparkline = sparkline(projectedDecrease)","pinned":false,"hidden":false,"mode":"ojs"},{"id":514,"value":"projectedUnknownDecreaseSparkline = sparkline(projectedUnknownDecrease)","pinned":false,"hidden":false,"mode":"ojs"},{"id":150,"value":"step2Date = moment('2020-09-28')","pinned":false,"hidden":false,"mode":"ojs"},{"id":190,"value":"step2Target = 50","pinned":false,"hidden":false,"mode":"ojs"},{"id":464,"value":"step3Target = 5","pinned":false,"hidden":false,"mode":"ojs"},{"id":517,"value":"step3UnknownTarget = 5","pinned":false,"hidden":false,"mode":"ojs"},{"id":461,"value":"step3Date = moment('2020-10-19')","pinned":false,"hidden":false,"mode":"ojs"},{"id":596,"value":"step3DateMaybe = moment('2020-10-26')","pinned":false,"hidden":false,"mode":"ojs"},{"id":154,"value":"daysUntilNextStep = step3DateMaybe.diff(moment(), 'days') + 1","pinned":false,"hidden":false,"mode":"ojs"},{"id":371,"value":"meanRollingPChange = {\n const lastFortnight = cases.slice(-14);\n const avgs = [];\n\n for (let i = 0; i < lastFortnight.length; i = i + 2) {\n avgs.push(getPChange([lastFortnight[i], lastFortnight[i + 1]]));\n }\n\n return d3.mean(avgs);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":363,"value":"getPChange = vals => {\n const [d1, d2] = vals.reverse();\n const v1 = parseFloat(d1[d1.length - 1]);\n const v2 = parseFloat(d2[d2.length - 1]);\n\n return Math.abs((v1 - v2) / ((v1 + v2) / 2));\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":498,"value":"pChangeUnknown = getPChange(last2UnknownValues)","pinned":false,"hidden":false,"mode":"ojs"},{"id":113,"value":"last2Values = cases.slice(-2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":112,"value":"pChange = getPChange(last2Values)","pinned":false,"hidden":false,"mode":"ojs"},{"id":47,"value":"latestdata = cases[cases.length - 1]","pinned":false,"hidden":false,"mode":"ojs"},{"id":484,"value":"latestUnknownData = unknown[unknown.length - 1]","pinned":false,"hidden":false,"mode":"ojs"},{"id":494,"value":"last2UnknownValues = {\n const pair = unknown.slice(-2);\n\n return pair.map(p => p.slice(0, 3));\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":478,"value":"unknown = data.unknown.slice(-14)","pinned":false,"hidden":false,"mode":"ojs"},{"id":475,"value":"cases = data.cases.slice(-14)","pinned":false,"hidden":false,"mode":"ojs"},{"id":553,"value":"fourteenDayCountdownTotal = d3.sum(\n cases\n .filter(c => {\n const [date] = c;\n const d = `2020-${date.split('/')[1]}-${date.split('/')[0]}`;\n\n return moment(d).isSameOrAfter('2020-10-05');\n })\n .map(x => x[1])\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":332,"value":"// Keep getting PR_END_OF_FILE errors???\ndata = fetch(\"https://c19.ryanseddon.workers.dev\").then(res => res.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":146,"value":"moment = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":386,"value":"d3 = require('d3-arrays')","pinned":false,"hidden":false,"mode":"ojs"},{"id":417,"value":"sparkline = stdlib.UnicodeColumnChartSparkline","pinned":false,"hidden":false,"mode":"ojs"},{"id":397,"value":"stdlib = require(\"https://unpkg.com/@stdlib/stdlib@0.0.34/dist/stdlib-flat.min.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}