{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA DPAC AUG 2022 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 AUG 2022 CAA","index":0,"n_rows":164,"n_cols":10,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
["DEPARTMENT OF TRANSPORTATION - CALTRANS"]
["DBE Commitment at Award (CAA) on Federally Funded Major Construction Contracts - October 1, 2021 - August 31, 2022"]
[]
["Total Award Amount Year-to-Date (YTD)",null,"Total DBE Commitment Amount YTD",null,null,"Total Prime Contracts Awarded YTD"]
[273573500,null,{"$f":"SUM(C7:C18)","v":51147000},null,null,{"$f":"SUM(C149:C161,I149:I157,F149:F161)","v":42}]
["Groups",null," Commitment Dollars YTD","Firms YTD","Contracts YTD","% of Contracts","% of DBE $","% of Total $"]
["Hispanic American Male",null,{"$f":"SUMIF(D26:D52,\"m\", C26:C52)","v":12677890},{"$f":"COUNTIF(D26:D52,\"M\")","v":19},{"$f":"SUMIF(D26:D52,\"M\",E26:E52)","v":29},{"$f":"E7/E20","v":0.20422535211267606},{"$f":"C7/C5","v":0.24787162492423798},{"$f":"C7/A5","v":4.6341805767005945E-2}]
["Hispanic American Female",null,{"$f":"SUMIF(D26:D52,\"F\", C26:C52)","v":1783540},{"$f":"COUNTIF(D26:D52,\"F\")","v":7},{"$f":"SUMIF(D26:D52,\"F\",E26:E52)","v":9},{"$f":"E8/E20","v":6.3380281690140844E-2},{"$f":"C8/C5","v":3.4870862416172994E-2},{"$f":"C8/A5","v":6.5194179991848629E-3}]
["African American Male",null,{"$f":"SUMIF(D60:D64,\"m\", C60:C64)","v":216000},{"$f":"COUNTIF(D60:D64,\"M\")","v":3},{"$f":"SUMIF(D60:D64,\"M\",E60:E64)","v":3},{"$f":"E9/E20","v":2.1126760563380281E-2},{"$f":"C9/C5","v":4.2231215907091325E-3},{"$f":"C9/A5","v":7.8955015745311584E-4}]
["African American Female",null,{"$f":"SUMIF(D60:D64,\"F\", C60:C64)","v":320000},{"$f":"COUNTIF(D60:D64,\"F\")","v":1},{"$f":"SUMIF(D60:D64,\"F\",E60:E64)","v":1},{"$f":"E10/E20","v":7.0422535211267607E-3},{"$f":"C10/C5","v":6.2564764306801959E-3},{"$f":"C10/A5","v":1.1697039369675791E-3}]
["Asian Pacific Male",null,{"$f":"SUMIF(D79:D104,\"m\", C79:C104)","v":11227800},{"$f":"COUNTIF(D79:D104,\"M\")","v":21},{"$f":"SUMIF(D79:D104,\"M\",E79:E104)","v":31},{"$f":"E11/E20","v":0.21830985915492956},{"$f":"C11/C5","v":0.21952020646372222},{"$f":"C11/A5","v":4.1041255823389328E-2}]
["Asian Pacific Female",null,{"$f":"SUMIF(D79:D104,\"F\", C79:C104)","v":2400000},{"$f":"COUNTIF(D79:D104,\"F\")","v":3},{"$f":"SUMIF(D79:D104,\"F\",E79:E104)","v":5},{"$f":"E12/E20","v":3.5211267605633804E-2},{"$f":"C12/C5","v":4.6923573230101469E-2},{"$f":"C12/A5","v":8.7727795272568437E-3}]
["Subcontinent Asian Male",null,{"$f":"SUMIF(D67:D76,\"m\", C67:C76)","v":11614000},{"$f":"COUNTIF(D67:D76,\"M\")","v":8},{"$f":"SUMIF(D67:D76,\"M\",E67:E76)","v":18},{"$f":"E13/E20","v":0.12676056338028169},{"$f":"C13/C5","v":0.22707099145599938},{"$f":"C13/A5","v":4.2452942262317071E-2}]
["Subcontinent Asian Female",null,{"$f":"SUMIF(D67:D76,\"F\", C67:C76)","v":30000},{"$f":"COUNTIF(D67:D76,\"F\")","v":1},{"$f":"SUMIF(D67:D76,\"F\",E67:E76)","v":1},{"$f":"E14/E20","v":7.0422535211267607E-3},{"$f":"C14/C5","v":5.8654466537626845E-4},{"$f":"C14/A5","v":1.0965974409071054E-4}]
["Native American Male",null,{"$f":"SUMIF(D55:D57,\"m\", C55:C57)","v":15000},{"$f":"COUNTIF(D55:D57,\"M\")","v":1},{"$f":"SUMIF(D55:D57,\"M\",E55:E57)","v":1},{"$f":"E15/E20","v":7.0422535211267607E-3},{"$f":"C15/C5","v":2.9327233268813422E-4},{"$f":"C15/A5","v":5.4829872045355272E-5}]
["Native American Female",null,{"$f":"SUMIF(D55:D57,\"F\", C55:C57)","v":0},{"$f":"COUNTIF(D55:D57,\"F\")","v":0},{"$f":"SUMIF(D55:D57,\"F\",E55:E57)","v":0},{"$f":"E16/E20","v":0},{"$f":"C16/C5","v":0},{"$f":"C16/A5","v":0}]
["Non Minority Women",null,{"$f":"SUMIF(D111:D144,\"F\", C111:C144)","v":10772770},{"$f":"COUNTIF(D111:D144,\"F\")","v":33},{"$f":"SUMIF(D111:D144,\"F\",E111:E144)","v":43},{"$f":"E17/E20","v":0.30281690140845069},{"$f":"C17/C5","v":0.21062369249418345},{"$f":"C17/A5","v":3.9377973378269461E-2}]
["Non Minority Men",null,{"$f":"SUMIF(D107:D108,\"M\", C107:C108)","v":90000},{"$f":"COUNTIF(D107:D108,\"M\")","v":1},{"$f":"SUMIF(D107:D108,\"M\",E107:E108)","v":1},{"$f":"E18/E20","v":7.0422535211267607E-3},{"$f":"C18/C5","v":1.7596339961288051E-3},{"$f":"C18/A5","v":3.2897923227213162E-4}]
[]
["Total  ",null,null,{"$f":"SUM(D7:D19)","v":98},{"$f":"SUM(E7:E19)","v":142}]
["Total Prime Contracts Awarded",null,{"$f":"SUM(C149:C161,F149:F161,I149:I157)","v":42}]
["Red Italic = DBE firm as Prime"]
["BOLD = women"]
[]
["Hispanic American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["360PSM",null,{"$f":"'[1]DPAC Worksheet'!E8","v":150000},"F",1,{"$f":"fetchcomment(E26)","v":"59A1156\n"},1,{"$f":"fetchcomment(G26)","v":"DOKKEN ENGINEERING"},59]
["ACT CONSULTING ENGINEERS","SB",{"$f":"'[1]DPAC Worksheet'!K7","v":353950},"M",3,{"$f":"fetchcomment(E27)","v":"12A1924\n12A1946\n06A2758"},2,{"$f":"fetchcomment(G27)","v":"WSP USA INC\nICF JONES "},"6,12"]
["ADV-SOC INC",null,{"$f":"'[1]DPAC Worksheet'!K12","v":720000},"M",1,{"$f":"fetchcomment(E28)","v":"59A1189"},1,{"$f":"fetchcomment(G28)","v":"WOOD ENVIRONMENTAL"},59]
["ADVANCED TECHNOLOGY",null,{"$f":"'[1]DPAC Worksheet'!K22","v":180000},"M",1,{"$f":"fetchcomment(E29)","v":"07A5236"},1,{"$f":"fetchcomment(G29)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["APEX CIVIL ENGINEERING",null,{"$f":"'[1]DPAC Worksheet'!E21","v":200000},"F",1,{"$f":"fetchcomment(E30)","v":"59A1170"},1,{"$f":"fetchcomment(G30)","v":"TY LIN INTERNATIONAL"},59]
["ARELLANO ASSOCIATES","SB",{"$f":"'[1]DPAC Worksheet'!E38","v":348540},"F",3,{"$f":"fetchcomment(E31)","v":"07A5172\n51A0556\n12A1946"},2,{"$f":"fetchcomment(G31)","v":"HNTB CORPORATION\nKIMLEY HORN AND ASSOCIATES\nICF JONES "},"7,51,12"]
["BEST TESTLAB INC",null,{"$f":"'[1]DPAC Worksheet'!E54","v":240000},"F",1,{"$f":"fetchcomment(E32)","v":"04A6198"},1,{"$f":"fetchcomment(G32)","v":"AECOM"},4]
["CABRINHA HEARN & ",null,{"$f":"'[1]DPAC Worksheet'!K31","v":315000},"M",2,{"$f":"fetchcomment(E33)","v":""},1,{"$f":"fetchcomment(G33)","v":"STANTEC  CONSTRUCTION"},7]
["DIAZ CONSULTANTS",null,{"$f":"'[1]DPAC Worksheet'!K45","v":280000},"M",1,{"$f":"fetchcomment(E34)","v":"12A1924"},1,{"$f":"fetchcomment(G34)","v":"WSP USA INC"},12]
["DUKE CULTURAL RESOURCES",null,{"$f":"'[1]DPAC Worksheet'!K51","v":117900},"M",1,{"$f":"fetchcomment(E35)","v":"12A1946"},1,{"$f":"fetchcomment(G35)","v":"ICF JONES"},12]
["DYNAMIC PRECONSTRUCTION ",null,{"$f":"'[1]DPAC Worksheet'!K62","v":72000},"M",1,{"$f":"fetchcomment(E36)","v":"03A3408"},1,{"$f":"fetchcomment(G36)","v":"STANTON CONSTRUCTABILITY"},3]
["EARTHVIEW SCIENCE","SB",{"$f":"'[1]DPAC Worksheet'!E61","v":80000},"F",1,{"$f":"fetchcomment(E37)","v":"04A6198"},1,{"$f":"fetchcomment(G37)","v":"AECOM"},4]
["FOUNTAINHEAD CONSULTING",null,{"$f":"'[1]DPAC Worksheet'!K71","v":5656800},"M",2,{"$f":"fetchcomment(E38)","v":"07A5257\n08A3374"},2,{"$f":"fetchcomment(G38)","v":"FOUNTAINHEAD CONSULTING CORPORATION\nPPM GROUP INC"},"7, 8"]
["JLB TRAFFIC ENGINEERING",null,{"$f":"'[1]DPAC Worksheet'!K78","v":150000},"M",1,{"$f":"fetchcomment(E39)","v":"09A0884"},1,{"$f":"fetchcomment(G39)","v":"NCM ENGINEERING"},9]
["LA SALLE SOLUTIONS LLC",null,{"$f":"'[1]DPAC Worksheet'!K89","v":517240},"M",3,{"$f":"fetchcomment(E40)","v":"08A3374\n07A5297\n07A5308"},2,{"$f":"fetchcomment(G40)","v":"PPM GROUP INC\nWSP USA INC"},"7,8"]
["MARTINEZ GEOSPATIAL INC",null,{"$f":"'[1]DPAC Worksheet'!K109","v":480000},"M",1,{"$f":"fetchcomment(E41)","v":"59A1142"},1,{"$f":"fetchcomment(G41)","v":"TOWILL INC"},59]
["MARTINI DRILLING CORP",null,{"$f":"'[1]DPAC Worksheet'!K98","v":60000},"M",1,{"$f":"fetchcomment(E42)","v":"07A5236"},1,{"$f":"fetchcomment(G42)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["MC LEAN & SCHULTZ INC",null,{"$f":"'[1]DPAC Worksheet'!K116","v":300000},"M",1,{"$f":"fetchcomment(E43)","v":"59A1163"},1,{"$f":"fetchcomment(G43)","v":"AECOM"},59]
["MONTEZ GROUP INC","SB",{"$f":"'[1]DPAC Worksheet'!K128","v":990000},"M",2,{"$f":"fetchcomment(E44)","v":"59A1151\n59A1192"},2,{"$f":"fetchcomment(G44)","v":"HDR CONSTRUCTION CONTROL CORPORATION\nGHIRADELLI  ASSOCIATES"},59]
["MTGL INC","SB",{"$f":"'[1]DPAC Worksheet'!E69","v":690000},"F",1,{"$f":"fetchcomment(E45)","v":"08A3327"},1,{"$f":"fetchcomment(G45)","v":"SMITH-EMERY LABORATORIES INC"},8]
["PROCURA 360 GROUP LLC","SB",{"$f":"'[1]DPAC Worksheet'!K134","v":80000},"M",1,{"$f":"fetchcomment(E46)","v":"04A6198"},1,{"$f":"fetchcomment(G46)","v":"AECOM"},4]
["SIERRA GROUP",null,{"$f":"'[1]DPAC Worksheet'!E78","v":75000},"F",1,{"$f":"fetchcomment(E47)","v":"07A5349"},1,{"$f":"fetchcomment(G47)","v":"ECORP CONSULTING"},7]
["SJ CONSTRUCTION MANAGEMENT","SB",{"$f":"'[1]DPAC Worksheet'!K143","v":270000},"M",1,{"$f":"fetchcomment(E48)","v":"59A1151"},1,{"$f":"fetchcomment(G48)","v":"HDR CONSTRUCTION CONTROL CORPORATION"},59]
["UNICO ENGINEERING CONSULTING",null,{"$f":"'[1]DPAC Worksheet'!K153","v":1360000},"M",3,{"$f":"fetchcomment(E49)","v":"59A1156\n03A3405\n59A1192"},2,{"$f":"fetchcomment(G49)","v":"DOKKEN ENGINEERING\nGHIRARDELLI"},"3,59"]
["UNIFIED TRAFFIC SYSTEMS",null,{"$f":"'[1]DPAC Worksheet'!K164","v":60000},"M",1,{"$f":"fetchcomment(E50)","v":"07A5236"},1,{"$f":"fetchcomment(G50)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["VSCE INC","SB",{"$f":"'[1]DPAC Worksheet'!K178","v":715000},"M",2,{"$f":"fetchcomment(E51)","v":"09A0855\n59A1151"},2,{"$f":"fetchcomment(G51)","v":"NV5 INC\nHDR CONSTRUCTION CONTROL CORPORATION"},"9,59"]
[null,null,null,null,null,{"$f":"fetchcomment(E52)","v":""},null,{"$f":"fetchcomment(G52)","v":""}]
[]
["Native American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["FMF PANDION","SB",{"$f":"'[1]DPAC Worksheet'!AI7","v":15000},"M",1,{"$f":"fetchcomment(E55)","v":"07A5172"},1,{"$f":"fetchcomment(G55)","v":"HNTB CORPORATION"},7]
[null,null,null,null,null,{"$f":"fetchcomment(E56)","v":""},null,{"$f":"fetchcomment(G56)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E57)","v":""},null,{"$f":"fetchcomment(G57)","v":""}]
[]
["African American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ACTIVEWAYZ ENGINEERING INC","SB",{"$f":"'[1]DPAC Worksheet'!AU10","v":160000},"M",1,{"$f":"fetchcomment(E60)","v":"04A6198"},1,{"$f":"fetchcomment(G60)","v":"AECOM"},4]
["ELLE CONSULTANTS",null,{"$f":"'[1]DPAC Worksheet'!AO8","v":320000},"F",1,{"$f":"fetchcomment(E61)","v":"07A5246"},1,{"$f":"fetchcomment(G61)","v":"ELLE CONSULTANTS"},7]
["TERRY A HAYES ASSOCIATES INC","SB",{"$f":"'[1]DPAC Worksheet'!AU18","v":30000},"M",1,{"$f":"fetchcomment(E62)","v":"07A5172"},1,{"$f":"fetchcomment(G62)","v":"HNTB CORPORATION"},7]
["WILTEC",null,{"$f":"'[1]DPAC Worksheet'!AU27","v":26000},"M",1,{"$f":"fetchcomment(E63)","v":"12A1986"},1,{"$f":"fetchcomment(G63)","v":"CDM SMITH INC"},12]
[null,null,null,null,null,{"$f":"fetchcomment(E64)","v":""},null,{"$f":"fetchcomment(G64)","v":""}]
[]
["Sub Cont Asian",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["AMC INC",null,{"$f":"'[1]DPAC Worksheet'!BG14","v":3615000},"M",5,{"$f":"fetchcomment(E67)","v":"07A5257\n07A5297\n07A5308\n59A1184\n59A1185"},4,{"$f":"fetchcomment(G67)","v":"FOUNTAINHEAD CONSULTING CORPORATION\nWSP\nPRESCIENCE\nATLAS TECHNICAL"},"7,59"]
["CHAUDHARY & ASSOCIATES","SB",{"$f":"'[1]DPAC Worksheet'!BG29","v":3580000},"M",4,{"$f":"fetchcomment(E68)","v":"04A6213\n59A1142\n59A1152\n07A5353"},4,{"$f":"fetchcomment(G68)","v":"CHAUDHARY & ASSOCIATES INC\nTOWILL INC\nBROWN AND CALDWELL\nPSOMAS"},"4,7,59"]
["EARTH MECHANICS",null,{"$f":"'[1]DPAC Worksheet'!BG37","v":150000},"M",2,{"$f":"fetchcomment(E69)","v":"59A1163\n59A1156"},2,{"$f":"fetchcomment(G69)","v":"AECOM\nDOKKEN ENGINEERING"},59]
["IQON ENGINEERING INC",null,{"$f":"'[1]DPAC Worksheet'!BG45","v":300000},"M",2,{"$f":"fetchcomment(E70)","v":"07A5297\n07A5308"},1,{"$f":"fetchcomment(G70)","v":"WSP USA INC"},7]
["KAL KRISHNAN CONSULTING",null,{"$f":"'[1]DPAC Worksheet'!BG53","v":492000},"M",2,{"$f":"fetchcomment(E71)","v":"59A1181\n07A5308"},2,{"$f":"fetchcomment(G71)","v":"PARSONS TRANSPORTATION GROUP\nWSP USA INC"},"7,59"]
["POLYTECHINIQUE ENVIRONMENTAL",null,{"$f":"'[1]DPAC Worksheet'!BA9","v":30000},"F",1,{"$f":"fetchcomment(E72)","v":"07A5236"},1,{"$f":"fetchcomment(G72)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["S2 ENGINEERING",null,{"$f":"'[1]DPAC Worksheet'!BG62","v":2160000},"M",1,{"$f":"fetchcomment(E73)","v":"59A1189"},1,{"$f":"fetchcomment(G73)","v":"WOOD ENVIRONMENTAL"},59]
["SIERRA GEOTECH DBE",null,{"$f":"'[1]DPAC Worksheet'!BG73","v":1200000},"M",1,{"$f":"fetchcomment(E74)","v":"03A3405"},1,{"$f":"fetchcomment(G74)","v":"GHIRARDELLI  ASSOCIATES"},3]
["TJKM",null,{"$f":"'[1]DPAC Worksheet'!BG81","v":117000},"M",1,{"$f":"fetchcomment(E75)","v":"12A1986"},1,{"$f":"fetchcomment(G75)","v":"CDM SMITH INC"},12]
[null,null,null,null,null,{"$f":"fetchcomment(E76)","v":""},null,{"$f":"fetchcomment(G76)","v":""}]
[]
["Asian Pacific",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["1ST CHOICE DBE INC",null,{"$f":"'[1]DPAC Worksheet'!W6","v":80000},"M",1,{"$f":"fetchcomment(E79)","v":"04A6198"},1,{"$f":"fetchcomment(G79)","v":"AECOM"},4]
["ADVANTEC CONSULTING ENGINEERS","SB",{"$f":"'[1]DPAC Worksheet'!W13","v":705000},"M",2,{"$f":"fetchcomment(E80)","v":"12A1924\n11A3332"},2,{"$f":"fetchcomment(G80)","v":"WSP USA INC\nKIMLEY-HORN AND ASSOCIATES"},"11, 12"]
["ALIQUOT ASSOCIATES","SB",{"$f":"'[1]DPAC Worksheet'!W23","v":375000},"M",2,{"$f":"fetchcomment(E81)","v":"04A6213\n04A6221"},2,{"$f":"fetchcomment(G81)","v":"CHAUDHARY & ASSOCIATES INC\nWRECO"},4]
["ASSET LABORATORIES",null,{"$f":"'[1]DPAC Worksheet'!Q6","v":60000},"F",1,{"$f":"fetchcomment(E82)","v":"07A5236"},1,{"$f":"fetchcomment(G82)","v":"GEOSYNTEC CONSULTANTS INC"},7]
["AXIOM ENGINEERING",null,{"$f":"'[1]DPAC Worksheet'!W31","v":900000},"M",1,{"$f":"fetchcomment(E83)","v":"59A1185"},1,{"$f":"fetchcomment(G83)","v":"ATLAS TECHNICAL"},59]
["AYCE CONSULTING ENGINEERS INC","SB",{"$f":"'[1]DPAC Worksheet'!Q19","v":245000},"F",1,{"$f":"fetchcomment(E84)","v":"12A1924"},1,{"$f":"fetchcomment(G84)","v":"WSP USA INC"},12]
["BRYAN MORI BIOLOGICAL CONSULTING",null,{"$f":"'[1]DPAC Worksheet'!W39","v":50000},"M",1,{"$f":"fetchcomment(E85)","v":"06A2758"},1,{"$f":"fetchcomment(G85)","v":"ICF JONES AND SONS"},6]
["CL SURVEYING AND MAPPING",null,{"$f":"'[1]DPAC Worksheet'!W48","v":360000},"M",1,{"$f":"fetchcomment(E86)","v":"07A5357"},1,{"$f":"fetchcomment(G86)","v":"PSOMAS"},7]
["ELITE TRANSPORTATION GROUP  INC","SB",{"$f":"'[1]DPAC Worksheet'!W56","v":40000},"M",1,{"$f":"fetchcomment(E87)","v":"11A3332"},1,{"$f":"fetchcomment(G87)","v":"KIMLEY HORN AND ASSOCIATES"},11]
["KCM ENGINEERING",null,{"$f":"'[1]DPAC Worksheet'!W78","v":3660000},"M",4,{"$f":"fetchcomment(E88)","v":"59A1151\n59A1181\n03A3405\n59A1184"},4,{"$f":"fetchcomment(G88)","v":"HDR CINSTRUCTION CONTROL CORP\nPARSONS TRANSPORTATION GROUP\nGHIRARDELLI ASSOCIATES \nPRESCIENCE CORP"},"3,59"]
["LIN CONSULTING","SB",{"$f":"'[1]DPAC Worksheet'!W84","v":80000},"M",1,{"$f":"fetchcomment(E89)","v":"11A3332"},1,{"$f":"fetchcomment(G89)","v":"KIMLEY HORN AND ASSOCIATES"},11]
["MOZAMO ENGINEERING","SB",{"$f":"'[1]DPAC Worksheet'!Q31","v":2095000},"F",3,{"$f":"fetchcomment(E90)","v":"09A0855\n59A1184\n59A1185"},3,{"$f":"fetchcomment(G90)","v":"NV5 INC\nPRESCIENCE \nATLAS TECH"},"9,59"]
["OPAC CONSULTING ",null,{"$f":"'[1]DPAC Worksheet'!W91","v":600000},"M",2,{"$f":"fetchcomment(E91)","v":"59A1163\n59A1170"},2,{"$f":"fetchcomment(G91)","v":"AECOM\nTY LIN INTERNATIONAL"},59]
["PARIKH CONSULTANTS",null,{"$f":"'[1]DPAC Worksheet'!W96","v":150000},"M",1,{"$f":"fetchcomment(E92)","v":"59A1170"},1,{"$f":"fetchcomment(G92)","v":"TY LIN INTERNATIONAL"},59]
["PARK ENGINEERING","SB",{"$f":"'[1]DPAC Worksheet'!W103","v":1170000},"M",2,{"$f":"fetchcomment(E93)","v":"59A1151\n03A3405"},2,{"$f":"fetchcomment(G93)","v":"HDR CINSTRUCTION CONTROL CORP\nGHIRARDELLI ASSOCIATES"},"3,59"]
["PRESCIENCE CORPORATION",null,{"$f":"'[1]DPAC Worksheet'!W110","v":900000},"M",1,{"$f":"fetchcomment(E94)","v":"04A6234"},1,{"$f":"fetchcomment(G94)","v":"WSP USA INC"},4]
["RAIL SURVEYORS",null,{"$f":"'[1]DPAC Worksheet'!W117","v":300000},"M",1,{"$f":"fetchcomment(E95)","v":"04A6221"},1,{"$f":"fetchcomment(G95)","v":"WRECO"},4]
["SILICON TRANSPORTATION","SB",{"$f":"'[1]DPAC Worksheet'!W123","v":96000},"M",1,{"$f":"fetchcomment(E96)","v":"11A3332"},1,{"$f":"fetchcomment(G96)","v":"KIMLEY HORN AND ASSOCIATES"},11]
["TATSUMI AND PARTNERS","SB",{"$f":"'[1]DPAC Worksheet'!W130","v":54300},"M",2,{"$f":"fetchcomment(E97)","v":"07A5172\n12A1946"},2,{"$f":"fetchcomment(G97)","v":"HNTB CORPORATION\nICF JONES & STOKES"},"7,12"]
["TRANSMAT",null,{"$f":"'[1]DPAC Worksheet'!W135","v":180000},"M",1,{"$f":"fetchcomment(E98)","v":"59A1185"},1,{"$f":"fetchcomment(G98)","v":"ATLAS TECHNOLOGIES"},59]
["TRICERTUS LLC",null,{"$f":"'[1]DPAC Worksheet'!W147","v":967500},"M",3,{"$f":"fetchcomment(E99)","v":"03A3334\n03A3405\n04A6401"},2,{"$f":"fetchcomment(G99)","v":"KREBS CORPORATION\nGHIRARDELLI ASSOCIATES"},"3,4"]
["WRECO ",null,{"$f":"'[1]DPAC Worksheet'!W155","v":240000},"M",1,{"$f":"fetchcomment(E100)","v":"04A6198"},1,{"$f":"fetchcomment(G100)","v":"AECOM"},4]
["Y & C TRANSPORTATION CONSULTANTS",null,{"$f":"'[1]DPAC Worksheet'!W161","v":240000},"M",1,{"$f":"fetchcomment(E101)","v":"04A6198"},1,{"$f":"fetchcomment(G101)","v":"AECOM"},4]
["YEI ENGINEERS","SB",{"$f":"'[1]DPAC Worksheet'!W166","v":80000},"M",1,{"$f":"fetchcomment(E102)","v":"04A6198"},1,{"$f":"fetchcomment(G102)","v":"AECOM"},4]
[null,null,null,null,null,{"$f":"fetchcomment(E103)","v":""},null,{"$f":"fetchcomment(G103)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E104)","v":""},null,{"$f":"fetchcomment(G104)","v":""}]
[]
["Other",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ADH TECHNICAL SERVICES","SB",{"$f":"'[1]DPAC Worksheet'!BS7","v":90000},"M",1,{"$f":"fetchcomment(E107)","v":"59A1152"},1,{"$f":"fetchcomment(G107)","v":"BROWN AND CALDWELL"},59]
[null,null,null,null,null,{"$f":"fetchcomment(E108)","v":""},null,{"$f":"fetchcomment(G108)","v":""}]
[]
["Non Minority Women",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["AESCO INC","SB",{"$f":"'[1]DPAC Worksheet'!BM7","v":690000},"F",1,{"$f":"fetchcomment(E111)","v":"08A3327"},1,{"$f":"fetchcomment(G111)","v":"SMITH-EMERY LABORATORIES INC"},8]
["ALBAT",null,{"$f":"'[1]DPAC Worksheet'!BM13","v":1620000},"F",2,{"$f":"fetchcomment(E112)","v":"03A3405\n59A1189"},2,{"$f":"fetchcomment(G112)","v":"GHIRARDELLI ASSOCIATES\nWOOD ENVIRONMENTAL"},"3,59"]
["APPL INC",null,{"$f":"'[1]DPAC Worksheet'!BM30","v":90000},"F",1,{"$f":"fetchcomment(E113)","v":"07A5236"},1,{"$f":"fetchcomment(G113)","v":"GEOSYNTEC CONSULTING"},7]
["ARCHAEO PALEO RESOURCES",null,{"$f":"'[1]DPAC Worksheet'!BM40","v":30000},"F",1,{"$f":"fetchcomment(E114)","v":"07A5236"},1,{"$f":"fetchcomment(G114)","v":"GEOSYNTEC CONSULTING"},7]
["BENNETT ENGINEERING","SB",{"$f":"'[1]DPAC Worksheet'!BM58","v":535000},"F",2,{"$f":"fetchcomment(E115)","v":"59A1152\n09A0884"},2,{"$f":"fetchcomment(G115)","v":"BROWN AND CALDWELL\nNCM ENGINEERING"},"9,59"]
["BLUE LAKE CIVIL","SB",{"$f":"'[1]DPAC Worksheet'!BM47","v":451500},"F",3,{"$f":"fetchcomment(E116)","v":"11A3332\n03A3334\n04A6401"},2,{"$f":"fetchcomment(G116)","v":"KIMLEY HORN AND ASSOCIATES\nKREBS CORPORATION\n"},"3, 4,11"]
["BURNE ENGINEERING SERVICES INC",null,{"$f":"'[1]DPAC Worksheet'!BM64","v":350000},"F",1,{"$f":"fetchcomment(E117)","v":"59A1156"},1,{"$f":"fetchcomment(G117)","v":"DOKKEN ENGINEERING"},59]
["CIVIC EDGE CONSULTING LLC","SB",{"$f":"'[1]DPAC Worksheet'!BM76","v":80000},"F",1,{"$f":"fetchcomment(E118)","v":"04A6198"},1,{"$f":"fetchcomment(G118)","v":"AECOM"},4]
["COGSTONE RESOURCES MANAGEMENT",null,{"$f":"'[1]DPAC Worksheet'!BM83","v":195000},"F",1,{"$f":"fetchcomment(E119)","v":"07A5349"},1,{"$f":"fetchcomment(G119)","v":"ECORP CONSULTING"},7]
["COSTIN PUBLIC OUTREACH GROUP",null,{"$f":"'[1]DPAC Worksheet'!BM92","v":210000},"F",1,{"$f":"fetchcomment(E120)","v":"12A1924"},1,{"$f":"fetchcomment(G120)","v":"WSP USA INC"},12]
["DESTINATION ENTERPRISES",null,{"$f":"'[1]DPAC Worksheet'!BM97","v":900000},"F",1,{"$f":"fetchcomment(E121)","v":"03A3405"},1,{"$f":"fetchcomment(G121)","v":"GHIRARDELLI ASSOCIATES"},3]
["FALCON ENGINEERING SERVICES INC",null,{"$f":"'[1]DPAC Worksheet'!BM109","v":864000},"F",1,{"$f":"fetchcomment(E122)","v":"59A1181"},1,{"$f":"fetchcomment(G122)","v":"59A1181"},59]
["GALVIN PRESERVATION ASSOCIATES","SB",{"$f":"'[1]DPAC Worksheet'!BM124","v":485760},"F",4,{"$f":"fetchcomment(E123)","v":"07A5172\n12A1946\n12A1947\n06A2758"},3,{"$f":"fetchcomment(G123)","v":"HNTB CORPORATION\nICF JONES & STOKES\nLSA ASSOCIATES"},"6,7,12"]
["GATEWAY PACIFIC","SB",{"$f":"'[1]DPAC Worksheet'!BM129","v":256000},"F",1,{"$f":"fetchcomment(E124)","v":"11A3332"},1,{"$f":"fetchcomment(G124)","v":"KIMLEY HORN AND ASSOCIATES"},11]
["GEOWING MAPPING","SB",{"$f":"'[1]DPAC Worksheet'!BM139","v":400000},"F",1,{"$f":"fetchcomment(E125)","v":"59A1142"},1,{"$f":"fetchcomment(G125)","v":"TOWILL INC"},59]
["HARRIS MILLER MILL & HANSON INC",null,{"$f":"'[1]DPAC Worksheet'!BM145","v":58950},"F",1,{"$f":"fetchcomment(E126)","v":"12A1946"},1,{"$f":"fetchcomment(G126)","v":"ICF JONES & STOKES"},12]
["HAYGOOD & ASSOCIATES","SB",{"$f":"'[1]DPAC Worksheet'!BM158","v":160000},"F",1,{"$f":"fetchcomment(E127)","v":"04A6198"},1,{"$f":"fetchcomment(G127)","v":"AECOM"},4]
["LEWIS JONES","SB",{"$f":"'[1]DPAC Worksheet'!BM193","v":192000},"F",1,{"$f":"fetchcomment(E128)","v":"11A3332"},1,{"$f":"fetchcomment(G128)","v":"KIMLEY HORN AND ASSOCIATES"},11]
["MBI MEDIA","SB",{"$f":"'[1]DPAC Worksheet'!BM202","v":60000},"F",1,{"$f":"fetchcomment(E129)","v":"07A5172"},1,{"$f":"fetchcomment(G129)","v":"HNTB CORPORATION"},7]
["MONUMENT ROW INC",null,{"$f":"'[1]DPAC Worksheet'!BM211","v":214300},"F",2,{"$f":"fetchcomment(E130)","v":"12A1924\n12A1946"},2,{"$f":"fetchcomment(G130)","v":"WSP USA INC\nICF JONES & STOKES"},12]
["MOTHER EARTH ENGINEERING",null,{"$f":"'[1]DPAC Worksheet'!BM172","v":1200000},"F",1,{"$f":"fetchcomment(E131)","v":"03A3405"},1,{"$f":"fetchcomment(G131)","v":"GHIRARDELLI ASSOCIATES"},3]
["P R R INC",null,{"$f":"'[1]DPAC Worksheet'!BM219","v":209940},"F",1,{"$f":"fetchcomment(E132)","v":"51A0556"},1,{"$f":"fetchcomment(G132)","v":"KIMLEY HORN AND ASSOCIATES"},51]
["PACIFIC COAST ECOLOGY",null,{"$f":"'[1]DPAC Worksheet'!BM226","v":50000},"F",1,{"$f":"fetchcomment(E133)","v":"06A2758"},1,{"$f":"fetchcomment(G133)","v":"ICF JONES & SONS"},6]
["PALEO SOLUTIONS","SB",{"$f":"'[1]DPAC Worksheet'!BM241","v":30000},"F",1,{"$f":"fetchcomment(E134)","v":"07A5172"},1,{"$f":"fetchcomment(G134)","v":"HNTB CORPORATION"},7]
["RUBICON ENGINEERING",null,{"$f":"'[1]DPAC Worksheet'!BM249","v":60000},"F",1,{"$f":"fetchcomment(E135)","v":"07A5236"},1,{"$f":"fetchcomment(G135)","v":"GEOSYNTEC CONSULTING"},7]
["SAYLOR CONSULTING","SB",{"$f":"'[1]DPAC Worksheet'!BM262","v":90000},"F",1,{"$f":"fetchcomment(E136)","v":"59A1152"},1,{"$f":"fetchcomment(G136)","v":"BROWN AND CALDWELL"},59]
["SEQUOIA ECOLOGICAL CONSULTING",null,{"$f":"'[1]DPAC Worksheet'!BM269","v":100000},"F",1,{"$f":"fetchcomment(E137)","v":"06A2758"},1,{"$f":"fetchcomment(G137)","v":"ICF JONES & SONS"},6]
["TORREY PINES ENVIRONMENTAL",null,{"$f":"'[1]DPAC Worksheet'!BM278","v":100000},"F",1,{"$f":"fetchcomment(E138)","v":"06A2758"},1,{"$f":"fetchcomment(G138)","v":"ICF JONES & SONS"},6]
["TRI COUNTY DRILLING","SB",{"$f":"'[1]DPAC Worksheet'!BM289","v":225000},"F",1,{"$f":"fetchcomment(E139)","v":"59A1152"},1,{"$f":"fetchcomment(G139)","v":"BROWN AND CALDWELL"},59]
["VANDERMOST CONSULTING SERVICES",null,{"$f":"'[1]DPAC Worksheet'!BM310","v":294320},"F",1,{"$f":"fetchcomment(E140)","v":"12A1947"},1,{"$f":"fetchcomment(G140)","v":"LSA ASSOCIATES"},12]
["VRPA TECHNOLOGIES",null,{"$f":"'[1]DPAC Worksheet'!BM299","v":91000},"F",1,{"$f":"fetchcomment(E141)","v":"12A1986"},1,{"$f":"fetchcomment(G141)","v":"CDM SMITH INC"},12]
["WAGNER ENGINEERING","SB",{"$f":"'[1]DPAC Worksheet'!BM317","v":315000},"F",2,{"$f":"fetchcomment(E142)","v":"59A1152\n07A5326"},2,{"$f":"fetchcomment(G142)","v":"BROWN AND CALDWELL\nSTANTEC CONSULTING"},"7,59"]
["WATEARTH","SB",{"$f":"'[1]DPAC Worksheet'!BM329","v":165000},"F",2,{"$f":"fetchcomment(E143)","v":"07A5172\n04A6221"},2,{"$f":"fetchcomment(G143)","v":"HNTB CORPORATION\nWRECO\n"},"4,7"]
[null,null,null,null,null,{"$f":"fetchcomment(E144)","v":""}]
[]
[]
[]
["Prime Name",null,"# of Contracts","Contract #","Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #"]
["AECOM",null,2,{"$f":"fetchcomment(C149)","v":"04A6198\n59A1163"},"ICF JONES & STOKES INC",2,{"$f":"fetchcomment(F149)","v":"12A1946\n06A2758"},"SMITH-EMERY LABORATORIES",1,{"$f":"fetchcomment(I149)","v":"08A3327\n"}]
["ATLAS TECHNICAL CONSULTANTS LLC",null,1,{"$f":"fetchcomment(C150)","v":"59A1185"},"KIMELY HORN AND ASSOCIATES",2,{"$f":"fetchcomment(F150)","v":"11A3332\n51A0556"},"TOWILL",1,{"$f":"fetchcomment(I150)","v":"59A1142\n"}]
["BROWN AND CALDWELL",null,1,{"$f":"fetchcomment(C151)","v":"59A1152"},"KREBS CORPORATION",2,{"$f":"fetchcomment(F151)","v":"03A3334\n04A6401"},"WOOD ENVIRONMENTAL & INFRASTRUCTURE INC",1,{"$f":"fetchcomment(I151)","v":"59A1192"}]
["CDM SMITH INC",null,1,{"$f":"fetchcomment(C152)","v":"12A1986"},"LSA ASSOCIATES INC",1,{"$f":"fetchcomment(F152)","v":"12A1947"},"WRECO",1,{"$f":"fetchcomment(I152)","v":"04A6221"}]
["CHAUDHARY & ASSOCIATES INC",null,1,{"$f":"fetchcomment(C153)","v":"04A6213"},"NCM ENGINEERS",1,{"$f":"fetchcomment(F153)","v":"09A0884"},"WSP USA INC",4,{"$f":"fetchcomment(I153)","v":"04A6234\n12A1924\n07A5297\n07A5308\n"}]
["DOKKEN ENGINEERING",null,1,{"$f":"fetchcomment(C154)","v":"59A1156"},"NV5 INC",1,{"$f":"fetchcomment(F154)","v":"09A0855"},null,null,{"$f":"fetchcomment(I154)","v":""}]
["ECORP CONSULTING",null,1,{"$f":"fetchcomment(C155)","v":"07A5349"},"PARSONS TRANSPORTATION GROUP INC",2,{"$f":"fetchcomment(F155)","v":"11A3324\n59A1181"},null,null,{"$f":"fetchcomment(I155)","v":""}]
["ELLE CONSULTANTS",null,1,{"$f":"fetchcomment(C156)","v":"07A5246"},"PPM GROUP INC",1,{"$f":"fetchcomment(F156)","v":"08A3374"},null,null,{"$f":"fetchcomment(I156)","v":""}]
["FOUNTAINHEAD CONSULTING CORPORATION",null,1,{"$f":"fetchcomment(C157)","v":"07A5257"},"PRESCIENCE CORPORATION",1,{"$f":"fetchcomment(F157)","v":"59A1184"},null,null,{"$f":"fetchcomment(I157)","v":""}]
["GEOSYNTEC CONSULTANTS INC",null,1,{"$f":"fetchcomment(C158)","v":"07A5236"},"PSOMAS ",2,{"$f":"fetchcomment(F158)","v":"07A5353\n07A5357"},null,null,{"$f":"fetchcomment(I158)","v":""}]
["GHIRARDELLI ASSOCIATES INC",null,2,{"$f":"fetchcomment(C159)","v":"03A3405\n59A1192"},"STANTEC CONSULTING SERVICES INC",1,{"$f":"fetchcomment(F159)","v":"07A5326"},null,null,{"$f":"fetchcomment(I159)","v":""}]
["HDR CONSTRUCTION CONTROL CORPORATION",null,1,{"$f":"fetchcomment(C160)","v":"59A1151"},"STANTON CONSTRUCTABILITY",2,{"$f":"fetchcomment(F160)","v":"03A3408\n11A3412"},null,null,{"$f":"fetchcomment(I160)","v":""}]
["HNTB CORPORATION",null,1,{"$f":"fetchcomment(C161)","v":"07A5172"},"TY LIN INTERNATIONAL",1,{"$f":"fetchcomment(F161)","v":"59A1170"},null,null,{"$f":"fetchcomment(I161)","v":""}]
[]
["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"]