See the top rated post in this thread. Click here

Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Split the areas in Schedule

  1. #1
    100 Club Mark Vorstenbosch's Avatar
    Join Date
    2005-03
    Posts
    155
    Login to Give a bone
    1

    Default Split the areas in Schedule

    hey Reviteers

    I need to split my areas in my schedule, meaning my rentable area should be in it own Column, the outside area in there own column & last but not least the store area should be in it's own column.

    Here is a excel sheet of what I need to do.

    Hope you can help.
    Attached Files Attached Files

  2. #2
    Certifiable AUGI Addict dhurtubise's Avatar
    Join Date
    2005-07
    Location
    Somewhere in the BIM world
    Posts
    3,792
    Login to Give a bone
    0

    Default Re: Split the areas in Schedule

    I don't see the issue

  3. #3
    100 Club Mark Vorstenbosch's Avatar
    Join Date
    2005-03
    Posts
    155
    Login to Give a bone
    0

    Default Re: Split the areas in Schedule

    I don't know how to get the areas in there own columns.
    As I showed in the excel file.

  4. #4
    Certifiable AUGI Addict dhurtubise's Avatar
    Join Date
    2005-07
    Location
    Somewhere in the BIM world
    Posts
    3,792
    Login to Give a bone
    0

    Default Re: Split the areas in Schedule

    Can you post the file ?

  5. #5
    100 Club Mark Vorstenbosch's Avatar
    Join Date
    2005-03
    Posts
    155
    Login to Give a bone
    0

    Default Re: Split the areas in Schedule

    Sorry can not post the file the file is too big.

  6. #6
    100 Club Mark Vorstenbosch's Avatar
    Join Date
    2005-03
    Posts
    155
    Login to Give a bone
    0

    Default Re: Split the areas in Schedule

    But what I can do for you guys is make up a smaller file.
    Ok done
    Attached Files Attached Files

  7. #7
    I could stop if I wanted to Mike Hardy-Brown's Avatar
    Join Date
    2004-09
    Location
    Melbourne, Australia
    Posts
    282
    Login to Give a bone
    0

    Default Re: Split the areas in Schedule

    Hey Marky Mark

    Why don't you use a Yes/No Parameter to define what is outside, and what is inside.
    Have your area col behind that.
    The easiest way is to just duplicate the schedule, add a filter (1 for outside) and another schedule (for inside)
    Makes life easier, and it would be clearer as 2 schedules.

    (I see Willem owns shop 4 from the XL spreadsheet )

  8. #8
    Member
    Join Date
    2005-08
    Posts
    6
    Login to Give a bone
    0

    Default Re: Split the areas in Schedule

    Thanks Mike!
    That's what I also told Mark to do..

  9. #9
    Active Member swissclive54638's Avatar
    Join Date
    2003-10
    Location
    London
    Posts
    50
    Login to Give a bone
    2

    Default Re: Split the areas in Schedule

    Sorry it's taken a while to answer this, but it took a little bit of working out.

    Basically, all you need to do is add a "location" instance parameter to your room tag. Make sure it's a number, and give your outside areas a value of 1, inside a value of 2 and stores a value of 3.

    Go to your schedule fields and add the location parameter. Then add 3 calculated values; outside area, inside area and store area. In each one, set the type to "Area" and add the conditional formula "if(location = 1, Area, 0 m²)" for the "outside area", if(location = 2, Area, 0 m²) for the "inside area" and if(location = 3, Area, 0 m²) for the "stores".

    What you'll get is a schedule with 3 area columns as attached.

    If you don't want to see the Area or Location columns, just change them to hidden.

    May not be exactly what you're after, but hopefully it helps!
    Attached Images Attached Images

  10. #10
    100 Club Mark Vorstenbosch's Avatar
    Join Date
    2005-03
    Posts
    155
    Login to Give a bone
    1

    Default Re: Split the areas in Schedule

    Thanks that works.
    Enjoy the weekend.

Page 1 of 2 12 LastLast

Similar Threads

  1. adding areas on schedule
    By ray salmon in forum Revit Architecture - General
    Replies: 4
    Last Post: 2009-06-03, 09:53 PM
  2. schedule areas of linked buildings
    By steedlei in forum Revit Architecture - General
    Replies: 1
    Last Post: 2008-11-19, 01:35 PM
  3. Schedule of areas
    By Wagurto in forum Revit Architecture - General
    Replies: 3
    Last Post: 2008-02-28, 05:45 PM
  4. Schedule trickery - How do I get an average of areas?
    By PeterJ in forum Revit Architecture - General
    Replies: 6
    Last Post: 2006-02-12, 09:49 PM
  5. Totalling areas in schedule
    By beegee in forum Revit Architecture - General
    Replies: 6
    Last Post: 2003-07-17, 03:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •