Spreadsheet checks before running Alimony Child Support in New Mexico

What the checker catches

Before you run alimony + child support calculations in New Mexico, DocketMath’s spreadsheet checker helps you catch common “spreadsheet failure modes” that can produce incorrect results—even when the calculator is working correctly.

This checker is especially helpful when your numbers depend on timelines, such as when you’re testing ongoing calculations or running retroactive windows.

Here are the main categories it looks for:

• Date logic errors

  • Start date after end date
  • Missing effective date
  • Inconsistent formatting that can silently convert dates into text (which then breaks date comparisons)

• Lookback / limitations mismatches

  • Retroactive amounts often depend on limitation periods.
  • For New Mexico, this checker uses the general/default statute of limitations rather than claim-type-specific rules, because the jurisdiction data provided does not include claim-type-specific exceptions.
  • It anchors to the general SOL period: 2 years under N.M. Stat. Ann. § 31-1-8.

• Spreadsheet arithmetic pitfalls

  • Child support vs. alimony fields swapped or duplicated
  • Sign mistakes (for example, negative balances or offsets)
  • Totals that don’t reconcile to the sum of line items

• Unit and frequency inconsistencies

  • Using “monthly” values in “weekly” rows (or vice versa)
  • Percent inputs entered as whole numbers (for example, 25 instead of 0.25)

• Missing or inconsistent worksheet logic

  • Scenarios that reference cells not populated in prior tabs
  • Hard-coded values that conflict with table-driven inputs

Limitation period baseline (New Mexico)

For this checker, the limitation-period baseline is the general/default statute of limitations:

• General SOL Period: 2 years
• Statute: N.M. Stat. Ann. § 31-1-8

Important clarity: Because no claim-type-specific sub-rule was found in the provided jurisdiction data, this checker treats § 31-1-8’s general 2-year period as the default limitation period for timeline checks.

When to run it

Run the checker before you rely on any output—especially if you’re building a spreadsheet you plan to use for planning, review, or an initial estimate.

A practical workflow:

• Step 1: Build your input table

  • Enter key dates (start date, end date, and any retroactive window dates you want to test)
  • Add the inputs your sheet uses for support calculations (for example, income figures and any caps/floors or structure you’re modeling)

• Step 2: Run DocketMath’s spreadsheet checks

  • Validate date consistency and parsing
  • Confirm the limitation-window logic aligns with the 2-year general SOL under N.M. Stat. Ann. § 31-1-8
  • Ensure totals tie out

• Step 3: Only then run the alimony/child support calculator

  • Once the timeline and arithmetic are stable, the calculator’s results are more trustworthy

• Step 4: Re-check after edits

  • Small spreadsheet edits—like changing a date cell—can ripple through retroactive windows and totals

Quick rule of thumb: if you change any of the following, rerun the checker immediately:

• any date field
• the definition of the “retroactive window”
• any frequency (weekly vs. monthly)
• any income or percentage input

Date-sensitive checklist (New Mexico-focused)

Before trusting calculator output, quickly verify:

(Gentle note: this is a practical spreadsheet check, not legal advice. For real-world decisions, consider consulting a qualified professional.)

Try the checker

You can test the workflow using DocketMath’s tool entry point:
**/tools/alimony-child-support

If you’re working in a spreadsheet, the most effective approach is to treat the checker as a pre-flight step:

1. Put your key dates and other critical inputs into the sheet first.
2. Run the checker to catch timeline and math issues.
3. After it clears, run the alimony + child support calculator using those same inputs.

If you want a quick navigation shortcut, you can open the main tool flow from the checker area:
**/tools/alimony-child-support

What outputs you can expect to change

Because this checker focuses on validation, you’ll typically see these effects once errors are corrected:

• Retroactive amounts may shrink or zero out if your prior window exceeded the 2-year general SOL baseline under N.M. Stat. Ann. § 31-1-8.
• Totals may change after fixing frequency/unit mismatches (for example, weekly vs. monthly).
• Line-item distributions may move if alimony/child support fields were swapped or duplicated.

Related reading

• Alimony & Child Support Estimator Guide for Alabama
• Alimony & Child Support Estimator Guide for Arizona
• Alimony & Child Support Estimator Guide for Colorado