+ Reply to Thread
Results 1 to 3 of 3

How to make this spreadsheet more user friendly for entering data

Hybrid View

  1. #1
    Registered User
    Join Date
    12-04-2016
    Location
    Melbourne, Australia
    MS-Off Ver
    2013
    Posts
    2

    How to make this spreadsheet more user friendly for entering data

    The attached spreadsheet is for a betting calculation based used on our local golf competition and is a win only basis with the formulas correct and the spreadsheet works but needs to be tidied up and maybe made more user friendly. There are 12 starters and a maximum of 12 people who may wager a bet on any or all of the 12 starters.

    Appreciate any suggestions.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-25-2014
    Location
    Pennsylvania, US
    MS-Off Ver
    Windows '16
    Posts
    165

    Re: How to make this spreadsheet more user friendly for entering data

    Definitely some room for improvement. I think everything is calculated as you would like but the original is indeed confusing (there are 3 columns that calculate the same value) so I would double check everything here.

    Enter names in column B and they should update everywhere. Enter bets in the yellow cells.

    You can add borders, shading, additional row height, etc. to make the grid easier to read. Hopefully this helps.

  3. #3
    Registered User
    Join Date
    12-04-2016
    Location
    Melbourne, Australia
    MS-Off Ver
    2013
    Posts
    2

    Thumbs up Re: How to make this spreadsheet more user friendly for entering data

    Hi JYTS,

    Thanks heaps the spreadsheet is now much clearer and easier to use.

+ 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. simple user-friendly spreadsheet for some 1st-grade teachers
    By redskyluv in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2016, 06:51 AM
  2. Error Handling - make macro more user friendly
    By jtn260 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-09-2014, 01:35 PM
  3. Replies: 3
    Last Post: 01-07-2013, 06:40 PM
  4. Making a spreadsheet user friendly
    By quiggdavid in forum Excel General
    Replies: 10
    Last Post: 03-30-2011, 07:18 PM
  5. User friendly view of large data set
    By salk31 in forum Excel General
    Replies: 0
    Last Post: 07-02-2010, 07:19 AM
  6. Tracking OT, trying to make it user friendly..
    By impala096 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-27-2008, 10:55 AM
  7. Anyone know where I can find free VBA code for a user-friendly financial spreadsheet
    By Abraham.Olson@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2006, 01:50 PM

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