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: 

Percentages in Schedules

18 ANTWORTEN 18
GELÖST
Antworten
Nachricht 1 von 19
AidanHawkins
889 Aufrufe, 18 Antworten

Percentages in Schedules

I am working on a 4 sided tower, where the facade is made of curtain walls with curtain panels on each level

I have created a curtain wall schedule

I have created 3 parameters for the curtain panels

Parameter 1 is a Yes/no parameter for weather the panel is complete or not

Parameter 2 is a text parameter that reports if the curtain wall is east, west, north or south

Parameter 3 is a text parameter that reports what level the curtain panel is on

 

How can I show in a schedule the count of the total that is yes for Parameter 1 / count of the total number of parameter 3 (which is the total number of panels) * 100

 

So I can show in a schedule the percentage of panels that are complete

18 ANTWORTEN 18
Nachricht 2 von 19
Alfredo_Medina
als Antwort auf: AidanHawkins

What if instead of using a Yes/No parameter to indicate complete or not, you use an integer parameter, and enter 1 if the panel is complete. Then you can get the percentage of the count of that field compared to the total number of panels.


Alfredo Medina _________________________________________________________________ ______
Licensed Architect (Florida) | Freelance Instructor | Profile on Linkedin
Nachricht 3 von 19
AidanHawkins
als Antwort auf: AidanHawkins

Ok thanks, but how do I do that?

I just want the count of the complete / count of the total panels on one side (that I have shown using my parameters)

 

Is it a formula in calculated values I have to use?

Nachricht 4 von 19
barthbradley
als Antwort auf: AidanHawkins

Text Parameters cannot be used in formulas, but if they were numeric, you could write a Calculated Parameter formula like this:

 

 

Sched73.png

 

Sched73-2.png

 

 

 

 

Nachricht 5 von 19
AidanHawkins
als Antwort auf: barthbradley

Could I make a parameter for the curtain panel and give each curtain panel the number 1

And then have a different parameter to show completion that gives a 1 to each one that is complete

 

And then get the percentage of completion by comparing these two? 

Nachricht 6 von 19
AidanHawkins
als Antwort auf: barthbradley

I want to get the total number of complete, by the grand total of How many panels there are..

Nachricht 7 von 19
AidanHawkins
als Antwort auf: Alfredo_Medina

how can I calculate total number of panels, as when i try to do a formula it wont let me use count in revit

Nachricht 8 von 19
barthbradley
als Antwort auf: AidanHawkins

Something like this?  Showing 21 of 42 "completed" as a percentage (50%).

 

Sched73-3.png

 

or maybe better this way:

 

Sched73-4.png

Nachricht 9 von 19
AidanHawkins
als Antwort auf: barthbradley

Exactly! How is it done?

Nachricht 10 von 19
barthbradley
als Antwort auf: AidanHawkins

see attached rvt

Nachricht 11 von 19
barthbradley
als Antwort auf: AidanHawkins

you could do this too...

 

Sched76-A.pngSched76-B.png

Nachricht 12 von 19
AidanHawkins
als Antwort auf: barthbradley

Yes thanks

 

But it is so annoying I cant just use count to do analysis in revit

With your way, I can never hide the percentage of  ´No´ and I cant make a presentable table

Nachricht 13 von 19
ToanDN
als Antwort auf: AidanHawkins


@AidanHawkins wrote:

Yes thanks

 

But it is so annoying I cant just use count to do analysis in revit

With your way, I can never hide the percentage of  ´No´ and I cant make a presentable table


Share how do you want your schedule to look and a revit file if possible.

Nachricht 14 von 19
AidanHawkins
als Antwort auf: ToanDN

Panels Level

North 

01

20%

02

10% 

 

This is an example of one of the schedules I want to produce. I would like to produce four (North, South, East and West) all the same.

 

Panels Level is a parameter that reports on what level each panel is on.

There is also another parameter working in the background that reports what elevation they are on (North South, East and West.)

And the percentages in Green are the amount of that are ´Yes´ in my Yes_No Completion Parameter out of the total number of panels that on that particular level and on that particular elevation side.

 

Many thanks, hope I am clear

Nachricht 15 von 19
barthbradley
als Antwort auf: AidanHawkins

Maybe this? 

 

Panel Sched 74.png

 

Panel Sched 74-1.png

Nachricht 16 von 19
AidanHawkins
als Antwort auf: barthbradley

Yes that could work for me

How is it done?

 

Nachricht 17 von 19
barthbradley
als Antwort auf: AidanHawkins

see attached

Nachricht 18 von 19
AidanHawkins
als Antwort auf: barthbradley

Thanks for this

I have begun to use it for my analysis

But it would be great if I could see number of complete by the number of panels per level

For example, at the end when everything is complete, I could see 100 percent in each cell for each level.

But thank you, this is good for now, I can just create a schedule for each level

 

 

Nachricht 19 von 19
AidanHawkins
als Antwort auf: barthbradley

How can you conditional format only one? I have looked at your model and these screenshots but I cant understand the steps

For example it will not let me change the colour if I place the test as ´None´

 

AidanHawkins_0-1688571034574.png

 

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