PGS Operations turns the daily house-totals file and the slot export your property already produces into the day, the month and the floor. Every figure is set against a fair comparison and names the file it came from.
Month end today means several of your people pulling figures out of several systems, and then someone laying the spreadsheet out by hand. By the time the pack is finished, nobody has the time left to ask what actually moved win.
Your daily house-totals file and your slot export go in the way your systems already produce them. Every report, the month-end pack included, comes back in one place and in the same layout every month, so nobody is chasing a figure through someone else's system or an old email thread. Each figure names the file it came from, and no one rebuilds last month's spreadsheet to get this month's.
Each day against the same weekday before it.
Coin-in, win, drop, free play, comps and whatever else the file carries, day by day for the whole property, with each day set against the same weekday over the weeks before it. Choose a 30, 90, 180 or 365-day window, and put send days beside non-send days.
Each day is set against the same weekday over prior weeks, so a soft Tuesday is measured against other Tuesdays. Send days are held apart from the rest, and a day marked for weather or construction carries its reason.
What was running on the day the figure moved.
Add a promotion and mark its days complete as they run, and keep a dated list of the events that explain a day, such as weather or construction. When a Saturday reads low, the reason sits on the calendar beside it.
The calendar shows which promotion headlined each day, the days marked complete, and dated events such as rain or construction. Each day is set against the same weekday, and send days are set against the days with nothing mailed.
The full month, or matched weekdays.
Take a chosen month against last year or against last month, as the full month or as matched weekdays. The scorecard carries 41 metrics grouped by source, each with its definition, its formula, both figures and the change, and a month your controller has signed off is frozen as a permanent record.
Every line is built from the files the property already produces, and a month that is signed off is frozen as a permanent record. The printable pack carries all 41 metrics with the definition and formula behind each one.
More play, a different hold, or both.
The breakdown splits the change in win into how much of it came from more play and how much of it came from a different hold. A month that rose on play is a different month from one that rose on hold, and your general manager sees which one it was.
Win rose $59,000 in October. On slots, more play and a higher hold added about the same amount, and lower table drop gave part of it back. Matched weekdays sets Saturday against Saturday when a month carries an extra weekend day.
The pack your controller can hand across a table.
The printable pack holds the scorecard, the win breakdown, the matched weekdays and a score for every promotion that ran that month. Print it, or save it as a PDF.
The pack puts the month on paper: the scorecard, what moved win, matched weekdays, and a score for every promotion that ran. Freezing the month makes it permanent, so a reprint in March matches the copy signed in November.
Machine by machine, from the export you already produce.
A sortable table of every machine on the floor with its coin-in, its theo, its hold and how it compares with its peers. Open one and its monthly history opens with it.
The whole floor from the slot export, sorted on any column. Machines earning less per day than their bank are marked for review, and one click opens a machine month by month.
The machines worth a decision this month.
One list ranks the machines earning less per day than the rest of their bank, so the review starts with the machines that need one. A second list holds the high-demand machines, protected so that one low-hold month does not pull a machine your players come for.
Machines earning less per day than their bank rise to the top of the review list, and a high-demand machine that held low for a single month stays on the floor. Open one for its month-by-month history.
Thirty minutes, and your general manager sees the month end and the floor built from your own figures.