Question for Spreadsheet Wiz aussie09

StayOrGo

Hi Aussie,

I know you are a wiz with the spreadsheets.

For the TLB charity comp, there is a side completion, where by players get points for tournament wins in 2015.

Namely 10pts for main win, 7pts for Mini win and 2pts for a £55 BH win (including Speed BH)

They also donate £10 every time they win any of these tournaments. At the moment I maintain the spreadsheet manually, relying on them informing me when this happens and I also manually scan through the results thread.

I was hoping, as you are so good at this stuff, that you could perhaps do something more scientific.

I have attached the spreadsheet below:

Many thanks,

Graham

 

	COMPETITOR	SPREADSHEET	30/01/2015
NAME	SKY ALIAS	CHARITY	PLEDGE AMT.	MAIN WINS	MINI WINS	£55 BH WINS	PTS	DONATION
Matt Bates	MattBates	STEP UP	£50.00	0	0	2	4	£20.00
Ben Nuttall	Nutter5932	CANCER RESEARCH UK	£50.00	0	0	0	0	£0.00
Ryan Spittles	Scotty77	NUFFIELD ORTHOPEDIC CENTRE	£50.00	0	0	1	2	£10.00
Graham Carter	StayOrGo	SALVATION ARMY	£50.00	0	0	0	0	£0.00
Tommy Dyer	TommyD	CENTREPOINT	£50.00	0	0	0	0	£0.00
Natalie Bromley	Bromley23	BRITISH HEART FOUNDATION	£50.00	0	0	0	0	£0.00
Adam Bromley	Bromley04	RSPCA	£50.00	0	0	0	0	£0.00
Paul Garner	SoLack	ST MICHAEL'S HOSPICE	£50.00	1	0	1	12	£20.00
David Watkin	Wacko90	MS TRUST	£50.00	0	0	1	2	£10.00
Conor Gilmore	bearlyther	MARIE CURIE CANCER CARE	£50.00	0	1	1	9	£20.00
Roger Arthurs	jawzindawz	PROSTRATE CANCER UK	£50.00	0	0	0	0	£0.00
Chris Cunliffe	rspca12	GUIDE DOGS FOR THE BLIND	£50.00	1	0	0	10	£10.00
Ross McConnell	RossMc	PERCY HEDLEY FOUNDATION	£50.00	0	0	1	2	£10.00
Andy Young	chicknMelt	MIND IN CAMBRIDGSHIRE	£50.00	0	0	0	0	£0.00
David Harvey	HITMAN_RV	HELP THE HEROES	£50.00	0	0	0	0	£0.00
Gary Carter	Limp2Lose	THE SAMARITANS	£50.00	0	0	0	0	£0.00
Gary Roberts	gazscoop	VICTORY OUTREACH UK	£50.00	1	0	0	10	£10.00
Gareth Smith	Gsmith13	MS RESEARCH	£50.00	0	0	1	2	£10.00
		TOTAL PLEDGED BY COMPETITORS	£900.00
		TOTAL SPONSORED	£865.00		MAIN	WIN =	10	POINTS
		DONATION FOR TOURNAMENT WINS	£120.00		MINI	WIN =	7	POINTS
					£55 BH	WIN =	2	POINTS
		CUMMULATIVE TOTAL	£1,885.00

aussie09

hi graham,

thanks for the compliment in your note.

i looked at this task to see what is possible and to decide which solution would be best.  i thought about what can be done, whether i could do it by adjusting my spreadsheets and/or maybe there is some fantastic solution.

however, the outcome is that it would be best achieved by a very simple spreadsheet and manually inserting the wins and using the spreadsheet to multiply by 10pts, 7pts etc.

the reason for this is that you (only) have 18 people to look for and (only) four events a day.  in january, there have been (only) 12 wins.  to automate this would actually be more work than continuing with a manual system.  this is because there are so few events to record each month.

if i were doing it, i would simply tally the wins on a bit of paper.  insert the numbers into a spreadsheet to make it look nice and publish.  this is exactly what you are doing already.  there are too few players and too few events to make it worthwhile looking to automate things more.

i spent an hour thinking about wonderful sexy solutions.  at the end of the hour i know that you have the sexiest solution already.

cheers man.

StayOrGo

In Response to Re: Question for Spreadsheet Wiz aussie09:

hi graham, thanks for the compliment in your note. i looked at this task to see what is possible and to decide which solution would be best.  i thought about what can be done, whether i could do it by adjusting my spreadsheets and/or maybe there is some fantastic solution. however, the outcome is that it would be best achieved by a very simple spreadsheet and manually inserting the wins and using the spreadsheet to multiply by 10pts, 7pts etc. the reason for this is that you (only) have 18 people to look for and (only) four events a day.  in january, there have been (only) 12 wins.  to automate this would actually be more work than continuing with a manual system.  this is because there are so few events to record each month. if i were doing it, i would simply tally the wins on a bit of paper.  insert the numbers into a spreadsheet to make it look nice and publish.  this is exactly what you are doing already.  there are too few players and too few events to make it worthwhile looking to automate things more. i spent an hour thinking about wonderful sexy solutions.  at the end of the hour i know that you have the sexiest solution already. cheers man.
Posted by aussie09

Thanks for the time you spent on this.

Appreciate it aussie.

Cheers,

Graham