Are you experiencing these issues with your MS Excel applications?

* Workbooks difficult to maintain and change? * Difficulty reporting on data (especially historic data)? * Users seeing too much, or not enough data? * Remote users have to email their Excel sheets to a central location causing a process and data bottleneck? * Documentation difficult to keep up to date? * Activities not being audited?


We can also convert your MS Access applications to SQL Server and ASP.NET. See here.

Step 1 - Analyse

image31

1. We analyse and document your existing Excel applications by looking at...

  • Your existing Excel spreadsheets and workbook designs 
  • Existing Excel user interaction
  • Existing Data flow (manual and automated)
  • Existing Excel Data validation 
  • Existing Excel Excel database(s)
  • Existing Excel Data storage/access and existing ADO/DAO data connections
  • Existing Excel Data retrieval requirements
  • Existing Dashboards, Management Information, pivots, charts, filters etc.
  • Existing Excel calculations and custom functions
  • Existing Macros, Add-Ins and VBA
  • Existing VBE screens and underlying VBA
  • Existing Security in place

Free onsite consultancy available to discuss your requirements

Step 2 - Discuss

image32

2. We discuss converting to give you...

  • Rich screens built to your exact requirements with enhanced validation and user guidance. 
  • All the benefits of SQL Server such as unlimited storage (access all historic data), quick and efficient data retrieval, Stored Procedures, User Defined Functions, Triggers etc.
  • Dashboard based Management Information customised to your exact requirements.
  • Pivots, grids, charts used to simplify/enhance your data gathering and data presentation
  • Reports can be amended by end-users and saved
  • Full security model with auditing
  • Automated feeds to or from other systems 

Free onsite consultancy available to discuss your requirements

Step 3 - Convert & Build

image33

3. We Convert and Build

  • We design your new data model and structures based on your requirements with an eye on any future needs
  • We convert your existing Excel data to SQL Server, including any historic data as required
  • We build your screens and reports
  • Includes configuration screens so you can make most changes in-house
  • Includes on screen help, themed and branded user guides and documentation.
  • Can include branded end user training course (CBT or classroom)
  • Full telephone support included
  • Includes free on-site consultancy day(s)
  • If required we can also provide full source code

 Free onsite consultancy available to discuss your requirements 

Free On-Site Consultancy

To discuss your requirements we can provide a free day's consultancy (UK) with no commitment

If you proceed we can provide additional free days on-site

Our Offer

Guaranteed conversions to ASP.NET and SQL Server from your Excel application(s) 

For example: T&C Monitoring, Workforce Monitoring, Productivity Measurements, Remote Data Gathering, Complaint Handling, File Checks etc.

We can provide free on-site consultancy on your premises  to discuss your requirements.

We can host the .NET/SQL Server application(s) for you or use your own servers.

If required we can also provide full source code.

Click here to see an example of how your Excel based system may look once converted to .NET and SQL.