NBA Betting Spreadsheet

[bwells]

Hi All,

I believe I am very close to completing this model but need some help as I believe the next formula is too advanced for my knowledge.

The goal of this spreadsheet is to upload my projections each day (Column G), determine the discrepancy of my projection vs. the betting line (Column D). The Discrepancy (Column I) and Prop (Column B) will match up with a Win % value from my Master Sheet. That Win % will then be generated into Column J. The Win % (Column J) will be compared to the Implied Win % (Column K) that is determined from the Betting Odds. Essentially, if the win % of my projected discrepancy for that prop is greater than the implied win % of the betting line, there is value in betting that prop. After each day, I will upload the results of the previous night (Column M) which will tell me whether the prop would W or L based on my projection. The W & L from each new sheet would then compile into my Master Sheet so that I can continue to build data with more accurate Win % results.

I am having trouble compiling the Win % for each prop and discrepancy into my Master Sheet, and then having that generate back into Column J of each of my new sheets.

P.S. Future sheets will have "Under" as part of Column C. This has been adjusted where necessary so it should not be an issue for what I am looking for.

Hope someone can help! Thanks!!