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

    Autodesk Revit MEP

    Reply
    Valued Contributor
    Posts: 87
    Registered: ‎12-07-2009

    Schedule Quantities

    164 Views, 6 Replies
    03-08-2012 03:56 PM

    Hello,

     

    I am trying to create a simple Quantity Schedule.  I want this schedule to total up the connected VA of each load classification in a project.  I have the fields selected correctly I think,  (Load Classification, Apparent Load) it's just when I go to Sorting/Grouping and uncheck "itemize ever instance" that my "Apparent Load" in the new schedule is blank.  Does anyone know how I can fix this?

     

    If I need to create a new parameter that totals up each VA in the different load classifications I would appreciate help on how to do that as well.  

     

    I've attached some screen captures.

     

    Thanks!

     

     

     

     

    Please use plain text.
    Valued Contributor
    Posts: 87
    Registered: ‎12-07-2009

    Re: Schedule Quantities

    03-08-2012 03:57 PM in reply to: Richie535

    Also I forgot to mention I created the schedule using "Electrical Circuits".

     

     

     

     

    Please use plain text.
    *Expert Elite*
    Posts: 1,905
    Registered: ‎08-28-2009

    Re: Schedule Quantities

    03-09-2012 07:12 AM in reply to: Richie535

    Well first off, if you total the load of all of the circuits, it's not going to be accurate because it will see ALL of the circuits, including Panel to Panel. Example:

     

    Receps 1000 ┐  (Schedule counts 3000)                              (Schedule counts another 3000)

    Lighting 1000 ├────────────────► Branch Panel ────────────────────► Distribution Panel

    Motors 1000  ┘                                                                        (Schedule total becomes 6000)

     

    I don't think there is a good way to accomplish this without having a separate schedule for each Category.

     

    If its not a moot point, now, your total looks like it may be counting the number of circuits. Under the Formatting Tab, select the load field and check the box for Calculate Totals.

    Corey D.                                                                                                                                                               LogoEE.png   AutoCAD user  Revit user
    ───────────────────────────────────────────────────────────────────────────────────────────
    ⁞|⁞ Please use the Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos functions as appropriate to further enhance the value of these forums. Thank you! ───────────────────────────────────────────────────────────────────────────────────────────
    Please use plain text.
    Valued Contributor
    Posts: 87
    Registered: ‎12-07-2009

    Re: Schedule Quantities

    03-09-2012 07:41 AM in reply to: Richie535

    Create a schedule for each load classification?

     

     

    Please use plain text.
    *Expert Elite*
    Posts: 1,905
    Registered: ‎08-28-2009

    Re: Schedule Quantities

    03-09-2012 08:01 AM in reply to: Richie535

    For each Category (i.e. Light FIxtures, Electrical Fixtures).

     

    An alternative would be to add a Project Parameter for Electrical Circuits named "Ignored by Schedule" as as yes/no instance parameter. You could then have the schedule ignore these circuits (via Filter tab), but you'll have to go and mark each and every circuit that is to be ignored. Loads of fun.

    Corey D.                                                                                                                                                               LogoEE.png   AutoCAD user  Revit user
    ───────────────────────────────────────────────────────────────────────────────────────────
    ⁞|⁞ Please use the Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos functions as appropriate to further enhance the value of these forums. Thank you! ───────────────────────────────────────────────────────────────────────────────────────────
    Please use plain text.
    Valued Contributor
    Posts: 87
    Registered: ‎12-07-2009

    Re: Schedule Quantities

    03-09-2012 08:12 AM in reply to: Richie535

    I really would like it to total each load classification.  Do you know if it would be possible to create a parameter that ignores certain circuits from certain panels?  Like you mentioned before it would double the load from a distribution panel, unless I told it to ignore that circuit by a parameter?

     

     

    Please use plain text.
    *Expert Elite*
    Posts: 1,905
    Registered: ‎08-28-2009

    Re: Schedule Quantities

    03-09-2012 08:21 AM in reply to: Richie535

    That would the the alternate method listed above. OR, maybe you can "Panel" to the schedule (Hidden Field) and create a filter to omit circuits with a Panel that "does not contain" [input a common naming component such as "DP"].

    Corey D.                                                                                                                                                               LogoEE.png   AutoCAD user  Revit user
    ───────────────────────────────────────────────────────────────────────────────────────────
    ⁞|⁞ Please use the Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos functions as appropriate to further enhance the value of these forums. Thank you! ───────────────────────────────────────────────────────────────────────────────────────────
    Please use plain text.