|
Downloadable files demonstrate some of the key ideas of the Mote Method. It is not the intention to review the correctness or application of the theory but to demonstrate the quality principles advocated by the Mote Method.
All examples are constructed using MS Office 2003 under Windows XP. For demonstration purposes, we have made files available for download in Adobe PDF format.
These examples cover the development of the spreadsheet. Most of the available time is spent planning and developing the spreadsheet to its conclusion. This process is supported by a flowchart which hyperlinks to the relevant pages. The flowchart is the plan and the navigational map for the spreadsheet. In the future, the spreadsheet will be developed to address the future functionality.
Consider the absence of the flowchart and ask yourself how you would create a spreadsheet without one. The flowchart adds value to the spreadsheet for the reader, the development of the spreadsheet and demonstrating the theory in action
The associated MS Word document took less than 3 hours to prepare. Intentionally, there is no dynamic link between the document and the spreadsheet.
Other examples are:
These examples illustrates the before and after treatment on a pilecap design. In a typical application, the worksheet solution is multiplied for all the problems under design consideration, without the spreadsheet being sufficiently checked for correctness. If the spreadsheet needs to be corrected, it adds to the time involved, at wrong end of the design cycle.
The ‘Anchorbolts worksheet before’ spreadsheet is 229 lines long compared with the condensed ‘Anchorbolts Worksheet after’ spreadsheet, which is 91 lines long and has only one worksheet, for all the design problems. The input_output worksheet defines the problems, and with the use of a macro (disabled), the results from the spreadsheets are posted alongside. The spreadsheet can still be used to analyze specific problems.
The detailed differences are explained more fully in The Engineer’s Tables.
Disclaimer
Anyone using these examples does so at their own risk. Motagg Solutions accept no responsibility as to the validity and/or correctness of the numbers or theory included in these documents. No proprietary information is disclosed and should not be construed from the information in the downloads. All names, dates and locations are fictitious and any resemblances to the living, corporations or projects is purely coincidental
|
