Forums >> General Discussion >> Wishlist >> Schedule fill in of multiple lines
|
|
active
Joined: Sat, Oct 25, 2003
411 Posts
![3.5 Stars: 5 Votes](/images/stars_3.5.gif) |
when filling in schedule fields (or pulling down to fill in) it would be nice to be able to select multiple lines/records and fill in all at once.
|
This user is offline |
View Website
|
![](images/spacer.gif) |
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 396 Votes](/images/stars_3.5.gif) |
One of the great powers of revit is the schedule. We often make a junk schedule to manipulate data without messing up a sheet placed schedule. Just copy your schedule, then add columns as you need to to filter/sort so that all like items are on one line (don't show every instance), then change the data. Do this as often as you need to.
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Sat, Oct 25, 2003
411 Posts
![3.5 Stars: 5 Votes](/images/stars_3.5.gif) |
If you have a room schedule, you may have a department with many rooms. All get (for example) carpet as the floor finish... hundreds of times. You have to pull down that choice for each room, when you should be able to do so just once. I think your scenario wouldn't help there. Or a hardware schedule. etc... where ever you are scheduling actual objects/families in the project, would a junk schedule help? A work around is to create schedule keys. that can become awkward because all fill ins have to be identical, you can't change any of them. (this room has wall/floor/ceiling the same but different baseboard, for example). i have ended up with a schedule key types in a project which is a bit hard to track. you can kind of work around by picking all the families from the plan (and filtering) then modifying the family attributes, but that's kind of imprecise.
|
This user is offline |
View Website
|
![](images/spacer.gif) |
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 396 Votes](/images/stars_3.5.gif) |
No, sorry but you are wrong. Your example is exactly where it works. Lets say you have 10 offices and a conference room and they are all in a department called sales and you want them all to have the same carpet. Simply make sure department is a column in your junk schedule, sort your schedule by department - don't show all instances... and all of the sales department rooms will be on one line.... The room name will now show blank because you have different names in each room... go to the floor finish and mark it with the carpet you want. Viola - all done in tyhe main schedule
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Sat, Oct 25, 2003
411 Posts
![3.5 Stars: 5 Votes](/images/stars_3.5.gif) |
You are right, that is helpful. that scenario assumes all of a certain field results in the same fill in at another field. there are alot of cases where one wants to pick selected multiple lines (which follow no particular rule) and just fill in the same info in those cells. Just a wish.
|
This user is offline |
View Website
|
![](images/spacer.gif) |
active
Joined: Sat, Oct 25, 2003
411 Posts
![3.5 Stars: 5 Votes](/images/stars_3.5.gif) |
one more question (since you are a schedule-meister!). in r2009 you could save a schedule (file/save to library/save views) then load it from a folder (file/insert from file/views). We have all kinds of schedules with calcluations etc that are worth re-using. in r2010 you save by (save/saveas/library/view). how do you load it? can't find it.
|
This user is offline |
View Website
|
![](images/spacer.gif) |
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 396 Votes](/images/stars_3.5.gif) |
Right... if you don't have something that is common to sort by then you can't do this. The trick is to try and have something common in your project wherever possible. This is what Room Styles is good for. You can have rooms assigned to room styles and all of your finishes are filled in from the get-go.... or whenever the room styles are changed. But for really unique items... sorry - you have to do them one at a time - but you do have your pull-down.
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Sat, Oct 25, 2003
411 Posts
![3.5 Stars: 5 Votes](/images/stars_3.5.gif) |
I found it... insert/insert from file/insert views.
|
This user is offline |
View Website
|
![](images/spacer.gif) |
active
Joined: Sun, Apr 25, 2004
1207 Posts
![4.5 Stars: 25 Votes](/images/stars_4.5.gif) |
In addition to developing multiple schedules for input (I call them working schedules rather than junk) there are a couple of other options. 1. You could develop a "schedule key" which is Revit's way of doing a "look-up" table in a database. This allows you to pre-define finishes for example per room type and assign that room type once to a room and all finishes update. 2. Another overlooked use of schedules is to select multiple rows in a schedule, then while they are still selected switch to a floor plan view. The rooms or objects you selected in the schedule view will still be selected and you can now go to their instance properties and change them all at the same time.
-----------------------------------
Tom www.reviteer.com http://twitter.com/Reviteer |
This user is offline |
View Website
|
![](images/spacer.gif) |
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 396 Votes](/images/stars_3.5.gif) |
Tom... I too call them working...but junk was easier... Your #2 tip sounded very good.... but how do yo select multiple rows in a schedule?
|
This user is offline |
|
![](images/spacer.gif) |
|
active
Joined: Sun, Apr 25, 2004
1207 Posts
![4.5 Stars: 25 Votes](/images/stars_4.5.gif) |
To select multiple rows you need to click and hold the mouse button and highlight the rows. All the rows need to be adjacent for this to work as you cannot skip rows to select. This method works best if you have a working schedule sorted by room name for instance and you want to select all rooms named the same and change their whatever to x. It is the down and dirty way in place of a key schedule. I teach it to those not ready for the key schedule concept yet and sometimes use it myself in the heat of battle.
-----------------------------------
Tom www.reviteer.com http://twitter.com/Reviteer |
This user is offline |
View Website
|
![](images/spacer.gif) |
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 396 Votes](/images/stars_3.5.gif) |
Darn ... you had me salivating for a minute there.....
|
This user is offline |
|
![](images/spacer.gif) |
active
![jarosa Avatar](user_avatar/53278.jpg)
Joined: Mon, Feb 18, 2008
251 Posts
![4 Stars: 5 Votes](/images/stars_4.gif) |
Tom Dormer...
I've been a reviteer since 2009. Starting to do room schedules. Your multiple rows, highlight in schedule is brilliant!!
Post from 2004 saves the day in 2024. Twenty freakin years later. Cheers
|
This user is offline |
View Website
|
![](images/spacer.gif) |
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 396 Votes](/images/stars_3.5.gif) |
There is still valuable information in many of our old posts. Wish Tom was still posting.
|
This user is offline |
|
![](images/spacer.gif) |
![](images/spacer.gif) |