Write to text file with Excel VBA macro

The following Excel VBA code will write the contents of column S (first 1001 lines) to a text file named after B16 in a directory labeled B15. The B15 entry will also look for “desktop” or “Desktop” and find the local desktop folder for the user. This is accopmplished by the CreateObject("WScript.Shell").specialfolders("Desktop") item

Sub fileWrite()
    If (Cells(15, 2).Value = "Desktop") Or (Cells(15, 2).Value = "desktop") Then  'if input cell is desktop then
        strFolder = CreateObject("WScript.Shell").specialfolders("Desktop") & "\" 'use desktop folder
        strFolder = Cells(15, 2).Value 'otherwise use directory path listed in input cell
    End If
    strFile = Cells(16, 2).Value 'input cell for file name
    strPath = strFolder & strFile 'combined directory + file name
    Dim fso As Object 'declare file system object
    Set fso = CreateObject("Scripting.FileSystemObject")
    Dim oFile As Object 'declare file object
    Set oFile = fso.CreateTextFile(strPath)
    'write the first 1001 lines of column S to a text file
    For i = 0 To 1000 'counter
        oFile.WriteLine Range("S" & (i + 1)) 'write cell contents to text file
    Next i
    oFile.Close 'close file
    Set fso = Nothing
    Set oFile = Nothing
End Sub
Posted in Excel, Macros, VBA | Leave a comment

Wabbitemu TI Calculator Emulator

Wabbitemu TI Calculator Emulator

Developed By Spencer Putt, Chris Shappell, and James Montelongo

For Windows and Mac OS X and Android

From the project site:

  • Wabbitemu – An accurate emulator/debugger for the TI-73, TI-81, TI-82, TI-83, TI-83+(SE), TI-84+(SE), TI-84+CSE, TI-85, and TI-86
  • SPASM – The fastest Z80 assembler with extra features supporting TI calculator development
  • Wabbitcode – An integrated development environment with auto-complete, syntax-highlighting, and comprehensive source-level debugging

Available on the Google Play Store

Wabbitemu creates a Texas Instruments graphing calculator right on your Android device. Wabbitemu supports the TI-73, TI-81, TI-82, TI-83, TI-83 Plus, TI-83 Plus Silver Edition, TI-84 Plus, TI-84 Plus Silver Edition, TI-85, and TI-86. Fast and convenient, Wabbitemu allows you to always have your trusty calculator with you. Because Wabbitemu is an emulator, the calculator it creates will act exactly like the real thing.
Wabbitemu, like all emulators, requires a ROM image. Wabbitemu includes an easy to use setup wizard that will help you create a ROM image for your TI.

If you need to make a ROM, you can download it from your calculator.  If you need help try clicking on appropriate link below:



Posted in software | Tagged , , , , , , , , , | Leave a comment

AISC 2013 Spring Seminar Series

AISC has announced their new spring seminars.

(Chicago, IL) – This season, become more informed, more efficient, and a better structural engineer with AISC’s annual Spring Seminar Series. No matter what type of building you’re designing, nowhere else will you learn to leverage your professional knowledge with the 14th Edition Steel Construction Manual, apply welding applications for cost-efficient design or delve into design concepts and connections for seismic braced frames – all while learning from masters in these topics, in person. Organized by the American Institute of Steel Construction (AISC), the Spring 2013 Seminar Series will be offered in 12 cities around the U.S. from March to June. Act now and you’ll receive a $50 early registration discount when you register at www.aisc.org/seminars; the discount is valid until February 22.

This year’s AISC spring seminars include:

2010 Specification and 14th Edition Manual: The Louis F. Geschwindner Seminar

Listen to the Steel: Duane Miller on Welding

Seismic Braced Frames – Design Concepts and Connections

Effective Steel Design with Seismic Considerations

Each lecture also provides useful tools and resources including course notes, design examples and AISC publications.

For more information on AISC’s spring seminars, registration details and pricing, visit www.aisc.org/seminars.

Registration Now Open for AISC 2013 Spring Seminar Series.

Posted in Building codes, Codes, Steel, structural | Tagged , , , , , , | Leave a comment

Could construction admin services have prevented downtown Montreal flooding?

Proper planning or perhaps an engineering services for construction administration could have possibly prevented a major flooding of downtown Montreal.  Soil around an aged water pipe may have shifted during construction work causing  the 47″diameter pipe to break and pour out 10.5 million gallons of water into the downtown streets in just 2 hours.

Moments before the water main broke, crews were working at a construction site at the McTavish reservoir near McGill University’s downtown campus.

The city’s water service said it’s possible the construction work near the water main caused the soil to shift, which led to the break.

Saeed Mirza is a professor emeritus at McGill University who specializes in structural engineering and the rehabilitation of infrastructure.

Mirza said the city should have known the pipe was vulnerable and taken the necessary precautions.

“It’s nearly a 100-year-old pipe. If the pipe was weakened, then any soil movement could easily fracture it,” he said. “Some engineer should have visualized this earlier.”

via [Montreal flooding linked to construction work – Montreal – CBC News.]

Posted in Building codes | Tagged , , , | Leave a comment

Why we need building permits

Collapsed Building

Collapsed Building – From Asheville Fire Department/SPECIAL TO THE CITIZEN-T

This is a very good example of why we need building permits from Asheville’s Citizen Times:

ASHEVILLE — The collapse of a downtown building might have been avoided if a contractor had gone through the proper permitting process, the head of the city’s Development Services Department said Friday.

Before a permit was issued, the city would have required that an engineer prepare plans that would include measures to ensure the structural integrity of the 1917 building during renovation, department head Robert Griffin said.

Odds are that following those plans would have prevented the Thursday collapse, he said.

Posted in Building codes, Codes, structural | Tagged , , , | Leave a comment

Excel: Primitive Bar Graph and Roman Numerals

Excel has a repeat function called REPT that will repeat a text character any number of times.  It’s format is REPT(TEXT, Value) where Value is the number of times that TEXT is repeated.  You can use “i”, “o”, “-“, or any other letters/symbols as your text and do a primative bar graph.  You can also your numbers to roman numerals if they are less than 4000 by using the ROMAN function.  The example table below shows three columns A, B, and C.  Row 7 shows the formulae starting with cell A7.  The rest of the rows show values if they formulae are copied down.

7 =Repeat(“i”,A7) =Roman(A7)
8 iiiiiiii VIII
9 iiiiiiiii IX
10 iiiiiiiiii X
11 iiiiiiiiiii XI
Posted in Excel, software | Tagged , , | Leave a comment

Excel Tip: Convert Number to Text

Here are four basic ways to convert a number in a cell to text.

Method (1) Format Cells

1) Right click cell(s) of interest and click on “Format Cells…”

2) Under the Number tab Choose Text as your Category

Method (2) Text function

1) use the TEXT function.  It has the formatting of =TEXT(Value,Format)

For example, =TEXT(42.6,”0.00″) returns 42.60 as a text value.  The formatting is the same as that used in the Format Cells dialogue box.

Method (3) Concatenation with &

Using the ampersand (&), you can concatenate text.  For example, the formula =”a”&”b” returns ab.  If you concatenate any text to a number (including a null text such as “”) it will return a text value.  So, typing the formula =””&70.0 returns 70 as a text.  Note the formatting isn’t as convenient as using the TEXT function.

Method (4) Text to Columns

Choosing Data -> Text To Columns from the menu will let you convert your numbers to text.  When the dialogue opens up just follow the steps in the Wizard:

Step 1) Choose Delimited and click Next.

Step 2) Tab delimited and click Next.

Step 3) Choose Text as your Coumn Data Format and click Finish.

Posted in Excel, software | Tagged , , , | Leave a comment

How Do I Average In Excel?



A very common question for Excel is, “How do I average in Excel?”  The simplest way to do this is to use the AVERAGE function.  In the example to the left, cell A5 has the following formula:


This returns the Average (mathematical mean) of the three numbers in the range from A1 to A3 inclusively.  You can check it by computing (2+3+6)/3 = 3.667.

If you are at the bottom of a column of numbers that you want to average just type


in the cell that you want to show the average in.  Before hitting the ENTER key, select the range of cells you want to include in the average.  The formula will finish filling in the range and last parenthesis for you after you hit Enter.

Typing the formula below will  give the same results as the example, but won’t update when you change any other cells:


Of course, if you want other types of mathematical averages other than the mean (which AVERAGE returns), then the MEDIAN and MODE functions are also available.  They work similarly to AVERAGE, but return their respective mathematical counterparts of central tendency.  Other tips and advanced averaging functions are available from Microsoft’s help website such as these:

  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function.
  • If you want to calculate the average of only the values that meet certain criteria, use the AVERAGEIF function or the AVERAGEIFS function.
Posted in Excel, software | Tagged , , | Leave a comment

Hoover Dam Bypass Bridge Inspection

Inspection Photo courtesy Art Domagala

Inspection Photo courtesy Art Domagala

Art Domagala’s Photo Blog has interesting pictures of the inspection of the Hoover Dam Bypass Bridge.  Check it out for some awesome shots.

Posted in structural | Tagged , , , | Leave a comment

LEAP Bridge Enterprise Release V12.01.00

LEAP Bridge Enterprise V12.01.00 is now available.  In addition to bug fixes, and code updates, some of the enhancements include the following:

LEAP Bridge v12.01.00.57


  • Introduced a new analysis option “Integral Abutment Bridge” in the Project tab. This option allows users to analyze and design integral abutment

LEAP CONSPAN v12. 01.00.57


  • CONSPAN has been updated to comply with the AASHTO LRFD 6th edition. Primary changes are minimum reinforcement requirement changes and Mcr calculations.

LEAP CONBOX v12. 01.00.57


  •  CONBOX now offers three types of temperature loading, including uniform temperature, linear gradient and multi-linear gradient temperature. Multi-linear temperature loading complies with AASHTO, CHBDC, and IRC codes.

LEAP RC-PIER v12. 01.00.57


  • For integral abutment bridges RC-PIER performs a 3D frame analysis. In the 3D analysis each abutment and pier is part of the full bridge model and is subjected to the loads generated through RC-PIER. Model tab displays both the 3D model and the specific abutment or pier 2D frame with the node and member numbers referenced in the analysis reports.

Geometry Module: GEOMATH v12. 01.00.57


  • Update for wall pier and pile bent.

To see the full list (there are a LOT more new features than the ones listed here), visit the Leap Product Update Page.

Posted in software, structural | Tagged , , , | Leave a comment