{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Comparador","Comparador2"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Comparador","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[19,6,19,8],[20,6,20,10],[21,6,21,10]]}
["Meses","2020","2021","2022"]
["2022-01-01",440,407,415]
["2022-02-01",375,328,320]
["2022-03-01",349,333,322]
["2022-04-01",430,385,394]
["2022-05-01",326,273,303]
["2022-06-01",288,215]
["2022-07-01",301,291]
["2022-08-01",272,231]
["2022-09-01",280,277]
["2022-10-01",365,328]
["2022-11-01",382,326]
["2022-12-01",468,369]
["Promedio",{"$f":"SUBTOTAL(101,TablaEscalones[2020])","v":356.33333333333331},{"$f":"SUBTOTAL(101,TablaEscalones[2021])","v":313.58333333333331},{"$f":"SUBTOTAL(101,TablaEscalones[2022])","v":350.8}]
["Máximo",{"$f":"SUBTOTAL(104,TablaEscalones[2020])","v":468},{"$f":"SUBTOTAL(104,TablaEscalones[2021])","v":407},{"$f":"SUBTOTAL(104,TablaEscalones[2022])","v":415}]
["Mínimo",{"$f":"SUBTOTAL(105,TablaEscalones[2020])","v":272},{"$f":"SUBTOTAL(105,TablaEscalones[2021])","v":215},{"$f":"SUBTOTAL(105,TablaEscalones[2022])","v":303}]
["Leyenda\n(promedio)",{"$f":"B1 & CHAR(10) & IFERROR(\" (\" & ROUND(B14,0) & \")\",\"\")","v":"2020\n (356)"},{"$f":"C1 & CHAR(10) & IFERROR(\" (\" & ROUND(C14,0) & \")\",\"\")","v":"2021\n (314)"},"2022\n (351)"]
[]
[]
[null,null,null,null,null,"AUTOR:","#ExcelPedroWave"]
[null,null,null,null,null,"BLOG:","Comparador mensual interactivo | #ExcelPedroWave"]
[null,null,null,null,null,"COPYRIGHT:","Creative Commons — Atribución-NoComercial-CompartirIgual 3.0 No portada"]
[]
["Fechas","Mínimo"]
[2020,{"$f":"B16","v":272}]
[2021,{"$f":"C16","v":215}]
[2022,{"$f":"D16","v":303}]
[{"$f":"SUBTOTAL(103,TablaFechas[Fechas])","v":3},{"$f":"MIN(TablaFechas[Mínimo])","v":215}]
[]
[]
["Mín. eje",null,"Mínimo valor eje vertical:",{"$f":"ROUNDDOWN(SUBTOTAL(105,TablaFechas[Mínimo])/50,0)*50","v":200}]
[{"$f":"miValormín","v":200}]
[{"$f":"IF(A32=0,0,A32-50)","v":150}]
[{"$f":"IF(A33=0,0,A33-50)","v":100}]
[50]
[0]
[0]
[0]
[{"$f":"SUBTOTAL(104,TablaMínEjeVertical[Mín. eje])","v":200}]

{"sheet":"Comparador2","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[19,6,19,8],[20,6,20,10],[21,6,21,10]]}
["Meses","2020","2021","2022"]
["2022-02-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":440},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":407},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":415}]
["2022-03-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":375},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":328},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":320}]
["2022-04-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":349},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":333},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":322}]
["2022-05-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":430},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":385},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":394}]
["2022-06-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":326},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":273},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":303}]
["2022-07-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":288},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":215},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":{"$error":"#N/A"}}]
["2022-08-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":301},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":291},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":{"$error":"#N/A"}}]
["2022-09-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":272},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":231},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":{"$error":"#N/A"}}]
["2022-10-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":280},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":277},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":{"$error":"#N/A"}}]
["2022-11-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":365},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":328},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":{"$error":"#N/A"}}]
["2022-12-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":382},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":326},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":{"$error":"#N/A"}}]
["2023-01-01",{"$f":"IF(TablaEscalones[[#This Row],[2020]]=0,NA(),TablaEscalones[[#This Row],[2020]])","v":468},{"$f":"IF(TablaEscalones[[#This Row],[2021]]=0,NA(),TablaEscalones[[#This Row],[2021]])","v":369},{"$f":"IF(TablaEscalones[[#This Row],[2022]]=0,NA(),TablaEscalones[[#This Row],[2022]])","v":{"$error":"#N/A"}}]
["2022-01-01",{"$f":"B2","v":440},{"$f":"C2","v":407},415]
["2022-02-01",{"$f":"B3","v":375},328,320]
["2022-03-01",{"$f":"B4","v":349},333,322]
["2022-04-01",{"$f":"B5","v":430},385,394]
["2022-05-01",{"$f":"B6","v":326},273,303]
["2022-06-01",{"$f":"B7","v":288},215,{"$error":"#N/A"}]
["2022-07-01",{"$f":"B8","v":301},291,{"$error":"#N/A"},null,"AUTOR:","#ExcelPedroWave"]
["2022-08-01",{"$f":"B9","v":272},231,{"$error":"#N/A"},null,"BLOG:","Comparador mensual interactivo | #ExcelPedroWave"]
["2022-09-01",{"$f":"B10","v":280},277,{"$error":"#N/A"},null,"COPYRIGHT:","Creative Commons — Atribución-NoComercial-CompartirIgual 3.0 No portada"]
["2022-10-01",{"$f":"B11","v":365},328,{"$error":"#N/A"}]
["2022-11-01",{"$f":"B12","v":382},326,{"$error":"#N/A"}]
["2022-12-01",{"$f":"B13","v":468},369,{"$error":"#N/A"}]