Tile materials shopping list
WorksheetOrganize confirmed products, quantities and package bases into an editable purchase record.
By Kevin
Plan the material purchase
A shopping list should describe a purchase clearly enough for you and the supplier to check the same thing: the exact product, the complete quantity and the package basis. “Three units” is incomplete when it could mean bags, full grout kits, bottles or cartons.
Use this organizer after the material calculations are complete. It does not estimate quantities or check compatibility. Keep different products, finishes, lots and package sizes on separate lines, even when they serve the same room.
How to use the worksheet
- Enter a project name and identify the exact product or specification in the first field.
- Copy the complete purchase quantity from the relevant calculator. Include the sales unit, such as “9 boxes, 12 tiles per box.” Do not copy an intermediate fractional requirement.
- Use the confirmation field to retain the estimate conditions, supplier product code, batch requirement or another purchase detail that matters.
- Add a separate line for each product and package size. Do not merge a full grout unit with a bag of grout or convert a box count to area without confirmed package information.
- Prepare the text record and compare it with the supplier quote. Copy or print it before leaving; entries are not saved automatically. After any edit, prepare a fresh record.
Build your purchase record
Copy the final purchase quantity from a completed estimate, then record the exact product and package basis. Use separate rows for different products, finishes, lots or package sizes.
Use the confirmation field for the applicable coverage conditions, estimate date, batch requirements or a question to resolve before ordering. Entries remain only in this page; create a text record or print before leaving. JavaScript enables adding rows and preparing text.
Review before placing an order
- Use complete purchase quantities, not rounded display fractions from an intermediate result.
- Retain the package name: 3 full units is not the same as 3 bags or 3 gallons.
- Leave an unresolved quantity blank rather than inventing a default.
- Compare this record with your supplier quote and the confirmed installation material checklist.
Turn a tile calculation into an unambiguous order line
Example inputs
| Input | Value |
|---|---|
| Measured project area | 95 sq ft |
| Tile face dimensions | 12 × 12 in |
| Gap for this arithmetic check | 0 in |
| Elected allowance | 10% |
| Confirmed box contents | 12 tiles |
Calculation steps
- Convert the tile face area: 12 × 12 = 144 sq in; 144 ÷ 144 = 1 sq ft per tile equivalent.
- Divide area by face coverage: 95 ÷ 1 = 95 net tile equivalents.
- Apply the elected allowance once: 95 × (1 + 10 ÷ 100) = 104.5 tile equivalents.
- Round upward for individual pieces: ceil(104.5) = 105 whole tiles. For boxes, use the unrounded demand: 104.5 ÷ 12 = 8.708333…; round upward to 9 boxes.
- Count the contents of complete boxes: 9 × 12 = 108 purchased tiles. The difference from whole-tile demand is 108 − 105 = 3 tiles.
- Enter “9 boxes; 12 tiles per box; 108 tiles total” in the purchase field. Keep the 95 sq ft measured area and example assumptions in the confirmation field. Do not replace the box count with 8.71, the displayed fractional requirement.
Checked result
| Result | Value |
|---|---|
| Product / specification | Example 12 × 12 in tile; supplier product code recorded separately |
| Purchase quantity + package | 9 boxes; 12 tiles per box; 108 tiles total |
| Confirmation / notes | 95 sq ft measured area; elected 10% allowance; zero-gap arithmetic check |
The dimensions and box contents are illustrative inputs, not a claim about a retail product. Zero gap is an arithmetic boundary, not a recommendation to install tile without joints. The current nonzero-gap model is an unverified repeating-area approximation and does not plan cuts. The elected 10% is not a universal waste rate. Displayed decimals use up to two places; purchase rounding uses the unrounded demand.
Start calculatorBefore you order
Use a purchase line that identifies both the quantity and its package. Save the checked record and compare it with the supplier order before paying. Recheck quantities when the product, box contents or installation conditions change; the worksheet does not update them automatically.