Daily Time Sheet Approval Automation (Office365)

Job ID: 33528652

Budget: $30 – $250 USD

Each day, an excel file is downloaded with approximately 100 rows of data - with each row representing a contractor's time sheet (with ~10 relevant columns include the contractor's name, the facility name they worked at (22 facility options) they worked at, clock-in, clock-out, unfilled shift, canceled shift, wage rate, bonus, etc...). At the end of each day, we would like to automatically distribute to each facility supervisor by email/Teams/Sharepoint a copy of their facility's time sheet data for approval - including the ability for manual editing and adding additional rows of contractor data. At the end of each day, after the supervisor edits/appends/approves their facility's data, we want the confirmed data to be compiled in a master data model for our accounting department. (other notes: we want to use Office365 apps - proposals should include how you will store / transform / distribute / compile data using Office365 tools, including but not limited to Excel, PowerAutomate, Teams / Sharepoint, PowerBI, etc., some facilities will have zero contract labor from day to day and will have no need to approve anything. The attached files are examples of the daily time sheet export mentioned at the beginning of this project description (file name will always include the date it was produced and the most important data for approval are highlighted in yellow). Please include in your proposal your approach, estimated cost, and examples of other similar work/references - read this project description first before messaging.