Trying to create an excel spreadsheet for HOME DEPOT products

[Nate Narcisse]

Hi BP family,

I'm trying to build a template excel spreadsheet, which would include products and pricing for materials from Home Depot. Also on this spreadsheet would be different labor rates from local contractors and the square footages of each material needed  (depending on the level of Rehab). I know every rehab/remodel is different. So I figure, the best way to go about it is to rehab for the worse case scenario, which would be a full gut remodel for every part of the house. That way, I could get an idea of the cost for the most work that could be done on a house, if that level of work was required. If the house doesn't need that much work, based on the comps, then I could simply deduct from the large rehab figure/estimate and call it a mid-size rehab or a light rehab. It would be nice to have all this information in one place, hence the spreadsheet. Not to mention, it would be a nice way to estimate accurate rehab cost and creating a budget ( once I get a measurement of each room). There's a few problems I'm currently facing: 

1) How do I go about getting that information and structuring the spreadsheet? (Home depot doesn't really have a price book for all the material they sell)

2) Would I have to manually redo/update the pricing, every time the prices change? (If this is the case, then I may hire a VA to do the work)

3) Am I better off going to a different material supplier for each individual product instead of Home Depot?

Any ideas?
 

[David Avery]

I would have Home Depot give you a $10,000 grant to promote their business products with you . Starters!

Home Depot also has their hands on contractors and product.  As does Lowe's.

@ when someone comes up to the counter and says, I need  my house insulated.  They are directed over to the service desk/pro desk and its in house product and vendors ( contractors).

But with the demand of contractors and the supply  product being so crazy the past year.  

I think it would be a up hill battle to do what your doing. 

If you want to accomplish your goal I would do the following.

1- talk to experts that Re Hab. Treat them to a steak dinner or more and pick their brains with 50-100 questions.

2- Its all about the bathrooms, kitchen, and overall condition of a house.  Square footage is not a very good rule.

3- In this political arena that we are in  sheet rock will go up to $30 a sheet within 90 days.  2x4 will triple.

Good luck