kharashy.com · Mohamed Elkharashy, spreadsheets your team actually uses

Hi, I'm Mohamed.

I turn messy spreadsheets into tools your team actually uses.

I turn the spreadsheet your business runs on into one clear screen: who to call, what to order, where the money goes.

Bring the spreadsheet that scares you.

Monthly dashboard.xlsxAfter
Cash in$184kup 6% on last month
Overdue$12k3 customers
Stock cover41 daysinside the range
Call first: Customer 014$4.2k, 12 days late
Then: Customer 017$3.9k, 9 days late
0 errors. Refreshed today at 08:00.
Q3_report_FINAL_v7_REAL (2).xlsxBefore
Only Sam knows how this works

An illustration, not a client file. Drag the handle.

Mohamed Elkharashy
Mohamed
13,700haplanned and tracked
30,042accounts, one call list
5,355spare parts, each with a rule
4projectsfor one repeat client

Real results from real projects. Client names changed.

How I can help

See your numbers

One screen that updates itself.

Plan ahead

Know the answer before you decide.

Run the operation

Stock, people and deadlines under control.

Get reports every month

Fresh and checked, for one fixed fee.

Some of my work

Open any project and try it.

Farming

Farm Operations Planning System

13,700 haplanned and tracked
9,493field operations logged
Satellite view of the same land in 2022, planted with centre pivots2022: 13,700 ha planted
Satellite view of the land in 2019, bare desert2019: bare desert
The same land in 2019 and 2022. Drag to compare.
The problem

Machines, staff and field work were planned in separate files, by feel.

What I did

One linked plan for machines and people at every stage, plus a log of every field operation.

The result

The plan showed 92 staff on site where the area needed 77, and flagged machine shortages months before delivery dates.

Size the operation

Demo figures. Move the planted area and pick the shift pattern. Machines and staff follow the same rules the real plan used.

INTERACTIVE
2,000 ha to 15,000 ha

Machines needed vs on site

One season, every operation logged

Field operations by type over one season. Each record carries its field, job order, machine, operator and area.

Business plan

Multi-Market Business Plan

6 yrsof cash seen ahead
3scenarios, one click
5currencies, one view
The problem

Costs in five currencies across four offices, with actuals and forecast in separate files.

What I did

One model that links profit, balance sheet and cash flow, with base, stress and upside cases on one switch.

The result

Monthly actuals drop in and the six-year cash view updates. Shareholders see a funding gap before it happens.

When does cash run out?

Demo figures. Pick a scenario, move a driver or switch the tax status, and watch six years of cash.

INTERACTIVE

Six-year P&L at a glance

From sales to EBITDA for the chosen year. Follows the scenario above.

Actuals and forecast in one timeline

Real spend to September, forecast after. Monthly overheads by category, demo figures.

What moves cash most

How the lowest cash point shifts when each driver moves to its stress or upside value.

Costs by currency

Entered in local money, reported in USD. Demo split.

What the owners get

  • The cash low point, and when it hitsTime to arrange funding before it is needed.
  • Three futures side by sideStress, base and upside in one click.
  • The tax bill before it arrivesFree-zone status and its cash effect, year by year.
  • Numbers that tie to the budgetReady for the board and the bank.
Stock policy

Spare Parts Stocking Policy

5,355items analyzed
9 in 10moved to order-on-demand
The problem

Fast movers and once-a-year parts were treated the same, so cash sat in stock that never moves.

What I did

I sorted every item by how often it is used, flagged dead and critical parts, and set a rule for each group.

The result

Only about 500 items stay on min-max. The rest are ordered on demand, and critical parts stay protected.

How often do parts actually move?

Items by number of months with any use, out of 25.

The policy each item gets

2-year history. Switch to see the 1-year view.

Min-max for one part

Pick a real part type and change the lead time. Safety stock uses 97.5% service level.

INTERACTIVE
Sales map

Provider Territory Map

19 → 1sheets to one list
30,042accounts
5,227win-back targets
The problem

About 30,000 accounts were split across 19 sheets, with broken location data.

What I did

I merged them into one list, ranked every account and mapped them by state into four actions.

The result

Reps now go where demand is, with a ready win-back list of 5,227 accounts that drove 75% of past orders.

30,042 accounts, sorted into who to call

Each dot is 5 accounts. Before: mixed inside 19 rep sheets. After: four clear groups.

CLICK A STATE

Where each group sits, so reps can be placed in the hot spots.

0accounts
0win back
0protect

Top 10 states

Follows the map switch above.

80/20 of orders

A small group of accounts drives most of the business.

Accounting firm

CPA Firm Operating System

1place where the whole team sees every job
Everyfiling deadline flagged before it is due
Weeklyfirm health for the partners, without asking anyone
The problem

Client work lived in scattered lists, with no warning before a filing deadline.

What I did

I built one workbook with client lists, a work board, deadlines, receivables and a partner dashboard.

The result

Every filing deadline is flagged before it is due, and anyone can see who is overloaded.

The firm's workload on any day

300 demo tasks, five staff, six clients. Move the date or press play and watch work flow through the stages while deadline flags turn on.

INTERACTIVE
Open tasks0
Overdue0
Due in 7 days0
On-time delivery0%
On trackDue within 7 daysPast internal SLAPast due dateBlocked

Needs attention now

Longest-overdue open work on the selected date.

    Manufacturing

    GRP Fittings Order Engine

    7 → 1calculators into one order table
    4outputs per order
    The problem

    Each fitting type had its own calculator, so a mixed order was slow to cost and easy to get wrong.

    What I did

    I built one order table. The engineering formulas run behind it.

    The result

    A mixed order of 7 fitting types is costed from one table, with materials, man-hours, pipe lengths and process sheets in one go.

    1

    Enter the order

    Any mix of fittings, one table.

    2

    The engine calculates

    Complex engineering formulas and tables, out of sight.

    3

    You get

    For the whole order, in one go.

    Raw materials
    Man-hours
    Pipe lengths
    Process sheets
    Workshop tool

    Cutting Stock Optimizer

    Same result as paid softwareNo licence feeOne-click cut planVisual cut map

    “The sheet is perfect.”

    Glen C. · aluminium window fabricator
    The problem

    Cut plans came from paid software, and material orders were estimated.

    What I did

    I built a one-click Excel tool with a to-scale cut map and the bar count for the purchase order.

    The result

    On their test job it used 10 bars, the same as their paid software, with no licence fee.

    Plan a cut list

    Loaded with the client's own 52-piece test job. His commercial optimizer planned it on 10 bars. Edit any number and both plans recalculate.

    INTERACTIVE
    Length (mm)Qty

    Cut in list order0
    Optimized0
    Bars saved0
    XLSM
    One-click workbookEnter stock length and cuts, press Run, get a bar-by-bar plan and waste summary.
    MAP
    Visual cut mapEvery bar drawn to scale so the saw operator reads the plan at a glance.
    PO
    Order quantityBar count feeds straight into the material order.
    Video walkthrough · 0:47 · YouTubeWatch the tool plan a cut list
    Real estate

    Mobile Home Park Deal Model

    2models rebuilt
    7parks reported
    The problem

    Inputs sat on five tabs, debt could not switch type and the unpaid investor return was wrong.

    What I did

    One input page now drives the model, with three debt options on a dropdown and a new fund performance page.

    The result

    A new deal is underwritten from one page, and investors are owed exactly what the agreement says.

    Output 1 · Acquisition model

    Underwrite a park in seconds

    Demo deal: a 35-lot park. Change the assumptions and every return updates.

    INTERACTIVE
    Output 2 · Quarterly investor update

    What investors see every quarter

    Demo figures. Fund totals, each park's returns, and the preferred return owed.

    Return by park
    Unpaid preferred return owed to investors

    Public sector

    Awareness Campaign M&E Dashboard

    Minutesto build a donor update
    4audiences tracked
    7regions compared
    The problem

    Results were spread across channel reports, surveys and enrolment records.

    What I did

    I linked reach, awareness and enrolments in one dashboard that filters by audience and ranks regions.

    The result

    Money moves to the channels that convert, lagging regions show up early, and donor updates take minutes.

    Campaign MonitorJan 2024 – Jun 2025 Demo data · live view
    Is the message landing?Everyone · monthly
    Where to push next
    Reach is not resultspeople reached by channel
    Sales team

    Sales Activity Simulator

    8 → 1CRM exports to one model
    14,763activities tracked
    The problem

    Activity was spread across 8 CRM exports, so leaders could not compare effort with results.

    What I did

    I built one activity model with funnel stages, per-rep results and a simulator based on real conversion rates.

    The result

    Managers see who converts, not just who is busy, and set targets from data instead of guesses.

    What if the team did more?

    Move the weekly activity sliders. The funnel uses the team's own conversion rates from the data.

    INTERACTIVE

    Activity by funnel stage, week by week

    Top, middle and bottom of funnel, January to June.

    Top of funnel (outreach)Middle (engagement)Bottom (closing)

    Effort vs results by rep

    More activity is not always more revenue. Bubble size = opportunities.

    Manufacturing

    Production & Inventory Planning System

    Built on a defined 36-month scenario, not live plant data
    5planning layers linked
    30+methods tested
    The problem

    Demand swung hard from a September peak to an October collapse, and nothing tied staffing, stock and orders together.

    What I did

    I linked 5 planning layers in one workbook and tested over 30 methods to recommend one for each layer.

    The result

    Every planning decision is backed by a tested method, and the whole plan re-runs when demand changes.

    Capacity plan: chase vs level workforce

    Drag the crew size and watch inventory, shortages and cost react across 36 months.

    INTERACTIVE
    DemandProductionStock on handUnmet demand
    Hire / fire$0
    Holding$0
    Shortage$0
    Total incl. labor$0

    Job sequencing on two machines

    Johnson's rule reorders four jobs and finishes them sooner.

    INTERACTIVE

    XLSX
    Planning workbook36 linked tabs, one per model, inputs separated from calculations.
    DOCX
    Technical reportAssumptions, method and recommendation for every planning layer.
    PPTX
    Management deckReady for the management review meeting.
    Sports

    Live Matchup Intelligence Dashboard

    1 clickfull matchup read
    137teams ranked
    0manual updates
    The problem

    Comparing two teams meant checking four websites, and the numbers never lined up.

    What I did

    I built one dashboard: pick two teams and see every key metric side by side, ranked against all 137 teams.

    The result

    “Who has the edge?” is answered in seconds, and bad data is caught automatically.

    Try it

    Pick any two teams

    Real 2026 season numbers. The ball moves toward the team losing the most battles.

    INTERACTIVE

    Spot strong and weak teams at a glance

    Offense against defense, all 137 teams. Click a ball to compare it.

    AwayHomeOther teams

    Game-day trip

    Where the away team travels from.

    0miles to travel

    What changed for the client

    Where the numbers are4 websites1 screen
    Keeping it currentBy handAutomatic
    Reading a matchupCompare tables yourselfEdge flagged per metric
    Bad dataFound late, if at allFlagged on every refresh

    What clients say

    Mohamed is absolutely the best in his field, without a shadow of a doubt! He is an excel wizard.
    MarkProduction & inventory planning project
    Once again, Mohammad did a great job completing the tasks!
    Kiev O.Repeat client, 4 projects
    The sheet is perfect.
    Glen C.Aluminium window fabricator, cutting optimizer
    Mohamed Elkharashy at his desk
    me, most days
    Mohamed Elkharashy in front of a centre pivot irrigation machine
    on site

    Good to meet you

    I have spent my working life inside farms, factories and oil and gas sites. When a spreadsheet got messy, I was the one they handed it to. Now I fix yours, in Excel, Google Sheets or Power BI.

    • I start with your question, not the tool.
    • I build in checks, so wrong numbers get caught.
    • I explain it in plain English.

    Free templates

    Free. Tell me which one you need and I will send it.

    Min-Max Calculator

    Safety stock, min and max per item.

    Ask for this one

    Inventory Classifier

    Fast, medium, rare and dead stock.

    Ask for this one

    Deadline & SLA Tracker

    Late and due-soon tasks light up.

    Ask for this one

    Overdue Invoice Tracker

    Who owes you, and who to call.

    Ask for this one

    Reorder Point Planner

    When to reorder, and how much.

    Ask for this one

    Let's look at your file together

    Bring the spreadsheet you run on. In 20 minutes I show you where it breaks.

    Pick a time20 minutes, then you decide

    Free, on Google Meet.

    1. 1
      Send me the fileTwo minutes.
    2. 2
      Pick a timeAny time zone.
    3. 3
      Get a clear planWhat to fix first.