# Office & Documents: prompt collection

## Documents & Translation / 1

Goal: create a vendor comparison brief for a project manager using the supplied sources.
First list each source's file name, date, and subject.
Then extract information about deployment, core features, data export,
team collaboration, and cost components.

Return a table:
Dimension | Vendor A | Vendor B | Vendor C | Source location | Follow-up question.

Keep the unit, time period, and applicable conditions with every important number.
Use “Information needed” for fields the material does not answer.
Show differing statements from different sources separately.
Finish with three findings, two tradeoffs, and the questions to resolve next.

## Documents & Translation / 2

Compare the source document with the translation for an international project team.
Apply the preferred terms in the attached glossary.
Preserve product names, variable names, and links.
Focus on numbers, units, dates, names, negation, conditions, and cause-and-effect statements.

Return a review table:
Source passage | Current translation | Suggested translation | Reason | Section.

Then provide a clear, natural revised version using the original heading and list structure.
Expand professional abbreviations on first use and keep later references consistent.

## Spreadsheets & Data Analysis / 1

Inspect the uploaded orders file and produce a data-quality report:
row count, field names and types, date range, missing values,
duplicate order_id values, and entirely identical rows.
Distinguish product lines within one order from duplicate exports.
List affected order identifiers and a proposed action for each issue.
Provide the plan first; wait for me to confirm the calculation rules before cleaning.

## Spreadsheets & Data Analysis / 2

Process the sample file with these rules:
1. Keep one copy of each entirely identical record.
2. Include only orders with status paid or refunded.
3. Net amount = quantity * unit_price - discount - refund.
4. Replace an empty region with Unknown. Group by order_date month.
5. All amounts are USD. Discount and refund are order-level amounts.

Return a cleaning log, cleaned records, monthly totals, and product totals.
Check that the monthly net amounts sum to the detail net total.
Create a monthly net-amount chart and export the CSV files and calculation steps.

## Spreadsheets & Data Analysis / 3

Inspect this workbook and propose which sheets you will read and change.
Preserve the Raw records and create Clean, Summary, Charts, and Readme sheets.
Summary should show monthly order count, merchandise value, discounts, refunds, and net amount.
Use editable charts with a date range and USD units in their titles.
In Readme, document formulas, filters, and next month's replacement and refresh steps.
Let me review the plan before editing. When finished, list the modified ranges.

## Meetings & Action Items / 1

Create project meeting minutes from this transcript.
Start with three sentences describing the meeting's goal and main results.
Organize the rest by agenda topic.

Within each topic, separate confirmed decisions, supporting reasons,
suggestions awaiting confirmation, and information still needed.

Preserve names, dates, amounts, and units.
Attach a timestamp or source passage to each important decision.
Mark information that was not established as “To confirm.”

## Meetings & Action Items / 2

Extract an action list from these reviewed meeting minutes:
Task | Owner | Target date | Completion criterion | Dependency | Reference | Status.

Use a concrete verb and name the deliverable for each task.
Use only owners and dates explicitly established in the discussion.
Write “To assign” for a missing owner and “To schedule” for a missing date.
Place suggestions for consideration in a separate pending-decisions list.
Finish with the fields the meeting chair needs to complete.

## Meetings & Action Items / 3

Write separate English and Chinese follow-up emails from the confirmed action table.
Use this structure: meeting outcome, action table, questions needing a response,
and the next review time.

Preserve names, product names, dates, and links to deliverables.
Provide a clear subject line in each language.
Keep the tone concise and friendly.
Clearly list items still awaiting an owner or a date.