Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – January 2019

Justice and Law concept. Legal counsel presents to the client a signed contract with gavel and legal law or legal having team meeting at law firm in background

ACEDS is thrilled to introduce our latest blogger, Sean O’Shea. Sean posts a litigation support related tip each night at Sean’s posts take a deep dive into the technical tools legal professionals use with a healthy crossover into case law. Our readers will be bound to find something that eases their challenges or piques their interest.

-Mary Mack


Presenting January 2019:

1/1/2019 Peter W. Martin’s Legal Citation Guide

Searchable online guide to the rules of legal citation, with cross references to the Bluebook.

1/2/2019: Superfetch

Superfetch is an option in Windows which preloads applications to reduce load times.

1/3/2019: Slack

Slack, which stands for ‘Searchable Log of All Conversation and Knowledge’, is a widely used collaboration tool.

1/4/2019: HeinOnline’s Law Journal Library

HeinOnline has PDFs of law journal articles dating back to the 19th century.

1/5/2019: M.D. Tenn. Rules on Spoliation Motions

EPAC Techs. v. Harpercollins Christian Publ., No. 3:12-cv-00463, 2019 U.S. Dist. LEXIS 1816 (M.D. Tenn. Jan. 4, 2019) – identification of four relevant emails that were not produced did not support a finding of spoliation.

1/6/2019: Pivot Table Slicers

If you have created multiple pivot tables on a worksheet you can use a slicer to apply filters to all of the tables at once.











1/7/2019: Timeline Slicers

You can use slicers on Pivot tables to apply timelines on pivot tables which include a date field.

1/8/2019: tskill

The tskill Windows command will close all instances of an open program.

1/9/2019: Loomis v. Wisconsin

The Supreme Court of Wisconsin ruled that AI can be used for criminal sentencing.

1/10/2019: More on Sentio

Sentieo allows you to pull tables from multiple SEC filings and compare them side by side.

1/11/2019: Commonwealth v. Equifax, Inc., (Mass. Super. Nov. 28, 2018)

Judge Janet L. Sanders rejected Equifax’s Motion to for a Protective Order seeking to prevent note taking or summarizing of data viewed in a virtual data room, and allow the use of two confidentiality categories: ‘Confidential Secure Documents’ and a more restrictive ‘Confidential Secure Data’.

1/12/2019: Excel Add-in To Merge Multiple Workbooks

Ron de Bruin’s free add-in for Excel lets you merge multiple workbooks.















1/13/2019: UK Hospital’s PHI Policy

The information governance policy of the biggest cancer care center in Europe requires that its staff understand their accountability for data breaches and pass an annual data security test.

1/14/2019: S.D. Tex. Awards Sanctions for Failure to Disclose Information About Related Suit

On 1/10/2019, Judge Gray H. Miller, issued a decision, Garcia v. Vasilia, No. H-17-1601, 2019 U.S. Dist. LEXIS 4371(S.D. Tex. Jan. 10, 2019), granting in part the Plaintiffs’ motion for sanctions for failure to disclose information about a related case that was not covered by the parties’ electronic discovery agreement.

1/15/2019: Working with Excel files in Python

A quick tutorial on how to access data from Excel workbooks using Python 2.7

1/16/2019: Supreme Court of Tennessee Adopts Rule 34 Specificity Amendment

The comments to the amended version of Rule 34 note that while it will not be necessary to submit a log of withheld documents, a party must give an adequate enough description of them to facilitate an informed discussion of the reasons for the withholding.

1/17/2019: Using Python to parse data

Demo of a Python script to add returns between multiple strings that are separated with unequal blank spaces.

1/18/2019: Use Python to create a comma delimited set

The Python split function will generate a comma delimited set.

1/19/2019: Gilded Age Electronic Discovery

Attorneys of the Gilded Age used cipher codes in telegrams.

1/20/2019: Excel Chart Trendlines

You can use six different trendlines for Excel charts: linear; exponential; logarithmic; power; polynomial; and moving average.

1/21/2019: Google Fined €50 Million for GDPR Violation

On 1/21/19, the French data regulator, CNIL, fined Google for violating the GDPR.  Consent was ruled not to be valid when information about how data would be used for personalizing advertisements could only be located in several different documents. CNIL also faulted Google for pre-selecting the option to consent to the data collection.

1/22/2019: Forecasting with Trendlines

Forecast future trends with an Excel pivot chart.

1/23/2019: CNIL Guide for Processors

France’s Commission Nationale Informatique & Libertes (CNIL) has published a guide to assist the processors of personal data comply with the General Data Protection Regulation.

1/24/2019: Script to add slip sheets to PDFs of exhibits

Script that can be used with PDF Combine to add slip sheets to a set of exhibits.

1/25/2019: Action to Extract Pages from Multiple PDFs

Extract the same page range from multiple PDFs using a Java script

1/26/2019: Third Circuit Rules File Conversion Costs Covered by 28 U.S.C. § 1920 After Voluntary Dismissal

A decision finding that costs for converting native files to TIFF images could be taxed under 28 U.S.C. § 1920 even against plaintiffs that voluntarily dismissed to appeal class de-certification.

1/27/2019: C.D. Cal. Grants Motion in Limine to Exclude Evidence of Sanctions for Spoliation

The Court granted a motion in limine to exclude evidence of sanctions because it, “would be improper to provide an additional remedy, in addition to the sanction awarded by the Magistrate Judge.”

1/28/2019: Fix half deleted characters in Excel

This problem may come up when you have text enclosed in double quotes.

Sean O'Shea on Email
Sean O'Shea
Litigation Paralegal
Sean O’Shea began working as a litigation support analyst at Brobeck, Phleger & Harrison LLP in 1998, near the dawn of the electronic discovery era. From assisting clients with the implementation of information governance policies, to conducting electronic presentations for attorneys at trials, he has been involved in all aspects of litigation support work. Sean is a Relativity Certified Administrator and an ACEDS Certified E-Discovery Specialist. He’s currently employed as a litigation paralegal in New York City, and continues to advise attorneys on legal technology. Look for a new tip on each night on

*The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer. All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. This policy is subject to change at any time. The owner is not an attorney, and nothing posted on this site should be construed as legal advice. Litigation Support Tip of the Night does not provide confirmation that any e-discovery technique or conduct is compliant with legal, regulatory, contractual or ethical requirements.