Lot code and Julian date generator
Quick help
Generate a date-based internal code using a prefix, YYYYDDD (year plus day of year) and your batch suffix. Here Julian means ordinal day, not astronomical Julian date. You must choose a unique suffix; uniqueness and traceability are not verified.
- Enter your numbers or replace the example rows.
- Prepare and review the result and formula.
- Download, print or export a draft before closing.
What it does not do: No cloud sync, automatic orders, certification or professional advice.
Generate a date-based internal code using a prefix, YYYYDDD (year plus day of year) and your batch suffix. Here Julian means ordinal day, not astronomical Julian date. You must choose a unique suffix; uniqueness and traceability are not verified.
One currency per worksheet. CSV has a header and up to 10,000 rows; previews show 100, downloads include all. CSV downloads prefix potential spreadsheet formulas with an apostrophe. Calculated values display up to six decimal places; totals use unrounded intermediate values. Examples are fictional inputs, not recommended rates.
Import is kept in this page's memory. The original profile file is unchanged.
Preview / results
Enter your details on the left to prepare your result.