DSR Summary (Frontend-only)

1) Inputs

Current month report (CSV) Columns expected: Date, Receipt number, BRAND, Quantity, MRP, LINETOTAL Last year same month (CSV) Saved in browser after load (so next time it auto-loads without re-upload).

Date

Select date Today = selected date. MTD = from month start to selected date. Footfall estimate multiplier If no manual override: Footfalls ≈ Bills × multiplier.

Manual Footfalls (optional) Saved per date in your browser. Manual Walkins (optional) Saved per date in your browser.

Upload current CSV and (optionally) LY CSV. If LY is already saved, you can skip uploading it.

Targets (saved monthly)

These change month-to-month. Once you enter them, they are saved in LocalStorage for that month.

GSV Target Bills Target

Qty Target UPT Target

ATV Target ASP Target

Brand mapping (advanced)

By default this matches your DSR:

RTW → BRAND contains Arvind
USPA → BRAND contains USPA or US POLO OR brand is blank
Fabric → BRAND contains Arvind Store
Tailoring → BRAND contains Studio Arvind
Accessories → BRAND contains Arvind Promo

You can edit these keywords in app.js if needed.

1) Inputs

Date

Targets (saved monthly)

2) Summary