Introduction

In this blog we show some of the work we have done throughout our career. We present those that we believe are more original and varied. Many of these works come from the restlessness of our clients, to carry out their management. Some of them are more generic, of which we have made several versions. […]

Continue reading

Excel template to make invoices

Taking advantage of one of the templates that Excel itself has, we created a template for making invoices. Our added value is that there are two sheets, one to make the invoice and another to put the list of items that can be invoiced. So there are formulas that interlace the data between both sheets. […]

Continue reading

Cash Journal Management

Management of the cash journal or daily management of cash amounts, for a retailer. Made with an Excel book, it is composed of fifteen related sheets, with: Annual Calendar Sheet. Twelve sheets, one for each month of the year. Consolidation sheet, with the totals for each month, to calculate the annual. Concept sheet, for the […]

Continue reading

Bicycle parking management, repair shop, lockers and showers

A company located in Rio de Janeiro (Brazil), asked us for a custom application, to manage a bicycle parking. The application should also include the offer of shower service and locker rental. In addition, as extra services, it offers towels, soap to the customers and repairs or maintenance of the bicycles. It also has vending […]

Continue reading

Management of futon covers production

Management of futon covers production, made in an Excel book that allows to take a complete control of the production, stock and sale. To carry out this management, the following stages have been taken into account: Entry of cloths, in rolls of several linear meters. Making the covers process, from the previous cloths. Sale of […]

Continue reading

Excel template to Overdue Premiums control

In a company whose clients pay fees for various periods, there are delays in the collection of these fees. To control the overdue premiums, a bespoke sheet was created, which is prepared to work with the overdue contributions, up to five years. The goal is to calculate the average amount for the last ten weeks, […]

Continue reading

Financial Analysis Model in Excel Book

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 reading

Excel 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 reading

Excel 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 reading

Excel 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 reading