{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["MENU","CLIENTES","ARTICULOS","SEGUIMIENTO","RESUMEN","FORMULARIO","TABLACLI"],"not_rendered":{"images":3,"macros":1,"defined_names":2,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"MENU","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[3,1,17,1],[3,2,4,9],[5,9,17,9],[16,2,17,8]]}

{"sheet":"CLIENTES","index":1,"n_rows":5,"n_cols":2,"rows_kept":5}
["NUMERO DE CLIENTE","NOMBRE DEL CLIENTE"]
[1001,"CARLOS XXXX"]
[1002,"ROSA ZZZZZ"]
[1003,"MARIA YYYYY"]
[1004,"ALEXA SSSSS"]

{"sheet":"ARTICULOS","index":2,"n_rows":12,"n_cols":4,"rows_kept":12}
["CODIGO","NOMBRE DEL ARTICULO","DESCRIPCION","PRECIO UNT."]
[2000,"ABANICO","NEGRO, MARCA XXX",{"v":250,"d":"250.00"}]
[2001,"CPU HP","500 GB DE DISCO DURO",{"v":3000,"d":"3,000.00"}]
[2002,"MONITORES HP","21 PULGADAS",{"v":1000,"d":"1,000.00"}]
[2003,"MOUSE","COLOR NEGRO",{"v":150,"d":"150.00"}]
[2004,"TECLADO","GENIUS",{"v":150,"d":"150.00"}]
[2005,"CUADERNOS","NOTE",{"v":25,"d":"25.00"}]
[2006,"LAPICEROS","BIG",{"v":10,"d":"10.00"}]
[2007,"AMPOS","ESPECIALES",{"v":70,"d":"70.00"}]
[2008,"LAPTOP TOSHIBA","1TB DE DISCO DURO",{"v":16000,"d":"16,000.00"}]
[2009,"MEMORIAS RAM","DE 4 GB",{"v":500,"d":"500.00"}]
[2010,"DISCO DUROS","1 TB",{"v":2000,"d":"2,000.00"}]

{"sheet":"SEGUIMIENTO","index":3,"n_rows":19,"n_cols":14,"rows_kept":19}
["FECHA","Nº DE FACT","FECHA DE VENC.","DIAS DE MORA","ESTADO","Nº CLIENTE","NOMBRE DE CLIENTE","CODIGO","NOMBRE DEL ARTICULO","DESCRIPCION","PRECIO UNIT.","CANTIDAD","IMPUESTO ","TOTAL"]
["2017-03-04",1,"2017-02-05",{"$f":"IF(C2=ISBLANK(0),0,IF(C2<TODAY(),DAYS360(TODAY(),C2,FALSE),IF(C2>TODAY(),DAYS360(TODAY(),C2,FALSE),0)))","v":-31},{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1001,{"$f":"IF(F2<>0,VLOOKUP(F2,CLIENTE[],2,0),\"\")","v":"CARLOS XXXX"},2000,{"$f":"IF(H2<>0,VLOOKUP(H2,PRODUCTOS[],2,0),\"\")","v":"ABANICO"},{"$f":"IF(H2<>0,VLOOKUP(H2,PRODUCTOS[],3,0),\"\")","v":"NEGRO, MARCA XXX"},{"$f":"IF(H2<>0,VLOOKUP(H2,PRODUCTOS[],4,0),\"\")","v":250},2,{"$f":"IF(L2>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":80},{"$f":"IF(L2>0,(K2*L2)+M2,\"\")","v":{"v":580,"d":"580.00"}}]
["2017-01-01",2,"2017-02-09",-27,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1002,{"$f":"IF(F3<>0,VLOOKUP(F3,CLIENTE[],2,0),\"\")","v":"ROSA ZZZZZ"},2001,{"$f":"IF(H3<>0,VLOOKUP(H3,PRODUCTOS[],2,0),\"\")","v":"CPU HP"},{"$f":"IF(H3<>0,VLOOKUP(H3,PRODUCTOS[],3,0),\"\")","v":"500 GB DE DISCO DURO"},{"$f":"IF(H3<>0,VLOOKUP(H3,PRODUCTOS[],4,0),\"\")","v":3000},3,{"$f":"IF(L3>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":1440},{"v":10440,"d":"10,440.00"}]
["2017-01-02",3,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1002,{"$f":"IF(F4<>0,VLOOKUP(F4,CLIENTE[],2,0),\"\")","v":"ROSA ZZZZZ"},2002,{"$f":"IF(H4<>0,VLOOKUP(H4,PRODUCTOS[],2,0),\"\")","v":"MONITORES HP"},{"$f":"IF(H4<>0,VLOOKUP(H4,PRODUCTOS[],3,0),\"\")","v":"21 PULGADAS"},{"$f":"IF(H4<>0,VLOOKUP(H4,PRODUCTOS[],4,0),\"\")","v":1000},1,{"$f":"IF(L4>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":160},{"v":1160,"d":"1,160.00"}]
["2017-01-03",4,"2017-02-09",-27,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1003,{"$f":"IF(F5<>0,VLOOKUP(F5,CLIENTE[],2,0),\"\")","v":"MARIA YYYYY"},2003,{"$f":"IF(H5<>0,VLOOKUP(H5,PRODUCTOS[],2,0),\"\")","v":"MOUSE"},{"$f":"IF(H5<>0,VLOOKUP(H5,PRODUCTOS[],3,0),\"\")","v":"COLOR NEGRO"},{"$f":"IF(H5<>0,VLOOKUP(H5,PRODUCTOS[],4,0),\"\")","v":150},1,{"$f":"IF(L5>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":24},{"v":174,"d":"174.00"}]
["2017-01-04",5,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1001,{"$f":"IF(F6<>0,VLOOKUP(F6,CLIENTE[],2,0),\"\")","v":"CARLOS XXXX"},2004,{"$f":"IF(H6<>0,VLOOKUP(H6,PRODUCTOS[],2,0),\"\")","v":"TECLADO"},{"$f":"IF(H6<>0,VLOOKUP(H6,PRODUCTOS[],3,0),\"\")","v":"GENIUS"},{"$f":"IF(H6<>0,VLOOKUP(H6,PRODUCTOS[],4,0),\"\")","v":150},1,{"$f":"IF(L6>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":24},{"v":174,"d":"174.00"}]
["2017-01-05",6,"2017-02-12",-24,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1002,{"$f":"IF(F7<>0,VLOOKUP(F7,CLIENTE[],2,0),\"\")","v":"ROSA ZZZZZ"},2005,{"$f":"IF(H7<>0,VLOOKUP(H7,PRODUCTOS[],2,0),\"\")","v":"CUADERNOS"},{"$f":"IF(H7<>0,VLOOKUP(H7,PRODUCTOS[],3,0),\"\")","v":"NOTE"},{"$f":"IF(H7<>0,VLOOKUP(H7,PRODUCTOS[],4,0),\"\")","v":25},1,{"$f":"IF(L7>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":4},{"v":29,"d":"29.00"}]
["2017-01-05",7,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1002,{"$f":"IF(F8<>0,VLOOKUP(F8,CLIENTE[],2,0),\"\")","v":"ROSA ZZZZZ"},2006,{"$f":"IF(H8<>0,VLOOKUP(H8,PRODUCTOS[],2,0),\"\")","v":"LAPICEROS"},{"$f":"IF(H8<>0,VLOOKUP(H8,PRODUCTOS[],3,0),\"\")","v":"BIG"},{"$f":"IF(H8<>0,VLOOKUP(H8,PRODUCTOS[],4,0),\"\")","v":10},1,{"$f":"IF(L8>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":1.6},{"v":11.6,"d":"11.60"}]
["2017-01-06",8,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1001,{"$f":"IF(F9<>0,VLOOKUP(F9,CLIENTE[],2,0),\"\")","v":"CARLOS XXXX"},2007,{"$f":"IF(H9<>0,VLOOKUP(H9,PRODUCTOS[],2,0),\"\")","v":"AMPOS"},{"$f":"IF(H9<>0,VLOOKUP(H9,PRODUCTOS[],3,0),\"\")","v":"ESPECIALES"},{"$f":"IF(H9<>0,VLOOKUP(H9,PRODUCTOS[],4,0),\"\")","v":70},1,{"$f":"IF(L9>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":11.200000000000001},{"v":81.2,"d":"81.20"}]
["2017-01-06",9,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1001,{"$f":"IF(F10<>0,VLOOKUP(F10,CLIENTE[],2,0),\"\")","v":"CARLOS XXXX"},2008,{"$f":"IF(H10<>0,VLOOKUP(H10,PRODUCTOS[],2,0),\"\")","v":"LAPTOP TOSHIBA"},{"$f":"IF(H10<>0,VLOOKUP(H10,PRODUCTOS[],3,0),\"\")","v":"1TB DE DISCO DURO"},{"$f":"IF(H10<>0,VLOOKUP(H10,PRODUCTOS[],4,0),\"\")","v":16000},1,{"$f":"IF(L10>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":2560},{"v":18560,"d":"18,560.00"}]
["2017-01-08",10,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1003,{"$f":"IF(F11<>0,VLOOKUP(F11,CLIENTE[],2,0),\"\")","v":"MARIA YYYYY"},2009,{"$f":"IF(H11<>0,VLOOKUP(H11,PRODUCTOS[],2,0),\"\")","v":"MEMORIAS RAM"},{"$f":"IF(H11<>0,VLOOKUP(H11,PRODUCTOS[],3,0),\"\")","v":"DE 4 GB"},{"$f":"IF(H11<>0,VLOOKUP(H11,PRODUCTOS[],4,0),\"\")","v":500},5,{"$f":"IF(L11>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":400},{"v":2900,"d":"2,900.00"}]
["2017-01-09",11,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1002,{"$f":"IF(F12<>0,VLOOKUP(F12,CLIENTE[],2,0),\"\")","v":"ROSA ZZZZZ"},2007,{"$f":"IF(H12<>0,VLOOKUP(H12,PRODUCTOS[],2,0),\"\")","v":"AMPOS"},{"$f":"IF(H12<>0,VLOOKUP(H12,PRODUCTOS[],3,0),\"\")","v":"ESPECIALES"},{"$f":"IF(H12<>0,VLOOKUP(H12,PRODUCTOS[],4,0),\"\")","v":70},2,{"$f":"IF(L12>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":22.400000000000002},{"v":162.4,"d":"162.40"}]
["2017-01-24",12,"2017-02-28",-8,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1003,{"$f":"IF(F13<>0,VLOOKUP(F13,CLIENTE[],2,0),\"\")","v":"MARIA YYYYY"},2002,{"$f":"IF(H13<>0,VLOOKUP(H13,PRODUCTOS[],2,0),\"\")","v":"MONITORES HP"},{"$f":"IF(H13<>0,VLOOKUP(H13,PRODUCTOS[],3,0),\"\")","v":"21 PULGADAS"},{"$f":"IF(H13<>0,VLOOKUP(H13,PRODUCTOS[],4,0),\"\")","v":1000},4,{"$f":"IF(L13>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":640},{"v":4640,"d":"4,640.00"}]
["2017-01-24",13,"2017-02-02",-34,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1001,{"$f":"IF(F14<>0,VLOOKUP(F14,CLIENTE[],2,0),\"\")","v":"CARLOS XXXX"},2006,{"$f":"IF(H14<>0,VLOOKUP(H14,PRODUCTOS[],2,0),\"\")","v":"LAPICEROS"},{"$f":"IF(H14<>0,VLOOKUP(H14,PRODUCTOS[],3,0),\"\")","v":"BIG"},{"$f":"IF(H14<>0,VLOOKUP(H14,PRODUCTOS[],4,0),\"\")","v":10},1,{"$f":"IF(L14>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":1.6},{"v":11.6,"d":"11.60"}]
["2017-01-25",14,"2017-01-25",-41,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1002,{"$f":"IF(F15<>0,VLOOKUP(F15,CLIENTE[],2,0),\"\")","v":"ROSA ZZZZZ"},2004,{"$f":"IF(H15<>0,VLOOKUP(H15,PRODUCTOS[],2,0),\"\")","v":"TECLADO"},{"$f":"IF(H15<>0,VLOOKUP(H15,PRODUCTOS[],3,0),\"\")","v":"GENIUS"},{"$f":"IF(H15<>0,VLOOKUP(H15,PRODUCTOS[],4,0),\"\")","v":150},2,{"$f":"IF(L15>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":48},{"v":348,"d":"348.00"}]
["2017-01-28",15,"2017-01-28",-38,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},1001,{"$f":"IF(F16<>0,VLOOKUP(F16,CLIENTE[],2,0),\"\")","v":"CARLOS XXXX"},2000,{"$f":"IF(H16<>0,VLOOKUP(H16,PRODUCTOS[],2,0),\"\")","v":"ABANICO"},{"$f":"IF(H16<>0,VLOOKUP(H16,PRODUCTOS[],3,0),\"\")","v":"NEGRO, MARCA XXX"},{"$f":"IF(H16<>0,VLOOKUP(H16,PRODUCTOS[],4,0),\"\")","v":250},3,{"$f":"IF(L16>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":120},{"v":870,"d":"870.00"}]
["2017-01-29",16,"2017-02-15",-21,{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},null,{"$f":"IF(F17<>0,VLOOKUP(F17,CLIENTE[],2,0),\"\")","v":""},null,{"$f":"IF(H17<>0,VLOOKUP(H17,PRODUCTOS[],2,0),\"\")","v":""},{"$f":"IF(H17<>0,VLOOKUP(H17,PRODUCTOS[],3,0),\"\")","v":""},{"$f":"IF(H17<>0,VLOOKUP(H17,PRODUCTOS[],4,0),\"\")","v":""},null,{"$f":"IF(L17>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":""},""]
["2017-02-01",17,"2017-03-03",{"$f":"IF(C18=ISBLANK(0),0,IF(C18<TODAY(),DAYS360(TODAY(),C18,FALSE),IF(C18>TODAY(),DAYS360(TODAY(),C18,FALSE),0)))","v":-3},{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"VENCIDO"},null,{"$f":"IF(F18<>0,VLOOKUP(F18,CLIENTE[],2,0),\"\")","v":""},null,{"$f":"IF(H18<>0,VLOOKUP(H18,PRODUCTOS[],2,0),\"\")","v":""},{"$f":"IF(H18<>0,VLOOKUP(H18,PRODUCTOS[],3,0),\"\")","v":""},{"$f":"IF(H18<>0,VLOOKUP(H18,PRODUCTOS[],4,0),\"\")","v":""},null,{"$f":"IF(L18>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":""},""]
["2017-03-04",18,"2017-04-04",{"$f":"IF(C19=ISBLANK(0),0,IF(C19<TODAY(),DAYS360(TODAY(),C19,FALSE),IF(C19>TODAY(),DAYS360(TODAY(),C19,FALSE),0)))","v":28},{"$f":"IF(BASE[[#This Row],[DIAS DE MORA]]<0,\"VENCIDO\",IF(BASE[[#This Row],[FECHA DE VENC.]]>1,\"PENDIENTE\",\"\"))","v":"PENDIENTE"},1001,{"$f":"IF(F19<>0,VLOOKUP(F19,CLIENTE[],2,0),\"\")","v":"CARLOS XXXX"},2001,{"$f":"IF(H19<>0,VLOOKUP(H19,PRODUCTOS[],2,0),\"\")","v":"CPU HP"},{"$f":"IF(H19<>0,VLOOKUP(H19,PRODUCTOS[],3,0),\"\")","v":"500 GB DE DISCO DURO"},{"$f":"IF(H19<>0,VLOOKUP(H19,PRODUCTOS[],4,0),\"\")","v":3000},{"v":2,"d":"2.00"},{"$f":"IF(L19>0,(BASE[[#This Row],[CANTIDAD]]*BASE[[#This Row],[PRECIO UNIT.]])*0.16,\"\")","v":960},{"$f":"IF(L19>0,(K19*L19)+M19,\"\")","v":{"v":6960,"d":"6,960.00"}}]

{"sheet":"RESUMEN","index":4,"n_rows":6,"n_cols":5,"rows_kept":6}
["NOMBRE DE CLIENTE","CARLOS XXXX"]
["ESTADO","PENDIENTE"]
[]
["Nº DE FACTR","SFECHA","FECHA DE VENC","DIAS MORA","TOTALES"]
[18,"2017-03-04","2017-04-04",28,{"v":6960,"d":"6,960.00"}]
["Total general",42798,"2017-04-04",28,{"v":6960,"d":"6,960.00"}]

{"sheet":"FORMULARIO","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"hidden":true,"merged":[[2,0,3,2],[6,0,6,2]]}
[]
[]
["EJEMPLO DE VALIDACION DE DATOS DINAMICO"]
[]
[]
[]
["https://aplicaexcelcontable.com/blog"]
[]
[]
["ID CONTABLE","NOMBRE DEL CLIENTE","DIRECCION"]
[20007,{"$f":"IF(A11<>0,VLOOKUP(A11,CLIENTES[],2,0))","v":"JOAN EULALIA"},"SANDINO"]

{"sheet":"TABLACLI","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"hidden":true}
["ID CONTABLE","NOMBRE DEL CLIENTE","DIRECCION"]
[2000,"CARLOS WILSON"]
[20001,"NELSON PEÑA"]
[20003,"ADRIANA TELLEZ"]
[2004,"LUCIA FERMIN"]
[20005,"ROSA LINA"]
[20006,"NIDIA VLADIMIR"]
[20007,"JOAN EULALIA"]
[20008,"ALEXA IDANIA"]