Help Needed: Custom Area Schedule Format for Municipality Approval

[marksam97]

Hello everyone,

I’m working on a project in Revit and facing a challenge with the Area Plan Schedule.
In my country, the municipality requires the submission of floor area plans with a specific schedule format (see attached image).

The required format includes:

• Calculated Area (length × width = area).

• Total Area (sum of calculated areas).

• Deducted Area (specific portions to be excluded).

• Total Deducted Area.

• Final Total Area (calculated – deducted).

• Percentage of built-up area for the floor.

My problem is that Revit’s default Area Schedule does not produce this layout directly. I need a way to either:

1. Generate this schedule fully inside Revit (if possible).

2. Or use a workaround (Dynamo script, custom parameters, or other techniques) to achieve the same output.

Additional note: In the past, I used Sheet Link (DiRoots) which was great, but since it became paid, it’s too expensive for my current use. I’m not using any other plugin now. If anyone knows of an alternative tool or plugin that can synchronize Excel with Revit schedules (like Sheet Link, not just a simple Excel import), I’d be very thankful.

Has anyone dealt with a similar requirement? Do you recommend using Dynamo or another approach to automate this? Any advice, workflows, or tool recommendations would be really helpful.

Thanks in advance

[SteveKStafford]

I'm not aware of any 3rd party tools that are free that will do this, nor less expensive than the one you mentioned is. Your best bet is to build a Dynamo graph that can gather up the information you want to export to Excel for final formatting. Lower tech still is to create separate schedules in Revit to summarize the information you need and then export those to CSV files that you can import into Excel to reorganize into the final format. Seems to me you'd easily burn through the cost of the software in one afternoon of trying to build it in Dynamo.

An Area plan and schedule can't give you the total for one area that also includes other areas within it. Your area #1 will have it's overall area reduced by each deducted area you place inside it. You'd need to use different area plans based on different types and then build the schedules for each type.

Alternatively, you could use floors to define the "areas" by type (Calculated and Deducted). To isolate the floors from the rest of the building you could put them in a later phase (or earlier) or a design option perhaps. Then a schedule of each type would give you the summary of information you need to assemble in Excel. The deducted floor types can coexist within the same boundary as the larger calculated without altering the total area of the surrounding calculated floor.

The underlying issue in the report format you need from a Revit schedule is we can't tell it to add these and subtract those. Nor can we tell it to add these up and then subtract these from that other total. In database terms (such as MS Access) you need to create a report that references several queries to fill out the data. Revit schedules are a report "engine" based on a single query, more or less.

I mocked up a quick comparison of Floors (as area) vs Area, 2026 Revit file attached.