2c:null 2d:["$","title",null,{"children":"Data Source - Test Site | Joshua Cooper | Observable"}] 32:T418,

${(annualcost.total/100).toLocaleString("en-GB", { style: "currency", currency: "GBP", minimumFractionDigits: 0, maximumFractionDigits: 0 })}

annual cost

${(annualcost.value/1000).toLocaleString(undefined, {maximumSignificantDigits: 6})} kWh

annual consumption

33:T5fc,|${daterange.from} to ${daterange.to} - ${client.name} - ${client.postcode}| | --- |---: | |Usage charges|${(annualcost.use/100).toLocaleString("en-GB", { style: "currency", currency: "GBP", minimumFractionDigits: 0, maximumFractionDigits: 0 })}| |Standing charges|${(annualcost.standingcharge/100).toLocaleString("en-GB", { style: "currency", currency: "GBP", minimumFractionDigits: 0, maximumFractionDigits: 0 })}| |Capacity charges|${(annualcost.capacitycharge/100).toLocaleString("en-GB", { style: "currency", currency: "GBP", minimumFractionDigits: 0, maximumFractionDigits: 0 })}| |CCL|${(annualcost.ccl/100).toLocaleString("en-GB", { style: "currency", currency: "GBP", minimumFractionDigits: 0, maximumFractionDigits: 0 })}| |VAT @ ${(client.tariff.vatrate).toLocaleString("en-GB", { style: "percent"})}|${(annualcost.vat/100).toLocaleString("en-GB", { style: "currency", currency: "GBP", minimumFractionDigits: 0, maximumFractionDigits: 0 })}| |**Total**|**${(annualcost.total/100).toLocaleString("en-GB", { style: "currency", currency: "GBP", minimumFractionDigits: 0, maximumFractionDigits: 0 })}**|34:T96f,loadshifted_battery_datapoints = { let loadshift = []; let capacity = batteryparameters.capacity; let chargehh = batteryparameters.maxpower *.9 / 2; dailycost.forEach((day, dayindex) => { let dayprofile = day.hhraw; // [ 45, 46, 47, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ] let highprofile = []; let newprofile = []; let chargepattern = []; dayprofile.forEach((hh, hhindex) => { // get last and first entry in the night rate half hours definition if(hhindex > nighthh[nighthh.length-1] && hhindex < nighthh[0]) { // this is within the day rate time, use capacity if(capacity > 0) { if(capacity >= chargehh) { // don't use more than the capacity capacity -= chargehh; newprofile.push(hh-chargehh); } else { // use the remaining capacity capacity = 0; newprofile.push(hh-capacity); } } else { // no capacity to use newprofile.push(hh); } } else { // this is within the night rate time, fill capacity if(capacity < batteryparameters.capacity) { if((capacity+chargehh) < batteryparameters.capacity) { newprofile.push(hh+chargehh); capacity += chargehh; } else { capacity = batteryparameters.capacity; newprofile.push(hh + batteryparameters.capacity - capacity); } } else { newprofile.push(hh); } } chargepattern.push(capacity); }); // debug check to see if energy is conserved // console.log(d3.sum(dayprofile) + " " + d3.sum(newprofile)); // debug to see old profile // console.log(dayprofile); // debug check to see the new daily profile // console.log(newprofile); // debug check of charging pattern // console.log(chargepattern); let datetimeindex = 0; // Write out the new profile for the day in a new year long data stream // BUG: !!! To be fixed - this is is kludge for now - the dailycost.datetime is the end of day // BUG: it should be the beginning of the day!!!! let bugfactor = 84600000; newprofile.forEach((hh, hhindex) => { loadshift.push({ datetime: (day.datetime+datetimeindex-bugfactor), value: hh }); datetimeindex += 30*60*1000; }); }); return loadshift; }35:T4d8,batteryparameters = { // // strategy is to use a battery size and shift expensive energy to cheaper energy // size also relates to charging time, i.e. if 3.55 kW battery will be used as a reference quanta // 70A current will be used as the reference - corresponds to charge rate of 1 (max is 1.7) // approximately 1 hour is required for a full charge // 70A is at 54VDC - therefore 1 hour to charge 3.55 kW // depending on the inverter, there will be 16A or greater at 230VAC to produce the 70A of DC current // commercial premises may have 32 (standard single phase), 100 (three phase) or greater supply amps // efficiency is the total system efficiency in discharge to charge of power, 9/10 means there is // loss of 10% or effectively only 90% of the grid energy being utilised let efficiency = 0.9; // number of modules is the quanta of 3.55 kWh batteries let numberofmodules = 3; // number of halfhours required for a full charge of a single module let chargehalfhoursrate = 2; let capacity = numberofmodules * 3550; let chargehalfhours = chargehalfhoursrate * numberofmodules; return { capacity: capacity, maxpower: capacity, chargehalfhours: chargehalfhours, efficiency: efficiency }; }36:T78f,hhsource = calc_hhsource(datapoints, client.tariff); //{ // let hhpoints = []; // let costpoints = []; // let vatrate = client.tariff.vatrate; // let cclrate = client.tariff.cclrate; // let night = nighthh; // let hhindex = 0; // modula 48 bucket // let estimated = false; // datapoints.forEach((hh, index) => { // let hhusecost = 0; // hhindex = index % 48; // if(!hh.value || hh.value === NaN) { // estimated = true; // hh.value = 0; // } else { // estimated = false; // } // let kwh = hh.value/1000; // if(night.includes(hhindex)) { // hhusecost = kwh * client.tariff.nightrate; // } else { // hhusecost = kwh * client.tariff.dayrate; // } // let standingchargecost = client.tariff.standingcharge/48; // let capacitychargecost = client.tariff.capacitycharge/48; // let cclcost = kwh * cclrate; // let pretaxcost = hhusecost + standingchargecost + capacitychargecost + cclcost; // let vatcost = pretaxcost * vatrate; // let dateoperator = new Date(hh.datetime); // hhpoints.push({ // datetime: hh.datetime, // value: hh.value, // estimated: estimated, // date: (dateoperator.toISOString()).split("T")[0], // year: parseInt(((dateoperator.toISOString()).split("T")[0]).substr(0,4)), // month: parseInt(((dateoperator.toISOString()).split("T")[0]).substr(5,2)), // dayofweek: dateoperator.getUTCDay(), // hhindex: hhindex, // cost: { // use: hhusecost, // standingcharge: standingchargecost, // capacitycharge: capacitychargecost, // ccl: cclcost, // vat: vatcost, // total: (hhusecost+standingchargecost+capacitychargecost+cclcost+vatcost) // }, // total: (hhusecost+standingchargecost+capacitychargecost+cclcost+vatcost) // }); // }); // return hhpoints; //}37:T5ce,datapoints = { let hours = [ "0030", "0100", "0130", "0200", "0230", "0300", "0330", "0400", "0430", "0500", "0530", "0600", "0630", "0700", "0730", "0800", "0830", "0900", "0930", "1000", "1030", "1100", "1130", "1200", "1230", "1300", "1330", "1400", "1430", "1500", "1530", "1600", "1630", "1700", "1730", "1800", "1830", "1900", "1930", "2000", "2030", "2100", "2130", "2200", "2230", "2300", "2330", "2400"]; let remaphours = [ "0000", "0030", "0100", "0130", "0200", "0230", "0300", "0330", "0400", "0430", "0500", "0530", "0600", "0630", "0700", "0730", "0800", "0830", "0900", "0930", "1000", "1030", "1100", "1130", "1200", "1230", "1300", "1330", "1400", "1430", "1500", "1530", "1600", "1630", "1700", "1730", "1800", "1830", "1900", "1930", "2000", "2030", "2100", "2130", "2200", "2230", "2300", "2330" ]; let datapoints = []; rawdata.forEach((day) => { hours.forEach((hour, index) => { let tokenDate = day["date"].split("/"); let strTime = remaphours[index].substr(0,2) + ":" + remaphours[index].substr(2,2); let dateStr = tokenDate[2] + "-" + tokenDate[1] + "-" + tokenDate[0] + "T" + strTime + "Z"; // pushing in an Epoch time (note in UTC) and value in Watt hours !!! not kilowatt !!! datapoints.push({ datetime: Date.parse(dateStr), value: parseInt(1000*parseFloat(day[hour])) }); }); }); datapoints.sort((firstItem, secondItem) => firstItem.datetime - secondItem.datetime); return datapoints; }38:T4f9,function calc_weekdaycost(dailycost) { let dayofweekindex = dailycost[0].dayofweek; // Sun -> 0 // Mon -> 1 ... Sat -> 6 let weekday = [ { dayofweek: 0, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 1, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 2, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 3, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 4, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 5, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 6, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] } ]; dailycost.forEach((day) => { dayofweekindex = day.dayofweek; weekday[dayofweekindex].raw.push(day.total); }); for(let i=0; i < 7; i++) { weekday[i].mean = d3.mean(weekday[i].raw); weekday[i].variance = d3.variance(weekday[i].raw); weekday[i].stddev = d3.deviation(weekday[i].raw); weekday[i].max = d3.max(weekday[i].raw); weekday[i].min = d3.min(weekday[i].raw); weekday[i].count = d3.count(weekday[i].raw); } return weekday; }39:T4fc,function calc_weekdayuse(dailycost) { let dayofweekindex = dailycost[0].dayofweek; // Sun -> 0 // Mon -> 1 ... Sat -> 6 let weekday = [ { dayofweek: 0, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 1, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 2, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 3, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 4, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 5, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] }, { dayofweek: 6, mean: 0, variance: 0, stddev: 0, max:0, min:0, count: 0, raw: [] } ]; dailycost.forEach((day) => { dayofweekindex = day.dayofweek; weekday[dayofweekindex].raw.push(day.value); }); for(let i=0; i < 7; i++) { weekday[i].mean = d3.mean(weekday[i].raw); weekday[i].variance = d3.variance(weekday[i].raw); weekday[i].stddev = d3.deviation(weekday[i].raw); weekday[i].max = d3.max(weekday[i].raw); weekday[i].min = d3.min(weekday[i].raw); weekday[i].count = d3.count(weekday[i].raw); } return weekday; }3a:T6bd,function calc_monthlycost(dailycost) { let datetime = dailycost[0].datetime; let dateyear = dailycost[0].year; let monthlycost = []; let monthindex = dailycost[0].month; let sumwh = 0; let sumuse = 0; let sumstandingcharge = 0; let sumcapacitycharge = 0; let sumccl = 0; let sumvat = 0; let sumtotal = 0; let dayraw = []; console.log(monthindex); dailycost.forEach((day, index) => { if(day.month !== monthindex) { monthlycost.push({datetime: datetime, year: dateyear, month: monthindex, value: sumwh, dayraw: dayraw, total: sumtotal, use: sumuse, standingcharge: sumstandingcharge, capacitycharge: sumcapacitycharge, ccl: sumccl, vat: sumvat }); dayraw = [day.value]; sumwh = day.value; sumuse = day.use; sumstandingcharge = day.standingcharge; sumcapacitycharge = day.capacitycharge; sumccl = day.ccl; sumvat = day.vat; sumtotal = day.total; dateyear = day.year; monthindex = day.month; datetime = day.datetime; } else { dayraw.push(day.value); sumwh += day.value; sumuse += day.use; sumstandingcharge += day.standingcharge; sumcapacitycharge += day.capacitycharge; sumccl += day.ccl; sumvat += day.vat; sumtotal += day.total; dateyear = day.year; monthindex = day.month; datetime = day.datetime; } }); // write out last entry monthlycost.push({datetime: datetime, year: dateyear, month: monthindex, value: sumwh, dayraw: dayraw, total: sumtotal, use: sumuse, standingcharge: sumstandingcharge, capacitycharge: sumcapacitycharge, ccl: sumccl, vat: sumvat }); return monthlycost; }3b:T868,function calc_dailycost(hhsource) { let dailycost = []; let dateindex = hhsource[0].date; let datetime = hhsource[0].datetime; let dayofweek = hhsource[0].dayofweek; let yearindex = hhsource[0].year; let monthindex = hhsource[0].month; let hhestimated = hhsource[0].estimated; let sumwh = 0; let sumuse = 0; let sumstandingcharge = 0; let sumcapacitycharge = 0; let sumccl = 0; let sumvat = 0; let sumtotal = 0; let hhraw = []; hhsource.forEach((hh, index) => { if(hh.date !== dateindex) { dailycost.push({datetime: datetime, date: dateindex, year: yearindex, month: monthindex, dayofweek: dayofweek, value: sumwh, estimated: hhestimated, hhraw: hhraw, total: sumtotal, use: sumuse, standingcharge: sumstandingcharge, capacitycharge: sumcapacitycharge, ccl: sumccl, vat: sumvat }); yearindex = hh.year; monthindex = hh.month; hhestimated = hh.estimated hhraw = [hh.value]; sumwh = hh.value; sumuse = hh.cost.use; sumstandingcharge = hh.cost.standingcharge; sumcapacitycharge = hh.cost.capacitycharge; sumccl = hh.cost.ccl; sumvat = hh.cost.vat; sumtotal = hh.cost.total; datetime = hh.datetime; dateindex = hh.date; dayofweek = hh.dayofweek; } else { if(hh.estimated || hhestimated) { hhestimated = true; }; hhraw.push(hh.value); sumwh += hh.value; sumuse += hh.cost.use; sumstandingcharge += hh.cost.standingcharge; sumcapacitycharge += hh.cost.capacitycharge; sumccl += hh.cost.ccl; sumvat += hh.cost.vat; sumtotal += hh.cost.total; datetime = hh.datetime; dateindex = hh.date; yearindex = hh.year; dayofweek = hh.dayofweek; } }); // write out the last record dailycost.push({datetime: datetime, date: dateindex, year: yearindex, month: monthindex, dayofweek: dayofweek, value: sumwh, estimated: hhestimated, hhraw: hhraw, total: sumtotal, use: sumuse, standingcharge: sumstandingcharge, capacitycharge: sumcapacitycharge, ccl: sumccl, vat: sumvat }); return dailycost; }3c:T6bf,function calc_hhsource(datasource, tariff) { let hhpoints = []; let costpoints = []; let vatrate = tariff.vatrate; let cclrate = tariff.cclrate; let night = nighthh; let hhindex = 0; // modula 48 bucket let estimated = false; datasource.forEach((hh, index) => { let hhusecost = 0; hhindex = index % 48; if(!hh.value || hh.value === NaN) { estimated = true; hh.value = 0; } else { estimated = false; } let kwh = hh.value/1000; if(night.includes(hhindex)) { hhusecost = kwh * tariff.nightrate; } else { hhusecost = kwh * tariff.dayrate; } let standingchargecost = tariff.standingcharge/48; let capacitychargecost = tariff.capacitycharge/48; let cclcost = kwh * cclrate; let pretaxcost = hhusecost + standingchargecost + capacitychargecost + cclcost; let vatcost = pretaxcost * vatrate; let dateoperator = new Date(hh.datetime); hhpoints.push({ datetime: hh.datetime, value: hh.value, estimated: estimated, date: (dateoperator.toISOString()).split("T")[0], year: parseInt(((dateoperator.toISOString()).split("T")[0]).substr(0,4)), month: parseInt(((dateoperator.toISOString()).split("T")[0]).substr(5,2)), dayofweek: dateoperator.getUTCDay(), hhindex: hhindex, cost: { use: hhusecost, standingcharge: standingchargecost, capacitycharge: capacitychargecost, ccl: cclcost, vat: vatcost, total: (hhusecost+standingchargecost+capacitychargecost+cclcost+vatcost) }, total: (hhusecost+standingchargecost+capacitychargecost+cclcost+vatcost) }); }); return hhpoints; }3d:[{"id":"98b081114fd30472edc414f0051f4608f19255f426059217e91a5bd1c155ebf420db0b545197b104e5016b458f0ee84844bd185c89f4eac4fd2846a1d998c201","href":"https://static.observableusercontent.com/files/98b081114fd30472edc414f0051f4608f19255f426059217e91a5bd1c155ebf420db0b545197b104e5016b458f0ee84844bd185c89f4eac4fd2846a1d998c201","name":"g7500@1.csv","type":"text/csv","lastModified":1634372005322.354,"size":102045},{"id":"789384dbb826889bb79da13a9975731b6a6c79e2277888879b65cb23f5e30cb0e9431150b2c2dbe6466b2c434e7cc2e6ba1aa7b931b1a2a1aa2c106032e75edf","href":"https://static.observableusercontent.com/files/789384dbb826889bb79da13a9975731b6a6c79e2277888879b65cb23f5e30cb0e9431150b2c2dbe6466b2c434e7cc2e6ba1aa7b931b1a2a1aa2c106032e75edf","name":"g7500.csv","type":"text/csv","lastModified":1632477518410.721,"size":109345}] 30:{"id":"829c218a4fe801dd","slug":"data-source-test-site","title":"Data Source - Test Site","thumbnail":"b8a1b4fb2a26dd299d1eba751439b2dc80d89bb9546d1fc6c8c7e57796aeca58","access_level":"public","create_time":"$D2021-09-24T09:47:15.424Z","update_time":"$D2022-01-28T16:29:56.869Z","view_time":null,"first_public_time":"$D2021-10-16T08:15:31.962Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"20e510411e88c2f1","login":"joshuacooper","name":"Joshua Cooper","avatar_url":"https://avatars-next.observableusercontent.com/814f458da4ea4bcfddd1fc64693fcb58da584f45f67098626643f24a0432a1c4","tier":"starter_2024"},"version":759,"publish_version":759,"role":null,"authored":false,"authors":[{"type":"individual","id":"5514a468c7245fb1","login":"joshuacooper","name":"Joshua Cooper","avatar_url":"https://avatars-next.observableusercontent.com/814f458da4ea4bcfddd1fc64693fcb58da584f45f67098626643f24a0432a1c4","tier":null}],"members":[{"type":"individual","id":"5514a468c7245fb1","login":"joshuacooper","name":"Joshua Cooper","avatar_url":"https://avatars-next.observableusercontent.com/814f458da4ea4bcfddd1fc64693fcb58da584f45f67098626643f24a0432a1c4","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Data Source - Test Site","cells":[{"id":117,"value":"# Data Source - Test Site\n\n## created by Hildebrand Technology Limited\n### for ${client.name}, ${client.postcode}\n\nHalf hourly electricity data from ${daterange.from} to ${daterange.to} with ${(dataquality).toLocaleString(undefined, {style: \"percent\"})} of the data reported.\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"$32","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":450,"value":"# Overall Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"Plot.line(datapoints, { x: \"datetime\", \"y\": \"value\" }).plot({ x: { type: \"utc\", domain: [daterange.mintime, daterange.maxtime]}, y: { label: \"kWh\", transform: w => w / 1000 }, grid: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"During the year there were Covid closures and reduced services. These can be seen in Figure 1 as sustained low usage during July 2020 and Winter 2020-2021.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"Plot.plot({\n caption: \"Figure 2. Annual spend, month by month\",\n x: {\n //transform: d => new Date(d).toString().substr(4, 3),\n domain: d3.sort(monthlycost, d => d.datetime).map(d => d.month)\n },\n y: {\n transform: v => parseInt(v / 100),\n label: \"↑ Cost (£)\",\n grid: true\n },\n marks: [\n Plot.barY(monthlycost, {x: \"month\", y: \"total\", fill: colors.side1 }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"Plot.line(dailycost, { x: \"datetime\", \"y\": \"total\" }).plot({ x: { type: \"utc\", domain: [daterange.mintime, daterange.maxtime]}, y: { label: \"pence\" }, grid: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":731,"value":"## Scenario battery with PV","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":713,"value":"## Scenario battery - single cycle","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":746,"value":"loadshifted_weekdaycost = calc_weekdaycost(dailycost)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":742,"value":"loadshifted_weekdayuse = calc_weekdayuse(dailycost)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":728,"value":"loadshifted_annualcost = calc_annualcost(loadshifted_monthlycost);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":725,"value":"loadshifted_monthlycost = calc_monthlycost(loadshifted_dailycost);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":719,"value":"loadshifted_dailycost = calc_dailycost(loadshifted_hhsource);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"loadshifted_hhsource = calc_hhsource(loadshifted_battery_datapoints, client.tariff);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":565,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":702,"value":"## Calculate usage and cost views for the input data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"timeofdaycost = calc_timeofdaycost(hhsource);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":538,"value":"timeofdayuse = calc_timeofdayuse (hhsource);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"weekdaycost = calc_weekdaycost(dailycost);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":494,"value":"weekdayuse = calc_weekdayuse(dailycost);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":350,"value":"annualcost = calc_annualcost(monthlycost);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"monthlycost = calc_monthlycost(dailycost);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"dailycost = calc_dailycost(hhsource);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":592,"value":"nighthh = [ 45, 46, 47, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ] ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"daterange = {\n \n let lastpoint = (datapoints.length - 1);\n let options = { year: 'numeric', month: 'long', day: 'numeric' };\n\n let start = datapoints[0].datetime;\n let end = datapoints[lastpoint].datetime;\n \n let from = new Intl.DateTimeFormat('en-GB', options).format(new Date(start));\n let to = new Intl.DateTimeFormat('en-GB', options).format(new Date(end));\n\n return { mintime: start, maxtime: end, start: start, end: end, from: from, to: to }\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":474,"value":"missingdata = { \n let md = 0;\n \n hhsource.forEach((value) => {\n \n if(value.estimated === true){\n md++;\n }\n});\n return md;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"dataquality = (datapoints.length - missingdata) / (365*48);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"client = { \n return {\n name: rawdata[0]['name'],\n type: rawdata[0]['type'],\n postcode: rawdata[0]['postcode'],\n mpan: rawdata[0]['mpan'],\n pr: rawdata[0]['pr'],\n mtc: rawdata[0]['mtc'],\n llf: rawdata[0]['llf'],\n tariff: {\n dayrate: parseFloat(rawdata[0]['dayrate']),\n nightrate: parseFloat(rawdata[0]['nightrate']),\n capacitycharge: parseFloat(rawdata[0]['capacitycharge']),\n standingcharge: parseFloat(rawdata[0]['standingcharge']),\n vatrate: 0.20,\n cclrate: 0.775\n }\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"rawdata = FileAttachment(\"g7500@1.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":706,"value":"## Functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"height = 400","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":364,"value":"width = 800","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":551,"value":"weekdayranges = {\n\n let cost = { min: 0, max: 0 };\n let use = { min: 0, max: 0 };\n\n weekdaycost.forEach((value) => {\n if(value.max > cost.max) cost.max = value.max;\n });\n\n weekdayuse.forEach((value) => {\n if(value.max > use.max) use.max = value.max;\n });\n \n return {\n cost: cost,\n use: use\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":694,"value":"function calc_timeofdaycost(hhsource) {\n // Sun -> 0\n // Mon -> 1 ... Sat -> 6\n\n // 0 -> 00:00 ... 47 -> 23:30\n\n // 7 days x 48 halfhours\n\n let dayhours = [];\n let hh = [];\n\n for(let j=0; j < 48; j++) {\n \thh.push({ hh: j, mean: 0, variance: 0, max: 0, min: 0, stddev: 0, count: 0, raw: [] });\n }\n\n for(let i=0; i < 7; i++) {\n dayhours.push({ dayofweek: i, hh: hh});\n }\n\n\n hhsource.forEach((hh) => {\n dayhours[hh.dayofweek].hh[hh.hhindex].raw.push(hh.total);\n });\n\n for(let i=0; i < 7; i++) {\n for(let j=0; j < 48; j++) {\n dayhours[i].hh[j].mean = d3.mean(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].variance = d3.variance(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].stddev = d3.deviation(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].max = d3.max(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].min = d3.min(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].count = d3.count(dayhours[i].hh[j].raw);\n }\n }\n\n return dayhours;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":690,"value":"function calc_timeofdayuse(hhsource) {\n // Sun -> 0\n // Mon -> 1 ... Sat -> 6\n\n // 0 -> 00:00 ... 47 -> 23:30\n\n // 7 days x 48 halfhours\n\n let dayhours = [];\n let hh = [];\n\n for(let j=0; j < 48; j++) {\n \thh.push({ hh: j, mean: 0, variance: 0, max: 0, min: 0, stddev: 0, count: 0, raw: [] });\n }\n\n for(let i=0; i < 7; i++) {\n dayhours.push({ dayofweek: i, hh: hh});\n }\n\n\n hhsource.forEach((hh) => {\n dayhours[hh.dayofweek].hh[hh.hhindex].raw.push(hh.value);\n });\n\n for(let i=0; i < 7; i++) {\n for(let j=0; j < 48; j++) {\n dayhours[i].hh[j].mean = d3.mean(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].variance = d3.variance(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].stddev = d3.deviation(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].max = d3.max(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].min = d3.min(dayhours[i].hh[j].raw);\n dayhours[i].hh[j].count = d3.count(dayhours[i].hh[j].raw);\n }\n }\n\n return dayhours;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":686,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":682,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":674,"value":"function calc_annualcost(monthlycost) {\n \n let value = 0;\n let total = 0;\n let use = 0;\n let vat = 0;\n let capacitycharge = 0;\n let standingcharge = 0;\n let ccl = 0;\n\n monthlycost.forEach((month) => {\n value += month.value;\n total += month.total;\n use += month.use;\n vat += month.vat;\n capacitycharge += month.capacitycharge;\n standingcharge += month.standingcharge;\n ccl += month.ccl;\n });\n\n return { value: value, total: total, use: use, vat: vat, capacitycharge: capacitycharge, standingcharge: standingcharge, ccl: ccl }\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":657,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"colors = ({\n card: d3sc.interpolateViridis(0),\n content: d3sc.interpolateViridis(0.1),\n front: d3sc.interpolateViridis(0.2),\n back: d3sc.interpolateViridis(0.3),\n side1: d3sc.interpolateViridis(0.4),\n side2: d3sc.interpolateViridis(0.5),\n side3: d3sc.interpolateViridis(0.6),\n side4: d3sc.interpolateViridis(0.7),\n side5: d3sc.interpolateViridis(0.8),\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"d3sc = require(\"d3-scale-chromatic@3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3d","stdlib":"1"}} 31:"$30:body"