{"text_format":"2","workbook":"xls","n_sheets":16,"sheets":["Inicio","Principal","Cálculo PNC","Cálculo PNC Comp. Trabajo","ACREDITACION JUBILACIÓN","ACREDITACION INVALIDEZ","JUBILACIÓN","INVALIDEZ","ACREDITACION JUB-INV(2 B)","CALCULO JUB-INV (2 B)","CALCULO JUB-INV (2B 2U)","Modificación del importe","CALCULO JUB-INV (3 B)","Límites €","L.A.R.","L.A.R. 1 año"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":2,"defined_names":264,"comments":32,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Inicio","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[[9,9,10,11],[58,2,59,6],[51,2,52,6],[9,1,10,3],[9,5,10,7],[19,5,20,7],[21,9,22,9]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[{"$nulls":7},2015]
[]
[]
[]
[]
[null,"Cálculo de la PNC para 1 Beneficiario",null,null,null,"Cálculo para 2 beneficiarios",null,null,null,"Importes PNC y Límites de Recursos"]
{"$rows_empty":9}
[{"$nulls":5},"Cálculo para 3 beneficiarios"]
[]
[{"$nulls":9},"(35%)"]

{"sheet":"Principal","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,1,7,6],[5,1,6,7],[9,2,10,6],[57,2,58,6],[50,2,51,6],[15,2,16,6]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"Consejería de Políticas Sociales, Familia, Igualdad y Justicia"]
[]
[null,"Servicio de Prestaciones Sociales",{"$nulls":5},2015,"(35%)"]
[]
[null,null,"Cálculo de la PNC para 1 Beneficiario"]
[]
[]
[]
[]
[]
[null,null,"Cálculo de la PNC para 1 Beneficiario\ncon Actividad Ecónomica"]

{"sheet":"Cálculo PNC","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,2,1,6],[7,2,7,4],[9,2,9,4],[11,2,11,4],[24,0,24,7],[13,2,13,4],[2,2,2,6],[22,0,22,7]],"flags":["formulas_cached_only"]}
[{"$nulls":7},"IMPORTE: "]
[null,null,"Cálculo  PNC 1 Beneficiario"]
[]
[null,"(A)","Rentas",null,"Solicitante (anuales)",null,0]
[]
[null,"(B)","Rentas",null,"UEC (anuales)",null,0]
[]
[null,"(C)","Grado de Consanguinidad",null,null,null,0]
[]
[null,"(D)","Numero miembros UEC",null,null,null,1]
[]
[null,"(E)","Fecha efectos económicos",null,null,null,"2015-01-01"]
[]
[null,null," ",null,null,null,0]
{"$rows_empty":8}
["IMPORTANTE: Este documento contiene MACROS y debe habilitarlas para un correcto funcionamiento del mismo."]
[]
["El resultado obtenido es orientativo y está sujeto a la veracidad de los datos introducidos y a su comprobación por parte de la Administración. "]

{"sheet":"Cálculo PNC Comp. Trabajo","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,2,1,6],[7,2,7,4],[17,0,17,7],[9,2,9,4],[2,2,2,6],[15,0,15,7],[10,2,10,4]],"flags":["formulas_cached_only"]}
[{"$nulls":7},"IMPORTE: ",6561.03]
[null,null,"Cálculo  PNC 1 Beneficiario con Actividad Económica"]
[]
[null,"(A)","Redimientos del Trabajo (anuales)",null,null,null,0]
[]
[null,"(B)","Importe PNC (anual)",null,null,null,0]
[]
[null,"(C)","Fecha efectos económicos",null,null,null,"2015-10-02"]
[]
[null,null," ",null,null,null,0]
[null,null," "]
[null,null,0]
[]
[]
[]
["IMPORTANTE: Este documento contiene MACROS y debe habilitarlas para un correcto funcionamiento del mismo."]
[]
["El resultado obtenido es orientativo y está sujeto a la veracidad de los datos introducidos y a su comprobación por parte de la Administración. "]

{"sheet":"ACREDITACION JUBILACIÓN","index":4,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":true,"merged":[[14,9,15,12],[17,4,17,7],[18,4,18,7],[19,4,19,7],[16,9,16,12],[20,9,20,12],[21,9,21,12],[18,9,18,12],[19,9,19,12],[15,4,15,7],[13,0,13,12],[15,0,15,3],[16,0,16,3],[17,0,17,3],[21,4,21,7],[18,0,18,3],[19,0,19,3],[31,0,32,3],[1,0,1,12],[5,0,5,6],[5,7,6,12],[6,0,6,5],[4,1,4,11],[3,1,3,2],[17,9,17,12],[22,4,22,7],[7,7,7,12],[8,7,8,12],[9,7,9,12],[10,7,10,12],[9,0,9,5],[10,0,10,5],[7,0,7,5],[8,0,8,5],[14,0,14,8],[33,0,33,3],[31,4,32,8],[33,4,33,8],[29,0,29,3],[28,3,28,4],[11,7,11,12],[30,0,30,12],[25,5,25,7],[26,0,26,1],[27,0,27,3],[12,0,12,5],[26,4,26,12],[23,0,23,3],[23,4,23,7],[22,9,22,12],[23,9,23,12],[24,9,24,12],[24,0,24,7],[25,3,25,4],[22,0,22,3],[31,9,33,12],[0,0,0,11],[28,5,28,7],[28,0,28,2],[28,8,28,9],[11,0,11,5],[21,0,21,3],[20,4,20,7],[20,0,20,3],[16,4,16,7]],"flags":["formulas_cached_only"]}
["ACREDITACIÓN DE CARENCIA DE RENTAS"]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)"]
["Tipo de Pensión:","JUBILACIÓN"]
["Nº de Expediente:",{"$nulls":4},"D.N.I.:"," ",null,"Año"]
["Solicitante:"]
["INGRESOS ANUALES",{"$nulls":6},"ANOTACIONES"]
["INGRESOS",{"$nulls":5},"IMPORTE"]
[{"$nulls":6},0]
[" "]
[]
[" "]
[]
["TOTAL (1) : ",{"$nulls":5},0]
["OTROS MIEMBROS DE LA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":8},"ANOTACIONES"]
["MIEMBRO",null,null,null,"CONCEPTO",null,null,null,"IMPORTE"]
{"$rows_empty":8}
["TOTAL (2):",{"$nulls":7},0]
["Ingresos efectivos del solicitante:",null,null,0,null,"Ingresos de los convivientes:",null,null,0,null,null,"Total de Ingresos (1)+(2)=(3):",0]
["Grado de Consanguinidad:",null,1]
["Número de Miembros de la Unidad de Convivencia:",null,null,null,1]
["Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,5108.6]
["Número de beneficiarios de la unidad económica:",null,null,null," "]
["CUMPLIMIENTO DEL REQUISITO"]
["Total Ingresos (3)",null,null,null,"Límite de acumulación recursos aplicable (6)"]
[]
[0,null,null,null,5108.6]

{"sheet":"ACREDITACION INVALIDEZ","index":5,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":true,"merged":[[24,9,24,12],[24,0,24,7],[28,3,28,4],[25,3,25,4],[30,0,30,12],[25,5,25,7],[26,4,26,12],[21,4,21,7],[23,4,23,7],[22,0,22,3],[22,4,22,7],[18,4,18,7],[23,0,23,3],[20,0,20,3],[19,4,19,7],[18,0,18,3],[19,0,19,3],[1,0,1,12],[5,0,5,6],[5,7,6,12],[6,0,6,5],[4,1,4,11],[3,1,3,2],[17,9,17,12],[18,9,18,12],[19,9,19,12],[7,0,7,5],[12,0,12,5],[8,0,8,5],[11,7,11,12],[14,0,14,8],[13,0,13,12],[8,7,8,12],[9,7,9,12],[10,7,10,12],[15,0,15,3],[15,4,15,7],[9,0,9,5],[10,0,10,5],[11,0,11,5],[14,9,15,12],[0,0,0,11],[26,0,26,1],[27,0,27,3],[20,9,20,12],[21,9,21,12],[22,9,22,12],[23,9,23,12],[21,0,21,3],[20,4,20,7],[7,7,7,12],[16,9,16,12],[33,0,33,3],[31,4,32,8],[33,4,33,8],[31,9,33,12],[31,0,32,3],[16,0,16,3],[17,0,17,3],[16,4,16,7],[17,4,17,7]],"flags":["formulas_cached_only"]}
["ACREDITACIÓN DE CARENCIA DE RENTAS"]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)"]
["Tipo de Pensión:","INVALIDEZ"]
["Nº de Expediente:",{"$nulls":4},"D.N.I.:",null,null,"Año"]
["Solicitante:"]
["INGRESOS ANUALES",{"$nulls":6},"ANOTACIONES"]
["INGRESOS",{"$nulls":5},"IMPORTE"]
[]
[]
[]
[]
[]
["TOTAL (1) : ",{"$nulls":5},0]
["OTROS MIEMBROS DE LA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":8},"ANOTACIONES"]
["MIEMBRO",null,null,null,"CONCEPTO",null,null,null,"IMPORTE"]
{"$rows_empty":8}
["TOTAL (2) :",{"$nulls":7},0]
["Ingresos efectivos del solicitante:",null,null,0,null,"Ingresos de los convivientes:",null,null,0,null,null,"Total  (1)+(2)=(3) :",0]
["Grado de Consanguinidad:",null,1]
["Número de Miembros de la Unidad de Convivencia:",null,null,null,1]
["Límite Acumulación Recursos aplicable (L.A.R.): ",null,null,5136.6]
["Número de beneficiarios de la unidad económica:"]
["CUMPLIMIENTO DEL REQUISITO"]
["Total de Ingresos (3)",null,null,null,"Límite de acumulación recursos aplicable (6)"]
[]
[0,null,null,null,5136.6]

{"sheet":"JUBILACIÓN","index":6,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[[34,2,34,12],[39,9,39,10],[39,0,39,1],[46,0,49,12],[40,0,40,1],[41,11,41,12],[41,4,41,5],[41,6,41,7],[36,2,36,3],[38,0,38,2],[25,5,25,7],[33,0,33,1],[26,0,26,1],[27,0,27,3],[25,3,25,4],[31,9,31,10],[32,9,32,10],[31,6,32,8],[33,4,33,5],[26,4,26,12],[33,11,33,12],[33,6,33,8],[31,0,32,1],[31,2,32,3],[33,2,33,3],[30,0,30,12],[31,11,32,12],[23,9,23,12],[17,0,17,3],[18,0,18,3],[19,0,19,3],[21,4,21,7],[23,4,23,7],[23,0,23,3],[21,0,21,3],[20,4,20,7],[20,0,20,3],[22,4,22,7],[18,4,18,7],[19,4,19,7],[18,9,18,12],[19,9,19,12],[22,0,22,3],[22,9,22,12],[16,4,16,7],[20,9,20,12],[21,9,21,12],[10,0,10,5],[11,0,11,5],[12,0,12,5],[14,9,15,12],[17,4,17,7],[15,4,15,7],[14,0,14,8],[15,0,15,3],[16,0,16,3],[16,9,16,12],[17,9,17,12],[33,9,33,10],[1,0,1,12],[5,0,5,6],[5,7,6,12],[6,0,6,5],[4,1,4,11],[3,1,3,2],[7,0,7,5],[8,0,8,5],[11,7,11,12],[13,0,13,12],[7,7,7,12],[8,7,8,12],[9,7,9,12],[10,7,10,12],[9,0,9,5],[24,9,24,12],[24,0,24,7],[0,0,0,11],[41,9,41,10],[31,4,32,5],[28,5,28,7],[28,0,28,2],[28,8,28,9],[29,0,29,3],[28,3,28,4]],"flags":["formulas_cached_only"]}
["CÁLCULO DEL IMPORTE DE LA P.N.C.",{"$nulls":12},true]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)"]
["Tipo de Pensión:","JUBILACIÓN"]
["Nº de Expediente:",{"$nulls":4},"D.N.I.:",null,null,"Periodo desde:",null,"hasta:"]
["Solicitante:"]
["INGRESOS ANUALES",{"$nulls":6},"ANOTACIONES"]
["INGRESOS",{"$nulls":5},"IMPORTE"]
[{"$nulls":6},0]
[" "]
[]
[" "]
[]
["Total1 (Total-1.797,81€) : ",{"$nulls":5},0]
["OTROS MIEMBROS DE LA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":8},"ANOTACIONES"]
["MIEMBRO",null,null,null,"CONCEPTO",null,null,null,"IMPORTE"]
[{"$nulls":8},0]
[{"$nulls":8},0]
[]
[]
[]
[]
[]
[]
["TOTAL (2):",{"$nulls":7},0]
["Ingresos efectivos del solicitante:",null,null,0,null,"Ingresos de los convivientes:",null,null,0,null,null,"Total de Ingresos (1)+(2)=(3):",0]
["Grado de Consanguinidad:",null,0]
["Número de Miembros de la Unidad de Convivencia:",null,null,null,1]
["Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,5136.6]
["Número de beneficiarios de la unidad económica:",null,null,null," "]
["CUANTÍA DE LA PENSIÓN"]
["Ingresos efectivos (3)",null,"Pensión Inicial     5.136,60€-(1)=(4)",null,"Total Ingresos (3)+(4)=(5)",null,"Límite de acumulación recursos aplicable (6)",null,null,"Reducción Pensión",null,"Cuantía Anual Resultante (4)-(7)=(8)"]
[{"$nulls":9},"si (5)>LAR (5)-(6)=(7)"]
[0,null,5136.6,null,5136.6,null,5136.6,null,null,0,null,5136.6]
[]
[]
["Cuantía mensual a reconocer:",null,366.9]
["Fecha de efectos económicos:",null,"2015-01-01"]
["Primer pago: Periodo devengado desde",null,null,null,"hasta",null,null,"Otros Importes:"]
["Atrasos: Periodo desde",null,null,"hasta",null,null,null,"Importe Atrasos:",null,"Mes Actual:",null,null,366.9]
["Deducciones: Periodo desde ",null,null,"hasta",null,null,null,"Importe Deducciones:"]
[{"$nulls":4},"IMPORTE:",null,366.9,null,null," ",null," "]
["Liquidación","Percibió","desde",null,"hasta",null,null,"Importe",null,null,0]
[null,"Percibió","desde",null,"hasta",null,null,"Importe",null,null,0,"Percibió",0]
[null,"Percibió","desde",null,"hasta",null,null,"Importe",null,null,0,"Debió percibir",0]
["Anotaciones","Debió Percibir","desde",null,"hasta",null,null,"Importe",null,null,0,"Diferencia",0]

{"sheet":"INVALIDEZ","index":7,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[[26,4,26,12],[23,0,23,3],[41,11,41,12],[46,0,49,12],[39,0,39,1],[39,9,39,10],[40,0,40,1],[41,4,41,5],[41,6,41,7],[41,9,41,10],[31,11,32,12],[24,9,24,12],[24,0,24,7],[28,3,28,4],[25,3,25,4],[30,0,30,12],[31,6,32,8],[31,9,31,10],[32,9,32,10],[31,4,32,5],[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[21,4,21,7],[25,5,25,7],[16,4,16,7],[23,4,23,7],[1,0,1,12],[5,0,5,6],[5,7,6,12],[6,0,6,5],[4,1,4,11],[3,1,3,2],[11,0,11,5],[7,0,7,5],[12,0,12,5],[8,0,8,5],[11,7,11,12],[8,7,8,12],[9,7,9,12],[10,7,10,12],[9,0,9,5],[10,0,10,5],[38,0,38,2],[36,7,36,8],[14,9,15,12],[17,4,17,7],[18,4,18,7],[19,4,19,7],[16,9,16,12],[17,9,17,12],[18,9,18,12],[19,9,19,12],[31,0,32,1],[31,2,32,3],[35,5,35,6],[20,0,20,3],[22,0,22,3],[22,4,22,7],[33,0,33,1],[33,4,33,5],[33,6,33,8],[33,2,33,3],[36,2,36,3],[36,9,36,11],[0,0,0,11],[33,9,33,10],[33,11,33,12],[34,2,34,11],[26,0,26,1],[27,0,27,3],[21,0,21,3],[20,4,20,7],[35,9,35,11],[13,0,13,12],[7,7,7,12],[20,9,20,12],[21,9,21,12],[22,9,22,12],[23,9,23,12],[14,0,14,8],[15,0,15,3],[15,4,15,7]],"flags":["formulas_cached_only"]}
["CÁLCULO DEL IMPORTE DE LA P.N.C.",{"$nulls":12},true]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)"]
["Tipo de Pensión:","INVALIDEZ"]
["Nº de Expediente:",{"$nulls":4},"D.N.I.:",null,null,"Periodo desde:",null,"hasta:"]
["Solicitante:"]
["INGRESOS ANUALES",{"$nulls":6},"ANOTACIONES"]
["INGRESOS",{"$nulls":5},"IMPORTE"]
[]
[]
[]
[]
[]
["Total1 (Total-1.797,81€) : ",{"$nulls":5},0]
["OTROS MIEMBROS DE LA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":8},"ANOTACIONES"]
["MIEMBRO",null,null,null,"CONCEPTO",null,null,null,"IMPORTE"]
{"$rows_empty":8}
["TOTAL (2) :",{"$nulls":7},0]
["Ingresos efectivos del solicitante:",null,null,0,null,"Ingresos de los convivientes:",null,null,0,null,null,"Total  (1)+(2)=(3) :",0]
["Grado de Consanguinidad:",null,1]
["Número de Miembros de la Unidad de Convivencia:",null,null,null,1]
["Límite Acumulación Recursos aplicable (L.A.R.): ",null,null,5136.6]
["Número de beneficiarios de la unidad económica:"]
["CUANTÍA DE LA PENSIÓN"]
["Ingresos efectivos (3)",null,"Pensión Inicial \n5.136,60€ - (1)=(4)",null,"Total Ingresos (3)+(4)=(5)",null,"Límite de acumulación recursos aplicable (6)",null,null,"Reducción Pensión",null,"Cuantía Anual Resultante (4)-(7)=(8)"]
[{"$nulls":9},"si (5)>L.A.R.) (5)-(6)=(7)"]
[0,null,5136.6,null,5136.6,null,5136.6,null,null,0,null,5136.6]
[]
["Gº Discapacidad:",{"$nulls":4},"Puntos de Baremo :",null,0,null,"Fecha de Caducidad:"]
["Cuantía mensual a reconocer:",null,366.9,null,null,null,"Cuantía Complemento:",0]
["Fecha de efectos económicos:",null,"2015-01-01"]
["Primer pago: Periodo devengado desde",null,null,null,"hasta",null,null,"Otros Importes:"]
["Atrasos: Periodo desde",null,null,"hasta",null,null,null,"Importe Atrasos:",null,"Total Pension Mes:",null,"  ",366.9]
["Deducciones: Periodo desde ",null,null,"hasta",null,null,null,"Importe Deducciones:"]
[{"$nulls":4},"IMPORTE:",null,366.9,null,null," ",null," "]
["Liquidación","Percibió","desde",null,"hasta",null,null,"Importe",null,1,0]
[null,"Percibió","desde",null,"hasta",null,null,"Importe",null,1,0,"Percibió",0]
[null,"Percibió","desde",null,"hasta",null,null,"Importe",null,1,0,"Debió percibir",0]
["Anotaciones","Debió Percibir","desde",null,"hasta",null,null,"Importe",null,1,0,"Diferencia",0]

{"sheet":"ACREDITACION JUB-INV(2 B)","index":8,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":true,"merged":[[26,3,26,4],[32,0,33,3],[32,4,33,8],[26,0,26,2],[26,5,26,7],[29,5,29,7],[17,0,17,3],[13,7,13,12],[14,0,14,13],[15,9,16,13],[17,9,17,13],[25,0,25,7],[34,0,34,3],[34,4,34,8],[27,0,27,1],[28,0,28,3],[29,0,29,2],[29,8,29,9],[31,0,31,13],[30,0,30,3],[29,3,29,4],[32,9,34,13],[26,9,26,12],[25,9,25,13],[24,4,24,7],[24,0,24,3],[18,0,18,3],[18,9,18,13],[19,9,19,13],[20,9,20,13],[18,4,18,7],[19,4,19,7],[23,9,23,13],[23,0,23,3],[23,4,23,7],[24,9,24,13],[22,4,22,7],[22,9,22,13],[22,0,22,3],[8,0,8,5],[9,0,9,5],[12,7,12,12],[10,7,10,12],[21,9,21,13],[17,4,17,7],[13,0,13,5],[15,0,15,8],[16,0,16,3],[12,0,12,5],[9,7,9,12],[20,4,20,7],[19,0,19,3],[6,7,6,13],[7,7,7,12],[6,0,6,6],[7,0,7,5],[20,0,20,3],[16,4,16,7],[3,8,3,9],[5,10,5,11],[3,4,3,5],[3,11,3,12],[11,7,11,12],[10,0,10,5],[11,0,11,5],[2,7,2,13],[3,1,3,2],[2,0,2,6],[4,8,4,13],[0,0,0,12],[21,4,21,7],[21,0,21,3],[8,7,8,12],[1,0,1,13],[4,1,4,6]],"flags":["formulas_cached_only"]}
["ACREDITACION DE CARENCIAS DE RENTAS",{"$nulls":13},false]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)"]
["1º BENEFICIARIO",{"$nulls":6},"2º BENEFICIARIO"]
["Nº de Expediente:",null,null,null,"Fecha Efectos Economicos:",null,null,"Nº de Expediente:",null,null,null,"Fecha Efectos Economicos:"]
["Solicitante:",{"$nulls":6},"Solicitante:"]
["D.N.I.:",null,null,"Periodo desde:",null,"hasta:",null,"D.N.I.:"]
["INGRESOS ANUALES",{"$nulls":6},"INGRESOS ANUALES"]
["INGRESOS",{"$nulls":5},"IMPORTE","INGRESOS",{"$nulls":5},"IMPORTE"]
[]
[" ",{"$nulls":6}," "]
[]
[" ",{"$nulls":6}," "]
[]
["Total1.1",{"$nulls":5},0,"Total1.2",{"$nulls":4},0,0]
["OTROS MIEMBROS DE LA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":8},"ANOTACIONES"]
["MIEMBRO",null,null,null,"CONCEPTO",null,null,null,"IMPORTE"]
{"$rows_empty":8}
["TOTAL (2):",{"$nulls":7},0]
["Ingresos efectivos de los solicitantes:",null,null,0,null,"Ingresos de los convivientes:",null,null,0,"Total de Ingresos (11)+(12)+(2)=(3):",null,null,null,0]
["Grado de Consanguinidad:"]
["Número de Miembros de la Unidad de Convivencia:"]
["Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,1459.92]
["Número de beneficiarios de la unidad económica:"]
["CUMPLIMIENTO DEL REQUISITO"]
["Total Ingresos (3)",null,null,null,"Límite de acumulación recursos aplicable (6)"]
[]
[0,null,null,null,1459.92]

{"sheet":"CALCULO JUB-INV (2 B)","index":9,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":true,"merged":[[51,0,53,13],[36,2,36,3],[38,7,38,8],[34,10,34,11],[34,12,34,13],[36,9,36,10],[39,0,39,2],[34,4,34,5],[43,0,43,6],[43,7,43,13],[34,0,34,1],[42,0,42,1],[42,7,42,8],[35,0,35,5],[0,0,0,12],[21,4,21,7],[21,0,21,3],[22,9,22,13],[6,7,6,13],[7,7,7,12],[6,0,6,6],[18,0,18,3],[18,4,18,7],[19,4,19,7],[7,0,7,5],[20,0,20,3],[20,4,20,7],[19,0,19,3],[9,0,9,5],[10,7,10,12],[11,7,11,12],[32,8,33,9],[33,6,33,7],[32,12,33,13],[32,10,33,11],[23,4,23,7],[29,7,29,9],[25,9,25,13],[26,5,26,7],[25,0,25,7],[29,0,29,2],[26,0,26,2],[29,3,29,4],[10,0,10,5],[11,0,11,5],[12,0,12,5],[17,0,17,3],[1,0,1,13],[4,1,4,6],[3,8,3,9],[5,10,5,11],[3,4,3,5],[3,11,3,12],[2,7,2,13],[3,1,3,2],[2,0,2,6],[4,8,4,13],[9,7,9,12],[8,7,8,12],[8,0,8,5],[12,7,12,12],[32,3,33,3],[17,4,17,7],[13,0,13,5],[15,0,15,8],[16,0,16,3],[16,4,16,7],[13,7,13,12],[14,0,14,13],[15,9,16,13],[17,9,17,13],[32,4,33,5],[32,6,32,7],[24,9,24,13],[24,4,24,7],[18,9,18,13],[19,9,19,13],[22,4,22,7],[22,0,22,3],[21,9,21,13],[23,9,23,13],[23,0,23,3],[29,10,29,11],[27,0,27,1],[26,9,26,12],[26,3,26,4],[28,0,28,2],[32,2,33,2],[32,0,33,1],[40,0,40,1],[40,7,40,8],[20,9,20,13],[31,0,31,13],[35,7,35,12],[39,7,39,9],[30,0,30,2],[24,0,24,3]],"flags":["formulas_cached_only"]}
["CÁLCULO DEL IMPORTE DE LA P.N.C.",{"$nulls":12},"ANEXO I",false]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)",{"$nulls":13},false]
["1º BENEFICIARIO",{"$nulls":6},"2º BENEFICIARIO"]
["Nº de Expediente:",null,null,null,"Tipo de Pensión:",null,"INVALIDEZ","Nº de Expediente:",null,null,null,"Tipo de Pensión:",null,"JUBILACIÓN"]
["Solicitante:",{"$nulls":6},"Solicitante:"]
["D.N.I.:",null,null,"Periodo desde:",null,"hasta:",null,"D.N.I.:"]
["INGRESOS ANUALES",{"$nulls":6},"INGRESOS ANUALES"]
["INGRESOS",{"$nulls":5},"IMPORTE","INGRESOS",{"$nulls":5},"IMPORTE"]
[]
[" "]
[]
[" ",{"$nulls":6}," "]
[]
["Total1.1 : ",{"$nulls":5},0,"Total1.2 : ",{"$nulls":4},0,0]
["OTROS MIEMBROS DE LA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":8},"ANOTACIONES"]
["MIEMBRO",null,null,null,"CONCEPTO",null,null,null,"IMPORTE"]
{"$rows_empty":8}
["TOTAL (2):",{"$nulls":7},0]
["Ingresos efectivos de los solicitantes:",null,null,0,null,"Ingresos de los convivientes:",null,null,0,"Total de Ingresos (11)+(12)+(2)=(3):",null,null,null,0]
["Grado de Consanguinidad:",null,1]
["Número de Miembros de la Unidad de Convivencia: ",null,null,2]
["Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,21830.55,null,null,null,"Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,21830.55]
["Número de beneficiarios de la unidad económica: ",null,null,2]
["CUANTÍA DE LA PENSIÓN"]
["Ingresos efectivos (3)",null,"1º Pensión inicial (4.1)","2º Pensión Inicial (4.2)","Total Ingresos (3)+(4.1)+(4.2)=(5)",null,"Límite de acumulación recursos",null,"Reducción Pensión si (5)>LAR [(5)-(6)]/2=(7)",null,"1º Beneficiario Cuantía Anual Resultante (1.1)-(7)=(8.1)",null,"2º Beneficiario Cuantía Anual Resultante (1.2)-(7)=(8.2)"]
[{"$nulls":6},"aplicable (6)"]
[0,null,4366.11,4366.11,8732.22,null,21830.55,21830.55,0,0,4366.11,null,4366.11]
["1º BENEFICIARIO                                              IMPORTE:",{"$nulls":5},0,"2º BENEFICIARIO                                              IMPORTE:",{"$nulls":5},0]
[{"$nulls":4},"Fecha de Efec. Ec.:",null,"2015-01-01",{"$nulls":4},"Fecha de Efec. Ec.:",null,"2015-01-01"]
[null,null,"2003-01-01",null,null,null,"2003-01-01",null,null,"2003-01-01",null,null,null,"2003-01-01"]
["Cuantía mensual a reconocer:",null,311.87,"Baremo: ",null,null,null,"Cuantía mensual a reconocer:",null,311.87,"Baremo: "]
["Primer pago: Periodo devengado desde",null,null,null,"hasta",null,null,"Primer pago: Periodo devengado desde",null,null,null,"hasta"]
["Atrasos: Periodo desde",null,null,"hasta",null,"Imp. Atrasos:",null,"Atrasos: Periodo desde",null,null,"hasta",null,"Imp. Atrasos:"]
["Mes Actual:",{"$nulls":4},"Otros Imp :",null,"Mes Actual:",{"$nulls":4},"Otros Imp :"]
["Deducciones: Periodo desde ",null,null,"hasta",null,"Imp. Deduc. :",null,"Deducciones: Periodo desde ",null,null,"hasta",null,"Imp. Deduc.:"]
["Liquidación",{"$nulls":6},"Liquidación"]
["Percibió/Debió","desde","hasta","Importe",null,null,"Total","Percibió/Debió","desde","hasta","Importe",null,null,"Total"]
["Percibió ",null,null,null,1,0,null,"Percibió ",null,null,null,1,0]
["Percibió",null,null,null,1,0,null,"Percibió",null,null,null,1,0]
["Percibió",null,null,null,1,0,0,"Percibió",null,null,null,1,0,0]
["Debió Percibir",null,null,null,1,0,0,"Debió Percibir",null,null,null,1,0,0]
["Diferencia",{"$nulls":5},0,"Diferencia",{"$nulls":5},0]
["Anotaciones"]

{"sheet":"CALCULO JUB-INV (2B 2U)","index":10,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":true,"merged":[[51,0,53,13],[32,8,33,8],[32,9,33,9],[32,10,33,10],[32,11,33,11],[32,5,33,6],[34,5,34,6],[32,7,33,7],[39,0,39,2],[43,0,43,6],[7,0,7,5],[43,7,43,13],[42,0,42,1],[42,7,42,8],[35,0,35,5],[40,0,40,1],[40,7,40,8],[35,7,35,12],[39,7,39,9],[27,0,27,1],[32,2,33,2],[32,4,33,4],[0,0,0,12],[36,2,36,3],[38,7,38,8],[34,12,34,13],[36,9,36,10],[26,0,26,2],[26,7,26,9],[17,0,17,1],[24,0,24,1],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[6,7,6,13],[4,8,4,13],[7,7,7,12],[6,0,6,6],[18,9,18,10],[18,5,18,6],[13,0,13,5],[13,7,13,12],[9,0,9,5],[12,7,12,12],[10,7,10,12],[11,7,11,12],[10,0,10,5],[11,0,11,5],[12,0,12,5],[9,7,9,12],[1,0,1,13],[4,1,4,6],[3,8,3,9],[5,10,5,11],[3,4,3,5],[3,11,3,12],[2,7,2,13],[3,1,3,2],[8,0,8,5],[2,0,2,6],[8,7,8,12],[29,3,29,4],[28,7,28,10],[29,7,29,9],[29,10,29,11],[23,5,23,6],[24,5,24,6],[17,5,17,6],[30,7,30,10],[32,3,33,3],[27,7,27,8],[31,0,31,13],[32,12,33,13],[29,0,29,2],[30,0,30,3],[32,1,33,1],[32,0,33,0],[28,0,28,3],[15,7,15,13],[16,7,16,8],[16,9,16,10],[16,12,16,13],[18,7,18,8],[17,9,17,10],[14,0,14,6],[21,7,21,8],[23,2,23,3],[17,7,17,8],[19,5,19,6],[20,5,20,6],[16,5,16,6],[15,0,15,6],[23,7,23,8],[14,7,14,13],[25,0,25,3],[16,0,16,1],[16,2,16,3],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,2,24,3],[25,12,25,13],[25,5,25,6],[25,7,25,10],[23,9,23,10],[24,9,24,10],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[19,7,19,8],[20,7,20,8],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[22,7,22,8],[24,7,24,8],[21,5,21,6],[22,5,22,6],[22,12,22,13],[23,12,23,13],[24,12,24,13]],"flags":["formulas_cached_only"]}
["CÁLCULO DEL IMPORTE DE LA P.N.C.",{"$nulls":13},false]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)"]
["1º BENEFICIARIO",{"$nulls":6},"2º BENEFICIARIO"]
["Nº de Expediente:",null,null,null,"Tipo de Pensión:",null,null,"Nº de Expediente:",null,null,null,"Tipo de Pensión:"]
["Solicitante:",{"$nulls":6},"Solicitante:"]
["D.N.I.:",null,null,"Periodo desde:",null,"hasta:",null,"D.N.I.:"]
["INGRESOS ANUALES",{"$nulls":6},"INGRESOS ANUALES"]
["INGRESOS",{"$nulls":5},"IMPORTE","INGRESOS",{"$nulls":5},"IMPORTE"]
[]
[" ",{"$nulls":6}," "]
[]
[" ",{"$nulls":6}," "]
[]
["Total1.1",{"$nulls":5},0,"Total1.2",{"$nulls":4},0,0]
[" MIEMBROS DE LA PRIMERA UNIDAD ECONÓMICA IMPUTABLES",{"$nulls":6}," MIEMBROS DE LA SEGUNDA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":6},"INGRESOS ANUALES "]
["MIEMBRO",null,"CONCEPTO",null,"IMPORTE","ANOTACIONES",null,"MIEMBRO",null,"CONCEPTO",null,"IMPORTE","ANOTACIONES"]
{"$rows_empty":8}
["TOTAL (2.1):",null,null,null,0,null,null,"TOTAL (2.2):",null,null,null,0]
["Total de Ingresos (1.1)+(1.2)+(2.1)=(3.1):",null,null,0,null,null,null,"Total de Ingresos (1.1)+(1.2)+(2.2)=(3.2):",null,null,0]
["Grado de Consanguinidad:",{"$nulls":6},"Grado de Consanguinidad:"]
["Número de Miembros de la Unidad de Convivencia:",{"$nulls":6},"Número de Miembros de la Unidad de Convivencia:"]
["Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,1540.98,null,null,null,"Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,1540.98]
["Número de beneficiarios de la unidad económica:",{"$nulls":6},"Número de beneficiarios de la unidad económica:"]
["CUANTÍA DE LA PENSIÓN"]
["Ingresos efectivos (3.1)","1º Pensión inicial (4.1)","Total Ingresos (3.1)+(4.1)+(4.2)=(5.1)","LAR aplicable (6.1)","Reducción [(5.1)-(6.1)]/2=(7.1)","1º Beneficiario Cuantía Anual Resultante (1.1)-(7.1)=(8.1)",null,"Ingresos efectivos (3.2)","2º Pensión inicial (4.2)","Total Ingresos (3.2)+(4.2)+(4.1)=(5.2)","LAR aplicable (6.2)","Reducción [(5.2)-(6.2)]/2=(7.2)","2º Beneficiario Cuantía Anual Resultante (4.2)-(7.2)=(8.2)"]
[]
[0,4366.11,8732.22,1540.98,3595.6200000000003,1284.15,null,0,4366.11,8732.22,1540.98,3595.6200000000003,1284.15]
["1º BENEFICIARIO                                              IMPORTE:",{"$nulls":5},0,"2º BENEFICIARIO                                              IMPORTE:",{"$nulls":5},0]
[{"$nulls":4},"Fecha de Efec. Ec.:",null,"2015-01-01",{"$nulls":4},"Fecha de Efec. Ec.:",null,"2015-01-01"]
[null,null,"2003-01-01",null,null,null,"2003-01-01",null,null,"2003-01-01",null,null,null,"2003-01-01"]
["Cuantía mensual a reconocer:",null,91.73,"Complemento:",null,"Total Pensión:",null,"Cuantía mensual a reconocer:",null,91.73,"Complemento:",null,"Total Pensión:"]
["Primer pago: Periodo devengado desde",null,null,null,"hasta",null,null,"Primer pago: Periodo devengado desde",null,null,null,"hasta"]
["Atrasos: Periodo desde",null,null,"hasta",null,"Imp. Atrasos:",null,"Atrasos: Periodo desde",null,null,"hasta",null,"Imp. Atrasos:"]
["Mes Actual:",{"$nulls":4},"Otros Imp :",null,"Mes Actual:",{"$nulls":4},"Otros Imp :"]
["Deducciones: Periodo desde ",null,null,"hasta",null,"Imp. Deduc. :",null,"Deducciones: Periodo desde ",null,null,"hasta",null,"Imp. Deduc.:"]
["Liquidación",{"$nulls":6},"Liquidación"]
["Percibió/Debió","desde","hasta","Importe",null,null,"Total","Percibió/Debió","desde","hasta","Importe",null,null,"Total"]
["Percibió ",null,null,null,1,0,null,"Percibió ",null,null,null,1,0]
["Percibió",null,null,null,1,0,null,"Percibió",null,null,null,1,0]
["Percibió",null,null,null,1,0,0,"Percibió",null,null,null,1,0,0]
["Debió Percibir",null,null,null,1,0,0,"Debió Percibir",null,null,null,1,0,0]
["Diferencia",{"$nulls":5},0,"Diferencia",{"$nulls":5},0]
["Anotaciones"]

{"sheet":"Modificación del importe","index":11,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":true,"merged":[[16,0,16,12],[26,0,29,12],[21,4,21,5],[21,6,21,7],[21,9,21,10],[19,5,19,6],[19,9,19,11],[21,11,21,12],[20,7,20,8],[19,2,19,3],[17,0,17,6],[18,0,18,6],[17,7,17,12],[18,7,18,12],[19,7,19,8],[7,0,7,5],[10,7,10,12],[13,5,13,9],[13,10,13,12],[11,0,11,5],[9,0,9,5],[9,7,9,12],[14,0,14,4],[14,5,14,9],[14,10,14,12],[13,0,13,4],[12,10,12,12],[15,5,15,9],[15,10,15,12],[15,0,15,4],[0,0,0,11],[10,0,10,5],[6,0,6,5],[12,0,12,4],[12,5,12,9],[4,0,4,12],[6,7,6,12],[7,7,7,12],[8,7,8,12],[1,0,1,12],[5,0,5,5],[3,1,3,11],[2,1,2,2],[2,5,2,6],[5,7,5,12],[8,0,8,5]],"flags":["formulas_cached_only"]}
["COMPATIBILIDAD POR INICIO DE ACTIVIDAD LUCRATIVA",{"$nulls":25}," "]
["(Ley    8/2005)"]
["Nº de Expediente:",null,null,null,"D.N.I.:",null,null,null,"Periodo desde:",null,"hasta:"]
["Solicitante:"]
["RENTAS A COMPATIBILIZAR"]
["INGRESOS ANUALES",{"$nulls":5},"IMPORTE","ANOTACIONES"]
[]
[{"$nulls":6}," "]
[]
[]
[]
["TOTAL (1) : ",{"$nulls":5},0]
["Pensión Inicial Anual: (2)",{"$nulls":4},"Rentas + Pensión :  (1) + (2) = (3) ",{"$nulls":4},"(3) - IPREM = (4)"]
[{"$nulls":5},0,{"$nulls":4},-6390.13]
["Si (4) <= 0 Pensión Integra ",{"$nulls":4},"Si (4) > 0, Reducción de Pensión  50%(4)=(5) ",{"$nulls":4},"Cuantía Anual Resultante: (2) - (5) = (6)"]
["NO PROCEDE REDUCCIÓN"]
["COMPROBACIÓN DE COMPATIBILIDAD"]
["Si (6) + (1) > 1,5 * IPREM",{"$nulls":6},"Si (6) + (1) < = 1,5 * IPREM"]
[]
["Cuantía mensual a reconocer:",null,0]
["Fecha de efectos económicos:",null,"2015-01-09"]
[{"$nulls":4},"IMPORTE:",null,0,null,null," ",null," "]
["Liquidación","Percibió","desde",null,"hasta",null,null,"Importe",null,1,0]
[null,"Percibió","desde",null,"hasta",null,null,"Importe",null,1,0,"Percibió",0]
[null,"Percibió","desde",null,"hasta",null,null,"Importe",null,1,0,"Debió percibir",0]
["Anotaciones","Debió Percibir","desde",null,"hasta",null,null,"Importe",null,1,0,"Diferencia",0]

{"sheet":"CALCULO JUB-INV (3 B)","index":12,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":true,"merged":[[12,5,12,8],[6,5,6,9],[13,5,13,8],[10,0,10,3],[11,0,11,3],[11,5,11,8],[0,0,0,14],[1,0,1,14],[2,0,2,4],[2,5,2,9],[2,10,2,14],[3,11,3,12],[3,1,3,2],[6,10,6,14],[10,5,10,8],[3,6,3,7],[6,0,6,4],[7,0,7,3],[9,0,9,3],[7,5,7,8],[8,5,8,8],[9,5,9,8],[8,0,8,3],[19,9,19,14],[20,9,20,14],[21,9,21,14],[7,10,7,13],[8,10,8,13],[9,10,9,13],[10,10,10,13],[11,10,11,13],[12,10,12,13],[13,10,13,13],[15,9,16,14],[17,9,17,14],[14,0,14,14],[12,0,12,3],[13,0,13,3],[17,0,17,3],[15,0,15,8],[16,0,16,3],[16,4,16,7],[17,4,17,7],[23,4,23,7],[22,4,22,7],[22,0,22,3],[23,0,23,3],[18,0,18,3],[18,4,18,7],[21,4,21,7],[21,0,21,3],[20,0,20,3],[20,4,20,7],[25,9,25,12],[24,4,24,7],[24,0,24,3],[25,0,25,7],[18,9,18,14],[25,13,25,14],[28,0,28,14],[19,4,19,7],[19,0,19,3],[27,6,27,9],[27,3,27,4],[27,0,27,2],[23,9,23,14],[24,9,24,14],[22,9,22,14],[26,0,26,1],[45,0,47,14],[31,9,31,10],[29,9,30,10],[29,11,30,12],[31,11,31,12],[31,4,31,5],[29,6,30,6],[29,7,30,8],[29,4,30,5],[31,7,31,8],[29,0,30,0],[29,1,30,1],[29,2,30,2],[29,13,30,14],[29,3,30,3],[31,13,31,14]],"flags":["formulas_cached_only"]}
["CÁLCULO DEL IMPORTE DE LA P.N.C.",{"$nulls":13},false,false]
["(R.D.Legislativo 1/94 de 20 de Junio, BOE 29-6-94 y R.D. 357/91 de 15 de Marzo, BOE 22-12-90)"]
["1º BENEFICIARIO",{"$nulls":4},"2º BENEFICIARIO",{"$nulls":4},"3º BENEFICIARIO"]
["Nº de Expediente:",{"$nulls":4},"Nº de Expediente:",{"$nulls":4},"Nº de Expediente:"]
["Solicitante:",{"$nulls":4},"Solicitante:",{"$nulls":4},"Solicitante:"]
["D.N.I.:",null,"Periodo:",null,null,"D.N.I.:",{"$nulls":4},"D.N.I.:"]
["INGRESOS ANUALES",{"$nulls":4},"INGRESOS ANUALES",{"$nulls":4},"INGRESOS ANUALES"]
["INGRESOS",null,null,null,"IMPORTE","INGRESOS",null,null,null,"IMPORTE","INGRESOS",null,null,null,"IMPORTE"]
[]
[" ",{"$nulls":4}," ",{"$nulls":4}," "]
[]
[" ",{"$nulls":4}," ",{"$nulls":4}," "]
[]
["Total1.1",null,null,null,0,"Total1.2",null,null,null,0,"Total1.3",null,null,null,0]
["OTROS MIEMBROS DE LA UNIDAD ECONÓMICA IMPUTABLES"]
["INGRESOS ANUALES ",{"$nulls":8},"ANOTACIONES"]
["MIEMBRO",null,null,null,"CONCEPTO",null,null,null,"IMPORTE"]
{"$rows_empty":8}
["TOTAL (2):",{"$nulls":7},0,"TOTAL INGRESOS (1+2+3+4):   ",null,null,null,0]
["Grado de Consanguinidad:",{"$nulls":5},"Número de Miembros de la Unidad de Convivencia:",null,null,null,3]
["Límite de Acumulación Recursos aplicable (L.A.R.):",null,null,12327.84,null,null,"Número de beneficiarios de la unidad económica:",null,null,null,3]
["CUANTÍA DE LA PENSIÓN"]
["Ingresos efectivos (3)","1º Pensión inicial (4.1)","2º Pensión Inicial (4.2)","3º Pensión Inicial (4.3)","Total Ingresos (3)+(4.1)+(4.2)=(5)",null,"L.A.R.","Reducción Pensión si (5)>LAR [(5)-(6)]/3=(7)",null,"1º Beneficiario Cuantía Anual Resultante (1.1)-(7)=(8.1)",null,"2º Beneficiario Cuantía Anual Resultante (1.2)-(7)=(8.2)",null,"3º Beneficiario Cuantía Anual Resultante (1.3)-(7)=(8.2)"]
[]
[0,4109.28,4109.28,4109.28,12327.84,null,12327.84,0,null,4109.28,null,4109.28,null,4109.28]
["BENEFICIARIO 1º",{"$nulls":8},"Liquidación"]
["Fecha Efectos:","2015-01-01",null,null,"Cuantía mesual a reconocer",null,293.52,null,null,"  Percibió",null,null,null,1,0]
["Primer Pago:",{"$nulls":8},"  Debió Percibir",null,null,null,1,0]
["Atrasos:",null,null,"Importe",null,"Mes Actual",null,"TOTAL",293.52,"  Diferencia",{"$nulls":4},0]
["BENEFICIARIO 2º",{"$nulls":8},"Liquidación"]
["Fecha Efectos:","2015-01-01",null,null,"Cuantía mesual a reconocer",null,293.52,null,null,"  Percibió",null,null,null,1,0]
["Primer Pago:",{"$nulls":8},"  Debió Percibir",null,null,null,1,0]
["Atrasos:",null,null,"Importe",null,"Mes Actual",null,"TOTAL",293.52,"  Diferencia",{"$nulls":4},0]
["BENEFICIARIO 3º",{"$nulls":8},"Liquidación"]
["Fecha Efectos:","2015-01-01",null,null,"Cuantía mesual a reconocer",null,293.52,null,null,"  Percibió",null,null,null,1,0]
["Primer Pago:",{"$nulls":8},"  Debió Percibir",null,null,null,1,0]
["Atrasos:",null,null,"Importe",null,"Mes Actual",null,"TOTAL",293.52,"  Diferencia",{"$nulls":4},0]
["Anotaciones"]

{"sheet":"Límites €","index":13,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":true,"merged":[[20,7,21,8],[20,4,21,6],[20,1,21,3],[1,15,3,15],[20,15,22,15],[19,0,19,15],[1,1,2,3],[20,0,22,0],[0,0,0,15],[1,11,2,12],[1,13,2,14],[20,11,21,12],[20,13,21,14],[1,9,2,10],[1,0,3,0],[20,9,21,10],[1,7,2,8],[1,4,2,6]],"flags":["formulas_cached_only"]}
["Moneda Euro"]
["AÑO","Máxima",null,null,"Mínima",null,null,"Comp. 3ª",null,"2 beneficiarios",null,"3 beneficiarios",null,"4 beneficiarios",null,"AÑO"]
[]
[null,"Anual","Mensual","+Comp. 3ª","Anual","Mensual","+Comp. 3ª","Anual","Mensual","Anual","Mensual","Anual","Mensual","Anual","Mensual"]
[2002,3621.52,258.68,388.02,905.38,64.67,194.01,1810.76,129.34,3078.2900000000004,219.88,2897.21,206.94,2806.6800000000003,200.48,2002]
[2003,3762.78,268.77,403.15999999999997,940.7,67.19,201.57999999999998,1881.39,134.39,3198.3700000000003,228.45999999999998,3010.23,215.01999999999998,2916.1600000000003,208.29999999999998,2003]
[2004,3868.2,276.3,414.45000000000005,967.05,69.08,207.23000000000002,1934.1,138.15,3287.97,234.85999999999999,3094.5600000000004,221.04,2997.86,214.13,2004]
[2005,4043.06,288.79,433.19,1010.77,72.2,216.59999999999997,2021.53,144.39999999999998,3436.6000000000004,245.47,3234.4500000000003,231.03,3133.3700000000003,223.81,2005]
[2006,4221.7,301.55,452.33000000000004,1055.43,75.39,226.17000000000002,2110.8500000000004,150.78,3588.4500000000003,256.32,3377.36,241.24,3271.82,233.7,2006]
[2007,4374.02,312.43,468.65,1093.51,78.11,234.32999999999998,2187.01,156.22,3717.92,265.57,3499.21,249.94,3389.86,242.13,2007]
[2008,4598.16,328.44,492.65999999999997,1149.54,82.11,246.32999999999998,2299.0800000000004,164.22,3908.44,279.17,3678.53,262.75,3563.57,254.54,2008]
[2009,4708.62,336.33,504.5,1177.16,84.08,252.25,2354.3100000000004,168.17,4002.3300000000004,285.88,3766.89,269.06,3649.1800000000003,260.65999999999997,2009]
[2010,4755.8,339.7,509.54999999999995,1188.95,84.93,254.78,2377.9,169.85,4042.43,288.75,3804.64,271.76,3685.75,263.27,2010]
[2011,4866.4,347.59999999999997,521.4,1216.6,86.9,260.70000000000005,2433.2000000000003,173.8,4136.4400000000005,295.46,3893.12,278.08,3771.46,269.39,2011]
[2012,5007.8,357.7,536.55,1251.95,89.43,268.28,2503.9,178.85,4256.63,304.05,4006.24,286.15999999999997,3881.05,277.21999999999997,2012]
[2013,5108.6,364.9,547.3499999999999,1277.15,91.23,273.68,2554.3,182.45,4342.31,310.17,4086.88,291.92,3959.17,282.8,2013]
[2014,5122.6,365.9,548.8499999999999,1280.65,91.48,274.43,2561.3,182.95,4354.21,311.02,4098.08,292.71999999999997,3970.0200000000004,283.57,2014]
[2015,5136.6,366.9,550.3499999999999,1284.15,91.73,275.18,2568.3,183.45,4366.11,311.87,4109.280000000001,293.52,3980.8700000000003,284.34999999999997,2015]
[]
["Moneda peseta"]
["AÑO","Máxima",null,null,"Mínima",null,null,"Comp. 3ª",null,"2 beneficiarios",null,"3 beneficiarios",null,"4 beneficiarios",null,"AÑO"]
[]
[null,"Anual","Mensual","+Comp. 3ª","Anual","Mensual","+Comp. 3ª","Anual","Mensual","Anual","Mensual","Anual","Mensual","Anual","Mensual"]
[2002,602570,43040.71,64561.06999999999,150642.5,10760.18,32280.539999999997,301285,21520.359999999997,512184.5,36584.61,482056,34432.57,466991.75,33356.55,2002]
[2003,626074,44719.57,67079.36,156518.5,11179.89,33539.67999999999,313037,22359.789999999997,532162.9,38011.64,500859.2,35775.66,485207.35,34657.670000000006,2003]
[2004,643614,45972.43,68958.64,160903.5,11493.11,34479.32,321807,22986.21,547071.9,39076.56,514891.2,36777.94,498800.85,35628.63,2004]
[2005,672709,48050.64,72075.95999999999,168177.25,12012.66,36037.979999999996,336354.5,24025.32,571802.65,40843.05,538167.2000000001,38440.51,521349.475,37239.25,2005]
[2006,702432,50173.71,75260.56999999999,175608,12543.43,37630.28999999999,351216,25086.859999999997,597067.2,42647.66,561945.6,40138.97,544384.8,38884.630000000005,2006]
[2007,727776,51984,77976,181944,12996,38988,363888,25992,618609.6,44186.4,582220.7999999999,41587.200000000004,564026.3999999999,40287.6,2007]
[2008,765069,54647.79,81971.68,191267.25,13661.95,40985.84,382534.5,27323.89,650308.6499999999,46450.62,612055.2,43718.23,592928.475,42352.03,2008]
[2009,783448,55960.57,83940.86,195862,13990.14,41970.42999999999,391724,27980.289999999997,665930.8,47566.490000000005,626758.4,44768.46,607172.2,43369.44,2009]
[2010,791299,56521.36,84782.04,197824.75,14130.34,42391.02,395649.5,28260.679999999997,672604.1499999999,48043.15,633039.2,45217.090000000004,613256.725,43804.05,2010]
[2011,809701,57835.79,86753.68,202425.25,14458.95,43376.84,404850.5,28917.89,688245.85,49160.420000000006,647760.7999999999,46268.630000000005,627518.2749999999,44822.73,2011]
[2012,833228,59516.29,89274.43,208307,14879.07,44637.21,416614,29758.14,708243.8,50588.84,666582.4,47613.03,645751.7,46125.12,2012]
[2013,850000,60714.29,91071.43,212500,15178.57,45535.71,425000,30357.14,722500,51607.14,680000,48571.43,658750,47053.57,2012]
[2014,852329,60880.64,91320.95999999999,213082.25,15220.16,45660.479999999996,426164.5,30440.32,724479.6499999999,51748.55,681863.2,48704.51,660554.975,47182.5,2012]
[2015,854658,61047,91570.5,213664.5,15261.75,45785.25,427329,30523.5,726459.3,51889.95,683726.4,48837.6,662359.95,47311.43,2012]

{"sheet":"L.A.R.","index":14,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,9,3,9],[2,16,3,16],[2,8,3,8],[2,7,3,7],[2,10,3,10],[2,12,3,12],[2,11,3,11],[2,14,3,14],[2,13,3,13],[2,15,3,15],[2,5,3,5],[2,2,3,2],[2,6,3,6],[35,0,36,0],[29,0,30,0],[32,0,33,0],[23,0,24,0],[26,0,27,0],[31,0,31,4],[34,0,34,4],[28,0,28,4],[22,0,22,4],[25,0,25,4],[17,0,18,0],[20,0,21,0],[19,0,19,4],[16,0,16,4],[2,3,3,3],[2,4,3,4],[4,0,4,4],[7,0,7,4],[2,1,3,1],[2,0,3,0],[5,0,6,0],[8,0,9,0],[11,0,12,0],[14,0,15,0],[1,0,1,4],[10,0,10,4],[13,0,13,4]],"flags":["formulas_cached_only"]}
["Convivientes","Consanguinidad",2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015]
[]
[1,"Pensión Anual",3621.52,3762.78,3868.2,4043.06,4221.7,4374.02,4598.16,4708.62,4755.8,4866.4,5007.8,5108.6,5122.6,5136.6]
[]
[]
[2,"Grado 1",15391.45,15991.83,16439.85,17183,17942.23,18589.579999999998,19542.179999999997,20011.629999999997,20212.15,20682.199999999997,21283.15,21711.55,21771.05,21830.55]
[null,"Grado 2",6156.58,6396.7300000000005,6575.9400000000005,6873.2,7176.889999999999,7435.83,7816.87,8004.65,8084.860000000001,8272.88,8513.26,8684.62,8708.42,8732.220000000001]
[]
[3,"Grado 1",21729.1,22576.7,23209.2,24258.35,25330.2,26244.1,27588.95,28251.7,28534.8,29198.4,30046.8,30651.6,30735.6,30819.6]
[null,"Grado 2",8691.64,9030.68,9283.68,9703.34,10132.08,10497.64,11035.58,11300.68,11413.920000000002,11679.36,12018.720000000001,12260.640000000001,12294.240000000002,12327.84]
[]
[4,"Grado 1",28066.75,29161.579999999998,29978.55,31333.699999999997,32718.179999999997,33898.630000000005,35635.73,36491.78,36857.450000000004,37714.6,38810.450000000004,39591.65,39700.15,39808.65]
[null,"Grado 2",11226.7,11664.630000000001,11991.420000000002,12533.48,13087.27,13559.45,14254.29,14596.71,14742.98,15085.84,15524.18,15836.660000000002,15880.060000000001,15923.460000000001]
[]
[5,"Grado 1",34404.4,35746.45,36747.9,38409.05,40106.15,41553.15,43682.5,44731.85,45180.1,46230.8,47574.1,48531.700000000004,48664.7,48797.7]
[null,"Grado 2",13761.76,14298.580000000002,14699.16,15363.619999999999,16042.46,16621.260000000002,17473,17892.74,18072.04,18492.32,19029.64,19412.68,19465.88,19519.08]
[]
[6,"Grado 1",40742.05,42331.33,43517.25,45484.4,47494.130000000005,49207.68,51729.28,52971.93,53502.75,54747,56337.75,57471.75,57629.25,57786.75]
[null,"Grado 2",16296.82,16932.530000000002,17406.9,18193.76,18997.65,19683.07,20691.71,21188.77,21401.100000000002,21898.800000000003,22535.1,22988.700000000004,23051.700000000004,23114.700000000004]
[]
[7,"Grado 1",47079.7,48916.200000000004,50286.6,52559.75,54882.1,56862.2,59776.05,61212,61825.4,63263.200000000004,65101.4,66411.8,66593.8,66775.8]
[null,"Grado 2",18831.88,19566.48,20114.640000000003,21023.9,21952.84,22744.88,23910.420000000002,24484.8,24730.16,25305.28,26040.56,26564.72,26637.520000000004,26710.32]
[]
[8,"Grado 1",53417.35,55501.08,57055.95,59635.1,62270.08,64516.73,67822.83,69452.08,70148.05,71779.4,73865.05,75351.85,75558.35,75764.85]
[null,"Grado 2",21366.94,22200.43,22822.38,23854.04,24908.030000000002,25806.69,27129.13,27780.83,28059.22,28711.760000000002,29546.02,30140.740000000005,30223.340000000004,30305.940000000002]
[]
[9,"Grado 1",59755,62085.95,63825.3,66710.45,69658.05,72171.25,75869.6,77692.15,78470.7,80295.59999999999,82628.7,84291.9,84522.9,84753.9]
[null,"Grado 2",23902,24834.38,25530.120000000003,26684.18,27863.22,28868.5,30347.84,31076.86,31388.280000000002,32118.239999999998,33051.48,33716.76,33809.16,33901.560000000005]
[]
[10,"Grado 1",66092.65,68670.83,70594.65,73785.8,77046.03,79825.78,83916.37999999999,85932.23,86793.35,88811.8,91392.35,93231.95,93487.45,93742.95]
[null,"Grado 2",26437.06,27468.33,28237.860000000004,29514.32,30818.41,31930.31,33566.55,34372.89,34717.340000000004,35524.72,36556.94,37292.780000000006,37394.98,37497.18]
[]
[11,"Grado 1",72430.3,75255.7,77364,80861.15,84434,87480.29999999999,91963.15,94172.3,95116,97328,100156,102172,102452,102732]
[null,"Grado 2",28972.12,30102.280000000002,30945.600000000002,32344.46,33773.6,34992.119999999995,36785.259999999995,37668.920000000006,38046.40000000001,38931.200000000004,40062.4,40868.8,40980.8,41092.8]
[]
[12,"Grado 1",78767.95,81840.58,84133.35,87936.5,91821.98,95134.83,100009.93,102412.37999999999,103438.65,105844.2,108919.65,111112.05,111416.55,111721.05]
[null,"Grado 2",31507.18,32736.230000000003,33653.340000000004,35174.6,36728.79,38053.92999999999,40003.97,40964.950000000004,41375.46000000001,42337.68,43567.86,44444.82,44566.62,44688.420000000006]

{"sheet":"L.A.R. 1 año","index":15,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":true,"merged":[[22,1,22,4],[22,5,22,8],[23,1,23,4],[23,5,23,8],[20,1,20,4],[20,5,20,8],[21,1,21,4],[21,5,21,8],[18,1,18,4],[18,5,18,8],[19,1,19,4],[19,5,19,8],[16,1,16,4],[16,5,16,8],[17,1,17,4],[17,5,17,8],[15,1,15,4],[15,5,15,8],[12,0,13,8],[11,1,11,4],[2,1,2,4],[3,5,3,8],[4,5,4,8],[8,1,8,4],[9,1,9,4],[10,1,10,4],[2,5,2,8],[14,1,14,4],[14,5,14,8],[1,0,1,8],[0,5,0,9],[11,5,11,8],[0,0,0,1],[0,3,0,4],[3,1,3,4],[4,1,4,4],[10,5,10,8],[7,1,7,4],[5,1,5,4],[6,1,6,4],[9,5,9,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8]],"flags":["formulas_cached_only"]}
[null,null,"AÑO",2015,null,"   <--    Teclea el año que desees consultar"]
[" "]
["Nº Convivientes","L.A.R. € - Grado de Consanguinidad 1",null,null,null,"L.A.R. € - Grados de Consanguinidad 2"]
[2,21830.55,null,null,null,8732.220000000001,null,null,null,2]
[3,30819.6,null,null,null,12327.84,null,null,null,3]
[4,39808.65,null,null,null,15923.460000000001,null,null,null,4]
[5,48797.7,null,null,null,19519.08,null,null,null,5]
[6,57786.75,null,null,null,23114.700000000004,null,null,null,6]
[7,66775.8,null,null,null,26710.32,null,null,null,7]
[8,75764.85,null,null,null,30305.940000000002,null,null,null,8]
[9,84753.9,null,null,null,33901.560000000005,null,null,null,9]
[10,93742.95,null,null,null,37497.18,null,null,null,10]
[]
[]
["Nº Convivientes","L.A.R. Ptas - Grado de Consanguinidad 1",null,null,null,"L.A.R. Ptas - Grados de Consanguinidad 2"]
[2,3632298,null,null,null,1452919,null,null,null,2]
[3,5127950,null,null,null,2051180,null,null,null,3]
[4,6623602,null,null,null,2649441,null,null,null,4]
[5,8119254,null,null,null,3247702,null,null,null,5]
[6,9614906,null,null,null,3845962,null,null,null,6]
[7,11110558,null,null,null,4444223,null,null,null,7]
[8,12606210,null,null,null,5042484,null,null,null,8]
[9,14101862,null,null,null,5640745,null,null,null,9]
[10,15597514,null,null,null,6239006,null,null,null,10]