I have an excel file that has data in rows, and has performance status taken for about a 1000 staff, on random dates, across a month. The status can be of 5-6 different types, like absent, present, half day, leave, terminated etc. I want you to create formulas and the charts that can take these rows and create a calendar, like a an attendance register, with one cell for each date, and the color of the cell should be as per the status as on that day. The row total should show a count for the numbers of days the staff was present.
You should create a list where I can change the status types. These status types will get matched with the status in the main sheet and then you should use the script to output the excel calendar as shown. All the cells that are green get counted as the row total, and if I make a cell green, you should count that in the total too.