{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Footings","Tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Footings","index":0,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,8,4,9],[7,16,7,17],[18,16,18,17],[6,10,9,12],[1,3,1,4],[3,1,3,16],[37,15,37,17],[24,9,24,10],[25,9,25,10],[25,4,26,4],[36,16,36,17],[26,5,26,6],[26,7,26,8],[26,9,26,10],[38,2,44,5],[24,5,24,6],[25,5,25,6],[24,7,24,8],[25,7,25,8]]}
[]
[null,"Primary Units:",null,"English"]
[null,"IF UNITS ARE NOT SELECTED, THIS FORM WILL DEFAULT TO ENGLISH UNITS."]
[null,"Class III Sign Post and Footer Calculations"]
[null,null,null,null,null,null,"W =",null,{"$f":"IF($D$2=\"Metric\",\"m (\"&ROUND(H5*3.28084,2)&\" ft)\",\"ft (\"&ROUND(H5/3.28084,2)&\" m)\")","v":"ft (0 m)"}]
[]
[null,null,null,null,null,null,null,null,null,null,"EXIT 291"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K =",null,{"$f":"IF($D$2=\"Metric\",\"m (\"&ROUND(P8*3.28084,2)&\" ft)\",\"ft (\"&ROUND(P8/3.28084,2)&\" m)\")","v":"ft (0 m)"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"V = Wind Speed =",null,{"$f":"IF($D$2=\"metric\",\"m/s (\"&ROUND(I13/5280*3.28084*3600,0)&\" MPH)\",\"MPH (\"&ROUND(I13*5280/3.28084/3600,0)&\" m/s)\")","v":"MPH (0 m/s)"}]
[]
[null,null,null,null,null,null,null,"Area = W x (L + K) =",{"$f":"H5*(P8+P19)","v":0},{"$f":"IF($D$2=\"metric\",\"SQ Meters (\"&ROUND(I15*10.7639,2)&\" SF)\",\"SF (\"&ROUND(I15/10.7639,2)&\" SQ Meters)\")","v":"SF (0 SQ Meters)"}]
[]
[null,null,null,null,null,null,null,"Moment Arm = 0.5 x (L + K) + X =",{"$f":"0.5*(P19+P8)+P37","v":0},{"$f":"IF($D$2=\"Metric\",\"m (\"&ROUND(I17*3.28084,2)&\" ft)\",\"ft (\"&ROUND(I17/3.28084,2)&\" m)\")","v":"ft (0 m)"}]
[]
[null,null,null,null,null,null,null,"Wind Pressure =",{"$f":"IFERROR(IF($D$2=\"Metric\",INDEX(Tables!G19:I23,MATCH(I13,Tables!F19:F23,1),MATCH(I17,Tables!G18:I18,1)),INDEX(Tables!C19:E23,MATCH(I13,Tables!B19:B23,1),MATCH(I17,Tables!C18:E18,1))),0)","v":0},{"$f":"IF($D$2=\"metric\",\"Pascal (\"&ROUND(I19/47.88026,0)&\" lbs/SF)\",\"lbs/SF (\"&ROUND(I19*47.88026,0)&\" Pascal)\")","v":"lbs/SF (0 Pascal)"},null,null,null,null,"L =",null,{"$f":"IF($D$2=\"Metric\",\"m (\"&ROUND(P19*3.28084,2)&\" ft)\",\"ft (\"&ROUND(P19/3.28084,2)&\" m)\")","v":"ft (0 m)"}]
[]
[null,null,null,null,null,null,null,"Rec. No. of Posts =",{"$f":"IF(H5>IF(D2=\"metric\",20/3.28084,20),3,2)","v":2},"Posts"]
[]
[null,null,null,null,null,null,null,"Calculated Moment =",{"$f":"I15*I17*I19/I21/1000","v":0},{"$f":"IF($D$2=\"Metric\",\"kN-m (\"&ROUND(I23*3.28084*0.225,2)&\" kips-ft)\",\"kips-ft (\"&ROUND(I23/3.28084/0.225,2)&\" kN-m)\")","v":"kips-ft (0 kN-m)"}]
[]
[null,null,null,null,null,"Post Size",null,"Footing Type",null,"Max Moment"]
[null,null,null,null,"USE:",{"$f":"IFERROR(IF($D$2=\"Metric\",INDEX(Tables!G5:G13,MATCH(I23,Tables!F5:F13,1)+1),INDEX(Tables!D5:D13,MATCH(I23,Tables!C5:C13,1)+1)),\"\")","v":""},null,{"$f":"IFERROR(IF($D$2=\"Metric\",INDEX(Tables!E5:E13,MATCH(I23,Tables!F5:F13,1)+1),INDEX(Tables!B5:B13,MATCH(I23,Tables!C5:C13,1)+1)),\"\")","v":""},null,{"$f":"IFERROR(IF($D$2=\"Metric\",INDEX(Tables!F5:F13,MATCH(F26,Tables!G5:G13,0))&\" kN-m\",INDEX(Tables!C5:C13,MATCH(F26,Tables!D5:D13,0))&\" kips-ft\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF($D$2=\"Metric\",INDEX(Tables!D5:D13,MATCH(I23*3.28084*0.225,Tables!C5:C13,1)+1),INDEX(Tables!G5:G13,MATCH(I23/3.28084/0.225,Tables!F5:F13,1)+1)),\"\")","v":""},null,{"$f":"IFERROR(IF($D$2=\"Metric\",INDEX(Tables!B5:B13,MATCH(I23*3.28084*0.225,Tables!C5:C13,1)+1),INDEX(Tables!E5:E13,MATCH(I23/3.28084/0.225,Tables!F5:F13,1)+1)),\"\")","v":""},null,{"$f":"IFERROR(IF($D$2=\"Metric\",INDEX(Tables!C5:C13,MATCH(F27,Tables!D5:D13,0))&\" kips-ft\",INDEX(Tables!F5:F13,MATCH(F27,Tables!G5:G13,0))&\" kN-m\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Y"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X=",null,{"$f":"IF($D$2=\"Metric\",\"m (\"&ROUND(P37*3.28084,2)&\" ft)\",\"ft (\"&ROUND(P37/3.28084,2)&\" m)\")","v":"ft (0 m)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(The Longest Post)"]
[null,null,"Disclaimer:\nThis Footings Form is to be used as a guide for Roadside Sign Footing Design.\n\nFor questions about this program, contact Anthony Vu: (303) 512-5109, anthony.vu@state.co.us."]

{"sheet":"Tables","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[16,1,17,1],[16,2,16,4],[16,6,16,8],[16,5,17,5],[1,1,1,6],[2,4,2,6],[15,5,15,8],[15,1,15,4],[2,1,2,3],[14,1,14,8]]}
[]
[null,"Concrete Footing Table"]
[null,"English Unit",null,null,"Metric Unit"]
[null,"Type","Max Allowed Moment","Size","Type","Max Allowed Moment","Size"]
[null,"4x4 Timber",1.4,"4x4 Timber","89x89 Timber",1.9,"89x89 Timber"]
[null,"6x6 Timber",5,"6x6 Timber","140x140 Timber",6.8,"140x140 Timber"]
[null,1,8.3000000000000007,"W6x12",1,11.3,"W150x18"]
[null,2,13.8,"W6x15",2,18.7,"W150x22"]
[null,3,20.399999999999999,"W8x18",3,27.7,"W200x27"]
[null,4,24.4,"W8x21",4,33.1,"W200x31"]
[null,5,32.299999999999997,"W10x22",5,43.8,"W250x33"]
[null,6,38.9,"W10x26",6,52.7,"W250x39"]
[null,7,46.5,"W12x26",7,63,"W310x39"]
[]
[null,"Wind Pressure Table"]
[null,"English Unit",null,null,null,"Metric Unit"]
[null,"Wind Speed","Height",null,null,"Wind Speed","Height"]
[null,null,0,16.399999999999999,24.6,null,0,5,7.5]
[null,80,18.2,19.899999999999999,21.1,36,873,951,1010]
[null,90,20.399999999999999,22.3,23.7,40,967,1053,1119]
[null,100,25.2,27.5,29.2,45,1224,1333,1416]
[null,110,30.5,33.299999999999997,35.299999999999997,49,1451,1581,1679]
[null,120,36.4,39.6,42.1,54,1763,1920,2040]