Using Excel as editor?

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • snepp
    We'll waste him too.
    • Apr 2003
    • 10007

    #16
    Re: Using Excel as editor?

    It's not dumb, it's actually a "feature" of the windows operating system to hide various file extensions. I'm assuming that's the issue here...

    Open up your data folder
    Click Tools
    Click Folder Options
    Click the View tab
    Remove the checkmark next to "Hide file extensions of known file types"

    If this is already unchecked then all you should have to do is right click on the file, go to rename, and remove the "dat" at the end of the name and replace it with "txt".
    Member of The OS Baseball Rocket Scientists Association

    Comment

    • snepp
      We'll waste him too.
      • Apr 2003
      • 10007

      #17
      Re: Using Excel as editor?

      It's not dumb, it's actually a "feature" of the windows operating system to hide various file extensions. I'm assuming that's the issue here...

      Open up your data folder
      Click Tools
      Click Folder Options
      Click the View tab
      Remove the checkmark next to "Hide file extensions of known file types"

      If this is already unchecked then all you should have to do is right click on the file, go to rename, and remove the "dat" at the end of the name and replace it with "txt".
      Member of The OS Baseball Rocket Scientists Association

      Comment

      • Reddog2
        Rookie
        • Oct 2002
        • 346

        #18
        Re: Using Excel as editor?

        That was it. Thanks!

        Comment

        • Reddog2
          Rookie
          • Oct 2002
          • 346

          #19
          Re: Using Excel as editor?

          That was it. Thanks!

          Comment

          • snepp
            We'll waste him too.
            • Apr 2003
            • 10007

            #20
            Re: Using Excel as editor?

            Really? I wasn't actually expecting to solve a problem on my first try, usually takes 4 or 5....

            Member of The OS Baseball Rocket Scientists Association

            Comment

            • snepp
              We'll waste him too.
              • Apr 2003
              • 10007

              #21
              Re: Using Excel as editor?

              Really? I wasn't actually expecting to solve a problem on my first try, usually takes 4 or 5....

              Member of The OS Baseball Rocket Scientists Association

              Comment

              • RsNation6
                Rookie
                • Apr 2003
                • 32

                #22
                Re: Using Excel as editor?

                What does this "starpower" attribut under the atrib.dat file, 41 playerattrib_starpower???

                Comment

                • RsNation6
                  Rookie
                  • Apr 2003
                  • 32

                  #23
                  Re: Using Excel as editor?

                  What does this "starpower" attribut under the atrib.dat file, 41 playerattrib_starpower???

                  Comment

                  • RsNation6
                    Rookie
                    • Apr 2003
                    • 32

                    #24
                    Re: Using Excel as editor?

                    sorry about the double post but, what is a .csv, and how do i save as that in Excel?

                    Comment

                    • RsNation6
                      Rookie
                      • Apr 2003
                      • 32

                      #25
                      Re: Using Excel as editor?

                      sorry about the double post but, what is a .csv, and how do i save as that in Excel?

                      Comment

                      • snepp
                        We'll waste him too.
                        • Apr 2003
                        • 10007

                        #26
                        Re: Using Excel as editor?

                        Star power has alot to do with how much money they ask for and also how much they will improve after a season.

                        A .csv file is virtually the same as the .dat, identical format, comma-delimited.

                        When you click "file" and "save-as" you can choose to save the file as a .csv.

                        good luck

                        sn
                        Member of The OS Baseball Rocket Scientists Association

                        Comment

                        • snepp
                          We'll waste him too.
                          • Apr 2003
                          • 10007

                          #27
                          Re: Using Excel as editor?

                          Star power has alot to do with how much money they ask for and also how much they will improve after a season.

                          A .csv file is virtually the same as the .dat, identical format, comma-delimited.

                          When you click "file" and "save-as" you can choose to save the file as a .csv.

                          good luck

                          sn
                          Member of The OS Baseball Rocket Scientists Association

                          Comment

                          • LhasaCM
                            Rookie
                            • Apr 2003
                            • 9

                            #28
                            Re: Using Excel as editor?

                            Actually...formulas can work. It's just a little tricky (i.e. risky) because of the steps you have to take.

                            For example, we take the speed column. When I open up the file in Excel, this is column W.

                            The "playerattrib_speed" value is 5 characters for everyone. We can increase everyone's speed by 10% by doing the following:

                            1. Insert three columns to the right of the speed column
                            2. In new column #1 (column X), insert the following formula in the first data row: =value(right(W2,2))
                            3. In new column #2 (column Y), insert the following formula in the first data row: =1.1*X2
                            4. In new column #3 (coumn Z), insert the following formula in the first data row: =concatenate("21 ",Y2)
                            5. Fill down on all three columns
                            6. Copy the header from column W to the third new column (column Z)
                            7. Copy column Z.
                            8. Right click on column W. Select "Paste Special..." and select Values.
                            9. The new speed values are now entered into the speed column.
                            10. Delete the three new columns.
                            11. Save as snepp detailed above.

                            Naturally, you can make the formula more complicated and do all sorts of neat things if so desired.

                            As always, make sure you back up the data file before editing, since funky things can and do happen.

                            Good luck!

                            Comment

                            • LhasaCM
                              Rookie
                              • Apr 2003
                              • 9

                              #29
                              Re: Using Excel as editor?

                              Actually...formulas can work. It's just a little tricky (i.e. risky) because of the steps you have to take.

                              For example, we take the speed column. When I open up the file in Excel, this is column W.

                              The "playerattrib_speed" value is 5 characters for everyone. We can increase everyone's speed by 10% by doing the following:

                              1. Insert three columns to the right of the speed column
                              2. In new column #1 (column X), insert the following formula in the first data row: =value(right(W2,2))
                              3. In new column #2 (column Y), insert the following formula in the first data row: =1.1*X2
                              4. In new column #3 (coumn Z), insert the following formula in the first data row: =concatenate("21 ",Y2)
                              5. Fill down on all three columns
                              6. Copy the header from column W to the third new column (column Z)
                              7. Copy column Z.
                              8. Right click on column W. Select "Paste Special..." and select Values.
                              9. The new speed values are now entered into the speed column.
                              10. Delete the three new columns.
                              11. Save as snepp detailed above.

                              Naturally, you can make the formula more complicated and do all sorts of neat things if so desired.

                              As always, make sure you back up the data file before editing, since funky things can and do happen.

                              Good luck!

                              Comment

                              • LhasaCM
                                Rookie
                                • Apr 2003
                                • 9

                                #30
                                Re: Using Excel as editor?

                                Whoops...

                                Actually...I was a bit simplistic in the post. The formula would have to be more complicated than =1.1*X2 because that would create decimal values and also values greater than 99.

                                Really, what I would do is:

                                =if(X2>90,99,round(1.1*x2))

                                This means that if the current value is greater than 90, make it 99...otherwise, add 10% and round to the nearest integer.

                                Comment

                                Working...