{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Controle de horas"],"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":"Controle de horas","index":0,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,12,5,17],[6,12,6,13]]}
[]
[]
[]
[]
[]
[null,"Dia","Entrada","Intervalo","Volta","Saída","Entrada","Intervalo","Volta","Saída","Saldo",null,"Regras de horários"]
[null,"2014-09-01","Folga","Folga","Folga","Folga",{"$f":"IFERROR(VLOOKUP(WEEKDAY($B7,1),$M$8:$R$14,MATCH(G$6,$M$7:$R$7,0),FALSE)-C7,\"Folga\")","v":"Folga"},{"$f":"IFERROR(D7-VLOOKUP(WEEKDAY($B7,1),$M$8:$R$14,MATCH(H$6,$M$7:$R$7,0),FALSE),\"Folga\")","v":"Folga"},{"$f":"IFERROR(VLOOKUP(WEEKDAY($B7,1),$M$8:$R$14,MATCH(I$6,$M$7:$R$7,0),FALSE)-E7,\"Folga\")","v":"Folga"},"Folga",{"$f":"SUM(G7:J7)","v":"00:00:00"},null,"Dia",null,"Entrada","Intervalo","Volta","Saída"]
[null,"2014-09-02","09:05:00","12:00:00","13:00:00","18:06:00",{"$f":"IFERROR(VLOOKUP(WEEKDAY($B8,1),$M$8:$R$14,MATCH(G$6,$M$7:$R$7,0),FALSE)-C8,\"Folga\")","v":-3.4722222222222654E-3},{"$f":"IFERROR(D8-VLOOKUP(WEEKDAY($B8,1),$M$8:$R$14,MATCH(H$6,$M$7:$R$7,0),FALSE),\"Folga\")","v":"00:00:00"},"00:00:00",{"$f":"IFERROR(F8-VLOOKUP(WEEKDAY($B8,1),$M$8:$R$14,MATCH(J$6,$M$7:$R$7,0),FALSE),\"Folga\")","v":"00:06:00"},{"$f":"SUM(G8:J8)","v":"00:01:00"},null,1,"Domingo","Folga","Folga","Folga","Folga"]
[null,"2014-09-03","08:57:00","12:13:00","13:04:00","18:02:00","00:03:00",{"$f":"IFERROR(D9-VLOOKUP(WEEKDAY($B9,1),$M$8:$R$14,MATCH(H$6,$M$7:$R$7,0),FALSE),\"Folga\")","v":"00:13:00"},-2.7777777777777679E-3,"00:02:00",{"$f":"SUM(G9:J9)","v":"00:14:00"},null,2,"Segunda","09:00:00","12:00:00","13:00:00","18:00:00"]
[null,"2014-09-04","08:56:00","11:56:00","12:55:00","18:01:00","00:04:00",-2.7777777777777679E-3,"00:05:00","00:01:00","00:06:00",null,3,"Terça","09:00:00","12:00:00","13:00:00","18:00:00"]
[null,"2014-09-05","08:54:00","12:10:00","13:16:00","18:23:00","00:06:00","00:10:00",-1.1111111111111183E-2,"00:23:00","00:23:00",null,4,"Quarta","09:00:00","12:00:00","13:00:00","18:00:00"]
[null,"2014-09-06","09:00:00","12:00:00","13:00:00","18:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,5,"Quinta","09:00:00","12:00:00","13:00:00","18:00:00"]
[null,"2014-09-07","Folga","Folga","Folga","Folga","Folga","Folga","Folga","Folga","00:00:00",null,6,"Sexta","09:00:00","12:00:00","13:00:00","18:00:00"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K13)","v":"00:44:00"},null,7,"Sábado","Folga","Folga","Folga","Folga"]