{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DATOS FISCALES","130","CALCULOS","Acerca de"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":3,"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 FISCALES","index":0,"n_rows":271,"n_cols":9,"rows_kept":271,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NIF","34999999W","Para calcular la casilla 13 del Modelo 130"]
[null,"Nombre o Razón Social",null,"(es decir, la deducción del artículo 10.3 c) del Reglamento del IRPF)"]
[null,"Nombre","NOMBRE","Se calcula según los rendimientos netos del ejercicio anterior"]
[null,"Primer Apellido","APELLIDOA","Este importe lo obtenemos:"]
[null,"Segundo Apellido","APELLIDOB"," - De la casilla 03 del Modelo 130 del último trimestre del año anterior"]
[null,"IBAN de la cuenta bancaria","ES9999999999999999999999"," - O bien, de la casilla 118 de la declaración anual de IRPF (Modelo 100)"]
[null,"DEL AÑO ANTERIOR: Casilla [03] del último trimestre del Modelo 130 (o bien la suma de las casillas [118] de la declaración anual de IRPF",9000,"<<<<<<<<<<<<<<<< escribir aquí este importe"]
[null,"Tipo de actividad / clave IRPF Anual",5]
[null,"Tipo de actividad / clave Modelo 390",1]
[null,"Grupo o epígrafe IAE",111]
[null,"IVA: Opción por el régimen especial del criterio de caja","NO","Macro: \"Ocultar columnas recargo equivalencia\" (Ctl+o)"]
[null,"Primer Tipo de IVA",4,"Tipo Recargo Equivalencia",0.5]
[null,"Segundo Tipo de IVA",10,"Tipo de Recargo Equivalencia",1.4]
[null,"Tercer Tipo de IVA",21,"Tipo de Recargo Equivalencia",5.2]
[null,"Localidad","CIUDAD"]
[null,"Teléfono",999999999]
[null,"Código Delegación","32600",{"$f":"VLOOKUP(C18,D20:E271,2,FALSE)","v":"OURENSE"}]
[null,"Observaciones",null,"LISTADO CÓDIGOS DELEGACIONES",null,"LISTADO CÓDIGO PROVINCIAS PARA MODELO 347",null,null,"Lista Trimestres"]
[null,"Enlaces",null,"01600","ALAVA","ARABA/ÁLAVA","01",null,"1T"]
[null,"Enlaces","AEAT, presentación declaraciones","02037","HELLIN","ALBACETE","02",null,"2T"]
[null,null,null,"02069","LA RODA","ALACANT / ALICANTE","03",null,"3T"]
[null,null,null,"02600","ALBACETE","ALMERÍA","04",null,"4T"]
[null,"Macro: \"Crear Nuevo Archivo\" (Ctl+a)",null,"03009","ALCOI/ALCOY","ASTURIAS","33"]
[null,null,null,"03031","BENIDORM","ÁVILA","05"]
[null,null,null,"03063","DENIA","BADAJOZ","06"]
[null,null,null,"03065","ELX/ELCHE","BARCELONA","08"]
[null,null,null,"03066","ELDA","BURGOS","09"]
[null,null,null,"03099","ORIHUELA","CÁCERES",10]
[null,null,null,"03140","VILLENA","CÁDIZ",11]
[null,null,null,"03601","ALACANT/ALICANTE","CANTABRIA",39]
[null,null,null,"04053","HUERCAL-OVERA","CASTELL / CASTELLÓN",12]
[null,null,null,"04104","EL EJIDO","CEUTA",51]
[null,null,null,"04600","ALMERIA","CIUDAD REAL",13]
[null,null,null,"05600","AVILA","CÓRDOBA",14]
[null,null,null,"06044","DON BENITO","A CORUÑA",15]
[null,null,null,"06083","MERIDA","CUENCA",16]
[null,null,null,"06158","ZAFRA","GIRONA",17]
[null,null,null,"06600","BADAJOZ","GRANADA",18]
[null,null,null,"07026","EIVISSA-FORMENTERA","GUADALAJARA",19]
[null,null,null,"07027","INCA","GIPÚZKOA",20]
[null,null,null,"07032","MENORCA","HUELVA",21]
[null,null,null,"07033","MANACOR","HUESCA",22]
[null,null,null,"07601","PALMA DE MALLORCA","ILLES BALEARS","07"]
[null,null,null,"08006","ARENYS DE MAR","JAÉN",23]
[null,null,null,"08015","BADALONA","LEÓN",24]
[null,null,null,"08022","BERGA","LLEIDA",25]
[null,null,null,"08072","CORNELLA DE LLOBR.","LUGO",27]
[null,null,null,"08095","GRANOLLERS","MADRID",28]
[null,null,null,"08100","L'HOSPITALET DE L.","MÁLAGA",29]
[null,null,null,"08101","IGUALADA","MELILLA",52]
[null,null,null,"08112","MANRESA","MURCIA",30]
[null,null,null,"08120","MATARO","NAVARRA",31]
[null,null,null,"08186","SABADELL","OURENSE",32]
[null,null,null,"08204","SANT CUGAT DEL V.","PALENCIA",34]
[null,null,null,"08210","SANT FELIU","LAS PALMAS",35]
[null,null,null,"08245","SANTA COLOMA DE G.","PONTEVEDRA",36]
[null,null,null,"08279","TERRASSA","LA RIOJA",26]
[null,null,null,"08299","VIC","SALAMANCA",37]
[null,null,null,"08306","VILAFRANCA PENEDES","SANTA CRUZ DE TENERIFE",38]
[null,null,null,"08308","VILANOVA I GELTRU","SEGOVIA",40]
[null,null,null,"08602","COLOM","SEVILLA",41]
[null,null,null,"08603","SANTS-LES CORTS","SORIA",42]
[null,null,null,"08604","PEDRALBES-SARRIA","TARRAGONA",43]
[null,null,null,"08605","GRACIA","TERUEL",44]
[null,null,null,"08606","HORTA","TOLEDO",45]
[null,null,null,"08607","SANT ANDREU","VALENCIA / VALÉNCIA",46]
[null,null,null,"08608","POBLE-NOU","VALLADOLID",47]
[null,null,null,"08610","LETAMENDI","BIZKAIA",48]
[null,null,null,"09018","ARANDA DE DUERO","ZAMORA",49]
[null,null,null,"09224","MIRANDA DE EBRO","ZARAGOZA",50]
[null,null,null,"09600","BURGOS","NO RESIDENTE",99]
[null,null,null,"10134","NAVALMORAL MATA"]
[null,null,null,"10151","PLASENCIA"]
[null,null,null,"10199","TRUJILLO"]
[null,null,null,"10600","CACERES"]
[null,null,null,"11004","ALGECIRAS"]
[null,null,null,"11015","CHICLANA DE LA FR."]
[null,null,null,"11027","PTO. DE STA. MARIA"]
[null,null,null,"11032","SANLUCAR BARRAMEDA"]
[null,null,null,"11033","SAN ROQUE"]
[null,null,null,"11038","UBRIQUE"]
[null,null,null,"11600","CADIZ"]
[null,null,null,"12135","VILA-REAL/VILLARR."]
[null,null,null,"12138","VINAROS"]
[null,null,null,"12600","CASTELLO/CASTELLON"]
[null,null,null,"13005","ALCAZAR SAN JUAN"]
[null,null,null,"13071","PUERTOLLANO"]
[null,null,null,"13087","VALDEPEÑAS"]
[null,null,null,"13600","CIUDAD REAL"]
[null,null,null,"14038","LUCENA"]
[null,null,null,"14042","MONTILLA"]
[null,null,null,"14052","PEÑARROYA-PUEBLON."]
[null,null,null,"14054","POZOBLANCO"]
[null,null,null,"14600","CORDOBA"]
[null,null,null,"14601","CORDOBA-ESTE"]
[null,null,null,"15009","BETANZOS"]
[null,null,null,"15019","CARBALLO"]
[null,null,null,"15023","CEE"]
[null,null,null,"15037","FERROL"]
[null,null,null,"15062","ORTIGUEIRA"]
[null,null,null,"15074","RIBEIRA"]
[null,null,null,"15079","SANTIAGO COMPOST."]
[null,null,null,"15600","A CORUÑA"]
[null,null,null,"16212","TARANCON"]
[null,null,null,"16600","CUENCA"]
[null,null,null,"17025","LA BISBAL"]
[null,null,null,"17072","FIGUERES"]
[null,null,null,"17121","OLOT"]
[null,null,null,"17600","GIRONA"]
[null,null,null,"18024","BAZA"]
[null,null,null,"18091","GUADIX"]
[null,null,null,"18123","LOJA"]
[null,null,null,"18142","MOTRIL"]
[null,null,null,"18150","ORGIVA"]
[null,null,null,"18600","GRANADA"]
[null,null,null,"18601","GRANADA-ALMANJAYAR"]
[null,null,null,"19600","GUADALAJARA"]
[null,null,null,"20600","GUIPUZCOA"]
[null,null,null,"21007","ARACENA"]
[null,null,null,"21010","AYAMONTE"]
[null,null,null,"21054","PALMA DEL CONDADO"]
[null,null,null,"21600","HUELVA"]
[null,null,null,"22218","MONZON"]
[null,null,null,"22600","HUESCA"]
[null,null,null,"23005","ANDUJAR"]
[null,null,null,"23055","LINARES"]
[null,null,null,"23092","UBEDA"]
[null,null,null,"23095","VILLACARRILLO"]
[null,null,null,"23600","JAEN"]
[null,null,null,"24009","ASTORGA"]
[null,null,null,"24118","PONFERRADA"]
[null,null,null,"24600","LEON"]
[null,null,null,"25252","LA SEU D'URGELL"]
[null,null,null,"25272","TARREGA"]
[null,null,null,"25600","LLEIDA"]
[null,null,null,"26036","CALAHORRA"]
[null,null,null,"26071","HARO"]
[null,null,null,"26600","LOGROÑO"]
[null,null,null,"27019","FOZ"]
[null,null,null,"27031","MONFORTE DE LEMOS"]
[null,null,null,"27600","LUGO"]
[null,null,null,"28005","ALCALA DE HENARES"]
[null,null,null,"28006","ALCOBENDAS"]
[null,null,null,"28007","ALCORCON"]
[null,null,null,"28013","ARANJUEZ"]
[null,null,null,"28014","ARGANDA"]
[null,null,null,"28045","COLMENAR VIEJO"]
[null,null,null,"28054","EL ESCORIAL"]
[null,null,null,"28058","FUENLABRADA"]
[null,null,null,"28065","GETAFE"]
[null,null,null,"28074","LEGANES"]
[null,null,null,"28092","MOSTOLES"]
[null,null,null,"28115","POZUELO"]
[null,null,null,"28148","TORREJON DE ARDOZ"]
[null,null,null,"28602","CARABANCHEL"]
[null,null,null,"28603","MONTALBAN"]
[null,null,null,"28604","CIUDAD LINEAL"]
[null,null,null,"28606","FUENCARRAL"]
[null,null,null,"28607","HORTALEZA-BARAJAS"]
[null,null,null,"28608","LATINA"]
[null,null,null,"28609","VILLA DE VALLECAS"]
[null,null,null,"28610","MORATALAZ-VICALV."]
[null,null,null,"28612","MARIA DE MOLINA"]
[null,null,null,"28613","SAN BLAS"]
[null,null,null,"28614","PUENTE DE VALLECAS"]
[null,null,null,"28615","VILLAVERDE-USERA"]
[null,null,null,"28616","GUZMAN EL BUENO"]
[null,null,null,"29012","ALORA"]
[null,null,null,"29015","ANTEQUERA"]
[null,null,null,"29069","MARBELLA"]
[null,null,null,"29084","RONDA"]
[null,null,null,"29094","VELEZ-MALAGA"]
[null,null,null,"29103","TORREMOLINOS"]
[null,null,null,"29600","MALAGA"]
[null,null,null,"29601","MALAGA-ESTE"]
[null,null,null,"30019","CIEZA"]
[null,null,null,"30024","LORCA"]
[null,null,null,"30029","MULA"]
[null,null,null,"30601","MURCIA"]
[null,null,null,"31600","NAFARROA/NAVARRA"]
[null,null,null,"32010","O BARCO VALDEORRAS"]
[null,null,null,"32020","O CARBALLIÑO"]
[null,null,null,"32025","CELANOVA"]
[null,null,null,"32086","VERIN"]
[null,null,null,"32600","OURENSE"]
[null,null,null,"33004","AVILES"]
[null,null,null,"33011","CANGAS DEL NARCEA"]
[null,null,null,"33012","CANGAS DE ONIS"]
[null,null,null,"33031","LANGREO"]
[null,null,null,"33034","LUARCA"]
[null,null,null,"33037","MIERES"]
[null,null,null,"33600","OVIEDO"]
[null,null,null,"34004","AGUILAR DE CAMPOO"]
[null,null,null,"34600","PALENCIA"]
[null,null,null,"35004","LANZAROTE"]
[null,null,null,"35010","STA.MARIA DE GUIA"]
[null,null,null,"35018","FUERTEVENTURA"]
[null,null,null,"35020","SAN BARTOLOME TIR."]
[null,null,null,"35601","LAS PALMAS G.C."]
[null,null,null,"36017","A ESTRADA"]
[null,null,null,"36042","PONTEAREAS"]
[null,null,null,"36055","TUI"]
[null,null,null,"36060","VILAGARCIA AROUSA"]
[null,null,null,"36600","PONTEVEDRA"]
[null,null,null,"37046","BEJAR"]
[null,null,null,"37107","CIUDAD RODRIGO"]
[null,null,null,"37600","SALAMANCA"]
[null,null,null,"38006","ARONA"]
[null,null,null,"38023","LA LAGUNA"]
[null,null,null,"38028","PUERTO DE LA CRUZ"]
[null,null,null,"38036","LA GOMERA"]
[null,null,null,"38037","LA PALMA"]
[null,null,null,"38048","EL HIERRO"]
[null,null,null,"38600","STA. CRUZ TENERIFE"]
[null,null,null,"39035","LAREDO"]
[null,null,null,"39059","REINOSA"]
[null,null,null,"39087","TORRELAVEGA"]
[null,null,null,"39600","CANTABRIA"]
[null,null,null,"40600","SEGOVIA"]
[null,null,null,"41039","ECIJA"]
[null,null,null,"41055","LORA DEL RIO"]
[null,null,null,"41065","MORON FRONTERA"]
[null,null,null,"41068","OSUNA"]
[null,null,null,"41095","UTRERA"]
[null,null,null,"41600","SEVILLA"]
[null,null,null,"41601","MACARENA"]
[null,null,null,"41603","PARQUE"]
[null,null,null,"41604","NERVION-SAN PABLO"]
[null,null,null,"41606","OESTE-NOROESTE"]
[null,null,null,"42600","SORIA"]
[null,null,null,"43125","REUS"]
[null,null,null,"43157","TORTOSA"]
[null,null,null,"43600","TARRAGONA"]
[null,null,null,"44013","ALCAÑIZ"]
[null,null,null,"44600","TERUEL"]
[null,null,null,"45143","QUINTANAR ORDEN"]
[null,null,null,"45166","TALAVERA REINA"]
[null,null,null,"45600","TOLEDO"]
[null,null,null,"46017","ALZIRA"]
[null,null,null,"46096","CATARROJA"]
[null,null,null,"46133","GANDIA"]
[null,null,null,"46147","XATIVA"]
[null,null,null,"46149","LLIRIA"]
[null,null,null,"46161","MANISES"]
[null,null,null,"46173","MONCADA"]
[null,null,null,"46215","REQUENA"]
[null,null,null,"46222","SAGUNT/SAGUNTO"]
[null,null,null,"46237","SUECA"]
[null,null,null,"46246","TORRENT"]
[null,null,null,"46601","VALENCIA-GRAO"]
[null,null,null,"46602","VALENCIA-NORTE"]
[null,null,null,"46603","GUILLEM DE CASTRO"]
[null,null,null,"47086","MEDINA DEL CAMPO"]
[null,null,null,"47600","VALLADOLID"]
[null,null,null,"47601","VALLADOLID CAPITAL"]
[null,null,null,"48600","VIZCAYA"]
[null,null,null,"49023","BENAVENTE"]
[null,null,null,"49600","ZAMORA"]
[null,null,null,"50067","CALATAYUD"]
[null,null,null,"50095","EJEA CABALLEROS"]
[null,null,null,"50600","ZARAGOZA"]
[null,null,null,"50601","ARRABAL-PTE. SANT."]
[null,null,null,"50602","DELICIAS"]
[null,null,null,"50603","LAS FUENTES"]
[null,null,null,"51600","CARTAGENA"]
[null,null,null,"52600","GIJON"]
[null,null,null,"53600","JEREZ FRONTERA"]
[null,null,null,"54600","VIGO"]
[null,null,null,"55600","CEUTA"]
[null,null,null,"56600","MELILLA"]

{"sheet":"130","index":1,"n_rows":99,"n_cols":42,"rows_kept":99,"cut":false,"hidden":false,"merged":[[4,27,4,30],[67,5,67,6],[58,14,58,20],[60,8,60,9],[72,16,72,17],[72,18,72,20],[72,2,72,6],[72,8,72,9],[72,10,72,11],[72,12,72,15],[60,15,60,16]]}
[]
[null,null,"IRPF Actividades económicas en estimación directa. Pago fraccionado",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,"Modelo 130",null,"Mostrar Calculadora de Windows (Ctl+w)"]
[]
[null,null,"NIF"]
[null,null,{"$f":"'DATOS FISCALES'!C2","v":"34999999W"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ejercicio",null,null,null,{"$f":"IF(NOT(ISBLANK(#REF!)),YEAR(#REF!),IF(NOT(ISBLANK(#REF!)),YEAR(#REF!),YEAR(TODAY())))","v":{"$error":"#REF!"}},null,null,null,null,null,"Período",null,null,null,"1T"]
[null,null,"Nombre"]
[null,null,{"$f":"'DATOS FISCALES'!C4","v":"NOMBRE"}]
[null,null,"Apellidos",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,{"$f":"HYPERLINK(\"C:\\AEAT\",\"ABRIR CARPETA C:\\AEAT\")","v":"ABRIR CARPETA C:\\AEAT"},null,"PAGO IMPUESTOS"]
[null,null,{"$f":"'DATOS FISCALES'!C5&\" \"&'DATOS FISCALES'!C6","v":"APELLIDOA APELLIDOB"},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,"PRESENTAR ELECTRÓNICA",null,"Consulta de declaraciones presentadas"]
[]
[]
[null,null,"I. Actividades económ. en estimación directa, modalidad normal o simplificada, distintas de agrícolas, ganaderas, "]
[null,null,"forestales y pesqueras. (Datos acumulados del periodo comprendido entre el primer día del año y el último día del trimestre)",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,"Diseños de registro"]
[]
[null,null,"Ingresos computables correspondientes al conjunto de las actividades ejercidas ……………………….",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,"01",{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,2,FALSE)","v":{"$error":"#REF!"}}]
[null,null,"Gastos fiscalmente deducibles correspondientes al conjunto de actividades ejercidas …………………",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,"02",{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,4,FALSE)","v":{"$error":"#REF!"}}]
[null,null,"Rendimiento neto ([01]-[02]). Si se obtiene una cantidad negativa, consígnela con signo menos (-) …..",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,"03",{"$f":"AL15-AL16","v":{"$error":"#REF!"}}]
[null,null,"20 por 100 del importe de la casilla [03], si dicho importe es positivo ……………………………………..",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,"04",{"$f":"ROUND(IF(AL17>0,0.2*AL17,0),2)","v":{"$error":"#REF!"}}]
[null,null,"(Si la casilla [03] fuese negativa, consigne el número cero)"]
[null,null,"A deducir:"]
[null,null,"De los trimestres anteriores: suma de los importes positivos de la casilla [07] menos"]
[null,null,"la suma de los importes de la casilla [16] ……………………………………………………………………",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,"05",{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,5,FALSE)","v":0}]
[null,null,"Retenciones e ingresos a cuenta soportados por las actividades incluidas en este apartado"]
[null,null,"y correspondientes al período comprendido entre el primer día del año y el último día del trimestre …..",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,"06",{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,6,FALSE)","v":{"$error":"#REF!"}}]
[]
[null,null,"Pago fraccionado previo del trimestre ([04]-[05]-[06])"]
[null,null,"Si se obtiene una cantidad negativa, consígnela con signo menos (-) ……………………………………",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,"07",{"$f":"AL18-AL22-AL24","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"II. Actividades agrícolas, ganaderas, forestales y pesqueras en estimación directa, modalidad normal o simplificada"]
[]
[null,null,"Volumen de ingresos del trimestre (excluidas las subvenciones de capital y las indemnizaciones) ….",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,"08"]
[null,null,"2 por 100 del importe de la casilla [08] ………………………………………………………………………",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,"09"]
[null,null,"A deducir:"]
[null,null,"Retenciones e ingresos a cuenta soportados por las actividades incluidas en este apartado, correspondientes al trimestre",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,10]
[null,null,"Pago fraccionado previo del trimestre ([09]-[10])"]
[null,null,"Si se obtiene una cantidad negativa, consígnela con signo menos(-) ……………………………………",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,11,{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,10,FALSE)","v":0}]
[]
[]
[null,null,"III. Total liquidación"]
[]
[null,null,"Suma de pagos fraccionados previos del trimestre ([07]+[11]) Si se obtiene una cantidad negativa, consigne número cero",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,12,{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,11,FALSE)","v":{"$error":"#REF!"}}]
[null,null,"A deducir: Minoración por aplicación de la deducción a que se refiere el art. 110.3 c) del Reglamento del Impuesto",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,13,{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,12,FALSE)","v":100}]
[null,null,"Diferencia ([12]-[13]).Si se obtiene una cantidad negativa, consignela con signo menos (-) ………..",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,14,{"$f":"AL42-AL43","v":{"$error":"#REF!"}}]
[null,null,"A deducir (si la diferencia anterior es positiva y con el máximo de su importe):"]
[null,null,null,"Resultados negativos de trimestres anteriores ……………………………………………………………………………….",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,15,{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,13,FALSE)","v":0}]
[null,null,null,"Por destinar cantidades al pago de préstamos para la adquisición o rehabilitación de la vivienda habitual:"]
[null,null,null,"El 2 por 100 de [03] (máximo: 660,14 euros por trimestre) o el 2 por 100 de [08] (máximo: 660,14 euros anuales) ..",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,16]
[null,null,"Total ([14]-[15]-[16]).Si se obtiene una cantidad negativa, consignela con signo menos (-) ………………………………..",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,17,{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,14,FALSE)","v":{"$error":"#REF!"}}]
[null,null,"A deducir (exclusivamente en caso de declaración complementaria):"]
[null,null,null,"Resultado a ingresar de las anteriores declaraciones presentadas por el mismo concepto, ejercicio y período",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,18,{"$f":"VLOOKUP($AL$5,CALCULOS!A5:P8,15,FALSE)","v":0}]
[]
[null,null,"Resultado de la declaración ([17]-[18])",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,19,{"$f":"AL49-AL51","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Ingreso efectuado a favor del Tesoro Público, cuenta restringida de",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AL5<>\"4T\",AL53<0),\"X\",\"\")","v":{"$error":"#REF!"}}," Autoliquidación con resultado a deducir en los"]
[null,null,"colaboración en la recaudación de la AEAT autoliquidaciones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," siguientes pagos fraccionados del mismo ejercicio"]
[]
[null,null,"Importe ingreso (casilla [19])",null,null,null,null,null,null,null,null,null,null,"I",{"$f":"IF(AL53>0,AL53,\"\")","v":{"$error":"#REF!"}}]
[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,"Si esta autoliquidación es complementaria de otra autoliquidación"]
[null,null,"Forma de pago:",null,null,null,null,null,null,null,"En efectivo",null,null,null,null,{"$f":"IF(AL53>0,\"X\",\"\")","v":{"$error":"#REF!"}},null,"Adeudo en cuenta",null,null,null,null,null,null,null,"anterior correspondiente al mismo concepto, ejercicio y período,"]
[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,"consigne una \"X\" esta casilla."]
[]
[null,null,"Código IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Autoliquidación complementaria"]
[null,null,{"$f":"IF($P$61=\"\",\"\",'DATOS FISCALES'!C7)","v":{"$error":"#REF!"}}]
[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,"En este caso, consigne a continuación el número de justificante"]
[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,"identificativo de la autoliquidación anterior"]
[null,null,null,null,null,{"$f":"IF(OR(AL53=0,AND(AL53<0,AL5=\"4T\")),\"X\",\"\")","v":{"$error":"#REF!"}},null,"    Autoliquidación negativa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nº de justificante"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,", a",null,null,"de",null,null,null,null,null,"de",null,null,null,null,null,null,null,"Firma:"]
[]
[]
[null,"CÁLCULOS PARA EL DISEÑO DE REGISTRO (para generar el archivo de texto con el contenido del modelo)"]
[null,null,"Posición","Longitud","Tipo","Descripción","Contenido","Formulas intermedias","Comprobación longitud"]
[null,null,13,1,"A","Tipo de Declaración",{"$f":"IF(Z56<>\"\",\"B\",IF(O59<>\"\",\"I\",IF(F68<>\"\",\"N\",\" \")))","v":{"$error":"#REF!"}}]
[null,null,23,60,"An","Declarante (1) - Apellidos ",{"$f":"'DATOS FISCALES'!C5&\" \"&'DATOS FISCALES'!C6&REPT(\" \",D79-LEN('DATOS FISCALES'!C5&\" \"&'DATOS FISCALES'!C6))","v":"APELLIDOA APELLIDOB                                         "}]
[null,null,83,20,"An","Declarante (1) - Nombre ",{"$f":"LEFT('DATOS FISCALES'!C4,20)&REPT(\" \",D80-LEN(LEFT('DATOS FISCALES'!C4,20)))","v":"NOMBRE              "}]
[null,null,109,17,"Num","Liquidación (3) - Activ. económicas estimac. Directa - Ingresos computables [01]",{"$f":"REPT(\"0\",D81-LEN(SUBSTITUTE(TEXT(AL15,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL15,\"0,00\"),\",\",\"\")","v":{"$error":"#REF!"}}]
[null,null,126,17,"Num","Liquidación (3) - Activ. económicas estimac. Directa - Gastos fiscal mente deducibles [02]",{"$f":"REPT(\"0\",D82-LEN(SUBSTITUTE(TEXT(AL16,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL16,\"0,00\"),\",\",\"\")","v":{"$error":"#REF!"}}]
[null,null,143,17,"N","Liquidación (3) - Activ. económicas estimac. Directa - Rendimiento neto [03]",{"$f":"IF(AL17<0,\"N\",0)&REPT(\"0\",D83-1-LEN(SUBSTITUTE(SUBSTITUTE(TEXT(AL17,\"0,00\"),\",\",\"\"),\"-\",\"\")))&SUBSTITUTE(SUBSTITUTE(TEXT(AL17,\"0,00\"),\",\",\"\"),\"-\",\"\")","v":{"$error":"#REF!"}}]
[null,null,160,17,"Num","Liquidación (3) - Activ. económicas estimac. Directa - 20% de la casilla 03 [04]",{"$f":"REPT(\"0\",D84-LEN(SUBSTITUTE(TEXT(AL18,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL18,\"0,00\"),\",\",\"\")","v":{"$error":"#REF!"}}]
[null,null,177,17,"Num","Liquidación (3) - Activ. económicas estimac. Directa - A deducir - De los trimestres anteriores [05]",{"$f":"REPT(\"0\",D85-LEN(SUBSTITUTE(TEXT(AL22,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL22,\"0,00\"),\",\",\"\")","v":"00000000000000000"}]
[null,null,194,17,"Num","Liquidación (3) - Activ. económicas estimac. Directa - A deducir - Retenciones e ingr. a cuenta [06]",{"$f":"REPT(\"0\",D86-LEN(SUBSTITUTE(TEXT(AL24,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL24,\"0,00\"),\",\",\"\")","v":{"$error":"#REF!"}}]
[null,null,211,17,"N","Liquidación (3) - Activ. económicas estimac. Directa - Pago fraccionado previo del trimestre [07]",{"$f":"IF(AL27<0,\"N\",0)&REPT(\"0\",D87-1-LEN(SUBSTITUTE(SUBSTITUTE(TEXT(AL27,\"0,00\"),\",\",\"\"),\"-\",\"\")))&SUBSTITUTE(SUBSTITUTE(TEXT(AL27,\"0,00\"),\",\",\"\"),\"-\",\"\")","v":{"$error":"#REF!"}}]
[null,null,228,17,"Num","Liquidación (3) - Activ. agrlcola. estimac. directa - Volumen de ingresos [08]",{"$f":"REPT(\"0\",D88-LEN(SUBSTITUTE(TEXT(AL32,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL32,\"0,00\"),\",\",\"\")","v":"00000000000000000"}]
[null,null,245,17,"Num","Liquidación (3) - Activ. agrlcola. estimac. directa - 2% de la casilla 08 [09]",{"$f":"REPT(\"0\",D89-LEN(SUBSTITUTE(TEXT(AL33,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL33,\"0,00\"),\",\",\"\")","v":"00000000000000000"}]
[null,null,262,17,"Num","Liquidación (3) - Activ. agrlcola. estimac. directa - A deducir- Retenciones e ingr. a cuenta [10]",{"$f":"REPT(\"0\",D90-LEN(SUBSTITUTE(TEXT(AL35,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL35,\"0,00\"),\",\",\"\")","v":"00000000000000000"}]
[null,null,279,17,"N","Liquidación (3) - Activ. agrlcola estimac. directa - Pago fraccionado previo del trimestre [11]",{"$f":"IF(AL37<0,\"N\",0)&REPT(\"0\",D91-1-LEN(SUBSTITUTE(SUBSTITUTE(TEXT(AL37,\"0,00\"),\",\",\"\"),\"-\",\"\")))&SUBSTITUTE(SUBSTITUTE(TEXT(AL37,\"0,00\"),\",\",\"\"),\"-\",\"\")","v":"00000000000000000"}]
[null,null,296,17,"Num","Liquidación (3) - Total liquidación - Suma de pagos fraccionados previos del trimestre [12]",{"$f":"REPT(\"0\",D92-LEN(SUBSTITUTE(TEXT(AL42,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL42,\"0,00\"),\",\",\"\")","v":{"$error":"#REF!"}}]
[null,null,313,17,"Num","Liquidación (3) - Total liquidación - A deducir: Minorac. Artículo 110.3 del Reglamento IRPF [13]",{"$f":"REPT(\"0\",D93-LEN(SUBSTITUTE(TEXT(AL43,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL43,\"0,00\"),\",\",\"\")","v":"00000000000010000"}]
[null,null,330,17,"N","Liquidación (3) - Total liquidación - Diferencia (12) - (13) [14]",{"$f":"IF(AL44<0,\"N\",0)&REPT(\"0\",D94-1-LEN(SUBSTITUTE(SUBSTITUTE(TEXT(AL44,\"0,00\"),\",\",\"\"),\"-\",\"\")))&SUBSTITUTE(SUBSTITUTE(TEXT(AL44,\"0,00\"),\",\",\"\"),\"-\",\"\")","v":{"$error":"#REF!"}}]
[null,null,347,17,"Num","Liquidación (3) - Total liquidación - A deducir - Resultados negativos de trimestres anteriores [15]",{"$f":"REPT(\"0\",D95-LEN(SUBSTITUTE(TEXT(AL46,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL46,\"0,00\"),\",\",\"\")","v":"00000000000000000"}]
[null,null,364,17,"Num","Liquidación (3) - Total liquidación - Pago de préstamos para la adquisición de vivienda habitual [16] ",{"$f":"REPT(\"0\",D96-LEN(SUBSTITUTE(TEXT(AL48,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL48,\"0,00\"),\",\",\"\")","v":"00000000000000000"}]
[null,null,381,17,"N","Liquidación (3) - Total liquidación [17] ",{"$f":"IF(AL49<0,\"N\",0)&REPT(\"0\",D97-1-LEN(SUBSTITUTE(SUBSTITUTE(TEXT(AL49,\"0,00\"),\",\",\"\"),\"-\",\"\")))&SUBSTITUTE(SUBSTITUTE(TEXT(AL49,\"0,00\"),\",\",\"\"),\"-\",\"\")","v":{"$error":"#REF!"}}]
[null,null,398,17,"Num","Liquidación (3) - Total liquidación - A deducir - Resultado de las anteriores declaraciones [18] ",{"$f":"REPT(\"0\",D98-LEN(SUBSTITUTE(TEXT(AL51,\"0,00\"),\",\",\"\")))&SUBSTITUTE(TEXT(AL51,\"0,00\"),\",\",\"\")","v":"00000000000000000"}]
[null,null,415,17,"N","Liquidación (3) - Total liquidación - Resultado de la declaración [19]",{"$f":"IF(AL53<0,\"N\",0)&REPT(\"0\",D99-1-LEN(SUBSTITUTE(SUBSTITUTE(TEXT(AL53,\"0,00\"),\",\",\"\"),\"-\",\"\")))&SUBSTITUTE(SUBSTITUTE(TEXT(AL53,\"0,00\"),\",\",\"\"),\"-\",\"\")","v":{"$error":"#REF!"}}]

{"sheet":"CALCULOS","index":2,"n_rows":23,"n_cols":71,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,41,12,41],[20,33,20,34],[20,35,20,40],[20,41,20,46],[11,35,11,39],[11,40,12,40],[11,34,12,34],[11,27,11,30],[11,31,11,32],[11,33,12,33],[20,69,20,70],[20,47,20,52],[20,53,20,58],[20,59,20,64],[20,65,20,66],[20,67,20,68],[20,27,20,32]]}
[]
["CÁLCULOS TRIMESTRALES PARA EL MODELO 130: IRPF"]
[]
["TRIMESTRE","Ingresos Casilla [01]","Gastos Brutos","Casilla [02] Gastos con deducción","Casilla [05]","Casilla [06] Retenc.\nsoportad","Casilla [07] Pago fraccionado",null,null,"Casilla [11]","Casilla [12]","Casilla [13] Deducción del art. 110.3 c) Regl. IRPF","Casilla [15]\nCompensar negativas anteriores","Casilla [17]","Casilla [18]","Casilla [19]"]
["1T",{"$f":"SUMIF(#REF!,1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,1,#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((B5-C5)>=0,C5+MIN(ROUND(0.05*(B5-C5),2),2000),C5)","v":{"$error":"#REF!"}},0,{"$f":"ROUND(SUMIF(#REF!,1,#REF!),2)","v":{"$error":"#REF!"}},{"$f":"ROUND(IF((B5-D5)>=0,0.2*(B5-D5),0)-(E5+F5),2)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(G5+J5>0,G5+J5,0)","v":{"$error":"#REF!"}},{"$f":"IF('DATOS FISCALES'!C$8>12000,0,IF('DATOS FISCALES'!C$8>=11000.01,25,IF('DATOS FISCALES'!C$8>=10000.01,50,IF('DATOS FISCALES'!C$8>=9000.01,75,100))))","v":100},0,{"$f":"K5-L5-M5","v":{"$error":"#REF!"}},null,{"$f":"N5-O5","v":{"$error":"#REF!"}}]
["2T",{"$f":"SUMIF(#REF!,\"<=2\",#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,\"<=2\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((B6-C6)>=0,C6+MIN(ROUND(0.05*(B6-C6),2),2000),C6)","v":{"$error":"#REF!"}},{"$f":"IF(G5>0,G5,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUMIF(#REF!,\"<=2\",#REF!),2)","v":{"$error":"#REF!"}},{"$f":"ROUND(IF((B6-D6)>=0,0.2*(B6-D6),0)-(E6+F6),2)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(G6+J6>0,G6+J6,0)","v":{"$error":"#REF!"}},{"$f":"IF('DATOS FISCALES'!C$8>12000,0,IF('DATOS FISCALES'!C$8>=11000.01,25,IF('DATOS FISCALES'!C$8>=10000.01,50,IF('DATOS FISCALES'!C$8>=9000.01,75,100))))","v":100},{"$f":"IF(AND(K6-L6>0,P5<0),IF(ABS(P5)<K6-L6,ABS(P5),K6-L6),0)","v":{"$error":"#REF!"}},{"$f":"K6-L6-M6","v":{"$error":"#REF!"}},null,{"$f":"N6-O6","v":{"$error":"#REF!"}}]
["3T",{"$f":"SUMIF(#REF!,\"<=3\",#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,\"<=3\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((B7-C7)>=0,C7+MIN(ROUND(0.05*(B7-C7),2),2000),C7)","v":{"$error":"#REF!"}},{"$f":"E6+IF(G6>0,G6,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUMIF(#REF!,\"<=3\",#REF!),2)","v":{"$error":"#REF!"}},{"$f":"ROUND(IF((B7-D7)>=0,0.2*(B7-D7),0)-(E7+F7),2)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(G7+J7>0,G7+J7,0)","v":{"$error":"#REF!"}},{"$f":"IF('DATOS FISCALES'!C$8>12000,0,IF('DATOS FISCALES'!C$8>=11000.01,25,IF('DATOS FISCALES'!C$8>=10000.01,50,IF('DATOS FISCALES'!C$8>=9000.01,75,100))))","v":100},{"$f":"IF(AND(K7-L7>0,(IF(P6<0,P6,0)+IF(M6+P5<0,M6+P5,0))<0),IF(ABS(IF(P6<0,P6,0)+IF(M6+P5<0,M6+P5,0))<K7-L7,ABS(IF(P6<0,P6,0)+IF(M6+P5<0,M6+P5,0)),K7-L7),0)","v":{"$error":"#REF!"}},{"$f":"K7-L7-M7","v":{"$error":"#REF!"}},null,{"$f":"N7-O7","v":{"$error":"#REF!"}}]
["4T",{"$f":"SUMIF(#REF!,\"<=4\",#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,\"<=4\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((B8-C8)>=0,C8+MIN(ROUND(0.05*(B8-C8),2),2000),C8)","v":{"$error":"#REF!"}},{"$f":"E7+IF(G7>0,G7,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUMIF(#REF!,\"<=4\",#REF!),2)","v":{"$error":"#REF!"}},{"$f":"ROUND(IF((B8-D8)>=0,0.2*(B8-D8),0)-(E8+F8),2)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(G8+J8>0,G8+J8,0)","v":{"$error":"#REF!"}},{"$f":"IF('DATOS FISCALES'!C$8>12000,0,IF('DATOS FISCALES'!C$8>=11000.01,25,IF('DATOS FISCALES'!C$8>=10000.01,50,IF('DATOS FISCALES'!C$8>=9000.01,75,100))))","v":100},{"$f":"IF(AND(K8-L8>0,SUM(M6:M7)+SUMIF(P5:P7,\"<0\")<0),IF(ABS(SUM(M6:M7)+SUMIF(P5:P7,\"<0\"))<K8-L8,ABS(SUM(M6:M7)+SUMIF(P5:P7,\"<0\")),K8-L8),0)","v":{"$error":"#REF!"}},{"$f":"K8-L8-M8","v":{"$error":"#REF!"}},null,{"$f":"N8-O8","v":{"$error":"#REF!"}}]
[]
[]
[]
[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,"IVA Deducible Adquisiciones Intracomunitarias",null,null,null,"Rectificación Deducciones",null,"Compensac. Rég. Esp. Agric. Ganad. y P. [42]","Resultado régimen general [46]","Información Adicional",null,null,null,null,"Cuotas a compensar trimestres Anteriores [67]","Resultado [69] y Resultado Liquid. [71]"]
[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,"Bases bienes y servicios corrientes [36]","Cuotas bienes y servicios corrientes [37]","Bases bienes de inversión [38]","Cuotas bienes de inversión [39]","Base Imponible [40]","Cuota [41]",null,null,"Entregas Intrac. de bienes y servicios [59]","Bases entregas en RECC calculadas según regla general devengo [62]","Cuotas entregas en RECC pero cálculo según regla general devengo [63]","Bases adquisic. en RECC pero cálculo según regla general devengo [74]","Cuotas adquisic. en RECC pero cálculo según regla general devengo [75]"]
[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,{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AD14","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AE14","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*#REF!),SUMPRODUCT((#REF!=#REF!)*#REF!))","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)-#REF!-SUM(#REF!,#REF!,AG14,AH14)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},null,{"$f":"AI14-AO14","v":{"$error":"#REF!"}}]
[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,{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AD15","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AE15","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*#REF!),SUMPRODUCT((#REF!=#REF!)*#REF!))","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)-#REF!-SUM(#REF!,#REF!,AG15,AH15)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(AP14<0,ABS(AP14),0)","v":{"$error":"#REF!"}},{"$f":"AI15-AO15","v":{"$error":"#REF!"}}]
[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,{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AD16","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AE16","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*#REF!),SUMPRODUCT((#REF!=#REF!)*#REF!))","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)-#REF!-SUM(#REF!,#REF!,AG16,AH16)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(AP15<0,ABS(AP15),0)","v":{"$error":"#REF!"}},{"$f":"AI16-AO16","v":{"$error":"#REF!"}}]
[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,{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AD17","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)-AE17","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*(#REF!=3)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!),SUMPRODUCT((#REF!=#REF!)*ISBLANK(#REF!)*(#REF!=1)*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,#REF!=0),SUMPRODUCT((#REF!=#REF!)*#REF!),SUMPRODUCT((#REF!=#REF!)*#REF!))","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)-#REF!-SUM(#REF!,#REF!,AG17,AH17)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=#REF!)*ISNUMBER(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,SUMPRODUCT((#REF!=#REF!)*(#REF!=1)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=1,#REF!=1),SUMPRODUCT((#REF!=#REF!)*(#REF!>0)*NOT(ISBLANK(#REF!))*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(AP16<0,ABS(AP16),0)","v":{"$error":"#REF!"}},{"$f":"AI17-AO17","v":{"$error":"#REF!"}}]
[]
[]
[]
[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,"IVA Devengado: Recargo de Equivalencia",null,null,null,null,null,"IVA Deveng. Modif R.E.",null,"IVA Deducible: Operaciones Interiores Bienes y Servicios Corrientes",null,null,null,null,null,"IVA Deducible: Operaciones Interiores de Bienes de Inversión",null,null,null,null,null,"IVA Deducible: Adq. Intracomunitarias de Bienes Corrientes",null,null,null,null,null,"IVA Deducible: Adq. Intracomunitarias de Bienes de Inversión",null,null,null,null,null,"IVA Deducible: Adq. Intracomunitarias de Bienes de Inversión",null,null,null,null,null,"Compensaciones Rég. Ag. Gan. y Pes.",null,"Rectificación Deducciones",null,"Volumen de Operaciones"]
[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,{"$f":"\"Bases sujetas R.E. \" & 'DATOS FISCALES'!$E13 & \"%\"","v":"Bases sujetas R.E. 0,5%"},{"$f":"\"Cuotas R.E. \" & 'DATOS FISCALES'!$E13 & \"%\"","v":"Cuotas R.E. 0,5%"},{"$f":"\"Bases sujetas R.E. \" & 'DATOS FISCALES'!$E14 & \"%\"","v":"Bases sujetas R.E. 1,4%"},{"$f":"\"Cuotas R.E. \" & 'DATOS FISCALES'!$E14 & \"%\"","v":"Cuotas R.E. 1,4%"},{"$f":"\"Bases sujetas R.E. \" & 'DATOS FISCALES'!$E15 & \"%\"","v":"Bases sujetas R.E. 5,2%"},{"$f":"\"Cuotas R.E. \" & 'DATOS FISCALES'!$E15 & \"%\"","v":"Cuotas R.E. 5,2%"},"Base Imponible [43]","Cuota [44]",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Base [60]","Cuota [61]","Base [639]","Cuota [62]","Base [639]","Cuota [62]"]
[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,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$13)*ISBLANK(#REF!)*ISBLANK(#REF!)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$13)*ISBLANK(#REF!)*ISBLANK(#REF!)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$14)*ISBLANK(#REF!)*ISBLANK(#REF!)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$14)*ISBLANK(#REF!)*ISBLANK(#REF!)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$15)*ISBLANK(#REF!)*ISBLANK(#REF!)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$15)*ISBLANK(#REF!)*ISBLANK(#REF!)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$13)*ISBLANK(#REF!)*(#REF!=1)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$13)*ISBLANK(#REF!)*(#REF!=1)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$14)*ISBLANK(#REF!)*(#REF!=1)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$14)*ISBLANK(#REF!)*(#REF!=1)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$15)*ISBLANK(#REF!)*(#REF!=1)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!='DATOS FISCALES'!$C$15)*ISBLANK(#REF!)*(#REF!=1)*ISBLANK(#REF!)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=1)*(#REF!='DATOS FISCALES'!$C13)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=1)*(#REF!='DATOS FISCALES'!$C13)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=1)*(#REF!='DATOS FISCALES'!$C14)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=1)*(#REF!='DATOS FISCALES'!$C14)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=1)*(#REF!='DATOS FISCALES'!$C15)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=1)*(#REF!='DATOS FISCALES'!$C15)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=3)*(#REF!='DATOS FISCALES'!$C13)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=3)*(#REF!='DATOS FISCALES'!$C13)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=3)*(#REF!='DATOS FISCALES'!$C14)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=3)*(#REF!='DATOS FISCALES'!$C14)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=3)*(#REF!='DATOS FISCALES'!$C15)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=3)*(#REF!='DATOS FISCALES'!$C15)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=2)*(#REF!='DATOS FISCALES'!$C13)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=2)*(#REF!='DATOS FISCALES'!$C13)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=2)*(#REF!='DATOS FISCALES'!$C14)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=2)*(#REF!='DATOS FISCALES'!$C14)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=2)*(#REF!='DATOS FISCALES'!$C15)*#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=2)*(#REF!='DATOS FISCALES'!$C15)*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=0,SUM(CALCULOS!#REF!)=0),SUMPRODUCT((#REF!>0)*#REF!),SUMPRODUCT((#REF!>0)*#REF!))","v":{"$error":"#REF!"}},{"$f":"SUM(AH14:AH17)","v":{"$error":"#REF!"}},{"$f":"SUM(AF14:AF17)","v":{"$error":"#REF!"}},{"$f":"SUM(AG14:AG17)","v":{"$error":"#REF!"}},{"$f":"SUM(AH14:AH17)","v":{"$error":"#REF!"}},{"$f":"SUM(AI14:AI17)","v":{"$error":"#REF!"}}]

{"sheet":"Acerca de","index":3,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,0,6,14]]}
["Plantilla de Excel para gestión de impuestos"]
["Programa de Excel para gestión de impuestos de empresarios individuales y profesionales autónomos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keywords"]
["Este archivo de Excel (\"plantilla\") se ofrece gratuitamente con la esperanza de que sea útil, pero SIN GARANTÍA ALGUNA;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APLICACIÓN EXCEL"]
["ni siquiera la garantía implícita MERCANTIL o de APTITUD PARA UN PROPÓSITO DETERMINADO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GESTIÓN DE IMPUESTOS AUTÓNOMOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CÁLCULO DE DECLARACIONES TRIMESTRALES EN EXCEL"]
["Se concede permiso para copiar, distribuir y/o modificar este documento bajo los términos de la Licencia de Documentación Libre de GNU, Versión 1.3 o cualquier otra versión posterior publicada por la Free Software Foundation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MODELO 130"]
["Consulte los detalles de la licencia en: http://www.gnu.org/licenses/fdl.txt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MODELO 303"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MODELO 390"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MODELO 347"]
["Agradecimientos:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GESTIÓN TRIBUTARIA PARA PEQUEÑOS EMPRESARIOS"]
["A todos los que han aportado ideas y correcciones con las que se ha ido mejorando esta plantilla.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Libro Registro de Ventas e Ingresos"]
["Especialmente agradecer a Jose Manuel Sánchez Puchades de Sánchez Castelló,S.L. (Valencia: asesoría fiscal, laboral y contable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Libro Registro de Compras y Gastos"]
["que aportó varias ideas fundamentales para la utilidad actual de la plantilla.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRPF"]
[]
["últimas actualizaciones:"]
["    * 26/01/2015 corregido error según comenta JuanL Rodríguez el 26 de Enero de 2015 (referido al diseño de registro para la impresión del Modelo 130). Gracias por su aportación."]
["    * 15/02/2015 Aportación de Marc Morales en comentario de febrero de 2015: corregida fórmula en la hoja cálculos, en la celda D5 y en las inferiores, para establecer un límite de 2000 euros en los gastos de difícil justificación: =SI((B5-C5)>=0;C5+MIN(REDONDEAR(0,05*(B5-C5);2);2000);C5)  Corregido también en la hoja 'IRPF ANUAL' la celda D43: establecido el mismo límite de 2000 euros."]
["    * 17/02/2015 Aportaciones de Jose Mª el 30/01/2015 y Marc Morales el 6/02/15: se corrige el tipo predeterminado de retención de IRPF en ingresos: cambiado del 21 al 19."]
["    * 17/02/2015 Corrección aportada por Mangloser en comentarios de 31/1/15 y 5/2/15: añadidas columnas en hoja ingresos y gastos para asignación de trimestres del Modelo 347. Ahora las casillas \"importe trimestral de las operaciones\" en el Modelo 347 se obtienen según la fecha de la factura (columna B) y no según la fecha de registro o contabilización (columna A) como hacemos para el resto de los Modelos (declaraciones)."]
["    * 17/02/2015 Corregidos cálculos en la hoja 'Bienes de inversión' según aportación de Juanan en comentario de fecha 15/02/2015."]
["    * 12/04/2015 Cambios en el diseño de registro del Modelo 303 para adaptarlo a las modificaciones introducidas por la Agencia Tributaria"]
["    * 19/04/2015 Actualizados los cálculos de la casilla 13 del Modelo 130 según la reducción establecida en el artículo 110.3 c) del Reglamentoo del IRPF. Cambio la celda B7 de la hoja DATOS FISCALES para introducir en ella el rendimiento neto del ejercicio anterior (que se utiliza para el cálculo de la reducción). También en la hoja CALCULOS se modifican las fórmulas en la celda L5 y siguientes"]
["    * 19/04/2015 Cambios en el diseño de registro del Modelo 130 para adaptarlo a las modificaciones introducidas por la Agencia Tributaria. Se elimina la macro que imprimía el modelo oficial (ya no existe el módulo de impresión para este modelo)"]
["    * Oct-2016 Mejora en las celdas con validación Hoja Clientes y Proveedores (evitando que salgan muchas filas vacías en el desplegable). Para ello se reescriben los dos procedimientos VBA: Cliente_Guardar y Proveedor_Guardar. También en los módulos VBA de las hojas Clientes y Proveedores se añade código en el evento Change de la primera columna; de forma que ahora se actualiza el rango con nombre en cada introducción de un nuevo nombre. "]
["    * Oct-2016 Para facilitar el alta de clientes o proveedores se incorpora un formulario y un botón en las hojas ingresos y gastos (ver botón en el encabezado de la columna E en ambas hojas). Este botón lanza el formulario."]
["    * Oct-2016 Se incorpora el cálculo de Adquisiciones Intracomunitarias y Entregas Intracomunitarias. Ha sido necesario hacer algunos cambios en la estructura de las hojas Gastos y Cálculos:"]
["        - Hoja Gastos: se añade la columna Z en la que se hay que escribir un número para que una factura (fila) sea identificada como compra intracomunitaria de bienes o servicios (escribir un 1 para bienes, 2 para servicios y 3 para bienes de inversión)."]
["        - Hoja Gastos: se cambia la fórmula en la columna referente al Modelo 347 para exluir del cálculo las operaciones intracomunitarias (que se declaran en el Modelo 349 no incorporado actualmente en la plantilla)"]
["        - Hoja Ingresos: se añade la columna M en la que hay que escribir un número para que esa fila se considere Entrega Intracomunitaria. También se cambia la fórmula en la columna del Modelo 347 para exluir del cálculo estas entregas."]
["        - Hoja Cálculos: se adapta la tabla del Modelo 303 para el cálculo de las casillas 10 y 11 del Modelo 303. También las casillas 36, 37, 38 y 39. Por último, la casilla 59 del Modelo 303 (Entregas Intracomunitarias)."]
["        - Hoja Cálculos: se cambia la tabla del 390 para incorporar las adquisiciones intracomunitarias."]
["        - Hoja Modelo 303: adaptados varios cálculos derivado del cambio en el diseño de la tabla en la Hoja Cálculos (cambio comentado en el punto anterior). También se añade el cálculo de las casillas 10 y 11 del Modelo; y de las casillas 36, 37, 38 y 39."]
["        - Hoja Modelo 303: se añaden filas en torno a la 44, para incorporar la casilla 59 del Modelo (que faltaba): 'Entregas Intracomunitarias de bienes y servicios'."]
["        - Hoja Modelo 390: rediseño para incorporar intracomunitarias."]
["    * Oct-2016 En la Hoja Cálculos, en la tabla del Modelo 347, se amplían los cálculos de las 16 líneas anteriores a 50 líneas (pero en la Hoja del Modelo 347 no se han añadido más páginas, sigue mostrando las primeras 16 líneas)"]
["    * Oct-2016 Posibilidad de ampliar fácilmente las filas de ingresos y gastos mediante un botón en ambas hojas (situado en el encabezado de la columna E). Este botón ejecuta una nueva macro llamada 'Añadir_mas_filas'."]
["    * Oct-2016 Se reduce a 100 filas las tablas de ingresos y gastos; ya que ahora es muy fácil añadir cualquier número de filas cuando se necesiten. Reducir el tamaño del archivo y el número de celdas consideradas en los cálculos aporta ventajas en términos de rapidez de carga del archivo y velocidad en la respuesta de la hoja al editar celdas (aunque en ordenadores potentes puede ser poco perceptible)."]
["    * Oct-2016 Reescrita la macro 'Crear_Hoja_Comprobacion_Modelo_347'. Antes se basaba en autofiltros; ahora utiliza matrices (variables Array)."]
["    * Oct-2016 Cambios en el diseño de registro del Modelo 303 (esto es el fichero .txt para la presentación telemática) para incorporar las Adquisiciones Intracomunitarias (casillas 10, 11 y 36 a 38), y también para incorporar las casilla 59 de Entregas Intracomunitarias."]
["    * Oct-2016 Cambio nombre de las hojas de los modelos: se abrevian eliminando 'Modelo '. El motivo es que ocupen menos las pestañas."]
["    * Oct-2016 En la Hoja Gastos, se añade la columna AA para el cálculo de las casillas 30 y 32 del Modelo 303 y casillas 196 y siguientes en el Modelo 390. Es decir, escribiendo un 1 en esta columna permite diferenciar los bienes de inversión del resto de operaciones interiores. En consecuencia, se adaptan las tablas en la Hoja Cálculos."]
["    * Oct-2016 En la Hoja Gastos, se añade la columna AB para identificar facturas rectificativas o abonos. Lo mismo en la Hoja Ingresos (columna N). En la Hoja Calculos se adapta la tabla del Modelo 303 para el cálculo de las casillas 14 y 15, 25 y 26, 40 y 41 del Modelo. También la tabla del Modelo 390: cálculo de las casillas 29 y 30, 43 y 44, 639 y 62."]
["    * Oct-2016 Adaptado el diseño de registro del Modelo 303 incorporando las rectificativas (casillas 14, 15, 25, 26, 40, 41)."]
["    * Oct-2016 Corrección según comentario Juan L. Rodríguez: \"fórmulas de búsqueda de NIF de clientes y proveedores sólo se centran en los primeros 4 registros. He visto el error en las tablas de ingresos, gastos y cálculos (abajo 347)\""]
["    * Oct-2016 Cambios para incorporar la opción del régimen especial del criterio de caja:"]
["        - Hoja Datos Fiscales: en la fila 11 escribir SI para aplicar este régimen."]
["        - Hoja Modelo 303: incoporación de las casillas 62, 63 y 74, 75"]
["        - Hoja Modelo 390: también incorporadas las casillas relativas al criterio de caja"]
["        - Hojas Ingresos y Gastos: se añade columna de asignación a trimestres según fecha de cobro / pago"]
["        - Hojas Calculos: adaptación de las tablas de cálculo de los Modelos 303 y 390"]
["    * Oct-2016 Incorporado cálculo de las compensaciones en compras a titulares de explotaciones acogidos al régimen especial de agricultura, ganadería y pesca. Ver columna AI en Hoja Gastos, casillas 42 del Modelo 303 y 60, 61 del Modelo 390."]
["    * Oct-2016 Cambios en el diseño de registro del Modelo 303 para incorporar el régimen especial de criterio de caja y las compensaciones a tanto alzado en compras a titulares del régimen especial de agricultura, ganadería y pesca."]
["    * Abril-2017 Adaptado a los cambios realizados por la Agencia Tributaria en el diseño de registro del Modelo 303."]