2f:T680,getChart = ()=>{ const dates = dailyCumSumMinerCumSumRewards.map((x,idx) => { var dateTime=new Date(); dateTime=dateTime.setDate(dateTime.getDate()+idx); dateTime=new Date(dateTime); return dateTime; }) var cumSumMinerInvestment = { x: dates, y: (radios == "USD" ? fiatDailyMinerInvestmentChart : dailyMinerInvestmentChart ), name: 'Total Investments', mode: 'lines', }; var cumSumMinerRevenue = { x: dates, y: (radios == "USD" ? fiatDailyMinerRevenueChart : dailyMinerRevenueChart), name: 'Total Revenues', mode: 'lines' }; var cumSumMinerTotalCost = { x: dates, y: (radios == "USD" ? fiatDailyMinerTotalCostChart : dailyMinerTotalCostChart), name: 'Total Costs', mode: 'lines' }; var cumSumMinerProfit = { x: dates, y: (radios == "USD" ? fiatDailyMinerProfitChart : dailyMinerProfitChart), name: 'Total Profits', mode: 'lines' }; var datas = [cumSumMinerInvestment, cumSumMinerRevenue,cumSumMinerTotalCost,cumSumMinerProfit]; chart2Data.shift(); chart2Data.push({dailyMinerInvestmentChart:dailyMinerInvestmentChart,dailyMinerRevenueChart:dailyMinerRevenueChart,dailyMinerTotalCostChart:dailyMinerTotalCostChart,dailyMinerProfitChart:dailyMinerProfitChart}) var layout = { title: 'Storage Provider Income Statement (' + radios + ')', xaxis: { title: 'Date', }, yaxis: { title: radios, }, width: width, showlegend: true, legend: { orientation:"h", x: 0.01, xanchor: 'left', y: 1.1 } }; const div = DOM.element('div'); Plotly.newPlot(div, datas, layout); return div }30:T614,{ const dates = dailyCumSumMinerCumSumRewards.map((x,idx) => { var dateTime=new Date(); dateTime=dateTime.setDate(dateTime.getDate()+idx); dateTime=new Date(dateTime); return dateTime; }) var cumSumMinerCumSumRewards = { x: dates, y: dailyCumSumMinerCumSumRewards, name: 'Total Block Rewards', mode: 'lines', }; var cumSumMinerTotalPledge = { x: dates, y: dailyCumSumMinerTotalPledge, name: 'Total Pledges', mode: 'lines' }; var cumSumMinerLockedRewards = { x: dates, y: dailyCumSumMinerLockedRewards, name: 'Total Locked Rewards', mode: 'lines' }; var cumSumMinerReleasedRewards = { x: dates, y: dailyCumSumMinerReleasedRewards, name: 'Total Released Rewards', mode: 'lines' }; var datas = [cumSumMinerCumSumRewards, cumSumMinerTotalPledge,cumSumMinerLockedRewards,cumSumMinerReleasedRewards]; chart1Data.shift() chart1Data.push({dailyCumSumMinerCumSumRewards:dailyCumSumMinerCumSumRewards,dailyCumSumMinerTotalPledge:dailyCumSumMinerTotalPledge,dailyCumSumMinerLockedRewards:dailyCumSumMinerLockedRewards,dailyCumSumMinerReleasedRewards:dailyCumSumMinerReleasedRewards}) var layout = { title: 'On-Chain Rewards and Pledges', xaxis: { title: 'Date', }, yaxis: { title: 'FIL', }, width: width, showlegend: true, legend: { orientation:"h", x: 0.01, xanchor: 'left', y: 1.1 } }; const div = DOM.element('div'); Plotly.newPlot(div, datas, layout); return div }31:T4b8,html`

Total block rewards are: ${(dailyCumSumMinerCumSumRewards[dailyCumSumMinerCumSumRewards.length -1]).toFixed(2)} FIL

Total pledges are: ${(dailyCumSumMinerTotalPledge[dailyCumSumMinerTotalPledge.length -1]).toFixed(2)} FIL

Annualized FIL-on-FIL return is: ${((Math.pow((1 + dailyCumSumMinerCumSumRewards[dailyCumSumMinerCumSumRewards.length -1] / dailyCumSumMinerTotalPledge[dailyCumSumMinerTotalPledge.length -1]), 12 / forecastMonth) - 1) * 100).toFixed(2) } %

Annualized storage ROI(FIL Based) is: ${((Math.pow((1 + totalProfit / totalInvestments), 12 / forecastMonth) - 1) * 100).toFixed(2) } %

`32:T565,

Total revenues are: ${(fiatDailyMinerRevenueChart[fiatDailyMinerRevenueChart.length - 1]).toFixed(2)} USD

Total deal revenues are: ${(fiatDailyCumSumDealFee[fiatDailyCumSumDealFee.length - 1]).toFixed(2)} USD

Total hardware CAPEX are: ${(hardwareInvestmentsUSD).toFixed(2)} USD

Total USD profits are: ${(fiatDailyMinerProfitChart[fiatDailyMinerProfitChart.length - 1]).toFixed(2) } USD

Annualized storage ROI(USD Based) is: ${((Math.pow((1 + fiatDailyMinerProfitChart[fiatDailyMinerProfitChart.length - 1] / fiatDailyMinerInvestmentChart[fiatDailyMinerInvestmentChart.length - 1]), 12 / forecastMonth) - 1) * 100).toFixed(2) } %

33:T1f1f,calculator = () =>{ let result = { test: [] , epochInDay : epochInDay, epochNetRBP : epochNetRBP, epochNetQAP : epochNetQAP, epochNetBasePower : epochNetBasePower, epochNetStoragePledge : epochNetStoragePledge, epochNetStorageConsensusPledge : epochNetStorageConsensusPledge, epochNetInitialPledge : epochNetInitialPledge, epochNetDealPledge : epochNetDealPledge, epochCumSumRealized : Number(epochCumSumRealized), epochNetNewReward : epochNetNewReward, epochNetMinedFIL : Number(epochNetMinedFIL), epochNetLockedFIL : Number(epochNetLockedFIL), epochNetRewardLocked : Number(epochNetRewardLocked), epochNetBurntFIL : Number(epochNetBurntFIL), epochNetVestedFIL : Number(epochNetVestedFIL), epochNetCircFIL : Number(epochNetCircFIL), epochNetReserveDisbursed : Number(epochNetReserveDisbursed), epochNetRewardFilter : new abFilter(epochNetRewardPosition, epochNetRewardVelocity), epochNetPowerFilter : new abFilter(epochNetQAPowerPosition, epochNetQAPowerVelocity), epochMinerRBP : epochMinerRBP, epochMinerQAP : epochMinerQAP, epochMinerStoragePledge : Number(epochMinerStoragePledge), epochMinerConsensusPledge : Number(epochMinerConsensusPledge), epochMinerInitialPledge : epochMinerInitialPledge, epochMinerDealPledge : epochMinerDealPledge, dailyMinerTotalPledge : Array.from({length:projectedDays.length},()=>(0)), dailyMinerCumSumRewards : dailyMinerCumSumRewards.map(x=>x), dailyMinerTotalCost : dailyMinerTotalCost.map(x=>x), dailyMinerReleasedRewards : dailyMinerReleasedRewards.map(x=>x), dailyMinerLockedRewards : dailyMinerLockedRewards.map(x=>x), dailyMinerInvestment : dailyMinerInvestment.map(x=>x), dailyMinerProfit : dailyMinerProfit.map(x=>x), projectedVerifiedStoragePercent : projectedVerifiedStoragePercent, dailyNetBurn : dailyNetBurn.map(x=>x), dailyMinerDeals: dailyMinerDeals.map(x=>x), cumMinerLockedReward: 0, cumMinerReleasedReward: 0, } projectedDays.map((x,day)=>{ if(day == 0) return; //grab daily power difference and compute epoch-based power growth let epochNetRBPGrowth = (dailyNetRBP[day] - dailyNetRBP[day - 1]) / epochInDay let epochNetQAPGrowth = (dailyNetQAP[day] - dailyNetQAP[day - 1]) / epochInDay //start calculations epoch-wise for(let index = 0; index < epochInDay; index++){ // update the current epoch let epoch = Number(epochStart) + ((day - 1) * epochInDay) + index // update the network for the current epoch // update network power result.epochNetRBP = Number(result.epochNetRBP) + epochNetRBPGrowth result.epochNetQAP = Number(result.epochNetQAP) + epochNetQAPGrowth result.epochNetBasePower = getBaselineByEpoch(epoch) // update network pledge terms let epochPerQAPCircSupply = result.epochNetCircFIL / Math.max(result.epochNetQAP, result.epochNetBasePower) result.epochNetStoragePledge = Math.max(epochNetQAPGrowth * extrapolateCumsumRatio(result.epochNetRewardFilter, result.epochNetPowerFilter, 20 * epochInDay ), 0) result.epochNetStorageConsensusPledge = Math.max(epochPerQAPCircSupply * 0.3 * epochNetQAPGrowth, 0) result.epochNetInitialPledge = Number(result.epochNetStoragePledge) + Number(result.epochNetStorageConsensusPledge) let epochPerRBPCircSupply = result.epochNetCircFIL / Math.max(result.epochNetRBP, result.epochNetBasePower) result.epochNetDealPledge = Math.max(result.projectedVerifiedStoragePercent * epochPerRBPCircSupply * 0.01 * epochNetRBPGrowth, 0) // update rewards and mint new tokens let epochPrevNetTimeEpoch = derive_network_time(result.epochCumSumRealized) result.epochCumSumRealized += Math.min(result.epochNetBasePower, result.epochNetRBP) let epochCurrNetTimeEpoch = derive_network_time(result.epochCumSumRealized) result.epochNetNewReward = computeBlockReward(epoch, epoch - 1, epochCurrNetTimeEpoch, epochPrevNetTimeEpoch) // update the network circulating supply values result.epochNetMinedFIL += result.epochNetNewReward // keep mining result.epochNetLockedFIL += (0.75 * result.epochNetNewReward + result.epochNetDealPledge + result.epochNetInitialPledge) // lock up the pledge // modify the logic here result.epochNetLockedFIL -= result.epochNetRewardLocked / 180 / epochInDay // release part of the rewards result.epochNetRewardLocked += 0.75 * result.epochNetNewReward // lock away new rewards result.epochNetRewardLocked -= result.epochNetRewardLocked / 180 / epochInDay // release part of the rewards result.epochNetBurntFIL += result.dailyNetBurn[day] / epochInDay result.epochNetVestedFIL += getVestOnEpoch(epoch) result.epochNetCircFIL = result.epochNetReserveDisbursed + result.epochNetMinedFIL + result.epochNetVestedFIL - result.epochNetLockedFIL - result.epochNetBurntFIL // update ab filters epochNetLockedFIL result.epochNetRewardFilter.update(result.epochNetNewReward, 1) result.epochNetPowerFilter.update(result.epochNetQAP, 1) // update the miners for this epoch // if we're still sealing, then add up pledges if (epoch <= daysForSealing * epochInDay + Number(epochStart)){ // onboarding storage power result.epochMinerRBP += epochMinerRBPGrowth result.epochMinerQAP += epochMinerQAPGrowth // accumulate pledges result.epochMinerStoragePledge = epochMinerQAPGrowth * extrapolateCumsumRatio(result.epochNetRewardFilter, result.epochNetPowerFilter, 20 * epochInDay ) result.epochMinerConsensusPledge = (epochMinerQAPGrowth / Math.max(result.epochNetQAP, result.epochNetBasePower)) * result.epochNetCircFIL * 0.3 result.epochMinerInitialPledge = result.epochMinerStoragePledge + result.epochMinerConsensusPledge result.epochMinerDealPledge = (verifiedPercentage * epochMinerRBPGrowth / Math.max(result.epochNetRBP, result.epochNetBasePower)) * result.epochNetCircFIL * 0.01 / 100 // aggregate the pledges daily result.dailyMinerTotalPledge[day] = result.dailyMinerTotalPledge[day] + result.epochMinerInitialPledge + result.epochMinerDealPledge } // mint and assign new rewards result.dailyMinerCumSumRewards[day] = result.dailyMinerCumSumRewards[day] + (result.epochMinerQAP / result.epochNetQAP) * result.epochNetNewReward result.test = result.cumMinerLockedReward + " " + result.epochMinerQAP + " " +result.epochNetQAP + " " +result.epochNetNewReward } // update EOD power result.dailyMinerDeals[day] = result.epochMinerRBP * verifiedPercentage * 0.01 // update the daily balance sheet items //// get the cumulative sum of the rewards result.dailyMinerReleasedRewards[day] += 0.25 * result.dailyMinerCumSumRewards[day] + result.cumMinerLockedReward / 180 result.dailyMinerLockedRewards[day] += 0.75 * result.dailyMinerCumSumRewards[day] - result.cumMinerLockedReward / 180 result.cumMinerLockedReward += result.dailyMinerLockedRewards[day] result.cumMinerReleasedReward += result.dailyMinerReleasedRewards[day] result.dailyMinerInvestment[day] += result.dailyMinerTotalPledge[day] result.dailyMinerProfit[day] += result.dailyMinerCumSumRewards[day] - result.dailyMinerTotalCost[day] }) return result }34:[] 2d:{"title":"Filecoin Storage Provider Return Calculator","cells":[{"id":1424,"value":"# Filecoin Storage Provider Return Calculator","pinned":false,"hidden":false,"mode":"md"},{"id":1431,"value":"## Disclaimer: Starboard Networks shall not be liable for any loss of profits or revenues, whether directly or indirectly, as a result of this dashboard.","pinned":false,"hidden":false,"mode":"md"},{"id":1803,"value":"**Income Statement Reporting Currency**","pinned":false,"hidden":false,"mode":"md"},{"id":1800,"value":"viewof radios = Inputs.radio([\"USD\", \"FIL\"], {label: \"\",value:'USD'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1684,"value":"getChart()","pinned":false,"hidden":false,"mode":"ojs"},{"id":2085,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":878,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1326,"value":"chart1Data =[]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1445,"value":"chart2Data = []","pinned":false,"hidden":false,"mode":"ojs"},{"id":1839,"value":"**Expect Sale Price (USD / FIL)**: expected price at which to sell the mined rewards","pinned":false,"hidden":false,"mode":"md"},{"id":1832,"value":"viewof expectSalePrice = Inputs.range([0, 500], {step:0.5 , value: filPriceToday })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1099,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":2023,"value":"$32","pinned":false,"hidden":false,"mode":"html"},{"id":940,"value":"## Network Assumptions\n## User Inputs and Parameters","pinned":false,"hidden":false,"mode":"md"},{"id":1272,"value":"**Forecast Period (Month)**: ","pinned":false,"hidden":false,"mode":"md"},{"id":948,"value":"viewof forecastMonth = Inputs.range([6, 60], { step:1 , value:18 }) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1277,"value":"**Projected Monthly Network Growth (%)**: Projected network raw byte storage capacity growth","pinned":false,"hidden":false,"mode":"md"},{"id":951,"value":"viewof projectedNetGrowthMonthlyInput = Inputs.range([-20, 10], {step:0.01 , value: growth })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1282,"value":"**Projected Verified Storage Percent(%)**: The projected average percentage of total storage capacity that stores verified deals over the forecast period.","pinned":false,"hidden":false,"mode":"md"},{"id":954,"value":"viewof projectedVerifiedStoragePercentInput = Inputs.range([0, 20], {step:0.01 , value:0.25 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1287,"value":"**Projected Monthly Burn (M-FIL)** The projected amount of FIL burned per month the forecast period: ","pinned":false,"hidden":false,"mode":"md"},{"id":957,"value":"viewof projectedNetBurnMonthlyInput = Inputs.range([0, 1], {step:0.01 , value:0.07 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":965,"value":"## Storage Provider Business Assumptions\n## User Inputs and Parameters\n### Power Commit and Sealing Capacity","pinned":false,"hidden":false,"mode":"md"},{"id":1382,"value":"**Total Raw Byte Capacity Commitment (PiB)**: Total amount of storage bytes planned to commit into the network","pinned":false,"hidden":false,"mode":"md"},{"id":971,"value":"viewof totalPowerToCommitInput = Inputs.range([0, 200], {step:1 , value:10})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1387,"value":"**Daily Sealing Capacity (TiB)**: Maximum Sector Sealing Capacity on a Daily Basis","pinned":false,"hidden":false,"mode":"md"},{"id":974,"value":"viewof dailySealingCapacityInput = Inputs.range([0, 2000], {step:1 , value:28})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1391,"value":"**Projected % of Storage in Filecoin+(%)**: The projected average percentage of total storage capacity that stores verified deals over the forecast period.","pinned":false,"hidden":false,"mode":"md"},{"id":977,"value":"viewof verifiedPercentage = Inputs.range([0, 100], {step:0.01 , value:20 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":981,"value":"### Hardware Investment and Finance","pinned":false,"hidden":false,"mode":"md"},{"id":1397,"value":"**Capital Borrowed (FIL)**: The total amount of capital borrowed to operate the Filecoin storage business at the beginning of the forecast period","pinned":false,"hidden":false,"mode":"md"},{"id":985,"value":"viewof capitalBorrowed = Inputs.range([0, 5000000], {step:1 , value:25000 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1412,"value":"**Annual Interest Rate (%)**: Annual interest rate for the borrowed capital","pinned":false,"hidden":false,"mode":"md"},{"id":997,"value":"viewof annualInterestRateInput = Inputs.range([0, 100], {step:1 , value:20})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1401,"value":"**Hardware Investments (USD)**: The total amount of hardware investments for the storage capacity commitment","pinned":false,"hidden":false,"mode":"md"},{"id":988,"value":"viewof hardwareInvestmentsUSD = Inputs.range([0, 9000000], {step:1 , value: 650000})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1404,"value":"**Hardware Resale Value (USD)**: The total resale value of the invested hardware at the end of the forecast period","pinned":false,"hidden":false,"mode":"md"},{"id":991,"value":"viewof hardwareResaleValueUSD = Inputs.range([0, 9000000], {step:1 , value: 300000})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1408,"value":"**Monthly Operating Cost (USD)**: Off-chain costs such as labor costs and rents","pinned":false,"hidden":false,"mode":"md"},{"id":994,"value":"viewof monthlyOperatingCostUSD = Inputs.range([0, 2000000], {step:1 , value: 2000})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2090,"value":"### Deal Fees","pinned":false,"hidden":false,"mode":"md"},{"id":2094,"value":"**Storage Deal Fees (USD / TiB Month)**:price charged for storing client deals","pinned":false,"hidden":false,"mode":"md"},{"id":2098,"value":"viewof dealFeePerTibMonth = Inputs.range([0, 50], {step:1 , value: 3})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1009,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":0,"value":"# ROI Calculator","pinned":false,"hidden":false,"mode":"md"},{"id":8,"value":"#### Logic: aggregate daily with states updated on an epoch basis","pinned":false,"hidden":false,"mode":"md"},{"id":21,"value":"## Data API","pinned":false,"hidden":false,"mode":"md"},{"id":2178,"value":"parameters = new Object({\n key: \"v2_cgdo_001\",\n last:true\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2192,"value":"parameters1 = new Object({\n key: \"v2_cgngo_001\",\n last:true\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2165,"value":"import { data } with { parameters as parameters } from \"@starboard/base-table-from-api\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2180,"value":"import { data as data_growth } with { parameters1 as parameters } from \"@starboard/base-table-from-api\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2140,"value":"growth = Number(Number(data_growth.growth).toFixed(2))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1723,"value":"filInfoToday = fetch(\"https://api-observable.herokuapp.com/getCMCFILData\" , {\n method: 'GET',\n redirect: 'follow'\n}).then(response => {\n return response.json();\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2153,"value":"JSON.parse(filInfoToday)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1731,"value":"filPriceToday = JSON.parse(filInfoToday).data[2280].quote.USD.price","pinned":false,"hidden":false,"mode":"ojs"},{"id":943,"value":"## Network Model\n#### User Inputs and Parameters","pinned":false,"hidden":false,"mode":"md"},{"id":1464,"value":"projectedNetGrowthMonthly = projectedNetGrowthMonthlyInput / 100","pinned":false,"hidden":false,"mode":"ojs"},{"id":1471,"value":"projectedVerifiedStoragePercent = projectedVerifiedStoragePercentInput / 100","pinned":false,"hidden":false,"mode":"ojs"},{"id":1743,"value":"hardwareInvestments = hardwareInvestmentsUSD / filPriceToday","pinned":false,"hidden":false,"mode":"ojs"},{"id":1752,"value":"hardwareResaleValue = hardwareResaleValueUSD / filPriceToday","pinned":false,"hidden":false,"mode":"ojs"},{"id":1755,"value":"monthlyOperatingCost = monthlyOperatingCostUSD / filPriceToday","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"#### Network State Variables","pinned":false,"hidden":false,"mode":"md"},{"id":66,"value":"##### State Variables: Storage Capacity","pinned":false,"hidden":false,"mode":"md"},{"id":1483,"value":"annualInterestRate = annualInterestRateInput / 100","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"State Variables Initialization","pinned":false,"hidden":false,"mode":"md"},{"id":188,"value":"epochStart = data.height","pinned":false,"hidden":false,"mode":"ojs"},{"id":192,"value":"projectedDays = Array.from({length:forecastMonth * daysInMonth + 1},(_, i)=>(i))","pinned":false,"hidden":false,"mode":"ojs"},{"id":53,"value":"projectedNetBurnMonthly = projectedNetBurnMonthlyInput * 1e6","pinned":false,"hidden":false,"mode":"ojs"},{"id":74,"value":"epochNetRBP = data.total_raw_bytes_power","pinned":false,"hidden":false,"mode":"ojs"},{"id":76,"value":"onChainNetQAP = data.total_qa_bytes_power","pinned":false,"hidden":false,"mode":"ojs"},{"id":81,"value":"qualityNetPowerAvgMultiplier = 9 * projectedVerifiedStoragePercent + 1 > onChainNetQAP / epochNetRBP ? 9 * projectedVerifiedStoragePercent + 1 : onChainNetQAP / epochNetRBP","pinned":false,"hidden":false,"mode":"ojs"},{"id":84,"value":"epochNetQAP = epochNetRBP * qualityNetPowerAvgMultiplier","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"epochNetQAPowerPosition = data.qa_smoothed_position_estimate / Q128_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":165,"value":"epochNetQAPowerVelocity = data.qa_smoothed_velocity_estimate / Q128_CON ","pinned":false,"hidden":false,"mode":"ojs"},{"id":175,"value":"Daily Aggregation","pinned":false,"hidden":false,"mode":"md"},{"id":178,"value":"dailyNetGrowthSpread = (1 + projectedNetGrowthMonthly) ** (1 / (daysInMonth))","pinned":false,"hidden":false,"mode":"ojs"},{"id":197,"value":"dailyNetRBPInit = projectedDays.map(x=> epochNetRBP * (dailyNetGrowthSpread ** x))","pinned":false,"hidden":false,"mode":"ojs"},{"id":201,"value":"dailyNetQAP = dailyNetRBP.map(x=> x * qualityNetPowerAvgMultiplier )","pinned":false,"hidden":false,"mode":"ojs"},{"id":209,"value":"Alternative Power Aggregations","pinned":false,"hidden":false,"mode":"md"},{"id":213,"value":"dailyNetRBP = dailyNetRBPInit.map((x,idx) => {\n return Number(epochNetRBP) * dailyNetGrowthSpread ** (idx); \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":223,"value":"##### State Variable: Reward\nState Variables Initialization","pinned":false,"hidden":false,"mode":"md"},{"id":228,"value":"epochCumSumRealized = data.cum_sum_realized ","pinned":false,"hidden":false,"mode":"ojs"},{"id":246,"value":"epochNetBasePower = getBaselineByEpoch(epochStart)","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"epochNetNewReward = data.new_reward / ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":262,"value":"epochNetRewardPosition = data.new_reward_smoothed_position_estimate / Q128_CON / ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":265,"value":"epochNetRewardVelocity = data.new_reward_smoothed_velocity_estimate / Q128_CON / ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":230,"value":"Helper Function","pinned":false,"hidden":false,"mode":"md"},{"id":234,"value":"getBaselineByEpoch = (epoch) => {\n return BaselineB0 * Math.pow(Math.E, g * Number(epoch))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"derive_network_time = (epochCumSumRealized) => {\n return Math.log(g * epochCumSumRealized / BaselineB0 + 1) / g\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"computeSupply = (allocation, time) => {\n return allocation * (1 - Math.pow(Math.E, - Lambda * time))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":239,"value":"computeSimpleMinted = (curr, prev) => {\n return computeSupply(SimpleAlloc, curr) - computeSupply(SimpleAlloc, prev)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":241,"value":"computeBaselineMinted = (curr, prev) => {\n return computeSupply(BaselineAlloc, curr) - computeSupply(BaselineAlloc, prev)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":243,"value":"computeBlockReward = (newWallClockEpoch, prevWallClockEpoch, newNetworkTimeEpoch, prevNetworkTimeEpoch) => {\n return computeSimpleMinted(newWallClockEpoch, prevWallClockEpoch) + computeBaselineMinted(newNetworkTimeEpoch, prevNetworkTimeEpoch)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":284,"value":"#### State Variables: Circulating Supply\nState Variables Initialization","pinned":false,"hidden":false,"mode":"md"},{"id":338,"value":"epochNetStoragePledge = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":340,"value":"epochNetStorageConsensusPledge = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":342,"value":"epochNetInitialPledge = epochNetStoragePledge + epochNetStoragePledge","pinned":false,"hidden":false,"mode":"ojs"},{"id":344,"value":"epochNetDealPledge = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":348,"value":"epochNetCircFIL = data.circulating_fil / ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":351,"value":"epochNetBurntFIL = data.burnt_fil / ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":353,"value":"epochNetLockedFIL = data.locked_fil / ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":1650,"value":"Right now we approximate the total locked funds as a fixed percent of lockedFIL. We will go ahead and fill a datafield later.","pinned":false,"hidden":false,"mode":"md"},{"id":1656,"value":"lockedRewardPercent = .005896","pinned":false,"hidden":false,"mode":"ojs"},{"id":1657,"value":"epochNetRewardLocked = lockedRewardPercent * epochNetLockedFIL","pinned":false,"hidden":false,"mode":"ojs"},{"id":354,"value":"epochNetVestedFIL = data.vested_fil / ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":356,"value":"epochNetMinedFIL = data.mined_fil / ATTO_CON\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":358,"value":"epochNetReserveDisbursed = data.fil_reserve_disbursed / ATTO_CON ","pinned":false,"hidden":false,"mode":"ojs"},{"id":373,"value":"dailyNetBurn = projectedDays.map(()=>{\n return projectedNetBurnMonthly / daysInMonth;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":376,"value":"getVestOnEpoch = (epoch) =>{\n let vestingSchedule = [\n { 'amt': 10632000, 'days': 0 },\n { 'amt': 19015887 + 32787700, 'days': 183 },\n { 'amt': 22421712 + 9400000, 'days': 365 },\n { 'amt': 7223364, 'days': 365 * 2 },\n { 'amt': 87637883 + 898958, 'days': 365 * 3 },\n { 'amt': 400000000 + 9805053, 'days': 365 * 6 },\n ];\n let offSetEpoch = epoch - 148888;\n let accumulate = 0;\n vestingSchedule.map((item)=>{\n if (offSetEpoch <= item['days'] * 2880 && offSetEpoch > 0)\n accumulate += item['amt'] / (item['days'] * 2880)\n })\n return accumulate\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":331,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":378,"value":"## Storage Provider Model\n#### User Inputs and Parameters","pinned":false,"hidden":false,"mode":"md"},{"id":382,"value":"totalPowerToCommit = totalPowerToCommitInput * 1.126 * 1e15 ","pinned":false,"hidden":false,"mode":"ojs"},{"id":389,"value":"dailySealingCapacity = dailySealingCapacityInput * 1.1 * 1e12","pinned":false,"hidden":false,"mode":"ojs"},{"id":426,"value":"#### Storage Provider State Variables\nState Variables: Time Related","pinned":false,"hidden":false,"mode":"md"},{"id":430,"value":"daysForSealing = totalPowerToCommit / dailySealingCapacity","pinned":false,"hidden":false,"mode":"ojs"},{"id":432,"value":"#### State Variables: Storage Capacity\nState Variable Initializations","pinned":false,"hidden":false,"mode":"md"},{"id":435,"value":"epochMinerRBP = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":437,"value":"epochMinerQAP = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":2101,"value":"dailyMinerDeals = projectedDays.map(()=>{\n return 0;\n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":439,"value":"qualityMinerPowerAvgMultiplier = 9 * verifiedPercentage / 100 + 1\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":441,"value":"epochMinerRBPGrowth = dailySealingCapacity / epochInDay","pinned":false,"hidden":false,"mode":"ojs"},{"id":443,"value":"epochMinerQAPGrowth = epochMinerRBPGrowth * qualityMinerPowerAvgMultiplier","pinned":false,"hidden":false,"mode":"ojs"},{"id":445,"value":"#### State Variables: On-chain Rewards\nState Variable Initialization","pinned":false,"hidden":false,"mode":"md"},{"id":450,"value":"epochMinerRewards = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":453,"value":"epochMinerReleasedRewards = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":455,"value":"epochMinerLockedRewards = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":456,"value":"Daily Aggregation","pinned":false,"hidden":false,"mode":"md"},{"id":460,"value":"dailyMinerCumSumRewards = projectedDays.map(()=>{\n return epochMinerRewards;\n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":463,"value":"dailyMinerReleasedRewards = projectedDays.map(()=>{\n return epochMinerReleasedRewards;\n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":464,"value":"dailyMinerLockedRewards = projectedDays.map(()=>{\n return epochMinerLockedRewards;\n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":466,"value":"#### State Variables: On-chain Investments\nState Variable Initialization","pinned":false,"hidden":false,"mode":"md"},{"id":290,"value":"epochMinerConsensusPledge = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":288,"value":"epochMinerStoragePledge = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":292,"value":"epochMinerDealPledge = 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":294,"value":"epochMinerInitialPledge = epochMinerStoragePledge + epochMinerConsensusPledge","pinned":false,"hidden":false,"mode":"ojs"},{"id":297,"value":"Daily Aggregation","pinned":false,"hidden":false,"mode":"md"},{"id":311,"value":"#### State Variables: Income Statement & Financial Items\nDaily Revenue","pinned":false,"hidden":false,"mode":"md"},{"id":2104,"value":"dealFeePerDayByte = (dealFeePerTibMonth / (1.1e+12 * 30))","pinned":false,"hidden":false,"mode":"ojs"},{"id":317,"value":"dailyMinerRevenue = Array.from({length:projectedDays.length},()=>(0))","pinned":false,"hidden":false,"mode":"ojs"},{"id":321,"value":"Daily Costs","pinned":false,"hidden":false,"mode":"md"},{"id":486,"value":"dailyMinerDepCost = projectedDays.map(() => {\n return (hardwareInvestments - hardwareResaleValue) / forecastMonth / daysInMonth\n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1900,"value":"fiatDailyMinerDepCost = projectedDays.map(()=>{\n return (hardwareInvestmentsUSD - hardwareResaleValueUSD) / forecastMonth / daysInMonth;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":488,"value":"dailyMinerMACost = projectedDays.map(() => {\n return (monthlyOperatingCost) / daysInMonth\n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1923,"value":"fiatDailyMinerMACost = projectedDays.map(()=>{\n return (monthlyOperatingCostUSD) / daysInMonth;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":489,"value":"dailyMinerInterestExpense = projectedDays.map(() => {\n return (capitalBorrowed * annualInterestRate / 360) \n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1926,"value":"fiatDailyMinerInterestExpense = projectedDays.map(()=>{\n return capitalBorrowed * annualInterestRate * ((filPriceToday + expectSalePrice) / 2) / 360;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":491,"value":"dailyMinerTotalCost = projectedDays.map((x,idx) => {\n return dailyMinerDepCost[idx] + dailyMinerMACost[idx] + dailyMinerInterestExpense[idx] \n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1930,"value":"fiatDailyMinerTotalCost = projectedDays.map((x,idx) => {\n return (fiatDailyMinerDepCost[idx] + fiatDailyMinerMACost[idx] + fiatDailyMinerInterestExpense[idx]) \n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":507,"value":"Daily Profits","pinned":false,"hidden":false,"mode":"md"},{"id":510,"value":"dailyMinerProfit = projectedDays.map(() => {\n return 0 \n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":514,"value":"Daily Investment","pinned":false,"hidden":false,"mode":"md"},{"id":513,"value":"dailyMinerInvestment = projectedDays.map(() => {\n return 0 \n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":529,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":541,"value":"## Projection","pinned":false,"hidden":false,"mode":"md"},{"id":545,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":571,"value":"result = calculator()","pinned":false,"hidden":false,"mode":"ojs"},{"id":885,"value":"## Outputs\n#### Build Up the On-Chain Daily Cumulatives","pinned":false,"hidden":false,"mode":"md"},{"id":854,"value":"dailyCumSumMinerCumSumRewards = cumsum(result.dailyMinerCumSumRewards);","pinned":false,"hidden":false,"mode":"ojs"},{"id":860,"value":"dailyCumSumMinerTotalPledge = cumsum(result.dailyMinerTotalPledge)","pinned":false,"hidden":false,"mode":"ojs"},{"id":862,"value":"dailyCumSumMinerLockedRewards = cumsum(result.dailyMinerLockedRewards)","pinned":false,"hidden":false,"mode":"ojs"},{"id":863,"value":"dailyCumSumMinerReleasedRewards = cumsum(result.dailyMinerReleasedRewards)","pinned":false,"hidden":false,"mode":"ojs"},{"id":894,"value":"#### Build Up the Income Statement Daily Cumulatives","pinned":false,"hidden":false,"mode":"md"},{"id":898,"value":"dailyMinerRevenueChart = dailyCumSumMinerCumSumRewards","pinned":false,"hidden":false,"mode":"ojs"},{"id":2109,"value":"fiatDailyDealFee = result.dailyMinerDeals.map((x=>{\n return x * dealFeePerDayByte \n})) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":2112,"value":"fiatDailyCumSumDealFee = cumsum(fiatDailyDealFee)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1946,"value":"fiatDailyMinerRevenue = dailyCumSumMinerCumSumRewards.map((x=>{\n return x * expectSalePrice\n})) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1956,"value":"fiatDailyMinerRevenueChart = fiatDailyMinerRevenue.map(((x, inx)=> {\n return x + fiatDailyCumSumDealFee[inx]\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":909,"value":"dailyMinerTotalCostChart = cumsum(dailyMinerTotalCost)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1935,"value":"fiatDailyMinerTotalCostChart = cumsum(fiatDailyMinerTotalCost) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":913,"value":"dailyMinerInvestmentChart = dailyCumSumMinerTotalPledge.map((x) => {\n return hardwareInvestments + x\n}) \n","pinned":false,"hidden":false,"mode":"ojs"},{"id":1776,"value":"fiatDailyMinerInvestment = dailyCumSumMinerTotalPledge.map((x)=>{\n return (hardwareInvestmentsUSD + (x * filPriceToday))\n}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1952,"value":"fiatDailyMinerInvestmentChart = fiatDailyMinerInvestment;","pinned":false,"hidden":false,"mode":"ojs"},{"id":917,"value":"dailyMinerProfitChart = dailyMinerRevenueChart.map((x,idx) => { \n return (x - dailyMinerTotalCostChart[idx])\n})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":1780,"value":"fiatDailyMinerProfit = fiatDailyMinerRevenueChart.map((x,idx) => {\n return x - fiatDailyMinerTotalCostChart[idx];\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1959,"value":"fiatDailyMinerProfitChart = (fiatDailyMinerProfit);","pinned":false,"hidden":false,"mode":"ojs"},{"id":1028,"value":"#### Forecast Summaries","pinned":false,"hidden":false,"mode":"md"},{"id":1032,"value":"totalEstimatedRewards = dailyCumSumMinerCumSumRewards[dailyCumSumMinerCumSumRewards.length -1]\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":1040,"value":"totalCapitalCost = capitalBorrowed * annualInterestRate * (forecastMonth * 30 / 360)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1042,"value":"totalCost = dailyMinerTotalCostChart[dailyMinerTotalCostChart.length -1]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1046,"value":"totalInvestments = dailyMinerInvestmentChart[dailyMinerInvestmentChart.length -1]\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":1052,"value":"totalProfit = totalEstimatedRewards - totalCost","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"value":"## Utils\n### Constants","pinned":false,"hidden":false,"mode":"md"},{"id":93,"value":"EiBToByte = Math.pow(2, 60)","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"unitMillion = Math.pow(10, 6)","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"TEB_CON = Math.pow(2, 40)","pinned":false,"hidden":false,"mode":"ojs"},{"id":99,"value":"EXA_CON = Math.pow(2, 60)","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"Q128_CON = Math.pow(2, 128)","pinned":false,"hidden":false,"mode":"ojs"},{"id":103,"value":"ATTO_CON = Math.pow(10, 18)","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"RESERVED_DISBURSED = 17066618.96177341 * ATTO_CON","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"liftoffEpoch = 148888","pinned":false,"hidden":false,"mode":"ojs"},{"id":109,"value":"epochInDay = 2880","pinned":false,"hidden":false,"mode":"ojs"},{"id":111,"value":"daysInMonth = 30","pinned":false,"hidden":false,"mode":"ojs"},{"id":113,"value":"decimalToPercent = 100","pinned":false,"hidden":false,"mode":"ojs"},{"id":115,"value":"g = Math.log(2) / 1051200","pinned":false,"hidden":false,"mode":"ojs"},{"id":117,"value":"Lambda =3.663258818 * Math.pow(10, -9) * 30","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"SimpleAlloc = 0.3 * 1.1 * Math.pow(10, 9)","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"BaselineAlloc = 0.7 * 1.1 * Math.pow(10, 9)","pinned":false,"hidden":false,"mode":"ojs"},{"id":123,"value":"BaselineB0 = 2.88888888 * Math.pow(10, 18)","pinned":false,"hidden":false,"mode":"ojs"},{"id":125,"value":"### Alpha Beta Filters","pinned":false,"hidden":false,"mode":"md"},{"id":130,"value":"class abFilter {\n alpha;\n beta;\n position;\n velocity;\n\n constructor(p, v) {\n this.alpha = 9.25e-4;\n this.beta = 2.84e-7;\n this.position = p;\n this.velocity = v;\n }\n\n update(value, deltaT) {\n this.position += this.velocity * deltaT;\n const residual = value - this.position;\n this.position += this.alpha * residual;\n this.position = Math.max(this.position, 0);\n this.velocity += this.beta * residual / deltaT;\n }\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":136,"value":"ratio_extract = (num_p, num_v, denom_p, denom_v, delta_T) =>{\n let x2a = Math.log(denom_p + denom_v) \n let x2b = Math.log(denom_p + denom_v + denom_v * delta_T)\n let m1 = denom_v * num_p * (x2b - x2a)\n let m2 = num_v * (denom_p * (x2a - x2b) + denom_v * delta_T)\n return (m1 + m2) / Math.pow(denom_v, 2)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":141,"value":"extrapolateCumsumRatio = (numerator, denominator, futureT) => {\n let x2a = Math.log(denominator.position + denominator.velocity)\n let x2b = Math.log(denominator.position + denominator.velocity + denominator.velocity * futureT);\n let m1 = denominator.velocity * numerator.position * (x2b - x2a);\n let m2 = numerator.velocity * (denominator.position * (x2a - x2b) + denominator.velocity * futureT);\n return (m1 + m2) / Math.pow(denominator.velocity, 2);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":774,"value":"extrapolateCumsumRatio1 = (numerator, denominator, futureT) => {\n let denominator1 = denominator\n return [denominator1.velocity,denominator1.position,denominator1] ;\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":902,"value":"cumsum = (item)=>{\n let cum = item;\n let total = 0;\n let ret = cum.map((x)=>{\n total = total + x;\n return total;\n })\n return ret;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":868,"value":"Plotly = require(\"https://cdn.plot.ly/plotly-latest.min.js\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}