AutoCAD Architecture General Discussion

AutoCAD Architecture General Discussion

Reply
Contributor
12 Posts
0 Kudos
Registered: ‎12-07-2011
Post 1 of 3

Space evaluation: XLS Template also reading space property set data?

398 Views, 2 Replies
02-01-2012 09:24 AM

Hi,

after discovering zones and the space evaluation tool I wonder whether it is possible to customise the XLS output further by also reading out information from a property set attached to the space?

 

Scenario as follows:

The office standard is to have a property set attached to each space that defines a room number (which is the level ID plus a number, say G-01), the area and the space name.

We used to simply schedule the areas with a schedule table. That only gives us net rooms, no subtotals per department (or say per flat) and no grandtotal.

So we got as far as using zones grouping the spaces in each flat.

Now I need an area schedule XLT template that also displays the room number from the space's property set and the schedule grouped in a fashion that I get subtotals per flat (=my zones) in another column and a grandtotal.

Playing with the Space evaluation tool I seem to only ever get Room/ zone names and their areas.

Does anybody know a good tutorial expanding on this and creating XLT templates?

 

Thanks in advance, much appreciated.

 

Peter

Product Support
68 Posts
4 Kudos
Registered: ‎11-23-2006
Post 2 of 3

Re: Space evaluation: XLS Template also reading space property set data?

02-06-2012 02:40 AM in reply to: peter.menken

 

The Autodesk University Online Classes are a great resource for all kinds of tutorials. 

According to your problem description, you may find the following classes helpful:

 

AB114-5 Real-World AutoCAD® Architecture Schedule Use: How to Create Custom Schedules That Work for You and Your Company 2009 AutoCAD Architecture Lauren Stassi No Rating
AB118-2 Schedule Anything in AutoCAD® Architecture or AutoCAD® MEP, Part 1 2009 AutoCAD Architecture    Matthew Dillon  
AB122-1 Schedule Anything in AutoCAD® Architecture or AutoCAD® MEP, Part 2 2009 AutoCAD Architecture   Matthew Dillon  
AB327-2 Real-World AutoCAD® Architecture Schedule Use: Tips and Tricks to Make Schedules Work for You! 2010 AutoCAD Architecture     Lauren Stassi  
AB4026-L Schedule Anything in AutoCAD® Architecture or AutoCAD MEP 2011 AutoCAD Architecture    Matthew Dillon  
AB419-5L Schedule Anything in AutoCAD® Architecture or AutoCAD MEP 2010 AutoCAD Architecture    Matthew Dillon  
AB430-3 The Ultimate Door Schedule in AutoCAD® Architecture 2010 AutoCAD Architecture Paul Aubin  
AB4739 Code Analysis in AutoCAD® Architecture 2011


Holger Klöcker
Contributor
12 Posts
0 Kudos
Registered: ‎12-07-2011
Post 3 of 3

Re: Space evaluation: XLS Template also reading space property set data?

02-06-2012 10:26 AM in reply to: Holger.Kloecker

Thanks.

This is what I know so far, now I need some help on what I think is the next step: using zones for my area schedule and collecting data with the space evaluation tool and manipulating the Excel templates for that.

I basically want to end up having an area schedule with subtotals per flat and per floor and a grandtotal at the bottom.

I haven't found anything to that respect in the AU yet.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!