Spreadsheet: 114386d1310132185-copying-data-from-one-workbook-to-another-example
Sheet: Sheet1

No. | Time | Day Code | Trip Code | Operator | Direction | Destination | Depot Code | Bus No. | Timetable | Days Run
11 | 619 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
10 | 622 |  |  | ss | Outwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
10 | 629 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
11 | 639 |  |  | ss | Outwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
12 | 639 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
11 | 649 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
10 | 659 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
12 | 659 |  |  | ss | Outwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
11 | 709 |  |  | ss | Outwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
12 | 709 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
11 | 719 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
10 | 719 |  |  | ss | Outwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
10 | 729 |  |  | ss | Inwards | xxxx | LT | 123 | xxxxxxxx | MTWHF
Shown above is the csv file opened in excel or in this case for demo purpose openoffice
The columns shown in orange are the columns that are needed tobe imported into a template spreadsheet. The csv is the same format, the only difference
the number of rows which could differ
Ref. | Observation Date | Departure Point | Svs No |  | Direction | Destination | Fleet No. | BusWM | Schedule Time | Actual  Time | Time     +/- | Result
 | 2011-07-05 00:00:00 |  |  |  |  |  |  |  | S | 13:10:00 | - | #N/A
 | 2011-07-05 00:00:00 |  | 11 |  | Outwards | xxxx | abc123 | 123 | 13:09:00 | 13:18:00 | 8.999999999999968 | Late
 | 2011-07-05 00:00:00 |  | 12 |  | Inwards | xxxx | abc123 | 123 | 13:09:00 | 13:16:00 | 6.999999999999975 | Late
 | 2011-07-05 00:00:00 |  | 10 |  | Outwards | xxxx | abc123 | 123 | 13:19:00 | 13:18:00 | -0.9999999999999964 | OK
 | 2011-07-05 00:00:00 |  | 11 |  | Inwards | xxxx | abc123 | 123 | 13:19:00 | 13:30:00 | 10.99999999999996 | Late
 | 2011-07-05 00:00:00 |  | 10 |  | Inwards | xxxx | abc123 | 123 | 13:29:00 | 13:28:00 | -0.9999999999999964 | OK
 | 2011-07-05 00:00:00 |  | 12 |  | Outwards | xxxx | abc123 | 123 | 13:29:00 | 13:32:00 | 2.999999999999989 | OK
 | 2011-07-05 00:00:00 |  | 12 |  | Inwards | xxxx | abc123 | 123 | 13:39:00 | 13:46:00 | 6.999999999999975 | Late
 | 2011-07-05 00:00:00 |  | 11 |  | Outwards | xxxx | abc123 | 123 | 13:39:00 | 13:47:00 | 7.999999999999972 | Late
 | 2011-07-05 00:00:00 |  | 10 |  | Outwards | xxxx | abc123 | 123 | 13:49:00 | 13:50:00 | 0.9999999999999964 | OK
 | 2011-07-05 00:00:00 |  | 11 |  | Inwards | xxxx | abc123 | 123 | 13:49:00 | 13:48:00 | -0.9999999999999964 | OK
 |  |  | Column A from csv file |  | column F from csv file | Column G from Csv File |  | Column I from csv file | Column B from csv file
This sheet shows the template that the data from the csv sheet needs to be imported to, the columns shown orange are where the data has to go.
As the data from column B (csv file) is imported into column J it needs tobe converted to 24 hour time format as shown
The rest of the columns in the template workbook can then be filled in by the user.