Academic challenge for advanced-users

[BrooksTech]

Heres an academic challenge. Unfortunately there's no prize other than Kudos and receiving credit for answering the challenge correctly:

1. CREATE A SPREADSHEET THAT WILL ANSWER THE FOLLOWING:

Youre trying to buy an item at a Vending Machine that costs 95 cents. The machine requires EXACT CHANGE ONLY. You do NOT have exact change and the change you have adds up to $1.15 (too much.)

Q. WHAT ARE THE NUMBER AND DENOMINATIONS OF COINS THAT YOU HAVE THAT RENDER $1.15 BUT YOU WILL NOT BE ABLE TO GET 95-CENTS FROM?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

(This challenge was originally introduced by CarTalk on 12/24) Good Luck!

 

[Norie]

A 96 cent piece and a 19 cent piece.

 

[Ron Coderre]

I sent my guess via private message...if the off-chance it's correct.

 

[BrooksTech]

CORRECTION AND LINK Re: Academic challenge for advanced-users

Sorry folks, I left out a bunch of key facts. YOU HAVE =SIX= COINS that total $1.15. Your spreadsheet will show (numerous) computations but highlights six coins/denominations that add up to $1.15 but NOT $.95.

ALSO, YOU CANNOT MAKE CHANGE FOR $1.00, $.50, OR $.25 CENTS.

And to further make it difficult, NO, you cannot adjust the numbers of denominations in your spreadsheet manually. That would basically be cheating and virtually eliminate the need for a spreadsheet.


http://www.cartalk.com/content/no-change-ray-0?question

 

[mikerickson]

Re: CORRECTION AND LINK Re: Academic challenge for advanced-users

test color

 

[BenMiller]

Re: CORRECTION AND LINK Re: Academic challenge for advanced-users

Sorry folks, I left out a key fact. YOU HAVE =SIX= COINS that total $1.15. Your spreadsheet will show (numerous) computations but highlights six coins/denominations that add up to $1.15 but NOT $.95. And to further clarify, NO, you cannot adjust the numbers of denominations in your spreadsheet manually.


http://www.cartalk.com/content/no-change-ray-0?question

Does it include 50-cent pieces and dollar coins?

 

[Norie]

Re: CORRECTION AND LINK Re: Academic challenge for advanced-users

Thought there might be a hitch.

Any specifications for denominations and currency?

 

[BenMiller]

How about 4 quarters, a dime, and a nickel?

 

[BenMiller]

Re: CORRECTION AND LINK Re: Academic challenge for advanced-users

Sorry folks, I left out a bunch of key facts. YOU HAVE =SIX= COINS that total $1.15. Your spreadsheet will show (numerous) computations but highlights six coins/denominations that add up to $1.15 but NOT $.95.

ALSO, YOU CANNOT MAKE CHANGE FOR $1.00, $.50, OR $.25 CENTS.

And to further make it difficult, NO, you cannot adjust the numbers of denominations in your spreadsheet manually. That would basically be cheating and virtually eliminate the need for a spreadsheet.


http://www.cartalk.com/content/no-change-ray-0?question

If I understand this correctly - if you can't make change for $1.00, $.50, OR $.25 cents, that means you can't have any quarters, half-dollars, or dollar coins. Is that right?

 

[BenMiller]

Ok, never mind. My mind was on stupid mode. I got it now. The guy has a half-dollar, a quarter, and four dimes.