2c:null 2d:["$","title",null,{"children":"calculang tools ✨ (bad/drafty version) | Declan Naughton | Observable"}] 32:T568,x = vega({ data: {name: 'projection'}, transform: [{filter: "abs(datum.step) <= 3"}], encoding: { x: {field: 'step'}, y: {field: 'value', type:'quantitative', scale: {zero:false}}, }, layer: [ { mark: {type: 'line', size: 5, tooltip:true, opacity:0.5}, encoding: {color: {field: 'sens', legend:null}} }, { transform: [ { "window": [{"op": "rank", "as": "rank"}], "sort": [{"field": "value", "order": "descending"}], "groupby": ["sens"] }, { "window": [{"op": "rank", "as": "rankAll"}], "sort": [{"field": "value", "order": "descending"}], }, {"filter": "datum.rank == 1"} ], "mark": { "type": "text", "tooltip": true, "limit": 200, "align": "right", "dx": -10,strokeWidth:2, "fontStyle": {"expr": "datum.rankAll % 2 == 1 ? 'bold' : ''"} }, encoding: {text: {field:'annotation'},color: {field: 'sens', legend:null} } }, { //transform: [{filter: "datum.sens=='empee_contribution_rate_in'"}], mark: {type: 'point', point: true, size: 100, tooltip:true, opacity:0.5}, encoding: {color: {field: 'sens', legend:null},fill: {field: 'sens', legend:null}} } ], width: 500, height:500, datasets: {projection: [...sensitivity_data]} })33:T50b,data_part_2b = { // nonCursor c-ps (made in a loop over inputs (excluding the multi one): should be more efficient?) var cpObj = Object.assign(Object({}), cursor); delete cpObj.multi; //delete cpObj.function$ //cpObj[cursor.multi] = cursor[cursor.multi]; //cpObj.function$ = function_inputs_cp_restricted[function_inputs_cp_restricted.length-1].function$ var out = [] for (const i in cpObj) { // must be inputs for fn only (not others) if (formula_inputs.some(d => d==i)) { var cpObj2 = Object.assign({}, cursor);; delete cpObj2.multi; cpObj2.function$ = [model[formula_select1]] //function_inputs_cp_restricted[function_inputs_cp_restricted.length-1].function$ cpObj2[i] = nonCursor[i]//domains[i] var arr2 = [] for (const j in cpObj2) /*if (j != 'function$')*/ arr2.push({[j]:cpObj2[j]}); //return arr2 if (i != cursor.multi) out[out.length] = cartesianProduct(arr2).map(({function$, ...d}) => ({...d, function:formula_select1, value: function$(d)})) //out.push(cartesianProduct(arr2).map(({function$, ...d}) => ({...d, function:formula_select, value: function$(d)}))); } } //return cpArr return out; //return cartesianProduct(cpArr).map(({function$, ...d}) => ({...d, function:formula_select, value: function$(d)})) }34:Tb9f,// copied 30/3/22 function facet2_custom(inputs, functions) { // this facet does a hconcat and a vconcat, where above the replication by function along rows follows depending on the data, in this case we need to include specific code for each one! (hence why they are input as an array) // TODO show titles. future: use diagram // Problem with gender selection/filters? - isNaN not the correct function here!! custom isundefined function? var s = `{ "$schema": "https://vega.github.io/schema/vega-lite/v${5}.json", "description": "description TODO", "data": {"values": []}, "transform": [], "vconcat": [`; var input, fn; var other_inputs, filters = '', details = ''; // hconcat on inputs for (var i = 0; i < inputs.length; i++) { input = inputs[i]; other_inputs = inputs.slice(); other_inputs.splice(i,1); filters = ''; other_inputs.forEach((d) => (filters += `{ "filter": { "or": ["isNaN(datum.${d})", { "selection": "selection_${d}" } ]}},`)); filters = filters.slice(0,-1); details = ''; other_inputs.forEach((d) => (details += `{"field": "${d}", "type": "nominal"},`)); details = details.slice(0,-1); //console.log(JSON.stringify({other_inputs, filters, details})) //s += `{ // "hconcat": [` // vconcat on functions for (var j = 0; j < functions.length; j++) { fn = functions[j]; s += ` { "width":300, "height":30, "resolve": {"scale": {"y": "independent"}}, "layer": [{ "selection": { "selection_${input}": {"type": "multi", "encodings": ["x"]} }, "mark": "bar", "transform": [{"filter": {"field": "function", "equal": "${fn}"}}, ${filters} ], "encoding": { "x": { "field": "${input}", "type": "ordinal" }, "y": { "aggregate": "sum", "field": "value", "type": "quantitative" }, "color": { "condition":{ "selection": "selection_${input}", "value": "red" }, "value":"blue" } }},{ "mark": "line", "transform": [{"filter": {"field": "function", "equal": "${fn}"}}, ${filters} ], "encoding": { "detail":[ ${details} ], "x": { "field": "${input}", "type": "ordinal" }, "y": { "field": "value", "type": "quantitative" }, "color": { "condition":{ "selection": "selection_${input}", "value": "purple" }, "value":"green" } } }] },` } s = s.slice(0,-1); s += ','//']},' } s = s.slice(0,-1); s += ']}' return s; }35:T527,data_new_sensitivities = { // nonCursor c-ps (made in a loop over inputs (excluding the multi one): should be more efficient?) var cpObj = Object.assign(Object({}), cursor); delete cpObj.multi; //delete cpObj.function$ //cpObj[cursor.multi] = cursor[cursor.multi]; //cpObj.function$ = function_inputs_cp_restricted[function_inputs_cp_restricted.length-1].function$ var out = [] for (const i in cpObj) { // must be inputs for fn only (not others) if (formula_inputs.some(d => d==i)) { var cpObj2 = Object.assign({}, cursor);; delete cpObj2.multi; cpObj2.function$ = [model[formula_select1]] //function_inputs_cp_restricted[function_inputs_cp_restricted.length-1].function$ cpObj2[i] = nonCursorSensitivities[i]//domains[i] var arr2 = [] for (const j in cpObj2) /*if (j != 'function$')*/ arr2.push({[j]:cpObj2[j]}); //return arr2 if (1 || i != cursor.multi) out[out.length] = cartesianProduct(arr2).map(({function$, ...d}) => ({...d, function:formula_select1, value: function$(d)})) //out.push(cartesianProduct(arr2).map(({function$, ...d}) => ({...d, function:formula_select, value: function$(d)}))); } } //return cpArr return out; //return cartesianProduct(cpArr).map(({function$, ...d}) => ({...d, function:formula_select, value: function$(d)})) }36:Tf75,viewof viz_spec = { // DN: transferrable const rows = ["formula","value"/*,"field 🔓"*/,...formulae_info_inputs,""]; const cols = ["x","y","color","row","col","text","detail","size"/*, "field 🔓"*/] const t = html`fieldmin# stepssizecursortypeformat${cols.map(c => `${c}`).join('')} ${rows.map(r => `${r}${ r.substr(-3) == '_in' ? `` : ``}${ r != "" ? `` : ``}${cols.map(c => ``).join('')}`).join('\n')} independent scale?${cols.map(c => ``).join('')} ` // todo zero scale const el = html`${t}

`//ffAB` let up = () => { const mins = el.querySelectorAll(`input[class="mins"]`) mins.forEach(d => {d.disabled = false}) var o = {cursor:{}, independent_scales:{}, types:{},formats:{},encodings:{"x":"","y":"formula","color":"formula","row":"","text":"value","detail":"","size":"","field 🔓":""}}; cols.forEach(c => { var s = el.querySelector(`input[name="${c}"]:checked`) o.encodings[c] = s ? s.value : ''; if (s.value && s.value != 'formula' && s.value != 'value') { el.querySelector(`input[id="${s.value}_min"]`).disabled = true } s = el.querySelector(`input[id="independent_scale_${c}"]`) o.independent_scales[c] = s.checked }) rows.filter(r => r.substr(-3) == "_in").forEach(r => { var s = el.querySelector(`input[id="cursor_${r}"]`); o.cursor[r] = s.value == '' ? undefined : +s.value; //o.types[r] = el.querySelector(`select[id="type_${r}"]`).value }) rows.filter(r => r != "").forEach(r => { //var s = el.querySelector(`input[id="cursor_${r}"]`); //o.cursor[r] = +s.value; o.types[r] = el.querySelector(`select[id="type_${r}"]`).value o.formats[r] = el.querySelector(`input[id="format_${r}"]`).value }) //var s = el.querySelector('input[name="x"]:checked') el.value = o//s ? s.value : '' el.dispatchEvent(new Event("input", {bubbles: true})); } //el.on el.onchange = up; // this is for configuring the default viz spec el.querySelector(`input[id="y_formula"]`).checked = true; el.querySelector(`input[id="color_formula"]`).checked = true; el.querySelector(`input[id="text_value"]`).checked = true; (el).dispatchEvent(new Event("input", {bubbles: true})) up() //el.onload = up; //el.querySelector(`input[id="x_formula"]`).checked = true; //el.getElementById("formula_x").checked = true; //el.dispatchEvent(new Event("input", {bubbles: true})); return el; }37:T988,vega_interactive = { // credit to Mike Bostock (starting point): https://observablehq.com/@mbostock/hello-vega-embed const v = window.vega = await require("vega"); const vl = window.vl = await require("vega-lite"); const ve = await require("vega-embed"); async function vega(spec, options) { const div = document.createElement("div"); div.value = (await ve(div, spec, options)).view; div.value.addEventListener('mousemove', (event, item) => { //console.log(item); if (item.datum != undefined && item.datum.formula != undefined) { viewof formula_select.value = item.datum.formula; viewof formula_select.dispatchEvent(new CustomEvent("input")) } }) div.value.addEventListener('click', (event, item) => { console.log(item.datum); /*viewof formula_select.value = item.datum.formula; viewof formula_select.dispatchEvent(new CustomEvent("input")); viewof month_select.value = item.datum.month_in; viewof month_select.dispatchEvent(new CustomEvent("input"));*/ //if (item.datum.age_0_in != undefined) {viewof inputs.value = {...viewof inputs.value, age_0_in:item.datum.age_0_in}; //cursor.month_in.push(item.datum.month_in); //viewof inputs.dispatchEvent(new CustomEvent("input"))}; // if (item.datum.age_in != undefined) {viewof inputs.value = {...viewof inputs.value, age_in:item.datum.age_in}; //cursor.month_in.push(item.datum.month_in); //viewof inputs.dispatchEvent(new CustomEvent("input"))}; viewof inputs.value = { ...viewof inputs.value, ...item.datum }; viewof inputs.dispatchEvent(new CustomEvent("input")) viewof formula_select.value = item.datum.formula; viewof formula_select.dispatchEvent(new CustomEvent("input")) //y.value.insert('selection_age_0_in_store', [{unit: "concat_1_layer_0", fields: [{"field":"age_0_in","channel":"x","type":"E"}] , values:[10]}]) //y.value.insert('selection_dampener_in_store', [{unit: "concat_2_concat_2_layer_0", fields: [{"field":"dampener_in","channel":"x","type":"E"}] , values:[0.95]}]) //.run() // NOW TODO addSignalListener stuff... is it trigerred for above?? // until there is a selection api... //https://github.com/vega/vega-lite/issues/2790#issuecomment-976633121 // https://github.com/vega/vega-lite/issues/1830#issuecomment-926138326 }) // DN return div; } vega.changeset = v.changeset; return vega; }38:[] 30:{"id":"ea835cdc5d19cb9a","slug":"calculang-tools-bad","title":"calculang tools ✨ (bad/drafty version)","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-01-10T20:03:38.230Z","update_time":"$D2023-11-08T03:51:00.078Z","view_time":null,"first_public_time":"$D2023-04-04T15:15:56.639Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"fa28dcfb9c2f53ce","login":"declann","name":"Declan Naughton","avatar_url":"https://avatars-next.observableusercontent.com/b36edfd0f90184ac4c0a8d8726969fe861a1d1fe9417e998413c8a47e6163983","tier":"starter_2024","bio":"👨‍💻 Modelling consultant\n🧮 numbers 📊 actuarial\n\n📈 viz, interactivity, transparency"},"version":1981,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"fca367047a53a31f","login":"declann","name":"Declan Naughton","avatar_url":"https://avatars-next.observableusercontent.com/b36edfd0f90184ac4c0a8d8726969fe861a1d1fe9417e998413c8a47e6163983","tier":null,"bio":"👨‍💻 Modelling consultant\n🧮 numbers 📊 actuarial\n\n📈 viz, interactivity, transparency"}],"members":[{"type":"individual","id":"fca367047a53a31f","login":"declann","name":"Declan Naughton","avatar_url":"https://avatars-next.observableusercontent.com/b36edfd0f90184ac4c0a8d8726969fe861a1d1fe9417e998413c8a47e6163983","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"52257843b4995dd1","slug":"calculang-wip","title":"calculang-wip","owner":{"id":"fa28dcfb9c2f53ce","login":"declann","name":"Declan Naughton"}},"type":"notebook","body":{"titling":"auto","title":"calculang tools ✨ (bad/drafty version)","cells":[{"id":0,"value":"# calculang tools ✨ (bad/drafty version)\n\nDrafty tools which I will release in other places (individually and cleaner) in weeks ahead.\n\nThis is a notebook where I mess about and I thought about integrating things which works but in a messy way.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1968,"value":"ref=\"3e313\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":395,"value":"// info for the available formulae (not every formula)\nformulae_info = Object.keys(model).map(d => Object.values(introspection.cul_functions).find(e => e.name == d && e.cul_scope_id == 0)).filter(d => d != undefined)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":420,"value":"formulae_info_inputs = {\n var inputs = [];\n formulae_info.forEach(d => {\n inputs.push(d.inputs)\n })\n return [...new Set(inputs.flat())] //Object.keys(inputs);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"// age_in,20,70,10,30,60,10\ninput_domains_config = d3.csvParse(\n`input,min,max,step,default0,default1,step_sens\nage_in,20,25,1,22,22,1\nage_0_in,20,50,5,25,40,5\nsalary_0_in,10000,200000,100,50000,100000,30000\nsalary_inflation_rate_in,-0.05,0.10,0.01,0.05,0.04,0.03\nempee_contribution_rate_in,0.00,0.30,0.01,0.05,0.1,0.05\nunit_growth_rate_in,-0.02,0.10,0.01,0.05,0.05,0.02\nretirement_age_in,25,90,1,66,60,5\nfund_value_0_in,0,300000,1000,0,100000,50000\nannual_salary_in,0,1000000,1000,50000,50000,50000\naddl_credit_in,0,1,1,0,0,1\nnum_bars_in,0,20,1,10,10,5\ncontainer_height$_in,0,600,1,500,500,100\ntop_margin$_in,0,20,1,10,10,5\nbottom_margin$_in,0,20,1,10,10,5\ngap$_in,0,20,1,10,10,15\nbar_height$_in,0,50,1,25,25,5\nrec_step_in,0,10,1,0,0,1\nage_opening_in,20,25,1,20,20,1\nage_closing_in,20,25,1,21,21,1\n`, d => ({...d, min:+d.min,max:+d.max,step:+d.step_sens,default:+d.default}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":785,"value":"### *inputs:*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1056,"value":"domains_ = ({\n age_in: [60,61,62],\n age_0_in:[30,40,60,61,62], // one with multi allowed in cursor\n fund_value_0_in: [/*inputs.fund_value_0_in*/0,25000,50000,75000,100000],\n unit_growth_rate_in:[-0.01,0,0.05,0.06,0.07],\n retirement_age_in:[inputs.retirement_age_in],\n annual_salary_0_in:[inputs.annual_salary_0_in],\n salary_inflation_rate_in:[inputs.salary_inflation_rate_in-0.01,inputs.salary_inflation_rate_in,inputs.salary_inflation_rate_in+0.01],\n empee_contribution_rate_in:[inputs.empee_contribution_rate_in]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1184,"value":"domains = {\n var o = {};\n for (var i in input_domains_config) {\n var d = input_domains_config[i];\n o[d.input] = _.range(d.min, d.max, d.step).map(d => +d.toFixed(2))// input_domains_config[i];\n };\n return o\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1137,"value":"inputs","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1143,"value":"{\n formula_inputs.forEach((d, i) => {\n y.value.insert(`selection_${d}_store`, [{unit: `concat_${i}_layer_0`, fields: [{\"field\":d,\"channel\":\"x\",\"type\":\"E\"}]\t\t, values:[viewof inputs.value[d]]}]).run(); // this is a lot of run calls !\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1118,"value":"/*{y.value.insert('selection_age_0_in_store', [{unit: \"concat_1_layer_0\", fields: [{\"field\":\"age_0_in\",\"channel\":\"x\",\"type\":\"E\"}]\t\t, values:[viewof inputs.value.age_0_in]}]);\n y.value.insert('selection_age_in_store', [{unit: \"concat_0_layer_0\", fields: [{\"field\":\"age_in\",\"channel\":\"x\",\"type\":\"E\"}]\t\t, values:[viewof inputs.value.age_in]}]);\n y.value.insert('selection_salary_inflation_rate_in_store', [{unit: \"concat_3_layer_0\", fields: [{\"field\":\"salary_inflation_rate_in\",\"channel\":\"x\",\"type\":\"E\"}]\t\t, values:[viewof inputs.value.salary_inflation_rate_in]}])\n \n//w.value.insert('selection_dampener_in_store', [{unit: \"concat_2_concat_2_layer_0\", fields: [{\"field\":\"dampener_in\",\"channel\":\"x\",\"type\":\"E\"}]\t, values:[0.95]}])\n \n .run()}*/","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1078,"value":"//formula_select1 = \"annual_salary\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1650,"value":"ooo = {\n var o = {}\n formulae_info_inputs.forEach(d => {\n o[d] = [inputs[d]]\n })\n return o\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1051,"value":"cursor = Object({\n multi: formula_inputs[0],//'age_0_in',\n ...ooo\n /*age_in: [inputs.age_in], //\n age_0_in:[inputs.age_0_in], // one with multi allowed in cursor\n fund_value_0_in: [inputs.fund_value_0_in],\n unit_growth_rate_in:[inputs.unit_growth_rate_in],\n retirement_age_in:[inputs.retirement_age_in],\n annual_salary_0_in:[inputs.annual_salary_0_in],\n salary_inflation_rate_in:[inputs.salary_inflation_rate_in],\n empee_contribution_rate_in:[inputs.empee_contribution_rate_in]*/\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1393,"value":"[10,20].indexOf(20)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1398,"value":"domains['age_in'].find(d => d == 60)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1388,"value":"cursorStepIndex = {\n var o = {}\n //o.age_in = domains['age_in'].find(d => d == cursor['age_in'][0])\n o.age_in = domains['age_in'].indexOf(cursor['age_in'][0])\n return o;\n}\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1642,"value":"introspection.cul_functions","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1634,"value":"formulae_info","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1155,"value":"viewof formula_select1 = Inputs.select(/*[\"annual_premium\", \"annual_salary\", \"fund_value\", \"projected_fund_value\"]*/formulae_info.map(d => d.name), {label: \"Select one\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1680,"value":"viewof use_cursor_from_table = Inputs.checkbox([\"?\"], {label: \"use_cursor_from_table\", value: [\"?\"]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1174,"value":"has bug fixes vs orig\n\ncan do this for every formula at once if repeat X/col works with layers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":438,"value":"viewof inputs = {\n var obj = {};\n //obj['age_in'] = Inputs.range([inputs.age_0_in-1, inputs.retirement_age_in], {step: 1, label:'age'});\n formulae_info_inputs/*.filter(d => d != pvt_y)*/.forEach(d => {\n //var rate = d.indexOf(\"rate\") != -1\n var config = input_domains_config.find(e => e.input == d)\n obj[d] = Inputs.range([config.min, config.max], {step: config.step_sens, label: d.substr(0,d.length-3), value: config.default1})\n obj[d].onchange = () => {console.log('changed hi')}\n })\n return Inputs.form(obj)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1771,"value":"this will be an interactive way to browse a model, difficulty is in the mix of super- vs. subtly sensitive params","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1560,"value":"// thx to https://observablehq.com/@sachina/calendar-view-horizontal-scrolling\nv = html`\n

${x}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1315,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1695,"value":"sensitivity_data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1736,"value":"vega({ //make this useindept xscales optional.. example to do: how much sales to make to compensate for lower prices?\n data: {name: 'projection'},\n mark: {type: 'bar', tooltip:true},\n \"resolve\": {\"scale\": {\"y\": \"independent\"}},\n encoding: {\n x: {field: 'step'},\n y: {field: 'value', type:'quantitative'},\n detail: {field: 'sens'},\n //detail: {expr: 'datum[datum.sens]'},\n color: { condition: { test: \"datum.step == 0\", value: 'brown'}},\n row: {field: 'sens'},\n },\n width: 500,\n height:50,\n datasets: {projection: [...sensitivity_data]}\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1465,"value":"vega({\n data: {name: 'projection'},\n \"resolve\": {\"scale\": {\"x\": \"independent\"}},\n\n repeat: {layer: formula_inputs/*, row:[\"value\", \"v2\"] breaks independent x scale*/},//[\"age_in\", \"age_0_in\"]},//formula_inputs,\n spec: {\n mark: {type: 'line', tooltip:true},\n encoding: {\n //x: {field: 'step'}, \n\n x: { field: { repeat: 'layer', type:'quantitative' , scale: {range:[-1,1]}}}, // will work if I move to offsets from cursor. Configurable step size and annotation step, done?? Still needs domain limits\n //y: {field: {repeat:'l2'}, type:'quantitative'},//'value', type:'quantitative'},\n y: {field:'value', type:'quantitative'},\n detail: {field: 'sens'},\n //detail: {expr: 'datum[datum.sens]'},\n color: { field:'sens'},\n //color: { condition: { test: \"datum.step == 0\", value: 'brown'}},\n //row: {field: 'sens'},\n }},\n width: 500,\n height:500,\n datasets: {projection: [...sensitivity_data]}\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"y = { var spec_1 = Object.assign({}, JSON.parse(facet2_custom(formula_inputs,[formula_select1]))); spec_1.data = {values: [...data_part_1,...data_part_2b.flat()]}; // needed to init correctly, because of..?\n spec_1.width = 200;\n return vega_interactive(spec_1, { renderer: 'svg' })}\n// I don't want the same event handlers here!!!","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1035,"value":"### put model explorer here: simple version\n\n=> can tweet \"pension calculator includes a model explorer, using sensitivities\" relate to m bostock rent-or-buy","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1066,"value":"nonCursor = {\n var out = {}\n for (const f in domains) {\n if (cursor[f] != undefined && f != 'range' && formula_inputs.some(d => d == f))\n out[f] = domains[f].filter(d => cursor[f].indexOf(d) == -1)\n }\n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1070,"value":"data_part_1 = { // all of multi domain, against cursor-only of e/t else\n var cpObj = Object.assign(Object({}), cursor); delete cpObj.multi\n cpObj[cursor.multi] = domains[cursor.multi];\n cpObj.function$ = [model[formula_select1]] //function_inputs_cp_restricted[function_inputs_cp_restricted.length-1].function$\n var cpArr = []\n for (const i in cpObj)\n cpArr.push({[i]:cpObj[i]})\n //return cpArr\nreturn cartesianProduct(cpArr).map(({function$, ...d}) => ({...d, function:formula_select1, value: function$(d)}))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1087,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1090,"value":"// using cul_functions rather than cul_input_map because of lack scope id dependence in cul_input_map (this needs to improve!)\nformula_inputs = Object.values(introspection.cul_functions).find(d => d.name == formula_select1).inputs","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1092,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":965,"value":"cul_formula_loc = introspection.cul_functions['0_'+formula_select].loc","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":981,"value":"cs = (code_opt_fv.indexOf(\"source\") != -1 ? calcuin_fv : calcuout).split('\\n')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1370,"value":"domainsWithStepOffsets = {\n var o = {}\n formulae_info_inputs.forEach(f => {\n var c = cursor[f][0];\n o[f] = domains[f].map((d,i) => ({step:i-domainsSteps[f].find(e => e.v==c).step,value:d}))\n })\n return o\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1379,"value":"domainsSteps = {\n var o = {};\n for (var i in input_domains_config) {\n var d = input_domains_config[i];\n o[d.input] = _.range(d.min, d.max, d.step).map((d, i) => ({v:+d.toFixed(2),step:i}))// input_domains_config[i];\n };\n return o\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1354,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1419,"value":"### ~~lets do the sensitivity thing~","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1422,"value":"cursor","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1425,"value":"formulae_info_inputs","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1427,"value":"domains","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1417,"value":"sensitivity_data = {\n var o = []\n var c = {}\n formulae_info_inputs.forEach(i => {\n c[i] = cursor[i][0]\n })\n formulae_info_inputs.forEach(i => {\n domains[i].forEach(v => {\n o.push(Object.assign({...c}, {[i]:v, step:domainsWithStepOffsets[i].find(g => g.value == v).step, sens:i, annotation: [i,`${domainsWithStepOffsets[i].find(g => g.value == v).step >= 0 ? '+' : '-'}= ${Math.abs(domainsWithStepOffsets[i].find(g => g.value == v).step)* input_domains_config.find(d => d.input == i).step}`]}))\n })\n })\n return o.map(d => ({...d, formula: formula_select1, value: model[formula_select1](d), v2: model[formula_select1](d)}))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1507,"value":"input_domains_config","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1358,"value":"nonCursorSensitivities = {\n var out = {}\n for (const f in domains) {\n if (cursor[f] != undefined && f != 'range' && formula_inputs.some(d => d == f))\n out[f] = domains[f]//.filter(d => cursor[f].indexOf(d) == -1)\n }\n return out\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1368,"value":"data_new_sensitivities.flat().map(d => {\n var step = 0\n formulae_info_inputs.forEach(f => {\n if (d[f] != cursor[f][0]) {\n step = domainsWithStepOffsets[f].find(g => g.value == d[f]).step\n return;\n }\n //domains[f].map((d,i) => ({step:i-domainsSteps[f].find(e => e.v==c).step,value:d}))\n })\n return {...d, step}\n}\n) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1640,"value":"formulae_info","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1834,"value":"*download data cell broken*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":816,"value":"DOM.download(serialize(projection), null, \"csv download\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1884,"value":"viewof selected_formulae = Inputs.select(formulae_info.map(d=>d.name), {label: \"formulae\", multiple: true, value:[\"age\", \"fund_value\"]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1894,"value":"selected_formulae","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1809,"value":"nocode_viz_tag = ''","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1806,"value":"# Nocode viz","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":351,"value":"viewof model_path1 = Inputs.select(new Map([[\"Pensions Calculator 💵🧓🤟\", \"/models/pensions/pension-calculator\"],[\"Pensions Reccer (broke, ex-working) 💵🧓🤟\", \"/models/pensions/rec\"],[\"Pensions Reccer (NEW) 💵🧓🤟\", \"/models/pensions/rec-exec\"]]), {label: \"model\", value: q.get('rec') ? \"/models/pensions/rec-exec\" : \"/models/pensions/pension-calculator\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1283,"value":"viewof mark = Inputs.select([\"?\", \"bar\", \"line\", \"point\",\"text\",\"rect\"], {label: \"mark\", value:\"text\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1285,"value":"viewof height = Inputs.range([0, 1000], {label: \"height\", step: 50, value:400})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1812,"value":"## example nocode tweak: set x to age_in, value to Q type and 's' format to make it cleaner, cycle other inputs on x by keyboarding down/up\n\nPros and cons to this UI layout, but I like it for mow, it shows the space of what I can viz from a model. The viz doesn't react to all the UI yet. It does react to cursor and the radios, mark and height.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1238,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1432,"value":"vega_interactive(c_spec1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1962,"value":"model.rec_order","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":951,"value":"### *formula viewer:*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1935,"value":"viewof code_opt_fv = Inputs.select([\"📝 calculang source 💬\", \"✨ calculang output ✨ for 🖥️\"], {label: \"🧙 via 🌲s\", value: \"📝 calculang source 💬\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":972,"value":"viewof formula_select = Inputs.select(/*[\"1_unit_balance_\", \"1_annual_salary_\", \"1_unit_allocation_\", \"0_unit_balance\", \"0_annual_salary\", \"0_unit_allocation\"]*/Object.entries(introspection.cul_functions).filter(([a,b]) => b.reason == 'definition').map(([a,b]) => b.name), {label: \"formula\", value:\"unit_balance\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":985,"value":"md`\n-\n~~~js\n${cs.filter((d, i) => i >= cul_formula_loc.start.line-1 && i < cul_formula_loc.end.line).join('\\n')}\n~~~\n-\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1837,"value":"mapped_inputs","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1785,"value":"viewof viz_spec.querySelector(`input[id=\"y_formula\"]`).checked = true;","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1798,"value":"viewof viz_spec.querySelector(`input[id=\"color_formula\"]`).checked = true;\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1800,"value":"viewof viz_spec.querySelector(`input[id=\"text_value\"]`).checked = true;\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1267,"value":"mapped_inputs = Object.entries(viz_spec.encodings).map(d => d[1]).filter(d => d.substr(-3) == \"_in\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1269,"value":"viz_spec","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"// anything mapped to an enconding should go here\n\ninput_domains_A_overrides = {\n var o = {}\n mapped_inputs.forEach(i => {\n o[i] = domains[i]\n })\n return o\n}\n\n/*input_domains_A_overrides = model_path.indexOf('pensions') != -1 ? ({\n [pvt_y]: domains[pvt_y]\n //age_in: _.range(inputs.age_0_in-1, inputs.retirement_age_in+3),\n //\n}) : ({t_in: _.range(0,12).map(m => new Date(2014,m,1))})*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1663,"value":"inputs","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1670,"value":"viz_spec.cursor","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1683,"value":"use_cursor_from_table","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1685,"value":"input_domains_A_new = use_cursor_from_table.length ? input_domains_A_projection : input_domains_A","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":599,"value":"input_domains_A = {\n var o = {}\n Object.entries(inputs).forEach(([k,v]) => {\n o[k] = [v]\n })\n Object.entries(input_domains_A_overrides).forEach(([k,v]) => {\n o[k] = v\n })\n //o.formula = Object.values(model)\n return o\n}\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1667,"value":"input_domains_A_projection = {\n var o = {}\n Object.entries(viz_spec.cursor).forEach(([k,v]) => {\n o[k] = [v]\n })\n Object.entries(input_domains_A_overrides).forEach(([k,v]) => {\n o[k] = v\n })\n //o.formula = Object.values(model)\n return o\n}\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":627,"value":"input_combos_A = cartesianProduct(Object.entries(input_domains_A_new).map(([k,v]) => ({[k]: v})))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1673,"value":"input_combos_A_projection = cartesianProduct(Object.entries(input_domains_A_projection).map(([k,v]) => ({[k]: v})))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":640,"value":"// age_in bit here not done programmatically ! just use all combos?\nprojection = formulae_info.filter(d => formulae_info_inputs.indexOf(d.name+'_in') == -1).map(({name}) => input_combos_A_projection.map(combos => ({...combos,/*[pvt_y]: combos[pvt_y],*/ formula:name, /*[name]*/value: +model[name](combos)/*.toFixed(2)*/}))).flat()\n// pre-folded!","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":836,"value":"links = Object.entries(introspection.cul_scope_ids_to_resource).filter(([cul_scope_id]) => cul_scope_id != 0).map(([cul_scope_id, resource]) => new URLSearchParams(resource.split('?').pop()).get('cul_scope_id') + ' -> ' + new URLSearchParams(resource).get('cul_parent_scope_id'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":835,"value":"nodes = Object.entries(introspection.cul_scope_ids_to_resource).map(d => (`${d[0]} [${ d[0] == 0 ? 'color=\"green\" style=\"filled\" ' : 'color=\"yellow\" style=\"filled\" '}label=\"[${d[0]}]: ${qs.length ? d[1] : d[1].split('?')[0]}\"]`))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":834,"value":"d = `digraph {\nrankdir=\"RL\"\nnode [shape=\"box\"];\n${nodes.join('\\n')}\n${links.join('\\n')}\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"## the calculang:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1632,"value":"model_path = /*q.get('path') ??*/ model_path1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"model = require(URL.createObjectURL(new Blob([b64_to_utf8(module_response.data.content)], { type: \"text/javascript\" })))\n //require(`https://cdn.jsdelivr.net/gh/${location1}@${sha}/${location2}.js?v=${version}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"viewof code_opt = Inputs.select([\"📝 calculang source 💬\", \"✨ calculang output ✨ for 🖥️\", \"🌲 calculang internal 🌲 for 🖥️\"], {label: \"🧙 via 🌲s\", value: \"📝 calculang source 💬\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":936,"value":"*Note: if memoisation is turned on, additional memo scopes are generated which **aren't actual source code**.* (strictly what \"calculang source\" is looking at is calculang transformation input)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":831,"value":"### *scope id graph:*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":830,"value":"viewof qs = Inputs.checkbox([\"show query string?\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":829,"value":"dot`${d}` // should make this interactive, but also consider indented tree?","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"viewof cul_scope_id = Inputs.radio(_.range(0,Object.keys(introspection.cul_scope_ids_to_resource).length), {label: \"cul_scope_id\", value: 0 /*maybe nice to default to last one instead?*/})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"cv = { \n //return md`\n//### source turned off`\n if (code_opt.indexOf(\"🌲\") != -1) return dot`${introspection.dot}`;\n else\n return md`\n~~~js\n${code_opt.indexOf(\"source\") != -1 ? calcuin : calcuout}\n~~~\n` }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"## appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":36,"value":"### calculang plugs","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1622,"value":"//q = ({get:() => (undefined)})// OFF for publish. new URLSearchParams(location.search)\nq = new URLSearchParams(location.search)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"viewof version = Inputs.button(\"refresh calculang model\", {}) // I think need a session id, because common version numbers means I can hit old cached responses between sessions\n\n// octokit: this is redundant if I change model_path","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"owner = \"declann\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"//repo = q.get('repo') ?? \"calculang-miscellaneous-models\"\nrepo = \"calculang-miscellaneous-models\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"module_response = await octokit.request('GET /repos/{owner}/{repo}/contents/{model_path}.js?ref={ref}', {\n owner, repo, model_path, ref\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"sourcemap_response = await octokit.request('GET /repos/{owner}/{repo}/contents/{model_path}.js.map', {\n owner, repo, model_path\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"sourcemap = JSON.parse(b64_to_utf8(sourcemap_response.data.content))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":916,"value":"calcuin_response = await octokit.request('GET /repos/{owner}/{repo}/contents/{model_path}-nomemo_esm/cul_scope_{cul_scope_id}.cul.js?ref={ref}', {\n owner, repo, model_path, cul_scope_id, ref\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1012,"value":"calcuin_response_fv = await octokit.request('GET /repos/{owner}/{repo}/contents/{model_path}-nomemo_esm/cul_scope_{cul_scope_id}.cul.js?ref={ref}', {\n owner, repo, model_path, cul_scope_id: 0, ref // won't work for scope > 9\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":918,"value":"calcuin = b64_to_utf8(calcuin_response.data.content)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1017,"value":"calcuin_fv = b64_to_utf8(calcuin_response_fv.data.content)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"calcuout_response = await octokit.request('GET /repos/{owner}/{repo}/contents/{model_path}-nomemo_esm/cul_scope_{cul_scope_id}.mjs?ref={ref}', {\n owner, repo, model_path, cul_scope_id, ref\n})\n \n//fetch(`https://cdn.jsdelivr.net/gh/${location1}@${sha}/${location2}_verbose/0.js?v=${version}`).then(response => response.text())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"calcuout = b64_to_utf8(calcuout_response.data.content)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"introspection_response = await octokit.request('GET /repos/{owner}/{repo}/contents/{model_path}-nomemo.introspection.json?ref={ref}', {\n owner, repo, model_path, ref\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"introspection = JSON.parse(b64_to_utf8(introspection_response.data.content))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"// https://developer.mozilla.org/en-US/docs/Glossary/Base64#the_unicode_problem\nfunction b64_to_utf8( str ) {\n return decodeURIComponent(escape(window.atob( str )));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"octokit_constructor = (await import('https://cdn.skypack.dev/@octokit/rest@16')).default","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":229,"value":"octokit = new octokit_constructor({})//auth: 'public'/*Secret(\"GITHUB_ACCESS_TOKEN\")*/, version});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":618,"value":"// https://stackoverflow.com/questions/18957972/cartesian-product-of-objects-in-javascript\n\nfunction copy(obj) {\n var res = {};\n for (var p in obj) res[p] = obj[p];\n return res;\n }\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":616,"value":"// https://stackoverflow.com/questions/18957972/cartesian-product-of-objects-in-javascript\nfunction cartesianProduct(input, current) {\n if (!input || !input.length) { return []; }\n \n var head = input[0];\n var tail = input.slice(1);\n var output = [];\n \n for (var key in head) {\n for (var i = 0; i < head[key].length; i++) {\n var newCurrent = copy(current); \n newCurrent[key] = head[key][i];\n if (tail.length) {\n var productOfTail = \n cartesianProduct(tail, newCurrent);\n output = output.concat(productOfTail);\n } else output.push(newCurrent);\n }\n } \n return output;\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1103,"value":"$37","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":657,"value":"vega = { // credit to Mike Bostock: https://observablehq.com/@mbostock/hello-vega-embed\n const v = window.vega = await require(\"vega\");\n const vl = window.vl = await require(\"vega-lite\");\n const ve = await require(\"vega-embed\");\n async function vega(spec, options) {\n const div = document.createElement(\"div\");\n div.value = (await ve(div, spec, options)).view;\n div.value.addEventListener('click', (event, item) => { console.log(item.datum) }) // DN\n return div;\n }\n vega.changeset = v.changeset;\n return vega;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":814,"value":"import {serialize} from \"@palewire/saving-csv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1291,"value":"## compassql","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1294,"value":"cql = require(\"compassql\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1298,"value":"projection","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1296,"value":"schema = cql.schema.build(projection)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1307,"value":"encodings = Object.entries(viz_spec.encodings).filter(([k,v]) => v != '' && k != 'cursor' && k != 'independent_scales' && k != 'types' && k != 'formats').map(([k,v]) => ({channel:k,field:v,type:viz_spec.types[v],format:viz_spec.formats[v]}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1303,"value":"output = cql.recommend({\n spec: {data: projection,\n mark: mark == 'bar' ? 'line' : mark,\n //tooltip: true,\n encodings/*: [\n {\n channel: \"x\",\n //aggregate: \"mean\",\n field: x_channel,\n //type: \"quantitative\",\n },\n {\n channel: \"y\",\n field: y_channel,\n //type: \"quantitative\",\n },\n {\n channel: \"text\",\n field: text_channel,\n type: \"quantitative\",\n format: \"s\"\n },\n {\n channel: \"row\",\n field: row_channel,\n //type: \"quantitative\",\n //format: \"s\"\n },\n {\n channel: \"color\",\n field: color_channel\n }\n ]*/,\n },\n chooseBy: \"effectiveness\",\n}, schema);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1301,"value":"vlTree = cql.result.mapLeaves(output.result, function (item) {\n return item//.toSpec();\n});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1309,"value":"c_spec = vlTree.items[0].toSpec()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1311,"value":"c_spec1 = {\n var s = c_spec;\n s.data = {name: 'projection'};\n s.width = 600;\n s.height = height;\n s.datasets = {projection}\n var r = {}\n Object.entries(viz_spec.independent_scales).filter(([k,v]) => v == true).forEach(([k,v]) => { r[k] = 'independent' })\n s.resolve = {scale: r}\n if (mark == \"bar\") s.mark = \"bar\"; //{\"type\": \"bar\", \"tooltip\": true};\n var p = s.mark;\n s.mark = {type: p, tooltip:true}\n if (mark == \"line\") s.mark.point = true\n \n s[\"config\"] ={\"legend\": {\"disable\": true}}\n return s\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"## credits\n\nmade with 💖 and [calculang](https://github.com/calculang)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W38","stdlib":"1"}} 31:"$30:body"