{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calendario","Citas","Feriados","Auxiliar"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"comments":1,"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":"Calendario","index":0,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,1,7,7],[7,9,7,11],[1,1,1,5]]}
[]
[null,"Reserva de citas o turnos"]
[]
[null,null,null,"Año",2020,"Seleccione el año",null,null,null,null,null,null,null,8]
[null,null,null,"Mes","Enero","Seleccione el mes"]
[]
[null,"Seleccione abajo el día que quiera visualizar",null,null,null,null,null,null,null,"2020-01-02"]
[null,{"$f":"TEXT(DATE(E4,VLOOKUP(E5,Auxiliar!$A$3:$B$14,2,0),1),\"MMMM\")&\" \"&Calendario!E4","v":"enero 2020"},null,null,null,null,null,null,null,"CITAS DEL DÍA"]
[null,"LUN","MAR","MIE","JUE","VIE","SAB","DOM",null,"FECHA","HORA","PACIENTE"]
[null,{"$f":"B8-WEEKDAY(B8,11)+1","v":"2019-12-30"},{"$f":"B10+1","v":"2019-12-31"},{"$f":"C10+1","v":"2020-01-01"},"2020-01-02","2020-01-03","2020-01-04","2020-01-05",null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A1)),COLUMN(A1)),\"\")","v":"2020-01-02"},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B1)),COLUMN(B1)),\"\")","v":"08:30:00"},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C1)),COLUMN(C1)),\"\")","v":"Ramírez, Cruz"}]
[null,{"$f":"H10+1","v":"2020-01-06"},{"$f":"B11+1","v":"2020-01-07"},{"$f":"C11+1","v":"2020-01-08"},"2020-01-09","2020-01-10","2020-01-11","2020-01-12",null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A2)),COLUMN(A2)),\"\")","v":"2020-01-02"},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B2)),COLUMN(B2)),\"\")","v":"09:00:00"},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C2)),COLUMN(C2)),\"\")","v":"Mcqueen, Rayo"}]
[null,{"$f":"H11+1","v":"2020-01-13"},{"$f":"B12+1","v":"2020-01-14"},"2020-01-15","2020-01-16","2020-01-17","2020-01-18","2020-01-19",null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A3)),COLUMN(A3)),\"\")","v":"2020-01-02"},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B3)),COLUMN(B3)),\"\")","v":"15:00:00"},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C3)),COLUMN(C3)),\"\")","v":"Storm"}]
[null,"2020-01-20",{"$f":"B13+1","v":"2020-01-21"},"2020-01-22","2020-01-23","2020-01-24","2020-01-25","2020-01-26",null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A4)),COLUMN(A4)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B4)),COLUMN(B4)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C4)),COLUMN(C4)),\"\")","v":""}]
[null,"2020-01-27",{"$f":"B14+1","v":"2020-01-28"},"2020-01-29","2020-01-30","2020-01-31","2020-02-01","2020-02-02",null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A5)),COLUMN(A5)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B5)),COLUMN(B5)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C5)),COLUMN(C5)),\"\")","v":""}]
[null,"2020-02-03",{"$f":"B15+1","v":"2020-02-04"},"2020-02-05","2020-02-06","2020-02-07","2020-02-08","2020-02-09",null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A6)),COLUMN(A6)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B6)),COLUMN(B6)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C6)),COLUMN(C6)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A7)),COLUMN(A7)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B7)),COLUMN(B7)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C7)),COLUMN(C7)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A8)),COLUMN(A8)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B8)),COLUMN(B8)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C8)),COLUMN(C8)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A9)),COLUMN(A9)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B9)),COLUMN(B9)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C9)),COLUMN(C9)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A10)),COLUMN(A10)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B10)),COLUMN(B10)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C10)),COLUMN(C10)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A11)),COLUMN(A11)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B11)),COLUMN(B11)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C11)),COLUMN(C11)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A12)),COLUMN(A12)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B12)),COLUMN(B12)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C12)),COLUMN(C12)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A13)),COLUMN(A13)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B13)),COLUMN(B13)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C13)),COLUMN(C13)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A14)),COLUMN(A14)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B14)),COLUMN(B14)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C14)),COLUMN(C14)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A15)),COLUMN(A15)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B15)),COLUMN(B15)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C15)),COLUMN(C15)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A16)),COLUMN(A16)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B16)),COLUMN(B16)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C16)),COLUMN(C16)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(A17)),COLUMN(A17)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(B17)),COLUMN(B17)),\"\")","v":""},{"$f":"IFERROR(INDEX(Citas,SMALL(IF(INT(INDEX(Citas,0,1))=$J$7,MATCH(ROW(Citas),ROW(Citas),0),\"\"),ROW(C17)),COLUMN(C17)),\"\")","v":""}]

{"sheet":"Citas","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,5],[1,1,1,5]]}
[]
[null,"Reserva de citas o turnos"]
[]
[null,"Ingrese en la tabla los turnos asignados a los diferentes pacientes"]
[null,"Turno",null,"Datos Personales"]
[null,"Día","Hora","Paciente","Teléfono","Obra Social"]
[null,"2020-01-02","08:30:00","Ramírez, Cruz","15-555-555","Seguros Salud"]
[null,"2020-01-02","09:00:00","Mcqueen, Rayo","15-522-111","Seguros Salud"]
[null,"2020-01-02","15:00:00","Storm","15-333-111","Salud Oboso"]
[null,"2020-01-06","09:00:00","Mate","15-111-111","Salud Oboso"]
[null,"2020-01-23","09:00:00","Cecilia","15-000-111","Yonilonci Salud"]
[null,"2020-01-23","09:30:00","Barcela","15-222-555","Yonilonci Salud"]
[null,"2020-01-23","10:00:00","Trixie","15-333-222"]
[null,"2020-02-03","09:00:00","Elena"]

{"sheet":"Feriados","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,4,4,5],[1,1,1,5]]}
[]
[null,"Reserva de citas o turnos"]
[]
[null,"Ingrese los feriados y vacaciones",null,null,"Identifique los días laborables"]
[null,"FERIADOS Y VACACIONES",null,null,"DÍAS LABORABLES"]
[null,"Día","Concepto",null,"Lun","Si"]
[null,"2020-01-01","Año Nuevo",null,"Mar","Si"]
[null,"2020-01-07","Vacaciones",null,"Mie","Si"]
[null,"2020-01-08","Vacaciones",null,"Jue","Si"]
[null,null,null,null,"Vie","Si"]
[null,null,null,null,"Sab","No"]
[null,null,null,null,"Dom","No"]

{"sheet":"Auxiliar","index":3,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
["Mes","# de mes",null,"Años"]
["Enero",1,null,2019]
["Febrero",2,null,2020]
["Marzo",3,null,2021]
["Abril",4,null,2022]
["Mayo",5,null,2023]
["Junio",6,null,2024]
["Julio",7,null,2025]
["Agosto",8,null,2026]
["Septiembre",9,null,2027]
["Octubre",10,null,2028]
["Noviembre",11,null,2029]
["Diciembre",12,null,2030]
[null,null,null,2031]
[null,null,null,2032]
[null,null,null,2033]
[null,null,null,2034]
[null,null,null,2035]
[null,null,null,2036]
[null,null,null,2037]
[null,null,null,2038]
[null,null,null,2039]
[null,null,null,2040]
[null,null,null,2041]
[null,null,null,2042]
[null,null,null,2043]
[null,null,null,2044]
[null,null,null,2045]
[null,null,null,2046]
[null,null,null,2047]
[null,null,null,2048]
[null,null,null,2049]
[null,null,null,2050]