Spreadsheet checks before running Alimony Child Support in Vermont

What the checker catches

Before you calculate alimony or child support in Vermont, DocketMath’s Spreadsheet checker helps you avoid spreadsheet errors that can cascade into incorrect results from the alimony-child-support calculator. This is especially useful when your Vermont sheet combines multiple income lines, shared expenses, and custody/child allocation inputs.

Here are the kinds of issues the checker is designed to catch before you run the Vermont calculation:

• Missing or blank required fields

  • Examples: annual gross income left empty for one parent, or the number of children not specified.
• Inconsistent time basis

  • Examples: one parent’s income entered as “monthly” while another is entered as “yearly,” or child-related expenses entered per month but treated as per year.
• Negative values where numbers should be non-negative

  • Examples: “net income” accidentally entered with a minus sign, or a deduction field left with an explanatory label converted into a number.
• Mismatched currency/units

  • Examples: entering “taxes withheld” as a percent but typing it into a dollar field (or vice versa).
• Formula drift

  • Examples: one row’s formula references a different column than the rest of the sheet, causing totals to be computed incorrectly.
• Custody-related toggles not aligned

  • Examples: you select a custody timing option but forget to adjust child-days or percentage inputs that the spreadsheet uses elsewhere.
• Rounding and precision errors

  • Examples: truncating decimals early so that downstream “difference” calculations become materially off.
• Data validity across the spreadsheet

  • Examples: a child count of 0 paired with child-specific inputs still filled in (which can lead to misleading totals).

Quick checklist of inputs the checker typically guards

Use this as a preflight pass:

When to run it

Run the checker before you run the alimony-child-support calculator, and again after any spreadsheet edits that change upstream inputs.

A practical Vermont workflow:

1. Create or open your spreadsheet
2. Run the DocketMath Spreadsheet checker
3. Fix flagged issues
4. Then run the DocketMath alimony-child-support calculator
5. After edits, re-run the checker (especially after changing income, custody inputs, or the number of children)

Timing that matters in Vermont: consider the general lookback window

Vermont has a general statute of limitations (SOL) period of 1 year. The jurisdiction data provided did not identify a claim-type-specific sub-rule, so the 1-year general/default period should be treated as the default for this scheduling/record-keeping note.

• General SOL Period: 1 years
• Source: https://legislature.vermont.gov/Documents/2020/Docs/CALENDAR/hc200226.pdf

What this means operationally: if your spreadsheet is used to compare scenarios across time (e.g., different income snapshots or custody arrangements), align your audit trail and saved inputs to a 1-year general window so you can reproduce the numbers that produced your results.

Run it in these high-risk moments

• When you migrate numbers into a new sheet
• After you reformat income (monthly → annual or annual → monthly)
• When you change custody-related selections or child allocation assumptions
• After you copy/paste rows and formulas into a new period

Try the checker

You can use DocketMath’s alimony-child-support workflow with jurisdiction-aware rules for Vermont (US-VT).

Upload the spreadsheet, review the warnings, and then run the calculation once the inputs are clean: Try the checker.

Primary CTA: run the calculator with the checker

Go directly to: **/tools/alimony-child-support

What to do inside the tool

1. Open /tools/alimony-child-support
2. Paste or enter your spreadsheet inputs (as supported by the tool)
3. Run the Spreadsheet checker step first
4. Review each flagged issue
5. Only after the sheet passes, run the Vermont calculation

How outputs change when inputs are corrected

The calculator output is chained arithmetic—so when the checker catches and you fix an issue, results can change in predictable ways:

• Unit corrections (monthly ↔ annual) often produce the biggest shifts in totals
• Blank field fixes prevent undercounting or overcounting from partial/ignored inputs
• Custody input alignment fixes affect distribution logic tied to child-related computations
• Rounding/precision fixes can shift results enough to change a payment comparison

Simple example of a common correction

• If one income is entered as $4,000 monthly and the other as $48,000 yearly, the numbers are not comparable.
• After you correct the time basis so both are annual, the calculated results typically shift substantially because the tool is applying Vermont computation logic to consistent time-based income.

If you want a faster path to cleaner calculations, treat the checker as a mandatory pre-run gate, not an optional review.

Related reading

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