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
7/1/2021: Software to Compress TIFFs with Specific Algorithms -
A free utility will allow you to run a command which will compress TIFF images with either the CCIT Group 4, LZW, Packbits, or JPEG algorithms.
7/2/2021:...more
6/1/2021: Use 7-zip to extract zip files with file paths greater than 255 characters -
While the extraction tool for Windows Explorer will not extract files with paths longer than this limit and will prompt you to skip over...more
5/1/2021: Things to Keep In Mind When Notarizing a Will in New York State -
A notarized will will be self-proving. The court will not have to contact the witnesses in order to confirm the validity of the will.
5/2/2021:...more
4/1/2021: Geofence Warrants -
The government may request that a court issue a ‘geofence warrant’. This is a warrant which gives law enforcement authorities the right to obtain data from any cell phones which were in the...more
3/1/2021: Excel DSUM formula -
Excel’s DSUM formula is a useful alternative to VLOOKUP. It will read the column headings of an array of data, and return the sum based on criteria entered in a separate set of...more
2/1/2021: Editing ppsx -
In Windows 10, if you want to edit a PowerPoint .ppsx file, you can select it in Windows Explorer and click on ‘New’ instead of ‘Show’.
2/2/2021: Relativity Analytics for Small Data Sets -...more
1/1/2021: Checking FASP Connection for RelativityOneIn order to see if a network is configured to transmit data to a fully qualified domain name via the FASP port run this PowerShell script: Test-NetConnection -ComputerName...more
12/1/2020: Compare Excel spreadsheets for differences -
Macro to see if two worksheets in the same Excel file have any text that differs.
12/2/2020: Tracking the Origin of an Email -
You can use Google Toolbox’s...more
11/1/2020: National Practitioner Data Bank -
The Department of Health and Human Services maintains the National Practitioner Data Bank (NPDB), a database which records restrictions placed on physicians’ privileges to...more
12/3/2020
/ Data Collection ,
Data Management ,
Discovery ,
e-Discovery Professionals ,
Electronically Stored Information ,
Evidence ,
Law Firm Associates ,
Law Firm Partners ,
Legal Project Management ,
Litigation Strategies ,
Paralegal
9/1/2020: FedRAMP 3PAOs -
Make sure that your CSP is evaluated by a third party assessment organization approved by FedRAMP.
9/2/2020: Courtroom Technology in the District of Minnesota -
The ELMO should have a ‘freeze’...more
10/1/2020
/ Discovery ,
e-Discovery Professionals ,
Electronically Stored Information ,
Evidence ,
Law Firm Associates ,
Law Firm Partners ,
Legal Project Management ,
Legal Technology ,
Litigation Strategies ,
Paralegal ,
Trial Preparation
8/1/2020: Maryland Court of Appeals on Social Media Authentication -
In Griffin v. State, 419 Md. 343 (2011), the Maryland Court of Appeals found social media evidence must be shown to have not been subject to hacking or...more
7/1/2020: Regex to Remove Relativity Numbering on Downloaded PDFs
([0-9]{1}_|[0-9]{2}_|[0-9]{3}_)(.*)
7/2/2020: UPDATE – How to Automate the Insertion of Hyperlinks in MS Word -
This macro can be edited so that the full...more
6/1/2020: When to use – ; – ; or —
A hyphen – to separate words.
An en dash – to separate ranges.
An em dash — in place of a colon, comma, or parentheses....more
5/1/2020: (California Styling) -
The California style is distinguished by enclosing citations in parentheses and putting the venue and year between the case name and reporter cite.
5/2/2020: Predicting the number of top...more
6/1/2020
/ Discovery ,
e-Discovery Professionals ,
Electronically Stored Information ,
Evidence ,
Law Firm Associates ,
Law Firm Partners ,
Legal Project Management ,
Legal Technology ,
Litigation Strategies ,
Paralegal ,
Trial Preparation
4/1/2020: Relativity and JVM RAM -
You can improve the performance of Relativity analytics operations by increasing the amount of RAM available for Java. The Java heap is the amount of memory allocated to the Java...more
3/1/2020: Quarter Inch Cartridges -
Quarter Inch Cartridges can range in size from 20 MB to 40 GB. Mini-QICs, QIC-40s and QIC-80s can be accessed with a standard floppy drive.
3/2/2020: Powershell script to find unique...more
2/1/2020: Illinois Supreme Court: Biometric Information Privacy Act Protects Rights Even If No Injury -
Illinois Supreme Court rules that Biometric Information Privacy Act does not require actual injury when fingerprint...more
1/1/2020: Conceptually Rich Documents for Conceptual Indices in Relativity Analytics -
When setting up a training set to be used for the creation of a conceptual index in Relativity, be sure to exclude computer generated...more