{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Raw Data","Haul Volume Reports","Haul Dashboard","Haul detail drill down"],"not_rendered":{"charts":9,"images":2,"macros":0,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Raw Data","index":0,"n_rows":76,"n_cols":22,"rows_kept":76,"cut":false,"hidden":false,"merged":[[64,1,64,4],[64,5,64,6],[32,4,32,6],[57,3,57,7],[58,4,58,6],[59,4,59,6],[61,4,61,6],[62,4,62,6]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"Plan Sequence"]
[]
[]
["Haul Name","Tag","Bal CY","Load CY","Cycles","C Time (s)","C Length (ft)","C Speed (fps)","Move Hours","Min/Hour",null,"Cost Hours"]
["Haul 1","Haul 1",28785.04,18,1599.1722222222222,202,2310,11.435643564356436,89.73133024691359,50,null,107.6775962962963]
["Haul 2","Haul 2",22112.16,18,1228.4555555555555,208,2462,11.836538461538462,70.97743209876543,50,null,85.17291851851853]
["Haul 3","Haul 3",50150.88,18,2786.161111111111,234,2900,12.393162393162394,181.1004722222222,50,null,217.32056666666665]
["Haul 4 stkpl","Haul 4 SP",20003.88,18,1111.3277777777778,304,4232,13.921052631578947,93.84545679012346,50,null,112.61454814814815]
[" "," ",121051.84,18,6725.116666666667,233.20887452592723,2899.8086955947065,12.434383989415108,435.6546913580247,50,null,522.7856296296296]
[]
[{"$nulls":17},"05:36:00","Moving time"]
[{"$nulls":5},"Track Record",{"$nulls":11},"00:45:00","Idle time"]
[]
[]
["Date","Tag","Wrk Hrs","Bal CY","Load CY","Cycles","C Time (s)","C Length (ft)","C Speed (fps)","Move Hours","Idle Hours","Min/Hour","Cost Hours","UAV BCY","Tracked Volume","Planned Cut","Planned Fill",null,null,"Cycles","C Time (s)","C Length (ft)"]
["06-22-2015","Haul 1","8:00",13211,17.8,741,199,2252,11.316582914572864,41.1,7,51.2,48.1,0,13211,2866.6000000000004,2345.4,5212,null,741,199,2252]
["06-23-2015","Haul 1","8:00",10049,16.7,602,207,2371,11.454106280193237,34.6,8.399999999999999,49.7,43,11590.59,23260,5548.2075,4539.4425,10087.65,null,1343,203,2311.5]
["06-24-2015","Haul 2","8:00",11785,17.7,665,261,2953,11.314176245210728,48.4,7.600000000000001,51.8,56,23181.18,35045,11096.415,9078.885,20175.3,null,2008,222.33333333333334,2525.3333333333335]
["06-25-2015","Haul 2","8:00",10841,17.9,607,238,2511,10.550420168067227,40.1,8,50.1,48.1,35123,45886,16644.6225,13618.3275,30262.949999999997,null,2615,226.25,2521.75]
["06-26-2015","Haul 3","8:00",9358,18.3,512,224,2493,11.129464285714286,31.8,5.199999999999999,51.9,37,53273,55244,22697.212499999998,22697.212499999998,45394.424999999996,null,3127,225.8,2516]
["06-29-2015","Haul 3","10:00",16258,19.8,823,230,2685,11.673913043478262,52.6,12.399999999999999,48.6,65,89573,71502,27741.0375,27741.0375,55482.075,null,3950,226.5,2544.1666666666665]
["06-30-2015","Haul 3","8:00",12033,18.8,639,223,2602,11.668161434977579,39.7,8.299999999999997,50,48,90123,83535,30262.949999999997,30262.949999999997,60525.899999999994,null,4589,226,2552.4285714285716]
["07-01-2015","Haul 3","8:00",8514,18,472,322,3978,12.354037267080745,42.2,5.799999999999997,53,48,95032.41,92049,35306.775,35306.775,70613.55,null,5061,238,2730.625]
["07-02-2015","Haul 4 SP","8:00",11316,18.7,605,307,3930,12.80130293159609,51.6,12.399999999999999,48.3,64,99754.82,103365,38605.43655,51174.64845,89780.085,null,5666,245.66666666666666,2863.8888888888887]
["07-06-2015","Haul 4 SP","8:00",10963,18.8,582,318,3514,11.050314465408805,51.4,9.600000000000001,50.4,61,105000,114328,42943.12605,56924.608949999994,99867.735,null,6248,252.9,2928.9]
["07-07-2015","Haul 1","8:00",3721,15.7,237,319,3666,11.492163009404388,21,3,52.5,24,113290.59,118049,44678.20185,59224.59314999999,103902.795,null,6485,258.90909090909093,2995.909090909091]
["07-08-2015","Haul 1","8:00",3376,15.7,215,244,2651,10.864754098360656,14.6,1.4000000000000004,54.7,16,121581.18,121425,47714.5845,63249.56549999999,110964.15,null,6700,257.6666666666667,2967.1666666666665]
["07-09-2015","Haul 1","6:00",455,15.7,29,329,3159,9.601823708206688,2.6,2.4,31.8,5,130123,121880,52052.2912,68999.54879999999,121051.84,null,6729,263.15384615384613,2981.923076923077]
["Totals"," "," ",121880,18.109674543022738,6729,252.18873532471392,2907.3676623569622,11.528538967505765,471.7,91.5,50.517521176995096,563.2]
[]
[]
[]
[{"$nulls":4},"Plan Vs. Track (Totals)"]
[]
[]
[null,"Tag","Bal CY","Load CY","Cycles","C Time (s)","C Length (ft)","C Speed (fps)","Move Hours","Min/Hour",null,"Cost Hours"]
["Plan Total","Haul 1",28785.04,18,1599.1722222222222,202,2310,11.435643564356436,89.73133024691359,50,null,107.6775962962963]
["Track Total","Haul 1",30812,16.883168859649125,1824,224.60361842105263,2536.4539473684213,11.293023528291801,113.9,50.21307861866275,null,136.1]
[" "," ",1.07,0.9390000000000001,1.141,1.114,1.0979999999999999,0.991,1.27,1,null,1.264]
[]
["Plan Total","Haul 2",22112.16,18,1228.4555555555555,208,2462,11.836538461538462,70.97743209876543,50,null,85.17291851851853]
["Track Total","Haul 2",22626,17.795440251572327,1272,250.0243710691824,2742.077044025157,10.967239042734828,88.5,51.00864553314121,null,104.1]
[" "," ",1.023,0.9890000000000001,1.036,1.202,1.114,0.932,1.246,1.02,null,1.222]
[]
["Plan Total","Haul 3",50150.88,18,2786.161111111111,234,2900,12.393162393162394,181.1004722222222,50,null,217.32056666666665]
["Track Total","Haul 3",46163,18.87743254292723,2446,244.66843826655764,2872.634914145544,11.740929620909704,166.3,50.39393939393939,null,198]
[" "," ",0.92,1.05,0.878,1.047,0.991,0.9440000000000001,0.9179999999999999,1,null,0.9109999999999999]
[]
["Plan Total","Haul 4 SP",20003.88,18,1111.3277777777778,304,4232,13.921052631578947,93.84545679012346,50,null,112.61454814814815]
["Track Total","Haul 4 SP",22279,18.749031171019375,1187,312.39342881213145,3726.0303285593936,11.927364614318344,103,49.44,null,125]
[" "," ",1.114,1.0390000000000001,1.068,1.026,0.88,0.856,1.0979999999999999,0.98,null,1.11]
[]
["Total Plan"," ",121051.84,18.002989292088042,6724,233.20791195716836,2899.788518738846,12.43434879375546,435.6546913580247,50,null,522.7856296296296]
["Total Track"," ",121880,18.109674543022738,6729,252.18873532471392,2907.3676623569622,11.528538967505765,471.7,50.517521176995096,null,563.2]
[" "," ",1.0070000000000001,1.006,1.001,1.082,1.002,0.927,1.083,1.02,null,1.077]
[]
[]
[null,null,null,"Job: 03_Trilogy Hauls Tracked"]
[{"$nulls":4},"Units: Ft-CY"]
[{"$nulls":4},"Tue Dec 18, 2018 16:28:55"]
[]
[{"$nulls":4},"Haul Report"]
[{"$nulls":4},"      Design vs. Existing      "]
[]
[null,"Area",null,null,null,"Volume",null,"Fill  ","Haul","Average",null,"Export"]
[null,"Total","Cut","Fill","OnGrade","Cut","Fill","Factor","Distance","Slope  ",null,"-Import"]
["Haul 1",517692,198866,296061,22765,28986,24972,1,258,-0.015,null,4014]
["Haul 2",671424,314095,325350,31979,22310,19232,1,264,0.012,null,3078]
["Haul 3",754712,284497,456838,13377,70158,43769,1,353,0.033,null,26389]
["Haul 4 stkpl",579085,293567,265069,20449,null,33078,1.15,887,0.02,null,28278]
[]
["Regions Total",2522913,1091025,1343318,88570,121454,121051,null,432,0.015,null,61759]
[]
[{"$nulls":5},"Cut ",121454]
[{"$nulls":5},"Fill",87973]
[{"$nulls":5},"Stockpile",33078]

{"sheet":"Haul Volume Reports","index":1,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,9]],"flags":["formulas_cached_only"]}
["Haulage Volume report"]
{"$rows_empty":34}
["Should be able to switch secondary axis between C Time, C Length and No. of Cycles"]

{"sheet":"Haul Dashboard","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,10,31,11],[34,1,34,2],[34,7,34,8],[32,10,32,11],[34,10,34,11],[34,4,34,5],[31,1,31,2],[31,4,31,5],[31,7,31,8],[34,13,34,14],[34,16,34,17],[0,8,0,10]],"flags":["formulas_cached_only"]}
[{"$nulls":7},"Date: ","2018-12-12"]
{"$rows_empty":30}
[null,"Quantity Moved",null,null,"Projected Quantity",null,null,"Planned",null,null,"No. of Cycles"]
[null,3023,"CY",null,5013,"CY",null,5212,"CY",null,542]
[]
[null,"Av. Cycle Length",null,null,"Av. Cycle Time",null,null,"Av. Speed",null,null,"Cost Hours",null,null,"Moving Hours",null,null,"Idle hours"]
[null,2525,"ft",null,"03:46:00","m",null,12,"mph",null,"06:21:00","hr",null,"05:36:00","hr",null,"00:45:00","hr"]

{"sheet":"Haul detail drill down","index":3,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,4,0,6]],"flags":["formulas_cached_only"]}
[null,null,null,"Date: ","2018-12-12"]
{"$rows_empty":17}
["Should be able to select date range and switch secondary axis between C Time, C Length and No. of Cycles"]
{"$rows_empty":37}
["Other useful charts from M20 data analysis"]