Search: "clean code"

#dynamic arrays #FILTER #SORT

excel Intermediate

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#remote work policy #employee handbook #HR policy

hr Intermediate

Remote Work Policy: Employee Handbook Section Design Guide

Help me write a comprehensive remote work policy for our employee handbook. I ne...

#coding #code-review #refactoring

coding intermediate

Code Review and Refactoring Assistant

Please review the following code and provide a comprehensive analysis with refac...

#ip-assignment #intellectual-property #startup-legal

legal advanced

IP Assignment Agreement: Clauses Guide for Startups & Contractors

Draft an IP assignment agreement for my business. Context: My business: [STARTU...

#Docker #Docker Compose #local development

Docker and Docker Compose Setup for Local Development Environment

Create a complete Docker and Docker Compose configuration for a local developmen...

#code-review #pull-request #collaboration

Code Review Comment Drafting Assistant

Act as a senior engineer doing a code review. I will paste a diff. For each subs...

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

#songwriting #lyrics #creative writing

creative Intermediate

ChatGPT Prompt: Songwriting Partner for Lyric Writing with Rhyme Scheme

Help me write lyrics for a song. Details: - Genre: [GENRE] - Mood: [MOOD] - The...

#excel #power query #m code

excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

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

#coding #refactoring #clean-code

Refactor a God Function with Multiple Responsibilities

Below is a function that's grown to ~200 lines and does too much. Refactor it. R...

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

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

#A/B testing #sample size #statistical significance

data Intermediate

A/B Test Sample Size Calculator and Analysis

Help me plan and analyze an A/B test: **Planning Phase:** - Current conversion ...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#chatgpt prompt for excel planner #capacity planning #workload tracker

excel Advanced

ChatGPT Prompt for Creating an Excel Capacity Planner for a Small Team

You are an Excel operations consultant. Build a practical team capacity planner ...

ChatGPT Prompt for Refactor Legacy API Handler Safely

I need help refactoring a legacy API handler without breaking behavior. Here is ...

#coding #refactor #api

#data #survey analysis #qualitative research

data Intermediate

ChatGPT Prompt for Survey Open-Text Response Coding Framework

Analyze these open-text survey responses and build a coding framework I can reus...

#code review #debugging #quality

Coding Advanced

Code Review Assistant

Review this code for: bugs, security issues, performance optimizations, code sty...

#python #web scraping #beautifulsoup

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

#writing #technical-documentation #api

writing intermediate

Technical Documentation for API Endpoints

Write clear technical documentation for the following API endpoint: [paste endpo...

#data #data cleaning #pandas

data Intermediate

Data Cleaning Checklist for Messy Datasets

Create a comprehensive data cleaning checklist and guide for a messy dataset abo...