<< Click to Display Table of Contents >> Navigation:  The Counting Tab [from v6.1.18] > Reporting > Excel processing – example calculating the Phase%

The advantage of exporting to Excel, is that further processing easily can be done.

 

As example:

•If the phase number (by tag % PHASEPCT %) is written to A39. This will write the phase numbers to column A, starting from A39.

•If the phase percentage (by tag %PHASEIDX%) is written to B39. This will write the phase percentage to column B, starting from B39.

Then the total phase percentage for phase “1” can be calculated like "=SUMIF($A39:$A100, "1",$B39:$B100)"

 

Sample template with data processing.