IMO, Enercalc was really a revoultionary and ingenious product when it first came out. Over the years, it has improved only slightly in technical quality. (Discounting the inevitable evolution from Lotus123-based to DOS to Windows version)
Unlike large steel or concrete buildings, wood-framed buildings are very tedious to calculate without software, and Enercalc doesn't really provide a total system approach. (Woodworks is somwhat better in that regard). Therefore we have developed an Excel workbook that greatly automates the...
Overall, we use software for about 75% of the calcs. Personally, I use software probably at least 95% of the time, especially Excel. ( I am an "old" guy but am kind of burned out by punching calculator and writing numbers all day). We don't use Mathcad at all.
That note is in error. It should read something like this : "Live Load 100 psf (reducible for tributary area)".
The 100 psf is the basic, unreduced LL, and you take a percentage reduction based on area to get it less than 100 psf on areas greater than 150 sq. ft.
Just to reduce a difficult/fuzzy design problem to sensible approximation, why not assume it is actually an enclosed square in plan (enclosed within the diameter of the full circle)?
A steel beam fabricated in 1968 would likely be A36 steel, 36 kips/sq. in. yield.
The depth for the 30 pound/linear foot section is exactly 12 inches, and flange width is exactly 5 inches.
If the beam was fabricated prior to 1965, it would be A7 steel, 33 ksi yield.
The web is about 0.32 to...
Why not use just one worksheet for all the projects? Then, you would allocate the same number of rows (every employee) to each project. If an employee isn't working on given project, then number of hours = zero.
The project label or number would then occur every, say, 20th row, and you could...
I agree with the above posts recommneding the VLOOKUP commands. However, if you absolutely wish to nest more than 7 IF statements, then nest 6, with the remaining statements "chained" to another cell.
