jhnblgr has a good suggestion to bring the footing up to slab level.
Can the roof provide lateral restraint? What if roof need to be removed? I would tend to not rely on the roof providing restraint and allow some movement at the top of the wall.
What about drainage, exterior loads, property...
Lapping gives continuity, not fixity, at least in my understanding of the words.
You get continuity and additional capacity over the support which is treated as a pin support for design.
In AWWA D103, Sec. 14.3 Seismic Design Loads
H = distance from bottom of shell to MOL in feet (m)
What does MOL mean?
From comparison with API 650 I think it is the maximum water water level, so Max Operating Level perhaps?
I am puzzled by this. P1 and P2 are referred to as pressure components but the units are kN/m height.
How is PT converted to hoop tension?
Referring to AWWA D103 it would appear that this is the hoop tension and hence the stress will be PT/t .
If this is so then it should read;
P1 =...
Here's my solution using normal functions. No macro required.
My approach is to first divide it into bite size pieces, so I deal with each level separately and combine those into the final result. It's easier to debug this way. I have used two columns to find the text for Level1. You can go back...
Without knowing more about the source I would suggest pasting as unformatted text.
Ooo eee ooo ah ah ting tang walla walla bing bang
Ooo eee ooo ah ah ting tang walla walla bing bang