+ Reply to Thread
Results 1 to 6 of 6

Creating a bookings diary on excel

  1. #1
    Registered User
    Join Date
    02-18-2019
    Location
    Wales
    MS-Off Ver
    office365
    Posts
    3

    Creating a bookings diary on excel

    I am trying to digitalise a booking system, can someone help please?
    I am an agent for a skipper who runs boat trips - I need to create the equivalent of a handwritten bookings diary (which I have used or many years)
    Each day needs up to 6 different trip types, no one day has the same times that they start. Some are one hour, some 2 and some 3. Each one fits up to 12 people on, which can be booked by singles, or families etc
    Each booking needs to record the time it starts, the type of trip (length etc), name, contact number, number of people in that group, whether they are adults or children (different price for kids),the total cost, the addition of a small booking fee, the total they paid and if the trip has to be cancelled due to inclement weather-the total that was then refunded. Each trip then needs a total number of people that are booked in.
    THe total figures for the day then need to be added up into a settlement document to reconcile what is paid to the skipper.
    As you can see it is rather complicated! I have messed around with some spreadsheets but someone suggested maybe Access would be better?
    I cannot seem to find any advice online as its difficult to know what to describe it as!
    Can anyone please help?
    Thank you!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,473

    Re: Creating a bookings diary on excel

    Welcome to the forum!

    What you are describing is a complete project. How much are you looking for help and how much for someone to create a solution for you?

    To me, what you have described would be better suited to an Access database.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    02-18-2019
    Location
    Wales
    MS-Off Ver
    office365
    Posts
    3

    Re: Creating a bookings diary on excel

    I am unfamiliar with Access, so don't know its capabilities, unfortunately I don't have funding to throw at this as it doesn't create a huge revenue for me. More info on what you would suggest would be appreciated please

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,473

    Re: Creating a bookings diary on excel

    Well, you mentioned Access, so I thought it was a consideration! Sorry.

    If you are wanting someone to create a solution for you (and you have not actually answered that question), then we have the commercial services section. There you can purchase points to offer someone to do the job for you - we are not talking big money, but enough as an incentive to the volunteers who man these boards.

    If you don't wish to do that, then you will need to mock up (manually) a spreadsheet showing the sort of thing you wish to achieve, and then you can get gradual help to realise it, but I should warn you that this could take some considerable time if you are not particularly au fait with Excel.

    Perhaps you could let us know?

  5. #5
    Registered User
    Join Date
    02-18-2019
    Location
    Wales
    MS-Off Ver
    office365
    Posts
    3

    Re: Creating a bookings diary on excel

    Thank you for your help, are we talking about 1's or 100's?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,473

    Re: Creating a bookings diary on excel

    Well, it's difficult to say, but the highest payment that has been made on there this year so far is 60 points (which is 60). Most issues are resolved at 20-30 points. It really rather depends on the people who help there and what they think it might be worth - they would base their recommendation on the amount of time they think it would take to achieve.

    Sorry this is a bit vague, but it would not be me offering the help, so I can't say for sure.

+ 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. Excel Diary Project Code Lookup
    By jamesjhhill in forum Excel General
    Replies: 11
    Last Post: 03-26-2014, 10:38 AM
  2. [SOLVED] using excel for home based symptoms diary
    By preventhospitalvisit in forum Excel General
    Replies: 4
    Last Post: 04-29-2013, 02:16 PM
  3. [SOLVED] Add Appointments to Common(!) Diary. Working Macro for Personal Diary included.
    By Slone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2013, 12:50 PM
  4. Replies: 1
    Last Post: 12-21-2012, 04:18 AM
  5. Excel Daily Diary
    By Zahhhaaaa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-30-2011, 01:05 PM
  6. Excel daily diary
    By Zahhhaaaa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2011, 08:17 AM
  7. Excel diary ?
    By Zahhhaaaa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2011, 09:34 AM
  8. take dates from excel & book appiotment in outlook diary using mac
    By hen7247 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2006, 04:50 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