Donate Now Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

Results 1 to 10 of 10
Like Tree4Likes
  • 3 Post By Bjorn_K
  • 1 Post By tuekappel

Thread: Renumber sheets while maintaining x.number suffixes?

  1. #1
    Member PatrickGSR94's Avatar
    Join Date
    July 7, 2017
    Location
    Hernando, MS
    Posts
    491
    Current Local Time
    06:34 AM

    Renumber sheets while maintaining x.number suffixes?

    I have over 100 sheets that I need to renumber, but several groups of sheets have a number with a x.1, x.2 suffix and so on. I'd like to renumber the sheets while maintaining those number suffixes. Is that possible with Dynamo or macros?

  2. #2
    Member tuekappel's Avatar
    Join Date
    February 6, 2012
    Location
    Frederiksberg, Denmark
    Posts
    334
    Current Local Time
    11:34 AM
    Could you give an example of 10 sheet numbers, old and new name, I'd like to give it a try

    Sendt fra min ONEPLUS A5000 med Tapatalk

  3. #3
    Forum Addict elton williams's Avatar
    Join Date
    December 7, 2010
    Location
    Gold Coast
    Posts
    2,617
    Current Local Time
    09:34 PM
    It would be really easy with Dynamo to export/import via excel.

  4. #4
    Member PatrickGSR94's Avatar
    Join Date
    July 7, 2017
    Location
    Hernando, MS
    Posts
    491
    Current Local Time
    06:34 AM
    So I might have sheets:

    117
    118
    119.1
    119.2
    120.1
    120.2

    and I need to stick a sheet in after 117, so all the sheet numbers after 117 need to increase by one, but the .1 and .2 needs to stay the same, so 119.1 becomes 120.1 and 120.2, and 120.1 becomes 121.1 and 121.2 and so on.

  5. #5
    Forum Addict elton williams's Avatar
    Join Date
    December 7, 2010
    Location
    Gold Coast
    Posts
    2,617
    Current Local Time
    09:34 PM
    Quote Originally Posted by PatrickGSR94 View Post
    So I might have sheets:

    117
    118
    119.1
    119.2
    120.1
    120.2

    and I need to stick a sheet in after 117, so all the sheet numbers after 117 need to increase by one, but the .1 and .2 needs to stay the same, so 119.1 becomes 120.1 and 120.2, and 120.1 becomes 121.1 and 121.2 and so on.
    Have a look at pyrevit, it has a function to increment sheet numbers, no excel needed.

  6. #6
    Member PatrickGSR94's Avatar
    Join Date
    July 7, 2017
    Location
    Hernando, MS
    Posts
    491
    Current Local Time
    06:34 AM
    Oh well, I went ahead and just renumbered the sheets manually. 100 sheets only took about 5 minutes to renumber in a schedule, starting at the bottom and going up, increasing each sheet number by 2 so that I could add in 2 sheets.

  7. #7
    Member Bjorn_K's Avatar
    Join Date
    April 8, 2011
    Location
    Rotterdam, Netherlands
    Posts
    319
    Current Local Time
    01:34 PM
    This is how it looks in the player.


    Renumber sheets while maintaining x.number suffixes?-insertsheet.png

    This should do it, fun little exercise to quickly build. Only needs a single Clockwork and Rhythem node. Rest is OOTB. Dynamo 1.3.3, Revit 2018.3

    If you want my Revit test file give me a shout, just a little to big for the upload limit.
    Attached Files Attached Files
    tuekappel, cellophane and amoursol like this.

  8. #8
    Member PatrickGSR94's Avatar
    Join Date
    July 7, 2017
    Location
    Hernando, MS
    Posts
    491
    Current Local Time
    06:34 AM
    ugh I need to learn how to do that. 15 year Revit veteran here, but I know zilch about Dynamo.

  9. #9
    Member tuekappel's Avatar
    Join Date
    February 6, 2012
    Location
    Frederiksberg, Denmark
    Posts
    334
    Current Local Time
    11:34 AM
    Quote Originally Posted by PatrickGSR94 View Post
    Oh well, I went ahead and just renumbered the sheets manually. 100 sheets only took about 5 minutes to renumber in a schedule, starting at the bottom and going up, increasing each sheet number by 2 so that I could add in 2 sheets.
    Less than an hour after you posed your question, you solved it by hand.

    I love a good challenge, but next time: please let us know if you're really stuck, or you are just venting frustration......

    -People here actually do hard work to help each other out, please respect that.
    Yna_Db likes this.

  10. #10
    Member PatrickGSR94's Avatar
    Join Date
    July 7, 2017
    Location
    Hernando, MS
    Posts
    491
    Current Local Time
    06:34 AM
    say what? Come on I was in a time crunch and needed to get it done. But I'll look into this further for future renumbering needs.

Similar Threads

  1. Replies: 0
    Last Post: July 2nd, 2018, 02:45 AM
  2. Replies: 0
    Last Post: July 2nd, 2018, 02:15 AM
  3. Replies: 0
    Last Post: July 2nd, 2018, 02:15 AM
  4. Replies: 0
    Last Post: March 21st, 2017, 01:45 AM
  5. Replies: 20
    Last Post: November 23rd, 2015, 08:31 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
  •