30:Tadf,

The Southern African Power Pool (SAPP) was created in August 1995. SAPP has seventeen members from twelve member countries including national utilities, transmission companies and independent generators. SAPP established the Short-Term Energy Market in April 2001. From January 2004, SAPP started the development of a competitive electricity market for the SADC region.

SAPP operates four competitive markets, the Day-ahead Market (DAM), Intraday Market (IDM), Forward Physical Weekly (FPW) and Forward Physical Monthly (FPM).

For information on the Day-ahead market:

For information on the other markets:

The APP Solar Benchmark tracks the price that a representative solar PV plant situated in western Zambia would receive selling all its power on the SAPP DAM market.
The APP Wind Benchmark tracks the price that a representative wind plant situated in eastern Zambia would receive selling all its power on the SAPP DAM market.

31:T1001,{ let prev_year=monthly[selected_month-12] let cal_month=calmonthly_dict[month.month] function diff(a,b) { return html` (${d3.format('+,.0%')((a-b)/b)})` } function diff2(a,b, cont) { return html`${cont}` } function spark(ser, fld) { return Plot.plot({ height: 120, width: 300, marginLeft:27,marginTop:5,marginRight:5,marginBottom:20, y: {grid: true, ticks: 3}, marks: [ Plot.line(ser.slice(-18), {x: "date", y: fld}), Plot.dot([[ser[selected_month].date,ser[selected_month][fld]]],{stroke: 'red', fill:'red'}) ] }) } let values = [month.dam.value,month.idm.value,month.fpm.value,month.fpw.value] let total = d3.sum(values) function value() { var data = [{ values: values, text: values.map(v=>'$' + d3.format(',.1f')(v/1000000) + 'm'), labels: [ 'DAM ' + d3.format(',.2r')(values[0]/total*100) +'%', 'IDM ' + d3.format(',.2r')(values[1]/total*100) +'%', 'FPM ' + d3.format(',.2r')(values[2]/total*100) +'%', 'FPW ' + d3.format(',.2r')(values[3]/total*100) +'%', ], textinfo: "none", marker: { colors: [marketCol(markets['dam'].col), marketCol(markets['idm'].col), marketCol(markets['fpm'].col), marketCol(markets['fpw'].col)] }, type: 'pie', hoverinfo:'label+text' }] var layout = { height: 190, showlegend: true, width: 300,margin: {l: 5,r: 5,b: 5,t: 5}, } const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}) return div } return html`

${diff2(month.value,prev_month.value,'SAPP Value')}	${diff2(month.value,prev_month.value,d3.format('$,.2r')(month.value/1000000) + 'm')}
${prev_month.lux_date.toFormat('LLL yyyy')}	${d3.format('$,.2r')(prev_month.value/1000000)}m ${diff(month.value,prev_month.value)}
${prev_year ? prev_year.lux_date.toFormat('LLL yyyy') : '-'}	${prev_year ? d3.format('$,.2r')(prev_year.value/1000000) :'-'}m ${prev_year ? diff(month.value,prev_year.value) : '-'}
${month.lux_date.toFormat('LLL')} Average	${d3.format('$,.2r')(cal_month.value/1000000)}m ${diff(month.value,cal_month.value)}
${spark(monthly,"value_m")}

${diff2(month.volume,prev_month.volume, "SAPP Volume")}	${diff2(month.volume,prev_month.volume,d3.format('.0f')(month.volume/1000) + 'GWh')}
${prev_month.lux_date.toFormat('LLL yyyy')}	${d3.format('.0f')(prev_month.volume/1000)} GWh ${diff(month.volume,prev_month.volume)}
${prev_year ? prev_year.lux_date.toFormat('LLL yyyy') :'-'}	${prev_year ? d3.format('.0f')(prev_year.volume/1000): '-'} GWh ${prev_year ? diff(month.volume,prev_year.volume) : '-'}
${month.lux_date.toFormat('LLL')} Average	${d3.format('.0f')(cal_month.volume/1000)} GWh ${diff(month.volume,cal_month.volume)}
${spark(monthly,"volume_gwh")}

` }32:Tb31,{ let cur_month=[monthly[selected_month].dam, monthly[selected_month].fpm,monthly[selected_month].fpw,monthly[selected_month].idm] let prev_month=[monthly[selected_month-1].dam, monthly[selected_month-1].fpm,monthly[selected_month-1].fpw,monthly[selected_month-1].idm] let prev_year=[monthly[selected_month-12].dam, monthly[selected_month-12].fpm,monthly[selected_month-12].fpw,monthly[selected_month-12].idm] let cal_month=[calmonthly[month.month-1],fpm_calmonthly[month.month-1],fpw_calmonthly[month.month-1],idm_calmonthly[month.month-1]] function diff(a,b) { return html` (${d3.format('+,.0%')((a-b)/b)})` } function diff2(a,b, cont) {3 return html`${cont}` } function spark(ser, fld) { return Plot.plot({ height: 120, width: 300, marginLeft:27,marginTop:5,marginRight:5,marginBottom:20, y: {grid: true, ticks: 3}, marks: [ Plot.line(ser.slice(-18).map(v=>v[fld]), {x: "date", y: "price_mean"}), Plot.dot([[ser[selected_month].date,ser[selected_month][fld].price_mean]],{stroke: 'red', fill:'red'}) ] }) } function table(name,indx,spark_dat) { return html`

Value breakdown by Market

${value()}

${diff2(cur_month[indx].price_mean,prev_month[indx].price_mean, name)}	${diff2(cur_month[indx].price_mean,prev_month[indx].price_mean, d3.format('$,.0f')(cur_month[indx].price_mean) + '/MWh')}
${prev_month[indx].lux_date.toFormat('LLL yyyy')}	${d3.format('$,.0f')(prev_month[indx].price_mean)}/MWh ${diff(cur_month[indx].price_mean,prev_month[indx].price_mean)}
${prev_year[indx] ? prev_year[indx].lux_date.toFormat('LLL yyyy') : '-'}	${prev_year[indx] ? d3.format('$,.0f')(prev_year[indx].price_mean) :'-'}/MWh ${prev_year[indx] ? diff(cur_month[indx].price_mean,prev_year[indx].price_mean) : '-'}
${cur_month[indx].lux_date.toFormat('LLL')} Average	${d3.format('$,.0f')(cal_month[indx].price_mean)}/MWh ${diff(cur_month[indx].price_mean,cal_month[indx].price_mean)}
${spark(monthly,spark_dat)}

` } return html`

${table('DAM', 0, 'dam')}

${table('IDM', 3, 'idm')}

${table('FPM', 1, 'fpm')}

${table('FPW', 2, 'fpw')}

` }33:T8ec,{ function values() { function series(ref) { return { y: monthly.map((v,i)=>v[ref] ? v[ref].volume/1000 : undefined), x: monthly.map(h=> h.date), mode: 'lines', marker: {color: marketCol(markets[ref].col)}, type: 'bar', hoverinfo: 'x,y', name: markets[ref].name, stackgroup: 'one', } } var data = Object.entries(markets).map(m=>series(m[0])) data.push({ y: monthly.map((v,i)=>v.volume/1000), x: monthly.map(h=> h.date), mode: 'none', line: {shape: '', color: 'grey', width:2}, type: 'scatter', hoverinfo: 'x,y', showlegend:false,name:'Total' }) var layout = { height: 250, width: width-30, font: font, barmode: 'stack', showlegend: true, legend: {xanchor: 'left', x:0, y: 1, orientation:'h'}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showticklabels:true, showgrid: true, zeroline: false, ticks:'outside', }, yaxis: { range:[0,340], title: 'GWh', showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside' } }; const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}) return div } function proportion() { function series(ref) { return { y: monthly.map((v,i)=>v[ref] ? v[ref].volume/monthly[i].volume : undefined), x: monthly.map(h=> h.date), mode: 'lines', line: {shape: '', color: marketCol(markets[ref].col), width:1}, fill:'tonexty', type: 'scatter', hoverinfo: 'x,y', name: markets[ref].name, stackgroup: 'one', } } var data = Object.entries(markets).map(m=>series(m[0])) var layout = { height: 140, width: width - 30, font: font, showlegend: false, legend: {xanchor: 'left', x:0, y: 1, orientation:'h'}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks:'outside', }, yaxis: { range:[0,1.1], title: '', showgrid: true, zeroline: false, tickformat: '.0%', ticks:'outside' } } const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}) return div } const div=container('Monthly volume traded on each of the SAPP markets.') div.prepend(proportion()) div.prepend(values()) return html`${div}` }34:T8f4,{ function values() { function series(ref) { return { y: monthly.map((v,i)=>v[ref] ? v[ref].value/1000000 : undefined), x: monthly.map(h=> h.date), mode: 'lines', marker: {color: marketCol(markets[ref].col), width:1}, type: 'bar', hoverinfo: 'x,y', name: markets[ref].name, stackgroup: 'one', } } var data = Object.entries(markets).map(m=>series(m[0])) data.push({ y: monthly.map((v,i)=>v.value/1000000), x: monthly.map(h=> h.date), mode: 'none', line: {shape: '', color: 'grey', width:2}, type: 'scatter', hoverinfo: 'x,y', showlegend:false,name:'Total' }) var layout = { height: 250, width: width-30, font: font, barmode:'stack', showlegend: true, legend: {xanchor: 'left', x:0, y: 1, orientation:'h'}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showticklabels:true, showgrid: true, zeroline: false, ticks:'outside', }, yaxis: { range:[0,26], title: '$m', showgrid: true, zeroline: false, tickformat: '.1f', ticks:'outside' } }; const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}) return div } function proportion() { function series(ref) { return { y: monthly.map((v,i)=>v[ref] ? v[ref].value/monthly[i].value : undefined), x: monthly.map(h=> h.date), mode: 'lines', line: {shape: '', color: marketCol(markets[ref].col), width:1}, fill:'tonexty', type: 'scatter', hoverinfo: 'x,y', name: markets[ref].name, stackgroup: 'one', } } var data = Object.entries(markets).map(m=>series(m[0])) var layout = { height: 140, width: width - 30, font: font, showlegend: false, legend: {xanchor: 'left', x:0, y: 1, orientation:'h'}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks:'outside', }, yaxis: { range:[0,1.1], title: '', showgrid: true, zeroline: false, tickformat: '.0%', ticks:'outside' } } const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}) return div } const div=container('Monthly value traded on each of the SAPP markets.') div.prepend(proportion()) div.prepend(values()) return html`${div}` }35:T489,{ function series(ref) { return { y: monthly.map((v,i)=>v[ref] ? v[ref].power_mean : undefined), x: monthly.map(h=> h.date), mode: 'lines', line: {shape: '', color: marketCol(markets[ref].col), width:2}, fill:'', type: 'scatter', hoverinfo: 'x,y', name: markets[ref].name, } } var data = Object.entries(markets).map(m=>series(m[0])) data.push({ y: monthly.map((v,i)=>v.power_mean), x: monthly.map(h=> h.date), mode: 'lines', line: {shape: '', color: 'grey', width:1}, type: 'scatter', hoverinfo: 'x,y', showlegend:false,name:'Total' }) var layout = { height: 270, width: width-30, font: font, showlegend: true, legend: {xanchor: 'left', x:0, y: 1, orientation:'h'}, margin: {l: 50,r: 5,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks:'outside', }, yaxis: { range:[0, 520], title: 'MW', showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside' } }; const div=container('Average traded power.') plt.newPlot(div, data, layout,{displayModeBar: false}) return html`${div}` }36:[{"id":"f97fdeb7341d3f752a7271f84a46608de7c558c00d96c577adeee0965b8603a8c97870615569a9fa16d0c6fa12d7e7b4892657bad77501f966f08b8e13e8e6b9","href":"https://static.observableusercontent.com/files/f97fdeb7341d3f752a7271f84a46608de7c558c00d96c577adeee0965b8603a8c97870615569a9fa16d0c6fa12d7e7b4892657bad77501f966f08b8e13e8e6b9","name":"APP logo.png","type":"image/png","lastModified":1657002631356.872,"size":92844}] 2e:{"title":"SAPP Markets","cells":[{"id":0,"value":"md`# SAPP Markets`","pinned":false,"hidden":false,"mode":"ojs"},{"id":402,"value":"$30","pinned":false,"hidden":false,"mode":"html"},{"id":753,"value":"

SAPP Markets Monthly Bulletin

","pinned":false,"hidden":false,"mode":"html"},{"id":423,"value":"viewof selected_month = {\n const form = html``;\n form.oninput = () => {\n form.querySelector(\"[id=month_disp]\").textContent = monthly[form.month_index.valueAsNumber].lux_date.toFormat('LLL yyyy')\n form.value = form.month_index.valueAsNumber;\n };\n form.oninput();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":426,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":611,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":378,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":239,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":275,"value":"{ \n\n function series(ref) {\n\n return {\n y: monthly.map((v,i)=>v[ref] ? v[ref].price_weight_mean : undefined),\n x: monthly.map(h=> h.date), \n mode: 'lines', line: {shape: '', color: marketCol(markets[ref].col), width:2},\n type: 'scatter', hoverinfo: 'x,y', name: markets[ref].name, \n } \n }\n \n var data = Object.entries(markets).map(m=>series(m[0]))\n \n var layout = {\n height: 270, width: width-30,\n font: font, \n showlegend: true, legend: {xanchor: 'left', x:0, y: 1, orientation:'h'},\n margin: {l: 50,r: 5,b: 30,t: 0},\n xaxis: { \n showgrid: true, zeroline: false, ticks:'outside',\n },\n yaxis: {\n range:[0, 180],\n title: '$/MWh',\n showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside'\n }\n };\n\n const div=container('Monthly volume weighted average price.')\n plt.newPlot(div, data, layout,{displayModeBar: false})\n return html`${div}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":281,"value":"{ \n function series(ref) {\n return {\n y: monthly.map((v,i)=>v[ref] ? v[ref].price_mean : undefined),\n x: monthly.map(h=> h.date), \n mode: 'lines', line: {shape: '', color: marketCol(markets[ref].col), width:2}, fill:'',\n type: 'scatter', hoverinfo: 'x,y', name: markets[ref].name, \n } \n }\n \n var data = Object.entries(markets).map(m=>series(m[0]))\n \n var layout = {\n height: 270, width: width - 30,\n font: font, \n showlegend: true, legend: {xanchor: 'left', x:0, y: 1, orientation:'h'},\n margin: {l: 50,r: 5,b: 30,t: 0},\n xaxis: { \n showgrid: true, zeroline: false, ticks:'outside',\n },\n yaxis: {\n range:[0, 190],\n title: '$/MWh',\n showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside'\n }\n };\n\n const div=container('Average hourly price.')\n plt.newPlot(div, data, layout,{displayModeBar: false})\n return html`${div}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":271,"value":"html`\n

\n

Setup

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":454,"value":"month=monthly[selected_month]","pinned":false,"hidden":false,"mode":"ojs"},{"id":456,"value":"prev_month=monthly[selected_month-1]","pinned":false,"hidden":false,"mode":"ojs"},{"id":429,"value":"calmonthly_dict=Object.fromEntries(calmonthly.map(n=>[n.month,n]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":445,"value":"calmonthly = {\n return d3.rollups(monthly, v => {return { month: v[0].lux_date.month, volume: d3.mean(v, t => t.volume), value: d3.mean(v, t => t.value), price_mean: d3.mean(v, t => t.price_mean ) }}, v => v.lux_date.month).map(v=>v[1])\n\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":324,"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"},{"id":305,"value":"function marketCol(index) {\n return d3.schemeSet2[index]\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"markets={\n return {\n \"dam\":{ name: \"Day-ahead Market\", ref: \"dam\", col: 0},\n \"idm\":{ name: \"Intraday Market\", ref: \"idm\", col: 1},\n \"fpm\":{ name: \"Forward Physical Monthly\", ref: \"fpm\", col: 3},\n \"fpw\":{ name: \"Forward Physical Weekly\", ref: \"fpw\", col: 2},\n \n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"dam= get_monthly('dam')","pinned":false,"hidden":false,"mode":"ojs"},{"id":618,"value":"dam_calmonthly= get_calmonthly('dam')","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"fpm= get_monthly('fpm')","pinned":false,"hidden":false,"mode":"ojs"},{"id":622,"value":"fpm_calmonthly = get_calmonthly('fpm')","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"value":"monthly={\n const fpm_dict= Object.fromEntries(fpm.map(n=>[n.date,n]))\n const fpw_dict= Object.fromEntries(fpw.map(n=>[n.date,n]))\n const idm_dict= Object.fromEntries(idm.map(n=>[n.date,n]))\n let mn = dam.map(d => {\n return {\n date: d.date,\n lux_date: d.lux_date,\n month: d.lux_date.month,\n dam: d,\n fpm: fpm_dict[d.date],\n fpw: fpw_dict[d.date],\n idm: idm_dict[d.date]\n }\n })\n mn.map(m=>{\n m.volume = (m.dam.volume) + (m.fpw ? m.fpw.volume : 0) + (m.fpm ? m.fpm.volume : 0) + (m.idm ? m.idm.volume : 0)\n m.value = (m.dam.value) + (m.fpw ? m.fpw.value : 0) + (m.fpm ? m.fpm.value : 0) + (m.idm ? m.idm.value : 0)\n m.power_mean = (m.dam.power_mean) + (m.fpw ? m.fpw.power_mean : 0) + (m.fpm ? m.fpm.power_mean : 0) + (m.idm ? m.idm.power_mean : 0)\n })\n mn.map(m=>{\n m.price_mean = m.value / m.volume\n m.value_m = m.value/1000000\n m.volume_gwh = m.volume / 1000\n }) \n return mn\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":135,"value":"fpw= get_monthly('fpw')","pinned":false,"hidden":false,"mode":"ojs"},{"id":625,"value":"fpw_calmonthly= get_calmonthly('fpw')","pinned":false,"hidden":false,"mode":"ojs"},{"id":331,"value":"idm = get_monthly('idm')","pinned":false,"hidden":false,"mode":"ojs"},{"id":627,"value":"idm_calmonthly = get_calmonthly('idm')","pinned":false,"hidden":false,"mode":"ojs"},{"id":616,"value":"function get_calmonthly(market_ref) {\n\n return d3.csv(base_url + market_ref + \"_calmonthly.csv?\" + Math.floor(Math.random() * 1000),d3.autoType)\n .then(raw=>{\n return raw.map(r=>{\n r.lux_date=DateTime.fromObject({year: r.year, month: r.month, day: 1, hour:0, zone:0})\n r.date=r.lux_date.toJSDate()\n return r\n })\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"function get_monthly(market_ref) {\n console.log(base_url + market_ref + \"_monthly.csv\")\n return d3.csv(base_url + market_ref + \"_monthly.csv?\" + Math.floor(Math.random() * 1000),d3.autoType)\n .then(raw=>{\n return raw.map(r=>{\n r.lux_date=DateTime.fromObject({year: r.year, month: r.month, day: 1, hour:0, zone:0})\n r.date=r.lux_date.toJSDate()\n return r\n })\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"base_url='https://data.africanpowerprojects.com/sapp/output/'","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"font = ({\n family: 'Courier New, monospace',\n size: 13,\n color: '#6f6f6f'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"plt = require(\"https://cdn.plot.ly/plotly-latest.min.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"style=html`css `","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"DateTime = luxon.DateTime","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"luxon = require(\"luxon@1/build/amd/luxon.js\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W36","stdlib":"1","titling":"auto"}

${diff2(month.value,prev_month.value,'SAPP Value')}

${diff2(month.value,prev_month.value,d3.format('$,.2r')(month.value/1000000) + 'm')}

${diff2(month.volume,prev_month.volume, "SAPP Volume")}

${diff2(month.volume,prev_month.volume,d3.format('.0f')(month.volume/1000) + 'GWh')}

Value breakdown by Market

${diff2(cur_month[indx].price_mean,prev_month[indx].price_mean, name)}

${diff2(cur_month[indx].price_mean,prev_month[indx].price_mean, d3.format('$,.0f')(cur_month[indx].price_mean) + '/MWh')}

SAPP Markets Monthly Bulletin

Setup