Talent Review Report Generator
Paste the following prompt into your AI chat to install this skill:
Please install @user_0b627a67/talent-review-system following https://skillhub.cn/install/skillhub.md.
About this skill
Problem
Personnel rosters are often kept in Excel files with fields such as unit, grade, title, review, certificate, and project status. Plain pivot tables can show totals, but they do not explain unit differences, key-role profiles, or pipeline needs. This skill targets the missing step: turning a roster into a browser-ready review view.
How it works
- Data preparation: parses a
.xlsxroster intopeople_data_enhanced.json, normalizing dates, age, tenure, numeric grade, and certificate lists. - Report building: uses
build_report_v3.pyto compute age, education, title, political status, certificate coverage, recent review trends, project categories, and third-level unit metrics, then emits a single-file HTML report. - Interaction: includes 12 tabs,
Chart.jsdrill-down, multi-field personnel search, pipeline editing, CSV/JSON export, and an admin gate for sensitive review data. - Deployment: can be published to EdgeOne Pages, Tencent Cloud COS, or htmlcode.fun; for WeChat access, a registered custom domain is the more stable option.
Boundaries
The skill expects relatively standard roster headers such as secondary unit, grade, 2025 review, and person tag; mismatched headers can leave fields empty. Admin password checks, blurred sensitive columns, QR-code collection, and Tencent Docs links are report-level features that should be used with organizational permissions in mind. Resume enrichment is optional and only populates manager profile fields when .docx resumes are provided.
Use Cases
- During annual talent review, convert multi-unit Excel rosters into an interactive HTML report with age, education, and title statistics.
- For key-role analysis, extract project managers from the roster and build profile pages by education, title, and review trend.
- When checking certifications, generate TOP15 certificate rankings and unit-level holding rates to spot coverage gaps.
- When sharing reports inside WeChat, deploy the single-file HTML to EdgeOne Pages or a registered custom domain.
Best For
- HR analysts running annual talent reviews who need to turn multi-unit Excel rosters into interactive HTML reports.
- Project managers or department heads managing key-role succession who need talent pools by education, title, and review trends.
- Operations or analytics leads reporting certification and review distribution who need TOP15 certificate rankings and unit comparisons.
- Project management offices maintaining successor pools who need to add, edit, and export pipeline records as CSV/JSON.
Related Skills
Scrapes JD search results for product titles, prices, sales, and stores, then exports verified data to UTF-8 CSV.
An A-share market monitor using Sina Finance API for real-time quotes, price and percentage alerts, daily logging, and scheduled checks.
Turn pasted or queried Xiaohongshu notes into a research memo covering title patterns, structure, quoted comments, and follow-up angles; public lookups are optional and confirmed before paid execution.
A universal base component that automatically launches the Edge browser and connects the BrowserSkill extension, ensuring readiness for web scraping and browser automation tasks.