{"text_format":"2","workbook":"xls","n_sheets":11,"sheets":["RND","Datos_Mal","TusDatos","TusDatosSOL","Hipoteca","Presupuesto","Peor Caso_2","Presupuesto_Escena","Optim_SinDtos","Optim","OptimizacionSOL"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":2,"defined_names":0,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"RND","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["GENERACIÓN ALEATORIA DE DATOS"]
[]
["Generar un número aleatorio entre 0 y 1"]
["Generar un número aleatorio entre 0 y 5"]
["Generar un número aleatorio según una normal"]
["Generar una recta con ruido gaussiano"]
["Generar una etiqueta (A, B, C o D)"]
["Generar una etiqueta (Hx.T) con x y T aleatorios"]

{"sheet":"Datos_Mal","index":1,"n_rows":8,"n_cols":97,"rows_kept":8,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["NÚMERO DE ESPECIES EN HÁBITATS CONOCIDOS (POR SEXOS)"]
[]
[]
["Habitat","H2.B","H3.A","H1.A","H3.B","H1.B","H3.B","H3.A","H1.A","H2.A","H2.A","H3.B","H2.A","H1.A","H2.B","H1.A","H2.A","H3.A","H1.A","H1.B","H2.B","H3.B","H2.A","H3.A","H1.A","H1.A","H1.B","H3.B","H1.A","H3.A","H2.B","H1.B","H1.A","H2.B","H1.B","H2.B","H3.A","H3.A","H3.B","H1.B","H1.B","H2.A","H2.A","H1.B","H3.B","H2.A","H1.B","H1.B","H3.A","H1.A","H1.A","H1.A","H1.B","H1.B","H1.B","H1.A","H1.B","H1.B","H3.A","H1.B","H2.A","H1.A","H1.A","H2.A","H3.B","H3.B","H1.B","H1.A","H3.A","H1.A","H1.A","H1.A","H1.B","H1.A","H2.A","H3.A","H2.B","H2.A","H2.A","H1.B","H1.A","H3.A","H1.B","H1.B","H3.A","H1.B","H2.A","H1.B","H3.A","H1.B","H3.A","H3.B","H3.B","H1.A","H1.B","H1.B","H1.B"]
["Especie","E2","E1","E1","E1","E1","E2","E2","E3","E1","E2","E1","E1","E1","E2","E3","E1","E1","E3","E1","E3","E2","E2","E2","E1","E3","E1","E2","E3","E4","E1","E2","E1","E1","E1","E1","E2","E2","E4","E1","E1","E2","E3","E4","E4","E2","E3","E1","E1","E2","E2","E1","E2","E2","E3","E1","E1","E2","E1","E4","E3","E2","E4","E1","E1","E1","E1","E3","E2","E3","E2","E2","E2","E2","E1","E2","E1","E1","E3","E1","E2","E1","E1","E4","E1","E1","E1","E3","E2","E4","E1","E1","E2","E3","E2","E2","E1"]
["Estación","Verano","Otoño","Verano","Verano","Invierno","Invierno","Primavera","Invierno","Invierno","Primavera","Primavera","Primavera","Otoño","Invierno","Otoño","Primavera","Invierno","Invierno","Primavera","Invierno","Verano","Primavera","Invierno","Primavera","Primavera","Invierno","Otoño","Invierno","Invierno","Primavera","Verano","Verano","Invierno","Invierno","Invierno","Primavera","Invierno","Invierno","Primavera","Invierno","Invierno","Primavera","Verano","Invierno","Otoño","Invierno","Primavera","Otoño","Verano","Verano","Invierno","Invierno","Primavera","Invierno","Invierno","Verano","Invierno","Invierno","Invierno","Verano","Invierno","Invierno","Invierno","Invierno","Invierno","Invierno","Invierno","Invierno","Invierno","Invierno","Invierno","Primavera","Otoño","Primavera","Primavera","Invierno","Primavera","Invierno","Otoño","Invierno","Verano","Verano","Invierno","Invierno","Primavera","Primavera","Invierno","Otoño","Primavera","Primavera","Invierno","Primavera","Primavera","Verano","Primavera","Primavera"]
["Machos",1,5,1,3,2,4,1,4,2,2,0,1,4,2,5,3,3,3,1,1,2,2,5,2,1,5,4,0,2,0,1,2,4,4,5,5,2,0,4,0,1,1,3,1,2,5,5,3,2,4,1,2,3,5,4,3,2,4,0,4,3,1,0,0,5,3,3,1,0,5,0,0,3,0,3,5,5,2,1,2,4,5,5,5,5,2,5,2,2,4,3,0,3,4,0,2]
["Hembras",5,5,2,0,1,2,2,1,1,1,0,1,3,2,1,3,1,3,5,4,4,4,0,0,3,2,4,2,1,5,3,5,5,3,1,5,3,1,1,2,0,0,0,2,1,5,4,2,4,4,2,5,3,1,0,1,4,0,0,5,0,4,4,1,5,0,1,3,3,1,3,3,3,0,5,4,1,3,1,1,1,3,0,5,5,3,5,5,5,2,0,2,5,0,4,0]

{"sheet":"TusDatos","index":2,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["NÚMERO DE ESPECIES EN HÁBITATS CONOCIDOS (POR SEXOS)"]
[]
[0,null,null,0]
["Habitat","Especie","Estación","Machos","Hembras"]

{"sheet":"TusDatosSOL","index":3,"n_rows":100,"n_cols":12,"rows_kept":100,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["NÚMERO DE ESPECIES EN HÁBITATS CONOCIDOS (POR SEXOS)"]
[]
[96,96,96,235,236]
["Habitat","Especie","Estación","Machos","Hembras",null,"Filtro"]
["H3.A","E1","Otoño",5,5,null,"Habitat","- todo -"]
["H1.B","E1","Invierno",3,3]
["H1.B","E1","Invierno",0,1,null,null,null,"Estación"]
["H1.B","E4","Invierno",5,3,null,"Datos","Especie","Invierno","Otoño","Primavera","Verano"]
["H2.B","E1","Invierno",4,0,null,"Suma - Machos","E1",68,7,24,3]
["H1.A","E2","Invierno",5,0,null,null,"E2",34,4,13,10]
["H3.A","E2","Invierno",2,2,null,null,"E3",18,null,10,2]
["H3.B","E1","Verano",2,4,null,null,"E4",34,4,4,0]
["H1.A","E1","Verano",1,0,null,"Suma - Hembras","E1",70,8,16,4]
["H2.B","E3","Primavera",1,2,null,null,"E2",20,12,12,9]
["H3.A","E4","Invierno",5,4,null,null,"E3",21,null,21,2]
["H2.A","E1","Primavera",1,4,null,null,"E4",20,6,10,5]
["H2.B","E2","Otoño",0,2,null,"Total Suma - Machos",null,154,15,51,15]
["H3.B","E4","Verano",0,5,null,"Total Suma - Hembras",null,131,26,59,20]
["H2.A","E3","Verano",1,1]
["H2.A","E1","Invierno",5,1]
["H3.A","E2","Invierno",4,2]
["H2.B","E1","Invierno",2,5]
["H3.B","E1","Invierno",2,3]
["H1.A","E4","Otoño",1,5]
["H1.A","E3","Invierno",0,4]
["H2.B","E3","Primavera",0,5]
["H1.B","E4","Invierno",3,1]
["H1.B","E3","Primavera",1,3]
["H2.B","E1","Otoño",0,0]
["H1.A","E1","Primavera",5,1]
["H1.B","E4","Otoño",3,1]
["H2.A","E4","Invierno",1,0]
["H1.B","E3","Invierno",4,2]
["H1.B","E3","Invierno",4,4]
["H1.B","E2","Primavera",4,4]
["H1.B","E3","Invierno",3,2]
["H3.A","E4","Invierno",1,2]
["H3.A","E1","Invierno",5,5]
["H3.B","E4","Invierno",3,5]
["H1.A","E1","Invierno",0,2]
["H2.A","E1","Primavera",5,0]
["H1.B","E2","Invierno",5,2]
["H2.B","E1","Invierno",2,1]
["H1.A","E1","Verano",0,0]
["H3.A","E1","Invierno",0,4]
["H1.A","E2","Otoño",1,5]
["H1.B","E1","Invierno",2,4]
["H1.A","E3","Verano",1,1]
["H1.A","E1","Invierno",1,5]
["H1.A","E2","Verano",3,0]
["H1.B","E2","Verano",0,2]
["H1.B","E1","Primavera",0,1]
["H1.A","E3","Primavera",5,5]
["H2.A","E1","Invierno",3,0]
["H1.B","E1","Primavera",2,1]
["H1.B","E4","Primavera",0,4]
["H1.B","E1","Invierno",4,5]
["H1.B","E3","Primavera",0,2]
["H2.B","E2","Invierno",2,2]
["H1.B","E1","Invierno",4,5]
["H1.A","E2","Invierno",5,3]
["H1.A","E2","Invierno",5,3]
["H1.B","E1","Verano",0,0]
["H1.A","E2","Invierno",3,0]
["H2.B","E4","Invierno",4,1]
["H1.A","E1","Invierno",4,4]
["H1.B","E1","Invierno",1,2]
["H1.B","E2","Invierno",0,4]
["H2.A","E2","Verano",4,4]
["H1.B","E4","Invierno",4,2]
["H3.A","E4","Invierno",0,0]
["H2.A","E3","Primavera",3,4]
["H1.A","E1","Invierno",3,4]
["H3.B","E1","Primavera",2,1]
["H1.B","E1","Invierno",4,4]
["H3.A","E1","Primavera",4,3]
["H3.B","E1","Invierno",4,1]
["H3.B","E4","Primavera",0,3]
["H1.B","E1","Invierno",5,4]
["H3.B","E1","Primavera",0,1]
["H1.B","E2","Primavera",3,4]
["H3.B","E4","Invierno",0,0]
["H1.B","E1","Otoño",0,2]
["H1.B","E2","Primavera",3,3]
["H1.B","E1","Invierno",4,1]
["H1.B","E3","Invierno",2,4]
["H1.B","E2","Invierno",3,2]
["H1.A","E1","Otoño",2,1]
["H1.B","E2","Primavera",2,0]
["H2.A","E1","Primavera",5,4]
["H1.A","E1","Invierno",1,1]
["H1.B","E2","Otoño",2,4]
["H1.B","E4","Invierno",5,1]
["H3.A","E2","Primavera",1,1]
["H3.B","E1","Invierno",5,5]
["H3.A","E2","Verano",3,3]
["H3.A","E3","Invierno",5,5]
["H3.A","E2","Otoño",1,1]
["H2.A","E4","Invierno",3,1]
["H2.A","E4","Primavera",4,3]

{"sheet":"Hipoteca","index":4,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,4,1,6],[2,0,2,1],[4,7,12,7],[15,9,23,9]],"flags":["formulas_cached_only"]}
["Hipoteca"]
[{"$nulls":4},"Resultado"]
["Entradas",null,null,null,"Pago Mensual","Pago Total","Interés total"]
["Préstamo",120000,null,null,650,234000,114000]
["Meses",360,null,0.05,null,null,null,"Simulación 1"]
["Interés",0.065,null,0.052500000000000005]
[null,null,null,0.055]
[null,null,null,0.0575]
[null,null,null,0.06]
[null,null,null,0.0625]
[null,null,null,0.065]
[null,null,null,0.0675]
[null,null,null,0.07]
[]
[{"$nulls":4},120000,125000,130000,135000,140000]
[null,null,null,0.05,{"$nulls":5},"Simulación 2"]
[null,null,null,0.052500000000000005]
[null,null,null,0.055]
[null,null,null,0.0575]
[null,null,null,0.06]
[null,null,null,0.0625]
[null,null,null,0.065]
[null,null,null,0.0675]
[null,null,null,0.07]

{"sheet":"Presupuesto","index":5,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Determinación del precio de un curso"]
[]
["Horas del curso",30,null,"€/h no UMU",10]
[null,null,null,"€/h UMU/Socio",3.3333333333333335,"Descuento:",0.6666666666666666]
[]
["Ingresos","Ayudas",1000,"Gastos","Profesorado",3000]
[null,"Tasas",12799.382716049378,null,"10% Becas",1379.9382716049379]
[null,null,13799.382716049378,null,"Otro 10% Infra",1241.9444444444441]
[{"$nulls":4},"Otros",1000]
[null,"Total OK",null,null,null,6621.882716049382]
[]
[]
["Simulación de Ingresos",{"$nulls":4},"Simulación de Gastos",null,null,"Total=Ingesos-Gastos"]
[]
[null,"UMU","NO-UMU",null,null,"€/h Profesor",100]
["Tasa",393.827160493827,492.2839506172838,"Ingreso"]
["Nº Alumnos UMU",null,20,7876.5432098765405,null,"Otros Gastos",1000]
["Nº Alumnos NO-UMU",null,10,4922.839506172838,null,"“” con Formula",8177.499999999996]
[null,"Total",30,12799.382716049378]
[]
["Número mínimo de alumnos = 10 !!!!!"]

{"sheet":"Peor Caso_2","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":14}
[null,"UMU","NO-UMU"]
["Tasa",393.827160493827,492.2839506172838,"Ingreso"]
["Nº Alumnos UMU",null,10,3938.2716049382702]
["Nº Alumnos NO-UMU",null,0,0]
[null,"Total",10,3938.2716049382702]

{"sheet":"Presupuesto_Escena","index":7,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Determinación del precio de un curso"]
[]
["Horas del curso",30,null,"€/h no UMU",10]
[null,null,null,"€/h UMU/Socio",3.3333333333333335,"Descuento:",0.6666666666666666]
[]
["Ingresos","Ayudas",1000,"Gastos","Profesorado",3000]
[null,"Tasas",3938.2716049382702,null,"10% Becas",493.8271604938271]
[null,null,4938.271604938271,null,"Otro 10% Infra",444.44444444444434]
[{"$nulls":4},"Otros",1000]
[null,"Total OK",null,null,null,4938.271604938272]
[]
[]
["Simulación de Ingresos",{"$nulls":4},"Simulación de Gastos",null,null,"Total=Ingesos-Gastos"]
[]
[null,"UMU","NO-UMU",null,null,"€/h Profesor",100]
["Tasa",393.827160493827,492.2839506172838,"Ingreso"]
["Nº Alumnos UMU",null,10,3938.2716049382702,null,"Otros Gastos",1000]
["Nº Alumnos NO-UMU",null,0,0,null,"“” con Formula",999.9999999999991]
[null,"Total",10,3938.2716049382702]
[]
["Número mínimo de alumnos = 10 !!!!!"]

{"sheet":"Optim_SinDtos","index":8,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[{"$nulls":10},"Beneficio","Erosión"]
[null,"arveja","lenteja","trigo","cebada",{"$nulls":4},0,null,1.66666666666667,"(máx)"]
[{"$nulls":9},1,null,1.62466666666667]
[{"$nulls":9},2,null,1.58266666666667]
["máx",{"$nulls":8},3,null,1.5406666666666702]
["mín",{"$nulls":8},4,null,1.4986666666666701]
["s.a",{"$nulls":8},5,null,1.45666666666667]
["Cantidades",{"$nulls":5},"=",10,null,6,null,1.41466666666667]
["Mano de obra",{"$nulls":5},"<",80,null,7,null,1.37266666666667]
["Gasto",{"$nulls":5},"<",600,null,8,null,1.3306666666666702]
[{"$nulls":9},9,null,1.2886666666666702]
[{"$nulls":9},10,null,1.2466666666666701,"(min)"]

{"sheet":"Optim","index":9,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[{"$nulls":10},"Beneficio","Erosión"]
[null,"arveja","lenteja","trigo","cebada",{"$nulls":4},0,null,1.66666666666667,"(máx)"]
[null,0,0,0,0,{"$nulls":4},1,null,1.62466666666667]
[{"$nulls":9},2,null,1.58266666666667]
["máx",200,220,120,120,0,null,null,null,3,null,1.5406666666666702]
["mín",0.2,0.4,0.05,0.1,0,"<",1.41,null,4,null,1.4986666666666701]
["s.a",{"$nulls":8},5,null,1.45666666666667]
["Cantidades",1,1,1,1,0,"=",10,null,6,null,1.41466666666667]
["Mano de obra",10,10,5,8,0,"<",80,null,7,null,1.37266666666667]
["Gasto",40,70,80,90,0,"<",600,null,8,null,1.3306666666666702]
[{"$nulls":9},9,null,1.2886666666666702]
[{"$nulls":9},10,null,1.2466666666666701,"(min)"]

{"sheet":"OptimizacionSOL","index":10,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[{"$nulls":10},"Beneficio","Erosión"]
[null,"arveja","lenteja","trigo","cebada",{"$nulls":4},0,1706.66666666667,1.66666666666667,"(máx)"]
[null,4.66666666666667,1.33333333333333,4,0,{"$nulls":4},1,1702,1.62466666666667]
[{"$nulls":9},2,1698,1.58266666666667]
["máx",200,220,120,120,1706.6666666666665,null,null,null,3,1694.06666666667,1.5406666666666702]
["mín",0.2,0.4,0.05,0.1,1.6666666666666659,"<",1.41,null,4,1690,1.4986666666666701]
["s.a",{"$nulls":8},5,1685.66666666667,1.45666666666667]
["Cantidades",1,1,1,1,10,"=",10,null,6,1681,1.41466666666667]
["Mano de obra",10,10,5,8,80,"<",80,null,7,1665.42222222222,1.37266666666667]
["Gasto",40,70,80,90,599.9999999999999,"<",600,null,8,1643.02222222222,1.3306666666666702]
[{"$nulls":9},9,1643.02222222222,1.2886666666666702]
[{"$nulls":9},10,1600,1.2466666666666701,"(min)"]