Odds of likely "no hits"

lottocalgal

I was hoping some of you mathemeticians can help me on this one.

I'm trying to figure out the odds of  Mega Millions if I omit the "bad" sequences.  I mean numbers such as
1,2,3,4,5,
2,3,4,5,6,...... 18,19,20,21,22, 31,32,33,34,35.....

2,4,6,8,10
3,6,9,12,15

5,10,15,20,25

I know that there are chances that these number CAN happen but the odds are pretty slim. Is there some way I can figure this out in Excel?, I don't know maybe a formula to remove them or such?  Im not the greatest in math, and i can forget coding stuff.  But if I can remove them as well as the combinations of bonuses that can be ommitted( 1,2,3,4,5, bonus 6) then maybe I can see what the "real" odds are?

time*treat

The odds are nearly the same. There are surprisingly (relatively) few of these types of combos, unless you're also willing to include 3 of a kind gaps e.g. 1,2,3,4,6 where the gaps are 1,1,1,2.

time*treat

quad deltas for a 56 choose 5

 A B C D E _ Delta #1 1 2 3 4 5 1 #2 1 3 5 7 9 2 #3 1 4 7 10 13 3 #4 1 5 9 13 17 4 #5 1 6 11 16 21 5 #6 1 7 13 19 25 6 #7 1 8 15 22 29 7 #8 1 9 17 25 33 8 #9 1 10 19 28 37 9 #10 1 11 21 31 41 10 #11 1 12 23 34 45 11 #12 1 13 25 37 49 12 #13 1 14 27 40 53 13 #14 2 3 4 5 6 1 #15 2 4 6 8 10 2 #16 2 5 8 11 14 3 #17 2 6 10 14 18 4 #18 2 7 12 17 22 5 #19 2 8 14 20 26 6 #20 2 9 16 23 30 7 #21 2 10 18 26 34 8 #22 2 11 20 29 38 9 #23 2 12 22 32 42 10 #24 2 13 24 35 46 11 #25 2 14 26 38 50 12 #26 2 15 28 41 54 13 #27 3 4 5 6 7 1 #28 3 5 7 9 11 2 #29 3 6 9 12 15 3 #30 3 7 11 15 19 4 #31 3 8 13 18 23 5 #32 3 9 15 21 27 6 #33 3 10 17 24 31 7 #34 3 11 19 27 35 8 #35 3 12 21 30 39 9 #36 3 13 23 33 43 10 #37 3 14 25 36 47 11 #38 3 15 27 39 51 12 #39 3 16 29 42 55 13 #40 4 5 6 7 8 1 #41 4 6 8 10 12 2 #42 4 7 10 13 16 3 #43 4 8 12 16 20 4 #44 4 9 14 19 24 5 #45 4 10 16 22 28 6 #46 4 11 18 25 32 7 #47 4 12 20 28 36 8 #48 4 13 22 31 40 9 #49 4 14 24 34 44 10 #50 4 15 26 37 48 11 #51 4 16 28 40 52 12 #52 4 17 30 43 56 13 #53 5 6 7 8 9 1 #54 5 7 9 11 13 2 #55 5 8 11 14 17 3 #56 5 9 13 17 21 4 #57 5 10 15 20 25 5 #58 5 11 17 23 29 6 #59 5 12 19 26 33 7 #60 5 13 21 29 37 8 #61 5 14 23 32 41 9 #62 5 15 25 35 45 10 #63 5 16 27 38 49 11 #64 5 17 29 41 53 12 #65 6 7 8 9 10 1 #66 6 8 10 12 14 2 #67 6 9 12 15 18 3 #68 6 10 14 18 22 4 #69 6 11 16 21 26 5 #70 6 12 18 24 30 6 #71 6 13 20 27 34 7 #72 6 14 22 30 38 8 #73 6 15 24 33 42 9 #74 6 16 26 36 46 10 #75 6 17 28 39 50 11 #76 6 18 30 42 54 12 #77 7 8 9 10 11 1 #78 7 9 11 13 15 2 #79 7 10 13 16 19 3 #80 7 11 15 19 23 4 #81 7 12 17 22 27 5 #82 7 13 19 25 31 6 #83 7 14 21 28 35 7 #84 7 15 23 31 39 8 #85 7 16 25 34 43 9 #86 7 17 27 37 47 10 #87 7 18 29 40 51 11 #88 7 19 31 43 55 12 #89 8 9 10 11 12 1 #90 8 10 12 14 16 2 #91 8 11 14 17 20 3 #92 8 12 16 20 24 4 #93 8 13 18 23 28 5 #94 8 14 20 26 32 6 #95 8 15 22 29 36 7 #96 8 16 24 32 40 8 #97 8 17 26 35 44 9 #98 8 18 28 38 48 10 #99 8 19 30 41 52 11 #100 8 20 32 44 56 12 #101 9 10 11 12 13 1 #102 9 11 13 15 17 2 #103 9 12 15 18 21 3 #104 9 13 17 21 25 4 #105 9 14 19 24 29 5 #106 9 15 21 27 33 6 #107 9 16 23 30 37 7 #108 9 17 25 33 41 8 #109 9 18 27 36 45 9 #110 9 19 29 39 49 10 #111 9 20 31 42 53 11 #112 10 11 12 13 14 1 #113 10 12 14 16 18 2 #114 10 13 16 19 22 3 #115 10 14 18 22 26 4 #116 10 15 20 25 30 5 #117 10 16 22 28 34 6 #118 10 17 24 31 38 7 #119 10 18 26 34 42 8 #120 10 19 28 37 46 9 #121 10 20 30 40 50 10 #122 10 21 32 43 54 11 #123 11 12 13 14 15 1 #124 11 13 15 17 19 2 #125 11 14 17 20 23 3 #126 11 15 19 23 27 4 #127 11 16 21 26 31 5 #128 11 17 23 29 35 6 #129 11 18 25 32 39 7 #130 11 19 27 35 43 8 #131 11 20 29 38 47 9 #132 11 21 31 41 51 10 #133 11 22 33 44 55 11 #134 12 13 14 15 16 1 #135 12 14 16 18 20 2 #136 12 15 18 21 24 3 #137 12 16 20 24 28 4 #138 12 17 22 27 32 5 #139 12 18 24 30 36 6 #140 12 19 26 33 40 7 #141 12 20 28 36 44 8 #142 12 21 30 39 48 9 #143 12 22 32 42 52 10 #144 12 23 34 45 56 11 #145 13 14 15 16 17 1 #146 13 15 17 19 21 2 #147 13 16 19 22 25 3 #148 13 17 21 25 29 4 #149 13 18 23 28 33 5 #150 13 19 25 31 37 6 #151 13 20 27 34 41 7 #152 13 21 29 37 45 8 #153 13 22 31 40 49 9 #154 13 23 33 43 53 10 #155 14 15 16 17 18 1 #156 14 16 18 20 22 2 #157 14 17 20 23 26 3 #158 14 18 22 26 30 4 #159 14 19 24 29 34 5 #160 14 20 26 32 38 6 #161 14 21 28 35 42 7 #162 14 22 30 38 46 8 #163 14 23 32 41 50 9 #164 14 24 34 44 54 10 #165 15 16 17 18 19 1 #166 15 17 19 21 23 2 #167 15 18 21 24 27 3 #168 15 19 23 27 31 4 #169 15 20 25 30 35 5 #170 15 21 27 33 39 6 #171 15 22 29 36 43 7 #172 15 23 31 39 47 8 #173 15 24 33 42 51 9 #174 15 25 35 45 55 10 #175 16 17 18 19 20 1 #176 16 18 20 22 24 2 #177 16 19 22 25 28 3 #178 16 20 24 28 32 4 #179 16 21 26 31 36 5 #180 16 22 28 34 40 6 #181 16 23 30 37 44 7 #182 16 24 32 40 48 8 #183 16 25 34 43 52 9 #184 16 26 36 46 56 10 #185 17 18 19 20 21 1 #186 17 19 21 23 25 2 #187 17 20 23 26 29 3 #188 17 21 25 29 33 4 #189 17 22 27 32 37 5 #190 17 23 29 35 41 6 #191 17 24 31 38 45 7 #192 17 25 33 41 49 8 #193 17 26 35 44 53 9 #194 18 19 20 21 22 1 #195 18 20 22 24 26 2 #196 18 21 24 27 30 3 #197 18 22 26 30 34 4 #198 18 23 28 33 38 5 #199 18 24 30 36 42 6 #200 18 25 32 39 46 7 #201 18 26 34 42 50 8 #202 18 27 36 45 54 9 #203 19 20 21 22 23 1 #204 19 21 23 25 27 2 #205 19 22 25 28 31 3 #206 19 23 27 31 35 4 #207 19 24 29 34 39 5 #208 19 25 31 37 43 6 #209 19 26 33 40 47 7 #210 19 27 35 43 51 8 #211 19 28 37 46 55 9 #212 20 21 22 23 24 1 #213 20 22 24 26 28 2 #214 20 23 26 29 32 3 #215 20 24 28 32 36 4 #216 20 25 30 35 40 5 #217 20 26 32 38 44 6 #218 20 27 34 41 48 7 #219 20 28 36 44 52 8 #220 20 29 38 47 56 9 #221 21 22 23 24 25 1 #222 21 23 25 27 29 2 #223 21 24 27 30 33 3 #224 21 25 29 33 37 4 #225 21 26 31 36 41 5 #226 21 27 33 39 45 6 #227 21 28 35 42 49 7 #228 21 29 37 45 53 8 #229 22 23 24 25 26 1 #230 22 24 26 28 30 2 #231 22 25 28 31 34 3 #232 22 26 30 34 38 4 #233 22 27 32 37 42 5 #234 22 28 34 40 46 6 #235 22 29 36 43 50 7 #236 22 30 38 46 54 8 #237 23 24 25 26 27 1 #238 23 25 27 29 31 2 #239 23 26 29 32 35 3 #240 23 27 31 35 39 4 #241 23 28 33 38 43 5 #242 23 29 35 41 47 6 #243 23 30 37 44 51 7 #244 23 31 39 47 55 8 #245 24 25 26 27 28 1 #246 24 26 28 30 32 2 #247 24 27 30 33 36 3 #248 24 28 32 36 40 4 #249 24 29 34 39 44 5 #250 24 30 36 42 48 6 #251 24 31 38 45 52 7 #252 24 32 40 48 56 8 #253 25 26 27 28 29 1 #254 25 27 29 31 33 2 #255 25 28 31 34 37 3 #256 25 29 33 37 41 4 #257 25 30 35 40 45 5 #258 25 31 37 43 49 6 #259 25 32 39 46 53 7 #260 26 27 28 29 30 1 #261 26 28 30 32 34 2 #262 26 29 32 35 38 3 #263 26 30 34 38 42 4 #264 26 31 36 41 46 5 #265 26 32 38 44 50 6 #266 26 33 40 47 54 7 #267 27 28 29 30 31 1 #268 27 29 31 33 35 2 #269 27 30 33 36 39 3 #270 27 31 35 39 43 4 #271 27 32 37 42 47 5 #272 27 33 39 45 51 6 #273 27 34 41 48 55 7 #274 28 29 30 31 32 1 #275 28 30 32 34 36 2 #276 28 31 34 37 40 3 #277 28 32 36 40 44 4 #278 28 33 38 43 48 5 #279 28 34 40 46 52 6 #280 28 35 42 49 56 7 #281 29 30 31 32 33 1 #282 29 31 33 35 37 2 #283 29 32 35 38 41 3 #284 29 33 37 41 45 4 #285 29 34 39 44 49 5 #286 29 35 41 47 53 6 #287 30 31 32 33 34 1 #288 30 32 34 36 38 2 #289 30 33 36 39 42 3 #290 30 34 38 42 46 4 #291 30 35 40 45 50 5 #292 30 36 42 48 54 6 #293 31 32 33 34 35 1 #294 31 33 35 37 39 2 #295 31 34 37 40 43 3 #296 31 35 39 43 47 4 #297 31 36 41 46 51 5 #298 31 37 43 49 55 6 #299 32 33 34 35 36 1 #300 32 34 36 38 40 2 #301 32 35 38 41 44 3 #302 32 36 40 44 48 4 #303 32 37 42 47 52 5 #304 32 38 44 50 56 6 #305 33 34 35 36 37 1 #306 33 35 37 39 41 2 #307 33 36 39 42 45 3 #308 33 37 41 45 49 4 #309 33 38 43 48 53 5 #310 34 35 36 37 38 1 #311 34 36 38 40 42 2 #312 34 37 40 43 46 3 #313 34 38 42 46 50 4 #314 34 39 44 49 54 5 #315 35 36 37 38 39 1 #316 35 37 39 41 43 2 #317 35 38 41 44 47 3 #318 35 39 43 47 51 4 #319 35 40 45 50 55 5 #320 36 37 38 39 40 1 #321 36 38 40 42 44 2 #322 36 39 42 45 48 3 #323 36 40 44 48 52 4 #324 36 41 46 51 56 5 #325 37 38 39 40 41 1 #326 37 39 41 43 45 2 #327 37 40 43 46 49 3 #328 37 41 45 49 53 4 #329 38 39 40 41 42 1 #330 38 40 42 44 46 2 #331 38 41 44 47 50 3 #332 38 42 46 50 54 4 #333 39 40 41 42 43 1 #334 39 41 43 45 47 2 #335 39 42 45 48 51 3 #336 39 43 47 51 55 4 #337 40 41 42 43 44 1 #338 40 42 44 46 48 2 #339 40 43 46 49 52 3 #340 40 44 48 52 56 4 #341 41 42 43 44 45 1 #342 41 43 45 47 49 2 #343 41 44 47 50 53 3 #344 42 43 44 45 46 1 #345 42 44 46 48 50 2 #346 42 45 48 51 54 3 #347 43 44 45 46 47 1 #348 43 45 47 49 51 2 #349 43 46 49 52 55 3 #350 44 45 46 47 48 1 #351 44 46 48 50 52 2 #352 44 47 50 53 56 3 #353 45 46 47 48 49 1 #354 45 47 49 51 53 2 #355 46 47 48 49 50 1 #356 46 48 50 52 54 2 #357 47 48 49 50 51 1 #358 47 49 51 53 55 2 #359 48 49 50 51 52 1 #360 48 50 52 54 56 2 #361 49 50 51 52 53 1 #362 50 51 52 53 54 1 #363 51 52 53 54 55 1 #364 52 53 54 55 56 1