
Open
Posted
•
Ends in 16 hours
Paid on delivery
I have an older bunker survey workbook that no longer meets our needs for a newly delivered vessel. Rather than patching what exists, I’d like a clean Excel-VBA rebuild that uses my latest bunker survey form report and the ship’s calibration tables as the data backbone. excell must include in separate sheet all the other tanks in calibration tables except ballast and slop tanks you can see the attached documents Core objectives • Automate every calculation now done by hand so totals, variances, ROB and consumption figures update instantly when fresh tank soundings are entered. • Produce the same general reports my crew is accustomed to—daily summary, noon report extract, and charterer-ready bunker statement—at the click of one button. • Embed solid data validation throughout: – Input data from users (e.g., manual soundings, temperature, density) – Imported data from external sources (CSV / sensor logs) – Calculated data within the report (cross-checks versus calibration tables) What I will supply • a excell VBA project for reference • PDF calibration tables for tanks • Acceptance criteria 1. A single macro-enabled workbook (.xlsm) with clearly named modules and no hard-coded file paths. 2. Button-driven workflow that runs without runtime errors on Office 2016 and 365. 3. Built-in checks that flag out-of-range densities, negative consumptions, or missing tank data before a report can be saved. 4. Output reports match the format of the sample documents I provide, ready for print or PDF export. Once the tool passes a short onboard test, I’ll mark the job complete and release final payment.
Project ID: 40466140
40 proposals
Open for bidding
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $140 USD for this job

Warm greetings! I specialize in Excel VBA automation and structured data-processing systems with 9+ years of experience rebuilding operational workbooks for reporting, validation, and calculation-heavy workflows. Here's how I can help: * Rebuild your bunker survey workbook as a clean, modular .xlsm solution using latest survey forms and calibration tables * Automate ROB, consumption, variance, and tank calculations with instant recalculation logic * Create button-driven reporting for daily summary, noon extract, and charterer-ready bunker statements * Implement strong validation rules for user inputs, imported CSV/sensor data, and calculation cross-checks * Structure calibration tables in dedicated sheets including all non-ballast/slop tanks as requested I focus on stable VBA architecture with clearly named modules, Office 2016/365 compatibility, and maintainable code—without fragile hard-coded dependencies. Do your calibration PDFs follow a consistent table structure, or will OCR/manual normalization also be needed during integration?
$140 USD in 7 days
7.3
7.3

Dear Sir, I can start to work immediately. INBOX ME I have just read your project description and I can help you with my experiences. I am able to work in your time zone. I did this kind of project before. I am interested in your project. I'm professional Microsoft Excel Visual Basic expert with 5 years’ experience; I have completed over 100+ Excel VBA, Excel Macro projects for my company. EXPERTISE: Visual Basic, Excel VBA, Excel Macro, Excel Formula, Google Sheets, Automate etc. I am highly confident about that. I can do this work with accuracy. Also, I make sure to give 100% quality and commitment to work. If you like me for this project then I would love to hear from you. Don't hesitate to give me a shout or ask me a question if you have any :) Please kindly drop me a message for further discussion. Thanks Habibullah B
$175 USD in 3 days
7.3
7.3

Hi there, I understand you need a complete Excel-VBA rebuild of your bunker survey workbook for a newly delivered vessel, using updated bunker survey forms and calibration tables as the foundation rather than modifying the older system. My approach will be to rebuild the workbook architecture from scratch using modular VBA, structured calculation sheets, and separate calibration-table repositories for all applicable tanks except ballast and slop tanks as requested. I will automate ROB, consumption, variance, density correction, and reporting calculations so updates occur instantly when new soundings or imported CSV data are entered. Strong validation rules will be implemented to detect missing tank data, negative consumption values, out-of-range densities, and inconsistencies against calibration tables before reports can be finalized. The workbook will also generate daily summaries, noon report extracts, and charterer-ready bunker statements through a single-click workflow compatible with Office 2016 and Microsoft 365. The deliverable will include the fully commented macro-enabled workbook, organized VBA modules, integrated validation checks, printable report outputs, and setup guidance for onboard operation. Are the calibration tables already digitized in Excel format, or will they need to be extracted and structured from PDF documents first? I’m ready to start immediately. Warm Regards, Aneesa.
$100 USD in 1 day
7.0
7.0

Hi, I understand you need a complete rebuild of your bunker survey workbook into a clean, reliable Excel-VBA system tailored to the new vessel and updated calibration tables — not just another patch on the old file. I can develop a structured .xlsm solution with automated ROB, consumption, variance, and reporting calculations, plus strong validation checks for manual entries, imported data, and calibration consistency. The workbook will include organized VBA modules, button-driven workflows, dynamic tank handling, and separate calibration sheets for all required tanks except ballast and slop tanks. The final tool will be stable on both Office 2016 and 365, fully print/PDF ready, and designed for smooth onboard operational use without runtime issues. Ready to review the existing VBA project and sample reports and start the rebuild immediately. Usman Bashir
$220 USD in 2 days
6.7
6.7

Hi there, We can rebuild this as a clean Excel VBA workbook that uses the latest bunker survey form and calibration tables as the data backbone. We will structure the workbook with clearly named modules, remove hard-coded paths, and automate the sounding, ROB, variance, and consumption calculations so the reports update from entered or imported data. We will also include validation for missing tank data, negative consumption, and out-of-range density values, plus button-driven outputs for the daily summary, noon extract, and charterer bunker statement in the formats you supply. We will align the tank sheet to include the required calibration-table tanks while excluding ballast and slop tanks, and we will test the workbook for Office 2016 and 365 compatibility before handover. Best Regards, 8veer
$250 USD in 10 days
6.4
6.4

As a highly specialized and experienced professional in Python VBA and automation solutions, I am uniquely qualified to revolutionize your bunker survey process. With over 13 years of proven results in developing tailored python solutions, I have an incredible track record of delivering efficient and precise tools for clients worldwide. I am confident I can automate every calculation you currently perform by hand - seamlessly integrating your latest bunk survey form report and the ship’s calibration tables in Excel VBA. Imagine the ease and peace-of-mind that comes with instantly updated totals, variances, ROB, and consumption figures as fresh tank soundings are entered. Moreover, my built-in checks will flag any out-of-range densities, negative consumptions, or missing tank data before a report can be saved - assuring you're always working with valid data. Being an expert in Python Web Automation & Data Mining/Extraction, AI Solutions & Full-Stack Development, I have ample experience completing projects that require dealing with large-scale data inputs like those from CSV/sensor logs as indicated in your project's core objectives. Furthermore, my skills are not limited to coding; they also transcend into understanding clients' needs deeply and building solutions accordingly. To cap it off, your acceptance criteria fall right within my purview; so let me bring my proficiency to bear on enhancing your own operations!
$40 USD in 1 day
6.8
6.8

Hello, I am an experienced Excel‑VBA developer with marine bunker and tank calibration expertise. I will build a clean, button‑driven workbook using your survey form and calibration tables (excluding ballast/slop tanks) to instantly calculate totals, ROB, and consumption from fresh soundings. I will add data validation for user inputs and imported data, flagging out‑of‑range values or missing tank data. One click will produce daily summary, noon report, and charterer‑ready bunker statement, matching your existing formats. Deliverable: a .xlsm with no hard‑coded paths, compatible with Office 2016/365. Ready to start once you share your reference project, calibration PDFs, and sample reports. Regards, Zafar
$125 USD in 1 day
6.2
6.2

With my extensive professional experience designing, creating, and editing Excel documents, combined with my passion for automating processes to enhance efficiency and accuracy, I am the ideal candidate for your project. Over the past 10 years, specializing in VBA and Macro development, I have proven myself adept at streamlining intricate tasks to ensure that time-consuming manual calculations are minimized or eliminated. Importantly, my expertise includes ensuring data integrity through robust validation checks. For example, I can establish a system that flags out-of-range densities, negative consumptions and missing tank data before generating reports. Not only will this prevent any potential errors but it will also save significant time and effort eliminating the need to manually review each entry. You can count on me to deliver a reliable macro-enabled excel workbook which runs smoothly not just for Office 2016 and 365 users but also without dependency on hard-coded file paths. This ensures future compatibility and ease of maintenance. I totally understand the critical importance of accuracy in bunker surveys as any errors might have significant financial implications for your company. Rest assured, I have a meticulous eye for detail which coupled with my problem-solving skills will guarantee precise results that match your sample documents ready for print or PDF export. Let me help you exceed your expectations!
$200 USD in 3 days
6.4
6.4

Hi, ★★★ Excel Expert ★★★ 4+ Years of Experience ★★★ I can rebuild your bunker survey workbook using your latest forms and calibration tables to automate calculations and generate reports. This will include: - A macro-enabled workbook with clearly named modules. - A button-driven workflow for seamless operation. - Built-in checks for data validation. - Output reports matching your provided formats. I will follow a structured approach to ensure all calculations are automated and reports are generated efficiently. I will utilize Excel VBA to create the necessary macros and ensure compatibility with Office 2016 and 365. Ready to start once you provide the reference project and calibration tables. Thanks!
$210 USD in 5 days
5.6
5.6

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
$120 USD in 2 days
5.3
5.3

I just read your project carefully a few seconds ago. I just have a small question before starting — can we discuss it quickly in chat? I’m experienced with Visual Basic, VB.NET, Automation, Excel VBA, Data Processing, Office 365, Excel Macros, Data Integration, Data Analysis and Excel . Ready to start once I get your answer!
$180 USD in 1 day
5.3
5.3

Excel, VBA professional developer, I cheked the requiremnts details and ready to do the required. Regards. Relevant experience and sample reference works and clients' reviews in links below. https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews
$250 USD in 3 days
5.3
5.3

Hi There! I Understand the value of accurate and efficient data entry. My expertise in Data Processing, ⛔Data-Entry⛔Excel⛔VBA-Macro⛔Power-BI & Accountant⛔PDF⛔ MS⛔Visual Basic⛔Data Processing⛔Excel⛔Excel VBA⛔Excel Macros will surely prove useful for this project. I have an excellent command over Power BI and can help you extract your data exactly the way you see it on the platform. In line with your goal to download the Excel file with utmost precision, I can assure you that my meticulous attention to detail will ensure a flawless transfer of all your data. Choose me for this project and let's achieve your goal together! Cheers!Jalal
$30 USD in 1 day
4.7
4.7

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I deliver robust, efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via the Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, pivot tables, Power Query, mail merge, email via Outlook and Gmail, add-ins, customized macros, and automated repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
$100 USD in 1 day
4.5
4.5

Hello, I have experience working with advanced Excel VBA automation, data processing workflows, and custom reporting systems. I can help revamp and optimize your Vessel Bunker Survey VBA solution for better performance, accuracy, and usability. I can assist with: • Refactoring and improving existing VBA code • Automating bunker survey calculations and reporting • Optimizing Excel forms, macros, and workflows • Improving stability, speed, and error handling • Cleaning up data structures and report generation • Creating a more user-friendly and maintainable system I understand the importance of precision and reliability in bunker survey operations and can deliver a structured, efficient, and scalable VBA solution tailored to your workflow.
$30 USD in 1 day
3.9
3.9

I understand you need a robust VBA solution to automate your bunker survey calculations, similar to how I've previously built dynamic reporting tools that instantly update based on user input, eliminating manual errors and saving significant time. My approach will involve a clean VBA rebuild within Excel. I'll leverage your new bunker survey form and ship's calibration tables directly. Using ADO or Power Query to efficiently import and manage the calibration data, I'll create dedicated VBA functions for all calculations (totals, variances, ROB, consumption). All tanks from the calibration tables, excluding ballast and slop, will be presented on a separate sheet for easy reference and validation. The core workbook will focus on the survey data entry, with instant calculation updates triggered by user input. Have you considered how you'd like to handle potential data discrepancies between the survey form and calibration tables during the rebuild? I’m keen to discuss your specific workflow and finalize the exact calculation logic. Would you be available for a brief call sometime this week to explore this further?
$200 USD in 21 days
4.0
4.0

Hi, Asad from Divulgetechnologies here, an experienced full-stack engineer with specialized skills in data integration, data processing, and Visual Basic. I have spent more than 15 years devising innovative technical solutions for complex projects just like yours. I'm confident that my skill set perfectly aligns with the Vessel Bunker Survey VBA Revamp as presented in the project description. Your specific objectives of automating calculations, generating familiar reports, and implementing robust data validation are exactly what I execute best. I've developed numerous Excel-VBA automation tools in the past that have immensely simplified data-heavy tasks and produced accurate reports with a single click. My proficiency in VB.NET provides me a deep understanding of how to code macros effortlessly while avoiding any runtime errors in multiple Office environments. Furthermore, I truly understand your requirements for solid validation checks throughout the entire workflow, to prevent any discrepancies or inaccuracies before reporting. This resonates with my commitment to deliver reliable, scalable, and error-free solutions. I not only code but also focus on comprehensive documentation, thus making sure that every aspect of my solution is profoundly understood by its users - contributing to hassle-free post-implementation support. Selecnting me would ensure your project completion (including full docking and testing) within the timef Thanks!
$75 USD in 3 days
3.8
3.8

Hi there, Manual lookups from calibration tables are slow and error-prone. One wrong interpolation can throw off your ROB and consumption figures. I will build a clean VBA engine that pulls volume directly from your tank tables (excluding ballast and slop) and updates all totals, variances, and reports instantly when soundings are entered. I have two quick questions to make sure we're on the same page: 1. Do your calibration tables list volume against sounding depth in cm or mm, and do you need linear interpolation between entries? 2. Should the CSV/sensor log import overwrite manual entries or flag conflicts for review? Let's discuss your project now!
$150 USD in 5 days
3.5
3.5

✨ I can rebuild your bunker survey workbook as a clean Excel VBA tool instead of just patching the old file. I would use your latest bunker survey form, current VBA workbook, and PDF calibration tables as the base, then create a single macro enabled workbook with separate sheets for the required tank calibration data, excluding ballast and slop tanks as requested. The workflow would let crew enter fresh soundings, temperature, density, and imported data, then automatically calculate ROB, consumption, totals, variances, and cross checks against the calibration tables. I will also add validation to catch missing tank data, out of range density, negative consumption, and inconsistent imported values before reports are saved. The daily summary, noon report extract, and charterer ready bunker statement can be generated with one button and prepared for print or PDF export. Please share the current workbook, sample reports, and calibration PDFs, and I can review the structure first so the rebuilt version matches your onboard workflow clearly. Best regards Ankit
$50 USD in 1 day
3.1
3.1

I've worked on maritime Excel tools before, and this one is actually well-scoped, which means I can deliver it cleanly without scope creep surprising either of us. Here's how I'd approach it: I'll pull the calibration table data from your PDFs into a locked reference sheet, build the sounding input logic on top of that, and wire up auto-calculations for ROB, consumption, and variance. No manual cross-checks. If a number changes, everything downstream updates immediately. For reports, I'll match your existing formats exactly: daily summary, noon report, bunker statement, all PDF-exportable with one button. I'll also build validation that stops bad data before it ever reaches a report. Out-of-range densities, negative consumption figures, missing soundings will all be flagged clearly so your crew knows exactly what to fix. Other tanks from the calibration tables (excluding ballast and slop) will get their own dedicated sheet as you mentioned. The workbook will run clean on both Office 2016 and 365, with named modules and no hard-coded paths. Happy to share a sample of previous maritime Excel work if that helps. A couple of quick questions before I start: 1. How many tanks total are in the calibration tables? 2. Do you want the CSV import to handle sensor logs, manual entry, or both?
$185 USD in 5 days
2.4
2.4

Yeongam, Greece
Payment method verified
Member since May 24, 2026
$30-250 USD
₹100-400 INR / hour
₹750-1250 INR / hour
$30-250 AUD
₹750-1250 INR / hour
₹600-1500 INR
₹750-1250 INR / hour
$15-25 USD / hour
$10-50 USD
$30-250 USD
₹12500-37500 INR
$15-25 USD / hour
£5-10 GBP / hour
₹12500-37500 INR
£18-36 GBP / hour
₹12500-37500 INR
$250-750 AUD
$30-250 SGD
$10-30 USD
$750-1500 AUD
₹1500-12500 INR