Spreadsheet: 64079d1264951334-data-in-cells-that-move-copy-of-excel-question2
Sheet: Planning Data

Jan 2010 Planning Schedule
Report generated on 1/28/10 7:52am
Active Overdue Customers to be Scheduled
Job # | Pref Date | Location | City | State | Account Manager | Region Director | Pri Provider | Billing Type | Service Lines | Price | Tech Price | Technician | Tech Group
108092 | 1/8/10 | Chili's #1034 Plant City | Plant City | FL |  |  | 556 | Normal |  | 585 | 303.5 |  | Service Partner
105845 | 1/10/10 | TGIF - #0528 Winchester | Winchester | VA |  |  | 554 | Normal |  | 664 | 395 |  | Service Partner
105700 | 1/24/10 | Chili's #0846 Market Street | Chattanooga | TN |  |  | 334 | Normal |  | 585 | 303.5 |  | Service Partner
105704 | 1/24/10 | Compass - BOA - Bytes Cafe Unit #13663 | Charlotte | NC |  |  | 3465 | Normal |  | 1100 | 0 |  | In-House Technician
105710 | 1/26/10 | Chili's #0381 Cool Springs | Franklin | TN |  |  | 3432 | Normal |  | 585 | 303.5 |  | Service Partner
107294 | 1/27/10 | Longhorn-LH056  Peachtree City | Peachtree City | GA |  |  | 334 | Fixed |  | 600 | 325 |  | Service Partner
 |  | 6 |  |  |  |  |  |  |  | 4119 | 1630.5
Jobs with No Technician Assigned
Job # | Req Date | Job Type | Location | City | State | Pri WO # | Cust PO # | Billing Type | Service Lines | Price | Tech Price | Technician | Company | Tech Group
108092 | 5/7/09 | Service | Dairy Queen-E 5th Street | Big Stone Gap | VA |  | 556 | Normal | KEC | 360 |  |  |  | No group
105845 | 1/11/10 | Service | Macaroni Grill #0163 Tucson | Tucson | AZ |  | 554 | Normal | ESP | 0 |  |  |  | No group
105497 | 1/2/10 | Service | TGIF - #0102 Lewisville | Lewisville | TX |  | 334 | Normal | GC | 1590 | 300 |  |  | No group
105700 | 1/15/10 | Service | Red Lobster #305 - [NAME] | [NAME] | SD |  | 3465 | Normal | KEC | 425 | 300 |  |  | No group
105704 | 1/15/10 | Service | Red Lobster #460 - Rapid City | Rapid City | SD |  | 3432 | Normal | KEC | 425 | 300 |  |  | No group
105710 | 1/15/10 | Service | Red Lobster #639 - Cheyenne | [NAME] | WY |  | 334 | Normal | KEC | 425 | 300 |  |  | No group
107294 | 1/29/10 | Service | Compass-Levy-US Airways #38129 | Phoenix | AZ |  | 3566 | Normal | Other | 0 |  |  |  | No group
 |  |  | 7 |  |  |  |  |  |  | 3225 | 1200
Tentatively Scheduled Jobs Without Dates (waiting on technician)
Job # | Req Date | Job Type | Location | City | State | Account Manager | Region Director | Pri Provider | Pri WO # | Cust PO # | Billing Type | Service Lines | Price | Tech Price
108092 | 5/7/09 | Service | Dairy Queen-E 5th Street | Big Stone Gap | VA |  |  |  |  | 556 | Normal | KEC | 360
107861 | 1/20/10 | Service | [NAME]'s of Chicago - Boca Raton | [NAME] | FL |  |  |  |  | 554 | Fixed | Other | 0
101874 | 11/12/09 | Service | [NAME]'s of Chicago - Louisville | Louisville | KY |  |  |  |  | 334 | Fixed | Other | 0
105483 | 1/15/10 | Service | Macaroni Grill #0301 - North Tucson | Tucson | AZ |  |  |  |  | 3465 | Normal | Other | 0
100373 | 1/15/10 | Service | Macaroni Grill #0163 Tucson | Tucson | AZ |  |  |  |  | 3432 | Normal | KEC,GC,Other | 784 | 470.2
105845 | 1/11/10 | Service | Macaroni Grill #0163 Tucson | Tucson | AZ |  |  |  |  | 334 | Normal | ESP | 0
108466 | 1/28/10 | Service | Chili's #0123 [NAME] | Tampa | FL |  |  |  |  | 3566 | Normal | KEC,GC | 585 | 303.5
107811 | 1/15/09 | Service | Chili's #0946 Atlantic Blvd | Jacksonville | FL |  |  |  |  | 778 | Normal | KEC,GC,Other | 585 | 303.5
99552 | 1/24/10 | Service | On the Border #0126 Broadway | Tucson | AZ |  |  |  |  | 987 | Normal | KEC,GC | 716 | 378.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3030 | 1456