Spreadsheet: 169741d1343047548-lookup-more-than-one-table-depending-on-user-input-blank-database-2003-copy
Sheet: Fault Codes

Codes |  |  |  |  |  |  | Codes |  |  |  |  | Helper Column
Safety |  | version |  | Universal Fault Codes |  |  | Iguana Fault Codes |  |  | Delivery |  | Fault Codes | product_fail_codes
- |  | - |  | Code | - |  | Number | Reason |  | Description |  | Universal Codes | product_fail_codes
Brusing |  | Iguana |  | 1 | Gears |  | 1 | UserAbort |  | waiting for loom |  | Iguana Codes | Table62
Strain |  |  |  | 2 | Gear Cover |  | 2 | InvalidBuildCode |  | no usb pcb's
Small Cut |  |  |  | 3 | Coin Vibrator |  | 3 | InvalidFeatureCode |  | C
Blister |  |  |  | 4 | [NAME] |  | 4 | InvalidOptionCode |  | D
Rash |  |  |  | 5 | [NAME] |  | 5 | MessageHandlerFailed |  | E
Slip/Trip |  |  |  | 6 | Light-Guide Screws |  | 6 | SupplyConnectionError |  | F
Minor Eye |  |  |  | 7 | Trapped Wires / Cables |  | 7 | SimplePollFailed |  | G
Burns |  |  |  | 8 | Plug Fitting |  | 8 | ReadSerialNumberFailed |  | H
Crush |  |  |  | 9 | Loom Failed / Damaged |  | 9 | ReadProductionFlagsFailed |  | I
Head |  |  |  | 10 | Motor |  | 10 | BeginCalibrationFailed |  | J
Other |  |  |  | 11 | Damage C/Plate |  | 11 | CalibrateTxFailed |  | K
 |  |  |  | 12 | Damage C/Box |  | 12 | CalibrateRxFailed |  | L
 |  |  |  | 13 | Damage E/Plate |  | 13 | VerifyTxFailed |  | M
 |  |  |  | 14 | Not Screwed Down |  | 14 | VerifyRxFailed |  | N
 |  |  |  | 15 | Nuts Screws & Washers |  | 15 | EndCalibrationFailed
 |  |  |  | 16 | Port Blank / Adapter |  | 16 | UsbEnumerationTimeout
 |  |  |  | 17 | Soldering |  | 17 | ReadDeviceStringsFailed
 |  |  |  | 18 | Wrong Build |  | 18 | ReadPositionFailed
 |  |  |  | 19 | Other |  | 19 | BuildMismatchError
 |  |  |  | 20 | PCB MK4 |  | 20 | ReadDeviceInfoFailed
 |  |  |  | 21 | PCB EMC |  | 21 | VerifyFirmwareFailed
 |  |  |  | 22 | PCB Serial |  | 22 | ResetDeviceFailed
 |  |  |  | 23 | PCB EMC HS |  | 23 | EnableDeviceInterruptFailed
 |  |  |  | 24 | PCB Konami |  | 24 | EnableCashOutFailed
 |  |  |  | 25 | PCB EMC Spill-Proof |  | 25 | CashPayoutTimeout
 |  |  |  | 26 | PCB Motor Filter |  | 26 | CashPayoutFailed
 |  |  |  | 27 | PCB Other |  | 27 | InsertCoinsTimeout
 |  |  |  | 28 | PCB USB |  | 28 | DisableDeviceInterruptFailed
 |  |  |  | 29 | PCB USB Dead |  | 29 | CoinsUnpaid
 |  |  |  | 30 | PCB USB [NAME] |  | 30 | [NAME]
 |  |  |  | 31 | USB Not Recognised |  | 31 | LogicCurrentTooHigh
 |  |  |  | 32 | # 0 |  | 32 | MotorCurrentTooLow
 |  |  |  | 33 | # 1 |  | 33 | MotorCurrentTooHigh
 |  |  |  | 34 | # 2 |  | 34 | UnitNotPassedCircuitTest
 |  |  |  | 35 | # 10 |  | 35 | ClearRamFailed
 |  |  |  | 36 | # 11 |  | 36 | ReadInterfaceListFailed
 |  |  |  | 37 | # 12 |  | 37 | DisableCashOutFailed
 |  |  |  | 38 | # 13 |  | 38 | ReadInterfaceFlagsFailed
 |  |  |  | 39 | # 14 |  | 39 | PowerFailDetected
 |  |  |  | 40 | # 20 |  | 40 | LowLevelPlateError
 |  |  |  | 41 | # 21 |  | 41 | ClearInterfaceFlagFailed
 |  |  |  | 42 | # 22 |  | 42 | MsdEnumerationTimeout
 |  |  |  | 43 | # 30 |  | 43 | MsdDisconnectTimeout
 |  |  |  | 44 | # 31 |  | 44 | HighLevelPlateTimeout
 |  |  |  | 45 | # 32 |  | 45 | LowLevelPlateTimeout
 |  |  |  | 46 | # 33 |  | 46 | EmptyLevelPlateTimeout
 |  |  |  | 47 | # 40 |  | 47 | InvalidSerialNumber
 |  |  |  | 48 | # 41 |  | 48 | SerialNumberMismatch
 |  |  |  | 49 | # 42
 |  |  |  | 50 | # 43 |  | 100 | ParseOrderTestFailed
 |  |  |  | 51 | # 44 |  | 101 | InitializeTestFailed
 |  |  |  | 52 | # 45 |  | 102 | PowerUpTestFailed
 |  |  |  | 53 | # 50 |  | 103 | SimplePollTestFailed
 |  |  |  | 54 | # 51 |  | 104 | CalibrateOptoTestFailed
 |  |  |  | 55 | # 52 |  | 105 | EnableUsbTestFailed
 |  |  |  | 56 | # 53 |  | 106 | ConfigurationCheckTestFailed
 |  |  |  | 57 | # 54 |  | 107 | UpdateFirmwareTestFailed
 |  |  |  | 58 | # 55 |  | 108 | ClearRamTestFailed
 |  |  |  | 59 | # 56 |  | 109 | VerifyFirmwareTestFailed
 |  |  |  | 60 | # 57 |  | 110 | InterfaceCheckTestFailed
 |  |  |  | 61 | # 58 |  | 111 | LevelPlatePrepareTestFailed
 |  |  |  | 62 | # 60 |  | 112 | LevelPlateTest1Failed
 |  |  |  | 63 | # 61 |  | 113 | LevelPlateTest2Failed
 |  |  |  | 64 | # 71 |  | 114 | LevelPlateTest3Failed
 |  |  |  | 65 | Knocking |  | 115 | PayoutTestFailed
 |  |  |  | 66 | [NAME] |  | 116 | DisableUsbTestFailed
 |  |  |  | 67 | Level Sense Plates |  | 117 | UpdateMemoryTestFailed
 |  |  |  | 68 | Dead |  | 118 | PrintLabelTestFailed
 |  |  |  | 69 | Track Off |  | 119 | UpdateCoinValueTestFailed