+ Reply to Thread
Results 1 to 1 of 1

Modified Stable Marriage Problem Solution using Excel macros?

  1. #1
    Registered User
    Join Date
    08-27-2019
    Location
    Florida
    MS-Off Ver
    2019
    Posts
    1

    Question Modified Stable Marriage Problem Solution using Excel macros?

    Hello All - So I saw this post about solving the Stable Marriage Problem in Excel/VBA and was curious to see if it could be modified for a more adaptive use for a project I am starting to work on.

    In the above scenario, you already know the names/preferences of the individuals from the start. Would it be possible to tweak this to work if the names and preferences aren't known from the beginning?

    What I am trying to do:
    • Have users enter their name and preferences that will be recorded in an SQL database
    • Export the data as CSV and open in Excel
    • Have the macro function like above (matching the individuals based off their preference) but changed based off of the data provided from the SQL db
    • Show the matching pairs on a case by case basis (aka each time a new data set is imported)

    I do have some coding experience, but not much in Excel/VBA but thought it would be cool to extend my reach. Any help or tips (if something like this is even possible) are much appreciated!

    Here is an image of how the data would be imported into Excel:
    Attached Images Attached Images

+ 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. Gale Shapley matching (Stable Marriage problem)
    By tshobe in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-12-2019, 04:38 AM
  2. Solution for macros and web queries Excel online.
    By mxkr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2017, 05:37 AM
  3. Help : Problem Pivot Not Stable...
    By Jhon Mustofa in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-24-2017, 04:52 AM
  4. Excel macro problem solution...
    By axabrt in forum Excel General
    Replies: 1
    Last Post: 01-17-2009, 12:41 PM
  5. Small problem, do we have a solution in excel???
    By kumbhatalok in forum Excel General
    Replies: 1
    Last Post: 01-16-2007, 02:30 AM
  6. Are Macros Safe as a solution to Excel sheet problems
    By Mubbu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2006, 08:10 AM
  7. Macros in Excel(probably a simple solution)
    By MrDarcy in forum Excel General
    Replies: 2
    Last Post: 12-14-2005, 10:54 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