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

 |  |  |  |  |  |  |  |  | Number of defects and observations found
Strength Product Inspection Form |  |  |  |  |  |  |  |  | Major | Minor | Observation
 | Material Number: MPL0051-02 |  | Model Number: MG-PL33
 | Date: 5/18/2020 |  | Inspector:
 |  |  |  |  |  | PL08BE1906G056 |  |  | PL08BE1906G059 |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number |  |  | Serial Number
Items | # | Inspection Standards | Inspection Methods | Tools | Level | Result | Defects | Notes | Result | Defects | Notes | Result | Defects | Notes | Result | Defects | Notes | Result | Defects | Notes | Result | Defects | Notes | Result | Defects | Notes | Result | Defects | Notes
 | 1 | Ergonomics Dimensions | Ergonomics meet drawing and good alignment. Unit assembles according to assembly guide. | Tape Measure | A | Observation |  | This unit does not have an adjustable seat. In order for a shorter user to be able to use the machine they would first have to start in a standing position and then sit down. I am six feet tall and I can barely reach the handles. [NAME] (pictured) is 5'8". | Observation |  | This unit does not have an adjustable seat. In order for a shorter user to be able to use the machine they would first have to start in a standing position and then sit down. I am six feet tall and I can barely reach the handles. [NAME] (pictured) is 5'8".
Structure | 1 | Ergonomics Dimensions | Ergonomics meet drawing and good alignment. Unit assembles according to assembly guide. | Tape Measure | A | Observation |  | Alignment settings for the knee pad has needless range. When placed at the 1 and 2 settings it would be vritually impossible for anyone regardless of how short their legs are to use the machine. | Observation |  | Alignment settings for the knee pad has needless range. When placed at the 1 and 2 settings it would be vritually impossible for anyone regardless of how short their legs are to use the machine.
 | 2 | Cam & Pulley | Run out tolerance of cam < 2MM, | Calipers | A | N/A
 | 3 | Weight Plate | Weight plates are not damaged and stack evenly. No interference with gude rods. | Visual | B | N/A
 | 4 | Pad | Correct location of holes and no interference after apply to fixing plate. | Visual | A | Accept |  |  | Accept
 | 5 | Cable/Belt | Proper looseness and will not interfere with other part during using; connecting head could rotate smoothly | Feeling and visual | A | N/A
 | 6 | Cover | Spacing to frame ≤9.5[NAME] | Calipers | A | N/A
 | 7 | Pull Pin | Loctite on all pull pins, cannot be easily disassembled. | Test | A
 | 8 | Frame | Good alignment of frame. bearings should be properly assembled and glued. | Visual | A | Accept |  |  | Major |  | Frame was excessively difficult to align when attempting to put the bolts in. Required use of an alignment tool and forcing of the bolt to be assembled. These are located directly under the seat. The previous machine had no difficulty in assembling at this location.
 | 9 | Arms | Arms balanced and aligned to be even at full extension and at rest | Visual/Tape | B | Accept |  |  | Accept
 | 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 | Accept |  |  | Accept
 | 12 | Hardware | Hardware should be appropriately torqued | Torque Wrench | A
 | 13 | Hardware | Loctite Evenly Applied on Bolts | Visual | A | Accept |  |  | Accept
 | 14 | Stability | No shaking during normal use, not loose, no twist and no parts fall off ( handles, end caps etc.) | Test unit | A | Accept |  |  | Accept
Function | 15 | Smoothness | No rough movement, no noise, bearing and cable don't sticking | Test unit | A | Accept |  |  | Accept
 | 16 | Weight stack | Pin fits each hole easily; weight stack could move easily and doesn't stick | Test unit | A
 | 17 | Adjustment set | Smooth sliding/no excess play of adjustment sets (incremental plate, seat adj. set, [NAME] set, etc.) | Test unit | A | Accept |  |  | Accept
 | 18 | Counter | Correctly counting and clear display make sure the battery is tight enough. | Visual | A
Appearance | 19 | Painting | Unit is painted the correct color. No rust, peeling, scratch, pinprick, cracking, flaws | Visual | B | Accept |  |  | Minor |  | 3cm scratch directly in front of user eyeline.
 | 20 | Painting | Complete and Even Clear Coat Application | Visual | B | Accept |  |  | Accept
 | 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 | Accept |  |  | Accept
 | 25 | Plastics / rubbers | Texture meets design, no shrink, wrong color, blur erosion, no bubble of rubbers | Visual | A | Accept |  |  | Accept
 | 26 | Label | Label is printed correctly, numbers on center, not crooked, correct color; applied correctly meeting label location chart, no peeling. | Label location chart | A | Accept |  |  | Accept
 | 27 | Plating parts | Plating layer meet drawing ( material, color, shape), no peeling, scratches, or yellowing of plating material. | Visual | B | Accept |  |  | Accept
 | 28 | Cable | No flaws, damages, or coating peeling off of cables. | Visual | A
 | 29 | End cap | No flaws, scratches or wrong color. [NAME] is secured tightly. | Visual | B | Accept |  |  | Accept
 | 30 | Spacing & flush | Spacing <1.0mm, flush <1.0mm | Calipers | B | Accept |  |  | Accept
 | 31 | Pads | Pads are the correct color. No flaws, scratches, or any damage. | Visual | B
 | 32 | Holes | No burrs in holes. | Visual | A | Major |  | Majority of holes had rust. While some bolts were not able to be smoothly inserted, it did not impact the ability to assemble the machine. One of the holes was found to have metal shavings inside of it. Some holes have not been blown clean with compressed air and had non-magnetic foreign material inside of them. | Major |  | Majority of holes had rust. While some bolts were not able to be smoothly inserted, it did not impact the ability to assemble the machine. Some holes have not been blown clean with compressed air and had non-magnetic foreign material inside of them.
 | 33 | Bending tube | No ripples/folds on frame tube bends. No pinholes or sanding marks. | Visual | A | Accept |  |  | Accept
Packing | 34 | Carton | No damage or dirt; right content of printing, s/n matches the machine | Visual | A | Major |  | Box extremely dirty. Had footprints on the top of it. | Major |  | Box severly damaged. (I cut the straps myself)
 | 35 | Carton label | Right content and location, bar code on the carton match with the S/N on machine | Visual | A | Accept |  |  | Accept
 | 36 | User manual | Matches with the model | Visual | B | Accept |  |  | Accept
 | 37 | Hardware bag | Right specification and quantity | Visual | A | Observation |  | The assembly guide calls for 12 diameter washers but the hardware bag labels the washers as 13. | Observation |  | The assembly guide calls for 12 diameter washers but the hardware bag labels the washers as 13.
 | 38 | Inside packing | Right quantity and location, no loose parts, painted parts should be packed with plastic bags and cardboard can not contact parts | Visual | B | Minor |  | [NAME] styrafoam. Blasting beads on interior. | Minor |  | [NAME] styrafoam. Blasting beads on interior.
 | 39 | [NAME] | [NAME] | Visual | B | Accept |  |  | Accept
 | 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 | Accept |  |  | Accept
Other | 41 | Other defects found with no specifications or standards. |  | Visual/Gauge/Human testing |  | Major |  | The styrafoam was broken in exactly the same place on both units. There is no support under the frame piece. | Major |  | The styrafoam was broken in exactly the same place on both units. There is no support under the frame piece.
 | 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
 |  |  | 注：一式三聯.白聯品保.紅聯客戶.綠聯產線                                                                     文件編號: