{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["d=100","d=500","d=1000"],"not_rendered":{"charts":15,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"d=100","index":0,"n_rows":214,"n_cols":26,"rows_kept":214,"cut":false,"hidden":false,"merged":[[2,17,2,19],[2,20,2,22]]}
["Flow Profile at downstream signal  (minor TH movement)"]
[]
["Given Data",null,null,null,"Robertson Model",null,null,null,"Movement","tc","tf",null,"Summary","Cap","Distance","Blocked",null,"ConFlow-Option 3",null,null,"Capacity Options",null,null,null,null,"Analysis of one cycle period (t=42-101)"]
["C",60,"sec",null,"Distance",100,"ft",null,"MajorLT",4.0999999999999996,2.2000000000000002,null,"GapCap",{"$f":"(INT((B4-B9-J6)/K6)+1)*(3600/B4)","v":600},null,null,null,"ConFlow",{"$f":"SUM(C47:C106)/60","v":587.74612180840825},null,"Option","CapFlow","PropBlocked"]
["G",30,"sec",null,"Speed",25,"mi/hr",null,"MinorRT",6.2,3.3,null,"c random",{"$f":"PotCap(B8,J6,K6,0)","v":417.3579938946678},null,null,null,null,null,null,3,{"$f":"PotCap(S4,J6,K6,0)","v":424.11515480397571}]
["R",{"$f":"B4-B5","v":30},"sec",null,"tR",{"$f":"(F4)/(1.47*F5)","v":2.7210884353741496},"sec",null,"MinorTH",6.5,4,null,null,null,null,null,null,"Critical flow line",null,null,4,{"$f":"AVERAGE(E47:E106)","v":442.96216602432304}]
["SatFlow",1800,"veh/hr-g",null,"tprime",{"$f":"tprime(F6,F8)","v":2.2805782312925169},"sec",null,"MinorLT",7.1,3.5,null,null,null,null,null,null,null,{"$f":"3600/$J$6","v":553.84615384615381},42]
["ArrFlow",600,"veh/hr",null,"F",{"$f":"F(F6)","v":0.59153739361381064},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3600/$J$6","v":553.84615384615381},111]
["gq",{"$f":"(B8*B6)/(B7-B8)","v":15},"sec"]
["gu",{"$f":"B5-B9","v":15},"sec"]
[]
[]
["Time i","DepFlowi","ArrFlowj","Blocked?","PotCapGap"]
[0,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A14)","v":0},{"$f":"IF(A14>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C13,$F$8),0)","v":0},{"$f":"IF(C14>(3600/$J$6),1,0)","v":0},{"$f":"IF(A14>$B$6+$F$7,PotCap(C14,$J$6,$K$6,D14),\"\")","v":""}]
[1,0,{"$f":"IF(A15>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C14,$F$8),0)","v":0},{"$f":"IF(C15>(3600/$J$6),1,0)","v":0},""]
[2,0,{"$f":"IF(A16>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C15,$F$8),0)","v":0},0,""]
[3,0,{"$f":"IF(A17>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C16,$F$8),0)","v":0},0,""]
[4,0,{"$f":"IF(A18>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C17,$F$8),0)","v":0},0,""]
[5,0,{"$f":"IF(A19>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C18,$F$8),0)","v":0},0,""]
[6,0,{"$f":"IF(A20>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C19,$F$8),0)","v":0},0,""]
[7,0,{"$f":"IF(A21>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C20,$F$8),0)","v":0},0,""]
[8,0,{"$f":"IF(A22>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C21,$F$8),0)","v":0},0,""]
[9,0,{"$f":"IF(A23>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C22,$F$8),0)","v":0},0,""]
[10,0,{"$f":"IF(A24>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C23,$F$8),0)","v":0},0,""]
[11,0,{"$f":"IF(A25>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C24,$F$8),0)","v":0},0,""]
[12,0,{"$f":"IF(A26>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C25,$F$8),0)","v":0},0,""]
[13,0,{"$f":"IF(A27>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C26,$F$8),0)","v":0},0,""]
[14,0,{"$f":"IF(A28>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C27,$F$8),0)","v":0},0,""]
[15,0,{"$f":"IF(A29>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C28,$F$8),0)","v":0},0,""]
[16,0,{"$f":"IF(A30>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C29,$F$8),0)","v":0},0,""]
[17,0,{"$f":"IF(A31>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C30,$F$8),0)","v":0},0,""]
[18,0,{"$f":"IF(A32>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C31,$F$8),0)","v":0},0,""]
[19,0,{"$f":"IF(A33>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C32,$F$8),0)","v":0},0,""]
[20,0,{"$f":"IF(A34>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C33,$F$8),0)","v":0},0,""]
[21,0,{"$f":"IF(A35>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C34,$F$8),0)","v":0},0,""]
[22,0,{"$f":"IF(A36>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C35,$F$8),0)","v":0},0,""]
[23,0,{"$f":"IF(A37>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C36,$F$8),0)","v":0},0,""]
[24,0,{"$f":"IF(A38>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C37,$F$8),0)","v":0},0,""]
[25,0,{"$f":"IF(A39>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C38,$F$8),0)","v":0},0,""]
[26,0,{"$f":"IF(A40>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C39,$F$8),0)","v":0},0,""]
[27,0,{"$f":"IF(A41>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C40,$F$8),0)","v":0},0,""]
[28,0,{"$f":"IF(A42>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C41,$F$8),0)","v":0},0,""]
[29,0,{"$f":"IF(A43>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C42,$F$8),0)","v":0},0,""]
[30,1800,{"$f":"IF(A44>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C43,$F$8),0)","v":0},0,""]
[31,1800,{"$f":"IF(A45>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C44,$F$8),0)","v":0},0,""]
[32,1800,{"$f":"IF(A46>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C45,$F$8),0)","v":0},0,""]
[33,1800,{"$f":"IF(A47>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C46,$F$8),0)","v":1064.7673085048591},1,0]
[34,1800,{"$f":"IF(A48>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C47,$F$8),0)","v":1499.6849385315616},1,0]
[35,1800,{"$f":"IF(A49>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C48,$F$8),0)","v":1677.332527255573},1,0]
[36,1800,{"$f":"IF(A50>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C49,$F$8),0)","v":1749.8949243640045},1,0]
[37,1800,{"$f":"IF(A51>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C50,$F$8),0)","v":1779.5339502125441},1,0]
[38,1800,{"$f":"IF(A52>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C51,$F$8),0)","v":1791.6403839613863},1,0]
[39,1800,{"$f":"IF(A53>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C52,$F$8),0)","v":1796.5854094444799},1,0]
[40,1800,{"$f":"IF(A54>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C53,$F$8),0)","v":1798.6052674419507},1,0]
[41,1800,{"$f":"IF(A55>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C54,$F$8),0)","v":1799.4303039041274},1,0]
[42,1800,{"$f":"IF(A56>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C55,$F$8),0)","v":1799.7673004478318},1,0]
[43,1800,{"$f":"IF(A57>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C56,$F$8),0)","v":1799.9049509344163},1,0]
[44,1800,{"$f":"IF(A58>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C57,$F$8),0)","v":1799.9611760109369},1,0]
[45,600,{"$f":"IF(A59>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C58,$F$8),0)","v":1799.9841418522369},1,0]
[46,600,{"$f":"IF(A60>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C59,$F$8),0)","v":1799.9935225396321},1,0]
[47,600,{"$f":"IF(A61>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C60,$F$8),0)","v":1090.1524818630826},1,0]
[48,600,{"$f":"IF(A62>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C61,$F$8),0)","v":800.20896026845412},1,0]
[49,600,{"$f":"IF(A63>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C62,$F$8),0)","v":681.77787373312185},1,0]
[50,600,{"$f":"IF(A64>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C63,$F$8),0)","v":633.40320344975157},1,0]
[51,600,{"$f":"IF(A65>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C64,$F$8),0)","v":613.64395954273368},1,0]
[52,600,{"$f":"IF(A66>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C65,$F$8),0)","v":605.57304727625274},1,0]
[53,600,{"$f":"IF(A67>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C66,$F$8),0)","v":602.27638141597163},1,0]
[54,600,{"$f":"IF(A68>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C67,$F$8),0)","v":600.92981668629682},1,0]
[55,600,{"$f":"IF(A69>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C68,$F$8),0)","v":600.37979534714611},1,0]
[56,600,{"$f":"IF(A70>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C69,$F$8),0)","v":600.15513219738864},1,0]
[57,600,{"$f":"IF(A71>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C70,$F$8),0)","v":600.0633657016798},1,0]
[58,600,{"$f":"IF(A72>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C71,$F$8),0)","v":600.02588251966358},1,0]
[59,600,{"$f":"IF(A73>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C72,$F$8),0)","v":600.01057204144161},1,0]
[60,0,{"$f":"IF(A74>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C73,$F$8),0)","v":600.00431828360206},1,0]
[61,0,{"$f":"IF(A75>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C74,$F$8),0)","v":600.00176385737518},1,0]
[62,0,{"$f":"IF(A76>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C75,$F$8),0)","v":245.07828430149439},0,660.47490918635322]
[63,0,{"$f":"IF(A77>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C76,$F$8),0)","v":100.10531477444391},0,793.73343892534297]
[64,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A78)","v":0},{"$f":"IF(A78>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C77,$F$8),0)","v":40.889277785879273},0,{"$f":"IF(A78>$B$6+$F$7,PotCap(C78,$J$6,$K$6,D78),\"\")","v":855.08182215544525}]
[65,0,{"$f":"IF(A79>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C78,$F$8),0)","v":16.701740977669161},{"$f":"IF(C79>(3600/$J$6),1,0)","v":0},881.39267167490527]
[66,0,{"$f":"IF(A80>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C79,$F$8),0)","v":6.8220366509257682},0,892.35570317644454]
[67,0,{"$f":"IF(A81>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C80,$F$8),0)","v":2.7865468712992496},0,896.87022985844999]
[68,0,{"$f":"IF(A82>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C81,$F$8),0)","v":1.1382001978681728},0,898.72037535225354]
[69,0,{"$f":"IF(A83>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C82,$F$8),0)","v":0.46491221941051031},0,899.47711569862099]
[70,0,{"$f":"IF(A84>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C83,$F$8),0)","v":0.18989925688120499},0,899.78638702056105]
[71,0,{"$f":"IF(A85>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C84,$F$8),0)","v":7.7566745416497496E-2},0,899.91274136290042]
[72,0,{"$f":"IF(A86>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C85,$F$8),0)","v":3.1683115001716576E-2},0,899.96435715631958]
[73,0,{"$f":"IF(A87>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C86,$F$8),0)","v":1.2941367732034529E-2},0,899.98544107274915]
[74,0,{"$f":"IF(A88>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C87,$F$8),0)","v":5.286064794028952E-3},0,899.99405318790912]
[75,0,{"$f":"IF(A89>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C88,$F$8),0)","v":2.1591598032953412E-3},0,899.9975709448554]
[76,0,{"$f":"IF(A90>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C89,$F$8),0)","v":8.8193604085830702E-4},0,899.99900782049485]
[77,0,{"$f":"IF(A91>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C90,$F$8),0)","v":3.6023789391490088E-4},0,899.99959485009197]
[78,0,{"$f":"IF(A92>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C91,$F$8),0)","v":1.4714370906755201E-4},0,899.99983453812956]
[79,0,{"$f":"IF(A93>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C92,$F$8),0)","v":6.0102702919063459E-5},0,899.99993232525321]
[80,0,{"$f":"IF(A94>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C93,$F$8),0)","v":2.4549706685175491E-5},0,899.99997174245732]
[81,0,{"$f":"IF(A95>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C94,$F$8),0)","v":1.0027637178643238E-5},0,899.99998890941629]
[82,0,{"$f":"IF(A96>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C95,$F$8),0)","v":4.0959148178836712E-6},0,899.99999566470319]
[83,0,{"$f":"IF(A97>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C96,$F$8),0)","v":1.6730280420485786E-6},0,900.000011226948]
[84,0,{"$f":"IF(A98>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C97,$F$8),0)","v":6.8336939461234567E-7},0,900.00004302727291]
[85,0,{"$f":"IF(A99>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C98,$F$8),0)","v":2.7913084404791107E-7},0,900.00008205229597]
[86,0,{"$f":"IF(A100>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C99,$F$8),0)","v":1.1401451208258671E-7},0,900.00011221921875]
[87,0,{"$f":"IF(A101>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C100,$F$8),0)","v":4.6570664771103047E-8},0,900.0003368180079]
[88,0,{"$f":"IF(A102>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C101,$F$8),0)","v":1.9022375113542239E-8},0,899.99959522322376]
[89,0,{"$f":"IF(A103>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C102,$F$8),0)","v":7.7699289185332479E-9},0,900.00511777653742]
[90,1800,{"$f":"IF(A104>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C103,$F$8),0)","v":3.173725417499516E-9},0,899.98983770709242]
[91,1800,{"$f":"IF(A105>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C104,$F$8),0)","v":1.2963481559859494E-9},0,899.98968278512189]
[92,1800,{"$f":"IF(A106>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C105,$F$8),0)","v":1064.7673085053887},1,0]
[93,1800,{"$f":"IF(A107>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C106,$F$8),0)","v":1499.6849385317778},1,0]
[94,1800,{"$f":"IF(A108>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C107,$F$8),0)","v":1677.3325272556613},1,0]
[95,1800,{"$f":"IF(A109>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C108,$F$8),0)","v":1749.8949243640404},1,0]
[96,1800,{"$f":"IF(A110>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C109,$F$8),0)","v":1779.5339502125589},1,0]
[97,1800,{"$f":"IF(A111>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C110,$F$8),0)","v":1791.6403839613922},1,0]
[98,1800,{"$f":"IF(A112>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C111,$F$8),0)","v":1796.5854094444826},1,0]
[99,1800,{"$f":"IF(A113>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C112,$F$8),0)","v":1798.6052674419516},1,0]
[100,1800,{"$f":"IF(A114>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C113,$F$8),0)","v":1799.4303039041279},1,0]
[101,1800,{"$f":"IF(A115>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C114,$F$8),0)","v":1799.767300447832},1,0]
[102,1800,{"$f":"IF(A116>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C115,$F$8),0)","v":1799.9049509344165},1,0]
[103,1800,{"$f":"IF(A117>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C116,$F$8),0)","v":1799.9611760109372},1,0]
[104,1800,{"$f":"IF(A118>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C117,$F$8),0)","v":1799.9841418522369},1,0]
[105,600,{"$f":"IF(A119>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C118,$F$8),0)","v":1799.9935225396321},1,0]
[106,600,{"$f":"IF(A120>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C119,$F$8),0)","v":1799.9973541996553},1,0]
[107,600,{"$f":"IF(A121>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C120,$F$8),0)","v":1090.1540469529225},1,0]
[108,600,{"$f":"IF(A122>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C121,$F$8),0)","v":800.20959954912928},1,0]
[109,600,{"$f":"IF(A123>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C122,$F$8),0)","v":681.77813485537263},1,0]
[110,600,{"$f":"IF(A124>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C123,$F$8),0)","v":633.40331010842669},1,0]
[111,600,{"$f":"IF(A125>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C124,$F$8),0)","v":613.6440031088141},1,0]
[112,600,{"$f":"IF(A126>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C125,$F$8),0)","v":605.57306507136741},1,0]
[113,600,{"$f":"IF(A127>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C126,$F$8),0)","v":602.27638868461054},1,0]
[114,600,{"$f":"IF(A128>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C127,$F$8),0)","v":600.92981965526405},1,0]
[115,600,{"$f":"IF(A129>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C128,$F$8),0)","v":600.37979655985828},1,0]
[116,600,{"$f":"IF(A130>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C129,$F$8),0)","v":600.15513269273617},1,0]
[117,600,{"$f":"IF(A131>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C130,$F$8),0)","v":600.06336590401065},1,0]
[118,600,{"$f":"IF(A132>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C131,$F$8),0)","v":600.02588260230823},1,0]
[119,600,{"$f":"IF(A133>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C132,$F$8),0)","v":600.01057207519887},1,0]
[120,0,{"$f":"IF(A134>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C133,$F$8),0)","v":600.00431829739068},1,0]
[121,0,{"$f":"IF(A135>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C134,$F$8),0)","v":600.00176386300734},1,0]
[122,0,{"$f":"IF(A136>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C135,$F$8),0)","v":245.0782843037949},0,660.47490918441565]
[123,0,{"$f":"IF(A137>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C136,$F$8),0)","v":100.10531477538359},0,793.73343892440232]
[124,0,{"$f":"IF(A138>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C137,$F$8),0)","v":40.889277786263094},0,855.08182215503496]
[125,0,{"$f":"IF(A139>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C138,$F$8),0)","v":16.701740977825938},0,881.39267167473315]
[126,0,{"$f":"IF(A140>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C139,$F$8),0)","v":6.8220366509898058},0,892.35570317637382]
[127,0,{"$f":"IF(A141>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C140,$F$8),0)","v":2.7865468713254065},0,896.87022985841975]
[128,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A142)","v":0},{"$f":"IF(A142>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C141,$F$8),0)","v":1.138200197878857},0,{"$f":"IF(A142>$B$6+$F$7,PotCap(C142,$J$6,$K$6,D142),\"\")","v":898.72037535222512}]
[129,0,{"$f":"IF(A143>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C142,$F$8),0)","v":0.46491221941487437},{"$f":"IF(C143>(3600/$J$6),1,0)","v":0},899.47711569874241]
[130,0,{"$f":"IF(A144>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C143,$F$8),0)","v":0.18989925688298753},0,899.78638702095475]
[131,0,{"$f":"IF(A145>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C144,$F$8),0)","v":7.7566745417225594E-2},0,899.91274136323125]
[132,0,{"$f":"IF(A146>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C145,$F$8),0)","v":3.1683115002013977E-2},0,899.96435715625205]
[133,0,{"$f":"IF(A147>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C146,$F$8),0)","v":1.2941367732156006E-2},0,899.985441074248]
[134,0,{"$f":"IF(A148>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C147,$F$8),0)","v":5.2860647940785712E-3},0,899.99405319635719]
[135,0,{"$f":"IF(A149>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C148,$F$8),0)","v":2.1591598033156084E-3},0,899.99757095330335]
[136,0,{"$f":"IF(A150>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C149,$F$8),0)","v":8.8193604086658545E-4},0,899.99900782894281]
[137,0,{"$f":"IF(A151>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C150,$F$8),0)","v":3.6023789391828229E-4},0,899.99959460890477]
[138,0,{"$f":"IF(A152>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C151,$F$8),0)","v":1.4714370906893318E-4},0,899.9998345465774]
[139,0,{"$f":"IF(A153>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C152,$F$8),0)","v":6.0102702919627616E-5},0,899.99993233370105]
[140,0,{"$f":"IF(A154>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C153,$F$8),0)","v":2.4549706685405928E-5},0,899.99997175090527]
[141,0,{"$f":"IF(A155>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C154,$F$8),0)","v":1.0027637178737364E-5},0,899.99998891786424]
[142,0,{"$f":"IF(A156>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C155,$F$8),0)","v":4.0959148179221181E-6},0,899.99999567315115]
[143,0,{"$f":"IF(A157>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C156,$F$8),0)","v":1.6730280420642826E-6},0,900.00001123539596]
[144,0,{"$f":"IF(A158>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C157,$F$8),0)","v":6.8336939461876014E-7},0,900.00004303572086]
[145,0,{"$f":"IF(A159>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C158,$F$8),0)","v":2.7913084405053116E-7},0,900.00008206074392]
[146,0,{"$f":"IF(A160>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C159,$F$8),0)","v":1.1401451208365691E-7},0,900.00011222766659]
[147,0,{"$f":"IF(A161>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C160,$F$8),0)","v":4.6570664771540182E-8},0,900.00033682645574]
[148,0,{"$f":"IF(A162>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C161,$F$8),0)","v":1.9022375113720794E-8},0,899.99959523167172]
[149,0,{"$f":"IF(A163>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C162,$F$8),0)","v":7.7699289186061804E-9},0,900.00511778498526]
[150,1800,{"$f":"IF(A164>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C163,$F$8),0)","v":3.173725417529306E-9},0,899.98983771554015]
[151,1800,{"$f":"IF(A165>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C164,$F$8),0)","v":1.2963481559981174E-9},0,899.9896827935695]
[152,1800,{"$f":"IF(A166>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C165,$F$8),0)","v":1064.7673085053887},1,0]
[153,1800,{"$f":"IF(A167>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C166,$F$8),0)","v":1499.6849385317778},1,0]
[154,1800,{"$f":"IF(A168>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C167,$F$8),0)","v":1677.3325272556613},1,0]
[155,1800,{"$f":"IF(A169>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C168,$F$8),0)","v":1749.8949243640404},1,0]
[156,1800,{"$f":"IF(A170>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C169,$F$8),0)","v":1779.5339502125589},1,0]
[157,1800,{"$f":"IF(A171>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C170,$F$8),0)","v":1791.6403839613922},1,0]
[158,1800,{"$f":"IF(A172>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C171,$F$8),0)","v":1796.5854094444826},1,0]
[159,1800,{"$f":"IF(A173>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C172,$F$8),0)","v":1798.6052674419516},1,0]
[160,1800,{"$f":"IF(A174>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C173,$F$8),0)","v":1799.4303039041279},1,0]
[161,1800,{"$f":"IF(A175>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C174,$F$8),0)","v":1799.767300447832},1,0]
[162,1800,{"$f":"IF(A176>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C175,$F$8),0)","v":1799.9049509344165},1,0]
[163,1800,{"$f":"IF(A177>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C176,$F$8),0)","v":1799.9611760109372},1,0]
[164,1800,{"$f":"IF(A178>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C177,$F$8),0)","v":1799.9841418522369},1,0]
[165,600,{"$f":"IF(A179>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C178,$F$8),0)","v":1799.9935225396321},1,0]
[166,600,{"$f":"IF(A180>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C179,$F$8),0)","v":1799.9973541996553},1,0]
[167,600,{"$f":"IF(A181>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C180,$F$8),0)","v":1090.1540469529225},1,0]
[168,600,{"$f":"IF(A182>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C181,$F$8),0)","v":800.20959954912928},1,0]
[169,600,{"$f":"IF(A183>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C182,$F$8),0)","v":681.77813485537263},1,0]
[170,600,{"$f":"IF(A184>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C183,$F$8),0)","v":633.40331010842669},1,0]
[171,600,{"$f":"IF(A185>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C184,$F$8),0)","v":613.6440031088141},1,0]
[172,600,{"$f":"IF(A186>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C185,$F$8),0)","v":605.57306507136741},1,0]
[173,600,{"$f":"IF(A187>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C186,$F$8),0)","v":602.27638868461054},1,0]
[174,600,{"$f":"IF(A188>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C187,$F$8),0)","v":600.92981965526405},1,0]
[175,600,{"$f":"IF(A189>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C188,$F$8),0)","v":600.37979655985828},1,0]
[176,600,{"$f":"IF(A190>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C189,$F$8),0)","v":600.15513269273617},1,0]
[177,600,{"$f":"IF(A191>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C190,$F$8),0)","v":600.06336590401065},1,0]
[178,600,{"$f":"IF(A192>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C191,$F$8),0)","v":600.02588260230823},1,0]
[179,600,{"$f":"IF(A193>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C192,$F$8),0)","v":600.01057207519887},1,0]
[180,0,{"$f":"IF(A194>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C193,$F$8),0)","v":600.00431829739068},1,0]
[181,0,{"$f":"IF(A195>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C194,$F$8),0)","v":600.00176386300734},1,0]
[182,0,{"$f":"IF(A196>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C195,$F$8),0)","v":245.0782843037949},0,660.47490918441565]
[183,0,{"$f":"IF(A197>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C196,$F$8),0)","v":100.10531477538359},0,793.73343892440232]
[184,0,{"$f":"IF(A198>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C197,$F$8),0)","v":40.889277786263094},0,855.08182215503496]
[185,0,{"$f":"IF(A199>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C198,$F$8),0)","v":16.701740977825938},0,881.39267167473315]
[186,0,{"$f":"IF(A200>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C199,$F$8),0)","v":6.8220366509898058},0,892.35570317637382]
[187,0,{"$f":"IF(A201>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C200,$F$8),0)","v":2.7865468713254065},0,896.87022985841975]
[188,0,{"$f":"IF(A202>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C201,$F$8),0)","v":1.138200197878857},0,898.72037535222512]
[189,0,{"$f":"IF(A203>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C202,$F$8),0)","v":0.46491221941487437},0,899.47711569874241]
[190,0,{"$f":"IF(A204>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C203,$F$8),0)","v":0.18989925688298753},0,899.78638702095475]
[191,0,{"$f":"IF(A205>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C204,$F$8),0)","v":7.7566745417225594E-2},0,899.91274136323125]
[192,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A206)","v":0},{"$f":"IF(A206>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C205,$F$8),0)","v":3.1683115002013977E-2},0,{"$f":"IF(A206>$B$6+$F$7,PotCap(C206,$J$6,$K$6,D206),\"\")","v":899.96435715625205}]
[193,0,{"$f":"IF(A207>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C206,$F$8),0)","v":1.2941367732156006E-2},{"$f":"IF(C207>(3600/$J$6),1,0)","v":0},899.985441074248]
[194,0,{"$f":"IF(A208>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C207,$F$8),0)","v":5.2860647940785712E-3},0,899.99405319635719]
[195,0,{"$f":"IF(A209>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C208,$F$8),0)","v":2.1591598033156084E-3},0,899.99757095330335]
[196,0,{"$f":"IF(A210>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C209,$F$8),0)","v":8.8193604086658545E-4},0,899.99900782894281]
[197,0,{"$f":"IF(A211>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C210,$F$8),0)","v":3.6023789391828229E-4},0,899.99959460890477]
[198,0,{"$f":"IF(A212>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C211,$F$8),0)","v":1.4714370906893318E-4},0,899.9998345465774]
[199,0,{"$f":"IF(A213>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C212,$F$8),0)","v":6.0102702919627616E-5},0,899.99993233370105]
[200,0,{"$f":"IF(A214>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C213,$F$8),0)","v":2.4549706685405928E-5},0,899.99997175090527]

{"sheet":"d=500","index":1,"n_rows":214,"n_cols":26,"rows_kept":214,"cut":false,"hidden":false,"merged":[[2,17,2,19],[2,20,2,22]]}
["Flow Profile at downstream signal  (minor TH movement)"]
[]
["Given Data",null,null,null,"Robertson Model",null,null,null,"Movement","tc","tf",null,"Summary","Cap","Distance","Blocked",null,"ConFlow-Option 3",null,null,"Capacity Options",null,null,null,null,"Analysis of one cycle period (t=42-101)"]
["C",60,"sec",null,"Distance",500,"ft",null,"MajorLT",4.0999999999999996,2.2000000000000002,null,"GapCap",{"$f":"(INT((B4-B9-J6)/K6)+1)*(3600/B4)","v":600},null,null,null,"ConFlow",{"$f":"SUM(C56:C115)/60","v":579.39668126873983},null,"Option","CapFlow","PropBlocked"]
["G",30,"sec",null,"Speed",25,"mi/hr",null,"MinorRT",6.2,3.3,null,"c random",{"$f":"PotCap(B8,J6,K6,0)","v":417.3579938946678},null,null,null,null,null,null,3,{"$f":"PotCap(S4,J6,K6,0)","v":428.77813528096561}]
["R",{"$f":"B4-B5","v":30},"sec",null,"tR",{"$f":"(F4)/(1.47*F5)","v":13.605442176870747},"sec",null,"MinorTH",6.5,4,null,null,null,null,null,null,"Critical flow line",null,null,4,{"$f":"AVERAGE(E56:E115)","v":428.34746125819908}]
["SatFlow",1800,"veh/hr-g",null,"tprime",{"$f":"tprime(F6,F8)","v":11.662891156462585},"sec",null,"MinorLT",7.1,3.5,null,null,null,null,null,null,null,{"$f":"3600/$J$6","v":553.84615384615381},42]
["ArrFlow",600,"veh/hr",null,"F",{"$f":"F(F6)","v":0.31322913670214469},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3600/$J$6","v":553.84615384615381},111]
["gq",{"$f":"(B8*B6)/(B7-B8)","v":15},"sec"]
["gu",{"$f":"B5-B9","v":15},"sec"]
[]
[]
["Time i","DepFlowi","ArrFlowj","Blocked?","PotCapGap"]
[0,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A14)","v":0},{"$f":"IF(A14>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C13,$F$8),0)","v":0},{"$f":"IF(C14>(3600/$J$6),1,0)","v":0},{"$f":"IF(A14>$B$6+$F$7,PotCap(C14,$J$6,$K$6,D14),\"\")","v":""}]
[1,0,{"$f":"IF(A15>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C14,$F$8),0)","v":0},{"$f":"IF(C15>(3600/$J$6),1,0)","v":0},""]
[2,0,{"$f":"IF(A16>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C15,$F$8),0)","v":0},0,""]
[3,0,{"$f":"IF(A17>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C16,$F$8),0)","v":0},0,""]
[4,0,{"$f":"IF(A18>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C17,$F$8),0)","v":0},0,""]
[5,0,{"$f":"IF(A19>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C18,$F$8),0)","v":0},0,""]
[6,0,{"$f":"IF(A20>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C19,$F$8),0)","v":0},0,""]
[7,0,{"$f":"IF(A21>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C20,$F$8),0)","v":0},0,""]
[8,0,{"$f":"IF(A22>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C21,$F$8),0)","v":0},0,""]
[9,0,{"$f":"IF(A23>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C22,$F$8),0)","v":0},0,""]
[10,0,{"$f":"IF(A24>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C23,$F$8),0)","v":0},0,""]
[11,0,{"$f":"IF(A25>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C24,$F$8),0)","v":0},0,""]
[12,0,{"$f":"IF(A26>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C25,$F$8),0)","v":0},0,""]
[13,0,{"$f":"IF(A27>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C26,$F$8),0)","v":0},0,""]
[14,0,{"$f":"IF(A28>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C27,$F$8),0)","v":0},0,""]
[15,0,{"$f":"IF(A29>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C28,$F$8),0)","v":0},0,""]
[16,0,{"$f":"IF(A30>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C29,$F$8),0)","v":0},0,""]
[17,0,{"$f":"IF(A31>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C30,$F$8),0)","v":0},0,""]
[18,0,{"$f":"IF(A32>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C31,$F$8),0)","v":0},0,""]
[19,0,{"$f":"IF(A33>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C32,$F$8),0)","v":0},0,""]
[20,0,{"$f":"IF(A34>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C33,$F$8),0)","v":0},0,""]
[21,0,{"$f":"IF(A35>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C34,$F$8),0)","v":0},0,""]
[22,0,{"$f":"IF(A36>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C35,$F$8),0)","v":0},0,""]
[23,0,{"$f":"IF(A37>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C36,$F$8),0)","v":0},0,""]
[24,0,{"$f":"IF(A38>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C37,$F$8),0)","v":0},0,""]
[25,0,{"$f":"IF(A39>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C38,$F$8),0)","v":0},0,""]
[26,0,{"$f":"IF(A40>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C39,$F$8),0)","v":0},0,""]
[27,0,{"$f":"IF(A41>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C40,$F$8),0)","v":0},0,""]
[28,0,{"$f":"IF(A42>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C41,$F$8),0)","v":0},0,""]
[29,0,{"$f":"IF(A43>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C42,$F$8),0)","v":0},0,""]
[30,1800,{"$f":"IF(A44>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C43,$F$8),0)","v":0},0,""]
[31,1800,{"$f":"IF(A45>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C44,$F$8),0)","v":0},0,""]
[32,1800,{"$f":"IF(A46>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C45,$F$8),0)","v":0},0,""]
[33,1800,{"$f":"IF(A47>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C46,$F$8),0)","v":0},0,""]
[34,1800,{"$f":"IF(A48>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C47,$F$8),0)","v":0},0,""]
[35,1800,{"$f":"IF(A49>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C48,$F$8),0)","v":0},0,""]
[36,1800,{"$f":"IF(A50>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C49,$F$8),0)","v":0},0,""]
[37,1800,{"$f":"IF(A51>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C50,$F$8),0)","v":0},0,""]
[38,1800,{"$f":"IF(A52>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C51,$F$8),0)","v":0},0,""]
[39,1800,{"$f":"IF(A53>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C52,$F$8),0)","v":0},0,""]
[40,1800,{"$f":"IF(A54>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C53,$F$8),0)","v":0},0,""]
[41,1800,{"$f":"IF(A55>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C54,$F$8),0)","v":0},0,""]
[42,1800,{"$f":"IF(A56>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C55,$F$8),0)","v":563.81244606386042},1,0]
[43,1800,{"$f":"IF(A57>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C56,$F$8),0)","v":951.02240638521334},1,0]
[44,1800,{"$f":"IF(A58>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C57,$F$8),0)","v":1216.946925112637},1,0]
[45,600,{"$f":"IF(A59>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C58,$F$8),0)","v":1399.5761364111368},1,0]
[46,600,{"$f":"IF(A60>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C59,$F$8),0)","v":1525.0005575180137},1,0]
[47,600,{"$f":"IF(A61>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C60,$F$8),0)","v":1611.1383954802172},1,0]
[48,600,{"$f":"IF(A62>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C61,$F$8),0)","v":1670.2953528201306},1,0]
[49,600,{"$f":"IF(A63>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C62,$F$8),0)","v":1710.9226274825373},1,0]
[50,600,{"$f":"IF(A64>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C63,$F$8),0)","v":1738.8242559758773},1,0]
[51,600,{"$f":"IF(A65>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C64,$F$8),0)","v":1757.9862814636645},1,0]
[52,600,{"$f":"IF(A66>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C65,$F$8),0)","v":1771.1462022504479},1,0]
[53,600,{"$f":"IF(A67>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C66,$F$8),0)","v":1780.1840524101185},1,0]
[54,600,{"$f":"IF(A68>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C67,$F$8),0)","v":1786.3909845666321},1,0]
[55,600,{"$f":"IF(A69>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C68,$F$8),0)","v":1790.6537247221922},1,0]
[56,600,{"$f":"IF(A70>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C69,$F$8),0)","v":1417.7062864162669},1,0]
[57,600,{"$f":"IF(A71>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C70,$F$8),0)","v":1161.5768522461831},1,0]
[58,600,{"$f":"IF(A72>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C71,$F$8),0)","v":985.67461962520338},1,0]
[59,600,{"$f":"IF(A73>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C72,$F$8),0)","v":864.870091472073},1,0]
[60,0,{"$f":"IF(A74>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C73,$F$8),0)","v":781.90506138205751},1,0]
[61,0,{"$f":"IF(A75>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C74,$F$8),0)","v":724.92709604360493},1,0]
[62,0,{"$f":"IF(A76>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C75,$F$8),0)","v":685.79628959916067},1,0]
[63,0,{"$f":"IF(A77>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C76,$F$8),0)","v":658.92239187576843},1,0]
[64,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A78)","v":0},{"$f":"IF(A78>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C77,$F$8),0)","v":640.46618193609606},1,{"$f":"IF(A78>$B$6+$F$7,PotCap(C78,$J$6,$K$6,D78),\"\")","v":0}]
[65,0,{"$f":"IF(A79>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C78,$F$8),0)","v":627.79099470262076},{"$f":"IF(C79>(3600/$J$6),1,0)","v":1},0]
[66,0,{"$f":"IF(A80>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C79,$F$8),0)","v":619.086045423825},1,0]
[67,0,{"$f":"IF(A81>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C80,$F$8),0)","v":613.10773989266238},1,0]
[68,0,{"$f":"IF(A82>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C81,$F$8),0)","v":609.00201384196748},1,0]
[69,0,{"$f":"IF(A83>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C82,$F$8),0)","v":606.18232081766723},1,0]
[70,0,{"$f":"IF(A84>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C83,$F$8),0)","v":604.24583780513365},1,0]
[71,0,{"$f":"IF(A85>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C84,$F$8),0)","v":414.9784356735675},0,531.03555107129807]
[72,0,{"$f":"IF(A86>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C85,$F$8),0)","v":284.99509851752947},0,627.64597843334411]
[73,0,{"$f":"IF(A87>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C86,$F$8),0)","v":195.72632984454103},0,703.28837222642846]
[74,0,{"$f":"IF(A88>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C87,$F$8),0)","v":134.41914051745621},0,760.09358246989314]
[75,0,{"$f":"IF(A89>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C88,$F$8),0)","v":92.315149176929125},0,801.56213010609645]
[76,0,{"$f":"IF(A90>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C89,$F$8),0)","v":63.39935469570991},0,831.25683560757466]
[77,0,{"$f":"IF(A91>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C90,$F$8),0)","v":43.540829556899631},0,852.24258246466968]
[78,0,{"$f":"IF(A92>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C91,$F$8),0)","v":29.902573103496735},0,866.9406771239378]
[79,0,{"$f":"IF(A93>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C92,$F$8),0)","v":20.536215945115682},0,877.17173943628006]
[80,0,{"$f":"IF(A94>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C93,$F$8),0)","v":14.103674753498279},0,884.26336079531836]
[81,0,{"$f":"IF(A95>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C94,$F$8),0)","v":9.6859928861321798},0,889.16466752093231]
[82,0,{"$f":"IF(A96>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C95,$F$8),0)","v":6.6520576963058824},0,892.54543058718639]
[83,0,{"$f":"IF(A97>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C96,$F$8),0)","v":4.5684394067991336},0,894.87419171094689]
[84,0,{"$f":"IF(A98>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C97,$F$8),0)","v":3.137471075331383},0,896.47680342587091]
[85,0,{"$f":"IF(A99>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C98,$F$8),0)","v":2.1547237189773845},0,897.57898301228465]
[86,0,{"$f":"IF(A100>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C99,$F$8),0)","v":1.4798014686504637},0,898.33666091786552]
[87,0,{"$f":"IF(A101>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C100,$F$8),0)","v":1.0162845321345131},0,898.85735804982801]
[88,0,{"$f":"IF(A102>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C101,$F$8),0)","v":0.69795460549027655},0,899.21512095685659]
[89,0,{"$f":"IF(A103>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C102,$F$8),0)","v":0.47933488695527127},0,899.46089914054267]
[90,1800,{"$f":"IF(A104>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C103,$F$8),0)","v":0.32919323412305151},0,899.62972878267828]
[91,1800,{"$f":"IF(A105>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C104,$F$8),0)","v":0.22608032159050109},0,899.74569320732974]
[92,1800,{"$f":"IF(A106>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C105,$F$8),0)","v":0.1552653776333652},0,899.82534228366762]
[93,1800,{"$f":"IF(A107>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C106,$F$8),0)","v":0.10663173743753374},0,899.88004676357582]
[94,1800,{"$f":"IF(A108>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C107,$F$8),0)","v":7.3231570374925281E-2},0,899.91761800593213]
[95,1800,{"$f":"IF(A109>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C108,$F$8),0)","v":5.0293308807045078E-2},0,899.94342168868786]
[96,1800,{"$f":"IF(A110>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C109,$F$8),0)","v":3.4539979107519977E-2},0,899.96114330611897]
[97,1800,{"$f":"IF(A111>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C110,$F$8),0)","v":2.372105126996138E-2},0,899.97331418741101]
[98,1800,{"$f":"IF(A112>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C111,$F$8),0)","v":1.6290926859004063E-2},0,899.98167287986769]
[99,1800,{"$f":"IF(A113>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C112,$F$8),0)","v":1.1188133902880438E-2},0,899.98741343261258]
[100,1800,{"$f":"IF(A114>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C113,$F$8),0)","v":7.683684379173202E-3},0,899.9913558969057]
[101,1800,{"$f":"IF(A115>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C114,$F$8),0)","v":563.81772299441479},1,0]
[102,1800,{"$f":"IF(A116>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C115,$F$8),0)","v":951.02603042736564},1,0]
[103,1800,{"$f":"IF(A117>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C116,$F$8),0)","v":1216.9494139991948},1,0]
[104,1800,{"$f":"IF(A118>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C117,$F$8),0)","v":1399.5778457059066},1,0]
[105,600,{"$f":"IF(A119>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C118,$F$8),0)","v":1525.0017314118586},1,0]
[106,600,{"$f":"IF(A120>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C119,$F$8),0)","v":1611.1392016763066},1,0]
[107,600,{"$f":"IF(A121>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C120,$F$8),0)","v":1670.2959064921147},1,0]
[108,600,{"$f":"IF(A122>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C121,$F$8),0)","v":1710.9230077283237},1,0]
[109,600,{"$f":"IF(A123>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C122,$F$8),0)","v":1738.8245171176045},1,0]
[110,600,{"$f":"IF(A124>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C123,$F$8),0)","v":1757.9864608081939},1,0]
[111,600,{"$f":"IF(A125>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C124,$F$8),0)","v":1771.1463254190448},1,0]
[112,600,{"$f":"IF(A126>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C125,$F$8),0)","v":1780.1841369987219},1,0]
[113,600,{"$f":"IF(A127>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C126,$F$8),0)","v":1786.3910426596203},1,0]
[114,600,{"$f":"IF(A128>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C127,$F$8),0)","v":1790.6537646187639},1,0]
[115,600,{"$f":"IF(A129>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C128,$F$8),0)","v":1793.5812778586437},1,0]
[116,600,{"$f":"IF(A130>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C129,$F$8),0)","v":1419.716844611138},1,0]
[117,600,{"$f":"IF(A131>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C130,$F$8),0)","v":1162.9576450333852},1,0]
[118,600,{"$f":"IF(A132>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C131,$F$8),0)","v":986.62290787970551},1,0]
[119,600,{"$f":"IF(A133>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C132,$F$8),0)","v":865.52134821527261},1,0]
[120,0,{"$f":"IF(A134>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C133,$F$8),0)","v":782.35232553781316},1,0]
[121,0,{"$f":"IF(A135>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C134,$F$8),0)","v":725.23426403397548},1,0]
[122,0,{"$f":"IF(A136>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C135,$F$8),0)","v":686.00724362508493},1,0]
[123,0,{"$f":"IF(A137>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C136,$F$8),0)","v":659.06726895426857},1,0]
[124,0,{"$f":"IF(A138>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C137,$F$8),0)","v":640.56567929236962},1,0]
[125,0,{"$f":"IF(A139>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C138,$F$8),0)","v":627.85932658788465},1,0]
[126,0,{"$f":"IF(A140>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C139,$F$8),0)","v":619.1329737716585},1,0]
[127,0,{"$f":"IF(A141>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C140,$F$8),0)","v":613.13996891461716},1,0]
[128,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A142)","v":0},{"$f":"IF(A142>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C141,$F$8),0)","v":609.02414779519859},1,{"$f":"IF(A142>$B$6+$F$7,PotCap(C142,$J$6,$K$6,D142),\"\")","v":0}]
[129,0,{"$f":"IF(A143>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C142,$F$8),0)","v":606.19752177183591},{"$f":"IF(C143>(3600/$J$6),1,0)","v":1},0]
[130,0,{"$f":"IF(A144>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C143,$F$8),0)","v":604.25627737755099},1,0]
[131,0,{"$f":"IF(A145>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C144,$F$8),0)","v":414.985605267729},0,531.03062998260805]
[132,0,{"$f":"IF(A146>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C145,$F$8),0)","v":285.00002238590127},0,627.64202492498919]
[133,0,{"$f":"IF(A147>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C146,$F$8),0)","v":195.7297114138735},0,703.28535160833451]
[134,0,{"$f":"IF(A148>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C147,$F$8),0)","v":134.42146288074599},0,760.09135155387048]
[135,0,{"$f":"IF(A149>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C148,$F$8),0)","v":92.316744108370543},0,801.56051992205346]
[136,0,{"$f":"IF(A150>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C149,$F$8),0)","v":63.400450048152834},0,831.25569152087246]
[137,0,{"$f":"IF(A151>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C150,$F$8),0)","v":43.541581813042477},0,852.24177821240562]
[138,0,{"$f":"IF(A152>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C151,$F$8),0)","v":29.903089731097378},0,866.9401158894085]
[139,0,{"$f":"IF(A153>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C152,$F$8),0)","v":20.536570749898978},0,877.17134974790463]
[140,0,{"$f":"IF(A154>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C153,$F$8),0)","v":14.103918423085604},0,884.26309114759977]
[141,0,{"$f":"IF(A155>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C154,$F$8),0)","v":9.6861602313050259},0,889.16448137590555]
[142,0,{"$f":"IF(A156>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C155,$F$8),0)","v":6.6521726240947068},0,892.54530229415832]
[143,0,{"$f":"IF(A157>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C156,$F$8),0)","v":4.568518335855881},0,894.87410338826896]
[144,0,{"$f":"IF(A158>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C157,$F$8),0)","v":3.1375252815078247},0,896.47674266694935]
[145,0,{"$f":"IF(A159>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C158,$F$8),0)","v":2.1547609461999753},0,897.57894123692336]
[146,0,{"$f":"IF(A160>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C159,$F$8),0)","v":1.4798270352222607},0,898.33663220510243]
[147,0,{"$f":"IF(A161>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C160,$F$8),0)","v":1.0163020905110978},0,898.85733832007656]
[148,0,{"$f":"IF(A162>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C161,$F$8),0)","v":0.6979666640717217},0,899.21510740198778]
[149,0,{"$f":"IF(A163>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C162,$F$8),0)","v":0.47934316843766051},0,899.4608898291408]
[150,1800,{"$f":"IF(A164>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C163,$F$8),0)","v":0.32919892160386138},0,899.62972238647808]
[151,1800,{"$f":"IF(A165>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C164,$F$8),0)","v":0.22608422758660687},0,899.74568881432981]
[152,1800,{"$f":"IF(A166>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C165,$F$8),0)","v":0.1552680601576828},0,899.82533926637132]
[153,1800,{"$f":"IF(A167>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C166,$F$8),0)","v":0.10663357971707514},0,899.88004469106875]
[154,1800,{"$f":"IF(A168>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C167,$F$8),0)","v":7.3232835598836366E-2},0,899.91761658215046]
[155,1800,{"$f":"IF(A169>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C168,$F$8),0)","v":5.0294177725962765E-2},0,899.94342071097026]
[156,1800,{"$f":"IF(A170>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C169,$F$8),0)","v":3.4540575855715211E-2},0,899.96114263544064]
[157,1800,{"$f":"IF(A171>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C170,$F$8),0)","v":2.3721461099234592E-2},0,899.97331372607584]
[158,1800,{"$f":"IF(A172>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C171,$F$8),0)","v":1.6291208317807834E-2},0,899.98167256592285]
[159,1800,{"$f":"IF(A173>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C172,$F$8),0)","v":1.1188327200586087E-2},0,899.9874132169997]
[160,1800,{"$f":"IF(A174>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C173,$F$8),0)","v":7.6838171304053843E-3},0,899.99135574614684]
[161,1800,{"$f":"IF(A175>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C174,$F$8),0)","v":563.81772308558448},1,0]
[162,1800,{"$f":"IF(A176>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C175,$F$8),0)","v":951.02603048997844},1,0]
[163,1800,{"$f":"IF(A177>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C176,$F$8),0)","v":1216.9494140421953},1,0]
[164,1800,{"$f":"IF(A178>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C177,$F$8),0)","v":1399.5778457354381},1,0]
[165,600,{"$f":"IF(A179>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C178,$F$8),0)","v":1525.0017314321399},1,0]
[166,600,{"$f":"IF(A180>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C179,$F$8),0)","v":1611.139201690235},1,0]
[167,600,{"$f":"IF(A181>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C180,$F$8),0)","v":1670.2959065016807},1,0]
[168,600,{"$f":"IF(A182>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C181,$F$8),0)","v":1710.9230077348934},1,0]
[169,600,{"$f":"IF(A183>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C182,$F$8),0)","v":1738.8245171221165},1,0]
[170,600,{"$f":"IF(A184>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C183,$F$8),0)","v":1757.9864608112925},1,0]
[171,600,{"$f":"IF(A185>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C184,$F$8),0)","v":1771.1463254211731},1,0]
[172,600,{"$f":"IF(A186>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C185,$F$8),0)","v":1780.1841370001835},1,0]
[173,600,{"$f":"IF(A187>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C186,$F$8),0)","v":1786.391042660624},1,0]
[174,600,{"$f":"IF(A188>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C187,$F$8),0)","v":1790.6537646194529},1,0]
[175,600,{"$f":"IF(A189>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C188,$F$8),0)","v":1793.5812778591167},1,0]
[176,600,{"$f":"IF(A190>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C189,$F$8),0)","v":1419.7168446114629},1,0]
[177,600,{"$f":"IF(A191>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C190,$F$8),0)","v":1162.9576450336083},1,0]
[178,600,{"$f":"IF(A192>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C191,$F$8),0)","v":986.62290787985876},1,0]
[179,600,{"$f":"IF(A193>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C192,$F$8),0)","v":865.52134821537788},1,0]
[180,0,{"$f":"IF(A194>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C193,$F$8),0)","v":782.35232553788546},1,0]
[181,0,{"$f":"IF(A195>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C194,$F$8),0)","v":725.23426403402505},1,0]
[182,0,{"$f":"IF(A196>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C195,$F$8),0)","v":686.00724362511892},1,0]
[183,0,{"$f":"IF(A197>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C196,$F$8),0)","v":659.06726895429188},1,0]
[184,0,{"$f":"IF(A198>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C197,$F$8),0)","v":640.56567929238565},1,0]
[185,0,{"$f":"IF(A199>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C198,$F$8),0)","v":627.85932658789557},1,0]
[186,0,{"$f":"IF(A200>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C199,$F$8),0)","v":619.132973771666},1,0]
[187,0,{"$f":"IF(A201>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C200,$F$8),0)","v":613.13996891462227},1,0]
[188,0,{"$f":"IF(A202>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C201,$F$8),0)","v":609.02414779520211},1,0]
[189,0,{"$f":"IF(A203>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C202,$F$8),0)","v":606.19752177183841},1,0]
[190,0,{"$f":"IF(A204>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C203,$F$8),0)","v":604.25627737755281},1,0]
[191,0,{"$f":"IF(A205>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C204,$F$8),0)","v":414.98560526773025},0,531.03062998260714]
[192,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A206)","v":0},{"$f":"IF(A206>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C205,$F$8),0)","v":285.00002238590213},0,{"$f":"IF(A206>$B$6+$F$7,PotCap(C206,$J$6,$K$6,D206),\"\")","v":627.64202492498862}]
[193,0,{"$f":"IF(A207>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C206,$F$8),0)","v":195.7297114138741},{"$f":"IF(C207>(3600/$J$6),1,0)","v":0},703.28535160833394]
[194,0,{"$f":"IF(A208>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C207,$F$8),0)","v":134.42146288074639},0,760.09135155387037]
[195,0,{"$f":"IF(A209>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C208,$F$8),0)","v":92.316744108370813},0,801.56051992205266]
[196,0,{"$f":"IF(A210>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C209,$F$8),0)","v":63.400450048153019},0,831.25569152087201]
[197,0,{"$f":"IF(A211>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C210,$F$8),0)","v":43.541581813042598},0,852.2417782124038]
[198,0,{"$f":"IF(A212>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C211,$F$8),0)","v":29.903089731097459},0,866.94011588940793]
[199,0,{"$f":"IF(A213>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C212,$F$8),0)","v":20.536570749899035},0,877.17134974790702]
[200,0,{"$f":"IF(A214>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C213,$F$8),0)","v":14.103918423085643},0,884.26309114760215]

{"sheet":"d=1000","index":2,"n_rows":214,"n_cols":26,"rows_kept":214,"cut":false,"hidden":false,"merged":[[2,17,2,19],[2,20,2,22]]}
["Flow Profile at downstream signal  (minor TH movement)"]
[]
["Given Data",null,null,null,"Robertson Model",null,null,null,"Movement","tc","tf",null,"Summary","Cap","Distance","Blocked",null,"ConFlow-Option 3",null,null,"Capacity Options",null,null,null,null,"Analysis of one cycle period (t=42-101)"]
["C",60,"sec",null,"Distance",1000,"ft",null,"MajorLT",4.0999999999999996,2.2000000000000002,null,"GapCap",{"$f":"(INT((B4-B9-J6)/K6)+1)*(3600/B4)","v":600},null,null,null,"ConFlow",{"$f":"SUM(C68:C127)/60","v":575.86908722999237},null,"Option","CapFlow","PropBlocked"]
["G",30,"sec",null,"Speed",25,"mi/hr",null,"MinorRT",6.2,3.3,null,"c random",{"$f":"PotCap(B8,J6,K6,0)","v":417.3579938946678},null,null,null,null,null,null,3,{"$f":"PotCap(S4,J6,K6,0)","v":430.76268364445576}]
["R",{"$f":"B4-B5","v":30},"sec",null,"tR",{"$f":"(F4)/(1.47*F5)","v":27.210884353741495},"sec",null,"MinorTH",6.5,4,null,null,null,null,null,null,"Critical flow line",null,null,4,{"$f":"AVERAGE(E68:E127)","v":427.39525825257965}]
["SatFlow",1800,"veh/hr-g",null,"tprime",{"$f":"tprime(F6,F8)","v":23.390782312925168},"sec",null,"MinorLT",7.1,3.5,null,null,null,null,null,null,null,{"$f":"3600/$J$6","v":553.84615384615381},42]
["ArrFlow",600,"veh/hr",null,"F",{"$f":"F(F6)","v":0.19723468915410469},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3600/$J$6","v":553.84615384615381},111]
["gq",{"$f":"(B8*B6)/(B7-B8)","v":15},"sec"]
["gu",{"$f":"B5-B9","v":15},"sec"]
[]
[]
["Time i","DepFlowi","ArrFlowj","Blocked?","PotCapGap"]
[0,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A14)","v":0},{"$f":"IF(A14>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C13,$F$8),0)","v":0},{"$f":"IF(C14>(3600/$J$6),1,0)","v":0},{"$f":"IF(A14>$B$6+$F$7,PotCap(C14,$J$6,$K$6,D14),\"\")","v":""}]
[1,0,{"$f":"IF(A15>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C14,$F$8),0)","v":0},{"$f":"IF(C15>(3600/$J$6),1,0)","v":0},""]
[2,0,{"$f":"IF(A16>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C15,$F$8),0)","v":0},0,""]
[3,0,{"$f":"IF(A17>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C16,$F$8),0)","v":0},0,""]
[4,0,{"$f":"IF(A18>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C17,$F$8),0)","v":0},0,""]
[5,0,{"$f":"IF(A19>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C18,$F$8),0)","v":0},0,""]
[6,0,{"$f":"IF(A20>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C19,$F$8),0)","v":0},0,""]
[7,0,{"$f":"IF(A21>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C20,$F$8),0)","v":0},0,""]
[8,0,{"$f":"IF(A22>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C21,$F$8),0)","v":0},0,""]
[9,0,{"$f":"IF(A23>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C22,$F$8),0)","v":0},0,""]
[10,0,{"$f":"IF(A24>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C23,$F$8),0)","v":0},0,""]
[11,0,{"$f":"IF(A25>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C24,$F$8),0)","v":0},0,""]
[12,0,{"$f":"IF(A26>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C25,$F$8),0)","v":0},0,""]
[13,0,{"$f":"IF(A27>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C26,$F$8),0)","v":0},0,""]
[14,0,{"$f":"IF(A28>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C27,$F$8),0)","v":0},0,""]
[15,0,{"$f":"IF(A29>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C28,$F$8),0)","v":0},0,""]
[16,0,{"$f":"IF(A30>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C29,$F$8),0)","v":0},0,""]
[17,0,{"$f":"IF(A31>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C30,$F$8),0)","v":0},0,""]
[18,0,{"$f":"IF(A32>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C31,$F$8),0)","v":0},0,""]
[19,0,{"$f":"IF(A33>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C32,$F$8),0)","v":0},0,""]
[20,0,{"$f":"IF(A34>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C33,$F$8),0)","v":0},0,""]
[21,0,{"$f":"IF(A35>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C34,$F$8),0)","v":0},0,""]
[22,0,{"$f":"IF(A36>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C35,$F$8),0)","v":0},0,""]
[23,0,{"$f":"IF(A37>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C36,$F$8),0)","v":0},0,""]
[24,0,{"$f":"IF(A38>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C37,$F$8),0)","v":0},0,""]
[25,0,{"$f":"IF(A39>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C38,$F$8),0)","v":0},0,""]
[26,0,{"$f":"IF(A40>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C39,$F$8),0)","v":0},0,""]
[27,0,{"$f":"IF(A41>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C40,$F$8),0)","v":0},0,""]
[28,0,{"$f":"IF(A42>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C41,$F$8),0)","v":0},0,""]
[29,0,{"$f":"IF(A43>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C42,$F$8),0)","v":0},0,""]
[30,1800,{"$f":"IF(A44>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C43,$F$8),0)","v":0},0,""]
[31,1800,{"$f":"IF(A45>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C44,$F$8),0)","v":0},0,""]
[32,1800,{"$f":"IF(A46>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C45,$F$8),0)","v":0},0,""]
[33,1800,{"$f":"IF(A47>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C46,$F$8),0)","v":0},0,""]
[34,1800,{"$f":"IF(A48>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C47,$F$8),0)","v":0},0,""]
[35,1800,{"$f":"IF(A49>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C48,$F$8),0)","v":0},0,""]
[36,1800,{"$f":"IF(A50>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C49,$F$8),0)","v":0},0,""]
[37,1800,{"$f":"IF(A51>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C50,$F$8),0)","v":0},0,""]
[38,1800,{"$f":"IF(A52>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C51,$F$8),0)","v":0},0,""]
[39,1800,{"$f":"IF(A53>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C52,$F$8),0)","v":0},0,""]
[40,1800,{"$f":"IF(A54>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C53,$F$8),0)","v":0},0,""]
[41,1800,{"$f":"IF(A55>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C54,$F$8),0)","v":0},0,""]
[42,1800,{"$f":"IF(A56>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C55,$F$8),0)","v":0},0,""]
[43,1800,{"$f":"IF(A57>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C56,$F$8),0)","v":0},0,""]
[44,1800,{"$f":"IF(A58>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C57,$F$8),0)","v":0},0,""]
[45,600,{"$f":"IF(A59>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C58,$F$8),0)","v":0},0,""]
[46,600,{"$f":"IF(A60>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C59,$F$8),0)","v":0},0,""]
[47,600,{"$f":"IF(A61>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C60,$F$8),0)","v":0},0,""]
[48,600,{"$f":"IF(A62>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C61,$F$8),0)","v":0},0,""]
[49,600,{"$f":"IF(A63>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C62,$F$8),0)","v":0},0,""]
[50,600,{"$f":"IF(A64>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C63,$F$8),0)","v":0},0,""]
[51,600,{"$f":"IF(A65>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C64,$F$8),0)","v":0},0,""]
[52,600,{"$f":"IF(A66>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C65,$F$8),0)","v":0},0,""]
[53,600,{"$f":"IF(A67>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C66,$F$8),0)","v":0},0,""]
[54,600,{"$f":"IF(A68>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C67,$F$8),0)","v":355.02244047738844},0,573.72002287745158]
[55,600,{"$f":"IF(A69>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C68,$F$8),0)","v":640.02214026448746},1,0]
[56,600,{"$f":"IF(A70>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C69,$F$8),0)","v":868.810012855065},1,0]
[57,600,{"$f":"IF(A71>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C70,$F$8),0)","v":1052.472980513011},1,0]
[58,600,{"$f":"IF(A72>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C71,$F$8),0)","v":1199.9112398358216},1,0]
[59,600,{"$f":"IF(A73>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C72,$F$8),0)","v":1318.2695599116753},1,0]
[60,0,{"$f":"IF(A74>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C73,$F$8),0)","v":1413.2835135185662},1,0]
[61,0,{"$f":"IF(A75>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C74,$F$8),0)","v":1489.5574195204995},1,0]
[62,0,{"$f":"IF(A76>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C75,$F$8),0)","v":1550.787465381572},1,0]
[63,0,{"$f":"IF(A77>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C76,$F$8),0)","v":1599.9408221803442},1,0]
[64,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A78)","v":0},{"$f":"IF(A78>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C77,$F$8),0)","v":1639.3994319300298},1,{"$f":"IF(A78>$B$6+$F$7,PotCap(C78,$J$6,$K$6,D78),\"\")","v":0}]
[65,0,{"$f":"IF(A79>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C78,$F$8),0)","v":1671.075435051283},{"$f":"IF(C79>(3600/$J$6),1,0)","v":1},0]
[66,0,{"$f":"IF(A80>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C79,$F$8),0)","v":1696.5038315432714},1,0]
[67,0,{"$f":"IF(A81>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C80,$F$8),0)","v":1716.9168661574752},1,0]
[68,0,{"$f":"IF(A82>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C81,$F$8),0)","v":1496.6221152499288},1,0]
[69,0,{"$f":"IF(A83>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C82,$F$8),0)","v":1319.7771310599132},1,0]
[70,0,{"$f":"IF(A84>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C83,$F$8),0)","v":1177.8121123550779},1,0]
[71,0,{"$f":"IF(A85>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C84,$F$8),0)","v":1063.8475199852476},1,0]
[72,0,{"$f":"IF(A86>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C85,$F$8),0)","v":972.36069856605491},1,0]
[73,0,{"$f":"IF(A87>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C86,$F$8),0)","v":898.9182519311737},1,0]
[74,0,{"$f":"IF(A88>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C87,$F$8),0)","v":839.96120342904032},1,0]
[75,0,{"$f":"IF(A89>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C88,$F$8),0)","v":792.6325300616686},1,0]
[76,0,{"$f":"IF(A90>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C89,$F$8),0)","v":754.63871287398661},1,0]
[77,0,{"$f":"IF(A91>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C90,$F$8),0)","v":724.13859440909505},1,0]
[78,0,{"$f":"IF(A92>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C91,$F$8),0)","v":699.65415732878978},1,0]
[79,0,{"$f":"IF(A93>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C92,$F$8),0)","v":679.99890058513165},1,0]
[80,0,{"$f":"IF(A94>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C93,$F$8),0)","v":664.22034229555311},1,0]
[81,0,{"$f":"IF(A95>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C94,$F$8),0)","v":651.55386304551939},1,0]
[82,0,{"$f":"IF(A96>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C95,$F$8),0)","v":641.38565289304302},1,0]
[83,0,{"$f":"IF(A97>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C96,$F$8),0)","v":514.88215301678122},0,466.46922847875902]
[84,0,{"$f":"IF(A98>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C97,$F$8),0)","v":413.32953161552018},0,532.16846925752486]
[85,0,{"$f":"IF(A99>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C98,$F$8),0)","v":331.80660992912135},0,591.09665363257977]
[86,0,{"$f":"IF(A100>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C99,$F$8),0)","v":266.36283636047381},0,642.77467168511237]
[87,0,{"$f":"IF(A101>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C100,$F$8),0)","v":213.82684512871009},0,687.29277206697247]
[88,0,{"$f":"IF(A102>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C101,$F$8),0)","v":171.65277379694606},0,725.10290498742518]
[89,0,{"$f":"IF(A103>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C102,$F$8),0)","v":137.79689231466557},0,756.85530351989837]
[90,1800,{"$f":"IF(A104>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C103,$F$8),0)","v":110.61856509258087},0,783.28153307367984]
[91,1800,{"$f":"IF(A105>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C104,$F$8),0)","v":88.800746791872584},0,805.11749741187816]
[92,1800,{"$f":"IF(A106>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C105,$F$8),0)","v":71.286159101725232},0,823.05717766148575]
[93,1800,{"$f":"IF(A107>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C106,$F$8),0)","v":57.226055670306408},0,837.72823126602941]
[94,1800,{"$f":"IF(A108>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C107,$F$8),0)","v":45.939092368658031},0,849.6821518391481]
[95,1800,{"$f":"IF(A109>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C108,$F$8),0)","v":36.87830976530406},0,859.39350846696118]
[96,1800,{"$f":"IF(A110>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C109,$F$8),0)","v":29.604627802215528},0,867.26440434021458]
[97,1800,{"$f":"IF(A111>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C110,$F$8),0)","v":23.765568240122583},0,873.63157648403421]
[98,1800,{"$f":"IF(A112>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C111,$F$8),0)","v":19.078173775711342},0,878.77449986330066]
[99,1800,{"$f":"IF(A113>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C112,$F$8),0)","v":15.315296101430924},0,882.92351508609681]
[100,1800,{"$f":"IF(A114>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C113,$F$8),0)","v":12.294588435562124},0,886.26743659493457]
[101,1800,{"$f":"IF(A115>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C114,$F$8),0)","v":9.869669107196378},0,888.96037869526333]
[102,1800,{"$f":"IF(A116>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C115,$F$8),0)","v":7.9230279887846304},0,891.1277088175849]
[103,1800,{"$f":"IF(A117>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C116,$F$8),0)","v":6.3603320262574226},0,892.87113730540716]
[104,1800,{"$f":"IF(A118>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C117,$F$8),0)","v":5.1058539161416432},0,894.27300644582988]
[105,600,{"$f":"IF(A119>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C118,$F$8),0)","v":4.098802406125178},0,895.39986596140091]
[106,600,{"$f":"IF(A120>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C119,$F$8),0)","v":3.290376387648982},0,896.3054294019347]
[107,600,{"$f":"IF(A121>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C120,$F$8),0)","v":2.6414000236310291},0,897.03300333352638]
[108,600,{"$f":"IF(A122>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C121,$F$8),0)","v":2.1204243110385184},0,897.61747364256269]
[109,600,{"$f":"IF(A123>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C122,$F$8),0)","v":1.7022030811760296},0,898.08692353273307]
[110,600,{"$f":"IF(A124>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C123,$F$8),0)","v":1.3664695855831162},0,898.46394757282712]
[111,600,{"$f":"IF(A125>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C124,$F$8),0)","v":1.0969543816320919},0,898.76671637828281]
[112,600,{"$f":"IF(A126>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C125,$F$8),0)","v":0.88059692515465315},0,899.00983763711076]
[113,600,{"$f":"IF(A127>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C126,$F$8),0)","v":355.72935314174015},0,573.19850783682659]
[114,600,{"$f":"IF(A128>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C127,$F$8),0)","v":640.58962522922673},1,0]
[115,600,{"$f":"IF(A129>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C128,$F$8),0)","v":869.26557009918429},1,0]
[116,600,{"$f":"IF(A130>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C129,$F$8),0)","v":1052.8386860656944},1,0]
[117,600,{"$f":"IF(A131>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C130,$F$8),0)","v":1200.2048155674997},1,0]
[118,600,{"$f":"IF(A132>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C131,$F$8),0)","v":1318.5052323251728},1,0]
[119,600,{"$f":"IF(A133>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C132,$F$8),0)","v":1413.4727031568452},1,0]
[120,0,{"$f":"IF(A134>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C133,$F$8),0)","v":1489.7092943992814},1,0]
[121,0,{"$f":"IF(A135>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C134,$F$8),0)","v":1550.909385265847},1,0]
[122,0,{"$f":"IF(A136>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C135,$F$8),0)","v":1600.0386952341426},1,0]
[123,0,{"$f":"IF(A137>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C136,$F$8),0)","v":1639.4780010224856},1,0]
[124,0,{"$f":"IF(A138>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C137,$F$8),0)","v":1671.1385075932112},1,0]
[125,0,{"$f":"IF(A139>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C138,$F$8),0)","v":1696.5544639919983},1,0]
[126,0,{"$f":"IF(A140>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C139,$F$8),0)","v":1716.9575121309163},1,0]
[127,0,{"$f":"IF(A141>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C140,$F$8),0)","v":1733.3363714123586},1,0]
[128,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A142)","v":0},{"$f":"IF(A142>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C141,$F$8),0)","v":1509.8031244898011},1,{"$f":"IF(A142>$B$6+$F$7,PotCap(C142,$J$6,$K$6,D142),\"\")","v":0}]
[129,0,{"$f":"IF(A143>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C142,$F$8),0)","v":1330.358388039622},{"$f":"IF(C143>(3600/$J$6),1,0)","v":1},0]
[130,0,{"$f":"IF(A144>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C143,$F$8),0)","v":1186.3063784035342},1,0]
[131,0,{"$f":"IF(A145>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C144,$F$8),0)","v":1070.6664221100443},1,0]
[132,0,{"$f":"IF(A146>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C145,$F$8),0)","v":977.83467664989507},1,0]
[133,0,{"$f":"IF(A147>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C146,$F$8),0)","v":903.31257164921135},1,0]
[134,0,{"$f":"IF(A148>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C147,$F$8),0)","v":843.48881086344704},1,0]
[135,0,{"$f":"IF(A149>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C148,$F$8),0)","v":795.46437094029238},1,0]
[136,0,{"$f":"IF(A150>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C149,$F$8),0)","v":756.91201649718118},1,0]
[137,0,{"$f":"IF(A151>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C150,$F$8),0)","v":725.96352369881583},1,0]
[138,0,{"$f":"IF(A152>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C151,$F$8),0)","v":701.11914725732413},1,0]
[139,0,{"$f":"IF(A153>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C152,$F$8),0)","v":681.17494368049756},1,0]
[140,0,{"$f":"IF(A154>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C153,$F$8),0)","v":665.16442889657264},1,0]
[141,0,{"$f":"IF(A155>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C154,$F$8),0)","v":652.31174301925239},1,0]
[142,0,{"$f":"IF(A156>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C155,$F$8),0)","v":641.99405264574079},1,0]
[143,0,{"$f":"IF(A157>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C156,$F$8),0)","v":515.37055523337415},0,466.17253361570454]
[144,0,{"$f":"IF(A158>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C157,$F$8),0)","v":413.72160397274126},0,531.89888126121707]
[145,0,{"$f":"IF(A159>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C158,$F$8),0)","v":332.12135201684004},0,590.8578086525041]
[146,0,{"$f":"IF(A160>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C159,$F$8),0)","v":266.61550039035762},0,642.56725148495593]
[147,0,{"$f":"IF(A161>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C160,$F$8),0)","v":214.02967504719936},0,687.11547525950857]
[148,0,{"$f":"IF(A162>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C161,$F$8),0)","v":171.81559861951095},0,724.95325477434824]
[149,0,{"$f":"IF(A163>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C162,$F$8),0)","v":137.92760243396529},0,756.7302504512752]
[150,1800,{"$f":"IF(A164>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C163,$F$8),0)","v":110.72349464213121},0,783.17786764619188]
[151,1800,{"$f":"IF(A165>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C164,$F$8),0)","v":88.884980594334294},0,805.0321095336119]
[152,1800,{"$f":"IF(A166>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C165,$F$8),0)","v":71.353779076342136},0,822.9872034307798]
[153,1800,{"$f":"IF(A167>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C166,$F$8),0)","v":57.280338640249134},0,837.67112240498034]
[154,1800,{"$f":"IF(A168>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C167,$F$8),0)","v":45.982668853897742},0,849.6356953369509]
[155,1800,{"$f":"IF(A169>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C168,$F$8),0)","v":36.913291456023089},0,859.35581638413919]
[156,1800,{"$f":"IF(A170>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C169,$F$8),0)","v":29.632709890039507},0,867.23388742147711]
[157,1800,{"$f":"IF(A171>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C170,$F$8),0)","v":23.788111566083803},0,873.6069104546807]
[158,1800,{"$f":"IF(A172>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C171,$F$8),0)","v":19.096270775784102},0,878.75458988217213]
[159,1800,{"$f":"IF(A173>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C172,$F$8),0)","v":15.329823745319711},0,882.90746151403039]
[160,1800,{"$f":"IF(A174>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C173,$F$8),0)","v":12.306250724124364},0,886.25450372626904]
[161,1800,{"$f":"IF(A175>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C174,$F$8),0)","v":9.8790311878992192},0,888.94996715306343]
[162,1800,{"$f":"IF(A176>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C175,$F$8),0)","v":7.9305435424102111},0,891.11933174761032]
[163,1800,{"$f":"IF(A177>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C176,$F$8),0)","v":6.3663652519998406},0,892.86440018780456]
[164,1800,{"$f":"IF(A178>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C177,$F$8),0)","v":5.1106971804801589},0,894.26759018529333]
[165,600,{"$f":"IF(A179>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C178,$F$8),0)","v":4.1026904107273952},0,895.39551285476136]
[166,600,{"$f":"IF(A180>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C179,$F$8),0)","v":3.2934975428720512},0,896.30193157583096]
[167,600,{"$f":"IF(A181>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C180,$F$8),0)","v":2.6439055787738748},0,897.03019326979404]
[168,600,{"$f":"IF(A182>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C181,$F$8),0)","v":2.1224356837916063},0,897.61521644721483]
[169,600,{"$f":"IF(A183>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C182,$F$8),0)","v":1.7038177414493891},0,898.08511064890786]
[170,600,{"$f":"IF(A184>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C183,$F$8),0)","v":1.3677657788393702},0,898.46249168155919]
[171,600,{"$f":"IF(A185>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C184,$F$8),0)","v":1.0979949206143651},0,898.76554727117798]
[172,600,{"$f":"IF(A186>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C185,$F$8),0)","v":0.88143223375420499},0,899.00889888127585]
[173,600,{"$f":"IF(A187>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C186,$F$8),0)","v":355.73002369850775},0,573.19801335408579]
[174,600,{"$f":"IF(A188>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C187,$F$8),0)","v":640.59016352893877},1,0]
[175,600,{"$f":"IF(A189>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C188,$F$8),0)","v":869.26600222751995},1,0]
[176,600,{"$f":"IF(A190>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C189,$F$8),0)","v":1052.8390329633323},1,0]
[177,600,{"$f":"IF(A191>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C190,$F$8),0)","v":1200.2050940448898},1,0]
[178,600,{"$f":"IF(A192>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C191,$F$8),0)","v":1318.5054558771615},1,0]
[179,600,{"$f":"IF(A193>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C192,$F$8),0)","v":1413.472882616627},1,0]
[180,0,{"$f":"IF(A194>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C193,$F$8),0)","v":1489.7094384633688},1,0]
[181,0,{"$f":"IF(A195>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C194,$F$8),0)","v":1550.9095009154989},1,0]
[182,0,{"$f":"IF(A196>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C195,$F$8),0)","v":1600.0387880736714},1,0]
[183,0,{"$f":"IF(A197>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C196,$F$8),0)","v":1639.4780755508389},1,0]
[184,0,{"$f":"IF(A198>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C197,$F$8),0)","v":1671.138567421988},1,0]
[185,0,{"$f":"IF(A199>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C198,$F$8),0)","v":1696.5545120204649},1,0]
[186,0,{"$f":"IF(A200>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C199,$F$8),0)","v":1716.9575506865033},1,0]
[187,0,{"$f":"IF(A201>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C200,$F$8),0)","v":1733.3364023634463},1,0]
[188,0,{"$f":"IF(A202>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C201,$F$8),0)","v":1509.8031493362605},1,0]
[189,0,{"$f":"IF(A203>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C202,$F$8),0)","v":1330.3584079854977},1,0]
[190,0,{"$f":"IF(A204>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C203,$F$8),0)","v":1186.3063944153912},1,0]
[191,0,{"$f":"IF(A205>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C204,$F$8),0)","v":1070.6664349638077},1,0]
[192,{"$f":"DepFlowi($B$9,$B$5,$B$4,$B$8,$B$7,A206)","v":0},{"$f":"IF(A206>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C205,$F$8),0)","v":977.83468696845034},1,{"$f":"IF(A206>$B$6+$F$7,PotCap(C206,$J$6,$K$6,D206),\"\")","v":0}]
[193,0,{"$f":"IF(A207>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C206,$F$8),0)","v":903.31257993258964},{"$f":"IF(C207>(3600/$J$6),1,0)","v":1},0]
[194,0,{"$f":"IF(A208>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C207,$F$8),0)","v":843.48881751305589},1,0]
[195,0,{"$f":"IF(A209>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C208,$F$8),0)","v":795.46437627836781},1,0]
[196,0,{"$f":"IF(A210>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C209,$F$8),0)","v":756.91202078240303},1,0]
[197,0,{"$f":"IF(A211>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C210,$F$8),0)","v":725.96352713884335},1,0]
[198,0,{"$f":"IF(A212>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C211,$F$8),0)","v":701.11915001885905},1,0]
[199,0,{"$f":"IF(A213>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C212,$F$8),0)","v":681.17494589736202},1,0]
[200,0,{"$f":"IF(A214>$F$7+$B$6,ArrFlow_j(INDIRECT(\"b\"&ROW()-INT($F$7)),C213,$F$8),0)","v":665.16443067619457},1,0]