Store Execution Sheet — ARMOOR

1Change Summary Dashboard

Auto-calculated from the four source tabs (Seasonal → DG → Dept → Article) filtered to this store. Refresh on plan update — no manual counting.

Total Line Changes

437

SKU-level ADD+REMOVE+MODIFY

Additions

24

New SKUs entering fixtures

Removals

48

SKUs dropping off floor

Modifications

365

Fascia space re-allocated

High-Impact Changes

52

|Δ Fascia| ≥ 1.0 unit at article level

Net Fascia Δ

+8.5

Store gains space overall

ADDJUL'26 fascia ≈ 0 → AUG'26 fascia > 0. New listing on the floor.

REMOVEAUG'26 fascia ≈ 0, was live in JUL'26. Pull from fixture.

MODIFYLive in both months, fascia value changed. Adjust space only.

NO CHANGEΔ within ±0.05. No floor action needed — greyed out, filterable away.

2Seasonal Level — Division Roll-up

14 divisions · 6 modified

Highest hierarchy tier. Read this first — it tells the store manager which divisions are gaining or losing floor space this cycle, before drilling into DG/Article detail.

	Division	Floor	Fascia JUL'26	Fascia AUG'26	Δ Fascia	Status
M	Men	2	117.56	151.21	+33.65	Major expansion — largest gainer this cycle
M	Women Ethnic	2	56.94	41.92	-15.01	Major contraction — reset fixtures
M	Infant	2	22.67	17.87	-4.79	Contraction
M	Girls	2	32.39	28.90	-3.49	Contraction
M	Women Western	2	54.05	53.15	-0.89	Minor trim
M	Boys	2	39.86	38.94	-0.92	Minor trim
–	Beauty	2	3.00	3.00	0.00	No change
–	Fashion & Hair	2	3.00	3.00	0.00	No change
–	FMCG	2	2.00	2.00	0.00	No change
+ 5 more no-change divisions (LS Kids, LS Mens, LS Women, LSN Women, Smart Gadget) — hidden by default filter, click "Show all"

3Division-Level Season View

14 divisions × 6 seasons

How each division's AUG'26 fascia splits across seasons — pulled from the same Seasonal tab's BASIC / BASIC FASHION / SUMMER / AUTUMN / PRE WINTER / WINTER columns. Spot divisions carrying heavy PRE WINTER or WINTER weight (new season entering) versus BASIC-only divisions that need no changeover work.

Division	BASIC	BASIC FASHION	SUMMER	AUTUMN	PRE WINTER	WINTER	Total AUG'26	Dominant Season	% Pre Winter/Winter
Men	49.24	35.14	57.63	8.39	0.81	0.00	151.21	SUMMER	0.5%
Women Ethnic	4.15	37.77	0.00	0.00	0.00	0.00	41.92	BASIC FASHION	0.0%
Women Western	20.61	14.68	14.46	3.29	0.11	0.00	53.15	BASIC	0.2%
Boys	7.35	4.82	22.74	3.74	0.28	0.00	38.94	SUMMER	0.7%
Girls	8.26	9.94	6.32	0.90	3.48	0.00	28.90	BASIC FASHION	12.0%
Infant	3.24	0.00	8.71	5.41	0.51	0.00	17.87	SUMMER	2.9%
Beauty	3.00	0.00	0.00	0.00	0.00	0.00	3.00	BASIC	0.0%
Fashion & Hair	3.00	0.00	0.00	0.00	0.00	0.00	3.00	BASIC	0.0%
LS Mens	2.25	0.00	0.00	0.00	0.00	0.00	2.25	BASIC	0.0%
+ 5 more divisions, all 100% BASIC (FMCG, LS Kids, LS Women, LSN Women, Smart Gadget) — no seasonal changeover needed this cycle

Reading this store: Men, Boys and Infant lean hardest into SUMMER; Women Ethnic and Girls carry the most BASIC FASHION weight; nobody is above ~12% PRE WINTER/WINTER yet — this store's next season changeover hasn't landed in the plan in force. The % Pre Winter/Winter column is what flags that shift when it does (highlighted amber at ≥40% in the working sheet).

4DG (Display Group) Level

131 DG lines · 12 add · 2 remove · 99 modify

This is the fixture-planning tier — each row is one display group that maps to a specific gondola/fixture run. Sorted by |Δ Fascia| so the biggest floor-work items surface first.

	Division	Display Group (DG)	DG Code	Floor	Fascia JUL'26	Fascia AUG'26	Δ Fascia
M	Women Ethnic	Coordinated Set-FW [L]	DG1228	2	15.97	5.67	-10.30
M	Men	Casual Shirt FS-Basic[M]	DG1185	2	11.53	18.84	+7.31
M	Men	Polo-T-Shirt-Fashion[M]	DG1195	2	5.62	12.15	+6.53
M	Men	Tees-T-Shirt-Fashion[M]	DG1199	2	6.58	11.93	+5.35
M	Men	T-Shirt FS[M]	DG1200	2	2.62	7.89	+5.27
A	Girls	W-Coordinated Set[G]	DG1085	2	0.01	2.65	+2.64
A	Men	Sweatshirt-Men	DG1205	2	0.05	0.63	+0.58
A	Girls	Sweatshirt[GS]	DG1080	2	0.03	0.38	+0.35
A	Girls	Sweatshirt[GJ]	DG1058	2	0.01	0.36	+0.34
A	Infant	W-Pyjama[IB]	DG1149	2	0.00	0.29	+0.29
R	Girls	Capri[GJ]	DG1046	2	0.12	0.01	-0.11
R	Girls	Capris(GS)	DG1062	2	0.11	0.01	-0.10
+ 7 more ADD · 94 more MODIFY · 18 NO-CHANGE lines below default view — expand via the DG filter dropdown

5Department Level

167 dept lines · 13 add · 2 remove · 116 modify

Sits between DG and Article — carries Season Flag and Dept Grade, so the team can see whether a change is season-driven (new AUTUMN/PRE WINTER line entering) or a grade re-rank.

	Section	Department	Season Flag	Grade	Fascia JUL'26	Fascia AUG'26	Δ Fascia
M	Fusion Wear	Coordinated Set-FW-Women	BASIC FASHION	B	15.97	5.67	-10.30
M	Mens Upper	Casual Shirt FS-Basic-Men	BASIC FASHION	A+	11.53	18.84	+7.31
M	Mens Upper	Polo-T-Shirt-Fashion-Men	SUMMER	A+	5.62	12.15	+6.53
M	Mens Upper	Tees-T-Shirt-Fashion-Men	SUMMER	A+	6.58	11.93	+5.35
A	Girls Senior	W-Coordinated Set[G]	PRE WINTER	D	0.01	2.65	+2.64
A	Mens W-Wear	Sweatshirt-Men	PRE WINTER	A+	0.05	0.63	+0.58
A	Girls Senior	Sweatshirt[GS]	PRE WINTER	B	0.03	0.38	+0.35
R	Girls Junior	Capri[GJ]	SUMMER	D	0.12	0.01	-0.11
R	Girls Senior	Capris(GS)	SUMMER	D	0.11	0.01	-0.10
+ 10 more ADD · 112 more MODIFY · 36 NO-CHANGE lines — full list in "Dept — All" filtered view

6Article (SKU) Level — Floor Action List

593 SKU lines · 24 add · 48 remove · 365 modify

The tier store execution teams actually work from. One row = one physical pick/pack/place task. FDU Status tells the associate the fixture type; sort by tag to batch REMOVE tasks first, then ADD, then MODIFY.

	Department	Article Name	Type	Season	Grade	Fascia JUL'26	Fascia AUG'26	Δ Fascia	FDU
A	W-Coordinated Set[G]	EXCLUSIVE-[GWCS04]	EXCLUSIVE	PRE WINTER	D	0.01	2.65	+2.64	VDU
A	T-Shirt FS-Women	Z_B1G1-T-SHIRT FS[L]	OFFER	AUTUMN	B	0.02	1.05	+1.03	VDU
A	Shorts Woven-Men	POPULAR WOVEN	POPULAR	SUMMER	A	0.04	0.68	+0.63	VDU
A	Sweatshirt-Men	EXCLUSIVE-[MWSS05]	EXCLUSIVE	PRE WINTER	A+	0.00	0.56	+0.56	VDU
R	Formal Shirt FS-Men	ROI_Z-VC-FORMAL SHIRT-NA	VAR CORE	BASIC FASHION	B+	1.12	0.04	-1.08	VDU
R	Trackpant Woven-Men	POPULAR-TEXTILE-[MSPT03]	POPULAR	BASIC	A	1.04	0.01	-1.03	VDU
R	Harem[G]	PROMO HAREM-[GSH07]	OFFER	BASIC	B	0.68	0.03	-0.65	VDU
R	Jeans-Fashion-Men	CARPENTER FIT-MID-[MLJF04]	REGULAR	BASIC	A+	0.65	0.04	-0.61	VDU
M	Coordinated Set-FW-Women	REGULAR-[LECFS02]	REGULAR	BASIC FASHION	B	13.80	1.83	-11.97	VDU
M	Kurta-Women	B1G1-[LUCK06]	OFFER	BASIC FASHION	A+	6.70	2.14	-4.56	VDU
M	Polo-T-Shirt-Fashion-Men	SEAMLESS-HIGH-[MUPTP04]	PREMIUM	SUMMER	A+	0.73	5.27	+4.55	VDU
M	Top-Women	PREMIUM-[LUTP04]	PREMIUM	BASIC FASHION	A	5.16	1.41	-3.75	VDU
+ 20 more ADD · 44 more REMOVE · 361 more MODIFY · 156 NO-CHANGE — full list retained in sheet, default view shows changes only

7Excel Optimization Toolkit

Formulas reference your actual column names — FASCIA AUG 26, FASCIA JULY 26, DIFF FROM PREVIOUS SPACE PLAN — so they drop straight into the existing sheets.

01Change Tag Formula

Drop this in a helper column ("Tag") next to Fascia AUG/JULY. Threshold 0.05 filters out floating-point noise.

fx

=IF([@[FASCIA JULY 26]]<0.05,IF([@[FASCIA AUG 26]]>=0.05,"ADD","NO CHANGE"),
  IF([@[FASCIA AUG 26]]<0.05,"REMOVE",
    IF(ABS([@[DIFF FROM PREVIOUS SPACE PLAN]])>0.05,"MODIFY","NO CHANGE")))

Wrap in a Table (Ctrl+T) first so [@[...]] structured references auto-fill down as new rows land each cycle.

02High-Impact Flag

Surfaces the changes that actually move the floor plan — feeds KPI card 5.

fx=IF(ABS([@[DIFF FROM PREVIOUS SPACE PLAN]])>=1,"⚑ HIGH","")

Article level: threshold 1.0 · Dept level: 2.0 · DG level: 3.0 (space is naturally larger higher up the hierarchy).

03Store-Sheet Extraction (build the per-store tab)

On each store's tab, pull only that store's rows from the master Article-level data dump. Skip FILTER() — it isn't supported by every Excel/LibreOffice build. This INDEX + AGGREGATE pattern works back to Excel 2010, no dynamic arrays needed:

fx

=IFERROR(INDEX(Data_Article!$O:$O,
  AGGREGATE(15,6,(ROW(Data_Article!$A$2:$A$3284)-ROW(Data_Article!$A$2)+1)
  /(Data_Article!$A$2:$A$3284=$C$3),ROWS($A$1:A1))),"")

$C$3 holds the Store name — one dropdown cell drives the whole sheet. Copy the formula down a fixed row window (sized to your largest store); rows beyond the store's actual data just return blank.

03bKeep the Sheet Clean (hide the blanks)

A fixed row window means smaller stores show trailing blank rows. Two fixes, both already in the working template:

fx

Wrap each block in an Excel Table (Ctrl+T)
→ gives a filter dropdown on every column
Pre-hide rows below the current store's row count
→ Home ▸ Format ▸ Hide Rows

When a bigger store needs more rows than are currently shown: select the hidden rows and Unhide, or use the column filter to reveal them.

04Summary KPI Counts

Feed the dashboard cards directly off the Tag column — no manual tally.

fx

=COUNTIFS(Article_Store[Tag],"ADD")
=COUNTIFS(Article_Store[Tag],"REMOVE")
=COUNTIFS(Article_Store[Tag],"MODIFY")
=SUMIFS(Article_Store[DIFF FROM PREVIOUS SPACE PLAN],Article_Store[Tag],"<>NO CHANGE")

8Conditional Formatting Rules

Apply at the Table level (not per-column) so the whole row highlights — easier to scan a printed or projected sheet on the shop floor.

Rule (Formula-based)	Applies to	Format
=$Tag="ADD"	Entire row	Fill #E5F5EC, text #0F7A44, bold
=$Tag="REMOVE"	Entire row	Fill #FBEAE9, text #B3261E, bold
=$Tag="MODIFY"	Δ Fascia cell only	Fill #FBF1DF, text #A8660A
=$Tag="NO CHANGE"	Entire row	Font grey #8B96A4, row height collapsed / grouped
=ABS([Δ Fascia])>=1	Δ Fascia cell	Data bar, purple #6B2FB3 (high-impact emphasis)

✓Filters & Validation

• Table AutoFilter on every sheet — filter Tag to isolate ADD/REMOVE for daily floor-work lists.
• Data-validation dropdown on Task Status column (helper, not in source data): Pending / In Progress / Done — store team ticks off as they execute.
• Freeze panes at row 6 (below KPI+legend) so headers stay visible while scrolling 500+ SKU rows.

✓Pivot Companion

Build one PivotTable off the Article-level table: Rows = Store → Department → Tag, Values = Count of Article Code & Sum of Δ Fascia. Slicer on Store lets a regional manager flip between store sheets from one summary view without opening 601 tabs.

9Scalability — One Sheet, 601 Stores

Your workbook already has 601 stores across the four source tabs. Don't build 601 static sheets by hand — generate them.

Keep 4 master data tabs as-isSeasonal, DG, Dept, Article level stay as the single source of truth — never edited by store teams, only refreshed from the space-plan system.
Build one Template tabEverything above (KPI cards, legend, four tables) lives on one tab called Store_Template, entirely formula-driven off a single input cell (Store name), using FILTER() as shown in Toolkit #03.
Generate per store with Power Query or a short macroA simple VBA loop (or Power Query parameter table) copies Store_Template, renames the tab to the Store name, and hard-sets the input cell — one click produces all 601 store sheets, re-run each cycle to refresh.
Standardize naming & orderTab name = Store name exactly as it appears in column A of the master tabs (case-sensitive match for FILTER/VLOOKUP to work). Order tabs by Region → Zone → Store for the regional manager's mental model.
Lock structure, not dataProtect the sheet layout (headers, formulas, formatting) but leave the underlying master tabs editable — this stops store teams from accidentally breaking the template while still letting planners update source data weekly.
Distribute selectivelyExport each store tab as an individual read-only PDF or a filtered view link for the store team — they don't need to see all 601 stores, only their own.

10Before vs. After

Before — Current State

4 separate flat exports (Seasonal, DG, Dept, Article) with 601 stores mixed together — a store team scrolls thousands of rows to find their own.
No visual distinction between a brand-new SKU, a dropped SKU, and a fascia tweak — all look identical.
"DIFF FROM PREVIOUS SPACE PLAN" column exists but sits buried mid-sheet, easy to miss.
No single number tells a store manager "how much changed this cycle" without manual filtering.

After — Store Execution Sheet

One store, one sheet, everything else filtered out automatically.
ADD / REMOVE / MODIFY tagged and color-coded at every hierarchy level, sorted so the biggest changes surface first.
KPI dashboard gives the manager the headline numbers in under 5 seconds, before reading a single row.
Same structure repeats for all 601 stores — one template, formula-driven, zero manual rebuild per cycle.

ARMOOR SITECODE 10xxxx · CLUSTER LA