{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Configuracion","Cotizador","Clientes","Productos","Informaciones"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":9,"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":"Configuracion","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,6,2,9],[4,6,4,7],[5,6,5,7],[6,6,6,7],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[3,6,3,7]]}
[]
[]
[null,null,"FORMAS DE PAGO","FORMAS DE ENTREGA","TIEMPOS DE ENTREGA",null,"CUENTA PARA TRANSFERENCIA"]
[null,null,"Efectivo","Retiro en local","1 dia",null,"Tipo de cuenta",null,"Cuenta corriente"]
[null,null,"Transferencia","Por Transporte","2 dia",null,"Numero",null,2664598752]
[null,null,"Deposito","Por correo","1 semana",null,"Nombre",null,"Mi Empresa Ltda."]
[null,null,"Cheque","Correo Electronico","1 mes",null,"Correo",null,"Miempresa@gmail.com"]

{"sheet":"Cotizador","index":1,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,4,9,5],[5,6,5,10],[6,6,6,10],[7,6,7,10],[8,6,8,10],[9,6,9,10],[20,7,20,10],[13,5,13,6],[13,7,13,8],[13,9,13,10],[15,5,15,6],[15,7,15,8],[15,9,15,10],[16,5,16,6],[16,7,16,8],[16,9,16,10],[18,7,18,10],[20,5,20,6],[18,5,18,6],[22,7,22,10],[24,7,24,10],[26,7,26,10],[26,5,26,6],[24,5,24,6],[22,5,22,6],[39,5,39,8],[28,5,28,8],[29,5,29,8],[30,5,30,8],[31,5,31,8],[32,5,32,8],[33,5,33,8],[34,5,34,8],[35,5,35,8],[36,5,36,8],[37,5,37,8],[38,5,38,8],[46,4,46,5],[40,4,40,5],[40,9,40,10],[41,4,42,8],[41,9,41,10],[42,9,42,10],[9,15,9,17],[11,15,11,17],[31,15,31,18],[32,15,32,18],[33,15,33,18],[35,15,35,18],[36,15,36,18],[37,15,37,18],[38,15,38,18],[40,16,40,17],[41,15,41,18],[42,15,42,18],[44,14,44,19],[47,15,47,18],[48,15,48,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porcentaje IVA",0.19]
[]
[]
[]
[]
[null,null,null,null,null,null,"NOMBRE DE LA EMPRESA AQUÍ LTDA."]
[null,null,null,null,null,null,"Direccion aquí #2675, comuna"]
[null,null,null,null,null,null,"+1 509 123456789"]
[null,null,null,null,null,null,"correaelectronico@ejemplo.com"]
[null,null,null,null,null,null,"www.sitiowebempresa.com",null,null,null,null,null,null,null,null,"INSTRUCCIONES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Para cambiar el logo, haz click derecho              sobre la imagen, elige Cambiar Imagen."]
[]
[null,null,null,null,null,2,null,{"$f":"TODAY()","v":"2020-12-01"},null,{"$f":"NOW()","v":44166.572133449074},null,null,null,null,null,"*Haz click sobre el boton Clientes para"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   llenar los datos de tus clientes"]
[null,null,null,null,null,"FORMA DE PAGO",null,"FORMA DE ENTREGA",null,"TIEMPO DE ENTREGA"]
[null,null,null,null,null,"Transferencia",null,"Por Transporte",null,"1 semana",null,null,null,null,null,"*Haz click sobre el boton Productos"]
[]
[null,null,null,null,null,"CLIENTE",null,"Alejandro Rodriguez ",null,null,null,null,null,null,null,"   para crear tu base de datos de productos"]
[]
[null,null,null,null,null,"CEDULA IDENTIDAD",null,{"$f":"IFERROR(VLOOKUP(nombreDelCliente,tablaClientes,2,0),\"\")","v":"123548547-5"},null,null,null,null,null,null,null,"*Cuando haces click sobre enviar correo"]
[]
[null,null,null,null,null,"DIRECCION",null,{"$f":"IFERROR(VLOOKUP(nombreDelCliente,tablaClientes,3,0),\"\")","v":"San pablo 7687, Santiago"},null,null,null,null,null,null,null,"  enviara una copia PDF de la cotizacion"]
[]
["Configuracion",null,null,null,null,"CORREO",null,{"$f":"IFERROR(VLOOKUP(nombreDelCliente,tablaClientes,4,0),\"\")","v":"alejandrorodriguez@gmail.com"},null,null,null,null,null,null,null,"  al correo del cliente"]
[]
["Ayuda ?",null,null,null,null,"TELEFONO",null,{"$f":"IFERROR(VLOOKUP(nombreDelCliente,tablaClientes,5,0),\"\")","v":"+1 564 87867865"},null,null,null,null,null,null,null,"*Haz click sobre el boton Ayuda para"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   mas instrucciones"]
["Sobre Nosotros",null,null,null,"CODIGO","DESCRIPCION",null,null,null,"CANTIDAD","PRECIO","TOTAL"]
[null,null,null,null,"TAZ-11",{"$f":"IFERROR(VLOOKUP(E30,tablaProductos,3,0),\"\")","v":"Tazon 11 onzas color blanco"},null,null,null,20,500,{"$f":"IFERROR(J30*K30,\"\")","v":10000}]
[null,null,null,null,null,"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(E31,tablaProductos,4,0),\"\")","v":""},{"$f":"IFERROR(J31*K31,\"\")","v":""}]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E34,tablaProductos,3,0),\"\")","v":""},null,null,null,null,"",""]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,"NOTA:",null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(L30:L40)","v":10000},null,null,null,null,"CONTACTOS"]
[null,null,null,null,null,null,null,null,null,"IVA",null,{"$f":"L41*P1","v":1900},null,null,null,"Whats'App +56 9 9492 4535"]
[null,null,null,null,null,null,null,null,null,"TOTAL  A PAGAR",null,{"$f":"SUM(L41:L42)","v":11900},null,null,null,"exceltrucosytips@gmail.com"]
[]
[null,null,null,null,"Cuenta Transferencia:"]
[null,null,null,null,{"$f":"IFERROR(Configuracion!I4,\"\")","v":"Cuenta corriente"}]
[null,null,null,null,{"$f":"IFERROR(Configuracion!I5,\"\")","v":2664598752}]
[null,null,null,null,{"$f":"Configuracion!I6","v":"Mi Empresa Ltda."}]
[null,null,null,null,{"$f":"Configuracion!I7","v":"Miempresa@gmail.com"}]

{"sheet":"Clientes","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Nº","NOMBRE","CEDULA IDENTIDAD","DIRECCION","CORREO","TELEFONO"]
[null,1,"Alejandro Rodriguez ","123548547-5","San pablo 7687, Santiago","alejandrorodriguez@gmail.com","+1 564 87867865"]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]

{"sheet":"Productos","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,10,12,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[17,10,17,13]]}
[]
[]
[]
[null,null,null,"Nº","CODIGO","NOMBRE","DESCRIPCION","PRECIO"]
[null,null,null,1,"TAZ-11","Tazon 11 onzas","Tazon 11 onzas color blanco",500]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7,null,null,null,null,null,null,"SOLO PUEDE INGRESAR 10 PRODUCTOS EN LA VERSION GRATUITA DE ESTA PLANILLA"]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11,null,null,null,null,null,null,"PARA OBTENER LA VERSION FULL O PARA PEDIR"]
[null,null,null,12,null,null,null,null,null,null,"MODIFICACIONES, CONTACTENOS AL"]
[null,null,null,13,null,null,null,null,null,null,"WHATS'APP +56 9 9492 4535"]
[null,null,null,14,null,null,null,null,null,null,"CORREO: EXCELTRUCOSYTIPS@GMAIL.COM"]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]

{"sheet":"Informaciones","index":4,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,6,40,10]]}
[]
[]
[]
[]
[null,null,null,null,"INSTRUCCIONES"]
[]
[]
[null,null,null,null,"-Generar nueva COTIZACION"]
[null,null,null,null,null,"Para generar una nueva orden haz click en el boton Nueva Orden "]
[null,null,null,null,null,"en la barra de menu arriba del formato de cotizaciòn. Al presionar este boton"]
[null,null,null,null,null,"te va generar el numero de cotizacion siguiente y borrar los datos  "]
[null,null,null,null,null,"existentes dejando lista la planilla para ingresar los nuevos datos."]
[]
[null,null,null,null,"-Enviar al correo una cotizacion"]
[null,null,null,null,null,"Para enviar la cotizacion al correo del cliente haz click en el boton"]
[null,null,null,null,null,"Al presionar este boton, la aplicación generara una copia PDF de la cotizacion, "]
[null,null,null,null,null,"y enviara la copia generada como documento adjuntado al correo del cliente."]
[null,null,null,null,null,"esta opción funciona sólo si tienes configurado Outlook en tu computador."]
[null,null,null,null,"-Guardar el archivo en PDF en el PC"]
[null,null,null,null,null,"Para guardar el archivo como PDF en el PC, haz click en el boton "]
[null,null,null,null,null,"Al presionar este boton, te va aparecer una ventana para poder elegir donde"]
[null,null,null,null,null,"quieres guardar el archivo, tienes que elegir una carpeta y presionar OK."]
[]
[null,null,null,null,"-Imprimir el archivo"]
[null,null,null,null,null,"Para imprimir el archivo solo hacer click en el boton "]
[null,null,null,null,null,"Y te imprimira la cotizacion con tu impresora predeterminada."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"S"]
[]
[]
[]
[null,null,null,null,null,"Somos Excel Trucos & Tips"]
[null,null,null,null,null,null,"exceltrucosytips@gmail.com"]