Barycentric Solutions Contact

Portfolio

Show, don't tell.

Four samples, built the way we build client work: understand the question first, then the data, then the fix. Each starts from public data, a public document or made-up names, and every figure ties back to its source. Where we can't show the number, we don't claim it.

Case study · Spreadsheet cleanup

243 rows in.
243 rows out.
Not one lost.

1 / 3

It arrived as text.

A public crop download: numbers with commas, the hay type jammed into a long label, six columns empty in every row. You can't add it up, and you can't ask it anything.

The question: how much hay came from each county, and how did that change by year?

Before and after: the download's rows beside the same rows with tons as numbers and the hay type in its own column
View full size of: Before and after: the download's rows beside the same rows with tons as numbers and the hay type in its own column
2 / 3

We pulled it apart.

Text became numbers. The hay type got its own column. The empty columns came out, and the guide tab says so. Every change went into a log.

12,384,600

tons in the download, and the same 12,384,600 in the workbook.

The answer tab: tons of all hay by year and the top five counties
View full size of: The answer tab: tons of all hay by year and the top five counties
3 / 3

Now it answers a question.

Tons by county and year, on one tab, with the top five counties and every total tied back to the data. The original download stays untouched beside it.

  • Public data
  • Excel
  • Checked line by line

Source: USDA NASS Quick Stats, Pennsylvania hay by county (public domain).

Three more

Before and after: raw export rows beside the tenant ledger, a possible duplicate flagged
View full size of: Before and after: raw export rows beside the tenant ledger, a possible duplicate flagged
January to June by property, and Schedule E for all three properties
View full size of: January to June by property, and Schedule E for all three properties
3,225values checked one by one

Property books

One flat ledger, rebuilt into books an owner can read.

339 rows in. 3 duplicates flagged and removed. Every one logged.

  • Made-up names
  • Excel
  • Tied to the cent

One flat export: rent as a credit, a payment entered twice under two spellings, dates typed as text. The rebuild splits it into tenant, expense, deposit and owner ledgers, with Schedule E lines tied to the export to the cent.

How it was built
  • Split one flat ledger into tenant, expense, deposit and owner ledgers
  • Added a rent roll, a dashboard, an owner report and Schedule E views
  • Converted text dates and amounts to real dates and numbers
  • Checked: 336 rows kept; 3,225 values compared against the export; 44 Schedule E cells tie back to the ledgers

Every tenant, property and amount is invented.

Before and after: loss notes as typed, and the same notes with notice deadlines worked out
View full size of: Before and after: loss notes as typed, and the same notes with notice deadlines worked out
Revenue less seed, plugs and supplies for the 2026 season, by crop
View full size of: Revenue less seed, plugs and supplies for the 2026 season, by crop
4 → 1loose sheets, one file

Farm records

Four loose farm sheets, rebuilt into records that answer questions.

Margin per crop. Loss-notice deadlines. One file.

  • Made-up farm
  • Excel
  • Schedule F by tax year

Field names written three ways, a date typed as text, “no” where a date belongs. The rebuild joins four loose sheets into records that show margin per crop, Schedule F by tax year, and every loss-notice deadline.

How it was built
  • Rebuilt four loose sheets as seven logs, joined by one planting ID
  • Added crop and field summaries and Schedule F by tax year
  • Mapped field names to one field ID and set one unit per crop
  • Checked: 36 sales rows kept and 2 exact duplicates removed; inputs tie to the before file

Record types follow the public USDA FSA program fact sheet; the farm is invented.

Before and after: the brochure's opening beside the rewrite's two-sentence opening
View full size of: Before and after: the brochure's opening beside the rewrite's two-sentence opening
Rights in your apartment, before and after
View full size of: Rights in your apartment, before and after
0rights dropped

Plain-language rewrite

A government brochure, rewritten so a tenant reads it in one pass.

The main point first. Every right kept.

  • Public document
  • Rewrite
  • Checked line by line

The original opens with a paragraph about who distributes it. The rewrite opens with what the tenant needs to know, in two sentences, then lays the same rights out one plain idea at a time.

How it was built
  • The main point goes first, in two sentences
  • Long sentences split into one idea each; terms explained where they appear
  • Every phone number, year and web address checked against the original
  • Requirement words compared line by line with the original

Source: a public HUD brochure. Not a HUD publication.

Samples are built from public data or made-up names. They are not legal, tax or accounting advice. Client work appears here only with the client's written yes, and never with their personal details.

Have a sheet, a document or a Monday-morning job that keeps breaking? Tell us what it is. If the fix isn't us, we'll say so. Start with one message.