Results 1 to 4 of 4

Solver configuration for a fairly complex sheet.

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2022
    Location
    Helsinki, Finland
    MS-Off Ver
    O365
    Posts
    5

    Cool Solver configuration for a fairly complex sheet.

    Hi folks!

    I need 2 level ones to get 1 level two. 2 level twos to get 1 level three. 2 level threes to get 1 level four, and so on.
    Formula for number of level ones to get 1 of level N is: X = 2^(N-1).
    I got this built on a sheet and now I need to find minimum number of level ones to get 1 level N having certain numbers of level K's between level 1 and level N.

    I tried Goal Seek and it finds a solution but it's not minimum. Found out Goal Seek does not have feature to search for minimums.

    So I tried Solver. I set up objective and constraints but solution is not found. Instead I get Feasibility errors.

    I'm not familiar with Solver and my scenario might be erronous or maybe the sheet is too complex. Could someone please check the setup on workbook attached.

    Any help highly appreciated, thanks in advance
    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: 1
    Last Post: 04-01-2020, 04:56 PM
  2. Fairly complex - matching "siblings" and "parents" across sheets
    By michael.sejrup in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-09-2016, 01:24 AM
  3. Solver - complex functionality
    By Adsup01 in forum Excel General
    Replies: 5
    Last Post: 10-27-2016, 08:29 AM
  4. Configuring a pivot from an unknown configuration to desired configuration
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2015, 11:14 AM
  5. Replies: 3
    Last Post: 04-23-2013, 06:49 PM
  6. I keep getting random bugs in a fairly complex code (for me neways)... works sometimes tho
    By Legend Rubber in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2013, 08:39 AM
  7. Fairly Complex IF Statement
    By Patrick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2005, 05:06 PM

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