Spreadsheet: 31630d1227572701-using-today-in-if-function-if-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Date Tracking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT Internal Info |  |  |  |  |  |  |  | Key Performance Indicators
 |  |  |  |  |  |  |  |  |  | Training Date |  | [NAME] | First Exam |  | Exam | Second Exam |  |  |  | Signature Tracking |  | Results Tracking
Temp Done Flag | Company Name | Type | Status | Reason for inactive status | Date of status change | Products Serviced | Cert # | Reason for class Cancellation | Class Location | Training Date | Training End Date | Link to registration form | Date of 1st Exam | Date 1st exam was scored | Link to exam #1 | Date of 2nd Exam | Date 2nd exam was scored | Cert Date | Re-Cert Date | Date certificate passed for signature | Date certificate returned from signature | Date Results Delivered | Cert. Experation Date | Re-Cert Expiration Date | Past Cert. Expiration | Cert. Not Expired | Student Title | Student First Name | Student Last Name | Student Suffix | Need ID card printed | Photo | Contact/Acct | Address | Address 2 | Address 3 | City | State | Country | Zip | Coordinator Name | Coordinator Tel # | Coordinator Fax# | Coordinator email address | Personal Email | Admin / Coordinator Email address | Main | Cell | Fax | SA Sent | SA [NAME] | M2M Acct# | SAP Ship To Acct # | [NAME] # | Acct. # [NAME] | Notes | Other Tech's | Days to score 1st exam | Days to score 2nd exam | Days to return certificate for signature | Days to produce documentation | Days start to finish | 2008 Annual Servicer Packet Sent | 2008 Agreement received | Confidentiality Agreement received | Certificate of Liability Insurance received
 |  | Independent | Active |  |  | PC/CT | CX0154 |  | [NAME], WA | 2007-10-29 00:00:00 | 2007-11-02 00:00:00 |  | 2007-11-02 00:00:00 | 2007-11-02 00:00:00 |  |  |  | 2007-11-02 00:00:00 |  | n/a | n/a | 2007-11-02 00:00:00 | 2009-11-01 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | Edmonton | AB | Canada | TSE5X3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes-6/12/08 | Yes-6/23/08 | Yes-6/23/08 | Yes-6/23/08
 |  | Independent | Active |  |  | CT | CX0196 |  | [NAME], WA | 2008-06-02 00:00:00 | 2008-06-06 00:00:00 |  |  |  |  |  |  | 2008-06-06 00:00:00 |  |  |  |  | 2010-06-06 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | Calgary | AB | CANADA | T3H 5X7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ---
 |  | Dealer | Active |  |  | PC/CT | CX0175 |  | Anchorage, AK | 2008-03-17 00:00:00 | 2008-03-21 00:00:00 |  |  |  |  |  |  | 2008-03-22 00:00:00 |  |  |  |  | 2010-03-22 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | Anchorage | AK | USA | 99507 |  |  |  |  |  |  |  |  |  |  |  |  | 197993 |  |  |  |  |  |  | ---
 |  | Dealer | Active |  |  | PC/CT | CX0176 |  | Anchorage, AK | 2008-03-17 00:00:00 | 2008-03-21 00:00:00 |  |  |  |  |  |  | 2008-03-22 00:00:00 |  |  |  |  | 2010-03-22 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | Anchorage | AK | USA | 99507 |  |  |  |  |  |  |  |  |  |  |  |  | 197993 |  |  |  |  |  |  | ---