We have now launched an online beta version of our tool used for removing noise and spikes in measurement data caused by measurement errors. By removing unwanted noise and spikes in the measurement data it becomes more accurate and easier to work with. The beta version is so far free to use. Our stand-alone version can be found here.

 

 

Click image to see our updated version of db DataCleaner.web

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Download the text file with measurement data to try it:

 

example_1.txt (right-click and select ‘save target as’)

 

 

Quick guide

 

 

1. Prepare the measurement data

 

db DataCleaner.web reads data from text files. In order for db DataCleaner.web to read the data properly it must be prepared first. The data is easiest prepared in either MS Excel or OpenOffice Calc and then exported as text file.

 

 

Export data from MS Excel (or OpenOffice Calc)

 

The image below shows how the data should be placed to export it properly. The different data headers should be placed in row 1, starting with column ‘A’. The data should be placed under each header, starting on row 2. As many as 256 different signals can be added.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When the data is prepared you select all cells and right-click the mouse. Select ‘Format cells’ and in the ‘Value’ tab choose ‘Value’ under ‘Category’. Select how many decimals you want and click OK.

 

Now go to ‘Save as’ and choose ‘Text (separated by tabs)’ under file format. Click ‘Save’. All columns in the text file will now be separated by a tab.

 

 

2. Import data to db DataCleaner.web

 

Click ‘Import data...’ in the db DataCleaner.web window and browse to the text file containing the measurement data.

 

 

3. Perform data clean

 

When the text file has been imported just press the ‘Run’ button and the data cleaning starts.

 

 

4. Result from data cleaning

 

When the calculation has finished, the result is plotted in the window. The signal name is shown in the upper left corner. You can scroll through all signals by using the drop down list under ‘View cleaning result’.

 

 

5. Manual fine tuning

 

The automatic data cleaning is very powerful and usually there is no need to perform any manual fine tuning of any signal. But if you scroll through the signals and see that some of them are too hard or not hard enough cleaned you have the possibility to adjust that manually. Under ‘Manual controls’ you have 3 sliders controlling different parameters of the data cleaning. They are set to 50% by default.

 

1. Noise reduction strength

Controls how hard the noise reduction of the signal should be. By moving the slider to 0% you will not have any noise reduction and by moving the slider to 100% you will have a very hard reduced signal.

 

2. Spike level adjustment

Controls what should be considered as a spike in the measurement data.

 

3. Spike width adjustment

Controls how wide a spike must be to be considered a spike.

 

When you have set the sliders as you want, just press “Fine Tune” to see the result of your settings. This can be done until you are pleased with the result. NOTE: Only the signal seen in the window will be affected by your manual settings. If you want to reset your manual settings to a signal, set all sliders to 50% and press “Fine Tune”.

 

 

6. Export cleaned data

 

Click the “Export data...”-button and a text box will appear in the bottom of the screen. Just select all data in the text box (Ctrl + A) and copy it (Ctrl + C). The data can the be pasted directly into MS Excel or OpenOffice Calc.

 

 

 

Correct placement of headers and measurement data

Go to updated version of db DataCleaner.web