|
Post by winzor @ Porto on Jul 30, 2013 9:26:55 GMT
was bored this morning................... so thought i would have a little go at doing a spreadsheet for the youth players in my team. im no excel wizard, but not sure if any of you guys could improve it? would be handy for Malky maybe if there was an easy way to copy paste the roster in some how as its not really time saving as is lol. I will probably use mine to keep up to date as the season goes on in future. feel free to use it too guys and welcome to improve it for us. cheers C:\Users\Shaun\Desktop\footy\Elite\Season ....xlsx (13.38 KB)
|
|
|
Post by Stu on Jul 30, 2013 10:54:06 GMT
This is the spreadsheet i've used for the past few seasons, it works out release fee value, rough idea of wages and eos bonus's. Celtic.xlsx (24.58 KB) Winzor it's easy to up date the spreadsheet by using the get external data tab, select "from text" and point it to your team sheet.
|
|
|
Post by winzor @ Porto on Jul 30, 2013 11:12:22 GMT
cool. will have a try with the updating part. cheers for the sheet....... defo an ideal thing to have may change the eos abs to have full stats then can ditch mine hehe
|
|
|
Post by winzor @ Porto on Jul 30, 2013 14:16:55 GMT
cant seem to find this 'get external data tab' to get my squad into the spreadsheet bud
|
|
|
Post by Stu on Jul 30, 2013 14:18:38 GMT
|
|
|
Post by winzor @ Porto on Jul 30, 2013 14:22:33 GMT
excel starter 2010
will have a look through, cheers.
if not i will try find my older microsoft office disc to install lol
|
|
|
Post by Stu on Jul 30, 2013 14:24:25 GMT
No worries, once you have it set up to import the data you then just right click and select refresh and it will load the new data from the current squad file for you.
|
|
|
Post by gazza on Jul 30, 2013 18:38:50 GMT
Saved your file Stu and tried to get data, but I am just not doing this right, idiots guide please, lmao !
|
|
|
Post by Lee (Marseille) on Jul 30, 2013 19:19:25 GMT
Bit interested in why this is being done myself
|
|
|
Post by garfy on Jul 30, 2013 20:57:46 GMT
I have something similar but in works really need to write it in excel
Mine also predicts abs for this season based on current performance and can calculate it for next three seasons
Excellent at planning where the youngsters will be when old guys retire
|
|