{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA DPAC AUGUST 2025 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 AUGUST 2025 CAA","index":0,"n_rows":151,"n_cols":10,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["DEPARTMENT OF TRANSPORTATION - CALTRANS"]
["DBE Commitment at Award (CAA) on Federally Funded Architectural & Engineering Contracts - October 1, 2024 - August  31, 2025"]
[]
["Total Award Amount Year-to-Date (YTD)",null,"Total DBE Commitment Amount YTD",null,null,"Total Prime Contracts Awarded YTD"]
[525378775.74000001,null,{"$f":"SUM(C7:C18)","v":132506688.55999999},null,null,{"$f":"SUM(C139:C148,I139:I148,F139:F148)","v":34}]
["Groups ",null," Commitment Dollars YTD","Firms YTD","Contracts YTD","% of Contracts","% of DBE $","% of Total $"]
["Hispanic American Male",null,{"$f":"SUMIF(D26:D55,\"m\", C26:C55)","v":34418305.879999995},{"$f":"COUNTIF(D26:D55,\"M\")","v":23},{"$f":"SUMIF(D26:D55,\"M\",E26:E55)","v":58},{"$f":"E7/E20","v":0.31521739130434784},{"$f":"C7/C5","v":0.25974768710950874},{"$f":"C7/A5","v":6.5511412849751205E-2}]
["Hispanic American Female",null,{"$f":"SUMIF(D26:D55,\"F\", C26:C55)","v":4193366.44},{"$f":"COUNTIF(D26:D55,\"F\")","v":6},{"$f":"SUMIF(D26:D55,\"F\",E26:E55)","v":11},{"$f":"E8/E20","v":5.9782608695652176E-2},{"$f":"C8/C5","v":3.1646451100475682E-2},{"$f":"C8/A5","v":7.9816060976075996E-3}]
["African American Male",null,{"$f":"SUMIF(D63:D69,\"m\", C63:C69)","v":5485561.3200000003},{"$f":"COUNTIF(D63:D69,\"M\")","v":4},{"$f":"SUMIF(D63:D69,\"M\",E63:E69)","v":7},{"$f":"E9/E20","v":3.8043478260869568E-2},{"$f":"C9/C5","v":4.1398373015080654E-2},{"$f":"C9/A5","v":1.0441155168998873E-2}]
["African American Female",null,{"$f":"SUMIF(D63:D69,\"F\", C63:C69)","v":1315000},{"$f":"COUNTIF(D63:D69,\"F\")","v":2},{"$f":"SUMIF(D63:D69,\"F\",E63:E69)","v":3},{"$f":"E10/E20","v":1.6304347826086956E-2},{"$f":"C10/C5","v":9.924027339982603E-3},{"$f":"C10/A5","v":2.5029560780178311E-3}]
["Asian Pacific Male",null,{"$f":"SUMIF(D86:D102,\"m\", C86:C102)","v":23531918.57},{"$f":"COUNTIF(D86:D102,\"M\")","v":9},{"$f":"SUMIF(D86:D102,\"M\",E86:E102)","v":25},{"$f":"E11/E20","v":0.1358695652173913},{"$f":"C11/C5","v":0.17759042072313638},{"$f":"C11/A5","v":4.4790386777340048E-2}]
["Asian Pacific Female",null,{"$f":"SUMIF(D86:D102,\"F\", C86:C102)","v":12097516.580000002},{"$f":"COUNTIF(D86:D102,\"F\")","v":7},{"$f":"SUMIF(D86:D102,\"F\",E86:E102)","v":14},{"$f":"E12/E20","v":7.6086956521739135E-2},{"$f":"C12/C5","v":9.1297403259173279E-2},{"$f":"C12/A5","v":2.3026275781621666E-2}]
["Subcontinent Asian Male",null,{"$f":"SUMIF(D72:D83,\"m\", C72:C83)","v":24942230.710000001},{"$f":"COUNTIF(D72:D83,\"M\")","v":7},{"$f":"SUMIF(D72:D83,\"M\",E72:E83)","v":21},{"$f":"E13/E20","v":0.11413043478260869},{"$f":"C13/C5","v":0.18823374865870246},{"$f":"C13/A5","v":4.7474758901077947E-2}]
["Subcontinent Asian Female",null,{"$f":"SUMIF(D72:D83,\"F\", C72:C83)","v":2428537.0500000003},{"$f":"COUNTIF(D72:D83,\"F\")","v":4},{"$f":"SUMIF(D72:D83,\"F\",E72:E83)","v":8},{"$f":"E14/E20","v":4.3478260869565216E-2},{"$f":"C14/C5","v":1.8327656334875059E-2},{"$f":"C14/A5","v":4.6224498631095012E-3}]
["Native American Male",null,{"$f":"SUMIF(D58:D60,\"m\", C58:C60)","v":870000},{"$f":"COUNTIF(D58:D60,\"M\")","v":2},{"$f":"SUMIF(D58:D60,\"M\",E58:E60)","v":2},{"$f":"E15/E20","v":1.0869565217391304E-2},{"$f":"C15/C5","v":6.5657063009770837E-3},{"$f":"C15/A5","v":1.6559481276619871E-3}]
["Native American Female",null,{"$f":"SUMIF(D58:D60,\"F\", C58:C60)","v":0},{"$f":"COUNTIF(D58:D60,\"F\")","v":0},{"$f":"SUMIF(D58:D60,\"F\",E58:E60)","v":0},{"$f":"E16/E20","v":0},{"$f":"C16/C5","v":0},{"$f":"C16/A5","v":0}]
["Non Minority Women",null,{"$f":"SUMIF(D109:D134,\"F\", C109:C134)","v":23224252.009999994},{"$f":"COUNTIF(D109:D134,\"F\")","v":24},{"$f":"SUMIF(D109:D134,\"F\",E109:E134)","v":35},{"$f":"E17/E20","v":0.19021739130434784},{"$f":"C17/C5","v":0.17526852615808813},{"$f":"C17/A5","v":4.4204777738286932E-2}]
["Non Minority Men",null,{"$f":"SUMIF(D105:D106,\"F\", C105:C106)","v":0},{"$f":"COUNTIF(D105:D106,\"F\")","v":0},{"$f":"SUMIF(D105:D106,\"F\",E105:E106)","v":0},{"$f":"E18/E20","v":0},{"$f":"C18/C5","v":0},{"$f":"C18/A5","v":0}]
[]
["Total  ",null,{"$f":"SUM(C7:C18)","v":132506688.55999999},{"$f":"SUM(D7:D19)","v":88},{"$f":"SUM(E7:E19)","v":184}]
["Total Prime Contracts Awarded",null,{"$f":"SUM(C139:C148,F139:F148,I139:I148)","v":34}]
["Red Italic = DBE firm as Prime"]
["BOLD = women"]
[]
["Hispanic American",null,"Dollars","M/F","# of Contracts","Contract #","# of Primes","Prime Name","Districts"]
["365 PROJECT CONTROLS CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!G8","v":120000},"M",1,{"$f":"FETCHCOMMENT(E26)","v":"07A6016"},1,{"$f":"FETCHCOMMENT(G26)","v":"Jacobs Project Management Co."},7]
["ADV-SOC, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!G18","v":1287210.25},"M",4,{"$f":"FETCHCOMMENT(E27)","v":"11A3999\n12A2206\n04A7117\n12A2210"},3,{"$f":"FETCHCOMMENT(G27)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC.\nFOUNTAINHEAD CONSULTING\nHDR ENGINEERING INC"},59]
["ADVANCED TECHNOLOGY",null,{"$f":"'[1]DPAC A&E Worksheet'!G24","v":240000},"M",1,{"$f":"FETCHCOMMENT(E28)","v":"07A6010"},1,{"$f":"FETCHCOMMENT(G28)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["AIX CONSULTING, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!G39","v":3050963.7},"M",5,{"$f":"FETCHCOMMENT(E29)","v":"11A3999\n12A2206\n04A7117\n12A2210\n59A1332"},3,{"$f":"FETCHCOMMENT(G29)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC.\nFOUNTAINHEAD CONSULTING\nHDR ENGINEERING INC"},"4,11,12,59"]
["AMC INC",null,{"$f":"'[1]DPAC A&E Worksheet'!G45","v":180000},"M",1,{"$f":"FETCHCOMMENT(E30)","v":"12A2203"},1,{"$f":"FETCHCOMMENT(G30)","v":"JACOBS PROJECT MANAGMENT"},12]
["BARGAS ENVIRONMENTAL",null,{"$f":"'[1]DPAC A&E Worksheet'!C13","v":2949098.02},"F",4,{"$f":"FETCHCOMMENT(E31)","v":"04A7044\n04A7071\n04A7106\n06A3116"},3,{"$f":"FETCHCOMMENT(G31)","v":"KLEINFELDER, INC.\nAECOM TECHNICAL SERVICES, INC.\nPARSONS TRANSPORTATION GROUP, INC."},4]
["BAYSIDE ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!G52","v":240000},"M",1,{"$f":"FETCHCOMMENT(E32)","v":"07A6010"},1,{"$f":"FETCHCOMMENT(G32)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["CABRINHA HEARN ",null,{"$f":"'[1]DPAC A&E Worksheet'!G60","v":330000},"M",1,{"$f":"FETCHCOMMENT(E33)","v":"07A6087"},1,{"$f":"FETCHCOMMENT(G33)","v":"Michael Baker International, Inc.\n"},7]
["EARTHVIEW SCIENCE",null,{"$f":"'[1]DPAC A&E Worksheet'!C20","v":185000},"F",1,{"$f":"FETCHCOMMENT(E34)","v":"04A7044"},1,{"$f":"FETCHCOMMENT(G34)","v":"KLEINFELDER, INC."},4]
["FERNANDEZ CONSTRUCTION",null,{"$f":"'[1]DPAC A&E Worksheet'!G68","v":168000},"M",1,{"$f":"FETCHCOMMENT(E35)","v":"12A2212"},1,{"$f":"FETCHCOMMENT(G35)","v":"PARSONS TRANSPORTATION GROUP, INC."},12]
["FOUNTAINHEAD CONSULTING CORP",null,{"$f":"'[1]DPAC A&E Worksheet'!G83","v":8959963.6999999993},"M",9,{"$f":"FETCHCOMMENT(E36)","v":"12A2203\n59A1319\n11A3999\n12A2206\n12A2212\n12A2210\n59A1332\n07A6021\n07A6016"},8,{"$f":"FETCHCOMMENT(G36)","v":"JACOBS PROJECT MANAGEMENT\nPARSONS TRANSPORTATION GROUP, INC.\nKLEINFELDER CONSTRUCTION SERVICES, INC.\nFOUNTAINHEAD CONSULTING\nPARSONS TRANSPORTATION GROUP, INC.\nHDR ENGINEERING INC\nTRC ENGINEERS INC\nJACOBS PROJECT MANAGEMENT CO "},"7,11,12,59"]
["FRANCISON CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!G89","v":180000},"M",1,{"$f":"FETCHCOMMENT(E37)","v":"07A6021"},1,{"$f":"FETCHCOMMENT(G37)","v":"TRC ENGINEERS INC"},7]
["LA SALLE SOLUTIONS",null,{"$f":"'[1]DPAC A&E Worksheet'!G105","v":1881292.9},"M",6,{"$f":"FETCHCOMMENT(E38)","v":"12A2203\n11A3999\n12A2210\n07A6021\n07A6016\n08A3848"},5,{"$f":"FETCHCOMMENT(G38)","v":"JACOBS PROJECT MANAGEMENT\nKLEINFELDER CONSTRUCTION SERVICES, INC.\nHDR Engineering, Inc.\nTRC ENGINEERS INC\nNV5 INC"},"7,8,11,12"]
["MARTINEZ GROSPATIAL INC",null,{"$f":"'[1]DPAC A&E Worksheet'!G117","v":480306.75},"M",1,{"$f":"FETCHCOMMENT(E39)","v":"59A1330"},1,{"$f":"FETCHCOMMENT(G39)","v":"TOWILL INC"},59]
["MESA BIOLOGICAL LLC",null,{"$f":"'[1]DPAC A&E Worksheet'!G111","v":476627.44},"M",1,{"$f":"FETCHCOMMENT(E40)","v":"06A3116"},1,{"$f":"FETCHCOMMENT(G40)","v":"PARSONS TRANSPORTATION GROUP, INC."},6]
["MONTEZ GROUP, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!G126","v":1725000},"M",3,{"$f":"FETCHCOMMENT(E41)","v":"59A1319\n59A1325\n59A1324"},2,{"$f":"FETCHCOMMENT(G41)","v":"PARSONS TRANSPORTATION GROUP, INC.\nHDR CONSTRUCTION CONTROL CORPORATION"},59]
["MTGL INC",null,{"$f":"'[1]DPAC A&E Worksheet'!C27","v":372000},"F",2,{"$f":"FETCHCOMMENT(E42)","v":"12A2203\n12A2210"},2,{"$f":"FETCHCOMMENT(G42)","v":"JACOBS PROJECT MANAGEMENT\nHDR Engineering, Inc."},12]
["NOMAD ECOLOGY, LLC",null,{"$f":"'[1]DPAC A&E Worksheet'!G132","v":740000},"M",1,{"$f":"FETCHCOMMENT(E43)","v":"04A7044"},1,{"$f":"FETCHCOMMENT(G43)","v":"KLEINFELDER, INC."},4]
["PEC WATER INC",null,{"$f":"'[1]DPAC A&E Worksheet'!G139","v":580000},"M",1,{"$f":"FETCHCOMMENT(E44)","v":"04A7117"},1,{"$f":"FETCHCOMMENT(G44)","v":"HDR Engineering, Inc."},4]
["R T ENGINEERING & ASSOCIATES",null,{"$f":"'[1]DPAC A&E Worksheet'!C34","v":102000},"F",1,{"$f":"FETCHCOMMENT(E45)","v":"12A2210"},1,{"$f":"FETCHCOMMENT(G45)","v":"HDR Engineering, Inc."},12]
["RUZ CONSULTING ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!G147","v":180000},"M",1,{"$f":"FETCHCOMMENT(E46)","v":"07A6016"},1,{"$f":"FETCHCOMMENT(G46)","v":"JACOBS PROJECT MANAGEMENT CO"},7]
["SAFE2CORE",null,{"$f":"'[1]DPAC A&E Worksheet'!C40","v":110268.42},"F",1,{"$f":"FETCHCOMMENT(E47)","v":"03A3892"},1,{"$f":"FETCHCOMMENT(G47)","v":"GEOCON CONSULTANTS INC"},3]
["SAMA CONSTRUCTION",null,{"$f":"'[1]DPAC A&E Worksheet'!G155","v":450292.9},"M",1,{"$f":"FETCHCOMMENT(E48)","v":"08A3848"},1,{"$f":"FETCHCOMMENT(G48)","v":"NV5 INC"},8]
["SIX RIVERS GEOSCIENCES",null,{"$f":"'[1]DPAC A&E Worksheet'!C50","v":475000},"F",2,{"$f":"FETCHCOMMENT(E49)","v":"04A7044\n04A7117"},2,{"$f":"FETCHCOMMENT(G49)","v":"KLEINFELDER, INC.\nHDR ENGINEERING INC"},4]
["SJ CONSTRUCTION MANAGEMENT",null,{"$f":"'[1]DPAC A&E Worksheet'!G169","v":3372284.7199999997},"M",3,{"$f":"FETCHCOMMENT(E50)","v":"59A1325\n59A1324\n06A3121"},1,{"$f":"FETCHCOMMENT(G50)","v":"HDR CONSTRUCTION CONTROL CORPORATION"},"6,59"]
["SYRUSA ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!G183","v":2547439.35},"M",7,{"$f":"FETCHCOMMENT(E51)","v":"12A2203\n11A3999\n12A2210\n07A6009\n07A6021\n07A6016\n08A3848"},5,{"$f":"FETCHCOMMENT(G51)","v":"JACOBS PROJECT MANAGEMENT\nKLEINFELDER CONSTRUCTION SERVICES, INC.\nHDR Engineering, Inc.\nTRC ENGINEERS INC\nNV5 INC"},"7,8,11,12"]
["UNICO ENGINEERING CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!G191","v":2916639.45},"M",3,{"$f":"FETCHCOMMENT(E52)","v":"03A3892\n03A3914\n06A3121"},3,{"$f":"FETCHCOMMENT(G52)","v":"GEOCON CONSULTANTS INC\nPSOMAS\nHDR CONSTRUCTION"},"3,6"]
["VSCE, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!G206","v":3842284.7199999997},"M",4,{"$f":"FETCHCOMMENT(E53)","v":"59A1319\n59A1325\n59A1324\n06A3121"},2,{"$f":"FETCHCOMMENT(G53)","v":"PARSONS TRANSPORTATION GROUP, INC.\nHDR CONSTRUCTION CONTROL CORPORATION"},"6,59"]
["VST ENGINEERING, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!G212","v":470000},"M",1,{"$f":"FETCHCOMMENT(E54)","v":"59A1319"},1,{"$f":"FETCHCOMMENT(G54)","v":"PARSONS TRANSPORTATION GROUP, INC."},59]
[null,null,".",null,null,{"$f":"FETCHCOMMENT(E55)","v":""},null,{"$f":"FETCHCOMMENT(G55)","v":""}]
[]
["Native American",null,"Dollars","M/F","# of Contracts","Contract #","# of Primes","Prime Name","Districts"]
["FMF PANDION",null,{"$f":"'[1]DPAC A&E Worksheet'!W10","v":580000},"M",1,{"$f":"FETCHCOMMENT(E58)","v":"04A7117"},1,{"$f":"FETCHCOMMENT(G58)","v":"HDR Engineering, Inc."},4]
["GERONIMO ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!W22","v":290000},"M",1,{"$f":"FETCHCOMMENT(E59)","v":"04A7117"},1,{"$f":"FETCHCOMMENT(G59)","v":"HDR Engineering, Inc."},4]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E60)","v":""},null,{"$f":"FETCHCOMMENT(G60)","v":""}]
[]
["African American",null,"Dollars","M/F","# of Contracts","Contract #","# of Primes","Prime Name","Districts"]
["ACTIVEWAYZ ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AI8","v":1450000},"M",1,{"$f":"FETCHCOMMENT(E63)","v":"04A7117"},1,{"$f":"FETCHCOMMENT(G63)","v":"HDR Engineering, Inc."},4]
["ANCHOR ENGINEERING, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!AC20","v":705000},"F",1,{"$f":"FETCHCOMMENT(E64)","v":"59A1319"},1,{"$f":"FETCHCOMMENT(G64)","v":"PARSONS TRANSPORTATION GROUP, INC."},59]
["APEX ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AI15","v":450292.9},"M",1,{"$f":"FETCHCOMMENT(E65)","v":"08A3848"},1,{"$f":"FETCHCOMMENT(G65)","v":"NV5 INC\n"},8]
["BIOMASS",null,{"$f":"'[1]DPAC A&E Worksheet'!AI28","v":3155000},"M",3,{"$f":"FETCHCOMMENT(E66)","v":"04A7044\n04A7071\n04A7106"},2,{"$f":"FETCHCOMMENT(G66)","v":"KLEINFELDER, INC.\nAECOM TECHNICAL SERVICES, INC."},4]
["DAVIS & ASSOCIATES",null,{"$f":"'[1]DPAC A&E Worksheet'!AC32","v":610000},"F",2,{"$f":"FETCHCOMMENT(E67)","v":"04A7044\n04A7071"},1,{"$f":"FETCHCOMMENT(G67)","v":"KLEINFELDER, INC."},4]
["GREGG DRILLING LLC",null,{"$f":"'[1]DPAC A&E Worksheet'!AI43","v":430268.42},"M",2,{"$f":"FETCHCOMMENT(E68)","v":"03A3892\n07A6010"},2,{"$f":"FETCHCOMMENT(G68)","v":"GEOCON CONSULTANTS INC\nGEOSYNTEC CONSULTANTS"},"3,7"]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E69)","v":""},null,{"$f":"FETCHCOMMENT(G69)","v":""}]
[]
["Sub Cont Asian",null,"Dollars","M/F","# of Contracts","Contract #","# of Primes","Prime Name","Districts"]
["AMC, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ14","v":1770169.49},"M",5,{"$f":"FETCHCOMMENT(E72)","v":"59A1338\n59A1336\n07A6009\n07A6021\n07A6016"},4,{"$f":"FETCHCOMMENT(G72)","v":"AMC, INC.\nATLAS TECHNICAL CONSULTANTS \nJACOBS PROJECT MANAGEMENT, INC.\nTRC ENGINEERS INC"},"7,59"]
["ENTERRIS ASSOCIATES, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ26","v":100000},"M",1,{"$f":"FETCHCOMMENT(E73)","v":"11A3999"},1,{"$f":"FETCHCOMMENT(G73)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC."},11]
["FULCRUM CONSULTANTS INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ34","v":478000},"M",3,{"$f":"FETCHCOMMENT(E74)","v":"12A2206\n12A2210\n07A6021"},3,{"$f":"FETCHCOMMENT(G74)","v":"FOUNTAINHEAD CONSULTING\nHDR Engineering, Inc.\nTRC ENGINEERS INC"},"7,12"]
["GEODE ENVIRONMENTAL",null,{"$f":"'[1]DPAC A&E Worksheet'!AM9","v":335642.15},"F",1,{"$f":"FETCHCOMMENT(E75)","v":"09A1060"},1,{"$f":"FETCHCOMMENT(G75)","v":"RINCON"},9]
["GRIT FORCE",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ41","v":4363659},"M",1,{"$f":"FETCHCOMMENT(E76)","v":"59A1336"},1,{"$f":"FETCHCOMMENT(G76)","v":"ATLAS TECHNICAL CONSULTANTS"},59]
["IQON ENGINEERS INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ48","v":270000},"M",1,{"$f":"FETCHCOMMENT(E77)","v":"07A6021"},1,{"$f":"FETCHCOMMENT(G77)","v":"TRC ENGINEERS INC"},7]
["REDDY ANTHROPOLOGY CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!AM21","v":280016.2},"F",1,{"$f":"FETCHCOMMENT(E78)","v":"11A3999\n"},1,{"$f":"FETCHCOMMENT(G78)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC.\n"},11]
["REDDY ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ59","v":700000},"M",1,{"$f":"FETCHCOMMENT(E79)","v":"06A3140"},1,{"$f":"FETCHCOMMENT(G79)","v":"FAR WESTERN ANTHOROPOLOGICAL"},6]
["S2 ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ79","v":17260402.219999999},"M",9,{"$f":"FETCHCOMMENT(E80)","v":"12A2210\n59A1332\n59A1338\n59A1336\n59A1337\n07A6009\n07A6088\n04A7232\n08A3848"},8,{"$f":"FETCHCOMMENT(G80)","v":"HDR Engineering, Inc.\nMNS ENGINEERS, INC.\nWSP USA ENVIRONMENT & INFRASTRUCTURE, INC.\nALTAS TECHINICAL CONSULTANTS\nKLEINFELDER INC\nJACOBS PROJECT MANAGEMENT, INC.\nS2 ENGINEERING\nNV5 INC"},"4,7,8,12,59"]
["SAMSA ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AM32","v":726439.35},"F",2,{"$f":"FETCHCOMMENT(E81)","v":"12A2210\n08A3848"},2,{"$f":"FETCHCOMMENT(G81)","v":"HDR Engineering, Inc.\nNV5 INC"},"8,12"]
["SKYLINE CONSULTANTS",null,{"$f":"'[1]DPAC A&E Worksheet'!AM46","v":1086439.3500000001},"F",4,{"$f":"FETCHCOMMENT(E82)","v":"12A2203\n12A2210\n07A6016\n08A3848"},3,{"$f":"FETCHCOMMENT(G82)","v":"JACOBS PROJECT MANAGEMENT\nHDR Engineering, Inc.\nNV5 INC"},"7,8,12"]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E83)","v":""},null,{"$f":"FETCHCOMMENT(G83)","v":""}]
[]
["Asian Pacific",null,"Dollars","M/F","# of Contracts","Contract #","# of Primes","Prime Name","Districts"]
["ALIQUOT ASSOCIATES",null,{"$f":"'[1]DPAC A&E Worksheet'!O7","v":1450000},"M",1,{"$f":"FETCHCOMMENT(E86)","v":"04A7117"},1,{"$f":"FETCHCOMMENT(G86)","v":"HDR Engineering, Inc."},4]
["AMC CONSULTING ENGINEERS INC",null,{"$f":"'[1]DPAC A&E Worksheet'!O18","v":1785000},"M",2,{"$f":"FETCHCOMMENT(E87)","v":"59A1324\n59A1325\n"},1,{"$f":"FETCHCOMMENT(G87)","v":"HDR CONSTRUCTION CONTROL CORPORATION"},59]
["ANALYZER INTERNATIONAL",null,{"$f":"'[1]DPAC A&E Worksheet'!O35","v":1836000},"M",3,{"$f":"FETCHCOMMENT(E88)","v":"59A1324\n59A1325\n12A2210"},2,{"$f":"FETCHCOMMENT(G88)","v":"HDR CONSTRUCTION CONTROL CORPORATION\nHDR Engineering, Inc."},"12,59"]
["ASSET LABORATORIES",null,{"$f":"'[1]DPAC A&E Worksheet'!K6","v":1342684.2},"F",2,{"$f":"FETCHCOMMENT(E89)","v":"03A3892\n07A6010"},2,{"$f":"FETCHCOMMENT(G89)","v":"GEOCON CONSULTANTS INC\nGEOSYNTEC CONSULTANTS"},"3,7"]
["C2PM",null,{"$f":"'[1]DPAC A&E Worksheet'!K20","v":500000},"F",1,{"$f":"FETCHCOMMENT(E90)","v":"11A3999"},1,{"$f":"FETCHCOMMENT(G90)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC."},11]
["CALIFORNIA BARRICADE INC",null,{"$f":"'[1]DPAC A&E Worksheet'!O40","v":160000},"M",1,{"$f":"FETCHCOMMENT(E91)","v":"07A6010"},1,{"$f":"FETCHCOMMENT(G91)","v":"GEOSYNTEC CONSULTANTS"},7]
["CHAUDHARY & ASSOCIATES",null,{"$f":"'[1]DPAC A&E Worksheet'!O48","v":1965918.4},"M",3,{"$f":"FETCHCOMMENT(E92)","v":"03A3789\n59A1330\n07A6010"},3,{"$f":"FETCHCOMMENT(G92)","v":"CHAUDHARY & ASSOCIATES\nTOWILL INC\nGEOSYNTEC CONSULTANTS"},"3,7,59"]
["CL SURVEYING AND MAPPING",null,{"$f":"'[1]DPAC A&E Worksheet'!O59","v":360000},"M",1,{"$f":"FETCHCOMMENT(E93)","v":"07A6087"},1,{"$f":"FETCHCOMMENT(G93)","v":"MICHAEL BAKER INTERNATIONAL INC"},7]
["DYNAMIC ENGINEERING SERVICES",null,{"$f":"'[1]DPAC A&E Worksheet'!K26","v":51000},"F",1,{"$f":"FETCHCOMMENT(E94)","v":"12A2210"},1,{"$f":"FETCHCOMMENT(G94)","v":"HDR Engineering, Inc."},12]
["GEOSPATIAL PROFESSIONAL",null,{"$f":"'[1]DPAC A&E Worksheet'!K31","v":960613.5},"F",1,{"$f":"FETCHCOMMENT(E95)","v":"59A1330"},1,{"$f":"FETCHCOMMENT(G95)","v":"TOWILL INC"},59]
["INTERPHASE ENVIRONMENTAL INC",null,{"$f":"'[1]DPAC A&E Worksheet'!K39","v":240000},"F",1,{"$f":"FETCHCOMMENT(E96)","v":"07A6010"},1,{"$f":"FETCHCOMMENT(G96)","v":"GEOSYNTEC CONSULTANTS"},7]
["KCM ENGINEERING, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!O76","v":4676098.4000000004},"M",6,{"$f":"FETCHCOMMENT(E97)","v":"59A1319\n59A1324\n59A1325\n59A1332\n03A3914\n59A1336"},5,{"$f":"FETCHCOMMENT(G97)","v":"PARSONS TRANSPORTATION GROUP, INC.\nHDR CONSTRUCTION CONTROL CORPORATION\nMNS ENGINEERS, INC.\nPSOMAS\nATLAS TECHNICAL CONSULTANTS"},"3,59"]
["MOZAMO ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!K57","v":8407434.5800000001},"F",7,{"$f":"FETCHCOMMENT(E98)","v":"59A1324\n59A1325\n59A1332\n59A1338\n03A3914\n06A3121\n59A1336"},5,{"$f":"FETCHCOMMENT(G98)","v":"HDR CONSTRUCTION CONTROL CORPORATION\nMNS ENGINEERS, INC.\nWSP USA ENVIRONMENT & INFRASTRUCTURE, INC.\nPSOMAS \nATLAS TECHNICAL CONSULTANTS"},"3,6,59"]
["PARK ENGINEERING, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!O82","v":669185.48},"M",1,{"$f":"FETCHCOMMENT(E99)","v":"59A1332"},1,{"$f":"FETCHCOMMENT(G99)","v":"MNS ENGINEERS, INC."},59]
["TRANSMAT",null,{"$f":"'[1]DPAC A&E Worksheet'!O97","v":10629716.289999999},"M",7,{"$f":"FETCHCOMMENT(E100)","v":"12A2206\n08A3792\n59A1338\n59A1336\n59A1337\n07A6088\n04A7232"},5,{"$f":"FETCHCOMMENT(G100)","v":"FOUNTAINHEAD CONSULTING\nKLEINFELDER, INC.\nWSP USA ENVIRONMENT & INFRASTRUCTURE, INC.\nATLAS TECHINICAL CONSULTANTS\nS2 ENGINEERING"},"4,7,8,12,59"]
["WEST KERN ENVIRONMENTAL",null,{"$f":"'[1]DPAC A&E Worksheet'!K74","v":595784.30000000005},"F",1,{"$f":"FETCHCOMMENT(E101)","v":"06A3116"},1,{"$f":"FETCHCOMMENT(G101)","v":"PARSONS TRANSPORTATION GROUP, INC."},6]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E102)","v":""},null,{"$f":"FETCHCOMMENT(G102)","v":""}]
[]
["Non Minority Men",null,"Dollars","M/F","# of Contracts","Contract #","# of Primes","Prime Name","Districts"]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E105)","v":""},null,{"$f":"FETCHCOMMENT(G105)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E106)","v":""},null,{"$f":"FETCHCOMMENT(G106)","v":""}]
[]
["Non Minority Women",null,"Dollars","M/F","# of Contracts","Contract #","# of Primes","Prime Name","Districts"]
["ALBAT",null,{"$f":"'[1]DPAC A&E Worksheet'!AU11","v":4205393.2},"F",4,{"$f":"FETCHCOMMENT(E109)","v":"11A3999\n59A1338\n03A3914\n59A1336"},4,{"$f":"FETCHCOMMENT(G109)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC.\nWSP USA ENVIRONMENT & INFRASTRUCTURE, INC.\nPSOMAS \nHDR CONSTRUCTION CONTROL "},"3,11,59"]
["ALBION ENVIRONMENTAL INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU16","v":896051.84},"F",1,{"$f":"FETCHCOMMENT(E110)","v":"06A3140"},1,{"$f":"FETCHCOMMENT(G110)","v":"FAR WESTERN ANTHROPOLOGICAL RESEARCH GROUP INC"},6]
["ALTA ARCHAEOLOGICAL CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!AU22","v":1680000},"F",1,{"$f":"FETCHCOMMENT(E111)","v":"04A7071"},1,{"$f":"FETCHCOMMENT(G111)","v":"KLEINFELDER, INC."},4]
["APPLIED TECHNOLOGY AND SCIENCE",null,{"$f":"'[1]DPAC A&E Worksheet'!AU27","v":1110000},"F",1,{"$f":"FETCHCOMMENT(E112)","v":"04A7044"},1,{"$f":"FETCHCOMMENT(G112)","v":"KLEINFELDER, INC."},4]
["ARCHAEO PALEO RESOURCES ",null,{"$f":"'[1]DPAC A&E Worksheet'!AU32","v":80000},"F",1,{"$f":"FETCHCOMMENT(E113)","v":"07A6010"},1,{"$f":"FETCHCOMMENT(G113)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["AREA WEST ENVIRONMENTAL",null,{"$f":"'[1]DPAC A&E Worksheet'!AU39","v":1794941.1600000001},"F",2,{"$f":"FETCHCOMMENT(E114)","v":"04A7106\n06A3116"},2,{"$f":"FETCHCOMMENT(G114)","v":"AECOM TECHNICAL SERVICES, INC.\nPARSONS TRANSPORTATION GROUP, INC."},"4,6"]
["AZAD ENGINEERING PC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU51","v":3427284.7199999997},"F",4,{"$f":"FETCHCOMMENT(E115)","v":"59A1319\n04A7117\n03A3914\n06A3121"},3,{"$f":"FETCHCOMMENT(G115)","v":"PARSONS TRANSPORTATION GROUP, INC.\nHDR ENGINEERING INC\nPSOMAS"},"3,4,6,59"]
["BANCROFT CONSTRUCTION SERVICES",null,{"$f":"'[1]DPAC A&E Worksheet'!AU56","v":335642.15},"F",1,{"$f":"FETCHCOMMENT(E116)","v":"09A1060"},1,{"$f":"FETCHCOMMENT(G116)","v":"RINCON"},9]
["BENNETT ENGINEERING SERVICES",null,{"$f":"'[1]DPAC A&E Worksheet'!AU64","v":1448968.95},"F",1,{"$f":"FETCHCOMMENT(E117)","v":"03A3928"},1,{"$f":"FETCHCOMMENT(G117)","v":"MARK THOMAS & COMPANY INC"},3]
["CONVEY, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!AU76","v":270000},"F",1,{"$f":"FETCHCOMMENT(E118)","v":"04A7106"},1,{"$f":"FETCHCOMMENT(G118)","v":"AECOM TECHNICAL SERVICES, INC."},4]
["CPM PARTNERS",null,{"$f":"'[1]DPAC A&E Worksheet'!AU71","v":600000},"F",1,{"$f":"FETCHCOMMENT(E119)","v":"11A3999"},1,{"$f":"FETCHCOMMENT(G119)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC."},11]
["CQMS CONSTRUCTION QUALITY",null,{"$f":"'[1]DPAC A&E Worksheet'!AU82","v":460000},"F",2,{"$f":"FETCHCOMMENT(E120)","v":"12A2203\n07A6009"},1,{"$f":"FETCHCOMMENT(G120)","v":"JACOBS PROJECT MANAGMENT"},"7,12"]
["DAVID J. POWERS & ASSOCIATES, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!AU87","v":1350000},"F",1,{"$f":"FETCHCOMMENT(E121)","v":"04A7106"},1,{"$f":"FETCHCOMMENT(G121)","v":"AECOM TECHNICAL SERVICES, INC."},4]
["EMPOWER ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AU94","v":1270571.18},"F",4,{"$f":"FETCHCOMMENT(E122)","v":"59A1324\n59A1325\n03A3914\n06A3121\n"},2,{"$f":"FETCHCOMMENT(G122)","v":"HDR CONSTRUCTION CONTROL CORPORATION\nPSOMAS"},"3,6,59"]
["FCG CONSULTANTS INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU103","v":270000},"F",1,{"$f":"FETCHCOMMENT(E123)","v":"12A2203"},1,{"$f":"FETCHCOMMENT(G123)","v":"JACOBS PROJECT MANAGMENT"},12]
["GALVIN PRESERVATION ASSOCIATES",null,{"$f":"'[1]DPAC A&E Worksheet'!AU109","v":870000},"F",1,{"$f":"FETCHCOMMENT(E124)","v":"04A7117"},1,{"$f":"FETCHCOMMENT(G124)","v":"HDR Engineering, Inc."},4]
["GATEWAY PACIFIC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU115","v":400000},"F",1,{"$f":"FETCHCOMMENT(E125)","v":"11A3999"},1,{"$f":"FETCHCOMMENT(G125)","v":"KLEINFELDER CONSTRUCTION SERVICES, INC."},11]
["INTEGRATED ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AU120","v":210000},"F",1,{"$f":"FETCHCOMMENT(E126)","v":"07A6009"},1,{"$f":"FETCHCOMMENT(G126)","v":"JACOBS PROJECT MANAGMENT"},7]
["KEISH ENVIRONMENTAL",null,{"$f":"'[1]DPAC A&E Worksheet'!AU126","v":540000},"F",1,{"$f":"FETCHCOMMENT(E127)","v":"04A7106"},1,{"$f":"FETCHCOMMENT(G127)","v":"AECOM TECHNICAL SERVICES, INC."},4]
["MERRIL MORRIS PARTNERS",null,{"$f":"'[1]DPAC A&E Worksheet'!AU133","v":460571.18},"F",1,{"$f":"FETCHCOMMENT(E128)","v":"06A3121\n"},1,{"$f":"FETCHCOMMENT(G128)","v":"HDR CONSTRUCTION CONTROL COMPANY"},6]
["MOUNTAINVIEW BIOLOGICAL",null,{"$f":"'[1]DPAC A&E Worksheet'!AU139","v":335642.15},"F",1,{"$f":"FETCHCOMMENT(E129)","v":"09A1060"},1,{"$f":"FETCHCOMMENT(G129)","v":"RINCON"},9]
["RUBICON ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AU150","v":240000},"F",1,{"$f":"FETCHCOMMENT(E130)","v":"07A6010"},1,{"$f":"FETCHCOMMENT(G130)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["TAIL WIND CONSTRUCTION SUPPLY ",null,{"$f":"'[1]DPAC A&E Worksheet'!AU158","v":300000},"F",1,{"$f":"FETCHCOMMENT(E131)","v":"03A3914"},1,{"$f":"FETCHCOMMENT(G131)","v":"PSOMAS"},3]
["Z&K CONSULTANTS, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!AU168","v":669185.48},"F",1,{"$f":"FETCHCOMMENT(E132)","v":"59A1332"},1,{"$f":"FETCHCOMMENT(G132)","v":"MNS ENGINEERS, INC."},59]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E133)","v":""},null,{"$f":"FETCHCOMMENT(G133)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E134)","v":""},null,{"$f":"FETCHCOMMENT(G134)","v":""}]
[]
[]
[]
["Prime Name",null,"# of Contracts","Contract #","Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #"]
["AECOM TECHNICAL SERVICES, INC.",null,1,{"$f":"FETCHCOMMENT(C139)","v":"04A7106"},"KLEINFELDER, INC.",6,{"$f":"FETCHCOMMENT(F139)","v":"04A7044\n11A3999\n04A7071\n08A3792\n59A1337\n07A6088"},"TRC ENGINEERS",1,{"$f":"FETCHCOMMENT(I139)","v":"07A6021"}]
["ATLAS TECHNICAL CONSULTANTS",null,1,{"$f":"FETCHCOMMENT(C140)","v":"59A1336"},"MARK  THOMAS & COMPANY",1,{"$f":"FETCHCOMMENT(F140)","v":"03A3928"},"WSP USA ENVIRONMENT & INFRASTRUCTURE, INC.",1,{"$f":"FETCHCOMMENT(I140)","v":"59A1338"}]
["CHAUDHARY & ASSOCIATES INC",null,1,{"$f":"FETCHCOMMENT(C141)","v":"03A3789"},"MICHAEL BAKER INTERNATIONAL INC",1,{"$f":"FETCHCOMMENT(F141)","v":"07A6087"}]
["FAR WESTERN ANTHROPOLOGICAL RESEARCH GROUP INC",null,1,{"$f":"FETCHCOMMENT(C142)","v":"06A3140"},"MNS ENGINEERS, INC.",1,{"$f":"FETCHCOMMENT(F142)","v":"59A1319\n06A3116\n12A2212\n59A1332"}]
["FOUNTAINHEAD CONSULTING CORPORATION",null,1,{"$f":"FETCHCOMMENT(C143)","v":"12A2206"},"NV5 INC",1,{"$f":"FETCHCOMMENT(F143)","v":"08A3848"}]
["GEOCON CONSULTANTS INC",null,1,{"$f":"FETCHCOMMENT(C144)","v":"03A3892"},"PARSONS TRANSPORTATION GROUP, INC.",3,{"$f":"FETCHCOMMENT(F144)","v":"59A1319\n06A3116\n12A2212"}]
["GEOSYNTEC CONSULTANTS",null,1,{"$f":"FETCHCOMMENT(C145)","v":"07A6010"},"PSOMAS",1,{"$f":"FETCHCOMMENT(F145)","v":"03A3914"}]
["HDR CONSTRUCTION CONTROL CORPORATION",null,3,{"$f":"FETCHCOMMENT(C146)","v":"59A1324\n59A1325\n06A3121\n"},"RINCON",1,{"$f":"FETCHCOMMENT(F146)","v":"09A1060"}]
["HDR ENGINEERING INC",null,2,{"$f":"FETCHCOMMENT(C147)","v":"04A7117\n12A2210"},"S2 ENGINEERING",1,{"$f":"FETCHCOMMENT(F147)","v":"04A7232"}]
["JACOBS PROJECT MANAGEMENT",null,3,{"$f":"FETCHCOMMENT(C148)","v":"12A2203\n07A6009\n07A6016"},"TOWILL INC",1,{"$f":"FETCHCOMMENT(F148)","v":"59A1330"}]
[]
["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"]