Site Update Summer 2020

The QPR Prediction Games section of the site has been updated to red and black in line with the new away kit colours.

The previous colours of mint green and gold have moved down to the Hoops & Dreams Support section which was previously pink and black from the season before.

I'm sticking with gold as the 'hover' colour across the site and as the border colour for the main section of the site for now as it just looks better than everything highlighting in red.

The Lone Ranger and QPR Prediction League will be back by the end of the week and open for entries ahead of the big kick off in just over 2 weeks time.

I will set up a Championship table prediction game and Place Your Bets in the next week or so too.

My problem is Dream R's... this season is awkward. I can't have a cut off before the season as the squad is going to change massively. But the transfer window is open into October by which time we'll have played quite a few times already. I'm not sure what to do with it if I'm honest. Open to suggestions!

Only a suggestion but why not have the cut off before the season starts or on a date convenient to you and then have 2 transfer windows (a one off special in November for this season only and then the normal transfer window early in the new year). 

As I say this is only a suggestion and might be totally impracticable because of the work involved.

Overall I'm happy to go with whatever the consensus is regarding the Dream R's competition.

Well after 20 minutes spent on the spreadsheet 2 transfer windows is a non-starter.

It is way beyond my capabilities on excel. I currently have the formulas so it works out a QPR players score for the full season, before the window and after the window. If a player is removed from a squad I adjust the formula and they only get the score from before the window, if they are added they only pick up the score for after the window etc. It's tricky enough but I know where I'm up to. To try and split the season into 3, I honestly don't even know where to start having had a look.

So we are going to have to go with 1 transfer window. It is just a decision on whether we open the game sooner or wait until the transfer window closes.

Yes I can add any new players in even up to the deadline for entry and then any who join after we start scoring can be added in February.

Adding players is easy, it's all the formulas that are tricky. On the Dream R's spreadsheet I manually enter the score for a QPR player each match and it knows which squads they are in and it then totals up the points for each team, which in turn it transfers to the league table. It works, but splitting the QPR player scores more than once in a season (for 2 transfer windows) is nigh on impossible for me!

The EFL website states:



QPR have an international break for 2 weeks there after a match on 3rd, playing again on 17 October. I think that will be when the deadline for entries is. It actually means Dream R's would only miss 4 league games. I think I'll set up Dream R's once the season is underway and players will have a month to enter and plan etc.

Players can then either enter straight away or wait to see if anybody comes in right until the deadline.

Would it work with just 10 players selected initially and then 11 once the transfer window slams shut...? (I have a feeling that it is too complicated but thought would ask...)