Product Engines - More Formulas

In this document we will list some formulas that you can use in your Product Engines in the Quantity Calculation field or the Number Up field.
 

1. # of Cuts - Ceiling((Quantity/#up)/sheets per lift)*# of cuts   

This formula requires knowing the #up, the sheets per lift and the # of cuts. This formula does not work when the engine requires the user to enter Height and Width. 

Example: Item is 8.5x11, runs 2up on 100# Cover and requires 6 cuts. We cut 250 sheets per lift of 100# Cover. 

# of Cuts = Ceiling((Quantity/2)/250)*6  If user enters Quantity of 10,000 this order will require 120 cuts.  Ceiling((10,000/2)/250)*6 = 120 Cuts 

2. Booklets Set 1st Quantity component for total number of books as “Quantity”, set 2nd quantity component for number of text pages as “Q1”. To calculate how much stock for text pages use the following formula -  ((Quantity*Q1)/4) where Quantity is number of books, Q1 is the number of text pages and 4 is the number of pages on press sheet. 

Example: Quantity - 1,000 16pg booklets that run 4pgs per press sheet the total number of press sheets is ((1,000*16)/4) = 4,000 press sheets 

3. Square Feet (Height and Width in Inches) - (Quantity*Height*Width)144

Example: Quantity-10, Height 24", Width 36"  Square Feet = (10*24*36)/144 = 60 Square Feet

4. Square Feet (Height and Width in feet) - Quantity*Height*Width 

Example: Quantity-10, Height 2', Width 3'  Square Feet = 10*2*3 = 60 Square Feet

5. Grommets in each corner – Quantity*4 

Example: Quantity-10  Total Grommets = 10*4 = 40 grommets

6. Grommets every 24” (Height and Width in Inches) (Quantity*(Height*2)+(Width*2))/24 

Example: Quantity-10, Height 24", Width 36"  Total Grommets = (10*(24*2)+(36*2))/24 = 50 Grommets

7. Grommets every 2 feet (Height and Width in Feet) - (Quantity*(Height*2)+(Width*2))/2 

Example: Quantity-10, Height 2', Width 3'  Total Grommets = (10*(2*2)+(3*2))/2 = 50 Grommets

8. Hemming (Height and Width in Inches) – Quantity*((Height*2)+(Width*2))

Example: Quantity-10, Height 24", Width 36"  Hem required = 10*(24*2)+(36*2) = 1200 inches

9. Hemming (Height and Width in Feet) – Quantity*((Height*2)+(Width*2))

Example: Quantity-10, Height 2', Width 3'  Hem required = 10*(2*2)+(3*2) = 100 feet

 

If you have questions or need help, please open a support ticket by selecting this link Aleyant Support