{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PAGO","DATOS","PROVINCIAS"],"not_rendered":{"charts":0,"images":1,"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":72,"n_cols":23,"rows_kept":72,"cut":false,"hidden":false,"merged":[[51,21,51,23],[46,21,46,23],[47,21,47,23],[28,22,28,23],[29,22,29,23],[49,12,49,23],[46,13,46,20],[45,21,45,23],[48,13,48,20],[48,21,48,23],[33,22,33,23],[34,22,34,23],[29,15,29,16],[33,19,33,20],[34,19,34,20],[35,19,35,20],[27,15,27,16],[27,19,27,20],[22,2,23,13],[18,1,18,6],[50,21,50,23],[22,22,23,23],[22,0,23,1],[22,19,23,21],[24,19,24,20],[25,19,25,20],[26,19,26,20],[22,17,23,18],[24,15,24,16],[25,15,25,16],[26,15,26,16],[32,19,32,20],[24,22,24,23],[25,22,25,23],[26,22,26,23],[27,22,27,23],[48,2,48,6],[48,7,48,10],[35,22,35,23],[30,19,30,20],[31,19,31,20],[30,22,30,23],[31,22,31,23],[32,22,32,23],[34,15,34,16],[32,15,32,16],[33,15,33,16],[30,15,30,16],[31,15,31,16],[34,2,34,13],[35,2,35,13],[37,17,37,20],[28,19,28,20],[29,19,29,20],[35,15,35,16],[29,17,29,18],[30,17,30,18],[31,17,31,18],[32,17,32,18],[33,17,33,18],[34,17,34,18],[35,17,35,18],[28,15,28,16],[24,17,24,18],[25,17,25,18],[26,17,26,18],[27,17,27,18],[28,17,28,18],[14,1,14,5],[14,7,14,12],[14,14,14,23],[8,5,8,6],[11,1,11,8],[11,10,11,17],[11,19,11,23],[8,13,8,19],[55,6,55,23],[57,15,57,24],[70,18,70,23],[57,1,57,4],[57,5,57,8],[57,9,57,12],[57,13,57,14],[38,6,38,9],[18,7,18,8],[18,10,18,23],[40,1,42,23],[24,2,24,13],[25,2,25,13],[26,2,26,13],[27,2,27,13],[22,14,23,14],[22,15,23,16],[32,2,32,13],[33,2,33,13],[28,2,28,13],[29,2,29,13],[30,2,30,13],[31,2,31,13]]}
[]
[]
[]
[]
[]
[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 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,99,null,null,{"$f":"O25*2.4","v":237.6},null,null,null,null,10]
[null,"1º","0100 Oficina de farmacia",null,null,null,null,null,null,null,null,null,null,null,198,null,null,{"$f":"O26*2.4","v":475.2},null,null,null,null,10]
[null,"1º","0102 Dispensación de productos parafarmacéuticos",null,null,null,null,null,null,null,null,null,null,null,264,null,null,633.6,null,null,null,null,10]
[null,"1º","0103 Operaciones básicas de laboratorio",null,null,null,null,null,null,null,null,null,null,null,198,null,null,475.2,null,null,null,null,10]
[null,"1º","0106. Formación y orientación laboral",null,null,null,null,null,null,null,null,null,null,null,99,null,null,237.6,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,132,null,null,316.8,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,210,null,null,{"$f":"O31*2.4","v":504},null,null,null,null,10]
[null,"2º","0104 Formulación magistral",null,null,null,null,null,null,null,null,null,null,null,147,null,null,352.8,null,null,null,null,10]
[null,"2º","0105 Promoción de la salud",null,null,null,null,null,null,null,null,null,null,null,168,null,null,403.2,null,null,null,null,10]
[null,"2º","0107. 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º","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º","0108. Formación en centros de trabajo.",null,null,null,null,null,null,null,null,null,null,null,380,null,null,{"$f":"O36*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:Q36,\"si\",O25:O36)","v":0},"h.",null,{"$f":"SUMIF(P25:Q36,\"si\",R25:S36)-SUMIF(T25:U36,\"si\",R25:S36)+SUMIF(T25:U36,\"si\",W25:X36)","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$38<>990,O38<>630)),DATOS!B35-H49,\"\")","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$38=990,O38=630),DATOS!B35-(DATOS!B35*8%)-H49,\"\"),\"\")","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$38<>990,O38<>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($O$38=990,O38=630),(R38-(R38*4%)-H49)/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$38<>990,O38<>630),R38>=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$38=990,O38=630),(R38-(R38*3%)-PAGO!H49)/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$59),\"\",MID($C$65,1,1))","v":""},{"$f":"IF(ISBLANK($V$59),\"\",MID($C$65,2,1))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($N$62=10,LEFT($N$62,1),IF($N$62=11,0,$N$62))","v":""},{"$f":"IF($O$62=10,LEFT($O$62,1),IF($O$62=11,0,$O$62))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F59*4,G59*8,H59*5,I59*10)","v":0},{"$f":"SUM(P59*1,Q59*2,R59*4,S59*8,T59*5,U59*10,V59*9,W59*7,X59*3,Y59*6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J59*9,K59*7,L59*3,M59*6)","v":0}]
[null,null,null,null,{"$f":"CONCATENATE(B59,C59,D59,E59,E63)","v":"ES"},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($H$59),\"\",11-MOD(SUM($N$60,$N$61),11))","v":""},{"$f":"IF(ISBLANK($U$59),\"\",11-MOD($O$60,11))","v":""}]
[null,null,null,null,{"$f":"CONCATENATE(F59,G59,H59,I59,J59,K59,L59,M59,N59,O59,P59,Q59,R59,S59,T59,U59,V59,W59,X59,Y59)","v":""}]
[]
[null,null,{"$f":"RIGHT(0&98-MOD(MOD(MOD(MOD(MID(E63,1,8),97)&MID(E63,9,8),97)&MID(E63&142800,17,8),97)&MID(E63&142800,25,2),97),2)","v":{"$error":"#VALUE!"}},null,{"$f":"MOD(MOD(MOD(MOD(MID(E63,1,8),97)&MID(E63,9,8),97)&MID(E63&142800,17,8),97)&MID(E63&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":"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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[false,1.1200000000000001]
[true,{"$f":"PAGO!R38*10%","v":0}]
[]
[]
[false,{"$f":"PAGO!R38","v":0}]
[false,{"$f":"(PAGO!R38-PAGO!H49)/3","v":0}]
[false,{"$f":"(PAGO!R38-PAGO!H49)/9","v":0}]

{"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"]