← Back to Skills Marketplace
PowerfulHarp2041
by
xuping2012
· GitHub ↗
· v1.0.0
279
Downloads
0
Stars
1
Active Installs
1
Versions
Install in OpenClaw
/install test-effort-estimator
Description
This skill should be used when users need to estimate test effort based on product requirements. It analyzes requirements, breaks down tasks, estimates test...
README (SKILL.md)
Test Effort Estimator
Purpose
This skill provides a systematic approach to estimate test effort based on product requirements. It analyzes requirements, breaks them down into testable items, estimates effort for each phase (case design, first run, retest, regression), and generates an Excel report.
When to Use
Use this skill when users provide product requirements and need:
- Test effort estimation for new features
- Resource planning for testing phases
- Detailed breakdown of testing activities
- Excel export of effort estimates
How to Use
Step 1: Analyze Requirements
Read and understand the provided product requirements. Identify:
- Functional modules and features
- User stories and test scenarios
- Complexity levels of different features
Step 2: Break Down Test Items
For each requirement, identify test items:
- Test entry points and navigation
- Data display and validation
- User interactions and workflows
- System operations and state changes
Step 3: Estimate Effort
Apply complexity-based estimation standards:
Simple Features (0.20-0.30 person-days for design):
- Single function, clear logic
- Few operation steps, simple data preparation
- Examples: list display, simple navigation
Medium Features (0.35-0.40 person-days for design):
- Multiple sub-functions, moderate complexity
- Requires test data preparation
- Examples: data filtering, user management
Complex Features (0.50 person-days for design):
- Complex business logic, multiple interaction paths
- Requires diverse test data, strong dependencies
- Examples: online/offline binding, batch operations
Time Calculation Formulas:
- Case Design: Simple 0.20-0.30, Medium 0.35-0.40, Complex 0.50
- First Run: Simple 0.15-0.20, Medium 0.25-0.30, Complex 0.30-0.40
- Retest: 33%-67% of first run, round to 0.10 minimum
- Regression: 48%-67% of first run, round to two decimals
Step 4: Generate Excel Report
Use the bundled script scripts/generate_excel.py to create the Excel report with:
- Requirement title
- Requirement story/description
- Case design time
- First run time
- Retest time
- Regression time
- Estimation rationale
Constraints
- All time values must be >= 0.10 person-days
- All time values must be rounded to two decimals
- Total estimation error should be within 0.5 person-days of actual values
- Minimum unit is 0.01 person-days
Bundled Resources
Scripts
scripts/generate_excel.py: Python script to generate Excel report from estimation data
References
references/complexity-standards.md: Detailed complexity classification criteria and examplesreferences/estimation-formulas.md: Complete formula documentation and calculation examples
Workflow
- Load complexity standards from
references/complexity-standards.md - Analyze requirements and identify test items
- Apply estimation formulas based on complexity
- Execute
scripts/generate_excel.pyto generate Excel report - Review and validate total estimates against constraints
Usage Guidance
This skill appears to do what it says (estimate testing effort and produce an Excel). However: 1) The Python script depends on pandas (and an Excel writer) but the skill does not declare these dependencies or require Python — ensure your environment has Python and the necessary packages before running. 2) The code and sample data use Chinese text; provide inputs in the expected language or verify classification logic works for your input. 3) Run the script in a safe, write-permitted directory (it writes an Excel file) and review the generated Excel for correctness. 4) Because there is no install step, avoid letting an agent auto-install packages without user approval; explicitly inspect/approve any package installs (pip) if required. If you need stronger assurance, run the scripts in a sandbox or review/modify them locally to add explicit dependency checks (e.g., verify python and pandas versions) before executing.
Capability Analysis
Type: OpenClaw Skill
Name: test-effort-estimator
Version: 1.0.0
The skill bundle is a legitimate tool designed to estimate software testing effort based on product requirements. The core logic in `scripts/generate_excel.py` uses keyword matching and predefined formulas to calculate person-days and exports the results to an Excel file using the pandas library. There is no evidence of data exfiltration, unauthorized network access, or malicious instructions in the documentation (SKILL.md) or scripts.
Capability Assessment
Purpose & Capability
Name/description (test-effort-estimator) align with included code and reference docs. The two scripts, references, and SKILL.md all implement test-effort estimation and Excel export. Minor mismatch: SKILL metadata/title is in English while the code, sample data and references use Chinese strings—this is not malicious but could cause classification errors if input language differs. Also the skill bundles a Python script that requires pandas (and an Excel writer backend) but the skill declares no runtime dependencies or required binaries.
Instruction Scope
SKILL.md instructs the agent to analyze requirements, apply formulas, and run the bundled generate_excel.py to produce an Excel report. The instructions do not request reading unrelated system files, accessing environment secrets, or network endpoints. The runtime behavior described matches what the bundled script does (process requirement items and write an Excel file).
Install Mechanism
There is no install specification. The bundled Python script uses pandas (and pandas.to_excel which typically requires an engine such as openpyxl or xlsxwriter). Because no dependencies or required binaries (python, pip, pandas, excel writer) are declared, an agent or user may attempt to run the script in an environment lacking them, leading to unexpected attempts to install packages or failure. This is an operational/packaging coherence issue rather than an active supply-chain red flag (no external download URLs or archives).
Credentials
The skill requests no environment variables, no credentials, and no config paths. The code does not read environment or sensitive system configuration. No excessive credential access is requested.
Persistence & Privilege
The skill does not request persistent presence (always: false) and does not modify other skills or global agent settings. The package_skill script writes an archive only when run locally; generate_excel.py writes an Excel file to the working directory. No elevated privileges are requested.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install test-effort-estimator - After installation, invoke the skill by name or use
/test-effort-estimator - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of Test Effort Estimator skill.
- Provides systematic estimation of test effort based on product requirements.
- Breaks down features by complexity to estimate time for case design, first run, retest, and regression.
- Exports detailed effort estimates and rationale to Excel via provided script.
- Includes clear usage instructions and bundled references for standards and formulas.
- Ensures time values meet minimum and rounding constraints for accuracy.
Metadata
Frequently Asked Questions
What is PowerfulHarp2041?
This skill should be used when users need to estimate test effort based on product requirements. It analyzes requirements, breaks down tasks, estimates test... It is an AI Agent Skill for Claude Code / OpenClaw, with 279 downloads so far.
How do I install PowerfulHarp2041?
Run "/install test-effort-estimator" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is PowerfulHarp2041 free?
Yes, PowerfulHarp2041 is completely free (open-source). You can download, install and use it at no cost.
Which platforms does PowerfulHarp2041 support?
PowerfulHarp2041 is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created PowerfulHarp2041?
It is built and maintained by xuping2012 (@xuping2012); the current version is v1.0.0.
More Skills