Rhino Logistics - Excel incident report macros
Budget: $250 – $750 USD
Spreadsheet design
Macro 1
List of employees imported weekly from ADP as CSV or excel file.
The dropdown list in column G contains all employee names and is updated after each import.
Employees that are terminated are marked as such on the incident data spreadsheet. Update the employee status column for each employee.
New employees are added to the incident data spreadsheet.
All employees without incident reports receive a value of zero for points assigned.
Macro 2
Drop down list in column C on incident data spreadsheet built from incident type list Tab.
Assign point values to each incident on the incident data tab.
On a separate tab, list employees and incident data with points and total points.
All employees with points are listed in column A.
All points assigned to an employee in Incident Data tab are added together and mapped to Column B by employee. Total number of points should be in this column .
Assign date for incident entry. After 60 days, create an alert that the incident needs to be archived.
Macro 3
Excel assigns a numerical value to each incident reported.
Timestamp in Column L of Incident Data is automatically populated when data in the corresponding row is saved.
Macro 1
List of employees imported weekly from ADP as CSV or excel file.
The dropdown list in column G contains all employee names and is updated after each import.
Employees that are terminated are marked as such on the incident data spreadsheet. Update the employee status column for each employee.
New employees are added to the incident data spreadsheet.
All employees without incident reports receive a value of zero for points assigned.
Macro 2
Drop down list in column C on incident data spreadsheet built from incident type list Tab.
Assign point values to each incident on the incident data tab.
On a separate tab, list employees and incident data with points and total points.
All employees with points are listed in column A.
All points assigned to an employee in Incident Data tab are added together and mapped to Column B by employee. Total number of points should be in this column .
Assign date for incident entry. After 60 days, create an alert that the incident needs to be archived.
Macro 3
Excel assigns a numerical value to each incident reported.
Timestamp in Column L of Incident Data is automatically populated when data in the corresponding row is saved.