Spreadsheet checks before running attorney fee calculations in Rhode Island

What the checker catches

Before you run DocketMath’s attorney-fee calculator, run a “spreadsheet sanity check” on your inputs. Fee spreadsheets fail most often in places that look small—an off-by-one date, a stray rounding step, or a category column that doesn’t match the billing format.

Here’s what the checker should catch in a Rhode Island attorney-fee workflow, with a focus on the numbers that drive the final amount.

1) Time leakage and date alignment

Common issues:

• Start/end dates entered in the wrong order (negative durations “fixed” by an absolute value).
• Hours calculated using the wrong day-count assumption (calendar days vs. business days).
• A missing “partial day” rule (e.g., treating a 15-minute entry as 0.25 vs. 0.1).

Checklist:

2) Rates and multipliers applied to the wrong column

Fee spreadsheets often include multiple rate fields (e.g., hourly rate, paralegal rate, blended rate, “enhancement” multiplier). Mistakes include:

• Rate applied to the wrong role column.
• Multiplier applied before rounding (or after), changing totals.
• Percent multipliers accidentally formatted as decimals (e.g., 10 entered as “10” instead of “0.10”).

Checklist:

3) Rounding drift (the quietest error)

A spreadsheet can look correct per-row but be wrong in totals due to rounding at intermediate steps.

Common patterns:

• Each line rounded to 2 decimals, then summed, producing a different total than summing raw minutes then rounding once.
• One tab rounds differently than another tab.

Checklist:

• Sum of rounded line amounts
• Round the unrounded total
• If the gap is meaningful (e.g., > $5–$10 on a small sample), revisit the rounding step.

4) Category mapping and exclusions

Attorney-fee spreadsheets frequently separate:

• compensable time vs. non-compensable time
• expenses vs. time
• professional vs. clerical work (or other internal categories)

Pitfall:

Checklist:

5) Deadline sensitivity using Rhode Island’s general default limitations period

Rhode Island’s general/default limitations period in this area is 1 year under General Laws § 12-12-17. This is the general period; no claim-type-specific sub-rule was found in the provided material, so treat 1 year as the default.

Why that matters for spreadsheets:

• If your spreadsheet includes “eligible” time windows, your date filter should align to a 1-year lookback from the controlling date you use in your internal workflow.
• If you’re using a limitations window to include/exclude billing entries, the inclusion boundary date must be consistent.

Source: General Laws § 12-12-17 (Rhode Island)
https://codes.findlaw.com/ri/title-12-criminal-procedure/ri-gen-laws-sect-12-12-17/

When to run it

Run the checker before you push numbers into DocketMath’s attorney-fee tool, and again after you export or copy values into the calculator input screen.

A practical timing plan:

1. After you import billing rows

   • Validate date fields, durations, and role/category mapping immediately.
2. After you set rates and multipliers

   • Confirm every multiplier is tied to the correct column and not accidentally inherited from an earlier worksheet version.
3. Right before the calculator run

   • Re-check rounding and subtotal references because copy/paste can break formulas or hardcode values.
4. After the calculator output comes back

   • Compare the calculator’s total to your spreadsheet total within a tolerance you choose (commonly 0.5% or a fixed dollar threshold).

Use a “tolerance test”:

• rounding strategy mismatch
• range reference mismatch
• wrong units (hours vs. minutes)
• expenses included twice

Try the checker

Use DocketMath’s attorney-fee flow as the final validation step—after your spreadsheet inputs pass the sanity checks above.

• Start here: ** /tools/attorney-fee
• Then follow this quick, repeatable sequence:

If DocketMath’s output differs, don’t “average it out”—trace the delta. The most common culprits are:

• one tab rounding differently,
• an expense range included twice,
• or a column shift where rate multipliers no longer match the intended role.

Here’s a compact “input-to-output” map you can use while checking:

Related reading

• Worked example: attorney fee calculations in Vermont — Worked example with real statute citations
• Attorney Fees Guide for Alaska
• Attorney Fees Guide for American Samoa