
I’ve been traveling for decades, and I’ve always needed a way to keep track of what to pack. My earliest packing lists were handwritten notes. Eventually, they evolved into text files, then Word documents, and finally complex Excel spreadsheets.
Over the years, what began as a simple packing list grew into KTIMS — Ken’s Travel Inventory Management System.
The objective has remained the same: not too little, not too much. Bring everything I need, but avoid carrying things I don’t.
Rather than optimize for price, I’m optimizing for “easy on Ken”. Not minimizing luggage; minimizing the inconvenience of luggage.
It’s Only Socks!
Consider something as simple as socks. How many pairs should I bring? That depends on how long I’ll be traveling, the expected weather, and how often I can do laundry.
But socks aren’t all alike. I have quarter socks, crew socks, and compression socks. Some will be in my checked luggage, some in my carry-on, and one pair will be on my feet.
Now multiply that problem by dozens of other items, each with its own quantity, type, and location.
That’s why I need KTIMS.
One Inventory, Many Trips
I don’t pack for just one trip. In 2026, my travels included Florida, Vermont, and a Mississippi River cruise. Each required a different assortment of clothing and equipment. For Florida: swim suit = 2; wool socks = 0.
Rather than creating a new packing list every time, KTIMS maintains a master inventory of everything I might bring. For each trip, I specify how many of each item I need.
KTIMS is particularly useful on complicated trips. During RTW 2027, I’ll sometimes leave my large suitcase at a hotel while taking smaller bags on side trips. Because everything is organized into Packages, I can rearrange my luggage without unpacking everything. And if my checked suitcase decides to explore the world without me, at least it won’t have taken all of my essentials along for the ride.
How KTIMS Works
KTIMS uses four main Excel worksheets:
- Items: Every item I might pack, with separate quantities for each trip.
- Luggage: Tracks which pieces of luggage accompany me on each portion of each trip.
- Packages: Every item is assigned to one Package, and every Package is assigned to one piece of luggage.
- Totals: Computes the volume used and weight of each piece of luggage for any trip.
Packages are the secret to making the system manageable. By organizing items into Packages that can be moved between pieces of luggage, I can easily adapt to different portions of the trip without constantly packing and repacking.
The Payoff
KTIMS requires a lot of work up front, but for me, that’s part of the fun!
I’d explain how KTIMS works, but neither of us has that much time.
KTIMS is major overkill for the average tourist. But for someone who takes multiple trips every year, often to very different climates, it’s worth the effort.
Besides, some people do crossword puzzles. I organize socks in spreadsheets. I probably spend more time planning than traveling.
The payoff comes on the road. I know what I’ve packed, where to find it, and which luggage goes where. Packing and repacking become routine, with fewer forgotten items and fewer unpleasant surprises.
Lots of planning at home. Fewer surprises away from home.
After all, discovering ancient civilizations is an adventure. Discovering that I’ve forgotten my underwear is not.