How to Track Saudi FMCG Ramadan Targets in a Spreadsheet

Sales to date, divided by the days gone, multiplied by the days in the period.

That one line tells a sales manager whether a Ramadan target will land while there is still time to act.

Across Saudi Arabia, FMCG teams carry some of their biggest monthly targets into Ramadan. This guide builds that daily pace check in a free web spreadsheet, step by step.

After the walkthrough come two days of real figures, the limits of a manual sheet, and how 1Channel tracks the same numbers without retyping.

The method suits FMCG, Consumer Durables, Cosmetics & Personal Care and Pharma field teams that sell against a fixed seasonal target.

A Saudi FMCG sales manager reviewing a Ramadan target spreadsheet on a laptop in a Riyadh distributor office overlooking the warehouse

Why Ramadan Targets Need a Daily Pace Check

Ramadan is one of the two seasonal demand windows Saudi FMCG distributors plan around, along with Hajj. Targets for the month are set high, and the window is short.

A month-end report only says who missed. A daily run rate says who is drifting while two or three weeks are still left to recover.

The question each morning is simple: if every rep keeps selling at today's pace, where does each one finish?

What You Need Before You Start

  • A web browser. EtherCalc runs at ethercalc.net with no sign-up and no install.
  • The number of days your Ramadan target covers, for example 30.
  • Each rep's target for the period in SAR.
  • A daily sales-to-date figure per rep, taken from your order or distributor report.

Step by Step: Build the Tracker in EtherCalc

Step 1: Create a New Spreadsheet

Open ethercalc.net and click Create spreadsheet. A blank grid opens at a new web address, and that address is the sheet.

EtherCalc home page with the Create spreadsheet button highlighted

Step 2: Add the Headers and Period Settings

In row 1, type eight headers: Rep, Territory, Target (SAR), Sales to Date, Daily Rate, Projected, Proj. % and Status.

Off to the side, put the two numbers every formula will share: Period days in K1 (30) and Days gone in K2 (12 on the twelfth day).

EtherCalc sheet with target tracker headers in row 1 and period days and days gone settings in columns J and K

Step 3: Enter Each Rep's Target and Sales to Date

Add one row per rep with their territory, Ramadan target and sales to date. Four reps across Riyadh, Jeddah and Dammam are used here.

In row 6, a Team total line uses SUM to add up the target and sales columns.

Ramadan targets and sales to date in SAR entered for four reps in Riyadh, Jeddah and Dammam, with a team total row

Step 4: Add the Run Rate and Projected Finish

In E2, type =D2/$K$2. This is the average sales per day so far. The dollar signs keep the formula pointing at Days gone when you copy it down.

In F2, type =E2*$K$1. This projects the finish if the rep keeps the same daily pace. Copy both formulas down to row 6.

EtherCalc formula bar showing the daily run rate formula with daily rate and projected finish columns highlighted

Step 5: Flag Who Is Behind

In G2, type =F2/C2 and format it as a percentage. This is the projected finish as a share of target.

In H2, type =IF(G2<1,"Behind","On track") so anyone projected below 100% is labelled. Copy both down.

EtherCalc IF formula labelling reps as Behind or On track from their projected percentage of the Ramadan target

Step 6: Update the Sheet Every Morning

Each morning, raise Days gone by one and overwrite every rep's sales to date. The formulas recalculate on their own.

Share the sheet's web address with the area managers who need to see it.

EtherCalc tracker on day 13 with days gone, updated sales to date and recalculated status highlighted

What the Sheet Showed on Days 12 and 13

On day 12 the team was projected at 101.1% of its SAR 610,000 target. The total said on track, yet two of the four reps were not.

RepTarget (SAR)Projected, Day 12Projected, Day 13Status
Khalid Al-Harbi, Riyadh North180,000162,000 (90.0%)165,000 (91.7%)Behind
Saad Al-Qahtani, Jeddah Central150,000165,000 (110.0%)163,615 (109.1%)On track
Majed Al-Ghamdi, Dammam120,000114,000 (95.0%)115,615 (96.3%)Behind
Turki Al-Dosari, Riyadh South160,000176,000 (110.0%)173,077 (108.2%)On track
Team total610,000617,000 (101.1%)617,308 (101.2%)On track

Khalid sold SAR 6,700 on day 13, above his average, so his projection rose.

He is still behind, and the sheet shows it with 17 days left to close the gap.

Saad and Turki dipped slightly. Both stay above target, so a manager can spend the morning on Riyadh North and Dammam instead.

Where the Manual Sheet Falls Short

  • Someone retypes it daily. Every rep's sales to date is keyed by hand, so the sheet is only as current as the last person who updated it.
  • The link is the only lock. A standard EtherCalc sheet can be edited by anyone who has its address.
  • Yesterday disappears. Overwriting sales to date keeps no daily history, so there is no trend line unless you copy the tab.
  • It assumes an even month. A straight run rate treats every remaining day like the days so far, and Ramadan demand rarely moves in a straight line.
  • Reps cannot see their own pace. The sheet sits with the manager, not on the phone of the person who has to act on it.
  • One row per rep only. Tracking by store or by unit as well as by value means more tabs and more typing.

How 1Channel Tracks Ramadan Targets Without Retyping

1Channel sets targets by person or by store, in value, units or counts, and for individuals or whole teams. Achievement is tracked live from the sales recorded in the platform.

Run rate and projected finish are calculated for you, with a month-on-month trend. Managers see the people behind target among their daily priorities, without opening a spreadsheet.

The target vs achievement report breaks figures down by person, store or manager, with Excel export and scheduled emails.

Managers can also ask plain-language questions on dashboards, with answers checked against the data.

NeedManual Sheet1Channel
Sales to dateRetyped every morningTracked live
Run rate and projected finishYour own formulasBuilt in
Who is behindAn IF formula on one tabShown to each manager daily
Trend over timeLost when overwrittenMonth-on-month trend
Who can see itAnyone with the linkEach manager's own reporting line

See Every Rep's Ramadan Pace Before It Slips

Track targets, run rate and projected finish for field teams across the Kingdom, without a daily spreadsheet.

Explore Sales Analytics Software →

Common Mistakes to Avoid

  • Reading only the team total. A total above 100% can hide reps who are well behind, as day 12 showed.
  • Forgetting to move Days gone. If K2 stays at 12 while sales keep rising, every projection is overstated.
  • Dropping the dollar signs. Without $K$2 and $K$1, copied formulas point at empty cells and return errors.
  • Treating the projection as a forecast. It is a pace check, so read it alongside what you know about the weeks ahead.
  • Mixing gross and net sales. Use the same sales definition every morning, or the run rate jumps for no real reason.

Note: Since the manual method was only tested once, consult a technical expert before running bulk operations.

Insights

Want to get more insights? Click on a topic below