Community
Hello
I need some help please i am working on a schedule which works total amount of glazing % per room area. I have got the first part to work so it will divide the purge ventilation area/ the room area. I need it to combine each instance into a total so the 2x windows in test and the 2 in ROSS. So test would have a % of 20% and and ROSS would be 13.4%. Eventually i would like to do this for the whole house so total glazing to total house areas.
Thanks hope i have been clear
Hello
I need some help please i am working on a schedule which works total amount of glazing % per room area. I have got the first part to work so it will divide the purge ventilation area/ the room area. I need it to combine each instance into a total so the 2x windows in test and the 2 in ROSS. So test would have a % of 20% and and ROSS would be 13.4%. Eventually i would like to do this for the whole house so total glazing to total house areas.
Thanks hope i have been clear
So i want to get this total in pink circle back into the schedule, the below text i have found on another forum i think is what i am after. I just need to get my head round
Good, as this schedule trick is dependent on the sorting levels (calculated values have access to the sorting level totals), and you are working within the same sorting level. I think you can do this with (2) additional CVs.
Parameters you already have (I'm renaming them here):
roomArea (area of room), roomAreaLimit (10% of roomArea), windowArea (area of each window unit), roomOK (y/n)
Parameters you need:
windowAreaPercentage: calculated value Of windowArea By Room:Name (this is one of your sorting levels). This is each window's percentage of the total window area for that room.
windowAreaPercentageTotal: formula, Type: Area, windowArea / windowAreaPercent. This is the total window area for the room.
Now you need to adjust your roomOK formula to: not(windowAreaPercentageTotal > roomAreaLimit)
So i want to get this total in pink circle back into the schedule, the below text i have found on another forum i think is what i am after. I just need to get my head round
Good, as this schedule trick is dependent on the sorting levels (calculated values have access to the sorting level totals), and you are working within the same sorting level. I think you can do this with (2) additional CVs.
Parameters you already have (I'm renaming them here):
roomArea (area of room), roomAreaLimit (10% of roomArea), windowArea (area of each window unit), roomOK (y/n)
Parameters you need:
windowAreaPercentage: calculated value Of windowArea By Room:Name (this is one of your sorting levels). This is each window's percentage of the total window area for that room.
windowAreaPercentageTotal: formula, Type: Area, windowArea / windowAreaPercent. This is the total window area for the room.
Now you need to adjust your roomOK formula to: not(windowAreaPercentageTotal > roomAreaLimit)
@roscopeco2000 wrote:
So i want to get this total in pink circle back into the schedule, the below text i have found on another forum i think is what i am after. I just need to get my head round
The total circled in pink IS in the schedule so I don't understand your question. Where do you want to show it exactly?
@roscopeco2000 wrote:
So i want to get this total in pink circle back into the schedule, the below text i have found on another forum i think is what i am after. I just need to get my head round
The total circled in pink IS in the schedule so I don't understand your question. Where do you want to show it exactly?
I don't count that as in the schedule, its a total as a footer to me. I want the total as a cell in the schedule. I need it display as cell so i can reference in a conditional format .
I don't count that as in the schedule, its a total as a footer to me. I want the total as a cell in the schedule. I need it display as cell so i can reference in a conditional format .
Forums Links
Can't find what you're looking for? Ask the community or share your knowledge.
Post to forums
