Original ask (Dishant's words)
"C) Operations and HR: ... 3) Maintain staff attendance and salary" "salary and increment as when and which day the employee has worked and his performance quality will define him/her marking his attendance but no output was there, which means they marked it wrong or fraudulently. each thing connects to other."
Vision
Google Sheet — employee × day matrix. Daily marking. Monthly summary auto-calculated. Salary calculated from attendance × performance.
The connection insight
Attendance alone is not enough. Marked attendance + zero output = either marked wrong or fraudulently. So C3 + C1 + performance connect: attendance × output = trustworthy attendance. Salary follows from this composite.
Notes
To be added.