Sub-totals can be
used in any Worksheet within JEstimator.
Sub-totals are like control characters and are implemented by
entering the characters '*', '#', '!', and '%' in the UNIT column
of any Worksheet other than the Section List whereby they are
entered in the 'CO' column.
Each column in a worksheet
that has the 'Show Sub-Totals' attribute turned on, has three
sub-total registers. These are referenced within the worksheet
by you using the '*', '#', and '!' in the UNIT or CO column.
When the program encounters one of these flags, it displays/prints
the current value of the appropriate sub-total register for each
column.
Think of these flags as:
'*' Sub-Total
'#' Total
'!' Grand Total
it is important to note that there is a hierarchy involved as
such, as you can zero (reset) the appropriate flag's register
for the Sub-Totals and Totals by including a second character
(the '*') with the flag.
e.g. if you enter the flag '**', the sub-total register will be
zeroed; if you enter the flag '#*', then both the Total and Sub-Total
registers will be zeroed.
NOTE: You cannot zero the Grand Total flag.
The '%' flag is quite different. It simply adds the percentage
of the Grand Total at that point to the Worksheet into the Value
Column. The percentage used is derived from the value in the QTY
column of the worksheet.
The process detailed above is dynamic - every time a change is
made to the worksheet, these flags are obeyed and the results
calculated instantly.
|