+ Reply to Thread
Results 1 to 2 of 2

Can I create a questionair to create an estimate with formulas?

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    US
    MS-Off Ver
    365
    Posts
    1

    Can I create a questionair to create an estimate with formulas?

    My first problem is I don't even know what I need.

    I'm trying to streamline my estimating process. I would like to have a questionnaire when I first open the template with basic info like project name, address... also square footage. It would also have flow charts that would operate based on check boxes selected. Those boxes would then populate new questions based on the prior selections.

    On a separate sheet I would like to list my material costs. The material lists would be separated by supplier. I can send the list to the supplier and they would return the form with current pricing. I would then cut and paste to update my price list.

    Then based on my selected systems and materials it would then auto populate an estimate.

    So my main question is can you create a flow chart based on check boxes and create a list?

  2. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Can I create a questionair to create an estimate with formulas?

    Hi there - and welcome to the forum. Your first sentence really sums this up - you need to decide what you need, and how you're going to get there. You could do this numerous ways... you could get basic data in one worksheet, then move on, wizard-style, to the next etc. Alternatively, you could use userforms to input info about your customer's needs, do the calculations using material and labour costs calculated from data on separate worksheets...

    Before anyone is likely to help, your thread title doesn't really convey what the problem is. The short answer to your question is "yes". I'd suggest changing the thread title to something more meaningful - then, in addition to complying with forum rule #1 (Title must briefly summarize your request), you're more likely to get some helpful suggestions.

    Additionally, if you attach a copy of what you've already got or an idea (roughly) how it should look, we can take it from there. See the yellow band at the top of the page for details.

    Tim
    Never stop learning!
    <--- please consider *-ing !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-01-2016, 06:28 AM
  2. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  3. create a master list from a estimate
    By rkshelburne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2013, 01:23 AM
  4. Point Estimate
    By smallexcel in forum Excel General
    Replies: 1
    Last Post: 08-12-2012, 03:48 PM
  5. Help
    By Rawly in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 05-22-2012, 07:20 AM
  6. Finding point estimate and interval estimate
    By Codedzero in forum Excel General
    Replies: 1
    Last Post: 10-11-2009, 02:46 PM
  7. [SOLVED] Trying to create a Sales Projection/Forecast/Estimate
    By S L Pace in forum Excel General
    Replies: 3
    Last Post: 03-30-2005, 10:06 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