A boat's rated capacity is the weight at which it is still technically floating, not the weight at which it still handles. Outfitters work to roughly 75% of the plate figure, and the gap between the two is where swamped boats and bad reviews live. This is a three-cell check that a counter staffer can run while the customer is signing the waiver.
A 500-lb tandem has a 375-lb working limit. Two paddlers at 380 plus 40 of gear is 45 pounds over — a different boat, not a warning.
The example
Three boats going out the same morning, each checked against its own plate rating.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Boat | Rated lb | Paddlers lb | Gear lb | Working limit | Remaining | Status |
| 2 | Solo sit-on-top | 300 | 195 | 25 | 225 | 5 | OK |
| 3 | Tandem sit-in | 500 | 380 | 40 | 375 | -45 | Over limit |
| 4 | Tripping canoe | 800 | 430 | 90 | 600 | 80 | OK |
The formula
Two columns: the working limit, then what is left of it:
How it works
Read it left to right:
B2*0.75is the working limit. The plate rating is a flotation figure from a test tank; at 100% of it a kayak has almost no freeboard and steers like a barge. Three-quarters is the common outfitter rule.C2+D2is everything going in: paddlers, cooler, dry bags, dog, water. Weigh a loaded gear bag once and you will never guess again — they run heavier than anyone expects.E2-(C2+D2)is the headroom in pounds. Positive is fine, small-positive is a conversation, negative is a different boat.IF(F2<0,...)turns the number into a decision the front counter can act on without doing arithmetic in front of a customer.
Keep the 0.75 in its own cell rather than buried in the formula. Colder water, wind, and beginner paddlers all argue for a lower factor, and you want to change it in one place.
Try it: interactive demo
Enter the boat's rated capacity, the combined paddler weight and the gear weight.
Variations
Maximum gear for a known crew
Rearrange to solve for gear instead. Useful when the paddlers are already standing there and the question is what they can bring.
Percent of working limit used
Show the load as a share of the working limit so a 95%-loaded boat looks different from a 40%-loaded one, even though both pass.
Pitfalls & errors
Rated capacity is not a safety limit. Manufacturers publish it as the load at which the hull still floats with a few inches of freeboard — loading to it in moving water is how boats swamp.
Ask for actual weights, not sizes. “Two adults” ranges from 260 lb to 500 lb, and that range is wider than the working limit of most tandems.
Do not forget the boat is already carrying water once it is wet. A canoe with two inches of bilge is carrying 40 lb you never entered into the sheet.
Practice workbook
Frequently asked questions
Is 75% the right working factor?
What about a canoe carrying three people?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class