I am a concrete estimator who is trying to create some cut and paste
Estimate line items I can just grab from one spread sheet and paste in
to my estimate.
I was refining one and tried to use the IF function to pick the number
of labor hours based on sq footage. More s.f. and we are more
productive therefore less hours per s.f.
I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to
1,000 then .0275 hrs/s.f. >1,000 s.f. then .0225 hours/s.f.
I could get one working but wanted to know how to get more going
choises out of one formula. Attached is the assembly and the formula
below it.
Form, place and finish ~ (__) s.f. of 4" broom swept finish concrete
sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/
w1.4 wwf.
$4,410.00
Area 990 s.f. Perimeter 114 l.f.
Concrete 990 0.33 1.03 336.501 12.463 13 145 1885
Labor 13 0.4 5.2 5.2 40 208
wwf 990 40 24.75 25 7 175
2" SB 990 0.26 257.4 260 0.49 127.4
Labor 990 0.003 2.97 3 40 120
Poly 990 1800 0.55 0.6 85 51
Labor 990 0.002 1.98 2 40 80
Expansion 990 0.25 247.5 100 2.475 2.5 31.64 79.1
Labor 250 0.01 2.5 2.5 40 100
Curing 640 350 1.828571429 5 0.365714286 0.4 55
22
Labor 990 0.003 2.97 3 40 120
2 x 4 114 16 7.125 8 5.81 46.48
Labor 114 0.33 37.62 0.2 7.524 7.6 40 304
Finish 990 100 9.9 2.75 27.225 27.3 40 1092
4409.98
=IF(B16<500,3.5,2.75)
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
