1Add this month's files
First run only: last month's Corporate Subs file
Needed once, to give the tool the corporate contracts already running. After that the list is kept inside the ARPU file, so leave this empty.
2Check the month and FX rates
Month-end rates per €1. They fill in from the ECB when you add the Piano report – the same rates as the CBI file.
3Revenue journal figures optional
For the Estimated Digital Revenue sheet. Leave blank to skip.
Add the three files to start.
What you'll get
About three minutes after you click Run, this side shows the month's figures and the files to download.
B2C, B2B and combined ARPU, subscribers and MRRThe figures for the three Summary tabs and David's report.
Deferred revenueThe Piano and Corp. Subs lines for the Deferred Revenue Monthly Summary and Gillian's journal.
Updated ARPU fileNew B2C and B2B tabs, FX column, Sub Count and summary columns. Upload this one next month.
Piano Deferred Revenue fileEvery row of the Piano report with the formulas filled down and totals by currency.
Corporate Subs fileBuilt from the Naviga export and the sales file, with every new invoice and where its subscriber count came from.
Recognised Revenue splitThe new month's row added to the Recognised Monthly Digital Revenue Split file, which is kept inside the ARPU file.
MRR SummaryAll of the above as a text file for the month's folder.
Running the update
Keep this tab open.
- Load the calculation engine
- Build the Piano Deferred Revenue file
- Build Corporate Subs from Naviga and the sales file
- Add the month to the ARPU file
- Save the files
| ARPU per month | Subscribers | MRR |
|---|