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

[barthbradley]

Have you considered doing this as a Curtain Wall instead?  FWIW.

Anyways, open the Array Family in the attached Project and you'll see how it is done.

[mattpick10]

Sorry pressed solved by accident. No I haven’t considered curtain wall. You helped me with the filter array a couple of weeks ago which works a treat so I tried to apply the same principle of adding visibility parameters to the arrays but just can’t get it to work. The weird thing is all the other fields are correct. For example if I change the length to 1200mm it gives me the correct data but just won’t let me have a sheet count of 1. Even though the A1 parameter changes to 1 and hides the array 

thanks for the quick response 

[barthbradley]

Are you the Baffle Filter guy?  

[ToanDN]

You should really have used curtain wall instead of arraying in the family with extra hassles of adding visibility and formula to overcome the 1 unit problem.

[mattpick10]

yes 

I tried to replicate what you did and it all works to a point but must be missing something as it won’t let me have a sheet count of 1

[mattpick10]

Maybe but would the not cause problems what I try to overlay it on to a wall. The sheets are for kitchen splash backs. I also have my template set up to schedule the sheets

[ToanDN]

---

@mattpick10 wrote:

Maybe but would the not cause problems what I try to overlay it on to a wall. The sheets are for kitchen splash backs. I also have my template set up to schedule the sheets

---

No overlaying a curtain wall on a wall would not cause any issue.  Simply set the curtain wall type to not automatically embedded, and choose Disallow Join when you draw it.  Curtain panels can be scheduled normally.

[mattpick10]

Would prefer to just fix the family I already have it must be a simple fix as it is pretty much working

[barthbradley]

---

@mattpick10 wrote:

Sorry pressed solved by accident. 

---

What do I need to do to get that credit back?  What exactly do you want this Family to do -- and what are the user-entered parameter values?  

Still think Curtain Walls would be the best solution all around though.  

[mattpick10]

Hi Barth

just want to be able to input a length for example the wall cladding comes in Sheets 1000mm wide but can be cut down to any width. So a wall that’s 6500mm long would have a sheet count of 6.5 sheets. However if there is a return wall that’s only 500mm long then that would still be 1 sheet cut to 500mm. The family does all this upto 1500mm but gives an error for anything less. As I have said before I am not great with if statements but am sure it a simple fix as it all seems to work ok until the cladding length drops below 1500mm which is weird?

thanks in advance

matthew

[barthbradley]

Okay, first of all, an Array can't have 6 1/2 elements. Second, all the elements in the Array are identically sized. So, what do you what Revit to do at 6500?  What do you want Revit to do at 1499?   

[mattpick10]

ok

So example 1

Cladding length 6500mm 

Sheet Count 7

Number of cladding sheets 6.5 ( Cladding length / 1000mm )

All above works fine.

Example 2

Cladding Length 1500mm

Sheet count 2

Number of cladding sheets 1.5 ( Cladding length / 1000mm )

All above works ok

Example 3

Cladding Length 900mm 

Sheet Count 1

Number of cladding sheets 0.9

Above gets an error: Parameter Sheet Count has an invalid value

So would like to fix above to read

Sheet Count 1

Number of cladding sheets 0.9

Not sure why it wont allow anything below 1500mm 

 

 

hope that all make sense 

[barthbradley]

That doesn't answer my question. I understand where your family is failing. I can see for myself and I understand perfectly well why it's failing.  I can predict the failure by just looking at the Parameters and Formulas.  

For instance: your Spacing Parameter is not Cladding Length divided by Sheet Count, and Sheet Count isn't arrived at by dividing Cladding Length by "1000".  What's this fixed number all about anyways?   The Number of Panels in the Array is contingent on the Width of the Panel arrived at by evaluating the Cladding Length, which means the Panel Width could be 500 or 1000 or any Width in-between. 

Just explain to me like you were explaining it to a worker on the job site - and don't reference your Revit Family.   

[mattpick10]

Ok

so we measure the length of the wall to be clad in the stainless steel sheets say 5540mm. We would then take 5 standard size sheets 1000mm wide and cut 1 sheet down to 540mm to make up the total length. So we could have 3 different walls to be clad all at different lengths. So the schedule will the have all the different cladding lengths with number of sheets. When I issue our fabrication drawing I just want the schedule to tell the sheet metal guy how many sheets to prepare.
 So wall 1 - 4500mm = 4.5 sheets

wall 2 - 700mm = 0.7 sheets

wall 3 - 2760mm = 2.76 sheets 

hope all that makes sense 

[barthbradley]

You wouldn't even have to model this.  A calculated parameter in the MTO would be all you need.  We do it all the time - in every project.  

[mattpick10]

Ok

not sure what you mean by MTO 

but willing to give it a go if you can explain 

[barthbradley]

Material Takeoff (MTO) Schedule.  

[barthbradley]

This work? 

NOTE: "Cut Panel Width (Array Spacing)" is the Array Spacing AND the Panel Width associated to your nested Panel Family's Parameter that controls its Width.  

[barthbradley]

or maybe this one which computes number of uncut panels needed: