Use of a spreadsheet again

I have to reconsider the previous article, "Use of a spreadsheet".

[For Mac]
ManyTime app's data format is a tab-delimited text,
so you can create ManyTime data using the spreadsheet.
Also you can create it using the usual text editor.

It is simple to create data using the text editor, but it will take effort.
Here, I explain the method to create data using the spreadsheet.
For example, from cell A1, enter the following three events in a spreadsheet.

2015-12-18 17:00:00 2015-12-18 21:30:00 It is rain today.
2015-12-19 20:30:00 2015-12-19 22:30:00 It is also rain today.
2015-12-20 19:30:00 2015-12-20 23:00:00 Rain, but also sunny today.

The event in the line 1 is organized as follow:
Start time 2015-12-18 17:00:00
End time 2015-12-18 21:30:00
Comment It is rain today.

For entering the start time, select A1 cell, and enter '2015-12-18 17:00:00
in the formula bar.
For entering the end time, select B1 cell, and enter '2015-12-18 21:30:00
in the formula bar.
For entering the comment, select C1 cell, and enter "It is rain today."
in the formula bar.

The head character of start time string and end time string in the formula bar
will begin with a single quote.
Also the event in the line 2 is organized as follow:

For entering the start time, select A2 cell, and enter '2015-12-19 20:30:00
in the formula bar.
For entering the end time, select B2 cell, and enter '2015-12-19 22:30:00
in the formula bar.
For entering the comment, select C2 cell, and enter "It is also rain today."
in the formula bar.

Then the event in the line 3 is organized as follow:

For entering the start time, select A3 cell, and enter '2015-12-20 19:30:00
in the formula bar.
For entering the end time, select B3 cell, and enter '2015-12-20 23:00:00
in the formula bar.
For entering the comment, select C3 cell, and enter "Rain, but also sunny today."
in the formula bar.

Save the data named manytime-1.txt from the spreadsheet.
In this case, as the type of file, save by selecting the tab-delimited text.
If you are forced to save in csv extension, correct the file name to txt extension
after saving.

The file manytime-1.txt after editing looks like the following.
This data is for the course 1 of ManyTime app.
You can copy the contents to the existing manytime-1.txt file under
the Dropbox>Apps>manytime folder, or replace the the existing file.
If the existing manytime-1.txt is absent,place it in manytime folder.
Select the course 1 in ManyTime app and press the sync button in ManyTime app,
the data will be downloaded from Dropbox.

2015-12-18 17:00:00 2015-12-18 21:30:00 It is rain today.
2015-12-19 20:30:00 2015-12-19 22:30:00 It is also rain today.
2015-12-20 19:30:00 2015-12-20 23:00:00 Rain, but also sunny today.

Between the date and the time is a space.
Between the start date and the end date is a tab.
Between the end date and the comment is also a tab.


[For Windows]
After saving manytime-1.txt from the spreadsheet, read it using the text editor
with the text editor, and save again it with LF in UTF-8 without BOM. Use the
advanced text editor, such as EmEditor.

Note:
If the file name is manytime-2.txt in the manytime folder of Dropbox,
it will be the data for the course 2 in ManyTime app.
If manytime-3.txt, it will be for the course 3.
If manytime-4.txt, it will be for the course 4.