Excel expert needed for formula driven work
Budget: $250 – $750 SGD
This data analysis work is driven by formulas. No data entry needed.
The task is to prepare a report on the data file that identifies and flags certain conditions. Specifically, the data consists of time records for 375 employees (297,200 excel lines).
Attached is a sample data set for one employee. First, we want to identify or flag each day when a meal break violation took place based on certain rules. Second, we need to record whether a premium was paid for a meal break violation.
Also attached are the detailed instructions for the work and a sample of how the end report should look like (found in the excel file tabbed: report)
Thank you.
The task is to prepare a report on the data file that identifies and flags certain conditions. Specifically, the data consists of time records for 375 employees (297,200 excel lines).
Attached is a sample data set for one employee. First, we want to identify or flag each day when a meal break violation took place based on certain rules. Second, we need to record whether a premium was paid for a meal break violation.
Also attached are the detailed instructions for the work and a sample of how the end report should look like (found in the excel file tabbed: report)
Thank you.