Search: "legacy code"

#power query #data cleaning #ETL

excel intermediate

Excel Power Query: Clean & Transform Raw Data Automatically

I have raw data in Excel that needs cleaning and transformation. Help me build a...

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

#A/B testing #statistical analysis #hypothesis testing

data advanced

A/B Test Results Analysis: Statistical Significance and Reporting

Help me analyze the results of an A/B test I ran: Experiment name: [name], Test ...

#break-even analysis #financial modeling #startup finance

finance intermediate

Break-Even Analysis: Startup Product Calculation Template

Help me calculate and model the break-even analysis for [product/business type]....

#writing #technical-blog #developer-content

writing intermediate

Technical Blog Post Writing Guide Developer Audience Engagement

Create a guide for writing technical blog posts that developers actually read an...

productivity intermediate

Personal Knowledge Management PKM System Setup Workflow Guide

Build a complete personal knowledge management (PKM) system from scratch using m...

#productivity #pkm #knowledge-management

REST API Design and Documentation Generator

Design and document a RESTful API for my application. Requirements: Application...

#coding #api #rest

#coding #testing #unit-tests

Unit Test Generator for Existing Code

Generate comprehensive unit tests for my existing code. Details: Code to test: ...

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

#accessibility #a11y #wcag

design Intermediate

Accessibility Audit Checklist for Web Pages

You are a WCAG 2.2 accessibility auditor. Audit this web page description: [PAGE...

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

#coding #refactoring #testing

Code Refactoring Plan with Test Coverage Gates and Risk Tiers

You are a senior engineer leading a refactor. I will describe a module that need...

#excel #formula #duplicates

excel Intermediate

Excel Formula to Detect Duplicate Customer Records Across Multiple Columns

Act as an Excel expert. I need a formula that flags duplicate customer rows wher...

#coding #refactoring #clean-code

coding Intermediate

Refactor a God Function with Multiple Responsibilities

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

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#react #component #frontend

ChatGPT prompt for generating a React component from a design specification

Act as a senior React developer who writes clean, accessible, production-ready c...

#debugging #api #rest api

ChatGPT prompt for debugging a REST API that returns 500 errors intermittently

Act as a senior backend engineer specializing in API reliability and debugging. ...

#python #web scraping #beautifulsoup

coding Intermediate

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

#coding #regex #validation

Regex Patterns for Form Data Validation

Provide production-ready regex patterns for validating the following form fields...

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

Git Branching Strategy and Workflow for Development Teams

You are an engineering manager and Git workflow expert. I need to define and doc...

#coding #git #branching

#software license #open source #EULA

legal Intermediate

Software License Agreement: Types, Comparison, and Selection Guide

Help me understand software licensing and choose the right license for my projec...