+ Reply to Thread
Results 1 to 2 of 2

dividing baseball cards porportionally to n-number of buyers contributing various $'s

  1. #1
    Registered User
    Join Date
    12-16-2003
    Posts
    5

    Cool dividing baseball cards porportionally to n-number of buyers contributing various $'s

    Hi guys,

    It started out as just a fun idea, working with numbers and baseball cards, but afer i figured out how to do it with 2 people, i wanted to move it up to n-people, and i got stumped...

    here's the scenario:
    If you and a friend want to buy 100 baseball cards for $100, and you put in $80, and he puts in $20, how many baseball cards should each of you get so that it would be fair and porportional (it wouldn't be fair for your friend to spend $20 dollars on 20 baseball cards if you had to pay the same price per card for 4 times as many!)

    Basically, the first spreadsheet works it out so that the person who spent $80 would recieve 92 cards, and the person who spent $20 would get 8.

    I would like a spreadsheet that could do this with n-contributors... I've included what i've done, but have got stuck and have gone in circles!

    Any ideas? I appreciate any tips/suggestions!... or if you want to give it a shot, maybe you could figure it out ;-)
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-16-2003
    Posts
    5
    morning bump

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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