+ Reply to Thread
Results 1 to 9 of 9

SOLVED - Employee Tip Pool Calculator

  1. #1
    Registered User
    Join Date
    11-19-2019
    Location
    Here
    MS-Off Ver
    2007
    Posts
    2

    SOLVED - Employee Tip Pool Calculator

    I'm looking for a way to automatically split an employee tip pool. I start with a dollar value which is total tips. That is split between 15 people based on their shift hours versus the total hours of everyone on shift that day. That is all simple.

    The issue is then that I want each person's percentage of tips to be automatically split based on the coins that are available giving everyone the maximum in large bills/coins (ex. 100, 50, 20, 10, 5, 2, 1, 0.25, 0.1, 0.05).

    I'm sure that someone has created something like this before but search leads to only ways to split a check between restaurant customers.
    Attached Files Attached Files
    Last edited by nervousnerd; 11-22-2019 at 07:35 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Employee Tip Pool Calculator

    crossposted: https://www.mrexcel.com/board/thread...lator.1115765/

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-19-2019
    Location
    Here
    MS-Off Ver
    2007
    Posts
    2

    Re: Employee Tip Pool Calculator

    May be solved. Apologies for the cross posting. Can't post link to solution because I am not allowed to post links yet.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Employee Tip Pool Calculator

    I have a workbook that does this:

    B
    C
    D
    E
    F
    G
    H
    2
    1. Event
    Tony Romo's Wedding
    3
    2. Date
    28 May 2011
    3. Tip
    $ 3,000.00
    4
    5
    4. Roles
    5. Share
    by Role
    6. Name
    7. Role
    8. Time Worked
    9. Tip-Out
    6
    Kahuna
    4
    Alan Kahuna
    6:00
    $ 473.68
    7
    Bartender
    3
    Barb Bartender
    6:00
    $ 355.26
    8
    Host
    3
    Cain Bartender
    6:00
    $ 355.26
    9
    Server
    2
    Dana Bartender
    4:00
    $ 236.84
    10
    Busser
    1
    Eric Bartender
    3:00
    $ 177.63
    11
    Runner
    1
    Fran Host
    3:00
    $ 177.63
    12
    Gary Host
    3:00
    $ 177.63
    13
    Hana Server
    6:00
    $ 236.84
    14
    Ivan Server
    5:30
    $ 217.10
    15
    Jane Server
    3:00
    $ 118.42
    16
    Kent Server
    3:00
    $ 118.42
    17
    Leah Busser
    6:00
    $ 118.42
    18
    Mark Busser
    5:00
    $ 98.68
    19
    Nina Runner
    3:00
    $ 59.21
    20
    Otto Runner
    4:00
    $ 78.94
    21
    22
    23
    24
    25
    Total shares
    14
    26
    Total share-hours
    152:00
    Total Hours and Tip-Out
    66:30
    $ 2,999.96


    I'll post if you're still interested.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    07-29-2019
    Location
    Australia
    MS-Off Ver
    Online
    Posts
    1

    Re: Employee Tip Pool Calculator

    Id totally like a copy of that workbook if poss!

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: SOLVED - Employee Tip Pool Calculator

    @nervousnerd

    You can manually type the link. You cannot copy and paste it until you have more posts.

  7. #7
    Registered User
    Join Date
    03-10-2021
    Location
    charlotte, nc
    MS-Off Ver
    current
    Posts
    1

    Re: Employee Tip Pool Calculator

    how can I get a copy of that tip out spreadsheet? Thanks

  8. #8
    Registered User
    Join Date
    10-17-2021
    Location
    North Vancouver
    MS-Off Ver
    2019
    Posts
    2
    Quote Originally Posted by nervousnerd View Post
    I'm looking for a way to automatically split an employee tip pool. I start with a dollar value which is total tips. That is split between 15 people based on their shift hours versus the total hours of everyone on shift that day. That is all simple.

    The issue is then that I want each person's percentage of tips to be automatically split based on the coins that are available giving everyone the maximum in large bills/coins (ex. 100, 50, 20, 10, 5, 2, 1, 0.25, 0.1, 0.05).

    I'm sure that someone has created something like this before but search leads to only ways to split a check between restaurant customers.
    Hi, this is also what I've been looking for. Did you ever find a spreadsheet that calculates the split based upon the coins and bills? If so, can you share it with me? Thanks!

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: SOLVED - Employee Tip Pool Calculator

    Dunno if this is what you're looking for ...
    Attached Files Attached Files

+ 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. Employee cost calculator Excel workbook needed?
    By jw01 in forum The Water Cooler
    Replies: 1
    Last Post: 03-26-2019, 12:39 AM
  2. Replies: 1
    Last Post: 02-16-2018, 10:52 AM
  3. Macro based employee productivity calculator for Banking / Finance Industry
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2017, 06:05 AM
  4. convert multiple employee records to one record per employee
    By jmccullough in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2016, 10:39 AM
  5. Generate output employee data from input employee sheet
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 05:28 PM
  6. California hourly employee time calculator
    By alwayskristie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2013, 09:27 PM
  7. Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 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