Tag Archives: eDiscovery analytics

Open and Analyze a Production Metadata File (dat file) in Excel

Posted on September 26, 2016 by excelesquire

Does this scenario sound familiar?  Your adversary drops a production on you in the form of a large zip file, and you need to know what’s in that production NOW. For example, you might have a motion to compel hearing later that day–are these … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Practice Management | Tagged , , , | 1 Comment

Find Inconsistent Document Tags with Excel

Posted on September 8, 2015 by excelesquire

Scenario:  You’re doing QC on a batch of reviewed documents that needs to be released for production.  One thing you need to check for is whether family members (i.e., emails and their attachments) have been coded consistently.  If an email is tagged … Continue reading →

Posted in CLE, eDiscovery, formulas, Lit Support | Tagged , , , , , , , , , | 1 Comment

Tracking Duplicates with MATCH, INDEX, and COUNTIF

Posted on June 14, 2015 by excelesquire

Today’s post is about a powerful Excel formula for tracking duplicates in a large set of email metadata.  This routine is not for the faint of heart, but if you are managing a document production, supervising a redaction project, or creating … Continue reading →

Posted in eDiscovery, formulas, Lit Support, Privilege Logs | Tagged , , , , , , | 2 Comments