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
Half started 2015-2016 mod. Roster kinda complete.
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: 836723" data-attributes="member: 29495"><p>Yes, columns BS & BT in the Player editor workbook relate to the players special abilities. The value is 2 bytes, therefore takes up two cells (BS & BT).</p><p></p><p>To do this, you will need to convert the decimal values for the cells to binary.</p><p></p><p>Go to a blank cell at the end of the row (i.e; the CK column) and put this formula into the formula bar of cell CK2</p><p>=DEC2BIN(BS2,8)</p><p>This will convert cell BS2 of the player editor workbook into 8 digit binary values.</p><p></p><p>Repeat or drag the formula across for cell CL2. </p><p>=DEC2BIN(BT2,8)</p><p></p><p>Now that both cells are converted to binary, refer to the 'guidelines' workbook under the section (Special Abilities)</p><p>You will see that the data consists of 0's and 1's.</p><p>Since the cells consist of 16 digits (2 x cells with 8 digits);</p><p></p><p>You place a '1' (or several) in amongst the 0's to activate or deactivate the special ability.</p><p></p><p>For example;</p><p> [TABLE]</p><p><tbody>[TR]</p><p>[TD="class: xl64"]1000 0000 0000 0000 – Tackle breaker[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0100 0000 0000 0000 – Crash ball[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0010 0000 0000 0000 – Tactical kicker[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0001 0000 0000 0000 – Goal Kicker[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"][/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 1000 0000 0000 – Scoring[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0100 0000 0000 – Playmaker[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0010 0000 0000 – Passing[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0001 0000 0000 – Command[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl65"]0000 0000 1000 0000 – Checkbox 9[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl65"]0000 0000 0100 0000 – Checkbox 10[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl65"]0000 0000 0010 0000 – Chckbox 11[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0000 0001 0000 – Jumper[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"][/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0000 0000 1000 – Scrummager[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0000 0000 0100 – Defensive organiser[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0000 0000 0010 – Ball winner[/TD]</p><p>[/TR]</p><p>[TR]</p><p>[TD="class: xl64"]0000 0000 0000 0001 – Tackler[/TD]</p><p>[/TR]</p><p></tbody>[/TABLE]</p><p>To answer your question, the first digit in column CL (the 9th digit over both cells) will need to have a value of '0' to show that it is unticked.</p><p>i.e; </p><p>0000 0000 0000 0001 - a player with the tackler special ability and checkbox 9 deactivated.</p><p></p><p>0000 0000 1000 0001 - a player with the tackler special ability and checkbox 9 activated (ticked).</p><p></p><p>Once you have made changes in binary, convert back to decimal (or hex) using the formula</p><p></p><p>=bin2dec(CK2) to convert the changes to decimal and paste in the decimal workbook.</p><p></p><p>or </p><p></p><p>=bin2hex(CK2,2) to convert the changes to hex and paste in the new hex workbook</p></blockquote><p></p>
[QUOTE="ama1, post: 836723, member: 29495"] Yes, columns BS & BT in the Player editor workbook relate to the players special abilities. The value is 2 bytes, therefore takes up two cells (BS & BT). To do this, you will need to convert the decimal values for the cells to binary. Go to a blank cell at the end of the row (i.e; the CK column) and put this formula into the formula bar of cell CK2 =DEC2BIN(BS2,8) This will convert cell BS2 of the player editor workbook into 8 digit binary values. Repeat or drag the formula across for cell CL2. =DEC2BIN(BT2,8) Now that both cells are converted to binary, refer to the 'guidelines' workbook under the section (Special Abilities) You will see that the data consists of 0's and 1's. Since the cells consist of 16 digits (2 x cells with 8 digits); You place a '1' (or several) in amongst the 0's to activate or deactivate the special ability. For example; [TABLE] <tbody>[TR] [TD="class: xl64"]1000 0000 0000 0000 – Tackle breaker[/TD] [/TR] [TR] [TD="class: xl64"]0100 0000 0000 0000 – Crash ball[/TD] [/TR] [TR] [TD="class: xl64"]0010 0000 0000 0000 – Tactical kicker[/TD] [/TR] [TR] [TD="class: xl64"]0001 0000 0000 0000 – Goal Kicker[/TD] [/TR] [TR] [TD="class: xl64"][/TD] [/TR] [TR] [TD="class: xl64"]0000 1000 0000 0000 – Scoring[/TD] [/TR] [TR] [TD="class: xl64"]0000 0100 0000 0000 – Playmaker[/TD] [/TR] [TR] [TD="class: xl64"]0000 0010 0000 0000 – Passing[/TD] [/TR] [TR] [TD="class: xl64"]0000 0001 0000 0000 – Command[/TD] [/TR] [TR] [/TR] [TR] [TD="class: xl65"]0000 0000 1000 0000 – Checkbox 9[/TD] [/TR] [TR] [TD="class: xl65"]0000 0000 0100 0000 – Checkbox 10[/TD] [/TR] [TR] [TD="class: xl65"]0000 0000 0010 0000 – Chckbox 11[/TD] [/TR] [TR] [TD="class: xl64"]0000 0000 0001 0000 – Jumper[/TD] [/TR] [TR] [TD="class: xl64"][/TD] [/TR] [TR] [TD="class: xl64"]0000 0000 0000 1000 – Scrummager[/TD] [/TR] [TR] [TD="class: xl64"]0000 0000 0000 0100 – Defensive organiser[/TD] [/TR] [TR] [TD="class: xl64"]0000 0000 0000 0010 – Ball winner[/TD] [/TR] [TR] [TD="class: xl64"]0000 0000 0000 0001 – Tackler[/TD] [/TR] </tbody>[/TABLE] To answer your question, the first digit in column CL (the 9th digit over both cells) will need to have a value of '0' to show that it is unticked. i.e; 0000 0000 0000 0001 - a player with the tackler special ability and checkbox 9 deactivated. 0000 0000 1000 0001 - a player with the tackler special ability and checkbox 9 activated (ticked). Once you have made changes in binary, convert back to decimal (or hex) using the formula =bin2dec(CK2) to convert the changes to decimal and paste in the decimal workbook. or =bin2hex(CK2,2) to convert the changes to hex and paste in the new hex workbook [/QUOTE]
Verification
Post reply
Forums
Other Stuff
Rugby Video Games & Apps
EA Rugby 08
Half started 2015-2016 mod. Roster kinda complete.
Top