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.

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[TD]j[/TD]
[TD]k[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Name[/TD]
[TD]Ball[/TD]
[TD]Ball[/TD]
[TD]Ball[/TD]
[TD]Ball[/TD]
[TD]Ball[/TD]
[TD]Ball[/TD]
[TD]Power[/TD]
[TD][/TD]
[TD]Match?[/TD]
[TD]Match[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Clark[/TD]
[TD]1[/TD]
[TD]17[/TD]
[TD]25[/TD]
[TD]15[/TD]
[TD]59[/TD]
[TD]6[/TD]
[TD]38[/TD]
[TD][/TD]
[TD] 5[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Alfred[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]25[/TD]
[TD]13[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Bruce[/TD]
[TD]17[/TD]
[TD]32[/TD]
[TD]33[/TD]
[TD]41[/TD]
[TD]42[/TD]
[TD]44[/TD]
[TD]51[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Barbara
[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]38[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Grayson[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]13[/TD]
[TD]46[/TD]
[TD]9[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Lottery[/TD]
[TD]Ball1[/TD]
[TD]Ball2[/TD]
[TD]Ball3[/TD]
[TD]Ball4[/TD]
[TD]Ball5[/TD]
[TD]Ball5[/TD]
[TD]Power[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]25[/TD]
[TD]1[/TD]
[TD]6[/TD]
[TD]59[/TD]
[TD]38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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?