WORK SMART! WORK WITH SMARTCALWORX PRODUCTS.
DESIGNED AND DEVELOPED BY A SEAFARER FOR THE SEAFARERS
SMARTCAL-LOAD DOWNLOAD & VERSION CHANGELOG PAGE
IMPORTANT!!!! Please EXTRACT the ZIP file before using the program
SmartCAL-Load 3.9 Changelog Released 30 November 2025 1️⃣ Security and Integrity Enhancements ✅ Integrated a code-signing certificate to authenticate the application and verify SmartCAL-Load’s code integrity. ✅ Implemented code hardening and VBA refactoring to boost performance and minimize antivirus false positives. ✅ Added a one-click Trusted Location utility to automatically include SmartCAL-Load’s folder in Excel’s trusted list and add the currently running SmartCAL-Load application to the Windows Defender Exclusion Folder, improving compatibility, startup reliability, and protection against unintended security blocks. ✅ Introduced a Home Menu auto-unblock function to enable ActiveX Controls when restricted by Excel security settings. 2️⃣ Simplified Version Update and Data Migration System ✅ Added a new automatic update and migration feature that allows users to seamlessly upgrade to the latest SmartCAL-Load version while retaining their ShipData and UserData. ✅ If the device is already registered, users no longer need to re-register the new version. 🔹 Simply click STEP 1: TRANSFER on your existing version, then STEP 2: UPDATE on the new version to migrate all data automatically. 🔹 The process eliminates the need to insert the SMARTCAL USB or use the Registration Tool again for version upgrades. ✅ This system ensures a smooth and effortless transition between versions, saving time and maintaining full registration integrity. 🔹 Purpose: To simplify version updates, automate data transfer, and reduce setup time for already registered devices. 3️⃣ User Interface and Experience Improvements ✅ Enhanced Home Menu performance by replacing dynamic references with optimized static logic for faster button response. 🔹 Added automatic touch-screen detection to disable hover effects for smoother operation on tablets and touch devices. ✅ Improved Home Menu startup layout—SmartCAL-Load now detects screen resolution automatically and adjusts the layout for full visibility. ✅ Introduced Advanced View Settings in the Home Menu, allowing users to personalize interface visibility and layout preferences. ✅ Added configurable sound effects for hover actions, creating a more immersive and futuristic user experience aligned with SmartCAL-Load’s visual theme. ✅ Added S.O.S Button for Legacy Excel Compatibility 🔹 Introduced an S.O.S (Switch Off Sequence) button that temporarily disables the Home Menu Animation to improve responsiveness in older Excel versions (e.g., Microsoft Excel 2007). 🔹 This resolves cases where animation delays caused the interface to become unresponsive, preventing users from clicking buttons or running their functions. 🔹 Once deactivated, users can seamlessly restore functionality and continue normal operations without restarting Excel. 4️⃣ Functional and Calculation Fixes ✅ Corrected logic in “Desired Draft & Trim at Disport”, ensuring accurate propagation of mid-draft trimming results into both Resultant Final Departure and Resultant Arrival Draft outputs. ✅ Fixed inconsistencies in KG/GM values and resolved Man/Auto button malfunctions in NCB Part II. ✅ Resolved Extra Tanks Summary lookup issues within the NCB module. ✅ Fixed a condition where Grains Data Sheets remained unlocked when accessed via GotoSheets (NCB, CANADA, AMSA) instead of through the Grain Home Menu. 5️⃣ Grain Data System Updates ✅ Added intuitive controls to all Grain Forms, allowing users to: 🔹 Select tank names from a dropdown list, or 🔹 Manually enter a custom tank name. This provides greater flexibility beyond predefined tanks in the Extra Tanks / COMP. & TANK BASIC DATA sheet. ✅ Upgraded CANADA Grain Forms (Simplified) with: 🔹 Updated database structure 🔹 Enhanced userform interface 🔹 Streamlined data integration for improved accuracy ✅ Introduced the new “Send and Transpose” feature for the Maximum Allowable Heeling Moment table, designed for cases where: 🔹 Displacement values are in columns (horizontal) and KG/GM values are in rows (vertical). 🔹 The Send and Transpose button automatically transposes and sends data, correctly interchanging KG/GM and Displacement positions for proper processing and display. 6️⃣ Mobile Version Enhancements ✅ Introduced Moderate & Large Trimming functionality in SmartCAL-Load Mobile, with enhanced data security and improved processing efficiency. 7️⃣ New Utility Features ✅ Added a “Repair Cell Format” tool in the Load-Disch Monitoring sheet to automatically restore original formatting after copy-paste alterations. ✅ Implemented an IntelliFix system for the Hydrostatic Table, which intelligently interprets and adjusts LCF & LCB values for alignment with SmartCAL-Load’s computational logic. ✅ Added IntelliFix for Trim & Heel Tables, which: 🔹 Corrects data arrangement and sign orientation (Trim / Heel). 🔹 Automatically inserts a Zero HEEL entry when missing. 🔹 Preserves all user data while ensuring consistent and accurate calculations. 8️⃣ System Optimization and Stability ✅ Performed comprehensive code optimization and cleanup, resulting in smoother performance and faster module response. ✅ Resolved multiple legacy bugs and inconsistencies identified in earlier SmartCAL-Load versions.
SmartCAL-Load Ver 3.8 (Beta)
(Changelog has been consolidated into Ver 3.9)
SmartCAL-Load Ver 3.7 Released 16 June 2025 🆕 New Feature: Hull Curvature Profile Replicator A powerful new tool designed to replicate your ship’s hull curvature profile—enabling highly accurate draft mark width/distance (Port–Starboard) calculations when solving for unknown drafts on one side. Key functionalities include: •Hull Curvature Database: Manage and store multiple hull curvature profiles for various vessels and configurations. •Auto-Generated Draft Mark Data: Instantly compute draft mark widths/distances at 10 cm intervals based on the replicated profile. •Real-Time Visual Representation: View a dynamic, interactive graphical reference of the hull curvature, automatically updated as data is entered. 🔧 Updated Utility: Solve for Unknown Draft at One Side This utility has been significantly enhanced to work seamlessly with the new Hull Curvature Profile Replicator. Enhancements include: •Automatic Data Lookup: Automatically retrieves draft mark width/distance values from the selected hull curvature profile. •Flexible Input Options: o“Use Expo” Checkbox: Auto-populates data using the Hull Curvature Replicator. oManual Entry: Input draft mark width/distance values directly if preferred. •Measurement Method Selection: Choose between Exponential (Expo) or Laser Rangefinder methods for interpreting input data. 📄 New Content Additions in Grain Forms •KM & GM Canada Grain Forms: Page 4 of the Assessment Section now includes KM and GM calculation forms specific to Canada Grain standards, added for your reference and compliance support. •Manual VHM Input Option (AMSA Grain Form Page 6): Users now have the option to manually select where to input all Vertical Heeling Moment (VHM) values of Partially Filled (PF) Holds to either Trimmed Ends or Untrimmed Ends. This is particularly useful when a third-party representative or AMSA Inspector prefers to enter all the VHM values to either FT or F-UT. By default, the system automatically calculates VHM values unless manually overridden. ⚙️ Performance & Stability Improvements •Optimized code for faster and smoother runtime. •Improved efficiency across core modules and routines. •Fixed various minor bugs to enhance the overall user experience. •Cleaned up typographical inconsistencies for better clarity. 🐞 Resolved Issues •Cell Comments in Demo Mode: Fixed an issue where cell comments were not displaying in Demo Mode. Comments now show properly in all user modes. •AMSA Grain Form KG Table Fix: Resolved a specific issue where the Max Allowable Heeling Moment Table was misinterpreted when tabulated as KG in AMSA Grain Forms.
SmartCAL-Load Ver 3.6 Released 01 March 2025 Major Changes and Improvements: • The new and modern-looking Home Menu offers a well-organized layout with grouped buttons for easier navigation. It includes an option to switch to the familiar legacy home menu and allows you to toggle between Dark and Light button themes to suit your lighting conditions. • New logo for consistency of the branding across the website and other products. • Fixed an issue in the previous version where the program failed to launch properly in older versions of MS Excel. • Resolved a hanging issue when closing the program. • Fixed a bug where the window bar, including the close button, disappeared in older versions of Microsoft Excel. • Fixed the error when creating a TempKey file in Registration Case 3 procedure. • Enhanced overall stability, compatibility, and calculation speed. Grain Forms Updates: • Updated the NCB Grain Forms to the latest February 2024 version. • The Legacy NCB Form can be effortlessly completed with a single click by importing data from SmartCAL-Load NCB (Automatic Forms). • Added the NCB Legacy Grain Forms (February 2024) with the ability to import data from SmartCAL-Load NCB Automatic Forms into Legacy Forms. • Introduced Extra Tanks for NCB and CANADA Grain Forms, allowing users to include all required tanks for their ship. • Revamped the entire database system for grain forms, improving data storage, retrieval, and management. Users can now rename, delete, import, and preview saved data, with built-in safeguards to prevent accidental deletions. Draft Survey & Cargo Forms Database Systems: • Improved the Draft Survey database, now featuring a preview of the survey with the ability to select specific figures for import. • The formatting of negative constant values during discharging operations has been corrected. These values are now converted to absolute values to eliminate confusion. • Added a dedicated database system for managing and saving conditions in: * Ballast Tank Sounding Forms * Deadweight Calculation Forms * Sequence Forms * Stowage Plan Forms * The All-New database system for Cargo Forms aim to improving data storage, retrieval, and management. Users can now rename, delete, import, and preview saved data, with built-in safeguards to prevent accidental deletions. • New Feature in Sounding-Forms: Users can now send and interchange data between Sounding-Initial & Sounding-Final Forms. UserData & Import Enhancements: • Updated the UserData importer to support the new database system. • New Import Options: When importing database data (UserData), users can now choose between: * Replace the Existing List * Append Before Existing List * Append After Existing List General Fixes & Improvements • Resolved various minor bugs and performance issues.
SmartCAL-Load Ver 3.5.2 Released 17 August 2024 Major Changes: - Revised all interpolation formulas using the INDEX and MATCH functions. This enhancement significantly improves the stability and flexibility of the formulas especially when dealing with data tables that have unequal intervals. The changes ensure more accurate and reliable data retrieval and manipulation, accommodating variations in data spacing and providing a robust solution for complex data calculation. - The program has been optimized compiled to the highest level to improve overall stability, despite its large size due to extensive data sets, hundreds of worksheets, formatting, complex formulas, VBA, UserForms, and more. This ensures efficient performance and reliability even with substantial data and functionalities. Grain Calculation Forms: - Added NCB Grain Stability Calculation Forms. When all the data have been entered in the Hydrostatic Table, Compartment and Tanks Data, Compartment Heeling Moment Table, and Maximum Allowable Heeling Moments Table, you can now enjoy the ease of entering and selecting the required fields in the Cargo Input userform to automatically compute the cargo figures and other grain stability calculations. To set up the compartments/holds in the form, simply select the number of holds using the provided menu. You can choose between 9 Holds to Free form (no compartment). You can save/store the current condition locally and restore/import it if needed using the provided listbox to serve as your database system. - Added AMSA Grain Stability Calculation Forms. When all the data have been entered in the Hydrostatic Table, Compartment and Tanks Data, Compartment Heeling Moment Table, and Maximum Allowable Heeling Moments Table, you can now enjoy the ease of entering and selecting the required fields in the Cargo Input user form to automatically compute the cargo figures and other grain stability calculations. You also have the flexibility to either use/override "C" or "V" or use the default settings to automatically identify the centers in the Upsetting Moment. To set up the compartments/holds in the form, simply select the number of holds using the provided menu. You can choose between 9 Holds to Free form (no compartment). You can save/store the current condition locally and restore/import it if needed using the provided listbox to serve as your database system. - Added CALCULATION OF STABILITY FOR VESSELS LOADING BULK GRAIN Calculation Forms. When all the data have been entered in the Hydrostatic Table, Compartment and Tanks Data, Compartment Heeling Moment Table, and Maximum Allowable Heeling Moments Table, you can now enjoy the ease of entering and selecting the required fields in the Cargo Input userform to automatically compute the cargo figures and other grain stability calculations. To set up the compartments/holds in the form, simply select the number of holds using the provided menu. You can choose between 9 Holds to Free form (no compartment). You can save/store the current condition locally and restore/import it if needed using the provided listbox to serve as your database system. To set up the compartments/holds in the form, simply select the number of holds using the provided menu. You can choose between 9 Holds to Free form (no compartment). You can save/store the current condition locally and restore/import it if needed using the provided listbox to serve as your database system. Ship Data & Hydro Sheet: - Added Keel Thickness Correction Setup Assistance. This utility assists in correctly entering and implementing whether the correction will be applied to the Quarter Mean or Corrected Drafts. Additionally, it helps generate the Drafts for the Hydrostatic Table sheet based on the desired Starting, Intervals, and Max Drafts. To ensure precise calculations that match your hydrostatic data with your load line data, you can use the SEND-INSERT function to send or insert the desired data into the table, regardless of the intervals or order. This ensures that the load line data and hydrostatic data (e.g., Displacements/Drafts) match down to the smallest decimal. - Added Auto Generate of Drafts in Data Sheet based on the Summer Draft and FWA only. Tank Sheets (Sounding-Initial & Sounding-Final): - Added Tank Data Status. This feature ensures that the Sounding Table is correctly set up for each tank. It helps you easily identify and rectify any issues if a tank sheet or sounding table is not set up correctly. - Revised all the formulas to allow to calculate unequal interval of soundings. - Rectified error in older version when calculating using combination correction with primary and secondary means of correction particularly to the "TRIM AS SOUND. & HEEL AS VOL." at a certain soundings. Trimming: - Added Trimming at One End. This utility assists in calculating how to trim the vessel while keeping one end constant (Forward or Aft), either by the required weight to load or by the required draft. It automatically calculates where and how much to load or discharge in a specific compartment based on the parameters entered. This ensures that the draft at the Forward or Aft end remains constant during trimming using one compartment. - Added Desired Draft & Trim at Disport. When all voyage deductibles/intakes have been identified and entered into the Compartment section, this worksheet will aid in computing the trimming cargo figures per selected compartments at the load port to achieve the desired draft or trim at the discharge port. You can choose from three cases, depending on your situation: * Case 1: Desired Draft and Trim at Discharge Port Based on Remaining Cargo in Load Port * Case 2: Desired Trim at Discharge Port Based on the Desired Mean Draft in Load Port * Case 3: Desired Mean Draft and Trim at Discharge Port This feature ensures precise calculations to meet your specific requirements at the discharge port. Deadweight Calculations: -Added DEADWEIGHT CALCULATION BY LOAD LINE ZONE. When all parameters have been set and voyage data and variables have been entered, this worksheet will help you compute the MAXIMUM ALLOWABLE CARGO at the LOAD PORT, DISCHARG POR, or any point during the voyage. It ensures compliance with Load Line Rules by not exceeding the draft, displacement, or deadweight limits of your ship per the Load Line Zone you will pass through during your voyage. - Added DEADWEIGHT CALC BY DESIRED DRAFT AT LOAD PORT OR DESTINATION. When all parameters have been set and voyage data and variables have been entered, this worksheet will help you compute the maximum allowable cargo at the Load Port or Discharge Port based on the desired Draft and their Water Density while it ensures compliance with Load Line Rules by not exceeding the draft, displacement, or deadweight limits of your ship per the Load Line Zone you will pass through during your voyage. Online Function: - Added new Online Help Function. This will provide users with the latest SmartCAL-Load online tutorials and materials like YouTube, Facebook, Microsoft Sway, PDF and etc. The content will be automatically updated upon open this form when the device is connected to the internet. - Added feature to automatically check if their is a latest update release available in smartcalworx.com if the device is connected to the internet. The notification will show in Home Menu just above the version number of SmartCAL-Load. Issues resolved from previous version: - Resolved issue with Quick Trimming when launching the userform if the existing data in the userform (cargo hold number) has no LCG value in Data Sheet. - Resolved issue with incorrect display of 1st and 2nd Trim Correction in SmartCAL-Load for Mobile Devices Version.