NixMatchUps – GrandFinal version

Greetings all, welcome to the grand final versions of Nix DreamTrader and NixMatchUps.

Nix DreamTrader is updated but no difference from previous versions.  So no further comment necessary.

It’s all about head-to-head Matchups this week as each coach tries to get his team to peak just one more time.

For NixMatchUps the biggest change is an improved “Selection” tab – just what your Match Committee needs.  This now includes:

  • Comparisons of all 30 players in each squad, so you also know the bench options each of your opponents can use.
  • The average scores over the last 3 rounds for all the relevant players, as well as the averages / forecasts.
  • Various rankings for the team of each player – such as how many total DT points, 100s they normally score, plus more.
  • Various rankings for the opposition team of each player this round – such as how many DT points or 100s they usually concede, or have over the last 3 rounds, and whether the aggregate DT points across both teams is high or not.

Other changes from last week:

  • I’ve added another chart to compare your team’s Actual performance against your Forecasts – so you can see which of your players delivers or doesn’t.
  • I’ve updated the Instructions a bit more, although nobody has reported any problems using it which is good.

Links are below …

Nix DreamTraderR22p

NixMatchUps

  • NixMatchUps contains lots of sorting macros – this might create some concern from your virus checker or corporate firewall.
  • EDIT: WordPress has added a 2 or 3 to the NixMatchUps file because there are already other files with the same name on this blog, so it will download as NixMatchUps3.xlsm.  After you download the file you have to change the name back to NixMatchUps.xlsm (i.e. remove the 3 or 2).
  • Naming the file anything other than NixMatchUps.xlsm  will stop the programming macros from running.  This is actually a protective thing because it prevents the macros mangling some other spreadsheet you might have open at the same time.  They will only run on this one file name.
  • If you still have a previous round’s version of NixMatchUps and want to keep it, I suggest you save it in a different folder rather than change the name of either file to something other than NixMatchUps.xlsm.
  • EDIT 2: I have replaced the NixMatchUps file.  I mistakenly uploaded an earlier working version instead of the final one ready to be published.  The working version contains some outdated information, that was removed and corrected in the final version.

So that’s it … good luck to everyone for the big game.  Thanks to Warnie and the other lads at DTTalk for their support.  Thanks also to the users who took the time to send thanks or provide feedback, this is always appreciated.

Nix

Any questions post here or on twitter @NixTrader

 

8 Comments

  • Ok .. just tested MatchUps download and macro didn’t work.

    This is because WordPress has changed the name of the file and added a 2 – presumably because it already had a file with the same name on this blog.

    The quickest way to fix it is for users to just change the file name after you download. For the macros to run they have to be in a file called ” NixMatchUps.xlsm “

  • OK all wise ones in DT land.
    Giles or Pyke?
    Giles has Brogan back with him and against Goldy and Pyke is up against Cats wich isn’t that red hot in the ruck department. but he came of sore last week.
    Going on a few notes from Nix post, Giles has had more 100’s, a lot more and i should pick him but Brogan back tends to make me lean towards Pyke.
    Help please!
    Oh and im up against JimmyBob so please no game of friendlies between fellow posties thanks, just your honest opinion
    Cheers
    Cam

    • ps. how do we think Goodes will go this weekend?

    • Hey Cam,

      I think you are reading it wrong.

      If you look up Giles in the Selection tab, where it gives you 100s that is the ranking for the total GWS team. GWS is 15th best in scoring 100s for the year which isn’t good out of 18, whereas Pyke’s team Sydney is 10th best (which is better).

      Of more importance for both Pyke and Goodes is that Geelong is pretty stingy:
      – has given up 2nd least number of 100s for the year to its opposition,
      – 5th least total DT points overall to its opposition,
      – Geelong’s games are relatively low overall in combined total DT scores, and Geelong players tend to take a higher than average share of those points anyway, rather than give them to the opposition.

      Whereas for Giles, North Melbourne with their open attacking game score highly themselves but also let their opposition score freely. Brogan hasn’t been that significant in limiting Giles scoring in the past – so I’d go with Giles.

        • I think you should go with Pyke and I think Goodes will go amazing tomorrow ;)

          Whacking the C on either of these players would be even smarter.

          good luck – but not too much

  • Hey I’ve got 1 trade left and I need to decide on a ruckman, I have 30k left.
    I have both giles and goldstein, but Im not sure which one I should trade. I was leaning towards Goldstein because he only got 24 last week. Do I keep faith or trade him? or trade giles and get jacobs?
    Any help would be much appreciated. Thanks.

    • Forget about who to trade out, because I expect whichever one you keep will be emergency at best anyway.

      Who are you going to trade in, and which 2 rucks are you going to play is what is more important.