no content
AdBlocker active?
It seems you are using software to block advertisements. You could help us if you could switch it off when visiting redzoneaction.org.
The reason is very simple: Advertisements help us running the site, to offer you the game in a good quality for free. So if you like the game, please support us by purchasing a Supporter Account or disabling the AdBlocker on this site.
Thank you very much!
| Main / Rookie Area / Help with excel... Search Forum | |
| Navigation: |< 2 > >| | |
| Poster | Message |
|
sfniner08
|
posted: 2012-03-12 15:21:23 (ID: 32201) Report Abuse |
|
Can anyone point me to a dummy guide to setting up an excel sheet for my youth academy. I want to create a spreadsheet where I can enter the player information combined with my coaches information to map out expected ranges of skill improvement.
|
|
| Quote Reply Edit | |
|
Admin
Contact |
posted: 2012-03-12 15:25:22 (ID: 32202) |
|
Off-topic: within weeks/months this will be part of RZAMS...
|
|
| Quote Reply Edit | |
|
Ranagol
|
posted: 2012-03-12 17:33:45 (ID: 32209) Report Abuse |
|
I'm no excel wizard either, but here's my formula sheet that I use to see how my YA players will improve.
A little guide to how it works: Top right box is just a reminder of your own HC and AC values. Just type in your numbers so you don't have to alt+tab all the time between this sheet and your browser. If you don't have an AC on a particular position, his ac-cp formula is 1 for both max and min values (found in the middle). If you train a player withouth an AC you have to manually type in 1 for these formulas. Middle boxes are the formulas. The only time you need to a l t e r them is when you don't have an AC (setting ac-cp formula max and min to 1). Here you can see your fitness and skill training avarage as well, which gives you the ammount of points your player gets per training session. Top left box is your AC's EXP, CON and CP, so just type in the needed numbers to get the formulas working. Under that is the fitness and skill % you're doing your training in, plus the trained player's TW (very important!) The bottom big box is just something I put together looking at the draft board: - O means that skill is trained. - O/2 means that skill is lower than those that are deffinetly trained, so it is trained as well, but maybe with a lower rate? (don't know for sure). - X means that skill isn't tained by that AC, so you get the same points as you would, having no AC at all (ac-cp formula = 1). So what you see when you download the sheet: - You've got the perfect AC set with 50 EXP, 50 CON and 100 CP - The player you're training has the max 50 TW - He's training 90% in fitness and gets 0,66375 points per training session - He's training 10% in skill and gets 0,07375 points per training session Now if this player is 16 years old, then he has 17 training sessions left in thie season, plus 24 sessions for every season until he hits 21 years old. So 17 + 24 x 4 = 113 sessions. Just open your windows calculator and multiply the numbers and you get how many points you can spread among the skills of your player. For the player in example that would be 113 x 0,66375 + 113 x 0,07375 = 88,3375 points. I hope all this is understandable, and helps some of you YA maniacs  |
|
| Quote Reply Edit | |
|
slider6
|
posted: 2012-03-13 21:35:55 (ID: 32414) Report Abuse |
|
Ranagol wrote:
Now if this player is 16 years old, then he has 17 training sessions left in thie season, plus 24 sessions for every season until he hits 21 years old. So 17 + 24 x 4 = 113 sessions. Just open your windows calculator and multiply the numbers and you get how many points you can spread among the skills of your player. For the player in example that would be 113 x 0,66375 + 113 x 0,07375 = 88,3375 points. I count 19 sessions left this season. Am I missing something? Edit: Nevermind, I counted end of April and beginning of May twice. Last edited on 2012-03-13 21:37:28 by slider6 |
|
| Quote Reply Edit | |
|
Lee1950
|
posted: 2012-03-14 00:56:06 (ID: 32451) Report Abuse |
|
slider6 wrote:I count 19 sessions left this season. Am I missing something?
Edit: Nevermind, I counted end of April and beginning of May twice. LOL! I've done that a few times!! |
|
| Quote Reply Edit | |
|
looser
|
posted: 2012-03-27 10:35:10 (ID: 33779) Report Abuse |
|
any excel genius so can help my here
hope i can make my understandable when i do formula in row AG4 it look like =R4+AG2 and now i like to copy that from AG4 to AG99 but when i take the small box and poll down then is came out like this R4+AG2 R5+AG3 R6+AG4....... But i like it to be like this R4+AG2 R5+AG2 R6+AG2................ and so on until....... R97+AG2 R98+AG2 R99+AG2 any one know have to make AG2 permanent |
|
| Quote Reply Edit | |
|
Turtlemania
|
posted: 2012-03-27 10:36:40 (ID: 33780) Report Abuse |
|
looser wrote:
any one know have to make AG2 permanent In your case make it $AG$2 $AG -> fixes it to column AG $2 -> fixes it to row 2 You can also eg make it $AG2 or AG$2 in other cases eg when you want to "move fixed" within a row or column Last edited on 2012-03-27 10:38:06 by Turtlemania |
|
| Quote Reply Edit | |
| posted: 2012-03-27 10:49:09 (ID: 33784) Report Abuse | |
|
Turtlemania wrote:
looser wrote:
any one know have to make AG2 permanent In your case make it $AG$2 $AG -> fixes it to column AG $2 -> fixes it to row 2 You can also eg make it $AG2 or AG$2 in other cases eg when you want to "move fixed" within a row or column if want to create $AG$4, then you put your cursor in front of AG4 and then push the F4-Button. Then you get $AG$4. |
|
| Quote Reply Edit | |
|
looser
|
posted: 2012-03-27 11:03:38 (ID: 33786) Report Abuse |
|
thanks both of you Germany boy
|
|
| Quote Reply Edit | |
| posted: 2012-03-27 11:56:35 (ID: 33789) Report Abuse | |
|
Wow. Knowing that makes already an Excel Genius?
 |
|
| Quote Reply Edit | |
| reply Mark this thread unread | |
| Navigation: |< 2 > >| | |
| Main / Rookie Area / Help with excel... | |
