Search: "system design"

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 #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#finance #budget #personal-finance

finance Beginner

Build a Personal Monthly Budget

You are a personal-finance coach. Based on the income and expenses I share, help...

data Advanced

Plan a Data Backup and Recovery Strategy

You are a data-resilience consultant. Based on the data and systems I describe, ...

#data #backup #recovery

#education #lesson-plan #backwards-design

education Intermediate

Build a 5-Day Lesson Plan from a Single Learning Objective

Given a single learning objective, design a 5-day lesson plan that progresses fr...

#design #design-system #audit

design Advanced

Design System Component Audit Checklist

Audit the design system component below. Check: naming consistency with the rest...

#reconciliation #matching #accounting

Excel: Reconcile Two Lists That Should Match But Don't

I have two lists — one from our accounting system, one from the bank — that shou...

#coding #debugging #testing

coding Intermediate

Coding: Debug a Test That Passes Locally but Fails in CI

I have a test that passes on my laptop and fails in CI, and I've already tried '...

#hr #onboarding #new-hire

hr Intermediate

HR: Design a 30-60-90 Day Onboarding Plan a New Hire Will Actually Use

I want a 30-60-90 day plan for a new hire that they'll reference, not file away....

#business #pricing #retention

business Intermediate

Raise prices on existing customers without losing them

I need to raise prices on our existing customer base by 15-20%. Costs went up, w...

#excel #charts #visualization

excel Beginner

Pick the chart that tells the story instead of the chart that's easy to make

I have a dataset and I'm about to default to a bar chart because that's what Exc...

#coding #debugging #production

coding Advanced

Diagnose a bug that only shows up in production

I have a bug that only happens in production and never reproduces locally. The s...

#coding #architecture #microservices

coding Advanced

Decide whether this new feature belongs in our existing service or its own

We're about to build a new feature. Someone on the team wants to put it in our e...

design Advanced

Critique a UX mockup using Jobs-to-be-Done framing

I will paste a mockup of [screen]. Help me critique it through a Jobs-to-be-Done...

#design #ux #jtbd

finance advanced

Pick the right metric for a unit that does not fit the company's KPI tree

Act as an FP&A leader. A new business unit does not fit the company's existing K...

#finance #metrics #fpna

#power-query #data-cleaning #pivot

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

productivity intermediate

Design a Weekly Review Routine

Act as a productivity systems expert. Design a 30-minute weekly review routine f...

#productivity #weekly review #systems

#excel #pivot-table #reporting

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

coding Advanced

Design a REST API for a Feature

You are an API designer. Based on the feature I describe, design a clean REST AP...

#coding #api #rest

#data #visualization #charts

data Beginner

Choose the Right Chart for My Data

You are a data-visualization expert. I will describe my dataset and the message ...

productivity Intermediate

Design a Weekly Review Routine

You are a personal-productivity strategist. Help me build a weekly review routin...

#productivity #weekly-review #habits