Hi Everyone,
Maybe you could help how to do the parameters of Schedule/Quantities.
Please see attached.
Thank you,
Solved! Go to Solution.
Solved by Alfredo_Medina. Go to Solution.
Solved by Alfredo_Medina. Go to Solution.
It is difficult to guess what you need. Please spend more time composing your question, providing all the necessary information.
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
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")))
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.
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,
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,
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?
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.
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.
Hi Alfredo,
Thank you very much for you help. Very much appreciated.
Just last one favor please if you can give me one example calculated formula for Good on how to do it.
Thank you.
It would be as in this image:
( I still think one single column would be a simpler and easier to read).