ATRELLUS — CUSTOM EXCEL & POWER BI SYSTEMS SPEC: ZERO MANUAL ENTRY HONG KONG · EST. 2016
What we Do

Real workbooks. Real results.

17mkts
Consumer Products · 17 Markets

Financial Forecasting Model

  • 3 months to build a 10yr + 5 years historical data Excel Production & Full Financial Forecast Model
  • Multiple illegible spreadsheets lacking automation, data integrity and consistency — highly error prone
  • No reporting, graphical representation or scenario modelling capabilities
1 Client Challenges
  • DevOps discipline to design and develop a highly automated Excel Application using small team agile methodology
  • Atrellus High Structure development eliminating ad hoc user manipulation, ensuring data accuracy and integrity
  • One Click automation for Report Activation, Scenario Modelling, Data Ingestion, Comparative Analysis, Data Export
2 Solutions
  • High level of functional automation delivering a single Model across all markets
  • Controlled environment ensuring data integrity and accuracy
  • Resident dynamic modelling and scenario analysis
3 Key Improvements
5min
Insurance · Hong Kong

Insurance Policy Quote Builder

  • Inefficient mechanism to construct multi-product single Policy quotations
  • Complex rate structure requiring excessive time to compile tiered loading scenarios
  • 100% manual calculation and quote generation
1 Client Challenges
  • Design and development of a single calculation engine accommodating limitless quotations
  • Minimal User intervention operating within a controlled environment to ensure accuracy and integrity
  • Intuitive interface delivering accelerated User performance and self-reliance
2 Solutions
  • Policy build-up created in less than 5 minutes with 100% accuracy
  • Flexibility to modify client parameters to deliver comparative quotations
  • Speed to respond to client requests within minutes vs. days
3 Key Improvements
90%
Logistics & Shipping · Global

Record Search & Update

  • A client provides a raw Excel data file of 70,000+ Purchase Orders, monthly
  • Searching and updating a single PO is like “finding a needle in a haystack”
  • Unproductive and costly
1 Client Challenges
  • Designed and developed an automated criteria driven search mechanism
  • Single click to open and update PO details
  • Simplistic and easy to use interface
2 Solutions
  • Automation vs. Scroll, Search & Find manual process
  • Productivity improvements with User time reduced by 90%
  • Atrellus High Structure development negates potential processing errors
3 Key Improvements
80%
Manufacturing · Automotive & Aerospace

Complete HR Process Consolidation

  • Multiple Excel unstructured workbooks for various HR functions lacking consolidation and integration
  • SHR department spending >60% of their time on Excel vs. value added HR responsibilities
  • Lack of consolidated Staff records, Payroll, Insurance & Benefits policies
1 Client Challenges
  • Atrellus HR designed to consolidate and simplify all core HR processes
  • Atrellus High Structure development to accelerate processing and ensure data integrity
  • Design Thinking methodology focused on improving HR Staff engagement with simplified processing
2 Solutions
  • Single HR Application with high levels of automation, reducing user required input
  • 80% staff time savings
  • Dynamic multi-functional one-stop reporting with user defined presets
3 Key Improvements
15min
Project Management · Cross-industry

Project Management

  • Time taken to create a Project Timeline and Resource Costing
  • Clumsy graphical process to add a Project Timeline into a presentation
  • Lack of automated real-time updates of Project Progress
1 Client Challenges
  • Atrellus Gantt Wizard creates Project Timelines via a fully automated user interface
  • Automated Project Timeline Chart generation with single click functionality to copy and paste
  • Fully automated Resources and Cost Tables, Workstream Progress Charts and single click data export
2 Solutions
  • Creation and production of Gantt Charts completed in minutes vs. hours
  • One time fee and no monthly recurring subscription charges
  • User defined customisation to align with company branding policies
3 Key Improvements