6/4/2024 – Effective Use of Courtroom Technology: A Judge’s Guide to Pretrial and Trial - The Federal Judicial Center’s Effective Use of Courtroom Technology: A Judge’s Guide to Pretrial and Trial is an old manual prepared...more
August 8, 2023: Detect Whether or Not Text Was Generated by AI -
It’s becoming more and more common to come across text on the internet which appears as though it may have been written by AI. You may question the...more
July 1, 2023: Javascript to Split PDF Into 5 Page Segments and Save & Rename -
You can use javascript code in Adobe Acrobat to extract set ranges of pages from a PDF file and then save and rename each extracted PDF range...more
June 3, 2023 – Hunting External Links -
Tonight I used the below vba code posted here by Domenic to successfully generate a list of each cell in a workbook which contained a link to an outside Excel file.
This code is...more
May 6, 2023 – Finding Abandoned Families in Active Learning Projects -
In an Active Learning project if a reviewer, while in the course of reviewing a family of documents for a prioritized review, is taken off a project,...more
April 7, 2023 – Stopping Excel From Rounding off Long Numbers During Import -
The Tip of the Night for March 24, 2023, warned about Excel’s tendency to cut off numbers with multiple decimal places. Excel will also round...more
March 4, 2023 – Searching for Emojis in Relativity -
A Relativity admin can make it possible to search for emojis in a Relativity workspace. A dtSearch index can be edited to include a special code that will enable the...more
2/4/2023: Regular Expression Search to Get the Line Count in a Text File -
Running the regular expression search:
\S+\s*$
. . . in a text editor like NotePad++ will generate a count of the number of non-empty lines in...more
January 1, 2023—Searching Inside an Excel Cell for One of Multiple Strings -
You can use an Excel formula to check to see when any one of multiple values appears in the contents of a...more
December 4, 2022 – S.D. Cal.: Request for Production from Backup Tapes Denied -
In 2015, Magistrate Judge William V. Gallo, in United States ex rel. Carter v. Bridgepoint Educ., Inc., 305 F.R.D. 225 (S.D. Cal. 2015), ruled...more
10/8/2022: Printer Settings on Local Computer Carry Over to VMWare -
When you send a job to a printer not on your office network from inside VMWare or another VPN, you may not see all of the options which should be...more
9/3/2022 – LINE CONDITIONERS -
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...more
August 6, 2022 – Powershell Script to Get the File Size of Files in Multiple Locations -
You can run a simple PowerShell script to get the file size of files saved in various locations on a network....more
7/1/2022: Fixing Excel Links Repointed to C drive -
If you find that Excel spreadsheets for which you have added hyperlinks to a network drive using the HYPERLINK formula are inexplicably repointed to the users appdata...more
June 4, 2022 – Getting a HP duplexer to work after you’ve installed it.
Note that on HP printers, even after you have manually installed a duplexer into the rear of a model such as those for the HP 600 series, it will not...more
May 7, 2022 – Excel array formula to check when all columns match, but ignore blanks -
Tonight’s tip of the night explains how you can use an array formula in Excel to confirm that values on a single row for multiple...more
APRIL 2, 2022: Checking for overlapping deposition designations -
If you have a list of page and line deposition designations and want to see not only where they match marked page and lines from a previous set, but also...more
MARCH 5, 2022: Finding which PDFs are not text searchable -
If you have a very large set of PDFs, and you’re uncertain about which files have searchable text, you can set up an Adobe action utilizing the Preflight tool to...more
2/5/2022: Spreadsheet to Track Time Used for Each Party and for Each Examination -
The Tip of the Night for September 4, 2021 discussed how to use the SUMIF formula in Excel to set up a spreadsheet to track the time each...more
Speeding up Chrome – January 8, 2022 -
There are some simple steps you can take to make sure that your Google Chrome browser is operating at optimum speed so you can run jobs in Relativity and other web based applications...more
12/1/2021: Number of Examples to Use for Categorization -
Relativity suggests that a minimum of 5 to 20 documents be used for any one category, and that as many as 15,000 documents can be effectively used as examples for...more
11/1/2021: Hot key for absolute reference -
In Excel, if you want to automatically convert a cell reference to an absolute reference (a fixed reference that will remain the same when it’s pulled down or across to other...more
10/1/2021: Get rid of XE codes -
You can also run a simple find and replace search to remove all of the XE codes added to Word document. Searching for:
^19 XE
. . . and replacing it with nothing, will erase any XE codes...more
9/1/2021: The Quantum Computing Threat to VPNs -
The National Institute of Standards and Technology (NIST) has initiated a program to develop encryption strong to provide protection for when quantum computers are widely...more
8/1/2021: Translate any object -
One of the neat things the Google Translate app does is to superimpose a translation into English over writing shown on some object you point your camera on.
8/2/2021: Regex to find dupes...more