{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Proyección de Índice Acumulado","Calculo de Índice por Semestre"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":3,"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":"Proyección de Índice Acumulado","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Índice Acumulado",2,null,"1.- Introduce estos valores"]
["Créditos Acumulados",10]
["Créditos Semestre Actual",10]
[]
["Puntos Acumulados",{"$f":"B3/B2","v":5}]
["Puntos Semestre Actual",{"$f":"B4/E9","v":2.5},null,"2.- Introduce el índice semestral que el estudiante espera obtener"]
[]
[null,null,null,"Si el estudiante obtiene un índice semestral de: ",4]
[null,null,null,"Entonces su índice acumulado será de:",{"$f":"(B3+B4)/(B6+B7)","v":2.6666666666666665}]

{"sheet":"Calculo de Índice por Semestre","index":1,"n_rows":215,"n_cols":17,"rows_kept":215,"cut":false,"hidden":false,"merged":[[0,0,0,12],[5,6,5,12],[6,6,6,12],[5,0,5,4]]}
["Cálculo de Índice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nota (Literal)","Nota (Puntos)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",1]
["Información Semestral",null,null,null,null,null,"     Resumen de Calculo de Índice",null,null,null,null,null,null,null,null,"F",0]
["Semestre:",1,null,null,null,null,"(Esta sección se llena automáticamente)",null,null,null,null,null,null,null,null,"S",0]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice",null,null,null,null,null,null,null,null,null,null,"NS",0]
[null,null,null,{"$f":"IF(B9=\"\",\"\",(VLOOKUP(B9,$P$2:$Q$13,2)*C9))","v":""},null,null,"Semestre","Créditos Sem.","Puntos Sem.","Índice Sem.","Total Créditos","Total Puntos","Índice Acum.",null,null,"RET",0]
[null,null,null,"",null,null,{"$f":"IF(B7<>\"\",B7,\"\")","v":1},{"$f":"IF(C19=0,\"\",C19)","v":""},{"$f":"IF(H10=\"\",\"\",D19)","v":""},{"$f":"IF(H10=\"\",\" \",ROUNDUP(I10/H10,4))","v":" "},{"$f":"IF(H10=\"\",\"\",H10)","v":""},{"$f":"IF(H10=\"\",\"\",I10)","v":""},{"$f":"IF(H10=\"\",\" \",ROUNDUP(L10/K10,4))","v":" "},null,null,null," "]
[null,null,null,"",null,null,{"$f":"IF(B21<>\"\",B21,\"\")","v":2},{"$f":"IF(C33=0,\"\",C33)","v":""},{"$f":"IF(H11=\"\",\"\",D33)","v":""}," ",{"$f":"IF(H11=\"\",\"\",K10+H11)","v":""},{"$f":"IF(H11=\"\",\"\",L10+I11)","v":""}," "]
[null,null,null,"",null,null,{"$f":"IF(B35<>\"\",B35,\"\")","v":3},{"$f":"IF(C47=0,\"\",C47)","v":""},{"$f":"IF(H12=\"\",\" \",D47)","v":" "}," ",{"$f":"IF(H12=\"\",\"\",K11+H12)","v":""},{"$f":"IF(H12=\"\",\"\",L11+I12)","v":""}," "]
[null,null,null,"",null,null,{"$f":"IF(B49<>\"\",B49,\"\")","v":4},{"$f":"IF(C61=0,\"\",C61)","v":""},{"$f":"IF(H13=\"\",\" \",D61)","v":" "}," ",{"$f":"IF(H13=\"\",\"\",K12+H13)","v":""},{"$f":"IF(H13=\"\",\"\",L12+I13)","v":""}," ",null,null,null," "]
[null,null,null,"",null,null,{"$f":"IF(B63<>\"\",B63,\"\")","v":5},{"$f":"IF(C75=0,\"\",C75)","v":""},{"$f":"IF(H14=\"\",\" \",D75)","v":" "}," ","",""," "]
[null,null,null,"",null,null,{"$f":"IF(B77<>\"\",B77,\"\")","v":6},{"$f":"IF(C89=0,\"\",C89)","v":""},{"$f":"IF(H15=\"\",\" \",D89)","v":" "}," ","",""," "]
[null,null,null,"",null,null,{"$f":"IF(B91<>\"\",B91,\"\")","v":7},{"$f":"IF(C103=0,\"\",C103)","v":""},{"$f":"IF(H16=\"\",\" \",D103)","v":" "}," ","",""," "]
[null,null,null,"",null,null,{"$f":"IF(B105<>\"\",B105,\"\")","v":8},{"$f":"IF(C117=0,\"\",C117)","v":""},{"$f":"IF(H17=\"\",\" \",D117)","v":" "}," ","",""," "]
[null,null,null,"",null,null,{"$f":"IF(B119<>\"\",B119,\"\")","v":9},{"$f":"IF(C131=0,\"\",C131)","v":""},{"$f":"IF(H18=\"\",\" \",D131)","v":" "}," ","",""," "]
["Total para el Semestre",null,{"$f":"SUMIFS(C9:C18,B9:B18,\"<=F\")","v":0},{"$f":"SUM(D9:D18)","v":0},{"$f":"IF(C19=0,\"\",ROUNDUP(D19/C19,4))","v":""},null,{"$f":"IF(B133<>\"\",B133,\"\")","v":10},{"$f":"IF(C145=0,\"\",C145)","v":""},{"$f":"IF(H19=\"\",\" \",D145)","v":" "}," ","",""," "]
[null,null,null,null,null,null,{"$f":"IF(B147<>\"\",B147,\"\")","v":11},{"$f":"IF(C159=0,\"\",C159)","v":""},{"$f":"IF(H20=\"\",\" \",D159)","v":" "}," ",{"$f":"IF(H20=\"\",\"\",K19+H20)","v":""},{"$f":"IF(H20=\"\",\"\",L19+I20)","v":""}," "]
["Semestre:",2,null,null,null,null,{"$f":"IF(B161<>\"\",B161,\"\")","v":12},{"$f":"IF(C173=0,\"\",C173)","v":""},{"$f":"IF(H21=\"\",\" \",D173)","v":" "}," ",{"$f":"IF(H21=\"\",\"\",K20+H21)","v":""},{"$f":"IF(H21=\"\",\"\",L20+I21)","v":""}," "]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice",null,{"$f":"IF(B175<>\"\",B175,\"\")","v":13},{"$f":"IF(C187=0,\"\",C187)","v":""},{"$f":"IF(H22=\"\",\" \",D187)","v":" "}," ",{"$f":"IF(H22=\"\",\"\",K21+H22)","v":""},{"$f":"IF(H22=\"\",\"\",L21+I22)","v":""}," "]
[null,null,null,{"$f":"IF(B23=\"\",\"\",(VLOOKUP(B23,$P$2:$Q$13,2)*C23))","v":""},null,null,{"$f":"IF(B189<>\"\",B189,\"\")","v":14},{"$f":"IF(C201=0,\"\",C201)","v":""},{"$f":"IF(H23=\"\",\" \",D201)","v":" "}," ",{"$f":"IF(H23=\"\",\"\",K22+H23)","v":""},{"$f":"IF(H23=\"\",\"\",L22+I23)","v":""}," "]
[null,null,null,"",null,null,{"$f":"IF(B203<>\"\",B203,\"\")","v":15},{"$f":"IF(C215=0,\"\",C215)","v":""},{"$f":"IF(H24=\"\",\" \",D215)","v":" "}," ",{"$f":"IF(H24=\"\",\"\",K23+H24)","v":""},{"$f":"IF(H24=\"\",\"\",L23+I24)","v":""}," "]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C23:C32,B23:B32,\"<=F\")","v":0},{"$f":"SUM(D23:D32)","v":0},{"$f":"IF(C33=0,\"\",ROUNDUP(D33/C33,4))","v":""}]
[]
["Semestre:",3]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B37=\"\",\"\",(VLOOKUP(B37,$P$2:$Q$13,2)*C37))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C37:C46,B37:B46,\"<=F\")","v":0},{"$f":"SUM(D37:D46)","v":0},{"$f":"IF(C47=0,\" \",ROUNDUP(D47/C47,4))","v":" "}]
[]
["Semestre:",4]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B51=\"\",\"\",(VLOOKUP(B51,$P$2:$Q$13,2)*C51))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C51:C60,B51:B60,\"<=F\")","v":0},{"$f":"SUM(D51:D60)","v":0},{"$f":"IF(C61=0,\" \",ROUNDUP(D61/C61,4))","v":" "}]
[]
["Semestre:",5]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B65=\"\",\"\",(VLOOKUP(B65,$P$2:$Q$13,2)*C65))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C65:C74,B65:B74,\"<=F\")","v":0},{"$f":"SUM(D65:D74)","v":0},{"$f":"IF(C75=0,\" \",ROUNDUP(D75/C75,4))","v":" "}]
[]
["Semestre:",6]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B79=\"\",\"\",(VLOOKUP(B79,$P$2:$Q$13,2)*C79))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C79:C88,B79:B88,\"<=F\")","v":0},{"$f":"SUM(D79:D88)","v":0},{"$f":"IF(C89=0,\" \",ROUNDUP(D89/C89,4))","v":" "}]
[]
["Semestre:",7]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B93=\"\",\"\",(VLOOKUP(B93,$P$2:$Q$13,2)*C93))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C93:C102,B93:B102,\"<=F\")","v":0},{"$f":"SUM(D93:D102)","v":0},{"$f":"IF(C103=0,\" \",ROUNDUP(D103/C103,4))","v":" "}]
[]
["Semestre:",8]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B107=\"\",\"\",(VLOOKUP(B107,$P$2:$Q$13,2)*C107))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C107:C116,B107:B116,\"<=F\")","v":0},{"$f":"SUM(D107:D116)","v":0},{"$f":"IF(C117=0,\" \",ROUNDUP(D117/C117,4))","v":" "}]
[]
["Semestre:",9]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B121=\"\",\"\",(VLOOKUP(B121,$P$2:$Q$13,2)*C121))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C121:C130,B121:B130,\"<=F\")","v":0},{"$f":"SUM(D121:D130)","v":0},{"$f":"IF(C131=0,\" \",ROUNDUP(D131/C131,4))","v":" "}]
[]
["Semestre:",10]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B135=\"\",\"\",(VLOOKUP(B135,$P$2:$Q$13,2)*C135))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C135:C144,B135:B144,\"<=F\")","v":0},{"$f":"SUM(D135:D144)","v":0},{"$f":"IF(C145=0,\" \",ROUNDUP(D145/C145,4))","v":" "}]
[]
["Semestre:",11]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B149=\"\",\"\",(VLOOKUP(B149,$P$2:$Q$13,2)*C149))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C149:C158,B149:B158,\"<=F\")","v":0},{"$f":"SUM(D149:D158)","v":0},{"$f":"IF(C159=0,\" \",ROUNDUP(D159/C159,4))","v":" "}]
[]
["Semestre:",12]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B163=\"\",\"\",(VLOOKUP(B163,$P$2:$Q$13,2)*C163))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C163:C172,B163:B172,\"<=F\")","v":0},{"$f":"SUM(D163:D172)","v":0},{"$f":"IF(C173=0,\" \",ROUNDUP(D173/C173,4))","v":" "}]
[]
["Semestre:",13]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B177=\"\",\"\",(VLOOKUP(B177,$P$2:$Q$13,2)*C177))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C177:C186,B177:B186,\"<=F\")","v":0},{"$f":"SUM(D177:D186)","v":0},{"$f":"IF(C187=0,\" \",ROUNDUP(D187/C187,4))","v":" "}]
[]
["Semestre:",14]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B191=\"\",\"\",(VLOOKUP(B191,$P$2:$Q$13,2)*C191))","v":""}]
[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,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C191:C200,B191:B200,\"<=F\")","v":0},{"$f":"SUM(D191:D200)","v":0},{"$f":"IF(C201=0,\" \",ROUNDUP(D201/C201,4))","v":" "}]
[]
["Semestre:",15]
["Asignatura","Calificación ","Créditos","Puntos Acum.","Índice"]
[null,null,null,{"$f":"IF(B205=\"\",\"\",(VLOOKUP(B205,$P$2:$Q$13,2)*C205))","v":""}]
[null,null,null,{"$f":"IF(B206=\"\",\"\",(VLOOKUP(B206,$J$8192:$K$8196,2)*C206))","v":""}]
[null,null,null,{"$f":"IF(B207=\"\",\"\",(VLOOKUP(B207,$P$2:$Q$13,2)*C207))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
["Total para el Semestre",null,{"$f":"SUMIFS(C205:C214,B205:B214,\"<=F\")","v":0},{"$f":"SUM(D205:D214)","v":0},{"$f":"IF(C215=0,\" \",ROUNDUP(D215/C215,4))","v":" "}]