{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["robertson model"],"not_rendered":{"charts":3,"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":"robertson model","index":0,"n_rows":214,"n_cols":16,"rows_kept":214,"cut":false,"hidden":false,"merged":[]}
["Flow Profile at downstream signal  (minor TH movement)"]
[]
["Given Data",null,null,null,"Robertson Model",null,null,null,"Movement","tc","tf",null,"Calculations"]
["C",60,"sec",null,"Distance",1000,"ft",null,"MajorLT",4.0999999999999996,2.2000000000000002,null,"Sum departed vehicles",null,null,{"$f":"SUM(B44:B103)/3600","v":10}]
["G",30,"sec",null,"Speed",25,"mi/hr",null,"MinorRT",6.2,3.3,null,"Sum arrived vehicles",null,null,{"$f":"SUM(C68:C127)/3600","v":9.5978181204998734}]
["R",{"$f":"B4-B5","v":30},"sec",null,"tR",{"$f":"(F4)/(1.47*F5)","v":27.210884353741495},"sec",null,"MinorTH",6.5,4,null,"Blocked intervals",null,null,29]
["SatFlow",1800,"veh/hr-g",null,"tprime",{"$f":"tprime(F6,F8)","v":23.390782312925168},"sec",null,"MinorLT",7.1,3.5,null,"Blocked proportion",null,null,{"$f":"P6/60","v":0.48333333333333334}]
["ArrFlow",600,"veh/hr",null,"F",{"$f":"F(F6)","v":0.19723468915410469},null,null,null,null,null,null,"Available proportion",null,null,{"$f":"1-P7","v":0.51666666666666661}]
["gq",{"$f":"(B8*B6)/(B7-B8)","v":15},"sec"]
["gu",{"$f":"B5-B9","v":15},"sec"]
[]
[]
["Time i","DepFlowi","ArrFlowj","Blocked?"]
[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}]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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}]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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}]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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}]
[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]
[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]
[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]
[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]
[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]
[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]
[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]