Need a book? Engineering books recommendations...

# Re: Excel Subscripts

• To: seaint-seaosc(--nospam--at)mail-list.com
• Subject: Re: Excel Subscripts
• From: <h.d.richardson(--nospam--at)shaw.ca>
• Date: Fri, 2 Aug 2013 16:48:30 -0600
• List-subscribe: <mailto:SEAINT-SEAOSC-on@mail-list.com>

```Gary,

```
The dynamic gust factor program I sent to you when we worked on the Sarnia project has a solution to this problem. If you revisit that program you will find that entering 1, 2, or 3, for "TERRAIN" in the left hand side and a value for "K" is calculated accordingly. If this is what you are looking for it shouldn't be too hard to adapt it for your use.
```
```
For those not privy to our past communication, it's simply an "if statement" in F7; I.E. (If B12=1, xxx, If B12=2, yyy, If B12=3, zzz).
```
```
I don't know if that's what Gary is looking for or not. If so, that is a possible solution.
```
Regards,

Daryl

```
----- Original Message ----- From: "Gary L. Hodgson and Assoc." <design(--nospam--at)hodgsoneng.ca>
```To: <seaint-seaosc(--nospam--at)mail-list.com>
Sent: Friday, August 02, 2013 1:00 PM
Subject: [SEAINT-SEAOSC] Excel Subscripts

```
```List,

```
Do any of the resident Excel experts here know how to append a calculated number to an alphanumeric character as a subscript? For example, a wind load is calculated for 3 different conditions so that there are 3 different answers to be appended to W as a subscript.
```
thanks,
Gary
```
```
-------------------------------------------------------------------------
```
Post your message to the list by sending it to: SEAINT-SEAOSC(--nospam--at)mail-list.com.
```
The email messages sent to the list will be saved in an archive on the World Wide Web.
These archives are located at:
http://archive.mail-list.com/SEAINT-SEAOSC

To contact the list owner, send your message to:
SEAINT-SEAOSC-list-owner(--nospam--at)mail-list.com.

Sponsored By: Pacific Structural & Forensic Engineers Group, Inc. (PSFEG)