For small GCs & remodelers — on the Microsoft 365 you already pay for

The Employee Master Blueprint

Who is on the payroll right now, what they are certified for, and who they answer to — in one list, not four spreadsheets. No HR system, no new software, no per-seat licence.

What's inside

Every column, every dropdown value and both guardrails, in the order you build them:

• Where it lives — why the list belongs in the channel the crew already
  opens, and what breaks when it sits somewhere else.
• The column spec — every column, its type, and the one you can't delete
  no matter what you call it.
• The three dropdowns — trade, department and supervisor, with the values
  spelled out so two people can't enter the same thing differently.
• The two guardrails — the validation rules that stop a bad date and a
  half-filled row before they are saved, not after.
• Four views, one list — active roster, by department, a photo directory,
  and the people who have left. Same data underneath, four ways to read it.
• Five rules that keep it clean — what to do the day somebody is hired,
  promoted, certified or gone.

Who it's for

Built by JD Steinberger — 30+ years building physical and digital
things, now automating the back office of construction.