Office Pool recordinh spreadsheet

[suicidalporcupine]

My office just started to do the lottery / powerball

I was assigned to keep record of all tickets.

All I want is to enter all 5 numbers + 1 powerball# then use to compare all the numbers on the list.

	a	b	c	d	e	f	g	h	i	j	k
	Name	Ball	Ball	Ball	Ball	Ball	Ball	Power		Match?	Match
1	Clark	1	17	25	15	59	6	38		5	Yes
2	Alfred	15	17	8	7	6	25	13		3	No
3	Bruce	17	32	33	41	42	44	51		1	No
4	Barbara	9	10	11	12	13	14	38		0	Yes
5	Grayson	5	8	13	46	9	12	4		0	No
6
7
8	Lottery	Ball1	Ball2	Ball3	Ball4	Ball5	Ball5	Power
9		15	17	25	1	6	59	38

<tbody>
</tbody>

 

[suicidalporcupine]

ok so i found this spreadsheet online that kinda* works.. well Can someone please check it for me? there's a small problem. I can't add any number above 56. it will say "You’ve entered a number that does not validate with Mega Million, please look to make sure you typed it in correctly"

I tried messaging the owner but the website's last posting was 2011.

Here is the google sheet: https://docs.google.com/spreadsheets/d/1b7wB7TByW6Y7vcsJncU-_zhF7lzVrTj9j7hxpbBado0/edit?usp=sharing

On the 2nd Tab. whenever you enter number 57 58 59... and above it will give you an error. Can someone show me how to fix this?