{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["MUR","Monthly Utilization Continued","AUR Continuation Sheet","MUR-AUR Instructions rev","JUR Continuation Sheet","MUR-AUR Instructions","Trades Definitions","Macro Security","MUR-AUR Instr working","Instructions","data transport"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":195,"comments":5,"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":"MUR","index":0,"n_rows":172,"n_cols":23,"rows_kept":172,"cut":false,"hidden":false,"merged":[[83,11,83,12],[84,0,84,1],[84,2,84,5],[84,11,84,12],[85,0,85,1],[85,2,85,5],[85,11,85,12],[86,0,86,1],[86,2,86,5],[86,11,86,12],[120,2,120,8],[117,2,117,8],[39,14,39,15],[4,10,4,13],[37,12,37,13],[26,14,26,17],[10,16,10,17],[10,14,10,15],[27,14,27,15],[6,10,6,15],[62,4,62,5],[62,2,62,3],[61,2,61,13],[51,16,51,17],[51,14,51,15],[51,4,51,5],[62,14,62,15],[62,10,62,11],[51,8,51,9],[51,12,51,13],[39,16,39,17],[38,14,38,17],[27,16,27,17],[72,0,72,17],[0,1,0,17],[1,1,1,17],[90,11,90,12],[90,0,90,1],[90,2,90,5],[9,14,9,17],[94,0,94,1],[92,2,92,5],[94,2,94,5],[91,11,91,12],[93,2,93,5],[89,6,89,9],[92,11,92,12],[92,8,92,9],[93,8,93,9],[94,8,94,9],[73,6,73,9],[74,0,74,1],[74,2,74,5],[74,11,74,12],[62,16,62,17],[62,8,62,9],[75,0,75,1],[75,2,75,5],[102,2,102,5],[93,11,93,12],[94,11,94,12],[39,4,39,5],[50,2,50,13],[88,0,88,17],[93,0,93,1],[92,0,92,1],[98,2,98,5],[97,0,97,1],[96,0,96,1],[95,0,95,1],[97,2,97,5],[95,2,95,5],[96,2,96,5],[75,11,75,12],[76,0,76,1],[76,2,76,5],[76,11,76,12],[77,0,77,1],[77,2,77,5],[77,11,77,12],[78,0,78,1],[78,2,78,5],[91,2,91,5],[101,0,101,1],[100,2,100,5],[99,0,99,1],[101,2,101,5],[100,0,100,1],[50,14,50,17],[38,2,38,13],[61,14,61,17],[78,11,78,12],[79,0,79,1],[79,2,79,5],[79,11,79,12],[80,0,80,1],[80,2,80,5],[80,11,80,12],[81,0,81,1],[81,2,81,5],[81,11,81,12],[82,0,82,1],[82,2,82,5],[82,11,82,12],[83,0,83,1],[83,2,83,5],[118,16,118,17],[117,16,117,17],[103,11,103,12],[104,2,104,3],[104,9,104,10],[104,11,104,12],[109,2,109,3],[118,12,118,15],[118,9,118,11],[117,9,117,11],[105,2,105,3],[105,9,105,10],[2,16,2,17],[4,15,4,17],[10,6,10,7],[10,2,10,3],[10,4,10,5],[9,2,9,13],[10,12,10,13],[2,1,2,3],[4,1,4,7],[5,1,5,7],[8,0,8,17],[10,8,10,9],[10,10,10,11],[39,12,39,13],[39,6,39,7],[27,2,27,3],[27,4,27,5],[27,6,27,7],[27,10,27,11],[39,8,39,9],[39,10,39,11],[28,0,28,1],[36,0,36,1],[27,8,27,9],[27,12,27,13],[48,0,48,1],[63,0,63,1],[52,0,52,1],[23,0,23,1],[51,6,51,7],[51,2,51,3],[59,0,59,1],[40,0,40,1],[39,2,39,3],[26,2,26,13],[62,12,62,13],[62,6,62,7],[107,11,107,12],[108,9,108,10],[51,10,51,11],[103,9,103,10],[102,0,102,1],[102,11,102,12],[99,2,99,5],[98,0,98,1],[96,11,96,12],[103,2,103,3],[90,8,90,9],[91,8,91,9],[70,0,70,1],[99,11,99,12],[98,11,98,12],[97,11,97,12],[95,11,95,12],[105,11,105,12],[106,2,106,3],[106,9,106,10],[106,11,106,12],[101,11,101,12],[100,11,100,12],[91,0,91,1],[119,16,119,17],[6,1,6,7],[2,6,2,7],[119,0,119,1],[117,0,117,1],[121,9,121,17],[119,2,119,8],[118,2,118,8],[121,2,121,8],[120,12,120,17],[117,12,117,15],[120,0,120,1],[121,0,121,1],[119,12,119,15],[108,11,108,12],[109,11,109,12],[22,0,22,1],[119,9,119,11],[120,9,120,11],[118,0,118,1],[107,2,107,3],[107,9,107,10],[108,2,108,3],[109,9,109,10],[101,8,101,9],[102,8,102,9],[90,15,102,15],[95,8,95,9],[96,8,96,9],[97,8,97,9],[98,8,98,9],[99,8,99,9],[100,8,100,9]]}
[null,"King County EEO Monthly Utilization Report and Apprenticeship Utilization Report "]
[null,"This form can be used as a tool to capture contractor Labor Hours which will then be reported online using the Contracts and Apprenticeship Report Tacking System (CARTS) http://info.kingcounty.gov/EXEC/contractreporting/Login.aspx "]
["King County Contract No",null,null,null,null,"Date Prepared",null,null,"Report Period",null,"Mo",null,"Yr",null,"Activity Status"]
[]
["PRIME Company Name",null,null,null,null,null,null,null,"Preparer Name",null,null,null,null,null,"Phone"]
[]
["Sub Company Name",null,null,null,null,null,null,null,"Preparer Email"]
[]
["MONTHLY UTILIZATION REPORT"]
[null,null,"Report TOTAL work HOURS including APPRENTICE HOURS in this section",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY","Type","M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F","IsOtherTrade"]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A13\")<>\"Carpenter\")*(INDIRECT(\"A13\")<>\"Electrician\")*(INDIRECT(\"A13\")<>\"Laborer\")*(INDIRECT(\"A13\")<>\"Equipment Operator\")*(INDIRECT(\"A13\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A14\")<>\"Carpenter\")*(INDIRECT(\"A14\")<>\"Electrician\")*(INDIRECT(\"A14\")<>\"Laborer\")*(INDIRECT(\"A14\")<>\"Equipment Operator\")*(INDIRECT(\"A14\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A15\")<>\"Carpenter\")*(INDIRECT(\"A15\")<>\"Electrician\")*(INDIRECT(\"A15\")<>\"Laborer\")*(INDIRECT(\"A15\")<>\"Equipment Operator\")*(INDIRECT(\"A15\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A16\")<>\"Carpenter\")*(INDIRECT(\"A16\")<>\"Electrician\")*(INDIRECT(\"A16\")<>\"Laborer\")*(INDIRECT(\"A16\")<>\"Equipment Operator\")*(INDIRECT(\"A16\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"a17\")<>\"Carpenter\")*(INDIRECT(\"a17\")<>\"Electrician\")*(INDIRECT(\"a17\")<>\"Laborer\")*(INDIRECT(\"a17\")<>\"Equipment Operator\")*(INDIRECT(\"a17\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"a18\")<>\"Carpenter\")*(INDIRECT(\"a18\")<>\"Electrician\")*(INDIRECT(\"a18\")<>\"Laborer\")*(INDIRECT(\"a18\")<>\"Equipment Operator\")*(INDIRECT(\"a18\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"a19\")<>\"Carpenter\")*(INDIRECT(\"a19\")<>\"Electrician\")*(INDIRECT(\"a19\")<>\"Laborer\")*(INDIRECT(\"a19\")<>\"Equipment Operator\")*(INDIRECT(\"a19\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"a20\")<>\"Carpenter\")*(INDIRECT(\"a20\")<>\"Electrician\")*(INDIRECT(\"a20\")<>\"Laborer\")*(INDIRECT(\"a20\")<>\"Equipment Operator\")*(INDIRECT(\"a20\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"a21\")<>\"Carpenter\")*(INDIRECT(\"a21\")<>\"Electrician\")*(INDIRECT(\"a21\")<>\"Laborer\")*(INDIRECT(\"a21\")<>\"Equipment Operator\")*(INDIRECT(\"a21\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"a22\")<>\"Carpenter\")*(INDIRECT(\"a22\")<>\"Electrician\")*(INDIRECT(\"a22\")<>\"Laborer\")*(INDIRECT(\"a22\")<>\"Equipment Operator\")*(INDIRECT(\"a22\")<>\"-- select a trade --\")","v":0}]
["All Non-Trade"]
["TOTAL",null,{"$f":"SUM(C13:C23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["MONTHLY UTILIZATION REPORT (calculated data)"]
[null,null,"Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY",null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F"]
[null,"column code >>","mbm","mbf","mhm","mhf","mam","maf","mnm","mnf","mdm","mdf","mom","mof","mmm","mmf","mtm","mtf"]
["Carpenter","c",{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"C13:C22\")))+'Monthly Utilization Continued'!C5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"D13:D22\"))+'Monthly Utilization Continued'!D5)","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"E13:E22\")))+'Monthly Utilization Continued'!E5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"F13:F22\")))+'Monthly Utilization Continued'!F5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"G13:G22\")))+'Monthly Utilization Continued'!G5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"H13:H22\")))+'Monthly Utilization Continued'!H5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"I13:I22\")))+'Monthly Utilization Continued'!I5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"J13:J22\")))+'Monthly Utilization Continued'!J5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"K13:K22\")))+'Monthly Utilization Continued'!K5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"L13:L22\")))+'Monthly Utilization Continued'!L5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"M13:M22\")))+'Monthly Utilization Continued'!M5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"N13:N22\")))+'Monthly Utilization Continued'!N5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"O13:O22\")))+'Monthly Utilization Continued'!O5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"P13:P22\")))+'Monthly Utilization Continued'!P5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"Q13:Q22\")))+'Monthly Utilization Continued'!Q5","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Carpenter\"),INDIRECT(\"R13:R22\")))+'Monthly Utilization Continued'!R5","v":0},"c"]
["Electrician","e",{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"C13:C22\")))+'Monthly Utilization Continued'!C6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"D13:D22\"))+'Monthly Utilization Continued'!D6)","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"E13:E22\")))+'Monthly Utilization Continued'!E6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"F13:F22\")))+'Monthly Utilization Continued'!F6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"G13:G22\")))+'Monthly Utilization Continued'!G6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"H13:H22\")))+'Monthly Utilization Continued'!H6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"I13:I22\")))+'Monthly Utilization Continued'!I6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"J13:J22\")))+'Monthly Utilization Continued'!J6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"K13:K22\")))+'Monthly Utilization Continued'!K6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"L13:L22\")))+'Monthly Utilization Continued'!L6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"M13:M22\")))+'Monthly Utilization Continued'!M6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"N13:N22\")))+'Monthly Utilization Continued'!N6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"O13:O22\")))+'Monthly Utilization Continued'!O6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"P13:P22\")))+'Monthly Utilization Continued'!P6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"Q13:Q22\")))+'Monthly Utilization Continued'!Q6","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Electrician\"),INDIRECT(\"R13:R22\")))+'Monthly Utilization Continued'!R6","v":0},"e"]
["Labor","l",{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"C13:C22\")))+'Monthly Utilization Continued'!C7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"D13:D22\"))+'Monthly Utilization Continued'!D7)","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"E13:E22\")))+'Monthly Utilization Continued'!E7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"F13:F22\")))+'Monthly Utilization Continued'!F7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"G13:G22\")))+'Monthly Utilization Continued'!G7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"H13:H22\")))+'Monthly Utilization Continued'!H7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"I13:I22\")))+'Monthly Utilization Continued'!I7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"J13:J22\")))+'Monthly Utilization Continued'!J7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"K13:K22\")))+'Monthly Utilization Continued'!K7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"L13:L22\")))+'Monthly Utilization Continued'!L7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"M13:M22\")))+'Monthly Utilization Continued'!M7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"N13:N22\")))+'Monthly Utilization Continued'!N7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"O13:O22\")))+'Monthly Utilization Continued'!O7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"P13:P22\")))+'Monthly Utilization Continued'!P7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"Q13:Q22\")))+'Monthly Utilization Continued'!Q7","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Laborer\"),INDIRECT(\"R13:R22\")))+'Monthly Utilization Continued'!R7","v":0},"l"]
["Equipment Operator","o",{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"C13:C22\")))+'Monthly Utilization Continued'!C8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"D13:D22\"))+'Monthly Utilization Continued'!D8)","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"E13:E22\")))+'Monthly Utilization Continued'!E8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"F13:F22\")))+'Monthly Utilization Continued'!F8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"G13:G22\")))+'Monthly Utilization Continued'!G8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"H13:H22\")))+'Monthly Utilization Continued'!H8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"I13:I22\")))+'Monthly Utilization Continued'!I8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"J13:J22\")))+'Monthly Utilization Continued'!J8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"K13:K22\")))+'Monthly Utilization Continued'!K8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"L13:L22\")))+'Monthly Utilization Continued'!L8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"M13:M22\")))+'Monthly Utilization Continued'!M8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"N13:N22\")))+'Monthly Utilization Continued'!N8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"O13:O22\")))+'Monthly Utilization Continued'!O8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"P13:P22\")))+'Monthly Utilization Continued'!P8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"Q13:Q22\")))+'Monthly Utilization Continued'!Q8","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$13:$a$22\")=\"Equipment Operator\"),INDIRECT(\"R13:R22\")))+'Monthly Utilization Continued'!R8","v":0},"o"]
["Other Trade","t",{"$f":"SUM(IF($S13:$S22,INDIRECT(\"C13:C22\")))+'Monthly Utilization Continued'!C9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"D13:D22\"))+'Monthly Utilization Continued'!D9)","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"E13:E22\")))+'Monthly Utilization Continued'!E9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"F13:F22\")))+'Monthly Utilization Continued'!F9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"G13:G22\")))+'Monthly Utilization Continued'!G9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"H13:H22\")))+'Monthly Utilization Continued'!H9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"I13:I22\")))+'Monthly Utilization Continued'!I9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"J13:J22\")))+'Monthly Utilization Continued'!J9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"K13:K22\")))+'Monthly Utilization Continued'!K9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"L13:L22\")))+'Monthly Utilization Continued'!L9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"M13:M22\")))+'Monthly Utilization Continued'!M9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"N13:N22\")))+'Monthly Utilization Continued'!N9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"O13:O22\")))+'Monthly Utilization Continued'!O9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"P13:P22\")))+'Monthly Utilization Continued'!P9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"Q13:Q22\")))+'Monthly Utilization Continued'!Q9","v":0},{"$f":"SUM(IF($S13:$S22,INDIRECT(\"R13:R22\")))+'Monthly Utilization Continued'!R9","v":0},"t"]
["All Non-Trade","n",{"$f":"INDIRECT(\"c18\")","v":0},{"$f":"INDIRECT(\"d18\")","v":0},{"$f":"INDIRECT(\"e18\")","v":0},{"$f":"INDIRECT(\"f18\")","v":0},{"$f":"INDIRECT(\"g18\")","v":0},{"$f":"INDIRECT(\"h18\")","v":0},{"$f":"INDIRECT(\"i18\")","v":0},{"$f":"INDIRECT(\"j18\")","v":0},{"$f":"INDIRECT(\"k18\")","v":0},{"$f":"INDIRECT(\"l18\")","v":0},{"$f":"INDIRECT(\"m18\")","v":0},{"$f":"INDIRECT(\"n18\")","v":0},{"$f":"INDIRECT(\"o18\")","v":0},{"$f":"INDIRECT(\"p18\")","v":0},{"$f":"INDIRECT(\"q18\")","v":0},{"$f":"INDIRECT(\"r18\")","v":0},"n"]
["TOTAL",null,{"$f":"SUM(C31:C36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["MONTHLY UTILIZATION REPORT (transport text - these are database source fields)",null,null,null,null,null,null,null,null,null,null,"rpttype",{"$f":"IF(Q3=\"One Time Only\",\"Final\",Q3)","v":0},null,"mo",{"$f":"IF(L3=0,\"\",L3)","v":""},"yr",{"$f":"TEXT(N3,\"0\")","v":"0"}]
[null,null,"Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY",null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F"]
[null,"column code >>","mbm","mbf","mhm","mhf","mam","maf","mnm","mnf","mdm","mdf","mom","mof","mmm","mmf","mtm","mtf"]
["Carpenter","c",{"$f":"TEXT(C31,0)","v":"0"},{"$f":"TEXT(D31,0)","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","c"]
["Electrician","e",{"$f":"TEXT(C32,0)","v":"0"},{"$f":"TEXT(D32,0)","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","e"]
["Labor","l",{"$f":"TEXT(C33,0)","v":"0"},{"$f":"TEXT(D33,0)","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","l"]
["Equipment Operator","o",{"$f":"TEXT(C34,0)","v":"0"},{"$f":"TEXT(D34,0)","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","o"]
["Other Trade","t",{"$f":"TEXT(C35,0)","v":"0"},{"$f":"TEXT(D35,\"0.0\")","v":"0.0"},{"$f":"TEXT(E35,0)","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","t"]
["All Non-Trade","n",{"$f":"TEXT(C36,0)","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","n"]
["TOTAL",null,{"$f":"SUM(C43:C48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["APPRENTICESHIP UTILIZATION REPORT (calculated data)",null,null,null,null,null,null,null,null,null,"Hiring Src:",null,"UH",{"$f":"COUNT(IF((INDIRECT(\"$K$71:$K$87\")=\"UH\")*$U92:$U103*$V92:$V103,INDIRECT(\"$R$71:$R$87\")))+'AUR Continuation Sheet'!N2","v":0},"CITC",{"$f":"COUNT(IF((INDIRECT(\"$K$71:$K$87\")=\"CITC\")*U92:U103*V92:V103,INDIRECT(\"$R$71:$R$87\")))+'AUR Continuation Sheet'!P2","v":0},"Other",{"$f":"COUNT(IF(U92:U103*V92:V103,(INDIRECT(\"R71:R87\"))))-N50-P50+'AUR Continuation Sheet'!R2+'AUR Continuation Sheet'!P2+'AUR Continuation Sheet'!N2","v":0}]
[null,null,"Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY",null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F"]
[null,"column code >>","abm","abf","ahm","ahf","aam","aaf","anm","anf","adm","adf","aom","aof","amm","amf"]
["Carpenter","c",{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!C6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!D6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!E6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!F6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!G6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!H6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!I6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!J6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!K6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!L6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!M6","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!N6","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!O6","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Carpenter\")*(INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!P6","v":0},"c"]
["Electrician","e",{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!C7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!D7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!E7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!F7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!G7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!H7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!I7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!J7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!K7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!L7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!M7","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!N7","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!O7","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Electrician\")*(INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!P7","v":0},"e"]
["Labor","l",{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!C8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!D8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!E8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!F8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!G8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!H8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!I8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!J8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!K8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!L8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!M8","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!N8","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!O8","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Laborer\")*(INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!P8","v":0},"l"]
["Equipment Operator","o",{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!C9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!D9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!E9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!F9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!G9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!H9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!I9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!J9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!K9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$C$76:$F$87\")=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!L9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!M9","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*($C$92:$F$103=\"Equipment Operator\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!N9","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Equipment Operator\")*(INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!O9","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$C$76:$F$87\")=\"Equipment Operator\")*(INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!P9","v":0},"o"]
["Other Trade","t",{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!C10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"B\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!D10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!E10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"H\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!F10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!G10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"A\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!H10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!I10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"N\")*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!J10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!K10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*($G$92:$G$103=\"Yes\")*(NOT(INDIRECT(\"$T$76:$T$87\")))*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!L10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$S$76:$S$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!M10","v":0},{"$f":"SUM(IF((INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$N$76:$N$87\")=\"O\")*NOT((INDIRECT(\"$G$76:$G$87\")=\"Yes\"))*(INDIRECT(\"$S$76:$S$87\"))*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!N10","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$O$76:$O$87\")=\"M\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!O10","v":0},{"$f":"COUNT(IF((INDIRECT(\"$W$76:$W$87\"))*(INDIRECT(\"$s$76:$s$87\"))*(INDIRECT(\"$O$76:$O$87\")=\"F\")*(INDIRECT(\"$U$76:$U$87\"))*(INDIRECT(\"$V$76:$V$87\")),INDIRECT(\"$R$76:$R$87\")))+'AUR Continuation Sheet'!P10","v":0},"t"]
["TOTAL",null,{"$f":"SUM(C55:C59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["APPRENTICESHIP UTILIZATION REPORT (transport text - these are database source fields)",null,null,null,null,null,null,null,null,null,"Hiring Src:",null,"UH",{"$f":"TEXT(N50,\"0\")","v":"0"},"CITC",{"$f":"TEXT(P50,\"0\")","v":"0"},"Other",{"$f":"TEXT(R50,\"0\")","v":"0"}]
[null,null,"Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY",null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F"]
[null,"column code >>","abm","abf","ahm","ahf","aam","aaf","anm","anf","adm","adf","aom","aof","amm","amf"]
["Carpenter","c",{"$f":"TEXT(C55,\"0\")","v":"0"},{"$f":"TEXT(D55,\"0\")","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","c"]
["Electrician","e",{"$f":"TEXT(C56,\"0\")","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","e"]
["Labor","l","0","0","0","0","0","0","0","0","0","0","0","0","0","0","l"]
["Equipment Operator","o","0","0","0","0","0","0","0","0","0","0","0","0","0","0","o"]
["Other Trade","t","0","0","0","0","0","0","0","0","0","0","0","0","0","0","t"]
["TOTAL",null,{"$f":"SUM(C66:C70)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["APPRENTICE WORKER REPORT"]
[null,null,null,null,null,null,"Yes or No",null,null,null,null,null,null,null,null,null,"Wages","Hours"]
["Last Name, First",null,"Trade",null,null,null,"D *","DY","NI","GJ","Hiring Source","S.A.C. ID NO.#",null,"Ethnicity","Gender","Skill Level","$/hr","Hrs"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[null,null,"-- select a trade --"]
[]
["JOURNEY UTILIZATIONS WORKER REPORT"]
[null,null,null,null,null,null,"Yes or No",null,null,null,null,null,null,null,null,null,"Wages","Hours"]
["Last Name, First",null,"Trade",null,null,null,"D *","DY","Zipcode",null,"Hiring Source","S.A.C. ID NO.#",null,"Ethnicity","Gender",null,"$/hr","Hrs","IsOtherTrade","IsMinority","IsNameTrade","IsHours","IsMinOrDisab"]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IsOtherTrade2","v":1},{"$f":"IsMinority2","v":0},{"$f":"IsNameTrade2","v":0},{"$f":"+R92>0","v":false},{"$f":"IsMinOrDisab","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,{"$f":"+R93>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,false,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["KEY"]
["B=Black",null,"P=Pacific Islander",null,null,null,null,null,null,"GJ=Graduated to Journey",null,null,"D*=Disabled (see note)",null,null,null,"M=Male"]
["H=Hispanic",null,"HTH=Helmets to Hardhats",null,null,null,null,null,null,"UH=Union Hall",null,null,"DY=Disadvantaged Youth",null,null,null,"F=Female"]
["A=Asian/Pacific Islander",null,"IEC=Independent Electrical Contractors",null,null,null,null,null,null,"UNK=Unknown",null,null,"NI-Newly Indentured"]
["N=Native American",null,"PACE=Pre-apprenticeship Construction Education",null,null,null,null,null,null,"YB=Youth Build",null,null,"CITC=Construction Industry Training Council"]
["O=white/Other",null,"SVI=Seattle Vocational Institute",null,null,null,null,null,null,"ANEW=Apprenticeship & Nontraditional Employment for Women"]
["* For disabled minorities, report as EITHER disabled or minority, but not both.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MUR-AUR 2018 02"]
[]
[]
["CATEGORY"]
["-- select a trade --"]
["Acoustical Worker"]
["Asbestos Worker"]
["Boilermaker"]
["Bricklayer"]
["Carpenter","Year","ReportType",null,"Ethnicity",null,"Sex","SkillLevel",null,"Hiring Source",null,"Month","Cat",null,"Choice"]
["Carpet, Linoleum, Soft Tile Layers",2016,"In Progress",null,"B",null,"M",1,null,"ANEW",null,"Jan","J",null,"Yes"]
["Cement Mason",2017,"Initial Report",null,"H",null,"F",2,null,"CITC",null,"Feb","A",null,"No"]
["Concrete Boom Pumper",2018,"No Activity",null,"A",null,null,3,null,"GJ",null,"Mar"]
["Diver",2019,"Final Report",null,"N",null,null,4,null,"HTH",null,"Apr"]
["Drywall Installer/taper",2020,"One Time Only",null,"O",null,null,5,null,"IEC",null,"May"]
["Electrician",2021,null,null,null,null,null,6,null,"PACE",null,"Jun"]
["Electrical Lineworker",2022,null,null,null,null,null,7,null,"SVI",null,"Jul"]
["Elevator Constructor",2023,null,null,null,null,null,8,null,"UH",null,"Aug"]
["Equipment Operator",null,null,null,null,null,null,9,null,"UNK",null,"Sep"]
["Fence Erector",null,null,null,null,null,null,10,null,"YB",null,"Oct"]
["Flagger",null,null,null,null,null,null,null,null,null,null,"Nov"]
["Floor Installers/Layers",null,null,null,null,null,null,null,null,null,null,"Dec"]
["Glaziers"]
["HVAC (Sheet Metal) Worker"]
["Insulation Worker"]
["Insulation (Heat and Frost) Worker"]
["Iron Worker"]
["Irrigation Pump Installer"]
["Laborer"]
["Landscaper"]
["Lather"]
["Millwright"]
["Painter"]
["Pile Driver Operator"]
["Pipefitter"]
["Plasterer"]
["Plumber"]
["Roofer"]
["Sprinkler Fitter"]
["Stone mason"]
["Structural steel fabricator"]
["Surveyor"]
["Teamster/Truck driver"]
["Telecommunications Technician"]
["Tile Finisher"]
["Tilesetter Installer"]
["Traffic control striper"]
["Tree Trimmers"]
["Well-drill operator"]
["Other Trade"]

{"sheet":"Monthly Utilization Continued","index":1,"n_rows":112,"n_cols":19,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,18,9,18],[10,0,10,17],[11,2,11,13],[11,14,11,17],[3,0,3,1],[4,0,4,1],[9,0,9,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[12,16,12,17],[8,0,8,1],[1,2,1,13],[1,14,1,17],[2,2,2,3],[2,4,2,5],[2,6,2,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[12,2,12,3],[12,4,12,5],[12,6,12,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17]]}
["MONTHLY UTILIZATION REPORT (continuation sheet)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hide these rows and columns in the production version of this form"]
[null,null,"Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY",null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F"]
["Carpenter",null,{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"c$15:c$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"d$15:d$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"e$15:e$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"f$15:f$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"g$15:g$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"h$15:h$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"i$15:i$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"j$15:j$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"k$15:k$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"l$15:l$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"m$15:m$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"n$15:n$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"o$15:o$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"p$15:p$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"q$15:q$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Carpenter\"),INDIRECT(\"r$15:r$63\")))","v":0}]
["Electrician",null,{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"c$15:c$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"d$15:d$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"e$15:e$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"f$15:f$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"g$15:g$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"h$15:h$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"i$15:i$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"j$15:j$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"k$15:k$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"l$15:l$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"m$15:m$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"n$15:n$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"o$15:o$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"p$15:p$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"q$15:q$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Electrician\"),INDIRECT(\"r$15:r$63\")))","v":0}]
["Laborer",null,{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"c$15:c$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"d$15:d$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"e$15:e$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"f$15:f$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"g$15:g$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"h$15:h$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"i$15:i$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"j$15:j$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"k$15:k$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"l$15:l$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"m$15:m$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"n$15:n$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"o$15:o$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"p$15:p$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"q$15:q$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Laborer\"),INDIRECT(\"r$15:r$63\")))","v":0}]
["Equipment Operator",null,{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"c$15:c$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"d$15:d$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"e$15:e$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"f$15:f$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"g$15:g$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"h$15:h$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"i$15:i$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"j$15:j$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"k$15:k$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"l$15:l$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"m$15:m$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"n$15:n$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"o$15:o$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"p$15:p$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"q$15:q$63\")))","v":0},{"$f":"SUM(IF((INDIRECT(\"$a$15:$a$63\")=\"Equipment Operator\"),INDIRECT(\"r$15:r$63\")))","v":0}]
["Other Trade",null,{"$f":"SUM(IF($S15:$S63,INDIRECT(\"c$15:c$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"d$15:d$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"e$15:e$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"f$15:f$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"g$15:g$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"h$15:h$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"i$15:i$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"j$15:j$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"k$15:k$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"l$15:l$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"m$15:m$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"n$15:n$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"o$15:o$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"p$15:p$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"q$15:q$63\")))","v":0},{"$f":"SUM(IF($S15:$S63,INDIRECT(\"r$15:r$63\")))","v":0}]
["TOTAL",null,{"$f":"SUM(C5:C9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q5:Q9)","v":0},{"$f":"SUM(R5:R9)","v":0}]
["MONTHLY UTILIZATION REPORT (continuation sheet)"]
[null,null,"Work HOURS Work HOURS Work HOURS Work HOURS Work HOURS Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY","Type","M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F","IsOtherTrade"]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A15\")<>\"Carpenter\")*(INDIRECT(\"A15\")<>\"Electrician\")*(INDIRECT(\"A15\")<>\"Laborer\")*(INDIRECT(\"A15\")<>\"Equipment Operator\")*(INDIRECT(\"A15\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A16\")<>\"Carpenter\")*(INDIRECT(\"A16\")<>\"Electrician\")*(INDIRECT(\"A16\")<>\"Laborer\")*(INDIRECT(\"A16\")<>\"Equipment Operator\")*(INDIRECT(\"A16\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A17\")<>\"Carpenter\")*(INDIRECT(\"A17\")<>\"Electrician\")*(INDIRECT(\"A17\")<>\"Laborer\")*(INDIRECT(\"A17\")<>\"Equipment Operator\")*(INDIRECT(\"A17\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A18\")<>\"Carpenter\")*(INDIRECT(\"A18\")<>\"Electrician\")*(INDIRECT(\"A18\")<>\"Laborer\")*(INDIRECT(\"A18\")<>\"Equipment Operator\")*(INDIRECT(\"A18\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A19\")<>\"Carpenter\")*(INDIRECT(\"A19\")<>\"Electrician\")*(INDIRECT(\"A19\")<>\"Laborer\")*(INDIRECT(\"A19\")<>\"Equipment Operator\")*(INDIRECT(\"A19\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A20\")<>\"Carpenter\")*(INDIRECT(\"A20\")<>\"Electrician\")*(INDIRECT(\"A20\")<>\"Laborer\")*(INDIRECT(\"A20\")<>\"Equipment Operator\")*(INDIRECT(\"A20\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A21\")<>\"Carpenter\")*(INDIRECT(\"A21\")<>\"Electrician\")*(INDIRECT(\"A21\")<>\"Laborer\")*(INDIRECT(\"A21\")<>\"Equipment Operator\")*(INDIRECT(\"A21\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A22\")<>\"Carpenter\")*(INDIRECT(\"A22\")<>\"Electrician\")*(INDIRECT(\"A22\")<>\"Laborer\")*(INDIRECT(\"A22\")<>\"Equipment Operator\")*(INDIRECT(\"A22\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A23\")<>\"Carpenter\")*(INDIRECT(\"A23\")<>\"Electrician\")*(INDIRECT(\"A23\")<>\"Laborer\")*(INDIRECT(\"A23\")<>\"Equipment Operator\")*(INDIRECT(\"A23\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A24\")<>\"Carpenter\")*(INDIRECT(\"A24\")<>\"Electrician\")*(INDIRECT(\"A24\")<>\"Laborer\")*(INDIRECT(\"A24\")<>\"Equipment Operator\")*(INDIRECT(\"A24\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A25\")<>\"Carpenter\")*(INDIRECT(\"A25\")<>\"Electrician\")*(INDIRECT(\"A25\")<>\"Laborer\")*(INDIRECT(\"A25\")<>\"Equipment Operator\")*(INDIRECT(\"A25\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A26\")<>\"Carpenter\")*(INDIRECT(\"A26\")<>\"Electrician\")*(INDIRECT(\"A26\")<>\"Laborer\")*(INDIRECT(\"A26\")<>\"Equipment Operator\")*(INDIRECT(\"A26\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A27\")<>\"Carpenter\")*(INDIRECT(\"A27\")<>\"Electrician\")*(INDIRECT(\"A27\")<>\"Laborer\")*(INDIRECT(\"A27\")<>\"Equipment Operator\")*(INDIRECT(\"A27\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A28\")<>\"Carpenter\")*(INDIRECT(\"A28\")<>\"Electrician\")*(INDIRECT(\"A28\")<>\"Laborer\")*(INDIRECT(\"A28\")<>\"Equipment Operator\")*(INDIRECT(\"A28\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A29\")<>\"Carpenter\")*(INDIRECT(\"A29\")<>\"Electrician\")*(INDIRECT(\"A29\")<>\"Laborer\")*(INDIRECT(\"A29\")<>\"Equipment Operator\")*(INDIRECT(\"A29\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A30\")<>\"Carpenter\")*(INDIRECT(\"A30\")<>\"Electrician\")*(INDIRECT(\"A30\")<>\"Laborer\")*(INDIRECT(\"A30\")<>\"Equipment Operator\")*(INDIRECT(\"A30\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A31\")<>\"Carpenter\")*(INDIRECT(\"A31\")<>\"Electrician\")*(INDIRECT(\"A31\")<>\"Laborer\")*(INDIRECT(\"A31\")<>\"Equipment Operator\")*(INDIRECT(\"A31\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A32\")<>\"Carpenter\")*(INDIRECT(\"A32\")<>\"Electrician\")*(INDIRECT(\"A32\")<>\"Laborer\")*(INDIRECT(\"A32\")<>\"Equipment Operator\")*(INDIRECT(\"A32\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A33\")<>\"Carpenter\")*(INDIRECT(\"A33\")<>\"Electrician\")*(INDIRECT(\"A33\")<>\"Laborer\")*(INDIRECT(\"A33\")<>\"Equipment Operator\")*(INDIRECT(\"A33\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A34\")<>\"Carpenter\")*(INDIRECT(\"A34\")<>\"Electrician\")*(INDIRECT(\"A34\")<>\"Laborer\")*(INDIRECT(\"A34\")<>\"Equipment Operator\")*(INDIRECT(\"A34\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A35\")<>\"Carpenter\")*(INDIRECT(\"A35\")<>\"Electrician\")*(INDIRECT(\"A35\")<>\"Laborer\")*(INDIRECT(\"A35\")<>\"Equipment Operator\")*(INDIRECT(\"A35\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A36\")<>\"Carpenter\")*(INDIRECT(\"A36\")<>\"Electrician\")*(INDIRECT(\"A36\")<>\"Laborer\")*(INDIRECT(\"A36\")<>\"Equipment Operator\")*(INDIRECT(\"A36\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A37\")<>\"Carpenter\")*(INDIRECT(\"A37\")<>\"Electrician\")*(INDIRECT(\"A37\")<>\"Laborer\")*(INDIRECT(\"A37\")<>\"Equipment Operator\")*(INDIRECT(\"A37\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A38\")<>\"Carpenter\")*(INDIRECT(\"A38\")<>\"Electrician\")*(INDIRECT(\"A38\")<>\"Laborer\")*(INDIRECT(\"A38\")<>\"Equipment Operator\")*(INDIRECT(\"A38\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A39\")<>\"Carpenter\")*(INDIRECT(\"A39\")<>\"Electrician\")*(INDIRECT(\"A39\")<>\"Laborer\")*(INDIRECT(\"A39\")<>\"Equipment Operator\")*(INDIRECT(\"A39\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A40\")<>\"Carpenter\")*(INDIRECT(\"A40\")<>\"Electrician\")*(INDIRECT(\"A40\")<>\"Laborer\")*(INDIRECT(\"A40\")<>\"Equipment Operator\")*(INDIRECT(\"A40\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A41\")<>\"Carpenter\")*(INDIRECT(\"A41\")<>\"Electrician\")*(INDIRECT(\"A41\")<>\"Laborer\")*(INDIRECT(\"A41\")<>\"Equipment Operator\")*(INDIRECT(\"A41\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A42\")<>\"Carpenter\")*(INDIRECT(\"A42\")<>\"Electrician\")*(INDIRECT(\"A42\")<>\"Laborer\")*(INDIRECT(\"A42\")<>\"Equipment Operator\")*(INDIRECT(\"A42\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A43\")<>\"Carpenter\")*(INDIRECT(\"A43\")<>\"Electrician\")*(INDIRECT(\"A43\")<>\"Laborer\")*(INDIRECT(\"A43\")<>\"Equipment Operator\")*(INDIRECT(\"A43\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A44\")<>\"Carpenter\")*(INDIRECT(\"A44\")<>\"Electrician\")*(INDIRECT(\"A44\")<>\"Laborer\")*(INDIRECT(\"A44\")<>\"Equipment Operator\")*(INDIRECT(\"A44\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A45\")<>\"Carpenter\")*(INDIRECT(\"A45\")<>\"Electrician\")*(INDIRECT(\"A45\")<>\"Laborer\")*(INDIRECT(\"A45\")<>\"Equipment Operator\")*(INDIRECT(\"A45\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A46\")<>\"Carpenter\")*(INDIRECT(\"A46\")<>\"Electrician\")*(INDIRECT(\"A46\")<>\"Laborer\")*(INDIRECT(\"A46\")<>\"Equipment Operator\")*(INDIRECT(\"A46\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A47\")<>\"Carpenter\")*(INDIRECT(\"A47\")<>\"Electrician\")*(INDIRECT(\"A47\")<>\"Laborer\")*(INDIRECT(\"A47\")<>\"Equipment Operator\")*(INDIRECT(\"A47\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A48\")<>\"Carpenter\")*(INDIRECT(\"A48\")<>\"Electrician\")*(INDIRECT(\"A48\")<>\"Laborer\")*(INDIRECT(\"A48\")<>\"Equipment Operator\")*(INDIRECT(\"A48\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A49\")<>\"Carpenter\")*(INDIRECT(\"A49\")<>\"Electrician\")*(INDIRECT(\"A49\")<>\"Laborer\")*(INDIRECT(\"A49\")<>\"Equipment Operator\")*(INDIRECT(\"A49\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A50\")<>\"Carpenter\")*(INDIRECT(\"A50\")<>\"Electrician\")*(INDIRECT(\"A50\")<>\"Laborer\")*(INDIRECT(\"A50\")<>\"Equipment Operator\")*(INDIRECT(\"A50\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A51\")<>\"Carpenter\")*(INDIRECT(\"A51\")<>\"Electrician\")*(INDIRECT(\"A51\")<>\"Laborer\")*(INDIRECT(\"A51\")<>\"Equipment Operator\")*(INDIRECT(\"A51\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A52\")<>\"Carpenter\")*(INDIRECT(\"A52\")<>\"Electrician\")*(INDIRECT(\"A52\")<>\"Laborer\")*(INDIRECT(\"A52\")<>\"Equipment Operator\")*(INDIRECT(\"A52\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A53\")<>\"Carpenter\")*(INDIRECT(\"A53\")<>\"Electrician\")*(INDIRECT(\"A53\")<>\"Laborer\")*(INDIRECT(\"A53\")<>\"Equipment Operator\")*(INDIRECT(\"A53\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A54\")<>\"Carpenter\")*(INDIRECT(\"A54\")<>\"Electrician\")*(INDIRECT(\"A54\")<>\"Laborer\")*(INDIRECT(\"A54\")<>\"Equipment Operator\")*(INDIRECT(\"A54\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A55\")<>\"Carpenter\")*(INDIRECT(\"A55\")<>\"Electrician\")*(INDIRECT(\"A55\")<>\"Laborer\")*(INDIRECT(\"A55\")<>\"Equipment Operator\")*(INDIRECT(\"A55\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A56\")<>\"Carpenter\")*(INDIRECT(\"A56\")<>\"Electrician\")*(INDIRECT(\"A56\")<>\"Laborer\")*(INDIRECT(\"A56\")<>\"Equipment Operator\")*(INDIRECT(\"A56\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A57\")<>\"Carpenter\")*(INDIRECT(\"A57\")<>\"Electrician\")*(INDIRECT(\"A57\")<>\"Laborer\")*(INDIRECT(\"A57\")<>\"Equipment Operator\")*(INDIRECT(\"A57\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A58\")<>\"Carpenter\")*(INDIRECT(\"A58\")<>\"Electrician\")*(INDIRECT(\"A58\")<>\"Laborer\")*(INDIRECT(\"A58\")<>\"Equipment Operator\")*(INDIRECT(\"A58\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A59\")<>\"Carpenter\")*(INDIRECT(\"A59\")<>\"Electrician\")*(INDIRECT(\"A59\")<>\"Laborer\")*(INDIRECT(\"A59\")<>\"Equipment Operator\")*(INDIRECT(\"A59\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A60\")<>\"Carpenter\")*(INDIRECT(\"A60\")<>\"Electrician\")*(INDIRECT(\"A60\")<>\"Laborer\")*(INDIRECT(\"A60\")<>\"Equipment Operator\")*(INDIRECT(\"A60\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A61\")<>\"Carpenter\")*(INDIRECT(\"A61\")<>\"Electrician\")*(INDIRECT(\"A61\")<>\"Laborer\")*(INDIRECT(\"A61\")<>\"Equipment Operator\")*(INDIRECT(\"A61\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A62\")<>\"Carpenter\")*(INDIRECT(\"A62\")<>\"Electrician\")*(INDIRECT(\"A62\")<>\"Laborer\")*(INDIRECT(\"A62\")<>\"Equipment Operator\")*(INDIRECT(\"A62\")<>\"-- select a trade --\")","v":0}]
["-- select a trade --","J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INDIRECT(\"A63\")<>\"Carpenter\")*(INDIRECT(\"A63\")<>\"Electrician\")*(INDIRECT(\"A63\")<>\"Laborer\")*(INDIRECT(\"A63\")<>\"Equipment Operator\")*(INDIRECT(\"A63\")<>\"-- select a trade --\")","v":0}]
["Subtotals",null,{"$f":"SUM(C15:C63)","v":0},{"$f":"SUM(D15:D63)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["CATEGORY",null,null,null,"Type"]
["-- select a trade --",null,null,null,"J"]
["Acoustical Worker",null,null,null,"A"]
["Asbestos Worker"]
["Boilermaker"]
["Bricklayer"]
["Carpenter"]
["Carpet, Linoleum, Soft Tile Layers"]
["Cement Mason"]
["Concrete Boom Pumper"]
["Diver"]
["Drywall Installer/taper"]
["Electrician"]
["Electrical Lineworker"]
["Elevator Constructor"]
["Equipment Operator"]
["Fence Erector"]
["Flagger"]
["Floor Installers/Layers"]
["Glaziers"]
["HVAC (Sheet Metal) Worker"]
["Insulation Worker"]
["Insulation (Heat and Frost) Worker"]
["Iron Worker"]
["Irrigation Pump Installer"]
["Laborer"]
["Landscaper"]
["Lather"]
["Millwright"]
["Painter"]
["Pile Driver Operator"]
["Pipefitter"]
["Plasterer"]
["Plumber"]
["Roofer"]
["Sprinkler Fitter"]
["Stone mason"]
["Structural steel fabricator"]
["Surveyor"]
["Teamster/Truck driver"]
["Telecommunications Technician"]
["Tile Finisher"]
["Tilesetter Installer"]
["Traffic control striper"]
["Tree Trimmers"]
["Well-drill operator"]
["Other Trade"]

{"sheet":"AUR Continuation Sheet","index":2,"n_rows":314,"n_cols":23,"rows_kept":314,"cut":false,"hidden":false,"merged":[[1,18,10,21],[217,0,217,1],[217,2,217,5],[217,11,217,12],[218,0,218,1],[218,2,218,5],[218,11,218,12],[215,0,215,1],[215,2,215,5],[215,11,215,12],[216,0,216,1],[216,2,216,5],[216,11,216,12],[219,0,219,1],[219,2,219,5],[219,11,219,12],[212,0,212,1],[212,2,212,5],[212,11,212,12],[213,0,213,1],[213,2,213,5],[213,11,213,12],[214,0,214,1],[214,2,214,5],[214,11,214,12],[209,0,209,1],[209,2,209,5],[209,11,209,12],[210,0,210,1],[210,2,210,5],[210,11,210,12],[211,0,211,1],[211,2,211,5],[211,11,211,12],[206,0,206,1],[206,2,206,5],[206,11,206,12],[207,0,207,1],[207,2,207,5],[207,11,207,12],[208,0,208,1],[208,2,208,5],[208,11,208,12],[203,0,203,1],[203,2,203,5],[203,11,203,12],[204,0,204,1],[204,2,204,5],[204,11,204,12],[205,0,205,1],[205,2,205,5],[205,11,205,12],[200,0,200,1],[200,2,200,5],[200,11,200,12],[201,0,201,1],[201,2,201,5],[201,11,201,12],[202,0,202,1],[202,2,202,5],[202,11,202,12],[197,0,197,1],[197,2,197,5],[197,11,197,12],[198,0,198,1],[198,2,198,5],[198,11,198,12],[199,0,199,1],[199,2,199,5],[199,11,199,12],[194,0,194,1],[194,2,194,5],[194,11,194,12],[195,0,195,1],[195,2,195,5],[195,11,195,12],[196,0,196,1],[196,2,196,5],[196,11,196,12],[191,0,191,1],[191,2,191,5],[191,11,191,12],[192,0,192,1],[192,2,192,5],[192,11,192,12],[193,0,193,1],[193,2,193,5],[193,11,193,12],[188,0,188,1],[188,2,188,5],[188,11,188,12],[189,0,189,1],[189,2,189,5],[189,11,189,12],[190,0,190,1],[190,2,190,5],[190,11,190,12],[185,0,185,1],[185,2,185,5],[185,11,185,12],[186,0,186,1],[186,2,186,5],[186,11,186,12],[187,0,187,1],[187,2,187,5],[187,11,187,12],[182,0,182,1],[182,2,182,5],[182,11,182,12],[183,0,183,1],[183,2,183,5],[183,11,183,12],[184,0,184,1],[184,2,184,5],[184,11,184,12],[179,0,179,1],[179,2,179,5],[179,11,179,12],[180,0,180,1],[180,2,180,5],[180,11,180,12],[181,0,181,1],[181,2,181,5],[181,11,181,12],[176,0,176,1],[176,2,176,5],[176,11,176,12],[177,0,177,1],[177,2,177,5],[177,11,177,12],[178,0,178,1],[178,2,178,5],[178,11,178,12],[173,0,173,1],[173,2,173,5],[173,11,173,12],[174,0,174,1],[174,2,174,5],[174,11,174,12],[175,0,175,1],[175,2,175,5],[175,11,175,12],[170,0,170,1],[170,2,170,5],[170,11,170,12],[171,0,171,1],[171,2,171,5],[171,11,171,12],[172,0,172,1],[172,2,172,5],[172,11,172,12],[167,0,167,1],[167,2,167,5],[167,11,167,12],[168,0,168,1],[168,2,168,5],[168,11,168,12],[169,0,169,1],[169,2,169,5],[169,11,169,12],[164,0,164,1],[164,2,164,5],[164,11,164,12],[165,0,165,1],[165,2,165,5],[165,11,165,12],[166,0,166,1],[166,2,166,5],[166,11,166,12],[161,0,161,1],[161,2,161,5],[161,11,161,12],[162,0,162,1],[162,2,162,5],[162,11,162,12],[163,0,163,1],[163,2,163,5],[163,11,163,12],[158,0,158,1],[158,2,158,5],[158,11,158,12],[159,0,159,1],[159,2,159,5],[159,11,159,12],[160,0,160,1],[160,2,160,5],[160,11,160,12],[155,0,155,1],[155,2,155,5],[155,11,155,12],[156,0,156,1],[156,2,156,5],[156,11,156,12],[157,0,157,1],[157,2,157,5],[157,11,157,12],[152,0,152,1],[152,2,152,5],[152,11,152,12],[153,0,153,1],[153,2,153,5],[153,11,153,12],[154,0,154,1],[154,2,154,5],[154,11,154,12],[149,0,149,1],[149,2,149,5],[149,11,149,12],[150,0,150,1],[150,2,150,5],[150,11,150,12],[151,0,151,1],[151,2,151,5],[151,11,151,12],[146,0,146,1],[146,2,146,5],[146,11,146,12],[147,0,147,1],[147,2,147,5],[147,11,147,12],[148,0,148,1],[148,2,148,5],[148,11,148,12],[143,0,143,1],[143,2,143,5],[143,11,143,12],[144,0,144,1],[144,2,144,5],[144,11,144,12],[145,0,145,1],[145,2,145,5],[145,11,145,12],[140,0,140,1],[140,2,140,5],[140,11,140,12],[141,0,141,1],[141,2,141,5],[141,11,141,12],[142,0,142,1],[142,2,142,5],[142,11,142,12],[137,0,137,1],[137,2,137,5],[137,11,137,12],[138,0,138,1],[138,2,138,5],[138,11,138,12],[139,0,139,1],[139,2,139,5],[139,11,139,12],[134,0,134,1],[134,2,134,5],[134,11,134,12],[135,0,135,1],[135,2,135,5],[135,11,135,12],[136,0,136,1],[136,2,136,5],[136,11,136,12],[131,0,131,1],[131,2,131,5],[131,11,131,12],[132,0,132,1],[132,2,132,5],[132,11,132,12],[133,0,133,1],[133,2,133,5],[133,11,133,12],[128,0,128,1],[128,2,128,5],[128,11,128,12],[129,0,129,1],[129,2,129,5],[129,11,129,12],[130,0,130,1],[130,2,130,5],[130,11,130,12],[125,0,125,1],[125,2,125,5],[125,11,125,12],[126,0,126,1],[126,2,126,5],[126,11,126,12],[127,0,127,1],[127,2,127,5],[127,11,127,12],[122,0,122,1],[122,2,122,5],[122,11,122,12],[123,0,123,1],[123,2,123,5],[123,11,123,12],[124,0,124,1],[124,2,124,5],[124,11,124,12],[119,0,119,1],[119,2,119,5],[119,11,119,12],[120,0,120,1],[120,2,120,5],[120,11,120,12],[121,0,121,1],[121,2,121,5],[121,11,121,12],[116,0,116,1],[116,2,116,5],[116,11,116,12],[117,0,117,1],[117,2,117,5],[117,11,117,12],[118,0,118,1],[118,2,118,5],[118,11,118,12],[113,0,113,1],[113,2,113,5],[113,11,113,12],[114,0,114,1],[114,2,114,5],[114,11,114,12],[115,0,115,1],[115,2,115,5],[115,11,115,12],[110,0,110,1],[110,2,110,5],[110,11,110,12],[111,0,111,1],[111,2,111,5],[111,11,111,12],[112,0,112,1],[112,2,112,5],[112,11,112,12],[107,0,107,1],[107,2,107,5],[107,11,107,12],[108,0,108,1],[108,2,108,5],[108,11,108,12],[109,0,109,1],[109,2,109,5],[109,11,109,12],[104,0,104,1],[104,2,104,5],[104,11,104,12],[105,0,105,1],[105,2,105,5],[105,11,105,12],[106,0,106,1],[106,2,106,5],[106,11,106,12],[101,0,101,1],[101,2,101,5],[101,11,101,12],[102,0,102,1],[102,2,102,5],[102,11,102,12],[103,0,103,1],[103,2,103,5],[103,11,103,12],[98,0,98,1],[98,2,98,5],[98,11,98,12],[99,0,99,1],[99,2,99,5],[99,11,99,12],[100,0,100,1],[100,2,100,5],[100,11,100,12],[95,0,95,1],[95,2,95,5],[95,11,95,12],[96,0,96,1],[96,2,96,5],[96,11,96,12],[97,0,97,1],[97,2,97,5],[97,11,97,12],[92,0,92,1],[92,2,92,5],[92,11,92,12],[93,0,93,1],[93,2,93,5],[93,11,93,12],[94,0,94,1],[94,2,94,5],[94,11,94,12],[89,0,89,1],[89,2,89,5],[89,11,89,12],[90,0,90,1],[90,2,90,5],[90,11,90,12],[91,0,91,1],[91,2,91,5],[91,11,91,12],[86,0,86,1],[86,2,86,5],[86,11,86,12],[87,0,87,1],[87,2,87,5],[87,11,87,12],[88,0,88,1],[88,2,88,5],[88,11,88,12],[83,0,83,1],[83,2,83,5],[83,11,83,12],[84,0,84,1],[84,2,84,5],[84,11,84,12],[85,0,85,1],[85,2,85,5],[85,11,85,12],[80,0,80,1],[80,2,80,5],[80,11,80,12],[81,0,81,1],[81,2,81,5],[81,11,81,12],[82,0,82,1],[82,2,82,5],[82,11,82,12],[77,0,77,1],[77,2,77,5],[77,11,77,12],[78,0,78,1],[78,2,78,5],[78,11,78,12],[79,0,79,1],[79,2,79,5],[79,11,79,12],[74,0,74,1],[74,2,74,5],[74,11,74,12],[75,0,75,1],[75,2,75,5],[75,11,75,12],[76,0,76,1],[76,2,76,5],[76,11,76,12],[71,0,71,1],[71,2,71,5],[71,11,71,12],[72,0,72,1],[72,2,72,5],[72,11,72,12],[73,0,73,1],[73,2,73,5],[73,11,73,12],[68,0,68,1],[68,2,68,5],[68,11,68,12],[69,0,69,1],[69,2,69,5],[69,11,69,12],[70,0,70,1],[70,2,70,5],[70,11,70,12],[65,0,65,1],[65,2,65,5],[65,11,65,12],[66,0,66,1],[66,2,66,5],[66,11,66,12],[67,0,67,1],[67,2,67,5],[67,11,67,12],[62,0,62,1],[62,2,62,5],[62,11,62,12],[63,0,63,1],[63,2,63,5],[63,11,63,12],[64,0,64,1],[64,2,64,5],[64,11,64,12],[59,0,59,1],[59,2,59,5],[59,11,59,12],[60,0,60,1],[60,2,60,5],[60,11,60,12],[61,0,61,1],[61,2,61,5],[61,11,61,12],[56,0,56,1],[56,2,56,5],[56,11,56,12],[57,0,57,1],[57,2,57,5],[57,11,57,12],[58,0,58,1],[58,2,58,5],[58,11,58,12],[53,0,53,1],[53,2,53,5],[53,11,53,12],[54,0,54,1],[54,2,54,5],[54,11,54,12],[55,0,55,1],[55,2,55,5],[55,11,55,12],[50,0,50,1],[50,2,50,5],[50,11,50,12],[51,0,51,1],[51,2,51,5],[51,11,51,12],[52,0,52,1],[52,2,52,5],[52,11,52,12],[47,0,47,1],[47,2,47,5],[47,11,47,12],[48,0,48,1],[48,2,48,5],[48,11,48,12],[49,0,49,1],[49,2,49,5],[49,11,49,12],[44,0,44,1],[44,2,44,5],[44,11,44,12],[45,0,45,1],[45,2,45,5],[45,11,45,12],[46,0,46,1],[46,2,46,5],[46,11,46,12],[41,0,41,1],[41,2,41,5],[41,11,41,12],[42,0,42,1],[42,2,42,5],[42,11,42,12],[43,0,43,1],[43,2,43,5],[43,11,43,12],[38,0,38,1],[38,2,38,5],[38,11,38,12],[39,0,39,1],[39,2,39,5],[39,11,39,12],[40,0,40,1],[40,2,40,5],[40,11,40,12],[35,0,35,1],[35,2,35,5],[35,11,35,12],[36,0,36,1],[36,2,36,5],[36,11,36,12],[37,0,37,1],[37,2,37,5],[37,11,37,12],[32,0,32,1],[32,2,32,5],[32,11,32,12],[33,0,33,1],[33,2,33,5],[33,11,33,12],[34,0,34,1],[34,2,34,5],[34,11,34,12],[29,0,29,1],[29,2,29,5],[29,11,29,12],[30,0,30,1],[30,2,30,5],[30,11,30,12],[31,0,31,1],[31,2,31,5],[31,11,31,12],[26,0,26,1],[26,2,26,5],[26,11,26,12],[27,0,27,1],[27,2,27,5],[27,11,27,12],[28,0,28,1],[28,2,28,5],[28,11,28,12],[23,0,23,1],[23,2,23,5],[23,11,23,12],[24,0,24,1],[24,2,24,5],[24,11,24,12],[25,0,25,1],[25,2,25,5],[25,11,25,12],[20,0,20,1],[20,2,20,5],[20,11,20,12],[21,0,21,1],[21,2,21,5],[21,11,21,12],[22,0,22,1],[22,2,22,5],[22,11,22,12],[16,2,16,5],[16,11,16,12],[17,0,17,1],[17,2,17,5],[17,11,17,12],[18,0,18,1],[18,2,18,5],[18,11,18,12],[19,0,19,1],[19,2,19,5],[19,11,19,12],[264,4,264,10],[264,16,264,17],[262,0,262,1],[263,0,263,1],[264,0,264,1],[264,2,264,3],[262,11,262,15],[263,11,263,15],[264,11,264,15],[262,4,262,10],[263,4,263,10],[262,2,262,3],[263,2,263,3],[235,0,235,1],[235,2,235,5],[238,0,238,1],[238,2,238,5],[253,9,253,10],[248,2,248,3],[248,9,248,10],[254,2,254,3],[254,9,254,10],[254,11,254,12],[252,2,252,3],[252,9,252,10],[252,11,252,12],[253,2,253,3],[229,2,229,5],[225,0,225,1],[225,2,225,5],[225,11,225,12],[226,0,226,1],[226,2,226,5],[226,11,226,12],[232,0,232,1],[232,2,232,5],[232,11,232,12],[233,0,233,1],[229,11,229,12],[230,0,230,1],[230,2,230,5],[230,11,230,12],[229,0,229,1],[238,11,238,12],[253,11,253,12],[250,2,250,3],[250,9,250,10],[250,11,250,12],[251,2,251,3],[251,9,251,10],[251,11,251,12],[227,2,227,5],[227,11,227,12],[239,2,239,5],[239,11,239,12],[231,2,231,5],[231,11,231,12],[237,2,237,5],[237,11,237,12],[235,11,235,12],[236,2,236,5],[236,11,236,12],[233,2,233,5],[233,11,233,12],[234,2,234,5],[234,11,234,12],[244,0,244,1],[244,2,244,5],[244,11,244,12],[245,0,245,1],[245,2,245,5],[245,11,245,12],[248,11,248,12],[249,2,249,3],[249,9,249,10],[249,11,249,12],[246,0,246,1],[246,2,246,5],[246,11,246,12],[247,0,247,1],[247,2,247,5],[247,11,247,12],[241,0,241,1],[241,2,241,5],[241,11,241,12],[242,0,242,1],[242,2,242,5],[242,11,242,12],[243,0,243,1],[243,2,243,5],[243,11,243,12],[228,0,228,1],[228,2,228,5],[228,11,228,12],[224,0,224,1],[224,2,224,5],[224,11,224,12],[223,0,223,1],[227,0,227,1],[240,0,240,1],[240,2,240,5],[240,11,240,12],[239,0,239,1],[231,0,231,1],[237,0,237,1],[236,0,236,1],[234,0,234,1],[2,14,2,17],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[11,0,11,17],[223,2,223,5],[223,11,223,12],[220,0,220,1],[220,2,220,5],[220,11,220,12],[221,0,221,1],[221,2,221,5],[221,11,221,12],[1,0,1,9],[222,0,222,1],[222,2,222,5],[222,11,222,12],[13,0,13,1],[13,2,13,5],[13,11,13,12],[14,0,14,1],[14,2,14,5],[14,11,14,12],[2,2,2,13],[12,6,12,9],[15,0,15,1],[15,2,15,5],[15,11,15,12],[16,0,16,1],[4,0,4,1],[5,0,5,1],[3,16,3,17],[10,0,10,1],[8,0,8,1],[9,0,9,1],[6,0,6,1],[7,0,7,1],[5,16,9,17]]}
[]
["APPRENTICESHIP UTILIZATION REPORT",null,null,null,null,null,null,null,null,null,"Hiring Src:",null,"UH",{"$f":"COUNT(IF(($K$15:$K$248=\"UH\")*U15:U248*V15:V248,$R$15:$R$248))","v":0},"CITC",{"$f":"COUNT(IF(($K$15:$K$248=\"CITC\")*U15:U248*V15:V248,$R$15:$R$248))","v":0},"Other",{"$f":"COUNT(IF(U15:U248*V15:V248,(R15:R248)))-N2-P2","v":0},"hide these rows  and columns in the production version of this form"]
[null,null,"Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY",null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F"]
["Carpenter",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Carpenter\")*U15:U248*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Carpenter\")*U15:U248*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0},"this count is already in the table above"]
["Electrician",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Electrician\")*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Electrician\")*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["Laborer",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Laborer\")*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Laborer\")*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["Equipment Operator",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Equipment Operator\")*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Equipment Operator\")*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["Other Trade",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*S15:S248*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*S15:S248*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["TOTAL",null,{"$f":"SUM(C6:C10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["APPRENTICE & JOURNEY UTILIZATION WORKER REPORT (Continuation Sheet)"]
[null,null,null,null,null,null,"Yes or No",null,null,null,null,null,null,null,null,null,"Wages","Hours"]
["Last Name, First",null,"Trade",null,null,null,"D *","DY","NI","GJ","HS","S.A.C. ID NO.#",null,"Ethnicity","Sex","Skill Level","$/hr","Hrs","IsOtherTrade","IsMinority","IsNameTrade","IsHours","IsMinOrDisab"]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},{"$f":"IsMinority","v":0},{"$f":"IsNameTrade","v":0},{"$f":"R15>0","v":false},{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R16>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},0,0,false,{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R80>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},0,0,false,{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R144>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},0,0,false,{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R208>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R221>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["KEY"]
["B=Black",null,"N=Native",null,"UH=Union Hall",null,null,null,null,null,null,"D*=Disabled (see note)",null,null,null,null,"M=Male"]
["H=Hispanic",null,"O=White/Other",null,"CITC=Construction Industry Training Council",null,null,null,null,null,null,"DY=Disadvantaged Youth",null,null,null,null,"F=Female"]
["A=Asian/Pacific Islander",null,null,null,null,null,null,null,null,null,null,"NI-Newly Indentured"]
["* For disabled minorities, report as EITHER diabled or minority, but not both."]
[]
["TRADES"]
["-- select a trade --"]
["Acoustical Worker"]
["Asbestos Worker"]
["Boilermaker"]
["Bricklayer"]
["Carpenter"]
["Carpet, Linoleum, Soft Tile Layers","Year","ReportType",null,"Ethnicity",null,"Sex","SkillLevel",null,"Hiring Source",null,null,null,null,"Choice"]
["Cement Mason",2003,"In Progress",null,"B",null,"M",1,null,"UH",null,null,null,null,"Yes"]
["Concrete Boom Pumper",2004,"Initial Report",null,"H",null,"F",2,null,"CITC",null,null,null,null,"No"]
["Diver",null,"No Activity",null,"A",null,null,3]
["Drywall Installer/taper",null,"Final Report",null,"N",null,null,4]
["Electrician",null,null,null,"O",null,null,5]
["Electrical Lineworker",null,null,null,null,null,null,6]
["Elevator Constructor",null,null,null,null,null,null,7]
["Equipment Operator",null,null,null,null,null,null,8]
["Fence Erector",null,null,null,null,null,null,9]
["Flagger",null,null,null,null,null,null,10]
["Floor Installers/Layers"]
["Glaziers"]
["HVAC (Sheet Metal) Worker"]
["Insulation Worker"]
["Insulation (Heat and Frost) Worker"]
["Iron Worker"]
["Irrigation Pump Installer"]
["Laborer"]
["Landscaper"]
["Lather"]
["Millwright"]
["Painter"]
["Pile Driver Operator"]
["Pipefitter"]
["Plasterer"]
["Plumber"]
["Roofer"]
["Sprinkler Fitter"]
["Stone mason"]
["Structural steel fabricator"]
["Surveyor"]
["Teamster/Truck driver"]
["Telecommunications Technician"]
["Tile Finisher"]
["Tilesetter Installer"]
["Traffic control striper"]
["Tree Trimmers"]
["Well-drill operator"]
["Other Trade"]

{"sheet":"MUR-AUR Instructions rev","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8]]}
["INSTRUCTIONS"]
["Applies to Apprenticeship and EEO Monthly Utilization Reports"]

{"sheet":"JUR Continuation Sheet","index":4,"n_rows":314,"n_cols":23,"rows_kept":314,"cut":false,"hidden":false,"merged":[[264,16,264,17],[263,0,263,1],[263,2,263,3],[263,4,263,10],[263,11,263,15],[264,0,264,1],[264,2,264,3],[264,4,264,10],[264,11,264,15],[253,2,253,3],[253,9,253,10],[253,11,253,12],[254,2,254,3],[254,9,254,10],[254,11,254,12],[262,0,262,1],[262,2,262,3],[262,4,262,10],[262,11,262,15],[250,2,250,3],[250,9,250,10],[250,11,250,12],[251,2,251,3],[251,9,251,10],[251,11,251,12],[252,2,252,3],[252,9,252,10],[252,11,252,12],[247,0,247,1],[247,2,247,5],[247,11,247,12],[248,2,248,3],[248,9,248,10],[248,11,248,12],[249,2,249,3],[249,9,249,10],[249,11,249,12],[244,0,244,1],[244,2,244,5],[244,11,244,12],[245,0,245,1],[245,2,245,5],[245,11,245,12],[246,0,246,1],[246,2,246,5],[246,11,246,12],[241,0,241,1],[241,2,241,5],[241,11,241,12],[242,0,242,1],[242,2,242,5],[242,11,242,12],[243,0,243,1],[243,2,243,5],[243,11,243,12],[238,0,238,1],[238,2,238,5],[238,11,238,12],[239,0,239,1],[239,2,239,5],[239,11,239,12],[240,0,240,1],[240,2,240,5],[240,11,240,12],[235,0,235,1],[235,2,235,5],[235,11,235,12],[236,0,236,1],[236,2,236,5],[236,11,236,12],[237,0,237,1],[237,2,237,5],[237,11,237,12],[232,0,232,1],[232,2,232,5],[232,11,232,12],[233,0,233,1],[233,2,233,5],[233,11,233,12],[234,0,234,1],[234,2,234,5],[234,11,234,12],[229,0,229,1],[229,2,229,5],[229,11,229,12],[230,0,230,1],[230,2,230,5],[230,11,230,12],[231,0,231,1],[231,2,231,5],[231,11,231,12],[226,0,226,1],[226,2,226,5],[226,11,226,12],[227,0,227,1],[227,2,227,5],[227,11,227,12],[228,0,228,1],[228,2,228,5],[228,11,228,12],[223,0,223,1],[223,2,223,5],[223,11,223,12],[224,0,224,1],[224,2,224,5],[224,11,224,12],[225,0,225,1],[225,2,225,5],[225,11,225,12],[220,0,220,1],[220,2,220,5],[220,11,220,12],[221,0,221,1],[221,2,221,5],[221,11,221,12],[222,0,222,1],[222,2,222,5],[222,11,222,12],[217,0,217,1],[217,2,217,5],[217,11,217,12],[218,0,218,1],[218,2,218,5],[218,11,218,12],[219,0,219,1],[219,2,219,5],[219,11,219,12],[214,0,214,1],[214,2,214,5],[214,11,214,12],[215,0,215,1],[215,2,215,5],[215,11,215,12],[216,0,216,1],[216,2,216,5],[216,11,216,12],[211,0,211,1],[211,2,211,5],[211,11,211,12],[212,0,212,1],[212,2,212,5],[212,11,212,12],[213,0,213,1],[213,2,213,5],[213,11,213,12],[208,0,208,1],[208,2,208,5],[208,11,208,12],[209,0,209,1],[209,2,209,5],[209,11,209,12],[210,0,210,1],[210,2,210,5],[210,11,210,12],[205,0,205,1],[205,2,205,5],[205,11,205,12],[206,0,206,1],[206,2,206,5],[206,11,206,12],[207,0,207,1],[207,2,207,5],[207,11,207,12],[202,0,202,1],[202,2,202,5],[202,11,202,12],[203,0,203,1],[203,2,203,5],[203,11,203,12],[204,0,204,1],[204,2,204,5],[204,11,204,12],[199,0,199,1],[199,2,199,5],[199,11,199,12],[200,0,200,1],[200,2,200,5],[200,11,200,12],[201,0,201,1],[201,2,201,5],[201,11,201,12],[196,0,196,1],[196,2,196,5],[196,11,196,12],[197,0,197,1],[197,2,197,5],[197,11,197,12],[198,0,198,1],[198,2,198,5],[198,11,198,12],[193,0,193,1],[193,2,193,5],[193,11,193,12],[194,0,194,1],[194,2,194,5],[194,11,194,12],[195,0,195,1],[195,2,195,5],[195,11,195,12],[190,0,190,1],[190,2,190,5],[190,11,190,12],[191,0,191,1],[191,2,191,5],[191,11,191,12],[192,0,192,1],[192,2,192,5],[192,11,192,12],[187,0,187,1],[187,2,187,5],[187,11,187,12],[188,0,188,1],[188,2,188,5],[188,11,188,12],[189,0,189,1],[189,2,189,5],[189,11,189,12],[184,0,184,1],[184,2,184,5],[184,11,184,12],[185,0,185,1],[185,2,185,5],[185,11,185,12],[186,0,186,1],[186,2,186,5],[186,11,186,12],[181,0,181,1],[181,2,181,5],[181,11,181,12],[182,0,182,1],[182,2,182,5],[182,11,182,12],[183,0,183,1],[183,2,183,5],[183,11,183,12],[178,0,178,1],[178,2,178,5],[178,11,178,12],[179,0,179,1],[179,2,179,5],[179,11,179,12],[180,0,180,1],[180,2,180,5],[180,11,180,12],[175,0,175,1],[175,2,175,5],[175,11,175,12],[176,0,176,1],[176,2,176,5],[176,11,176,12],[177,0,177,1],[177,2,177,5],[177,11,177,12],[172,0,172,1],[172,2,172,5],[172,11,172,12],[173,0,173,1],[173,2,173,5],[173,11,173,12],[174,0,174,1],[174,2,174,5],[174,11,174,12],[169,0,169,1],[169,2,169,5],[169,11,169,12],[170,0,170,1],[170,2,170,5],[170,11,170,12],[171,0,171,1],[171,2,171,5],[171,11,171,12],[166,0,166,1],[166,2,166,5],[166,11,166,12],[167,0,167,1],[167,2,167,5],[167,11,167,12],[168,0,168,1],[168,2,168,5],[168,11,168,12],[163,0,163,1],[163,2,163,5],[163,11,163,12],[164,0,164,1],[164,2,164,5],[164,11,164,12],[165,0,165,1],[165,2,165,5],[165,11,165,12],[160,0,160,1],[160,2,160,5],[160,11,160,12],[161,0,161,1],[161,2,161,5],[161,11,161,12],[162,0,162,1],[162,2,162,5],[162,11,162,12],[157,0,157,1],[157,2,157,5],[157,11,157,12],[158,0,158,1],[158,2,158,5],[158,11,158,12],[159,0,159,1],[159,2,159,5],[159,11,159,12],[154,0,154,1],[154,2,154,5],[154,11,154,12],[155,0,155,1],[155,2,155,5],[155,11,155,12],[156,0,156,1],[156,2,156,5],[156,11,156,12],[151,0,151,1],[151,2,151,5],[151,11,151,12],[152,0,152,1],[152,2,152,5],[152,11,152,12],[153,0,153,1],[153,2,153,5],[153,11,153,12],[148,0,148,1],[148,2,148,5],[148,11,148,12],[149,0,149,1],[149,2,149,5],[149,11,149,12],[150,0,150,1],[150,2,150,5],[150,11,150,12],[145,0,145,1],[145,2,145,5],[145,11,145,12],[146,0,146,1],[146,2,146,5],[146,11,146,12],[147,0,147,1],[147,2,147,5],[147,11,147,12],[142,0,142,1],[142,2,142,5],[142,11,142,12],[143,0,143,1],[143,2,143,5],[143,11,143,12],[144,0,144,1],[144,2,144,5],[144,11,144,12],[139,0,139,1],[139,2,139,5],[139,11,139,12],[140,0,140,1],[140,2,140,5],[140,11,140,12],[141,0,141,1],[141,2,141,5],[141,11,141,12],[136,0,136,1],[136,2,136,5],[136,11,136,12],[137,0,137,1],[137,2,137,5],[137,11,137,12],[138,0,138,1],[138,2,138,5],[138,11,138,12],[133,0,133,1],[133,2,133,5],[133,11,133,12],[134,0,134,1],[134,2,134,5],[134,11,134,12],[135,0,135,1],[135,2,135,5],[135,11,135,12],[130,0,130,1],[130,2,130,5],[130,11,130,12],[131,0,131,1],[131,2,131,5],[131,11,131,12],[132,0,132,1],[132,2,132,5],[132,11,132,12],[127,0,127,1],[127,2,127,5],[127,11,127,12],[128,0,128,1],[128,2,128,5],[128,11,128,12],[129,0,129,1],[129,2,129,5],[129,11,129,12],[124,0,124,1],[124,2,124,5],[124,11,124,12],[125,0,125,1],[125,2,125,5],[125,11,125,12],[126,0,126,1],[126,2,126,5],[126,11,126,12],[121,0,121,1],[121,2,121,5],[121,11,121,12],[122,0,122,1],[122,2,122,5],[122,11,122,12],[123,0,123,1],[123,2,123,5],[123,11,123,12],[118,0,118,1],[118,2,118,5],[118,11,118,12],[119,0,119,1],[119,2,119,5],[119,11,119,12],[120,0,120,1],[120,2,120,5],[120,11,120,12],[115,0,115,1],[115,2,115,5],[115,11,115,12],[116,0,116,1],[116,2,116,5],[116,11,116,12],[117,0,117,1],[117,2,117,5],[117,11,117,12],[112,0,112,1],[112,2,112,5],[112,11,112,12],[113,0,113,1],[113,2,113,5],[113,11,113,12],[114,0,114,1],[114,2,114,5],[114,11,114,12],[109,0,109,1],[109,2,109,5],[109,11,109,12],[110,0,110,1],[110,2,110,5],[110,11,110,12],[111,0,111,1],[111,2,111,5],[111,11,111,12],[106,0,106,1],[106,2,106,5],[106,11,106,12],[107,0,107,1],[107,2,107,5],[107,11,107,12],[108,0,108,1],[108,2,108,5],[108,11,108,12],[103,0,103,1],[103,2,103,5],[103,11,103,12],[104,0,104,1],[104,2,104,5],[104,11,104,12],[105,0,105,1],[105,2,105,5],[105,11,105,12],[100,0,100,1],[100,2,100,5],[100,11,100,12],[101,0,101,1],[101,2,101,5],[101,11,101,12],[102,0,102,1],[102,2,102,5],[102,11,102,12],[97,0,97,1],[97,2,97,5],[97,11,97,12],[98,0,98,1],[98,2,98,5],[98,11,98,12],[99,0,99,1],[99,2,99,5],[99,11,99,12],[94,0,94,1],[94,2,94,5],[94,11,94,12],[95,0,95,1],[95,2,95,5],[95,11,95,12],[96,0,96,1],[96,2,96,5],[96,11,96,12],[91,0,91,1],[91,2,91,5],[91,11,91,12],[92,0,92,1],[92,2,92,5],[92,11,92,12],[93,0,93,1],[93,2,93,5],[93,11,93,12],[88,0,88,1],[88,2,88,5],[88,11,88,12],[89,0,89,1],[89,2,89,5],[89,11,89,12],[90,0,90,1],[90,2,90,5],[90,11,90,12],[85,0,85,1],[85,2,85,5],[85,11,85,12],[86,0,86,1],[86,2,86,5],[86,11,86,12],[87,0,87,1],[87,2,87,5],[87,11,87,12],[82,0,82,1],[82,2,82,5],[82,11,82,12],[83,0,83,1],[83,2,83,5],[83,11,83,12],[84,0,84,1],[84,2,84,5],[84,11,84,12],[79,0,79,1],[79,2,79,5],[79,11,79,12],[80,0,80,1],[80,2,80,5],[80,11,80,12],[81,0,81,1],[81,2,81,5],[81,11,81,12],[76,0,76,1],[76,2,76,5],[76,11,76,12],[77,0,77,1],[77,2,77,5],[77,11,77,12],[78,0,78,1],[78,2,78,5],[78,11,78,12],[73,0,73,1],[73,2,73,5],[73,11,73,12],[74,0,74,1],[74,2,74,5],[74,11,74,12],[75,0,75,1],[75,2,75,5],[75,11,75,12],[70,0,70,1],[70,2,70,5],[70,11,70,12],[71,0,71,1],[71,2,71,5],[71,11,71,12],[72,0,72,1],[72,2,72,5],[72,11,72,12],[67,0,67,1],[67,2,67,5],[67,11,67,12],[68,0,68,1],[68,2,68,5],[68,11,68,12],[69,0,69,1],[69,2,69,5],[69,11,69,12],[64,0,64,1],[64,2,64,5],[64,11,64,12],[65,0,65,1],[65,2,65,5],[65,11,65,12],[66,0,66,1],[66,2,66,5],[66,11,66,12],[61,0,61,1],[61,2,61,5],[61,11,61,12],[62,0,62,1],[62,2,62,5],[62,11,62,12],[63,0,63,1],[63,2,63,5],[63,11,63,12],[58,0,58,1],[58,2,58,5],[58,11,58,12],[59,0,59,1],[59,2,59,5],[59,11,59,12],[60,0,60,1],[60,2,60,5],[60,11,60,12],[55,0,55,1],[55,2,55,5],[55,11,55,12],[56,0,56,1],[56,2,56,5],[56,11,56,12],[57,0,57,1],[57,2,57,5],[57,11,57,12],[52,0,52,1],[52,2,52,5],[52,11,52,12],[53,0,53,1],[53,2,53,5],[53,11,53,12],[54,0,54,1],[54,2,54,5],[54,11,54,12],[49,0,49,1],[49,2,49,5],[49,11,49,12],[50,0,50,1],[50,2,50,5],[50,11,50,12],[51,0,51,1],[51,2,51,5],[51,11,51,12],[46,0,46,1],[46,2,46,5],[46,11,46,12],[47,0,47,1],[47,2,47,5],[47,11,47,12],[48,0,48,1],[48,2,48,5],[48,11,48,12],[43,0,43,1],[43,2,43,5],[43,11,43,12],[44,0,44,1],[44,2,44,5],[44,11,44,12],[45,0,45,1],[45,2,45,5],[45,11,45,12],[40,0,40,1],[40,2,40,5],[40,11,40,12],[41,0,41,1],[41,2,41,5],[41,11,41,12],[42,0,42,1],[42,2,42,5],[42,11,42,12],[37,0,37,1],[37,2,37,5],[37,11,37,12],[38,0,38,1],[38,2,38,5],[38,11,38,12],[39,0,39,1],[39,2,39,5],[39,11,39,12],[34,0,34,1],[34,2,34,5],[34,11,34,12],[35,0,35,1],[35,2,35,5],[35,11,35,12],[36,0,36,1],[36,2,36,5],[36,11,36,12],[31,0,31,1],[31,2,31,5],[31,11,31,12],[32,0,32,1],[32,2,32,5],[32,11,32,12],[33,0,33,1],[33,2,33,5],[33,11,33,12],[28,0,28,1],[28,2,28,5],[28,11,28,12],[29,0,29,1],[29,2,29,5],[29,11,29,12],[30,0,30,1],[30,2,30,5],[30,11,30,12],[25,0,25,1],[25,2,25,5],[25,11,25,12],[26,0,26,1],[26,2,26,5],[26,11,26,12],[27,0,27,1],[27,2,27,5],[27,11,27,12],[22,0,22,1],[22,2,22,5],[22,11,22,12],[23,0,23,1],[23,2,23,5],[23,11,23,12],[24,0,24,1],[24,2,24,5],[24,11,24,12],[19,0,19,1],[19,2,19,5],[19,11,19,12],[20,0,20,1],[20,2,20,5],[20,11,20,12],[21,0,21,1],[21,2,21,5],[21,11,21,12],[16,0,16,1],[16,2,16,5],[16,11,16,12],[17,0,17,1],[17,2,17,5],[17,11,17,12],[18,0,18,1],[18,2,18,5],[18,11,18,12],[11,0,11,17],[12,6,12,9],[13,0,13,1],[13,2,13,5],[13,11,13,12],[14,0,14,1],[14,2,14,5],[14,11,14,12],[15,0,15,1],[15,2,15,5],[15,11,15,12],[1,0,1,9],[1,18,10,21],[2,2,2,13],[2,14,2,17],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[4,0,4,1],[5,0,5,1],[5,16,9,17],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1]]}
[]
["APPRENTICESHIP UTILIZATION REPORT",null,null,null,null,null,null,null,null,null,"Hiring Src:",null,"UH",{"$f":"COUNT(IF(($K$15:$K$248=\"UH\")*U15:U248*V15:V248,$R$15:$R$248))","v":0},"CITC",{"$f":"COUNT(IF(($K$15:$K$248=\"CITC\")*U15:U248*V15:V248,$R$15:$R$248))","v":0},"Other",{"$f":"COUNT(IF(U15:U248*V15:V248,(R15:R248)))-N2-P2","v":0},"hide these rows  and columns in the production version of this form"]
[null,null,"Work HOURS",null,null,null,null,null,null,null,null,null,null,null,"Employee COUNT"]
[null,null,"Black",null,"Hispanic",null,"Asian/\nPacific Is.",null,"Native American",null,"Disabled",null,"White/\nOther",null,"Minorities/\nDisabled",null,"Total Employees"]
["CATEGORY",null,"M","F","M","F","M","F","M","F","M","F","M","F","M","F","M","F"]
["Carpenter",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Carpenter\")*U15:U248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Carpenter\")*U15:U248*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Carpenter\")*U15:U248*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0},"this count is already in the table above"]
["Electrician",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Electrician\"),$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Electrician\")*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Electrician\")*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["Laborer",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Laborer\"),$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Laborer\")*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Laborer\")*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["Equipment Operator",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*($C$15:$E$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*($C$15:$F$248=\"Equipment Operator\"),$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Equipment Operator\")*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*($C$15:$F$248=\"Equipment Operator\")*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["Other Trade",null,{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"B\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"B\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"H\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"H\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"A\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"A\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"N\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"N\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($G$15:$G$248=\"Yes\")*(NOT($T$15:$T$248))*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"M\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"SUM(IF(($O$15:$O$248=\"F\")*($N$15:$N$248=\"O\")*NOT($G$15:$G$248=\"Yes\")*S15:S248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*S15:S248*($O$15:$O$248=\"M\")*V15:V248,$R$15:$R$248))","v":0},{"$f":"COUNT(IF(W15:W248*S15:S248*($O$15:$O$248=\"F\")*V15:V248,$R$15:$R$248))","v":0}]
["TOTAL",null,{"$f":"SUM(C6:C10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["APPRENTICE & JOURNEY UTILIZATION WORKER REPORT (Continuation Sheet)"]
[null,null,null,null,null,null,"Yes or No",null,null,null,null,null,null,null,null,null,"Wages","Hours"]
["Last Name, First",null,"Trade",null,null,null,"D *","DY","NI","GJ","HS","S.A.C. ID NO.#",null,"Ethnicity","Sex","Skill Level","$/hr","Hrs","IsOtherTrade","IsMinority","IsNameTrade","IsHours","IsMinOrDisab"]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},{"$f":"IsMinority","v":0},{"$f":"IsNameTrade","v":0},{"$f":"R15>0","v":false},{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R16>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},0,0,false,{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R80>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},0,0,false,{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R144>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,{"$f":"isOtherTrade","v":0},0,0,false,{"$f":"IsMinOrDisab2","v":false}]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,{"$f":"R208>0","v":false},false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,"-- select a trade --",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,0,0,0,false,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["KEY"]
["B=Black",null,"N=Native",null,"UH=Union Hall",null,null,null,null,null,null,"D*=Disabled (see note)",null,null,null,null,"M=Male"]
["H=Hispanic",null,"O=White/Other",null,"CITC=Construction Industry Training Council",null,null,null,null,null,null,"DY=Disadvantaged Youth",null,null,null,null,"F=Female"]
["A=Asian/Pacific Islander",null,null,null,null,null,null,null,null,null,null,"NI-Newly Indentured"]
["* For disabled minorities, report as EITHER diabled or minority, but not both."]
[]
["TRADES"]
["-- select a trade --"]
["Acoustical Worker"]
["Asbestos Worker"]
["Boilermaker"]
["Bricklayer"]
["Carpenter"]
["Carpet, Linoleum, Soft Tile Layers","Year","ReportType",null,"Ethnicity",null,"Sex","SkillLevel",null,"Hiring Source",null,null,null,null,"Choice"]
["Cement Mason",2003,"In Progress",null,"B",null,"M",1,null,"UH",null,null,null,null,"Yes"]
["Concrete Boom Pumper",2004,"Initial Report",null,"H",null,"F",2,null,"CITC",null,null,null,null,"No"]
["Diver",null,"No Activity",null,"A",null,null,3]
["Drywall Installer/taper",null,"Final Report",null,"N",null,null,4]
["Electrician",null,null,null,"O",null,null,5]
["Electrical Lineworker",null,null,null,null,null,null,6]
["Elevator Constructor",null,null,null,null,null,null,7]
["Equipment Operator",null,null,null,null,null,null,8]
["Fence Erector",null,null,null,null,null,null,9]
["Flagger",null,null,null,null,null,null,10]
["Floor Installers/Layers"]
["Glaziers"]
["HVAC (Sheet Metal) Worker"]
["Insulation Worker"]
["Insulation (Heat and Frost) Worker"]
["Iron Worker"]
["Irrigation Pump Installer"]
["Laborer"]
["Landscaper"]
["Lather"]
["Millwright"]
["Painter"]
["Pile Driver Operator"]
["Pipefitter"]
["Plasterer"]
["Plumber"]
["Roofer"]
["Sprinkler Fitter"]
["Stone mason"]
["Structural steel fabricator"]
["Surveyor"]
["Teamster/Truck driver"]
["Telecommunications Technician"]
["Tile Finisher"]
["Tilesetter Installer"]
["Traffic control striper"]
["Tree Trimmers"]
["Well-drill operator"]
["Other Trade"]

{"sheet":"MUR-AUR Instructions","index":5,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,10],[40,0,40,11],[14,1,14,7],[10,0,10,10],[22,1,22,10],[11,1,11,10],[26,0,26,11]]}
["INSTRUCTIONS FOR FILING EEO AND APPRENTICESHIP MONTHLY UTILIZATION REPORT"]
[]
["The Prime Contractor and each subcontractor must complete the EEO and Apprenticeship Monthly Utilization Reports.  "]
[]
["The Prime Contractor is responsible for the collection and submittal of all reports."]
[]
["Below is a list of explanations for the information needed."]
[]
["Contact a Contract Specialist with your questions. See the Contact Us page."]
[]
["EEO Monthly Utilization Section"]
["Field Name","What to Put in Field"]
["King County Contract #","Contract Number from the cover sheet of the contract document"]
["Contractor/Consultant Name","Company Name of the contractor or subcontractor preparing this report."]
["Report Period","Ending date (MM/DD/YY) for monthly reporting period."]
["Type of Report","Choose one of the following from the drop-down box, or leave blank if reporting work during middle of contract "]
["Initial Report","Check box if this is the last report after contractor has finished work."]
["One Time Only","When the initial report is also the final report."]
["Final Report","Check box if this is the last report after contractor has finished work."]
["No Activity","Between initial and final reports, a report must be submitted each month. "]
[null,"If no employees worked on the project during the reporting period, check box for No Activity."]
["Category","Use the trade name that best describes the type of work performed by your employees. "]
["Work Hours","Total number of employee HOURS worked in each classification, by race, gender & disability."]
[null," Do not include  owners or principals. ALSO INCLUDE APPRENTICE HOURS IN THIS SECTION."]
[]
[]
["Apprentice & Journey Utilization Worker Report Section:"]
["Apprentice/Journey Worker Name","Employee name (in Firstname, Lastname format) participating in the Apprenticeship program."]
["Yes or No","Using the codes identified at foot of form page, answer to describe the individual."]
["Trade","Consult the List of Construction Trades defined for EEO & Apprenticeship tracking. ."]
[null,"Use the trade name that best describes the work performed by each employee. For help, call your Contract Specialist."]
["SAC ID No.","ID number issued to the Apprentice by SAC (State Apprenticeship Council)."]
["Ethnicity","Ethnic background of the Apprentice; select one from the choices at bottom left of form. "]
[null,"Indicate white/other if the apprentice is not a minority (code: O)"]
["Gender","Gender of the Apprentice (M or F)."]
["Skill Level","Indicate the employee’s current year of apprenticeship using code at top right of box."]
["Wages","Hourly wage rate (regular and overtime) of the Apprentice."]
["Hours","Total work hours performed by the Apprentice during the reporting period, both regular and overtime. ."]
[null,"ALSO INCLUDE THESE HOURS IN THE MUR/EEO SECTION."]
[]
["TIPS: Set up an electronic file for Monthly Utilization Reports. Some information will remain the same each month (e.g., Contract #, Contract Title, Contractor, etc.)."]
["Each month open the previous month’s document and Save As a new document in your file. "]
["Incorporate the company initials and the reporting months as part of the file name for easy identification."]
["Fill in the appropriate information and be sure to delete last month’s numbers."]
["Be sure to report HOURS worked not number of employees in the “hours worked” columns."]
["Remember to change the “Report Period” each month when you fill in the new data, and check the status boxes in the top right corner."]
["Leave the names of inactive Apprentices on the report and leave the Base Wage & Work Hours columns empty."]
["Subcontractors then submit their documents to the prime who can identify the subs by initials and date on each document file."]
["Prime contractor then submits forms for prime and all subs to King County via the website Submittal Button."]

{"sheet":"Trades Definitions","index":6,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["TRADE / CRAFT","DEFINITIONS"]
["Acoustical Worker","Acoustical workers perform work on suspended ceilings that are common in most tenant areas of high rise buildings and in computer rooms.  "]
["Asbestos Worker","Asbestos workers perform removal of asbestos containing materials. "]
["Boilermaker","Boilermakers are complete metal fabricators who build and repair ships, fishing boats, ferries, barges, cranes, offshore drilling platforms, boilers, tanks pressure vessels, plate and structural fabrications."]
["Bricklayer","Bricklayers construct walls, fireplaces, commercial buildings, schools, as well as furnaces, kilns and other structures using brick, block, stone and marble and granite."]
["Carpenter","Carpenters work with power and hand tools. They build forms for concrete and frame buildings, walls, footings, columns and stairs."]
["Carpet, Linoleum, Soft Tile Layers","These worker install carpet, linoleum, and soft tile on floors, walls, and stairs at residential and commercial sites."]
["Cement Mason","Cement masons are responsible for all concrete construction, including pouring and finishing slabs, steps, wall tops, curbs and gutters, sidewalks, paving and other concrete construction.  "]
["Concrete Boom Pumper","Workers operate a concrete boom pump that pours concrete in specific areas and forms."]
["Diver","Emphasis is on dive planning and skill perfection in different diving scenarios."]
["Drywall Installer/taper","Drywall installers and tapers are construction workers who install and tape drywall panels to the framework inside houses and other buildings.  Drywall finishing is the work of tapers who fill in an smooth seams in sheets of drywall."]
["Electrician","Construction and residential electricians work in all phases of the electrical construction and service industry.  Workers install conduits and wire all lighting, along with switches and converters, to complex maintenance of electrical systems. "]
["Electrical Lineworker","Electrical lineworkers construct and maintain electric transmission and distribution facilities that deliver electricity to our homes, factories and commercial and retail businesses.  "]
["Elevator Constructor","Elevator constructors and mechanics assemble and install escalators and elevators."]
["Equipment Operator","Equipment operators use heavy construction equipment such as cranes, bulldozers, pavers, trench excavators and many other kinds of equipment used in constructing buildings, dams, airports and highways."]
["Fence Erector","Workers erects and repair metal and wooden fences and fence gates around industrial establishments, residences, or farms, using power tools and hand tools."]
["Flagger","Flaggers perform temporary traffic control and have responsibility for road user safety."]
["Floor Installers/Layers","Floor installers, or floor layers, apply blocks, strips, or sheets of shock-absorbing, sound-deadening, or decorative coverings to floors and cabinets using rollers, knives, trowels, sanding machines, and other tools."]
["Glaziers","Glaziers prepare and install various types of glass, mirrors, metal framing and glass and aluminum doors and entrances in and on buildings at residential, commercial and industrial sites."]
["HVAC (Sheet Metal) Worker","Install, repair or maintain Heating, Ventilating and Air Conditioning (HVAC) equipment such as evaporative coolers, air conditioning window units and environmental control systems"]
["Insulation Worker","Insulators work with both thermal and sound insulation using many variations of rolled and rigid insulation sytems."]
["Insulation (Heat and Frost) Worker","Insulation workers apply insulation materials to pipes, tanks, boilers, ducts, refrigeration equipment and other surfaces requiring thermal control of temperatures."]
["Iron Worker","Ironworkers assemble and erect steel framework and other metal parts in buildings, on bridges, dams and other steel structures. "]
["Irrigation Pump Installer","Workers install or repairs well pumps and equipment."]
["Laborer","Construction laborers perform a wide range of physically demanding tasks involving building and highway construction projects, tunnel and shaft excavation, hazardous waste removal, demolition, doing clearing, grade checking, stake hopping, culvert installation, equipment signaling and traffic control."]
["Landscaper","Landscape workers build and install landscapes plants."]
["Lather","Lathing is a trade that is performed on both interior and exterior surfaces.  Complete buildings may be framed from structural steel studs, sheeting or metal lath and made ready for plaster by the lather.  "]
["Millwright","Millwrights are crafts people who do precision machine installation and assembly using sophisticated measuring instruments."]
["Painter","Painters prepare and paint a diverse array of surfaces."]
["Pile Driver Operator","Piledrivers work with power and hand tools. They drive all types of piling such as wood, steel and concrete pilings."]
["Pipefitter","Pipefitters install piping sytems that carry water, steam, air and other liquids or gases necessary for sanitation, industrial production, heating and air condition, an many other uses. "]
["Plasterer","Plasterers finish interior walls and ceilings of buildings, apply plaster on masonry, metal, wirelath or gypsum.  They also apply cement on masonry, metal, and wirelath (stucco)."]
["Plumber","Plumbers install piping sytems that carry water, steam, air  and other liquids. They also alter, remodel and repair existing piping systems and install plumbing fixtures, radiators, and other heating units and some appliances. "]
["Roofer","Roofers install new roofs and repair and remove old roofs using a variety of materials."]
["Sprinkler Fitter","Sprinkler Fitters are pipefitter specialists in fire protection.  They install fire protection systems of all sorts. "]
["Stone mason","Stonemasons build stone walls, as well as set stone exteriors and floors. They work with two types of stone-natural cut, such as marble, granite, and limestone; and artificial stone made from concrete, marble chips, or other masonry materials."]
["Structural steel fabricator","Worker perform tasks, such as riveting, welding, bolting, and chipping, using portable power tools. "]
["Surveyor","Surveyors measure and map the earth’s surface.  Surveyors establish official boundaries, write descriptions of property lots and measure sites.  The measurements of land areas determined by surveyors may be used for mapmaking, construction, and engineering projects. "]
["Teamster/Truck driver","Workers in this trade perform work using a variety of Teamster construction equipment, including truck and pup dump trucks, belly dumps, and booms trucks."]
["Telecommunications Technician","Workers install, maintain, test and repair telecommunications equipment.  "]
["Tile Finisher","Tile finishers help some tilesetters by supplying and mixing construction materials and doing other tasks such as applying grout and cleaning installed tile. \n"]
["Tilesetter Installer","Tilesetters install ceramic tile, marble and granite on a variety of surfaces such as walls, floors, countertops, pools, showers, tubs and the exterior of buildings."]
["Traffic control striper","Workers perform work in the operation of a high capacity traffic stripping machine."]
["Tree Trimmers","Tree trimmers work outdoors clearing trees from around power lines and other structures. "]
["Well-drill operator","Well-driller apprentices perform services associated with drilling, deepening, or altering a well under the direct supervision of the supervising driller."]
["Other Trade"]

{"sheet":"Macro Security","index":7,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Change the security level for macro virus protection"]
["Why? Because the navigation buttons in this workbook are macros.  They will not operate with security set to High."]
["1. On the Tools menu, click Options."]
["2. Click the Security tab."]
["3. Under Macro Security, click Macro Security."]
["4. Click the Security Level tab, and then select the security level you want to use (MEDIUM)."]

{"sheet":"MUR-AUR Instr working","index":8,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":true,"merged":[[40,0,40,11]]}
["INSTRUCTIONS FOR MONTHLY UTILIZATION REPORTS"]
["Applies to Apprenticeship and Monthly Utilization Reports"]
["The Prime Contractor and each subcontractor must complete the EEO and Apprenticeship Monthly Utilization Reports.  "]
[]
["The Prime Contractor is responsible for the collection and submittal of all reports."]
[]
["Below is a list of explanations for the information needed."]
[]
["Contact a Contract Specialist with your questions. See the Contact Us page."]
[]
["EEO Monthly Utilization Section"]
[]
["Field Name","What to Put in Field"]
["King County Contract #","Contract Number from the cover sheet of the contract document"]
["Contractor/Consultant Name","Company Name of the contractor or subcontractor preparing this report."]
["Report Period","Ending date (MM/DD/YY) for monthly reporting period."]
["Type of Report","Choose one of the following from the drop-down box, or leave blank if reporting work during middle of contract "]
["Initial Report","Check box if this is the last report after contractor has finished work."]
["Final Report","Check box if this is the last report after contractor has finished work."]
["No Activity","Between initial and final reports, a report must be submitted each month. "]
[null,"If no employees worked on the project during the reporting period, check box for No Activity."]
["Category","Use the trade name that best describes the type of work performed by your employees. "]
["Work Hours","Total number of employee HOURS worked in each classification, by race, gender & disability."]
[null," Do not include  owners or principals. ALSO INCLUDE APPRENTICE HOURS IN THIS SECTION."]
[]
[]
["Apprenticeship Utilization Report Section:"]
["Apprentice Name","Employee name (in Firstname, Lastname format) participating in the Apprenticeship program."]
["Yes or No","Using the codes identified at foot of form page, answer to describe the individual."]
["Trade","Consult the List of Construction Trades defined for EEO & Apprenticeship tracking. ."]
[null,"Use the trade name that best describes the work performed by each employee. For help, call your Contract Specialist."]
["SAC ID No.","ID number issued to the Apprentice by SAC (State Apprenticeship Council)."]
["Ethnicity","Ethnic background of the Apprentice; select one from the choices at bottom left of form. "]
[null,"Leave the column blank if the apprentice is not a minority."]
["Sex","Gender of the Apprentice."]
["Skill Level","Indicate the employee’s current year of apprenticeship using code at top right of box."]
["Wages","Hourly wage rate (regular and overtime) of the Apprentice."]
["Hours","Total work hours performed by the Apprentice during the reporting period, both regular and overtime. ."]
[null,"ALSO INCLUDE THESE HOURS IN THE MUR/EEO SECTION."]
[]
["TIPS: Set up an electronic file for Monthly Utilization Reports. Some information will remain the same each month (e.g., Contract #, Contract Title, Contractor, etc.)."]
["Each month open the previous month’s document and Save As a new document in your file. "]
["Incorporate the company initials and the reporting months as part of the file name for easy identification."]
["Fill in the appropriate information and be sure to delete last month’s numbers."]
["Be sure to report HOURS worked not number of employees in the “hours worked” columns."]
["Remember to change the “Report Period” each month when you fill in the new data, and check the status boxes in the top right corner."]
["Leave the names of inactive Apprentices on the report and leave the Base Wage & Work Hours columns empty."]
["Subcontractors then submit their documents to the prime who can identify the subs by initials and date on each document file."]
["Prime contractor then submits forms for prime and all subs to King County via the website Submittal Button."]

{"sheet":"Instructions","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"data transport","index":10,"n_rows":234,"n_cols":5,"rows_kept":234,"cut":false,"hidden":true,"merged":[[8,3,8,4],[9,3,9,4],[38,0,38,4],[23,3,23,5],[24,3,24,5],[25,3,25,5],[14,4,14,7],[15,4,15,7],[16,4,16,7],[17,4,17,7],[36,0,36,7],[30,4,30,7],[31,4,31,7],[32,4,32,7],[33,4,33,7]]}
["Each document is one record in the MURAUR table"]
["Two fields are manually selected from pick lists by the user upon upload:"]
["fieldname"]
["vendor"]
["contractno"]
[]
["The following fields are imported by the website upon upload:"]
["Section","fieldname","cellref","description"]
["Header","mo","p3","report period month"]
[null,"yr","r3","report period year"]
[null,"field count",null,2]
[]
["MUR","KEY"]
[null,"character","dimension","choices","codes key"]
[null,"1st","source",1,"m=monthly utilization"]
[null,"2nd","column",8,"b=black;h=hispanic;a=asian;n=native;d=disabled;o=other;m=minority/disabled;t=total employees"]
[null,"3rd","gender",2,"m=male;f=female"]
[null,"4th","trade",6,"c=carpenter;e=electrician;l=labor;o=equipment operator;t=other trade;n=all non trade"]
[null,"field count",null,{"$f":"+D15*D16*D17*D18","v":96}]
[]
["AUR"]
[]
["Header","fieldname","cellref","description"]
[null,"hsuh","n42","hiring source - union hall"]
[null,"hscitc","p42","hiring source - citc"]
[null,"hsother","r42","hiring source - other"]
[null,"field count",null,3]
[]
[null,"KEY"]
["Body","character","dimension","choices","codes key"]
[null,"1st","source",1,"a=monthly apprenticeship"]
[null,"2nd","column",7,"b=black;h=hispanic;a=asian;n=native;d=disabled;o=other;m=minority/diabled"]
[null,"3rd","gender",2,"m=male;f=female"]
[null,"4th","trade",6,"c=carpenter;e=electrician;l=labor;o=equipment operator;t=other trade;n=all non trade"]
[null,"field count",null,{"$f":"+D31*D32*D33*D34","v":84}]
[]
["note: field naming conventions for the PIR matrix is very similar to the MUR and AUR matrixes.  Source code (1st character) is \"p\""]
[]
["Recap of Field Names"]
[]
["Report header","2 fields",null,null,"field name"]
[null,null,null,null,"mo"]
[null,null,null,null,"yr"]
[]
["AUR header","3 fields",null,null,"field name"]
[null,null,null,null,"hsuh"]
[null,null,null,null,"hscitc"]
[null,null,null,null,"hsother"]
[]
["MUR Matrix","96 fields"]
["1st char","2nd char","3rd char","4th char","field name"]
["m","b","m","c",{"$f":"+A52&B52&C52&D52","v":"mbmc"}]
["m","b","m","e",{"$f":"+A53&B53&C53&D53","v":"mbme"}]
["m","b","m","l","mbml"]
["m","b","m","o","mbmo"]
["m","b","m","t","mbmt"]
["m","b","m","n","mbmn"]
["m","b","f","c","mbfc"]
["m","b","f","e","mbfe"]
["m","b","f","l","mbfl"]
["m","b","f","o","mbfo"]
["m","b","f","t","mbft"]
["m","b","f","n","mbfn"]
["m","h","m","c","mhmc"]
["m","h","m","e","mhme"]
["m","h","m","l","mhml"]
["m","h","m","o","mhmo"]
["m","h","m","t","mhmt"]
["m","h","m","n","mhmn"]
["m","h","f","c","mhfc"]
["m","h","f","e","mhfe"]
["m","h","f","l","mhfl"]
["m","h","f","o","mhfo"]
["m","h","f","t","mhft"]
["m","h","f","n","mhfn"]
["m","a","m","c","mamc"]
["m","a","m","e","mame"]
["m","a","m","l","maml"]
["m","a","m","o","mamo"]
["m","a","m","t","mamt"]
["m","a","m","n","mamn"]
["m","a","f","c","mafc"]
["m","a","f","e","mafe"]
["m","a","f","l","mafl"]
["m","a","f","o","mafo"]
["m","a","f","t","maft"]
["m","a","f","n","mafn"]
["m","n","m","c","mnmc"]
["m","n","m","e","mnme"]
["m","n","m","l","mnml"]
["m","n","m","o","mnmo"]
["m","n","m","t","mnmt"]
["m","n","m","n","mnmn"]
["m","n","f","c","mnfc"]
["m","n","f","e","mnfe"]
["m","n","f","l","mnfl"]
["m","n","f","o","mnfo"]
["m","n","f","t","mnft"]
["m","n","f","n","mnfn"]
["m","d","m","c",{"$f":"+A100&B100&C100&D100","v":"mdmc"}]
["m","d","m","e","mdme"]
["m","d","m","l","mdml"]
["m","d","m","o","mdmo"]
["m","d","m","t","mdmt"]
["m","d","m","n","mdmn"]
["m","d","f","c","mdfc"]
["m","d","f","e","mdfe"]
["m","d","f","l","mdfl"]
["m","d","f","o","mdfo"]
["m","d","f","t","mdft"]
["m","d","f","n","mdfn"]
["m","o","m","c","momc"]
["m","o","m","e","mome"]
["m","o","m","l","moml"]
["m","o","m","o","momo"]
["m","o","m","t","momt"]
["m","o","m","n","momn"]
["m","o","f","c","mofc"]
["m","o","f","e","mofe"]
["m","o","f","l","mofl"]
["m","o","f","o","mofo"]
["m","o","f","t","moft"]
["m","o","f","n","mofn"]
["m","m","m","c","mmmc"]
["m","m","m","e","mmme"]
["m","m","m","l","mmml"]
["m","m","m","o","mmmo"]
["m","m","m","t","mmmt"]
["m","m","m","n",{"$f":"+A129&B129&C129&D129","v":"mmmn"}]
["m","m","f","c","mmfc"]
["m","m","f","e","mmfe"]
["m","m","f","l","mmfl"]
["m","m","f","o","mmfo"]
["m","m","f","t","mmft"]
["m","m","f","n","mmfn"]
["m","t","m","c","mtmc"]
["m","t","m","e","mtme"]
["m","t","m","l","mtml"]
["m","t","m","o","mtmo"]
["m","t","m","t","mtmt"]
["m","t","m","n","mtmn"]
["m","t","f","c","mtfc"]
["m","t","f","e","mtfe"]
["m","t","f","l","mtfl"]
["m","t","f","o","mtfo"]
["m","t","f","t","mtft"]
["m","t","f","n","mtfn"]
[]
["AUR Matrix","84 fields"]
["1st char","2nd char","3rd char","4th char","field name"]
["a","b","m","c",{"$f":"+A151&B151&C151&D151","v":"abmc"}]
["a","b","m","e",{"$f":"+A152&B152&C152&D152","v":"abme"}]
["a","b","m","l","abml"]
["a","b","m","o","abmo"]
["a","b","m","t","abmt"]
["a","b","m","n","abmn"]
["a","b","f","c","abfc"]
["a","b","f","e","abfe"]
["a","b","f","l","abfl"]
["a","b","f","o","abfo"]
["a","b","f","t","abft"]
["a","b","f","n","abfn"]
["a","h","m","c","ahmc"]
["a","h","m","e","ahme"]
["a","h","m","l","ahml"]
["a","h","m","o","ahmo"]
["a","h","m","t","ahmt"]
["a","h","m","n","ahmn"]
["a","h","f","c","ahfc"]
["a","h","f","e","ahfe"]
["a","h","f","l","ahfl"]
["a","h","f","o","ahfo"]
["a","h","f","t","ahft"]
["a","h","f","n","ahfn"]
["a","a","m","c","aamc"]
["a","a","m","e","aame"]
["a","a","m","l","aaml"]
["a","a","m","o","aamo"]
["a","a","m","t","aamt"]
["a","a","m","n","aamn"]
["a","a","f","c","aafc"]
["a","a","f","e","aafe"]
["a","a","f","l","aafl"]
["a","a","f","o","aafo"]
["a","a","f","t","aaft"]
["a","a","f","n","aafn"]
["a","n","m","c","anmc"]
["a","n","m","e","anme"]
["a","n","m","l","anml"]
["a","n","m","o","anmo"]
["a","n","m","t","anmt"]
["a","n","m","n","anmn"]
["a","n","f","c","anfc"]
["a","n","f","e","anfe"]
["a","n","f","l","anfl"]
["a","n","f","o","anfo"]
["a","n","f","t","anft"]
["a","n","f","n","anfn"]
["a","d","m","c",{"$f":"+A199&B199&C199&D199","v":"admc"}]
["a","d","m","e","adme"]
["a","d","m","l","adml"]
["a","d","m","o","admo"]
["a","d","m","t","admt"]
["a","d","m","n","admn"]
["a","d","f","c","adfc"]
["a","d","f","e","adfe"]
["a","d","f","l","adfl"]
["a","d","f","o","adfo"]
["a","d","f","t","adft"]
["a","d","f","n","adfn"]
["a","o","m","c","aomc"]
["a","o","m","e","aome"]
["a","o","m","l","aoml"]
["a","o","m","o","aomo"]
["a","o","m","t","aomt"]
["a","o","m","n","aomn"]
["a","o","f","c","aofc"]
["a","o","f","e","aofe"]
["a","o","f","l","aofl"]
["a","o","f","o","aofo"]
["a","o","f","t","aoft"]
["a","o","f","n","aofn"]
["a","m","m","c","ammc"]
["a","m","m","e","amme"]
["a","m","m","l","amml"]
["a","m","m","o","ammo"]
["a","m","m","t","ammt"]
["a","m","m","n",{"$f":"+A228&B228&C228&D228","v":"ammn"}]
["a","m","f","c","amfc"]
["a","m","f","e","amfe"]
["a","m","f","l","amfl"]
["a","m","f","o","amfo"]
["a","m","f","t","amft"]
["a","m","f","n","amfn"]