2f:T6f4,gem = ({ //"meta": {"name": "All at once"}, staggerings: [ { name: "a", by: "year_in", order: "ascending", // step ? "ascending" : "descending", overlap: 0 //0.7 } ], timeline: { concat: [ ...(step ? [ { component: { mark: "layer_0_marks" }, // rect change: { data: false, //data: { keys: ["year_in", "formula"] }, encode: { update: { y: false, y2: false }, enter: false, exit: false } }, timing: { duration: 200 } } ] : []), { component: { mark: "layer_0_marks" }, // rect change: { //data: { keys: ["year_in", "formula"] }, encode: { update: { opacity: false } // enter: true, // for now //exit: true } }, timing: { staggering: "a", duration: { ratio: 1 } } }, { component: { mark: "layer_1_marks" }, timing: { duration: { ratio: 0.7 } } }, { component: { mark: "layer_2_marks" }, timing: { duration: { ratio: 0.7 } } }, ...(!step ? [ { component: { mark: "layer_0_marks" }, // rect change: { data: false, //data: { keys: ["year_in", "formula"] }, encode: { update: { y: false, y2: false }, enter: false, exit: false } }, timing: { duration: 200 } } ] : []) ] }, totalDuration: 2200 })30:T10c1,function area_spec_new_format(reserves, params, w) { let color_scale; if (reserves == 0) color_scale = { domain: ["premiums", "mclaims"], range: ["steelblue", "darkorange", "yellow"] }; else if (reserves == 1) color_scale = { domain: ["premiums", "mclaims", "mΔreserve"], range: ["steelblue", "darkorange", "yellow"] }; else color_scale = { domain: ["premiums", "mclaims", "mΔreserve", "mΔadverse_reserve"], range: ["steelblue", "darkorange", "yellow", "purple"] }; return { $schema: "https://vega.github.io/schema/vega-lite/v5.json", data: { name: "projection" }, datasets: { projection: [] }, height, width: w, transform: [ { calculate: "datum.partition == 'subtract' ? -datum.value : datum.value", as: "value" } ], encoding: { order: { field: "formula" }, x: { field: "year_in", type: "ordinal", axis: { grid: false, values: [1, 10, 20] }, scale: { nice: false } }, y: { field: "value", title: null, type: "quantitative", scale: { domain: [-400, 450], nice: false }, axis: { grid: false, gridColor: "hotpink", gridWidth: 5, labelAngle: 0, values: [0 /*,100,-200*/] } } }, layer: [ { transform: [ { filter: "abs(datum.value)>0.01" }, { filter: "datum.formula != 'profit' && (datum.partition == 'keep' || datum.partition == 'add' || datum.partition == 'subtract')" } ], mark: { type: "bar" /*, width: 12*/ }, ...(params && { params: [ { name: "cashflow", // DN: as long as not used in spec (=> data() function called in expressions), then gemini transitions work select: { type: "point", fields: ["formula"] }, bind: "legend" } ] }), encoding: { opacity: { //condition: { param: "cashflow", value: 1 }, condition: { test: 'datum.partition == "add" || datum.partition == "subtract"', value: 1 }, value: 0.6 }, strokeWidth: { value: 0, condition: { test: 'datum.partition == "add" || datum.partition == "subtract"', value: 2 } }, stroke: { value: "darkgreen", condition: { test: 'datum.partition == "subtract"', value: "red" } }, color: { legend: false, field: "formula", type: "nominal", scale: color_scale } } }, { transform: [ { filter: "datum.formula == 'profit' && datum.partition == 'B'" }, { calculate: "50+width/8", as: "a" } ], mark: { type: "point", baseline: "middle", dy: 1, size: 90, filled: true }, encoding: { opacity: { value: 1 }, strokeWidth: { value: 2 }, stroke: { value: "black" }, color: { field: "value", type: "quantitative", scale: { type: "threshold", domain: [-0.1, 0.1], range: ["red", "lightblue", "green"] }, legend: null } } }, { // 'ghost' marks for visual comparison transform: [ { filter: "datum.formula == 'profit' && datum.partition == 'A'" } ], mark: { type: "point", baseline: "middle", dy: 1, size: 90, filled: false }, encoding: { opacity: { value: 0.15 }, strokeWidth: { value: 2 }, stroke: { value: "black" } /*color: { field: "value", type: "quantitative", scale: { type: "threshold", domain: [-0.1, 0.1], range: ["red", "lightblue", "green"] }, legend: null }*/ } } ] }; }31:T129c,vgspec = { // using https://github.com/uwdata/gemini/blob/master/src/util/vl2vg4gemini.js function appendNamesOnGuides(vgSpec) { if (vgSpec.axes) { vgSpec.axes.forEach((axis) => { if (!axis.encode) { axis.encode = { axis: { name: axis.scale } }; } else { axis.encode.axis = { ...axis.encode.axis, name: axis.scale }; } }); } if (vgSpec.legends) { vgSpec.legends.forEach((legend, i) => { if (!legend.encode) { legend.encode = { legend: { name: `legend${i}` } }; } else { legend.encode.legend = Object.assign({}, legend.encode.legend, { name: `legend${i}` }); } }); } } function mergeDuplicatedAxes(vegaAxes) { if (!vegaAxes || vegaAxes.length <= 0) { return []; } let axesScales = vegaAxes.filter((a) => a.grid).map((a) => a.scale); return d3 .rollups( vegaAxes, (axes) => { let axisWithGrid = axes.find((a) => a.grid); let axisWithoutGrid = { ...axes.find((a) => !a.grid) }; if (axisWithGrid) { axisWithoutGrid.grid = true; if (axisWithGrid.gridScale) { axisWithoutGrid.gridScale = axisWithGrid.gridScale; } axisWithoutGrid.zindex = 0; } return axisWithoutGrid; }, (axis) => axis.scale ) .map((d) => d[1]) .sort( (a, b) => axesScales.indexOf(a.scale) - axesScales.indexOf(b.scale) ); } let vgSpec = vl.compile(vlspec).spec; vgSpec.axes = mergeDuplicatedAxes(vgSpec.axes); appendNamesOnGuides(vgSpec); // TODO my custom patches vgSpec.scales = [ ...(vgSpec.scales ? vgSpec.scales : []), { name: "formula_shadow", type: "ordinal", domain: ["premiums", "claims", "-Δreserve"], range: ["steelblue", "darkorange", "yellow"] }, { name: "profit_category_shadow", type: "ordinal", domain: ["loss", "-", "profit"], range: ["red", "lightblue", "green"], interpolate: "hcl" } ]; vgSpec.legends = [ ...(vgSpec.legends ? vgSpec.legends : []), { orient: "top", padding: 6, strokeColor: "lightgrey", title: "cashflow", fill: "formula_shadow", direction: "horizontal", symbolType: "square", encode: { legend: { name: "legend_0" }, symbols: { update: { opacity: { value: 1 } } } } }, { orient: "top", padding: 6, strokeColor: "lightgrey", title: "Σ cashflows", fill: "profit_category_shadow", direction: "horizontal", symbolType: "circle", encode: { legend: { name: "legend_1" }, symbols: { update: { stroke: { value: "black" } } } } } ]; vgSpec.marks = [ { name: "bgtop", type: "rect", encode: { update: { fill: { value: "lightgreen" }, x: { scale: "x", field: "year_in" }, width: { signal: "width" }, //width: { scale: "x", signal: "domain('x')[1]" }, y: { scale: "y", value: 0 }, y2: { scale: "y", signal: "domain('y')[1]" }, opacity: { value: 0.5 } } } }, { name: "bgbottom", type: "rect", encode: { update: { fill: { value: "orange" }, x: { scale: "x", field: "year_in" }, width: { signal: "width" }, y2: { scale: "y", value: 0 }, y: { scale: "y", signal: "domain('y')[0]" }, opacity: { value: 0.4 } } } }, { name: "minus_annotation", type: "text", encode: { update: { x: { signal: "width*1/3" }, y: { signal: "height*4/5" }, text: { value: "➖" }, // 💸 fontSize: { value: 30 }, align: { value: "center" }, baseline: { value: "middle" } } } }, { name: "plus_annotation", type: "text", encode: { update: { x: { signal: "width*1/3" }, y: { signal: "height*1/5" }, text: { value: "➕" }, // 💰 fontSize: { value: 30 }, align: { value: "center" }, baseline: { value: "middle" } } } }, { name: "zero_rule", type: "rule", encode: { update: { x: { signal: "0" }, y: { signal: "0", scale: "y" }, x2: { signal: "width" }, //y2: { signal: "height*2/5" }, stroke: { signal: "'gray'" }, strokeWidth: { signal: "2" } } } }, ...vgSpec.marks ]; return vgSpec; }32:T8fc,portfolio_cul = `import { profit, premiums_ as premiums_pp, claims_ as claims_pp, reserve_ as reserve_pp, Δreserve, adverse_reserve_ as adverse_reserve_pp, Δadverse_reserve, mclaims, mΔreserve, mΔadverse_reserve, premiums_less_claims, fut_profit_ as fut_profit_pp, fut_premiums_ as fut_premiums_pp, fut_claims_ as fut_claims_pp } from './policy.cul.js' // export not necessary anymore export const point_id = () => point_id_in; // should constrain start_year etc. export const start_year = () => point_id() != undefined ? portfolio()[point_id()].start_year : 1 export const count = () => portfolio()[point_id()].count //export const end_year = point_id() != undefined ? end_year_pp() : 50 export const portfolio = () => [ {start_year:1, count:1}, {start_year:2, count:1}, {start_year:3, count:1}, /*{start_year:4, count:1}, {start_year:5, count:1}, {start_year:6, count:1}, {start_year:7, count:1},*/ ] export const premiums = () => { if (point_id() == undefined) { return portfolio().reduce((a,v,point_id_in) => a + count() * premiums_pp(), 0) } else return count() * premiums_pp(); } export const claims = () => { if (point_id() == undefined) { return portfolio().reduce((a,v,point_id_in) => a + count() * claims_pp(), 0) } else return count() * claims_pp(); } export const reserve = () => { if (point_id() == undefined) { return portfolio().reduce((a,v,point_id_in) => a + 1 * reserve_pp(), 0) } else return 1 * reserve_pp(); } export const adverse_reserve = () => { if (point_id() == undefined) { return portfolio().reduce((a,v,point_id_in) => a + 1 * adverse_reserve_pp(), 0) } else return 1 * adverse_reserve_pp(); } export const fut_profit = () => { if (point_id() == undefined) { return portfolio().reduce((a,v,point_id_in) => a + 1 * fut_profit_pp(), 0) } else return 1 * fut_profit_pp(); } export const fut_premiums = () => { if (point_id() == undefined) { return portfolio().reduce((a,v,point_id_in) => a + 1 * fut_premiums_pp(), 0) } else return 1 * fut_premiums_pp(); } export const fut_claims = () => { if (point_id() == undefined) { return portfolio().reduce((a,v,point_id_in) => a + 1 * fut_claims_pp(), 0) } else return 1 * fut_claims_pp(); } // do i need to do this also for fut_x ??`33:Te7b,policy_cul = `export const year = () => year_in; export const start_year = () => start_year_in export const policy_year = () => year() - start_year() // 0 indexed export const end_year = () => start_year() + term() - 1 export const term = () => 20 // derive end export const premiums_fn = () => premiums_fn_in; export const claims_fn = () => claims_fn_in; export const premiums_pp = () => (year() < start_year() || year() > end_year()) ? 0 : premiums_fn()()[policy_year()+1] export const claims_pp = () => (year() < start_year() || year() > end_year()) ? 0 : claims_fn()()[policy_year()+1] export const premiums = () => { return sales().reduce((a,v,i) => a + v * premiums_pp({year_in:year()-i}), 0) } export const claims = () => { return sales().reduce((a,v,i) => a + v * claims_pp({year_in:year()-i}), 0) } export const premiums_less_claims = () => premiums() - claims(); export const fut_claims = () => { if (year() >= end_year()) return 0; else return fut_claims({ year_in: year() + 1 }) + claims({year_in: year() + 1}) } export const fut_premiums = () => { if (year() >= end_year()) return 0; else return fut_premiums({ year_in: year() + 1 }) + premiums({year_in: year() + 1}) } export const fut_profit = () => { if (year() >= end_year()) return 0; else return fut_profit({ year_in: year() + 1 }) + profit({year_in: year() + 1}) } export const fut_bads = () => { if (year() >= end_year()) return 0; else return fut_bads({ year_in: year() + 1 }) + bads({year_in: year() + 1}) } export const fut_not_bads = () => { if (year() >= end_year()) return 0; else return fut_not_bads({ year_in: year() + 1 }) + not_bads({year_in: year() + 1}) } export const fut_positives = () => { if (year() >= end_year()) return 0; else return fut_positives({ year_in: year() + 1 }) + positives({year_in: year() + 1}) } export const limit = () => limit_in; // for animation export const bads = () => { /*if (profit({reserve_factor_in:0, adverse_reserve_factor_in:0}) < -limit()) CIRCULARITY return profit({reserve_factor_in:0, adverse_reserve_factor_in:0}) + limit()*/ if (premiums() - claims() < -limit()) return premiums() - claims() + limit() else return 0 } export const not_bads = () => claims()-bads() export const reserve_factor = () => reserve_factor_in ?? 1 export const positives = () => premiums() > claims() ? premiums() - claims() : 0; export const reserve = () => { if (year() < start_year() - 1) return 0 return Math.max(0, -fut_bads() -fut_positives() ) } export const reserve_A = () => { if (year() < start_year() - 1) return 0 return Math.max(0, -fut_bads() -fut_premiums()+fut_not_bads()-fut_claims() ) //if (fut_premiums()-fut_not_bads()>-fut_bads()) return 0//-(fut_premiums()-fut_not_bads()-fut_bads()); //else return -fut_bads() //return Math.max(0, -fut_premiums()+fut_claims()+fut_bads()) } export const Δreserve = () => reserve() - reserve({year_in:year()-1}) //export const profit = () => premiums() - claims() - Δreserve() export const adverse_reserve_factor = () => adverse_reserve_factor_in ?? .3 export const adverse_reserve = () => year() < start_year() - 1 ? 0 : adverse_reserve_factor()*fut_claims() // timing? export const Δadverse_reserve = () => adverse_reserve() - adverse_reserve({year_in:year()-1}) export const profit = () => premiums() - claims() - Δreserve() - Δadverse_reserve() // things I need to remove! export const mclaims = () => -claims(); export const mΔreserve = () => -Δreserve(); export const mΔadverse_reserve = () => -Δadverse_reserve(); //// // NBS export const sales = () => [1]; // not using this as reserves always at start //export const capital_requirement = () => `34:[] 2d:{"title":"cashflow transitions iv (dimming)","cells":[{"id":0,"value":"# cashflow transitions iv (dimming)\n\n**UPDATE**: I released this to a [blog post about actuarial terminology](https://calcwithdec.dev/posts/actuarial-terms-i/): [hoot](https://fosstodon.org/@calculang/112841998111396907)\n\n~~This doesn't work backwards!~~ It does: duration error was fixed by embed using a spec that reactively updates after animation (mapped[v0])\n\n***drag the step ▶️:***","pinned":false,"hidden":false,"mode":"md"},{"id":321,"value":"viewof step = Inputs.range([0, 1], {\n label: \"step ▶️\",\n step: 1,\n value: 0\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":268,"value":"

","pinned":false,"hidden":false,"mode":"html"},{"id":1008,"value":"viewof w = Inputs.range([0, 1000], {\n label: \"width\",\n value: Math.min(300, width - 50),\n step: 1\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":279,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":320,"value":"{\n if (step != mutable v0) {\n console.log(\"RUNNING\");\n const animation = await gemini.animate(mapped[v0], mapped[step], gem);\n await animation.play(\"#view\");\n setV0(step);\n console.log(\"done\");\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1031,"value":"height = 250","pinned":false,"hidden":false,"mode":"ojs"},{"id":1024,"value":"For ordinal x scale (but not quantitative) 'bandwidth' in output is a problem using v5 compiler.","pinned":false,"hidden":false,"mode":"md"},{"id":1018,"value":"viewof vlv = Inputs.range([4, 5], {\n label: \"vega-lite compiler version\",\n step: 1,\n value: 4\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":650,"value":"v = \"messin\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":911,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":914,"value":"vlspec = area_spec_new_format(i, params, w)","pinned":false,"hidden":false,"mode":"ojs"},{"id":929,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":924,"value":"vl = require(\"vega-lite@\" + vlv)","pinned":false,"hidden":false,"mode":"ojs"},{"id":933,"value":"spec = vgspec","pinned":false,"hidden":false,"mode":"ojs"},{"id":973,"value":"viewof params = Inputs.toggle({ value: false, label: \"params\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":919,"value":"viewof i = Inputs.range([0, 10], { step: 1, value: 1, label: \"reserves i\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":658,"value":"mapped","pinned":false,"hidden":false,"mode":"ojs"},{"id":477,"value":"spec0 = {\n let s = JSON.parse(JSON.stringify(spec)); // structuredClone(spec); //Object.assign({}, spec); // , { data: { values: projection0 } }\n s.data = s.data.map((d) =>\n d.name == \"projection\"\n ? { name: \"projection\", values: [...projection0] }\n : d\n );\n s.marks = [...s.marks];\n s.marks[5].encode.update.opacity = { value: 1 };\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":479,"value":"spec1 = {\n let s = Object.assign({}, spec); // , { data: { values: projection0 } }\n s.data = s.data.map((d) =>\n d.name == \"projection\"\n ? { name: \"projection\", values: [...projection1] }\n : d\n );\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":613,"value":"edits: Unrecognized function: data (then vlSelectionTest) so removed these","pinned":false,"hidden":false,"mode":"md"},{"id":319,"value":"[v0, step]","pinned":false,"hidden":false,"mode":"ojs"},{"id":656,"value":"gemini.animate(mapped[0], mapped[1], gem)","pinned":true,"hidden":false,"mode":"ojs"},{"id":605,"value":"//gemini.animate(mapped[0], mapped[1], gem)","pinned":true,"hidden":false,"mode":"ojs"},{"id":607,"value":"spec0.marks.map((d) => d.name)","pinned":true,"hidden":false,"mode":"ojs"},{"id":10,"value":"viewof chart = embed(\"#view\", mapped[v0], { renderer: \"svg\" })","pinned":true,"hidden":false,"mode":"ojs"},{"id":26,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":316,"value":"setV0 = (v) => (mutable v0 = v)","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"gemini = require(\"https://cdn.jsdelivr.net/gh/declann/gemini@1c2e679/gemini.web.js\") // pinned","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"embed = require(\"https://cdn.jsdelivr.net/gh/declann/vega-embed-vl4@main/build/vega-embed.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":205,"value":"mapped = [spec0, spec1] //.map(gemini.vl2vg4gemini)","pinned":false,"hidden":false,"mode":"ojs"},{"id":382,"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":384,"value":"calculang = import(\n \"https://cdn.jsdelivr.net/gh/declann/calculang-js-browser-dev@main/calculang.js\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":424,"value":"mutable v0 = 0","pinned":true,"hidden":false,"mode":"ojs"},{"id":427,"value":"v1 = step","pinned":true,"hidden":false,"mode":"ojs"},{"id":560,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":563,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":386,"value":"fs = ({\n \"entrypoint.cul.js\": portfolio_cul,\n \"./policy.cul.js\": policy_cul\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":442,"value":"fs1 = fs","pinned":false,"hidden":false,"mode":"ojs"},{"id":568,"value":"fs0 = fs","pinned":false,"hidden":false,"mode":"ojs"},{"id":388,"value":"introspection0 = await calculang.introspection(\"entrypoint.cul.js\", fs0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":444,"value":"introspection1 = await calculang.introspection(\"entrypoint.cul.js\", fs1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":448,"value":"compiled0 = await calculang.compile_new(\n \"entrypoint.cul.js\",\n fs0,\n introspection0\n) // ?","pinned":false,"hidden":false,"mode":"ojs"},{"id":392,"value":"compiled1 = await calculang.compile_new(\n \"entrypoint.cul.js\",\n fs1,\n introspection1\n) // ?","pinned":false,"hidden":false,"mode":"ojs"},{"id":394,"value":"esm1 = compiled1[0]","pinned":false,"hidden":false,"mode":"ojs"},{"id":396,"value":"bundle0 = calculang.bundleIntoOne(compiled0, introspection0, true)","pinned":false,"hidden":false,"mode":"ojs"},{"id":450,"value":"bundle1 = calculang.bundleIntoOne(compiled1, introspection1, true)","pinned":false,"hidden":false,"mode":"ojs"},{"id":398,"value":"u0 = {\n const u = URL.createObjectURL(\n new Blob([bundle0], { type: \"text/javascript\" })\n );\n\n invalidation.then(() => {\n console.log(`revoking ${u}`);\n URL.revokeObjectURL(u);\n });\n\n return u;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":452,"value":"u1 = {\n const u = URL.createObjectURL(\n new Blob([bundle1], { type: \"text/javascript\" })\n );\n\n invalidation.then(() => {\n console.log(`revoking ${u}`);\n URL.revokeObjectURL(u);\n });\n\n return u;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":400,"value":"model0 = await import(u0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":454,"value":"model1 = await import(u1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":462,"value":"projection0_ = helpers.calcudata({\n models: [model0],\n outputs: [\"premiums\", \"mclaims\", \"profit\", \"mΔreserve\"],\n input_domains: { year_in: _.range(0, 21 + 0.1, 1) },\n input_cursors: [cursor, cursor] // for update in enter/exit/update pattern to match\n //pivot: true\n})\n//.filter((d) => d.formula == \"profit\" || Math.abs(d.value) > 0.001)","pinned":true,"hidden":false,"mode":"ojs"},{"id":890,"value":"projection0 = aq\n .from(projection0_)\n .groupby([\"year_in\", \"formula\"])\n .orderby(\"input_cursor_id\")\n .derive({ A: (d) => aq.op.lag(d.value, 1, 0), B: (d) => d.value })\n .filter((d) => d.input_cursor_id == 1)\n .derive({\n keep: (\n d // =IF(C6<0,MIN(0,MAX(D6,C6)),IF(C6>0,MAX(0,MIN(D6,C6))))\n ) => {\n if (d.A < 0) return Math.min(0, Math.max(d.A, d.B));\n return Math.max(0, Math.min(d.A, d.B));\n },\n add: (d) => Math.max(0, d.B - d.A),\n subtract: (d) => Math.max(0, d.A - d.B)\n })\n .fold([\"A\", \"B\", \"keep\", \"add\", \"subtract\"], { as: [\"partition\", \"value\"] })","pinned":true,"hidden":false,"mode":"ojs"},{"id":900,"value":"projection1_ = helpers.calcudata({\n models: [model0],\n outputs: [\"premiums\", \"mclaims\", \"profit\", \"mΔreserve\"],\n input_domains: { year_in: _.range(0, 21 + 0.1, 1) },\n input_cursors: [cursor, { ...cursor, limit_in: 0 }] // for update in enter/exit/update pattern to match\n //pivot: true\n})\n//.filter((d) => d.formula == \"profit\" || Math.abs(d.value) > 0.001)","pinned":true,"hidden":false,"mode":"ojs"},{"id":464,"value":"projection1 = aq\n .from(projection1_)\n .groupby([\"year_in\", \"formula\"])\n .orderby(\"input_cursor_id\")\n .derive({ A: (d) => aq.op.lag(d.value, 1, 0), B: (d) => d.value })\n .filter((d) => d.input_cursor_id == 1)\n .derive({\n keep: (\n d // =IF(C6<0,MIN(0,MAX(D6,C6)),IF(C6>0,MAX(0,MIN(D6,C6))))\n ) => {\n if (d.A < 0) return Math.min(0, Math.max(d.A, d.B));\n return Math.max(0, Math.min(d.A, d.B));\n },\n add: (d) => Math.max(0, d.B - d.A),\n subtract: (d) => Math.max(0, d.A - d.B)\n })\n .fold([\"A\", \"B\", \"keep\", \"add\", \"subtract\"], { as: [\"partition\", \"value\"] })","pinned":false,"hidden":false,"mode":"ojs"},{"id":468,"value":"cursor = ({ premiums_fn_in:() => premiums, claims_fn_in:() => claims, point_id_in: 0, adverse_reserve_factor_in:0, limit_in:10000 })","pinned":true,"hidden":false,"mode":"ojs"},{"id":578,"value":"premiums = [0, ..._.range(0, 19.1).map((year) => 100 - year * 1.5)]","pinned":true,"hidden":false,"mode":"ojs"},{"id":580,"value":"claims = [0, ..._.range(0, 19.1).map((year) => 1.35 ** year)]","pinned":true,"hidden":false,"mode":"ojs"},{"id":591,"value":"mapped[0]","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}