CANDLE BATCH-TESTING LOG

CANDLE BATCH-TESTING LOG

Turn every candle test into a useful, traceable business record.

The Candle Batch-Testing Log helps candle makers document production batches, record controlled burn-test observations, track component lot numbers, and organize release, retest, or rejection decisions—all in one editable workbook.

Designed for small-batch makers who want a more consistent testing process, this spreadsheet connects each production batch to its individual burn cycles and automatically summarizes testing activity on an easy-to-read dashboard.

WHAT’S INCLUDED

• Start Here guide with instructions and a color-coded input key
• Production Batch Log with space for up to 100 batches
• Burn Test Log with space for up to 100 test cycles
• Automatic burn-hour calculations
• Batch-status dropdowns
• Burn-cycle result dropdowns
• Release, retest, rejected, and in-progress tracking
• Automatic testing dashboard
• Testing-activity summary
• Review queue for batches requiring attention
• Sample entries showing how the workbook works

DOCUMENT THE DETAILS

Record the information that helps make every batch traceable:

• Batch ID and pour date
• Product or fragrance name
• Vessel style
• Wax type and supplier lot
• Fragrance and fragrance load
• Fragrance lot number
• Wick type, size, and lot number
• Batch size and fill weight
• Cure date
• Tester and batch status
• Test-cycle dates and times
• Flame height and melt-pool measurements
• Vessel and room temperatures
• Wick position
• Smoke or soot observations
• Test results and stop reasons

AUTOMATIC DASHBOARD

The dashboard updates as information is entered, providing an at-a-glance view of:

• Total batches recorded
• Released batches
• Batches requiring retesting
• Rejected batches
• Burn cycles completed
• Average recorded burn time
• Highest recorded vessel temperature
• Open review items

EASY TO CUSTOMIZE

Replace the included sample entries with your own information and continue adding records as you pour and test.

Editable cells are color-coded, formulas calculate automatically, and dropdown menus help keep testing terminology consistent across the workbook.

FILE FORMAT

• One editable Microsoft Excel workbook
• Four organized worksheet tabs
• Compatible with Microsoft Excel
• Can be uploaded to Google Drive and opened in Google Sheets
• Minor formatting or chart differences may occur in Google Sheets

PERFECT FOR

• Small-batch candle makers
• Refillable-candle businesses
• Vintage-vessel candle makers
• New candle businesses
• Market and booth vendors
• Makers developing a documented testing process

IMPORTANT SAFETY NOTICE

This workbook is an educational recordkeeping and planning tool. It does not certify that a candle, vessel, wick, fragrance, formula, or refill process is safe.

Test the exact vessel, wax, fragrance load, dye, wick, fill weight, and production process you intend to sell. Follow current supplier instructions, applicable candle-safety standards, labeling requirements, insurance requirements, and professional guidance.

Stop and quarantine any test showing cracking, leaking, instability, flame contact, wick migration, flashover, secondary ignition, excessive soot, or other abnormal behavior. Never leave a burning test candle unattended.

DIGITAL PRODUCT

This is a digital download. No physical product will be shipped.

The workbook may be used repeatedly within the purchaser’s own business. It may not be resold, shared, redistributed, or reproduced as a competing digital product.