IV.4.4 Recovery of results in excel and reporting word

A “reportToExcelAndWord.xlsm” excel Workbook performs the final extractions to produce the final excel outputs, and the word report. This workbook contains several macros that automate the different worksheet buttons. The following operations are possible:

• “extractXL” Worksheet extracts results from “xl_*” tables in SQLite database and exports them to separate worksheets in a new excel workbook. The worksheets referes to two “data” worksheets:
  • “extractXL_a” Worksheet defines the SQLite extraction parameters and conversion operations for each type of SQLite/excel table.
  • “extractXL_b” defines the list of load cases for which the extraction is done.

  Data for the extraction for one selection of load cases are provided in cells C3 to C5, and the extraction is triggered by “Extract for one load case” button. The “extract for all selected load cases” button performs the extraction for several load cases using the information found on lines 11 and following.

  User can copy the “extractXL” and associated Worksheets and modify the data to perform several extractions in the same Workbook.

• “extractSR2XL” Worksheet extracts results from “xl_from_sr” SQLite table and saves them in different Workbooks. The data are read from cells C2 to C7, and from lines 11 and following (colmuns B, C and D). Cell C5 corresponds to the range address of conversion data in “extractSR2XL_a” Worksheet. Again, “extractSR2XL” Worksheet proposes two buttons to extract a single Workbook or all the Workbooks according to the data in lines 11 and following.

  User can copy the “extractSR2XL” and associated Worksheets and modify the data to perform several extractions in the same Workbook.

• The “WordTable*” Worksheets are used to copy excel tables and insert them in a Microsoft Word report.