To All: O.K. I got some ideas. I'll follow up on them. Thanks EGTO1 and jmw for the samples. I've created circular references before, a long time ago, but have forgotten what I did. I was using a different spreadsheet program that allowed one to select whether to iterate or not. The...
Norm: Tried that. The iteration box is stil checked. I suspect I do not have an appropriate definition for setting up the iteration process. Is there a function available to force an iteration that can be included within a cell? It will probably be nested in an IF function.
I would like to get some confirmation about my suspicion that there is no way to get Excel to automatically iterate cell calculations without using a VBA function. Solver is not an option for this spreadsheet. Can anyone confirm this?
A thought before you throw out that "100+" years of standards. You are still going to have to deal with the "backbone" of the previous 100+ years at your existing and new installations: Cables. While minuraturization and multiplexing of information has created opportunities...
Existing EHV transmission line? Find the longest span and determine the minimum line to ground clearance (courtesy of NESC). Determine the sag of the line at installation temperature or sag at existing temperature. Find normal load current and Isc at source and load terminals. If taps exist...
Fan noise will be attenuated to some degree through the duct. What kind of duct and fittings exist in the run makes a great difference in the amount of attenuation. Unlined duct gives a minor reduction to sound. More is found in the ASHRAE Fundamentals(1997), Ch.7, and Applications(1995)...