Using Excel as editor?

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RsNation6
    Rookie
    • Apr 2003
    • 32

    #46
    Re: Using Excel as editor?

    Do any you you people understand how to read the birthday in the atrib.dat file... all the numbers are like 9945 or 10239... If you can tell me how to read it it would be nice...

    i'm looking for someone to trade Jonny Damon for... an outfirlder or 1st basemen to DH mostly, but with a decent bat, i have 2 quality speed gys in Jackson and Raphial furcal. I want a young guy...

    Comment

    • RsNation6
      Rookie
      • Apr 2003
      • 32

      #47
      Re: Using Excel as editor?

      Do any you you people understand how to read the birthday in the atrib.dat file... all the numbers are like 9945 or 10239... If you can tell me how to read it it would be nice...

      i'm looking for someone to trade Jonny Damon for... an outfirlder or 1st basemen to DH mostly, but with a decent bat, i have 2 quality speed gys in Jackson and Raphial furcal. I want a young guy...

      Comment

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

        #48
        Re: Using Excel as editor?

        </font><blockquote><font class="small">Quote:</font><hr />
        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.

        <hr /></blockquote><font class="post">

        I've noticed the "MID" function works really well for columns that have an uneven amount of characters (names, audio id, etc).

        I can't remember the last time I had so much fun using Excel!

        (I'm such a dork...)

        Member of The OS Baseball Rocket Scientists Association

        Comment

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

          #49
          Re: Using Excel as editor?

          </font><blockquote><font class="small">Quote:</font><hr />
          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.

          <hr /></blockquote><font class="post">

          I've noticed the "MID" function works really well for columns that have an uneven amount of characters (names, audio id, etc).

          I can't remember the last time I had so much fun using Excel!

          (I'm such a dork...)

          Member of The OS Baseball Rocket Scientists Association

          Comment

          • Reddog2
            Rookie
            • Oct 2002
            • 346

            #50
            Re: Using Excel as editor?

            </font><blockquote><font class="small">Quote:</font><hr />
            </font><blockquote><font class="small">Quote:</font><hr />
            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.

            <hr /></blockquote><font class="post">

            I've noticed the "MID" function works really well for columns that have an uneven amount of characters (names, audio id, etc).

            I can't remember the last time I had so much fun using Excel!

            (I'm such a dork...)



            <hr /></blockquote><font class="post">

            Dumb question...how do I get it so the columns line up? So that when I open it the header does not say first name, but the first name does not appear in the next column?
            Thanks!

            Comment

            • Reddog2
              Rookie
              • Oct 2002
              • 346

              #51
              Re: Using Excel as editor?

              </font><blockquote><font class="small">Quote:</font><hr />
              </font><blockquote><font class="small">Quote:</font><hr />
              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.

              <hr /></blockquote><font class="post">

              I've noticed the "MID" function works really well for columns that have an uneven amount of characters (names, audio id, etc).

              I can't remember the last time I had so much fun using Excel!

              (I'm such a dork...)



              <hr /></blockquote><font class="post">

              Dumb question...how do I get it so the columns line up? So that when I open it the header does not say first name, but the first name does not appear in the next column?
              Thanks!

              Comment

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

                #52
                Re: Using Excel as editor?

                </font><blockquote><font class="small">Quote:</font><hr />
                Dumb question...how do I get it so the columns line up? So that when I open it the header does not say first name, but the first name does not appear in the next column?
                Thanks!

                <hr /></blockquote><font class="post">

                Well, you want to leave the headers as "A, B, C, etc". Here's what you can do to make it appear like you have named headers....

                1. Right-click in cell "A1"
                2. Choose "Insert"
                3. Select "Shift cells right" and click "OK"

                4. Highlight row "2"
                5. Click "Window" in the top menu
                6. Select "Freeze Panes" (this will lock the first row in place)

                When you are done repeat steps 1-3 except select "Delete" rather than insert and tell them to "Shift Left".

                Good luck

                sn
                Member of The OS Baseball Rocket Scientists Association

                Comment

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

                  #53
                  Re: Using Excel as editor?

                  </font><blockquote><font class="small">Quote:</font><hr />
                  Dumb question...how do I get it so the columns line up? So that when I open it the header does not say first name, but the first name does not appear in the next column?
                  Thanks!

                  <hr /></blockquote><font class="post">

                  Well, you want to leave the headers as "A, B, C, etc". Here's what you can do to make it appear like you have named headers....

                  1. Right-click in cell "A1"
                  2. Choose "Insert"
                  3. Select "Shift cells right" and click "OK"

                  4. Highlight row "2"
                  5. Click "Window" in the top menu
                  6. Select "Freeze Panes" (this will lock the first row in place)

                  When you are done repeat steps 1-3 except select "Delete" rather than insert and tell them to "Shift Left".

                  Good luck

                  sn
                  Member of The OS Baseball Rocket Scientists Association

                  Comment

                  • Reddog2
                    Rookie
                    • Oct 2002
                    • 346

                    #54
                    Re: Using Excel as editor?

                    Thanks Snepp.

                    Comment

                    • Reddog2
                      Rookie
                      • Oct 2002
                      • 346

                      #55
                      Re: Using Excel as editor?

                      Thanks Snepp.

                      Comment

                      • Reddog2
                        Rookie
                        • Oct 2002
                        • 346

                        #56
                        Re: Using Excel as editor?

                        Wow that was sooo easy. I just edited the attrib file in like 20 minutes (I spent several hours a day for a few days doing it mannually before).

                        Thanks again guys.

                        Comment

                        • Reddog2
                          Rookie
                          • Oct 2002
                          • 346

                          #57
                          Re: Using Excel as editor?

                          Wow that was sooo easy. I just edited the attrib file in like 20 minutes (I spent several hours a day for a few days doing it mannually before).

                          Thanks again guys.

                          Comment

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

                            #58
                            Re: Using Excel as editor?

                            </font><blockquote><font class="small">Quote:</font><hr />
                            Wow that was sooo easy. I just edited the attrib file in like 20 minutes (I spent several hours a day for a few days doing it mannually before).

                            Thanks again guys.

                            <hr /></blockquote><font class="post">

                            It does work alright, but I would still prefer to have a killer editor
                            Member of The OS Baseball Rocket Scientists Association

                            Comment

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

                              #59
                              Re: Using Excel as editor?

                              </font><blockquote><font class="small">Quote:</font><hr />
                              Wow that was sooo easy. I just edited the attrib file in like 20 minutes (I spent several hours a day for a few days doing it mannually before).

                              Thanks again guys.

                              <hr /></blockquote><font class="post">

                              It does work alright, but I would still prefer to have a killer editor
                              Member of The OS Baseball Rocket Scientists Association

                              Comment

                              • Reddog2
                                Rookie
                                • Oct 2002
                                • 346

                                #60
                                Re: Using Excel as editor?

                                I figured out why the pitcher.dat was giving me trouble. Excel was converting any of the fields that had a number and then a - to a negative number (e.g. when a pitcher does not have a 4th pitch, that space is indicated as 17 -). In the advance tab of the import fuction is an option that say trailing - equals a negative number. Once I unchecked that the numbers came up right.

                                Only took me 4 hours to figure that out.

                                Comment

                                Working...