There are multiple ways to set baseline in the dashboard, depending on the data the customer provides, follow those specific steps below:

Click here if we did a 1:1 fixture replacement and you were given the wattage of the old fixtures

Click here if we used circuit controllers - each of our devices control multiple fixtures - and you were given the KhW for the entire site

Steps to set baseline with the wattage of the old fixtures:

1. Log into the site

2. Select Terminal

3. Type: `set -t (device type) -i 31 (index row it's in) -v (previous watts)`

Example: set -t driver -i 31 -v 92

Steps to calculate the value:

Background: BEF: Ballast Efficiency Factor - The efficiency of the ballast itself. A BEF of .85 is fairly typical, but older fixtures maybe have significantly worse efficiency. a BEF of 0.85 means that the ballast is “85% efficient”, or losing 15% of the energy it consumes, so to calculate the total fixture power consumption you multiply the tube wattage by 1.15 to get the total value.

Formula: #watts x 1.15

Example: 80 x 1.15 = 92w

Only do step 4 if you are backtracking - if the site has had controls and baseline was not set up prior. If you are not backtracking, then skip to step 5

4. Type: `set -t (device type) -i 23 (index row it's in) -v (Amatis device watts)`

Example: set -t driver -i 23 -v 32 (watts for our garage fixture)

5. Type: `set -t (device type) -i 30 (index row it's in) -v 2 (baseline mode)`

Example: set -t driver -i 30 -v 2
If the lights were on 24/7 in this space prior to our controls being installed, use baseline mode 1, instead of 2.

Note: The data should start populating in the Dashboard after 1 hour.

Steps to set baseline with the sites previous KWH usage:

1. Log into the Energy dashboard

2. Extract the data from the dashboard:

Steps

Select Graphing
In the All Data Points table search for Energy
Select all the devices you need to set baseline for
In the Selected Data points table use the drop down to select 30 days
Select Graph it
Select CSV

3. Let excel or gsheets do the math for you!

Open up this template: https://docs.google.com/spreadsheets/d/1HK4PXwJeoimfkYbkr0Zh0Sae4PYxeFqGpbqJMu5ML_I/edit#gid=0
The gray section is the information you will get from the csv file from the dashboard. But you need to fill out the blue and green sections.

Steps:

Add 3 rows in the top of the sheet with the following names:

Total Energy Usage (per month)
Baseline Energy Usage (per month)
Actual Savings

2. Add 4 rows to the bottom of the sheet with the following names:

Energy per device
Proportion
Baseline Wh
Baseline Watts

3. Pull the formulas from the B column in both the green and blue cells and add them to your sheet

4. Input the data from this sheet into the app

Note: When you put it into the app, the app will share the information to the dashboard which is what will populate those graphs for you.