JWDixon's All-Inclusive Franchise Spreadsheet

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JWDixon120
    Rookie
    • Jul 2012
    • 802

    #91
    Re: JWDixon's All Inclusive Franchise Spreadsheet

    Huge Update just dropped for this project!

    Go check out the first post to see the details and the YouTube video that accompanies it!
    - 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

      #92
      Re: JWDixon's All Inclusive Franchise Spreadsheet

      Looks great. For whatever reason, some of the formulas (like the Park Factor when selecting a team, or the Trade Calculator) just come up #NAME? when I try to load it in Excel on my PC, but work fine in Sheets or on Excel on my Cell Phone. It's got to be something wrong with the version I'm using.

      But overall looks great. I'm coming up on the Trade Deadline in my franchise so I had happened to fool around with it a little bit just to gauge the value of trade candidates just before the update (like I had literally just finished when I saw your post about an update coming soon), so I did it again after the changes, and I really liked the adjustments you made. I thought the results aligned more closely with what I thought they would be.

      Sent from my Pixel 6 using Tapatalk

      Comment

      • JWDixon120
        Rookie
        • Jul 2012
        • 802

        #93
        Re: JWDixon's All Inclusive Franchise Spreadsheet

        Originally posted by DonkeyJote
        Looks great. For whatever reason, some of the formulas (like the Park Factor when selecting a team, or the Trade Calculator) just come up #NAME? when I try to load it in Excel on my PC, but work fine in Sheets or on Excel on my Cell Phone. It's got to be something wrong with the version I'm using.

        But overall looks great. I'm coming up on the Trade Deadline in my franchise so I had happened to fool around with it a little bit just to gauge the value of trade candidates just before the update (like I had literally just finished when I saw your post about an update coming soon), so I did it again after the changes, and I really liked the adjustments you made. I thought the results aligned more closely with what I thought they would be.

        Sent from my Pixel 6 using Tapatalk

        That’s great news about the trade calculator. I did some revamping to it and it seems in a much better place.

        It’s very hard to nail down so I still expect to see some head scratchers.


        And I built the sheet on the latest version of Excel so it could have something to do with the formula not being on an older version.

        You can always manually type your park factor in that cell if you’d like to get around that issue. You can find each team’s 5 year rolling park factors on Fangraphs!
        - 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

          #94
          Re: JWDixon's All Inclusive Franchise Spreadsheet

          I’ll be moving this back to google sheets for those who are still interested. I’ll have it out 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

          • millertime98
            Rookie
            • Apr 2016
            • 198

            #95
            Re: JWDixon's All Inclusive Franchise Spreadsheet

            Originally posted by JWDixon120
            I’ll be moving this back to google sheets for those who are still interested. I’ll have it out soon!
            I'm not sure what that means but...cool!

            Comment

            • DonkeyJote
              All Star
              • Jul 2003
              • 9192

              #96
              Re: JWDixon's All Inclusive Franchise Spreadsheet

              I noticed a small error in the way OBP is done on the stats page. There isn't a place for Sac Flys (SF), just Sac (which is a sacrifice bunt, and they count as a plate appearance, but don't count against your OBP). So right now the formula is (H+BB+HBP)/(AB+BB+HBP+Sac) when it should be (H+BB+HBP)/(AB+BB+HBP+SF) or alternatively (H+BB+HBP)/(Total Plate Appearances-Sac). Pretty easy fix, just added a column for SF and fixed the formula. But thought I'd let you know.

              Other solution would be to just change "Sac" to "SF" and not record Sac Bunts. OBP would be accurate, though Plate Appearances would be off.

              Sent from my Pixel 6 using Tapatalk

              Comment

              • Legaci3
                Rookie
                • Feb 2009
                • 331

                #97
                Re: JWDixon's All Inclusive Franchise Spreadsheet

                what happened to the re-rate old players screen?
                Currently Playing:
                MLB 23 The Show (PS5)

                GT: Ahh ToasTy
                PSN: StraightOuttaDR

                Comment

                • not_great_bob
                  Rookie
                  • Jun 2022
                  • 18

                  #98
                  Re: JWDixon's All Inclusive Franchise Spreadsheet

                  Was this ever translated to Google Sheets?

                  Comment

                  • mikep10
                    Rookie
                    • Aug 2009
                    • 189

                    #99
                    Re: JWDixon's All Inclusive Franchise Spreadsheet

                    Is there a link to the spreadsheet? I can't get the link to load.

                    Comment

                    • PhilDe47
                      Just started!
                      • Jan 2019
                      • 1

                      #100
                      Re: JWDixon's All Inclusive Franchise Spreadsheet

                      Originally posted by mikep10
                      Is there a link to the spreadsheet? I can't get the link to load.
                      Same for me. The link does not work.

                      Comment

                      • schutzk21
                        Rookie
                        • Jul 2014
                        • 12

                        #101
                        Re: JWDixon's All Inclusive Franchise Spreadsheet

                        Does anyone have a link to the spreadsheet they can share?

                        Comment

                        • JWDixon120
                          Rookie
                          • Jul 2012
                          • 802

                          #102
                          JWDixon's All Inclusive Franchise Spreadsheet

                          Originally posted by schutzk21
                          Does anyone have a link to the spreadsheet they can share?


                          https://docs.google.com/spreadsheets...f=true&sd=true



                          This updated link should work. Sorry guys, have been busy modding Madden and NCAA!



                          This sheet may have some of my old franchise data in it, so just delete that and enter your own info.
                          - 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

                            #103
                            Re: JWDixon's All Inclusive Franchise Spreadsheet

                            If anyone still uses this tool, drop me feature requests you’d like to see added for 2024!


                            -Franchise Fidelity to Reality Roster out Now!
                            -Creator of JWDixon’s Franchise Spreadsheet
                            -More coming 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

                            • bilbobeuli
                              Rookie
                              • Oct 2023
                              • 58

                              #104
                              Re: JWDixon's All Inclusive Franchise Spreadsheet

                              Originally posted by JWDixon120
                              If anyone still uses this tool, drop me feature requests you’d like to see added for 2024!


                              -Franchise Fidelity to Reality Roster out Now!
                              -Creator of JWDixon’s Franchise Spreadsheet
                              -More coming soon!

                              I'm trying to get back into '23, and wanted to user your spreadsheet for my franchise, especially because of the STORYLINE/EVENT GENERATORS.

                              But I can't seem to find them in the docs file?

                              Comment

                              • JWDixon120
                                Rookie
                                • Jul 2012
                                • 802

                                #105
                                Re: JWDixon's All Inclusive Franchise Spreadsheet

                                Originally posted by bilbobeuli
                                I'm trying to get back into '23, and wanted to user your spreadsheet for my franchise, especially because of the STORYLINE/EVENT GENERATORS.

                                But I can't seem to find them in the docs file?

                                https://docs.google.com/file/d/13SjG...letype=msexcel

                                Here’s a link to an old sheet with those. I removed them from my personal one!


                                -Franchise Fidelity to Reality Roster out Now!
                                -Creator of JWDixon’s Franchise Spreadsheet
                                -More coming 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...