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

Thread: Data Entry in Room Schedules

  1. #1
    AUGI Addict MikeJarosz's Avatar
    Join Date
    2015-10
    Location
    New York NY
    Posts
    1,497
    Login to Give a bone
    0

    Default Data Entry in Room Schedules

    We have a GSA project that requires extensive non-graphic data entry. The room parameters are set up in a GSA furnished template, so that's not a problem. However, repetitive entries in Revit schedules falls far short of Excel-like performance. For example, I have 25 rooms in a row that get "01" as their property. I would like to highlight all 25 and type 01 just once. Revit doesn't seem to allow that.

    Does anyone know more about this? There are hundreds and hundreds of rooms in this project.

  2. #2
    Certifiable AUGI Addict
    Join Date
    2004-05
    Location
    St. Louis, Missouri
    Posts
    3,135
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    Sounds like a job for a 3rd party app like Whitefeet Tools, Trelligence Affinity for Revit or Ideate BIM Link.

  3. #3
    Certified AUGI Addict patricks's Avatar
    Join Date
    2004-06
    Location
    Memphis TN area
    Posts
    7,048
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    Yep, unfortunately this sort of entry just isn't possible in Revit schedules. You can't even copy/paste and use the arrow key to quickly paste it in (used to be able to). Oh no, you have actually click in each and every cell before you can even Ctrl-V paste the data in there.

  4. #4
    Early Adopter sbrown's Avatar
    Join Date
    2003-05
    Location
    Coast to Coast
    Posts
    4,440
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    I try to find common ways to "collapse" the schedule to enter data one time into multiple rows, you do this via sorting and grouping and not itemizing.
    Scott D. Brown, AIA
    Senior Project Manager | Associate

    BECK

  5. #5
    Certifiable AUGI Addict Dimitri Harvalias's Avatar
    Join Date
    2015-12
    Location
    Vancouver, BC Canada
    Posts
    3,753
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    Cliff's suggestion is probably a better long term approach if you do this sort of thing frequently.
    You can go a long way to getting this done by using plans in conjunction with schedules.
    I'm guessing that rooms with common properties share other commonalities such as department, location on a floor area, occupancy etc.
    If that's the case, open a plan view and tile it with your schedule.
    Use the plan to select rooms with a major common property, let's say department.
    Window select the rooms and filter so you you only have room objects.
    The properties palette should allow you to change parameters for all these rooms at once.
    Change all the common parameters you need to.
    Let's say you now need to change the finishes for all rooms that have a common FUNCTION parameter. You can 'collapse' your schedule so it will only show a single instance of all rooms with a common parameter. Sort and group by the common parameter and then uncheck the 'show all instances' check box. You'll now be able to alter parameter values for every occurance of those rooms.
    It sounds cumbersome but as you add data the available properties to group and sort by make it pretty quick.
    I'll try to upload a video to demonstrate this if it's not clear enough.

    (Scott appears to be able to express himself more more concisely)
    Last edited by Dimitri Harvalias; 2012-04-10 at 08:58 PM. Reason: Scott is too succinct!

  6. #6
    AUGI Addict MikeJarosz's Avatar
    Join Date
    2015-10
    Location
    New York NY
    Posts
    1,497
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    Thanks everyone. The ideal solution is native two-way Excel compatibility in Revit. Lacking that, there are some 3rd party products to check out. CTC in Minneapolis has an interesting Revit-Excel link. I was hoping there was some hidden trick I didn't know about.

    If AD is serious about the I in BIM, they should add some advanced non-graphic data entry tools.

    Right now, there is an intern in NYC cursing Revit room schedules

  7. #7
    Certifiable AUGI Addict Dimitri Harvalias's Avatar
    Join Date
    2015-12
    Location
    Vancouver, BC Canada
    Posts
    3,753
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    Quote Originally Posted by MikeJarosz View Post
    Right now, there is an intern in NYC cursing Revit room schedules

    For me it was hand drafting reflected ceiling plans for 25,000sf of 2x4 T-bar ceilings in Safeway stores! At least we had the sense to draw on the reverse side of the mylar floor plan. Ahhh, those were the days.

  8. #8
    AUGI Addict MikeJarosz's Avatar
    Join Date
    2015-10
    Location
    New York NY
    Posts
    1,497
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    At least you had double sided mylar. We had the shiny back stuff because the chief draftsman (the guy with the green visor) liked to bubble revisions with a china marker on the back!

  9. #9
    AUGI Addict MikeJarosz's Avatar
    Join Date
    2015-10
    Location
    New York NY
    Posts
    1,497
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    Found one trick that helps! (thanks to Sean at the CAD Technology Center in Minneapolis)

    If you have a field in a schedule that is the same for every room you can enter them all at once. I had one such field. The GSA requires a room type. This is an entirely new building, so the room type for every Revit room is 01, the GSA code for new construction. To do it:

    Create a new room schedule with just one field, the one you want to populate. They should all be empty.
    sort the list, make sure you turn off "itemize every instance". You should have just one line in the schedule.
    In that one line type anything "@$@$&(^&*^"
    Turn "itemize every instance" back on
    The entire list should now be populated

    Be careful! Make sure you save before you try this. It crashed Revit the first time I tried it, but later it worked great!! This might be able to do sections of the schedule by adding more fields and sorting into groups. I haven't tried deletions, but I bet that will work too!

    Just make sure you save first!!!

    edit: [ deletion works too!!!! ]
    Last edited by MikeJarosz; 2012-04-11 at 09:15 PM. Reason: new info

  10. #10
    Revit Forum Manager Steve_Stafford's Avatar
    Join Date
    2001-12
    Location
    Irvine, CA
    Posts
    7,567
    Login to Give a bone
    0

    Default Re: Data Entry in Room Schedules

    That's what Scott was getting at with his "collapse" a schedule using common criteria. If you want all of "something" to be editable as one row you need to sort by "something" and then un-check "Itemize every Instance"

Page 1 of 2 12 LastLast

Similar Threads

  1. Ceiling data in Room schedules
    By tristram.taylor in forum Revit Architecture - General
    Replies: 8
    Last Post: 2018-05-30, 06:17 PM
  2. Rebaring by data entry in member's property
    By ljupadhyay in forum Revit Structure - Tips & Tricks
    Replies: 0
    Last Post: 2011-07-12, 06:08 PM
  3. Schedule Data Entry
    By wadeshuey in forum Revit Architecture - General
    Replies: 7
    Last Post: 2010-02-12, 08:33 AM
  4. Automation - 2 data entry problems
    By avinash00002002 in forum VBA/COM Interop
    Replies: 2
    Last Post: 2006-05-18, 07:54 AM
  5. 8.1/N - Import Excel room data to Schedules - O
    By dbaldacchino in forum Revit Architecture - Wish List
    Replies: 1
    Last Post: 2006-01-19, 07:02 PM

Tags for this Thread

Posting Permissions

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