Barbados Double Draw Ticket Checker Spreadsheet

So I went ahead and created this spreadsheet for checking multiple Double Draw Lotto tickets from 3 spots up to 7 spots. It calculates how much money you spent and the amount won in a very tasteful colour coded theme. With this tool, you wouldn't have the headache to manually check your tickets and the winning results back and forth.
It's based off some other lottery checking spreadsheets but modified for Barbados' own DOUBLE DRAW.

People who usually buy multiple spot sequences but always the same sequences will find the most efficient use of this particular array model or even someone into statistics who wants to do lottery simulations.
Enough with the intro..So how does it work?

It's a fast spreadsheet made of 5 sheets. You chose what spot you intend on checking, be it 3 spot, 4 spot, 5 spot, 6 spot or the ever elusive 7 spot.
There is space to add up to 70 sequences (tickets) for each spot bet and all numbered from 1-70. That's the first column.
Next to the ticket number is the input field where you would enter your chosen numbers as seen with the heading [1] Enter your 3 chosen numbers in blue spaces below:
You can add  up to how many ticket numbers you desire if you insert and auto-fill the relevant ranges, that's if you have more than 70 different sequences.. The whole process of entering your chosen spot numbers may seem tedious at first, but I imagine compared to the old un-automated way of checking tickets, you might be used to repetitive tasks.
---------------------
Now the fun part. How much did you win!
To the right of your chosen numbers is a blue range called [2], Here you would input the draw's winning numbers of which you are to reference your tickets to. As soon as you enter the the final digit, the formulas embedded, match and calculate the winning amounts instantly.

For example on the 3 spot sheet, if any of your tickets match all 3 of any of the winning numbers, 55 will be the amount shown, if only 2 of your numbers matched then 1 is shown etc. This goes for each spot sheet. All aligned with the The Barbados Lottery Prize amounts.

The very top column which is frozen, highlights how much you spent and how much you won using the Count function for tickets and Sum for matches. Based on 1 dollar wagers.

Here is it in action: 6 spot example

In the future maybe I'll add a multiplier tab or find a way to automate some more functionality.

Even imagine an app where it automatically parses the Barbados Lottery website!

I was playing around with macros and colour counting VB scripts but I have found many hidden headaches trying to gain compatibility across the different spreadsheet systems.

The above screen-shots are dark mode filters but the Google sheets original page is a more common bright white.

Google Sheets Link > THE BARBADOS LOTTERY DOUBLE DRAW TICKET CHECKER.  

You would need to make a copy and save to your drive/device to input tickets and results.

Double Draw (7/30) – Odds:
1 in 2,035,800 to match 7
1 in 593,775 to match 6
1 in 142,506 to match 5
1 in 27,405 to match 4
1 in 4,060 to match 3


-------------------------
edit

I have since updated the spreadsheet to 100 sequences per spot and added a base sheet that calculates all the different spots totals from one single draw input; which means it can show the results of up to 500 sequences instantly indicating how much you spent vs won.
looks like this >>>>>>>>>>>>>