+ Reply to Thread
Results 1 to 3 of 3

Payout speadsheet

  1. #1
    Registered User
    Join Date
    10-17-2021
    Location
    North Vancouver
    MS-Off Ver
    2019
    Posts
    2

    Payout speadsheet

    Hello!

    I'm looking for a currency / payout spreadsheet where you list the total number of bills and coins you have (example, 5x$100 bills, 3x$50 bills, 20xquarters, 10xdimes, 5xnickels) and then calculates how many of each should be given to 30 employees based upon a payout amount.

    So for example, I have $2537.82 to split between 30 employees, I denominations of bills and coins. Each employee receives a different percentage of this money based upon weightings that were previously calculated on another spreadsheet. Let's say the top payout is $161.42 all he way down to $12.11. I need a spreadsheet that will tell me how many of each bill and coin each employee should get, ensuring the highest paud employees get more hundreds, fifties, twenties, etc, and keeping the payouts fair so that all employees receive a fair amount of bills and someone doesn't get all coins. Does this make sense?

    In case you haven't figured it out, this is meant for a tip pool calculation at a restaurant that divides cash to 30 employees, and I'm tired of having to spend an hour manually splitting and dispursing the cash every two weeks. Thanks!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Payout speadsheet

    Hi
    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Payout speadsheet

    Perhaps you could utilize the following in some manner ...

    Please Login or Register  to view this content.


    See the two attachments ....
    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. Golf skins payout
    By dimples in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 10-09-2018, 01:08 PM
  2. Investment Payout Calc.
    By fhxfhx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2016, 07:05 AM
  3. Payout ties
    By FivestarMac in forum Excel General
    Replies: 6
    Last Post: 01-20-2014, 11:07 AM
  4. Payout Calculation
    By Frank1000 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-07-2014, 02:14 PM
  5. Poker Payout Calculator
    By Ridgy in forum Excel General
    Replies: 3
    Last Post: 01-11-2010, 09:39 PM
  6. Life Insurance - Top Payout
    By jackla12 in forum Excel General
    Replies: 0
    Last Post: 08-23-2006, 07:40 AM
  7. [SOLVED] How to make a payout table
    By Chris Barnes in forum Excel General
    Replies: 4
    Last Post: 09-20-2005, 12:05 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