December 3rd. The outdoor lights from last year are in three separate bins in the basement. You know roughly where the front yard wireframe deer went. You have a mental picture of what the foyer garland looked like, but the specific product you bought for the garland hangers — the ones that gripped the bannister without scratching — is gone from memory. And next weekend you need to reproduce something close to what worked last year.
Without a record, you start from zero every year. Not entirely from zero — you remember the broad strokes — but all the implementation details that actually determined whether it looked right are gone. Which lights worked on the front gutter run and which burned out midway through January. What length of garland you needed for the stair rail. Whether the wreath you bought was the right diameter for the front door frame or whether it needed to be two inches larger.
The Location Grid as Organizational Layer
Environment (Interior vs. Exterior), Category (Lights, Ornaments, Garland, Tree, Wreath), and Orientation (Living Room, Foyer, Front of House, Front Yard, Fence, and five others) form a three-axis classification system for each decoration plan.
Filtering by Environment = Exterior gives you every outdoor installation. Filtering further by Category = Lights narrows to the exterior lighting plan specifically. You can see the front gutter run entry, the fence outline entry, and the front yard accent lighting entry as separate records, each with their own Material List and Shopping List, each with their own project photos from the previous year.
This is the record you look at when you are standing in the lighting aisle at Home Depot trying to remember whether you used C7 or C9 bulbs on the roofline. The photo from last year's Orientation = Front of House, Category = Lights record shows you exactly what bulb style and spacing you used, and the Material List tells you how many strands you needed.
The Four-Photo Documentation System
Each record holds four project images with independent description fields. This is enough to document: pre-installation state, in-progress, completed installation, and a detail shot of the specific connection or attachment method that is always the part you forget.
The Foyer garland record with Image 1 showing the banister, Image 2 showing the garland attached at mid-span, Image 3 showing the completed run at full height, and Image 4 showing the specific clip style used — that four-image sequence means next year you can reproduce the installation without reverse-engineering the original process. The Image Description fields anchor what each photo shows, so you are not guessing which stage of installation a photograph captures.
Materials Needed as the Pre-Season Checklist
The Materials Needed flag — Yes or No — is the inventory status field that drives the Shopping List.
In November, open the database and filter Materials Needed = Yes. Every record where existing materials are insufficient, missing, or need replacement appears in the filtered list. That is your pre-season shopping list, already organized by location and category. You are not making a separate list from scratch — you are reading the flag you set when you packed the decorations away in January and noted that the living room wreath lights had failed.
The Shopping List field on each record is distinct from the Material List. Material List is what you own and are using. Shopping List is what you need to acquire. Keeping them separate means the shopping trip to the store does not require cross-referencing the inventory with the gaps.
The Description field is where the design intent lives: "front yard deer facing toward the house with spotlight from left, warm white LED only, no colored lights in front yard." That captures the aesthetic decision that makes next year's installation look intentional rather than improvised.