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.
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.