{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BD","SUMA DE TONELAJE","DATOS","DENS","DOMINIO"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"BD","index":0,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["PERIODO","BANCO","POLIGONO ","VOLUMEN","DENCIDAD","FASE","CODIGO","TONELADA "]
["2020-07-01",4216,495,36.36,2.8,"F1",82.04,{"$f":"D2*E2","v":101.80799999999999}]
["2020-07-01",4216,496,10.68,2.8,"F1",71.84,29.903999999999996]
["2020-07-01",4336,500,898.58,2.8,"F3",39.24,2516.0239999999999,null,"La columna B.C,F,G y H"]
["2020-07-02",4216,495,1523.5,2.8,"F1",82.04,4265.8]
["2020-07-02",4216,496,99,2.8,"F1",71.84,277.2]
["2020-07-02",4216,497,49.39,2.8,"F1",109.05,138.292]
["2020-07-02",4336,500,122.95,2.8,"F3",39.24,344.26]
["2020-07-02",4336,501,126.28,2.8,"F3",26.93,353.584]
["2020-07-03",4216,495,678,2.8,"F1",82.04,1898.3999999999999]
["2020-07-03",4216,496,310.93392857142857,2.8,"F1",71.84,870.6149999999999]
["2020-07-03",4216,497,13.035714285714286,2.8,"F1",109.05,36.5]
["2020-07-03",4216,499,169.46428571428572,2.8,"F1",35.130000000000003,474.5]
["2020-07-03",4216,522,169.46428571428572,2.8,"F1",31.34,474.5]
["2020-07-03",4336,501,117.32142857142858,2.8,"F3",26.93,328.5]
["2020-07-04",4216,495,415.43,2.8,"F1",82.04,1163.204]
["2020-07-04",4216,496,437.32,2.8,"F1",71.84,1224.4959999999999]
["2020-07-04",4216,497,32.200000000000003,2.8,"F1",109.05,90.16]
["2020-07-04",4216,522,204.40799999999999,2.8,"F1",31.34,572.34239999999988]
["2020-07-05",4216,451,6.32,2.8,"F1",43.31,17.695999999999998]
["2020-07-05",4216,495,345.19,2.8,"F1",82.04,966.53199999999993]
["2020-07-05",4216,497,739.33,2.8,"F1",109.05,2070.1239999999998]
["2020-07-05",4210,507,92.39,2.8,"F1",23.79,258.69200000000001]
["2020-07-06",4336,490,612.29999999999995,2.8,"F2",56.92,1714.4399999999998]
["2020-07-06",4216,495,244.47,2.8,"F1",82.04,684.51599999999996]
["2020-07-06",4216,497,185.7,2.8,"F1",109.05,519.95999999999992]
["2020-07-06",4216,499,11.92,2.8,"F1",35.130000000000003,33.375999999999998]
["2020-07-06",4216,502,30.49,2.8,"F1",130.13,85.371999999999986]
["2020-07-06",4210,504,49.98,2.8,"F1",22.78,139.94399999999999]
["2020-07-06",4210,506,194.79,2.8,"F1",49.75,545.41199999999992]
["2020-07-06",4210,508,154.01,2.8,"F1",111.35,431.22799999999995]
["2020-07-07",4336,490,110,2.8,"F2",56.92,308]
["2020-07-06",4216,497,78,2.8,"F1",109.05,218.39999999999998]
["2020-07-07",4216,499,321,2.8,"F1",35.130000000000003,{"$f":"D34*E34","v":898.8}]
["2020-07-07",4210,504,74.98,2.8,"F1",22.78,209.94399999999999]
["2020-07-07",4210,506,303.5,2.8,"F1",49.75,849.8]
["2020-07-07",4210,508,813.69,2.8,"F1",111.35,2278.3319999999999]
["2020-07-08",4216,499,142.97999999999999,2.8,"F1",35.130000000000003,400.34399999999994]
["2020-07-08",4216,502,92.57,2.8,"F1",130.13,259.19599999999997]
["2020-07-08",4216,498,229.97,2.8,"F1",34.72,643.91599999999994]
["2020-07-08",4210,508,844.67000000000007,2.8,"F1",111.35,2365.076]
["2020-07-08",4210,503,52.67,2.8,"F1",58.47,147.476]
["2020-07-08",4210,504,32.409999999999997,2.8,"F1",22.78,90.74799999999999]
["2020-07-08",4216,453,92.15,2.8,"F1",96.35,258.02]
["2020-07-09",4336,490,388.08,2.8,"F2",56.92,1086.6239999999998]
["2020-07-09",4216,497,361.25,2.8,"F1",109.05,1011.4999999999999]
["2020-07-09",4216,499,157.65,2.8,"F1",35.130000000000003,441.42]
["2020-07-09",4210,504,32.699999999999996,2.8,"F1",22.78,91.559999999999988]
["2020-07-09",4210,508,134.16999999999999,2.8,"F1",111.35,375.67599999999993]
["2020-07-09",4216,502,134.22999999999999,2.8,"F1",130.13,375.84399999999994]
["2020-07-09",4216,498,293.05,2.8,"F1",34.72,820.54]
["2020-07-09",4210,515,46.35,2.8,"F1",75.400000000000006,{"$f":"D52*E52","v":129.78},null,"Copiar en la siguiente hoja por periodo (SUMA DE TONELAJE)"]
[]
[null,null,null,null,null,null,null,null,"FACTOR"]
[null,null,null,null,null,null,null,null,"> = 55","Purpura"]
[null,null,null,null,null,null,null,null,"46-55","Rojo"]
[null,null,null,null,null,null,null,null,"31-45","Verde"]
[null,null,null,null,null,null,null,null,"17-30","Celeste"]

{"sheet":"SUMA DE TONELAJE","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["POLIGONO ","BANCO","FASE","CODIGO"," Stock Materiales TN",null,"FACTOR","TOTAL  TN","M3","CODIGO PROMEDIO"]
[4216,495,"F1",82.04,101.80799999999999,null,"MUY ALTA ",{"$f":"SUM(E2:E31)","v":25382.474999999995},{"$f":"H2/2.8","v":9065.1696428571413},{"$f":"AVERAGE(D2:D31)","v":92.657333333333327}]
[4216,496,"F1",71.84,29.903999999999996,null,"BUENA ",{"$f":"SUM(E32:E33)","v":1395.212},{"$f":"H3/2.8","v":498.29},{"$f":"AVERAGE(D32:D33)","v":49.75}]
[4216,495,"F1",82.04,4265.8,null,"MEDIANA ",{"$f":"SUM(E34:E45)","v":7637.7183999999997},2727.7565714285715,{"$f":"AVERAGE(D34:D45)","v":35.796666666666674}]
[4216,496,"F1",71.84,277.2,null,"BAJA",{"$f":"SUM(E46:E52)","v":1472.972},526.06142857142856,{"$f":"AVERAGE(D46:D52)","v":24.110000000000003}]
[4216,497,"F1",109.05,138.292,null,null,{"$f":"SUM(H2:H5)","v":35888.377399999998},{"$f":"SUM(I2:I5)","v":12817.277642857143}]
[4216,495,"F1",82.04,1898.3999999999999]
[4216,496,"F1",71.84,870.6149999999999,null,"Los calculos de debe ser automaticas"]
[4216,497,"F1",109.05,36.5]
[4216,495,"F1",82.04,1163.204]
[4216,496,"F1",71.84,1224.4959999999999]
[4216,497,"F1",109.05,90.16]
[4216,495,"F1",82.04,966.53199999999993]
[4216,497,"F1",109.05,2070.1239999999998]
[4336,490,"F2",56.92,1714.4399999999998,null,"Aquí se debe ordenar por color y  periodo fechas formar un pequeño cuadro para vincular a un documento a informar como el de arriba"]
[4216,495,"F1",82.04,684.51599999999996,null,"si es posible aquí no debe figurar los calculos solo numeros y nadie puede cambiar los resultados"]
[4216,497,"F1",109.05,519.95999999999992,null,"si esto se visualizara en formulario con sus respectivos colores"]
[4216,502,"F1",130.13,85.371999999999986]
[4210,508,"F1",111.35,431.22799999999995]
[4336,490,"F2",56.92,308]
[4216,497,"F1",109.05,218.39999999999998]
[4210,508,"F1",111.35,2278.3319999999999]
[4216,502,"F1",130.13,259.19599999999997]
[4210,508,"F1",111.35,2365.076]
[4210,503,"F1",58.47,147.476]
[4216,453,"F1",96.35,258.02]
[4336,490,"F2",56.92,1086.6239999999998]
[4216,497,"F1",109.05,1011.4999999999999]
[4210,508,"F1",111.35,375.67599999999993]
[4216,502,"F1",130.13,375.84399999999994]
[4210,515,"F1",75.400000000000006,129.78]
[4210,506,"F1",49.75,545.41199999999992]
[4210,506,"F1",49.75,849.8]
[4336,500,"F3",39.24,2516.0239999999999]
[4336,500,"F3",39.24,344.26]
[4216,499,"F1",35.130000000000003,474.5]
[4216,522,"F1",31.34,474.5]
[4216,522,"F1",31.34,572.34239999999988]
[4216,451,"F1",43.31,17.695999999999998]
[4216,499,"F1",35.130000000000003,33.375999999999998]
[4216,499,"F1",35.130000000000003,898.8]
[4216,499,"F1",35.130000000000003,400.34399999999994]
[4216,498,"F1",34.72,643.91599999999994]
[4216,499,"F1",35.130000000000003,441.42]
[4216,498,"F1",34.72,820.54]
[4336,501,"F3",26.93,353.584]
[4336,501,"F3",26.93,328.5]
[4210,507,"F1",23.79,258.69200000000001]
[4210,504,"F1",22.78,139.94399999999999]
[4210,504,"F1",22.78,209.94399999999999]
[4210,504,"F1",22.78,90.74799999999999]
[4210,504,"F1",22.78,91.559999999999988]
["TOTAL",null,null,null,{"$f":"SUM(E2:E52)","v":35888.377400000005}]

{"sheet":"DATOS","index":2,"n_rows":104,"n_cols":7,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["RESPONSABLE","BANCO","POLIGONAL","MATERIAL","DENCIDAD","FASE","CODIGO"]
["FREDY CAYO",4222,426,"ARENA",1.62,"F1","> = 55"]
[null,4336,427,"DESMONTE",1.8,"F2","46-55"]
[null,4210,430,null,1.9,"F3","31-45"]
[null,null,441,null,2.8,null,"17-30"]
[null,null,446]
[null,null,447]
[null,null,448]
[null,null,449]
[null,null,450]
[null,null,451]
[null,null,452]
[null,null,454]
[null,null,455]
[null,null,460]
[null,null,461]
[null,null,462]
[null,null,485]
[null,null,486]
[null,null,451]
[null,null,452]
[null,null,453]
[null,null,490]
[null,null,491]
[null,null,492]
[null,null,493]
[null,null,495]
[null,null,496]
[null,null,497]
[null,null,498]
[null,null,499]
[null,null,502]
[null,null,503]
[null,null,504]
[null,null,505]
[null,null,506]
[null,null,507]
[null,null,508]
[null,null,509]
[null,null,510]
[null,null,511]
[null,null,512]
[null,null,513]
[null,null,514]
[null,null,515]
[null,null,516]
[null,null,517]
[null,null,518]
[null,null,519]
[null,null,520]
[null,null,521]
[null,null,522]
[null,null,523]
[null,null,524]
[null,null,525]
[null,null,495]
[null,null,496]
[null,null,494]
[null,null,495]
[null,null,496]
[null,null,497]
[null,null,494]
[null,null,495]
[null,null,496]
[null,null,497]
[null,null,499]
[null,null,522]
[null,null,495]
[null,null,496]
[null,null,497]
[null,null,522]
[null,null,451]
[null,null,495]
[null,null,497]
[null,null,507]
[null,null,490]
[null,null,495]
[null,null,497]
[null,null,499]
[null,null,502]
[null,null,504]
[null,null,506]
[null,null,508]
[null,null,490]
[null,null,497]
[null,null,499]
[null,null,504]
[null,null,506]
[null,null,508]
[null,null,499]
[null,null,502]
[null,null,498]
[null,null,508]
[null,null,503]
[null,null,504]
[null,null,453]
[null,null,490]
[null,null,497]
[null,null,499]
[null,null,504]
[null,null,508]
[null,null,502]
[null,null,498]
[null,null,515]

{"sheet":"DENS","index":3,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Nivel","Stope","Dens Min"]
[3420,17,3.34,null,null,null,"OB17",3.4833333333333329]
[4218,15,3.34]
[3540,22,3.34]
[3420,55,3.47,null,null,null,"OBA",3.2283333333333335]
[4154,87,3.34,null,null,null,"VT",3.2266666666666666]
[3420,101,3.59,null,null,null,"OB13",3.6973333333333334]
[3420,102,3.59,null,null,null,"OB13R4",3.5433333333333334]
[3420,103,3.59,null,null,null,"OBSB",3.3441666666666667]
[3480,195,3.54,null,null,null,"OB13B",4.0705882352941174]
[3540,366,3.54]
[3600,299,3.23]
[3180,327,3.54,null,null,null,"OBPRVS",3.5925000000000002]
[3180,"Rpa 110S",3.54,null,null,null,"VSG",3.5483333333333333,null,null,null,null,null,null,null,null,null,null,null,6000,3.34,{"$f":"+T14*U14","v":20040}]
[3180,325,3.54,null,null,null,"OBCNE",3.5479999999999996,null,null,null,null,null,null,null,null,null,null,null,6000,3.6,{"$f":"+T15*U15","v":21600}]
[3180,331,3.33,null,null,null,"VRP",2.8,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+V15-V14","v":1560}]
[3120,406,4.07,null,null,null,"OBDF",3.4733333333333332,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T17*U17","v":0}]
[3060,407,4.07,null,null,null,"OB13R6",3.3264999999999993,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T18*U18","v":0}]
[3420,"Rpa. 7937 E",3.47,null,null,null,"OB23",3.5125000000000002,null,null,null,null,null,null,null,null,null,null,null,10000,3.55,{"$f":"+T19*U19","v":35500}]
[3060,438,3.7,null,null,null,"VI",3.1579999999999999,null,null,null,null,null,null,null,null,null,null,null,10000,2.75,{"$f":"+T20*U20","v":27500}]
[3120,443,3.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+V20-V19","v":-8000}]
[3480,"Gal 187N",3.7]
[3180,444,3.7]
[3000,"OB13B_3000",4.07]
[3120,489,4.07]
[3120,658,3.55]
[3180,659,3.55]
[4050,695,3.55]
[4050,917,3.43]
[4050,617,3.16]
[4154,911,3.16]
[4050,"Gal. 498 N",3.55]
[3540,996,3.48]
[3420,"OBC_3420",3.48]
[3000,"OB13BSK_3000",4.07]
[3540,"OB13_3540",3.7]
[3420,"OB15_3420",3.43]
[3420,"OBSB_3420",3.34]

{"sheet":"DOMINIO","index":4,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
["Atacocha","DOM1","OB_13_R4"]
[null,null,"OB_13_R6"]
[null,null,"OB_13_R7"]
[null,null,"OB_25"]
[null,"DOM2","OB_13"]
[null,null,"OB_13_B"]
[null,null,"OB_13_BSKN"]
[null,null,"OB_13_C"]
[null,null,"OB_9"]
[null,null,"V_P "]
[null,null,"V_R_P"]
[null,null,"V_PR"]
["Total Atacocha"]
["San gerardo","DOM3","OB_10"]
[null,null,"OB_12"]
[null,null,"OB_15"]
[null,null,"OB_17"]
[null,null,"OB_18"]
[null,null,"OB_23"]
[null,null,"OB_AD"]
[null,null,"OB_CR"]
[null,null,"V_CH"]
[null,null,"V_I"]
[null,null,"V_INT"]
[null,null,"V_K"]
[null,null,"V_L"]
[null,null,"V_LIND"]
[null,null,"V_SG"]
[null,null,"V_T"]
["Total San gerardo"]
["Santa_Barbara","DOM4","OB_A"]
[null,null,"OB_CNE"]
[null,null,"OB_DF"]
[null,null,"OB_M"]
[null,null,"OB_PRVS"]
[null,null,"OB_SB"]
[null,null,"OB_SP"]
[null,null,"OB_V"]
[null,null,"OB_C "]