Trying to experiment with friends sport picks and prediction

[smart512]

I've put together a pretty extensive spreadsheet using formulas and a separate sheet for source data, however, I'm not extremely confident in my formulas. I'd love to have someone review and either let me know what needs to be changed or if there is an easier method or even if I am missing something altogether. I will say upfront that my knowledge of Excel is limited and have NO experience with Pivot tables. Even if anyone could review the formulas used on "Source" sheet (I2-M2), Helper row formulas "Jan20A" sheet (formulas for three rows shown in column W, and most importantly formulas in cells D1-M1 "TOPSM"sheet. I'd like to know if I'm way off or could I be doing something better and/or more efficient and/or effective.

Any and all assistance is greatly appreciated.

p.s. In order to adjust file size to fit as attachment, removed formulas from all rows except first on sheet "TOPSM"

[Sunny18pc]

Hi Samrt,

You are really smart, but what are your requirements until I know, would not be able to review or suggest anything.

[smart512]

The headers in the spreadsheet identify the data I'm trying to calculate. Where I'm running into issues are the two columns not showing any results. The other item I seem to be lacking insight is how I'm factoring ties/pushes. Right now they have the same value of a loss, as I am only using 1 or 0 values. Finally, again, looking to see if what my formulas are calculating are the best option for what I'm looking for (again based on what header titles are) or is there a more effective way/formula.

Thanks