The use of a tuned absorber to control the vibration amplitudes of a secondary system subjected to base excitation via a primary system is investigated computationally. A second investigation considers the use of an impact damper mounted on the tuned absorber to control vibration amplitudes of secondary system subjected to base excitation via the same primary system. A series of spreadsheet programs have been written to assist in the investigation of the two vibration control problems. Techniques for solving both closed form and numerical integration problems using spreadsheet macros are presented. The graphics capabilities of spreadsheets are used to present the results of batch case runs of different system parameters. User manuals for both series of programs have been written, fully explaining the programs and how they can be used as a basis for continued investigations of these and similar situations. / Thesis / Master of Engineering (ME) / This thesis has been partially OCRed.

This paper presents DECO (Dresden Enron COrpus), a dataset of spreadsheet files, annotated on the basis of layout and contents. It comprises of 1,165 files, extracted from the Enron corpus. Three different annotators (judges) assigned layout roles (e.g., Header, Data, and Notes) to non-empty cells and marked the borders of tables. Files that do not contain tables were flagged using categories such as Template, Form, and Report. Subsequently, a thorough analysis is performed to uncover the characteristics of the overall dataset and specific annotations. The results are discussed in this paper, providing several takeaways for future works. Furthermore, this work describes in detail the annotation methodology, going through the individual steps. The dataset, methodology, and tools are made publicly available, so that they can be adopted for further studies. DECO is available at: https://wwwdb.inf.tu-dresden.de/research-projects/deexcelarator/.