32: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 }33: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 }34: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) } %

`35: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) } %

36:T4593,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, initial_pledge_lock_target: Number(initial_pledge_lock_target), testmove: [], dailyNetNewPledge : dailyNetNewPledge.map(x=>x), dailyNetRenewPledge : dailyNetRenewPledge.map(x=>x), dailyNetNewDealPledge: dailyNetNewDealPledge.map(x => x), dailyMinerRBPCommitted: dailyMinerRBPCommitted.map(x => x), dailyMinerQAPCommitted: dailyMinerQAPCommitted.map(x => x), dailyMinerLockedPledge: dailyMinerLockedPledge.map(x=>x), dailyMinerReleasedPledge: dailyMinerReleasedPledge.map(x=>x), } 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 // ------------------------------------------------------- Power Update Starts Here ----------------------------------------------------// // calculate the daily & epoch based scheduled expiration part let dayKnownSERBP = (day < known_se_power.length) ? known_se_power[day] : 0 let dayModelSERBP_o = (day > projectedAvgSectorDurationDays) ? (dailyNetRBP[day - projectedAvgSectorDurationDays] - dailyNetRBP[day - projectedAvgSectorDurationDays - 1]) : 0 let dayModelSERBP_se = (day > projectedAvgSectorDurationDays) && (day - projectedAvgSectorDurationDays < known_se_power.length) ? projectedRenewalRate * known_se_power[day - projectedAvgSectorDurationDays] : 0 let daySERBP = dayKnownSERBP + dayModelSERBP_o + dayModelSERBP_se // calculate today's renewal part let dayRenewRBP = projectedRenewalRate * daySERBP // do the same thing for QAP let dayKnownSEQAP = (day < known_se_power.length) ? (9 * projectedVerifiedStoragePercent + 1) * known_se_power[day] : 0 let dayModelSEQAP_o = (day > projectedAvgSectorDurationDays) ? dailyNetQAP[day - projectedAvgSectorDurationDays] - dailyNetQAP[day - projectedAvgSectorDurationDays - 1] : 0 let dayModelSEQAP_r = (day > projectedAvgSectorDurationDays) && (day - projectedAvgSectorDurationDays < known_se_power.length) ? qualityNetPowerAvgMultiplier * projectedRenewalRate * known_se_power[day - projectedAvgSectorDurationDays] : 0 let daySEQAP = dayKnownSEQAP + dayModelSEQAP_o + dayModelSEQAP_r // QAP: calculate the daily renewal part let dayRenewQAP = projectedRenewalRate * daySEQAP // make everything as epochs let epochSERBP = daySERBP / epochInDay let epochRenewRBP = dayRenewRBP / epochInDay let epochSEQAP = daySEQAP / epochInDay let epochRenewQAP = dayRenewQAP / epochInDay // --------------------------------------------------------- Power Update Ends Here ----------------------------------------------------// // ------------------------------------------------- Miner Power Update Starts Here ----------------------------------------------------// // ------------------------------------------------- Miner Power Update Ends Here ------------------------------------------------------// //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 - epochSERBP + epochRenewRBP result.epochNetQAP = Number(result.epochNetQAP) + epochNetQAPGrowth - epochSEQAP + epochRenewQAP result.epochNetBasePower = getBaselineByEpoch(epoch) // update network pledge terms let epochPerRBPCircSupply = result.epochNetCircFIL / Math.max(result.epochNetRBP, result.epochNetBasePower) let epochPerQAPCircSupply = result.epochNetCircFIL / Math.max(result.epochNetQAP, result.epochNetBasePower) // -------------------------------------------------- Daily New Pledge Starts Here ----------------------------------------------------// // initial storage pledge result.epochNetStoragePledge = Math.max(epochNetQAPGrowth * extrapolateCumsumRatio(result.epochNetRewardFilter, result.epochNetPowerFilter, 20 * epochInDay ), 0) result.epochNetStorageConsensusPledge = Math.max(epochPerQAPCircSupply * initial_pledge_lock_target * epochNetQAPGrowth, 0) result.epochNetInitialPledge = result.epochNetStoragePledge + result.epochNetStorageConsensusPledge result.dailyNetNewPledge[day] += result.epochNetInitialPledge // deal pledge result.epochNetDealPledge = Math.max(result.projectedVerifiedStoragePercent * epochPerRBPCircSupply * 0.01 * epochNetRBPGrowth, 0) result.dailyNetNewDealPledge[day] += result.epochNetDealPledge // update it here result.epochNetLockedFIL += (result.epochNetDealPledge + result.epochNetInitialPledge) // -------------------------------------------------- Daily New Pledge Ends Here -------------------------------------------------------// // ----------------------------------------- Known Scheduled Expiration Starts Here ----------------------------------------------------// // deal effect omitted for now // /////////////////////////////////////////////////////////// Leaves /////////////////////////////////////////////////////////////////////// let dailyKnownSEOut = (day < known_se_pledge.length) ? (1 - projectedRenewalRate) * known_se_pledge[day]: 0 let epochKnownSEOut = dailyKnownSEOut / epochInDay result.epochNetLockedFIL = result.epochNetLockedFIL - epochKnownSEOut /////////////////////////////////////////////////////////// Repledges //////////////////////////////////////////////////////////////////// let epochKnownSERBP = dayKnownSERBP / epochInDay let dailyKnownSERepledged = (day < known_se_pledge.length) ? projectedRenewalRate * known_se_pledge[day] : 0 let epochKnownSERepledged = dailyKnownSERepledged / epochInDay let epochKnownRenewStoragePledge = Math.max(qualityNetPowerAvgMultiplier * projectedRenewalRate * epochKnownSERBP * extrapolateCumsumRatio(result.epochNetRewardFilter, result.epochNetPowerFilter, 20 * epochInDay), 0) let epochKnownRenewConsensusPledge = Math.max(epochPerQAPCircSupply * initial_pledge_lock_target * qualityNetPowerAvgMultiplier * projectedRenewalRate * epochKnownSERBP, 0) result.epochNetLockedFIL = result.epochNetLockedFIL + epochKnownRenewStoragePledge + epochKnownRenewConsensusPledge - epochKnownSERepledged /////////////////////////////////////////////////////////// Save a Record //////////////////////////////////////////////////////////////// result.dailyNetRenewPledge[day] += epochKnownRenewStoragePledge + epochKnownRenewConsensusPledge // ------------------------------------------ Known Scheduled Expiration Ends Here ----------------------------------------------------// // -------------------------------------- Modelled Scheduled Expiration Starts Here ----------------------------------------------------// // deal effect omitted for now // /////////////////////////////////////////////////////////// Leaves /////////////////////////////////////////////////////////////////////// let epochNetNewPledgeOut = (day > projectedAvgSectorDurationDays) ? (1 - projectedRenewalRate) * result.dailyNetNewPledge[day - projectedAvgSectorDurationDays] / epochInDay : 0 let epochNetRenewPledgeOut = (day > projectedAvgSectorDurationDays) ? (1 - projectedRenewalRate) * result.dailyNetRenewPledge[day - projectedAvgSectorDurationDays] / epochInDay : 0 result.epochNetLockedFIL = result.epochNetLockedFIL - epochNetNewPledgeOut - epochNetRenewPledgeOut /////////////////////////////////////////////////////////// Repledges //////////////////////////////////////////////////////////////////// // step 1: get the re-pledged out part let epochNetNewPledgeRe = (day > projectedAvgSectorDurationDays) ? projectedRenewalRate * result.dailyNetNewPledge[day - projectedAvgSectorDurationDays] / epochInDay: 0 let epochNetRenewPledgeRe = (day > projectedAvgSectorDurationDays) ? projectedRenewalRate * result.dailyNetRenewPledge[day - projectedAvgSectorDurationDays] / epochInDay: 0 result.epochNetLockedFIL = result.epochNetLockedFIL - epochNetNewPledgeRe - epochNetRenewPledgeRe // step 2: construct up the re-pledges //// Model out the newly onboarded part let epochModelSERBP_o = dayModelSERBP_o / epochInDay let epochModelSERBP_o_storage_pledge = Math.max(qualityNetPowerAvgMultiplier * projectedRenewalRate * epochModelSERBP_o * extrapolateCumsumRatio(result.epochNetRewardFilter, result.epochNetPowerFilter, 20 * epochInDay), 0) let epochModelSERBP_o_consensus_pledge = Math.max(epochPerQAPCircSupply * initial_pledge_lock_target * qualityNetPowerAvgMultiplier * projectedRenewalRate * epochModelSERBP_o, 0) let epochModelSERBP_o_new = (day > projectedAvgSectorDurationDays) ? epochModelSERBP_o_storage_pledge + epochModelSERBP_o_consensus_pledge : 0 result.epochNetLockedFIL = result.epochNetLockedFIL + epochModelSERBP_o_new //// model out the known expiration part let epochModelSERBP_se = dayModelSERBP_se / epochInDay let epochModelSERBP_se_storage_pledge = Math.max(qualityNetPowerAvgMultiplier * projectedRenewalRate * epochModelSERBP_se * extrapolateCumsumRatio(result.epochNetRewardFilter, result.epochNetPowerFilter, 20 * epochInDay), 0) let epochModelSERBP_se_consensus_pledge = Math.max(epochPerQAPCircSupply * initial_pledge_lock_target * qualityNetPowerAvgMultiplier * projectedRenewalRate * epochModelSERBP_se, 0) let epochModelSERBP_se_new = (day > projectedAvgSectorDurationDays) ? epochModelSERBP_se_storage_pledge + epochModelSERBP_se_consensus_pledge : 0 result.epochNetLockedFIL = result.epochNetLockedFIL + epochModelSERBP_se_new // --------------------------------------- Modelled Scheduled Expiration Ends Here ----------------------------------------------------// // update new rewards & FIL Mined 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) result.epochNetMinedFIL += result.epochNetNewReward // keep mining result.epochNetRewardLocked += 0.75 * result.epochNetNewReward // lock away new rewards result.epochNetRewardLocked -= result.epochNetRewardLocked / 180 / epochInDay // release part of the rewards // reward part result.epochNetLockedFIL += 0.75 * result.epochNetNewReward result.epochNetLockedFIL -= result.epochNetRewardLocked / 180 / epochInDay // release part of the rewards result.epochNetBurntFIL += result.dailyNetBurn[day] / epochInDay result.epochNetVestedFIL += getVestOnEpoch(epoch) // update the total network circulating supply field result.epochNetCircFIL = result.epochNetReserveDisbursed + result.epochNetMinedFIL + result.epochNetVestedFIL - result.epochNetLockedFIL - result.epochNetBurntFIL // update ab filters for next round prediction result.epochNetRewardFilter.update(result.epochNetNewReward, 1) result.epochNetPowerFilter.update(result.epochNetQAP, 1) // some pledge accounting //accounting up result.dailyMinerQAPCommitted[day] += epochMinerRBPGrowth result.dailyMinerRBPCommitted[day] += epochMinerQAPGrowth // more accounting let dailyMinerRBPRetire = (day > projectedSPStorageDurationDays) && (day - projectedSPStorageDurationDays < daysForSealing) ? result.dailyMinerRBPCommitted[day - projectedSPStorageDurationDays] : 0 let dailyMinerQAPRetire = (day > projectedSPStorageDurationDays) && (day - projectedSPStorageDurationDays < daysForSealing) ? result.dailyMinerQAPCommitted[day - projectedSPStorageDurationDays] : 0 let epochMinerRBPRetire = dailyMinerRBPRetire / epochInDay let epochMinerQAPRetire = dailyMinerQAPRetire / epochInDay result.epochMinerRBP = epochMinerRBPRetire result.epochMinerQAP -= epochMinerQAPRetire // 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 } // 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] // get the cumulative sum of the pledges let dailyMinerPledgeRelease = (day > projectedSPStorageDurationDays) ? result.dailyMinerTotalPledge[day - projectedSPStorageDurationDays] : 0 result.dailyMinerReleasedPledge[day] = dailyMinerPledgeRelease result.dailyMinerLockedPledge[day] = result.dailyMinerTotalPledge[day] - result.dailyMinerReleasedPledge[day] result.dailyMinerInvestment[day] += result.dailyMinerTotalPledge[day] result.dailyMinerProfit[day] += result.dailyMinerCumSumRewards[day] - result.dailyMinerTotalCost[day] }) return result }37:[] 30:{"title":"Filecoin Storage Provider Return Calculator (Beta)","cells":[{"id":1424,"value":"# Filecoin Storage Provider Return Calculator (Beta)","pinned":false,"hidden":false,"mode":"md"},{"id":1431,"value":"## Disclaimer:\n* **Version Update:** Added scheduled expiration modeling to improve projection accuracy and incorporated protocol-level changes proposed by [FIP 421](https://github.com/filecoin-project/FIPs/discussions/421).\n\n* **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":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":878,"value":"$33","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: 20 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1099,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":2023,"value":"$35","pinned":false,"hidden":false,"mode":"html"},{"id":2236,"value":"## Forecast Period","pinned":false,"hidden":false,"mode":"md"},{"id":1272,"value":"**Forecast Period (Month)**: Projection length.","pinned":false,"hidden":false,"mode":"md"},{"id":948,"value":"viewof forecastMonth = Inputs.range([12, 60], { step:1 , value:20}) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":940,"value":"## Network Assumptions\n## User Inputs and Parameters","pinned":false,"hidden":false,"mode":"md"},{"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([0, 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, 100], {step:0.01 , value: 2.5 })","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":2248,"value":"**Projected Average Sector Duration (Month):** The projected average sector duration on the network. ","pinned":false,"hidden":false,"mode":"md"},{"id":2250,"value":"viewof projectedAvgSectorDuration = Inputs.range([12, 60], {step:0.1 , value: 18})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2391,"value":"**Projected Sector Renewal Rate(%):** The projected percentage of sector renewal out of service completion. Default value estimated from sector extensions in the past 90 days.","pinned":false,"hidden":false,"mode":"md"},{"id":2393,"value":"viewof projectedRenewalRatePercent = Inputs.range([0, 100], {step:1 , value: 50})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2165,"value":"**Sector Duration Multiplier Slope (unitless):** Slope in the Sector Duration Multiplier function. ","pinned":false,"hidden":false,"mode":"md"},{"id":2167,"value":"viewof sdm_slope = Inputs.range([1, 2], {step:0.01 , value: 1 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":2175,"value":"**Initial Pledge Lock Target:** percentage of normalized circulating supply charged for initial consensus pledge. ","pinned":false,"hidden":false,"mode":"md"},{"id":2177,"value":"viewof initial_pledge_lock_target = Inputs.range([0.3, 0.9], {step:0.01 , value: 0.5})","pinned":false,"hidden":false,"mode":"ojs"},{"id":965,"value":"## Storage Provider Business Assumptions\n## User Inputs and Parameters","pinned":false,"hidden":false,"mode":"md"},{"id":2201,"value":"### 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":2651,"value":"**Projected Average Sector Duration (Month):** The projected average sector duration the storage provider plans to commit.","pinned":false,"hidden":false,"mode":"md"},{"id":2646,"value":"viewof projectedSPStorageDurationMonth = Inputs.range([12, 60], {step:0.1 , value:20})","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:28})","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":13,"value":"data_res = fetch(\"https://observable-api.starboard.ventures/calculator/getDataOB\" , {\n method: 'GET',\n redirect: 'follow'\n}).then(response => {\n return response.json();\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2135,"value":"data_growth = fetch(\"https://observable-api.starboard.ventures/calculator/getNetworkGrowthOB\" , {\n method: 'GET',\n redirect: 'follow'\n}).then(response => {\n return response.json();\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2140,"value":"growth = Number(Number(data_growth.data[0].growth).toFixed(2))","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"data = data_res.data[0]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2790,"value":"import { GetApiUrl} from \"@starboard/api-config\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1723,"value":"apiconfig = GetApiUrl('v2_prt_001')","pinned":false,"hidden":false,"mode":"ojs"},{"id":2153,"value":"filInfoToday = fetch(apiconfig.src + apiconfig.url, {\n method: \"GET\",\n headers: new Headers({\n authorization: apiconfig.accout\n })\n}).then((response) => {\n return response.json();\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1731,"value":"filPriceToday = filInfoToday.data.price","pinned":false,"hidden":false,"mode":"ojs"},{"id":943,"value":"## Network Model\n#### User Inputs and Parameters","pinned":false,"hidden":false,"mode":"md"},{"id":2577,"value":"projectedRenewalRate = projectedRenewalRatePercent / 100","pinned":false,"hidden":false,"mode":"ojs"},{"id":2543,"value":"known_se_power_90_rate = (() => {\n let extended_bytes = 0;\n let potential_expire_bytes = 0;\n let se_array_pib = se_pib.filter(\n (x) => Date.parse(x.stat_date) <= Date.parse(x.interest_date)\n );\n let rate_list = se_array_pib.splice(0, 90);\n for (let i in rate_list) {\n extended_bytes += Number(rate_list[i].extended_bytes);\n potential_expire_bytes += Number(rate_list[i].potential_expire_bytes);\n }\n return extended_bytes / (extended_bytes + potential_expire_bytes);\n})()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1464,"value":"projectedNetGrowthMonthly = projectedNetGrowthMonthlyInput / 100","pinned":false,"hidden":false,"mode":"ojs"},{"id":2402,"value":"projectedAvgSectorDurationDays = projectedAvgSectorDuration * 30","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":2264,"value":"projectedAvgSectorDurationYears = projectedAvgSectorDuration / 12","pinned":false,"hidden":false,"mode":"ojs"},{"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":2293,"value":"projectedDays = Array.from({length:forecastMonth * daysInMonth + 1},(_, i)=>(i))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2344,"value":"import {data as se_pib} from \"@starboard/chart-scheduled-expiration-by-date-breakdown-in-pib\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2385,"value":"known_se_power","pinned":false,"hidden":false,"mode":"ojs"},{"id":2387,"value":"known_se_pledge","pinned":false,"hidden":false,"mode":"ojs"},{"id":2303,"value":"known_se_power = (() => {\n let se_array_pib = se_pib.filter(\n (x) => Date.parse(x.stat_date) <= Date.parse(x.interest_date)\n );\n return projectedDays.map((x, idx) => {\n let item = se_array_pib[idx];\n if (!item) return 0;\n return (\n Number(item.extended_bytes) +\n Number(item.expired_bytes) +\n Number(item.potential_expire_bytes)\n );\n });\n})()","pinned":false,"hidden":false,"mode":"ojs"},{"id":2316,"value":"import {data as se_fil} from \"@starboard/chart-initial-pledge-release-by-scheduled-expiration-fil\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2309,"value":"known_se_pledge = (() => {\n let se_array_fil = se_fil.filter(\n (x) => Date.parse(x.stat_date) <= Date.parse(x.interest_date)\n );\n return projectedDays.map((x, idx) => {\n let item = se_array_fil[idx];\n if (!item) return 0;\n return (\n Number(item.extended_pledge) +\n Number(item.expired_pledge) +\n Number(item.potential_expire_pledge)\n );\n });\n})()","pinned":false,"hidden":false,"mode":"ojs"},{"id":2416,"value":"dailySERBP = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2418,"value":"dailySEQAP = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2290,"value":"today = se_pib.filter(\n (x) => Date.parse(x.stat_date) <= Date.parse(x.interest_date)\n)[0].interest_date","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 = projectedAvgSectorDurationYears *\n sdm_slope *\n (9 * projectedVerifiedStoragePercent + 1) >\nonChainNetQAP / epochNetRBP\n ? projectedAvgSectorDurationYears *\n sdm_slope *\n (9 * projectedVerifiedStoragePercent + 1)\n : 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":2457,"value":"dailyModelSEPledges_o = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2462,"value":"dailyModelSEPledges_r = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2781,"value":"dailyNetNewPledge = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":2783,"value":"dailyNetRenewPledge = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":2785,"value":"dailyNetNewDealPledge = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":true,"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":2653,"value":"projectedSPStorageDurationDays = projectedSPStorageDurationMonth * 30","pinned":false,"hidden":false,"mode":"ojs"},{"id":2215,"value":"durationInYears = forecastMonth / 12","pinned":false,"hidden":false,"mode":"ojs"},{"id":382,"value":"totalPowerToCommit = totalPowerToCommitInput * 1.126 * 1e15 ","pinned":true,"hidden":false,"mode":"ojs"},{"id":389,"value":"dailySealingCapacity = dailySealingCapacityInput * 1.1 * 1e12","pinned":true,"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":true,"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) * (projectedSPStorageDurationMonth / 12) * sdm_slope","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":2682,"value":"dailyMinerLockedPledge = Array.from({length:projectedDays.length},()=>(0))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2629,"value":"dailyMinerReleasedPledge = Array.from({length:projectedDays.length},()=>(0))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2641,"value":"dailyMinerPowerToReleaseRBP = Array.from({length:projectedDays.length},()=>(0))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2666,"value":"dailyMinerPowerToReleaseQAP = Array.from({length:projectedDays.length},()=>(0))","pinned":false,"hidden":false,"mode":"ojs"},{"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":2519,"value":"dailyLockedFIL = projectedDays.map((x,idx) => {\n return 0; \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2775,"value":"dailyMinerQAPCommitted = Array.from({length:daysForSealing},(_, i)=>(i))","pinned":true,"hidden":false,"mode":"ojs"},{"id":2779,"value":"dailyMinerRBPCommitted = Array.from({length:daysForSealing},(_, i)=>(i))","pinned":true,"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":"$36","pinned":true,"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":2525,"value":"result.dailyLockedFIL","pinned":false,"hidden":false,"mode":"ojs"},{"id":2410,"value":"result","pinned":false,"hidden":false,"mode":"ojs"},{"id":854,"value":"dailyCumSumMinerCumSumRewards = cumsum(result.dailyMinerCumSumRewards);","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":860,"value":"dailyCumSumMinerTotalPledge = cumsum(result.dailyMinerTotalPledge)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2699,"value":"dailyCumSumMinerReleasedPledge = cumsum(result.dailyMinerReleasedPledge)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2714,"value":"dailyCumSumMinerReleasedPledge[dailyCumSumMinerReleasedPledge.length - 20]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2702,"value":"dailyCumSumMinerLockedPledge = cumsum(result.dailyMinerLockedPledge)","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":2549,"value":"firstYearTotalEstimatedRewards = dailyCumSumMinerCumSumRewards[360 - 1]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2557,"value":"firstYearTotalInvestment = dailyMinerInvestmentChart[360 - 1]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2559,"value":"firstYearTotalCost = dailyMinerTotalCostChart[360 - 1]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2561,"value":"firstYearTotalProfit = firstYearTotalEstimatedRewards - firstYearTotalCost","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":"$W37","stdlib":"1","titling":"auto"}