{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["MEN","FAC","FMOD","LFAC","TFAC","EST","CALCULO2","AYUDA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"MEN","index":0,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"INSTRUCCIONES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Fra. Inicial"]

{"sheet":"FAC","index":1,"n_rows":45,"n_cols":36,"rows_kept":45,"cut":false,"hidden":false,"merged":[[55,2,55,3],[55,4,55,9],[51,2,51,3],[51,4,51,9],[53,2,53,3],[53,4,53,9],[18,3,18,7],[19,3,19,7],[11,3,11,7],[10,3,10,7],[4,7,4,10],[16,3,16,7],[5,7,6,10],[4,2,4,5],[0,2,0,5],[1,2,1,5],[2,2,2,5],[3,2,3,5],[41,8,41,9],[38,3,38,7],[39,3,39,7],[36,3,36,7],[37,3,37,7],[34,3,34,7],[35,3,35,7],[32,3,32,7],[33,3,33,7],[30,3,30,7],[31,3,31,7],[28,3,28,7],[44,8,44,9],[0,7,0,10],[1,7,1,10],[2,7,2,10],[3,7,3,10],[29,3,29,7],[26,3,26,7],[27,3,27,7],[24,3,24,7],[25,3,25,7],[22,3,22,7],[23,3,23,7],[17,3,17,7],[15,3,15,7],[20,3,20,7],[21,3,21,7]]}
["MENU",null,null,null,null,null,null,"EMPRESA"]
[null,null,null,null,null,null,null,"DIRECCION"]
[null,null,null,null,null,null,null,"CP Y LOCALIDAD"]
[null,null,null,null,null,null,null,"PROVINCIA"]
[null,null,null,null,null,null,null,"NIF  O CIF"]
[null,null,null,null,null,null,null,"TELEFONO  999 999 999"]
[]
[]
[]
[null,null,"Cliente"]
[null,null,"Nombre",null,null,null,null,null,null,"Fecha",null,null,null,"Última factura"]
[null,null,"Dirección",null,null,null,null,null,null,"Factura",{"$f":"N12+1","v":1}]
[null,null,"Ciudad",null,"Provincia",null,"CP",null,null,null,null,null,null,{"$f":"MAX(TFAC!G2:G28)","v":"00:00:00"}]
[null,null,"CIF - NIF"]
[]
[null,null,"Albarán-Fecha","Trabajo",null,null,null,null,"Cantidad","Precio","TOTAL",null,null,null,null,null,null,"factura","fecha","trabajo","unidades","precio",null,"nombre","direccion","poblacion","provincia","cp","cif","fecha","factura","tipo iva","bruto","iva","total","estado"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I17*J17","v":0},null,null,null,null,null,null,{"$f":"$K$12","v":1},{"$f":"C17","v":0},{"$f":"D17","v":0},{"$f":"I17","v":0},{"$f":"J17","v":0},null,{"$f":"$D$11","v":0},{"$f":"$D$12","v":0},{"$f":"$D$13","v":0},{"$f":"$F$13","v":0},{"$f":"$H$13","v":0},{"$f":"$D$14","v":0},{"$f":"$K$11","v":0},{"$f":"$K$12","v":1},{"$f":"$J$43","v":0},{"$f":"K42","v":0},{"$f":"K43","v":0},{"$f":"K45","v":0},"Pendiente"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I18*J18","v":0},null,null,null,null,null,null,1,{"$f":"C18","v":0},{"$f":"D18","v":0},{"$f":"I18","v":0},{"$f":"J18","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I20*J20","v":0},null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,"Total bruto",null,{"$f":"SUM(K17:K40)","v":0}]
[null,null,null,null,null,null,null,null,"IVA",null,{"$f":"K42*J43","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total factura",null,{"$f":"SUM(K42:K43)","v":0}]

{"sheet":"FMOD","index":2,"n_rows":101,"n_cols":36,"rows_kept":101,"cut":false,"hidden":false,"merged":[[19,3,19,7],[4,2,4,5],[44,8,44,9],[38,3,38,7],[39,3,39,7],[36,3,36,7],[28,3,28,7],[3,12,3,13],[4,12,4,13],[51,4,51,9],[53,4,53,9],[41,8,41,9],[29,3,29,7],[37,3,37,7],[34,3,34,7],[35,3,35,7],[32,3,32,7],[33,3,33,7],[22,3,22,7],[23,3,23,7],[17,3,17,7],[15,3,15,7],[20,3,20,7],[99,3,99,7],[11,3,11,7],[10,3,10,7],[26,3,26,7],[27,3,27,7],[24,3,24,7],[25,3,25,7],[30,3,30,7],[31,3,31,7],[16,3,16,7],[55,4,55,9],[51,2,51,3],[53,2,53,3],[55,2,55,3],[21,3,21,7],[18,3,18,7],[0,2,0,5],[1,2,1,5],[2,2,2,5],[3,2,3,5],[5,7,6,10],[4,7,4,10],[0,7,0,10],[1,7,1,10],[2,7,2,10],[3,7,3,10]]}
["MENU",null,null,null,null,null,null,{"$f":"FAC!H1","v":"EMPRESA"},null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,{"$f":"FAC!H2","v":"DIRECCION"}]
[null,null,null,null,null,null,null,{"$f":"FAC!H3","v":"CP Y LOCALIDAD"}]
[null,null,"inserte logo aquí",null,null,null,null,{"$f":"FAC!H4","v":"PROVINCIA"},null,null,null,null,"ESTADO"]
[null,null,null,null,null,null,null,{"$f":"FAC!H5","v":"NIF  O CIF"}]
[null,null,null,null,null,null,null,{"$f":"FAC!H6","v":"TELEFONO  999 999 999"}]
[]
[]
[]
[null,null,"Cliente"]
[null,null,"Nombre",null,null,null,null,null,null,"Fecha"]
[null,null,"Dirección",{"$f":"Y101","v":0},null,null,null,null,null,"Factura"]
[null,null,"Ciudad",{"$f":"Z101","v":0},"Provincia",{"$f":"AA101","v":0},"CP",{"$f":"AB101","v":0}]
[null,null,"CIF - NIF",{"$f":"AC101","v":0}]
[]
[null,null,{"$f":"FAC!C16","v":"Albarán-Fecha"},{"$f":"FAC!D16","v":"Trabajo"},null,null,null,null,{"$f":"FAC!I16","v":"Cantidad"},{"$f":"FAC!J16","v":"Precio"},"TOTAL",null,null,null,null,null,null,"factura","fecha-albaran","trabajo","unidades","precio",null,"nombre","direccion","poblacion","provincia","cp","cif","fecha","factura","tipo iva","bruto","iva","total","estado"]
[null,null,{"$f":"S101","v":0},null,null,null,null,null,null,null,{"$f":"I17*J17","v":0},null,null,null,null,null,null,{"$f":"$K$12","v":0},{"$f":"C17","v":0},{"$f":"D17","v":0},{"$f":"I17","v":0},{"$f":"J17","v":0},null,{"$f":"$D$11","v":0},{"$f":"$D$12","v":0},{"$f":"$D$13","v":0},{"$f":"$F$13","v":0},{"$f":"$H$13","v":0},{"$f":"$D$14","v":0},{"$f":"$K$11","v":0},{"$f":"$K$12","v":0},{"$f":"$J$43","v":7.0000000000000007E-2},{"$f":"K42","v":0},{"$f":"K43","v":0},{"$f":"K45","v":0},{"$f":"$M$5","v":0}]
[null,null,0,{"$f":"T102","v":0},null,null,null,null,{"$f":"U102","v":0},{"$f":"V102","v":0},0,null,null,null,null,null,null,0,{"$f":"C18","v":0},{"$f":"D18","v":0},{"$f":"I18","v":0},{"$f":"J18","v":0}]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,{"$f":"C19","v":0},0,{"$f":"I19","v":0},0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[null,null,0,0,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,"Total bruto",null,{"$f":"SUM(K17:K40)","v":0}]
[null,null,null,null,null,null,null,null,"IVA",7.0000000000000007E-2,{"$f":"K42*J43","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total factura",null,{"$f":"SUM(K42:K43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"S184","v":0},{"$f":"T184","v":0},null,null,null,null,{"$f":"U184","v":0},{"$f":"V184","v":0},null,null,null,null,null,null,null,"factura","fecha","trabajo","unidades","precio",null,"nombre","direccion","poblacion","provincia","cp","cif","fecha","factura","tipo iva","bruto","iva","total","estado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,"OYUFYFUGY",11,11,null,"KKKK",0,0,0,0,0,39456,1,7.0000000000000007E-2,121,8.4700000000000006,129.47,"Pendiente"]

{"sheet":"LFAC","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N' FACTURA",{"$f":"FAC!C16","v":"Albarán-Fecha"},{"$f":"FAC!D16","v":"Trabajo"},{"$f":"FAC!I16","v":"Cantidad"},{"$f":"FAC!J16","v":"Precio"}]

{"sheet":"TFAC","index":4,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["CLIENTE","direccion","poblacion","provincia","cp","cif","FECHA","N' FAC.","tipo IVA","bruto","iva","TOTAL","ESTADO"]

{"sheet":"EST","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,8],[15,2,17,6]]}
["MENU","CONSULTAS-ESTADISTICA"]
[]
[]
[]
[]
[]
[null,"IVA INGRESADO",null,"DESDE",null,"HASTA"]
[]
[null,"TOTAL FACTURADO",null,"DESDE",null,"HASTA"]
[]
[null,"PENDIENTE DE COBRO"]
[]
[]
[]
[]
[null,null,"ESPERE, CALCULANDO …"]

{"sheet":"CALCULO2","index":6,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["MENU"]
["ESTADISTICA","PENDIENTE DE COBRO"]
[]
[]
[]
[]
[]
[null,"CLIENTE","DIRECCION","POBLACION","PROVINCIA","CP","CIF","FECHA","N' FAC.","TIPO IVA","BRUTO","IVA","TOTAL","ESTADO"]
[]
[null,null,null,null,null,null,null,null,null,null,0,0,0]

{"sheet":"AYUDA","index":7,"n_rows":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["MENU","www.jesusferrer.es"]
[]
[null,"Este libro le ayudará a guardar sus facturas y poderlas recuperar si es necesario"]
[null,"para volver a imprimirlas o rectificarlas."]
[]
[null,"Es una aplicación para alguien que haga muy pocas facturas ya que todas las líneas"]
[null,"de factura deben introducirse a mano."]
[]
[null,"En el menú nos encontramos tres apartados :"]
[]
[null,"CREAR FACTURA"]
["-","En esta hoja podremos hacer, imprimir y guardar todas las facturas que generamos."]
[null,"Podremos configurar algunas cabeceras del albarán (como Trabajo, Cantidad …)"]
[null,"pero no es conveniente añadir o suprimir filas o columnas si no sabes como hacerlo."]
[null,"Esto podría hacer que el libro no funcionara bien."]
["-","Hay tres apartados imprescindibles para que el libro nos deje anotar la factura,"]
[null,"Nombre de cliente, Fecha y nº Factura. Si alguno de ellos está vacío, no podremos"]
[null,"guardar la factura."]
["-","Para que una línea de factura se anote, es necesario que haya algún contenido en la"]
[null,"columna Trabajo."]
["-","A la derecha, veremos un cuadro amarillo que nos mostrará el último número de factura"]
[null,"guardado y la fecha de la misma. No nos dejará anotar si el número de factura que"]
[null,"pongamos no es el siguiente al mostrado. La fecha tampoco puede ser menor a la indicada."]
["-","Una vez terminada, la podemos guardar con solo pulsar el botón Guardar factura."]
[null,"La plantilla quedará limpia para el próximo uso."]
[]
[null,"MODIFICAR-CONSULTAR FACTURA"]
[null,"La estructura de esta hoja es igual a la anterior con unas pequeñas diferencias."]
["-","Desde este apartado podremos recuperar facturas anteriores y modificarlas o imprimirlas"]
[null,"de nuevo. Para ello pondremos el número de factura buscado en la celda correspondiente"]
[null,"y pulsaremos el botón pequelo que hay a la derecha Buscar. Entonces aparecerán los"]
[null,"datos correspondientes a la factura. Si nos hubiéramos equivocado y el número no existiera,"]
[null,"nos lo daría a saber."]
["-","Cuando creamos una factura por primera vez, el archivo la guarda como Pendiente de cobro"]
[null,"Aquí podremos modificar ese dato y poner que está pagada en la celda arriba a la derecha"]
[null,"que pone ESTADO. Esto solo influye en las estadísticas de pendientes de cobro."]
["-","Una vez que hayamos terminado, es imprescindible volver a GUARDAR desde el botón"]
[null,"Guardar factura que hay en la hoja."]
[]
[null,"ESTADISTICAS"]
[null,"En las estadísticas podremos pedir tres tipos de informe, "]
["-","IVA INGRESADO, que podemos definir la búsqueda desde una fecha de inicio hasta otra de fin."]
["-","TOTAL FACTURADO, entre dos fechas que nosotros definimos, como el anterior."]
["-","PENDIENTE DE COBRO, las facturas que nos deben."]
[]
["-","Cuando nos muestre el resumen, veremos que la hija contiene dos botones con flechas a derecha"]
[null,"e izquierda que solo sirve para mostrar más datos de los clientes o no.El formatos de impresión"]
[null,"cambia con estas flechas y queda preparado para como se vea la hoja."]
[]
[]
[null,"Coloque su logotipo y sus datos en la hoja CREAR FACTURA y MODIFICAR FACTURA para"]
[null,"personalizarla a su gusto. Para ello desproteja la hoja desde HERRAMIENTAS>PROTEGER"]
[]
[null,"DEFINA EL NUMERO DE INICIO DE FACTURA EN LA PAGINA MENU. SOLO PUEDE HACERLO"]
[null,"ANTES DE  COMENZAR A INTRODUCIR DATOS DE FACTURAS. SI NO LO HACE, COMENZARÁ EN 1."]
[]
[]
[]
[null,"http://www.jesusferrer.es"]
[null,"SE PUEDE DISTRIBUIR LIBREMENTE PERO TENGA CUIDADO CON LAS MACROS SI"]
[null,"DESCARGA EL ARCHIVO DE UN SITIO QUE NO SEA DE CONFIANZA."]