To perform the financial analysis of a company, we created an Excel template, composed of four sheets, interlaced with each other. In these sheets, we find a Profit and Loss Statement (PyG), a Balance Sheet (BCE), a Cash Flow Statement and a Summary Table, where we also calculate the Ratios that financial analysts need. The […]
Continue readingDocumentary management for Occupational Risk Prevention Contracts (ORP)
We carry out the document management as an extension of an application initiated by us and detailed in the section “Management for Occupational Risk Prevention Contracts”, for: the combination with client and contract data, with a model contract. facilitating the safeguarding and tracing of contracts signed by clients. carry out contract renewals. Below we explain […]
Continue readingData transfer from SAP to Access
The personnel department of a multinational company asked us to create a customised programme to transfer data from their SAP application to a small Access database. The personnel department uses the Access database, for its statistics and training activities. But the data is updated centrally in their SAP application. Therefore, the data transfer, allows the […]
Continue readingManagement for Occupational Risk Prevention Contracts (ORP)
For a company dedicated to the occupational risk management of its clients, we created a customised application that allows the administrative processing of contracts. The program has a main part, to manage the data of the clients, their contacts, the addresses that they have (central offices, delegations, warehouses, factories, etc.), data of invoicing, Contracts, Disciplines, […]
Continue readingWork Order Management for die cuts
The purpose of the program is to see the list of work orders and what phase each one is in. The programme is managed from several networked computers, but the work list is projected to a television set, which is located in the workshop, in view of all the operators. The program has a section […]
Continue readingExcel template for accounting
It is an Excel book, which contains several sheets in order to make a simple accounting, with a journal of expenses, a balance sheet, and budget for the next year. We explain in more detail the structure of this template. The book consists of a sheet for the definition of the accounting accounts to be […]
Continue readingExcel book for the payroll of a company
It is an Excel book, for the personnel department of a company, which contains several sheets, in order to follow up the monthly payroll. The Excel book presents a monthly sheet, keeping a total of 24 sheets, two years. Within each sheet, we find a column for each month of the year, in a correlative […]
Continue readingExcel Book for the Design of Solar Thermal and Aerothermal Energy Production Facilities and Issuance of the Energy Efficiency Label
Excel book prepared to design solar thermal, aerothermal energy production facilities, based on the F-CHART method and also includes the generation of the energy efficiency label. It is composed of 40 sheets, linked together. These sheets allow you to calculate the amount of solar panels needed for a Solar Thermal installation, to know what type […]
Continue readingApplication for self-evaluation training, in web format
Application made as if it were a web page. It is a program that allows the introduction of diverse contents, with the objective that it serves to carry out self-evaluation courses. In the example we show, it is relative to the occupational risks of a company. The programme allows the introduction of an infinite number […]
Continue readingMedical Resource Management (ERP) in Surgical Dermatology
Medical Resource Management Program (ERP), for a Medical Surgical Center with Laser Treatments. The application includes an agenda that seeks maximum availability by mixing the agenda of each resource and agreeing on coinciding times. Valid for consultations with multiple doctors, rooms or boxes, operating rooms, appliances, therapists, assistants, etc.. When a patient requires an hour […]
Continue reading