{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["AFFACT-343","Sheet4","Sheet1"],"not_rendered":{"images":1,"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"AFFACT-343","index":0,"n_rows":75,"n_cols":16,"rows_kept":75,"merged":[[0,14,0,15],[1,14,1,15],[4,13,4,14],[5,1,5,11],[5,13,5,14],[7,0,7,15],[9,2,9,6],[9,7,9,11],[31,0,33,14],[35,1,35,5],[35,8,35,10],[39,0,39,15],[40,0,40,15]]}
[{"$nulls":14},"AFFACT-343"]
[{"$nulls":14},"2020-08-15"]
[]
[]
[{"$nulls":12},"County","Arkansas"]
[{"$nulls":12},"Program Year",2018]
[]
["List of all 4-H and EH Clubs and Certification of All Reasonable Efforts"]
[]
["(1)","(2)","(3) Racial/Ethnic Composition Club/Unit",{"$nulls":4},"(4) Racial/Ethnic Composition of Membership Area",{"$nulls":4},"(5)","(6)","(7)","(8)"]
[" Club or Unit Name                               (List all Clubs in the County)                      ","Type","White","Black","Other","Total # Members","# Minority/ Undreprsnted ","White","Black ","Other","Total","% of Minorities in  Area","# of Contacts Required","Personal Contacts","Direct Mail Contacts","Mass Media Releases"]
[{"$nulls":5},{"$f":"SUM(C12:E12)","v":0},{"$f":"IF(SUM(D12:E12)<C12,D12+E12,C12)","v":0},{"$nulls":3},{"$f":"SUM(H12:J12)","v":0},{"$f":"IF((D12+E12)<C12,(I12+J12)/K12,H12/K12)","v":{"$error":"#DIV/0!"}},{"$f":"IF((F12*L12)*0.75-(G12)>0,(F12*L12)*0.75-(G12),IF((F12*L12)*0.75-(G12)<=0,0,))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM(C13:E13)","v":0},{"$f":"IF(SUM(D13:E13)<C13,D13+E13,C13)","v":0},{"$nulls":3},{"$f":"SUM(H13:J13)","v":0},{"$f":"IF((D13+E13)<C13,(I13+J13)/K13,H13/K13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},{"$f":"SUM(H14:J14)","v":0},{"$f":"IF((D14+E14)<C14,(I14+J14)/K14,H14/K14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$f":"SUM(C15:E15)","v":0},0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$f":"SUM(C24:E24)","v":0},{"$f":"IF(SUM(D24:E24)<C24,D24+E24,C24)","v":0},{"$nulls":3},{"$f":"SUM(H24:J24)","v":0},{"$f":"IF((D24+E24)<C24,(I24+J24)/K24,H24/K24)","v":{"$error":"#DIV/0!"}},{"$f":"IF((F24*L24)*0.75-(G24)>0,(F24*L24)*0.75-(G24),IF((F24*L24)*0.75-(G24)<=0,0,))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$f":"SUM(C29:E29)","v":0},{"$f":"IF(SUM(D29:E29)<C29,D29+E29,C29)","v":0},{"$nulls":3},{"$f":"SUM(H29:J29)","v":0},{"$f":"IF((D29+E29)<C29,(I29+J29)/K29,H29/K29)","v":{"$error":"#DIV/0!"}},{"$f":"IF((F29*L29)*0.75-(G29)>0,(F29*L29)*0.75-(G29),IF((F29*L29)*0.75-(G29)<=0,0,))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},0,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["The above list of is an accurate summary of the clubs and members of each club in the county.  I hereby certify that if \"all reasonable efforts\" were needed to achieve balanced membership in any club, such efforts have been made and are documented in the county's civl rights files. "]
[]
[]
[]
["County Staff Chair:",{"$nulls":6},"Date:"]
[]
[]
[]
["INSTRUCTIONS (Certification of All Reasonable Efforts)  "]
["Submit the AFFACT-343 with one copy of attachements to the District Director.  "]
[]
["1.     Name of Club or Unit.  List EH clubs and 4-H clubs located in interracial membership areas only."]
[]
["2.     Select from drop down list if club is EH or 4-H."]
[]
["3.     Racial-Ethnic Composition:         Enter number of current members in the club by race-ethnicity.  "]
[null,"\"Other\" includes American Indian/Alaskan Native, Native Hawaiian/Other Pacific Islander, Two or More Races, Hispanic"]
[]
["4.     Racial-Ethnic Compositon of Membership Area:  Enter number of individuals in the membership area."]
[null,"4-H- Number of youth, ages 5-19, by race/ethnicity, (if county wide membership, use 4-H potential audience numbers)"]
[null,"EH- Number of individuals, by race/ethnicity, (if county wide membership, use FCS potential audience numbers)"]
[null,"\"Other\" includes American Indian/Alaskan Native, Native Hawaiian/Other Pacific Islander, Two or More Races, Hispanic"]
[]
["5.     Number of Contacts Required: (Sheet automatically calculates this number)"]
[null,"The number of contact required is determined by the minority or underrepresented population in the membership area"]
[]
[null,"Contact the number necessary to achieve a balanced membership.  A balanced membership is when the number of members"]
[null,"of the underrepresented race reaches 75% of the number of underrepresented members of the club would have if its racial"]
[null,"composition were exactly proportional to that of the membership area."]
[]
[null,"NOTE:"]
[null,"If the tenth place of the number is less than .5, then round down to the next whole number, i.e, if 1.3 then contact 1 person."]
[null,"If the tenth place of the number is greater than .5, then round up to the next whole number, i.e., If 1.6 then contact 2 people."]
[]
["6.   Personal Contacts:                       Enter the number of personal contacts actually made with persons of the racial/ethnic grop not sufficiently represented in the club/unit."]
[null,"Attach one copy of Form AFFACT-504, Interview Record for each individual contacted."]
[]
["7.     Direct Mail Contacts:                 Enter the number of different individuals receiving one or more personal or circular letters inviting them to join a club/unit."]
[null,"Attach one copy of each letter and a list of those who received the letter identified by race/ethnicity."]
[null,"(Letters mut include the club/unite by name and contain the nondiscrimination statement.)"]
[]
["8.     Mass Media Releases:               Enter number of releases through newspapers, radio, television, and other mass media outlets.  Submit clippings from "]
[null,"newspapers and copies of radio/television scripts or other documentation.  (Releases must refer to clubs/units by"]
[null,"name and contain the nondiscrimination statement.)  Describe any use made of posters, displays, exhibits, etc."]

{"sheet":"Sheet4","index":1,"n_rows":75,"n_cols":1,"rows_kept":75,"hidden":true}
["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"]
["Quachita"]
["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"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}