IBC section 2902.3.2 states the path to travel to facilities shall not exceed a distance of 500 ft, but then in the next paragraph there is an Exception stating the maximum distance can be exceeded if approved.
The building in question has expanded multiple times and now the path to travel to...
I am trying to create a template that once a few cells are filled in the user can run a macro and auto populate specific named sheets to enter specific info.
To use this spreadsheet the user is required to enter specifics (Series/Chute#) in Cells A2&B2,A3&B3.... within the summary sheet then...
I would like to modify the following code so I don’t need to step into and edit the sheet names every time I use it. Currently I step into the vba and change the sheet name to one of the 10 sheet names within the workbook(W-shape in 3 places as shown highlighted below for this example). Is there...
I have used this coding bellow in the past but now I am getting a Compile error. looking for some guidance how to change this coding to get around the compile error.
Sub Sendoffice365invoice()
Dim myItem As Outlook.MailItem
Dim myolApp As Outlook.Application
Dim myRecipient As Recipient...
To resist uplift to a footing that sits directly on solid granite my customer plans on drilling a 5.5" diameter hole, 10 feet deep with 2 #8 rebars embedded into the hole with 4000 psi concrete.I came accross equation 10.8.3.5.4b-1 on page 10-137 of 2012 AASHTO book to calculate to calculate the...
I want to create a macro within outlook that allows me to send emails with meeting invites every Tuesday between 9:00-9:30. The code I wrote in the VBA doesn't work and I think its a problem with the 11th line (.When = "Tuesdays 9:00-9:30") and 12th line (.To =...
I have a data validation list (pull down) in cell A2. What I would like to do is use an if statement [=IF(A1="YES",Pull Down List,"")]. forcing cell A2 to have a pull down if A1 says YES and a blank cell if A1 says no. Is there a tool or formula to replace the verbiage Pull Down List in my...
I plan on taking the SE Exam in October and looking for advice on study materials as I will be choosing the buildings modules. PPI has ton of reference materials see list below of just some references available.
I am looking for advice on study/reference materials.
1.Structural Engineering...
I am trying to take two criteria values to pick a value from a table. My table values range from I3:M326. First criteria is in cells C3 to match value from table I3:I326. Second criteria is in cells D3 to match value from table J3:J326. The results I want to obtain need to go in cell F3 from...
What type of equipment is available to perform in field vibration test on steel and concrete structures. These structures would support heavy vibrating machinery (Screens, Crushers....). Looking into meters for individual support member frequencies and overall structure frequencies.
I would like to know how others approach calculating/ applying soil loads to structural support members located within granular stockpiles. I am also looking for reference material for these types of designs.
I apply the Rankine active force the full height of the support member located in the...
I have an 18" square concrete column that has very little uplift and shear forces (couple kips). According to section 11.4.5.1 in 318-08 taking d/2 would require tie spacing of 7" c-c. This seams excessive as I normally see these ties spaced at 16" c-c. Could anyone provide more insight or is...
In order to do the structural analysis for square and Rectangular footings I first calculate ks using equations from reference #2. I recently came across Reference #1 which provides some extra verbage and a different equation for rectangular footings than reference #2. What is the recommended...
Creating a macro in word to fill out report templates. I manually fill information in excel then copy & paste each cell into corresponding advanced properties place holder text already created in word. Is it possible to write a macro to match names from the word properties text and replace with...
I inserted a Table of contents using Microsoft word 2010. I have one formatting issue that I have to manually correct every time I update the table. Every time I update the table word automatically adds a couple of spaces in from of one of my headings (inspection#13). I have tried deleting and...
In the never section deflections results there is a L/y Ratio & L/z Ratio. I see that in the Risa Help menu there is an arbitrary L/360 value for the example. What is the typical deflection criteria used & how does Risa flag these criteria?
I am designing a tunnel for a conveyor and would like to know if anyone uses some concrete tunnel design software? I found a few packages out there and now looking for some software recommendations..
I am looking into purchasing a program to calculate my wind loads on buildings and structures following ASCE Code. I would really like a program that includes sketches along with all the design pressures. Any suggestions would be appreciated. Also if there is an all in one program that does...
I was using the ASCE705W template created by A Tomanovich. When running the MWFRS (Any Ht.)work sheet I was wondering about the roof load outputs. In my example I am getting 4 output results( Roof (zone #1) cond. 1,Roof (zone #1) cond. 2,Roof (zone #2) cond. 1, & Roof (zone #2) cond. 2) The zone...
I have an Excel file that contains two Work sheets (Calculation, Loads).In the Calculation work sheet there are six variables (Cells D13-D18) that change depending on which # trial is being checked.The results show up in cells G47 & G48 for each unique trial. There are a total of 104 trials with...
