www.excelcalcs.com - Forum

Subject: XLC Turorial - Text Processing - apparent typing error - by: BJPearson

Wed, 22 May 2013 01:08:57 +0100

Hi, please see the attached file. Regards Brian PS This is my first message, so I hope it all works.:) http://www.excelcalcs.com/images/fbfiles/files/Text_Conversion.pdf

Subject: Re:Struggling to make it work! - by: JohnDoyle

Tue, 21 May 2013 10:23:35 +0100

Thanks for your kind comments about the site. I am struggling a little to understand your problem: In cell H54 (phi*Ms), I get a #VALUE error. Is this an excel file you have downloaded from the repository. If so could you tell me which one so that I can check it myself. However, I can't access C:/Documents and settings, so have the files in a different location Or are you having a problem with our XLC software. I'll be very pleased to help if you give me a little more information about your problem.

Subject: Struggling to make it work! - by: therealdozza

Tue, 21 May 2013 04:11:50 +0100

Hi there, Firstly a big thank you for making this resource available. It looks like you've put in countless hours working on it. Unfortunately, I'm having similar problems that other users appear to be. In cell H54 (phi*Ms), I get a #VALUE error. I have attempted to follow all of your previous advice regarding the linked files. However, I can't access C:/Documents and settings, so have the files in a different location. I have updated the links, however. Do you have any further advice? thanks again.

Subject: Re:AXIAL AND LATERAL LOAD PILES (FEM) - by: 22levent

Thu, 16 May 2013 14:29:48 +0100

Tuna bey merhaba, bu exceli nasil bedava yukleyebilirim? Tesekkurler,elinize saglik..:)

Subject: Re:API 579 - by: AFingle

Tue, 14 May 2013 14:21:47 +0100

And some fatigue checks: http://www.excelcalcs.com/images/fbfiles/images/API579_3.png

Subject: Re:API 579 - by: AFingle

Tue, 14 May 2013 14:20:36 +0100

Some Buckling Checks too: http://www.excelcalcs.com/images/fbfiles/images/API579_2.png

Subject: Re:API 579 - by: AFingle

Tue, 14 May 2013 14:19:05 +0100

I did make some progress with my calculations which may be helpful for you. See below: http://www.excelcalcs.com/images/fbfiles/images/API579_1.png

Subject: Re:API 579 - by: haroldjoubert

Tue, 14 May 2013 13:43:08 +0100

I would love to have something on this myself

Subject: Re:Using XLC to decipher an existing spreadsheet - by: JohnDoyle

Sat, 11 May 2013 16:13:55 +0100

Yes it is easy to do. Just use the XLC "name" and "insert equation" buttons. You can try out all this functionality with a free trial subscription too.

Subject: Using XLC to decipher an existing spreadsheet - by: kjn.fife

Sat, 11 May 2013 09:31:09 +0100

I'm new to ExcelCalcs: Can XLC be used to decipher an existing spreadsheet and display the formula.

Subject: Re:File Error : while opening - by: JohnDoyle

Thu, 02 May 2013 14:49:33 +0100

As far as Excel is concerned an XLC named cell is just a cell containing some formatted text. This data is not lost when it is saved. As far as Excel is concerned XLC equations are simply graphics and again this data is not lost when it is saved. Unless I can reproduce the error you experienced I cannot debug it but I really cannot see how XLC has given rise to your file corruption issue.

Subject: Re:File Error : while opening - by: erik01

Thu, 02 May 2013 14:40:26 +0100

I am using name functions, but excel deletes all names and other texts from the workbook. They are also missing from the file You sent back. If I open your work I still get this message: http://www.excelcalcs.com/images/fbfiles/images/Capture2.PNG

Subject: Re:File Error : while opening - by: JohnDoyle

Thu, 02 May 2013 14:15:57 +0100

Eric I managed to open the file with a few errors. I can see that you have been using XLC so I redrew equations on a couple of worksheets. I was a little surprised to see that you have not been using XLC name functions to generate algebraic equations. Your numeric equations appeared well enough though. I saved my work which re-opened without errors (see attached). I do not believe that the file corruption problem has anything to do with XLC but some other Excel weirdness. Sorry I cannot be of much help. http://www.excelcalcs.com/images/fbfiles/files/XLC_error2.xlsx

Subject: Re:File Error : while opening - by: erik01

Thu, 02 May 2013 13:56:32 +0100

The file is here: http://www.excelcalcs.com/images/fbfiles/files/XLC_error.xlsx

Subject: Re:File Error : while opening - by: JohnDoyle

Thu, 02 May 2013 13:39:32 +0100

Could you attach a file exhibiting the problem and I'll take a look at it?

Subject: Re:Re :File Error : while opening - by: erik01

Thu, 02 May 2013 12:25:48 +0100

Hello! I have a similar issue:"Excel found unreadable content in ' filename '. Do you want to recover the contents of this workbook?" Cliking YES results in losing all of the text strings (names, xlc formulas,even headings). Only calculations and drawings are left. Im working with excel 2007 sp3 & xlc trial. Thank You! http://www.excelcalcs.com/images/fbfiles/images/Capture.PNG

Subject: FOOTINGS.xls update to version 3.6 - by: ATomanovich

Wed, 01 May 2013 14:42:57 +0100

In the "Footings (Table)" worksheet of the "FOOTINGS.xls", it was discovered that original intended criteria for use of top reinforcing was not being handled for all cases. I had originally set the criteria for the use of top reinforcing in the footing base to be for either the case with uplift load on the footing pier and/or for the case when there is no soil cover (D = 0) over the top of the footing. The worksheet was providing top reinforcing when an uplift load was input. However, for the special case of no uplift load along with no soil cover, the worksheet was showing the top reinforcing = 0, when there should have been a calculated value > 0. I have made the necessary corrections. This workbook is now version 3.6.

Subject: FRAME (metric) - by: ATomanovich

Wed, 01 May 2013 14:29:51 +0100

This thread will track of the version history of the following download: FRAME (metric) http://www.excelcalcs.com/images/repository/903.png (http://www.excelcalcs.com/component/option,com_remository/func,fileinfo/id,903/) At the request of several people in the past, I've finally created a metric units version of the "FRAME.xls" spreadsheet workbook for the analysis of portal and gable frames. I took the easy way out in creating this new workbook by starting with a copy of the English units workbook. Metric units are used for input, and those values are automatically converted back to English units for the actual analysis. Then the results, which are calculated in English units, are converted back to metric units for display on the calculation page. Also, since a few people had asked me about it, I added some information at the bottom of the "DOC" worksheet describing how the user can manually implement an iterative solution to account for P-Delta ("Big" Delta) effects (2nd order) on the columns of a frame.

Subject: FRAME.xls update to version 1.1 - by: ATomanovich

Wed, 01 May 2013 14:11:11 +0100

In the process of creating the new metric units version of the "FRAME.xls" spreadsheet workbook for the analysis of portal and gable frames, I realized that for some reason I had used the angular units of radians for the slope (rotation) which really are suited for metric (SI) units. Degrees would have been the better choice for consistent English units, so I made that minor change in the 2 calculation worksheets. Also, since a few people had asked me about it, I added some information at the bottom of the "DOC" worksheet describing how the user can manually implement an iterative solution to account for P-Delta ("Big" Delta) effects (2nd order) on the columns of a frame. This workbook is now version 1.1.

Subject: ClipConnTable.xls update to version 1.8 - by: ATomanovich

Wed, 01 May 2013 14:08:27 +0100

It was brought to my attention that in all 3 calculation worksheets of the "ClipConnTable.xls" spreadsheet workbook, the program was giving "FALSE" and "#DIV/0!" error messages when a yield stress of 33 ksi was selected for either the beam and/or the clip angles. These error messages were a result of the fact that the program inadvertently did not include the logic for the ultimate tensile strength, "Fu", when the value of the yield stress was 33 ksi. Otherwise, the worksheets were operating fine for yield stresses of either 36 or 50 ksi. I have made the necessary corrections to all 3 worksheets. This workbook is now version 1.8.

Subject: FLRPLATE update to version 1.6 - by: ATomanovich

Wed, 01 May 2013 14:05:08 +0100

I made a few changes and additions to the "FLRPLATE.xls" spreadsheet workbook for the analysis of floor plate. Several people had asked about why the allowable bending stress, Fb, was limited to 16 ksi in the Floor Plate Bending Capacity table in the AISC Manual. The answer is best explained in the article "Are You Properly Specifying Materials?" by Charlie J. Carter, S.E., P.E. from "Modern Steel Construction" magazine, January 2004 (as follows): Raised-Pattern Floor Plates ASTM A786 is the standard specification for rolled steel floor plates. As floor plate design is seldom controlled by strength considerations, ASTM A786 "Commercial Grade" commonly is specified. If so, per ASTM A786 Section 5.1.2, "the product will be supplied 0.33 percent maximum carbon and without specific mechanical properties". Alternatively, if a defined strength level is desired, ASTM A786 raised-pattern floor plate can be ordered to a defined plate specification, such as ASTM A36, A572, or A588; see ASTM A786 Sections 8 and Appendix Table X1.1. In order for the worksheet to be able to create a calculation which would reflect the values in the AISC Manual table, I added the user input asking if the allowable bending stress is to be limited to 16 ksi or not. I also added a couple of comment boxes as well as a couple of visible notes on the calculation page pertaining to simulating one-way action and plate yield stress. This workbook is now version 1.6.

Subject: ASME CALCULATION FOR MITERED BEND - by: ratnadeep1972

Wed, 01 May 2013 13:50:58 +0100

This thread will track of the version history of the following download: ASME CALCULATION FOR MITER BEND http://www.excelcalcs.com/images/repository/902.png (http://www.excelcalcs.com/component/option,com_remository/func,fileinfo/id,902/)

Subject: STEPCOL.xls update to version 1.1 - by: ATomanovich

Tue, 30 Apr 2013 13:46:49 +0100

In the "STEPCOL.xls" spreadsheet workbook, the effective length factors for the upper and lower shafts, K1 and K2, were expressed relative to the total column length, LT = L1+L2, as was done in the reference documents. This has caused a bit of confusion for some people, so I added the effective length factors, K1 and K2, expressed relative to the individual lengths of the upper shaft (L1) and the lower shaft (L2). This workbook is now version 1.1.

Subject: BMREINF9.xls update to version 2.0 - by: ATomanovich

Tue, 30 Apr 2013 13:39:05 +0100

In the "BMREINF9.xls" spreadsheet workbook I discovered that in some of the calculation worksheets under the last heading pertaining to the end welds for the particular reinforcing, the text display of the results was inconsistent with the calculated result. For the value of the end weld length on each side of the reinforcing to use, the program was selecting the wrong cell of "a'(req'd)" when it should have been selecting the cell for "a'(use)". The value of "a'(use)" is determined from the maximum of the values for "a'(min)" and "a'(req'd)". I have made the necessary corrections. This workbook is now version 2.0.

Subject: PILEGRP.xls update to version 3.6 - by: ATomanovich

Tue, 30 Apr 2013 13:35:03 +0100

In the "Corner Pile Shear" worksheet of the "PILEGRP.xls" spreadsheet workbook, the user had been limited to selecting either the ACI 318-99, 318-02, or 318-05 Code versions. I added the ability to select either the ACI 318-08 or 318-11 Code versions as well. Actually, for this particular worksheet this change is somewhat of a formality, as the "phi" factor for shear changed from the ACI 318-99 Code value of 0.85 to a value of 0.75 starting with ACI 318-02 Code, and has remained constant through ACI 318-11 Code. This workbook is now version 3.6.

Subject: SECTPROP.xls update to version 2.5 - by: ATomanovich

Tue, 30 Apr 2013 13:28:29 +0100

It was brought to my attention that in the "Shapes" worksheet of the "SECTPROP.xls" spreadsheet workbook, if the user was adding multiple cylinders the program was inadvertently only referencing the values for the first cylinder that was input when determining the composite section properties. I have made the necessary cell referencing corrections pertaining to only the cylinders. The other shapes were fine. While I was at it, I decided to expand the capability of the "Stress" worksheet in this workbook. Before, the worksheet only allowed the user to determine the combined stress at one point within the cross section at a time. I have expanded that now so that the worksheet can calculate and display the stress results for up to six (6) points at one time. I also added a cautionary note to remind the user to make sure that the points to be investigated are actually within the given cross section. This workbook is now version 2.5.

Subject: MOVLOADS update to version 1.2 - by: ATomanovich

Tue, 30 Apr 2013 13:22:44 +0100

While recently using the "MOVELOADS.xls" spreadsheet workbook for moving loads analysis, I inadvertently discovered that the program does not work properly for wheels loads that are input with negative ( < 0 ) values. Thus, I added the user input data validation to restrict the input values of the wheel loads to values greater than 0. This workbook is now version 1.2.

Subject: ASCE705W Wind Loading update to version 1.4 - by: ATomanovich

Mon, 29 Apr 2013 13:58:20 +0100

In the worksheet for "Stacks & Tanks" of the "ASCE705W.xls" spreadsheet workbook, I revised the method for determining the fundamental period. The worksheet now uses ASCE 7-05 Equation C6-22a on page 294 of Chapter 6 of the Commentary for the natural frequency of a cantilever beam of uniform cross-section. That formula is f = 0.56/h^2*SQRT(E*I/m). The inverse of the frequency value is then taken to arrive at the period, "T". Also of note, this same formula is used in the Fluor Structural Guideline 000.215.1215, "Wind Load Calculation". In the past, I had been using the rather simplistic and approximate formula from ASCE 7-05 of T = Ct*h^(3/4) for the period. The main issue with having used this formula is that there is no accounting for varying the diameter (width) of a vessel in determining the period. Also, I have corrected some minor "typo" errors in a few of the worksheets This workbook is now version 1.4.

Subject: ASCE702W.xls update to version 2.1 - by: ATomanovich

Mon, 29 Apr 2013 13:55:51 +0100

I have corrected "typo" errors in some of the worksheets in the "ASCE702W.xls" spreadsheet workbook on wind analysis per ASCE 7-02. This workbook is now version 2.1.

Subject: RECTBEAM (318-05).xls update to version 1.3 - by: ATomanovich

Mon, 29 Apr 2013 13:53:27 +0100

In the "Complete Analysis", "Shear", and "Torsion" worksheets of the "RECTBEAM (318-05).xls" spreadsheet workbook it was brought to my attention that the program was not limiting the ultimate shear strength provided by the shear reinforcing, "(phi)Vs" to the Code allowable maximum, (phi)Vs(max) = 8*(0.75)*SQRT(f'c)*b*d. Actually, I had the verbiage on this in the appropriate comment boxes, but for some reason I did not have the program logic set up to limit the value. I also added a visible note which appears in bold, red text whenever the value of (phi)Vs is controlled by the allowable maximum value. Also, in the "Biaxial" worksheet and under the heading of "Tie Min. Size & Max. Spac:", the program was supposed to be only referencing the input cells for the longitudinal bar sizes in Cells D18 and D20. However, it was also inadvertently referencing Cell D19, which pertains to the total number of side reinforcing bars. I have made the necessary corrections to the above mentioned items. While I was at it, I decided to add a new worksheet to this workbook. The "Slenderness (Sidesway)" worksheet can be used to analysis the slenderness effects for a single, unbraced column subject to sidesway. This worksheet is very well suited for the quick slenderness analysis of a pier of a foundation, where there is either no supporting soil around the pier or where the soil is considered inadequate to provide continuous lateral support for the pier. This workbook is now version 1.3.

Subject: GRDSLAB.xls update to version 1.8 - by: ATomanovich

Mon, 29 Apr 2013 13:51:16 +0100

In the "Slab on Grade" worksheet of the "GRDSLAB.xls" spreadsheet workbook, I had some typo errors in the list of references at the bottom of the second page. The corrections have been made. This workbook is now version 1.8.

Subject: IBC2009E.xls update to V 1.1 - by: ATomanovich

Mon, 29 Apr 2013 13:47:35 +0100

In the "M & E Components" worksheet of the "IBC2009E.xls" spreadsheet workbook, I corrected some typo errors under the heading of "Amplification Factor and Response Modification Coefficient". I had inadvertently shown the table and page numbers for the Architectural Components when it should have been the table and page numbers for Mechanical and Electrical Components. This workbook is now version 1.1.

Subject: Padeye Design Metric - by: reney

Mon, 29 Apr 2013 08:01:07 +0100

This thread will track of the version history of the following download: Padeye Design http://www.excelcalcs.com/images/repository/900.png (http://www.excelcalcs.com/component/option,com_remository/func,fileinfo/id,900/)

Subject: CALCULATION OF CORROSION PROPERTY - by: ratnadeep1972

Mon, 29 Apr 2013 07:41:17 +0100

This thread will track of the version history of the following download: CALCULATION OF CORROSION PROPERTY http://www.excelcalcs.com/images/repository/898.png (http://www.excelcalcs.com/component/option,com_remository/func,fileinfo/id,898/)

Subject: COMPRESSED AIR SYSTEM - by: ratnadeep1972

Tue, 23 Apr 2013 08:00:30 +0100

This thread will track of the version history of the following download: COMPRESSED AIR SYSTEM http://www.excelcalcs.com/images/repository/895.png (http://www.excelcalcs.com/component/option,com_remository/func,fileinfo/id,895/)