{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["B","A","DATA","Instructions","CEC Requirements","Premise"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":3,"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":"B","index":0,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,14,11,15],[2,1,3,1],[2,2,3,2],[2,3,3,3],[3,4,3,5],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[11,4,12,4],[11,5,12,5],[11,12,12,12],[6,12,7,12],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,12,9,12],[11,1,12,1],[11,2,12,2],[11,3,12,3],[13,12,15,12],[26,2,26,3],[27,2,27,3],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5]]}
[null,null,null,null,null,"Enter credits earned after this date:",{"$f":"IF(O12=\"\",\"\",(EDATE(L1,-60)))","v":""},null,null,null,"Enter credits earned before this date:",{"$f":"IF(O12=\"\",\"\",O12)","v":""}]
[null,"Sec","Description","Credits","Max %","Max credits",{"$f":"IF(G1=\"\",\"\",G1)","v":""},{"$f":"IF(G2=\"\",\"\",DATE(YEAR(G2)+1,MONTH(G2),DAY(G2)))","v":""},{"$f":"IF(H2=\"\",\"\",DATE(YEAR(H2)+1,MONTH(H2),DAY(H2)))","v":""},"","","","Totals",null,"Required CEC's:",{"$f":"IF(O12=\"\",\"\",IF(L1<=DATA!H3,DATA!I3,IF(AND(B!L1>=DATA!G4,L1<=DATA!H4),DATA!I4,IF(L1>=DATA!G5,DATA!I5,\"\"))))","v":""}]
[null,"9.6.3.1.2","Registered attendance at the IAI Annual International Educational Conference or other IAI state or regional conferences or other forensic meetings recognized by the Certification Board1","2 credits per half day (4 hours)","varies",{"$f":"IF(O12=\"\",\"\",IF(AND(L1<=DATA!H2),M27,IF(AND(L1>=DATA!G3,L1<=DATA!H3),M29,IF(AND(L1>=DATA!G4,L1<=DATA!H4),M29,IF(AND(L1>=DATA!G5),M30,\"\")))))","v":""},null,null,null,null,null,null,null,null,"CEC's Earned:",{"$f":"IF(M23=0,\"\",M23)","v":""}]
[null,null,null,null,"Allowed:",null,{"$f":"IF(G3=\"\",\"\",IF(G2<=$R$9,G3*$R$10,G3*$R$11))","v":""},"","","","","",{"$f":"IF(SUM(G4:L4)>=F3,F3,SUM(G4:L4))","v":0}]
[null,"9.6.3.1.3","Presentation of a paper","5 credits for each different paper",0.5,{"$f":"IF(P2=\"\",\"\",E5*$P$2)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G5:L5)>=F5,F5,SUM(G5:L5))","v":0}]
[null,"9.6.3.1.4","Participation in a panel discussion/plenary discussion/poster presentation","5 credits for each",0.5,{"$f":"IF($P$2=\"\",\"\",$P$2*E6)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G6:L6)>=F6,F6,SUM(G6:L6))","v":0}]
[null,"9.6.3.1.5","Conduct a training workshop or seminar for forensic examiners within the forensic disciplines","5 credits for each half-day presentation",0.5,{"$f":"IF($P$2=\"\",\"\",$P$2*E7)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G7:L8)>=F7,F7,SUM(G7:L8))","v":0}]
[]
[null,"9.6.3.1.6","Conduct a training workshop for non-examiners","3 credits for each half day presentation",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E9)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G9:L10)>=F9,F9,SUM(G9:L10))","v":0},null,null,null,null,"2020-02-29"]
[null,null,null,null,null,{"$f":"IF($F$24=\"\",\"\",$F$24*E10)","v":""},null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,"9.6.3.2","Articles published in board recognized forensic journals2","up to 10 credits per article",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E11)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G11:L11)>=F11,F11,SUM(G11:L11))","v":0},null,null,null,null,0.5]
[null,"9.6.3.3","Attendance at or participation in a course or workshop or in-service training recognized by the individual Certification Board","one credit per 2 hours",0.75,{"$f":"IF($P$2=\"\",\"\",$P$2*E12)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G12:L13)>=F12,F12,SUM(G12:L13))","v":0}]
[null,null,null,null,null,{"$f":"IF($F$24=\"\",\"\",$F$24*E13)","v":""}]
[null,"9.6.3.4","Holding an office or serving on a committee in a forensic society recognized by the Certification Board or performing an official service for a forensic journal publication","5 credits for each year served",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E14)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G14:L16)>=F14,F14,SUM(G14:L16))","v":0}]
[]
[]
[null,"9.6.3.5","Membership in a forensic society recognized by the Certification Board","1 credit earned per year of membership per organization",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E17)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G17:L17)>=F17,F17,SUM(G17:L17))","v":0}]
[null,"9.6.3.6","Acting as the primary provider of on-the-job training for novice forensic examiners","5 credits for each year in which training is provided",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E18)","v":""},null,null,null,null,null,null,0]
[null,"9.6.3.7","Providing a written summary (minimum of 250 words) of an article written by another forensic examiner or related professional and published within the last 5 years","2 credits per article allowed",0.4,{"$f":"IF($P$2=\"\",\"\",$P$2*E19)","v":""},null,null,null,null,null,null,0]
[null,"9.6.3.8","Any other activity that an applicant for recertification feels that the specific Certification Board should consider, such as teaching forensic related college courses, research and presentations to the general public, etc.","maximum of 30%\n(contact the board secretary for calculation of credits)",0.3,{"$f":"IF($P$2=\"\",\"\",$P$2*E20)","v":""},null,null,null,null,null,null,0]
[null,"9.6.3.9","Full-time forensic casework, i.e. more than 50% of job duties conducting forensic science examinations","4 credits/year allowed",null,20,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total:…",{"$f":"SUM(M4:M21)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"2020-02-29",80,0.75,60]
[null,null,null,null,null,null,null,null,"2020-03-01","2020-08-31",80,0.5,40]
[null,null,null,null,null,null,null,null,"2020-09-01","2021-02-28",100,0.5,50]
[null,null,null,null,null,null,null,null,"2021-03-01",null,120,0.5,60]

{"sheet":"A","index":1,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,2,26,3],[27,2,27,3],[6,12,7,12],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,12,12,12],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,12,9,12],[13,1,15,1],[2,1,3,1],[2,2,3,2],[2,3,3,3],[3,4,3,5],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[13,12,15,12]]}
[null,null,null,null,null,"Enter credits earned after this date:",{"$f":"Instructions!D14","v":""},null,null,null,"Enter credits earned before this date:",{"$f":"IF(G1=\"\",\"\",EDATE(G1,60))","v":""}]
[null,"Sec","Description","Credits","Max %","Max credits",{"$f":"IF(G1=\"\",\"\",G1)","v":""},{"$f":"IF(G2=\"\",\"\",DATE(YEAR(G2)+1,MONTH(G2),DAY(G2)))","v":""},{"$f":"IF(H2=\"\",\"\",DATE(YEAR(H2)+1,MONTH(H2),DAY(H2)))","v":""},"","","","Totals",null,"Required CEC's:",{"$f":"IF(L1=\"\",\"\",IF(L1<=DATA!H3,DATA!I3,IF(AND(A!L1>=DATA!G4,L1<=DATA!H4),DATA!I4,IF(L1>=DATA!G5,DATA!I5,\"\"))))","v":""}]
[null,"9.6.3.1.2","Registered attendance at the IAI Annual International Educational Conference or other IAI state or regional conferences or other forensic meetings recognized by the Certification Board1","2 credits per half day (4 hours)","varies",{"$f":"IF(G1=\"\",\"\",IF(AND(L1<=DATA!H2),M27,IF(AND(L1>=DATA!G3,L1<=DATA!H3),M29,IF(AND(L1>=DATA!G4,L1<=DATA!H4),M29,IF(AND(L1>=DATA!G5),M30,\"\")))))","v":""},null,null,null,null,null,null,null,null,"CEC's Earned:",{"$f":"IF(M23=0,\"\",M23)","v":""}]
[null,null,null,null,"Allowed:",null,{"$f":"IF(G3=\"\",\"\",IF(G2<=$R$9,G3*$R$10,G3*$R$11))","v":""},"","","","","",{"$f":"IF(SUM(G4:L4)>=F3,F3,SUM(G4:L4))","v":0}]
[null,"9.6.3.1.3","Presentation of a paper","5 credits for each different paper",0.5,{"$f":"IF(P2=\"\",\"\",E5*$P$2)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G5:L5)>=F5,F5,SUM(G5:L5))","v":0}]
[null,"9.6.3.1.4","Participation in a panel discussion/plenary discussion/poster presentation","5 credits for each",0.5,{"$f":"IF($P$2=\"\",\"\",$P$2*E6)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G6:L6)>=F6,F6,SUM(G6:L6))","v":0}]
[null,"9.6.3.1.5","Conduct a training workshop or seminar for forensic examiners within the forensic disciplines","5 credits for each half-day presentation",0.5,{"$f":"IF($P$2=\"\",\"\",$P$2*E7)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G7:L8)>=F7,F7,SUM(G7:L8))","v":0}]
[]
[null,"9.6.3.1.6","Conduct a training workshop for non-examiners","3 credits for each half day presentation",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E9)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G9:L10)>=F9,F9,SUM(G9:L10))","v":0},null,null,null,null,"2020-02-29"]
[null,null,null,null,null,{"$f":"IF($F$24=\"\",\"\",$F$24*E10)","v":""},null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,"9.6.3.2","Articles published in board recognized forensic journals2","up to 10 credits per article",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E11)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G11:L11)>=F11,F11,SUM(G11:L11))","v":0},null,null,null,null,0.5]
[null,"9.6.3.3","Attendance at or participation in a course or workshop or in-service training recognized by the individual Certification Board","one credit per 2 hours",0.75,{"$f":"IF($P$2=\"\",\"\",$P$2*E12)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G12:L13)>=F12,F12,SUM(G12:L13))","v":0}]
[null,null,null,null,null,{"$f":"IF($F$24=\"\",\"\",$F$24*E13)","v":""}]
[null,"9.6.3.4","Holding an office or serving on a committee in a forensic society recognized by the Certification Board or performing an official service for a forensic journal publication","5 credits for each year served",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E14)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G14:L16)>=F14,F14,SUM(G14:L16))","v":0}]
[]
[]
[null,"9.6.3.5","Membership in a forensic society recognized by the Certification Board","1 credit earned per year of membership per organization",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E17)","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(G17:L17)>=F17,F17,SUM(G17:L17))","v":0}]
[null,"9.6.3.6","Acting as the primary provider of on-the-job training for novice forensic examiners","5 credits for each year in which training is provided",0.25,{"$f":"IF($P$2=\"\",\"\",$P$2*E18)","v":""},null,null,null,null,null,null,0]
[null,"9.6.3.7","Providing a written summary (minimum of 250 words) of an article written by another forensic examiner or related professional and published within the last 5 years","2 credits per article allowed",0.4,{"$f":"IF($P$2=\"\",\"\",$P$2*E19)","v":""},null,null,null,null,null,null,0]
[null,"9.6.3.8","Any other activity that an applicant for recertification feels that the specific Certification Board should consider, such as teaching forensic related college courses, research and presentations to the general public, etc.","maximum of 30%\n(contact the board secretary for calculation of credits)",0.3,{"$f":"IF($P$2=\"\",\"\",$P$2*E20)","v":""},null,null,null,null,null,null,0]
[null,"9.6.3.9","Full-time forensic casework, i.e. more than 50% of job duties conducting forensic science examinations","4 credits/year allowed",null,20,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total:…",{"$f":"SUM(M4:M21)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"2020-02-29",80,0.75,60]
[null,null,null,null,null,null,null,null,"2020-03-01","2020-08-31",80,0.5,40]
[null,null,null,null,null,null,null,null,"2020-09-01","2021-02-28",100,0.5,50]
[null,null,null,null,null,null,null,null,"2021-03-01",null,120,0.5,60]

{"sheet":"DATA","index":2,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,"Location","Conferences","Start","End",null,"start","end","required","Conf %","Max"]
[null,"Orlando",2020,"2020-08-09","2020-08-15",null,null,"2020-02-29",80,0.75,60]
[null,"Nashville",2021,"2021-08-01","2021-08-07",null,"2020-03-01","2020-08-31",80,0.5,40]
[null,"Omaha",2022,"2022-08-06","2022-08-06",null,"2020-09-01","2021-02-28",100,0.5,50]
[null,"Maryland",2023,"2023-08-20","2023-08-26",null,"2021-03-01",null,120,0.5,60]
[null,"Reno",2024,"2024-08-11","2024-08-17"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-29"]
[null,null,null,null,null,"2017-10-01",{"$f":"IF(F10=\"\",\"\",DATE(YEAR(F10)+1,MONTH(F10),DAY(F10)))","v":"2018-10-01"},{"$f":"IF(G10=\"\",\"\",DATE(YEAR(G10)+1,MONTH(G10),DAY(G10)))","v":"2019-10-01"},"2020-10-01","2021-10-01",{"$f":"IF(J10=\"\",\"\",DATE(YEAR(J10)+1,MONTH(J10),DAY(J10)))","v":"2022-10-01"},null,null,null,null,null,null,0.75]
[null,null,{"$f":"IF(A!L2<=DATA!E2,1,IF(A!L2<=DATA!E3,2,IF(A!L2<=DATA!E4,3,IF(A!L2<=DATA!E5,4,IF(A!L2<=DATA!E6,5,IF(A!L2>=DATA!E6,6,\"\"))))))","v":6},null,null,null,20,20,20,20,1,null,null,null,null,null,null,0.5]
[null,null,null,null,null,{"$f":"IF(F11=\"\",\"\",IF(F10<=$R$9,F11*$R$10,F11*$R$11))","v":""},15,15,10,10,0.5]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(AND(F10>G10,\"2015\"),\"\")","v":false}]
[]
[null,null,null,null,null,{"$f":"(IF(E3>=H18,\"NO\",\"YES\"))","v":"NO"},null,"2020-08-15"]

{"sheet":"Instructions","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,1,3,5]]}
[]
[]
[]
[]
[]
[null,null,"Enter the date your certification expires:",null,null,{"$f":"IF(D6=\"\",\"\",A!P2)","v":""},"Credits required for recertification"]
[]
[null,null,"This is the earliest date you can apply for recertification:",{"$f":"IF(D6=\"\",\"\",EDATE(D6,-12))","v":""}]
[]
[null,null,"Enter the date you plan to complete your eCert application:"]
[]
[null,null,{"$f":"IF(D12=\"\",\"\",\"The deadline for submitting your practical exam:\")","v":""},{"$f":"IF(D10=\"\",\"\",EDATE(D10,6))","v":""},{"$f":"IF(D12=\"\",\"\",\"or 30-days from the time you receive your practical exam, whichever is earlier\")","v":""}]
[]
[null,null,"Continuing Education Credits (CEC's) can be added from this date:",{"$f":"IF(D10=\"\",\"\",EDATE(D6,-60))","v":""},{"$f":"IF(D14=\"\",\"\",\"Please proceed to Worksheet A\")","v":""}]

{"sheet":"CEC Requirements","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Premise","index":5,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Premise:","Can apply for recertification up to and including the date they expire"]
[]
[null,null,"Even though conference credit maximums were reduced, any conference attended prior to this change will receive credit expected at that time.  Note that workshops attended at those conferences cannot be incuded."]
[]
[null,null,"Credits received for attending the 2020 and later conferences are reduced, but full credit for workshop attendance at those conferences will be given."]