+ Reply to Thread
Results 1 to 11 of 11

**FUN** Help with projecting MLB season final standing, etc.

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    **FUN** Help with projecting MLB season final standing, etc.

    Ok, I'm following the Braves this year and their record to date is 10-1. I want to project the final regular season wins and losses based on each game's outcome. The problem I'm having is 'locking' the 162 cell for formula purposes and 'filling' the column down. Excel moves the next cell down when "CTRL+D" is pressed and I can't figure this one out.
    How do I lock the formula so I can fill down?
    Attaching what I have down.
    It's no biggie. Just having fun with my brother on FB.
    Help would be appreciated though.
    All the best to you and your sport and team.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: **FUN** Help with projecting MLB season final standing, etc.

    Hi Cilla,

    Welcome to the forums

    add an additional $ to your G1 cell reference:

    =($G$1*F5)

    Steve=True

  3. #3
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: **FUN** Help with projecting MLB season final standing, etc.

    j4 cell =($G$1*F4)

    $ signs locks the cell.
    Appreciate the help? CLICK *

  4. #4
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: **FUN** Help with projecting MLB season final standing, etc.

    I LOVE you guys (AND THIS FORUM)!!! Thanks so much for your help. Maybe some more stats will come during the season.

  5. #5
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: **FUN** Help with projecting MLB season final standing, etc.

    I just wish I knew how to post this thread as closed with a thank you to you both. Sorry.

  6. #6
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: **FUN** Help with projecting MLB season final standing, etc.

    u have one other problem with your spreadsheet - you are following the braves lol

    check out this post

    http://www.exceldashboardtemplates.c...oard-templates

    steve=true

  7. #7
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: **FUN** Help with projecting MLB season final standing, etc.

    Ok, next question and thank you again for your help. But where 122 is was 121.5. so I rounded up. 122 +41=163 How do I keep 162 as the constant?
    Any help again, greatly appreciated. (I feel so stupid)

    games played won lost percentage on pace for

    4 3 1 0.750 122 41

  8. #8
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: **FUN** Help with projecting MLB season final standing, etc.

    LAST QUESTION>>>>I swear. Is it possible to show a line chart of the projected finish?
    I'm done.

  9. #9
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: **FUN** Help with projecting MLB season final standing, etc.

    OMG that had me rollin!

    Thanks Steve. (Must be a Philly fan) hahaha

  10. #10
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: **FUN** Help with projecting MLB season final standing, etc.

    Hi Cilla,

    Go Bogs

    LOL

    Check out this file.

    Braves 2013 (2) with chart.xlsx

    I updated your formulas and created a chart for you and added a trend line and a playoff cut line:

    It uses these techniques:

    How-to Make Dynamic Excel Dashboard Charts Using Tables

    How-to Create a Dynamic Banding on an Excel Line Chart

    Case Study - Creating a Dynamic Chart in Excel Using Offset Formula


    Let me know what you think.

    Steve=True

  11. #11
    Registered User
    Join Date
    07-05-2011
    Location
    Grand Cayman
    MS-Off Ver
    Excel 2003
    Posts
    12

    Talking Re: **FUN** Help with projecting MLB season final standing, etc.


    STEVE!!! That is absolutely incredible!
    I couldn't believe it when I opened it up.
    You are amazing!!
    I can't thank you enough!
    THAT MADE MY SEASON!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1