ASCE7-05风荷载计算EXCEL表格

ASCE705W---ASCE7-05CODEWINDANALYSISPROGRAMProgramDescription:ASCE705WisaspreadsheetprogramwritteninMS-ExcelforthepurposeofwindloadinganalysisforbuildingsandstructurespertheASCE7-05Code.Specifically,windpressurecoefficientsandrelatedandrequiredparametersareselectedorcalculatedinordertocomputethenetdesignwindpressures.Thisprogramisaworkbookconsistingofnine(9)worksheets,describedasfollows:WorksheetNameDescriptionDocThisdocumentationsheetSimplifiedAnalysisusingsimplifiedmethodforlow-risebuildingswithh=60’MWFRS(Low-Rise)MainWind-ForceResistingSystemforlow-risebuildingswithh=60’MWFRS(AnyHt.)MainWind-ForceResistingSystemforbuildingsofanyheightWallC&CAnalysisofwallComponentsandCladdingRoofC&CAnalysisofroofComponentsandCladdingStacks&TanksAnalysisofcantileveredchimneys,stacks,andverticaltanksOpenStructures(noroof)AnalysisofopenstructureswithoutroofsWindMapBasicwindspeedmap(Figure6-1ofASCE7-05Code)ProgramAssumptionsandLimitations:1.WorksheetforSimplifiedanalysisisapplicableforlow-risebuildingsmeetingthecriteriaofSection6.4.1.2.IntheworksheetforSimplifiedanalysis,thedesignMWFRSwindloadiscalculatedforeachdirection.ThedesignMWFRSloadisassumedtobethetotalwindloadoneitherthewidthorthelengthofthebuildingrespectively.3.WorksheetforMWFRS(Low-Rise)isapplicableforlow-risebuildingsasdefinedinSection6.2.4.WorksheetsforMWFRS(AnyHt.),WallC&C,andRoofC&Careapplicableforbuildingswithmeanroofheightsofupto500feet.5.InworksheetsforMWFRS(AnyHt.),WallC&C,andRoofC&Ctheusermayopttoutilizeuserdesignatedstepsinheight,'z',indeterminingthewindpressuredistribution.6.WorksheetsforMWFRS(AnyHt.),Stacks&Tanks,andOpenStructurescanhandle“rigid”aswellas“flexible”buildingsandstructures.For“rigid”buildingsorstructures,thisprogramusesthesmallervalueofeither0.85orthecalculatedvaluefromSection6.5.8.1oftheCodeforthegusteffectfactor,'G'.For“flexible”buildingsorstructures,thisprogramcalculatesthegusteffectfactor,‘Gf’,perSection6.5.8.2oftheCodebasedontheassumedformulaforthefundamentalperiodofvibrationfromSection12.8.2.1oftheCode,wheretheexponent'x'intheformulaT=Ct*h^xisassumedtobe0.75.7.WorksheetsforWallC&CandRoofC&Careapplicableforflatroofbuildings,gableroofbuildingswithroofangles=45degrees,andmonosloperoofbuildingswithroofangles=3degrees.8.WorksheetforStacks&Tanksisapplicableforcantileveredstructuresupto600feettall.9.WorksheetforOpenStructuresisapplicableforopenstructureswithoutroofsupto500feettall.Thiscanbeutilizedforopenprocess-typestructuresaswellaspipe/utilityracksandbridges.10.Thisprogramusestheequationslistedinthereference,“GuidetotheUseoftheWindLoadProvisionsofASCE7-02”fordeterminingtheexternalwindpressurecoefficients,‘GCp’,usedintheWallC&CandRoofC&Cworksheets.(Note:aversionofthisdocumentapplicabletotheASCE7-05Codewasnotavailable.)11.Thisprogramcontainsnumerous“commentboxes”whichcontainawidevarietyofinformationincludingexplanationsofinputoroutputitems,equationsused,datatables,etc.(Note:presenceofa“commentbox”isdenotedbya“redtriangle”intheupperright-handcornerofacell.Merelymovethemousepointertothedesiredcelltoviewthecontentsofthatparticularcommentbox.)ASCE705W.xlsProgramVersion1.1WINDLOADINGANALYSIS-MWFRSandComponents/CladdingPerASCE7-05CodeforLow-Rise,EnclosedBuildingswithh=60'andRoofq=45oUsingMethod1:SimplifiedProcedure(Section6.4)JobName:Subject:JobNumber:Originator:Checker:MainWindForceResistingSystem-Method1InputData:WindSpeed,V=90mph(WindMap,Figure6-1)EnclosedBuildingsBldg.Classification=II(Table1-1OccupancyCategory)SimplifiedDesignWindPressure,ps30(psf)(ExposureBath=30ft.withIw=1.0)ExposureCategory=B(Sect.6.5.6)RidgeHeight,hr=19.00ft.(hr=he)EaveHeight,he=15.00ft.(he=hr)BuildingWidth,W=41.00ft.(NormaltoBuildingRidge)BuildingLength,L=61.00ft.(ParalleltoBuildingRidge)RoofType=Monoslope(GableorMonoslope)Topo.Factor,Kzt=1.00(Sect.6.5.7&Figure6-4)PlanWallC&CName=Wall(Girt,Siding,Wall,orFastener)WallC&CEff.Area=75.00ft.^2(forComponent/Cladding)RoofC&CName=Joist(Purlin,Joist,Decking,orFastener)RoofC&CEff.Area=205.00ft.^2(forComponent/Cladding)OverhangEff.Area=0.00ft.^2(forComponent/Cladding)HurricaneRegion?NResultingParametersandNetDesignPressures:ForTransverseDirection:(windperpendiculartoridge)ElevationRoofAngle,q=5.57deg.MeanRoofHt.,h=15.00ft.(h=heforq10deg.)AdjustmentFactor,l=1.000(adjustsforheightandexposure)ImportanceFactor,I=1.00(Table6-1)Wall&RoofEndZoneWidth,a=4.100ft.(use:2*aforMWFRS,aforC&C)TransverseMWFRSNetPressures,ps(psf)ps=l*Kzt*I*ps30LocationDirectionZoneLoadCase1LoadCase2(ps30fromFig.6-2)A=endzoneofwallHorizontalA12.99---B=endzoneofroofHorizontalB0.00---C=interiorzoneofwallHorizontalC8.63---D=interiorzoneofroofHorizontalD0.00---E=endzoneofwindwardroofVerticalE-15.40---F=endzoneofleewardroofVerticalF-8.87---G=interiorzoneofwindwardroofVerticalG-10.70---H=interiorzoneofleewardroofVerticalH-6.85---ForLongitudinalDirection:(windparalleltoridge)RoofAngle,q=0.00deg.(assumed)MeanRoofHt.,h=17.00ft.(h=(hr+he)/2)AdjustmentFactor,l=1.000(adjustsforheightandexposure)LongitudinalMWFRSNetPressures,ps(psf)ps=l*Kzt*I*ps30LocationDirectionZoneL