Results 1 to 5 of 5

Database Spreadsheet with Multiple Variables

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2015
    Location
    West Michigan
    MS-Off Ver
    13
    Posts
    17

    Cool Database Spreadsheet with Multiple Variables

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 11-29-2016, 07:21 AM
  2. Database Query-possible to link a spreadsheet to a database
    By COYF in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-04-2010, 09:37 AM
  3. Extracting Data from ERP Database based on 2 variables in Spreadsheet...cont'd
    By NBVC in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 01-11-2010, 01:09 PM
  4. [SOLVED] Formula for counting multiple variables in a spreadsheet
    By smorgan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-25-2006, 01:15 AM
  5. Searching for variables in excel database
    By Gavin77 in forum Excel General
    Replies: 0
    Last Post: 08-02-2005, 10:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1