True. In my last job I was unofficial HR, timekeeper, purchaser, schedule maker, everything. My precessor used to do everything on paper. He had files of leave

True. In my last job I was unofficial HR, timekeeper, purchaser, schedule maker, everything. My precessor used to do everything on paper. He had files of leave forms, monthly attendance timesheets, rotation scheudles etc. I started using a excel sheet. One sheet named db, listing the employee number, names, start date, position, entitled leave days, manager name, work pattern (day only, any shift). Then over time I added other sheets like leave details, which pulls employee data from db, and adds more data like their aprooved vacation slots etc. A sheet listing every day of the year in columns, and rows as employee names & numbers, and I will manually tyoe N for Night, D for Day, F for Friday OFF, H for Holiday, V for Vacation. Then another sheets pulls data & shows me for my chosen month a printed & formatted schedule. It also lists the percentage of workforce, and their divisions. Another sheet pulls vacation data for one employee for my chosen year. It was fun creating all those formulas.