JWDixon's All-Inclusive Franchise Spreadsheet

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • LegendKillerOne
    MVP
    • Jan 2019
    • 1764

    #76
    Re: JWDixon's All Inclusive Franchise Spreadsheet

    Originally posted by JWDixon120
    Just checked it out. Looks like a great way to stay organized.

    Really wish you could upload franchise data to the cloud to make a lot of this stuff more automated :/
    Thanks, Basically what I did was I went to fangraphs/roster resource or whatever that site is that has all the roster depth charts. I paid for a year suscription was like $30, then you are able to download each teams depth chart in excel. Did that then took out the lines I didnt need and copy and paste and did not take too long
    Mets Baseball, All Day Every Day

    Bringing the trophy back to the Queens in MLB the Show 25.

    Baseball is my life





    Comment

    • TexasDBack
      Rookie
      • Feb 2016
      • 122

      #77
      Re: JWDixon's All Inclusive Franchise Spreadsheet

      Originally posted by JWDixon120
      Gray is demanding $7m in game, but my tool suggests he should demand closer to $12m.

      Which IRL Gray is on a 14m year deal so it’s close.


      I use 30 team control, so when I’m making decisions to resign players, this keeps me from giving guys way less then they should be getting compared to IRL.
      Oh man - this is going force me to look at my "maybe I'm getting too much value for this to be an honest franchise" and stop getting tons of value for way cheaper than I should.

      Comment

      • JWDixon120
        Rookie
        • Jul 2012
        • 802

        #78
        Re: JWDixon's All Inclusive Franchise Spreadsheet

        Originally posted by TexasDBack
        Oh man - this is going force me to look at my "maybe I'm getting too much value for this to be an honest franchise" and stop getting tons of value for way cheaper than I should.

        This is exactly why I made it lol.

        I need to make a Braves toggle where it drops all demand by 7-10m a year.
        - Franchise Fidelity to Reality Roster out now! (MLB 25)
        - Creator of JWDixon's Franchise Spreadsheet, Contract Tool, Trade Calculator, Lineup Optimizer, (I need a hobby)
        - More coming soon, as always!

        Comment

        • TexasDBack
          Rookie
          • Feb 2016
          • 122

          #79
          Re: JWDixon's All Inclusive Franchise Spreadsheet

          Originally posted by JWDixon120
          This is exactly why I made it lol.

          I need to make a Braves toggle where it drops all demand by 7-10m a year.
          Is it live on the version linked on page 1? Went to check it out and didn't see a tab for it.

          Comment

          • JWDixon120
            Rookie
            • Jul 2012
            • 802

            #80
            Re: JWDixon's All Inclusive Franchise Spreadsheet

            Originally posted by TexasDBack
            Is it live on the version linked on page 1? Went to check it out and didn't see a tab for it.

            I have to relink the correct one. I’ll do that now.
            - Franchise Fidelity to Reality Roster out now! (MLB 25)
            - Creator of JWDixon's Franchise Spreadsheet, Contract Tool, Trade Calculator, Lineup Optimizer, (I need a hobby)
            - More coming soon, as always!

            Comment

            • elkins6374
              Rookie
              • Oct 2014
              • 11

              #81
              Re: JWDixon's All Inclusive Franchise Spreadsheet

              Hey bro I noticed something last night while I was working on the spreadsheet. In the Veteran Regression Calendar there were no formulas set up for position players statistics to provide an adjusted rating for them.

              Comment

              • JWDixon120
                Rookie
                • Jul 2012
                • 802

                #82
                Re: JWDixon's All Inclusive Franchise Spreadsheet

                Originally posted by elkins6374
                Hey bro I noticed something last night while I was working on the spreadsheet. In the Veteran Regression Calendar there were no formulas set up for position players statistics to provide an adjusted rating for them.

                Still working on those for the hitters haha
                - Franchise Fidelity to Reality Roster out now! (MLB 25)
                - Creator of JWDixon's Franchise Spreadsheet, Contract Tool, Trade Calculator, Lineup Optimizer, (I need a hobby)
                - More coming soon, as always!

                Comment

                • barko26
                  Rookie
                  • Jan 2022
                  • 14

                  #83
                  Re: JWDixon's All Inclusive Franchise Spreadsheet

                  Just wondering if you ever got around to updating/finishing off new version before I finally get around to starting my franchise? I used this last year and loved it.

                  Comment

                  • JWDixon120
                    Rookie
                    • Jul 2012
                    • 802

                    #84
                    Re: JWDixon's All Inclusive Franchise Spreadsheet

                    Originally posted by barko26
                    Just wondering if you ever got around to updating/finishing off new version before I finally get around to starting my franchise? I used this last year and loved it.

                    The link you see in the first post is the most updated version of the sheet!

                    I’ve made some changes but nothing major.
                    - Franchise Fidelity to Reality Roster out now! (MLB 25)
                    - Creator of JWDixon's Franchise Spreadsheet, Contract Tool, Trade Calculator, Lineup Optimizer, (I need a hobby)
                    - More coming soon, as always!

                    Comment

                    • DonkeyJote
                      All Star
                      • Jul 2003
                      • 9192

                      #85
                      Re: JWDixon's All Inclusive Franchise Spreadsheet

                      Originally posted by JWDixon120


                      TRADE VALUE CALCULATOR
                      • Enter a players Previous 3 years WAR, Games Played, and Contract Info and a Trade Value is spit back out.
                      • Use this to compare when making trades between MLB Players
                      • Also use the Prospect Value sheet to reference when trades involving Farmhands.
                      • This calculation is based on the MLB The Show 20 Trade Discussion Thread
                      I'm going over some trades and trying to even them out, and not really sure what Prospect Value sheet you mean. I don't see where that is?

                      Sent from my Pixel 6 using Tapatalk

                      Comment

                      • JWDixon120
                        Rookie
                        • Jul 2012
                        • 802

                        #86
                        Re: JWDixon's All Inclusive Franchise Spreadsheet

                        Originally posted by DonkeyJote
                        I'm going over some trades and trying to even them out, and not really sure what Prospect Value sheet you mean. I don't see where that is?

                        Sent from my Pixel 6 using Tapatalk

                        That was for the old trade calculator. The new one takes into account potentials and all but the values need to be refined.
                        - Franchise Fidelity to Reality Roster out now! (MLB 25)
                        - Creator of JWDixon's Franchise Spreadsheet, Contract Tool, Trade Calculator, Lineup Optimizer, (I need a hobby)
                        - More coming soon, as always!

                        Comment

                        • bangthetrashcan
                          Rookie
                          • Jan 2021
                          • 7

                          #87
                          Re: JWDixon's All Inclusive Franchise Spreadsheet

                          This is awesome! Excited to use this as I'm finally starting my Angels franchise

                          Comment

                          • bangthetrashcan
                            Rookie
                            • Jan 2021
                            • 7

                            #88
                            Re: JWDixon's All Inclusive Franchise Spreadsheet

                            Unsure if you are still taking suggestions, but a storyline/event generator would be cool for FA! Could have different events of either a player wanting to re-sign, go to his hometown team, play for a big market team, or sign with the team that offers the most. Just a fun thought

                            Comment

                            • JWDixon120
                              Rookie
                              • Jul 2012
                              • 802

                              #89
                              Re: JWDixon's All Inclusive Franchise Spreadsheet

                              Originally posted by bangthetrashcan
                              Unsure if you are still taking suggestions, but a storyline/event generator would be cool for FA! Could have different events of either a player wanting to re-sign, go to his hometown team, play for a big market team, or sign with the team that offers the most. Just a fun thought

                              Always taking suggestions!

                              I’ll have to look into adding these in!
                              - Franchise Fidelity to Reality Roster out now! (MLB 25)
                              - Creator of JWDixon's Franchise Spreadsheet, Contract Tool, Trade Calculator, Lineup Optimizer, (I need a hobby)
                              - More coming soon, as always!

                              Comment

                              • JWDixon120
                                Rookie
                                • Jul 2012
                                • 802

                                #90
                                Re: JWDixon's All Inclusive Franchise Spreadsheet

                                Gonna have a big update coming to the sheet soon!
                                - Franchise Fidelity to Reality Roster out now! (MLB 25)
                                - Creator of JWDixon's Franchise Spreadsheet, Contract Tool, Trade Calculator, Lineup Optimizer, (I need a hobby)
                                - More coming soon, as always!

                                Comment

                                Working...