ACEDS is thrilled to introduce our latest blogger, Sean O’Shea. Sean posts a litigation support related tip each night at http://www.litigationsupporttipofthenight.com/. 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.
Presenting January 2019:
Searchable online guide to the rules of legal citation, with cross references to the Bluebook.
Superfetch is an option in Windows which preloads applications to reduce load times.
Slack, which stands for ‘Searchable Log of All Conversation and Knowledge’, is a widely used collaboration tool.
HeinOnline has PDFs of law journal articles dating back to the 19th century.
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.
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.
You can use slicers on Pivot tables to apply timelines on pivot tables which include a date field.
The tskill Windows command will close all instances of an open program.
The Supreme Court of Wisconsin ruled that AI can be used for criminal sentencing.
Sentieo allows you to pull tables from multiple SEC filings and compare them side by side.
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’.
Ron de Bruin’s free add-in for Excel lets you merge multiple workbooks.
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.
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.
A quick tutorial on how to access data from Excel workbooks using Python 2.7
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.
Demo of a Python script to add returns between multiple strings that are separated with unequal blank spaces.
The Python split function will generate a comma delimited set.
Attorneys of the Gilded Age used cipher codes in telegrams.
You can use six different trendlines for Excel charts: linear; exponential; logarithmic; power; polynomial; and moving average.
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.
Forecast future trends with an Excel pivot chart.
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.
Script that can be used with PDF Combine to add slip sheets to a set of exhibits.
Extract the same page range from multiple PDFs using a Java script
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.
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.”
This problem may come up when you have text enclosed in double quotes.