Date Formula Editor

Origin

Date: The selections available will vary depending on the type of Date that a formula is being created for. The date formula will start from the Origin Date, then add or subtract days from it.

Add Days: Enter the quantity of days to add to the Origin Date. You can enter a negative or positive value.

Type of Day: Select from 'Calendar Days' or 'Work Days'. 'Work Days' will skip days that are not checked as Workdays under Settings-->Options-->Labor.

Multiplier

Multiplier Type: Configure a Multiplier value that will be multiplied by the Add Days field to get the final amount of days to add to the Origin date.

Flat Rate - Do not multiply: Select this option to use only the value entered in Add Days, essentially setting the 'Multiplier' value to 1

Sum of All Multipliers: When this option is selected, a list of all configured Quantities will be displayed. The Quantities of the Parent object of the Date being calculated will be divided by the values entered here and then the results will be added together to get the Multiplier value.

Max of All Multipliers: When this option is selected, a list of all configured Quantities will be displayed. The Quantities of the Parent object of the Date being calculated will be divided by the values entered here and then the highest absolute value in the results will be used as the Multiplier value.

Per Qty: When this option is selected, a list of all configured Quantities will be displayed. Select a specific Quantity from the list and that Quantity of the Parent object of the Date being calculated will be divided by the value entered and the result will used as the Multiplier value.

Custom Formulas

Enter a VBScript expression that will be evaluated. Either enter a text expression that can be mathematically evaluated, or enter a script containing a Function named Result() without parameters. The function can call other functions. The Result() function will be called to generate the Multiplier value.

To reference a Quantity from the Parent object of the Date being calculated you can type Qty followed by a number (i.e. Qty1, Qty12) or you can use the name of the configured Qty (i.e. Boxes, LF of Ctop).

To reference the Budget Hours for the Parent object you can type BudgetHours<name>.

Acceptable values for 'name' are Department Names or the word Task (i.e. BudgetHours<Finishing>, BudgetHours<Task>).

To use a Budget from an Operation, append a colon and the Operation name to the end of the Department name (i.e. BudgetHours<Finishing:Sanding>).

Using Task is only valid when calculating a Task date and will use the Budget Hours entered for the task.

Example using Text Expression:

(Qty1 + Boxes) / (2 * BudgetHours<Assembly:Sanding>) + BudgetHours<Finishing>

Example using Result() Function:

Function Result()
  If BudgetHours<Engineering> = 0 Then
    Result = 0
  ElseIf BudgetHours<Engineering> < 8 Then
    Result = 1
  Else
    Result = CInt((BudgetHours<Engineering> / 8) - 1)
  End If
End Function

Range Limit

After multiplying the ‘Add Days’ field by the ‘Multiplier’ value, the result will be compared to the Range Limit values and adjusted if it falls outside the range limit before being added to the origin date. Values can be positive or negative.