FlowWorks graphic data editing and QA/QC tools make it possible to edit any and all data, on a single secure web platform, from anywhere. Designed by power users from the FlowWorks community, the editing tools combine the game-changing FACE (FlowWorks Advanced Calculation Engine) with an intuitive interface designed to make short work of data editing. Using the tools, analysts and data managers can select data directly on graphs and tables to delete or modify it including applying offsets, interpolation and much more. A complete history of all edits is stored in the permanent record so reviewing data across multiple hardware platforms has never been easier.
The new FlowWorks Graphic Editing QA/QC tools make it easy to:
Quickly select data channels to edit
Select data points directly by drawing boxes on time-series graphs or scatter-graphs, using date range selection tools, or through direct entry of dates and times
Raw data is always protected from editing – editing tools make it easy to save edited data to new records
Find and replace missing data
Apply corrections to ranges of data, or to individual data points
Make quick work of simple operations such as nulling invalid data, applying constants and linearly varying ramps, and data substitution.
Automatically create and edit QA/QC flags
View and make direct edits in the tabular data display
Add notes to document your edits, which can be displayed on the graphical interface
One-stop data editing – all part of the power of FlowWorks.
Watch this video to see how curve fitting works in the graphing engine.
Curve Fitting Function
This section explains how to use the curve fitting function inside the ‘Graphing’ functions. Begin by bringing up a graph showing two different series that you want to graph against each other. In this case level and flow form an AV meter have been selected for the ‘Last 7 Days’.
Under ‘Plot Method’ change from a ‘Time Series’ to a ‘Scatter Plot’ and click on the ‘Plot Data’ button.
You are given a scatter plot showing level and flow in this case.
To add a curve to this graph click on ‘Curve Fit’ on the top right corner of the screen.
Select ‘New Curve”.
Then select which type of curve you would like to pick. You can chose between ‘Linear’, ‘Polynomial’, ‘Exponential’, ‘Logrithmic’, ‘Power’ and you can also plot ‘Manning’ curves. Start by doing a ‘Polynomial’.
Select the polynomial order. In this case we will use the third degree. Chose ‘save’ and the information is stored for this curve fit.
If you want to plot the curve, select it and click on ‘OK’.
You see the curve that best fits through the data using a third order polynomial shown on the graph. At the bottom of the graph you can see the equation for the polynomial and the calculated R2.
If you want to try a different kind of curve simply click on ‘Curve Fit’ and define a new curve.
For the next example we can plot a fourth degree polynomial and save it.
The information is now saved for the fourth degree polynomial. You can chose to turn it on as well.
Although you can’t see the difference from a far, zooming in will show that there is in fact two curves.
You can turn on and off curves by checking or un-checking them in the curve fit box.
If you want to add a manning curve, simply chose the ‘Manning’ function and enter in the pipe diameter, in this case 0.3 meters, the hydraulic slope which in this case is 0.04 and the manning coefficient you want to display.
Chose save and then chose to display this curve.
You will see the manning curve plotted through the data.
It is important to note that the manning curve is not a curve fit through the data. It is simply the manning curve based on the coefficients that were entered.
With any curve, clicking on the curves shows the values under selected point. This allows you to look up values by simply clicking on the curve at different locations and reading the value underneath the graph.
You can display a family of manning curves by simply going to ‘Curve Fit’ and selecting another new curve. So in this case we will produce another manning curve with a manning coefficient of 0.015.
Save it and then chose to display it. This will display the second curve so you can show a series of curves on the graph.
Under curve fit, each curve type is shown along with the date range of data the curve was fit to and the x and y values that were used in the fit. This date range does not change. It you want to create another curve using different data, you have to create it using the ‘New Curve’.
To delete a curve simply select it and click on ‘delete’.