🔋 KNX0600 Functional Macro

An Excel-based automation utility designed to prune raw telemetry data and analyze pass/fail criteria for the KNX0600 battery functional test. This macro processes .log files generated by the Texas Instruments bq Gas Gauge Evaluation Software, transforming raw data into a structured, actionable report.

✨ Key Features

• 📁 Automated Log Parsing: Directly imports .log files and populates temporary processing sheets to maintain data integrity.
• 🔍 RSOC Analysis:
  • Searches telemetry for the first valid Relative State of Charge (RSOC) value.
  • Priority-based search starting at 100%, cascading down to 98%.
  • Automatically prunes all trailing data rows once the target value is located.
• ⚡ Capacity & Time Validation:
  • Full Charge Capacity: Validates against a minimum threshold of ≥ 1840 mAh.
  • Total Elapsed Time: Calculates test duration and validates against a maximum of ≤ 3 hours.
• 📊 Visual Results Display:
  • Generates a final PASS/FAIL summary with dynamic cell coloring (Green/Red).
  • Automatically navigates to the summary sheet upon success or stays on the failure result for immediate review.
• 📋 Table of Contents: Maintains a running, hyperlinked list of all processed test worksheets for rapid navigation.

🛠️ Requirements

• Host: Microsoft Excel 2016 or later (Windows).
• Data Source: Output files from TI bq Gas Gauge Evaluation Software.
• Compatibility: Optimized for 64-bit Excel installations.

🚀 Usage Instructions

1. Open: Launch the Excel workbook containing the macro.
2. Navigate: Go to the "Import and Analyze" worksheet.
3. Run: Execute the macro from the Developer tab or assigned button.
4. Select: A file dialog will prompt you to choose the .log file for analysis.
5. Review: The utility will automatically prune the data, perform the analysis, and update the Table of Contents.

👤 Author

Jason Sparks - GitHub Profile

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.