Itemized sheet list

[thomas.denney836893]

So I had a co-worker ask if there was a way to add a column to the sheet list that itemized the drawings, 1-xxx, where xxx= total number of sheets in the set. I said "Sure that should be easy enough to set-up, let me go back to my desk and grind on it for a few minutes and I'll come back when i have the steps figured out." I'm stumped. I can not accept that something this simple, remedial, adolescent...isn't done with a simple check of a box.

Anyone???

[jsteinhauer]

You'll have to do a dumb text parameter for Sheets. Grab the count and place it within that parameter field. This is an excellent use of working schedules. Sort by volume number, and don't itemize every instance. You'll also need to add this parameter to your title block family. So this is going to be a shared parameter.

Cheers,
Jeff S.

[dhurtubise]

1 - I stopped doing that kind of drawing sets.... 15 years ago. Too much work for the benefits(is there any)?
2 - If you really care about that use that tool http://www.kiwicodes.com/products/24-sheet-counter.html

[MikeJarosz]

Yo're right. I don't do this anymore either.

This is one of those old habits that doesn't serve any useful purpose anymore in this day of easy drawing generation by computer. In the days of hand drawing, a set rarely added new sheets because they were so hard to create, so you had 50 sheets throughout the like of the project. Nowadays, what's the point of having old sets around with different sheet counts every time you issue?

[jsteinhauer]

Hey guys,

Thomas is just trying to do something that is being asked of him. I guess there could be push back to the co-worker asking him to do this, to see if it a practice they wish to proceed with. Just because the rest of the industry has left this process in the past, doesn't mean it can't be done. Thomas is asking for the "How".

Thomas,

Were you able to follow my instructions? Do you have any additional questions? Did it solve your issue?

Thank you,
Jeff S.

[thomas.denney836893]

Yes, my co-worker is being required by the owner to itemize the sheet index. @jsteinhauer- no I was not able to follow your suggestion. And I also want to make sure everyone understands what I am asking as dhurtbise's suggestion in in fact not what I want. On my sheet that has my drawing index, the client simply wants each sheet in the set to be numbered as line items.


1. G-100- Cover Sheet
2. G-101- Sheet Index and Abbreviations
3. G-102- Symbols
.
.
.
23. A-100- First Floor Plan
23. A-101- Second Floor Plan
.
.
.
123. M-701-First Floor Mechanical Plan
etc.

So, All I want is to be able to add a column to the sheet list schedule and have it simple itemize all the sheets in the set 1 through however many sheets there are.

[dhurtubise]

Create a parameter, create a drawing list and filled in the number.
If you want to automate it you can look for excel export/import tool or Dynamo.

[jsteinhauer]

Thomas,

This is where a Revit / Excel tool will show it's worth. Depending on the number of sheets, it could pay for itself in one or two issuances of those sheets. Doing this manually in Revit will cause a brief pause between data entry as the database is updated. Since this only needs to appear in the sheet list and not on each sheet, please follow the steps below.

Open your Sheet List Schedule
Click on the "Edit" button for Fields
Select the "Add Parameter..." button
Create a Parameter Name "Sheet Line Item Number"
Select the appropriate parameter type, Text or Integer
Move parameter to top of the "Scheduled fields (in order):" list
Place sheet list on cover sheet or drawing list sheet.
Adjust column widths
Manually or via an Add-on, populate the appropriate value to new parameter either in each sheet or the sheet index schedule.
Repeat last step every time a new sheet is added to the sets.

Cheers,
Jeff S.

[thomas.denney836893]

@jsteinhauer- That's what I was able to do, but was hoping there was a way to have it update automatically every time a new sheet was added to the list. But, thank you for confirming I am not crazy and this is something that needs add-in magic to be automated, as opposed to it being just user stupidity.

[jsteinhauer]

Thomas,

If you can find the lowest paid Revit user, or the least liked, make them do the manual data entry. Make sure to give them a realistic expectation of time to complete their task. I would figure 15 seconds a sheet, once the schedule is setup. It could probably be done in 8-10 seconds per sheet or less. But that is a mind numbing task.

Cheers,
Jeff S.