Just beginning a two month long trial so I only have time for a few quick tips:

  • your Apple watch can still receive a phone call when your iPhone is shut down. Take it off wifi to prevent it from making a minir disturbance.

  • stamping exhibits with page level numbering may remove bookmarks.

  • OnCue appears to be the electronic presentation software most favored by trial techs these days because of its superior video clip editing tools.

36 views0 comments

Most people will have a used a power strip with a surge protector at some point - this will shut off an electrical current when the power becomes too high.

If you are setting up audio-visual equipment in a courtroom or other building with an older electrical system it may be wise to also use a line (or power) conditioner which will control the voltage which hardware receives. More modern electrical systems will have line conditioners built-in, but many older facilities will lack them.

Low voltage dips will put stress on electrical devices and cause them to fail. A line conditioner will keep the voltage with a safe range.

A typical line conditioner will look like this model:

The power cords from multiple laptops, printers, and other devices can be plugged into the line conditioner, and the line conditioner's power cord will be plugged to a wall outlet.

The line conditioner should have warning lights which indicate when the power is too high or too low.

30 views0 comments

Extend Office has Visual Basic code posted here, which can be used to run one macro on multiple workbooks. The below variation of this code will process multiple Excel spreadsheets saved in a single folder, and prepare them to be printed. The vba code will set the workbooks so that:

- all columns fit on a single page

- landscape orientation is set

- the first row repeats at the top of each page

- the name of the Excel file appears in the footer

Insert the code in a module of a blank workbook. When it's run it will prompt you to select a folder with the files to process.

The macro will open each file and set the specified formatting settings.

The files will not be saved automatically, but you can do this by holding down the SHIFT key and clicking the X to close Excel. You will be prompted to save all of the files.

Sub LoopThroughFiles()

Dim xFd As FileDialog

Dim xFdItem As Variant

Dim xFileName As String

Set xFd = Application.FileDialog(msoFileDialogFolderPicker)

If xFd.Show = -1 Then

xFdItem = xFd.SelectedItems(1) & Application.PathSeparator

xFileName = Dir(xFdItem & "*.xls*")

Do While xFileName <> ""

With Workbooks.Open(xFdItem & xFileName)

'your code here

Dim ws As Worksheet

Application.PrintCommunication = False

For Each ws In ActiveWorkbook.Worksheets

With ws.PageSetup

.Zoom = False

.PrintTitleRows = "$1:$2"

.FitToPagesWide = 1

.FitToPagesTall = 1000

.Orientation = xlLandscape

.CenterFooter = "&F"

End With

Next ws

End With

xFileName = Dir


End If

End Sub

32 views0 comments