Prateeka Mogili
Organizing chaos into simple, usable spreadsheets.
New to Contra
Prateeka is building their profile!
Client Order Tracker (B2B)
Built an order management tracker for a wholesale/B2B business — tracks shop name, parts ordered, quantity, and pricing, with dropdown-driven delivery and payment status tracking, full color-coding for at-a-glance status checks, and a SUMIF formula that automatically calculates total outstanding (unpaid) amounts."
1
8
Trip Budget Tracker
Built a categorized expense tracker for trip planning — includes dropdown-based categories (Transport, Food, Vacation, Decor), color-coded spending levels to flag big expenses at a glance, payment method tracking, and an auto-calculating total using SUM formulas.
1
22
Weekly Task & Priority Tracker
Built an interactive task tracker in Google Sheets — includes clickable checkboxes for task completion, color-coded priority levels (High/Medium/Low) using conditional formatting, dropdown menus to keep entries consistent and error-free, a live formula that auto-counts completed tasks, and one-click sorting by priority or day.
1
31