How to use Caffeine Intake Worksheet
- Replace the sample Products with the names, milligrams per serving and serving labels you have. Use one product name per row; names are matched without case.
- Leave Caffeine mg per serving empty when the amount is unknown. Enter 0 only when you intend a known zero; an empty cell is never counted as zero.
- Under Consumption events, enter the calendar date, 24-hour time, matching product name and number of those servings consumed. For half a labeled serving, enter 0.5.
- Select Total entered caffeine. Review the daily known milligram subtotal and unknown-entry count together. Missing amounts make the known total partial.
- Download caffeine-intake-worksheet.csv for event-level data or its PDF for daily and event tables. Save the JSON project to restore both editable lists later.
Example: Caffeine Intake Worksheet
Total one sample 200 mg bottle and two sample 30 mg cups: 200 + 2 × 30 = 260 mg. These are entered examples, not typical caffeine values for all drinks of those types.
Options
- Editable fields
- Products: Product name, Caffeine mg per serving (optional), Serving label (optional). Consumption events: Date, Time, Product, Servings. Add or remove these records with the labeled controls; each new row starts blank.
- Advanced raw input
- Products use three tab-separated cells: name, milligrams per serving and optional serving label. Events use four: date, time, product and servings. Keep empty cells when a value is unknown or a label is omitted.
- Label amounts
- Milligrams refer to the serving description you supplied. There is no product database or estimate for an unknown product.
- Fractional consumption
- A fraction scales the supplied amount. It does not apply a personal safety threshold or metabolism model.
Supported inputs and limits
- Use up to 200 product rows and 200 event rows, with 100,000 characters allowed in each dataset.
- Product names allow 80 characters and serving labels 60.
- A supplied amount ranges from 0 to 5,000 mg per serving; consumed servings from 0.01 to 1,000.
- These are accepted input ranges, not recommended intakes.
- Event amounts and known subtotals are rounded to three decimal places.
More details
Times order entries within their written calendar dates; there is no time-zone conversion, elimination/half-life estimate or bedtime prediction.
Unknown amounts remain separate from known zero values.
No product database, intake limit or personal safety assessment is applied.
Entries stay in this browser without automatic saving or upload.
Save the JSON project to continue later; imports are limited to 100,000 bytes and characters.
Saved files contain the entered details, and PDF text uses the supported standard-font character set.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
A known subtotal can omit unknown entries
Each consumption event scales the supplied milligrams per serving. If a product has no entered caffeine amount, its contribution stays unknown instead of becoming zero. The known daily subtotal therefore does not prove complete intake. No product database, metabolism estimate or personal safety threshold is used.
Questions about Caffeine Intake Worksheet
Does the worksheet tell me a safe amount?
No. It totals entered values without recommending a dose, applying a safety limit or assessing pregnancy or medical circumstances.
What if a label does not state caffeine?
Leave its amount empty. Events using that product remain unknown and are counted separately from the known subtotal.
Can I record half a serving?
Yes. Enter the fraction consumed and keep the serving description consistent with the supplied milligram value.