AI Case Brief
Generate an AI-powered case brief with:
Estimated cost: $0.001 - $0.003 per brief
Full Opinion
MEMORANDUM AND ORDER
Plaintiff Shirley Williams filed this suit on behalf of herself and others similarly situated, asserting that her age was a determining factor in Defendantâs decision to terminate her employment during a reduction-in-force (RIF). Currently, 1727 plaintiffs remain in the case out of the 2354 plaintiffs who opted into this provisionally certified collective action pursuant to 29 U.S.C. § 216(b). The .parties are presently engaged in discovery concerning the merits of Plaintiffsâ pattern and practice allegations. This matter is presently before the Court on Defendantâs Response to the Courtâs July 12, 2005 Order (doc. 3037), which ordered Defendant to show cause why it should not produce electronic Microsoft Excel spreadsheets in the manner in which they were maintained and why it should not be sanctioned for âscrubbingâ the metadata and locking certain data on the electronic spreadsheets prior to producing them to Plaintiffs without either the agree
I. Background Information
Plaintiff Williams commenced this action in April 2003, and, to date, the docket reflects that over 3300 pleadings and orders have been filed. The case is assigned to Chief Judge John W. Lungstrum but is referred to the undersigned Magistrate Judge for pretrial proceedings, including discovery. Due to the highly contentious nature of this litigation, the Magistrate Judge has conducted discovery conferences twice a month since March 2005 to resolve discovery issues identified by the parties. One of the ongoing discovery disputes has been Defendantâs production of spreadsheets that relate to the RIFs at issue in this case.
Plaintiffs raised the issue of the RIF-related spreadsheets at the May 5, 2005 discovery conference. Item 1 on Plaintiffsâ List of Issues for the May 5, 2005 discovery conference was âDefendantâs Failure to Produce Candidate Selection Spreadsheets and Other Basic RIF Documents.â
Two weeks later, at the May 19, 2005 discovery conference, Plaintiffs requested that Defendant be required to produce the actual electronic âactive fileâ version of all the Excel RIF spreadsheets. Plaintiffsâ stated reason for requesting that the spreadsheets be produced in their electronic form was so Plaintiffs could perform âstatistical or manipulative things without taking the spreadsheets and going through the laborious process of keying in all that data
[Generally, when things are maintained in the regular course of business in electronic form, they should be produced in that form, unless thereâs an agreement otherwise. And it sounds like what youâre telling me, there was an agreement otherwise, until May 11, and then it was pointed out you want them in the form they were maintained.9
The Court then asked Defendant why it could not produce the spreadsheets in their electronic form. Defendant responded by suggesting that it should be allowed to finish its review of the documents to be produced in TIFF image and then go back at a later time and review what it holds in electronic format. The Court commented on Defendantâs reference to reviewing documents by stating that âon the information thatâs in electronic form, the only review [Defendant has] to do is the privilege review.â
What Iâm talking about is if youâre talking about documents maintained on Excel, youâve got that in some form, whether itâs on disk or paper, whatever itâs on. Itâs an electronic form of Excel containing the data. The only thing you would have to do is review it for privilege and then give it to them.11
At the June 2, 2005 discovery conference, Plaintiffs again raised the issue of Defendant producing the RIF spreadsheets in then-electronic Excel form. Plaintiffs explained why they needed the electronic version of the spreadsheets in the following exchange:
PLAINTIFFSâ COUNSEL: There are, on each of these documents, things that show you why you have to have an electronic copy. These are spreadsheets. There are columns not there, that should be there. There are columns where the entry will have a sentence, and it cuts off in midsen-tence because the box ends. And we all know, on the computer, we click on that and we get everything.12
* ĂjĂ *
The electronic form of this document would reveal whether or not it had any actual other columns or types of information available on a spreadsheet.13
THE COURT: Okay. Before we get much further here, I thought it was clear from the last time we discussed this electronic issue, that you [Defendant] were looking for them and you were going to produce them. Itâs not an issue that youâre not going to do it. Itâs a question of when.14
DEFENDANTâS COUNSEL: Absolutely. And the only caveat is the one that I mentioned to you, is that there may be the issue of Social Security numbers. And if there are privileged communications, which are these analyses that were prepared, if they are on those documents, weâll redact those and point out that they have been redacted, but still give them the*644 electronic version of it, with the notation that thatâs missing.15
At the June 9, 2005 discovery conference, Plaintiffs again raised the issue of Defendant producing the RIF spreadsheets in their electronic Excel format. The Court renewed its show cause order, stating, âfor today on this issue weâll leave the show cause that youâre going to do the electronic spreadsheets by [June] 24th.â
On June 23, 2005, Defendant tendered to Plaintiffsâ counsel 3083 Excel spreadsheets in electronic form and indicated that there were 983 additional spreadsheets identified that had not been fully processed for production and would be produced no later than June 27, 2005.
At the July 7, 2005 discovery conference, Plaintiffsâ counsel advised the Court that Defendant, prior to producing the electronic versions of the Excel spreadsheets, had utilized software to scrub the spreadsheet files to remove the metadata. Plaintiffs claim this metadata would have contained information such as file names, dates of the file, authors of the file, recipients of the file, print-out dates, changes and modification dates, and other information. Plaintiffsâ counsel stated that Defendant did not provide them with any type of log of what information was scrubbed. Plaintiffsâ counsel also advised the Court that Defendant had locked certain cells and data on the Excel spreadsheets prior to producing them so that Plaintiffs could not access those cells.
Defendant admitted that it had scrubbed the metadata from and locked certain data on the spreadsheets prior to producing them. It argued that the spreadsheetsâ metadata is irrelevant and contains privileged information. Defendant further argued that Plaintiffs never requested the metadata be included in the electronic Excel spreadsheets it produced and that metadata was never discussed at any of the discovery conferences.
After hearing the respective arguments of counsel, the Court ordered Defendant to show cause why it should not be sanctioned for not complying with âwhat at least I understood my Order to be, which was that electronic data be produced in the manner in which it was maintained, and to me that did not allow for the scrubbing of metadata because when I talk about electronic data, that includes the metadata.â
The Courtâs corresponding written Order dated July 12, 2005 (doc. 3037), required Defendant to show cause in writing: (1) âwhy it should not produce the electronic spreadsheets in the manner in which they were maintainedâ and (2) âwhy it should not be
II. Discussion
In its response to the Courtâs Show Cause Order, Defendant states that it provided the spreadsheets as requested by Plaintiffs in native Excel format, with the following four modifications, none of which affected the discoverable data regarding the RIFs at issue this lawsuit: (1) Defendant deleted the adverse impact analyses; (2) Defendant deleted the social security numbers of employees referenced in the spreadsheets; (3) Defendant deleted metadata from the electronic files that included the spreadsheets; and (4) Defendant locked the value of the cells in the spreadsheets.
Defendant asserts that these four modifications to the RIF spreadsheets were made in good faith and for legitimate purposes, namely to protect from disclosure information that Judge Lungstrum determined is not discoverable, to ensure the Courtâs rulings could not be circumvented, and to maintain the integrity of the data. Defendant maintains that under these circumstances its actions were appropriate and do not warrant the imposition of sanctions.
A. Adverse Impact Analyses and Social Security Numbers
Although Defendantâs response to the Show Cause Order explains why it redacted or removed adverse impact analyses information and social security numbers from the electronic spreadsheets prior to producing them, the Court finds this explanation is not necessary, as Defendant previously indicated that it intended to redact this information. At the June 2, 2005 discovery conference, Defendant indicated to the Court that it intended to redact social security numbers and privileged communications consisting of the adverse impact analyses that were prepared.
B. Metadata
The Courtâs Show Cause Order, however, does require Defendant to show cause for its actions in scrubbing the metadata from the electronic spreadsheets prior to producing them to Plaintiffs. Defendant claims that it scrubbed the metadata from the spreadsheets to preclude the possibility that Plaintiffs could âundeleteâ or recover privileged and protected information properly deleted from the spreadsheets and to limit the information in the spreadsheets to those pools from which it made the RIF decisions currently being litigated. In an attempt to justify its actions, Defendant contends that emerging standards of electronic discovery articulate a presumption against the produc
1. Emerging standards of electronic discoveiy with regard to metadata
a. What is metadata?
Before addressing whether Defendant was justified in removing the metadata from the Excel spreadsheets prior to producing them to Plaintiffs, a general discussion of metadata and its implications for electronic document production in discovery is instructive.
Metadata, commonly described as âdata about data,â is defined as âinformation describing the history, tracking, or management of an electronic document.â
Most metadata is generally not visible when a document is printed or when the document is converted to an image file.
Appendix E to The Sedona Guidelines further explains the importance of metadata:
Certain metadata is critical in information management and for ensuring effective retrieval and accountability in record-keeping. Metadata can assist in proving the authenticity of the content of electronic documents, as well as establish the context of the content. Metadata can also identify and exploit the structural relationships that exist between and within electronic documents, such as versions and drafts. Metadata allows organizations to track the many layers of rights and reproduction information that exist for records and their multiple versions. Metadata may also document other legal or security requirements that have been imposed on records; for example, privacy concerns, privileged communications or work product, or proprietary interests.34
The Microsoft Office Online website lists several examples of metadata that may be stored in Microsoft Excel spreadsheets, as well as other Microsoft applications such as Word or PowerPoint: author name or initials, company or organization name, identification of computer or network server or hard disk where document is saved, names of previous document authors, document revisions and versions, hidden text or cells, template information, other file properties and summary information, non-visible portions or embedded objects, personalized views, and comments.
It is important to note that metadata varies with different applications. As a general rule of thumb, the more interactive the application, the more important the metadata is to understanding the applicationâs output. At one end of the spectrum is a word processing application where the metadata is usually not critical to understanding the substance of the document. The information can be conveyed without the need for the metadata. At the other end of the spectrum is a database application where the database is a completely undifferentiated mass of tables of data. The metadata is the key to showing the relationships between the data; without such metadata, the tables of data would have little meaning. A spreadsheet application lies somewhere in the middle. While metadata is not as crucial to understanding a spreadsheet as it is to a database application, a spreadsheetâs metadata may be necessary to understand the spreadsheet because the cells containing formulas, which arguably are metadata themselves, often display a value rather than the formula itself. To understand the spreadsheet, the user must be able to ascertain the formula within the cell.
Due to the hidden, or not readily visible, nature of metadata, commentators note that metadata created by any software application has the potential for inadvertent disclosure of confidential or privileged information in both a litigation and non-litigation setting, which could give rise to an ethical violation.
With the increasing usage of electronic document production in discovery, metadata presents unique challenges regarding the production of documents in litigation and raises many new discovery questions. The group of judges and attorneys comprising the Sedona Conference Working Group on Best Practices for Electronic Document Retention and Production (Sedona Electronic Document Working Group) identified metadata as one of the primary ways in which producing electronic documents differs from producing paper documents.
Defendant contends that emerging standards of electronic discovery articulate a presumption against the production of metadata. To determine whether Defendantâs contention is accurate, the Court must first identify the emerging standards for the production of metadata. Then the Court must determine whether these emerging standards provide any guidance on the issue before the Court, i.e., whether a court order directing a party to produce electronic documents as they are maintained in the ordinary course of business requires the producing party to produce those documents with the metadata intact. A related issue is determining which party has the initial burden with regard to the disclosure of metadata. Does the requesting party have the burden to specifically request metadata and demonstrate its relevance? Or does the party ordered to produce electronic documents have an obligation to produce the metadata unless that party timely objects to production of the metadata?
The Court starts with the current version of Federal Rule of Civil Procedure 34. This rule provides that â[a]ny party may serve on any other party a request (1) to produce and permit the party making the request, or someone acting on the requestorâs behalf, to inspect and copy, any designated documents (including writings, drawings, graphs, charts, photographs, phonorecords, and other data compilations from which information can be obtained, translated, if necessary, by the respondent through detection devices into reasonably usable form).â
Federal Rule of Civil Procedure 34 includes âdata compilationsâ in the listing of items that constitute a âdocument.â The 1970 amendment advisory committee note to Rule 34 states that âRule 34 applies to electronics data compilations from which information can be obtained only with the use of detection devices, and that when the data can as a practical matter be made usable by the discovering party only through respondentâs devices, respondent may be required to use his devices to translate the data into usable form.â
In the past year, the Civil Rules Advisory Committee has proposed to the Judicial Conference several amendments to the Federal Rules of Civil Procedure addressing the discovery of electronically stored information.
Unless the parties otherwise agree, or the court otherwise orders,
* * *
(ii) if a request for electronically stored information does not specify the form or forms of production, a responding party must produce the information in a form or forms in which it is ordinarily maintained, or in a form or forms that are reasonably usable.46
The proposed committee note to Rule 34(b) provides the following guidance on the form of production:
The amendment to Rule 34(b) permits the requesting party to designate the form or forms in which it wants electronically stored information produced. The form of production is more important to the exchange of electronically stored information than of hard-copy materials, although a party might specify hard copy as the requested form. Specification of the desired form or forms may facilitate the orderly, efficient, and cost-effective discovery of electronically stored information. The rule recognizes that different forms of production may be appropriate for different types of electronically stored information. Using current technology, for example, a party might be called upon to produce word processing documents, e-mail messages, electronic spreadsheets, different image or sound files, and material from databases. Requiring that such diverse types of electronically stored information all be produced in the same form could prove impossible, and even if possible could increase the cost and burdens of producing and using the information. The rule therefore provides that the requesting party may ask for different forms of production for different types of electronically stored information.47
Although the proposed amendments to Rule 34 use the phrase âin a form or forms in which it is ordinarily maintained,â they provide no further guidance as to whether a partyâs production of electronically stored information âin the form or forms in which it is ordinarily maintainedâ would encompass the electronic documentâs metadata.
In the few cases where discovery of meta-data is mentioned, it is unclear whether me-tadata should ordinarily be produced as a matter of course in an electronic document production. In the case In re Verisign, Inc. Securities Litigation,
In another case, which involved the imposition of sanctions against a corporate defendant who repeatedly engaged in a number of discovery abuses, Magistrate Judge Hemann recommended that default judgment be entered against the defendant as sanctions for its discovery abuses.
Having concluded that neither the federal rules nor case law provides sufficient guid-anee on the production of metadata, the Court next turns to materials issued by the Sedona Conference Working Group on Electronic Document Production. The Court finds two of the Sedona Principles for Electronic Document Production particularly helpful in determining whether Defendant was justified in scrubbing the metadata from the electronic spreadsheets. Principle 9 states that â[ajbsent a showing of special need and relevance a responding party should not be required to preserve, review, or produce deleted, shadowed, fragmented, or residual data or documents.â
Comment 9.a. to the Sedona Principles for Electronic Document Production focuses on the scope of a âdocumentâ under Fed. R.Civ.P. 34. It notes that although Rule 34 was amended in 1970 to add âdata compilationsâ to the list of discoverable documents, there was no suggestion that âdata compilationsâ was intended to turn all forms of âdataâ into a Rule 34 âdocument.â
A party demands that responsive documents, âwhether in hard copy or electronic format,â be produced. The producing party objects to producing the documents in electronic format and states that production will be made through PDF or TIF images on CD-ROMs. The producing party assembles copies of the relevant hard copy memoranda, prints out copies of relevant e-mails and electronic memoranda, and produces them in a PDF or TIF format that does not include metadata. Absent a special request for metadata (or any reasonable basis to conclude the metadata was relevant to the claims and defenses in the litigation), and a prior order of the court based on a showing of need, this production of documents complies with the ordinary meaning of Rule 34.61
Metadata is specifically discussed in depth in Comment 12.a. to the Sedona Principles. The comment states that â[ajlthough there are exceptions to every rule, especially in an evolving area of the law, there should be a modest legal presumption in most cases that the producing party need not take special efforts to preserve or produce metadata.â
The comment lists several ways in which routine preservation and production of meta-data may be beneficial.
c. Application to this case
The narrow issue currently before the Court is whether, under emerging standards of electronic discovery, the Courtâs Order directing Defendant to produce electronic spreadsheets as they are kept in the ordinary course of business requires Defendant to produce those documents with the metadata intact. As noted above, the Court finds insufficient guidance in either the federal rules or case law, and thus relies primarily on the
Comment 9.a. to the Sedona Principles for Electronic Document Production approaches discoverability based on what constitutes a âdocumentâ under Rule 34. This comment uses viewability as the determining1 factor in whether something should be presumptively treated as a part of a âdocument.â Using viewability as the standard, all metadata ordinarily visible to the user of the Excel spreadsheet application should presumptively be treated as part of the âdocumentâ and should thus be discoverable. For spreadsheet applications, the user ordinarily would be able to view the contents of the cells on the spreadsheets, and thus the contents of those cells would be discoverable.
In light of the proposed amendment to Rule 34, which adds âelectronically stored informationâ as its own separate category, it is no longer necessary to focus on what constitutes a âdocument.â With regard to me-tadata in general, the Court looks to Principle 12 and Comment 12.a. to the Sedona Principles. Based upon this Principle and Comment, emerging standards of electronic discovery appear to articulate a general presumption against the production of metadata, but provide a clear caveat when the producing party is aware or should be reasonably aware that particular metadata is relevant to the dispute.
Based on these emerging standards, the Court holds that when a party is ordered to produce electronic documents as they are maintained in the ordinary course of business,
i. Relevancy
Defendant maintains that the metadata it removed from its electronic spreadsheets has absolutely no evidentiary value and is completely irrelevant. It argues that Plaintiffsâ suggestion that the metadata may identify the computers used to create or modify the spreadsheets or reveal titles of documents that may assist in efforts to piece together the facts of the RIFs at issue in this case has no relevance to Plaintiffsâ claim that Defendant maintained discriminatory policies or practices used to effectuate a pattern and practice of age discrimination. Defendant likewise argues that the metadata is not necessary because the titles of documents can be gleaned from the subject spreadsheets, and these titles adequately describe the data included in such spreadsheets.
The Court agrees with Defendant that certain metadata from the spreadsheets may be
ii. Reliability
Defendant also argues that the metadata removed from the electronic spreadsheets may be inaccurate and therefore has no evi-dentiary value. The Court finds that this is not sufficient justification for removing the metadata absent agreement of the parties or the Courtâs approval. If Defendant had any concerns regarding the accuracy or reliability of the metadata, it should have communicated those concerns to the Court before it scrubbed the metadata.
Hi. Privilege
Defendant also argues that production of certain metadata removed by Defendant would facilitate the revelation of information that is attorney-client privileged and/or attorney work product. Defendant claims that through the use of easily accessible technology, metadata may reveal information extracted from a document, such as the items redacted by Defendantâs counsel, as well as other protected or privileged matters. It further claims that metadata may â create a data trail that reveals changes to prior drafts or edits.
The Court agrees with Defendant that it should not be required to produce metadata directly corresponding to the information that it was permitted to redact, namely the adverse impact analyses and social security numbers. The Court is cognizant that all or some of the metadata may reveal the redacted information. The Court will therefore permit Defendant to remove metadata directly corresponding to Defendantâs adverse impact analyses and social security number information.
For any other metadata Defendant claims is protected by the attorney-client privilege or as attorney work product, the Court finds that Defendant should have raised this issue prior to its unilateral decision to produce the spreadsheets with the metadata removed. Fed.R.Civ.P. 26(b)(5) requires a party withholding otherwise discoverable information on the basis of privilege to make the claim expressly and to describe the nature of the documents, communications, or things not produced or disclosed in a manner that, without revealing the privileged information, will enable the other parties to assess the applicability of the privilege. Normally, this is accomplished by objecting and providing a privilege log for âdocuments, communications, or thingsâ
In this case, Defendant has failed to object and has not provided a privilege log identifying the electronic documents that it claims contain privileged metadata. Defendant has not provided the Court with even a general description of the purportedly privileged me-tadata that was scrubbed from the spreadsheets. As Defendant has failed to provide any privilege log for the electronic documents it claims contain metadata that will
2. Plaintiffs never requested the production of metadata
Defendant also argues that Plaintiffs never requested the metadata and that metadata was never mentioned during any of the discovery conferences. While metadata was never mentioned during any of the discovery conferences or in any of the Courtâs orders, the Court finds that Defendant should reasonably have been aware that the spreadsheetsâ metadata was encompassed within the Courtâs directive that it produce the electronic Excel spreadsheets as they are maintained in the regular course of business. Defendant is correct in asserting that Plaintiffs never expressly requested metadata and that the Court never expressly ordered Defendant to produce the electronic spreadsheetsâ metadata. However, taken in the context of Plaintiffsâ stated reasons for requesting the Excel spreadsheets in their native electronic format and the Courtâs repeated statements that the spreadsheets should be produced in the electronic form in which they are maintained, the Court finds that Defendant should have reasonably understood that the Court expected and intended for Defendant to produce the spreadsheetsâ metadata along with the Excel spreadsheets. If Defendant did not understand the Courtâs ruling, it should have requested clarification of the Courtâs order. As the Sedona Working Group on Electronic Document Production observed: âOf course, if the producing party knows or should reasonably know that particular meta-data is relevant to the dispute, it should be produced.â
3. Whether Judge Lungstrumâs prior orders compel the removal of meta-data
Defendant next argues that its removal of metadata from the RIF spreadsheets was consistent with, if not compelled by, Judge Lungstrumâs prior orders. Defendant appears to be arguing that Judge Lungstrumâs prior rulings with regard to the adverse impact analyses compel the removal of all meta-data. As discussed in section II.A. above, Defendant may redact its adverse impact analyses and social security numbers from the spreadsheets prior to producing them to Plaintiffs. Defendant may also remove the metadata directly corresponding to the redacted information. The undersigned Magistrate Judge, however, does not find that Judge Lungstrumâs prior rulings compel the removal of all other metadata. But in any event, if Defendant believed that Judge Lungstrumâs rulings compelled the removal
C. Locked Spreadsheet Cells and Data
The Court next addresses whether Defendant has shown cause for the locking of certain data and cells on the Excel spreadsheets produced to Plaintiffs. Defendant states that it locked the value of the cells in the spreadsheets to ensure the integrity of the data regarding RIFs, i.e., to ensure that the data could not be accidentally or intentionally altered. Defendant claims its purpose was not to preclude Plaintiffs from sorting or filtering the data, a task it claims Plaintiffs could easily accomplish by copying the data to another spreadsheet. Instead, Defendant claims it locked the data to preclude inadvertent or intentional modification of the data it produced. It argues that because electronic data is not ordinarily static, locking the data was essential to ensure that Defendant could demonstrate data subsequently used in the case was identical to data it produced electronically. It asserts that no malicious intent was associated with Defendantâs efforts to preserve the integrity of the data it produced.
The Court finds that Defendant has failed to show sufficient cause for its unannounced and unilateral actions in locking certain data and cells on the Excel spreadsheets the Court ordered it to produce to Plaintiffs in the manner in which they were maintained. None of the reasons asserted by Defendant justifies its decision to lock the spreadsheet