Summary
In calculating the cost of running HVAC units in the summer and providing a subsequent report, the following processes were carried out:
Upon being opened, the file named ‘HVAC_Cooling’ was saved as ‘Lastname_Firstname_HVAC_Cooling.’ Later, the name was replaced to appear in the footer of the sheet. Then, I created a new header row in the Excel Worksheet. Thirdly, I made a ‘Calculated’ column that entailed a prospective ‘Cooling BTU’ division with $0.00124 and then formatted it with the Accounting Number Format. The data obtained was filtered based on my own ‘Heating BTU’ as directed by the instructions. Later, I applied the best fit across the sheet and set it to the landscape page in a horizontal format.
Lastly, I created a new database in the Access app and named it ‘Lastname_Firstname_Cooling_Cost.’ The other excel file created initially was then imported into access. Data within the access app was then filtered to display ‘Cooling BTU’ values greater than 60,000 only, along with the power units of my choice. The results show that the cost of running HVAC units in summer increase with the increase in Heating BTU (Seo & Ooka, 2017). Therefore, for the practical realization of running the HVAC units, Johnston Smith will be required to set aside funds to cater to the rising Heating BTU as shown,
Appendices
Appendix A
Appendix B
Appendix C
Appendix D
Appendix E
Reference
Seo, J., Ooka, R., Kim, J. T., & Nam, Y. (2017). Optimization of the HVAC system design to minimize primary energy demand. Energy and Buildings, 76, 102-108.