{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["PR Liability","Format","Quick Report","Bart, D","Bradley, R","Johnson, S","Morgan, P","Zed, S","McClellan, S","Macky, J"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"PR Liability","index":0,"n_rows":23,"n_cols":111,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,108],[1,8,1,108]]}
["PTO 2014"]
[null,null,null,null,null,null,null,null,"Pay  Date"]
[null,null,null,null,null,null,null,null,"PR1",null,null,null,"PR2",null,null,null,"PR3",null,null,null,"PR4",null,null,null,"PR5",null,null,null,"PR6",null,null,null,"PR7",null,null,null,"PR8",null,null,null,"PR9",null,null,null,"PR10",null,null,null,"PR11",null,null,null,"PR12",null,null,null,"PR13",null,null,null,"PR14",null,null,null,"PR15",null,null,null,"PR16",null,null,null,"PR17",null,null,null,"PR18",null,null,null,"PR19",null,null,null,"PR20",null,null,null,"PR21",null,null,null,"PR22",null,null,null,"PR23",null,null,null,"PR24",null,null,null,"PR25",null,null,null,"PR26"]
[null,"Carryover from 2013","Carry over cost from 2013","Used this Year","Accrued this year","Pay Rate","Total Liability\nfor 2014","Hours Earned","2014-01-10","Historical","Adjustment","Hours Earned","2014-01-24","Historical","Adjustment","Hours Earned","2014-02-07","Historical","Adjustment","Hours Earned","2014-02-21","Historical","Adjustment","Hours Earned","2014-03-07","Historical","Adjustment","Hours Earned","2014-03-21","Historical","Adjustment","Hours Earned","2014-04-04","Historical","Adjustment","Hours Earned","2014-04-18","Historical","Adjustment","Hours Earned","2014-05-02","Historical","Adjustment","Hours Earned","2014-05-16","Historical","Adjustment","Hours Earned","2014-05-30","Historical","Adjustment","Hours Earned","2014-06-12","Historical","Adjustment","Hours Earned","2014-06-27","Historical","Adjustment","Hours Earned","2014-07-11","Historical","Adjustment","Hours Earned","2014-07-25","Historical","Adjustment","Hours Earned","2014-08-08","Historical","Adjustment","Hours Earned","2014-08-22","Historical","Adjustment","Hours Earned","2014-09-05","Historical","Adjustment","Hours Earned","2014-09-19","Historical","Adjustment","Hours Earned","2014-10-03","Historical","Adjustment","Hours Earned","2014-10-17","Historical","Adjustment","Hours Earned","2014-10-31","Historical","Adjustment","Hours Earned","2014-11-14","Historical","Adjustment","Hours Earned","2014-11-28","Historical","Adjustment","Hours Earned","2014-12-12","Historical","Adjustment","Hours Earned","2014-12-26","Historical","Adjustment"]
["Bart, David",{"$f":"'Bart, D'!H6","v":71.459999999999994},{"$f":"B5*F5","v":3930.2999999999997},{"$f":"'Bart, D'!H39","v":10},{"$f":"'Bart, D'!H5","v":36.538525},55,{"$f":"E5*F5","v":2009.6188749999999},{"$f":"'Bart, D'!F12","v":4.2265250000000005},{"$f":"H5*F5","v":232.45887500000003},203.21129999999999,null,{"$f":"'Bart, D'!F13","v":4.6159999999999997},{"$f":"L5*F5","v":253.88},221.93729999999999,null,{"$f":"'Bart, D'!F14","v":4.6159999999999997},{"$f":"P5*F5","v":253.88},221.93729999999999,null,{"$f":"'Bart, D'!F15","v":4.6159999999999997},{"$f":"T5*F5","v":253.88},221.93729999999999,715.40707300000008,{"$f":"'Bart, D'!F16","v":4.6159999999999997},{"$f":"X5*F5","v":253.88},null,null,{"$f":"'Bart, D'!F17","v":4.6159999999999997},{"$f":"AB5*F5","v":253.88},null,null,{"$f":"'Bart, D'!F18","v":4.6159999999999997},{"$f":"AF5*F5","v":253.88},null,null,{"$f":"'Bart, D'!F19","v":0},{"$f":"AJ5*F5","v":0},null,null,{"$f":"'Bart, D'!F20","v":4.6159999999999997},{"$f":"AN5*F5","v":253.88},null,null,{"$f":"'Bart, D'!F21","v":0},{"$f":"AR5*F5","v":0},null,null,{"$f":"'Bart, D'!F22","v":0},{"$f":"AV5*F5","v":0},null,null,{"$f":"'Bart, D'!F23","v":0},{"$f":"AZ5*F5","v":0},null,null,{"$f":"'Bart, D'!F24","v":0},{"$f":"BD5*F5","v":0},null,null,{"$f":"'Bart, D'!F25","v":0},{"$f":"BH5*F5","v":0},null,null,{"$f":"'Bart, D'!F26","v":0},{"$f":"BL5*F5","v":0},null,null,{"$f":"'Bart, D'!F27","v":0},{"$f":"BP5*F5","v":0},null,null,{"$f":"'Bart, D'!F28","v":0},{"$f":"BT5*F5","v":0},null,null,{"$f":"'Bart, D'!F29","v":0},{"$f":"BX5*F5","v":0},null,null,{"$f":"'Bart, D'!F30","v":0},{"$f":"CB5*F5","v":0},null,null,{"$f":"'Bart, D'!F31","v":0},{"$f":"CF5*F5","v":0},null,null,{"$f":"'Bart, D'!F32","v":0},{"$f":"CJ5*F5","v":0},null,null,{"$f":"'Bart, D'!F33","v":0},{"$f":"CN5*F5","v":0},null,null,{"$f":"'Bart, D'!F34","v":0},{"$f":"CR5*F5","v":0},null,null,{"$f":"'Bart, D'!F35","v":0},{"$f":"CV5*F5","v":0},null,null,{"$f":"'Bart, D'!F36","v":0},{"$f":"CZ5*F5","v":0},null,null,{"$f":"'Bart, D'!F37","v":0},{"$f":"DD5*F5","v":0}]
["Bradley, Ryan",{"$f":"'Bradley, R'!H6","v":36.950000000000003},1030.5355000000002,{"$f":"'Bradley, R'!H39","v":27},{"$f":"'Bradley, R'!H5","v":24.64},27.89,687.20960000000002,{"$f":"'Bradley, R'!F12","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F13","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F14","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F15","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F16","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F17","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F18","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F19","v":0},0,null,null,{"$f":"'Bradley, R'!F20","v":3.08},85.901200000000003,null,null,{"$f":"'Bradley, R'!F21","v":0},0,null,null,{"$f":"'Bradley, R'!F22","v":0},0,null,null,{"$f":"'Bradley, R'!F23","v":0},0,null,null,{"$f":"'Bradley, R'!F24","v":0},0,null,null,{"$f":"'Bradley, R'!F25","v":0},0,null,null,{"$f":"'Bradley, R'!F26","v":0},0,null,null,{"$f":"'Bradley, R'!F27","v":0},0,null,null,{"$f":"'Bradley, R'!F28","v":0},0,null,null,{"$f":"'Bradley, R'!F29","v":0},0,null,null,{"$f":"'Bradley, R'!F30","v":0},0,null,null,{"$f":"'Bradley, R'!F31","v":0},0,null,null,{"$f":"'Bradley, R'!F32","v":0},0,null,null,{"$f":"'Bradley, R'!F33","v":0},0,null,null,{"$f":"'Bradley, R'!F34","v":0},0,null,null,{"$f":"'Bradley, R'!F35","v":0},0,null,null,{"$f":"'Bradley, R'!F36","v":0},0,null,null,{"$f":"'Bradley, R'!F37","v":0},0]
["Johnson, Scott",{"$f":"'Johnson, S'!H6","v":27.8},1109.4979999999998,{"$f":"'Johnson, S'!H39","v":24},{"$f":"'Johnson, S'!H5","v":24.64},39.909999999999997,983.38239999999996,{"$f":"'Johnson, S'!F12","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F13","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F14","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F15","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F16","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F17","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F18","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F19","v":0},0,null,null,{"$f":"'Johnson, S'!F20","v":3.08},122.9228,null,null,{"$f":"'Johnson, S'!F21","v":0},0,null,null,{"$f":"'Johnson, S'!F22","v":0},0,null,null,{"$f":"'Johnson, S'!F23","v":0},0,null,null,{"$f":"'Johnson, S'!F24","v":0},0,null,null,{"$f":"'Johnson, S'!F25","v":0},0,null,null,{"$f":"'Johnson, S'!F26","v":0},0,null,null,{"$f":"'Johnson, S'!F27","v":0},0,null,null,{"$f":"'Johnson, S'!F28","v":0},0,null,null,{"$f":"'Johnson, S'!F29","v":0},0,null,null,{"$f":"'Johnson, S'!F30","v":0},0,null,null,{"$f":"'Johnson, S'!F31","v":0},0,null,null,{"$f":"'Johnson, S'!F32","v":0},0,null,null,{"$f":"'Johnson, S'!F33","v":0},0,null,null,{"$f":"'Johnson, S'!F34","v":0},0,null,null,{"$f":"'Johnson, S'!F35","v":0},0,null,null,{"$f":"'Johnson, S'!F36","v":0},0,null,null,{"$f":"'Johnson, S'!F37","v":0},0]
["Macky, Johnny ",{"$f":"'Macky, J'!$H$6","v":0},0,{"$f":"'Macky, J'!$H$39","v":0},{"$f":"'Macky, J'!$H$5","v":0},14,0,{"$f":"'Macky, J'!$F$12","v":0},0,null,null,{"$f":"'Macky, J'!$F$13","v":0},0,null,null,{"$f":"'Macky, J'!$F$14","v":0},0,null,null,{"$f":"'Macky, J'!$F$15","v":0},0,null,null,{"$f":"'Macky, J'!$F$16","v":0},0,null,null,{"$f":"'Macky, J'!$F$17","v":0},0,null,null,{"$f":"'Macky, J'!$F$18","v":0},0,null,null,{"$f":"'Macky, J'!$F$19","v":0},0,null,null,{"$f":"'Macky, J'!$F$20","v":0},0,null,null,{"$f":"'Macky, J'!$F$21","v":0},0,null,null,{"$f":"'Macky, J'!$F$22","v":0},0,null,null,{"$f":"'Macky, J'!$F$23","v":0},0,null,null,{"$f":"'Macky, J'!$F$24","v":0},0,null,null,{"$f":"'Macky, J'!$F$25","v":0},0,null,null,{"$f":"'Macky, J'!$F$26","v":0},0,null,null,{"$f":"'Macky, J'!$F$27","v":0},0,null,null,{"$f":"'Macky, J'!$F$28","v":0},0,null,null,{"$f":"'Macky, J'!$F$29","v":0},0,null,null,{"$f":"'Macky, J'!$F$30","v":0},0,null,null,{"$f":"'Macky, J'!$F$31","v":0},0,null,null,{"$f":"'Macky, J'!$F$32","v":0},0,null,null,{"$f":"'Macky, J'!$F$33","v":0},0,null,null,{"$f":"'Macky, J'!$F$34","v":0},0,null,null,{"$f":"'Macky, J'!$F$35","v":0},0,null,null,{"$f":"'Macky, J'!$F$36","v":0},0,null,null,{"$f":"'Macky, J'!$F$37","v":0},0]
["McClellan, Scott",{"$f":"'McClellan, S'!$H$6","v":0},0,{"$f":"'McClellan, S'!$H$39","v":0},{"$f":"'McClellan, S'!$H$5","v":3.08},15,46.2,{"$f":"'McClellan, S'!$F$12","v":0},0,null,null,{"$f":"'McClellan, S'!$F$13","v":0},0,null,null,{"$f":"'McClellan, S'!$F$14","v":0},0,null,null,{"$f":"'McClellan, S'!$F$15","v":0},0,null,null,{"$f":"'McClellan, S'!$F$16","v":0},0,null,null,{"$f":"'McClellan, S'!$F$17","v":0},0,null,null,{"$f":"'McClellan, S'!$F$18","v":0},0,null,null,{"$f":"'McClellan, S'!$F$19","v":0},0,null,null,{"$f":"'McClellan, S'!$F$20","v":3.08},46.2,null,null,{"$f":"'McClellan, S'!$F$21","v":0},0,null,null,{"$f":"'McClellan, S'!$F$22","v":0},0,null,null,{"$f":"'McClellan, S'!$F$23","v":0},0,null,null,{"$f":"'McClellan, S'!$F$24","v":0},0,null,null,{"$f":"'McClellan, S'!$F$25","v":0},0,null,null,{"$f":"'McClellan, S'!$F$26","v":0},0,null,null,{"$f":"'McClellan, S'!$F$27","v":0},0,null,null,{"$f":"'McClellan, S'!$F$28","v":0},0,null,null,{"$f":"'McClellan, S'!$F$29","v":0},0,null,null,{"$f":"'McClellan, S'!$F$30","v":0},0,null,null,{"$f":"'McClellan, S'!$F$31","v":0},0,null,null,{"$f":"'McClellan, S'!$F$32","v":0},0,null,null,{"$f":"'McClellan, S'!$F$33","v":0},0,null,null,{"$f":"'McClellan, S'!$F$34","v":0},0,null,null,{"$f":"'McClellan, S'!$F$35","v":0},0,null,null,{"$f":"'McClellan, S'!$F$36","v":0},0,null,null,{"$f":"'McClellan, S'!$F$37","v":0},0]
["Morgan, Paul",{"$f":"'Morgan, P'!H6","v":29.8},1088.8920000000001,{"$f":"'Morgan, P'!H39","v":38},{"$f":"'Morgan, P'!H5","v":36.927999999999997},36.54,1349.3491199999999,{"$f":"'Morgan, P'!F12","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F13","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F14","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F15","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F16","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F17","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F18","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F19","v":0},0,null,null,{"$f":"'Morgan, P'!F20","v":4.6159999999999997},168.66863999999998,null,null,{"$f":"'Morgan, P'!F21","v":0},0,null,null,{"$f":"'Morgan, P'!F22","v":0},0,null,null,{"$f":"'Morgan, P'!F23","v":0},0,null,null,{"$f":"'Morgan, P'!F24","v":0},0,null,null,{"$f":"'Morgan, P'!F25","v":0},0,null,null,{"$f":"'Morgan, P'!F26","v":0},0,null,null,{"$f":"'Morgan, P'!F27","v":0},0,null,null,{"$f":"'Morgan, P'!F28","v":0},0,null,null,{"$f":"'Morgan, P'!F29","v":0},0,null,null,{"$f":"'Morgan, P'!F30","v":0},0,null,null,{"$f":"'Morgan, P'!F31","v":0},0,null,null,{"$f":"'Morgan, P'!F32","v":0},0,null,null,{"$f":"'Morgan, P'!F33","v":0},0,null,null,{"$f":"'Morgan, P'!F34","v":0},0,null,null,{"$f":"'Morgan, P'!F35","v":0},0,null,null,{"$f":"'Morgan, P'!F36","v":0},0,null,null,{"$f":"'Morgan, P'!F37","v":0},0]
["Zed, Sam",{"$f":"'Zed, S'!H6","v":-22.77},-821.08620000000008,{"$f":"'Zed, S'!H39","v":13},{"$f":"'Zed, S'!H5","v":36.927999999999997},36.06,1331.6236799999999,{"$f":"'Zed, S'!F12","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F13","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F14","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F15","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F16","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F17","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F18","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F19","v":0},0,null,null,{"$f":"'Zed, S'!F20","v":4.6159999999999997},166.45295999999999,null,null,{"$f":"'Zed, S'!F21","v":0},0,null,null,{"$f":"'Zed, S'!F22","v":0},0,null,null,{"$f":"'Zed, S'!F23","v":0},0,null,null,{"$f":"'Zed, S'!F24","v":0},0,null,null,{"$f":"'Zed, S'!F25","v":0},0,null,null,{"$f":"'Zed, S'!F26","v":0},0,null,null,{"$f":"'Zed, S'!F27","v":0},0,null,null,{"$f":"'Zed, S'!F28","v":0},0,null,null,{"$f":"'Zed, S'!F29","v":0},0,null,null,{"$f":"'Zed, S'!F30","v":0},0,null,null,{"$f":"'Zed, S'!F31","v":0},0,null,null,{"$f":"'Zed, S'!F32","v":0},0,null,null,{"$f":"'Zed, S'!F33","v":0},0,null,null,{"$f":"'Zed, S'!F34","v":0},0,null,null,{"$f":"'Zed, S'!F35","v":0},0,null,null,{"$f":"'Zed, S'!F36","v":0},0,null,null,{"$f":"'Zed, S'!F37","v":0},0]
[]
["TOTAL",{"$f":"SUM(B5:B12)","v":143.24},{"$f":"SUM(C5:C12)","v":6338.1392999999998},null,null,null,{"$f":"SUM(G5:G12)","v":6407.3836749999991},{"$f":"SUM(H5:H12)","v":19.618524999999998},{"$f":"SUM(I5:I12)","v":776.40447499999993},null,null,{"$f":"SUM(L5:L12)","v":20.007999999999999},{"$f":"SUM(M5:M12)","v":797.82560000000001},null,null,{"$f":"SUM(P5:P12)","v":20.007999999999999},{"$f":"SUM(Q5:Q12)","v":797.82560000000001},null,null,{"$f":"SUM(T5:T12)","v":20.007999999999999},{"$f":"SUM(U5:U12)","v":797.82560000000001},null,null,{"$f":"SUM(X5:X12)","v":20.007999999999999},{"$f":"SUM(Y5:Y12)","v":797.82560000000001},null,null,{"$f":"SUM(AB5:AB12)","v":20.007999999999999},{"$f":"SUM(AC5:AC12)","v":797.82560000000001},null,null,{"$f":"SUM(AF5:AF12)","v":20.007999999999999},{"$f":"SUM(AG5:AG12)","v":797.82560000000001},null,null,{"$f":"SUM(AJ5:AJ12)","v":0},{"$f":"SUM(AK5:AK12)","v":0},null,null,{"$f":"SUM(AN5:AN12)","v":23.088000000000001},{"$f":"SUM(AO5:AO12)","v":844.02559999999994},null,null,{"$f":"SUM(AR5:AR12)","v":0},{"$f":"SUM(AS5:AS12)","v":0},null,null,{"$f":"SUM(AV5:AV12)","v":0},{"$f":"SUM(AW5:AW12)","v":0},null,null,{"$f":"SUM(AZ5:AZ12)","v":0},{"$f":"SUM(BA5:BA12)","v":0},null,null,{"$f":"SUM(BD5:BD12)","v":0},{"$f":"SUM(BE5:BE12)","v":0},null,null,{"$f":"SUM(BH5:BH12)","v":0},{"$f":"SUM(BI5:BI12)","v":0},null,null,{"$f":"SUM(BL5:BL12)","v":0},{"$f":"SUM(BM5:BM12)","v":0},null,null,{"$f":"SUM(BP5:BP12)","v":0},{"$f":"SUM(BQ5:BQ12)","v":0},null,null,{"$f":"SUM(BT5:BT12)","v":0},{"$f":"SUM(BU5:BU12)","v":0},null,null,{"$f":"SUM(BX5:BX12)","v":0},{"$f":"SUM(BY5:BY12)","v":0},null,null,{"$f":"SUM(CB5:CB12)","v":0},{"$f":"SUM(CC5:CC12)","v":0},null,null,{"$f":"SUM(CF5:CF12)","v":0},{"$f":"SUM(CG5:CG12)","v":0},null,null,{"$f":"SUM(CJ5:CJ12)","v":0},{"$f":"SUM(CK5:CK12)","v":0},null,null,{"$f":"SUM(CN5:CN12)","v":0},{"$f":"SUM(CO5:CO12)","v":0},null,null,{"$f":"SUM(CR5:CR12)","v":0},{"$f":"SUM(CS5:CS12)","v":0},null,null,{"$f":"SUM(CV5:CV12)","v":0},{"$f":"SUM(CW5:CW12)","v":0},null,null,{"$f":"SUM(CZ5:CZ12)","v":0},{"$f":"SUM(DA5:DA12)","v":0},null,null,{"$f":"SUM(DD5:DD12)","v":0},{"$f":"SUM(DE5:DE12)","v":0}]
[null,null,null,null,null,null,null,11,null,null,null,12,null,null,null,12,null,null,null,14,null,null,null,15,null,null,null,16,null,null,null,17,null,null,null,18,null,null,null,19,null,null,null,20,null,null,null,21,null,null,null,22,null,null,null,23,null,null,null,24,null,null,null,25,null,null,null,26,null,null,null,27,null,null,null,28,null,null,null,29,null,null,null,30,null,null,null,31,null,null,null,32,null,null,null,33,null,null,null,34,null,null,null,35,null,null,null,36]
[]
[]
[]
[]
[]
[]
["Terminated Employees"]
[]
[null,null,null,null,null,{"$f":"COUNT(#REF!)","v":0}]

{"sheet":"Format","index":1,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[37,1,37,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2]]}
[null,"Employee:",null,null,null,null,null,"PTO 2014"]
[null,"Date of Hire:",null,null," ",null,"Year Type (Full or Partial):"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"D39","v":0}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 240)",null,null,{"$f":"SUM(H4*I5)","v":0}]
[null,"Prior Year Carry Over",null,null,null,null,null,0]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":0}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"H39","v":0}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":0}]
[null,"Maximin PTO allowed"]
[null,"Pay Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,null,null,{"$f":"D12*$I$5","v":0}]
[2,"2014-01-24",null,null,null,{"$f":"D13*$I$5","v":0}]
[3,"2014-02-07",null,null,null,0]
[4,"2014-02-21",null,null,null,0]
[5,"2014-03-07",null,null,null,0]
[6,"2014-03-21",null,null,null,0]
[7,"2014-04-04",null,null,null,0]
[8,"2014-04-18",null,null,null,0]
[9,"2014-05-02",null,null,null,0]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,0]
[]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":0},{"$f":"SUM(E12:E38)","v":0},null,"Used Hours",{"$f":"SUM(H12:H38)","v":0}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]

{"sheet":"Quick Report","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4],[9,1,9,2]]}
["PTO 2014"]
[null,"Used in 2014","Remaining in 2014","Pay Rate","Liability"]
["Bart, David",{"$f":"'Bart, D'!H39","v":10},{"$f":"'Bart, D'!H9","v":97.998525000000001},{"$f":"'PR Liability'!F5","v":55},{"$f":"IF((C3*D3)>0,C3*D3,0)","v":5389.9188750000003}]
["Bradley, Ryan",{"$f":"'Bradley, R'!H39","v":27},{"$f":"'Bradley, R'!H9","v":34.590000000000003},{"$f":"'PR Liability'!F6","v":27.89},964.71510000000012]
["Johnson, Scott",{"$f":"'Johnson, S'!H39","v":24},{"$f":"'Johnson, S'!H9","v":28.439999999999998},{"$f":"'PR Liability'!F7","v":39.909999999999997},1135.0403999999999]
["Macky, Johnny ",{"$f":"'Macky, J'!$H$39","v":0},{"$f":"'Macky, J'!$H$9","v":0},{"$f":"'PR Liability'!F8","v":14},0]
["McClellan, Scott",{"$f":"'McClellan, S'!$H$39","v":0},{"$f":"'McClellan, S'!$H$9","v":3.08},{"$f":"'PR Liability'!F9","v":15},46.2]
["Morgan, Paul",{"$f":"'Morgan, P'!H39","v":38},{"$f":"'Morgan, P'!H9","v":28.727999999999994},{"$f":"'PR Liability'!F10","v":36.54},1049.7211199999997]
["Zed, Sam",{"$f":"'Zed, S'!H39","v":13},{"$f":"'Zed, S'!H9","v":1.1579999999999977},{"$f":"'PR Liability'!F11","v":36.06},41.757479999999923]
[null,"TOTAL",null,null,{"$f":"SUM(E3:$E$9)","v":8627.3529749999998}]

{"sheet":"Bart, D","index":3,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[35,1,35,2],[36,1,36,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2]]}
[null,"Employee:","David Bart",null,null,null,null,"PTO 2014"]
[null,"Date of Hire:","2013-04-11",null," ",null,"Year Type (Full or Partial):",null,"F"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"SUM(D39)","v":633.25}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 240)",null,null,{"$f":"SUM(H4*I5)","v":36.538525},5.7700000000000001E-2]
[null,"Prior Year Carry Over",null,null,null,null,null,71.459999999999994]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":107.998525}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"SUM(H39)","v":10}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":97.998525000000001}]
[null,"Maximin PTO allowed",null,null,null,null,null,240]
[null,"Pay Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,73.25,73.25,{"$f":"D12*0.0577","v":4.2265250000000005},"2014-04-15",10,"test"]
[2,"2014-01-24",null,80,84.5,{"$f":"D13*0.0577","v":4.6159999999999997}]
[3,"2014-02-07",null,80,87.75,{"$f":"D14*0.0577","v":4.6159999999999997}]
[4,"2014-02-21",null,80,79.75,4.6159999999999997]
[5,"2014-03-07",null,80,88.75,4.6159999999999997]
[6,"2014-03-21",null,80,84.75,4.6159999999999997]
[7,"2014-04-04",null,80,88.5,4.6159999999999997]
[8,"2014-04-18",null,null,null,0]
[9,"2014-05-02",null,80,null,4.6159999999999997]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,{"$f":"D37*0.0577","v":0}]
[null," "]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":633.25},{"$f":"SUM(E12:E38)","v":587.25},null,"Used Hours",{"$f":"SUM(H12:H32)","v":10}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]

{"sheet":"Bradley, R","index":4,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[35,1,35,2],[36,1,36,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2]]}
[null,"Employee:","Ryan Bradley",null,null,null,null,"PTO 2014"]
[null,"Date of Hire:","2013-03-29",null," ",null,"Year Type (Full or Partial):",null,"F"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"SUM(D39)","v":640}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 160)",null,null,{"$f":"SUM(H4*I5)","v":24.64},3.85E-2]
[null,"Prior Year Carry Over",null,null,null,null,null,36.950000000000003]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":61.59}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"SUM(H39)","v":27}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":34.590000000000003}]
[null,"Maximin PTO allowed",null,null,null,null,null,160]
[null,"Pay Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,80,80,{"$f":"D12*0.0385","v":3.08},"2013-12-24",8]
[2,"2014-01-24",null,80,79.75,3.08,"2014-01-02",2.5]
[3,"2014-02-07",null,80,109,3.08,"2014-01-03",2]
[4,"2014-02-21",null,80,80,3.08,"2014-01-13",8]
[5,"2014-03-07",null,80,122.5,3.08,"2014-03-03",6.5]
[6,"2014-03-21",null,80,81.5,3.08]
[7,"2014-04-04",null,80,82.75,3.08]
[8,"2014-04-18",null,null,null,0]
[9,"2014-05-02",null,80,null,3.08]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,{"$f":"D37*0.0385","v":0}]
[null," "]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":640},{"$f":"SUM(E12:E38)","v":635.5},null,"Used Hours",{"$f":"SUM(H12:H32)","v":27}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]

{"sheet":"Johnson, S","index":5,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2]]}
[null,"Employee:","Scott Johnson",null,null,null,null,"PTO 2014"]
[null,"Date of Hire:","2012-08-20",null," ",null,"Year Type (Full or Partial):",null,"F"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"SUM(D39)","v":640}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 160)",null,null,{"$f":"SUM(H4*I5)","v":24.64},3.85E-2]
[null,"Prior Year Carry Over",null,null,null,null,null,27.8]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":52.44}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"SUM(H39)","v":24}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":28.439999999999998}]
[null,"Maximin PTO allowed",null,null,null,null,null,160]
[null,"Pay Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,80,82.5,{"$f":"D12*0.0385","v":3.08},"2013-12-24",8]
[2,"2014-01-24",null,80,90.5,3.08,"2014-01-20",8]
[3,"2014-02-07",null,80,90,3.08,"2014-03-24",8]
[4,"2014-02-21",null,80,89.25,3.08]
[5,"2014-03-07",null,80,87.75,3.08]
[6,"2014-03-21",null,80,88,3.08]
[7,"2014-04-04",null,80,88.75,3.08]
[8,"2014-04-18",null,null,null,0]
[9,"2014-05-02",null,80,null,3.08]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,{"$f":"D37*0.0385","v":0}]
[null," "]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":640},{"$f":"SUM(E12:E38)","v":616.75},null,"Used Hours",{"$f":"SUM(H12:H32)","v":24}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]

{"sheet":"Morgan, P","index":6,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2]]}
[null,"Employee:","Paul Morgan",null,null,null,null,"PTO 2014"]
[null,"Date of Hire:","2010-09-24",null," ",null,"Year Type (Full or Partial):",null,"F"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"SUM(D39)","v":640}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 160)",null,null,{"$f":"SUM(H4*I5)","v":36.927999999999997},5.7700000000000001E-2]
[null,"Prior Year Carry Over",null,null,null,null,null,29.8]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":66.727999999999994}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"SUM(H39)","v":38}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":28.727999999999994}]
[null,"Maximin PTO allowed",null,null,null,null,null,240]
[null,"Pay Period Ending Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,80,84.5,{"$f":"D12*0.0577","v":4.6159999999999997},"2013-12-24",6]
[2,"2014-01-24",null,80,84.5,{"$f":"D13*0.0577","v":4.6159999999999997},"2014-01-21",4]
[3,"2014-02-07",null,80,81.75,{"$f":"D14*0.0577","v":4.6159999999999997},"2014-02-14"]
[4,"2014-02-21",null,80,79,{"$f":"D15*0.0577","v":4.6159999999999997},"2014-02-24",4]
[5,"2014-03-07",null,80,104.5,4.6159999999999997,"2014-02-25",4]
[6,"2014-03-21",null,80,185.75,4.6159999999999997,"2014-03-27",8]
[7,"2014-04-04",null,80,82.5,4.6159999999999997,"2014-03-28",8]
[8,"2014-04-18",null,null,null,0,"2014-04-04",4]
[9,"2014-05-02",null,80,null,4.6159999999999997]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,0]
[null," "]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":640},{"$f":"SUM(E12:E38)","v":702.5},null,"Used Hours",{"$f":"SUM(H12:H32)","v":38}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]

{"sheet":"Zed, S","index":7,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2]]}
[null,"Employee:","Sam Zed",null,null,null,null,"PTO 2014"]
[null,"Date of Hire:","2012-08-13",null," ",null,"Year Type (Full or Partial):",null,"F"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"SUM(D39)","v":640}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 160)",null,null,{"$f":"SUM(H4*I5)","v":36.927999999999997},5.7700000000000001E-2]
[null,"Prior Year Carry Over",null,null,null,null,null,-22.77]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":14.157999999999998}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"SUM(H39)","v":13}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":1.1579999999999977}]
[null,"Maximin PTO allowed",null,null,null,null,null,240]
[null,"Pay Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,80,88,{"$f":"D12*0.0577","v":4.6159999999999997},"2014-01-03",7]
[2,"2014-01-24",null,80,81.25,{"$f":"D13*0.0577","v":4.6159999999999997},"2014-03-28",6]
[3,"2014-02-07",null,80,89.75,{"$f":"D14*0.0577","v":4.6159999999999997}]
[4,"2014-02-21",null,80,82.25,{"$f":"D15*0.0577","v":4.6159999999999997}]
[5,"2014-03-07",null,80,87,4.6159999999999997]
[6,"2014-03-21",null,80,82.75,4.6159999999999997]
[7,"2014-04-04",null,80,86,4.6159999999999997]
[8,"2014-04-18",null,null,null,0]
[9,"2014-05-02",null,80,null,4.6159999999999997]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,0]
[null," "]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":640},{"$f":"SUM(E12:E38)","v":597},null,"Used Hours",{"$f":"SUM(H12:H32)","v":13}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]

{"sheet":"McClellan, S","index":8,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[37,1,37,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2]]}
[null,"Employee:","Scott McClellan",null,null,null,null,"PTO 2014"]
[null,"Date of Hire:","2014-03-30",null," ",null,"Year Type (Full or Partial):",null,"P"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"D39","v":80}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 240)",null,null,{"$f":"SUM(H4*I5)","v":3.08},3.85E-2]
[null,"Prior Year Carry Over",null,null,null,null,null,0]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":3.08}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"H39","v":0}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":3.08}]
[null,"Maximin PTO allowed",null,null,null,null,null,160]
[null,"Pay Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,null,null,{"$f":"D12*$I$5","v":0}]
[2,"2014-01-24",null,null,null,{"$f":"D13*$I$5","v":0}]
[3,"2014-02-07",null,null,null,0]
[4,"2014-02-21",null,null,null,0]
[5,"2014-03-07",null,null,null,0]
[6,"2014-03-21",null,null,null,0]
[7,"2014-04-04",null,null,null,0]
[8,"2014-04-18",null,null,null,0]
[9,"2014-05-02",null,80,null,3.08]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,0]
[]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":80},{"$f":"SUM(E12:E38)","v":0},null,"Used Hours",{"$f":"SUM(H12:H38)","v":0}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]

{"sheet":"Macky, J","index":9,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[28,1,28,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[40,1,40,8],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2]]}
[null,"Employee:","Johnny  Macky",null,null,null,null,"PTO 2014"]
[null,"Date of Hire:","2014-02-15",null," ",null,"Year Type (Full or Partial):",null,"P"]
[null,"PTO Hours Summary"]
[null,"2014 Actual Hours Worked to Date:",null,null,null,null,null,{"$f":"D39","v":0}]
[null,"2014 Actual PTO Hours Earned:",null,null,"(Maximum PTO hours: 240)",null,null,{"$f":"SUM(H4*I5)","v":0},5.7700000000000001E-2]
[null,"Prior Year Carry Over",null,null,null,null,null,0]
[null,"Total PTO Hours Available",null,null,null,null,null,{"$f":"SUM(H5:H6)","v":0}]
[null,"PTO Hours Used:",null,null,null,null,null,{"$f":"H39","v":0}]
[null,"Actual PTO Hours Available:",null,null,null,null,null,{"$f":"SUM(H7-H8)","v":0}]
[null,"Maximin PTO allowed",null,null,null,null,null,240]
[null,"Pay Date",null,"Hrs Worked","Actual Hrs","Earned","Date","Hours Used","Notes"]
[1,"2014-01-10",null,null,null,{"$f":"D12*$I$5","v":0}]
[2,"2014-01-24",null,null,null,{"$f":"D13*$I$5","v":0}]
[3,"2014-02-07",null,null,null,0]
[4,"2014-02-21",null,null,null,0]
[5,"2014-03-07",null,null,null,0]
[6,"2014-03-21",null,null,null,0]
[7,"2014-04-04",null,null,null,0]
[8,"2014-04-18",null,null,null,0]
[9,"2014-05-02",null,null,null,0]
[10,"2014-05-16",null,null,null,0]
[11,"2014-05-30",null,null,null,0]
[12,"2014-06-13",null,null,null,0]
[13,"2014-06-27",null,null,null,0]
[14,"2014-07-11",null,null,null,0]
[15,"2014-07-25",null,null,null,0]
[16,"2014-08-08",null,null,null,0]
[17,"2014-08-22",null,null,null,0]
[18,"2014-09-05",null,null,null,0]
[19,"2014-09-19",null,null,null,0]
[20,"2014-10-03",null,null,null,0]
[21,"2014-10-17",null,null,null,0]
[22,"2014-10-31",null,null,null,0]
[23,"2014-11-14",null,null,null,0]
[24,"2014-11-28",null,null,null,0]
[25,"2014-12-12",null,null,null,0]
[26,"2014-12-26",null,null,null,0]
[]
[null,"Total Hours Worked to Date:",null,{"$f":"SUM(D12:D38)","v":0},{"$f":"SUM(E12:E38)","v":0},null,"Used Hours",{"$f":"SUM(H12:H38)","v":0}]
[null,"PTO Rule:  Use them or lose them--Can have 160 on record max."]
[null,"As long as the Actual Hours worked is greater than the Hours worked, PTO accrual will be 80 hours per pay period."]