Menu
Forums
New posts
Search forums
What's new
New posts
Latest activity
Log in
Register
What's new
Search
Search
Search titles and first posts only
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Help Support The Rugby Forum :
Forums
Other Stuff
Rugby Video Games & Apps
EA Rugby 08
Rugby 08 - Roster Editor Spreadsheet **Updated
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="ama1" data-source="post: 1169961" data-attributes="member: 29495"><p>Sorry I have just edited the download and added a team lineup editor.</p><p>The easy part...</p><p></p><p>To swap players, go to the Lineups DEC workbook and add the 2 byte Player ID's into the relevant position on the worksheet.</p><p>The Lineups HEX workbook will convert the data to hex.</p><p>Copy and paste to overwrite rows 1 - 149 of the 'hex' or 'New Ros' workbook</p><p></p><p></p><p>To explain how the team lineups are structured in the roster....</p><p></p><p>Open the 'Edit' workbook</p><p></p><p>I am going to edit the team lineup for <strong>Argentina</strong> as an example.</p><p></p><p>The team lineups are the top part of the roster (Rows 1 - 149)</p><p>The player data is the bottom part (Rows 150 downward)</p><p></p><p>Referring to the team lineups;</p><p>*There are 104 bytes allocated to each team.</p><p>*Each player ID (Cells A & B in the Name Conversion workbook) consists of 2 bytes.</p><p>*There are 30 players in each team, so all up 60 bytes for the team lineup. <strong>BYTES 1 - 60 AG2 - CN2</strong></p><p></p><p>The first player in the team (Jersey 1 - Loosehead Prop) F.Gigena who's id in the Name Conversion spreadsheet is 159 093</p><p>If we start from cell AG2 (which displays 159) then cell AH2 (which displays 093)</p><p></p><p>Next is the hooker - which is 131 073 J.Montoya</p><p>and so on....</p><p></p><p>After the 30th player in the team is the team id (in this case 001 for Argentina - which is Team id 1) <strong>BYTE 61 CO2</strong></p><p>* I have highlighted this in gold with white text to make it easy to find</p><p></p><p>3 bytes NULL (000) <strong>BYTES 62-64 CP2 - CR2</strong></p><p> </p><p>Next is Team Captain (2 bytes) <strong>BYTES 65-66 CS2 - CT2</strong></p><p>In Argentina's case it is 131 073 which is the player ID for J.Montoya</p><p> </p><p>Vice Captain player ID (2 Bytes) <strong>BYTES 67-68 CU2 - CV2</strong></p><p>Long GK player ID (2 Bytes) <strong>BYTES 69-70 A3 - B3</strong></p><p>Short GK player ID (2 Bytes) <strong>BYTES 71-72 C3 - D3</strong></p><p>Long P player ID (2 Bytes) <strong>BYTES 73-74 E3 - F3</strong></p><p>Short P player ID (2 Bytes) <strong>BYTES 75-76 G3 - H3</strong></p><p>Kick Off T player ID (2 bytes) <strong>BYTES 77-78 I3 - J3</strong></p><p></p><p>Attacking (1 Byte) <strong> BYTE 79 K3</strong></p><p>Defending (1 Byte) <strong>BYTE 80 L3</strong></p><p>Scrums (1 Byte) <strong>BYTE 81 M3</strong></p><p>Lineouts (1 Byte) <strong>BYTE 82 N3</strong></p><p>Rucks (1 Byte) <strong>BYTE 83 O3</strong></p><p>Kicking (1 Byte) <strong>BYTE 84 P3</strong></p><p>Technique (1 Byte) <strong>BYTE 85 Q3</strong></p><p>Stamina (1 Byte) <strong>BYTE 86 R3</strong></p><p>Flair (1 Byte) <strong>BYTE 87 S3</strong></p><p>Overall (1 Byte)<strong> BYTE 88 T3</strong></p><p></p><p>Next 3 Bytes (I can't remember)</p><p><strong>BYTES 89 - 91 U3 - W3</strong></p><p></p><p>Team Performance Rating (1 Byte) <strong>BYTE 92 X3</strong></p><p></p><p>Set Plays (4 Bytes) <strong>BYTES 93 - 96 Y3 - AB3</strong></p><p></p><p>Stadium (1 Byte) <strong>BYTE 97 AC3</strong></p><p></p><p>Next 7 Bytes (Null 000) <strong>BYTES 98 - 104 AD3 - AJ3</strong></p></blockquote><p></p>
[QUOTE="ama1, post: 1169961, member: 29495"] Sorry I have just edited the download and added a team lineup editor. The easy part... To swap players, go to the Lineups DEC workbook and add the 2 byte Player ID's into the relevant position on the worksheet. The Lineups HEX workbook will convert the data to hex. Copy and paste to overwrite rows 1 - 149 of the 'hex' or 'New Ros' workbook To explain how the team lineups are structured in the roster.... Open the 'Edit' workbook I am going to edit the team lineup for [B]Argentina[/B] as an example. The team lineups are the top part of the roster (Rows 1 - 149) The player data is the bottom part (Rows 150 downward) Referring to the team lineups; *There are 104 bytes allocated to each team. *Each player ID (Cells A & B in the Name Conversion workbook) consists of 2 bytes. *There are 30 players in each team, so all up 60 bytes for the team lineup. [B]BYTES 1 - 60 AG2 - CN2[/B] The first player in the team (Jersey 1 - Loosehead Prop) F.Gigena who's id in the Name Conversion spreadsheet is 159 093 If we start from cell AG2 (which displays 159) then cell AH2 (which displays 093) Next is the hooker - which is 131 073 J.Montoya and so on.... After the 30th player in the team is the team id (in this case 001 for Argentina - which is Team id 1) [B]BYTE 61 CO2[/B] * I have highlighted this in gold with white text to make it easy to find 3 bytes NULL (000) [B]BYTES 62-64 CP2 - CR2[/B] Next is Team Captain (2 bytes) [B]BYTES 65-66 CS2 - CT2[/B] In Argentina's case it is 131 073 which is the player ID for J.Montoya Vice Captain player ID (2 Bytes) [B]BYTES 67-68 CU2 - CV2[/B] Long GK player ID (2 Bytes) [B]BYTES 69-70 A3 - B3[/B] Short GK player ID (2 Bytes) [B]BYTES 71-72 C3 - D3[/B] Long P player ID (2 Bytes) [B]BYTES 73-74 E3 - F3[/B] Short P player ID (2 Bytes) [B]BYTES 75-76 G3 - H3[/B] Kick Off T player ID (2 bytes) [B]BYTES 77-78 I3 - J3[/B] Attacking (1 Byte) [B] BYTE 79 K3[/B] Defending (1 Byte) [B]BYTE 80 L3[/B] Scrums (1 Byte) [B]BYTE 81 M3[/B] Lineouts (1 Byte) [B]BYTE 82 N3[/B] Rucks (1 Byte) [B]BYTE 83 O3[/B] Kicking (1 Byte) [B]BYTE 84 P3[/B] Technique (1 Byte) [B]BYTE 85 Q3[/B] Stamina (1 Byte) [B]BYTE 86 R3[/B] Flair (1 Byte) [B]BYTE 87 S3[/B] Overall (1 Byte)[B] BYTE 88 T3[/B] Next 3 Bytes (I can't remember) [B]BYTES 89 - 91 U3 - W3[/B] Team Performance Rating (1 Byte) [B]BYTE 92 X3[/B] Set Plays (4 Bytes) [B]BYTES 93 - 96 Y3 - AB3[/B] Stadium (1 Byte) [B]BYTE 97 AC3[/B] Next 7 Bytes (Null 000) [B]BYTES 98 - 104 AD3 - AJ3[/B] [/QUOTE]
Verification
Post reply
Forums
Other Stuff
Rugby Video Games & Apps
EA Rugby 08
Rugby 08 - Roster Editor Spreadsheet **Updated
Top