Sales Forecasting Tool

The client asked us to create a tool that would allow to report, analyse and forecast sales data taken from an SQL database. The fast growing client wanted to replace a manually kept spreadsheet, which was just not good enough any longer.


  • Design of a ‘database’ and lookup tables (in Excel, which could later be maintained in SQL server or Oracle databases)
  • Building CSV interfaces, so that actual data can be imported on the touch of a button.
  • Menu driven navigation
  • Professional look and feel
  • Design of templates for the different functions (e.g. forecast, budget, analysis, reports)
  • Multi user capable
  • Programed in Microsoft Excel VBA
  • Use of cell protection to avoid accidental overwriting of formulas

Are you interested in our services? Please contact us for a free quote.

Excel Software Solutions