Spreadsheet checks before running deadlines in California

Spreadsheets are great—until they quietly drift out of sync with California’s procedural rules. A single wrong “+30” or mis‑labeled column can snowball into a chain of incorrect deadlines.

This post walks through how to sanity‑check a deadline spreadsheet before you run California dates through a calculator like DocketMath’s deadline tool. The focus is on structure, not on giving legal advice, so you can adapt it to your own rules and practices.

What the checker catches

Think of a “spreadsheet checker” as a short, repeatable review you run before feeding data into DocketMath. You’re not auditing the law—you’re auditing the inputs that will drive your calculations.

Below are the main categories of issues it should catch, with concrete examples tailored to California practice.

1. Wrong or ambiguous event types

If your “Trigger Event” column isn’t precise, your calculations won’t be either.

Common problem patterns:

• “Service of motion” (but California deadlines often differ for:

  • Service of moving papers
  • Service of opposition
  • Service of reply
• “Complaint filed” vs. “Complaint served”
• “Order entered” vs. “Notice of entry served”

Checklist:

• Each row clearly states what happened (e.g., “Service of summons and complaint on Defendant A”)
• You distinguish filing from service, and entry from notice of entry
• Multi-step events are broken into separate rows if they drive different deadlines

2. Missing jurisdiction and court context

California has layers: statewide rules, local rules, and sometimes judge‑specific orders. A generic “CA” label isn’t always enough.

Your checker should confirm that for each event (or matter):

• Jurisdiction is clearly noted (e.g., “California state court”)
• Court level is captured where it matters:

  • Superior Court (and which county, if local rules are relevant)
  • Court of Appeal (with district, if needed)
  • Supreme Court
• You’ve flagged whether federal rules might apply instead (e.g., removed case in C.D. Cal.)

A simple structure that tends to work:

Column	Example value
Jurisdiction	US-CA
Court	Los Angeles County Superior Ct.
Proceeding type	Unlimited civil
Governing rule set	CCP / CRC / Local rules

Your checker should highlight any blank or inconsistent court/jurisdiction entries before you calculate deadlines.

3. Date format and time-zone consistency

California deadlines often depend on:

• Calendar vs. court days
• Holidays recognized by California courts
• Timing of electronic vs. mail service

Your checker should catch:

• Mixed date formats (e.g., 3/4/24 vs. 2024-03-04)
• Text dates that won’t parse correctly (e.g., “March 4th, 2024”)
• Missing or ambiguous service dates (e.g., only “filed” date, no “served” date where service controls)

Checklist:

• All dates use a consistent format (e.g., ISO YYYY-MM-DD)
• Service date columns are not blank where they drive deadlines
• “Service method” is recorded so you can apply the right California extensions (mail, overnight, electronic, personal)

A minimal but effective schema:

Column	Example value
Event date	2026-02-02
Service date	2026-02-02
Service method	Electronic
Time zone	America/Los_Angeles

4. Direction of time and offsets

California rules frequently say things like:

• “At least 16 court days before the hearing”
• “Within 30 days after service”
• “No later than 60 days after mailing of notice of entry”

Your spreadsheet should always make these assumptions explicit:

• A Direction column (e.g., “before” or “after”)
• A Unit column (e.g., “calendar days”, “court days”, “months”)
• A Count column (numeric value only)

Example:

Rule driver	Direction	Count	Unit
Time to oppose motion	before	9	court days
Time to appeal civil	after	60	calendar days

Your checker should flag:

• Rows missing direction
• Rows where unit is blank or inconsistent
• Any non-numeric values in the Count column (e.g., “thirty”)

This is what lets a tool like DocketMath reliably turn your spreadsheet row into a precise calculation.

5. Service method and extensions

California’s service rules can change the deadline by several days depending on:

• Mail within California
• Overnight delivery
• Electronic service
• Personal service

Your checker should confirm:

• Service method is always captured where it affects the deadline
• You don’t have “N/A” for service method where the rule clearly depends on service
• You’re not mixing “mail” and “electronic” in one cell (e.g., “mail & email”) without a clear convention

A simple coding scheme:

Code	Meaning
P	Personal service
M	Mail (within California)
O	Overnight delivery
E	Electronic service

Then you can add a checker rule: any row with a California rule that includes mail/e-service extensions must have a valid service code.

6. Status and overrides

Not every theoretical deadline is still active. Some are:

• Superseded by stipulation
• Vacated by court order
• Stayed

Your checker should ensure that:

• There is a Status column (e.g., “Active”, “Vacated”, “Stayed”, “Superseded”)
• Any row with a status other than “Active” is clearly marked so you don’t treat it as a live deadline
• Manual overrides (e.g., “Per judge’s order dated…”) are recorded in a Notes or Authority column

This matters when you later push rows into a calculator. You want to avoid computing dates for deadlines that no longer control.

When to run it

The spreadsheet checker is most useful at three points in your workflow.

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.

Capture the source for each input so another team member can verify the same result quickly.

1. When you first build or import a template

If you maintain a master “California civil deadlines” spreadsheet:

• Run the checker when:

  • You first build the template
  • You import a template from another team, firm, or vendor
• Use the checker to:

  • Normalize column names
  • Standardize jurisdictions, courts, and units
  • Remove legacy or outdated rule assumptions

This prevents old logic from silently propagating into new matters.

2. Before using DocketMath for a new matter

Right before you feed your spreadsheet into DocketMath’s deadline calculator:

• Filter to the specific court and case type (e.g., “US-CA, LA Superior, Unlimited civil”)
• Run the checker to confirm:

  • No blank trigger dates
  • No missing direction/unit/count fields
  • Service methods are filled in where needed
• Spot-check a few rows against your current understanding of California rules

You’re not validating the law here—you’re validating that your spreadsheet correctly describes the law you intend to apply.

3. After rule changes or local rule updates

California’s rules and local practices evolve. When you learn about:

• A California Rules of Court amendment
• A local rule change in your key counties
• A new standing order that affects timing

Run the checker on:

• The affected subset of rows (by rule citation, if you track it)
• Any templates that rely on those rules

Then decide whether to:

• Update the offset or unit (e.g., 10 to 15 court days)
• Add or remove a service extension
• Mark old rows as “Superseded” and add new ones

Try the checker

You can approximate a “checker” with filters and conditional formatting, but it’s even more effective when paired with a calculator that understands jurisdictional logic.

A practical way to start:

1. Standardize your columns
   Decide on a minimal schema for California matters:

   • Trigger event description
   • Event date
   • Service date
   • Service method
   • Jurisdiction (e.g., US-CA)
   • Court
   • Direction (before/after)
   • Count
   • Unit (calendar/court days, months, years)
   • Status
   • Notes / Authority

2. Add simple “checker” rules in your spreadsheet
   Examples:

   • Conditional formatting for blank Direction, Count, or Unit
   • Data validation lists for Jurisdiction, Court, Service method, Status
   • Filters to quickly find rows with missing service data

3. Push clean rows into DocketMath
   Once your spreadsheet passes its own checks, use DocketMath’s deadline calculator to:

   • Apply California-specific calendar logic
   • Incorporate court holidays
   • Generate concrete, matter-specific deadlines you can review against the underlying rules

Related reading

• Why deadlines results differ in Canada

• Worked example: deadlines in New York

• Deadlines reference snapshot for New Hampshire

• Why we started the DocketMath blog