Proceses Product Management Computer Applications R+D Assistance Projects’ Exchange  
        esp cat eng deu  
    Computer applications      
   

Nowadays is more and more fulfilled that knowledge is power, that is why the importance to manage the information in a good way, which enables a more clear interpretation. MASA offers software development on C-language, Java, Visual Basic and Matlab, to manage and evaluate big databases with procedures that repeat periodically.

Concrete cases:

  • Reorganization and administration of intern databases (for example product catalogue) periodically.
  • Statistic analyze of the data of measure devices (like measure of dimensions).
  • Analysis and representation of the evolution of significant values according to desired parameters (for example sails according to sector).
  • Web design and from the internet accessible applications.

 

 

    
 
 
Project samples - Database management by means of a Visual Basic application
   
         
 

Main objectives: Implementation of a computer application to manage, considering the desired tasks, a costumer's database. For this sample were the following tasks programmed: order customers according to sector, give format to the description of the customer according to the commercial relation, order customers in a sheet according to location, sum up the last visits and gather together the contacts that require urgent attention.

General performance of the program: The structure is designed in task blocs, where every block is a function. Therefore every task is executed by a specific function. In this way the structure of the application remains clearly arranged, in order to identify errors in a easier way. That allows to speed up actualizations and modifications on the application.

   
 

Needed codifications: In order to modify the cell format according to the commercial relation with the customer, this application is configured regarding that the customer introduces in an extra column called "Estado" the state of the commercial relation with the customer: "p" for pending, "no" for no interest, "si" for interest. To point at urgencies, the character has to be introduced in a specific color format. For this sample case, were chosen the red one.
aa Illustration 1: Screen capture of the program code, where the aa modular structure can be appreciate.
    
 

Error notifications: it's foreseen that some cells in the codification column contain unrecognized characters due to shorthand errors, or some empty cells due to oversight. In these cases the program transmits an error message in the output cells in the Excel table, specifying the row where the irregularity appeared.

Program implementation: a technical manual with the detailed description of the software performance is given for his implementation in the customer’s enterprise. For more complex applications, is foreseen small seminary to form the personal.

      
     
 
Illustration 2: Screen capture of the database. On the picture can be appreciated the output cells in orange (for example error messages), the input cells in green and on the bottom the database.
 


 
MASA, Método y Análisis Soluciones Alumni. Tel: 629156269, Mail: info@masa-ingenieria.com