Position General Discussion

[freowho]

Calling all computer experts.
I have a NAB cup spreadsheet I'm compiling and would like to sort data from various columns without having to change the look of the spreadsheet. For example. It would like this to start with.
SC1 SC2 SC3
Player A 55 77 66
Player B 66 55 44
Player C 88 33 44

I would then like it to sort each player in order of their best score. So it would look like:

Player C 88 33 44
Player A 55 77 66
Player B 66 55 44

If it's a big programming job then I'll give it a miss but if there's a little trick it would make things easier.

Rep points if anyone can help.

 

[aps1]

Calling all computer experts.
I have a NAB cup spreadsheet I'm compiling and would like to sort data from various columns without having to change the look of the spreadsheet. For example. It would like this to start with.
SC1 SC2 SC3
Player A 55 77 66
Player B 66 55 44
Player C 88 33 44

I would then like it to sort each player in order of their best score. So it would look like:

Player C 88 33 44
Player A 55 77 66
Player B 66 55 44

If it's a big programming job then I'll give it a miss but if there's a little trick it would make things easier.

Rep points if anyone can help.

A bit clunky, but you can add another column and then use the MAX function on each set of player values, so that it returns the maximum value for each player. Then just sort on that column.

 

[freowho]

A bit clunky, but you can add another column and then use the MAX function on each set of player values, so that it returns the maximum value for each player. Then just sort on that column.

Thanks aps1. I think that will do the job.

 

[freowho]

I just did a dollars per supercoach point from the NAB cup to see who jumps out as an option and if I pick the 4 players who had a negative score supercoach will pay me!!!
I'm going to get an extra $250,000 for every point Joe Daniher loses.

 

[Philzsay]

I just did a dollars per supercoach point from the NAB cup to see who jumps out as an option and if I pick the 4 players who had a negative score supercoach will pay me!!!
I'm going to get an extra $250,000 for every point Joe Daniher loses.

Yep he had a shocker. Mind you he basically had practically no pre season. Training the house up I suppose you could say!

 

[bwright]

General type question - Given things go according to plan, what round do coaches plan to start their upgrades?

 

[stephen]

General type question - Given things go according to plan, what round do coaches plan to start their upgrades?

I think most aggressive coaches start properly up/downing at RD6. If you've started midpricers and/or have injuries and/or there's an obvious breakout, you can sometimes fiddle things around and do a quasi-upgrade before then.

 

[bwright]

I think most aggressive coaches start properly up/downing at RD6. If you've started midpricers and/or have injuries and/or there's an obvious breakout, you can sometimes fiddle things around and do a quasi-upgrade before then.

Cheers for the reply stephen. That's what I had pinned, was wondering if I was going too early but looks around the mark.

 

[Darkie]

Cheers for the reply stephen. That's what I had pinned, was wondering if I was going too early but looks around the mark.

I looked at this recently and I started in round six, as did last year's winner, I believe.

I think it's determined by how quickly the rookies reach optimal (not max) value, so it could vary from one year to another, but I think it's fair to say you want to be upgrading as quickly as you reasonably can.

Deciding not to wait for every last dollar is one of the key areas I think I've improved in over the last year or two.

 

[bwright]

I looked at this recently and I started in round six, as did last year's winner, I believe.

I think it's determined by how quickly the rookies reach optimal (not max) value, so it could vary from one year to another, but I think it's fair to say you want to be upgrading as quickly as you reasonably can.

Deciding not to wait for every last dollar is one of the key areas I think I've improved in over the last year or two.

Yep, absolutely this.

Working out what is enough instead of waiting till every last dollar is squeezed out of a rookie is a big one I think and one I am only just really coming to terms with. That is the kind of question that was behind this one, when do you start to cull rookies even if they haven't reached absolute optimum and I think r6 looks reasonable

 

[Ricky Bobby]

I looked at this recently and I started in round six, as did last year's winner, I believe.

I think it's determined by how quickly the rookies reach optimal (not max) value, so it could vary from one year to another, but I think it's fair to say you want to be upgrading as quickly as you reasonably can.

Deciding not to wait for every last dollar is one of the key areas I think I've improved in over the last year or two.

Yep, absolutely this.

Working out what is enough instead of waiting till every last dollar is squeezed out of a rookie is a big one I think and one I am only just really coming to terms with. That is the kind of question that was behind this one, when do you start to cull rookies even if they haven't reached absolute optimum and I think r6 looks reasonable

So, is the trick to get rid of the most or least successful rookies at this time?

 

[Darkie]

Yep, absolutely this.

Working out what is enough instead of waiting till every last dollar is squeezed out of a rookie is a big one I think and one I am only just really coming to terms with. That is the kind of question that was behind this one, when do you start to cull rookies even if they haven't reached absolute optimum and I think r6 looks reasonable

Yes, I think this is key. For me, the benchmark I used was that I was essentially happy enough to leave the last $20k on the table, because extracting it simply takes too long in most cases. It's better to have $140k invested for 12 weeks than $160k invested for 8 weeks, eg - and often that's the trade-off.

I would usually take the average I thought a player was heading towards achieving, multiply by $5,000, deduct $20,000, and treat that as a rough sell price. I'd then look at current and likely future breakevens, as well as any games I ought could be particularly high/low scoring depending on opposition etc.

The other thing, in my view, is to try hard to get on every good downgrade target. There aren't many good rookies after those that play round one, so sometimes you need to sacrifice a cash cow a bit early to get on the next one! Thinking about the production line of future cash cows is helpful as well - sometimes you need to take the best of a middling bunch

 

[Bomber18]

Yes, I think this is key. For me, the benchmark I used was that I was essentially happy enough to leave the last $20k on the table, because extracting it simply takes too long in most cases. It's better to have $140k invested for 12 weeks than $160k invested for 8 weeks, eg - and often that's the trade-off.

I would usually take the average I thought a player was heading towards achieving, multiply by $5,000, deduct $20,000, and treat that as a rough sell price. I'd then look at current and likely future breakevens, as well as any games I ought could be particularly high/low scoring depending on opposition etc.

The other thing, in my view, is to try hard to get on every good downgrade target. There aren't many good rookies after those that play round one, so sometimes you need to sacrifice a cash cow a bit early to get on the next one! Thinking about the production line of future cash cows is helpful as well - sometimes you need to take the best of a middling bunch

Interesting rule of thumb! I need a lot more help nailing who to cash out and who to keep, I was terrible at it last year! Traded the likes of Ruggles, Tippa, Menadue out too early and they went on to make another $100k. Also got DBJ after his first price rise. Definitely agree with that last point, definitely worth delaying an upgrade if there's a good rookie on the bubble.

 

[bomberboy]

Hey guys,
Is there an easy way to post a table on the forum from excel? Just curious, because I see some big tables posted, and surely you're not typing everything out!

 

[Darkie]

Interesting rule of thumb! I need a lot more help nailing who to cash out and who to keep, I was terrible at it last year! Traded the likes of Ruggles, Tippa, Menadue out too early and they went on to make another $100k. Also got DBJ after his first price rise. Definitely agree with that last point, definitely worth delaying an upgrade if there's a good rookie on the bubble.

Haha - unfortunately the rule of thumb doesn't preclude making the wrong judgments on the inputs, which I did in a couple of cases last year

Others potentially have a better approach, but this one served me well, especially when trying to make fairly quick decisions.

I think the way to think about rookies is that they are there to make you cash, but ultimately they're really there to get you more premiums.

If you think about it that way, it's clear that you want those premiums essentially ASAP, and the points tradeoff becomes clearer.

If you think of it in terms of points gained (x points per week from cash invested, times y weeks) and compare the trade on a "now vs later" basis, you'll be on the right track in my experience. The other factors I mentioned are then overlays on that.

 

[Darkie]

So, is the trick to get rid of the most or least successful rookies at this time?

Just to confirm on this, in my view it doesn't matter how well they've gone so far, it matters how much they've got left to go, and how quickly they will get there.

If you've made a mistaken selection, cutting and running is often the way to go.

 

[THCLT]

Hey guys,
Is there an easy way to post a table on the forum from excel? Just curious, because I see some big tables posted, and surely you're not typing everything out!

Option 1 - CLICK HERE and read post #43, if you want to copy an Excel table into your post and edit via the 'Advanced Options'.

Option 2 - CLICK HERE if you want to do all the formatting codes within Excel for your tables, then simply copy and paste the whole contents into your post.

 

[bomberboy]

Option 1 - CLICK HERE and read post #43, if you want to copy an Excel table into your post and edit via the 'Advanced Options'.

Option 2 - CLICK HERE if you want to do all the formatting codes within Excel for your tables, then simply copy and paste the whole contents into your post.

Will rep when possible. Makes life so much easier!

 

[toxic]

With the emergence of Preuss and Cameron as possible playing R3s.

Who is everyone using as their VC/Capt loophole option?

Myers?
Balic?
Strandica?

 

[stephen]

With the emergence of Preuss and Cameron as possible playing R3s.

Who is everyone using as their VC/Capt loophole option?

Myers?
Balic?
Strandica?

Deluca-Cardillo