i need to calculate the total for each person from a spreadsheet
I have a spreadsheet of data.
i have a list of dollars raised for various fundraisers
date, total amount donated, location, friends who were present at the fundraiser
April 2006, $350, School A, Jane, Tom, John, Sue, Ellen
May 2006, $425, School B, Jane, Tom, Sue, Mike
I want to for each person, go through this row by row, print out which fundraiser they were at, and then create a total of sums raised for all the fundraisers they were at.
Jane, School A, 350
Jane, School B, 425
total for Jane 775
Mike, School B, 425
total for Mike 425
I have hundreds of people and hundreds of events
My data is in a spreadsheet in columns. All the donors are in one column, with the names comma separated.
I can output the data to a text file.
What should I use to get results I want?
I am guessing Perl
What would the code be?
Thank you very much.