soccer

Good Evening, I am in charge of creating the workbook to use for the soccer league I play in to keep track of the top scorers for both male and female players, and also for the red cards and yellow cards. I have sheet with tables for each team with each player, their gender and how many goals...

Hello All, Thanks for having this wonderful forum and I request your help with a small challenge of mine. I am new to excel and not sure if excel can do this at all, but I give it a try. We have a small team of players(around 30) out of which around 20 who come every week to play soccer. The...

Hi everyone, I have a very basic understanding of Excel and have seen a few YouTube tutorials on formulas etc. however what I am looking for is some help on this fantasy league I've created, It's a 10 team league based on the 2021/22 Premier League fixtures. I want to be able to input the office...

I am trying to use a formula to calculate 10% time improvements on my student's mile run times. I came up with a workaround to split the minutes and seconds into different cells, convert them into total seconds, multiply by .90, then divide by sixty to get Min.Sec. Not fully working though as I...

is there a book i can read or someone who does lessons on that? what i need is to insert the soccer data,and after using formulas like poisson.distr. to give possibilities for certain outcomes

Hello, I have a reception Im going to be keeping track of those people who arrive and I need 2 formulas to keep track of how many group of people have arrived, and of those how many of them are getting an award. I'm not sure how to attach my spreadsheet anymore since I've gone to Excel 2016 so...

How many possible outcomes are there in 8 soccer matches

I help run a pick up soccer league in my hometown and we are always arguing about unfair/unbalanced teams so I am praying someone on here can help me come up with a macro to solve this. I have created this spreadsheet - https://1drv.ms/x/s!Ailn0TMJeSXLidw46xoEz-WElsxGaw What I am hoping is...

Hi all-- I need help on how to transpose a large set of data which contains: year, term, student id, and sports. It gets complicated because there are some students that played multiple sports each term. Here's what the raw data looks like: <tbody> YEAR_CODE TERM_CODE ID NUM SPORTS...

Hi Folks Just wondering if someone can help me speed up a process. In the attached sheet you will see some sets of soccer results which I type in as text on sheet 1. What I want to do is combine the sets of results from both teams in order to find the most likely scoreline at full time,and...

I am after a formula that tells me if a bet I have placed has won and in what way. It is to do with Asian handicap betting. I shall explain more. I have a bet in a1 that I have made. It may be -1, which means that I have bet on the away team to win by 1 or more goals. It could be a positive...

Hi everybody! I'm a novice when it comes to vba and using external data. Can someone please tell me how to get the data from the following web source: https://www.norsk-tipping.no/page?id=22 This is a secure norwegian gaming website from "Norsk Tipping" - the only legal betting company in...