{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Pop Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Calculator","index":0,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[12,0,12,14],[28,0,28,11],[13,0,13,14],[14,0,14,14],[15,0,15,14],[16,0,16,14],[17,0,17,14],[20,2,20,5],[20,6,20,8],[20,9,20,16],[19,0,19,16],[0,0,1,1],[0,2,1,16],[1,17,1,33],[18,0,18,14],[27,0,27,11],[27,12,27,23],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[6,0,6,14],[7,0,7,14],[8,0,8,14],[9,0,9,14],[10,0,10,14],[11,0,11,14]]}
[{"$error":"#VALUE!"},null,"UC Master Gardener Program Volunteer Parity Calculator Instructions"]
[]
["Description: Use this tool to determine in which race ethnicity and gender (REG) categories your local UC Master Gardener Program does or does not meet parity. \n"]
["Your County Data: You will need a copy of your program’s UC Master Gardener Program Volunteer Demographics Report, 2025."]
["Missing your report? Contact Statewide Evaluation Specialist, Jocelyn Mobley at jmmobley@ucanr.edu. "]
["Need assistance with this calculator? Contact Assistant Director for Volunteer and Community Engagement, Marisa Coyne at macoyne@ucanr.edu"]
[]
["Instructions: "]
["• In cell 22B, double click to show arrow. Click the downward arrow to drop a drop down of counties. Select your county. This will autopopulate the population % for each category. "]
["• In cells 25C - 25Q, enter your counties %. Hit enter."]
["• In row 26, 100% = double your current count to hit parity, 50% = increase numbers by half to hit parity, 200% = 3x to hit parity"]
[]
["Notes, Caveats, and Considerations:"]
["• ND = No Data. OMB's Statistical Policy added new categories in 2024. UC ANR's California baselines were last updated in 2023, and are scheduled for updating in 2026. ND represents no current data avaliable in the recently added categories. "]
["• Baseline data is collected mutually exclusively (participants can select 1 race option)"]
[]
["Data Sources:"]
["• UC Master Gardener Program Volunteer Demographic Survey Report"]
["• UC ANR Office of Civil Rights California Baselines 2023"]
["UC Master Gardener Program Volunteer Parity Calculator Tool"]
[null,"Click the drop down to choose your county","Gender",null,null,null,"Ethnicity",null,null,"Race"]
["COUNTY","Humboldt","Female","Male","Non-Binary","Other","Hispanic","Not Hispanic","Prefer not to state Ethnicity","American Indian or Alaskan Native","Asian","Black or African American","Middle Eastern or North African","Native Hawaiian or Pacific Islander","White","More than 1 race","Unknown"]
["# of respondants "]
["County Level","Population %",{"$f":"IFERROR(\n  INDEX('Pop Data'!$B$2:$Q$51, MATCH($B$22, 'Pop Data'!$A$2:$A$51, 0), ),\n  \"\"\n)","v":0.50674126560303423},0.49325873439696571,"ND","ND",0.13600467973091548,0.86399532026908454,"ND",6.1996999688646935E-2,2.7002802177584467E-2,1.4001452980969723E-2,"ND",3.0003113530649409E-3,0.71899914142033605,0.11800281161252583,5.6996480766872033E-2,0]
["Program Level","Program %"]
[null,"Achieves Parity?",{"$f":"IF(OR(C24=\"\",C25=\"\"),\"\",IF(C25>=0.8*C24,\"Yes\",\"No\"))","v":""},{"$f":"IF(OR(D24=\"\",D25=\"\"),\"\",IF(D25>=0.8*D24,\"Yes\",\"No\"))","v":""},null,{"$f":"IF(IFERROR(ERROR.TYPE(IF(OR(F24=\"\",F25=\"\"),\"\",IF(F25>=0.8*F24,\"Yes\",\"No\"))),0)=3,\"Uncalculable\",IF(OR(F24=\"\",F25=\"\"),\"\",IF(F25>=0.8*F24,\"Yes\",\"No\")))","v":""},"","","","","","",null,"","","",""]
[null,"% Increase Needed to Hit Parity",{"$f":"IF(C25>=0.8*C24,\"Meets Parity\",((0.8*C24)-C25)/C25)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D25>=0.8*D24,\"Meets Parity\",((0.8*D24)-D25)/D25)","v":{"$error":"#DIV/0!"}},{"$f":"IF(IFERROR(ERROR.TYPE(IF(E25>=0.8*E24,\"Meets Parity\",((0.8*E24)-E25)/E25)),0)=3,\"Uncalculable\",IF(E25>=0.8*E24,\"Meets Parity\",((0.8*E24)-E25)/E25))","v":"Uncalculable"},{"$f":"IF(IFERROR(ERROR.TYPE(IF(F25>=0.8*F24,\"Meets Parity\",((0.8*F24)-F25)/F25)),0)=3,\"Uncalculable\",IF(F25>=0.8*F24,\"Meets Parity\",((0.8*F24)-F25)/F25))","v":"Uncalculable"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(IFERROR(ERROR.TYPE(IF(I25>=0.8*I24,\"Meets Parity\",((0.8*I24)-I25)/I25)),0)=3,\"Uncalculable\",IF(I25>=0.8*I24,\"Meets Parity\",((0.8*I24)-I25)/I25))","v":"Uncalculable"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(IFERROR(ERROR.TYPE(IF(M25>=0.8*M24,\"Meets Parity\",((0.8*M24)-M25)/M25)),0)=3,\"Uncalculable\",IF(M25>=0.8*M24,\"Meets Parity\",((0.8*M24)-M25)/M25))","v":"Uncalculable"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Adapted from University of Florida IFAS Extension x Program Development and Evaluation Center. (Sept. 2024), Parity Calculator. https://pdec.ifas.ufl.edu/workload/ParityCalculator.xlsx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated Aug. 19, 2025, JM, MC"]

{"sheet":"Pop Data","index":1,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Counties","Female","Male","Nion-Binary","Other","Hispanic","Not Hispanic","Prefer Not to State Ethnicity","Am Indian/ Alaskan Native","Asian ","Black ","Middle Eastern or North African","Native Hawaiian or Pacific Islander","White","More than 1","Unknown"]
["Alameda",0.51608249749906843,0.48391750250093157,"ND","ND",0.2339998361058756,0.7660001638941244,"ND",1.1999833013533634E-2,0.32400012987836274,9.800018244817621E-2,"ND",7.9998886756890899E-3,0.31200029686482911,0.11300036025783948,0.1330000819470622]
["Amador",0.45059383133395159,0.54940616866604841,"ND","ND",0.14901127830795466,0.85098872169204531,"ND",1.8996619499207227E-2,1.4000658150596822E-2,3.0992909923116044E-2,"ND",2.0043677266880066E-3,0.76800191461991807,9.6000239327489759E-2,7.0003290752984115E-2]
["Butte",0.5087714938872876,0.49122850611271246,"ND","ND",0.18999726667329292,0.81000273332670714,"ND",2.0996918795348374E-2,5.0001242421230496E-2,1.7002534539310207E-2,"ND",3.0004472716429779E-3,0.70699980121260309,0.11699880727561873,8.5000248484246102E-2]
["Calaveras",0.50165757965971669,0.49834242034028331,"ND","ND",0.12898983533795447,0.87101016466204551,"ND",1.6000438368174469E-2,1.6000438368174469E-2,8.0002191840872344E-3,"ND",2.9863831885805089E-3,0.80199457519384088,0.11098934217375818,4.4001205512479796E-2]
["Colusa",0.5034418850939899,0.49655811490601004,"ND","ND",0.61702409319565787,0.38297590680434207,"ND",2.2967963992586708E-2,1.2973259200423616E-2,9.0018533227429181E-3,"ND",3.9714058776806989E-3,0.42897802488747683,0.19499602859412232,0.32697908392904423]
["Contra Costa",0.52083936771509398,0.47916063228490602,"ND","ND",0.26999989696233517,0.73000010303766483,"ND",1.0000377804771102E-2,0.18699962334009185,8.7000424744151747E-2,"ND",4.9996164709141845E-3,0.43000021752395912,0.13200040757120762,0.14900047740784711]
["Del Norte",0.44602813501091043,0.55397186498908957,"ND","ND",0.19197734342355727,0.80802265657644268,"ND",8.7979943358558896E-2,2.999210734017364E-2,3.1013510376526301E-2,"ND",1.0214030363526626E-3,0.61999164306606624,0.1240076140953619,0.10599377872696039]
["El Dorado",0.50913033785290129,0.49086966214709876,"ND","ND",0.13799882450700229,0.86200117549299771,"ND",9.998446187416821E-3,4.7999297406484127E-2,7.9987569499334558E-3,"ND",1.9996892374833639E-3,0.76700242529877116,0.11500239827594361,4.9998986643967493E-2]
["Fresno",0.50869415616215008,0.49130584383784998,"ND","ND",0.53599947459570285,0.4640005254042972,"ND",2.1999877215300116E-2,0.11199963450135848,4.8000251280316042E-2,"ND",2.0002484248579054E-3,0.37200051969338088,0.16200013420653242,0.28199933467825411]
["Glenn",0.50513921729479327,0.49486078270520678,"ND","ND",0.43401051971239685,0.5659894802876031,"ND",3.7977126863871058E-2,2.2004536022776626E-2,5.9836896202287316E-3,"ND",1.978478019591758E-3,0.54499831105534913,0.13598417217584327,0.25097717511943252]
["Humboldt",0.50674126560303423,0.49325873439696571,"ND","ND",0.13600467973091548,0.86399532026908454,"ND",6.1996999688646935E-2,2.7002802177584467E-2,1.4001452980969723E-2,"ND",3.0003113530649409E-3,0.71899914142033605,0.11800281161252583,5.6996480766872033E-2]
["Imperial",0.50154423119347014,0.49845576880652986,"ND","ND",0.85199804607481644,0.14800195392518359,"ND",2.3998613343418108E-2,1.7002300589329049E-2,2.3998613343418108E-2,"ND",1.0005987835239986E-3,0.26500110302228103,0.27700040969399009,0.39199836122403958]
["Inyo",0.49492095526404306,0.50507904473595699,"ND","ND",0.231012445341406,0.76898755465859403,"ND",0.12996972754793137,1.5001681802892701E-2,4.9781365623948869E-3,"ND",1.0090817356205853E-3,0.61802892700975443,0.11200807265388496,0.11900437268752102]
["Kern",0.49575203599931533,0.50424796400068461,"ND","ND",0.54900075665109105,0.45099924334890895,"ND",1.9999264144816301E-2,5.0999563285945328E-2,5.500037592601776E-2,"ND",1.9996064774452389E-3,0.40899950889664916,0.16100031513798085,0.30199976644596344]
["Kings",0.44506147617101893,0.55493852382898112,"ND","ND",0.56800453177816579,0.43199546822183427,"ND",2.3996136844842315E-2,3.8000074291445342E-2,5.8996694030682369E-2,"ND",2.9995171056052894E-3,0.40200029716578134,0.15900226588908287,0.31499572824189292]
["Lake",0.49563881830937845,0.50436118169062161,"ND","ND",0.22700898782661458,0.77299101217338539,"ND",3.3998255527323752E-2,1.499867268383329E-2,1.7994614888695058E-2,"ND",1.990974250066366E-3,0.68699988623004282,0.13100610565436688,0.11299252910614738]
["Los Angeles",0.51639088103033004,0.48360911896967002,"ND","ND",0.47999999480009486,0.52000000519990519,"ND",1.5999978160398356E-2,0.14999997400047424,7.8999949040929496E-2,"ND",2.0000135197533997E-3,0.32599999376011379,0.14900003223941197,0.27800005927891874]
["Madera",0.50606971209071949,0.49393028790928056,"ND","ND",0.59599886049311246,0.4040011395068876,"ND",4.8998796166110699E-2,2.4995634953454818E-2,2.900228820334684E-2,"ND",1.0016633124730057E-3,0.41799685716648749,0.16200295904207904,0.31600180115604809]
["Marin",0.51649824048216186,0.48350175951783814,"ND","ND",0.18800092270391511,0.81199907729608489,"ND",1.499884662010611E-2,6.2999082204084442E-2,2.4000117791989163E-2,"ND",1.9975558162248649E-3,0.68399844907214269,0.11300178160383609,9.8999258892068176E-2]
["Mariposa",0.50003595828838543,0.49996404171161452,"ND","ND",0.12499101042790363,0.87500898957209639,"ND",2.8982380438691117E-2,1.6972312117943186E-2,5.9690758719884935E-3,"ND",2.0136641495864796E-3,0.78101402373247031,0.11902193455591514,4.6026609133405248E-2]
["Mendocino",0.50267606230494399,0.49732393769505601,"ND","ND",0.26099727451174221,0.73900272548825785,"ND",5.0004942595286178E-2,1.9996328357787412E-2,7.0043636055526527E-3,"ND",2.0052815161057998E-3,0.6499936452346321,0.13199553754254162,0.13899990114809427]
["Merced",0.50622240276011965,0.49377759723988035,"ND","ND",0.61799880774648264,0.38200119225351742,"ND",2.6999794257136375E-2,7.3998849950146925E-2,3.2997990050486134E-2,"ND",3.0017356256957011E-3,0.36999952520877627,0.17599983118534268,0.31700227372241596]
["Mono",0.46026811734991258,0.53973188265008742,"ND","ND",0.26598018263065865,0.73401981736934141,"ND",2.1954536623275695E-2,1.2045851952593743E-2,6.0229259762968716E-3,"ND",2.0400233145521662E-3,0.7089566737905576,0.11997279968913931,0.12900718865358463]
["Monterey",0.49901975137330284,0.5009802486266971,"ND","ND",0.60399865056682556,0.39600134943317439,"ND",2.9000082748260696E-2,6.1001381259428528E-2,2.3000833847857775E-2,"ND",4.9999045212376593E-3,0.36200136216367607,0.17900040101080184,0.34099921707414882]
["Napa",0.51481571380559399,0.48518428619440607,"ND","ND",0.35399940251689754,0.64600059748310246,"ND",1.4003510213226782E-2,7.7000634825796332E-2,1.7999178460734157E-2,"ND",2.9967511856305315E-3,0.55199970125844877,0.14999626573060981,0.18600395832555361]
["Nevada",0.51261827742037103,0.48738172257962903,"ND","ND",0.10200026654066563,0.89799973345933437,"ND",9.9952749609275617E-3,1.400550043009971E-2,3.9981099843710245E-3,"ND",1.0055852384933182E-3,0.83800385272416678,9.8995626309986789E-2,3.3996050351954833E-2]
["Orange",0.51600181661494471,0.48399818338505524,"ND","ND",0.34099987112409841,0.65900012887590154,"ND",1.1999869888866151E-2,0.22200006340859055,1.7000090171956687E-2,"ND",2.9999674722165377E-3,0.43400009799509448,0.1399999917651181,0.1719999192981575]
["Placer",0.52211039549325466,0.47788960450674528,"ND","ND",0.1500008236011135,0.84999917639888645,"ND",9.0003129684231332E-3,8.8000131776178159E-2,1.699912698281968E-2,"ND",3.0012024576257226E-3,0.71199986822382189,0.12100018119224497,4.9999176398886493E-2]
["Riverside",0.50978304128193896,0.49021695871806104,"ND","ND",0.49699973791601548,0.50300026208398452,"ND",1.7999859536688045E-2,7.1000207269033486E-2,6.5000254090137474E-2,"ND",2.9999765894480079E-3,0.41100021868881498,0.16799983098723439,0.2640002238277166]
["Sacramento",0.51926073803970296,0.48073926196029698,"ND","ND",0.23600006111286528,0.76399993888713469,"ND",1.2000190128914194E-2,0.17799970801631035,9.5999823451722532E-2,"ND",1.2000190128914194E-2,0.45100021389502848,0.13400014259668563,0.11699973178242462]
["San Bernardino",0.51196127936988278,0.48803872063011722,"ND","ND",0.537000288054305,0.46299971194569506,"ND",1.9000087502083762E-2,8.4000084308577055E-2,8.500029060911031E-2,"ND",2.9999802002584185E-3,0.35799976623530905,0.1659997560160876,0.28500003512857375]
["San Diego",0.50728180516436872,0.49271819483563128,"ND","ND",0.3390000727286312,0.6609999272713688,"ND",1.1999826723042617E-2,0.12499985096591969,4.7000182417714309E-2,"ND",4.9999940386367871E-3,0.49499980724925613,0.15799997059060816,0.15799997059060816]
["San Francisco",0.48881360103471017,0.51118639896528983,"ND","ND",0.15599967364364828,0.84400032635635169,"ND",7.0006112493964413E-3,0.33899998528721365,5.2999469002165456E-2,"ND",4.000540360516767E-3,0.41400041998317394,9.8999664280966071E-2,8.4000647362599296E-2]
["San Joaquin",0.50807921008128309,0.49192078991871691,"ND","ND",0.41800047278744568,0.58199952721255432,"ND",1.600021820959031E-2,0.17899914534577127,7.7000709181168511E-2,"ND",7.000891022493772E-3,0.3430000181841325,0.1450002727619879,0.23300056370810832]
["San Luis Obispo",0.50546114059246328,0.49453885940753678,"ND","ND",0.23999910436398647,0.76000089563601347,"ND",1.0998410246075995E-2,3.699872371868073E-2,1.6000537381608115E-2,"ND",9.9863415507937575E-4,0.70299814155527196,0.13499921631848816,9.7001858444728056E-2]
["San Mateo",0.51208166864690019,0.48791833135309975,"ND","ND",0.25000084145902263,0.75000084145902268,"ND",9.000245706034608E-3,0.30099998990249172,2.0999451368717247E-2,"ND",1.1999205662682639E-2,0.39300007068255788,0.1229994311737007,0.1409999225857699]
["Santa Barbara",0.50840533038535951,0.49159466961464054,"ND","ND",0.46999855805625984,0.53000144194374021,"ND",2.100130976556398E-2,5.8999531368284445E-2,1.5999567416877952E-2,"ND",2.0006969394744116E-3,0.50200069693947447,0.17799894257459054,0.22199925499573425]
["Santa Clara",0.49969671760056728,0.50030328239943267,"ND","ND",0.25199967344008606,0.748000326559914,"ND",1.0999806358067549E-2,0.39200009176063699,2.3000208485564905E-2,"ND",3.9996842354550954E-3,0.32200021995564454,0.10800024559464604,0.13999974360998491]
["Santa Cruz",0.50714067365927284,0.49285932634072716,"ND","ND",0.34800156664947174,0.65199843335052832,"ND",1.3001280067251294E-2,4.6001222750807209E-2,1.1998242295714641E-2,"ND",9.9826140119600314E-4,0.59300070690281037,0.14299975162874229,0.19200053495347816]
["Shasta",0.51541884948078287,0.48458115051921713,"ND","ND",0.1080000286662319,0.89199997133376807,"ND",2.699642388757104E-2,3.3001999469674713E-2,1.1000666489891569E-2,"ND",1.9994696747099336E-3,0.78399994266753625,0.10699671054988999,3.5997620702752677E-2]
["Solano",0.50969900055023598,0.49030099944976402,"ND","ND",0.28299887332636564,0.71700112667363436,"ND",1.200038429178227E-2,0.15999930128766859,0.13700002037910966,"ND",8.998832568146287E-3,0.38800078022877005,0.14700034062226155,0.14700034062226155]
["Sonoma",0.51898017887737935,0.48101982112262059,"ND","ND",0.28899909356219577,0.71100090643780423,"ND",1.800038772484111E-2,4.7001157934998455E-2,1.5998889220725464E-2,"ND",4.000377245791352E-3,0.62700084356350572,0.13499897829264842,0.15299936601748954]
["Stanislaus",0.51478692395769843,0.48521307604230152,"ND","ND",0.48100026266330392,0.51899973733669613,"ND",1.9001012401278126E-2,6.3000940997661528E-2,2.900006885348743E-2,"ND",7.9997551876002521E-3,0.46400110165579889,0.1530000994550374,0.26399957157830045]
["Sutter",0.5095161851722938,0.49048381482770625,"ND","ND",0.31700661329620605,0.68299338670379395,"ND",1.9004524886877826E-2,0.18300034806822138,2.0006961364427429E-2,"ND",2.9933867037939435E-3,0.46998955795335884,0.12499825965889315,0.18000696136442743]
["Trinity",0.43309778892181444,0.5669022110781855,"ND","ND",5.797431806093762E-2,0.94202568193906233,"ND",2.6973634222323531E-2,0.13798343590912546,4.0270496162905555E-3,"ND",1.9755337740293291E-3,0.72198161233948788,8.4036167464478381E-2,2.3022566674264874E-2]
["Tulare",0.50983102092709198,0.49016897907290802,"ND","ND",0.65499868751047619,0.34500131248952381,"ND",2.1999221994161794E-2,3.6000164456518643E-2,1.4000942462356851E-2,"ND",1.9987792266115949E-3,0.39399986716973495,0.18299899112251061,0.34899887094274701]
["Tuolumne",0.48141432456935629,0.51858567543064371,"ND","ND",0.12801008336465958,0.87198991663534042,"ND",1.7999690423014837E-2,1.4992371138579926E-2,1.7999690423014837E-2,"ND",1.9901377617583971E-3,0.79501581053888504,0.10200561661101652,4.9996683103730399E-2]
["Ventura",0.51482819948256087,0.48517180051743908,"ND","ND",0.43299985152846704,0.56700014847153291,"ND",1.6999990523093641E-2,7.6999864164342194E-2,1.7999804143935254E-2,"ND",1.999627241683225E-3,0.50800166793551915,0.17199953247261965,0.20599951351880691]
["Yolo",0.52225359856057574,0.47774640143942421,"ND","ND",0.33099885045981609,0.66900114954018397,"ND",1.599985005997601E-2,0.14000024990003998,2.8001299480207915E-2,"ND",4.9980007996801284E-3,0.4960015993602559,0.15799930027988804,0.15699970011995201]
["Yuba",0.50222268709795514,0.49777731290204486,"ND","ND",0.28800794937503271,0.71199205062496729,"ND",2.2000244059759776E-2,7.1003957254676356E-2,3.6992486445966914E-2,"ND",5.0032250753970333E-3,0.57101267367466835,0.14399525826752435,0.14999215522200721]