2c:null 2d:["$","title",null,{"children":"Ilute PPA Simulation | Andy Fleming | Observable"}] 32:T1352,viewof params = { const form = html`

Plant

Use P90 plant yield:

GreenCo

${makeSlider('greenco.base_tariff')} ${makeSlider('greenco.indexation')}

${makeSlider('greenco.adjustment_cap_plus')} ${makeSlider('greenco.adjustment_cap_minus')}

${makeSlider('greenco.adjustment_factor_up')} ${makeSlider('greenco.adjustment_factor_down')}

${makeSlider('greenco.fixed_transaction_cost')} ${makeSlider('greenco.actual_transaction_cost')}

${makeSlider('greenco.buffer_initial')} ${makeSlider('greenco.buffer_6mo_increment')}

${makeSlider('greenco.buffer_increments')}

Parameters marked * are indexed

` form.value = JSON.parse(JSON.stringify(scenario)) function makeSlider(indx) { let dom = html`

` return dom } function makeDropdown(indx, items, valueParam, textParam) { let dom = html`

` return dom } function addHandler(indx, label, unit, type = 'value') { function set() { let newVal = null if (type == 'dropdown'){ newVal = form[indx].value } if (type == 'value'){ newVal = parseFloat(form[indx].value) } console.log('==Param Change:' + indx + ':' + newVal) if (newVal !== objIndex(base_params, indx)) { form.querySelector(`[id='${indx}_label']`).style.color = 'red' form.querySelector(`[id='${indx}_disp']`).textContent = newVal + unit + ' (' + objIndex(base_params, indx) + ')' } else { form.querySelector(`[id='${indx}_label']`).style.color = '' form.querySelector(`[id='${indx}_disp']`).textContent = newVal + unit } form.querySelector(`[id='${indx}_label']`).textContent = label return newVal } set() form.querySelector(`[id='${indx}']`).addEventListener("input", () => { setObjIndex(form.value, indx, set()) }) } addHandler('greenco.base_tariff', '*Base tariff', ' $/MWh') addHandler('greenco.indexation', 'Indexation', '%') addHandler('greenco.adjustment_cap_plus', '*Adjustment cap +', ' $/MWh') addHandler('greenco.adjustment_cap_minus', '*Adjustment cap -', ' $/MWh') addHandler('greenco.adjustment_factor_up', 'Passthrough upside', '%') addHandler('greenco.adjustment_factor_down', 'Passthrough downside', '%') addHandler('greenco.fixed_transaction_cost', '*Fixed transaction cost', ' $/MWh') addHandler('greenco.actual_transaction_cost', '*Actual transaction cost', ' $/MWh') addHandler('greenco.buffer_initial', 'Initial Liquidity Buffer Size', ' $m') addHandler('greenco.buffer_6mo_increment', 'Liq Buffer 6mo Increment', ' $m') addHandler('greenco.buffer_increments', 'Liq Buffer Increments', ' no') form.addEventListener("input", () => { if (form['use_p90'].checked) { form.value.plant.yield_curve = 'p90' } else { form.value.plant.yield_curve = 'p50' } }) return form }33:Te3e,{ let pers = fGreenCo.periods var data = [ { y: pers.map(d=>d.applicable_tariff), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')),stackgroup: 'one', mode: 'lines', line: {shape: '', color: '#9eadf4', width: 0}, type: 'scatter', hoverinfo: 'x+y', showlegend:true, name: 'Applicable tariff' },{ y: pers.map(d=>d.fixed_transaction_cost), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), stackgroup: 'one', mode: 'lines', line: {shape: '', color: '#a3b4c2', width: 0}, type: 'scatter', hoverinfo: 'y', showlegend:true, name: 'Transaction costs' },{ y: pers.map(d=>d.greenco_specific_margin), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), stackgroup: 'one', mode: 'lines', line: {shape: '', color: '#e9ab61', width: 0}, type: 'scatter', hoverinfo: 'y', showlegend:true, name: 'GreenCo Margin' },{ y: pers.map(d=>d.buffer_recharge / d.yield), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')),stackgroup: 'one', mode: 'lines', line: {shape: '', color: '#abebc6', width: 0}, type: 'scatter', hoverinfo: 'y', showlegend:true, name: 'Buffer Recharge' },{ y: pers.map(d=> (-d.buffer_drawdown / d.yield)), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')),stackgroup: 'two', mode: 'lines', line: {shape: '', color: '#f1948a', width: 0}, type: 'scatter', hoverinfo: 'y', showlegend:true, name: 'Buffer Drawdown' },{ y: pers.map(d=>d.base_tariff), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), mode: 'lines', line: {shape: '', color: 'grey', width: 2}, type: 'scatter', hoverinfo: 'y', showlegend:true, name: 'Base Tariff' },{ y: pers.map(d=>d.base_tariff+d.adjustment_range_lower), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), mode: 'lines', line: {dash:'dashdot', color: 'grey', width: 1}, type: 'scatter', hoverinfo: 'y', showlegend:true, name: 'Cap/Floor' },{ y: pers.map(d=>d.base_tariff+d.adjustment_range_upper), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), mode: 'lines', line: {dash:'dashdot', color: 'grey', width: 1}, type: 'scatter', hoverinfo: 'y', showlegend:false, name: 'Cap/Floor' },{ y: pers.map(d=>d.benchmark_price), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), mode: 'lines', line: {shape: '', color: '#ba4a00', width: 1.5}, type: 'scatter', hoverinfo: 'y', showlegend:true, name: 'SAPP Benchmark price' },{ y: pers.map(d=>d.applicable_tariff), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), mode: 'lines', line: {shape: '', color: '#2471a3', width: 1.5}, type: 'scatter', hoverinfo: 'y', showlegend:false, name: 'Applicable tariff line' }] var layout = { height: 400, width: width-30, font: font, showlegend: true, legend: {orientation: 'h',xanchor: 'left', x:0, y: 1}, margin: {l: 90,r: 10,b: 20,t: 10}, xaxis: { showgrid: true, zeroline: false, showticklabels:true }, yaxis: { title: `$/MWh`, range: [ d3.min(pers.map(d=>-d.buffer_drawdown / d.yield*1.1))-20, d3.max([d3.max(pers.map(d=>d.base_tariff+ d.adjustment_range_upper)),d3.max(pers.map(d=>d.benchmark_price))])*1.2 ], showgrid: true, zeroline: true, tickformat: '.0f', ticks:'outside' } }; const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}); return html`${div}` }34:T500,{ let pers = fGreenCo.periods var data = [ { y: pers.map(d=>d.buffer_recharge/1000), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), bargap:10, mode: 'lines', marker: {shape: '', color: 'green', width: 2}, type: 'bar', hoverinfo: 'x+y', showlegend:true, name: 'Buffer Recharge' }, { y: pers.map(d=>d.buffer_drawdown/1000), x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')), mode: 'lines', marker: {shape: '', color: '#CD5C5C', width: 2}, type: 'bar', hoverinfo: 'x+y', showlegend:true, name: 'Buffer Drawdown' }] var layout = { height: 150, width: width-30, font: font, barmode:'stack', bargap:0, showlegend: true, legend: {orientation: 'h',xanchor: 'right', x:0.95, y: 0.95}, margin: {l: 90,r: 10,b: 12,t: 0}, xaxis: { showgrid: true, zeroline: false, showticklabels:false }, yaxis: { title: `$000s`, showgrid: true, zeroline: true, tickformat: ',.0f', ticks:'outside', range:[0, d3.max([d3.max(pers.map(d=>d.buffer_drawdown/1000)),d3.max(pers.map(d=>d.buffer_recharge/1000))])*1.2] } }; const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}); return html`${div}` }35:T1288,fGreenCo = function() { //let pers = fPeriods(params.forecast.years) let buffer_size = params.greenco.buffer_initial*1000000 let buffer_position = params.greenco.buffer_initial*1000000 let buffer_increments_remain = params.greenco.buffer_increments let model = periods.map((p, i) => { // ========================================================================================================= // Copy in some values //p.run=run p.yield = plantYield[i].yield p.yield_undegraded_gross = plantYield[i].yield_undegraded_gross p.yield_undegraded_net = plantYield[i].yield_undegraded_net //p.mu = dam_prices[i].mu //p.sd = dam_prices[i].annual_sd // ========================================================================================================= // GreenCo model if ((p.period+1) % 6 == 0 && buffer_increments_remain>0) { buffer_size+=params.greenco.buffer_6mo_increment*1000000 buffer_position+=params.greenco.buffer_6mo_increment*1000000 buffer_increments_remain-- } p.buffer_size = buffer_size p.index_factor = (1 + (params.greenco.indexation / 100)) ** (p.period / 12) p.benchmark_price = periods[i].benchmarkPrice p.base_tariff = params.greenco.base_tariff * p.index_factor p.fixed_transaction_cost = params.greenco.fixed_transaction_cost * p.index_factor p.reference_tariff = p.base_tariff + p.fixed_transaction_cost p.adjustment_range_lower = - (params.greenco.adjustment_cap_minus * p.index_factor) p.adjustment_range_upper = params.greenco.adjustment_cap_plus * p.index_factor if (p.reference_tariff > p.base_tariff) { p.adjustment_factor = params.greenco.adjustment_factor_up } else { p.adjustment_factor = params.greenco.adjustment_factor_down } p.tariff_difference = (p.benchmark_price - p.reference_tariff) p.tariff_adjustment = (p.adjustment_factor / 100) * p.tariff_difference p.tariff_adjustment_capped = d3.max([p.tariff_adjustment, p.adjustment_range_lower ]) p.tariff_adjustment_capped = d3.min([p.tariff_adjustment_capped, p.adjustment_range_upper ]) p.applicable_tariff = p.base_tariff + p.tariff_adjustment_capped // ========================================================================================================= // Cashflows and buffer movements p.greenco_gross_revenue = p.yield * p.benchmark_price p.actual_transaction_cost = params.greenco.actual_transaction_cost * p.index_factor p.transaction_cost = p.yield * p.actual_transaction_cost p.greenco_net_revenue = p.greenco_gross_revenue - p.transaction_cost p.projectco_invoiced = p.yield * p.applicable_tariff if (p.greenco_net_revenue > p.projectco_invoiced) { // Revenue exceeds cost, no buffer drawdown, buffer replenishment if necassary p.projectco_payment = p.projectco_invoiced p.buffer_drawdown = 0 p.greenco_defecit = 0 if (buffer_position < buffer_size) { p.buffer_recharge = d3.min([p.greenco_net_revenue - p.projectco_invoiced, buffer_size - buffer_position]) } else { p.buffer_recharge = 0 } p.greenco_margin = p.greenco_net_revenue - p.projectco_invoiced - p.buffer_recharge buffer_position += p.buffer_recharge } else { // Cost exceeds revenue, buffer drawdown p.greenco_defecit = p.projectco_invoiced - p.greenco_net_revenue p.buffer_drawdown = d3.min([p.greenco_defecit, buffer_position]) p.projectco_payment = d3.min([p.projectco_invoiced, buffer_position + p.greenco_net_revenue]) p.buffer_recharge = 0 p.greenco_margin = 0 buffer_position -= p.buffer_drawdown } p.projectco_tariff_achieved = p.projectco_payment / p.yield p.greenco_specific_margin = p.greenco_margin / p.yield p.buffer_position = buffer_position p.buffer_position_pct = p.buffer_position / buffer_size return p }) return { //run: run, buffer_drawdown_months: d3.count(periods.filter(v => v.buffer_drawdown > 0), v => 1)/periods.length, buffer_zero_months: d3.count(periods.filter(v => v.buffer_position==0), v => 1)/periods.length, buffer_min_position_pct: d3.min(periods, v => v.buffer_position_pct), first_period_buffer_zero: d3.min(periods.filter(v => v.buffer_position==0), v => v.period), projectco_defecit_months: d3.count(periods.filter(v => v.projectco_payment < v.projectco_invoiced), v => 1)/periods.length, projectco_tariff_achieved: d3.mean(periods, v => v.projectco_tariff_achieved), projectco_npv: d3.sum(periods,v=>v.projectco_payment*v.discount_factor), greenco_npv: d3.sum(periods,v=>v.greenco_margin*v.discount_factor), periods: model } }()36:[] 30:{"id":"1898f370e1ed89b0","slug":"ilute-ppa-simulation","title":"Ilute PPA Simulation","thumbnail":"300f9f0c965ca1a0fcc150b908e878691795c8176e2ba2ba2ee6ebb4d8809ff6","access_level":"public","create_time":"$D2025-08-16T07:52:59.404Z","update_time":"$D2025-08-19T10:59:00.083Z","view_time":null,"first_public_time":"$D2025-08-18T09:55:11.782Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"21337e734770a90b","login":"andyflem","name":"Andy Fleming","avatar_url":"https://avatars-next.observableusercontent.com/fd3844143a4c29872f0df28a8ebce77bb56cebf2fa74bb669872e4def82ad809","tier":"starter_2024"},"version":346,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"96924893937b5930","login":"andyflem","name":"Andy Fleming","avatar_url":"https://avatars-next.observableusercontent.com/fd3844143a4c29872f0df28a8ebce77bb56cebf2fa74bb669872e4def82ad809","tier":null}],"members":[{"type":"team","id":"21337e734770a90b","login":"andyflem","name":"Andy Fleming","avatar_url":"https://avatars-next.observableusercontent.com/fd3844143a4c29872f0df28a8ebce77bb56cebf2fa74bb669872e4def82ad809","tier":"starter_2024","role":"editor"},{"type":"individual","id":"96924893937b5930","login":"andyflem","name":"Andy Fleming","avatar_url":"https://avatars-next.observableusercontent.com/fd3844143a4c29872f0df28a8ebce77bb56cebf2fa74bb669872e4def82ad809","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Ilute PPA Simulation","cells":[{"id":0,"value":"# Ilute PPA Simulation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":327,"value":"A simulation of the Ilute Solar PV PPA between Ilute Solar and Africa GreenCo using actual SAPP DAM (unconstrained) prices and mean solar yield for nearly 10 years from January 2016 to July 2025.","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":84,"value":"solar_chart()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"viewof scenario_number = {\n const form = html`\n

\n Scenario \n

\n \n

\n `\n\n form.oninput = () => {\n form.value = parseInt(form.input.value)\n }\n form.oninput()\n return form\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"{ \n let pers = fGreenCo.periods\n var data = [\n {\n y: pers.map(d=>d.buffer_position/d.buffer_size),\n x: pers.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')),\n mode: 'lines', line: {shape: '', color: '#5499c7', width: 2},\n type: 'scatter', hoverinfo: 'x+y', showlegend:true, name: 'Buffer position', fill:'tozeroy'\n }]\n \n var layout = {\n height: 200, width: width-30,\n font: font, \n showlegend: true, legend: {orientation: 'v',xanchor: 'left', x:0.05, y: 0.5},\n margin: {l: 90,r: 10,b: 50,t: 0},\n xaxis: {\n showgrid: true, zeroline: false, ticks: 'outside', title: 'year'\n },\n yaxis: {\n title: `%`, range:[0, 1.05],\n showgrid: true, zeroline: false, tickformat: '%01f', ticks:'outside'\n }\n };\n \n const div=DOM.element('div')\n plt.newPlot(div, data, layout,{displayModeBar: false});\n\n return html`\n ${div}` \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"{\n var data = [\n {\n y: fGreenCo.periods.map(d=>d.projectco_payment/1000),\n x: fGreenCo.periods.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')),\n mode: 'lines+markers', marker: {color: colr(2,0.8)},\n type: 'bar', showlegend:false, fill:'tozeroy', name:''\n } \n ]\n\n \n var layout = {\n height: 220, width: width>1100?1070:width-30,\n font: font, \n showlegend: true, legend: {orientation: 'h',xanchor: 'left', x:0, y: 1},\n margin: {l: 50,r: 5,b: 30,t: 0},\n xaxis: {\n showgrid: true, zeroline: false, ticks: 'outside',\n },\n yaxis: {\n title: `$000s`,\n showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside'\n }\n };\n\n \n const div=container(`ProjectCo monthly revenue.`,width>1100?1090:width-10,)\n plt.newPlot(div, data, layout,{displayModeBar: false});\n return div \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"{\n var data = [\n {\n y: fGreenCo.periods.map(d=>d.greenco_margin/1000),\n x: fGreenCo.periods.map(d=>new Date(d.calendarYear + '-' + d.month + '-01')),\n mode: 'lines+markers', marker: {color: colr_b(3,0.8)},\n type: 'bar', showlegend:false, fill:'tozeroy', name:''\n } \n ]\n\n \n var layout = {\n height: 220, width: width>1100?1070:width-30,\n font: font, \n showlegend: true, legend: {orientation: 'h',xanchor: 'left', x:0, y: 1},\n margin: {l: 50,r: 5,b: 30,t: 0},\n xaxis: {\n showgrid: true, zeroline: false, ticks: 'outside',\n },\n yaxis: {\n title: `$000s`,\n showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside'\n }\n };\n\n \n const div=container(`GreenCo monthly margin.`, width>1100?1090:width-10)\n plt.newPlot(div, data, layout,{displayModeBar: false});\n return div \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"{\n var data = [\n {\n y: annual.map(d=>d.projectco_payment/1000),\n x: annual.map(d=>d.calendarYear),\n mode: 'lines+markers', marker: {color: colr(2,0.7)},\n type: 'bar', showlegend:false, fill:'tozeroy', name:''\n } \n ]\n\n \n var layout = {\n height: 220, \n width: width>700?670:width-30,\n font: font, \n showlegend: true, legend: {orientation: 'h',xanchor: 'left', x:0, y: 1},\n margin: {l: 70,r: 5,b: 30,t: 0},\n xaxis: {\n showgrid: true, zeroline: false, ticks: 'outside',\n },\n yaxis: {\n title: `$000s`,\n showgrid: true, zeroline: false, tickformat: ',.0f', ticks:'outside'\n }\n };\n\n \n const div=container(`ProjectCo annual revenue.`, width>700?690:width-10)\n plt.newPlot(div, data, layout,{displayModeBar: false});\n return div \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"{\n var data = [\n {\n y: annual.map(d=>d.projectco_average_tariff),\n x: annual.map(d=>d.calendarYear),\n mode: 'lines+markers', marker: {color: colr(1,0.6)},\n type: 'bar', showlegend:false, fill:'tozeroy', name:''\n } \n ]\n\n \n var layout = {\n height: 220, \n width: width>700?670:width-30,\n font: font, \n showlegend: true, legend: {orientation: 'h',xanchor: 'left', x:0, y: 1},\n margin: {l: 70,r: 5,b: 30,t: 0},\n xaxis: {\n showgrid: true, zeroline: false, ticks: 'outside',\n },\n yaxis: {\n title: `$/MWh`,\n showgrid: true, zeroline: false, tickformat: ',.0f', ticks:'outside'\n }\n };\n\n \n const div=container(`ProjectCo average tariff.`, width>700?690:width-10)\n plt.newPlot(div, data, layout,{displayModeBar: false});\n return div \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"md `\n### Model\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"annual = d3.rollups(fGreenCo.periods, v=>{\n return {\n calendarYear: v[0].calendarYear,\n yield: d3.sum(v,d=>d.yield)/1000,\n projectco_payment:d3.sum(v,d=>d.projectco_payment),\n projectco_average_tariff: d3.sum(v,d=>d.projectco_payment)/d3.sum(v,d=>d.yield),\n greenco_margin:d3.sum(v,d=>d.greenco_margin),\n \n }\n}, v=>v.calendarYear).map(v=>v[1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"startYear=2016","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"periods = monthly_solar_price.map((v,i)=>{\n let ret= {\n period: i+1,\n year: v[1].lux_date.year-startYear+1,\n calendarYear: v[1].lux_date.year,\n month: v[1].lux_date.month,\n benchmarkPrice: v[1].price\n }\n ret.discount_factor = 1/(1+params.discount_rate)**(ret.year-1)\n return ret\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":135,"value":"plantYield = \n periods.map(p => {\n let ret= {\n period: p.period,\n year: p.year,\n month: p.month,\n degredation: fDegredation(p.year, p.month),\n yield_undegraded_gross: monthly_yield_totals[p.month-1]*monthDays(p.month-1),\n }\n ret.yield_undegraded_net = ret.yield_undegraded_gross * plant_netting_factor\n ret.yield = ret.yield_undegraded_net * ret.degredation\n ret.specific_yield = ret.yield / params.plant.capacity\n\n return ret\n })\n\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"md `\n### Plant\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"plant_netting_factor = params.plant.net_factors.availability * params.plant.net_factors.planned_outages * params.plant.net_factors.unplanned_outages","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":132,"value":"function fDegredation(year, month) {\n if (year === 1) { \n return 1 - params.plant.degredation.year_one/12*month \n } else {\n return 1 - (params.plant.degredation.year_one + (params.plant.degredation.year_plusone * (year - 2)) + (params.plant.degredation.year_plusone/12*month))\n }\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"monthly_yield_totals = {\n return monthly_hours.map((m,i) => {\n let obs=Object.entries(m)\n obs.pop()\n return d3.sum(obs, v => v[1])\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"md `\n### Params\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":116,"value":"fBaseCase = function() {\n let p = JSON.parse(JSON.stringify(base_params))\n p.name = 'Base Case'\n return p\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"scenario={\n let s = scenarios[scenario_number].fn()\n s.number = scenario_number\n return s\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"scenarios = [\n {name: 'Base Case', fn: fBaseCase},\n //{name: 'APV Cases', fn: fAPV},\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"base_params = {\n return {\n discount_rate: 0.1,\n plant: {\n yield_curve: 'p50',\n capacity: 25,\n net_factors: { \n availability: 0.98,\n planned_outages: 0.998,\n unplanned_outages: 0.995\n },\n degredation: {\n year_one: 0.02,\n year_plusone: 0.0035\n } \n },\n greenco: {\n indexation: 2,\n base_tariff: 45,\n adjustment_cap_plus: 40,\n adjustment_cap_minus: 5,\n adjustment_factor_up: 80,\n adjustment_factor_down: 80,\n fixed_transaction_cost: 15,\n actual_transaction_cost: 15,\n buffer_initial: 3.04,\n buffer_6mo_increment: 0.102,\n buffer_increments: 5 \n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"md `\n### Data\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"monthly_hours = params.plant.yield_curve==='p90'? monthly_hours_p90 : monthly_hours_p50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"monthly_hours_p90 = d3.groups(calMonthlyHours_raw,v=>v.month).map(v=>v[1].map(l=>l.p90HourlyEnergyMWh))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"monthly_hours_p50=d3.groups(calMonthlyHours_raw,v=>v.month).map(v=>v[1].map(l=>l.medianHourlyEnergyMWh))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"calMonthlyHours_raw = {\n const raw = (await d3.csv(base_url + \"/pv/iluteCalmonthlyHours.csv?\" + Math.floor(Math.random() * 1000),d3.autoType))\n return raw\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"base_url='https://data.africanpowerprojects.com/sapp/output/'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"import {monthly_solar_price} from \"@andyflem/app-solar-benchmark\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"import {solar_chart} from \"@andyflem/app-solar-benchmark\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"md `\n### Style\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"makeTrans=function(col,opacity) {\n let c=d3.color(col)\n c.opacity=opacity\n return c.formatRgb()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"font = ({\n family: 'Courier New, monospace',\n size: 13,\n color: '#6f6f6f'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"style=html`css\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"md `\n### Libs\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"function colr_b(i = 1, a = 1) {\n return d3hsv.hsv(215, 1, ((6 - i + 1.5) * 15)/120, a).toString();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":241,"value":"function colr(i = 1, a = 1) {\n return d3hsv.hsv(26, 0.85, ((6 - i + 1.5) * 15)/100, a).toString();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"container = function(captionText, width_over) {\n const div=DOM.element('div')\n div.setAttribute(\"class\",\"border m-2 p-2\")\n div.setAttribute(\"style\",`width: ${width_over?width_over:(width>800?800:width)}px`)\n if (captionText) {\n const caption=DOM.element('figcaption')\n caption.setAttribute(\"style\",\"max-width:100%\")\n caption.append(captionText)\n div.append(caption)\n }\n return div\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"d3hsv = require(\"d3-hsv@0.1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"applyFn=function(object1, object2, index, fn) {\n return fn(objIndex(object1, index),objIndex(object2, index))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"objIndex = function(obj, indx) {\n // Retrieve from an object using a hierarchical index either as an array ['greenco','buffer'] or string 'greenco.buffer'\n if (!Array.isArray(indx)) { indx = indx.split('.') }\n let ret=obj\n indx.forEach(v => ret = ret[v])\n return ret\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"setObjIndex = function(obj, indx, val) {\n // Set an object value using a hierarchical index either as an array ['greenco','buffer'] or string 'greenco.buffer'\n if (!Array.isArray(indx)) { indx = indx.split('.') }\n let ret=obj\n indx.forEach((v, i) => {\n if (i