
Suoritettu
Julkaistu
Maksettu toimituksen yhteydessä
I work at a company which owns 2 factories, 1 storage facility, 1 retail facility, administration building. All these locations are on-site and maintained by the same team but have different equipment. I need a single-workbook solution in Excel that lets me stay on top of their upkeep. The file must be driven by VBA and user-friendly forms so anyone in the team can add a new asset, log a repair, or update status without touching raw sheets. Core workflow - One form called for e.g. "enter repair or maintenance" lets user select date, location (factory 1, 2, etc.), equipment category, equipment. Choosing the locations filters the appropriate equipment category which filters the appropriate equipment (e.g. Factory 1 -> BOILERS -> CHANGING ROOM BOILER #2). Then the users selects repair or maintenance; then they can enter notes on the repair; select who did the repair; select a price if applicable; select who accepted/ validated the repair; enter additional notes; all these are separate entries on the form; then the form has a button to save the entry or cancel/empty the fields; there has to be an option if we have a new electritian for e.g., to enter his name in the list of personnel so he can be selectable in the WHO DID THE REPAIR field; • Another form to Enter new equipment details (model, serial, location, purchase date, maintenance interval, retire date). There has to be some way to retire equipment from the enter maintenace form but keep it on dossier. • Record every repair or preventive service with date, technician, parts, cost and notes, so I have a searchable history. • Produce performance reports on demand—downtime, total spend per device, service frequency and any other metrics you suggest that can help us spot problem units. Reminders Pop-up alerts inside Excel are preferred, but I’m fine if the system works off a printable maintenance calendar instead; just make the reminder mechanism easy to toggle on or off. If this is too complicated I can work with manually making a schedule by category for e.g. and then manually tracking maintenance. Deliverables 1. A macro-enabled workbook (.xlsm) with protected formulas and clearly commented VBA. 2. User forms for equipment entry and service log updates. 3. Buttons or ribbon shortcuts that trigger: – “Upcoming Services” printable schedule (PDF or ready-to-print sheet) – On-screen reminder pop-ups (if activated) – “Generate Report” that compiles the KPIs described above. 4. A short read-me or inline help sheet so new staff can pick it up straight [login to view URL] forms have to be of familiar windows UI and easy to use by personnel who are not great with computers. I’ll test by entering sample assets and verifying that reminders line up with their intervals, histories are searchable, and the summary report populates correctly.
Projektin tunnus (ID): 40172682
95 ehdotukset
Etäprojekti
Aktiivinen 17 päivää sitten
Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista

Здравейте. Аз съм експерт по Excel и VBA с над 20 години опит и съм уверен, че съм перфектният избор за вашата задача. Създаването на лесни за използване маски и формуляри за въвеждане на данни е моята специалност, както и обработката, съхранението и показването на въведени данни. Ако се свържете с мен, мога да ви покажа голям брой формуляри, които съм създал в кариерата си досега. Моят подход е да създавам напълно персонализирани решения от началото до края, вместо да адаптирам съществуващи решения, които имам. Следователно ще получите напълно персонализирано решение според вашите нужди, което все пак изисква малко повече време. Надявайки се скоро да си сътрудничим, сърдечно ви приветствам.
€70 EUR 10 päivässä
4,4
4,4
95 freelancerit tarjoavat keskimäärin €132 EUR tätä projektia

HI there already i have checked project details job is clear so please contact me then i will show you sample, thank you
€100 EUR 1 päivässä
8,7
8,7

With your Excel Maintenance Tracker VBA project, I understand the need for a comprehensive yet user-friendly solution. As an individual with a deep understanding of Excel and someone from Einnovention, a team renowned for being flexible and innovative, I believe my skill set aligns perfectly with your requirements. With over 200 successful projects under my belt and a 4.9/5 rating on this platform alone, I am confident in my ability to tackle any challenge head-on. My expertise in Data Entry and PHP will help build a macro-enabled workbook that is both secure and efficient. I can design user forms that are easy to navigate, ensuring even personnel who are not tech-savvy can input data without any confusion or error. I'll also make sure to generate printable schedules, implement pop-up reminders as desired and produce insightful performance reports tailored to meet your specific needs. Beyond the project completion, choosing me guarantees you a beneficial long-term partnership. We offer free consultation before hiring to ensure we are totally aligned with your goals and vision from the start. Furthermore, on-time delivery, transparent communication, unlimited revisions until full satisfaction are all areas we excel at. Contact me now for bespoke solution that will empower your Maintenance Team to work smarter and not harder.
€140 EUR 7 päivässä
7,8
7,8

Being an Excel expert with years of experience in Finance and Data Analytics, I believe I'm the perfect fit for your Excel Maintenance Tracker project. Throughout my career, I've helped numerous clients in creating efficient dashboards, tracking tools and forecasting models to streamline their operations and I can do the same for you. The core workflow you described resonates with my skills and abilities. My proficiency in VBA allows me to create user-friendly forms, such as the ones you need. Moreover, being familiar with both IFRS and US GAAP, I understand the significance of maintaining detailed records of every repair or preventive service performed. I will meticulously build a system that captures all necessary data points (date, technician, parts etc.) while still generating summary reports that highlight important Key Performance Indicators like downtime and total spend per device. Additionally, my commitment to client satisfaction doesn't end after the contract is fulfilled. As a bonus offered exclusively by me, I provide free demos and continuous support even after the project concludes. Give me this chance to show my value to you and feel free to message me to discuss your project further. Let's build this amazing maintenance tracker together
€40 EUR 1 päivässä
7,6
7,6

Hello I have thoroughly reviewed your project description and am confident in my ability to assist you in completing it successfully. I believe it would be highly beneficial to delve deeper into the specifics of the job to determine the most effective way forward. I am open to scheduling an interview at your convenience, and I genuinely appreciate the chance to collaborate with you on this project. Your response is eagerly anticipated, and I'm excited about the prospect of working together. Thank you for considering my proposal. Looking forward to your prompt reply! Best regards Rekha!!!
€250 EUR 7 päivässä
7,8
7,8

Hi Lachezar, Thank you for considering my proposal. With over 8 years of hands-on experience in Excel and VBA, I am confident in my ability to assist you with your Excel Maintenance Tracker project. I have carefully reviewed your requirements and believe I can provide you with a user-friendly solution that streamlines your maintenance tracking process. I would like to connect with you in chat to discuss your project further and ensure that I fully understand your needs. Regards.
€30 EUR 1 päivässä
6,8
6,8

Hi, I’m excited about the opportunity to create a comprehensive Excel Maintenance Tracker for your team. With my expertise in Excel VBA and a solid understanding of user-friendly interfaces, I can develop a single-workbook solution that meets all your tracking needs. I will design intuitive forms that streamline the process of asset management, allowing users to easily log repairs, update statuses, and input new equipment details without the need to access raw sheets. The system will include essential features like searchable repair histories, on-demand performance reports, and a toggle mechanism for reminders. You can expect a macro-enabled workbook with well-protected formulas, clear comments in the VBA code, and helpful resources for new staff. I’ll ensure the testing phase is thorough by entering sample assets and validating all functionalities. Let’s aim for a 14-day delivery so you can start benefiting from this tool quickly.
€250 EUR 14 päivässä
6,6
6,6

Greetings, It sounds like you're looking for a comprehensive Excel solution to manage maintenance across your facilities. I can help create a user-friendly workbook that utilizes VBA and forms, allowing your team to log repairs, add new equipment, and track maintenance effortlessly. I plan to design intuitive forms that guide users through the process, ensuring they can easily select locations and equipment, record details, and generate reports. Additionally, I'll implement reminder mechanisms that suit your preference, whether that's pop-up alerts or a printable schedule. With my experience in Excel VBA and data management, I’m confident I can deliver a solution that meets your needs while being easy for your team to navigate. Best regards, Saba Ehsan
€200 EUR 3 päivässä
6,4
6,4

I'm a Certified Excel VBA Programmer,,,,,, I can create an easy-to-use VBA workbook with forms to log repairs, track equipment, and generate reports with reminders. Your team will be able to enter data, view history, and run reports without touching raw sheets.
€50 EUR 2 päivässä
6,5
6,5

Hello, I can deliver a clean, VBA-driven Excel workbook with easy-to-use Windows-style forms that let your team add equipment, log repairs or maintenance, and track full service history without touching raw sheets. The system will use smart dropdowns (location → category → equipment), support new personnel entries, handle asset retirement, and generate clear reports on downtime, costs, and service frequency, with optional reminders or printable schedules. You’ll get a protected, well-documented .xlsm file that’s simple for staff to use and powerful enough to keep all facilities’ maintenance fully under control. Regards, Zafar
€100 EUR 1 päivässä
6,3
6,3

Hello, I understand you’re looking for a single Excel .xlsm maintenance tracker driven by VBA UserForms so your team can add assets, log repairs/PMs, retire equipment, and generate KPI reports without touching raw sheets. I build Windows-style VBA interfaces with cascading dropdowns (Location → Category → Equipment), protected backend tables, and clearly commented code for long-term support. I will structure the workbook into clean tables: Locations, Categories, Assets, Personnel, and ServiceLogs. The “Enter Repair/Maintenance” form will capture date, type (repair/maintenance), technician, parts/cost, validator, notes, and will auto-filter equipment lists based on selections. A second “New Equipment” form will record model/serial, purchase date, interval, and retirement date; retired assets will stay in history but be hidden from active selection unless toggled. For reminders, I can implement optional in-Excel pop-up alerts on open and a printable “Upcoming Services” schedule, plus a “Generate Report” button producing downtime, spend per device, service frequency, repeat-fault flags, and top problem units. You’ll receive a protected, user-friendly workbook with buttons, documentation, and maintainable VBA that your staff can operate confidently. Thanks Asif.
€250 EUR 3 päivässä
6,3
6,3

Hi, I can build a single Excel (.xlsm) maintenance system driven by VBA and easy-to-use Windows-style forms so your team can log assets, repairs, and maintenance without touching raw sheets. It will handle location-based filtering (site → category → equipment), full service history, equipment retirement, personnel lists, and on-demand reports like downtime, spend, and service frequency. The file will also support optional reminders (pop-ups or printable schedules), with protected formulas, clearly commented VBA, and simple buttons for reports and schedules. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Best Regards, Virendra
€90 EUR 3 päivässä
6,2
6,2

Hello, I have carefully reviewed your project details and understand that you need a comprehensive, user-friendly Excel solution to manage equipment maintenance and repairs across multiple facilities. I bring strong experience in developing macro-enabled workbooks with custom VBA forms, automated reporting, and interactive dashboards, and I can confidently deliver a solution that combines ease of use with full operational tracking for your team. I will start by designing the equipment database and creating forms to enter new assets, record maintenance or repairs, and manage personnel dynamically. The forms will include cascading dropdowns for locations, categories, and equipment, and all entries will be automatically logged with details including date, technician, cost, and notes. I will implement reporting features to track KPIs such as downtime, total spend, and service frequency, as well as optional pop-up reminders and printable maintenance schedules. VBA will ensure protected formulas and a seamless workflow for non-technical users. I am ready to begin. Would you like the maintenance tracking system to also include automated alerts for upcoming preventive services? Best Regards, Aneesa.
€150 EUR 1 päivässä
6,1
6,1

Hello Lachezar, I am a proficient Excel VBA expert with extensive experience in data management and Excel macros. I understand your need for a comprehensive Excel Maintenance Tracker driven by VBA for your company's various locations and equipment. My approach involves creating user-friendly forms for easy asset addition, repair logging, and status updates, ensuring seamless data entry for all team members. I will deliver a macro-enabled workbook with protected formulas, clearly commented VBA code, and intuitive user forms. The solution will include features like equipment entry forms, service log updates, printable maintenance schedules, reminder pop-ups, and performance reports. I guarantee reliable delivery, clear communication, and a solution tailored to your specific requirements. I invite you to discuss further and explore how I can assist in optimizing your maintenance tracking process. Best regards,
€30 EUR 7 päivässä
5,8
5,8

Hi there,Good afternoon I am Talha. I can work with your project skills Excel, Excel Macros, Data Entry, Visual Basic, Data Management, Visual Basic for Apps, Excel VBA and PHP I am excited to present my proposal, which centers around a personalized approach designed to elevate your project. We will start with an in-depth consultation to gain a deep understanding of your project's unique requirements, goals, and constraints. Our commitment to customization means that we will tailor our services to align perfectly with your project, and we will explain how this approach will meet your expectations. Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Thanks Regards. Talha Ramzan
€30 EUR 14 päivässä
5,5
5,5

Hi there, I can build this as a single, clean Excel .xlsm solution driven entirely by VBA and user-friendly Windows-style forms. The focus will be ease of use for non-technical staff: guided dropdowns, filtered selections (location → category → equipment), clear buttons, and zero interaction with raw data sheets. All logic, validation, and workflows will sit behind the forms. I’ll design two core forms: one for logging repairs/maintenance with cascading filters, personnel management, costs, notes, validation, and equipment retirement (kept in history), and another for adding/editing equipment with full lifecycle tracking. Every action will be logged to structured tables so histories remain searchable and reliable. On top of that, I’ll include VBA-driven reports and reminders: printable maintenance schedules, optional in-Excel pop-up alerts, and KPI reports covering downtime, spend per asset, service frequency, and repeat-failure indicators. The workbook will have protected formulas, clearly commented VBA, buttons/ribbon shortcuts, and a short help sheet so new staff can get productive immediately. Regards, Avinash
€60 EUR 4 päivässä
5,5
5,5

Hi Lachezar D., I can build the single-workbook Excel (.xlsm) you describe with VBA user forms so staff can add assets, log repairs, and update status without opening raw sheets. Forms will filter location to category to equipment, allow new technician entry, record repairs (date, tech, parts, cost, notes), and retire equipment while keeping its record. I will add printable schedules, optional pop-up reminders, and a Generate Report button for downtime, spend per device and service frequency. The file will have protected formulas, clear VBA comments, and a short read-me so new staff can use it quickly. I have strong Excel VBA and form design experience. Please let me know if reminders should follow fixed dates or maintenance intervals. Best regards, Saad J.
€150 EUR 3 päivässä
5,3
5,3

Hello Lachezar D., I am Maryam Abbas, a PHP developer with 4 years of experience. I have carefully read the requirements for the Excel Maintenance Tracker VBA project. I propose to create a user-friendly Excel workbook driven by VBA, featuring forms for easy asset entry, repair logging, and status updates. The core workflow will include forms for entering repairs, adding new equipment details, and recording maintenance history. I will also implement reminders and performance reports to enhance tracking and analysis. My extensive experience with various technologies ensures a successful project delivery. You can review my portfolio at https://www.freelancer.pk/u/maryam951 Let's discuss further details in chat. Best regards, Maryam Abbas
€30 EUR 5 päivässä
4,9
4,9

Hello, I can build a single, macro-enabled Excel workbook that your whole team can use through familiar Windows-style VBA forms, with no one needing to touch raw sheets. I’ll structure it around a clean asset register and a service/repair log, then implement the “Enter Repair or Maintenance” form exactly as you described with cascading dropdowns (Location → Category → Equipment), separate fields for repair vs. preventive maintenance, notes, technician, cost, and validation/acceptance, plus an admin-friendly way to add new personnel so names appear instantly in the right fields. I’ll also deliver a second form for adding and managing equipment (model/serial, purchase date, interval, retire date), including a “retire” workflow that removes an asset from day-to-day selection while preserving its full dossier and history for reporting. On top of that, I’ll add one-click buttons to generate an upcoming-services printable schedule, optional on-screen reminder popups that can be toggled on/off, and a report generator that compiles downtime, total spend per asset, service frequency, repeat-issue flags, and other practical KPIs to help you spot problem units early. The workbook will be protected where appropriate, VBA will be clearly commented, and I’ll include a short read-me/help sheet so new staff can start using it immediately. Best regards, Juan
€140 EUR 1 päivässä
4,9
4,9

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev
€50 EUR 2 päivässä
4,9
4,9

I have done a similar project last month. I am interested to work in this project too. Kindly give me the job. Go through my client reviews
€50 EUR 1 päivässä
5,0
5,0

Sandanski, Bulgaria
Maksutapa vahvistettu
Liittynyt huhtik. 23, 2021
€8-30 EUR
€8-30 EUR
$15-25 USD/ tunnissa
$10-75 USD/ tunnissa
$2-8 USD/ tunnissa
₹600-1500 INR
₹600-1500 INR
₹750-1250 INR/ tunnissa
$250-750 USD
₹12500-37500 INR
$30-250 AUD
₹100-400 INR/ tunnissa
£250-750 GBP
$250-750 AUD
₹2000-6000 INR
₹750-1250 INR/ tunnissa
₹2500-5000 INR
€30-250 EUR
₹100-400 INR/ tunnissa
$450-500 USD
₹12500-37500 INR
₹750-1250 INR/ tunnissa