[Exporting Daily Ratings into Excel]

Hi, just found this. I think the issue with other ELO tables being stubborn is the different dates so I have changed some formulas in the input sheet

Change F2 to this and then copy down: =COUNTIFS($A$2:A2,">="&$B$1,$A$2:A2,"<"&$B$2+50000)

Change G3 to this and copy down: =IF(AND((A3>($B$1-1)),(A3<($B$1+50000))),"Start","")

This means that instead of just matching with the date in B1 it looks 50000 units (not sure what they are but it works) ahead.

Works for me - needs testing though. You could now add a date column in the ELO ratings sheet

In the example below the bottom two games are on different dates to the rest. It is broken though - says Man United will win

Edit: Change B2 to this and copy down: =IF(AND((A2>($B$1-1)),(A2<($B$1+50000))),1,0)

You can now paste data from multiple ELO tables!

 

Edited again - Added date column in ratings sheet. Hard to explain (if you know arrays, you know!) so will find a way to upload file (with massive thanks to Froment)