Quote Originally Posted by ibangali View Post
Hi Toxcatl
I tried with your training planner, "drills lvl" & "drills xp" works fine but there are no "calculate" & "check key abilities" button on FieldPlayer 1, 2 & GK.

Also can you plz explain little more about 6 drills on those FieldPlayer; do we have to copy past those drills from "drills xp " or ....?
Thanks
Thank you for your reply.

It should be like this:
Click image for larger version.  Name: button.jpg  Views: 4044  Size: 76.6 KB  ID: 72962

On the screenshot you can see "Calculate!" button and checkboxes on the skills (there's no button to set key abilities, but checkboxes). I suspect you see none of them in the file...
Have you enabled editing and macros? What version of Excel do you use? I use Excel 2016 and have saved the file in Excel 97-2003 format, I don't understand why it doesn't work for you, guys v_v ¡Ay, caramba!

User have to copy-paste drills from "drills_xp" to player's sheet, check the checkboxes to highlight key attributes and then press "Calculate!". This will fill the table with numbers and apply penalties and bonuses depends on the amount of grey skills of the drill.

By the way, do you see combo-boxes in the "drills_lvls" sheet?
Click image for larger version.  Name: lvls.jpg  Views: 4022  Size: 45.3 KB  ID: 72963

Thanks again! Let me google this...