July 6, 2024 – Rufus – How to Create Bootable Media with ISO Files If you have a flash drive or disc from which you want to access a program when booting up in BIOS, the data can be saved in an .iso file – which acts as a...more
8/12/2024
/ Cybersecurity ,
Data Collection ,
Data Management ,
Discovery ,
Document Review ,
e-Discovery Professionals ,
Electronically Stored Information ,
Legal Project Management ,
Legal Technology ,
Popular ,
Technology-Assisted Review
February 5, 2024: Destroying Solid State Drives - The Tip of the Night for March 25, 2022, mentioned that the data on solid state drives cannot be degaussed because such drives do not use magnetic fields to store data. A USB...more
January 7, 2024: Creating a Random Series of Numbers in Excel for QC - If you need to generate a list of random numbers in Excel you may want to avoid using the RANDBETWEEN formula....more
October 9, 2023: Projector Types - There are two basic types of projectors – digital light projectors and liquid crystal display projectors. An LCD projector sends light through a prism. A DLP projector works with micro...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