2f:T5fe9,viewof viz = embed({ // todo //width, data: { values: cfs_impacts_static_arrow /*aq.from([ { point_id_in: 12, t_in: -34, zero_duration_in: false, mort_rate_factor_in: 1, model_id: 0, input_cursor_id: 0, formula: "pv_premiums", value: 0, t_in_step_end: -22, A_keep_gte_0: true, partition: "A", duration_mth: 0, duration_n: 0, value_n: 47.1075, t_in_mean: -28.5 } ])*/ }, height: 300, transform: [ { calculate: 'datum.formula == "pv_premiums" ? "Premiums" : (datum.formula == "pv_claims" ? "Claims" : (datum.formula == "pv_expenses" ? "Expenses" : (datum.formula == "pv_commissions" ? "Commissions" : "N/A")))', as: "formula" }, //{calculate: 'datum.value_n', as: 'value'}, { filter: "abs(datum.value)>0.0001" }, // or 1 or some responsive tol? /*{ calculate: "datum.partition == 'subtract' ? -datum.value : datum.value", as: "value" }, { calculate: "(datum.partition == 'subtract') ? -datum.value : datum.value", as: "value" },*/ /*{ calculate: 'datum.t_in+'+bin_size, as: 'bin_end' },*/ /*{ calculate: 'datum.value/' + bin_size, as: 'value' // versus use an aggregate mean? },*/ { calculate: "(datum.A_keep_gte_0 == false && datum.partition == 'subtract') ? -datum.value : datum.value", as: "value" } ], hconcat: [ { vconcat: [ { //title: 'amounts are AVERAGES PER MONTH', width: width - 70, encoding: {}, layer: [ // RECTS BREAKING ZOOM ON Y { mark: { type: "rect", clip: true }, // TODO find extents, or clip? (extents = SUM of CFs) data: { values: [{}] }, transform: [{}], encoding: { y: { datum: 0 }, // can't use datum: what scale? x: { value: 0 }, //y2:{datum:10}, //y2: {}, y2: { value: -1000 }, //y2: {value: {expr: "scale('concat_0_concat_0_y', 1000)"}}, x2: { value: "width" }, fill: { value: "lightgreen" }, opacity: { value: 0.2 } } }, { mark: { type: "rect", clip: true }, data: { values: [{}] }, encoding: { y: { datum: 0 }, // can't use datum: what scale? x: { value: 0 }, //y2: {value: {expr: "scale('concat_0_concat_0_y', -1000)"}}, y2: { value: 1000 }, x2: { value: "width" }, fill: { value: "orange" }, opacity: { value: 0.2 } } }, { mark: { type: "rule" }, data: { values: [{}] }, encoding: { y: { datum: 0 }, // for Q set to 0 (not string) size: { value: 0.2 }, // remove, unnecessary? color: { value: "gray" } //x: {datum:'51', type:'quantitative', scale:null} } }, { mark: { type: "rule", strokeDash: [10, 5] }, data: { values: [{}] }, encoding: { x: { datum: 0, scale: { zero: false, padding: 10, domain: /*[-10*12,23*12]}*/ { param: "brush", encoding: "x" }, nice: false } }, // for Q set to 0 (not string) size: { value: 1 } //x: {datum:'51', type:'quantitative', scale:null} } }, { transform: [ /* {"filter": {"param": "brush"}},*/ { filter: "datum.formula != 'profit' && (datum.partition == 'keep' || datum.partition == 'add' || datum.partition == 'subtract')" } ], params: [ { name: "grid", select: "interval", bind: "scales" }, { name: "cashflow", select: { type: "point", fields: ["formula"] }, bind: "legend" } ], mark: { type: "area", tooltip: false, interpolate: "step-after" }, encoding: { x: { field: "t_in", title: "t_in (month)", type: "quantitative", scale: { zero: false, padding: 10, domain: [-36, 18 * 12], nice: false }, axis: { values: [0, 60, 120, -60, -120, 180, 240, -180, -240] } }, y: { field: "value", type: "quantitative", scale: { domain: [-premiums * 1.5, premiums * 1.5 /*-10000,10000*/] }, axis: { grid: false, title: "amount", labelAngle: -90, values: [0, 100, -100] } /*, stack:'normalize'*/ }, //WHY IS LEGEND DOTS? color: { field: "formula", type: "nominal", scale: { domain: ["Premiums", "Claims", "Commissions", "Expenses"], range: [ "steelblue", "darkorange", "brown", "mediumvioletred" ] }, legend: { direction: "horizontal", orient: "top", strokeColor: "lightgray", rows: 1, title: "cashflows", padding: 3 } }, order: { field: "formula" /* also partition */, type: "nominal" }, // I want expenses @ bottom detail: { field: "partition" }, opacity: { value: 0.6, condition: { //test: 'datum.partition == "add" || datum.partition == "subtract"', param: "cashflow", value: 1 } }, strokeWidth: { value: 0, condition: { //test: 'datum.partition == "add" || datum.partition == "subtract"', param: "cashflow", empty: false, value: 0.5 * 2 * (bin_size <= 2 ? 0.5 : bin_size == 12 ? 1 : 0.5) // Scale down for bin size 1 month } }, stroke: { value: "darkgreen", condition: { test: 'datum.partition == "subtract"', value: "red" } } } }, { mark: { type: "rect", clip: true }, data: { values: [{}] }, encoding: { x: { datum: -10000 }, x2: { datum: 0 }, fill: { value: "purple" }, y: { value: -100 }, y2: { value: 1000 }, opacity: { value: 0.1 } } }, { transform: [ { calculate: "datum.t_in_mean", as: "t_in" }, /* {"filter": {"param": "brush"}*/ /* "slow" per docs vs scale-domain-param but also does extent fix */ { filter: "datum.partition == 'B' ||datum.partition == 'A' " }, // filter out unselected cashflows, for better y range? {filter: "datum.t_in "}, //sum?{calculate: 'datum.val'} //{"extent": "sum_value", "param": "b_extent"}// not using, can use in order to make a greedy selection? (pick one at edge of interval) (change above also) { calculate: "((datum.t_in_step_end-datum.t_in)*4)", as: "step_size" }, { aggregate: [ { // de-duplicate and use value_n op: "min", field: "value_n", as: "value_n" } ], groupby: [ /*"duration_n",*/ "t_in" /* has already become mean */, "partition", "formula" ] }, { aggregate: [ { op: "sum", field: "value_n", as: "sum_value" } ], groupby: [/*"duration_n",*/ "t_in", "partition"] }, { aggregate: [ { op: "mean", field: "sum_value", as: "sum_value" } ], groupby: [/*"duration_n",*/ "t_in", "partition"] } ], mark: { type: "line", tooltip: true, point: true }, encoding: { //opacity: {value: 0.8}, size: { field: "step_size", scale: null }, // make dept on step size? //fill: {value:'green', condition: {test: 'datum.sum_value<0', value: 'red'}}, strokeWidth: { value: 0.1 }, // remember: no grouping so many appeareances!! opacity: { field: "partition", type: "nominal", scale: { domain: ["A", "B"], range: [0.3, 0.8] }, legend: null }, color: { value: "black" }, x: { field: "t_in", type: "quantitative", scale: { zero: false, padding: 10, nice: false } }, y: { field: "sum_value", type: "quantitative" /*, scale: {domain:{param:'b_extent'}}*/ /*, stack:'normalize'*/ }, detail: { field: "partition" } //color: {field: 'formula', type:'nominal'}, } }, { transform: [ { calculate: "datum.t_in_mean", as: "t_in" }, /* {"filter": {"param": "brush"}*/ /* "slow" per docs vs scale-domain-param but also does extent fix */ { filter: "datum.partition == 'B' ||datum.partition == 'A' " }, // filter out unselected cashflows, for better y range? {filter: "datum.t_in "}, //sum?{calculate: 'datum.val'} //{"extent": "sum_value", "param": "b_extent"}// not using, can use in order to make a greedy selection? (pick one at edge of interval) (change above also) { calculate: "((datum.t_in_step_end-datum.t_in)*4)", as: "step_size" }, { aggregate: [ { // de-duplicate and use value_n op: "min", field: "value_n", as: "value_n" } ], groupby: [ /*"duration_n",*/ "t_in" /* has already become mean */, "partition", "formula" ] }, { aggregate: [ { op: "sum", field: "value_n", as: "sum_value" } ], groupby: [/*"duration_n",*/ "t_in", "partition"] }, { aggregate: [ { op: "mean", field: "sum_value", as: "sum_value" } ], groupby: [/*"duration_n",*/ "t_in", "partition"] } ], mark: { type: "point", tooltip: true, interpolate: "step", point: true }, encoding: { //opacity: {value: 0.8}, size: { field: "step_size", scale: null }, // make dept on step size? fill: { value: "green", condition: { test: "datum.sum_value<0", value: "red" } }, strokeWidth: { value: 1 }, // remember: no grouping so many appeareances!! opacity: { field: "partition", type: "nominal", scale: { domain: ["A", "B"], range: [0.3, 0.8] }, legend: null }, color: { value: "black" }, x: { field: "t_in", type: "quantitative", scale: { zero: false, padding: 10, domain: [-36, 18 * 12], nice: false } }, y: { field: "sum_value", type: "quantitative" /*, scale: {domain:{param:'b_extent'}}*/ /*, stack:'normalize'*/ }, detail: { field: "partition" } //color: {field: 'formula', type:'nominal'}, } }, { transform: [ { calculate: "datum.t_in_mean", as: "t_in" }, /* {"filter": {"param": "brush"}*/ /* "slow" per docs vs scale-domain-param but also does extent fix */ { filter: "datum.partition == 'B' ||datum.partition == 'A' " }, // filter out unselected cashflows, for better y range? {filter: "datum.t_in "}, //sum?{calculate: 'datum.val'} //{"extent": "sum_value", "param": "b_extent"}// not using, can use in order to make a greedy selection? (pick one at edge of interval) (change above also) { calculate: "((datum.t_in_step_end-datum.t_in)*4)", as: "step_size" }, { aggregate: [ { // de-duplicate and use value_n op: "min", field: "value_n", as: "value_n" } ], groupby: [ "duration_n", "t_in" /* has already become mean */, "partition", "formula" ] }, { aggregate: [ { op: "sum", field: "value_n", as: "sum_value" } ], groupby: ["duration_n", "t_in", "partition"] }, { aggregate: [ { op: "mean", field: "sum_value", as: "sum_value" } ], groupby: ["duration_n", "t_in", "partition"] } ], mark: { type: "text", tooltip: false, point: true, fontWeight: "bold" }, encoding: { opacity: { value: 0.5 }, size: { value: 8 }, // make dept on step size? //fill: {value:'green', condition: {test: 'datum.sum_value<0', value: 'red'}}, //strokeWidth: {value:0.1}, // remember: no grouping so many appeareances!! //opacity: {field:'partition', type:'nominal', scale: {domain:['A','B'],range:[0.1,0.1]}, legend:null}, color: { value: "black" }, text: { value: { expr: "datum.duration_n+1" } }, x: { field: "t_in", type: "quantitative", scale: { zero: false, padding: 10, domain: [-36, 18 * 12], nice: false } }, y: { field: "sum_value", type: "quantitative" /*, scale: {domain:{param:'b_extent'}}*/ /*, stack:'normalize'*/ }, yOffset: { value: 9 }, detail: { field: "partition" } //color: {field: 'formula', type:'nominal'}, } }, { mark: { type: "rule", strokeDash: [3, 80] }, data: { values: [{}] }, encoding: { color: { value: "orange" }, x: { datum: stress.t_in ?? 0, scale: { zero: false, padding: 10, domain: /*[-10*12,23*12]}*/ { param: "brush", encoding: "x" }, nice: false } } // for Q set to 0 (not string) //x: {datum:'51', type:'quantitative', scale:null} } }, { mark: { type: "text", interactive: false }, // why do these break params? data: { values: [{}] }, encoding: { y: { datum: premiums * 1.2 }, // can't use datum: what scale? x: { value: width - 130 }, text: { value: "➕" }, size: { value: 18 } } }, { mark: { type: "text", interactive: false }, // why do these break params? data: { values: [{}] }, encoding: { y: { datum: -premiums * 1.5 }, // can't use datum: what scale? x: { value: width - 130 }, text: { value: "➖" }, size: { value: 18 } } }, { mark: { type: "text", align: "right", font: "monospace" }, data: { values: [{}] }, encoding: { x: { datum: -1 }, y: { value: 180 }, text: { value: "past ↤" } } }, { mark: { type: "text", align: "left", font: "monospace" }, data: { values: [{}] }, encoding: { x: { datum: 1 }, y: { value: 180 }, text: { value: "↦ future" } } } /*, {mark: {type:'text'}, data: {values:[{}]}, encoding: { y: {datum:-40}, // can't use datum: what scale? x: {datum:100}, text:{value:''}, size: {value:20} //opacity: {value: 0.2} } } */ ] } //,{ // title: '', // ex "zoom" // width:width-50, // height:100, // transform: [ { // filter: // "datum.formula != 'profit' && (datum.partition == 'keep' || datum.partition == 'add' || datum.partition == 'subtract')" // }], // encoding: { x: {field: 't_in', type:'quantitative',nice:false, axis:null}, // y: {field: 'value', type:'quantitative', /*scale: {domain:bin_size <=12 ? [-100,60] : null},*/ axis:null}, // }, // layer:[ // { // params: [{ // name: 'brush', // value: {x: [-50,21*12], y:[-40,40]},// // select: {type:'interval', encodings:['x','y']} // },/*{ // name: 'brush2', // select: {type:'interval', encodings:['y']} // }*/], // mark: {type:'bar', clip:false, tooltip: false}, // can I add rules? In Altair something about interactive, non-interactive layers? // encoding: { // color: {value:'gray'}, // //stroke: {} // //color: {field: 'formula', type:'nominal', legend: {orient: 'top', title: 'cashflow', titleFontSize:20}}, // //order: {field: 'formula', type:'nominal'}, // opacity: { // value: 0.6, // condition: { // test: 'datum.partition == "add" || datum.partition == "subtract"', // value: 1 // } // }, // strokeWidth: { // value: 0, // condition: { // test: 'datum.partition == "add" || datum.partition == "subtract"', // value: 0.5*(bin_size<= 2 ? .2 : bin_size == 12 ? 1 : 0.5) // Scale down for bin size 1 month // } // }, // stroke: { // value: "darkgreen", // condition: { test: 'datum.partition == "subtract"', value: "red" } // }, // }},{ // "mark": {type:"rule", strokeDash: [10,10]}, // "encoding": { // "x": {"datum": 0}, // color: {value:'black'}, // size: {value:2} // }}, // { // mark: {type :'rule'}, // why can't I get rules here ?! // //interactive:false, // data: {values:[{}]}, // encoding: { // x: {value:{expr:"0"}, scale:{padding:0, domain:[-10*12,23*12]}} // for Q set to 0 (not string) // ,color: {value:'red'}, // //size:{value:10} // //x: {datum:'51', type:'quantitative', scale:null} // } // }]} ] } /*{title:'Σ fut. cfs',layer: [{ transform: [ { filter: "datum.t_in>=0"}, { filter: "datum.formula != 'profit' && (datum.partition == 'keep' || datum.partition == 'add' || datum.partition == 'subtract')" },{ aggregate: [{op:'sum',field:'value',as:'value2'}], groupby: ['formula','partition'] }], mark: {type:'bar', tooltip: true}, encoding: { y: {field: 'value2', type:'quantitative'}, color: {field: 'formula', type:'nominal', legend: {orient: 'top', title: 'cashflow', titleFontSize:20}}, //order: {field: 'formula', type:'nominal'}, opacity: { //value: 0.6, condition: { test: 'datum.partition == "add" || datum.partition == "subtract"', value: 1 } }, strokeWidth: { value: 0, condition: { test: 'datum.partition == "add" || datum.partition == "subtract"', value: 2 } }, stroke: { value: "darkgreen", condition: { test: 'datum.partition == "subtract"', value: "red" } }, }}, { transform: [ { filter: "1 && (datum.partition == 'B' ||datum.partition == 'A' )" },], mark: {type:'point', tooltip: true}, encoding: { opacity: {value: 0.8}, size: {value: 190}, strokeWidth: {value:4}, color: {field:'partition', type:'nominal'}, y: {field: 'value', aggregate:'sum', type:'quantitative', axis:{orient:'right', title: null, format:'s'}}, detail: {field:'partition'}, //color: {field: 'formula', type:'nominal'}, }} ]}*/ ], config: { scale: { padding: 0, paddingInner: 0, paddingOuter: 0 } } })30:T5f1,cfs_impacts = aq .from(cfs) .params({ bin_size }) .params({ duration_mth_in }) //.filter(d => d.t_in < 0) // bin: //.groupby(["formula", { // t_in: aq.bin('t_in', {step:bin_size,/*offset:0,*/ nice:false}) //}, 'input_cursor_id']) //.rollup({value: d => aq.op.sum(d.value)}) // nobin: .groupby(["t_in", "formula"]) .orderby(["formula", "t_in", "input_cursor_id"]) .derive({ A: (d) => aq.op.lag(d.value, 1, 0), B: (d) => d.value, t_in_step_end: (d) => Math.min(d.t_in + bin_size, 0) // EDITED DONT COPY }) .filter((d) => d.input_cursor_id == 0) // CHANGED HERE .derive({ keep: ( d // =IF(C6<0,MIN(0,MAX(D6,C6)),IF(C6>0,MAX(0,MIN(D6,C6)))) ) => { if (d.A < 0) return Math.min(0, Math.max(d.A, d.B)); return Math.max(0, Math.min(d.A, d.B)); }, add: (d) => Math.max(0, d.B - d.A) * (d.A < 0 ? -1 : 1), subtract: (d) => Math.max(0, d.A - d.B) * (d.A < 0 ? 1 : 1), // todo edge case for flips A_keep_gte_0: (d) => d.A >= 0 }) .fold(["A", "B", "keep", "add", "subtract"], { as: ["partition", "value"] }) //.derive({'value': d => d.value}) .derive({ duration_mth: (d) => Math.floor((d.t_in + duration_mth_in) / 1), duration_n: (d) => Math.floor((d.t_in + duration_mth_in) / bin_size) }) .groupby("partition", "formula", "input_cursor_id", "duration_n") .derive({ value_n: aq.rolling(aq.op.mean("value"), [-Infinity, Infinity], false), t_in_mean: aq.rolling(aq.op.mean("t_in"), [-Infinity, Infinity], false) })31:T5df,cfs_impacts_static = aq .from(cfs_static) .params({ bin_size }) .params({ duration_mth_in:0 }) //.filter(d => d.t_in < 0) // bin: //.groupby(["formula", { // t_in: aq.bin('t_in', {step:bin_size,/*offset:0,*/ nice:false}) //}, 'input_cursor_id']) //.rollup({value: d => aq.op.sum(d.value)}) // nobin: .groupby(["t_in", "formula"]) .orderby(["formula", "t_in", "input_cursor_id"]) .derive({ A: (d) => aq.op.lag(d.value, 1, 0), B: (d) => d.value, t_in_step_end: (d) => Math.min(d.t_in + 12, 0) // EDITED DONT COPY }) .filter((d) => d.input_cursor_id == 0) // CHANGED HERE .derive({ keep: ( d // =IF(C6<0,MIN(0,MAX(D6,C6)),IF(C6>0,MAX(0,MIN(D6,C6)))) ) => { if (d.A < 0) return Math.min(0, Math.max(d.A, d.B)); return Math.max(0, Math.min(d.A, d.B)); }, add: (d) => Math.max(0, d.B - d.A) * (d.A < 0 ? -1 : 1), subtract: (d) => Math.max(0, d.A - d.B) * (d.A < 0 ? 1 : 1), // todo edge case for flips A_keep_gte_0: (d) => d.A >= 0 }) .fold(["A", "B", "keep", "add", "subtract"], { as: ["partition", "value"] }) //.derive({'value': d => d.value}) .derive({ duration_mth: (d) => Math.floor((d.t_in + 0) / 1), duration_n: (d) => Math.floor((d.t_in + 0) / bin_size) }) .groupby("partition", "formula", "input_cursor_id", "duration_n") .derive({ value_n: aq.rolling(aq.op.mean("value"), [-Infinity, Infinity], false), t_in_mean: aq.rolling(aq.op.mean("t_in"), [-Infinity, Infinity], false) })32:[{"id":"88d2ca942b5398b831064887cbcef9a30e5ef52ad491f971800232b2c5f6e770345d7d6a015f224526e9015d8094a2b14b5e0dc2e25ce4093d9c4f3534286d91","href":"https://static.observableusercontent.com/files/88d2ca942b5398b831064887cbcef9a30e5ef52ad491f971800232b2c5f6e770345d7d6a015f224526e9015d8094a2b14b5e0dc2e25ce4093d9c4f3534286d91","name":"basicterm@3.cul.js","type":"application/javascript","lastModified":1725060688079.935,"size":38199},{"id":"fbb31f5fbd5a416316cc5d923415b80aef119f77da0bffac195ad044baa32a02dba53049fee035a2de7ebdba402d34a9c1bb0b8e6e6ad8d01bb7d705a4328050","href":"https://static.observableusercontent.com/files/fbb31f5fbd5a416316cc5d923415b80aef119f77da0bffac195ad044baa32a02dba53049fee035a2de7ebdba402d34a9c1bb0b8e6e6ad8d01bb7d705a4328050","name":"mps-basicterm@2.cul.js","type":"application/javascript","lastModified":1725060688224.97,"size":5612}] 2d:{"title":"Visualizing Cashflows Question","cells":[{"id":0,"value":"# Visualizing Cashflows Question\n\n~~No longer a question~~\n\nI moved to .toArray","pinned":false,"hidden":false,"mode":"md"},{"id":293,"value":"## WIP (and not a very column-heavy dataset), but this visualization does function and react to the slider (even though I broke the data processing)","pinned":false,"hidden":false,"mode":"md"},{"id":296,"value":"

*spec includes

data: { values: cfs_impacts_static }

","pinned":false,"hidden":false,"mode":"md"},{"id":117,"value":"viewof point_id_in = Inputs.range([1, 30], {\n step: 1,\n value: 21,\n label: \"point_id_in\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":154,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":279,"value":"# Data\n\n## calculang -> Arquero -> Arrow using `.toArrow()`","pinned":false,"hidden":false,"mode":"md"},{"id":127,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":329,"value":"cfs_impacts_arrow = aq.toArrow(cfs_impacts) // also tried cfs_impacts.toArrow()","pinned":false,"hidden":false,"mode":"ojs"},{"id":223,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":333,"value":"cfs_impacts_static_arrow = aq.toArrow(cfs_impacts_static) // also tried cfs_impacts_static.toArrow()","pinned":false,"hidden":false,"mode":"ojs"},{"id":286,"value":"# How I populate data\n\n

*Slider reactivity doesn't work if I uncomment:*

","pinned":false,"hidden":false,"mode":"md"},{"id":152,"value":"viz.data(\"source_0\", cfs_impacts_arrow.toArray()).run()","pinned":true,"hidden":false,"mode":"ojs"},{"id":343,"value":"

*But it works with this:*

","pinned":false,"hidden":false,"mode":"md"},{"id":339,"value":"//viz.data(\"source_0\", [...cfs_impacts]).run()","pinned":true,"hidden":false,"mode":"ojs"},{"id":358,"value":"## This versus Observable default is different but neither works","pinned":false,"hidden":false,"mode":"md"},{"id":350,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":347,"value":"aq\n .table({\n w: [\"a\", \"b\", \"a\"],\n x: [1, 2, 3],\n y: [1.6181, 2.7182, 3.1415],\n z: [true, true, false]\n })\n .toArrow()","pinned":false,"hidden":false,"mode":"ojs"},{"id":281,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":9,"value":"basictermCul = FileAttachment(\"basicterm@3.cul.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"mpsBasictermCul = FileAttachment(\"mps-basicterm@2.cul.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"calculang = import(\n \"https://cdn.jsdelivr.net/gh/calculang/calculang@dev/packages/standalone/index.js\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"model = calculang.compile({\n entrypoint: \"entrypoint.cul.js\",\n fs: {\n \"entrypoint.cul.js\": await mpsBasictermCul.text(),\n \"./basicterm.cul.js\": await basictermCul.text()\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"helpers = import(\n \"https://cdn.jsdelivr.net/gh/declann/calculang-js-browser-dev@main/helpers.js\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"calcudata = helpers.calcudata","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"cursor = ({\n point_id_in,\n t_in: 0,\n zero_duration_in: false,\n mort_rate_factor_in: 1\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":112,"value":"model.js.pv_fut_net_cf(cursor)","pinned":false,"hidden":false,"mode":"ojs"},{"id":120,"value":"cfs = await calcudata({\n models: [model.js],\n input_cursors: [cursor],\n //input_cursors: [{...cursor, stress_in: 'none',duration_mth_in:0},{...cursor, stress_in: 'none'}],\n input_domains: {\n t_in: _.range(\n -model.js.duration_mth({ ...cursor, t_in: 0 }),\n model.js.proj_len(cursor) + 1,\n 1\n )\n },\n outputs: [\"pv_premiums\", \"pv_claims\", \"pv_commissions\", \"pv_expenses\"]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":252,"value":"# `*_static` is just to initialize visualization","pinned":false,"hidden":false,"mode":"md"},{"id":219,"value":"cfs_static = await calcudata({\n models: [model.js],\n input_cursors: [\n { point_id_in: 1, t_in: 0, zero_duration_in: false, mort_rate_factor_in: 1 }\n ],\n //input_cursors: [{...cursor, stress_in: 'none',duration_mth_in:0},{...cursor, stress_in: 'none'}],\n input_domains: {\n t_in: _.range(\n -model.js.duration_mth({\n point_id_in: 1,\n t_in: 0,\n zero_duration_in: false,\n mort_rate_factor_in: 1\n }),\n model.js.proj_len({\n point_id_in: 1,\n t_in: 0,\n zero_duration_in: false,\n mort_rate_factor_in: 1\n }) + 1,\n 1\n )\n },\n outputs: [\"pv_premiums\", \"pv_claims\", \"pv_commissions\", \"pv_expenses\"]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":136,"value":"duration_mth_in = model.js.duration_mth({ ...cursor, t_in: 0 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"bin_size = 12","pinned":false,"hidden":false,"mode":"ojs"},{"id":158,"value":"premiums = 94 //model.js.premium_pp({ ...cursor, point_id_in: 1 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":156,"value":"stress = ({ formula: \"\", t_in: 0 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":173,"value":"embed = require(\"vega-embed\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}