Database Spreadsheet with Multiple Variables

[MVWest Michigan]

I am trying to build a spreadsheet that would allow me to prepare a conceptual cost estimate for construction. The problem I am having is that there are two databases to chose from based on the construction type. If the Construction Type selected is "Remodel" then the pricing should be based on one database, if the Construction Type selected is "New" or "Addition" then pricing is based on the other database.

To complicate things is that I am asking the client to select priorities for items, "1" being Low Priority, "2" being Medium Priority, and "3" being High Priority. These then drive the costs being used to calculate a project cost.

I am having a difficult time putting this all together. I have the formulas for the Priorities, but can't seem how to integrate the Construction Type question as a driver for the unit costs.

Any suggestions? I have attached the spreadhseet

[mahju]

Hi

Not much clear.

I can not see the second database.

where to add construction type?

You can Add 3 more column in the database table for new / Addition and use and / or with the formula You are using

Regards

[MVWest Michigan]

Sorry,

Attached is a cleaner copy of the spreadsheet. Priorities tab, Cell L3 contains the selection for construction type.

Thank you

[mahju]

Thanks for updated file

I have used construction type list box on Cost Model sheet cell O3. Change it as required

Please Login or Register  to view this content.

Also see Yellow in attached

Regards

[MVWest Michigan]

Mahju

Thank you for your assistance! This is exactly what I was trying to achieve.

MVWest Michigan