500 million Excel users successfully manage single spreadsheets every day. However, when two or more users want to share a single spreadsheet, problems start. To attempt to solve this, businesses spend millions on enterprise applications, only to abandon them. They do not want to change their processes and adapt to new software.
NanoApps completely solve the problem of shared spreadsheets.
The UK Government awarded Synapse funding for our innovative NanoApp solution. NanoApps extend Excel, meaning many users share a single version view of real time data. Business users are now able to create their own solutions without fuss or IT. Each tiny solution does only what is needed and no more.
The Problems We Solve
Shared Spreadsheet Chaos
Sharing one copy of the same spreadsheet causes many familiar issues.
Synapse solves this problem from the ground up using UK R&D SMART award-winning database technology.
As each single spreadsheet user changes any values in any cells, Synapse synchronises them with our cloud database server and sends one version of the truth back to everyone.
The power of an Oracle database, the simplicity of an Excel interface.
We synchronise the user’s basic validation rules in our cloud server and add additional powerful database rules and constraints.
Whatever data logic that has been defined by the user is then enforced by the database by synchronising this back to each local spreadsheet copy.
Traditional Excel understands the notion of a single worksheet and the notion of formulae and logic linking cells in two or more worksheets but that’s as far as it goes.
Our database goes beyond Excel by enforcing data integrity rules such as by disallowing changes that don’t make sense with the set database rules.
Business Bottom Line
Businesses grow tired of inflexible, expensive software packages or accounting software that never completely do what they need. Reverting to spreadsheets gives them back the control they need but deadlines are missed, report data is mistrusted and huge amounts of expensive time is wasted.
We remove these problems.
Synapse connects your spreadsheets to our cloud. We provide a simple spreadsheet template into which you can insert your current worksheets or tabs – there is no complexity or new software to install.
Your team will see a toolbar that lets them synchronise their data with colleagues. The team then sees live, up-to-date and clean data on their desktops.
To configure your initial Synapse cloud service, you create ‘sync groups’ of collaborating individuals in your team.
Each user will see one version of consistent, current data. Different levels of access capability through secure, role-based accreditation and authentication will allow users to see only what is relevant to them.
Business Rules and Validation
Synapse synchronises and backs your formulae and rules in our cloud database.
We also go beyond this by providing extended Excel syntax. This allows users to harness database power to make their rule logic more effective.
Advanced users can describe database-level data integrity rules so that primary and foreign key relationships link many different worksheets together, with each effectively treated as a database.
For these expert Excel users, we also expose a programmers API and SQL interface enabling them to create sophisticated applications.
We provide extended Excel syntax that allows intelligent grouping of data according to defined named ranges. This means that highly customised pages of interlinked data reports can be created that precisely match the business needs.
Audit and Security
The Synapse cloud database keeps a complete track of every change made to every spreadsheet cell by every user at every point in time since system inception. This is invaluable for forensic audit and for industrial grade security.
Synapse has embedded our award-winning technology inside a standard looking Excel spreadsheet, making the solution perfect for large corporate deployments.
What makes this spreadsheet different is that it is linked to the Synapse cloud database server.
We call this basic Synapse configuration of a spreadsheet a NanoApp.
What are NanoApps?
A team takes the basic Synapse NanoApp template described and adds columns and rows. They add and synchronise their data, creating a clean, up to the minute view of all prospects. This is the team’s new NanoApp – created and deployed in minutes.
Enterprise software solutions often have low user adoption because they mean adapting the tried and tested method of working, whereas a NanoApp is a minimal yet powerful application that supercharges the familiar spreadsheet-based workflow. NanoApps are highly customisable and therefore perfectly fit any team’s needs.
Putting the Business Back in Control
NanoApps mean not having to ask IT for permission or software vendors to configure their packages – NanoApps are 10x faster to deploy and 10x cheaper than either of these approaches.
You can now automate whole areas of business processes very easily and without serious spending.
Synapse provides expert support when needed. When you don’t want the service any more, you switch it off and stop paying – simple.
Synapse already has substantial successful deployments of several hundreds of concurrent users in large corporates with very locked down IT systems and procedures.
For example, at a leading UK Bank where Synapse technology is used, the users edit the NanoApp validation logic themselves in order to meet the frequently changing reporting requirements from the regulator.
Help with your NanoApps
We have done extensive work in implementing solutions in the following business domains:
Programme and Project Management Office;
Automated collection of and integration of: MS Project and Excel Plans to produce a real time unified Programme GANTT and RAIDS logs to produce a real time unified Risk Register.
Resource and Capacity Planning;
Automated collection of and integration of: Resource availability, commitment and skills datasets, MS Project and Excel Plans and Financial Extracts, leading to a unified capacity plan heat map at global level and per resource line item.