CFM Spreadsheet Geeks

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Billy4NY
    Data = Power
    • Mar 2017
    • 89

    #1

    CFM Spreadsheet Geeks

    I am a huge CFM and like to dive deep into the details of my Franchise for the fun of it. I have used spreadsheets over the years for my franchises. Started out with pen and paper while trying to recruit players in NCAA 2007. Now, I use them to track how my players progressed with their ratings, quickly identify needs rather than flipping through the depth chart and roster menus in game, and use them for navigating contracts and projecting salary cap issues among other stat recording and schedule detailing that I have added in.

    I am looking for folks out there that use spreadsheets like me and I would like to see what kind of methods you use to track the details of your Franchise. Or for any CFM fan out there that finds this stuff interesting I would love to hear some feedback on how my spreadsheet is laid out or what I could add to it to make my CFM really come to life. To be clear, I am just looking for feedback on my spreadsheet and things I track vs. things I don't. I am NOT looking for criticism on how unrealistic I might play my games or manage my teams. I think CFM gives everyone the chance to make their own NFL world and each person should make it their own depending on their interests.

    You can see mine in the attached document. Here is a breakdown of each of the tabs and their purpose:

    NFL Roster: Track current and past players on my roster and their ratings while on my team. Also, included details of how they were acquired or why they departed the team.

    Draft Results: Records details of each draft. The key information on here that I like to track that the game won't is the True Talent Rank that is presented to you upon selecting a player. I find this adds to the story of a player's career.

    Contracts: Illustrates each player's current contract including their bonus. Other details included are their Overall, Age, and Development Trait to assist in making contract decisions. There is also a row that counts the N/A's for a given year so you know how many spots you might have to fill.

    NFL Recap: Shows final Division Standings for my division, Awards, Coaching Staff, Schedule Results, Playoff details for each round (including comments), and other misc. data that I have sometimes included.

    Season Stats: Records my players' season stats in Passing, Rushing, Receiving, and Defense for the relative top performers in each category. Also, included Team Stats off to the right.

    Note: If you are curious, I do play 15 minutes quarters on All-Madden with adjusted sliders.
    Attached Files
    Follow me on Twitter @Billy4NY for Madden tips and tools for your CFM
  • awffltony77
    MVP
    • Mar 2014
    • 1005

    #2
    Re: CFM Spreadsheet Geeks

    I'm all over this stuff. I do the same for CFM, for my Twins franchise on the Show, and for my Universe on WWE 2K18.

    I even double as a beat writer on my own stuff lol. I excited to check yours out.

    Sent from my REVVLPLUS C3701A using Operation Sports mobile app

    Comment

    • awffltony77
      MVP
      • Mar 2014
      • 1005

      #3
      Re: CFM Spreadsheet Geeks

      Aaaaaaand I can't open the file for some reason. I'll try my laptop....

      Sent from my REVVLPLUS C3701A using Operation Sports mobile app

      Comment

      • awffltony77
        MVP
        • Mar 2014
        • 1005

        #4
        Re: CFM Spreadsheet Geeks

        That is impressive. This is very well put together.

        IMO, all it is missing would be a page tracking the Eagles All Time statistical records. Career, Season, and Single game records are huge emersion factors for me.

        Sent from my REVVLPLUS C3701A using Operation Sports mobile app

        Comment

        • awffltony77
          MVP
          • Mar 2014
          • 1005

          #5
          Re: CFM Spreadsheet Geeks

          And NFL All Time leaders too, and how your CFM carries and alters those..

          Sent from my REVVLPLUS C3701A using Operation Sports mobile app

          Comment

          • reyes the roof
            Hall Of Fame
            • Mar 2009
            • 11525

            #6
            Re: CFM Spreadsheet Geeks

            I really like the draft results tab. I wish Madden kept track of draft classes so you could look back at an entire draft a few years after it took place and see who panned out and who didn't

            Comment

            • awffltony77
              MVP
              • Mar 2014
              • 1005

              #7
              Re: CFM Spreadsheet Geeks

              You seem to really know your way around excel too....pm me if you would have any interest in helping me set one up. My skills are Mendoza line on that.

              Sent from my REVVLPLUS C3701A using Operation Sports mobile app

              Comment

              • bravesfan1984
                MVP
                • Mar 2008
                • 2808

                #8
                Re: CFM Spreadsheet Geeks

                This is AWESOME! Would you happen to have a blank template you'd be willing to post? I'm definitely interested in using this for my own franchise I'm about to begin.
                Braves | Cowboys | ND Football | UNC Basketball | 4-Kevin Harvick


                Comment

                • Billy4NY
                  Data = Power
                  • Mar 2017
                  • 89

                  #9
                  Re: CFM Spreadsheet Geeks

                  Originally posted by bravesfan1984
                  This is AWESOME! Would you happen to have a blank template you'd be willing to post? I'm definitely interested in using this for my own franchise I'm about to begin.
                  Yeah I can post a blank template with some basic instructions on how to use it and when to fill it out. If you forget to fill it out at key points in CFM you will lose data forever. I can do it this weekend. You will need some basic excel skills like inserting columns and rows and basic formatting as well.
                  Follow me on Twitter @Billy4NY for Madden tips and tools for your CFM

                  Comment

                  • Billy4NY
                    Data = Power
                    • Mar 2017
                    • 89

                    #10
                    Re: CFM Spreadsheet Geeks

                    Originally posted by awffltony77
                    That is impressive. This is very well put together.

                    IMO, all it is missing would be a page tracking the Eagles All Time statistical records. Career, Season, and Single game records are huge emersion factors for me.

                    Sent from my REVVLPLUS C3701A using Operation Sports mobile app
                    I really like this idea. I will see what I can do about getting records and things added into it. I can help you set something help as well. A person below asked for a blank template that I will post this weekend as well.
                    Follow me on Twitter @Billy4NY for Madden tips and tools for your CFM

                    Comment

                    • bravesfan1984
                      MVP
                      • Mar 2008
                      • 2808

                      #11
                      Re: CFM Spreadsheet Geeks

                      Originally posted by Billy4NY
                      Yeah I can post a blank template with some basic instructions on how to use it and when to fill it out. If you forget to fill it out at key points in CFM you will lose data forever. I can do it this weekend. You will need some basic excel skills like inserting columns and rows and basic formatting as well.
                      I really appreciate it man! Look forward to using it for my Cowboys!

                      Sent from my SM-G920P using Operation Sports mobile app
                      Braves | Cowboys | ND Football | UNC Basketball | 4-Kevin Harvick


                      Comment

                      • Billy4NY
                        Data = Power
                        • Mar 2017
                        • 89

                        #12
                        Re: CFM Spreadsheet Geeks

                        Here is a blank version of it with some instructions on how to get your team colors perfectly into excel.

                        I am going to work on building out the instructions tab so you can see exactly how each tab is utilized and when exactly to fill them out. For now just use the original file I posted as an example. Feel free to post here more about questions, ideas, or anything else. I am glad to have found some people that enjoy this like I do.
                        Attached Files
                        Follow me on Twitter @Billy4NY for Madden tips and tools for your CFM

                        Comment

                        • awffltony77
                          MVP
                          • Mar 2014
                          • 1005

                          #13
                          Re: CFM Spreadsheet Geeks

                          Awesome man, thanks

                          Sent from my REVVLPLUS C3701A using Operation Sports mobile app

                          Comment

                          • bravesfan1984
                            MVP
                            • Mar 2008
                            • 2808

                            #14
                            Re: CFM Spreadsheet Geeks

                            Thank you sir!

                            Sent from my SM-G920P using Operation Sports mobile app
                            Braves | Cowboys | ND Football | UNC Basketball | 4-Kevin Harvick


                            Comment

                            • onetonmartin
                              Think Different
                              • Jul 2003
                              • 1048

                              #15
                              Re: CFM Spreadsheet Geeks

                              I love it. Thanks!

                              Comment

                              Working...