Transform Monthly Data

Description

HOB Tools uses a format for monthly data where every row contains a monthly value (i.e., Year / Month / Data). Monthly data obtained elsewhere may be formatted where every row contains a year’s worth of monthly values (i.e., Year / Jan / … / Dec, where ... is February through November). This tool transforms this alternate format into the format used by HOB Tools.

Input

Input File
Select the input file by clicking on "Browse" and navigating to the proper file.

Input Data Format
Year / Jan / Feb / Mar / Apr / May / Jun / Jul / Aug / Sep / Oct / Nov / Dec

Each "/" is a tab (i.e., data should be tab-delimited).

Start Row
This input is the row number where the main data to be processed begin in the dataset. An example of how row numbers are entered is shown in Figure 2 located in the Running HOB Tools topic.

Output

Output File
Select the file and location where the new data will be stored.

Output File Header
Information entered here will be output in the first line of the output file.