{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["PAGO","PAGO (2)","DATOS","PROVINCIAS","Hoja1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PAGO","index":0,"n_rows":74,"n_cols":23,"rows_kept":74,"cut":false,"hidden":false,"merged":[[8,5,8,6],[11,1,11,8],[11,10,11,17],[11,19,11,23],[8,13,8,19],[28,2,28,13],[14,1,14,5],[14,7,14,12],[14,14,14,23],[22,2,23,13],[22,14,23,14],[22,15,23,16],[27,15,27,16],[27,19,27,20],[22,0,23,1],[22,19,23,21],[28,15,28,16],[24,17,24,18],[25,17,25,18],[26,17,26,18],[27,17,27,18],[26,15,26,16],[18,7,18,8],[18,10,18,23],[24,2,24,13],[25,2,25,13],[26,2,26,13],[30,2,30,13],[36,19,36,20],[37,19,37,20],[36,22,36,23],[35,2,35,13],[29,2,29,13],[31,2,31,13],[27,2,27,13],[32,2,32,13],[37,22,37,23],[37,2,37,13],[36,15,36,16],[37,15,37,16],[36,17,36,18],[28,19,28,20],[28,22,28,23],[28,17,28,18],[29,22,29,23],[31,22,31,23],[32,19,32,20],[57,6,57,23],[59,15,59,24],[72,18,72,23],[59,1,59,4],[59,5,59,8],[59,9,59,12],[59,13,59,14],[40,6,40,9],[34,22,34,23],[35,22,35,23],[37,17,37,18],[50,2,50,6],[50,7,50,10],[47,21,47,23],[48,13,48,20],[48,21,48,23],[49,21,49,23],[50,13,50,20],[50,21,50,23],[52,21,52,23],[53,21,53,23],[39,17,39,20],[42,1,44,23],[32,22,32,23],[33,22,33,23],[32,17,32,18],[33,17,33,18],[34,17,34,18],[35,17,35,18],[29,17,29,18],[18,1,18,6],[51,12,51,23],[22,22,23,23],[24,22,24,23],[25,22,25,23],[26,22,26,23],[30,22,30,23],[27,22,27,23],[24,19,24,20],[25,19,25,20],[26,19,26,20],[35,15,35,16],[22,17,23,18],[33,15,33,16],[34,15,34,16],[24,15,24,16],[25,15,25,16],[33,19,33,20],[34,19,34,20],[35,19,35,20],[29,19,29,20],[30,15,30,16],[31,15,31,16],[30,19,30,20],[31,19,31,20],[36,2,36,13],[33,2,33,13],[34,2,34,13],[29,15,29,16],[32,15,32,16],[30,17,30,18],[31,17,31,18]]}
[]
[]
[]
[]
[]
[null,"DATOS ALUMNO/A"]
[]
[null,"Documento"]
[null,"de identidad:",null,null,null,null,null,null,null,null,"Número:"]
[]
[null,"Apellido1:",null,null,null,null,null,null,null,null,"Apellido 2:",null,null,null,null,null,null,null,null,"Nombre:"]
[]
[]
[null,"Télefono fijo:",null,null,null,null,null,"Télefono móvil:",null,null,null,null,null,null,"e-mail"]
[]
[]
[null,"CURSO EN EL QUE SE MATRICULA"]
[null,"NIVEL",null,null,null,null,null,null,null,null,"TÍTULO:"]
[null,"C.F. GRADO SUPERIOR",null,null,null,null,null,null,null,null,"Integración Social"]
[]
[null,"MODULOS EN LOS QUE SE MATRICULA:"]
[]
["Curso",null,"Módulo",null,null,null,null,null,null,null,null,null,null,null,"Horas","Matricular",null,"Precio",null,"Convalidar",null,null,"Precio Conval."]
[]
[null,"1º","0337 Contexto de la intervención social",null,null,null,null,null,null,null,null,null,null,null,160,null,null,{"$f":"O25*2.4","v":384},null,null,null,null,10]
[null,"1º","0338 Inserción sociolaboral",null,null,null,null,null,null,null,null,null,null,null,192,null,null,460.79999999999995,null,null,null,null,10]
[null,"1º","0339 Atención a las unidades de convivencia",null,null,null,null,null,null,null,null,null,null,null,192,null,null,460.79999999999995,null,null,null,null,10]
[null,"1º","0342 Promoción de la autonomía personal",null,null,null,null,null,null,null,null,null,null,null,224,null,null,{"$f":"O28*2.4","v":537.6},null,null,null,null,10]
[null,"1º","0344 Metodología de la intervención social",null,null,null,null,null,null,null,null,null,null,null,96,null,null,{"$f":"O29*2.4","v":230.39999999999998},null,null,null,null,10]
[null,"1º","0346 Formación y orientación laboral",null,null,null,null,null,null,null,null,null,null,null,96,null,null,{"$f":"O30*2.4","v":230.39999999999998},null,null,null,null,10]
[null,"2º","0340 Mediación comunitaria",null,null,null,null,null,null,null,null,null,null,null,105,null,null,{"$f":"O31*2.4","v":252},null,null,null,null,10]
[null,"2º","0341 Apoyo a la intervención educativa",null,null,null,null,null,null,null,null,null,null,null,126,null,null,302.39999999999998,null,null,null,null,10]
[null,"2º","0343 Sistemas alternativos de comunicación",null,null,null,null,null,null,null,null,null,null,null,126,null,null,302.39999999999998,null,null,null,null,10]
[null,"2º","0020 Primeros auxilios",null,null,null,null,null,null,null,null,null,null,null,42,null,null,100.8,null,null,null,null,10]
[null,"2º","0017 Habilidades sociales",null,null,null,null,null,null,null,null,null,null,null,168,null,null,403.2,null,null,null,null,10]
[null,"2º","0347 Empresa e iniciativa emprendedora",null,null,null,null,null,null,null,null,null,null,null,63,null,null,151.19999999999999,null,null,null,null,10]
[null,"2º","0345 Proyecto de integración social",null,null,null,null,null,null,null,null,null,null,null,30,null,null,72,null,null,null,null,10]
[null,"2º","0348 Formación en Centros de trabajo",null,null,null,null,null,null,null,null,null,null,null,380,null,null,{"$f":"O38*1.2","v":456},null,null,null,null,50]
[]
[null,null,null,null,null,null,"TOTAL horas  e importe",null,null,null,null,null,null,null,{"$f":"SUMIF(P25:Q38,\"si\",O25:O38)","v":0},"h.",null,{"$f":"SUMIF(P25:Q38,\"si\",R25:S38)-SUMIF(T25:U38,\"si\",R25:S38)+SUMIF(T25:U38,\"si\",W25:X38)","v":0}]
[]
[null,"FORMA DE PAGO:"]
[null,"El pago inicial se podrá realizar mediante transferencia bancaria o ingreso en efectivo a través de los cajeros automáticos disponibles en la oficinas del Banco Santander, a favor del siguiente número de cuenta: ES05 0049 3319 5928 1405 0252"]
[]
[]
[null,"OBLIGATORIAMENTE DEBERÁ INDICARSE EN EL CONCEPTO EL NOMBRE  DEL ALUMNO/A SEGUIDO DE FP-ONLINE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(DATOS!A35=TRUE,AND(O40<>960,O40<>630)),DATOS!B35-H51,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"8% DTO. PARA MATRICULA CURSO COMPLETO",null,null,null,null,null,null,null,{"$f":"IF(DATOS!A35=TRUE,IF(OR(O40=960,O40=630),R40-(R40*8%)-H51,\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(DATOS!A36=TRUE,AND(O40<>960,O40<>630)),DATOS!B36,\"\")","v":""}]
[null,null,"Total a pagar",null,null,null,null,{"$f":"SUMIF(DATOS!A31:A32,\"verdadero\",DATOS!B31:B32)","v":0},null,null,null,null,null,"4% DTO PARA MATRICULA CURSO COMPLETO",null,null,null,null,null,null,null,{"$f":"IF(DATOS!A36=TRUE,IF(OR(O40=960,O40=630),(R40-(R40*4%)-H51)/3,\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"SOLO PARA IMPORTES SUPERIORES A 1.000€"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(DATOS!A37=TRUE,AND(O40<>960,O40<>630),R40>=1000),DATOS!B37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," 3% dto para matricula curso completo",null,null,null,null,null,null,null,{"$f":"IF(DATOS!A37=TRUE,IF(OR(O40=960,O40=630),(R40-(R40*3%)-H51)/9,\"\"),\"\")","v":""}]
[]
[null,"DATOS PARA DOMICILIACIÓN BANCARIA"]
[]
[null,"Entidad Bancaria"]
[]
[null,"Código IBAN",null,null,null,"Entidad",null,null,null,"sucursal",null,null,null,"dc",null,"código cuenta"]
[null,"E","S",{"$f":"IF(ISBLANK($V$61),\"\",MID($C$67,1,1))","v":""},{"$f":"IF(ISBLANK($V$61),\"\",MID($C$67,2,1))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($N$64=10,LEFT($N$64,1),IF($N$64=11,0,$N$64))","v":""},{"$f":"IF($O$64=10,LEFT($O$64,1),IF($O$64=11,0,$O$64))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F61*4,G61*8,H61*5,I61*10)","v":0},{"$f":"SUM(P61*1,Q61*2,R61*4,S61*8,T61*5,U61*10,V61*9,W61*7,X61*3,Y61*6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J61*9,K61*7,L61*3,M61*6)","v":0}]
[null,null,null,null,{"$f":"CONCATENATE(B61,C61,D61,E61,E65)","v":"ES"},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($H$61),\"\",11-MOD(SUM($N$62,$N$63),11))","v":""},{"$f":"IF(ISBLANK($U$61),\"\",11-MOD($O$62,11))","v":""}]
[null,null,null,null,{"$f":"CONCATENATE(F61,G61,H61,I61,J61,K61,L61,M61,N61,O61,P61,Q61,R61,S61,T61,U61,V61,W61,X61,Y61)","v":""}]
[]
[null,null,{"$f":"RIGHT(0&98-MOD(MOD(MOD(MOD(MID(E65,1,8),97)&MID(E65,9,8),97)&MID(E65&142800,17,8),97)&MID(E65&142800,25,2),97),2)","v":{"$error":"#VALUE!"}},null,{"$f":"MOD(MOD(MOD(MOD(MID(E65,1,8),97)&MID(E65,9,8),97)&MID(E65&142800,17,8),97)&MID(E65&142821,25,2),97)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valladolid a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma del Titular"]

{"sheet":"PAGO (2)","index":1,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[9,1,9,8],[9,10,9,17],[9,19,9,23],[37,18,37,23],[20,6,20,9],[12,1,12,5],[12,7,12,8],[12,10,12,23],[23,17,23,20]]}
[]
[]
[]
[]
[]
[]
[null,"DATOS ALUMNO/A"]
[]
[null,"Apellido1:",null,null,null,null,null,null,null,null,"Apellido 2:",null,null,null,null,null,null,null,null,"Nombre:"]
[null,{"$f":"IF(ISBLANK(PAGO!$B$12),\"\",PAGO!$B$12)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PAGO!$K$12),\"\",PAGO!$K$12)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PAGO!$T$12),\"\",PAGO!$T$12)","v":""}]
[null,"CURSO EN EL QUE SE MATRICULA"]
[null,"NIVEL",null,null,null,null,null,"CURSO:",null,null,"TÍTULO:"]
[null,{"$f":"IF(ISBLANK(PAGO!$B$19),\"\",PAGO!$B$19)","v":"C.F. GRADO SUPERIOR"},null,null,null,null,null,{"$f":"IF(ISBLANK(PAGO!H19),\"\",PAGO!H19)","v":""},null,null,{"$f":"IF(ISBLANK(PAGO!K19),\"\",PAGO!K19)","v":"Integración Social"}]
[]
[null,"CUOTA POR ENSEÑANZA REGLADA"]
[]
[]
[]
[]
[]
[null,null,"Total a pagar:",null,null,null,{"$f":"IF(PAGO!$B$19=\"C.F. GRADO MEDIO\",SUMIF(DATOS!$G$3:$G$4,\"verdadero\",DATOS!$H$3:$H$4),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total a pagar:",null,null,null,{"$f":"IF(OR(PAGO!$B$19=\"BACHILLER\",PAGO!$B$19=\"C.F. GRADO SUPERIOR\"),SUMIF(DATOS!$G$6:$G$10,\"verdadero\",DATOS!$H$6:$H$10),\"\")","v":162.12}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!*4,#REF!*8,#REF!*5,#REF!*10)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!*1,#REF!*2,#REF!*4,#REF!*8,#REF!*5,#REF!*10,#REF!*9,#REF!*7,#REF!*3,#REF!*6)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!*9,#REF!*7,#REF!*3,#REF!*6)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(#REF!),\"\",11-MOD(SUM(N28,N29),11))","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(#REF!),\"\",11-MOD(O28,11))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"CONCATENATE(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"RIGHT(0&98-MOD(MOD(MOD(MOD(MID(E31,1,8),97)&MID(E31,9,8),97)&MID(E31&142800,17,8),97)&MID(E31&142800,25,2),97),2)","v":{"$error":"#REF!"}},null,{"$f":"MOD(MOD(MOD(MOD(MID(E31,1,8),97)&MID(E31,9,8),97)&MID(E31&142800,17,8),97)&MID(E31&142821,25,2),97)","v":{"$error":"#REF!"}}]
[null,"FORMA DE PAGO:"]
[null,"El pago se realizará por transferencia bancaría , en el siguiente número de cuenta"]
[null,null,null,null,"Banco Popular ES21 0075 0549 19 0600035384."]
[null,"OBLIGATORIAMENTE DEBERÁ INDICARSE EN EL CONCEPTO EL NOMBRE  DEL ALUMNO/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valladolid a",null,null,{"$f":"TODAY()","v":"2021-01-22"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma del Titular"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ejemplar para la Entidad Bancaria"]

{"sheet":"DATOS","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[26,2,26,13],[15,2,15,13],[16,2,16,13],[17,2,17,13],[18,2,18,13],[19,2,19,13],[20,2,20,13],[21,2,21,13],[22,2,22,13],[23,2,23,13],[24,2,24,13],[25,2,25,13]]}
["NIVEL","AÑO","TITULO",null,null,"Celdas vinculadas"]
["C.F. GRADO MEDIO","1º","Atención a Personas en Situación de Dependencia",null,null,"Nivel",1]
["C.F. GRADO SUPERIOR","2º","Gestión Administrativa",null,null,"FPB Y GM",true,1.1200000000000001]
[null,null,"Farmacia y Parafarmacia",null,null,null,false,20]
[null,null,"Sistemas Microinformáticos y Redes",null,null,"G.S. Y BACHILLER"]
[null,null,"Administración y Finanzas",null,null," <28",true,24.12]
[null,null,"Desarrollo Aplicaciones Multiplataforma",null,null,">28",false,23]
[null,null,"Educación Infantil",null,null,"1trimestre",true,69]
["DOCUMENTO",null,"Gestión de Ventas y Espacios Comerciales",null,null,"2trimestre",true,69]
["D.N.I.",null,"Guía, Información y Asistencia Turística",null,null,"3trimestre",false,69]
["N.I.E.",null,"Integración Social"]
[null,null,"Laboratorio Clínico y Biomédico"]
[]
[]
["SI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[false,1.1200000000000001]
[true,{"$f":"PAGO!R40*10%","v":0}]
[]
[]
[false,{"$f":"PAGO!R40","v":0}]
[false,{"$f":"(PAGO!R40-PAGO!H51)/3","v":0}]
[false,{"$f":"(PAGO!R40-PAGO!H51)/9","v":0}]

{"sheet":"PROVINCIAS","index":3,"n_rows":54,"n_cols":1,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Provincia"]
[]
["Álava (Vitoria)"]
["Albacete"]
["Alicante"]
["Almería"]
["Asturias (Oviedo)"]
["Ávila"]
["Badajoz"]
["Baleares (Palma de Mallorca)"]
["Barcelona"]
["Burgos"]
["Cáceres"]
["Cádiz"]
["Cantabria (Santander)"]
["Castellón"]
["Ceuta"]
["Ciudad Real"]
["Córdoba"]
["Coruña"]
["Cuenca"]
["Gerona"]
["Granada"]
["Guadalajara"]
["Guipúzcoa (San Sebastián)"]
["Huelva"]
["Huesca"]
["Jaén"]
["La Rioja (Logroño)"]
["Las Palmas"]
["León"]
["Lérida"]
["Lugo"]
["Madrid"]
["Málaga"]
["Melilla"]
["Murcia"]
["Navarra (Pamplona)"]
["Orense"]
["Palencia"]
["Pontevedra"]
["Salamanca"]
["Santa Cruz de Tenerife"]
["Segovia"]
["Sevilla"]
["Soria"]
["Tarragona"]
["Teruel"]
["Toledo"]
["Valencia"]
["Valladolid"]
["Vizcaya (Bilbao)"]
["Zamora"]
["Zaragoza"]

{"sheet":"Hoja1","index":4,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Curso","Módulo","Horas","matricula","Precio","Convalidar","Precio Conval."]
[1,"0099 Disposición y venta de productos",99,null,{"$f":"C2*2.4","v":237.6}]
[1,"0100 Oficina de farmacia",198,null,{"$f":"C3*2.4","v":475.2},null,5]
[1,"0102 Dispensación de productos parafarmacéuticos",264,null,633.6,null,5]
[1,"0103 Operaciones básicas de laboratorio",198,null,475.2,null,5]
[1,"0106. Formación y orientación laboral",99,null,237.6,null,5]
[1,"0061 Anatomofisiología y patología básicas",132,null,316.8,null,5]
[2,"0101 Dispensación de productos farmacéuticos",210,null,504,null,5]
[2,"0104 Formulación magistral",147,null,352.8,null,5]
[2,"0105 Promoción de la salud",168,null,403.2,null,5]
[2,"0107. Empresa e iniciativa emprendedora",63,null,151.19999999999999,null,5]
[2,"0020 Primeros auxilios",42,null,100.8,null,5]
[2,"0108. Formación en centros de trabajo.",380,null,912,null,50]
[null,"Total Módulos:"]
[]
[null,"Total Horas:"]
[]
[null,"Precio total sin descuentos:",null,null,null,null,null,null,null,{"$f":"990*2.4","v":2376}]
[null,null,null,null,null,null,null,null,null,{"$f":"J18*10%","v":237.60000000000002},null,null,null,"cuota"]
[null,"Descuento 10% para nuevos alumnos",null,null,null,null,null,null,null,{"$f":"J18-J19","v":2138.4},{"$f":"J18*3%","v":71.28},{"$f":"J20-K20","v":2067.12},{"$f":"L20+J19","v":2304.7199999999998},{"$f":"L20/9","v":229.67999999999998}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J18*4%","v":95.04},{"$f":"J20-K21","v":2043.3600000000001},{"$f":"L21+J19","v":2280.96},{"$f":"L21/3","v":681.12}]
[null,"Descuento 3% (más de 600 horas)"]
[]
[null,"Si abonas tu matrícula en un sólo plazo (3% descuento sobre el total a pagar, si es superior a 500 Euros)"]
[]
[null,"Si abonas tu matrícula en 5 plazos (importe de cada plazo)"]
[]
[]
[null,"0337 Contexto de la intervención social"]
[null,"0338 Inserción sociolaboral"]
[null,"0339 Atención a las unidades de convivencia"]
[null,"0340 Mediación comunitaria"]
[null,"0341 Apoyo a la intervención educativa"]
[null,"0342 Promoción de la autonomía personal"]
[null,"0343 Sistemas alternativos de comunicación"]
[null,"0344 Metodología de la intervención social"]
[null,"0020 Primeros auxilios"]
[null,"0017 Habilidades sociales"]
[null,"0345 Proyecto de Integración Social"]
[null,"0346 Formación y orientación laboral"]
[null,"0347 Empresa e iniciativa emprendedora"]
[null,"0348 Formación en Centros de trabajo"]