AI Prompt Library - Page 2

You are a patient spreadsheet troubleshooter. This formula in [EXCEL / GOOGLE SHEETS] is not working: [PASTE FORMULA]. It shows [ERROR, e.g. #N/A, #VALUE!, #REF!, wrong result]. The cells it refers to contain: [DESCRIBE DATA]. What I expected: [EXPECTED RESULT]. Explain what the error means, the most likely cause in my case, and the corrected formula. Then list other possible causes to check if the fix does not work, such as numbers stored as text, extra spaces or wrong ranges, and how to spot each one.

Tip: Paste the exact formula and a sample of the data. Try the fixes in order until the error clears.

Act as a data analyst teaching a business owner. I have a sales sheet with these columns: [LIST COLUMNS, e.g. date, city, product, salesperson, quantity, amount]. I want to see [QUESTIONS, e.g. sales by city per month, top 5 products, best salesperson]. Give me step-by-step instructions to build a pivot table for each question in [EXCEL / GOOGLE SHEETS], what to put in rows, columns, values and filters, and how to group dates by month. Then explain how to read the results and suggest one chart for each pivot.

Tip: Make sure your data has one header row and no blank rows before building the pivot table.

You are a business reporting specialist. Help me build a one-page sales dashboard in Google Sheets for my [TYPE OF BUSINESS]. My raw data sheet has columns [LIST COLUMNS]. The dashboard should show: this month's sales vs last month, top products, sales by channel (shop, WhatsApp, Daraz, website, or my channels: [LIST]), average order value and a monthly trend chart. Give me the layout, the exact formulas for each metric (using SUMIFS, COUNTIFS, AVERAGEIFS and similar), chart types to use, and how to add a month drop-down so the dashboard updates automatically.

Tip: Keep raw data on a separate tab and never type into the dashboard tab. Add new sales rows at the bottom of the data sheet.

Act as a payroll assistant for a small business. Create a monthly salary sheet layout for [NUMBER] employees. Columns should include employee name, designation, basic salary, allowances, overtime hours and rate, days absent, deductions for absence, advances taken, tax deduction left as [AMOUNT OR RATE TO CONFIRM], other deductions, net pay and payment method. Give the exact Excel formulas for each calculated column, a summary row for totals, and a simple payslip template that pulls data from the sheet. Remind me to confirm tax and legal deductions with an accountant.

Tip: Keep one tab per month and lock the formula cells. Confirm any tax or contribution deductions with a qualified accountant.

You are a financial analyst helping a small business owner. I am comparing these loan or financing offers: [OFFER 1: AMOUNT, RATE, TENURE, FEES], [OFFER 2 ...], [OFFER 3 ...]. For each, calculate the monthly instalment, total amount repaid and total cost of borrowing, showing the formula (including the Excel PMT function). Put the results in a comparison table. Then explain hidden costs to ask the lender about, whether my business can afford the instalment given monthly profit of [PKR], and questions to ask before signing. This is for understanding only, not financial advice.

Tip: Get the full terms in writing from each lender first. Ask an accountant to review before signing any agreement.

Act as a management accountant. My business is [DESCRIBE]. Monthly fixed costs: [LIST WITH PKR AMOUNTS]. Average selling price per unit or customer: [PKR]. Variable cost per unit: [PKR]. Calculate the contribution margin, break-even point in units and in sales value, and the sales needed to earn a target profit of [PKR] a month. Show every step of the working. Then create a small table showing profit at 50%, 75%, 100%, 125% and 150% of break-even sales, and explain in simple words what I should do if break-even looks too high.

Tip: Include your own salary as a fixed cost for a realistic answer. Rerun whenever rent or prices change.

You are a growth analyst. My business is [SUBSCRIPTION / REPEAT-PURCHASE BUSINESS DESCRIPTION]. Data: monthly marketing and sales spend [PKR], new customers per month [NUMBER], average revenue per customer per month [PKR], gross margin [PERCENT], average customer lifespan or monthly churn [DETAIL]. Calculate CAC, customer lifetime value, the LTV to CAC ratio and the payback period in months, showing the formulas. Explain what healthy numbers usually look like and give 5 practical ways to improve the weakest metric.

Tip: Use at least three months of data for averages. Recalculate by channel to see which marketing works best.

Act as a brand naming specialist. My business: [WHAT IT DOES], customers: [WHO], feel I want: [e.g. modern, trustworthy, desi, playful], languages: [ENGLISH / URDU / BOTH]. Suggest 20 name ideas in 4 styles: descriptive, invented words, Urdu or regional words, and combination names. For each give the meaning and one line on why it works. Avoid names that are hard to spell or pronounce. Then pick the top 5 and give me a checklist to confirm availability: domain, social media handles, and trademark or business name search (I will check these myself).

Tip: Say the shortlisted names out loud to a few customers. Check availability before designing a logo.

You are a positioning expert. My business: [DESCRIPTION]. Target customer: [WHO]. Their main problem: [PROBLEM]. My solution and what makes it different: [DETAILS]. Write: a one-sentence value proposition using the format 'We help [customer] [achieve outcome] by [how], unlike [alternative]', 3 alternative headline versions for my website, a 30-second elevator pitch for networking events, and a 2-line version for my WhatsApp Business and Instagram bio. Avoid buzzwords and vague claims like 'best quality'.

Tip: Test the pitch on people who do not know your business and ask them to repeat what you do.

Act as a startup mentor. Help me complete a Lean Canvas for my idea: [DESCRIBE IDEA]. Fill each of the 9 boxes: problem, customer segments, unique value proposition, solution, channels, revenue streams, cost structure, key metrics and unfair advantage. Keep each box to 2-4 short bullets. Where you are guessing, mark the bullet with (assumption). Then list the 3 assumptions I should test first and suggest a quick experiment for each. Present the canvas as a table.

Tip: Update the canvas each time you learn something new from customers. Keep old versions to see how the idea evolved.

You are a business acquisition advisor. I am thinking of buying an existing [TYPE OF BUSINESS] in [CITY] for [ASKING PRICE]. The seller says monthly sales are [PKR] and profit is [PKR]. Give me a due diligence checklist: which records and documents to ask for, how to check that sales figures are real (e.g. observe footfall, check bank statements and supplier bills), questions about lease, staff, debts and licences, and red flags. Then explain simple ways to judge whether the price is fair, such as a multiple of yearly profit, and what to negotiate. Remind me to involve a lawyer and accountant.

Tip: Never pay a deposit before checking the records. Spend a few days observing the business in person.

Act as a marketing strategist. My business sells [PRODUCT/SERVICE] in [MARKET, e.g. Karachi, all of Pakistan, overseas Pakistanis]. Here is what I know about my customers: [DETAILS FROM SALES, CHATS, REVIEWS]. Create 3 distinct customer personas. For each give: a name and short background, age range and occupation, goals, frustrations, where they spend time online, how they make buying decisions, objections to buying, and the message most likely to convince them. Base them only on the patterns I have given, and flag anything that is a guess.

Tip: Use real customer conversations as input. Match each ad or post to one persona rather than everyone.

You are a customer experience researcher. Create a short feedback survey for customers of my [BUSINESS] who recently [BOUGHT / VISITED / USED SERVICE]. Keep it to 6-8 questions that take under 2 minutes: one overall satisfaction or Net Promoter Score question, questions about quality, price, speed and service, one open question, and an optional contact permission question. Use simple wording and avoid leading questions. Provide the survey in English and suggest how to share it (Google Forms link on WhatsApp, QR code at the counter). Add a template to summarise the results each month.

Tip: Build it in Google Forms and share right after a purchase. Act on at least one piece of feedback each month.

Act as a retail marketing consultant. I own a [TYPE OF SHOP, e.g. bakery, pharmacy, salon] in [AREA, CITY] with about [NUMBER] regular customers. Design a simple, low-cost loyalty programme. Compare 3 options (stamp card, points on WhatsApp, member discount day) in a table showing cost, ease of running and likely impact. Recommend one and explain the rules, reward levels, how to track it without expensive software, and how to calculate if it is profitable. Write the announcement message for customers under 60 words.

Tip: Start small and run it for three months before changing the rewards. Track how many customers return.

You are a customer service expert. A customer has asked for a full refund for [PRODUCT/SERVICE] because [REASON]. Under our policy, [WHAT WE CAN AND CANNOT OFFER]. Write a reply that thanks them, shows understanding, explains the policy clearly without sounding defensive, offers the best alternative we can (e.g. exchange, partial refund, store credit, repair), and makes the next step simple. Keep it under 130 words. Also give me 2 lines I can say if the customer calls and gets upset.

Tip: Stay consistent with your written policy. If the customer has a genuine point, consider making an exception.

Act as a customer service trainer for retail staff in Pakistan. Create a 45-minute training session for [NUMBER] staff at my [TYPE OF SHOP]. Include: session goals, a warm-up activity, 5 key behaviours (greeting, listening, product knowledge, handling complaints, closing the sale politely), 3 role-play scenarios with a customer script for each, dos and don'ts, and a short quiz. Keep the language simple and give key phrases in both English and Urdu script so staff can use them naturally.

Tip: Run the role-plays with real situations from your shop. Repeat a short refresher every month.

You are a procurement specialist. I need to choose a supplier for [PRODUCT/MATERIAL]. I have these options: [LIST SUPPLIERS WITH KNOWN DETAILS: PRICE, MINIMUM ORDER, LEAD TIME, PAYMENT TERMS, QUALITY NOTES]. Create a supplier scorecard with weighted criteria (price, quality, reliability, lead time, payment terms, communication, flexibility). Score each supplier from my details and mark missing info as [ASK SUPPLIER]. Show totals in a table, recommend one, and list 8 questions to ask each supplier before placing a trial order.

Tip: Place a small trial order with the top two before committing. Rescore suppliers every six months.

Act as a purchasing manager. Write a request for quotation (RFQ) that I can send to [NUMBER] suppliers for [PRODUCT/SERVICE]. Include: a short introduction to my company [DETAILS], exact specifications [SPECS], quantity and delivery schedule, delivery location [CITY], quality or sample requirements, payment terms I prefer, the format I want prices in (unit price, taxes shown separately, delivery charges), the deadline for replies [DATE], and a contact person. Keep it clear and formal, under 250 words, so that all quotations come back in a comparable format.

Tip: Send the same RFQ to every supplier so quotes are easy to compare in one table.

You are a firm but professional operations manager. Our supplier [SUPPLIER NAME] delivered [ORDER DETAILS] [LATE BY X DAYS / WITH THESE FAULTS: DETAILS]. This caused [IMPACT ON OUR BUSINESS]. Write an email that states the facts clearly with order references, explains the impact, requests a specific remedy (replacement, discount, credit note, or faster delivery) by [DATE], and asks what they will change to prevent it happening again. Keep the relationship intact. Under 200 words. Also give a short WhatsApp version for the supplier's sales contact.

Tip: Attach photos and delivery notes as evidence. Keep a record of repeated issues for future negotiations.

Act as an HR officer. Draft a job offer letter from [COMPANY] to [CANDIDATE NAME] for the position of [JOB TITLE]. Include: a warm opening, start date, reporting manager, work location and hours, salary [PKR] and payment schedule, benefits, probation period [DURATION], notice period [DURATION], documents to bring on day one, and an acceptance deadline with how to accept. Keep it professional and friendly, one page long. Add a note that the final employment contract should be reviewed by a legal or HR professional.

Tip: Replace all brackets with confirmed terms. Send with a separate employment contract where required.

You are an HR communications writer. Write 3 rejection message templates for candidates who applied for [JOB TITLE] at [COMPANY]: one for applicants not shortlisted, one for candidates rejected after an interview, and one for a strong final-round candidate we want to keep in touch with. Each should be respectful, brief (under 100 words), thank them for their time, and avoid giving false hope. For the post-interview version, include an optional line with 1-2 pieces of constructive feedback I can fill in.

Tip: Send rejections within a week of your decision. Candidates remember how you treated them.

Act as an HR adviser focused on fair treatment. An employee, [NAME, ROLE], has [ISSUE, e.g. been late 8 times this month / broken a safety rule]. Previous conversations: [DATES AND WHAT WAS SAID]. Write a formal written warning that states the facts with dates, refers to the relevant company rule, explains the expected improvement and timeline, mentions the support available, states the possible consequences if there is no improvement, and gives space for the employee to respond and sign. Keep the tone neutral, not insulting. Remind me to follow my written policy and check with an HR or legal professional.

Tip: Talk to the employee in person before handing over the letter. Keep a signed copy on file.

Act as an HR policy writer. My company [NAME] has [NUMBER] staff, and I want to allow [REMOTE / HYBRID] work for roles like [ROLES]. Write a clear policy covering who is eligible, required office days, working hours and availability, communication tools and response times, internet and power backup expectations, data security and use of personal devices, how performance is measured, equipment and allowances [IF ANY], and how the arrangement can be changed or ended. Keep it to about one page with headings and suggest a short agreement form employees sign.

Tip: Pilot the policy with one team for a month and collect feedback before rolling it out.

You are an HR consultant helping a company of [NUMBER] staff in [INDUSTRY] create its first employee handbook. Create a detailed table of contents with 12-15 sections (welcome and values, hiring and probation, working hours, pay, leave, conduct, safety, IT and data, benefits, performance, grievances, disciplinary process, leaving the company, and others you think fit). Under each section, list the key points it should cover and questions I must decide as the owner. Flag sections that need legal review. Keep it practical, not corporate jargon.

Tip: Write one section per week using this outline. Get the finished handbook reviewed by an HR or legal professional.

Act as a project coordinator who writes clear updates. Here are my rough notes for this week: [PASTE NOTES]. Turn them into a weekly status update for [MANAGER / CLIENT] with these sections: overall status (on track, at risk or off track with a one-line reason), completed this week, planned for next week, risks or blockers and what help I need, and key numbers [IF ANY]. Keep it under 200 words and use bullet points. Do not exaggerate progress; if something is late, say so clearly with a new expected date.

Tip: Send updates on the same day each week. Being honest early about delays builds more trust than surprises later.

You are a coach for overworked small business owners. Here is a list of everything I do in a typical week with rough hours: [LIST TASKS AND HOURS]. My team includes [PEOPLE AND ROLES]. Sort my tasks into a table with 4 groups: only I should do, delegate to staff, outsource, and stop doing. For each task to delegate, suggest who takes it, what training or SOP they need, and how I will check the work without micromanaging. Calculate how many hours per week I will free up and suggest the highest-value way to use them.

Tip: Track your time honestly for one week first. Delegate one task at a time and give it a month to settle.

Act as a performance management consultant. My business is a [TYPE OF BUSINESS] with [NUMBER] staff and my main goal this year is [GOAL]. Suggest 8-10 key performance indicators across sales, customers, operations, finance and team. For each give: what it measures, the formula, how often to track it, where the data comes from, and a warning level. Then pick the 5 most important ones for a weekly owner review and show a simple one-page tracking template.

Tip: Track fewer numbers well rather than many badly. Review the five core KPIs every week at the same time.

You are a risk management adviser for small and medium businesses. My business is [DESCRIPTION] in [CITY]. Identify 12-15 realistic risks across categories such as financial, supplier, staff, legal and compliance, technology, security, reputation, and external events (e.g. price inflation, currency changes, power outages, floods, road closures). Present a risk register table with columns: risk, category, likelihood (1-5), impact (1-5), risk score, early warning sign, prevention action, response plan and owner. Sort by risk score, highest first.

Tip: Review the register every quarter and update scores. Assign a real person as owner for each top risk.

Act as a business continuity planner. My business [DESCRIBE] depends on [KEY THINGS, e.g. electricity, internet, one supplier, delivery riders, a key staff member]. Create a simple continuity plan for these scenarios: long power outages, internet failure, main supplier failure, city-wide strikes or road closures, key person unavailable, and data loss. For each give: impact, immediate actions in the first hour, backup options, who is responsible, and what to prepare in advance. Include an emergency contact list template and a data backup checklist.

Tip: Test one scenario every few months, such as a day working without internet. Keep a printed copy at the business.

You are a restaurant operations manager. My restaurant opens [DAYS AND HOURS], and the busiest times are [PEAK TIMES]. I have these staff: [LIST NAMES/ROLES AND AVAILABILITY]. Each person should work about [HOURS] per week with [DAYS OFF] days off. Create a fair weekly rota as a table showing shifts for each person, making sure peak times have enough kitchen and floor staff. Point out any gaps or overtime. Then give a template I can reuse each week and tips for handling shift swaps, Ramadan timings and Eid holidays fairly.

Tip: Share the rota with staff at least a few days in advance. Adjust for special days like Ramadan iftar rush.

Act as a local marketing planner. I am opening a [TYPE OF SHOP/RESTAURANT] in [AREA, CITY] on [DATE] with a budget of [PKR]. Create a grand opening plan: a 3-week countdown timeline, pre-opening buzz on WhatsApp, Instagram and Facebook, local flyer or banner ideas, an opening-day offer, a simple event plan for the day, staff preparation, and how to collect customer numbers for future offers (with permission). Include a budget split table and 3 social media post captions. Keep ideas realistic for a small business.

Tip: Start the countdown at least three weeks early. Make sure stock and staff are ready before promoting heavily.

You are an operations consultant for service businesses such as salons, clinics and tutors. My business: [TYPE] with [NUMBER] staff, services [LIST WITH TIME TAKEN]. Problems: [e.g. double bookings, no-shows, long waits]. Design a simple appointment system: booking channels (WhatsApp, phone, online form), a booking sheet layout, time slot rules including buffer times, confirmation and reminder messages (write them), a no-show and late cancellation policy, and how to handle walk-ins. Suggest what to look for in booking software if I outgrow the manual system.

Tip: Send reminders the day before each appointment. Track no-shows for a month to see if the policy works.

Act as an education business consultant in Pakistan. I want to start a tuition academy in [AREA, CITY] for [LEVELS, e.g. matric, FSc, O and A levels, entry test preparation]. Help me plan: which subjects and batches to start with, how to find and pay teachers (fixed salary vs revenue share), fee structure left as [PKR], timetable, space and equipment needs, marketing to parents and students, attendance and progress reports for parents, and a first-year budget template. Include a list of local permissions or registrations I should ask about (without stating specific laws).

Tip: Start with two or three strong subjects. Collect feedback from parents after the first month.

You are a conversion rate specialist for e-commerce stores. Here is the content of one of my product pages on [SHOPIFY / DARAZ / MY WEBSITE]: title [TITLE], price [PRICE], description [DESCRIPTION], photos [DESCRIBE PHOTOS], reviews [NUMBER], delivery info [DETAILS], and other elements [LIST]. Audit it against best practice: clarity, trust signals, photos, pricing display, urgency, mobile readability, and delivery and return information. Give a score out of 10 for each area in a table, then list the top 7 changes in order of likely impact, and rewrite the description.

Tip: Audit your best-selling product first. Make one change at a time so you can see what moves sales.

Act as an e-commerce retention marketer. Customers add items to cart on my store [STORE NAME] selling [PRODUCTS] but do not complete the order. Write an abandoned cart sequence of 3 messages for [EMAIL / WHATSAPP / SMS]: a gentle reminder after 1 hour, a helpful message after 24 hours answering common doubts (delivery time, cash on delivery, returns), and a final message after 48 hours with an optional offer [OFFER]. Keep each under 60 words, friendly and not pushy. Include [CUSTOMER NAME] and [PRODUCT] placeholders and tell me which one to test first.

Tip: Only message customers who agreed to receive messages. Measure how many carts each message recovers.

You are an e-commerce campaign planner for Pakistani online sellers. I sell [PRODUCTS] on [DARAZ / SHOPIFY / INSTAGRAM] and want to plan a sale for [OCCASION, e.g. Eid ul Fitr, 11.11, winter season, back to school] starting around [DATE]. Create a 4-week campaign plan: stock planning based on last year's sales [DATA IF ANY], offer ideas that protect margin, courier and packaging preparation, a content calendar for social posts, ad budget split [PKR], and a post-sale review checklist. Show the plan as a week-by-week table.

Tip: Order extra stock and confirm courier capacity early; delivery delays before Eid are common.

Act as a sourcing advisor for small online resellers. I want to resell [PRODUCT CATEGORY] and I am considering buying from [LOCAL WHOLESALE MARKETS / MANUFACTURERS / IMPORT PLATFORMS]. Explain how to: shortlist products with good margin and low return risk, check quality before a bulk purchase, negotiate minimum order quantity, calculate landed cost per unit (price, transport, customs or duties left as [AMOUNT TO CONFIRM], packaging), and avoid common sourcing scams. Give a landed cost calculation table template and a supplier checklist.

Tip: Always buy a sample first. Confirm any import duties and rules with a customs agent or official source.

You are an export costing specialist. I want to quote a price for [PRODUCT] to a buyer in [COUNTRY] for [QUANTITY]. My costs: production per unit [PKR], packaging for export [PKR], inland transport to port [PKR], documentation and inspection [PKR], freight forwarder charges [AMOUNT], insurance [AMOUNT], bank charges [PERCENT], and my target margin [PERCENT]. Build a costing table that calculates EXW, FOB and CIF prices per unit, and convert them to [USD/EUR] at an exchange rate of [RATE] I will enter. Include formulas I can use in Excel and explain each price term simply.

Tip: Update the exchange rate on the day you quote. Ask your freight forwarder to confirm freight and port costs.

Act as a trade research analyst. I produce [PRODUCT] in Pakistan and want to find the 3 best export markets to target first. Help me build a market selection framework: criteria to compare (demand, competition, distance and shipping, trade agreements, standards and certifications needed, payment risk, cultural fit), where to find reliable data for each (trade statistics portals, trade attaches, chambers of commerce, trade fairs), and a scoring table for up to 6 countries I choose: [LIST COUNTRIES]. Do not invent statistics; show where I should look them up.

Tip: Use Perplexity or official trade portals to gather data, then paste it back in to fill the scoring table.

You are a startup founder coach. Help me write a monthly investor update for [STARTUP NAME] for [MONTH]. My notes: key metrics [REVENUE, USERS, GROWTH, CASH, BURN, RUNWAY], wins [LIST], challenges [LIST], team changes [LIST], and asks [e.g. introductions, hiring help]. Structure it as: a 3-line summary, metrics table vs last month, highlights, lowlights and what we are doing about them, and specific asks. Keep it under 350 words, honest and easy to skim. Do not hide bad news.

Tip: Send updates every month, even bad ones. Investors help more when they know the real situation.

Act as a startup operations adviser. An investor wants to do due diligence on my startup [NAME, STAGE, SECTOR]. Create a checklist of documents and information I should organise into a data room, grouped into: company and legal, founders and team, financials, product and technology, customers and sales, intellectual property, and contracts. For each item say why investors ask for it and mark which ones are usually needed at [MY STAGE]. Add tips on naming and organising folders. Remind me to have a lawyer review legal documents.

Tip: Start collecting documents before you start fundraising. A well organised data room speeds up the deal.

You are a grant and competition application writer. I am applying to [PROGRAMME NAME] which asks these questions: [PASTE APPLICATION QUESTIONS AND WORD LIMITS]. My startup: [DESCRIPTION, PROBLEM, SOLUTION, TRACTION, TEAM, IMPACT]. Draft an answer for each question that stays within the word limit, uses specific evidence instead of hype, and ties back to the programme's goals: [PROGRAMME GOALS]. After the drafts, list any weak points a judge might notice and what extra evidence would help. Keep all claims truthful.

Tip: Paste the exact questions and limits. Edit the drafts in your own voice before submitting.

Act as a neutral startup mentor. My co-founders and I are deciding how to split equity. Here is each person's situation: [FOR EACH: ROLE, TIME COMMITMENT, MONEY INVESTED, IDEA OR IP, EXPERIENCE, SALARY TAKEN]. Give us a structured framework to discuss this fairly: factors to weigh, a simple scoring exercise, typical reasons for equal vs unequal splits, and why vesting with a cliff protects everyone. Show an example split based on our inputs as a starting point only. List the questions we must agree on and remind us to put the final agreement in writing with a lawyer.

Tip: Do the scoring exercise together in one meeting. Agree on vesting before anyone starts full-time.

You are a business development adviser. My company [NAME] wants to work with [PARTNER COMPANY] on [COLLABORATION, e.g. joint marketing, distribution, supply]. Create an outline of what our memorandum of understanding should cover: purpose, responsibilities of each party, contributions, revenue or cost sharing, duration, confidentiality, use of brand names, how either side can exit, and how disputes will be discussed. Under each heading list the questions we should agree on. State clearly that this is a discussion outline, not a binding legal document, and should be reviewed by a qualified lawyer.

Tip: Agree on the business points with your partner first, then take the outline to a lawyer to draft properly.

Act as a business adviser for freelancers and small agencies in Pakistan working with local and foreign clients. I provide [SERVICE] to [CLIENT TYPE]. Create an outline of the key terms my client agreement should cover: scope of work, deliverables and revisions, timelines, fees and payment milestones [PERCENT ADVANCE], currency and payment method, late payment, change requests, ownership of work and when it transfers, confidentiality, cancellation, and communication. For each term, explain the risk if it is left out. Note that this is an outline to review with a lawyer, not a finished contract.

Tip: Use this to prepare questions for a lawyer or to check a client's contract. Platforms like Fiverr have their own terms that also apply.

You are a business coach running an annual review with an owner. Here is my data for [YEAR]: revenue [PKR], profit [PKR], customers [NUMBER], best and worst products or services [LIST], biggest wins [LIST], biggest problems [LIST], and team changes [DETAILS]. Guide me through a structured year-end review: what worked, what did not, what I learned, which activities gave the best return, what to stop, start and continue. Then help me set 3 goals for next year with quarterly milestones, presented as a table.

Tip: Block two quiet hours for this. Share the goals with your team so everyone pulls in the same direction.

Act as a cost reduction consultant. Here are my monthly business expenses: [PASTE LIST WITH PKR AMOUNTS]. My business is [DESCRIPTION]. Group expenses into categories and show each as a percentage of total. Identify the 5 areas with the biggest savings potential and suggest specific actions for each (renegotiating, switching suppliers, reducing waste, energy saving, solar or backup options to research, cancelling unused subscriptions). Estimate possible savings as a range, and flag any cuts that could hurt quality, staff morale or customers.

Tip: Paste at least three months of expenses for a clearer picture. Make cuts one at a time and watch the effect.

You are a sales operations specialist for small B2B businesses. I sell [PRODUCT/SERVICE] to [CLIENT TYPE] and track leads on WhatsApp and memory, which is messy. Design a sales pipeline tracker in Google Sheets or Excel with columns for lead name, company, contact source, stage (new, contacted, meeting, proposal, negotiation, won, lost), deal value in PKR, next action and date, owner and notes. Give formulas for total pipeline value by stage, win rate, and overdue follow-ups, plus conditional formatting rules to highlight them. Add a weekly 20-minute review routine.

Tip: Enter every lead the same day it comes in. Sort by next action date each morning.

Act as a B2B proposal writer. I am pitching [SERVICE/PRODUCT] to [CLIENT COMPANY], who need [CLIENT'S PROBLEM OR REQUIREMENT, from our meeting notes: PASTE NOTES]. Write a proposal with: a cover page line, executive summary focused on the client's goals, understanding of their needs, proposed solution, deliverables and timeline table, pricing options [PRICES], why choose us with relevant experience [DETAILS], terms, and next steps. Keep it under 900 words and use the client's own words from the meeting where possible. Do not include claims I have not given you.

Tip: Send within 48 hours of the meeting while interest is high. Follow up with a call two or three days later.

You are a data cleaning expert in [EXCEL / GOOGLE SHEETS]. My customer or sales sheet has these problems: [e.g. duplicate customers, phone numbers in different formats like 0300 and +92300, names in mixed case, extra spaces, dates stored as text, city names spelled differently]. Here are 5 sample rows: [PASTE ROWS]. Give me step-by-step fixes with exact formulas (TRIM, PROPER, SUBSTITUTE, TEXT, DATEVALUE, UNIQUE, or others as needed), how to remove duplicates safely, and how to standardise city names. Tell me to keep a backup copy before making changes.

Tip: Work on a copy of the sheet. Paste real sample rows with personal details changed.

Act as a patient programming mentor. I am a complete beginner who wants to learn Python in 12 weeks while studying or working, with about [HOURS PER WEEK] hours a week. My goal is [GOAL, e.g. data analysis job, freelancing, automating office work]. Create a week-by-week plan in a table with columns: Week, Topics, Free resources to use, Mini project, How I know I am ready to move on. Keep topics in a logical order (variables, loops, functions, files, libraries, and so on). End with three common mistakes beginners make and how to avoid them. Ask me two questions first if my goal is unclear.

Tip: Replace the hours and goal with your real situation. After you get the plan, ask the AI to expand any single week into daily tasks.

You are a teacher who explains programming to people with no technical background. Explain the Python concept [CONCEPT, e.g. list comprehensions, dictionaries, classes, decorators] to me. Structure your answer as: 1) a one-line plain definition, 2) a real-life analogy from daily life in Pakistan (a bazaar, a cricket match, a school register, or similar), 3) the smallest code example possible with comments on every line, 4) one slightly bigger example, 5) two practice questions for me to try, without the answers. Keep the whole thing under 350 words.

Tip: Try your own answers to the practice questions, then paste them back and ask the AI to check them and explain any mistakes.

Act as a Python coding coach. My current level: [LEVEL, e.g. I know loops and functions but not classes]. Give me 8 practice exercises that increase in difficulty, each with: a short problem statement, sample input and expected output, and a hint hidden under the label 'Hint:'. Do not give full solutions. Make at least three exercises about real situations such as calculating a utility bill, splitting a restaurant bill between friends, or tracking monthly expenses in PKR. After I send my solutions, review each one for correctness, readability and edge cases.

Tip: Solve the exercises in your own editor first, then paste your code back in one message for review.

You are a senior JavaScript developer teaching a junior. Explain how promises, async and await work in JavaScript, and why my code sometimes runs in an unexpected order. Use a simple timeline diagram in text form to show what the event loop does. Then take this snippet of mine and explain exactly what happens line by line and in what order the output appears:

[PASTE YOUR CODE]

Finally, rewrite it in the clearest modern style and list the two most common async mistakes to watch out for.

Tip: Paste a real snippet that confused you. If you have none, ask the AI to invent a confusing example and walk through it.

Act as a coding mentor who guides without doing everything for me. I want to build [PROJECT, e.g. a to-do list, a PKR to USD converter with manually entered rates, a quiz app] using plain HTML, CSS and JavaScript, no frameworks. Break the project into 6 to 8 small milestones. For each milestone give: what to build, which DOM methods or concepts I will need, and a test I can do in the browser to confirm it works. Only show code if I ask for it. Start with milestone 1 and wait for me to say 'done' before continuing.

Tip: Work through one milestone at a time and paste your code when stuck. This builds real skill instead of copying a finished app.

You are a WordPress developer teaching PHP to someone who already builds WordPress sites with page builders but has never written code. Teach me only the PHP I need to safely edit a child theme: variables, arrays, if statements, loops, functions, hooks (actions and filters) and the template hierarchy. For each topic give a tiny example taken from real WordPress use. Include a warning section on what never to edit directly and how to keep a backup. Finish with a small exercise: add a custom message below every blog post using a hook.

Tip: Practise on a local site (for example with XAMPP or LocalWP), never on a live client site.

Act as a SQL tutor. Create a small practice database for a general store in [CITY] with tables for customers, products, orders and order_items. Give me the CREATE TABLE statements and INSERT statements with about 10 realistic rows per table, prices in PKR. Then give me 12 questions in increasing difficulty (simple SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOINs, subqueries, one window function). List only the questions first. When I send my query for a question, check it, show the correct version if needed and explain the difference.

Tip: Run the setup script in MySQL, SQLite or an online SQL playground, then answer the questions one by one.

You are an experienced developer helping me understand code I did not write. Language: [LANGUAGE]. Here is the code:

[PASTE CODE]

Please: 1) summarise in three sentences what it does overall, 2) walk through it block by block in plain English, 3) point out any parts that look risky, outdated or confusing, 4) list the external libraries or functions it depends on and what each is for. Assume I know basic programming but not this codebase. Do not rewrite the code unless I ask.

Tip: Paste one function or file at a time for best results. Remove passwords, API keys and client data before pasting.

Act as a tech lead onboarding me to a new project. Below is the folder structure and the main config files of a [FRAMEWORK, e.g. Laravel, React, Django] project I just joined:

[PASTE TREE OUTPUT AND KEY FILES]

Explain: what each main folder is responsible for, where a request or user action enters the app and how it flows through, where I should look to change [SPECIFIC FEATURE], and which files I should avoid touching as a newcomer. Finish with a 5-step checklist for my first week to understand the project safely.

Tip: Generate the folder tree with the 'tree' command (or 'tree /F' on Windows) and paste only the important parts.

You are a Python debugging expert. I got this error:

[PASTE FULL TRACEBACK]

Here is the relevant code:

[PASTE CODE]

My Python version is [VERSION] and I am running it on [OS / environment]. Explain in simple words what the error means, which exact line causes it and why. Give the fix as a corrected code block, then explain how I could have found this myself (which part of the traceback to read first). If there are several possible causes, rank them from most to least likely.

Tip: Always paste the full traceback, not only the last line. Mention if you are using a virtual environment or Jupyter notebook.