Two Microsoft Excel worksheets combining to form a estimate/quotation form for a heating engineers. The company carry out a lot of work for a local authority, especially refurbishing tower and housing blocks, so the worksheet had to cope with multi-choice component use. The engineer would survey a site and fill in the details on the workbook shown behind. Back in the office, the workbook was transferred to the office computer and the process button pushed, the estimate/quotation is collated and printed out. There are several other features, such as if a particular component is used, then another must accompany it, etc. Written in VBA.

Back to Office Home Page