Search: "clean code"

#excel #data-cleaning #trim

excel Beginner

Clean Messy Imported Data with Formulas

You are an expert Excel data-cleaning specialist. Help me clean a messy column o...

#excel #lambda #automation

excel Advanced

Write a Reusable LAMBDA Function

You are an expert Excel 365 power user. Help me turn a repetitive calculation in...

Design a Clean REST API Endpoint

You are an API designer. Help me design a REST endpoint for [DESCRIBE RESOURCE/A...

#coding #api #rest

#coding #debugging #troubleshooting

Debug My Code With a Root-Cause Walkthrough

You are a senior software engineer doing a calm, systematic debugging session. I...

excel Advanced

Plan an Excel Macro or Office Script

You are an Excel automation expert. I will describe a repetitive task and you wi...

#excel #automation #vba

#excel #reconciliation #vlookup

excel Beginner

Reconcile Two Excel Lists for Differences

You are an Excel reconciliation helper. I have two lists (for example, a system ...

#email #meeting-notes #follow-up

email Intermediate

Turn Meeting Notes into a Follow-Up Email

You are a meeting-summary assistant. I will paste rough meeting notes and you wi...

#flaky tests #debugging #test reliability

Triage a flaky test that fails 1 in 20 runs

I have a test that fails roughly once every 20 runs. The error message changes —...

#writing #interview #editing

writing Advanced

Turn a chaotic interview transcript into a clean Q&A piece

I will paste a 90-minute interview transcript that is full of 'um's, tangents, a...

#power-query #data-cleaning #pivot

excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#debugging #trace #root-cause

Find the bug by explaining the code back to me

Act as a debugging partner. I will paste code that is misbehaving and tell you t...

#code-review #quality #bugs

Review my code the way a tough reviewer would, before I open the PR

You're a thorough but fair code reviewer. I will paste a change I am about to su...

#coding #testing #unit tests

coding intermediate

Write Unit Tests for My Function

Act as a senior software engineer. Write comprehensive unit tests for this funct...

#excel #power-query #data-cleaning

excel Intermediate

Clean Messy Spreadsheet Data Step by Step

You are a data-cleaning specialist. I have a messy Excel sheet with these proble...

#coding #refactoring #clean-code

Refactor Code for Readability and Reuse

You are a code reviewer focused on maintainability. Refactor this code without c...