|
Forums >> Revit Building >> Technical Support >> Understanding Formulas
|
|
|
active
Joined: Mon, Sep 13, 2004
102 Posts
 |
I need some help using formulas in Revit, I want to be able to do cost estimates based on lenght of wall, or area of of floor, etc, but am having problems getting the formulas to work. Can someone help? Thanks
|
This user is offline |
|
 |
|
|
|
active
Joined: Sun, Sep 19, 2004
202 Posts
 |
I think it should not be that difficult but just the steps are abit complicated.
Once you create a schedule, let say wall schedule, select all the required parameters over which should include length, area & cost whichever applied. (note: you can rename the cost field by right click on the schedule>view properties> format. & change it into cost per meter or cost per ft. to be more exact) After that, going back to view properties> field tab> click on calculated value> put in a field of Total cost and add in your formula there. I think the formula should be something like length*cost per meter (depending what field name you are using, if any problems, revit will prompt you.) If you intend to show the Grand total, please go back to format tab> click on, select the Total Cost field & click on calculate totals in the bottom, after that, go back to view properties>sorting/ group tab> click on grand total at the bottom. Try to run the project by putting some wall and see the schedule generate or not.
The revit tutorial will help too as all the steps I mentioned are eventually from the revit tutorial..Good Luck
Let me know whether it work or not..
Try to share if you are working on some specific schedule such as formwork schedule and cut & fill schedule as I am still working on that. Good Day
-----------------------------------
Life is never easy but nor it should be complex. Just stay simple  |
This user is offline |
|
|
|
active
Joined: Mon, Sep 13, 2004
102 Posts
|
Thanks for the tip, what I have problems with, is getting the units right for some reason or another. The way parameters for the schedule, (length, width, area, cost) just doesnt want to seem to work. I can try area*cost, or length*cost, I get the inconsistent units. Can you help. Thanks
|
This user is offline |
|
|
|
active
Joined: Sun, Sep 19, 2004
202 Posts
|
Not quite understand your problems.
What do you mean by inconsistent units?
Do you mean the parameters did not add up to represent the real length & area? or you are testing length*cost & area*cost and they don't match out in figure??
Sound interesting & maybe I can investigate more on it..
Let me know more details on your case or try out.
-----------------------------------
Life is never easy but nor it should be complex. Just stay simple |
This user is offline |
|
|
|
active
Joined: Mon, Sep 13, 2004
102 Posts
|
I mean the units in the formula are inconsistant. The trick is getting the units to be consistant. Numbers with numbers.......that is the problem that I am having, I am trying to understand what kind of units they are using for their(Revit) parameters. If you have any insight to this that would be greatly appreciated. Thanks.
|
This user is offline |
|
|
|
active
Joined: Sun, Sep 19, 2004
202 Posts
|
Properly you are talking about project unit
Go to setting> project unit> and standardized your project unit there.
I tried and it reflected the changes on the schedule as well but I think it only apply for common parameters such as length, area, volumes & for structural loading
Hope this help!
-----------------------------------
Life is never easy but nor it should be complex. Just stay simple |
This user is offline |
|
|
|
site moderator|||
Joined: Mon, Jan 12, 2004
2889 Posts
 |
Okay the confusion comes because cost is a number and area is mē. Therefore when you create a calculated value for total cost you select number...
Now revit is looking for a number yet your units when for instance going cost*area is mē....
Try this cost*(Area/1)
This will effectively remove the units from the value.
Post edited on 2004-11-01 20:45:06
|
This user is offline |
View Website
|
|
|
active
Joined: Sun, Sep 19, 2004
202 Posts
|
arnosandoval,
Please follow Mr.Spot formula..
My mistake for not giving you the correct formula at the first place.
As explained by Mr.Spot. Cost has no unit (or just a number) and area and length has a unit of m2 or m as recognized in Revit. When we key in formula, we must put cost/1 (1 represent invert unit so that it will cancel out with the area or length unit) and it will return the value in number for total cost.
|
This user is offline |
|
|
|
active
Joined: Mon, Sep 13, 2004
102 Posts
|
Sorry about all the confusion,
Thanks for the tips, I get it now and it worked out well.
|
This user is offline |
|
|
|
active
Joined: Wed, May 10, 2006
2 Posts
No Rating |
Thanks! It's an absolutely wonderful tip! I had been struggling with that too.
|
This user is offline |
|
|
|
|
|
active
Joined: Fri, Jun 22, 2007
62 Posts
|
Amazing tip MR. SPOT!!!!!!!! It makes sense when you think about it, but I really don't think I would've come up with that on my own. Thanks again! JB
|
This user is offline |
|
|
|
active
Joined: Sun, Nov 6, 2005
123 Posts
|
Nice one Mr Spot! Had no idea about that workaround, and I wasnt looking forward to re-writing all my formulas as lengths/areas/volumes!
|
This user is offline |
View Website
|
|
|
active
Joined: Sat, Sep 4, 2010
173 Posts
 |
I'm not sure if this solution applies, but I was wondering how I might generate a total area for the following case and forgive me for being a novice at using using formulas: I gave associated departments within the identity data to rooms that I've created and I want to generate a schedule that displays the total area of each department. The Department is considered as a text parameter and area as area. How can I associate these two? I'm not sure if I need to convert similarly to the above threads or if there is something more obvious that I'm missing. Thanks!
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
 |
Just set your schedule to sort by departments and total your areas.
|
This user is offline |
|
|
|
active
Joined: Sat, Sep 4, 2010
173 Posts
|
Thanks. I think I got it close to what I want. Appreciate it!
|
This user is offline |
|
|
|
Search