I think what I'm looking for is a workaround for an area as a global parameter. Here's the issue:
I have a flooring material schedule reporting area square footage of two finishes in my model, Tile A and Tile B. Floor 1 is a uniform pattern of Tile A. Floor 2 is a mix of the two tiles, where Tile B makes up 1/3 of the mix. I want my schedule to automatically calculate the total square footage needed of Tile A and Tile B, for ordering purposes.
Tile B is easy enough. Since I have no other instance of Tile B, i'm just using Floor 2 as Tile B and taking 1/3 of that square footage. Tile A is the problem. I'd like to total Floor 1 and Floor 2's 2/3 remaining area. At first I thought Global parameters was my answer until I realized I can't use them to report Floor 2's area. So has anyone found a work around, where i'm using the values of one floor to calculate/generate values for another?
Tile A and Tile B must remain separate line items in the schedule. I'm looking for an automatic solution where I do not have to manually input Floor 2's area (which is what I'm doing now), so that if Floor 2's boundaries change, Tile A and Tile B will automatically update.
I'm hoping someone's found a creative way to set up a schedule to do this.
for this it is useful to use calculated value. Calculated Values | Revit Products 2018 | Autodesk Knowledge Network
Correct me if I'm wrong, but I'm not able to use a calculated value using the reporting value from a different line/element in the schedule.
I used a calculated value to create Tile B (33% of Floor 02). My issue is determining how to add the remaining floor of Floor 02 into a formula or calulated value of Floor 01 in order to calculate the value of Tile A.
If calculated values can do that, please provide more detail as I seem to be missing something.
In your formula, I'd need to go further and take the amount of tile that is not counted in [ quantity_tile_B ] and add it to the [ quantity_tile_A] to create the actual total of Tile A.
I don't think I'm explaining my problem very well. I've revised my original image to show that my issue is what's specifically highlighed in green. If I just use a simple area calculated value, Tile A would come up as 4800 SF. I'm missing the remaining amount of Tile A (highlighted in green) that is in the Floor 02 mix.
Calculated values by itself is not enough b/c I want to use an area from a different element (Floor 02) in order to create a calculated value for Floor 01. Tile A needs to be a calculation of two different floors' areas.
Currently I'm manually inputing Floor 02's area into a parameter assigned to Floor 01 and that is how my schedule is calculating the total Tile A value. I'm looking for a workaround that can report Floor 02's area so that it would no longer be manually inputed so that when I inevitably need to change Floor 02's extents, both quantities for Tile A and Tile B update automatically.
I understand this needs to be a workaround b/c I'm asking Revit to assign attributes of one element to another. The only other option I can think of is to break apart my mixed floor into rectangular regions, then I could report each region's length & width to create a workaround for a reporting area parameter. But this would require adding/removing multiple parameters when my floor changes shape, just to report a single area. I was hoping my brain was making this harder than it needed to be and that there was a better solution out there.
Hi, something like this? (we can calculate it in columns but not in rows...)
See the snapshot Floor A = 100m2 and Floor B = 49m2
Total A = 100 + (49 * 2/3) = 133m2 (rounded)
Total B = 49 * 1/3 = 16m2 (rounded)
- Michel
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.