{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA DPAC FEB 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 FEB 2024 CAA","index":0,"n_rows":125,"n_cols":10,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["DEPARTMENT OF TRANSPORTATION - CALTRANS"]
["DBE Commitment at Award (CAA) on Federally Funded Architectural & Engineering Contracts - October 1, 2023 - February 29, 2024"]
[]
["Total Award Amount Year-to-Date (YTD)",null,"Total DBE Commitment Amount YTD",null,null,"Total Prime Contracts Awarded YTD"]
[249311098,null,{"$f":"SUM(C7:C18)","v":55712305.090000004},null,null,{"$f":"SUM(C117:C122,I117:I122,F117:F122)","v":18}]
["Groups ",null," Commitment Dollars YTD","Firms YTD","Contracts YTD","% of Contracts","% of DBE $","% of Total $"]
["Hispanic American Male",null,{"$f":"SUMIF(D26:D40,\"m\", C26:C40)","v":18608944.880000003},{"$f":"COUNTIF(D26:D40,\"M\")","v":12},{"$f":"SUMIF(D26:D40,\"M\",E26:E40)","v":21},{"$f":"E7/E20","v":0.23595505617977527},{"$f":"C7/C5","v":0.33401857722343975},{"$f":"C7/A5","v":7.4641462130177624E-2}]
["Hispanic American Female",null,{"$f":"SUMIF(D26:D40,\"F\", C26:C40)","v":100000.01},{"$f":"COUNTIF(D26:D40,\"F\")","v":1},{"$f":"SUMIF(D26:D40,\"F\",E26:E40)","v":1},{"$f":"E8/E20","v":1.1235955056179775E-2},{"$f":"C8/C5","v":1.7949357837277738E-3},{"$f":"C8/A5","v":4.0110532905358268E-4}]
["African American Male",null,{"$f":"SUMIF(D47:D51,\"m\", C47:C51)","v":367895.11},{"$f":"COUNTIF(D47:D51,\"M\")","v":2},{"$f":"SUMIF(D47:D51,\"M\",E47:E51)","v":2},{"$f":"E9/E20","v":2.247191011235955E-2},{"$f":"C9/C5","v":6.6034803156266239E-3},{"$f":"C9/A5","v":1.4756467439728655E-3}]
["African American Female",null,{"$f":"SUMIF(D47:D51,\"F\", C47:C51)","v":80000},{"$f":"COUNTIF(D47:D51,\"F\")","v":1},{"$f":"SUMIF(D47:D51,\"F\",E47:E51)","v":1},{"$f":"E10/E20","v":1.1235955056179775E-2},{"$f":"C10/C5","v":1.4359484833873708E-3},{"$f":"C10/A5","v":3.2088423115444304E-4}]
["Asian Pacific Male",null,{"$f":"SUMIF(D64:D86,\"m\", C64:C86)","v":10908089.82},{"$f":"COUNTIF(D64:D86,\"M\")","v":16},{"$f":"SUMIF(D64:D86,\"M\",E64:E86)","v":23},{"$f":"E11/E20","v":0.25842696629213485},{"$f":"C11/C5","v":0.19579318792102773},{"$f":"C11/A5","v":4.3752925190678839E-2}]
["Asian Pacific Female",null,{"$f":"SUMIF(D64:D86,\"F\", C64:C86)","v":4557695.88},{"$f":"COUNTIF(D64:D86,\"F\")","v":3},{"$f":"SUMIF(D64:D86,\"F\",E64:E86)","v":6},{"$f":"E12/E20","v":6.741573033707865E-2},{"$f":"C12/C5","v":8.1807706082835843E-2},{"$f":"C12/A5","v":1.8281159228619656E-2}]
["Subcontinent Asian Male",null,{"$f":"SUMIF(D54:D61,\"m\", C54:C61)","v":10705398.649999999},{"$f":"COUNTIF(D54:D61,\"M\")","v":6},{"$f":"SUMIF(D54:D61,\"M\",E54:E61)","v":11},{"$f":"E13/E20","v":0.12359550561797752},{"$f":"C13/C5","v":0.19215501194405879},{"$f":"C13/A5","v":4.2939920187588271E-2}]
["Subcontinent Asian Female",null,{"$f":"SUMIF(D54:D61,\"F\", C54:C61)","v":585000},{"$f":"COUNTIF(D54:D61,\"F\")","v":1},{"$f":"SUMIF(D54:D61,\"F\",E54:E61)","v":1},{"$f":"E14/E20","v":1.1235955056179775E-2},{"$f":"C14/C5","v":1.0500373284770149E-2},{"$f":"C14/A5","v":2.3464659403168646E-3}]
["Native American Male",null,{"$f":"SUMIF(D43:D44,\"m\", C43:C44)","v":0},{"$f":"COUNTIF(D43:D44,\"M\")","v":0},{"$f":"SUMIF(D43:D44,\"M\",E43:E44)","v":0},{"$f":"E15/E20","v":0},{"$f":"C15/C5","v":0},{"$f":"C15/A5","v":0}]
["Native American Female",null,{"$f":"SUMIF(D43:D44,\"F\", C43:C44)","v":180000.01},{"$f":"COUNTIF(D43:D44,\"F\")","v":1},{"$f":"SUMIF(D43:D44,\"F\",E43:E44)","v":2},{"$f":"E16/E20","v":2.247191011235955E-2},{"$f":"C16/C5","v":3.2308842671151449E-3},{"$f":"C16/A5","v":7.2198956020802572E-4}]
["Non Minority Women",null,{"$f":"SUMIF(D93:D112,\"F\", C93:C112)","v":9619280.7300000004},{"$f":"COUNTIF(D93:D112,\"F\")","v":17},{"$f":"SUMIF(D93:D112,\"F\",E93:E112)","v":21},{"$f":"E17/E20","v":0.23595505617977527},{"$f":"C17/C5","v":0.17265989469401077},{"$f":"C17/A5","v":3.8583443766309997E-2}]
["Non Minority Men",null,{"$f":"SUMIF(D89:D90,\"M\", C89:C90)","v":0},{"$f":"COUNTIF(D89:D90,\"M\")","v":0},{"$f":"SUMIF(D89:D90,\"M\",E89:E90)","v":0},{"$f":"E18/E20","v":0},{"$f":"C18/C5","v":0},{"$f":"C18/A5","v":0}]
[]
["Total  ",null,{"$f":"SUM(C7:C18)","v":55712305.090000004},{"$f":"SUM(D7:D19)","v":60},{"$f":"SUM(E7:E19)","v":89}]
["Total Prime Contracts Awarded",null,{"$f":"SUM(C117:C122,F117:F122,I117:I121)","v":18}]
["Red Italic = DBE firm as Prime"]
["BOLD = women"]
[]
["Hispanic American",null,"Dollars","M/F","Contract","Contract Number","Prime","Prime Name","Districts"]
["ACT CONSULTING ENGINEERS ",null,{"$f":"'[1]DPAC A&E Worksheet'!G6","v":1350000},"M",1,{"$f":"FETCHCOMMENT(E26)","v":"08A3639"},1,{"$f":"FETCHCOMMENT(G26)","v":"TranSystems Corporation"},8]
["CABRINHA HEARN & ASSOCIATES",null,{"$f":"'[1]DPAC A&E Worksheet'!G11","v":110000},"M",1,{"$f":"FETCHCOMMENT(E27)","v":"07A5738"},1,{"$f":"FETCHCOMMENT(G27)","v":"STANTEC CONSULTING SERVICES INC"},7]
["FILIPPIN ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!G19","v":585000},"M",1,{"$f":"FETCHCOMMENT(E28)","v":"07A5729"},1,{"$f":"FETCHCOMMENT(G28)","v":"NV5 INC"},7]
["FOUNTAINHEAD CONSULTING CORP",null,{"$f":"'[1]DPAC A&E Worksheet'!G28","v":3297267.0999999996},"M",2,{"$f":"FETCHCOMMENT(E29)","v":"11A3661\n0612971\n"},2,{"$f":"FETCHCOMMENT(G29)","v":"Kleinfelder Construction Services, Inc.\nMS ENGINEERS"},"6,11"]
["LA SALLE SOLUTIONS",null,{"$f":"'[1]DPAC A&E Worksheet'!G35","v":1800164.6},"M",2,{"$f":"FETCHCOMMENT(E30)","v":"11A3661\n08A3604"},2,{"$f":"FETCHCOMMENT(G30)","v":"Kleinfelder Construction Services, Inc.\nBureau Veritas North America, Inc."},"8,11"]
["RIVER FOCUS",null,{"$f":"'[1]DPAC A&E Worksheet'!G44","v":100000.01},"M",1,{"$f":"FETCHCOMMENT(E31)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G31)","v":"HDR Engineering, Inc."},4]
["SAMA CONSTRUCTION",null,{"$f":"'[1]DPAC A&E Worksheet'!G51","v":1667895.1},"M",3,{"$f":"FETCHCOMMENT(E32)","v":"59A1258\n08A3604\n06A2975"},2,{"$f":"FETCHCOMMENT(G32)","v":"Bureau Veritas North America, Inc.\nNV5 INC"},"6,8,59"]
["SIX RIVERS GEOSCIENCES",null,{"$f":"'[1]DPAC A&E Worksheet'!C40","v":100000.01},"F",1,{"$f":"FETCHCOMMENT(E33)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G33)","v":"HDR Engineering, Inc."},4]
["SYRUSA ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!G63","v":4112856.97},"M",4,{"$f":"FETCHCOMMENT(E34)","v":"59A1258\n09A0964\n06A2975\n07A5729"},2,{"$f":"FETCHCOMMENT(G34)","v":"Bureau Veritas North America, Inc.\nNV5 INC"},"6,7,9,59"]
["TRIDENT CPM CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!G72","v":100000},"M",1,{"$f":"FETCHCOMMENT(E35)","v":"07A5677"},1,{"$f":"FETCHCOMMENT(G35)","v":"ARCADIS INC"},7]
["UNICO ENGINEERING CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!G78","v":2507179.9500000002},"M",2,{"$f":"FETCHCOMMENT(E36)","v":"09A0964\n06A2975"},1,{"$f":"FETCHCOMMENT(G36)","v":"NV5 INC"},"6,9"]
["VALLE & ASSOCIATES CIVIL",null,{"$f":"'[1]DPAC A&E Worksheet'!G86","v":739296.3},"M",1,{"$f":"FETCHCOMMENT(E37)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G37)","v":"MS ENGINEERING INC"},6]
["VSCE INC",null,{"$f":"'[1]DPAC A&E Worksheet'!G93","v":2239284.85},"M",2,{"$f":"FETCHCOMMENT(E38)","v":"09A0964\n06A2975"},1,{"$f":"FETCHCOMMENT(G38)","v":"NV5 INC"},"6,9"]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E39)","v":""},null,{"$f":"FETCHCOMMENT(G39)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E40)","v":""},null,{"$f":"FETCHCOMMENT(G40)","v":""}]
[]
["Native American",null,"Dollars","M/F","Contract","Contract Number","Prime","Prime Name","Districts"]
["GERONIMO ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!W8","v":180000.01},"F",2,{"$f":"FETCHCOMMENT(E43)","v":"04A6813\n04A6823"},2,{"$f":"FETCHCOMMENT(G43)","v":"HDR Engineering, Inc.\nBROWN AND CALDWELL"},4]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E44)","v":""},null,{"$f":"FETCHCOMMENT(G44)","v":""}]
[]
["African American",null,"Dollars","M/F","Contract","Contract Number","Prime","Prime Name","Districts"]
["ACTIVEWAYZ ENGINEERING, INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AI8","v":100000.01},"M",1,{"$f":"FETCHCOMMENT(E47)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G47)","v":"HDR Engineering, Inc."},4]
["ACUMEN BUILDING",null,{"$f":"'[1]DPAC A&E Worksheet'!AI17","v":267895.09999999998},"M",1,{"$f":"FETCHCOMMENT(E48)","v":"06A2975"},1,{"$f":"FETCHCOMMENT(G48)","v":"NV5 INC"},6]
["O2EPCM INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AC8","v":80000},"F",1,{"$f":"FETCHCOMMENT(E49)","v":"07A5677"},1,{"$f":"FETCHCOMMENT(G49)","v":"ARCADIS INC"},7]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E50)","v":""},null,{"$f":"FETCHCOMMENT(G50)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E51)","v":""},null,{"$f":"FETCHCOMMENT(G51)","v":""}]
[]
["Sub Cont Asian",null,"Dollars","M/F","Contract","Contract Number","Prime","Prime Name","Districts"]
["AMC INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ13","v":4020000},"M",3,{"$f":"FETCHCOMMENT(E54)","v":"59A1258\n07A5677\n08A3604"},2,{"$f":"FETCHCOMMENT(G54)","v":"ARCADIS INC\nBureau Veritas North America, Inc."},"7,8,59"]
["EARTH MECHANICS ",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ23","v":135000},"M",1,{"$f":"FETCHCOMMENT(E55)","v":"08A3639"},1,{"$f":"FETCHCOMMENT(G55)","v":"TranSystems Corporation"},8]
["FULCRUM CONSULTANTS INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ34","v":739296.3},"M",1,{"$f":"FETCHCOMMENT(E56)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G56)","v":"MS ENGINEERS INC"},6]
["GRIT FORCE INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ56","v":1428233.3},"M",1,{"$f":"FETCHCOMMENT(E57)","v":"06A2969"},1,{"$f":"FETCHCOMMENT(G57)","v":"ATLAS TECHNICAL CONSULTANTS INC"},6]
["REDDY ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ65","v":1070164.6000000001},"M",2,{"$f":"FETCHCOMMENT(E58)","v":"11A3661\n11A3767"},2,{"$f":"FETCHCOMMENT(G58)","v":"Kleinfelder Construction Services, Inc.\nKimley-Horn and Associates, Inc."},11]
["S2 ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!AQ81","v":3312704.45},"M",3,{"$f":"FETCHCOMMENT(E59)","v":"09A0964\n06A2975\n07A5729"},1,{"$f":"FETCHCOMMENT(G59)","v":"NV5 INC"},"6,7,9"]
["SKYLINE CONSULTANTS",null,{"$f":"'[1]DPAC A&E Worksheet'!AM8","v":585000},"F",1,{"$f":"FETCHCOMMENT(E60)","v":"07A5729"},1,{"$f":"FETCHCOMMENT(G60)","v":"NV5 INC"},7]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E61)","v":""},null,{"$f":"FETCHCOMMENT(G61)","v":""}]
[]
["Asian Pacific",null,"Dollars","M/F","Contract","Contract Number","Prime","Prime Name","Districts"]
["ADVANTEC CONSULTING ENGINEERS ",null,{"$f":"'[1]DPAC A&E Worksheet'!O8","v":1591314.2},"M",2,{"$f":"FETCHCOMMENT(E64)","v":"08A3639\n09A0976"},2,{"$f":"FETCHCOMMENT(G64)","v":"TranSystems Corporation\nParsons"},"6,8"]
["AEW ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!O16","v":160000},"M",1,{"$f":"FETCHCOMMENT(E65)","v":"04A6823"},1,{"$f":"FETCHCOMMENT(G65)","v":"BROWN & CALDWELL"},4]
["ALIQUOT ASSOCIATES",null,{"$f":"'[1]DPAC A&E Worksheet'!O26","v":500000.05},"M",1,{"$f":"FETCHCOMMENT(E66)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G66)","v":"HDR Engineering, Inc."},4]
["AMC CONSULTING ENGINEERS",null,{"$f":"'[1]DPAC A&E Worksheet'!O33","v":267895.09999999998},"M",1,{"$f":"FETCHCOMMENT(E67)","v":"06A2975"},1,{"$f":"FETCHCOMMENT(G67)","v":"NV5 INC"},6]
["AXIOM ENGINEERING",null,{"$f":"'[1]DPAC A&E Worksheet'!O42","v":574116.65},"M",1,{"$f":"FETCHCOMMENT(E68)","v":"06A2969"},1,{"$f":"FETCHCOMMENT(G68)","v":"ATLAS TECHNICAL CONSULTANTS INC"},6]
["C2PM",null,{"$f":"'[1]DPAC A&E Worksheet'!K6","v":425102.98},"F",1,{"$f":"FETCHCOMMENT(E69)","v":"11A3661"},1,{"$f":"FETCHCOMMENT(G69)","v":"Kleinfelder Construction Services, Inc."},11]
["ELITE TRANSPORTATION GROUP INC",null,{"$f":"'[1]DPAC A&E Worksheet'!O56","v":312000},"M",1,{"$f":"FETCHCOMMENT(E70)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G70)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["INNOVEX ENVIRONMENTAL",null,{"$f":"'[1]DPAC A&E Worksheet'!O63","v":320000},"M",1,{"$f":"FETCHCOMMENT(E71)","v":"04A6823"},1,{"$f":"FETCHCOMMENT(G71)","v":"BROWN & CALDWELL"},4]
["KCM ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!O69","v":739296.3},"M",1,{"$f":"FETCHCOMMENT(E72)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G72)","v":"MS ENGINEERS INC"},6]
["LIN CONSULTING ",null,{"$f":"'[1]DPAC A&E Worksheet'!O78","v":582000},"M",2,{"$f":"FETCHCOMMENT(E73)","v":"08A3639\n11A3767"},2,{"$f":"FETCHCOMMENT(G73)","v":"TranSystems Corporation\nKimley-Horn and Associates, Inc."},"8,11"]
["MOZAMO ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!K26","v":3820592.9},"F",4,{"$f":"FETCHCOMMENT(E74)","v":"06A2969\n09A0964\n06A2971\n06A2975"},3,{"$f":"FETCHCOMMENT(G74)","v":"ATLAS TECHNICAL CONSULTANTS INC\nNV5 INC\nMS ENGINEERING INC"},"6,9"]
["PARK ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!O87","v":739296.3},"M",1,{"$f":"FETCHCOMMENT(E75)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G75)","v":"MS ENGINEERS INC"},6]
["RAIL SURVEYORS AND ENGINEERS, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!O102","v":500000.05},"M",1,{"$f":"FETCHCOMMENT(E76)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G76)","v":"HDR Engineering, Inc."},4]
["SAN DIEGUITO ENGINEERING INC",null,{"$f":"'[1]DPAC A&E Worksheet'!K40","v":312000},"F",1,{"$f":"FETCHCOMMENT(E77)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G77)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["SILICON TRANSPORTATION",null,{"$f":"'[1]DPAC A&E Worksheet'!O111","v":78000},"M",1,{"$f":"FETCHCOMMENT(E78)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G78)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["SYSTEM METRICS GROUP",null,{"$f":"'[1]DPAC A&E Worksheet'!O118","v":1051314.2},"M",1,{"$f":"FETCHCOMMENT(E79)","v":"09A0976"},1,{"$f":"FETCHCOMMENT(G79)","v":"PARSONS"},9]
["TATSUMI AND PARTNERS",null,{"$f":"'[1]DPAC A&E Worksheet'!O129","v":540000},"M",1,{"$f":"FETCHCOMMENT(E80)","v":"08A3639"},1,{"$f":"FETCHCOMMENT(G80)","v":"TranSystems Corporation"},8]
["TRANSMAT",null,{"$f":"'[1]DPAC A&E Worksheet'!O142","v":2872856.97},"M",6,{"$f":"FETCHCOMMENT(E81)","v":"08A3615\n09A0964\n06A2975\n09A0976\n06A2975\n07A5729"},3,{"$f":"FETCHCOMMENT(G81)","v":"ATLAS TECHNICAL CONSULTANTS INC\nNV5 INC\nPARSONS"},"6,7,8,9"]
["TRICERTUS LLC",null,{"$f":"'[1]DPAC A&E Worksheet'!O153","v":80000},"M",1,{"$f":"FETCHCOMMENT(E82)","v":"07A5677"},1,{"$f":"FETCHCOMMENT(G82)","v":"ARCADIS INC"},7]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E83)","v":""},null,{"$f":"FETCHCOMMENT(G83)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E84)","v":""},null,{"$f":"FETCHCOMMENT(G84)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E85)","v":""},null,{"$f":"FETCHCOMMENT(G85)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E86)","v":""},null,{"$f":"FETCHCOMMENT(G86)","v":""}]
[]
["Other",null,"Dollars","M/F","Contract","Contract Number","Prime","Prime Name","Districts"]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E89)","v":""},null,{"$f":"FETCHCOMMENT(G89)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E90)","v":""},null,{"$f":"FETCHCOMMENT(G90)","v":""}]
[]
["Non Minority Women",null,"Dollars","M/F","Contract","Contract Number","Prime","Prime Name","Districts"]
["ALBAT",null,{"$f":"'[1]DPAC A&E Worksheet'!AU7","v":1764578.48},"F",2,{"$f":"FETCHCOMMENT(E93)","v":"11A3661\n06A2975"},2,{"$f":"FETCHCOMMENT(G93)","v":"Kleinfelder Construction Services, Inc.\nNV5 INC"},"6,11"]
["BENNETT ENGINEERING SERVICES, INC.",null,{"$f":"'[1]DPAC A&E Worksheet'!AU13","v":556000.04},"F",2,{"$f":"FETCHCOMMENT(E94)","v":"04A6813\n11A3767"},2,{"$f":"FETCHCOMMENT(G94)","v":"HDR Engineering, Inc.\nKimley-Horn and Associates, Inc."},"4,11"]
["BLUE LAKE CIVIL",null,{"$f":"'[1]DPAC A&E Worksheet'!AU19","v":546000},"F",1,{"$f":"FETCHCOMMENT(E95)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G95)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["CPM PARTNERS",null,{"$f":"'[1]DPAC A&E Worksheet'!AU28","v":425102.98},"F",1,{"$f":"FETCHCOMMENT(E96)","v":"11A3661"},1,{"$f":"FETCHCOMMENT(G96)","v":"Kleinfelder Construction Services, Inc."},11]
["EKOLOJIK",null,{"$f":"'[1]DPAC A&E Worksheet'!AU33","v":85020.58},"F",1,{"$f":"FETCHCOMMENT(E97)","v":"11A3661"},1,{"$f":"FETCHCOMMENT(G97)","v":"Kleinfelder Construction Services, Inc."},11]
["GATEWAY PACIFIC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU40","v":886082.3},"F",2,{"$f":"FETCHCOMMENT(E98)","v":"11A3767\n11A3661"},2,{"$f":"FETCHCOMMENT(G98)","v":"KIMLEY-HORN AND ASSOCIATES\nKleinfelder Construction Services, Inc."},11]
["JSE4",null,{"$f":"'[1]DPAC A&E Worksheet'!AU45","v":213000},"F",2,{"$f":"FETCHCOMMENT(E99)","v":"11A3767\n08A3639"},2,{"$f":"FETCHCOMMENT(G99)","v":"KIMLEY-HORN AND ASSOCIATES\nTranSystems Corporation"},"8,11"]
["LEWIS JONES ",null,{"$f":"'[1]DPAC A&E Worksheet'!AU57","v":624000},"F",1,{"$f":"FETCHCOMMENT(E100)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G100)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["KELLY MCNUTT CONSULTING, LLC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU51","v":1100000},"F",1,{"$f":"FETCHCOMMENT(E101)","v":"04A6685"},1,{"$f":"FETCHCOMMENT(G101)","v":"Stanton Constructability Services ,LLC"},4]
["MEGAN STROMBERG CONSTULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!AU63","v":80000},"F",1,{"$f":"FETCHCOMMENT(E102)","v":"04A6823"},1,{"$f":"FETCHCOMMENT(G102)","v":"BROWN & CALDWELL"},4]
["MOUNTAINVIEW BIOLOGICAL ",null,{"$f":"'[1]DPAC A&E Worksheet'!AU70","v":594150},"F",1,{"$f":"FETCHCOMMENT(E103)","v":"08A3623"},1,{"$f":"FETCHCOMMENT(G103)","v":"DUDEK\n"},8]
["PRR INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU76","v":78000},"F",1,{"$f":"FETCHCOMMENT(E104)","v":"11A3767"},1,{"$f":"FETCHCOMMENT(G104)","v":"KIMLEY-HORN AND ASSOCIATES"},11]
["SAYLOR CONSULTING GROUP",null,{"$f":"'[1]DPAC A&E Worksheet'!AU86","v":1120000},"F",1,{"$f":"FETCHCOMMENT(E105)","v":"04A6823"},1,{"$f":"FETCHCOMMENT(G105)","v":"BROWN & CALDWELL"},4]
["SWAIM BIOLOGICAL CONSULTING",null,{"$f":"'[1]DPAC A&E Worksheet'!AU96","v":198050},"F",1,{"$f":"FETCHCOMMENT(E106)","v":"08A3623"},1,{"$f":"FETCHCOMMENT(G106)","v":"DUDEK\n"},8]
["WAGNER ENGINEERING & SURVEY ",null,{"$f":"'[1]DPAC A&E Worksheet'!AU102","v":110000},"F",1,{"$f":"FETCHCOMMENT(E107)","v":"07A5738"},1,{"$f":"FETCHCOMMENT(G107)","v":"STANTEC CONSULTING SERVICES INC"},7]
["WATEARTH",null,{"$f":"'[1]DPAC A&E Worksheet'!AU113","v":500000.05},"F",1,{"$f":"FETCHCOMMENT(E108)","v":"04A6813"},1,{"$f":"FETCHCOMMENT(G108)","v":"HDR Engineering, Inc."},4]
["Z & K CONSULTANTS INC",null,{"$f":"'[1]DPAC A&E Worksheet'!AU123","v":739296.3},"F",1,{"$f":"FETCHCOMMENT(E109)","v":"06A2971"},1,{"$f":"FETCHCOMMENT(G109)","v":"MS ENGINEERS INC"},6]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E110)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E111)","v":""}]
[null,null,null,null,null,{"$f":"FETCHCOMMENT(E112)","v":""}]
[]
[]
[null,null,null,null,null,null,{"$f":"FETCHCOMMENT(F115)","v":""},null,null,{"$f":"FETCHCOMMENT(I115)","v":""}]
["Prime Name",null,"# of Contracts","Contract #","Prime Name","# of Contracts","Contract #","Prime Name","# of Contracts","Contract #"]
["ATLAS TECHNICAL CONSULTANTS INC",null,2,{"$f":"FETCHCOMMENT(C117)","v":"06A2969\n08A3615"},"KIMLEY-HORN AND ASSOCIATES INC",1,{"$f":"FETCHCOMMENT(F117)","v":"11A3767"},"STANTON CONSTRUCTABILITY SERVICES ,LLC",1,{"$f":"FETCHCOMMENT(I117)","v":"04A6685"}]
["ARCADIS USA INC",null,1,{"$f":"FETCHCOMMENT(C118)","v":"07A5677"},"KLEINFELDER CONSTRUCTION SERVICES INC",1,{"$f":"FETCHCOMMENT(F118)","v":"11A3661\n"},"TRANSYSTEMS CORPORATION",1,{"$f":"FETCHCOMMENT(I118)","v":"08A3639"}]
["BROWN AND CALDWELL",null,1,{"$f":"FETCHCOMMENT(C119)","v":"04A6823"},"MS ENGINEERING INC",1,{"$f":"FETCHCOMMENT(F119)","v":"06A2971"}]
["BUREAU VERITAS NORTH AMERICA INC",null,2,{"$f":"FETCHCOMMENT(C120)","v":"59A1258\n08A3604"},"NV5 INC",3,{"$f":"FETCHCOMMENT(F120)","v":"09A0964\n06A2975\n07A5729"}]
["DUDEK",null,1,{"$f":"FETCHCOMMENT(C121)","v":"08A3623\n"},"PARSONS",1,{"$f":"FETCHCOMMENT(F121)","v":"09A0976"}]
["HDR ENGINEERING, INC.",null,1,{"$f":"FETCHCOMMENT(C122)","v":"04A6813"},"STANTEC CONSULTING SERVICES INC",1,{"$f":"FETCHCOMMENT(F122)","v":"07A5738"}]
[]
["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"]