{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overtime Calculator","Sheet1"],"not_rendered":{"charts":0,"images":1,"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":"Overtime Calculator","index":0,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Overtime Calculator"]
["Start Date goes here",null,null,"Week 1",null,null,null,null,null,null,null,null,"Week 2"]
["Standard Hourly $Rate goes here",40,null,"Day","Date","am Hours","pm Hours","Total Hours","Reason","Total $ Lost","Total $ Lost",null,"Day","Date","am Hours","pm Hours","Total Hours","Reason","Total $ Lost","Total $ Lost"]
[null,null,null,{"$f":"IF($B$2<>\"\",TEXT(E4,\"ddd\"),\"\")","v":""},{"$f":"IF(B2=\"\",\"\",B2)","v":""},null,1,{"$f":"IF(AND(F4=\"\",G4=\"\"),\"\",SUM(F4:G4))","v":1},null,{"$f":"IF(D4=\"Sat\",IF(F4<=2,F4*$B$3*1.5+G4*2*$B$3,(F4-2)*$B$3*2+2*$B$3*1.5+G4*2*$B$3),IF(D4=\"Sun\",$B$3*2*(F4+G4),IF(F4+G4<=2,(F4+G4)*$B$3*1.5,(F4+G4-2)*$B$3*2+3*$B$3)))","v":60},{"$f":"IF(J4=0,\"\",J4)","v":60},null,{"$f":"IF($B$2<>\"\",TEXT(N4,\"ddd\"),\"\")","v":""},{"$f":"IF($B$2=\"\",\"\",E10+1)","v":""},null,null,{"$f":"IF(AND(O4=\"\",P4=\"\"),\"\",SUM(O4:P4))","v":""},null,{"$f":"IF(M4=\"Sat\",IF(O4<=2,O4*$B$3*1.5+P4*2*$B$3,(O4-2)*$B$3*2+2*$B$3*1.5+P4*2*$B$3),IF(M4=\"Sun\",$B$3*2*(O4+P4),IF(O4+P4<=2,(O4+P4)*$B$3*1.5,(O4+P4-2)*$B$3*2+3*$B$3)))","v":0},{"$f":"IF(S4=0,\"\",S4)","v":""}]
["Enter all unpaid overtime hours ",null,null,{"$f":"IF($B$2<>\"\",TEXT(E5,\"ddd\"),\"\")","v":""},{"$f":"IF($B$2=\"\",\"\",E4+1)","v":""},null,1,{"$f":"IF(AND(F5=\"\",G5=\"\"),\"\",SUM(F5:G5))","v":1},null,60,{"$f":"IF(J5=0,\"\",J5)","v":60},null,{"$f":"IF($B$2<>\"\",TEXT(N5,\"ddd\"),\"\")","v":""},{"$f":"IF($B$2=\"\",\"\",N4+1)","v":""},null,null,{"$f":"IF(AND(O5=\"\",P5=\"\"),\"\",SUM(O5:P5))","v":""},null,{"$f":"IF(M5=\"Sat\",IF(O5<=2,O5*$B$3*1.5+P5*2*$B$3,(O5-2)*$B$3*2+2*$B$3*1.5+P5*2*$B$3),IF(M5=\"Sun\",$B$3*2*(O5+P5),IF(O5+P5<=2,(O5+P5)*$B$3*1.5,(O5+P5-2)*$B$3*2+3*$B$3)))","v":0},{"$f":"IF(S5=0,\"\",S5)","v":""}]
["am and/or pm into the yellow cells",null,null,"",{"$f":"IF($B$2=\"\",\"\",E5+1)","v":""},null,1,1,null,60,60,null,"",{"$f":"IF($B$2=\"\",\"\",N5+1)","v":""},null,null,"",null,0,""]
[null,null,null,"","",null,1,1,null,60,60,null,"","",null,null,"",null,0,""]
["Click on Sample Data button below",null,null,"","",null,null,"",null,0,"",null,"","",null,null,"",null,0,""]
["to see an example",null,null,"","",null,null,"",null,0,"",null,"","",null,null,"",null,0,""]
[null,null,null,"","",null,null,"",null,0,"",null,"","",null,null,"",null,0,""]
["Click on Clear button to start again",null,null,null,null,null,null,null,"Total lost this week",{"$f":"SUM(J4:J10)","v":240},{"$f":"SUM(K4:K10)","v":240},null,null,null,null,null,null,"Total lost this week",{"$f":"SUM(S4:S10)","v":0},{"$f":"SUM(T4:T10)","v":0}]
[]
["Note: You can only edit the yellow cells"]
[null,null,null,"Week 3",null,null,null,null,null,null,null,null,"Week 4"]
[null,null,null,"Day","Date","am Hours","pm Hours","Total Hours","Reason","Total $ Lost","Total $ Lost",null,"Day","Date","am Hours","pm Hours","Total Hours","Reason","Total $ Lost","Total $ Lost"]
[null,null,null,{"$f":"IF($B$2<>\"\",TEXT(E16,\"ddd\"),\"\")","v":""},{"$f":"IF($B$2=\"\",\"\",N10+1)","v":""},null,null,{"$f":"IF(AND(F16=\"\",G16=\"\"),\"\",SUM(F16:G16))","v":""},null,{"$f":"IF(D16=\"Sat\",IF(F16<=2,F16*$B$3*1.5+G16*2*$B$3,(F16-2)*$B$3*2+2*$B$3*1.5+G16*2*$B$3),IF(D16=\"Sun\",$B$3*2*(F16+G16),IF(F16+G16<=2,(F16+G16)*$B$3*1.5,(F16+G16-2)*$B$3*2+3*$B$3)))","v":0},{"$f":"IF(J16=0,\"\",J16)","v":""},null,{"$f":"IF($B$2<>\"\",TEXT(N16,\"ddd\"),\"\")","v":""},{"$f":"IF($B$2=\"\",\"\",E22+1)","v":""},null,null,{"$f":"IF(AND(O16=\"\",P16=\"\"),\"\",SUM(O16:P16))","v":""},null,{"$f":"IF(M16=\"Sat\",IF(O16<=2,O16*$B$3*1.5+P16*2*$B$3,(O16-2)*$B$3*2+2*$B$3*1.5+P16*2*$B$3),IF(M16=\"Sun\",$B$3*2*(O16+P16),IF(O16+P16<=2,(O16+P16)*$B$3*1.5,(O16+P16-2)*$B$3*2+3*$B$3)))","v":0},{"$f":"IF(S16=0,\"\",S16)","v":""}]
[null,null,null,"",{"$f":"IF($B$2=\"\",\"\",E16+1)","v":""},null,null,"",null,{"$f":"IF(D17=\"Sat\",IF(F17<=2,F17*$B$3*1.5+G17*2*$B$3,(F17-2)*$B$3*2+2*$B$3*1.5+G17*2*$B$3),IF(D17=\"Sun\",$B$3*2*(F17+G17),IF(F17+G17<=2,(F17+G17)*$B$3*1.5,(F17+G17-2)*$B$3*2+3*$B$3)))","v":0},{"$f":"IF(J17=0,\"\",J17)","v":""},null,{"$f":"IF($B$2<>\"\",TEXT(N17,\"ddd\"),\"\")","v":""},{"$f":"IF($B$2=\"\",\"\",N16+1)","v":""},null,null,{"$f":"IF(AND(O17=\"\",P17=\"\"),\"\",SUM(O17:P17))","v":""},null,0,{"$f":"IF(S17=0,\"\",S17)","v":""}]
[null,null,null,"",{"$f":"IF($B$2=\"\",\"\",E17+1)","v":""},null,null,"",null,0,"",null,"",{"$f":"IF($B$2=\"\",\"\",N17+1)","v":""},null,null,"",null,0,""]
[null,null,null,"","",null,null,"",null,0,"",null,"","",null,null,"",null,0,""]
[null,null,null,"","",null,null,"",null,0,"",null,"","",null,null,"",null,0,""]
[null,null,null,"","",null,null,"",null,0,"",null,"","",null,null,"",null,0,""]
[null,null,null,"","",null,null,"",null,0,"",null,"","",null,null,"",null,0,""]
[null,null,null,null,null,null,null,null,"Total lost this week",{"$f":"SUM(J16:J22)","v":0},{"$f":"SUM(K16:K22)","v":0},null,null,null,null,null,null,"Total lost this week",{"$f":"SUM(S16:S22)","v":0},{"$f":"SUM(T16:T22)","v":0}]
[]
[]
[null,null,null,"              So far you have missed out on",null,null,null,null,{"$f":"J11+S11+J23+S23","v":240}]
[]
[null,null,null,{"$f":"IF(I26>0,\"Which is enough to pay for\",\"\")","v":"Which is enough to pay for"},null,null,null,{"$f":"IF(AND(I26>5,I26<50),\"Netflix*\",IF(AND(I26>=50,I26<100),\"a night at the movies*\",IF(AND(I26>=100,I26<200),\"a dinner for two at a restaurant*\",IF(AND(I26>=200,I26<300),\"a dinner for two at a nice restaurant*\",IF(AND(I26>=300,I26<500),\"a dinner for two at a really nice restaurant*\",IF(AND(I26>=500,I26<1000),\"a one-way flight to Hawaii*\",IF(AND(I26>=1000,I26<5000),\"at least one labradoodle*\",IF(AND(I26>=5000,I26<10000),\"a used 2012 Toyota Yaris*\",IF(I26>=10000,\"…hey, could I borrow a few bucks?*\",\"\")))))))))","v":"a dinner for two at a nice restaurant*"}]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}