This is to import a bmk file from KeyframeMp to Premiere as EDL

1. Save BMK
2. Edit it in Notepad, leave only frames and remove comma, adding paragraph between frames
3. Import csv into google sheets
4. Load sheets formula for extracting frame ranges and frame to timecode convert
5. Convert timecode to EDL readable format (with blanks and spaces as the format requires)
6. Download as csv
7. Convert to .edl and remove “Commas”
8. Load it into Premiere
9. Relink Source.

This Excel formula grabs a timecode value from cell A1 and converts it into frames. The timecode should be in the format “01:01:01;01”. The formula uses 30 frames per second and does not calculate drop frames.

=VALUE(LEFT(A1,2))*60*60*30+VALUE(MID(A1,4,2))*60*30+VALUE(MID(A1,7,2))*30+RIGHT(A1,2)

Example:
A1: 01:06:46;11
RESULT: 120191

This Excel formula grabs a number value from cell A2 and converts it into timecode.

=TEXT(MOD(INT(INT(INT(ABS(A2)/30)/60)/60),60),"00")&":"&TEXT(MOD(INT(INT(ABS(A2)/30)/60),60),"00")&":"&TEXT(MOD(INT(ABS(A2)/30),60),"00")&";"&TEXT(MOD(ABS(A2),30),"00")

Example:
A2: 112019
RESULT: 01:02:13;29

You may want to replace “30” in that formula for a more accurate Frames Per Second value (e.g., 29.97 for NTSC, 25 for PAL).

This Excel formula calculates the difference between two timecode values and outputs “GOOD” if they are within 3 frames of each other. Otherwise, it outputs the actual difference as a timecode.

=IF((A4-A3)=MEDIAN((A4-A3),-3,3),"GOOD",TEXT(MOD(INT(INT(INT(ABS(A4-A3)/30)/60)/60),60),"00")&":"&TEXT(MOD(INT(INT(ABS(A4-A3)/30)/60),60),"00")&":"&TEXT(MOD(INT(ABS(A4-A3)/30),60),"00")&";"&TEXT(MOD(ABS(A4-A3),30),"00"))

You may want to replace the value pair (-3,3) by a named cell containing a user determined error allowance. That way the formula will mark errors that fall withing the allowed interval as correct.

Example:
A3: 01:13:35;05
A4: 01:13:35;04
RESULT: GOOD

A3: 01:15:31;13
A4: 01:15:30;12
RESULT: 00:00:01;01

NOTE:
The formula “IF((A4-A3)=MEDIAN((A4-A3),-3,3)” calculates whether the value of A4-A3 falls within the values -3 and 3. If you were trying to determine whether these two values are 1 second apart, you would use -33 and 33 as your boundaries (30 frames equal 1 second).

This Excel formula will convert frames back into TimeCode. It will add 1 second to the final value, because Hulu requests that we give them the frame-accurate value of the middle of the commercial break.

=TEXT(MOD(INT(INT(INT(ABS(C3)/RFPS)/60)/60),60),"00")&":"&TEXT(MOD(INT(INT(ABS(C3)/RFPS)/60),60),"00")&":"&TEXT((MOD(INT(ABS(C3)/RFPS),60)+1),"00")&";"&TEXT(MOD(ABS(C3),RFPS),"00")  

This Excel formula will convert frames back into TimeCode. It will round up the seconds and zero out the frames, because YouTube only works with second-accurate commercial breaks. Since our commercial breaks last one second, we can guarantee we fall within the break by rounding up the seconds.

=TEXT(MOD(INT(INT(INT(ABS(C4)/RFPS)/60)/60),60),"00")&":"&TEXT(MOD(INT(INT(ABS(C4)/RFPS)/60),60),"00")&":"&TEXT((MOD(INT(ABS(C4)/RFPS),60)+1),"00")&";"&"00"

RFPS in the formulas is a named cell containing the real FPS value.

Fuente: https://github.com/cgranier/Excel-Timecode

Cinec exporta a prores desde windows.

Cinec es un software de Cinemartin, desarrollador de herramientas para cine y vídeo, que permite la codificación y conversión de vídeos en una amplia gama de formatos para cine y broadcast.

http://www.cinemartin.com/cinec/

Abrir el Sketch en processing

Ir a SKETCH/IMPORT LIBRARY/ ADD LIBRARY

Buscar e instalar:
OSC
Leap

Para obtener los rangos de cada Shot a partir de los bookmarks de Keyframe MP.

1. Abrir el archivo “.bmk” en cualquier editor de texto
2. Seleccionar todo lo que esté entre la etiqueta: frames=”1,366,624,726,792,830,916,953“
3. Copiarlo y pegarlo en un nuevo texto que vamos a guardar con la terminación “.csv”
4. En notepad++ usar el FIND and REPLACE con los siguientes valores:
   Find What: ,
   Replace with: \r
5. Guardar el “.csv”
6. Importarlo en la Hoja de Excel de Cocoa Breakdown/Ranges con la primer celda de START seleccionada
   
7. La hoja de cálculo hace el resto.

Photogrammetry Pipeline

Photogrammetry is the science of making measurements from photographs. It infers the geometry of a scene from a set of unordered photographies or videos. Photography is the projection of a 3D scene onto a 2D plane, losing depth information. The goal of photogrammetry is to reverse this process.

The dense modeling of the scene is the result yielded by chaining two computer vision-based pipelines:
“Structure-from-Motion” (SfM) and “Multi View Stereo” (MVS).

Learn more about each step of the photogrammetry pipeline:

https://alicevision.github.io/

http://hhoppe.com/#demos

New

Check out this GitHub repository with C++ source code and demos for many of my 1992-1998 SIGGRAPH papers.

See my notes for using math in Microsoft Word, including this cheat sheet.