Ryokiteki na Kanojo [Japanese Subs] (Ep 04-05) timing needed

I attach two text files containing the dialogue from episode 4 and 5 but without timings. So if anyone feels like taking the timings from the English or Chinese SRTs please feel free to do so. I have found using Microsoft excel spreadsheet useful to line up two languages and copying the timings from one to the other. Then once this is done the Ryokiteki na Kanojo [Japanese Subs] becomes complete as a set together with the other two posts here. I would not have time to do this timing till at least Xmas 08.

So if anyone has ahlf a day to one day free then have a go and attach your efforts here to complete the set. As timings already exist , using an Excel spreadsheet methods should take about half or day or even less if you are familiar. For example using excel in different columns line up the Chinese (can be English) to the Japanese like the following, once all the two languages are lined up then use excel formulae to copy in the timing (e.g. to set a flag to test if the cell has any one of the digits 1,2,or 9 use this function: =OR(left(A5,1)="0",left(A5,1)="1",left(A5,1)="2",left(A5,1)="3",left(A5,1)="4",left(A5,1)="5",left(A5,1)="6",left(A5,1)="7",left(A5,1)="8",left(A5,1)="9") , the beauty of this function is then you can copy in all the subtitle sequence numbers in less than 30 secs effort!; The sequence number is the first line number of every dialogue and counts up all the dialogues in an srt file. I would use the excel string function and if then else function to copy in the timings like 00:00:02,302)

1
00:00:02,302 --> 00:00:03,136
藍色的薔薇（三朗）青いバラ

2
00:00:04,204 --> 00:00:06,006
野野村俊介先生---------------------------（五月）野々村俊介さん

3
00:00:06,540 --> 00:00:09,142
是凜子深愛的人--------------------------- 凛子ちゃんが大好きだった人

4
00:00:09,610 --> 00:00:11,378
等一下我要上船---------------------------待ってください乗ります

5
00:00:12,212 --> 00:00:14,481
或許是和他的緣分太淺吧---------------------------（南）彼とは巡り合わせが悪いっていうか…

Posted: Sat Jul 04, 2009 12:22 am Post subject: Post Rating: 0

i did the timing for the episodes 4 and 5