Return to index: [Subject] [Thread] [Date] [Author]

Spreadsheet Tutorial - developing Flow charts to write Nested Conditional "IF" Functions

[Subject Prev][Subject Next][Thread Prev][Thread Next]

I have posted the spreadsheet for the Pole Sign Wind Load calculation to the Software Productivity forum at:"">

Be sure to copy the entire link starting with
Http:// and ending with SID=12897. The link must include the complete address which may appear on multiple lines. Be sure to cut and paste each segment to the Browsers address bar. LEAVE NO SPACES OR LINE FEEDS (RETURNS) - EVERYTHING MUST OCCUR AS A CONTINUOUS ADDRESS TO WORK. If you receive this message in HTML format, the URL is embedded in the spreadsheet name and you can click on the name as the link or copy the long address below it.

I have created a tutorial on the Spreadsheet forum of the Software Users Group located at:"">


This spreadsheet allows the user to place a sign of any width and any height (up to 40-feet) on a pole. In fact, the spreadsheet allows the user to place three signs on one pole. The spreadsheet calculates the wind pressure for each segment and calculates the total accurate moment for all signs on the pole. The user can use the moment calculations to choose a steel pole section and to calculate the depth and diameter of the post footing (which will be added to the spreadsheet later).

Inasmuch as this is a spreadsheet tool, the conditional statements must be written to allow the user to place up to three signs of any size at any location on the pole and still be able to calculate the areas of the sign that occur at elevations on the pole that have different Ce values. These generally are noted in the code tables at:

0-15 Feet

15 to 20 Feet

20 to 25 Feet

25 to 30 Feet

30 to 40 Feet

The tutorial provides a flow chart that explains the first test - to determine if any part of the sign lies between 30 and 40 feet and to calculate the appropriate area and wind pressure on that portion of the sign which lies within this region. The additional Ce region flow charts will be added over the next few days, however, the user can gain a lot of information by starting the tutorial now.

The tutorial culminates with the nested "IF" statements that is embedded in the spreadsheet cell which then can be used as a template for future sign calculations. The purpose of the lesson is to help the novice interested in learning to create programs in spreadsheets to understand the importance of starting with logical tests which cover all conditions. While the creation may seem difficult, once laid out in a flow chart, the development of the nested conditional statements becomes an easy task.

If you are interested in learning how to create spreadsheet programs, this is an excellent start. Follow the links above to retrieve the spreadsheet and use the spreadsheet as reference while working through the tutorial on the Structuralist.Net.

Dennis S. Wish, PE
The Structuralist Administrator for:
AEC-Residential Listservice
(208) 361-5447 E-Fax
ICQ #95561393

The Structuralist is a Public, Professional and Educational website devoted to issues on Housing. You are invited to participate or simply visit our discussion forums at"

You may register on the Structuralist.Net at:"">

Please make sure that when you copy this link that you copy the entire link beginning at http: and ending with Register. There should be no spaces between any of the letters or characters.

Our Residential Listservice is open to all professionals in the building industry and the discussions include code compliance issues as well as quality of construction, prescriptive vs. full compliance, present and future code development and more. The AEC-Residential List is by subscription (always free). To subscribe please use the AutoList subscription feature for the Listservices located at: