{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA DPAC JAN 2021 CAA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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 2021 CAA","index":0,"n_rows":117,"n_cols":9,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
["DEPARTMENT OF TRANSPORTATION - CALTRANS"]
["DBE Commitment at Award (CAA) on Federally Funded Major Construction Contracts - October 1, 2020 - January 31, 2020"]
[]
["Total Award Amount",null,"Total DBE Commitment Amount",null,null,"Total Prime Contracts Awarded"]
[98366420,null,{"$f":"SUM(B7:B19)","v":17833545.510000002},null,null,{"$f":"SUM(B107:B114,I107:I114,E107:E114)","v":20}]
["Groups","Commitment Dollars","Firms","Contracts","% of Contracts","% of DBE $","% of Total $"]
["Hispanic American Male",{"$f":"SUMIF(C27:C43,\"m\", B27:B43)","v":3310891.5},{"$f":"COUNTIF(C27:C43,\"M\")","v":11},{"$f":"SUMIF(C27:C43,\"M\",D27:D43)","v":13},{"$f":"D7/D20","v":0.2},{"$f":"B7/C5","v":0.18565525840856756},{"$f":"B7/A5","v":3.3658757734600891E-2}]
["Hispanic American Female",{"$f":"SUMIF(C27:C43,\"F\", B27:B43)","v":242000},{"$f":"COUNTIF(C27:C43,\"F\")","v":3},{"$f":"SUMIF(C27:C43,\"F\",D27:D43)","v":3},{"$f":"D8/D20","v":4.6153846153846156E-2},{"$f":"B8/C5","v":1.3569932006190281E-2},{"$f":"B8/A5","v":2.460189158048041E-3}]
["African American Male",{"$f":"SUMIF(C50:C55,\"m\", B50:B55)","v":360000},{"$f":"COUNTIF(C50:C55,\"M\")","v":3},{"$f":"SUMIF(C50:C55,\"M\",D50:D55)","v":5},{"$f":"D9/D20","v":7.6923076923076927E-2},{"$f":"B9/C5","v":2.0186675711688022E-2},{"$f":"B9/A5","v":3.6597855243689871E-3}]
["African American Female",{"$f":"SUMIF(C50:C55,\"F\", B50:B55)","v":370000},{"$f":"COUNTIF(C50:C55,\"F\")","v":2},{"$f":"SUMIF(C50:C55,\"F\",D50:D55)","v":2},{"$f":"D10/D20","v":3.0769230769230771E-2},{"$f":"B10/C5","v":2.0747416703679356E-2},{"$f":"B10/A5","v":3.7614462333792364E-3}]
["Asian Pacific Male",{"$f":"SUMIF(C69:C82,\"m\", B69:B82)","v":5134178.01},{"$f":"COUNTIF(C69:C82,\"M\")","v":11},{"$f":"SUMIF(C69:C82,\"M\",D69:D82)","v":19},{"$f":"D11/D20","v":0.29230769230769232},{"$f":"B11/C5","v":0.28789440703874924},{"$f":"B11/A5","v":5.2194417668143249E-2}]
["Asian Pacific Female",{"$f":"SUMIF(C69:C82,\"F\", B69:B82)","v":690960},{"$f":"COUNTIF(C69:C82,\"F\")","v":2},{"$f":"SUMIF(C69:C82,\"F\",D69:D82)","v":2},{"$f":"D12/D20","v":3.0769230769230771E-2},{"$f":"B12/C5","v":3.8744959582633208E-2},{"$f":"B12/A5","v":7.0243483497722092E-3}]
["Subcontinent Asian Male",{"$f":"SUMIF(C58:C66,\"m\", B58:B66)","v":4366085.7},{"$f":"COUNTIF(C60:C66,\"M\")","v":6},{"$f":"SUMIF(C60:C66,\"M\",D60:D66)","v":6},{"$f":"D13/D20","v":9.2307692307692313E-2},{"$f":"B13/C5","v":0.24482432265371776},{"$f":"B13/A5","v":4.4385936786151207E-2}]
["Subcontinent Asian Female",{"$f":"SUMIF(C58:C66,\"F\", B58:B66)","v":0},{"$f":"COUNTIF(C60:C66,\"F\")","v":0},{"$f":"SUMIF(C60:C66,\"F\",D60:D66)","v":0},{"$f":"D14/D20","v":0},{"$f":"B14/C5","v":0},{"$f":"B14/A5","v":0}]
["Native American Male",{"$f":"SUMIF(C46:C47,\"m\", B46:B47)","v":0},{"$f":"COUNTIF(C46:C47,\"M\")","v":0},{"$f":"SUMIF(C46:C47,\"M\",D46:D47)","v":0},{"$f":"D15/D20","v":0},{"$f":"B15/C5","v":0},{"$f":"B15/A5","v":0}]
["Native American Female",{"$f":"SUMIF(C46:C47,\"F\", B46:B47)","v":0},{"$f":"COUNTIF(C46:C47,\"F\")","v":0},{"$f":"SUMIF(C46:C47,\"F\",D46:D47)","v":0},{"$f":"D16/D20","v":0},{"$f":"B16/C5","v":0},{"$f":"B16/A5","v":0}]
["Non Minority Women",{"$f":"SUMIF(C89:C102,\"F\", B89:B102)","v":3359430.3},{"$f":"COUNTIF(C89:C102,\"F\")","v":13},{"$f":"SUMIF(C89:C102,\"F\",D89:D102)","v":15},{"$f":"D17/D20","v":0.23076923076923078},{"$f":"B17/C5","v":0.18837702789477445},{"$f":"B17/A5","v":3.415220661685156E-2}]
["Non Minority Men",{"$f":"SUMIF(C85:C86,\"F\", B85:B86)","v":0},{"$f":"COUNTIF(C85:C86,\"F\")","v":0},{"$f":"SUMIF(C85:C86,\"F\",D85:D86)","v":0},{"$f":"D18/D20","v":0},{"$f":"B18/C5","v":0},{"$f":"B18/A5","v":0}]
[]
["Total  ",null,{"$f":"SUM(C7:C19)","v":51},{"$f":"SUM(D7:D19)","v":65}]
["Total Prime Contracts Awarded",{"$f":"SUM(B107:B114,E107:E114,I107:I114)","v":20}]
["Red Italic = DBE firm as Prime"]
["BOLD = women"]
[]
[]
["Hispanic American","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ACT CONSULTING ENGINEERS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G6","v":1540315.5},"M",2,{"$f":"FETCHCOMMENT(D27)","v":"12A1857\n12A1863"},1,{"$f":"FETCHCOMMENT(F27)","v":"TRANSYSTEMS CORPORATION"},12]
["ALTA LAND SURVEYING INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G13","v":6000},"M",1,{"$f":"FETCHCOMMENT(D28)","v":"11A3117"},1,{"$f":"FETCHCOMMENT(F28)","v":"KIMLEY-HORN & ASSOCIATES INC"},11]
["ARAGON GEOTECHNICAL",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G18","v":460000},"M",1,"08A3187",1,"ALTA VISTA SOLUTIONS",8]
["CADRE DESIGN",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G24","v":80000},"M",1,"59A1107",1,"KLEINFELDER INC",59]
["CALIFORNIA TESTING & ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C7","v":92000},"F",1,"08A3187",1,"ALTA VISTA SOLUTIONS",8]
["DYNAMIC CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G31","v":50000},"M",1,"11A3122",1,"JACOBS ENGINEERING GROUP",11]
["EARTHVIEW SCIENCE",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C13","v":100000},"F",1,"04A6021",1,"JACOBS ENGINEERING GROUP",4]
["ESTRADA LAND PLANNING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C22","v":50000},"F",1,"11A3122",1,"JACOBS ENGINEERING GROUP",11]
["LA SALLE  SOLUTIONS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G37","v":126576},"M",1,"12A1860",1,"TRC ENGINEERS INC",12]
["LOPEZ ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G48","v":450000},"M",1,"11A3122",1,"JACOBS ENGINEERING GROUP",11]
["MONTEZ GROUP INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G54","v":60000},"M",1,"04A6043\n",1,"ARCADIS U.S. INC",4]
["NOMAD ECOLOGY INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G61","v":100000},"M",1,"04A6021",1,"JACOBS ENGINEERING GROUP",4]
["RUZ CONSULTING ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G68","v":120000},"M",1,"07A4986",1,"ARCADIS U.S. INC",7]
["UNDER CONSTRUCTION",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G76","v":318000},"M",2,"11A3117\n03A3120",2,"KIMLEY-HORN & ASSOCIATES INC\nTRC ENGINEERS INC","3,11"]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[]
["Native American","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[]
["African American","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["BIOMAAS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AE6","v":200000},"M",1,"04A6021",1,"JACOBS ENGINEERING GROUP INC",4]
["DAVID ENGINEERING LLC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AE12","v":50000},"M",1,"11A3122",1,"JACOBS ENGINEERING GROUP INC",11]
["ELLE CONSULTANTS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AA6","v":250000},"F",1,"04A6036",1,"ELLE CONSULTANTS",4]
["O2EPCM INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AA16","v":120000},"F",1,"07A4986",1,"ARCADIS U.S. INC",7]
["TRIUNITY ENGINEERING ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AE23","v":110000},"M",3,"03A3117\n53A0252\n04A6043",2,"KREBS CORPORATION\nARCADIS U.S. INC","3,4,53"]
[null,null,null,null,"",null,""]
[]
["Sub Cont Asian","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["AMC INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM9","v":880960},"M",3,"07A4986\n08A3183\n12A1860",3,"ARCADIS U.S. INC\nWSP USA INC\nTRC ENGINEERS INC","7,8,12"]
["CHAUDHARY & ASSOCIATES INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM17","v":1940827.4},"M",2,"06A2613\n59A1107",2,"CHAUDHARY & ASSOCIATES INC\nKLEINFELDER INC","6,59"]
["EARTH MECHANICS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM25","v":12000},"M",1,"11A3117",1,"KIMLEY-HORN ^ ASSOICATES INC",11]
["IQON ENGINEERS INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM31","v":503100},"M",1,"08A3229",1,"PARSONS TRANSPORTATION GROUP INC",8]
["KAL KRISHNAN CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM38","v":180000},"M",1,"07A4986",1,"ARCADIS U.S. INC",7]
["T J K M ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM45","v":210960},"M",1,"12A1860",1,"TRC ENGINEERS INC",12]
["TORRENT LABORATORY INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM53","v":558238.30000000005},"M",1,"06A2647",1,"MICHAEL BAKER INTERNATIONAL INC",6]
[null,{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM63","v":80000},"M",1,"59A1107",1,"KLEINFELDER INC",59]
[null,null,null,null,"",null,""]
[]
["Asian Pacific","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["1ST CHOICE DBE INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O6","v":84000},"M",1,"03A3117",1,"03A3117",3]
["A P ENGINEERING AND",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O13","v":80000},"M",1,"59A1107",1,"KLEINFELDER INC",59]
["ADVANTEC CONSULTING ENGINEERS ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O23","v":1151663.1000000001},"M",3,"11A3117\n11A3122\n12A1857",3,"KIMLEY-HORN ^ ASSOICATES INC\nJACOBS ENGINEERING GROUP INC\nTRANSYSTEMS CORPORATION","11,12"]
["C2PM",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!K8","v":210960},"F",1,"12A1860",1,"TRC ENGINEERS INC",12]
["CL SURVEYING AND MAPPING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O28","v":558387.19999999995},"M",1,"08A3230",1,"GUIDA SURVEYING INC",8]
["LIN CONSULTING ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O40","v":1021323.1},"M",4,"12A1857\n12A1861\n12A1863\n08A3229",3,"TRANSYSTEMS CORPORATION\nAECOM TECHNICAL SERVICES INC\nPARSONS TRANSPORTATION GROUP INC","8,12"]
["LRS PROGRAM DELIVERY",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!K15","v":480000},"F",1,"03A3120",1,"TRC ENGINEERS",3]
["PRESCIENCE CORPORATION",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O47","v":700000},"M",1,"08A3183",1,"WSP USA INC",8]
["SILICON TRANSPORTATION ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O52","v":120000},"M",1,"11A3117",1,"KIMLEY-HORN ^ ASSOICATES INC",11]
["TATSUMI AND PARTNERS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O59","v":484534.65},"M",3,"12A1857\n12A1861\n12Z1863",2,"TRANSYSTEMS CORPORATION\nAECOM TECHNICAL SERVICES INC\n",12]
["TRANSMAT",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O67","v":84384},"M",1,"12A1860",1,"TRC ENGINEERS INC",12]
["TRICERTUS LLC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O73","v":80000},"M",1,"04A6043",1,"ARCADIS U.S. INC",4]
["WRECO",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O88","v":769885.96},"M",2,"04A6021\n06A2647",2,"JACOBS ENGINEERING GROUP\nMICHAEL BAKER INTERNATIONAL INC","4,6"]
[null,null,null,null,"",null,""]
[]
["Other","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[]
["Non Minority Women","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ALERT-O-LITE INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ6","v":80000},"F",1,"59A1107",1,"KLEINFELDER INC",59]
["APPLIED TECHNOLOGY",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ16","v":400000},"F",1,"04A6021",1,"JACOBS ENGINEERING GROUP",4]
["AREA WEST ENVURONMENTAL",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ24","v":200000},"F",1,{"$f":"FETCHCOMMENT(D91)","v":"04A6021"},1,{"$f":"FETCHCOMMENT(F91)","v":"JACOBS ENGINEERING GROUP"},4]
["AVILA TRAFFIC SAFETY",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ32","v":400000},"F",1,"59A1107",1,"KLEINFELDER INC",59]
["BLUE LAKE CIVIL ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ40","v":327000},"F",3,"11A3117\n03A3117\n53A0252",2,"KIMLEY-HORN ^ ASSOICATES INC\nKREBS CORPORATION","11,53"]
["CIVIL WORKS ENGINEERS ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ46","v":558238.30000000005},"F",1,"06A2647",1,"MICHAEL BAKER INTERNATIONAL INC",6]
["DILLAR ENVIRONMENTAL SERVICES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ53","v":400000},"F",1,"59A1107",1,"KLEINFELDER INC",59]
["GATEWAY PACIFIC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ60","v":120000},"F",1,"11A3117",1,"KIMLEY-HORN ^ ASSOICATES INC",11]
["MYRIAD ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ66","v":120000},"F",1,"03A3120",1,"TRC ENGINEERS INC",3]
["NORTHGATE ENVIRONMENTAL",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ72","v":100000},"F",1,"04A6021",1,"JACOBS ENGINEERING GROUP",4]
["P R R INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ83","v":12000},"F",1,"11A3117",1,"KIMLEY-HORN ^ ASSOICATES INC",11]
["PAVEMENT MANAGEMENT",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ78","v":42192},"F",1,"12A1860",1,"TRC ENGINEERS INC",12]
["SWAIM BIOLOGICAL CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ90","v":600000},"F",1,"04A6021",1,"JACOBS ENGINEERING GROUP",4]
[null,null,null,null,"",null,""]
[]
[]
[]
["Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #"]
["AECOM TECHNICAL SERVICES INC",1,{"$f":"FETCHCOMMENT(B107)","v":"12A1861"},"KLEINFELDER INC",1,"59A1107"]
["ARCADIS U.S. INC",2,{"$f":"FETCHCOMMENT(B108)","v":"07A4986\n04A6043"},"KREBS CORPORATION",2,"03A3117\n53A0252"]
["ALTA VISTA SOLUTIONS",1,"08A3187","MICHAEL BAKER INTERNATIONAL INC",1,"06A2647"]
["CHAUDHARY & ASSOCIATES INC",1,"06A2613","PARSONS TRANSPORTATION GROUP INC",1,"08A3229"]
["ELLE CONSULTANTS",1,"04A6036","TRANSYSTEMS CORPORATION",2,"12A1857\n12A1863"]
["GUIDA SURVEYING INC",1,"08A3230","TRC ENGINEERS INC",2,"12A1860\n03A3120\n"]
["JACOBS ENGINEERING GROUP INC",2,"11A3122\n04A6021","WSP USA INC",1,"08A3183"]
["KIMLEY-HORN & ASSOCIATES INC",1,"11A3117",null,null,""]
[]
["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"]