Spreadsheet: 491479d1480510108-import-named-ranges-into-excel-document-help-football-prediction-template-vd2
Sheet: BET TYPES

GROUP | BET | CASH OUT?
FULL TIME RESULT | HOME | YES
 | DRAW | YES
 | AWAY | YES
CORRECT SCORE | HOME WIN  1-0 | YES
 | HOME WIN  2-0 | YES
 | HOME WIN  2-1 | YES
 | HOME WIN  3-0 | YES
 | HOME WIN  3-1 | YES
 | HOME WIN  3-2 | YES
 | HOME WIN  4-0 | YES
 | HOME WIN  4-1 | YES
 | HOME WIN  4-2 | YES
 | HOME WIN  4-3 | YES
 | HOME WIN  5-0 | YES
 | HOME WIN  5-1 | YES
 | HOME WIN  5-2 | YES
 | HOME WIN  5-3 | YES
 | HOME WIN  5-4 | YES
 | HOME WIN  6-0 | YES
 | HOME WIN  6-1 | YES
 | HOME WIN  6-2 | YES
 | HOME WIN  6-3 | YES
 | HOME WIN  6-4 | YES
 | HOME WIN  6-5 | YES
 | HOME WIN  7-0 | YES
 | HOME WIN  8-0 | YES
 | HOME WIN  8-1 | YES
 | HOME WIN  8-2 | YES
 | HOME WIN  8-3 | YES
 | HOME WIN  8-4 | YES
 | HOME WIN  8-5 | YES
 | HOME WIN  8-6 | YES
 | HOME WIN  8-7 | YES
 | DRAW 1-1 | YES
 | DRAW 2-2 | YES
 | DRAW 3-3 | YES
 | DRAW 4-4 | YES
 | DRAW 5-5 | YES
 | DRAW 6-6 | YES
 | DRAW 7-7 | YES
 | DRAW 8-8 | YES
 | AWAY WIN  1-0 | YES
 | AWAY WIN  2-0 | YES
 | AWAY WIN  2-1 | YES
 | AWAY WIN  3-0 | YES
 | AWAY WIN  3-1 | YES
 | AWAY WIN  3-2 | YES
 | AWAY WIN  4-0 | YES
 | AWAY WIN  4-1 | YES
 | AWAY WIN  4-2 | YES
 | AWAY WIN  4-3 | YES
 | AWAY WIN  5-0 | YES
 | AWAY WIN  5-1 | YES
 | AWAY WIN  5-2 | YES
 | AWAY WIN  5-3 | YES
 | AWAY WIN  5-4 | YES
 | AWAY WIN  6-0 | YES
 | AWAY WIN  6-1 | YES
 | AWAY WIN  6-2 | YES
 | AWAY WIN  6-3 | YES
 | AWAY WIN  6-4 | YES
 | AWAY WIN  6-5 | YES
 | AWAY WIN  7-0 | YES
 | AWAY WIN  8-0 | YES
 | AWAY WIN  8-1 | YES
 | AWAY WIN  8-2 | YES
 | AWAY WIN  8-3 | YES
 | AWAY WIN  8-4 | YES
 | AWAY WIN  8-5 | YES
 | AWAY WIN  8-6 | YES
 | AWAY WIN  8-7 | YES
HALF TIME / FULL TIME | HOME / HOME | NO
 | DRAW / HOME | NO
 | AWAY / HOME | NO
 | HOME / DRAW | NO
 | DRAW / DRAW | NO
 | AWAY / DRAW | NO
 | HOME / AWAY | NO
 | DRAW / AWAY | NO
 | AWAY / AWAY | NO
UNDER / OVER 2.5 GOALS | UNDER | YES
 | OVER | YES
GOAL HANDICAP | HOME -1 | NO
 | DRAW -1 | NO
 | AWAY -1 | NO
 | HOME -2 | NO
 | DRAW -2 | NO
 | AWAY -2 | NO
 | HOME -3 | NO
 | DRAW -3 | NO
 | AWAY -3 | NO
BTTS | YES | YES
 | NO | YES
BTTS IN 1st HALF | YES | NO
 | NO | NO
BTTS IN 2nd HALF | YES | NO
 | NO | NO
BTTS IN BOTH HALVES | YES | NO
 | NO | NO
F/T RESULT AND U/O 2.5 | HOME & OVER | NO
 | HOME & UNDER | NO
 | AWAY & OVER | NO
 | AWAY & UNDER | NO
 | DRAW & OVER | NO
 | DRAW & UNDER | NO
F/T RESULT AND U/O 3.5 | HOME & OVER | NO
 | HOME & UNDER | NO
 | AWAY & OVER | NO
 | AWAY & UNDER | NO
 | DRAW & OVER | NO
 | DRAW & UNDER | NO
F/T RESULT AND U/O 4.5 | HOME & OVER | NO
 | HOME & UNDER | NO
 | AWAY & OVER | NO
 | AWAY & UNDER | NO
 | DRAW & OVER | NO
 | DRAW & UNDER | NO
FULL TIME RESULT AND BTTS | HOME & YES | YES
 | HOME & NO | YES
 | DRAW & YES | YES
 | DRAW & NO | YES
 | AWAY & YES | YES
 | AWAY & NO | YES
BOTH TEAMS TO SCORE AND U/O 2.5 | BTTS & OVER | NO
 | BTTS & UNDER | NO
BOTH TEAMS TO SCORE AND U/O 3.5 | BTTS & OVER | NO
 | BTTS & UNDER | NO
BOTH TEAMS TO SCORE AND U/O 4.5 | BTTS & OVER | NO
 | BTTS & UNDER | NO
BOTH SCORE NO DRAW | YES | NO
 | NO | NO
DRAW NO BET | HOME | NO
 | AWAY | NO
DOUBLE CHANCE | HOME / DRAW | YES
 | AWAY / DRAW | YES
 | HOME / AWAY | YES
WIN TO NIL | HOME | NO
 | AWAY | NO
WINNING MARGIN | HOME BY 1 | NO
 | HOME BY 2 | NO
 | HOME BY 3+ | NO
 | AWAY BY 1 | NO
 | AWAY BY 2 | NO
 | AWAY BY 3+ | NO
HT RESULT | HOME | YES
 | DRAW | YES
 | AWAY | YES
HALF TIME CORRECT SCORE | HOME WIN  1-0 | YES
 | HOME WIN  2-0 | YES
 | HOME WIN  2-1 | YES
 | HOME WIN  3-0 | YES
 | HOME WIN  3-1 | YES
 | HOME WIN  3-2 | YES
 | HOME WIN  4-0 | YES
 | HOME WIN  4-1 | YES
 | HOME WIN  4-2 | YES
 | HOME WIN  4-3 | YES
 | HOME WIN  5-0 | YES
 | HOME WIN  5-1 | YES
 | HOME WIN  5-2 | YES
 | HOME WIN  5-3 | YES
 | HOME WIN  5-4 | YES
 | HOME WIN  6-0 | YES
 | HOME WIN  6-1 | YES
 | HOME WIN  6-2 | YES
 | HOME WIN  6-3 | YES
 | HOME WIN  6-4 | YES
 | HOME WIN  6-5 | YES
 | HOME WIN  7-0 | YES
 | HOME WIN  8-0 | YES
 | HOME WIN  8-1 | YES
 | HOME WIN  8-2 | YES
 | HOME WIN  8-3 | YES
 | HOME WIN  8-4 | YES
 | HOME WIN  8-5 | YES
 | HOME WIN  8-6 | YES
 | HOME WIN  8-7 | YES
 | DRAW 1-1 | YES
 | DRAW 2-2 | YES
 | DRAW 3-3 | YES
 | DRAW 4-4 | YES
 | DRAW 5-5 | YES
 | DRAW 6-6 | YES
 | DRAW 7-7 | YES
 | DRAW 8-8 | YES
 | AWAY WIN  1-0 | YES
 | AWAY WIN  2-0 | YES
 | AWAY WIN  2-1 | YES
 | AWAY WIN  3-0 | YES
 | AWAY WIN  3-1 | YES
 | AWAY WIN  3-2 | YES
 | AWAY WIN  4-0 | YES
 | AWAY WIN  4-1 | YES
 | AWAY WIN  4-2 | YES
 | AWAY WIN  4-3 | YES
 | AWAY WIN  5-0 | YES
 | AWAY WIN  5-1 | YES
 | AWAY WIN  5-2 | YES
 | AWAY WIN  5-3 | YES
 | AWAY WIN  5-4 | YES
 | AWAY WIN  6-0 | YES
 | AWAY WIN  6-1 | YES
 | AWAY WIN  6-2 | YES
 | AWAY WIN  6-3 | YES
 | AWAY WIN  6-4 | YES
 | AWAY WIN  6-5 | YES
 | AWAY WIN  7-0 | YES
 | AWAY WIN  8-0 | YES
 | AWAY WIN  8-1 | YES
 | AWAY WIN  8-2 | YES
 | AWAY WIN  8-3 | YES
 | AWAY WIN  8-4 | YES
 | AWAY WIN  8-5 | YES
 | AWAY WIN  8-6 | YES
 | AWAY WIN  8-7 | YES
HALF TIME UNDER / OVER 0.5 | OVER | YES
 | UNDER | YES
HALF TIME UNDER / OVER 1.5 | OVER | YES
 | UNDER | YES
1st HALF GOALS | 0 | NO
 | 1 | NO
 | 2 | NO
 | 3+ | NO
UNDER / OVER 0.5 | OVER | YES
 | UNDER | YES
UNDER / OVER 1.5 | OVER | YES
 | UNDER | YES
UNDER / OVER 3.5 | OVER | YES
 | UNDER | YES
UNDER / OVER 4.5 | OVER | YES
 | UNDER | YES
TOTAL GOALS | 1 | NO
 | 2 | NO
 | 3 | NO
 | 4 | NO
 | 5 | NO
 | 6+ | NO
TEAM TOTAL GOALS | HOME EXACTLY - 0 | NO
 | HOME EXACTLY - 1 | NO
 | HOME EXACTLY - 2 | NO
 | HOME EXACTLY - 3 | NO
 | HOME EXACTLY - 4+ | NO
 | AWAY EXACTLY - 0 | NO
 | AWAY EXACTLY - 1 | NO
 | AWAY EXACTLY - 2 | NO
 | AWAY EXACTLY - 3 | NO
 | AWAY EXACTLY - 4+ | NO
TO SCORE (X)+ GOALS | HOME 1+ | NO
 | HOME 2+ | NO
 | HOME 3+ | NO
 | HOME 4+ | NO
 | HOME 5+ | NO
 | AWAY 1+ | NO
 | AWAY 2+ | NO
 | AWAY 3+ | NO
 | AWAY 4+ | NO
 | AWAY 5+ | NO
HALF WITH MOST GOALS | 1st | NO
 | 2nd | NO
ODD OR EVEN GOALS | ODD | NO
 | EVEN | NO
2nd HALF GOALS | 0 | NO
 | 1 | NO
 | 2 | NO
 | 3+ | NO
TO WIN BOTH HALVES | HOME | NO
 | AWAY | NO
TO WIN EITHER HALF | HOME | NO
 | AWAY | NO
GOAL IN BOTH HALVES | YES | NO
 | NO | NO
CLEAN SHEET | HOME | NO
 | AWAY | NO
TEAM MOST BOOKING POINTS | HOME | NO
 | AWAY | NO
TOTAL OVER BOOKINGS | 20+ | NO
 | 30+ | NO
 | 40+ | NO
 | 50+ | NO
 | 60+ | NO
 | 70+ | NO
 | 80+ | NO
 | 90+ | NO
EACH TEAM TOTAL BOOKINGS | 20+ | NO
 | 30+ | NO
 | 40+ | NO
 | 50+ | NO
HOME OVER BOOKINGS | 20+ | NO
 | 30+ | NO
 | 40+ | NO
 | 50+ | NO
AWAY OVER BOOKINGS | 20+ | NO
 | 30+ | NO
 | 40+ | NO
 | 50+ | NO
TOTAL UNDER BOOKINGS | -30 | NO
 | -40 | NO
 | -50 | NO
 | -60 | NO
 | -70 | NO
 | -80 | NO
TIME OF 1st GOAL | 0-10 | NO
 | 2020-11-01 00:00:00 | NO
 | 21-30 | NO
 | 31-40 | NO
 | 41-50 | NO
 | 51-60 | NO
 | 61-70 | NO
 | 71-80 | NO
 | 81+ | NO
 | NO GOAL | NO
2HF 1st GOAL TIME | 46-55 | NO
 | 56-65 | NO
 | 66-75 | NO
 | 76-85 | NO
 | 86+ | NO
 | NO GOAL | NO