{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Расчет1","Расчеты (Скрытые)"],"not_rendered":{"charts":0,"images":3,"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":"Расчет1","index":0,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[34,1,36,2],[33,1,33,2],[33,3,33,4],[33,5,33,6],[33,7,33,8],[50,4,52,4],[50,6,52,6],[50,8,52,8],[13,1,13,8],[14,1,15,4],[39,2,41,2],[50,2,52,2],[39,4,41,4],[39,6,41,6],[24,1,24,8],[39,8,41,8],[44,2,46,2],[44,4,46,4],[44,6,46,6],[44,8,46,8],[2,1,2,8],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8]]}
[]
[]
[null,"Введите параметры рассчитываемого перекрестка:"]
[]
[null,"Подъезд №1",null,"Подъезд №2",null,"Подъезд №3",null,"Подъезд №4"]
[null,"Nлев1=",246,"Nлев2=",282,"Nлев=",379,"Nлев=",68]
[null,"Nпрям1=",379,"Nпрям2=",348,"Nпрям=",302,"Nпрям=",524]
[null,"Nправ1=",350,"Nправ2=",21,"Nправ=",34,"Nправ=",20]
[null,"x1=",12,"x2=",13,"x3=",14,"x4=",15]
[null,"L1=",21,"L2=",22,"L3=",23,"L4=",19]
[null,"Vавт прям1=",40,"Vавт прям2=",{"$f":"C11","v":40},"Vавт прям=",{"$f":"C11","v":40},"Vавт прям=",{"$f":"C11","v":40}]
[null,"Vавт поворот1=",25,"Vавт поворот2=",{"$f":"C12","v":25},"Vавт поворот=",{"$f":"C12","v":25},"Vавт поворот="]
[null,"Радиус поворота=",35,"Радиус поворота=",35,"Радиус поворота=",24,"Радиус поворота=",35]
[null,"Выберите ширину полосы движения на подъезде к перекрестку"]
[null,"Для выбора соответствубщей ширины поставьте 1 в соседюю ячейку"]
[]
[null,"Ширина, м"]
[null,3,null,3,null,3,null,3,1]
[null,3.5,null,3.5,1,3.5,1,3.5,0]
[null,3.75,1,3.75,null,3.75,null,3.75]
[null,4.2,null,4.2,null,4.2,null,4.2]
[null,4.8,null,4.8,null,4.8,null,4.8]
[null,5,null,5,null,5,null,5]
[]
[null,"Постоянные параметры для расчета:"]
[null,"Aавт=",5]
[]
[]
[]
[]
[]
[]
[]
[null,"Подъезд №1",null,"Подъезд №2",null,"Подъезд №3",null,"Подъезд №4"]
[null,"Направления движения по полосам на перекрестке"]
[]
[]
[null,"Вариант № 1"]
[]
[null,null,1]
[]
[]
[]
[null,"Вариант № 2"]
[null,null,0,null,1,null,null,null,1]
[]
[]
[]
[null,"Вариант № 3"]
[]
[null,null,0]
[]
[]
[]
[null,"Вариант № 4"]

{"sheet":"Расчеты (Скрытые)","index":1,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[19,1,19,2],[34,1,34,2],[48,1,48,2],[62,1,62,2],[16,1,18,2]]}
[]
[]
[]
[null,"Определение потоков насыщения"]
[null,"Подъезд №1",null,"Подъезд №2",null,"Подъезд №3",null,"Подъезд №4"]
[null,1850,{"$f":"B6*Расчет1!C18","v":0},1850,{"$f":"D6*Расчет1!E18","v":0},1850,{"$f":"F6*Расчет1!G18","v":0},1850,{"$f":"H6*Расчет1!I18","v":1850}]
[null,1920,{"$f":"B7*Расчет1!C19","v":0},1920,{"$f":"D7*Расчет1!E19","v":1920},1920,{"$f":"F7*Расчет1!G19","v":1920},1920,{"$f":"H7*Расчет1!I19","v":0}]
[null,1970,{"$f":"B8*Расчет1!C20","v":1970},1970,{"$f":"D8*Расчет1!E20","v":0},1970,{"$f":"F8*Расчет1!G20","v":0},1970,{"$f":"H8*Расчет1!I20","v":0}]
[null,2075,{"$f":"B9*Расчет1!C21","v":0},2075,{"$f":"D9*Расчет1!E21","v":0},2075,{"$f":"F9*Расчет1!G21","v":0},2075,{"$f":"H9*Расчет1!I21","v":0}]
[null,2475,{"$f":"B10*Расчет1!C22","v":0},2475,{"$f":"D10*Расчет1!E22","v":0},2475,{"$f":"F10*Расчет1!G22","v":0},2475,{"$f":"H10*Расчет1!I22","v":0}]
[null,2700,{"$f":"B11*Расчет1!C23","v":0},2700,{"$f":"D11*Расчет1!E23","v":0},2700,{"$f":"F11*Расчет1!G23","v":0},2700,{"$f":"H11*Расчет1!I23","v":0}]
[null,"Сумм",{"$f":"SUM(C6:C11)","v":1970},null,{"$f":"SUM(E6:E11)","v":1920},null,{"$f":"SUM(G6:G11)","v":1920},null,{"$f":"SUM(I6:I11)","v":1850}]
[null,{"$f":"C12","v":1970},{"$f":"C12","v":1970},{"$f":"E12","v":1920},{"$f":"E12","v":1920},{"$f":"G12","v":1920},{"$f":"G12","v":1920},{"$f":"I12","v":1850},{"$f":"I12","v":1850}]
[]
[null,"Расчет интенсивнотей, коэффициентов M и Y"]
[null,"Подъезд №1",null,"Подъезд №2",null,"Подъезд №3",null,"Подъезд №4"]
[null,"Направления движения по полосам на перекрестке"]
[]
[]
[null,"Вариант № 1"]
[null,"Лев,%","Пр%"]
["прямо-Ni",{"$f":"Расчет1!C7/2","v":189.5},{"$f":"Расчет1!C7/2","v":189.5},{"$f":"Расчет1!E7/2","v":174},{"$f":"Расчет1!E7/2","v":174},{"$f":"Расчет1!G7/2","v":151},{"$f":"Расчет1!G7/2","v":151},{"$f":"Расчет1!I7/2","v":262},{"$f":"Расчет1!I7/2","v":262}]
["налево-Ni",{"$f":"Расчет1!C6","v":246},{"$f":"0","v":0},{"$f":"Расчет1!E6","v":282},{"$f":"0","v":0},{"$f":"Расчет1!G6","v":379},{"$f":"0","v":0},{"$f":"Расчет1!I6","v":68},{"$f":"0","v":0}]
["право-Ni",{"$f":"0","v":0},{"$f":"Расчет1!C8","v":350},{"$f":"0","v":0},{"$f":"Расчет1!E8","v":21},{"$f":"0","v":0},{"$f":"Расчет1!G8","v":34},{"$f":"0","v":0},{"$f":"Расчет1!I8","v":20}]
["Сумм",{"$f":"SUM(B22:B24)","v":435.5},{"$f":"SUM(C22:C24)","v":539.5},{"$f":"SUM(D22:D24)","v":456},195,530,185,330,282]
["прямо-a",{"$f":"ROUND(B22/(B22+B23+B24)*100,0)","v":44},35,38,89,28,82,79,93]
["налево-b",{"$f":"ROUND(B23/(B22+B23+B24)*100,0)","v":56},0,62,0,72,0,21,0]
["право-c",{"$f":"ROUND(B24/(B22+B23+B24)*100,0)","v":0},65,0,11,0,18,0,7]
[null,"Лев,%","Пр%"]
["Mhij",{"$f":"(B13*100)/(B26+1.75*B27+1.25*B28)","v":1387.3239436619717},{"$f":"(C13*100)/(C26+1.75*C27+1.25*C28)","v":1694.6236559139784},{"$f":"(D13*100)/(D26+1.75*D27+1.25*D28)","v":1310.5802047781569},1868.6131386861314,1246.7532467532467,1837.3205741626793,1598.2721382289417,1818.1818181818182]
["yi",{"$f":"B25/B30","v":0.31391370558375636},{"$f":"C25/C30","v":0.31835977157360407},{"$f":"D25/D30","v":0.34793750000000001},0.10435546875,0.42510416666666667,0.10069010416666667,0.20647297297297298,0.15509999999999999]
["Yподъезд",{"$f":"MAX(B31:C31)*Расчет1!$C40","v":0.31835977157360407},null,{"$f":"MAX(D31:E31)*Расчет1!$E40","v":0},null,{"$f":"MAX(F31:G31)*Расчет1!$G40","v":0},null,{"$f":"MAX(H31:I31)*Расчет1!$I40","v":0}]
[]
[]
[null,"Вариант № 2"]
[null,"Лев,%","Пр%"]
["прямо-Ni",{"$f":"Расчет1!C7/2","v":189.5},{"$f":"Расчет1!$C$7/2","v":189.5},{"$f":"Расчет1!E7/2","v":174},{"$f":"Расчет1!E7/2","v":174},{"$f":"Расчет1!G7/2","v":151},{"$f":"Расчет1!G7/2","v":151},{"$f":"Расчет1!I7/2","v":262},{"$f":"Расчет1!I7/2","v":262}]
["налево-Ni",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
["право-Ni",{"$f":"0","v":0},{"$f":"Расчет1!$C$8","v":350},{"$f":"0","v":0},{"$f":"Расчет1!E8","v":21},{"$f":"0","v":0},{"$f":"Расчет1!G8","v":34},{"$f":"0","v":0},{"$f":"Расчет1!I8","v":20}]
["Сумм",{"$f":"SUM(B37:B39)","v":189.5},{"$f":"SUM(C37:C39)","v":539.5},{"$f":"SUM(D37:D39)","v":174},195,151,185,262,282]
["прямо-a",{"$f":"ROUND(B37/(B37+B38+B39)*100,0)","v":100},35,{"$f":"ROUND(D37/(D37+D38+D39)*100,0)","v":100},89,100,82,100,93]
["налево-b",{"$f":"ROUND(B38/(B37+B38+B39)*100,0)","v":0},0,{"$f":"ROUND(D38/(D37+D38+D39)*100,0)","v":0},0,0,0,0,0]
["право-c",{"$f":"ROUND(B39/(B37+B38+B39)*100,0)","v":0},65,{"$f":"ROUND(D39/(D37+D38+D39)*100,0)","v":0},11,0,18,0,7]
[null,"Лев,%","Пр%"]
["Mhij",{"$f":"525*Расчет1!C9","v":6300},{"$f":"(C13*100)/(C41+1.75*C42+1.25*C43)","v":1694.6236559139784},{"$f":"525*Расчет1!E9","v":6825},{"$f":"(E13*100)/(E41+1.75*E42+1.25*E43)","v":1868.6131386861314},{"$f":"525*Расчет1!G9","v":7350},{"$f":"(G13*100)/(G41+1.75*G42+1.25*G43)","v":1837.3205741626793},{"$f":"525*Расчет1!I9","v":7875},{"$f":"(I13*100)/(I41+1.75*I42+1.25*I43)","v":1818.1818181818182}]
["yi",{"$f":"B40/B45","v":3.0079365079365081E-2},{"$f":"C40/C45","v":0.31835977157360407},{"$f":"D40/D45","v":2.5494505494505496E-2},0.10435546875,2.0544217687074831E-2,0.10069010416666667,3.3269841269841269E-2,0.15509999999999999]
["Yподъезд",{"$f":"MAX(B46:C46)*Расчет1!C45","v":0},null,{"$f":"MAX(D46:E46)*Расчет1!E45","v":0.10435546875},null,{"$f":"MAX(F46:G46)*Расчет1!G45","v":0},null,{"$f":"MAX(H46:I46)*Расчет1!I45","v":0.15509999999999999}]
[]
[null,"Вариант №3"]
[null,"Лев,%","Пр%"]
["прямо-Ni",{"$f":"0","v":0},{"$f":"Расчет1!C7/2","v":189.5},{"$f":"0","v":0},{"$f":"Расчет1!E7/2","v":174},{"$f":"0","v":0},{"$f":"Расчет1!G7/2","v":151},{"$f":"0","v":0},{"$f":"Расчет1!I7/2","v":262}]
["налево-Ni",{"$f":"Расчет1!C6","v":246},{"$f":"0","v":0},{"$f":"Расчет1!E6","v":282},{"$f":"0","v":0},{"$f":"Расчет1!G6","v":379},{"$f":"0","v":0},{"$f":"Расчет1!I6","v":68},{"$f":"0","v":0}]
["право-Ni",{"$f":"0","v":0},{"$f":"Расчет1!C8","v":350},{"$f":"0","v":0},{"$f":"Расчет1!E8","v":21},{"$f":"0","v":0},{"$f":"Расчет1!G8","v":34},{"$f":"0","v":0},{"$f":"Расчет1!I8","v":20}]
["Сумм",{"$f":"SUM(B51:B53)","v":246},{"$f":"SUM(C51:C53)","v":539.5},{"$f":"SUM(D51:D53)","v":282},195,379,185,68,282]
["прямо-a",{"$f":"ROUND(B51/(B51+B52+B53)*100,0)","v":0},35,{"$f":"ROUND(D51/(D51+D52+D53)*100,0)","v":0},89,0,82,0,93]
["налево-b",{"$f":"ROUND(B52/(B51+B52+B53)*100,0)","v":100},0,{"$f":"ROUND(D52/(D51+D52+D53)*100,0)","v":100},0,100,0,100,0]
["право-c",{"$f":"ROUND(B53/(B51+B52+B53)*100,0)","v":0},65,{"$f":"ROUND(D53/(D51+D52+D53)*100,0)","v":0},11,0,18,0,7]
[null,"Лев,%","Пр%"]
["Mhij",{"$f":"3000/(1+1.525/Расчет1!C13)","v":2874.7433264887063},{"$f":"(C13*100)/(C55+1.75*C56+1.25*C57)","v":1694.6236559139784},{"$f":"3000/(1+1.525/Расчет1!E13)","v":2874.7433264887063},{"$f":"(E13*100)/(E55+1.75*E56+1.25*E57)","v":1868.6131386861314},{"$f":"3000/(1+1.525/Расчет1!G13)","v":2820.7639569049952},{"$f":"(G13*100)/(G55+1.75*G56+1.25*G57)","v":1837.3205741626793},{"$f":"3000/(1+1.525/Расчет1!I13)","v":2874.7433264887063},{"$f":"(I13*100)/(I55+1.75*I56+1.25*I57)","v":1818.1818181818182}]
["yi",{"$f":"B54/B59","v":8.5572857142857145E-2},{"$f":"C54/C59","v":0.31835977157360407},{"$f":"D54/D59","v":9.8095714285714286E-2},0.10435546875,0.13436076388888887,0.10069010416666667,2.3654285714285714E-2,0.15509999999999999]
["Yподъезд",{"$f":"MAX(B60:C60)*Расчет1!C51","v":0},null,{"$f":"MAX(D60:E60)*Расчет1!E51","v":0},null,{"$f":"MAX(F60:G60)*Расчет1!G51","v":0},null,{"$f":"MAX(H60:I60)*Расчет1!I51","v":0}]
[]
[null,"Вариант №3"]
[null,"Лев,%","Пр%"]