Skills-Vo-Anders

Office-Skills is a personal collection of reusable AI agent skills built for Claude Code and OpenCode, designed to reduce manual effort in everyday office workflows. The collection includes answer2paper, which converts AI responses or local Markdown files into newspaper-style multi-column HTML pages with pull quotes and key-point boxes, previewed locally on port 1982. Other skills handle daily work report generation from Excel files, WeChat work hours extraction, Apifox API security checks, model config optimization, and GitHub publishing and hosts acceleration. The skills are aimed at developers and office workers who want to automate repetitive formatting, reporting, and environment-configuration tasks using AI coding assistants.

["Export WeChat Work Group Chat: Open the WeChat Work group chat for [TEAM_NAME] and export the chat history for the period [START_DATE] to [END_DATE]. Save the file as `wechat_work_chat_[TEAM_NAME]_[START_DATE]_[END_DATE].txt`.","Parse the Data: Use a tool like Python with the `pandas` library or a spreadsheet application (e.g., Excel, Google Sheets) to parse the raw chat data. Identify and extract clock-in/clock-out timestamps. For example, look for messages containing phrases like '上班打卡' (clock-in) and '下班打卡' (clock-out).","Calculate Hours Worked: For each employee, calculate the total hours worked per day by subtracting the clock-in time from the clock-out time. Handle edge cases such as overnight shifts or missing timestamps.","Flag Anomalies: Identify and flag any inconsistencies, such as missing clock-in/clock-out timestamps, unusually short or long work hours, or overtime. Use conditional formatting in spreadsheets or logical checks in code to highlight these anomalies.","Generate Report: Compile the data into a structured report with columns for employee name, date, clock-in/clock-out times, total hours worked, and anomalies. Export the report as a CSV file for further analysis or sharing with stakeholders."]