Streamlining hardcoded subtitle extraction

I am trying to create a time table in excel, make a screenshot of every second of the video, detect the characters from that screenshot, create a srt file from that excel sheet in the time table and extract the hard coded subtitles, any ideas for efficiency