{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ADA CONSTRUCTION JAN 2023 CAA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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 CONSTRUCTION JAN 2023 CAA","index":0,"n_rows":234,"n_cols":10,"rows_kept":234,"cut":false,"hidden":false,"merged":[]}
["DEPARTMENT OF TRANSPORTATION - CALTRANS"]
["DBE Commitment at Award (CAA) on Federally Funded Major Construction Contracts - October 1, 2022 - January 31, 2023"]
[]
["Total Award Amount Year-to-Date (YTD)",null,"Total DBE Commitment Amount YTD",null,null,null,"Total Prime Contracts Awarded YTD"]
[721964213.89999998,null,{"$f":"SUM(C7:C18)","v":183071079.72},null,null,null,{"$f":"SUM(C206:C231,J206:J231,F206:F231)","v":80}]
["Groups",null,"Commitment Dollars YTD","Firms YTD","Contracts YTD",null,"% of Contracts",null,"% of DBE $","% of Total $"]
["Hispanic American Male",null,{"$f":"SUMIF(D30:D95,\"m\", C30:C95)","v":50871601.969999999},{"$f":"COUNTIF(D30:D95,\"M\")","v":48},{"$f":"SUMIF(D30:D95,\"M\",E30:E95)","v":119},null,{"$f":"E7/E20","v":0.27738927738927738},null,{"$f":"C7/C5","v":0.2778789639947834},{"$f":"C7/A5","v":7.0462775010959586E-2}]
["Hispanic American Female",null,{"$f":"SUMIF(D30:D95,\"F\", C30:C95)","v":23448195.52},{"$f":"COUNTIF(D30:D95,\"F\")","v":15},{"$f":"SUMIF(D30:D95,\"F\",E30:E95)","v":60},null,{"$f":"E8/E20","v":0.13986013986013987},null,{"$f":"C8/C5","v":0.12808246696235742},{"$f":"C8/A5","v":3.2478334893269151E-2}]
["African American Male",null,{"$f":"SUMIF(D108:D119,\"m\", C108:C119)","v":4029510.2399999998},{"$f":"COUNTIF(D108:D118,\"M\")","v":6},{"$f":"SUMIF(D108:D118,\"M\",E108:E118)","v":22},null,{"$f":"E9/E20","v":5.128205128205128E-2},null,{"$f":"C9/C5","v":2.2010632406620295E-2},{"$f":"C9/A5","v":5.5813157528028547E-3}]
["African American Female",null,{"$f":"SUMIF(D108:D119,\"F\", C108:C119)","v":887169.87999999989},{"$f":"COUNTIF(D108:D118,\"F\")","v":3},{"$f":"SUMIF(D108:D118,\"F\",E108:E118)","v":8},null,{"$f":"E10/E20","v":1.8648018648018648E-2},null,{"$f":"C10/C5","v":4.8460405726392791E-3},{"$f":"C10/A5","v":1.2288280539662353E-3}]
["Asian Pacific Male",null,{"$f":"SUMIF(D135:D148,\"m\", C135:C148)","v":5729859.5},{"$f":"COUNTIF(D135:D148,\"M\")","v":6},{"$f":"SUMIF(D135:D148,\"M\",E135:E148)","v":15},null,{"$f":"E11/E20","v":3.4965034965034968E-2},null,{"$f":"C11/C5","v":3.1298550862121938E-2},{"$f":"C11/A5","v":7.9364868641448334E-3}]
["Asian Pacific Female",null,{"$f":"SUMIF(D135:D148,\"F\", C135:C148)","v":5584271.0800000001},{"$f":"COUNTIF(D135:D148,\"F\")","v":6},{"$f":"SUMIF(D135:D148,\"F\",E135:E148)","v":20},null,{"$f":"E12/E20","v":4.6620046620046623E-2},null,{"$f":"C12/C5","v":3.050329461398776E-2},{"$f":"C12/A5","v":7.734830857937071E-3}]
["Subcontinent Asian Male",null,{"$f":"SUMIF(D122:D132,\"m\", C122:C132)","v":10991960.060000001},{"$f":"COUNTIF(D122:D132,\"M\")","v":9},{"$f":"SUMIF(D122:D132,\"M\",E122:E132)","v":22},null,{"$f":"E13/E20","v":5.128205128205128E-2},null,{"$f":"C13/C5","v":6.0042034366169526E-2},{"$f":"C13/A5","v":1.5225076047221515E-2}]
["Subcontinent Asian Female",null,{"$f":"SUMIF(D122:D132,\"F\", C122:C132)","v":0},{"$f":"COUNTIF(D122:D132,\"F\")","v":0},{"$f":"SUMIF(D122:D132,\"F\",E122:E132)","v":0},null,{"$f":"E14/E20","v":0},null,{"$f":"C14/C5","v":0},{"$f":"C14/A5","v":0}]
["Native American Male",null,{"$f":"SUMIF(D98:D105,\"m\", C98:C105)","v":15556910.83},{"$f":"COUNTIF(D98:D105,\"M\")","v":6},{"$f":"SUMIF(D98:D105,\"M\",E98:E105)","v":18},null,{"$f":"E15/E20","v":4.195804195804196E-2},null,{"$f":"C15/C5","v":8.497743528794216E-2},{"$f":"C15/A5","v":2.1548035942062366E-2}]
["Native American Female",null,{"$f":"SUMIF(D98:D105,\"F\", C98:C105)","v":1881339},{"$f":"COUNTIF(D98:D105,\"F\")","v":1},{"$f":"SUMIF(D98:D105,\"F\",E98:E105)","v":3},null,{"$f":"E16/E20","v":6.993006993006993E-3},null,{"$f":"C16/C5","v":1.0276549430294692E-2},{"$f":"C16/A5","v":2.6058618471366314E-3}]
["Non Minority Women",null,{"$f":"SUMIF(D155:D201,\"F\", C155:C201)","v":64090261.640000008},{"$f":"COUNTIF(D155:D201,\"F\")","v":46},{"$f":"SUMIF(D155:D201,\"F\",E155:E201)","v":142},null,{"$f":"E17/E20","v":0.33100233100233101},null,{"$f":"C17/C5","v":0.35008403150308359},{"$f":"C17/A5","v":8.8772075410481793E-2}]
["Other Men",null,{"$f":"SUMIF(D151:D152,\"m\", C151:C152)","v":0},{"$f":"COUNTIF(D151:D152,\"M\")","v":0},{"$f":"SUMIF(D151:D152,\"M\",E151:E152)","v":0},null,{"$f":"E18/E20","v":0},null,{"$f":"C18/C5","v":0},{"$f":"C18/A5","v":0}]
[null,null,null,null,null,null,{"$f":"E19/E20","v":0},null,{"$f":"C19/C5","v":0},{"$f":"C19/A5","v":0}]
["Total  ",null,{"$f":"SUM(C7:C18)","v":183071079.72},{"$f":"SUM(D7:D19)","v":146},{"$f":"SUM(E7:E19)","v":429}]
["Total Primes Contracts",null,{"$f":"SUM(C206:C231,J206:J231,F206:F231)","v":80}]
[]
["Yellow = DBEs",null,"Green = Trucking",{"$f":"COUNTIF(B30:B201,43)","v":19},{"$f":"SUM(SUMIF(B29:B95,\"43\",C29:C95),SUMIF(B97:B152,\"43\",C97:C152),SUMIF(B154:B201,\"43\",C154:C201))","v":20806474.300000001},null,{"$f":"E23/C5","v":0.11365243670285161}]
["Red = Prime Contractor",null,"Blue = Supplier",{"$f":"COUNTIF(B30:B201,33)","v":22},{"$f":"SUM(SUMIF(B30:B95,\"33\",C30:C95),SUMIF(B98:B152,\"33\",C98:C152),SUMIF(B155:B201,\"33\",C155:C201))","v":32449175.000000004},null,{"$f":"E24/C5","v":0.17724905020295798}]
["Red Italic = DBE firm as Prime",null,"White = Other",{"$f":"COUNTIF(B30:B201,-4142)","v":105},{"$f":"C5-(E23+E24)","v":129815430.41999999},null,{"$f":"E25/C5","v":0.70909851309419036}]
["BOLD = women"]
["* = Used both as Trucking & Supplier"]
[]
["Hispanic American","Column1","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["3P LANDSCAPING",-4142,2329355.7800000003,"M",4,{"$f":"fetchcomment(E30)","v":"04-0Q6804\n06-0R2104\n07-306614\n12-0Q2704"},4,{"$f":"fetchcomment(G30)","v":"A.M. CONCRETE, INC.\nCAL VALLEY CONSTRUCTION, INC.\nGRIFFITH COMPANY\nGORDON N. BALL, INC."},"4, 6, 7, 12"]
["A & M CONSULTING ENGINEERS",-4142,66100,"M",3,{"$f":"fetchcomment(E31)","v":"03-1J0104\n04-0K4904\n05-1G9804"},3,{"$f":"fetchcomment(G31)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC\nO.C. JONES AND SONS INC\nCALPORTLAND CONSTRUCTION"},"3,4,5"]
["ABSL CONSTRUCTION",-4142,2002050,"M",13,{"$f":"fetchcomment(E32)","v":"04-0K2404\n04-0Q30U4\n04-3K4404\n04-4J9404\n05-0C7324\n03-0J8704\n04-0K4904\n04-2Q2504\n05-1G9804\n05-1H6904\n04-1J7804\n05-1H8104\n06-0R2104"},8,{"$f":"fetchcomment(G32)","v":"BAY CITIES PAVING & GRADING, INC.\nDESILVA GATES CONSTRUCTION LLC\nGRANITE CONSTRUCTION COMPANY\nO.C. JONES & SONS, INC.\nA TEICHERT AND SON INC\nAMERICAN CIVIL CONSTRUCTION\nCALPORTLAND CONSTRUCTION\nCAL VALLEY CONSTRUCTION, INC.  "},"3,4,5,6"]
["ALFARO COMMUNICATIONS CONSTRUCTION INC",-4142,1383364.1,"M",1,{"$f":"fetchcomment(E33)","v":"12-0R1504"},1,{"$f":"fetchcomment(G33)","v":"ALFARO COMMUNICATIONS CONSTRUCTION,INC"},12]
["AUSTIN ENTERPRISE",-4142,1503555.2500000002,"F",9,{"$f":"fetchcomment(E34)","v":"01-0G1404\n04-0Q30U4\n05-0C7324\n05-1H9604\n07-326204\n04-2Q2504\n05-1K1204\n04-2K1704\n06-0U8804"},8,{"$f":"fetchcomment(G34)","v":"BAY CITIES PAVING & GRADING, INC.\nFEC FUTURE CONTRACTORS AND ENGINEERS, INC\nGRANITE CONSTRUCTION COMPANY\nSTEELHEAD CONSTRUCTORS JV\nAMERICAN CIVIL CONSTRUCTORS \nGORDON N BALL\nGHILOTTI CONSTRUCTION COMPANY, INC.\nSECURITY PAVING COMPANY, INC."},"1, 4, 5, 6, 7"]
["BAYSIDE ENGINEERING",-4142,23600,"M",1,{"$f":"fetchcomment(E35)","v":"12-0Q2704"},1,{"$f":"fetchcomment(G35)","v":"GRIFFITH COMPANY"},12]
["BEST TESTLAB INC",-4142,16500,"F",1,{"$f":"fetchcomment(E36)","v":"03-1J0104"},1,{"$f":"fetchcomment(G36)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC."},3]
["BLANCO CONSTRUCTION",-4142,1203520,"M",1,{"$f":"fetchcomment(E37)","v":"07-322704"},1,{"$f":"fetchcomment(G37)","v":"AUTOBAHN CONSTRUCTION INC."},7]
["BRUCE ANDERSON",-4142,592026,"M",2,{"$f":"fetchcomment(E38)","v":"07-307024\n07-359704"},1,{"$f":"fetchcomment(G38)","v":"CALPROMAX ENGINEERING INC."},7]
["C&N REINFORCING, INC.",-4142,3907391.2800000003,"M",7,{"$f":"fetchcomment(E39)","v":"04-0Q30U4\n01-0E7904\n01-0H0214\n01-366004\n05-1H6904"},6,{"$f":"fetchcomment(G39)","v":"BAY CITIES PAVING & GRADING, INC.\nMERCER FRASER\nGRANITE CONSTRUCTION COMPANY\nDESILVA GATES CONSTRUCTION\nGHILOTTI BROS., INC.\nGHILOTTI CONSTRUCTION COMPANY, INC. "},"1, 4, 5"]
["CENTRAL COAST TRAFFIC SAFETY INC",-4142,2245502.5,"M",2,{"$f":"fetchcomment(E40)","v":"05-1H9604\n05-1G9804"},2,{"$f":"fetchcomment(G40)","v":"GRANITE CONSTRUCTION COMPANY\nCALPORTLAND CONSTRUCTION"},5]
["CHAVEZ TRUCKING",33,1931921,"F",5,{"$f":"fetchcomment(E41)","v":"04-0K2404\n04-0K4904\n04-1J7804\n04-4J4904\n05-1H6904"},3,{"$f":"fetchcomment(G41)","v":"DESILVA GATES CONSTRUCTION LLC\nGHILOTTI BROS., INC.          \nO.C. JONES & SONS INC"},"4,5"]
["D.B. ELECTRIC INC",-4142,1433261,"M",1,{"$f":"fetchcomment(E42)","v":"07-333004"},1,{"$f":"fetchcomment(G42)","v":"POWELL CONSTRUCTORS INC"},7]
["DE LA FUENTE CONSTRUCTION",-4142,1173730,"M",1,{"$f":"fetchcomment(E43)","v":"11-422304"},1,{"$f":"fetchcomment(G43)","v":"HAZARD CONSTRUCTION ENGR"},11]
["DELTA BAY CONSULTANTS LLC",-4142,4800,"M",3,{"$f":"fetchcomment(E44)","v":"01-434804\n12-0R1904\n01-366004"},3,{"$f":"fetchcomment(G44)","v":"FERREIRA CONSTRUCTION CO., INC.\nPOWELL CONSTRUCTORS INC\nGRANITE CONSTRUCTION"},"1,12"]
["DESIGN BUILD ENGINEERING",-4142,469694,"M",1,{"$f":"fetchcomment(E45)","v":"07-322004"},1,{"$f":"fetchcomment(G45)","v":"POWELL CONSTRUCTORS INC"},7]
["DON MAHAFFEY DRILLING COMPANY",-4142,87000,"F",2,{"$f":"fetchcomment(E46)","v":"05-0C7324\n12-0R1904"},2,{"$f":"fetchcomment(G46)","v":"GRANITE CONSTRUCTION COMPANY\nFERREIRA CONSTRUCTION CO., INC.            "},"5, 12"]
["DRAGON MATERIAL TRANSPORT",33,5893350,"F",5,{"$f":"fetchcomment(E47)","v":"04-0Q30U4\n05-0C7324\n05-1J4604\n06-0R2104\n06-0U8804"},5,{"$f":"fetchcomment(G47)","v":"BAY CITIES PAVING & GRADING, INC.\nCAL VALLEY CONSTRUCTION, INC.\nGRANITE CONSTRUCTION COMPANY\nGRANITE ROCK COMPANY\nSECURITY PAVING COMPANY, INC."},"4, 5, 6"]
["DRS REBAR INC",-4142,302167.26,"M",4,{"$f":"fetchcomment(E48)","v":"07-333004\n07-353304\n12-0Q2704\n07-322004"},2,{"$f":"fetchcomment(G48)","v":"GRIFFITH COMPANY\nPOWELL CONSTRUCTORS INC"},"7, 12"]
["E & L GONZALEZ ENGINEERING",-4142,1787729.8599999999,"M",2,{"$f":"fetchcomment(E49)","v":"07-326204\n07-326204"},1,{"$f":"fetchcomment(G49)","v":"FEC FUTURE CONTRACTORS AND ENGINEERS, INC"},7]
["E. AMEZCUA TRUCKING INC",43,550000,"M",1,{"$f":"fetchcomment(E50)","v":"04-0K4904"},1,{"$f":"fetchcomment(G50)","v":"O.C. JONES AND SONS INC"},4]
["EIGHTEEN TRUCKING",43,320000,"F",3,{"$f":"fetchcomment(E51)","v":"04-0Q6804\n05-1K1204\n05-1M4504"},1,{"$f":"fetchcomment(G51)","v":"GORDON N BALL INC"},"4, 5"]
["ENDEMIC ENVIRONMENTAL SERVICES",-4142,102250,"M",4,{"$f":"fetchcomment(E52)","v":"08-1H2004\n01-0E0104\n01-0H0214\n01-0H1914"},2,{"$f":"fetchcomment(G52)","v":"AMES CONSTRUCTION INC\nMERCER FRASER COMPANY"},"1,8"]
["FLASH TRAFFIC INC",-4142,58000,"F",1,{"$f":"fetchcomment(E53)","v":"05-1K0704"},1,{"$f":"fetchcomment(G53)","v":"GORDON N. BALL, INC."},5]
["FRONTLINE TRAFFIC CONTROL",-4142,23380,"M",1,{"$f":"fetchcomment(E54)","v":"12-0R2904"},1,{"$f":"fetchcomment(G54)","v":"PETERSON-CHASE GENERAL ENGINEERING CONST"},12]
["FULL TRAFFIC MAINTENANCE, INC.",-4142,48712.5,"M",1,{"$f":"fetchcomment(E55)","v":"12-0R1804"},1,{"$f":"fetchcomment(G55)","v":"CALPROMAX ENGINEERING INC. "},12]
["HER-CON CONSTRUCTION SERVICES",-4142,337917.38,"M",2,{"$f":"fetchcomment(E56)","v":"07-359504\n12-0R5004"},2,{"$f":"fetchcomment(G56)","v":"CROSSTOWN ELECTRICAL AND DATA,  INC.\nINTERNATIONAL LINE BUILDERS, INC."},"7, 12"]
["G & G ELECTRIC",-4142,41480,"M",1,{"$f":"fetchcomment(E57)","v":"07-322004"},1,{"$f":"fetchcomment(G57)","v":"POWELL CONSTRUCTORS INC"},7]
["G.O. RODRIGUEZ TRUCKING",43,231840,"M",1,{"$f":"fetchcomment(E58)","v":"07-336004"},1,{"$f":"fetchcomment(G58)","v":"BEADOR CONSTRUCTION"},7]
["GEOSTRUCTURAL",-4142,455680,"M",2,{"$f":"fetchcomment(E59)","v":"04-0Q30U4\n05-1M4504"},2,{"$f":"fetchcomment(G59)","v":"BAY CITIES PAVING & GRADING, INC.\nGORDON N. BALL, INC."},"4,5"]
["GREENCOAST LANDSCAPES, INC.",-4142,25436,"F",1,{"$f":"fetchcomment(E60)","v":"05-1C3604"},1,{"$f":"fetchcomment(G60)","v":"M.C.M. CONSTRUCTION, INC."},5]
["GOLDEN BAY FENCE PLUS IRON",-4142,10720,"M",1,{"$f":"fetchcomment(E61)","v":"04-1J7804"},1,{"$f":"fetchcomment(G61)","v":"O.C. JONES & SONS, INC."},4]
["JEFFERSON STATE HIGHWAY INC",-4142,2613655.88,"M",5,{"$f":"fetchcomment(E62)","v":"04-0K2404\n04-2K8104\n05-1K0704\n01-0E0104\n01-366004"},5,{"$f":"fetchcomment(G62)","v":"DESILVA GATES CONSTRUCTION LLC\nGORDON N. BALL, INC.\nPACIFIC INFRASTRUCTURE CONSTRUCTION\nMERCER FRASER COMPANY\nGRANITE CONSTRUCTION "},"1,4,5"]
["L & B METAL PRODUCT FABRICATION",33,142278.75,"M",1,{"$f":"fetchcomment(E63)","v":"01-0G1404"},1,{"$f":"fetchcomment(G63)","v":"STEELHEAD CONSTRUCTORS JV"},1]
["LA FIRMA, INC.",-4142,62850,"M",3,{"$f":"fetchcomment(E64)","v":"12-0R2904\n05-1H6904\n05-1H8104"},2,{"$f":"fetchcomment(G64)","v":"PETERSON-CHASE GENERAL ENGINEERING CONSTRUCITON\nDESILVA GATES CONSTRUCTION\nA. TEICHERT & SON INC DBA TEICHERT CONSTRUCTION"},"5,12"]
["LOGISTICAL ENTERPRISES",33,1008454.49,"F",5,{"$f":"fetchcomment(E65)","v":"03-1J0104\n04-0K0704\n07-307024\n07-359704\n12-0R1804"},3,{"$f":"fetchcomment(G65)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC.\nCALPROMAX ENGINEERING INC.\nST. FRANCIS ELECTRIC, LLC"},"3, 4, 7, 12"]
["LONE STAR LANDSCAPE",-4142,1389216,"M",5,{"$f":"fetchcomment(E66)","v":"03-1J0104\n04-3K4204\n05-0C7324\n04-2G7404\n05-1K1204"},5,{"$f":"fetchcomment(G66)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC.\nGRANITE CONSTRUCTION COMPANY\nGRANITE ROCK COMPANY\nGHILOTTI BROS INC\nGORDON N BALL"},"3,4,5"]
["LS TRUCKING",43,82420,"M",1,{"$f":"fetchcomment(E67)","v":"03-1J0104"},1,{"$f":"fetchcomment(G67)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC."},3]
["M&S ENVIRONMENTAL LANDSCAPE",33,439633.4,"M",6,{"$f":"fetchcomment(E68)","v":"01-0G1404\n01-0J4104\n01-0H0214\n01-0H1914\n01-366004\n01-0H20U4"},5,{"$f":"fetchcomment(G68)","v":"MCCULLOUGH CONSTRUCTION INC\nSTEELHEAD CONSTRUCTORS JV\nMERCER FRASER COMPANY\nGRANITE CONSTRUCTION COMPANY \nS.T. RHOADES CONSTRUCTION"},1]
["MANERI TRAFFIC CONTROL",-4142,1022705,"F",4,{"$f":"fetchcomment(E69)","v":"07-358804\n08-1H2004\n11-422304\n05-1M7404"},4,{"$f":"fetchcomment(G69)","v":"AMES CONSTRUCTION INC\nHAZARD CONSTRUCTION ENGR\nTRUESDELL CORPORATION OF CALIFORNIA, INC. \nCAL STRIPE INC"},"5,7, 8, 11"]
["MARTINEZ LANDSCAPE CO",33,1829461.25,"M",4,{"$f":"fetchcomment(E70)","v":"07-333004\n07-336804\n07-353304\n07-322004"},2,{"$f":"fetchcomment(G70)","v":"POWELL CONSTRUCTORS INC\nMARTINEZ LANDSCAPE CO., INC"},7]
["MESA TRAFFIC SERVICES",-4142,7500,"M",1,{"$f":"fetchcomment(E71)","v":"07-307024"},1,{"$f":"fetchcomment(G71)","v":"CALPROMAX ENGINEERING INC."},7]
["MEX ELECTRIC",-4142,5822652,"M",5,{"$f":"fetchcomment(E72)","v":"06-0W1704\n07-353304\n11-422304\n11-430644\n06-0U8804"},5,{"$f":"fetchcomment(G72)","v":"HAZARD CONSTRUCTION ENGR\nPOWELL CONSTRUCTORS INC\nRNR CONSTRUCTION, INC.\nSEMA CONSTRUCTION\nSECURITY PAVING COMPANY, INC."},"6, 7, 11"]
["MIRANDA LOGISTIC ENTERPRISE LLC",-4142,555711.46,"M",2,{"$f":"fetchcomment(E73)","v":"07-333004\n12-0Q2704"},2,{"$f":"fetchcomment(G73)","v":"GRIFFITH COMPANY\nPOWELL CONSTRUCTORS INC"},"7, 12"]
["MJD ENGINEERING",-4142,1431947,"M",1,{"$f":"fetchcomment(E74)","v":"01-434804"},1,{"$f":"fetchcomment(G74)","v":"MCM CONSTRUCTION, INC."},1]
["PRE-CON PRODUCTS INC",-4142,182622.47,"M",3,{"$f":"fetchcomment(E75)","v":"07-333004\n07-336004\n05-1C3604"},3,{"$f":"fetchcomment(G75)","v":"POWELL CONSTRUCTORS INC\nBEADOR CONSTRUCTION\nM.C.M. CONSTRUCTION, INC. "},"5,7"]
["PTM GENERAL ENGINEERING SERVICES INC",-4142,11058278.779999999,"F",7,{"$f":"fetchcomment(E76)","v":"04-3J1404\n06-0W15V4\n07-352004\n07-354904\n03-0J9234\n04-2J9504\n07-352104"},2,{"$f":"fetchcomment(G76)","v":"PTM GENERAL ENGINEERING SERVICES INC.\nCENTRAL COAST FINANCIAL GROUP"},"3,4,6,7"]
["QA CONSTRUCTORS",-4142,279800,"M",1,{"$f":"fetchcomment(E77)","v":"01-434804"},1,{"$f":"fetchcomment(G77)","v":"MCM CONSTRUCTION, INC."},1]
["QUIMU CONTRACTING, INC.",-4142,136952,"M",1,{"$f":"fetchcomment(E78)","v":"10-1C4004"},1,{"$f":"fetchcomment(G78)","v":"MIDSTATE BARRIER, INC."},10]
["RE CHAFFEE CONSTRUCTION INC",-4142,1736332,"M",1,{"$f":"fetchcomment(E79)","v":"07-319304"},1,{"$f":"fetchcomment(G79)","v":"RE CHAFFEE CONSTRUCTION INC."},7]
["RNR CONSTRUCTION, INC.                                                                                                     ",-4142,7087879,"M",2,{"$f":"fetchcomment(E80)","v":"06-0W1704\n06-0R2104"},2,{"$f":"fetchcomment(G80)","v":"RNR CONSTRUCTION, INC.\nCAL VALLEY CONSTRUCTION, INC."},6]
["ROBINSON SWEEPING INC",43,64750,"F",1,{"$f":"fetchcomment(E81)","v":"01-0E0104"},1,{"$f":"fetchcomment(G81)","v":"MERCER FRASER COMPANY"},1]
["S CHAVEZ CONSTRUCTION",43,231000,"F",1,{"$f":"fetchcomment(E82)","v":"05-1G9804"},1,{"$f":"fetchcomment(G82)","v":"CALPORTLAND CONSTRUCTION"},5]
["S&S TRUCKING",43,423620,"M",4,{"$f":"fetchcomment(E83)","v":"04-0Q30U4\n04-4J9404\n04-2K1704\n04-4J4904"},3,{"$f":"fetchcomment(G83)","v":"BAY CITIES PAVING & GRADING, INC.\nGHILOTTI BROS., INC\nGHILOTTI CONSTRUCTION COMPANY, INC. "},4]
["SWPPQUEEN",-4142,104020,"F",5,{"$f":"fetchcomment(E84)","v":"03-1J0104\n04-0K2404\n12-0P9304\n12-0R5004\n03-0J8704"},5,{"$f":"fetchcomment(G84)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC.\nDESILVA GATES CONSTRUCTION LLC\nGRIFFITH COMPANY\nINTERNATIONAL LINE BUILDERS, INC.\nA TEICHERT & SON"},"3,4,12"]
["T.D.W. CONSTRUCTION, INC.",-4142,42015,"M",1,{"$f":"fetchcomment(E85)","v":"04-0K2404"},1,{"$f":"fetchcomment(G85)","v":"DESILVA GATES CONSTRUCTION LLC"},4]
["TERRA WEST",-4142,2900,"M",1,{"$f":"fetchcomment(E86)","v":"11-422304"},1,{"$f":"fetchcomment(G86)","v":"HAZARD CONSTRUCTION ENGR"},11]
["TULLY INC",-4142,123225,"F",10,{"$f":"fetchcomment(E87)","v":"04-0K0704\n04-0K2404\n05-0C7324\n01-0E0104\n01-0H1914\n04-0K4904\n05-1K1204\n04-0Q6804\n04-1J7804\n05-1M4504"},6,{"$f":"fetchcomment(G87)","v":"BAY CITIES PAVING & GRADING, INC.\nGRANITE CONSTRUCTION COMPANY\nST. FRANCIS ELECTRIC, LLC\nMERCER FRASER COMPANY\nO.C. JONES & SONS INC\nGORDON N BALL"},"1,4,5"]
["VALDIVIA TRUCKING",43,88560,"M",1,{"$f":"fetchcomment(E88)","v":"01-0H8104\n"},1,{"$f":"fetchcomment(G88)","v":"GHILOTTI CONSTRUCTION COMPANY, INC."},1]
["VELARDE CONSTRUCTION",-4142,74778.100000000006,"M",1,{"$f":"fetchcomment(E89)","v":"07-353304"},1,{"$f":"fetchcomment(G89)","v":"POWELL CONSTRUCTORS INC"},7]
["VINTAGE PAVING COMPANY",-4142,191800,"M",1,{"$f":"fetchcomment(E90)","v":"03-1J0104"},1,{"$f":"fetchcomment(G90)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC."},3]
["WESTERN TRAFFIC SUPPLY INC",-4142,4368870,"M",5,{"$f":"fetchcomment(E91)","v":"04-0K2404\n04-0Q30U4\n04-2K8104\n04-4J9404\n04-2Q2504"},4,{"$f":"fetchcomment(G91)","v":"BAY CITIES PAVING & GRADING, INC.\nDESILVA GATES CONSTRUCTION LLC\nPACIFIC INFRASTRUCTURE CONSTRUCTION\nAMERICAN CIVIL CONSTRUCTION"},4]
["ZABEL ENTERPRISES",43,1151876,"M",3,{"$f":"fetchcomment(E92)","v":"06-0W1704\n01-0E0104\n01-366004"},3,{"$f":"fetchcomment(G92)","v":"RNR CONSTRUCTION, INC. \nMERCER FRASER COMPANY\nGRANITE CONSTRUCTION COMPANY"},"1,6"]
[]
[null,null,null,null,null,{"$f":"fetchcomment(E94)","v":""},null,{"$f":"fetchcomment(G94)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E95)","v":""},null,{"$f":"fetchcomment(G95)","v":""}]
[]
["Native American","Column1","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["DISABLED AMERICAN VETERAN",-4142,1453626,"M",1,{"$f":"fetchcomment(E98)","v":"06-0U8804"},1,{"$f":"fetchcomment(G98)","v":"SECURITY PAVING COMPANY, INC.              "},6]
["KRC SAFETY CO INC",33,2223276.2999999998,"M",7,{"$f":"fetchcomment(E99)","v":"03-1J0104\n06-0W1704\n06-1C7404\n05-1G9804\n04-4K4004\n06-0R2104\n10-1C4004"},6,{"$f":"fetchcomment(G99)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC.\nMIDSTATE BARRIER, INC. \nRNR CONSTRUCTION, INC.\nCALPORTLAND CONSTRUCTION\nMIKE BROWN ELECTRIC\nCAL VALLEY CONSTRUCTION, INC.  "},"3,4,5,6,10"]
["GR SUNBERG",-4142,1420400,"M",1,{"$f":"fetchcomment(E100)","v":"01-366004"},1,{"$f":"fetchcomment(G100)","v":"GRANITE CONSTRUCTION"},1]
["S.T. RHOADES CONSTRUCTION",-4142,8806546,"M",2,{"$f":"fetchcomment(E101)","v":"01-0G1404\n01-0H20U4"},2,{"$f":"fetchcomment(G101)","v":"STEELHEAD CONSTRUCTORS JV\nS,T, RHOADES CONSTRUCTION"},1]
["SAM'S EQUIPMENT & SUPPLIES",33,1185151.03,"M",3,{"$f":"fetchcomment(E102)","v":"04-0Q30U4\n06-0U8804\n07-322004"},1,{"$f":"fetchcomment(G102)","v":"BAY CITIES PAVING & GRADING, INC.\nPOWELL CONSTRUCTORS INC\nSECURITY PAVING COMPANY, INC."},"4,6,7"]
["TOTAL TRAFFIC CONTROL",33,467911.5,"M",4,{"$f":"fetchcomment(E103)","v":"04-3K4204\n05-1K0704\n04-0Q6804\n05-1M4504"},2,{"$f":"fetchcomment(G103)","v":"GORDON N. BALL, INC.\nGRANITE ROCK COMPANY"},"4, 5"]
["WEST COAST DRILLING",-4142,1881339,"F",3,{"$f":"fetchcomment(E104)","v":"01-0H8104\n06-0W1704\n05-1K1204"},3,{"$f":"fetchcomment(G104)","v":"GHILOTTI CONSTRUCTION COMPANY, INC.\nRNR CONSTRUCTION, INC.\nGORDON N BALL INC"},"1,5,6"]
[null,null,null,null,null,{"$f":"fetchcomment(E105)","v":""},null,{"$f":"fetchcomment(G105)","v":""}]
[]
["African American","Column1","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ALLUVION BIOLOGICAL CONSULTING",-4142,662780,"M",3,{"$f":"fetchcomment(E108)","v":"04-0Q30U4\n01-0E7904\n04-0Q6804"},3,{"$f":"fetchcomment(G108)","v":"BAY CITIES PAVING & GRADING, INC.\nGORDON N. BALL, INC.   \nMERCER FRASER"},"1,4"]
["AMERICAN TRAFFIC BARRICADE",-4142,195850,"M",1,{"$f":"fetchcomment(E109)","v":"08-1L6404"},1,{"$f":"fetchcomment(G109)","v":"BC RENTAL LLC"},8]
["APPIAN UDBE SWPPPS",-4142,6050,"F",4,{"$f":"fetchcomment(E110)","v":"07-307024\n01-0H0214\n05-1H8104\n12-0R1804"},3,{"$f":"fetchcomment(G110)","v":"A. TEICHERT & SON INC DBA TEICHERT CONSTRUCTION                    \nCALPROMAX ENGINEERING INC.\nMERCER FRASER"},"1,5,7,12"]
["BLACK DIAMOND ASPHALT",33,700293.17999999993,"F",2,{"$f":"fetchcomment(E111)","v":"01-0E0104\n03-0J8704"},2,{"$f":"fetchcomment(G111)","v":"MERCER FRASER COMPANY\nA TEICHERT & SON INC"},"1,3"]
["DOUBLE G'S SUPPLY, INC.",33,180826.7,"F",2,{"$f":"fetchcomment(E112)","v":"04-0K2404\n04-0Q30U4"},2,{"$f":"fetchcomment(G112)","v":"BAY CITIES PAVING & GRADING, INC.\nDESILVA GATES CONSTRUCTION LLC"},4]
["GARRISON WALKER GROUP, INC.",-4142,258339.77,"M",1,{"$f":"fetchcomment(E113)","v":"04-0Q30U4"},1,{"$f":"fetchcomment(G113)","v":"BAY CITIES PAVING & GRADING, INC."},4]
["K & G CONCRETE PUMPING",-4142,18590,"M",1,{"$f":"fetchcomment(E114)","v":"05-1K1204"},1,{"$f":"fetchcomment(G114)","v":"GORDON N BALL"},5]
["SYNERGY TRAFFIC CONTROL",-4142,2795000.4699999997,"M",15,{"$f":"fetchcomment(E115)","v":"07-353304\n07-359504\n12-0P9304\n12-0Q2704\n12-0R1904\n12-0R5004\n05-1H6904\n07-336004\n04-2G4614\n05-1C3604\n05-1H8104\n06-0U8804\n07-322004\n07-322704"},13,{"$f":"fetchcomment(G115)","v":"CROSSTOWN ELECTRICAL AND DATA,  INC.\nFERREIRA CONSTRUCTION CO., INC.\nGRIFFITH COMPANY\nINTERNATIONAL LINE BUILDERS, INC.\nPOWELL CONSTRUCTORS INC\nDESILVA GATES CONSTRUCTION\nBEADOR CONSTRUCTION\nACCURATE EARTHWORKS, INC.\nM.C.M. CONSTRUCTION, INC.\nA. TEICHERT & SON INC DBA TEICHERT CONSTRUCTION\nSECURITY PAVING COMPANY, INC.\nPOWELL CONSTRUCTORS INC\nAUTOBAHN CONSTRUCTION INC."},"4,5,6,7,12"]
["THOMPSON CONSTRACTING",-4142,98950,"M",1,{"$f":"fetchcomment(E116)","v":"03-0J8704"},1,{"$f":"fetchcomment(G116)","v":"A TEICHERT & SON INC"},3]
[null,null,null,null,null,{"$f":"fetchcomment(E117)","v":""},null,{"$f":"fetchcomment(G117)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E118)","v":""},null,{"$f":"fetchcomment(G118)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E119)","v":""},null,{"$f":"fetchcomment(G119)","v":""}]
[]
["Sub Cont Asian","Column1","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["A1 TRUCKING SVS, INC.",43,3817823,"M",4,{"$f":"fetchcomment(E122)","v":"04-0Q30U4\n04-4J9404\n04-2G7404\n04-2K1704"},3,{"$f":"fetchcomment(G122)","v":"BAY CITIES PAVING & GRADING, INC.\nGHILOTTI BROTHERS\nGHILOTTI CONSTRUCTION COMPANY, INC."},4]
["ACCURATE EARTHWORKS, INC.  ",-4142,169501,"M",1,{"$f":"fetchcomment(E123)","v":"04-2G4614"},1,{"$f":"fetchcomment(G123)","v":"ACCURATE EARTHWORKS, INC."},4]
["ALL CITIES TRUCKING",43,6276286,"M",4,{"$f":"fetchcomment(E124)","v":"04-0Q30U4\n04-4J9404\n04-2Q2504\n04-1J7804"},3,{"$f":"fetchcomment(G124)","v":"BAY CITIES PAVING & GRADING, INC.\nAMERICAN CIVIL CONSTRUCTION\nO.C. JONES & SONS, INC."},4]
["BRIDGE RUBBER BEARING",-4142,71501.459999999992,"M",3,{"$f":"fetchcomment(E125)","v":"04-0Q30U4\n05-0C7324\n05-1C3604"},3,{"$f":"fetchcomment(G125)","v":"BAY CITIES PAVING & GRADING, INC.\nGRANITE CONSTRUCTION COMPANY\nM.C.M. CONSTRUCTION, INC."},"4, 5"]
["HEIR AND SON CONSTRUCTION",-4142,51567.6,"M",1,{"$f":"fetchcomment(E126)","v":"04-2Q2504"},1,{"$f":"fetchcomment(G126)","v":""},4]
["SEQUOIA CONSULTANT INC",33,123340,"M",4,{"$f":"fetchcomment(E127)","v":"07-353304\n11-422304\n07-336004\n07-322004"},3,{"$f":"fetchcomment(G127)","v":"HAZARD CONSTRUCTION ENGR\nPOWELL CONSTRUCTORS INC\nBEADOR CONSTRUCTION COMPANY"},"7, 11"]
["SHK HAULING",43,67920,"M",2,{"$f":"fetchcomment(E128)","v":"03-0J8704\n03-0J9234"},2,{"$f":"fetchcomment(G128)","v":"A TEICHERT & SON\nCENTRAL COAST FINANCIAL GROUP"},3]
["SIERRA GEOTECH DBE INC",-4142,379021,"M",2,{"$f":"fetchcomment(E129)","v":"05-0C7324\n05-1C3604"},1,{"$f":"fetchcomment(G129)","v":"GRANITE CONSTRUCTION COMPANY\nM.C.M. CONSTRUCTION, INC."},5]
["USA TRUCKING",43,35000,"M",1,{"$f":"fetchcomment(E130)","v":"03-0J8704"},1,{"$f":"fetchcomment(G130)","v":"A TEICHERT & SON INC"},3]
[null,null,null,null,null,{"$f":"fetchcomment(E131)","v":""},null,{"$f":"fetchcomment(G131)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E132)","v":""},null,{"$f":"fetchcomment(G132)","v":""}]
[]
["Asian Pacific","Column1","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["A AND M SALES",-4142,119305.53,"F",1,{"$f":"fetchcomment(E135)","v":"05-0C7324"},1,{"$f":"fetchcomment(G135)","v":"GRANITE CONSTRUCTION COMPANY"},5]
["ACE FENCE COMPANY",-4142,3410173.26,"F",11,{"$f":"fetchcomment(E136)","v":"05-1C3604\n06-0U8804\n06-0W1704\n07-306614\n07-322704\n08-1H2004\n11-422304\n12-0Q2704\n12-0R2904\n05-1G9804\n07-336004\n"},11,{"$f":"fetchcomment(G136)","v":"A.M. CONCRETE, INC.\nAMES CONSTRUCTION INC\nAUTOBAHN CONSTRUCTION INC. \nGRIFFITH COMPANY\nHAZARD CONSTRUCTION ENGR\nPETERSON-CHASE GENERAL ENGINEERING CONST\nRNR CONSTRUCTION, INC.\nM.C.M. CONSTRUCTION, INC.    \nMERCER FRASER COMPANY\nA TEICHERT AND SON\nSECURITY PAVING COMPANY, INC.     "},"5,6,7,8,11,12"]
["GLOBAL ROAD SEALING, INC.",-4142,142560,"M",4,{"$f":"fetchcomment(E137)","v":"07-307024\n07-359704\n12-0R2904\n12-0R1804"},2,{"$f":"fetchcomment(G137)","v":"CALPROMAX ENGINEERING INC.\nPETERSON-CHASE GENERAL ENGINEERING CONST"},"7, 12"]
["GOLDEN STATE TRUCKING",43,2209770,"M",1,{"$f":"fetchcomment(E138)","v":"04-0Q30U4\n"},1,{"$f":"fetchcomment(G138)","v":"BAY CITIES PAVING & GRADING, INC."},4]
["JJ NGUYEN",33,785476.5,"M",5,{"$f":"fetchcomment(E139)","v":"04-0K4904\n04-1J7804\n04-2K1704\n04-4J4904\n05-1H8104"},4,{"$f":"fetchcomment(G139)","v":"A. TEICHERT & SON INC DBA TEICHERT CONSTRUCTION  \nGHILOTTI BROS., INC.\nGHILOTTI CONSTRUCTION COMPANY, INC.          \nO.C. JONES AND SONS"},"4,5"]
["KUDU EQUIPMENT CORPORATION",33,7914.43,"F",1,{"$f":"fetchcomment(E140)","v":"12-0R1904"},1,{"$f":"fetchcomment(G140)","v":"HAZARD CONSTRUCTION ENGR"},12]
["LMS TRANSPORT",-4142,1893358,"M",3,{"$f":"fetchcomment(E141)","v":"05-1G9804\n09-379304\n11-422304"},3,{"$f":"fetchcomment(G141)","v":"GORDON N. BALL, INC.\nHAT CREEK CONSTRUCTION & MATERIALS, INC.   \nCALPORTALND CONSTRUCTION"},"5,9,11"]
["NITTA EROSION CONTROL",33,1166677.6000000001,"F",3,{"$f":"fetchcomment(E142)","v":"01-0E7904\n03-0J8704\n05-1K0704"},3,{"$f":"fetchcomment(G142)","v":"GRIFFITH COMPANY\nCALPORTLAND CONSTRUCTION \nBEADOR CONSTRUCTION"},"1,3,5"]
["PRIME SUPPLY 1",-4142,40200.259999999995,"F",2,{"$f":"fetchcomment(E143)","v":"05-1C3604\n12-0P9304"},2,{"$f":"fetchcomment(G143)","v":"MIDSTATE BARRIER, INC."},"5,12"]
["S. KWOK ENGINEERS",-4142,103900,"M",1,{"$f":"fetchcomment(E144)","v":"04-0Q30U4"},1,{"$f":"fetchcomment(G144)","v":"BAY CITIES PAVING & GRADING, INC."},4]
["TRAFFIC LOOPS CRACKFILLING",-4142,840000,"F",2,{"$f":"fetchcomment(E145)","v":"06-1C7404\n05-1G9804"},2,{"$f":"fetchcomment(G145)","v":"MIDSTATE BARRIER, INC.\nCALPORTLAND CONSTRUCTION"},"5,6"]
["VT ELECTRIC",-4142,594795,"M",1,{"$f":"fetchcomment(E146)","v":"07-204904"},1,{"$f":"fetchcomment(G146)","v":"POWELL CONSTRUCTORS INC"},7]
[null,null,null,null,null,{"$f":"fetchcomment(E147)","v":""},null,{"$f":"fetchcomment(G147)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E148)","v":""},null,{"$f":"fetchcomment(G148)","v":""}]
[]
["Other",null,"Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
[null,null,null,null,null,{"$f":"fetchcomment(E151)","v":""},null,{"$f":"fetchcomment(G151)","v":""}]
[null,null,null,null,null,{"$f":"fetchcomment(E152)","v":""},null,{"$f":"fetchcomment(G152)","v":""}]
[]
["Non Minority Women","Column1","Dollars","M/F","Contract","Contract #","Prime","Prime Name","Districts"]
["ACTION SWEEPING SERVICES",43,276000,"F",2,{"$f":"fetchcomment(E155)","v":"03-0J8704\n04-0K4904"},2,{"$f":"fetchcomment(G155)","v":"A TEICHERT & SON INC\nO.C. JONES & SONS INC"},"3,4"]
["ALTA GROUP",-4142,42250,"F",1,{"$f":"fetchcomment(E156)","v":"01-0H8104"},1,{"$f":"fetchcomment(G156)","v":"GHILOTTI CONSTRUCTION COMPANY, INC."},1]
["AMERICAN PAVING SUPPLY",-4142,1125584.1000000001,"F",1,{"$f":"fetchcomment(E157)","v":"04-0Q30U4"},1,{"$f":"fetchcomment(G157)","v":"BAY CITIES PAVING & GRADING, INC."},4]
["AMERICAN TRAFFIC SAFETY",-4142,446880,"F",1,{"$f":"fetchcomment(E158)","v":"04-2K1704"},1,{"$f":"fetchcomment(G158)","v":"GHILOTTI CONSTRUCTION COMPANY, INC."},4]
["AURORA INDUSTIAL HYGIENE",-4142,2000,"F",2,{"$f":"fetchcomment(E159)","v":"05-1H9604\n12-0P9304"},2,{"$f":"fetchcomment(G159)","v":"GRANITE CONSTRUCTION COMPANY\nGRIFFITH COMPANY"},"5, 12"]
["AVILA TRAFFIC SAFETY",33,440904.9,"F",2,{"$f":"fetchcomment(E160)","v":"05-1J4604\n05-1K1204"},2,{"$f":"fetchcomment(G160)","v":"GRANITE ROCK COMPANY\nGORDON N BALL INC"},5]
["BT TRUCKING",43,417621,"F",3,{"$f":"fetchcomment(E161)","v":"08-1H2004\n05-1C3604\n07-322004"},1,{"$f":"fetchcomment(G161)","v":"AMES CONSTRUCTION INC\nM.C.M. CONSTRUCTION, INC.\nPOWELL CONSTRUCTORS INC"},"5, 7, 8"]
["C&N REINFORCING, INC.",-4142,2398202.62,"F",1,{"$f":"fetchcomment(E162)","v":"04-0Q30U4"},1,{"$f":"fetchcomment(G162)","v":"BAY CITIES PAVING & GRADING, INC."},4]
["CAL SIGNAL CORP",33,2250507.2000000002,"F",4,{"$f":"fetchcomment(E163)","v":"05-1H9604\n05-1H6904\n04-4K4004\n05-1H8104"},4,{"$f":"fetchcomment(G163)","v":"GRANITE CONSTRUCTION COMPANY\nDESILVA GATES CONSTRUCTION\nMIKE BROWN ELECTRIC\nA. TEICHERT & SON INC DBA TEICHERT CONSTRUCTION"},"4,5"]
["CAT TRACKING",-4142,1145545,"F",5,{"$f":"fetchcomment(E164)","v":"07-326204\n07-359504\n08-1K7904\n12-0Q2704\n12-0R5004"},4,{"$f":"fetchcomment(G164)","v":"CROSSTOWN ELECTRICAL AND DATA,  INC.\nFEC FUTURE CONTRACTORS AND ENGINEERS, INC\nGRIFFITH COMPANY\nINTERNATIONAL LINE BUILDERS, INC."},"7, 8, 12"]
["CMC TRAFFIC CONTROL",-4142,249980,"F",1,{"$f":"fetchcomment(E165)","v":"04-0K4904"},1,{"$f":"fetchcomment(G165)","v":"O.C. JONES & SONS INC"},4]
["COLUMBIA ELECTRIC INC",-4142,3764950,"F",6,{"$f":"fetchcomment(E166)","v":"04-3K4204\n04-3K4404\n04-0K4904\n04-2G7404\n04-2Q2504\n04-4J4904"},4,{"$f":"fetchcomment(G166)","v":"GRANITE ROCK COMPANY\nO.C. JONES & SONS, INC.\nGHILOTTI BROS \nAMERICAN CIVIL CONSTRUCTION"},"4, 7"]
["CONSTRUCTION SURVEY INC",-4142,11000,"F",1,{"$f":"fetchcomment(E167)","v":"04-2G7404"},1,{"$f":"fetchcomment(G167)","v":"GHILOTTI BROS INC"},4]
["COOPER ENGINEERING",-4142,1394784.25,"F",2,{"$f":"fetchcomment(E168)","v":"05-0C7324\n11-422304"},2,{"$f":"fetchcomment(G168)","v":"GRANITE CONSTRUCTION COMPANY\nHAZARD CONSTRUCTION ENGR"},"5, 11"]
["DEES BURKE ENGINEERING",-4142,4688876.58,"F",16,{"$f":"fetchcomment(E169)","v":"01-0G1404\n01-434804\n04-0Q30U4\n05-0C7324\n06-0W1704\n11-430644\n12-0Q2704\n01-0E7904\n01-0H0214\n01-0H1914\n01-366004\n05-1G9804\n04-2K1704\n04-4J4904\n05-1C3604\n06-0R2104"},11,{"$f":"fetchcomment(G169)","v":"BAY CITIES PAVING & GRADING, INC.\nGRANITE CONSTRUCTION COMPANY\nGRIFFITH COMPANY\nMCM CONSTRUCTION, INC.\nRNR CONSTRUCTION, INC. \nSEMA CONSTRUCTION\nSTEELHEAD CONSTRUCTORS JV\nMERCER FRASER COMPANY\nCALPORTLAND CONSTRUCTION\nGHILOTTI CONSTRUCTION COMPANY, INC.\nGHILOTTI BROS., INC.\nCAL VALLEY CONSTRUCTION, INC. "},"1, 4, 5, 6, 11, 12"]
["DILLARD ENVIRONMENTAL SERVICES",43,85660,"F",2,{"$f":"fetchcomment(E170)","v":"01-434804\n01-366004"},2,{"$f":"fetchcomment(G170)","v":"MCM CONSTRUCTION, INC.\nGRANITE CONSTRUCTION"},1]
["DIVERSIFIED LANDSCAPE CO",-4142,528307.6,"F",3,{"$f":"fetchcomment(E171)","v":"08-1H2004\n11-422304\n11-430644"},3,{"$f":"fetchcomment(G171)","v":"AMES CONSTRUCTION INC\nHAZARD CONSTRUCTION ENGR\nSEMA CONSTRUCTION"},"8, 11"]
["FOREFRONT DEEP FOUNDATIONS",-4142,1046322,"F",1,{"$f":"fetchcomment(E172)","v":"06-0U8804"},1,{"$f":"fetchcomment(G172)","v":"SECURITY PAVING COMPANY, INC."},6]
["GDS INDUSTRIES, INC.",-4142,2448487.79,"F",1,{"$f":"fetchcomment(E173)","v":"04-0Q30U4"},1,{"$f":"fetchcomment(G173)","v":"BAY CITIES PAVING & GRADING, INC."},4]
["HILLSIDE DRILLING",-4142,3796155,"F",2,{"$f":"fetchcomment(E174)","v":"05-0C7324\n05-1C3604"},2,{"$f":"fetchcomment(G174)","v":"GRANITE CONSTRUCTION COMPANY\nM.C.M. CONSTRUCTION, INC. "},5]
["J & M LAND RESTORATION",-4142,1375293.41,"F",3,{"$f":"fetchcomment(E175)","v":"05-1G9804\n05-1C3604\n06-0U8804"},3,{"$f":"fetchcomment(G175)","v":"CALPORTLAND CONSTRUCTION\nM.C.M. CONSTRUCTION, INC. \nSECURITY PAVING COMPANY, INC."},"5, 6"]
["J FRANCIS COMPANY",-4142,2202040,"F",1,{"$f":"fetchcomment(E176)","v":"11-430444"},1,{"$f":"fetchcomment(G176)","v":"J. FRANCIS COMPANY"},11]
["JARRETT FOUNDATIONS INC",33,7083670,"F",5,{"$f":"fetchcomment(E177)","v":"01-0J4104\n01-0E7904\n01-0H0214\n01-0H1914\n01-366004"},3,{"$f":"fetchcomment(G177)","v":"MCCULLOUGH CONSTRUCTION INC\nMERCER FRASER COMPANY\nGRANITE CONSTRUCTION"},1]
["JL STORMWATER CONSULTANTS",-4142,6000,"F",1,{"$f":"fetchcomment(E178)","v":"12-0R1904"},1,{"$f":"fetchcomment(G178)","v":"FERREIRA CONSTRUCTION CO., INC."},12]
["K & K CONSTRUCTION SUPPLY INC",33,27222.89,"F",2,{"$f":"fetchcomment(E179)","v":"04-0Q30U4\n05-0C7324"},2,{"$f":"fetchcomment(G179)","v":"BAY CITIES PAVING & GRADING, INC.\nGRANITE CONSTRUCTION COMPANY"},"4, 5"]
["LA STEEL SERVICES INC",-4142,127750,"F",1,{"$f":"fetchcomment(E180)","v":"11-430644"},1,{"$f":"fetchcomment(G180)","v":"SEMA CONSTRUCTION"},11]
["LOGISTICAL ENTERPRISES",-4142,595398.29,"F",1,{"$f":"fetchcomment(E181)","v":"04-0Q30U4"},1,{"$f":"fetchcomment(G181)","v":"BAY CITIES PAVING & GRADING, INC."},4]
["MCCULLOUGH CONSTRUCTION INC",-4142,10312056.140000001,"F",1,{"$f":"fetchcomment(E182)","v":"01-0J4104"},1,{"$f":"fetchcomment(G182)","v":"MCCULLOUGH CONSTRUCTION INC"},11]
["MCW TRAFFIC CONTROL",-4142,284525,"F",2,{"$f":"fetchcomment(E183)","v":"04-0Q30U4\n10-1C4004"},2,{"$f":"fetchcomment(G183)","v":"BAY CITIES PAVING & GRADING, INC.\nMIDSTATE BARRIER, INC."},"4, 10"]
["MOUNTAINVIEW BIOLOGICAL",-4142,16766.25,"F",1,{"$f":"fetchcomment(E184)","v":"08-1L6404"},1,{"$f":"fetchcomment(G184)","v":"BC RENTAL LLC DBA BC TRAFFIC"},8]
["NATURAL RESOURCES MANAGEMENT",-4142,16706.7,"F",2,{"$f":"fetchcomment(E185)","v":"01-0G1404\n01-0J4104"},2,{"$f":"fetchcomment(G185)","v":"MCCULLOUGH CONSTRUCTION INC\nSTEELHEAD CONSTRUCTORS JV"},1]
["PAVEMENT MANAGEMENT",-4142,83800,"F",3,{"$f":"fetchcomment(E186)","v":"04-0K2404\n04-0Q30U4\n05-1H6904"},2,{"$f":"fetchcomment(G186)","v":"BAY CITIES PAVING & GRADING, INC.\nDESILVA GATES CONSTRUCTION LLC "},"4,5"]
["PAYCO SPECIALTIES",-4142,410312,"F",3,{"$f":"fetchcomment(E187)","v":"07-353304\n11-422304\n12-0R2904"},3,{"$f":"fetchcomment(G187)","v":"HAZARD CONSTRUCTION ENGR\nPETERSON-CHASE GENERAL ENGINEERING CONST\nPOWELL CONSTRUCTORS INC"},"7, 11, 12"]
["PC&N CONSTRUCTION, INC.",-4142,529289.99,"F",4,{"$f":"fetchcomment(E188)","v":"04-2K1704\n04-4J4904\n05-1M4504\n10-1C4004"},4,{"$f":"fetchcomment(G188)","v":"GHILOTTI CONSTRUCTION COMPANY, INC.\nGHILOTTI BROS., INC.\nGORDON N. BALL, INC.\nMIDSTATE BARRIER, INC."},"4, 5, 10"]
["PLAYA SAFETY INC",-4142,68792.76999999999,"F",3,{"$f":"fetchcomment(E189)","v":"07-333004\n12-0R1904\n08-1L6404"},3,{"$f":"fetchcomment(G189)","v":"POWELL CONSTRUCTORS INC\nFERREIRA CONSTRUCTION CO., INC. \nBC RENTAL LLC"},"7,8,12"]
["ROLL N ROCK CONSTRUCTION",-4142,1585984.5,"F",8,{"$f":"fetchcomment(E190)","v":"01-0G1404\n01-434804\n01-0E0104\n01-0H0214\n01-0H1914\n03-0J8704\n03-0J9234\n04-2K1704"},6,{"$f":"fetchcomment(G190)","v":"MCM CONSTRUCTION, INC.\nSTEELHEAD CONSTRUCTORS JV\nMERCER FRASER COMPANY\nA TEICHERT AND SONS\nCENTRALCOAST FINANCIAL GROUP\nGHILOTTI CONSTRUCTION COMPANY, INC."},"1,3,4"]
["ROUCH REBAR",-4142,637333.48,"F",1,{"$f":"fetchcomment(E191)","v":"07-336004"},1,{"$f":"fetchcomment(G191)","v":"BEADOR CONSTRUCTION"},7]
["RUPERT CONSTRUCTION SUPPLY",33,1127643.02,"F",9,{"$f":"fetchcomment(E192)","v":"01-0H8104\n01-434804\n01-0H0214\n01-0H1914\n05-1K1204\n04-2K1704\n05-1C3604\n05-1M4504\n06-0U8804"},5,{"$f":"fetchcomment(G192)","v":"GHILOTTI CONSTRUCTION COMPANY, INC.\nMERCER FRASER COMPANY\nGORDON N BALL INC\nM.C.M. CONSTRUCTION, INC.\nSECURITY PAVING COMPANY, INC."},"1,4,5,6"]
["SUPER SEAL & STRIPE",-4142,1249633,"F",4,{"$f":"fetchcomment(E193)","v":"04-3K4404\n05-0C7324\n05-1J4604\n07-358804"},4,{"$f":"fetchcomment(G193)","v":"GRANITE CONSTRUCTION COMPANY\nGRANITE ROCK COMPANY\nO.C. JONES & SONS, INC.\nTRUESDELL CORPORATION OF CALIFORNIA, INC."},"4, 5, 7"]
["SURFACE PREP AND MAINTENANCE",-4142,96990,"F",1,{"$f":"fetchcomment(E194)","v":"03-0J9234"},1,{"$f":"fetchcomment(G194)","v":"CENTRAL COAST FINANCIAL GROUP"},3]
["T&S DVBE INC",33,3302148.88,"F",7,{"$f":"fetchcomment(E195)","v":"01-0G1404\n03-1J0104\n04-0K0704\n05-0C7324\n01-366004\n04-1J7804\n09-379304"},6,{"$f":"fetchcomment(G195)","v":"CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC.\nGRANITE CONSTRUCTION COMPANY\nST. FRANCIS ELECTRIC, LLC\nSTEELHEAD CONSTRUCTORS JV\nO.C. JONES & SONS, INC.\nHAT CREEK CONSTRUCTION & MATERIALS, INC."},"1, 3, 4, 5, 9"]
["TRI VALLEY WATER TRUCKS INC",43,3911916.3,"F",4,{"$f":"fetchcomment(E196)","v":"04-0K2404\n05-0C7324\n05-1H6904\n05-1H8104"},3,{"$f":"fetchcomment(G196)","v":"DESILVA GATES CONSTRUCTION LLC\nGRANITE CONSTRUCTION COMPANY\nA. TEICHERT & SON INC DBA TEICHERT CONSTRUCTION"},"4, 5"]
["TRIUMPH GEO-SYNTHETICS INC",33,131111.97999999998,"F",7,{"$f":"fetchcomment(E197)","v":"04-0Q30U4\n07-353304\n08-1H2004\n12-0Q2704\n07-336004\n05-1H8104\n07-322004"},6,{"$f":"fetchcomment(G197)","v":"AMES CONSTRUCTION INC\nBAY CITIES PAVING & GRADING, INC.\nGRIFFITH COMPANY\nPOWELL CONSTRUCTORS INC\nBEADOR CONSTRUCTION\nA. TEICHERT & SON INC DBA TEICHERT CONSTRUCTION"},"4,5,7,8,12"]
["TYRRELL RESOURCES",-4142,1773412,"F",9,{"$f":"fetchcomment(E198)","v":"01-0H8104\n01-434804\n04-0Q30U4\n05-0C7324\n01-366004\n03-0J8704\n05-1K1204\n05-1C3604\n06-0U8804"},7,null,"1,3,4,5"]
["VERIDICO GROUP INC",-4142,10035,"F",1,{"$f":"fetchcomment(E199)","v":"04-2Q2504"},1,null,4]
["WEST COAST WATER & TRUCKING",43,564412,"F",1,{"$f":"fetchcomment(E200)","v":"03-0J8704"},1,null,3]
[null,null,null,null,null,{"$f":"fetchcomment(E201)","v":""}]
[null,{"$f":"COUNTIF(B30:B201, \"33\")","v":22}]
[null,{"$f":"COUNTIF(B30:B201, \"43\")","v":19}]
[null,{"$f":"COUNTIF(B30:B201, \"-4142\")","v":105},null,null,null,null,{"$f":"fetchcomment(F204)","v":""}]
["Prime Name",null,"# of Contracts","Contract #","Prime Name","# of Contracts","Contract #"]
["A. TEICHERT & SON INC",null,2,{"$f":"fetchcomment(C206)","v":"03-0J8704\n05-1H8104"},"HAT CREEK CONSTRUCTION & MATERIALS, INC.                                                                                   ",1,{"$f":"fetchcomment(F206)","v":"09-379304"}]
["A.M. CONCRETE, INC.",null,1,{"$f":"fetchcomment(C207)","v":"07-306614"},"HAZARD CONSTRUCTION ENGR",1,{"$f":"fetchcomment(F207)","v":"11-422304"}]
["ACCURATE EARTHWORKS, INC.                                                                                                  ",null,1,{"$f":"fetchcomment(C208)","v":"04-2G4614"},"INTERNATIONAL LINE BUILDERS, INC.",2,{"$f":"fetchcomment(F208)","v":"08-1K7904\n12-0R5004"}]
["ALFARO COMMUNICATIONS CONSTRUCTION,INC",null,1,{"$f":"fetchcomment(C209)","v":"12-0R1504"},"J FRANCIS COMPANY",1,{"$f":"fetchcomment(F209)","v":"11-430444"}]
["AMERICAN CIVIL CONSTRUCTION",null,1,{"$f":"fetchcomment(C210)","v":"04-2Q2504"},"MARTINEZ LANDSCAPE CO., INC                                                                                                ",1,{"$f":"fetchcomment(F210)","v":"07-336804"}]
["AMES CONSTRUCTION INC",null,1,{"$f":"fetchcomment(C211)","v":"08-1H2004"},"MCCULLOUGH CONSTRUCTION INC                                                                                                ",1,{"$f":"fetchcomment(F211)","v":"01-0J4104"}]
["AUTOBAHN CONSTRUCTION INC.                                                                                                 ",null,1,{"$f":"fetchcomment(C212)","v":"07-322704"},"MCM CONSTRUCTION, INC.",2,{"$f":"fetchcomment(F212)","v":"01-434804\n05-1C3604"}]
["BAY CITIES PAVING & GRADING, INC.",null,2,{"$f":"fetchcomment(C213)","v":"04-0Q30U4\n04-4J9404"},"MERCER FRASER COMPANY",4,{"$f":"fetchcomment(F213)","v":"01-0E0104\n01-0E7904\n01-0H0214\n01-0H1914"}]
["BC RENTAL LLC",null,1,{"$f":"fetchcomment(C214)","v":"08-1L6404"},"MIDSTATE BARRIER, INC.",2,{"$f":"fetchcomment(F214)","v":"06-1C7404\n10-1C4004"}]
["BEADOR CONSTRUCTION COMPANY",null,1,{"$f":"fetchcomment(C215)","v":"07-336004"},"MIKE BROWN ELECTRIC",1,{"$f":"fetchcomment(F215)","v":"04-4K4004"}]
["CAL STRIPE INC",null,1,{"$f":"fetchcomment(C216)","v":"05-1M7404"},"O.C. JONES & SONS, INC.                                                                                                    ",3,{"$f":"fetchcomment(F216)","v":"04-3K4404\n04-0K4904\n04-1J7804"}]
["CAL VALLEY CONSTRUCTION, INC.                                                                                               ",null,1,{"$f":"fetchcomment(C217)","v":"06-0R2104"},"PETERSON-CHASE GENERAL ENGINEERING CONST                                                                                   ",1,{"$f":"fetchcomment(F217)","v":"12-0R2904"}]
["CALIFORNIA HIGHWAY CONSTRUCTION GROUP, INC. ",null,1,{"$f":"fetchcomment(C218)","v":"03-1J0104"},"PACIFIC INFRASTRUCTURE CONSTRUCTION",1,{"$f":"fetchcomment(F218)","v":"04-2K8104"}]
["CALPORTLAND CONSTRUCTION",null,1,{"$f":"fetchcomment(C219)","v":"05-1G9804"},"POWELL CONSTRUCTORS INC",4,{"$f":"fetchcomment(F219)","v":"07-333004\n07-353304\n07-204904\n07-322004"}]
["CALPROMAX ENGINEERING INC.",null,3,{"$f":"fetchcomment(C220)","v":"07-307024\n07-359704\n12-0R1804"},"PTM GENERAL ENGINEERING SERVICES, INC.",6,{"$f":"fetchcomment(F220)","v":"04-3J1404\n06-0W15V4\n07-352004\n07-354904\n07-352104\n04-2J9504"}]
["CENTRAL COAST FINANCIAL GROUP",null,1,{"$f":"fetchcomment(C221)","v":"03-0J9234"},"RE CHAFFEE CONSTRUCTION INC",1,{"$f":"fetchcomment(F221)","v":"07-319304"}]
["CROSSTOWN ELECTRICAL AND DATA,  INC.                                                                                       ",null,1,{"$f":"fetchcomment(C222)","v":"07-359504"},"RNR CONSTRUCTION, INC.                                                                                                     ",1,{"$f":"fetchcomment(F222)","v":"06-0W1704"}]
["DESILVA GATES CONSTRUCTION LLC                                                                                             ",null,2,{"$f":"fetchcomment(C223)","v":"04-0K2404\n05-1H6904"},"SECURITY PAVING COMPANY, INC.                                                                                              ",1]
["FEC FUTURE CONTRACTORS AND ENGINEERS, INC.                                                                             ",null,2,{"$f":"fetchcomment(C224)","v":"07-320104\n07-326204"},"SEMA CONSTRUCTION",1]
["FERREIRA CONSTRUCTION CO., INC.",null,1,{"$f":"fetchcomment(C225)","v":"12-0R1904"},"ST. FRANCIS ELECTRIC, LLC",1]
["GHILOTTI BROS., INC.                                                                                                    ",null,1,{"$f":"fetchcomment(C226)","v":"04-4J4904"},"S.T. RHOADES CONSTRUCTION",1]
["GHILOTTI CONSTRUCTION COMPANY, INC.",null,3,{"$f":"fetchcomment(C227)","v":"01-0H8104\n04-2G7404\n04-2K1704"},"STEELHEAD CONSTRUCTORS JV                                                                                                  ",1]
["GORDON N. BALL, INC.",null,4,{"$f":"fetchcomment(C228)","v":"05-1K0704\n05-1K1204\n04-0Q6804\n05-1M4504"},"TRUESDELL CORPORATION OF CALIFORNIA, INC.",1]
["GRANITE CONSTRUCTION COMPANY",null,3,{"$f":"fetchcomment(C229)","v":"05-0C7324\n05-1H9604\n01-366004"}]
["GRANITE ROCK COMPANY",null,2,{"$f":"fetchcomment(C230)","v":"04-3K4204\n05-1J4604"}]
["GRIFFITH COMPANY",null,2,{"$f":"fetchcomment(C231)","v":"12-0P9304\n12-0Q2704"}]
[]
["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"]