Spreadsheet checks before running deadlines in Rhode Island

Spreadsheets are great—until they aren’t. A single off-by-one formula or mis-sorted row can quietly corrupt every deadline in a case. Before you run Rhode Island deadlines through any calculator, it’s worth giving your spreadsheet a quick, systematic sanity check.

Below is a practical checklist-style guide to vetting your data before you plug it into DocketMath’s Rhode Island deadline calculator.

What the checker catches

Think of the “checker” as a short, repeatable routine you run on your spreadsheet before you calculate deadlines. You can do it manually, or you can mirror the logic in formulas or scripts.

Here’s what it’s designed to catch for Rhode Island work:

1. Bad or ambiguous dates

Inconsistent or invalid date entries are the fastest way to derail a deadline run.

Check for:

• Mixed formats: 1/2/24, 2024-01-02, Jan 2 2024
• Text dates that won’t parse: next Monday, TBD, ASAP
• Impossible dates: 2/30/2024, 13/01/2024
• Missing years: 3/15 (is that this year or next?)

Practical steps:

• Convert the “trigger date” column to a Date type (not Text).
• Sort by that column and scan for blanks or odd values clustered at the top or bottom.
• Use a helper column with a formula like =ISNUMBER(A2) to flag non-date values.

2. Wrong event-to-rule mapping

Each row in a litigation spreadsheet usually represents an “event” (e.g., “Complaint served,” “Answer due,” “Discovery responses due”). The problem: similar-sounding events can trigger very different rules.

Common trouble spots:

• Confusing service of complaint with filing of complaint
• Mixing up calendar days and court days
• Using a federal rule citation for a Rhode Island state-court task
• Carrying over rule numbers from a prior version of the rules

Checklist for each event row:

• Confirm the “Rule / Authority” column clearly points to Rhode Island (e.g., “RI” or “R.I. R. Civ. P.”), not a federal or other state rule.
• Make sure the event is clearly labeled as a trigger (e.g., “Service of complaint”) or a deadline (e.g., “Answer due”).
• If you’re tracking both state and federal in the same file, include a “Court / System” column so you can filter Rhode Island rows separately.

A simple mapping table can help:

If any of those cells are blank or inconsistent, that row is not ready to run.

3. Misaligned offsets and time periods

Rhode Island rules can vary in:

• Length of time (e.g., 10 vs. 20 vs. 30 days)
• Whether time is measured in calendar or court days
• How weekends and legal holidays are treated

Before calculation, verify:

• The “Days to add” column matches the current Rhode Island rule you’re relying on.
• If you store “10 court days” as just 10, there’s a separate “Day type” column that says “court.”
• Short time periods (e.g., under 7 days) are clearly flagged for any special counting rules you follow.

4. Direction errors (counting forward vs. backward)

Not every deadline counts forward from a triggering event. Some dates are:

• Counted backward from a hearing or trial date
• Tied to entry of judgment rather than filing
• Based on service of a motion rather than the hearing date

Pre-check:

• Add a “Direction” column with values like Forward or Backward.
• Confirm that backward-count deadlines (e.g., “Opposition due 10 days before hearing”) are marked correctly.
• Make sure your “Anchor date” column is the right one (hearing date vs. service date).

When you later use DocketMath, these directional and anchor details are what drive how the /tools/deadline calculator interprets your inputs.

5. Duplicated or missing events

Spreadsheets evolve. Rows get copied, moved, or filtered. That’s where ghost deadlines appear—or disappear.

Run these quick checks:

• Sort by “Event name” and scan for duplicates that share the same trigger date and rule.
• Filter for blanks in “Trigger date,” “Rule / Authority,” or “Days to add.”
• If you track phases (pleadings, discovery, motions), filter each phase and confirm its expected core events are present.

A simple “Status” column (e.g., Planned, Calculated, Verified) can also help you see which rows are still in flux.

When to run it

The checker works best if you treat it as a standard step in your workflow, not a one-off rescue mission.

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. Right after building or importing a case

Any time you:

• Import from a case-management system
• Copy a template from another matter
• Merge multiple tabs into one master sheet

…run the checker before you calculate a single Rhode Island deadline.

This is where you’ll catch:

• Wrong jurisdiction labels
• Legacy federal rules in a Rhode Island file
• Old rule versions that no longer match current practice

2. Before any major recalculation

Re-run your checks when:

• The court resets a hearing or trial date
• You add new claims or parties that change the pleading sequence
• You convert a Rhode Island state case to federal or vice versa

In practice:

• Lock in the new anchor date(s) in your spreadsheet.
• Reconfirm the direction and time periods for any dependent deadlines.
• Only then re-run your Rhode Island calculations in DocketMath.

3. When rules or local practices change

If you learn that:

• A Rhode Island rule has been amended
• A local practice in a particular county affects timing
• A standing order changes briefing schedules

…use that as a trigger to:

• Update your “Rule / Authority” and “Time period” columns.
• Re-run the checker to ensure no rows still rely on the old settings.
• Mark in a “Version” or “Notes” column which rule set each row assumes.

Try the checker

You don’t need elaborate macros to get value from this process. A simple, repeatable routine works:

1. Normalize your dates

   • Convert trigger dates to a Date type.
   • Use filters or conditional formatting to highlight invalid or missing dates.

2. Standardize your columns

   • At minimum, have:

     • Court / System
     • Event name
     • Trigger date
     • Rule / Authority
     • Days to add
     • Day type (calendar vs. court)
     • Direction (forward vs. backward)
   • Make sure every row you plan to calculate has all of these filled in.

3. Filter by jurisdiction

   • Filter Court / System to Rhode Island only.
   • Confirm that rule citations match Rhode Island practice (e.g., “R.I. R. Civ. P.”).

4. Spot-check a few rows manually

   • Choose:

     • One simple pleading deadline
     • One discovery deadline
     • One motion or hearing-related deadline
   • Manually count days on a calendar for each and compare to what your spreadsheet currently produces.

5. Run the case through DocketMath

   • Once the sheet passes your sanity checks, use the Rhode Island settings in the DocketMath deadline calculator.
   • Compare your spreadsheet’s output dates with the calculator’s results. Any mismatch is a signal to revisit the corresponding input row.

6. Record what you assumed

   • In a “Notes” column, capture assumptions like:

     • “Assumes calendar days; weekends included unless final date falls on weekend/holiday.”
     • “Counts backward from hearing date.”
   • This makes future audits and updates far easier.

Related reading

• Why we started the DocketMath blog

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

• Why we started the DocketMath blog

• Why we started the DocketMath blog