{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Oculta","Presupuesto","Instrucciones"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Oculta","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Elegir de la lista desplegable"]
["Dirección",400]
["2 Directores",200]
["3 Directores",133]
["4 Directores",100,null,null,null,null,"Es blanco","Es blanco","Es blanco"]
["Dirección renuncia",0,null,null,null,null,"Nombre","Concepto","Cantidad"]
["Ponencia hasta 4h.",150,null,"Es texto",null,"Nombre","x"]
["Ponencia más de 4 h.",75,null,"Es texto",null,"Concepto","Introducir Ponente y cantidad","x"]
["Mesa Redonda",100,null,"Es numero",null,"Cantidad","Introducir ponente y concepto",null,"x"]
["Moderadores",50]
["Apoyo",50]
[]
[]
[]
[null,null,null,"Dirección",1,400]
[null,null,null,"2 Directores",2,200]
[null,null,null,"3 Directores",3,133]
[null,null,null,"4 Directores",4,100]
["INTERNO",null,null,"Dirección renuncia",0,0]
["EXTERNO"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"VLOOKUP(D15,D15:E19,2,0)","v":1}]

{"sheet":"Presupuesto","index":1,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[53,2,53,4],[53,5,53,6],[53,7,53,10],[39,2,40,6],[40,7,40,11],[41,2,41,11],[42,2,42,6],[42,7,42,8],[42,9,42,10],[43,2,43,6],[43,7,43,8],[43,9,43,10],[49,2,49,4],[49,5,49,6],[49,8,49,9],[44,2,44,6],[3,2,3,11],[4,3,4,11],[5,3,5,11],[7,3,7,11],[8,2,8,11],[6,3,6,11],[44,7,44,8],[44,9,44,10],[45,2,45,6],[45,7,45,8],[45,9,45,10],[46,2,46,6],[46,7,46,8],[46,9,46,10],[47,2,47,10],[48,2,48,11],[50,2,50,4],[50,5,50,6],[50,7,50,10],[52,2,52,4],[52,5,52,6],[52,7,52,10],[51,2,51,4],[51,5,51,6],[51,7,51,10],[54,2,54,4],[54,5,54,6],[54,7,54,10],[55,2,55,10],[56,2,56,10]]}
[]
[]
[]
[null,null,"Presupuesto Inicial"]
[null,null,"TÍTULO DEL CURSO","XXXX"]
[null,null,"Dirección del curso:","XXXX"]
[null,null,"Fechas de celebración:"]
[null,null,"Lugar de celebración:"]
[null,null,"PONENTES (Incluir todos: directores, ponentes, ayudantes…)"]
[null,null," PONENTE","INTERNO \no \nEXTERNO","CONCEPTO / \nTIPO DE INTERVENCIÓN \n\nElegir de la lista desplegable","IMPORTE ESTABLECIDO\n(FIJADO)","CANTIDAD","TOTAL\nHONORARIOS","VIAJE","HOTEL","TAXI","COMIDA\nCENA",null,"Especificación de ponentes/intervenciones."]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E11,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,{"$f":"IFERROR(IF(AND(ISTEXT(C11),ISBLANK(E11),ISBLANK(G11)),\"Introducir concepto y cantidad\",IF(AND(ISTEXT(C11),ISTEXT(E11),ISBLANK(G11)),\"Introducir cantidad\",IF(AND(ISBLANK(C11),ISBLANK(E11),ISNUMBER(G11)),\"Introducir ponente y concepto\",IF(AND(ISBLANK(C11),ISTEXT(E11),ISBLANK(G11)),\"Introducir ponente y cantidad\",IF(AND($E11=\"Ponencia hasta 4h.\",$G11>4),\"ERROR. Para esta ponencia máximo 4 horas\",G11*F11))))),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E12,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,{"$f":"IFERROR(IF(AND(ISTEXT(C12),ISBLANK(E12),ISBLANK(G12)),\"Introducir concepto y cantidad\",IF(AND(ISTEXT(C12),ISTEXT(E12),ISBLANK(G12)),\"Introducir cantidad\",IF(AND(ISBLANK(C12),ISBLANK(E12),ISNUMBER(G12)),\"Introducir ponente y concepto\",IF(AND(ISBLANK(C12),ISTEXT(E12),ISBLANK(G12)),\"Introducir ponente y cantidad\",IF(AND($E12=\"Ponencia hasta 4h.\",$G12>4),\"ERROR. Para esta ponencia máximo 4 horas\",G12*F12))))),\"\")","v":""},null,null,null,null,null,"Directrices sobre desplazamientos"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E13,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E14,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,"",null,null,null,null,null,"Directrices sobre dietas"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E15,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E16,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,"",null,null,null,null,null,"Directrices sobre pernoctas"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E17,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E18,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,"",null,null,null,null,null,"Directrices sobre compra de material"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E19,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E20,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,"",null,null,null,null,null,"Directrices sobre precios"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E21,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E22,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,"",null,null,null,null,null,"Cuestiones sobre financiación externa"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E38,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E39,Oculta!$A$2:$B$11,2,0),\"\")","v":""},null,""]
[null,null,"TOTAL PONENTES",null,null,null,null,{"$f":"SUM(H11:H39)","v":0},{"$f":"SUM(I11:I39)","v":0},{"$f":"SUM(J11:J39)","v":0},{"$f":"SUM(K11:K39)","v":0},{"$f":"SUM(L11:L39)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H40:L40)","v":0}]
[null,null,"OTROS GASTOS"]
[null,null,null,null,null,null,null,"PRECIO",null,"UNIDADES",null,"TOTAL"]
[null,null,"MATERIAL",null,null,null,null,null,null,null,null,{"$f":"H44*J44","v":0}]
[null,null,"OTROS",null,null,null,null,null,null,null,null,{"$f":"H45*J45","v":0}]
[null,null,"EXCURSIÓN",null,null,null,null,null,null,null,null,0]
[null,null,"GASTOS FIJOS",null,null,null,null,650,null,1,null,650]
[null,null,"TOTAL GASTOS",null,null,null,null,null,null,null,null,{"$f":"SUM(L44:L47)+H41","v":650}]
[null,null,"INGRESOS"]
[null,null,"INSCRIPCIONES",null,null,"Precio",null,null,"Plazas",null,null,{"$f":"H50*K50","v":0}]
[null,null,"SUBVENCIÓN 1",null,null,"Institución"]
[null,null,"SUBVENCIÓN 2",null,null,"Institución"]
[null,null,"SUBVENCIÓN 3",null,null,"Institución"]
[null,null,"PATROCINIO 1",null,null,"Institución"]
[null,null,"PATROCINIO 2",null,null,"Institución"]
[null,null,"TOTAL INGRESOS",null,null,null,null,null,null,null,null,{"$f":"SUM(L50:L55)","v":0}]
[null,null,"TOTAL A SUBVENCIONAR",null,null,null,null,null,null,null,null,{"$f":"L48-L56","v":650}]

{"sheet":"Instrucciones","index":2,"n_rows":167,"n_cols":6,"rows_kept":167,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Especificación de ponentes/intervenciones."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Volver al presupuesto"]
[]
[null,"Directrices sobre desplazamientos"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Volver al presupuesto"]
[]
[]
[null,"Directrices sobre dietas"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Volver al presupuesto"]
[]
[]
[null,"Directrices sobre pernoctas"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Volver al presupuesto"]
[]
[null,"Directrices sobre compra de material"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Volver al presupuesto"]
[]
[null,"Directrices sobre precios"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Volver al presupuesto"]
[]
[null,"Cuestiones sobre financiación externa"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Volver al presupuesto"]