Dynasty Spreadsheets

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • huskerfan01
    Rookie
    • Jan 2013
    • 490

    #1

    Dynasty Spreadsheets

    Hey Guys,

    I've seen this thread before, but it's not active so might as well start a new one. Who all uses a spreadsheet to keep track of their dynasty? I just built a new one so if anyone needs a template, let me know. Also, if you post links I can go ahead and update this OP and get you guys some views on them.

    Feedback would be appreciated to help out the community as much as you can! Also, I might go start a dynasty over on the specific forum for that but I'll keep you guys updated!

    huskerfan01: Marshall Thundering Herd
    Nebraska Cornhuskers
  • AKEjcl41
    Rookie
    • May 2017
    • 158

    #2
    Re: Dynasty Spreadsheets

    I'll take a look at one!! I use a spreadsheet to keep track of my recruiting, and dynasty but not very detailed on the dynasty...I'd like to see what you got...


    #GBR baby!!!!!!!!!!!

    Comment

    • whughes
      MVP
      • Jul 2012
      • 1688

      #3
      Re: Dynasty Spreadsheets

      I've been using Jello's for around 15 seasons now across 2 dynasties and I love it.m
      Check out my dynasty thread:
      http://www.operationsports.com/forum...post2047930775

      Fan of:
      Chicago Bears
      U of M Wolverines
      CMU Chippewas


      Comment

      • FarFromEer
        Rookie
        • May 2014
        • 213

        #4
        Re: Dynasty Spreadsheets

        Here's mine. I'm in the middle of starting my dynasty over (again), so it reflects a previous dynasty setup.

        My spreadsheet began as a way to speed up recruiting, but grew into a much bigger ordeal. I use Skulletor's DB editor's File->Dump Tables to quickly export all of the dynasty tables, then use the import feature of Excel to populate the spreadsheets in the Data Builders folder. From there, it's copy and paste into the RecruIQ spreadsheet.

        Comment

        • Hellisan
          Fan of real schools
          • Jul 2002
          • 1893

          #5
          Re: Dynasty Spreadsheets

          I use several, but they're a mess and I should probably coalesce them.

          I noticed your recruiting rules. I totally agree with the liberal allowance of recruiting 3-star guys for 2-star and up. They screwed up and 3-star is largely 2-star players, like half of it. The 2-star pool is WAY too small. For this reason I divided the 3-stars essentially in half every year and fibbed about 2-star/3star to some extent. Just random thought you didn't ask for.

          Comment

          • Heyuimintojsus
            Pro
            • Nov 2004
            • 759

            #6
            Re: Dynasty Spreadsheets

            Originally posted by huskerfan01
            Hey Guys,

            I've seen this thread before, but it's not active so might as well start a new one. Who all uses a spreadsheet to keep track of their dynasty? I just built a new one so if anyone needs a template, let me know. Also, if you post links I can go ahead and update this OP and get you guys some views on them.

            Feedback would be appreciated to help out the community as much as you can! Also, I might go start a dynasty over on the specific forum for that but I'll keep you guys updated!

            huskerfan01: Marshall Thundering Herd
            Interesting. Looks like a lot of busy work? How does the random.org thing work?

            Comment

            • huskerfan01
              Rookie
              • Jan 2013
              • 490

              #7
              Re: Dynasty Spreadsheets

              Originally posted by AKEjcl41
              I'll take a look at one!! I use a spreadsheet to keep track of my recruiting, and dynasty but not very detailed on the dynasty...I'd like to see what you got...


              #GBR baby!!!!!!!!!!!
              Gonna be an interesting year with new system on D and new QB.

              Originally posted by whughes
              I've been using Jello's for around 15 seasons now across 2 dynasties and I love it.m
              Mind sharing it?

              Originally posted by mcfeenathan
              Here's mine. I'm in the middle of starting my dynasty over (again), so it reflects a previous dynasty setup.

              My spreadsheet began as a way to speed up recruiting, but grew into a much bigger ordeal. I use Skulletor's DB editor's File->Dump Tables to quickly export all of the dynasty tables, then use the import feature of Excel to populate the spreadsheets in the Data Builders folder. From there, it's copy and paste into the RecruIQ spreadsheet.

              https://drive.google.com/open?id=0B7...21DSFhjRjJYdEU
              I have Mac so I can't use the editor. Looks good though.

              Originally posted by Hellisan
              I use several, but they're a mess and I should probably coalesce them.

              I noticed your recruiting rules. I totally agree with the liberal allowance of recruiting 3-star guys for 2-star and up. They screwed up and 3-star is largely 2-star players, like half of it. The 2-star pool is WAY too small. For this reason I divided the 3-stars essentially in half every year and fibbed about 2-star/3star to some extent. Just random thought you didn't ask for.
              Yeah it gives it more of a challenge. If it's Week 8 and you have about 1000 points to spend, you can target a 5* that's about a 14-16% lock and still get him despite not even being in Top 10.

              Originally posted by Heyuimintojsus
              Interesting. Looks like a lot of busy work? How does the random.org thing work?
              Eh. It's nice to keep track of everything and see how it all plays out over my entire dynasty. Random.org just chooses a team for you.
              Nebraska Cornhuskers

              Comment

              • Mattyspence503
                Rookie
                • Jul 2011
                • 42

                #8
                Re: Dynasty Spreadsheets

                Ive made a few for various dynasty trackers over the years, the NCAA one and my NHL one are the most used.

                Attached is my current NCAA Dynasty
                Attached Files

                Comment

                • BV28
                  MVP
                  • Aug 2009
                  • 1125

                  #9
                  Re: Dynasty Spreadsheets

                  How can I keep track if I don't have excel?

                  Comment

                  • huskerfan01
                    Rookie
                    • Jan 2013
                    • 490

                    #10
                    Re: Dynasty Spreadsheets

                    Originally posted by Hushroom
                    How can I keep track if I don't have excel?
                    Google Sheets. Just need a Google account (free). It's basically excel, has all the same functions as it.
                    Nebraska Cornhuskers

                    Comment

                    • AKEjcl41
                      Rookie
                      • May 2017
                      • 158

                      #11
                      Re: Dynasty Spreadsheets

                      I just made my own the other day in Microsoft word....idk how to attach it though...it keeps telling me its an invalid file....but if you want to see it or use it as a template I can send it via email or something...

                      Comment

                      • shockscape
                        Rookie
                        • Jan 2014
                        • 9

                        #12
                        Re: Dynasty Spreadsheets

                        I copied Jello's spreadsheet over to Google Sheets and added a few things for myself. I have worked my way to season 18 in my dynasty and love it. I still play the game almost everyday!

                        Edit: Link as requested

                        https://docs.google.com/spreadsheets...it?usp=sharing
                        Last edited by shockscape; 08-19-2017, 05:40 PM.

                        Comment

                        • huskerfan01
                          Rookie
                          • Jan 2013
                          • 490

                          #13
                          Re: Dynasty Spreadsheets

                          Originally posted by shockscape
                          I copied Jello's spreadsheet over to Google Sheets and added a few things for myself. I have worked my way to season 18 in my dynasty and love it. I still play the game almost everyday!
                          Would you mind sharing it? I'd love to see it! Thank you.
                          Nebraska Cornhuskers

                          Comment

                          • Skyflame21
                            Rookie
                            • Mar 2013
                            • 310

                            #14
                            Re: Dynasty Spreadsheets

                            A site I use a lot is avidmanager.com. It's Free to use and very good for tracking dynasties.

                            Comment

                            • croc500
                              Rookie
                              • Jul 2004
                              • 414

                              #15
                              Re: Dynasty Spreadsheets

                              Id like to get the file from the original post and Jello's. Any help in obtaining those would be appreciated.

                              Comment

                              Working...