
Completed
Posted
Paid on delivery
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.
Project ID: 40142831
48 proposals
Remote project
Active 5 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
48 freelancers are bidding on average €27 EUR for this job

With years of experience focusing on data entry, processing, and Excel functions, I am confident I can deliver precisely what you need for your HSE metrics project. Not only am I adept in using Excel 365 and well-versed in its functions, but my skills extend to encompass dynamic ranges, a crucial factor in managing spreadsheet updates. Throughout my career, I have consistently demonstrated the ability to incorporate improved logic and automation into projects requiring data management. This aligns perfectly with what you’re looking for in your workbook. By applying efficient SUM formulas and employing structured Cell referencing techniques, you can trust that the report will update accurately every single time new data is entered - irrespective of rows being inserted, deleted, or filtered. Moreover, beyond optimizing your existing sheet with correct formulas, I propose to take a step further by automatizing graphs. This additional enhancement adds meaningful visual representation to the numbers you track, highlighting trends and giving valuable insights into your metrics. This project would be a great fit for my skills and passion for delivering high-quality results efficiently. Let's discuss how we can turn this project around to exceed your expectations!
€30 EUR in 1 day
8.9
8.9

I recognize the value of your project and understand exactly what you need. With my seven years of experience as a Full stack developer, I have acquired strong skills in Excel including formulas, VBA, Macros, and data analysis - all of which are pivotal for tackling this project. I've effectively tackled projects similar to yours, blending excel automation with data processing to make comprehensive and meaningful reports efficiently. Your project will definitely benefit from my expertise. I guarantee not only a swift delivery but also absolute satisfaction. I code efficiently, considering every aspect from clarity to versatility to ensure they work seamlessly even when rows are manipulated or filtered. In addition to setting up accurate SUM formulas, testing them extensively is a remarkable feature of my service that reassures optimal and holistic functionality. All these assurances will be provided with clear communication on how to extend the logic if the sheet grows.
€50 EUR in 1 day
8.7
8.7

With 7 years of professional experience and a comprehensive array of skills with advanced data analysis, I am confident in my ability to not just implement the Excel formulas you need for your HSE metrics, but to do so with efficiency and accuracy. I have consistently enabled businesses to derive valuable insights from their data by leveraging various tools and techniques, including deep knowledge of Excel 365 functions and best practices for dynamic ranges – making me perfectly suited to tackle this task. I will not just add reliable SUM formulas to each metric column and ensure they continue working seamlessly even with changes made on the sheet; I will also conduct thorough tests on the file's functionality to confirm all totals update instantly for any new entries. Moreover, as an Excel expert, automation is second nature to me – something you can expect me to bring into play when generating automated graphs for you. My service doesn't end at mere calculations; I provide detailed notes elucidating not only how the formulas operate, but also where they reside and how they can be extended in case of future sheet expansion. This foresightedness ensures that you have a sustainable solution. I'm excited about the opportunity to work with you on this project and delighted at the potential prospect of employing my expertise for your future endeavors. Let's discuss timelines & any further questions you have!
€60 EUR in 1 day
6.7
6.7

I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
€80 EUR in 3 days
6.7
6.7

Hi Ian, Thank you for considering my proposal. With over 8 years of real-world experience and freelance work in Excel, I am confident in my ability to assist you with this project. I have carefully reviewed your project requirements regarding adding accurate SUM formulas to track HSE metrics in your Excel workbook. I am well-versed in Excel 365 functions and can ensure that the formulas are reliable and adaptable to changes in the data. I would like to connect with you in chat to discuss your project further and clarify any details. Regards,
€30 EUR in 1 day
6.5
6.5

Hello, I’m an Excel 365 specialist with strong experience implementing robust, future-proof formulas, and I can quickly complete the logic your HSE metrics workbook is missing. I’ll insert reliable, dynamic SUM calculations for TRIR, LTIFR, and MCFR that continue to work flawlessly when rows are added, removed, or filtered, using best practices such as Excel Tables, structured references, or named ranges where appropriate. I’ll fully test the file to ensure totals update instantly with new entries, automate the related graphs so visuals stay in sync with the data, and return a clean, updated .xlsx along with a brief explanation of where the formulas live and how to extend them as the sheet grows. This is a straightforward task for me, and I can turn it around quickly while keeping everything clear, maintainable, and accurate. Regards, Zafar
€30 EUR in 1 day
6.3
6.3

Hi, I can update your Excel 365 workbook so that TRIR, LTIFR, and MCFR columns automatically calculate running totals with reliable formulas. I’ll ensure the formulas update correctly when rows are added, deleted, or filtered, using dynamic ranges, structured references, or named ranges for clarity and maintainability. I can also automate the associated graphs so they reflect new data instantly. Deliverables will include: The updated .xlsx file with fully tested formulas. A brief note explaining where the formulas are and how to extend them as the sheet grows. Automated graphs linked to your metrics. Best Regards, Virendra
€30 EUR in 3 days
6.2
6.2

Having worked with Excel for data analysis and visualization for over a decade, I have honed my skills in deciphering spreadsheets into sleek and powerful tools. Your need to automate your HSE metrics screams my name - I am well-versed in the art of crafting formulas, summarising and monitoring columns that save you time, effort, and human error. I understand the necessity of dynamic ranges and table structuring, which ensures that your sheet remains flexible, robust and always up-to-date. As per your request, not only will I add reliable SUM formulas to each metric column ensuring they can handle insertions, deletions, and filters, but I'll also create a logically structured sheet that will allow easy and intuitive extension as needed overtime. And let's not forget about those automation! I'll transform your important metrics into visual wisdom via automated graphs. As a freelancer with a full-stack team when required, you are not just hiring me; you are bringing aboard an entire network of certified developers who can assist if the project's complexity grows. Been impressed by my well organized and easily maintainable work? Rest assured, I don't disappear after delivery—I am here to provide long-term support & post-launch updates to ensure complete client satisfaction. Let's bring the golden age of manual tallies in your HSE workbook to an end with my swift turnaround skills.
€19 EUR in 7 days
6.0
6.0

Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply
€30 EUR in 1 day
5.7
5.7

Hello, I’d be happy to help you automate your Excel 365 workbook so TRIR, LTIFR, and MCFR totals update automatically without manual work. I will add reliable SUM logic that keeps working even when rows are inserted, deleted, or filtered. I’ll convert ranges into dynamic tables or named ranges so the totals remain stable and accurate. I will also test the file to confirm everything updates instantly when new data is entered. Along with that, I will automate graphs so they refresh automatically with new data. You’ll also receive a brief explanation of where formulas are placed and how to extend them if the sheet grows. This is straightforward and I can deliver it quickly. Please let me know your turnaround time and share the file so I can begin. Best regards, Tauqeer Ahmed
€25 EUR in 2 days
4.9
4.9

Hi there, I understand you're looking for a seamless solution to automate your health, safety, and environmental metrics within your existing Excel workbook. With expertise in Excel 365 functions and dynamic range management, I can efficiently set up the required SUM formulas to ensure your TRIR, LTIFR, and MCFR columns update automatically with every data entry. I'll also ensure clear cell referencing and test the workbook to confirm instant updates, enhancing usability with tables and named ranges where beneficial. Best regards,
€21 EUR in 1 day
4.3
4.3

I reviewed the workbook and the figures are correct, but the KPIs and rolling totals are currently driven by manually entered values rather than calculated from a structured data source. My proposal is to introduce a proper data table as the calculation backbone, convert the summaries into formula-driven results (TRIR, LTIFR, MTIFR and 12-month rolling), and link the charts to these dynamic ranges so everything updates automatically when new data is added.
€30 EUR in 3 days
3.3
3.3

Sir, I am well expert in excel VBA formula. I can fulfill your requirement's as sooner and duly time frame. Please keep trust and inbox me for more discussion. Regards Musa khan
€8 EUR in 2 days
3.5
3.5

Your project aligns perfectly with my skills and expertise in data entry, Excel, and data management. In the past, I have excelled at creating dynamic and efficient spreadsheets by implementing formula logic, which enables smooth tracking of metrics over time. Leveraging these capabilities, I will add reliable SUM formulas to the metric columns (TRIR, LTIFR, and MCFR) that will work seamlessly even during insertions, deletions, or filters. One area where I can provide immense value is by thoroughly testing the file to ensure instant updates for new entries and maintain clear cell referencing. If any opportunity arises to improve the ranges (tables, named ranges, structured references), I will implement them for enhanced convenience and organization. Moreover, as a detail-oriented expert, I am dedicated to maintaining accuracy and confidentiality. Lastly in addition to delivering a comprehensive updated file with all necessary formulas and testing completed to your satisfaction I will go above and beyond by providing additional insights in a brief note explaining where the formulas reside and how they can be extended if needed. As an Excel ninja well-versed in graph automation as well- graphs depicting your safety metrics could also be created automatically saving you time. Together, we can revolutionize your HSE data tracking process for improved efficiency and reliability.
€19 EUR in 7 days
1.4
1.4

Hi there, My name is Devi Apriana, and I’d be happy to help you automate the calculation logic in your Excel 365 workbook so your TRIR, LTIFR, and MCFR totals update automatically without any manual work. I understand the sheet structure is already in place and what’s needed now is clean, reliable formulas that continue to work even when rows are added, deleted, or filtered. That’s exactly the kind of Excel optimization I specialize in. Here’s how I’ll handle your file: Insert robust SUM formulas for each metric column so totals update instantly with new data Use Excel 365 best practices (structured tables, dynamic ranges, or named ranges) to prevent broken formulas Test the workbook thoroughly to confirm totals recalculate correctly in real use Automate graphs so charts update dynamically as new entries are added Keep formulas easy to understand and maintain Deliverables: Updated .xlsx file with tested formulas in place A brief explanation showing where formulas live and how they extend as the sheet grows Automated charts linked to dynamic ranges I’m comfortable working with Excel 365 functions and designing spreadsheets that stay reliable long-term. This should be a straightforward task, and I can deliver quickly once I review the file. Let me know if you have any specific preferences for table structure or chart style, and I’m ready to get started. Thanks for your time and consideration. I look forward to working with you. All the best, Devi Apriana
€8 EUR in 3 days
1.4
1.4

I understand that you already have an Excel 365 workbook tracking TRIR, LTIFR and MCFR, but totals and visuals are still being updated manually. The goal is to implement reliable formulas and automation so totals and charts update instantly as new data is entered—without breaking when rows are added, deleted, or filtered. Approach: I will convert your existing data range into structured Excel Tables and implement dynamic SUM / SUBTOTAL formulas using Excel 365 best practices. This ensures accuracy, scalability, and zero manual intervention. Where helpful, I’ll apply clean structured references and optional running totals. Automated, table-driven charts will be added so visuals always reflect the latest data. Deliverables 1. Updated Excel (.xlsx) file with tested, dynamic formulas for TRIR, LTIFR and MCFR 2. Automated, auto-refreshing graphs based on table ranges 3. A brief documentation note explaining formula placement and how to extend the sheet as it grows Requirements 1. Access to the existing Excel file 2. Confirmation on whether you need column totals, running totals, or both 3. Preferred chart types (line, trend, cumulative, etc.) Post-Delivery Support: I provide post-delivery support for clarifications, minor adjustments, and future-proofing guidance to ensure long-term usability. Turnaround time: Same day (within 2-3 hours after file access).
€20 EUR in 1 day
1.2
1.2

Hi there, I have carefully reviewed your project requirements and understand the task clearly. After analyzing the details and expected outcome, I am submitting this proposal with a focused and practical approach to your project. I will add reliable SUM formulas to the three health, safety, and environmental metrics columns in your Excel 365 workbook. These formulas will update automatically when new data is entered, ensuring accurate running sums. Additionally, I will validate that the totals remain accurate even with inserted, deleted, or filtered rows. Upon completion, I will provide you with the updated .xlsx file with tested formulas, along with a brief note outlining the formula locations and how they can be extended as the sheet grows. Furthermore, I will automate graphs to enhance data visualization. If you approve, I will implement best practices for dynamic ranges, clear cell referencing, and consider restructuring ranges for better organization. Let's discuss in detail through chat.
€8 EUR in 4 days
3.1
3.1

Hello, I am very interested in helping you automate your HSE metrics workbook in Excel 365. I understand that you need TRIR, LTIFR, and MCFR totals to update automatically whenever new data is added, and that the totals should remain accurate even when rows are inserted, deleted, or filtered. I am comfortable with Excel formulas, dynamic ranges, tables, structured references, and VBA if needed. I will: • Add SUM or structured SUM formulas for each metric column • Ensure formulas automatically adjust to new rows or changes • Test the workbook thoroughly to confirm totals update instantly • Optionally improve range structure using tables or named ranges • Automate graphs so they update dynamically with new data • Provide a brief note explaining the formulas and how to extend them I can deliver this within 1–2 days depending on the workbook size. Please share the file so I can review and confirm the best approach. Looking forward to helping you make this workbook fully automated. Best regards, Karan
€19 EUR in 7 days
0.0
0.0

Hello, I can help you complete this Excel 365 task efficiently. I will add dynamic and reliable SUM formulas for TRIR, LTIFR, and MCFR so totals update automatically whenever new data is added, removed, or filtered. I’ll use Excel Tables and structured references to ensure the file remains clean, scalable, and easy to maintain. I will fully test the workbook and also automate the graphs so they update instantly with new entries. Along with the updated file, I’ll include a short note explaining where the formulas are placed and how they can be extended as the sheet grows. Delivery within 2 days. Ready to start immediately. Best regards, Mohammed
€19 EUR in 2 days
0.0
0.0

I have over a decade of experience in optimising legacy excel tools having VBA, Power Query, DAX, Excel Advanced Formulas.
€30 EUR in 3 days
0.0
0.0

Noordhoek, Netherlands
Payment method verified
Member since Jan 13, 2026
₹1500-12500 INR
₹750-1250 INR / hour
$10-30 USD
$10-30 USD
₹12500-37500 INR
$250-750 CAD
$10-30 USD
₹600-1500 INR
₹12500-37500 INR
₹1500-12500 INR
$30-250 USD
₹12500-37500 INR
₹12500-37500 INR
₹5000-20000 INR
$30-250 USD
₹12500-37500 INR
£250-750 GBP
$10-30 USD
$1500-3000 USD
₹400-750 INR / hour