Sheet Array with 1 HELP!

[mattpick10]

Please can some one look at the attached family and give me some tips on how to fix it. The family is steel sheets where you choose the length and it will tell you how many sheets are require ( sheets are 1000mm wide ) however if the length is less than 1500mm the family will break and gives an error of Parameter sheet count has an invalid value . The family is made up of has singe sheet and then another instance which is the arrayed sheets. I want to be able to have a cladding length of say 500mm and a sheet count of 1, if the cladding length goes over 1000mm the the sheet count will change to 2. 

Thanks in advance

Matthew

[ToanDN]

huh what 'bout this:
6.4 meters = 6.4 panels or 7 uncut panels
3.2 meters = 3.2 panels or 4 uncut panels
but in reality you only need 10, not 11 panels

[barthbradley · Accepted solution]

I'm not following you, @ToanDN .  

...maybe "Number of Uncut Panels" is a bad name for the Parameter.  

...how about "Number of Cladding Sheets", as per the OP's post?  

[ToanDN]

doesn't matter what you call them, you don't cut a one meter sheet to get a 20 cm stripe then throw 80 cm away.

[barthbradley]

If I screwed up, I'll gladly take a nap. I just don't see what you are talking about.  Can you post a Screenshot pointing out the error/flaw?   

[barthbradley]

Nevermind. I see where I screwed up.  Sh*t! Nap time.  

[ToanDN]

Nothing is wrong with your formula, mathematically speaking. But if one brings it to a shop showing they need 11 panels for a wall of 6.4 meters and a wall of 3.2 meters then they the shopper will laugh at you for give them more money that they worth.

Here is an example using Imperial system if that is easier. Let's say you are installing 4x8 GWB on two walls, one is 5x8, the other is 9x8. Don't tell me you need 5 sheets of 4x8 GWB.

[barthbradley]

Actually, the formula for "Cut Panel Width (Array Spacing)" is totally wrong. Doesn't factor in that the MAX Panel Width cannot exceed the Uncut Panel Width.  Basically, the family should include an End Panel that fills in the leftover space.  In my example using 86'-0' Overall Length, there would be eight (8) 10'-0" wide panels in the Array and a separate 6'-0" wide End Panel.  Easy to correct though  -- after a nap.  he, he. 

...or, in lieu of End Panel, a MAX 10' panel, which is probably more to your point.

[barthbradley]

I think this works...

Feel free to critique, @ToanDN.  

[ToanDN]

See modified family placed in project.  

[barthbradley]

 2019 version attached.  

[bin]

Sorry, I'm late, not to fixe the issue, only to explain to OP what happened there:

1. at 1500, 1500/1000=2, at 1499, 1499/1000=1. to fix it, and roundup()

2. you cant have an array with 1, even when it is hidden. So make it 2.

Also, you can simplify some formula as well. Good luck.

[barthbradley]

Dang @bin! Thanks a lot. I thought this thread was behind me, but you caused me to reexamine my last file. The SOB broke to smithereens.  ARRGH! 

If you feel so inclined, check out the attached revised version and tell me what you think.  

If you break it, you own it -- and I'm giving up for good. 😉

[bin]

Don't have 2019, sorry about that.

1. I was having a bit of trouble to understand that formula, so I changed that and mike it a bit simpler.

2. In the original family, the extra 1mm is used so it will not fail the extrusion when it is 0mm left for the end panel. But this will cause the whole family 1mm longer than the overall length.  So I just changed them a little bit so the end panel stays at 1mm, but hidden.

3. In your original family, the visibility of the single panel is not(array), which means it will always visible when the overall length is less than 2* panel width. Not sure if this is the intention, I just changed it...

4. I think some of the parameters should be Type instead of Instance.

Other than that, nice work. 🙂

I have attached the 2020 version.

[barthbradley]

Well @bin, if you are going to grade it like a test, then you should really be grading the RVT that I posted today in Message #32. That one flexes beautifully and flawlessly -- in fact, so much so, that  I am thinking of making a few more of them to give to friends and family as Christmas gifts  this year.   

Here it is for you. Keep it. I think it may go double-platinum which would make this original worth a lot of money.  I'm starting a 57-city, 44-country tour next month to promote it.    I'm thinking it could propel me to super-stardom and maybe even get me into the Autodesk Hall of Fame.   Fingers-crossed.  

[bin]

Sounds good. Good luck and make sure you wear masks.

[mattpick10]

Barth

Genius!

That works a treat 

Thanks for helping out once again