Search: "legacy code"

Refactor a Tangled React Component Into Custom Hooks

Refactor the React component below by extracting state and side effects into cus...

#coding #react #hooks

#coding #debugging #flaky-tests

Diagnose a Flaky Test From Logs Alone

Act as a senior test engineer. The test {{test name}} fails in CI roughly {{freq...

#javascript #refactoring #es2024

Refactor Legacy JavaScript to Modern ES2024 Standards

Refactor the following legacy JavaScript code to modern ES2024 standards: [PAST...

#coding #refactoring #legacy code

Refactor Legacy Function with Tests

Act as a senior engineer. I will paste a legacy function in [LANGUAGE]. Step 1: ...

#invoice #VBA #automation

excel Advanced

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

#data pipeline #monitoring #data quality

data advanced

Data Pipeline Monitoring Alerting Strategy Production

Design a monitoring and alerting strategy for a production data pipeline. My pip...

customer-service Intermediate

Refund Decision Matrix for Support Agents

Act as a head of customer support. Build a decision matrix for refund requests a...

#refund #policy #support

#coding #refactor #clean-code

ChatGPT Prompt: Code Refactor Plan for a Long, Tangled Function

You are a senior engineer guiding a safe refactor. Help me decompose a long, tan...

data Intermediate

ChatGPT Prompt: Exploratory Data Analysis Plan for a New Dataset

You are a senior data analyst. Walk me through a systematic EDA plan for a datas...

#data #eda #analysis

#api design #rate limiting #distributed systems

ChatGPT Prompt: API Rate Limiting Strategy with Multiple Tier Support

Design a rate limiting system for [API SERVICE]. Context: - Tech stack: [LANGUA...

data Intermediate

Build a Pandas Data Quality Report for a Raw CSV Drop

Write a Python script using pandas that takes a CSV path and produces a one-page...

#data #pandas #python

#dates #iso #data cleaning

excel Intermediate

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#exit-interview #turnover #retention

hr intermediate

Employee Exit Interview Framework to Reduce Turnover

Design an employee exit interview program for [company] to extract actionable tu...

#email-design #html-email #newsletter-design

design intermediate

Email Newsletter Design: Responsive HTML Template Best Practices

Help me design and code a high-quality responsive email newsletter template. Con...

#code review #pull request #quality assurance

Code Review Checklist for Pull Request Quality Assurance

Create a comprehensive code review checklist for [programming language/framework...

#power query #excel #data combine

excel Intermediate

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#excel #dynamic-arrays #textsplit

excel Advanced

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

#coding #refactoring #clean-code

Refactor a God Function Into Composable Units

Act as a senior engineer. I'll paste a function that does too much — parses inpu...

design Intermediate

User Flow Diagram for E-commerce Checkout

Map a complete e-commerce checkout user flow including all branching paths. Cont...

#user flow #ux #checkout

#coding #testing #property-based

Generate Property-Based Tests from Spec

Given the function signature and natural-language specification below, generate ...

#code-review #self-review #pr

Coding: Review Your Own PR Before You Send It

Walk through my diff like a reviewer who doesn't know the context. For each file...

#coding #code-review #mentoring

Review a Pull Request From a Junior Developer Without Crushing Their Confidence

I'm reviewing a PR from a junior developer who's been on the team for two months...