2f:Tc2e,params = new Map([ ["WALLR", [ {compare: d => d < 10, label: "<10"}, {compare: d => d >= 10 && d <= 20, label: "10 to 20"}, {compare: d => d > 20, label: ">20"} ]], ["ROOFR", [ {compare: d => d < 10, label: "<10"}, {compare: d => d >= 10 && d <= 20, label: "10 to 20"}, {compare: d => d > 20, label: ">20"} ]], ["WWR", [ {compare: d => d > 0.4, label: ">40%"}, {compare: d => d >= 0.2 && d <= 0.4, label: "20-40%"}, {compare: d => d < 0.2, label: "<20%"} ]], ["WINU", [ {compare: d => d > 0.6, label: ">0.6"}, {compare: d => d >= 0.2 && d <= 0.6, label: "0.2-0.6"}, {compare: d => d < 0.2, label: "<0.2"} ]], ["WINSHGC", [ {compare: d => d > 0.6, label: ">0.6"}, {compare: d => d >= 0.2 && d <= 0.6, label: "0.2-0.6"}, {compare: d => d < 0.2, label: "<0.2"} ]], ["INFIL", [ {compare: d => d > 0.12, label: ">0.12"}, {compare: d => d >= 0.09 && d <= 0.12, label: "0.09-0.12"}, {compare: d => d < 0.09, label: "<0.09"} ]], ["LPD", [ {compare: d => d > 1.2, label: ">1.2"}, {compare: d => d >= 0.8 && d <= 1.2, label: "0.8-1.2"}, {compare: d => d < 0.8, label: "<0.8"} ]], ["EPD", [ {compare: d => d > 5, label: ">5"}, {compare: d => d >= 2 && d <= 5, label: "2-5"}, {compare: d => d < 2, label: "<2"} ]], ["HRV", [ {compare: d => d < .25, label: "No heat recovery"}, {compare: d => d >= 0.25 && d <= 0.5, label: "25-50% effectiveness"}, {compare: d => d > 0.5, label: ">50% effectiveness"} ]], ["SATRESET", [ {compare: d => d < 58, label: "<58°F"}, {compare: d => d >= 58 && d <= 62, label: "58-62°F"}, {compare: d => d > 62, label: ">62°F"} ]], ["FANPOWER", [ {compare: d => d > 6, label: ">6"}, {compare: d => d >= 2 && d <= 6, label: "2-6"}, {compare: d => d < 2, label: "<2"} ]], ["ACH", [ {compare: d => d > 4, label: ">4"}, {compare: d => d >= 1 && d <= 4, label: "1-4"}, {compare: d => d < 1, label: "<1"} ]], ["ECON", [ {compare: d => d === "NoEconomizer", label: "No economizer"}, {compare: d => d === "DifferentialDryBulb", label: "Economizer"} ]], ["COOLCOP_C", [ {compare: d => d === 1, label: "District cooling"} ]], ["COOLCOP_E", [ {compare: d => d < 3.5, label: "<3.5"}, {compare: d => d >= 3.5 && d <= 5, label: "3.5-5.0"}, {compare: d => d > 5, label: "<5.0"} ]], ["HEATCOP_S", [ {compare: d => d === 1, label: "District heating"} ]], ["HEATCOP_G", [ {compare: d => d < 0.75, label: "<0.75"}, {compare: d => d >= 0.75 && d <= 0.85, label: "0.75-0.85"}, {compare: d => d > 0.85, label: ">0.85"} ]], ["HEATCOP_E", [ {compare: d => d < 2, label: "<2.0"}, {compare: d => d >= 2 && d <= 3, label: "2.0-3.0"}, {compare: d => d > 3, label: "<3.0"} ]], ["EPDSCH", [ {compare: d => d.split("_")[1] === "High", label: "High"}, {compare: d => d.split("_")[1] === "Seasonal", label: "Seasonal"}, {compare: d => d.split("_")[1] === "Typical", label: "Typical"}, {compare: d => d.split("_")[1] === "Low", label: "Low"} ]] ])30:T817,data = { let binned = []; //loop through the files for (const file of files) { const fileName = file.name; const f = await file.xlsx(); const sheets = f.sheetNames; //loop through the tabs for (const [sheetIndex, sheetName] of sheets.entries()) { //pull out the headers const table = f.sheet(sheetIndex, {headers: true}).map((d) => d3.autoType(d)); const headers = Object.keys(table[0]); //loop through the headers for (const header of headers) { let values = table.map((d) => ({ name: `Building_${fileName.split("_")[1]}`, sheet: sheetName, param: header, value: d[header], bin: null, color: null })); //check to see if header exists in params if (params.has(header)) { values = values.map((d) => ({ ...d, ...bin(header, d.value) })); } //custom for HEATCOP if (header === "HEATCOP") { const average = d3.mean(values, (d) => d.value); if (average < 1) { values = values.map((d) => ({ ...d, ...bin("HEATCOP_G", d.value) })); } else if (average > 1) { values = values.map((d) => ({ ...d, ...bin("HEATCOP_E", d.value) })); } else if (average === 1) { values = values.map((d) => ({ ...d, ...bin("HEATCOP_S", d.value) })); } } ///custom for COOLCOP if (header === "COOLCOP") { const average = d3.mean(values, (d) => d.value); if (average > 1) { values = values.map((d) => ({ ...d, ...bin("COOLCOP_E", d.value) })); } else if (average === 1) { values = values.map((d) => ({ ...d, ...bin("COOLCOP_C", d.value) })); } } ///add the values to binned binned.push(values) } } } return binned.flat(); } 31:[{"id":"adf08ae5905b98ed9f008332b48dcba8482ce18634858bea4ef5737d8d0c46802182ad824298299e07ed4e0715d8cd9b743bffce96b6e4295b383ac4c73802c8","href":"https://static.observableusercontent.com/files/adf08ae5905b98ed9f008332b48dcba8482ce18634858bea4ef5737d8d0c46802182ad824298299e07ed4e0715d8cd9b743bffce96b6e4295b383ac4c73802c8","name":"Example Building 4402.csv","type":"text/csv","lastModified":1767146092704.157,"size":34431},{"id":"3ffb5fca301ab7ebf34aa1e4bd877d8dffdd2b9e8bcf706f377d5c4c91ec6fc7e8245b2b6f68ec1ac62218d5fbb5546396bb84c29d8e276ff471924cad4737b5","href":"https://static.observableusercontent.com/files/3ffb5fca301ab7ebf34aa1e4bd877d8dffdd2b9e8bcf706f377d5c4c91ec6fc7e8245b2b6f68ec1ac62218d5fbb5546396bb84c29d8e276ff471924cad4737b5","name":"building_548_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767198687203.733,"size":267540},{"id":"691a0696ee49cbee93ab16baa56cdce105d917940843663df56979423b5510d6fa3a80ce3e422168bfc5606ea4c409556fef1aafb81347b2a202f7082e3892e8","href":"https://static.observableusercontent.com/files/691a0696ee49cbee93ab16baa56cdce105d917940843663df56979423b5510d6fa3a80ce3e422168bfc5606ea4c409556fef1aafb81347b2a202f7082e3892e8","name":"building_838_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767198686915.934,"size":125318},{"id":"151cc6f0abd9e9fd98af193eb3680eba44b70859ed34fa74f87063f1c4d463d7041263d7cef5c6344c93990dfb91a2c57e0f1c1082ca6f425b6b2e68d55b8ede","href":"https://static.observableusercontent.com/files/151cc6f0abd9e9fd98af193eb3680eba44b70859ed34fa74f87063f1c4d463d7041263d7cef5c6344c93990dfb91a2c57e0f1c1082ca6f425b6b2e68d55b8ede","name":"building_550_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767198687220.115,"size":267833},{"id":"a9b96eb3d809c212a474db8419fbd164b2bef68f53580f43ad460b4c6c70d0da387cc8bb69176cd6f9bc0ff927fa9e731441cac950301d8d7c51d7c8d86f03f4","href":"https://static.observableusercontent.com/files/a9b96eb3d809c212a474db8419fbd164b2bef68f53580f43ad460b4c6c70d0da387cc8bb69176cd6f9bc0ff927fa9e731441cac950301d8d7c51d7c8d86f03f4","name":"building_570_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767198687504.665,"size":260127},{"id":"9e26f13d21c658545f80cceb76a6ed624e96179dab845c086b139a61ec476243c59bc90862219bfcd53321a0ee986454133666cda4d357970e1cb6ed7528fe70","href":"https://static.observableusercontent.com/files/9e26f13d21c658545f80cceb76a6ed624e96179dab845c086b139a61ec476243c59bc90862219bfcd53321a0ee986454133666cda4d357970e1cb6ed7528fe70","name":"building_560_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767198687525.054,"size":260065},{"id":"6c73d2b3efea26f8c05255e37c62102eb94dbbab3de8d83aa760bfa1d8dffe7b1ef2be359ed4bb8dbbbfad5c06969d7ef3a8a4b736e3fcada52dcd4c3cb77cf8","href":"https://static.observableusercontent.com/files/6c73d2b3efea26f8c05255e37c62102eb94dbbab3de8d83aa760bfa1d8dffe7b1ef2be359ed4bb8dbbbfad5c06969d7ef3a8a4b736e3fcada52dcd4c3cb77cf8","name":"building_4402_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767199412432.696,"size":122169},{"id":"42358a48a9e2d193b30caa6f2337600dce4544494077098065d77380a7e0dbe1c676ce4dfe6a30b1a953e39c84799f0fcc3dacc565e0a1fd00f0398d8477f346","href":"https://static.observableusercontent.com/files/42358a48a9e2d193b30caa6f2337600dce4544494077098065d77380a7e0dbe1c676ce4dfe6a30b1a953e39c84799f0fcc3dacc565e0a1fd00f0398d8477f346","name":"building_4960_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767198686903.207,"size":125083},{"id":"7a0c172638fb238839caf5fe65c873f5351321db41c41840f6f6cd1723b1e33ed59a407ecee2bf966deb4e8214830d24f8ecd42cfdd9ebe5e8a1ca192880bae0","href":"https://static.observableusercontent.com/files/7a0c172638fb238839caf5fe65c873f5351321db41c41840f6f6cd1723b1e33ed59a407ecee2bf966deb4e8214830d24f8ecd42cfdd9ebe5e8a1ca192880bae0","name":"building_825_diagnostics.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1767198686912.667,"size":124387}] 2d:{"title":"Characterization Across Buildings","cells":[{"id":4,"value":"# Characterization Across Buildings","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"files = [\n FileAttachment(\"building_4960_diagnostics.xlsx\"),\n FileAttachment(\"building_4402_diagnostics.xlsx\"),\n FileAttachment(\"building_548_diagnostics.xlsx\"),\n FileAttachment(\"building_550_diagnostics.xlsx\"),\n FileAttachment(\"building_560_diagnostics.xlsx\"),\n FileAttachment(\"building_570_diagnostics.xlsx\"),\n FileAttachment(\"building_825_diagnostics.xlsx\"),\n FileAttachment(\"building_838_diagnostics.xlsx\")\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":373,"value":"tabs = {\n const sheets = await files[0].xlsx();\n return sheets.sheetNames;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":383,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":418,"value":"function bin(param, value) {\n const bins = params.get(param);\n const size = bins.length;\n let out = {bin: null, color: null};\n for (const [i, b] of bins.entries()) {\n if (b.compare(value)) {\n out.bin = b.label;\n out.color = colors[size - 1][i];\n break;\n }\n }\n return out;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":145,"value":"colors = [\n [\"#C6CBD4\"],\n [\"#3E4784\", \"#15B79E\"],\n [\"#3E4784\", \"#C6CBD4\", \"#15B79E\"],\n [\"#3E4784\", \"#878DB1\", \"#6FD0C1\", \"#15B79E\"],\n [\"#3E4784\", \"#878DB1\", \"#C6CBD4\", \"#6FD0C1\", \"#15B79E\"]\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":547,"value":"buildings = new Set(data.map(d => d.name))","pinned":true,"hidden":false,"mode":"ojs"},{"id":544,"value":"viewof buildingName = Inputs.select(buildings, {label: \"Select one\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":550,"value":"filtered = data.filter(d => d.name === buildingName)","pinned":false,"hidden":false,"mode":"ojs"},{"id":452,"value":"Plot.plot({\n subtitle: buildingName,\n marginLeft: 100,\n marginBottom: 100,\n marginRight: 100,\n grid: false,\n x: {tickRotate: -90, label: null},\n marks: [\n Plot.cell(filtered.filter((d) => params.has(d.param)), Plot.group({fill: \"mode\"}, {\n x: \"sheet\",\n y: \"param\",\n fill: \"color\",\n inset: 0.5\n }))\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":560,"value":"Plot.plot({\n subtitle: \"Baseline\",\n marginLeft: 100,\n marginBottom: 100,\n marginRight: 100,\n grid: false,\n x: {tickRotate: -90, label: null},\n marks: [\n Plot.cell(data.filter((d) => params.has(d.param) && d.sheet === \"baseline\"), Plot.group({fill: \"mode\"}, {\n x: \"name\",\n y: \"param\",\n fill: \"color\",\n inset: 0.5\n }))\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}