To comply with the sound building regulations (code) here in the UK, I need to make sure that there is not more than 1 light fitting per 2m2 of ceiling area in each room.
I thought that this should be simple to schedule in Revit, and it probably is, but I'm getting stuck at the starting point.
I have my light fixture schedule which has a quantity (count) total per room, and each room area in m2. So the schedule fields include 'Count' and 'Room: Area'. But when I go to add a Calculated Value the available fields doesn't have 'count'. So my great idea of making a formula that is area/count is a non starter.
I'm looking to have in my schedule a column that if the area/# of fittings are >2m2 then all is OK but if area/# of fittings is less than 2m2 then it'll flag up in red. (I'm OK with the conditional formatting, its the formula that has me stuck).
Thanks
I thought that this should be simple to schedule in Revit, and it probably is, but I'm getting stuck at the starting point.
I have my light fixture schedule which has a quantity (count) total per room, and each room area in m2. So the schedule fields include 'Count' and 'Room: Area'. But when I go to add a Calculated Value the available fields doesn't have 'count'. So my great idea of making a formula that is area/count is a non starter.
I'm looking to have in my schedule a column that if the area/# of fittings are >2m2 then all is OK but if area/# of fittings is less than 2m2 then it'll flag up in red. (I'm OK with the conditional formatting, its the formula that has me stuck).
Thanks
Comment