მოდული 3

ChatGPT Prompt: "შექმენი Google Sheets formula: მონაცემები: Column A: Product Name Column B: Current Stock Column C: Average Daily Sales (last 30 days) Column D: Lead Time (days from supplier) Column E: Safety Stock Level (days) გამოთვალე: Column F: Reorder Point Column G: Optimal Order Quantity Column H: Status (OK / Low / Critical / Overstock) Status logic: - Critical: stock < 3 days - Low: stock < reorder point - OK: adequate stock - Overstock: stock > 60 days მომეცი ზუსტი formula თითოეული სვეტისთვის"

ChatGPT Prompt: "შექმენი automated weekly sales report template Google Sheets-ისთვის: Input data (Raw): - Date, Product, Quantity, Revenue, Staff Member Generate: 1. Top 10 products by revenue (pivot table structure) 2. Bottom 10 products (slow movers) 3. Staff performance ranking 4. Day-of-week patterns 5. Category performance comparison 6. Average transaction value trend Output: - Pivot tables structure - Conditional formatting rules - Chart recommendations - Executive summary template Formulas უნდა იყოს dynamic - auto-update როცა raw data ემატება"

ChatGPT Prompt: "შექმენი delivery route optimization spreadsheet: Input: - Column A: Customer Name - Column B: Address (district/area) - Column C: Order Size (kg) - Column D: Priority (Normal/Urgent) - Column E: Time Window (Morning/Afternoon) Calculate: - Optimal route sequence (by district grouping) - Estimated time per stop (15 min base + 2 min per 10kg) - Vehicle load optimization (max 500kg per vehicle) - Route assignments (Route 1, 2, 3) - Total estimated time and distance Output: - Driver instruction sheet format - Formulas for all calculations - Conditional formatting (overweight alerts, urgent priority highlighting)"

ChatGPT Prompt: "გადააქციე ეს meeting notes professional minutes-ებად: [paste თქვენი rough notes ან bullet points] ფორმატი: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ MEETING MINUTES Date: [auto-fill based on notes] Attendees: [list from notes] Topic: [extract main subject] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ DISCUSSION SUMMARY [3-5 key points discussed in clear paragraphs] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ DECISIONS MADE 1. [decision] - Impact: [who/what] 2. [decision] - Impact: [who/what] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ACTION ITEMS │ Task │ Owner │ Due Date │ Priority │ ├───────────────────────┼──────────┼──────────┼──────────┤ │ [task 1] │ [name] │ [date] │ [H/M/L] │ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ NEXT STEPS [clear next meeting or follow-up plan] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"

ChatGPT Prompt: "შექმენი employee performance review: Employee: [სახელი] Position: [როლი] Review Period: [თარიღები] Input data: - KPIs: [მიღწეული vs target numbers] - Strengths: [რა კარგად აკეთებს - 3-4 bullet points] - Areas for improvement: [რა საჭიროებს განვითარებას - 2-3 points] - Specific incidents: [პოზიტიური და negative examples] - Goals last period: [შესრულდა თუ არა] Generate: 1. Overall Performance Rating Section - Clear justification 2. Detailed Assessment by Category - Technical Skills (score + explanation) - Leadership & Initiative - Team Collaboration - Customer Focus 3. Key Achievements (3-5 highlights) 4. Development Areas (2-3 constructive points with examples) 5. SMART Goals for Next Period (5 goals) 6. Development Plan (training, mentorship, timeline) Tone: professional, balanced, constructive, specific Format: ready for official HR file Length: 2-3 pages"

ChatGPT Prompt: "შექმენი detailed SOP document: Process: [process name] Department: Gastronome.ge [specify area] Who performs: [role] Frequency: [daily/weekly/as needed] Critical for: [quality/safety/compliance/efficiency] SOP Structure: 1. Purpose (2 sentences - why this process matters) 2. Scope (who, when, where this applies) 3. Step-by-Step Procedure - Numbered steps with clear actions - Sub-steps where needed - Estimated time for each major step 4. Quality Checkpoints - What to verify at key stages - Acceptance criteria 5. Common Mistakes to Avoid - 3-5 frequent errors and how to prevent 6. Troubleshooting - If X happens, do Y 7. Escalation Process - When to call manager/supervisor - Who to contact for specific issues 8. Related Documents & Tools - Links to forms, checklists, systems Format: - Max 2 pages - Visual-friendly (leave space for photos/diagrams) - Clear, action-oriented language - Checkbox format where applicable"