RunRyder RC
WATCH
 1 page 551 views POST REPLY
HomeOff Topics › Excel question
06-19-2015 12:43 PM  3 years agoPost 1
RayJayJohnsonJr

rrKey Veteran

Midwest

My Posts: All  Forum  Topic

Not being an Excel user, perhaps Excel isn't what I need to do this, but...

Going thru some of Dad's stuff after his passing, and came to a small coin collection. There are four of us kids to divide it amongst. I was thinking of entering the coin and it's value in a spreadsheet. Is there a way, after all the coins are entered, to divide the coins into 4 equally valued (or as close as one could get) groups?

There, their and they're. It's really that simple.

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 01:46 PM  3 years agoPost 2
jerseyheli

rrNovice

NJ, FL

My Posts: All  Forum  Topic

I would divide the coins by value i.e all the $100 coins together, all the $50 coins together etc. Then divide each stack equally by four, after that you'r equally divided by four. No need for Excel, just a calculator

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 02:39 PM  3 years agoPost 3
GREYEAGLE

rrElite Veteran

Flat Land's

My Posts: All  Forum  Topic

Put them in a Pile in the Center of the ROOM ! Pile of GOLD

Maybe handicap the strongest and devise a way to give favor or a advantage to the weakest : HEad Start or Something

Put a Ref in their TOO and PAY HIM WELL : The ONE with WIZDOM

Make sure the Promoter or organizer gets a commission ! for handling the Gold Coin's

If you need ADVICE - GET"S LOT of it - from the Culturally SPLIT -

Blow the HORN and GO AT IT - Toot !

NO Figure Four head Lock's or Choking or Leaping off the Top Rope -

It is VALUABLE !!!! This was Dad's Favorite !

greyeagle

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 04:49 PM  3 years agoPost 4
ticedoff8

rrKey Veteran

Morgan Hill, CA. USA

My Posts: All  Forum  Topic

This is a math question, and I assume Excel could be made to figure it out.

But, the solution only partially involves math. The final solution will involve the personalities and the perception of fairness.

If you list all the coins and their values, you could easily sort the list from highest to lowest.
And that is the starting point.

Then then question becomes how to divide it "equally" and fairly between 4 personalities (people).

If you find that the value of the total collection is $100,000, this is only relevant if you sold the collection and then divided the proceeds between the 4 personalities.

But, if you try to divide the collection, it becomes more about "fairness" and how that relates to value.
This relates to the value of the individual coins.
A specific coin might be valued at $10,000 and there is only 1.
Another specific coin might be valued at $100, but there are 50.
This goes on and on for all the coins in the collection.

How do you divide that?

One person may say "Well, the $10,000 has peaked in value, and I don't want it" while another may say "Well, the $10,000 coin has bottomed out and will skyrocket over the next 10 years - why didn't I get it?"

My advice; Sell the entire collection through a reputable dealer and then split the proceeds 4 ways.

Believe 1/2 of what you see and none of what you hear.
Fake News will be the downfall of our Republic!

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 05:31 PM  3 years agoPost 5
RayJayJohnsonJr

rrKey Veteran

Midwest

My Posts: All  Forum  Topic

Sell the entire collection through a reputable dealer and then split the proceeds 4 ways.
Selling the collection is unacceptable. It spans 4 generations. Family history supersedes cash value. Just looking for a way to split it evenly among four people. Trying to guess what a coin might be worth tomorrow or ten years from now is irrelevant in this situation. Not looking at it with 'investment' eyes.

There's an app for iPhone called HeirSplit that could work. I don't own anything that says Apple on it. Don't find an Android or Windows version of it anywhere.

Still looking.

There, their and they're. It's really that simple.

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 05:46 PM  3 years agoPost 6
GREYEAGLE

rrElite Veteran

Flat Land's

My Posts: All  Forum  Topic

It's a QUESTION of the HEART - Not Material Value :

The memories of a BE Loved Father and the Family Heritage

Who Can be Trusted to Carry On the Memories of the Father / His Love / His Heritage ; His Teaching too the Sibling's ??

WOULD HE of Recommended to Cut UP Linage for Distribution and scatter it like Salt ?

It is a Value Issue of the HEART and WHOM can be trusted to carry it Forward for Future generation - Who has the HEART of Your Father ??

You WILL SO DISCOVER

greyeagle

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 06:11 PM  3 years agoPost 7
ticedoff8

rrKey Veteran

Morgan Hill, CA. USA

My Posts: All  Forum  Topic

Family history supersedes cash value. Just looking for a way to split it evenly among four people. Trying to guess what a coin might be worth tomorrow or ten years from now is irrelevant in this situation. Not looking at it with 'investment' eyes.
Well said.

I expect you have talked through this with the other three parties and they agree "cash value" is irreverent.

In that case, put all the coins on a table and let the 4 people take their choice based on the sentimental value.
I am sure that will work out well.
And, it will not require an app or a spreadsheet.

As you say, "Family history supersedes cash value".
So there is no point in figuring out their cash value.
Good luck.

Believe 1/2 of what you see and none of what you hear.
Fake News will be the downfall of our Republic!

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 06:56 PM  3 years agoPost 8
RayJayJohnsonJr

rrKey Veteran

Midwest

My Posts: All  Forum  Topic

As you say, "Family history supersedes cash value".
So there is no point in figuring out their cash value.
Good luck.
That may be what you read, however that's not what I said. Family history supersedes cash value in that the collection WILL NOT be sold for cash and split up based on it's a family heirloom.

Present value, based on a guide like "A Guide Book of United States Coins 2016", or similar, and evenly divided into four equal value groups, and BLINDLY split amongst the four. FAIR.

Anyway, yes I can do this by hand. Short of buying an apple product to run the aforementioned app, I was hoping to find an easier way.

There, their and they're. It's really that simple.

PM  EMAIL  GALLERY  Attn:RR  Quote
06-19-2015 08:27 PM  3 years agoPost 9
Xterra

rrApprentice

USA

My Posts: All  Forum  Topic

A small AWK script will suffice using a CSV file as input.
PS. Just curious, how many coins?


Stratus
Raptor 50V2
T-rex SE
T-rex CDE
T-rex 250 SC
Kyosho M24

PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
06-19-2015 09:05 PM  3 years agoPost 10
jcrack_corn

rrVeteran

End of Time

My Posts: All  Forum  Topic

It *may* be possible in excel. But it is TRIVIAL for a scripting language based math tool. You should post a flier in the local universities math or csc dept billboard...should just be a few lines of code to organize 4 groups with equal value....just a sort with parameters

------------------------------------------------------------------
do it inverted
------------

PM  EMAIL  Attn:RR  Quote
06-19-2015 10:03 PM  3 years agoPost 11
Xterra

rrApprentice

USA

My Posts: All  Forum  Topic

Do you have the excel file template? AWK or PERL can get it done in no time. Heck, even SED might be sufficient


Stratus
Raptor 50V2
T-rex SE
T-rex CDE
T-rex 250 SC
Kyosho M24

PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
WATCH
 1 page 551 views POST REPLY
HomeOff Topics › Excel question
 Print TOPIC  Make Suggestion 

 1  Topic Subscribe

Sunday, August 19 - 10:44 am - Copyright © 2000-2018 RunRyder   EMAILEnable Cookies

Login Here
 New Subscriptions 
 Buddies Online