Schedules and Formulas

[Thomas Allan Palmer]

Hi,

I understand that from AC22 on you can use formulas. I can easily make schedules that add totals but would like to be able to subtract areas and produce percentages. Typically for project data. Below is a sample of what kind of schedule I would like to create:

I would like to create a schedule that:
Title: "Project Data"

Site Area (zone) sq. ft.
Building Area (zone) sq. ft.
Site Coverage (Building Area / Site Area as a %)
Open Area (Site Area - Building area) sq. ft., %
Calculates Gross Floor Area (zone) sq. ft., by storey, total
Net Floor Area (gross floor area minus exclusions) (zone) sq. ft., by storey, total
Floor Area Ratio (net floor area / site area) sq. ft.
Units By Type (based on zones), by storey, total
Density (units per acre)

same as above using m2 listed next to the sq. ft. numbers

[Anonymous]

Barry wrote:

kzaremba wrote:
However, since it's the expression you cant sum it up in schedule... even if I left it as number value.... proc num column on attachment.

'proc num' column has totalled correctly.

Barry.

Sure Sum did but I meant value in the cell. The proc num shows the only ratio between single apartment to the overall area - so quite useless. I'd expected to sum hole type of apartments. (if you sum up cells in this column you get 29,28).

[Barry Kelly]

You have multiple elements with the same 'proc num' result.
Because they are not unique, they show the same figure but the total is correct.

(1 x 5.44) + (6 x 9.67) + (2 x 5.90) +(3 x 8.27) = 100.07

In the scheme settings try turning on the 'flag' icon next to the 'proc num' field.
You should then see sub totals - I hope.

NOTE: this does not work for area, length, width fields, as these do sum as you are wanting them to (which I think is wrong).
But your field is not a true area, length or width so it should work.

Barry.