The least you can do (my mother always told me) is say thank you. At ExcelCalcs you can thank people by applauding to increase their Karma rating. You just need to login to the site and look for the applaud markers in the forum  Karma+ (or you can click them in this email). I can't believe that Alex Tomanovich (the ExcelCalcs national treasure) has only a Karma rating of 4 and I am writing to implore you to applaud Alex for all his good work. Whilst you are at it you can applaud all other users who have contributed to the repository in the last week.

Repository News 



Karma: 4  Karma+ Karma- 



Pipe Weight and Tank Volume and Weight Calculator.

In the "WEIGHTS.xls" workbook, I was recently asked to expand the capabilities to include extra strong (XS) and double-extra strong (XXS) pipes. In the earlier version, only Standard weight pipes were addressed. Thus, I added 2 new worksheets, "XS Pipe Wt's" and XXS Pipe Wt's", and updated the "Pipe Rack Level Wt." worksheet as well.


sumnerdave (User)

  Karma: 1  Karma+ Karma-

FileAppendix D - Anchor Bolt Anchorage

Anchor Bolt(CSA)rev1.1.xls" is a MS-Excel spreadsheet workbook for the analysis of anchor bolt anchorage per the Canadian Standard Code, A23.3-04, Appendix D.

Thank you for your comments. I've fixed the conditional format problems that you have mentioned and some that were not. I've submitted a new version but forgot to fix the simplest of errors "kip" to "KN". sad.png



Karma: 4  Karma+ Karma- 



Steel Beam Stiffener Analysis for Concentrated Loads (ASD).

In the "STIFFNER.xls" workbook, a glitch was brought to my attention. A good while ago I had made the revision in calculating the stiffener width (bs) to round it down to the nearest 1/2". In the calculation of the total weld length (Lw) for attaching the stiffener to the beam flange, I was using the actual unrounded stiffener length and not the rounded down stiffener length. This has now been corrected.



Karma: 4  Karma+ Karma- 


Concrete Slab on Grade Analysis for Post and Wheel Loading

The "GRDSLAB.xls" workbook recently went through a thorough independent check for validation prior to it's use on one of the projects here at work. As a result, I was asked to add some additional comments and references for clarification. Also it was discovered that in the "Slab on Grade" worksheet that there were certain combinations of concentrated load (P), subgrade modulus (k), and contact area (Ac) which would produce a #N/A error message for some the minimum slab thickness calculations shown off of the calculation page on the right side of the display. These minimum slab thickness calculations were originally placed there for convenience and reference only, so they are not actually required. The simple iterative solution that I was using fails sometimes in part because of the complex nature of the equations, as well as the VLOOKUP command not working properly due to the iterative expression results not always being in complete ascending order. I added a note shown in red text to explain these occurrences to the user.


FileLoad combination tools

 This worksheet includes loads combinating and load combination case for Staad/Pro input file. You can see a log-in dialog when you open the spreadsheet. Please click the "Enter Program" botton to access first time. Of course, the password could be change if you want to do.

ExcelCalcs TV

And how about rating the videos? It would be good to get feedback regarding this relatively new site feature.

Rate New Videos

Line between two points and perpendicular distance to third point
This calculation is very useful for calculation the moment of a force vector about a point. It is best viewed in fullscreen mode (double click the video player).
Date: 2008-09-03 22:11:47 - Added by: JohnDoyle
Views: 6 - Votes: 0 - Rating: 0


And some you may have already seen. 

Why Excel & XLC?
Find out why you should be using MS Excel and XLC to make and share calculation documents.
Date: 2008-08-19 14:35:27 - Added by: JohnDoyle
Views: 252 - Votes: 0 - Rating: 0
Excavator Arm Geometry and Load Assessment
This is best viewed in full screen model. Double click the player.
Date: 2008-08-15 09:09:21 - Added by: JohnDoyle
Views: 288 - Votes: 0 - Rating: 0
Enhanced Equation Rendering in XLC ver.03_08
This is best viewed in full screen model. Double click the player.
Date: 2008-05-23 10:27:33 - Added by: JohnDoyle
Views: 559 - Votes: 0 - Rating: 0
Animate your Excel charts
This is best viewed in full screen model. Double click the player.
Date: 2008-05-23 10:08:56 - Added by: JohnDoyle
Views: 511 - Votes: 0 - Rating: 0
How to present Calculations in Excel
Date: 2008-05-02 07:26:07 - Added by: JohnDoyle
Views: 433 - Votes: 0 - Rating: 0
What is XLC and ExcelCalcs?
Date: 2008-05-02 07:24:39 - Added by: JohnDoyle
Views: 640 - Votes: 0 - Rating: 0
Making great sketches with Excel
Date: 2008-05-02 04:41:02 - Added by: JohnDoyle
Views: 315 - Votes: 0 - Rating: 0