{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Presentación","Ejercicio","Datos","Solución"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Presentación","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Ejercicio","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["ID","Nombre","Apellido","Puesto","Salario base","Días trabajados","Salario total"]
[]
[]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G2:G4)","v":0}]

{"sheet":"Datos","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,6]]}
[]
[null,null,"Tabla con la información"]
[]
[null,null,"ID","Nombre","Apellido","Puesto","Salario base"]
[null,null,1,"Luis","Apaez","Secretario",2000]
[null,null,2,"Ana","Alvarez","Secretaria",2500]
[null,null,3,"Pedro","Sanchez","Ingeniero",3000]
[null,null,4,"Jorge","Ramirez","Auxiliar",3500]
[null,null,5,"Luis","Lopez","Auxiliar",4000]
[null,null,6,"Kendral","Perez","Ingeniero",4500]
[null,null,7,"José","Perez","Docente",5000]
[null,null,8,"Alex","Smith","Ingeniero",5500]
[null,null,9,"Danna","Santander","Docente",6000]
[null,null,10,"Alexa","Plata","Auxiliar",6500]
[null,null,11,"Andrea","Plata","Docente",7000]
[null,null,12,"Lola","Smith","Ingeniero",7500]

{"sheet":"Solución","index":3,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["ID","Nombre","Apellido","Puesto","Salario base","Días trabajados","Salario total"]
[5,{"$f":"VLOOKUP(A2, Datos!$C$5:$G$16,2,FALSE)","v":"Luis"},{"$f":"VLOOKUP(A2, Datos!$C$5:$G$16,3,FALSE)","v":"Lopez"},{"$f":"VLOOKUP(A2, Datos!$C$5:$G$16,4,FALSE)","v":"Auxiliar"},{"$f":"VLOOKUP(A2, Datos!$C$5:$G$16,5,FALSE)","v":4000},15,{"$f":"E2*F2","v":60000}]
[1,{"$f":"VLOOKUP(A3, Datos!$C$5:$G$16,2,FALSE)","v":"Luis"},{"$f":"VLOOKUP(A3, Datos!$C$5:$G$16,3,FALSE)","v":"Apaez"},{"$f":"VLOOKUP(A3, Datos!$C$5:$G$16,4,FALSE)","v":"Secretario"},{"$f":"VLOOKUP(A3, Datos!$C$5:$G$16,5,FALSE)","v":2000},1,{"$f":"E3*F3","v":2000}]
[null,null,null,null,null,"Total",{"$f":"SUM(G2:G3)","v":62000}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"ID","Nombre","Apellido","Puesto","Salario base","Días trabajados","Salario total"]
[null,null,null,null,null,null,null,null,5,{"$f":"VLOOKUP(I9,Datos!$C$5:$G$16,2,FALSE)","v":"Luis"},{"$f":"VLOOKUP(J9,Datos!C5:G16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K9,Datos!D5:H16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L9,Datos!E5:I16,2,FALSE)","v":{"$error":"#N/A"}},15,{"$f":"M9*N9","v":{"$error":"#N/A"}}]