Getting started · Episode 14 of 17
4:52
A till export full of mixed-up dates, repeated rows and the till’s own totals hides what you need to know. Put the file in one project folder, ask in plain words, and get back a clean sheet, a chart and three short answers: your best day, your worst product and one thing to act on.
Your sales numbers already know your best day and your worst product. You just never have time to dig it out. One messy sales export. Cleaned up, and charted. Then her best day, her worst product, and one thing to act on. In three lines. Got a spreadsheet you never open? A till export, a sales report, a list of orders. The answers are in there, buried under mixed-up dates, repeated rows and blank lines. Today, Murage cleans it up, charts it, and tells you what it means, in three lines. Let's do it. Step one: give the spreadsheet a home. A new project: Bluebell Café sales. Ember's on it. Create project. Now point it at the folder. Details, Folder, Choose a folder. The Sales folder. Set. That folder is now what this project works from. Here's what's in that folder: the till export, July to September. Look closer: the same rows, twice. And it's a mess. Four kinds of date. Blank lines. And the till's own daily totals, mixed in with the sales. Twelve hundred rows of it. Step two: ask in plain words. Clean it into a new sheet. Chart the sales by day. Say what you fixed. Then three short lines: best day, worst product, and one thing to act on. Step three: watch it work. Before it runs anything, Ember asks. First, a short script to tidy the sheet. Allow once. Then two more: save the clean sheet, and save the chart. Allow once. And once more. Done. Both files saved, and the answer, on one screen. Step four: see what it made. Two new files, next to the export: a clean sheet, and a chart. The clean sheet: one date format, one name for every item. No repeats, no blank lines, no total rows. Just under eleven hundred rows, every one a sale. And the chart: sales by day, July to September. One day stands out above all the rest. Step five: the three answers. Best day: Saturday the twelfth of September, one thousand, four hundred and fifty-three pounds forty. Worst product: hot chocolate. Nine hundred and seventy-six pounds fifty, for the whole quarter. And one thing to act on: Saturdays beat the weekdays, so put on an extra person, or try a Saturday-only special. Don't take its word for it. Open the raw export, and search for that best-day total. There it is: the till's own total for the twelfth of September. Twelve sales above it, and the till's total underneath. The same number Ember gave. Step six: one more ask. A short note to her café manager, Jo: best day, worst product, and the Saturday idea. Done. Plain words, the right numbers, signed Maya. And it waits on her. It's a draft, and it goes nowhere until she says yes. Now try it on your own spreadsheets. Stock counts: what's running low. Bookings: your busiest hours. Expenses: where the money goes. Same three moves: one folder, a plain ask, and say what you want back. That's spreadsheets. Put the file in one folder, ask in plain words, and say yes as it works. You get a clean sheet, a chart, three answers you can check, and a draft that waits for your word. Pick the sheet you've been avoiding, and hand it over. Whatever your spreadsheet is, sales, stock or bookings, you get the clean sheet, the answers that matter, and you're the one who says yes. Real work, finished. By an AI team you never had to hire. Let Murage handle it. Get started at murage.ai.