{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PAGO","DATOS","PROVINCIAS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[74,19,74,23],[55,21,55,23],[50,21,50,23],[51,21,51,23],[27,22,27,23],[28,22,28,23],[53,12,53,23],[50,13,50,20],[49,21,49,23],[52,13,52,20],[52,21,52,23],[34,22,34,23],[35,22,35,23],[28,15,28,16],[34,19,34,20],[35,19,35,20],[39,19,39,20],[29,2,29,13],[29,15,29,16],[29,17,29,18],[29,19,29,20],[29,22,29,23],[30,2,30,13],[30,15,30,16],[30,17,30,18],[54,21,54,23],[21,22,22,23],[21,0,22,1],[21,19,22,21],[23,19,23,20],[24,19,24,20],[25,19,25,20],[21,17,22,18],[23,15,23,16],[24,15,24,16],[25,15,25,16],[33,19,33,20],[30,19,30,20],[30,22,30,23],[36,2,36,13],[36,15,36,16],[36,17,36,18],[36,19,36,20],[36,22,36,23],[37,22,37,23],[37,19,37,20],[37,17,37,18],[37,15,37,16],[37,2,37,13],[52,2,52,6],[52,7,52,10],[39,22,39,23],[31,19,31,20],[32,19,32,20],[31,22,31,23],[32,22,32,23],[33,22,33,23],[35,15,35,16],[33,15,33,16],[34,15,34,16],[31,15,31,16],[38,2,38,13],[38,15,38,16],[38,17,38,18],[38,19,38,20],[38,22,38,23],[42,6,42,9],[44,1,46,23],[39,17,39,18],[7,5,7,6],[10,1,10,8],[10,10,10,17],[10,19,10,23],[7,13,7,19],[23,17,23,18],[24,17,24,18],[25,17,25,18],[26,17,26,18],[23,22,23,23],[24,22,24,23],[25,22,25,23],[26,22,26,23],[26,15,26,16],[26,19,26,20],[21,2,22,13],[17,1,17,6],[15,15,15,18],[15,19,15,23],[17,7,17,8],[17,10,17,23],[23,2,23,13],[24,2,24,13],[25,2,25,13],[59,6,59,23],[61,15,61,24],[61,1,61,4],[61,5,61,8],[61,9,61,12],[61,13,61,14],[13,1,13,5],[13,7,13,12],[13,14,13,23],[27,17,27,18],[32,15,32,16],[35,2,35,13],[39,2,39,13],[41,17,41,20],[27,19,27,20],[28,19,28,20],[39,15,39,16],[28,17,28,18],[31,17,31,18],[32,17,32,18],[33,17,33,18],[34,17,34,18],[35,17,35,18],[26,2,26,13],[21,14,22,14],[21,15,22,16],[33,2,33,13],[34,2,34,13],[27,2,27,13],[28,2,28,13],[31,2,31,13],[32,2,32,13],[27,15,27,16]]}
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"AÑO ACADÉMICO"]
[null,"NIVEL",null,null,null,null,null,null,null,null,"TÍTULO:"]
[null,"C.F. GRADO MEDIO",null,null,null,null,null,null,null,null,"Farmacia y Parafarmacia"]
[]
[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º","0099 Disposición y venta de productos",null,null,null,null,null,null,null,null,null,null,null,102,null,null,{"$f":"O24*2.4","v":244.79999999999998},null,null,null,null,10]
[null,"1º","0100 Oficina de farmacia",null,null,null,null,null,null,null,null,null,null,null,136,null,null,{"$f":"O25*2.4","v":326.39999999999998},null,null,null,null,10]
[null,"1º","0102 Dispensación de productos parafarmacéut.",null,null,null,null,null,null,null,null,null,null,null,238,null,null,571.19999999999993,null,null,null,null,10]
[null,"1º","0103 Operaciones básicas de laboratorio",null,null,null,null,null,null,null,null,null,null,null,170,null,null,408,null,null,null,null,10]
[null,"1º","1709 Itinerario personal para la empleabilidad I",null,null,null,null,null,null,null,null,null,null,null,102,null,null,244.79999999999998,null,null,null,null,10]
[null,"1º","0061 Anatomofisiología y patología básicas",null,null,null,null,null,null,null,null,null,null,null,136,null,null,326.39999999999998,null,null,null,null,10]
[null,"1º","0156 Ingés profesional",null,null,null,null,null,null,null,null,null,null,null,68,null,null,{"$f":"O30*2.4","v":163.19999999999999},null,null,null,null,10]
[null,"1º","Módulo optativo I",null,null,null,null,null,null,null,null,null,null,null,34,null,null,{"$f":"O31*2.4","v":81.599999999999994},null,null,null,null,10]
[null,"2º","0101 Dispensación de productos farmacéuticos",null,null,null,null,null,null,null,null,null,null,null,297,null,null,{"$f":"O32*2.4","v":712.8},null,null,null,null,10]
[null,"2º","0104 Formulación magistral",null,null,null,null,null,null,null,null,null,null,null,198,null,null,475.2,null,null,null,null,10]
[null,"2º","0105 Promoción de la salud",null,null,null,null,null,null,null,null,null,null,null,198,null,null,475.2,null,null,null,null,10]
[null,"2º","1710 Itinerario personal para la empleabilidad II",null,null,null,null,null,null,null,null,null,null,null,68,null,null,163.19999999999999,null,null,null,null,10]
[null,"2º","0020 Primeros auxilios",null,null,null,null,null,null,null,null,null,null,null,66,null,null,158.4,null,null,null,null,10]
[null,"2º","1664 Digitalización aplicada a los sectores prod.",null,null,null,null,null,null,null,null,null,null,null,34,null,null,{"$f":"O37*2.4","v":81.599999999999994},null,null,null,null,10]
[null,"2º","1713 Proyecto intermodular",null,null,null,null,null,null,null,null,null,null,null,65,null,null,{"$f":"O38*2.4","v":156},null,null,null,null,10]
[null,"2º","1708 Sostenibilidad aplicada al sistema product.",null,null,null,null,null,null,null,null,null,null,null,34,null,null,{"$f":"O39*2.4","v":81.599999999999994},null,null,null,null,10]
[null,"2º","Módulo optativo II",null,null,null,null,null,null,null,null,null,null,null,54,null,null,{"$f":"O40*2.4","v":129.6},null,null,null,null,10]
[]
[null,null,null,null,null,null,"TOTAL horas  e importe",null,null,null,null,null,null,null,{"$f":"SUMIF(P24:Q40,\"si\",O24:O40)","v":0},"h.",null,{"$f":"SUMIF(P24:Q40,\"si\",R24:S40)-SUMIF(T24:U40,\"si\",R24:S40)+SUMIF(T24:U40,\"si\",W24:X40)","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($O$42<986,O42<1014)),DATOS!B35-H53,\"\")","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($O$42>=986,O42>=1014),DATOS!B35-(DATOS!B35*8%)-H53,\"\"),\"\")","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($O$42<986,O42<1014)),DATOS!B36,\"\")","v":""}]
[null,null,"Total a pagar",null,null,null,null,{"$f":"SUMIF(DATOS!A31:A32,\"verdadero\",DATOS!B31:B32)","v":200},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($O$42>=986,O42>=1014),(R42-(R42*4%)-H53)/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($O$42<986,O42<1014),R42>=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($O$42>=986,O42>=1014),(R42-(R42*3%)-PAGO!H53)/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$63),\"\",MID($C$69,1,1))","v":""},{"$f":"IF(ISBLANK($V$63),\"\",MID($C$69,2,1))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($N$66=10,LEFT($N$66,1),IF($N$66=11,0,$N$66))","v":""},{"$f":"IF($O$66=10,LEFT($O$66,1),IF($O$66=11,0,$O$66))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F63*4,G63*8,H63*5,I63*10)","v":0},{"$f":"SUM(P63*1,Q63*2,R63*4,S63*8,T63*5,U63*10,V63*9,W63*7,X63*3,Y63*6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J63*9,K63*7,L63*3,M63*6)","v":0}]
[null,null,null,null,{"$f":"CONCATENATE(B63,C63,D63,E63,E67)","v":"ES"},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($H$63),\"\",11-MOD(SUM($N$64,$N$65),11))","v":""},{"$f":"IF(ISBLANK($U$63),\"\",11-MOD($O$64,11))","v":""}]
[null,null,null,null,{"$f":"CONCATENATE(F63,G63,H63,I63,J63,K63,L63,M63,N63,O63,P63,Q63,R63,S63,T63,U63,V63,W63,X63,Y63)","v":""}]
[]
[null,null,{"$f":"RIGHT(0&98-MOD(MOD(MOD(MOD(MID(E67,1,8),97)&MID(E67,9,8),97)&MID(E67&142800,17,8),97)&MID(E67&142800,25,2),97),2)","v":{"$error":"#VALUE!"}},null,{"$f":"MOD(MOD(MOD(MOD(MID(E67,1,8),97)&MID(E67,9,8),97)&MID(E67&142800,17,8),97)&MID(E67&142821,25,2),97)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
["CLAUSULAS IMPAGO:"]
[null,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":"DATOS","index":1,"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"]
["NO"]
[]
[]
["2022/2023"]
["2023/2024"]
["2024/2025"]
["2025/2026"]
["2026/2027"]
["2027/2028"]
[]
[]
[]
[]
[]
[]
[false,1.1200000000000001]
[true,{"$f":"200","v":200}]
[]
[]
[false,{"$f":"PAGO!R42","v":0}]
[false,{"$f":"(PAGO!R42-PAGO!H53)/3","v":-66.666666666666671}]
[false,{"$f":"(PAGO!R42-PAGO!H53)/9","v":-22.222222222222221}]

{"sheet":"PROVINCIAS","index":2,"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"]