Hi
user
Admin Login:
Username:
Password:
Name:
Python & Spreadsheets: Earth Dog Edition
--client
pyconau
--show
pyconau_2018
--room c36 14296 --force
Next: 12 Creepy, frivolous and beautiful art made with machines (CW)
show more...
Marks
Author(s):
Kojo Idrissa
Location
C3.6
Date
aug Sat 25
Days Raw Files
Start
11:50
First Raw Start
11:16
Duration
0:30:0
Offset
0:34:00
End
12:20
Last Raw End
12:46
Chapters
00:00
0:26:26
Total cuts_time
33 min.
https://2018.pycon-au.org/talks/45310-python-spreadsheets-earth-dog-edition/
raw-playlist
raw-mp4-playlist
encoded-files-playlist
host
tweet
mp4
svg
png
assets
release.pdf
Python_Spreadsheets_Earth_Dog_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
Spreadsheets files are great for sharing data. Spreadsheet applications can be a nightmare. In this updated talk, you'll see how OpenPyXL let's you work with those files in a way that's better than using the app OR a .csv. I'll also discuss common problems in working with spreadsheets via code.
Comment:
production notes
2018-08-25/11_16_00.ts
Apply:
11:16:00 - 11:41:04 ( 00:25:04 )
S:
11:16:00 -
E:
11:45:59
D:
00:29:59
(
End:
1504.0)
show more...
vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c36/2018-08-25/11_16_00.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
11:16:00
seconds: 0.0
Wall: 11:16:00
Duration
00:29:59
11:45:59
seconds: 1504.0
Wall: 11:41:04
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-08-25/11_16_00.ts
Apply:
11:41:04 - 11:45:59 ( 00:04:55 )
S:
11:16:00 -
E:
11:45:59
D:
00:29:59
(
Start:
1504.0)
show more...
vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c36/2018-08-25/11_16_00.ts :start-time=01504.0 --audio-desync=0
Raw File
Cut List
11:16:00
seconds: 1504.0
Wall: 11:41:04
Duration
00:29:59
11:45:59
seconds: 0.0
Wall: 11:16:00
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-08-25/11_46_00.ts
Apply:
11:46:00 - 11:49:34 ( 00:03:34 )
S:
11:46:00 -
E:
12:16:00
D:
00:30:00
(
End:
214.0)
show more...
vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c36/2018-08-25/11_46_00.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
11:46:00
seconds: 0.0
Wall: 11:46:00
Duration
00:30:00
12:16:00
seconds: 214.0
Wall: 11:49:34
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-08-25/11_46_00.ts
Apply:
11:49:34 - 12:16:00 ( 00:26:26 )
S:
11:46:00 -
E:
12:16:00
D:
00:30:00
(
Start:
214.0)
show more...
vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c36/2018-08-25/11_46_00.ts :start-time=0214.0 --audio-desync=0
Raw File
Cut List
11:46:00
seconds: 214.0
Wall: 11:49:34
Duration
00:30:00
12:16:00
seconds: 0.0
Wall: 11:46:00
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-08-25/12_16_00.ts
Apply:
12:16:00 - 12:22:46 ( 00:06:46 )
S:
12:16:00 -
E:
12:46:00
D:
00:30:00
(
End:
406.0)
show more...
vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c36/2018-08-25/12_16_00.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
12:16:00
seconds: 0.0
Wall: 12:16:00
Duration
00:30:00
12:46:00
seconds: 406.0
Wall: 12:22:46
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-08-25/12_16_00.ts
Apply:
12:22:46 - 12:46:00 ( 00:23:14 )
S:
12:16:00 -
E:
12:46:00
D:
00:30:00
(
Start:
406.0)
show more...
vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c36/2018-08-25/12_16_00.ts :start-time=0406.0 --audio-desync=0
Raw File
Cut List
12:16:00
seconds: 406.0
Wall: 12:22:46
Duration
00:30:00
12:46:00
seconds: 0.0
Wall: 12:16:00
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
2018-08-25/11_16_00.ts
2018-08-25/11_46_00.ts
2018-08-25/12_16_00.ts
Veyepar
Video Eyeball Processor and Review