{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PVPC"],"not_rendered":{"charts":1,"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":"PVPC","index":0,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[18,10,18,12],[20,10,20,15],[19,10,19,15]]}
["Hora","14/06","15/06","16/06","17/06","18/06","19/06","20/06"]
[1,266.95,311.85000000000002,351.79,366.15,382.47,322.01,389.8]
[2,266.33999999999997,310.04000000000002,327.79,362.99,349.78,311.57,392.63]
[3,254.41,309.45,325.77999999999997,357.71,340.4,304.47000000000003,400.82]
[4,249.73,308.39,329.18,356.93,341.76,296.16000000000003,405.91]
[5,244.74,309.25,333.76,359.79,345.85,274.58,408.32]
[6,248.96,317.24,343.87,357.71,343.84,257.95,394.56]
[7,261.12,306.79000000000002,337.22,351.59,333.59,259.74,377.08]
[8,274.29000000000002,301.17,350.95,352.26,318.77999999999997,259.43,374.73]
[9,300.68,318.52999999999997,365.2,361.21,273.88,234.59,382.65]
[10,291.95,293.99,327.58,344.42,249.12,201.14,349.03]
[11,332.44,323.20999999999998,366.39,381.12,248.11,164.99,380.44]
[12,317.75,318.02999999999997,354.13,368.45,223.01,150.80000000000001,346.4]
[13,313.79000000000002,318.49,351.11,365.07,200.13,146.69,333.98]
[14,313.36,319.3,351.57,360.42,192.8,145.94,312.39999999999998]
[15,265.42,267.74,294.85000000000002,296.38,176.32,139,252.6]
[16,258.39999999999998,257.79000000000002,297.18,295.38,169.65,120.93,243.5]
[17,268.77,261.45999999999998,298.73,295.86,164.59,104.71,235.21]
[18,271.23,260.72000000000003,310.60000000000002,299.3,167.43,130.53,243.75,null,"AUTOR:","#ExcelPedroWave"]
[19,325.92,309.83,362.85,359.1,178.45,163.72999999999999,302.24,null,"BLOG:","Comparador interactivo con gráficos escalonados | #ExcelPedroWave"]
[20,340.65,328.61,405,387.79,206.71,204.77,332.24,null,"COPYRIGHT:","Creative Commons — Atribución-NoComercial-CompartirIgual 3.0 No portada"]
[21,361.8,356.12,418.49,410.82,256.64,281.14,382.49]
[22,366.25,358.24,428.98,423.98,286.58,332.16,412.94]
[23,309.93,309.05,384.98,380.13,304.92,384.06,384.52]
[24,292.87,282.86,379.63,372.88,293.12,376.31,372.82]
["Promedio",{"$f":"SUBTOTAL(101,TablaEscalones[14/06])","v":291.57291666666657},{"$f":"SUBTOTAL(101,TablaEscalones[15/06])","v":306.58958333333328},{"$f":"SUBTOTAL(101,TablaEscalones[16/06])","v":349.90041666666662},{"$f":"SUBTOTAL(101,TablaEscalones[17/06])","v":356.97666666666663},{"$f":"SUBTOTAL(101,TablaEscalones[18/06])","v":264.49708333333336},{"$f":"SUBTOTAL(101,TablaEscalones[19/06])","v":231.97500000000005},{"$f":"SUBTOTAL(101,TablaEscalones[20/06])","v":350.46083333333326}]
["Máximo",{"$f":"SUBTOTAL(104,TablaEscalones[14/06])","v":366.25},{"$f":"SUBTOTAL(104,TablaEscalones[15/06])","v":358.24},{"$f":"SUBTOTAL(104,TablaEscalones[16/06])","v":428.98},{"$f":"SUBTOTAL(104,TablaEscalones[17/06])","v":423.98},{"$f":"SUBTOTAL(104,TablaEscalones[18/06])","v":382.47},{"$f":"SUBTOTAL(104,TablaEscalones[19/06])","v":384.06},{"$f":"SUBTOTAL(104,TablaEscalones[20/06])","v":412.94}]
["Mínimo",{"$f":"SUBTOTAL(105,TablaEscalones[14/06])","v":244.74},{"$f":"SUBTOTAL(105,TablaEscalones[15/06])","v":257.79000000000002},{"$f":"SUBTOTAL(105,TablaEscalones[16/06])","v":294.85000000000002},{"$f":"SUBTOTAL(105,TablaEscalones[17/06])","v":295.38},{"$f":"SUBTOTAL(105,TablaEscalones[18/06])","v":164.59},{"$f":"SUBTOTAL(105,TablaEscalones[19/06])","v":104.71},{"$f":"SUBTOTAL(105,TablaEscalones[20/06])","v":235.21}]
["Leyenda\n(promedio)",{"$f":"B1 & IFERROR(\" (\" & ROUND(B26,0) & \")\",\"\")","v":"14/06 (292)"},{"$f":"C1 & IFERROR(\" (\" & ROUND(C26,0) & \")\",\"\")","v":"15/06 (307)"},"16/06 (350)","17/06 (357)","18/06 (264)","19/06 (232)","20/06 (350)"]
[]
["Fechas","Mínimo"]
[{"$f":"DATEVALUE(TablaEscalones[[#Headers],[14/06]])","v":"2022-06-14"},{"$f":"B28","v":244.74}]
[{"$f":"DATEVALUE(TablaEscalones[[#Headers],[15/06]])","v":"2022-06-15"},{"$f":"C28","v":257.79000000000002}]
[{"$f":"DATEVALUE(TablaEscalones[[#Headers],[16/06]])","v":"2022-06-16"},{"$f":"D28","v":294.85000000000002}]
[{"$f":"DATEVALUE(TablaEscalones[[#Headers],[17/06]])","v":"2022-06-17"},{"$f":"E28","v":295.38}]
[{"$f":"DATEVALUE(TablaEscalones[[#Headers],[18/06]])","v":"2022-06-18"},{"$f":"F28","v":164.59}]
[{"$f":"DATEVALUE(TablaEscalones[[#Headers],[19/06]])","v":"2022-06-19"},{"$f":"G28","v":104.71}]
[{"$f":"DATEVALUE(TablaEscalones[[#Headers],[20/06]])","v":"2022-06-20"},{"$f":"H28","v":235.21}]
[{"$f":"SUBTOTAL(103,TablaFechas[Fechas])","v":7},{"$f":"MIN(TablaFechas[Mínimo])","v":104.71}]
[]
[]
["Mín. eje",null,"Mínimo valor eje vertical:",{"$f":"ROUNDDOWN(SUBTOTAL(105,TablaFechas[Mínimo])/50,0)*50","v":100}]
[{"$f":"miPVPCmín","v":100}]
[{"$f":"IF(A43=0,0,A43-50)","v":50}]
[{"$f":"IF(A44=0,0,A44-50)","v":0}]
[0]
[0]
[0]
[0]
[{"$f":"SUBTOTAL(104,TablaMínEjeVertical[Mín. eje])","v":100}]