Well, I was going to post my solution, but it went way beyond figuring a simple footing ...
The spreadsheet I use (sorry but I am not allowed to post it) uses allows the user to specify these loads in live/dead PSF:
- Tributary roof loads
- Tributary floor loads
- Snow loads
- Point loads
Then it allows the user to enter the following for the footing:
- Soil Bearing Capacity
- Concrete strength PSI
- Steel Tensile Strength PSI
- Depth of rebar cover
The user can specify various items by default as well
- Footing size (x,y)
- Footing depth (z)
- Rebar size
- Number of rebar
- Smallest bearing plate
- Depth of footing below grade
The footing is calculated based on the input parameters for size and number of rebar, size and depth of footing, depth of rebar cover.
Loads are increased if the user selects a checkbox to do so. Liveloads are increased by 1.7 and dead loads by 1.4
Loads are increased/decreased based on the depth of the footing taking into consideration the backfill on the pad.
I have been working on converting it to lisp and vba over the last year or so so that I could enter the information (or better yet select the location in the drawing) and have it automatically calculate and draw it for me.
If I get it completed, I'll post it.