C6 isnt really relevant, just titles
D7:D10898 is the areas where attendees are from
I7:I10898 is the first date column (I has day 1 dates, K day 2, M day 3), a no show has an N, attendance is Y