{"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":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[22,2,23,13],[18,1,18,6],[54,21,54,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],[36,19,36,20],[50,21,50,23],[51,21,51,23],[28,22,28,23],[29,22,29,23],[53,12,53,23],[50,13,50,20],[49,21,49,23],[52,13,52,20],[52,21,52,23],[37,22,37,23],[61,5,61,8],[61,9,61,12],[61,13,61,14],[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],[24,17,24,18],[25,17,25,18],[26,17,26,18],[27,17,27,18],[28,17,28,18],[31,15,31,16],[38,2,38,13],[39,2,39,13],[41,17,41,20],[28,19,28,20],[29,19,29,20],[39,15,39,16],[30,22,30,23],[36,17,36,18],[28,15,28,16],[24,22,24,23],[25,22,25,23],[26,22,26,23],[27,22,27,23],[30,19,30,20],[31,19,31,20],[74,18,74,23],[31,22,31,23],[36,22,36,23],[38,15,38,16],[36,15,36,16],[37,15,37,16],[30,15,30,16],[27,15,27,16],[27,19,27,20],[38,22,38,23],[29,15,29,16],[37,19,37,20],[38,19,38,20],[32,22,32,23],[33,22,33,23],[39,17,39,18],[52,2,52,6],[52,7,52,10],[39,22,39,23],[55,21,55,23],[39,19,39,20],[34,22,34,23],[35,22,35,23],[18,7,18,8],[18,10,18,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],[36,2,36,13],[28,2,28,13],[29,2,29,13],[30,2,30,13],[31,2,31,13],[29,17,29,18],[30,17,30,18],[31,17,31,18],[32,2,32,13],[32,15,32,16],[32,17,32,18],[32,19,32,20],[33,2,33,13],[33,15,33,16],[33,17,33,18],[33,19,33,20],[61,1,61,4],[44,1,46,23],[34,2,34,13],[34,15,34,16],[34,17,34,18],[34,19,34,20],[35,2,35,13],[35,15,35,16],[35,17,35,18],[35,19,35,20],[42,6,42,9],[37,2,37,13],[59,6,59,23],[61,15,61,24],[37,17,37,18],[38,17,38,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,"Agencias de Viajes y Gestión de Eventos"]
[]
[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º","0171. Estructura del mercado turístico",null,null,null,null,null,null,null,null,null,null,null,96,null,null,{"$f":"O25*2.4","v":230.39999999999998},null,null,null,null,10]
[null,"1º","0172. Protocolo y relaciones públicas",null,null,null,null,null,null,null,null,null,null,null,96,null,null,{"$f":"O26*2.4","v":230.39999999999998},null,null,null,null,10]
[null,"1º","0173. Marketing turístico",null,null,null,null,null,null,null,null,null,null,null,128,null,null,307.2,null,null,null,null,10]
[null,"1º","0179. Inglés",null,null,null,null,null,null,null,null,null,null,null,160,null,null,384,null,null,null,null,10]
[null,"1º","0180. Segunda lengua extranjera (Francés)",null,null,null,null,null,null,null,null,null,null,null,160,null,null,384,null,null,null,null,10]
[null,"1º","0383. Destinos turísticos",null,null,null,null,null,null,null,null,null,null,null,224,null,null,537.6,null,null,null,null,10]
[null,"1º","0401. Formación y orientación laboral",null,null,null,null,null,null,null,null,null,null,null,96,null,null,{"$f":"O31*2.4","v":230.39999999999998},null,null,null,null,10]
[null,"2º","0384. Recursos Turísticos",null,null,null,null,null,null,null,null,null,null,null,126,null,null,302.39999999999998,null,null,null,null,10]
[null,"2º","0397. Gestión de productos turísticos",null,null,null,null,null,null,null,null,null,null,null,126,null,null,{"$f":"O33*2.4","v":302.39999999999998},null,null,null,null,10]
[null,"2º","0398. Venta de servicios turísticos",null,null,null,null,null,null,null,null,null,null,null,147,null,null,352.8,null,null,null,null,10]
[null,"2º","0399. Dirección de entidades de intermediación turística",null,null,null,null,null,null,null,null,null,null,null,84,null,null,201.6,null,null,null,null,10]
[null,"2º","0402. 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º","CL10. Inglés para agencias de viajes y gestión de eventos",null,null,null,null,null,null,null,null,null,null,null,42,null,null,100.8,null,null,null,null,10]
[null,"2º","CL11. Segunda lengua extranjera para agencia de viajes y gestión de eventos, Francés",null,null,null,null,null,null,null,null,null,null,null,42,null,null,100.8,null,null,null,null,10]
[null,"2º","0400. Proyecto de agencias de viajes y gestión de eventos",null,null,null,null,null,null,null,null,null,null,null,30,null,null,72,null,null,null,null,10]
[null,"2º","0403. Formación en centros de trabajo",null,null,null,null,null,null,null,null,null,null,null,380,null,null,{"$f":"O40*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:Q40,\"si\",O25:O40)","v":0},"h.",null,{"$f":"SUMIF(P25:Q40,\"si\",R25:S40)-SUMIF(T25:U40,\"si\",R25:S40)+SUMIF(T25:U40,\"si\",W25: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<>960,O42<>630)),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=960,O42=630),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<>960,O42<>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$42=960,O42=630),(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<>960,O42<>630),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=960,O42=630),(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!"}}]
[]
[]
[]
[]
[]
[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"]
[null,null,"Agencias de Viajes y Gestión de Eventos"]
[]
["SI"]
["NO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[false,1.1200000000000001]
[true,{"$f":"PAGO!R42*10%","v":0}]
[]
[]
[false,{"$f":"PAGO!R42","v":0}]
[false,{"$f":"(PAGO!R42-PAGO!H53)/3","v":0}]
[false,{"$f":"(PAGO!R42-PAGO!H53)/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"]