Logic

How every Heat Map component is scored β€” plain language, editable in place

Syncing…—Next: 01:00
All logic in sync with the dashboard
Tweak any rule below, then Apply to refresh every Heat Map.
Open full settings
πŸ“¦

Outward

Outward sheet

Did the DB do any outward dispatch?

If the DB ID is found in the Outward sheet β†’ Green. Otherwise β†’ red.

Present in Outward sheetMissing from Outward sheet
🧾

Reconciliation

Reconciliation sheet

Are all line items reconciled?

If every row matches β€œreconciled” β†’ Green. If some are pending β†’ Orange. If no rows exist β†’ red.

All rows reconciledSome rows pendingNo rows for this DB
πŸ’°

Deposit

Deposit sheet

Did cash collection match the deposit?

|cash βˆ’ deposit| ≀ ৳2 β†’ Green. Deposit/cash ratio 80%–100% (excl.) β†’ Orange. Everything else β†’ Red.

Gap ≀ ৳2Ratio 80% – 100%Everything else
🏷️

Over Stock

Over Stock sheet Β· Status column

Is the DB carrying healthy stock cover?

Status β€œon track” β†’ Β· β€œlower stock” β†’ Β· β€œover stock” β†’ . Unknown status β†’ Red.

on tracklower stockover stock
🐒

Slow Moving

Slow Moving sheet

How much aged salable value is sitting at the DB?

Ξ£ aged salable value < ৳1 β†’ . ৳1–৳100,000 β†’ . > ৳100,000 β†’ . Category β€œwinter” excluded.

< ৳1৳1 – ৳100,000> ৳100,000
πŸ”

Stock Audit

Stock Audit sheet Β· most recent Audit_End_Date

Did the latest audit balance check out?

Latest audit's total_balance ≀ 2 β†’ . Otherwise β†’ Red.

total_balance ≀ 2total_balance > 2
↩️

Picklist Return% (Telco)

Picklist Return % sheet

How much picked value is being returned?

Return % = Ξ£ Return Value Γ· Ξ£ Picked Value Γ— 100. < 5% β†’ . 5% – 30% β†’ . β‰₯ 30% β†’ . Scope: BU = β€œdigital”.

< 5%5% – 30%β‰₯ 30%
βš–οΈ

Primary vs Secondary

Primary (Purchase) + Secondary (Sales) sheets

Are secondary sales keeping pace with primary purchase?

Ratio = Secondary Γ· Primary Γ— 100. β‰₯ 90% β†’ Healthy. 50% – 90% β†’ Watch / Warning. < 50% β†’ Critical Leakage.

β‰₯ 90% Healthy50% – 90% Watch/Warning< 50% Critical Leakage
πŸ’³

Payment vs GRN

Primary (Payment) + GRN sheets Β· date-wise cumulative

Is GRN catching up with the payments made?

For each DB, the earliest REQUISITION_CREATION_DATE is treated as the baseline β€” GRNs before that date are excluded. Cumulative GRN Γ· Cumulative Payment Γ— 100 = Coverage %. β‰₯ 90% β†’ Matched. 50% – 90% β†’ Watch / Warning. < 50% β†’ Critical. GRN-only or Payment-only DBs β†’ Red (band label shown in drill-down).

β‰₯ 90% Matched50% – 90% Watch/Warning< 50% Critical / one-sided
🎯

Target vs Achievement

Target Vs Ach_AM sheet

Is the DB on pace with its MTD target?

Score uses MTD_Achieved_Percent from the Target Vs Ach_AM tab. ≀ 85% β†’ Red Β· 86% – 95% β†’ Orange Β· > 95% β†’ Green.

> 95% MTD achieved86% – 95% MTD achieved≀ 85% MTD achieved
🚫

Global Exclusions

Applies to every component

Hide DBs whose name / BU / Sub-BU matches any keyword.

Currently excluding: artisan, national dist, lafz tej, remedist tejgaon, elite narsingdi.

βš–οΈ

Component Weightage

Applied to overall DB compliance score

How much each component contributes to a DB's overall compliance %.

Default share β€” Outward 5%, Reconciliation 15%, Deposit 20%, Over Stock 5%, Slow Moving 5%, Stock Audit 20%, Picklist Return% 10%, Primary vs Secondary 2.5%, Payment vs GRN 2.5%, Target vs Achievement 10%. For DBs where Picklist Return% doesn't apply (non-Telco), that share is redistributed to Outward 10% and Reconciliation 20%.

πŸ”„

Sync Cadence

Auto-refresh + server cache

How often does the dashboard pull fresh data?

Browser auto-refreshes every 60s. The server caches sheet reads for 60s.