{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["intro","data","x-sec graph","calcs","segments"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"x-sec graph","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":"intro","index":0,"n_rows":123,"n_cols":7,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[]
["Welcome to the xsecAnalyzer."]
[null,"This tool enables you to examine stream"]
[null,"or river cross-sections and determine"]
[null,"hydraulic parameters, such as flow area,"]
[null,"discharge, and average velocity."]
[]
[null,"The screenshot at right shows the data"]
[null,"entry sheet.  The user may input data"]
[null,"into any cell with a light yellow background."]
[null,"Cross-section station-elevation coordinates"]
[null,"are entered in columns A and B, along with"]
[null,"n-values in column C.  These coordinates are"]
[null,"plotted on the \"x-sec graph\" sheet.  Although"]
[null,"the cross-section is normally not plotted until"]
[null,"a rating curve is determined, the user may obtain"]
[null,"a preview by pressing the button in cell C4."]
[]
[null,"In cells L11 and M11 the user is required to enter bank stations.  The reason these data"]
[null,"are required is that, for many natural cross-section shapes, the results are affected by"]
[null,"how overbank flow is accounted for.  See details below in the section \"overbank flow\"."]
[]
[null,"The user may enter optional data for choice of unit system and channel profile slope."]
[null,"(Note that if profile slope is not entered, certain parameters including discharge cannot be computed.)"]
[null,"After the cross-section is entered, the user presses the \"calculate rating table\" button."]
[null,"This produces the table of data in columns E through P and from row 15 down."]
[null,"The user may then push the \"analyze single condition\" button to compute these parameters"]
[null,"for a given water surface, or discharge, which may be between the rating table values."]
[]
[null,"To obtain hydraulic parameters for left or right overbanks and channel, run a single"]
[null,"water surface calculation and see the comments for each parameter cell on line 8."]
[null,"Note that the comments will show no data if the selected water surface does not "]
[null,"result in overbank flow."]
[]
[null,"Lots of info about how the spreadsheet works is given in comments in several cells"]
[null,"of the data sheet (note the little red triangles in the upper right of the cells)."]
[null,"To really dig in to the guts of the spreadsheet, check out the macro modules,"]
[null,"from the View pull-down menu, Macros button (Excel 2013).  Choose a macro,"]
[null,"such as \"rateSection\" and click the Edit button.  You may browse the code"]
[null,"which includes numerous comment lines for information.  (Of course, you"]
[null,"won't want to change the code unless you know what you're doing.)"]
[]
[null,"The spreadsheet uses Mannings Equation, which computes \"uniform flow\".  This condition"]
[null,"may not be present in any given natural stream channel.  To understand more about how"]
[null,"\"uniform flow\" approximates real stream hydraulic parameters, consult a textbook, such as"]
[null,"Open Channel Hydraulics, by V.T. Chow.  Wikipedia also has many good articles."]
[]
[]
[null,"overbank flow"]
[]
[null,"Bank stations must be specified because, for many natural cross-sections, the total section"]
[null,"output is significantly affected by how overbank flow is treated.  The issue relates to how "]
[null,"wetted perimeter varies with depth.  If the cross-section has a relatively wide flat overbank"]
[null,"then the wetted perimeter can increase significantly with a minor increase in flow depth"]
[null,"(between in-channel flow and out-of-bank flow).  As a result, the hydraulic radius will "]
[null,"decrease with increase in depth, along with a reduction in computed total discharge."]
[null,"If the overbank hydraulic parameters are computed separately from the channel, then"]
[null,"this computational artifact is avoided.  However, the onus remains upon the user"]
[null,"to select appropriate bank stations."]
[]
[null,"The screenshot below demonstrates the difference in the rating table for a cross-section"]
[null,"with no banks specified versus banks at stations 100 and 130.  Note the red box, showing"]
[null,"the point at which flow goes out of banks.  The wetted perimeter jumps from 30 to 130"]
[null,"for a half foot increase in depth.  Total hydraulic radius and discharge drop.  With the"]
[null,"banks specified, the total discharge is the sum of the channel and overbank flows"]
[null,"computed separately.  (To test this yourself, insert the cross-section data on the data sheet."]
[null,"See separate bank parameters by running a single water surface analysis.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"relative roughness"]
[]
[null,"For gravel streams, the channel roughness may be computed using the Limerinos equation (below)"]
[null,"for which hydraulic radius and d84 are supplied in feet.  This is a \"relative roughness\" in that it varies with flow depth."]
[null,"The equation is number 34 from the following paper:"]
[]
[null,"Limerinos, J. T. (1970)"]
[null," \"Determination of the Manning coefficient from measured bed roughness in natural channels.\""]
[null," USGS water Supply Paper 1898-B: 52 pages."]
[]
[null,"In this spreadsheet, the relative roughness equation may be used by observing the following rules:"]
[]
[null,"1) The equation is only valid within the channel."]
[]
[null,"2) The left station boundary of the relative roughness computation must be equal to or greater than the left bank station (cell 11L)."]
[]
[null,"3) The right station boundary of the relative roughness computation must be equal to or less than the right bank station (cell 11M)."]
[]
[null,"4) To invoke the equation, put the word \"relative\" (no quotes) in the n value column (col C) in the row of the left relative roughness boundary."]
[]
[null,"5) In the next cell down (under the word \"relative\") specify the d84 gravel size in inches or mm if using SI units.  (spreadsheet will convert either to feet)"]
[]
[null,"6) Leave the n value rows in column C blank until the station which will form the right relative roughness boundary."]
[]
[null,"7) Specify an n value in that row, which will pertain to the cross-section right of the relative roughness boundary."]
[]
[null,"8) Any other n-values may be specified for the rows outside of the relative roughness boundaries."]
[]
[null,"9) See screenshot below for example.  Relative roughness will be computed between stations 108 and 120.  The d84 is 1.25 inches."]
[]
[]
[null,null,null,null,null,"Note:  The computed relative roughnesses can be found in the \"calcs\" sheet, column AS."]
[null,null,null,null,null,null,"The n-values reported in the rating curve may include the influence of roughness"]
[null,null,null,null,null,null,"outside the relative roughness boundary.  For example, normally one would only"]
[null,null,null,null,null,null,"compute relative roughness for the gravel channel bed.  The roughness of the banks"]
[null,null,null,null,null,null,"would be specified with an n-value representing, say, vegetation.  The total roughness"]
[null,null,null,null,null,null,"for the flow between the banks would be composited by the spreadsheet using"]
[null,null,null,null,null,null,"the relative roughness and the bank roughnesses.  In the example at left, the relative"]
[null,null,null,null,null,null,"roughness boundaries are the channel bottom at each bank.  The banks themselves are "]
[null,null,null,null,null,null,"vegetated, and the specified roughness is a 0.04 n value."]

{"sheet":"data","index":1,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Mannings Equation Analysis",null,null,null,"w.s. elev","flow area","wetted P","hydr. radius","top width","hydr. depth","n value","darcy-weis. f","conveyance","discharge","velocity","shear"]
["version 17, Sep 2016"]
["Murky Creek station 27+00",null,null,null,null,0,null,null,null,null,null,"unit system:","en"]
["cross-section data:",null,null,null,null,null,null,null,null,null,null,"auto scale:","yes"]
["station","elevation","n-value"]
[0,100,0.05,null,"hydraulic properties for given water surface elevation:"]
[10,98,null,null,"w.s. elev","flow area","wetted P","hydr. radius","top width","hydr. depth","n value","darcy-weis. f","conveyance","discharge","velocity","shear"]
[100,97.6,0.04,null,97.76,80.083999450000647,107.53779749647573,0.74470559481772158,106.80000000000233,0.74985018211609455,4.6315766804162828E-2,5.8126628593673513E-2,4600.6948051061418,172.14223701817895,2.1495209804756765,6.5057480763276151E-2]
[105,95.2,0.03]
[110,95,null,null,null,null,null,"    profile slope=",null,null,"bank stations:      left              right"]
[120,95.1,0.04,null,null,null,null,null,1.4E-3,null,null,100,130]
[130,97,0.05]
[150,97.5,null,null,"hydraulic properties rating table:"]
[190,98,null,null,"w.s. elev","flow area","wetted P","hydr. radius","top width","hydr. depth","n value","darcy-weis. f","conveyance","discharge","velocity","shear"]
[196,99.1,null,null,100,493.19999975000042,197.93786979576944,2.491690954635815,196,2.516326529336737,4.8033461720206012E-2,0.14758974502775529,32524.826880255649,1216.9675875005221,2.4674930821520564,0.21767412179698478]
[null,null,null,null,99.5,395.82499975000042,194.88836003897305,2.0310345865235093,193.5,2.0456072338501312,4.8002050195779834E-2,0.14571803533820793,23718.004955049957,887.44648439603623,2.2420172676221553,0.17743118147869377]
[null,null,null,null,99,299.7272724500001,191.38430536414384,1.5661016292831005,190.45454599999999,1.5737470107434459,4.7964693923924211E-2,0.13764509591256061,16226.647066054404,607.14553857276167,2.025659972847631,0.13681463833417165]
[null,null,null,null,98.5,205.80681770000024,186.06206806636385,1.1061191560366508,185.227273,1.1111042902413202,4.7905202625643427E-2,0.11543871367074592,10224.872568823757,382.57969975961657,1.8589262689892714,9.663056947136181E-2]
[null,null,null,null,98,114.49999945000013,180.73983076858383,0.63350728482535745,180,0.63611110805555626,4.7842127012074513E-2,6.2368537317768202E-2,5856.9489824992243,219.14696424326343,1.9139472951609973,5.5343196402343225E-2]
[null,null,null,null,97.5,61.510416100000384,50.504726896255207,1.2179140425083899,49.791667000000004,1.2353556288846561,4.1815666463201083E-2,8.9883689002777031E-2,3634.0380395064903,135.97325274336953,2.2105727999354028,0.10639697075353294]
[null,null,null,null,97,41.87499935000028,29.34302552001645,1.427085264995428,28.75,1.4565217165217488,3.5242820215422389E-2,0.12869635339352004,2238.0489597029009,83.740124220340945,1.9997641915268562,0.12467016875000059]
[null,null,null,null,96.5,28.418310849999898,25.508915288424635,1.1140540681043964,25.076753999999994,1.1332531654615228,3.4471085892489269E-2,0.13371580586261772,1316.5366427023207,49.260290541257035,1.733399666196459,9.7323763389600068E-2]
[null,null,null,null,96,16.798245350000116,21.674805056832831,0.77501252287870459,21.403508000000002,0.78483608154327389,3.3397923577823868E-2,0.14165903088503815,630.62194009707775,23.595712404259451,1.4046533975799615,6.770509399868363E-2]
[null,null,null,null,95.5,7.0148026000000527,17.840695726764043,0.39319109004682307,17.730262999999994,0.39564007595375517,3.1800651411877205E-2,0.16103207275451456,175.92761941538231,6.582608767231199,0.93838831148736102,3.434917362649046E-2]
[null,null,null,null,95,0,0,0,0,0,3.3397923577823868E-2,0.14165903088503815,0,0,0,0]

{"sheet":"calcs","index":3,"n_rows":21,"n_cols":65,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["inc #","elev","Atot","Aleft","Achan","Aright","WPtot","WPleft","WPchan","WPright","Rtot","Rleft","Rchan","Rright","TWtot","TWleft","TWchan","TWright","ntot","nleft","nchan","nright","Ktot","Kleft","Kchan","Kright","Qtot","Qleft","Qchan","Qright","Vtot","Vleft","Vchan","Vright","τtot","τleft","τchan","τright","ftot","fleft","fchan","fright","Arel","WPrel","nrel","STAleft","STAright","sta","elev","n-value",null,"w.s. plot stations",null,null,"bank station lines",null,null,"x-sec end extensions",null,null,"d84","relSTAleft","relSTAright",null,"slope"]
[1,100,493.19999975000042,208,131.49999945000013,153.70000030000028,197.93786979576944,100.19892791168493,30.729567982402706,67.009373901681798,2.491690954635815,2.0758705141369442,4.2792661297843058,2.2937089447442625,196,100,30,66,4.8033461720206012E-2,0.05,3.547121476225415E-2,4.9999999999999996E-2,32524.826880255649,10059.559880856566,14520.493036867003,7944.773962532081,1216.9675875005221,376.39426535901765,543.30710030993009,297.2662218315744,2.4674930821520564,1.8095878142260464,4.1316129473940428,1.9340678025462168,0.21767412179698478,0.18134804811500344,0.37383668909795692,0.20037841341285875,0.14758974502775529,0.22862032008001962,9.0407389919340359E-2,0.22114076745188466,null,null,null,100,130,0,100,0.05,1,63.999999999998082,97.76,null,100,100.5,null,0,9999,null,2.0833333333333332E-2,-77.777000000000001,-77.777000000000001,null,1.4E-3]
[2,99.5,395.82499975000042,158.625,116.49999945000013,120.70000030000028,194.88836003897305,97.649418154888536,30.729567982402706,66.509373901681798,2.0310345865235093,1.6244336422813483,3.7911369114174946,1.8147817851725137,193.5,97.5,30,66,4.8002050195779834E-2,5.000000000000001E-2,3.547121476225415E-2,4.9999999999999996E-2,23718.004955049957,6514.6100311233904,11866.290698092525,5337.1042258340422,887.44648439603623,243.75438744904451,443.99594244124813,199.69615450574364,2.2420172676221553,1.5366706852579639,3.8111239874452001,1.6544834632095951,0.17743118147869377,0.14191052298969858,0.33119372058143232,0.15853933675267079,0.14571803533820793,0.24809285492555952,9.4131982879700885E-2,0.23909662434731532,null,null,null,null,null,10,98,null,null,170.80000000000041,97.76,null,100,97.85,null,0,9999]
[3,99,299.7272724500001,110.5,101.49999945000013,87.727272999999968,191.38430536414384,95.09990839809214,30.729567982402706,65.554828983648989,1.5661016292831005,1.1619359246640117,3.3030076930506844,1.3382274709599402,190.45454599999999,95,30,65.454545999999993,4.7964693923924211E-2,0.05,3.547121476225415E-2,4.9999999999999996E-2,16226.647066054404,3629.6593645535522,9430.7994834652745,3166.1882180355769,607.14553857276167,135.8094177285501,352.86820550491717,118.46791533929439,2.025659972847631,1.2290445043307701,3.4765340632217776,1.3504114659906781,0.13681463833417165,0.10150672237864806,0.28855075206490777,0.11690755186306037,0.13764509591256061,0.27740919709738082,9.8557686754092072E-2,0.26464981917178287,null,null,null,null,null,100,97.6,0.04,2,300,9999,null,130,100.5,null,196,100]
[4,98.5,205.80681770000024,63.625,86.499999450000132,55.681818250000106,186.06206806636385,92.550398641295757,30.729567982402706,62.782101442665379,1.1061191560366508,0.68746327335224122,2.8148784746838738,0.88690593290908748,185.227273,92.5,30,62.727272999999997,4.7905202625643427E-2,0.05,3.547121476225415E-2,0.05,10224.872568823757,1472.9101948503219,7224.3473526185762,1527.6150213548583,382.57969975961657,55.111253106163524,270.31032636546064,57.158120287992382,1.8589262689892714,0.86618865392791389,3.1249748911467794,1.0265131794253552,9.663056947136181E-2,6.0056791560051788E-2,0.24590778354838319,7.7480102298937883E-2,0.11543871367074592,0.33044441392623952,0.10395382646302914,0.3035445188412656,null,null,null,null,null,105,95.2,0.03,null,400,9999,null,130,97.25,null,196,99.1]
[5,98,114.49999945000013,18,71.499999450000132,25,180.73983076858383,90.000888884499361,30.729567982402706,60.009373901681776,0.63350728482535745,0.19999802472062136,2.3267492563170631,0.41660158029576394,180,90,30,60,4.7842127012074513E-2,5.000000000000001E-2,3.547121476225415E-2,5.000000000000001E-2,5856.9489824992243,182.95254186897466,5259.5490377938586,414.44740283639061,219.14696424326343,6.8454572971311789,196.79430508361168,15.507201862520564,1.9139472951609973,0.3803031831739544,2.7523679244393522,0.62028807450082257,5.5343196402343225E-2,1.7471827439593482E-2,0.20326481503185861,3.6394314054637937E-2,6.2368537317768202E-2,0.49870035769489607,0.11076702770040596,0.39048822654340798,null,null,null,null,null,110,95,null,3,500,9999]
[6,97.5,61.510416100000384,0,56.510416100000384,5,50.504726896255207,0,30.498477872512652,20.006249023742555,1.2179140425083899,0,1.8528929980119271,0.2499219116020307,49.791667000000004,0,29.791667000000004,20,4.1815666463201083E-2,0,3.543469029787602E-2,0.05,3634.0380395064903,0,3575.0783711319914,58.959668374499131,135.97325274336953,0,133.76718395641768,2.2060687869518665,2.2105727999354028,0,2.3671243849931018,0.44121375739037327,0.10639697075353294,0,0.16186873230632196,2.1833178197553402E-2,8.9883689002777031E-2,0,0.11925650453377758,0.46299908970975417,null,null,null,null,null,120,95.1,0.04,null,600,9999]
[7,97,41.87499935000028,0,41.87499935000028,0,29.34302552001645,0,29.34302552001645,0,1.427085264995428,0,1.427085264995428,0,28.75,0,28.75,0,3.5242820215422389E-2,0,3.5242820215422389E-2,0,2238.0489597029009,0,2238.0489597029009,0,83.740124220340945,0,83.740124220340945,0,1.9997641915268562,0,1.9997641915268562,0,0.12467016875000059,0,0.12467016875000059,0,0.12869635339352004,0,0.12869635339352004,0,null,null,null,null,null,130,97,0.05,4,700,9999]
[8,96.5,28.418310849999898,0,28.418310849999898,0,25.508915288424635,0,25.508915288424635,0,1.1140540681043964,0,1.1140540681043964,0,25.076753999999994,0,25.076753999999994,0,3.4471085892489269E-2,0,3.4471085892489269E-2,0,1316.5366427023207,0,1316.5366427023207,0,49.260290541257035,0,49.260290541257035,0,1.733399666196459,0,1.733399666196459,0,9.7323763389600068E-2,0,9.7323763389600068E-2,0,0.13371580586261772,0,0.13371580586261772,0,null,null,null,null,null,150,97.5,null,null,800,9999]
[9,96,16.798245350000116,0,16.798245350000116,0,21.674805056832831,0,21.674805056832831,0,0.77501252287870459,0,0.77501252287870459,0,21.403508000000002,0,21.403508000000002,0,3.3397923577823868E-2,0,3.3397923577823868E-2,0,630.62194009707775,0,630.62194009707775,0,23.595712404259451,0,23.595712404259451,0,1.4046533975799615,0,1.4046533975799615,0,6.770509399868363E-2,0,6.770509399868363E-2,0,0.14165903088503815,0,0.14165903088503815,0,null,null,null,null,null,190,98,null,5,900,9999]
[10,95.5,7.0148026000000527,0,7.0148026000000527,0,17.840695726764043,0,17.840695726764043,0,0.39319109004682307,0,0.39319109004682307,0,17.730262999999994,0,17.730262999999994,0,3.1800651411877205E-2,0,3.1800651411877205E-2,0,175.92761941538231,0,175.92761941538231,0,6.582608767231199,0,6.582608767231199,0,0.93838831148736102,0,0.93838831148736102,0,3.434917362649046E-2,0,3.434917362649046E-2,0,0.16103207275451456,0,0.16103207275451456,0,null,null,null,null,null,196,99.1,null,null,1000,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1100,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1200,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1300,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1500,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1600,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1700,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1800,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1900,9999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000,9999]

{"sheet":"segments","index":4,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["incr #","sta1","elev1","sta2","elev2","n value","WPseg"]
[1,0,100,2.5,99.5,0.05,2.5495097567963922]
[2,2.5,99.5,5,99,0.05,2.5495097567963922]
[3,5,99,7.5,98.5,0.05,2.5495097567963922]
[4,7.5,98.5,10,98,0.05,2.5495097567963922]
[5,10,98,100,97.6,0.05,90.000888884499361]
[5,100,97.6,100.208333,97.5,0.04,0.23109010989005402]
[6,100.208333,97.5,101.25,97,0.04,1.1554523524962024]
[7,101.25,97,102.291667,96.5,0.04,1.1554523524962024]
[8,102.291667,96.5,103.33333399999999,96,0.04,1.1554523524961895]
[9,103.33333399999999,96,104.375,95.5,0.04,1.1554514509731741]
[10,104.375,95.5,105,95.2,0.04,0.69327123119310119]
[10,105,95.2,110,95,0.03,5.0039984012787215]
[10,110,95,120,95.1,0.03,10.000499987500625]
[10,120,95.1,122.10526299999999,95.5,0.04,2.1429261067915939]
[9,122.10526299999999,95.5,124.736842,96,0.04,2.6786578790956135]
[8,124.736842,96,127.368421,96.5,0.04,2.6786578790956135]
[7,127.368421,96.5,130,97,0.04,2.6786578790956135]
[6,130,97,150,97.5,0.05,20.006249023742555]
[5,150,97.5,190,98,0.05,40.003124877939221]
[4,190,98,192.727273,98.5,0.05,2.7727275409836039]
[3,192.727273,98.5,195.45454599999999,99,0.05,2.7727275409836039]
[2,195.45454599999999,99,196,99.1,0.05,0.55454491803280104]
[2,196,99.1,196,99.5,0.05,0.40000000000000568]
[1,196,99.5,196,100,0.05,0.5]