Area Schedule

[bill.92885]

Can someone help with a problem I'm having? I'm working on a residential project and need to show the area schedule on the plan sheet. I've created the area plans for the two floors and have named the areas accordingly. I then went and created a schedule from the Areas (gross building) category and all my areas show up and there's a grand total at the bottom. Here's where my problem is; I want to group the first and second floors together and subtotal them and then have the remainder of the area listed next. Is there a way to do this or is it not possible. If anyone could give some instruction on this I'd appreciate it.

Thanks.

[Anthony.d]

Having trouble understanding ..what is the remainder?

First floor 10,000
Second Flr 5,000
Total 15,000

or

First Floor 10,000
Sub Total 10,000

Second Flr 5,000
Sub-Total 5000

Total 15,000

[bill.92885]

First Floor
Second Floor
Total

[Anthony.d]

Like the one attached?

[bill.92885]

Almost but I have a few more areas that are added to the end. Sorry I didn't eplain that last post.

First Floor
Second Floor
Total

Garage
Entry
Total UR

Patio

More like that.

[christo4robin]

In your Area Schedule view properties, Fields tab, put the field for Level into the Scheduled Fields box. Then, in Sorting/Grouping tab, Sort by Level and check the Footer box and then change the drop down list to Title and Totals (or whatever you choose). Then at the bottom of the dialog, check Grand Totals and again change the drop down list to whatever you'd like. You'll also need to go to the formatting tab and for the Area and Perimeter (if you're using it) fields, check the Calculate Totals box.

[bill.92885]

Thanks Christopher but that won't quite work as the garage and entry are on the first level. Unless you have a way of separating them out.

[doug.79572]

We do something similar for our residential projects

We use Gross Building type of area plan for the main floor, second floor, open space, etc.

Then we use the Rentable type of area plan for the other areas that we want calculated separately, such as garage, deck, verandah, etc. In the scheule properties, you can hav it total or not.

We end up with 2 schedules in the end, but it seems to be OK.

Hope this helps

[sbrown]

Create an order parameter(new parameter in your schedule) to sort by, then sort your list by level, assign everything to 1, then level 2 to to, then Garage to 3, etc. then re sort by order parameter, then hide the order parameter.