{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Pasos del software","Analisis","Enc. de Criterios","Enc. de Alternativas","Bruto","Calculo de los criterios"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":31,"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":"Pasos del software","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,4,4,12]]}
[]
[null,null,null,null,"Pasos para la aplicación del  AHP a los riesgos en Proyectos"]
[]
[]
[]
[]
[]
["*","Para el correcto uso de esta aplicacion se sugiere contraer la cinta de opciones:"]
[]
[]
[]
[]
["1)","Presionar para el inicio del proyecto:"]
[]
["2)","Comienzo de la encuesta de Criterios:"]
[]
["3)","Comienzo de la encuesta de Alternativas con respecto a los crierios:",null,null,null,null,null,"\"Alternativas en base al criterio x\""]
[]
[null,"a)",null,null,"d)"]
[]
[null,"b)",null,null,"e)"]
[]
[null,"c)",null,null,"f)"]
[]
[]
["4)","Al terminar las encuestas se obtienen a los pesos de los criterios y las prioridades de las alternativas"]

{"sheet":"Analisis","index":1,"n_rows":139,"n_cols":33,"rows_kept":139,"cut":false,"hidden":false,"merged":[[112,3,112,4],[112,14,112,17],[7,3,7,9],[122,1,124,6],[103,24,103,25],[104,24,104,25],[105,24,105,25],[106,24,106,25],[107,24,107,25],[108,24,108,25],[109,24,109,25],[115,14,115,15],[116,14,116,15],[117,14,117,15],[113,16,113,17],[114,16,114,17],[115,16,115,17],[116,16,116,17],[117,16,117,17],[105,10,105,11],[106,10,106,11],[107,10,107,11],[108,10,108,11],[109,10,109,11],[109,12,109,13],[109,14,109,15],[109,16,109,17],[109,18,109,19],[109,20,109,21],[109,22,109,23],[101,14,101,19],[113,14,113,15],[114,14,114,15],[107,12,107,13],[107,14,107,15],[107,16,107,17],[107,18,107,19],[107,20,107,21],[107,22,107,23],[108,12,108,13],[108,14,108,15],[108,16,108,17],[108,18,108,19],[108,20,108,21],[108,22,108,23],[105,12,105,13],[105,14,105,15],[105,16,105,17],[105,18,105,19],[105,20,105,21],[105,22,105,23],[106,12,106,13],[106,14,106,15],[106,16,106,17],[106,18,106,19],[106,20,106,21],[106,22,106,23],[101,3,101,5],[103,12,103,13],[103,14,103,15],[103,16,103,17],[103,18,103,19],[103,20,103,21],[103,22,103,23],[104,12,104,13],[104,14,104,15],[104,16,104,17],[104,18,104,19],[104,20,104,21],[104,22,104,23],[44,0,45,2],[17,2,17,3],[17,4,17,5],[18,4,18,5],[19,4,19,5],[99,0,100,2],[41,0,42,2],[47,3,47,4],[49,1,49,2],[50,1,50,2],[36,0,38,5],[25,2,26,4],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[56,0,56,2],[66,0,67,2],[75,1,75,2],[70,1,70,2],[96,0,97,2],[58,0,59,1],[63,0,64,3],[66,3,67,15],[6,13,7,26],[10,13,12,26],[20,12,21,13],[15,17,16,18],[15,14,16,15],[15,11,16,12],[15,20,16,21],[20,15,21,16],[15,23,16,24],[15,26,16,27],[20,18,21,19],[20,21,21,22],[20,24,21,25],[75,7,75,8],[69,3,69,4],[71,1,71,2],[72,1,72,2],[73,1,73,2],[0,0,2,8],[8,3,8,4],[9,3,9,4],[7,0,7,2],[8,0,8,2],[9,0,9,2],[4,4,5,6],[21,4,21,5],[20,2,20,3],[21,2,21,3],[11,2,11,3],[11,4,11,5],[18,2,18,3],[19,2,19,3],[15,2,16,3],[15,4,16,5],[20,4,20,5],[22,4,22,5],[22,2,22,3],[71,19,71,20],[72,19,72,20],[70,15,70,18],[70,19,70,20],[70,21,70,22],[69,19,69,22],[71,15,71,18],[71,21,71,22],[74,1,74,2],[72,21,72,22],[73,21,73,22],[74,21,74,22],[69,9,69,10],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[75,21,75,22],[73,19,73,20],[74,19,74,20],[75,19,75,20],[72,15,72,18],[73,15,73,18],[74,15,74,18],[75,15,75,18],[89,1,89,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[77,15,77,16],[78,15,78,16],[77,17,77,18],[78,17,78,18],[83,3,83,4],[83,9,83,10],[87,15,87,18],[87,19,87,20],[87,21,87,22],[88,15,88,18],[84,7,84,8],[85,7,85,8],[86,7,86,8],[87,7,87,8],[88,7,88,8],[83,19,83,22],[84,15,84,18],[84,19,84,20],[84,21,84,22],[85,15,85,18],[85,19,85,20],[85,21,85,22],[86,15,86,18],[86,19,86,20],[86,21,86,22],[92,15,92,16],[92,17,92,18],[88,21,88,22],[89,15,89,18],[89,19,89,20],[89,21,89,22],[91,15,91,16],[91,17,91,18],[89,7,89,8],[88,19,88,20]]}
["Aplicación de la tecnica AHP a Proyectos"]
[]
[]
[]
[null,null,null,null,"1. (Presionar \"Inicio del Proyecto\")"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Estructura Jerárquica"]
["Nombre",null,null,"Destinos Erasmus"]
["Número de Criterios",null,null,3]
["Número de Alternativas",null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D8","v":"Destinos Erasmus"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"2. Definir los Criterios",null,"3. Definir las Alternativas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,"Nombre de Criterios",null,"Nombre de Alternativas",null,null,null,null,null,null,{"$f":"+IF(C22<>\"\",C22,\"\")","v":""},null,null,{"$f":"+IF(C20<>\"\",C18,\"\")","v":"Formación"},null,null,{"$f":"IF(C18=\"\",\"\",IF(C20=\"\",C18,C19))","v":"Costo de Vida"},null,null,{"$f":"IF(C19=\"\",\"\",IF(C20=\"\",C19,C20))","v":"Ocio"},null,null,{"$f":"+IF(C21<>\"\",C21,\"\")","v":""},null,null,{"$f":"+IF(G23=6,C23,\"\")","v":""},null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,1,"Formación",null,"Munchen",null,{"$f":"+IF(C18=\"\",\"\",1)","v":1},{"$f":"+IF(E18=\"\",\"\",1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,2,"Costo de Vida",null,"London",null,{"$f":"+IF(C19=\"\",\"\",2)","v":2},{"$f":"+IF(E19=\"\",\"\",2)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,3,"Ocio",null,"Praga",null,{"$f":"+IF(C20=\"\",\"\",3)","v":3},{"$f":"+IF(E20=\"\",\"\",3)","v":3}]
[null,4,null,null,null,null,{"$f":"+IF(C21=\"\",\"\",4)","v":""},{"$f":"+IF(E21=\"\",\"\",4)","v":""},null,null,null,null,{"$f":"+IF(H22=5,E22,\"\")","v":""},null,null,{"$f":"+IF(E20<>\"\",E18,\"\")","v":"Munchen"},null,null,{"$f":"IF(E18=\"\",\"\",IF(E20=\"\",E18,E19))","v":"London"},null,null,{"$f":"IF(E19=\"\",\"\",IF(E20=\"\",E19,E20))","v":"Praga"},null,null,{"$f":"+IF(H21=4,E21,\"\")","v":""}]
[null,5,null,null,null,null,{"$f":"+IF(C22=\"\",\"\",5)","v":""},{"$f":"+IF(E22=\"\",\"\",5)","v":""}]
[null,6,null,null,null,null,{"$f":"+IF(C23=\"\",\"\",6)","v":""}]
[]
[]
[null,null,"4. Fin de la primera parte"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Resultados"]
[]
[]
[]
[]
["Pesos de Criterios"]
[]
[]
["Prioridades Locales"]
[]
[]
[null,null,null,"Métodos"]
[null,null,null,"Aproximado","Exacto",null,null,null,null,"Nombres","Criterios"]
[null,{"$f":"+IF(Analisis!C18=\"\",\"\",Analisis!C18)","v":"Formación"},null,{"$f":"+'Calculo de los criterios'!S9","v":0.72350605721266426},{"$f":"+'Calculo de los criterios'!V29","v":0.73064467136111755},null,null,null,null,{"$f":"+B50","v":"Formación"},{"$f":"+D50","v":0.72350605721266426}]
[null,{"$f":"+IF(Analisis!C19=\"\",\"\",Analisis!C19)","v":"Costo de Vida"},null,{"$f":"+'Calculo de los criterios'!S10","v":0.19318605992738133},{"$f":"+'Calculo de los criterios'!V30","v":0.18839409663913004},null,null,null,null,{"$f":"+B51","v":"Costo de Vida"},{"$f":"+D51","v":0.19318605992738133}]
[null,{"$f":"+IF(Analisis!C20=\"\",\"\",Analisis!C20)","v":"Ocio"},null,{"$f":"+'Calculo de los criterios'!S11","v":8.3307882859954524E-2},{"$f":"+'Calculo de los criterios'!V31","v":8.0961231999752442E-2},null,null,null,null,"Ocio",8.3307882859954524E-2]
[null,{"$f":"+IF(Analisis!C21=\"\",\"\",Analisis!C21)","v":""},null,{"$f":"+'Calculo de los criterios'!S12","v":""},{"$f":"+'Calculo de los criterios'!V32","v":""},null,null,null,null,"",""]
[null,{"$f":"+IF(Analisis!C22=\"\",\"\",Analisis!C22)","v":""},null,{"$f":"+'Calculo de los criterios'!S13","v":""},{"$f":"+'Calculo de los criterios'!V33","v":""},null,null,null,null,"",""]
[null,{"$f":"+IF(Analisis!C23=\"\",\"\",Analisis!C23)","v":""},null,{"$f":"+'Calculo de los criterios'!S14","v":""},{"$f":"+'Calculo de los criterios'!V34","v":""},{"$f":"+D55","v":""},"",null,null,"",""]
[]
["Consistencia según los métodos"]
[]
["Consistencia de la Matriz",null,null,"Aproximado",{"$f":"+'Calculo de los criterios'!X9","v":0.10717663573206684},{"$f":"+'Calculo de los criterios'!Z9","v":"La matriz es inconsistente, se debe volver a evaluar"}]
[null,null,null,"Exacto",{"$f":"+'Calculo de los criterios'!AB30","v":6.2391882315018583E-2},{"$f":"+'Calculo de los criterios'!AD29","v":"La matriz es consistente"}]
[]
[null,null,null,null,null,null,"(Presionar para tener el valor Exacto)"]
[]
["Prioridades de Alternativas"]
[]
[]
["Prioridades Locales:",null,null,"Comparacion de todas las alternativas respecto a cada criterio"]
[]
[]
[null,null,null,"Métodos",null,null,null,null,null,"Métodos",null,null,null,null,null,null,null,null,null,{"$f":"+J70","v":"Métodos"}]
[null,{"$f":"+IF(Analisis!C18=\"\",\"\",Analisis!C18)","v":"Formación"},null,"Aproximado","Exacto",null,null,{"$f":"+IF(Analisis!C19=\"\",\"\",Analisis!C19)","v":"Costo de Vida"},null,"Aproximado","Exacto",null,null,null,null,{"$f":"+IF(Analisis!C20=\"\",\"\",Analisis!C20)","v":"Ocio"},null,null,null,{"$f":"+J71","v":"Aproximado"},null,{"$f":"+K71","v":"Exacto"}]
[null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,{"$f":"+'Calculo de los criterios'!R46","v":8.5324397824397824E-2},{"$f":"+'Calculo de los criterios'!T65","v":8.4144148481701708E-2},null,null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,{"$f":"+'Calculo de los criterios'!R77","v":0.25059254471019177},{"$f":"+'Calculo de los criterios'!T96","v":0.24994741772923482},null,null,null,null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,null,null,{"$f":"+'Calculo de los criterios'!R108","v":0.65554501370440654},null,{"$f":"+'Calculo de los criterios'!T127","v":0.65862996564355225}]
[null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,{"$f":"+'Calculo de los criterios'!R47","v":0.21323815073815075},{"$f":"+'Calculo de los criterios'!T66","v":0.21091984291133428},null,null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,{"$f":"+'Calculo de los criterios'!R78","v":0.68034906270200379},{"$f":"+'Calculo de los criterios'!T97","v":0.68127689982151429},null,null,null,null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,null,null,{"$f":"+'Calculo de los criterios'!R109","v":7.9643685431161723E-2},null,{"$f":"+'Calculo de los criterios'!T128","v":7.8616863015871841E-2}]
[null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,{"$f":"+'Calculo de los criterios'!R48","v":0.7014374514374514},{"$f":"+'Calculo de los criterios'!T67","v":0.70493600860696415},null,null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,{"$f":"+'Calculo de los criterios'!R79","v":6.9058392587804343E-2},{"$f":"+'Calculo de los criterios'!T98","v":6.8775682449250683E-2},null,null,null,null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,null,null,{"$f":"+'Calculo de los criterios'!R110","v":0.26481130086443178},null,{"$f":"+'Calculo de los criterios'!T129","v":0.26275317134057585}]
[null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,{"$f":"+'Calculo de los criterios'!R49","v":""},{"$f":"+'Calculo de los criterios'!T68","v":""},null,null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,{"$f":"+'Calculo de los criterios'!R80","v":""},{"$f":"+'Calculo de los criterios'!T99","v":""},null,null,null,null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,null,null,{"$f":"+'Calculo de los criterios'!R111","v":""},null,{"$f":"+'Calculo de los criterios'!T130","v":""}]
[null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,{"$f":"+'Calculo de los criterios'!R50","v":""},{"$f":"+'Calculo de los criterios'!T69","v":""},null,null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,{"$f":"+'Calculo de los criterios'!R81","v":""},{"$f":"+'Calculo de los criterios'!T100","v":""},null,null,null,null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,null,null,{"$f":"+'Calculo de los criterios'!R112","v":""},null,{"$f":"+'Calculo de los criterios'!T131","v":""}]
[]
[null,"Aproximado",{"$f":"+'Calculo de los criterios'!W47","v":5.0808344077574598E-2},{"$f":"+'Calculo de los criterios'!Y47","v":"La matriz es consistente"},null,null,null,"Aproximado",{"$f":"+'Calculo de los criterios'!W78","v":1.4002149183144607E-2},{"$f":"+'Calculo de los criterios'!Y78","v":"La matriz es consistente"},null,null,null,null,null,"Aproximado",null,{"$f":"+'Calculo de los criterios'!W109","v":4.7001499800361286E-2},null,{"$f":"+'Calculo de los criterios'!Y109","v":"La matriz es consistente"}]
[null,"Exacto",{"$f":"+'Calculo de los criterios'!Y64","v":3.1121685597370094E-2},{"$f":"+'Calculo de los criterios'!AA63","v":"La matriz es consistente"},null,null,null,"Exacto",{"$f":"+'Calculo de los criterios'!Y95","v":8.8487412029577463E-3},{"$f":"+'Calculo de los criterios'!AA94","v":"La matriz es consistente"},null,null,null,null,null,{"$f":"+V71","v":"Exacto"},null,{"$f":"+'Calculo de los criterios'!Y126","v":3.1121685597369667E-2},null,{"$f":"+'Calculo de los criterios'!AA125","v":"La matriz es consistente"}]
[]
[null,null,null,"(Presionar para tener el valor Exacto)",null,null,null,null,null,"(Presionar para tener el valor Exacto)",null,null,null,null,null,null,null,null,null,"(Presionar para tener el valor Exacto)"]
[]
[]
[null,null,null,"Métodos",null,null,null,null,null,"Métodos",null,null,null,null,null,null,null,null,null,{"$f":"+J84","v":"Métodos"}]
[null,{"$f":"+IF(Analisis!C21=\"\",\"\",Analisis!C21)","v":""},null,"Aproximado","Exacto",null,null,{"$f":"+IF(Analisis!C22=\"\",\"\",Analisis!C22)","v":""},null,"Aproximado","Exacto",null,null,null,null,{"$f":"+IF(Analisis!C23=\"\",\"\",Analisis!C23)","v":""},null,null,null,{"$f":"+J85","v":"Aproximado"},null,{"$f":"+K85","v":"Exacto"}]
[null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,{"$f":"+'Calculo de los criterios'!R139","v":""},{"$f":"+'Calculo de los criterios'!T158","v":""},null,null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,{"$f":"+'Calculo de los criterios'!R170","v":""},{"$f":"+'Calculo de los criterios'!T189","v":""},null,null,null,null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,null,null,{"$f":"+'Calculo de los criterios'!R201","v":""},null,{"$f":"+'Calculo de los criterios'!T220","v":""}]
[null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,{"$f":"+'Calculo de los criterios'!R140","v":""},{"$f":"+'Calculo de los criterios'!T159","v":""},null,null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,{"$f":"+'Calculo de los criterios'!R171","v":""},{"$f":"+'Calculo de los criterios'!T190","v":""},null,null,null,null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,null,null,{"$f":"+'Calculo de los criterios'!R202","v":""},null,{"$f":"+'Calculo de los criterios'!T221","v":""}]
[null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,{"$f":"+'Calculo de los criterios'!R141","v":""},{"$f":"+'Calculo de los criterios'!T160","v":""},null,null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,{"$f":"+'Calculo de los criterios'!R172","v":""},{"$f":"+'Calculo de los criterios'!T191","v":""},null,null,null,null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,null,null,{"$f":"+'Calculo de los criterios'!R203","v":""},null,{"$f":"+'Calculo de los criterios'!T222","v":""}]
[null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,{"$f":"+'Calculo de los criterios'!R142","v":""},{"$f":"+'Calculo de los criterios'!T161","v":""},null,null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,{"$f":"+'Calculo de los criterios'!R173","v":""},{"$f":"+'Calculo de los criterios'!T192","v":""},null,null,null,null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,null,null,{"$f":"+'Calculo de los criterios'!R204","v":""},null,{"$f":"+'Calculo de los criterios'!T223","v":""}]
[null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,{"$f":"+'Calculo de los criterios'!R143","v":""},{"$f":"+'Calculo de los criterios'!T162","v":""},null,null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,{"$f":"+'Calculo de los criterios'!R174","v":""},{"$f":"+'Calculo de los criterios'!T193","v":""},null,null,null,null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,null,null,{"$f":"+'Calculo de los criterios'!R205","v":""},null,{"$f":"+'Calculo de los criterios'!T224","v":""}]
[]
[null,"Aproximado",{"$f":"+'Calculo de los criterios'!W140","v":0},{"$f":"+'Calculo de los criterios'!Y140","v":""},null,null,null,"Aproximado",{"$f":"+'Calculo de los criterios'!W171","v":0},{"$f":"+'Calculo de los criterios'!Y171","v":""},null,null,null,null,null,"Aproximado",null,{"$f":"+'Calculo de los criterios'!W202","v":0},null,{"$f":"+'Calculo de los criterios'!Y202","v":""}]
[null,"Exacto",{"$f":"+'Calculo de los criterios'!Y157","v":0},{"$f":"+'Calculo de los criterios'!AA156","v":""},null,null,null,"Exacto",{"$f":"+'Calculo de los criterios'!Y188","v":0},{"$f":"+'Calculo de los criterios'!AA187","v":""},null,null,null,null,null,{"$f":"+V85","v":"Exacto"},null,{"$f":"+'Calculo de los criterios'!Y219","v":0},null,{"$f":"+'Calculo de los criterios'!AA218","v":""}]
[]
[null,null,null,"(Presionar para tener el valor Exacto)",null,null,null,null,null,"(Presionar para tener el valor Exacto)",null,null,null,null,null,null,null,null,null,"(Presionar para tener el valor Exacto)"]
[]
["Alternativas"]
[]
[]
["Prioridades Globales"]
[]
[null,null,null,"Método Aproximado",null,null,null,null,null,null,null,null,null,null,"Método Exacto"]
[]
[null,null,{"$f":"+$B$50","v":"Formación"},{"$f":"+$B$51","v":"Costo de Vida"},{"$f":"+$B$52","v":"Ocio"},{"$f":"+$B$53","v":""},{"$f":"+$B$54","v":""},{"$f":"+$B$55","v":""},"Overall",null,null,null,{"$f":"+C104","v":"Formación"},null,{"$f":"+D104","v":"Costo de Vida"},null,{"$f":"+E104","v":"Ocio"},null,{"$f":"+F104","v":""},null,{"$f":"+G104","v":""},null,{"$f":"+H104","v":""},null,"Overall"]
[null,null,{"$f":"+D50","v":0.72350605721266426},{"$f":"+D51","v":0.19318605992738133},{"$f":"+D52","v":8.3307882859954524E-2},{"$f":"+D53","v":""},{"$f":"+D54","v":""},{"$f":"+D55","v":""},null,null,null,null,{"$f":"+E50","v":0.73064467136111755},null,{"$f":"+E51","v":0.18839409663913004},null,{"$f":"+E52","v":8.0961231999752442E-2},null,{"$f":"+E53","v":""},null,{"$f":"+E54","v":""},null,{"$f":"+E55","v":""}]
[null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},{"$f":"+D72","v":8.5324397824397824E-2},{"$f":"+J72","v":0.25059254471019177},{"$f":"+T72","v":0.65554501370440654},{"$f":"+D86","v":""},{"$f":"+J86","v":""},{"$f":"+T86","v":""},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C106:H106)=0,\"\",SUMPRODUCT($C$105:$H$105,C106:H106))","v":0.16475577222482696},null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,{"$f":"+E72","v":8.4144148481701708E-2},null,{"$f":"+K72","v":0.24994741772923482},null,{"$f":"+V72","v":0.65862996564355225},null,{"$f":"+E86","v":""},null,{"$f":"+K86","v":""},null,{"$f":"+V86","v":""},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M106:X106)=0,\"\",SUMPRODUCT($M$105:$X$105,M106:X106))","v":0.16189158513521312}]
[null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},{"$f":"+D73","v":0.21323815073815075},{"$f":"+J73","v":0.68034906270200379},{"$f":"+T73","v":7.9643685431161723E-2},{"$f":"+D87","v":""},{"$f":"+J87","v":""},{"$f":"+T87","v":""},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C107:H107)=0,\"\",SUMPRODUCT($C$105:$H$105,C107:H107))","v":0.29234799530300054},null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,{"$f":"+E73","v":0.21091984291133428},null,{"$f":"+K73","v":0.68127689982151429},null,{"$f":"+V73","v":7.8616863015871841E-2},null,{"$f":"+E87","v":""},null,{"$f":"+K87","v":""},null,{"$f":"+V87","v":""},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M107:X107)=0,\"\",SUMPRODUCT($M$105:$X$105,M107:X107))","v":0.28882092349619243}]
[null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},{"$f":"+D74","v":0.7014374514374514},{"$f":"+J74","v":6.9058392587804343E-2},{"$f":"+T74","v":0.26481130086443178},{"$f":"+D88","v":""},{"$f":"+J88","v":""},{"$f":"+T88","v":""},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C108:H108)=0,\"\",SUMPRODUCT($C$105:$H$105,C108:H108))","v":0.54289623247217245},null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,{"$f":"+E74","v":0.70493600860696415},null,{"$f":"+K74","v":6.8775682449250683E-2},null,{"$f":"+V74","v":0.26275317134057585},null,{"$f":"+E88","v":""},null,{"$f":"+K88","v":""},null,{"$f":"+V88","v":""},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M108:X108)=0,\"\",SUMPRODUCT($M$105:$X$105,M108:X108))","v":0.54928749136859456}]
[null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},{"$f":"+D75","v":""},{"$f":"+J75","v":""},{"$f":"+T75","v":""},{"$f":"+D89","v":""},{"$f":"+J89","v":""},{"$f":"+T89","v":""},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C109:H109)=0,\"\",SUMPRODUCT($C$105:$H$105,C109:H109))","v":""},null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,{"$f":"+E75","v":""},null,{"$f":"+K75","v":""},null,{"$f":"+V75","v":""},null,{"$f":"+E89","v":""},null,{"$f":"+K89","v":""},null,{"$f":"+V89","v":""},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M109:X109)=0,\"\",SUMPRODUCT($M$105:$X$105,M109:X109))","v":""}]
[null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},{"$f":"+D76","v":""},{"$f":"+J76","v":""},{"$f":"+T76","v":""},{"$f":"+D90","v":""},{"$f":"+J90","v":""},{"$f":"+T90","v":""},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C110:H110)=0,\"\",SUMPRODUCT($C$105:$H$105,C110:H110))","v":""},null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,{"$f":"+E76","v":""},null,{"$f":"+K76","v":""},null,{"$f":"+V76","v":""},null,{"$f":"+E90","v":""},null,{"$f":"+K90","v":""},null,{"$f":"+V90","v":""},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M110:X110)=0,\"\",SUMPRODUCT($M$105:$X$105,M110:X110))","v":""}]
[]
[]
[null,null,null,{"$f":"+Analisis!D8","v":"Destinos Erasmus"},null,null,null,null,null,null,null,null,null,null,{"$f":"+D8","v":"Destinos Erasmus"}]
[null,null,null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C106:H106)=0,\"\",SUMPRODUCT($C$105:$H$105,C106:H106))","v":0.16475577222482696},null,null,null,null,null,null,null,null,null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M106:X106)=0,\"\",SUMPRODUCT($M$105:$X$105,M106:X106))","v":0.16189158513521312}]
[null,null,null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C107:H107)=0,\"\",SUMPRODUCT($C$105:$H$105,C107:H107))","v":0.29234799530300054},null,null,null,null,null,null,null,null,null,{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M107:X107)=0,\"\",SUMPRODUCT($M$105:$X$105,M107:X107))","v":0.28882092349619243}]
[null,null,null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C108:H108)=0,\"\",SUMPRODUCT($C$105:$H$105,C108:H108))","v":0.54289623247217245},null,null,null,null,null,null,null,null,null,{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M108:X108)=0,\"\",SUMPRODUCT($M$105:$X$105,M108:X108))","v":0.54928749136859456}]
[null,null,null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C109:H109)=0,\"\",SUMPRODUCT($C$105:$H$105,C109:H109))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M109:X109)=0,\"\",SUMPRODUCT($M$105:$X$105,M109:X109))","v":""}]
[null,null,null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},{"$f":"+IF(SUMPRODUCT($C$105:$H$105,C110:H110)=0,\"\",SUMPRODUCT($C$105:$H$105,C110:H110))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""},null,{"$f":"+IF(SUMPRODUCT($M$105:$X$105,M110:X110)=0,\"\",SUMPRODUCT($M$105:$X$105,M110:X110))","v":""}]
[]
[]
[]
[]
[null,"Gráficos de resultados "]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"+IF(Analisis!$E$18=\"\",\"\",Analisis!$E$18)","v":"Munchen"},{"$f":"+IF(Analisis!$E$19=\"\",\"\",Analisis!$E$19)","v":"London"},{"$f":"+IF(Analisis!$E$20=\"\",\"\",Analisis!$E$20)","v":"Praga"},{"$f":"+IF(Analisis!$E$21=\"\",\"\",Analisis!$E$21)","v":""},{"$f":"+IF(Analisis!$E$22=\"\",\"\",Analisis!$E$22)","v":""}]
[null,{"$f":"+$B$50","v":"Formación"},{"$f":"+IF(C106=\"\",\"\",C106)","v":8.5324397824397824E-2},{"$f":"+IF(C107=\"\",\"\",C107)","v":0.21323815073815075},{"$f":"+IF(C108=\"\",\"\",C108)","v":0.7014374514374514},{"$f":"+IF(C109=\"\",\"\",C109)","v":""},{"$f":"+IF(C110=\"\",\"\",C110)","v":""}]
[null,{"$f":"+$B$51","v":"Costo de Vida"},{"$f":"+IF(D106=\"\",\"\",D106)","v":0.25059254471019177},{"$f":"+IF(D107=\"\",\"\",D107)","v":0.68034906270200379},{"$f":"+IF(D108=\"\",\"\",D108)","v":6.9058392587804343E-2},{"$f":"+IF(D109=\"\",\"\",D109)","v":""},{"$f":"+IF(D110=\"\",\"\",D110)","v":""}]
[null,{"$f":"+$B$52","v":"Ocio"},{"$f":"+IF(E106=\"\",\"\",E106)","v":0.65554501370440654},{"$f":"+IF(E107=\"\",\"\",E107)","v":7.9643685431161723E-2},{"$f":"+IF(E108=\"\",\"\",E108)","v":0.26481130086443178},{"$f":"+IF(E109=\"\",\"\",E109)","v":""},{"$f":"+IF(E110=\"\",\"\",E110)","v":""}]
[null,{"$f":"+$B$53","v":""},{"$f":"+IF(F106=\"\",\"\",F106)","v":""},{"$f":"+IF(F107=\"\",\"\",F107)","v":""},{"$f":"+IF(F108=\"\",\"\",F108)","v":""},{"$f":"+IF(F109=\"\",\"\",F109)","v":""},{"$f":"+IF(F110=\"\",\"\",F110)","v":""}]
[null,{"$f":"+$B$54","v":""},{"$f":"+IF(G106=\"\",\"\",G106)","v":""},{"$f":"+IF(G107=\"\",\"\",G107)","v":""},{"$f":"+IF(G108=\"\",\"\",G108)","v":""},{"$f":"+IF(G109=\"\",\"\",G109)","v":""},{"$f":"+IF(G110=\"\",\"\",G110)","v":""}]
[null,{"$f":"+$B$55","v":""},{"$f":"+IF(H106=\"\",\"\",H106)","v":""},{"$f":"+IF(H107=\"\",\"\",H107)","v":""},{"$f":"+IF(H108=\"\",\"\",H108)","v":""},{"$f":"+IF(H109=\"\",\"\",H109)","v":""},{"$f":"+IF(H110=\"\",\"\",H110)","v":""}]
[null,"Overall",{"$f":"+IF(I106=\"\",\"\",I106)","v":0.16475577222482696},{"$f":"+IF(I107=\"\",\"\",I107)","v":0.29234799530300054},{"$f":"+IF(I108=\"\",\"\",I108)","v":0.54289623247217245},{"$f":"+IF(I109=\"\",\"\",I109)","v":""},{"$f":"+IF(I110=\"\",\"\",I110)","v":""}]
[null,"Final",{"$f":"+C138","v":0.16475577222482696},{"$f":"+D138","v":0.29234799530300054},{"$f":"+E138","v":0.54289623247217245},{"$f":"+F138","v":""},{"$f":"+G138","v":""}]

{"sheet":"Enc. de Criterios","index":2,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,9,43,11],[29,6,29,7],[27,6,27,7],[25,6,25,7],[39,6,39,7],[37,6,37,7],[35,6,35,7],[33,6,33,7],[31,6,31,7],[10,0,10,3],[10,4,10,5],[0,0,1,2],[3,0,4,2],[23,6,23,7],[21,6,21,7],[19,6,19,7],[17,6,17,7],[15,6,15,7],[13,6,13,7],[10,6,10,7],[11,6,11,7],[21,18,22,19],[23,18,24,19],[25,18,26,19],[27,18,28,19],[13,20,16,21],[17,20,18,21],[19,20,20,21],[21,20,22,21],[23,20,24,21],[25,20,26,21],[27,20,28,21],[13,18,16,19],[17,18,18,19],[19,18,20,19]]}
["Encuestas"]
[]
[]
["Criterios"]
[]
["Nota:","En esta sección la evaluación sera tomando como referencia el primer criterio con respecto al segundo"]
["Ejemplo:","Si el riesgo de que A es 3 veces mas importante que el riesgo de B, se colocara el valor de 3; si en cambio la relación es 1/3, se marcará la casilla de inversa."]
[]
[null,"A vs B",null,null,false,null,3,null,{"$f":"+IF(E9=FALSE,G9,1/G9)","v":3}]
[]
["Relación de criterios",null,null,null,"Inverso de la relación",null,"Calificación"]
[{"$f":"IF(Analisis!D9>=2,+CONCATENATE(Analisis!C18,\" \",\"vs\",\" \",Analisis!C19),\"\")","v":"Formación vs Costo de Vida"},null,null,null,false,null,5,null,{"$f":"+IF(A12=\"\",\"\",IF(E12=TRUE,G12,1/G12))","v":0.2},{"$f":"+IF(A12=\"\",\"\",1/I12)","v":5},{"$f":"+IF(A12=\"\",\"\",CONCATENATE(Analisis!C18,\" es \",J12,\" veces más importante que \",Analisis!C19))","v":"Formación es 5 veces más importante que Costo de Vida"}]
[]
[{"$f":"IF(Analisis!D9>=3,+CONCATENATE(Analisis!C18,\" \",\"vs\",\" \",Analisis!C20),\"\")","v":"Formación vs Ocio"},null,null,null,false,null,7,null,{"$f":"+IF(A14=\"\",\"\",IF(E14=TRUE,G14,1/G14))","v":0.14285714285714285},{"$f":"+IF(A14=\"\",\"\",1/I14)","v":7},{"$f":"+IF(A14=\"\",\"\",CONCATENATE(Analisis!C18,\" es \",J14,\" veces más importante que \",Analisis!C20))","v":"Formación es 7 veces más importante que Ocio"},null,null,null,null,null,null,null,"Intensidad de importancia",null,"Definición"]
[]
[{"$f":"IF(Analisis!D9>=3,+CONCATENATE(Analisis!C19,\" \",\"vs\",\" \",Analisis!C20),\"\")","v":"Costo de Vida vs Ocio"},null,null,null,false,null,3,null,{"$f":"+IF(A16=\"\",\"\",IF(E16=TRUE,G16,1/G16))","v":0.33333333333333331},{"$f":"+IF(A16=\"\",\"\",1/I16)","v":3},{"$f":"+IF(A16=\"\",\"\",CONCATENATE(Analisis!C19,\" es \",J16,\" veces más importante que \",Analisis!C20))","v":"Costo de Vida es 3 veces más importante que Ocio"}]
[]
[{"$f":"IF(Analisis!D9>=4,+CONCATENATE(Analisis!C18,\" \",\"vs\",\" \",Analisis!C21),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A18=\"\",\"\",IF(E18=TRUE,G18,1/G18))","v":""},{"$f":"+IF(A18=\"\",\"\",1/I18)","v":""},{"$f":"+IF(A18=\"\",\"\",CONCATENATE(Analisis!C18,\" es \",J18,\" veces más importante que \",Analisis!C21))","v":""},null,null,null,null,null,null,null,1,null,"IGUAL"]
[]
[{"$f":"IF(Analisis!D9>=4,+CONCATENATE(Analisis!C19,\" \",\"vs\",\" \",Analisis!C21),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A20=\"\",\"\",IF(E20=TRUE,G20,1/G20))","v":""},{"$f":"+IF(A20=\"\",\"\",1/I20)","v":""},{"$f":"+IF(A20=\"\",\"\",CONCATENATE(Analisis!C19,\" es \",J20,\" veces más importante que \",Analisis!C21))","v":""},null,null,null,null,null,null,null,3,null,"MODERADO"]
[]
[{"$f":"IF(Analisis!D9>=4,+CONCATENATE(Analisis!C20,\" \",\"vs\",\" \",Analisis!C21),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A22=\"\",\"\",IF(E22=TRUE,G22,1/G22))","v":""},{"$f":"+IF(A22=\"\",\"\",1/I22)","v":""},{"$f":"+IF(A22=\"\",\"\",CONCATENATE(Analisis!C20,\" es \",J22,\" veces más importante que \",Analisis!C21))","v":""},null,null,null,null,null,null,null,5,null,"FUERTE"]
[]
[{"$f":"IF(Analisis!D9>=5,+CONCATENATE(Analisis!C18,\" \",\"vs\",\" \",Analisis!C22),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A24=\"\",\"\",IF(E24=TRUE,G24,1/G24))","v":""},{"$f":"+IF(A24=\"\",\"\",1/I24)","v":""},{"$f":"+IF(A24=\"\",\"\",CONCATENATE(Analisis!C18,\" es \",J24,\" veces más importante que \",Analisis!C22))","v":""},null,null,null,null,null,null,null,7,null,"MUY FUERTE"]
[]
[{"$f":"IF(Analisis!D9>=5,+CONCATENATE(Analisis!C19,\" \",\"vs\",\" \",Analisis!C22),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A26=\"\",\"\",IF(E26=TRUE,G26,1/G26))","v":""},{"$f":"+IF(A26=\"\",\"\",1/I26)","v":""},{"$f":"+IF(A26=\"\",\"\",CONCATENATE(Analisis!C19,\" es \",J26,\" veces más importante que \",Analisis!C22))","v":""},null,null,null,null,null,null,null,9,null,"EXTREMA"]
[]
[{"$f":"IF(Analisis!D9>=5,+CONCATENATE(Analisis!C20,\" \",\"vs\",\" \",Analisis!C22),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A28=\"\",\"\",IF(E28=TRUE,G28,1/G28))","v":""},{"$f":"+IF(A28=\"\",\"\",1/I28)","v":""},{"$f":"+IF(A28=\"\",\"\",CONCATENATE(Analisis!C20,\" es \",J28,\" veces más importante que \",Analisis!C22))","v":""},null,null,null,null,null,null,null,"2,4,6,8",null,"Valores de Transición"]
[]
[{"$f":"IF(Analisis!D9>=5,+CONCATENATE(Analisis!C21,\" \",\"vs\",\" \",Analisis!C22),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A30=\"\",\"\",IF(E30=TRUE,G30,1/G30))","v":""},{"$f":"+IF(A30=\"\",\"\",1/I30)","v":""},{"$f":"+IF(A30=\"\",\"\",CONCATENATE(Analisis!C21,\" es \",J30,\" veces más importante que \",Analisis!C22))","v":""}]
[]
[{"$f":"IF(Analisis!D9>=6,+CONCATENATE(Analisis!C18,\" \",\"vs\",\" \",Analisis!C23),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A32=\"\",\"\",IF(E32=TRUE,G32,1/G32))","v":""},{"$f":"+IF(A32=\"\",\"\",1/I32)","v":""},{"$f":"+IF(A32=\"\",\"\",CONCATENATE(Analisis!C18,\" es \",J32,\" veces más importante que \",Analisis!C23))","v":""}]
[]
[{"$f":"IF(Analisis!D9>=6,+CONCATENATE(Analisis!C19,\" \",\"vs\",\" \",Analisis!C23),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A34=\"\",\"\",IF(E34=TRUE,G34,1/G34))","v":""},{"$f":"+IF(A34=\"\",\"\",1/I34)","v":""},{"$f":"+IF(A34=\"\",\"\",CONCATENATE(Analisis!C19,\" es \",J34,\" veces más importante que \",Analisis!C23))","v":""}]
[]
[{"$f":"IF(Analisis!D9>=6,+CONCATENATE(Analisis!C20,\" \",\"vs\",\" \",Analisis!C23),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A36=\"\",\"\",IF(E36=TRUE,G36,1/G36))","v":""},{"$f":"+IF(A36=\"\",\"\",1/I36)","v":""},{"$f":"+IF(A36=\"\",\"\",CONCATENATE(Analisis!C20,\" es \",J36,\" veces más importante que \",Analisis!C23))","v":""}]
[]
[{"$f":"IF(Analisis!D9>=6,+CONCATENATE(Analisis!C21,\" \",\"vs\",\" \",Analisis!C23),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A38=\"\",\"\",IF(E38=TRUE,G38,1/G38))","v":""},{"$f":"+IF(A38=\"\",\"\",1/I38)","v":""},{"$f":"+IF(A38=\"\",\"\",CONCATENATE(Analisis!C21,\" es \",J38,\" veces más importante que \",Analisis!C23))","v":""}]
[]
[{"$f":"IF(Analisis!D9>=6,+CONCATENATE(Analisis!C22,\" \",\"vs\",\" \",Analisis!C23),\"\")","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A40=\"\",\"\",IF(E40=TRUE,G40,1/G40))","v":""},{"$f":"+IF(A40=\"\",\"\",1/I40)","v":""},{"$f":"+IF(A40=\"\",\"\",CONCATENATE(Analisis!C22,\" es \",J40,\" veces más importante que \",Analisis!C23))","v":""}]
[]
[null,"Antes de \"limpiar\", Borrar la celda G40",null,null,null,null,null,null,null,"Finalizar la encuesta"]

{"sheet":"Enc. de Alternativas","index":3,"n_rows":229,"n_cols":20,"rows_kept":229,"cut":false,"hidden":false,"merged":[[161,0,161,5],[200,0,200,5],[148,9,149,11],[138,6,138,7],[140,6,140,7],[142,6,142,7],[144,6,144,7],[146,6,146,7],[187,6,187,7],[173,6,173,7],[175,6,175,7],[177,6,177,7],[179,6,179,7],[181,6,181,7],[156,0,157,2],[189,9,190,11],[168,0,168,3],[168,4,168,5],[168,6,168,7],[169,6,169,7],[171,6,171,7],[195,0,196,2],[110,9,111,11],[115,0,116,2],[136,6,136,7],[127,0,127,3],[127,4,127,5],[127,6,127,7],[128,6,128,7],[130,6,130,7],[132,6,132,7],[134,6,134,7],[120,0,120,5],[100,6,100,7],[102,6,102,7],[104,6,104,7],[108,6,108,7],[98,6,98,7],[89,0,89,3],[89,4,89,5],[89,6,89,7],[90,6,90,7],[94,6,94,7],[96,6,96,7],[92,6,92,7],[106,6,106,7],[65,6,65,7],[67,6,67,7],[71,9,72,11],[69,6,69,7],[53,6,53,7],[55,6,55,7],[57,6,57,7],[59,6,59,7],[82,0,82,5],[77,0,78,2],[38,0,39,2],[33,9,34,11],[50,0,50,3],[50,4,50,5],[50,6,50,7],[43,0,43,5],[51,6,51,7],[61,6,61,7],[63,6,63,7],[27,6,27,7],[29,6,29,7],[31,6,31,7],[0,0,1,2],[17,6,17,7],[19,6,19,7],[21,6,21,7],[23,6,23,7],[25,6,25,7],[12,4,12,5],[12,6,12,7],[13,6,13,7],[15,6,15,7],[12,0,12,3],[5,0,5,5],[224,6,224,7],[207,0,207,3],[207,4,207,5],[207,6,207,7],[183,6,183,7],[185,6,185,7],[228,9,229,11],[226,6,226,7],[208,6,208,7],[210,6,210,7],[212,6,212,7],[214,6,214,7],[216,6,216,7],[218,6,218,7],[220,6,220,7],[222,6,222,7],[23,17,24,18],[23,19,24,20],[25,17,26,18],[25,19,26,20],[27,17,28,18],[27,19,28,20],[15,17,18,18],[15,19,18,20],[19,17,20,18],[19,19,20,20],[21,17,22,18],[21,19,22,20],[59,17,60,18],[59,19,60,20],[61,17,62,18],[61,19,62,20],[63,17,64,18],[63,19,64,20],[29,17,30,18],[29,19,30,20],[53,17,56,18],[53,19,56,20],[57,17,58,18],[57,19,58,20],[96,17,97,18],[96,19,97,20],[98,17,99,18],[98,19,99,20],[100,17,101,18],[100,19,101,20],[65,17,66,18],[65,19,66,20],[67,17,68,18],[67,19,68,20],[92,17,95,18],[92,19,95,20],[130,17,133,18],[130,19,133,20],[134,17,135,18],[134,19,135,20],[136,17,137,18],[136,19,137,20],[102,17,103,18],[102,19,103,20],[104,17,105,18],[104,19,105,20],[106,17,107,18],[106,19,107,20],[144,17,145,18],[144,19,145,20],[171,17,174,18],[171,19,174,20],[175,17,176,18],[175,19,176,20],[138,17,139,18],[138,19,139,20],[140,17,141,18],[140,19,141,20],[142,17,143,18],[142,19,143,20],[183,17,184,18],[183,19,184,20],[185,17,186,18],[185,19,186,20],[210,17,213,18],[210,19,213,20],[177,17,178,18],[177,19,178,20],[179,17,180,18],[179,19,180,20],[181,17,182,18],[181,19,182,20],[220,17,221,18],[220,19,221,20],[222,17,223,18],[222,19,223,20],[224,17,225,18],[224,19,225,20],[214,17,215,18],[214,19,215,20],[216,17,217,18],[216,19,217,20],[218,17,219,18],[218,19,219,20]]}
["Alternativas"]
[]
[]
[]
[]
[{"$f":"+IF(Analisis!$D$9>=1,Analisis!C18,\"\")","v":"Formación"},null,null,null,null,null,"\"1\""]
[]
["Nota:","En esta sección la evaluación sera tomando como referencia la primera alternativa con respecto a la segunda"]
["Ejemplo:","Si el riesgo de que A es 3 veces mas importante que el riesgo de B, se colocara el valor de 3; si en cambio la relación es 1/3, se marcará la casilla de inversa."]
[]
[null,"A vs B",null,null,false,null,3,null,{"$f":"+IF(E11=FALSE,G11,1/G11)","v":3}]
[]
["Relacion de criterios",null,null,null,"Inverso de la relación",null,"Calificación"]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=2,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E19),\"\"))","v":"Munchen vs London"},null,null,null,false,null,3,null,{"$f":"+IF(A14=\"\",\"\",IF(E14=TRUE,G14,1/G14))","v":0.33333333333333331},{"$f":"+IF(A14=\"\",\"\",1/I14)","v":3},{"$f":"+IF(A14=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J14,\" más importante que \",Analisis!$E$19))","v":"Munchen es 3 más importante que London"}]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":"Munchen vs Praga"},null,null,null,false,null,7,null,{"$f":"+IF(A16=\"\",\"\",IF(E16=TRUE,G16,1/G16))","v":0.14285714285714285},{"$f":"+IF(A16=\"\",\"\",1/I16)","v":7},{"$f":"+IF(A16=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J16,\" más importante que \",Analisis!$E$20))","v":"Munchen es 7 más importante que Praga"},null,null,null,null,null,null,"Intensidad de importancia",null,"Definición"]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":"London vs Praga"},null,null,null,false,null,4,null,{"$f":"+IF(A18=\"\",\"\",IF(E18=TRUE,G18,1/G18))","v":0.25},{"$f":"+IF(A18=\"\",\"\",1/I18)","v":4},{"$f":"+IF(A18=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J18,\" más importante que \",Analisis!$E$20))","v":"London es 4 más importante que Praga"}]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A20=\"\",\"\",IF(E20=TRUE,G20,1/G20))","v":""},{"$f":"+IF(A20=\"\",\"\",1/I20)","v":""},{"$f":"+IF(A20=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J20,\" más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,1,null,"IGUAL"]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A22=\"\",\"\",IF(E22=TRUE,G22,1/G22))","v":""},{"$f":"+IF(A22=\"\",\"\",1/I22)","v":""},{"$f":"+IF(A22=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J22,\" más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,3,null,"MODERADO"]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A24=\"\",\"\",IF(E24=TRUE,G24,1/G24))","v":""},{"$f":"+IF(A24=\"\",\"\",1/I24)","v":""},{"$f":"+IF(A24=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J24,\" más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,5,null,"FUERTE"]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A26=\"\",\"\",IF(E26=TRUE,G26,1/G26))","v":""},{"$f":"+IF(A26=\"\",\"\",1/I26)","v":""},{"$f":"+IF(A26=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J26,\" más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,7,null,"MUY FUERTE"]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A28=\"\",\"\",IF(E28=TRUE,G28,1/G28))","v":""},{"$f":"+IF(A28=\"\",\"\",1/I28)","v":""},{"$f":"+IF(A28=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J28,\" más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,9,null,"EXTREMA"]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A30=\"\",\"\",IF(E30=TRUE,G30,1/G30))","v":""},{"$f":"+IF(A30=\"\",\"\",1/I30)","v":""},{"$f":"+IF(A30=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J30,\" más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,"2,4,6,8",null,"Valores de Transición"]
[]
[{"$f":"IF(A6=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E21,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A32=\"\",\"\",IF(E32=TRUE,G32,1/G32))","v":""},{"$f":"+IF(A32=\"\",\"\",1/I32)","v":""},{"$f":"+IF(A32=\"\",\"\",CONCATENATE(Analisis!$E$21,\" es \",J32,\" más importante que \",Analisis!$E$22))","v":""}]
[]
[null,null,"Antes de \"limpiar\", Borrar la celda G32",null,null,null,null,null,null,"Finalizar la encuesta"]
[]
[]
[]
[]
["Alternativas"]
[]
[]
["Para:"]
[]
[{"$f":"+IF(Analisis!$D$9>=2,Analisis!C19,\"\")","v":"Costo de Vida"},null,null,null,null,null,"\"2\""]
[]
["Nota:","En esta sección la evaluación sera tomando como referencia la primera alternativa con respecto a la segunda"]
["Ejemplo:","Si el riesgo de que A es 3 veces mas importante que el riesgo de B, se colocara el valor de 3; si en cambio la relación es 1/3, se marcará la casilla de inversa."]
[]
[null,"A vs B",null,null,false,null,3,null,{"$f":"+IF(E49=FALSE,G49,1/G49)","v":3}]
[]
["Relacion de criterios",null,null,null,"Inverso de la relación",null,"Calificación"]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=2,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E19),\"\"))","v":"Munchen vs London"},null,null,null,false,null,3,null,{"$f":"+IF(A52=\"\",\"\",IF(E52=TRUE,G52,1/G52))","v":0.33333333333333331},{"$f":"+IF(A52=\"\",\"\",1/I52)","v":3},{"$f":"+IF(A52=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J52,\" veces más importante que \",Analisis!$E$19))","v":"Munchen es 3 veces más importante que London"}]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":"Munchen vs Praga"},null,null,null,true,null,4,null,{"$f":"+IF(A54=\"\",\"\",IF(E54=TRUE,G54,1/G54))","v":4},{"$f":"+IF(A54=\"\",\"\",1/I54)","v":0.25},{"$f":"+IF(A54=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J54,\" veces más importante que \",Analisis!$E$20))","v":"Munchen es 0,25 veces más importante que Praga"},null,null,null,null,null,null,"Intensidad de importancia",null,"Definición"]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":"London vs Praga"},null,null,null,true,null,9,null,{"$f":"+IF(A56=\"\",\"\",IF(E56=TRUE,G56,1/G56))","v":9},{"$f":"+IF(A56=\"\",\"\",1/I56)","v":0.1111111111111111},{"$f":"+IF(A56=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J56,\" veces más importante que \",Analisis!$E$20))","v":"London es 0,111111111111111 veces más importante que Praga"}]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A58=\"\",\"\",IF(E58=TRUE,G58,1/G58))","v":""},{"$f":"+IF(A58=\"\",\"\",1/I58)","v":""},{"$f":"+IF(A58=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J58,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,1,null,"IGUAL"]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A60=\"\",\"\",IF(E60=TRUE,G60,1/G60))","v":""},{"$f":"+IF(A60=\"\",\"\",1/I60)","v":""},{"$f":"+IF(A60=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J60,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,3,null,"MODERADO"]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A62=\"\",\"\",IF(E62=TRUE,G62,1/G62))","v":""},{"$f":"+IF(A62=\"\",\"\",1/I62)","v":""},{"$f":"+IF(A62=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J62,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,5,null,"FUERTE"]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A64=\"\",\"\",IF(E64=TRUE,G64,1/G64))","v":""},{"$f":"+IF(A64=\"\",\"\",1/I64)","v":""},{"$f":"+IF(A64=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J64,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,7,null,"MUY FUERTE"]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A66=\"\",\"\",IF(E66=TRUE,G66,1/G66))","v":""},{"$f":"+IF(A66=\"\",\"\",1/I66)","v":""},{"$f":"+IF(A66=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J66,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,9,null,"EXTREMA"]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A68=\"\",\"\",IF(E68=TRUE,G68,1/G68))","v":""},{"$f":"+IF(A68=\"\",\"\",1/I68)","v":""},{"$f":"+IF(A68=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J68,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,"2,4,6,8",null,"Valores de Transición"]
[]
[{"$f":"IF(A44=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E21,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A70=\"\",\"\",IF(E70=TRUE,G70,1/G70))","v":""},{"$f":"+IF(A70=\"\",\"\",1/I70)","v":""},{"$f":"+IF(A70=\"\",\"\",CONCATENATE(Analisis!$E$21,\" es \",J70,\" veces más importante que \",Analisis!$E$22))","v":""}]
[]
[null,null,"Antes de \"limpiar\", Borrar la celda G70",null,null,null,null,null,null,"Finalizar la encuesta"]
[]
[]
[]
[]
[]
["Alternativas"]
[]
[]
[]
[]
[{"$f":"+IF(Analisis!$D$9>=3,Analisis!C20,\"\")","v":"Ocio"},null,null,null,null,null,"\"3\""]
[]
["Nota:","En esta sección la evaluación sera tomando como referencia la primera alternativa con respecto a la segunda"]
["Ejemplo:","Si el riesgo de que A es 3 veces mas importante que el riesgo de B, se colocara el valor de 3; si en cambio la relación es 1/3, se marcará la casilla de inversa."]
[]
[null,"A vs B",null,null,false,null,3,null,{"$f":"+IF(E88=FALSE,G88,1/G88)","v":3}]
[]
["Relacion de criterios",null,null,null,"Inverso de la relación",null,"Calificación"]
[{"$f":"IF(A83=\"\",\"\",IF(Analisis!D10>=2,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E19),\"\"))","v":"Munchen vs London"},null,null,null,true,null,7,null,{"$f":"+IF(A91=\"\",\"\",IF(E91=TRUE,G91,1/G91))","v":7},{"$f":"+IF(A91=\"\",\"\",1/I91)","v":0.14285714285714285},{"$f":"+IF(A91=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J91,\" veces más importante que \",Analisis!$E$19))","v":"Munchen es 0,142857142857143 veces más importante que London"}]
[]
[{"$f":"IF(A83=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":"Munchen vs Praga"},null,null,null,true,null,3,null,{"$f":"+IF(A93=\"\",\"\",IF(E93=TRUE,G93,1/G93))","v":3},{"$f":"+IF(A93=\"\",\"\",1/I93)","v":0.33333333333333331},{"$f":"+IF(A93=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J93,\" veces más importante que \",Analisis!$E$20))","v":"Munchen es 0,333333333333333 veces más importante que Praga"},null,null,null,null,null,null,"Intensidad de importancia",null,"Definición"]
[]
[{"$f":"IF(A83=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":"London vs Praga"},null,null,null,false,null,4,null,{"$f":"+IF(A95=\"\",\"\",IF(E95=TRUE,G95,1/G95))","v":0.25},{"$f":"+IF(A95=\"\",\"\",1/I95)","v":4},{"$f":"+IF(A95=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J95,\" veces más importante que \",Analisis!$E$20))","v":"London es 4 veces más importante que Praga"}]
[]
[{"$f":"IF(A83=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A97=\"\",\"\",IF(E97=TRUE,G97,1/G97))","v":""},{"$f":"+IF(A97=\"\",\"\",1/I97)","v":""},{"$f":"+IF(A97=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J97,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,1,null,"IGUAL"]
[]
[{"$f":"+IF(A83=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A99=\"\",\"\",IF(E99=TRUE,G99,1/G99))","v":""},{"$f":"+IF(A99=\"\",\"\",1/I99)","v":""},{"$f":"+IF(A99=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J99,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,3,null,"MODERADO"]
[]
[{"$f":"+IF(A83=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A101=\"\",\"\",IF(E101=TRUE,G101,1/G101))","v":""},{"$f":"+IF(A101=\"\",\"\",1/I101)","v":""},{"$f":"+IF(A101=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J101,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,5,null,"FUERTE"]
[]
[{"$f":"+IF(A83=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A103=\"\",\"\",IF(E103=TRUE,G103,1/G103))","v":""},{"$f":"+IF(A103=\"\",\"\",1/I103)","v":""},{"$f":"+IF(A103=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J103,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,7,null,"MUY FUERTE"]
[]
[{"$f":"+IF(A83=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A105=\"\",\"\",IF(E105=TRUE,G105,1/G105))","v":""},{"$f":"+IF(A105=\"\",\"\",1/I105)","v":""},{"$f":"+IF(A105=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J105,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,9,null,"EXTREMA"]
[]
[{"$f":"+IF(A83=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A107=\"\",\"\",IF(E107=TRUE,G107,1/G107))","v":""},{"$f":"+IF(A107=\"\",\"\",1/I107)","v":""},{"$f":"+IF(A107=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J107,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,"2,4,6,8",null,"Valores de Transición"]
[]
[{"$f":"+IF(A83=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E21,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A109=\"\",\"\",IF(E109=TRUE,G109,1/G109))","v":""},{"$f":"+IF(A109=\"\",\"\",1/I109)","v":""},{"$f":"+IF(A109=\"\",\"\",CONCATENATE(Analisis!$E$21,\" es \",J109,\" veces más importante que \",Analisis!$E$22))","v":""}]
[]
[null,null,"Antes de \"limpiar\", Borrar la celda G109",null,null,null,null,null,null,"Finalizar la encuesta"]
[]
[]
[]
[]
["Alternativas"]
[]
[]
[]
[]
[{"$f":"+IF(Analisis!$D$9>=4,Analisis!C21,\"\")","v":""},null,null,null,null,null,"\"4\""]
[]
["Nota:","En esta sección la evaluación sera tomando como referencia la primera alternativa con respecto a la segunda"]
["Ejemplo:","Si el riesgo de que A es 3 veces mas importante que el riesgo de B, se colocara el valor de 3; si en cambio la relación es 1/3, se marcará la casilla de inversa."]
[]
[null,"A vs B",null,null,false,null,3,null,{"$f":"+IF(E126=FALSE,G126,1/G126)","v":3}]
[]
["Relacion de criterios",null,null,null,"Inverso de la relación",null,"Calificación"]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=2,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E19),\"\"))","v":""},null,null,null,true,null,2,null,{"$f":"+IF(A129=\"\",\"\",IF(E129=TRUE,G129,1/G129))","v":""},{"$f":"+IF(A129=\"\",\"\",1/I129)","v":""},{"$f":"+IF(A129=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J129,\" veces más importante que \",Analisis!$E$19))","v":""}]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":""},null,null,null,false,null,4,null,{"$f":"+IF(A131=\"\",\"\",IF(E131=TRUE,G131,1/G131))","v":""},{"$f":"+IF(A131=\"\",\"\",1/I131)","v":""},{"$f":"+IF(A131=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J131,\" veces más importante que \",Analisis!$E$20))","v":""},null,null,null,null,null,null,"Intensidad de importancia",null,"Definición"]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=3,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E20),\"\"))","v":""},null,null,null,false,null,5,null,{"$f":"+IF(A133=\"\",\"\",IF(E133=TRUE,G133,1/G133))","v":""},{"$f":"+IF(A133=\"\",\"\",1/I133)","v":""},{"$f":"+IF(A133=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J133,\" veces más importante que \",Analisis!$E$20))","v":""}]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A135=\"\",\"\",IF(E135=TRUE,G135,1/G135))","v":""},{"$f":"+IF(A135=\"\",\"\",1/I135)","v":""},{"$f":"+IF(A135=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J135,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,1,null,"IGUAL"]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A137=\"\",\"\",IF(E137=TRUE,G137,1/G137))","v":""},{"$f":"+IF(A137=\"\",\"\",1/I137)","v":""},{"$f":"+IF(A137=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J137,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,3,null,"MODERADO"]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=4,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A139=\"\",\"\",IF(E139=TRUE,G139,1/G139))","v":""},{"$f":"+IF(A139=\"\",\"\",1/I139)","v":""},{"$f":"+IF(A139=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J139,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,5,null,"FUERTE"]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E18,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A141=\"\",\"\",IF(E141=TRUE,G141,1/G141))","v":""},{"$f":"+IF(A141=\"\",\"\",1/I141)","v":""},{"$f":"+IF(A141=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J141,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,7,null,"MUY FUERTE"]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E19,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A143=\"\",\"\",IF(E143=TRUE,G143,1/G143))","v":""},{"$f":"+IF(A143=\"\",\"\",1/I143)","v":""},{"$f":"+IF(A143=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J143,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,9,null,"EXTREMA"]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E20,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A145=\"\",\"\",IF(E145=TRUE,G145,1/G145))","v":""},{"$f":"+IF(A145=\"\",\"\",1/I145)","v":""},{"$f":"+IF(A145=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J145,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,"2,4,6,8",null,"Valores de Transición"]
[]
[{"$f":"+IF(A121=\"\",\"\",IF(Analisis!D10>=5,+CONCATENATE(Analisis!E21,\" \",\"vs\",\" \",Analisis!E22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A147=\"\",\"\",IF(E147=TRUE,G147,1/G147))","v":""},{"$f":"+IF(A147=\"\",\"\",1/I147)","v":""},{"$f":"+IF(A147=\"\",\"\",CONCATENATE(Analisis!$E$21,\" es \",J147,\" veces más importante que \",Analisis!$E$22))","v":""}]
[]
[null,null,"Antes de \"limpiar\", Borrar la celda G147",null,null,null,null,null,null,"Finalizar la encuesta"]
[]
[]
[]
[]
[]
[]
[]
["Alternativas"]
[]
[]
[]
[]
[{"$f":"+IF(Analisis!$D$9>=5,Analisis!C22,\"\")","v":""},null,null,null,null,null,"\"5\""]
[]
["Nota:","En esta sección la evaluación sera tomando como referencia la primera alternativa con respecto a la segunda"]
["Ejemplo:","Si el riesgo de que A es 3 veces mas importante que el riesgo de B, se colocara el valor de 3; si en cambio la relación es 1/3, se marcará la casilla de inversa."]
[]
[null,"A vs B",null,null,false,null,3,null,{"$f":"+IF(E167=FALSE,G167,1/G167)","v":3}]
[]
["Relacion de criterios",null,null,null,"Inverso de la relación",null,"Calificación"]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=2,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$19),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A170=\"\",\"\",IF(E170=TRUE,G170,1/G170))","v":""},{"$f":"+IF(A170=\"\",\"\",1/I170)","v":""},{"$f":"+IF(A170=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J170,\" veces más importante que \",Analisis!$E$19))","v":""}]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=3,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$20),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A172=\"\",\"\",IF(E172=TRUE,G172,1/G172))","v":""},{"$f":"+IF(A172=\"\",\"\",1/I172)","v":""},{"$f":"+IF(A172=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J172,\" veces más importante que \",Analisis!$E$20))","v":""},null,null,null,null,null,null,"Intensidad de importancia",null,"Definición"]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=3,+CONCATENATE(Analisis!$E$19,\" \",\"vs\",\" \",Analisis!$E$20),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A174=\"\",\"\",IF(E174=TRUE,G174,1/G174))","v":""},{"$f":"+IF(A174=\"\",\"\",1/I174)","v":""},{"$f":"+IF(A174=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J174,\" veces más importante que \",Analisis!$E$20))","v":""}]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=4,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A176=\"\",\"\",IF(E176=TRUE,G176,1/G176))","v":""},{"$f":"+IF(A176=\"\",\"\",1/I176)","v":""},{"$f":"+IF(A176=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J176,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,1,null,"IGUAL"]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=4,+CONCATENATE(Analisis!$E$19,\" \",\"vs\",\" \",Analisis!$E$21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A178=\"\",\"\",IF(E178=TRUE,G178,1/G178))","v":""},{"$f":"+IF(A178=\"\",\"\",1/I178)","v":""},{"$f":"+IF(A178=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J178,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,3,null,"MODERADO"]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=4,+CONCATENATE(Analisis!$E$20,\" \",\"vs\",\" \",Analisis!$E$21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A180=\"\",\"\",IF(E180=TRUE,G180,1/G180))","v":""},{"$f":"+IF(A180=\"\",\"\",1/I180)","v":""},{"$f":"+IF(A180=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J180,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,5,null,"FUERTE"]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A182=\"\",\"\",IF(E182=TRUE,G182,1/G182))","v":""},{"$f":"+IF(A182=\"\",\"\",1/I182)","v":""},{"$f":"+IF(A182=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J182,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,7,null,"MUY FUERTE"]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$19,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A184=\"\",\"\",IF(E184=TRUE,G184,1/G184))","v":""},{"$f":"+IF(A184=\"\",\"\",1/I184)","v":""},{"$f":"+IF(A184=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J184,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,9,null,"EXTREMA"]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$20,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A186=\"\",\"\",IF(E186=TRUE,G186,1/G186))","v":""},{"$f":"+IF(A186=\"\",\"\",1/I186)","v":""},{"$f":"+IF(A186=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J186,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,"2,4,6,8",null,"Valores de Transición"]
[]
[{"$f":"+IF(A162=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$21,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A188=\"\",\"\",IF(E188=TRUE,G188,1/G188))","v":""},{"$f":"+IF(A188=\"\",\"\",1/I188)","v":""},{"$f":"+IF(A188=\"\",\"\",CONCATENATE(Analisis!$E$21,\" es \",J188,\" veces más importante que \",Analisis!$E$22))","v":""}]
[]
[null,null,"Antes de \"limpiar\", Borrar la celda G188",null,null,null,null,null,null,"Finalizar la encuesta"]
[]
[]
[]
[]
[]
["Alternativas"]
[]
[]
[]
[]
[{"$f":"+IF(Analisis!$D$9>=6,Analisis!C23,\"\")","v":""},null,null,null,null,null,"\"6\""]
[]
["Nota:","En esta sección la evaluación sera tomando como referencia la primera alternativa con respecto a la segunda"]
["Ejemplo:","Si el riesgo de que A es 3 veces mas importante que el riesgo de B, se colocara el valor de 3; si en cambio la relación es 1/3, se marcará la casilla de inversa."]
[]
[null,"A vs B",null,null,false,null,3,null,{"$f":"+IF(E206=FALSE,G206,1/G206)","v":3}]
[]
["Relacion de criterios",null,null,null,"Inverso de la relación",null,"Calificación"]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=2,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$19),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A209=\"\",\"\",IF(E209=TRUE,G209,1/G209))","v":""},{"$f":"+IF(A209=\"\",\"\",1/I209)","v":""},{"$f":"+IF(A209=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J209,\" veces más importante que \",Analisis!$E$19))","v":""}]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=3,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$20),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A211=\"\",\"\",IF(E211=TRUE,G211,1/G211))","v":""},{"$f":"+IF(A211=\"\",\"\",1/I211)","v":""},{"$f":"+IF(A211=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J211,\" veces más importante que \",Analisis!$E$20))","v":""},null,null,null,null,null,null,"Intensidad de importancia",null,"Definición"]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=3,+CONCATENATE(Analisis!$E$19,\" \",\"vs\",\" \",Analisis!$E$20),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A213=\"\",\"\",IF(E213=TRUE,G213,1/G213))","v":""},{"$f":"+IF(A213=\"\",\"\",1/I213)","v":""},{"$f":"+IF(A213=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J213,\" veces más importante que \",Analisis!$E$20))","v":""}]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=4,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A215=\"\",\"\",IF(E215=TRUE,G215,1/G215))","v":""},{"$f":"+IF(A215=\"\",\"\",1/I215)","v":""},{"$f":"+IF(A215=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J215,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,1,null,"IGUAL"]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=4,+CONCATENATE(Analisis!$E$19,\" \",\"vs\",\" \",Analisis!$E$21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A217=\"\",\"\",IF(E217=TRUE,G217,1/G217))","v":""},{"$f":"+IF(A217=\"\",\"\",1/I217)","v":""},{"$f":"+IF(A217=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J217,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,3,null,"MODERADO"]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=4,+CONCATENATE(Analisis!$E$20,\" \",\"vs\",\" \",Analisis!$E$21),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A219=\"\",\"\",IF(E219=TRUE,G219,1/G219))","v":""},{"$f":"+IF(A219=\"\",\"\",1/I219)","v":""},{"$f":"+IF(A219=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J219,\" veces más importante que \",Analisis!$E$21))","v":""},null,null,null,null,null,null,5,null,"FUERTE"]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$18,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A221=\"\",\"\",IF(E221=TRUE,G221,1/G221))","v":""},{"$f":"+IF(A221=\"\",\"\",1/I221)","v":""},{"$f":"+IF(A221=\"\",\"\",CONCATENATE(Analisis!$E$18,\" es \",J221,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,7,null,"MUY FUERTE"]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$19,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A223=\"\",\"\",IF(E223=TRUE,G223,1/G223))","v":""},{"$f":"+IF(A223=\"\",\"\",1/I223)","v":""},{"$f":"+IF(A223=\"\",\"\",CONCATENATE(Analisis!$E$19,\" es \",J223,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,9,null,"EXTREMA"]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$20,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A225=\"\",\"\",IF(E225=TRUE,G225,1/G225))","v":""},{"$f":"+IF(A225=\"\",\"\",1/I225)","v":""},{"$f":"+IF(A225=\"\",\"\",CONCATENATE(Analisis!$E$20,\" es \",J225,\" veces más importante que \",Analisis!$E$22))","v":""},null,null,null,null,null,null,"2,4,6,8",null,"Valores de Transición"]
[]
[{"$f":"+IF(A201=\"\",\"\",IF(Analisis!$D$10>=5,+CONCATENATE(Analisis!$E$21,\" \",\"vs\",\" \",Analisis!$E$22),\"\"))","v":""},null,null,null,false,null,null,null,{"$f":"+IF(A227=\"\",\"\",IF(E227=TRUE,G227,1/G227))","v":""},{"$f":"+IF(A227=\"\",\"\",1/I227)","v":""},{"$f":"+IF(A227=\"\",\"\",CONCATENATE(Analisis!$E$21,\" es \",J227,\" veces más importante que \",Analisis!$E$22))","v":""}]
[]
[null,null,"Antes de \"limpiar\", Borrar la celda G227",null,null,null,null,null,null,"Finalizar la encuesta"]

{"sheet":"Bruto","index":4,"n_rows":81,"n_cols":39,"rows_kept":81,"cut":false,"hidden":true,"merged":[[64,12,64,14],[65,12,65,14],[66,12,66,14],[67,12,67,14],[59,12,59,14],[60,12,60,14],[61,12,61,14],[62,12,62,14],[63,12,63,14],[74,12,74,14],[75,12,75,14],[76,12,76,14],[77,12,77,14],[78,12,78,14],[80,12,80,14],[75,6,75,8],[76,6,76,8],[77,6,77,8],[78,6,78,8],[79,6,79,8],[80,6,80,8],[79,12,79,14],[68,12,68,14],[69,0,69,2],[71,6,71,8],[72,6,72,8],[73,6,73,8],[71,12,71,14],[72,12,72,14],[73,12,73,14],[74,6,74,8],[66,0,66,2],[66,6,66,8],[67,0,67,2],[67,6,67,8],[68,0,68,2],[68,6,68,8],[62,0,62,2],[62,6,62,8],[63,6,63,8],[64,6,64,8],[65,0,65,2],[65,6,65,8],[59,0,59,2],[59,6,59,8],[60,0,60,2],[60,6,60,8],[61,0,61,2],[61,6,61,8],[55,0,55,2],[55,6,55,8],[55,12,55,14],[56,0,56,2],[56,6,56,8],[56,12,56,14],[52,6,52,8],[52,12,52,14],[53,6,53,8],[53,12,53,14],[54,0,54,2],[54,6,54,8],[54,12,54,14],[50,0,50,2],[50,6,50,8],[50,12,50,14],[51,0,51,2],[51,6,51,8],[51,12,51,14],[49,6,49,8],[49,12,49,14],[13,1,17,1],[18,1,22,1],[23,1,27,1],[28,1,32,1],[33,1,37,1],[38,1,42,1],[47,0,47,2],[47,6,47,8],[47,12,47,14],[48,6,48,8],[48,12,48,14],[3,3,3,8],[3,9,3,38],[5,9,5,13],[5,14,5,18],[5,19,5,23],[5,24,5,28],[5,29,5,33],[5,34,5,38]]}
[null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,0,1E-4,0.52,0.89,1.1100000000000001,1.25,1.35,1.4,1.45,1.49]
[]
[null,null,null,"CRITERIOS",null,null,null,null,null,"ALTERNATIVAS"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+D7","v":"Formación"},null,null,null,null,{"$f":"+E7","v":"Costo de Vida"},null,null,null,null,{"$f":"+F7","v":"Ocio"},null,null,null,null,{"$f":"+G7","v":0},null,null,null,null,{"$f":"+H7","v":0},null,null,null,null,{"$f":"+I7","v":0}]
[null,null,null,{"$f":"+Analisis!C18","v":"Formación"},{"$f":"+C9","v":"Costo de Vida"},{"$f":"+C10","v":"Ocio"},{"$f":"+C11","v":0},{"$f":"+C12","v":0},{"$f":"+C13","v":0},{"$f":"+$C$14","v":"Munchen"},{"$f":"+$C$15","v":"London"},{"$f":"+$C$16","v":"Praga"},{"$f":"+$C$17","v":0},{"$f":"+$C$18","v":0},{"$f":"+$C$14","v":"Munchen"},{"$f":"+$C$15","v":"London"},{"$f":"+$C$16","v":"Praga"},{"$f":"+$C$17","v":0},{"$f":"+$C$18","v":0},{"$f":"+$C$14","v":"Munchen"},{"$f":"+$C$15","v":"London"},{"$f":"+$C$16","v":"Praga"},{"$f":"+$C$17","v":0},{"$f":"+$C$18","v":0},{"$f":"+$C$14","v":"Munchen"},{"$f":"+$C$15","v":"London"},{"$f":"+$C$16","v":"Praga"},{"$f":"+$C$17","v":0},{"$f":"+$C$18","v":0},{"$f":"+$C$14","v":"Munchen"},{"$f":"+$C$15","v":"London"},{"$f":"+$C$16","v":"Praga"},{"$f":"+$C$17","v":0},{"$f":"+$C$18","v":0},{"$f":"+$C$14","v":"Munchen"},{"$f":"+$C$15","v":"London"},{"$f":"+$C$16","v":"Praga"},{"$f":"+$C$17","v":0},{"$f":"+$C$18","v":0}]
[null,null,{"$f":"+D7","v":"Formación"},1,{"$f":"1/D9","v":5},{"$f":"+IF(D10=0,0,1/D10)","v":7},{"$f":"+IF(D11=0,0,1/D11)","v":0},{"$f":"+IF(D12=0,0,1/D12)","v":0},{"$f":"+IF(OR(D13=0,D13=\"\"),0,1/D13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!C19","v":"Costo de Vida"},{"$f":"+IF(Analisis!D9>=2,D48,0)","v":0.2},1,{"$f":"+IF(E10=0,0,1/E10)","v":3},{"$f":"+IF(E11=0,0,1/E11)","v":0},{"$f":"+IF(E12=0,0,1/E12)","v":0},{"$f":"+IF(OR(E13=0,E13=\"\"),0,1/E13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!C20","v":"Ocio"},{"$f":"+IF(Analisis!D9>=3,D51,0)","v":0.14285714285714285},{"$f":"+IF(Analisis!D9>=3,D52,0)","v":0.33333333333333331},1,{"$f":"+IF(F11=0,0,1/F11)","v":0},{"$f":"+IF(F12=0,0,1/F12)","v":0},{"$f":"+IF(OR(F13=0,F13=\"\"),0,1/F13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!C21","v":0},{"$f":"+IF(Analisis!D9>=4,D55,0)","v":0},{"$f":"+IF(Analisis!D9>=4,D56,0)","v":0},{"$f":"+IF(Analisis!D9>=4,D57,0)","v":0},1,{"$f":"+IF(G12=0,0,1/G12)","v":0},{"$f":"+IF(OR(G13=0,G13=\"\"),0,1/G13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!C22","v":0},{"$f":"+IF(Analisis!D9>=5,D60,0)","v":0},{"$f":"+IF(Analisis!$D$9>=5,D61,0)","v":0},{"$f":"+IF(Analisis!$D$9>=5,D62,0)","v":0},{"$f":"+IF(Analisis!$D$9>=5,D63,0)","v":0},1,{"$f":"+IF(OR(H13=0,H13=\"\"),0,1/H13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!C23","v":0},{"$f":"+IF(Analisis!D9>=5,D66,0)","v":0},{"$f":"+IF(Analisis!$D$9>=5,D67,0)","v":0},{"$f":"+IF(Analisis!$D$9>=5,D68,0)","v":0},{"$f":"+IF(Analisis!$D$9>=5,D69,0)","v":0},{"$f":"+IF(Analisis!$D$9>=5,D70,0)","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+C8","v":"Formación"},{"$f":"+Analisis!$E$18","v":"Munchen"},0,0,0,0,0,0,1,{"$f":"1/J15","v":0.33333333333333331},{"$f":"+IF(J16=0,0,1/J16)","v":0.14285714285714285},{"$f":"+IF(J17=0,0,1/J17)","v":0},{"$f":"+IF(J18=0,0,1/J18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$19","v":"London"},0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=2,J48,0)","v":3},1,{"$f":"+IF(K16=0,0,1/K16)","v":0.25},{"$f":"+IF(K17=0,0,1/K17)","v":0},{"$f":"+IF(K18=0,0,1/K18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$20","v":"Praga"},0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=3,J49,0)","v":7},{"$f":"+IF(Analisis!$D$10>=3,J50,0)","v":4},1,{"$f":"+IF(L17=0,0,1/L17)","v":0},{"$f":"+IF(L18=0,0,1/L18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$21","v":0},0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=4,J51,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,J52,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,J53,0)","v":0},1,{"$f":"+IF(M18=0,0,1/M18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$22","v":0},0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=5,J54,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J55,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J56,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J57,0)","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+C9","v":"Costo de Vida"},{"$f":"+Analisis!$E$18","v":"Munchen"},0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"1/O20","v":0.33333333333333331},{"$f":"+IF(O21=0,0,1/O21)","v":4},{"$f":"+IF(O22=0,0,1/O22)","v":0},{"$f":"+IF(O23=0,0,1/O23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$19","v":"London"},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=2,J60,0)","v":3},1,{"$f":"+IF(P21=0,0,1/P21)","v":9},{"$f":"+IF(P22=0,0,1/P22)","v":0},{"$f":"+IF(P23=0,0,1/P23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$20","v":"Praga"},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=3,J61,0)","v":0.25},{"$f":"+IF(Analisis!$D$10>=3,J62,0)","v":0.1111111111111111},1,{"$f":"+IF(Q22=0,0,1/Q22)","v":0},{"$f":"+IF(Q23=0,0,1/Q23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$21","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=4,J63,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,J64,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,J65,0)","v":0},1,{"$f":"+IF(R23=0,0,1/R23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$22","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=5,J66,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J67,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J68,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J69,0)","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+C10","v":"Ocio"},{"$f":"+Analisis!$E$18","v":"Munchen"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"1/T25","v":7},{"$f":"+IF(T26=0,0,1/T26)","v":3},{"$f":"+IF(T27=0,0,1/T27)","v":0},{"$f":"+IF(T28=0,0,1/T28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$19","v":"London"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=2,J72,0)","v":0.14285714285714285},1,{"$f":"+IF(U26=0,0,1/U26)","v":0.25},{"$f":"+IF(U27=0,0,1/U27)","v":0},{"$f":"+IF(U28=0,0,1/U28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$20","v":"Praga"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=3,J73,0)","v":0.33333333333333331},{"$f":"+IF(Analisis!$D$10>=3,J74,0)","v":4},1,{"$f":"+IF(V27=0,0,1/V27)","v":0},{"$f":"+IF(V28=0,0,1/V28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=4,J75,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,J76,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,J77,0)","v":0},1,{"$f":"+IF(W28=0,0,1/W28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=5,J78,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J79,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J80,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,J81,0)","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+C11","v":0},{"$f":"+Analisis!$E$18","v":"Munchen"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"1/Y30","v":{"$error":"#DIV/0!"}},{"$f":"+IF(Y31=0,0,1/Y31)","v":0},{"$f":"+IF(Y32=0,0,1/Y32)","v":0},{"$f":"+IF(Y33=0,0,1/Y33)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$19","v":"London"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=2,P48,0)","v":0},1,{"$f":"+IF(Z31=0,0,1/Z31)","v":0},{"$f":"+IF(Z32=0,0,1/Z32)","v":0},{"$f":"+IF(Z33=0,0,1/Z33)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$20","v":"Praga"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=3,P49,0)","v":0},{"$f":"+IF(Analisis!$D$10>=3,P50,0)","v":0},1,{"$f":"+IF(AA32=0,0,1/AA32)","v":0},{"$f":"+IF(AA33=0,0,1/AA33)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=4,P51,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,P52,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,P53,0)","v":0},1,{"$f":"+IF(AB33=0,0,1/AB33)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=5,P54,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P55,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P56,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P57,0)","v":0},1,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+C12","v":0},{"$f":"+Analisis!$E$18","v":"Munchen"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"1/AD35","v":{"$error":"#DIV/0!"}},{"$f":"+IF(AD36=0,0,1/AD36)","v":0},{"$f":"+IF(AD37=0,0,1/AD37)","v":0},{"$f":"+IF(AD38=0,0,1/AD38)","v":0},0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$19","v":"London"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=2,P60,0)","v":0},1,{"$f":"+IF(AE36=0,0,1/AE36)","v":0},{"$f":"+IF(AE37=0,0,1/AE37)","v":0},{"$f":"+IF(AE38=0,0,1/AE38)","v":0},0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$20","v":"Praga"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=3,P61,0)","v":0},{"$f":"+IF(Analisis!$D$10>=3,P62,0)","v":0},1,{"$f":"+IF(AF37=0,0,1/AF37)","v":0},{"$f":"+IF(AF38=0,0,1/AF38)","v":0},0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=4,P63,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,P64,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,P65,0)","v":0},1,{"$f":"+IF(AG38=0,0,1/AG38)","v":0},0,0,0,0,0]
[null,null,{"$f":"+Analisis!$E$22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=5,P66,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P67,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P68,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P69,0)","v":0},1,0,0,0,0,0]
[null,{"$f":"+C13","v":0},{"$f":"+Analisis!$E$18","v":"Munchen"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"1/AI40","v":{"$error":"#DIV/0!"}},{"$f":"+IF(AI41=0,0,1/AI41)","v":0},{"$f":"+IF(AI42=0,0,1/AI42)","v":0},{"$f":"+IF(AI43=0,0,1/AI43)","v":0}]
[null,null,{"$f":"+Analisis!$E$19","v":"London"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=2,P72,0)","v":0},1,{"$f":"+IF(AJ41=0,0,1/AJ41)","v":0},{"$f":"+IF(AJ42=0,0,1/AJ42)","v":0},{"$f":"+IF(AJ43=0,0,1/AJ43)","v":0}]
[null,null,{"$f":"+Analisis!$E$20","v":"Praga"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=3,P73,0)","v":0},{"$f":"+IF(Analisis!$D$10>=3,P74,0)","v":0},1,{"$f":"+IF(AK42=0,0,1/AK42)","v":0},{"$f":"+IF(AK43=0,0,1/AK43)","v":0}]
[null,null,{"$f":"+Analisis!$E$21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=4,P75,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,P76,0)","v":0},{"$f":"+IF(Analisis!$D$10>=4,P77,0)","v":0},1,{"$f":"+IF(AL43=0,0,1/AL43)","v":0}]
[null,null,{"$f":"+Analisis!$E$22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(Analisis!$D$10>=5,P78,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P79,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P80,0)","v":0},{"$f":"+IF(Analisis!$D$10>=5,P81,0)","v":0},1]
[]
[]
[null,null,null,null,null,null,""]
[2,null,null,null,null,null,"Para",{"$f":"+C8","v":"Formación"},null,null,null,null,"Para",{"$f":"+C11","v":0}]
["# de categorias de primer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A12=\"\",0,'Enc. de Criterios'!I12)","v":0.2},null,null,{"$f":"+'Enc. de Alternativas'!$A$14","v":"Munchen vs London"},null,null,{"$f":"+IF('Enc. de Alternativas'!A14=\"\",0,'Enc. de Alternativas'!J14)","v":3},null,null,{"$f":"+'Enc. de Alternativas'!$A$14","v":"Munchen vs London"},null,null,{"$f":"+IF('Enc. de Alternativas'!A129=\"\",0,'Enc. de Alternativas'!J129)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$16","v":"Munchen vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A16=\"\",0,'Enc. de Alternativas'!J16)","v":7},null,null,{"$f":"+'Enc. de Alternativas'!$A$16","v":"Munchen vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A131=\"\",0,'Enc. de Alternativas'!J131)","v":0}]
[3,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$18","v":"London vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A18=\"\",0,'Enc. de Alternativas'!J18)","v":4},null,null,{"$f":"+'Enc. de Alternativas'!$A$18","v":"London vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A133=\"\",0,'Enc. de Alternativas'!J133)","v":0}]
["# de categorias de primer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A14=\"\",0,'Enc. de Criterios'!I14)","v":0.14285714285714285},null,null,{"$f":"+'Enc. de Alternativas'!$A$20","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A20=\"\",0,'Enc. de Alternativas'!J20)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$20","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A135=\"\",0,'Enc. de Alternativas'!J135)","v":0}]
["# de categorias de segundo nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A16=\"\",0,'Enc. de Criterios'!I16)","v":0.33333333333333331},null,null,{"$f":"+'Enc. de Alternativas'!$A$22","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A22=\"\",0,'Enc. de Alternativas'!J22)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$22","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A137=\"\",0,'Enc. de Alternativas'!J137)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$24","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A24=\"\",0,'Enc. de Alternativas'!J24)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$24","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A139=\"\",0,'Enc. de Alternativas'!J139)","v":0}]
[4,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$26","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A26=\"\",0,'Enc. de Alternativas'!J26)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$26","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A141=\"\",0,'Enc. de Alternativas'!J141)","v":0}]
["# de categorias de primer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A18=\"\",0,'Enc. de Criterios'!I18)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$28","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A28=\"\",0,'Enc. de Alternativas'!J28)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$28","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A143=\"\",0,'Enc. de Alternativas'!J143)","v":0}]
["# de categorias de segundo nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A20=\"\",0,'Enc. de Criterios'!I20)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$30","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A30=\"\",0,'Enc. de Alternativas'!J30)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$30","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A145=\"\",0,'Enc. de Alternativas'!J145)","v":0}]
["# de categorias de tercer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A22=\"\",0,'Enc. de Criterios'!I22)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$32","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A32=\"\",0,'Enc. de Alternativas'!J32)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$32","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A147=\"\",0,'Enc. de Alternativas'!J147)","v":0}]
[]
[5,null,null,null,null,null,"Para",{"$f":"+C9","v":"Costo de Vida"},null,null,null,null,"Para",{"$f":"+C12","v":0}]
["# de categorias de primer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A24=\"\",0,'Enc. de Criterios'!I24)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$14","v":"Munchen vs London"},null,null,{"$f":"+IF('Enc. de Alternativas'!A52=\"\",0,'Enc. de Alternativas'!J52)","v":3},null,null,{"$f":"+'Enc. de Alternativas'!$A$14","v":"Munchen vs London"},null,null,{"$f":"+IF('Enc. de Alternativas'!A170=\"\",0,'Enc. de Alternativas'!J170)","v":0}]
["# de categorias de segundo nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A26=\"\",0,'Enc. de Criterios'!I26)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$16","v":"Munchen vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A54=\"\",0,'Enc. de Alternativas'!J54)","v":0.25},null,null,{"$f":"+'Enc. de Alternativas'!$A$16","v":"Munchen vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A172=\"\",0,'Enc. de Alternativas'!J172)","v":0}]
["# de categorias de tercer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A28=\"\",0,'Enc. de Criterios'!I28)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$18","v":"London vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A56=\"\",0,'Enc. de Alternativas'!J56)","v":0.1111111111111111},null,null,{"$f":"+'Enc. de Alternativas'!$A$18","v":"London vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A174=\"\",0,'Enc. de Alternativas'!J174)","v":0}]
["# de categorias de cuarto nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A30=\"\",0,'Enc. de Criterios'!I30)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$20","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A58=\"\",0,'Enc. de Alternativas'!J58)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$20","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A176=\"\",0,'Enc. de Alternativas'!J176)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$22","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A60=\"\",0,'Enc. de Alternativas'!J60)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$22","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A178=\"\",0,'Enc. de Alternativas'!J178)","v":0}]
[6,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$24","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A62=\"\",0,'Enc. de Alternativas'!J62)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$24","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A180=\"\",0,'Enc. de Alternativas'!J180)","v":0}]
["# de categorias de primer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A32=\"\",0,'Enc. de Criterios'!I32)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$26","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A64=\"\",0,'Enc. de Alternativas'!J64)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$26","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A182=\"\",0,'Enc. de Alternativas'!J182)","v":0}]
["# de categorias de segundo nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A34=\"\",0,'Enc. de Criterios'!I34)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$28","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A66=\"\",0,'Enc. de Alternativas'!J66)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$28","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A184=\"\",0,'Enc. de Alternativas'!J184)","v":0}]
["# de categorias de tercer nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A36=\"\",0,'Enc. de Criterios'!I36)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$30","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A68=\"\",0,'Enc. de Alternativas'!J68)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$30","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A186=\"\",0,'Enc. de Alternativas'!J186)","v":0}]
["# de categorias de cuarto nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A38=\"\",0,'Enc. de Criterios'!I38)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$32","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A70=\"\",0,'Enc. de Alternativas'!J70)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$32","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A188=\"\",0,'Enc. de Alternativas'!J188)","v":0}]
["# de categorias de quinto nivel",null,null,{"$f":"+IF('Enc. de Criterios'!A40=\"\",0,'Enc. de Criterios'!I40)","v":0}]
[null,null,null,null,null,null,"Para",{"$f":"+C10","v":"Ocio"},null,null,null,null,"Para",{"$f":"+C13","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$14","v":"Munchen vs London"},null,null,{"$f":"+IF('Enc. de Alternativas'!A91=\"\",0,'Enc. de Alternativas'!J91)","v":0.14285714285714285},null,null,{"$f":"+'Enc. de Alternativas'!$A$14","v":"Munchen vs London"},null,null,{"$f":"+IF('Enc. de Alternativas'!A209=\"\",0,'Enc. de Alternativas'!J209)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$16","v":"Munchen vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A93=\"\",0,'Enc. de Alternativas'!J93)","v":0.33333333333333331},null,null,{"$f":"+'Enc. de Alternativas'!$A$16","v":"Munchen vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A211=\"\",0,'Enc. de Alternativas'!J211)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$18","v":"London vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A95=\"\",0,'Enc. de Alternativas'!J95)","v":4},null,null,{"$f":"+'Enc. de Alternativas'!$A$18","v":"London vs Praga"},null,null,{"$f":"+IF('Enc. de Alternativas'!A213=\"\",0,'Enc. de Alternativas'!J213)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$20","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A97=\"\",0,'Enc. de Alternativas'!J97)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$20","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A215=\"\",0,'Enc. de Alternativas'!J215)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$22","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A99=\"\",0,'Enc. de Alternativas'!J99)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$22","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A217=\"\",0,'Enc. de Alternativas'!J217)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$24","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A101=\"\",0,'Enc. de Alternativas'!J101)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$24","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A219=\"\",0,'Enc. de Alternativas'!J219)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$26","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A103=\"\",0,'Enc. de Alternativas'!J103)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$26","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A221=\"\",0,'Enc. de Alternativas'!J221)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$28","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A105=\"\",0,'Enc. de Alternativas'!J105)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$28","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A223=\"\",0,'Enc. de Alternativas'!J223)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$30","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A107=\"\",0,'Enc. de Alternativas'!J107)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$30","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A225=\"\",0,'Enc. de Alternativas'!J225)","v":0}]
[null,null,null,null,null,null,{"$f":"+'Enc. de Alternativas'!$A$32","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A109=\"\",0,'Enc. de Alternativas'!J109)","v":0},null,null,{"$f":"+'Enc. de Alternativas'!$A$32","v":""},null,null,{"$f":"+IF('Enc. de Alternativas'!A227=\"\",0,'Enc. de Alternativas'!J227)","v":0}]

{"sheet":"Calculo de los criterios","index":5,"n_rows":225,"n_cols":33,"rows_kept":225,"cut":false,"hidden":false,"merged":[[1,1,1,4],[38,1,38,4]]}
[]
[null,"Criterios"]
[]
[null,"Metodo Aproximado"]
[]
[null,null,"Matriz resultante",null,"Categorias"]
[null,null,{"$f":"+COUNTIF(C9:C14,\">0\")","v":3}]
[null,null,{"$f":"+B9","v":"Formación"},{"$f":"+B10","v":"Costo de Vida"},{"$f":"+B11","v":"Ocio"},{"$f":"+B12","v":0},{"$f":"+B13","v":0},{"$f":"+B14","v":0},null,null,{"$f":"+C8","v":"Formación"},"Costo de Vida","Ocio",0,0,0,null,null,null,null,"λ","n","IC","CR"]
[null,{"$f":"+Analisis!C18","v":"Formación"},{"$f":"+Bruto!D8","v":1},{"$f":"+Bruto!E8","v":5},{"$f":"+Bruto!F8","v":7},{"$f":"+Bruto!G8","v":0},{"$f":"+Bruto!H8","v":0},{"$f":"+Bruto!I8","v":0},null,{"$f":"+B9","v":"Formación"},{"$f":"+C9/C$16","v":0.74468085106382986},0.78947368421052633,0.63636363636363635,0,0,0,null,{"$f":"+SUM(K9:P9)-K17","v":2.1705181716379927},{"$f":"IF(R9=0,\"\",R9/(6-Q17))","v":0.72350605721266426},null,{"$f":"+SUMPRODUCT(C16:H16,K15:P15)","v":3.1114637011613495},{"$f":"+COUNTIF(C9:H9,\">0\")","v":3},{"$f":"+(U9-V9)/(V9-1)","v":5.5731850580674758E-2},{"$f":"+W9/+HLOOKUP(V9,Bruto!D1:M2,2,FALSE)","v":0.10717663573206684},null,{"$f":"+IF(AD29=\"\",\"\",IF(X10>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es inconsistente, se debe volver a evaluar"}]
[null,{"$f":"+Analisis!C19","v":"Costo de Vida"},{"$f":"+Bruto!D9","v":0.2},{"$f":"+Bruto!E9","v":1},{"$f":"+Bruto!F9","v":3},{"$f":"+Bruto!G9","v":0},{"$f":"+Bruto!H9","v":0},{"$f":"+Bruto!I9","v":0},null,"Costo de Vida",0.14893617021276598,0.15789473684210528,0.27272727272727271,0,0,0,null,{"$f":"+SUM(K10:P10)-L17","v":0.57955817978214397},{"$f":"IF(R10=0,\"\",R10/(6-Q17))","v":0.19318605992738133},null,null,null,null,{"$f":"+IF(X9<0,0,X9)","v":0.10717663573206684}]
[null,{"$f":"+Analisis!C20","v":"Ocio"},{"$f":"+Bruto!D10","v":0.14285714285714285},{"$f":"+Bruto!E10","v":0.33333333333333331},{"$f":"+Bruto!F10","v":1},{"$f":"+Bruto!G10","v":0},{"$f":"+Bruto!H10","v":0},{"$f":"+Bruto!I10","v":0},null,"Ocio",0.10638297872340426,5.2631578947368418E-2,9.0909090909090912E-2,0,0,0,null,{"$f":"+SUM(K11:P11)-M17","v":0.24992364857986357},{"$f":"IF(R11=0,\"\",R11/(6-Q17))","v":8.3307882859954524E-2}]
[null,{"$f":"+Analisis!C21","v":0},{"$f":"+Bruto!D11","v":0},{"$f":"+Bruto!E11","v":0},{"$f":"+Bruto!F11","v":0},{"$f":"+Bruto!G11","v":1},{"$f":"+Bruto!H11","v":0},{"$f":"+Bruto!I11","v":0},null,0,0,0,0,1,0,0,null,{"$f":"+SUM(K12:P12)-N17","v":0},{"$f":"IF(R12=0,\"\",R12/(6-Q17))","v":""},null,1,0,0,0,0,0,null,{"$f":"+(C9:H14-Z22*U12:Z17)","v":-2.0648875576076193},5,7,0,0,0]
[null,{"$f":"+Analisis!C22","v":0},{"$f":"+Bruto!D12","v":0},{"$f":"+Bruto!E12","v":0},{"$f":"+Bruto!F12","v":0},{"$f":"+Bruto!G12","v":0},{"$f":"+Bruto!H12","v":1},{"$f":"+Bruto!I12","v":0},null,0,0,0,0,0,1,0,null,{"$f":"+SUM(K13:P13)-O17","v":0},{"$f":"IF(R13=0,\"\",R13/(6-Q17))","v":""},null,0,1,0,0,0,0,null,0.2,-2.0648875576076193,3,0,0,0]
[null,{"$f":"+Analisis!C23","v":0},{"$f":"+Bruto!D13","v":0},{"$f":"+Bruto!E13","v":0},{"$f":"+Bruto!F13","v":0},{"$f":"+Bruto!G13","v":0},{"$f":"+Bruto!H13","v":0},{"$f":"+Bruto!I13","v":1},null,0,0,0,0,0,0,1,null,{"$f":"+SUM(K14:P14)-P17","v":0},{"$f":"IF(R14=0,\"\",R14/(6-Q17))","v":""},null,0,0,1,0,0,0,null,0.14285714285714285,0.33333333333333331,-2.0648875576076193,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+S9","v":0.72350605721266426},{"$f":"+S10","v":0.19318605992738133},{"$f":"+S11","v":8.3307882859954524E-2},{"$f":"+S12","v":""},{"$f":"+S13","v":""},{"$f":"+S14","v":""},null,null,null,null,0,0,0,1,0,0,null,0,0,0,-2.0648875576076193,0,0]
[null,null,{"$f":"+SUMIF(C9:C14,\">0\",C9:C14)","v":1.3428571428571427},6.333333333333333,11,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,1,0,null,0,0,0,0,-2.0648875576076193,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(K9=1,1,0)","v":0},{"$f":"+IF(L10=1,1,0)","v":0},{"$f":"+IF(M11=1,1,0)","v":0},{"$f":"+IF(N12=1,1,0)","v":1},{"$f":"+IF(O13=1,1,0)","v":1},{"$f":"+IF(P14=1,1,0)","v":1},{"$f":"SUM(K17:P17)","v":3},null,null,null,0,0,0,0,0,1,null,0,0,0,0,0,-2.0648875576076193]
[]
[null,"Metodo Exacto"]
[]
[null,null,{"$f":"+MMULT(C9:H14,C9:H14)","v":3},12.333333333333332,29,0,0,0,null,{"$f":"+IF(C21=0,\"\",SUM(C21:H21))","v":44.333333333333329},{"$f":"+IF(J21=\"\",\"\",J21/$J$27)","v":0.73527088927499606},null,null,{"$f":"+MMULT(C21:H26,C21:H26)","v":29.438095238095233},114.04761904761904,265.26666666666665,0,0,0,null,{"$f":"+IF(N21=0,\"\",SUM(N21:S21))","v":408.75238095238092},{"$f":"+IF(U21=\"\",\"\",U21/$U$27)","v":0.73053273589473711}]
[null,null,0.82857142857142851,3,7.4,0,0,0,null,11.228571428571428,0.18622650450165851,null,null,7.5790476190476195,29.438095238095233,68.428571428571431,0,0,0,null,105.44571428571427,0.1884552842628987,null,null,"λ",3.0648875576076193,null,null,2,"deter",{"$f":"+MDETERM(AB12:AC13)","v":3.2637606255627594}]
[null,null,0.35238095238095235,1.3809523809523807,3,0,0,0,null,4.7333333333333325,7.8502606223345442E-2,null,null,3.2585034013605436,12.63174603174603,29.438095238095237,0,0,0,null,45.328344671201812,8.1011979842364273E-2,null,null,"deter",{"$f":"IF(C9=\"\",\"\",VLOOKUP(V9,AC22:AE26,3,FALSE))","v":2.1800484614637716E-7},null,null,3,"deter",{"$f":"+MDETERM(AB12:AD14)","v":2.1800484614637716E-7}]
[null,null,0,0,0,1,0,0,null,"","",null,null,0,0,0,1,0,0,null,"","",null,null,null,null,null,null,4,"deter",{"$f":"+MDETERM(AB12:AE15)","v":-4.5015549430581755E-7}]
[null,null,0,0,0,0,1,0,null,"","",null,null,0,0,0,0,1,0,null,"","",null,null,null,null,null,null,5,"deter",{"$f":"+MDETERM(AB12:AF16)","v":9.295204791807902E-7}]
[null,null,0,0,0,0,0,1,null,"","",null,null,0,0,0,0,0,1,null,"","",null,null,null,null,null,null,6,"deter",{"$f":"+MDETERM(AB12:AG17)","v":-1.9193552720018857E-6}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J21:J26)","v":60.295238095238091},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U21:U26)","v":559.52643990929698}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"λ","n","IC","CR"]
[null,null,{"$f":"+MMULT(N21:S26,N21:S26)","v":2595.3461224489793},10065.47050642479,23422.006439909292,0,0,0,null,{"$f":"+IF(C29=0,\"\",SUM(C29:H29))","v":36082.823068783066},{"$f":"+IF(J29=\"\",\"\",J29/$J$35)","v":0.7306446130228953},{"$f":"+K29-V21","v":1.1187712815818873E-4},null,{"$f":"+MMULT(C29:H34,C29:H34)","v":20207450.925150864},78370111.397574589,182364645.0970116,0,0,0,null,{"$f":"+IF(N29=0,\"\",SUM(N29:S29))","v":280942207.41973704},{"$f":"+IF(U29=\"\",\"\",U29/$U$35)","v":0.73064467136111755},{"$f":"+V29-K29","v":5.8338222252984906E-8},null,{"$f":"+Z22","v":3.0648875576076193},{"$f":"+COUNTIF(AB12:AB17,\"<>0\")","v":3},{"$f":"+(Y29-Z29)/(Z29-1)","v":3.2443778803809664E-2},{"$f":"+AA29/+HLOOKUP(Z29,Bruto!D1:M2,2,FALSE)","v":6.2391882315018583E-2},null,{"$f":"+IF(AB29<0,\"\",IF(AB30>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es consistente"}]
[null,null,669.20018399740843,2595.3461224489793,6039.282303854874,0,0,0,null,9303.8286103012615,0.18839413539363536,{"$f":"+K30-V22","v":-6.1148869263338845E-5},null,5210418.4313431885,20207450.925150864,47022066.838544756,0,0,0,null,72439936.19503881,0.18839409663913004,{"$f":"+V30-K30","v":-3.8754505327087685E-8},null,null,null,null,{"$f":"+IF(AB29<0,0,AB29)","v":6.2391882315018583E-2}]
[null,null,287.58487161213685,1115.3336399956804,2595.3461224489793,0,0,0,null,3998.2646340567962,8.0961251583469312E-2,null,null,2239146.0399307022,8684030.7189053129,20207450.925150864,0,0,0,null,31130627.68398688,8.0961231999752442E-2]
[null,null,0,0,0,1,0,0,null,"","",null,null,0,0,0,1,0,0,null,"",""]
[null,null,0,0,0,0,1,0,null,"","",null,null,0,0,0,0,1,0,null,"",""]
[null,null,0,0,0,0,0,1,null,"","",null,null,0,0,0,0,0,1,null,"",""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J29:J34)","v":49384.916313141126},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U29:U34)","v":384512771.29876274}]
[]
[]
[]
[null,"Alternativas"]
[]
[null,"Para",{"$f":"+C8","v":"Formación"}]
[]
[null,"Metodo Aproximado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R46:R50)","v":1}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,{"$f":"+C45","v":"Munchen"},{"$f":"+D45","v":"London"},{"$f":"+E45","v":"Praga"},0,{"$f":"+G45","v":0}]
[null,{"$f":"+C45","v":"Munchen"},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!J14,\"\")","v":1},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!K14,\"\")","v":0.33333333333333331},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!L14,\"\")","v":0.14285714285714285},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!M14,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!N14,\"\")","v":0},null,null,{"$f":"+B46","v":"Munchen"},{"$f":"+IF(C46=\"\",\"\",C46/C$52)","v":9.0909090909090912E-2},{"$f":"+IF(D46=\"\",\"\",D46/D$52)","v":6.25E-2},0.10256410256410256,0,0,null,{"$f":"SUM(K46:O46)-K52","v":0.25597319347319347},{"$f":"IF(Q46=0,\"\",Q46/(5-$P$52))","v":8.5324397824397824E-2},null,"λ","n","IC","CR"]
[null,{"$f":"+D45","v":"London"},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!J15,\"\")","v":3},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!K15,\"\")","v":1},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!L15,\"\")","v":0.25},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!M15,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!N15,\"\")","v":0},null,null,{"$f":"+B47","v":"London"},{"$f":"+IF(C47=\"\",\"\",C47/C$52)","v":0.27272727272727271},0.1875,0.17948717948717949,0,0,null,{"$f":"SUM(K47:O47)-L52","v":0.63971445221445222},{"$f":"IF(Q47=0,\"\",Q47/(5-$P$52))","v":0.21323815073815075},null,{"$f":"+SUMPRODUCT(C52:G52,K53:O53)","v":3.0528406778406776},{"$f":"+COUNTIF(C46:G46,\">0\")","v":3},{"$f":"+(T47-U47)/(U47-1)","v":2.6420338920338793E-2},{"$f":"+IF(V47=0,0,+V47/HLOOKUP(U47,Bruto!D1:M2,2,FALSE))","v":5.0808344077574598E-2},null,{"$f":"+IF(AA63=\"\",\"\",IF(W48>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es consistente"}]
[null,{"$f":"+E45","v":"Praga"},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!J16,\"\")","v":7},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!K16,\"\")","v":4},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!L16,\"\")","v":1},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!M16,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!N16,\"\")","v":0},null,null,{"$f":"+B48","v":"Praga"},0.63636363636363635,0.75,0.71794871794871795,0,0,null,{"$f":"SUM(K48:O48)-M52","v":2.1043123543123543},0.7014374514374514,null,null,null,null,{"$f":"+IF(W47<0,0,W47)","v":5.0808344077574598E-2}]
[null,{"$f":"+F45","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!J17,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!K17,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!L17,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!M17,\"\")","v":1},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!N17,\"\")","v":0},null,null,0,0,0,0,1,0,null,{"$f":"SUM(K49:O49)-N52","v":0},"",null,1,0,0,0,0,null,{"$f":"+IF(C46=\"\",\"\",C46:G50-W56*T49:X53)","v":-2.0323665530212649},0.33333333333333331,0.14285714285714285,0,0]
[null,{"$f":"+G45","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!J18,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!K18,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!L18,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!M18,\"\")","v":0},{"$f":"+IF(Analisis!$C$18<>\"\",Bruto!N18,\"\")","v":1},null,null,0,0,0,0,0,1,null,{"$f":"SUM(K50:O50)-O52","v":0},"",null,0,1,0,0,0,null,3,-2.0323665530212649,0.25,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,null,7,4,-2.0323665530212649,0,0]
[null,null,{"$f":"SUM(C46:C50)","v":11},{"$f":"SUM(D46:D50)","v":5.333333333333333},1.3928571428571428,1,1,null,null,null,{"$f":"+IF(K46=1,1,0)","v":0},{"$f":"+IF(L47=1,1,0)","v":0},{"$f":"+IF(M48=1,1,0)","v":0},{"$f":"+IF(N49=1,1,0)","v":1},{"$f":"+IF(O50=1,1,0)","v":1},{"$f":"SUM(K52:O52)","v":2},null,null,null,0,0,0,1,0,null,0,0,0,-2.0323665530212649,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+R46","v":8.5324397824397824E-2},{"$f":"+R47","v":0.21323815073815075},{"$f":"+R48","v":0.7014374514374514},{"$f":"+R49","v":""},{"$f":"+R50","v":""},null,null,null,null,0,0,0,0,1,null,0,0,0,0,-2.0323665530212649]
[null,"Metodo Exacto"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J57:J61)","v":1}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,"λ",3.0323665530212649,null,null,2,"deter",{"$f":"IF($C$57=\"\",\"\",MDETERM(Z49:AA50))","v":3.1305138058395388}]
[null,{"$f":"+C56","v":"Munchen"},{"$f":"+IF(C46=\"\",\"\",MMULT(C46:G50,C46:G50))","v":3},1.2380952380952381,0.36904761904761901,0,0,null,{"$f":"+IF(OR(C57=\"\",C57=0),\"\",SUM(C57:G57))","v":4.6071428571428568},{"$f":"+IF(I57=\"\",\"\",I57/$I$62)","v":8.2833904109589046E-2},null,{"$f":"+M56","v":"Munchen"},{"$f":"+IF(C57=\"\",\"\",MMULT(C57:G61,C57:G61))","v":28.19047619047619},11.242063492063492,3.3639455782312924,0,0,null,{"$f":"+IF(OR(M57=\"\",M57=0),\"\",SUM(M57:Q57))","v":42.796485260770979},{"$f":"+IF(S57=\"\",\"\",S57/$S$62)","v":8.4157967446797904E-2},null,"deter",{"$f":"IF(C46=\"\",\"\",VLOOKUP(U47,Z56:AB59,3,FALSE))","v":6.0090199312959219E-7},null,null,3,"deter",{"$f":"IF($C$57=\"\",\"\",MDETERM(Z49:AB51))","v":6.0090199312959219E-7}]
[null,{"$f":"+D56","v":"London"},7.75,3,0.9285714285714286,0,0,null,11.678571428571429,{"$f":"+IF(I58=\"\",\"\",I58/$I$62)","v":0.20997431506849318},null,{"$f":"+N56","v":"London"},70.642857142857139,28.19047619047619,8.4315476190476186,0,0,null,107.26488095238095,{"$f":"+IF(S58=\"\",\"\",S58/$S$62)","v":0.21093307790043744},null,null,null,null,null,4,"deter",{"$f":"IF($C$57=\"\",\"\",MDETERM(Z49:AC52))","v":-1.2212531124803971E-6}]
[null,{"$f":"+E56","v":"Praga"},26,10.333333333333332,3,0,0,null,{"$f":"+IF(OR(C59=\"\",C59=0),\"\",SUM(C59:G59))","v":39.333333333333329},0.7071917808219178,null,{"$f":"+O56","v":"Praga"},236.08333333333331,94.19047619047619,28.19047619047619,0,0,null,358.46428571428572,0.7049089546527646,null,null,null,null,null,5,"deter",{"$f":"IF($C$57=\"\",\"\",MDETERM(Z49:AD53))","v":2.4820339785782757E-6}]
[null,{"$f":"+F56","v":0},0,0,0,1,0,null,{"$f":"+IF(OR(C60=\"\",C60=0),\"\",SUM(C60:G60))","v":""},"",null,{"$f":"+P56","v":0},0,0,0,1,0,null,"",""]
[null,{"$f":"+G56","v":0},0,0,0,0,1,null,"","",null,{"$f":"+Q56","v":0},0,0,0,0,1,null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I57:I61)","v":55.619047619047613},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S57:S61)","v":508.52565192743765},null,null,"λ","n","IC","CR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W56","v":3.0323665530212649},{"$f":"+COUNTIF(Z49:Z53,\"<>0\")","v":3},{"$f":"+(V63-W63)/(W63-1)","v":1.6183276510632449E-2},{"$f":"+X63/+HLOOKUP(W63,Bruto!D1:M2,2,FALSE)","v":3.1121685597370094E-2},null,{"$f":"+IF(Y63<0,\"\",IF(Y64>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es consistente"}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,null,null,{"$f":"+IF(Y63<0,0,Y63)","v":3.1121685597370094E-2}]
[null,{"$f":"+C64","v":"Munchen"},{"$f":"+IF(M57=\"\",\"\",MMULT(M57:Q61,M57:Q61))","v":2383.0459183673465},950.68988230212722,284.45044912806395,0,0,null,{"$f":"+IF(OR(C65=\"\",C65=0),\"\",SUM(C65:G65))","v":3618.186249797538},{"$f":"+IF(I65=\"\",\"\",I65/$I$70)","v":8.4144149949967259E-2},null,{"$f":"+M64","v":"Munchen"},{"$f":"+IF(C65=\"\",\"\",MMULT(C65:G69,C65:G69))","v":17036722.737145815},6796612.9115628395,2033575.402778507,0,0,null,{"$f":"+IF(OR(M65=\"\",M65=0),\"\",SUM(M65:Q65))","v":25866911.051487163},{"$f":"+IF(S65=\"\",\"\",S65/$S$70)","v":8.4144148481701708E-2}]
[null,{"$f":"+D64","v":"London"},5973.4594316893417,2383.045918367347,713.01741172659536,0,0,null,9069.5227617832843,{"$f":"+IF(I66=\"\",\"\",I66/$I$70)","v":0.21091984507011963},null,{"$f":"+N64","v":"London"},42705083.458348639,17036722.737145819,5097459.6836721282,0,0,null,64839265.879166588,{"$f":"+IF(S66=\"\",\"\",S66/$S$70)","v":0.21091984291133428}]
[null,{"$f":"+E64","v":"Praga"},19964.487528344667,7964.6125755857902,2383.0459183673465,0,0,null,30312.146022297806,0.70493600497991304,null,{"$f":"+O64","v":"Praga"},142728871.14281958,56940111.277798191,17036722.737145815,0,0,null,216705705.15776357,0.70493600860696415]
[null,{"$f":"+F64","v":0},0,0,0,1,0,null,"","",null,{"$f":"+P64","v":0},0,0,0,1,0,null,"",""]
[null,{"$f":"+G64","v":0},0,0,0,0,1,null,"","",null,{"$f":"+Q64","v":0},0,0,0,0,1,null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I65:I69)","v":42999.85503387863},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S65:S69)","v":307411882.08841729}]
[]
[null,"Para",{"$f":"+D8","v":"Costo de Vida"}]
[]
[null,"Metodo Aproximado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R77:R81)","v":0.99999999999999989}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,{"$f":"+C76","v":"Munchen"},{"$f":"+D76","v":"London"},{"$f":"+E76","v":"Praga"},{"$f":"+F76","v":0},{"$f":"+G76","v":0}]
[null,{"$f":"+C76","v":"Munchen"},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!O19,\"\")","v":1},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!P19,\"\")","v":0.33333333333333331},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!Q19,\"\")","v":4},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!R19,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!S19,\"\")","v":0},null,null,{"$f":"+B77","v":"Munchen"},{"$f":"+IF(C77=\"\",\"\",C77/C$83)","v":0.23529411764705882},{"$f":"+IF(D77=\"\",\"\",D77/D$83)","v":0.23076923076923075},0.2857142857142857,0,0,null,{"$f":"SUM(K77:O77)-K83","v":0.7517776341305753},{"$f":"IF(Q77=0,\"\",Q77/(5-$P$83))","v":0.25059254471019177},null,"λ","n","IC","CR"]
[null,{"$f":"+D76","v":"London"},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!O20,\"\")","v":3},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!P20,\"\")","v":1},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!Q20,\"\")","v":9},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!R20,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!S20,\"\")","v":0},null,null,{"$f":"+B78","v":"London"},{"$f":"+IF(C78=\"\",\"\",C78/C$83)","v":0.70588235294117652},0.69230769230769229,0.6428571428571429,0,0,null,{"$f":"SUM(K78:O78)-L83","v":2.0410471881060115},{"$f":"IF(Q78=0,\"\",Q78/(5-$P$83))","v":0.68034906270200379},null,{"$f":"+SUMPRODUCT(C83:G83,K84:O84)","v":3.0145622351504704},{"$f":"+COUNTIF(C77:G77,\">0\")","v":3},{"$f":"+(T78-U78)/(U78-1)","v":7.2811175752351964E-3},{"$f":"+IF(V78=0,0,+V78/HLOOKUP(U78,Bruto!D1:M2,2,FALSE))","v":1.4002149183144607E-2},null,{"$f":"+IF(AA94=\"\",\"\",IF(W79>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es consistente"}]
[null,{"$f":"+E76","v":"Praga"},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!O21,\"\")","v":0.25},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!P21,\"\")","v":0.1111111111111111},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!Q21,\"\")","v":1},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!R21,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!S21,\"\")","v":0},null,null,{"$f":"+B79","v":"Praga"},5.8823529411764705E-2,7.6923076923076913E-2,7.1428571428571425E-2,0,0,null,{"$f":"SUM(K79:O79)-M83","v":0.20717517776341304},6.9058392587804343E-2,null,null,null,null,{"$f":"+IF(W78<0,0,W78)","v":1.4002149183144607E-2}]
[null,{"$f":"+F76","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!O22,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!P22,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!Q22,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!R22,\"\")","v":1},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!S22,\"\")","v":0},null,null,0,0,0,0,1,0,null,{"$f":"SUM(K80:O80)-N83","v":0},"",null,1,0,0,0,0,null,{"$f":"+IF(C77=\"\",\"\",C77:G81-W87*T80:X84)","v":-2.0092026908510761},0.33333333333333331,4,0,0]
[null,{"$f":"+G76","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!O23,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!P23,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!Q23,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!R23,\"\")","v":0},{"$f":"+IF(Analisis!$C$19<>\"\",Bruto!S23,\"\")","v":1},null,null,0,0,0,0,0,1,null,{"$f":"SUM(K81:O81)-O83","v":0},"",null,0,1,0,0,0,null,3,-2.0092026908510761,9,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,null,0.25,0.1111111111111111,-2.0092026908510761,0,0]
[null,null,{"$f":"SUM(C77:C81)","v":4.25},{"$f":"SUM(D77:D81)","v":1.4444444444444444},14,1,1,null,null,null,{"$f":"+IF(K77=1,1,0)","v":0},{"$f":"+IF(L78=1,1,0)","v":0},{"$f":"+IF(M79=1,1,0)","v":0},{"$f":"+IF(N80=1,1,0)","v":1},{"$f":"+IF(O81=1,1,0)","v":1},{"$f":"SUM(K83:O83)","v":2},null,null,null,0,0,0,1,0,null,0,0,0,-2.0092026908510761,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+R77","v":0.25059254471019177},{"$f":"+R78","v":0.68034906270200379},{"$f":"+R79","v":6.9058392587804343E-2},{"$f":"+R80","v":""},{"$f":"+R81","v":""},null,null,null,null,0,0,0,0,1,null,0,0,0,0,-2.0092026908510761]
[null,"Metodo Exacto"]
[]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,"λ",3.0092026908510761,null,null,2,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z80:AA81))","v":3.0368954529232051}]
[null,{"$f":"+C87","v":"Munchen"},{"$f":"+IF(C77=\"\",\"\",MMULT(C77:G81,C77:G81))","v":3},1.1111111111111112,11,0,0,null,{"$f":"+IF(OR(C88=\"\",C88=0),\"\",SUM(C88:G88))","v":15.111111111111111},{"$f":"+IF(I88=\"\",\"\",I88/$I$93)","v":0.2497704315886134},null,{"$f":"+M87","v":"Munchen"},{"$f":"+IF(C88=\"\",\"\",MMULT(C88:G92,C88:G92))","v":27.333333333333336},10.027777777777779,99.333333333333343,0,0,null,{"$f":"+IF(OR(M88=\"\",M88=0),\"\",SUM(M88:Q88))","v":136.69444444444446},{"$f":"+IF(S88=\"\",\"\",S88/$S$93)","v":0.24994814968445381},null,"deter",{"$f":"IF(C77=\"\",\"\",VLOOKUP(U78,Z87:AB90,3,FALSE))","v":1.9918878354294839E-7},null,null,3,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z80:AB82))","v":1.9918878354294839E-7}]
[null,{"$f":"+D87","v":"London"},8.25,3,30,0,0,null,41.25,{"$f":"+IF(I89=\"\",\"\",I89/$I$93)","v":0.68181818181818177},null,{"$f":"+N87","v":"London"},74.5,27.333333333333336,270.75,0,0,null,372.58333333333337,{"$f":"+IF(S89=\"\",\"\",S89/$S$93)","v":0.68127505216776651},null,null,null,null,null,4,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z80:AC83))","v":-4.0021063988184446E-7}]
[null,{"$f":"+E87","v":"Praga"},0.83333333333333326,0.30555555555555552,3,0,0,null,4.1388888888888893,6.8411386593204782E-2,null,{"$f":"+O87","v":"Praga"},7.520833333333333,2.7592592592592591,27.333333333333332,0,0,null,37.613425925925924,6.8776798147779747E-2,null,null,null,null,null,5,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z80:AD84))","v":8.0410429455783289E-7}]
[null,{"$f":"+F87","v":0},0,0,0,1,0,null,"","",null,{"$f":"+P87","v":0},0,0,0,1,0,null,"",""]
[null,{"$f":"+G87","v":0},0,0,0,0,1,null,"","",null,{"$f":"+Q87","v":0},0,0,0,0,1,null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I88:I92)","v":60.5},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S88:S92)","v":546.8912037037037},null,null,"λ","n","IC","CR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W87","v":3.0092026908510761},{"$f":"+COUNTIF(Z80:Z84,\"<>0\")","v":3},{"$f":"+(V94-W94)/(W94-1)","v":4.6013454255380282E-3},{"$f":"+X94/+HLOOKUP(W94,Bruto!D1:M2,2,FALSE)","v":8.8487412029577463E-3},null,{"$f":"+IF(Y94<0,\"\",IF(Y95>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es consistente"}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,null,null,{"$f":"+IF(Y94<0,0,Y94)","v":8.8487412029577463E-3}]
[null,{"$f":"+C95","v":"Munchen"},{"$f":"+IF(M88=\"\",\"\",MMULT(M88:Q92,M88:Q92))","v":2241.25},822.27160493827182,8145.2430555555566,0,0,null,{"$f":"+IF(OR(C96=\"\",C96=0),\"\",SUM(C96:G96))","v":11208.764660493827},{"$f":"+IF(I96=\"\",\"\",I96/$I$101)","v":0.24994741773956156},null,{"$f":"+M95","v":"Munchen"},{"$f":"+IF(C96=\"\",\"\",MMULT(C96:G100,C96:G100))","v":15069604.68235597},5528748.7034156928,54766577.988297343,0,0,null,{"$f":"+IF(OR(M96=\"\",M96=0),\"\",SUM(M96:Q96))","v":75364931.374069005},{"$f":"+IF(S96=\"\",\"\",S96/$S$101)","v":0.24994741772923482}]
[null,{"$f":"+D95","v":"London"},6108.932291666667,2241.25,22201.333333333336,0,0,null,30551.515625000004,{"$f":"+IF(I97=\"\",\"\",I97/$I$101)","v":0.68127689980085504},null,{"$f":"+N95","v":"London"},41074933.491223,15069604.68235597,149276214.99222368,0,0,null,205420753.16580266,{"$f":"+IF(S97=\"\",\"\",S97/$S$101)","v":0.68127689982151429}]
[null,{"$f":"+E95","v":"Praga"},616.7037037037037,226.25675154320987,2241.25,0,0,null,3084.2104552469136,6.8775682459583404E-2,null,{"$f":"+O95","v":"Praga"},4146561.5275617684,1521293.8330082591,15069604.682355968,0,0,null,20737460.042925995,6.8775682449250683E-2]
[null,{"$f":"+F95","v":0},0,0,0,1,0,null,"","",null,{"$f":"+P95","v":0},0,0,0,1,0,null,"",""]
[null,{"$f":"+G95","v":0},0,0,0,0,1,null,"","",null,{"$f":"+Q95","v":0},0,0,0,0,1,null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I96:I100)","v":44844.490740740745},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S96:S100)","v":301523144.58279771}]
[]
[null,"Para",{"$f":"+E8","v":"Ocio"}]
[]
[null,"Metodo Aproximado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R108:R112)","v":1}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,{"$f":"+C107","v":"Munchen"},{"$f":"+D107","v":"London"},{"$f":"+E107","v":"Praga"},{"$f":"+F107","v":0},{"$f":"+G107","v":0}]
[null,{"$f":"+C107","v":"Munchen"},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!T24,\"\")","v":1},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!U24,\"\")","v":7},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!V24,\"\")","v":3},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!W24,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!X24,\"\")","v":0},null,null,{"$f":"+B108","v":"Munchen"},{"$f":"+IF(C108=\"\",\"\",C108/C$114)","v":0.67741935483870974},{"$f":"+IF(D108=\"\",\"\",D108/D$114)","v":0.58333333333333337},0.70588235294117652,0,0,null,{"$f":"SUM(K108:O108)-K114","v":1.9666350411132196},{"$f":"IF(Q108=0,\"\",Q108/(5-$P$114))","v":0.65554501370440654},null,"λ","n","IC","CR"]
[null,{"$f":"+D107","v":"London"},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!T25,\"\")","v":0.14285714285714285},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!U25,\"\")","v":1},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!V25,\"\")","v":0.25},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!W25,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!X25,\"\")","v":0},null,null,{"$f":"+B109","v":"London"},{"$f":"+IF(C109=\"\",\"\",C109/C$114)","v":9.6774193548387094E-2},8.3333333333333329E-2,5.8823529411764705E-2,0,0,null,{"$f":"SUM(K109:O109)-L114","v":0.23893105629348516},{"$f":"IF(Q109=0,\"\",Q109/(5-$P$114))","v":7.9643685431161723E-2},null,{"$f":"+SUMPRODUCT(C114:G114,K115:O115)","v":3.0488815597923757},{"$f":"+COUNTIF(C108:G108,\">0\")","v":3},{"$f":"+(T109-U109)/(U109-1)","v":2.444077989618787E-2},{"$f":"+IF(V109=0,0,+V109/HLOOKUP(U109,Bruto!D1:M2,2,FALSE))","v":4.7001499800361286E-2},null,{"$f":"+IF(AA125=\"\",\"\",IF(W110>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es consistente"}]
[null,{"$f":"+E107","v":"Praga"},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!T26,\"\")","v":0.33333333333333331},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!U26,\"\")","v":4},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!V26,\"\")","v":1},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!W26,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!X26,\"\")","v":0},null,null,{"$f":"+B110","v":"Praga"},0.22580645161290325,0.33333333333333331,0.23529411764705882,0,0,null,{"$f":"SUM(K110:O110)-M114","v":0.79443390259329538},0.26481130086443178,null,null,null,null,{"$f":"+IF(W109<0,0,W109)","v":4.7001499800361286E-2}]
[null,{"$f":"+F107","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!T27,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!U27,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!V27,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!W27,\"\")","v":1},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!X27,\"\")","v":0},null,null,0,0,0,0,1,0,null,{"$f":"SUM(K111:O111)-N114","v":0},"",null,1,0,0,0,0,null,{"$f":"+IF(C108=\"\",\"\",C108:G112-W118*T111:X115)","v":-2.0323665530212645},7,3,0,0]
[null,{"$f":"+G107","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!T28,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!U28,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!V28,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!W28,\"\")","v":0},{"$f":"+IF(Analisis!$C$20<>\"\",Bruto!X28,\"\")","v":1},null,null,0,0,0,0,0,1,null,{"$f":"SUM(K112:O112)-O114","v":0},"",null,0,1,0,0,0,null,0.14285714285714285,-2.0323665530212645,0.25,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,null,0.33333333333333331,4,-2.0323665530212645,0,0]
[null,null,{"$f":"SUM(C108:C112)","v":1.4761904761904761},{"$f":"SUM(D108:D112)","v":12},4.25,1,1,null,null,null,{"$f":"+IF(K108=1,1,0)","v":0},{"$f":"+IF(L109=1,1,0)","v":0},{"$f":"+IF(M110=1,1,0)","v":0},{"$f":"+IF(N111=1,1,0)","v":1},{"$f":"+IF(O112=1,1,0)","v":1},{"$f":"SUM(K114:O114)","v":2},null,null,null,0,0,0,1,0,null,0,0,0,-2.0323665530212645,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+R108","v":0.65554501370440654},{"$f":"+R109","v":7.9643685431161723E-2},{"$f":"+R110","v":0.26481130086443178},{"$f":"+R111","v":""},{"$f":"+R112","v":""},null,null,null,null,0,0,0,0,1,null,0,0,0,0,-2.0323665530212645]
[null,"Metodo Exacto"]
[]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,"λ",3.0323665530212645,null,null,2,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z111:AA112))","v":3.1305138058395365}]
[null,{"$f":"+C118","v":"Munchen"},{"$f":"+IF(C108=\"\",\"\",MMULT(C108:G112,C108:G112))","v":3},26,7.75,0,0,null,{"$f":"+IF(OR(C119=\"\",C119=0),\"\",SUM(C119:G119))","v":36.75},{"$f":"+IF(I119=\"\",\"\",I119/$I$124)","v":0.66074486301369861},null,{"$f":"+M118","v":"Munchen"},{"$f":"+IF(C119=\"\",\"\",MMULT(C119:G123,C119:G123))","v":28.19047619047619},236.08333333333331,70.642857142857139,0,0,null,{"$f":"+IF(OR(M119=\"\",M119=0),\"\",SUM(M119:Q119))","v":334.91666666666663},{"$f":"+IF(S119=\"\",\"\",S119/$S$124)","v":0.65860328854060735},null,"deter",{"$f":"IF(C108=\"\",\"\",VLOOKUP(U109,Z118:AB121,3,FALSE))","v":6.0090199676149265E-7},null,null,3,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z111:AB113))","v":6.0090199676149265E-7}]
[null,{"$f":"+D118","v":"London"},0.36904761904761901,3,0.9285714285714286,0,0,null,4.2976190476190474,{"$f":"+IF(I120=\"\",\"\",I120/$I$124)","v":7.7268835616438353E-2},null,{"$f":"+N118","v":"London"},3.3639455782312924,28.19047619047619,8.4315476190476186,0,0,null,39.985969387755098,{"$f":"+IF(S120=\"\",\"\",S120/$S$124)","v":7.8631174722845185E-2},null,null,null,null,null,4,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z111:AC114))","v":-1.2212531198617499E-6}]
[null,{"$f":"+E118","v":"Praga"},1.2380952380952379,10.333333333333332,3,0,0,null,14.571428571428569,0.26198630136986295,null,{"$f":"+O118","v":"Praga"},11.24206349206349,94.190476190476176,28.19047619047619,0,0,null,133.62301587301585,0.26276553673654746,null,null,null,null,null,5,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z111:AD115))","v":2.4820339935798899E-6}]
[null,{"$f":"+F118","v":0},0,0,0,1,0,null,"","",null,{"$f":"+P118","v":0},0,0,0,1,0,null,"",""]
[null,{"$f":"+G118","v":0},0,0,0,0,1,null,"","",null,{"$f":"+Q118","v":0},0,0,0,0,1,null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I119:I123)","v":55.61904761904762},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S119:S123)","v":508.52565192743759},null,null,"λ","n","IC","CR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W118","v":3.0323665530212645},{"$f":"+COUNTIF(Z111:Z115,\"<>0\")","v":3},{"$f":"+(V125-W125)/(W125-1)","v":1.6183276510632227E-2},{"$f":"+X125/+HLOOKUP(W125,Bruto!D1:M2,2,FALSE)","v":3.1121685597369667E-2},null,{"$f":"+IF(Y12<0,\"\",IF(Y126>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":"La matriz es consistente"}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,null,null,{"$f":"+IF(Y125<0,0,Y125)","v":3.1121685597369667E-2}]
[null,{"$f":"+C126","v":"Munchen"},{"$f":"+IF(M119=\"\",\"\",MMULT(M119:Q123,M119:Q123))","v":2383.0459183673465},19964.487528344667,5973.4594316893417,0,0,null,{"$f":"+IF(OR(C127=\"\",C127=0),\"\",SUM(C127:G127))","v":28320.992878401354},{"$f":"+IF(I127=\"\",\"\",I127/$I$132)","v":0.65862996180075206},null,{"$f":"+M126","v":"Munchen"},{"$f":"+IF(C127=\"\",\"\",MMULT(C127:G131,C127:G131))","v":17036722.737145811},142728871.14281958,42705083.458348639,0,0,null,{"$f":"+IF(OR(M127=\"\",M127=0),\"\",SUM(M127:Q127))","v":202470677.33831403},{"$f":"+IF(S127=\"\",\"\",S127/$S$132)","v":0.65862996564355225}]
[null,{"$f":"+D126","v":"London"},284.45044912806389,2383.0459183673465,713.01741172659536,0,0,null,3380.5137792220057,{"$f":"+IF(I128=\"\",\"\",I128/$I$132)","v":7.8616864558231053E-2},null,{"$f":"+N126","v":"London"},2033575.4027785067,17036722.737145811,5097459.6836721282,0,0,null,24167757.823596448,{"$f":"+IF(S128=\"\",\"\",S128/$S$132)","v":7.8616863015871841E-2}]
[null,{"$f":"+E126","v":"Praga"},950.68988230212699,7964.6125755857884,2383.0459183673465,0,0,null,11298.348376255262,0.26275317364101686,null,{"$f":"+O126","v":"Praga"},6796612.9115628367,56940111.277798176,17036722.737145811,0,0,null,80773446.926506817,0.26275317134057585]
[null,{"$f":"+F126","v":0},0,0,0,1,0,null,"","",null,{"$f":"+P126","v":0},0,0,0,1,0,null,"",""]
[null,{"$f":"+G126","v":0},0,0,0,0,1,null,"","",null,{"$f":"+Q126","v":0},0,0,0,0,1,null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I127:I131)","v":42999.855033878623},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S127:S131)","v":307411882.08841729}]
[]
[null,"Para ",{"$f":"+F8","v":0}]
[]
[null,"Metodo Aproximado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R139:R143)","v":0}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0}]
[null,{"$f":"+C138","v":"Munchen"},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Y29,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Z29,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AA29,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AB29,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AC29,\"\")","v":""},null,null,{"$f":"+K138","v":"Munchen"},{"$f":"+IF(C139=\"\",\"\",C139/C$145)","v":""},{"$f":"+IF(D139=\"\",\"\",D139/D$145)","v":""},"","","",null,{"$f":"SUM(K139:O139)-K145","v":0},{"$f":"IF(Q139=0,\"\",Q139/(5-$P$114))","v":""},null,"λ","n","IC","CR"]
[null,{"$f":"+D138","v":"London"},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Y30,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Z30,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AA30,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AB30,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AC30,\"\")","v":""},null,null,{"$f":"+L138","v":"London"},{"$f":"+IF(C140=\"\",\"\",C140/C$145)","v":""},"","","","",null,{"$f":"SUM(K140:O140)-L145","v":0},{"$f":"IF(Q140=0,\"\",Q140/(5-$P$114))","v":""},null,{"$f":"+SUMPRODUCT(C145:G145,K146:O146)","v":0},{"$f":"+COUNTIF(C139:G139,\">0\")","v":0},{"$f":"+(T140-U140)/(U140-1)","v":0},{"$f":"+IF(V140=0,0,+V140/HLOOKUP(U140,Bruto!D1:M2,2,FALSE))","v":0},null,{"$f":"+IF(AA156=\"\",\"\",IF(W141>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":""}]
[null,{"$f":"+E138","v":"Praga"},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Y31,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Z31,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AA31,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AB31,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AC31,\"\")","v":""},null,null,{"$f":"+M138","v":"Praga"},"","","","","",null,{"$f":"SUM(K141:O141)-M145","v":0},"",null,null,null,null,{"$f":"+IF(W140<0,0,W140)","v":0}]
[null,{"$f":"+F138","v":0},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Y32,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Z32,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AA32,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AB32,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AC32,\"\")","v":""},null,null,{"$f":"+N138","v":0},"","","","","",null,{"$f":"SUM(K142:O142)-N145","v":0},"",null,1,0,0,0,0,null,{"$f":"+IF(C139=\"\",\"\",C139:G143-W149*T142:X146)","v":""},"","","",""]
[null,{"$f":"+G138","v":0},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Y33,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!Z33,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AA33,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AB33,\"\")","v":""},{"$f":"+IF(Analisis!$C$21<>\"\",Bruto!AC33,\"\")","v":""},null,null,{"$f":"+O138","v":0},"","","","","",null,{"$f":"SUM(K143:O143)-O145","v":0},"",null,0,1,0,0,0,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,null,"","","","",""]
[null,null,{"$f":"SUM(C139:C143)","v":0},{"$f":"SUM(D139:D143)","v":0},0,0,0,null,null,null,{"$f":"+IF(K139=1,1,0)","v":0},{"$f":"+IF(L140=1,1,0)","v":0},{"$f":"+IF(M141=1,1,0)","v":0},{"$f":"+IF(N142=1,1,0)","v":0},{"$f":"+IF(O143=1,1,0)","v":0},{"$f":"SUM(K145:O145)","v":0},null,null,null,0,0,0,1,0,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+R139","v":""},{"$f":"+R140","v":""},{"$f":"+R141","v":""},{"$f":"+R142","v":""},{"$f":"+R143","v":""},null,null,null,null,0,0,0,0,1,null,"","","","",""]
[null,"Metodo Exacto"]
[]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,"λ",3.024594996877807,null,null,2,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z142:AA143))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+C149","v":"Munchen"},{"$f":"+IF(C139=\"\",\"\",MMULT(C139:G143,C139:G143))","v":""},"","","","",null,{"$f":"+IF(OR(C150=\"\",C150=0),\"\",SUM(C150:G150))","v":""},{"$f":"+IF(I150=\"\",\"\",I150/$I$155)","v":""},null,{"$f":"+M149","v":"Munchen"},{"$f":"+IF(C150=\"\",\"\",MMULT(C150:G154,C150:G154))","v":""},"","","","",null,{"$f":"+IF(OR(M150=\"\",M150=0),\"\",SUM(M150:Q150))","v":""},{"$f":"+IF(S150=\"\",\"\",S150/$S$155)","v":""},null,"deter",{"$f":"IF(C139=\"\",\"\",VLOOKUP(U140,Z149:AB152,3,FALSE))","v":""},null,null,3,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z142:AB144))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+D149","v":"London"},"","","","","",null,"",{"$f":"+IF(I151=\"\",\"\",I151/$I$155)","v":""},null,{"$f":"+N149","v":"London"},"","","","","",null,"",{"$f":"+IF(S151=\"\",\"\",S151/$S$155)","v":""},null,null,null,null,null,4,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z142:AC145))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+E149","v":"Praga"},"","","","","",null,"","",null,{"$f":"+O149","v":"Praga"},"","","","","",null,"","",null,null,null,null,null,5,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z142:AD146))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+F149","v":0},"","","","","",null,"","",null,{"$f":"+P149","v":0},"","","","","",null,"",""]
[null,{"$f":"+G149","v":0},"","","","","",null,"","",null,{"$f":"+Q149","v":0},"","","","","",null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I150:I154)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S150:S154)","v":0},null,null,"λ","n","IC","CR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W149","v":3.024594996877807},{"$f":"+COUNTIF(Z142:Z146,\"<>0\")","v":5},{"$f":"+(V156-W156)/(W156-1)","v":-0.49385125078054826},{"$f":"+X156/+HLOOKUP(W156,Bruto!D1:M2,2,FALSE)","v":-0.4449110367392326},null,{"$f":"+IF(Y156<0,\"\",IF(Y157>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":""}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,null,null,{"$f":"+IF(Y156<0,0,Y156)","v":0}]
[null,{"$f":"+C157","v":"Munchen"},{"$f":"+IF(M150=\"\",\"\",MMULT(M150:Q154,M150:Q154))","v":""},"","","","",null,{"$f":"+IF(OR(C158=\"\",C158=0),\"\",SUM(C158:G158))","v":""},{"$f":"+IF(I158=\"\",\"\",I158/$I$163)","v":""},null,{"$f":"+M157","v":"Munchen"},{"$f":"+IF(C158=\"\",\"\",MMULT(C158:G162,C158:G162))","v":""},"","","","",null,{"$f":"+IF(OR(M158=\"\",M158=0),\"\",SUM(M158:Q158))","v":""},{"$f":"+IF(S158=\"\",\"\",S158/$S$163)","v":""}]
[null,{"$f":"+D157","v":"London"},"","","","","",null,"",{"$f":"+IF(I159=\"\",\"\",I159/$I$163)","v":""},null,{"$f":"+N157","v":"London"},"","","","","",null,"",{"$f":"+IF(S159=\"\",\"\",S159/$S$163)","v":""}]
[null,{"$f":"+E157","v":"Praga"},"","","","","",null,"","",null,{"$f":"+O157","v":"Praga"},"","","","","",null,"",""]
[null,{"$f":"+F157","v":0},"","","","","",null,"","",null,{"$f":"+P157","v":0},"","","","","",null,"",""]
[null,{"$f":"+G157","v":0},"","","","","",null,"","",null,{"$f":"+Q157","v":0},"","","","","",null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I158:I162)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S158:S162)","v":0}]
[]
[null,"Para ",{"$f":"+G8","v":0}]
[]
[null,"Metodo Aproximado"]
[]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0}]
[null,{"$f":"+C169","v":"Munchen"},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AD34,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AE34,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AF34,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AG34,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AH34,\"\")","v":""},null,null,{"$f":"+K169","v":"Munchen"},{"$f":"+IF(C170=\"\",\"\",C170/C$176)","v":""},{"$f":"+IF(D170=\"\",\"\",D170/D$176)","v":""},"","","",null,{"$f":"SUM(K170:O170)-K176","v":0},{"$f":"IF(Q170=0,\"\",Q170/(5-$P$114))","v":""},null,"λ","n","IC","CR"]
[null,{"$f":"+D169","v":"London"},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AD35,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AE35,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AF35,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AG35,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AH35,\"\")","v":""},null,null,{"$f":"+L169","v":"London"},{"$f":"+IF(C171=\"\",\"\",C171/C$176)","v":""},"","","","",null,{"$f":"SUM(K171:O171)-L176","v":0},{"$f":"IF(Q171=0,\"\",Q171/(5-$P$114))","v":""},null,{"$f":"+SUMPRODUCT(C176:G176,K177:O177)","v":0},{"$f":"+COUNTIF(C170:G170,\">0\")","v":0},{"$f":"+(T171-U171)/(U171-1)","v":0},{"$f":"+IF(V171=0,0,+V171/HLOOKUP(U171,Bruto!D1:M2,2,FALSE))","v":0},null,{"$f":"+IF(AA187=\"\",\"\",IF(W172>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":""}]
[null,{"$f":"+E169","v":"Praga"},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AD36,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AE36,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AF36,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AG36,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AH36,\"\")","v":""},null,null,{"$f":"+M169","v":"Praga"},"","","","","",null,{"$f":"SUM(K172:O172)-M176","v":0},"",null,null,null,null,{"$f":"+IF(W171<0,0,W171)","v":0}]
[null,{"$f":"+F169","v":0},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AD37,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AE37,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AF37,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AG37,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AH37,\"\")","v":""},null,null,{"$f":"+N169","v":0},"","","","","",null,{"$f":"SUM(K173:O173)-N176","v":0},"",null,1,0,0,0,0,null,{"$f":"+IF(C170=\"\",\"\",C170:G174-W180*T173:X177)","v":""},"","","",""]
[null,{"$f":"+G169","v":0},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AD38,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AE38,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AF38,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AG38,\"\")","v":""},{"$f":"+IF(Analisis!$C$22<>\"\",Bruto!AH38,\"\")","v":""},null,null,{"$f":"+O169","v":0},"","","","","",null,{"$f":"SUM(K174:O174)-O176","v":0},"",null,0,1,0,0,0,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,null,"","","","",""]
[null,null,{"$f":"SUM(C170:C174)","v":0},{"$f":"SUM(D170:D174)","v":0},0,0,0,null,null,null,{"$f":"+IF(K170=1,1,0)","v":0},{"$f":"+IF(L171=1,1,0)","v":0},{"$f":"+IF(M172=1,1,0)","v":0},{"$f":"+IF(N173=1,1,0)","v":0},{"$f":"+IF(O174=1,1,0)","v":0},{"$f":"SUM(K176:O176)","v":0},null,null,null,0,0,0,1,0,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+R170","v":""},{"$f":"+R171","v":""},{"$f":"+R172","v":""},{"$f":"+R173","v":""},{"$f":"+R174","v":""},null,null,null,null,0,0,0,0,1,null,"","","","",""]
[null,"Metodo Exacto"]
[]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,"λ",1.9999997237447769,null,null,2,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z173:AA174))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+C180","v":"Munchen"},{"$f":"+IF(C170=\"\",\"\",MMULT(C170:G174,C170:G174))","v":""},"","","","",null,{"$f":"+IF(OR(C181=\"\",C181=0),\"\",SUM(C181:G181))","v":""},{"$f":"+IF(I181=\"\",\"\",I181/$I$186)","v":""},null,{"$f":"+M180","v":"Munchen"},{"$f":"+IF(C181=\"\",\"\",MMULT(C181:G185,C181:G185))","v":""},"","","","",null,{"$f":"+IF(OR(M181=\"\",M181=0),\"\",SUM(M181:Q181))","v":""},{"$f":"+IF(S181=\"\",\"\",S181/$S$186)","v":""},null,"deter",{"$f":"IF(C170=\"\",\"\",VLOOKUP(U171,Z180:AB183,3,FALSE))","v":""},null,null,3,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z173:AB175))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+D180","v":"London"},"","","","","",null,"",{"$f":"+IF(I182=\"\",\"\",I182/$I$186)","v":""},null,{"$f":"+N180","v":"London"},"","","","","",null,"",{"$f":"+IF(S182=\"\",\"\",S182/$S$186)","v":""},null,null,null,null,null,4,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z173:AC176))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+E180","v":"Praga"},"","","","","",null,"","",null,{"$f":"+O180","v":"Praga"},"","","","","",null,"","",null,null,null,null,null,5,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z173:AD177))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+F180","v":0},"","","","","",null,"","",null,{"$f":"+P180","v":0},"","","","","",null,"",""]
[null,{"$f":"+G180","v":0},"","","","","",null,"","",null,{"$f":"+Q180","v":0},"","","","","",null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I181:I185)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S181:S185)","v":0},null,null,"λ","n","IC","CR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W180","v":1.9999997237447769},{"$f":"+COUNTIF(Z173:Z177,\"<>0\")","v":5},{"$f":"+(V187-W187)/(W187-1)","v":-0.75000006906380579},{"$f":"+X187/+HLOOKUP(W187,Bruto!D1:M2,2,FALSE)","v":-0.67567573789532043},null,{"$f":"+IF(Y187<0,\"\",IF(Y188>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":""}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,null,null,{"$f":"+IF(Y187<0,0,Y187)","v":0}]
[null,{"$f":"+C188","v":"Munchen"},{"$f":"+IF(M181=\"\",\"\",MMULT(M181:Q185,M181:Q185))","v":""},"","","","",null,{"$f":"+IF(OR(C189=\"\",C189=0),\"\",SUM(C189:G189))","v":""},{"$f":"+IF(I189=\"\",\"\",I189/$I$194)","v":""},null,{"$f":"+M188","v":"Munchen"},{"$f":"+IF(C189=\"\",\"\",MMULT(C189:G193,C189:G193))","v":""},"","","","",null,{"$f":"+IF(OR(M189=\"\",M189=0),\"\",SUM(M189:Q189))","v":""},{"$f":"+IF(S189=\"\",\"\",S189/$S$194)","v":""}]
[null,{"$f":"+D188","v":"London"},"","","","","",null,"",{"$f":"+IF(I190=\"\",\"\",I190/$I$194)","v":""},null,{"$f":"+N188","v":"London"},"","","","","",null,"",{"$f":"+IF(S190=\"\",\"\",S190/$S$194)","v":""}]
[null,{"$f":"+E188","v":"Praga"},"","","","","",null,"","",null,{"$f":"+O188","v":"Praga"},"","","","","",null,"",""]
[null,{"$f":"+F188","v":0},"","","","","",null,"","",null,{"$f":"+P188","v":0},"","","","","",null,"",""]
[null,{"$f":"+G188","v":0},"","","","","",null,"","",null,{"$f":"+Q188","v":0},"","","","","",null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I189:I193)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S189:S193)","v":0}]
[]
[null,"Para ",{"$f":"H8","v":0}]
[]
[null,"Metodo Aproximado"]
[]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0}]
[null,{"$f":"+C200","v":"Munchen"},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AI39,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AJ39,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AK39,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AL39,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AM39,\"\")","v":""},null,null,{"$f":"+K200","v":"Munchen"},{"$f":"+IF(C201=\"\",\"\",C201/C$207)","v":""},{"$f":"+IF(D201=\"\",\"\",D201/D$207)","v":""},"","","",null,{"$f":"SUM(K201:O201)-K207","v":0},{"$f":"IF(Q201=0,\"\",Q201/(5-$P$114))","v":""},null,"λ","n","IC","CR"]
[null,{"$f":"+D200","v":"London"},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AI40,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AJ40,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AK40,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AL40,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AM40,\"\")","v":""},null,null,{"$f":"+L200","v":"London"},{"$f":"+IF(C202=\"\",\"\",C202/C$207)","v":""},"","","","",null,{"$f":"SUM(K202:O202)-L207","v":0},{"$f":"IF(Q202=0,\"\",Q202/(5-$P$114))","v":""},null,{"$f":"+SUMPRODUCT(C207:G207,K208:O208)","v":0},{"$f":"+COUNTIF(C201:G201,\">0\")","v":0},{"$f":"+(T202-U202)/(U202-1)","v":0},{"$f":"+IF(V202=0,0,+V202/HLOOKUP(U202,Bruto!D1:M2,2,FALSE))","v":0},null,{"$f":"+IF(AA218=\"\",\"\",IF(W203>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":""}]
[null,{"$f":"+E200","v":"Praga"},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AI41,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AJ41,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AK41,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AL41,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AM41,\"\")","v":""},null,null,{"$f":"+M200","v":"Praga"},"","","","","",null,{"$f":"SUM(K203:O203)-M207","v":0},"",null,null,null,null,{"$f":"+IF(W202<0,0,W202)","v":0}]
[null,{"$f":"+F200","v":0},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AI42,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AJ42,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AK42,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AL42,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AM42,\"\")","v":""},null,null,{"$f":"+N200","v":0},"","","","","",null,{"$f":"SUM(K204:O204)-N207","v":0},"",null,1,0,0,0,0,null,{"$f":"+IF(C201=\"\",\"\",C201:G205-W211*T204:X208)","v":""},"","","",""]
[null,{"$f":"+G200","v":0},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AI43,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AJ43,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AK43,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AL43,\"\")","v":""},{"$f":"+IF(Analisis!$C$23<>\"\",Bruto!AM43,\"\")","v":""},null,null,{"$f":"+O200","v":0},"","","","","",null,{"$f":"SUM(K205:O205)-O207","v":0},"",null,0,1,0,0,0,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,null,"","","","",""]
[null,null,{"$f":"SUM(C201:C205)","v":0},{"$f":"SUM(D201:D205)","v":0},0,0,0,null,null,null,{"$f":"+IF(K201=1,1,0)","v":0},{"$f":"+IF(L202=1,1,0)","v":0},{"$f":"+IF(M203=1,1,0)","v":0},{"$f":"+IF(N204=1,1,0)","v":0},{"$f":"+IF(O205=1,1,0)","v":0},{"$f":"SUM(K207:O207)","v":0},null,null,null,0,0,0,1,0,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+R201","v":""},{"$f":"+R202","v":""},{"$f":"+R203","v":""},{"$f":"+R204","v":""},{"$f":"+R205","v":""},null,null,null,null,0,0,0,0,1,null,"","","","",""]
[null,"Metodo Exacto"]
[]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,"λ",1.9999997237447771,null,null,2,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z204:AA205))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+C211","v":"Munchen"},{"$f":"+IF(C201=\"\",\"\",MMULT(C201:G205,C201:G205))","v":""},"","","","",null,{"$f":"+IF(OR(C212=\"\",C212=0),\"\",SUM(C212:G212))","v":""},{"$f":"+IF(I212=\"\",\"\",I212/$I$217)","v":""},null,{"$f":"+M211","v":"Munchen"},{"$f":"+IF(C212=\"\",\"\",MMULT(C212:G216,C212:G216))","v":""},"","","","",null,{"$f":"+IF(OR(M212=\"\",M212=0),\"\",SUM(M212:Q212))","v":""},{"$f":"+IF(S212=\"\",\"\",S212/$S$217)","v":""},null,"deter",{"$f":"IF(C201=\"\",\"\",VLOOKUP(U202,Z211:AB214,3,FALSE))","v":""},null,null,3,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z204:AB206))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+D211","v":"London"},"","","","","",null,"",{"$f":"+IF(I213=\"\",\"\",I213/$I$217)","v":""},null,{"$f":"+N211","v":"London"},"","","","","",null,"",{"$f":"+IF(S213=\"\",\"\",S213/$S$217)","v":""},null,null,null,null,null,4,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z204:AC207))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+E211","v":"Praga"},"","","","","",null,"","",null,{"$f":"+O211","v":"Praga"},"","","","","",null,"","",null,null,null,null,null,5,"deter",{"$f":"IF($C$77=\"\",\"\",MDETERM(Z204:AD208))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+F211","v":0},"","","","","",null,"","",null,{"$f":"+P211","v":0},"","","","","",null,"",""]
[null,{"$f":"+G211","v":0},"","","","","",null,"","",null,{"$f":"+Q211","v":0},"","","","","",null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I212:I216)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S212:S216)","v":0},null,null,"λ","n","IC","CR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W211","v":1.9999997237447771},{"$f":"+COUNTIF(Z204:Z208,\"<>0\")","v":5},{"$f":"+(V218-W218)/(W218-1)","v":-0.75000006906380579},{"$f":"+X218/+HLOOKUP(W218,Bruto!D1:M2,2,FALSE)","v":-0.67567573789532043},null,{"$f":"+IF(Y218<0,\"\",IF(Y219>0.1,\"La matriz es inconsistente, se debe volver a evaluar\",\"La matriz es consistente\"))","v":""}]
[null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,{"$f":"+Analisis!$E$18","v":"Munchen"},{"$f":"+Analisis!$E$19","v":"London"},{"$f":"+Analisis!$E$20","v":"Praga"},{"$f":"+Analisis!$E$21","v":0},{"$f":"+Analisis!$E$22","v":0},null,null,null,null,null,null,null,{"$f":"+IF(Y218<0,0,Y218)","v":0}]
[null,{"$f":"+C219","v":"Munchen"},{"$f":"+IF(M212=\"\",\"\",MMULT(M212:Q216,M212:Q216))","v":""},"","","","",null,{"$f":"+IF(OR(C220=\"\",C220=0),\"\",SUM(C220:G220))","v":""},{"$f":"+IF(I220=\"\",\"\",I220/$I$225)","v":""},null,{"$f":"+M219","v":"Munchen"},{"$f":"+IF(C220=\"\",\"\",MMULT(C220:G224,C220:G224))","v":""},"","","","",null,{"$f":"+IF(OR(M220=\"\",M220=0),\"\",SUM(M220:Q220))","v":""},{"$f":"+IF(S220=\"\",\"\",S220/$S$225)","v":""}]
[null,{"$f":"+D219","v":"London"},"","","","","",null,"",{"$f":"+IF(I221=\"\",\"\",I221/$I$225)","v":""},null,{"$f":"+N219","v":"London"},"","","","","",null,"",{"$f":"+IF(S221=\"\",\"\",S221/$S$225)","v":""}]
[null,{"$f":"+E219","v":"Praga"},"","","","","",null,"","",null,{"$f":"+O219","v":"Praga"},"","","","","",null,"",""]
[null,{"$f":"+F219","v":0},"","","","","",null,"","",null,{"$f":"+P219","v":0},"","","","","",null,"",""]
[null,{"$f":"+G219","v":0},"","","","","",null,"","",null,{"$f":"+Q219","v":0},"","","","","",null,"",""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I220:I224)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S220:S224)","v":0}]