EBMS Nimblex joins VendorPanel, creating a world class Source-to-Pay procurement suite
Wednesday August 12, 2020

Go Beyond Spreadsheets with eForms .

3 minutes

Is there a better way than using spreadsheets?

Many businesses rely on carefully constructed spreadsheets to keep track of their processes.

Entering data into the complex web of equations and conditional formatting is a time-consuming and intensive task. Like all data entry, it is difficult to ensure accuracy. And when errors do occur, it can take hours of data cleaning to identify and correct mistakes.

Moreover, there is no audit trail to track these errors.

And significantly, there are no automation features native to spreadsheets such as workflow and automated communication.

Are spreadsheets driving you crazy?

Spreadsheets are clunky but still widely used

Despite the drawbacks, spreadsheets are useful tools. A properly designed spreadsheet allows you to process numerical data and scenarios.

However, the fact remains they are complex to setup, a nightmare to keep track of and risky to maintain. 

Besides which, a complete business management solution is more than just a register, but should provide company-wide integration, secure compliance and comprehensive reporting.

Why tolerate complex spreadsheets?

Users are unwilling to surrender their spreadsheets due to the inflexibility and high costs associated with trying to create similar applications within their enterprise management solutions.

Often, a spreadsheet is a ‘work around’ as it’s too expensive to create a new register or application module in SAP, Oracle or similar.

The fact is that the requirements of these types of solutions (e.g. pricing, hierarchies, cost allocations, data entries, business rules, etc.) all change far too quickly for IT to respond with updates.

The better way is with low-code eForms to build powerful solutions

Surely there is a solution for those who require all the benefits of spreadsheets, but need something with more muscle. There has to be something highly flexible and cost-effective that can do the job more efficiently by being fully automated and digitised.

eForms created with low-code, drag-and-drop development

Nimblex provides you with the ability to create data entry eForms which are configurable to your exact needs via a simple drag-and-drop interface that anyone can use.

The web-based system allows you to convert spreadsheet line items into online web forms. By using Nimblex, you have the capability to to turn your humble spreadsheet register into a powerful online management solution that integrates with other systems and has advanced reporting capabilities.

You can do all of this at a fraction of the cost, when compared to gaining similar functionality in tier one management solutions such as SAP, Oracle or IBM.

How Nimblex works with eForms

Nimblex has a parent-child dynamic, similar to Excel formulas, which keeps the interface familiar. Building templates for your business allows your system to grow with ease. This will help you:

  • Produce custom-made forms and business rules specific to your company’s needs.
  • Create input forms, to mine the data you want from other users.
  • Excellent user experience with enhanced features and functionality.

Nimblex speaks the language of the spreadsheet – it can understand the contents of a spreadsheet, and can also output data back into a spreadsheet.

We use Excel or CSV to:

  • Import and export data, records, users and departments
  • Enable data manipulation
  • Transfer data between systems
  • Generate new forms

Nimblex has created a formula language, which is highly compatible with that found in Excel.

Many of our clients have used Nimblex to replace Excel for functions within their business, because in many ways, Nimblex is the next logical step from building and managing your register in Excel.

It’s a cost effective way to convert your basic spreadsheet system into a multi-user system with automation, access control and auditability.

Jeannie De Vynck

What is Nimblex?

Created in Australia, Nimblex is a cloud-based integrated business management platform that will deliver the business process automation you need.

We configure Nimblex’s Core solutions using our unique low-code tool and a wide variety of value-added features. This gives the flexibility that enables us to automate any type of process, especially if compliance and transparency are non-negotiables.

Our world class support team is ready to help.

1300 721 159

+61 3 9958 0000