{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Time Computation","Printout","Proration","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Time Computation","index":0,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,8],[17,4,17,8],[2,5,2,8],[2,0,2,1],[0,0,1,8],[4,12,5,12],[6,12,7,12],[3,10,3,12],[14,4,14,8],[15,4,15,8]]}
["Time Calculator Sheet"]
[]
["(Enter time as hh:mm)",null,null,null,null,"(Enter time as hh:mm)"]
["Total monthly hours",null,null,null,"Claimed",null,null,null,null,null,"Possible Overtime",null,null,null,1.6666666666666667]
["Weekly hours",{"$f":"IF(B4=0,\"\",B4/4)","v":""},null,null,"Day 1",null,null,null,null,null,"Week 1",{"$f":"IF(F12>O4,F12-O4,\"\")","v":""},{"$f":"SUM(L5:L6)","v":0}]
[null,null,null,null,"Day 2",null,null,null,null,null,"Week 2",{"$f":"IF(G12>O4,G12-O4,\"\")","v":""}]
["30-Day Computation",{"$f":"B4/30","v":0},null,null,"Day 3",null,null,null,null,null,"Week 3",{"$f":"IF(H12>O4,H12-O4,\"\")","v":""},{"$f":"SUM(L7:L8)","v":0}]
["Entry for 29 days",{"$f":"INT(B7*1440)/1440","v":0},null,null,"Day 4",null,null,null,null,null,"Week 4",{"$f":"IF(I12>O4,I12-O4,\"\")","v":""}]
["Entry for 1 day",{"$f":"B4-(B8*29)","v":0},null,null,"Day 5"]
[null,null,null,null,"Day 6"]
["31-Day Computation",{"$f":"B4/31","v":0},null,null,"Day 7",null,null,null,null,null,"Grand total"]
["Entry for 30 days",{"$f":"INT(B11*1440)/1440","v":0},null,null,"Total",{"$f":"SUM(F4:F11)","v":0},0,0,0,null,{"$f":"SUM(F12:I12)","v":0}]
["Entry for 1 day",{"$f":"B4-(B12*30)","v":0}]
[]
[null,null,null,null,{"$f":"IF(F12=0,\"\",IF(F12>B5,\"Week 1 total exceeds allowable claimed hours\",\"\"))","v":""}]
[null,null,null,null,{"$f":"IF(G12=0,\"\",IF(G12>B5,\"Week 2 total exceeds allowable claimed hours\",\"\"))","v":""}]
[null,null,null,null,{"$f":"IF(H12=0,\"\",IF(H12>B5,\"Week 3 total exceeds allowable claimed hours\",\"\"))","v":""}]
[null,null,null,null,{"$f":"IF(I12=0,\"\",IF(I12>B5,\"Week 4 total exceeds allowable claimed hours\",\"\"))","v":""}]

{"sheet":"Printout","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,0,5,1],[9,0,9,1],[0,0,0,1],[17,0,17,5],[14,0,14,4],[30,0,30,5],[29,0,29,5],[28,0,28,5],[27,0,27,5],[26,0,26,5],[25,0,25,5],[24,0,24,5],[23,0,23,5],[22,0,22,5],[21,0,21,5],[20,0,20,5],[19,0,19,5],[18,0,18,5]]}
["Time Calculation"]
[]
["Total monthly hours",{"$f":"'Time Computation'!B4","v":0}]
["Weekly hours",{"$f":"'Time Computation'!B5","v":""}]
[]
["30-Day Computation"]
["Entry for 29 days",{"$f":"'Time Computation'!B8","v":0}]
["Entry for 1 day",{"$f":"'Time Computation'!B9","v":0}]
[]
["31-Day Computation"]
["Entry for 30 days",{"$f":"'Time Computation'!B12","v":0}]
["Entry for 1 day",{"$f":"'Time Computation'!B13","v":0}]
[]
["Note:"]
["- This computation is based on working 7 days/week"]
["- A workweek starts on a Sunday and ends Saturday"]
[]
["Instructions:"]

{"sheet":"Proration","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Total Hours",null,"Enter time as hh:mm"]
["Date out",null,"Date client was out (mm/dd/yy)"]
["Date in",null,"Date client returned (mm/dd/yy)"]
["Days/month",{"$f":"IF(AND(B2<>0,B3<>0), DAY(DATE(YEAR(B2),MONTH(B2)+1,1)-1), \"\")","v":""}]
["No. of days out",{"$f":"B3-B2","v":0}]
["Prorated hours",{"$f":"IF(B5=0,\" \",Total_hours-(Total_hours/Days_per_month)*Days_out)","v":" "}]

{"sheet":"Sheet2","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Jan",31]
["Feb",28]
["Mar",31]
["Apr",30]
["May",31]
["Jun",30]
["Jul",31]
["Aug",31]
["Sep",30]
["Oct",31]
["Nov",30]
["Dec",31]