npjg

' For a given Excel table row, returns the cell in that row corresponding to a given column name.
Function GetCellInTableRowByColumnName(ByRef tableRow As ListRow, columnName As String) As Range
    ' Since the parent of ListRow is a ListObject (the table that holds the row), we can just use
    ' the Parent attribute rather than also requiring the ListObject be passed into this method.
    Dim columnIndex As Integer
    On Error Resume Next
    columnIndex = tableRow.Parent.ListColumns(columnName).Index
    If Err <> 0 Then
        Set GetCellInTableRowByColumnName = Nothing
    Else

npjg

' For a given Excel table, returns the column with the given name.
Private Function GetTableColumnByName(ByRef table As ListObject, columnName As String) As ListColumn
    Dim columnIndex As Integer
    On Error Resume Next
    columnIndex = table.ListColumns(columnName).index
    If Err <> 0 Then
        Set GetTableColumnByName = Nothing
    Else
        Set GetTableColumnByName = table.ListColumns(columnIndex)
    End If

npjg

\documentclass[12pt]{article}

%\usepackage[width=5truein,height=7truein,letter,center,frame]{crop}
\usepackage[paperheight=7in, paperwidth=5in, top=1.75cm, left=0cm, right=0cm, bottom=0cm]{geometry}

\usepackage[T1]{fontenc}
\usepackage{fontspec}

\usepackage{calligra}
\usepackage{setspace}

npjg

#!/bin/zsh

# https://video.stackexchange.com/questions/19867/how-to-fade-in-out-a-video-audio-clip-with-unknown-duration
# https://superuser.com/questions/1041816/combine-one-image-one-audio-file-to-make-one-video-using-ffmpeg
# https://superuser.com/questions/833232/create-video-with-5-images-with-fadein-out-effect-in-ffmpeg/834035#834035
# https://askubuntu.com/questions/1128754/how-do-i-add-a-1-second-fade-out-effect-to-the-end-of-a-video-with-ffmpeg

# $1: Input image file
# $2: Input video/audio file
# $3: Fade-in duration in seconds (audio and video fade)

npjg

#!/bin/zsh
NATS_HD=$(pwd)
for folder in $1
do
		output=~/tapes/$folder
		mkdir -p $output
		cd $folder/Media
		for f in *.dv; do ffmpeg -i $f -vf yadif $output/$f.mp4 -loglevel panic -stats; done
		cd $NATS_HD
done

npjg

ROOT=/home/npgentry/inodes
while read p; do
		outf=$ROOT/$p
		mkdir -p $outf
		sudo ntfsundelete --undelete /dev/sdc1 --inodes $p --destination $outf
done <inodes.txt

npjg

\documentclass{standalone}
\usepackage{xcolor}

\begin{document}
%\color{white}
{\fontsize{500}{500}\selectfont \LaTeX{}}
\end{document}

npjg

#!/usr/bin/python3

import argparse
import logging

from PyPDF2 import PdfFileReader

import tika
tika.initVM()
from tika import parser

npjg

\documentclass[10pt]{article}

\usepackage[top=0.75in,bottom=1in,left=0.5in,right=0.5in,landscape]{geometry}
\usepackage[T1]{fontenc}
\usepackage[english]{babel}

\setlength{\parindent}{0pt}
\setlength{\parskip}{0pt}
\usepackage{multicol}
\usepackage{xifthen}

npjg

title	author	date
Google Summer of Code 2020 Final Evaluation	Nathanael Gentry	24 August 2020

Summary

My weekly progress on the Director engine is archived on my ScummVM blog. Here are eight highlights from my time at GSoC: