{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Principal","Registro Egresos","Codigos"],"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":"Principal","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Registro Egresos","index":1,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Nombres y Apellidos","Documento de Identidad","Género","Tipo de gasto","Código","Día","Mes","Año","Razón Social","RUC","Sustento del egreso","Otros impuestos (%)","Valor de Venta","IGV","Otros Impuestos","Monto total"]
["José David Núñez Sánchez",46324035,"Masculino","Alojamiento",{"$f":"+IF(D2<>\"\",VLOOKUP(D2,Codigos!$A$1:$B$38,2,0),\"\")","v":6313},1,3,2012,"Asociación Civil Liderazgo e Intercambio",56458798520,"Factura",null,{"$f":"IF(K2=\"Factura\",P2/(1+(SUM(18+L2)/100)),P2/(1+L2)/100)","v":677.96610169491532},{"$f":"IF(K2=\"Factura\",M2*0.18,0)","v":122.03389830508475},{"$f":"+M2*L2/100","v":0},800]
[null,null,null,null,{"$f":"+IF(D3<>\"\",VLOOKUP(D3,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(K3=\"Factura\",P3/(1+(SUM(18+L3)/100)),P3/(1+L3)/100)","v":0},{"$f":"IF(K3=\"Factura\",M3*0.18,0)","v":0},{"$f":"+M3*L3/100","v":0}]
[null,null,null,null,{"$f":"+IF(D4<>\"\",VLOOKUP(D4,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D5<>\"\",VLOOKUP(D5,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D6<>\"\",VLOOKUP(D6,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D7<>\"\",VLOOKUP(D7,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D8<>\"\",VLOOKUP(D8,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D9<>\"\",VLOOKUP(D9,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D10<>\"\",VLOOKUP(D10,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D11<>\"\",VLOOKUP(D11,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D12<>\"\",VLOOKUP(D12,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D13<>\"\",VLOOKUP(D13,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D14<>\"\",VLOOKUP(D14,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D15<>\"\",VLOOKUP(D15,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D16<>\"\",VLOOKUP(D16,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D17<>\"\",VLOOKUP(D17,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D18<>\"\",VLOOKUP(D18,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D19<>\"\",VLOOKUP(D19,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D20<>\"\",VLOOKUP(D20,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D21<>\"\",VLOOKUP(D21,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D22<>\"\",VLOOKUP(D22,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"+IF(D23<>\"\",VLOOKUP(D23,Codigos!$A$1:$B$38,2,0),\"\")","v":""},null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]

{"sheet":"Codigos","index":2,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Tipo de Gasto","Partida",null,"Sustento",null,"Día","Mes","Año"]
["Alimentación",6314,null,"Factura",null,"1","1","2012"]
["Alojamiento",6313,null,"Boleta",null,"2","2","2011"]
["Alquileres Edificaciones Auditorio",635213,null,"Plantilla transporte",null,"3","3","2010"]
["Alquileres Edificaciones Oficina",635211,null,"Dec. Jurada",null,"4","4","2009"]
["Alquileres Edificaciones Otros",635214,null,"Arrendamiento",null,"5","5","2008"]
["Alquileres Edificaciones Trainee house",635212,null,"Honorarios",null,"6","6","2007"]
["Alquileres Equipos diversos",6356,null,null,null,"7","7","2006"]
["Cable",6367,null,null,null,"8","8","2005"]
["Copias, impresiones",659314,null,null,null,"9","9","2004"]
["Correos Envíos internacionales",631213,null,null,null,"10","10","2003"]
["Correos Envíos locales",631211,null,null,null,"11","11","2002"]
["Correos Envíos nacionales",631212,null,null,null,"12","12","2001"]
["Energía eléctrica",6361,null,null,null,"13",null,"2000"]
["Fee congresos",657111,null,null,null,"14"]
["Ferretería",659315,null,null,null,"15"]
["Gas",6362,null,null,null,"16"]
["Gasolina",659311,null,null,null,"17"]
["Gastos de visado",657112,null,null,null,"18"]
["Honorarios, comisiones y corretajes - Otros honorarios",632114,null,null,null,"19"]
["Honorarios, comisiones y corretajes - Servicios contable",632112,null,null,null,"20"]
["Honorarios, comisiones y corretajes - Servicios de vigilancia",632113,null,null,null,"21"]
["Honorarios, comisiones y corretajes - Servicios legales",632111,null,null,null,"22"]
["Internet",6365,null,null,null,"23"]
["Mantenimiento y reparaciones",634,null,null,null,"24"]
["Medicinas",659316,null,null,null,"25"]
["Otros",659317,null,null,null,"26"]
["Otros gastos de viaje - Otros gastos en el viaje",631513,null,null,null,"27"]
["Otros gastos de viaje - Seguro médico",631512,null,null,null,"28"]
["Otros gastos de viaje - Tramites de visado",631511,null,null,null,"29"]
["Publicidad, publicaciones, relaciones públicas",637,null,null,null,"30"]
["Teléfono",6364,null,null,null,"31"]
["Transporte De carga",63111]
["Transporte De pasajeros Internacional",631123]
["Transporte De pasajeros Interprovincial",631122]
["Transporte De pasajeros Local",631121]
["Útiles de escritorio",659313]
["Útiles de limpieza",659312]