Create an account to follow your favorite communities and start taking part in conversations. You do not need to know how good the team for which we are calculating the SoS is, but you are only interested in knowing the opponent skills level. In some cases, it is measured in distance from the average. The final point above mentions an offensive/defensive model, one which uses points scored and points allowed rather than simply margin of victory. A single angle or double angle lintel configuration (or both types) may be selected along with user defined limits on . Click "Go" in add-ins. Again, I'll do Ctrl+1, alignment wrap text. But if you're using different plant high THC, high CBD or high . In inter-European competition, no permanent divisions or groups are instituted although qualifying teams are drawn into different groups, where the top teams per group advance into the "knockout stage" which is almost similar to the concept of "playoffs" in North American sports. Relative Strength RS = Avg Gain/Avg Loss. We could certainly go much deeper into the math with some matrix theory, even for the simple model in this post, but Im doing my best right now to keep my inner nerd at bay. Before the 2004 season, in the American college football Bowl Championship Series (BCS)[1] the SOS was calculated as shown at right, where OR is the opponents' record, while OOR is the opponents' opponents record. A higher coefficient means that teams do not have to meet teams that are as strong as them early in the tournament, while weaker teams have to face stronger teams in the early stages. That's 103 points. Okay, so that difference is six, the difference there is 3.64 minus a minus 2.8. In fact, its very easy to expand the basic model in this way, with the nice result that for each team, the offensive and defensive ratings sum to the total ratings from above. Okay, so I go to the function wizard, go under all functions, and I'll do count it. (Well need to eventually incorporate more information, but this simplicity is what allows the model to be used for almost any sport. Strength of schedule in the NBA has not been considered nearly as important as in the NFL or as in the NCAA basketball since the NBA teams play each other at least twice. Now the schedule who is number 32. But you can probably interpret the formulas even so. To better remember the function's name, notice that "I" stands for "interest" and "PMT" for "payment". Last consideration, when calculating the Strength of Schedule for the classic European competitions, the SoS of all the teams at the end of the season will be equal to 0.5. Im really interested in getting back to this site and posting more content soon! Once these advisors have been identified, we can give them power of one training and hopefully over time your schedule adherence figures will improve. There are variants of the SoS in which the Net Rating is used instead of the W%. Type =(2500-2342)/2342, and then press RETURN . We'll assume you're ok with this, but you can opt-out if you wish. However, you can use the below table to check the Unit weight of different Da Bars. As already said, SoS is an acronym that stands for Strength of Schedule. But then anytime you opened the workbook you'd be prompted to enable macros, or if you distributed the workbook others would get the prompt and would be very unlikely to know how to interact with macros at all. There are a few things that set different methods apart from the rest. So we have no obvious way of determining how good they are, leaving us with nothing to say about how good the Texans are. Please consult the sportsbook website directly to view the most up-to-date terms and conditions regarding the bonus offers outlined on this page. And poor St. Louis had to play all those good teams. SoS in Europe, on the other hand, loses much of its peculiarities and value, given that competitions have the same schedules for all teams. Step 4: Calculate the unit weight of Reinforcement Bar. Its in the "Excel Programming / VBA / Macros" subforum, that's true. Home Court Advantage in College Basketball. Much of the schedule differences between teams come down to road trips, back-to-backs, afternoon games for example. where RS is the Relative Strength Factor. 1000 sq ft house construction cost. Finally, that number is divided by three. An estimate of the fatigue life is determined from the Goodman diagram. Cumulative interest paid at time CalcPds: =PdRate* (Period*Loan - ( (Period^2-Period)/2) * PrinPmt) Until the final formula above, the term-loan calculations were easy. Necessary cookies are absolutely essential for the website to function properly. Since the model came about as a way of computing strength-of-schedule, its particularly good at comparing two teams who have few or no common opponents, where humans have difficulty. How does excel calculate dates: Part C. Calculate Overtime Pay: Convert Hours and Minutes into Minutes: Express Log in and Log out in Excel: . Select Blank Workbook. What is the meaning of "\big" in the strength of schedule formula you've listed? A note on the math: Im including a few equations here, but nothing fancy. Perhaps you could do a rolling 3 game average to take into account teams on the upswing or downswing. tm_efg_pct is adjusted for . The project is a single-family residence to be built in unincorporated Palm Beach County, Florida. So I think I'd name this column, well we haven't named these columns so let's name them. As you can see, BMI is very simple to calculate which is both its biggest strength and its biggest flaw. And that the 3 is there because its an average of 3 games. Ionic strength of a solution indicates the concentration of ionic charge in the solution. The strength of schedule can be calculated in many ways. Here are a few of methods for calculating the strength of schedule: 1) SOS can be calculated by the help of Relative Percentage Index which incorporates W/L records of opponents and opponents opponents. This formula is actually a weighted average: the Overall Opponent Winning Percentage has a double weight than the OOW%. So that's going to be tough on them. So I think we could use sum if. For example, opponents of the 2016 New England Patriots had a combined record of 1111423 (a win percentage of 0.439, the SOS), and Patriots' wins came against teams with a combined record of 931292 (a win percentage of 0.420, the SOV). There we go. These are the results of the six games: In the table above (has to be read from left to right), you can see the individual steps for calculating the OW%. for constructing this strength of schedule is to help inform the choice of teams given bids to the national tournament: teams who have won more games than their strength of schedule have strongest evidence that they deserve such a bid. Consider using the social media buttons below, or add the page URL when sharing it anywhere. The spreadsheet contains multiple tabs, including two different layouts for the weight training schedule, a diet plan worksheet, weight and measurement log, and a body fat percentage calculator. So if I double click and copy that down. Timesheets for Night-shifts Excel Timesheets to calculate Nightshifts. Let $$x_i $$ be the strength of team $$i$$, and $$m_{i,j}$$ be the margin of team $$i$$s game against team $$j$$. To find the break-even point, Ms. Suji must put in some formula to find the total cost. Below is the formula that will give you the time difference in hours: = (B2-A2)*24. Now if I add these all together and divide it by the number of games we should be good. So like when I look at the Arizona Cardinals, I look at every game, what was the rating of the team they playing? Despite this, the Strength of Schedule can also be useful in Europe: for example, you can evaluate the hardness of the teams run during the season or understand, in the situation of multi-phase and multiple-group competitions, the difficulty of the path taken by each team. The calculator has space for THC, CBD and CBG. So, that's the home team. Using ROUND Function. Get all the latest news straight to your inbox. Countries that had teams progress deeper into UEFA competitions have a higher coefficient. Were failing to account for a lot of stuff here, including mean reversion, any injuries that make the past data a poor representation of the teams that will be on the field on Sunday, and more. SoS = Strength of Schedule (1 = easiest) Methodology: The following rankings are based on the overall fantasy points allowed by week during the prior NFL regular season and for a team's opponents in Weeks 14-17. Youre considering a bet on the Houston Texans this weekend, Week 4. The first section (entitled: "Scheduled") you fill in manually, with the help of your schedules, and the second (entitled: "Actual") using log-in and log-out times. The reason why W% or Net Rating is used is very simple. In the National Hockey League, prior to 2008, some teams did not meet each other in a given year, and intra-division games are more frequent (six times) when compared to the NBA. It turns out that with a little creativity and a computer, this problem can be solved. Google Digital Marketing & E-commerce Professional Certificate, Google IT Automation with Python Professional Certificate, Preparing for Google Cloud Certification: Cloud Architect, DeepLearning.AI TensorFlow Developer Professional Certificate, Free online courses you can finish in a day, 10 In-Demand Jobs You Can Get with a Business Degree. 2022 NFL Strength of Schedule for Every Team Calculated the Proper Way 28 Feb 7:30 PM CHI TOR +5 -5 -- 7:30 PM LAL MEM +8.5 -8.5 -- 8:00 PM DEN HOU -10 +10 -- 8:30 PM IND DAL +6.5 -6.5 -- 9:00 PM SA UTA +9 -9 -- 10:00 PM MIN LAC +6.5 -6.5 -- 10:00 PM POR GS +3.5 -3.5 -- 2022 NFL Strength of Schedule for Every Team Calculated Properly Improving the Strength of Schedule Model, and Week 4 NFL Picks, A Basic Model to Account for Strength of Schedule, How Sports Betting is Like the Playing the Stock Market, A Simple Probability Error Almost Everyone Makes (Including this Gambling Author), Using a forgetting factor to weight recent games more strongly than games from several weeks ago, Using thresholding or tapering to minimize the impact of blowouts, Our additive model for a teams strength can be interpreted as average margin of victory plus average opponent strength. A multiplicative model would better capture interaction between teams, Rather than using margin of victory, use yards, turnovers, and other data that is less noisy (luck impacts the final score more than the final yard and turnover totals). It is important to understand that this value is only an estimate. And we'll just put a blank in there, because Excel will ignore blanks in calculations. Discuss. This is especially important if teams in a league do not play each other the same number of times. The strength of schedule can be calculated in many ways. Great way to get to know how analytics departments behind the scenes of professional sports work. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. Instead, there are four functions to calculate the ratio in the Excel formula, which we can use per the requirements. So if we require that the $$x_i$$s sum to 0, we can interpret them as the amount of points per game by which each team is better or worse than average, after accounting for strength of schedule. Project Summary Using data from Kaggle's Machine Learning Mania contest, I calculated Massey and Colley ratings for each team in one season using python, pandas, and numpy. The first columns show the individual calculations to find the various OppW% for each team. But it could be done, and I think replacing score entirely with a few stats might improve the model. The most important feature to note about the Strength of Schedule is that it is not a predictive statistic. The result is 0.06746. Okay. With this data, you consider the toughness of the path of the opponents: doing this is very relevant because only the opponent W% could provide you the wrong information. But first, please note: You should NOT bet based on these numbers! Compressive Strength Formula Compressive strength formula for any material is the load applied at the point of failure to the cross-section area of the face on which load was applied. Currently, those cells have equations, but if you want to find out the Rank of the Players in, say, game 13, set the scroll bar to 13, then change the output from the function/equation, to just the number that the formula came up with. So this is basically a three win difference in schedules. Because basically there's just a real difference in schedule. Efes, Real Madrid, Barcelona, and Zalgiris have played it. Weve seen that looking at each team one at a time, wont work, so we have to set the problem up as a system of equations and write a program to solve it. Okay, so like the poor St. Louis Rams play in schedule that was three points tougher than average. Create your "Categories" column. The Palm Beach County Building Department will be the permitting agency for this project. Okay, so then this should be an e, and it is, double-click and copy it down. If a team plays an away game it will be the teams I will add 1.5 times the opponents strength adder to the teams schedule strength pool. The one thing to keep in mind is that if you build a basic model using the same stats and tools (and combining them in the same way) as everyone else, you wont get anywhere. And Arizona played a pretty tough schedule, because that division that year was St Louis, Arizona, Seattle, and San Francisco. The one flaw can be most often found in college basketball. So Baltimore Ravens, how good were you? Weekly Schedule Template, Mon-Sun for Word: Plan your days from 8:00 a.m. to 6:00 p.m. with this free weekly schedule template in Word format. The data required for the calculation are very simple. Explore Bachelors & Masters degrees, Advance your career with graduate-level learning. These log-in and log-out times do not just include the start and end of the day, but they allow you to add in lunchtime figures, to find a true figure for schedule adherence. The lintel design loads are specified by the user along with dead load and live load deflection criteria. We try to keep this content unique and up-to-date. All values used will be a monetary figure (USD, GBP, etc.). A number of material specimens are tested and the points at which they break are plotted on the S-N curve. The BCS previously used the SOS in its formula to determine which teams will play in BCS Bowls, and more importantly, to the BCS National Championship Game. This leads to an estimation of the quantity of steel, which translates to the cost requirements for steel work. the games tab is a game log, and thus the games are in chronological order. In the National Basketball Association (NBA), the 30 teams are all guaranteed to face each other at least twice in an 82-game regular season, although intra-division games are more frequent (as much as four times) than inter-conference games (twice). Im going to try to start posting more frequently here, maybe two or three times a week. We need to make one final assumption in order to get values that have any meaning to us. Step 3: Now calculate the multiplication by 4. If a team has played two or more times against an opponent, its Winning Percentage must be added the same number of times. Theres plenty of room to make it stronger, and my hope is that the readers of this site will contribute with ideas and man-hours to help strengthen it. Would a macro be easier in your opinion? Ionic Strength Calculator. Not surprising. Thanks! The 0.2% Offset Yield Strength Method in Excel Step By Step Tutorial The Complete Guide to Everything 72.8K subscribers Subscribe 1K 78K views 1 year ago In this video I will teach you how to. The strength of schedule can be calculated in many ways and all methods assign a greater SOS number to a more difficult schedule. once i have that i can tweak it from there. 2) Simple Rating System (SRS) also incorporates strength of the schedule by employing margin of victory (MOV) and the results can be found at basketball-reference.com. NBAstuffer is not affiliated with the NBA. For example, if you start with a 5 year historical data for a stock, your RSI may . Strength Of Schedule (SOS) represents a teams average schedule difficulty faced by each team in the games that its played so far or for all season. As you can see, Efes played twice against Barca, so the Catalan teams OppW% is added up twice.This procedure is performed for all participants. Click to share on Facebook (Opens in new window), Click to share on Twitter (Opens in new window), Click to share on Pocket (Opens in new window), Click to share on WhatsApp (Opens in new window), Click to share on Telegram (Opens in new window), Click to email a link to a friend (Opens in new window). How to calculate strength ratings of football teams? The reason being round 4 strength ratings only account for the first three games. The information provided on this site is for entertainment purposes only, and should not be taken as financial advice. Strength of schedule is often displayed in two ways. This article explains how to calculate a percentage in Excel using various methods, such as formulas . But I think we did a pretty good job at explaining that, and of course this could be applied to any sport, but in the NFL, it's by far most important. So when we are home what's the opponent's trick. In this post Ill introduce the basic framework of the model Ive used with some success to bet NFL and college basketball games. As such, approximately half of teams' strength of schedules are positive numbers . When the team was home, add up the opponents strength of the away and I know there are 16 games so I can divide it by 16. 4) Details drawing with various sections. You definitely want to keep the number as low as possible for most purposes, especially in the machine-learning approaches that I know the most about (Ill write more about these in the future). Okay, so when Arizona was the away team, we should average the home teams, we should add up the home teams. The higher the value, the greater the toughness of the schedule played. Step 1: Create a basic timesheet as described in Part A, Step 2: Data . We can use sumif, countif, averageif, whatever. Looks like it does what I need so I'm gonna mark the thread as solved and then see if I can decipher the formula. That says, okay, if the home team is Arizona, add up the away team's spread. You can bet you'll have a test question to where you'll have to put your schedules. It is mandatory to procure user consent prior to running these cookies on your website. But since Oakland is home, add 2.5 points to the difference, and our model predicts that Houston should win by 2-3 points. after thinking about it and trying some stuff, i imagine this is best done with several sumif functions, but the problem i keep running into is a way to properly retrieve player b's rank once the formula has found the game with player a in it. I manually filled in the values for "b" team's strength of schedule with an explanation of how I got to that number. For example, the stress is a constant x strain ^n (in cold forming). of steel. Thus, it can be difficult to determine the difference between a good strength of schedule system and a bad one. This system takes the sum of the team's opponent's records and multiplies by two. Ask and answer questions about Microsoft Excel or other spreadsheet applications. Then I would add up the opponents score, F3 the away teams. Calculating the attacking and defensive strength ratings for Man Utd is very straightforward as well. For instance, the 2006-07 Spurs won games by an average of 8.43 points per game and played a schedule with opponents that were 0.08 points worse than average, giving them an SRS of 8.35. Then I can copy this across. Then like when Arizona was home, add up the away teams strengths. I'm trying to recreate this formula myself, and am having problems deciphering what this means. Click the table . Usually, you give greater weight to away victories, considered more challenging. It then adds that number to the teams opponents opponents record and multiplies by one. The calculator also generates a comparison report between a fixed-rate mortgage and interest-only mortgage. The formulas and the calculation sequence remain the same, as does the meaning of the final result. And then we should rank the schedule just rank the one mediums the toughest schedule. To get replies by our experts at nominal charges, follow this. Theyve each played Texans, the team were trying to evaluate in the first place! On the other hand, however, the SoS remains an estimate of the difficulty faced and not an accurate calculation, therefore even only the W% (very easy to find) is suitable with the calculation of this advanced statistic. Still, this is the model we want to build upon, so Ill do my best to run this version of the system and publish the results by this weekend. The concept of "strength of schedule" is alien to European domestic leagues since each league is not divided into divisions or conferences (the meaning of "conference" is different here, since even though several leagues may be in one conference, teams from the same conference do not play teams from other leagues of the same conference. If the away team at equals Arizona, add up the home team's strength. For the sake of familiarity, lets assume were talking about the NFL. Your conformance rates will inform you if this is the case too. NFL Strength of Schedule 2021. Click any blank cell. Hi Matt, Lets consider a 6-games 4-team mini-tournament. In Excel, there is no specific function to calculate the ratio. Tampa Bay 3.64 was the toughest schedule. Set up an equation like this for each team, and were left with a system of 32 equations in 32 unknowns. This category only includes cookies that ensures basic functionalities and security features of the website. Is a Master's in Computer Science Worth it. Furthermore, several more factors may be added, such as the position of the team in the league, the strength of the team's division or conference, which games count in the formula and which do not (vital in the Bowl Championship Series), the locations of the games (see home team and home advantage) and others. #1 means that the opponents that the team faces during the selected period allow the most fantasy points. Im also assuming frac is the fraction of 1/3. This screenshot is a sneak peek at our free schedule adherence tool. Unit weight of Bar = Volume of Bar X Density of Bar (7850 kg/m3) Example, 10 mm Da reinforcement bar Weight = 10 2 /162 = 0.617 kg/m. W% and Net Rating are two stats that show how strong a team is (and therefore tough to face). Sounds about right. Powered by Headway, the drag and drop WordPress theme. opponents average (Modified by tigeravatar).xlsx, opponents average (Modified by tigeravatar) v2.xlsx, opponents average (Modified by tigeravatar) v3.xlsm. Here is the link if you want to check out our Schedule Adherence Tool. IPMT is Excel's interest payment function. I see you're using point differentials, but I don't quite understand the "bid" thought process. Steps: First, select the cell and right-click on it. How to Calculate Relative Strength Index RSI is defined by this equation. Your first idea (to use important stats instead of simply score) is one I havent tried with this model. You probably do. We'll do formulas, create from selection, names in top row. Follow these steps to create a seven-day schedule with hourly blocks for a single user. We could look at the other games these teams have played, but the same problem arises in trying to evaluate their opponents. But almost immediately, we run into the problem. Ive calculated these numbers using only the simple model Ive explained above, in addition to a small homefield adjustment to each margin of victory. Okay. Here are a few of methods for calculating the strength of schedule: Download NBA Schedule Export NBA schedules to Excel including rest days to build your own strength of schedule model! I mean, it's not true that every NFL team plays every other NFL team. For more on schedule adherence and how it is calculated and managed, read our articles: Read more about - Essential Call Centre Tools, Adherence. For example: Monday: Workout 1. manor house rental Join Dean Eboni Nelson and the UConn Law School Softball Club for the second annual Faculty & Staff vs. Students Softball Game Schedule: 3:00 - 3:30 p.m. Warmups 3:30 - 5:00 p.m. Game 5:00 - 6:00 p.m. Post-game refreshments Bring a glove/bat if you have one! Im listing them here in hopes that theyll get the wheels turning in your head to come up with more ideas about how we might make this better. Very interesting course. Activity coefficient of an ionic solution is related to the ionic strength of the solution by Debye-Huckel formula. Having trouble thinking of a way to adjust it to reflect the average value of a team's opponents up until the current day's games. STRENGTH OF SCHEDULE AS EXPLAINED BY THE BCS ORGANIZATION. Subtracting, we find that Houston is just less than 5 points better than Oakland. Copyright 2007-2023. John Hollinger explains the calculation of SOS. I spent a lot of time in Houston last year, and the Texans were nine and seven but they played the easiest schedule. Finally, were in a position to calculate the team strengths. If you start working at 11:00 pm and finish at 7:00 am, Excel doesn't understand it's a new day. Strength of schedule is an incredibly interesting metric when one gets down into the thick of it. This system wont always have an exact solution, but we can use an optimization routine to find the set of team strength ratings that best fits the data. There are different levels of very weak teams and games against strong very weak teams could boost a teams SOS even though victory is almost guaranteed regardless of the weak opponent. 3) Unit weight of different dia. For each stat, our procedure generated a team "rating" that accounts for the strength of the opponent on the opposite side of the ball in the same stat (e.g. The weight is at the discretion of the person who calculates. Avg. Learn how probability, math, and statistics can be used to help baseball, football and basketball teams improve, player and lineup selection as well as in game strategy. Excel sheet for brickwork calculation. To calculate weld strength: Select the type of joint from the list of weld types, say, transverse weld (double) or double fillet weld. Wednesday: Workout 2. A macro or UDF would certainly make it cleaner, and depending on your level of expertise with VBA it could certainly be easier. If Function to Get Duration From an Earlier Time to a Former Time 7. The previously calculated OW% are taken and add them up based on the games played and then divide the result as done for the OW%. Theres not much we can do with this new information, since the model is still additive (once we add them, we get the same implied bets as in the simpler model). The following image is a sample amortization schedule for the first year of a mortgage. The above formula will give you the total number of hours elapsed between the two-time values. In column C, enter = (A1*B1). I know coaches and media talk a lot about different stats, but many insiders really talk about turnovers and 3rd down efficiency as big ones. Simulation of the NCAA basketball tournament will aid you in filling out your 2016 bracket. Weekly Schedule Template, Mon-Sat for Word : This blank weekly schedule template offers simplicity and flexibility. So every team has eight home and eight away games. The OOW%, on the other hand, is a more challenging thread to understand: this stat is the Overall Opponent Winning Percentage of the opponents faced by the team under analysis. A strong team in a weak division or conference is capable of bloating their record in order to have a better seeding in the playoffs. To generate a sample amortisation table, use the above calculator. The fatigue strength is the maximum completely reversed stress under which a material will fail after it has experienced the stress for a specified number of cycles. The actual model I use for betting is far more complicated than this (you didnt think beating the sportsbooks was that easy, did you?). I'm the only one using the workbook so no issues there. Choose the content that you want to receive. =((if(Games!$A2=$G$1, if(Games!C$2=Standings!A$3,Standings!$D$3, if(Games!C$2=Standings!A$4,Standings!$D$4, if(Games!C$2=Standings!A$5,Standings!$D$5, if(Games!C$2=Standings!A$6,Standings!$D$6, if(Games!C$2=Standings!A$7, Standings!$D$7, if(Games!C$2=Standings!A$8,Standings!$D$8, if(Games!C$2=Standings!A$9,Standings!$D$9, if(Games!C$2=Standings!A$10,Standings!$D$10, if(Games!C$2=Standings!A$11,Standings!$D$11, if(Games!C$2=Standings!A$12,Standings!$D$12, if(Games!C$2=Standings!A$13, Standings!$D$13, if(Games!C$2=Standings!A$14, Standings!$D$14, if(Games!C$2=Standings!A$15, Standings!$D$15, if(Games!C$2=Standings!A$16, Standings!$D$16, 0))))))))))))))))+(if(Games!B$2=Standings!A$2, if(Games!C$2=Standings!A$3,Standings!$D$3, if(Games!C$2=Standings!A$4,Standings!$D$4, if(Games!C$2=Standings!A$5,Standings!$D$5, if(Games!C$2=Standings!A$6,Standings!$D$6, if(Games!C$2=Standings!A$7, Standings!$D$7, if(Games!C$2=Standings!A$8,Standings!$D$8, if(Games!C$2=Standings!A$9,Standings!$D$9, if(Games!C$2=Standings!A$10,Standings!$D$10, if(Games!C$2=Standings!A$11,Standings!$D$11, if(Games!C$2=Standings!A$12,Standings!$D$12, if(Games!C$2=Standings!A$13, Standings!$D$13, if(Games!C$2=Standings!A$14, Standings!$D$14, if(Games!C$2=Standings!A$15, Standings!$D$15, if(Games!C$2=Standings!A$16, Standings!$D$16, 0))))))))))))))))+(if(Games!A$2=Standings!A$2, if(Games!D$2=Standings!A$3,Standings!$D$3, if(Games!D$2=Standings!A$4,Standings!$D$4, if(Games!D$2=Standings!A$5,Standings!$D$5, if(Games!D$2=Standings!A$6,Standings!$D$6, if(Games!D$2=Standings!A$7, Standings!$D$7, if(Games!D$2=Standings!A$8,Standings!$D$8, if(Games!D$2=Standings!A$9,Standings!$D$9, if(Games!D$2=Standings!A$10,Standings!$D$10, if(Games!D$2=Standings!A$11,Standings!$D$11, if(Games!D$2=Standings!A$12,Standings!$D$12, if(Games!D$2=Standings!A$13, Standings!$D$13, if(Games!D$2=Standings!A$14, Standings!$D$14, if(Games!D$2=Standings!A$15, Standings!$D$15, if(Games!D$2=Standings!A$16, Standings!$D$16,0))))))))))))))))+(if(Games!B$2=Standings!A$2, if(Games!D$2=Standings!A$3,Standings!$D$3, if(Games!D$2=Standings!A$4,Standings!$D$4, if(Games!D$2=Standings!A$5,Standings!$D$5, if(Games!D$2=Standings!A$6,Standings!$D$6, if(Games!D$2=Standings!A$7, Standings!$D$7, if(Games!D$2=Standings!A$8,Standings!$D$8, if(Games!D$2=Standings!A$9,Standings!$D$9, if(Games!D$2=Standings!A$10,Standings!$D$10, if(Games!D$2=Standings!A$11,Standings!$D$11, if(Games!D$2=Standings!A$12,Standings!$D$12, if(Games!D$2=Standings!A$13, Standings!$D$13, if(Games!D$2=Standings!A$14, Standings!$D$14, if(Games!D$2=Standings!A$15, Standings!$D$15, if(Games!D$2=Standings!A$16, Standings!$D$16, 0))))))))))))))))+(if(Games!C$2=Standings!A$2, if(Games!A$2=Standings!A$3,Standings!$D$3, if(Games!A$2=Standings!A$4,$D$4, if(Games!A$2=Standings!A$5,Standings!$D$5, if(Games!A$2=Standings!A$6,Standings!$D$6, if(Games!A$2=Standings!A$7, Standings!$D$7, if(Games!A$2=Standings!A$8,Standings!$D$8, if(Games!A$2=Standings!A$9,Standings!$D$9, if(Games!A$2=Standings!A$10,Standings!$D$10, if(Games!A$2=Standings!A$11,Standings!$D$11, if(Games!A$2=Standings!A$12,Standings!$D$12, if(Games!A$2=Standings!A$13, Standings!$D$13, if(Games!A$2=Standings!A$14, Standings!$D$14, if(Games!A$2=Standings!A$15, Standings!$D$15, if(Games!A$2=Standings!A$16, Standings!$D$16, 0))))))))))))))))+(if(Games!D$2=Standings!A$2, if(Games!B$2=Standings!A$3,Standings!$D$3, if(Games!B$2=Standings!A$4,Standings!$D$4, if(Games!B$2=Standings!A$5,Standings!$D$5, if(Games!B$2=Standings!A$6,Standings!$D$6, if(Games!B$2=Standings!A$7, Standings!$D$7, if(Games!B$2=Standings!A$8,Standings!$D$8, if(Games!B$2=Standings!A$9,Standings!$D$9, if(Games!B$2=Standings!A$10,Standings!$D$10, if(Games!B$2=Standings!A$11,Standings!$D$11, if(Games!B$2=Standings!A$12,Standings!$D$12, if(Games!B$2=Standings!A$13, Standings!$D$13, if(Games!B$2=Standings!A$14, Standings!$D$14, if(Games!B$2=Standings!A$15, Standings!$D$15, if(Games!B$2=Standings!A$16, Standings!$D$16, 0))))))))))))))))+(if(Games!D$2=Standings!A$2, if(Games!A$2=Standings!A$3,Standings!$D$3, if(Games!A$2=Standings!A$4,Standings!$D$4, if(Games!A$2=Standings!A$5,Standings!$D$5, if(Games!A$2=Standings!A$6,Standings!$D$6, if(Games!A$2=Standings!A$7, Standings!$D$7, if(Games!A$2=Standings!A$8,Standings!$D$8, if(Games!A$2=Standings!A$9,Standings!$D$9, if(Games!A$2=Standings!A$10,Standings!$D$10, if(Games!A$2=Standings!A$11,Standings!$D$11, if(Games!A$2=Standings!A$12,Standings!$D$12, if(Games!A$2=Standings!A$13, Standings!$D$13, if(Games!A$2=Standings!A$14, Standings!$D$14, 0))))))))))))))+(if(Games!C$2=Standings!A$2, if(Games!B$2=Standings!A$3,Standings!$D$3, if(Games!B$2=Standings!A$4,Standings!$D$4, if(Games!B$2=Standings!A$5,Standings!$D$5, if(Games!B$2=Standings!A$6,Standings!$D$6, if(Games!B$2=Standings!A$7, Standings!$D$7, if(Games!B$2=Standings!A$8,Standings!$D$8, if(Games!B$2=Standings!A$9,Standings!$D$9, if(Games!B$2=Standings!A$10,Standings!$D$10, if(Games!B$2=Standings!A$11,Standings!$D$11, if(Games!B$2=Standings!A$12,Standings!$D$12, if(Games!B$2=Standings!A$13, Standings!$D$13, if(Games!B$2=Standings!A$14, Standings!$D$14, if(Games!B$2=Standings!A$15, Standings!$D$15, if(Games!B$2=Standings!A$16, Standings!$D$16, 0)))))))))))))))))/2.