{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Applicant Instructions","Application","Basic \"Core\" IS Courses","Intermediate \"Core\" IS Courses","Advanced \"Core\" IS Courses","\"Core\" Non-IS Courses","\"Optional\" Courses","Higher Education Credit","Instructional Credit","Conference Credit","Disaster Credit","Recertifications Hours","Summary of Hours"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"Applicant Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Application","index":1,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,1,9],[5,2,5,5],[11,6,11,9],[11,2,11,4],[7,2,7,9],[9,2,9,4],[3,2,3,9],[41,1,44,9],[16,2,16,4],[29,1,29,6],[33,1,33,9],[26,5,26,8],[34,1,34,9],[35,1,35,9],[36,1,36,9],[14,1,14,3],[15,1,15,2],[14,6,14,7],[14,8,14,9],[37,1,37,9]]}
[null,null,null,null,null,null,null,null,null,null,null,"None","Employee"]
[null,"Name of Applicant:",null,null,null,null,null,null,null,null,null,"Basic","Support staff"]
[null,null,null,null,null,null,null,null,null,null,null,"Intermediate","Volunteer"]
[null,"Address of Applicant:",null,null,null,null,null,null,null,null,null,"Advanced"]
[null,null,null,null,null,null,null,null,null,null,null,"Masters"]
[null,"City:",null,null,null,null,"State:",null,"ZIP:",null,null,"ReCert"]
[]
[null,"Email Address:"]
[]
[null,"Date of Application:"]
[]
[null,"Work Phone:",null,null,null,"Cell Phone:"]
[]
[]
[null,"Current Level of Certification:",null,null,null,null,"Year Certified:"]
[null,"Certification Sought:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Are you an emergency management student?"]
[]
[]
[]
[null,"Should we send a notification letter to someone upon your receipt of certification?"]
[null,"If yes, please provide names, titles and mailing addresses for any contacts (including media) you would like us to notify. Limit 1 Supervisor & 2 Media."]

{"sheet":"Basic \"Core\" IS Courses","index":2,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,3],[24,0,24,3]]}
["20 Required Courses for Basic Level - Reference Cert. Rules Page 2"]
["Date Completed","IS Course #","Course Name","Contact Hours"]
[null,"IS-5","An Introduction to Hazardous Materials"]
[null,"IS-100","Introduction to Incident Command"]
[null,"IS-120","An Orientation to Community Disaster Exercises"]
[null,"IS-200","ICS for Single and Initial Action Incidents"]
[null,"IS-230.d","Fundamentals of Emergency Management"]
[null,"IS-235.c","Emergency Planning"]
[null,"IS-240.c","Leadership and Influence"]
[null,"IS-241.c","Decision Making and Problem Solving"]
[null,"IS-242.c","Effective Communication"]
[null,"IS-244.b","Developing and Managing Volunteers"]
[null,"IS-317.a","Introduction to Community Emergency Response Teams (CERT)"]
[null,"IS-700.b","An Introduction to the National Incident Management System"]
[null,"IS-800.d","National Response Framework, an Introduction"]
[null,"IS-2000","National Preparedness Goal and System Overview"]
[null,"IS-2500","National Prevention Framework, an Introduction"]
[null,"IS-2600","National Protection Framework, an Introduction"]
[null,"IS-2700","National Mitigation Framework, an Introduction"]
[null,"IS-2900.a","National Disaster Recovery Framework, an Introduction"]
[null,"IS-2901","Introduction to Community Lifelines"]
[null,"Q-890","Emergency Response to Terrorism. Course is offered through the U.S. Fire Administration: https://apps.usfa.fema.gov/nfacourses/catalog/details/67"]
[null,null,"Course Hours Total:",{"$f":"SUM(D3:D22)","v":0}]
[]
["Additional Core IS Classes for BLEM Certification Application"]
["Date Completed","IS Course #","Course Name","Contact Hours"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Non IS Course Total Hours:",{"$f":"SUM(D27:D58)","v":0}]

{"sheet":"Intermediate \"Core\" IS Courses","index":3,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[18,0,18,3],[0,0,0,3]]}
["14 Required Courses for Intermediate Level - Reference Cert. Rules Page 2"]
["Date Completed","IS Course #","Course Name","Contact Hours"]
[null,"IS-10.a","Animals in Disasters: Awareness and Preparedness"]
[null,"IS-15","Special Events Contingency Planning for Public Safety Agencies"]
[null,"IS-26","Guide to Points of Distribution"]
[null,"IS-42.a","Social Media in Emergency Management"]
[null,"IS-130","Exercise Evaluation & Improvement Planning"]
[null,"IS-201","Forms Used for the Development of the Incident Action Plan"]
[null,"IS-240","Leadership & Influence"]
[null,"IS-288","The Role of Volunteer Agencies in Emergency Management"]
[null,"IS-362","Multi-Hazard Emergency Planning for Schools"]
[null,"IS-366.a","Planning for the Needs of Children in Disasters"]
[null,"IS-368.a","Including People with Disabilities & Others with Access & Functional Needs in Disaster Operations"]
[null,"IS-403","Introduction to Individual Assistance"]
[null,"IS-559","Local Damage Assessment"]
[null,"IS-1000","Public Assistance Program & Eligibility"]
[null,null,"Course Hours Total:",{"$f":"SUM(D3:D16)","v":0}]
[]
["Additional Core IS Classes for ILEM Certification Application"]
["Date Completed","IS Course #","Course Name","Contact Hours"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Non IS Course Total Hours:",{"$f":"SUM(D21:D52)","v":0}]

{"sheet":"Advanced \"Core\" IS Courses","index":4,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,3],[17,0,17,3]]}
["13 Required Courses for Advance Level - Reference Cert. Rules Page 3"]
["Date Completed","IS Course #","Course Name","Contact Hours"]
[null,"IS-29.a","Public Information Officer Awareness"]
[null,"IS-75","Military Resources in Emergency Management"]
[null,"IS-271","Anticamping Hazardous Weather & Community Risk"]
[null,"IS-393","Introduction to Mitigation"]
[null,"IS-552","The Public Works Role in Emergency Management"]
[null,"IS-772.a","Individual Assistance Preliminary Damage Assessment Orientation"]
[null,"IS-1006","Documenting Disaster Damage & Developing Project Files"]
[null,"IS-1009","Conditions for Public Assistance Grant"]
[null,"IS-1010","Emergency Protective Measures"]
[null,"IS-2001","Threat and Hazard Identification and Risk Assessment (THIRA)"]
[null,"IS-2200","Basic Emergency Operations Center Functions"]
[null,"ICS-300","ICS-300 Intermediate ICS for Expanding Incidents – (G300)"]
[null,"ICS-400","ICS-400 Advanced ICS Command & General Staff – (G400)"]
[null,null,"Course Hours Total:",{"$f":"SUM(D3:D15)","v":0}]
[]
["Additional Core IS Classes for ALEM Certification Application"]
["Date Completed","IS Course #","Course Name","Contact Hours"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Non IS Course Total Hours:",{"$f":"SUM(D20:D51)","v":0}]

{"sheet":"\"Core\" Non-IS Courses","index":5,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":false,"merged":[[0,0,0,4],[124,1,130,1]]}
["\"Core\" Non-IS Course Credit Hours - Reference Cert. Rules Page 7"]
["Date Completed","Name of Course","Sponsored By","Contact Hours","Applied To"]
["2024-04-01","NEMA","FEMA",40,"Basic","Example"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Advance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ReCert"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do Not Edit These Cells","BLEM-Credited Hours This Worksheet",{"$f":"SUMIF(E4:E124, \"Basic\", D4:D124)","v":0}]
[null,null,"(200 hours including Core IS) Total BLEM ",{"$f":"SUM('Basic \"Core\" IS Courses'!D23,'Basic \"Core\" IS Courses'!D59)+(SUMIF(E4:E124, \"Basic\", D4:D124))","v":0}]
[null,null,"ILEM-Credited Hours This Worksheet",{"$f":"(SUMIF(E4:E124,\"Intermediate\",D4:D124))","v":0}]
[null,null,"(450 hours including Core IS) ILEM Hours",{"$f":"SUM(D126+'Intermediate \"Core\" IS Courses'!D17,'Intermediate \"Core\" IS Courses'!D53)+(SUMIF(E4:E124, \"Intermediate\", D4:D124))","v":0}]
[null,null,"ALEM-Credited Hours This Worksheet",{"$f":"SUMIF(E4:E124, \"Advance\", D4:D124)","v":0}]
[null,null,"(700 hours including Core IS) ALEM Hours",{"$f":"(D128)+SUM('Advanced \"Core\" IS Courses'!D52,'Advanced \"Core\" IS Courses'!D16)+(SUMIF(E4:E124, \"Advance\", D4:D124))","v":0}]
[null,null,"ReCert Hours",{"$f":"SUMIF(E4:E124, \"ReCert\", D4:D124)","v":0}]

{"sheet":"\"Optional\" Courses","index":6,"n_rows":131,"n_cols":11,"rows_kept":131,"cut":false,"hidden":false,"merged":[[0,0,0,4],[127,1,130,1]]}
["\"Optional\" Course Credit Hours - Reference Cert. Rules Page 7"]
["Date Completed","Name of Course","Sponsored By","Contact Hours","Applied To"]
["2024-04-01","Firefighter I","Alabama Fire College",40,"Basic","Example"]
[null,null,null,null,null,null,null,null,null,null,"Basic"]
[null,null,null,null,null,null,null,null,null,null,"Intermediate"]
[null,null,null,null,null,null,null,null,null,null,"Advance"]
[null,null,null,null,null,null,null,null,null,null,"ReCert"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do Not Edit These Cells","(100 hours required) BLEM Hours",{"$f":"SUMIF(E4:E127, \"Basic\", D4:D127)","v":0}]
[null,null,"(100 hours required) ILEM Hours",{"$f":"SUMIF(E5:E128, \"Intermediate\", D5:D128)","v":0}]
[null,null,"(100 hours required) ALEM Hours",{"$f":"SUMIF(E6:E129, \"Advance\", D6:D129)","v":0}]
[null,null,"ReCert Hours",{"$f":"SUMIF(E7:E130, \"ReCert\", D7:D130)","v":0}]

{"sheet":"Higher Education Credit","index":7,"n_rows":112,"n_cols":12,"rows_kept":112,"cut":false,"hidden":false,"merged":[[9,2,9,3],[105,1,111,1],[14,0,14,5],[0,0,0,4],[2,1,2,3],[5,2,5,3],[6,2,6,3],[8,2,8,3]]}
["Higher Education Credit Hours - Reference Cert. Rules Page 7"]
[]
[null,"NOTE: COLLEGE CLASS WORK FORMULA (AS OF 5/1/24)"]
[null,null,null,null,null,null,null,null,null,null,null,"Core"]
[null,null,null,null,null,null,null,null,null,null,null,"Optional"]
[null,"Quarter Hour Credit","10 contact hours credit for each quarter hour taken",null,null,null,null,null,null,null,"Basic"]
[null,null,"3 qtr hrs = 30 contact hrs",null,null,null,null,null,null,null,"Intermediate"]
[null,null,null,null,null,null,null,null,null,null,"Advance"]
[null,"Semester & Term Hour Credit","15 contact hours credit for each semester hour taken",null,null,null,null,null,null,null,"Recert"]
[null,null,"3 sem hrs = 45 contact hours"]
[]
[]
["2020-12-15","Effective Emergency Management 101","University of EMI at Alabama",45,"Core","Basic","Example"]
["2020-12-15","Sportscasting 101","University of EMA at Alabama",45,"Optional","Advance","Example"]
["Higher Education Credit Hours"]
["Date Completed","Name of Course","School Name","Contact Hours","Credit Type","Applied To"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do Not Edit These Cells","Core Basic Total",{"$f":"SUMIFS(Table3[Contact Hours],Table3[Applied To],\"Basic\",Table3[Credit Type],\"Core\")","v":0}]
[null,null,"Optional Basic Total",{"$f":"SUMIFS(Table3[Contact Hours],Table3[Applied To],\"Basic\",Table3[Credit Type],\"Optional\")","v":0}]
[null,null,"Core Intermediate Total",{"$f":"SUMIFS(Table3[Contact Hours],Table3[Applied To],\"Intermediate\",Table3[Credit Type],\"Core\")","v":0}]
[null,null,"Optional Intermediate Total",{"$f":"SUMIFS(Table3[Contact Hours],Table3[Applied To],\"Intermediate\",Table3[Credit Type],\"Optional\")","v":0}]
[null,null,"Core Advance Total",{"$f":"SUMIFS(Table3[Contact Hours],Table3[Applied To],\"Advance\",Table3[Credit Type],\"Core\")","v":0}]
[null,null,"Optional Advance Total",{"$f":"SUMIFS(Table3[Contact Hours],Table3[Applied To],\"Advance\",Table3[Credit Type],\"Optional\")","v":0}]
[null,null,"Recert",{"$f":"SUMIFS(Table3[Contact Hours],Table3[Applied To],\"Recert\",Table3[Credit Type],\"Core\")","v":0}]

{"sheet":"Instructional Credit","index":8,"n_rows":66,"n_cols":11,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,2,65,3],[59,1,65,1],[0,0,0,5],[59,0,65,0],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3]]}
["Instructional Credit - Reference Cert. Rules Page 7"]
["Date Completed","Name of Course You Taught","Course Sponsor","Core or Optional?","Applied to:","Hours",null,null,null,"Core","BLEM"]
["2024-06-01","ICS-300","AAEM University","Core","ILEM",12,"Example, and here, 12 of the 25 total hours allowed to be claimed will go toward Core hours, leaving 13 additional hours available.",null,null,"Optional","ILEM"]
["2024-06-01","EMT Basic","I CARE, LLC","Optional","ALEM",140,"Example, and here, only 25 of the 140 hours can be claimed.  A max of 25 hours of instruction time can be claimed for each certification level.",null,null,null,"ALEM"]
["2024-06-01","Advanced Academy","AAEM University","Core","ReCert",40,"Example, and here, 25 hours will be counted because only 25 instructional hours per year will count towards a renewal.",null,null,null,"ReCert"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["25 hours max can be applied towards each certification level.\n\nThose 25 can be split between Core & Optional.","Do Not Edit\nThese Cells  ","BLEM Core Hours",null,{"$f":"SUMIFS(F6:F59, E6:E59, \"BLEM\", D6:D59, \"Core\")","v":0},{"$f":"IF(E60>25, \"25\", E60)","v":0}]
[null,null,"BLEM Optional Hours",null,{"$f":"SUMIFS(F7:F59, E7:E59, \"BLEM\", D7:D59, \"Optional\")","v":0},{"$f":"IF(E61>25, \"25\", E61)","v":0}]
[null,null,"ILEM Core Houres",null,{"$f":"SUMIFS(F8:F59, E8:E59, \"ILEM\", D8:D59, \"Core\")","v":0},0]
[null,null,"ILEM Optional Hours",null,{"$f":"SUMIFS(F9:F59, E9:E59, \"ILEM\", D9:D59, \"Optional\")","v":0},0]
[null,null,"ALEM Core Hours",null,{"$f":"SUMIFS(F10:F59, E10:E59, \"ALEM\", D10:D59, \"Core\")","v":0},0]
[null,null,"ALEM Optional Hours",null,{"$f":"SUMIFS(F11:F59, E11:E59, \"ALEM\", D11:D59, \"Optional\")","v":0},0]
[null,null,"ReCert Hours",null,{"$f":"SUMIFS(F12:F59, E12:E59, \"Recert\")","v":0},0]

{"sheet":"Conference Credit","index":9,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,3],[30,1,33,1]]}
["Conference Credit (CORE) - Reference Cert. Rules Page 7"]
["Conference Dates","Name of Conference","Applied to:","Hours",null,null,null,"Core","BLEM"]
["6/13-15/2023","AAEM Summer Conference","ILEM",12,"Example",null,null,"Optional","ILEM"]
[null,null,null,null,null,null,null,null,"ALEM"]
[null,null,null,null,null,null,null,null,"ReCert"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do Not Edit These Cells","BLEM Hours",{"$f":"SUMIF(C4:C30, \"BLEM\", D4:D30)","v":0}]
[null,null,"ILEM Hours",{"$f":"SUMIF(C4:C30, \"ILEM\", D4:D30)","v":0}]
[null,null,"ALEM Hours",{"$f":"SUMIF(C4:C30, \"ALEM\", D4:D30)","v":0}]
[null,null,"ReCert Hours",{"$f":"SUMIF(C4:C30, \"ReCERT\", D4:D30)","v":0}]

{"sheet":"Disaster Credit","index":10,"n_rows":344,"n_cols":12,"rows_kept":344,"cut":false,"hidden":false,"merged":[[340,3,340,5],[340,6,340,7],[341,3,341,5],[342,3,342,8],[343,3,343,8],[320,1,320,4],[320,5,320,8],[322,2,322,8],[326,1,326,4],[334,2,334,8],[336,2,336,4],[314,1,314,4],[314,5,314,8],[316,1,316,4],[316,5,316,8],[318,1,318,4],[318,5,318,8],[305,1,305,8],[308,1,308,4],[308,5,308,8],[310,1,310,4],[310,5,310,8],[312,1,312,4],[312,5,312,8],[292,3,292,5],[292,6,292,7],[293,3,293,5],[294,3,294,8],[295,3,295,8],[302,1,303,2],[302,3,302,8],[303,3,303,8],[272,1,272,4],[272,5,272,8],[274,2,274,8],[278,1,278,4],[286,2,286,8],[288,2,288,4],[266,1,266,4],[266,5,266,8],[268,1,268,4],[268,5,268,8],[270,1,270,4],[270,5,270,8],[257,1,257,8],[260,1,260,4],[260,5,260,8],[262,1,262,4],[262,5,262,8],[264,1,264,4],[264,5,264,8],[245,3,245,5],[246,3,246,8],[247,3,247,8],[254,1,255,2],[254,3,254,8],[255,3,255,8],[226,2,226,8],[230,1,230,4],[238,2,238,8],[240,2,240,4],[244,3,244,5],[244,6,244,7],[220,1,220,4],[220,5,220,8],[222,1,222,4],[222,5,222,8],[224,1,224,4],[224,5,224,8],[214,1,214,4],[214,5,214,8],[216,1,216,4],[216,5,216,8],[218,1,218,4],[218,5,218,8],[206,1,207,2],[206,3,206,8],[207,3,207,8],[209,1,209,8],[212,1,212,4],[212,5,212,8],[2,3,2,8],[3,3,3,8],[2,1,3,2],[20,1,20,4],[8,5,8,8],[10,5,10,8],[14,1,14,4],[16,1,16,4],[44,3,44,8],[12,5,12,8],[14,5,14,8],[16,5,16,8],[22,2,22,8],[26,1,26,4],[18,5,18,8],[20,5,20,8],[18,1,18,4],[46,3,46,8],[40,6,40,7],[42,3,42,5],[40,3,40,5],[5,1,5,8],[36,2,36,4],[34,2,34,8],[8,1,8,4],[10,1,10,4],[12,1,12,4],[53,1,54,2],[53,3,53,8],[54,3,54,8],[56,1,56,8],[59,1,59,4],[59,5,59,8],[61,1,61,4],[61,5,61,8],[63,1,63,4],[63,5,63,8],[65,1,65,4],[65,5,65,8],[67,1,67,4],[67,5,67,8],[69,1,69,4],[69,5,69,8],[71,1,71,4],[71,5,71,8],[73,2,73,8],[77,1,77,4],[85,2,85,8],[87,2,87,4],[91,3,91,5],[91,6,91,7],[93,3,93,5],[95,3,95,8],[97,3,97,8],[104,1,105,2],[104,3,104,8],[105,3,105,8],[107,1,107,8],[110,1,110,4],[110,5,110,8],[112,1,112,4],[112,5,112,8],[114,1,114,4],[114,5,114,8],[116,1,116,4],[116,5,116,8],[118,1,118,4],[118,5,118,8],[120,1,120,4],[120,5,120,8],[122,1,122,4],[122,5,122,8],[124,2,124,8],[128,1,128,4],[136,2,136,8],[138,2,138,4],[142,3,142,5],[142,6,142,7],[144,3,144,5],[146,3,146,8],[148,3,148,8],[155,1,156,2],[155,3,155,8],[156,3,156,8],[158,1,158,8],[161,1,161,4],[161,5,161,8],[163,1,163,4],[163,5,163,8],[165,1,165,4],[165,5,165,8],[189,2,189,4],[167,1,167,4],[167,5,167,8],[169,1,169,4],[169,5,169,8],[171,1,171,4],[171,5,171,8],[193,3,193,5],[193,6,193,7],[195,3,195,5],[197,3,197,8],[199,3,199,8],[173,1,173,4],[173,5,173,8],[175,2,175,8],[179,1,179,4],[187,2,187,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"\"Core\" credit"]
[null,"Note:",null,"SEE THE AAEM CERTIFICATION PROGRAM RULES FOR SPECIFIC ",null,null,null,null,null,null,"Declared (Emergency, Major, SBA)","\"Optional\" credit"]
[null,null,null,"REQUIREMENTS AND GUIDANCE - PAGE 8",null,null,null,null,null,null,"Incident of Nat. Sign. (SEAR 1-3, Other)","No preference"]
[null,null,null,null,null,null,null,null,null,null,"State Declared Disaster"]
[null,"  To which level should this credit be applied?",null,null,null,null,null,null,null,null,"Other (specify)"]
[]
[]
[null,"Type of disaster:"]
[]
[null,"Date of disaster:"]
[]
[null,"Disaster assignment:"]
[]
[null,"County of assignment:"]
[]
[null,"Was this your home jurisdiction?"]
[]
[null,"What was the type of declaration?"]
[]
[null,"Number of hours worked on this disaster:"]
[]
[null,"Notes:"]
[]
[]
[]
[null,"How should this credit be applied?"]
[]
[]
[]
[null,"Name of contact for verification:"]
[]
[null,"Phone number:",null,null,null,null,"Ext:"]
[]
[null,"Address:"]
[]
[null,"City:",null,null,null,"State:",null,"ZIP:"]
[]
[]
[]
[null,"Verified by:",null,null,null,null,"Type verification:"]
[]
[null,"Credit hours allowed:"]
[]
[null,"Credit applied to:",null,"Basic             Intermediate             Advanced             Masters          Re-Certification"]
[]
[null,"Applied as:",null,"\"Core\" credit          \"Optional\" credit"]
[]
[null,null,null,null,null,null,null,null,null,null,"SBA","\"Core\" credit"]
[]
[]
[]
[]
[null,"Note:",null,"SEE THE AAEM CERTIFICATION PROGRAM RULES FOR SPECIFIC ",null,null,null,null,null,null,"FEMA","\"Optional\" credit"]
[null,null,null,"REQUIREMENTS AND GUIDANCE",null,null,null,null,null,null,"Emergency","No preference"]
[null,null,null,null,null,null,null,null,null,null,"Other (specify)"]
[null,"  To which level should this credit be applied?"]
[]
[]
[null,"Type of disaster:"]
[]
[null,"Date of disaster:"]
[]
[null,"Disaster assignment:"]
[]
[null,"County of assignment:"]
[]
[null,"Was this your home jurisdiction?"]
[]
[null,"What was the type of declaration?"]
[]
[null,"Number of hours worked on this disaster:"]
[]
[null,"Notes:"]
[]
[]
[]
[null,"How should this credit be applied?"]
[]
[]
[]
[null,"Name of contact for verification:"]
[]
[null,"Phone number:",null,null,null,null,"Ext:"]
[]
[null,"Address:"]
[]
[null,"City:",null,null,null,"State:",null,"ZIP:"]
[]
[]
[]
[null,"Verified by:",null,null,null,null,"Type verification:"]
[]
[null,"Credit hours allowed:"]
[]
[null,"Credit applied to:",null,"Basic             Intermediate             Advanced             Masters        Re-Certification"]
[]
[null,"Applied as:",null,"\"Core\" credit          \"Optional\" credit"]
[]
[]
[]
[]
[]
[]
[null,"Note:",null,"SEE THE AAEM CERTIFICATION PROGRAM RULES FOR SPECIFIC ",null,null,null,null,null,null,"FEMA","\"Optional\" credit"]
[null,null,null,"REQUIREMENTS AND GUIDANCE",null,null,null,null,null,null,"Emergency","No preference"]
[null,null,null,null,null,null,null,null,null,null,"Other (specify)"]
[null,"  To which level should this credit be applied?"]
[]
[]
[null,"Type of disaster:"]
[]
[null,"Date of disaster:"]
[]
[null,"Disaster assignment:"]
[]
[null,"County of assignment:"]
[]
[null,"Was this your home jurisdiction?"]
[]
[null,"What was the type of declaration?"]
[]
[null,"Number of hours worked on this disaster:"]
[]
[null,"Notes:"]
[]
[]
[]
[null,"How should this credit be applied?"]
[]
[]
[]
[null,"Name of contact for verification:"]
[]
[null,"Phone number:",null,null,null,null,"Ext:"]
[]
[null,"Address:"]
[]
[null,"City:",null,null,null,"State:",null,"ZIP:"]
[]
[]
[]
[null,"Verified by:",null,null,null,null,"Type verification:"]
[]
[null,"Credit hours allowed:"]
[]
[null,"Credit applied to:",null,"Basic             Intermediate             Advanced             Masters        Re-Certification"]
[]
[null,"Applied as:",null,"\"Core\" credit          \"Optional\" credit"]
[]
[]
[]
[]
[]
[]
[null,"Note:",null,"SEE THE AAEM CERTIFICATION PROGRAM RULES FOR SPECIFIC ",null,null,null,null,null,null,"FEMA","\"Optional\" credit"]
[null,null,null,"REQUIREMENTS AND GUIDANCE",null,null,null,null,null,null,"Emergency","No preference"]
[null,null,null,null,null,null,null,null,null,null,"Other (specify)"]
[null,"  To which level should this credit be applied?"]
[]
[]
[null,"Type of disaster:"]
[]
[null,"Date of disaster:"]
[]
[null,"Disaster assignment:"]
[]
[null,"County of assignment:"]
[]
[null,"Was this your home jurisdiction?"]
[]
[null,"What was the type of declaration?"]
[]
[null,"Number of hours worked on this disaster:"]
[]
[null,"Notes:"]
[]
[]
[]
[null,"How should this credit be applied?"]
[]
[]
[]
[null,"Name of contact for verification:"]
[]
[null,"Phone number:",null,null,null,null,"Ext:"]
[]
[null,"Address:"]
[]
[null,"City:",null,null,null,"State:",null,"ZIP:"]
[]
[]
[]
[null,"Verified by:",null,null,null,null,"Type verification:"]
[]
[null,"Credit hours allowed:"]
[]
[null,"Credit applied to:",null,"Basic             Intermediate             Advanced             Masters        Re-Certification"]
[]
[null,"Applied as:",null,"\"Core\" credit          \"Optional\" credit"]
[]
[]
[]
[]
[]
[]
[null,"Note:",null,"SEE THE AAEM CERTIFICATION PROGRAM RULES FOR SPECIFIC "]
[null,null,null,"REQUIREMENTS AND GUIDANCE"]
[]
[null,"  To which level should this credit be applied?"]
[]
[]
[null,"Type of disaster:"]
[]
[null,"Date of disaster:"]
[]
[null,"Disaster assignment:"]
[]
[null,"County of assignment:"]
[]
[null,"Was this your home jurisdiction?"]
[]
[null,"What was the type of declaration?"]
[]
[null,"Number of hours worked on this disaster:"]
[]
[null,"Notes:"]
[]
[]
[]
[null,"How should this credit be applied?"]
[]
[]
[]
[null,"Name of contact for verification:"]
[]
[null,"Phone number:",null,null,null,null,"Ext:"]
[]
[null,"Address:"]
[]
[null,"City:",null,null,null,"State:",null,"ZIP:"]
[]
[]
[]
[null,"Verified by:",null,null,null,null,"Type verification:"]
[null,"Credit hours allowed:"]
[null,"Credit applied to:",null,"Basic             Intermediate             Advanced             Masters        Re-Certification"]
[null,"Applied as:",null,"\"Core\" credit          \"Optional\" credit"]
[]
[]
[]
[]
[]
[]
[null,"Note:",null,"SEE THE AAEM CERTIFICATION PROGRAM RULES FOR SPECIFIC "]
[null,null,null,"REQUIREMENTS AND GUIDANCE"]
[]
[null,"  To which level should this credit be applied?"]
[]
[]
[null,"Type of disaster:"]
[]
[null,"Date of disaster:"]
[]
[null,"Disaster assignment:"]
[]
[null,"County of assignment:"]
[]
[null,"Was this your home jurisdiction?"]
[]
[null,"What was the type of declaration?"]
[]
[null,"Number of hours worked on this disaster:"]
[]
[null,"Notes:"]
[]
[]
[]
[null,"How should this credit be applied?"]
[]
[]
[]
[null,"Name of contact for verification:"]
[]
[null,"Phone number:",null,null,null,null,"Ext:"]
[]
[null,"Address:"]
[]
[null,"City:",null,null,null,"State:",null,"ZIP:"]
[]
[]
[]
[null,"Verified by:",null,null,null,null,"Type verification:"]
[null,"Credit hours allowed:"]
[null,"Credit applied to:",null,"Basic             Intermediate             Advanced             Masters        Re-Certification"]
[null,"Applied as:",null,"\"Core\" credit          \"Optional\" credit"]
[]
[]
[]
[]
[]
[]
[null,"Note:",null,"SEE THE AAEM CERTIFICATION PROGRAM RULES FOR SPECIFIC "]
[null,null,null,"REQUIREMENTS AND GUIDANCE"]
[]
[null,"  To which level should this credit be applied?"]
[]
[]
[null,"Type of disaster:"]
[]
[null,"Date of disaster:"]
[]
[null,"Disaster assignment:"]
[]
[null,"County of assignment:"]
[]
[null,"Was this your home jurisdiction?"]
[]
[null,"What was the type of declaration?"]
[]
[null,"Number of hours worked on this disaster:"]
[]
[null,"Notes:"]
[]
[]
[]
[null,"How should this credit be applied?"]
[]
[]
[]
[null,"Name of contact for verification:"]
[]
[null,"Phone number:",null,null,null,null,"Ext:"]
[]
[null,"Address:"]
[]
[null,"City:",null,null,null,"State:",null,"ZIP:"]
[]
[]
[]
[null,"Verified by:",null,null,null,null,"Type verification:"]
[null,"Credit hours allowed:"]
[null,"Credit applied to:",null,"Basic             Intermediate             Advanced             Masters        Re-Certification"]
[null,"Applied as:",null,"\"Core\" credit          \"Optional\" credit"]

{"sheet":"Recertifications Hours","index":11,"n_rows":123,"n_cols":6,"rows_kept":123,"cut":false,"hidden":false,"merged":[[0,0,0,4],[118,1,122,1]]}
["Recertification Hours - Reference Cert. Rules Page 8                                                                                                                                                                                               (Include New Required Core Courses Here)"]
["Date Completed","Name of Course","Sponsored By","Contact Hours","ReCert Year"]
["2024-04-01","NEMA","FEMA",40,2025,"Example"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do Not Edit These Cells","Total Hours ReCert Year",{"$f":"SUMIF(E4:E118,E119, D4:D118)","v":0},"ReCert Year 1"]
[null,null,"Total Hours ReCert Year",{"$f":"SUMIF(E4:E118,E120, D4:D118)","v":0},"ReCert Year 2"]
[null,null,"Total Hours ReCert Year",{"$f":"SUMIF(E4:E118,E121, D4:D118)","v":0},"ReCert Year 3"]
[null,null,"Total Hours ReCert Year",{"$f":"SUMIF(E4:E118,E122, D4:D118)","v":0},"ReCert Year 4"]
[null,null,"Total Hours ReCert Year",{"$f":"SUMIF(E4:E118,E123, D4:D118)","v":0},"ReCert Year 5"]

{"sheet":"Summary of Hours","index":12,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Summary of Hours"]
[]
["Type","BLEM","ILEM","ALEM"]
["Core",{"$f":"SUM(('\"Core\" Non-IS Courses'!D126)+('Higher Education Credit'!D106)+('Instructional Credit'!E60)+('Conference Credit'!D31)+B6)","v":0},{"$f":"SUM(('Intermediate \"Core\" IS Courses'!E17)+('Intermediate \"Core\" IS Courses'!D53)+('\"Core\" Non-IS Courses'!D127)+('\"Core\" Non-IS Courses'!D125)+('Higher Education Credit'!D108)+('Instructional Credit'!E62)+('Conference Credit'!D32)+B4+C6)","v":0},{"$f":"SUM('Advanced \"Core\" IS Courses'!D16+'Advanced \"Core\" IS Courses'!D52+'\"Core\" Non-IS Courses'!D129+'Higher Education Credit'!D110+'Instructional Credit'!E64+'Conference Credit'!D33+'Summary of Hours'!C4+D6)","v":0}]
["Optional",{"$f":"SUM('\"Optional\" Courses'!D129+'Higher Education Credit'!D107+'Instructional Credit'!E61+B7)","v":0},{"$f":"SUM('\"Optional\" Courses'!D129+'Higher Education Credit'!D109+'Instructional Credit'!E63+C7+B5)","v":0},{"$f":"SUM('\"Optional\" Courses'!D130+'Higher Education Credit'!D111+'Instructional Credit'!E65+D7+C5)","v":0}]
["Disaster Credit Core",null,null,null,"Manually input the Disaster Core Credit Here"]
["Disaster Credit Optional",null,null,null,"Manually input the Disaster Optional Credit Here"]