Workbook Structure

 

The generic report workbook consists of multiple worksheets to open and delete new CSV data, to create charts from the CSV data, the CSV data sheets, the charts and also possibly comparison sheets and internal worksheets. The worksheets:  are the main worksheets to manage the CSV data and to create the charts:

 Helps you to open CSV files, to include them into the workbook, to create a description for the data and to delete the CSV sheets if necessary

         Assists you in creating charts on a selected CSV file and to rename the CSV column headers

 Supports the creation of a table for selected data item (column of a CSV file) and to plot it against the instances of another data column

 

The last two worksheets of the workbook are named. Keep off your hands from the Ranges worksheet  because it contains range names which are important for the workbook to function correctly. The meaning of the  worksheet is explained when we discuss how CSV data can be opened.

The generic report workbook may also contain one or multiple CSV data sheets, charts and comparison worksheets. The graphic below shows the worksheet tabs after opening two CSV files. The CSV data sheets always have a green tab color, the internal worksheets a light yellow color and the three main worksheets a blue color.

Tabs01

The picture below shows an example of worksheets after opening 3 CSV files, creating 2 charts Chart_trx1 and Chart_RTD3 which are based on the data of the worksheet from CSVREP02, and after creating to comparison data sheets Data_Serv_4 and Data_DDFServ_6 with related charts. The comparison data sheet are always depicted in red and all charts are with white tabs.

CSV data sheets are always named CSVREP with two appended digits. The first CSV data file has no digits. All charts are preceded with Chart_ and all comparison data sheets with Data_. The tag following the underscore is user defined and for unique identification a number is added at the end. The number always increases.