{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Weld Section Evaluation Results","Weld Section Result Instruction"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Weld Section Evaluation Results","index":0,"n_rows":80,"n_cols":13,"rows_kept":80,"cut":false,"hidden":false,"merged":[[40,0,40,17],[65,12,66,15],[79,0,79,1],[79,2,79,3],[79,4,79,6],[79,7,79,8],[77,0,77,1],[77,4,77,8],[78,0,78,1],[78,4,78,8],[74,0,74,1],[74,4,74,8],[75,0,75,1],[75,4,75,8],[76,0,76,1],[76,4,76,8],[71,0,71,1],[71,4,71,8],[72,0,72,1],[72,4,72,8],[73,0,73,1],[73,4,73,8],[68,0,68,1],[68,4,68,8],[69,0,69,1],[69,4,69,8],[70,0,70,1],[70,4,70,8],[64,0,64,8],[65,0,65,1],[65,3,65,8],[66,0,66,1],[66,4,66,8],[67,0,67,1],[67,4,67,8],[61,2,61,3],[62,0,62,1],[62,2,62,3],[62,4,63,8],[63,0,63,1],[63,2,63,3],[56,0,56,1],[56,2,56,3],[56,4,57,8],[57,0,57,1],[57,2,57,3],[58,0,61,0],[58,1,59,1],[58,4,61,8],[59,2,59,3],[60,1,61,1],[52,0,55,0],[52,1,53,1],[52,4,55,8],[53,2,53,3],[54,1,55,1],[55,2,55,3],[49,0,49,1],[49,2,49,3],[49,4,49,8],[50,0,50,1],[50,4,50,8],[51,0,51,1],[51,2,51,3],[51,4,51,8],[46,0,46,1],[46,4,46,8],[47,0,47,1],[47,2,47,3],[47,4,47,8],[48,0,48,1],[48,4,48,8],[41,0,41,17],[42,1,42,3],[42,4,45,17],[43,1,43,3],[45,0,45,1],[45,2,45,3],[18,0,21,0],[20,1,21,1],[27,0,27,1],[28,0,28,1],[26,0,26,1],[23,0,23,1],[2,4,5,17],[0,0,0,17],[1,0,1,17],[11,4,11,8],[3,1,3,3],[5,2,5,3],[7,2,7,3],[7,0,7,1],[2,1,2,3],[5,0,5,1],[6,0,6,1],[39,0,39,1],[39,2,39,3],[12,0,15,0],[16,0,16,1],[17,0,17,1],[37,0,37,1],[22,0,22,1],[11,2,11,3],[9,2,9,3],[6,4,6,8],[10,0,10,1],[8,0,8,1],[12,4,15,8],[9,0,9,1],[11,0,11,1],[7,4,7,8],[9,4,9,8],[10,4,10,8],[8,4,8,8],[16,4,17,8],[34,4,34,8],[22,4,23,8],[18,4,21,8],[23,2,23,3],[24,0,24,8],[25,3,25,8],[25,0,25,1],[21,2,21,3],[19,2,19,3],[14,1,15,1],[12,1,13,1],[22,2,22,3],[17,2,17,3],[16,2,16,3],[18,1,19,1],[15,2,15,3],[13,2,13,3],[38,0,38,1],[38,4,38,8],[33,4,33,8],[33,0,33,1],[36,4,36,8],[36,0,36,1],[34,0,34,1],[35,0,35,1],[37,4,37,8],[35,4,35,8],[27,4,27,8],[30,4,30,8],[29,0,29,1],[31,0,31,1],[32,0,32,1],[30,0,30,1],[29,4,29,8],[31,4,31,8],[26,20,26,21],[26,24,26,28],[27,20,27,21],[27,24,27,28],[25,12,26,15],[39,4,39,6],[39,7,39,8],[32,4,32,8],[28,4,28,8],[26,4,26,8],[30,20,30,21],[30,24,30,28],[31,20,31,21],[31,24,31,28],[28,20,28,21],[28,24,28,28],[29,20,29,21],[29,24,29,28],[34,20,34,21],[34,24,34,28],[35,20,35,21],[35,24,35,28],[32,20,32,21],[32,24,32,28],[33,20,33,21],[33,24,33,28],[38,20,38,21],[38,24,38,28],[36,20,36,21],[36,24,36,28],[37,20,37,21],[37,24,37,28]]}
["Windsor Machine Group:"]
["Weld Section Evaluation Results: "]
["Technician: ",null,null,null,"Weld Etch Specification"]
["Date:"]
["Fixture:",1,"Side:","A"]
["Requirement",null,"Results"]
["Thickness",null,1.4,{"$f":"IF(ISBLANK(C7),\"-\",IF(OR(C7=\"NA\"),\"NA\",IF(AND(OR(C7>=C8)),\"PASS\",IF(OR(C7<C8),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D7=\"PASS\")),\"PASS\",IF((OR(D7=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Wall Thickness Minimum",null,1.4,null,"Pivot Plate Thickness  5.0 +/-0.10 \nTube Thickness 1.40+0.15/-0.00 / Tube Thickness 1.50 +0.2 /-0.10"]
["Throat",null,3.036,{"$f":"IF(ISBLANK(C9),\"-\",IF(OR(C9=\"NA\"),\"NA\",IF(OR(C9>=C10),\"PASS\",IF(OR(C9<C10),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D9=\"PASS\")),\"PASS\",IF((OR(D9=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Throat Minimum",null,{"$f":"C7*0.6","v":0.84},null,"60% min of thickness of the thinner plate."]
["Bead Width",null,6.3949999999999996,{"$f":"IF(ISBLANK(C11),\"-\",IF(OR(C11=\"NA\"),\"NA\",IF(OR(C11>=C12),\"PASS\",IF(OR(C11<C12),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D11=\"PASS\")),\"PASS\",IF((OR(D11=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Bead Width Minimum",null,{"$f":"C7*1.5","v":2.0999999999999996},null,"At least 1.5 times the thickness of thinner plate."]
["Penetration","Vertical",0.26600000000000001,{"$f":"IF(ISBLANK(C13),\"-\",IF(OR(C13=\"NA\"),\"NA\",IF(OR(C13>=C17),\"PASS\",IF(OR(C13<C17),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D13=\"PASS\")),\"PASS\",IF((OR(D13=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C13),\"-\",C13*100/C7)","v":19.000000000000004}]
[null,"Horizontal",0.40200000000000002,{"$f":"IF(ISBLANK(C15),\"-\",IF(OR(C15=\"NA\"),\"NA\",IF(OR(C15>=C18),\"PASS\",IF(OR(C15<C18),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D15=\"PASS\")),\"PASS\",IF((OR(D15=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C15),\"-\",C15*100/C7)","v":28.714285714285719}]
[" Vertical Penetration Minimum",null,{"$f":"C7*0.1","v":0.13999999999999999},null,"10% minimum of the thinner metal."]
["Horizontal Penetration Minimum",null,{"$f":"C7*0.1","v":0.13999999999999999}]
["Leg","Vertical",3.5339999999999998,{"$f":"IF(ISBLANK(C19),\"-\",IF(OR(C19=\"NA\"),\"NA\",IF(OR(C19>=C23),\"PASS\",IF(OR(C19<C23),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D19=\"PASS\")),\"PASS\",IF((OR(D19=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C19),\"-\",C19*100/C7)","v":252.42857142857142}]
[null,"Horizontal",3.4060000000000001,{"$f":"IF(ISBLANK(C21),\"-\",IF(OR(C21=\"NA\"),\"NA\",IF(OR(C21>=C24),\"PASS\",IF(OR(C21<C24),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D21=\"PASS\")),\"PASS\",IF((OR(D21=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C21),\"-\",C21*100/C7)","v":243.28571428571431}]
[" Vertical Leg Minimum",null,{"$f":"C7*0.7","v":0.97999999999999987},null,"70% min of the thickness of the thinner plate."]
["Horizontal Leg Minimum",null,{"$f":"C7*0.7","v":0.97999999999999987}]
[]
[null,null,"OK / BAD",null,null,null,null,null,null,null,null,null,"Insert Picture Here"]
["Over Lap",null,"OK",{"$f":"IF(ISBLANK(C27),\"-\",IF(AND(OR(C27=\"OK\")),\"PASS\",IF(OR(C27=\"BAD\"),\"FAIL\",IF(OR(C27=\"NA\"),\"NA\"))))","v":"PASS"},"Not permitted in lengths as specified on the drawing.",null,null,null,null,{"$f":"IF((AND(D27=\"PASS\")),\"PASS\",IF((OR(D27=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Weld Cracks",null,"OK",{"$f":"IF(ISBLANK(C28),\"-\",IF(AND(OR(C28=\"OK\")),\"PASS\",IF(OR(C28=\"BAD\"),\"FAIL\",IF(OR(C28=\"NA\"),\"NA\"))))","v":"PASS"},"None permitted.",null,null,null,null,"PASS"]
["Welding Penatration",null,"NA","NA","10% minimum of the thinner metal",null,null,null,null,"PASS"]
["Discontinuation in Bead",null,"OK","PASS","Bead shall be continous in weld.",null,null,null,null,"PASS"]
["Minimum Root Penetration",null,"NA","NA","10% T1 (0.14) . For Parts that have less than 10% T1 Weld penetration; follow weld repair procedures",null,null,null,null,"PASS"]
["Hole",null,"OK","PASS","No hole in weld due to burn-through is permissable.",null,null,null,null,"PASS"]
["Inclusions",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Porosity",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Notching",null,"NA","NA","Must not exceed stock thickness and to decrease to zero at or before the root of the weld",null,null,null,null,"PASS"]
["Skips",null,"OK","PASS","None permitted.",null,null,null,null,"PASS"]
["Maximum under cut in each weld length",null,"NA","NA","First and last 13mm (.50 in), 10% T1 (0.14), Remainder of length 20 % T1 (0.28)",null,null,null,null,"PASS"]
["Burn-Through",null,"OK","PASS","No detrimental burn-through causing reduction in joint cross section or concentration of stress is permissable",null,null,null,null,"PASS"]
["Blow Hole",null,"NA","NA","Blowholes or group of blowholes shall be dispersed with intervals of 50mm min.  Regardless of the number of blowholes, the total open area shall be 1mm squared max.",null,null,null,null,"PASS"]
["PASS / FAIL",null,{"$f":"IF(ISBLANK(C7),\"-\",IF(ISBLANK(C13),\"-\",IF(ISBLANK(C19),\"-\",IF(ISBLANK(C27),\"-\",IF(ISBLANK(C33),\"-\",IF(ISBLANK(C39),\"-\",IF(AND(J7=\"PASS\",J9=\"PASS\",J11=\"PASS\",J13=\"PASS\",J15=\"PASS\",J19=\"PASS\",J21=\"PASS\",J27=\"PASS\",J28=\"PASS\",J29=\"PASS\",J30=\"PASS\",J31=\"PASS\",J32=\"PASS\",J33=\"PASS\",J34=\"PASS\",J35=\"PASS\",J36=\"PASS\",J37=\"PASS\",J38=\"PASS\",J38=\"PASS\",J39=\"PASS\"),\"PASS\",\"FAIL\")))))))","v":"PASS"},null,"Final disposition"]
["Windsor Machine Group: "]
["Weld Etch Evaluation Results: "]
["Technician: ","Simon Cheng",null,null,"Weld Etch Specification"]
["Date:","2012-04-10"]
["Fixture:",1,"Side:","B"]
["Requirement",null,"Results"]
["Thickness",null,1.4,{"$f":"IF(ISBLANK(C47),\"-\",IF(OR(C47=\"NA\"),\"NA\",IF(AND(OR(C47>=C48)),\"PASS\",IF(OR(C47<C48),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D47=\"PASS\")),\"PASS\",IF((OR(D47=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Wall Thickness Minimum",null,1.4,null,"Pivot Plate Thickness  5.0 +/-0.10 \nTube Thickness 1.40+0.15/-0.00 / Tube Thickness 1.50 +0.2 /-0.10"]
["Throat",null,1.2,{"$f":"IF(ISBLANK(C49),\"-\",IF(OR(C49=\"NA\"),\"NA\",IF(OR(C49>=C50),\"PASS\",IF(OR(C49<C50),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D49=\"PASS\")),\"PASS\",IF((OR(D49=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Throat Minimum",null,{"$f":"C47*0.6","v":0.84},null,"60% min of thickness of the thinner plate."]
["Bead Width",null,6.3949999999999996,{"$f":"IF(ISBLANK(C51),\"-\",IF(OR(C51=\"NA\"),\"NA\",IF(OR(C51>=C52),\"PASS\",IF(OR(C51<C52),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D51=\"PASS\")),\"PASS\",IF((OR(D51=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Bead Width Minimum",null,{"$f":"C47*1.5","v":2.0999999999999996},null,"At least 1.5 times the thickness of thinner plate."]
["Penetration","Vertical",0.26600000000000001,{"$f":"IF(ISBLANK(C53),\"-\",IF(OR(C53=\"NA\"),\"NA\",IF(OR(C53>=C57),\"PASS\",IF(OR(C53<C57),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D53=\"PASS\")),\"PASS\",IF((OR(D53=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C53),\"-\",C53*100/C47)","v":19.000000000000004}]
[null,"Horizontal",0.40200000000000002,{"$f":"IF(ISBLANK(C55),\"-\",IF(OR(C55=\"NA\"),\"NA\",IF(OR(C55>=C58),\"PASS\",IF(OR(C55<C58),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D55=\"PASS\")),\"PASS\",IF((OR(D55=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C55),\"-\",C55*100/C47)","v":28.714285714285719}]
[" Vertical Penetration Minimum",null,{"$f":"C47*0.1","v":0.13999999999999999},null,"10% minimum of the thinner metal."]
["Horizontal Penetration Minimum",null,{"$f":"C47*0.1","v":0.13999999999999999}]
["Leg","Vertical",3.5339999999999998,{"$f":"IF(ISBLANK(C59),\"-\",IF(OR(C59=\"NA\"),\"NA\",IF(OR(C59>=C63),\"PASS\",IF(OR(C59<C63),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D59=\"PASS\")),\"PASS\",IF((OR(D59=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C59),\"-\",C59*100/C47)","v":252.42857142857142}]
[null,"Horizontal",3.4060000000000001,{"$f":"IF(ISBLANK(C61),\"-\",IF(OR(C61=\"NA\"),\"NA\",IF(OR(C61>=C64),\"PASS\",IF(OR(C61<C64),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D61=\"PASS\")),\"PASS\",IF((OR(D61=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C61),\"-\",C61*100/C47)","v":243.28571428571431}]
[" Vertical Leg Minimum",null,{"$f":"C47*0.7","v":0.97999999999999987},null,"70% min of the thickness of the thinner plate."]
["Horizontal Leg Minimum",null,{"$f":"C47*0.7","v":0.97999999999999987}]
[]
[null,null,"OK / BAD",null,null,null,null,null,null,null,null,null,"Insert Picture Here"]
["Over Lap",null,"OK",{"$f":"IF(ISBLANK(C67),\"-\",IF(AND(OR(C67=\"OK\")),\"PASS\",IF(OR(C67=\"BAD\"),\"FAIL\",IF(OR(C67=\"NA\"),\"NA\"))))","v":"PASS"},"Not permitted in lengths as specified on the drawing.",null,null,null,null,{"$f":"IF((AND(D67=\"PASS\")),\"PASS\",IF((OR(D67=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Weld Cracks",null,"OK",{"$f":"IF(ISBLANK(C68),\"-\",IF(AND(OR(C68=\"OK\")),\"PASS\",IF(OR(C68=\"BAD\"),\"FAIL\",IF(OR(C68=\"NA\"),\"NA\"))))","v":"PASS"},"None permitted.",null,null,null,null,"PASS"]
["Welding Penatration",null,"NA","NA","10% minimum of the thinner metal",null,null,null,null,"PASS"]
["Discontinuation in Bead",null,"OK","PASS","Bead shall be continous in weld.",null,null,null,null,"PASS"]
["Minimum Root Penetration",null,"NA","NA","10% T1 (0.14) . For Parts that have less than 10% T1 Weld penetration; follow weld repair procedures",null,null,null,null,"PASS"]
["Hole",null,"OK","PASS","No hole in weld due to burn-through is permissable.",null,null,null,null,"PASS"]
["Inclusions",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Porosity",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Notching",null,"NA","NA","Must not exceed stock thickness and to decrease to zero at or before the root of the weld",null,null,null,null,"PASS"]
["Skips",null,"OK","PASS","None permitted.",null,null,null,null,"PASS"]
["Maximum under cut in each weld length",null,"NA","NA","First and last 13mm (.50 in), 10% T1 (0.14), Remainder of length 20 % T1 (0.28)",null,null,null,null,"PASS"]
["Burn-Through",null,"OK","PASS","No detrimental burn-through causing reduction in joint cross section or concentration of stress is permissable",null,null,null,null,"PASS"]
["Blow Hole",null,"NA","NA","Blowholes or group of blowholes shall be dispersed with intervals of 50mm min.  Regardless of the number of blowholes, the total open area shall be 1mm squared max.",null,null,null,null,"PASS"]
["PASS / FAIL",null,{"$f":"IF(ISBLANK(C47),\"-\",IF(ISBLANK(C53),\"-\",IF(ISBLANK(C59),\"-\",IF(ISBLANK(C67),\"-\",IF(ISBLANK(C73),\"-\",IF(ISBLANK(C79),\"-\",IF(AND(J47=\"PASS\",J49=\"PASS\",J51=\"PASS\",J53=\"PASS\",J55=\"PASS\",J59=\"PASS\",J61=\"PASS\",J67=\"PASS\",J68=\"PASS\",J69=\"PASS\",J70=\"PASS\",J71=\"PASS\",J72=\"PASS\",J73=\"PASS\",J74=\"PASS\",J75=\"PASS\",J76=\"PASS\",J77=\"PASS\",J78=\"PASS\",J78=\"PASS\",J79=\"PASS\"),\"PASS\",\"FAIL\")))))))","v":"PASS"},null,"Final disposition"]

{"sheet":"Weld Section Result Instruction","index":1,"n_rows":80,"n_cols":13,"rows_kept":80,"cut":false,"hidden":false,"merged":[[30,0,30,1],[30,4,30,8],[37,4,37,8],[38,0,38,1],[32,0,32,1],[32,4,32,8],[36,0,36,1],[36,4,36,8],[33,0,33,1],[33,4,33,8],[23,2,23,3],[29,0,29,1],[29,4,29,8],[26,0,26,1],[27,0,27,1],[27,4,27,8],[28,4,28,8],[28,0,28,1],[11,4,11,8],[12,4,15,8],[16,2,16,3],[16,0,16,1],[16,4,17,8],[22,2,22,3],[17,0,17,1],[17,2,17,3],[6,4,6,8],[8,0,8,1],[8,4,8,8],[9,0,9,1],[9,4,9,8],[10,0,10,1],[10,4,10,8],[7,0,7,1],[7,4,7,8],[31,0,31,1],[31,4,31,8],[0,0,0,17],[1,0,1,17],[2,1,2,3],[2,4,5,17],[3,1,3,3],[5,0,5,1],[5,2,5,3],[6,0,6,1],[34,4,34,8],[34,0,34,1],[56,0,56,1],[35,0,35,1],[35,4,35,8],[37,0,37,1],[38,4,38,8],[39,0,39,1],[58,0,61,0],[58,1,59,1],[58,4,61,8],[59,2,59,3],[60,1,61,1],[61,2,61,3],[7,2,7,3],[9,2,9,3],[11,2,11,3],[12,0,15,0],[12,1,13,1],[13,2,13,3],[14,1,15,1],[15,2,15,3],[11,0,11,1],[18,0,21,0],[18,1,19,1],[18,4,21,8],[19,2,19,3],[20,1,21,1],[21,2,21,3],[25,12,26,15],[26,4,26,8],[26,20,26,21],[26,24,26,28],[22,0,22,1],[22,4,23,8],[24,0,24,8],[25,0,25,1],[25,3,25,8],[23,0,23,1],[29,20,29,21],[29,24,29,28],[30,20,30,21],[30,24,30,28],[27,20,27,21],[27,24,27,28],[28,20,28,21],[28,24,28,28],[33,20,33,21],[33,24,33,28],[34,20,34,21],[34,24,34,28],[31,20,31,21],[31,24,31,28],[32,20,32,21],[32,24,32,28],[37,24,37,28],[38,20,38,21],[38,24,38,28],[35,20,35,21],[35,24,35,28],[36,20,36,21],[36,24,36,28],[45,2,45,3],[39,2,39,3],[39,4,39,6],[39,7,39,8],[40,0,40,17],[37,20,37,21],[46,0,46,1],[46,4,46,8],[47,0,47,1],[47,2,47,3],[47,4,47,8],[41,0,41,17],[42,1,42,3],[42,4,45,17],[43,1,43,3],[45,0,45,1],[50,0,50,1],[50,4,50,8],[51,0,51,1],[51,2,51,3],[51,4,51,8],[48,0,48,1],[48,4,48,8],[49,0,49,1],[49,2,49,3],[49,4,49,8],[56,2,56,3],[56,4,57,8],[57,0,57,1],[57,2,57,3],[52,0,55,0],[52,1,53,1],[52,4,55,8],[53,2,53,3],[54,1,55,1],[55,2,55,3],[65,12,66,15],[66,0,66,1],[66,4,66,8],[62,0,62,1],[62,2,62,3],[62,4,63,8],[63,2,63,3],[63,0,63,1],[67,0,67,1],[67,4,67,8],[68,0,68,1],[68,4,68,8],[64,0,64,8],[65,0,65,1],[65,3,65,8],[71,0,71,1],[71,4,71,8],[72,0,72,1],[72,4,72,8],[69,0,69,1],[69,4,69,8],[70,0,70,1],[70,4,70,8],[75,0,75,1],[75,4,75,8],[76,0,76,1],[76,4,76,8],[73,0,73,1],[73,4,73,8],[74,0,74,1],[74,4,74,8],[79,0,79,1],[79,2,79,3],[79,4,79,6],[79,7,79,8],[77,0,77,1],[77,4,77,8],[78,0,78,1],[78,4,78,8]]}
["Windsor Machine Group: G&R 1"]
["Weld Section Evaluation Results: "]
["Technician: ",null,null,null,"Weld Etch Specification"]
["Date:"]
["Fixture:",1,"Side:","A"]
["Requirement",null,"Results"]
["Thickness",null,1.4,{"$f":"IF(ISBLANK(C7),\"-\",IF(OR(C7=\"NA\"),\"NA\",IF(AND(OR(C7>=C8)),\"PASS\",IF(OR(C7<C8),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D7=\"PASS\")),\"PASS\",IF((OR(D7=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Wall Thickness Minimum",null,1.4,null,"Pivot Plate Thickness  5.0 +/-0.10 \nTube Thickness 1.40+0.15/-0.00 / Tube Thickness 1.50 +0.2 /-0.10"]
["Throat",null,3.036,{"$f":"IF(ISBLANK(C9),\"-\",IF(OR(C9=\"NA\"),\"NA\",IF(OR(C9>=C10),\"PASS\",IF(OR(C9<C10),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D9=\"PASS\")),\"PASS\",IF((OR(D9=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Throat Minimum",null,{"$f":"C7*0.6","v":0.84},null,"60% min of thickness of the thinner plate."]
["Bead Width",null,6.3949999999999996,{"$f":"IF(ISBLANK(C11),\"-\",IF(OR(C11=\"NA\"),\"NA\",IF(OR(C11>=C12),\"PASS\",IF(OR(C11<C12),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D11=\"PASS\")),\"PASS\",IF((OR(D11=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Bead Width Minimum",null,{"$f":"C7*1.5","v":2.0999999999999996},null,"At least 1.5 times the thickness of thinner plate."]
["Penetration","Vertical","NA",{"$f":"IF(ISBLANK(C13),\"-\",IF(OR(C13=\"NA\"),\"NA\",IF(OR(C13>=C17),\"PASS\",IF(OR(C13<C17),\"FAIL\"))))","v":"NA"},null,null,null,null,null,{"$f":"IF((AND(D13=\"PASS\")),\"PASS\",IF((OR(D13=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C13),\"-\",C13*100/C7)","v":{"$error":"#VALUE!"}}]
[null,"Horizontal","NA",{"$f":"IF(ISBLANK(C15),\"-\",IF(OR(C15=\"NA\"),\"NA\",IF(OR(C15>=C18),\"PASS\",IF(OR(C15<C18),\"FAIL\"))))","v":"NA"},null,null,null,null,null,{"$f":"IF((AND(D15=\"PASS\")),\"PASS\",IF((OR(D15=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C15),\"-\",C15*100/C7)","v":{"$error":"#VALUE!"}}]
[" Vertical Penetration Minimum",null,{"$f":"C7*0.1","v":0.13999999999999999},null,"10% minimum of the thinner metal."]
["Horizontal Penetration Minimum",null,{"$f":"C7*0.1","v":0.13999999999999999}]
["Leg","Vertical",3.5339999999999998,{"$f":"IF(ISBLANK(C19),\"-\",IF(OR(C19=\"NA\"),\"NA\",IF(OR(C19>=C23),\"PASS\",IF(OR(C19<C23),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D19=\"PASS\")),\"PASS\",IF((OR(D19=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C19),\"-\",C19*100/C7)","v":252.42857142857142}]
[null,"Horizontal",3.4060000000000001,{"$f":"IF(ISBLANK(C21),\"-\",IF(OR(C21=\"NA\"),\"NA\",IF(OR(C21>=C24),\"PASS\",IF(OR(C21<C24),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D21=\"PASS\")),\"PASS\",IF((OR(D21=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C21),\"-\",C21*100/C7)","v":243.28571428571431}]
[" Vertical Leg Minimum",null,{"$f":"C7*0.7","v":0.97999999999999987},null,"70% min of the thickness of the thinner plate."]
["Horizontal Leg Minimum",null,{"$f":"C7*0.7","v":0.97999999999999987}]
[]
[null,null,"OK / BAD",null,null,null,null,null,null,null,null,null,"Insert Picture Here"]
["Over Lap",null,"OK",{"$f":"IF(ISBLANK(C27),\"-\",IF(AND(OR(C27=\"OK\")),\"PASS\",IF(OR(C27=\"BAD\"),\"FAIL\",IF(OR(C27=\"NA\"),\"NA\"))))","v":"PASS"},"Not permitted in lengths as specified on the drawing.",null,null,null,null,{"$f":"IF((AND(D27=\"PASS\")),\"PASS\",IF((OR(D27=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Weld Cracks",null,"OK",{"$f":"IF(ISBLANK(C28),\"-\",IF(AND(OR(C28=\"OK\")),\"PASS\",IF(OR(C28=\"BAD\"),\"FAIL\",IF(OR(C28=\"NA\"),\"NA\"))))","v":"PASS"},"None permitted.",null,null,null,null,"PASS"]
["Welding Penatration",null,"NA","NA","10% minimum of the thinner metal",null,null,null,null,"PASS"]
["Discontinuation in Bead",null,"OK","PASS","Bead shall be continous in weld.",null,null,null,null,"PASS"]
["Minimum Root Penetration",null,"NA","NA","10% T1 (0.14) . For Parts that have less than 10% T1 Weld penetration; follow weld repair procedures",null,null,null,null,"PASS"]
["Hole",null,"OK","PASS","No hole in weld due to burn-through is permissable.",null,null,null,null,"PASS"]
["Inclusions",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Porosity",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Notching",null,"NA","NA","Must not exceed stock thickness and to decrease to zero at or before the root of the weld",null,null,null,null,"PASS"]
["Skips",null,"OK","PASS","None permitted.",null,null,null,null,"PASS"]
["Maximum under cut in each weld length",null,"NA","NA","First and last 13mm (.50 in), 10% T1 (0.14), Remainder of length 20 % T1 (0.28)",null,null,null,null,"PASS"]
["Burn-Through",null,"OK","PASS","No detrimental burn-through causing reduction in joint cross section or concentration of stress is permissable",null,null,null,null,"PASS"]
["Blow Hole",null,"NA","NA","Blowholes or group of blowholes shall be dispersed with intervals of 50mm min.  Regardless of the number of blowholes, the total open area shall be 1mm squared max.",null,null,null,null,"PASS"]
["PASS / FAIL",null,{"$f":"IF(ISBLANK(C7),\"-\",IF(ISBLANK(C13),\"-\",IF(ISBLANK(C19),\"-\",IF(ISBLANK(C27),\"-\",IF(ISBLANK(C33),\"-\",IF(ISBLANK(C39),\"-\",IF(AND(J7=\"PASS\",J9=\"PASS\",J11=\"PASS\",J13=\"PASS\",J15=\"PASS\",J19=\"PASS\",J21=\"PASS\",J27=\"PASS\",J28=\"PASS\",J29=\"PASS\",J30=\"PASS\",J31=\"PASS\",J32=\"PASS\",J33=\"PASS\",J34=\"PASS\",J35=\"PASS\",J36=\"PASS\",J37=\"PASS\",J38=\"PASS\",J38=\"PASS\",J39=\"PASS\"),\"PASS\",\"FAIL\")))))))","v":"PASS"},null,"Final disposition"]
["Windsor Machine Group: "]
["Weld Etch Evaluation Results: "]
["Technician: ","Simon Cheng",null,null,"Weld Etch Specification"]
["Date:","2012-04-10"]
["Fixture:",1,"Side:","B"]
["Requirement",null,"Results"]
["Thickness",null,1.4,{"$f":"IF(ISBLANK(C47),\"-\",IF(OR(C47=\"NA\"),\"NA\",IF(AND(OR(C47>=C48)),\"PASS\",IF(OR(C47<C48),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D47=\"PASS\")),\"PASS\",IF((OR(D47=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Wall Thickness Minimum",null,1.4,null,"Pivot Plate Thickness  5.0 +/-0.10 \nTube Thickness 1.40+0.15/-0.00 / Tube Thickness 1.50 +0.2 /-0.10"]
["Throat",null,1.2,{"$f":"IF(ISBLANK(C49),\"-\",IF(OR(C49=\"NA\"),\"NA\",IF(OR(C49>=C50),\"PASS\",IF(OR(C49<C50),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D49=\"PASS\")),\"PASS\",IF((OR(D49=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Throat Minimum",null,{"$f":"C47*0.6","v":0.84},null,"60% min of thickness of the thinner plate."]
["Bead Width",null,6.3949999999999996,{"$f":"IF(ISBLANK(C51),\"-\",IF(OR(C51=\"NA\"),\"NA\",IF(OR(C51>=C52),\"PASS\",IF(OR(C51<C52),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D51=\"PASS\")),\"PASS\",IF((OR(D51=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Bead Width Minimum",null,{"$f":"C47*1.5","v":2.0999999999999996},null,"At least 1.5 times the thickness of thinner plate."]
["Penetration","Vertical",0.26600000000000001,{"$f":"IF(ISBLANK(C53),\"-\",IF(OR(C53=\"NA\"),\"NA\",IF(OR(C53>=C57),\"PASS\",IF(OR(C53<C57),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D53=\"PASS\")),\"PASS\",IF((OR(D53=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C53),\"-\",C53*100/C47)","v":19.000000000000004}]
[null,"Horizontal",0.40200000000000002,{"$f":"IF(ISBLANK(C55),\"-\",IF(OR(C55=\"NA\"),\"NA\",IF(OR(C55>=C58),\"PASS\",IF(OR(C55<C58),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D55=\"PASS\")),\"PASS\",IF((OR(D55=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C55),\"-\",C55*100/C47)","v":28.714285714285719}]
[" Vertical Penetration Minimum",null,{"$f":"C47*0.1","v":0.13999999999999999},null,"10% minimum of the thinner metal."]
["Horizontal Penetration Minimum",null,{"$f":"C47*0.1","v":0.13999999999999999}]
["Leg","Vertical",3.5339999999999998,{"$f":"IF(ISBLANK(C59),\"-\",IF(OR(C59=\"NA\"),\"NA\",IF(OR(C59>=C63),\"PASS\",IF(OR(C59<C63),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D59=\"PASS\")),\"PASS\",IF((OR(D59=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C59),\"-\",C59*100/C47)","v":252.42857142857142}]
[null,"Horizontal",3.4060000000000001,{"$f":"IF(ISBLANK(C61),\"-\",IF(OR(C61=\"NA\"),\"NA\",IF(OR(C61>=C64),\"PASS\",IF(OR(C61<C64),\"FAIL\"))))","v":"PASS"},null,null,null,null,null,{"$f":"IF((AND(D61=\"PASS\")),\"PASS\",IF((OR(D61=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,{"$f":"IF(ISBLANK(C61),\"-\",C61*100/C47)","v":243.28571428571431}]
[" Vertical Leg Minimum",null,{"$f":"C47*0.7","v":0.97999999999999987},null,"70% min of the thickness of the thinner plate."]
["Horizontal Leg Minimum",null,{"$f":"C47*0.7","v":0.97999999999999987}]
[]
[null,null,"OK / BAD",null,null,null,null,null,null,null,null,null,"Insert Picture Here"]
["Over Lap",null,"OK",{"$f":"IF(ISBLANK(C67),\"-\",IF(AND(OR(C67=\"OK\")),\"PASS\",IF(OR(C67=\"BAD\"),\"FAIL\",IF(OR(C67=\"NA\"),\"NA\"))))","v":"PASS"},"Not permitted in lengths as specified on the drawing.",null,null,null,null,{"$f":"IF((AND(D67=\"PASS\")),\"PASS\",IF((OR(D67=\"NA\")),\"PASS\",\"FAIL\"))","v":"PASS"}]
["Weld Cracks",null,"OK",{"$f":"IF(ISBLANK(C68),\"-\",IF(AND(OR(C68=\"OK\")),\"PASS\",IF(OR(C68=\"BAD\"),\"FAIL\",IF(OR(C68=\"NA\"),\"NA\"))))","v":"PASS"},"None permitted.",null,null,null,null,"PASS"]
["Welding Penatration",null,"NA","NA","10% minimum of the thinner metal",null,null,null,null,"PASS"]
["Discontinuation in Bead",null,"OK","PASS","Bead shall be continous in weld.",null,null,null,null,"PASS"]
["Minimum Root Penetration",null,"NA","NA","10% T1 (0.14) . For Parts that have less than 10% T1 Weld penetration; follow weld repair procedures",null,null,null,null,"PASS"]
["Hole",null,"OK","PASS","No hole in weld due to burn-through is permissable.",null,null,null,null,"PASS"]
["Inclusions",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Porosity",null,"NA","NA","Individual pinholes separated by at least their own diameter and other scattered porosity will be tolerated. Total length of porosity (sum of diameters) shall not exceed 6mm (.25 in) in any 25mm (1.0 in) of weld. Maximum pinhole diameter is not to exceed ",null,null,null,null,"PASS"]
["Notching",null,"NA","NA","Must not exceed stock thickness and to decrease to zero at or before the root of the weld",null,null,null,null,"PASS"]
["Skips",null,"OK","PASS","None permitted.",null,null,null,null,"PASS"]
["Maximum under cut in each weld length",null,"NA","NA","First and last 13mm (.50 in), 10% T1 (0.14), Remainder of length 20 % T1 (0.28)",null,null,null,null,"PASS"]
["Burn-Through",null,"OK","PASS","No detrimental burn-through causing reduction in joint cross section or concentration of stress is permissable",null,null,null,null,"PASS"]
["Blow Hole",null,"NA","NA","Blowholes or group of blowholes shall be dispersed with intervals of 50mm min.  Regardless of the number of blowholes, the total open area shall be 1mm squared max.",null,null,null,null,"PASS"]
["PASS / FAIL",null,{"$f":"IF(ISBLANK(C47),\"-\",IF(ISBLANK(C53),\"-\",IF(ISBLANK(C59),\"-\",IF(ISBLANK(C67),\"-\",IF(ISBLANK(C73),\"-\",IF(ISBLANK(C79),\"-\",IF(AND(J47=\"PASS\",J49=\"PASS\",J51=\"PASS\",J53=\"PASS\",J55=\"PASS\",J59=\"PASS\",J61=\"PASS\",J67=\"PASS\",J68=\"PASS\",J69=\"PASS\",J70=\"PASS\",J71=\"PASS\",J72=\"PASS\",J73=\"PASS\",J74=\"PASS\",J75=\"PASS\",J76=\"PASS\",J77=\"PASS\",J78=\"PASS\",J78=\"PASS\",J79=\"PASS\"),\"PASS\",\"FAIL\")))))))","v":"PASS"},null,"Final disposition"]