Excel Formulas for HSE Metrics
Budget: €8 – €30 EUR
I’ve built an Excel 365 workbook that tracks three health, safety and environmental metrics—TRIR, LTIFR and MCFR—but the totals are still being tallied manually. I need you to insert the correct arithmetic formulas so each of those columns automatically produces an accurate running Sum every time new data is entered.
The sheet is already laid out; what’s missing is the logic behind it. Please:
• Add reliable SUM formulas to each of the three metric columns, making sure they keep working even when rows are inserted, deleted or filtered.
• Test the file to confirm that totals update instantly for new entries.
• Keep cell referencing clear and, if you see a cleaner way to structure the ranges (tables, named ranges, structured references), feel free to apply it.
Deliverables
1. The updated .xlsx file with formulas in place and tested.
2. A brief note explaining where the formulas live and how they can be extended if the sheet grows.
3. Automate graphs .
If you’re comfortable with Excel 365 functions and best practices for dynamic ranges, this should be straightforward. Let me know your turnaround time and any clarifying questions.
The sheet is already laid out; what’s missing is the logic behind it. Please:
• Add reliable SUM formulas to each of the three metric columns, making sure they keep working even when rows are inserted, deleted or filtered.
• Test the file to confirm that totals update instantly for new entries.
• Keep cell referencing clear and, if you see a cleaner way to structure the ranges (tables, named ranges, structured references), feel free to apply it.
Deliverables
1. The updated .xlsx file with formulas in place and tested.
2. A brief note explaining where the formulas live and how they can be extended if the sheet grows.
3. Automate graphs .
If you’re comfortable with Excel 365 functions and best practices for dynamic ranges, this should be straightforward. Let me know your turnaround time and any clarifying questions.