{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FACTURAS","INSTRUCCIONES"],"not_rendered":{"charts":0,"images":1,"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":104,"n_cols":15,"rows_kept":104,"cut":false,"hidden":false,"merged":[[82,11,82,12],[98,3,98,4],[102,11,102,12],[77,11,77,12],[73,3,73,4],[78,3,78,4],[86,11,86,12],[88,3,88,4],[92,11,92,12],[93,3,93,4],[87,11,87,12],[46,11,46,12],[50,11,50,12],[52,3,52,4],[51,11,51,12],[71,11,71,12],[58,11,58,12],[63,11,63,12],[103,11,103,12],[97,11,97,12],[34,11,34,12],[12,11,12,13],[16,3,16,4],[20,11,20,12],[14,12,14,13],[14,0,14,3],[12,0,12,7],[12,9,12,10],[21,3,21,4],[67,11,67,12],[72,11,72,12],[39,11,39,12],[40,3,40,4],[35,3,35,6],[3,4,5,11],[8,0,8,13],[22,3,22,4],[27,11,27,12],[33,11,33,12],[10,0,10,2],[10,3,10,13],[11,0,11,2],[11,3,11,10],[11,12,11,13],[28,3,28,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AYUD0166T01","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,"ANEXO VI","x"]
[null,null,null,null,"SUBVENCIONES CON DESTINO A LA EJECUCIÓN DE PROYECTOS DE COOPERACIÓN AL DESARROLLO",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"]
[]
[]
["REGISTRO DE FACTURAS IMPUTABLES A PROYECTO DE COOPERACIÓN AL DESARROLLO O MICRO PROYECTO",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 / Micro 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 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","Forma de 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":"I18/$L$15","v":0},null,null,{"$f":"K18*$M18","v":0},"x"]
[2,"A.I",null,null,null,null,null,null,null,null,{"$f":"I19/$L$15","v":0},null,null,{"$f":"K19*$M19","v":0}]
[3,"A.I",null,null," ",null,null,null,null,null,{"$f":"I20/$L$15","v":0},null,null,{"$f":"K20*$M20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N18:N20)","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":"I24/$L$15","v":0},null,null,{"$f":"K24*$M24","v":0},"x"]
[5,"A.II.I",null,null,null,null,null,null,null,null,{"$f":"I25/$L$15","v":0},null,null,{"$f":"K25*$M25","v":0}]
[6,"A.II.I",null,null,null,null,null,null,null,null,{"$f":"I26/$L$15","v":0},null,null,{"$f":"K26*$M26","v":0}]
[7,"A.II.I",null,null,null,null,null,null,null,null,{"$f":"I27/$L$15","v":0},null,null,{"$f":"K27*$M27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N24:N27)","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":"I30/$L$15","v":0},null,null,{"$f":"K30*$M30","v":0},"x"]
[9,"A.II.II",null,null,null,null,null,null,null,null,{"$f":"I31/$L$15","v":0},null,null,{"$f":"K31*$M31","v":0}]
[null,"A.II.II",null,null,null,null,null,null,null,null,{"$f":"I32/$L$15","v":0},null,null,{"$f":"K32*$M32","v":0}]
[null,"A.II.II",null,null,null,null,null,null,null,null,{"$f":"I33/$L$15","v":0},null,null,{"$f":"K33*$M33","v":0}]
[null,null,null,"SUBTOTAL",null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N30:N33)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"N28+N34","v":0},"x"]
[null,null,"A.III","Construcciones y/o reforma de inmuebles e infraestructuras",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A,III",null,null,null,null,null,null,null,null,{"$f":"I37/$L$15","v":0},null,null,{"$f":"K37*$M37","v":0},"x"]
[null,"A,III",null,null,null,null,null,null,null,null,{"$f":"I38/$L$15","v":0},null,null,{"$f":"K38*$M38","v":0}]
[null,"A,III",null,null,null,null,null,null,null,null,{"$f":"I39/$L$15","v":0},null,null,{"$f":"K39*$M39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N37:N39)","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":"I43/$L$15","v":0},null,null,{"$f":"K43*$M43","v":0},"x"]
[null,"A.IV.I",null,null,null,null,null,null,null,null,{"$f":"I44/$L$15","v":0},null,null,{"$f":"K44*$M44","v":0}]
[null,"A.IV.I",null,null,null,null,null,null,null,null,{"$f":"I45/$L$15","v":0},null,null,{"$f":"K45*$M45","v":0}]
[null,"A.IV.I",null,null,null,null,null,null,null,null,{"$f":"I46/$L$15","v":0},null,null,{"$f":"K46*$M46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N43:N46)","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":"I49/$L$15","v":0},null,null,{"$f":"K49*$M49","v":0},"x"]
[null,"A.IV.II",null,null,null,null,null,null,null,null,{"$f":"I50/$L$15","v":0},null,null,{"$f":"K50*$M50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N49:N50)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"N47+N51","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 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":"I55/$L$15","v":0},null,null,{"$f":"K55*$M55","v":0},"x"]
[null,"A.V.I",null,null,null,null,null,null,null,null,{"$f":"I56/$L$15","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$15","v":0},null,null,{"$f":"K57*$M57","v":0}]
[null,"A.V.I",null,null,null,null,null,null,null,null,{"$f":"I58/$L$15","v":0},null,null,{"$f":"K58*$M58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N55:N58)","v":0},"x"]
[null,null,"A.V.II","Personal local",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.V.II",null,null,null,null,null,null,null,null,{"$f":"I61/$L$15","v":0},null,null,{"$f":"K61*$M61","v":0},"x"]
[null,"A.V.II",null,null,null,null,null,null,null,null,{"$f":"I62/$L$15","v":0},null,null,{"$f":"K62*$M62","v":0},"x"]
[null,"A.V.II",null,null,null,null,null,null,null,null,{"$f":"I63/$L$15","v":0},null,null,{"$f":"K63*$M63","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N61:N63)","v":0},"x"]
[null,null,"A.V.III","Personal en sede en Asturias",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.V.III",null,null,null,null,null,null,null,null,{"$f":"I66/$L$15","v":0},null,null,{"$f":"K66*$M66","v":0},"x"]
[null,"A.V.III",null,null,null,null,null,null,null,null,{"$f":"I67/$L$15","v":0},null,null,{"$f":"K67*$M67","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N66:N67)","v":0},"x"]
[null,null,"A.V.IV ","Servicios técnicos y profesionales",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.V.IV ",null,null,null,null,null,null,null,null,{"$f":"I70/$L$15","v":0},null,null,{"$f":"K70*$M70","v":0},"x"]
[null,"A.V.IV ",null,null,null,null,null,null,null,null,{"$f":"I71/$L$15","v":0},null,null,{"$f":"K71*$M71","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N70:N71)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N59,N64,N68,N72)","v":0},"x"]
[null,null,"A.VI","Viajes, estancias 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":"I75/$L$15","v":0},null,null,{"$f":"K75*$M75","v":0},"x"]
[null,"A.VI",null,null,null,null,null,null,null,null,{"$f":"I76/$L$15","v":0},null,null,{"$f":"K76*$M76","v":0}]
[null,"A.VI",null,null,null,null,null,null,null,null,{"$f":"I77/$L$15","v":0},null,null,{"$f":"K77*$M77","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N75:N77)","v":0},"x"]
[null,null,"A.VII","Gastos de evalución y auditoría",null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,"A.VII.I","Evaluación final",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.VII.I",null,null,null,null,null,null,null,null,{"$f":"I81/$L$15","v":0},null,null,{"$f":"K81*$M81","v":0},"x"]
[null,"A.VII.I",null,null,null,null,null,null,null,null,{"$f":"I82/$L$15","v":0},null,null,{"$f":"K82*$M82","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N81:N82)","v":0},"x"]
[null,null,"A.VII.II","Auditoría",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.VII.II",null,null,null,null,null,null,null,null,{"$f":"I85/$L$15","v":0},null,null,{"$f":"K85*$M85","v":0},"x"]
[null,"A.VII.II",null,null,null,null,null,null,null,null,{"$f":"I86/$L$15","v":0},null,null,{"$f":"K86*$M86","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL",null,{"$f":"SUM(N85:N86)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N83:N87)","v":0},"x"]
[null,null,"A.VIII","Sensibilización en Asturias",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.VIII",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K90*$M90","v":0},"x"]
[null,"A.VIII",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K91*$M91","v":0}]
[null,"A.VIII",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K92*$M92","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N90:N92)","v":0},"x"]
[null,null,"A.IX","Funcionamiento",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.IX",null,null,null,null,null,null,null,null,{"$f":"I95/$L$15","v":0},null,null,{"$f":"K95*$M95","v":0},"x"]
[null,"A.IX",null,null,null,null,null,null,null,null,{"$f":"I96/$L$15","v":0},null,null,{"$f":"K96*$M96","v":0}]
[null,"A.IX",null,null,null,null,null,null,null,null,{"$f":"I97/$L$15","v":0},null,null,{"$f":"K97*$M97","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N95:N97)","v":0},"x"]
[null,null,"A.X","Otros",null,null,null,null,null,null,null,null,null,null,"x"]
[null,"A.X",null,null,null,null,null,null,null,null,{"$f":"I100/$L$15","v":0},null,null,{"$f":"K100*$M100","v":0},"x"]
[null,"A.X",null,null,null,null,null,null,null,null,{"$f":"I101/$L$15","v":0},null,null,{"$f":"K101*$M101","v":0}]
[null,"A.X",null,null,null,null,null,null,null,null,{"$f":"I102/$L$15","v":0},null,null,{"$f":"K102*$M102","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDA",null,{"$f":"SUM(N100:N102)","v":0},"x"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PARTIDAS",null,{"$f":"SUM(N103,N21,N35,N40,N52,N73,N78,N88,N93,N98)","v":0},"x"]

{"sheet":"INSTRUCCIONES","index":1,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["INSTRUCCIONES BÁSICAS"]
[]
["1. Registro de las facturas"]
["Cada línea corresponde a una factura o documento equivalente de gasto."]
["Deben completarse todos los campos que figuran en el formulario."]
[]
["2. Numeración de las facturas"]
["Asigne un número correlativo a cada factura registrada."]
["Ese mismo número deberá figurar en la factura física o digital."]
[]
["3. Indicación del financiador"]
["Si el gasto se imputa a la Agencia Asturiana de Cooperación (AACD), escribir AACD en la columna correspondiente."]
["Si un gasto se financia con varios financiadores, deberá duplicar la fila tantas veces como financiadores tenga el gasto, manteniendo el mismo número de factura en todas ellas y cambiando únicamente el financiador y el porcentaje imputado."]
[]
["4. Tasa de cambio"]
["El formulario permite registrar gastos en moneda local, en otra moneda adicional y en euros."]
["La columna de tasa de cambio está configurada para dos monedas además del euro."]
["Si necesita introducir una tasa diferente, deberá modificar la fórmula de la columna K únicamente en las filas donde sea necesario."]
[]
["5. Copiar o añadir filas"]
["Al copiar una fila, se copian también sus contenidos y fórmulas."]
["Por ello, deberá actualizar el número de factura y el resto de los campos para evitar duplicados o datos incorrectos."]
[]
["6. Formas de pago"]
["Las formas de acreditación aceptadas son:"]
["Contado"]
["Ttransferencia"]
["Cheque"]
["Carta de pago"]
["Otros"]