WEBVTT

1
00:00:00.100 --> 00:00:02.400
This video
will cover special administrative

2
00:00:02.400 --> 00:00:05.400
reporting and ECM Management features.

3
00:00:05.533 --> 00:00:10.900
The ECM manager form can be used to input
savings information for each individual

4
00:00:10.900 --> 00:00:14.366
ECM evaluated as part of any prior
audit effort.

5
00:00:15.700 --> 00:00:17.700
The previously evaluated ECMs

6
00:00:17.700 --> 00:00:20.700
are grouped into the 20 categories
shown on the screen.

7
00:00:21.100 --> 00:00:24.000
The ECM manager allows either
the administrator

8
00:00:24.000 --> 00:00:28.033
or manager to enter information
at an installation or agency level

9
00:00:28.033 --> 00:00:31.733
that was not previously available
for auditors to enter into the system,

10
00:00:32.366 --> 00:00:35.066
including data associated with measure

11
00:00:35.066 --> 00:00:38.066
implementation and M&V activities.

12
00:00:39.233 --> 00:00:42.466
Dropdown boxes
contain pre-populated fields consistent

13
00:00:42.466 --> 00:00:46.333
with reporting requirements.
For each ECM in the BAT,

14
00:00:46.500 --> 00:00:49.366
Evaluated information is shown in gray

15
00:00:49.366 --> 00:00:52.366
in fields on the left of the data
input table.

16
00:00:52.366 --> 00:00:56.766
These data inputs are brought over
from the auditor ECM input form.

17
00:00:57.366 --> 00:01:00.700
In this form, new fields
associated with implemented

18
00:01:00.700 --> 00:01:04.400
ECM values are now available
for data entry.

19
00:01:04.733 --> 00:01:05.566
For convenience

20
00:01:05.566 --> 00:01:09.933
filters are available for implemented
and resiliency related ECMs

21
00:01:10.500 --> 00:01:14.500
These filters can be selected
using the radio buttons on the lower

22
00:01:14.500 --> 00:01:15.733
right of the form.

23
00:01:15.733 --> 00:01:18.200
I am circling them now with my mouse.

24
00:01:18.200 --> 00:01:21.533
The form also includes
several other radio buttons

25
00:01:21.533 --> 00:01:26.233
which I can see if I scroll down in the
form with my mouse like this.

26
00:01:27.733 --> 00:01:28.766
The installation

27
00:01:28.766 --> 00:01:32.100
wide button indicates
if this ECM was implemented

28
00:01:32.100 --> 00:01:35.100
for all buildings for a given entity,

29
00:01:35.100 --> 00:01:37.333
the user may change this.

30
00:01:37.333 --> 00:01:41.166
The resilience related button indicates
whether the ECM has

31
00:01:41.166 --> 00:01:45.266
a resiliency elements
considered as part of the evaluation.

32
00:01:45.966 --> 00:01:48.966
This may also be changed by the user.

33
00:01:49.200 --> 00:01:53.833
The implemented button is a flag,
not directly input by the user

34
00:01:54.933 --> 00:01:58.066
Entering cost data for implementation

35
00:01:58.100 --> 00:02:01.100
automatically invokes this flag.

36
00:02:01.800 --> 00:02:04.166
The measurement verification detail table

37
00:02:04.166 --> 00:02:07.200
located at the bottom of the form
is used to keep track

38
00:02:07.200 --> 00:02:11.400
of actual savings and monitoring activity
throughout an ECM’s life.

39
00:02:11.900 --> 00:02:15.000
Each time an M&V event occurs,

40
00:02:15.533 --> 00:02:19.800
the details of the activities can be added
as a new record

41
00:02:19.800 --> 00:02:22.800
in the support table
at the bottom of the form.

42
00:02:23.100 --> 00:02:27.133
Data to be tracked includes
the date of the M&V event,

43
00:02:27.633 --> 00:02:30.433
the type of verification activity

44
00:02:30.433 --> 00:02:33.433
and the measured savings by energy source.

45
00:02:33.466 --> 00:02:38.233
I will demonstrate the addition
of new data by first selecting a date,

46
00:02:41.600 --> 00:02:42.833
then selecting the

47
00:02:42.833 --> 00:02:45.833
primary method from the dropdown
like this.

48
00:02:46.400 --> 00:02:51.200
Entering in a value for the actual savings
and then a note describing the savings.

49
00:02:51.600 --> 00:02:56.233
It is notable that no new ECM
may be entered on this screen.

50
00:02:56.800 --> 00:02:59.433
Any new ECM should be entered

51
00:02:59.433 --> 00:03:02.433
through the auditors input menu.

52
00:03:02.933 --> 00:03:06.900
See the Energy Measure
Input Menu Selection of the User Guide

53
00:03:06.900 --> 00:03:09.300
for more guidance.

54
00:03:09.300 --> 00:03:12.000
I will now go back to the main
administration menu

55
00:03:12.000 --> 00:03:16.166
by clicking the administration
link at the top of the page like this

56
00:03:16.533 --> 00:03:19.533
so that we can look at the BAT
reporting tool.

57
00:03:19.533 --> 00:03:22.600
I will open the BAT reporting tool
by clicking on the reports

58
00:03:22.600 --> 00:03:25.600
button from the left Navigation menu.

59
00:03:26.166 --> 00:03:28.200
The BAT reporting tool is a form in

60
00:03:28.200 --> 00:03:31.566
which reports can be run
for a variety of information.

61
00:03:32.500 --> 00:03:36.100
The form contains
five horizontal navigation

62
00:03:36.100 --> 00:03:39.900
tabs at the top of the page,
each for a different report.

63
00:03:42.000 --> 00:03:43.833
These reports include

64
00:03:43.833 --> 00:03:48.666
age information, building information, reports on ECM

65
00:03:49.566 --> 00:03:52.700
reports containing information
on the overall condition

66
00:03:52.700 --> 00:03:56.066
of a building's components
and the data dictionary.

67
00:03:57.400 --> 00:04:00.400
Each group of reports functions similarly.

68
00:04:01.166 --> 00:04:03.900
Clicking on the desired report
and selecting run

69
00:04:03.900 --> 00:04:06.900
report will create the desired report.

70
00:04:07.933 --> 00:04:11.033
Filters are available to narrow results
by geography

71
00:04:11.033 --> 00:04:14.466
or facility, and all reports are formatted
for printing.

72
00:04:15.533 --> 00:04:19.566
However,
all reports may also be exported to excel.

73
00:04:20.366 --> 00:04:23.400
To do this, select
and run the desired reports.

74
00:04:24.000 --> 00:04:28.833
I will check the box inside the domestic
hot water systems report like this

75
00:04:29.366 --> 00:04:32.366
and then select the run report button

76
00:04:32.366 --> 00:04:35.600
to tabs will open in Access

77
00:04:36.300 --> 00:04:41.100
one showing the report and the second one
with a small green icon in the top

78
00:04:41.700 --> 00:04:45.066
right click on the tab with the green icon
as I'm doing now.

79
00:04:45.633 --> 00:04:47.966
Then select print preview

80
00:04:49.200 --> 00:04:50.100
from this screen

81
00:04:50.100 --> 00:04:54.633
you can select the Excel icon
at the top menu bar,

82
00:04:55.133 --> 00:04:59.933
which I'm pointing to with my mouse,
and a separate dialog box

83
00:04:59.966 --> 00:05:04.366
will provide instructions
for exporting the data into an Excel file.

84
00:05:04.800 --> 00:05:08.166
Users are encouraged
to select the checkbox next to the open,

85
00:05:08.166 --> 00:05:12.366
the destination file
after the export operation is complete.

86
00:05:12.433 --> 00:05:14.766
For convenience,

87
00:05:14.766 --> 00:05:17.500
there is no need
to save the export routine

88
00:05:17.500 --> 00:05:21.633
so the user may exit the final dialog box
without saving.

89
00:05:22.566 --> 00:05:25.633
Then select the close
print preview button like this

90
00:05:25.633 --> 00:05:30.866
to close the print preview and then select
the yellow close button as I'm doing

91
00:05:30.866 --> 00:05:35.666
now to close the report and return
to the reporting menu as I'm doing now.

92
00:05:36.633 --> 00:05:38.800
Thank you for watching this video
highlighting

93
00:05:38.800 --> 00:05:44.033
key aspects of the Administrator Menu
Reporting and ECM Management features.