{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Lab Results","Surface","Dist Chart","readme"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Dist Chart","index":2,"reason":"not_a_worksheet"}],"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":"Lab Results","index":0,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%Finer Lab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38.1,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.125,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.25E-2,0.4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D16",{"$f":"+Dsize(Q$2:Q$12,R$2:R$12,16)","v":1.2599210498948732},null,16,{"$f":"10^(FORECAST(T14,LOG(OFFSET(Q$2:Q$12,MATCH(T14,R$2:R$12,-1)-1,0,2)),OFFSET(R$2:R$12,MATCH(T14,R$2:R$12,-1)-1,0,2)))","v":1.2599210498948734}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D50",{"$f":"+Dsize(Q$2:Q$12,R$2:R$12,50)","v":17.716955716898482},null,50,{"$f":"10^(FORECAST(T15,LOG(OFFSET(Q$2:Q$12,MATCH(T15,R$2:R$12,-1)-1,0,2)),OFFSET(R$2:R$12,MATCH(T15,R$2:R$12,-1)-1,0,2)))","v":17.7169557168985}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D84",{"$f":"+Dsize(Q$2:Q$12,R$2:R$12,84)","v":33.357357878506853},null,84,{"$f":"10^(FORECAST(T16,LOG(OFFSET(Q$2:Q$12,MATCH(T16,R$2:R$12,-1)-1,0,2)),OFFSET(R$2:R$12,MATCH(T16,R$2:R$12,-1)-1,0,2)))","v":33.357357878506875}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D90",{"$f":"+Dsize(Q$2:Q$12,R$2:R$12,90)","v":35.062400293269917},null,90,{"$f":"10^(FORECAST(T17,LOG(OFFSET(Q$2:Q$12,MATCH(T17,R$2:R$12,-1)-1,0,2)),OFFSET(R$2:R$12,MATCH(T17,R$2:R$12,-1)-1,0,2)))","v":35.062400293269945}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gr",{"$f":"0.5*(R17/R16+R16/R15)","v":1.4669536505468994}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%Gravel",{"$f":"100-R7","v":82}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%Sand",{"$f":"+R7-R12","v":17.600000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%Silt/Clay",{"$f":"+R12","v":0.4}]

{"sheet":"Surface","index":1,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":false,"merged":[[33,6,33,7],[33,20,33,21],[33,25,33,27],[29,2,29,7],[29,9,29,14],[29,16,29,21],[29,24,29,31],[32,6,32,7],[32,13,32,14],[32,20,32,21],[32,25,32,27],[30,6,30,7],[30,13,30,14],[30,20,30,21],[31,6,31,7],[31,13,31,14],[31,20,31,21],[26,2,26,5],[26,9,26,12],[26,16,26,19],[26,24,26,31],[28,24,28,31],[27,2,27,5],[27,9,27,12],[27,16,27,19],[27,24,27,31],[23,2,23,5],[23,9,23,12],[23,16,23,19],[23,24,23,31],[24,2,24,5],[24,9,24,12],[24,16,24,19],[24,24,24,31],[25,2,25,5],[25,9,25,12],[25,16,25,19],[25,24,25,31],[21,2,21,5],[21,9,21,12],[21,16,21,19],[21,24,21,31],[22,2,22,5],[22,9,22,12],[22,16,22,19],[22,24,22,31],[19,2,19,5],[19,9,19,12],[19,16,19,19],[19,24,19,31],[20,2,20,5],[20,9,20,12],[20,16,20,19],[20,24,20,31],[18,2,18,5],[18,9,18,12],[18,16,18,19],[18,24,18,31],[15,2,15,5],[15,9,15,12],[15,16,15,19],[16,2,16,5],[16,9,16,12],[16,16,16,19],[16,24,16,31],[17,2,17,5],[17,9,17,12],[17,16,17,19],[17,24,17,31],[13,2,13,5],[13,9,13,12],[13,16,13,19],[14,2,14,5],[14,9,14,12],[14,16,14,19],[11,2,11,5],[11,9,11,12],[11,16,11,19],[12,2,12,5],[12,9,12,12],[12,16,12,19],[1,1,1,21],[1,23,1,30],[9,2,9,7],[10,2,10,5],[10,9,10,12],[10,16,10,19]]}
[]
[null,"Pebble Count Data Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pebble Count Data Sheet"]
[]
[null,"River / Tributary:",null,"Deshka",null,null,null,null,null,null,"Crew:","MH, BF",null,null,null,null,null,null,null,null,null,null,null,"River / Tributary:","Deshka",null,"  Crew:","WTF, MDH"]
[null,"Site: ",null,"U/S of X-sec 10",null,null,null,null,null,null,"PRM: ","NA",null,null,null,null,null,null,null,null,null,null,null,"Site: ","Multiple",null,"  PRM: ","NA"]
[null,"Date / Time:",null,"2013-09-26",null,null,null,null,null,null,"Length & Interval:",null,"Random",null,null,null,null,null,null,null,null,null,null,"Date / Time:","98/26/2013","11 a.m.-5 p.m.","Field Book #","MDH-2"]
[null,"Field Book #",null,null,null,null,null,null,null,null,"Comments:",null,"These are at three locations, see waypoints",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waypoint(s):","PC-1/008"]
[null,"Waypoint(s):",null,"MDH Waypoint 008 (see below, one per site)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Comments"]
[null,"Photo(s) #",null,"MDH-See back",null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PC-1 is at split flow island on RH channel, inside of bend (against island)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bar fines in D?S direction, Dmaz~90 mm"]
[null,"Size (mm)","PC-1 WP 8",null,null,null,"Sum","Cum % ","Size (mm)","PC-2 WP 13",null,null,null,"Sum","Cum % ","Size (mm)","PC-3 WP 37",null,null,null,"Sum","Cum % ","Cum Ave"]
[null,"< 2",null,null,null,null,null,null,"< 2","Took Bulk sample Deshka-3 SS-3",null,null,null,null,{"$f":"N12","v":0},"< 2"]
[null,2,null,null,null,null,null,null,2,"(note: took sand bed material Deshka ",null,null,null,null,0,2,null,null,null,null,null,null,{"$f":"AVERAGE(V13,O13,H13)","v":0}]
[null,2.8,null,null,null,null,null,null,2.8,"at WP 12)",null,null,null,null,{"$f":"100*N13/SUM(N$13:N$28)","v":0},2.8,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,{"$f":"100*N14/SUM(N$13:N$28)+O14","v":0},4,null,null,null,null,null,null,0]
[null,5.6,null,null,null,null,null,null,5.6,null,null,null,null,null,{"$f":"100*N15/SUM(N$13:N$28)+O15","v":0},5.6,null,null,null,null,null,null,0,"Photo Log"]
[null,8,null,null,null,null,null,null,8,null,null,null,null,null,0,8,null,null,null,null,null,null,0,"Photo #","Description"]
[null,11,null,null,null,null,null,null,11,null,null,null,null,6,0,11,null,null,null,null,null,null,0,null,"MDH Nikon"]
[null,16,null,null,null,null,null,null,16,null,null,null,null,7,6,16,null,null,null,null,null,null,6,687,"Surface at PC-1, Deshka, WP 008"]
[null,22.5,null,null,null,null,null,null,22.5,null,null,null,null,21,13,22.5,null,null,null,null,null,null,13,688,"Overview of bar looking U/S PC-1/SS-1"]
[null,32,null,null,null,null,null,null,32,null,null,null,null,40,{"$f":"100*N20/SUM(N$13:N$28)+O20","v":34},32,null,null,null,null,null,null,34,689,"Hole for SS-1 D-1"]
[null,45,null,null,null,null,null,null,45,null,null,null,null,25,74,45,null,null,null,null,null,null,74,5699,"Surface at PC-2, Deshka, WP 13"]
[null,64,null,null,null,null,null,null,64,null,null,null,null,1,99,64,null,null,null,null,null,null,99,5700,"Overview of bar looking U/S PC-2/SS-3(D-3)"]
[null,90,null,null,null,null,null,null,90,null,null,null,null,null,100,90,null,null,null,null,null,null,100,5701,"Hole for SS-3/D-3"]
[null,128,null,null,null,null,null,null,128,null,null,null,null,null,100,128,null,null,null,null,null,null,100,5715,"Surface PC-3/Des"]
[null,180,null,null,null,null,null,null,180,null,null,null,null,null,100,180,null,null,null,null,null,null,{"$f":"AVERAGE(H26,V26,O26)","v":100},5716,"Overview of bar looking U/S PC-3/ SS-7 (D7) WP 37"]
[null,256,null,null,null,null,null,null,256,null,null,null,null,null,100,256,null,null,null,null,null,null,{"$f":"AVERAGE(H27,V27,O27)","v":100},5717,"Hole for SS-/D-"]
[null,360,null,null,null,null,null,null,360,null,null,null,null,null,{"$f":"100*N27/SUM(N$13:N$28)+O27","v":100},360,null,null,null,null,null,null,{"$f":"AVERAGE(V28,O28,H28)","v":100}]
[]
[null,null,"LEFT  COUNT",null,null,null,null,null,null,"CENTER  COUNT",null,null,null,null,null,null,"RIGHT  COUNT"]
[]
[]
[]
[]
[null,"QC1______________","RAV",null,null,null,null,null,null,null,"Photo Backup_____________","TT cam 2- 343",null,null,null,null,null,null,null,null,null,"Page ____1_ of _2_____",null,"QC1_______RAV______",null,null,"Photo Backup_____________","TT cam 2- 344",null,null,null,"Page ____2_ of ___2__"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average"]
[null,null,null,null,"D%","Size (mm)",null,null,null,null,null,"D%","Size (mm)",null,null,null,null,null,"D%","Size (mm)",null,null,"Size (mm)"]
[null,null,null,null,16,null,null,null,null,null,null,16,{"$f":"10^(FORECAST(L40,LOG(OFFSET(I$13:I$28,MATCH(L40,O$13:O$28,1)-1,0,2)),OFFSET(O$13:O$28,MATCH(L40,O$13:O$28,1)-1,0,2)))","v":23.661104434727164},null,null,null,null,null,16,null,null,null,{"$f":"10^(FORECAST(S40,LOG(OFFSET(P$13:P$28,MATCH(S40,W$13:W$28,1)-1,0,2)),OFFSET(W$13:W$28,MATCH(S40,W$13:W$28,1)-1,0,2)))","v":23.661104434727164}]
[null,null,null,null,50,null,null,null,null,null,null,50,{"$f":"10^(FORECAST(L41,LOG(OFFSET(I$13:I$28,MATCH(L41,O$13:O$28,1)-1,0,2)),OFFSET(O$13:O$28,MATCH(L41,O$13:O$28,1)-1,0,2)))","v":36.675411259579192},null,null,null,null,null,50,null,null,null,{"$f":"10^(FORECAST(S41,LOG(OFFSET(P$13:P$28,MATCH(S41,W$13:W$28,1)-1,0,2)),OFFSET(W$13:W$28,MATCH(S41,W$13:W$28,1)-1,0,2)))","v":36.675411259579192}]
[null,null,null,null,84,null,null,null,null,null,null,84,51.808318605198686,null,null,null,null,null,84,null,null,null,51.808318605198686]
[null,null,null,null,90,null,null,null,null,null,null,90,{"$f":"10^(FORECAST(L43,LOG(OFFSET(I$13:I$28,MATCH(L43,O$13:O$28,1)-1,0,2)),OFFSET(O$13:O$28,MATCH(L43,O$13:O$28,1)-1,0,2)))","v":56.378262619648879},null,null,null,null,null,90,null,null,null,56.378262619648879]
[]
[null,null,null,null,"Gr",null,null,null,null,null,null,"Gr",{"$f":"0.5*(M42/M41+M41/M40)","v":1.4813234043524894},null,null,null,null,null,"Gr",null,null,null,{"$f":"0.5*(W42/W41+W41/W40)","v":1.4813234043524894}]
[null,null,null,null,"%Sand",null,null,null,null,null,null,"%Sand",{"$f":"O12","v":0},null,null,null,null,null,"%Sand",null,null,null,{"$f":"AVERAGE(T46,M46,F46)","v":0}]

{"sheet":"readme","index":3,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Sheets:"]
[]
["Lab Results—Image of lab results from bulk sample"]
[]
["Surface—Electronic version of pages 1 and 2 of Field Pebble Count data sheet as described in ISR study 6.6 section 4.1.2.9.  Additional data included in cells E38:W47 show calculation of significant grain sizes and percent of sand, gravel and silt."]
[]
["Dist Chart—Sediment distribution curves for surface and subsurface samples"]