marine-engineering-excel-analyzer

Analyze marine engineering Excel workbooks to extract formulas and generate Python conversion plans.

14|2|Updated Jan 18, 2023

Search Tags:#documentation #analysis #formulas #excel #pattern-identification #marine-engineering #python-conversion

Ready to run

npx skills add https://github.com/vamseeachanta/digitalmodel --skill marine-engineering-excel-analyzer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: marine-engineering-excel-analyzer
Source: https://github.com/vamseeachanta/digitalmodel/tree/main/.claude/skills/converted-agents/engineering/marine-engineering-excel-analyzer
Command: npx skills add https://github.com/vamseeachanta/digitalmodel --skill marine-engineering-excel-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyzes marine engineering Excel workbooks to extract formulas, patterns, and data structures, enabling Python-based implementation planning.

Core Features & Use Cases

Excel Analysis: parse workbooks, count formulas, identify named ranges, detect VBA macros, and extract data structures.
Engineering Model Identification: recognize marine engineering patterns (e.g., RAO, mooring), extract component databases and calculation methodologies.
Documentation Generation: produce analysis reports, feature mappings, and Python implementation roadmaps.

Quick Start

Load a marine engineering Excel workbook and run the analysis workflow to generate a Python implementation plan.

Frequently Asked Questions about marine-engineering-excel-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I extract formulas and data structures from marine engineering Excel workbooks?▼

Extract formulas and data structures from marine engineering Excel workbooks by parsing files to identify named ranges, count formulas, and detect VBA macros. The analysis produces feature mappings and Python implementation roadmaps for marine calculations.

What is the best way to map RAO and mooring calculations from Excel to Python?▼

Map RAO and mooring calculations from Excel to Python by identifying marine engineering patterns within the workbook. The analyzer recognizes hydrodynamics models and component databases, then generates a structured Python conversion plan.

Does this Excel analysis tool require openpyxl to parse workbooks?▼

Yes, this Excel analysis requires openpyxl to parse workbooks. The library handles workbook parsing to detect named ranges and VBA macros, enabling extraction of calculation methodologies for Python implementation.

Can I identify VBA macros and named ranges in marine calculation spreadsheets?▼

You can identify VBA macros and named ranges in marine calculation spreadsheets during the workbook parsing process. The analyzer detects these elements alongside formulas to produce comprehensive analysis reports.

How do I generate a Python implementation roadmap from an Excel component database?▼

Generate a Python implementation roadmap from an Excel component database by running the analysis workflow. The tool extracts calculation methodologies and data structures, outputting feature mappings that guide Python conversion planning.