topic Re: Schedule count by phase in Revit Architecture Forum

Schedule count by phase

ryley.g.h — Tue, 18 May 2021 14:07:33 GMT

Is it possible to have a Revit schedule that counts items by the phase they are created? For instance, if I have 10 elements, 3 are new, 4 are relocated, and 3 are existing to remain.

This is how our schedules look in CAD:

E= Existing, R= Relocated, N= New

I understand it might not look exactly like this, which is fine.

What cannot happen, is to have a different row for each element that is dedicated to a phase, we would never be able to fit the schedules onto our sheets.

Re: Schedule count by phase

L.Maas — Tue, 18 May 2021 14:42:27 GMT

You can not have it on one row (with plain Revit). You could do something like this example

If you really need it on one row you might be able to do something by adding parameters (i.e E, R, N) to all your relevant objects and then use a Dynamo script to push relevant data into those parameters. Tht is read the phase of the element (e.g. Existing) and then set the E parameter to 1 and leave R and N on 0). then you could schedule those E,R and N parameters and do a count. Something along those lines

Re: Schedule count by phase

barthbradley — Tue, 18 May 2021 15:04:39 GMT

Maybe you can get there by Creating a Yes/No Project Parameter for each Phase and assigning it to all available Categories and then manually checking the checkboxes for the elements in the Project. Then put together a Multi Category Schedule for the last Phase of the Project and set the Schedule's Phase Filter to "None". Then add these "checkbox" Project Parameters into the Schedule from the list of available Parameter Fields along with Count and other data. Then Sort/Group and Calculate totals as needed.

Re: Schedule count by phase

ToanDN — Tue, 18 May 2021 19:20:25 GMT

It can be done semi-automatically.
- create Action ID integer parameter and add it to your schedule
- select all existing to remain elements and enter 0 for that parameter value
- select all existing to be relocated elements and enter 1 for that parameter value
- select all new elements and enter 2 for that parameter value
(you can do the 3 above steps fairly quickly via filtering/grouping in a schedule based on the actual Phase parameters)
- add E as a calculated value with the formula: if (Action ID = 0, 1, 0)
- add R as a calculated value with the formula: if (Action ID = 1, 1, 0)
- add N as a calculated value with the formula: if (Action ID = 2, 1, 0)
- format E, R, N to Calculate Totals

That's about it.

Re: Schedule count by phase

RDAOU — Tue, 18 May 2021 22:57:36 GMT

@ryley.g.h

PS: This currently works for elements in the Current Model - It can be modified to include elements from a Linked models

I am using Dynamo to filter Elements (in this case walls) by Phase

Existing (Demolished) – Excluded from the schedule
Existing (Not Demolished) + Split into 2 Categories

Relocated
Not Relocated

New (I assumed that those elements being are not relocated)

Parameters used: Project Parameters Added to Category of the element (Instance)

New - Integer (Set by Dynamo)
Existing - Integer (Set by Dynamo)
Existing Relocated - Integer (Set by Dynamo)
Existing to be Relocated - Yes/No (This has to be checked by the user for walls to be relocated)