{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["DATOS EMPRESA","PRINCIPAL","IMPRESION","IMP NV","SALDOS","REGISTROS","NOTAVTA","SALIDAS","CLIENTES","PRODUCTOS","INDX"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":4,"comments":1,"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":"DATOS EMPRESA","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["DATOS GENERALES"]
[]
["NOMBRE DE LA EMPRESA:","EMPRESA EJEMPLO"]
["ULTIMO FOLIO FACTURADO:",1005]
["ULTIMA NOTA EMITIDA:",890]
["MÁX. ARTICULOS FACTURADOS",10]
["MÁX. ARTS. EN NOTA DE VENTA",10]

{"sheet":"PRINCIPAL","index":1,"n_rows":12,"n_cols":23,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,19,5,20],[0,0,0,22],[1,0,1,22],[3,1,3,2],[3,19,3,20],[3,3,3,17],[5,3,5,17],[5,1,5,2],[9,21,9,22],[10,1,10,3],[10,4,10,12],[10,13,10,15],[7,12,7,14],[7,6,7,8],[7,1,7,3],[9,18,9,20]]}
[{"$f":"'DATOS EMPRESA'!B3","v":"EMPRESA EJEMPLO"}]
["Formato de registro de factura"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha:",{"$f":"TODAY()","v":"2012-10-16"}]
[null,"Cliente:",null,"EL MERO S.C.L.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RFC:","ELM5806048F5",null,"Registros:",{"$f":"COUNTA(W12:W65536)","v":1}]
[]
[null,"Domicilio:",null,"MANUEL M. DIEGUEZ 8722 E/ E/NORMAL Y JUAREZ Col. LOS OLIVOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad/Edo.","SAN JUAN, HIDALGO",null,"Folio:",1005]
[]
[null,"CONTADO",null,null,null,"Subtotal:",{"$f":"R8+M8","v":200},null,null,null,null,"Descuento:",{"$f":"SUM(S12:S65536)","v":0},null,null,null,"Subtotal Neto:",{"$f":"SUM(T12:T65536)","v":200},"IVA",{"$f":"SUM(V12:V65536)","v":0},"Total:",{"$f":"SUM(W12:W65536)","v":200}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBSERVACIONES:",null,null,null," DOSCIENTOS  PESOS 00/100 M.N."]
["No","CÓDIGO",null,null,"DESCRIPCIÓN",null,null,null,null,null,null,null,null,"Unidad d Med",null,null,"Cantidad","Precio","Descuento","Subtotal","Tasa IVA","IVA","Total"]
[1,"B-001",null,null,"ACCESORIO, GAS REFRIGERANTE ",null,null,null,null,null,null,null,null,"LITROS",null,null,1,200,null,200,0,0,200]

{"sheet":"IMPRESION","index":2,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[27,2,27,6],[25,1,25,6],[11,10,11,15],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[7,0,7,2],[33,0,36,5],[19,1,19,6],[20,1,20,6],[21,1,21,6],[23,1,23,6],[24,1,24,6],[32,1,32,6],[29,2,29,6],[26,1,26,6],[18,1,18,6],[22,1,22,6],[28,1,28,6],[15,1,15,6],[16,1,16,6],[17,1,17,6]]}
[null,null,"                                                                                                                "]
[]
[]
[null,{"$f":"IF(PRINCIPAL!D4<>\"\",PRINCIPAL!D4,\"\")","v":"EL MERO S.C.L."}]
[null,{"$f":"IF(PRINCIPAL!D6<>\"\",PRINCIPAL!D6,\"\")","v":"MANUEL M. DIEGUEZ 8722 E/ E/NORMAL Y JUAREZ Col. LOS OLIVOS"}]
[null,{"$f":"IF(PRINCIPAL!T6<>\"\",PRINCIPAL!T6,\"\")","v":"SAN JUAN, HIDALGO"}]
[]
[{"$f":"IF(PRINCIPAL!T4<>\"\",PRINCIPAL!T4,\"\")","v":"ELM5806048F5"},null,null,null,null,null,{"$f":"PRINCIPAL!W3","v":"2012-10-16"}]
[]
[null,null,null,null,null," "]
[]
[1,"ACCESORIO, GAS REFRIGERANTE ",null,null,null,null,null,200,200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"***NO SE ACEPTAN DEVOLUCIONES***"]
[null,null,"***PAGO HECHO EN UNA SOLA EXHIBICION***"]
[]
[]
[]
[{"$f":"IF(PRINCIPAL!V10<>\"\",PRINCIPAL!V10,\"\")","v":" DOSCIENTOS  PESOS 00/100 M.N."},null,null,null,null,null,null,null,{"$f":"PRINCIPAL!R8","v":200}]
[null,null,null,null,null,null,null,null,{"$f":"PRINCIPAL!T8","v":0}]
[null,null,null,null,null,null,null," ",{"$f":"PRINCIPAL!V8","v":200}]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"IMP NV","index":3,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,3,4,5],[5,3,6,5],[7,3,7,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[21,4,21,5],[23,4,23,5],[24,4,24,5],[25,3,27,5],[13,4,13,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[20,4,20,5]]}
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2012-10-16"}]
[null,null,null,{"$f":"PRINCIPAL!D4","v":"EL MERO S.C.L."}]
[]
[]
[]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"PRINCIPAL!V10","v":" DOSCIENTOS  PESOS 00/100 M.N."},null,null,null,{"$f":"H28","v":200}]
[]
[null,null,null,null,null,null," ",{"$f":"PRINCIPAL!V8","v":200}]
[]
[null,null,null,null,null,null," "]

{"sheet":"SALDOS","index":4,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[[2,8,2,9],[0,0,0,8],[1,0,1,8]]}
[{"$f":"PRINCIPAL!A1","v":"EMPRESA EJEMPLO"}]
["CONTROL DE FACTURAS A CRÉDITO"]
["REGS:",{"$f":"COUNTA(B5:B65536)","v":27},null,null,null,null,null,null,{"$f":"TODAY()","v":"2012-10-16"}]
["No CTRL","No FACT/NOTA","FECHA","No.CLIENTE","MOVIMIENTO","TIPO","IMPORTE","STATUS","OBSERVACIONES"]
[1,32,"2008-03-13",2,"C","FC",55200,4,"tttttt"]
[2,10,"2008-03-19",6,"C","NV",1800,4,"kjjkjhj"]
[3,11,"2008-03-19",3,"C","NV",null,2,"**** CANCELADO ****"]
[4,36,"2008-03-19",6,"C","FC",0,2,"**** CANCELADO ****"]
[5,37,"2008-03-19",5,"C","FC",207000,4,"kjhkjhkjh"]
[6,38,"2008-03-19",2,"C","FC",null,2,"**** CANCELADO ****"]
[7,39,"2008-03-19",1,"C","FC",null,2,"**** CANCELADO ****"]
[8,12,"2008-03-19",2,"C","NV",43125,4,"aaaaaaaaaa"]
[9,42,"2008-03-19",2,"C","FC",17250,4]
[10,13,"2008-03-25",3,"C","NV",13800,4,"x"]
[11,44,"2008-03-26",6,"C","FC",2000,1,"ssss"]
[12,45,"2008-03-26",6,"C","FC",41400,1,"g"]
[13,32,"2008-03-26T22:34:02",2,"A","FC",55200,4]
[14,12,"2008-03-26T22:34:41",2,"A","NV",43125,4]
[15,13,"2008-03-26T22:45:12",3,"A","NV",10000,3]
[16,13,"2008-03-26T22:46:14",3,"A","NV",3800,4]
[17,42,"2008-03-26T22:52:48",2,"A","FC",17200,3]
[18,42,"2008-03-26T22:53:02",2,"A","FC",50,4]
[19,37,"2008-03-26T22:53:22",5,"A","FC",200000,3]
[20,37,"2008-03-26T22:54:08",5,"A","FC",7000,4]
[21,10,"2008-03-26T22:54:25",6,"A","NV",1000,3]
[22,10,"2008-03-26T22:54:39",6,"A","NV",800,4]
[23,46,"2008-04-02",2,"C","FC",17250,1,"x"]
[24,15,"2008-04-02",3,"C","NV",140000,1,"Z"]
[25,16,"2008-04-02",4,"C","NV",34900,1,"Z"]
[26,17,"2008-04-03",5,"C","NV",9155,1,"X"]
[27,47,"2008-04-03",2,"C","FC",220800,1,"H"]

{"sheet":"REGISTROS","index":5,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10]]}
[{"$f":"'DATOS EMPRESA'!B3","v":"EMPRESA EJEMPLO"}]
["REPORTE DE FACTURAS EMITIDAS"]
["FECHA",{"$f":"TODAY()","v":"2012-10-16"}]
["No REGISTROS",{"$f":"COUNTA(A6:A65536)","v":24}]
["#FACT","FECHA ELAB","RFC","NOMBRE","SUBTOTAL 1","DESCUENTO","SUBTOTAL 2","IVA","TOTAL","TIPO DE PAGO","OBSERVACIONES"]
[32,"2008-03-13","HNT5406159D0","HIELO DEL NORTE SA DE CV",48000,0,48000,7200,55200,"CREDITO"]
[33,"2008-03-19","EXS850709U15","EMPRESAS X´S SA DE CV",24000,0,24000,3600,27600,"CONTADO"]
[34,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV",1200,0,1200,0,1200,"CONTADO"]
[35,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV",225000,0,225000,33750,258750,"CONTADO"]
[36,"2008-03-19","PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA",0,0,0,0,0,"CREDITO"]
[37,"2008-03-19","USC0608166R5","UNION DE SOC. COOP. PESQ",180000,0,180000,27000,207000,"CREDITO"]
[38,"2008-03-19","HNT5406159D0","**** CANCELADA ****",null,null,null,null,null,"CREDITO"]
[39,"2008-03-19","EIJJ990813DA8","**** CANCELADA ****",null,null,null,null,null,"CREDITO"]
[40,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV",15000,0,15000,2250,17250,"CONTADO"]
[41,"2008-03-19","EIJJ990813DA8","JUAN JESUS ECIMO",15000,0,15000,2250,17250,"CONTADO"]
[42,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV",15000,0,15000,2250,17250,"CREDITO"]
[43,"2008-03-25","HNT5406159D0","HIELO DEL NORTE SA DE CV",75000,0,75000,11250,86250,"CONTADO"]
[44,"2008-03-26","PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA",2000,0,2000,0,2000,"CREDITO"]
[45,"2008-03-26","PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA",36000,0,36000,5400,41400,"CREDITO"]
[46,"2008-04-02","HNT5406159D0","HIELO DEL NORTE SA DE CV",15000,0,15000,2250,17250,"CREDITO"]
[47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV",192000,0,192000,28800,220800,"CREDITO"]
[51,"2008-07-11","EXS850709U15","EMPRESAS X´S SA DE CV",30000,0,30000,4500,34500,"CONTADO"]
[52,"2009-07-08","HNT5406159D0","HIELO DEL NORTE SA DE CV",12000,0,12000,1800,13800,"CONTADO"]
[53,"2010-06-02","EIJJ990813DA8","JUAN JESUS ECIMO",24000,0,24000,3600,27600,"CONTADO"]
[54,"2010-06-02","EXS850709U15","EMPRESAS X´S SA DE CV",90000,0,90000,13500,103500,"CONTADO"]
[55,"2010-06-02","PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA",12000,0,12000,1920,13920,"CONTADO"]
[1003,"2012-03-19","USC0608166R5","UNION DE SOC. COOP. PESQ",400,0,400,0,400,"CONTADO"]
[1004,"2012-09-13","EXS850709U15","EMPRESAS X´S SA DE CV",24000,0,24000,3840,27840,"CONTADO"]
[1005,"2012-09-13","ELM5806048F5","EL MERO S.C.L.",200,0,200,0,200,"CONTADO"]

{"sheet":"NOTAVTA","index":6,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10]]}
[{"$f":"'DATOS EMPRESA'!B3","v":"EMPRESA EJEMPLO"}]
["REPORTE DE NOTAS DE VENTA EMITIDAS"]
["FECHA",{"$f":"TODAY()","v":"2012-10-16"}]
["No REGISTROS",{"$f":"COUNTA(A6:A65536)","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(W12:W65536)","v":0}]
["#OPER","FECHA ELAB","No CLIENTE","NOMBRE","SUBTOTAL 1","DESCUENTO","SUBTOTAL 2","IVA","TOTAL","TIPO DE PAGO","OBSERVACIONES"]
[10,"2008-03-19",6,"PROPULSORA INDUSTRIAL DE V SA",1800,0,1800,0,1800,"CREDITO","kjjkjhj"]
[11,"2008-03-19",3,"**** CANCELADA ****",null,null,null,null,null,"CREDITO","kjgjhhgjh"]
[12,"2008-03-19",2,"HIELO DEL NORTE SA DE CV",37500,0,37500,5625,43125,"CREDITO","aaaaaaaaaa",null,{"$f":"SUM(S12:S65536)","v":0},null,null,null,null,{"$f":"SUM(T12:T65536)","v":0},null,{"$f":"SUM(V12:V65536)","v":0},null,{"$f":"SUM(W12:W65536)","v":0}]
[13,"2008-03-25",3,"EMPRESAS X´S SA DE CV",12000,0,12000,1800,13800,"CREDITO","x"]
[14,"2008-04-02",2,"HIELO DEL NORTE SA DE CV",23100,0,23100,3375,26475,"CONTADO","N"]
[15,"2008-04-02",3,"EMPRESAS X´S SA DE CV",122000,0,122000,18000,140000,"CREDITO","Z"]
[16,"2008-04-02",4,"EL MERO S.C.L.",30400,0,30400,4500,34900,"CREDITO","Z"]
[17,"2008-04-03",5,"UNION DE SOC. COOP. PESQ",8000,0,8000,1155,9155,"CREDITO","X"]

{"sheet":"SALIDAS","index":7,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[[3,0,3,1],[2,0,2,1],[0,0,0,12],[1,0,1,12]]}
[{"$f":"REGISTROS!A1","v":"EMPRESA EJEMPLO"}]
["REPORTE DE SALIDAS DE PRODUCTOS"]
["No. REGISTROS:",null,{"$f":"COUNTA(B6:B65536)","v":70}]
["FECHA:",null,{"$f":"TODAY()","v":"2012-10-16"}]
["No","#FACT/NOTA","FECHA ELAB","RFC","CLIENTE","DESCRIPCIÓN ","CANTIDAD ","PRECIO UNITARIO","DESCUENTO S/VTA","IMPORTE DE VENTA","IVA","TOTAL","U.M.","DOCTO"]
[1,32,"2008-03-13","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[2,32,"2008-03-13","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[3,32,"2008-03-13","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[4,32,"2008-03-13","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[5,33,"2008-03-19","EXS850709U15","EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[6,33,"2008-03-19","EXS850709U15","EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[7,34,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","ACCESORIO, GAS REFRIGERANTE ",2,200,null,400,0,400,"LITROS","FACTURA"]
[8,34,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","ACCESORIO, GAS REFRIGERANTE ",2,200,null,400,0,400,"LITROS","FACTURA"]
[9,34,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","ACCESORIO, GAS REFRIGERANTE ",2,200,null,400,0,400,"LITROS","FACTURA"]
[10,35,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",3,15000,null,45000,6750,51750,"PIEZA","FACTURA"]
[11,35,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",3,15000,null,45000,6750,51750,"PIEZA","FACTURA"]
[12,35,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",3,15000,null,45000,6750,51750,"PIEZA","FACTURA"]
[13,35,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",3,15000,null,45000,6750,51750,"PIEZA","FACTURA"]
[14,35,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",3,15000,null,45000,6750,51750,"PIEZA","FACTURA"]
[15,10,"2008-03-19",6,"PROPULSORA INDUSTRIAL DE V SA","ACCESORIO, GAS REFRIGERANTE ",3,200,null,600,0,600,"LITROS","NOTA DE VENTA"]
[16,10,"2008-03-19",6,"PROPULSORA INDUSTRIAL DE V SA","ACCESORIO, GAS REFRIGERANTE ",3,200,null,600,0,600,"LITROS","NOTA DE VENTA"]
[17,10,"2008-03-19",6,"PROPULSORA INDUSTRIAL DE V SA","ACCESORIO, GAS REFRIGERANTE ",3,200,null,600,0,600,"LITROS","NOTA DE VENTA"]
[18,11,"2008-03-19",3,"**** CANCELADO ****"]
[19,11,"2008-03-19",3,"**** CANCELADO ****"]
[20,37,"2008-03-19","USC0608166R5","UNION DE SOC. COOP. PESQ","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",6,15000,null,90000,13500,103500,"PIEZA","FACTURA"]
[21,37,"2008-03-19","USC0608166R5","UNION DE SOC. COOP. PESQ","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",6,15000,null,90000,13500,103500,"PIEZA","FACTURA"]
[22,38,"2008-03-19","HNT5406159D0","**** CANCELADO ****"]
[23,38,"2008-03-19","HNT5406159D0","**** CANCELADO ****"]
[24,39,"2008-03-19","EIJJ990813DA8","**** CANCELADO ****"]
[25,39,"2008-03-19","EIJJ990813DA8","**** CANCELADO ****"]
[26,40,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA CARRIER 12,000 BTU DE VENTANA 220 VOLTS",1,7500,null,7500,1125,8625,"PIEZA","FACTURA"]
[27,40,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA CARRIER 12,000 BTU DE VENTANA 220 VOLTS",1,7500,null,7500,1125,8625,"PIEZA","FACTURA"]
[28,12,"2008-03-19",2,"HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA CARRIER 12,000 BTU DE VENTANA 220 VOLTS",5,7500,null,37500,5625,43125,"PIEZA","NOTA DE VENTA"]
[29,41,"2008-03-19","EIJJ990813DA8","JUAN JESUS ECIMO","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",1,15000,null,15000,2250,17250,"PIEZA","FACTURA"]
[30,42,"2008-03-19","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",1,15000,null,15000,2250,17250,"PIEZA","FACTURA"]
[31,43,"2008-03-25","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",5,15000,null,75000,11250,86250,"PIEZA","FACTURA"]
[32,13,"2008-03-25",3,"EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","NOTA DE VENTA"]
[33,44,"2008-03-26","PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA","ACCESORIO, GAS REFRIGERANTE ",10,200,null,2000,0,2000,"LITROS","FACTURA"]
[34,45,"2008-03-26","PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",3,12000,null,36000,5400,41400,"PIEZA","FACTURA"]
[35,46,"2008-04-02","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",1,15000,null,15000,2250,17250,"PIEZA","FACTURA"]
[36,14,"2008-04-02",2,"HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA CARRIER 12,000 BTU DE VENTANA 220 VOLTS",3,7500,null,22500,3375,25875,"PIEZA","NOTA DE VENTA"]
[37,14,"2008-04-02",2,"HIELO DEL NORTE SA DE CV","ACCESORIO, GAS REFRIGERANTE ",3,200,null,600,0,600,"LITROS","NOTA DE VENTA"]
[38,15,"2008-04-02",3,"EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",10,12000,null,120000,18000,138000,"PIEZA","NOTA DE VENTA"]
[39,15,"2008-04-02",3,"EMPRESAS X´S SA DE CV","ACCESORIO, GAS REFRIGERANTE ",10,200,null,2000,0,2000,"LITROS","NOTA DE VENTA"]
[40,16,"2008-04-02",4,"EL MERO S.C.L.","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",2,15000,null,30000,4500,34500,"PIEZA","NOTA DE VENTA"]
[41,16,"2008-04-02",4,"EL MERO S.C.L.","ACCESORIO, GAS REFRIGERANTE ",2,200,null,400,0,400,"LITROS","NOTA DE VENTA"]
[42,17,"2008-04-03",5,"UNION DE SOC. COOP. PESQ","AIRE ACONDICIONADO, MARCA CARRIER 12,000 BTU DE VENTANA 220 VOLTS",1,7500,null,7500,1125,8625,"PIEZA","NOTA DE VENTA"]
[43,17,"2008-04-03",5,"UNION DE SOC. COOP. PESQ","ACCESORIO, GAS REFRIGERANTE ",1,200,null,200,0,200,"LITROS","NOTA DE VENTA"]
[44,17,"2008-04-03",5,"UNION DE SOC. COOP. PESQ","ACCESORIO, ESPUMA AISLANTE",1,300,null,300,30,330,"METRO CUADRADO","NOTA DE VENTA"]
[45,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[46,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[47,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[48,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[49,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[50,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[51,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[52,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[53,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[54,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[55,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[56,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[57,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[58,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[59,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[60,47,"2008-04-03","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[61,51,"2008-07-11","EXS850709U15","EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",1,15000,null,15000,2250,17250,"PIEZA","FACTURA"]
[62,51,"2008-07-11","EXS850709U15","EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",1,15000,null,15000,2250,17250,"PIEZA","FACTURA"]
[63,52,"2009-07-08","HNT5406159D0","HIELO DEL NORTE SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1800,13800,"PIEZA","FACTURA"]
[64,53,"2010-06-02","EIJJ990813DA8","JUAN JESUS ECIMO","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",2,12000,null,24000,3600,27600,"PIEZA","FACTURA"]
[65,54,"2010-06-02","EXS850709U15","EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",3,15000,null,45000,6750,51750,"PIEZA","FACTURA"]
[66,54,"2010-06-02","EXS850709U15","EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",3,15000,null,45000,6750,51750,"PIEZA","FACTURA"]
[67,55,"2010-06-02","PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",1,12000,null,12000,1920,13920,"PIEZA","FACTURA"]
[68,1003,"2012-03-19","USC0608166R5","UNION DE SOC. COOP. PESQ","ACCESORIO, GAS REFRIGERANTE ",2,200,null,400,0,400,"LITROS","FACTURA"]
[69,1004,"2012-09-13","EXS850709U15","EMPRESAS X´S SA DE CV","AIRE ACONDICIONADO, MARCA SAMSUNG 24,000 BTU´S",2,12000,null,24000,3840,27839.999999999996,"PIEZA","FACTURA"]
[70,1005,"2012-09-13","ELM5806048F5","EL MERO S.C.L.","ACCESORIO, GAS REFRIGERANTE ",1,200,null,200,0,200,"LITROS","FACTURA"]

{"sheet":"CLIENTES","index":8,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14]]}
[{"$f":"REGISTROS!A1","v":"EMPRESA EJEMPLO"}]
["REPORTE DE DATOS DE CLIENTES"]
["FECHA:",{"$f":"TODAY()","v":"2012-10-16"}]
["REGISTROS:",{"$f":"COUNTA(B6:B65536)","v":6}]
["# CONSECUTIVO","RFC","CLIENTE","CURP","REPRESENTANTE LEGAL:","CALLE","No","REFERENCIA","COLONIA","CIUDAD","CP","MPIO","EDO","TELEFONO(S)","CORREO ELECTRÓNICO"]
[1,"EIJJ990813DA8","JUAN JESUS ECIMO",null,null,"MANUEL TORRE IGLESIAS",988,"E/ ALTAMIRANO Y GOMEZ FARIAS",null,"ROSARITO",null,null," BC"]
[2,"HNT5406159D0","HIELO DEL NORTE SA DE CV",null,"JORGE S. R.","RIO NILO",1230,null,"QUINTA VELARDE SECTOR REFORMA","VILLA INSURGENTES",null,null,"JALISCO"]
[3,"EXS850709U15","EMPRESAS X´S SA DE CV",null,"IVAN D. L.","CALZADA NORTE",790,"ESQ. COLOSIO",null,"MONTEJO",null,null,{"$f":"SUM(S12:S65536)","v":0}]
[4,"ELM5806048F5","EL MERO S.C.L.",null,"IGNACIO L.","MANUEL M. DIEGUEZ",8722,"E/NORMAL Y JUAREZ","LOS OLIVOS","SAN JUAN",null,null,"HIDALGO"]
[5,"USC0608166R5","UNION DE SOC. COOP. PESQ",null,"PEDRO RX","PASEO COSTERO",9012,"Y PASEO ENSENADA",null,"SAN PEDRO",null,null,"NUEVO LEON"]
[6,"PIV921016LB3","PROPULSORA INDUSTRIAL DE V SA",null,"HUGO L. F","BRAVO",8788,null,null,"SAN ANTONIO",null,null,"OAXACA"]
[7]

{"sheet":"PRODUCTOS","index":9,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,5,2,6],[0,1,0,6]]}
[null,{"$f":"REGISTROS!A1","v":"EMPRESA EJEMPLO"}]
[null,"BASE DE DATOS DE PRODUCTOS"]
[null,null,null,null,null,{"$f":"TODAY()","v":"2012-10-16"}]
[null,"REGISTROS:",{"$f":"COUNTA(B6:B65536)","v":5}]
["No.","CÓDIGO","CLASE","DESCRIPCIÓN","TASA                       (0, 10, 15)","UNIDAD DE MEDIDA","PRECIO UNITARIO"]
[1,"A-001","AIRE ACONDICIONADO","MARCA SAMSUNG 24,000 BTU´S",16,"PIEZA",12000]
[2,"A-002","AIRE ACONDICIONADO","MARCA TRANE 3 TONS TIPO MINI SPLIT 220 VOLTS",15,"PIEZA",15000]
[3,"A-003","AIRE ACONDICIONADO","MARCA CARRIER 12,000 BTU DE VENTANA 220 VOLTS",15,"PIEZA",7500]
[4,"B-001","ACCESORIO","GAS REFRIGERANTE ",0,"LITROS",200]
[5,"B-002","ACCESORIO","ESPUMA AISLANTE",10,"METRO CUADRADO",300]

{"sheet":"INDX","index":10,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[{"$f":"'DATOS EMPRESA'!B3","v":"EMPRESA EJEMPLO"}]
["REGISTROS:",{"$f":"COUNTA(A6:A65536)","v":32},null,null,null,null,{"$f":"TODAY()","v":"2012-10-16"}]
[]
["No CTRL","No FACT/NV","POS1","MOVS","POS MOV1","CANCEL","OPER","POS CLIENT","DOCTO","POS CR",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(W12:W65536)","v":0}]
[]
[1,32,6,4,6,null,1,7,"FC",5]
[2,33,7,2,10,null,0,8,"FC"]
[3,34,8,3,12,null,0,7,"FC",null,null,null,{"$f":"SUM(S12:S65536)","v":0},null,null,null,null,{"$f":"SUM(T12:T65536)","v":0},null,{"$f":"SUM(V12:V65536)","v":0},null,{"$f":"SUM(W12:W65536)","v":0}]
[4,35,9,5,15,null,0,7,"FC"]
[5,10,6,3,20,null,1,11,"NV",6]
[6,11,7,2,23,1,1,8,"NV",7]
[7,36,10,0,null,null,1,11,"FC",8]
[8,37,11,2,25,null,1,10,"FC",9]
[9,38,12,2,27,1,1,7,"FC",10]
[10,39,13,2,29,1,1,6,"FC",11]
[11,40,14,2,31,null,0,7,"FC"]
[12,12,9,1,33,null,1,7,"NV",12]
[13,41,15,1,34,null,0,6,"FC"]
[14,42,16,1,35,null,1,7,"FC",13]
[15,43,17,1,36,null,0,7,"FC"]
[16,13,9,1,37,null,1,8,"NV",14]
[17,44,18,1,38,null,1,11,"FC",15]
[18,45,19,1,39,null,1,11,"FC",16]
[19,46,20,1,40,null,1,7,"FC",27]
[20,14,10,2,41,null,0,7,"NV"]
[21,15,11,2,43,null,1,8,"NV",28]
[22,16,12,2,45,null,1,9,"NV",29]
[23,17,13,3,47,null,1,10,"NV",30]
[24,47,21,16,50,null,1,7,"FC",31]
[25,51,22,2,66,null,0,8,"FC"]
[26,52,23,1,68,null,0,7,"FC"]
[27,53,24,1,69,null,0,6,"FC"]
[28,54,25,2,70,null,0,8,"FC"]
[29,55,26,1,72,null,0,11,"FC"]
[30,1003,27,1,73,null,0,10,"FC"]
[31,1004,28,1,74,null,0,8,"FC"]
[32,1005,29,1,75,null,0,9,"FC"]