{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Расчёт","Ветровые районы","К-т пространственной корреляции","Д.1 Аэродинамические коэф-ты"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":1,"defined_names":0,"comments":10,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Расчёт","index":0,"n_rows":121,"n_cols":14,"rows_kept":121,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Расчёт ветровых нагрузок по СП 20.13330.2011",null,null,"http://fordewind.org/"]
[null,"Исходные данные:",{"$nulls":7},"Основная система координат:"]
[null,"Ветровой район, кПа","Wo",0.3,"(II)",null,"Высота Z","Ze"]
[null,null,"α",0.2,null,null,0,20]
[null,"Тип местности","k10",0.65,"(B)",null,20,20]
[null,null,"ζ10",1.06,null,null,"от 20 до 55","от 20 до 55"]
[null,"Тип сооружения",null,"Здание",null,null,55,75]
[null,"Ширина, м","b или d",20,null,null,75,75]
[null,"Длина, м","a",20]
[null,"Высота здания, м","h",75]
[null,"Аэродинамический коэф-т","c",1.3]
[null,"Коэф-т пространственной \nкорреляции пульсации ветра","ν",0.68625]
[null,"Коэф-т динамичности","ξ",1,null,"(1÷3)",null,"ε",0.022263459271967656]
[null,"Первая собственная частота, Гц","f1",1.1]
[null,"Вторая собственная частота, Гц","f2",1.1]
[null,"Предельное значение \nсобственной частоты, Гц","fl",1.1,"(II, ж/б)"]
[null,"Коэф-т надёжности по нагрузке","γf",1.4]
[]
[null,"Z","Ze","k(Ze)","Wm","ζ (Ze)","Wp","W"]
[null,"м","м",null,"кПа",null,"кПа","кПа"]
[0,0,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[1,1,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[2,2,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[3,3,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[4,4,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[5,5,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[6,6,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[7,7,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[8,8,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[9,9,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[10,10,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[11,11,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[12,12,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[13,13,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[14,14,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[15,15,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[16,16,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319]
[17,17,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319,null,"Плита","Отметка","Z","W","q"]
[18,18,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319,null,"(этаж)","м","м","кПа","кН/м"]
[19,19,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319,null,null,null,0,0.7648449231569318]
[20,20,20,0.8576801420023813,0.4682933575333002,0.9227835970938916,0.2965515656236316,0.7648449231569319,null,"П1",3,"","",3.4418021542061927]
[21,21,21,0.8745830869761001,0.4775223654889506,0.9138228352619028,0.29945949027589225,0.7769818557648429,null,null,null,4.5,0.7648449231569318,""]
[22,22,22,0.8910096937447739,0.48649129278464653,0.9053600546616303,0.3022586638774065,0.788749956662053,null,"П2",6,"","",2.294534769470795]
[23,23,23,0.9069941607061659,0.49521881174556653,0.8973467579196167,0.30495783044274793,0.8001766421883145,null,null,null,7.5,0.7648449231569318,""]
[24,24,24,0.9225668669913217,0.5037215093772617,0.8897410271345109,0.30756468691943245,0.8112861962966942,null,"П3",9,"","",2.294534769470795]
[25,25,25,0.9377549388396889,0.5120141966064702,0.8825063998459856,0.31008604639893583,0.8221002430054061,null,null,null,10.5,0.7648449231569318,""]
[26,26,26,0.9525827128806498,0.5201101612328347,0.8756109734836615,0.312527970453886,0.8326381316867206,null,"П4",12,"","",2.294534769470795]
[27,27,27,0.9670721183005022,0.5280213765920742,0.8690266850001084,0.314895877391804,0.8429172539838782,null,null,null,13.5,0.7648449231569318,""]
[28,28,28,0.9812429945530565,0.5357586750259689,0.8627287263068609,0.31719463152855004,0.852953306554519,null,"П5",15,"","",2.294534769470795]
[29,29,29,0.995113357382165,0.5433318931306621,0.8566950660541347,0.3194286173613937,0.8627605104920558,null,null,null,16.5,0.7648449231569318,""]
[30,30,30,1.0086996230449838,0.5507499941825612,0.8509060554658445,0.32160180162331037,0.8723517958058715,null,"П6",18,"","",2.294534769470795]
[31,31,31,1.0220167984684232,0.558021171963759,0.8453441011893448,0.32371778553252806,0.8817389574962871,null,null,null,19.5,0.7648449231569318,""]
[32,32,32,1.0350786434390928,0.5651529393177447,0.8399933920043902,0.3257798490497765,0.8909327883675212,null,"П7",21,"","",2.339023971535106]
[33,33,33,1.0478978096793625,0.5721522040849318,0.8348396691430187,0.3277909885749808,0.8999431926599126,null,null,null,22.5,0.7945043911998056,""]
[34,34,34,1.060485960699516,0.5790253345419357,0.8298700321693155,0.32975394922342194,0.9087792837653577,null,"П8",24,"","",2.432860453126999]
[35,35,35,1.0728538755668424,0.585778216059496,0.8250727740442411,0.33167125259586683,0.9174494686553628,null,null,null,25.5,0.8274025775515269,""]
[36,36,36,1.085011539144804,0.5924163003730629,0.820437240290611,0.33354522078138243,0.9259615211544454,null,"П9",27,"","",2.5279308835836622]
[37,37,37,1.0969682208908682,0.598944648606414,0.8159537081740891,0.33537799719345657,0.9343226457998706,null,null,null,28.5,0.8578846781709145,""]
[38,38,38,1.1087325439317672,0.6053679689867449,0.8116132825984506,0.33717156473077464,0.9425395337175195,null,"П10",30,"","",2.6163661182454296]
[39,39,39,1.1203125458385763,0.6116906500278627,0.8074078060295014,0.3389277616669477,0.9506184116948104,null,null,null,31.5,0.886359400659372,""]
[40,40,40,1.1317157322849614,0.6179167898275889,0.803329780250511,0.34064829560366094,0.9585650854312499,null,"П11",33,"","",2.699241022850674]
[41,41,41,1.1429491245780476,0.624050222019614,0.7993722981418093,0.3423347557653964,0.9663849777850104,null,null,null,34.5,0.9131346145744108,""]
[42,42,42,1.1540193018931422,0.6300945388336556,0.7955289839901105,0.3439886238681679,0.9740831627018236,null,"П12",36,"","",2.7773750016000744]
[43,43,43,1.164932438913776,0.6360531116469217,0.7917939410857928,0.3456112837574101,0.9816643954043318,null,null,null,37.5,0.9384487198256389,""]
[44,44,44,1.175694339471563,0.6419291093514734,0.7881617055714918,0.34720402997957855,0.989133139331052,null,"П13",39,"","",2.8514089112671814]
[45,45,45,1.1863104666917514,0.6477255148136962,0.784627205672765,0.3487680754268022,0.9964935902404984,null,null,null,40.5,0.9624905543524821,""]
[46,46,46,1.1967859700766077,0.6534451396618277,0.7811857255788729,0.35030455817304923,1.003749697834877,null,"П14",42,"","",2.921854671859821]
[47,47,47,1.2071257098971502,0.659090637603844,0.7778328733548436,0.35181454760290254,1.0109051852067465,null,null,null,43.5,0.9854125602207318,""]
[48,48,48,1.2173342792120136,0.6646645164497594,0.7745645523596205,0.35329904991953015,1.0179635663692896,null,"П15",45,"","",2.9891285324048997]
[49,49,49,1.2274160237886653,0.6701691489886114,0.7713769357229165,0.3547590131062694,1.0249281620948807,null,null,null,46.5,1.0073397947158682,""]
[50,50,50,1.237375060165321,0.6756067828502653,0.7682664434983573,0.35619533140599174,1.031802114256257,null,"П16",48,"","",3.0535741103909495]
[51,51,51,1.247215292060626,0.6809795494651018,0.7652297221649219,0.3576088493737603,1.038588398838862,null,null,null,49.5,1.0283762788780983,""]
[52,52,52,1.2569404253115222,0.6862894722200912,0.762263626194469,0.35900036555094084,1.045289837771032,null,"П17",51,"","",3.1154787920933944]
[53,53,53,1.2665539814969364,0.6915384738973273,0.7593652014417713,0.36037063580267836,1.0519091097000057,null,null,null,52.5,1.048609582517498,""]
[54,54,54,1.276059310385413,0.6967283834704354,0.7565316701462077,0.3617203763553133,1.0584487598257488,null,"П18",54,"","",3.344190493867927]
[55,55,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,55.5,1.1808507467277867,""]
[56,56,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,"П19",57,"","",3.54255224018336]
[57,57,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,58.5,1.1808507467277867,""]
[58,58,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,"П20",60,"","",3.54255224018336]
[59,59,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,61.5,1.1808507467277867,""]
[60,60,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,"П21",63,"","",3.54255224018336]
[61,61,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,64.5,1.1808507467277867,""]
[62,62,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,"П22",66,"","",3.54255224018336]
[63,63,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,67.5,1.1808507467277867,""]
[64,64,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,"П23",69,"","",3.54255224018336]
[65,65,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,70.5,1.1808507467277867,""]
[66,66,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,"П24",72,"","",2.9521268668194667]
[67,67,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,73,1.1808507467277867,""]
[68,68,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,"П25",74,"","",2.3617014934555733]
[69,69,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867,null,null,null,75,1.1808507467277867]
[70,70,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867]
[71,71,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867]
[72,72,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867]
[73,73,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867]
[74,74,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867]
[75,75,75,1.4552508512556401,0.7945669647855794,0.7084245656757651,0.38628378194220714,1.1808507467277867]
[76,"","","","","","",""]
[77,"","","","","","",""]
[78,"","","","","","",""]
[79,"","","","","","",""]
[80,"","","","","","",""]
[81,"","","","","","",""]
[82,"","","","","","",""]
[83,"","","","","","",""]
[84,"","","","","","",""]
[85,"","","","","","",""]
[86,"","","","","","",""]
[87,"","","","","","",""]
[88,"","","","","","",""]
[89,"","","","","","",""]
[90,"","","","","","",""]
[91,"","","","","","",""]
[92,"","","","","","",""]
[93,"","","","","","",""]
[94,"","","","","","",""]
[95,"","","","","","",""]
[96,"","","","","","",""]
[97,"","","","","","",""]
[98,"","","","","","",""]
[99,"","","","","","",""]
[100,"","","","","","",""]

{"sheet":"Ветровые районы","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,7,1,9],[0,6,0,9],[0,1,0,2],[0,3,0,4]],"flags":["formulas_cached_only"]}
[null,"Таблица 11.1",null,"Таблица 11.5",null,null,"Таблица 11.3"]
[null,"Ветровой \nрайон","Wo, кПа","f1, Гц \nδ=0,3","f1, Гц \nδ=0,15",null,"Парам.","Тип местности"]
[null,"Ia",0.17,0.85,2.6,null,null,"A","B","C"]
[null,"I",0.23,0.95,2.9,null,"α",0.15,0.2,0.25]
[null,"II",0.3,1.1,3.4,null,"k10",1,0.65,0.4]
[null,"III",0.38,1.2,3.8,null,"ζ10",0.76,1.06,1.78]
[null,"IV",0.48,1.4,4.3]
[null,"V",0.6,1.6,5]
[null,"VI",0.73,1.7,5.6]
[null,"VII",0.85,1.9,5.9]
[]
[]
[null,"По формуле 11.4",{"$nulls":4},"По формуле 11.6"]
[null,"Коэффициент k для типов местности",{"$nulls":4},"Коэффициент пульсаций давления ветра"]
[null,"ze, м","A","B","C",null,"ze, м","A","B","C"]
[null,5,0.8122523963562355,0.4926078841158794,0.28284271247461906,null,5,0.8432727987715622,1.2176202562968572,2.1167886647048433]
[null,10,1,0.65,0.4,null,10,0.76,1.06,1.78]
[null,20,1.2311444133449163,0.8576801420023813,0.5656854249492381,null,20,0.684950351584231,0.9227835970938916,1.496795619151612]
[null,40,1.515716566510398,1.1317157322849614,0.8,null,40,0.617311821230739,0.803329780250511,1.2586500705120547]
[null,60,1.711769859409705,1.3309871322014926,0.9797958971132712,null,60,0.5808859934486277,0.740756745897874,1.137318725558365]
[null,80,1.8660659830736148,1.4933078614961457,1.1313708498984762,null,80,0.5563525644593377,0.6993391927096341,1.0583943323524216]
[null,100,1.9952623149688797,1.6327261804812274,1.264911064067352,null,100,0.5380387961319448,0.6688147851490048,1.0009675588388214]

{"sheet":"К-т пространственной корреляции","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,8],[2,1,3,1]],"flags":["formulas_cached_only"]}
[]
[null,"Таблица 11.6"]
[null,"ρ, м","Коэффициенты ν при χ, м, равном",{"$nulls":8},"ZOY","ZOX","XOY"]
[null,null,5,10,20,40,80,160,350]
[null,0,0.95,0.92,0.88,0.83,0.76,0.67,0.56,null,"ρ",20,8,20]
[null,5,0.89,0.87,0.84,0.8,0.73,0.65,0.54,null,"χ",75,75,20]
[null,10,0.85,0.84,0.81,0.77,0.71,0.64,0.53]
[null,20,0.8,0.78,0.76,0.73,0.68,0.61,0.51,null,"ν",0.68625,0.726,0.76]
[null,40,0.72,0.72,0.7,0.67,0.63,0.57,0.48]
[null,80,0.63,0.63,0.61,0.59,0.56,0.51,0.44]
[null,160,0.53,0.53,0.52,0.5,0.47,0.44,0.38]

{"sheet":"Д.1 Аэродинамические коэф-ты","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}