31:T11a4,// Adapted from data provided by Montana's Legislative Fiscal Division in Dec. 2020 raw = [ { "year": "2002", "tot_expenditures": "3474096804", "gf_expenditures": "1404223087", "ss_expenditures": "572926879.7", "cpi": "1.781666667", "population": "909902.25", "personal_income": "21970.169" }, { "year": "2003", "tot_expenditures": "3540060727", "gf_expenditures": "1278046021", "ss_expenditures": "623443802.8", "cpi": "1.820916667", "population": "916643.875", "personal_income": "23116.195" }, { "year": "2004", "tot_expenditures": "3725776380", "gf_expenditures": "1285197432", "ss_expenditures": "751157152.4", "cpi": "1.861083333", "population": "926116.875", "personal_income": "24998.058" }, { "year": "2005", "tot_expenditures": "3826330682", "gf_expenditures": "1364968809", "ss_expenditures": "779439091.2", "cpi": "1.917", "population": "936317.125", "personal_income": "26901.452" }, { "year": "2006", "tot_expenditures": "4145747782", "gf_expenditures": "1569779070", "ss_expenditures": "901340949.8", "cpi": "1.989416667", "population": "947970.75", "personal_income": "29236.606" }, { "year": "2007", "tot_expenditures": "4349720258", "gf_expenditures": "1713450016", "ss_expenditures": "935496450.2", "cpi": "2.04112", "population": "960200.75", "personal_income": "31591.206" }, { "year": "2008", "tot_expenditures": "4956877476", "gf_expenditures": "2068217904", "ss_expenditures": "1060357252", "cpi": "2.11684", "population": "972024.125", "personal_income": "33805.165" }, { "year": "2009", "tot_expenditures": "5017414052", "gf_expenditures": "1861781529", "ss_expenditures": "1078565682", "cpi": "2.146485833", "population": "981144.375", "personal_income": "34023.008" }, { "year": "2010", "tot_expenditures": "5402254246", "gf_expenditures": "1709175869", "ss_expenditures": "1179621845", "cpi": "2.167613333", "population": "988373.25", "personal_income": "34383.195" }, { "year": "2011", "tot_expenditures": "5506333371", "gf_expenditures": "1746439883", "ss_expenditures": "1139756758", "cpi": "2.210613333", "population": "994833.875", "personal_income": "36836.736" }, { "year": "2012", "tot_expenditures": "5289660659", "gf_expenditures": "1774442619", "ss_expenditures": "1184240341", "cpi": "2.275535", "population": "1001357.875", "personal_income": "39322.369" }, { "year": "2013", "tot_expenditures": "5375371366", "gf_expenditures": "1996921062", "ss_expenditures": "1117028026", "cpi": "2.313886667", "population": "1009899.25", "personal_income": "40683.003" }, { "year": "2014", "tot_expenditures": "5676324656", "gf_expenditures": "2187909716", "ss_expenditures": "1177190405", "cpi": "2.34989", "population": "1018756.5", "personal_income": "41577.949" }, { "year": "2015", "tot_expenditures": "5775075056", "gf_expenditures": "2167939626", "ss_expenditures": "1185373090", "cpi": "2.366704167", "population": "1027247.75", "personal_income": "44007.573" }, { "year": "2016", "tot_expenditures": "6052672625", "gf_expenditures": "2317218881", "ss_expenditures": "1152374807", "cpi": "2.382355", "population": "1036965", "personal_income": "45042.772" }, { "year": "2017", "tot_expenditures": "6456794816", "gf_expenditures": "2360678690", "ss_expenditures": "1130123336", "cpi": "2.4264575", "population": "1048123.375", "personal_income": "46633.873" }, { "year": "2018", "tot_expenditures": "6530757497", "gf_expenditures": "2276512422", "ss_expenditures": "1246724432", "cpi": "2.481086667", "population": "1057596.375", "personal_income": "49055.434" }, { "year": "2019", "tot_expenditures": "6748968996", "gf_expenditures": "2405387910", "ss_expenditures": "1243856600", "cpi": "2.532565", "population": "1065735.625", "personal_income": "51382.40875" }, { "year": "2020", "tot_expenditures": "7300121093", "gf_expenditures": "2452214205", "ss_expenditures": "1244705079", "cpi": "2.572648333", "population": "1072956.524", "personal_income": "54993.61767" } ]32:T430,summary = (data, measure, is_inflation_adjusted, is_per_capita) => { const measureLabel = (measure === 'gf_expenditures') ? 'state General Fund' : 'state' const inflationLabel = (is_inflation_adjusted === 'yes') ? 'inflation-adjusted' : 'absolute dollar' const perCapLabel = (is_per_capita === 'yes') ? 'per-capita' : 'total' const d_initial = data.find(d => d.year === '2009') const d_final = data.find(d => d.year === '2019') let value_initial = d_initial[measure] let value_final = d_final[measure] if (is_inflation_adjusted === 'yes') { value_initial = value_initial * d_final.cpi / d_initial.cpi // no need to adjust value_final } if (is_per_capita === 'yes') { value_initial = value_initial / d_initial.population value_final = value_final / d_final.population } const change = d3.format('.0%')(value_final / value_initial - 1) return md`In ${inflationLabel} terms, ${perCapLabel} ${measureLabel} spending grew by **${change}** from ${format(value_initial)} to ${format(value_final)} between 2009 and 2019.` }33:T554,// adapted from from @jashkenas/inputs radio = (config = {}) => { let { value: formValue, title, description, submit, options, disabled } = Array.isArray(config) ? { options: config } : config; options = options.map(o => typeof o === "string" ? { value: o, label: o } : o ); const form = input({ type: "radio", title, description, submit, getValue: input => { if (input.checked) return input.value; const checked = Array.prototype.find.call(input, radio => radio.checked); return checked ? checked.value : undefined; }, form: html` ` }); form.output.remove(); return form; }34:[] 2f:{"title":"Montana budget growth","cells":[{"id":0,"value":"md`# Montana budget growth`","pinned":false,"hidden":false,"mode":"ojs"},{"id":188,"value":"fronter = md`\n### Slicing and dicing the state budget\n\n_There are several ways to look at how Montana's state budget has grown over the last decade. Use the toggles below to see how three particular factors shift the trendline._\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"viewof is_inflation_adjusted = radio({\n // title: 'Which spending',\n description: 'Inflation adjustment accounts for the declining real value of the dollar over time by translating all figures to 2019 dollars',\n options: [\n { label: 'Look at absolute dollars', value: 'no' },\n { label: 'Look at inflatation adjusted dollars', value: 'yes' },\n ],\n value: 'no'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":116,"value":"viewof is_per_capita = radio({\n // title: 'Which spending',\n description: 'Per-capita figures account for Montana population growth',\n options: [\n { label: 'Look at total spending', value: 'no' },\n { label: 'Look at spending per resident', value: 'yes' },\n ],\n value: 'no'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":92,"value":"viewof measure = radio({\n // title: 'Which spending',\n description: `The General Fund is Montana's 'state checkbook', often used as a proxy for the entire state budget`,\n options: [\n { label: 'Look at all state spending', value: 'tot_expenditures' },\n { label: 'Look at General Fund spending only', value: 'gf_expenditures' },\n ],\n value: 'tot_expenditures'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"budgetGrowthEmbed = html`\n

\n \n

${summary(data, measure, is_inflation_adjusted, is_per_capita)}

${await chart(data, measure, is_inflation_adjusted, is_per_capita)}

Data: Montana Legislative Fiscal Division. Chart: Eric Dietrich / MTFP

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"data = raw.map(d => {\n return {\n year: d.year,\n tot_expenditures: +d.tot_expenditures,\n gf_expenditures: +d.gf_expenditures,\n cpi: +d.cpi,\n population: +d.population,\n personal_income: +d.personal_income,\n }\n})\n.filter(d => +d.year >= 2009)\n.filter(d => +d.year <= 2019)","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"chart = (data, measure, is_inflation_adjusted, is_per_capita) => {\n // const metricName = measure\n \n const useData = data.map(d => {\n let value = d[measure]\n if (is_inflation_adjusted === 'yes') {\n const cpi_19 = data.find(d => d.year === '2019').cpi\n value = value * cpi_19 / d.cpi\n }\n if (is_per_capita === 'yes') {\n const cpi_19 = data.find(d => d.year === '2019').cpi\n value = value / d.population\n }\n return {\n year: d.year,\n value,\n }\n })\n \n const color = '#AE9864'\n return embed({\n title: \"\",\n data: {\"values\": useData},\n width: getWidth(),\n height: 200,\n config: baseConfig,\n // transform: [sevenDayAvgTransform(metricName)],\n layer: [\n bars('value', color, null),\n // sevenDayAvg(color),\n ]\n // .concat(makeAnnotationLayers(annotations))\n\n },{actions: false, renderer: 'canvas'})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"annotations = [\n // {label: 'First cases', date: new Date('3/13/20')},\n // {label: 'Bullock/Trump call', date: new Date('3/30/20')},\n // {label: 'State sets 15k/wk testing goal', date: new Date('4/29/20')},\n // {label: 'Phase 2 reopening', date: new Date('6/1/20')},\n // {label: 'Face mask order', date: new Date('7/15/20')}\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":157,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":209,"value":"format = (val) => {\n if (val > 1000000000) {\n return d3.format('$,.1f')(val / 1000000000) + ' billion'\n }\n if (val > 1000000) {\n return d3.format('$,.1f')(val / 1000000) + ' million'\n }\n else {\n return d3.format('$,.0f')(val)\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"makeAnnotationLayers = (annotations) => [\n {\n mark: 'rule',\n data: {values: annotations},\n encoding: {\n x: dateAxis\n }\n },\n {\n mark: { type:'text', angle: 90, dy: -7, dx: 3, align: 'left'},\n data: {values: annotations},\n encoding: {\n x: dateAxis,\n y: {value: 0,},\n text: {field: 'label', type: 'nominal'}\n }\n }\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":42,"value":"baseConfig = ({\n view: {\n \"stroke\": \"transparent\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":35,"value":"getWidth = () => Math.min(width - 60, 600)","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"dateAxis = ({\n field: \"year\",\n type: \"ordinal\",\n // scale: { domainMin: {\"year\": 2020, \"month\": \"march\", \"date\": 13} },\n axis: { grid: false },\n title: 'Fiscal year',\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"bars = (metric, color, domain, format='$,.0f',) => ({\n mark: {\n type: \"bar\",\n // size: (width >= 400) ? 3 : 1,\n color: color,\n // opacity: 0.3,\n // tooltip: true,\n clip: true,\n },\n encoding: {\n x: dateAxis,\n y: {\n field: metric,\n type: \"quantitative\",\n scale: { domain: domain}, \n axis: { domain: false, format: format },\n title: \"\",\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"embed = require('vega-embed@6')","pinned":false,"hidden":false,"mode":"ojs"},{"id":263,"value":"import { input } from '@jashkenas/inputs'","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}