Search: "legacy code"

#code review #pull request #software engineering

ChatGPT Prompt: Code Review Checklist Tailored to PR Diff Analysis

Review this pull request diff and provide structured feedback. [PASTE DIFF OR F...

Refactor a Tangled React Component Into Custom Hooks

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

#coding #react #hooks

#design #design-systems #components

design Advanced

Component Library Naming Convention and Folder Structure

Propose a naming convention and folder structure for a Figma + code component li...

#excel #power-query #data-cleaning

excel Intermediate

Convert a Messy Paste from PDF into a Clean Table

I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...

#react #performance #virtualization

coding advanced

React Performance Optimization Techniques for Large Lists

Optimize a React application that renders a large list of [data type, e.g., 10,0...

excel advanced

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

#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 ...

#ab testing #statistics #significance

data Advanced

A/B Test Analysis Statistical Significance Sample Size Calculator

You are a data scientist. Help me analyze an A/B test on [METRIC] comparing [VAR...

#cohort analysis #retention #saas

data Advanced

Cohort Retention Analysis Framework SaaS Product Health

Act as a product analyst. Build a cohort retention analysis for [PRODUCT] using ...

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

excel Advanced

Excel VBA Macro to Email Each Manager Their Filtered Sheet

Write a VBA macro that splits the Master sheet by [Manager Name], saves each man...

#excel #vba #outlook

#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...

#hr #onboarding #new-manager

hr Intermediate

30-60-90 Day Onboarding Plan for a New Manager

Build a 30-60-90 day onboarding plan for a new people manager joining a 6-person...

#memory leak #nodejs #debugging

Debug Memory Leak in Long-Running Node.js Process

I have a Node.js process leaking memory. RSS grows from 200MB to 2GB over 6 hour...

👁 4 views

#coding #refactor #clean-code

Refactor Tangled Function Into Smaller Pure Pieces

Act as a code reviewer focused on readability. Below is a function that has grow...

#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...

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration

#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...

#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...

👁 2 views