Introduction: Why a Spreadsheet Changes Everything

If you have ever lost track of what you paid for a purchase, forgotten which size you ordered, or struggled to explain to an agent exactly what you wanted, a spreadsheet is the simplest fix available. The CAFANS approach treats the spreadsheet not as a boring grid but as a personal control panel for every purchase you make. In this guide, we will walk through the main spreadsheet workflow, then expand into the shopping spreadsheet, the product comparison spreadsheet, and the agent shopping spreadsheet. Along the way, we will define thirty related terms and show how each one fits naturally into everyday use.

Part 1: The Main Spreadsheet as Your Foundation

Every CAFANS workflow starts with one master file. Call it the main spreadsheet. This is where you store the core record: item name, category, price, currency, quantity, seller, order date, tracking number, and status. Keep the layout stable. Use one row per item and one column per attribute. Format the header row with bold text and a frozen pane so it stays visible while you scroll. Add a few helper columns: a total cost column, a paid column, and a received column. A simple data validation dropdown for status values—planned, ordered, shipped, received, returned—prevents typos and makes filtering reliable.

The main spreadsheet should also hold a small settings block. Put the exchange rate in a single cell and reference it in formulas rather than hard-coding numbers. When the rate changes, update one cell and every converted price recalculates. This is the difference between a static list and a living document.

Part 2: The Shopping Spreadsheet

The shopping spreadsheet is the working layer where decisions happen. Unlike the main spreadsheet, which records facts, the shopping spreadsheet captures intent. Use it for a wishlist, a budget planner, or a seasonal buying plan. Include columns for priority, target price, maximum acceptable price, and a notes field for color or size preferences.

A useful technique is the priority score. Combine a subjective rating with a calculated value, such as price divided by usefulness. Sort by score to decide what to buy first. Keep a separate tab for each season or project so the file does not become unwieldy. This tab structure keeps the shopping spreadsheet readable while the main spreadsheet remains the single source of truth.

Part 3: The Product Comparison Spreadsheet

When two or more options compete, switch to a product comparison spreadsheet. The goal is structured comparison, not endless browsing. Create a comparison matrix with products as columns and criteria as rows: price, shipping cost, warranty, material, dimensions, weight, return policy, and seller rating.

Normalize the data before comparing. Convert all prices to one currency, all weights to one unit, and all dimensions to the same scale. Then add a weighted scoring row. Assign weights to criteria based on what matters most, multiply each score by its weight, and sum the result. A product comparison spreadsheet turns a vague feeling into a defensible choice. It also documents why you rejected an option, which is invaluable when you revisit the decision later.

Part 4: The Agent Shopping Spreadsheet

Buying through an agent adds steps: quotation, domestic shipping, warehouse consolidation, international shipping, and customs. The agent shopping spreadsheet exists to track all of it. Add columns for agent name, quote number, domestic tracking, warehouse arrival date, parcel weight, volumetric weight, shipping line, and service fee.

The most important column is the consolidated cost per item. When several items share one international parcel, allocate the shipping fee by weight or by value. Use a formula so the allocation updates automatically. Also track the agent's response time and any quality-check photos. An agent shopping spreadsheet is not just a cost tracker; it is a service record that helps you decide whether to reuse the same agent next time.

Part 5: Practical Spreadsheet Guide

This spreadsheet guide distills the habits that keep files useful.

  • Use consistent naming for tabs, columns, and status values.
  • Freeze header rows and add filters to every table.
  • Separate raw data from calculations and from summaries.
  • Reference single cells for rates and fees instead of typing numbers.
  • Color-code by status, but never rely on color alone.
  • Keep a change log tab with dates and short notes.
  • Back up the file weekly and export a CSV snapshot monthly.

Apply these rules to all four files and the system stays maintainable even as it grows.

Part 6: Thirty Related Terms

Here are thirty terms used throughout this guide, each with a short working definition.

  1. Main spreadsheet — the master record of all purchases.
  2. Shopping spreadsheet — the planning layer for wishlists and budgets.
  3. Product comparison spreadsheet — a matrix for evaluating options.
  4. Agent shopping spreadsheet — a tracker for agent-mediated orders.
  5. Spreadsheet guide — documented best practices for file use.
  6. Workbook — the file containing multiple sheets.
  7. Worksheet — a single tab inside the workbook.
  8. Cell reference — an address such as B4 used in formulas.
  9. Formula — a calculation beginning with an equals sign.
  10. Function — a built-in operation such as SUM or VLOOKUP.
  11. Data validation — a rule restricting allowed entries.
  12. Dropdown list — a picker created through validation.
  13. Filter — a temporary view that hides non-matching rows.
  14. Sort — reordering rows by a column value.
  15. Frozen pane — a locked header area that stays visible.
  16. Conditional formatting — automatic styling based on rules.
  17. Pivot table — a summary that groups and aggregates data.
  18. Named range — a label that refers to a cell range.
  19. Absolute reference — a fixed reference using dollar signs.
  20. Relative reference — a reference that shifts when copied.
  21. Lookup table — a reference table used to retrieve values.
  22. Weighted score — a total where criteria carry different weights.
  23. Exchange rate cell — a single cell holding currency conversion.
  24. Budget planner — a sheet for planned versus actual spend.
  25. Wishlist — a list of desired items with priorities.
  26. Tracking number — a carrier identifier for a shipment.
  27. Consolidation — combining parcels at a warehouse.
  28. Volumetric weight — a shipping weight based on dimensions.
  29. Change log — a dated record of edits and decisions.
  30. CSV export — a plain-text snapshot for backup.

Conclusion

The CAFANS method is simple: one main spreadsheet for facts, a shopping spreadsheet for intent, a product comparison spreadsheet for decisions, and an agent shopping spreadsheet for logistics. Follow the spreadsheet guide habits, and the thirty terms above become second nature. Start with a single tab today, and let the structure grow with your needs.