We use informatic technology

for reach your

business's objectives

We develop solutions...

Ad Hoc

Our objective:

satisfy the customer

Our method:

work together to develop the best solution

Via Londra 11 - 46047 - Porto Mantovano - Mantova - P.IVA IT01902540200
+39 0376 392859

GlaxoSmithKline

Creating ADD-in for Excel

Ad Hoc Sistemi has developed a toolbar in Excel on behalf of GlaxoSmithKline, a pharmaceutical company engaged in the research and in the development of prescription medicine, innovative vaccines and other products of self-medication.

Sviluppo_Gestionali_Icon_03

Needs

The customer needed to group together in a single instrument the use of multiple applications for standardize, sort and create chemical structures,by accessing, through web services, to heterogeneous information that reside in different databases of properties and maintaining consistency with legacy data.
The instrument had to provide a graphical representation of the chemical structure, giving the user the ability to import and export these formulas easily and intuitively.

Sviluppo_Gestionali_Icon_02

Solution

Using Microsoft .NET 2007 for creating Add-in for Microsoft Excel, it was developed a new toolbar "Helium Ribbon" that manages the compound appear in Excel sheet and loaded by calling a web service from various customer database.
Througt pressing of simple buttons in the toolbar you can:

  • highlight the compounds which have the same chemical formula;
  • delete duplicates;
  • insert new compound and validate the chemical structure.

Have been implemented specific features according to the type of the same compound, can be activated by a special task panel that will auto configure based on selection by the user.

Click here for the presentation of the project

Sviluppo_Gestionali_Icon_01

Technology

The application was developed using Microsoft Excel 2007, Microsoft .NET 2007, JChem for Excel Add-in, ORACLE database, SQL Server database.