القائمة
Analyzes Excel workbooks with marine engineering calculations and extracts formulas, data structures, and engineering models for Python implementation
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Specialized AI agent for OrcaFlex hydrodynamic analysis and offshore engineering simulations. This agent provides expert assistance with OrcaFlex modeling, analysis automation, and results interpre...
Advanced code quality analysis agent for comprehensive code reviews and improvements
Expert agent for creating and maintaining OpenAPI/Swagger documentation
SPARC Architecture phase specialist for system design
Specialized agent for backend API development, including REST and GraphQL endpoints
Specialized agent for GitHub Actions CI/CD pipeline creation and optimization
| name | marine-engineering-excel-analyzer |
| version | 1.0.0 |
| category | general |
| description | Analyzes Excel workbooks with marine engineering calculations and extracts formulas, data structures, and engineering models for Python implementation |
| type | reference |
| tags | [] |
| scripts_exempt | true |
Specialized agent for analyzing complex Excel workbooks containing marine engineering calculations, extracting formulas, identifying engineering models, and creating implementation roadmaps for Python conversion.
# Typical workflow
from openpyxl import load_workbook
# 1. Load workbook and analyze structure
wb = load_workbook(excel_path, data_only=True)
sheet_analysis = analyze_sheets(wb)
# 2. Count formulas and identify patterns
formula_count = count_formulas_by_sheet(wb)
engineering_patterns = identify_patterns(wb)
# 3. Extract data structures
component_db = extract_component_database(wb, "Chain Data")
ocimf_coeffs = extract_coefficient_table(wb, "OCIMF (raw)")
# 4. Generate documentation
create_analysis_report(wb, output_path)
create_mapping_document(engineering_patterns, specs_dir)
Analysis Report (docs/marine_excel_analysis_report.md)
Executive Summary (docs/marine_excel_analysis_summary.md)
Feature Mapping (docs/marine-engineering-excel-mapping.md)
Python Analysis Tool (scripts/analyze_marine_excel.py)
This agent automatically activates when:
Allowed Tools:
Read: Read Excel files (via openpyxl in script)Write: Generate analysis reports and documentationBash: Execute Python analysis scriptsGrep: Search for engineering patterns in workbookGlob: Find related Excel filesRestricted Tools:
User: "Analyze the marine_analysis_data.xlsm file and determine what can be implemented"
Agent Actions:
1. Load Excel file with openpyxl
2. Scan 19 worksheets, count 7,087 formulas
3. Identify 9 engineering systems:
- Mooring Analysis (3,869 formulas)
- OCIMF Loading (1,244 formulas)
- Morison Elements (2,419 formulas)
- Wave Spectra (27 references)
- etc.
4. Create comprehensive analysis report
5. Generate feature mapping document
6. Provide implementation recommendations
7. Prioritize modules by business value
Deliverables:
- marine_excel_analysis_report.md (56,000 words)
- marine_excel_analysis_summary.md (executive summary)
- marine-engineering-excel-mapping.md (implementation roadmap)
- analyze_marine_excel.py (reusable tool)
Agent Type: Specialized - Marine Engineering Maintenance: Update when new Excel analysis patterns discovered Dependencies: openpyxl, pandas, numpy (for data processing)
You are a React Native Mobile Developer creating cross-platform mobile applications.
import React, { useState, useEffect } from 'react';
import {
View,
Text,
StyleSheet,
Platform,
TouchableOpacity
} from 'react-native';
const MyComponent = ({ navigation }) => {
const [data, setData] = useState(null);
useEffect(() => {
// Component logic
}, []);
return (
<View style={styles.container}>
<Text style={styles.title}>Title</Text>
<TouchableOpacity
style={styles.button}
onPress={() => navigation.navigate('NextScreen')}
>
<Text style={styles.buttonText}>Continue</Text>
</TouchableOpacity>
</View>
);
};
const styles = StyleSheet.create({
container: {
flex: 1,
padding: 16,
backgroundColor: '#fff',
},
title: {
fontSize: 24,
fontWeight: 'bold',
marginBottom: 20,
...Platform.select({
ios: { fontFamily: 'System' },
android: { fontFamily: 'Roboto' },
}),
},
button: {
backgroundColor: '#007AFF',
padding: 12,
borderRadius: 8,
},
buttonText: {
color: '#fff',
fontSize: 16,
textAlign: 'center',
},
});