• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Architecture

    Reply
    Active Member
    peter.menken
    Posts: 10
    Registered: ‎12-07-2011

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

    242 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

    Please use plain text.
    Product Support
    Posts: 46
    Registered: ‎11-23-2006

    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
    Support Specialist
    Product Support
    Autodesk, Inc.
    Please use plain text.
    Active Member
    peter.menken
    Posts: 10
    Registered: ‎12-07-2011

    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.

    Please use plain text.