RevitCity.com Logo

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

Welcome !

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

 

Forums

Forums >> Revit Building >> Tips & Tricks >> Material cost per sq ft formula

Search this ThreadSearch this Thread | Page 1 of 1 |

Tue, Nov 13, 2007 at 8:29:48 PM | Material cost per sq ft formula

#1

JAMESHGRIMES


site moderator|||
JAMESHGRIMES Avatar

Joined: Fri, Apr 14, 2006
584 Posts
4.5 Stars: 10 Votes


Hey Revit users,

I just figured out how to get around the "Inconsistent Units" error in some formulas. I was trying to figure out a material cost per sq ft formula.

I set up a calculated value in a material takeoff and wrote the following as the formula.

Total cost = (Material: Area/1) * Material: Cost.

I put the area/1 to return a "number" type instead of an "area" type and that allowed me to multiply the result in the parenthesis by the cost parameter. You can use a similar method to figure total cost and unit cost in the same schedule.


This user is offline

 

Wed, Nov 14, 2007 at 7:18:18 AM | Material cost per sq ft formula

#2

coreed


site moderator|||
coreed Avatar

Joined: Fri, Feb 10, 2006
1874 Posts
4 Stars: 16 Votes


what you are talking, Revit recommends doing it this way:

For Formula, enter Material: Area*Material: Cost /(1'^2).

The /(1'^2) is required to remove the formatting of the fields so the cost estimate value can be calculated.



Attached Images

29795_cost.bmp

-----------------------------------

best regards,

coreed,aia

bmpArchitects,Inc.

"Revit has to be implemented, Not installed." 

Long Live Revit

This user is offline

 

Wed, Nov 14, 2007 at 8:42:35 AM | Material cost per sq ft formula

#3

JAMESHGRIMES


site moderator|||
JAMESHGRIMES Avatar

Joined: Fri, Apr 14, 2006
584 Posts
4.5 Stars: 10 Votes


Just because one way is "recommended" doesn't mean that it is the only way. I just posted this as an alternative method that maybe someone can understand better, I know I did. Also I'm fairly certain you can use this formula for both imperial and metric units without typing any other syntax.

This user is offline

 

Wed, Nov 14, 2007 at 9:10:22 AM | Material cost per sq ft formula

#4

coreed


site moderator|||
coreed Avatar

Joined: Fri, Feb 10, 2006
1874 Posts
4 Stars: 16 Votes


i was just posting the Revit recommendation as an alternative method like you said. there's always more than one way to do anything. that's why will have sites like this. i sure someone will post a different method, and on and on.

 


-----------------------------------

best regards,

coreed,aia

bmpArchitects,Inc.

"Revit has to be implemented, Not installed." 

Long Live Revit

This user is offline

 

Wed, Nov 14, 2007 at 6:51:30 PM | Material cost per sq ft formula

#5

perthmod1


active

Joined: Tue, Sep 4, 2007
8 Posts
5 Stars: 1 Votes


When i enter that code into Revit Architecture 2008 i get a invailid message. And which schedule are you meant to do that in?

 



Attached Images

29855_f.bmp

This user is offline

 

Fri, Nov 16, 2007 at 6:42:04 AM | Material cost per sq ft formula

#6

JustinT


active

Joined: Fri, Nov 16, 2007
93 Posts
5 Stars: 1 Votes


http://www.revitup.co.za/_mgxroot/page_10829.html

 


This user is offline

 

Wed, May 6, 2009 at 9:16:15 AM | Material cost per sq ft formula

#7

homebrew


active
homebrew Avatar

Joined: Thu, Aug 28, 2008
7 Posts
5 Stars: 1 Votes


Thanks James and coreed

I was just playing around with both methods and was wondering  why i was getting the wrong answers with the revit Recommended method. the answer was with the 1' in the Material: Area*Material: Cost /(1'^2) . Its Impirial, where as i do not use that so if your using metric the1' will have to be replaced with your metric units, in my case 1000mm. Oh and there is no fullstop in either formula, that got me on both :-/


This user is offline

 

Mon, Sep 21, 2009 at 9:06:24 AM | Material cost per sq ft formula

#8

bazar


active
bazar Avatar

Joined: Tue, Jul 31, 2007
33 Posts
No Rating


This was just what I was looking for...thanks guys

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Material Cost Analysis in Schedules

Revit Building >> Technical Support

Wed, Jan 13, 2010 at 6:55:37 PM

0

formula for schedules

Revit Building >> Technical Support

Thu, Mar 22, 2012 at 11:06:24 AM

3

I want to know how can I calculate the total cost with revit???

Revit Building >> Technical Support

Sun, Mar 31, 2013 at 12:02:26 PM

6

Creating wall schedules??

Revit Building >> Technical Support

Tue, Dec 14, 2010 at 5:32:23 AM

1

Cost Modelling Schedule

Revit Building >> Technical Support

Fri, Jan 30, 2009 at 10:05:09 AM

3

Site Stats

Members:

1988727

Objects:

22877

Forum Posts:

152178

Job Listings:

3

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

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights