|
active
Joined: Mon, Jan 22, 2018
0 Posts
No Rating |
Okay, first question here and I hope it's a good one.
I have a data device outlet family I created, and it has a couple of shared parameters that I am adding to the device schedule. One of them is a text parameter that adds a letter annotation to the symbol. Since the annotation in the symbol can't be shared, I made a similar shared parameter and simply based the value of the unshared value on the shared one. Works great. This will allow me to populate the floor plans with the outlet type designations from the schedule.
However, the other annotation is for the number of cables at the outlet. Yes, I could go the same "shared/unshared" method but I would like to be able to total the number of cables from the schedule, which means the shared parameter must be numerical (and the non shared one has to be text). So I'm getting the usual "bad units" type errors.
I suppose I could do a bunch of nested IF statements in the parameter formula (if that's the way to go, could someone steer me the right way on it?). The only permutations are 1, 2, 3, or 4 cables at an outlet, so it could be done with 3 nested IF's right? I'm terrible at the syntax, but I took a stab at the formula for the "Count" unshared parameter (Shared parameter is "Schedule):
= IF(Schedule = 1 , "1", IF (Schedule = 2 , "2", IF(Schedule = 3 , "3", "4"))
Maybe my syntax is wrong (right now I'm getting an "unexpected end of expression" error. But if comeone could give their two cents if I'm wrong or headed in the right direction I'd really appreciate it.
If this sounds like a lot of trouble, the reason I want to do it this way is I have to lay out the devices right now (about 1,000 of them), but I haven't been given cable counts or device types yet...I only know where they will be. Later, it will be much easier to enter the information into a schedule.
|
|
active
Joined: Tue, Apr 12, 2005
1310 Posts
 |
I'm not entirely sure about what you're trying to achieve, but I can see that your formula needs another closing bracket.
|
|
active
Joined: Mon, Jan 22, 2018
0 Posts
No Rating |
Let me try to clarify. There is a label next to my data outlet symbol that indicates the number of data cables at the outlet. I want this value to be entered from a schedule (and not via the floor plan), but the schedule value has to be a number for the schedule column to be able to be totalled to determine the number of cables on the project.
So I gave the outlet symbol a shared parameter for the schedule, and an unshared parameter for the label. I am trying to connect the two parameters via formula. The only values I forsee are 1, 2, 3, or 4 cables.
Thanks for spotting the missing parentheses...the formula is now whole, but it's not working as intended...every one returns 4 cables now, regardless of the schedule input.
Any ideas?
|
Search