WEIMI / WORKBOOK HANDOFF NOTES
One calendar date.
Two serial baselines.
A correct-looking column needs an agreed representation and a verified transfer route.
Introduction
A buyer receives a stock workbook, copies a date column into a launch sheet and discovers that the dates have moved by roughly four years. The product names and quantities still agree. It is tempting to replace the dates manually and move on, especially when the vending installation is waiting for its catalogue. That response removes the visible symptom without documenting what crossed the handoff.
Excel supports two date systems with different starting dates. A calendar date can therefore have two legitimate serial numbers. A procurement team needs to distinguish the calendar fact it intends to preserve from the numeric representation that a workbook uses. The equipment discussion should include that distinction whenever a workbook carries stock dates into commissioning.
This guide addresses that workbook boundary. It does not reinterpret best-before or use-by labels, establish a food-safety decision or diagnose a time-zone offset. It also does not claim that a listed vending machine imports Excel files. Request confirmation of the actual data route before writing workbook assumptions into the machine specification.
Quick Answer
Keep the original workbook, establish its date system and the receiving workbook’s system, and record whether the handoff converts underlying values. Compare the resulting calendar dates with an approved reference before data reaches live stock records. A difference of 1,462 days is a diagnostic clue for this specific pair of systems, not a universal repair instruction.
Microsoft gives July 5, 2011 as its teaching example: serial 40729 in the 1900 system and 39267 in the 1904 system. The 1900 serial for the same date is 1,462 greater. Use this published example to explain the baseline relationship; do not present it as a real stock date or a test completed on a WEIMI machine.
Microsoft describes automatic conversion when copying dates from an earlier-version workbook to a newer-version workbook, unless the automatic date-system conversion option is disabled. It separately warns about dates copied as part of a chart. Confirm your actual application, workbook and route instead of assuming every transfer receives the same treatment.
Source reviewed 11 October 2026: Microsoft Support — Date systems in Excel. The acceptance exercises below are proposed procurement work, not reported experiments.
Comparison Table
| Evidence layer |
What to capture |
Acceptance question |
| Calendar reference |
Approved date expressed unambiguously, such as July 5, 2011 in the teaching example |
Did the receiving record preserve the intended day? |
| Source workbook |
Actual 1900 or 1904 setting and original values |
Which baseline interprets this serial? |
| Transfer route |
Copy or other agreed transformation, conversion choice and owner |
Was conversion performed once in the correct direction? |
| Receiving workbook |
System, resulting values and displayed dates |
Do representation and calendar reference agree? |
| Charts or later catalogue |
Separate observed result along the route actually used |
Did a later boundary introduce a new discrepancy? |
A screenshot of a formatted cell answers only part of the question. Pair it with the workbook setting and approved reference. The same printed date can be represented by different values, while the same value interpreted against a different baseline can point to a different day. Retain enough evidence to explain which of those situations your handoff encountered.
Who Should Buy This
This brief suits operators inheriting older stock workbooks, distributors consolidating several supplier sheets and project teams copying stock dates into a commissioning workbook. It is also useful when procurement receives a chart-based stock-age review alongside the actual data table. The buying requirement is dependable date evidence across an agreed route, rather than an extra cabinet feature chosen by name alone.
Invite the stock-data owner, workbook reviewer and receiving-system supplier to the same acceptance discussion. The owner supplies the calendar reference; the reviewer records the workbook baseline; the receiver explains the accepted representation. If nobody owns that chain, a field labelled “date” can travel through several interpretations without a documented decision.
A small installation can use a short signed sample sheet. A multi-site rollout may need a controlled handoff record for each workbook origin. Scale the evidence to the number of distinct routes, not just the number of machines. Repeated copies from one verified route and imports from several unrelated legacy files present different review workloads.
How We Evaluate Smart Vending Machines
The three WEIMI formats below form a procurement shortlist based on public product listings. We have not independently tested their hardware, workbook conversion, date parsing or automatic stock controls. The listing evidence identifies equipment formats worth discussing; it does not demonstrate the data capability needed by this article.
Ask for a demonstration in an isolated project environment using harmless sample records and approved calendar references. Retain copies of the original workbook and receiving sheet. Record the two date-system settings before the transfer, the chosen conversion route and the resulting dates. Have the responsible reviewer compare the results before approving any launch file.
Include more than one agreed sample date so acceptance does not depend on a single cell. The Microsoft example can serve as a teaching reference, while project samples should represent the real column structure. Keep the distinction clear between an explanatory example and a production stock record. No live sale or expiry decision is necessary to establish the workbook representation.
If a chart is part of the purchase review, check it separately. Microsoft’s warning means that a successful copied cell column does not establish that copied chart dates also agree. Finally inspect the date that the eventual catalogue or operator view receives, if that route exists in the quoted solution. Acceptance ends at the actual agreed destination.
Key Buying Factors
Inspect the workbook, not its computer label. Microsoft lists the 1900 system as the default for Windows and specified newer Mac versions, while earlier Mac versions used 1904. A general “Mac file” note is insufficient. Ask for the actual workbook setting and preserve that evidence with the handoff version.
Separate representation from presentation. A date format controls how a reviewer sees a value; the documented conversion adjusts underlying values. Require the supplier to explain what its route receives: a workbook date, a numeric serial or an explicit calendar representation. Do not accept a claim that a nicer display resolves a baseline mismatch.
Declare direction before correction. For the same date, the 1900 serial exceeds the 1904 serial by 1,462. That relationship does not mean every suspicious date should be increased. A conversion in the other direction, an already converted value or a text field demands a different assessment. Document source, destination and operation before approving a transformation.
Keep conversion ownership visible. Name the person or system allowed to convert and record where conversion occurred. A reviewer who fixes a column and a receiver who converts it again can create an unexplained second change. Preserve originals and require a reconciled result rather than allowing each participant to repair its own copy silently.
Version-specific settings need context. Microsoft describes a Windows path through File, Options, Advanced and the workbook calculation area’s Use 1904 date system setting. That is evidence of a workbook-level choice, not an instruction to change every operator’s defaults. Inspect controlled copies under the relevant application guidance; do not alter unrelated workbooks as a commissioning shortcut.
Best Smart Vending Machines
PUBLIC LISTING SHORTLIST / 01
Single-Door AI Vision Smart Fridge for Packaged Drinks
The public listing describes camera-based checkout for packaged goods, five shelf levels with five baskets and a top screen or lightbox. It does not establish workbook date conversion. Despite the wording in the listing URL, this format should not be described here as a machine that prepares fresh juice. Confirm the quoted cooling and physical arrangement.
For a packaged-drink project, ask how the approved calendar date is attached to the correct stock record and which operator view receives it. If dates remain in an external sheet, request a clear external handoff procedure rather than describing an unverified in-machine function.
View public product listing
PUBLIC LISTING SHORTLIST / 02
WM22 Snacks and Drinks Vending Machine
The public WM22 page lists a 21.5-inch touchscreen, inventory management and cooling, with several dispensing arrangements described as options. Confirm whether the quotation uses spiral, conveyor, direct-push or hanging delivery. Those hardware choices do not establish a particular Excel date system or stock-date import process.
For a mixed stock sheet, confirm which columns the receiver accepts and who checks a converted date alongside the intended product. An inventory-management claim is a reason to ask these questions, not proof of a batch-date model. Physical fit and dispensing acceptance still require their own checks.
View public product listing
PUBLIC LISTING SHORTLIST / 03
Two Cabinets, More Choice: Snack & Drink Vending Station
The public two-cabinet listing shows a main display and an additional spiral stock area. It offers a format for a broader snack-and-drink selection. Do not infer shared catalogue software, independently controlled cooling, a second display or date-driven stock blocking from its visible cabinet arrangement.
For a larger selection, require a reconciliation report that keeps date evidence associated with the intended products across the quoted arrangement. Do not let extra physical storage substitute for an agreed record structure. Ask whether any transfer between stock areas changes data ownership or simply changes the physical location.
View public product listing
Feature Comparison
| Format |
Public evidence used |
Date-related quotation request |
| Single-door AI vision fridge |
Packaged-goods camera checkout and shelf arrangement |
Declare the actual stock-data route and calendar-date destination |
| WM22 |
Touchscreen, inventory-management description and dispensing options |
Identify accepted date representation and conversion owner |
| Two-cabinet station |
Main display with additional spiral area |
Explain record association across the quoted cabinet arrangement |
None of the public features above proves Excel workbook conversion, date-based sale inhibition or expiry enforcement. Ask the supplier to quote the required data work explicitly, including any external workbook procedure. A responsible comparison keeps the verified physical format alongside the capability still awaiting a demonstration.
Cost & ROI Analysis
Budget for finding the discrepancy, tracing its origin and reconciling the corrected handoff. Do not assign an invented machine price or claim that a date-system check guarantees a financial return. A sensible estimate separates a one-time review process from ongoing correction work and from the equipment’s wider operating economics.
| Hypothetical assumption |
Calculation |
Illustrative amount |
| Monthly date-reconciliation workload |
6 hours × $30 per hour |
$180 per month |
| Work remaining after an accepted route |
2 hours × $30 per hour |
$60 per month |
| Illustrative reduction in review labour |
$180 − $60 |
$120 per month |
| One-time documentation and acceptance effort |
Assumed project cost |
$480 |
| Simple recovery of that effort |
$480 ÷ $120 |
4 months, if the assumed reduction occurs |
These are assumptions, not WEIMI prices, observed savings or a customer case. They exclude software integration, equipment purchase, subscriptions, taxes and any consequences of stock decisions. They also exclude the time needed to resolve a route that does not support the proposed representation. Replace every input with evidence from your operation before using the example in a buying decision.
Keep the benefit category precise: the example estimates reviewer labour. It does not estimate reduced food waste, increased sales or prevented safety incidents. Those outcomes would need separate measurements and an accepted operating process. Avoid adding several speculative benefits to make a weak conversion project appear profitable.
Best Choice by Scenario
One legacy workbook feeds a new launch sheet: prioritise baseline inspection and a controlled copied-date reconciliation. Choose the cabinet around product format, cooling and delivery needs, then include the documented workbook route as a separate acceptance item.
Several distributors send unrelated sheets: require a source-specific handoff record. A single correction applied to all columns may be wrong because the files can have different systems or may already contain explicit calendar text. Standardise only after the origins are understood.
A purchasing review includes copied charts: retain both the data table and the chart evidence. Resolve the chart date issue separately under Microsoft’s warning. Do not approve the chart solely because the table’s sample cells matched.
The receiving platform accepts calendar text only: have the supplier explain the transformation from the workbook’s values into the agreed representation. The Excel serial relationship still informs diagnosis, but it does not establish the parser contract of that platform. Demonstrate the actual output used by the project.
Applications
An office vending project can use the process when a facilities team inherits a stock spreadsheet from a previous operator. The handoff record should identify which workbook carried the reference dates and which reviewed copy became the launch file. Ownership of the cabinet does not by itself establish ownership of the source data.
A distributor-led rollout can attach baseline evidence to each supplier sheet before consolidating the catalogue. Keep the approved calendar reference available to the person reviewing the consolidated file. Once several sheets are merged, it becomes harder to infer which original interpretation produced a disputed value.
A snack-and-drink station can use the same discipline for dates held outside the machine, provided the external process is clearly specified. Avoid claiming that a cabinet automatically prevents expired stock sales when the evidence only establishes a workbook correction. Operational date control requires its own physical and procedural acceptance.
FAQ
Does a four-year shift prove the date system caused it?
No. It is a reason to inspect the systems and transfer route. Establish the original calendar date, underlying representation and first point of disagreement before assigning a cause. A guessed correction can hide another problem.
Should we add 1,462 to every date column?
No. Microsoft’s relationship describes the same date under two confirmed systems. The direction matters, and a field may already have been converted or may contain text rather than a serial. Preserve originals and validate the relevant conversion in isolation.
Does changing the displayed date format perform the conversion?
The source describes conversion as adjusting underlying values. Acceptance should compare the intended calendar dates and the relevant values, rather than accepting a cosmetic display change as proof.
Can we assume every Mac workbook uses 1904?
No. Microsoft distinguishes older versions from newer versions and lists newer Mac versions with the 1900 default. Inspect the actual workbook instead of inferring the setting from a computer brand.
Do copied charts follow the same conversion route?
Microsoft explicitly warns that dates copied as part of a chart cannot be converted from the 1904 system through that copy conversion and can vary by approximately four years. Include chart evidence as a separate review task if charts are part of the handoff.
Does a corrected serial establish that food is suitable for sale?
No. It only addresses calendar-date representation. Label meaning, storage conditions, stock condition and the operator’s applicable food controls require their own evidence and decisions.
Final Recommendation
Accept the calendar date across the complete agreed route, with the workbook baselines and conversion decision recorded. Use the 1,462-day relationship to investigate a confirmed 1900/1904 mismatch, not to justify an unexplained bulk correction. Preserve the original file and compare the destination against approved references.
Select an AI vision fridge, WM22 or two-cabinet station according to the verified physical format and your actual stocking model. Add date-representation acceptance to the quotation only where that data route is part of the project. Keep workbook conversion, food-date meaning and physical stock decisions as separately evidenced responsibilities.
CTA
Send WEIMI your product formats, intended stock-data route, source workbook context and the calendar-date evidence you expect at handoff. Ask for a quotation that identifies supported functions, external responsibilities and the demonstration needed before launch. Share harmless samples first; a buying brief does not require confidential live stock records.
Get My Custom Quote
