Schedule count by phase

[ryley.g.h]

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.

[L.Maas]

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

[barthbradley]

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. 

[ToanDN]

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.

[RDAOU]

@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

1. Existing (Demolished) – Excluded from the schedule
2. Existing (Not Demolished) + Split into 2 Categories
• Relocated
• Not Relocated
3. 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)