Hi
user
Admin Login:
Username:
Password:
Name:
Python and Spreadsheets: 2017 Edition
--client
pyohio
--show
pyohio_2017
--room cartoon2 12375 --force
Next: 11 U is for Unicode: Solving the Mystery
show more...
Marks
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:
---------
borked
edit
encode
push to queue
post
richard
review 1
email
review 2
make public
tweet
to-miror
conf
done
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
Unknown
Yes
No
Normalise:
Channelcopy:
m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:
filename.png
Description:
markdown
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.
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
2017-07-29/14_27_20.ts
2017-07-29/14_57_20.ts
2017-07-29/15_27_20.ts
Veyepar
Video Eyeball Processor and Review