Spreadsheet: 700477d1603204945-determining-how-many-unique-items-across-two-or-more-non-sequential-rows-test-baronvonteabag-
Sheet: WORKSHEET

ESTIMATING/ORDER DATA FORM
CUSTOMER | DAINTY RICE |  | #UP | 8 | BLANK SIZE | 239.8 | X | 348.9 |  | CALIPER | 450
DIE | 11804 |  |  |  | SHEET SIZE | 878 | X | 720 |  | MATERIAL | SBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RUNS (TANDEM OR COMBO)
CUST REF | 350G RICE |  | # OF KINDS |  | Inches of Rule | 1039 |  |  |  | JOBBER SOURCE | MCDERMID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RUN #1 | RUN #2 | RUN #3 | RUN #4 | RUN #5 | RUN #6 | RUN #7 | RUN #8 | RUN #9 | RUN #10 | RUN #11 | RUN #12 | RUN #13 | RUN #14 | RUN #15 |  | TTL SHEETS | # OF RUNS |  |  | COLOUR CHANGES FOR TANDEM RUNS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COLOUR CHANGES FOR COMBO RUNS
ITEM CODE | [NAME] |  | CUSTOMER ID | NEW ITEMS | QTY |  |  |  |  | SPEC1 | SPEC2 | SPEC3 | SPEC4 | SPEC5 | SPEC6 | SPEC7 | SPEC8 | SPEC9 | SPEC10 | SPEC11 | SPEC12 | SPEC13 | SPEC14 | SPEC15 |  | #COLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | new clrs for CTP chrg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | X | 75000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 25000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 50000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 50000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 25000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 37500 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 25000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 12500 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | X | 25000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 75000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 25000 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 12500 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 12500 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 37500 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | X | 12500 | C | M | Y | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
QUANTITIES | PAPER SOURCE | EPICOR PRICE | PRE-PRESS CHARGES |  |  |  | FIXED COST |  | PP CHARGES
500000 |  |  | CTP CHARGE |  | # of New Items |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLTS
 |  |  |  |  | # of Clrs ttl on New |  | PDF | 25 | FUJI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLT CHG
 |  |  | PLATE CHARGE (IF APPLICABLE) |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLR CHG
 |  |  | True |  | Charge if half buried in Estimate
 |  |  | DIE CHARGE |  |  | 1.43 |  | /inch |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | Charge if half buried in Estimate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Combo | 1 | PLATE CHANGES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  | Tandem |  | COLOUR CHANGES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
INSTRUCTIONS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
1 - ENSURE ALL COLOURS ARE INPUT IN SAME ORDER FOR EACH ITEM - HAVE THE ONE-OFF COLOURS LISTED AS LAST COLOUR (USE PMS NUMBER FOR EASE) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
2 - INPUT ALL QUANTITIES BESIDE EACH ITEM BEING ORDERED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
3 - ANY NEW GRAPHICS TYPE IN "NEW" IN SPECIFIC COLUMN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
4 - SORT ENTIRE SHEET BY GREATEST # OF COLOURS TO LEAST (COLUMN N) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
5 -  SKIPPING ITEM #1, TYPE IN # OF COLOUR CHANGES BETWEEN EACH ITEM (BETWEEN ITEM 1 AND 2, THEN 2 AND 3 AND SO ON) IN COLOUR CHANGE COLUMN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
PLATE CHANGES ARE AUTOMATICALLY CALCULATED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
ADDITIONAL CHARGES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
IN GREEN AREAS INPUT DATA (BLANK LENGTH AND WIDTH, FIXED COST RATES AND THE RULE LENGTH) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
DIE, PRINTING PLATES AND CTP COSTS WILL THEN CALCULATE FOR YOU