wins

In our Bocce ball league, 2 games are played in each match. If a team wins both games they get a score of 2 wins and 0 losses. If a team wins one game and loses the other game they get a score of 1 win and 1 loss. If the team loses both games they get a score of 0 wins and 2 losses. The score...

I have the following data: <tbody> A B C D E 1 Team 1 1 Team 2 2 2 Team 3 2 Team 4 1 3 Team 1 1 Team 3 2 4 Team 4 1 Team 1 2 5 Team 2 2 Team 1 1 6 7 Team 1-Wins Team 1-Losses </tbody> Whenever a team wins, a 1 is entered manually into Column B or Column D...

Hi all, First time posting and looking for some help regarding a set of sports statistics. I am looking to analyze the effect of home court advantage in the 2018-2019 season and wanted to be able to control for how many wins each team has at a certain time in the season. I currently have a set...

Hello there, I am looking for a formula that can handle returning an index value based on header names instead of index number. This is because the data source is dynamic. The location of the index value I am looking for will vary depending on the source. There are two reliable constants...

I have been lurking for a while, reading a lot of great questions and answers! I could use some help that is a little above my excel pay grade: I am looking to compare two or more college wrestlers against common opponents. Results are posted in a dual-meet format so: 125 lbs wrestler 1 dec...

I thought I had this figured out, but it's doing my head in now! I'm trying to calculate the total value of WINS only. Can anyone help? Thank you.

Hi all, I have 2 criteria, and based on which one is rtue I would like the colour of a line on the line graph to change. I am doing this for points in a tennis match to show the momentum changes. If Roger Federer wins the point the line graph goes up by 1, is Novak Djokovic wins a point the...

Hi all. I am looking to use a line graph to show momentum changes in a tennis match. I have a column showing momentum change ( +1 whenever player A win's a point and -1 when player B win's the point). I have then used an IF function so show when player A wins the point but show NA () when...

Hello experts, I am trying to create a volleyball league schedule on excel where I can place scores(I14:I17, K14:K17, Q14:Q17, S14:S17) that automatically calculate and update the cells that show the standings (E2:E9, F2:F9). A B C D E F...

Hello everyone, I have an issue. I have made a chart for a game im playing. when i win a match i will type in W and it will automatically show me how much money i made with the use of IF functions. if i put in an L it will do for losing. like this: https://ibb.co/gcBD2U As you can see i have...

Hi all I am trying to build something to use for my local darts and dominoes league and are unsure which one is best for what I need and am looking for help. I have downloaded some football spreadsheets from internet where you enter the score and it updates the league but our league is based...

I have tried to simplify this in my small brain and try to present it to this forum in a manner which respected their time (and solicited a quick/ easy answer). But when I try to simplify, I lose the challenge. Basically I am confusing myself. Is there anyone who could take a look at this and...

I had a hard time thinking of a good title for this since it is hard to explain. here is what I am hoping to achieve... There are four individual games that are each worth a point. If someone wins the game, then they win 1 point. If nobody wins the game, then that point "carries over" and...

Hello, I would like to know how i could sum the most consecutive wins in dollars in column A, and the average consecutive wins in column B. In the table below, you can see in column A1:A3, three consecutive dollar wins which should total $43. How do i go about calculating the largest sum in...

Upon search I have found https://www.mrexcel.com/forum/excel-questions/830707-calculating-current-streak-record-last-10-games.html but I cannot get it to work like it is written. Upon edited many time all I could ever get it to do was show 10W all the time. I too have a sheet (Sheet1) with a...

Hi All, I am looking for assistance for a mathematical formula to be able to turn my assessed win betting prices (win %) into place betting probabilities. The below should explain the equation a little further. <tbody> W% 2nd % 3rd % Horse 1 35 Horse 2 15 Horse 3 13 Horse 4 10...

Hello. I want to count the number of consecutive wins in a table. Below I have an example. <tbody> $40 -$20 $25 $10 $5 $41 $32 -$5 $9 -$12 </tbody> My goal is to be able to count how many consecutive wins I was able to get. The example shows 4 consecutive wins <tbody>...

Good evening, I'm looking for some help. I created a workbook, that has functions across sheets and tables(2). I created this book before I actually had any training in excel, and that was only an intro. It may seem a bit amature, but it is functional. I would like to make even more so, by...

The pool Match consists of 7 games and the 4th game is always a doubles game. Teams must have at least 6 players so 2 players could play a doubles game as well as their singles game. Please refer to the spreadsheet link. There are two tables, one for fixture and results details and the other for...

So I am trying to track wins, losses and ties and by a certain league/team. <tbody> Result Team W A Team A W's L's Tie W B W C Team B W's L's Tie L A L A Team C W's L's Tie W B L B W C L C </tbody> So I want it to look at the result in Col A, then...