{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Company Profile","CC-257"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Instructions","index":0,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,1,66,17],[0,1,0,17],[59,1,59,17],[1,14,2,17],[1,1,2,13],[4,1,57,17]]}
[null,"U.S. Department of Labor\nMonthly Employment Utilization Report (CC-257 Report)"]
[null,"This report is authorized by Executive Order 11246, Sec. 203. Read the instructions prior to completing the form. All fields are required, unless marked optional.",null,null,null,null,null,null,null,null,null,null,null,null,"OMB Control Number: 1250-0NEW\nExpires: XX/XX/XXXX"]
[]
[]
[null,"\nBusinesses with a federal construction contract or subcontract and/or federally assisted construction contract or subcontract in excess of $10,000 must complete and submit a CC-257 report to the Office of Federal Contract Compliance Programs (OFCCP) on a monthly-basis. Each report is due on the 15th day of the month following the end of the reporting period described below. If this date falls on a weekend or Federal holiday, the report is due on the following business day.\n\nSubmitting the form electronically is the preferred submission method. Directions for electronic submission are available at [Placeholder for link to OFCCP website]. Businesses who prefer not to use this method have the option to send a PDF version of the report via email to ofccp-construction@dol.gov or via mail to the United States Department of Labor, Office of Federal Contract Compliance Programs, Division of Program Operations, 200 Constitution Ave NW, Room C-3325, Washington, DC 20210.\n\nProvide the following information in the report:\n\n1.  Name of Federal Contractor or Subcontractor – Official name of the contractor or subcontractor who has a construction contract with the U.S. Government or a contract funded in whole or in part with Federal funds.\n\n2.  Employer Identification Number (EIN) – Unique nine-digit numerical identifier used on Employer's Quarterly Federal Tax Return (U.S. Treasury Department Form 941).\n\n3.  Unique Entity ID (UEI) or Data Universal Numbering System (DUNS) Number – Provide the alphanumeric identifier assigned to the entity by the System for Award Management (SAM.gov). If the contractor or subcontractor has not yet completed the transition to UEI, provide the Data Universal Numbering System (DUNS) number. If neither is available, state \"unavailable.\"\n\n4.  Reporting Period – Contractors and subcontractors must report on the work hours and employee counts for each calendar month. In this field, indicate the calendar month covered by the report. The work hours provided in the report must cover this entire month. The employee counts provided in the report must reflect the employee count on the last day of the month.\n\n5.  Federal Funding Agency – U.S. Government agency funding project (in whole or in part); if more than one agency, list all.\n\n6.  Location of Contractor or Subcontractor – Registered address of the business.\n\t\n7.  Number of Covered Areas with Projects During the Reporting Period – Identify the number of covered areas (Standard Metropolitan Statistical Area (SMSA) or Economic Area (EA)) with projects during the reporting period. These are the geographic areas identified in the notice required under 41 CFR 60-4.2.\n\n8.  Company Official Submitting Report – Provide the first name, last name, title, phone number (including area code), and email address of the company official submitting the information.\n\n9.  Signature of Company Official – Provide the signature of the company official certifying the information. A typed signature is acceptable.\n\n10.  Date – Provide the date the report is signed.\n\nSubmit items 11 through 16 for each Covered Area where you have projects during the reporting period.\n\n11.  Covered Area (SMSA or EA) – Geographic area identified in the notice required under 41 CFR 60-4.2.\n\n12.  Type of entity - Indicate whether the entity providing the information is a prime contractor, subcontractor, or both in the Covered Area. Select one.\n\n13.  OFCCP Megaproject in SMSA/EA – Indicate whether the company performed work on a project designated by OFCCP as a Megaproject through its Mega Construction Project Program in the Covered Area. Select one.\n\n14.  Employee Counts - Identify the various construction trades for work being performed in the Covered Area in Item 11 and provide the number of trade employees by racial group, gender and classification (foreperson, journey workers, apprentices, trainees, and non-apprenticed laborers or helpers). See comments section below for reporting on non-binary employees.\n\n15.  Work Hours - Identify the various construction trades for work being performed in theCovered Area in item 11 and provide the work hours (up to 1 decimal in 6-minute increments) for trade employees by racial group, gender and classification (forepersons, journey workers, apprentices, trainees, and non-apprenticed laborers or helpers). For example, for 10 hours and 30 minutes, insert 10.5 hours. See comments section below for reporting on non-binary employees. \n\n16.  Comments (Optional) – Optional field. The contractor or subcontractor may use this field to share any additional context on their submission. This field should not be used for time-sensitive communications, communications regarding a compliance evaluation, or in lieu of an official notification to OFCCP. Contractors and subcontractors may also voluntarily use this field to report the information in Item 14 and Item 15 for non-binary employees (employees who do not identify as exclusively male or female). Contractors and subcontractors that voluntarily choose to report non-binary employees in the comments section should not account for these employees in the classification, employee count, work hours, gender or race/ethnicity totals provided in Item 14 and Item 15."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Public Burden Statement"]
[null,"According to the Paperwork Reduction Act (PRA) of 1995, as amended, no persons are required to respond to a collection of information unless it displays a valid OMB Control Number. Public reporting burden for this collection of information is estimated to average 1.5 hours, including time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and submitting the collection of information. If you have comments regarding the estimated reporting burden, or suggestions for reducing the burden, please send them to the OFCCP, Division of Policy and Program Development, 200 Constitution Avenue, N.W., Room C-3325, Washington, D.C. 20210, and reference OMB Control Number 1250-0NEW."]

{"sheet":"Company Profile","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,17,4,18],[3,9,3,18],[5,0,5,18],[6,0,6,18],[12,9,12,10],[12,2,12,8],[9,15,9,16],[9,17,9,18],[10,0,10,16],[10,17,10,18],[11,0,11,18],[12,0,12,1],[12,11,12,18],[9,0,9,3],[16,0,16,3],[16,4,16,14],[16,15,16,16],[16,17,16,18],[13,0,13,1],[13,9,13,10],[14,0,14,1],[13,2,13,8],[14,9,14,18],[13,11,13,18],[14,2,14,8],[15,0,15,18],[2,9,2,18],[0,0,0,18],[9,4,9,10],[9,11,9,12],[9,13,9,14],[4,9,4,12],[4,14,4,15],[4,0,4,5],[4,6,4,8],[2,0,2,8],[3,0,3,8],[7,0,7,18],[8,0,8,3],[8,4,8,18],[1,15,1,18],[1,0,1,14]]}
["Monthly Employment Utilization Report (CC-257 Report)"]
["This report is authorized by Executive Order 11246, Sec. 203. Read the instructions prior to completing the form. All fields are required, unless marked optional.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMB Control Number: 1250-0NEW\nExpires: XX/XX/XXXX"]
["1. Name of Federal Contractor or Subcontractor:",null,null,null,null,null,null,null,null,"2. Employee Identification Number (EIN):"]
[]
["3. Unique Entity ID (UEI) or Data Universal Numbering Systems (DUNS) Number, if UEI unavailable. State \"unavailable\" if neither available:",null,null,null,null,null," ",null,null,"4. Reporting Period",null,null,null,"From:",null,null,"To:"]
["5. Federal Funding Agency (list all that apply):"]
[]
["6. Location of Contractor or Subcontractor (Registered Address):"]
["Address"]
["City",null,null,null,null,null,null,null,null,null,null,"State",null,null,null,"Zip Code + 4"]
["7. Number of Covered Areas with projects during the reporting period.\nNote: If more than one covered area during the reporting period, you must add a new form for each covered area via the \"Add SMSA/EA\" button on the CC-257 tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["8. Company Official Submitting Report"]
["First Name:",null,null,null,null,null,null,null,null,"Title:"]
["Last Name:",null,null,null,null,null,null,null,null,"Phone Number (including Area Code):"]
["Email:"]
["I certify that the information, including any workforce demographic data, provided in this report is correct and true to the best of my knowledge and was prepared in conformity with the directions set forth in the form  and accompanying instructions."]
["9. Signature of Company Official:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10. Date:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"CC-257","index":2,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[77,0,77,18],[9,0,15,0],[16,0,21,0],[7,2,8,3],[7,4,8,5],[7,0,8,0],[42,2,43,3],[42,4,43,5],[42,6,43,7],[42,8,43,9],[42,0,43,0],[42,1,43,1],[22,0,27,0],[57,0,62,0],[7,1,8,1],[7,10,8,11],[75,0,75,1],[70,0,70,1],[7,14,8,15],[7,6,8,7],[7,8,8,9],[7,12,8,13],[71,0,71,1],[72,0,72,1],[74,0,74,1],[42,10,43,11],[42,12,43,13],[38,0,38,1],[73,0,73,1],[28,0,33,0],[63,0,68,0],[0,0,1,18],[3,13,3,18],[2,15,2,18],[2,0,2,14],[78,0,85,18],[34,0,34,1],[44,0,50,0],[42,14,43,15],[40,0,40,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[39,0,39,1],[41,0,41,18],[51,0,56,0],[69,0,69,1],[42,16,43,18],[4,13,5,18],[3,6,3,12],[4,6,5,12],[6,0,6,18],[7,16,8,18],[4,0,5,5],[3,0,3,5]]}
["Monthly Employment Utilization Report (CC-257 Report)"]
[]
["This report is authorized by Executive Order 11246, Sec. 203. Read the instructions prior to completing the form. All fields are required, unless marked optional.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMB Control Number: 1250-0NEW\nExpires: XX/XX/XXXX"]
["11. Covered Area",null,null,null,null,null,"12. Type of Entity",null,null,null,null,null,null,"13. Select whether OFCCP Megaproject in Covered Area"]
[""]
[]
["14. TOTAL NUMBER OF TRADE EMPLOYEES ON THE LAST DAY OF THE REPORTING PERIOD IN THE COVERED AREA"]
["Construction Trades (insert the construction trades being worked in the Covered Area. Include only one trade in each box).","Classification","Hispanic\nor\nLatino",null,"White\n(Not Hispanic or Latino)",null,"Black\n or \nAfrican American\n(Not Hispanic or Latino)",null,"Asian\n(Not Hispanic or Latino)",null,"Native Hawaiian\nor Other Pacific Islander\n(Not Hispanic or Latino)",null,"American Indian\nor\nAlaska Native\n(Not Hispanic or Latino)",null,"Two or More Races\n(Not Hispanic or Latino)",null,"TOTAL(s)"]
[]
[null,null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F","ALL"]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C11,E11,G11,I11,K11,M11,O11)","v":0},0,{"$f":"SUM(Q11:R11)","v":0}]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sub-Total",{"$f":"SUM(C11:C15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C16,E16,G16,I16,K16,M16,O16)","v":0},{"$f":"SUM(D16,F16,H16,J16,L16,N16,P16)","v":0},0]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C17,E17,G17,I17,K17,M17,O17)","v":0},0,0]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q21:R21)","v":0}]
[null,"Sub-Total",{"$f":"SUM(C17:C21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C22,E22,G22,I22,K22,M22,O22)","v":0},{"$f":"SUM(D22,F22,H22,J22,L22,N22,P22)","v":0},0]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C23,E23,G23,I23,K23,M23,O23)","v":0},0,{"$f":"SUM(Q23:R23)","v":0}]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sub-Total",{"$f":"SUM(C23:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C29,E29,G29,I29,K29,M29,O29)","v":0},0,{"$f":"SUM(Q29:R29)","v":0}]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sub-Total",{"$f":"SUM(C29:C33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Forepersons",null,{"$f":"SUMIF(B11:B34,\"Forepersons\",C11:C34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",D11:D34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",E11:E34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",F11:F34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",G11:G34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",H11:H34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",I11:I34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",J11:J34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",K11:K34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",L11:L34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",M11:M34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",N11:N34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",O11:O34)","v":0},{"$f":"SUMIF(B11:B34,\"Forepersons\",P11:P34)","v":0},{"$f":"SUM(C35,E35,G35,I35,K35,M35,O35)","v":0},{"$f":"SUM(D35,F35,H35,J35,L35,N35,P35)","v":0},{"$f":"SUM(Q35:R35)","v":0}]
["Total Journey Workers",null,{"$f":"SUMIF(B11:B34,\"Journey Workers\",C11:C34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",D11:D34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",E11:E34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",F11:F34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",G11:G34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",H11:H34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",I11:I34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",J11:J34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",K11:K34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",L11:L34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",M11:M34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",N11:N34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",O11:O34)","v":0},{"$f":"SUMIF(B11:B34,\"Journey Workers\",P11:P34)","v":0},0,0,0]
["Total Apprentices",null,{"$f":"SUMIF(B11:B34,\"Apprentices\",C11:C34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",D11:D34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",E11:E34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",F11:F34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",G11:G34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",H11:H34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",I11:I34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",J11:J34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",K11:K34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",L11:L34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",M11:M34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",N11:N34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",O11:O34)","v":0},{"$f":"SUMIF(B11:B34,\"Apprentices\",P11:P34)","v":0},0,0,0]
["Total Trainees",null,{"$f":"SUMIF(B11:B34,\"Trainees\",C11:C34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",D11:D34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",E11:E34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",F11:F34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",G11:G34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",H11:H34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",I11:I34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",J11:J34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",K11:K34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",L11:L34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",M11:M34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",N11:N34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",O11:O34)","v":0},{"$f":"SUMIF(B11:B34,\"Trainees\",P11:P34)","v":0},0,0,0]
["Total Non-apprenticed Laborers or Helpers",null,{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",C11:C34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",D11:D34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",E11:E34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",F11:F34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",G11:G34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",H11:H34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",I11:I34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",J11:J34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",K11:K34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",L11:L34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",M11:M34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",N11:N34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",O11:O34)","v":0},{"$f":"SUMIF(B11:B34,\"Non-apprenticed Laborers or Helpers\",P11:P34)","v":0},{"$f":"SUM(C39,E39,G39,I39,K39,M39,O39)","v":0},{"$f":"SUM(D39,F39,H39,J39,L39,N39,P39)","v":0},0]
["TOTAL NUMBER OF TRADE EMPLOYEES",null,{"$f":"SUM(C35:C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q40:R40)","v":0}]
["TOTAL PERCENTAGE",null,{"$f":"C40/S40","v":{"$error":"#DIV/0!"}},{"$f":"D40/S40","v":{"$error":"#DIV/0!"}},{"$f":"E40/S40","v":{"$error":"#DIV/0!"}},{"$f":"F40/S40","v":{"$error":"#DIV/0!"}},{"$f":"G40/S40","v":{"$error":"#DIV/0!"}},{"$f":"H40/S40","v":{"$error":"#DIV/0!"}},{"$f":"I40/S40","v":{"$error":"#DIV/0!"}},{"$f":"J40/S40","v":{"$error":"#DIV/0!"}},{"$f":"K40/S40","v":{"$error":"#DIV/0!"}},{"$f":"L40/S40","v":{"$error":"#DIV/0!"}},{"$f":"M40/S40","v":{"$error":"#DIV/0!"}},{"$f":"N40/S40","v":{"$error":"#DIV/0!"}},{"$f":"O40/S40","v":{"$error":"#DIV/0!"}},{"$f":"P40/S40","v":{"$error":"#DIV/0!"}},{"$f":"Q40/S40","v":{"$error":"#DIV/0!"}},{"$f":"R40/S40","v":{"$error":"#DIV/0!"}}]
["15. TOTAL CONSTRUCTION WORK HOURS IN THE COVERED AREA DURING THE REPORTING PERIOD"]
["Construction Trades (insert the construction trades being worked in the Covered Area. Include only one trade in each box).","Classification","Hispanic\nor\nLatino",null,"White\n(Not Hispanic or Latino)",null,"Black\n or \nAfrican American\n(Not Hispanic or Latino)",null,"Asian\n(Not Hispanic or Latino)",null,"Native Hawaiian\nor Other Pacific Islander\n(Not Hispanic or Latino)",null,"American Indian\nor\nAlaska Native\n(Not Hispanic or Latino)",null,"Two or More Races\n(Not Hispanic or Latino)",null,"TOTAL(s)"]
[]
[null,null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F","ALL"]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C46,E46,G46,I46,K46,M46,O46)","v":0},0,{"$f":"SUM(Q46:R46)","v":0}]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sub-Total",{"$f":"SUM(C46:C50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C51,E51,G51,I51,K51,M51,O51)","v":0},{"$f":"SUM(D51,F51,H51,J51,L51,N51,P51)","v":0},0]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C52,E52,G52,I52,K52,M52,O52)","v":0},{"$f":"SUM(D52,F52,H52,H52,J52,L52,N52,P52)","v":0},0]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D53,F53,H53,J53,L53,N53,P53)","v":0},0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D54,F54,H54,J54,L54,N54,P54)","v":0},0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D55,F55,H55,J55,L55,N55,P55)","v":0},0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D56,F56,H56,J56,L56,N56,P56)","v":0},{"$f":"SUM(Q56:R56)","v":0}]
[null,"Sub-Total",{"$f":"SUM(C52:C56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D57,F57,H57,J57,L57,N57,P57)","v":0},{"$f":"SUM(Q57:R57)","v":0}]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C58,E58,G58,I58,K58,M58,O58)","v":0},0,{"$f":"SUM(Q58:R58)","v":0}]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sub-Total",{"$f":"SUM(C58:C62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C63,E63,G63,I63,K63,M63,O63)","v":0},0,0]
[null,"Forepersons",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q64:R64)","v":0}]
[null,"Journey Workers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Apprentices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trainees",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Non-apprenticed Laborers or Helpers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sub-Total",{"$f":"SUM(C64:C68)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Forepersons",null,{"$f":"SUMIF(B46:B69,\"Forepersons\",C46:C69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",D46:D69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",E46:E69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",F46:F69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",G46:G69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",H46:H69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",I46:I69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",J46:J69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",K46:K69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",L46:L69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",M46:M69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",N46:N69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",O46:O69)","v":0},{"$f":"SUMIF(B46:B69,\"Forepersons\",P46:P69)","v":0},{"$f":"SUM(C70,E70,G70,I70,K70,M70,O70)","v":0},{"$f":"SUM(D70,F70,H70,J70,L70,N70,P70)","v":0},{"$f":"SUM(Q70:R70)","v":0}]
["Total Journey Workers",null,{"$f":"SUMIF(B46:B69,\"Journey Workers\",C46:C69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",D46:D69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",E46:E69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",F46:F69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",G46:G69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",H46:H69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",I46:I69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",J46:J69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",K46:K69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",L46:L69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",M46:M69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",N46:N69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",O46:O69)","v":0},{"$f":"SUMIF(B46:B69,\"Journey Workers\",P46:P69)","v":0},0,0,0]
["Total Apprentices",null,{"$f":"SUMIF(B46:B69,\"Apprentices\",C46:C69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",D46:D69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",E46:E69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",F46:F69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",G46:G69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",H46:H69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",I46:I69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",J46:J69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",K46:K69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",L46:L69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",M46:M69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",N46:N69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",O46:O69)","v":0},{"$f":"SUMIF(B46:B69,\"Apprentices\",P46:P69)","v":0},0,0,0]
["Total Trainees",null,{"$f":"SUMIF(B46:B69,\"Trainees\",C46:C69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",D46:D69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",E46:E69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",F46:F69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",G46:G69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",H46:H69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",I46:I69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",J46:J69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",K46:K69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",L46:L69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",M46:M69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",N46:N69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",O46:O69)","v":0},{"$f":"SUMIF(B46:B69,\"Trainees\",P46:P69)","v":0},0,0,0]
["Total Non-apprenticed Laborers or Helpers",null,{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",C46:C69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",D46:D69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",E46:E69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",F46:F69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",G46:G69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",H46:H69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",I46:I69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",J46:J69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",K46:K69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",L46:L69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",M46:M69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",N46:N69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",O46:O69)","v":0},{"$f":"SUMIF(B46:B69,\"Non-apprenticed Laborers or Helpers\",P46:P69)","v":0},{"$f":"SUM(C74,E74,G74,I74,K74,M74,O74)","v":0},{"$f":"SUM(D74,F74,H74,J74,L74,N74,P74)","v":0},0]
["TOTAL NUMBER OF WORK HOURS",null,{"$f":"SUM(C70:C74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL PERCENTAGE OF WORK HOURS",null,{"$f":"C75/S75","v":{"$error":"#DIV/0!"}},{"$f":"D75/S75","v":{"$error":"#DIV/0!"}},{"$f":"E75/S75","v":{"$error":"#DIV/0!"}},{"$f":"F75/S75","v":{"$error":"#DIV/0!"}},{"$f":"G75/S75","v":{"$error":"#DIV/0!"}},{"$f":"H75/S75","v":{"$error":"#DIV/0!"}},{"$f":"I75/S75","v":{"$error":"#DIV/0!"}},{"$f":"J75/S75","v":{"$error":"#DIV/0!"}},{"$f":"K75/S75","v":{"$error":"#DIV/0!"}},{"$f":"L75/S75","v":{"$error":"#DIV/0!"}},{"$f":"M75/S75","v":{"$error":"#DIV/0!"}},{"$f":"N75/S75","v":{"$error":"#DIV/0!"}},{"$f":"O75/S75","v":{"$error":"#DIV/0!"}},{"$f":"P75/S75","v":{"$error":"#DIV/0!"}},{"$f":"Q75/S75","v":{"$error":"#DIV/0!"}},{"$f":"R75/S75","v":{"$error":"#DIV/0!"}}]
[]
[]
[""]