energy consumption plot

Posted on
Tue Feb 23, 2016 10:32 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

energy consumption plot

Here the steps do do this plot .. hope that helps.

Karl

Screen Shot 2016-02-23 at 10.19.29 PM.png
Screen Shot 2016-02-23 at 10.19.29 PM.png (57.73 KiB) Viewed 2229 times

select the data:
Screen Shot 2016-02-23 at 10.08.50 PM.png
Screen Shot 2016-02-23 at 10.08.50 PM.png (92.31 KiB) Viewed 2229 times

but for ENEGRY you must select a reset frequency, otherwise will you will only have a line that goes up continuously and the values might be VERY large >> 100000 as it is the accumulated energy since last reset . You can select a reset once a day(used in this plot) or once a week or every xx days.


use the normal properties (i.e. average) for power(Watts), temperature etc


Setup the energy consumption histogram, here just the engr. histogram
Screen Shot 2016-02-23 at 10.12.58 PM.png
Screen Shot 2016-02-23 at 10.12.58 PM.png (96.16 KiB) Viewed 2229 times



The attached gives the properties used in the program for all lines. The parameters should be understandable they map one to one to the input fields
the energy line is the one with "" -l# 15/Energy Week/4 Color>#000000<; EveryRepeat>1<; Func>None<; LeftRight>Right<; Multiplier>0.25<; NumbersFormat><; Nu..."

the marker points are created (e.g. max: 59) with " EveryRepeat>max<..."

Code: Select all
Feb 23, 2016, 10:14:48 PM
  INDIGOplotD                     pending indigoCommands: ['PrintPlotData:309579619']
  PLOT:: EnergyUsage ü            deviceID: 309579619
  ...Background                   >>#FFFFFF<<
  ...Border                       >>1+2+4+8<<
  ...DeviceNamePlot               >>EnergyUsage ü<<
  ...ExtraText                    >><<
  ...ExtraTextColorRGB            >>#000000<<
  ...ExtraTextFrontBack           >>front<<
  ...ExtraTextRotate              >>0.0<<
  ...ExtraTextSize                >>10<<
  ...ExtraTextXPos                >>0.0<<
  ...ExtraTextYPos                >>0.0<<
  ...Grid                         >>0<<
  ...LeftLabel                    >>                                   Power[W]<<
  ...LeftLog                      >>linear<<
  ...LeftScaleDecPoints           >>0<<
  ...LeftScaleRange               >>-15000:11500<<
  ...LeftScaleTics                >>0,1000,2000,3000,4000,5000,6000,7000,8000,9000,10000<<
  ...MHDDays                      >>[1, 14, 0]<<
  ...MHDShift                     >>[0, -11, 0]<<
  ...NumberIsUsed                 >>1<<
  ...PlotFileLastUpdate           >>0<<
  ...PlotFileOrVariName           >><<
  ...PlotType                     >>dataFromTimeSeries<<
  ...Raw                          >><<
  ...RightLabel                   >>Energy KWH(*0.1) and KWH*cost<<
  ...RightLog                     >>linear<<
  ...RightScaleDecPoints          >>0<<
  ...RightScaleRange              >>0:400<<
  ...RightScaleTics               >>0,50,100,150,200,250<<
  ...TextColor                    >>#000000<<
  ...TextFont                     >>System-font<<
  ...TextMATFont                  >>sans-serif<<
  ...TextSize                     >>10<<
  ...Textscale21                  >>1.5<<
  ...TitleText                    >>Energy<<
  ...TransparentBackground        >><<
  ...TransparentBlocks            >>1.0<<
  ...XLabel                       >>x-axis Text<<
  ...XLog                         >>linear<<
  ...XScaleDecPoints              >>0<<
  ...XScaleFormat                 >><<
  ...XScaleRange                  >><<
  ...XScaleTics                   >><<
  ...XYvPolar                     >>xy<<
  ...ampm                         >>24<<
  ...compressPNGfile              >>False<<
  ...dataSource                   >>interactive<<
  ...drawZeroLine                 >>false<<
  ...resxy                        >>[u'850,600', u'']<<
  ...variableInText               >><<
  ...variableinPlot               >><<
  -l# 1/W                         Color>#4B0082<; EveryRepeat>1<; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>66<; ToColumnIndexB>0<; Type>LineSolid<; Width>2<
  -l# 2/Kwh                       Color>#00FFFF<; EveryRepeat>1<; Func>None<; LeftRight>Right<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>64<; ToColumnIndexB>0<; Type>Histogram<; Width>0<
  -l# 3/avL                       Color>#4B0082<; EveryRepeat>1<; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>66<; ToColumnIndexB>0<; Type>averageLeft<; Width>4<
  -l# 4/                          Color>#00FFFF<; EveryRepeat>1<; Func>None<; LeftRight>Right<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>64<; ToColumnIndexB>0<; Type>averageRight<; Width>3<
  -l# 5/Cost*10                   Color>#00A000<; EveryRepeat>1<; Func>None<; LeftRight>Right<; Multiplier>10.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>65<; ToColumnIndexB>0<; Type>LineSolid<; Width>3<
  -l# 7/MAX                       Color>#A00000<; EveryRepeat>max<; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat>MAX: %d[W]<; NumbersOffset>1,0.2<; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>66<; ToColumnIndexB>0<; Type>Numbers<; Width>2<
  -l# 8/day                       Color>#00FFFF<; EveryRepeat>day<; Func>None<; LeftRight>Right<; Multiplier>1.0<; NumbersFormat>%d<; NumbersOffset>1,0<; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>64<; ToColumnIndexB>0<; Type>Numbers<; Width>1<
  -l# 9/day                       Color>#00A000<; EveryRepeat>day<; Func>None<; LeftRight>Right<; Multiplier>10.0<; NumbersFormat>%d<; NumbersOffset>-0,0.7<; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>65<; ToColumnIndexB>0<; Type>Numbers<; Width>2<
  -l# 10/MIN                      Color>#FF0000<; EveryRepeat>min<; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat>Min: %d[W]<; NumbersOffset>0.7,-0.1<; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>66<; ToColumnIndexB>0<; Type>Numbers<; Width>1<
  -l# 13/                         Color>#FF0000<; EveryRepeat>min<; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>66<; ToColumnIndexB>0<; Type>DOT*<; Width>1<
  -l# 14/                         Color>#A00000<; EveryRepeat>max<; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>66<; ToColumnIndexB>0<; Type>DOT*<; Width>1<
  -l# 15/Energy Week/4            Color>#000000<; EveryRepeat>1<; Func>None<; LeftRight>Right<; Multiplier>0.25<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>1<; ToColumnIndexB>0<; Type>LineSolid<; Width>3<
  -l# 18/                         Color>#000000<; EveryRepeat>lastBin<; Func>None<; LeftRight>Right<; Multiplier>0.25<; NumbersFormat>%3d<; NumbersOffset>-0.2,0.5<; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>1<; ToColumnIndexB>0<; Type>Numbers<; Width>1<
  INDIGOplotD                     
  Schedule                        checkNOAARainStatus
  Sent INSTEON                    "poolHeater" off

Posted on
Tue Nov 08, 2016 8:35 am
exos offline
Posts: 57
Joined: Feb 02, 2016

Re: energy consumption plot

Hey Karl,

I'm trying to work on an Energy plot. I seem to have some large spikes of Power usage that get averaged out in my line graph, however when I try to plot my min, max data points, the min works fine but the max line pulls data from the averaged out high spike and the data gets put much higher than is what is useful on the graph. I have no offsets for the max text.
Attachments
Energy-hour-S2.png
Energy-hour-S2.png (34.47 KiB) Viewed 2004 times

Posted on
Tue Nov 08, 2016 12:00 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: energy consumption plot

when we plot averages it does the average .. (thats pretty straight forward)
when we plot min/max, we have 2 choices: 1. min/max of the individual data or min/max of the averages. I believe i took the min/max of the individual values.

individual values: the energy monitor sends data every 1-10 minutes- depending on settings. some of them might be very high, while in average it can much lower.
if you look at the 5 minute plot you should see lots of spikes up and down..
but let me double check.

could you run indigo utilities and check if there is any data at that value?

Posted on
Tue Nov 08, 2016 12:09 pm
exos offline
Posts: 57
Joined: Feb 02, 2016

Re: energy consumption plot

where do I set whether I want the min/max values to come from the average or the real data? I do have data at those points.

"we have the choice"(*): I made a decision one way or the other.. currently no option to have both


Karl
(*) philosophically speaking

Posted on
Tue Nov 08, 2016 1:23 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: energy consumption plot

double checked: i use the min / max of the binned data = min/max of the averages, not the min/max of the real data.

this could be a bug..

could you post menu/print /log plot config parameters for that plot?

things you could check:
1. did you add an offset in the line def (where the should the text "max 6....W"go)
2. i guess you are using matplot?
3. you used "at MAX over all" for the max / min values?

Karl


sorry I edited your posted, wanted to add a reply in the previous posting

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest