{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA CAA DPAC SEP 2020"],"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 CAA DPAC SEP 2020","index":0,"n_rows":176,"n_cols":9,"rows_kept":176,"cut":false,"hidden":false,"merged":[]}
["DEPARTMENT OF TRANSPORTATION - CALTRANS"]
["DBE Commitment at Award (CAA) on Federally Funded Major Construction Contracts - October 1, 2019 - September 30, 2020"]
[]
["Total Award Amount",null,"Total DBE Commitment Amount",null,null,"Total Prime Contracts Awarded"]
[276604139,null,{"$f":"SUM(B7:B19)","v":69029700.25999999},null,null,{"$f":"SUM(B161:B172,H161:H172,E161:E172)","v":54}]
["Groups","Commitment Dollars","Firms","Contracts","% of Contracts","% of DBE $","% of Total $"]
["Hispanic American Male",{"$f":"SUMIF(C28:C54,\"m\", B28:B54)","v":14978033.530000001},{"$f":"COUNTIF(C28:C54,\"M\")","v":20},{"$f":"SUMIF(C28:C54,\"M\",D28:D54)","v":55},{"$f":"D7/D20","v":0.26066350710900477},{"$f":"B7/C5","v":0.21697955334566599},{"$f":"B7/A5","v":5.4149708620231461E-2}]
["Hispanic American Female",{"$f":"SUMIF(C28:C54,\"F\", B28:B54)","v":1118940.3999999999},{"$f":"COUNTIF(C28:C54,\"F\")","v":6},{"$f":"SUMIF(C28:C54,\"F\",D28:D54)","v":10},{"$f":"D8/D20","v":4.7393364928909949E-2},{"$f":"B8/C5","v":1.6209550320883864E-2},{"$f":"B8/A5","v":4.045277138821122E-3}]
["African American Male",{"$f":"SUMIF(C61:C64,\"m\", B61:B64)","v":645600},{"$f":"COUNTIF(C62:C64,\"M\")","v":2},{"$f":"SUMIF(C62:C64,\"M\",D62:D64)","v":2},{"$f":"D9/D20","v":9.4786729857819912E-3},{"$f":"B9/C5","v":9.3524960642788705E-3},{"$f":"B9/A5","v":2.3340214731927783E-3}]
["African American Female",{"$f":"SUMIF(C61:C64,\"F\", B61:B64)","v":0},{"$f":"COUNTIF(C62:C64,\"F\")","v":0},{"$f":"SUMIF(C62:C64,\"F\",D62:D64)","v":0},{"$f":"D10/D20","v":0},{"$f":"B10/C5","v":0},{"$f":"B10/A5","v":0}]
["Asian Pacific Male",{"$f":"SUMIF(C80:C106,\"m\", B80:B106)","v":27625307.699999999},{"$f":"COUNTIF(C80:C106,\"M\")","v":21},{"$f":"SUMIF(C80:C106,\"M\",D80:D106)","v":39},{"$f":"D11/D20","v":0.18483412322274881},{"$f":"B11/C5","v":0.40019451911205506},{"$f":"B11/A5","v":9.9873081436427813E-2}]
["Asian Pacific Female",{"$f":"SUMIF(C80:C106,\"F\", B80:B106)","v":780742.3},{"$f":"COUNTIF(C80:C106,\"F\")","v":5},{"$f":"SUMIF(C80:C106,\"F\",D80:D106)","v":6},{"$f":"D12/D20","v":2.843601895734597E-2},{"$f":"B12/C5","v":1.1310237434891625E-2},{"$f":"B12/A5","v":2.8225980378406416E-3}]
["Subcontinent Asian Male",{"$f":"SUMIF(C67:C77,\"m\", B67:B77)","v":8198882.6799999997},{"$f":"COUNTIF(C67:C77,\"M\")","v":9},{"$f":"SUMIF(C67:C77,\"M\",D67:D77)","v":16},{"$f":"D13/D20","v":7.582938388625593E-2},{"$f":"B13/C5","v":0.11877326207587391},{"$f":"B13/A5","v":2.964121473250984E-2}]
["Subcontinent Asian Female",{"$f":"SUMIF(C67:C77,\"F\", B67:B77)","v":417500},{"$f":"COUNTIF(C67:C77,\"F\")","v":1},{"$f":"SUMIF(C67:C77,\"F\",D67:D77)","v":3},{"$f":"D14/D20","v":1.4218009478672985E-2},{"$f":"B14/C5","v":6.0481212931171443E-3},{"$f":"B14/A5","v":1.5093772692967547E-3}]
["Native American Male",{"$f":"SUMIF(C57:C58,\"m\", B57:B58)","v":0},{"$f":"COUNTIF(C57:C58,\"M\")","v":0},{"$f":"SUMIF(C57:C58,\"M\",D57:D58)","v":0},{"$f":"D15/D20","v":0},{"$f":"B15/C5","v":0},{"$f":"B15/A5","v":0}]
["Native American Female",{"$f":"SUMIF(C57:C58,\"F\", B57:B58)","v":0},{"$f":"COUNTIF(C57:C58,\"F\")","v":0},{"$f":"SUMIF(C57:C58,\"F\",D57:D58)","v":0},{"$f":"D16/D20","v":0},{"$f":"B16/C5","v":0},{"$f":"B16/A5","v":0}]
["Non Minority Women",{"$f":"SUMIF(C114:C155,\"F\", B114:B155)","v":15014693.649999999},{"$f":"COUNTIF(C114:C155,\"F\")","v":41},{"$f":"SUMIF(C114:C155,\"F\",D114:D155)","v":80},{"$f":"D17/D20","v":0.37914691943127959},{"$f":"B17/C5","v":0.21751063083639705},{"$f":"B17/A5","v":5.4282245031770829E-2}]
["Non Minority Men",{"$f":"SUMIF(C110:C111,\"M\", B110:B111)","v":250000},{"$f":"COUNTIF(C110:C111,\"F\")","v":0},{"$f":"SUMIF(C110:C111,\"F\",D110:D111)","v":0},{"$f":"D18/D20","v":0},{"$f":"B18/C5","v":3.6216295168366133E-3},{"$f":"B18/A5","v":9.0381872412979326E-4}]
[]
["Total  ",null,{"$f":"SUM(C7:C19)","v":105},{"$f":"SUM(D7:D19)","v":211}]
["Total Prime Contracts Awarded",{"$f":"SUM(B161:B172,E161:E172,H161:H172)","v":54}]
["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'!G14","v":1323365},"M",3,{"$f":"fetchcomment(D28)","v":"08A3114\n08A3164\n07A4765"},3,{"$f":"fetchcomment(F28)","v":"ICF JONES & STOKES\nEXP U.S. SERVICES INC\nTRANSYSTEMS CORPORATION"},"7,8"]
["ADVANCED TECHNOLOGY",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G25","v":580180},"M",6,{"$f":"fetchcomment(D29)","v":"09A0769\n04A5953\n12A1843\n07A4958\n07A4968\n08A3186"},3,{"$f":"fetchcomment(F29)","v":"GEOCON CONSULTANTS\nSTANTEC CONSULTING SERVICES INC\nGEOSYNTEC CONSULTANTS INC"},"4,7,8,9,12"]
["ARELLANO ASSOCIATES LLC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C13","v":337450},"F",2,"07A4811\n08A3114",2,"GPA CONSULTING\nICF JONES & STOKES","7,8"]
["BAINBRIDGE ENVIRONMENTAL",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G30","v":10695},"M",1,"08A3186",1,"STANTEC CONSULTING",8]
["CABRINHA HEARN & ASSOCIATES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G41","v":320590},"M",4,"07A4918\n12A1843\n08A3201\n08A3186",2,"STANTEC\nPSOMAS","7,8,12"]
["CADRE DESIGN GROUP",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G46","v":85128.84},"M",1,"03A3085",1,"MARK THOMAS & COMPANY",3]
["COAST SURVEYING INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G50","v":843800},"M",1,"12A1816",1,"PSOMAS",12]
["DIAZ CONSULTANTS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G61","v":93000},"M",2,"07A4758\n12A1843",2,"HNTB CORPORATION\nSTANTEC CONSULTING SERVICES","7,12"]
["DIEGO & SON PRINTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G56","v":16011.98},"M",1,"11A3018\n",1,"AECOM TECHNICAL SERVICES INC",11]
["EARTHVIEW SCIENCE",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C19","v":135000},"F",3,"03A3066\n03A3073\n03A3072",1,"STANTEC CONSULTING",3]
["ESTRADA LAND PLANNING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C25","v":56490.400000000001},"F",1,"03A3087",1,"DOKKEN ENGINEERING",3]
["FOUNTAINHEAD CONSULTING CORP",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G71","v":4744880.2},"M",5,"06A2588\n07A4906\n11A3056\n11A3099\n59A1110",4,"MNS ENGINEERS INC\nFOUNTAINHEAD CONSULTING\nKLEINFELDER CONSTRUCTION\nPRESCINCE CORPORATION","6,7,11,59"]
["FULL TRAFFIC MAINTENANCE",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G78","v":34390},"M",2,"12A1843\n08A3186",1,"STANTEC CONSULTING SERVICES INC","8,12"]
["LA SALLE SOLUTIONS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G86","v":737500},"M",4,"59A1095\n11A3027\n11A3056\n11A3099",2,"T R C ENGINEERS INC\nKLEINFELDER CONSTRUCTION","11,59"]
["MA ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G91","v":160000},"M",1,"07A4758",1,"HNTB CORPORATION",7]
["MARTINI DRILLING CORP",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G96","v":40000},"M",1,"07A4968",1,"GEOSYNTEC CONSULTANTS INC",7]
["MONTEZ GROUP INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G105","v":760600},"M",2,"04A5915\n11A3060",2,"HDR ENGINEERS INC\nARCADIS U.S. INC","4,11"]
["MTGL INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C36","v":450000},"F",2,"04A5786\n07A4764",1,"S2 ENGINEERING INC","4,7"]
["MUNDO ENVIRONMENTAL INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G110","v":23695},"M",2,"12A1843\n08A3186",1,"STANTEC CONSULTING INC","8,12"]
["R T ENGINEERING & ASSOCIATES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C48","v":120000},"F",1,"59A1095",1,"T R C ENGINEERS INC",59]
["RUZ CONSULTING ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G118","v":145412.42000000001},"M",1,"03A3008",1,"PSOMAS",3]
["SAFE2CORE",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!C55","v":20000},"F",1,"04A5953",1,"GEOCON CONSULTANTS",4]
["SOUTHSTAR ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G131","v":1192130},"M",5,"59A1095\n07A4906\n08A3164\n04A5910\n07A4929",4,"T R C ENGINEERS INC\nFOUNTAINHEAD CONSULTING\nEXP U.S. SERVICES INC\nPPM GROUP INC","4,7,8,59"]
["UNDER CONSTRUCTION",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G139","v":382492.3},"M",2,"06A2597\n11A3027",1,"T R C ENGINEERS INC","6,11"]
["UNICO ENGINEERING CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G155","v":1887522.7900000003},"M",7,"04A5823\n09A0769\n03A3008\n03A3041\n09A0788\n03A3087\n59A1103",7,"TRC ENGINEERS INC\nGEOCON CONSULTANTS\nPSOMAS\nGHIRARDELLI ASSOCIATES INC\nNV5 INC\nDOKKEN ENGINEERING \nHDR CONSTRUCITON CONTROL","3,4,9,59"]
["VSCE INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!G165","v":1596640},"M",4,"04A5823\n04A5915\n06A2596\n09A0788",3,"TRC ENGINEERS INC\nHDR ENGINEERS INC\nNV5 INC","4,6,9"]
[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"]
["ALLUVION BIOLOGICAL CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AE13","v":245000},"M",3,"03A3073\n03A3066\n03A3072",1,"STANTEC CONSULTING",3]
["SKS ENGINEERING INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AE25","v":40000},"M",1,"59A1095",1,"T R C ENGINEERS INC",59]
["TRINITY ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AE31","v":360600},"M",1,"11A3060",1,"ARCADIS U.S. INC",11]
[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'!AM14","v":2060000},"M",3,"07A4783\n07A4764\n59A1110",3,"JACOBS PROJECT MANAGEMENT\nS2 ENGINEERING INC\nPRESCIENCE CORPORATION","7, 59"]
["CHAUDHARY AND ASSOCIATES INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM22","v":4093640},"M",3,"04A5915\n06A2596\n04A5906",3,"HDR ENGINEERS INC\nNV5, INC\nCHAUDHARY & ASSOCIATES","4,6"]
["KAL KRISHNAN CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM43","v":177315},"M",1,"EXP E.S. SERVICES INC",1,"08A3164",8]
["EARTH MECHANICS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM28","v":160000},"M",1,"07A4765",1,"TRANSYSTEMS CORPORATION",7]
["ENVIRONMENTAL COST MANAGEMENT",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM33","v":90170},"M",2,"12A1843\n08A3186",1,"STANTECT CONSULTING SERVICES INC","8, 12"]
["IQON ENGINEERS INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM38","v":300000},"M",1,"07A4929",1,"PPM GROUP INC",7]
["REDDY ANTHROPOLOGY CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AI14","v":417500},"F",3,"07A4811\n11A3056\n11A3099",2,"GPA CONSULTING\nKLEINFELDER CONSTRUCTION","7,11"]
["S2 ENGINEERING ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM60","v":487500},"M",3,"04A5910\n11A3056\n11A3099",2,"EXP U.S. SERVICES INC\nKLEINFELDER CONSTRUCTION","4,11"]
["SUBSTRATE INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM66","v":660000},"M",1,"59A1110",1,"PRESCIENCE CORPORATION",59]
["T J K M ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AM70","v":170257.68},"M",1,"03A3085",1,"MARK THOMAS & COMPANY",3]
[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'!O10","v":232000},"M",2,"53A0241\n53A0237",2,"STANTON CONSTRUCTABILITY SERVICES\n1ST CHOICE DBE, INC",53]
["ALIQUOT ASSOCIATES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O16","v":500000},"M",1,"04A5906",1,"CHAUDHARY & ASSOICATES",4]
["ANALYZER INTERNATIONAL",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O26","v":350000},"M",1,"59A1103",1,"HDR CONSTRUCTION CONTROL",59]
["ASSET LABORATORIES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!K10","v":100000},"F",1,"04A5953",1,"GEOCON CONSUTANTS",4]
["AXIOM ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O33","v":359000},"M",1,"06A2593",1,"06A2593\n",6]
["COASTAL ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O39","v":372315},"M",2,"08A3164\n04A5910\n",1,"EXP US SERVICES INC","4,8"]
["FPL AND ASSOCIATES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O45","v":400000},"M",1,"07A4758",1,"HNTB CORPORATION",7]
["INTERPHASE ENVIRONEMTAL INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!K19","v":3250},"F",1,"12A1843",1,"STANTEC CONSULTING SERVICE INC",12]
["I D C CONSULTING ENGINEERS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!K14","v":270000},"F",1,"11A3027",1,"T R C ENGINEERS INC",11]
["INNOVEX ENVIRONMENTAL ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O57","v":250000},"M",1,"04A5950",1,"BROWN AND CALDWELL",4]
["GLOBALASR CONSULTING INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O50","v":55780},"M",2,"12A1843\n08A3186",1,"STANTEC CONSULTING SERVICES INC","8,12"]
["LINKALL CONSTRUCTION",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O61","v":360600},"M",1,"11A3060",1,"ARCADIS U.S. INC",11]
["LRS PROGRAM DELIVERY INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!K25","v":382492.3},"F",2,"06A2597\n11A3027",1,"T R C ENGINEERS INC","6,11"]
["MGE ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O67","v":895412.42},"M",3,{"$f":"fetchcomment(D93)","v":"03A3008\n04A5915\n59A1103"},2,{"$f":"fetchcomment(F93)","v":"PSOMAS\nHDR ENGINEERS INC"},"3,4,59"]
["PACRIM ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O71","v":240000},"M",1,"07A4758",1,"HNTB CORPORATION",7]
["PARIKH CONSULTANTS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O88","v":750000},"M",1,"04A5786",1,"S2 ENGINEERING INC",4]
["PARK ENGINEERING INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O81","v":762500},"M",3,"04A5823\n04A5915\n59A1103",2,"TRC ENGINEERS INC\nHDR ENGINEERS INC","4,59"]
["PENECORE DRILLING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O96","v":4950},"M",1,"09A0769",1,"GEOCON CONSULTANTS",9]
["PRESCIENCE CORPORATION",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O108","v":17174654.079999998},"M",5,"03A3008\n06A2588\n59A1096\n06A2593\n59A1110",4,"PSOMAS\nMNS ENGINEERS INC\nPRESCIENCE CORPORATION\nALTA VISTA ","3,6,59"]
["SAFEPROBE INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O113","v":80000},"M",1,"07A4765",1,"TRANSYSTEMS CORPORATION",7]
["SF BOAT SUPPORT LLC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!K32","v":25000},"F",1,"04A5950",1,"BROWN & CALDWELL",4]
["SUMMIT ASSOCIATES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O125","v":100000},"M",1,"04A5823",1,"TRC ENGINEERS INC",4]
["TATSUMI AND PARTNERS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O132","v":320000},"M",2,"07A4758\n07A4765",2,"HNTB CORPORATION\nTRANSYSTEMS CORPORATION",7]
["THE ALLIANCE GROUP",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O138","v":240000},"M",1,"07A4758",1,"HNTB CORPORATION",7]
["TRICERTUS LLC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O145","v":25000},"M",1,"53A0244",1,"HILL INTERNATIONAL INC",53]
["WRECO",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!O158","v":4153096.2},"M",7,"04A5818\n03A3066\n03A3085\n04A5950\n03A3073\n03A3087\n03A3072",5,"WRECO\nSTANTEC CONSULTING\nMARK THOMAS & COMPANY\nBROWN & CALDWELL\nDOKKEN ENGINEERING","3,4"]
[null,null,null,null,"",null,""]
[]
["Other","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
[null,null,null,null,"",null,""]
["ADH TECHNICAL SERVICES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AU8","v":250000},"M",1,"04A5950",1,"BROWN & CALDWELL",4]
[null,null,null,null,"",null,""]
[]
["Non Minority Women","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["A-TECH CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ5","v":26000},"F",1,"12A1843",1,"STANTEC CONSULTING SERVICE INC",3]
["APPL INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ11","v":80000},"F",2,"07A4958\n07A4968",1,"GEOSYNTEC CONSULTANTS INC",7]
["ARCHAEO PALEO RESOURCES ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ22","v":45825},"F",4,"09A0769\n04A5953\n07A4958\n07A4968",2,"GEOCON CONSULTANTS\nGEOSYNTEC CONSULTANTS INC","4,7,9"]
["AREA WEST ENVIRONMENTAL",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ32","v":525000},"F",3,"03A3066\n03A3073\n03A3072",1,"STANTEC CONSULTING",3]
["ARGONAUT ECOLOGICAL CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ38","v":145412.42000000001},"F",1,"03A3008",1,"PSOMAS",3]
["ARTEMIS ENVIRONMENTAL ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ47","v":48035.94},"F",1,"11A3018",1,"AECOM TECHNICAL SERVICES INC",11]
["AURORA INDUSTRIAL HYGIENE",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ52","v":90170},"F",2,"12A1843\n08A3186",1,"STANTEC CONSULTING SERVICES INC","8,12"]
["AZAD ENGINEERING PC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ60","v":312000},"F",2,"04A5823\n53A0237",2,"TRC ENGINEERS INC\n1ST CHOICE DBE INC","4,53"]
["BARRETT'S BIOLOGICAL SURVEYS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ68","v":8005.99},"F",1,"11A3018",1,"AECOM TECHNICAL SERVICES INC",11]
["BENNETT ENGINEERING SERVICES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ73","v":622967.36},"F",2,"03A3085\n03A3087",2,"MARK THOMAS & COMPANY\nDOKKEN ENGINEERING",3]
["CECILIA'S SAFETY SERVICE",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ78","v":13000},"F",1,"12A1843",1,"STANTEC CONSULTING INC",12]
["CITYWORKS PEOPLE + PLACES INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ90","v":48035.94},"F",1,"11A3018",1,"AECOM TECHNICAL SERVICES INC",11]
["CIVIL WORKS ENGINEERS",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ98","v":355350},"F",2,"08A3114\n07A4758",2,"ICF JONES & STOKES \nHNTB CORPORATION","7,8"]
["CONNECT & COMPANY LLC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ104","v":177315},"F",1,"08A3164",1,"EXP U.S. SERVICES INC",8]
["CURALIUM CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ113","v":135000},"F",3,"03A3066\n03A3073\n03A3072",1,"STANTEC CONSULTING",3]
["DILLARD ENVIRONMENTAL SERVICES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ118","v":40000},"F",2,"07A4958\n07A4968",1,"GEOSYNTEC CONSULTANTS INC",7]
["DP ENGINEERING TRANSPORTATION",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ125","v":85128.84},"F",1,"03A3073",1,"MARK THOMAS & COMPANY",3]
["FALCON ENGINEERING SERVICES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ131","v":1019760.4},"F",1,"06A2588",1,"MNS ENGINEERS INC",6]
["FCG CONSULTANTS INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ137","v":355446.48},"F",1,"03A3041",1,"GHIRARDELLI ASSOCIATES INC",3]
["GALVIN PRESERVATION ASSOCIATES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ143","v":130500},"F",3,"03A3073\n03A3072\n08A3182",2,"STANTEC CONSULTING\nSTATISTICAL RESEARCH INC\n","3, 8"]
["GATEWAY PACIFIC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ149","v":520000},"F",2,"11A3056\n11A3099",1,"KLEINFELDER CONSTRUCTION",11]
["GHIRARDELLI ASSOCIATES INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ160","v":4306081.01},"F",7,"59A1095\n06A2588\n59A1096\n03A3029\n06A2593\n06A2596\n09A0788",6,"T R C ENGINEERS INC\nMNS ENGINEERS INC\nPRESCIENCE CORPORATION\nBLACKBURN CONSULTING\nALTA VISTA \nNV5 INC","6,9,59"]
["GPA CONSULTING DBA GALVIN PRESERVATION ASSOCIATES",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ168","v":1680000},"F",1,"07A4811",1,"GPA CONSULTING",7]
["H & P MOBIL GEOCHEMISTRY",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ179","v":47390},"F",2,"12A1843\n08A3186",1,"STANTEC CONSULTING SERVICES INC","8,12"]
["HARRIS MILLER MILL & HANSON",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ185","v":50000},"F",1,"04A5950",1,"BROWN & CALDWELL",4]
["KIRSTIN SKADBERG",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ192","v":16011.98},"F",1,"11A3018",1,"AECOM TECHNICAL SERVICES INC",11]
["LYNN CAPOUYA INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ196","v":160000},"F",1,"07A4758",1,"HNTB CORPORATION",7]
["MONUMENT ROW INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ200","v":80000},"F",1,"07A4758",1,"HNTB CORPORATION",7]
["PACIFIC CREST ENGINEERING INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ209","v":254940.1},"F",1,"06A2588",1,"MNS ENGINEEERS INC",6]
["PALEO SOLUTIONS INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ223","v":172453.2},"F",3,"11A3009\n08A3114\n08A3182",3,"SAN DIEGO NATURAL HISTORY MUSEUM\nICF JONES & STOKES\nSTATISTICAL RESEARCH INC","8,11"]
["RUBICON ENGINEERING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ229","v":120000},"F",2,"07A4958\n07A4968",1,"GEOSYNTEC CONSULTANTS INC",7]
["SEQUOIA ECOLOGICAL CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ234","v":50000},"F",1,"03A3066",1,"STANTEC CONSULTING\n",3]
["SPRING RIVERS ECOLOGICAL",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ244","v":185000},"F",3,"03A3066\n03A3073\n03A3072",1,"STANTEC CONSULTING\n",3]
["STATISTICAL RESEARCH INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ254","v":1966500},"F",2,"07A4811\n08A3182",2,"GPA CONSULTING\nSTATISTICAL RESEARCH INC","7,8"]
["STEPHANIE REMINGTON",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ260","v":280008},"F",1,"08A3125",1,"ECORP CONSULTING",8]
["SWAIM BIOLOGICAL CONSULTING",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ270","v":260000},"F",3,"03A3066\n03A3073\n03A3072",1,"STANTEC CONSULTING\n",3]
["TRANSTERRA CONSULTING LLC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ276","v":135000},"F",3,"03A3066\n03A3073\n03A3072",1,"STANTEC CONSULTING\n",3]
["TRANSTRACK SYSTEMS INC",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ281","v":50000},"F",1,"03A3066",1,"STANTEC CONSULTING\n",3]
["VRPA TECHNOLOGIES ",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ288","v":8005.99},"F",1,"11A3018",1,"AECOM TECHNICAL SERVICES INC",11]
["WAGNER ENGINEERING & SURVEY",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ297","v":240000},"F",4,"07A4758\n07A4765\n07A4958\n07A4968",3,"HNTB CORPORATION \nTRANSYSTEMS CORPORATION\nGEOSYNTEC CONSULTANTS INC",7]
["WATEARTH",{"$f":"'[1]Commitment-DPAC-Minor B Alpha'!AQ307","v":170350},"F",4,"08A3114\n03A3066\n03A3073\n03A3072",2,"ICF JONES & STOKES \nSTANTEC CONSULTING","3,8"]
[null,null,null,null,""]
[{"$f":"COUNTIF(#REF!, \"33\")","v":{"$error":"#REF!"}}]
[]
[{"$f":"COUNTIF(#REF!, \"-4142\")","v":{"$error":"#REF!"}}]
["Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #"]
[]
["1ST CHOICE DBE INC",1,{"$f":"fetchcomment(B161)","v":"53A0237"},"GEOSYNTEC CONSULTANTS",2,{"$f":"fetchcomment(E161)","v":"07A4958\n07A4968"},"PARSONS TRANSPORTATION",1,{"$f":"fetchcomment(H161)","v":"59A1096"}]
["AECOM TECHNICAL SERVICES INC",1,{"$f":"fetchcomment(B162)","v":"11A3018\n"},"GHIRARDELLI ASSOCIATES INC",1,{"$f":"fetchcomment(E162)","v":"03A3041"},"PPM GROUP INC",1,{"$f":"fetchcomment(H162)","v":"07A4929"}]
["ALTA VISTA ",1,"06A2593","GPA CONSULTING",1,"07A4811\n","PRESCIENCE CORPORATION",2,"59A1096\n59A1110"]
["ARCADIS U.S. INC",1,"11A3060","HDR ENGINEERS INC",2,"04A5915\n59A1103","PSOMAS",3,"03A3008\n12A1816\n08A3201"]
["BLACKBURN CONSULTING",1,"03A3029","HILL INTERNATIONAL INC",1,"53A0244","S2 ENGINEERING INC",2,"04A5786\n07A4764"]
["BROWN & CALDWELL",1,"04A5950","HNTB CORPORATION",1,"07A4758","SAN DIEGO NATURAL HISTORY MUSEUM",1,"11A3009"]
["CHAUDHARY & ASSOCIATES",1,"04A5906","ICF JONES & STOKES",1,"08A3114","STANTEC",6,"07A4918\n03A3066\n03A3073\n03A3072\n12A1843\n08A3186"]
["DOKKEN ENGINEERING",1,"03A3087","JACOBS PROJECT MANAGEMENT",1,"07A4783\n","STANTON CONSTRUCTABILITY SERVICES ",1,"53A0241"]
["ECORP CONSULTING",1,"08A3125","KLEINFELDER CONSTRUCTION",2,"11A3056\n11A3099","STATISTICAL RESEARCH INC",1,"08A3182"]
["EXP U.S. SERVICES INC",2,"08A3164\n04A5910","MARK THOMAS & COMPANY",1,"03A3085","TRANSYSTEMS CORPORATION",1,"07A4765"]
["FOUNTAINHEAD CONSULTING",1,"07A4906","MNS ENGINEERS INC",1,"06A2588","TRC ENGINEERING INC",4,"04A5823\n59A1095\n06A2597\n11A3027"]
["GEOCON CONSULTANTS",2,"09A0769\n04A5953","NV5 INC",2,"06A2596\n09A0788","WRECO",1,"04A5818"]
[]
["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"]
["*These reports are subject to change, reports are generated from information available at the time of reporting."]