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 ;-)
Bookmarks