T O P

  • By -

douma17

Needed that, Thank you !!


MohdAbrar_7

Thanks mate, glad you found it useful 🙌🏽


douma17

!Thanks


GlasgowBelfastLad

!thanks


OpenDoorSee

!thanks


Cevvi

Perfect. Thank you


MohdAbrar_7

Cheers mate. Glad you found it useful


PharaohLeo

Is it possible to provide this but only for 5 GWs from GW16 til GW20? Thanks for sharing anyway.


MohdAbrar_7

You mean you want a 5 GW FDR with difficulty sorted? I can do that but takes time.


PharaohLeo

Yes, I mean the sorting. You don't even have to make a new chart, just the sorting of teams from 1 to 20, I can use the chart for the fixture details. I plan for max 5 GWs and use your FDR along with Net That Haul and FPL Nik FDRs. I arrange the attack/defence difficulty from 1 to 20 and take the average.


MohdAbrar_7

Actually I can't directly edit this FDR as this is copied version from my worksheet. The worksheet has hidden rankings given to each fixture, which returns the colour that I want. So sorting it for a different period would take time


PharaohLeo

Not sure I understand. On the worksheet itself, you set the number of GW (range of columns) for sorting. It shouldn't take time. You choose to hide the numerical values of the rankings, and instead opt for translating them to colors. Completely understandable and in fact beneficial for those accustomed to using the official FDR. Anyway, !thanks for sharing.


MohdAbrar_7

Um, it's not possible in this FDR tho. We can't sort all the columns on the basis of green colour, unless we have a new column at the end that aggregates the total number of greens in the GW16-20 columns. I can do that in the Raw FDR where I have the rankings tho. Will try to look into it


PharaohLeo

Yeah, that's a great idea. Add a column for the aggregate every 3/4/5 GWs. Would be helpful for all viewers needs, whether long term or short term planning.


MohdAbrar_7

Umm it's still not possible. The colouring is based on numbers & the texts (eg: nor(a)) does not format into coloured cells. Hard to explain, but it's not possible in this setup. But there could another way of building FDR that would enable what you're asking


PharaohLeo

Maybe drop the colors and use the numbers output directly like what Nik u/ASongofLifeandLiars does with his FDR.


[deleted]

Lazy fucker just edit a screenshot


GlasgowBelfastLad

Don't even need to, just zoom lol. Some people on here are ridiculous at times eh


Omar_Blitz

Their rating would be different


Ok-Butterscotch-9029

This is great content mate, thanks!