{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Audit Questionnaire","Formulas"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Audit Questionnaire","index":0,"n_rows":230,"n_cols":23,"rows_kept":230,"cut":false,"hidden":false,"merged":[[202,2,202,3],[203,2,203,3],[204,2,204,3],[196,4,196,18],[197,4,197,18],[198,4,198,18],[199,4,199,18],[200,4,200,18],[201,4,201,18],[202,4,202,18],[203,4,203,18],[204,4,204,18],[189,2,189,3],[189,4,189,18],[180,2,180,3],[181,2,181,3],[182,2,182,3],[183,2,183,3],[184,2,184,3],[185,2,185,3],[180,4,180,18],[181,4,181,18],[182,4,182,18],[183,4,183,18],[184,4,184,18],[185,4,185,18],[187,2,187,3],[187,4,187,18],[188,4,188,18],[188,2,188,3],[84,4,84,10],[44,19,44,20],[42,2,42,10],[48,2,48,10],[2,12,2,20],[15,0,15,3],[0,0,1,20],[2,0,2,11],[47,15,47,16],[41,13,41,14],[42,13,42,14],[43,13,43,14],[45,13,45,14],[46,13,46,14],[47,13,47,14],[51,13,51,14],[52,13,52,14],[50,15,50,16],[45,2,45,10],[45,19,45,20],[46,2,46,10],[46,19,46,20],[47,2,47,10],[47,19,47,20],[102,2,102,20],[103,2,103,20],[16,0,16,3],[24,0,24,20],[28,2,28,20],[30,2,30,20],[32,2,32,20],[40,0,40,10],[19,0,19,3],[19,5,19,9],[41,0,41,1],[41,2,41,10],[41,19,41,20],[42,0,47,1],[42,19,42,20],[43,2,43,10],[43,19,43,20],[41,15,41,16],[42,15,42,16],[43,15,43,16],[45,15,45,16],[46,15,46,16],[44,2,44,10],[84,11,84,16],[56,2,56,10],[56,19,56,20],[63,15,63,16],[48,19,48,20],[49,2,49,10],[49,19,49,20],[50,2,50,10],[54,2,54,10],[54,19,54,20],[55,2,55,10],[55,19,55,20],[48,15,48,16],[49,15,49,16],[48,13,48,14],[49,13,49,14],[50,19,50,20],[51,2,51,10],[51,19,51,20],[52,2,52,10],[52,19,52,20],[53,2,53,10],[61,13,61,14],[83,17,83,19],[48,0,73,1],[62,19,62,20],[64,19,64,20],[65,19,65,20],[53,19,53,20],[50,13,50,14],[67,19,67,20],[68,19,68,20],[67,13,67,14],[68,13,68,14],[65,15,65,16],[57,2,57,10],[57,19,57,20],[58,2,58,10],[58,19,58,20],[59,2,59,10],[59,19,59,20],[59,13,59,14],[57,15,57,16],[58,15,58,16],[59,15,59,16],[66,15,66,16],[60,2,60,10],[107,4,107,12],[107,13,107,19],[108,4,108,12],[85,17,85,19],[86,4,86,10],[86,11,86,16],[63,19,63,20],[60,13,60,14],[111,4,111,12],[64,13,64,14],[65,13,65,14],[66,13,66,14],[76,2,77,20],[80,0,80,20],[81,1,82,1],[81,2,82,2],[81,3,82,3],[69,19,69,20],[70,19,70,20],[72,19,72,20],[69,13,69,14],[70,13,70,14],[71,13,71,14],[81,0,88,0],[149,18,149,20],[144,4,144,12],[145,4,145,12],[146,4,146,12],[147,4,147,12],[132,4,132,12],[133,4,133,12],[135,4,135,12],[136,4,136,12],[137,4,137,12],[143,4,143,12],[140,13,140,19],[141,13,141,19],[142,13,142,19],[143,13,143,19],[138,13,138,19],[139,13,139,19],[135,13,135,19],[136,13,136,19],[137,13,137,19],[142,4,142,12],[138,4,138,12],[139,4,139,12],[140,4,140,12],[166,19,166,20],[158,2,158,20],[159,2,159,20],[160,2,160,20],[161,2,161,20],[157,2,157,20],[162,2,162,20],[163,2,163,20],[150,0,150,20],[164,2,164,20],[167,19,167,20],[168,19,168,20],[169,19,169,20],[170,19,170,20],[171,19,171,20],[172,19,172,20],[173,19,173,20],[171,4,171,18],[174,4,174,18],[173,4,173,18],[169,2,169,3],[170,2,170,3],[171,2,171,3],[166,2,166,3],[167,2,167,3],[168,2,168,3],[167,4,167,18],[168,4,168,18],[169,4,169,18],[170,4,170,18],[166,4,166,18],[191,4,191,18],[190,4,190,18],[186,19,186,20],[178,19,178,20],[179,19,179,20],[175,4,175,18],[174,2,174,3],[174,19,174,20],[172,4,172,18],[178,2,178,3],[179,2,179,3],[186,2,186,3],[175,2,175,3],[176,2,176,3],[177,2,177,3],[175,19,175,20],[176,19,176,20],[177,19,177,20],[172,2,172,3],[173,2,173,3],[190,2,190,3],[191,2,191,3],[190,19,190,20],[191,19,191,20],[205,2,205,3],[206,2,206,3],[207,2,207,3],[205,19,205,20],[206,19,206,20],[207,19,207,20],[193,2,193,3],[194,2,194,3],[195,2,195,3],[194,19,194,20],[195,19,195,20],[193,4,193,18],[194,4,194,18],[195,4,195,18],[205,4,205,18],[193,19,193,20],[206,4,206,18],[207,4,207,18],[196,2,196,3],[197,2,197,3],[198,2,198,3],[199,2,199,3],[200,2,200,3],[201,2,201,3],[211,2,211,3],[212,2,212,3],[213,2,213,3],[211,19,211,20],[212,19,212,20],[213,19,213,20],[208,2,208,3],[209,2,209,3],[210,2,210,3],[208,19,208,20],[209,19,209,20],[210,19,210,20],[208,4,208,18],[209,4,209,18],[210,4,210,18],[211,4,211,18],[219,2,219,3],[220,2,220,3],[221,2,221,3],[219,4,219,20],[220,4,220,20],[221,4,221,20],[217,2,217,3],[217,19,217,20],[214,2,214,3],[215,2,215,3],[216,2,216,3],[214,19,214,20],[215,19,215,20],[216,19,216,20],[215,4,215,18],[216,4,216,18],[217,4,217,18],[228,2,228,3],[228,4,228,20],[225,2,225,3],[226,2,226,3],[227,2,227,3],[225,4,225,20],[226,4,226,20],[227,4,227,20],[222,2,222,3],[223,2,223,3],[224,2,224,3],[222,4,222,20],[223,4,223,20],[224,4,224,20],[141,4,141,12],[124,13,124,19],[83,11,83,16],[83,4,83,10],[109,4,109,12],[110,4,110,12],[113,4,113,12],[129,13,129,19],[111,13,111,19],[112,13,112,19],[113,13,113,19],[118,13,118,19],[120,4,120,12],[121,4,121,12],[122,4,122,12],[123,4,123,12],[124,4,124,12],[125,4,125,12],[114,4,114,12],[115,4,115,12],[112,4,112,12],[116,4,116,12],[114,13,114,19],[115,13,115,19],[117,4,117,12],[125,13,125,19],[126,13,126,19],[127,13,127,19],[128,13,128,19],[119,13,119,19],[120,13,120,19],[121,13,121,19],[122,13,122,19],[123,13,123,19],[126,4,126,12],[127,4,127,12],[128,4,128,12],[118,4,118,12],[119,4,119,12],[117,13,117,19],[116,13,116,19],[86,17,86,19],[87,4,87,10],[87,11,87,16],[87,17,87,19],[85,11,85,16],[85,4,85,10],[99,2,99,13],[100,2,100,13],[105,0,105,20],[95,2,95,3],[96,2,96,3],[97,2,97,3],[91,2,91,20],[92,2,92,3],[93,2,93,3],[94,2,94,3],[94,5,94,20],[95,5,95,20],[93,5,93,20],[96,5,96,20],[97,5,97,20],[92,5,92,20],[89,0,89,20],[101,2,101,20],[81,20,82,20],[73,19,73,20],[72,13,72,14],[53,13,53,14],[54,13,54,14],[55,13,55,14],[56,13,56,14],[57,13,57,14],[58,13,58,14],[66,19,66,20],[71,19,71,20],[60,19,60,20],[61,19,61,20],[60,15,60,16],[62,15,62,16],[63,13,63,14],[64,15,64,16],[71,15,71,16],[72,15,72,16],[64,2,64,10],[65,2,65,10],[66,2,66,10],[67,2,67,10],[81,17,82,19],[81,11,82,16],[68,2,68,10],[69,2,69,10],[70,2,70,10],[71,2,71,10],[72,2,72,10],[61,2,61,10],[62,2,62,10],[63,2,63,10],[73,13,73,14],[67,15,67,16],[68,15,68,16],[69,15,69,16],[70,15,70,16],[73,15,73,16],[61,15,61,16],[81,4,82,10],[62,13,62,14],[4,0,4,3],[5,0,5,3],[7,0,7,3],[8,0,8,3],[4,4,4,10],[88,18,88,20],[212,4,212,18],[213,4,213,18],[214,4,214,18],[176,4,176,18],[177,4,177,18],[178,4,178,18],[179,4,179,18],[186,4,186,18],[106,0,149,0],[154,2,154,20],[155,2,155,20],[156,2,156,20],[144,13,144,19],[145,13,145,19],[146,13,146,19],[147,13,147,19],[106,4,106,12],[106,13,106,19],[8,4,8,10],[9,4,9,10],[12,4,12,10],[4,12,4,14],[5,12,5,14],[4,15,4,19],[5,15,5,19],[7,12,7,14],[7,15,7,19],[8,12,8,14],[8,15,8,19],[9,15,9,19],[12,15,12,19],[9,12,9,14],[7,4,7,10],[5,4,5,10],[11,4,11,10],[9,0,9,3],[12,0,12,3],[15,15,15,19],[16,15,16,19],[13,0,13,3],[14,0,14,3],[13,4,13,10],[14,4,14,10],[15,4,15,10],[16,4,16,10],[10,0,10,3],[10,4,10,10],[10,15,10,19],[11,1,11,3],[16,12,16,14],[12,12,12,14],[13,15,13,19],[14,12,14,14],[15,12,15,14],[18,12,18,14],[14,15,14,19],[17,0,17,3],[17,4,17,10],[17,15,17,19],[229,0,229,1],[84,17,84,19],[17,12,17,14],[21,2,21,5],[21,6,21,19],[18,15,18,19],[18,4,18,10],[35,0,35,20],[36,0,36,20],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[73,2,73,10],[108,13,108,19],[109,13,109,19],[110,13,110,19],[129,4,129,12],[130,4,130,12],[131,4,131,12],[132,13,132,19],[133,13,133,19],[134,13,134,19],[130,13,130,19],[134,4,134,12],[131,13,131,19],[200,19,200,20],[201,19,201,20],[202,19,202,20],[203,19,203,20],[204,19,204,20],[180,19,180,20],[181,19,181,20],[182,19,182,20],[183,19,183,20],[184,19,184,20],[185,19,185,20],[187,19,187,20],[188,19,188,20],[189,19,189,20],[196,19,196,20],[197,19,197,20],[198,19,198,20],[199,19,199,20]]}
["JDS-G223  供应商质量体系审核调查问卷\nV2.0"]
[]
["供应商信息",null,null,null,null,null,null,null,null,null,null,null,"审核信息"]
[]
["供应商代码：",null,null,null,null,null,null,null,null,null,null,null,"供应商认证系统审核号码："]
["供应商名称：",null,null,null,null,null,null,null,null,null,null,null,"实际审核日期："]
[]
["地址：",null,null,null,null,null,null,null,null,null,null,null,"主审员："]
[null,null,null,null,null,null,null,null,null,null,null,null,"审核小组成员："]
[]
[]
[null,null,null,null,"质量联系人"]
["姓名：",null,null,null,null,null,null,null,null,null,null,null,"其他小组成员："]
["职位："]
["电话号码："]
["电子邮件："]
["其他："]
[]
[]
[]
[]
[null,null,"审核的过程/产品："]
[]
[]
["注册证书"]
[null,null,"注：如事先未得到，应获取证书副本，且上传到供应商资格系统的认证库中。"]
[]
[null,null,"质量体系认证、注册机构及证书有效日期（ISO、IATF 等):"]
[]
[null,null,"环境体系认证、注册机构及证书有效日期 (ISO 14001)：  "]
[]
[null,null,"健康与安全体系认证、注册机构及证书有效日期 (ISO 45001、SA 8000)： "]
[]
[]
[]
["限制、结论及备注"]
["(最少需要120个字符)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["审核总结"]
["范畴",null,"部分",null,null,null,null,null,null,null,null,"总问题数","已回答问题","满分",null,"得分",null,"得分百分数","平均得分","符合度"]
["合规",null,"合规*",null,null,null,null,null,null,null,null,{"$f":"SUM(L44:L48)","v":5},{"$f":"SUM(M44:M48)","v":0},null,null,null,null,null,null,{"$f":"IF(COUNTIF(U84:U88,\"\")>0,\"未完成\",IF(AND(U84=\"YES\",OR(U85=\"NO\",U86=\"NO\",U87=\"NO\",U88=\"NO\")),\"跟进\",IF(COUNTIF(U84:U88,\"YES\")=5,\"符合\",\"不符合\")))","v":"未完成"}]
[null,null,"行为准则理解",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U84)","v":0},null,null,null,null,null,null,{"$f":"IF(LEFT(U84,1)=\"n\",\"不符合\",IF(LEFT(U84,1)=\"y\",\"符合\",\"未完成\"))","v":"未完成"}]
[null,null,"法规符合性",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U85)","v":0},null,null,null,null,null,null,{"$f":"IF(LEFT(U85,1)=\"n\",\"不符合\",IF(LEFT(U85,1)=\"y\",\"符合\",\"未完成\"))","v":"未完成"}]
[null,null,"管制材料",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U86)","v":0},null,null,null,null,null,null,"未完成"]
[null,null,"冲突物质",null,null,null,null,null,null,null,null,1,0,null,null,null,null,null,null,"未完成"]
[null,null,"行为准则观察",null,null,null,null,null,null,null,null,1,0,null,null,null,null,null,null,"未完成"]
["质量",null,"质量",null,null,null,null,null,null,null,null,{"$f":"SUM(L50,L53,L55,L61,L68,L71)","v":41},{"$f":"SUM(M50,M53,M55,M61,M68,M71)","v":0},{"$f":"SUM(N50,N53,N55,N61,N68,N71)","v":164},null,{"$f":"SUM(P50,P53,P55,P61,P68,P71)","v":0},null,{"$f":"P49/N49","v":0},{"$f":"IF(M49=L49,P49/M49,\"?\")","v":"?"},{"$f":"IF(ISNUMBER(S49),(IF(COUNTIF(T50:T73,\"不符合\")>0,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"4 - 组织环境",null,null,null,null,null,null,null,null,{"$f":"SUM(L51:L52)","v":2},{"$f":"SUM(M51:M52)","v":0},{"$f":"SUM(N51:O52)","v":8},null,{"$f":"SUM(P51:Q52)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S50),(IF(COUNTIF(T51:T52,\"不符合\")>0,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"4.3 - 质量管理体系的范围",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U123)","v":0},{"$f":"L51*4","v":4},null,{"$f":"U123","v":0},null,{"$f":"P51/N51","v":0},"?",{"$f":"IF(ISNUMBER(S51),(IF(MIN(U123)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"4.4 - 质量管理体系及其过程",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U128)","v":0},{"$f":"L52*4","v":4},null,{"$f":"(U128)","v":0},null,{"$f":"P52/N52","v":0},"?",{"$f":"IF(ISNUMBER(S52),(IF(MIN(U128)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"},null,null," "]
[null,null,"6 - 策划",null,null,null,null,null,null,null,null,{"$f":"SUM(L54)","v":2},{"$f":"SUM(M54)","v":0},{"$f":"SUM(N54)","v":8},null,{"$f":"SUM(P54)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S53),(IF(COUNTIF(T54,\"不符合\")>0,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"6.1 - 应对风险和机遇的措施",null,null,null,null,null,null,null,null,2,{"$f":"COUNTA(U111,U112)","v":0},{"$f":"L54*4","v":8},null,{"$f":"SUM(U111:U112)","v":0},null,{"$f":"P54/N54","v":0},"?",{"$f":"IF(ISNUMBER(S54),(IF(MIN(U111,U112)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"7 - 支持",null,null,null,null,null,null,null,null,{"$f":"SUM(L56:L60)","v":11},{"$f":"SUM(M56:M60)","v":0},{"$f":"SUM(N56:O60)","v":44},null,{"$f":"SUM(P56:Q60)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S55),(IF(COUNTIF(T56:T60,\"不符合\")>0,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"7.1 - 资源",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U136)","v":0},{"$f":"L56*4","v":4},null,{"$f":"SUM(U136)","v":0},null,{"$f":"P56/N56","v":0},"?",{"$f":"IF(ISNUMBER(S56),(IF(MIN(U136)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"7.1.5 - 监视和测量资源",null,null,null,null,null,null,null,null,6,{"$f":"COUNTA(U139,U140,U141,U142,U143,U144)","v":0},{"$f":"L57*4","v":24},null,{"$f":"SUM(U139:U144)","v":0},null,{"$f":"P57/N57","v":0},{"$f":"IF(M57=L57,P57/M57,\"?\")","v":"?"},{"$f":"IF(ISNUMBER(S57),(IF(MIN(U139,U140,U141,U142,U143,U144)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"7.2 - 能力",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U133)","v":0},4,null,{"$f":"SUM(U133)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S58),(IF(MIN(U133)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"7.3 - 意识",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U110)","v":0},4,null,{"$f":"SUM(U110)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S59),(IF(MIN(U110)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"7.5 - 成文信息",null,null,null,null,null,null,null,null,2,{"$f":"COUNTA(U109,U122)","v":0},8,null,{"$f":"SUM(U117:U118)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S60),(IF(MIN(U109,U122)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"8 - 运行",null,null,null,null,null,null,null,null,{"$f":"SUM(L62:L67)","v":19},{"$f":"SUM(M62:M67)","v":0},{"$f":"SUM(N62:O67)","v":76},null,{"$f":"SUM(P62:Q67)","v":0},null,0,{"$f":"IF(M61=L61,P61/M61,\"?\")","v":"?"},{"$f":"IF(ISNUMBER(S61),(IF(COUNTIF(T62:T67,\"不符合\")>0,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"8.1 - 运行的策划和控制",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U134)","v":0},{"$f":"L62*4","v":4},null,{"$f":"SUM(U134)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S62),(IF(MIN(U134)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"8.2 - 产品和服务的要求",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U115)","v":0},{"$f":"L63*4","v":4},null,{"$f":"SUM(U115)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S63),(IF(MIN(U115)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"8.3 - 产品和服务的设计和开发",null,null,null,null,null,null,null,null,5,{"$f":"COUNTA(U114,U116,U118,U120,U121)","v":0},20,null,{"$f":"SUM(U114,U116,U118,U120,U121)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S64),(IF(MIN(U114,U116,U118,U120,U121)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"8.4 - 外部提供的过程、产品和服务的控制",null,null,null,null,null,null,null,null,4,{"$f":"COUNTA(U124,U125,U126,U127)","v":0},16,null,{"$f":"SUM(U124,U125,U126,U127)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S65),(IF(MIN(U124,U125,U126,U127)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"8.5 - 生产和服务提供",null,null,null,null,null,null,null,null,5,{"$f":"COUNTA(U117,U145,U146,U147,U148)","v":0},20,null,{"$f":"SUM(U117,U145,U146,U147,U148)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S66),(IF(MIN(U117,U145,U146,U147,U148)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"8.7 - 不合格品输出的控制",null,null,null,null,null,null,null,null,3,{"$f":"COUNTA(U131,U137,U138)","v":0},12,null,{"$f":"SUM(U131,U137,U138)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S67),(IF(MIN(U131,U137,U138)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"9 - 绩效评价",null,null,null,null,null,null,null,null,{"$f":"SUM(L69:L70)","v":3},{"$f":"SUM(M69:M70)","v":0},{"$f":"SUM(N69:O70)","v":12},null,{"$f":"SUM(P69:Q70)","v":0},null,0,{"$f":"IF(M68=L68,P68/M68,\"?\")","v":"?"},{"$f":"IF(ISNUMBER(S68),(IF(COUNTIF(T69:T70,\"不符合\")>0,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"9.1 - 监视、测量、分析和评价",null,null,null,null,null,null,null,null,2,{"$f":"COUNTA(U119,U135)","v":0},{"$f":"L69*4","v":8},null,{"$f":"SUM(U119,U135)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S69),(IF(MIN(U119,U135)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"9.3 - 管理评审",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U108)","v":0},{"$f":"L70*4","v":4},null,{"$f":"SUM(U108)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S70),(IF(MIN(U108)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"10 - 改进",null,null,null,null,null,null,null,null,{"$f":"SUM(L72:L73)","v":4},{"$f":"SUM(M72:M73)","v":0},{"$f":"SUM(N72:O73)","v":16},null,{"$f":"SUM(P72:Q73)","v":0},null,0,{"$f":"IF(M71=L71,P71/M71,\"?\")","v":"?"},{"$f":"IF(ISNUMBER(S71),(IF(COUNTIF(T72:T73,\"不符合\")>0,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"10.2 - 不合格和纠正措施",null,null,null,null,null,null,null,null,3,{"$f":"COUNTA(U129,U130,U132)","v":0},{"$f":"L72*4","v":12},null,{"$f":"SUM(U129,U130,U132)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S72),(IF(MIN(U129,U130,U132)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"10.3 - 持续改进",null,null,null,null,null,null,null,null,1,{"$f":"COUNTA(U113)","v":0},{"$f":"L73*4","v":4},null,{"$f":"SUM(U113)","v":0},null,0,"?",{"$f":"IF(ISNUMBER(S73),(IF(MIN(U113)<2,\"不符合\",\"符合\")), \"未打分\")","v":"未打分"}]
[null,null,"总审核得分",null,null,null,null,null,null,null,null,{"$f":"SUM(L49)","v":41},{"$f":"SUM(M49)","v":0},{"$f":"N49","v":164},null,{"$f":"P49","v":0},null,0,{"$f":"IF(M74=L74,P74/M74,\"?\")","v":"?"},{"$f":"IF(OR(R74<=0.65,COUNTIF(T50:T73,\"不符合\")>0),\"不符合\",IF(COUNTIF(T50:T73,\"NOT SCORED\")>0,\"未打分\",\"COMPLIES\"))","v":"不符合"}]
[]
[]
[null,null," -  总共有46个问题。5个合规问题的评分为 \"yes / no\"。\n                              41个质量问题得分为“0-4”，满分为164分。\n * 评分为“no”的合规问题必须由主审核员通过90smcompliance@johndeere.com报告给: WWSM，合规部门经理。\n * 公司合规部将执行任何调查，确定最终解决方案，并向主审核员提供反馈。\n"]
[]
[]
[]
["合规"]
[null,"#","问题编号","质量手册参考","面谈问题",null,null,null,null,null,null,"观察标准",null,null,null,null,null,"记录和支持的证据",null,null,"观察"]
[]
[null,1,"CC01","4.2.2","Supplier has procedures in place designed to ensure that the requirements set out in John Deere’s Supplier Code of Conduct are met?\n供应商是否制定好了相关程序来确保《John Deere 供应商行为守则》中所列出的要求都得到满足？",null,null,null,null,null,null,"Is Supplier aware of the Deere code of conduct and know where to locate it? \n(Proceed if YES)     (STOP Audit if No)\n供应商是否知道 约翰迪尔的《供应商行为准则》，并知道可以在哪里获取？\n（如果是，则继续审核）  （如果不是，则停止审核）   "]
[null,2,"CC02","4.2.2","Does the supplier comply with the laws, rules, regulations, and John Deere policies of the countries, regions, and locations in which they operate and can evidence (permits, registrations, certifications, etc...) be shown to support?\n供应商是否遵守其运营所在国家、地区和地点的法律、法规、规章和约翰迪尔政策，并能提供证据（许可、注册、认证等）来支持?",null,null,null,null,null,null,"If YES, no additional action required. \nIf NO, notify WWSM, Compliance Manager at 90smcompliance@johndeere.com for further evaluation.\n如果是，无需额外行动。\n如果否，请通过90smcompliance@johndeere.com通知WWSM，合规经理进行进一步评估。"]
[null,3,"CC03","8.2.2.4","Supplier does not manufacture or provide products (to any customer) that contain substances in excess of the amount listed on John Deere’s Restricted Materials List (JDM H30) or other substances restricted by applicable laws? \n供应商不生产或提供(给任何客户)含有超出约翰迪尔限制材料清单(JDM H30)规定含量的物质或其他适用法律管制的物质的产品吗?",null,null,null,null,null,null,"If YES, no additional action required. \nIf NO, notify WWSM, Compliance Manager at 90smcompliance@johndeere.com for further evaluation.\n如果是，无需额外行动。\n如果否，请通过90smcompliance@johndeere.com通知WWSM，合规经理进行进一步评估。"]
[null,4,"CC04","4.2.2","Does the supplier manufacture or provide products containing Conflict Minerals (CM) as defined by applicable laws?  If yes, has the supplier submitted a Conflict Mineral's declaration as requested by John Deere?\n供应商生产或提供的产品是否含有适用法律规定的冲突矿物(CM)?如果是，供应商是否按照约翰迪尔的要求提交了冲突矿物的声明?",null,null,null,null,null,null,"Score as \"Yes\" if supplier does not provide products containing CM's or can submit a CM declaration when requested, if they are providing CM's.\nScore as \"No\" if supplier provides products containing CM's and has NOT submitted a CM's declaration. Notify WWSM, Compliance Manager at: 90smcompliance@johndeere.com for further evaluation. (CM = Tin, Tantalum, Tungsten and Gold)\n如果供应商提供的产品不含冲突矿物或如果供应商提供的产品含有冲突矿物，并且可以根据要求提交冲突矿物声明，则该题得分为“是”，如果供应商提供的产品含有冲突矿物并且没有提交冲突矿物声明。\n则该题得分为“否”， 邮件通知 WWSM 合规部门经理 ：90smcompliance@johndeere.com进行进一步评估。 \n（CM = 锡、钽、钨和金）"]
[null,5,"CC05","4.2.2","Supplier displays conduct and operations consistent with the contents of the John Deere Supplier Code of Conduct?\n供应商的行为和运营是否符合约翰迪尔供应商行为守则的内容?",null,null,null,null,null,null,"Score as \"Yes\" if there are no observations contradictory to the contents of the Code of Conduct\nScore as \"No\" if there are observations contradictory to the contents of the Code of Conduct. Notify WWSM, Compliance Manager at: 90smcompliance@johndeere.com for further evaluation.\n如果没有与行为守则内容违背的内容，得分为“是”\n如果有与行为守则内容相违背的内容，评分为“否”。通知WWSM，合规经理:90smcompliance@johndeere.com进行进一步评估。"]
[null,null,"合规部分符合度:    (符合 = 上述所有问题均符合)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(U84:U88,\"\")>0,\"未完成\",IF(AND(U84=\"YES\",OR(U85=\"NO\",U86=\"NO\",U87=\"NO\",U88=\"NO\")),\"跟进\",IF(COUNTIF(U84:U88,\"YES\")=5,\"符合\",\"不符合\")))","v":"未完成"}]
[]
[]
[null,null,"总体供应商质量评定标准"]
[null,null,"评定",null,"得分 **","符合问题要求的能力："]
[null,null,"不符合",null,0,"不符合要求。 没有实施或文件证明（重大不符合）。"]
[null,null,"不符合",null,1,"部分符合要求，但是在实施或文件中存在重大不一致（重大不符合）。"]
[null,null,"符合",null,2,"符合要求，但是在执行或文件中存在轻微不一致，或者处于实施的早期阶段，只能初步证明有实施效果（轻微不符合）。"]
[null,null,"符合",null,3,"符合要求，有效实施并且文件完整。 （或者是否该问题不适用）"]
[null,null,"符合",null,4,"该供应商的过程或措施能切实确保不会发生不符合。 他们在各种情况下均符合下面规定的流程。 （例如“世界级”）"]
[]
[null,null,"** 供应商在每个问题的得分不得低于 2 分才能被接受。"]
[null,null,"** 用 0 到 4 分制进行评分，其中 4 最高。"]
[null,null," - 审核摘要中显示的质量分类是根据第一个列出的质量手册参考资料编制的，与问题编号相关联"]
[null,null," - 序号栏中列出的O / F / VV字符表示确认问题符合性的方法"]
[null,null,"VV = 虚拟验证，必须提供现场或录制的视频，以确定是否符合\nF = 车间验证， 必须在车间现场确认\nO = 办公室，完全可以通过屏幕共享和/或对话来确认，不需要现场或录制的视频"]
[]
["质量"]
[null,"#","问题编号","质量手册参考","面谈问题",null,null,null,null,null,null,null,null,"记录和支持的证据",null,null,null,null,null,null,"得分\n(0 to 4)"]
[null,6,"PE01\nO",9.3000000000000007,"How does Top Management review the organization’s quality management system to ensure its continuing suitability, adequacy, and effectiveness?\n最高管理层如何评审组织的质量管理体系，以确保其持续的适宜性、充分性和有效性?"]
[null,7,"SU01\nO","7.5.1.2","How does the supplier define and arrange the elements of their quality management system?\n供应商如何定义和安排其质量管理体系的要素?"]
[null,8,"SU02\nO/F","7.3.2","How does training provide employees with an awareness of the relevance and importance of employee’s activities and how employees contribute to the achievement of quality objectives and recognition in the business plan?\n培训如何使员工意识到员工活动在业务计划中的相关性和重要性，以及员工如何为实现质量目标和质量认可做出贡献?"]
[null,9,"PL01\nO","6.1.3","How are risks identified and evaluated to prepare contingency plans? \n如何识别和评估风险以制定急计划?"]
[null,10,"PL02\nO","6.1.3","How will contingency plans be documented, traceable, reviewed, change managed, tested for effectiveness, and communicated to John Deere if deployed?\n如果部署了应急计划，应急计划如何被记录、追踪、评审、管理变更、测试有效性，并与约翰迪尔进行沟通?"]
[null,11,"IM01\nO/F",10.3,"How does the supplier demonstrate a formal process of commitment to continuous improvement in products, process, and services to their end customers?\n供应商如何向最终客户展示其承诺持续改进产品、过程和服务的正式流程?"]
[null,12,"OP01\nO","8.3.2.1","How does the supplier execute Advanced Product Quality Planning for design and development of products and services?\n供应商如何为产品和服务的设计和开发执行先期产品质量策划（APQP）?"]
[null,13,"OP02\nO","8.2.2.2","How does the supplier ensure definition of product and service requirements, including those considered necessary by the supplier, are provided to the customer?\n供应商如何确保向客户提供产品和服务要求的定义，包括供应商认为必要的产品和服务要求？"]
[null,14,"OP03\nO","8.3.2.2","How are failure modes and effects analysis used in design and development of products and services?\n在产品和服务的设计和开发中如何使用失效模式和影响分析（FMEA）？"]
[null,15,"OP04\nO","8.5.1.1\n8.3.6.2\n9.1.4.3.1\n8.6.2","How are control plans created, communicated to, and/or approved by the end customer, and executed? \n控制计划是如何创建、和最终客户沟通、和/或由最终客户批准、执行的?"]
[null,16,"OP05\nO","8.3.6.1\n8.2.3.3\n8.3.2.1.7\n7.1.5.3.2\n8.3.2.1.6\n8.3.6.3\n8.3.6.6","How does the supplier identify and document Process and Product Special Characteristics?\n供应商如何识别和记录过程和产品的关键特性?"]
[null,17,"PE02\nO","9.1.1.5\n9.1.6.8\n9.1.1.8","What are the supplier's process capability requirements on special characteristics, for both product and process, and what actions are taken when targets are not met?\n供应商对产品和过程的关键特性的过程能力要求是什么，当未达到目标时采取什么措施?"]
[null,18,"OP06\nO","8.3.2.3","How does supplier develop software and products with software?\n供应商如何开发软件和包含软件的产品?"]
[null,19,"OP07\nO","8.3.9\n8.4.2.5","How does the supplier manage design and development changes that are initiated both internally and externally?\n供应商如何管理内部和外部发起的设计和开发变更?"]
[null,20,"SU03\nO","7.5.3.2","How does supplier control documented information?\n供应商如何控制文件信息?"]
[null,21,"CO01\nO","4.3.4","How does supplier ensure usage of the most current standards, understand relevant standards, and review any changes in those standards, both customer required and industry driven?\n供应商如何确保使用最新的标准，了解相关的标准，并评审这些标准中的任何变化，无论是客户要求的还是行业驱动的?"]
[null,22,"OP08\nO","8.4.2.2\n8.4.3.1.1\n8.4.3.1.2","How are requirements and standards, and any subsequent updates, communicated to second tier suppliers/providers?\n要求和标准，以及任何后续的更新，如何传达给二级供应商/供货商?"]
[null,23,"OP09\nO","8.4.1.5","How will second tier suppliers be selected to ensure they have the capability to meet JDS-G223 and other applicable John Deere Standards?\n如何选择二级供应商，以确保他们有能力满足JDS-G223和其他适用的约翰迪尔标准?"]
[null,24,"OP10\nO","8.4.2.3\n8.4.2.4","How does the supplier monitor second tier supplier performance, take appropriate actions for non-conformances and develop appropriate supplier development processes/plans?\n供应商如何监控二级供应商的绩效，针对不合格采取适当的措施，并制定适当的供应商开发流程/计划?"]
[null,25,"OP11\nO","8.4.2.3.3","How does the supplier audit their supply chain's quality systems and capabilities?   \n供应商如何审核其供应链的质量体系和能力?  "]
[null,26,"CO02\nO/F","4.4.4","How does the supplier control and identify products and processes where product conformity may be affected as a result of outsourcing?\n供应商如何控制和识别可能因外包而影响产品符合性的产品和过程？"]
[null,27,"IM02\nO","10.2.1","How does the supplier react to, evaluate, and correct nonconformities, both internally and externally?\n供应商如何对内部和外部的不符合项作出反应、评估和纠正?"]
[null,28,"IM03\nO","10.2.3.1\nTable 12 ","What is the supplier's documented process for problem solving (8D process or equivalent)?\n供应商解决问题的文件程序是什么(8D流程或同等流程)?"]
[null,29,"OP12\nO","8.7.1.12","How does the supplier obtain customer authorization (deviation) prior to shipment, whenever the product or process is different from the current Production Part Approval Process (PPAP) approval?\n当产品或过程与当前的生产零件批准过程(PPAP)不同时，供应商如何在出货前获得客户授权（偏差）?"]
[null,30,"IM04\nO","10.2.5","How does the supplier manage warranty?\n供应商如何管理三包投诉?"]
[null,31,"SU04\nF/VV",7.2,"How has the operator(s) basic competence been identified, evaluated, and evidence thereof retained for the work being performed?\n操作人员的基本能力是如何被识别、评估，并为其所进行的工作保留相关证据的?"]
[null,32,"OP13\nF/VV","8.1\n9.1.1.2\n8.3.8.2.2\n7.5.3.2","How are documented process monitoring and other work instructions prepared for operators and do these documents match the controlled copies?\n如何为操作人员准备文件化的过程监控和其他作业指导书，这些文件是否与受控版本相一致?"]
[null,33,"PE03\nF/VV","9.1.1.3\n7.2","How are special process parameters, process and product CCs or KCs addressed on process control documents?  Is there documented evidence of process capability?\n关键过程参数、过程关键特性和产品关键特性在过程控制文件中是如何描述的，是否有过程能力的文件证明?"]
[null,34,"SU05\nF/VV","7.1.3\n7.1.4","How does the supplier determine, provide, and maintain the equipment necessary for the operation of its processes and to achieve conformity of products and services?\n供应商如何确定、提供和维护操作过程所需的设备，以实现产品和服务的一致性?"]
[null,35,"OP14\nF/VV","8.7.1","What actions are taken when nonconforming or suspect product is found and who can execute the actions?\n当发现不合格或可疑产品时将采取什么措施，谁可以执行这些措施？"]
[null,36,"OP15\nF/VV","8.7.1.11","What does the supplier's documented process for rework and/or repair of product entail?\n供应商对产品的返工和/或返修有什么文件化的程序?"]
[null,37,"SU06\nO/F","7.1.5.2.2\n7.1.5.2.3","How does the supplier select gages to have the discrimination of less than one-tenth of the total product tolerance and who is responsible to review the affected gages in the event of engineering changes?\n供应商如何选择分辨率小于产品总公差十分之一的量具，并在工程变更时由谁负责评审受影响的量具?"]
[null,38,"SU07\nO","7.1.5.2.9","How does the supplier select laboratories for any calibrations performed externally? \n供应商如何选择实验室进行外部校准?"]
[null,39,"SU08\nO","7.1.5.2.6\n7.1.5.3.10","How are documented procedures for the calibration, control, and maintenance of measuring, inspection, and test equipment used, established and maintained to ensure that products and processes conform to applicable requirements?\n如何建立和维护用于测量、检验和测试设备的校准、控制和维护程序，以确保产品和过程符合适用的要求?"]
[null,40,"SU09\nO","7.1.5.2.4\n7.1.5.2.5","What documented process and actions will be taken when a gage used to verify parts for John Deere is found to be out of calibration? \n当发现用于验证约翰迪尔零件的量具未校准时，将采取什么文件化的流程和措施?"]
[null,41,"SU10\nO","7.1.5.2.10\n7.1.5.2.11","What is the process for managing customer owned gages, test fixtures, and test machines and how are any supplied drawings stored?\n管理客户拥有的检具、测试夹具和测试设备的流程是什么，客户所提供的图纸是如何存储的?"]
[null,42,"SU11\nO","7.1.5.3","How does the supplier determine the need for gage R&R studies, who is included in the study, and what level of total variation of tolerance does the supplier accept?\n供应商如何确定量具重复性和再现性（gage R&R）研究的需要，研究对象包括谁，供应商接受的总变差水平是多少?"]
[null,43,"OP16\nO/F","8.5.1.3","How is the preventive maintenance program established and maintained?\n预防性维护程序是如何建立和维护的?"]
[null,44,"OP17\nO/F/VV","8.5.1","How does the supplier validate any onsite \"special\" processes as identified by the customer?\n供应商如何验证客户确定的任何现场“特殊”过程?"]
[null,45,"OP18\nF/VV","8.5.2","How is the required product identification maintained through all stages of production, assembly, and delivery? \n在生产、装配和交付的所有阶段，如何保持所需的产品标识?"]
[null,46,"OP19\nF/VV","8.5.4","How is production material protected to prevent damage, ensure cleanliness, and/or prevent deterioration during internal handling and storage of production material?\n在生产材料的内部处理和储存过程中，如何保护生产材料以防止损坏，确保清洁和/或防止变质?"]
[null,null,"质量部分平均分：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S74","v":"?"}]
[null,null,"质量部分符合度： （符合 = 单项得分不得低于 2 分）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T74","v":"不符合"}]
[]
[]
[]
[]
[null,null,"优势"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"问题编号",null,"重大不符合 / 差距  (如果没有不符合项/差距，保持空白)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAR #"]
[null,null,{"$f":"IF(ISBLANK(Formulas!C2),\"\",Formulas!C2)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D2),\"\",Formulas!D2)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C3),\"\",Formulas!C3)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D3),\"\",Formulas!D3)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C4),\"\",Formulas!C4)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D4),\"\",Formulas!D4)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C5),\"\",Formulas!C5)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D5),\"\",Formulas!D5)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C6),\"\",Formulas!C6)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D6),\"\",Formulas!D6)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C7),\"\",Formulas!C7)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D7),\"\",Formulas!D7)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C8),\"\",Formulas!C8)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D8),\"\",Formulas!D8)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C9),\"\",Formulas!C9)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D9),\"\",Formulas!D9)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C10),\"\",Formulas!C10)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D10),\"\",Formulas!D10)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C11),\"\",Formulas!C11)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D11),\"\",Formulas!D11)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C12),\"\",Formulas!C12)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D12),\"\",Formulas!D12)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C13),\"\",Formulas!C13)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D13),\"\",Formulas!D13)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C14),\"\",Formulas!C14)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D14),\"\",Formulas!D14)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C15),\"\",Formulas!C15)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D15),\"\",Formulas!D15)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C16),\"\",Formulas!C16)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D16),\"\",Formulas!D16)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C17),\"\",Formulas!C17)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D17),\"\",Formulas!D17)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C18),\"\",Formulas!C18)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D18),\"\",Formulas!D18)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C19),\"\",Formulas!C19)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D19),\"\",Formulas!D19)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C20),\"\",Formulas!C20)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D20),\"\",Formulas!D20)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C21),\"\",Formulas!C21)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D21),\"\",Formulas!D21)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C22),\"\",Formulas!C22)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D22),\"\",Formulas!D22)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C23),\"\",Formulas!C23)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D23),\"\",Formulas!D23)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C24),\"\",Formulas!C24)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D24),\"\",Formulas!D24)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C25),\"\",Formulas!C25)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D25),\"\",Formulas!D25)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!C26),\"\",Formulas!C26)","v":""},null,{"$f":"IF(ISBLANK(Formulas!D26),\"\",Formulas!D26)","v":""}]
[]
[null,null,"问题编号",null,"轻微不符合 / 差距  (如果没有不符合项/差距，保持空白)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAR #"]
[null,null,{"$f":"IF(ISBLANK(Formulas!H2),\"\",Formulas!H2)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I2),\"\",Formulas!I2)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H3),\"\",Formulas!H3)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I3),\"\",Formulas!I3)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H4),\"\",Formulas!H4)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I4),\"\",Formulas!I4)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H5),\"\",Formulas!H5)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I5),\"\",Formulas!I5)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H6),\"\",Formulas!H6)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I6),\"\",Formulas!I6)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H7),\"\",Formulas!H7)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I7),\"\",Formulas!I7)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H8),\"\",Formulas!H8)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I8),\"\",Formulas!I8)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H9),\"\",Formulas!H9)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I9),\"\",Formulas!I9)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H10),\"\",Formulas!H10)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I10),\"\",Formulas!I10)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H11),\"\",Formulas!H11)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I11),\"\",Formulas!I11)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H12),\"\",Formulas!H12)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I12),\"\",Formulas!I12)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H13),\"\",Formulas!H13)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I13),\"\",Formulas!I13)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H14),\"\",Formulas!H14)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I14),\"\",Formulas!I14)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H15),\"\",Formulas!H15)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I15),\"\",Formulas!I15)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H16),\"\",Formulas!H16)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I16),\"\",Formulas!I16)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H17),\"\",Formulas!H17)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I17),\"\",Formulas!I17)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H18),\"\",Formulas!H18)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I18),\"\",Formulas!I18)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H19),\"\",Formulas!H19)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I19),\"\",Formulas!I19)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H20),\"\",Formulas!H20)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I20),\"\",Formulas!I20)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H21),\"\",Formulas!H21)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I21),\"\",Formulas!I21)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H22),\"\",Formulas!H22)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I22),\"\",Formulas!I22)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H23),\"\",Formulas!H23)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I23),\"\",Formulas!I23)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H24),\"\",Formulas!H24)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I24),\"\",Formulas!I24)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Formulas!H25),\"\",Formulas!H25)","v":""},null,{"$f":"IF(ISBLANK(Formulas!I25),\"\",Formulas!I25)","v":""}]
[]
[null,null,"问题编号",null,"改进机会"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["V2.0"]

{"sheet":"Formulas","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,0,0,3],[0,5,0,8]]}
["Majors",null,null,null,null,"Minors"]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U108),\"\",IF(OR('Audit Questionnaire'!U108=0,'Audit Questionnaire'!U108=1),LEFT('Audit Questionnaire'!C108,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U108),\"\",IF(OR('Audit Questionnaire'!U108=0,'Audit Questionnaire'!U108=1),IF(ISBLANK('Audit Questionnaire'!N108),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N108),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C2)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C2)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D2)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D2)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U108),\"\",IF('Audit Questionnaire'!U108=2,LEFT('Audit Questionnaire'!C108,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U108),\"\",IF('Audit Questionnaire'!U108=2,IF(ISBLANK('Audit Questionnaire'!N108),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N108),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H2)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H2)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I2)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I2)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U109),\"\",IF(OR('Audit Questionnaire'!U109=0,'Audit Questionnaire'!U109=1),LEFT('Audit Questionnaire'!C109,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U109),\"\",IF(OR('Audit Questionnaire'!U109=0,'Audit Questionnaire'!U109=1),IF(ISBLANK('Audit Questionnaire'!N109),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N109),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C3)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C3)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D3)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D3)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U109),\"\",IF('Audit Questionnaire'!U109=2,LEFT('Audit Questionnaire'!C109,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U109),\"\",IF('Audit Questionnaire'!U109=2,IF(ISBLANK('Audit Questionnaire'!N109),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N109),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H3)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H3)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I3)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I3)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U110),\"\",IF(OR('Audit Questionnaire'!U110=0,'Audit Questionnaire'!U110=1),LEFT('Audit Questionnaire'!C110,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U110),\"\",IF(OR('Audit Questionnaire'!U110=0,'Audit Questionnaire'!U110=1),IF(ISBLANK('Audit Questionnaire'!N110),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N110),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C4)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C4)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D4)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D4)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U110),\"\",IF('Audit Questionnaire'!U110=2,LEFT('Audit Questionnaire'!C110,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U110),\"\",IF('Audit Questionnaire'!U110=2,IF(ISBLANK('Audit Questionnaire'!N110),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N110),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H4)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H4)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I4)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I4)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U111),\"\",IF(OR('Audit Questionnaire'!U111=0,'Audit Questionnaire'!U111=1),LEFT('Audit Questionnaire'!C111,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U111),\"\",IF(OR('Audit Questionnaire'!U111=0,'Audit Questionnaire'!U111=1),IF(ISBLANK('Audit Questionnaire'!N111),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N111),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C5)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C5)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D5)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D5)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U111),\"\",IF('Audit Questionnaire'!U111=2,LEFT('Audit Questionnaire'!C111,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U111),\"\",IF('Audit Questionnaire'!U111=2,IF(ISBLANK('Audit Questionnaire'!N111),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N111),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H5)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H5)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I5)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I5)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U112),\"\",IF(OR('Audit Questionnaire'!U112=0,'Audit Questionnaire'!U112=1),LEFT('Audit Questionnaire'!C112,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U112),\"\",IF(OR('Audit Questionnaire'!U112=0,'Audit Questionnaire'!U112=1),IF(ISBLANK('Audit Questionnaire'!N112),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N112),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C6)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C6)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D6)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D6)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U112),\"\",IF('Audit Questionnaire'!U112=2,LEFT('Audit Questionnaire'!C112,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U112),\"\",IF('Audit Questionnaire'!U112=2,IF(ISBLANK('Audit Questionnaire'!N112),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N112),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H6)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H6)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I6)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I6)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U113),\"\",IF(OR('Audit Questionnaire'!U113=0,'Audit Questionnaire'!U113=1),LEFT('Audit Questionnaire'!C113,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U113),\"\",IF(OR('Audit Questionnaire'!U113=0,'Audit Questionnaire'!U113=1),IF(ISBLANK('Audit Questionnaire'!N113),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N113),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C7)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C7)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D7)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D7)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U113),\"\",IF('Audit Questionnaire'!U113=2,LEFT('Audit Questionnaire'!C113,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U113),\"\",IF('Audit Questionnaire'!U113=2,IF(ISBLANK('Audit Questionnaire'!N113),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N113),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H7)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H7)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I7)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I7)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U114),\"\",IF(OR('Audit Questionnaire'!U114=0,'Audit Questionnaire'!U114=1),LEFT('Audit Questionnaire'!C114,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U114),\"\",IF(OR('Audit Questionnaire'!U114=0,'Audit Questionnaire'!U114=1),IF(ISBLANK('Audit Questionnaire'!N114),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N114),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C8)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C8)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D8)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D8)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U114),\"\",IF('Audit Questionnaire'!U114=2,LEFT('Audit Questionnaire'!C114,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U114),\"\",IF('Audit Questionnaire'!U114=2,IF(ISBLANK('Audit Questionnaire'!N114),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N114),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H8)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H8)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I8)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I8)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U115),\"\",IF(OR('Audit Questionnaire'!U115=0,'Audit Questionnaire'!U115=1),LEFT('Audit Questionnaire'!C115,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U115),\"\",IF(OR('Audit Questionnaire'!U115=0,'Audit Questionnaire'!U115=1),IF(ISBLANK('Audit Questionnaire'!N115),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N115),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C9)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C9)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D9)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D9)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U115),\"\",IF('Audit Questionnaire'!U115=2,LEFT('Audit Questionnaire'!C115,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U115),\"\",IF('Audit Questionnaire'!U115=2,IF(ISBLANK('Audit Questionnaire'!N115),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N115),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H9)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H9)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I9)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I9)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U116),\"\",IF(OR('Audit Questionnaire'!U116=0,'Audit Questionnaire'!U116=1),LEFT('Audit Questionnaire'!C116,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U116),\"\",IF(OR('Audit Questionnaire'!U116=0,'Audit Questionnaire'!U116=1),IF(ISBLANK('Audit Questionnaire'!N116),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N116),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C10)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C10)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D10)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D10)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U116),\"\",IF('Audit Questionnaire'!U116=2,LEFT('Audit Questionnaire'!C116,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U116),\"\",IF('Audit Questionnaire'!U116=2,IF(ISBLANK('Audit Questionnaire'!N116),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N116),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H10)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H10)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I10)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I10)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U117),\"\",IF(OR('Audit Questionnaire'!U117=0,'Audit Questionnaire'!U117=1),LEFT('Audit Questionnaire'!C117,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U117),\"\",IF(OR('Audit Questionnaire'!U117=0,'Audit Questionnaire'!U117=1),IF(ISBLANK('Audit Questionnaire'!N117),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N117),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C11)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C11)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D11)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D11)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U117),\"\",IF('Audit Questionnaire'!U117=2,LEFT('Audit Questionnaire'!C117,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U117),\"\",IF('Audit Questionnaire'!U117=2,IF(ISBLANK('Audit Questionnaire'!N117),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N117),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H11)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H11)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I11)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I11)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U118),\"\",IF(OR('Audit Questionnaire'!U118=0,'Audit Questionnaire'!U118=1),LEFT('Audit Questionnaire'!C118,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U118),\"\",IF(OR('Audit Questionnaire'!U118=0,'Audit Questionnaire'!U118=1),IF(ISBLANK('Audit Questionnaire'!N118),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N118),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C12)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C12)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D12)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D12)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U118),\"\",IF('Audit Questionnaire'!U118=2,LEFT('Audit Questionnaire'!C118,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U118),\"\",IF('Audit Questionnaire'!U118=2,IF(ISBLANK('Audit Questionnaire'!N118),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N118),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H12)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H12)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I12)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I12)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U119),\"\",IF(OR('Audit Questionnaire'!U119=0,'Audit Questionnaire'!U119=1),LEFT('Audit Questionnaire'!C119,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U119),\"\",IF(OR('Audit Questionnaire'!U119=0,'Audit Questionnaire'!U119=1),IF(ISBLANK('Audit Questionnaire'!N119),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N119),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C13)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C13)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D13)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D13)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U119),\"\",IF('Audit Questionnaire'!U119=2,LEFT('Audit Questionnaire'!C119,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U119),\"\",IF('Audit Questionnaire'!U119=2,IF(ISBLANK('Audit Questionnaire'!N119),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N119),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H13)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H13)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I13)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I13)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U120),\"\",IF(OR('Audit Questionnaire'!U120=0,'Audit Questionnaire'!U120=1),LEFT('Audit Questionnaire'!C120,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U120),\"\",IF(OR('Audit Questionnaire'!U120=0,'Audit Questionnaire'!U120=1),IF(ISBLANK('Audit Questionnaire'!N120),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N120),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C14)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C14)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D14)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D14)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U120),\"\",IF('Audit Questionnaire'!U120=2,LEFT('Audit Questionnaire'!C120,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U120),\"\",IF('Audit Questionnaire'!U120=2,IF(ISBLANK('Audit Questionnaire'!N120),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N120),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H14)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H14)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I14)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I14)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U121),\"\",IF(OR('Audit Questionnaire'!U121=0,'Audit Questionnaire'!U121=1),LEFT('Audit Questionnaire'!C121,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U121),\"\",IF(OR('Audit Questionnaire'!U121=0,'Audit Questionnaire'!U121=1),IF(ISBLANK('Audit Questionnaire'!N121),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N121),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C15)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C15)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D15)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D15)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U121),\"\",IF('Audit Questionnaire'!U121=2,LEFT('Audit Questionnaire'!C121,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U121),\"\",IF('Audit Questionnaire'!U121=2,IF(ISBLANK('Audit Questionnaire'!N121),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N121),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H15)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H15)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I15)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I15)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U122),\"\",IF(OR('Audit Questionnaire'!U122=0,'Audit Questionnaire'!U122=1),LEFT('Audit Questionnaire'!C122,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U122),\"\",IF(OR('Audit Questionnaire'!U122=0,'Audit Questionnaire'!U122=1),IF(ISBLANK('Audit Questionnaire'!N122),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N122),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C16)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C16)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D16)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D16)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U122),\"\",IF('Audit Questionnaire'!U122=2,LEFT('Audit Questionnaire'!C122,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U122),\"\",IF('Audit Questionnaire'!U122=2,IF(ISBLANK('Audit Questionnaire'!N122),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N122),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H16)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H16)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I16)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I16)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U123),\"\",IF(OR('Audit Questionnaire'!U123=0,'Audit Questionnaire'!U123=1),LEFT('Audit Questionnaire'!C123,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U123),\"\",IF(OR('Audit Questionnaire'!U123=0,'Audit Questionnaire'!U123=1),IF(ISBLANK('Audit Questionnaire'!N123),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N123),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C17)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C17)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D17)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D17)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U123),\"\",IF('Audit Questionnaire'!U123=2,LEFT('Audit Questionnaire'!C123,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U123),\"\",IF('Audit Questionnaire'!U123=2,IF(ISBLANK('Audit Questionnaire'!N123),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N123),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H17)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H17)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I17)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I17)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U124),\"\",IF(OR('Audit Questionnaire'!U124=0,'Audit Questionnaire'!U124=1),LEFT('Audit Questionnaire'!C124,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U124),\"\",IF(OR('Audit Questionnaire'!U124=0,'Audit Questionnaire'!U124=1),IF(ISBLANK('Audit Questionnaire'!N124),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N124),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C18)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C18)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D18)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D18)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U124),\"\",IF('Audit Questionnaire'!U124=2,LEFT('Audit Questionnaire'!C124,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U124),\"\",IF('Audit Questionnaire'!U124=2,IF(ISBLANK('Audit Questionnaire'!N124),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N124),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H18)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H18)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I18)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I18)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U125),\"\",IF(OR('Audit Questionnaire'!U125=0,'Audit Questionnaire'!U125=1),LEFT('Audit Questionnaire'!C125,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U125),\"\",IF(OR('Audit Questionnaire'!U125=0,'Audit Questionnaire'!U125=1),IF(ISBLANK('Audit Questionnaire'!N125),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N125),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C19)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C19)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D19)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D19)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U125),\"\",IF('Audit Questionnaire'!U125=2,LEFT('Audit Questionnaire'!C125,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U125),\"\",IF('Audit Questionnaire'!U125=2,IF(ISBLANK('Audit Questionnaire'!N125),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N125),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H19)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H19)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I19)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I19)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U126),\"\",IF(OR('Audit Questionnaire'!U126=0,'Audit Questionnaire'!U126=1),LEFT('Audit Questionnaire'!C126,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U126),\"\",IF(OR('Audit Questionnaire'!U126=0,'Audit Questionnaire'!U126=1),IF(ISBLANK('Audit Questionnaire'!N126),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N126),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C20)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C20)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D20)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D20)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U126),\"\",IF('Audit Questionnaire'!U126=2,LEFT('Audit Questionnaire'!C126,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U126),\"\",IF('Audit Questionnaire'!U126=2,IF(ISBLANK('Audit Questionnaire'!N126),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N126),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H20)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H20)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I20)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I20)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U127),\"\",IF(OR('Audit Questionnaire'!U127=0,'Audit Questionnaire'!U127=1),LEFT('Audit Questionnaire'!C127,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U127),\"\",IF(OR('Audit Questionnaire'!U127=0,'Audit Questionnaire'!U127=1),IF(ISBLANK('Audit Questionnaire'!N127),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N127),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C21)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C21)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D21)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D21)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U127),\"\",IF('Audit Questionnaire'!U127=2,LEFT('Audit Questionnaire'!C127,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U127),\"\",IF('Audit Questionnaire'!U127=2,IF(ISBLANK('Audit Questionnaire'!N127),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N127),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H21)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H21)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I21)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I21)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U128),\"\",IF(OR('Audit Questionnaire'!U128=0,'Audit Questionnaire'!U128=1),LEFT('Audit Questionnaire'!C128,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U128),\"\",IF(OR('Audit Questionnaire'!U128=0,'Audit Questionnaire'!U128=1),IF(ISBLANK('Audit Questionnaire'!N128),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N128),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C22)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C22)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D22)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D22)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U128),\"\",IF('Audit Questionnaire'!U128=2,LEFT('Audit Questionnaire'!C128,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U128),\"\",IF('Audit Questionnaire'!U128=2,IF(ISBLANK('Audit Questionnaire'!N128),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N128),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H22)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H22)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I22)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I22)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U129),\"\",IF(OR('Audit Questionnaire'!U129=0,'Audit Questionnaire'!U129=1),LEFT('Audit Questionnaire'!C129,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U129),\"\",IF(OR('Audit Questionnaire'!U129=0,'Audit Questionnaire'!U129=1),IF(ISBLANK('Audit Questionnaire'!N129),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N129),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C23)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C23)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D23)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D23)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U129),\"\",IF('Audit Questionnaire'!U129=2,LEFT('Audit Questionnaire'!C129,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U129),\"\",IF('Audit Questionnaire'!U129=2,IF(ISBLANK('Audit Questionnaire'!N129),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N129),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H23)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H23)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I23)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I23)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U130),\"\",IF(OR('Audit Questionnaire'!U130=0,'Audit Questionnaire'!U130=1),LEFT('Audit Questionnaire'!C130,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U130),\"\",IF(OR('Audit Questionnaire'!U130=0,'Audit Questionnaire'!U130=1),IF(ISBLANK('Audit Questionnaire'!N130),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N130),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C24)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C24)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D24)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D24)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U130),\"\",IF('Audit Questionnaire'!U130=2,LEFT('Audit Questionnaire'!C130,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U130),\"\",IF('Audit Questionnaire'!U130=2,IF(ISBLANK('Audit Questionnaire'!N130),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N130),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H24)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H24)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I24)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I24)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U131),\"\",IF(OR('Audit Questionnaire'!U131=0,'Audit Questionnaire'!U131=1),LEFT('Audit Questionnaire'!C131,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U131),\"\",IF(OR('Audit Questionnaire'!U131=0,'Audit Questionnaire'!U131=1),IF(ISBLANK('Audit Questionnaire'!N131),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N131),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C25)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C25)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D25)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D25)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U131),\"\",IF('Audit Questionnaire'!U131=2,LEFT('Audit Questionnaire'!C131,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U131),\"\",IF('Audit Questionnaire'!U131=2,IF(ISBLANK('Audit Questionnaire'!N131),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N131),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H25)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H25)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I25)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I25)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U132),\"\",IF(OR('Audit Questionnaire'!U132=0,'Audit Questionnaire'!U132=1),LEFT('Audit Questionnaire'!C132,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U132),\"\",IF(OR('Audit Questionnaire'!U132=0,'Audit Questionnaire'!U132=1),IF(ISBLANK('Audit Questionnaire'!N132),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N132),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C26)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C26)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D26)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D26)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U132),\"\",IF('Audit Questionnaire'!U132=2,LEFT('Audit Questionnaire'!C132,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U132),\"\",IF('Audit Questionnaire'!U132=2,IF(ISBLANK('Audit Questionnaire'!N132),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N132),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H26)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H26)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I26)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I26)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U133),\"\",IF(OR('Audit Questionnaire'!U133=0,'Audit Questionnaire'!U133=1),LEFT('Audit Questionnaire'!C133,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U133),\"\",IF(OR('Audit Questionnaire'!U133=0,'Audit Questionnaire'!U133=1),IF(ISBLANK('Audit Questionnaire'!N133),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N133),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C27)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C27)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D27)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D27)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U133),\"\",IF('Audit Questionnaire'!U133=2,LEFT('Audit Questionnaire'!C133,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U133),\"\",IF('Audit Questionnaire'!U133=2,IF(ISBLANK('Audit Questionnaire'!N133),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N133),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H27)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H27)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I27)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I27)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U134),\"\",IF(OR('Audit Questionnaire'!U134=0,'Audit Questionnaire'!U134=1),LEFT('Audit Questionnaire'!C134,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U134),\"\",IF(OR('Audit Questionnaire'!U134=0,'Audit Questionnaire'!U134=1),IF(ISBLANK('Audit Questionnaire'!N134),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N134),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C28)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C28)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D28)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D28)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U134),\"\",IF('Audit Questionnaire'!U134=2,LEFT('Audit Questionnaire'!C134,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U134),\"\",IF('Audit Questionnaire'!U134=2,IF(ISBLANK('Audit Questionnaire'!N134),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N134),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H28)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H28)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I28)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I28)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U135),\"\",IF(OR('Audit Questionnaire'!U135=0,'Audit Questionnaire'!U135=1),LEFT('Audit Questionnaire'!C135,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U135),\"\",IF(OR('Audit Questionnaire'!U135=0,'Audit Questionnaire'!U135=1),IF(ISBLANK('Audit Questionnaire'!N135),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N135),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C29)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C29)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D29)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D29)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U135),\"\",IF('Audit Questionnaire'!U135=2,LEFT('Audit Questionnaire'!C135,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U135),\"\",IF('Audit Questionnaire'!U135=2,IF(ISBLANK('Audit Questionnaire'!N135),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N135),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H29)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H29)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I29)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I29)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U136),\"\",IF(OR('Audit Questionnaire'!U136=0,'Audit Questionnaire'!U136=1),LEFT('Audit Questionnaire'!C136,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U136),\"\",IF(OR('Audit Questionnaire'!U136=0,'Audit Questionnaire'!U136=1),IF(ISBLANK('Audit Questionnaire'!N136),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N136),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C30)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C30)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D30)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D30)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U136),\"\",IF('Audit Questionnaire'!U136=2,LEFT('Audit Questionnaire'!C136,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U136),\"\",IF('Audit Questionnaire'!U136=2,IF(ISBLANK('Audit Questionnaire'!N136),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N136),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H30)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H30)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I30)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I30)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U137),\"\",IF(OR('Audit Questionnaire'!U137=0,'Audit Questionnaire'!U137=1),LEFT('Audit Questionnaire'!C137,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U137),\"\",IF(OR('Audit Questionnaire'!U137=0,'Audit Questionnaire'!U137=1),IF(ISBLANK('Audit Questionnaire'!N137),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N137),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C31)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C31)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D31)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D31)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U137),\"\",IF('Audit Questionnaire'!U137=2,LEFT('Audit Questionnaire'!C137,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U137),\"\",IF('Audit Questionnaire'!U137=2,IF(ISBLANK('Audit Questionnaire'!N137),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N137),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H31)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H31)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I31)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I31)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U138),\"\",IF(OR('Audit Questionnaire'!U138=0,'Audit Questionnaire'!U138=1),LEFT('Audit Questionnaire'!C138,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U138),\"\",IF(OR('Audit Questionnaire'!U138=0,'Audit Questionnaire'!U138=1),IF(ISBLANK('Audit Questionnaire'!N138),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N138),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C32)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C32)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D32)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D32)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U138),\"\",IF('Audit Questionnaire'!U138=2,LEFT('Audit Questionnaire'!C138,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U138),\"\",IF('Audit Questionnaire'!U138=2,IF(ISBLANK('Audit Questionnaire'!N138),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N138),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H32)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H32)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I32)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I32)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U139),\"\",IF(OR('Audit Questionnaire'!U139=0,'Audit Questionnaire'!U139=1),LEFT('Audit Questionnaire'!C139,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U139),\"\",IF(OR('Audit Questionnaire'!U139=0,'Audit Questionnaire'!U139=1),IF(ISBLANK('Audit Questionnaire'!N139),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N139),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C33)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C33)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D33)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D33)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U139),\"\",IF('Audit Questionnaire'!U139=2,LEFT('Audit Questionnaire'!C139,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U139),\"\",IF('Audit Questionnaire'!U139=2,IF(ISBLANK('Audit Questionnaire'!N139),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N139),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H33)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H33)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I33)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I33)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U140),\"\",IF(OR('Audit Questionnaire'!U140=0,'Audit Questionnaire'!U140=1),LEFT('Audit Questionnaire'!C140,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U140),\"\",IF(OR('Audit Questionnaire'!U140=0,'Audit Questionnaire'!U140=1),IF(ISBLANK('Audit Questionnaire'!N140),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N140),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C34)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C34)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D34)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D34)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U140),\"\",IF('Audit Questionnaire'!U140=2,LEFT('Audit Questionnaire'!C140,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U140),\"\",IF('Audit Questionnaire'!U140=2,IF(ISBLANK('Audit Questionnaire'!N140),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N140),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H34)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H34)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I34)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I34)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U141),\"\",IF(OR('Audit Questionnaire'!U141=0,'Audit Questionnaire'!U141=1),LEFT('Audit Questionnaire'!C141,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U141),\"\",IF(OR('Audit Questionnaire'!U141=0,'Audit Questionnaire'!U141=1),IF(ISBLANK('Audit Questionnaire'!N141),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N141),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C35)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C35)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D35)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D35)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U141),\"\",IF('Audit Questionnaire'!U141=2,LEFT('Audit Questionnaire'!C141,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U141),\"\",IF('Audit Questionnaire'!U141=2,IF(ISBLANK('Audit Questionnaire'!N141),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N141),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H35)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H35)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I35)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I35)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U142),\"\",IF(OR('Audit Questionnaire'!U142=0,'Audit Questionnaire'!U142=1),LEFT('Audit Questionnaire'!C142,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U142),\"\",IF(OR('Audit Questionnaire'!U142=0,'Audit Questionnaire'!U142=1),IF(ISBLANK('Audit Questionnaire'!N142),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N142),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C36)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C36)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D36)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D36)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U142),\"\",IF('Audit Questionnaire'!U142=2,LEFT('Audit Questionnaire'!C142,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U142),\"\",IF('Audit Questionnaire'!U142=2,IF(ISBLANK('Audit Questionnaire'!N142),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N142),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H36)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H36)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I36)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I36)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U143),\"\",IF(OR('Audit Questionnaire'!U143=0,'Audit Questionnaire'!U143=1),LEFT('Audit Questionnaire'!C143,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U143),\"\",IF(OR('Audit Questionnaire'!U143=0,'Audit Questionnaire'!U143=1),IF(ISBLANK('Audit Questionnaire'!N143),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N143),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C37)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C37)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D37)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D37)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U143),\"\",IF('Audit Questionnaire'!U143=2,LEFT('Audit Questionnaire'!C143,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U143),\"\",IF('Audit Questionnaire'!U143=2,IF(ISBLANK('Audit Questionnaire'!N143),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N143),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H37)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H37)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I37)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I37)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U144),\"\",IF(OR('Audit Questionnaire'!U144=0,'Audit Questionnaire'!U144=1),LEFT('Audit Questionnaire'!C144,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U144),\"\",IF(OR('Audit Questionnaire'!U144=0,'Audit Questionnaire'!U144=1),IF(ISBLANK('Audit Questionnaire'!N144),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N144),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C38)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C38)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D38)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D38)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U144),\"\",IF('Audit Questionnaire'!U144=2,LEFT('Audit Questionnaire'!C144,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U144),\"\",IF('Audit Questionnaire'!U144=2,IF(ISBLANK('Audit Questionnaire'!N144),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N144),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H38)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H38)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I38)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I38)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U145),\"\",IF(OR('Audit Questionnaire'!U145=0,'Audit Questionnaire'!U145=1),LEFT('Audit Questionnaire'!C145,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U145),\"\",IF(OR('Audit Questionnaire'!U145=0,'Audit Questionnaire'!U145=1),IF(ISBLANK('Audit Questionnaire'!N145),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N145),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C39)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C39)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D39)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D39)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U145),\"\",IF('Audit Questionnaire'!U145=2,LEFT('Audit Questionnaire'!C145,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U145),\"\",IF('Audit Questionnaire'!U145=2,IF(ISBLANK('Audit Questionnaire'!N145),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N145),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H39)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H39)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I39)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I39)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U146),\"\",IF(OR('Audit Questionnaire'!U146=0,'Audit Questionnaire'!U146=1),LEFT('Audit Questionnaire'!C146,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U146),\"\",IF(OR('Audit Questionnaire'!U146=0,'Audit Questionnaire'!U146=1),IF(ISBLANK('Audit Questionnaire'!N146),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N146),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C40)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C40)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D40)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D40)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U146),\"\",IF('Audit Questionnaire'!U146=2,LEFT('Audit Questionnaire'!C146,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U146),\"\",IF('Audit Questionnaire'!U146=2,IF(ISBLANK('Audit Questionnaire'!N146),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N146),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H40)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H40)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I40)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I40)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U147),\"\",IF(OR('Audit Questionnaire'!U147=0,'Audit Questionnaire'!U147=1),LEFT('Audit Questionnaire'!C147,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U147),\"\",IF(OR('Audit Questionnaire'!U147=0,'Audit Questionnaire'!U147=1),IF(ISBLANK('Audit Questionnaire'!N147),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N147),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C41)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C41)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D41)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D41)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U147),\"\",IF('Audit Questionnaire'!U147=2,LEFT('Audit Questionnaire'!C147,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U147),\"\",IF('Audit Questionnaire'!U147=2,IF(ISBLANK('Audit Questionnaire'!N147),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N147),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H41)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H41)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I41)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I41)))),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Audit Questionnaire'!U148),\"\",IF(OR('Audit Questionnaire'!U148=0,'Audit Questionnaire'!U148=1),LEFT('Audit Questionnaire'!C148,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U148),\"\",IF(OR('Audit Questionnaire'!U148=0,'Audit Questionnaire'!U148=1),IF(ISBLANK('Audit Questionnaire'!N148),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N148),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(C$2:C42)>COUNTA(A:A),\"\",INDEX(A:A,SMALL(IF(A$2:A$42<>\"\",ROW(A$2:A$42)),ROWS(C$2:C42)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(D$2:D42)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$2:B$42<>\"\",ROW(B$2:B$42)),ROWS(D$2:D42)))),\"\")","v":""},null,{"$f":"IF(ISBLANK('Audit Questionnaire'!U148),\"\",IF('Audit Questionnaire'!U148=2,LEFT('Audit Questionnaire'!C148,4),\"\"))","v":""},{"$f":"IF(ISBLANK('Audit Questionnaire'!U148),\"\",IF('Audit Questionnaire'!U148=2,IF(ISBLANK('Audit Questionnaire'!N148),\"COMMENTS REQUIRED\",'Audit Questionnaire'!N148),\"\"))","v":""},{"$f":"IFERROR(IF(ROWS(H$2:H42)>COUNTA(F:F),\"\",INDEX(F:F,SMALL(IF(F$2:F$42<>\"\",ROW(F$2:F$42)),ROWS(H$2:H42)))),\"\")","v":""},{"$f":"IFERROR(IF(ROWS(I$2:I42)>COUNTA(G:G),\"\",INDEX(G:G,SMALL(IF(G$2:G$42<>\"\",ROW(G$2:G$42)),ROWS(I$2:I42)))),\"\")","v":""}]