Adding Mode and Median to your report

There is no built-in way in the Clemex software to add these measurements to your analysis.
It is still possible to do so using Excel.

In order to do this, you need to:

1- in your routine, just after the Measure instruction, add an "Export Data instruction". This allows you to export to a temporary file. This file only needs to contain the correct data while the report is generated. Disable overwrite protection as this is just a temporary transit file.

​


2- Open the tempo.xls file. Select and copy the entire column containing your length measurements.

​

3- open your template for editing

​


4- on the second sheet of your template, select the entire first column, right click on it and select paste special. Select "Paste Link"
​

You should see the current content of your length column of the temp file. It is now linked in the template.
​


5- going the the first sheet of your template, you can now add mode and median formulas that use the data on Sheet2. They need to be entered in a way to ignore the trailing zeros of the unfilled cells. If you link-pasted your data to Column A of Sheet2, the cells are :
=MEDIAN(IF(Sheet2!A:A<>0,Sheet2!A:A))
=MODE(IF(Sheet2!A:A<>0,Sheet2!A:A))

You NEED to write the content of the cell in the top bar and confirm with Ctrl+Shift+Enter.
This wil add the curly brackets surrounding the entire equation.


 (see : https://www.wizardofexcel.com/2013/11/13/modeif-and-medianif-conditional-mode-and-median/ for more info)


​​

Once you hit Ctrl+Shift+Enter, the equation will become. Notice the brackets!!!
​
 (for more info, search the internet for "excel mode without Zeros" or see : https://www.wizardofexcel.com/2013/11/13/modeif-and-medianif-conditional-mode-and-median/ )

6- save your template. 

You should be ready to go!!