Room schedule legend scheme and formulas

[kafka]

Hi All,

I am trying to make a color coded legend with a calculated value parameter for a room schedule. Quite nicely I have discovered calculated value cannot be used in color scheme - that s what they should be used for...especially for room!

Project parameters dosnt seem to accept other system params in their formulas!

Any ideas how can this be done?

I am calculating whether some rooms exceed or not a required amount of area.

[Alfredo Medina]

A color scheme may not be the best choice for this task. A schedule with the room name, the room's area, and two additional columns and a conditional formatting would do the job. The two additional columns are:

1) "Programmed area".(new parameter, area)
2) "Complies" (calculated value, yes/no)

The calculated value works with a formula, which compares the values of "Area" and "Programmed area" between a certain range. Then you apply conditional formatting to "Complies" to display in red background the values where the result of the formula is "No".

[kafka]

Yes I know and I already did a schedule with those parameters! The problem is I want to generate automatically a plan showing the rooms that do not comply! The problem is that I cannot use calculated values parameters to make color legend plans!!!!!

[Alfredo Medina]

Yes I know and I already did a schedule with those parameters! The problem is I want to generate automatically a plan showing the rooms that do not comply! The problem is that I cannot use calculated values parameters to make color legend plans!!!!!

You can make a floor plan (not a Color Scheme), showing rooms that do not comply with certain conditions, using a Filter, with conditions such as " 'Area' less than..." , and turning on the Fill of rooms.

[kafka]

Yes true I didn't think about filters, but still you can't use calculated values to make view filters! The only option is to use a shared parameter for areas/rooms and use as number, but this still invoves a bit of manual input. You need to entry this parameter for all rooms that exceedes or below a certain range! This is something they need to improve definetely. Probably it can be worked out with some API I guess also.

thanks anyway