# Site diary with Excel: templates, pros and cons \| Mela

Source: https://www.mela.work/en/blog/construction-logbook-excel-templates-pros-cons

Language: en

Discover the pros and cons of using an Excel site diary, with examples of private and public works and a digital alternative for managing documents.

## Site Diary with Excel: Templates, Examples, Pros and Cons

A site diary with Excel is a widely used template in the construction industry, with both pros and cons. With the help of some examples, let’s look at the limitations of this template and how the “digital 2022” can improve it.

Site Diary with Excel

Site Diary with Excel



The Excel site diary, an editable digital template, is now a necessity for anyone acting as the Works Director of a construction project. Italian regulations require it, whether through **[the decree law of 2018](/en/blog/italian-construction-logbook-law-decree-49-2018)** or through ANAC’s guidelines for Site Managers.



## Site diary with Excel: examples for private works



Here is an example of the most typical Excel site diary, widely used for private works, with particular attention to costs. We have seen this template in every possible form; it is used by many Works Directors and often for large projects too.

Site diary with Excel

> Let’s be honest, a document like this is of limited use. What are the drawbacks?



### 1. Limited flexibility



A template like this has to be completed day by day and cannot be used for any purpose other than as a passive record of what has happened.



### 2. Lack of information



This Excel site diary template is not entirely complete: it is missing the test register, service orders, the minutes of commencement of works, the minutes of completion of works and all the other documents that the site management team will eventually have to digitise. We also notice **the lack of a type of information that is indispensable nowadays: [photos and videos.](/en/blog/certified-construction-photos-italian-tax-credit-transfer)**



### 3. Legal validity



The Excel site diary is widely used, but it is not sufficient on its own because it has a small problem: **it has no legal significance**. To give it legal significance, it must in fact be printed, signed and archived. This does not have to be done with paper, but with a digital signature and certified email (PEC).



## The Site Diary for public works



For [**public works**](/en/blog/italian-public-works-site-accounting-tools), the bar is higher, particularly when it comes to the administrative burden. Let’s try to simplify things here. In this case, the RUP (sole person responsible for the procedure, or project manager) appoints the Works Director to ensure that the works are carried out:



- In compliance with the project


- Within the required timescales


- Within budget


- To the required quality



So, is it the same as in the case of private works? Not quite, because **what was previously optional becomes mandatory here.** Below is an example of a typical Excel site diary for a public works project.

Site diary with Excel for public works

## The digital Site Diary with Mela



Italian regulations require an editable digital template. We have looked at some examples of Excel site diaries, with their pros and cons. But when we talk about digital tools, do we necessarily have to react allergically to instruments from the ‘90s, which are difficult, expensive and inefficient? Not necessarily\! **With [Mela](/en) it is possible to create a [complete Site Diary](/en/blog/construction-logbook-completed-example) with genuine digital validity** in a really simple way, without the worry of printing or archiving.



> Photos taken go directly into the document, the workers and equipment are recorded, and signatures are added directly in the app.

Workforce report in Mela

In the same app, you can also create measurement books, progress reports, test registers and manage all minutes and reports using your own templates. In addition, **signatures are managed automatically within the application thanks to [BlockChain technology](/en/blog/construction-blockchain-report-notarization)**[,](/en/blog/construction-blockchain-report-notarization), thereby ensuring the legal validity of documents and replacing PEC, a laborious and somewhat outdated tool.



Mela is a flexible, comprehensive solution that allows you to prepare a digital Site Diary with full legal validity, ready for archiving without having to use Word or Excel.



**See how to create and export the Site Diary in Mela**

## Article video
