{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA DPAC MAY 2024 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 MAY 2024 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, 2023 - May 31, 2024"]
[]
["Total Award Amount Year-to-Date (YTD)",null,"Total DBE Commitment Amount YTD",null,null,"Total Prime Contracts Awarded YTD"]
[396121192,null,{"$f":"SUM(C7:C18)","v":85464172.950000018},null,null,{"$f":"SUM(C141:C148,I141:I148,F141:F148)","v":30}]
["Groups ",null," Commitment Dollars YTD","Firms YTD","Contracts YTD","% of Contracts","% of DBE $","% of Total $"]
["Hispanic American Male",null,{"$f":"SUMIF(D26:D48,\"m\", C26:C48)","v":21857445.820000004},{"$f":"COUNTIF(D26:D48,\"M\")","v":18},{"$f":"SUMIF(D26:D48,\"M\",E26:E48)","v":29},{"$f":"E7/E20","v":0.20714285714285716},{"$f":"C7/C5","v":0.25574980796675456},{"$f":"C7/A5","v":5.517868334597964E-2}]
["Hispanic American Female",null,{"$f":"SUMIF(D26:D48,\"F\", C26:C48)","v":2090504.71},{"$f":"COUNTIF(D26:D48,\"F\")","v":4},{"$f":"SUMIF(D26:D48,\"F\",E26:E48)","v":6},{"$f":"E8/E20","v":4.2857142857142858E-2},{"$f":"C8/C5","v":2.4460597205135645E-2},{"$f":"C8/A5","v":5.2774371889701879E-3}]
["African American Male",null,{"$f":"SUMIF(D56:D61,\"m\", C56:C61)","v":1472895.1099999999},{"$f":"COUNTIF(D56:D61,\"M\")","v":4},{"$f":"SUMIF(D56:D61,\"M\",E56:E61)","v":4},{"$f":"E9/E20","v":2.8571428571428571E-2},{"$f":"C9/C5","v":1.7234064979037508E-2},{"$f":"C9/A5","v":3.7182941477162876E-3}]
["African American Female",null,{"$f":"SUMIF(D56:D61,\"F\", C56:C61)","v":80000},{"$f":"COUNTIF(D56:D61,\"F\")","v":1},{"$f":"SUMIF(D56:D61,\"F\",E56:E61)","v":1},{"$f":"E10/E20","v":7.1428571428571426E-3},{"$f":"C10/C5","v":9.3606475366939102E-4},{"$f":"C10/A5","v":2.0195839459152189E-4}]
["Asian Pacific Male",null,{"$f":"SUMIF(D76:D104,\"m\", C76:C104)","v":22140589.82},{"$f":"COUNTIF(D76:D104,\"M\")","v":21},{"$f":"SUMIF(D76:D104,\"M\",E76:E104)","v":37},{"$f":"E11/E20","v":0.26428571428571429},{"$f":"C11/C5","v":0.2590628219494166},{"$f":"C11/A5","v":5.5893474691957407E-2}]
["Asian Pacific Female",null,{"$f":"SUMIF(D76:D104,\"F\", C76:C104)","v":8655545.879999999},{"$f":"COUNTIF(D76:D104,\"F\")","v":7},{"$f":"SUMIF(D76:D104,\"F\",E76:E104)","v":11},{"$f":"E12/E20","v":7.857142857142857E-2},{"$f":"C12/C5","v":0.10127689277545389},{"$f":"C12/A5","v":2.1850751877975767E-2}]
["Subcontinent Asian Male",null,{"$f":"SUMIF(D64:D73,\"m\", C64:C73)","v":13620398.649999999},{"$f":"COUNTIF(D64:D73,\"M\")","v":8},{"$f":"SUMIF(D64:D73,\"M\",E64:E73)","v":15},{"$f":"E13/E20","v":0.10714285714285714},{"$f":"C13/C5","v":0.15936968883988945},{"$f":"C13/A5","v":3.4384423063131643E-2}]
["Subcontinent Asian Female",null,{"$f":"SUMIF(D64:D73,\"F\", C64:C73)","v":585000},{"$f":"COUNTIF(D64:D73,\"F\")","v":1},{"$f":"SUMIF(D64:D73,\"F\",E64:E73)","v":1},{"$f":"E14/E20","v":7.1428571428571426E-3},{"$f":"C14/C5","v":6.8449735112074217E-3},{"$f":"C14/A5","v":1.4768207604505038E-3}]
["Native American Male",null,{"$f":"SUMIF(D51:D53,\"m\", C51:C53)","v":240000},{"$f":"COUNTIF(D51:D52,\"M\")","v":1},{"$f":"SUMIF(D51:D52,\"M\",E51:E52)","v":1},{"$f":"E15/E20","v":7.1428571428571426E-3},{"$f":"C15/C5","v":2.8081942610081729E-3},{"$f":"C15/A5","v":6.0587518377456563E-4}]
["Native American Female",null,{"$f":"SUMIF(D51:D53,\"F\", C51:C53)","v":180000.01},{"$f":"COUNTIF(D51:D52,\"F\")","v":1},{"$f":"SUMIF(D51:D52,\"F\",E51:E52)","v":2},{"$f":"E16/E20","v":1.4285714285714285E-2},{"$f":"C16/C5","v":2.1061458127642242E-3},{"$f":"C16/A5","v":4.5440641307572356E-4}]
["Non Minority Women",null,{"$f":"SUMIF(D111:D136,\"F\", C111:C136)","v":14541792.950000001},{"$f":"COUNTIF(D111:D136,\"F\")","v":24},{"$f":"SUMIF(D111:D136,\"F\",E111:E136)","v":33},{"$f":"E17/E20","v":0.23571428571428571},{"$f":"C17/C5","v":0.17015074794566298},{"$f":"C17/A5","v":3.6710464483303888E-2}]
["Non Minority Men",null,{"$f":"SUMIF(D107:D108,\"M\", C107:C108)","v":0},{"$f":"COUNTIF(D107:D108,\"M\")","v":0},{"$f":"SUMIF(D107:D108,\"M\",E107:E108)","v":0},{"$f":"E18/E20","v":0},{"$f":"C18/C5","v":0},{"$f":"C18/A5","v":0}]
[]
["Total  ",null,{"$f":"SUM(C7:C18)","v":85464172.950000018},{"$f":"SUM(D7:D19)","v":90},{"$f":"SUM(E7:E19)","v":140}]
["Total Prime Contracts Awarded",null,{"$f":"SUM(C141:C148,F141:F148,I141:I148)","v":30}]
["Red Italic = DBE firm as Prime"]
["BOLD = women"]
[]
["Hispanic American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ACT CONSULTING ENGINEERS ",null,1350000,"M",1,{"$f":"FETCHCOMMENT(E26)","v":"08A3639"},1,{"$f":"FETCHCOMMENT(G26)","v":"TranSystems Corporation"},8]
["BARGAS ENVIRONMENTAL",null,300003.76,"F",1,{"$f":"FETCHCOMMENT(E27)","v":"03A3681\n"},1,{"$f":"FETCHCOMMENT(G27)","v":"ICF Jones & Stokes, Inc.\n"},3]
["CABRINHA HEARN & ASSOCIATES",null,110000,"M",1,{"$f":"FETCHCOMMENT(E28)","v":"07A5738"},1,{"$f":"FETCHCOMMENT(G28)","v":"STANTEC CONSULTING SERVICES INC"},7]
["D'LEON CONSULTING",null,350000,"M",1,{"$f":"FETCHCOMMENT(E29)","v":"07A5766"},1,{"$f":"FETCHCOMMENT(G29)","v":"Michael Baker International, Inc."},7]
["DEAN RYAN CONSULTANTS & DESIGNERS, INC.",null,1495500,"F",2,{"$f":"FETCHCOMMENT(E30)","v":"07A5768\n59A1270"},2,{"$f":"FETCHCOMMENT(G30)","v":"DEAN RYAN CONSULTANTS & DESIGNERS, INC.\nFUGRO"},"7,59"]
["EARTHVIEW SCIENCE",null,75000.94,"F",1,{"$f":"FETCHCOMMENT(E31)","v":"03A3681"},1,{"$f":"FETCHCOMMENT(G31)","v":"ICF Jones & Stokes, Inc."},3]
["FILIPPIN ENGINEERING INC",null,585000,"M",1,{"$f":"FETCHCOMMENT(E32)","v":"07A5729"},1,{"$f":"FETCHCOMMENT(G32)","v":"NV5 INC"},7]
["FOUNTAINHEAD CONSULTING CORP",null,3297267.0999999996,"M",2,{"$f":"FETCHCOMMENT(E33)","v":"11A3661\n0612971\n"},2,{"$f":"FETCHCOMMENT(G33)","v":"Kleinfelder Construction Services, Inc.\nMS ENGINEERS"},"6,11"]
["FULL TRAFFIC SAFETY",null,120000,"M",1,{"$f":"FETCHCOMMENT(E34)","v":"59A1270"},1,{"$f":"FETCHCOMMENT(G34)","v":"FUGRO"},59]
["JM DIAZ, INC.",null,350000,"M",1,{"$f":"FETCHCOMMENT(E35)","v":"07A5766"},1,{"$f":"FETCHCOMMENT(G35)","v":"Michael Baker International, Inc."},7]
["KINGFISHER BIO, INC.",null,75000.94,"M",1,{"$f":"FETCHCOMMENT(E36)","v":"03A3681"},1,{"$f":"FETCHCOMMENT(G36)","v":"ICF Jones & Stokes, Inc."},3]
["LA SALLE SOLUTIONS",null,1800164.6,"M",2,{"$f":"FETCHCOMMENT(E37)","v":"11A3661\n08A3604"},2,{"$f":"FETCHCOMMENT(G37)","v":"Kleinfelder Construction Services, Inc.\nBureau Veritas North America, Inc."},"8,11"]
["MA ENGINEERING",null,870000,"M",2,{"$f":"FETCHCOMMENT(E38)","v":"07A5766\n53A0282"},2,{"$f":"FETCHCOMMENT(G38)","v":"Michael Baker International, Inc.\nVALUE MANAGEMENT STRATEGIES INC"},"7,53"]
["RIVER FOCUS",null,100000.01,"M",1,{"$f":"FETCHCOMMENT(E39)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G39)","v":"HDR Engineering, Inc."},4]
["SAMA CONSTRUCTION",null,1667895.1,"M",3,{"$f":"FETCHCOMMENT(E40)","v":"59A1258\n08A3604\n06A2975"},2,{"$f":"FETCHCOMMENT(G40)","v":"Bureau Veritas North America, Inc.\nNV5 INC"},"6,8,59"]
["SIX RIVERS GEOSCIENCES",null,220000.01,"F",2,{"$f":"FETCHCOMMENT(E41)","v":"04A6813\n59A1270"},2,{"$f":"FETCHCOMMENT(G41)","v":"HDR Engineering, Inc.\nFUGRO"},"4,59"]
["SYRUSA ENGINEERING INC",null,4112856.97,"M",4,{"$f":"FETCHCOMMENT(E42)","v":"59A1258\n09A0964\n06A2975\n07A5729"},2,{"$f":"FETCHCOMMENT(G42)","v":"Bureau Veritas North America, Inc.\nNV5 INC"},"6,7,9,59"]
["TRIDENT CPM CONSULTING",null,100000,"M",1,{"$f":"FETCHCOMMENT(E43)","v":"07A5677"},1,{"$f":"FETCHCOMMENT(G43)","v":"ARCADIS INC"},7]
["UNICO ENGINEERING CONSULTING",null,2820679.95,"M",3,{"$f":"FETCHCOMMENT(E44)","v":"09A0964\n06A2975\n09A0983"},1,{"$f":"FETCHCOMMENT(G44)","v":"NV5 INC"},"6,9"]
["VALLE & ASSOCIATES CIVIL",null,739296.3,"M",1,{"$f":"FETCHCOMMENT(E45)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G45)","v":"MS ENGINEERING INC"},6]
["VSCE INC",null,2239284.85,"M",2,{"$f":"FETCHCOMMENT(E46)","v":"09A0964\n06A2975"},1,{"$f":"FETCHCOMMENT(G46)","v":"NV5 INC"},"6,9"]
["VST ENGINEERING, INC.",null,1170000,"M",1,{"$f":"FETCHCOMMENT(E47)","v":"04A6909"},1,{"$f":"FETCHCOMMENT(G47)","v":"WSP USA, Inc."},4]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E48)","v":""},null,{"$f":"FETCHCOMMENT(G48)","v":""}]
[]
["Native American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["GERONIMO ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!W17","v":180000.01},"F",2,{"$f":"FETCHCOMMENT(E51)","v":"04A6813\n04A6823"},2,{"$f":"FETCHCOMMENT(G51)","v":"HDR Engineering, Inc.\nBROWN AND CALDWELL"},4]
["GREGG DRILLING LLC",null,{"$f":"'[1]DPAC A&E Worksheet'!W25","v":240000},"M",1,{"$f":"FETCHCOMMENT(E52)","v":"59A1270"},1,{"$f":"FETCHCOMMENT(G52)","v":"FUGRO"},59]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E53)","v":""},null,{"$f":"FETCHCOMMENT(G53)","v":""}]
[]
["African American",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ACTIVEWAYZ ENGINEERING, INC",null,100000.01,"M",1,{"$f":"FETCHCOMMENT(E56)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G56)","v":"HDR Engineering, Inc."},4]
["ACUMEN BUILDING",null,267895.09999999998,"M",1,{"$f":"FETCHCOMMENT(E57)","v":"06A2975"},1,{"$f":"FETCHCOMMENT(G57)","v":"NV5 INC"},6]
["LUSTER NATIONAL",null,585000,"M",1,{"$f":"FETCHCOMMENT(E58)","v":"04A6909"},1,{"$f":"FETCHCOMMENT(G58)","v":"WSP USA, Inc."},4]
["O2EPCM INC",null,80000,"F",1,{"$f":"FETCHCOMMENT(E59)","v":"07A5677"},1,{"$f":"FETCHCOMMENT(G59)","v":"ARCADIS INC"},7]
["VIRTEK COMPANY",null,520000,"M",1,{"$f":"FETCHCOMMENT(E60)","v":"53A0282"},1,{"$f":"FETCHCOMMENT(G60)","v":"VALUE MANAGEMENT STRATEDIES INC"},53]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E61)","v":""},null,{"$f":"FETCHCOMMENT(G61)","v":""}]
[]
["Sub Cont Asian",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["AMC INC",null,4020000,"M",3,{"$f":"FETCHCOMMENT(E64)","v":"59A1258\n07A5677\n08A3604"},2,{"$f":"FETCHCOMMENT(G64)","v":"ARCADIS INC\nBureau Veritas North America, Inc."},"7,8,59"]
["EARTH MECHANICS ",null,875000,"M",3,{"$f":"FETCHCOMMENT(E65)","v":"08A3639\n07A5782\n59A1270"},2,{"$f":"FETCHCOMMENT(G65)","v":"TranSystems Corporation\nFUGRO"},"7,8,59"]
["FULCRUM CONSULTANTS INC",null,739296.3,"M",1,{"$f":"FETCHCOMMENT(E66)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G66)","v":"MS ENGINEERS INC"},6]
["GRIT FORCE INC",null,1428233.3,"M",1,{"$f":"FETCHCOMMENT(E67)","v":"06A2969"},1,{"$f":"FETCHCOMMENT(G67)","v":"ATLAS TECHNICAL CONSULTANTS INC"},6]
["PBS ENGINEERS, INC.",null,1590000,"M",1,{"$f":"FETCHCOMMENT(E68)","v":"59A1268"},1,{"$f":"FETCHCOMMENT(G68)","v":"Gannett Fleming, Inc."},59]
["REDDY ENGINEERING",null,1070164.6000000001,"M",2,{"$f":"FETCHCOMMENT(E69)","v":"11A3661\n11A3767"},2,{"$f":"FETCHCOMMENT(G69)","v":"Kleinfelder Construction Services, Inc.\nKimley-Horn and Associates, Inc."},11]
["S2 ENGINEERING",null,3312704.45,"M",3,{"$f":"FETCHCOMMENT(E70)","v":"09A0964\n06A2975\n07A5729"},1,{"$f":"FETCHCOMMENT(G70)","v":"NV5 INC"},"6,7,9"]
["SPS ENGINEERS",null,585000,"M",1,{"$f":"FETCHCOMMENT(E71)","v":"04A6909"},1,{"$f":"FETCHCOMMENT(G71)","v":"WSP USA, Inc."},4]
["SKYLINE CONSULTANTS",null,585000,"F",1,{"$f":"FETCHCOMMENT(E72)","v":"07A5729"},1,{"$f":"FETCHCOMMENT(G72)","v":"NV5 INC"},7]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E73)","v":""},null,{"$f":"FETCHCOMMENT(G73)","v":""}]
[]
["Asian Pacific",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ADVANTEC CONSULTING ENGINEERS ",null,2611314.2000000002,"M",4,{"$f":"FETCHCOMMENT(E76)","v":"08A3639\n09A0976\n07A5782\n04A6800"},2,{"$f":"FETCHCOMMENT(G76)","v":"TranSystems Corporation\nParsons"},"4,7,8,9"]
["AEW ENGINEERING INC",null,160000,"M",1,{"$f":"FETCHCOMMENT(E77)","v":"04A6823"},1,{"$f":"FETCHCOMMENT(G77)","v":"BROWN & CALDWELL"},4]
["ALIQUOT ASSOCIATES",null,2150000.0499999998,"M",2,{"$f":"FETCHCOMMENT(E78)","v":"04A6813\n04A6890"},2,{"$f":"FETCHCOMMENT(G78)","v":"HDR Engineering, Inc.\nCHAUDHARY & ASSOCIATES INC"},4]
["AMC CONSULTING ENGINEERS",null,267895.09999999998,"M",1,{"$f":"FETCHCOMMENT(E79)","v":"06A2975"},1,{"$f":"FETCHCOMMENT(G79)","v":"NV5 INC"},6]
["AP ENGINEERING",null,240000,"M",1,{"$f":"FETCHCOMMENT(E80)","v":"59A1270"},1,{"$f":"FETCHCOMMENT(G80)","v":"FUGRO"},59]
["AXIOM ENGINEERING",null,574116.65,"M",1,{"$f":"FETCHCOMMENT(E81)","v":"06A2969"},1,{"$f":"FETCHCOMMENT(G81)","v":"ATLAS TECHNICAL CONSULTANTS INC"},6]
["C2PM",null,425102.98,"F",1,{"$f":"FETCHCOMMENT(E82)","v":"11A3661"},1,{"$f":"FETCHCOMMENT(G82)","v":"Kleinfelder Construction Services, Inc."},11]
["EGP CONSULTING, INC.",null,140000,"F",1,{"$f":"FETCHCOMMENT(E83)","v":"07A5782\n"},1,{"$f":"FETCHCOMMENT(G83)","v":"TranSystems Corporation\n"},7]
["ELITE TRANSPORTATION GROUP INC",null,912000,"M",2,{"$f":"FETCHCOMMENT(E84)","v":"11A3767\n04A6800"},2,{"$f":"FETCHCOMMENT(G84)","v":"KIMLEY-HORN AND ASSOCIATES\nParsons Transportation Group, Inc."},"4,11"]
["FPL AND ASSOCIATES INC",null,350000,"M",1,{"$f":"FETCHCOMMENT(E85)","v":"07A5766"},1,{"$f":"FETCHCOMMENT(G85)","v":"Michael Baker International, Inc."},7]
["I D C CONSULTING ENGINEERS",null,1560000,"F",1,{"$f":"FETCHCOMMENT(E86)","v":"59A1285"},1,{"$f":"FETCHCOMMENT(G86)","v":"HNTB CORPORATION"},59]
["INNOVEX ENVIRONMENTAL",null,320000,"M",1,{"$f":"FETCHCOMMENT(E87)","v":"04A6823"},1,{"$f":"FETCHCOMMENT(G87)","v":"BROWN & CALDWELL"},4]
["KCM ENGINEERING INC",null,739296.3,"M",1,{"$f":"FETCHCOMMENT(E88)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G88)","v":"MS ENGINEERS INC"},6]
["LIN CONSULTING ",null,1212000,"M",4,{"$f":"FETCHCOMMENT(E89)","v":"08A3639\n11A3767\n07A5766\n07A5782"},3,{"$f":"FETCHCOMMENT(G89)","v":"TranSystems Corporation\nKimley-Horn and Associates, Inc.\nMichael Baker International, Inc."},"7,8,11"]
["LRS PROGRAM DELIVERY INC",null,728000,"F",1,{"$f":"FETCHCOMMENT(E90)","v":"53A0282"},1,{"$f":"FETCHCOMMENT(G90)","v":"VALUE MANAGEMENT STRATEDIES INC"},53]
["MGE ENGINEERING",null,2730000,"M",1,{"$f":"FETCHCOMMENT(E91)","v":"59A1285"},1,{"$f":"FETCHCOMMENT(G91)","v":"HNTB CORPORATION"},59]
["MOZAMO ENGINEERING INC",null,4165442.9,"F",5,{"$f":"FETCHCOMMENT(E92)","v":"06A2969\n09A0964\n06A2971\n06A2975\n09A0983"},3,{"$f":"FETCHCOMMENT(G92)","v":"ATLAS TECHNICAL CONSULTANTS INC\nNV5 INC\nMS ENGINEERING INC"},"6,9"]
["PACRIM ENGINEERING",null,1325000,"F",1,{"$f":"FETCHCOMMENT(E93)","v":"59A1268"},1,{"$f":"FETCHCOMMENT(G93)","v":"Gannett Fleming, Inc."},59]
["PARIKH CONSULTANTS",null,97500,"M",1,{"$f":"FETCHCOMMENT(E94)","v":"04A6909"},1,{"$f":"FETCHCOMMENT(G94)","v":"WSP USA, Inc."},4]
["PARK ENGINEERING INC",null,739296.3,"M",1,{"$f":"FETCHCOMMENT(E95)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G95)","v":"MS ENGINEERS INC"},6]
["RAIL SURVEYORS AND ENGINEERS, INC.",null,500000.05,"M",1,{"$f":"FETCHCOMMENT(E96)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G96)","v":"HDR Engineering, Inc."},4]
["SAN DIEGUITO ENGINEERING INC",null,312000,"F",1,{"$f":"FETCHCOMMENT(E97)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G97)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["SILICON TRANSPORTATION",null,78000,"M",1,{"$f":"FETCHCOMMENT(E98)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G98)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["SYSTEM METRICS GROUP",null,2051314.2,"M",2,{"$f":"FETCHCOMMENT(E99)","v":"09A0976\n04A6800"},1,{"$f":"FETCHCOMMENT(G99)","v":"PARSONS"},"4,9"]
["TATSUMI AND PARTNERS",null,890000,"M",2,{"$f":"FETCHCOMMENT(E100)","v":"08A3639\n07A5782\n"},1,{"$f":"FETCHCOMMENT(G100)","v":"TranSystems Corporation"},"7,8"]
["TRANSMAT",null,2872856.97,"M",6,{"$f":"FETCHCOMMENT(E101)","v":"08A3615\n09A0964\n06A2975\n09A0976\n06A2975\n07A5729"},3,{"$f":"FETCHCOMMENT(G101)","v":"ATLAS TECHNICAL CONSULTANTS INC\nNV5 INC\nPARSONS"},"6,7,8,9"]
["TRICERTUS LLC",null,80000,"M",1,{"$f":"FETCHCOMMENT(E102)","v":"07A5677"},1,{"$f":"FETCHCOMMENT(G102)","v":"ARCADIS INC"},7]
["YEI ENGINEERS",null,2565000,"M",2,{"$f":"FETCHCOMMENT(E103)","v":"04A6909\n59A1268"},2,{"$f":"FETCHCOMMENT(G103)","v":"WSP USA, Inc.\nGannett Fleming, Inc."},"4,59"]
[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"]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E107)","v":""},null,{"$f":"FETCHCOMMENT(G107)","v":""}]
[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"]
["ALBAT",null,1764578.48,"F",2,{"$f":"FETCHCOMMENT(E111)","v":"11A3661\n06A2975"},2,{"$f":"FETCHCOMMENT(G111)","v":"Kleinfelder Construction Services, Inc.\nNV5 INC"},"6,11"]
["AREA WEST ENVIRONMENTAL",null,450005.64,"F",1,{"$f":"FETCHCOMMENT(E112)","v":"03A3681"},1,{"$f":"FETCHCOMMENT(G112)","v":"ICF Jones & Stokes, Inc."},3]
["AVILA TRAFFIC SAFETY",null,120000,"F",1,{"$f":"FETCHCOMMENT(E113)","v":"59A1270"},1,{"$f":"FETCHCOMMENT(G113)","v":"FUGRO"},59]
["BENNETT ENGINEERING SERVICES, INC.",null,1921000.04,"F",3,{"$f":"FETCHCOMMENT(E114)","v":"04A6813\n11A3767\n04A6909"},3,{"$f":"FETCHCOMMENT(G114)","v":"HDR Engineering, Inc.\nKimley-Horn and Associates, Inc.\nWSP USA, Inc."},"4,11"]
["BLUE LAKE CIVIL",null,546000,"F",1,{"$f":"FETCHCOMMENT(E115)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G115)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["COGSTONE RESOURCE",null,75000.94,"F",1,{"$f":"FETCHCOMMENT(E116)","v":"03A3681"},1,{"$f":"FETCHCOMMENT(G116)","v":"ICF Jones & Stokes, Inc."},3]
["CONVEY, INC.",null,97500,"F",1,{"$f":"FETCHCOMMENT(E117)","v":"04A6909"},1,{"$f":"FETCHCOMMENT(G117)","v":"WSP USA, Inc."},4]
["CPM PARTNERS",null,425102.98,"F",1,{"$f":"FETCHCOMMENT(E118)","v":"11A3661"},1,{"$f":"FETCHCOMMENT(G118)","v":"Kleinfelder Construction Services, Inc."},11]
["EKOLOJIK",null,85020.58,"F",1,{"$f":"FETCHCOMMENT(E119)","v":"11A3661"},1,{"$f":"FETCHCOMMENT(G119)","v":"Kleinfelder Construction Services, Inc."},11]
["GALVIN PRESERVATION ASSOCIATES",null,150001.88,"F",1,{"$f":"FETCHCOMMENT(E120)","v":"03A3681\n"},1,{"$f":"FETCHCOMMENT(G120)","v":"ICF Jones & Stokes, Inc\n"},3]
["GATEWAY PACIFIC",null,886082.3,"F",2,{"$f":"FETCHCOMMENT(E121)","v":"11A3767\n11A3661"},2,{"$f":"FETCHCOMMENT(G121)","v":"KIMLEY-HORN AND ASSOCIATES\nKleinfelder Construction Services, Inc."},11]
["GSM LANDSCAPE ARCHITECTS INC",null,520000,"F",1,{"$f":"FETCHCOMMENT(E122)","v":"53A0282"},1,{"$f":"FETCHCOMMENT(G122)","v":"VALUE MANAGEMENT STRATEDIES INC"},53]
["JSE4",null,493000,"F",3,{"$f":"FETCHCOMMENT(E123)","v":"11A3767\n08A3639\n07A5782"},2,{"$f":"FETCHCOMMENT(G123)","v":"KIMLEY-HORN AND ASSOCIATES\nTranSystems Corporation"},"3,8,11"]
["LEWIS JONES ",null,624000,"F",1,{"$f":"FETCHCOMMENT(E124)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G124)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["KELLY MCNUTT CONSULTING, LLC",null,1100000,"F",1,{"$f":"FETCHCOMMENT(E125)","v":"04A6685"},1,{"$f":"FETCHCOMMENT(G125)","v":"Stanton Constructability Services ,LLC"},4]
["MEGAN STROMBERG CONSTULTING",null,80000,"F",1,{"$f":"FETCHCOMMENT(E126)","v":"04A6823"},1,{"$f":"FETCHCOMMENT(G126)","v":"BROWN & CALDWELL"},4]
["MOUNTAINVIEW BIOLOGICAL ",null,594150,"F",1,{"$f":"FETCHCOMMENT(E127)","v":"08A3623"},1,{"$f":"FETCHCOMMENT(G127)","v":"DUDEK\n"},8]
["PRR INC",null,228001.88,"F",2,{"$f":"FETCHCOMMENT(E128)","v":"11A3767\n03A3681"},2,{"$f":"FETCHCOMMENT(G128)","v":"KIMLEY-HORN AND ASSOCIATES\nICF Jones & Stokes, Inc."},"3,11"]
["SAYLOR CONSULTING GROUP",null,2445000,"F",2,{"$f":"FETCHCOMMENT(E129)","v":"04A6823\n59A1268"},2,{"$f":"FETCHCOMMENT(G129)","v":"BROWN & CALDWELL\nGannett Fleming, Inc."},"4,59"]
["SWAIM BIOLOGICAL CONSULTING",null,198050,"F",1,{"$f":"FETCHCOMMENT(E130)","v":"08A3623"},1,{"$f":"FETCHCOMMENT(G130)","v":"DUDEK\n"},8]
["TRI COUNTY DRILLING INC",null,240000,"F",1,{"$f":"FETCHCOMMENT(E131)","v":"59A1270"},1,{"$f":"FETCHCOMMENT(G131)","v":"FUGRO"},59]
["WAGNER ENGINEERING & SURVEY ",null,110000,"F",1,{"$f":"FETCHCOMMENT(E132)","v":"07A5738"},1,{"$f":"FETCHCOMMENT(G132)","v":"STANTEC CONSULTING SERVICES INC"},7]
["WATEARTH",null,650001.92999999993,"F",2,{"$f":"FETCHCOMMENT(E133)","v":"04A6813\n03A3681"},2,{"$f":"FETCHCOMMENT(G133)","v":"HDR Engineering, Inc.\nICF Jones & Stokes, Inc."},"3,4"]
["Z & K CONSULTANTS INC",null,739296.3,"F",1,{"$f":"FETCHCOMMENT(E134)","v":"06A2971"},1,null,6]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E135)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E136)","v":""}]
[]
[]
[]
["Prime Name",null,"No of Contracts","Contract #","Prime Name","No of Contracts","Contract #","Prime Name","No of Contracts","Contract #"]
["ATLAS TECHNICAL CONSULTANTS INC",null,2,{"$f":"FETCHCOMMENT(C141)","v":"06A2969\n08A3615"},"GANNETT FLEMING, INC.",1,{"$f":"FETCHCOMMENT(F141)","v":"59A1268"},"NV5 INC",4,{"$f":"FETCHCOMMENT(I141)","v":"09A0964\n06A2975\n07A5729\n09A0983"}]
["ARCADIS USA INC",null,1,{"$f":"FETCHCOMMENT(C142)","v":"07A5677"},"HDR ENGINEERING, INC.",1,{"$f":"FETCHCOMMENT(F142)","v":"04A6813"},"PARSONS TRANSPORTATION GROUP, INC.",2,{"$f":"FETCHCOMMENT(I142)","v":"09A0976\n04A6800"}]
["BROWN AND CALDWELL",null,1,{"$f":"FETCHCOMMENT(C143)","v":"04A6823"},"HNTB CORPORATION",1,{"$f":"FETCHCOMMENT(F143)","v":"59A1285"},"STANTEC CONSULTING SERVICES INC",1,{"$f":"FETCHCOMMENT(I143)","v":"07A5738"}]
["BUREAU VERITAS NORTH AMERICA INC",null,2,{"$f":"FETCHCOMMENT(C144)","v":"59A1258\n08A3604"},"ICF JONES & STOKES, INC.",1,{"$f":"FETCHCOMMENT(F144)","v":"03A3681"},"STANTON CONSTRUCTABILITY SERVICES ,LLC",1,{"$f":"FETCHCOMMENT(I144)","v":"04A6685"}]
["CHAUDHARY & ASSOCIATES INC",null,1,{"$f":"FETCHCOMMENT(C145)","v":"04A6890"},"KIMLEY-HORN AND ASSOCIATES INC",1,{"$f":"FETCHCOMMENT(F145)","v":"11A3767"},"TRANSYSTEMS CORPORATION",2,{"$f":"FETCHCOMMENT(I145)","v":"08A3639\n07A5782"}]
["DEAN RYAN CONSULTANTS & DESIGNERS, INC.",null,1,{"$f":"FETCHCOMMENT(C146)","v":"07A5768"},"KLEINFELDER CONSTRUCTION SERVICES INC",1,{"$f":"FETCHCOMMENT(F146)","v":"11A3661\n"},"WSP USA, INC.",1,{"$f":"FETCHCOMMENT(I146)","v":"04A6909"}]
["DUDEK",null,1,{"$f":"FETCHCOMMENT(C147)","v":"08A3623\n"},"MICHAEL BAKER INTERNATIONAL, INC.",1,{"$f":"FETCHCOMMENT(F147)","v":"09A0976\n07A5766"},"VALUE MANAGEMENT STRATEGIES",1,{"$f":"FETCHCOMMENT(I147)","v":"53A0282"}]
["FUGRO",null,1,{"$f":"FETCHCOMMENT(C148)","v":"59A1270"},"MS ENGINEERING INC",1]
[]
["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"]