Jump to content
Sign in to follow this  
elsears

Raw (Unscaled Data)

Recommended Posts

Is there any way for SDR to export (and/or store itself) raw (unscaled) values/data into ascii txt files?  I've recently run into cases where discrepancies between commissioning sheets (and different versions of these commissioning sheets) and file-specific values of the scale factor and offset are causing me to re-run massive bulk imports.  That is fine, except that I have a separate database as well for manipulating the data in other ways; and when this happens I have to re-run that process as well. 

 A perfect fit, for me :), would be to store the data in my own database in an unscaled manner, and then apply the scaling on-demand; based on the latest agreed upon scale/offset values.

 

Thanks,

Edward

Share this post


Link to post
Share on other sites

 2 things... I realize I probably posted this into the wrong board (apologies)

second, Another way to ask my question might be to say: If I know the offset and scale factors, is there any way to convert the scaled value back to a raw value?

Share this post


Link to post
Share on other sites

Personally, my approach has been to leave the loggers set to factory defaults for the sensors (at least the "normal" ones - anemometers, vanes, temp).  That way, you don't have to worry that someone tweaked the settings in the logger, or got them wrong.

As to how to "unscale" the data, it's my understanding that you just subtract the offset and then divide by the slope.

The SDR does   value * slope + offset = scaled value.

So the inverse would be     scaled value - offset / slope = value

By storing the values using the default values in your database (either unscaled or the "normal" values for slope/offset), you can always back them out and then re-scale as necessary.

I'm doing this right now for one of my clients - we did post-calibration of some anemometers and we're working on formulaically applying the change in slope/offset to the data (assuming that any change in calibration occurred over the life of the anemometer).

George Friend
President
Prodigium, LLC
george.friend@prodigium.us

Share this post


Link to post
Share on other sites

 thanks for your response.  I also realized also that the formula is displayed in the SDR when you hover over the offset/scale fields when editing the site database.  Sounds like we're working on the same project...

Thanks

Edward

Share this post


Link to post
Share on other sites

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...