Spreadsheet: 179869d1347391756-putting-a-changing-number-in-a-cell-brought-in-by-a-macro-into-a-formula-poisson-spread-concept_reva
Sheet: Sheet1

POINTS SPREAD | 56.5
IS IT INTEGER | NO
ADJUSTMENT MIN | 56
ADJUSTMENT PUSH | 0
ADJUSTMENT MAX | 57
 | mean | 25.32265631964295 | 27.8995130674608
 | goals | team 1 | team 2 | team 1 wins
 | 0 | 1.00579643800167e-11 | 7.64531576092836e-13
 | 1 | 2.546943752703735e-10 | 2.133005869768848e-11 | 1.947218921474389e-22
 | 2 | 3.224769065758918e-09 | 2.975491256829329e-10 | 7.124995123550787e-20
 | 3 | 2.721990625414305e-08 | 2.76715857340084e-09 | 8.700671983067691e-18
 | 4 | 1.723200827816411e-07 | 1.930059419458323e-08 | 5.31918026032653e-16
 | 5 | 8.727204466503838e-07 | 1.076954359883066e-07 | 1.953793865880404e-14
 | 6 | 3.683266655608826e-06 | 5.007750372769412e-07 | 4.791297593121778e-13
 | 7 | 1.332429937908329e-05 | 1.99591138519517e-06 | 8.405739122188919e-12
 | 8 | 4.217583173456975e-05 | 6.960619471593304e-06 | 1.107861781020744e-10
 | 9 | 0.0001186671213344 | 2.157754376725994e-05 | 1.137707821292103e-09
 | 10 | 0.0003004966729992381 | 6.020029642983761e-05 | 9.364958528632031e-09
 | 11 | 0.0006917612705050762 | 0.0001526871779008425 | 6.320292684020103e-08
 | 12 | 0.001459769409019967 | 0.000354991492923189 | 3.562602376800684e-07
 | 13 | 0.002843479926964686 | 0.0007618530612036869 | 1.703369304303136e-06
 | 14 | 0.005143176067309299 | 0.00151823781689552 | 6.999332679638959e-06
 | 15 | 0.008682591996259079 | 0.002823873054132647 | 2.499835257828442e-05
 | 16 | 0.01374164331780945 | 0.004924042698414015 | 7.836869946573635e-05
 | 17 | 0.0204691124120004 | 0.008081081977008043 | 0.0002175262919146338
 | 18 | 0.02879623882095688 | 0.01252545845648655 | 0.0005387238515772428
 | 19 | 0.03837880310323428 | 0.0183923258885623 | 0.00119870783781002
 | 20 | 0.0485926620471224 | 0.02565684682344707 | 0.00241145540638972
 | 21 | 0.0585950133655161 | 0.03408635872479055 | 0.004411194543782204
 | 22 | 0.06744460843181134 | 0.0432269459392932 | 0.007376357634845252
 | 23 | 0.07425550608398485 | 0.05243524969998836 | 0.01133109828101164
 | 24 | 0.07834777751691267 | 0.06095491392501646 | 0.0160637480897949
 | 25 | 0.07935895373874514 | 0.0680244967030778 | 0.02110838907765246
 | 26 | 0.07729151966971873 | 0.07299424364134473 | 0.02581619680474474
 | 27 | 0.07248987366737816 | 0.0754260686785598 | 0.02950373902470377
 | 28 | 0.06555843419761974 | 0.07515537816873838 | 0.03162742365549892
 | 29 | 0.05724529993242248 | 0.07230339501064395 | 0.03191920180287112
 | 30 | 0.04832010187012047 | 0.0672409837973747 | 0.03043633998751764
 | 31 | 0.03947075267700636 | 0.06051582922979919 | 0.02751627730998977
 | 32 | 0.03123450952242059 | 0.05276131776203152 | 0.02366472079173722
 | 33 | 0.02396790151360217 | 0.04460651740479545 | 0.01942377781055947
 | 34 | 0.01785090978623523 | 0.03660294456555907 | 0.01526278603353891
 | 35 | 0.01291521295742245 | 0.0291772665775531 | 0.01151542868700584
 | 36 | 0.009084652750439112 | 0.02261198694870083 | 0.008365099863242012
 | 37 | 0.006217501064396451 | 0.01705036284747383 | 0.005865631915526253
 | 38 | 0.004143253753176988 | 0.01251833739652748 | 0.003979417166555569
 | 39 | 0.002690210021455682 | 0.008955269686597479 | 0.002617508065976973
 | 40 | 0.001703081595024538 | 0.006246191591096548 | 0.00167230798419743
 | 41 | 0.001051867071100383 | 0.004250383022381998 | 0.001039430659459981
 | 42 | 0.0006341921032243914 | 0.002823419444634764 | 0.0006293894964343052
 | 43 | 0.0003734750853623905 | 0.001831907620709547 | 0.0003717013119204023
 | 44 | 0.0002149404825132074 | 0.001161575695508341 | 0.0002143134005470229
 | 45 | 0.000120952532619115 | 0.0007201643621262185 | 0.0001207401530054503
 | 46 | 6.658346553270116e-05 | 0.0004367877180839131 | 6.651450318111661e-05
 | 47 | 3.587383434585922e-05 | 0.0002592800989018833 | 3.585234806571548e-05
 | 48 | 1.892543287516659e-05 | 0.0001507039272384505 | 1.891900466144782e-05
 | 49 | 9.780453722414604e-06 | 8.580747321034306e-05 | 9.778605645675242e-06
 | 50 | 4.953341365257552e-06 | 4.787973440235517e-05 | 4.952830434721589e-06
 | CUMULATIVE | 0.9999952792313118 | 0.9999447310720576
 | tie | 0.05152780278483683
 | team 1 wins | 0.3364671500713495
 | team 2 wins | 0.6120050471438137
 | TOTAL | 1
 | mean | 53.22216938710375
 | TOTAL GOALS | team 1
 | 0 | 0
 | 1 | 0
 | 2 | 0
 | 3 | 0
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | 7 | 0
 | 8 | 1.227794205825127e-14
 | 9 | 7.260652354992161e-14
 | 10 | 3.864276694982665e-13
 | 11 | 1.869683534718226e-12
 | 12 | 8.292384482087691e-12
 | 13 | 3.394913011758936e-11
 | 14 | 1.290604538330833e-10
 | 15 | 4.579251556720561e-10
 | 16 | 1.523235637612126e-09
 | 17 | 4.768817948321504e-09
 | 18 | 1.410037981232376e-08
 | 19 | 3.949751593652596e-08
 | 20 | 1.051071741771807e-07
 | 21 | 2.663824679932252e-07
 | 22 | 6.444296742404624e-07
 | 23 | 1.491215012195738e-06
 | 24 | 3.306904082153065e-06
 | 25 | 7.04002436829021e-06
 | 26 | 1.44109757468646e-05
 | 27 | 2.840679230492858e-05
 | 28 | 5.399539684989944e-05
 | 29 | 9.909490197480124e-05
 | 30 | 0.0001758015219433771
 | 31 | 0.0003018238186897114
 | 32 | 0.0005019912001051972
 | 33 | 0.0008096078994798273
 | 34 | 0.001267326140095666
 | 35 | 0.001927138471339311
 | 36 | 0.002849069170945139
 | 37 | 0.004098206540854524
 | 38 | 0.005739880071070948
 | 39 | 0.007833047933441003
 | 40 | 0.0104222950982725
 | 41 | 0.01352919890543025
 | 42 | 0.01714412656706255
 | 43 | 0.02121971181735229
 | 44 | 0.02566725219746933
 | 45 | 0.0303570409812272
 | 46 | 0.03512320819987226
 | 47 | 0.03977304970706623
 | 48 | 0.0441001664281495
 | 49 | 0.04790013321711099
 | 50 | 0.05098698007491832
 | 51 | 0.05320858215851346
 | 52 | 0.05445915716323134
 | 53 | 0.05468744315510194
 | 54 | 0.05389971042497116
 | 55 | 0.05215744578461194
 | 56 | 0.04957022168477316
 | 57 | 0.04628481991339088
 | 58 | 0.04247204354279452
 | 59 | 0.03831278467205179
 | 60 | 0.03398482525845954
 | 61 | 0.02965157584421075
 | 62 | 0.02545356761572804
 | 63 | 0.02150308074841867
 | 64 | 0.01788188446776419
 | 65 | 0.01464173360159946
 | 66 | 0.01180704281613902
 | 67 | 0.009379051234646826
 | 68 | 0.007340786080892616
 | 69 | 0.005662211017851598
 | 70 | 0.004305073627108898
 | 71 | 0.00322711771557666
 | 72 | 0.002385475079035337
 | 73 | 0.001739180256508677
 | 74 | 0.001250850624413667
 | 75 | 0.0008876397841401156
 | 76 | 0.0006216067756083873
 | 77 | 0.0004296527416052076
 | 78 | 0.0002931673204018702
 | 79 | 0.0001975063390530589
 | 80 | 0.0001313964479013581
 | 81 | 8.63358519391337e-05
 | 82 | 5.603635775712785e-05
 | 83 | 3.593224728176149e-05
 | 84 | 2.276657322963343e-05
 | 85 | 1.425513431519355e-05
 | 86 | 8.821967129757515e-06
 | 87 | 5.396830217326621e-06
 | 88 | 3.26398877249997e-06
 | 89 | 1.951871498062901e-06
 | 90 | 1.154253727686263e-06
 | 91 | 6.750756858309256e-07
 | 92 | 3.90532527178356e-07
 | 93 | 2.234944979855931e-07
 | 94 | 1.265410854135633e-07
 | 95 | 7.08925377085119e-08
 | 96 | 3.930265260629229e-08
 | 97 | 2.156466427190292e-08
 | 98 | 1.171141035362491e-08
 | 99 | 6.296026925277835e-09
 | 100 | 3.350882114829029e-09
 | CUMULATIVE | 0.9999999963474118
 | TIE % | 0
 | OVER 56.5 | 0.3200815610157278
 | UNDER 56.5 | 0.6799184389842722