NRL Fantasy Fanatics

NRL Fantasy Fanatics - A place for discussion of NRL Fantasy / Virtual Sports / Super Coach and other Fantasy Sports

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

    filthridden
    filthridden
    Moderator

    Posts : 9488
    Reputation : 3922
    Join date : 2015-09-27

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by filthridden on Mon Apr 13, 2020 9:16 am

    @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 :pp:
    wolfking
    wolfking
    Fanatic

    Posts : 17028
    Reputation : 3820
    Join date : 2016-04-26
    Age : 36
    Location : Brisbane

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by wolfking on Mon Apr 13, 2020 9:36 am

    @filthridden wrote:

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

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

    Posts : 361
    Reputation : 171
    Join date : 2020-01-27

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by easytiger on Mon Apr 13, 2020 9:37 am

    @milchcow
    Would you please check Kurt Gidley:
    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Gidley10

    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!

    multiple.scoregasms
    multiple.scoregasms

    Posts : 3857
    Reputation : 1655
    Join date : 2015-10-29
    Age : 27

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by multiple.scoregasms on Mon Apr 13, 2020 9:47 am

    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?
    multiple.scoregasms
    multiple.scoregasms

    Posts : 3857
    Reputation : 1655
    Join date : 2015-10-29
    Age : 27

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by multiple.scoregasms on Mon Apr 13, 2020 9:57 am

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

    Posts : 410
    Reputation : 166
    Join date : 2020-01-27
    Location : Shaky Town

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by Moanaman on Mon Apr 13, 2020 10:08 am

    @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...
    wolfking
    wolfking
    Fanatic

    Posts : 17028
    Reputation : 3820
    Join date : 2016-04-26
    Age : 36
    Location : Brisbane

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by wolfking on Mon Apr 13, 2020 10:26 am

    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.
    mattnz
    mattnz

    Posts : 4560
    Reputation : 1174
    Join date : 2018-03-11

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by mattnz on Mon Apr 13, 2020 11:03 am

    @GreenMachine wrote:Ruh Roh... CP13... he's in :-)
    CP12
    Teeth Eater
    Teeth Eater

    Posts : 1225
    Reputation : 336
    Join date : 2018-02-20

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by Teeth Eater on Mon Apr 13, 2020 11:03 am

    @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. Sad

    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
    mattnz

    Posts : 4560
    Reputation : 1174
    Join date : 2018-03-11

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by mattnz on Mon Apr 13, 2020 11:07 am

    Code Delta has negative cash available, so something is wrong somewhere
    easytiger
    easytiger

    Posts : 361
    Reputation : 171
    Join date : 2020-01-27

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by easytiger on Mon Apr 13, 2020 11:34 am

    @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
    multiple.scoregasms
    multiple.scoregasms

    Posts : 3857
    Reputation : 1655
    Join date : 2015-10-29
    Age : 27

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by multiple.scoregasms on Mon Apr 13, 2020 11:41 am

    @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 Laughing
    mrstephenb
    mrstephenb

    Posts : 19
    Reputation : 5
    Join date : 2020-03-28

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by mrstephenb on Mon Apr 13, 2020 11:41 am

    @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
    Moanaman
    Moanaman

    Posts : 410
    Reputation : 166
    Join date : 2020-01-27
    Location : Shaky Town

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by Moanaman on Mon Apr 13, 2020 11:56 am

    @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...

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


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

    Posts : 19
    Reputation : 5
    Join date : 2020-03-28

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by mrstephenb on Mon Apr 13, 2020 12:26 pm

    @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...

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


    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.
    Milchcow
    Milchcow
    Moderator

    Fantasy Fanatics VSDT Overall Group Winner : 2017
    Posts : 13745
    Reputation : 6615
    Join date : 2015-07-31

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by Milchcow on Mon Apr 13, 2020 1:02 pm

    @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
    Milchcow
    Milchcow
    Moderator

    Fantasy Fanatics VSDT Overall Group Winner : 2017
    Posts : 13745
    Reputation : 6615
    Join date : 2015-07-31

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by Milchcow on Mon Apr 13, 2020 1:07 pm

    @easytiger wrote:@milchcow
    Would you please check Kurt Gidley:
    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Gidley10

    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
    mrstephenb
    mrstephenb

    Posts : 19
    Reputation : 5
    Join date : 2020-03-28

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by mrstephenb on Mon Apr 13, 2020 1:11 pm

    @Milchcow wrote:

    Updated sheet, available first page

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

    Thanks Milchcow Smile
    Milchcow
    Milchcow
    Moderator

    Fantasy Fanatics VSDT Overall Group Winner : 2017
    Posts : 13745
    Reputation : 6615
    Join date : 2015-07-31

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by Milchcow on Mon Apr 13, 2020 1:13 pm


    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
    White Lightning
    White Lightning
    Fanatic

    Posts : 10008
    Reputation : 2577
    Join date : 2015-10-13

    NRLFF 2006 Fantasy thread - Round 3+4 El Magic round - Page 2 Empty Re: NRLFF 2006 Fantasy thread - Round 3+4 El Magic round

    Post by White Lightning on Mon Apr 13, 2020 1:19 pm

    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.

      Current date/time is Fri Jun 05, 2020 9:16 pm