{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Durability Design","Example","Reference Data","ODOT Pipe Charts","Revisions","Steel Pipe Charts","Conduit Material Photos"],"not_rendered":{"charts":0,"images":41,"macros":1,"external_links":0,"defined_names":31,"comments":1,"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":"Instructions","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Durabilty Design Notes:"]
[]
[null,null,"Many options are eliminated when abrasion level equals 4 or greater"]
[null,null,"Aluminum is only available between pH levels ranging from 5.0 to less than 9.0"]
[null,null,"Aluminized protective coating is 0 years when pH levels are outside of allowable for Aluminum"]
[null,null,"Polymeric coated is only available for pH ranges greater than 5.0 and less than 9.0"]
[null,null,"Options were emiminated when the NCSPA online Service Life Calculator did not recommend option; typically due to abrasive conditions or pH limitations"]
[null,null,"Epoxy is required on all concrete surfaces when pH<5"]
[null,null,"Provide concrete field paving on corrugated metal conduits 60” or larger where the invert is always submerged due to tail water conditions from a body of water"]
[null,null,"Designer is responsible to ensure the required gage thickness is available for the given pipe size"]
[null,null,"Concrete Invert paving is available at 60\" span/rise or larger"]
[]
[]
[null,"User Instructions:","Provide at least one pipe material option from metal pipe, concrete pipe, and plastic pipe when feasible"]
[null,null,"Provide a maximum of 3 options per material in the plans.  Metal pipe has many options.  Relative material cost increases from left to right and top to bottom in the durability design tab.  Contact material vendor as required to verify relative cost.  "]
[null,null,"Cells in yellow require user input. Three inputs are required: Conduit Type, Stream pH, & Abrasion Level"]
[null,null,"A pop-up box will appear with additional instructions when an input is selected"]
[null,null,"See the 'Reference Data' tab for Abrasion Level descriptions and photos"]
[null,null,"For Storm Sewers: assume abrasion level =1  and pH=7. Designer may modify as site conditions require."]
[null,null,"For Culverts: Use field collected pH; and stream abrasion level according to section 1002.2.2 in L&D, Vol. 2"]
[null,null,"Cells that appear in light blue are the minimum gauge or thickness (inches) permitted by ODOT Specifications"]
[null,null,"Cells that appear in blue are the maximum gauge or thickness (inches) commercially available for a given conduit size. Do not specify a conduit exceeding the maximum gauge or thickness commercially available."]
[null,null,"Cells that appear in green meet service life requirements, however available gauge needs to be verified. "]
[null,null,"Use the highest gauge/lowest thickness that is an available option shown in a green cell that is at least the minimum gauge thickness permitted by ODOT specifications and does not exceed the maximum commercially available"]
[null,null,"Cells that appear in red do not meet service life requirements or are not commercially available options"]

{"sheet":"Durability Design","index":1,"n_rows":58,"n_cols":25,"rows_kept":58,"cut":false,"hidden":false,"merged":[[55,11,55,12],[17,1,17,24],[22,1,22,24],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[54,11,54,12],[36,1,36,2],[37,1,37,2],[40,1,40,16],[41,1,41,2],[42,1,42,2],[47,11,47,13],[24,24,32,24],[9,1,9,24],[10,1,10,2],[11,1,11,2],[24,20,32,20],[24,21,32,21],[24,22,32,22],[24,23,32,23],[13,1,16,1],[13,19,16,19],[18,1,21,1],[18,19,21,19],[1,1,1,14],[2,2,2,3],[3,2,3,3],[3,5,3,6],[4,10,5,11],[5,2,5,3],[5,5,5,8]]}
[]
[null,"See Instructions on Tab 1"]
[null,"County","Columbiana",null,"Route",644,"Section",7.96,"PID",118153,"Shape","Circular"]
[null,"Station","422+43.07",null,"Station","422+52.73",null,null,null,null,"Span x Rise",30]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L3=\"Elliptical\",\"Span and Rise not Required for Elliptical Shape\",IF(L3=\"Box\",\"Contact Manufacturer for Span and Rise for Metal Box if specified.\",\"\"))","v":""}]
[null,null,"User Input",null,null,"Constants and Calculated Values"]
[null,null,"pHw","Abrasion Level",null,"pHs","Sediment/Rise","End of Service Life GA","Service Life Required"]
[null,null,6.5,4,null,7.6,0,4,75]
[]
[null,"Metal Conduit Durability Results"]
[null,"Material",null,"707.01 , 707.02, or 707.03 Metallic coated (galvanized)",{"$f":"IF($C$8>=6, \"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with Concrete Field Paving\", IF( $C$8>=5,\"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with External Coating per AASHTO M243 and Concrete Field Paving\",\"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with External Coating per AASHTO M243 and Concrete Field Paving with Epoxy per 706.03\"))","v":"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with Concrete Field Paving"},"707.01 or 707.02 Metallic coated (Aluminized)",{"$f":"IF($C$8>=6, \"***707.01 or 707.02 Metallic coated (aluminized) with Concrete Field Paving\", IF( $C$8>=5,\"***707.01 or 707.02 Metallic coated (aluminized) with External Coating per AASHTO M243 and Concrete Field Paving\",\"***707.01 or 707.02 Metallic coated (aluminized) with External Coating per AASHTO M243 and Concrete Field Paving with Epoxy per 706.03\"))","v":"***707.01 or 707.02 Metallic coated (aluminized) with Concrete Field Paving"},"707.04 Polymeric Coated over galvanized steel",{"$f":"IF($C$8>=5, \"***707.04 Polymeric Coated with Concrete Field Paving\", \"***707.04 Polymeric Coated  with Epoxy Coated (per 706.03) Concrete Field Paving\")","v":"***707.04 Polymeric Coated with Concrete Field Paving"},"707.05 or 707.07 (707.01 or 707.02 galvanized)  1/2 Bituminous coated with Bituminous paved invert","***707.05 or 707.07 (707.01 or 707.02 aluminized) 1/2 Bituminous coated with Bituminous paved invert","**707.11 Polymer Precoated spiral rib steel","**707.12 or 707.17 Aluminum coated spiral rib steel","707.13 or 707.14 (707.01 or 707.02 galvanized) Bituminous lined galvanized steel","707.13 or 707.14 (707.01 or 707.02 aluminized) Bituminous lined aluminized steel","707.15 Galvanized steel box","**707.18 Polymer Precoated, Galvanized Steel Conduits with precoated galvanized smooth steel interior liner","**707.19 Aluminum coated Steel Conduits with precoated galvanized smooth steel interior liner","**707.20 Galvanized Coated Steel Conduits with precoated galvanized smooth steel interior liner","**748.06 Steel Casing Pipe non-galvanized","707.21 or 707.22 Aluminum","707.23 Aluminum Structural Plate","707.24 Aluminum Spiral Rib","707.25 Aluminum Box",{"$f":"IF($C$8>=5,\"707.21, 707.22, or 707.23 Aluminum Alloy or Aluminum Alloy Structural Plate with Concrete Invert Paving\",\"707.21, 707.22, or 707.23 Aluminum Alloy or Aluminum Alloy Structural Plate with Concrete Invert Paving with Epoxy Coated (per 706.03) Concrete Invert Paving\")","v":"707.21, 707.22, or 707.23 Aluminum Alloy or Aluminum Alloy Structural Plate with Concrete Invert Paving"}]
[null,"Conduit Use and Shape",null,"Culvert or Liner Pipe -Round or Pipe Arch","Culvert-Round, Pipe Arch, and Arch","Culvert or Liner Pipe -Round or Pipe Arch","Culvert -Round or Pipe Arch","Culvert or Liner Pipe -Round or Pipe Arch","Culvert-Round or Pipe Arch","Culvert -Round or Pipe Arch","Culvert -Round or Pipe Arch","Storm Sewer or Liner Pipe- Round","Liner Pipe- Round or Pipe Arch","Storm Sewer - Round or Pipe Arch","Storm Sewer -Round or Pipe Arch","Culvert -Box","Liner Pipe -Round ","Liner Pipe -Round","Liner Pipe - Round ","Culvert or Liner Pipe-Round, Pipe Arch, or Box","Culvert or Liner Pipe-Round or Pipe Arch","Culvert or Liner Pipe -Round, Pipe Arch, and Arch","Storm Sewer or Liner Pipe -Round","Culvert -Box","Culvert - Round or Pipe Arch"]
[null,null,"Corr. Depth (inches)"]
[null,"min gauge or thickness ","1/4 or 1/2",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,5),\"N/A\")))","v":16},16,16,16,16,16,16,16,"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,5),\"N/A\")))","v":16},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,5),\"N/A\")))","v":16},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":16},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":16},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":16},0.5,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,3),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,3),\"N/A\")))","v":14},"N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,3),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,3),\"N/A\")))","v":14}]
[null,null,1,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":"N/A"},"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":"N/A"},"N/A","N/A","N/A","N/A",null,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,3),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,3,FALSE),\"N/A\")))","v":"N/A"},"N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,3),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,3,FALSE),\"N/A\")))","v":"N/A"}]
[null,null,2,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,6)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,6)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":"N/A"},"N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,6)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":"N/A"},"N/A","N/A","N/A","N/A","N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),12,\"N/A\"),\"N/A\")","v":"N/A"},"N/A","N/A","N/A",null,"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,6)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,6),\"N/A\")))","v":"N/A"},"N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),0.1,\"N/A\"),\"N/A\")","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,6)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,6),\"N/A\")))","v":"N/A"}]
[null,null,"3/4","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":16},{"$f":"IFERROR((IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE),IF(VLOOKUP($L$4,all_pipe_arch,8,FALSE)=\"1/4 \",VLOOKUP($L$4,Spiral_Rib_Pipe_Arch,6),\"N/A\")))),\"N/A\")","v":16},"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4<18,$L$4>66),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Spiral_Rib,6))","v":16},"N/A","N/A"]
[]
[null,"max gauge or thickness ","1/4 or 1/2",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,8),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,8),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":12},"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":12},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":12},0.5,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,4),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,4),\"N/A\")))","v":10},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4<18,$L$4>66),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Spiral_Rib,7))","v":12},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,4),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,4),\"N/A\")))","v":10}]
[null,null,1,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,8,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,8,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":"N/A"},"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":"N/A"},"N/A","N/A","N/A","N/A",null,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,4),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,4,FALSE),\"N/A\")))","v":"N/A"},"N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,4),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,4,FALSE),\"N/A\")))","v":"N/A"}]
[null,null,2,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,7)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,7)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":"N/A"},"N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,7)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":"N/A"},"N/A","N/A","N/A","N/A","N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),1,\"N/A\"),\"N/A\")","v":"N/A"},"N/A","N/A","N/A",null,"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,7)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,7),\"N/A\")))","v":"N/A"},"N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),0.25,\"N/A\"),\"N/A\")","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,7)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,7),\"N/A\")))","v":"N/A"}]
[null,null,"3/4","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":12},{"$f":"IFERROR((IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,8,FALSE),IF(VLOOKUP($L$4,all_pipe_arch,8,FALSE)=\"1/4 \",VLOOKUP($L$4,Spiral_Rib_Pipe_Arch,8),\"N/A\")))),\"N/A\")","v":12},"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4<18,$L$4>66),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Spiral_Rib,7))","v":12},"N/A","N/A"]
[]
[null,"Gauge","Thickness (inches)",{"$f":"N56","v":0},{"$f":"N50","v":20},{"$f":"N51","v":35},{"$f":"N50+N51","v":55},{"$f":"N53","v":50},{"$f":"N50+N53","v":70},{"$f":"N54","v":10},{"$f":"N54+N51","v":45},{"$f":"N53","v":50},{"$f":"N52","v":35},{"$f":"N55","v":25},{"$f":"N51+N55","v":60},{"$f":"N56","v":0},{"$f":"N53","v":50},{"$f":"N53","v":50},{"$f":"N53","v":50},0,75,null,null,null,{"$f":"75+N50","v":95}]
[null,16,6.4000000000000001E-2,{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$D$24)))","v":0},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$F$24),0)))","v":0},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},{"$f":"IF($D$8>=4,0,IF($C$8<=5,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$H$24))))","v":0},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},{"$f":"IF(OR($D$8>=4,$C$8<6),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$J$24))","v":0},{"$f":"IF(OR($D$8>=4,$C$8<5),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$K$24))","v":0},{"$f":"IF(OR($D$8>=4,$C$8<=5),0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$L$24)))","v":0},{"$f":"IF($D$8>=4,0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$M$24),0))","v":0},{"$f":"IF($D$8>=4,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$N$24))","v":0},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$O$24),0)))","v":0},{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$P$24)))","v":0},{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":82.607447232501272},{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":82.607447232501272},{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":82.607447232501272},null,{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":0},{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":0},{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":0},{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":0},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF(AND($C$8>=5,$C$8<9),$Y$24,0)))))","v":0}]
[null,14,7.9000000000000001E-2,{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$D$24)))","v":0},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$F$24),0)))","v":0},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},{"$f":"IF($D$8>=4,0,IF($C$8<=5,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$H$24))))","v":0},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},{"$f":"IF(OR($D$8>=4,$C$8<6),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$J$24))","v":0},{"$f":"IF(OR($D$8>=4,$C$8<5),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$K$24))","v":0},{"$f":"IF(OR($D$8>=4,$C$8<=5),0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$L$24)))","v":0},{"$f":"IF($D$8>=4,0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$M$24),0))","v":0},{"$f":"IF($D$8>=4,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$N$24))","v":0},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$O$24),0)))","v":0},{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$P$24)))","v":0},84.884800173677746,84.884800173677746,84.884800173677746]
[null,12,0.109,0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},0,0,0,0,0,0,0,{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":89.439506056030694},89.439506056030694,89.439506056030694]
[null,10,0.13800000000000001,0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},0,0,0,0,0,0,0,{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":93.842388408971871},93.842388408971871,93.842388408971871]
[null,8,0.16800000000000001,0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C29)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C29)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C29)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},0,0,0,0,0,0,0,98.397094291324805,98.397094291324805,98.397094291324805]
[null,7,0.188,0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C30)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C30)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C30)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},0,0,0,0,0,0,0,101.43356487956012,101.43356487956012,101.43356487956012]
[null,5,0.218,0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C31)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C31)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C31)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},0,0,0,0,0,0,0,105.98827076191304,105.98827076191304,105.98827076191304]
[null,3,0.249,0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C32)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C32)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C32)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},0,0,0,0,0,0,0,110.69480017367775,110.69480017367775,110.69480017367775]
[null,1,0.28000000000000003,0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C33)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C33)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":0},0,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C33)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":0},0,0,0,0,0,0,0,115.40132958544248,115.40132958544248,115.40132958544248]
[null,"Casing",0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$8<5,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C34)-(6.466*LOG10($F$8))+4.254)/-0.068)+$T$24)","v":98.802506056030694}]
[]
[null,"Concrete Conduit Durability Results"]
[null,"Material",null,"**706.01 Non-reinforced Concrete Pipe","**706.02 Reinforced Concrete Circular Pipe","**706.03 Reinforced Concrete Pipe, Epoxy Coated","**706.04 Reinforced Concrete Elliptical Culvert, Storm Drain, and Sewer Pipe","**706.05 Precast Reinforced Concrete Box Sections","706.08 Clay Drain Tile"]
[null,"Conduit Use and Shape",null,"Culvert or Storm Sewer -Round","Culvet or Storm Sewer -Round","Culvert or Storm Sewer -Round or Elliptical","Culvert or Storm Sewer -Elliptical","Culvert or Storm Sewer -Box","Culvert or Storm Sewer - Round"]
[null,null,null,{"$f":"IF(AND($L$3=\"Circular\",$L$4<=36),($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":109.89349496751859},{"$f":"IF(L3=\"Circular\",($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":109.89349496751859},{"$f":"IF(OR(L3=\"Circular\",L3=\"Elliptical\"),IF($D$39<$I$8,\"epoxy required\",IF($C$8<5,\"epoxy required\",\"epoxy not required\")),0)","v":"epoxy not required"},{"$f":"IF(L3=\"Elliptical\",($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":0},{"$f":"IF(L3=\"Box\",($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=48),$I$8,0)","v":75}]
[]
[null,"Plastic Conduit Durability Results"]
[null,"Material",null,"707.33 Corrugated Polyethylene Smooth Lined Pipe","707.34 Polyethylene Plastic Pipe Based on Outside Diameter (OD)","707.35 Polyethylene Profile Wall Pipe","707.42 Polyvinyl Chloride Corrugated Smooth Interior Pipe","707.43 Polyvinyl Chloride Profile Wall Pipe","707.45 Polyvinyl Chloride Solid Wall Pipe","707.46 Polyvinyl Chloride Drain Waste and Vent Pipe","707.47 ABS and Polyvinyl Chloride Composite Pipe","707.48 Polyvinyl Chloride Large-Diameter Solid Wall Pipe","707.65 Polypropylene corrugated Double Wall Pipe","707.69 Polypropylene Triple Wall Pipe","707.75 Glass-Fiber-Reinforced Polymer Mortar Pipe","748.02 Polyvinyl Chloride (PVC) Pipe, Joints, and Fittings","SS938 Steel Reinforced Thermoplastic Ribbed Pipe"]
[null,"Conduit Use and Shape",null,"Culvert, Storm Sewer, or Liner Pipe - Round","Culvert, Storm Sewer, or Liner Pipe - Round","Culvert, Storm Sewer, or Liner Pipe - Round","Storm Sewer or Liner Pipe - Round","Storm Sewer or Liner Pipe - Round","Storm Sewer - Round","Storm Sewer - Round","Storm Sewer - Round","Storm Sewer - Round","Culvert or Storm Sewer - Round","Culvert or Storm Sewer - Round","Culvert, Storm Sewer, or Liner Pipe - Round","Storm Sewer - Round","Culvert or Liner Pipe - Round"]
[null,null,null,{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=132),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=48),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=48),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=15),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=24),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=15),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4>=18,$L$4<=60),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=156),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4>=30,$L$4<=120),$I$8,0)","v":75}]
[]
[]
[]
[null,null,"Notes:",null,null,null,null,null,null,null,null,"Constants"]
[null,null,null,"Many metal options are eliminated when abrasion level equals 4 or greater",null,null,null,null,null,null,null,null,"Protective Coating Constants-Initial Service Life (years)"]
[null,null,null,"Aluminum is only available between pH levels ranging from 5.0 to less than 9.0",null,null,null,null,null,null,null,"Concrete Invert Paving=",null,20]
[null,null,null,"Alumized protective coating is 0 years when pH levels are outside of allowable for Aluminum",null,null,null,null,null,null,null,"Aluminized=",null,35]
[null,null,null,"Polymeric coated is only available for pH ranges greater than 5.0 and less than 9.0",null,null,null,null,null,null,null,"Aluminized Spiral Rib=",null,35]
[null,null,null,"Options were emiminated when the NCSPA online Service Life Calculator did not recommend option; typically due to abrasive conditions or pH limitations",null,null,null,null,null,null,null,"Polymeric=",null,50]
[null,null,null,"Epoxy is required on all concrete surfaces when pH<5",null,null,null,null,null,null,null,"Bituminous coated w/ bitum. paved invert=",null,10]
[null,null,null,"** Smooth lined conduit ",null,null,null,null,null,null,null,"Bituminous lined =",null,25]
[null,null,null,"***Minimum gauges set per industry comments; see Reference Data",null,null,null,null,null,null,null,"Galvanized=",null,0]
[null,null,null,"Provide concrete field paving on corrugated metal conduits 60” or larger where the invert is always submerged due to tail water conditions from a body of water"]
[null,null,null,"Designer is responsible to ensure the required gage thickness is available for the given pipe size"]

{"sheet":"Example","index":2,"n_rows":68,"n_cols":25,"rows_kept":68,"cut":false,"hidden":false,"merged":[[17,1,17,24],[65,11,65,12],[36,12,38,16],[46,12,50,16],[51,3,51,8],[52,3,55,8],[63,11,63,12],[64,11,64,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[57,11,57,13],[36,1,36,2],[37,1,37,2],[40,1,40,16],[9,1,9,24],[10,1,10,2],[11,1,11,2],[13,1,16,1],[13,19,16,19],[41,1,41,2],[42,1,42,2],[18,1,21,1],[18,19,21,19],[22,1,22,24],[24,20,32,20],[24,21,32,21],[24,22,32,22],[24,23,32,23],[24,24,32,24],[1,1,1,14],[2,2,2,3],[3,2,3,3],[3,5,3,6],[4,10,5,11],[5,2,5,3],[5,5,5,8],[3,12,6,17]]}
[]
[null,"Example -Conduit Type: Type A Culvert; Conduit Shape:  Circular; Hydraulic Requirements: 66 inch smooth or corrugated; Stream Information:  pH=7.8, Abrasion Level=2"]
[null,"County","Knox",null,"Route",4,"Section",14.36,"PID",99999,"Shape","Circular"]
[null,"Station","16+00",null,"Station","16+00",null,null,null,null,"Span x Rise",66,"Metal Options:  66\" Type A Conduit, 707.02 (0.109) with CFP, 707.02 (0.064) aluminized, 707.04 (0.064)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L3=\"Elliptical\",\"Span and Rise not Required for Elliptical Shape\",IF(L3=\"Box\",\"Contact Manufacturer for Span and Rise for Metal Box if specified.\",\"\"))","v":""}]
[null,null,"User Input",null,null,"Constants and Calculated Values"]
[null,null,"pHw","Abrasion Level",null,"pHs","Sediment/Rise","End of Service Life GA","Service Life Required"]
[null,null,7.8,2,null,7.6,0,4,75]
[]
[null,"Metal Conduit Durability Results"]
[null,"Material",null,"707.01 , 707.02, or 707.03 Metallic coated (galvanized)",{"$f":"IF($C$8>=6, \"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with Concrete Field Paving\", IF( $C$8>=5,\"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with External Coating per AASHTO M243 and Concrete Field Paving\",\"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with External Coating per AASHTO M243 and Concrete Field Paving with Epoxy per 706.03\"))","v":"707.01 or 707.02 or 707.03 Metallic coated (galvanized) with Concrete Field Paving"},"707.01 or 707.02 Metallic coated (Aluminized)",{"$f":"IF($C$8>=6, \"***707.01 or 707.02 Metallic coated (aluminized) with Concrete Field Paving\", IF( $C$8>=5,\"***707.01 or 707.02 Metallic coated (aluminized) with External Coating per AASHTO M243 and Concrete Field Paving\",\"***707.01 or 707.02 Metallic coated (aluminized) with External Coating per AASHTO M243 and Concrete Field Paving with Epoxy per 706.03\"))","v":"***707.01 or 707.02 Metallic coated (aluminized) with Concrete Field Paving"},"707.04 Polymeric Coated over galvanized steel",{"$f":"IF($C$8>=5, \"***707.04 Polymeric Coated with Concrete Field Paving\", \"***707.04 Polymeric Coated  with Epoxy Coated (per 706.03) Concrete Field Paving\")","v":"***707.04 Polymeric Coated with Concrete Field Paving"},"707.05 or 707.07 (707.01 or 707.02 galvanized)  1/2 Bituminous coated with Bituminous paved invert","***707.05 or 707.07 (707.01 or 707.02 aluminized) 1/2 Bituminous coated with Bituminous paved invert","**707.11 Polymer Precoated spiral rib steel","**707.12 or 707.17 Aluminum coated spiral rib steel","707.13 or 707.14 (707.01 or 707.02 galvanized) Bituminous lined galvanized steel","707.13 or 707.14 (707.01 or 707.02 aluminized) Bituminous lined aluminized steel","707.15 Galvanized steel box","**707.18 Polymer Precoated, Galvanized Steel Conduits with precoated galvanized smooth steel interior liner","**707.19 Aluminum coated Steel Conduits with precoated galvanized smooth steel interior liner","**707.20 Galvanized Coated Steel Conduits with precoated galvanized smooth steel interior liner","**748.06 Steel Casing Pipe non-galvanized","707.21 or 707.22 Aluminum","707.23 Aluminum Structural Plate","707.24 Aluminum Spiral Rib","707.25 Aluminum Box",{"$f":"IF($C$8>=5,\"707.21, 707.22, or 707.23 Aluminum Alloy or Aluminum Alloy Structural Plate with Concrete Invert Paving\",\"707.21, 707.22, or 707.23 Aluminum Alloy or Aluminum Alloy Structural Plate with Concrete Invert Paving with Epoxy Coated (per 706.03) Concrete Invert Paving\")","v":"707.21, 707.22, or 707.23 Aluminum Alloy or Aluminum Alloy Structural Plate with Concrete Invert Paving"}]
[null,"Conduit Use and Shape",null,"Culvert or Liner Pipe -Round or Pipe Arch","Culvert-Round, Pipe Arch, and Arch","Culvert or Liner Pipe -Round or Pipe Arch","Culvert -Round or Pipe Arch","Culvert or Liner Pipe -Round or Pipe Arch","Culvert-Round or Pipe Arch","Culvert -Round or Pipe Arch","Culvert -Round or Pipe Arch","Storm Sewer or Liner Pipe- Round","Liner Pipe- Round or Pipe Arch","Storm Sewer - Round or Pipe Arch","Storm Sewer -Round or Pipe Arch","Culvert -Box","Liner Pipe -Round ","Liner Pipe -Round","Liner Pipe - Round ","Culvert or Liner Pipe-Round, Pipe Arch, or Box","Culvert or Liner Pipe-Round or Pipe Arch","Culvert or Liner Pipe -Round, Pipe Arch, and Arch","Storm Sewer or Liner Pipe -Round","Culvert -Box","Culvert - Round or Pipe Arch"]
[null,null,"Corr. Depth (inches)"]
[null,"min gauge or thickness ","1/4 or 1/2",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,5),\"N/A\")))","v":10},10,10,10,10,10,10,10,"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,5),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,5),\"N/A\")))","v":10},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":12},0.5,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,3),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,3),\"N/A\")))","v":8},"N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,3),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,3),\"N/A\")))","v":8}]
[null,null,1,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":12},"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,6),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,5,FALSE),\"N/A\")))","v":12},"N/A","N/A","N/A","N/A",null,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,3),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,3,FALSE),\"N/A\")))","v":12},"N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,3),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,3,FALSE),\"N/A\")))","v":12}]
[null,null,2,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,6)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":12},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,6)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":12},"N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,6)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":12},"N/A","N/A","N/A","N/A","N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),12,\"N/A\"),\"N/A\")","v":"N/A"},"N/A","N/A","N/A",null,"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,6)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,6),\"N/A\")))","v":0.1},"N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),0.1,\"N/A\"),\"N/A\")","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,6)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,6),\"N/A\")))","v":0.1}]
[null,null,"3/4","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE)))","v":12},{"$f":"IFERROR((IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,6,FALSE),IF(VLOOKUP($L$4,all_pipe_arch,8,FALSE)=\"1/4 \",VLOOKUP($L$4,Spiral_Rib_Pipe_Arch,6),\"N/A\")))),\"N/A\")","v":12},"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4<18,$L$4>66),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Spiral_Rib,6))","v":10},"N/A","N/A"]
[]
[null,"max gauge or thickness ","1/4 or 1/2",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,8),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,8),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":10},"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,6),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=84,VLOOKUP($L$4,Round_Half_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,2,FALSE)=\"1/4 or 1/2\",VLOOKUP($L$4,Pipe_Arch_Half_Corrugations,7),\"N/A\")))","v":10},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":10},0.5,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,4),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,4),\"N/A\")))","v":8},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4<18,$L$4>66),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Spiral_Rib,7))","v":10},"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<=72,VLOOKUP($L$4,Aluminum_Half_Corrugations,4),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,5,FALSE)=\" 1/2\",VLOOKUP($L$4,Aluminum_Pipe_Arch_Half_Corrugations,4),\"N/A\")))","v":8}]
[null,null,1,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,8,FALSE),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,9),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,8,FALSE),\"N/A\")))","v":10},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1),VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":10},"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,7),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,6,FALSE),\"N/A\")))","v":8},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Round_Inch_Corrugations,8),\"N/A\"),IF(VLOOKUP($L$4,all_pipe_arch,3,FALSE)=1,VLOOKUP($L$4,Pipe_Arch_Inch_Corrugations,7,FALSE),\"N/A\")))","v":10},"N/A","N/A","N/A","N/A",null,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,4),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,4,FALSE),\"N/A\")))","v":8},"N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(AND($L$4>=36,$L$4<=120),VLOOKUP($L$4,Aluminum_Inch_Corrugations,4),\"N/A\"),IF((VLOOKUP($L$4,all_pipe_arch,6,FALSE)=1),VLOOKUP($L$4,Aluminum_Pipe_Arch_Inch_Corrugations,4,FALSE),\"N/A\")))","v":8}]
[null,null,2,{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,7)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":1},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,7)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":1},"N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF($L$4<60,\"N/A\",VLOOKUP($L$4,Round_Plate,7)),IF(VLOOKUP($L$4,all_pipe_arch,4,FALSE)=2,1,\"N/A\")))","v":1},"N/A","N/A","N/A","N/A","N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),1,\"N/A\"),\"N/A\")","v":"N/A"},"N/A","N/A","N/A",null,"N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,7)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,7),\"N/A\")))","v":0.25},"N/A",{"$f":"IF($L$3=\"Box\",IF(OR($P$25>=75,$P$26>=75,$P$27>=75,$P$28>=75,$P$29>=75,$P$30>=75,$P$31>=75,$P$32>=75,$P$33>=75),0.25,\"N/A\"),\"N/A\")","v":"N/A"},{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",IF(OR($L$4<60,$L$4>228),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Plate,7)),IF((VLOOKUP($L$4,all_pipe_arch,7,FALSE)=2),VLOOKUP($L$4,Aluminum_Pipe_Arch_Plate,7),\"N/A\")))","v":0.25}]
[null,null,"3/4","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4>90,$L$4<18,$L$4=27),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,9,FALSE)))","v":10},{"$f":"IFERROR((IF(OR($L$3=\"Box\",$L$3=\"Elliptical\"),\"N/A\",IF($L$3=\"Circular\",VLOOKUP($L$4,Spiral_Rib_Pipe,8,FALSE),IF(VLOOKUP($L$4,all_pipe_arch,8,FALSE)=\"1/4 \",VLOOKUP($L$4,Spiral_Rib_Pipe_Arch,8),\"N/A\")))),\"N/A\")","v":10},"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A",{"$f":"IF(OR($L$3=\"Box\",$L$3=\"Elliptical\",$L$3=\"Pipe Arch\",$L$4<18,$L$4>66),\"N/A\",VLOOKUP($L$4,Aluminum_Circular_Spiral_Rib,7))","v":10},"N/A","N/A"]
[]
[null,"Gauge","Thickness (inches)",{"$f":"N66","v":0},{"$f":"N60","v":20},{"$f":"N61","v":35},{"$f":"N60+N61","v":55},{"$f":"N63","v":50},{"$f":"N60+N63","v":70},{"$f":"N64","v":10},{"$f":"N64+N61","v":45},{"$f":"N63","v":50},{"$f":"N62","v":35},{"$f":"N65","v":25},{"$f":"N61+N65","v":60},{"$f":"N66","v":0},{"$f":"N63","v":50},{"$f":"N63","v":50},{"$f":"N63","v":50},0,75,null,null,null,{"$f":"75+N60","v":95}]
[null,16,6.4000000000000001E-2,{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$D$24)))","v":50.590819542085192},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":70.5908195420852},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$F$24),0)))","v":85.5908195420852},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":105.5908195420852},{"$f":"IF($D$8>=4,0,IF($C$8<=5,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$H$24))))","v":100.5908195420852},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":120.5908195420852},{"$f":"IF(OR($D$8>=4,$C$8<6),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$J$24))","v":60.590819542085192},{"$f":"IF(OR($D$8>=4,$C$8<5),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$K$24))","v":95.5908195420852},{"$f":"IF(OR($D$8>=4,$C$8<=5),0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$L$24)))","v":100.5908195420852},{"$f":"IF($D$8>=4,0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$M$24),0))","v":85.5908195420852},{"$f":"IF($D$8>=4,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$N$24))","v":75.5908195420852},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$O$24),0)))","v":110.5908195420852},{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$P$24)))","v":50.590819542085192},{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":100.5908195420852},{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":100.5908195420852},{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C25)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":100.5908195420852},null,{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":75},{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":75},{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":75},{"$f":"IF(AND($C$8>=5,$C$8<9),(IF($D$8<=2,$U$24,0)),0)","v":75},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF(AND($C$8>=5,$C$8<9),$Y$24,0)))))","v":95}]
[null,14,7.9000000000000001E-2,{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$D$24)))","v":52.86817248326166},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":72.86817248326166},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$F$24),0)))","v":87.86817248326166},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":107.86817248326166},{"$f":"IF($D$8>=4,0,IF($C$8<=5,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$H$24))))","v":102.86817248326166},{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":122.86817248326166},{"$f":"IF(OR($D$8>=4,$C$8<6),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$J$24))","v":62.86817248326166},{"$f":"IF(OR($D$8>=4,$C$8<5),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$K$24))","v":97.86817248326166},{"$f":"IF(OR($D$8>=4,$C$8<=5),0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$L$24)))","v":102.86817248326166},{"$f":"IF($D$8>=4,0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$M$24),0))","v":87.86817248326166},{"$f":"IF($D$8>=4,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$N$24))","v":77.86817248326166},{"$f":"IF($D$8>=4,0,(IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$O$24),0)))","v":112.86817248326166},{"$f":"IF($C$8<6,0,(IF($D$8>=4,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C26)-(6.466*LOG10($F$8))+4.254)/-0.068)+$P$24)))","v":52.86817248326166},102.86817248326166,102.86817248326166,102.86817248326166]
[null,12,0.109,57.422878365614586,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":77.422878365614594},92.422878365614594,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":112.42287836561459},107.42287836561459,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":127.42287836561459},67.422878365614594,102.42287836561459,107.42287836561459,92.422878365614594,82.422878365614594,117.42287836561459,57.422878365614586,{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C27)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":107.42287836561459},107.42287836561459,107.42287836561459]
[null,10,0.13800000000000001,61.825760718555784,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":81.825760718555784},96.825760718555784,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":116.82576071855578},111.82576071855578,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":131.82576071855578},71.825760718555784,106.82576071855578,111.82576071855578,96.825760718555784,86.825760718555784,121.82576071855578,61.825760718555784,{"$f":"IF($D$8>=6,0,IF($C$8<=4,0,IF($C$8=9,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C28)-(6.466*LOG10($F$8))+4.254)/-0.068)+$Q$24))))","v":111.82576071855578},111.82576071855578,111.82576071855578]
[null,8,0.16800000000000001,66.380466600908704,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C29)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":86.380466600908704},101.3804666009087,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C29)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":121.3804666009087},116.3804666009087,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C29)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":136.3804666009087},76.380466600908704,111.3804666009087,116.3804666009087,101.3804666009087,91.380466600908704,126.3804666009087,66.380466600908704,116.3804666009087,116.3804666009087,116.3804666009087]
[null,7,0.188,69.416937189144008,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C30)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":89.416937189144008},104.41693718914401,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C30)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":124.41693718914401},119.41693718914401,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C30)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":139.41693718914399},79.416937189144008,114.41693718914401,119.41693718914401,104.41693718914401,94.416937189144008,129.41693718914399,69.416937189144008,119.41693718914401,119.41693718914401,119.41693718914401]
[null,5,0.218,73.971643071496956,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C31)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":93.971643071496956},108.97164307149696,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C31)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":128.97164307149694},123.97164307149696,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C31)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":143.97164307149694},83.971643071496956,118.97164307149696,123.97164307149696,108.97164307149696,98.971643071496956,133.97164307149694,73.971643071496956,123.97164307149696,123.97164307149696,123.97164307149696]
[null,3,0.249,78.678172483261648,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C32)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":98.678172483261648},113.67817248326165,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C32)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":133.67817248326165},128.67817248326165,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C32)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":148.67817248326165},88.678172483261648,123.67817248326165,128.67817248326165,113.67817248326165,103.67817248326165,138.67817248326165,78.678172483261648,128.67817248326165,128.67817248326165,128.67817248326165]
[null,1,0.28000000000000003,83.384701895026353,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C33)-(6.466*LOG10($F$8))+4.254)/-0.068)+$E$24))))","v":103.38470189502635},118.38470189502635,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,IF(AND($C$8>=5,$C$8<9),((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C33)-(6.466*LOG10($F$8))+4.254)/-0.068)+$G$24),0))))","v":138.38470189502635},133.38470189502635,{"$f":"IF(IFERROR(MATCH($L$4,'Reference Data'!$B$150:$B$256,0)<=11,0),0,(IF(AND($L$3=\"Circular\",$L$4<60),0,(IF($D$8>=5,0,IF($C$8<=4,0,IF($C$8=9,0,IF($C$8<=3,0,((($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C33)-(6.466*LOG10($F$8))+4.254)/-0.068)+$I$24)))))))))","v":153.38470189502635},93.384701895026353,128.38470189502635,133.38470189502635,118.38470189502635,108.38470189502635,143.38470189502635,83.384701895026353,133.38470189502635,133.38470189502635,133.38470189502635]
[null,"Casing",0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$8<5,0,(($H$8-(6.755*LOG10($C$8))+(0.344*$D$8)-(10.324*$C34)-(6.466*LOG10($F$8))+4.254)/-0.068)+$T$24)","v":116.78587836561459}]
[]
[null,"Concrete Conduit Durability Results"]
[null,"Material",null,"**706.01 Non-reinforced Concrete Pipe","**706.02 Reinforced Concrete Circular Pipe","**706.03 Reinforced Concrete Pipe, Epoxy Coated","**706.04 Reinforced Concrete Elliptical Culvert, Storm Drain, and Sewer Pipe","**706.05 Precast Reinforced Concrete Box Sections","706.08 Clay Drain Tile",null,null,null,"Concrete Options:  66\" Type A Conduit, 706.02"]
[null,"Conduit Use and Shape",null,"Culvert or Storm Sewer -Round","Culvet or Storm Sewer -Round","Culvert or Storm Sewer -Round or Elliptical","Culvert or Storm Sewer -Elliptical","Culvert or Storm Sewer -Box","Culvert or Storm Sewer - Round"]
[null,null,null,{"$f":"IF(AND($L$3=\"Circular\",$L$4<=36),($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":0},{"$f":"IF(L3=\"Circular\",($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":172.36920031379012},{"$f":"IF(OR(L3=\"Circular\",L3=\"Elliptical\"),IF($D$39<$I$8,\"epoxy required\",IF($C$8<5,\"epoxy required\",\"epoxy not required\")),0)","v":"epoxy required"},{"$f":"IF(L3=\"Elliptical\",($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":0},{"$f":"IF(L3=\"Box\",($H$8-10.689*LOG10($C$8)+(0.389*$D$8)+(4.445*(1-$G$8))-4.169)/-0.026,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=48),$I$8,0)","v":0}]
[]
[null,"Plastic Conduit Durability Results"]
[null,"Material",null,"707.33 Corrugated Polyethylene Smooth Lined Pipe","707.34 Polyethylene Plastic Pipe Based on Outside Diameter (OD)","707.35 Polyethylene Profile Wall Pipe","707.42 Polyvinyl Chloride Corrugated Smooth Interior Pipe","707.43 Polyvinyl Chloride Profile Wall Pipe","707.45 Polyvinyl Chloride Solid Wall Pipe","707.46 Polyvinyl Chloride Drain Waste and Vent Pipe","707.47 ABS and Polyvinyl Chloride Composite Pipe","707.48 Polyvinyl Chloride Large-Diameter Solid Wall Pipe","707.65 Polypropylene corrugated Double Wall Pipe","707.69 Polypropylene Triple Wall Pipe","707.75 Glass-Fiber-Reinforced Polymer Mortar Pipe","748.02 Polyvinyl Chloride (PVC) Pipe, Joints, and Fittings","SS938 Steel Reinforced Thermoplastic Ribbed Pipe"]
[null,"Conduit Use and Shape",null,"Culvert, Storm Sewer, or Liner Pipe - Round","Culvert, Storm Sewer, or Liner Pipe - Round","Culvert, Storm Sewer, or Liner Pipe - Round","Storm Sewer or Liner Pipe - Round","Storm Sewer or Liner Pipe - Round","Storm Sewer - Round","Storm Sewer - Round","Storm Sewer - Round","Storm Sewer - Round","Culvert or Storm Sewer - Round","Culvert or Storm Sewer - Round","Culvert, Storm Sewer, or Liner Pipe - Round","Storm Sewer - Round","Culvert or Liner Pipe - Round"]
[null,null,null,{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=132),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=48),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=48),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=15),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=24),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=15),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4>=18,$L$4<=60),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=156),$I$8,0)","v":75},{"$f":"IF(AND($L$3=\"Circular\",$L$4<=60),$I$8,0)","v":0},{"$f":"IF(AND($L$3=\"Circular\",$L$4>=30,$L$4<=120),$I$8,0)","v":75}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plastic Options:  66\" Type A Conduit, 707.35, 707.75, SS938"]
[]
[]
[]
[]
[null,null,null,"Final Pay Item for Plans"]
[null,null,null,"66\" Type A Conduit, 707.02 (0.109) with CFP, 707.02 (0.064) Aluminized, 707.04 (0.064), 706.02, 707.35, 707.75, SS938"]
[]
[]
[]
[]
[null,null,"Notes:",null,null,null,null,null,null,null,null,"Constants"]
[null,null,null,"Many metal options are eliminated when abrasion level equals 4 or greater",null,null,null,null,null,null,null,null,"Protective Coating Constants-Initial Service Life (years)"]
[null,null,null,"Aluminum is only available between pH levels ranging from 5.0 to less than 9.0",null,null,null,null,null,null,null,"Concrete Invert Paving=",null,20]
[null,null,null,"Alumized protective coating is 0 years when pH levels are outside of allowable for Aluminum",null,null,null,null,null,null,null,"Aluminized=",null,35]
[null,null,null,"Polymeric coated is only available for pH ranges greater than 5.0 and less than 9.0",null,null,null,null,null,null,null,"Aluminized Spiral Rib=",null,35]
[null,null,null,"Options were emiminated when the NCSPA online Service Life Calculator did not recommend option; typically due to abrasive conditions or pH limitations",null,null,null,null,null,null,null,"Polymeric=",null,50]
[null,null,null,"Epoxy is required on all concrete surfaces when pH<5",null,null,null,null,null,null,null,"Bituminous coated w/ bitum. paved invert=",null,10]
[null,null,null,"** Smooth lined conduit ",null,null,null,null,null,null,null,"Bituminous lined =",null,25]
[null,null,null,"***Minimum gauges set per industry comments; see Reference Data",null,null,null,null,null,null,null,"Galvanized=",null,0]
[null,null,null,"Provide concrete field paving on corrugated metal conduits 60” or larger where the invert is always submerged due to tail water conditions from a body of water"]
[null,null,null,"Designer is responsible to ensure the required gage thickness is available for the given pipe size"]

{"sheet":"Reference Data","index":3,"n_rows":256,"n_cols":10,"rows_kept":256,"cut":false,"hidden":false,"merged":[[100,7,100,9],[99,6,99,9],[148,5,148,7],[31,0,31,3],[100,2,100,4],[99,1,99,4],[148,2,148,4],[147,1,147,8]]}
[]
["Gauge","Thickness (inches)"]
[16,6.4000000000000001E-2]
[14,7.9000000000000001E-2]
[12,0.109]
[10,0.13800000000000001]
[8,0.16800000000000001]
[7,0.188]
[5,0.218]
[3,0.249]
[1,0.28000000000000003]
["Casing",0.5]
[]
[]
[]
[]
[]
["Abrasion Level",null,"Conduit Shapes"]
[1,null,"Circular"]
[2,null,"Pipe Arch"]
[3,null,"Elliptical"]
[4,null,"Box"]
[5]
[6]
[]
[]
[]
[]
[]
[]
[]
["***Minimum gauges set per Industry Comments:"]
[null,"Abrasion Level 4","Abrasion Level 5","Abrasion Level 6"]
["Aluminized with concrete invert paving"]
["Service Life Required=75",null,12,10]
[]
["Aluminized bituminous coated w/ bitum. paved invert"]
["Service Life Required=75",14,12,10]
[]
["Polymeric coated with concrete invert paving"]
["Service Life Required=75",null,14,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Galvanized, T2, and Poly Coated Circular Shape",null,null,null,null,"Aluminum Circular Shape"]
[null,"Spans Available (inches)","Max Gauge or Thickness (inches)",null,null,null,"Spans Available (inches)","Max Gauge or Thickness (inches)"]
[null,12,"1/4 or 1/2",null,null,null,12,"1/4 or 1/2"]
[null,15,"1/4 or 1/2",null,null,null,15,"1/4 or 1/2"]
[null,18,"1/4 or 1/2",null,null,null,18,"1/4 or 1/2"]
[null,21,"1/4 or 1/2",null,null,null,21,"1/4 or 1/2"]
[null,24,"1/4 or 1/2",null,null,null,24,"1/4 or 1/2"]
[null,27,"1/4 or 1/2",null,null,null,27,"1/4 or 1/2"]
[null,30,"1/4 or 1/2",null,null,null,30,"1/4 or 1/2"]
[null,36,"1/4 or 1/2",1,null,null,36,"1/4 or 1/2",1]
[null,42,"1/4 or 1/2",1,null,null,42,"1/4 or 1/2",1]
[null,48,"1/4 or 1/2",1,null,null,48,"1/4 or 1/2",1]
[null,54,"1/4 or 1/2",1,null,null,54,"1/4 or 1/2",1]
[null,60,"1/4 or 1/2",1,2,null,60,"1/4 or 1/2",1,2]
[null,66,"1/4 or 1/2",1,2,null,66,"1/4 or 1/2",1,2]
[null,72,"1/4 or 1/2",1,2,null,72,"1/4 or 1/2",1,2]
[null,78,"1/4 or 1/2",1,2,null,78,null,null,2]
[null,84,"1/4 or 1/2",1,2,null,84,null,null,2]
[null,90,null,1,2,null,90,null,null,2]
[null,96,null,1,2,null,96,null,null,2]
[null,102,null,1,2,null,102,null,null,2]
[null,108,null,1,2,null,108,null,null,2]
[null,114,null,1,2,null,114,null,null,2]
[null,120,null,1,2,null,120,null,null,2]
[null,126,null,null,2,null,126,null,null,2]
[null,132,null,null,2,null,132,null,null,2]
[null,138,null,null,2,null,138,null,null,2]
[null,144,null,null,2,null,144,null,null,2]
[null,150,null,null,2,null,150,null,null,2]
[null,156,null,null,2,null,156,null,null,2]
[null,162,null,null,2,null,162,null,null,2]
[null,168,null,null,2,null,168,null,null,2]
[null,174,null,null,2,null,174,null,null,2]
[null,180,null,null,2,null,180,null,null,2]
[null,186,null,null,2,null,186,null,null,2]
[null,192,null,null,2,null,192,null,null,2]
[null,198,null,null,2,null,198,null,null,2]
[null,204,null,null,2,null,204,null,null,2]
[null,210,null,null,2,null,210,null,null,2]
[null,216,null,null,2,null,216,null,null,2]
[null,222,null,null,2,null,222,null,null,2]
[null,228,null,null,2,null,228,null,null,2]
[null,234,null,null,2]
[null,240,null,null,2]
[null,246,null,null,2]
[null,252,null,null,2]
[]
[]
[null,"Pipe Arch Shape"]
[null,"Spans x Rise Available (inches)","Galvanized Corrugation Depth (inches)",null,null,"Aluminum Corrugation Depth (inches)",null,null,"Spiral Rib"]
[null,"17 x 13","1/4 or 1/2",null,null," 1/2"]
[null,"20 x 16",null,null,null,null,null,null,"1/4 "]
[null,"21 x 15","1/4 or 1/2",null,null," 1/2"]
[null,"23 x 19",null,null,null,null,null,null,"1/4 "]
[null,"24 x 18","1/4 or 1/2",null,null," 1/2"]
[null,"27 x 21",null,null,null,null,null,null,"1/4 "]
[null,"28 x 20","1/4 or 1/2",null,null," 1/2"]
[null,"33 x 26",null,null,null,null,null,null,"1/4 "]
[null,"35 x 24","1/4 or 1/2",null,null," 1/2"]
[null,"40 x 31",null,1,null,null,null,null,"1/4 "]
[null,"42 x 29","1/4 or 1/2",null,null," 1/2"]
[null,"46 x 36",null,1,null,null,null,null,"1/4 "]
[null,"49 x 33","1/4 or 1/2",null,null," 1/2"]
[null,"53 x 41",null,1,null,null,1,null,"1/4 "]
[null,"57 x 38","1/4 or 1/2",null,null," 1/2"]
[null,"60 x 46",null,1,null,null,1,null,"1/4 "]
[null,"64 x 43","1/4 or 1/2",null,null," 1/2"]
[null,"66 x 51",null,1,null,null,1,null,"1/4 "]
[null,"71 x 47","1/4 or 1/2",null,null," 1/2"]
[null,"73 x 55",null,1,2,null,1,null,"1/4 "]
[null,"76 x 57",null,null,2]
[null,"77 x 52","1/4 or 1/2"]
[null,"79 x 68",null,null,null,null,null,2]
[null,"81 x 59",null,1,2,null,1,null,"1/4 "]
[null,"84 x 61",null,null,2]
[null,"83 x 57","1/4 or 1/2"]
[null,"83 x 69",null,null,null,null,null,2]
[null,"87 x 63",null,1,2,null,1]
[null,"87 x 71",null,null,null,null,null,2]
[null,"92 x 65",null,null,2]
[null,"93 x 72",null,null,null,null,null,2]
[null,"95 x 67",null,1,2,null,1]
[null,"97x 73",null,null,null,null,null,2]
[null,"98 x 69",null,null,2]
[null,"101 x 75",null,null,null,null,null,2]
[null,"103 x 71",null,1,2,null,1]
[null,"106 x 72",null,null,2]
[null,"106 x 76",null,null,null,null,null,2]
[null,"111 x 77",null,null,null,null,null,2]
[null,"112 x 75",null,1,2,null,1]
[null,"114 x 77",null,null,2]
[null,"115 x 78",null,null,null,null,null,2]
[null,"117 x 79",null,1,null,null,1]
[null,"119 x 80",null,null,null,null,null,2]
[null,"123 x 81",null,null,2,null,null,2]
[null,"128 x 83",null,1,2]
[null,"129 x 82",null,null,null,null,null,2]
[null,"131 x 85",null,null,2]
[null,"133 x 84",null,null,null,null,null,2]
[null,"137 x 85",null,null,null,null,null,2]
[null,"137 x 87",null,1,2]
[null,"139 x 89",null,null,2]
[null,"141 x 86",null,null,null,null,null,2]
[null,"142 x 91",null,1,2]
[null,"147 x 87",null,null,null,null,null,2]
[null,"148 x 93",null,null,2]
[null,"150 x 95",null,null,2]
[null,"151 x 89",null,null,null,null,null,2]
[null,"152 x 97",null,null,2]
[null,"154 x 100",null,null,2]
[null,"155 x 90",null,null,null,null,null,2]
[null,"157 x 98",null,null,null,null,null,2]
[null,"159 x 112",null,null,2]
[null,"161 x 101",null,null,2]
[null,"162 x 114",null,null,2]
[null,"167 x 101",null,null,null,null,null,2]
[null,"167 x 103",null,null,2]
[null,"167 x 113",null,null,null,null,null,2]
[null,"168 x 104",null,null,null,null,null,2]
[null,"168 x 105",null,null,2]
[null,"168 x 116",null,null,2]
[null,"170 x 118",null,null,2]
[null,"171 x 107",null,null,2]
[null,"171 x 115",null,null,null,null,null,2]
[null,"173 x 120",null,null,2]
[null,"176 x 116",null,null,null,null,null,2]
[null,"178 x 109",null,null,2]
[null,"179 x 118",null,null,null,null,null,2]
[null,"179 x 122",null,null,2]
[null,"184 x 111",null,null,2]
[null,"184 x 120",null,null,null,null,null,2]
[null,"184 x 124",null,null,2]
[null,"186 x 113",null,null,2]
[null,"187 x 122",null,null,null,null,null,2]
[null,"187 x 126",null,null,2]
[null,"188 x 115",null,null,2]
[null,"190 x 118",null,null,2]
[null,"190 x 128",null,null,2]
[null,"193 x 124",null,null,null,null,null,2]
[null,"195 x 130",null,null,2]
[null,"196 x 126",null,null,null,null,null,2]
[null,"197 x 119",null,null,2]
[null,"198 x 132",null,null,2]
[null,"199 x 121",null,null,2]
[null,"204 x 134",null,null,2]
[null,"206 x 136",null,null,2]
[null,"209 x 138",null,null,2]
[null,"215 x 140",null,null,2]
[null,"217 x 142",null,null,2]
[null,"223 x 144",null,null,2]
[null,"225 x 146",null,null,2]
[null,"231 x 148",null,null,2]
[null,"234 x 150",null,null,2]
[null,"236 x 152",null,null,2]
[null,"239 x 154",null,null,2]
[null,"245 x 156",null,null,2]
[null,"247 x 158",null,null,2]

{"sheet":"ODOT Pipe Charts","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Revisions","index":5,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"For January 2020"]
[null,1,"For Steel Pipe, added Steel Pipe Charts with gauge thickness information, added data to the Reference Data Tab for Steel Pipe, added min and max gauge to the Durability Design Tab"]
[null,2,"Restricted availability of concrete field paving to pipe sizes 60\" or greater."]
[null,3,"Example Calculation tab included. Example has notes included when the mouse is hovered over the material options."]
[null,4,"Conduit material photos were added to a new tab"]
[null,5,"Improved Durability Design Calculations to remove options that are not commercial available"]
[]
[null,null,"For July 2019"]
[null,1,"Protective Coatings Add-On Service Life-"]
[null,null,"Changed name of 'Bituminous Lined and Invert Paved' to 'Bituminous Coated w/ bitum. Paved invert'; changed add-on service life to 10 yrs from 25 yrs"]
[null,null,"Changed add-on service life of 'Bituminous Lined' to 25 yrs from 10 yrs"]
[null,2,"Added a note stating that the designer is responsible to ensure the required gage thickness is available for the given pipe size"]
[null,3,"Corrected 707.13 & 707.14 conduit use to storm sewer instead of culvert"]
[null,4,"Changed minimum storm sewer abrasion level to 1 from 2 and assumed Ph to 7 instead of using L&D figure 1002-2. Noted in instructions. "]
[null,5,"Added ODOT Pipe Charts as a reference "]
[null,6,"Added 707.11 Polymer Precoated Spiral Rib Steel for use as a storm sewer or liner pipe"]
[null,7,"Revised 707.12 Aluminum Coated Spiral Rib Steel for use as a liner pipe only"]
[]
[null,null,"For July 2021"]
[null,1,"Removed mention of 75 yr. service life for polymeric coating pH range under Durability Design Notes on Instructions tab"]
[null,2,"Removed old references to storm sewer options and corrected allowable Abrasion Level to less than 4 in service life calculations for 707.04, 707.05 or 707.07 galvanized and aluminized, and 707.11"]
[null,3,"Updated Example to match the changes to the Durability Design tab"]
[null,4,"Added the metal pipe gage thickness to metal options in the Example"]

{"sheet":"Steel Pipe Charts","index":6,"n_rows":46,"n_cols":116,"rows_kept":46,"cut":false,"hidden":false,"merged":[[26,59,26,62],[27,59,27,62],[28,59,28,62],[29,59,29,62],[30,59,30,62],[12,57,30,57],[12,56,30,56],[41,59,41,62],[42,59,42,62],[32,56,42,56],[32,57,42,57],[32,59,32,62],[33,59,33,62],[34,59,34,62],[35,59,35,62],[36,59,36,62],[37,59,37,62],[39,59,39,62],[40,59,40,62],[38,59,38,62],[25,59,25,62],[8,10,11,10],[8,11,11,11],[9,4,9,7],[10,5,10,7],[11,4,11,7],[12,15,23,16],[12,18,12,20],[13,18,13,20],[14,18,14,20],[15,18,15,20],[16,18,16,20],[6,16,11,16],[6,17,6,20],[7,17,7,20],[8,18,8,20],[23,18,23,20],[20,18,20,20],[21,18,21,20],[22,18,22,20],[6,1,11,1],[6,2,11,2],[6,3,6,7],[7,3,7,7],[8,4,8,7],[8,9,11,9],[7,8,11,8],[0,7,0,9],[1,0,2,6],[1,7,2,9],[3,0,4,6],[3,7,3,9],[4,7,4,9],[44,1,44,7],[45,1,45,7],[0,20,0,22],[1,14,4,19],[1,20,2,22],[3,20,3,22],[4,20,4,22],[6,15,11,15],[36,4,36,7],[12,1,27,2],[12,4,12,7],[13,4,13,7],[14,4,14,7],[15,4,15,7],[16,4,16,7],[17,4,17,7],[18,4,18,7],[19,4,19,7],[20,4,20,7],[35,4,35,7],[21,4,21,7],[22,4,22,7],[23,4,23,7],[24,4,24,7],[28,1,42,2],[28,4,28,7],[29,4,29,7],[30,4,30,7],[31,4,31,7],[32,4,32,7],[33,4,33,7],[34,4,34,7],[37,4,37,7],[38,4,38,7],[39,4,39,7],[40,4,40,7],[41,4,41,7],[27,4,27,7],[42,4,42,7],[25,4,25,7],[26,4,26,7],[40,15,40,20],[41,15,41,20],[0,32,0,34],[1,27,4,31],[1,32,2,34],[3,32,3,34],[4,32,4,34],[6,28,6,32],[7,28,7,32],[8,24,11,24],[9,18,9,20],[10,19,10,20],[11,18,11,20],[8,22,11,22],[8,23,11,23],[7,21,11,21],[31,18,31,20],[17,18,17,20],[18,18,18,20],[19,18,19,20],[30,18,30,20],[24,15,38,16],[24,18,24,20],[25,18,25,20],[26,18,26,20],[27,18,27,20],[28,18,28,20],[29,18,29,20],[32,18,32,20],[33,18,33,20],[34,18,34,20],[35,18,35,20],[36,18,36,20],[37,18,37,20],[38,18,38,20],[41,30,41,32],[42,30,42,32],[43,30,43,32],[44,30,44,32],[0,41,0,43],[1,37,4,40],[1,41,2,43],[3,41,3,43],[4,41,4,43],[6,38,6,41],[7,38,7,41],[8,39,8,41],[28,30,28,32],[29,30,29,32],[30,30,30,32],[19,30,19,32],[20,30,20,32],[21,30,21,32],[22,30,22,32],[23,30,23,32],[24,30,24,32],[25,30,25,32],[27,30,27,32],[13,30,13,32],[32,30,32,32],[33,30,33,32],[34,30,34,32],[35,30,35,32],[36,30,36,32],[37,30,37,32],[38,30,38,32],[39,30,39,32],[40,30,40,32],[13,39,13,41],[7,42,11,42],[14,39,14,41],[15,39,15,41],[16,39,16,41],[17,39,17,41],[18,39,18,41],[19,39,19,41],[31,30,31,32],[14,30,14,32],[15,30,15,32],[16,30,16,32],[7,33,11,33],[26,30,26,32],[17,30,17,32],[18,30,18,32],[8,30,8,32],[8,34,11,34],[9,30,9,32],[10,31,10,32],[11,30,11,32],[12,30,12,32],[45,39,45,41],[0,50,0,52],[1,46,4,49],[1,50,2,52],[3,50,3,52],[4,50,4,52],[6,47,6,50],[7,47,7,50],[8,48,8,50],[28,39,28,41],[29,39,29,41],[30,39,30,41],[31,39,31,41],[20,39,20,41],[21,39,21,41],[22,39,22,41],[23,39,23,41],[24,39,24,41],[25,39,25,41],[8,43,11,43],[9,39,9,41],[10,40,10,41],[11,39,11,41],[12,39,12,41],[36,39,36,41],[37,39,37,41],[38,39,38,41],[39,39,39,41],[40,39,40,41],[41,39,41,41],[42,39,42,41],[43,39,43,41],[44,39,44,41],[32,48,32,50],[33,48,33,50],[34,48,34,50],[35,48,35,50],[27,48,27,50],[28,48,28,50],[29,48,29,50],[30,48,30,50],[26,39,26,41],[27,39,27,41],[32,39,32,41],[33,39,33,41],[34,39,34,41],[35,39,35,41],[31,48,31,50],[0,62,0,64],[1,55,4,61],[1,62,2,64],[3,62,3,64],[4,62,4,64],[26,48,26,50],[14,48,14,50],[15,48,15,50],[16,48,16,50],[6,56,11,56],[13,48,13,50],[7,51,11,51],[17,48,17,50],[18,48,18,50],[19,48,19,50],[8,52,11,52],[9,48,9,50],[10,49,10,50],[11,48,11,50],[12,48,12,50],[10,59,10,60],[10,61,10,62],[11,59,11,62],[20,48,20,50],[21,48,21,50],[22,48,22,50],[23,48,23,50],[24,48,24,50],[25,48,25,50],[1,83,2,84],[3,78,4,81],[3,83,3,84],[4,83,4,84],[6,83,9,83],[1,69,2,72],[12,59,12,62],[13,59,13,62],[14,59,14,62],[15,59,15,62],[16,59,16,62],[17,59,17,62],[18,59,18,62],[19,59,19,62],[20,59,20,62],[21,59,21,62],[22,59,22,62],[23,59,23,62],[24,59,24,62],[6,57,11,57],[6,58,6,62],[1,74,2,75],[3,69,4,72],[3,74,3,75],[4,74,4,75],[6,74,9,74],[8,69,23,70],[6,73,9,73],[8,78,20,79],[21,78,31,79],[24,69,38,70],[1,78,2,81],[0,87,3,93],[0,94,1,96],[2,94,2,96],[3,94,3,96],[5,88,8,88],[5,89,8,89],[5,91,5,94],[5,96,8,96],[6,91,6,94],[7,91,7,92],[6,111,6,113],[7,112,7,113],[8,111,8,113],[8,102,8,104],[5,95,8,95],[0,109,3,112],[0,113,1,115],[2,113,2,115],[3,113,3,115],[5,111,5,113],[5,115,8,115],[5,114,8,114],[9,111,9,113],[10,111,10,113],[11,111,11,113],[15,91,15,94],[16,91,16,94],[17,91,17,94],[7,105,10,105],[7,106,10,106],[7,93,7,94],[8,91,8,94],[9,91,9,94],[10,91,10,94],[11,91,11,94],[12,91,12,94],[13,91,13,94],[14,91,14,94],[36,111,36,113],[37,111,37,113],[30,111,30,113],[38,111,38,113],[1,99,4,103],[1,104,2,106],[3,104,3,106],[4,104,4,106],[6,100,6,104],[7,102,7,104],[23,111,23,113],[12,111,12,113],[13,111,13,113],[14,111,14,113],[15,111,15,113],[16,111,16,113],[17,111,17,113],[20,111,20,113],[21,111,21,113],[22,111,22,113],[18,102,18,104],[19,102,19,104],[9,103,9,104],[10,102,10,104],[31,111,31,113],[32,111,32,113],[33,111,33,113],[34,111,34,113],[35,111,35,113],[24,111,24,113],[25,111,25,113],[26,111,26,113],[27,111,27,113],[28,111,28,113],[29,111,29,113],[18,111,18,113],[19,111,19,113],[15,102,15,104],[16,102,16,104],[17,102,17,104],[20,102,20,104],[21,102,21,104],[22,102,22,104],[23,102,23,104],[38,102,38,104],[39,102,39,104],[7,9,7,11],[7,22,7,24],[7,64,7,66],[32,102,32,104],[33,102,33,104],[34,102,34,104],[35,102,35,104],[36,102,36,104],[11,102,11,104],[12,102,12,104],[13,102,13,104],[6,82,9,82],[9,88,18,88],[9,89,18,89],[18,91,18,94],[7,58,7,62],[8,59,8,62],[8,64,11,64],[7,63,11,63],[8,65,11,65],[8,66,11,66],[9,59,9,62],[24,102,24,104],[25,102,25,104],[14,102,14,104],[37,102,37,104],[26,102,26,104],[27,102,27,104],[28,102,28,104],[29,102,29,104],[30,102,30,104],[31,102,31,104]]}
[null,null,null,null,null,null,null,"Revised July 2014",null,null,null,null,null,null,null,null,null,null,null,null,"Revised July 2014",null,null,null,null,null,null,null,null,null,null,null,"Revised July 2014",null,null,null,null,null,null,null,null,"Revised January 2013",null,null,null,null,null,null,null,null,"Revised January 2013",null,null,null,null,null,null,null,null,null,null,null,"Revised January 2013",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE  5                          FOR CORRUGATED ALUMINUM                                  SPIRAL RIB PIPE",null,null,null,null,null,null,"    1008-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE 4 707.23 STRUCTURAL PLATE CORRUGATED ALUMINUM PIPE ARCHES",null,null,null,"1008-18"]
["MINIMUM HEIGHT OF COVER TABLE 1",null,null,null,null,null,null,"    1008-1",null,null,null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE 2 CORRUGATED STEEL PIPE ARCHES",null,null,null,null,null,"    1008-2",null,null,null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE 3 707.03 STRUCTURAL PLATE CORRUGATED STEEL PIPE",null,null,null,null,"    1008-3",null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE 4 707.03 STRUCTURAL PLATE CORRUGATED STEEL PIPE ARCHES",null,null,null,"    1008-4",null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE 5 707.03 STRUCTURAL PLATE CORRUGATED STEEL PIPE ARCHES",null,null,null,"    1008-5",null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE  6                           FOR CORRUGATED STEEL                                   SPIRAL RIB PIPE",null,null,null,null,null,null,"    1008-6",null,null,null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE 1",null,null,null,null,"    1008-15",null,null,null,"MINIMUM HEIGHT OF COVER TABLE 2",null,null,null,null,"    1008-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMUM HEIGHT OF COVER TABLE 3 707.23 STRUCTURAL PLATE CORRUGATED ALUMINUM PIPE",null,null,null,null,"    1008-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference Section"]
["CORRUGATED STEEL PIPE",null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,"CORRUGATED ALUMINUM PIPE",null,null,null,null,"Reference Section",null,null,null,"CORRUGATED ALUMINUM PIPE ARCHES",null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,null,"Reference Section",null,null,null,null,null,null,null,null,"1008.1.2"]
[null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,"1008.1.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1008.1.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipe ",null,null,null,null,"Min Gauge Thickness","Maximum Gauge",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipe ",null,null,null,"Min Gauge Thickness","Maximum Thickness (inches)"]
[null,"Pipe","Designation","HEIGHT OF COVER TABLE 1",null,null,null,null,null,null,null,null,null,null,null,"Pipe","Designation","HEIGHT OF COVER TABLE 2",null,null,null,null,null,null,null,null,null,null,"HEIGHT OF COVER TABLE 3",null,null,null,null,null,null,null,null,null,"HEIGHT OF COVER TABLE 4",null,null,null,null,null,null,null,null,"HEIGHT OF COVER TABLE 5",null,null,null,null,null,null,null,null,"Pipe","Designation","HEIGHT OF COVER TABLE 6",null,null,null,null,null,null,null,null,null,null,null,null,"Pipe ",null,"Min Gauge Thickness","Maximum Gage ",null,null,null,null,null,"Pipe ",null,"Min Gauge Thickness","Maximum Gauge ",null,null,null,null,null,null,"Diameter","Minimum Cover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dimensions","Minimum Cover"]
[null,null,null,"Corrugated Steel Pipe",null,null,null,null,"Min Gauge Thickness","Max Gauge thickness",null,null,null,null,null,null,null,"Corrugated Steel Pipe Arches",null,null,null,"Min Gauge Thickness","Max Gauge thickness",null,null,null,null,null,"707.03 Structural Plate Corrugated Steel Pipe",null,null,null,null,"Min Gauge Thickness",null,null,null,null,"707.03 Structural Plate Corrugated Steel Pipe (18-inch Corner Radius)",null,null,null,"Min Gauge Thickness",null,null,null,null,"707.03 Structural Plate Corrugated Steel Pipe (31-inch Corner Radius)",null,null,null,"Min Gauge Thickness",null,null,null,null,null,null,"Corrugated Steel Spiral Rib Pipe",null,null,null,null,"Min Gauge Thickness","Maximum Gage Thickness ",null,null,null,null,null,null,"Diameter","Minimum Cover",null,null,null,null,null,null,null,"Diameter","Minimum Cover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipe ","Pipe ",null,null,null,"Min Thickness","Maximum Thickness (inches)",null,null,"Span X Rise","Span X Rise"]
[null,null,null,"Pipe ",null,null,null,null,null,"Maximum Gauge GALV","Maximum Gauge T2","Maximum Gauge POLY",null,null,null,null,null,"Pipe Dimentions",null,null,null,null,"Maximum Gauge GALV","Maximum Gauge T2","Maximum Gauge POLY",null,null,null,"Pipe ","Pipe ",null,null,null,null,"Maximum Gauge",null,null,null,"Pipe ",null,null,null,null,"Maximum Gauge",null,null,null,"Pipe ",null,null,null,null,"Maximum Gauge",null,null,null,null,null,"Pipe ",null,null,null,null,null,"Maximum Gauge GALV","Maximum Gauge T2","Maximum Gauge POLY",null,null,"707.21               (2 2/3\" x 1/2\" Corrugations)",null,null,null,null,null,null,null,null,"707.21               (2 2/3\" x 1/2\" Corrugations)",null,null,null,null,null,null,null,null,null,null,null,"(inches)","(inches)",null,null,null,null,null,null,null,null,"Diameter","Diameter","Minimum Cover",null,null,null,null,null,null,"inch-inch","(feet-inches)","(inches)"]
[null,null,null,"Diameter","Minimum Cover",null,null,null,null,null,null,null,null,null,null,null,null,"Span X Rise","Minimum Cover",null,null,null,null,null,null,null,null,null,"Diameter","Diameter","Minimum Cover",null,null,null,null,null,null,null,"Dimentions","Minimum Cover",null,null,null,null,null,null,null,"Dimentions","Minimum Cover",null,null,null,null,null,null,null,null,null,"Diameter","Minimum Cover",null,null,null,null,null,null,null,null,null,null,null,"(inches)","(inches)",null,null,null,null,null,null,null,"(inches)","(inches)",null,null,null,null,null,null,707.24,"(3/4\" x 7 1/2\" Corrugations)",18,12,null,null,null,16,14,null,null,null,null,null,null,null,null,null,null,null,null,"79 x 68","6-'7\" x 5-8\"",21,null,null,0.1,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Span X Rise","Span X Rise",null,null,null,null,null,null,null,"Span X Rise","Span X Rise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,12,16,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,12,null,null,null,16,14,null,null,null,"(inches)","(feet-inches)","(inches)",null,null,null,null,null,null,"83 x 69","6'-11\" x 5'-9\"",21,null,null,0.1,0.25]
[null,null,null,"(inches)","(inches)",null,null,null,null,null,null,null,null,null,null,null,null,"(inches)","(inches)",null,null,null,null,null,null,null,null,null,"(inches)","(feet-inches)","(inches)",null,null,null,null,null,null,"inch-inch","(feet-inches)","(inches)",null,null,null,null,null,null,"inch-inch","(feet-inches)","(inches)",null,null,null,null,null,null,null,null,null,"(inches)","(inches)",null,null,null,null,null,null,null,null,null,null,null,15,12,16,12,null,null,null,null,null,"17 X 13",12,16,12,null,null,null,null,null,null,24,12,null,null,null,16,12,null,null,null,60,"5'0\"",15,null,null,0.1,0.25,null,null,"87 x 71","7'-3\" x 5'-11\"",21,null,null,0.1,0.25]
[null,"707.01, 707.04, 707.05, 707.11 and 707.13                                   (2 2/3\" x 1/2\" Corrugations)",null,12,12,null,null,null,16,14,14,14,null,null,null,"707.01, 707.04, 707.05, 707.11 and 707.13 (2 2/3\" x 1/2\" Corrugations)",null,"17 x 13",12,null,null,16,14,14,14,null,null,null,60,"5'0\"",12,null,null,12,1,null,null,"73 x 55","6'1\" x 4'7\"",18,null,null,12,1,null,null,"159 x 112","13'3\" x 9'4\"",24,null,null,12,1,null,null,null,707.12,"(3/4\" x 7 1/2\" Corrugations)",18,12,null,null,null,16,14,14,14,null,null,null,null,18,12,16,12,null,null,null,null,null,"21 X 15",12,16,12,null,null,null,null,null,null,30,15,null,null,null,16,12,null,null,null,66,"5'6\"",18,null,null,0.1,0.25,null,null,"93 x 72","7'-9\" X 6'-0\"",24,null,null,0.1,0.25]
[null,null,null,15,12,null,null,null,16,14,14,14,null,null,null,null,null,"21 x 15",12,null,null,16,14,14,14,null,null,null,66,"5'6\"",12,null,null,12,1,null,null,"76 x 57","6'4\" x 4'9\"",18,null,null,12,1,null,null,"162 x 114","13'6\" x 9'6\"",24,null,null,12,1,null,null,null,null,null,21,12,null,null,null,16,12,12,12,null,null,null,null,21,12,16,12,null,null,null,null,null,"24 X 18",12,16,12,null,null,null,null,null,null,36,15,null,null,null,14,12,null,null,null,72,"6'0\"",24,null,null,0.1,0.25,null,null,"97x 73","8'-1\"X 6'-1\"",24,null,null,0.1,0.25]
[null,null,null,18,12,null,null,null,16,14,14,14,null,null,null,null,null,"24 x 18",12,null,null,16,12,12,12,null,null,null,72,"6'0\"",12,null,null,12,1,null,null,"81 x 59","6'9 x 4'11\"",18,null,null,12,1,null,null,"168 x 116","14'0\" x 9'8\"",24,null,null,12,1,null,null,null,null,null,24,12,null,null,null,16,12,12,12,null,null,null,null,24,12,16,10,null,null,null,null,null,"28 X 20",12,14,10,null,null,null,null,null,null,42,15,null,null,null,12,12,null,null,null,78,"6'6\"",24,null,null,0.1,0.25,null,null,"101 x 75","8'-5\" x 6'-3\"",24,null,null,0.1,0.25]
[null,null,null,21,12,null,null,null,16,12,12,12,null,null,null,null,null,"28 x 20",12,null,null,16,12,12,12,null,null,null,78,"6'6\"",12,null,null,12,1,null,null,"84 x 61","7'0\" x 5'1\"",18,null,null,12,1,null,null,"170 x 118","14'2\" x 9'10\"",24,null,null,12,1,null,null,null,null,null,30,12,null,null,null,16,12,12,12,null,null,null,null,27,12,14,10,null,null,null,null,null,"35 X 24",12,14,10,null,null,null,null,null,null,48,18,null,null,null,12,10,null,null,null,84,"7'0\"",24,null,null,0.1,0.25,null,null,"106 x 76","8'-10\" x 6'-4\"",27,null,null,0.1,0.25]
[null,null,null,24,12,null,null,null,16,12,12,12,null,null,null,null,null,"35 x 24",12,null,null,16,12,12,12,null,null,null,84,"7'0\"",12,null,null,12,1,null,null,"87 x 63","7'3\" x 5'3\"",18,null,null,12,1,null,null,"173 x 120","14'5\" x 10'0\"",24,null,null,12,1,null,null,null,null,null,36,12,null,null,null,16,12,12,12,null,null,null,null,30,12,14,10,null,null,null,null,null,"42 X 29",15,12,8,null,null,null,null,null,null,54,18,null,null,null,12,10,null,null,null,90,"7'6\"",24,null,null,0.1,0.25,null,null,"111 x 77","9'-3\" x 6'-5\"",27,null,null,0.1,0.25]
[null,null,null,27,12,null,null,null,16,12,12,12,null,null,null,null,null,"42 x 29",12,null,null,16,10,10,10,null,null,null,90,"7'6\"",12,null,null,12,1,null,null,"92 x 65","7'8\" x 5'5\"",18,null,null,12,1,null,null,"179 x 122","14'11\" x 10'2\"",24,null,null,12,1,null,null,null,null,null,42,15,null,null,null,16,12,12,12,null,null,null,null,36,12,14,8,null,null,null,null,null,"49 X 33",15,12,8,null,null,null,null,null,null,60,18,null,null,null,10,10,null,null,null,96,"8'0\"",24,null,null,0.1,0.25,null,null,"115 x 78","9'-7\" x 6'-6\"",27,null,null,0.1,0.25]
[null,null,null,30,12,null,null,null,16,12,12,12,null,null,null,null,null,"49 x 33",12,null,null,14,8,10,10,null,null,null,96,"8'0\"",12,null,null,12,1,null,null,"95 x 67","7'11\" x 5'7\"",18,null,null,12,1,null,null,"184 x 124","15'4\" x 10'4\"",24,null,null,12,1,null,null,null,null,null,48,15,null,null,null,16,12,12,12,null,null,null,null,42,12,12,8,null,null,null,null,null,"57 X 38",15,10,8,null,null,null,null,null,null,66,21,null,null,null,10,10,null,null,null,102,"8'6\"",30,null,null,0.1,0.25,null,null,"119 x 80","9\"-11\" X 6'-8\"",27,null,null,0.1,0.25]
[null,null,null,36,12,null,null,null,16,10,10,10,null,null,null,null,null,"57 x 38",12,null,null,12,8,10,10,null,null,null,102,"8'6\"",18,null,null,12,1,null,null,"98 x 69","8'2\" x 5'9\"",18,null,null,12,1,null,null,"187 x 126","15'7\" x 10'6\"",24,null,null,12,1,null,null,null,null,null,54,15,null,null,null,12,12,12,12,null,null,null,null,48,12,12,8,null,null,null,null,null,"64 X 43",18,10,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,"9'0\"",30,null,null,0.1,0.25,null,null,"123 x 81","10'-3\" x 6'-9\"",27,null,null,0.1,0.25]
[null,null,null,42,12,null,null,null,16,8,10,10,null,null,null,null,null,"64 x 43",12,null,null,12,8,10,10,null,null,null,108,"9'0\"",18,null,null,12,1,null,null,"103 x 71","8'7\" x 5'11\"",18,null,null,12,1,null,null,"190 x 128","15'10\" x 10'8\"",24,null,null,12,1,null,null,null,null,null,60,15,null,null,null,12,10,10,10,null,null,null,null,54,18,12,8,null,null,null,null,null,"71 X 47",18,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,"9'6\"",30,null,null,0.1,0.25,null,null,"129 x 82","10'-9\" x 6'-10\"",30,null,null,0.1,0.25]
[null,null,null,48,12,null,null,null,16,8,10,10,null,null,null,null,null,"71 x 47",12,null,null,10,8,10,10,null,null,null,114,"9'6\"",18,null,null,12,1,null,null,"106 x 72","8'10\" x 6'1\"",18,null,null,12,1,null,null,"195 x 130","16'3\" x 10'10\"",36,null,null,12,1,null,null,null,null,null,66,18,null,null,null,12,10,10,10,null,null,null,null,60,18,10,8,null,null,null,"707.22                         (3\" x 1\" Corrugations)",null,"53 X 41",15,14,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"10'0\"",30,null,null,0.1,0.25,null,null,"133 x 84","11'-1\" x 7'-0\"",30,null,null,0.1,0.25]
[null,null,null,54,12,null,null,null,12,8,10,10,null,null,null,null,null,"77 x 52",12,null,null,8,8,10,10,null,null,null,120,"10'0\"",18,null,null,12,1,null,null,"112 x 75","9'4\" x 6'3\"",18,null,null,12,1,null,null,"198 x 132","16'6\" x 11'0\"",36,null,null,12,1,null,null,null,null,null,72,18,null,null,null,12,10,10,10,null,null,null,null,66,18,8,8,null,null,null,null,null,"60 X 46",15,12,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,"10'6\"",30,null,null,0.1,0.25,null,null,"137 x 85","11'-5\" x 7'-1\"",30,null,null,0.1,0.25]
[null,null,null,60,12,null,null,null,12,8,10,10,null,null,null,null,null,"83 x 57",12,null,null,8,8,10,10,null,null,null,126,"10'6\"",18,null,null,12,1,null,null,"114 x 77","9'6\" x 6'5\"",18,null,null,12,1,null,null,"204 x 134","17'0\" x 11'2\"",36,null,null,12,1,null,null,null,null,null,78,18,null,null,null,12,10,10,10,null,null,null,null,72,18,8,8,null,null,null,null,null,"66 X 51",15,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,"11'0\"",30,null,null,0.1,0.25,null,null,"141 x 86","11'-9\" x 7'-2\"",33,null,null,0.1,0.25]
[null,null,null,66,12,null,null,null,10,8,10,10,null,null,null,"707.02, 707.04, 707.07, 707.11 and 707.14                        (5\" x 1\" Corrugations)",null,"40 x 31",15,null,null,12,10,10,10,null,null,null,132,"11'0\"",18,null,null,12,1,null,null,"117 x 79","9'9\" x 6'7\"",18,null,null,12,1,null,null,"206 x 136","17'2\" x 11'4\"",36,null,null,12,1,null,null,null,null,null,84,18,null,null,null,10,10,10,10,null,null,"707.22                         (3\" x 1\" Corrugations)",null,36,12,16,10,null,null,null,null,null,"73 X 55",18,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,"11'6\"",30,null,null,0.1,0.25,null,null,"147 x 87","12'-3\" x 7'-3\"",33,null,null,0.1,0.25]
[null,null,null,72,12,null,null,null,10,8,10,10,null,null,null,null,null,"46 x 36",15,null,null,12,8,10,10,null,null,null,138,"11'6\"",18,null,null,12,1,null,null,"123 x 81","10'3\" x 6'9\"",18,null,null,12,1,null,null,"209 x 138","17'5\" x 11'6\"",36,null,null,12,1,null,null,null,null,null,90,18,null,null,null,10,10,10,10,null,null,null,null,42,12,16,10,null,null,null,null,null,"81 X 59",21,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,"12'0\"",36,null,null,0.1,0.25,null,null,"151 x 89","12'-7\" x 7'-5\"",33,null,null,0.1,0.25]
[null,null,null,78,12,null,null,null,8,8,10,10,null,null,null,null,null,"53 x 41",15,null,null,12,8,10,10,null,null,null,144,"12'0\"",18,null,null,12,1,null,null,"128 x 83","10'8\" x 6'11\"",18,null,null,12,1,null,null,"215 x 140","17'11\" x 11'8\"",36,null,null,12,1,null,null,null,null,null,96,18,null,null,null,10,10,10,10,null,null,null,null,48,12,16,10,null,null,null,null,null,"87 X 63",21,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,"12'6\"",36,null,null,0.1,0.25,null,null,"155 x 90","12'-11\" x 7'-6\"",33,null,null,0.1,0.25]
[null,null,null,84,12,null,null,null,8,8,10,10,null,null,null,null,null,"60 x 46",15,null,null,12,8,10,10,null,null,null,150,"12'6\"",24,null,null,12,1,null,null,"131 x 85","10'11\" x 7'1\"",18,null,null,12,1,null,null,"217 x 142","18'1\" x 11'10\"",36,null,null,12,1,null,null,null,null,null,102,18,null,null,null,10,10,10,10,null,null,null,null,54,18,14,10,null,null,null,null,null,"95 X 67",24,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156,"13'0\"",36,null,null,0.1,0.25,null,null,"157 x 98","13'-1\" x 8'-2\"",33,null,null,0.1,0.25]
[null,"707.02, 707.04, 707.07, 707.11 and 707.14                                (5\" x 1\" Corrugations)",null,36,12,null,null,null,16,10,10,10,null,null,null,null,null,"66 x 51",15,null,null,12,8,10,10,null,null,null,156,"13'0\"",24,null,null,12,1,null,null,"137 x 87","11'5\" x 7'3\"",18,null,null,12,1,null,null,"223 x 144","18'7\" x 12'0\"",36,null,null,12,1,null,null,null,null,null,108,18,null,null,null,10,10,10,10,null,null,null,null,60,18,12,8,null,null,null,null,null,"103 X 71",24,10,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,"13'6\"",36,null,null,0.1,0.25,null,null,"157 x 100","13'-1\" x 8'-4\"",33,null,null,0.1,0.25]
[null,null,null,42,12,null,null,null,16,8,10,10,null,null,null,null,null,"73 x 55",18,null,null,12,8,10,10,null,null,null,162,"13'6\"",24,null,null,12,1,null,null,"139 x 89","11'7\" x 7'5\"",18,null,null,12,1,null,null,"225 x 146","18'9\" x 12'2\"",36,null,null,12,1,null,null,null,null,null,114,18,null,null,null,10,10,10,10,null,null,null,null,66,18,12,8,null,null,null,null,null,"112 X 75",27,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168,"14'0\"",36,null,null,0.1,0.25,null,null,"167 x 101","13'-11\" x 8'-5\"",33,null,null,0.1,0.25]
[null,null,null,48,12,null,null,null,16,8,10,10,null,null,null,null,null,"81 x 59",18,null,null,12,8,10,10,null,null,null,168,"14'0\"",24,null,null,12,1,null,null,"142 x 91","11'10\" x 7'7\"",18,null,null,12,1,null,null,"231 x 148","19'3\" x 12'4\"",36,null,null,12,1,null,null,null,null,null,120,18,null,null,null,10,10,10,10,null,null,null,null,72,18,12,8,null,null,null,null,null,"117 X 79",27,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,174,"14'6\"",36,null,null,0.1,0.25,null,null,"167 x 113","13'-11\" x 9'-5\"",33,null,null,0.1,0.25]
[null,null,null,54,12,null,null,null,14,8,10,10,null,null,null,null,null,"87 x 63",18,null,null,12,8,10,10,null,null,null,174,"14'6\"",24,null,null,12,1,null,null,"148 x 93","12'4\" x 7'9\"",18,null,null,12,1,null,null,"234 x 150","19'6\" x 12'6\"",36,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,24,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,"15'0\"",36,null,null,0.1,0.25,null,null,"168 x 104","14'-0\" x 8'-7\"",33,null,null,0.1,0.25]
[null,null,null,60,12,null,null,null,14,8,10,10,null,null,null,null,null,"95 x 67",18,null,null,12,8,10,10,null,null,null,180,"15'0\"",24,null,null,12,1,null,null,"150 x 95","12'6\" x 7'11\"",18,null,null,12,1,null,null,"236 x 152","19'8\" x 12'8\"",36,null,null,12,1,null,null,null,707.17,null,"20 x 16",null,null,null,null,14,null,12,null,null,null,null,null,84,24,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,186,"15'6\"",36,null,null,0.1,0.25,null,null,"171 x 115","14'-3\" x 9'-7\"",33,null,null,0.1,0.25]
[null,null,null,66,12,null,null,null,12,8,10,10,null,null,null,null,null,"103 x 71",18,null,null,12,8,10,10,null,null,null,186,"15'6\"",24,null,null,12,1,null,null,"152 x 97","12'8\" x 8'1\"",24,null,null,12,1,null,null,"239 x 154","19'11\" x 12'10\"",36,null,null,12,1,null,null,null,null,null,"23 x 19",null,null,null,null,14,null,12,null,null,null,null,null,90,24,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,192,"16'0\"",36,null,null,0.1,0.25,null,null,"176 x 116","14'-8\" x 9'-8\"",33,null,null,0.1,0.25]
[null,null,null,72,12,null,null,null,12,8,10,10,null,null,null,null,null,"112 x 75",21,null,null,12,8,10,10,null,null,null,192,"16'0\"",24,null,null,12,1,null,null,"154 x 100","12'10\" x 8'4\"",24,null,null,12,1,null,null,"245 x 156","20'5\" x 13'0\"",36,null,null,12,1,null,null,null,null,null,"27 x 21",null,null,null,null,14,null,12,null,null,null,null,null,96,24,12,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198,"16'6\"",36,null,null,0.1,0.25,null,null,"179 x 118","14'-11\" x 9'-10\"",33,null,null,0.1,0.25]
[null,null,null,78,12,null,null,null,12,8,10,10,null,null,null,null,null,"117 x 79",21,null,null,12,8,10,10,null,null,null,198,"16'6\"",30,null,null,12,1,null,null,"161 x 101","13'5\" x 8'5\"",24,null,null,12,1,null,null,"247 x 158","20'7\" x 13'2\"",36,null,null,12,1,null,null,null,null,null,"33 x 26",null,null,null,null,14,null,12,null,null,null,null,null,102,30,10,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,204,"17'0\"",36,null,null,0.1,0.25,null,null,"184 x 120","15'-4\" x 10'-0\"",33,null,null,0.1,0.25]
[null,null,null,84,12,null,null,null,12,8,10,10,null,null,null,null,null,"128 x 83",24,null,null,10,8,10,10,null,null,null,204,"17'0\"",30,null,null,12,1,null,null,"167 x 103","13'11\" x 8'7\"",24,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 x 31",null,null,null,null,14,null,12,null,null,null,null,null,108,30,10,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"17'6\"",36,null,null,0.1,0.25,null,null,"187 x 122","15'-7\" x 10'-2\"",33,null,null,0.1,0.25]
[null,null,null,90,12,null,null,null,12,8,10,10,null,null,null,null,null,"137 x 87",24,null,null,10,8,10,10,null,null,null,210,"17'6\"",30,null,null,12,1,null,null,"168 x 105","14'1\" x 8'9\"",24,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46 x 36",null,null,null,null,14,null,12,null,null,null,null,null,114,30,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,216,"18'0\"",36,null,null,0.1,0.25,null,null,"193 x 124","16'-1\" x 10'-4\"",33,null,null,0.1,0.25]
[null,null,null,96,12,null,null,null,12,8,10,10,null,null,null,null,null,"142 x 91",24,null,null,8,8,10,10,null,null,null,216,"18'0\"",30,null,null,12,1,null,null,"171 x 107","14'3\" x 8'11\"",24,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"53 x 41",null,null,null,null,12,null,12,null,null,null,null,null,120,30,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222,"18'6\"",36,null,null,0.1,0.25,null,null,"196 x 126","16'-4\" x 10'-6\"",33,null,null,0.1,0.25]
[null,null,null,102,18,null,null,null,12,8,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222,"18'6\"",30,null,null,12,1,null,null,"178 x 109","14'10\" x 9'1\"",24,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 x 46",null,null,null,null,12,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,228,"19'0\"",36,null,null,0.1,0.25]
[null,null,null,108,18,null,null,null,12,8,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,228,"19'0\"",30,null,null,12,1,null,null,"184 x 111","15'4\" x 9'3\"",24,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"66 x 51",null,null,null,null,12,null,10]
[null,null,null,114,18,null,null,null,12,8,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,234,"19'6\"",30,null,null,12,1,null,null,"186 x 113","15'6\" x 9'5\"",24,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"73 x 55",null,null,null,null,12,null,10]
[null,null,null,120,18,null,null,null,12,8,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,"20'0\"",30,null,null,12,1,null,null,"188 x 115","15'8\" x 9'7\"",24,null,null,12,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"81 x 59",null,null,null,null,10,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,246,"20'6\"",36,null,null,12,1,null,null,"190 x 118","15'10\" x 9'10\"",24,null,null,12,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,252,"21'0\"",36,null,null,12,1,null,null,"197 x 119","16'5\" x 9'11\"",36,null,null,12,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"199 x 121","16'7\" x 10'1\"",36,null,null,12,1]

{"sheet":"Conduit Material Photos","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}