
Completed
Posted
Paid on delivery
I need a proficient Excel VBA coder to develop a script that evaluates my downtime tracking Excel sheet against my log sheet. The code should primarily check for: - Incorrect downtime minutes - Mismatched dates - Misplaced well names The script is not meant to correct these errors but to flag them for manual review. Errors that are particularly significant or common include: - Any downtime noted in the log as FBU or RWO, which I will handle manually - Any remarks marked with FPS, which should be calculated as zero - Any remarks marked with KOC, which should be calculated at 50% - the ticket have excel have several sheets in which the time should be checked in the any sheet begin with MTS i can't share the full ticket as it's secret The VBA code should strike a balance between speed and accuracy. It should not only be quick, but also precise enough to catch every inconsistency. Previous experience with Excel and VBA is a must, along with a keen eye for detail and ability to understand and interpret complex instructions.
Project ID: 39231219
17 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $140 USD for this job

As you are in need of a proficient Excel VBA coder to develop a downtime tracking script, I am confident that my 7 years of experience in full-stack development with specialization in Web Scraping, Automation and VBA make me the perfect fit. I have executed numerous VBA projects with top companies like Metlife GOSC, DXC Technologies, and Elite Services – guaranteeing efficient, accurate and reliable work. Bringing a keen eye for detail and an ability to understand and interpret complex instructions is where I excel. I'm more than capable of sorting out your Excel issue with speed and precision ensuring every inconsistency is flagged as you need. My dedication to delivering quality work is evident from my commitment to providing free 4-day support for any issues faced post-delivery. Having worked on diverse projects over the years, my skill set extends beyond just data processing. This versatile skill set allows me to propose time-efficient ways of executing tasks. I also promise fair charges, assuring maximum value for your investment. Let's collaborate for timely delivery, quality assurance, and a long-term project relationship you won't regret! Choose me today!
$30 USD in 3 days
8.7
8.7

Hi, I’ll develop a precise and efficient VBA script to flag inconsistencies in your downtime tracking sheet. With 9+ years of experience in Excel automation, I ensure speed and accuracy in error detection. Here's how I can help: ● Identify incorrect downtime minutes, mismatched dates, and misplaced well names ● Flag FBU/RWO entries for manual review, handle FPS (0) and KOC (50%) correctly ● Scan all relevant MTS sheets while maintaining high processing efficiency Do you need a summary report of flagged issues, or should they be highlighted directly in the sheet? Let’s refine the approach to fit your workflow.
$140 USD in 2 days
7.2
7.2

Hi There! I have understood the requirements for the task. I have 8+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -Python -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks Anjali
$200 USD in 3 days
5.9
5.9

Hi, I can build a fast and accurate VBA script to validate your downtime tracking sheet against the log sheet. ✅ Key features: Flag incorrect downtime, mismatched dates, and misplaced well names. Special handling for FBU, RWO, FPS (0 mins), and KOC (50%). Cross-check across all MTS sheets without needing full access to the ticket. Why me? Proven Excel VBA expertise — speed and precision balanced. Experience handling complex, structured data checks. Let’s get this done smoothly! Best,
$140 USD in 1 day
5.7
5.7

Hello there, I work full time on freelancer and the skills Software Architecture, Visual Basic, Visual Basic for Apps, Excel and Data Processing u mentioned on the project fall under my level of expertise so i can surely help u with it. Please have a look at my profile: https://www.freelancer.com/u/ayesha0124 Looking forward to ur response and discuss in detail. Ayesha
$250 USD in 8 days
5.2
5.2

hello there, i am a senior software developer and i can do it as required and on time with high quality. regards,
$200 USD in 3 days
5.3
5.3

Hi there! I understand you need a proficient VBA coder to help you create a script for your downtime tracking Excel sheet. With my extensive Excel and VBA experience, I'm confident I can develop a fast yet accurate script that flags any mismatches or inconsistencies based on your specific criteria, ready for your manual review. I've previously worked on similar projects and understand the importance of precision in handling complex data. Let's chat for more details about your requirements.
$80 USD in 7 days
4.9
4.9

Hi Ahmed F. Good morning Already have something live to show you Live Similar Site work I have gone through your requirement , I found it very interesting , Since I already have similar live to show you As i had worked on these tech Visual Basic, Software Architecture, Visual Basic for Apps, Excel and Data Processing I can Implement is the similar or with changes for you !!!! Let us discuss more about this Thanks
$155 USD in 16 days
3.6
3.6

Greetings, I am an experienced Excel VBA developer with a strong background in automating data validation and error detection. I can create a robust VBA script that efficiently evaluates your downtime tracking sheet against your log sheet, flagging discrepancies such as: Incorrect downtime minutes Mismatched dates Misplaced well names The script will be optimized for speed and accuracy, ensuring that: Downtime noted as FBU or RWO is flagged for manual handling Remarks marked as FPS are calculated as zero Remarks marked as KOC are calculated at 50% Time tracking is checked across all relevant sheets (beginning with MTS) I understand the importance of precision in this task and will ensure that every inconsistency is identified without altering your original data. Let’s discuss how I can tailor the solution to fit your workflow.
$140 USD in 7 days
2.4
2.4

⭐⭐⭐⭐⭐ Dear client, I have thoroughly reviewed your job posting and am confident in my ability to develop an Excel VBA script that will efficiently flag errors in your downtime tracking and log sheets. With my extensive experience in Excel VBA coding and data analysis, I can deliver a precise, quick solution to meet your requirements. With 8+ years of experience in Excel VBA development, I have worked on similar tasks where I identified errors such as incorrect time calculations, mismatched dates, and misplaced data entries. I will develop a script that checks for specific errors, like identifying remarks marked as FPS and KOC and flagging entries that need manual review, while ensuring all checks are done across the sheets starting with MTS. To carry out this project, I will create a script that systematically evaluates your data, quickly identifies inconsistencies, and flags them for review. I will ensure the script performs efficiently without compromising accuracy, adhering to your specific requirements. I am ready to work with you to ensure the flawless execution of this Excel VBA script, and I will ensure that it meets your expectations. Best regards, Pavlo
$40 USD in 7 days
1.1
1.1

Kuwait City, Kuwait
Payment method verified
Member since Mar 22, 2025
$10-30 USD
₹12500-37500 INR
$100 NZD
₹600-1500 INR
₹37500-75000 INR
€6-12 EUR / hour
₹12500-37500 INR
min £36 GBP / hour
$10-30 USD
₹12500-37500 INR
$250-750 USD
$30-250 USD
$250-750 USD
£20-250 GBP
₹600-1500 INR
₹100-400 INR / hour
$15-25 USD / hour
₹1250-2500 INR / hour
$250-750 USD
₹400-750 INR / hour