25:["$","title",null,{"children":"Budget Reviser | Ell Bradshaw | Observable"}] 49:Teb8,chart = { const width = 800; const height = 400; const margin = { top: 20, right: 30, bottom: 30, left: 40 }; const cumsum = d3.cumsum(budgetEntries, (d, idx) => idx == 0 ? d.available : d.budgeted - d.spent ); const x = d3 .scaleTime() .domain(d3.extent(budgetEntries, (d) => d.monthValue)) .range([margin.left, width - margin.right]); const yRange = d3.extent([ ...d3.extent(cumsum), ...d3.extent(budgetEntries, (d) => d.budgeted), ...d3.extent(budgetEntries, (d) => d.spent) ]); const y = d3 .scaleLinear() .domain([Math.min(0, yRange[0]), Math.max(0, yRange[1])]) .range([height - margin.bottom, margin.top]); const svg = d3.create("svg").attr("width", width).attr("height", height); const bins = d3 .scaleBand() .domain( d3.timeMonth.range(x.domain()[0], d3.timeMonth.offset(x.domain()[1], 1)) ) .range(x.range()) .paddingInner(0.1) .paddingOuter(0.05); const narrowBins = bins.copy().paddingInner(0.6).paddingOuter(0.3); const points = bins.copy().padding(1).paddingOuter(0.5); svg .append("g") .attr("transform", `translate(0,${height - margin.bottom})`) .call( d3.axisBottom(bins).tickFormat((d) => { const [month, year] = formatYnab(d).split(" "); return month === "Jan" ? year : month; }) ); svg.call( budgetChart, { values: budgetEntries }, currentOverrides, { x, y, bins, narrowBins, points }, { height, margin } ); const getNiceDiv = (num) => { if (num < 50) return 5; if (num < 200) return 10; if (num < 500) return 25; if (num < 1000) return 50; return 100; }; const round = (num, div) => Math.round(num / div) * div; const isNear = (ref, tolerance) => (value) => Math.abs(value - ref) < Math.abs(ref * tolerance); function getNearestValue(month, exactValue, { useData }) { const monthIdx = budgetEntries.findIndex((entry) => entry.month === month); const curMonth = budgetEntries[monthIdx]; const lastMonth = budgetEntries[monthIdx - 1]; console.log(exactValue, curMonth, lastMonth); const isNearValue = isNear(exactValue, 0.2); if (useData) { if (curMonth && isNearValue(curMonth.spent)) { return curMonth.spent; } if (lastMonth && isNearValue(lastMonth.budgeted)) { return lastMonth.budgeted; } } return round(exactValue, getNiceDiv(exactValue)); } svg.on("click", (evt) => { // Bars are centered on ticks, so we gotta do a weird offset, this is good enough const exactDate = d3.timeDay.offset(x.invert(evt.layerX), 15); console.log( "x click", exactDate, d3.timeMonth.floor(exactDate), d3.timeMonth.round(exactDate), d3.timeMonth.ceil(exactDate) ); const date = formatDate(d3.timeMonth.floor(exactDate)); const exactValue = y.invert(evt.layerY); if (evt.altKey) { return; } console.log(evt); const value = getNearestValue(date, exactValue, { useData: !evt.ctrlKey }); const filtered = flatOverrides .filter( (o) => !( o.categoryGroup === categoryGroup && o.category === category && o.date === date ) ) .map((entry, idx) => (entry.idx ? entry : { ...entry, idx: idx + 1 })); if (evt.shiftKey) { console.log(categoryGroup, category, date); set(viewof flatOverrides, filtered); } else { set(viewof flatOverrides, [ ...filtered, { idx: d3.max(filtered, (d) => Number(d.idx)) + 1, categoryGroup, category, date, value } ]); } }); return svg.node(); }4a:T83b,YearMonthInput = ({ label = "Year/Month", buttons = false } = {}) => { //.filter((m) => yearmonths.has(`${m} ${start.year}`)) const monthOpts = d3 .map(months, (m) => ``) .join("\n"); const yearOpts = d3 .map(years, (y) => ``) .join("\n"); const form = html``; const stepMonth = (dir) => { const monthList = [...months]; const yearList = [...years]; const monthIdx = monthList.findIndex((m) => m === form.month.value); const yearIdx = yearList.findIndex((y) => y === form.year.value); const nextMonth = monthIdx + dir; const nextYear = yearIdx + dir; if (nextMonth >= monthList.length) { if (nextYear >= yearList.length) return; form.month.value = monthList[0]; form.year.value = yearList[nextYear]; } else if (nextMonth < 0) { if (nextYear < 0) return; form.month.value = monthList[monthList.length - 1]; form.year.value = yearList[nextYear]; } else { form.month.value = monthList[nextMonth]; } form.dispatchEvent(new Event("input", { bubbles: true })); form.oninput(); }; form.oninput = () => { const v = { year: form.year.value, month: form.month.value }; v.shortDate = `${v.month} ${v.year}`; v.date = parseYnab(v.shortDate); return (form.value = v); }; if (buttons) { const prevBtn = html``; const nextBtn = html``; prevBtn.addEventListener("click", (evt) => { evt.preventDefault(); evt.stopPropagation(); stepMonth(-1); }); nextBtn.addEventListener( "click", (evt) => { evt.preventDefault(); evt.stopPropagation(); stepMonth(1); }, true ); form.insertBefore(prevBtn, form.querySelector("select")); form.appendChild(nextBtn); } form.oninput(); return form; }4b:T645,makePrevNextBtns = ({ listGetters, valGetters, valSetters, finished = () => {} }) => { const step = (dir) => { let nextIdx = []; for (const [optIdx, getVal] of valGetters.entries()) { const curVal = getVal(); const opts = listGetters[optIdx](nextIdx); nextIdx.push(opts.findIndex((v) => v === curVal)); } let carry = true; let lastIdx = null; for (let optIdx = listGetters.length - 1; carry && optIdx >= 0; optIdx--) { lastIdx = optIdx; const opts = listGetters[optIdx](nextIdx); nextIdx[optIdx] += dir; carry = nextIdx[optIdx] < 0 || nextIdx[optIdx] > opts.length - 1; console.log(nextIdx, optIdx, carry); } if (carry) return; /* for ( let rippleIdx = optIdx + 1; rippleIdx < listGetters.length - 1; rippleIdx++ ) { const prevOpts = listGetters[rippleIdx](nextIdx); nextIdx[rippleIdx] = dir < 0 ? prevOpts.length - 1 : 0; } */ const opts = listGetters[lastIdx](nextIdx); valSetters[lastIdx](opts[nextIdx[lastIdx]]); /*for (const [optIdx, setter] of Object.entries(valSetters)) { const opts = listGetters[optIdx](nextIdx); setter(opts[nextIdx[optIdx]]); }*/ }; const buttons = { prev: html``, next: html`` }; buttons.prev.addEventListener("click", (evt) => { evt.preventDefault(); evt.stopPropagation(); step(-1); }); buttons.next.addEventListener("click", (evt) => { evt.preventDefault(); evt.stopPropagation(); step(1); }); return buttons; }4c:T9b7,budgetChart = ( selection, { key, total, cumsum, values: entries }, overrides, { x, y, outerY, bins, narrowBins, points }, inOpts = {} ) => { const defaults = { colors: { budgeted: "goldenrod", surplus: "darkgreen", spent: "cornflowerblue" }, height: 50, margin: { bottom: 5, top: 5, left: 5, right: 50 } }; const opts = { ...defaults, ...inOpts }; console.log("Entries", entries); const cumavail = d3.cumsum(entries, (d, idx) => idx == 0 ? d.available : d.budgeted - d.spent ); const maxSpent = d3.quantile( entries.map((d) => d.budgeted), 0.9 ); const scaleMax = Math.max(maxSpent, 1); if (!y) { y = d3 .scaleLinear() .domain([0, scaleMax]) .range([outerY(total) - opts.margin.bottom, outerY(0) + opts.margin.top]); } const opacity = d3.scaleThreshold( [0, scaleMax * 1.1, scaleMax * 2, scaleMax * 3], [0.5, 1, 0.5, 0.25, 0.1] ); console.log(key, y.domain(), y.range()); selection .append("g") .attr("transform", `translate(${opts.width - opts.margin.right},0)`) .call(d3.axisRight(y).tickValues([y.domain()[1]]).tickSizeOuter(0)); selection .append("g") .selectAll("rect") .data(entries) .join("rect") .attr("x", (d) => bins(d.monthValue)) .attr("y", (d) => Math.min(y(0), y(d.spent))) .attr("width", bins.bandwidth()) .attr("height", (d) => Math.abs(y(d.spent) - y(0))) .attr("fill", opts.colors.spent) .style("opacity", (d) => opacity(d.spent)); selection .append("g") .selectAll("rect") .data(entries) .join("rect") .attr("x", (d) => narrowBins(d.monthValue)) .attr("y", (d, i) => Math.min(y(0), y(cumavail[i]))) .attr("width", narrowBins.bandwidth()) .attr("height", (d, i) => Math.abs(y(cumavail[i]) - y(0))) .attr("fill", opts.colors.surplus) .style("opacity", (d, i) => opacity(cumavail[i])); const budgeted = d3 .line() .x((d) => points(d.monthValue)) .y((d) => y(d.budgeted)) .curve(d3.curveStep); selection .append("path") .attr("fill", "none") .attr("stroke", opts.colors.budgeted) .attr("stroke-width", 1.5) .attr("d", budgeted(entries)); selection .append("g") .selectAll("circle") .data(overrides) .join("circle") .attr("cx", (d) => points(getDate(d.date))) .attr("cy", (d, i) => y(d.value)) .attr("r", bins.bandwidth() / 5) .attr("fill", opts.colors.budgeted); }4d:Tceb,allBudgeted = { const width = 800; const height = 5000; const outermargin = { top: 20, right: 30, bottom: 20, left: 40 }; const margin = { top: 5, right: 30, bottom: 5, left: 40 }; const grouped = multiGroup(exportedOverrides, ["categoryGroup", "category"]); delete grouped.Meta; delete grouped["Credit Card Payments"]; delete grouped["Savings Goals"]; delete grouped["Rainy Day Funds"]["Windfall"]; const entries = listifyGrouped(grouped); let totalSpent = 0; let totalCount = 0; for (const supercat of entries) { supercat.total = 0; for (const subcat of supercat.values) { subcat.cumsum = supercat.total; subcat.total = d3.sum(subcat.values, (d) => d.budgeted); supercat.total += subcat.total; } supercat.cumsum = totalSpent; supercat.cumcount = totalCount; supercat.subcount = supercat.values.length; totalSpent += supercat.total; totalCount += supercat.subcount; } console.log("entries", entries, totalSpent, totalCount); const svg = d3.create("svg").attr("width", width).attr("height", height); const supercatoffset = d3.cumsum(entries, (d) => d.total); const x = d3 .scaleTime() .domain(d3.extent(budgetEntries, (d) => d.monthValue)) .range([margin.left, width - margin.right]); const y = d3 .scaleLinear() .domain([0, totalSpent]) .range([ 0, height - (margin.top + margin.bottom) * totalCount - outermargin.top - outermargin.bottom ]); const bins = d3 .scaleBand() .domain( d3.timeMonth.range(x.domain()[0], d3.timeMonth.offset(x.domain()[1], 1)) ) .range(x.range()) .paddingInner(0.1) .paddingOuter(0.05); const narrowBins = bins.copy().paddingInner(0.6).paddingOuter(0.3); const points = bins.copy().padding(1).paddingOuter(0.5); svg .append("g") .attr("transform", `translate(0,${height - margin.bottom})`) .call( d3.axisBottom(bins).tickFormat((d) => { const [month, year] = formatYnab(d).split(" "); return month === "Jan" ? year : month; }) ); const supercats = svg .append("g") .selectAll("g") .data(entries) .join("g") .attr( "transform", (d, i) => `translate(0, ${ y(d.cumsum) + (margin.top + margin.bottom) * d.cumcount })` ); const cats = supercats .selectAll("g") .data((d) => d.values) .join("g") .attr( "transform", (d, i) => `translate(0, ${y(d.cumsum) + (margin.top + margin.bottom) * i})` ); cats.append("g").each(function (d, i) { d3.select(this).call( budgetChart, d, currentOverrides, { x, outerY: y, bins, narrowBins, points }, { height, width, margin, colors: { surplus: "lightgray", budgeted: "goldenrod", spent: "cornflowerblue" } } ); }); supercats .append("text") .text((d) => d.key) .attr("x", width - margin.right) .style("dominant-baseline", "hanging") .style("text-anchor", "end"); cats .append("text") .text((d) => d.key) .attr("font-size", ".75em") .style("dominant-baseline", "hanging"); return svg.node(); }4e:[{"id":"7a97c543e78b8ecdf48fd482d4c741d642e63a29710d6e93ea16c490ad307004742056d8cd283a3b8a18a86feaa89a6bb48be9166bcfdf0abbad525e7ba73156","href":"https://static.observableusercontent.com/files/7a97c543e78b8ecdf48fd482d4c741d642e63a29710d6e93ea16c490ad307004742056d8cd283a3b8a18a86feaa89a6bb48be9166bcfdf0abbad525e7ba73156","name":"overrides.csv","type":"text/csv","lastModified":1698280389323.871,"size":351}] 29:{"id":"a3c0ef79b8938e46","slug":null,"title":"Budget Reviser","thumbnail":"cb7420cf1a4c87139b82917c03005b25d54b9a86fcb9db5dff1dc3971ee1e5ce","access_level":"public","create_time":"$D2023-05-04T07:38:43.821Z","update_time":"$D2026-09-02T22:09:16.721Z","view_time":null,"first_public_time":"$D2023-05-04T07:38:43.821Z","has_unpublished_edits":null,"fork":{"id":"7dcef0ebff4028d9","slug":"input-chart","title":"Input + Chart","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"960355db0b7c2a9c","login":"cincodenada","name":"Ell Bradshaw","avatar_url":"https://avatars-next.observableusercontent.com/c83e95a63117fd7f77675a226ebd1079bf73a5f1277fae51e256f1909f8206dd","tier":"starter_2024","bio":"","following":false},"version":1622,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"0c9b104cbb4c21b2","login":"cincodenada","name":"Ell Bradshaw","avatar_url":"https://avatars-next.observableusercontent.com/c83e95a63117fd7f77675a226ebd1079bf73a5f1277fae51e256f1909f8206dd","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"0c9b104cbb4c21b2","login":"cincodenada","name":"Ell Bradshaw","avatar_url":"https://avatars-next.observableusercontent.com/c83e95a63117fd7f77675a226ebd1079bf73a5f1277fae51e256f1909f8206dd","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Budget Reviser","cells":[{"id":4,"value":"# Budget Reviser\n\nThis is a tool to figure out good budgeting values over time in YNAB. It won't be super useful unless you, like me, have been using YNAB largely for recordkeeping but not for budget-enforcement, and want to adjust your budgets retroactively to reflect a kind of manually-moving average of what you spend, but if that's what you want, this is an overengineered tool to do so. Just upload a budget backup below. Register is optional, but will allow you to inspect transactions with alt-click if you do upload it.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":12,"value":"viewof budgetfile = Inputs.file({label: \"Budget\", accept: \".csv\", required: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"viewof registerfile = Inputs.file({label: \"Register\", accept: \".csv\", required: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":855,"value":"viewof savedOverrides = Inputs.file({ label: \"Saved Overrides\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":653,"value":"Once a budget is loaded, dropdowns will appear below with your categories. You can also select a start date to show only recent months.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":27,"value":"viewof categoryGroup = Inputs.select(Object.keys(budgetGrouped), {label: \"Category Group\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"viewof category = Inputs.select(Object.keys(budgetGrouped[categoryGroup]), {label: \"Category\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":704,"value":"viewof start = YearMonthInput({ label: \"Start Date\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":634,"value":"flatOverrides","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1036,"value":"md`## ${categoryGroup} - ${category}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":322,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":898,"value":"{\n const getCategoryGroups = () => Object.keys(budgetGrouped);\n const getCategories = ([groupIdx]) =>\n Object.keys(budgetGrouped[getCategoryGroups()[groupIdx]]);\n return PrevNextBtns({\n label: \"Category\",\n listGetters: [getCategoryGroups, getCategories],\n valGetters: [() => categoryGroup, () => category],\n valSetters: [\n set.bind(null, viewof categoryGroup),\n set.bind(null, viewof category)\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":700,"value":"overrideSummary = applyOverrides(budgetFormatted, budgetOverrides)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1114,"value":"overridesView = _.groupBy(\n overrideSummary.filter((o) => o.month === formatDate(curDate.date)),\n \"categoryGroup\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":702,"value":"viewof curDate = YearMonthInput({ label: \"Budget Month\", buttons: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":782,"value":"{\n const rows = _.map(overridesView, (categories, groupName) => [\n `${groupName}${\n Math.round(d3.sum(categories, (c) => c.budgeted) * 100) / 100\n }`,\n ...categories.map(\n (o) =>\n `${o.category}${Math.round(o.budgeted * 100) / 100}`\n )\n ]).flat();\n return html`\n \n ${rows.join(\"\\n\")}\n

Category	Budgeted

`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1132,"value":"Plot.plot({\n //x: { type: \"log\" },\n //y: { type: \"log\" },\n marks: [\n Plot.boxY(filteredEntries, {\n x: \"category\",\n y: \"spent\",\n fill: \"categoryGroup\"\n })\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":675,"value":"# Support Code","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":649,"value":"## Setup\n\nLoad and parse the files","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1469,"value":"File.prototype.csv = async function() { console.log(\"csv\", this); return d3.csvParse(await this.text()) }","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"budget = budgetfile.csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":647,"value":"register = registerfile.csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"## Utils\n\nThese are various utility functions used above","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":126,"value":"function multiGroup(items, keys) {\n if(!keys.length) { return items }\n const [curKey, ...nextKeys] = keys;\n return _.chain(items)\n .groupBy(curKey)\n .mapValues(groupItems => multiGroup(groupItems, nextKeys))\n .value()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1466,"value":"listifyGrouped = {\n const listify = (grouped) => {\n if (Array.isArray(grouped)) {\n return grouped;\n } else {\n return Object.entries(grouped).map(([key, val]) => ({\n key,\n values: listify(val)\n }));\n }\n };\n return listify;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"function mapGrouped(obj, fn) {\n if(Array.isArray(obj)) {\n return fn(obj)\n } else {\n return _.mapValues(obj, vals => mapGrouped(vals, fn))\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"function categorize(lineItems, mapfn) {\n return mapGrouped(multiGroup(lineItems, ['Category Group', 'Category']), items => items.map(mapfn))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"parseYnab = d3.timeParse(\"%b %Y\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"getDate = d3.timeParse(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":552,"value":"formatDate = d3.timeFormat(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1027,"value":"formatYnab = d3.timeFormat(\"%b %Y\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"parseDate = (d) => formatDate(parseYnab(d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"parseMoney = (money) => parseFloat(money.replace('$',''));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":584,"value":"formatMoney = d3.format(\"$.2f\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1291,"value":"formatBudgetLine = (line) => ({\n categoryGroup: line[\"Category Group\"],\n category: line[\"Category\"],\n month: parseDate(line[\"Month\"]),\n monthValue: parseYnab(line[\"Month\"]),\n spent: -parseMoney(line[\"Activity\"]),\n budgeted: parseMoney(line[\"Assigned\"]),\n available: parseMoney(line[\"Available\"])\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":750,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":880,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":893,"value":"PrevNextBtns = ({ label, ...opts }) => {\n const { prev, next } = makePrevNextBtns(opts);\n return html``;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":662,"value":"## Budget Parsing/Formatting","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":803,"value":"budgetFormatted = budget.map(formatBudgetLine)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"budgetGrouped = multiGroup(budgetFormatted, [\"categoryGroup\", \"category\"])\n/*categorize(budget, (line) => ({\n month: parseDate(line[\"Month\"]),\n monthValue: parseYnab(line[\"Month\"]),\n spent: -parseMoney(line[\"Activity\"]),\n budgeted: parseMoney(line[\"Budgeted\"]),\n available: parseMoney(line[\"Available\"])\n}))*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"filteredEntries = budgetGrouped[categoryGroup][category].filter(\n (entry) => entry.monthValue >= start.date\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":718,"value":"yearmonths = new Set(budget.map(e => e.Month))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":713,"value":"years = new Set(d3.map(yearmonths, ym => ym.split(' ')[1]))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":712,"value":"// This silliness is because of partial years resulting in bad month orders, bleh\nmonths = new Set(\n d3\n .map(years, (y) =>\n d3.map(\n d3.filter(yearmonths, (ym) => ym.endsWith(y)),\n (ym) => ym.split(\" \")[0]\n )\n )\n .reverse()\n .flat()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":670,"value":"## Override Handling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1269,"value":"blankOverrides = { \n const empty = []\n empty.columns = [\"idx\", \"categoryGroup\", \"category\", \"date\", \"value\"]\n return empty\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":446,"value":"viewof flatOverrides = Inputs.input(savedOverrides?.csv() || blankOverrides)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"viewof selectedOverrides = Inputs.table(flatOverrides)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":473,"value":"budgetOverrides = mapGrouped(multiGroup(flatOverrides, ['categoryGroup','category', 'date']), vals => vals.slice(-1)[0].value)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"function applyOverrides(entries, allOverrides) {\n let lastOverrides = {};\n let lastValues = {};\n return entries.map((entry) => {\n const catPath = [entry.categoryGroup, entry.category];\n const overrides = _.get(allOverrides, catPath);\n const curOverride = overrides?.[entry.month];\n const lastOverride = _.get(lastOverrides, catPath);\n const lastValue = _.get(lastValues, catPath);\n const getOverrides = () => {\n if (curOverride)\n return { budgeted: curOverride, override: true, continued: false };\n if (lastOverride)\n return { budgeted: lastOverride, override: true, continued: true };\n return { override: false, continued: false };\n };\n const combined = {\n ...entry,\n ...getOverrides()\n };\n combined.changed = lastValue !== combined.budgeted;\n _.set(lastValues, catPath, combined.budgeted);\n if (!_.isNil(curOverride)) {\n _.set(lastOverrides, catPath, curOverride);\n }\n return combined;\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":683,"value":"currentOverrides = flatOverrides.filter(\n (entry) =>\n entry.category === category && entry.categoryGroup === categoryGroup\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"budgetEntries = applyOverrides(\n filteredEntries,\n budgetOverrides ?? []\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":672,"value":"## Input Processing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":480,"value":"function set(input, value) {\n input.value = value;\n input.dispatchEvent(new Event(\"input\", { bubbles: true }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":535,"value":"exportedOverrides = budgetFormatted\n .filter((entry) => entry.monthValue > start.date)\n .map((entry) => {\n const matchedOverride = _.get(budgetOverrides, [\n entry.categoryGroup,\n entry.category\n ]);\n return matchedOverride\n ? {\n ...entry,\n budgeted: formatMoney(matchedOverride.value)\n }\n : entry;\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"Plot.plot({\n x: {\n type: \"utc\",\n },\n marks: [\n Plot.rectY(budgetEntries, {x: {interval: \"month\", value: \"month\"}, y: \"spent\", fill: \"cornflowerblue\"}),\n Plot.rectY(budgetEntries, Plot.mapY(\"cumsum\", {x: {interval: \"month\", value: \"month\"}, y: d => d.budgeted - d.spent, fill: \"darkgreen\"})),\n Plot.lineY(budgetEntries, {x: \"month\", y: \"budgeted\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1302,"value":"$4c","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1285,"value":"$4d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":693,"value":"## Register Parsing ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1467,"value":"// quick check of what's actually on the File object\n[typeof budgetfile.csv, budgetfile.constructor.name, Object.getPrototypeOf(budgetfile) === File.prototype]","pinned":true,"hidden":false,"mode":"js","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4e","stdlib":"1"}} 24:null