What's wrong with this schedule?
This is what I need to see - with Itemize Each Instance unchecked
The highlighted fields are formula driven -
Both Total Existing and Total Proposed are Shared Number Parameters.
I understand that this is a problem, that prevents the formula from working -
Is there any way around this? I don't want to ask my team to calculate and manually enter values!
Thank you in advance....
Gelöst! Gehe zur Lösung
Gelöst von Sahay_R. Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
You need to enter 0 for all blank cells of Existing Seats, Existing BF, New Seats, New BF.
Here's the deal, @ToanDN - can't add the 0s. The Proposed Seats and Proposed BFs have a Shared Parameter with a value of 1 so that they schedule by that parameter and give actual counts. The Existing is an invisible 'dummy' family that has a Shared Parameter for the sole purpose of entering the numbers since we do not want to model the existing seating.
Per @barthbradley 's wish - here is a link to the file -
OK - you added the parameters to the project - that was the step that I was missing....THANK YOU!
I just edit the parameters directly from the schedule and assign them to the Rooms/Doors categories. By the way, you don't need to use shared parameters for any of those fields, everything can be added as non-shared parameters directly in the project's schedule.
I just assigned them to Furniture. How did you edit the parameters right out of the schedule?
(Hang on - I see them as Shared Parameters assigned to Furniture and Rooms in your project....)
And also - those parameters come from the Families, and if they aren't Shared I can't schedule for that parameter....
Aahh. Another way to add a Shared parameter to the project..... Thank you!
And now what's wrong with this?
This is the desired result....
After coming so far.....
What would you suggest? Creating hidden fields for Total Existing and Total Proposed, and using them in a calculated field for the Percentage Decrease?> My head hurts now......
Would that mean stitching the two schedules together on the sheet? A FrankenSchedule, so as to speak?
Since you have to re-enter the values to the room schedule anyways so just use one schedule. Keep the furniture schedule for validation should the design changes.
Right - that's what I did - created two hidden fields, manually entered the numbers in there to feed the calculated parameter that gave the percentage decrease values. All is well now.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.