{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Recertification Form"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Recertification Form","index":0,"n_rows":525,"n_cols":36,"rows_kept":525,"cut":false,"hidden":false,"merged":[[524,3,524,19],[10,2,10,20],[77,15,77,16],[78,3,78,14],[78,15,78,16],[79,3,79,14],[79,15,79,16],[193,18,193,19],[191,3,191,15],[193,3,193,15],[193,16,193,17],[191,16,191,17],[192,3,192,15],[192,16,192,17],[192,18,192,19],[209,3,209,13],[210,3,210,13],[211,3,211,13],[212,3,212,13],[0,31,1,35],[2,33,3,35],[226,18,226,19],[227,3,227,11],[227,12,227,17],[227,18,227,19],[228,3,228,11],[228,12,228,17],[228,18,228,19],[214,14,214,17],[214,18,214,19],[225,18,225,19],[225,12,225,17],[225,3,225,11],[179,18,179,19],[178,18,178,19],[165,3,165,7],[165,8,165,17],[165,18,165,19],[176,18,177,19],[170,3,170,19],[163,3,163,7],[163,8,163,17],[13,2,13,20],[198,3,198,19],[1,14,3,20],[137,18,137,19],[132,18,133,19],[142,3,142,18],[135,3,135,7],[135,8,135,17],[135,18,135,19],[136,3,136,7],[136,8,136,17],[136,18,136,19],[134,18,134,19],[134,3,134,7],[94,3,94,9],[94,10,94,16],[98,3,98,18],[102,3,102,4],[49,3,49,14],[49,15,49,16],[50,3,50,14],[92,3,92,9],[92,10,92,16],[93,3,93,9],[93,10,93,16],[178,3,178,17],[179,3,179,17],[2,23,4,27],[163,18,163,19],[164,3,164,7],[164,8,164,17],[164,18,164,19],[154,3,154,18],[162,3,162,7],[160,18,161,19],[162,8,162,17],[162,18,162,19],[149,3,149,7],[149,8,149,19],[148,3,148,7],[148,8,148,19],[137,3,137,7],[137,8,137,17],[124,24,124,27],[84,3,84,19],[90,3,90,9],[90,10,90,16],[91,3,91,9],[23,3,23,20],[91,10,91,16],[184,3,184,19],[189,18,190,19],[191,18,191,19],[50,15,50,16],[77,3,77,14],[322,24,322,27],[301,24,301,27],[312,24,312,27],[288,24,288,27],[285,24,285,27],[265,24,265,27],[234,24,234,27],[219,24,219,27],[198,24,198,27],[184,24,184,27],[170,24,170,27],[154,24,154,27],[142,24,142,27],[127,24,127,27],[294,14,294,17],[295,14,295,17],[296,14,296,17],[219,3,219,19],[4,2,4,20],[30,6,30,12],[32,6,32,12],[34,6,34,12],[66,19,66,20],[61,19,61,20],[62,19,62,20],[63,19,63,20],[59,14,59,15],[42,3,42,19],[48,3,48,14],[54,3,54,19],[59,5,59,10],[60,3,60,4],[19,3,19,20],[25,3,25,19],[17,3,17,20],[0,23,1,27],[42,24,42,27],[38,24,38,27],[5,26,5,27],[112,24,112,27],[98,24,98,27],[84,24,84,27],[71,24,71,27],[54,24,54,27],[204,3,204,13],[205,3,205,13],[206,3,206,13],[207,3,207,13],[208,3,208,13],[229,3,229,11],[229,12,229,17],[229,18,229,19],[226,3,226,11],[226,12,226,17],[214,3,214,13],[223,18,224,19],[204,18,204,19],[213,3,213,13],[517,25,517,26],[518,25,518,26],[516,25,516,26],[512,25,512,26],[513,25,513,26],[514,25,514,26],[506,24,506,27],[488,24,488,27],[474,24,474,27],[497,7,497,19],[491,4,491,19],[482,6,482,8],[482,9,482,19],[480,3,480,5],[480,6,480,8],[480,9,480,19],[453,18,453,19],[454,3,454,13],[454,14,454,17],[454,18,454,19],[481,9,481,19],[482,3,482,5],[397,24,397,27],[393,24,393,27],[366,24,366,27],[353,24,353,27],[343,24,343,27],[333,24,333,27],[495,6,495,19],[493,6,493,19],[446,3,446,19],[450,3,450,13],[450,18,450,19],[451,3,451,13],[451,14,451,17],[460,24,460,27],[446,24,446,27],[429,24,429,27],[426,24,426,27],[378,24,378,27],[418,24,418,27],[411,24,411,27],[404,24,404,27],[453,3,453,13],[453,14,453,17],[499,9,499,19],[500,9,500,19],[501,9,501,19],[488,3,488,19],[305,14,305,17],[307,18,307,19],[307,14,307,17],[483,3,483,5],[483,6,483,8],[483,9,483,19],[467,9,467,19],[468,3,468,5],[468,6,468,8],[468,9,468,19],[469,3,469,5],[469,6,469,8],[469,9,469,19],[460,3,460,19],[464,3,464,5],[464,6,464,8],[481,3,481,5],[481,6,481,8],[464,9,464,19],[465,3,465,5],[465,6,465,8],[465,9,465,19],[466,3,466,5],[466,6,466,8],[466,9,466,19],[455,3,455,13],[455,14,455,17],[455,18,455,19],[474,3,474,19],[478,3,478,5],[478,6,478,8],[478,9,478,19],[479,3,479,5],[479,6,479,8],[479,9,479,19],[467,3,467,5],[467,6,467,8],[518,18,518,19],[514,3,514,15],[514,16,514,17],[517,3,517,15],[517,16,517,17],[518,3,518,15],[518,16,518,17],[506,3,506,19],[511,3,511,13],[511,18,511,19],[512,18,512,19],[513,18,513,19],[512,16,512,17],[512,3,512,15],[513,3,513,15],[513,16,513,17],[516,3,516,15],[516,16,516,17],[516,18,516,19],[517,18,517,19],[515,3,515,4],[514,18,514,19],[451,18,451,19],[452,3,452,13],[452,14,452,17],[452,18,452,19],[102,6,102,7],[103,3,103,16],[104,3,104,16],[118,7,119,17],[119,3,119,5],[112,3,112,18],[280,3,280,19],[249,3,249,19],[254,3,254,19],[255,3,255,19],[265,3,265,19],[270,3,270,19],[271,3,271,19],[272,3,272,19],[250,3,250,19],[251,3,251,19],[252,3,252,19],[253,3,253,19],[256,3,256,19],[260,3,260,19],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[62,14,62,18],[63,5,63,13],[63,14,63,18],[64,5,64,13],[65,5,65,13],[66,5,66,13],[64,14,64,18],[65,14,65,18],[66,14,66,18],[65,19,65,20],[60,19,60,20],[59,19,59,20],[48,15,48,16],[64,19,64,20],[60,5,60,13],[60,14,60,18],[61,5,61,13],[61,14,61,18],[62,5,62,13],[59,3,59,4],[71,3,71,18],[89,10,89,11],[247,3,247,19],[248,3,248,19],[105,3,105,16],[106,3,106,16],[107,3,107,16],[234,3,234,19],[208,18,208,19],[209,14,209,17],[209,18,209,19],[210,14,210,17],[210,18,210,19],[211,14,211,17],[211,18,211,19],[212,14,212,17],[212,18,212,19],[213,14,213,17],[213,18,213,19],[117,3,118,5],[127,3,127,18],[134,8,134,17],[240,3,240,19],[205,14,205,17],[205,18,205,19],[206,14,206,17],[206,18,206,19],[207,14,207,17],[207,18,207,19],[208,14,208,17],[273,3,273,19],[274,3,274,19],[244,3,244,19],[245,3,245,19],[246,3,246,19],[257,3,257,19],[258,3,258,19],[242,3,242,19],[243,3,243,19],[327,16,327,19],[328,3,328,15],[328,16,328,19],[333,3,333,19],[337,3,337,13],[338,3,338,15],[241,3,241,19],[295,3,295,13],[296,3,296,13],[293,14,293,17],[293,18,293,19],[275,3,275,19],[276,3,276,19],[277,3,277,19],[278,3,278,19],[279,3,279,19],[294,18,294,19],[295,18,295,19],[296,18,296,19],[288,3,288,19],[292,3,292,13],[292,18,292,19],[293,3,293,13],[294,3,294,13],[411,3,411,19],[415,3,415,6],[418,3,418,19],[422,3,422,6],[378,3,378,19],[383,3,383,13],[259,3,259,19],[353,3,353,19],[312,3,312,19],[316,3,316,13],[317,16,317,19],[317,3,317,15],[301,3,301,19],[305,3,305,13],[305,18,305,19],[306,3,306,13],[306,14,306,17],[306,18,306,19],[307,3,307,13],[343,3,343,19],[348,3,348,6],[322,3,322,19],[326,3,326,13],[327,3,327,15],[429,3,429,19],[433,3,433,13],[433,18,433,19],[434,3,434,13],[434,14,434,17],[434,18,434,19],[338,16,338,19],[436,3,436,13],[436,14,436,17],[436,18,436,19],[366,3,366,19],[358,3,358,13],[359,3,359,15],[359,16,359,19],[360,3,360,15],[360,16,360,19],[361,3,361,15],[361,16,361,19],[362,3,362,15],[362,16,362,19],[385,3,385,15],[386,3,386,15],[385,16,385,19],[386,16,386,19],[441,14,441,17],[441,18,441,19],[441,3,441,13],[437,18,437,19],[438,3,438,13],[438,14,438,17],[438,18,438,19],[435,3,435,13],[435,14,435,17],[435,18,435,19],[439,3,439,13],[439,14,439,17],[439,18,439,19],[437,3,437,13],[437,14,437,17],[440,3,440,13],[440,14,440,17],[440,18,440,19],[371,3,371,13],[372,3,372,15],[372,16,372,19],[373,3,373,15],[373,16,373,19],[397,3,397,19],[401,3,401,6],[404,3,404,19],[408,3,408,6],[384,16,384,19],[387,3,387,15],[387,16,387,19],[391,5,391,19],[384,3,384,15]]}
[{"$nulls":23},"Reviewer Approval",{"$nulls":7},"Logic Calcs"]
[{"$nulls":14},{"$f":"IF(U6<100,\"Not Yet Ready to Submit\",IF(AF6,\"Ready to Submit your form by saving this file and replacing 'Your Name' with your name and send it to IBO@inceusa.org\",\"Not Yet Ready to Submit\"))","v":"Not Yet Ready to Submit"}]
[{"$nulls":23},"Mark dark blue boxes with \"x\" if approved or \"n\" if not approved",{"$nulls":4},{"$f":"SUM(Z40,Z126,Z287,Z428)","v":0},"Points Approved",null,"Points",null,"Approved"]
[]
[null,null,"Board Recertification Worksheet",{"$nulls":25},{"$f":"IF(AI6=0,\"--\",AJ6/AI6)","v":"--"},"Percent Reviewed",null,null,null,"Reviewed","Claimed","Both"]
[null,null,"Total points counted in all categories towards recertification (100 needed)",{"$nulls":17},{"$f":"SUM(T39,T125,T286,T427)","v":0},{"$f":"IF(U6>=100,\"OK\",\"X\")","v":"X"},{"$nulls":9},{"$f":"AND(AF35,AF33,AF31, U6>=100)","v":false},null,null,{"$f":"COUNTIF(AI7:AI521,TRUE)","v":0},{"$f":"COUNTIF(AJ7:AJ521,TRUE)","v":0}]
[]
[null,null,"Performance Period:",null,null,null,"January 1, 2017 to December 31, 2021"]
[]
[null,null,"Due Date:",null,null,null,"January 31, 2022"]
[]
[null,null,"Instructions"]
[]
[null,null,"This form is used by INCE Board Certified Noise Control Engineers to demonstrate that they meet their recertification requirements in a five-year recertification period. The form may be submitted at any time up until the due date shown above. To use the form, follow these instructions:"]
[]
[null,null,"* ","Enter your information in the appropriate fields below. Editable fields are "]
[]
[null,null,"* ","It is okay if your entry is longer than the width of the textbox."]
[]
[null,null,"* ","If you are pasting your information into the form from another place, you must double click on a cell to paste into it."]
[]
[null,null,"* ","All fields within a row must be filled out for the points to count."]
[]
[null,null,"* ","The spreadsheet continuously calculates recertification points. It alerts the user when the number of points equal or exceed the minimum for recertification (100 points) in the top right of the screen."]
[]
[null,null,"* ","Once the form is ready to submit, save this file and replace 'Your Name' in the file name with your first and last name and send it to:"]
[{"$nulls":4},"IBO@inceusa.org"]
[]
[null,null,"Contact Information"]
[]
[null,null,"Name",{"$nulls":10},{"$f":"IF(AF31,\"OK\",\"X\")","v":"X"},{"$nulls":17},{"$f":"(IF(ISBLANK(G31),FALSE,TRUE))","v":false}]
[]
[null,null,"Email",{"$nulls":10},{"$f":"IF(AF33,\"OK\",\"X\")","v":"X"},{"$nulls":17},{"$f":"(IF(ISBLANK(G33),FALSE,TRUE))","v":false}]
[]
[null,null,"Phone Number",{"$nulls":10},{"$f":"IF(AF35,\"OK\",\"X\")","v":"X"},{"$nulls":17},{"$f":"(IF(ISBLANK(G35),FALSE,TRUE))","v":false}]
[]
[]
[null,null,"Work-Related and Other Activity"]
[{"$nulls":18},"Total points counted in category towards recertification (Up to 50)",{"$f":"MIN(SUM(S53,S69,S82,S97,S110,S122),50)","v":0},{"$nulls":4},"Work"]
[{"$nulls":25},{"$f":"MIN(SUM(Z53,Z69,Z82,Z97,Z110,Z122),50)","v":0}]
[]
[null,null,"No."]
[null,null,1,"Private professional practice related to noise control engineering (NCE) involving exercise of engineering judgment and/or direction/management of engineering activities.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C43)","v":"No. 1"}]
[{"$nulls":4},"*  One (1) point for each 100 hours of NCE practice."]
[{"$nulls":4},"*  Up to 40 points per five (5) years."]
[{"$nulls":4},"*  Name of your employer(s) firm/company and/or sole proprietorship must be included for points to count"]
[]
[null,null,null,"What company was the work performed for",{"$nulls":11},"Total Hours"]
[{"$nulls":31},{"$f":"IF(ISBLANK(D49),0,MIN(P49/100,40))","v":0}]
[{"$nulls":31},{"$f":"IF(ISBLANK(D50),0,MIN(P50/100,40))","v":0}]
[{"$nulls":31},0]
[]
[{"$nulls":17},"Points Earned #1",{"$f":"MIN(SUM(AF49:AF51),40)","v":0},{"$nulls":4},"x",null,{"$f":"IF(OR(X53=\"x\",X53=\"X\"),S53,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X53))","v":true},{"$f":"S53>0","v":false},{"$f":"AND(AH53:AI53)","v":false}]
[null,null,"No."]
[null,null,2,"Teaching of formal courses directly related to NCE at a college, university, or collegiate level technology school.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C55)","v":"No. 2"}]
[{"$nulls":4},"*  Six (6) points per credit hour."]
[{"$nulls":4},"*  Up to 40 points per five (5) years."]
[{"$nulls":4},"*  List of courses and schools must be included for points to count"]
[]
[null,null,null,"Course Number",null,"Course Name",{"$nulls":8},"School",{"$nulls":4},"# Credit Hours"]
[{"$nulls":25},{"$f":"IF(OR(X61=\"x\",X61=\"X\"),T61,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D61),ISBLANK(F61),ISBLANK(O61)),0,T61*6)","v":0},null,{"$f":"NOT(ISBLANK(X61))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X62=\"x\",X62=\"X\"),T62,0)","v":0},{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[]
[{"$nulls":17},"Points Earned #2",{"$f":"MIN(SUM(AF61:AG67),40)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z61:Z67)*2,40)","v":0},{"$nulls":7},{"$f":"OR(AH61:AH67)","v":false},{"$f":"S69>0","v":false},{"$f":"AND(AH69:AI69)","v":false}]
[]
[null,null,"No."]
[null,null,3,"Research in areas directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C72)","v":"No. 3"}]
[{"$nulls":4},"*  One (1) point for each 100 hours of research."]
[{"$nulls":4},"*  Up to 40 points per five (5) years."]
[{"$nulls":4},"*  Company/school Information must be included for points to count"]
[]
[null,null,null,"What company/school was the research performed for",{"$nulls":11},"Total Hours"]
[{"$nulls":31},{"$f":"IF(ISBLANK(D78),0,MIN(P78/100,40))","v":0}]
[{"$nulls":31},{"$f":"IF(ISBLANK(D79),0,MIN(P79/100,40))","v":0}]
[{"$nulls":31},0]
[]
[{"$nulls":17},"Points Earned #3",{"$f":"MIN(SUM(AF78:AF80),40)","v":0},{"$nulls":4},"x",null,{"$f":"IF(OR(X82=\"x\",X82=\"X\"),S82,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X82))","v":true},{"$f":"S82>0","v":false},{"$f":"AND(AH82:AI82)","v":false}]
[]
[null,null,"No."]
[null,null,4,"Serving on a doctoral thesis review board (by formal written invitation) for a candidate with a thesis topic directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C85)","v":"No. 4"}]
[{"$nulls":4},"*  Two (2) points for each thesis."]
[{"$nulls":4},"*  10 points per five (5) years."]
[{"$nulls":4},"*  List of names of doctoral candidates must be included for points to count"]
[]
[null,null,null,"Candidate's Name",{"$nulls":6},"School"]
[{"$nulls":25},{"$f":"IF(OR(X91=\"x\",X91=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D91),ISBLANK(K91)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X91))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X92=\"x\",X92=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D92),ISBLANK(K92)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X92))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X93=\"x\",X93=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D93),ISBLANK(K93)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X93))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X94=\"x\",X94=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D94),ISBLANK(K94)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X94))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X95=\"x\",X95=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D95),ISBLANK(K95)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X95))","v":false}]
[]
[{"$nulls":17},"Points Earned #4",{"$f":"MIN(SUM(AF91:AF95),10)","v":0},{"$nulls":6},{"$f":"SUM(Z91:Z95)","v":0},{"$nulls":7},{"$f":"OR(AH91:AH95)","v":false},{"$f":"S97>0","v":false},{"$f":"AND(AH97:AI97)","v":false}]
[null,null,"No."]
[null,null,5,"Serving as a expert on issues directly related to NCE in litigation involving deposition and/or court testimony.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C99)","v":"No. 5"}]
[{"$nulls":4},"*  Two (2) points for each case."]
[{"$nulls":4},"*  10 points per five (5) years."]
[{"$nulls":4},"*  List of cases must be included for points to count"]
[null,null,null,"Cases"]
[{"$nulls":25},{"$f":"IF(OR(X104=\"x\",X104=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(ISBLANK(D104),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X104))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X105=\"x\",X105=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(ISBLANK(D105),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X105))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X106=\"x\",X106=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(ISBLANK(D106),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X106))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X107=\"x\",X107=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(ISBLANK(D107),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X107))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X108=\"x\",X108=\"X\"),2,0)","v":0},{"$nulls":5},{"$f":"IF(ISBLANK(D108),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X108))","v":false}]
[]
[{"$nulls":17},"Points Earned #5",{"$f":"MIN(SUM(AF104:AF108),10)","v":0},{"$nulls":6},{"$f":"SUM(Z104:Z108)","v":0},{"$nulls":7},{"$f":"OR(AH104:AH108)","v":false},{"$f":"S110>0","v":false},{"$f":"AND(AH110:AI110)","v":false}]
[]
[null,null,"No."]
[null,null,6,"Obtaining U.S. Patent or copyright for engineering or technical inventions directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C113)","v":"No. 6"}]
[{"$nulls":4},"*  Ten (10) points per patent"]
[{"$nulls":4},"*  10 points per five (5) years."]
[{"$nulls":4},"*  List of patents must be included for points to count"]
[]
[null,null,null,"Patent Country & Number",null,null,null,"Patent Name"]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D120),ISBLANK(H119)),0,10)","v":0}]
[]
[]
[{"$nulls":17},"Points Earned #6",{"$f":"MIN(AF119,10)","v":0},{"$nulls":6},{"$f":"IF(OR(X122=\"x\",X122=\"X\"),S122,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X122))","v":false},{"$f":"S122>0","v":false},{"$f":"AND(AH122:AI122)","v":false}]
[]
[null,null,"Publications and Presentations Activity"]
[null,null,"Total points counted in category towards recertification",{"$nulls":16},{"$f":"SUM(S140,S152,S168,S182,S196,S217,S232,S263,S283)","v":0},{"$nulls":4},"Pubs and Presents"]
[{"$nulls":25},{"$f":"SUM(Z140,Z152,Z168,Z182,Z196,Z217,Z232,Z263,Z283)","v":0}]
[null,null,"No."]
[null,null,7,"Acceptance for publication in NOISE-CON, INTER-NOISE, ASA, or other technical conference proceedings of a technical paper or case study directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C128)","v":"No. 7"}]
[{"$nulls":4},"*  Twenty (20) points per sole authored paper"]
[{"$nulls":4},"*  Ten (10) points per jointly paper"]
[{"$nulls":4},"*  40 points per five (5) years."]
[{"$nulls":4},"*  List of publications must be included for points to count"]
[{"$nulls":18},"Sole or Joint"]
[null,null,null,"Proceedings",{"$nulls":4},"Title"]
[{"$nulls":23},"x",null,{"$f":"IF(OR(X135=\"x\",X135=\"X\"),AF135,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D135),ISBLANK(I135),ISBLANK(S135)),0,IF(S135=\"Sole\",20,IF(S135=\"Joint\",10,0)))","v":0},null,{"$f":"NOT(ISBLANK(X135))","v":true}]
[{"$nulls":23},"n",null,{"$f":"IF(OR(X136=\"x\",X136=\"X\"),AF136,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D136),ISBLANK(I136),ISBLANK(S136)),0,IF(S136=\"Sole\",20,IF(S136=\"Joint\",10,0)))","v":0},null,{"$f":"NOT(ISBLANK(X136))","v":true}]
[{"$nulls":25},{"$f":"IF(OR(X137=\"x\",X137=\"X\"),AF137,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D137),ISBLANK(I137),ISBLANK(S137)),0,IF(S137=\"Sole\",20,IF(S137=\"Joint\",10,0)))","v":0},null,{"$f":"NOT(ISBLANK(X137))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X138=\"x\",X138=\"X\"),AF138,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D138),ISBLANK(I138),ISBLANK(S138)),0,IF(S138=\"Sole\",20,IF(S138=\"Joint\",10,0)))","v":0},null,{"$f":"NOT(ISBLANK(X138))","v":false}]
[]
[{"$nulls":17},"Points Earned #7",{"$f":"MIN(SUM(AF135:AF138),40)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z134:Z138),40)","v":0},{"$nulls":7},{"$f":"OR(AH135:AH138)","v":true},{"$f":"S140>0","v":false},{"$f":"AND(AH140:AI140)","v":false}]
[]
[null,null,"No."]
[null,null,8,"Presentation of a technical paper at NOISE-CON, INTER-NOISE, ASA, or other technical conference directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C143)","v":"No. 8"}]
[{"$nulls":4},"*  Five (5) points per presentation"]
[{"$nulls":4},"*  10 points per five (5) years."]
[{"$nulls":4},"*  List of presentation must be included for points to count"]
[]
[null,null,null,"Conference",{"$nulls":4},"Title"]
[{"$nulls":25},{"$f":"IF(OR(X149=\"x\",X149=\"X\"),AF149,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D149),ISBLANK(I149)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X149))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X150=\"x\",X150=\"X\"),AF150,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D150),ISBLANK(I150)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X150))","v":false}]
[]
[{"$nulls":17},"Points Earned #8",{"$f":"MIN(SUM(AF149:AF150),10)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z149:Z150),10)","v":0},{"$nulls":7},{"$f":"OR(AH149:AH150)","v":false},{"$f":"S152>0","v":false},false]
[]
[null,null,"No."]
[null,null,9,"Acceptance for publication in NCEJ, JASA, or other recognized scientific journal of a solely or jointly authored technical paper, case study, or opinion paper on a NCE related topic.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C155)","v":"No. 9"}]
[{"$nulls":4},"*  Forty (40) points per sole authored paper"]
[{"$nulls":4},"*  Twenty (20) points per jointly authored paper"]
[{"$nulls":4},"*  80 points per five (5) years."]
[{"$nulls":4},"*  List of publications must be included for points to count"]
[]
[{"$nulls":18},"Sole or Joint"]
[null,null,null,"Journal",{"$nulls":4},"Title"]
[{"$nulls":25},{"$f":"IF(OR(X163=\"x\",X163=\"X\"),AF163,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D163),ISBLANK(I163),ISBLANK(S163)),0,IF(S163=\"Sole\",40,IF(S163=\"Joint\",20,0)))","v":0},null,{"$f":"NOT(ISBLANK(X163))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X164=\"x\",X164=\"X\"),AF164,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D164),ISBLANK(I164),ISBLANK(S164)),0,IF(S164=\"Sole\",40,IF(S164=\"Joint\",20,0)))","v":0},null,{"$f":"NOT(ISBLANK(X164))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X165=\"x\",X165=\"X\"),AF165,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D165),ISBLANK(I165),ISBLANK(S165)),0,IF(S165=\"Sole\",40,IF(S165=\"Joint\",20,0)))","v":0},null,{"$f":"NOT(ISBLANK(X165))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X166=\"x\",X166=\"X\"),AF166,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D166),ISBLANK(I166),ISBLANK(S166)),0,IF(S166=\"Sole\",40,IF(S166=\"Joint\",20,0)))","v":0},null,{"$f":"NOT(ISBLANK(X166))","v":false}]
[]
[{"$nulls":17},"Points Earned #9",{"$f":"MIN(SUM(AF163:AF166),80)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z162:Z166),80)","v":0},{"$nulls":7},{"$f":"OR(AH162:AH166)","v":false},{"$f":"S168>0","v":false},false]
[]
[null,null,"No."]
[null,null,10,"Acceptance for publication of a solely or jointly authored textbook directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C171)","v":"No. 10"}]
[{"$nulls":4},"*  Sixty (60) points per sole authored textbook"]
[{"$nulls":4},"*  Thirty (30) points per jointly authored textbook"]
[{"$nulls":4},"*  60 points per five (5) years."]
[{"$nulls":4},"*  Titles of textbooks must be included for points to count"]
[]
[{"$nulls":18},"Sole or Joint"]
[null,null,null,"Textbook"]
[{"$nulls":25},{"$f":"IF(OR(X179=\"x\",X179=\"X\"),AF179,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D179),ISBLANK(S179)),0,IF(S179=\"Sole\",60,IF(S179=\"Joint\",30,0)))","v":0},null,{"$f":"NOT(ISBLANK(X179))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X180=\"x\",X180=\"X\"),AF180,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D180),ISBLANK(S180)),0,IF(S180=\"Sole\",60,IF(S180=\"Joint\",30,0)))","v":0},null,{"$f":"NOT(ISBLANK(X180))","v":false}]
[]
[{"$nulls":17},"Points Earned #10",{"$f":"MIN(SUM(AF179:AF180),60)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z179:Z180),60)","v":0},{"$nulls":7},{"$f":"OR(AH176:AH180)","v":false},{"$f":"S182>0","v":false},false]
[]
[null,null,"No."]
[null,null,11,"Acceptance for publication of a solely authored chapter directly related to NCE in a textbook, encyclopedia, handbook, or compendium.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C185)","v":"No. 11"}]
[{"$nulls":4},"*  Thirty (30) points per sole authored textbook"]
[{"$nulls":4},"*  Ten (10) points per jointly authored textbook"]
[{"$nulls":4},"*  30 points per five (5) years."]
[{"$nulls":4},"* Name of publication must be included for points to count"]
[{"$nulls":18},"Sole or Joint"]
[null,null,null,"Publication",{"$nulls":12},"Chapter"]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D192),ISBLANK(Q192),ISBLANK(S192)),0,IF(S192=\"Sole\",30,IF(S192=\"Joint\",10,0)))","v":0}]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D193),ISBLANK(Q193),ISBLANK(S193)),0,IF(S193=\"Sole\",30,IF(S193=\"Joint\",10,0)))","v":0}]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D194),ISBLANK(Q194),ISBLANK(S194)),0,IF(S194=\"Sole\",30,IF(S194=\"Joint\",10,0)))","v":0}]
[]
[{"$nulls":17},"Points Earned #11",{"$f":"MIN(SUM(AF192:AF194),30)","v":0},{"$nulls":6},{"$f":"IF(OR(X196=\"x\",X196=\"X\"),S196,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X196))","v":false},{"$f":"S196>0","v":false},false]
[]
[null,null,"No."]
[null,null,12,"Teach a seminar in topic(s) directly related to NCE, offered through a national professional society (e.g., ASA, SAE, ASHRAE, etc.).",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C199)","v":"No. 12"}]
[{"$nulls":4},"*  Two (2) points per CEU professional development hour."]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"*  List of CEU title and professional society must be included for points to count"]
[{"$nulls":4},"* If seminar is run more than once, list the total hours for that seminar"]
[]
[null,null,null,"CEU Name",{"$nulls":10},"Professional Society",null,null,null,"# Hours"]
[{"$nulls":25},{"$f":"IF(OR(X206=\"x\",X206=\"X\"),AF206,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D206),ISBLANK(O206)),0,S206*2)","v":0},null,{"$f":"NOT(ISBLANK(X206))","v":false}]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[]
[{"$nulls":17},"Points Earned #12",{"$f":"MIN(SUM(AF206:AF215),20)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z206:Z215),20)","v":0},{"$nulls":7},{"$f":"OR(AH206:AH215)","v":false},{"$f":"S217>0","v":false},false]
[]
[null,null,"No."]
[null,null,13,"Teach a course on topics directly related to NCE in a government or industry-sponsored school, trade school that is a minimum of four (4) hours of contact time.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C220)","v":"No. 13"}]
[{"$nulls":4},"*  One (1) point per hour of instruction"]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"* Name of course and institution must be included for points to count"]
[{"$nulls":18},"Hours"]
[null,null,null,"Course Title",{"$nulls":8},"Institution"]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D226),ISBLANK(M226)),0,S226)","v":0}]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D227),ISBLANK(M227)),0,S227)","v":0}]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D228),ISBLANK(M228)),0,S228)","v":0}]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D229),ISBLANK(M229)),0,S229)","v":0}]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D230),ISBLANK(M230)),0,S230)","v":0}]
[]
[{"$nulls":17},"Points Earned #13",{"$f":"MIN(SUM(AF226:AF230),20)","v":0},{"$nulls":6},{"$f":"IF(OR(X232=\"x\",X232=\"X\"),S232,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X232))","v":false},{"$f":"S232>0","v":false},false]
[]
[null,null,"No."]
[null,null,14,"Active participation in recognized engineering and/or professional engineering societies which enhance professional engineering development, that do not including conferences listed under 29",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C235)","v":"No. 14"}]
[{"$nulls":4},"*  Half (½) point per meeting."]
[{"$nulls":4},"*  Up to 10 points per five (5) years."]
[{"$nulls":4},"*  List of professional society meetings must be included for points to count"]
[{"$nulls":4},"* Does not need to be directly related to NCE, just engineering in general"]
[]
[null,null,null,"Conference/Meeting Name"]
[{"$nulls":25},{"$f":"IF(OR(X242=\"x\",X242=\"X\"),AF242,0)","v":0},{"$nulls":5},{"$f":"IF(ISBLANK(D242),0,0.5)","v":0},null,{"$f":"NOT(ISBLANK(X242))","v":false}]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[]
[{"$nulls":17},"Points Earned #14",{"$f":"SUM(AF242:AF261)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z242:Z261),20)","v":0},{"$nulls":7},{"$f":"OR(AH242:AH261)","v":false},{"$f":"S263>0","v":false},false]
[]
[null,null,"No."]
[null,null,15,"Active participation on committees or boards serving local, state or national governments, involving application of NCE principles.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C266)","v":"No. 15"}]
[{"$nulls":4},"*  One (1) point per meeting."]
[{"$nulls":4},"*  Up to 10 points per five (5) years."]
[{"$nulls":4},"*  List of committee or board meetings must be included for points to count"]
[]
[null,null,null,"Committee or Board Meeting Name"]
[{"$nulls":25},{"$f":"IF(OR(X272=\"x\",X272=\"X\"),AF272,0)","v":0},{"$nulls":5},{"$f":"IF(ISBLANK(D272),0,1)","v":0},null,{"$f":"NOT(ISBLANK(X272))","v":false}]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[]
[{"$nulls":17},"Points Earned #15",{"$f":"SUM(AF272:AF281)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z272:Z281),20)","v":0},{"$nulls":7},{"$f":"OR(AH277:AH281)","v":false},{"$f":"S283>0","v":false},false]
[]
[null,null,"Service-Related Professional Activity"]
[null,null,"Total points counted in category towards recertification",{"$nulls":16},{"$f":"SUM(S299,S310,S320,S331,S341,S351,S365,S376,S396,S390)","v":0},{"$nulls":4},"Service"]
[{"$nulls":25},{"$f":"SUM(Z299,Z310,Z320,Z331,Z341,Z351,Z365,Z376,Z396,Z390)","v":0}]
[null,null,"No."]
[null,null,16,"Service as an officer or Director of the Institute or other professional society directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C289)","v":"No. 16"}]
[{"$nulls":4},"*  Five (5) points per year of service"]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"*  List of roles served must be included for points to count"]
[null,null,null,"Leadership Role",{"$nulls":10},"Professional Society",null,null,null,"# Years of Service"]
[{"$nulls":25},{"$f":"IF(OR(X294=\"x\",X294=\"X\"),AF294,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D294),ISBLANK(O294)),0,S294*5)","v":0},null,{"$f":"NOT(ISBLANK(X294))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X295=\"x\",X295=\"X\"),AF295,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D295),ISBLANK(O295)),0,S295*5)","v":0},null,{"$f":"NOT(ISBLANK(X295))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X296=\"x\",X296=\"X\"),AF296,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D296),ISBLANK(O296)),0,S296*5)","v":0},null,{"$f":"NOT(ISBLANK(X296))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X297=\"x\",X297=\"X\"),AF297,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D297),ISBLANK(O297)),0,S297*5)","v":0},null,{"$f":"NOT(ISBLANK(X297))","v":false}]
[]
[{"$nulls":17},"Points Earned #16",{"$f":"MIN(SUM(AF294:AF297),20)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z294:Z297),20)","v":0},{"$nulls":7},{"$f":"OR(AH293:AH297)","v":false},{"$f":"S299>0","v":false},false]
[]
[null,null,"No."]
[null,null,17,"Service as an INCE Technical Committee Chair or as a Chair of a NCE-related technical committee of another national professional society.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C302)","v":"No. 17"}]
[{"$nulls":4},"*  Ten (10) points per committee chairs for every two (2) years of service"]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"*  List of committee chairs must be included for points to count"]
[null,null,null,"Technical Committee",{"$nulls":10},"Professional Society",null,null,null,"# Years of Service"]
[{"$nulls":25},{"$f":"IF(OR(X307=\"x\",X307=\"X\"),AF307,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D307),ISBLANK(O307)),0,S307/2*10)","v":0},null,{"$f":"NOT(ISBLANK(X307))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X308=\"x\",X308=\"X\"),AF308,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D308),ISBLANK(O308)),0,S308/2*10)","v":0},null,{"$f":"NOT(ISBLANK(X308))","v":false}]
[]
[{"$nulls":17},"Points Earned #17",{"$f":"MIN(SUM(AF307:AF308),20)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z307:Z308),20)","v":0},{"$nulls":7},{"$f":"OR(AH304:AH308)","v":false},{"$f":"S310>0","v":false},false]
[]
[null,null,"No."]
[null,null,18,"Service as a General Chair or technical chair of a NOISE-CON or INTER-NOISE, or other NCE-related national professional society conference.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C313)","v":"No. 18"}]
[{"$nulls":4},"*  Twenty (20) points per conference."]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"*  Conference chaired must be included for points to count"]
[null,null,null,"Conference",{"$nulls":12},"Chair Type"]
[{"$nulls":31},{"$f":"IF(OR(ISBLANK(D318),ISBLANK(Q318)),0,20)","v":0}]
[]
[{"$nulls":17},"Points Earned #18",{"$f":"AF318","v":0},{"$nulls":6},{"$f":"IF(OR(X320=\"x\",X320=\"X\"),S320,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X320))","v":false},{"$f":"S320>0","v":false},false]
[]
[null,null,"No."]
[null,null,19,"Service as the organizer of a technical session at a NOISE-CON or INTER-NOISE, or other NCE-related national professional society conference.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C323)","v":"No. 19"}]
[{"$nulls":4},"*  Ten (10) points per session chaired"]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"*  Conference and Session must be included for points to count"]
[null,null,null,"Session",{"$nulls":12},"Conference"]
[{"$nulls":25},{"$f":"IF(OR(X328=\"x\",X328=\"X\"),AF328,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D328),ISBLANK(Q328)),0,10)","v":0},null,{"$f":"NOT(ISBLANK(X328))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X329=\"x\",X329=\"X\"),AF329,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D329),ISBLANK(Q329)),0,10)","v":0},null,{"$f":"NOT(ISBLANK(X329))","v":false}]
[]
[{"$nulls":17},"Points Earned #19",{"$f":"SUM(AF328,AF329)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z328:Z329),20)","v":0},{"$nulls":7},{"$f":"OR(AH325:AH329)","v":false},{"$f":"S331>0","v":false},false]
[]
[null,null,"No."]
[null,null,20,"Service as an Editor or Associate Editor of Noise Control Engineering Journal (NCEJ).",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C334)","v":"No. 20"}]
[{"$nulls":4},"*  Five (5) points per edition."]
[{"$nulls":4},"*  Up to 25 points per five (5) years."]
[{"$nulls":4},"*  Position and # of editions served must be included for points to count"]
[null,null,null,"Position",{"$nulls":12},"# Editions Served"]
[{"$nulls":31},{"$f":"IF(ISBLANK(D339),0,Q339*5)","v":0}]
[]
[{"$nulls":17},"Points Earned #20",{"$f":"MIN(AF339,25)","v":0},{"$nulls":6},{"$f":"IF(OR(X341=\"x\",X341=\"X\"),S341,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X341))","v":false},{"$f":"S341>0","v":false},false]
[]
[null,null,"No."]
[null,null,21,"Service as an Editor of a special edition of NCEJ.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C344)","v":"No. 21"}]
[{"$nulls":4},"*  Five (5) points per edition."]
[{"$nulls":4},"*  Up to 25 points per five (5) years."]
[{"$nulls":4},"*  # of editions served must be included for points to count"]
[null,null,null,"# Editions Served"]
[{"$nulls":31},{"$f":"D349*5","v":0}]
[]
[{"$nulls":17},"Points Earned #21",{"$f":"MIN(AF349,25)","v":0},{"$nulls":6},{"$f":"IF(OR(X351=\"x\",X351=\"X\"),S351,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X351))","v":false},{"$f":"S351>0","v":false},false]
[]
[null,null,"No."]
[null,null,22,"Service as a peer reviewer for an NCEJ paper at the request of one or more Associate Editors, or service as a peer reviewer for a journal published by an NCE-related professional society or organization.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C354)","v":"No. 22"}]
[{"$nulls":4},"*  Five (5) points per paper reviewed."]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"*  List of papers reviewed and journal names must be included for points to count"]
[]
[null,null,null,"Paper Title",{"$nulls":12},"Journal Name"]
[{"$nulls":25},{"$f":"IF(OR(X360=\"x\",X360=\"X\"),AF360,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D360),ISBLANK(Q360)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X360))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X361=\"x\",X361=\"X\"),AF361,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D361),ISBLANK(Q361)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X361))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X362=\"x\",X362=\"X\"),AF362,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D362),ISBLANK(Q362)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X362))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X363=\"x\",X363=\"X\"),AF363,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D363),ISBLANK(Q363)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X363))","v":false}]
[]
[{"$nulls":17},"Points Earned #22",{"$f":"SUM(AF360:AF363)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z360:Z363),20)","v":0},{"$nulls":7},{"$f":"OR(AH359:AH363)","v":false},{"$f":"S365>0","v":false},false]
[null,null,"No."]
[null,null,23,"Service as an author or reviewer of a proposed standard in noise control. (Reviewer’s work must include written comments on the draft being reviewed, additional written comments is appropriate, and checking of mathematics and technical assumptions for plausibility).",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C367)","v":"No. 23"}]
[{"$nulls":4},"*  Five (5) points per standard drafted or reviewed."]
[{"$nulls":4},"*  Up to 10 points per five (5) years."]
[{"$nulls":4},"*  List of standards reviewed and standard organizations must be included for points to count"]
[]
[null,null,null,"Standard Title",{"$nulls":12},"Standard Organization"]
[{"$nulls":25},{"$f":"IF(OR(X373=\"x\",X373=\"X\"),AF373,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D373),ISBLANK(Q373)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X373))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X374=\"x\",X374=\"X\"),AF374,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D374),ISBLANK(Q374)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X374))","v":false}]
[]
[{"$nulls":17},"Points Earned #23",{"$f":"SUM(AF373:AF374)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z373:Z374),20)","v":0},{"$nulls":7},{"$f":"OR(AH370:AH374)","v":false},{"$f":"S376>0","v":false},false]
[]
[null,null,"No."]
[null,null,24,"Service in the judging of INCE Awards (See Note A below)",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C379)","v":"No. 24"}]
[{"$nulls":4},"*  Five (5) points per award judged."]
[{"$nulls":4},"*  Up to Twenty (20) points per five (5) years."]
[{"$nulls":4},"*  List of awards and years judged must be included for points to count"]
[]
[null,null,null,"Awards Judged",{"$nulls":12},"Year Judged"]
[{"$nulls":25},{"$f":"IF(OR(X385=\"x\",X385=\"X\"),AF385,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D385),ISBLANK(Q385)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X385))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X386=\"x\",X386=\"X\"),AF386,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D386),ISBLANK(Q386)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X386))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X387=\"x\",X387=\"X\"),AF387,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D387),ISBLANK(Q387)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X387))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X388=\"x\",X388=\"X\"),AF388,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D388),ISBLANK(Q388)),0,5)","v":0},null,{"$f":"NOT(ISBLANK(X388))","v":false}]
[]
[{"$nulls":17},"Points Earned #24",{"$f":"SUM(AF385:AF388)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z385:Z388),20)","v":0},{"$nulls":7},{"$f":"OR(AH384:AH388)","v":false},{"$f":"S390>0","v":false},false]
[]
[null,null,null,"Note A:",null,"INCE Board Certified members interested in participating for judging must notify the current INCE VP of Honors and Awards of their availability and interest in participating at least 6 months prior to the next scheduled NoiseCon or InterNoise conference. The INCE Board Certified member cannot fulfill the judging position if there is any potential conflict of interest with nominees for the Award that they would be judging.  Just by expressing availability, the INCE Board Certified member is not guaranteed a judging position. Their participation is based on availably of judging positions as determined by the current VP of Honors and Awards."]
[]
[null,null,"No more than 60 points may be included per 5- year maintenance period for items 25 through 28.",{"$nulls":21},"No. 24-27"]
[]
[{"$nulls":17},"Points Earned for #25-#28",{"$f":"MIN(SUM(AF402,AF409,AF416,AF423),60)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z402,Z409,Z416,Z423),50)","v":0}]
[null,null,"No."]
[null,null,25,"Service in the grading of Board Certification exams (available to the INCE Board Certification Committee Exam Sub-Committee only)",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C398)","v":"No. 25"}]
[{"$nulls":4},"*  Twenty (20) points per year."]
[{"$nulls":4},"*  # of Board Certification exams graded must be included for points to count."]
[null,null,null,"# of exams graded"]
[{"$nulls":25},{"$f":"IF(OR(X402=\"x\",X402=\"X\"),AF402,0)","v":0},{"$nulls":5},{"$f":"D402*20","v":0},null,{"$f":"NOT(ISBLANK(X402))","v":false},{"$f":"S402>0","v":false},false]
[]
[null,null,"No."]
[null,null,26,"Service in the proctoring of the Board Certification exam (open to all INCE Board Certified members)",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C405)","v":"No. 26"}]
[{"$nulls":4},"*  Ten (10) points per year."]
[{"$nulls":4},"*  # of years proctoring the exam must be included for points to count."]
[null,null,null,"# of years proctoring"]
[{"$nulls":25},{"$f":"IF(OR(X409=\"x\",X409=\"X\"),AF409,0)","v":0},{"$nulls":5},{"$f":"D409*10","v":0},null,{"$f":"NOT(ISBLANK(X409))","v":false},{"$f":"S409>0","v":false},false]
[]
[null,null,"No."]
[null,null,27,"Service in the creation of an open book Board Certification exam problem (open to all INCE Board Certified members)",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C412)","v":"No. 27"}]
[{"$nulls":4},"*  Five (5) points per approved problem, submitted to the Exam Sub- Committee Chair."]
[{"$nulls":4},"*  # of open book exam problems created must be included for points to count"]
[null,null,null,"# of open book problems"]
[{"$nulls":25},{"$f":"IF(OR(X416=\"x\",X416=\"X\"),AF416,0)","v":0},{"$nulls":5},{"$f":"D416*5","v":0},null,{"$f":"NOT(ISBLANK(X416))","v":false},{"$f":"S416>0","v":false},false]
[]
[null,null,"No."]
[null,null,28,"Service in the creation of a closed book Board Certification exam question (open to all INCE Board Certified members)",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C419)","v":"No. 28"}]
[{"$nulls":4},"*  One (1) point per approved problem, submitted to the Exam Sub- Committee Chair."]
[{"$nulls":4},"*  # of closed book exam problems created must be included for points to count"]
[null,null,null,"# of close book problems"]
[{"$nulls":25},{"$f":"IF(OR(X423=\"x\",X423=\"X\"),AF423,0)","v":0},{"$nulls":5},{"$f":"D423*1","v":0},null,{"$f":"NOT(ISBLANK(X423))","v":false},{"$f":"S423>0","v":false},false]
[]
[]
[null,null,"Continuing Education Activity"]
[null,null,"Total points counted in category towards recertification",{"$nulls":16},{"$f":"SUM(S444,S458,S472,S486,S504,S521,)","v":0},{"$nulls":4},"Cont. Ed"]
[{"$nulls":25},{"$f":"SUM(Z444,Z458,Z472,Z486,Z504,Z521)","v":0}]
[null,null,"No."]
[null,null,29,"Attendance at a NOISE-CON, INTER-NOISE, ASA, or other technical conference directly related to noise control engineering.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C430)","v":"No. 29"}]
[{"$nulls":4},"*  Five (5) points per day; Up to twenty (20) points per conference."]
[{"$nulls":4},"*  Up to 40 points per five (5) years."]
[{"$nulls":4},"*  List of conferences, year of conference, and # of days must be included for points to count"]
[null,null,null,"Conference",{"$nulls":10},"Year of conference",null,null,null,"# of days "]
[{"$nulls":25},{"$f":"IF(OR(X435=\"x\",X435=\"X\"),AF435,0)","v":0},{"$nulls":5},{"$f":"MIN(IF(OR(ISBLANK(D435),ISBLANK(O435)),0,S435*5),20)","v":0},null,{"$f":"NOT(ISBLANK(X435))","v":false}]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[{"$nulls":25},0,{"$nulls":5},0,null,false]
[]
[{"$nulls":17},"Points Earned #29",{"$f":"MIN(SUM(AF435:AF442),40)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z435:Z442),40)","v":0},{"$nulls":7},{"$f":"OR(AH435:AH442)","v":false},{"$f":"S444>0","v":false},false]
[]
[null,null,"No."]
[null,null,30,"Organize a local chapter meeting of a national professional society with presentation topic(s) directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C447)","v":"No. 30"}]
[{"$nulls":4},"*  Two (2) points per meeting."]
[{"$nulls":4},"*  Up to 10 points per five (5) years."]
[{"$nulls":4},"*  List of chapters, society and dates must be included for points to count"]
[null,null,null,"Chapter",{"$nulls":10},"Society",null,null,null,"Year"]
[{"$nulls":25},{"$f":"IF(OR(X452=\"x\",X452=\"X\"),AF452,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D452),ISBLANK(O452),ISBLANK(S452)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X452))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X453=\"x\",X453=\"X\"),AF453,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D453),ISBLANK(O453),ISBLANK(S453)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X453))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X454=\"x\",X454=\"X\"),AF454,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D454),ISBLANK(O454),ISBLANK(S454)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X454))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X455=\"x\",X455=\"X\"),AF455,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D455),ISBLANK(O455),ISBLANK(S455)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X455))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X456=\"x\",X456=\"X\"),AF456,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D456),ISBLANK(O456),ISBLANK(S456)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X456))","v":false}]
[]
[{"$nulls":17},"Points Earned #30",{"$f":"SUM(AF452:AF456)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z452:Z456),20)","v":0},{"$nulls":7},{"$f":"OR(AH452:AH456)","v":false},{"$f":"S458>0","v":false},false]
[]
[null,null,"No."]
[null,null,31,"Deliver a talk at a local chapter meeting of a national professional society on topic(s) directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C461)","v":"No. 31"}]
[{"$nulls":4},"*  Two (2) points per meeting."]
[{"$nulls":4},"*  Up to 10 points per five (5) years."]
[{"$nulls":4},"*  List of chapters, society and dates must be included for points to count"]
[null,null,null,"Chapter",null,null,"Society",null,null,"Title"]
[{"$nulls":25},{"$f":"IF(OR(X466=\"x\",X466=\"X\"),AF466,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D466),ISBLANK(G466),ISBLANK(J466)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X466))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X467=\"x\",X467=\"X\"),AF467,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D467),ISBLANK(G467),ISBLANK(J467)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X467))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X468=\"x\",X468=\"X\"),AF468,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D468),ISBLANK(G468),ISBLANK(J468)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X468))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X469=\"x\",X469=\"X\"),AF469,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D469),ISBLANK(G469),ISBLANK(J469)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X469))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X470=\"x\",X470=\"X\"),AF470,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D470),ISBLANK(G470),ISBLANK(J470)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X470))","v":false}]
[]
[{"$nulls":17},"Points Earned #31",{"$f":"SUM(AF466:AF470)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z466:Z470),20)","v":0},{"$nulls":7},{"$f":"OR(AH466:AH470)","v":false},{"$f":"S472>0","v":false},false]
[]
[null,null,"No."]
[null,null,32,"Attendance at a local chapter meeting of a national professional society with presentation topic(s) directly related to NCE.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C475)","v":"No. 32"}]
[{"$nulls":4},"*  Two (2) points per meeting."]
[{"$nulls":4},"*  Up to 10 points per five (5) years."]
[{"$nulls":4},"*  List of chapters, society and dates must be included for points to count"]
[null,null,null,"Chapter",null,null,"Society",null,null,"Title"]
[{"$nulls":25},{"$f":"IF(OR(X480=\"x\",X480=\"X\"),AF480,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D480),ISBLANK(G480),ISBLANK(J480)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X480))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X481=\"x\",X481=\"X\"),AF481,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D481),ISBLANK(G481),ISBLANK(J481)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X481))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X482=\"x\",X482=\"X\"),AF482,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D482),ISBLANK(G482),ISBLANK(J482)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X482))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X483=\"x\",X483=\"X\"),AF483,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D483),ISBLANK(G483),ISBLANK(J483)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X483))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X484=\"x\",X484=\"X\"),AF484,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D484),ISBLANK(G484),ISBLANK(J484)),0,2)","v":0},null,{"$f":"NOT(ISBLANK(X484))","v":false}]
[]
[{"$nulls":17},"Points Earned #32",{"$f":"SUM(AF480:AF484)","v":0},{"$nulls":6},{"$f":"MIN(SUM(Z480:Z484),20)","v":0},{"$nulls":7},{"$f":"OR(AH480:AH484)","v":false},{"$f":"S486>0","v":false},false]
[]
[null,null,"No."]
[null,null,33,"Participation in a self-teaching study group (of two (2) or more people) covering a minimum of 100 pages of a noise control text.",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C489)","v":"No. 33"}]
[{"$nulls":4},"*  Twenty (20) points per study session."]
[{"$nulls":4},"*  Up to 20 points per five (5) years."]
[{"$nulls":4},"*  Title and author of the text, pages covered, names of group participants and dates of study must be included for points to count"]
[]
[null,null,null,"Title of text"]
[]
[null,null,null,"Author of text"]
[]
[null,null,null,"Pages Covered"]
[]
[null,null,null,"Names of group participants"]
[]
[]
[]
[{"$nulls":17},"Points Earned #33",{"$f":"IF(OR(ISBLANK(G494),ISBLANK(G496),ISBLANK(H498),ISBLANK(J500),ISBLANK(J500)),0,20)","v":0},{"$nulls":6},{"$f":"IF(OR(X504=\"x\",X504=\"X\"),S504,0)","v":0},{"$nulls":7},{"$f":"NOT(ISBLANK(X504))","v":false},{"$f":"S504>0","v":false},false]
[]
[null,null,"No."]
[null,null,34,"Read at least three articles in a North American peer reviewed noise or acoustics journal.  These include NCEJ (Noise Control Engineering Journal), JASA (Journal of the Acoustical Society of America) and Canadian Acoustics",{"$nulls":20},{"$f":"CONCATENATE(\"No. \",C507)","v":"No. 34"}]
[{"$nulls":4},"*  Five (5) points per set of three articles."]
[{"$nulls":4},"*  Up to 10 points per five (5) years."]
[{"$nulls":4},"*  List of paper titles, volume and number of issues must be included for points to count"]
[null,null,null,"Set 1"]
[null,null,null,"Title",{"$nulls":12},"Volume",null,"Issue"]
[{"$nulls":25},{"$f":"IF(OR(X513=\"x\",X513=\"X\"),AF513,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D513),ISBLANK(Q513),ISBLANK(S513)),FALSE,TRUE)","v":false},null,{"$f":"NOT(ISBLANK(X513))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X514=\"x\",X514=\"X\"),AF514,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D514),ISBLANK(Q514),ISBLANK(S514)),FALSE,TRUE)","v":false},null,{"$f":"NOT(ISBLANK(X514))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X515=\"x\",X515=\"X\"),AF515,0)","v":0},null,{"$f":"IF(AND(Z515,Z514,Z513),5,0)","v":0},null,null,null,{"$f":"IF(OR(ISBLANK(D515),ISBLANK(Q515),ISBLANK(S515)),FALSE,TRUE)","v":false},{"$f":"IF(AND(AF515,AF514,AF513),5,0)","v":0},{"$f":"NOT(ISBLANK(X515))","v":false}]
[null,null,null,"Set 2"]
[{"$nulls":25},{"$f":"IF(OR(X517=\"x\",X517=\"X\"),AF517,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D517),ISBLANK(Q517),ISBLANK(S517)),FALSE,TRUE)","v":false},null,{"$f":"NOT(ISBLANK(X517))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X518=\"x\",X518=\"X\"),AF518,0)","v":0},{"$nulls":5},{"$f":"IF(OR(ISBLANK(D518),ISBLANK(Q518),ISBLANK(S518)),FALSE,TRUE)","v":false},null,{"$f":"NOT(ISBLANK(X518))","v":false}]
[{"$nulls":25},{"$f":"IF(OR(X519=\"x\",X519=\"X\"),AF519,0)","v":0},null,{"$f":"IF(AND(Z519,Z518,Z517),5,0)","v":0},null,null,null,{"$f":"IF(OR(ISBLANK(D519),ISBLANK(Q519),ISBLANK(S519)),FALSE,TRUE)","v":false},{"$f":"IF(AND(AF519,AF518,AF517),5,0)","v":0},{"$f":"NOT(ISBLANK(X519))","v":false}]
[]
[{"$nulls":17},"Points Earned #34",{"$f":"AG515+AG519","v":0},{"$nulls":6},{"$f":"AB515+AB519","v":0},{"$nulls":7},{"$f":"OR(AH513:AH519)","v":false},{"$f":"S521>0","v":false},false]
[]
[]
[]
[null,null,null,"END OF FORM"]