Better together: ABUX + MS EXCEL

Many people use Excel as a database manager, which is not its original function, making this activity cumbersome. ABUX uses Excel for data presentation, but handles database management itself, returning Excel to its original spreadsheet and data presentation function.

With ABUX, accurate and consistent data management is achieved while allowing the user to remain in their familiar environment.

Read more
Excel Abux
Basic excel functions
Formulas, Macros, Graphs, Pivot tables, formatting solutions etc.
Software based on OLAP cube, dinamic Excel-extension.
Based management
Centralized data storage (SPOT - single point of truth)
Automatic data transmission from source systems
Data security is available over huge number of records
Role-based access control
Implementing structural changes rapidly
Database management (on Excel platform)
Financial planning
Direct connection with database (even through Pivot)
Templates for input data
Top-down planning via Pivot
Usage of templates for planning (with automatic access control, no need to create separated tables for users with various data access)
Automatically filled business plan through the aggregation of already completed input templates.
Handling parallel versions of business plan
Reporting
Automatic data update in the background
Scheduled report sending function
Rapid, ad-hoc reporting
Unlimited number of dimensions and hierarchies in business reports
Drilldown (data drilling) till source data (i.e. invoices)
Managaeble size of reports (data is stored in Advanced Budgeting instead of Excel sheet)
Additional, extra functions
Cash-flow, balance sheet and P/L immediately
Consolidation (complete financial consolidation including inter company eliminations, partial ownership rules
Template for planning an investment, calculation for depreciation
Anonymus platform for HR planning
Age of assets as an automatic function in analysis
Cost allocation (based on product/partner/project/working no./cost-centre/etc ...)
Calculation of break-even point (based on partner or product hierarchy)
Calculation of bonuses (based on partner and product hierarchy)
Forecast calculation in background
Copying versions rapidly - to create any combination of versions based on facts or plan data

Manufacturing

ABUX provides the opportunity for flexible management of manufacturing processes, especially in the case of deeply complex bill of materials. The following features assist in the effective tracking of the manufacturing process:

Management of Complex Bill of Materials

ABUX flexibly handles deep multi-layered bills of materials, allowing for the tracking of raw materials and semi-finished products.

Hierarchical Structure

The system structures data hierarchically, facilitating easy modification and management of individual components.

Tracking Prices and Costs

With ABUX, the different purchase and sales prices can be easily managed, enabling cost optimization.

Parallel Management of Plan Versions

The system allows for the simultaneous creation of plan versions, making it possible to quickly compare different scenarios and pricing options.



Do you want to see ABUX in action?

Book a live presentation