{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["2-PG Payroll Report-no formulas","10-PG Payroll Report-formulas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2-PG Payroll Report-no formulas","index":0,"n_rows":70,"n_cols":22,"rows_kept":70,"cut":false,"hidden":false,"merged":[[64,21,65,21],[44,3,44,13],[44,14,44,21],[45,1,47,1],[45,14,47,14],[45,15,47,15],[45,16,47,16],[45,17,47,17],[45,18,47,18],[52,21,53,21],[62,21,63,21],[23,21,24,21],[25,21,26,21],[27,21,28,21],[29,21,30,21],[48,21,49,21],[50,21,51,21],[45,21,47,21],[45,19,47,19],[54,21,55,21],[56,21,57,21],[58,21,59,21],[60,21,61,21],[58,19,59,19],[52,20,53,20],[52,19,53,19],[15,21,16,21],[17,21,18,21],[19,21,20,21],[21,21,22,21],[15,15,16,15],[15,20,16,20],[15,19,16,19],[19,17,20,17],[19,18,20,18],[21,19,22,19],[50,18,51,18],[50,0,51,0],[50,1,51,1],[50,2,51,2],[62,17,63,17],[60,14,61,14],[60,0,61,0],[38,1,38,2],[38,6,38,10],[38,13,38,15],[38,17,38,20],[64,20,65,20],[64,14,65,14],[64,15,65,15],[64,16,65,16],[64,17,65,17],[64,18,65,18],[64,19,65,19],[64,0,65,0],[64,1,65,1],[64,2,65,2],[62,19,63,19],[62,20,63,20],[60,18,61,18],[60,19,61,19],[60,20,61,20],[62,14,63,14],[62,15,63,15],[62,16,63,16],[62,18,63,18],[60,1,61,1],[60,2,61,2],[62,0,63,0],[62,1,63,1],[62,2,63,2],[58,18,59,18],[60,17,61,17],[60,16,61,16],[60,15,61,15],[58,15,59,15],[54,18,55,18],[54,19,55,19],[54,20,55,20],[58,14,59,14],[56,0,57,0],[56,1,57,1],[56,2,57,2],[56,14,57,14],[54,0,55,0],[54,1,55,1],[56,16,57,16],[56,17,57,17],[56,18,57,18],[56,19,57,19],[56,20,57,20],[56,15,57,15],[58,16,59,16],[58,17,59,17],[58,0,59,0],[58,1,59,1],[58,2,59,2],[58,20,59,20],[50,16,51,16],[50,17,51,17],[52,17,53,17],[40,2,40,10],[42,1,42,10],[40,13,40,15],[48,1,49,1],[48,2,49,2],[48,14,49,14],[42,11,42,12],[42,13,42,15],[46,2,47,2],[25,0,26,0],[25,1,26,1],[25,2,26,2],[27,0,28,0],[48,15,49,15],[35,0,35,20],[36,0,36,20],[48,19,49,19],[27,2,28,2],[29,16,30,16],[48,17,49,17],[25,16,26,16],[25,17,26,17],[27,15,28,15],[27,16,28,16],[27,17,28,17],[27,1,28,1],[25,14,26,14],[25,15,26,15],[15,18,16,18],[15,14,16,14],[7,18,7,20],[10,14,12,14],[10,15,12,15],[10,16,12,16],[10,17,12,17],[17,1,18,1],[0,0,0,20],[1,0,1,20],[3,17,3,20],[15,0,16,0],[3,1,3,2],[3,6,3,10],[5,13,5,15],[15,16,16,16],[15,17,16,17],[15,1,16,1],[15,2,16,2],[3,13,3,15],[7,1,7,10],[7,11,7,12],[7,13,7,15],[5,2,5,10],[13,0,14,0],[13,19,14,19],[13,16,14,16],[13,17,14,17],[13,1,14,1],[13,18,14,18],[13,15,14,15],[13,2,14,2],[5,19,5,20],[13,14,14,14],[13,20,14,20],[9,3,9,13],[9,14,9,21],[10,1,12,1],[10,18,12,18],[10,19,12,19],[10,20,12,20],[10,21,12,21],[11,2,12,2],[13,21,14,21],[23,17,24,17],[23,18,24,18],[23,0,24,0],[23,1,24,1],[23,2,24,2],[23,14,24,14],[19,0,20,0],[19,1,20,1],[19,2,20,2],[21,0,22,0],[21,1,22,1],[21,2,22,2],[19,14,20,14],[21,14,22,14],[21,15,22,15],[23,15,24,15],[52,0,53,0],[52,1,53,1],[52,2,53,2],[29,1,30,1],[29,2,30,2],[52,18,53,18],[29,17,30,17],[48,0,49,0],[52,14,53,14],[52,15,53,15],[29,0,30,0],[48,18,49,18],[29,18,30,18],[42,18,42,20],[48,20,49,20],[45,20,47,20],[29,14,30,14],[29,15,30,15],[48,16,49,16],[52,16,53,16],[50,19,51,19],[50,20,51,20],[50,14,51,14],[50,15,51,15],[54,2,55,2],[19,20,20,20],[54,14,55,14],[54,15,55,15],[54,16,55,16],[54,17,55,17],[19,19,20,19],[21,20,22,20],[21,16,22,16],[21,17,22,17],[21,18,22,18],[29,20,30,20],[29,19,30,19],[40,19,40,20],[27,14,28,14],[23,20,24,20],[27,18,28,18],[27,19,28,19],[27,20,28,20],[25,18,26,18],[25,19,26,19],[25,20,26,20],[23,19,24,19],[23,16,24,16],[17,0,18,0],[17,20,18,20],[19,16,20,16],[17,19,18,19],[17,15,18,15],[19,15,20,15],[17,14,18,14],[17,16,18,16],[17,17,18,17],[17,18,18,18],[17,2,18,2]]}
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1, below):",null,null,"PROJECT NO.",null,null,null,null,null,null,null,null,"WEEK ENDING:",null,null,null,"COUNTY:"]
[]
[null,"REPORTING CONTRACTOR:",null,null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,null,null,null,null,"CONTRACT LETTING DATE:"]
[]
["PRIME CONTRACTOR:",null,null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,null,null,null,null,"WAGE DECISION:","2015-10-09"]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (*These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Columns D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O  Total Weekly Hours*","Col P   Total Weekly \"Bona-Fide\" ER Fringe Benefits","Col Q         Total Weekly Gross Pay*","Col R      SOC SEC Tax Withheld*","Col S FED Tax Withheld*","Col T Other Withheld*","Col U TOTAL Withheld*","Col V TOTAL     Net Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT",null,null,null,null,null,null,null,"Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,"See \"Instruction\" tab for more details.",null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx "]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",null,null,"PROJECT NO.",null,null,null,null,null,null,null,null,"WEEK ENDING:",null,null,null,"COUNTY:"]
[]
[null,"REPORTING CONTRACTOR",null,null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,null,null,null,null,"CONTRACT LETTING DATE(2)"]
[]
["PRIME CONTRACTOR:",null,null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,null,null,null,null,"WAGE DECISION:","2015-10-09"]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (*These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Columns D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O  Total Weekly Hours*","Col P   Total Weekly \"Bona-Fide\" ER Fringe Benefits","Col Q         Total Weekly Gross Pay*","Col R      SOC SEC Tax Withheld*","Col S FED Tax Withheld*","Col T Other Withheld*","Col U TOTAL Withheld*","Col V TOTAL     Net Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT",null,null,null,null,null,null,null,"Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
[null,null,null,"ST "]
[null,null,null,"OT"]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,"See \"Instruction\" tab for more details.",null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]

{"sheet":"10-PG Payroll Report-formulas","index":1,"n_rows":350,"n_cols":22,"rows_kept":350,"cut":false,"hidden":false,"merged":[[145,20,145,21],[180,20,180,21],[215,20,215,21],[250,20,250,21],[285,20,285,21],[75,17,75,19],[40,17,40,19],[5,17,5,19],[42,16,42,17],[77,16,77,17],[112,16,112,17],[7,16,7,17],[105,0,105,20],[79,3,79,13],[5,20,5,21],[147,16,147,17],[182,16,182,17],[217,16,217,17],[252,16,252,17],[255,21,257,21],[256,2,257,2],[290,1,292,1],[290,14,292,14],[290,15,292,15],[290,16,292,16],[290,17,292,17],[290,18,292,18],[290,19,292,19],[290,20,292,20],[290,21,292,21],[291,2,292,2],[325,1,327,1],[325,14,327,14],[325,15,327,15],[325,16,327,16],[325,17,327,17],[325,18,327,18],[325,19,327,19],[325,20,327,20],[326,2,327,2],[287,16,287,17],[322,16,322,17],[309,17,310,17],[301,17,302,17],[299,17,300,17],[297,17,298,17],[150,18,152,18],[150,19,152,19],[150,20,152,20],[150,21,152,21],[151,2,152,2],[185,1,187,1],[185,14,187,14],[185,15,187,15],[185,16,187,16],[185,17,187,17],[185,19,187,19],[185,20,187,20],[185,21,187,21],[186,2,187,2],[220,1,222,1],[220,14,222,14],[220,15,222,15],[220,16,222,16],[220,17,222,17],[220,18,222,18],[220,20,222,20],[220,21,222,21],[221,2,222,2],[342,0,343,0],[342,1,343,1],[342,2,343,2],[342,14,343,14],[342,15,343,15],[342,16,343,16],[344,0,345,0],[344,1,345,1],[344,2,345,2],[344,14,345,14],[344,15,345,15],[344,16,345,16],[322,11,322,12],[344,17,345,17],[344,18,345,18],[344,19,345,19],[344,20,345,20],[342,17,343,17],[342,18,343,18],[342,19,343,19],[342,20,343,20],[340,19,341,19],[324,3,324,13],[322,1,322,10],[338,0,339,0],[338,1,339,1],[338,2,339,2],[338,14,339,14],[338,15,339,15],[338,16,339,16],[338,17,339,17],[338,18,339,18],[338,19,339,19],[338,20,339,20],[340,0,341,0],[340,1,341,1],[340,2,341,2],[340,14,341,14],[340,15,341,15],[340,16,341,16],[340,17,341,17],[340,18,341,18],[340,20,341,20],[334,0,335,0],[334,1,335,1],[334,2,335,2],[334,14,335,14],[334,15,335,15],[334,16,335,16],[334,17,335,17],[334,18,335,18],[334,19,335,19],[334,20,335,20],[336,0,337,0],[336,1,337,1],[336,2,337,2],[336,14,337,14],[336,15,337,15],[336,16,337,16],[336,17,337,17],[336,18,337,18],[336,19,337,19],[336,20,337,20],[330,0,331,0],[330,1,331,1],[330,2,331,2],[330,14,331,14],[330,15,331,15],[330,16,331,16],[330,17,331,17],[330,18,331,18],[330,19,331,19],[330,20,331,20],[332,0,333,0],[332,1,333,1],[332,2,333,2],[332,14,333,14],[332,15,333,15],[332,16,333,16],[332,17,333,17],[332,18,333,18],[332,19,333,19],[332,20,333,20],[318,1,318,2],[318,6,318,10],[318,13,318,15],[318,17,318,20],[320,2,320,10],[320,13,320,15],[320,17,320,19],[322,13,322,15],[322,18,322,20],[328,0,329,0],[328,1,329,1],[328,2,329,2],[328,14,329,14],[328,15,329,15],[328,16,329,16],[328,17,329,17],[328,18,329,18],[328,19,329,19],[328,20,329,20],[320,20,320,21],[309,0,310,0],[309,1,310,1],[309,2,310,2],[309,14,310,14],[309,15,310,15],[309,16,310,16],[307,0,308,0],[309,18,310,18],[309,19,310,19],[309,20,310,20],[10,21,12,21],[15,2,16,2],[17,2,18,2],[19,2,20,2],[21,2,22,2],[23,2,24,2],[307,17,308,17],[115,16,117,16],[289,3,289,13],[246,0,246,20],[245,0,245,20],[255,20,257,20],[10,20,12,20],[219,3,219,13],[184,3,184,13],[141,0,141,20],[140,0,140,20],[114,3,114,13],[106,0,106,20],[115,1,117,1],[115,14,117,14],[115,15,117,15],[303,0,304,0],[303,1,304,1],[303,2,304,2],[303,14,304,14],[303,15,304,15],[303,16,304,16],[303,18,304,18],[303,19,304,19],[303,20,304,20],[305,0,306,0],[305,1,306,1],[305,2,306,2],[305,14,306,14],[305,15,306,15],[305,16,306,16],[307,1,308,1],[307,2,308,2],[307,14,308,14],[307,15,308,15],[307,16,308,16],[303,17,304,17],[307,18,308,18],[307,19,308,19],[307,20,308,20],[299,0,300,0],[299,1,300,1],[299,2,300,2],[299,14,300,14],[299,15,300,15],[299,16,300,16],[299,18,300,18],[299,19,300,19],[299,20,300,20],[301,0,302,0],[301,1,302,1],[301,2,302,2],[301,14,302,14],[301,15,302,15],[301,16,302,16],[301,18,302,18],[301,19,302,19],[301,20,302,20],[295,0,296,0],[295,1,296,1],[295,2,296,2],[295,14,296,14],[295,15,296,15],[295,16,296,16],[295,17,296,17],[295,18,296,18],[295,19,296,19],[295,20,296,20],[297,0,298,0],[297,1,298,1],[297,2,298,2],[297,14,298,14],[297,15,298,15],[297,16,298,16],[297,18,298,18],[297,19,298,19],[297,20,298,20],[285,2,285,10],[285,13,285,15],[285,17,285,19],[287,1,287,10],[287,11,287,12],[287,13,287,15],[287,18,287,20],[293,0,294,0],[293,1,294,1],[293,2,294,2],[293,14,294,14],[293,15,294,15],[293,16,294,16],[293,17,294,17],[293,18,294,18],[293,19,294,19],[293,20,294,20],[272,0,273,0],[272,1,273,1],[272,2,273,2],[272,14,273,14],[272,15,273,15],[272,16,273,16],[272,17,273,17],[272,18,273,18],[272,19,273,19],[272,20,273,20],[274,0,275,0],[274,1,275,1],[274,2,275,2],[274,14,275,14],[274,15,275,15],[274,16,275,16],[274,17,275,17],[274,18,275,18],[274,19,275,19],[274,20,275,20],[266,0,267,0],[266,1,267,1],[266,2,267,2],[266,14,267,14],[266,15,267,15],[266,16,267,16],[268,0,269,0],[268,1,269,1],[268,2,269,2],[268,14,269,14],[268,15,269,15],[268,16,269,16],[268,17,269,17],[268,18,269,18],[268,19,269,19],[268,20,269,20],[270,0,271,0],[270,1,271,1],[270,2,271,2],[270,14,271,14],[270,15,271,15],[270,16,271,16],[270,17,271,17],[270,18,271,18],[270,19,271,19],[270,20,271,20],[262,0,263,0],[262,1,263,1],[262,2,263,2],[262,14,263,14],[262,15,263,15],[262,16,263,16],[262,17,263,17],[262,18,263,18],[262,19,263,19],[262,20,263,20],[264,0,265,0],[264,1,265,1],[264,2,265,2],[264,14,265,14],[264,15,265,15],[264,16,265,16],[264,17,265,17],[264,18,265,18],[264,19,265,19],[264,20,265,20],[250,2,250,10],[250,13,250,15],[250,17,250,19],[252,1,252,10],[252,11,252,12],[252,13,252,15],[252,18,252,20],[258,0,259,0],[258,1,259,1],[258,2,259,2],[258,14,259,14],[258,15,259,15],[258,16,259,16],[260,0,261,0],[260,1,261,1],[260,2,261,2],[260,14,261,14],[260,15,261,15],[260,16,261,16],[260,17,261,17],[260,18,261,18],[260,19,261,19],[260,20,261,20],[255,1,257,1],[255,14,257,14],[255,15,257,15],[255,16,257,16],[255,17,257,17],[255,18,257,18],[255,19,257,19],[239,0,240,0],[239,1,240,1],[239,2,240,2],[239,14,240,14],[239,15,240,15],[239,16,240,16],[239,17,240,17],[239,18,240,18],[239,19,240,19],[239,20,240,20],[25,2,26,2],[27,2,28,2],[29,2,30,2],[45,14,47,14],[45,15,47,15],[45,16,47,16],[248,1,248,2],[248,6,248,10],[248,13,248,15],[248,17,248,20],[46,2,47,2],[80,1,82,1],[80,14,82,14],[80,15,82,15],[80,16,82,16],[80,17,82,17],[81,2,82,2],[75,2,75,10],[75,13,75,15],[77,11,77,12],[115,18,117,18],[115,19,117,19],[235,0,236,0],[235,1,236,1],[235,2,236,2],[235,14,236,14],[235,15,236,15],[235,16,236,16],[235,17,236,17],[235,18,236,18],[235,19,236,19],[235,20,236,20],[237,0,238,0],[237,1,238,1],[237,2,238,2],[237,14,238,14],[237,15,238,15],[237,16,238,16],[237,17,238,17],[237,18,238,18],[237,19,238,19],[237,20,238,20],[231,0,232,0],[231,1,232,1],[231,2,232,2],[231,14,232,14],[231,15,232,15],[231,16,232,16],[231,17,232,17],[231,18,232,18],[231,19,232,19],[231,20,232,20],[233,0,234,0],[233,1,234,1],[233,2,234,2],[233,14,234,14],[233,15,234,15],[233,16,234,16],[233,17,234,17],[233,18,234,18],[233,19,234,19],[233,20,234,20],[227,0,228,0],[227,1,228,1],[227,2,228,2],[227,14,228,14],[227,15,228,15],[227,16,228,16],[227,17,228,17],[227,18,228,18],[227,19,228,19],[227,20,228,20],[229,0,230,0],[229,1,230,1],[229,2,230,2],[229,14,230,14],[229,15,230,15],[229,16,230,16],[229,17,230,17],[229,18,230,18],[229,19,230,19],[229,20,230,20],[223,0,224,0],[223,1,224,1],[223,2,224,2],[223,14,224,14],[223,15,224,15],[223,16,224,16],[223,17,224,17],[223,18,224,18],[223,19,224,19],[223,20,224,20],[225,0,226,0],[225,1,226,1],[225,2,226,2],[225,14,226,14],[225,15,226,15],[225,16,226,16],[225,17,226,17],[225,18,226,18],[225,19,226,19],[225,20,226,20],[204,0,205,0],[204,1,205,1],[204,2,205,2],[204,14,205,14],[204,15,205,15],[204,16,205,16],[210,0,210,20],[211,0,211,20],[213,1,213,2],[213,6,213,10],[213,13,213,15],[213,17,213,20],[215,2,215,10],[215,13,215,15],[217,1,217,10],[217,11,217,12],[217,13,217,15],[217,18,217,20],[215,17,215,19],[200,0,201,0],[200,1,201,1],[200,2,201,2],[200,14,201,14],[200,15,201,15],[200,16,201,16],[200,17,201,17],[200,18,201,18],[200,19,201,19],[200,20,201,20],[202,0,203,0],[202,1,203,1],[202,2,203,2],[202,14,203,14],[202,15,203,15],[202,16,203,16],[202,17,203,17],[202,18,203,18],[202,19,203,19],[202,20,203,20],[196,0,197,0],[196,1,197,1],[196,2,197,2],[196,14,197,14],[196,15,197,15],[196,16,197,16],[196,17,197,17],[196,18,197,18],[196,19,197,19],[196,20,197,20],[198,0,199,0],[198,1,199,1],[198,2,199,2],[198,14,199,14],[198,15,199,15],[198,16,199,16],[198,17,199,17],[198,18,199,18],[198,19,199,19],[198,20,199,20],[192,0,193,0],[192,1,193,1],[192,2,193,2],[192,14,193,14],[192,15,193,15],[192,16,193,16],[192,17,193,17],[192,18,193,18],[192,19,193,19],[192,20,193,20],[194,0,195,0],[194,1,195,1],[194,2,195,2],[194,14,195,14],[194,15,195,15],[194,16,195,16],[194,17,195,17],[194,18,195,18],[194,19,195,19],[194,20,195,20],[182,1,182,10],[182,11,182,12],[182,13,182,15],[182,18,182,20],[188,0,189,0],[188,1,189,1],[188,2,189,2],[188,14,189,14],[188,15,189,15],[188,16,189,16],[188,17,189,17],[188,18,189,18],[188,19,189,19],[188,20,189,20],[190,0,191,0],[190,1,191,1],[190,2,191,2],[190,14,191,14],[190,15,191,15],[190,16,191,16],[190,17,191,17],[190,18,191,18],[190,19,191,19],[190,20,191,20],[169,17,170,17],[169,18,170,18],[169,19,170,19],[169,20,170,20],[175,0,175,20],[176,0,176,20],[169,0,170,0],[169,1,170,1],[169,2,170,2],[169,14,170,14],[169,15,170,15],[169,16,170,16],[178,1,178,2],[178,6,178,10],[178,13,178,15],[178,17,178,20],[180,2,180,10],[180,13,180,15],[180,17,180,19],[163,0,164,0],[163,1,164,1],[163,2,164,2],[163,14,164,14],[163,15,164,15],[163,16,164,16],[163,17,164,17],[163,18,164,18],[163,19,164,19],[163,20,164,20],[165,0,166,0],[165,1,166,1],[165,2,166,2],[165,14,166,14],[165,15,166,15],[165,16,166,16],[167,0,168,0],[167,1,168,1],[167,2,168,2],[167,14,168,14],[167,15,168,15],[167,16,168,16],[165,17,166,17],[165,18,166,18],[165,19,166,19],[165,20,166,20],[159,0,160,0],[159,1,160,1],[159,2,160,2],[159,14,160,14],[159,15,160,15],[159,16,160,16],[159,17,160,17],[159,18,160,18],[159,19,160,19],[159,20,160,20],[161,0,162,0],[161,1,162,1],[161,2,162,2],[161,14,162,14],[161,15,162,15],[161,16,162,16],[161,17,162,17],[161,18,162,18],[161,19,162,19],[161,20,162,20],[155,0,156,0],[155,1,156,1],[155,2,156,2],[155,14,156,14],[155,15,156,15],[155,16,156,16],[155,17,156,17],[155,18,156,18],[155,19,156,19],[155,20,156,20],[157,0,158,0],[157,1,158,1],[157,2,158,2],[157,14,158,14],[157,15,158,15],[157,16,158,16],[157,17,158,17],[157,18,158,18],[157,19,158,19],[157,20,158,20],[45,1,47,1],[45,17,47,17],[45,18,47,18],[45,19,47,19],[143,1,143,2],[143,6,143,10],[143,13,143,15],[143,17,143,20],[145,2,145,10],[145,13,145,15],[145,17,145,19],[147,1,147,10],[147,11,147,12],[147,13,147,15],[147,18,147,20],[153,0,154,0],[153,1,154,1],[153,2,154,2],[153,14,154,14],[153,15,154,15],[153,16,154,16],[153,17,154,17],[153,18,154,18],[153,19,154,19],[153,20,154,20],[115,20,117,20],[116,2,117,2],[150,1,152,1],[150,14,152,14],[150,15,152,15],[150,16,152,16],[150,17,152,17],[132,0,133,0],[132,1,133,1],[132,2,133,2],[132,14,133,14],[132,15,133,15],[132,16,133,16],[132,17,133,17],[132,18,133,18],[132,19,133,19],[132,20,133,20],[134,0,135,0],[134,1,135,1],[134,2,135,2],[134,14,135,14],[134,15,135,15],[134,16,135,16],[134,17,135,17],[134,18,135,18],[134,19,135,19],[134,20,135,20],[128,0,129,0],[128,1,129,1],[128,2,129,2],[128,14,129,14],[128,15,129,15],[128,16,129,16],[128,17,129,17],[128,18,129,18],[128,19,129,19],[128,20,129,20],[130,0,131,0],[130,1,131,1],[130,2,131,2],[130,14,131,14],[130,15,131,15],[130,16,131,16],[130,17,131,17],[130,18,131,18],[130,19,131,19],[130,20,131,20],[124,0,125,0],[124,1,125,1],[124,2,125,2],[124,14,125,14],[124,15,125,15],[124,16,125,16],[124,17,125,17],[124,18,125,18],[124,19,125,19],[124,20,125,20],[126,0,127,0],[126,1,127,1],[126,2,127,2],[126,14,127,14],[126,15,127,15],[126,16,127,16],[126,17,127,17],[126,18,127,18],[126,19,127,19],[126,20,127,20],[120,0,121,0],[120,1,121,1],[120,2,121,2],[120,14,121,14],[120,15,121,15],[120,16,121,16],[120,17,121,17],[120,18,121,18],[120,19,121,19],[120,20,121,20],[122,0,123,0],[122,1,123,1],[122,2,123,2],[122,14,123,14],[122,15,123,15],[122,16,123,16],[122,17,123,17],[122,18,123,18],[122,19,123,19],[122,20,123,20],[108,1,108,2],[108,6,108,10],[108,13,108,15],[108,17,108,20],[110,2,110,10],[110,13,110,15],[110,17,110,19],[112,1,112,10],[112,11,112,12],[112,13,112,15],[112,18,112,20],[118,0,119,0],[118,1,119,1],[118,2,119,2],[118,14,119,14],[118,15,119,15],[118,16,119,16],[118,17,119,17],[118,18,119,18],[118,19,119,19],[118,20,119,20],[110,20,110,21],[95,0,96,0],[95,1,96,1],[95,2,96,2],[95,14,96,14],[95,15,96,15],[95,16,96,16],[97,0,98,0],[97,1,98,1],[97,2,98,2],[97,14,98,14],[97,15,98,15],[97,16,98,16],[97,17,98,17],[97,18,98,18],[97,19,98,19],[97,20,98,20],[99,0,100,0],[99,1,100,1],[99,2,100,2],[99,14,100,14],[99,15,100,15],[99,16,100,16],[99,17,100,17],[99,18,100,18],[99,19,100,19],[99,20,100,20],[91,0,92,0],[91,1,92,1],[91,2,92,2],[91,14,92,14],[91,15,92,15],[91,16,92,16],[91,17,92,17],[91,18,92,18],[91,19,92,19],[91,20,92,20],[93,0,94,0],[93,1,94,1],[93,2,94,2],[93,14,94,14],[93,15,94,15],[93,16,94,16],[93,17,94,17],[93,18,94,18],[93,19,94,19],[93,20,94,20],[87,0,88,0],[87,1,88,1],[87,2,88,2],[87,14,88,14],[87,15,88,15],[87,16,88,16],[87,17,88,17],[87,18,88,18],[87,19,88,19],[87,20,88,20],[89,0,90,0],[89,1,90,1],[89,2,90,2],[89,14,90,14],[89,15,90,15],[89,16,90,16],[89,17,90,17],[89,18,90,18],[89,19,90,19],[89,20,90,20],[83,0,84,0],[83,1,84,1],[83,2,84,2],[83,14,84,14],[83,15,84,15],[83,16,84,16],[83,17,84,17],[83,18,84,18],[85,0,86,0],[85,1,86,1],[85,2,86,2],[85,14,86,14],[85,15,86,15],[85,16,86,16],[85,17,86,17],[85,18,86,18],[85,19,86,19],[64,0,65,0],[64,1,65,1],[64,2,65,2],[64,14,65,14],[64,15,65,15],[64,16,65,16],[64,17,65,17],[64,18,65,18],[64,19,65,19],[77,13,77,15],[77,18,77,20],[64,20,65,20],[70,0,70,20],[71,0,71,20],[73,1,73,2],[73,6,73,10],[73,13,73,15],[73,17,73,20],[75,20,75,21],[77,1,77,10],[60,0,61,0],[60,1,61,1],[60,2,61,2],[60,14,61,14],[60,15,61,15],[60,16,61,16],[60,17,61,17],[60,18,61,18],[60,19,61,19],[60,20,61,20],[62,0,63,0],[62,1,63,1],[62,2,63,2],[62,14,63,14],[62,15,63,15],[62,16,63,16],[62,17,63,17],[62,18,63,18],[62,19,63,19],[62,20,63,20],[54,0,55,0],[54,1,55,1],[54,2,55,2],[54,14,55,14],[54,15,55,15],[54,16,55,16],[54,17,55,17],[54,18,55,18],[54,19,55,19],[54,20,55,20],[56,0,57,0],[56,1,57,1],[56,2,57,2],[56,14,57,14],[56,15,57,15],[56,16,57,16],[58,0,59,0],[58,1,59,1],[58,2,59,2],[58,14,59,14],[58,15,59,15],[58,16,59,16],[58,17,59,17],[58,18,59,18],[58,19,59,19],[58,20,59,20],[153,21,154,21],[27,16,28,16],[27,17,28,17],[27,18,28,18],[27,19,28,19],[27,20,28,20],[29,17,30,17],[29,18,30,18],[29,19,30,19],[29,20,30,20],[29,0,30,0],[29,1,30,1],[29,14,30,14],[29,15,30,15],[29,16,30,16],[35,0,35,20],[36,0,36,20],[38,1,38,2],[38,6,38,10],[38,13,38,15],[38,17,38,20],[40,2,40,10],[40,13,40,15],[42,1,42,10],[42,11,42,12],[42,13,42,15],[42,18,42,20],[48,0,49,0],[48,1,49,1],[48,2,49,2],[48,14,49,14],[48,15,49,15],[149,3,149,13],[149,14,149,21],[23,16,24,16],[23,17,24,17],[23,18,24,18],[23,19,24,19],[23,20,24,20]],"merged_total":1260,"flags":["merged_cut"]}
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",null,null,"PROJECT NO.",null,null,null,null,null,null,null,null,"WEEK ENDING:",null,null,null,"COUNTY:"]
[]
[null,"REPORTING CONTRACTOR:",null,null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,null,null,null,"CONTRACT LETTING DATE:"]
[]
["PRIME CONTRACTOR:",null,null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,null,null,null,"WAGE DECISION:",null,"2015-10-09"]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (*These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri.","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E14:K14)","v":0},null,{"$f":"+L14*M14","v":0},null,null,null,null,null,null,{"$f":"SUM(R14:T15)","v":0},{"$f":"+Q14-U14","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M14*1.5","v":0},{"$f":"+L15*M15","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R16:T17)","v":0},{"$f":"+Q16-U16","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M16*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R18:T19)","v":0},{"$f":"+Q18-U18","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M18*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R20:T21)","v":0},{"$f":"+Q20-U20","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M20*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R22:T23)","v":0},{"$f":"+Q22-U22","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M22*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R24:T25)","v":0},{"$f":"+Q24-U24","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M24*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R26:T27)","v":0},{"$f":"+Q26-U26","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M26*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R28:T29)","v":0},{"$f":"+Q28-U28","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M28*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R30:T31)","v":0},{"$f":"+Q30-U30","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M30*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,"See \"Instruction\" tab for more details.",null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx "]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B4","v":0},null,"PROJECT NO.",null,null,{"$f":"+G4","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N4","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R4","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C6","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N6","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U6","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B8","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N8","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S8","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E49:K49)","v":0},null,{"$f":"+L49*M49","v":0},null,null,null,null,null,null,{"$f":"SUM(R49:T50)","v":0},{"$f":"+Q49-U49","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M49*1.5","v":0},{"$f":"+L50*M50","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R51:T52)","v":0},{"$f":"+Q51-U51","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M51*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R53:T54)","v":0},{"$f":"+Q53-U53","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M53*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R55:T56)","v":0},{"$f":"+Q55-U55","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M55*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R57:T58)","v":0},{"$f":"+Q57-U57","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M57*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R59:T60)","v":0},{"$f":"+Q59-U59","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M59*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R61:T62)","v":0},{"$f":"+Q61-U61","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M61*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R63:T64)","v":0},{"$f":"+Q63-U63","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M63*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R65:T66)","v":0},{"$f":"+Q65-U65","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M65*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B39","v":0},null,"PROJECT NO.",null,null,{"$f":"+G39","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N39","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R39","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C41","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N41","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U41","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B43","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N43","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S43","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E84:K84)","v":0},null,{"$f":"+L84*M84","v":0},null,null,null,null,null,null,{"$f":"SUM(R84:T85)","v":0},{"$f":"+Q84-U84","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M84*1.5","v":0},{"$f":"+L85*M85","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R86:T87)","v":0},{"$f":"+Q86-U86","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M86*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R88:T89)","v":0},{"$f":"+Q88-U88","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M88*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R90:T91)","v":0},{"$f":"+Q90-U90","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M90*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R92:T93)","v":0},{"$f":"+Q92-U92","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M92*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R94:T95)","v":0},{"$f":"+Q94-U94","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M94*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R96:T97)","v":0},{"$f":"+Q96-U96","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M96*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R98:T99)","v":0},{"$f":"+Q98-U98","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M98*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R100:T101)","v":0},{"$f":"+Q100-U100","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M100*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B74","v":0},null,"PROJECT NO.",null,null,{"$f":"+G74","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N74","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R74","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C76","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N76","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U76","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B78","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N78","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S78","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E119:K119)","v":0},null,{"$f":"+L119*M119","v":0},null,null,null,null,null,null,{"$f":"SUM(R119:T120)","v":0},{"$f":"+Q119-U119","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M119*1.5","v":0},{"$f":"+L120*M120","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R121:T122)","v":0},{"$f":"+Q121-U121","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M121*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R123:T124)","v":0},{"$f":"+Q123-U123","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M123*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R125:T126)","v":0},{"$f":"+Q125-U125","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M125*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R127:T128)","v":0},{"$f":"+Q127-U127","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M127*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R129:T130)","v":0},{"$f":"+Q129-U129","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M129*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R131:T132)","v":0},{"$f":"+Q131-U131","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M131*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R133:T134)","v":0},{"$f":"+Q133-U133","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M133*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R135:T136)","v":0},{"$f":"+Q135-U135","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M135*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B109","v":0},null,"PROJECT NO.",null,null,{"$f":"+G109","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N109","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R109","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C111","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N111","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U111","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B113","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N113","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S113","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E154:K154)","v":0},null,{"$f":"+L154*M154","v":0},null,null,null,null,null,null,{"$f":"SUM(R154:T155)","v":0},{"$f":"+Q154-U154","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M154*1.5","v":0},{"$f":"+L155*M155","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R156:T157)","v":0},{"$f":"+Q156-U156","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M156*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R158:T159)","v":0},{"$f":"+Q158-U158","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M158*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R160:T161)","v":0},{"$f":"+Q160-U160","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M160*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R162:T163)","v":0},{"$f":"+Q162-U162","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M162*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R164:T165)","v":0},{"$f":"+Q164-U164","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M164*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R166:T167)","v":0},{"$f":"+Q166-U166","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M166*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R168:T169)","v":0},{"$f":"+Q168-U168","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M168*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R170:T171)","v":0},{"$f":"+Q170-U170","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M170*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B144","v":0},null,"PROJECT NO.",null,null,{"$f":"+G144","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N144","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R144","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C146","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N146","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U146","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B148","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N148","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S148","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E189:K189)","v":0},null,{"$f":"+L189*M189","v":0},null,null,null,null,null,null,{"$f":"SUM(R189:T190)","v":0},{"$f":"+Q189-U189","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M189*1.5","v":0},{"$f":"+L190*M190","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R191:T192)","v":0},{"$f":"+Q191-U191","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M191*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R193:T194)","v":0},{"$f":"+Q193-U193","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M193*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R195:T196)","v":0},{"$f":"+Q195-U195","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M195*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R197:T198)","v":0},{"$f":"+Q197-U197","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M197*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R199:T200)","v":0},{"$f":"+Q199-U199","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M199*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R201:T202)","v":0},{"$f":"+Q201-U201","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M201*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R203:T204)","v":0},{"$f":"+Q203-U203","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M203*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R205:T206)","v":0},{"$f":"+Q205-U205","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M205*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B179","v":0},null,"PROJECT NO.",null,null,{"$f":"+G179","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N179","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R179","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C181","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N181","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U181","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B183","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N183","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S183","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E224:K224)","v":0},null,{"$f":"+L224*M224","v":0},null,null,null,null,null,null,{"$f":"SUM(R224:T225)","v":0},{"$f":"+Q224-U224","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M224*1.5","v":0},{"$f":"+L225*M225","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R226:T227)","v":0},{"$f":"+Q226-U226","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M226*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R228:T229)","v":0},{"$f":"+Q228-U228","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M228*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R230:T231)","v":0},{"$f":"+Q230-U230","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M230*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R232:T233)","v":0},{"$f":"+Q232-U232","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M232*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R234:T235)","v":0},{"$f":"+Q234-U234","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M234*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R236:T237)","v":0},{"$f":"+Q236-U236","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M236*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R238:T239)","v":0},{"$f":"+Q238-U238","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M238*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R240:T241)","v":0},{"$f":"+Q240-U240","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M240*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B214","v":0},null,"PROJECT NO.",null,null,{"$f":"+G214","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N214","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R214","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C216","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N216","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U216","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B218","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N218","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S218","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E259:K259)","v":0},null,{"$f":"+L259*M259","v":0},null,null,null,null,null,null,{"$f":"SUM(R259:T260)","v":0},{"$f":"+Q259-U259","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M259*1.5","v":0},{"$f":"+L260*M260","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R261:T262)","v":0},{"$f":"+Q261-U261","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M261*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R263:T264)","v":0},{"$f":"+Q263-U263","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M263*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R265:T266)","v":0},{"$f":"+Q265-U265","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M265*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R267:T268)","v":0},{"$f":"+Q267-U267","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M267*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R269:T270)","v":0},{"$f":"+Q269-U269","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M269*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R271:T272)","v":0},{"$f":"+Q271-U271","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M271*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R273:T274)","v":0},{"$f":"+Q273-U273","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M273*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R275:T276)","v":0},{"$f":"+Q275-U275","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M275*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B249","v":0},null,"PROJECT NO.",null,null,{"$f":"+G249","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N249","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R249","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C251","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N251","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U251","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B253","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N253","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S253","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E294:K294)","v":0},null,{"$f":"+L294*M294","v":0},null,null,null,null,null,null,{"$f":"SUM(R294:T295)","v":0},{"$f":"+Q294-U294","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M294*1.5","v":0},{"$f":"+L295*M295","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R296:T297)","v":0},{"$f":"+Q296-U296","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M296*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R298:T299)","v":0},{"$f":"+Q298-U298","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M298*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R300:T301)","v":0},{"$f":"+Q300-U300","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M300*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R302:T303)","v":0},{"$f":"+Q302-U302","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M302*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R304:T305)","v":0},{"$f":"+Q304-U304","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M304*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R306:T307)","v":0},{"$f":"+Q306-U306","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M306*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R308:T309)","v":0},{"$f":"+Q308-U308","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M308*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R310:T311)","v":0},{"$f":"+Q310-U310","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M310*1.5","v":0},0]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]
["C e r t i f i e d   P a y r o l l  R e p o r t"]
["(MEETS STATE AND FEDERAL PAYROLL REQUIREMENTS)"]
[]
["PCN NO. (see Note 1):",{"$f":"+B284","v":0},null,"PROJECT NO.",null,null,{"$f":"+G284","v":0},null,null,null,null,null,"WEEK ENDING:",{"$f":"+N284","v":"00:00:00"},null,null,"COUNTY:",{"$f":"+R284","v":0}]
[]
[null,"REPORTING CONTRACTOR",{"$f":"+C286","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",{"$f":"+N286","v":0},null,null,null,"CONTRACT LETTING DATE:",null,null,{"$f":"+U286","v":"00:00:00"}]
[]
["PRIME CONTRACTOR:",{"$f":"+B288","v":0},null,null,null,null,null,null,null,null,null,"TELEPHONE:",null,{"$f":"+N288","v":0},null,null,"WAGE DECISION:",null,{"$f":"+S288","v":"2015-10-09"}]
[]
["Col A","Col B","Col C","T  H  I  S    P  R  O  J  E  C  T ",null,null,null,null,null,null,null,null,null,null,"A L L   P R O J E C T S   (These amounts must match weekly pay stubs.)"]
["Employee's Full Name &","SDDOT Group Code",null,"Colums D-K:  HOURS WORKED EACH DAY ",null,null,null,null,null,null,null,"Col L ","Col M","Col N","Col O\nTotal\nWeekly\nHours*","Col P Total\nWeekly \"Bona-\nFide\" ER\nFringe\nBenefits","Col Q\nTotal Weekly\nGross Pay*","Col R\nSOC SEC\nTax Withheld*","Col S\nFED Tax\nWithheld*","Col T\nOther\nWithheld*","Col U\nTOTAL\nWithheld*","Col V\nTOTAL\nNet Wages*"]
[" Individual Identifying No.",null,"Work Class","ST ","Sun.","Mon.","Tue.","Wed.","Thu.","Fri,","Sat.","Total ST hrs","Base","Gross ST"]
["(e.g. last 4 digits of SS number)",null,null,"OT","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2015-08-08","Total OT hrs","Hourly Wage","Gross OT"]
[null,null,null,"ST ",null,null,null,null,null,null,null,{"$f":"SUM(E329:K329)","v":0},null,{"$f":"+L329*M329","v":0},null,null,null,null,null,null,{"$f":"SUM(R329:T330)","v":0},{"$f":"+Q329-U329","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M329*1.5","v":0},{"$f":"+L330*M330","v":0}]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R331:T332)","v":0},{"$f":"+Q331-U331","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M331*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R333:T334)","v":0},{"$f":"+Q333-U333","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M333*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R335:T336)","v":0},{"$f":"+Q335-U335","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M335*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R337:T338)","v":0},{"$f":"+Q337-U337","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M337*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R339:T340)","v":0},{"$f":"+Q339-U339","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M339*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R341:T342)","v":0},{"$f":"+Q341-U341","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M341*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R343:T344)","v":0},{"$f":"+Q343-U343","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M343*1.5","v":0},0]
[null,null,null,"ST ",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(R345:T346)","v":0},{"$f":"+Q345-U345","v":0}]
[null,null,null,"OT",null,null,null,null,null,null,null,0,{"$f":"+M345*1.5","v":0}]
["Note 1: Failure to list Project Control Number (PCN) will delay processing.",null,null,null,null,null,null,null,null,null,null,null,"Note 2: Contract LETTING Date determines the correct Wage Decision."]
["Note 3: Update daily dates and enter daily regular & overtime project hours worked by employees.",null,null,null,null,null,null,null,null,null,null,null,"Note 4: SDDOT Group Code AND specific Work Classification are required to be reported."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev:","March-2017"]
["This SDDOT form is available online at: ",null,null,null,"http://www.sddot.com/business/contractors/labor/payrolls/Default.aspx"]