230 F.R.D. 640 | D. Kan. | 2005
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 cells and data prior to producing them to Plaintiffs. While the Court’s Order did not expressly state that the spreadsheets should be produced “unlocked,” Defendant should have been reasonably aware that locking the spreadsheets’ cells and data was not complying with the spirit of the Court’s directive that the spreadsheets be produced as they are kept in the ordinary course of business. Moreover, at the June 2, 2005 discovery conference, Plaintiffs specifically detailed their difficulties with the hard copy versions of the spreadsheets produced by Defendant, including their complaints that the hard copy versions cut off the information contained in the spreadsheet columns and cells.
Defendant’s concerns regarding maintaining the integrity of the spreadsheet’s values and data could have been addressed by the less intrusive and more efficient use of “hash marks.” For example, Defendant could have run the data through a mathematical process to generate a shorter symbolic reference to the original file, called a “hash mark” or “hash value,” that is unique to that particular file.
Defendant also states that despite its ongoing concerns with the integrity of the data in the electronic spreadsheets, it has voluntarily reproduced “unlocked” copies of the spreadsheets that were produced before July 7, 2005. It also represents that all successive productions of spreadsheets have not been locked. The Court concludes from Defendant’s statement that it has already produced “unlocked” spreadsheets to Plaintiffs. To
III. Sanctions
The Court’s Show Cause Order also required Defendant to show cause why it should not be sanctioned for its failure to comply with the Court’s ruling directing Defendant to produce electronic spreadsheets in the manner in which they were maintained. Defendant states that it did not understand the Court’s direction to produce electronic spreadsheets included the production of metadata and that its actions were not made in bad faith. It points out that it has already produced hundreds of documents in response to formal and informal requests for production, answered hundreds of interrogatories, and produced and scheduled scores of witnesses for deposition in support of its assertion that it has acted in good faith throughout this litigation.
The Court concludes that Defendant has shown cause why it should not be sanctioned for its actions in scrubbing the metadata and locking spreadsheet cells and data. Although the Court intended its ruling requiring Defendant to produce the electronic RIF-related spreadsheets in the manner in which they were ordinarily maintained to include the metadata, the Court recognizes that the production of metadata is a new and largely undeveloped area of the law. This lack of clear law on production of metadata, combined with the arguable ambiguity in the Court’s prior rulings, compels the Court to conclude that sanctions are not appropriate here.
The Court, however, wants to clarify the law regarding the production of metadata in this case. When the Court orders a party to produce an electronic document in the form in which it is regularly maintained, i.e., in its native format or as an active file, that production must include all metadata unless that party timely objects to production of the metadata, the parties agree that the metada-ta should not be produced, or the producing party requests a protective order.
Defendant avoids sanctions with regard to its locking of the spreadsheet cells and data by its decision to voluntarily reproduce “unlocked” versions of these spreadsheets to Plaintiffs. As directed above, to the extent that Defendant has not produced “unlocked” versions of all the spreadsheets previously produced with locked cells or data, it shall produce “unlocked” versions of those spreadsheets by the next discovery conference on October 6, 2005, or advise the Court at the discovery conference of the date when this information will be produced.
IT IS THEREFORE ORDERED that Defendant has failed to show cause why it should not produce the electronic spreadsheets in the manner in which they were maintained. Defendant therefore shall produce the electronic spreadsheets in the manner in which they were maintained, which includes the spreadsheets’ metadata. Defendant may, however, redact its adverse impact analyses and any social security numbers from the spreadsheets prior to producing them to Plaintiffs. Defendant may also remove the metadata directly corresponding to the redacted information. Defendant shall produce the electronic spreadsheets by the next discovery conference on October 6, 2005, or advise the Court at the October 6, 2005 discovery conference of the date when these spreadsheets will be produced. Any assertion of attorney-client privilege or work product protection with regard to the meta-data contained within these Excel spreadsheets, other than the metadata directly corresponding to the adverse impact analyses and social security number information, is deemed waived due- to Defendant’s failure to object and produce a privilege log regarding the metadata.
IT IS FURTHER ORDERED that to the extent Defendant has not reproduced “un
IT IS FURTHER ORDERED that Defendant has shown sufficient cause why it should not be sanctioned for its failure to comply with the Court’s ruling directing it to produce electronic spreadsheets in the manner in which they were maintained.
IT IS SO ORDERED.
. The following explanation accompanied Item 1 on Plaintiffs’ List of Issues for the May 5, 2005 discovery conference (doc. 3301):
These documents constitute the essential materials regarding the termination and other RIF decisions that are at issue in this collective action. Plaintiffs requested these documents in November of 2003 and again in December of 2004, and yet Defendant has produced only a few improperly redacted versions relating to some Plaintiffs and initial Opt-in Plaintiffs. At an April 12th meet and confer with [Plaintiffs’ counsel], Defendant’s counsel promised these documents would begin being produced in batches. At the meet and confer prior to the April 21st hearing, Plaintiffs noted that Defendant still had not begun producing any of these documents. Defendant’s counsel acknowledged at that time that he had nine (9) boxes of these documents in his office. At the April 21st hearing, Defendant stated it would begin getting these documents produced. To date, Defendant has still not begun production of these documents which are of core relevance to this collective action. Defendant’s counsel has been indefinite and imprecise as to when Defendant will be able to certify that it has produced all of these basic RIF decision documents and spreadsheets. At the May 5th conference, Plaintiffs seek the Court's Order that Defendant produce all such documents no later than May 16, 2005.
. The following explanation accompanied Item 2 on Plaintiffs' List of Issues for the May 5, 2005 discovery conference (doc. 3301):
Plaintiffs requested these documents in November of 2003, and yet Defendant continues to trickle such documents in and to indicate that it has not produced all such documents. Indeed, Defendant’s counsel recently advised Plaintiffs' counsel that it had not produced various Sprint Human Resources officials’ notes and other documents regarding the RIF decisions at issue in this case and that Defendant would not consider producing such documents until a new, formal request for production was made. At the May 5th conference, Plaintiffs seek the Court’s Order that Defendant produce all such documents no later than May 16, 2005. (emphasis in original)
. May 5, 2005 Discovery Conf. Transcript (Tr.) (doc. 2905) p. 15,1. 11-21.
. Id. at p. 25,1. 18-21.
. Id. at p. 26,1. 10-12.
. Id. at p. 27,1. 3-7.
. May 19, 2005 Tr. (doc. 2915) p. 11-12, 1. 24-25; 1-2.
. TIFF (Tagged Image File Format) is one of the most widely used and supported graphic file formats for storing bit-mapped images, with many different compression formats and resolutions. A TIFF file is characterized by its "tif” file name extension. The Sedona Conference Glossary for E-Discovery and Digital Information Management (The Sedona Conference Working Group Series, May 2005 Version), available at http:// www.thesedonaconference.org. The Sedona Conference is a nonprofit legal policy research and educational organization which sponsors Working Groups on cutting-edge issues of law. The Working Group on Electronic Document Production is comprised of judges, attorneys, and technologists experienced in electronic discovery and document management matters.
. May 19, 2005 Tr. p. 12,1. 17-24.
. Id. at p. 16,1. 11-13.
. Id. at p. 16,1. 19-25.
. June 2, 2005 Tr. (doc. 2940) p. 55, 1. 11-18.
. Id. at p.57,1. 15-18.
. Id. at p. 57,1. 19-24.
. Id. at p. 57-58,1. 15-25; 1-8.
. June 9, 2005 Tr. (doc. 3146) p. 17, 1. 22-24.
. Doc. 2953.
. See Defendant's Response to Show Cause Order (doc. 2968).
. July 7, 2005 Tr. (doc. 3147) p. 60, 1. 20-25.
. Id. at p. 61,1. 4-6.
. Id. al p. 61,1. 9-13.
. Doc. 3037.
. Id.
. See June 2, 2005 Tr. p. 57-58.
. Proposed advisory committee note to Federal Rule of Civil Procedure 26(0- The pending rule amendments and notes can be viewed at: http:/! www.us courts.go vlrules/comment2005/ CVAug04.pdf# page=24. On September 20, 2005, the Judicial Conference approved the proposed rule amendments and they were transmitted to the Supreme Court for approval. The proposed rule amendments are set to become effective December 1, 2006.
. The Sedona Guidelines: Best Practice Guidelines & Commentary for Managing Information & Records in the Electronic Age, App. F (The Sedo-na Conference Working Group Series, Sept. 2005 Version), available generally at http://www.these-don aconference.org and more specifically at http: Hwww.thesedona conference.org/content /mi-scFiles/TSG9 05.pdf.
. Id. at App. E.
. Id. at App. E. n. 1.
. Id. at App. E.
. Id.
. The Sedona Conference Glossary, p. 28-29.
. The Sedona Principles: Best Practices, Recommendations & Principles for Addressing Electronic Document Discovery, Cmt. 12.a. (The Sedona Conference Working Group Series, July 2005 Version), available generally at http://www.these-do naconference.org, and more specifically at available at http.i/www.thesedon aconference.org/ content/miscFiles/7 05TSP.pdf.
. The Sedona Guidelines, App. E.
. Id.
. Microsoft Office Online: Find and Remove Metadata (Hidden Information) in Your Legal Documents, http://office.microsoft ,co m/en-us/assistance /HA010776461033.aspx.
. See e.g., Brian D. Zall, Metadata: Hidden Information in Microsoft Word Documents and its Ethical Implications, 33-Oct. Colo. Law. 53 (2004).
. Id. at 58.
. Id.
. The Sedona Principles, p. 5-6.
. Id.
. Fed.R.Civ.P. 34(a).
. Fed.R.Civ.P. 34(b).
. Fed.R.Civ.P. 34(a) advisory committee’s note.
. Fed.R.Evid. 803(6) advisory committee’s note.
. The pending rule amendments can be viewed at http://www.uscou.rts. gov/rules/Reports/ ST09-2005. pdf. On September 20, 2005, the Judicial Conference approved the proposed rules amendments and they were transmitted to the Supreme Court for approval. The proposed rule amendments are set to become effective December 1, 2006.
. Id.
. Id.
. No. C 02-2270 JW, 2004 WL 2445243 (N.D.Cal. Mar. 10, 2004).
. 2004 WL 2445243, at *2.
. Id. at *1.
. In re Tehon Corp. Sec. Litig., No. 5:98CV2876, 1:01CV1078, 2004 WL 3192729 (N.D.Ohio July 16, 2004), reported in LEXIS as Hayman v. Price Waterhouse Coopers, LLP, 2004 U.S. LEXIS 27296. Note that the litigation concluded before the district judge issued any ruling on the magistrate judge’s Amended Report and Recommendation.
. Id. at *34 (The magistrate judge found the defendant’s explanations for the missing documents and metadata and for differences between hardcopy versions of documents and those on any of the electronic databases less than convincing. She stated the defendant's explanations "may explain these phenomena in whole or in part, but ‘may’ is the operative conditioner here.”)
. The Sedona Principles, Principle 9.
. The Sedona Principles, Principle 12.
. The Sedona Principles, Cmt. 9.a.
. Id.
. Id.
. Id.
. Id.
. The Sedona Principles, Cmt. 9.a. (citing McPeek v. Ashcroft, 202 F.R.D. 31, 33 (D.D.C. 2001); McPeek v. Ashcroft, 212 F.R.D. 33, 35-37 (D.D.C.2003)).
. The Sedona Principles, Cmt. 9.a.
. The Sedona Principles, Cmt. 12.a. (citing Pub. Citizen v. Carlin, 184 F.3d 900, 908-11 (D.C.Cir. 1999), cert. denied, 529 U.S. 1003, 120 S.Ct. 1267, 146 L.Ed.2d 217 (2000)).
. The Sedona Principles, Cmt. 12.a.
. Id.
. Id.
. Id.
. Id.
. This same reasoning would apply if the court ordered a party to produce the electronic documents as an "active file” or in their "native format.”
. The same principle may apply when a party requests electronic documents be produced as they are maintained in the ordinary course of business, as an "active file,” or in their "native format.”
. Fed.R.Civ.P. 26(b)(5).
. See Employer’s Reinsurance Corp. v. Clarendon Nat’l Ins. Co., 213 F.R.D. 422, 428 (D.Kan.2003) (stating that it is well-established law in this district that failure to produce a privilege log can result in a waiver of any protection afforded to those documents); Haid v. Wal-Mart Stores, Inc., No. 99-4186-RDR, 2001 WL 964102, at *1 (D.Kan. June 25, 2001) (failure to produce a privilege log or production of an inadequate privilege log may be deemed a waiver of the privilege asserted); Starlight Int'l, Inc. v. Herlihy, No. 97-2329-GTV, 1998 WL 329268, at *3 (D.Kan. June 16, 1998) (same).
. The Court recognizes that this ruling impacts the relief requested by Plaintiffs in their pending Motion to Declare Defendant Has Waived Any Asserted Privilege With Regard to Certain Documents and Electronic Spreadsheets (doc. 3192). The Court intends its ruling herein to resolve the issue of waiver with regard to metadata only. The remainder of Plaintiffs’ Motion to Declare Defendant Has Waived Any Asserted Privilege With Regard to Certain Documents and Electronic Spreadsheets (doc. 3192) is still pending.
. The Sedona Principles, Cmt. 12.a.
. Dean M. Harts, Reel to Real: Should You Believe What You See? Keeping the good and eliminating the had of computer-generated evidence will be accomplished through methods of self-authentication and vigilance, 66 Def. Couns. J. 514, 522 (1999).
. Id.
. Id.
. Id.