Spreadsheet: 180134d1347484409-putting-a-changing-number-in-a-cell-brought-in-by-a-macro-into-a-formula-poisson-spread-concept_revb
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 | OVERALL | CUMULATIVE
 | 0 | 0 | 0
 | 1 | 0 | 0
 | 2 | 0 | 0
 | 3 | 0 | 0
 | 4 | 0 | 0
 | 5 | 0 | 0
 | 6 | 0 | 0
 | 7 | 0 | 0
 | 8 | 1.227794205825127e-14 | 1.227794205825127e-14
 | 9 | 7.260652354992161e-14 | 8.488446560817288e-14
 | 10 | 3.864276694982665e-13 | 4.713121351064394e-13
 | 11 | 1.869683534718226e-12 | 2.340995669824665e-12
 | 12 | 8.292384482087691e-12 | 1.063338015191236e-11
 | 13 | 3.394913011758936e-11 | 4.458251026950172e-11
 | 14 | 1.290604538330833e-10 | 1.73642964102585e-10
 | 15 | 4.579251556720561e-10 | 6.315681197746411e-10
 | 16 | 1.523235637612126e-09 | 2.154803757386768e-09
 | 17 | 4.768817948321504e-09 | 6.923621705708272e-09
 | 18 | 1.410037981232376e-08 | 2.102400151803203e-08
 | 19 | 3.949751593652596e-08 | 6.0521517454558e-08
 | 20 | 1.051071741771807e-07 | 1.656286916317387e-07
 | 21 | 2.663824679932252e-07 | 4.320111596249639e-07
 | 22 | 6.444296742404624e-07 | 1.076440833865426e-06
 | 23 | 1.491215012195738e-06 | 2.567655846061164e-06
 | 24 | 3.306904082153065e-06 | 5.874559928214229e-06
 | 25 | 7.04002436829021e-06 | 1.291458429650444e-05
 | 26 | 1.44109757468646e-05 | 2.732556004336904e-05
 | 27 | 2.840679230492858e-05 | 5.573235234829762e-05
 | 28 | 5.399539684989944e-05 | 0.0001097277491981971
 | 29 | 9.909490197480124e-05 | 0.0002088226511729983
 | 30 | 0.0001758015219433771 | 0.0003846241731163754
 | 31 | 0.0003018238186897114 | 0.0006864479918060868
 | 32 | 0.0005019912001051972 | 0.001188439191911284
 | 33 | 0.0008096078994798273 | 0.001998047091391111
 | 34 | 0.001267326140095666 | 0.003265373231486777
 | 35 | 0.001927138471339311 | 0.005192511702826088
 | 36 | 0.002849069170945139 | 0.008041580873771227
 | 37 | 0.004098206540854524 | 0.01213978741462575
 | 38 | 0.005739880071070948 | 0.0178796674856967
 | 39 | 0.007833047933441003 | 0.0257127154191377
 | 40 | 0.0104222950982725 | 0.0361350105174102
 | 41 | 0.01352919890543025 | 0.04966420942284044
 | 42 | 0.01714412656706255 | 0.06680833598990299
 | 43 | 0.02121971181735229 | 0.08802804780725529
 | 44 | 0.02566725219746933 | 0.1136953000047246
 | 45 | 0.0303570409812272 | 0.1440523409859518
 | 46 | 0.03512320819987226 | 0.1791755491858241
 | 47 | 0.03977304970706623 | 0.2189485988928903
 | 48 | 0.0441001664281495 | 0.2630487653210398
 | 49 | 0.04790013321711099 | 0.3109488985381508
 | 50 | 0.05098698007491832 | 0.3619358786130691
 | 51 | 0.05320858215851346 | 0.4151444607715826
 | 52 | 0.05445915716323134 | 0.469603617934814
 | 53 | 0.05468744315510194 | 0.524291061089916
 | 54 | 0.05389971042497116 | 0.5781907715148871
 | 55 | 0.05215744578461194 | 0.630348217299499
 | 56 | 0.04957022168477316 | 0.6799184389842722
 | 57 | 0.04628481991339088 | 0.726203258897663
 | 58 | 0.04247204354279452 | 0.7686753024404576
 | 59 | 0.03831278467205179 | 0.8069880871125094
 | 60 | 0.03398482525845954 | 0.8409729123709689
 | 61 | 0.02965157584421075 | 0.8706244882151797
 | 62 | 0.02545356761572804 | 0.8960780558309077
 | 63 | 0.02150308074841867 | 0.9175811365793264
 | 64 | 0.01788188446776419 | 0.9354630210470906
 | 65 | 0.01464173360159946 | 0.95010475464869
 | 66 | 0.01180704281613902 | 0.961911797464829
 | 67 | 0.009379051234646826 | 0.9712908486994758
 | 68 | 0.007340786080892616 | 0.9786316347803684
 | 69 | 0.005662211017851598 | 0.98429384579822
 | 70 | 0.004305073627108898 | 0.9885989194253288
 | 71 | 0.00322711771557666 | 0.9918260371409056
 | 72 | 0.002385475079035337 | 0.9942115122199409
 | 73 | 0.001739180256508677 | 0.9959506924764495
 | 74 | 0.001250850624413667 | 0.9972015431008632
 | 75 | 0.0008876397841401156 | 0.9980891828850033
 | 76 | 0.0006216067756083873 | 0.9987107896606117
 | 77 | 0.0004296527416052076 | 0.9991404424022169
 | 78 | 0.0002931673204018702 | 0.9994336097226187
 | 79 | 0.0001975063390530589 | 0.9996311160616718
 | 80 | 0.0001313964479013581 | 0.9997625125095732
 | 81 | 8.63358519391337e-05 | 0.9998488483615123
 | 82 | 5.603635775712785e-05 | 0.9999048847192694
 | 83 | 3.593224728176149e-05 | 0.9999408169665511
 | 84 | 2.276657322963343e-05 | 0.9999635835397808
 | 85 | 1.425513431519355e-05 | 0.999977838674096
 | 86 | 8.821967129757515e-06 | 0.9999866606412258
 | 87 | 5.396830217326621e-06 | 0.999992057471443
 | 88 | 3.26398877249997e-06 | 0.9999953214602155
 | 89 | 1.951871498062901e-06 | 0.9999972733317136
 | 90 | 1.154253727686263e-06 | 0.9999984275854413
 | 91 | 6.750756858309256e-07 | 0.9999991026611271
 | 92 | 3.90532527178356e-07 | 0.9999994931936543
 | 93 | 2.234944979855931e-07 | 0.9999997166881524
 | 94 | 1.265410854135633e-07 | 0.9999998432292377
 | 95 | 7.08925377085119e-08 | 0.9999999141217755
 | 96 | 3.930265260629229e-08 | 0.999999953424428
 | 97 | 2.156466427190292e-08 | 0.9999999749890923
 | 98 | 1.171141035362491e-08 | 0.9999999867005027
 | 99 | 6.296026925277835e-09 | 0.9999999929965296
 | 100 | 3.350882114829029e-09 | 0.9999999963474118
 | CUMULATIVE | 0.9999999963474118
 | TIE % | 0
 | OVER | 0.3200815610157278
 | UNDER | 0.6799184389842722
 | WORKING UNDER | 0.6799184389842722
 | WORKING TIE | 0
 | WORKING OVER | 0.3200815610157278
 | CUMULATIVE | 1