RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

344 Users Online (195 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> Understanding Formulas

Search this ThreadSearch this Thread | Page 1 of 1 |

Thu, Oct 28, 2004 at 7:25:49 PM | Understanding Formulas

#1

arnosandoval


active

Joined: Mon, Sep 13, 2004
102 Posts
5 Stars: 3 Votes


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

 

Fri, Oct 29, 2004 at 1:22:49 AM | RE: Understanding Formulas

#2

ale02


active
ale02 Avatar

Joined: Mon, Sep 20, 2004
202 Posts
3 Stars: 3 Votes


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 Smile

This user is offline

 

Fri, Oct 29, 2004 at 1:34:38 PM | RE: Understanding Formulas

#3

arnosandoval


active

Joined: Mon, Sep 13, 2004
102 Posts
5 Stars: 3 Votes


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

 

Sat, Oct 30, 2004 at 2:01:19 PM | RE: Understanding Formulas

#4

ale02


active
ale02 Avatar

Joined: Mon, Sep 20, 2004
202 Posts
3 Stars: 3 Votes


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 Smile

This user is offline

 

Mon, Nov 1, 2004 at 3:09:04 PM | RE: Understanding Formulas

#5

arnosandoval


active

Joined: Mon, Sep 13, 2004
102 Posts
5 Stars: 3 Votes


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

 

Tue, Nov 2, 2004 at 1:29:15 AM | RE: Understanding Formulas

#6

ale02


active
ale02 Avatar

Joined: Mon, Sep 20, 2004
202 Posts
3 Stars: 3 Votes


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 Smile

This user is offline

 

Tue, Nov 2, 2004 at 2:44:55 AM | RE: Understanding Formulas

#7

Mr Spot


site moderator|||
Mr Spot Avatar

Joined: Tue, Jan 13, 2004
2889 Posts
4.5 Stars: 91 Votes


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

Tue, Nov 2, 2004 at 4:31:38 AM | RE: Understanding Formulas

#8

ale02


active
ale02 Avatar

Joined: Mon, Sep 20, 2004
202 Posts
3 Stars: 3 Votes


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

 

Tue, Nov 2, 2004 at 1:34:30 PM | RE: Understanding Formulas

#9

arnosandoval


active

Joined: Mon, Sep 13, 2004
102 Posts
5 Stars: 3 Votes


Sorry about all the confusion, Thanks for the tips, I get it now and it worked out well.

This user is offline

 

Tue, Sep 12, 2006 at 12:17:41 AM | RE: Understanding Formulas

#10

mabel


active

Joined: Thu, May 11, 2006
2 Posts
No Rating


Thanks! It's an absolutely wonderful tip! I had been struggling with that too.

This user is offline

 

Thu, Aug 30, 2007 at 4:18:06 PM | Understanding Formulas

#11

justinblack


active

Joined: Fri, Jun 22, 2007
62 Posts
5 Stars: 1 Votes


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

 

Thu, Jul 8, 2010 at 1:03:02 AM | Understanding Formulas

#12

hisdirt


active

Joined: Sun, Nov 6, 2005
123 Posts
5 Stars: 5 Votes


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

Tue, Nov 16, 2010 at 6:17:10 PM | Understanding Formulas

#13

crwinchester


active
crwinchester Avatar

Joined: Sat, Sep 4, 2010
173 Posts
3.5 Stars: 4 Votes


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

 

Tue, Nov 16, 2010 at 6:29:18 PM | Understanding Formulas

#14

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 351 Votes


Just set your schedule to sort by departments and total your areas.

This user is offline

 

Tue, Nov 16, 2010 at 7:36:05 PM | Understanding Formulas

#15

crwinchester


active
crwinchester Avatar

Joined: Sat, Sep 4, 2010
173 Posts
3.5 Stars: 4 Votes


Thanks. I think I got it close to what I want. Appreciate it!


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Formula

Community >> Newbies

Sat, Jun 13, 2015 at 10:51:55 AM

0

Formulas in Schedule

Community >> Newbies

Thu, Feb 27, 2014 at 1:41:30 PM

1

to import shared parameters with formulas.

Workflow & Implementation >> API & Third Party Apps

Fri, Jun 20, 2014 at 12:19:05 PM

0

Door Family Formulas

Revit Building >> Technical Support

Fri, Dec 12, 2008 at 9:00:47 PM

4

Parameter Formulas

Revit Building >> Technical Support

Wed, Mar 21, 2007 at 5:48:43 PM

1

Site Stats

Members:

1454057

Objects:

20602

Forum Posts:

150690

Job Listings:

6

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.0981

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights