AI Coding Assistant Lingma:User stories

Office automation

Use case 1: Automating annual reports

Scenario

Jane, the Director of Administration at a 300-person tech company, creates an annual work summary for the board of directors at the end of each year. She collects year-end reports from eight departments—including R&D, marketing, sales, HR, and finance—and consolidates them into a single document, reusing the previous year's format and referencing the company's reports from the last three years. Previously, this manual process took at least two full days, as it involved sifting through over 50 Word and PDF documents to extract relevant paragraphs and repeatedly refine the content and format.

This year, she decided to try QoderWork CN.

File preparation

Jane created a folder on the desktop named "2024 Annual Summary Materials" and put all the relevant materials inside:

desktop/2024 annual summary materials/
├── 2022 annual work summary.docx
├── 2023 annual work summary.docx (template)
├── R&D department - 2024 year-end report.docx
├── marketing department - 2024 year-end report.docx
├── sales department - 2024 year-end report.docx
├── human resources department - 2024 year-end report.docx
├── finance department - 2024 year-end report.docx
├── customer service department - 2024 year-end report.docx
├── product department - 2024 year-end report.docx
├── operations department - 2024 year-end report.docx
├── 2024 financial data summary.pdf
└── 2024 business indicator performance.xlsx

Three steps

1. Select the working directory

   In QoderWork, create a task. At the bottom of the dialog box, click "Select working directory" and choose the 2024 Annual Summary Materials folder.

2. Enter the prompt

   In the dialog box, enter the following prompt:

   Read all documents in the folder and complete the following tasks:
   1. Use "2023 annual work summary.docx" as the formatting template.
   2. Extract key work achievements, critical performance metrics, and project highlights from each department's 2024 year-end report.
   3. Incorporate core business figures, referencing the financial data summary and performance against business indicators.
   4. Follow the writing style and section structure from prior years' summaries.
   5. Generate the 2024 annual work summary report, including: an overall business overview, progress across business lines, team building and organizational development, and planning and outlook for the next year.
   6. Maintain the formatting and layout of the template.
   Output the result as a Word document.

QoderWork CN overview

QoderWork CN automatically processed all 50+ documents in the folder, identified the template structure, and extracted key data and highlights from the eight departments' reports. It then combined this information with financial data and business metrics, emulated the writing style of previous summaries, and generated a complete annual work summary in just 6 minutes. Jane only had to make a few minor edits before submitting the draft that same day.

Ongoing use

The following year, Jane can simply add the new department reports to the folder and instruct QoderWork CN to generate the 2025 annual work summary based on the previous year's format. The more historical data the folder contains, the more accurately the report reflects the company's business development over time.

Core Value

Metric	Result
Time savings	Reduced from 2 days to 6 minutes
Accuracy	Preserves 100% of KPI data
Format consistency	Automatically matches the template

User query

"What took hours now takes 6 minutes."

Tips and best practices

The success of this use case depends on two factors: standardized folder organization and a clear prompt structure.

Jane organized over 50 documents into a single folder with a consistent naming convention (DepartmentName-Year-FileType), allowing QoderWork CN to understand the full context in a single pass. The prompt performs three key tasks:

• Explicitly specify the template file ("Use '2023 Annual Work Summary' as the format template") to ensure a consistent output format.

• List all data sources (department reports, financial data, and business metrics) to ensure completeness.

• Define the output structure (business overview, business segments, team building, and future outlook) to provide a framework for the generated content.

With the folder as the source and the prompt as the blueprint, QoderWork CN generates a draft in one pass.

Case study 2: Online research and PPT analysis

Pain Points

Researching a new technology direction, from gathering and synthesizing information to creating a PPT, typically takes more than half a day.

After using QoderWork CN

Automatically searches the web for content on a target topic, synthesizes the findings, and generates a presentation-ready PPT—from a simple question to a finished presentation.

Example prompt

Research the use of large models for code generation:
1. Identify the latest technical advancements and leading products.
2. Compare the features, performance, and price of the leading solutions.
3. Analyze the advantages, disadvantages, and use cases of each solution.
4. Prepare a technical analysis report.
5. Create a presentation of approximately 15 slides for the technical team.

Continued use

To research a new topic, simply replace the topic in the prompt. For a consistent PPT style, place a PPT of your choice in the folder to use as a template.

Core values

Metric	Result
end-to-end automation	Generates a report-ready presentation from a problem in a single pass.
time saving	Reduces a half-day process to 30 minutes.
use cases	Supports technical research, competitive analysis, and industry reports.

Case study 3: Technical presentation for a client pitch

Pain points

Presales engineers manually create solution PPTs tailored to specific customer requirements and align them with the presentation's talk track. This multi-step process, which includes understanding requirements, structuring the solution, designing the PPT, writing a script, and planning for the Q&A session, is time-consuming and difficult to quantify or control.

After adopting QoderWork CN

QoderWork CN automatically generates a proposal presentation—containing a customer background, pain point analysis, solution architecture, and value comparison—and an accompanying 30-minute script from the customer data and solution documents in a folder.

Prompt example

Review all materials in the folder and prepare for the "Cloud Migration Solution Defense for a Financial Services Customer":
1. Identify the core pain points and key requirements in the customer requirements document.
2. Design a solution using the provided materials and relevant industry success stories.
3. Create a presentation of about 20 slides covering: customer background, pain point analysis, solution architecture, implementation plan, value comparison, and success stories.
4. Write a 30-minute speaking script that details the key points, time allocation, and specific talking points for each slide.
5. In the speaking script, flag potential questions and prepare corresponding talking points.

Next steps

Organize your presentation materials by creating a subfolder for each client. The more use cases you accumulate, the more accurately QoderWork can match similar scenarios.

Core values

Metric	Result
Efficiency Improvement	Reduced from 4–6 hours to 30 minutes
Specificity	Generated from customer-specific materials
Full Presentation Kit	PPT, speaker notes, pacing guide, and anticipated questions

Use Case 4: Automation skill for internal platform configuration

Pain points

Deploying internal platform configurations involves a complex, error-prone series of manual steps: checking configuration items, switching between environments, handling approvals, and preparing for rollbacks.

QoderWork: Next Steps

Use the create-skill feature to encapsulate the release process into a reusable Skill that enables one-click releases, eliminating repetitive operations.

Four steps

1. Run the initial release process

   Use QoderWork CN to complete a full release process.

2. Create the standard process document

   Say to QoderWork CN, "Convert the recent steps into a standard process document."

3. Package as a Skill

   Use create-skill to package the process into the "Release Assistant" Skill.

4. Reuse the Skill

   For future releases, simply say, "Run the Release Assistant Skill, target environment: production."

Continued use

When a workflow changes, simply update the Skill. New team members can also call it directly without needing to be familiar with the complex workflow.

Core values

Metric	Description
Process standardization	Standardizes complex internal processes.
Time saving	Cuts time from 30 to 3 minutes.
Zero omission	Ensures no steps are missed.
Team Enablement	Enables new members to complete complex deployments with one click.

Data processing

Use case 5: Foreign trade technical documents

Customer stories

Zhou, a merchandiser at an apparel trading company for eight years, dreads processing tech packs from international clients—20+ page PDFs that contain over 30 measurement points, specialized English terminology, a tolerance chart, and fractional values for seven different sizes.

Previously, her workflow involved opening a PDF, translating it line-by-line, and manually entering each number into Excel. This process, which took two to three hours per tech pack, was highly error-prone. For example, a single mistake last year—misreading half an inch as a quarter-inch—forced a complete batch rework, costing the company over 200,000 yuan.

Recently, her team lead suggested she try QoderWork CN.

Prepare files

Zhou put the customer's latest tech pack in a folder:

desktop/orders-2024SS-customer-ABC/
├── ABC-SS24-Style001-TechPack.pdf
├── ABC-SS24-Style002-TechPack.pdf
└── ABC-SS24-Style003-TechPack.pdf

Three steps

1. Select the working directory

   In QoderWork CN, select the Order-2024SS-ClientABC folder.

2. Enter the prompt

   In the dialog, enter the following prompt:

   These are English Tech Pack PDF files from the client. Process each one as follows:
   1. Extract all Points of Measurement (POM) and translate the English technical terms to Chinese.
   2. Organize the data into an Excel table with the following structure:
      - Columns: Part to Measure / English Name / Chinese Name / Tolerance (+/-)
      - Rows: Values for each size: S / M / L / XL / XXL / XXXL
   3. Preserve the original precision for fractional values, such as 1/2" and 3/4".
   4. Create a separate sheet for each style, and include the style number in the sheet name.
   Please pay special attention to the accuracy of fractional units, as it directly impacts production quality.

How QoderWork CN works

QoderWork CN automatically processed the three PDF files, identifying the complex table layouts and English terms. Within 10 minutes, it generated a standard bilingual size chart in Excel. Zhou reviewed the output and found that all data for the 30+ measurement points and seven sizes was accurate, including the easily confused fractional units.

Next steps

To process new orders, Zhou does the following:

• Place the new tech pack PDF in the corresponding order folder.

• Tell QoderWork CN, "We have tech packs for two new styles. Please process them using the previous format."

QoderWork CN automatically detects and outputs new files in the same format. Jane also uses it for cross-comparison. Using a prompt like "Compare the size differences between Style001 and Style002 and highlight any discrepancies," she can now complete in two minutes a task that used to take an entire afternoon.

Core values

Metric	Result
time savings	Cuts processing time from 2-3 hours per file to 10 minutes for 3 files.
accuracy	Ensures 100% accuracy, preventing costly losses from scoring errors.
Cumulative benefits	A standardized order folder structure streamlines processing.

User query

"It's 100% accurate, saving us hundreds of thousands."

Usage tips

The core technique for this use case is precisely defining the output format and precision in the prompt.

Instead of a vague request like "Help me organize the Tech Pack," Zhou's prompt precisely defines the Excel column structure (measurement point, English name, Chinese name, tolerance) and row structure (sizes S, M, L, XL). She even specifies critical requirements, such as "maintain original precision for fractional values" and "pay special attention to the accuracy of fractional units." Building quality guardrails into the prompt directly determines the output's reliability.

Another best practice is to organize files into order-specific folders, such as orders-2024SS-clientABC. For subsequent orders, you can simply place the files in the corresponding folder to reuse the workflow.

For precision-sensitive tasks, clearly define the desired output format and critical constraints in your prompt.

Case 6: Consolidated declaration for multi-factory shipments

Scenario: Pain Points

Each OEM factory provides its packing list in a unique format. These lists must be merged and then split into two—one for the United States and one for Canada. The style number, carton number, and quantity for each size must match exactly. This manual copy-and-paste process is highly error-prone, as a single mistake, such as a broken carton number sequence or an incorrect quantity, requires a complete rework of the customs declaration documents.

Using QoderWork CN

Select the folder containing the factory packing lists, and QoderWork CN automatically analyzes them, splits the data by destination, generates a customs declaration summary, and assigns sequential carton numbers.

Prompt example

The folder contains packing lists from three factories in Excel format. Complete the following steps:
1. Read all packing lists and identify the style number, carton number, and quantity for each size.
2. Merge the data and split it by destination into a "US order summary table" and a "Canada order summary table".
3. Renumber the carton numbers sequentially starting from 001, with no gaps.
4. Add a summary row to the end of each table showing the total carton count and total piece count.
5. Ensure the style numbers and quantities for each size are accurate, then output the results in Excel format.

Next steps

Create a folder for each shipment batch (e.g., 2024-03-shipment-batch-1), allowing you to select and process it directly for customs declaration.

Core values

Metric	Result
Efficiency improvement	Reduced from hours to 5 minutes
Accuracy	100% accuracy through automated, sequential orchestration of container numbers
Timeliness assurance	Prevents customs declaration errors that lead to customs clearance delays

Use case 7: Batch extract data from purchase orders into a Skill

Challenges

Manually extracting and consolidating fields from eight bilingual PDF purchase orders into Excel takes at least half a day.

After using QoderWork CN

QoderWork CN automatically reads all PDFs in a folder, recognizes complex layouts, and extracts 280 order details—all in just 28 minutes. Users can then encapsulate this workflow as a reusable Skill.

Example prompt

Read all PDF purchase orders in the folder:
1. Extract key data from each purchase order: order number, supplier, SKU, product name, quantity, unit price, total amount, and delivery date.
2. Generate summary tables: consolidated, by supplier, and by product category.
3. Flag line items where the unit price deviates by more than 20% from the average price for that SKU.
4. Export the results to Excel.

Next steps

Once you encapsulate a process as a Skill, you can process future purchase orders simply by placing the PDFs in a folder and calling the Skill.

Core value

Metric	Description
Efficiency gains	Reduces processing time from half a day to 28 minutes.
Reusability	Users proactively encapsulate processes as Skills.
Reuse mindset	Users not only see the efficiency gains but also start to think, I should turn this into a template and make it the standard.

User utterance

"I want to encapsulate this workflow into a Skill for reuse."

Use case 8: Multi-dimensional sales analysis

Pain points

Analyzing large Excel datasets manually is time-consuming and makes it difficult to pivot between data dimensions to analyze variables like customer assignments, case types, and sales amounts by employee.

After implementing QoderWork CN

Upload a daily sales report and use a single prompt to perform multidimensional analysis and generate a Japanese translation.

Example prompt

Analyze this daily Excel sales report (10,634 rows):
1. For each salesperson, calculate the number of customers, case type distribution, total sales, and average sale value.
2. Analyze the monthly sales trend and calculate the month-over-month growth rate.
3. Analyze the contribution of the top 20 customers and the overall customer concentration.
4. Generate an analysis report with data tables and trend charts.
5. Translate the report into Japanese.

Core values

Metric	Result
Processing scale	Performs multi-dimensional analysis on 10,634 rows of data in a single prompt.
Multi-language	Supports translated output in Japanese.
Flexibility	Supports switching between analysis dimensions at any time.

Use Case 9: Aggregate and visualize e-commerce sales data

Pain points

Sales detail Excel files scattered across multiple regions require manual aggregation and visualization, making it difficult to generate a global view quickly.

After QoderWork CN

Aggregate US, European, and global sales data from Excel files to generate an interactive HTML visual analysis page.

Example prompt

The folder contains three Excel files: US sales details, EU sales details, and a global summary. Do the following:
1. Merge the data from the three files and standardize the field format.
2. Generate an HTML visualization report that includes:
   - A pie chart of the sales breakdown by region.
   - A line chart of the monthly sales trend.
   - A bar chart ranking the top 10 best-selling products.
   - Dynamic filtering by region, month, and category.
3. Export the result as an HTML file.

Core values

Metric	Benefit
Visualization	Direct visualization of aggregated cross-region data.
Interactivity	Enables dynamic filtering.
Accessibility	Uses standard HTML, viewable in any web browser.

Use case 10: Batch convert PDFs to Word

Pain points

Manually converting multiple PDF teaching materials into editable Word documents is repetitive and time-consuming. Online conversion tools often have page limits or require payment.

Next Steps with QoderWork CN

Automatically batch-convert local PDF files to Word format, preserving the original formatting.

Example prompt

Batch convert all PDF files in a specified folder to Word (.docx) format:
1. Preserve the original layout, including headings, paragraphs, tables, and images.
2. Keep the original filename, changing only the extension.
3. Output the converted files to the source folder.

Core benefits

Feature	Benefit
Batch processing	Process multiple files at once.
Format retention	Retains the original layout.
Unlimited	No page limits and no charge.

Use case 11: One-to-many column expansion

Use case pain points

In Excel, data representing a one-to-many relationship, such as a contract with multiple payment batches, often needs to be manually expanded into individual rows. Traditionally, this requires writing complex formulas.

Next steps

Describe a requirement in a single sentence, and QoderWork CN automatically generates the columns.

Example prompt

The "payment batch" column in this Excel file contains comma-separated values.
Expand each value into a separate row, keeping the data in the other columns unchanged.
Output the result to a new Excel file.

Core value

Metric	Effect
Ease of use	Simplifies complex data operations down to a single sentence
Zero learning curve	No formulas required
use case	Processing enterprise financial data

Use case 12: Automated receipt photo organization

Pain points

Photos of business trip receipts often have random filenames, such as IMG_20240301_xxx.jpg, forcing you to manually view, rename, and archive each one by category.

Next steps

QoderWork CN automatically extracts the amount, date, and expense type from a folder of photos, then batch-renames and archives the files in a standard format.

Prompt example

Process the business trip receipt images in this folder:
1. For each image, identify the transaction date, amount, merchant name, and expense category (dining, transportation, accommodation, or other).
2. Rename each file using the format: Date-Category-Amount-MerchantName.jpg (e.g., 20240301-Dining-128-SomeRestaurant.jpg).
3. Create subfolders for each expense category and move the corresponding files into them.
4. Generate an Excel expense report listing all line items and the total amount.

Core values

Feature	Benefit
Common Use Case	Addresses a common office pain point: invoice processing.
Fully automatic	Automates the entire OCR, classification, and renaming workflow.
Batch processing	Eliminates manual operations.

Content creation

Case 13: Materials → PPT → Narrated video (End-to-end)

Use case

Sun is an instructor at a civil service exam prep center. His question bank for structured interviews is stored as a JSON data file containing questions, reference answers, and explanations. Previously, to create video lessons from this content, he would first compile the material into a PPT presentation and then use screen recording software to narrate each slide. For a set of 30 questions, this entire workflow would take at least two days.

He wants to see if QoderWork CN can get this link working.

Preparing files

desktop/civil service exam course production/
├── structured interview question bank-part1.json
├── answer framework template.pptx (optional, a PowerPoint style reference)
└── intro and outro assets/ (optional)

Three steps

1. Select working directory

   Set the Civil Service Exam Course Production folder as the working directory.

2. Generate PPT

   Read "structured-interview-questions-batch1.json" and generate one slide for each question:
   - Top half of the slide: The question content
   - Bottom half of the slide: Key points from the reference answer (listed as bullet points)
   - Final slide: A summary of the answering framework
   Use the color scheme and font style from "answering-framework-template.pptx".

3. Generate video with voice-over

   Convert the generated PPT into a video:
   - Add a conversational voice-over to each slide based on the reference answer.
   - Automatically adjust the display duration for each slide based on its content length.
   - Output the video as an MP4 file.

What QoderWork CN Does

QoderWork CN uses JSON data to automatically generate a 30-slide structured PPT handout. It then converts each slide into conversational narration to create a teaching video. This process reduces what was once a two-day task to a single morning.

Next steps

Sun now updates the question bank weekly simply by placing a new JSON file in the folder and saying, "Generate a PPT and video for the new question bank." He has also encapsulated this workflow as a Skill so his teaching assistants can use it.

Core value

Feature	Description
End-to-end automation	Automates the workflow from materials to PPT to video in a single pass.
Use cases	Training, education, and knowledge sharing—any scenario that involves turning source materials into a course.

Best practices

The key technique in this use case is a combination of step-by-step prompts and skill encapsulation, ideal for complex, long end-to-end workflows.

Instead of trying to manage the entire JSON → PPT → video workflow in a single prompt, Sun broke the task down into two steps:

• The first step focuses on PPT generation: reading data and applying the template style.

• The second step focuses on video composition: adding voice-overs and controlling timing.

QoderWork CN runs more reliably because each step has well-defined input and output. If you're not satisfied with an intermediate result, you can adjust just that step without restarting the entire process.

After validating the workflow, Sun used create-skill to encapsulate it as a Skill that teaching assistants can call directly, which enables "build once, use forever" reuse across the team.

Break down a complex task into step-by-step prompts, and encapsulate a proven workflow as a Skill to create your own custom automated pipeline.

Use case 14: Create introductory presentation from an online paper

Pain points

Creating an introductory presentation from a dense academic paper is time-consuming: understanding the content, distilling key insights, and designing the slides.

Working with QoderWork CN

QoderWork CN analyzes a paper using just a link, automatically generating a structured, beginner-friendly PPT.

Prompt example

Create an introductory presentation based on this paper:
Paper link: https://arxiv.org/abs/xxxx.xxxxx
Requirements:
1. Explain the core concepts in plain language for a non-specialist audience.
2. Each slide should focus on a single key point, with an intuitive diagram or analogy.
3. The presentation must be 12-15 slides long and include: Background, Core Method, Key Results, and Practical Significance.
4. List suggestions for further reading on the final slide.

Continued use

To batch generate PPT courseware, place all your paper links and PDFs in a single folder.

Core values

Metric	Description
One-click conversion	Automatically generates a presentation from a paper.
Audience adaptation	Automatically tailors content for the target audience.
Flexible input	Supports input from online links.

Use case 15: Generate a mind map from content

Scenario Pain Points

Manually organizing online and offline content into a mind map is time-consuming, making it difficult to quickly build a structured knowledge system.

After using QoderWork CN

Automatically generates structured mind maps in XMind format from online and offline content.

Prompt example

Analyze the following content and generate a mind map:
1. Read study notes and references from the folder.
2. Extract the core concepts, key points, and their relations.
3. Organize into a hierarchical structure with a maximum of 5 main branches.
4. Expand each branch to 2 to 3 levels.
5. Export as an XMind file.

Core values

Metric	Description
Automatic conversion	Automatically generates a mind map from your content.
Multi-source input	Supports online links and local files.
Standard format	Generates editable XMind files.

Legal

Use case 16: Custom legal skill and case issue analysis

Scenario

Attorney Liu is a senior partner at a law firm with over 20 years of experience in commercial disputes. He analyzes new cases using a set methodology: building a timeline, identifying key disputed issues, evaluating the evidence chain, and developing a litigation strategy.

The problem was that his methodology was entirely undocumented. Each new case required a manual, repetitive process, making it difficult to standardize the workflow or effectively train new associates. He had long wanted to codify this approach into a reusable tool.

File preparation

Attorney Liu organized the folders by case:

desktop/Case - John Doe Contract Dispute/
├── Complaint.docx
├── Original Contract Scan.pdf
├── Supplemental Agreement.pdf
├── WeChat Chat Screenshots/
│   ├── 2024-01-ChatHistory.png
│   ├── 2024-03-ChatHistory.png
│   └── ...
├── Bank Transfer Receipt.pdf
└── Opposing Counsel's Letter.pdf

Three-Step Operation

1. Select the working directory

   Select the case folder as the working directory.

2. Process using the analysis framework

   Read all case materials in the folder and analyze them using the following framework:
   1. Case timeline: List all key events and sort them chronologically.
   2. Points of contention: List the core points of dispute in this case, such as contract validity, determination of breach, and calculation of damages.
   3. Evidence chain analysis:
      - For each point of contention, list evidence that supports our position and likely counterarguments from the other party.
      - Label the evidence strength (strong/medium/weak).
      - Identify gaps in the evidence chain and suggest ways to strengthen it.
   4. Litigation strategy recommendations: Recommend the primary approach, fallback options, and key risks.
   5. Generate a case analysis report (Word format).

3. Encapsulate as a Skill (Advanced)

   Once satisfied with the analysis results, use QoderWork CN to encapsulate this analysis framework into a Skill:

   Encapsulate the case analysis workflow you just used into a Skill named "Commercial Dispute Case Analysis":
   - Input: A case materials folder
   - Output: A case timeline, points of contention, evidence chain analysis, and a litigation strategy report.
   - The analysis framework is fixed, but the content is dynamically generated based on the materials of each case.

   Now, junior lawyers at the firm can also use this Skill. They select the case materials folder and generate the case analysis report with one click. Attorney Liu then reviews and signs off.

Core value

Benefit	Description
experience encapsulation	Encapsulates 20 years of professional experience into a Skill.
team empowerment	Lets junior associates create high-quality case analysis frameworks.
industry-specific depth	Excels in specialized legal industry scenarios.

Usage tips

The core technique for this use case is encapsulating expertise in a Skill to turn implicit methods into reusable tools.

Attorney Liu's process involves two steps:

• Define the analysis framework (Timeline → Points of Dispute → Evidence Chain → Litigation Strategy) in the prompt for QoderWork CN to follow.

• Once satisfied with the results, use create-skill to encapsulate the entire process as a Skill, defining the input (case materials folder) and output (analysis report).

The primary benefit of an encapsulated Skill is team reuse: junior lawyers can generate standardized analysis reports by simply selecting a case folder and running the Skill, which Attorney Liu then reviews for final approval. This ensures one person's 20 years of professional experience can benefit the entire team.

First, validate your workflow with a structured prompt. Then, use create-skill to encapsulate it as a standardized, reusable tool for your team.

E-commerce operations

Case 17: Daily data automation for cross-border e-commerce

Scenario

For three years, Alex has run a cross-border e-commerce business, managing five stores and over 200 SKUs. Each morning, he would log into each of his five store backends to export the previous day's sales data, paste it into a summary spreadsheet, and manually calculate daily changes and ranking shifts. This daily routine alone took over an hour, and in the rush, he would often miss a store.

He could automate this process with QoderWork CN.

Example prompt

Automate daily data synchronization for e-commerce stores:
1. Log in to the seller console for each of the following sites:
   - US site: [URL]
   - European site: [URL]
   - Japanese site: [URL]
   - ...
2. On each site’s business report page, export yesterday’s sales.
3. Consolidate all site data into a single Excel file containing:
   - Sales, orders, and return rate for each site.
   - The top 10 best-selling SKUs and their performance.
   - Day-over-day change, with any decreases highlighted in red.
4. Generate a brief daily operations summary (within 200 words).

How QoderWork CN works

QoderWork CN uses browser automation to log in to each store backend, navigate to the reports page, and export the data. It then merges and analyzes this data to generate a summary report. Each morning, Wang Lei opens his computer and finds the report already waiting for him in the folder.

Continued use

Save this workflow as a Skill. You can then run it daily by simply saying, "Generate the daily store report." As your data accumulates, you can also ask follow-up questions, such as, "Which SKUs are showing a consistent sales decline over the past 30 days?"

Core value

Metric	Effect
browser automation	Solves a common pain point for cross-border e-commerce sellers.
time saving	Reduces a 1-hour manual task to a 10-minute automated process.
data accumulation	Enables trend analysis over time.

Best practices

The core technique for this use case is browser automation and skill encapsulation, ideal for repetitive tasks like logging into websites and performing actions.

In this scenario, QoderWork CN does not use local files; instead, it needs to open a browser, log in to multiple consoles, and export data. This process is guided by a prompt that specifies the URL and operation path for each site, for example, "export yesterday's sales data from the business report page," enabling QoderWork CN to navigate and perform these actions as a human would.

A daily, repetitive task can be perfectly encapsulated as a Skill. Once Alex saves the workflow as a reusable Skill, he can run it daily with a simple command like "Generate the daily store report." With its browser automation, QoderWork CN can not only process local files but also interact directly with web-based systems.

The best way to save significant time on repetitive tasks—such as logging into websites, exporting data, and performing backend operations—is to encapsulate the workflow into a reusable Skill with browser automation.

Use Case 18: AI generative editing for e-commerce images

Pain points

E-commerce product images need multiple variants (e.g., with different backgrounds, scenes, and styles), but maintaining a consistent brand style and color across them is a costly manual process.

Next steps

Batch-recreate e-commerce product images with AI, preserving the original style and color while modifying only the image elements.

Prompt example

AI-powered generative editing for main product images:
1. Analyze the images' brand visual style, including the color scheme, composition, and lighting and shadow.
2. Generate three image variants of the same product in different scenes, such as a pure white background, a lifestyle scene, and a holiday theme.
3. Ensure the brand color and product form remain consistent.
4. Output a side-by-side comparison for evaluation.

Core values

Metric	Benefit
innovative application	Real-world application of AI image generation for e-commerce.
brand consistency	Produce image variants at scale while maintaining a consistent look and feel.
low barrier to entry	Requires no professional design skills.

System management

Use Case 19: Deep-clean Mac disk

Scenario

Chen is a graphic designer with a 256 GB MacBook Pro. Recently, she's been getting frequent warnings about low disk space. With only 7 GB of available space left, she discovered that system data was consuming a staggering 124 GB. She doesn't know which files are safe to delete and finds the available tutorials long and confusing. She's worried that accidentally deleting system files could crash her computer.

On a friend's recommendation, she tried QoderWork CN.

Direct messages

You don't need to prepare a folder. In the QoderWork dialog, say:

My Mac has only 7 GB of available space left, and system data is taking up 124 GB.
Please do the following:
1. Analyze disk usage to identify large files and folders consuming space.
2. Identify what is safe to delete and what must be kept.
3. Provide a cleanup plan specifying how much space each action will free up.
4. Wait for my confirmation before starting the cleanup.
Important: Do not delete any system files or my work files. If you're unsure about a file, ask me first.

Working principle

QoderWork CN ran a system diagnosis and identified the largest consumers of disk space: 23 GB of development tool cache, 18 GB of unused container images, 31 GB of local snapshots, and 12 GB of application caches. It presented a cleanup plan detailing the estimated freed space, requiring Chen's confirmation for each item to proceed. In total, the process freed approximately 84 GB, increasing her available space from 7 GB to 91 GB.

Continuous Use

Once a month, Chen asks QoderWork CN, "Check my disk space and see if anything needs cleanup." QoderWork CN quickly scans her system and provides recommendations, effectively acting as her on-demand IT assistant.

Core value

Metric	Effect
Tangible effect	Increased available space from 7 GB to 91 GB
Widespread pain point	Large Mac user base
Safety-first approach	Presents a plan requiring confirmation before execution.

User utterance

Scaled from 7 GB to 91 GB.

Best practices

This use case's core technique is direct conversation with a safety confirmation mechanism—no folders or complex preparation needed.

Chen's approach is simple: she describes the problem directly ("available space is down to 7 GB, and system data takes up 124 GB") and adds two key instructions to the prompt: "Wait for my confirmation before proceeding with the cleanup" and "If you are unsure about anything, ask me first." These instructions place QoderWork CN in a safe mode, where it first diagnoses the issue, then recommends a solution, and waits for confirmation before acting. This avoids the risk of accidental deletion.

This use case shows that not all tasks require a folder. For scenarios such as system management and troubleshooting, a direct interaction is sufficient if you clearly describe the current situation and define the security boundary.

For tasks involving system operations, always instruct the model to present a solution and wait for confirmation before proceeding. This is a security-first best practice.

Use case 20: Storage space analysis and visualization report

Pain points

Without data on how file types use your disk space, you're left to guess what to clean up.

After using QoderWork CN

Analyze storage space usage and generate a visual HTML report showing the storage breakdown by file type.

Example prompt

Analyze storage space utilization:
1. Scan the storage usage of each disk partition.
2. Calculate storage usage by file type: document, image, video, application, cache, and other.
3. Identify the 20 largest files and folders.
4. Generate an HTML visualization report that includes a pie chart, a bar chart, and a detailed list.

Core value

Metric	Description
Visualization	Generates a clear, intuitive report.
No special software	Opens directly in a browser as HTML.
Decision support	Provides data for cleanup decisions.

Use Case 21: Analyzing installers and background processes

Pain points

Untracked applications, especially background processes, can pose security and performance risks.

QoderWork CN: What's next

Automatically lists all installed and background applications, filtering out system applications to help you understand your computer's status.

Example prompt

Check the status of applications and processes on your computer:
1. List all user-installed applications (excluding built-in ones), showing their installation date and disk space usage.
2. List all currently running non-system processes, showing their CPU and memory usage.
3. Flag any suspicious or uncommon processes.
4. Provide optimization suggestions, such as which applications to uninstall and which background processes to stop.

Core values

Metric	Description
security audit	Comprehensive system security and performance check.
key focus	Automatically filters system processes.
decision support	Informs uninstallation and optimization decisions.

Use case 22: Desktop and browser bookmarks

Pain points

Cluttered desktop files and disorganized browser bookmarks hinder productivity.

After Using QoderWork CN

Automatically analyzes your desktop file structure and bookmarks, organizes them into categories, and streamlines your bookmark bar.

Example prompt

Help me organize my digital workspace:
1. Organize the desktop: Scan all files on the desktop and automatically sort them into subfolders by type (e.g., documents, images, downloads, and temporary files).
2. Organize browser bookmarks: Export all bookmarks, remove broken links, and recategorize them by topic.
3. Generate a summary report detailing the number of files organized, bookmarks optimized, and the amount of desktop space freed up.

Core value

Parameter	Description
Dual optimization	Simultaneously organizes your desktop and browser.
Efficiency improvement	Improves your work efficiency.
Immediate effect	Delivers immediate, noticeable improvements.

Preparation

Case 23: Automatically generating a test

Use case

Ms. Zhao teaches eighth-grade physics to three separate classes. Before each monthly exam, her most challenging task is creating test papers. She must balance question types (multiple-choice, fill-in-the-blank, experimental, and calculation), control a precise difficulty gradient (60% basic, 30% intermediate, and 10% advanced), and ensure all chapter concepts are covered. In the past, this meant manually searching the question bank, hand-picking questions, and formatting the paper for printing. Each test took at least three hours to create. Creating a unique test for each of her three classes tripled her total workload.

File preparation

Ms. Zhao organizes her teaching materials in a folder:

desktop/Grade 8 physics-exam prep materials/
├── curriculum standard-Grade 8 physics.pdf
├── Chapter 1-mechanical motion-key points.docx
├── Chapter 2-acoustic phenomena-key points.docx
├── Chapter 3-changes in states of matter-key points.docx
├── past monthly exam papers.docx
└── class grades-last monthly exam.xlsx (optional, to create questions targeting weak points)

Three steps

1. Select the working directory

   Select the "Grade 8 physics-exam creation materials" folder.

2. Enter exam requirements

   Please generate 3 versions of a Grade 8 physics monthly exam based on the knowledge point documents and curriculum standards in the folder:
   1. Scope: Chapters 1 to 3
   2. Question distribution: 10 multiple-choice questions (3 points each), 8 fill-in-the-blank questions (2 points per blank), 2 experimental questions (16 points total), and 2 calculation questions (14 points total), for a total of 100 points
   3. Difficulty ratio: 60% basic, 30% intermediate, and 10% advanced
   4. The 3 versions must cover the same knowledge points but contain unique questions.
   5. Each version must include a standard answer key and a scoring rubric.
   6. Reference the previous monthly exam results to add more weight to topics where the class showed weakness, such as the graphical analysis of changes in states of matter.
   7. Output as Word documents formatted for printing.

How QoderWork CN works

At Teacher Zhao's request, QoderWork analyzed the curriculum standards and topic documents to generate three exam versions of comparable difficulty, each with a detailed scoring rubric. It also used data from the previous monthly exam to add two image analysis questions about changes in states of matter, precisely targeting the class's areas of weakness.

Next steps

Before each monthly exam, Ms. Zhao now only needs to:

• Add the knowledge point documents for the new chapter to the folder.

• Tell QoderWork CN, "Expand the scope to Chapter 4 and generate a new set of test papers based on the same criteria."

• For the final exam review, you can also say, "Based on all monthly exam results from this semester, generate personalized practice questions for each student to target their weak knowledge points."

Core values

Feature	Description
Intelligent question generation	Provides comprehensive topic coverage
Controllable difficulty	Offers flexible question types and precise difficulty control
Batch generation	Generates multiple unique exam versions in a single pass
Targeted generation	Uses performance data to target student weaknesses

Best practices

The core of this use case involves folder management and fine-grained parameterized prompts.

Ms. Zhao did two things right:

• Centralized material management: Organize all materials, including knowledge point documents, curriculum standards, past exam papers, and class grades, into a single folder to create a complete item bank for QoderWork CN.

• Use specific numbers to quantify all requirements: Define the question type distribution with exact point values (for example, 10 multiple-choice questions at 3 points each), specify the difficulty ratio as a percentage (60% basic, 30% intermediate, and 10% advanced), and assign greater weight to questions targeting weak knowledge points.

A parameterized prompt is more effective than a vague instruction like "create a moderately difficult test," because it provides QoderWork CN with clear constraints, making the output quality easier to control.

To take QoderWork CN's output from "close enough" to "exactly right," specify parameters like quantity, ratio, and score as specific numbers in your prompt.

Getting information

Use Case 24: Crawl macroeconomic news and send emails

Use case

Lin is an investment researcher at a private equity fund. Every morning before 8:00 a.m., he has one task: browse six information sources, including multiple financial information websites and the central bank's official website, find important macroeconomic news, and compile a briefing for his team. This seemingly simple task actually takes 40 to 50 minutes each day—a manual process of opening websites, flipping through pages, assessing importance, copying and pasting, formatting, and sending the email. Each step is essential.

direct conversation

No need for folders. Just tell QoderWork CN what to do:

Create a daily macroeconomic news briefing:
1. Crawl the following websites for major news from the past 24 hours:
   - A financial news platform (xxx.com)
   - The People's Bank of China website (www.pbc.gov.cn)
   - IMF News (www.imf.org/en/News)
   - Federal Reserve statements (www.federalreserve.gov)
   - National Bureau of Statistics (www.stats.gov.cn)
2. Filter for news about macroeconomic policy, interest rates, exchange rates, GDP, and inflation.
3. For each news article, include the title, a single-sentence summary, and the original link.
4. Sort the articles by importance into two categories: "Must-Read" and "Reference".
5. Format the results as a concise email.
6. Send the email to team@example.com with the subject "Macroeconomic Daily-{today's date}".

How QoderWork CN works

QoderWork CN uses browser automation to scrape relevant news from six websites. It then filters and sorts the news by importance, generates a concise briefing, and automatically sends it to the team mailbox each morning.

Continued use

Once you encapsulate this workflow as a Skill, you can run it daily with a simple command like "Generate today's macro report." For special events, such as a central bank interest rate cut, you can also make a more complex request like "Perform an in-depth analysis of today's interest rate cut and generate a special report for the team."

Core values

Metric	Description
multi-source collection	automated collection, filtering, and sorting
end-to-end closed loop	Organizes and pushes in a single step
target roles	Information-intensive roles, such as investment researchers and analysts
automation	Can run daily once encapsulated as a Skill.

Usage tips

This use case combines browser automation, email integration, and Skill encapsulation to create a fully automated, end-to-end workflow: collection → curation → delivery.

Lin's prompt serves several key purposes:

• Specify a list of websites and filter keywords (macroeconomic policy, interest rates, exchange rates, etc.)

• Define the output format (title + one-sentence summary + source link)

• Configure email delivery (recipient and email subject format)

With a single prompt, QoderWork CN handles the entire workflow, from data collection to email delivery. Once encapsulated as a Skill, this workflow becomes a recurring daily automated task.

Browser automation isn't just for managing the backend; it can also gather information. Combined with email sending and Skill encapsulation, it becomes a personal information assistant.

IT tools

Use case 25: Extract stack trace from website crash

Use case

Zhang is a backend engineer. His company has an internal crash log platform. Whenever a production issue occurs, he must manually open a browser, log in to the platform, locate the corresponding crash record, copy the stack trace, and paste it into a document for analysis. The process isn't complex, but repeating it several times a day is tedious. To make matters worse, his login session frequently expires, so he has to repeatedly enter his password.

Direct conversation

Describe your request in QoderWork CN:

To extract information from the crash log platform:
1. Open your browser and navigate to http://crash.internal.company.com.
2. If prompted, log in.
3. In the search box, enter the crash ID: CRASH-2024-03-001.
4. Extract the full stack trace.
5. Save it as a Markdown document, ensuring the filename includes the crash ID.
6. Analyze the stack trace to make a preliminary determination of the potential cause of the crash.

What QoderWork CN does

QoderWork CN automates a complete browser workflow, including login, navigation, search, and extraction. It saves the stack trace as a formatted Markdown document and generates a preliminary cause analysis, such as "A NullPointerException occurred at UserService.java:128, which may indicate that the user object was not initialized."

Next steps

Zhang packaged this operation as a skill. Now, whenever he receives an online alert, he can simply say, "Extract and analyze the stack trace for CRASH-2024-03-002." QoderWork CN automatically handles the entire workflow, so he can go straight to the analysis results.

Core value

Metric	Effect
typical scenario	Browser automation in the development toolchain
ideal for automation	Automation provides the greatest benefit for simple, repetitive tasks.
efficiency stacking	Single-pass extraction and analysis

Best practices

This use case uses browser automation + Skill encapsulation to automate frequent, repetitive tasks.

Zhang's workflow is repetitive, performed several times a day: login → search for a crash ID → copy the stack trace. His prompt cleverly adds a requirement: "also analyze the stack trace and provide a preliminary assessment of the crash cause." This requirement elevates QoderWork from a simple data mover to a basic diagnostic assistant, performing a first-pass analysis as it extracts the data.

Once you've encapsulated the operation as a skill, you can simply say, "Extract and analyze the stack trace for CRASH-xxx," passing the crash ID as a variable.

Simple, repetitive daily tasks are ideal use cases for browser automation and Skill encapsulation.

Hands-on guide: Getting the most out of QoderWork with folders

This section illustrates the workflow with an example: a teacher managing exam scores for a class.

Working directory importance

QoderWork CN lets you select a local folder as the working directory. Once you do:

• QoderWork CN reads all files directly from the folder, eliminating the need for individual uploads.

• QoderWork CN automatically saves processing results back to the folder, eliminating manual downloads.

• QoderWork CN immediately detects and processes newly added files in the folder.

Just place the files in the correct location and leave the rest to QoderWork CN.

Get started in 3 steps

1. Organize your folders

   Group files by topic or task into a single folder. Use clear folder names and a consistent file naming convention.

2. Select the folder in QoderWork CN

   In QoderWork CN, create a task. In the dialog box, click "Select working directory" and choose your folder. QoderWork CN can then access all files within it.

3. Describe your requirements in natural language

   You do not need to write code or specify a file path. Simply describe your requirements. QoderWork CN automatically identifies and processes the files in the working directory.

Managing class exam scores

In this section, we'll use a teacher scenario to walk you through the entire process, from folder organization to analysis with QoderWork.

Scenario

Ms. Zhang is a middle school math teacher who gets a spreadsheet with her students' scores after each exam. Over the course of the semester, she has collected four of these spreadsheets in a folder. She wants a comprehensive overview of her class's performance to identify improving students, pinpoint those needing extra attention, and track overall class trends.

1. Organize the folder

   Ms. Zhang creates a folder on her desktop named "Grade 8 Class 2-Math Scores" and saves each exam's scoresheet inside:

   desktop/Grade 8 Class 2-Math Scores/
   ├── First Monthly Exam Scores.xlsx
   ├── Midterm Exam Scores.xlsx
   ├── Second Monthly Exam Scores.xlsx
   └── Final Exam Scores.xlsx

   Note

   Include the exam name or date in the filename, such as "2024-03-Monthly Exam Scores.xlsx". This allows QoderWork to automatically analyze the data chronologically.

2. Select the working directory

   In QoderWork, create a task. At the bottom of the dialog box, click "Select working directory" and select the "Grade 8 Class 2-Math Scores" folder.

3. Let QoderWork analyze

   In the dialog box, enter the following:

   Read all exam scoresheets in the folder and perform the following analysis:
   1. For each exam, calculate the class average, highest score, lowest score, and passing rate.
   2. Identify the score trend for each student across all exams.
   3. Find the top 5 most improved students and the top 5 students with the largest score drops.
   4. Generate a visual class performance analysis report.
   5. Provide recommendations for students who require special attention.

   QoderWork automatically reads all Excel files, performs the data analysis, and saves the analysis report to the folder. Ms. Zhang can then open the folder to view the analysis report.

Next steps

After the next exam, Ms. Zhang only needs to:

• Place the new score sheet in the same folder.

• Open QoderWork CN (if the working directory is unchanged, you don't need to reselect it).

• Say, "New exam scores have been added, please update the analysis report."

The entire process takes less than five minutes. As data accumulates, QoderWork CN's analysis becomes increasingly valuable. For example, it can identify a student whose performance has consistently declined since the third exam, enabling early intervention.

More scenarios

The three-step pattern of organizing a folder, selecting a working directory, and performing natural language analysis is ideal for almost any task requiring repetitive processing of similar files:

Role	Folder organization	Example prompt
teacher	Organize report cards by class/semester	"Analyze all report cards and identify students needing attention."
sales	Organize sales reports by month	"Compare sales trends for the last three months and identify the fastest-growing product."
finance	Organize reimbursement forms by month	"Summarize all reimbursements for this quarter and generate a report by expense category."
lawyer	Organize contract files by case	"Review all contracts and list the risk clauses."
operations	Organize data exports by channel	"Merge all channel data and generate an ROI analysis report."
foreign trade	Organize customer data by order	"Read all orders and generate a customs declaration summary."
researcher	Organize research materials by topic	"Organize the core ideas from all papers and generate a literature review."

Folder management

• Follow a naming convention: Include a date or sequence number in your file names, such as 2024-03-Monthly-Exam-Scores.xlsx or 01-First-Monthly-Exam.xlsx. This practice allows QoderWork to automatically determine their order.

• Use one folder per topic: Avoid mixing unrelated files. For example, keeping Chinese scores and math scores in separate folders improves the accuracy of QoderWork's analysis.

• Maintain consistent formatting: Use the same template for similar files. For example, using the same column names—such as Name, Student ID, and Score—across all exam result files enables QoderWork to align the data automatically.

• Use subfolders for organization: For large sets of files, create subfolders organized by date or category. QoderWork can read files within them recursively.

• Build your dataset over time: The more data a folder contains, the more valuable the analysis becomes. Regularly place files in their appropriate folders to streamline future analysis.

Start your first case

1. Organize a folder

   Choose a work scenario, such as monthly reports or exam scores, and gather all relevant files into a folder.

2. Select a working directory

   In QoderWork CN, create a task. In the dialog box, click "Select Working Directory" and select the folder.

3. Start with a use case prompt

   Copy the prompt structure from one of the use cases above and adapt it for your needs.

4. Refine iteratively

   The initial output may not be perfect. Use it to refine the prompt and build a template for your workflow.

5. Encapsulate as a Skill (Advanced)

   For frequently used workflows, consider creating a Skill to build your personal or team toolbox.