Spreadsheet: 680777d1591192660-inputting-multiple-values-in-a-single-cell-example-for-excel-forum
Sheet: Strength with chinese

喬山健身器材(上海)有限公司 Johnson Industries (Shanghai) Co. Ltd
重训GM查檢表 Strength Product Inspection Form
Date: |  |  | Model: |  |  |  |  |  |  |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number
Inspector: |  |  | Material Number:
類別 Part | 序號 # | 項目Inspection point | 检验标准 Specification | 檢驗方法 Method | 等級 Level | 檢驗結果Result | 判定Verdict |  | 檢驗結果Result | 判定Verdict |  | Result | Description | Pictures | Result | Description | Pictures | Result | Description | Pictures | Result | Description | Pictures | Result | Description | Pictures | Result | Description | Pictures | Result | Description | Pictures | Result | Description | Pictures
 |  |  |  |  |  | 产线自检Self-inspection | OK:ˇ | OUT:╳ | 品保检验 QC inspection | OK:ˇ | OUT:╳
結構Structure | 1 | 人體工學尺寸Ergonomics Dimensions | 人體工學尺寸符合圖面要求,準線良好。 Ergonomics  meet drawing and good alignment | 卷尺 Tape | A
 | 2 | 凸輪和滑輪 Cam & Pulley | 凸輪偏擺間隙< 2MM,滑輪偏擺不能干涉滑輪固定片  Run out tolerance of cam < 2MM, | 卡尺 Calipers | A
 | 3 | 選擇片 Weight Plate | 距離1米目視選擇片組，整體方正且無歪斜 ,[NAME]。 Lengths 1 m Visual group, founder as a whole and there is no skew, adjust the rod interference-free choice | 目視 Visual | B
 | 4 | 坐背墊類 [NAME] | 孔位正確，與固定片對鎖不干涉  Correct location of holes and no interference after apply to fixing plate. | 目視 Visual | A
 | 5 | 鋼索、皮带 Cable/Belt | 鋼索/皮帶松緊合適;運動時不干涉其他部件;鏈接頭(孔)旋轉自由  Proper looseness and will not interfere with other part during using; connecting head could rotate smoothly | 手測&目視 Feeling and visual | A
 | 6 | 護蓋/網 Cover | 與車架配合間隙參照安規標準:≤9.5mm  Spacing to frame ≤9.5[NAME] | 卡尺 Calipers | A
 | 7 | 調整拉銷  [NAME] | 插銷螺絲需點膠，不可輕易拆卸  Loctite all pull pins and could not be easily disassembled | 手測&目視 Feeling and visual | A
 | 8 | 車架、基座、連結組、驅動組 frame | 組裝G準線良好,軸承組裝到位並加膠固定，軸承轉到順暢  Good alignment of frame. bearings should be properly assembled and glued | 目視  Visual | A
 | 9 | Arms | Arms balanced and aligned to be even at full extension and at rest | 目視/卷尺  Visual/Tape | B
 | 10 | Arms | Breaker Arms can be aligned properly | Visual | B
 | 11 | 五金件 Hardware | 規格正確,數目齊全;螺絲需耐落并鎖緊;具體緊固部位可查看爆炸圖驗證  Right specification and quantity; screws should have Loctite and  be secured; [NAME] to exploded diagram for details | 手測&目視 Feeling and visual | A
 | 12 | 五金件 Hardware | Hardware should be appropriately torqued | Torque Wrench | A
 | 13 | 五金件 Hardware | Loctite Evenly Applied on Bolts | Visual | A
 | 14 | 整機機構穩定性Stability | 正常使用時整機無晃動,各部件(如握把,護蓋,端蓋等)無鬆動,扭曲,脫落現象  No shaking during normal use, not loose, no twist and no parts fall off ( handles, end caps etc.) | 人機測試  Try on machine | A
功能Function | 15 | 整機運動順暢度 Smoothness | 運動時順暢但不鬆散，無頓點,無異音,[NAME],鋼索等連接處)  No rough movement, no noise, bearing and cable don't sticking | 人機測試  Try on machine | A
 | 16 | 選擇片類 weight stack | 選擇片插銷可輕松插入所有孔; 重量選擇片運動時順暢不會過緊，無頓點,無卡死  Pin fits each hole easily; weight stack could move easily and doesn't stick | 人機測試 Try on machine | A
 | 17 | 調節鎖緊機構 adjustment set | 調節鎖緊機構(輔助選擇片,座椅、背墊、腿墊、手柄調節拉銷等)調節順暢，定位準確  Smooth sliding/no excess play of adjustment sets ( incremental plate, seat adj. set, [NAME] set etc.) | 人機測試 Try on machine | A
 | 18 | [NAME] | 計數器計數準確，顯示清晰,[NAME],并確認電池是否鬆動容易脫落  Correctly counting and clear display make sure the battery is tight enough. | 目視 Visual | A
機台外觀Appearance | 19 | 烤漆 painting | 烤漆件漆面無色差﹑發黃生銹﹑掉漆﹑滑碰傷﹑針孔﹑麻點﹑亀裂﹑雪花狀等不良現象  No wrong color, rust, peeling, scratch, pinprick, cracking, flaws | 目視  Visual | B
 | 20 | 烤漆 painting | Complete and Even Clear Coat Application | 目視  Visual | B
 | 21 | 烤漆 painting | Frame and Stack Color Match | 目視  Visual | B
 | 22 | 選擇片 weight plate | 選擇片烤漆面無生鏽，漆面無脫落  No rust and peeling off of the painting | 目視 Visual | B
 | 23 | 選擇片 weight plate | No rust inside weight plate Holes | 目視  Visual | B
 | 24 | 焊道 weld seam | 焊道外觀無錯焊,漏焊,假焊,丑焊等現象  No wrong weld, missing weld, fake weld, ugly weld | 目視  Visual | A
 | 25 | 塑膠件/橡膠件 plastics / rubbers | 咬花符合設計,塑膠件/橡膠件表面無縮水、色差、毛邊、蝕痕等不良,橡膠無起泡現象  Texture meets design, no shrink, wrong color, blur erosion, no bubble of rubbers | 目視  Visual | A
 | 26 | 貼標 label | 貼標印刷內容正確;數字貼標位置正確,居中，無偏斜,無色差;機臺貼標位置正確，符合貼標示意圖;水印貼標無顆粒,無色差,無浮翹  Correctly printed, numbers on center, no decline, wrong color; apply correctly, meeting label location chart, no peeling | 對比樣品貼標示意圖   Label location chart | A
 | 27 | 電鍍件 plating parts | 各鍍件表面電鍍層符合圖紙要求(材質:鍍鉻/鋅/鎳等;顏色:如鍍黑色/金屬色鉻;鍍層形狀:光滑/噴沙/劃線等鍍面),無脫落,無劃傷,無發黃  Plating layer meet drawing ( material, color, shape), no peeling off, scratch, yellow | 目視  Visual | B
 | 28 | 鋼索 cable | 鋼索外觀無瑕疵，鋼索皮無脫落  No flaws , no peeling off | 目視 Visual | A
 | 29 | 端塞 end cap | 端塞表面無暇疵及鋒利棱角;不可用手輕易取下;無劃傷,無色差 No flaw, blur; secure tightly, no scratch or wrong color | 目視 Visual | B
 | 30 | 間隙與斷差 spacing & flush | 端蓋與管口等組件配合:[NAME]   Spacing <1.0mm, flush <1.0mm | 卡尺 Calipers | B
 | 31 | 坐背墊類 Pads | 坐背墊表面無瑕疵，無劃傷;坐背墊顏色正確,無色差，符合BOM要求 No flaws, scratch, and right color, meeting BOM | 目視 Visual | B
 | 32 | 沖孔 Holes | 管材件&鈑金件A級面孔內無毛邊無毛刺  No burs in the hole of A surface | 目視  Visual | A
 | 33 | 管材 [NAME] tube | [NAME]標準參考涂裝烤漆外觀標準） Tube without folds, MA, pinholes and sanding marks (standard coating paint appearance standards for reference) | 目視 Visual | A
包裝Packing | 34 | [NAME] | 紙箱表面無損傷，無污垢;外箱印刷內容正確;外箱上的條碼要與機臺條碼相符  No damage or dirt; right content of printing, s/n matches the machine | 目視  Visual | A
 | 35 | 紙箱貼標 [NAME] label | 貼標印刷內容及位置正確，外箱条码与机台条码一致 Right content and location, bar code on the carton match with the S/N on machine | 目視  Visual | A
 | 36 | 使用手冊&說明書 User manual | 使用者手冊 &組裝說明書與機種相符  Matches with the model | 目視  Visual | B
 | 37 | 五金零件包 Hardware bag | 五金零件包零件規格,數量正確  Right specification and quantity | 目視 Visual | A
 | 38 | 內包裝 Inside packing | 部件數目正確;部件位置正確，穩固無松動;烤漆面都用塑膠袋完整包覆，紙板不會碰觸零件  Right quantity, and location; no loose; painting parts should be packed with plastic bags and carton board can not contact with other parts | 目視  Visual | B
 | 39 | 攻牙 Need Taping | 需要攻牙 [NAME] | 目視  Visual | B
 | 40 | 包裝方式Packaging Material | 兩邊機台調整握把必須朝內，兩個車架之間增加紙板隔開,包裝前確認護蓋無碰劃傷。 The adjusting handlebars on the two side frames must face inside, adding cartons between the two frames and checking the shroud no scratches before packaging. | 目視  Visual | A
Other | 41 | Other defects found with no specifications or standards. |  | Visual/Gauge/Human testing
 | 42
 | 43
 | 44
附加檢驗Others | 客抱 内容Scar | 根據不同機種填寫客報內容并納入重點檢查項目 Included under the different species of fill in content and focus on projects
備註:等級A:嚴重缺陷---產品不符合客人特殊的要求事項,影響到產品的功能/結構;存在安全隱患,可能會造成客戶端批量不良或出貨後在客戶端重工的.等級B:重要缺陷---產品不符合客人的要求事項,可能存在潛在性的風險,但不會有結構和功能的影響,不會造成客戶的退貨. 等級C: 次要缺陷---產品不符合要求,但處於臨界狀態,不會有功能/組裝上的影響,不會造成客戶的退貨,一般為外觀要求事項 Remark: Level A: Critical defect- product could not meet some special demands of customer and may effect product's function / structure; Have safety issue, and may cause lot defect or rework in the field. Level B: Major defect--Product could not meet the demand of customer, and may have potential risk, but don't have function or structure issue causing products return back. Level C: Minor defect--Product could not meet demand of customer, but don't have any effect of function or assembly and will not cause products return back. Normally appearance issues. |  |  |  |  | 产线判定 Production verdict |  |  |  | 品保判定QC verdict
 |  |  | 注：一式三聯.白聯品保.紅聯客戶.綠聯產線                                                                     文件編號: