sports

  1. J

    Season Fixtures extracted

    Hi All, Someone please help, I am trying to create a spreadsheet with my clubs sports fixtures for the coming season. The fixtures have been sent for the full league in the format below. I am trying to work a formula so that it will automatically extract the fixture for a set team and place...
  2. T

    VBA Listbox To Print Multiple Athlete's Workout Sheets Off The Same Sheet "Template"!?!

    Greetings! I was wondering if anyone can help me with a VBA question to make my life as a strength coach easier when trying to print off multiple workouts based on an athletes name? Ill try to explain as best as I can! I have a excel file that I use for each of my teams to collect data for...
  3. O

    Athletics - Creating a formula to calculate win/loss/tie

    I am creating an excel file in order to track the history of our football team. The excel sheet has the name of our opponents as well as the score for our team and the score for the opponent. I want to have another column that has a formula to calculate, based on the score, the result with a...
  4. M

    Sports Betting Excel Spreadsheet

    Hello All, I have recently aquired Excel 2010 and still getting used to. As the new football season is about to start I am looking to make a Spreadsheet with my football accumilator selections on. I am hoping to have a column with the odds of each bet, and at the bottom a formula which will...
  5. F

    Sports League Ranking With Tiebreakers

    Hello, I've seen numerous posts around this topic, but can't quite find one that meets my needs. I'm trying to create a ranking system for a non-profit sports league with tiebreakers. The following are the tiebreaker rules: Primary: Head to head Secondary: Team with higher points scored...
  6. F

    Random Team Scheduler Over Multiple Weeks

    <body> <p>Hi All,</p><p>I need help trying to make a team scheduler for a non-profit league using XL2003/7. I need to pick random opponents over an 8 week period for each team with no team playing each other more than once, and only playing one game each week. The number of teams can vary...
  7. B

    VBA Macro for Live Sports Odds

    Looking for a programmer who is able to write or has a stable Macro for Excel that pulls live sports odds from an online source, like SBRodds.com. The Macro will need to cover all listed tabs "Today, NFL, College Football, NBA, NCAA Basketball, MLB, NHL, Soccer, Tennis, WNBA, Arena Football...
  8. L

    Find Keyword and Paste in Worksheet with same name

    Hi, I currently have a macro that searches a whole list of sports results that i have already imported (column A:F) and when it finds the name of a team it then pastes that information onto a worksheet with the same name (First 3 letters), whether the team be home or away. It does however only...
  9. R

    Need complex formula for Volleyball league

    We have a volleyball league and we are looking for scheduling formula that can accommodate our leagues format: Number of teams varies from year to year: 12 this year Number of courts varies from year to year: 4 this year (teams/3 and rounded up) Number of weeks varies from year to year: 20 this...
  10. S

    Managing sports into seperate list and a master

    I am trying to create a spreadsheet that will contain the list of all athletes at our school. Other sheets (Tabs at the bottom) are to have each sport and those athletes that participate in that sport. As I add a new student (athlete) to the master list, I want them to add or delete from the...
  11. D

    Soccer stats and relations

    Hi all, I have recently started using PowerPivot to analyze historical soccer results and so far I have been enjoying working with the tool. However, I have come across one obstacle that I can't seem to get past so I hope you are able to help me out. Currently my PowerPivot model has two...
  12. R

    Sports Possession and Territory Calculator

    Hi All I've been trying to set up a Sport Analysis capability for local sports clubs. Many are quite poorly funded and can't afford high end subscription based tools for doing in-game analysis for rugby and football. I've been searching online and haven't been able to track down a free...
  13. N

    Sports Fixture Table in excel

    does anyone know any spreadsheets that have formulas that can possible answer my questions? Task Jo needs to create an ICT solution that will enhance the efficiency of running Westwood Hockey Club. Jo will be the main user of the system. The proposed ICT solution will need to be presented to...
  14. K

    Establishing Sports Standings on Excel, Formulas needed

    I'm trying to tie the name of a team to their wins and losses so that they ascend or descend based on their performance and on other team performances. What exactly would be the formula to establish this linking. It would have to involve both the team name, the team record and win percentage as...
  15. T

    If IsError and WorksheetFunctions

    Hey guys, I am developing a function that does a couple of things. First, the user specifies player names in 'Scores'!A1:A1000, and then various statistics in 'Scores'!B1:G1000. The function loops through these entries, and then updates the corresponding cells in the 'Lifetime Statistics'...
    • Tom59593
    • Thread
    • error handling if statement iserror sports worksheetfunction
    • Replies: 1
    • Forum: Excel Questions
  16. T

    From Row and Column to Cell Position

    Hey guys, I searched the forum for a while and couldn't find anything related to this, so hopefully someone knows a simple way to accomplish what I'm trying to do. What I have going on in a little application I'm developing for a sports league is this: 1) The user selects a name from a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top