Search: "clean code"

#coding #refactoring #solid

Refactor God Object Into Single-Responsibility Classes

Refactor the following large class (>500 lines, multiple responsibilities) into ...

#excel #power-query #data-cleaning

excel Intermediate

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#coding #code-review #communication

coding Intermediate

Coding: Review a PR Whose Author Is More Senior Than Me

Here's a PR from [SENIOR ENGINEER]: [PASTE DIFF]. I have real concerns but I'm s...

#excel #data-cleaning #names

excel Intermediate

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#coding #refactoring #legacy-code

Refactor a 500-Line Function Without Breaking the Three Features That Depend on Its Bugs

I have a 500-line function in production that I need to refactor. The complicati...

#coding #architecture #abstraction

Decide Whether to Extract a Shared Module or Just Copy the Code One More Time

I have a piece of logic that now appears in three places across our codebase. I'...

#business #partnerships #due diligence

business Intermediate

Evaluate a partnership pitch that sounds great in the deck but feels off in the gut

A bigger company pitched me a partnership. The deck shows complementary audience...

#coding #refactoring #legacy

Refactor a 600-line function without breaking the three teams that depend on it

I have a 600-line function that handles order processing. It's been touched by 1...

#LET function #nested IF #refactor

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

#refactor #extraction #legacy code

Pull one function out of a 600-line file without breaking callers

I want to extract one function from a 600-line legacy file into its own module. ...

#power-query #m-language #etl

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda

#coding #code-review #communication

coding Intermediate

Write a code review comment that fixes the bug without making the author defensive

I am reviewing a PR with a real bug — [describe bug]. The author is junior and h...

#coding #refactoring #testing

Refactor a 400-line function without breaking implicit callers

I have a 400-line function that is impossible to test but heavily used. Help me ...

#excel #power-query #office-scripts

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#code-review #feedback #communication

coding Intermediate

Write a code review comment that gets the change improved without making the author defensive

I want to leave a code review comment about [specific concern — naming, design c...

#code-comprehension #review #refactor

Explain what a function does without me reading every line

Act as a senior engineer pairing with me. I will paste a function. Tell me in pl...

Help me write a commit message that explains the why

I'll paste a diff or describe my change. Write a commit message with a concise i...

#coding #git #commits

#excel #pivot table #data cleaning

excel Intermediate

Turn a flat sales export into a pivot-ready table

I have a raw sales export with merged headers, blank rows, and totals mixed into...

Write commit messages that explain the why

I'll paste a diff or describe a change I just made. Write a commit message with ...

#coding #git #commits

#coding #debugging #learning

Explain Unfamiliar Code Line by Line

You are a patient senior engineer mentoring a junior developer. I will paste a b...

#coding #git #version control

Write a Clear Git Commit Message and PR Description

Act as an experienced open-source maintainer who values clean project history. I...

#data #schema #spreadsheet

data Beginner

Design a Clean Data Collection Spreadsheet or Schema

You are a data architect who helps people set up clean data from the start so it...