Spreadsheet dashboard building in Kenya

The buyer and the buying decision

Owners needing a repeatable operational summary. The offer to test is: Build an explainable spreadsheet dashboard from defined business records.

Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear.

Separate interest from an accepted order

Create a small dashboard from fictional or authorized sample data.

The purpose of this test is to establish whether the buyer accepts the specified result, delivery arrangement and payment terms. An encouraging interview does not establish repeat demand. Ask what the buyer currently uses, what would make them change supplier and who has authority to approve the first order. Record a refusal as carefully as an enquiry so that unsuccessful offers do not disappear from the evidence.

Collect evidence specific to this offer

Record metric definitions, source versions, reconciliation results, filter tests, missing periods, owner questions, and independent refresh attempts before accepting the completed dashboard.

Decide whether to continue

Review the specification with the buyer before committing to tools or stock. A trial is commercially useful only if actual costs, rejected work, time spent and cash collected can be reconciled. A colourful dashboard fails when revenue means invoiced sales on one page and cash received elsewhere, leading the owner to compare incompatible figures.

If a buyer changes the required output, record a new scope and re-cost the test. Do not count a request for a different product as proof of demand for the original one. Keep personal contact details in your private records and use customer statements publicly only with permission.

Turn the example into a buyer test

Fictional dashboard DSH-89 summarises an owner-approved sales table using four fixture rows: confirmed 500, confirmed 700, cancelled 300 and refund 200. The example definitions yield confirmed sales 1,200, refunds 200 and net 1,000; cancelled 300 is excluded. These are invented test values, not audited accounts. Output is source table, metric dictionary, three KPI cells, one monthly chart and refresh instructions. Forecasting, tax reporting, accounting assurance and live-system integration are excluded.

Ask the buyer to describe one acceptable and one unacceptable result. Record the decision maker, price basis, quantity, handover point and payment date privately. A sample request, an encouraging conversation and an accepted order are different evidence. Keep the first commitment within your demonstrated capacity; no customer interview or successful trial is asserted here.

What a failed test should change

Check source-table expansion and chart range.. If the offer cannot meet that check, revise the specification or process before promising a repeat. Keep rejected offers and reasons in the same register as positive replies so that your record does not exaggerate demand.

Build a budget around the first deliverable

Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear.

This scope determines what you need before the first order. A national average or a supplier' s bundle cannot establish your opening budget. The main cost drivers for this business are:

• sources
• metric complexity
• refresh support

Separate setup, operating cost and working cash

Equipment that remains useful after the pilot belongs in a separate setup schedule. Consumables used in accepted work belong in operating cost. Refundable deposits use cash but are not automatically an expense. Do not count the same equipment purchase in full both as setup spending and again as one period' s operating expense.

Include costs that are easily missed

Include data cleanup, calculation design, layout, source connections, documentation, and training, allowing for manual refresh work that remains necessary after delivery.

Prepare the cash schedule in date order. Supplier payments can fall due before the customer pays; a positive paper margin does not fill that gap. Record transport, rejected inputs, corrections and your own working time against the actual trial rather than assuming them to be free.

Set a spending decision

Use this pilot as the smallest meaningful commitment: Create a small dashboard from fictional or authorized sample data.

Before buying, obtain comparable written quotations with the same item specification, quantity, delivery destination and relevant support terms. Keep uncertain lines marked unknown until you have evidence. If the cash requirement exceeds your available funds, reduce the trial scope, negotiate transparent payment stages or defer the purchase. Do not silently replace missing costs with zero.

A colourful dashboard fails when revenue means invoiced sales on one page and cash received elsewhere, leading the owner to compare incompatible figures.

Use the pricing and cash-flow chapter to test whether accepted sales can cover recurring costs after setup. This page supplies a budgeting method, not a verified opening-cost estimate.

Build the first spending decision from actual specifications

The listed cost exercise below is a narrow scenario, not a complete startup budget. Do not buy this entire list automatically: first decide whether the trial requires purchase, suitable hire or a competent service provider. Record one-time resources separately from repeat inputs, and enter the actual supplier due dates.

A cash-timing exercise using the same example

Assume solely for arithmetic practice that opening cash is zero and the entire listed input bill of KSh 4,950.00 must be paid before handover. With no advance, that amount must be funded before any sale is collected. This deliberately simplified case does not establish when your actual suppliers need payment.

If a buyer hypothetically pays a 30% advance on the example revenue of KSh 7,200.00, cash received would be KSh 2,160.00. Paying the listed bill then leaves KSh -2,790.00. The additional cash needed to avoid a negative balance at that point is KSh 2,790.00. The unpaid remainder is KSh 5,040.00; it is a receivable, not cash already in the business.

The 30% figure is an invented teaching assumption, not a recommended or agreed customer term. Check whether deposits are refundable and which commitments they can actually fund. Do not count the advance again when entering the final collection. Add equipment payments, tax, owner drawings and unlisted operating bills to the dated cash plan as appropriate. The 13-week planner in file 10 shows week-end funding gaps; inspect intra-week dates for a large payment.

Close these budget uncertainties

• Real source quality and metric definitions unverified.
• No financial assurance, dashboard execution or performance result claimed.

Buy for the acceptance standard

The procurement decision starts with the result you must deliver: Headline totals reconcile and missing data is not disguised as zero.

Ask the owner to trace selected figures to source records and explain the chart, checking filters, date boundaries, duplicates, and missing-data signals.

A tool or material is suitable only when it can support this specification at the pilot scale. Use the following shortlist as a starting point, not a compulsory shopping package:

• spreadsheet software
• data dictionary
• source controls
• test workbook

Write comparable requests for quotations

Ask for the exact unit or pack size, rather than accepting a price without a quantity. Where equipment is involved, check maintenance needs, safe operation, available support and whether you can obtain replacement consumables. Inspect a sample or demonstration where practical. A photograph and a low asking price do not prove suitability or available stock.

Connect procurement to the operating sequence

1. Define each metric, unit and reporting period with the owner, then reconcile sample source data and approve a compact dashboard layout.
2. Build readable calculations linked to source records, test missing inputs and update cases and record any exclusions that affect totals or comparisons.
3. Have the owner trace headline figures to records, supply refresh instructions and keep unresolved source defects visible rather than displaying plausible zeros.

At each step, identify the input whose absence would stop delivery. Arrange that input before accepting a deadline. Compare buying with suitable hire or a competent subcontractor, while keeping the responsibility for inspection and customer handover explicit.

Inspect before release to use

Retain the quote and check the delivered specification, quantity, condition and identifying details. Keep unsuitable items separate while you resolve the discrepancy. Record supplier identity and payment reference privately; do not post customer or supplier personal data in a public planning sheet.

Include data cleanup, calculation design, layout, source connections, documentation, and training, allowing for manual refresh work that remains necessary after delivery.

Limit the first purchase to the agreed scope: Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear. Expand the resource list only when actual orders and measured capacity justify it.

Exact procurement specifications for this offer

A usable quotation states the exact variant, comparison unit, minimum order, delivered quantity, tax, delivery charge, payment dates, expiry and exclusions. Obtain written clarification of substitutions; compare only equivalent scopes. Match the delivered item against the same check before releasing it to use.

Supplier evidence and limits

No matched public listing observation was established for this exact offer. That is a quotation gap, not evidence that the item is unavailable.

Any listing above is an earlier observation, not a fresh quotation or confirmed stock. Reconfirm suitability and landed cost. The supplier comparison in the operating pack separates purchase quantity from usable requirement when a minimum order creates surplus.

Define the activity that authorities need to assess

Build an explainable spreadsheet dashboard from defined business records.

Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear.

Describe that exact operation when checking requirements. State where the work takes place, whether customers enter the premises, who performs technical tasks and whether you manufacture, resell, deliver or coordinate the service. Requirements can change with these facts; a broad business category is not a complete permit determination.

Sector questions to investigate

• Assess data-controller/processor duties and registration requirements for systems handling personal data.
• Obtain written authority for access, backups, testing and changes.
• Use properly licensed software and assets; document responsibility for third-party renewals and processor contracts.

Keep registration separate from permission to operate

A registered business name does not itself establish approval of premises, products or professional work. Use the Business Registration Service to check the appropriate registration route. Ask the relevant county office which premises and trading checks apply to the actual activity. Confirm tax and invoicing obligations with KRA for your circumstances rather than copying another trader' s treatment.

Prepare a written enquiry

Add the county, location, premises arrangement, scale, equipment and responsible person' s qualifications. Ask which authority handles an issue if it falls outside the first office' s remit. Record the answer, reference link, date checked and any renewal or inspection condition. A guide' s reference list is a route to verification, not an approval document.

Decide what must wait

Do not offer a regulated service or make a safety, accreditation or certification claim that you cannot substantiate. Resolve an unanswered prerequisite before accepting work that depends on it. A demand interview can often precede trading; a paid or physical trial still needs the appropriate permissions and safe arrangements.

A colourful dashboard fails when revenue means invoiced sales on one page and cash received elsewhere, leading the owner to compare incompatible figures.

No universal licence package, current fee or exemption is asserted here. The official links below support only their stated scope.

Prepare a precise activity enquiry

Describe this actual operating scope to the relevant authority or competent adviser: Fictional dashboard DSH-89 summarises an owner-approved sales table using four fixture rows: confirmed 500, confirmed 700, cancelled 300 and refund 200. The example definitions yield confirmed sales 1,200, refunds 200 and net 1,000; cancelled 300 is excluded. These are invented test values, not audited accounts. Output is source table, metric dictionary, three KPI cells, one monthly chart and refresh instructions. Forecasting, tax reporting, accounting assurance and live-system integration are excluded.

Use these operating details to make the enquiry specific:

Keep the reply date, official source, exact activity facts and any conditions together. This is an enquiry preparation method, not a determination that a licence, exemption or fee applies. The earlier source dates do not mean legal requirements were rechecked today. Resolve these outstanding checks before relying on a broad business description:

• Real source quality and metric definitions unverified.
• No financial assurance, dashboard execution or performance result claimed.

Deliver the agreed result consistently

Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear.

The operating sequence for this offer is:

1. Define each metric, unit and reporting period with the owner, then reconcile sample source data and approve a compact dashboard layout.
2. Build readable calculations linked to source records, test missing inputs and update cases and record any exclusions that affect totals or comparisons.
3. Have the owner trace headline figures to records, supply refresh instructions and keep unresolved source defects visible rather than displaying plausible zeros.

Put acceptance into the job record

Headline totals reconcile and missing data is not disguised as zero.

Ask the owner to trace selected figures to source records and explain the chart, checking filters, date boundaries, duplicates, and missing-data signals.

Inspect at the point where a correction is still possible, then again at handover. Record rejected or incomplete output separately from accepted output. A completed task is not automatically an accepted task, and an invoice does not establish that the customer received the right result.

Measure real capacity

Time preparation, the main operation, transport, cleaning, approvals and correction as applicable. The slowest stage determines how much you can promise. Where two orders need the same person, space or equipment at the same time, resolve the conflict before confirming both deadlines. An additional enquiry should not erase a commitment already made.

Keep a correction and escalation rule

When inputs, access, specifications or customer instructions change, pause the affected work and confirm the effect on time and cost. Do not quietly lower the acceptance standard to avoid a delayed delivery. Keep rework caused by your error distinct from a customer-requested change of scope and agree the remedy clearly.

A colourful dashboard fails when revenue means invoiced sales on one page and cash received elsewhere, leading the owner to compare incompatible figures.

Retain the minimum records needed to investigate a complaint without disclosing unrelated personal information. Use measured delivery and actual acceptance as the basis for expanding capacity, rather than the maximum theoretical output of a tool or production line.

Operating control points for this exact offer

Do not substitute a tick for an observation: record the count, measurement, approved sample or evidence reference used at each checkpoint. Mark unresolved work as held and identify who can approve the recheck.

Diagnose a failure before repeating it

These are diagnostic prompts, not proof of the cause in a real incident. Separate suspect output, record any correction and repeat the relevant acceptance check. Link rejected units, rework time, replacement materials, customer credits and collection delays to the actual job result.

Price an accepted unit, not an activity title

Start with this sale unit: dashboard project.

Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear.

A quotation needs the accepted quantity or scope, exclusions, completion point, delivery arrangement and payment schedule. Without that specification, two apparently similar prices may pay for different work.

Build the direct-cost sheet

• sources
• metric complexity
• refresh support

Include data cleanup, calculation design, layout, source connections, documentation, and training, allowing for manual refresh work that remains necessary after delivery.

Count rejected output, unsold stock and correction time. Keep fixed overhead in a consistent period; a daily contribution cannot be compared directly with a monthly overhead figure. If contribution is zero or negative, extra sales do not establish a workable break-even point.

Reconcile the cash separately

A customer' s unpaid balance cannot pay today' s supplier bill. List actual collections, advance payments, supplier deadlines, refunds and recurring bills by date. Separate refundable deposits and money held for an uncompleted commitment from funds freely available for expansion.

A colourful dashboard fails when revenue means invoiced sales on one page and cash received elsewhere, leading the owner to compare incompatible figures.

Test a weaker outcome

Recalculate with fewer accepted units, a delayed customer collection or a higher input quotation. Change one assumption at a time to see which constraint matters. Use the actual pilot record: Record metric definitions, source versions, reconciliation results, filter tests, missing periods, owner questions, and independent refresh attempts before accepting the completed dashboard.

Do not interpret the invented financial teaching exercise in the complete manuscript as a market price or predicted income. Replace its assumptions before using it for a real decision. The public planning tool can help with arithmetic; it does not validate the inputs.

Work through this business' s example

Test the listed example when things change

These calculations are invented teaching cases derived from this guide' s example, " Fictional planning scenario in KSh; not a supplier quotation or earnings forecast". They are not observed customer results, local quotations or forecasts. They hold the listed input bill constant unless the row explicitly changes it. Excluded expenses and tax still need to be added.

The lower-acceptance case represents the loss of priced output, not a prediction of the actual reject rate. At this small example scale, rounding leaves no accepted unit. The entire listed bill remains to be funded; a cost per accepted unit cannot be calculated. A whole-job price needs its own agreed acceptance and partial-payment treatment.

Inspect the cost that can change the decision

The largest listed line is Dashboard build hours: 5 at KSh 500.00, giving KSh 2,500.00. A 10% increase in this line alone adds KSh 250.00 to the example bill. Check its exact unit, scope, quotation validity and whether it is a one-off resource or a repeat input before changing the quote.

Keep every input quantity separate from priced output. A fall in accepted output does not automatically reduce already-purchased inputs. Use the itemised costing tool to change the real quantities, rather than scaling the whole bill by a sales percentage.

Connect the commercial check to quality

For spreadsheet dashboard building, investigate this concrete failure: New month missing. The guide' s diagnostic check is: Check source-table expansion and chart range.. Proposed response: Extend the correct structured source and retest a new row..

Record what was actually found and rechecked; do not mark a corrected item accepted until the agreed buyer checkpoint has passed. Any rework materials, transport, labour or credit must be added to the actual cost/result record.

A cash-timing exercise using the same example

Assume solely for arithmetic practice that opening cash is zero and the entire listed input bill of KSh 4,950.00 must be paid before handover. With no advance, that amount must be funded before any sale is collected. This deliberately simplified case does not establish when your actual suppliers need payment.

If a buyer hypothetically pays a 30% advance on the example revenue of KSh 7,200.00, cash received would be KSh 2,160.00. Paying the listed bill then leaves KSh -2,790.00. The additional cash needed to avoid a negative balance at that point is KSh 2,790.00. The unpaid remainder is KSh 5,040.00; it is a receivable, not cash already in the business.

The 30% figure is an invented teaching assumption, not a recommended or agreed customer term. Check whether deposits are refundable and which commitments they can actually fund. Do not count the advance again when entering the final collection. Add equipment payments, tax, owner drawings and unlisted operating bills to the dated cash plan as appropriate. The 13-week planner in file 10 shows week-end funding gaps; inspect intra-week dates for a large payment.

Reach a buyer who can accept the offer

Owners needing a repeatable operational summary.

Offer owners a reconciled sample with visible calculation steps.

Begin with the problem and specification rather than promising a return on investment you cannot establish. The proposed output is: Build an explainable spreadsheet dashboard from defined business records.

Make the first message specific

Explain what you will deliver, what is excluded and what the prospect needs to confirm before a quotation. Use this scope when preparing a sample, demonstration or introduction:

Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear.

Ask who approves purchases, who accepts the output and how payment is arranged. These can be different people. An informal recommendation is useful for an introduction but does not replace the buyer' s approval.

Use proof that matches the promise

Ask the owner to trace selected figures to source records and explain the chart, checking filters, date boundaries, duplicates, and missing-data signals.

Keep approved examples, inspection records or handover evidence that demonstrate this result. Obtain permission before using a customer' s name, photograph, premises or work. Do not invent reviews, imply an endorsement or display private contact details as marketing proof.

Follow the lead through to collection

Create a small dashboard from fictional or authorized sample data.

Review what it cost to obtain and fulfil a paying order, including travel and follow-up. High enquiry counts do not compensate for a route or delivery arrangement that loses money. Keep cancellations, complaints and refusals visible when evaluating a channel.

A colourful dashboard fails when revenue means invoiced sales on one page and cash received elsewhere, leading the owner to compare incompatible figures.

Expand outreach only when the promised scope can be delivered reliably. Use permission-based follow-up and an achievable response time instead of bulk unsolicited messages.

A scope-led outreach draft

The supplied draft below is ready to adapt, not a message already sent:

Hi [owner], I can build three clearly defined KPIs and one monthly chart from your approved table, with a fixture sheet proving what is included. Please explain confirmed, cancelled and refunded states before design. You will practise refresh and trace one number back to source at handover.

Replace claims with proof of this offer

Remove placeholders and replace assumed prices with an approved scope and actual cost estimate. Do not advertise technical certification, current stock, guaranteed income or results you cannot substantiate. Record enquiries, accepted quotes, declined quotes, delivered orders and collected balances separately; a sent message is not a sale.

Set the conditions for a safe commercial test

• Wrong definitions
• broken references
• stale data

A colourful dashboard fails when revenue means invoiced sales on one page and cash received elsewhere, leading the owner to compare incompatible figures.

A risk list is useful only when it changes a decision. For each risk, write the observable warning, who checks it and the response before the next commitment. Do not treat a reserve of money as permission to continue unsafe or unauthorized work.

Use a small, measurable pilot

Create a small dashboard from fictional or authorized sample data.

The pilot scope is: Build the dashboard around decisions the owner makes, identifying approved data sources, metric definitions, refresh responsibilities, and how missing periods should appear.

Stage the launch around prerequisites

First confirm the buyer specification and activity requirements. Then compare suppliers, establish suitable facilities and prepare the operating record. Run the bounded trial when those prerequisites are in place. Review actual costs, quality failures and cash collected before increasing the commitment.

This sequence is not a promise that the complete business cycle fits into 30 days. Growing periods, qualifications, approvals, seasonal access and customer buying cycles can require longer. Revise the schedule when a prerequisite changes rather than skipping it to meet a launch date.

Choose continue, revise, pause or stop

Continue only when the scoped result is accepted and direct costs and payment timing are workable. Revise one part of the offer if the problem is identifiable and affordable to test again. Pause when required information, permission, skills or resources are missing. Stop the affected work when safety, consent or lawful authority is uncertain.

Keep a maximum test loss and unpaid-balance limit suited to your actual funds. A successful single delivery is useful evidence, but it does not establish year-round demand or justify committing every available resource.

Tie launch milestones to observable checks

Outstanding go / hold conditions

• Real source quality and metric definitions unverified.
• No financial assurance, dashboard execution or performance result claimed.

Assign an owner, evidence reference and review date to each unresolved condition. Do not give every milestone a fixed calendar date when it depends on a crop, production, approval or competence cycle. Run only a suitable limited trial, reconcile accepted output and actual cash, and record whether the evidence supports holding, revising, proceeding within the limit or stopping.

Keep evidence that answers a real operating question

For spreadsheet dashboard building, the record should connect the promised output, its cost and the buyer' s acceptance. Begin with:

Record metric definitions, source versions, reconciliation results, filter tests, missing periods, owner questions, and independent refresh attempts before accepting the completed dashboard.

An order and acceptance record

Add the date, private customer reference, agreed price, advance, balance, promised handover and actual acceptance. Record a change before carrying it out. An unresolved complaint needs its own action and follow-up date rather than being overwritten by the next order.

A supplier and cost record

For each required input, record the specification, quantity, supplier identity, quote date, delivered cost, payment terms and reason for selection. Match the record to the receipt and inspect what arrived. Keep one-time setup, recurring inputs and refundable deposits in separate categories so that the same cash movement is not counted twice.

A weekly review

Compare accepted output with started output; reconcile money collected with outstanding balances; investigate rework and returns. Review whether measured capacity can meet the next commitment. A positive surplus estimate does not remove a shortage of cash caused by late collection.

Use sources within their stated scope

• ODPC — Registration FAQs — Registration applicability, exemptions and non-exempt activities; not every small business is automatically exempt. Reference recorded 2026-10-26.
• ODPC — Guidance Notes for Data Protection Policies (2026) — Privacy governance reference covering access, retention, data sharing and incident response. Reference recorded 2026-10-26.
• Kenya Copyright Board — National Rights Registry — Official registry for copyright records; negotiate ownership and third-party licences separately. Reference recorded 2026-10-26.

These references route sector and activity questions. They do not independently establish local customer demand, supplier stock, a complete budget or business profitability. A reference date records the earlier check; it is not a claim that every linked requirement was reverified today.

The complete downloadable guide includes editable planning worksheets. Save backups privately when they contain personal, customer or supplier information. These planning forms do not replace required statutory records or professional advice for a regulated task.

Evidence register for this particular offer

• SUMIFS function — Microsoft - Conditional summation and matching range dimensions; business metric definitions remain client decisions. Recorded 2026-10-26.
• Keeping leading zeros and large numbers — Microsoft - Import identifier columns as text to preserve zeros and precision. Recorded 2026-10-26.
• Import data from data sources (Power Query) - Import preview and data-source workflow; version-specific menus may differ. Recorded 2026-10-26.

These recorded references support only their stated scope. They do not establish current supplier stock, actual local demand, operator competence or complete commercial feasibility. Preserve source dates and record new checks separately.

Match the evidence to a decision

The operating pack provides an itemised quote tool, supplier request, sales draft, job card, quality response sheet, evidence gaps, operations desk and cashflow/launch-review workbook. Keep a separate private backup per actual job and per scenario. Test restoring it before closing the original. Exported files may contain customer or supplier information; do not publish completed private records as SEO content.