Spreadsheet: 681536d1591629213-counting-instances-on-columns-excel-example
Sheet: Treadmill with Chinese

喬山健身器材(上海)有限公司
DATE:09/04/16  REV:2.0 |  | TM RETAIL電跑成品檢驗查檢表
 |  |  | Material Number: |  | Model Number:
項目 Items | 序號 # | [NAME] | Date: |  | Inspector: | 等級 Level | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial# |  |  | 序號Serial#
 |  |  | Inspection Standards | 檢驗量具 Tools | 檢驗方法                      Inspection Methods |  | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes | 檢驗結果 result | 不良現象 defects | 備註 notes
包裝及零附件 Packaging & parts | 1 | 成品包裝外觀符合要求（打包帶位置正確;外箱/內包材無破損,無污痕，發黴，潮濕.纏繞膜要拉緊纏位；包裝確保零件齊全/擺放位置正確；折叠机种需用打包带固定；） | Good appearance, correct strap position for outside and inner package, no damage on carton & internal packaging materials, no dirt, mildew, moisture, parts well wrapped with plastic film, parts in box are complete and correct position | 目視 Visual | 參照包裝sop Check with packaging SOP | B
 | 2 | 黄色大警告贴标及说明书开箱可见，无多余的尖锐零件，美工刀片遗留成品箱里，打包带固定好折叠车架处 | Yellow warning decal and OM can be see after open box. No sharps and no box cutters left in box.  Correct strap position for inside (to secure running deck frame) | 目視 Visual | 實機查看 Confirm | A
 | 3 | 安全指導書/說明書/組立書/保證卡/吊卡 | safety guide /Owner's manual/Assembly guide/Warranty card/Tag. | 目視 Visual | 查核BOM，對比首件 Check with BOM/ first article | B
 | 4 | 五金零件包零件與組裝說明書相符 | Hardware parts match assembly guide/ hardware box checklist. Silicone bottle should be included in hardware box on models with silicone system. | 目視 Visual | 查核BOM，對比首件 Check with BOM/ first article | B
 | 5 | 按照国家别插頭規格: | Plug spec. according to country | 目視 Visual | 查核BOM，對比首件 Check with BOM/ first article | A
 | 6 | 車架顏色；側蓋顏色 | Frame color ;Side cover color | 目視 Visual | 查核BOM，對比首件 Check with BOM/ first article | B
 | 7 | CE貼標1；ETL貼標 2； | CE certification            ETL certification | 目視 Visual | 查核BOM，對比首件 Check with BOM/ first article | A
外觀 Appearance | 8 | 機台及各部件表面不得有外觀色差,劃傷,生锈,破裂的痕跡，磨痕，焊渣，虚焊、飞溅、气孔，整體不得有污垢不潔現象（塗裝件，焊接件，塑膠件，跑带等） | No color difference, scratch, rust, break, polishing scratch, slags, fake welding, spatter and hole on units and parts surface. No dirty on whole units( painting , welding ,plastic parts and others). | 目視 Visual | 查看整機及各部件 check whole machine and other parts | B
 | 9 | 貼標印刷、粘貼位置正確，不可歪斜，不可浮翘,[NAME] | All decals printing correct and pasted on proper positions, straight, no peel off, model and serial number correct and match with units, UPC on package box matches with serial number on frame. | 目視 Visual | 實機查看 Confirm | A
 | 10 | 相連塑膠件均勻間隙≦2.0MM;段差≦1.5MM | Plastic gap ≦2.0[NAME], level difference≦1.5mm. | 卡尺 Caliper | 實機量測 Measure | B
 | 11 | 泡棉左右對稱,無漏洞/皺紋/凹陷,不轉動 | L/R foams are symmetrical, no hole/wrinkle/cut, not movable. | 目視 Visual | 實機查看 Confirm | B
 | 12 | 操作面板無劃傷,印刷不良,保護膜不可脫落 | Overlay: no scratch, printing defect, protective film included. | 目視 Visual | 實機查看 Confirm | B
結構Structure | 13 | [NAME],无烤漆，能顺利组装（含组装困难） | All screw and parts need tighten, no paint in threads/damaged threads, can be easily assembled | 組裝 Assembly | 按照對應組立說明書組裝 Assemble according to OM. | B
 | 14 | 所有組裝皆能完成（无法组装） | Units parts can be assembled according to OM | 組裝 Assembly | 按照對應組立說明書組裝 Assemble according to OM. | A
 | 15 | 跑带运行前，跑帶偏離中心:靜止時A-B<7MM | Running belt off-center: when belt is stopped A-B<7mm. | 直尺 Foot rectangular | 开箱静止时四点量测跑带居中度，在平台运转2-5分钟后再次量测跑带居中度 measurement belt position before running treadmill, test again after 2-5 minute movement (only record before running treadmill). | B |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance. |  |  | Before Running (side rail to belt)  Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance  After Running  (no user) Left: 0mm  Right: 0mm Difference: 0mm  [NAME] is 0mm off center, which is 0mm under/over the 3.5mm tolerance.
 | 16 | 機台豎起來可易於卡住,不脫勾,無干涉； | Folding mechanism secured when unit folded, does not unhook on its own. | 實機測試 Unit test | 實機查看 Confirm | A
 | 17 | 刹車正常，輕鬆順暢；可調性緩衝腳墊調節順暢，不歪斜 | Transport wheel latch works normally, easy and smoothly; Adjustable foot pad cushion can be adjusted smoothly. | 實機測試 Unit test | 實機查看 Confirm | B
 | 18 | 馬達護蓋與跑帶間隙大於5MM小於10MM | Motor cover & running belt gap >5mm, <10mm. | 塞尺 Feeler | 實機量測 Measure | A
 | 19 | 機身折迭不干涉扶手,[NAME] | When folding up, no interference with handlebar, L/R difference≦15[NAME], no contact with console. | 卷尺 Tape measure | 實機量測 Measure | B
 | 20 | MF:跑帶中心張力  0.5~1.2KG (thickness適用於厚度1.6 & 2.2mm跑帶) | [NAME]: Running belt center tension :       0.5~1.2KG (thickness1.6 & 2.2mm ) | 跑帶張力計 Running belt tension meter | 參照sop Check with SOP | B
 | 20 | VF:跑帶中心張力:0.6 ~ 0.8 KG (thickness適用於厚度3.1 & 4.4 mm跑帶)   0.8~1.6KG (thickness適用於厚度1.6 & 2.2mm跑帶) | VF: Running belt center tension :    0.6 ~ 0.8 KG (thickness3.1 & 4.4 mm)   0.8~1.6KG (thickness1.6 & 2.2mm ) | 跑帶張力計 Running belt tension meter | 參照sop Check with SOP | B
 | 21 | HZ:跑帶中心張力:  0.6 ~ 0.8 KG (適用於厚度thickness3.1 & 4.4 mm跑帶)   0.8~1.6KG (適用於厚度thickness1.6 & 2.2mm跑帶 )  0.7～1.4KG (OPP適用厚度 thickness≦1.6mm以下） | HZ: Running belt center tension :    0.6 ~ 0.8 KG (thickness3.1 & 4.4 mm)   0.8~1.6KG (thickness1.6 & 2.2mm )  0.7～1.4KG (OPP thickness≦1.6mm） | 跑帶張力計 Running belt tension meter | 參照sop Check with SOP | B
 | 22 | 多槽皮帶張力（有压力轮不测试） | Drive belt tension    (not performed if model includes tension wheel) | 張力計 Tension meter | 參照sop Check with SOP | B
 | 23 | 多槽皮帶準線<1.5MM,反轉不跳槽（无压力轮） | Drive belt alignment <1.5mm, (without tension wheel) | 治具 Alignment gauge | 与马达飞轮对齐测量皮带到马达和滚轮的距离，A-B<1.5MM Place straightedge against motor housing; measure side of belt from straightedge - at both motor axle point and roller point; deviation between two measures must [NAME]， | A
 | 24 | 皮帶不可偏出前滾輪及壓力輪邊緣，多槽皮带正反转不脱落(有压力轮） | tension wheel should be parallel with drive belt (not overhanging), multiple-groove belt is not falling off during forward and reverse | 目視 Visual | 實機查看 Confirm | A
 | 25 | TM马达区域有否松脱的五金零件,多余螺丝垫片等 | Check  if have loose hardware parts, extra screw ,washer and other parts left in motor area | 目視 Visual | 實機查看 Confirm | A
 | 26 | 线材端子包括端子固定物不可受损；检查线材和端子连接牢固,電線要正确保护,鬆緊適當,配線槽須貼緊與運動件無接觸(马达/电源座/EMI滤波器等)（如果导致功能异常，不良等级将升级为A级） | cable and connector cannot be damage; check connection  between connector and cable, cable should be properly secured, cable cannot touch moving parts | 實機測試 Unit test | 實機查看 Confirm | A
 | 27 | 氣壓棒折叠无异音 | Air shock no abnormal noise when folding up and down. | 實機測試 Unit test | 實機確認 Confirm | B
 | 28 | 驅動馬達/升降馬達規格確認 | Drive motor/incline motor spec. confirmation | 目視 Visual | 對比BOM Check with BOM | A
 | 29 | 升降馬達在整個行程不碰到任何零件/升降正常（最低到最高來回3次） | Elevation motor does not touch any parts in travel process, decline normally.(Bottom to top for 3 times) | 實機測試 Unit test | 實機確認 Confirm | A
儀錶Console | 30 | 儀錶軟體版本 | console software version | 目視 Visual | 實際檢查 Confirm | A
 | 31 | 儀錶:1. Kilometers公制;2.Miles英制 | Console:1. Kilometers    2.Miles | 目視 Visual | 美國/英國/加拿大為英里;其他為公里 US/UK/Canada miles, others kilometers | A
 | 32 | Polar功能 | Polar function | 治具 gauge | 距儀表30-60cm distance 30-60cm | A
 | 33 | 正常按壓下，各按鍵靈敏度及功能正常 | All [NAME] and buttons work well with normal and  sensitivity press | 測試 test | 實機確認 Confirm by pressing all keys | A
 | 34 | 所有點全亮/無陰影/任何角度無背光障礙；內容及位置顯示正確，無缺化 ；握把心跳功能正常，不可單手心跳； | Full lights,/no shadow/any angle no block to back light; Display correctly, no stroke missed. Normal functions of HR handlebar. | 目視 Visual | 實機確認 Confirm | A
 | 35 | 心跳握把間隙小於2.0[NAME], 高低和斷差小於1.5mm.感應片不可凹陷/松脫/浮翹/凹痕/破損 | HR handlebar [NAME], level difference <1.5mm, no sunken, loose, raise, dent, broken on grip plate | 目視 Visual | 實機確認 Confirm | B
 | 36 | 按鍵功能/iPod/Wi-Fi/藍牙；音響音訊輸入或輸出/音響音質正常,無紮音/破音；触摸屏按键灵敏 | Normal functions of Keys/IPOD/Wi-Fi/Bluetooth, Normal functions of audio input or output and tone quality, proper sensitivity of  touch screen | 治具 gauge | 實機確認 Confirm | A
功能function | 37 | 電源規格 | Power spec. | 目視 Visual | 對比BOM,查看電源頻率貼標 Check label with BOM. | A
 | 38 | [NAME]                                                                                                                                                                                                  [NAME]: 英制0.5MPH±0.05MPH                                                         [NAME]: 公制0.8KPH ±0.08KPH | Running belt start speed:    Mile: 0.5MPH±0.05MPH                                                         Kilometer: 0.8KPH ±0.08KPH | [NAME] | 參照sop Check with SOP | B
 | 39 | 跑帶中速:                                                    [NAME]: 英制 6MPH ±0.3MPH                                              Kilometer: 公制 10KPH ±0.48KPH | Running belt mid speed: Mile:  6MPH ±0.3MPH                                              Kilometer: 10KPH ±0.48KPH | [NAME] | 參照sop Check with SOP | B
 | 40 | 跑帶最高速:                          [NAME]: 英制最高速 ±0.3MPH                                                  [NAME]:公制 最高速 ±0.48KPH | Running belt high speed:         Mile: high speed ±0.3MPH                                                  [NAME]: high speed±0.48KPH | [NAME] | 參照sop Check with SOP | B
 | 41 | 上控板版本號檢查；下控板版本號檢查 | PCB version; MCB version | 目視 Visual | 對比BOM Check with BOM | A
 | 42 | 下控板電壓檢查；升降馬達電壓檢查 | MCB voltage; Decline motor voltage | 目視 Visual | 1) 110V     2)220V (+/- 10 volts) | A
 | 43 | 安全開關插入順暢，不卡死；連續插3次須每次機台都能正常運行；拉下機台需立即停止 | Safety key fits well, no stuck, continuously fit three times and unit can run normally. Machine stops immediately when pulling off the key. | 人機實測 Man test | 實機確認 Confirm | A
 | 44 | [NAME]:VF/Matrix<0.6cm/s | vibration test :VF/Matrix<0.6cm/s | 震動計 [NAME] | 在4&6&8&10mph車架左側前滚轮前部量测震動小于0.6cm/s  Vibration test:@ 4&6&8&10mph, measure on upper/left position of front roller frame, <0.6cm/s | B
 | 45 | [NAME]:HZ 中高端為<0.8cm/s（马达2.25hp以上） | vibration test :HZ middle and high price is <0.8cm/s ( including motor ＞2.25hp ) | 震動計 [NAME] | 在4&6&8&10mph車架左側前滚轮前部量测震動小于0.8cm/s   Vibration test:@ 4&6&8&10mph, measure on upper/left position of front roller frame, <0.8cm/s | B
 | 46 | 震動檢查:低端為<1.1cm/s（马达含2.25hp以下） | vibration test :low price is <1.1cm/s ( including motor ≤2.25hp ) | 震動計 [NAME] | 在4&6&8&10mph車架左側前滚轮前部量测震動小于1.1cm/s   Vibration test:@ 4&6&8&10mph, measure on upper/left position of front roller frame, <1.1cm/s | B
 | 47 | 耐高壓測試，絕緣測試，交流接地測試，消耗功率測試，漏電流測試，低電壓啟動 | high pressure resistant test, insulation test, AC grounding test, consumed power test, Leakage Current Test, Low voltage start | 六合一測試儀   multiple test machine | 依測試SOP According to test SOP | A
 | 48 | 家用机种整机噪音:最高速時<90db. | Home use model noise : @ highest speed<90db | 噪音計 [NAME] | 垂直距離馬達上護蓋上方30CM處測量 Vertical distance 30cm from upper motor cover. | B
 | 49 | 整机噪音(含Matrix及VF）:最高速時<80db. | Matrix and Vision model noise : @ highest speed<80db | 噪音計 [NAME] | 垂直距離馬達上護蓋上方30CM處測量 Vertical distance 30cm from upper motor cover. | B
 | 50 | 整機運轉無干涉 | No interference of moving parts during operation | 目視 Visual | 實機確認 Confirm | B
Other | 51 | Other defects found with no specifications or standards. | Other defects found with no standard or specification
 | 52
 | 53
核准Approved by:                              審核Checked by:                              檢驗者Inspector: