File talk:Energy Monitoring ECM.xls: Difference between revisions

Hey there. I realize you were not able to upload your document right away, so these things may have already been changed, but here is what I noticed. Note: I have been working off of the version that Dr. Pearce uploaded at 23:49.

• Resize comment windows... More user friendly so that when someone scrolls over a comment they can see the whole thing.
• Many of the instruction text boxes have the same problem. Just expand them so that all text is visible. Some cells also need resizing (i.e. Utilitiy bill input page, corporate section).
• On your Utility exec summary page, check the writing.. it doesn't always line up. Also, when changing the type of monitoring system (ie. Powerwatch to Electric Detective), text overlaps in your executive summary. This is theoretically the section for whoever is making the decisions, so it should be perfect.
• Which studies did the value of 8.2% come from? Maybe include in your assumptions.
• Otherwise looks really good. The colour coding makes it easy to distinguish between sections for the most part and overall it looks fairly comprehensive.
• All calculations I tried updated well.

- CB

Comments on ECM

• Many grammar and spelling errors, especially on “assumptions” page
• Energy breakdown page is unfinished
• Check that cells and comments with a lot of text are formatted to the proper size so all of the text is visible
• Units for Energy Input Page B11 and energy consumptions (on the same tab)
• It would be really nice if you linked your assumptions and references to the cell they apply to. For example, where did you get the information about how much energy a certain type of light or monitor uses?
• Why does it say “error” in P27 Utilities Input Page. Also an error in P41

Energy Input Page

• How did you calculate energy consumption?
• Are the phones cell phones or landline phones?
• Are hours of operation per day? You should note that.
• It is unclear what the kw value in the top right corner is.

The spreadsheet you’ve made is very thorough and it is clear you put a lot of work into it. Your ecm basically repeats back to the company their energy use that they’ve inputted, tells the company how much it will cost them to implement the monitoring system, and estimates savings based on a percentage that the user feels might be right. It is useful as far as being able to change the possible % savings and see the results, but it is all hypothetical. It is also useful if you use the energy input page just to calculate energy use without access to the electricity bill. In my opinion I think an ecm spreadsheet is not really appropriate or valuable for energy monitoring since it can’t give any revolutionary information. Raising awareness about energy consumption is good and effective, and studies can show quantitative results for their effectiveness, but it’s tough to estimate savings when you aren’t actually saving energy directly.

--Krystal 05:26, 11 February 2010 (UTC)