{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["ProgramComplianceCalculator","Sheet1"],"not_rendered":{"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"ProgramComplianceCalculator","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[2,9,2,10],[3,0,3,7],[3,9,3,10],[5,0,5,1],[5,2,6,2],[5,3,6,8],[5,9,6,10],[5,11,10,11],[6,0,6,1],[7,2,10,2],[7,3,10,3],[7,4,10,4],[7,5,10,5],[7,6,10,6],[7,7,10,7],[7,8,10,8],[7,9,9,10],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[22,0,24,9]]}
[{"$nulls":11},"A.F.F.A.C.T.-12"]
[]
[{"$nulls":8},"County:","Arkansas"]
["PROGRAM COMPLIANCE* CALCULATOR",{"$nulls":7},"Program:","AG-Comm."]
[]
[null,null,"Ethnic Group","Race",{"$nulls":5},"Gender"]
[]
[null,null,"Hispanic/\nLatino\n(of any \nrace)","American \nIndian or \nAlaska Native","Asian","Black or \nAfrican \nAmerican","Hawaiian or Pacific Islander","White","Two or More Races/Other Race","Total Data \nby Gender"]
[]
[]
[{"$nulls":9},"F","M"]
["Potential Audience (%)",{"$nulls":10},{"$f":"SUM(C12:I12)","v":{"v":0,"d":"0.00%"}}]
["AIMS #'s",{"$nulls":10},{"$f":"SUM(D13:I13)","v":0}]
["Contact Numbers Needed To Be in Compliance",null,{"$f":"C12*$L$13*0.8","v":0},0,0,0,0,0,0,0,0]
["Actual Contact %",null,{"$f":"C13/$L$13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Contact % Needed",null,{"$f":"C12*0.8","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
["In Compliance?",null,{"$f":"IF(C15<C16, \"NO\",\"YES\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D15<D16, \"NO\",\"YES\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E15<E16, \"NO\",\"YES\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F15<F16, \"NO\",\"YES\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
["*An Extension program is in parity when the participation of individuals of the underrepresented group reflects the proportionate representation in the population of the potential audience.  A program will be in compliance when its participation has reached 80% of parity.  "]

{"sheet":"Sheet1","index":1,"n_rows":75,"n_cols":1,"rows_kept":75}
["Arkansas"]
["Ashley"]
["Baxter"]
["Benton"]
["Boone"]
["Bradley"]
["Calhoun"]
["Carroll"]
["Chicot"]
["Clark"]
["Clay"]
["Cleburne"]
["Cleveland"]
["Columbia"]
["Conway"]
["Craighead"]
["Crawford"]
["Crittenden"]
["Cross"]
["Dallas"]
["Desha"]
["Drew"]
["Faulkner"]
["Franklin"]
["Fulton"]
["Garland"]
["Grant"]
["Greene"]
["Hempstead"]
["Hot Spring"]
["Howard"]
["Independence"]
["Izard"]
["Jackson"]
["Jefferson"]
["Johnson"]
["Lafayette"]
["Lawrence"]
["Lee"]
["Lincoln"]
["Little River"]
["Logan"]
["Lonoke"]
["Madison"]
["Marion"]
["Miller"]
["Mississippi"]
["Monroe"]
["Montgomery"]
["Nevada"]
["Newton"]
["Ouachita"]
["Perry"]
["Phillips"]
["Pike"]
["Poinsett"]
["Polk"]
["Pope"]
["Prairie"]
["Pulaski"]
["Randolph"]
["St Francis"]
["Saline"]
["Scott"]
["Searcy"]
["Sebastian"]
["Sevier"]
["Sharp"]
["Stone"]
["Union"]
["Van Buren"]
["Washington"]
["White"]
["Woodruff"]
["Yell"]