VellumDesignBuild Posted November 21, 2020 Share Posted November 21, 2020 Does anyone know how to get a pocket door to account for the pocket portion of the door in the door schedule? Currently when I add a simple pocket door into a wall, the door schedule only accounts for the door slab, door jambs, and shim gaps... this is fine for swinging doors, but not pockets, since the RO width needs to account for the pocket, which is usually the door width +1 inches. For example a pocket door with a 2'-6" x 8'-0" door slab should have an RO width of 0.25 shim gap + 0.75 jamb +30 door slab +31 pocket = 62" total RO width. I have the a similar issue for the RO height, but I can account for the overhead track by using a z offest in the theshold dialog. Still... I wish there was a better and more accurate way to do that. For a pocket door, the RO hieght should be about 4" greater than the door slab size. Any help would be greatly appreciated. Software Versions VW2021 and VW 2020 Quote Link to comment
Guest SMannVW Posted November 24, 2020 Share Posted November 24, 2020 I would use an IF function in the rough opening columns of the door schedule database headers to calculate those values. If it's a pocket door the function will return the calculated dimension, and if it's any other door it will return the rough opening dimension. More information about worksheet functions in help guide:https://app-help.vectorworks.net/2021/eng/index.htm#t=VW2021_Guide%2FWorksheets%2FWorksheet_functions.htm&rhsyns= Worksheets on the Vectorworks University:https://university.vectorworks.net/mod/page/view.php?id=631 Here are a couple screenshots with samples of pocket door worksheet formulas: Quote Link to comment
VellumDesignBuild Posted January 3, 2021 Author Share Posted January 3, 2021 (edited) Thank you Scott, I tried this method and the schedule did not populate correctly. I get #NAME? Any ideas? Edited January 3, 2021 by VellumDesignBuild Quote Link to comment
Pat Stanford Posted January 3, 2021 Share Posted January 3, 2021 It needs to 'Door'.'Config', not 'Door'.'Configuration' You can track this down by either using the Formula Generator in a database header row. Use a single part of the formula at a time and see exactly what ends up in the formula. Alternatively, take a look at this thread about a script that will create a worksheet showing all of the possible fields of a PIO. 1 Quote Link to comment
VellumDesignBuild Posted January 4, 2021 Author Share Posted January 4, 2021 Thank you, Pat. That edit cleared the error out of the formula, but at first, I could not get the equation to recognize which doors were pocket doors. I suspected that the configuration was not "pocket" since none of my pocket doors end up with different values. I tried 'slider' to see if the equation works and it did, so I knew the issue had to be with the name of the door type. I tried 'pocket.simple', 'pocketsimple' just guessing as to what the correct name is for that door type, and realized that I needed to include the space between "pocket simple' As easy as that was, it took me quite a bit of head-scratching to get it to work. The good news is that I also now have the POI script you created and shared, and that is working perfectly. The script did not drill down into the deeper aspects of the door configuration types, but does provide a huge list of the POI info needed for worksheets. All in all, I want to thank you for your help and time. Have a happy new year. @SMannVW thank you as well, you pointed me in the right direction. I think that the Mac vs PC criteria are slightly different, which is why your formula worked for you. Quote Link to comment
VellumDesignBuild Posted December 14, 2021 Author Share Posted December 14, 2021 Okay more on this item. The formula above works fine for pocket simple doors, but how do I add a 2nd rule for pocket bi-part? I basically want the same rule to apply to standard pocket and biparting pocket doors. =IF('Door'.'Config'='Pocket Simple', ('Door'.'ROWidth'+'Door'.'Width'+1/12), 'Door'.'ROWidth') How would I modify this formula? Quote Link to comment
Pat Stanford Posted January 14, 2022 Share Posted January 14, 2022 Something like: =IF('Door'.'Config'='Pocket Simple', ('Door'.'ROWidth'+'Door'.'Width'+1/12), IF('Door'.'Config'='POCKET BIPART', (width you want for bipartisan), 'Door'.'ROWidth')) This is called Nested IF Statements. If the formula is something like: IF (condition, What to do if the condition is true, What to do if the condition is false) Then normally the second IF should go into the FALSE portion of the first IF. Quote Link to comment
VellumDesignBuild Posted June 22, 2022 Author Share Posted June 22, 2022 Hello Pat, thank you on for the help on this. I finally got it to work. Your posts on other threads is what made me realize that I was not nesting my statements correctly. Sorry for the delayed thank you.👍 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.