Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Eguide lite spreadsheet user guide

eGuide Lite Spreadsheet User Guide The central data repository for the DOE eGuide Lite eGuide Lite is the eGuideLitev xls spreadsheet in the guide home folder This spreadsheet allows you to record and track your energy consumption energy use and energy improvement projects There are tabs in the spreadsheet The ?rst tab is the Dashboard The ?rst step in this tool is Getting Started and because there is no data to be gathered with Getting Started there is no tab in the spreadsheet for this step The material you need to review in Getting Started is found in the Documentation folder under the title -Getting Started pdf There are ?ve tabs that align with ?ve steps in the eGuide Lite Getting Organized Plan Implement Monitor and Review In addition you will see tabs for Energy Sources Energy Use Project List Archive and Summary Report This document is provided to instruct you how to enter data into the spreadsheet and to provide a basic overview of how the spreadsheet manages and presents your data Dashboard The Dashboard tab is designed to function much like the dashboard in your car It is tied to the other parts of the spreadsheet and provides a quick overview of how your energy management e ?orts are progressing The top portion of the Dashboard is a row of gauges Figure one for each step in the eGuide Lite The gauge measures your progress in completing and maintaining that step In instances where the activity or step is tied to data that needs to be updated periodically the gauge is continually assessing the timeliness of your data inputs and providing a quick view of the data ? s relevance to your current state In simple words the dashboard much like the dashboard in your car will let you know what parts of the program need your attention There is a progression to the steps so don ? t expect to get all of the gauges to the top while you are learning how to proceed through this guide The eGuide Lite is based on the Plan-Do-Check-Act cycle of continuous improvement and it may take some time after you get started to work through this cycle and have the chance to push the dashboard gauges to the top Figure Below the gauge panel on the Dashboard are a set of horizontal bar graphs Figure There is one section for each step in the eGuide Lite The progress for each activity in the eGuide Lite step is represented with a horizontal bar measured in percentage Some activities are simple to complete and others will take more time Copyright Georgia Tech Research Corporation and U S Department of Energy eGuide Lite Spreadsheet User Guide docx Figure of ver CeGuide Lite Spreadsheet User Guide One thing you will notice is that the composite average score of all the activities for a particular step do not always equal what you see in the top gauge panel This is due to the fact