{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["EMPRESA","DATA","FILTRO","DAOT","CONSULTA","T1","T2","ENTIDADES"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":22,"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":"EMPRESA","index":0,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["DATOS GENERALES"]
["Periodo",2017,null,null,null,null,null,null,null,null,null,null,null,null,"Ingresos.txt",null,"DAOT"]
["Tipo Doc.",6,null,null,null,null,null,null,null,null,null,null,null,null,"Costos.txt",null,"S"]
["Núm. Doc.",20565893174]
["Nombre ó Razón Social","Archivo Excel E.I.R.L."]
["UIT",4050]
[]
["Tope (2 UIT)",{"$f":"B6*2","v":8100}]
["Archivo","Ingresos.txt"]
[]
[]
["Compuestos","DE"]
[null,"DE LA"]
[null,"DEL"]
[null,"LA "]
[null,"LAS "]
[null,"LOS"]
[null,"MAC"]
[null,"MC"]
[null,"VAN"]
[null,"VON"]
[null,"Y"]
[null,"Y DEL "]
[null,"DE LOS"]

{"sheet":"DATA","index":1,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Data de Comprobantes",null,null,null,null,null,null,{"$f":"SUM(H4:H1000000)","v":2878667.57},{"$f":"SUM(I4:I1000000)","v":0},0,0,0,523030.10000000003,0,0,3401697.6700000004]
[null,null,null,null,null,null,null,"Campos con información para el consolidado para el DAOT",null,null,null,{"$f":"SUM(H4:H1000000)+SUM(I4:I1000000)+SUM(J4:J1000000)+SUM(K4:K1000000)+SUM(L4:L1000000)","v":2878667.57},"Campos referenciales de control"]
["Número de Voucher o Registro","Fecha","Tipo Comp.","Serie","Número","Número de Documento","Apellidos y Nombres o Razón Social","B.I.O.G y E. (A)","Importe 2","B.I.O.G.sin DER.CRED.FISCAL ©","ADQUISICIONES NO GRAV.","Importe 5","IGV1","IGV2","IGV3","Total"]
[2,"2011-01-25","01","001       ","000088              ","20514358347","Mundo Minerales SAC                     ",58277.3,null,null,null,null,11072.7,null,null,69350]
[3,"2011-01-31","01","001       ","000089              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[4,"2011-01-31","01","001       ","000090              ","20514358347","Mundo Minerales SAC                     ",216164.9,null,null,null,null,41071.33,null,null,257236.23]
[1,"2011-02-14","01","001       ","000091              ","20514358347","Mundo Minerales SAC                     ",12742.19,null,null,null,null,2421.02,null,null,15163.21]
[2,"2011-02-25","01","001       ","000092              ","20514358347","Mundo Minerales SAC                     ",58445.37,null,null,null,null,11104.63,null,null,69550]
[3,"2011-02-28","01","001       ","000093              ","20514358347","Mundo Minerales SAC                     ",143744.35999999999,null,null,null,null,27311.43,null,null,171055.79]
[1,"2011-03-22","01","001       ","000094              ","20512526595","Invicta Mining Corp S.A.C.              ",16110.97,null,null,null,null,2899.97,null,null,19010.939999999999]
[2,"2011-03-22","01","001       ","000095              ","20512526595","Invicta Mining Corp S.A.C.              ",11827.34,null,null,null,null,2128.91,null,null,13956.25]
[3,"2011-03-25","01","001       ","000096              ","20514358347","Mundo Minerales SAC                     ",58855.93,null,null,null,null,10594.07,null,null,69450]
[4,"2011-03-31","01","001       ","000097              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[5,"2011-03-31","01","001       ","000098              ","20514358347","Mundo Minerales SAC                     ",130192.36,null,null,null,null,23434.61,null,null,153626.97]
[1,"2011-04-14","01","001       ","000099              ","20512526595","Invicta Mining Corp S.A.C.              ",16307.94,null,null,null,null,2935.43,null,null,19243.37]
[3,"2011-04-25","01","001       ","000100              ","20514358347","Mundo Minerales SAC                     ",59788.13,null,null,null,null,10761.87,null,null,70550]
[4,"2011-04-30","01","001       ","000101              ","20514358347","Mundo Minerales SAC                     ",113167.52,null,null,null,null,20370.14,null,null,133537.66]
[1,"2011-05-25","01","001       ","000102              ","20514358347","Mundo Minerales SAC                     ",58326.27,null,null,null,null,10498.73,null,null,68825]
[2,"2011-05-31","01","001       ","000103              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[3,"2011-05-31","01","001       ","000104              ","20514358347","Mundo Minerales SAC                     ",119461.49,null,null,null,null,21503.08,null,null,140964.57]
[1,"2011-06-25","01","001       ","000105              ","20514358347","Mundo Minerales SAC                     ",58495.76,null,null,null,null,10529.24,null,null,69025]
[2,"2011-06-30","01","001       ","000106              ","20514358347","Mundo Minerales SAC                     ",145048.28,null,null,null,null,26108.69,null,null,171156.97]
[1,"2011-07-25","01","001       ","000107              ","20514358347","Mundo Minerales SAC                     ",58008.47,null,null,null,null,10441.530000000001,null,null,68450]
[2,"2011-07-30","01","001       ","000108              ","20514358347","Mundo Minerales SAC                     ",128714.02,null,null,null,null,23168.51,null,null,151882.53]
[1,"2011-08-25","01","001       ","000109              ","20514358347","Mundo Minerales SAC                     ",57902.54,null,null,null,null,10422.459999999999,null,null,68325]
[2,"2011-08-31","01","001       ","000110              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[3,"2011-08-31","01","001       ","000111              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[4,"2011-08-31","01","001       ","000112              ","20514358347","Mundo Minerales SAC                     ",146321.82,null,null,null,null,26337.93,null,null,172659.75]
[5,"2011-08-31","01","001       ","000113              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[6,"2011-08-31","01","001       ","000114              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[7,"2011-08-31","01","001       ","000115              ","20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",32202.25,null,null,null,null,5796.4,null,null,37998.65]
[1,"2011-09-25","01","001       ","000116              ","20514358347","Mundo Minerales SAC                     ",58707.63,null,null,null,null,10567.37,null,null,69275]
[2,"2011-09-30","01","001       ","000117              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[3,"2011-09-30","01","001       ","000118              ","20514358347","Mundo Minerales SAC                     ",136960.72,null,null,null,null,24652.93,null,null,161613.65]
[4,"2011-09-30","01","001       ","000119              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[5,"2011-09-30","01","001       ","000120              ","20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",121241.1,null,null,null,null,21823.4,null,null,143064.5]
[1,"2011-10-31","01","001       ","000121              ","20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",4737.66,null,null,null,null,852.78,null,null,5590.44]
[2,"2011-10-31","01","001       ","000122              ","20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",16678.900000000001,null,null,null,null,3002.2,null,null,19681.099999999999]
[3,"2011-10-31","01","001       ","000123              ","20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",228252.36,null,null,null,null,41085.42,null,null,269337.78000000003]
[1,"2011-11-30","01","001       ","000124              ","00000000000","ANULADO                                 ",0,null,null,null,null,0,null,null,0]
[2,"2011-11-30","01","001       ","000125              ","20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",315942.26,null,null,null,null,56869.61,null,null,372811.87]
[1,"2011-12-31","01","001       ","000126              ","20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",304730.53999999998,null,null,null,null,54851.5,null,null,359582.04]
[1,"2011-01-24","07","001       ","000001              ","20514358347","Mundo Minerales SAC                     ",-2380.87,null,null,null,null,-452.36,null,null,-2833.23]
[2,"2011-04-14","07","001       ","000002              ","20512526595","Invicta Mining Corp S.A.C.              ",-16307.94,null,null,null,null,-2935.43,null,null,-19243.37]
[29,"2011-10-24","01","001",152,"09834233","Gonzales Romero, Sergio",10000,null,null,null,null,1800,null,null,11800]

{"sheet":"FILTRO","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Resumen Anual por Entidad"]
[null,"TOTAL GENERAL",{"$f":"SUM(C4:C1000000)","v":2878667}]
["Número de Documento","Apellidos y Nombres o Razón Social","Importe Total","DAOT"]
["00000000000","ANULADO                                 ",0,""]
["09834233","Gonzales Romero, Sergio",10000,"S"]
["20512526595","Invicta Mining Corp S.A.C.              ",27938,"S"]
["20514358347","Mundo Minerales SAC                     ",1816944,"S"]
["20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",1023785,"S"]

{"sheet":"DAOT","index":3,"n_rows":7,"n_cols":36,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(\"DAOT  -  \",año)","v":"DAOT  -  2017"},null,null,null,null,null,null,{"$f":"SUM(H4:H1000000)","v":2878667},null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(LEN(X1)=8,1,IF(AND(LEN(X1)=11,LEFT(X1,2)=\"20\"),6,IF(AND(LEN(X1)=11,LEFT(X1,2)=\"10\"),6,IF(X1=\"\",\"-\",0))))","v":6},{"$f":"ruccia","v":20565893174},{"$f":"año","v":2017},{"$f":"IF(LEN(AB1)=8,1,IF(AND(LEN(AB1)=11,LEFT(AB1,2)=\"20\"),2,IF(AND(LEN(AB1)=11,LEFT(AB1,2)=\"10\"),1,IF(AB1=\"-\",3,0))))","v":2},{"$f":"IF(LEN(AB1)=8,1,IF(AND(LEN(AB1)=11,LEFT(AB1,2)=\"20\"),6,IF(AND(LEN(AB1)=11,LEFT(AB1,2)=\"10\"),6,IF(AB1=\"\",\"-\",0))))","v":6},"20514358347",null,{"$f":"IF(ISERROR(VLOOKUP(AB1,#REF!,1,0))=FALSE,VLOOKUP(AB1,#REF!,2,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB1,#REF!,1,0))=FALSE,VLOOKUP(AB1,#REF!,3,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB1,#REF!,1,0))=FALSE,VLOOKUP(AB1,#REF!,4,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB1,#REF!,1,0))=FALSE,VLOOKUP(AB1,#REF!,5,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB1,#REF!,1,0))=FALSE,VLOOKUP(AB1,#REF!,6,0),\"\")","v":""},null,{"$f":"CONCATENATE(V1,\"|\",W1,\"|\",X1,\"|\",Y1,\"|\",TEXT(Z1,\"0#\"),\"|\",AA1,\"|\",AB1,\"|\",AC1,\"|\",AD1,\"|\",AE1,\"|\",AF1,\"|\",AG1,\"|\",AH1)","v":"1|6|20565893174|2017|02|6|20514358347||||||"}]
[]
["Número Correlativo","Tipo Documento(tabla 1)","Número de Documento","Periodo","Tipo de Persona (tabla2)","Tipo Documento(tabla 1)","Número de Documento","Importe Total","Apellido Paterno","Apellido Materno","Primer Nombre","Segundo Nombre","Razón Social                      "]
[1,6,20565893174,2016,1,1,"09834233",10000,"Gonzales","Romero","Sergio","","",null,"1|6|20565893174|2016|01|1|09834233|10000|Gonzales|Romero|Sergio|||"]
[2,6,20565893174,2016,2,6,"20512526595",27938,"","","","","Invicta Mining Corp S.A.C.              ",null,"2|6|20565893174|2016|02|6|20512526595|27938|||||Invicta Mining Corp S.A.C.              |"]
[3,6,20565893174,2016,2,6,"20514358347",1816944,"","","","","Mundo Minerales SAC                     ",null,"3|6|20565893174|2016|02|6|20514358347|1816944|||||Mundo Minerales SAC                     |"]
[4,6,20565893174,2016,2,6,"20522495621",1023785,"","","","","Cia. Minera Cerro Pucapunta S.A.C       ",null,"4|6|20565893174|2016|02|6|20522495621|1023785|||||Cia. Minera Cerro Pucapunta S.A.C       |"]

{"sheet":"CONSULTA","index":4,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Detalle de Comprobantes"]
["Campo","Número de Documento"]
["Dato","20521194724","Inversiones Ventura A. & R. E.I.R.L.    ",null,null,{"$f":"SUM(F6:F1000000)","v":139047.14000000001},0,0,0,0,25952.860000000004,0,0,165000]
[]
["Número de Voucher o Registro","Fecha","Tipo Comp.","Serie","Número",{"$f":"DATA!H3","v":"B.I.O.G y E. (A)"},{"$f":"DATA!I3","v":"Importe 2"},{"$f":"DATA!J3","v":"B.I.O.G.sin DER.CRED.FISCAL ©"},{"$f":"DATA!K3","v":"ADQUISICIONES NO GRAV."},{"$f":"DATA!L3","v":"Importe 5"},{"$f":"DATA!M3","v":"IGV1"},{"$f":"DATA!N3","v":"IGV2"},{"$f":"DATA!O3","v":"IGV3"},{"$f":"DATA!P3","v":"Total"}]
["  84","2011-01-02","01","001       ","003176              ",10428.57,0,0,0,null,1981.43,0,0,12410]
["  85","2011-01-11","01","001       ","003243              ",9647.06,0,0,0,null,1832.94,0,0,11480]
["  86","2011-01-18","01","001       ","003295              ",9109.24,0,0,0,null,1730.76,0,0,10840]
["  87","2011-01-25","01","001       ","003339              ",8504.2000000000007,0,0,0,null,1615.8,0,0,10120]
["  87","2011-02-05","01","001       ","003446              ",7495.8,0,0,0,null,1424.2,0,0,8920]
["  88","2011-01-30","01","001       ","003388              ",8529.41,0,0,0,null,1620.59,0,0,10150]
["  88","2011-02-19","01","001       ","003536              ",9168.07,0,0,0,null,1741.93,0,0,10910]
["  89","2011-02-21","01","001       ","003552              ",9991.6,0,0,0,null,1898.4,0,0,11890]
["  90","2011-02-25","01","001       ","003588              ",10445.379999999999,0,0,0,null,1984.62,0,0,12430]
["  91","2011-02-28","01","001       ","003611              ",9117.65,0,0,0,null,1732.35,0,0,10850]
[" 137","2011-03-05","01","001       ","003638              ",9186.44,0,0,0,null,1653.56,0,0,10840]
[" 138","2011-03-15","01","001       ","003697              ",9245.76,0,0,0,null,1664.24,0,0,10910]
[" 139","2011-03-17","01","001       ","003721              ",8906.7800000000007,0,0,0,null,1603.22,0,0,10510]
[" 140","2011-03-19","01","001       ","003745              ",10059.32,0,0,0,null,1810.68,0,0,11870]
[" 141","2011-03-31","01","001       ","003829              ",9211.86,0,0,0,null,1658.14,0,0,10870]

{"sheet":"T1","index":5,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["TABLA 1"]
["============================================"]
["COD.  ","DESCRIPCION"]
["============================================"]
[1,"Libreta Electoral/ DNI"]
[2,"Carnet de Fuerzas policiales"]
[3,"Carnet de Fuerzas armadas"]
[4,"Carnet de Extranjería"]
[6,"Registro Unico de contribuyentes"]
[7,"Pasaporte"]
["- ","Sin documento "]
["____________________________________________"]

{"sheet":"T2","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["TABLA 2"]
["============================================"]
["COD.  ","DESCRIPCION"]
["============================================"]
[1,"Persona Natural."]
[2,"Persona jurica o Entidades."]
[3,"Sujeto no domiciliado."]
[4,"Adquirente - ticket"]
["____________________________________________"]

{"sheet":"ENTIDADES","index":7,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Número de Documento","Apellidos y Nombres o Razón Social",10,12,20,9,11,19,"","pellidos y Nombres o Razón Social","",10,2,"","",""]
["09834233","Gonzales Romero Sergio",9,16,0,7,0,0,"Gonzales","Romero Sergio","Romero",0,16,"Sergio","",""]
["20512526595","Invicta Mining Corp S.A.C.              ",8,15,20,7,14,19,"","nvicta Mining Corp S.A.C.              ","",8,2,"","","Invicta Mining Corp S.A.C.              "]
["20514358347","Mundo Minerales SAC                     ",6,16,20,5,15,19,"","undo Minerales SAC                     ","",6,2,"","","Mundo Minerales SAC                     "]
["20522495621","Cia. Minera Cerro Pucapunta S.A.C       ",5,12,18,4,11,17,"","ia. Minera Cerro Pucapunta S.A.C       ","",5,2,"","","Cia. Minera Cerro Pucapunta S.A.C       "]