Clean Excel dates and calculate a duration
Normalize mixed date inputs before calculating calendar or working time
A safe conversion and duration method with locale and boundary tests
Open recipeAI tools
Qwen prompt templates for practical work and learning
Explore Qwen prompt templates for writing, analysis, spreadsheets, teaching, planning, business tasks, and personal productivity
Adapt these task-centered templates for Qwen by supplying your real context and checking the stated result criteria. Compatibility is treated as a starting point, while recorded Qwen tests are identified explicitly.
How to use this collection
- Replace every visible placeholder before using a template in 通义千问.
- Review facts, calculations, sources, and consequential decisions outside the model.
Choose a recipe
318Choose mean, median, or quantiles for a spreadsheet metric
Match the summary statistic to the decision, metric scale, distribution, weighting, and tail risk
A justified statistic set with Excel formulas, distribution checks, and interpretation language
Open recipeChoose between VLOOKUP, XLOOKUP, and INDEX/MATCH
Select a lookup pattern from workbook compatibility, match behavior, layout, maintainability, and data risk
A justified lookup choice with formula, alternatives, data checks, and compatibility notes
Open recipeChoose the right chart for spreadsheet data
Match the comparison task and data shape to a chart without distorting scale or uncertainty
A chart recommendation, data layout, labeling rules, and rejected alternatives
Open recipeCheck whether a promotion beats the regular offer
Normalize price, quantity, quality, fees, conditions, timing, rewards, returns, and unused volume before comparing savings
A like-for-like promotion comparison with effective cost, break-even use, caveats, and verification questions
Open recipeCheck understanding with the teach-back method
Test whether a learner can explain, apply, and repair a concept without copying the source
A structured teach-back dialogue with diagnosed gaps, targeted prompts, and a retest
Open recipeCheck understanding with Socratic questions
Probe definitions, reasoning, evidence, boundaries, and transfer one question at a time without supplying the answer
An adaptive question sequence, misconception evidence, hints, and mastery summary
Open recipeCalculate period and cumulative change in Excel
Compare complete periods with explicit baselines, denominators, and missing-period rules
Verified change formulas, comparison table, and boundary checks
Open recipeBuild prioritization criteria for feature requirements
Define evidence-based feature criteria, gates, scales, uncertainty, dependencies, and decision rules before scoring candidates
A calibrated prioritization rubric, evidence contract, scoring table, sensitivity test, and decision log template
Open recipeBuild evaluation criteria for a procurement comparison
Translate business needs, risks, and constraints into observable vendor evaluation criteria before reviewing offers
A review-ready procurement framework with gates, weighted criteria, evidence rules, scoring anchors, conflicts, and governance
Open recipeBuild comparison criteria for a shared family decision
Turn different household needs, constraints, evidence, and decision rights into fair criteria before comparing options
A shared decision contract with gates, criteria, evidence scales, option table, trade-offs, dissent, trial plan, and review trigger
Open recipeBuild character goals, conflict, and change for a story
Connect what characters want, why action is difficult, which choices matter, and how consequences drive change
A character-driven story spine with causal beats, pressure tests, and open choices
Open recipe