
Closed
Posted
Paid on delivery
I need an expert Excel VBA developer to create a specific 4-sheet calculation system based on my ship's calibration tables. Here is the exact structure and requirements for the 4 sheets: 1. Sheet "DAILY_READINGS_LO" (Lubricating Oil Inputs): - Dedicated input dashboard to enter soundings/values ONLY for Lubricating Oil (LO) Tanks. - CRITICAL REQUIREMENT: For LO tanks that DO NOT have calibration tables in the PDF, you must create a dedicated manual input cell so I can type the volume directly. 2. Sheet "DAILY_READINGS_MISC" (Miscellaneous Tanks Inputs): - Dedicated input dashboard to enter soundings/values ONLY for Miscellaneous Tanks (excluding Ballast). 3. Sheet "CALCULATIONS_LO" (LO Calculations & Visuals): - Performs automated calculations ONLY for Lubricating Oil (LO) Tanks. - MATHEMATICS: VBA code must perform Linear Interpolation using calibration tables based on Soundings, fully incorporating Trim and Heel corrections. - DYNAMIC VISUAL GAUGING: Includes virtual tanks (stylized cell blocks) showing filling percentage. The color must dynamically change based on volume % (Green -> Yellow -> Red) and display the exact capacity %. 4. Sheet "CALCULATIONS_MISC" (Miscellaneous Calculations & Visuals): - Performs automated calculations ONLY for Miscellaneous Tanks. - MATHEMATICS: VBA code must perform Linear Interpolation using calibration tables based on Soundings, fully incorporating Trim and Heel corrections. - DYNAMIC VISUAL GAUGING: Includes virtual tanks (stylized cell blocks) showing filling percentage. The color must dynamically change based on volume % (Green -> Yellow -> Red) and display the exact capacity %. I will provide the excell calibration tables and my reference Excel file immediately to the selected freelancer. Please only bid if you can deliver a clean, working .xlsm file.
Project ID: 40466661
33 proposals
Remote project
Active 3 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs