All projects

Deal Calculator

Dual-mode influencer deal pricing calculator with profile management and Google Sheets sync, running in a Chrome side panel with progressive disclosure UX.

Role

Solo developer

Team

Solo

Duration

2025

Year

2025

Tools

Chrome Extension · React · Side Panel · Calculator · Google Sheets

Deal Calculator hero

What & Why

Pricing influencer deals involves allocating a total budget across multiple platforms (YouTube, Instagram, TikTok) and content types (video, story, reel, post) with different relative values. Without a structured tool, managers use mental math or ad-hoc spreadsheets that don't travel with them. Deal Calculator runs in a Chrome side panel so it's always alongside the CRM or email thread being worked.

Key Features

  • Simple Mode — enter total price + views + content quantities, get instant itemized breakdown using default weights
  • Advanced Mode — full control over per-platform, per-content-type price and views weights (slider-driven)
  • Influencer profiles — searchable dropdown with Name (PROMOCODE) identifiers, per-profile weight presets
  • Deal history — auto-saved per influencer profile; load any past deal by date
  • Responsive layout — stacks vertically as Chrome side panel; two-column layout as web app
  • localStorage persistence — all data stored locally by default
  • Google Sheets sync — optional one-way push of profile + deal history to a linked sheet

Tech & Implementation

Stack: React (or Vue) · Chrome Extension Side Panel API · chrome.storage.local · Google Sheets API · localStorage

Notable decision: The weighted-allocation formula (Price per unit = P_total / Σ(N × W)) distributes total deal value proportionally across all content pieces, making the math auditable and explainable to clients. Simple Mode uses fixed default weights so managers can get a number in under 5 seconds; Advanced Mode exposes the full model for negotiations that need justification.

Outcome

A self-contained pricing tool that demonstrates clean calculator UX design — progressive disclosure (Simple → Advanced), persistent state, and data portability via Sheets. Predecessor concept to DealDash's full deal management system.