Click here to view the Estimated Delivery Date menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to Contact contact us.

Introduction

This document

explains how the Estimated Delivery Date is calculated and also shows what tables

we use.

Procedure

Programs

$CWD/progs/ofdemon (update to use tt_ststop table)

$CWD/progs/edd

$CWD/progs/edd_report

Tables

1. The edd_acct table is where each account’s cut-off time is entered. Any job coming in after the cut-off time will start starts counting from the next day.
2. The edd_cal table is where the lab enters what days and hours they work. The days worked can either be Y (full day), H (half day), or N (don’t work).
3. The edd_courier table is where each courier’s pickup time is gets entered. Any job expected after the pickup time will have gets 1 day added to the time.
4. The edd_ctrl table is the control table to find the length of time needed for the lens.
5. The edd_liteups table is where each lite-up is entered gets a length of time needed.
6. The grp_style table is where allows you can to enter a name set with certain specific criteria and use that name set in the edd_ctrl table.
7. The grp_rx table is where allows you can to enter a name set with certain specific criteria and use that name set in the edd_ctrl table.
8. The grp_mat table is where allows you can to enter a name set with certain specific criteria and use that name set in the edd_ctrl table.
9. The grp_color table is where allows you can to enter a name set with certain specific criteria and use that name set in the edd_ctrl table.

Where are the

Menu Options Located?

From the Optifacts main menu:

Select Option 3 – Editor Utilities and press enter.

Select Option 13 - Estimated Delivery Date and press enter.

Here you have two options, either the editor or reports. 

• The editor menu will have has the menus for all of the tables above to use for this project.
• The reports are on the EDD tables only listed above.

Here is how the calculation is done

How the Calculation Gets Done

1. The job gets entered into the system.
2. Take the entered time and compare it against the cut-off time for this account. If the time is under the cut-off time, start counting the days from today.  If the entered time is above the cut-off time, start counting the days from the next day instead of today.
3. If there is NO cut-off time for an account, the program will NOT ‘NOT’ continue to estimate the date.
4. Next, the program will go goes to the edd_liteup table and search . It searches through each lite-up the job has turned on and add adds the appropriate time for each one. It will look looks for a specific account entry first and then try tries account 0‘0’.
5. Then we go to the edd_ctrl control to see what type of job it is. It starts with the highest number first and works it its way down until it finds a match.  It does each eye separately.  Once it finds a match, it looks to see if any lite-ups are in the record.  If there are lite-ups in the entry, and the lite-up is turned on, it will override overrides the value from the edd_liteups table.  If the job it is a split job and the value for each eye is different, the computer will select selects the largest longest time. 

6. Now that we have the time needed, we go to the calendar to find out the date. The program looks at each day to see if the lab works and finds the estimated date

for job

completion.

7. Once the date

gets found, the program puts a record in the job_data table with the date. This record allows you to print the date on the work ticket and invoice.

The edd_liteups table holds, by account ship-to, the amount of time it takes for each lite-up.  The program first looks at the specific account and then falls back to account ‘0’ for any remaining lite-ups.

Image Added

The edd_ctrl table controls the rest of the days/time calculations.  The lens specs lines can contain a group name set for that group table, a specific code (like SV or P for lens styles), or an ‘*’ for all.  The lite-ups section is for exceptions to the edd_liteups table.  You can over-ride a date/time from the edd_liteups table that might take longer because of a particular style of lens.  An example is that a flat-top might take 3 days for Crizal, but a single vision might only take 2 days for Crizal.

Image Added

Image Added

To view and download these instructions as a PDF file, click on the following document image.

Click here to return to the top of the page.