#REF!
A formula points at a column that isn't there any more.
The Excel Uplift · Launch
Welcome to the Matrix.
Spreadsheets have run a lot of EMG for years. Now the work we share is moving into apps of our own, all opened from the EMG Portal with one sign‑in. Ticketing and Documentation are the first two.
Why we're doing this
Where shared spreadsheets get hard
Spreadsheets are quick to set up and everyone knows how to use them. They get harder to manage once a whole team shares one file and the business depends on it.
Budget_FINAL_v7 (2).xlsx
There are several copies, each a little different, and it isn't clear which one is current.
Locked for editing by another user
Only one person can change it at a time, so everyone else waits.
RE: FW: latest copy
Each emailed copy changes on its own after it's sent.
=RunMacro()
The macro does important work, and few people know how it works.
Hidden
A hidden tab is still in the file, and anyone with the file can unhide it.
The Excel Uplift moves this kind of shared work into apps, one spreadsheet at a time. Excel stays for the analysis and modelling it does well.
How it works
How the portal and its apps fit together
You
Sign in once, with your work email
On a computer or a phone.
The portal
Decides which apps you can open
An administrator chooses which apps each person can use.
The apps
Each decides what you can see and do inside it
Ticketing
Documentation
Operations
Accounts
+ 4 more
EMG data
Kept once, in EMG's own databases
Hosted in Sydney. Apps get data from each other instead of copying it.
What it means for you
One password
Your work email and one password open every EMG app you've been given.
Information that stays current
Each piece of information is stored once, so when someone updates it, everyone sees the update.
Access that fits your role
You see the apps you work in. Inside each app, your role decides what you can see and change.
A record of changes
The portal and the apps log sign-ins and changes, so you can see who changed something and when.
Live now
Ticketing and Documentation are ready to use
We started with asking IT for help and looking up how things are done, because everyone at EMG does both.
Ticketing
LiveTicketing is EMG's IT help desk.
- Raise a ticket in the portal, or email the service desk and the email becomes a ticket.
- See where your ticket is up to at any time.
- Get an email when it changes, and rate the help once it's resolved.
- The IT team gets queues by team, SLA targets, dashboards and an audit log.
Try this firstRaise a ticket for a small IT problem you've been putting up with, like a monitor that flickers.
Documentation
LiveDocumentation is where EMG writes down how things are done.
- Spaces for teams and topics, with pages you can browse or search.
- Every save is kept in the page's history, with who made it, whether a person or an AI assistant.
- Comment on a page, @mention a colleague or give them a task.
- Download any page as a PDF.
Try this firstOpen the Ticketing user manual in Documentation. It explains how to raise and follow a ticket.
What's next
The apps we're building next
The EMG mark has 29 tiles. We've lit one for the portal and one for each live app, and we'll light another each time an app goes live. Six apps are being scoped now, listed in no particular order.
3of 29 tiles lit
LiveBeing scopedNot yet planned
Operations
ScopingDaily checklists, shift handovers and market notices in one place.
Accounts
ScopingCollects billable items from each EMG app and prepares invoices for MYOB.
Retail Gas
ScopingCustomers, sites, contracts and pricing, moved over from the PowerApp.
Retail Electricity
ScopingMeter data, network tariffs, quotes and bills in one place.
Wholesale Gas Portfolio
ScopingCurrent and planned contracts, with saved scenarios run across the whole portfolio.
Wholesale Gas Management
ScopingIts scope is being worked out with the Operations team.
Does your team rely on a spreadsheet that should be an app? See the IT team and tell them what the spreadsheet does and who uses it. We'll use the suggestions to decide what to build after these six.
Get started
How to sign in
Go to the portal
Bookmark it. Every EMG app opens from here.
portal.apps.energymatrix.com.auSign in with your work email
Use your EMG password. If you've forgotten it, choose Forgot password and we'll email you a link to set a new one.
Open an app
You'll see the apps you can use. Start with Ticketing or Documentation.
If you can't sign in, email the service desk. Your email becomes a ticket and IT will follow it up.
Questions
Common questions
Is Excel going away?
No. Excel is still the right tool for a lot of work, especially analysis and one-off models. The apps take on work that many people share and repeat every day.
What happens to the spreadsheets we use now?
Each one stays in use until the app that replaces it is live and tested. We'll move the data across with the people who use the spreadsheet.
Where does my data live?
In EMG's own databases, hosted in Sydney.
Who can see what?
You only see the apps you've been given. Inside each app, your role decides what you can see and change, and every change is logged.
How do I get IT help now?
Raise a ticket in Ticketing, or email the service desk and your email becomes a ticket.
Can I suggest the next app?
Yes. See the IT team and tell them what the spreadsheet does and who uses it. Suggestions help us decide what to build after the six apps already planned.
Does it work on my phone?
Yes, in your phone's web browser. There's nothing to install.
Who's building it?
EMG's own team. Each change is tested and checked on a test copy of the portal before it goes live.