<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Hi<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>I’m puzzled by my results when extracting data from an RRD which stores power usage in kW from several sensors. They are spot values and are not constantly increasing like a router byte counter. This is RRD 1.2 on Windows x86 by the way.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>The RRD definition is this.... <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>rrdtool create kwh.rrd --start N --step 300 <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>DS:graze_0:GAUGE:900:0:60000 <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>DS:edctr_0:GAUGE:900:0:60000 <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>DS:hall_0:GAUGE:900:0:60000 <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>DS:shop_0:GAUGE:900:0:60000 <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>DS:encounter_0:GAUGE:900:0:60000 <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>RRA:AVERAGE:0.5:1:105120 <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>RRA:AVERAGE:0.5:12:43800<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Which as I understand it should maintain the data with two averages for each sensor. <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>One average should be for every 5 minutes for 105120 samples (approx 1 years worth)<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>The other should store 1hrly for 43800 samples (approx 5 years worth)<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>The data collection has been running since approx May 2010 so I was expecting to be able to dump either 5min averages (back to Jun 12ish 2010 – a yrs worth) or the full 1hrly averages right back to May 2010. I realise its averaged data and not actual data values – thats fine.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>If I dump the data using RRDTOOL DUMP I can see all the data as I expect it. (5 min and 1 hr intervals all ok)<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>The problem I am having is getting the data exported using RRDTOOL XPORT – no matter what step I give it seems to be in 36000 steps and I cant get either 5 min or 1hr steps.......<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>The output command I’m using is (eg)<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>rrdtool xport -s Jan_1 -e Jun_6 --step 300 DEF:graze=kwh.rrd:graze_0:AVERAGE XPORT:graze:graze<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Which gets me this<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>graze:36000<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>step: 36000<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><?xml version="1.0" encoding="ISO-8859-1"?><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><xport><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <meta><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <start>1293912000</start><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <step>36000</step><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <end>1307340000</end><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <rows>374</rows><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <columns>1</columns><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <legend><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <entry>graze</entry><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> </legend><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> </meta><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <data><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1293912000</t><v>NaN</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1293948000</t><v>7.6373329643e+003</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1293984000</t><v>3.2184306372e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294020000</t><v>8.7615560014e+003</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294056000</t><v>1.9665019537e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294092000</t><v>2.1051444142e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294128000</t><v>7.4891892048e+003</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294164000</t><v>3.1874450422e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294200000</t><v>2.1790117352e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294236000</t><v>3.0731709437e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294272000</t><v>1.6547402220e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294308000</t><v>1.6929343229e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294344000</t><v>2.1757634908e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294380000</t><v>7.4123166718e+003</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294416000</t><v>2.3384609095e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294452000</t><v>8.5652547377e+003</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294488000</t><v>1.6631237788e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294524000</t><v>1.9049472654e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294560000</t><v>8.7360718392e+003</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <row><t>1294596000</t><v>3.1791358773e+004</v></row><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Why is the step size so large? I’m sure I’m doing something stupid ..... 8-)<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Thanks<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Dave<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#004000'>Dave Whitehead | </span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#004000'>IT & Telecomms Manager | Marwell Wildlife | Colden Common | Winchester | SO21 1JH<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:Wingdings;color:#004000'>(</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#004000'> Direct: +44 (0)1962 777930 | Mob: +44 (0)7881 408657 </span><span lang=EN-US style='font-size:10.0pt;font-family:Wingdings;color:#004000'>+</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#004000'> <a href="mailto:davew@marwell.org.uk"><span style='color:blue'>davew@marwell.org.uk</span></a> </span><span lang=EN-US style='font-size:10.0pt;font-family:Wingdings;color:#004000'>:</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#004000'> <a href="http://www.marwell.org.uk/"><span style='color:blue'>www.marwell.org.uk</span></a> </span><o:p></o:p></p></div>
<P align=left>
<HR>
<P></P>
<P align=left><FONT size=2 face=Arial>Please print responsibly</FONT></P>
<P align=left><FONT size=2><FONT face=Arial>Marwell Wildlife is a
limited liability company registered in England and Wales under number
1355272.</FONT><FONT face=Arial>VAT No. 631 9661 30. The company is a registered
charity, number 275433. </FONT><FONT face=Arial>Registered office: Marwell
Wildlife, Colden Common, Winchester, Hampshire, SO21 1JH.</FONT></FONT></P>
<P align=left><FONT size=2><SPAN class=apple-style-span><SPAN
style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 7.5pt" lang=EN-US><FONT
size=2>Opinions expressed in this e-mail are those of the individual, not the
company unless specifically indicated to that effect. This e-mail and any
attachments are confidential and solely for the use of the intended recipient.
If you are not the intended recipient we apologise for any inconvenience. Please
return to the sender. Any use or copying is strictly
prohibited</FONT>.</SPAN></SPAN><SPAN
style="FONT-FAMILY: Helvetica; COLOR: black; FONT-SIZE: 9pt; mso-bidi-font-family: 'Times New Roman'"
lang=EN-US><O:P></O:P></SPAN></FONT></P>
</body></html>