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: 836711" data-attributes="member: 29495"><p>Forgot to mention how I auto calculate the stats for each position.</p><p></p><p>Say, for example you want to edit an attribute across all players of the same position (i.e; the speed of all the second rowers / locks)</p><p></p><p>Select all, then go to the sort icon. Select my data has headers, then sort by Pos1, then by Speed.</p><p>Sort from largest to smallest.</p><p></p><p>This will change the order, so that the player in that position with the highest speed rating is at the top (i.e; Second Rowers / E.Etzebeth - speed=75)</p><p>Now make sure that the player with the lowest rating is at the bottom (i.e; Second Rowers / W.Skelton - speed = 40)</p><p>Keep the highest and lowest rating, while blanking out everything in the middle. Highlight everything from the highest to the lowest (with blanks in between).</p><p></p><p>On the home tab, find the 'fill' icon.</p><p>Then click on 'series'.</p><p><img src="http://www.therugbyforum.com/attachment.php?attachmentid=4811&stc=1" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p>Now make sure the following is enabled. </p><p>Series in 'columns'</p><p>Type 'linear' </p><p>'Trend' checkbox is checked.</p><p></p><p><img src="http://www.therugbyforum.com/attachment.php?attachmentid=4812&stc=1" alt="" class="fr-fic fr-dii fr-draggable " style="" />Click OK and voila! the stats are distributed automatically between highest and lowest.</p><p><img src="http://www.therugbyforum.com/attachment.php?attachmentid=4813&stc=1" alt="" class="fr-fic fr-dii fr-draggable " style="" />You can repeat this procedure for any of the other attributes.</p><p></p><p>I tend to rank players based on their position and skill (i.e; for Number 8's, Reid and Parisse would have the highest handling ratings IMO) and repeat until I am happy with how they sit in comparison to others </p><p>in the same position.</p><p></p><p>Pics are probably hard to see clearly, but were just to provide a basic visual idea of what is going on.</p></blockquote><p></p>
[QUOTE="ama1, post: 836711, member: 29495"] Forgot to mention how I auto calculate the stats for each position. Say, for example you want to edit an attribute across all players of the same position (i.e; the speed of all the second rowers / locks) Select all, then go to the sort icon. Select my data has headers, then sort by Pos1, then by Speed. Sort from largest to smallest. This will change the order, so that the player in that position with the highest speed rating is at the top (i.e; Second Rowers / E.Etzebeth - speed=75) Now make sure that the player with the lowest rating is at the bottom (i.e; Second Rowers / W.Skelton - speed = 40) Keep the highest and lowest rating, while blanking out everything in the middle. Highlight everything from the highest to the lowest (with blanks in between). On the home tab, find the 'fill' icon. Then click on 'series'. [IMG]http://www.therugbyforum.com/attachment.php?attachmentid=4811&stc=1[/IMG] Now make sure the following is enabled. Series in 'columns' Type 'linear' 'Trend' checkbox is checked. [IMG]http://www.therugbyforum.com/attachment.php?attachmentid=4812&stc=1[/IMG]Click OK and voila! the stats are distributed automatically between highest and lowest. [IMG]http://www.therugbyforum.com/attachment.php?attachmentid=4813&stc=1[/IMG]You can repeat this procedure for any of the other attributes. I tend to rank players based on their position and skill (i.e; for Number 8's, Reid and Parisse would have the highest handling ratings IMO) and repeat until I am happy with how they sit in comparison to others in the same position. Pics are probably hard to see clearly, but were just to provide a basic visual idea of what is going on. [/QUOTE]
Verification
Post reply
Forums
Other Stuff
Rugby Video Games & Apps
EA Rugby 08
Half started 2015-2016 mod. Roster kinda complete.
Top