{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FACTURAS","INSTRUCCIONES"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"FACTURAS","index":0,"n_rows":102,"n_cols":16,"rows_kept":102,"cut":false,"hidden":false,"merged":[[101,11,101,12],[0,3,0,13],[69,11,69,12],[73,11,73,12],[65,3,65,4],[70,3,70,4],[74,3,74,4],[79,11,79,12],[80,3,80,4],[84,11,84,12],[85,3,85,4],[89,11,89,12],[90,3,90,4],[95,11,95,12],[94,11,94,12],[96,3,96,4],[35,11,35,12],[13,11,13,13],[17,3,17,4],[21,11,21,12],[15,12,15,13],[15,0,15,3],[13,0,13,7],[13,9,13,10],[22,3,22,4],[0,0,0,2],[23,3,23,4],[28,11,28,12],[34,11,34,12],[11,0,11,2],[11,3,11,13],[12,0,12,2],[12,3,12,10],[12,12,12,13],[63,11,63,12],[59,11,59,12],[64,11,64,12],[40,11,40,12],[36,3,36,4],[41,3,41,4],[47,11,47,12],[51,11,51,12],[53,3,53,4],[52,11,52,12]]}
["ANEXO 5 ",null,null,"SUBVENCIONES CON DESTINO A LA EJECUCIÓN DE PROYECTOS DE COOPERACIÓN AL DESARROLLO O MICROACCIONES ",null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","Forma de pago"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","Contado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","Transferencia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","Cheque"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","Carta de pago"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","otros"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["Proyecto:",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["Entidad beneficiaria:",null,null,null,null,null,null,null,null,null,null,"CIF.:",null,null,"x"]
["Beneficiaria en la convocatoria de subvenciones a proyectos de cooperación al desarrollo/microacciones del año:",null,null,null,null,null,null,null,null,"Nº EXPEDIENTE",null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["A.   COSTES DIRECTOS",null,null,null,null,null,null,null,"TASA DE CAMBIO APLICADA:  1 EURO=",null,null,10,0,null,"x"]
["Nº de orden","Nº Part","Proveedor/emisor","Nº de documento","Concepto de gasto","Fecha de expedición","Fecha de pago","Medio acreditado del pago","Moneda Local","Otra Moneda","Euros","Financiador . Primero AACD","% imputado","Cantidad imputada","x"]
[null,null,"A.I","Identificación y formulación",null,null,null,null,null,null,null,null,null,null,"x"]
[1,"A.I",null,null,null,null,null,null,null,null,{"$f":"I19/$L$16","v":0},null,null,{"$f":"K19*$M19","v":0},"x"]
[2,"A.I",null,null,null,null,null,null,null,null,{"$f":"I20/$L$16","v":0},null,null,{"$f":"K20*$M20","v":0}]
[3,"A.I",null,null," ",null,null,null,null,null,{"$f":"I21/$L$16","v":0},null,null,{"$f":"K21*$M21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N19:N21)","v":0},"x"]
[null,null,"A.II","Terrenos y/o inmuebles",null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,"A.II.I","Alquiler de vivienda de expatriado",null,null,null,null,null,null,null,null,null,null,"x"]
[4,"A.II.I",null,null,null,null,null,null,null,null,{"$f":"I25/$L$16","v":0},null,null,{"$f":"K25*$M25","v":0},"x"]
[5,"A.II.I",null,null,null,null,null,null,null,null,{"$f":"I26/$L$16","v":0},null,null,{"$f":"K26*$M26","v":0}]
[6,"A.II.I",null,null,null,null,null,null,null,null,{"$f":"I27/$L$16","v":0},null,null,{"$f":"K27*$M27","v":0}]
[7,"A.II.I",null,null,null,null,null,null,null,null,{"$f":"I28/$L$16","v":0},null,null,{"$f":"K28*$M28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N25:N28)","v":0},"x"]
[null,null,"A.II.II","Terrenos/inmuebles",null,null,null,null,null,null,null,null,null,null,"x"]
[8,"A.II.II",null,null,null,null,null,null,null,null,{"$f":"I31/$L$16","v":0},null,null,{"$f":"K31*$M31","v":0},"x"]
[9,"A.II.II",null,null,null,null,null,null,null,null,{"$f":"I32/$L$16","v":0},null,null,{"$f":"K32*$M32","v":0}]
[null,"A.II.II",null,null,null,null,null,null,null,null,{"$f":"I33/$L$16","v":0},null,null,{"$f":"K33*$M33","v":0}]
[null,"A.II.II",null,null,null,null,null,null,null,null,{"$f":"I34/$L$16","v":0},null,null,{"$f":"K34*$M34","v":0}]
[null,null,null,"SUBTOTAL",null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N31:N34)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"N29+N35","v":0},"x"]
[null,null,"A.III","Construcciones",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A,III",null,null,null,null,null,null,null,null,{"$f":"I38/$L$16","v":0},null,null,{"$f":"K38*$M38","v":0},"x"]
[null,"A,III",null,null,null,null,null,null,null,null,{"$f":"I39/$L$16","v":0},null,null,{"$f":"K39*$M39","v":0}]
[null,"A,III",null,null,null,null,null,null,null,null,{"$f":"I40/$L$16","v":0},null,null,{"$f":"K40*$M40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N38:N40)","v":0},"x"]
[null,null,"A.IV","Equipos, materiales y suministros",null,null,null,null,null," ",null,null,null,null,"x"]
[null,null,"A.IV.I","Equipos",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.IV.I",null,null,null,null,null,null,null,null,{"$f":"I44/$L$16","v":0},null,null,{"$f":"K44*$M44","v":0},"x"]
[null,"A.IV.I",null,null,null,null,null,null,null,null,{"$f":"I45/$L$16","v":0},null,null,{"$f":"K45*$M45","v":0}]
[null,"A.IV.I",null,null,null,null,null,null,null,null,{"$f":"I46/$L$16","v":0},null,null,{"$f":"K46*$M46","v":0}]
[null,"A.IV.I",null,null,null,null,null,null,null,null,{"$f":"I47/$L$16","v":0},null,null,{"$f":"K47*$M47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N44:N47)","v":0},"x"]
[null,null,"A.IV.II","Materiales y sumunistros",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.IV.II",null,null,null,null,null,null,null,null,{"$f":"I50/$L$16","v":0},null,null,{"$f":"K50*$M50","v":0},"x"]
[null,"A.IV.II",null,null,null,null,null,null,null,null,{"$f":"I51/$L$16","v":0},null,null,{"$f":"K51*$M51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N50:N51)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"N48+N52","v":0},"x"]
[null,null,"A.V","Personal",null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,"A.V.I","Personal Local",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.V.I",null,null,null,null,null,null,null,null,{"$f":"I56/$L$16","v":0},null,null,{"$f":"K56*$M56","v":0},"x"]
[null,"A.V.I",null,null,null,null,null,null,null,null,{"$f":"I57/$L$16","v":0},null,null,{"$f":"K57*$M57","v":0},"x"]
[null,"A.V.I",null,null,null,null,null,null,null,null,{"$f":"I58/$L$16","v":0},null,null,{"$f":"K58*$M58","v":0}]
[null,"A.V.I",null,null,null,null,null,null,null,null,{"$f":"I59/$L$16","v":0},null,null,{"$f":"K59*$M59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N56:N59)","v":0},"x"]
[null,null,"A.V.IÎ","Personal Expatriado",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.V.IÎ",null,null,null,null,null,null,null,null,{"$f":"I62/$L$16","v":0},null,null,{"$f":"K62*$M62","v":0},"x"]
[null,"A.V.IÎ",null,null,null,null,null,null,null,null,{"$f":"I63/$L$16","v":0},null,null,{"$f":"K63*$M63","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N62:N63)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"N60+N64","v":0},"x"]
[null,null,"A.VI","Viajes, alojamientos y dietas",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.VI",null,null,null,null,null,null,null,null,{"$f":"I67/$L$16","v":0},null,null,{"$f":"K67*$M67","v":0},"x"]
[null,"A.VI",null,null,null,null,null,null,null,null,{"$f":"I68/$L$16","v":0},null,null,{"$f":"K68*$M68","v":0}]
[null,"A.VI",null,null,null,null,null,null,null,null,{"$f":"I69/$L$16","v":0},null,null,{"$f":"K69*$M69","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N67:N69)","v":0},"x"]
[null,null,"A.VII","Servicios técnicos y profesionales",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.VII",null,null,null,null,null,null,null,null,{"$f":"I72/$L$16","v":0},null,null,{"$f":"K72*$M72","v":0}]
[null,"A.VII",null,null,null,null,null,null,null,null,{"$f":"I73/$L$16","v":0},null,null,{"$f":"K73*$M73","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N72:N73)","v":0},"x"]
[null,null,"A.VIII","Funcionamiento",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.VIII",null,null,null,null,null,null,null,null,{"$f":"I76/$L$16","v":0},null,null,{"$f":"K76*$M76","v":0},"x"]
[null,"A.VIII",null,null,null,null,null,null,null,null,{"$f":"I77/$L$16","v":0},null,null,{"$f":"K77*$M77","v":0}]
[null,"A.VIII",null,null,null,null,null,null,null,null,{"$f":"I78/$L$16","v":0},null,null,{"$f":"K78*$M78","v":0}]
[null,"A.VIII",null,null,null,null,null,null,null,null,{"$f":"I79/$L$16","v":0},null,null,{"$f":"K79*$M79","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N76:N79)","v":0},"x"]
[null,null,"A.IX","Evaluación  externa",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.IX",null,null,null,null,null,null,null,null,{"$f":"I82/$L$16","v":0},null,null,{"$f":"K82*$M82","v":0},"x"]
[null,"A.IX",null,null,null,null,null,null,null,null,{"$f":"I83/$L$16","v":0},null,null,{"$f":"K83*$M83","v":0}]
[null,"A.IX",null,null,null,null,null,null,null,null,{"$f":"I84/$L$16","v":0},null,null,{"$f":"K84*$M84","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N82:N84)","v":0},"x"]
[null,null,"A.X","Sensibilización en Asturias",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K87*$M87","v":0},"x"]
[null,"A.X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K88*$M88","v":0}]
[null,"A.X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K89*$M89","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N87:N89)","v":0},"x"]
[null,null,"A.XI","Otros",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.XI",null,null,null,null,null,null,null,null,{"$f":"I92/$L$16","v":0},null,null,{"$f":"K92*$M92","v":0},"x"]
[null,"A.XI",null,null,null,null,null,null,null,null,{"$f":"I93/$L$16","v":0},null,null,{"$f":"K93*$M93","v":0}]
[null,"A.XI",null,null,null,null,null,null,null,null,{"$f":"I94/$L$16","v":0},null,null,{"$f":"K94*$M94","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N92:N94)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDAS",null,{"$f":"SUM(N22,N36,N41,N53,N65,N70,N74,N80,N85,N90,N95)","v":0},"x"]
[null,null,null,"Auditoría contable",null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I98/$L$16","v":0},null,null,{"$f":"K98*$M98","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I99/$L$16","v":0},null,null,{"$f":"K99*$M99","v":0}]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N98:N99)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL CON AUDITORÍA CONTABLE",null,{"$f":"SUM(N96,N100)","v":0},"x"]

{"sheet":"INSTRUCCIONES","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["INSTRUCCIONES BÁSICAS"]
[]
["Se rellenan los campos de cada factura. Algunos tienen desplegable para elegir opción."]
["Se numeraran las facturas y se pondrá el mismo número en cada una de las facturas físicas."]
["En el campo \"financiador\" si es la Agencia Asturiana de Cooperación, poner AACD"]
["En el caso de que existan dos o mas financiadores, se repetirá la fila, tantas veces como financiadores haya, manteniendo el mismo número de factura."]
["En el apartado de tasa de cambio, está prevista la posibilidad de tener dos monedas además del euro. En ese caso hay que cambiar la fórmula de la columna k, en las filas en las que se necesite incluir otra tasa de cambio."]
["Para añadir filas, se puede insertar una fila y copiar la anterior, o bien situarse en una fila del medio y darle al botón que está en la parte superior derecha \"FILA\"."]
["Al copiar o añadir fila, la copia entera, por lo que hay que cambiar el número de factura y los datos que se hubiesen rellenado con anterioridad."]
["En el caso de que no permita usar ese botón, es necesario habilitar macros: para ello hay que ir a la pestaña ARCHIVO, OPCIONES, CENTRO DE CONFIANZA, CONFIGURACIÓN CENTRO DE CONFIANZA, CONFIGURACIÓN DE MACROS y o bien, DESHABILITAR MARCROS CON NOTIFICACIÓN o HABILITAR TODOS LOS MACROS."]