veyepar: Python and Spreadsheets: 2017 Edition

Author(s):	Kojo Idrissa
Location	Cartoon 2
Date	jul Sat 29	Days Raw Files
Start	16:00	First Raw Start	14:27
Duration	00:50:00	Offset	1:32:40
End	16:50	Last Raw End	15:57
Chapters	00:00 0:26:42 0:49:30
Total cuts_time	52 min.

http://pyohio.org/schedule/presentation/296/
raw-playlist raw-mp4-playlist encoded-files-playlist host archive tweet mp4 svg png

assets release.pdf Python_and_Spreadsheets_2017_Edition.json
logs
Admin: episode episode list cut list raw files day marks day marks day image_files

State:
Locked:	clear this to unlock
Locked by:	user/process that locked.
Start:	initially scheduled time from master, adjusted to match reality
Duration:	length in hh:mm:ss
Name:	Video Title (shows in video search results)
Emails:	email(s) of the presenter(s)
Released:	has someone authorised pubication
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	Spreadsheet files are often used to share interesting & important data. But spreadsheet applications aren't always the best tool for processing that data. I'll show you how to use OpenPyXL to work with that data in a way that's better than using .csv files. I'll also discuss common problems faced when working with spreadsheets via code. "State of the art" moves fast here, thus the title. markdown
Comment:	production notes

2017-07-29/14_27_20.ts Apply: 14:27:20 - 14:50:19 ( 00:22:59 ) S: 14:27:20 - E: 14:57:20 D: 00:30:00 (End: 1379.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/14_27_20.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:27:20		seconds: 0.0 Wall: 14:27:20
Duration	00:30:00
	14:57:20		seconds: 1379.0 Wall: 14:50:19
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_27_20.ts Apply: 14:50:19 - 14:57:20 ( 00:07:01 ) S: 14:27:20 - E: 14:57:20 D: 00:30:00 (Start: 1379.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/14_27_20.ts :start-time=01379.0 --audio-desync=0

	Raw File	Cut List
	14:27:20		seconds: 1379.0 Wall: 14:50:19
Duration	00:30:00
	14:57:20		seconds: 0.0 Wall: 14:27:20
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_57_20.ts Apply: 14:57:20 - 15:00:15 ( 00:02:55 ) S: 14:57:20 - E: 15:27:20 D: 00:30:00 (End: 175.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/14_57_20.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:57:20		seconds: 0.0 Wall: 14:57:20
Duration	00:30:00
	15:27:20		seconds: 175.0 Wall: 15:00:15
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_57_20.ts Apply: 15:00:15 - 15:00:38 ( 00:00:23 ) S: 14:57:20 - E: 15:27:20 D: 00:30:00 (Start: 175.0) (End: 198.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/14_57_20.ts :start-time=0175.0 --audio-desync=0

	Raw File	Cut List
	14:57:20		seconds: 175.0 Wall: 15:00:15
Duration	00:30:00
	15:27:20		seconds: 198.0 Wall: 15:00:38
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_57_20.ts Apply: 15:00:38 - 15:27:20 ( 00:26:42 ) S: 14:57:20 - E: 15:27:20 D: 00:30:00 (Start: 198.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/14_57_20.ts :start-time=0198.0 --audio-desync=0

	Raw File	Cut List
	14:57:20		seconds: 198.0 Wall: 15:00:38
Duration	00:30:00
	15:27:20		seconds: 0.0 Wall: 14:57:20
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/15_27_20.ts Apply: 15:27:20 - 15:50:08 ( 00:22:48 ) S: 15:27:20 - E: 15:57:19 D: 00:29:59 (End: 1368.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/15_27_20.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:27:20		seconds: 0.0 Wall: 15:27:20
Duration	00:29:59
	15:57:19		seconds: 1368.0 Wall: 15:50:08
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/15_27_20.ts Apply: 15:50:08 - 15:53:25 ( 00:03:17 ) S: 15:27:20 - E: 15:57:19 D: 00:29:59 (Start: 1368.0) (End: 1565.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/15_27_20.ts :start-time=01368.0 --audio-desync=0

	Raw File	Cut List
	15:27:20		seconds: 1368.0 Wall: 15:50:08
Duration	00:29:59
	15:57:19		seconds: 1565.0 Wall: 15:53:25
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/15_27_20.ts Apply: 15:53:25 - 15:57:19 ( 00:03:54 ) S: 15:27:20 - E: 15:57:19 D: 00:29:59 (Start: 1565.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/cartoon2/2017-07-29/15_27_20.ts :start-time=01565.0 --audio-desync=0

	Raw File	Cut List
	15:27:20		seconds: 1565.0 Wall: 15:53:25
Duration	00:29:59
	15:57:19		seconds: 0.0 Wall: 15:27:20
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

Rf filename:	root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:	check and save to add this