2c:null 2d:["$","title",null,{"children":"Ilute solar project output compared to the SAPP DAM Market | Andy Fleming | Observable"}] 32:T496,{ var data = [...Array(12).keys()].map(month_no=>{ return { y:[...Array(24).keys()].map(hour_no=> (monthly_hours[month_no][hour_no]/month_days(month_no)) / ( month_profiles_volume[month_no].get(hour_no) )), x:[...Array(24).keys()], mode: 'lines', line: {shape:'spline',color: d3.schemeCategory10[month_dict[month_names[month_no]].group],width:2}, fill:'', type: 'scatter', hoverinfo: 'name+y', showlegend:true, name: month_names[month_no] } }) var layout = { height: 300, width: width, font: font, hovermode:'closest', showlegend: true, legend: {xanchor: 'left', x:1,y: 1}, margin: {l: 90,r: 90,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks:'outside', dtick:1, }, yaxis: { title: '', showgrid: true, zeroline: false, tickformat: '%.0f', ticks:'outside' } }; const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}); return html`

${div}

Ilute solar plant output as a proportion of the mean power traded on the SAPP DAM market by month and hour of day. 2016 - 2021 data.

` }33:T42e,{ var data = [...Array(12).keys()].map(month_no=>{ return { y:[...Array(24).keys()].map(hour_no=> monthly_hours[month_no][hour_no]/month_days(month_no)), x:[...Array(24).keys()], mode: 'lines', line: {shape:'spline',color: d3.schemeCategory10[month_dict[month_names[month_no]].group],width:2}, fill:'', type: 'scatter', hoverinfo: 'name', showlegend:true, name: month_names[month_no] } }) var layout = { height: 300, width: width, font: font, hovermode:'closest', showlegend: true, legend: {xanchor: 'left', x:1,y: 1}, margin: {l: 90,r: 90,b: 30,t: 0}, xaxis: { showgrid: true, zeroline: false, ticks:'outside', dtick:1, }, yaxis: { title: 'MW', showgrid: true, zeroline: false, tickformat: '.0f', ticks:'outside', range: [-3,29] } }; const div=DOM.element('div') plt.newPlot(div, data, layout,{displayModeBar: false}); return html`

${div}

Ilute solar undegraded gross plant yield by month and hour of day.

` }34:[] 30:{"id":"afbd04cf9d0004bb","slug":"ilute-versus-sapp-dam","title":"Ilute solar project output compared to the SAPP DAM Market","thumbnail":"fed23e31b740d5682d03f1cc62d0a90f23cb120cbaff6845ad15d82ec3cb009c","access_level":"public","create_time":"$D2021-11-15T14:08:00.106Z","update_time":"$D2021-11-15T14:25:54.225Z","view_time":null,"first_public_time":"$D2021-11-15T14:26:47.747Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"21337e734770a90b","login":"andyflem","name":"Andy Fleming","avatar_url":"https://avatars-next.observableusercontent.com/fd3844143a4c29872f0df28a8ebce77bb56cebf2fa74bb669872e4def82ad809","tier":"starter_2024"},"version":73,"publish_version":73,"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":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Ilute solar project output compared to the SAPP DAM Market","cells":[{"id":0,"value":"# Ilute solar project output compared to the SAPP DAM Market","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"{ \n \n let data = selected_months.map((m, i)=>{\n const ser = month_profiles_volume[i]\n return {\n y: [...Array(24).keys()].map(h=>ser.get(h)),\n mode: 'lines', line: {shape: 'spline', color: d3.schemeCategory10[month_dict[m].group], width:2}, fill:'',\n type: 'scatter', hoverinfo: 'x,y', name: m,\n }\n })\n \n var layout = {\n height: 300, width: width,\n font: font, \n showlegend: true, legend: {xanchor: 'left', x:1,y: 1},\n margin: {l: 90,r: 90,b: 50,t: 0},\n xaxis: {\n title: 'Hour',\n showgrid: true, zeroline: false, dtick: 1, ticks:'outside',\n },\n yaxis: {\n range:[0,410],\n title: `MW`,\n showgrid: false, zeroline: false, tickformat: '.0f', 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

Mean SAPP DAM power traded by month and hour of day.

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

\n

\n

Setup

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"monthly_hours = {\n const raw = (await d3.csv(\"https://gis.westernpower.org/data/sapp/output/pv/25mw_p50.csv?\" + Math.floor(Math.random() * 1000),d3.autoType))\n return raw\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"month_profiles_volume=[...Array(12).keys()].map(m=>month_profile_volume(m+1))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"function month_profile_volume(month_no) {\n return d3.rollup(calmonthly_hours.filter(m=>m.month==month_no),v=>d3.mean(v,m=>m.volume),t=>t.hour)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"calmonthly_hours = {\n const raw = (await d3.csv(\"https://gis.westernpower.org/data/sapp/output/dam_calmonthly_hours.csv?\" + Math.floor(Math.random() * 1000),d3.autoType))\n \n return raw\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"month_dict={\n return {\n 'Jan':{index: 0, group: 1},\n 'Feb':{index: 1, group: 1},\n 'Mar':{index: 2, group: 6},\n 'Apr':{index: 3, group: 6},\n 'May':{index: 4, group: 2},\n 'Jun':{index: 5, group: 2},\n 'Jul':{index: 6, group: 3},\n 'Aug':{index: 7, group: 3},\n 'Sep':{index: 8, group: 4},\n 'Oct':{index: 9, group: 4},\n 'Nov':{index: 10, group: 4},\n 'Dec':{index: 11, group: 1},\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"selected_months=Object.values(month_names).map((cat,i) => cat)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"plt = require(\"https://cdn.plot.ly/plotly-latest.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"font = ({\n family: 'Courier New, monospace',\n size: 13,\n color: '#6f6f6f'\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1"}} 31:"$30:body"