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