excel projects dewhirst order book Many sales people use spreadsheets to keep track of their orders. However, collating this data for the whole sales force can be tricky because individual sales people tend to use different formats for their spreadsheets. This system gives the sales force the flexibility to keep track of their own data whilst preserving a common format that can be imported into a central database. This is achieved by providing the functionality to add, remove and format the orders in a controlled way by including buttons that perform the tasks whilst keeping the layout fixed. The controls for the spreadsheet are provided on a 'floating' control panel that allows the users easy access to the control buttons no matter which area of the overall spreadsheet they are working on. dewhirst order book trus joist import Often there is a need to create Excel spreadsheets using data from another program. In this application a parts list is taken from a design package and then used to create an invoice and price/cost calculation tool for the project. trus joist import The application (shown above) also allows multiple spreadsheets to be combined into a single workbook for larger projects, adding a summary sheet to display the totals for the entire project. To create this workbook the user need only select the folder in which the single spreadsheets are saved - the combination and calculations are all handled automatically, saving a great deal of cutting and pasting of data. site man spreadsheet This excel-based application (shown below) was developed for Carillion Highway Maintenance. It reads data from text files output from an off-site database system, performs a complex series of operations on the data and then produces a range of spreadsheets including a fully formatted summary sheet. site man spreadsheet This system has significantly reduced the time required to generate important financial information every month. The project was completed within two weeks to meet a tight deadline.