{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA DPAC JAN 2023 CAA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"ADA DPAC JAN 2023 CAA","index":0,"n_rows":124,"n_cols":10,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["DEPARTMENT OF TRANSPORTATION - CALTRANS"]
["DBE Commitment at Award (CAA) on Federally Funded Architectural & Engineering and Minor B Contracts - October 1, 2022 - January 31, 2023"]
[]
["Total Award Amount Year-to-Date (YTD)",null,"Total DBE Commitment Amount YTD",null,null,"Total Prime Contracts Awarded YTD"]
[139162452,null,{"$f":"SUM(C7:C18)","v":31336260.270000003},null,null,{"$f":"SUM(C109:C121,J109:J117,F109:F121)","v":15}]
["Groups",null," Commitment Dollars YTD","Firms YTD","Contracts YTD","% of Contracts","% of DBE $","% of Total $"]
["Hispanic American Male",null,{"$f":"SUMIF(D26:D39,\"m\", C26:C39)","v":4203688.72},{"$f":"COUNTIF(D26:D39,\"M\")","v":10},{"$f":"SUMIF(D26:D39,\"M\",E26:E39)","v":13},{"$f":"E7/E20","v":0.17808219178082191},{"$f":"C7/C5","v":0.13414774717149103},{"$f":"C7/A5","v":3.0207061312774224E-2}]
["Hispanic American Female",null,{"$f":"SUMIF(D26:D39,\"F\", C26:C39)","v":988854.5},{"$f":"COUNTIF(D26:D39,\"F\")","v":3},{"$f":"SUMIF(D26:D39,\"F\",E26:E39)","v":3},{"$f":"E8/E20","v":4.1095890410958902E-2},{"$f":"C8/C5","v":3.1556238411342502E-2},{"$f":"C8/A5","v":7.1057565154140859E-3}]
["African American Male",null,{"$f":"SUMIF(D47:D49,\"m\", C47:C49)","v":964040.25},{"$f":"COUNTIF(D47:D49,\"M\")","v":3},{"$f":"SUMIF(D47:D49,\"M\",E47:E49)","v":4},{"$f":"E9/E20","v":5.4794520547945202E-2},{"$f":"C9/C5","v":3.0764368233274185E-2},{"$f":"C9/A5","v":6.9274451272244037E-3}]
["African American Female",null,{"$f":"SUMIF(D47:D49,\"F\", C47:C49)","v":0},{"$f":"COUNTIF(D47:D49,\"F\")","v":0},{"$f":"SUMIF(D47:D49,\"F\",E47:E49)","v":0},{"$f":"E10/E20","v":0},{"$f":"C10/C5","v":0},{"$f":"C10/A5","v":0}]
["Asian Pacific Male",null,{"$f":"SUMIF(D59:D74,\"m\", C59:C74)","v":7441007.6100000013},{"$f":"COUNTIF(D59:D74,\"M\")","v":10},{"$f":"SUMIF(D59:D74,\"M\",E59:E74)","v":14},{"$f":"E11/E20","v":0.19178082191780821},{"$f":"C11/C5","v":0.23745678475627496},{"$f":"C11/A5","v":5.3469937494346545E-2}]
["Asian Pacific Female",null,{"$f":"SUMIF(D59:D74,\"F\", C59:C74)","v":1972781.44},{"$f":"COUNTIF(D59:D74,\"F\")","v":4},{"$f":"SUMIF(D59:D74,\"F\",E59:E74)","v":7},{"$f":"E12/E20","v":9.5890410958904104E-2},{"$f":"C12/C5","v":6.2955228958468168E-2},{"$f":"C12/A5","v":1.4176104341708495E-2}]
["Subcontinent Asian Male",null,{"$f":"SUMIF(D52:D56,\"m\", C52:C56)","v":7295185},{"$f":"COUNTIF(D52:D56,\"M\")","v":2},{"$f":"SUMIF(D52:D56,\"M\",E52:E56)","v":2},{"$f":"E13/E20","v":2.7397260273972601E-2},{"$f":"C13/C5","v":0.23280330636595134},{"$f":"C13/A5","v":5.2422078622184669E-2}]
["Subcontinent Asian Female",null,{"$f":"SUMIF(D52:D56,\"F\", C52:C56)","v":873600},{"$f":"COUNTIF(D52:D56,\"F\")","v":2},{"$f":"SUMIF(D52:D56,\"F\",E52:E56)","v":2},{"$f":"E14/E20","v":2.7397260273972601E-2},{"$f":"C14/C5","v":2.7878246876713215E-2},{"$f":"C14/A5","v":6.2775553854138759E-3}]
["Native American Male",null,{"$f":"SUMIF(D42:D44,\"m\", C42:C44)","v":0},{"$f":"COUNTIF(D42:D44,\"M\")","v":0},{"$f":"SUMIF(D42:D44,\"M\",E42:E44)","v":0},{"$f":"E15/E20","v":0},{"$f":"C15/C5","v":0},{"$f":"C15/A5","v":0}]
["Native American Female",null,{"$f":"SUMIF(D42:D44,\"F\", C42:C44)","v":0},{"$f":"COUNTIF(D42:D44,\"F\")","v":0},{"$f":"SUMIF(D42:D44,\"F\",E42:E44)","v":0},{"$f":"E16/E20","v":0},{"$f":"C16/C5","v":0},{"$f":"C16/A5","v":0}]
["Non Minority Women",null,{"$f":"SUMIF(D81:D104,\"F\", C81:C104)","v":7597102.75},{"$f":"COUNTIF(D81:D104,\"F\")","v":23},{"$f":"SUMIF(D81:D104,\"F\",E81:E104)","v":28},{"$f":"E17/E20","v":0.38356164383561642},{"$f":"C17/C5","v":0.24243807922648453},{"$f":"C17/A5","v":5.4591613188879423E-2}]
["Non Minority Men",null,{"$f":"SUMIF(D77:D78,\"M\", C77:C78)","v":0},{"$f":"COUNTIF(D77:D78,\"M\")","v":0},{"$f":"SUMIF(D77:D78,\"M\",E77:E78)","v":0},{"$f":"E18/E20","v":0},{"$f":"C18/C5","v":0},{"$f":"C18/A5","v":0}]
[]
["Total  ",null,{"$f":"SUM(C7:C18)","v":31336260.270000003},{"$f":"SUM(D7:D19)","v":57},{"$f":"SUM(E7:E19)","v":73}]
["Total Prime Contracts Awarded",null,{"$f":"SUM(C109:C121,F109:F121,J109:J117)","v":15}]
["Red Italic = DBE firm as Prime"]
["BOLD = women"]
[]
["Hispanic American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ACT CONSULTING ENGINEERS",null,94040.25,"M",1,{"$f":"fetchcomment(E26)","v":"08A3485"},1,{"$f":"fetchcomment(G26)","v":"ICF JONES & STOKES"},8]
["ADVANCED TECHNOLOGY",null,150000,"M",1,{"$f":"fetchcomment(E27)","v":"07A5331"},1,{"$f":"fetchcomment(G27)","v":"Geosyntec Consultants, Inc."},7]
["ALFRED MARTINEZ ENGINEERING",null,146000,"M",1,{"$f":"fetchcomment(E28)","v":"59A1208"},1,{"$f":"fetchcomment(G28)","v":"HDR Construction Control Corporation"},59]
["ARELLANO ASSOCIATES LLC",null,438854.5,"F",1,{"$f":"fetchcomment(E29)","v":"08A3485"},1,{"$f":"fetchcomment(G29)","v":"ICF JONES & STOKES"},8]
["BARGAS ENVIRONMENT",null,350000,"F",1,{"$f":"fetchcomment(E30)","v":"03A3447"},1,{"$f":"fetchcomment(G30)","v":"ICF Jones & Stokes"},3]
["B & R CONSULTING ENGINEERS",null,843600,"M",1,{"$f":"fetchcomment(E31)","v":"59A1206"},1,{"$f":"fetchcomment(G31)","v":"FALCON ENGINEERING SERVICES INC"},59]
["DUKE CULTURAL RESOURCES",null,31346.75,"M",1,{"$f":"fetchcomment(E32)","v":"08A3485"},1,{"$f":"fetchcomment(G32)","v":"ICF JONES & STOKES"},8]
["FOUNTAINHEAD COUSULTING CORP.",null,715000,"M",1,{"$f":"fetchcomment(E33)","v":"59A1195"},1,{"$f":"fetchcomment(G33)","v":"MNS Engineers, Inc."},59]
["MARTINI DRILLING CORP",null,60000,"M",1,{"$f":"fetchcomment(E34)","v":"07A5331"},1,{"$f":"fetchcomment(G34)","v":"Geosyntec Consultants, Inc."},7]
["SIX RIVERS GEOSCIENCES",null,200000,"F",1,{"$f":"fetchcomment(E35)","v":"04A6470"},1,{"$f":"fetchcomment(G35)","v":"HDR Construction Control Corporation"},4]
["SJ CONSTRUCTION MANAGEMENT",null,1197701.98,"M",2,{"$f":"fetchcomment(E36)","v":"06A2824\n59A1208"},1,{"$f":"fetchcomment(G36)","v":"Ghiradelli & Associates, Inc.\nHDR Construction Control Corporation"},"6, 59"]
["UNIFIED TRAFFIC SYSTEMS.",null,60000,"M",1,{"$f":"fetchcomment(E37)","v":"07A5331"},1,{"$f":"fetchcomment(G37)","v":"Geosyntec Consultants, Inc."},7]
["UNICO ENGINEERING CONSULTING",null,905999.74,"M",3,{"$f":"fetchcomment(E38)","v":"06A2767\n06A2779\n59A1208"},2,{"$f":"fetchcomment(G38)","v":"Geocon Consultants, Inc.\nHDR Construction Control Corporation"},"6, 59"]
[null,null,null,null,null,{"$f":"fetchcomment(E39)","v":""},null,{"$f":"fetchcomment(G39)","v":""}]
[]
["Native American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
[null,null,null,null,null,{"$f":"fetchcomment(E42)","v":""},null,{"$f":"fetchcomment(G42)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E43)","v":""},null,{"$f":"fetchcomment(G43)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E44)","v":""},null,{"$f":"fetchcomment(G44)","v":""}]
[]
["African American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ACTIVEWAYZ ENGINEERING, INC.",null,210000,"M",1,{"$f":"fetchcomment(E47)","v":"04A6470"},1,{"$f":"fetchcomment(G47)","v":"HDR Construction Control Corporation"},4]
["BIOMAAS",null,510000,"M",1,{"$f":"fetchcomment(E48)","v":"04A6493"},1,{"$f":"fetchcomment(G48)","v":"AECOM Technical Services"},4]
["ENVIRONMENTAL REVIEW PARTNERS",null,244040.25,"M",2,{"$f":"fetchcomment(E49)","v":"03A3447\n08A3485"},1,{"$f":"fetchcomment(G49)","v":"ICF JONES & STOKES"},"3, 8"]
[]
["Sub Cont Asian",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["CHAUDHARY & ASSOCIATES",null,6732785,"M",1,{"$f":"fetchcomment(E52)","v":"06A2812"},1,{"$f":"fetchcomment(G52)","v":"CHAUDHARY & ASSOCIATES"},6]
["KZAB ENGINEERS INC",null,562400,"M",1,{"$f":"fetchcomment(E53)","v":"59A1206"},1,{"$f":"fetchcomment(G53)","v":"FALCON ENGINEERING SERVICES INC"},59]
["POLYTECHNIQUE ENVIRONMENTAL",null,30000,"F",1,{"$f":"fetchcomment(E54)","v":"07A5331"},1,{"$f":"fetchcomment(G54)","v":"Geosyntec Consultants, Inc."},7]
["SKYLINE CONSULTANTS",null,843600,"F",1,{"$f":"fetchcomment(E55)","v":"59A1206"},1,{"$f":"fetchcomment(G55)","v":"FALCON ENGINEERING SERVICES INC"},59]
[null,null,null,null,null,{"$f":"fetchcomment(E56)","v":""},null,{"$f":"fetchcomment(G56)","v":""}]
[]
["Asian Pacific",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ALIQUOT ASSOCIATES",null,250000,"M",1,{"$f":"fetchcomment(E59)","v":"04A6470"},1,{"$f":"fetchcomment(G59)","v":"HDR Construction Control Corporation"},4]
["ANALYZER INTERNATIONAL, INC.",null,876000,"M",1,{"$f":"fetchcomment(E60)","v":"59A1208"},1,{"$f":"fetchcomment(G60)","v":"HDR Construction Control Corporation"},59]
["ASSET LABORATORIES",null,779993.64,"F",3,{"$f":"fetchcomment(E61)","v":"06A2767\n06A2779\n07A5331"},2,{"$f":"fetchcomment(G61)","v":"Geocon Consultants, Inc.\nGeosyntec Consultants, Inc."},"6, 7"]
["AXIOM ENVIRONMENTAL",null,934788.06,"M",1,{"$f":"fetchcomment(E62)","v":"06A2732"},1,{"$f":"fetchcomment(G62)","v":"BLACKBURN CONSULTING"},6]
["COASTAL ENGINEERING INC",null,1181515.2,"M",1,{"$f":"fetchcomment(E63)","v":"08A3516"},1,{"$f":"fetchcomment(G63)","v":"EXP U.S. SERVICES INC"},8]
["DICKERSON CONSULTING",null,146000,"M",1,{"$f":"fetchcomment(E64)","v":"59A1208"},1,{"$f":"fetchcomment(G64)","v":"HDR Construction Control Corporation"},59]
["INTERPHASE ENVIRONMENTAL, INC.",null,14999.74,"F",1,{"$f":"fetchcomment(E65)","v":"06A2767"},1,{"$f":"fetchcomment(G65)","v":"Geocon Consultants, Inc."},6]
["J MYRAH ENVIRONMENTAL, INC.",467701.98,100000,"F",1,{"$f":"fetchcomment(E66)","v":"03A3447"},1,{"$f":"fetchcomment(G66)","v":"ICF Jones & Stokes"},3]
["KCM ENGINEERING, INC.",null,1740301.98,"M",3,{"$f":"fetchcomment(E67)","v":"06A2824\n59A1195\n59A1206"},3,{"$f":"fetchcomment(G67)","v":"Ghiradelli & Associates, Inc.\nMNS Engineers, Inc.\nFALCON ENGINEERING SERVICES INC"},"6, 59"]
["MOZAMO ENGINEERING, INC.",null,1077788.06,"F",2,{"$f":"fetchcomment(E68)","v":"59A1195\n06A2732"},2,{"$f":"fetchcomment(G68)","v":"MNS Engineers, Inc.\nBLACKBURN CONSULTING"},"6,59"]
["PARK ENGINEEERING, INC.",null,1039701.98,"M",2,{"$f":"fetchcomment(E69)","v":"06A2824\n59A1195"},2,{"$f":"fetchcomment(G69)","v":"Ghiradelli & Associates, Inc.\nMNS Engineers, Inc."},"6, 59"]
["PENECORE DRILLING",null,179998.41,"M",2,{"$f":"fetchcomment(E70)","v":"06A2767\n06A2779"},1,{"$f":"fetchcomment(G70)","v":"Geocon Consultants, Inc."},6]
["TRANSMAT",null,625000,"M",1,{"$f":"fetchcomment(E71)","v":"07A5417\n"},1,{"$f":"fetchcomment(G71)","v":"Kleinfelder"},7]
["TRICERTUS, LLC",null,467701.98,"M",1,{"$f":"fetchcomment(E72)","v":"06A2824"},1,{"$f":"fetchcomment(G72)","v":"Ghiradelli & Associates, Inc."},6]
[null,null,null,null,null,{"$f":"fetchcomment(E73)","v":""},null,{"$f":"fetchcomment(G73)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E74)","v":""},null,{"$f":"fetchcomment(G74)","v":""}]
[]
["Other",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
[null,null,null,null,null,{"$f":"fetchcomment(E77)","v":""},null,{"$f":"fetchcomment(G77)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E78)","v":""},null,{"$f":"fetchcomment(G78)","v":""}]
[]
["Non Minority Women",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["A I M CONSULTING",null,200000,"F",1,{"$f":"fetchcomment(E81)","v":"03A3447"},1,{"$f":"fetchcomment(G81)","v":"ICF Jones & Stokes"},3]
["ALTA ARCHAEOLOGICAL CONSULTING",null,170000,"F",1,{"$f":"fetchcomment(E82)","v":"04A6493"},1,{"$f":"fetchcomment(G82)","v":"AECOM Technical Services"},4]
["ALBAT",null,467701.98,"F",1,{"$f":"fetchcomment(E83)","v":"06A2824"},1,{"$f":"fetchcomment(G83)","v":"Ghiradelli & Associates, Inc."},6]
["APPL INC",null,209998.94,"F",3,{"$f":"fetchcomment(E84)","v":"06A2767\n06A2779\n07A5331"},2,{"$f":"fetchcomment(G84)","v":"Geocon Consultants, Inc.\nGeosyntec Consultants, Inc."},"6, 7"]
["AREA WEST ENVIRONMENTAL",null,400000,"F",1,{"$f":"fetchcomment(E85)","v":"03A3447"},1,{"$f":"fetchcomment(G85)","v":"ICF Jones & Stokes"},3]
["ARCHAEOPALEO RESOURCES",null,30000,"F",1,{"$f":"fetchcomment(E86)","v":"07A5331"},1,{"$f":"fetchcomment(G86)","v":"Geosyntec Consultants, Inc."},7]
["AZAD ENGINEERING PC",null,200000,"F",1,{"$f":"fetchcomment(E87)","v":"04A6470"},1,{"$f":"fetchcomment(G87)","v":"HDR Construction Control Corporation"},4]
["CIVIL WORKS ENGINEERS",null,31346.75,"F",1,{"$f":"fetchcomment(E88)","v":"08A3485"},1,{"$f":"fetchcomment(G88)","v":"ICF JONES & STOKES"},8]
["CONVEY, INC.",null,297500,"F",1,{"$f":"fetchcomment(E89)","v":"04A6493"},1,{"$f":"fetchcomment(G89)","v":"AECOM Technical Services"},4]
["DAVID J. POWERS & ASSOCIATES",null,255000,"F",1,{"$f":"fetchcomment(E90)","v":"04A6493"},1,{"$f":"fetchcomment(G90)","v":"AECOM Technical Services"},4]
["DESTINATION ENTERPRISES",null,467701.98,"F",1,{"$f":"fetchcomment(E91)","v":"06A2824"},1,{"$f":"fetchcomment(G91)","v":"Ghiradelli & Associates, Inc."},6]
["EGRET, INC.",null,100000,"F",1,{"$f":"fetchcomment(E92)","v":"03A3447"},1,{"$f":"fetchcomment(G92)","v":"ICF Jones & Stokes"},3]
["GALLAWAY ENTERPRISES",null,300000,"F",1,{"$f":"fetchcomment(E93)","v":"03A3447"},1,{"$f":"fetchcomment(G93)","v":"ICF Jones & Stokes"},3]
["INTEGRATED ECOSYSTEMS CONSULTING",null,42500,"F",1,{"$f":"fetchcomment(E94)","v":"04A6493"},1,{"$f":"fetchcomment(G94)","v":"AECOM Technical Services"},4]
["KEISH ENVIRONMENTAL",null,85000,"F",1,{"$f":"fetchcomment(E95)","v":"04A6493"},1,{"$f":"fetchcomment(G95)","v":"AECOM Technical Services"},4]
["MATERIAL CULTURE CONSULTING",null,300000,"F",1,{"$f":"fetchcomment(E96)","v":"03A3447"},1,{"$f":"fetchcomment(G96)","v":"ICF Jones & Stokes"},3]
["MONUMENT ROW",null,62693.5,"F",1,{"$f":"fetchcomment(E97)","v":"08A3485"},1,{"$f":"fetchcomment(G97)","v":"ICF JONES & STOKES"},8]
["NATURAL RESOURCES MANAGEMENT CORPORATION",null,250000,"F",1,{"$f":"fetchcomment(E98)","v":"08A3485"},1,{"$f":"fetchcomment(G98)","v":"ICF JONES & STOKES"},8]
["RUBICON ENGINEERING",null,60000,"F",1,{"$f":"fetchcomment(E99)","v":"07A5331"},1,{"$f":"fetchcomment(G99)","v":"Geosyntec Consultants, Inc."},7]
["SEQUOIA ECOLOGICAL CONSULTING",null,550000,"F",2,{"$f":"fetchcomment(E100)","v":"03A3447\n04A6470"},2,{"$f":"fetchcomment(G100)","v":"HDR Construction Control Corporation\nICF Jones & Stokes"},"3, 4"]
["SWAIM BIOLOGICAL CONSULTING",null,510000,"F",1,{"$f":"fetchcomment(E101)","v":"04A6493"},1,{"$f":"fetchcomment(G101)","v":"AECOM Technical Services"},4]
["WATEARTH, INC.",null,250000,"F",1,{"$f":"fetchcomment(E102)","v":"03A3447"},1,{"$f":"fetchcomment(G102)","v":"ICF Jones & Stokes"},3]
["Z & K CONSULTANTS, INC.",null,2357659.6,"F",3,{"$f":"fetchcomment(E103)","v":"59A1195\n08A3516\n59A1206"},3,{"$f":"fetchcomment(G103)","v":"MNS Engineers, Inc.\nEXP U.S. SERVICES INC\nFALCON ENGINEERING SERVICES INC"},"8, 59"]
[]
[]
[]
[]
["Prime Name",null,"# of Contracts","Contract #","Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #"]
["AECOM TECHNICAL SERVICES",null,1,{"$f":"fetchcomment(C109)","v":"04A6493"}]
["BLACKBURN CONSULTING",null,1,{"$f":"fetchcomment(C110)","v":"06A2732"}]
["CHAUDHARY & ASSOCIATES",null,1,{"$f":"fetchcomment(C111)","v":"06A2812"}]
["EXP U.S. SERVICES INC",null,1,{"$f":"fetchcomment(C112)","v":"08A3516"}]
["FALCON ENGINEERING SERVICES INC",null,1,{"$f":"fetchcomment(C113)","v":"59A1206"}]
["GEOCON CONSULTANTS, INC.",null,2,{"$f":"fetchcomment(C114)","v":"06A2767\n06A2779"}]
["GEOSYNTEC CONSULTANTS, INC.",null,1,{"$f":"fetchcomment(C115)","v":"07A5331"}]
["GHIRARDELLI & ASSOCIATES",null,1,{"$f":"fetchcomment(C116)","v":"06A2824"}]
["HDR CONSTRUCTION CONTROL CORPORATION",null,2,{"$f":"fetchcomment(C117)","v":"06A2767\n06A2779"}]
["ICF JONES & STOKES",null,2,{"$f":"fetchcomment(C118)","v":"03A3447\n08A3485"}]
["KLIENFELDER",null,1,{"$f":"fetchcomment(C119)","v":"07A5417"}]
["MNS ENGINEERS, INC.",null,1,{"$f":"fetchcomment(C120)","v":"59A1195"}]
[]
[]
["To see names of prime contractors/contract numbers, place your cursor on comment tab (red triangle)."]
["Caltrans DBE Reports: http://www.dot.ca.gov/hq/bep/reports.htm"]