Exterior Siding Sqft in a Schedule

[LegacyChief]

Hello all!

I've been tasked by my organization to show the exterior siding net sqft totals (cutting around doors and windows) in schedule format. I've tried and tested a few methods with little to no luck. 

1st thought was to use a Wall Schedule, but there are no default options for area.

2nd thought was to use a custom schedule with wall material regions and selecting area, surface as an available column. (This only shows GROSS sqft, not NET)

Using Google Gemini (AI) for assistance, I tried creating a custom field with a macro but continued to get either the exact text from the macro (even with "Format as Number" checked), or "ERROR"

There are instances where we would plan for two different material types, usually a stone wainscot as a pony wall, and would want this separated as well. 

Any guidance on this would be greatly appreciated!

 

[joey_martin]

The information lives in the materials list but, while in elevation camera create a polyline and aim that polyline to a custom schedule. 

[LegacyChief]

Hey Joey, 

Thanks for the quick response. Just tried your polyline method for this particular project and that works. 

Long term were hoping for more automation. Being able to use a template that is set up with the schedule already on the layout and updating automatically as we draw our walls in (similar to how a door schedule works). 

Thought there might be a macro that could be used to get this automation set up for long term goals.