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

Transportation

ABUX provides the opportunity for detailed tracking of costs related to transportation and logistics activities, allowing for transparency in vehicle and route-related expenses.

Cost Allocation

Cost allocation is crucial in transportation processes, as it allows for the effective tracking of costs associated with smaller units, such as vehicles, shelves, and pallets. This helps in demonstrating the complete cost coverage.

Management of Energy Costs

The allocation of energy costs is particularly important, for example, in the case of an electric power storage facility. Like other costs, heating expenses can also be broken down into smaller units, allowing for precise distribution of costs across different activities.

Rental of Warehouse Spaces

ABUX enables organizations to rent out their warehouse spaces and allocate costs accordingly, making service costs clearly visible to partners.

Optimizing Service Prices

ABUX enables the effective and competitive pricing of individual services offered to various partners.



Do you want to see ABUX in action?

Book a live presentation