Advanced Scheduling-TNO Calculation for CDS Submission

If your project has 2-storey unit type, the default BCA’s CDS schedule and calculation would show exceeded TNO value which should be 5 as maximum.

It would calculate wrongly for the required area and volume as because of total TNO.

In order to get the combining area, merging the two rows in Revit is impossible. However, you can add the following additional parameters and formulae to get the combined value.

Rename existing parameter “TNO” to “TNO (1-Level)” before you create new “TNO” parameter as number instead of integer format.

The following formula will be true if the unit has 2 levels. if(Net Unit GFA % = 1, [TNO (1-Level)], (if(Net GFA < 45 m², 2, if(and(Net GFA < 75 m², Net GFA > 45 m²), 3, if(and(Net GFA < 140 m², Net GFA > 75 m²), 4, 5)))) / 2)