Notes: In excel shortform given there full form are given below.

• - = Pending
• P = Present
• A = Absent
• H = Half day
• S = Short day