
Abgeschlossen
Veröffentlicht
Bezahlt bei Lieferung
Project: Excel-Based Compressor Health & Service Tracking Dashboard Project Overview I am looking for an experienced Excel developer to build a maintenance dashboard in Microsoft Excel only (no Power BI) for 13 industrial air compressors at a mine. The dashboard must track equipment health and service compliance based on running hours and support future date forecasting. ⸻ Key Requirements 1. Platform • Microsoft Excel only • No Power BI, no external databases, no macros unless clearly justified ⸻ 2. Asset Scope • 13 compressors (same OEM) • Each compressor runs approximately 24 hours per day • Running hours will be manually entered weekly ⸻ 3. Data Capture • Input sheet for weekly cumulative running hours • Asset register for compressor details • Service history table where completed services are recorded • Clear separation between input sheets and calculation logic ⸻ 4. Hours-Based Service Tracking The dashboard must track the following service intervals per compressor: • 500 hours • 1,000 hours • 2,000 hours • 4,000 hours • 8,000 hours • 22,000 hours For each service interval, the dashboard must automatically calculate: • Next service due (hours) • Remaining hours • Service status (healthy / due soon / overdue) ⸻ 5. Dashboard & Visualisation • Main dashboard showing all compressors vs all service intervals • Service status displayed using colour indicators/icons only (no text) • Overall compressor health based on worst-case service status • Summary indicators for: • Services overdue • Services due soon • Filters or dropdowns to view individual compressors ⸻ 6. Date-Based Forecasting • Dashboard must include an “As-At Date” selector • Changing the date must: • Forecast running hours based on 24 hrs/day • Recalculate service status and due dates • Default view must show current (today’s) status ⸻ 7. Controls & Governance • Input sheets clearly identified • Service resets controlled (planner-level updates) • Dashboard protected / read-only for viewers • Solution must be simple, robust, and audit-friendly ⸻ Deliverables • Fully functional Excel dashboard • Professional formatting and clear layout • Brief user guide explaining weekly updates • All formulas visible (no black-box solutions) ⸻ Preferred Experience • Advanced Excel skills (tables, formulas, Power Pivot optional) • Experience with maintenance or asset management dashboards • Industrial or mining background preferred ⸻ Notes • This is a technical maintenance tool, not a generic KPI dashboard • Logic accuracy and usability are critical • Solution must be easy to maintain long-term
Projekt-ID: 40073974
18 Vorschläge
Remote Projekt
Aktiv vor 2 Monaten
Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten

I can share examples of similar projects I’ve completed, and I’m able to I can develop fully dynamic visualization sheet that will provide clear insights tailored to your needs About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA Programming
$30 USD in 1 Tag
6,4
6,4
18 Freelancer bieten im Durchschnitt $28 USD für diesen Auftrag

Hi! I am proficient in MS Excel, Google Sheets, Spreadsheet accounting, and its use in business and analysis. I can accurately enter, arrange, analyze, and present your data. Let's Connect
$60 USD in 7 Tagen
4,2
4,2

As a seasoned data scientist, Excel guru, and an expert in data visualization and analysis - I am more than ready to take up this task! My technical expertise spans across a wide range of skills including the key Excel proficiencies required for this job such as tables, formulas, and its visualizing options. With my profound understanding of Python, R, SAS, SPSS, STATA, POWER BI and other similar tools - simplicity, robustness, and solution-driven approach will be the hallmarks of my work. Having contributed to vast dashboards that streamline complex processes in various industrial sectors in the past, I bring well-informed insights to the table -- which can prove to be valuable assets working on a project of such criticality. From building advanced predictive models to handling huge sets of data for insightful analysis with meticulous precision – my portfolio is stacked with examples that demonstrate my capabilities.
$10 USD in 1 Tag
4,3
4,3

Hello there,, I have advanced experience in Data Mining, Statistics, Statistical Analysis and Data Science. With my vast background in data analysis and management, I am confident in my ability to handle your categorical data project effectively and efficiently. I have extensive experience in collecting, cleaning, analyzing, and visualizing data using Python programming, an invaluable asset for a project of this nature. Additionally, I am well-versed with CRISP-DM framework and adept at identifying patterns within datasets Choosing me means benefitting from not only my expertise but also my personal approach to projects. I understand that each task is unique, requiring tailored skills, and so I'm willing to go the extra mile to provide you with results that meet and exceed your expectations. Let's join forces in this project as our combined strengths will surely produce a result that's efficient, elegant and insightful! Let's not waste any more time! Together, we can mine this data efficiently and answer the questions to achieve your goals. Best Regards, Thanks
$10 USD in 1 Tag
3,1
3,1

Hi! Pleased to meet you on this platform. I just read through the job details and can help you with the Excel dashboard. Let's discuss more on chat about your requirements and budget. Warm Regards. Bc
$30 USD in 4 Tagen
2,9
2,9

Hello! I have reviewed your project details and understand the critical need for a robust, audit-friendly Excel dashboard to track compressor health and service compliance. With my expertise in advanced Excel development and experience in maintenance and asset management solutions, I can deliver a solution that meets all your requirements. I can provide a solution that is simple, accurate, and future-ready. Let’s discuss your expectations and finalize the approach. Looking forward to your response.
$26 USD in 3 Tagen
2,4
2,4

Hi There I hope you're doing well. I am confident that I can complete the tasks you mentioned, and I would appreciate the opportunity to discuss the details with you further.
$15 USD in 1 Tag
0,0
0,0

Hello Sir/Madam, I have good experience in Excel work like data entry, data cleaning, formatting, compressing files and accuracy checking. I always deliver work on time with 100% accuracy. I carefully understand client requirements before starting the work. I can complete this Excel project within 7 days or earlier if needed. I am ready to start immediately and provide revisions until you are satisfied. Thank you for considering my bid.
$20 USD in 3 Tagen
0,0
0,0

Hi there, This is a well-defined, technical build and a strong fit for my experience with Excel-only maintenance dashboards in asset-heavy environments. I can deliver a robust, audit-friendly Excel solution (no Power BI, no external databases, no hidden logic) to track health and service compliance for all 13 compressors using running hours and date forecasting. Approach: • Clear separation of inputs, calculations, and dashboard • Weekly cumulative hours input, asset register, and service history tables • Automated tracking for all intervals (500–22,000 hrs) • Remaining hours, next service due, and status logic (healthy / due soon / overdue) • Overall health based on worst-case service status Dashboard & Forecasting: • Single view: all compressors vs all service intervals • Colour/icon indicators only • Overdue & due-soon summaries • Compressor filter dropdown • As-At Date selector forecasting hours at 24 hrs/day • Default view = today Governance & Delivery: • Controlled service resets • Protected, read-only dashboard • All formulas visible • User guide included Advanced Excel skills; maintenance-focused, simple, and built for long-term use. Best regards, Tisa
$30 USD in 5 Tagen
0,0
0,0

Hello! I have reviewed your project details and understand the critical need for a robust, audit-friendly Excel dashboard to track compressor health and service compliance. With my expertise in advanced Excel development and experience in maintenance and asset management solutions, I can deliver a solution that meets all your requirements. I can provide a solution that is simple, accurate, and future-ready. Let’s discuss your expectations and finalize the approach. Looking forward to your response.
$20 USD in 1 Tag
0,0
0,0

In my 1st Company I've given the same like dashboards for steam boilers input consumption and output given. So I believe I can give you what your organization needs.
$30 USD in 7 Tagen
0,0
0,0

Leveraging my rich experience in finance, particularly in data analysis, I bring a unique blend of skills to excel at your project of creating a maintenance dashboard for your industrial air compressors. Detail-driven and highly proficient in Microsoft Excel, I specialize in harnessing the platform's full capabilities while ensuring simple yet robust solutions. Additionally, my past experience in an industrial environment has given me important insights into maintenance operations and asset management - both crucial aspects of your project. By meticulously organizing the data capture process and logic flow, I will create separate, easily trackable sheets for your weekly cumulative running hours, asset register, and service history. This will enable us to build the tracking system you need for service intervals, remaining hours, and health status - seamlessly updated with every new data entry, ensuring you have real-time awareness of any potential issues.
$20 USD in 7 Tagen
0,0
0,0

I will build a robust Excel-only compressor maintenance dashboard (no Power BI, no macros unless approved) for 13 compressors. It will track hours-based services (500–22,000 hrs), show clear colour/icon status, forecast hours using an As-At Date, and provide planner-controlled service resets. Fully transparent formulas, protected dashboard, clean inputs, and a short user guide included.
$10 USD in 1 Tag
0,0
0,0

I am much more experienced in this field as I have worked as a Research Analyst, Online Event Management Trainee, Gathered, arranged and corrected research data to create representative graphs and charts highlighting results for presentations. Collaborated with leadership team to identify relevant questions and determine best methods of collection. Streamlined research processes to meet tight deadlines for multiple projects. Also controlling the part of Event Management to make a event successful. And expertised in best computer skills.
$20 USD in 7 Tagen
0,0
0,0

Freetown, Sierra Leone
Zahlungsmethode verifiziert
Mitglied seit Juli 16, 2025
$10-30 USD
$250-750 USD
$10-30 USD
$10-30 USD
$15-25 USD / Stunde
£250-750 GBP
$30-250 USD
$15-25 USD / Stunde
$30-250 USD
$30-250 USD
$2-8 USD / Stunde
$250-750 USD
$30-250 USD
₹12500-37500 INR
₹1250-2500 INR / Stunde
₹2000-6000 INR
$25-50 USD / Stunde
$30-250 USD
₹600-1500 INR
₹12500-37500 INR
$15-25 USD / Stunde
₹2000-6500 INR
$10-30 USD