+ Reply to Thread
Results 1 to 4 of 4

Answering a couple of variables to get the answer to an equation

  1. #1
    Registered User
    Join Date
    11-27-2019
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    4

    Answering a couple of variables to get the answer to an equation

    Hey guys,

    I'm trying to make a interactive Excelsheet, where the user is able to answer a couple of questions and is given a set result for that combination of answers.

    The user answers the following questions with a list of variables:
    -Client (7 options)
    -Standard (depends on client, up to 20)
    -(optional) substandard (depends on standard, up to 10)
    -Material (50 materials)

    The user also answers the following yes/no questions:
    -coating
    -glued
    -cleanroom
    -REIN1VOOR
    -REIN1NA
    -REIN2
    -EXT
    -IPA
    -Oven
    -Clean

    As you can see this gives a long list of possibilites. Some of these questions affect one another in a certain way. Is it possible to make this, without creating a excelsheet with 700.000 rows?

    The attachment shows how it would work in a simple manner. The first tab consists of the field of variables and the other tabs would 'carry' the possible combination of answers.

    In what way would I be able to make a list of answers without manually answering the questions 700.000 times? Would that even be possible?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-22-2019
    Location
    Qatar
    MS-Off Ver
    2013
    Posts
    12

    Re: Answering a couple of variables to get the answer to an equation

    Hi,
    I got your problem, but i need some more clear example, if is it possible to fill at-least 3 clients by manually to better understand?

  3. #3
    Registered User
    Join Date
    11-27-2019
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    4

    Re: Answering a couple of variables to get the answer to an equation

    I've changed the file to be a little more clear. An example is given of a combination of variables, which gives a certain answer to the equation.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-27-2019
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    4

    Re: Answering a couple of variables to get the answer to an equation

    Sorry didnt reply to you, see above

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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