done using vlookup...... refer attached file....
On Tue, Dec 28, 2010 at 8:18 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi J D, > > It would be really appreciable if you can share a test file on this. Help > us to help you :) > > Best Regards, > DILIPandey > > On Tue, Dec 28, 2010 at 7:36 AM, J D <springer...@gmail.com> wrote: > >> 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 >> > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > ---------------------------------------------------------------------------------- > 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 > -- Srinivasan Ethirajalu, +919677042736 -- ---------------------------------------------------------------------------------- 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
sft.xls
Description: MS-Excel spreadsheet
