how to calculate strength of schedule in excel

), and every team plays every opponent twice (home and away) and as such, no playoffs are usually done to determine the winner; the team with the best record wins the championship outright, with several tiebreaking criteria to determine a team's overall standing. The strength of the conference largely depends on the number of NFL players the conference produces. Click on Excel "add-ins" category from the Excel options dialog box. 2) cutting length of each steel used. 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. Fixed & Variable Rate UK Mortgage Repayment Calculator Thanks! JMS, good ideas. Make sense? Excel sheet for brickwork calculation. So we would do SUMIF. In column C, enter = (B1/A1). Compressive Strength = Load / Cross-sectional Area Procedure: Compressive Strength Test of Concrete Cubes To check out all of these tools and more, visit our tools page. And with so many parameters, the Curse of Dimensionality makes it very hard to find the optimal values for them and can also lead to overfitting of the model to past data. 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. Okay, if the away team, see the ranges make this so simple, was Arizona. $$m_{hou,ind} + x_{ind} = 10 + x_{ind}$$. Bar Bending Schedule helps the quantity surveyor to consolidate the number of bars required of each bar type. While the NFL has 32 teams, each team plays only 17 games against 14 other teams. I'm the only one using the workbook so no issues there. Hence the 3. Here's the formula: Type " WEEKLY SCHEDULE " into A1:E2, change the font size to 18, and select Middle Align in the Alignment group. So if the home team Would be Arizona. Go to the "Options". And poor St. Louis had to play all those good teams. Now, if you were to bet based on these numbers, heres how youd do it. 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. Ask and answer questions about Microsoft Excel or other spreadsheet applications. Check the Analysis ToolPak checkbox in the Add-Ins box, and then click OK. Click the "Data analysis" icon to open the data analysis dialog box. How do you formulate strength of schedule? : r/CFBAnalysis - reddit 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 it could be done, and I think replacing score entirely with a few stats might improve the model. We try to keep this content unique and up-to-date. thats my goal. Enter the length of weld, l. Fill in the size of weld, s. Insert the maximum permissible tensile stress \sigma_\mathrm {t} t . 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. 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. As already said, SoS is an acronym that stands for Strength of Schedule. Video by @MetricsMike:https://twitter.com/MetricsMikeHow do you calculate strength of schedule? DON'T JUST LOOK LIKE YOU'RE STRONG. For something like football, where you need not just to model individual players but their interactions in an infinite number of game states, things get out of hand rather quickly. Tampa Bay 3.64 was the toughest schedule. How to calculate strength of concrete in rebound hammer test Write in cell C2 and use asterisk symbol (*) to multiply "=A2*4". Good. We use the team ratings from the previous video to identify t. Im trying to recreate this formula myself, and am having problems deciphering what this means. 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. To better remember the function's name, notice that "I" stands for "interest" and "PMT" for "payment". Lets look at the most basic way to do this. And I'll do the away team's strength. So the schedule screen, we would just add up. 4) Jeff Sagarin is also in charge of SOS ratings. The odds and lines probably already reflect that basic level of sophistication, except probably for rare situations where the public goes crazy and moves the line away from where it should be. See you soon, your friendly neighborhood Cappe! Step 1: Enter the percentage of the cannabinoids in the plant material. I'm gonna play around with both of these and see which solution I like better! Lets start with the formula: As you can see in the formula (and as you could already guess from the data listed in the previous paragraph), the team winning percentage does not appear in the 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. 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%. Follow the link to take a look at and play around with our free Schedule Adherence Tool for yourself. The result is 6.75%, which is the percentage of increase in earnings. The compressive strength of cartons is calculated by the following formula: P = KW (n - 1) In the formula, P- carton compressive strength, N. W- Carton weight after loading, N. N - Number of stacking layers. ), So how should we use that information for each game? There are a few things that set different methods apart from the rest. Find the % of a total: Put the total in column A and number completed in B. A model is only as good as its assumptions, and simulators require a lot of them. So no offense, I don't expect in 2015 fantastic things from the Texans because they probably won't get the easiest schedule again. Calculating Strength of Schedule - DRatings Strength Of Schedule (SOS) Explained - NBAstuffer 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! How does excel calculate dates: Part C. Calculate Overtime Pay: Convert Hours and Minutes into Minutes: Express Log in and Log out in Excel: . Now what's the difference there? 3) Include Cast Factor (reduced fatigue performance due to casting defects). For lazy betting, what are your thoughts on ESPNs Accuscore Simulator? once i have that i can tweak it from there. RSI Indicator Excel Template - Relative Strength Index Analysis - INDZARA Then I would add up the opponents score, F3 the away teams. This method is being used by ESPN. Step 1: Create a basic timesheet as described in Part A, Step 2: Data . formula for strength of schedule? [SOLVED] - Excel Help Forum Advanced NFL Strength of Schedule 2021 - FantasyData New LSAT and GPA medians are out for the Class of 2023! To help you The calculator has space for THC, CBD and CBG. This is a ratings based strength of schedule system that gives less weight to opponents teams that are outliers. Unit cost of steel is charged by weight of steel . This screenshot is a sneak peek at our free schedule adherence tool. So I think I'd name this column, well we haven't named these columns so let's name them. (i feel like this will be the easiest.) Now you have the tools to start building a sports betting bankroll using predictive analytics and gambling data science. Do they publish its record against the spread or any other data about how it performs? Now, lets name a few of them. This category only includes cookies that ensures basic functionalities and security features of the website. 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. JMS recently posted..Unwinding Your Life. In my opinion, this is the best system out there for calculating SOS, yet it still isnt perfect. The strength of schedule can be calculated in many ways. 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. Step 4: Calculate the unit weight of Reinforcement Bar. So if I add up the strength of the teams in the home games. So how many home games? Such calculations are the basis of many of the various tie-breaking systems used in Swiss-system tournaments in chess and other tabletop games. Now if I add these all together and divide it by the number of games we should be good. Id certainly be willing to help any way that I can 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. Conformance is the percentage of time that advisors are scheduled to work compared to the amount of time that they have actually worked. Estimating the strength of schedules is possible through tting a simple statistical model to the results of . How to calculate the compressive strength of cartons? 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. Calculations in Excel | Learn How to Use Excel to Calculate? - EDUCBA The \big and \frac are LaTeX code; theyre supposed to show up on the site as math symbols (parenthesis and fraction, respectively), so something isnt working right. Calculate Time Duration with Simple Formula 2. 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. Statistics, Analytics, Microsoft Excel, Probability. 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. Okay, now the Sum_range. Bar Bending Schedule (BBS) | BBS Step by Step Preparation | Excel Sheet 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. House Construction Cost Calculation Excel Sheet. If OP would like a VBA solution I can provide that as well, but it didn't (and still doesn't) seem to be necessary. 8.2 Computing Strength of Schedule - Module 8 | Coursera Well, as the creator of those grades, I can fully . 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. Get the latest exciting call centre reports, specialist whitepapers and interesting case-studies. Relative Strength Index Spreadsheet - Invest Excel Use a model which produces offensive and defensive ratings to capture interactions and use current week number to account for mean reversion. Steps: First, select the cell and right-click on it. Need Florida Licensed Engineer to Review and Certify Residential I'm trying to recreate this formula myself, and am having problems deciphering what this means. Im certainly not well versed in the math at all, but I found it interesting. The one flaw can be most often found in college basketball. This math-on-a-blog stuff is brand new to me, so Im to figure out the right balance between whats interesting and necessary and what will put you to sleep. And we'll multiply that by 16. My biggest problem with simulators is the sheer number of parameters and assumptions they require. To calculate the first percentage change, enter this percent change formula in C5 : = (B5-B4)/B5 Step 2 Excel displays this as a decimal, so click the Percent Style button on the Ribbon (or use the above mentioned shortcuts) to format it as a percent. As such, approximately half of teams' strength of schedules are positive numbers . How to calculate a correlation coefficient in Excel (2023) - Spreadsheeto Learn a Stat: Strength of Schedule (SoS) - Hack a Stat For Example, For Vertical Upward position of Hammer If 15 Rebound number readings are 48,42,43,43,44,44,45,45,45,45,46,47,48,50 , as per IS:8900, Clause 5.1.1 (TESTS FOR TWO OR MORE OUTLIERS , AT LEAST ONE OUTLIER AT EACH END), 42 and 50 are Outlaying values. i also have a sheet with game by game cumulative w% and rank based off win%, for every player on a game by game basis, based on the game log. The reason being round 4 strength ratings only account for the first three games. Strength Of Schedule Explained - NationalChamps.net We would essentially be determining teams abilities to produce those stats, rather than points, which I suspect would be a better way to do it with less noise. This website uses cookies to improve your experience. For obtaining the Overall Opponent Winning Percentage [OW%], you have to add up all the winning percentages of the opponents encountered and divide them by the number of games played by the team for which you are calculating the SoS. Notice that the units in the margin of victory numbers $$m_{i,j}$$ are simply points. To be consistent, we want the units for the strength ratings to be points as well. Stress Life Fatigue.xls - ExcelCalcs And now if I copy that across I should get the away teams rating I believe, because look up is like dollar sign. Finally, were in a position to calculate the team strengths. 1) Input Applied Stress. Then, keep track of this over the course of the games, and keep track of each team's weekly point differential (a simple 'sum.'). Hi Matt, Step-by-Step Instructions for Excel's Correlation Analysis Under Input Range, select the range for the variables that you want to analyze. I've attached a small spreadsheet attempting to show what I'm trying to do. So you can see that when x is 1 or 2 or something small and the current week number is much larger, then the exponent is large, making the total weight given to that data very small. I like the simplification of the first formula thanks! Calculate Time Duration from a Start Time to Now 6. This component is calculated by determining the cumulative won/loss records of the team's opponents and the cumulative won/loss records of the teams' opponents' opponents.The formula shall be weighted two-third (66 2/3%) for the opponent's record and one-third (33 1/3%) for . This worksheet is used for the design of laterally unsupported steel angle lintels subject to vertical loads. See if that's true. The Strength of Schedule, commonly called SoS, is a team statistic widely used in the USA and, more generally, where there are championships in which the teams schedules are different regarding the number of matches or for the opponents faced. There we go. where RS is the Relative Strength Factor. Hence the "3". In sports, strength of schedule (SOS) refers to the difficulty or ease of a team's/person's opponent as compared to other teams/persons. But those should be too hard to compile, especially if multiple people are working on it or someone who knows how to pull data automatically from a website and parse it up. How to calculate strength ratings of football teams? So every team has eight home and eight away games. Bar Bending Schedule (BBS) Excel Sheet (Sample Excel Sheet) Does this all make them good or bad? But almost immediately, we run into the problem. How to Make a Schedule in Excel - Lifewire This template shows a full week, starting with Monday. This formula is actually a weighted average: the Overall Opponent Winning Percentage has a double weight than the OOW%. Look at the chart and see that Houston is .34 points worse than average. And we just want to look at regular season games when evaluating strength of schedule. The remaining loan balance is equal to the beginning Loan amount minus the cumulative principal paid. The Palm Beach County Building Department will be the permitting agency for this project. If the home team equals Arizona, add up the away teams. Okay, so like the poor St. Louis Rams play in schedule that was three points tougher than average. For the sake of familiarity, lets assume were talking about the NFL. The averaging window is usually 14 days, but is sometimes more or less. Decrease by %: Use the formula =A1* (1-B1). This Learn a Stat ends here. The final point above mentions an offensive/defensive model, one which uses points scored and points allowed rather than simply margin of victory. the bids are just something we keep track of. Convert this back to points after it is output from the model, using some form of regression, to make bets, Find a way to efficiently account for injuries by determining how many points an injured or returning player is worth, Use a pattern-recognition algorithm to determine what a favorable bet looks like in terms of the spread and team strength ratings, Filter data through a neural network or other filter to determine best way to combine team strengths and current week number to determine expected outcome. 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. Also, what about using the weekly differentials as a standard for ranking the teams. On the contrary, several leagues do not incorporate SOS directly into team standings. 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. 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. 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. In Excel, times are stored as decimal values. You might, however, be hesitant regarding the positive impact of reporting on conformance? Sorry, I wan't capitalizing AVERAGE as commentary on your use of sumifs instead of averageifs only to try to clarify what I am after. These log-in and log-out times do not just include the start and end of the day, but they allow you to . At a glance, we see that Pittsburgh is the best (even without Roethlisberger, a scary thought), and that Carolina is the worst. Home Court Advantage in College Basketball. When Arizona was away, add up the home team's strengths and then divide by the number of games. ), Lets say you actually wanted to bet that Houston-Oakland game. Cite. 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. On this Wikipedia the language links are at the top of the page across from the article title. Calculate a percentage of increase. I mean, it's not true that every NFL team plays every other NFL team. 1. Okay, so I go to the function wizard, go under all functions, and I'll do count it. 2023 Coursera Inc. All rights reserved. In a game like baseball, where players act largely independently and the possible states of the game are relatively few, I think you can make it work. Retaining Wall Calculator EXCEL Sheet Combined Footing Design EXCEL Spreadsheet EXCEL spreadsheet calculator of cantilevered sheet-pile wall penetrating sandy soils Footing Design of Shear Wall per ACI 318-14 Meyerhof bearing capacity calculator View all files of Foundation Analysis and Design Load Calculation Beam Analysis EXCEL Spreadsheet So that's going to be tough on them. On the Home tab, click . Okay, I screwed up there because I need to dollar sign the O. Simulation of the NCAA basketball tournament will aid you in filling out your 2016 bracket. Step 1: We should enter the formula as Total Cost = (Fixed + Other) + (Variable * Units).as Total Cost = (Fixed + Other) + (Variable * Units). at this point i know what i want, and this will solve it, but im wondering if theres a simpler way. For example, if a team has lost a home game and won an away game and you want to give a weight of 1.5 to the away wins, the W% will be: The team obtained a W% of 60% instead of the normal 50% without different weights. All right. 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. 3.64 points above average. I am going with that Mark Lindsay's song, Arizona. Now remember 30 some odd points is one win. We need to make one final assumption in order to get values that have any meaning to us. Free Civil Engineering Files for Downloading - CivilEngineeringBible.com NFL Strength of Schedule - nfl stats & nfl rankings in Excel More complex systems are needed as the number of games drop or the number of teams increases. We can simply do this by dividing Man United's average goals scored/against (above formulas) by the Premier League averages. You must include at least two variables for correlation and they must form a contiguous block in your worksheet. As we get further into the season the web of games played becomes more complicated, and the problem becomes overwhelming. Loan balance at time Period: =Loan-Pmt*CalcPds. For example, a mid-level team may have a high W% only because it has faced weak teams. This will go in the "A" column. Select the cell range A1:E2, then select Merge & Center in the Alignment group of the Home tab. Alternatively, after selecting a cell, you can press ' Ctrl + 1 ' from the keyboard to get the dialog box. The project is a single-family residence to be built in unincorporated Palm Beach County, Florida. So we have no obvious way of determining how good they are, leaving us with nothing to say about how good the Texans are. To do so, you should first click and drag the divider between columns "A" and "B" to the right at least three spaces so you don't run out of writing room. Okay, and I want to do ranged mains here. 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. =((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.