Teams Team Development (SC GOLD Picker)

[Here2tellyouwhy]

How do you function with so many useful facts and so much Beer?lol

Sober tonight Big big one tomorrow.

 

[Here2tellyouwhy]

View attachment 317667View attachment 317669

Version 2

Nice. Me likey.

 

[gutsroy]

Does anyone know how to get a straight list of SuperCoach players and prices - just want a straight spreadsheet without fancy pickers.

Is it possible to break Paige's to get them out of the drop downs or from somewhere else?

Cheers

G'day, yep, just right click on the strategiser tab at the bottom of the window, then select 'unhide' in the list of options that appear, then select the 'Data' tab. Column A has the names, Column B has the salary data etc.
It's password protected, but you can crack that (vba code), can send the data extract to you (or the method ti crack it in Excel 2010 or earlier) if you like.

 

[Here2tellyouwhy]

G'day, yep, just right click on the strategiser tab at the bottom of the window, then select 'unhide' in the list of options that appear, then select the 'Data' tab. Column A has the names, Column B has the salary data etc.
It's password protected, but you can crack that (vba code), can send the data extract to you (or the method ti crack it in Excel 2010 or earlier) if you like.

 

[gutsroy]

View attachment 317681

Guilty as charged lol

 

[Keg on legs]

Published version 3

Doc, Laird, jj, hibberd, Scharenberg, Hampton, Witherden, long

Danger, Neale, Treloar, bont, Fyfe, SPS, SPP, Myers, Venables, Pickett, greenwood

Maxxxy, sandi, strnadica

Dollhouse, heeney, touk touk, Ryder, Simpkin, Bolton, Kirby, eddy

$99,300 leftover



What can I say, it's a gift.

 

[majortinkle]

OK first off I had to go onto Paige's website and Facebook to find the spreadsheet so you owe me

Open the spreadsheet.
Enable editing. (yellow button up the top below the toolbar)
Go down to the tab bottom left named Stategiser and right mouse click on it.
Select Un-hide.
NOW next to the Stategiser tab their should be a tab named 'Data'
Click on that tab. That's the one with all the players in it

You sir, are a gent and a scholar - no matter what other people say, I thank you!

 

[majortinkle]

G'day, yep, just right click on the strategiser tab at the bottom of the window, then select 'unhide' in the list of options that appear, then select the 'Data' tab. Column A has the names, Column B has the salary data etc.
It's password protected, but you can crack that (vba code), can send the data extract to you (or the method ti crack it in Excel 2010 or earlier) if you like.

Thanks, I ended up unprotecting by getting it opened in word pad and then recreating in excel.

No idea whether that's what you suggested as you were speaking above my pay grade there.......

Cheers though

 

[majortinkle]

Never seen anything like you are looking for sorry mate can't help you, anyone else?

Would be handy, would stop a lot of shuffling in the preseason.

I've done the spreadsheet, but Bigfooty won't let me upload it - extension not allowed.

I might try and get it up somewhere else and link to it.

 

[pincrusher]

Version 2. Rookies under $150k are just place holders for the time being.

 

[Me Myself and I]

Re: the SCPaige spreadsheet.

I added my team as a tryout and it kindly gives me Strnadica as a freebie.
He's the only ruck but the last six forwards in the dropbox are also free.
They also don't add to the bye round totals.

I did look at the other teams that used the spreadsheet on here but none had Strnadica.
Don't know whether this is just me or not. If not, do we have an Excel guru to find where the error is.

 

[Bearded Dragons]

What can I say, it's a gift. [/QUOTE]

Is that what you used to say to all the girls

 

[Keg on legs]

Version 2. Rookies under $150k are just place holders for the time being.

View attachment 317753

Crouch is a nice pod

Not a bad looking list

 

[Keg on legs]

What can I say, it's a gift.

Is that what you used to say to all the girls[/QUOTE]

Sadly, not the gift that kept on giving!

 

[pincrusher]

Crouch is a nice pod

Not a bad looking list

Yeah he averaged 104 in his last 12 this year (something like that) and statistically next season is the one where he should reach his scoring potential. Not sure if he'll make the final cut but he's there at the moment. It's the POD's that make or break a good season. No point being the same as everyone else.

 

[toxic]

Public Version 5



90K left over as well

 

[Flandersss]

First version 1.0

Thoughts?

 

[Here2tellyouwhy]

First version 1.0
Thoughts?

Delete Supercoach

 

[Here2tellyouwhy]

Public Version 5

View attachment 317804

90K left over as well

Too risky.
Rocky, Swallow, Sandi and Motlop.

 

[Sir Skid]

Come on SincMagic wheretf is Freeman?

 

[Flandersss]

Come on SincMagic wheretf is Freeman?

Yeahhh

I'll chuck him in

 

[Flandersss]

Delete Supercoach

 

[gutsroy]

Thanks, I ended up unprotecting by getting it opened in word pad and then recreating in excel.

No idea whether that's what you suggested as you were speaking above my pay grade there.......

Cheers though

Good stuff, hadn't even thought of that option, much simpler by the sounds

 

[Keg on legs]

First version 1.0

Thoughts?

View attachment 317811
View attachment 317812
View attachment 317813

Boyd, beams and McCarthy. Boy oh boy wowee. Risky.

Gonna be interesting to see how lids goes at GWS.

I like the no freezer. None of us should.picm him- we will only mozz him if we do!

 

[gutsroy]

Re: the SCPaige spreadsheet.

I added my team as a tryout and it kindly gives me Strnadica as a freebie.
He's the only ruck but the last six forwards in the dropbox are also free.
They also don't add to the bye round totals.

I did look at the other teams that used the spreadsheet on here but none had Strnadica.
Don't know whether this is just me or not. If not, do we have an Excel guru to find where the error is.

Yeah, true, what has happened is that they have defined some named ranges incompletely. Al except two defined ranges are affected and finish in row 802, but should finish in row 815.

You can fix yourself by going to the formula tab and clicking on 'named ranges and then editing them to extend the end of the all of the named ranges except AllPlayers and OnfField (by the looks, they are unaffected)from row 802 to row 815:


After fixing them all up, Strnadica showed like this for me, so it looks like that is all that is needed;

I'll drop them a line,I guess they'd like to know so they can fix