25:["$","title",null,{"children":"Analysis: SP ROI Calculator (WIP) | vvk | Observable"}] 49:T693,sectorProfitabilityCurve = { const raw = dataRewards.map((demo) => ({ ...demo, ...generateHistory(demo, d) })); const data = raw .map((d) => d.history.map((v) => ({ ...v, demo: d.name }))) .flat() .map((d) => ({ type: "daily", ...d })); const cum = raw .map((d) => d.cumHistory.map((v) => ({ ...v, demo: d.name }))) .flat() .map((d) => ({ type: "cum", ...d })); const plot1 = Plot.plot({ caption: "Figure 6: Sector profitability through time", height: 650, width: width / 2 - 10, inset: 10, x: { tickFormat: (d) => d3.format(".1f")(d / 365) + "y", ticks: d3.range(dYear * 2 + 1).map((d) => d * 30 * 6), label: "months →" }, y: { grid: true }, fy: { label: null }, marks: [ Plot.frame(), Plot.line(data, { fy: "demo", x: "day", y: "reward", stroke: "demo" }) ] }); const plot2 = Plot.plot({ caption: "Figure 7: Sector profitability through time (cumulative)", height: 650, width: width / 2 - 10, inset: 10, x: { tickFormat: (d) => d3.format(".1f")(d / 365) + "y", ticks: d3.range(dYear * 2 + 1).map((d) => d * 30 * 6), label: "months →" }, y: { grid: true }, marks: [ Plot.frame(), Plot.line(cum, { fy: "demo", x: "day", y: "profit", stroke: "demo" }), Plot.ruleY([0], { stroke: "gray" }) ] }); return html` ${plot1.legend("color")}

${plot1}

${plot2}

`; }4a:T72d,## Definitions Resource definition: - S(t) = storage available at time t (in GiB) - T(t) = tokens needed at time t for adding a sector with deals to the network - Tcc(t) = tokens needed at time t for adding a CC sector to the network - D(t) = deals available at time t (in GiB) - B(t) = bandwidth Costs: - Cost_S = cost of 32GiB storage - Cost_B(t) = bandwidth cost at time t for 32 GiB transfer - lendingR = Lending interest rate (tunable) - Cost_L(lendingR) = Cost of lending 1$ for 1 day with interest rate lendingR (considering a 365 days lending window) - Cost_M(t, t') = Maintenance cost for a 32 GiB sector from time t to time t'. Currently split into WindowPost costs (proving + gas) and Operational costs - Cost_ccseal = cost of sealing a CC sector (ie, labeling or PC1). - Cost_ccproving = cost of proving a CC sector (ie, Commitments + SNARKs, or PC2 + C2) - Cost_ccgas(t) = gas cost for adding a CC sector at time t (ie, gas for `PreCommit`+`ProveCommit`) - Cost_dataOp = data operational costs - Cost_dataLat = latency costs - Cost_dealGas(t) = gas cost for deal publishing at time t (ie, gas for `PublishStorageDeals`) - Cost_dseal = cost of sealing a sector with deals (i.e.labeling or PC1) - Cost_dproving = cost of proving a sector with deals (ie, Commitments + SNARKs PC2 + C2) - Cost_dgas(t) = gas cost for adding a sector with deals at time t (ie, gas for `PreCommit`+`ProveCommit`) - Cost_snapembed = cost of embedding data when snapping - Cost_snapproving = cost of proving a snap - Cost_snapgas(t) = gas cost for a snapped sector at time t (ie, gas for `ProveReplicaUpdate`) Other parameters - d: sector lifetime (in days) - d0: moment in time when FIL+ data are snapped into the sector - BR(t) = the expected share of the 24h block reward that a 32GiB sectors with no deal gives to an SP in a day at time t4b:T77a,function ccSector({ d, d0 = 0, size, filPlus = true, newSector = true, lending = true, t, name, pureCC = false }) { if (pureCC) { filPlus = false; } const rewards = brModelSelection .model({ days: d }) .map( (d, day) => (day >= d0 && filPlus ? 10 : 1) * rewardPerGiB(d, 20.2) * size * FIL ); const reward = d3.sum(rewards); // const reward = // BR(size) * d0 * FIL + (filPlus ? 10 : 1) * BR(size) * (d - d0) * FIL; const costs = []; if (newSector) { // costs.push({ type: "Cost_provecommit ", value: Cost_ccprovecommit }); costs.push({ type: "seal", value: Cost_ccseal, source: "proofs", day: 0 }); costs.push({ type: "pcprove", value: Cost_ccproving, day: 0 }); costs.push({ type: "pcgas", value: Cost_ccgas, source: "gas", day: 0 }); } if (!pureCC) { costs.push({ type: "snapembed", value: Cost_snapembed, day: d0 }); costs.push({ type: "snapprove", value: Cost_snapproving, day: d0 }); costs.push({ type: "snapgas", value: Cost_snapgas, day: d0 }); costs.push({ type: "snapextra", value: Cost_snapextra, day: d0 }); costs.push({ type: "data", value: Cost_data, day: d0 }); costs.push({ type: "deal", value: Cost_deal, day: d0 }); } costs.push({ type: "B", value: Cost_B(t), day: 0 }); costs.push({ type: "S", value: Cost_S * d, day: 0 }); costs.push({ type: "M", value: Cost_M(t) * d, day: 0 }); let lending_cost = 0; if (lending) { lending_cost = IP_cc(t) * Cost_L(t) * d0 + (filPlus ? IP_filplus(t) : IP_cc(t)) * Cost_L(t) * (d - d0); } costs.push({ type: "lending", value: lending_cost, day: 0 }); const cost = costs.reduce((acc, curr) => acc + curr.value, 0); const profit = reward - cost; return { profit, reward, cost, costs, name, rewards, arr: ARR(cost, profit, d / 365), roi: totalReturn(cost, profit, d / 365), }; }4c:T51c,function dealSector({ d, d0, size, t, lending = true, name }) { const rewards = brModelSelection .model({ days: d }) .map((d, day) => (day >= d0 ? rewardPerGiB(d, 20.2) * size * 10 * FIL : 0)); const reward = d3.sum(rewards); // const reward = (d - d0) * 10 * BR(size) * FIL; const costs = []; costs.push({ type: "data", value: Cost_data, day: d0 }); costs.push({ type: "deal", value: Cost_deal, day: d0 }); // costs.push({ type: "Cost_provecommit ", value: Cost_dprovecommit }); costs.push({ type: "seal", value: Cost_dseal, day: d0 }); costs.push({ type: "pcprove", value: Cost_dproving, day: d0 }); costs.push({ type: "pcgas", value: Cost_dgas, day: d0 }); costs.push({ type: "B", value: Cost_B(t), day: d0 }); costs.push({ type: "S", value: Cost_S * (d - d0), day: d0 }); costs.push({ type: "M", value: Cost_M(t) * (d - d0), day: d0 }); let lending_cost = 0; if (lending) { lending_cost = IP_filplus(t) * Cost_L(t) * (d - d0); } costs.push({ type: "lending", value: lending_cost, day: d0 }); const cost = costs.reduce((acc, curr) => acc + curr.value, 0); const profit = reward - cost; return { profit, reward, cost, costs, name, rewards, arr: ARR(cost, profit, d / 365), roi: totalReturn(cost, profit, d / 365) }; }4d:[] 29:{"id":"bccb783ff3f422cc","slug":null,"title":"Analysis: SP ROI Calculator (WIP)","thumbnail":"464c84cba8f12b1772f1e86b8bcae9c39e7d3236471d0796b60e066b4e4cc86c","access_level":"public","create_time":"$D2023-05-25T16:04:03.426Z","update_time":"$D2023-05-25T16:04:03.426Z","view_time":null,"first_public_time":"$D2023-05-25T16:04:03.426Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"3c11114b01b5b2b7","login":"vvk","name":"vvk","avatar_url":"https://avatars-next.observableusercontent.com/ba879617805b489c1de148fc9d03aa3e3105ab5823ba6d518fce81dc4b7dd90b","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":2279,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"ce1fdda78327969d","login":"vvk","name":"vvk","avatar_url":"https://avatars-next.observableusercontent.com/ba879617805b489c1de148fc9d03aa3e3105ab5823ba6d518fce81dc4b7dd90b","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"ce1fdda78327969d","login":"vvk","name":"vvk","avatar_url":"https://avatars-next.observableusercontent.com/ba879617805b489c1de148fc9d03aa3e3105ab5823ba6d518fce81dc4b7dd90b","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Analysis: SP ROI Calculator (WIP)","cells":[{"id":0,"value":"# Analysis: SP ROI Calculator (WIP)\n*Author: [Cryptonet Intelligence](https://cryptonet.org)*\n\nUse this at your own risk.\n\nThere are two pipelines to on-board FIL+ data:\n* **Deal Sector Pipeline:** Storage Providers wait to receive FIL+ data to fill a sector before sealing it and adding it to the network\n* **CC Sector Upgrade Pipeline:** Storage Providers seal a sector, add it to the network and then update it with FIL+ sector","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1603,"value":"## Assumptions\n* Deal duration (and FIL+ claim) covers the entire sector lifetime","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":914,"value":"## Demos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1008,"value":"* `cc existing fil+`: An existing CC sector gets upgraded with FIL+\n* `cc fil+`: A new CC sector is upgraded with FIL+ after `d0` days\n* `cc pure`: A new CC sector with no upgrade\n* `deal sector`: A sector with FIL+ deals that is published after `d0` days","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":26,"value":"viewof FIL = Inputs.range([0, 100], {\n step: 0.01,\n value: 5.16,\n label: \"Filecoin Price\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":945,"value":"viewof d0 = Inputs.range([0, 500], {\n step: 1,\n value: 20,\n label: \"d0, time to FIL+ sector\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":973,"value":"viewof dYear = Inputs.range([0.1, 5], {\n step: 0.01,\n value: (365 * 5) / 365,\n label: \"d, sector duration in years\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1269,"value":"viewof lendingR = Inputs.range([0, 100], {\n step: 1,\n value: 20,\n label: \"lending rate\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1359,"value":"viewof storageSelection = {\n return Inputs.select(storageCosts, {\n label: html`Storage Cost`,\n format: (d) =>\n `${d.source} ${d3.format(\"$0.6f\")(\n d.costPer32GiBSectorPerDay\n )} / 32GiB-sector /24h`\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1414,"value":"viewof sealingSelection = {\n return Inputs.select(sealingCosts, {\n label: html`Sealing Cost`,\n format: (d) =>\n `${d.source} ${d3.format(\"$0.3f\")(d.sealingCost)} / 32GiB-sector`\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1666,"value":"viewof provingSelection = {\n return Inputs.select(provingCosts, {\n label: html`Proving Cost`,\n format: (d) => `${d.source} ${d3.format(\"$0.3f\")(d.cost)} / sector`\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1595,"value":"viewof snapDealGasReduction = Inputs.range([0, 1], {\n step: 0.05,\n value: 0,\n label: \"% of snap deal gas cost reduction (hypotethical)\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1692,"value":"viewof brModelSelection = {\n return Inputs.select(brModels, {\n label: html`Block Reward Model`,\n format: (d) => d.name\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1037,"value":"

[See definitions](https://observablehq.com/d/c492019c9cea5217#cell-11)

${costPlot.legend(\"color\")}

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1207,"value":"

\n ${costPlot}\n \n

\n ${profitAmortizedPlot}\n \n

\n ${profitDiffPlot}\n \n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":835,"value":"breakdownCosts = Plot.plot({\n caption: \"Figure 4: Breakdown by type of cost\",\n height: 300,\n width: width,\n color: {\n scheme: \"BrBG\"\n },\n x: {\n tickRotate: 0\n },\n y: {\n grid: true\n },\n marks: [\n Plot.barY(\n dataCosts.map((d) => ({ ...d, source: costsMap[d.type] || \"empty\" })),\n {\n fx: \"demo\",\n x: \"source\",\n y: \"value\",\n fill: \"type\",\n sort: (a, b) => b.value - a.value,\n title: (d) => `${d.type} ${d.value}`\n }\n ),\n Plot.textY(\n dataCosts.map((d) => ({ ...d, source: costsMap[d.type] || \"empty\" })),\n Plot.stackY({\n fx: \"demo\",\n y: \"value\",\n textAnchor: \"middle\",\n x: \"source\",\n text: (d) => `${d.type}\\n${d3.format(\"0.2f\")(d.value)}`,\n fontSize: 8,\n filter: (d) => d.value > 0.03,\n sort: (a, b) => b.value - a.value\n // fill: (d) => \"#fff\"\n })\n ),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1465,"value":"yearCosts = {\n const data = dataRewardsYear.map((d) => ({\n ...d,\n profit: d.profit / d.cost,\n cost: 1\n }));\n return Plot.plot({\n caption:\n \"Figure 5: Profitability for a sector lifetime (annualized returns per $ invested)\",\n height: 300,\n width: width,\n color: {\n // scheme: \"BrBG\"\n },\n x: {\n ticks: d3.range(dYear + 1),\n label: \"sector lifetime\"\n },\n y: {\n grid: true\n },\n marks: [\n Plot.barY(data, {\n fx: \"demo\",\n x: \"year\",\n y: \"profit\",\n fill: \"demo\",\n sort: (a, b) => b.year - a.year\n // title: (d) => `${d.type} ${d.value}`\n }),\n Plot.textY(data, {\n fx: \"demo\",\n y: \"profit\",\n x: \"year\",\n text: (d) =>\n [\n d3.format(\".2f\")(d.profit),\n d3.format(\".2%\")(d.arr),\n d3.format(\".2%\")(d.roi)\n ].join(\"\\n\"),\n fontSize: 8,\n dy: -15\n }),\n Plot.ruleY([0], { strokeWidth: 3 })\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2243,"value":"Note that the following graph assumes that all the costs are upfront","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1890,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":924,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1431,"value":"ARR = (p, g, y) => totalReturn(p, g) * (1 / y)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1292,"value":"totalReturn = (principal, gains) => gains / principal","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1259,"value":"### Graphs","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1560,"value":"profitAmortizedPlot = Plot.plot({\n caption: \"Figure 2: Profit break down (per $ invested)\",\n height: 300,\n width: 300,\n y: {\n grid: true,\n label: \"↑\\nprofit\\narr\\nroi\"\n },\n marks: [\n Plot.barY(dataRewardsAmortized, {\n x: \"demo\",\n y: \"profit\",\n title: (d) => `${d.profit}`,\n fill: \"#ffc850\"\n }),\n Plot.textY(dataRewardsAmortized, {\n y: \"profit\",\n x: \"demo\",\n text: (d) =>\n [\n d3.format(\".2f\")(d.profit),\n d3.format(\".2%\")(d.arr),\n d3.format(\".2%\")(d.roi)\n ].join(\"\\n\"),\n fontSize: 8,\n dy: -8\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"costPlot = Plot.plot({\n title: \"Figure\",\n height: 300,\n width: 400,\n y: { grid: true },\n color: {\n scheme: \"BrBG\"\n },\n caption: \"Figure 1: Cost breakdown\",\n marks: [\n Plot.barY(dataCosts, {\n x: \"demo\",\n y: \"value\",\n fill: \"type\",\n sort: (a, b) => b.value - a.value,\n title: (d) => `${d.type} ${d.value}`\n }),\n Plot.textY(dataRewards, {\n y: \"cost\",\n x: \"demo\",\n text: \"cost\",\n dy: -9,\n fontSize: 9\n }),\n Plot.textY(\n dataCosts,\n Plot.stackY({\n y: \"value\",\n textAnchor: \"middle\",\n x: \"demo\",\n text: (d) => `${d.type} ${d3.format(\"0.2f\")(d.value)}`,\n fontSize: 9,\n filter: (d) => d.value > 0.05,\n sort: (a, b) => b.value - a.value\n })\n ),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1162,"value":"profitDiffPlot = {\n const baseline = dataRewards[0].roi;\n const data = dataRewards.map((d) => ({ ...d, roi: d.roi / baseline - 1 }));\n return Plot.plot({\n caption: \"Figure 3: Total ROI difference from deal sector\",\n height: 300,\n width: 300,\n y: {\n grid: true,\n label: \"↑ roi diff\"\n },\n marks: [\n Plot.barY(data, {\n x: \"demo\",\n y: \"roi\",\n title: (d) => `${d.profit}`,\n fill: (d) => (d.roi > 0 ? \"green\" : \"red\")\n }),\n Plot.textY(data, {\n y: \"roi\",\n x: \"demo\",\n text: (d) => `${d3.format(\"0.2%\")(d.roi)}`,\n fontSize: 8,\n dy: -8\n }),\n Plot.ruleY([0])\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":901,"value":"## Demos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":749,"value":"existingCCDemo = (d, d0) =>\n ccSector({\n d: d,\n d0: d0,\n size: 32,\n filPlus: true,\n newSector: false,\n t: 0,\n lending: true,\n name: \"cc existing fil+ \"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"pureCCDemo = (d, d0) =>\n ccSector({\n d: d,\n d0: d0,\n pureCC: true,\n size: 32,\n newSector: true,\n t: 0,\n lending: true,\n name: \"cc pure\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1551,"value":"pureCCNoLendingDemo = (d, d0) =>\n ccSector({\n d: d,\n d0: d0,\n pureCC: true,\n size: 32,\n newSector: true,\n t: 0,\n lending: false,\n name: \"cc no lend\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"upgradedCCDemo = (d, d0) =>\n ccSector({\n d: d,\n d0: d0,\n size: 32,\n filPlus: true,\n newSector: true,\n t: 0,\n lending: true,\n name: \"cc fil+ \"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"dealDemo = (d, d0) =>\n dealSector({\n d: d,\n d0: d0,\n size: 32,\n t: 0,\n lending: true,\n name: \"deal sector\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":788,"value":"existingPureCCDemo = ccSector({\n d: d,\n d0: d0,\n size: 32,\n filPlus: false,\n newSector: true,\n t: 0,\n lending: true,\n name: \"cc existing pure\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"TODO:\n- [ ] Generalize beyond 32 GiB\n- [x] Add BR rewards\n- [ ] Add transfer costs\n- [x] Batch balancer missing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"$4a","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":24,"value":"function BR(sizeGiB) {\n const rewardPerTiB = 0.0096; // https://filfox.info/en\n\n if (sizeGiB === 32) {\n return rewardPerTiB / 32;\n }\n if (sizeGiB === 64) {\n return rewardPerTiB / 16;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"Note that BR in this version is fixed, we should model it better.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":235,"value":"Shared costs","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":888,"value":"## Parameters","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":155,"value":"Cost_B = (t) => 0 * t //cost of bandwidth","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"Cost_L = (t) => lendingR / 100 / 365 // const of lending 1$ for a day assuming 365 days lending window","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":313,"value":"IP_cc = (t) => 0.2 * FIL //IP for CC sector","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"IP_filplus = (t) => 10 * IP_cc(t) // IP for sector with deals","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"Cost_M = (t) => WindowedPoStPerDay + Operational_cost","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1396,"value":"Cost_S = storageSelection.costPer32GiBSectorPerDay","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"Cost_dataOp = 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"Cost_dataLat = 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"Cost_data = Cost_dataOp + Cost_dataLat","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":169,"value":"Cost_dealLat = 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"Cost_dealGas = (0.1992 / 5.22) * FIL // ~128,000,000","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"Cost_deal = Cost_dealOp + Cost_dealLat + Cost_dealGas","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":575,"value":"Cost_dealOp = 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"SubmitWindowedPoSt = 0.0171 * FIL // overestimated given we count only 1 partition submitted at a time, ppl are using submitting multiple partitions at a time","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"WindowedPoStPerDay = WindowPoStGas + WindowPoStSnark // amortized WindowedPoSt gas + WindowedPoSt snark.","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":769,"value":"WindowPoStGas = gasCosts.avg_windowpost_per_sector * FIL // SubmitWindowedPoSt / 2349 // TODO spaceport bug","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1680,"value":"gasCosts.avg_windowpost_per_sector * FIL","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":766,"value":"WindowPoStSnark = Cost_C2 / 10 / 2349","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"Operational_cost = 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"Cost_C2 = 0.1006 //C2 costs pre SN improvements","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"\nCC Sectors\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":201,"value":"Cost_ccseal = Cost_dseal // PC1 cost pre SN improvements\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"Cost_ccproving = Cost_dproving //PC2 + C2 pre SN improvements\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"Cost_ccgas = Cost_dgas // PreCommit + ProveCommit from FilFox\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":208,"value":"Cost_snapproving = Cost_dproving/2 // Snap snark assuming snapping ~ C2","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"Cost_snapgas = 0.075 * (1 - snapDealGasReduction) * FIL // ProveReplicaUpdates cost from FilFox (overestimation, given we assume SP are submitting a single snapdeal proof at a time. to be verified)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"Cost_snapembed = 0 //cost of embedding data into existing CC sector","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"Cost_snapextra = (Cost_S / 2880) * 900 // 0.000003 // cost of maintaining the old CC sector for 900 epochs","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"Sector Natively with deals","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":141,"value":"Cost_dseal = sealingSelection.sealingCost","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"Cost_dproving = provingSelection.cost // 0.2012","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"Cost_dgas = (gasCosts.avg_precommit_per_sector_min +\n gasCosts.avg_provecommit_per_sector_min) *\n FIL // (0.0355 + 0.015) * FIL","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"Cost_dprovecommit = Cost_dseal + Cost_dproving + Cost_dgas","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"Cost_ccprovecommit = Cost_ccseal + Cost_ccproving + Cost_ccgas","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":813,"value":"costsMap = ({\n snapgas: \"gas\",\n seal: \"proofs\",\n pcprove: \"snarks\",\n pcgas: \"gas\",\n snapembed: \"proofs\",\n snapprove: \"snarks\",\n snapgas: \"gas\",\n snapextra: \"storage\",\n data: \"ops\",\n deal: \"gas\",\n B: \"ops\",\n S: \"storage\",\n M: \"gas\",\n lending: \"fil\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"## Model: CC Sector","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"$4b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":897,"value":"## Model: Deal Sector","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":98,"value":"$4c","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":907,"value":"## Graphs","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1452,"value":"dataCosts = dataCostsF(d, d0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2268,"value":"demos = [\n dealDemo(d, d0),\n upgradedCCDemo(d, d0),\n existingCCDemo(d, d0),\n pureCCDemo(d, d0)\n // pureCCNoLendingDemo(d, d0)\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"dataCostsF = (d, d0) =>\n demos\n .map((d, i) => d.costs.map((v) => ({ ...v, demo: d.name || `demo-${i}` })))\n .flat()\n .filter((d) => d.value > 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1454,"value":"dataRewards = dataRewardsF(d, d0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":419,"value":"dataRewardsF = (d, d0) =>\n demos.map((d, i) => ({\n ...d,\n demo: d.name || `demo-${i}`\n }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1600,"value":"dataRewardsAmortized = dataRewards.map((d) => ({\n ...d,\n profit: d.profit / d.cost,\n cost: 1\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1457,"value":"dataRewardsYear = [...Array(5)]\n .map((_, dYear) =>\n dataRewardsF((dYear + 1) * 365, d0).map((v) => ({\n ...v,\n year: dYear + 1\n }))\n )\n .flat()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2110,"value":"function generateHistory({ costs, rewards }, d) {\n // return dealDemo;\n const costsHistory = d3.rollup(\n costs,\n (d) => ({\n day: d[0].day,\n history: d,\n value: d3.sum(d, (d) => d.value)\n }),\n (d) => d.day\n );\n const history = d3\n .range(d)\n .map((i) => ({\n day: i,\n reward: rewards[i],\n cost: costsHistory.get(i)?.value || 0\n }))\n .map((d) => ({ ...d, profit: d.reward - d.cost }));\n\n const cumHistory = history.reduce(\n (acc, curr, day) =>\n acc.concat({\n day,\n reward: (acc[acc.length - 1]?.reward || 0) + curr.reward,\n cost: (acc[acc.length - 1]?.cost || 0) + curr.cost,\n profit: (acc[acc.length - 1]?.profit || 0) + curr.profit\n }),\n []\n );\n return {\n costsHistory,\n history,\n cumHistory\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":781,"value":"md`TODO: show that current gas is limiting FIL price`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":666,"value":"## Misc","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":977,"value":"d = dYear * 365","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":581,"value":"Plot.plot({\n height: 300,\n legend: true,\n color: {\n legend: true,\n scheme: \"BrBG\",\n type: \"categorical\"\n // domain: [],\n // range: [],\n },\n marks: [\n Plot.barY(\n dataCosts.map((d) => ({ ...d, value: -d.value })),\n {\n fx: \"demo\",\n y: \"value\",\n fill: \"type\"\n }\n ),\n Plot.barY(\n dataRewards.map((d) => ({\n demo: d.demo,\n type: \"reward\",\n value: d.reward\n })),\n {\n fx: \"demo\",\n y: \"value\",\n fill: \"type\"\n }\n ),\n Plot.ruleY(dataRewards, { y: \"profit\", stroke: \"black\", fx: \"demo\" }),\n Plot.textY(dataRewards, {\n y: \"profit\",\n fx: \"demo\",\n dy: -5,\n text: [\"Profit\", \"Profit\", \"Profit\"]\n })\n // Plot.ruleX(seattle, {x: \"date\", y1: \"temp_min\", y2: \"temp_max\", stroke: \"temp_max\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1402,"value":"import { provingCosts } from \"1679e6b422a2ceac\";","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1361,"value":"import { storageCosts } from \"8fdeea85535907e7\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1635,"value":"import { sealingCosts } from \"e9f86c66060711e4\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1638,"value":"import { gasCosts } from \"8753bb69b3b2120e\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1695,"value":"import { models as brModels, rewardPerGiB } from \"@protocol/econ-br-models\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 24:null