Energy Audit & Solar System Design Tool<\/title>\r\n\r\n\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.18.5\/xlsx.full.min.js\"><\/script>\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jspdf\/2.5.1\/jspdf.umd.min.js\"><\/script>\r\n\r\n<style>\r\nbody {\r\n font-family: Arial, sans-serif;\r\n background: #f4f6f8;\r\n padding: 20px;\r\n}\r\n.container {\r\n max-width: 1200px;\r\n background: #fff;\r\n padding: 20px;\r\n border-radius: 6px;\r\n}\r\ntable {\r\n width: 100%;\r\n border-collapse: collapse;\r\n margin-top: 15px;\r\n}\r\nth, td {\r\n border: 1px solid #ccc;\r\n padding: 6px;\r\n text-align: center;\r\n}\r\nth {\r\n background: #007bff;\r\n color: white;\r\n}\r\ninput, select, button {\r\n width: 100%;\r\n padding: 5px;\r\n}\r\nbutton {\r\n background: #28a745;\r\n color: white;\r\n border: none;\r\n cursor: pointer;\r\n}\r\n.remove {\r\n background: #dc3545;\r\n}\r\n.actions {\r\n display: flex;\r\n gap: 10px;\r\n margin-top: 15px;\r\n}\r\n.summary {\r\n background: #eef4ff;\r\n padding: 15px;\r\n margin-top: 20px;\r\n border-radius: 5px;\r\n}\r\n<\/style>\r\n<\/head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n<h2>Energy Audit & Solar System Design Tool<\/h2>\r\n\r\n<table id=\"applianceTable\">\r\n<tr>\r\n<th>Appliance<\/th>\r\n<th>Power (W)<\/th>\r\n<th>Qty<\/th>\r\n<th>Hours<\/th>\r\n<th>Energy (Wh)<\/th>\r\n<th>Action<\/th>\r\n<\/tr>\r\n\r\n<tr>\r\n<td>LED Bulb<\/td>\r\n<td><input type=\"number\" value=\"10\"><\/td>\r\n<td><input type=\"number\" value=\"10\"><\/td>\r\n<td><input type=\"number\" value=\"6\"><\/td>\r\n<td class=\"energy\">0<\/td>\r\n<td><\/td>\r\n<\/tr>\r\n\r\n<tr>\r\n<td>Fan<\/td>\r\n<td><input type=\"number\" value=\"75\"><\/td>\r\n<td><input type=\"number\" value=\"4\"><\/td>\r\n<td><input type=\"number\" value=\"8\"><\/td>\r\n<td class=\"energy\">0<\/td>\r\n<td><\/td>\r\n<\/tr>\r\n<\/table>\r\n\r\n<div class=\"actions\">\r\n<button onclick=\"addAppliance()\">\u2795 Add Appliance<\/button>\r\n<\/div>\r\n\r\n<h3>System Configuration<\/h3>\r\n\r\n<table>\r\n<tr>\r\n<td>Panel Size<\/td>\r\n<td>\r\n<select id=\"panelSize\">\r\n<option value=\"330\">330 W<\/option>\r\n<option value=\"450\">450 W<\/option>\r\n<option value=\"550\">550 W<\/option>\r\n<option value=\"580\">580 W<\/option>\r\n<option value=\"585\">585 W<\/option>\r\n<option value=\"600\">600 W<\/option>\r\n<option value=\"620\">620 W<\/option>\r\n<option value=\"630\">630 W<\/option>\r\n<option value=\"635\">635 W<\/option>\r\n<option value=\"710\" selected>710 W<\/option>\r\n<\/select>\r\n<\/td>\r\n\r\n<td>Battery Type<\/td>\r\n<td>\r\n<select id=\"batteryType\">\r\n<option value=\"0.5\">Lead-Acid (50%)<\/option>\r\n<option value=\"0.8\">Lithium (80%)<\/option>\r\n<\/select>\r\n<\/td>\r\n<\/tr>\r\n\r\n<tr>\r\n<td>System Voltage<\/td>\r\n<td>\r\n<select id=\"systemVoltage\">\r\n<option value=\"12\">12 V<\/option>\r\n<option value=\"24\">24 V<\/option>\r\n<option value=\"48\">48 V<\/option>\r\n<\/select>\r\n<\/td>\r\n\r\n<td>Backup Hours<\/td>\r\n<td><input id=\"backupHours\" type=\"number\" value=\"8\"><\/td>\r\n<\/tr>\r\n<\/table>\r\n\r\n<div class=\"actions\">\r\n<button onclick=\"calculateSystem()\">\u26a1 Calculate<\/button>\r\n<button onclick=\"exportExcel()\">\ud83d\udcca Excel<\/button>\r\n<button onclick=\"exportPDF()\">\ud83d\udcc4 PDF<\/button>\r\n<\/div>\r\n\r\n<div id=\"results\" class=\"summary\"><\/div>\r\n<\/div>\r\n\r\n<script>\r\nlet reportData = [];\r\n\r\nfunction addAppliance() {\r\n const table = document.getElementById(\"applianceTable\");\r\n const row = table.insertRow();\r\n\r\n row.innerHTML = `\r\n <td><input placeholder=\"Appliance\"><\/td>\r\n <td><input type=\"number\" value=\"0\"><\/td>\r\n <td><input type=\"number\" value=\"1\"><\/td>\r\n <td><input type=\"number\" value=\"1\"><\/td>\r\n <td class=\"energy\">0<\/td>\r\n <td><button class=\"remove\" onclick=\"this.parentNode.parentNode.remove()\">\u2716<\/button><\/td>\r\n `;\r\n}\r\n\r\nfunction calculateSystem() {\r\n const table = document.getElementById(\"applianceTable\");\r\n const results = document.getElementById(\"results\");\r\n\r\n let totalEnergy = 0;\r\n let peakLoad = 0;\r\n\r\n reportData = [[\"Appliance\",\"Power\",\"Qty\",\"Hours\",\"Energy\"]];\r\n\r\n for (let i = 1; i < table.rows.length; i++) {\r\n const row = table.rows[i];\r\n const c = row.cells;\r\n\r\n const nameInput = c[0].querySelector(\"input\");\r\n const name = nameInput ? (nameInput.value || \"Custom\") : c[0].innerText;\r\n\r\n const power = Number(c[1].querySelector(\"input\").value) || 0;\r\n const qty = Number(c[2].querySelector(\"input\").value) || 0;\r\n const hours = Number(c[3].querySelector(\"input\").value) || 0;\r\n\r\n const energy = power * qty * hours;\r\n c[4].innerText = energy.toFixed(0);\r\n\r\n totalEnergy += energy;\r\n peakLoad += power * qty;\r\n\r\n reportData.push([name, power, qty, hours, energy]);\r\n }\r\n\r\n const panelW = Number(document.getElementById(\"panelSize\").value);\r\n const voltage = Number(document.getElementById(\"systemVoltage\").value);\r\n const dod = Number(document.getElementById(\"batteryType\").value);\r\n const backup = Number(document.getElementById(\"backupHours\").value);\r\n\r\n const solarRequired = totalEnergy \/ (5 * 0.8);\r\n const panelCount = Math.ceil(solarRequired \/ panelW);\r\n\r\n const batteryWh = (peakLoad * backup) \/ dod;\r\n const batteryAh = batteryWh \/ voltage;\r\n\r\n const inverterVA = (peakLoad * 1.3) \/ 0.8;\r\n\r\n results.innerHTML = `\r\n <strong>Total Energy:<\/strong> ${(totalEnergy\/1000).toFixed(2)} kWh<br>\r\n <strong>Peak Load:<\/strong> ${peakLoad} W<br><br>\r\n\r\n <strong>Panels:<\/strong> ${panelCount} \u00d7 ${panelW} W<br>\r\n <strong>Battery:<\/strong> ${batteryAh.toFixed(0)} Ah @ ${voltage} V<br>\r\n <strong>Inverter:<\/strong> ${inverterVA.toFixed(0)} VA\r\n `;\r\n}\r\n\r\nfunction exportExcel() {\r\n if (!reportData.length) return alert(\"Calculate first\");\r\n const wb = XLSX.utils.book_new();\r\n const ws = XLSX.utils.aoa_to_sheet(reportData);\r\n XLSX.utils.book_append_sheet(wb, ws, \"Audit\");\r\n XLSX.writeFile(wb, \"energy_audit.xlsx\");\r\n}\r\n\r\nfunction exportPDF() {\r\n if (!reportData.length) return alert(\"Calculate first\");\r\n const { jsPDF } = window.jspdf;\r\n const doc = new jsPDF();\r\n let y = 20;\r\n doc.text(\"Energy Audit Report\", 10, 10);\r\n\r\n reportData.forEach(r => {\r\n doc.text(r.join(\" | \"), 10, y);\r\n y += 7;\r\n });\r\n\r\n doc.save(\"energy_audit.pdf\");\r\n}\r\n<\/script>\r\n\r\n<\/body>\r\n<\/html>\r\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Energy Audit & Solar System Design Tool Energy Audit & Solar System Design Tool Appliance Power (W) Qty Hours Energy (Wh) Action LED Bulb 0 Fan 0 \u2795 Add Appliance System Configuration Panel Size 330 W450 W550 W580 W585 W600 W620 W630 W635 W710 W Battery Type Lead-Acid (50%)Lithium (80%) System Voltage 12 V24 V48 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-fullwidth.php","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-11693","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages\/11693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/comments?post=11693"}],"version-history":[{"count":24,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages\/11693\/revisions"}],"predecessor-version":[{"id":12556,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages\/11693\/revisions\/12556"}],"wp:attachment":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/media?parent=11693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t\t\t\r\n\r\n\r\n\r\nEnergy Audit & Solar System Design Tool<\/title>\r\n\r\n\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.18.5\/xlsx.full.min.js\"><\/script>\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jspdf\/2.5.1\/jspdf.umd.min.js\"><\/script>\r\n\r\n<style>\r\nbody {\r\n font-family: Arial, sans-serif;\r\n background: #f4f6f8;\r\n padding: 20px;\r\n}\r\n.container {\r\n max-width: 1200px;\r\n background: #fff;\r\n padding: 20px;\r\n border-radius: 6px;\r\n}\r\ntable {\r\n width: 100%;\r\n border-collapse: collapse;\r\n margin-top: 15px;\r\n}\r\nth, td {\r\n border: 1px solid #ccc;\r\n padding: 6px;\r\n text-align: center;\r\n}\r\nth {\r\n background: #007bff;\r\n color: white;\r\n}\r\ninput, select, button {\r\n width: 100%;\r\n padding: 5px;\r\n}\r\nbutton {\r\n background: #28a745;\r\n color: white;\r\n border: none;\r\n cursor: pointer;\r\n}\r\n.remove {\r\n background: #dc3545;\r\n}\r\n.actions {\r\n display: flex;\r\n gap: 10px;\r\n margin-top: 15px;\r\n}\r\n.summary {\r\n background: #eef4ff;\r\n padding: 15px;\r\n margin-top: 20px;\r\n border-radius: 5px;\r\n}\r\n<\/style>\r\n<\/head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n<h2>Energy Audit & Solar System Design Tool<\/h2>\r\n\r\n<table id=\"applianceTable\">\r\n<tr>\r\n<th>Appliance<\/th>\r\n<th>Power (W)<\/th>\r\n<th>Qty<\/th>\r\n<th>Hours<\/th>\r\n<th>Energy (Wh)<\/th>\r\n<th>Action<\/th>\r\n<\/tr>\r\n\r\n<tr>\r\n<td>LED Bulb<\/td>\r\n<td><input type=\"number\" value=\"10\"><\/td>\r\n<td><input type=\"number\" value=\"10\"><\/td>\r\n<td><input type=\"number\" value=\"6\"><\/td>\r\n<td class=\"energy\">0<\/td>\r\n<td><\/td>\r\n<\/tr>\r\n\r\n<tr>\r\n<td>Fan<\/td>\r\n<td><input type=\"number\" value=\"75\"><\/td>\r\n<td><input type=\"number\" value=\"4\"><\/td>\r\n<td><input type=\"number\" value=\"8\"><\/td>\r\n<td class=\"energy\">0<\/td>\r\n<td><\/td>\r\n<\/tr>\r\n<\/table>\r\n\r\n<div class=\"actions\">\r\n<button onclick=\"addAppliance()\">\u2795 Add Appliance<\/button>\r\n<\/div>\r\n\r\n<h3>System Configuration<\/h3>\r\n\r\n<table>\r\n<tr>\r\n<td>Panel Size<\/td>\r\n<td>\r\n<select id=\"panelSize\">\r\n<option value=\"330\">330 W<\/option>\r\n<option value=\"450\">450 W<\/option>\r\n<option value=\"550\">550 W<\/option>\r\n<option value=\"580\">580 W<\/option>\r\n<option value=\"585\">585 W<\/option>\r\n<option value=\"600\">600 W<\/option>\r\n<option value=\"620\">620 W<\/option>\r\n<option value=\"630\">630 W<\/option>\r\n<option value=\"635\">635 W<\/option>\r\n<option value=\"710\" selected>710 W<\/option>\r\n<\/select>\r\n<\/td>\r\n\r\n<td>Battery Type<\/td>\r\n<td>\r\n<select id=\"batteryType\">\r\n<option value=\"0.5\">Lead-Acid (50%)<\/option>\r\n<option value=\"0.8\">Lithium (80%)<\/option>\r\n<\/select>\r\n<\/td>\r\n<\/tr>\r\n\r\n<tr>\r\n<td>System Voltage<\/td>\r\n<td>\r\n<select id=\"systemVoltage\">\r\n<option value=\"12\">12 V<\/option>\r\n<option value=\"24\">24 V<\/option>\r\n<option value=\"48\">48 V<\/option>\r\n<\/select>\r\n<\/td>\r\n\r\n<td>Backup Hours<\/td>\r\n<td><input id=\"backupHours\" type=\"number\" value=\"8\"><\/td>\r\n<\/tr>\r\n<\/table>\r\n\r\n<div class=\"actions\">\r\n<button onclick=\"calculateSystem()\">\u26a1 Calculate<\/button>\r\n<button onclick=\"exportExcel()\">\ud83d\udcca Excel<\/button>\r\n<button onclick=\"exportPDF()\">\ud83d\udcc4 PDF<\/button>\r\n<\/div>\r\n\r\n<div id=\"results\" class=\"summary\"><\/div>\r\n<\/div>\r\n\r\n<script>\r\nlet reportData = [];\r\n\r\nfunction addAppliance() {\r\n const table = document.getElementById(\"applianceTable\");\r\n const row = table.insertRow();\r\n\r\n row.innerHTML = `\r\n <td><input placeholder=\"Appliance\"><\/td>\r\n <td><input type=\"number\" value=\"0\"><\/td>\r\n <td><input type=\"number\" value=\"1\"><\/td>\r\n <td><input type=\"number\" value=\"1\"><\/td>\r\n <td class=\"energy\">0<\/td>\r\n <td><button class=\"remove\" onclick=\"this.parentNode.parentNode.remove()\">\u2716<\/button><\/td>\r\n `;\r\n}\r\n\r\nfunction calculateSystem() {\r\n const table = document.getElementById(\"applianceTable\");\r\n const results = document.getElementById(\"results\");\r\n\r\n let totalEnergy = 0;\r\n let peakLoad = 0;\r\n\r\n reportData = [[\"Appliance\",\"Power\",\"Qty\",\"Hours\",\"Energy\"]];\r\n\r\n for (let i = 1; i < table.rows.length; i++) {\r\n const row = table.rows[i];\r\n const c = row.cells;\r\n\r\n const nameInput = c[0].querySelector(\"input\");\r\n const name = nameInput ? (nameInput.value || \"Custom\") : c[0].innerText;\r\n\r\n const power = Number(c[1].querySelector(\"input\").value) || 0;\r\n const qty = Number(c[2].querySelector(\"input\").value) || 0;\r\n const hours = Number(c[3].querySelector(\"input\").value) || 0;\r\n\r\n const energy = power * qty * hours;\r\n c[4].innerText = energy.toFixed(0);\r\n\r\n totalEnergy += energy;\r\n peakLoad += power * qty;\r\n\r\n reportData.push([name, power, qty, hours, energy]);\r\n }\r\n\r\n const panelW = Number(document.getElementById(\"panelSize\").value);\r\n const voltage = Number(document.getElementById(\"systemVoltage\").value);\r\n const dod = Number(document.getElementById(\"batteryType\").value);\r\n const backup = Number(document.getElementById(\"backupHours\").value);\r\n\r\n const solarRequired = totalEnergy \/ (5 * 0.8);\r\n const panelCount = Math.ceil(solarRequired \/ panelW);\r\n\r\n const batteryWh = (peakLoad * backup) \/ dod;\r\n const batteryAh = batteryWh \/ voltage;\r\n\r\n const inverterVA = (peakLoad * 1.3) \/ 0.8;\r\n\r\n results.innerHTML = `\r\n <strong>Total Energy:<\/strong> ${(totalEnergy\/1000).toFixed(2)} kWh<br>\r\n <strong>Peak Load:<\/strong> ${peakLoad} W<br><br>\r\n\r\n <strong>Panels:<\/strong> ${panelCount} \u00d7 ${panelW} W<br>\r\n <strong>Battery:<\/strong> ${batteryAh.toFixed(0)} Ah @ ${voltage} V<br>\r\n <strong>Inverter:<\/strong> ${inverterVA.toFixed(0)} VA\r\n `;\r\n}\r\n\r\nfunction exportExcel() {\r\n if (!reportData.length) return alert(\"Calculate first\");\r\n const wb = XLSX.utils.book_new();\r\n const ws = XLSX.utils.aoa_to_sheet(reportData);\r\n XLSX.utils.book_append_sheet(wb, ws, \"Audit\");\r\n XLSX.writeFile(wb, \"energy_audit.xlsx\");\r\n}\r\n\r\nfunction exportPDF() {\r\n if (!reportData.length) return alert(\"Calculate first\");\r\n const { jsPDF } = window.jspdf;\r\n const doc = new jsPDF();\r\n let y = 20;\r\n doc.text(\"Energy Audit Report\", 10, 10);\r\n\r\n reportData.forEach(r => {\r\n doc.text(r.join(\" | \"), 10, y);\r\n y += 7;\r\n });\r\n\r\n doc.save(\"energy_audit.pdf\");\r\n}\r\n<\/script>\r\n\r\n<\/body>\r\n<\/html>\r\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Energy Audit & Solar System Design Tool Energy Audit & Solar System Design Tool Appliance Power (W) Qty Hours Energy (Wh) Action LED Bulb 0 Fan 0 \u2795 Add Appliance System Configuration Panel Size 330 W450 W550 W580 W585 W600 W620 W630 W635 W710 W Battery Type Lead-Acid (50%)Lithium (80%) System Voltage 12 V24 V48 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-fullwidth.php","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-11693","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages\/11693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/comments?post=11693"}],"version-history":[{"count":24,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages\/11693\/revisions"}],"predecessor-version":[{"id":12556,"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/pages\/11693\/revisions\/12556"}],"wp:attachment":[{"href":"https:\/\/phozenergy.ng\/store\/wp-json\/wp\/v2\/media?parent=11693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}