Hi,
I have been doing a little bit of reading up into sports and have set-up a worksheet to analyse point spreads mathematically for US College Basketball (based on previously established mathematical formula). I basically like to get an opinion. In short for convenience so I can print it out afterwards, I would be keen to create a Macro to copy inputs and generated results into a log for my own reference later on. I have attached a worksheet with details for this evening's BYU vs Iona game (I'm not 100% on the maths yet but I think it's right - either way that can be sorted later, it looks right when I adjust the handicap up and down).
In short all I input is Team Names, Ratings, Home Edge and a Handicap and I am looking at adding that in the layout starting in Row 18.
The copying of cells would be:
A18= A2, B18= "AT" (effectively), C18=C2 (all of this row is effectively text and can be a straight copy and paste)
A19= A3, B19=A8, C19=C3 (all of these cells are again text and can be a straight copy and paste), D19=D3 (which is generated by formula so would need to be a paste value)
A20=B9, B20=B11, C20=B10 (all of these cells are generated by a formula so would need to be a paste value - I wouldn't be concerned about the percentage issue as I know what I'm looking at)
I would then be looking at the next set of results being posted in rows 21, 22 and 23.
I can see (I think) how to do this for the first set of results, but I wouldn't be sure how to do this for the second set of results (e.g. how would I get this to pick row 21 and subsequently 24, 27 etc. when the rows above it are full)?
Thanks in advance for any advice,
NCAAB Normdist Workup - No Trials.xls
Bookmarks