The spreadsheet was not in admissible form?

Key Takeaways

• The insurer’s spreadsheets did not establish the admissibility needed to prove timely verification requests.
• Jason’s original account says the spreadsheets summarized documents already supplied with the motion.
• That explanation did not change the appellate court’s ruling on the foundation actually presented.
• The insurer nevertheless obtained dismissal of a duplicate claim and further proceedings.
• The case illustrates why an evidentiary setback and the overall appellate result must be described separately.

What failed in Total Family v Mercury?

Total Family Chiropractic v Mercury Casualty Co., 28 Misc 3d 138(A), 2010 NY Slip Op 51470(U), was decided August 13, 2010, by the Appellate Term, Second Department.

Mercury relied on spreadsheets attached to its claim representative’s affidavit to establish that outstanding verification requests tolled the time to pay or deny claims.

The court found that the representative had not established the spreadsheets’ admissibility under CPLR 4518(a). The insurer therefore had not shown timely verification requests.

The holding was about the foundation submitted on that motion. It was not a rule that the spreadsheet format itself makes evidence inadmissible.

A summary is not its own foundation

The firm’s CPLR 4518 business-records guide addresses the broader foundation requirements. This older note adds a concrete example of a claim chronology that did not carry the evidentiary burden.

Under CPLR 4518(a), the inquiry concerns how a record was made and maintained. The statute also addresses whether an electronic record’s tangible exhibit accurately represents that record.

A table can make a large file easier to understand. That presentation function is different from proving the dates or events listed in the table.

The useful questions are therefore separate: what does the summary illustrate, where is its source information, and what evidence establishes the source and summary as usable proof?

Those are reading prompts, not a model affidavit. Merely attaching or incorporating a spreadsheet does not guarantee admission.

Jason’s original account — August 19, 2010

Jason opened with a candid assessment:

This was another one that did not necessarily go my way.

He described a large motion record and a spreadsheet used to organize dates across numerous bills. These selections preserve his explanation:

In fact, the motion was about 1000 pages. The spreadsheet was more or less illustrative.

Since there was so much information for each bill, I used a spreadsheet instead of one of my charts in this case.

Here, the information was always stored and processed by Mercury.

The size and organization of the motion are details from Jason’s published account, not separate findings in the short appellate opinion. His disagreement with the court remains part of the historical record.

The original account also included personal allegations unrelated to understanding the foundation issue. They are omitted here; the relevant procedural history is available in the official decision.

Why the result was mixed

The appellate court reversed the provider’s judgment and vacated the underlying order. It dismissed one claim as duplicative, denied the provider’s cross motion and struck the notice of trial.

The matter returned to Civil Court for further proceedings. The opinion found the examination-under-oath transcripts relevant to further discovery on the asserted fraudulent-procurement defense.

It did not determine that the alleged procurement fraud had been proved. Nor did the failure of the spreadsheet foundation mean every defense or discovery request failed.

The court also distinguished the provider from its assignors for discovery purposes. It required subpoenas to compel the assignors’ examinations rather than treating them as the provider’s officers or employees.

The opinion’s discovery discussion concerns this record and the way the assignors’ testimony was sought. It should not be converted into an automatic dismissal or sanctions rule for every missed examination.

Comparing evidentiary problems across the archive

Market Street’s expert-preclusion appeal concerned witnesses excluded at a nonjury trial. It resulted in a limited new trial, not a ruling about spreadsheet records.

McMahon’s CPT Assistant appeal concerned incorporated coding guidance excluded in arbitration. It resulted in a new arbitration, not a business-records ruling.

The distinctions help keep the archive useful: the source of a document, the authority of coding guidance and the timing of expert disclosure are different problems.

For no-fault defense work, a record review should connect each asserted date to the supporting document and foundation evidence. A clear chronology helps counsel find gaps before asking a court to rely on it.

The Legal Encyclopedia provides wider topic navigation. This note preserves a particular evidentiary disagreement and the actual mixed disposition.

For review of a current file, request a Free Case Review.

Last reviewed: September 2026 — editorial source check against the opinion, current CPLR 4518 and original public note. Original publication date retained; no finding of fraud or final case outcome is asserted.