Excel Wage & Rent Automation Dashboard

Замовник: AI | Опубліковано: 09.10.2025

I have a basic Excel file that tracks wages and rent payments, but it still relies on manual updates. I’m looking for someone to turn it into a streamlined workbook with simple automation and an at-a-glance dashboard. What I already have • Sample data that shows the columns and layout I’m using. • A clear idea of the wage formula I need (hours worked × hourly rate). What I need you to build • An automated wage sheet that calculates pay instantly when I enter employee details and hours. • A rent-payment tracker on a separate sheet that records each payment date, amount, and running balance. • A summary dashboard that pulls the key numbers—total wages, total rent paid, and any outstanding amounts—into clean visuals and easy-to-read figures. • Basic error checks (for example, highlight hours that exceed a normal range). Deliverable One Excel workbook that includes the wage calculator, rent tracker, and dashboard, ready for me to drop in my real data and start using right away.