Revit Architecture

## Revit Architecture

Distinguished Contributor
Posts: 176
Registered: ‎10-08-2007
Message 1 of 13 (279 Views)

# Schedule/Quantities - Need HELP Urgently

279 Views, 12 Replies
12-07-2013 08:02 AM

Hi Everyone,

Maybe you could help how to do the parameters of Schedule/Quantities.

Thank you,

*Expert Elite*
Posts: 2,737
Registered: ‎06-11-2009
Message 2 of 13 (258 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-07-2013 10:07 AM in reply to: ennujozlagam

It is difficult to guess what you need. Please spend more time composing your question, providing all the necessary information.

-----------------------------------------------------------------------------------------------------------------
Planta1 Revit Online Consulting | info@planta1.com | my Twitter | The Planta1 Blog
Distinguished Contributor
Posts: 176
Registered: ‎10-08-2007
Message 3 of 13 (233 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-07-2013 07:45 PM in reply to: Alfredo_Medina

Hi Alfredo,

Thank you for you prompt reply,

I want to know how im going to add parameters like for example how many basin, water closet , showers, bathtubs (all plumbing fixtures) in a condominium which have 6 units per floor (approx. sample only 2 floors) and need to calculate also their "Wells" example 1 basin is .075 another basin is 3.  I tried this formula if(Well < 1, "Good", "Very Good", "Excellent") doesnt work.

In my first posted if i can create schedule/quantities something like that if  i can get total numbers of plumbing fixtures?

thank you

*Expert Elite*
Posts: 2,737
Registered: ‎06-11-2009
Message 4 of 13 (202 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-08-2013 06:13 AM in reply to: ennujozlagam

You need a calculated value such as "Rating" (as text), with embedded IFs statements based on the value of "Wells" (as number), such as in this example:

if(not(Wells > 1), "Good", if(not(Wells > 2), "Better", if(not(Wells > 3), "Even Better", "out of range")))

-----------------------------------------------------------------------------------------------------------------
Planta1 Revit Online Consulting | info@planta1.com | my Twitter | The Planta1 Blog
Distinguished Contributor
Posts: 176
Registered: ‎10-08-2007
Message 5 of 13 (195 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-08-2013 06:23 AM in reply to: Alfredo_Medina

Hi Alfredo,

Thank you very much for your help. Very much appreciated.

Is there anyways if can create or how to create in schedule/quantities same table (please see attachment) . I have difficulties doing this schedule.

Any help again you can give is much appreciated.

Thank you.

Distinguished Contributor
Posts: 176
Registered: ‎10-08-2007
Message 6 of 13 (189 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-08-2013 06:42 AM in reply to: ennujozlagam

Hi Alfredo,

I tried your instructions but sorry to say it looks like doesnt work. Anything that goes wrong?  I attached the sample files.

Thank you,

Distinguished Contributor
Posts: 176
Registered: ‎10-08-2007
Message 7 of 13 (186 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-08-2013 07:02 AM in reply to: ennujozlagam

Hi Alfredo,

Thank You. Sorry you are right. I managed to use your formula and it works find now. Is there anyways that i can put on top (same as attachment-follow the tables) the "Good" "Very Good" "Excellent"?

Thank you,

*Expert Elite*
Posts: 2,737
Registered: ‎06-11-2009
Message 8 of 13 (176 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-08-2013 07:23 AM in reply to: ennujozlagam

And what would you like to show in each column? A numeric value or a yes or no mark? I think that just one column for "Rating", showing the rating of each row as "good", "bad", or "excellent", or whatever, is enough. Is it not?

-----------------------------------------------------------------------------------------------------------------
Planta1 Revit Online Consulting | info@planta1.com | my Twitter | The Planta1 Blog
Distinguished Contributor
Posts: 176
Registered: ‎10-08-2007
Message 9 of 13 (147 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-08-2013 04:34 PM in reply to: Alfredo_Medina

Hi Alfredo,

Thank you, Need to show yes or no and quantities of plumbing fixtures like basin water closet shower head bathtubs. My main goal also is to create same table (schedule/quantities) as posted but the problem i have difficulties doing that could you help me please.

Thank you very much.

*Expert Elite*
Posts: 2,737
Registered: ‎06-11-2009
Message 10 of 13 (141 Views)

# Re: Schedule/Quantities - Need HELP Urgently

12-08-2013 06:17 PM in reply to: ennujozlagam

I think that just one column for rating is more efficient. If you want 3 columns to express the same thing, you need to create 3 calculated values with formulas, based on the value of the "Wells" parameter.

-----------------------------------------------------------------------------------------------------------------
Planta1 Revit Online Consulting | info@planta1.com | my Twitter | The Planta1 Blog

Recently Solved

Revit