+ Reply to Thread
Results 1 to 4 of 4

Seat/Table Joins

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    IOM, UK
    MS-Off Ver
    Microsoft 365
    Posts
    31

    Seat/Table Joins

    Hello, we have the following seats available and we want to sell to the public whether it be for one seat or 60.

    The idea is that should a person want to book say 16 seats as one reservation, the 'seat joins' must be able to work out which ones are left for capacity.

    The seat number is irrelevant as we will put parties together as they booked, what we need to do though is tell the system which seats to join based on the group requirements, meaning all the seats are sold.

    Seat numbers below numbered 910 - 969, 60 seats in total and example would be, if 910-917 had been sold to a group of eight, the system would need to know to book from there on.

    What we don't know is how many will be in each group that books, so although we can say join 910, 911, 912, 913, 914, 915, 916 & 917 for a group of eight, we need to know every possible join for every possible group number, also considering what seats may have already been sold.

    Is this possible.....?!? PLEASE! Thank you.

    910 920 930 940 950 960
    911 921 931 941 951 961
    912 922 932 942 952 962
    913 923 933 943 953 963
    914 924 934 944 954 964
    915 925 935 945 955 965
    916 926 936 946 956 966
    917 927 937 947 957 967
    918 928 938 948 958 968
    919 929 939 949 959 969

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: Seat/Table Joins

    See attached is one approach: will need further code but it shows the principle.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 12-06-2022 at 01:58 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    06-26-2015
    Location
    IOM, UK
    MS-Off Ver
    Microsoft 365
    Posts
    31

    Re: Seat/Table Joins

    Hello John, thank you for your reply, apologies for the delayed response, I did not notice a notification on this one.

    I don't think I was clear with my description, sorry about that, in the booking system that we have, I cannot import a spreadsheet unfortunately.

    The formula I'm looking for is, every possible combination of joining the seats regardless of what numbers/seats are left.

    i.e. a party of four book 910, 911, 912, 913 are joined, then a party of 3 book, 916, 917, 918, if a party of two look to book then the would join 914, 915.

    The software needs to be told of every possible 'join' as each seat is individually sold and we don't want spare seats left.

    I hope that makes more sense and you may still have a solution for us!?!

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: Seat/Table Joins

    Way above my pay scale if you want that level of "sophistication" but I don't understand ......

    I cannot import a spreadsheet unfortunately.


    nor

    every possible combination of joining the seats regardless of what numbers/seats
    so why are you asking about Excel ?
    Last edited by JohnTopley; 02-08-2023 at 12:35 PM.

+ 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. [SOLVED] Seat location range to individual rows per seat
    By MissyEagen in forum Excel General
    Replies: 1
    Last Post: 05-02-2022, 11:47 AM
  2. Replies: 1
    Last Post: 09-18-2017, 01:54 AM
  3. [SOLVED] Seat auto asignment Help!
    By macnabong in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-06-2017, 10:38 AM
  4. Seat allocation with Date & Time
    By jayexcel1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-10-2014, 11:44 AM
  5. Seat number not found
    By jakeembx in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-14-2013, 02:29 PM
  6. Seat position finder, Indian Railway.
    By sreejith K K in forum Excel Tips
    Replies: 6
    Last Post: 07-15-2012, 02:45 PM
  7. Seat Plan
    By natski in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-05-2006, 05:20 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