I'm James, a retired law enforcement officer and I build Sun Decks using Wood Dimensional Lumber. I am also new to MS Office XP/Excel 2002 and a beginner...My latest task involves developing a workbook to figure Labor and Materials creating a Working Estimate from a Selectable Inventory List (list of dimensional lumber)(and the prices from 2 lumber yards). The selectable issue is that some people want Douglas-Fir, some want Pressure Treated lumber, and some want Redwood...! Also in the selectable list are the different sizes and lengths of the lumber(2x4, 2x6, 2x10, 2x12 etc., and the lengths 8', 10', 12' etc...) each stick of lumber has a different price..! The price varies up and down like all other things in this world. My Working Estimate sheet gives me more control on how a deck is priced out. Yet, I can not seem to link all the data together and get the calculations done that I need...
Basically, I want to be able to use my Working Estimate sheet to give a customer a hard copy of the Costs: Materials/Labor/Finish(Paint or Stain) and fasteners. Then, different size Decks require, different size lumber...making the "Selectable" function a God send..! I've been "playing" in it a lot and I've learned a lot, I'm simply lost in all the features Excel can use to compile data and calculate the end product...
Would anyone have any recommendations or suggestions that might help me....?
Thanks so much in advance, please feel free to contact me anytime.....James....
Bookmarks