Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Area Reporting in Calculated Value

5 ANTWORTEN 5
Antworten
Nachricht 1 von 6
scadetMH3VD
2053 Aufrufe, 5 Antworten

Area Reporting in Calculated Value

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. 

Beschriftungen (2)
5 ANTWORTEN 5
Nachricht 2 von 6
Anonymous
als Antwort auf: scadetMH3VD

for this it is useful to use calculated value. Calculated Values | Revit Products 2018 | Autodesk Knowledge Network

Tags (1)
Nachricht 3 von 6
scadetMH3VD
als Antwort auf: Anonymous

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. 

Nachricht 4 von 6
FAIR59
als Antwort auf: scadetMH3VD

  • Add a project TYPE-parameter to the floor category: [ tile-ratio ]. Value : 1 for floor_1 type and 0.666 for floor_2 type.

tiles_PP.PNG

  • Add project parameter to the schedule.
  • Add a calculated value { type Area } in the schedule: [ quantity_tile_A ] with formula [ tile_ratio * Area ]
  • Add a calculated value { type Area } in the schedule: [ quantity_tile_B ] with formula [ (1-tile_ratio) * Area ]
  • Calculate totals.
Nachricht 5 von 6
scadetMH3VD
als Antwort auf: FAIR59

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. 

 

Tile Calcs 2.JPG

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. 

 

Nachricht 6 von 6
TripleM-Dev.net
als Antwort auf: scadetMH3VD

Hi, something like this? (we can calculate it in columns but not in rows...)

 

totals_2-3_1-3.PNG

 

 

 

 

 

 

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.

In Foren veröffentlichen  

Autodesk Design & Make Report