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: 

Add a row inschedule for percentage calculation

15 ANTWORTEN 15
Antworten
Nachricht 1 von 16
Anonymous
8334 Aufrufe, 15 Antworten

Add a row inschedule for percentage calculation

Hi,

 

I wish to add a row above grand total in schedule to show % area calculation. Summation of each column divide by total building area(5279.27)

 

Eg:

3587.48/5279.27= 67.9%

942.29/5279.27=1.8%

749.5/5279.27=14.2%

 

Pls advise steps to do it.

 

Thaniks

 

 

schedule %.jpg

15 ANTWORTEN 15
Nachricht 2 von 16
rudi.roux
als Antwort auf: Anonymous

Hi @Anonymous

 

Hope you are well! Smiley (fröhlich)

 

What you need to do is to add a Calculated Parameter/Value to your Schedule. 

 

Go to your Schedule, Click on Edit Fields, or Insert a new Column >> Calculated Value >> Select Percentage >> Then Select Percentage Of: e.g - Area Divided By: Area <Grand Total> and click ok. 

 

1-gross-1.png

 

This will then give you the result which you're after. e.g - 84/140 = 60% (as per the sample below:

 

1-gross-2.png

 

I hope this helps! Smiley (fröhlich)


Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate

If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome

Nachricht 3 von 16
Anonymous
als Antwort auf: rudi.roux

Hi Rudi,

 

Thanks but I need to add a row above the Grand Total, not column. May I know how?

 

Thank you.

Nachricht 4 von 16
FGPerraudin
als Antwort auf: Anonymous

hi @Anonymous,

 

Sadly Revit will not let you add a customized total (as it is what you want to get).

 

If I were you, I would export the data into excel.

 

You can use dynamo to do that, and get a live feed from Revit to excel.

 

François



Francois-Gabriel Perraudin
BIM management and coaching

Nachricht 5 von 16
rudi.roux
als Antwort auf: Anonymous

Hi @Anonymous

 

As @FGPerraudin mentioned, there are limitations to rows in schedules. 

 

What you can do is the following: (To keep everything in Revit)

  • Create Calculated Values (Percentages) for each Column as showed in my first post. 
  • Then you can Create "Grand Totals" for each of the Data Totals(m²) which you're trying to get a Percentage for. 
  • So, instead of the Percentages being displayed above the m², they will be displayed next to them. This will give you the result which you're after, or at least a workaround due to the limitations. 

1-calc-1.png

 

Add Calculated Value/Percentages as shown below: 

 

1-calc-2.png

I hope this helps! Smiley (fröhlich)


Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate

If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome

Nachricht 6 von 16
RDAOU
als Antwort auf: Anonymous

@FGPerraudin I'm gonna start believing that you work on DynamoBim marketing team lol

 

 

@Anonymous it is a presentation thing? If it is you can simply duplicate and overlay schedulles to produce something similar... A customized total

 

image.png

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 7 von 16
FGPerraudin
als Antwort auf: RDAOU

@RDAOU

 

Iknow... have to say I start loving the tool!

 

But yes, maybe a bit too enthusiastic at the moment!



Francois-Gabriel Perraudin
BIM management and coaching

Nachricht 8 von 16
Anonymous
als Antwort auf: RDAOU

Hi Rdaou,

 

Can you show me how you manage to get the last row %. I need to have % at bottom of each column like what you have shown.

Not sure what you mean by 'presentation thing', but looked like it worked in your video.

 

Hi Rubi, 

% is not by level.

Perhaps I should create a separate schedule but how do I link new schedule to this current schedule so that grand total of each column can be expressed as a %.

 

Hi FGPerraudin,

I'm not so advanced to try Dynamo, Smiley (fröhlich)

Maybe future.

 

Nachricht 9 von 16
rudi.roux
als Antwort auf: Anonymous

Hi @Anonymous

 

Are you at liberty to share the model via Dropbox or WeTransfer? Then I can help you out directly in your project. Otherwise, I'll revise my sample a bit to show you what can be done or to further elaborate on what I suggested. Smiley (fröhlich)


Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate

If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome

Nachricht 10 von 16
RDAOU
als Antwort auf: Anonymous

1. Duplicate the area schedule u have
2, on the new, add a calculated value column for the % next to each area column
3. Uncheck the itemize every instance (u get one line)
4. Hide all columns except the % columns
5 place both schedules on a sheet

Et Voila

I'm not at a computer at the moment maybe I will screencast all the steps when I'm back at my desk

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 11 von 16
Anonymous
als Antwort auf: RDAOU

Thanks rdaou.

Appreciate if you could screencast step by step.

Sorry I cant share model.

Nachricht 12 von 16
rudi.roux
als Antwort auf: Anonymous

Hi @Anonymous

 

Screencast and sample project attached for you reference. You can create percentage calculated values as per one of my previous posts next to each of your columns and then manipulate the schedules and percentages as you wish to fit your needs. 

 

I hope this helps! Smiley (fröhlich)
 


Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate

If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome

Nachricht 13 von 16
Anonymous
als Antwort auf: rudi.roux

Hi Rudi,

 

Thanks for screencast but I'm not looking at % per floor.

 

Here's what I'm looking at :

3587.49 / 5279.39 = %

 

sch.jpg

Nachricht 14 von 16
Anonymous
als Antwort auf: RDAOU

Hi Rdaou,

 

Can you show me how you get the overall building percentage at 25.56%?

 

Thanks

Nachricht 15 von 16
RDAOU
als Antwort auf: Anonymous

@Anonymous

 

You hide the columns which you do not Need!!! we Show you the method but you Need to work it out following same steps on your Project!!

 

What @rudi.roux has put in a screencast is correct...if you follow same step and hide the % column for floors you will get what you want. You really need to put some effort in trying :leicht_lächelndes_Gesicht:

 

otherwise attach your file and someone will do it for you. Take less time then posting 100 replies to this thread

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 16 von 16
Anonymous
als Antwort auf: RDAOU

I tried your method to create %columns but the % are not correct figures.

It should be grand total of each column divide by grand total of Column B.

Eg C/B, D/B, E/B, G/B, H/B.

 

maanger.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