Monday, October 31, 2011

yogi_Compute Allowance Earned By Kids For Chores Done

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

user Robcsousa said:
Does anyone know how to give a character a number value? I'm a rookie Google spreadsheet user.
All I am trying to do is assign a value in $ to a cell that has an x or * or whatever in it. So for example, if my kid puts an x next to the chore on the spreadsheet, he get $ .50 in his bank.
a little technically challenged :-)
Basically, I'm experimenting with a chart for my kids that has chores/duties etc, and that's the way they'll earn an allowance. They would simply put an x next to the chore and it would calculate a dollar amount which would be totalled in another sheet, the bank. It's just my way of teaching them a lesson on earning and saving their money. I'm sure it's possible but I'm a rookie when it comes to spreadsheets. I really appreciate all the input you given.
Goof Job Rob in Teaching Responsibility and Value of Money to Kids
following is one solution to the problem