Spreadsheet checks before running deadlines in Massachusetts

Sanity-checking your spreadsheet before you calculate Massachusetts deadlines is the difference between a clean, explainable result and a silent error that only shows up when something is late.

This post walks through how to use a “spreadsheet checker” mindset with DocketMath’s deadline calculator for Massachusetts (US‑MA). The focus is on what to verify, when to run checks, and how those checks change the output you get.

What the checker catches

Think of the checker as a repeatable pre‑flight list for your spreadsheet and DocketMath inputs. It doesn’t give you legal advice or tell you what rule to apply—it helps you confirm that what you think you’re calculating is actually what’s in the sheet.

Below are the main categories of mistakes it’s designed to catch, with Massachusetts‑specific twists.

1. Wrong starting event or date

Deadlines in Massachusetts often hinge on very specific trigger events: “service,” “entry of judgment,” “mailing,” “filing,” etc. A checker helps you confirm:

• The trigger event in your spreadsheet matches the event in the rule
• The date in the spreadsheet matches the date in the file or docket
• You’re not accidentally using a hearing date where the rule keys off service

How this changes outputs

If you fix the starting event/date:

• All downstream deadlines shift accordingly.
• DocketMath’s Explain++‑style breakdown will show a different “Start from” line and different intermediate steps (e.g., weekends/holidays skipped).

2. Calendar‑type mistakes (court days vs calendar days)

Massachusetts rules frequently distinguish between:

• Calendar days – count every day
• Court days – skip weekends and court holidays

Your checker should force you to answer:

• Does this rule say “days” (often calendar) or “court days” / “business days”?
• Does my spreadsheet formula match that choice?
• Does my DocketMath input use the same choice?

How this changes outputs

• A 10‑day deadline:

  • As calendar days might land on a weekend or holiday.
  • As court days will skip weekends and holidays and may land days later.
• If you change the “day type” in your spreadsheet but forget to change it in DocketMath (or vice versa), your outputs will diverge by several days.

3. Weekend and Massachusetts holiday handling

Even when you’re counting calendar days, rules may tell you what happens when a deadline lands on:

• A Saturday or Sunday
• A Massachusetts legal holiday
• A federal holiday (for some deadlines)

Your checker should confirm:

• Does my spreadsheet adjust when the computed date is a weekend?
• Does it adjust for Massachusetts court holidays, not just federal holidays?
• Does that adjustment rule match what DocketMath is doing?

How this changes outputs

• If your spreadsheet ignores holidays, you may:

  • End up with due dates on days the court is closed.
  • See a one‑ or two‑day mismatch compared to DocketMath’s output.
• Once you align holiday logic, your dates should match DocketMath’s date (or differ only where you’ve consciously chosen a different interpretation).

4. Extra time for service method (mail, e‑service, etc.)

Massachusetts rules sometimes grant additional time based on how service was made (e.g., by mail). Your checker should make you explicitly confirm:

• Did I identify the service method correctly from the file?
• Does this rule actually add time for that method?
• If so, did I add the right number of days in my spreadsheet?
• Does my DocketMath configuration reflect the same assumption?

How this changes outputs

• If you add extra time in the spreadsheet but not in DocketMath:

  • The spreadsheet due date will be later.
• If DocketMath adds time automatically (because the rule and method call for it) but your spreadsheet doesn’t:

  • The DocketMath due date will be later.

Aligning this assumption is critical—especially when you’re documenting calculations for others.

5. Wrong jurisdiction or rule set

Massachusetts has its own procedural rules, plus local rules and standing orders. A checker helps you avoid:

• Using federal rules for a state case
• Using the wrong Massachusetts rule family (e.g., civil vs. appellate)
• Applying a local rule globally

Your checklist:

• Is this actually a Massachusetts (US‑MA) deadline?
• Am I using Massachusetts rules, not federal or another state?
• Did I pick the right rule family (civil, criminal, appellate, probate, etc.)?
• Does my spreadsheet label match the rule name/number I selected in DocketMath?

6. Time‑of‑day and “filed by” assumptions

Some Massachusetts deadlines are “filed by X days after Y,” and your internal practice may treat that as:

• “End of business day”
• “11:59 p.m. local time”
• “Before the clerk’s office closes”

Your checker should:

• Document what “due by” means in your workflow.
• Ensure both spreadsheet and DocketMath notes use the same convention.

DocketMath focuses on the date, not the exact time of day, so this is more about internal documentation than calculation—but it’s still a common source of confusion.

When to run it

You don’t need a full audit for every trivial date, but there are clear moments when running a spreadsheet check is worth the time.

Run the checker before importing a spreadsheet into the Deadline workflow. It is especially helpful when you have multiple entries or when a teammate provided the inputs.

1. Before using a template on a new Massachusetts matter

Any time you take a “generic” deadline spreadsheet and apply it to a Massachusetts case:

• Confirm the jurisdiction (US‑MA)
• Re‑map each rule reference to the Massachusetts equivalent
• Check that DocketMath is set to Massachusetts, not a prior jurisdiction

This avoids quietly importing another state’s logic into a Massachusetts workflow.

2. When a rule or standing order changes

If Massachusetts updates a rule:

• Flag all spreadsheets that reference that rule number or description
• Update the logic and add a note with the effective date of the change
• Run a sample case through DocketMath and compare dates

If your spreadsheet and DocketMath disagree, you’ll know you need to reconcile assumptions before relying on either.

3. Before sharing or delegating work

Any time you send a date to:

• A colleague
• A client
• A docketing team

run a quick check to ensure:

• The spreadsheet shows the rule citation and jurisdiction
• You can reproduce the date in DocketMath’s deadline calculator
• Any differences are explained in a note (e.g., “We’re adding one extra day as a conservative buffer”)

4. When something “looks wrong”

Red flags that should trigger a check:

• A deadline lands on a holiday or weekend with no adjustment.
• A Massachusetts appellate deadline seems unusually short or long.
• Your spreadsheet and DocketMath disagree by more than one day.

In those cases, walk through each checklist item above, then re‑run the calculation.

Try the checker

You can use DocketMath’s deadline calculator as a live “checker” for your spreadsheet logic:

1. Open your spreadsheet.
   Identify:

   • Trigger event and date
   • Number of days
   • Day type (calendar vs court)
   • Any extra time for service
   • Jurisdiction and rule citation

2. Go to DocketMath’s deadline tool.
   Use the jurisdiction‑aware calculator at /tools/deadline.

3. Select Massachusetts (US‑MA).

   • Choose the rule or rule family that matches your spreadsheet.
   • Confirm whether the calculator is using court days or calendar days.

4. Enter the same inputs.

   • Same trigger event date
   • Same service method
   • Same rule selection or time period

5. Compare the outputs.

   • If the dates match:

     • Document that your spreadsheet is aligned with DocketMath.
   • If they differ:

     • Use the step‑by‑step breakdown (Explain++‑style explanation) to see:

       • How days were counted
       • When weekends/holidays were skipped
       • Whether extra time for service was applied

6. Update your spreadsheet.

   • Adjust formulas to reflect the same assumptions.
   • Add notes describing:

     • Jurisdiction: “Massachusetts (US‑MA)”
     • Rule: name/number
     • Day type and holiday rule
     • Whether extra time for service is included

Using DocketMath alongside your spreadsheet gives you a documented, reproducible path from rule to date—critical when someone later asks, “How did you get this deadline?”

Related reading

• Introducing Explain++: step‑by‑step calculation breakdowns

• A practical workflow for jurisdiction‑aware legal calculations (and how to document them)

• Why we started the DocketMath blog