Spreadsheet: 194918d1353357653-solved-sum-cells-based-on-color-s-2012-1119
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT DELETE!!!! | Y | P | N
Cherry Creek Production Schedule
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Deadlines |  |  | Financial Tracking |  |  |  |  |  |  | Paint Tracking |  |  |  |  |  |  | Invoicing |  |  |  |  |  | Outsource Payments Due Within 10 Days of Today
Order # | Customer | Co # | Released | Range | Paint | Install | Delivery | Products | Supplier | Stick | [NAME] | Cutlisted | Location/Notes | ETA | Ship By | Install Date | Shop Price | Shop Done | Paint Price | Install Price | [NAME] Cost | Outsource Our Cost |  | Order # | Customer | Paint Received | Type | Contacted? | Ship Date |  | Order # | Customer | Invoiced? | Payment Received? | Notes |  | Order # | Customer | Estimated Payment Date | Estimated Amount Due | Has [NAME]?
7404 | REIMNITZ | 1 | 2012-09-28 00:00:00 | 1-2, | N | N | N | GLASS (3) | TG | NA | C | X | AT SR | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 |  |  |  |  |  | 375 | 375 |  |  |  |  |  |  |  |  |  |  |  |  | ASK ERIK
6026R1 | SIMPSON | 1 | 2012-10-10 00:00:00 |  | N | Y | Y | [NAME] (1) | CC | NA | LL | X |  |  | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | NO CHARGES
7433 | LOVELL | 3 | 2012-10-24 00:00:00 |  | N | Y | Y | GLASS (1) | TG | NA | C | X |  | 2012-10-02 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEE CC & OUTSOURCE
2079-R1R2 | BURKHOLDER | 1 | 2012-10-19 00:00:00 | 4-6, | N | Y | Y | GLASS (12), [NAME] (1) | TG | NA | C | X |  | 2012-10-02 00:00:00 | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 596 |  |  |  |  | 433.58 |  |  |  |  |  |  |  |  |  |  |  |  | SEE CC & OUTSOURCE
7235 | CARLSON | 2 | 2012-11-09 00:00:00 |  | N | Y | Y | GLASS (1) | BUFF | NA | C | X |  | 2012-10-02 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 |  |  |  |  |  | 20.45
6172R1 | ANDREWS | 1 | 2012-11-01 00:00:00 | 2-3, | N | Y | Y | GLASS (9) | TG | NA | C | X |  | 2012-11-19 00:00:00 | 2012-11-30 00:00:00 |  |  |  |  |  |  | 422.59
7481 | SOUND WOODWORKS | 1 | 2012-11-12 00:00:00 | 1-2 DAYS | N | N | N | GLASS SG(4) | CC | NA | C | X |  |  | 2012-11-14 00:00:00 |  | 0 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
7250 | [NAME] | 1 | 2012-05-29 00:00:00 | 616 | Y | Y |  | STORM (16, ST DOOR (1), [NAME] (1) | CC | OG | C | X | AT SR |  | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 0 | 5954 |  |  |  |  |  |  |  | Y |  |  | DONE |  |  |  | Y
7115 | KIMBALL | 2 | 2012-07-26 00:00:00 | 4-6, | N | Y |  | DS DH (2) | CC | OLAY | C | X | AT SR |  |  |  | 0 | 1328 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DISREGARD
7377 | [NAME] | 1 | 2012-09-12 00:00:00 | 4-6, | N | Y |  | STORM (6) | CC | NA | C | X | NOT INSTALLED |  |  | 2012-11-19 00:00:00 | 0 | 4206 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | PARTIAL | RECEIVED FOR PRODUCT
7230 | GOLDEN | 2 | 2012-08-28 00:00:00 | 4-6, | Y | Y |  | DS DH (2), MISC | CC | OLAY | C | X | AT CUSTOMERS HOME |  | 2012-11-01 00:00:00 | 2012-11-28 00:00:00 | 0 | 1897 |  |  |  |  |  |  |  | Y |  |  | DONE |  |  |  | Y | PARTIAL | RECEIVED FOR PRODUCT
7411 | PETERSON WEATHER | 2 | 2012-09-20 00:00:00 | 3-4, | Y | N |  | STORM (4) | CC | NA | NA | X | NEED TO GO BACK TO FACTORY |  | 2012-11-25 00:00:00 |  | 200 | 998 | 480 |  |  |  |  |  |  | Y | CANS |  |  |  |  |  |  |  | PAINT ADDED IN CO#2
7407 | MARTIN | 1 | 2012-10-02 00:00:00 | 4-6, | N | N |  | 4900 SH (1) | CC | OG | LL | X | WIP |  | 2012-11-14 00:00:00 |  | 1023 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
7426 | CRICHTON | 1 | 2012-10-02 00:00:00 | 4-6, | Y | Y |  | STORM (4) | CC | NA | C | X | IN PAINT |  | DONE | DONE | 0 | 860 |  |  |  |  |  |  |  | Y |  |  | DONE |  |  |  | Y
7417 | SCHULTZ MILL-MOGA | 1 | 2012-09-25 00:00:00 | 4-6, | Y | Y |  | ST DOOR (3) | CC | NA | C | X | IN PAINT |  | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 1740 | 0 |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | Y
7388 | GILLETTE | 5 | 2012-09-17 00:00:00 | 6-8, | Y | Y |  | SO (20) | CC | OG | LLC | X | IN PAINT |  | 2012-11-09 00:00:00 | 2012-11-12 00:00:00 | 30492 | 0 |  |  |  |  |  |  |  | Y |  |  | DONE |  |  |  | Y | Y
7427 | HOLLINSWORTH | 1 | 2012-10-05 00:00:00 | 4-6, | N | N |  | SL (2) | CC,BUFF | NA | NA | X | SL'S FROM BUFF, CC GLASS | 2012-11-11 00:00:00 |  |  | 1598 | 0 |  |  |  | 394 |  |  |  |  |  |  |  |  |  |  | Y
7430 | LILLYBRIDGE | 2 | 2012-10-08 00:00:00 | 4, | Y | Y |  | STORM (4), GLASS (2), TRACK (1) | CC | NA | C | X | IN PAINT |  | 2012-11-16 00:00:00 | 2012-11-19 00:00:00 | 1044 | 0 |  |  |  |  |  |  |  | Y | CANS |  |  |  |  |  | Y
7423 | STRONG | 1 | 2012-10-05 00:00:00 | 4-6, | N | Y |  | SO (1), DS DH (1) | CC | OG | C | X |  |  | 2012-12-03 00:00:00 | 2012-12-04 00:00:00 | 1160 | 0
7433 | LOVELL | 1 | 2012-10-16 00:00:00 | 4-6, | Y | Y |  | DH KIT (1), SO (1) | CC | OLAY | C | X | 3 JELD AT SR, WAITING ON CC |  | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 1435 | 0 |  |  |  |  |  |  |  | N |  | Y
7439 | CLEVENGER | 1 | 2012-10-14 00:00:00 | 4-6, | Y | Y |  | STORM (2) | CC | NA | C | X | LARGE STORM TO BE GLAZED AT SR |  | 2012-12-04 00:00:00 | 2012-12-04 00:00:00 | 405 | 0 |  |  |  |  |  |  |  | Y | CANS | Y
7437 | WATTS | 1 | 2012-10-17 00:00:00 | 4-6, | Y | Y |  | DH KIT (2), STORM (10) | CC | OG | C | X |  |  | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 4541 | 0 |  |  |  |  |  |  |  | Y
7441 | DOERR | 1 | 2012-10-18 00:00:00 | 4-6, | Y | Y |  | STORM (6) | CC | OG | C | X |  |  | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 1786 | 0 |  |  |  |  |  |  |  | Y | CANS
7448 | ISERMAN | 2 | 2012-10-22 00:00:00 | 4-6, | N | Y |  | RETRO CA (2) | CC | OG | LL | X |  |  | 2012-11-30 00:00:00 | 2012-12-10 00:00:00 | 1444 | 0
7452 | SULLIVAN | 1 | 2012-10-23 00:00:00 | 4, | N | N |  | STORM (1) | CC | NA | C | X |  |  | 2012-11-23 00:00:00 |  | 220 | 0
7454 | MINOR | 1 | 2012-10-23 00:00:00 | 4-6, | Y | N |  | DS DH (3), MISC | CC | OG | C | X |  |  | 2012-11-27 00:00:00 |  | 1932 | 0 |  |  |  |  |  |  |  | Y | CANS
7458 | CALDWELL | 1 | 2012-10-24 00:00:00 | 6, | Y | N |  | 5900 DBL CA (1), DBL DR W SL (1) | CC,BUFF | OLAY | C | X | DOORS BY BUFFELEN |  | 2012-12-12 00:00:00 |  | 2438 | 0 |  |  |  |  |  |  |  | N |  | Y,Y
7461 | BUILT SQUARE | 1 | 2012-10-25 00:00:00 | 4-6, | N | N |  | RETRO CA (2) | CC | OLAY | C | X |  |  | 2012-11-25 00:00:00 |  | 1536 | 0
7462 | PELTON | 1 | 2012-10-25 00:00:00 | 2-3, | N | N |  | [NAME] (10) | CC | NA | LLC | X |  |  | 2012-11-29 00:00:00 |  | 5100 | 0
7401 | ROLES | 1 | 2012-10-29 00:00:00 | 4-6, | N | N |  | STORM (5), COMBO ST DOOR (1) | CC | NA | C | X |  |  | 2012-11-27 00:00:00 |  | 2261 | 0
2079-R1R2 | BURKHOLDER | 1 | 2012-10-19 00:00:00 | 4-6, | Y | Y |  | STORM (3) | CC | NA | C | X |  |  | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 723 | 0 |  |  |  |  |  |  |  | N |  | Y |  |  |  |  |  |  | SEE GLASS & OUTSOURCE
7450 | EBY | 1 | 2012-10-24 00:00:00 | 4-6, | Y | Y |  | DH KIT (1) | CC | OG | LLC | X |  |  | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 947 | 0 |  |  |  |  |  |  |  | Y
7477 | FOSTER, ANDY | 1 | 2012-11-07 00:00:00 | 2 WEEKS, | N | N |  | STORM (1) | CC | NA | C | X |  |  | 2012-11-21 00:00:00 |  | 170 | 0
7465 | KENNY | 1 | 2012-11-07 00:00:00 | 4-5, | N | N |  | SO (1), STORM (3) | CC | OG | LLC | X |  |  | 2012-12-07 00:00:00 |  | 1927 | 0
7470 | JANNEY | 1 | 2012-11-03 00:00:00 | 4-5, | N | Y |  | STORM (6) | CC | NA | C | X |  |  | 2012-12-03 00:00:00 | 2012-12-17 00:00:00 | 1215 | 0
7471 | PETERSON, MICHELLE | 1 | 2012-11-06 00:00:00 | 4-6, | N | N |  | 5900 DBL CA (1), SO (2) | CC | TDL OG | C | X |  |  | 2012-12-06 00:00:00 |  | 3348 | 0
7472 | [NAME], DAN | 1 | 2012-11-08 00:00:00 | 4-6, | N | N |  | SO (2) | CC | SQ | C | X |  |  | 2012-12-08 00:00:00 |  | 1226 | 0
7466 | WARMINGTON | 1 | 2012-11-05 00:00:00 | 4-6, | Y | Y |  | STORM (1), STICKS (1) | CC | SQ | C | X |  |  | 2012-12-12 00:00:00 | 12/17/ | 474 | 0 |  |  |  |  |  |  |  | Y | CANS
7478 | JORDAN | 1 | 2012-11-08 00:00:00 | 2-3, | N | N |  | STORM (1) | CC | SW | C | X |  |  | 2012-11-27 00:00:00 |  | 270 | 0
7482 | FLOOD, GREG | 1 | 2012-11-12 00:00:00 | 3-4, | N | N | N | STORM (1) | CC | SW | C |  |  |  | 2012-12-03 00:00:00 |  | 181.25 | 0
7476 | FOSMORE CONSTR | 1 | 2012-11-13 00:00:00 | 2 WEEKS, | N | N | Y | 5900 DBL CA(1)5900 SGL CA(1) | CC | OG | C | X |  |  | 2012-11-28 00:00:00 |  | 2543 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7392 | CHARLES WDO & DOOR | 1 | 2012-09-17 00:00:00 | 5-7, | N | N |  | 4900 DH (1), CA (1) | LINDAL | NA | NA | X | DELIVERED 11/1 | 2012-10-30 00:00:00 | 2012-10-30 00:00:00 |  | 0 | 0 |  |  | 5511 | 5750 |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  | Y
7405 | BAKSTAD | 2 | 2012-09-18 00:00:00 | 4-6, | N | N |  | SO (1) | LINDAL | NA | NA | X | PICKED UP BY CUSTOMER | 2012-10-30 00:00:00 | 2012-10-30 00:00:00 |  | 0 | 0 |  |  | 651 | 481 |  |  |  |  |  |  |  |  |  |  | Y
7415 | CARLISLE CLASSIC HOMES | 1 | 2012-09-24 00:00:00 | 6-8, | N | N |  | JELDWEN | JELD | NA | NA | X | NOT HERE | 2012-12-02 00:00:00 | 2012-12-02 00:00:00 |  | 0 | 0 |  |  | 19240 | 15320.72
7421 | WAGNER | 1 | 2012-08-02 00:00:00 | 6-8, | N | N |  | SERIOUS | SERIOUS | NA | NA | X | ON TRUCK | 2012-11-12 00:00:00 | 2012-10-30 00:00:00 |  | 0 | 0 |  |  | 1843 | 1422.18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
7424 | ROWEN | 1 | 2012-10-04 00:00:00 | 4-5, | N | Y |  | MARVIN (1), LINDAL (1) | MARV, SERIOUS | NA | NA | X | LINDAL ON TRUCK | 2012-11-14 00:00:00 |  | 2012-11-06 00:00:00 | 0 | 0 |  |  | 5657 | 6605 |  |  |  |  |  |  |  |  |  |  |  | Y
7431 | REINKE | 1 | 2012-10-05 00:00:00 | 4-5, | N | N |  | JELDWEN (6) | JELD | NA | NA | X | DELIVERING DIRECT TO CUSTOMER | 2012-11-14 00:00:00 | 2012-11-14 00:00:00 |  | 0 | 0 |  |  | 6101 | 3173.04 |  |  |  |  |  |  |  |  |  |  | Y
7434 | BENNION CONST | 1 | 2012-10-08 00:00:00 | 4-6, | N | N |  |  | JELD | NA | NA | X | IN SHOWROOM | 2012-11-15 00:00:00 |  |  | 0 | 0 |  |  | 843 | 625.13 |  |  |  |  |  |  |  |  |  |  | Y
7438 | STANDISH | 1 | 2012-10-12 00:00:00 | 4-6, | N | N |  |  | LINDAL | NA | NA | X | ON TRUCK | 2012-11-16 00:00:00 | 2012-11-16 00:00:00 |  | 0 | 0 |  |  | 2349 | 1659
7422 | MATTER | 1 | 2012-10-16 00:00:00 | 6, | N | N |  | DOUBLE CASE WITH CC LEAD | LINDAL | NA | LLC | X | AT SHOWROOM TAKE TO VASHON | 2012-11-06 00:00:00 | 2012-11-25 00:00:00 |  | 0 | 0 |  |  | 1049 | 611 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
7385 | CERQUI | 1 | 2012-10-14 00:00:00 | 2-3, | N | Y |  |  | TESCO | NA | NA | X | IN SHOWROOM | 2012-11-01 00:00:00 |  |  | 0 | 0 |  |  | 68 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
7451 | ISHIKURA | 1 | 2012-10-22 00:00:00 |  | N | N |  |  | JELD | NA | NA | X | NOT HERE | 2012-11-05 00:00:00 |  |  | 0 | 0 |  |  | 11826 | 7277.65
7456 | LOVELL | 1 | 2012-10-22 00:00:00 | 4-5, | N | Y |  | CC DH KIT (1), VINYL SLID (3), GR (1) | JELD | NA | NA | X | 3 JELD IN SR, WAITING ON CC | 2012-11-05 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 0 | 0 |  |  | 432 | 242.65 |  |  |  |  |  |  |  |  |  |  |  |  | SEE GLASS & CC |  |  |  |  |  | Y
7458 | CALDWELL | 1 | 2012-10-24 00:00:00 | 6, | Y | N |  | [NAME] | BUFF | NA | NA | X | DOORS BY BUFFELEN | 2012-12-02 00:00:00 | 2012-12-12 00:00:00 |  | 0 | 0 |  |  | 3922 | 2774.8 |  |  |  | N
7443 | FOSTER-MATT | 1 | 2012-10-22 00:00:00 | 4-5, | N | Y |  | DH KITS (2) | LINDAL | NA | NA | X | AT SHOWROOM | 2012-11-12 00:00:00 | 2012-12-17 00:00:00 | 2012-11-29 00:00:00 | 0 | 0 |  |  | 1449 | 652
7432 | SWETONIC | 1 | 2012-10-22 00:00:00 | 4-5, | N | Y |  | DBL CA (1) | JELD | NA | NA | X | NOT HERE | 2012-11-30 00:00:00 | 2012-12-11 00:00:00 |  | 0 | 0 |  |  | 1723.59 | 1030
7463 | BELLAN CONSTRUCTION | 1 | 2012-11-01 00:00:00 | 4-5, | N | N |  | LINDAL (2) | LINDAL | NA | NA | X | NOT HERE | 2012-12-01 00:00:00 |  |  | 0 | 0 |  |  | 819.9 | 695.52
7459 | BENNION -EMSLIE | 1 | 2012-10-24 00:00:00 | 2, | N | N |  |  | JELD | NA | NA | X | DELIVERED 11/06 | 2012-11-06 00:00:00 | 2012-11-06 00:00:00 |  | 0 | 0 |  |  | 986 | 591.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
7465 | KENNY | 1 | 2012-11-07 00:00:00 | 4-5, | N | N |  |  | JELD | NA | NA | X | NOT HERE | 2012-12-06 00:00:00 | 2012-12-07 00:00:00 |  | 0 | 0 |  |  | 2351 | 1448.03
7474 | FRYETT | 1 | 2012-11-06 00:00:00 | 4-6, | N | Y |  | DH KITS (2) | LINDAL | NA | NA | X | NOTE HERE | 2012-12-04 00:00:00 | 2012-12-04 00:00:00 |  | 0 | 0 |  |  | 1195
7473 | BENNIION - ROBERTSON | 1 | 2012-11-12 00:00:00 | 2, | N | N |  | JELDWEN VINYL (26) | JELD | NA | NA | X | SHIPPING DIRECT TO JOBSITE | 2012-11-26 00:00:00 | 2012-11-26 00:00:00 |  | 0 | 0 |  |  | 5530.63 | 4254.32
7483 | DAHL | 1 | 2012-11-14 00:00:00 | 4, | N | N |  | JELDWEN DH (1) | JELD | NA | NA | X | NOT HERE | 2012-12-14 00:00:00 | 2012-12-14 00:00:00 |  | 0 | 0 |  |  | 100 | 399.48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL DUE WITHIN 10 DAYS FROM TODAY