Individual Training Planner

[ibangali]

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

[Toxcatl]

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:


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?


Thanks again! Let me google this...

[Eneifos]

Hey toxicat how did u make the calculate button.

[Toxcatl]

Hey toxicat how did u make the calculate button.

You can find buttons, checkboxes and menus in "Developer" menu. If you don't see it, go File -> Options -> Customize Ribbon and check "Developer". But you need to write a macro and attach it to the button. I guess you should google "vba macro" or something.
By the way, there's no more "calculate" button ::)