{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["I-Code Background","Instructions","Calculator"],"not_rendered":{"charts":0,"images":9,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"I-Code Background","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,0,2,14]]}
[]
[]
["2018 IRC Prescriptive Footing Calculator"]

{"sheet":"Instructions","index":1,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"To begin filling out the 2018 IRC Prescriptive Footing Calculator, select the \"Calculator\" tab at the bottom of this spreadsheet."]
["FIELD","INSTRUCTION"]
["Designer","The name of  the person inputting the calculations. "]
["Project Address","The address of the proposed project."]
["Project Description","The type of project, I.E. a single family house, garage, accessory building, etc."]
[]
["Soil Bearing Pressure","Input the assumed soil bearing capacity from the table on sheet 1 of this spreadsheet. Verification may be required at plan review."]
["Roof Snow Load","Input the roof snow load for the location the structure is to be built. Minimum is 30 PSF, if 70 PSF or higher a licensed design professional is required."]
[]
["Exterior Light Frame Wood Walls","The total height of the exterior wall section being reviewed. If a 2 or 3 story structure, add all floors together. I.E.- 1 story is 8', a 2 story is 16', etc.","A"]
["Exterior Light Frame Cold-Formed Steel Walls","Same as line 13 if the exterior walls are built from steel studs.","B"]
["Interior Light Frame Wood Walls","Utilized for calculationg an interior footing size when wood studs are used. Add numbers as per line 13 above.","C"]
["Interior Light Frame Cold-Formed Steel Walls","Utilized for calculationg an interior footing size when steel studs are used. Add numbers as per line 13 above.","D"]
["Masonry Veneer","Add in the height of masonry or brick veneer that is used on the wall system.","E"]
["Masonry Walls (8\")","Total height of an 8\" thick masonry wall. If used for the foundation, measure from the top of the footing to the top of the masonry wall.","F"]
["Concrete Walls (6\")","Total height of a 6\" thick concrete wall. Typically utilized for a crawl space foundation, measure from the top of the footing to the top of the concrete wall.","G"]
["Concrete Walls (8\")","Total height of an 8\" thick concrete wall. Typically used for the basement foundation, measure from the top of the footing to the top of the concrete wall.","H"]
["SIP Walls","Total height of an exterior wall system utilizing SIP's panels. Input height as per line 13 above.","I"]
["Weight of Walls","This line shows the total weight of the wall system for a 1' wide section."]
[]
[]
[]
[]
["Roof Snow Loads","Input the tributary width of the roof system at the point on an exterior wall a footing is being calculated. I.E., the roof is a clear span truss that spans 50, the tributary load is 25', half of the total span.","J"]
["Floor 2 Live Load","Input the tributary width of the floor system at the point on an exterior wall a footing is being calculated. I.E., the floor joist spans 14' from the exterior wall to an interior bearing wall, the tributary load is 7', half the total span.","K"]
["Floor 1 Live Load","Input the tributary width of the floor system at the point on an exterior wall a footing is being calculated. I.E., the floor joist spans 14' from the exterior wall to an interior bearing wall, the tributary load is 7', half the total span.","L"]
["Deck Live Load","Input the tributary widht of the deck system at the point on an exterior wall a footing is being calculated. I.E., the deck joist spans 8' from the exterior wall to a bearing beam, the tributary load is 4', half the total span.","M"]
["Weight of Walls","This line shows the total weight of the roof and floor system for a 1' wide section."]
[]
["Total Weight of Floors and Roof","This line shows the total weight of the 1' section of exterior wall, foundation, roof and floor system for the location being calculated."]
[]
["Continuous Footing Width","This is the minimum width of footing required to support the calculated weight for the chosen soil bearing pressure on site."]
["Continuous Footing Depth","This is the minimum depth/thickness required to support the calculated weight for the chosen soil bearing pressure on site."]
[]
["Spread Footing Identified as:","Input an identifier to locate on the plans the spread footing being calculated."]
[]
["Point loads greater than 1500 lb.","Input the total point load that a footing pad is being calculated for. Note, lines 13 thru 31 from above need to be blank or the size calculated will be oversized."]
[]
["Spread Footing Width","This is the minimum square size of footing calculated, I.E., 2' by 2', for a point load footing."]
["Spread Footing Depth","This is the minimum depth/thickness of the point load footing."]

{"sheet":"Calculator","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[9,1,9,2],[9,3,9,5],[1,1,1,5],[3,2,3,5],[4,1,4,5],[6,1,6,2],[7,1,7,2],[30,1,30,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,4],[28,1,28,4],[48,1,48,5],[32,1,32,2],[33,1,33,2],[35,1,35,2],[35,3,35,5],[37,1,37,2],[39,1,39,2],[40,1,40,2],[45,1,45,5],[46,1,46,5],[47,1,47,5],[43,1,44,5]]}
[]
[null,"Prescriptive Continuous Footing Calculator Based on 2018 IRC ᵈ ᵉ"]
[]
[null,"Designer:","Project Address:"]
[null,"Project Description: "]
[]
[null,"Soil Bearing Pressure (lb/sq ft) ᵃ",null,null,1500]
[null,"Roof Snow Load (lb/sq ft) ᵇ",null,null,30]
[]
[null,"Continous Footing for Wall Line Identified as:"]
[]
[null,null,null,"Dead Load (lb/sq ft)","Wall Height (ft)","Wall Load (lb/lin ft)"]
[null,"Exterior Light Frame Wood Walls",null,15,null,{"$f":"D13*E13","v":0}]
[null,"Exterior Light Frame Cold-Formed Steel Walls",null,14,null,{"$f":"D14*E14","v":0}]
[null,"Interior Light Frame Wood Walls",null,10,null,0]
[null,"Interior Light Frame Cold-Formed Steel Walls",null,5,null,0]
[null,"Masonry Veneer",null,50,null,0]
[null,"Masonry Walls (8\")",null,80,null,0]
[null,"Concrete Walls (6\")",null,85,null,0]
[null,"Concrete Walls (8\")",null,110,null,0]
[null,"SIP Walls",null,10,null,0]
[null,"Weight of Walls (lbs/lin ft) ",null,null,null,{"$f":"SUM(F13:F21)","v":0}]
[]
[null,null,"Dead Load (lb/sq ft)","Live Load (lb/sq ft)","Tributary Width (ft)","Floor Load (lb/lin ft)"]
[null,"Roof Snow Loads",15,{"$f":"E8","v":30},null,{"$f":"(D25+C25)*E25","v":0}]
[null,"Floor 2 Live Load",10,40,null,{"$f":"(D26+C26)*E26","v":0}]
[null,"Floor 1 Live Load",10,40,null,0]
[null,"Deck Live Load",10,60,null,0]
[null,"Weight of Floors and Roof (lb/lin ft) ",null,null,null,{"$f":"SUM(F25:F28)","v":0}]
[]
[null,"Total Weight of Walls, Floors, and Roof (lb/lin ft)",null,null,null,{"$f":"F22+F29","v":0}]
[]
[null,"Continuous Footing Width (in)",null,null,null,{"$f":"MAX(ROUND(F31*12/E7,0),12)","v":12}]
[null,"Continuous Footing Depth (in)",null,null,null,{"$f":"MAX(ROUND((F33-(IF(F19,6,8)))/2,0),6)","v":6}]
[]
[null,"Spread Footing Identified as:"]
[]
[null,"Point loads greater than 1500 lb"]
[]
[null,"Spread Footing Width (in) ᶜ",null,null,null,{"$f":"MAX(ROUND(SQRT(E38/E7*144),0),F33)","v":12}]
[null,"Spread Footing Depth (in)",null,null,null,{"$f":"MAX(ROUND(((F40-6)/2),0),F34)","v":6}]
[]
[null,"Notes:"]
[null,"a. Minimum soil bearing pressure is 1,500 lb/sq ft. If using a higher value, provide justification of soil bearing capacity."]
[]
[null,"b. Roof Snow Load = 0.7 X Ground Snow Load"]
[null,"c. Provide spread footing at point load location if width is greater than continuous footing width"]
[null,"d. User to input values in white cells only"]
[null,"e. Weights of materials shall not exceed values listed in R301.2.2.2"]
[null,"For help filling out the Calculator, select the \"Instructions\" tab at the bottom of this spreadsheet."]