Feature Request: Windowed Energy Display Statistics

SolarMill · 2016-07-06T19:07:36.481Z

As a manufacturing company, we are routinely analyzing the embodied energy of the products we make. We have Emon sensors installed on all of our machinery and equipment and are using EmonCMS to log and graph. Frequently we have the need to look at how much energy a specific operation required or even just what we used that afternoon. The Wh logging functionality is very handy, but to pull out specific moments requires cutting and pasting values and using a calculator to determine how much energy was used in a given time span.

In one of the current visualizations there is displayed below the graph some very useful figures: quality, min, max, mean, and std deviations. It would be extremely useful for the statistics to show how much energy is displayed in the current window assuming that the source is watts. We are interested in developing this functionality ourselves but could use some guidance for a starting point.

How do we go about modifying the GRAPH visualization to display the energy integral expressed as Wh?

-Berkeley

SolarMill · 2016-07-07T20:16:47.787Z

Here’s a screen shot at what we’re looking at doing.

Screen Shot 2016-07-06 at 5.52.38 PM.png1984×1396 322 KB

TrystanLea · 2016-07-08T14:04:52.151Z

Good idea + enjoying reading your posts and love what your doing with SolarMill!

If you add another line here as below that should do it:
https://github.com/emoncms/graph/blob/master/graph2.js#L491

(mean power in watts x time_in_window in seconds) / 3600 Joules in 1 watt hour

out += "<td>"+((feedlist[z].stats.mean * time_in_window) / 3600).toFixed(dp)+"</td>";

TrystanLea · 2016-07-08T14:06:56.357Z

The table titles are set here:

github.com

emoncms/graph/blob/master/view.php#L161

    
      
          </div>
          <div>
              <div id="yaxis_left" class="input-append input-prepend">
                  <span id="yaxis-left" class="add-on"><?php echo _('Y-axis').' ('._('Left').')' ?>:</span>
                  <span class="yaxis-minmax-label add-on"><?php echo _('min') ?></span>
                  <input class="yaxis-minmax" id="yaxis-min" type="text" value="auto">
                  <span class="yaxis-minmax-label add-on"><?php echo _('max') ?></span>
                  <input class="yaxis-minmax" id="yaxis-max" type="text" value="auto">
                  <button class="btn reset-yaxis"><?php echo _('Reset') ?></button>
              </div>
              <div id="yaxis_right" class="input-append input-prepend">
                  <span id="yaxis-right" class="add-on"><?php echo _('Y-axis').' ('._('Right').')' ?>:</span>
                  <span class="yaxis-minmax-label add-on"><?php echo _('min') ?></span>
                  <input class="yaxis-minmax" id="yaxis-min2" type="text" value="auto">
                  <span class="yaxis-minmax-label add-on"><?php echo _('max') ?></span>
                  <input class="yaxis-minmax" id="yaxis-max2" type="text" value="auto">
                  <button class="btn reset-yaxis"><?php echo _('Reset') ?></button>
              </div>
              <button id="reload" class="btn" style="vertical-align:top"><?php echo _('Reload') ?></button>
              <button id="clear" class="btn" style="vertical-align:top"><?php echo _('Clear All') ?></button>
          </div>

SolarMill · 2016-08-11T18:07:57.610Z

Looking to implement these changes now and came across a question. Where are these files located on the EmonPi? We installed using the pre-built image.

-Berkeley Fergusson

Jon · 2016-08-11T19:26:10.517Z

SolarMill:

Where are these files located on the EmonPi?

Do a search via the terminal command and you’ll find both files:

pi@emonpi:~ $ sudo find / -iname graph2.js
/var/www/emoncms/Modules/graph/graph2.js
pi@emonpi:~ $ 
pi@emonpi:~ $ sudo find / -iname view.php
/var/www/emoncms/Modules/graph/view.php
/home/pi/postprocess/mainserver/postprocess/view.php
pi@emonpi:~ $

ignore the post processing file.

SolarMill · 2016-08-12T19:25:53.031Z

Found view.php, but we don’t have a graph2.js on our pi just a graph1.js

Jon · 2016-08-12T20:20:00.349Z

Ugh! This is probably over my head. We’ll probably need help from @TrystanLea or @glyn.hudson. What directory did you find “graph1.js”?

Run this command and let us know the results:

ls /boot | grep emonSD

SolarMill · 2016-08-12T20:27:14.753Z

I do not get any results at all with that command.

pb66 · 2016-08-12T20:52:36.171Z

graph2.js is part of the optional graph module, do you have that installed?

github.com

emoncms/graph/blob/master/readme.md

# Graph

A versatile graphing module for emoncms. This module is designed to replace the default data viewer in emoncms and is loaded when a feed view button is clicked.

# Install 

## 1. Install the Graph module

And ensure you are runing latest version and Emoncms

    cd /var/www/emoncms
    git pull
    cd /var/www/emoncms/Modules
    git clone https://github.com/emoncms/graph

Check for Database upates in Admin

## 2. Make Emoncms use graph module as default feed viewer

Add (or change) `$feedviewpath = "graph/";` in `settings.php`

This file has been truncated. show original

SolarMill · 2016-08-12T21:12:39.714Z

It is in the same directory that our view.php and your graph2.js are in.

/var/www/emoncms/Modules/graph/

pb66 · 2016-08-12T21:23:48.164Z

If you have a graph directory in emoncms/Modules then you do have the graph module installed but if graph2.js isn’t there it is not up to date.

if you cd into the emoncms/Modules/graph directory and run a git pull you should find it after that.

SolarMill · 2016-08-15T16:25:38.539Z

That did it graph2.js is there now. Made the changes and also added some other stuff. For now it’s up to the user to decide what the “Int” value means, and whether or not the “Wh” and “kWh” values are relevant or not.

graph2 screenshot.PNG1306×631 64.4 KB

Starting at line 491 in graph2.js
out += "<td>"+feedlist[z].stats.stdev.toFixed(dp)+"</td>"; out += "<td>"+((feedlist[z].stats.mean * time_in_window)).toFixed(dp)+"</td>"; out += "<td>"+((feedlist[z].stats.mean * time_in_window) / 3600).toFixed(dp)+"</td>"; out += "<td>"+((feedlist[z].stats.mean * time_in_window) / 3600000).toFixed(dp)+"</td>"; for (var i=0; i<11; i++) out += "<option>"+i+"</option>";

Link to fork: GitHub - solarmill/graph: Versatile graphing module for emoncms

Thanks for the help everyone!

-Berkeley Fergusson