NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

wolfking wrote:Shit I have Stapleton, Norrie and Hookey on a bye, Costigan dropped, TLT still injured and Luck now on the bench.  Oh dear.

WTF is with McGuire, starts hooker round 1, centre round 2 and now lock round 3?  Got not choice this week but still.

TLT is injured? Wondered why we were getting teams on a Monday

filthridden wrote:

TLT is injured? Wondered why we were getting teams on a Monday

Been injured for a couple of weeks and will be out until at least the 28th of May.

@milchcow
Would you please check Kurt Gidley:


It looks like something funky is going on with his prior S2, S3, S4, S5 scores. He was originally priced at $915K for a 60 point average.
I thought I picked him up last round for $905K, but looks like I got him for $817K instead - which gives me an extra $88K ITB that I probably shouldn't have (and as much as I'd like to have that extra cash...)
Thanks!

Think something is wrong with the pricing on teams tab.

For myself cell 235I seems to have taken Schifcofske's price and given it to Inglis. Similarly 233I has given Putell's price to Covell. I assume this is the same across all teams?

Phil Bailey as a starting centre made 33 tackles #gun watch

multiple.scoregasms wrote:Think something is wrong with the pricing on teams tab.

For myself cell 235I seems to have taken Schifcofske's price and given it to Inglis. Similarly 233I has given Putell's price to Covell. I assume this is the same across all teams?

Sort your players tab by Alphabetical, Yileen Gordon (Who?!) should be your last player on line 422, make sure you select all the data......

If not, sort Milch's sheet on Alpha then copy paste players column and Price column

Also check the formula in G2 on the planner tab actually matches up with the correct player.  It should say =IFERROR(INDEX(Players!F:F,MATCH(E2,Players!A:A,0)),0)

Hope this helps.....

If that doesn't work there is another thing to try...

Luke Douglas debut game off the bench produced a 38. Could be a good cash cow. With the amount of bench duds I have I may have to take a punt with him.

wolfking wrote:Luke Douglas debut game off the bench produced a 38.  Could be a good cash cow.  With the amount of bench duds I have I may have to take a punt with him.

I liked the look of him but needed a WFB so probably going to waste a trade on Darren Albert.

The Dogs bye is a bigger pain for me than the Panthers one.

Any idea on why Cordoba is out? Is that an injury? Seemed to be going well as a bench forward?

mattnz wrote:Code Delta has negative cash available, so something is wrong somewhere

It's okay, I read somewhere that he now has Nick Politis as a patron, so a bit of a "flexible" cap

Moanaman wrote:

Sort your players tab by Alphabetical, Yileen Gordon (Who?!) should be your last player on line 422, make sure you select all the data......

If not, sort Milch's sheet on Alpha then copy paste players column and Price column

Also check the formula in G2 on the planner tab actually matches up with the correct player.  It should say =IFERROR(INDEX(Players!F:F,MATCH(E2,Players!A:A,0)),0)

Hope this helps.....

If that doesn't work there is another thing to try...

I don't own Yileen Gordon and haven't since about 2008

Moanaman wrote:

Sort your players tab by Alphabetical, Yileen Gordon (Who?!) should be your last player on line 422, make sure you select all the data......

If not, sort Milch's sheet on Alpha then copy paste players column and Price column

Also check the formula in G2 on the planner tab actually matches up with the correct player.  It should say =IFERROR(INDEX(Players!F:F,MATCH(E2,Players!A:A,0)),0)

Hope this helps.....

If that doesn't work there is another thing to try...

I think the error is in the spreadsheet. Affects what the view of team value is, so is important to fix up for everyone

mrstephenb wrote:I think the error is in the spreadsheet. Affects what the view of team value is, so is important to fix up for everyone

Moanaman wrote:

Sort your players tab by Alphabetical, Yileen Gordon (Who?!) should be your last player on line 422, make sure you select all the data......

If not, sort Milch's sheet on Alpha then copy paste players column and Price column

Also check the formula in G2 on the planner tab actually matches up with the correct player.  It should say =IFERROR(INDEX(Players!F:F,MATCH(E2,Players!A:A,0)),0)

Hope this helps.....

If that doesn't work there is another thing to try...

Ok, if that doesn't work go to the Planner tab

Click Data at the top

Click in Cell G2

Click on Data Validation (Top Right)

It should say ... =Players!$F$2:$F$425 Or what ever column you have the player names in on the Players tab

Check every cell in Column G, or whatever column has your prices in it, shows the same thing...




If that doesn't work, it's beyond my (limited) Excel knowledge.  Milchcow or Verbal may have other ideas

Moanaman wrote:



Ok, if that doesn't work go to the Planner tab

Click Data at the top

Click in Cell G2

Click on Data Validation (Top Right)

It should say ... =Players!$F$2:$F$425 Or what ever column you have the player names in on the Players tab

Check every cell in Column G, or whatever column has your prices in it, shows the same thing...




If that doesn't work, it's beyond my (limited) Excel knowledge.  Milchcow or Verbal may have other ideas

I know how to fix it. In Column I of the Teams tab, it should refer to Column F not Column B.

mrstephenb wrote:

Hi Milchcow, I think there is an error in the spreadsheet. For example in the Teams tab, in my team it is looking up Chris Hicks instead of Greg Inglis for Inglis's new price.

Updated sheet, available first page

was getting prices from round 1 team not the round 2 changes

easytiger wrote:@milchcow
Would you please check Kurt Gidley:


It looks like something funky is going on with his prior S2, S3, S4, S5 scores. He was originally priced at $915K for a 60 point average.
I thought I picked him up last round for $905K, but looks like I got him for $817K instead - which gives me an extra $88K ITB that I probably shouldn't have (and as much as I'd like to have that extra cash...)
Thanks!

I see what I've done, working on it now

Milchcow wrote:

Updated sheet, available first page

was getting prices from round 1 team not the round 2 changes

Thanks Milchcow

The problem was - when getting the players starting value, is I was looking for the player on the 'History tab', but then getting the value from that row on the 'R0' initial tab

So if they were both sorted alphabetically it would be fine, but as soon as once of the tabs got sorted in a different way, everything stuffed up.

I've fixed that problem, but just trying to make sure before I re-upload that everything still makes sense

Does anyone remember if Ben Rogers was any good. He's starting at lock for Souths in round 3 & is priced at 301k & is dpp 2fr/hlf. I do remember him I think & he likes to be aggressive but what about his work rate at lock. Cheers.