2c:null 2d:["$","title",null,{"children":"APP Solar Benchmark | Andy Fleming | Observable"}] 32:T5d4,{ var data = [...Array(12).keys()].map(month_no=>{ return { y:relative_disp[month_no], x:[...Array(24).keys()], mode: 'lines', line: {shape:'spline',color: d3.quantize(d3.interpolateHcl("#d66000", "#a9a9b4"), 12)[month_no],width:2}, fill:'', type: 'scatter', hoverinfo: 'name', showlegend:true, name: month_names[month_no] } }) var layout = { height: 250, width: width-30, font: font, hovermode:'closest', showlegend: true, legend: {orientation: 'h', xanchor: 'left', x:0, y: 1}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks:'outside', dtick:1, }, yaxis: { title: 'Output', range: [0,1.19], showgrid: true, zeroline: false, tickformat: '%.0f', ticks:'outside' } }; const div=container('Hourly plant output relative to installed capacity by calendar month. For an undegraded plant.') plt.newPlot(div, data, layout,{displayModeBar: false}) div.on('plotly_hover', d => { var curveNumber = d.points[0].curveNumber var vals = div.data.map((_, i) => (i === curveNumber) ? 1 : 0.2) var vals2 = div.data.map((_, i) => (i === curveNumber) ? 'tozeroy' : '') plt.restyle(div, 'opacity', vals) plt.restyle(div, 'fill', vals2) }) div.on('plotly_unhover', d => { var vals = div.data.map((_, i) => 1) var vals2 = div.data.map((_, i) => '') plt.restyle(div, 'opacity', vals) plt.restyle(div, 'fill', vals2) }) return div }33:T5da,{ var data = [ { y: daily.map(d=>d.price_max).concat(daily.map(d=>d.price_min).reverse()), x: daily.map(d=>d.date).concat(daily.map(d=>d.date).reverse()), mode: 'lines', line: { width: 0}, fill:'toself', fillcolor:'rgba(100, 149, 237,0.3)', type: 'scatter', hoverinfo: 'none', showlegend:false,name: '', } , { y: daily.map(d=>d.price_weight_av), x: daily.map(d=>d.date), mode: 'lines', line: {shape: 'spline', color:'grey', width: 1.5}, type: 'scatter', hoverinfo: 'none', showlegend:false,name: '', }, { y: movingAverage(daily.map(d=>d.price_weight_av),14), x: daily.map(d=>d.date), mode: 'lines', line: {shape: 'spline', color:d3.schemeCategory10[3], width: 1.5}, type: 'scatter', hoverinfo: 'x,y', showlegend:false,name: '', }, ] var layout = { height: 250, width: width-30, font: font, showlegend: true, legend: {xanchor: 'left', x:0, y: 1}, margin: {l: 50,r: 5,b: 5,t: 0}, xaxis: { rangeslider: {}, range:years_range, showgrid: true, zeroline: false, ticks:'outside', }, yaxis: { title: '$/MWh', range: [0,320], showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside' } }; const div=container('SAPP DAM weighted average daily price. 14 day moving average in red. Blue area is the daily maximum and minimum prices.') plt.newPlot(div, data, layout,{displayModeBar: false}); return div }34:T451,{ var data = [ { y: daily_price.map(d=>d[1].price), x: daily_price.map(d=>d[0]), mode: 'lines', line: {shape: '', color:col, width: 1.5}, type: 'scatter', hoverinfo: 'x+y', showlegend:false,name: '', }, { y: movingAverage(daily_price.map(d=>d[1].price),14), x: daily_price.map(d=>d[0]), mode: 'lines', line: {shape: 'spline', color:'#566573', width: 1.5}, type: 'scatter', hoverinfo: 'none', showlegend:false,name: '', }, ] var layout = { height: 250, width: width-30, font: font, showlegend: true, legend: {xanchor: 'left', x:0, y: 1}, margin: {l: 50,r: 5,b: 5,t: 0}, xaxis: { rangeslider: {}, range: years_range, showgrid: true, zeroline: false, ticks: 'outside', }, yaxis: { title: `$/MWh`, showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside' } }; const div=container('APP Solar Benchmark price calculated daily from 2016 to date. Grey line: 14 day moving average.') plt.newPlot(div, data, layout,{displayModeBar: false}); return div }35:T4f2,{ var data = [{ y: annual_mean.map(v => v[1]), x: annual_mean.map(v => v[0]), text: annual_mean.map(v => d3.format('.1f')(v[1])), name: 'Yearly mean', marker: {color:make_trans(col,0.55)}, type: 'bar', hoverinfo: 'y', showlegend:true, mode:'markers+text', textposition:'outside' }, { y: means.map(v => v.mean), x: means.map(v => v.year), text: means.map(v => d3.format('.1f')(v.mean)),name: 'Expanding average from 2025 back', line: {color:col}, type: 'scatter', hoverinfo: 'y', showlegend:true, mode:'markers+text+lines', textposition:'top' }] var layout = { height: 250, width: width *.5, font: font, barmode:'stack', showlegend: true, legend: {orientation:'h',xanchor: 'left', x:0, y: 1}, margin: {l: 65,r: 10,b: 30,t: 0}, xaxis: { showgrid: false, zeroline: false, ticks:'outside', dtick:1}, yaxis: { title: '$/MWh', showgrid: true, zeroline: true, tickformat: ',.0f', ticks:'outside', range: [40,160] }}; const div=container('Annual average APP Solar Benchmark price (bars) and the expanding average from 2025 back (line).') plt.newPlot(div, data, layout,{displayModeBar: false}); return div }36:T66b,{ function series(dat, col, nam) { let p90 = dat[Math.floor(dat.length*0.1)] let p50 = dat[Math.floor(dat.length*0.5)] return [{ y: dat.map(v=>v.price), x: dat.map(v=>v.exceedance), mode: 'lines', line: {shape: 'spline', color: col, width:3}, fill:'', type: 'scatter', hoverinfo: 'x,y', name: nam, }, { y: [p90.price], x: [p90.exceedance], text: [d3.format('$.0f')(p90.price)], mode: 'markers+text', marker: {color: col, size:10}, textposition:'top-right', type: 'scatter', hoverinfo: 'none', name: nam, showlegend:false }, { y: [p50.price], x: [p50.exceedance], text: [d3.format('$.0f')(p50.price)], mode: 'markers+text', marker: {color: col, size:10}, textposition:'top-right', type: 'scatter', hoverinfo: 'none', name: nam, showlegend:false } ] } var data = [] data=data.concat(series(solar_pdc,col, '2016 to date')) data=data.concat(series(solar_pdc_recent,make_trans(col,0.5), '2021 to date')) var layout = { height: 270, width: width-30, font: font, showlegend: true, legend: {orientation:'h',xanchor: 'right', x:1, y: 1}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks:'outside', tickformat: '%.0f' }, yaxis: { title: `$/MWh`, showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside' } }; const div=container('Solar benchmark price exceedance curves. Median (P50) and P90 prices highlighted.') plt.newPlot(div, data, layout,{displayModeBar: false}); return div }37:T75d,solar_chart = function(showDAM){ var data = [ { y: monthly_solar_price.map(d=>d[1].price), x: monthly_solar_price.map(d=>d[1].start_date), mode: 'lines+markers', line: {shape: '', color: col, width: 1.5}, type: 'scatter', showlegend:showDAM, fill:'tozeroy', name:'APP Solar Benchmark', hovertemplate: "%{x}
" + "%{y:,.0f} %{yaxis.title.text}" + "", } , { y: annual_mean.map(d=>d[1]), text: annual_mean.map(d=>'$'+d3.format(',.0f')(d[1])+'/MWh'), x: annual_mean.map(d=>DateTime.fromObject({year:d[0],month:6,day:1}).toJSDate()), mode: 'markers+text', marker: { color: '#444', size: 8},textposition:'topright', type: 'scatter', showlegend:false, name:'', hoverinfo:'text' } ] if (showDAM) { data.push({ y: monthly.map(d=>d.price_mean), x: monthly.map(d=>d.date), mode: 'lines+markers', line: {shape: '', color: '#444', width: 1}, marker:{size:2}, type: 'scatter', showlegend:true, fill:'', name:'SAPP DAM Average Price', hovertemplate: "%{x}
" + "%{y:,.0f} %{yaxis.title.text}" + "", }) } var layout = { height: 220, width: width-30, font: font, showlegend: true, legend: {orientation: 'h',xanchor: 'left', x:0, y: 1}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks: 'outside', range:[d3.min(monthly_solar_price, d=>d[1].start_date),d3.max(monthly_solar_price, d=>d[1].start_date)] }, yaxis: { range: [20,230], title: `$/MWh`, showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside' } }; const div=container('Monthly average APP Solar Benchmark price from 2016 to date.') plt.newPlot(div, data, layout,{displayModeBar: false}); return div }38:T44a,solar_variance_chart=function(){ var data = [ { y: monthly_solar_variance.map(d=>d.variance), x: monthly_solar_variance.map(d=>d.start_date), marker: {color: make_trans(col,0.7)}, type: 'bar', showlegend:false, fill:'tozeroy', name:'APP Wind Benchmark', hovertemplate: "%{x}
" + "%{y:%.0f} %{yaxis.title.text}" + "", } ] var layout = { height: 200, width: width-30, font: font, showlegend: true, legend: {orientation: 'h',xanchor: 'left', x:0, y: 1}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks: 'outside', range:[d3.min(monthly_solar_price, d=>d[1].start_date),d3.max(monthly_solar_price, d=>d[1].start_date)+20] }, yaxis: { title: ``, range:[-0.32,0.32], showgrid: true, zeroline: false, tickformat: '%.0f', ticks:'outside' } }; const div=container('Relative APP Solar Benchmark price compared to the average SAPP DAM Price.') plt.newPlot(div, data, layout,{displayModeBar: false}); return div }39:[{"id":"f97fdeb7341d3f752a7271f84a46608de7c558c00d96c577adeee0965b8603a8c97870615569a9fa16d0c6fa12d7e7b4892657bad77501f966f08b8e13e8e6b9","href":"https://static.observableusercontent.com/files/f97fdeb7341d3f752a7271f84a46608de7c558c00d96c577adeee0965b8603a8c97870615569a9fa16d0c6fa12d7e7b4892657bad77501f966f08b8e13e8e6b9","name":"APP logo.png","type":"image/png","lastModified":1660249420064.245,"size":92844}] 30:{"id":"b1d9c4bee4b81200","slug":"app-solar-benchmark","title":"APP Solar Benchmark","thumbnail":"e70a2a9b16e97ec2210b69d64f22ea794e42e09d50f1af08c399acc645799fd6","access_level":"public","create_time":"$D2022-08-11T20:09:13.243Z","update_time":"$D2026-06-05T12:05:50.903Z","view_time":null,"first_public_time":"$D2022-08-12T20:02:06.717Z","has_unpublished_edits":null,"fork":true,"stars":2,"starred":false,"owner":{"type":"team","id":"21337e734770a90b","login":"andyflem","name":"Andy Fleming","avatar_url":"https://avatars-next.observableusercontent.com/fd3844143a4c29872f0df28a8ebce77bb56cebf2fa74bb669872e4def82ad809","tier":"starter_2024"},"version":7137,"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":"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":4,"collection":{"id":"7d6d01969d5f1ad9","slug":"southern-african-power-pool","title":"Southern African Power Pool","owner":{"id":"21337e734770a90b","login":"andyflem","name":"Andy Fleming"}},"type":"notebook","body":{"titling":"auto","title":"APP Solar Benchmark","cells":[{"id":0,"value":"html`

APP Solar Benchmark

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6825,"value":"

\n\n

\n The APP Solar Benchmark is a reference price (in $/MWh) that would be achieved by a nominal grid-connected solar PV plant that sells all of its energy on the Southern African Power Pool (SAPP) Day-ahead Market (DAM).\n

\n The APP Solar Benchmark is calculated by combining the hourly settlement price of the SAPP DAM market with the hourly relative output of a solar PV plant located in Western Zambia.\n

\n
\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7068,"value":"solar_chart(false)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7072,"value":"solar_variance_chart()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6968,"value":"

Calculating the benchamrk

Solar plant

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6851,"value":"html`\nPlant: Ground-mounted, single-axis tracking mounting system, with bifacial mono-crystalline PV modules and string inverters.
\nLocation: 17°S, 23°E
\nAnnual GHI: 2,215kWh/m2
\nUndegraded Gross Yield: ${d3.format(',.0f')(specific_yield)} MWh/MWac/year
\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6895,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5593,"value":"html`\n

Market Price

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6536,"value":"html`\nThe price on the Southern African Power Pool (SAPP) day-ahead market (DAM) varies hour by hour and average daily prices vary over time. On average prices are lowest at night (and on Sundays and public holidays) and there are two peak periods in during weekday mornings and evenings. An intermediate price occurs during the day on weekdays. \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1924,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6517,"value":"{ \n var selected_months=['Mar','Jun', 'Aug', 'Dec']\n let data = selected_months.map((m, i)=>{\n const ser = month_profiles[month_dict[m].index]\n return {\n y: [...Array(24).keys()].map(h=>ser.get(h)),\n mode: 'lines', line: {shape: 'spline', color: d3.schemeDark2[month_dict[m].group], width:3}, fill:'',\n type: 'scatter', hoverinfo: 'x,y', name: m,\n }\n })\n \n var layout = {\n height: 250, width: width-30,\n font: font, \n showlegend: true, legend: {xanchor: 'left', x:1,y: 1},\n margin: {l: 50,r: 5,b: 30,t: 0},\n xaxis: {\n title: '',\n showgrid: true, zeroline: false, dtick: 1, ticks:'outside',\n },\n yaxis: {\n range: [20,240],\n title: `$/MWh`,\n showgrid: false, zeroline: false, tickformat: '.0f', ticks:'outside'\n }\n };\n\n const div=container('Average price on the SAPP DAM market by time-of-day for selected months for 2020 to date.')\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":5599,"value":"html`\n

Solar benchmark price

Setup

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6942,"value":"col='#d68910'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6913,"value":"container = function(captionText) {\n const div=DOM.element('div')\n div.setAttribute(\"class\",\"border m-2 p-2\")\n const caption=DOM.element('figcaption')\n caption.append(captionText)\n div.append(caption)\n return div\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5466,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7026,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7084,"value":"monthly_solar_variance = monthly_solar_price.map((d,month_no)=>\n{\n return {\n lux_date: d[1].lux_date,\n start_date: d[1].start_date,\n variance:(d[1].price-monthly[month_no].price_mean)/monthly[month_no].price_mean\n}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1469,"value":"md `\n## Solar\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6862,"value":"specific_yield = yield_total/capacity","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6860,"value":"capacity = 25","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6857,"value":"yield_total = d3.sum(monthly_yield_totals)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6979,"value":"solar_pdc_recent={\n let out={}\n\n let prices=JSON.parse(JSON.stringify(daily_price.filter(a=>a[1].lux_date.year>2020))).sort((a,b)=>a[1]['price']-b[1]['price'])\n out=prices.map((d,i)=>{\n return {\n exceedance: 1-(i/prices.length),\n price: d[1]['price']?d[1]['price']:0\n }\n })\n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6976,"value":"solar_pdc={\n let out={}\n let prices=JSON.parse(JSON.stringify(daily_price)).sort((a,b)=>a[1]['price']-b[1]['price'])\n out=prices.map((d,i)=>{\n return {\n exceedance: 1-(i/prices.length),\n price: d[1]['price']?d[1]['price']:0\n }\n })\n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6469,"value":"monthly_yield_totals = {\n return monthly_hours_p50.map(m => {\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":6057,"value":"relative_yield_profiles = {\n return monthly_hours_p50.map((m, i) => {\n let tmp = Object.keys(m).map(h=>{\n return m[h]/monthly_yield_totals[i]\n })\n tmp.pop()\n return tmp\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6878,"value":"relative_disp = monthly_hours_p50.map((m,i) => Object.values(m).slice(0,24).map(h=>h))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6031,"value":"md `\n### SAPP DAM\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6522,"value":"month_profiles=[...Array(12).keys()].map(m=>month_profile_price(m+1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6524,"value":"function month_profile_price(month_no) {\n return d3.rollup(calmonthly_hours.filter(m=>m.month==month_no),v=>d3.mean(v,m=>m.price),t=>t.hour)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3491,"value":"years_range= [monthly[0].lux_date.plus({month:-0.5}).toJSDate(),monthly[monthly.length-1].lux_date.plus({month:0.5}).toJSDate()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6681,"value":"means={\n return annual_mean.map(v => { return {year: v[0], mean: d3.mean(annual_mean.filter(m => m[0] >= v[0]), y => y[1])}})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6588,"value":"annual_mean = d3.rollups(monthly_solar_price, v => d3.mean(v, d => d[1].price), v => DateTime.fromJSDate(v[1].start_date).year)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5341,"value":"monthly_solar_price = {\n \n let ret = d3.rollups(\n daily_price.map(v => v[1]),\n v => {\n return {\n lux_date: v[0].lux_date,\n start_date: d3.min(v, d => d.date),\n weekday_price: d3.mean(v.filter(p => p.lux_date.weekday < 6), d => d.price),\n saturday_price: d3.mean(v.filter(p => p.lux_date.weekday == 6), d => d.price),\n sunday_price: d3.mean(v.filter(p => p.lux_date.weekday == 7), d => d.price),\n price: d3.mean(v, d => d.price),\n }\n },\n v => v.lux_date.year + '_' + v.lux_date.month\n )\n return ret\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5294,"value":"daily_price = d3.rollups(hourly_weighted_price, v => { \n return {\n date: d3.max(v, v=>v.date),\n lux_date: d3.max(v, v=>DateTime.fromJSDate(v.date)),\n price: d3.sum(v, d => d.weighted_price)\n }\n}, v => v.date)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5273,"value":"hourly_weighted_price={\n return hourly.map(h => {\n return {\n date: h.date,\n hour: h.hour,\n weighted_price: h.price * relative_yield_profiles[h.lux_date.month-1][h.hour],\n }\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4499,"value":"md `\n### Data Load\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6526,"value":"calmonthly_hours = {\n const raw = (await d3.csv(base_url + market_ref + \"_calmonthly_hours.csv?\" + Math.floor(Math.random() * 1000),d3.autoType))\n \n return raw\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5278,"value":"hourly = {\n const raw = (await d3.csv(base_url + market_ref + \"_hourly_slim.csv?\" + Math.floor(Math.random() * 1000),d3.autoType))\n raw.forEach(r=>{\n r.lux_date=DateTime.fromJSDate(r.date)\n }) \n return raw\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5090,"value":"monthly_hours_p50=d3.groups(monthly_hours_p50_raw,v=>v.month).map(v=>v[1].map(l=>l.medianHourlyCapFactor))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7116,"value":"monthly_hours_p50_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":2118,"value":"monthly = {\n const raw = (await d3.csv(base_url + market_ref + \"_monthly.csv?\" + Math.floor(Math.random() * 1000),d3.autoType))\n raw.map(r=>{\n r.lux_date=DateTime.fromObject({year: r.year, month: r.month, day: 1})\n r.date=r.lux_date.toJSDate()\n })\n return raw\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1918,"value":"daily = {\n const raw = (await d3.csv(base_url + market_ref + \"_daily.csv?\" + Math.floor(Math.random() * 1000),d3.autoType))\n raw.forEach(r=>{\n r.lux_date=DateTime.fromObject({year: r.year, month: r.month, day: r.day})\n r.date=r.lux_date.toJSDate()\n })\n return raw\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6028,"value":"md `\n### Setup\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4509,"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":4512,"value":"market_ref='dam'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5103,"value":"function month_days(i) {\n if(i === 4 || i === 6 || i === 9 || i === 11) {\n\t\treturn 30\n\t} else if(i === 2) {\n\t\treturn 28\n\t} else {\n\t\treturn 31\n\t}\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5108,"value":"month_names={\n return {\n 0:'Jan',\n 1:'Feb',\n 2:'Mar',\n 3:'Apr',\n 4:'May',\n 5:'Jun',\n 6:'Jul',\n 7:'Aug',\n 8:'Sep',\n 9:'Oct',\n 10:'Nov',\n 11:'Dec',\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5152,"value":"month_dict={\n return {\n 'Jan':{index: 0, days: 31},\n 'Feb':{index: 1, days: 28},\n 'Mar':{index: 2, days: 31},\n 'Apr':{index: 3, days: 30},\n 'May':{index: 4, days: 31},\n 'Jun':{index: 5, days: 30},\n 'Jul':{index: 6, days: 31},\n 'Aug':{index: 7, days: 31},\n 'Sep':{index: 8, days: 30},\n 'Oct':{index: 9, days: 31},\n 'Nov':{index: 10, days: 30},\n 'Dec':{index: 11, days: 31},\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"md `\n### Imports\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4702,"value":"function catCol(index) {\n return d3.schemeCategory10[index]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3027,"value":"make_trans=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":4690,"value":"function movingAverage(values, N) {\n let i = 0;\n let sum = 0;\n const means = new Float64Array(values.length).fill(NaN);\n for (let n = Math.min(N - 1, values.length); i < n; ++i) {\n sum += values[i];\n }\n for (let n = values.length; i < n; ++i) {\n sum += values[i];\n means[i - Math.floor(N / 2)] = sum / N;\n sum -= values[i - N + 1];\n }\n return means;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"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":16,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"plt = require(\"https://cdn.plot.ly/plotly-latest.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5957,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5117,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1201,"value":"ss = require('simple-statistics')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4407,"value":"style=html`css\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2137,"value":"luxon = require(\"luxon@1/build/amd/luxon.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2140,"value":"DateTime = luxon.DateTime","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W39","stdlib":"1"}} 31:"$30:body"