Document details

M&Excel: A Practical Guide to Building Results Monitoring Tools in Excel

Eschborn: energypedia consult (2016), 22 pp.
"This guide shows, besides other things, how to implement the traffic light function of Excel. Aside from this function, it is in general very easy to visualize information with Excel. In this respect, the progress of indicators along the results chain of a project, but also the cash flow can be graphically presented [...] Another goal of this manual is to stress the point that Excel is much more than a static tool in which data can be handled in tabular format. By means of cross-linking data, the whole monitoring system becomes dynamic so that the whole data processing works nearly automated. Time and resource intensive double entries of information can be avoided, since the majority of data can be updated, calculated and visualized automatically." (Introduction)