Spreadsheet: 26613d1218822255-complicated-if-then-question-test
Sheet: master sheet

charge amount | DMA | Customer Name | Cust Acct Number | [NAME] | [NAME] | Tech User ID | Actual End Date | Service Address | Service Address Line 3 | Service Address Line 2 | Service City | Service State | Service [NAME] | site number | Date QC was completed | inspector | sub/aero | repaired | charge amount | Results | Line Of Site ** | ODU Assembly ** | Correct ODU ** | ODU Mount ** | Monopoles ** | Cabling from LNB to MS | Correct MS ** | Bishop tape used ** | F-Conn Prep/Install ** | Weather proof ext. connections ** | MS/GB Mounted | Drip Loops | Sealant @ Entry Point | Cabling Routing / Attachment | Approved Cables Used | Unnecessary Splices or Barrels | Connectors tight | ODU / GB Bonded | System Grounded to NEC ground source | Approved Ground Wire Used | System Bonded to NEC Spec ** | Approved Materials Used | Trash Picked Up | Customer Contact | Phone Lines connected | Approved phone line in good condition | phone [NAME] (wireless / other) | Receiver Connection to TV | Integration of Customers Equip | BBC Installed ** | Wall Plate with barrell | Acceptable Signal Level | Receiver Properly Installed | Remotes Programmed | DirecTV ID | Uniform | Site Survey Discussed | DTV marketing materials | Contact numbers provided | IRD Explained | Support Channels Reviewed | Tech on Time | Tech professional | Welcome Kit
#N/A | ST LOUIS MO | [NAME] | 5708565 | 6365328288 | ODU | ASMO004036 | 2008-07-23 00:00:00 | 254 CHEVAL SQUARE DR |  |  | CHESTERFIELD | MO | 63005163754 | 406 | 2008-08-08 00:00:00 | RANDALL | AERO |  | #N/A | #N/A | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS
25 | ST LOUIS MO | [NAME] | 10013362 | 6365327312 | ODU | ASMO004096 | 2008-07-20 00:00:00 | 100 N EATHERTON RD |  |  | CHESTERFIELD | MO | 63005350200 | 406 | 2008-08-08 00:00:00 | RANDALL | AERO |  | 25 | FAIL | fail | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | fail | fail | fail | fail | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS
25 | ST LOUIS MO | [NAME] | 5468211 | 6365300703 | ODU | ASMO004036 | 2008-07-23 00:00:00 | 201 FICK FARM RD |  |  | CHESTERFIELD | MO | 63005363901 | 406 | 2008-08-08 00:00:00 | RANDALL | AERO | NO | 25 | FAIL * | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | FAIL | FAIL | N/A | FAIL | PASS | PASS
25 | ST LOUIS MO | [NAME] | 63307619 | 3147950932 | ODU | ASMO004800 | 2008-07-21 00:00:00 | 526 EATHERTON RD |  |  | CHESTERFIELD | MO | 63005411426 | 406 | 2008-08-08 00:00:00 | RANDALL | SUB |  | 25 | FAIL | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | fail | fail | fail | fail | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS | PASS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if any of the columns from V on are in red, and that particular line items fails
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | it returns a Fail * - look at cell AP10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if four non critical fails are scored - it retuns a fail - see cells AF11 thru AI11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if four non critical fails are scored - it retuns a fail - see cells [NAME] thru AI9, and V9.  V(
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is a critical fail but it only returns a fail