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:[{"id":"adf08ae5905b98ed9f008332b48dcba8482ce18634858bea4ef5737d8d0c46802182ad824298299e07ed4e0715d8cd9b743bffce96b6e4295b383ac4c73802c8","href":"https://static.observableusercontent.com/files/adf08ae5905b98ed9f008332b48dcba8482ce18634858bea4ef5737d8d0c46802182ad824298299e07ed4e0715d8cd9b743bffce96b6e4295b383ac4c73802c8","name":"Example Building 4402.csv","type":"text/csv","lastModified":1766495180945.997,"size":34431}] 2d:{"title":"Characterization","cells":[{"id":4,"value":"# Characterization","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"data = FileAttachment(\"Example Building 4402.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"binned = {\n let m = new Map();\n for (const k of Object.keys(data[0])) {\n let values = data.map(d => d[k]);\n let defs = [];\n if (params.has(k)) {\n defs = params.get(k);\n m.set(k, bin(defs, values));\n }\n if (k === \"HEATCOP\") {\n const average = d3.mean(values);\n if (average < 1) {\n defs = params.get(\"HEATCOP_G\");\n }\n else if (average > 1) {\n defs = params.get(\"HEATCOP_E\");\n }\n else {\n defs = params.get(\"HEATCOP_S\");\n }\n m.set(k, bin(defs, values));\n }\n if (k === \"COOLCOP\") {\n const average = d3.mean(values);\n if (average > 1) {\n defs = params.get(\"COOLCOP_E\");\n }\n else {\n defs = params.get(\"COOLCOP_C\");\n }\n m.set(k, bin(defs, values));\n }\n }\n return m;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":221,"value":"function bin(defs, values) {\n return defs.map((def) => {\n console.log(def);\n const filtered = values.filter(value => def.compare(value));\n return {...def, values: filtered, length: filtered.length}\n });\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":65,"value":"{\n return html`${[...binned.keys()].map((k) =>\n Plot.plot({\n height: 48,\n subtitle: k,\n marginLeft: 10,\n marginBottom: 32,\n color: { legend: true , domain: binned.get(k).map(d => d.label), range: colors[binned.get(k).length - 1]},\n x: { percent: true, label: \"Frequency(%)\",ticks: [0, 100]},\n marks: [Plot.barX(binned.get(k), { \n x: \"length\",\n inset: 1,\n sort: (d, i) => i,\n fill: \"label\",\n offset: \"normalize\"})]\n })\n )}`;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":247,"value":"{\n return html`${[...binned.keys()].map((k) =>\n Plot.plot({\n height: 48,\n subtitle: k,\n x: {\n domain: binned.get(k).map(d => d.label),\n label: null,\n padding: 0\n },\n color: {\n domain: [0, 100],\n scheme: \"Blues\"\n },\n y: {\n axis: null\n },\n marks: [\n Plot.barY(binned.get(k), {x: \"label\", y: 20, fill: \"length\", inset: 1})\n ]\n })\n )}`;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":279,"value":"{\n return html`${[...binned.keys()].map((k) => {\n const values = binned.get(k).flatMap(d => d.values.map(dd => ({label: d.label, value: dd})));\n return Plot.plot({\n subtitle: k,\n height: 28,\n marginLeft: 0,\n x: {axis: null},\n y: {label: null},\n color: { legend: true , domain: binned.get(k).map(d => d.label), range: colors[binned.get(k).length - 1]},\n marks: [\n Plot.barX(values, {x: 1, inset: 0.5, fill: \"label\"})\n ]\n });\n }\n )}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":316,"value":"grid = {\n let plots = [];\n for (const [k, v] of binned) {\n \n let cells = v.flatMap(d => d.values.map(dd => ({label: d.label, value: dd})));\n const r = 1;\n const l = cells.length;\n cells = cells.map((d, i) => {\n const p = position(i, r, l);\n return {...d, x: p.x, y: p.y}\n });\n\n const w = 200;\n \n let plot = Plot.plot({\n subtitle: k,\n marginTop: 0,\n width: w,\n height: w/r,\n x: {axis: null},\n y: {axis: null},\n color: {legend: true , domain: v.map(d => d.label), range: colors[v.length - 1]},\n marks: [\n Plot.cell(cells, {fill: \"label\", x: \"x\", y: \"y\"})\n ]\n });\n\n plots.push(plot);\n \n }\n return html`

${plots}

`\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":320,"value":"function position(i, r, l) {\n const rows = Math.ceil(Math.sqrt(l/r));\n const cols = Math.ceil(l / rows);\n return {x: i % cols, y: Math.floor(i / cols)}\n}","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}