{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ARQUEO DE CAJA","RESUMEN","BASE DE DATOS","BUSCADOR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":2,"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":"ARQUEO DE CAJA","index":0,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,3,7,4],[47,3,47,4],[1,3,1,5],[3,3,3,4],[4,3,4,4],[5,3,5,4],[33,3,33,5],[50,3,50,4],[12,3,12,5],[29,3,29,4],[19,3,19,4],[40,3,40,4],[44,3,44,5],[48,3,48,4],[21,3,21,5],[45,3,45,4],[46,3,46,4],[49,3,49,4]]}
[]
[null,null,null,"ARQUEO DE CAJA CHICA"]
[]
[null,null,null,"FECHA:"]
[null,null,null,"Hr. INICIO:"]
[null,null,null,"Hr. TÉRMINO:"]
[]
[null,null,null,"SALDO INICIAL:"]
[]
[]
[null,null,"1.-","EFECTIVO"]
[]
[null,null,null,"BILLETES"]
[null,null,null,"Valor","Cantidad","Total"]
[null,null,null,200,null,{"$f":"D15*E15","v":0}]
[null,null,null,100,null,0]
[null,null,null,50,null,0]
[null,null,null,20,null,0]
[null,null,null,10,null,0]
[null,null,null,"Total Billetes",null,{"$f":"+SUM(F15:F19)","v":0}]
[]
[null,null,null,"MONEDAS"]
[null,null,null,"Valor","Cantidad","Total"]
[null,null,null,5,null,{"$f":"D24*E24","v":0}]
[null,null,null,2,null,{"$f":"D25*E25","v":0}]
[null,null,null,1,null,0]
[null,null,null,0.5,null,0]
[null,null,null,0.2,null,0]
[null,null,null,0.1,null,0]
[null,null,null,"Total Monedas",null,{"$f":"+SUM(F24:F29)","v":0}]
[]
[null,null,"2.-","CHEQUES"]
[]
[null,null,null,"CHEQUES"]
[null,null,null,"Banco","Nro de Cheque","Total"]
[]
[]
[]
[]
[]
[null,null,null,"Total Cheques",null,{"$f":"+SUM(F36:F40)","v":0}]
[]
[null,null,"3.-","OTROS:"]
[]
[null,null,null,"COMPRAS"]
[null,null,null,"Total Facturas"]
[null,null,null,"Total Recibos"]
[null,null,null,"Total Vales"]
[null,null,null,"Total Recibos"]
[null,null,null,"Otros"]
[null,null,null,"Total Compras",null,{"$f":"-SUM(F46:F50)","v":0}]

{"sheet":"RESUMEN","index":1,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[34,1,35,5],[4,1,4,5],[37,1,37,2],[38,1,38,2],[33,1,33,5]]}
[]
[null,"EMPRESA:","ABC"]
[null,"NIT:",1234567890]
[]
[null,"RESUMEN ARQUEO DE CAJA"]
[null,null,null,null,"FECHA",{"$f":"IF('ARQUEO DE CAJA'!F4,'ARQUEO DE CAJA'!F4,\"\")","v":""}]
[null,null,null,null,"Hr. INICIO",{"$f":"IF('ARQUEO DE CAJA'!F5,'ARQUEO DE CAJA'!F5,\"\")","v":""}]
[null,null,null,null,"Hr. TÉRMINO",{"$f":"IF('ARQUEO DE CAJA'!F6,'ARQUEO DE CAJA'!F6,\"\")","v":""}]
[]
[null,null,"Saldo Inicial",null,{"$f":"IF('ARQUEO DE CAJA'!F8,'ARQUEO DE CAJA'!F8,\"\")","v":""}]
[]
[]
[]
[]
[null,null,"mas",null,{"$f":"IF('ARQUEO DE CAJA'!F10,'ARQUEO DE CAJA'!F10,\"\")","v":""}]
[null,null,"EFECTIVO DISPONIBLE",null,{"$f":"IF('ARQUEO DE CAJA'!F11,'ARQUEO DE CAJA'!F11,\"\")","v":""}]
[null,null,"Total Billetes",null,{"$f":"IF('ARQUEO DE CAJA'!F20,'ARQUEO DE CAJA'!F20,\"\")","v":""}]
[null,null,"Total Monedas",null,{"$f":"IF('ARQUEO DE CAJA'!F30,'ARQUEO DE CAJA'!F30,\"\")","v":""}]
[null,null,"Total Cheques",null,{"$f":"IF('ARQUEO DE CAJA'!F41,'ARQUEO DE CAJA'!F41,\"\")","v":""}]
[null,null,"TOTAL EFECTIVO DISPONIBLE",null,{"$f":"SUM(E10:E19)","v":0}]
[]
[null,null,"menos"]
[null,null,"COMPRAS"]
[null,null,"TOTAL COMPRAS",null,{"$f":"IF('ARQUEO DE CAJA'!F51,'ARQUEO DE CAJA'!F51,\"\")","v":""}]
[]
[null,null,"TOTAL",null,{"$f":"IF(E20>0,E20+E24,\"\")","v":""}]
[]
[null,null,"DETERMINACION DE LA DIFERENCIA"]
[null,null,"Saldo según arqueo",null,{"$f":"+E26","v":""}]
[null,null,"Saldo según libros"]
[null,null,"DIFERENCIA",null,{"$f":"+E29-E30","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF(E31=0,\"SIN DIFERENCIA\",IF(E31>0,\"SOBRANTE EN CAJA\",IF(E31<0,\"FALTANTE EN CAJA\",\"\")))","v":{"$error":"#VALUE!"}}]
[]
[null,"OBSERVACIONES:"]
[]
[]
[]
[null,"RESPONSABLE DE CAJA:"]
[null,"SUPERVISOR DE CAJA:"]
[]
[]
[]
[]
[]
[null,"Encargado",null,null,null,"Supervisor"]

{"sheet":"BASE DE DATOS","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,0,5,6]]}
[]
[]
[]
[]
[]
["BASE DE DATOS"]
[]
[]
["FECHA","TOTAL EFECTIVO DISPONIBLE","TOTAL COMPRAS","DIFERENCIA","OBS.","RESPONSABLE DE CAJA:","SUPERVISOR DE CAJA:"]

{"sheet":"BUSCADOR","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"BUSCAR:"]
[null,"FECHA","TOTAL EFECTIVO DISPONIBLE","TOTAL COMPRAS","DIFERENCIA","OBS.","RESPONSABLE DE CAJA:","SUPERVISOR DE CAJA:"]
[]
[]
[]
[null,"RESULTADOS:"]
[null,"FECHA","TOTAL EFECTIVO DISPONIBLE","TOTAL COMPRAS","DIFERENCIA","OBS.","RESPONSABLE DE CAJA:","SUPERVISOR DE CAJA:"]