{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Preamble","Change Log","Instructions","Logic Flowchart","Strain Pole 1 Input","Strain Pole 2 Input","Strain Pole 3 Input","Strain Pole 4 Input","Strain Pole 5 Input","Strain Pole 6 Input","Strain Pole 7 Input","Strain Pole 8 Input","Strain Pole 9 Input","Strain Pole 10 Input","RESULTS","Equipment Loading","Lists"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":3,"defined_names":43,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Preamble","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,2,8,15],[9,2,9,15],[10,2,10,15],[1,1,1,15],[4,1,4,15],[5,2,5,15],[6,2,6,15],[7,2,7,15],[2,1,2,2],[2,3,2,15],[3,1,3,15]]}
[]
[null,"Engineering Manual Preamble"]
[null,"Revised",null,"2023-December"]
[]
[null,"This tool provides guidance to administrative, engineering, and technical staff. Engineering practice requires that professionals use a combination of technical skills and judgment in decision making. Engineering judgment is necessary to allow decisions to account for unique site-specific conditions and considerations to provide high quality products, within budget, and to protect the public health, safety, and welfare. This tool provides the general operational guidelines; however, it is understood that adaptation, adjustments, and deviations are sometimes necessary. Innovation is a key foundational element to advance the state of engineering practice and develop more effective and efficient engineering solutions and materials. As such, it is essential that our engineering manuals provide a vehicle to promote, pilot, or implement technologies or practices that provide efficiencies and quality products, while maintaining the safety, health, and welfare of the public. It is expected when making significant or impactful deviations from the technical information from these guidance materials, that reasonable consultations with experts, technical committees, and/or policy setting bodies occur prior to actions within the timeframes allowed. It is also expected that these consultations will eliminate any potential conflicts of interest, perceived or otherwise. MDOT Leadership is committed to a culture of innovation to optimize engineering solutions. The National Society of Professional Engineers Code of Ethics for Engineering is founded on six fundamental canons. Those canons are provided below. Engineers, in the fulfillment of their professional duties, shall:"]
[null,null,"1. Hold paramount the safety, health, and welfare of the public."]
[null,null,"2. Perform Services only in areas of their competence."]
[null,null,"3. Issue public statement only in an objective and truthful manner."]
[null,null,"4. Act for each employer or client as faithful agents or trustees."]
[null,null,"5. Avoid deceptive acts."]
[null,null,"6. Conduct themselves honorably, reasonably, ethically and lawfully so as to enhance the honor, reputation, and usefulness of the profession."]

{"sheet":"Change Log","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,15],[3,2,3,15],[10,2,10,11]]}
[]
[null,"Strain Pole Scoping Tool Change Log"]
[]
[null,"v0.5","ALPHA VERSION"]
[null,null,"• Initial release"]
[]
[null,"v0.6","BETA VERSION"]
[null,null,"• Addressing user comments"]
[]
[null,"v1.0","INITIAL RELEASE"]
[null,null,"• Added loading envelopes for 4-bolt strain poles and 6-bolt strain poles constructed using the SIG-020-B MDOT special detail dated 12/11/20 or earlier versions"]
[null,null,"• Updated logic to account for previously standardized 4-bolt and 6-bolt loading envelopes"]
[null,null,"• Added training YouTube video links to Instructions Tab"]

{"sheet":"Instructions","index":2,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[[41,1,41,15],[38,1,38,15],[39,1,39,15],[40,1,40,15],[16,1,17,15],[1,1,1,15],[2,1,2,15],[3,1,3,15],[4,1,4,15],[5,1,5,15],[6,1,6,15],[13,1,13,15],[14,1,14,15],[15,1,15,15],[8,1,8,15],[50,9,50,12],[43,3,43,4],[43,5,43,8],[43,9,43,12],[44,3,44,4],[45,3,45,4],[46,3,46,4],[44,5,44,8],[45,5,45,8],[46,5,46,8],[44,9,44,12],[47,3,47,4],[47,5,47,8],[47,9,47,12],[48,3,48,4],[48,5,48,8],[48,9,48,12],[46,9,46,12],[45,9,45,12],[43,1,43,2],[44,1,46,2],[47,1,51,2],[52,1,56,2],[55,3,55,4],[55,5,55,8],[55,9,55,12],[51,3,51,4],[51,5,51,8],[51,9,51,12],[52,3,52,4],[52,5,52,8],[52,9,52,12],[53,3,53,4],[53,5,53,8],[53,9,53,12],[54,3,54,4],[54,5,54,8],[54,9,54,12],[49,3,49,4],[49,5,49,8],[49,9,49,12],[50,3,50,4],[50,5,50,8],[58,1,58,15],[60,1,60,15],[62,1,62,2],[62,3,62,4],[62,5,62,8],[62,9,62,12],[56,3,56,4],[56,5,56,8],[56,9,56,12],[63,1,65,2],[63,3,63,4],[63,5,63,8],[63,9,63,12],[64,3,64,4],[64,5,64,8],[64,9,64,12],[65,3,65,4],[65,5,65,8],[65,9,65,12],[67,5,67,8],[67,9,67,12],[68,3,68,4],[68,5,68,8],[68,9,68,12],[69,3,69,4],[69,5,69,8],[69,9,69,12],[70,3,70,4],[70,5,70,8],[70,9,70,12],[77,1,77,15],[76,1,76,15],[57,1,57,15],[71,1,75,2],[71,3,71,4],[71,5,71,8],[71,9,71,12],[72,3,72,4],[72,5,72,8],[72,9,72,12],[73,3,73,4],[73,5,73,8],[73,9,73,12],[74,3,74,4],[74,5,74,8],[74,9,74,12],[75,3,75,4],[75,5,75,8],[75,9,75,12],[66,1,70,2],[66,3,66,4],[66,5,66,8],[66,9,66,12],[67,3,67,4]]}
[]
[null,"STRAIN POLE EVALUATION TOOL AND LOGIC FLOWCHART"]
[null,"MDOT Traffic and Safety Support Area"]
[]
[null,"PURPOSE"]
[]
[null,"This tool is intended to assist in scoping intersections with steel or wood strain poles where the proposed work would change the configuration of signs or signals carried by the span wire and therefore have an impact on the structural adequacy of the poles and their foundations.  For example, this tool should be used to inform projects intending to add backplates and/or tethering to existing strain poles."]
[]
[null,"Training Tutorial Video Links"]
[null,"Part 1:","https://youtu.be/DQEAKf36vX0"]
[null,"Part 2:","https://youtu.be/eXJVpzXHytc"]
[null,"Part 3:","https://youtu.be/aXjFhMkTOgQ"]
[null,"Part 4:","https://youtu.be/aXjFhMkTOgQ"]
[]
[null,"INSTRUCTIONS"]
[]
[null,"Click \"Enable Content\" at the top of the spreadsheet in order to allow the spreadsheet to have full functionality.\n\nUsing the Logic Flowchart\nThis tool should be utilized in a step-by-step approach by pole (i.e. The entire flowchart pathway should be followed for pole 1 before moving on to strain pole 2)\n\nVarious steps may have colored indicators noting when prequalifications are required. If any decisions lead to a red square, this indicates that the project will likely require an entire replacement of the given pole.\n\nUsing the Evaluation Tool\nThis tool should be utilized in a step-by-step approach in conjunction with the flow chart developed parallel to this tool. (i.e. all data for strain pole 1 should be entered starting at the top of the sheet, moving section by section to the bottom of the sheet before moving on to strain pole 2, etc.) \n\nEach sheet is representative of a different pole and should be used in such a manner (i.e. Enter all data for Pole 1 in the \"Strain Pole 1\" tab and all data for Pole 2 in the \"Strain Pole 2\" tab.)\n\nWithin each sheet are yellow highlighted boxes. These boxes are where data should be entered for each pole. Utilize the provided drop down menu's to select input data. DO NOT CUT AND PASTE ANY CELLS and DO NOT FILL IN ANY NON-HIGHLIGHTED BOXES. If data is accidentally entered into an unhighlighted box, simply delete the entered data from the box or use the clear section button. Note: Some sections may highlight yellow that were previously blank based on data entered for the pole.\n\nAn example of how to fill out the top section of the Pole 1 tab is shown below:\n\n\n\n\n\n\n\n\n\n\nTo determine if loading exceeds the existing condition, utilize the Signal Span Calculation Program. In general, if additional equipment is added, the loading will increase. Always select \"Yes\" for loading unless existing equipment is being removed or replaced with smaller or lighter equipment. If condition ratings for poles are not known, utilize the ArcGIS database shown here: https://hntbcorp.maps.arcgis.com/apps/dashboards/b44d63a1781148089d5e6a195e532866. If you are not able to access this database, contact the Ancillary Structures unit at MDOT-Ancillary@michigan.gov.\n\nLabelling the Poles\nPoles should be labelled beginning with 1 at the pole located nearest to the signal controller and continuing clockwise around the intersection as shown in the figure below. The traffic designer will input at the top of each pole sheet the pole location (cardinal directions (ie. North, South, East, West) are used to determine the location of the pole relative to the intersection) and the structure ID of the strain pole, if applicable. To obtain the structure ID, contact the Ancillary Structures unit and include the site CS Spot Location,and the Latitude & Longitude Coordinates of the intersection center in the correspondence."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LOADING ENVELOPES"]
[null,"As noted in the \"Load Capacity\" section of this tool, use these tables to determine whether your proposed loading falls within the documented loading envelope for the listed standards. For newer strain poles, refer to the relevant statewide standards and special details."]
[]
[null,"6-Bolt Strain Pole, constructed using the SIG-020-B MDOT special detail dated 12/11/20 or earlier versions*"]
[]
[null,"Pole Height",null,"Span Length",null,"Weight of Generalized Load (LBS)**",null,null,null,"Max Perp. Wind Area (Tethered spans, signals with backplates) (SFT)**"]
[null,"30 ft",null,"Up to 100 ft",null,153.9,null,null,null,24.7]
[null,null,null,"101 ft to 120 ft",null,153.9,null,null,null,24.7]
[null,null,null,"121 ft to 150 ft",null,153.9,null,null,null,24.7]
[null,"36 ft",null,"Up to 100 ft",null,171,null,null,null,27.4]
[null,null,null,"101 ft to 120 ft",null,171,null,null,null,27.4]
[null,null,null,"121 ft to 150 ft",null,171,null,null,null,27.4]
[null,null,null,"151 ft to 175 ft",null,171,null,null,null,27.4]
[null,null,null,"176 ft to 200 ft",null,171,null,null,null,27.4]
[null,"40 ft",null,"Up to 100 ft",null,171,null,null,null,27.4]
[null,null,null,"101 ft to 120 ft",null,171,null,null,null,27.4]
[null,null,null,"121 ft to 150 ft",null,171,null,null,null,27.4]
[null,null,null,"151 ft to 175 ft",null,171,null,null,null,27.4]
[null,null,null,"176 ft to 200 ft",null,171,null,null,null,27.4]
[null,"*Tie-offs and field-drilled holes are not considered."]
[null,"** Weights and areas include allowance for signals, signs, and anything else carried by the cables."]
[]
[null,"4-Bolt Strain Pole*"]
[]
[null,"Pole Height",null,"Span Length",null,"Weight of Generalized Load (LBS)**",null,null,null,"Max Perp. Wind Area (Tethered spans, signals with backplates) (SFT)**"]
[null,"30 ft",null,"Up to 100 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"101 ft to 120 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"121 ft to 150 ft",null,51.3,null,null,null,8.1999999999999993]
[null,"36 ft",null,"Up to 100 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"101 ft to 120 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"121 ft to 150 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"151 ft to 175 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"176 ft to 200 ft",null,51.3,null,null,null,8.1999999999999993]
[null,"40 ft",null,"Up to 100 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"101 ft to 120 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"121 ft to 150 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"151 ft to 175 ft",null,51.3,null,null,null,8.1999999999999993]
[null,null,null,"176 ft to 200 ft",null,51.3,null,null,null,8.1999999999999993]
[null,"*Tie-offs and field-drilled holes are not considered."]
[null,"** Weights and areas include allowance for signals, signs, and anything else carried by the cables."]

{"sheet":"Logic Flowchart","index":3,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,62,11]]}
[null,"Strain Pole Scoping Tool"]
[null,"FLOWCHART SHOWING THE LOGIC OF HOW USER INPUTS LEAD TO RECOMMENDATIONS."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTES:\n*UTILIZE THE MOST RECENT INSPECTION THROUGH THE MDOT ANCILLARY STRUCTURES PROGRAM. SEE MIASIM FOR ADDITIONAL DETAILS.\n1. EACH TIME \"SPAN\" IS NOTED, REFERENCE ALL SPANS CONNECTED TO THE POLE BEING EVALUATED."]

{"sheet":"Strain Pole 1 Input","index":4,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[20,1,20,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[11,1,11,9],[13,1,13,9],[18,1,18,9],[5,2,5,6],[5,8,5,9],[7,1,7,9],[16,1,16,9],[47,1,47,9],[27,1,27,9],[30,1,30,9],[41,1,41,9],[44,3,44,9],[43,1,43,9],[32,3,32,9],[33,3,33,9],[36,3,36,9],[37,3,37,9]]}
[]
[null,"Intersection Description: ",null,null,null,null,null,"Pole #:",1]
[]
[null,null,null,null,null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:"]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B10=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B13=\"\",\"\",IF(B13=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B18=Lists!A10,B18=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B20=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B24=\"No\",\"\",IF(B26=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B43=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B10=\"No\",B13=\"Yes\",B20=\"Yes\",B26=\"No\",B43=\"No\",B45=\"Yes\",B45=\"No\"),\"All Pole 1 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 2 Input","index":5,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,9],[23,1,23,9],[8,1,8,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[30,1,30,9],[33,1,33,9],[44,1,44,9],[47,3,47,9],[46,1,46,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",2]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 2 identical to Pole 1?"]
[null,{"$f":"IF(B8=Lists!A2,\"All work associated with pole 1 has been applied to pole 2.\",\"\")","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=\"Yes\",B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 2 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 3 Input","index":6,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,9],[23,1,23,9],[8,1,8,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[30,1,30,9],[33,1,33,9],[44,1,44,9],[47,3,47,9],[46,1,46,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",3]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 3 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 3.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 3.\",\"\"))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 3 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 4 Input","index":7,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,9],[23,1,23,9],[8,1,8,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[30,1,30,9],[33,1,33,9],[44,1,44,9],[47,3,47,9],[46,1,46,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",4]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 4 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 4.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 4.\",IF(B8=Lists!A21,\"All work associated with pole 3 has been applied to pole 4.\",\"\")))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B8=Lists!A21,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 4 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 5 Input","index":8,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[36,3,36,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[47,3,47,9],[46,1,46,9],[8,1,8,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[21,1,21,9],[23,1,23,9],[30,1,30,9],[33,1,33,9],[44,1,44,9],[39,3,39,9],[40,3,40,9],[35,3,35,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",5]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 5 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 5.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 5.\",IF(B8=Lists!A21,\"All work associated with pole 3 has been applied to pole 5.\",IF(B8=Lists!A22,\"All work associated with pole 4 has been applied to pole 5.\",\"\"))))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B8=Lists!A21,B8=Lists!A22,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 5 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 6 Input","index":9,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[5,2,5,6],[5,8,5,9],[21,1,21,9],[8,1,8,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[50,1,50,9],[23,1,23,9],[30,1,30,9],[33,1,33,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9],[44,1,44,9],[46,1,46,9],[47,3,47,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",6]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 6 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 6.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 6.\",IF(B8=Lists!A21,\"All work associated with pole 3 has been applied to pole 6.\",IF(B8=Lists!A22,\"All work associated with pole 4 has been applied to pole 6.\",IF(B8=Lists!A23,\"All work associated with pole 5 has been applied to pole 6.\",\"\")))))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B8=Lists!A21,B8=Lists!A22,B8=Lists!A23,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 6 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 7 Input","index":10,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,9],[8,1,8,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[23,1,23,9],[30,1,30,9],[33,1,33,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9],[44,1,44,9],[46,1,46,9],[47,3,47,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",7]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 7 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 7.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 7.\",IF(B8=Lists!A21,\"All work associated with pole 3 has been applied to pole 7.\",IF(B8=Lists!A22,\"All work associated with pole 4 has been applied to pole 7.\",IF(B8=Lists!A23,\"All work associated with pole 5 has been applied to pole 7.\",IF(B8=Lists!A24,\"All work associated with pole 6 has been applied to pole 7.\",\"\"))))))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B8=Lists!A21,B8=Lists!A22,B8=Lists!A23,B8=Lists!A24,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 7 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 8 Input","index":11,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[8,1,8,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[23,1,23,9],[30,1,30,9],[33,1,33,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9],[44,1,44,9],[46,1,46,9],[47,3,47,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",8]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 8 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 8.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 8.\",IF(B8=Lists!A21,\"All work associated with pole 3 has been applied to pole 8.\",IF(B8=Lists!A22,\"All work associated with pole 4 has been applied to pole 8.\",IF(B8=Lists!A23,\"All work associated with pole 5 has been applied to pole 8.\",IF(B8=Lists!A24,\"All work associated with pole 6 has been applied to pole 8.\",IF(B8=Lists!A25,\"All work associated with pole 7 has been applied to pole 8.\",\"\")))))))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B8=Lists!A21,B8=Lists!A22,B8=Lists!A23,B8=Lists!A24,B8=Lists!A25,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 8 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 9 Input","index":12,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[8,1,8,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[23,1,23,9],[30,1,30,9],[33,1,33,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9],[44,1,44,9],[46,1,46,9],[47,3,47,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",9]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 9 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 9.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 9.\",IF(B8=Lists!A21,\"All work associated with pole 3 has been applied to pole 9.\",IF(B8=Lists!A22,\"All work associated with pole 4 has been applied to pole 9.\",IF(B8=Lists!A23,\"All work associated with pole 5 has been applied to pole 9.\",IF(B8=Lists!A24,\"All work associated with pole 6 has been applied to pole 9.\",IF(B8=Lists!A25,\"All work associated with pole 7 has been applied to pole 9.\",IF(B8=Lists!A26,\"All work associated with pole 8 has been applied to pole 9.\",\"\"))))))))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B8=Lists!A21,B8=Lists!A22,B8=Lists!A23,B8=Lists!A24,B8=Lists!A25,B8=Lists!A26,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 9 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"Strain Pole 10 Input","index":13,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,1,21,9],[1,1,1,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[3,8,3,9],[8,1,8,9],[10,1,10,9],[14,1,14,9],[16,1,16,9],[19,1,19,9],[5,2,5,6],[5,8,5,9],[50,1,50,9],[23,1,23,9],[30,1,30,9],[33,1,33,9],[35,3,35,9],[36,3,36,9],[39,3,39,9],[40,3,40,9],[44,1,44,9],[46,1,46,9],[47,3,47,9]]}
[]
[null,"Intersection Description: ",null,{"$f":"IF('Strain Pole 1 Input'!D2=0,\"\",'Strain Pole 1 Input'!D2)","v":""},null,null,null,"Pole #:",10]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D3=0,\"\",'Strain Pole 1 Input'!D3)","v":""}]
[null,null,null,{"$f":"IF('Strain Pole 1 Input'!D4=0,\"\",'Strain Pole 1 Input'!D4)","v":""},null,null,null,"Structure ID:"]
[]
[null,"Pole Location:",null,null,null,null,null,"CS Spot Location:",{"$f":"IF('Strain Pole 1 Input'!I6=0,\"\",'Strain Pole 1 Input'!I6)","v":""}]
[]
[null,null,"  Is Pole 10 identical to another pole?"]
[null,{"$f":"IF(B8=Lists!A19,\"All work associated with pole 1 has been applied to pole 10.\",IF(B8=Lists!A20,\"All work associated with pole 2 has been applied to pole 10.\",IF(B8=Lists!A21,\"All work associated with pole 3 has been applied to pole 10.\",IF(B8=Lists!A22,\"All work associated with pole 4 has been applied to pole 10.\",IF(B8=Lists!A23,\"All work associated with pole 5 has been applied to pole 10.\",IF(B8=Lists!A24,\"All work associated with pole 6 has been applied to pole 10.\",IF(B8=Lists!A25,\"All work associated with pole 7 has been applied to pole 10.\",IF(B8=Lists!A26,\"All work associated with pole 8 has been applied to pole 10.\",IF(B8=Lists!A27,\"All work associated with pole 9 has been applied to pole 10.\",\"\")))))))))","v":""}]
[]
[null,"INITIAL CHECK"]
[]
[null,null,"Is additional equipment (or heavier equipment) being added to the intersection?"]
[null,null,"(i.e. is the proposed loading greater than the existing loading)"]
[null,{"$f":"IF(B13=Lists!A3,\"No additional checks needed.  Proceed with project\",\"\")","v":""}]
[null,null,"Is the existing pole embedded steel or wooden?"]
[null,{"$f":"IF(B16=\"\",\"\",IF(B16=Lists!A3,\"\",\"FULL REPLACEMENT RECOMMENDED\"))","v":""}]
[]
[]
[null,"INSPECTION RATING(S)"]
[null,null,"Overall Structure Rating ≤ 4"]
[null,{"$f":"IF(OR(B21=Lists!A10,B21=Lists!A11),\"Move to Outstanding Issues Section\",\"\")","v":""}]
[null,null,"Foundation Component Rating ≤ 4"]
[null,{"$f":"IF(B23=\"Yes\", \"Full Replacement Recommended\",\"\")","v":""}]
[null,null,"Vertical Structure Component Rating ≤ 4"]
[null,null,"Element Ratings:"]
[null,null,"Is any portion of the Pole or Base Plate Rated Poor or Severe?"]
[null,null,null,"Can the poorly rated element be repaired?"]
[null,null,null,"If it can't be repaired, can the pole be replaced in-kind?"]
[null,null,"Is any portion of the Vertical Connection Rated Poor or Severe?"]
[null,{"$f":"IF(B27=\"No\",\"\",IF(B29=\"No\",\"Full Replacement Recommended\",\"\"))","v":""}]
[]
[]
[null,"OUTSTANDING ISSUES"]
[null,null,"Is there an outstanding RFA or Work Rec for this pole?"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the RFA or Work Rec require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[null,null,"Are there any construction non-conformance reports or other known issues with the pole?"]
[null,null,null,"Does the issue highlighted in the report reduce the pole's structural capacity? (i.e. heavy rust, impact damage, etc.)"]
[null,null,null,"Does the issue highlighted in the report require a geotechnical evaluation during the design phase? (i.e. the issue is related to movement of the foundation or damage to the foundation, etc.)"]
[]
[]
[]
[null,"LOAD CAPACITY"]
[null,null,"Is the year of installation and/or are the standards known for the pole?"]
[null,{"$f":"IF(B46=Lists!A2,\"Note: See instructions sheet for load envelope.\",\"\")","v":""}]
[null,null,null,"Does the proposed design meet requirements of its signal standards and the proposed loading fall within the documented load envelope? (See \"Instructions\" tab for loading envelopes.)"]
[]
[]
[null,{"$f":"IF(OR(B8=Lists!A19,B8=Lists!A20,B8=Lists!A21,B8=Lists!A22,B8=Lists!A23,B8=Lists!A24,B8=Lists!A25,B8=Lists!A26,B8=Lists!A27,B13=\"No\",B16=\"Yes\",B23=\"Yes\",B29=\"No\",B46=\"No\",B48=\"Yes\",B48=\"No\"),\"All Pole 9 work has been updated in the Results tab.\",\"\")","v":""}]

{"sheet":"RESULTS","index":14,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,1,6,14],[1,5,1,7],[3,5,3,6],[1,11,1,13],[2,11,2,12],[3,11,3,12],[1,1,3,2],[1,3,1,4],[2,3,2,4],[3,3,3,4]]}
[]
[null,null,null,"Project Name: ",null,null,null,null,null,null,"Intersection Name:"]
[null,null,null,null,null,null,null,null,null,null,"MDOT CS: "]
[null,null,null,"MDOT JN: ",null,null,null,null,null,null,"MI County: "]
[]
[]
[null,"INCLUDE THE FOLLOWING WITH WORK"]
[null,"POLE #","POLE LOCATION","Proceed as is. No additional checks needed.","Full Replacement \nof Foundation \nand Pole Recommended","1a. Structural Prequalification  Needed for Site-Specific Structural Design","1b. Structural Prequalification Needed for Repair Design","2. Field Investigation to gather data for site-specific analysis of existing poles (Gather material properties, structural component sizes, soil properties, etc.)","3. Geotechnical Prequalification","Replace pole \nin-kind and \nreplace vertical connections.","Repair base plate/pole","Replace Vertical Connections","Replace Horizontal Elements (i.e. span wire, span wire connections, luminaire arm, etc.)","Outstanding repairs from RFAs and Work Recs","Repairs to address construction non-conformance report(s) or other known issues."]
[null,"Strain Pole 1",{"$f":"'Strain Pole 1 Input'!C6","v":0},{"$f":"IF('Strain Pole 1 Input'!B$10=\"No\",\"X\",IF(AND(E$9:O$9=\"\",'Strain Pole 1 Input'!B$45=Lists!A$2),\"X\",\"\"))","v":""},{"$f":"IF('Strain Pole 1 Input'!B$14=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 1 Input'!B$21=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 1 Input'!B$28=\"Full Replacement Recommended\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 1 Input'!B$43=\"No\",\"X\",IF('Strain Pole 1 Input'!B$45=Lists!A$3,\"X\",IF('Strain Pole 1 Input'!B$45=Lists!A$3,\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 1 Input'!B$25=\"Yes\",\"X\",IF(OR('Strain Pole 1 Input'!B$33=\"Yes\",'Strain Pole 1 Input'!B$34=\"Yes\"),\"X\",IF(OR('Strain Pole 1 Input'!B$37=\"Yes\",'Strain Pole 1 Input'!B$38=\"Yes\"),\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 1 Input'!B$18=\"Not Rated\",\"X\",IF(OR('Strain Pole 1 Input'!B$37=\"Yes\",'Strain Pole 1 Input'!B$38=\"Yes\"),\"X\",IF('Strain Pole 1 Input'!B$43=\"No\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 1 Input'!B$34=\"Yes\",\"X\",IF('Strain Pole 1 Input'!B$38=\"Yes\",\"X\",IF('Strain Pole 1 Input'!B$43=\"No\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 1 Input'!B$26=\"Yes\",\"X\",\"\")","v":""},{"$f":"IF('Strain Pole 1 Input'!B$25=\"Yes\",\"X\",\"\")","v":""},{"$f":"IF('Strain Pole 1 Input'!B$27=\"Yes\",\"X\",\"\")","v":""},{"$f":"IF('Strain Pole 1 Input'!B$22=\"No\",\"X\",\"\")","v":""},{"$f":"IF('Strain Pole 1 Input'!B$32=\"Yes\",\"X\",\"\")","v":""},{"$f":"IF('Strain Pole 1 Input'!B$36=\"Yes\",\"X\",\"\")","v":""}]
[null,"Strain Pole 2",{"$f":"'Strain Pole 2 Input'!C6","v":0},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!D$9,IF('Strain Pole 2 Input'!B$13=\"No\",\"X\",IF(AND(E$10:O$10=\"\",'Strain Pole 2 Input'!B$48=Lists!A$2),\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!E$9,IF('Strain Pole 2 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 2 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 2 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!F$9,IF('Strain Pole 2 Input'!B$46=\"No\",\"X\",IF('Strain Pole 2 Input'!B$48=Lists!A$3,\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!G$9,IF('Strain Pole 2 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 2 Input'!B$36=\"Yes\",'Strain Pole 2 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 2 Input'!B$40=\"Yes\",'Strain Pole 2 Input'!B$41=\"Yes\"),\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!H$9,IF('Strain Pole 2 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 2 Input'!B$40=\"Yes\",'Strain Pole 2 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 2 Input'!B$46=\"No\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!I$9,IF('Strain Pole 2 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 2 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 2 Input'!B$46=\"No\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!J$9,IF('Strain Pole 2 Input'!B$29=\"Yes\",\"X\",\"\"))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!K$9,IF('Strain Pole 2 Input'!B$28=\"Yes\",\"X\",\"\"))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!L$9,IF('Strain Pole 2 Input'!B$30=\"Yes\",\"X\",\"\"))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!M$9,IF('Strain Pole 2 Input'!B$25=\"No\",\"X\",\"\"))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!N$9,IF('Strain Pole 2 Input'!B$35=\"Yes\",\"X\",\"\"))","v":""},{"$f":"IF('Strain Pole 2 Input'!B$8=Lists!A$2,RESULTS!O$9,IF('Strain Pole 2 Input'!B$39=\"Yes\",\"X\",\"\"))","v":""}]
[null,"Strain Pole 3",{"$f":"'Strain Pole 3 Input'!C6","v":0},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!D$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!D$10,IF('Strain Pole 3 Input'!B$13=\"No\",\"X\",IF(AND(E$11:O$11=\"\",'Strain Pole 3 Input'!B$48=Lists!A$2),\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!E$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!E$10,IF('Strain Pole 3 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 3 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 3 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!F$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!F$10,IF('Strain Pole 3 Input'!B$46=\"No\",\"X\",IF('Strain Pole 3 Input'!B$48=Lists!A$3,\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!G$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!G$10,IF('Strain Pole 3 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 3 Input'!B$36=\"Yes\",'Strain Pole 3 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 3 Input'!B$40=\"Yes\",'Strain Pole 3 Input'!B$41=\"Yes\"),\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!H$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!H$10,IF('Strain Pole 3 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 3 Input'!B$40=\"Yes\",'Strain Pole 3 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 3 Input'!B$46=\"No\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!I$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!I$10,IF('Strain Pole 3 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 3 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 3 Input'!B$46=\"No\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!J$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!J$10,IF('Strain Pole 3 Input'!B$29=\"Yes\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!K$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!K$10,IF('Strain Pole 3 Input'!B$28=\"Yes\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!L$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!L$10,IF('Strain Pole 3 Input'!B$30=\"Yes\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!M$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!M$10,IF('Strain Pole 3 Input'!B$25=\"No\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!N$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!N$10,IF('Strain Pole 3 Input'!B$35=\"Yes\",\"X\",\"\")))","v":""},{"$f":"IF('Strain Pole 3 Input'!B$8=Lists!A$19,RESULTS!O$9,IF('Strain Pole 3 Input'!B$8=Lists!A$20,RESULTS!O$10,IF('Strain Pole 3 Input'!B$39=\"Yes\",\"X\",\"\")))","v":""}]
[null,"Strain Pole 4",{"$f":"'Strain Pole 4 Input'!C6","v":0},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!D$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!D$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!D$11,IF('Strain Pole 4 Input'!B$13=\"No\",\"X\",IF(AND(E$12:O$12=\"\",'Strain Pole 4 Input'!B$48=Lists!A$2),\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!E$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!E$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!E$11,IF('Strain Pole 4 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 4 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 4 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!F$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!F$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!F$11,IF('Strain Pole 4 Input'!B$46=\"No\",\"X\",IF('Strain Pole 4 Input'!B$48=Lists!A$3,\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!G$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!G$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!G$11,IF('Strain Pole 4 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 4 Input'!B$36=\"Yes\",'Strain Pole 4 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 4 Input'!B$40=\"Yes\",'Strain Pole 4 Input'!B$41=\"Yes\"),\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!H$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!H$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!H$11,IF('Strain Pole 4 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 4 Input'!B$40=\"Yes\",'Strain Pole 4 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 4 Input'!B$46=\"No\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!I$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!I$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!I$11,IF('Strain Pole 4 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 4 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 4 Input'!B$46=\"No\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!J$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!J$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!J$11,IF('Strain Pole 4 Input'!B$29=\"Yes\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!K$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!K$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!K$11,IF('Strain Pole 4 Input'!B$28=\"Yes\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!L$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!L$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!L$11,IF('Strain Pole 4 Input'!B$30=\"Yes\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!M$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!M$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!M$11,IF('Strain Pole 4 Input'!B$25=\"No\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!N$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!N$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!N$11,IF('Strain Pole 4 Input'!B$35=\"Yes\",\"X\",\"\"))))","v":""},{"$f":"IF('Strain Pole 4 Input'!B$8=Lists!A$19,RESULTS!O$9,IF('Strain Pole 4 Input'!B$8=Lists!A$20,RESULTS!O$10,IF('Strain Pole 4 Input'!B$8=Lists!A$21,RESULTS!O$11,IF('Strain Pole 4 Input'!B$39=\"Yes\",\"X\",\"\"))))","v":""}]
[null,"Strain Pole 5",{"$f":"'Strain Pole 5 Input'!C6","v":0},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!D$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!D$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!D$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!D$12,IF('Strain Pole 5 Input'!B$13=\"No\",\"X\",IF(AND(E$13:O$13=\"\",'Strain Pole 5 Input'!B$48=Lists!A$2),\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!E$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!E$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!E$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!E$12,IF('Strain Pole 5 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 5 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 5 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!F$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!F$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!F$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!F$12,IF('Strain Pole 5 Input'!B$46=\"No\",\"X\",IF('Strain Pole 5 Input'!B$48=Lists!A$3,\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!G$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!G$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!G$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!G$12,IF('Strain Pole 5 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 5 Input'!B$36=\"Yes\",'Strain Pole 5 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 5 Input'!B$40=\"Yes\",'Strain Pole 5 Input'!B$41=\"Yes\"),\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!H$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!H$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!H$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!H$12,IF('Strain Pole 5 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 5 Input'!B$40=\"Yes\",'Strain Pole 5 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 5 Input'!B$46=\"No\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!I$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!I$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!I$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!I$12,IF('Strain Pole 5 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 5 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 5 Input'!B$46=\"No\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!J$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!J$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!J$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!J$12,IF('Strain Pole 5 Input'!B$29=\"Yes\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!K$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!K$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!K$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!K$12,IF('Strain Pole 5 Input'!B$28=\"Yes\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!L$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!L$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!L$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!L$12,IF('Strain Pole 5 Input'!B$30=\"Yes\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!M$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!M$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!M$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!M$12,IF('Strain Pole 5 Input'!B$25=\"No\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!N$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!N$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!N$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!N$12,IF('Strain Pole 5 Input'!B$35=\"Yes\",\"X\",\"\")))))","v":""},{"$f":"IF('Strain Pole 5 Input'!B$8=Lists!A$19,RESULTS!O$9,IF('Strain Pole 5 Input'!B$8=Lists!A$20,RESULTS!O$10,IF('Strain Pole 5 Input'!B$8=Lists!A$21,RESULTS!O$11,IF('Strain Pole 5 Input'!B$8=Lists!A$22,RESULTS!O$12,IF('Strain Pole 5 Input'!B$39=\"Yes\",\"X\",\"\")))))","v":""}]
[null,"Strain Pole 6",{"$f":"'Strain Pole 6 Input'!C6","v":0},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!D$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!D$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!D$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!D$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!D$13,IF('Strain Pole 6 Input'!B$13=\"No\",\"X\",IF(AND(E$14:O$14=\"\",'Strain Pole 6 Input'!B$48=Lists!A$2),\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!E$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!E$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!E$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!E$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!E$13,IF('Strain Pole 6 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 6 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 6 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!F$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!F$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!F$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!F$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!F$13,IF('Strain Pole 6 Input'!B$46=\"No\",\"X\",IF('Strain Pole 6 Input'!B$48=Lists!A$3,\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!G$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!G$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!G$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!G$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!G$13,IF('Strain Pole 6 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 6 Input'!B$36=\"Yes\",'Strain Pole 6 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 6 Input'!B$40=\"Yes\",'Strain Pole 6 Input'!B$41=\"Yes\"),\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!H$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!H$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!H$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!H$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!H$13,IF('Strain Pole 6 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 6 Input'!B$40=\"Yes\",'Strain Pole 6 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 6 Input'!B$46=\"No\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!I$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!I$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!I$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!I$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!I$13,IF('Strain Pole 6 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 6 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 6 Input'!B$46=\"No\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!J$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!J$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!J$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!J$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!J$13,IF('Strain Pole 6 Input'!B$29=\"Yes\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!K$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!K$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!K$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!K$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!K$13,IF('Strain Pole 6 Input'!B$28=\"Yes\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!L$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!L$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!L$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!L$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!L$13,IF('Strain Pole 6 Input'!B$30=\"Yes\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!M$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!M$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!M$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!M$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!M$13,IF('Strain Pole 6 Input'!B$25=\"No\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!N$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!N$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!N$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!N$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!N$13,IF('Strain Pole 6 Input'!B$35=\"Yes\",\"X\",\"\"))))))","v":""},{"$f":"IF('Strain Pole 6 Input'!B$8=Lists!A$19,RESULTS!O$9,IF('Strain Pole 6 Input'!B$8=Lists!A$20,RESULTS!O$10,IF('Strain Pole 6 Input'!B$8=Lists!A$21,RESULTS!O$11,IF('Strain Pole 6 Input'!B$8=Lists!A$22,RESULTS!O$12,IF('Strain Pole 6 Input'!B$8=Lists!A$23,RESULTS!O$13,IF('Strain Pole 6 Input'!B$39=\"Yes\",\"X\",\"\"))))))","v":""}]
[null,"Strain Pole 7",{"$f":"'Strain Pole 7 Input'!C6","v":0},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!D$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!D$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!D$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!D$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!D$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!D$14,IF('Strain Pole 7 Input'!B$13=\"No\",\"X\",IF(AND(E$15:O$15=\"\",'Strain Pole 7 Input'!B$48=Lists!A$2),\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!E$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!E$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!E$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!E$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!E$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!E$14,IF('Strain Pole 7 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 7 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 7 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!F$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!F$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!F$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!F$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!F$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!F$14,IF('Strain Pole 7 Input'!B$46=\"No\",\"X\",IF('Strain Pole 7 Input'!B$48=Lists!A$3,\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!G$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!G$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!G$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!G$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!G$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!G$14,IF('Strain Pole 7 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 7 Input'!B$36=\"Yes\",'Strain Pole 7 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 7 Input'!B$40=\"Yes\",'Strain Pole 7 Input'!B$41=\"Yes\"),\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!H$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!H$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!H$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!H$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!H$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!H$14,IF('Strain Pole 7 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 7 Input'!B$40=\"Yes\",'Strain Pole 7 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 7 Input'!B$46=\"No\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!I$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!I$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!I$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!I$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!I$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!I$14,IF('Strain Pole 7 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 7 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 7 Input'!B$46=\"No\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!J$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!J$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!J$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!J$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!J$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!J$14,IF('Strain Pole 7 Input'!B$29=\"Yes\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!K$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!K$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!K$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!K$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!K$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!K$14,IF('Strain Pole 7 Input'!B$28=\"Yes\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!L$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!L$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!L$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!L$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!L$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!L$14,IF('Strain Pole 7 Input'!B$30=\"Yes\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!M$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!M$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!M$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!M$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!M$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!M$14,IF('Strain Pole 7 Input'!B$25=\"No\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!N$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!N$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!N$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!N$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!N$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!N$14,IF('Strain Pole 7 Input'!B$35=\"Yes\",\"X\",\"\")))))))","v":""},{"$f":"IF('Strain Pole 7 Input'!B$8=Lists!A$19,RESULTS!O$9,IF('Strain Pole 7 Input'!B$8=Lists!A$20,RESULTS!O$10,IF('Strain Pole 7 Input'!B$8=Lists!A$21,RESULTS!O$11,IF('Strain Pole 7 Input'!B$8=Lists!A$22,RESULTS!O$12,IF('Strain Pole 7 Input'!B$8=Lists!A$23,RESULTS!O$13,IF('Strain Pole 7 Input'!B$8=Lists!A$24,RESULTS!O$14,IF('Strain Pole 7 Input'!B$39=\"Yes\",\"X\",\"\")))))))","v":""}]
[null,"Strain Pole 8",{"$f":"'Strain Pole 8 Input'!C6","v":0},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!D$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!D$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!D$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!D$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!D$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!D$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!D$15,IF('Strain Pole 8 Input'!B$13=\"No\",\"X\",IF(AND(E$16:O$16=\"\",'Strain Pole 8 Input'!B$48=Lists!A$2),\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!E$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!E$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!E$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!E$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!E$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!E$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!E$15,IF('Strain Pole 8 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 8 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 8 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!F$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!F$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!F$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!F$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!F$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!F$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!F$15,IF('Strain Pole 8 Input'!B$46=\"No\",\"X\",IF('Strain Pole 8 Input'!B$48=Lists!A$3,\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!G$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!G$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!G$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!G$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!G$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!G$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!G$15,IF('Strain Pole 8 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 8 Input'!B$36=\"Yes\",'Strain Pole 8 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 8 Input'!B$40=\"Yes\",'Strain Pole 8 Input'!B$41=\"Yes\"),\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!H$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!H$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!H$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!H$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!H$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!H$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!H$15,IF('Strain Pole 8 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 8 Input'!B$40=\"Yes\",'Strain Pole 8 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 8 Input'!B$46=\"No\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!I$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!I$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!I$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!I$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!I$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!I$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!I$15,IF('Strain Pole 8 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 8 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 8 Input'!B$46=\"No\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!J$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!J$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!J$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!J$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!J$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!J$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!J$15,IF('Strain Pole 8 Input'!B$29=\"Yes\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!K$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!K$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!K$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!K$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!K$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!K$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!K$15,IF('Strain Pole 8 Input'!B$28=\"Yes\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!L$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!L$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!L$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!L$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!L$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!L$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!L$15,IF('Strain Pole 8 Input'!B$30=\"Yes\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!M$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!M$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!M$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!M$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!M$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!M$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!M$15,IF('Strain Pole 8 Input'!B$25=\"No\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!N$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!N$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!N$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!N$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!N$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!N$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!N$15,IF('Strain Pole 8 Input'!B$35=\"Yes\",\"X\",\"\"))))))))","v":""},{"$f":"IF('Strain Pole 8 Input'!B$8=Lists!A$19,RESULTS!O$9,IF('Strain Pole 8 Input'!B$8=Lists!A$20,RESULTS!O$10,IF('Strain Pole 8 Input'!B$8=Lists!A$21,RESULTS!O$11,IF('Strain Pole 8 Input'!B$8=Lists!A$22,RESULTS!O$12,IF('Strain Pole 8 Input'!B$8=Lists!A$23,RESULTS!O$13,IF('Strain Pole 8 Input'!B$8=Lists!A$24,RESULTS!O$14,IF('Strain Pole 8 Input'!B$8=Lists!A$25,RESULTS!O$15,IF('Strain Pole 8 Input'!B$39=\"Yes\",\"X\",\"\"))))))))","v":""}]
[null,"Strain Pole 9",{"$f":"'Strain Pole 9 Input'!C6","v":0},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!D$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!D$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!D$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!D$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!D$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!D$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!D$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!D$16,IF('Strain Pole 9 Input'!B$13=\"No\",\"X\",IF(AND(E$17:O$17=\"\",'Strain Pole 9 Input'!B$48=Lists!A$2),\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!E$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!E$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!E$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!E$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!E$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!E$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!E$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!E$16,IF('Strain Pole 9 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 9 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 9 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\")))))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!F$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!F$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!F$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!F$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!F$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!F$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!F$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!F$16,IF('Strain Pole 9 Input'!B$46=\"No\",\"X\",IF('Strain Pole 9 Input'!B$48=Lists!A$3,\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!G$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!G$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!G$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!G$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!G$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!G$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!G$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!G$16,IF('Strain Pole 9 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 9 Input'!B$36=\"Yes\",'Strain Pole 9 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 9 Input'!B$40=\"Yes\",'Strain Pole 9 Input'!B$41=\"Yes\"),\"X\",\"\")))))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!H$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!H$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!H$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!H$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!H$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!H$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!H$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!H$16,IF('Strain Pole 9 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 9 Input'!B$40=\"Yes\",'Strain Pole 9 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 9 Input'!B$46=\"No\",\"X\",\"\")))))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!H$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!H$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!H$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!H$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!H$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!H$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!H$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!H$16,IF('Strain Pole 9 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 9 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 9 Input'!B$46=\"No\",\"X\",\"\")))))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!J$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!J$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!J$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!J$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!J$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!J$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!J$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!J$16,IF('Strain Pole 9 Input'!B$29=\"Yes\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!K$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!K$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!K$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!K$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!K$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!K$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!K$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!K$16,IF('Strain Pole 9 Input'!B$28=\"Yes\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!L$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!L$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!L$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!L$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!L$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!L$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!L$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!L$16,IF('Strain Pole 9 Input'!B$30=\"Yes\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!M$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!M$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!M$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!M$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!M$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!M$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!M$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!M$16,IF('Strain Pole 9 Input'!B$25=\"No\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!N$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!N$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!N$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!N$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!N$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!N$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!N$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!N$16,IF('Strain Pole 9 Input'!B$35=\"Yes\",\"X\",\"\")))))))))","v":""},{"$f":"IF('Strain Pole 9 Input'!$B$8=Lists!$A$19,RESULTS!O$9,IF('Strain Pole 9 Input'!$B$8=Lists!$A$20,RESULTS!O$10,IF('Strain Pole 9 Input'!$B$8=Lists!$A$21,RESULTS!O$11,IF('Strain Pole 9 Input'!$B$8=Lists!$A$22,RESULTS!O$12,IF('Strain Pole 9 Input'!$B$8=Lists!$A$23,RESULTS!O$13,IF('Strain Pole 9 Input'!$B$8=Lists!$A$24,RESULTS!O$14,IF('Strain Pole 9 Input'!$B$8=Lists!$A$25,RESULTS!O$15,IF('Strain Pole 9 Input'!$B$8=Lists!$A$26,RESULTS!O$16,IF('Strain Pole 9 Input'!B$39=\"Yes\",\"X\",\"\")))))))))","v":""}]
[null,"Strain Pole 10",{"$f":"'Strain Pole 10 Input'!C6","v":0},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!D$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!D$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!D$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!D$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!D$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!D$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!D$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!D$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!D$17,IF('Strain Pole 10 Input'!B$13=\"No\",\"X\",IF(AND(E$18:O$18=\"\",'Strain Pole 10 Input'!B$48=Lists!A$2),\"X\",\"\")))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!E$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!E$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!E$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!E$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!E$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!E$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!E$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!E$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!E$17,IF('Strain Pole 10 Input'!B$17=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 10 Input'!B$24=\"Full Replacement Recommended\",\"X\",IF('Strain Pole 10 Input'!B$31=\"Full Replacement Recommended\",\"X\",\"\"))))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!F$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!F$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!F$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!F$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!F$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!F$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!F$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!F$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!F$17,IF('Strain Pole 10 Input'!B$46=\"No\",\"X\",IF('Strain Pole 10 Input'!B$48=Lists!A$3,\"X\",\"\")))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!G$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!G$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!G$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!G$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!G$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!G$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!G$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!G$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!G$17,IF('Strain Pole 10 Input'!B$28=\"Yes\",\"X\",IF(OR('Strain Pole 10 Input'!B$36=\"Yes\",'Strain Pole 10 Input'!B$37=\"Yes\"),\"X\",IF(OR('Strain Pole 10 Input'!B$40=\"Yes\",'Strain Pole 10 Input'!B$41=\"Yes\"),\"X\",\"\"))))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!H$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!H$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!H$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!H$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!H$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!H$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!H$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!H$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!H$17,IF('Strain Pole 10 Input'!B$21=\"Not Rated\",\"X\",IF(OR('Strain Pole 10 Input'!B$40=\"Yes\",'Strain Pole 10 Input'!B$41=\"Yes\"),\"X\",IF('Strain Pole 10 Input'!B$46=\"No\",\"X\",\"\"))))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!I$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!I$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!I$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!I$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!I$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!I$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!I$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!I$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!I$17,IF('Strain Pole 10 Input'!B$37=\"Yes\",\"X\",IF('Strain Pole 10 Input'!B$41=\"Yes\",\"X\",IF('Strain Pole 10 Input'!B$46=\"No\",\"X\",\"\"))))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!J$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!J$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!J$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!J$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!J$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!J$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!J$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!J$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!J$17,IF('Strain Pole 10 Input'!B$29=\"Yes\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!K$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!K$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!K$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!K$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!K$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!K$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!K$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!K$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!K$17,IF('Strain Pole 10 Input'!B$28=\"Yes\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!L$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!L$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!L$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!L$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!L$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!L$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!L$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!L$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!L$17,IF('Strain Pole 10 Input'!B$30=\"Yes\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!M$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!M$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!M$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!M$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!M$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!M$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!M$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!M$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!M$17,IF('Strain Pole 10 Input'!B$25=\"No\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!N$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!N$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!N$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!N$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!N$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!N$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!N$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!N$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!N$17,IF('Strain Pole 10 Input'!B$35=\"Yes\",\"X\",\"\"))))))))))","v":""},{"$f":"IF('Strain Pole 10 Input'!$B$8=Lists!$A$19,RESULTS!O$9,IF('Strain Pole 10 Input'!$B$8=Lists!$A$20,RESULTS!O$10,IF('Strain Pole 10 Input'!$B$8=Lists!$A$21,RESULTS!O$11,IF('Strain Pole 10 Input'!$B$8=Lists!$A$22,RESULTS!O$12,IF('Strain Pole 10 Input'!$B$8=Lists!$A$23,RESULTS!O$13,IF('Strain Pole 10 Input'!$B$8=Lists!$A$24,RESULTS!O$14,IF('Strain Pole 10 Input'!$B$8=Lists!$A$25,RESULTS!O$15,IF('Strain Pole 10 Input'!$B$8=Lists!$A$26,RESULTS!O$16,IF('Strain Pole 10 Input'!$B$8=Lists!$A$27,RESULTS!O$17,IF('Strain Pole 10 Input'!B$39=\"Yes\",\"X\",\"\"))))))))))","v":""}]

{"sheet":"Equipment Loading","index":15,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":true,"merged":[[40,0,40,6],[0,6,1,6],[0,7,1,7],[0,8,0,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5]]}
["Code","Description","Comment/Detail","Code","Weight***\n(lbs)","Trans Area\n(sft)","Par Area\n(sft)","Bot Area\n(sft)","Height**",null,"Width\n(ft)","Depth\n(ft)","Unit Cost ($/each)"]
[null,null,null,null,null,null,null,null,"inches","feet"]
[]
["1W-1C",null,null,null,17,1.36,1.49,1.53,14,{"$f":"I4/12","v":1.1666666666666667},{"$f":"F4/J4","v":1.1657142857142857},{"$f":"H4/J4","v":1.3114285714285714}]
["1W-1C w/BP",null,null,null,21,4,1.59,1.53,24,2,2,0.76500000000000001,1000]
["1W-1C w/CS",null,null,null,49,3.61,2.15,2.25,{"$f":"I4+12","v":26},2.1666666666666665,1.6661538461538463,1.0384615384615385]
["1W-1C w/CS w/BP",null,null,null,53,6.25,2.2599999999999998,2.25,{"$f":"I5+12","v":36},3,2.0833333333333335,0.75,1200]
["1W-2C PED",null,null,null,27,2.72,3.97,1.53,28,2.3333333333333335,1.1657142857142857,0.65571428571428569]
["1W-2C PED w/BP",null,null,null,32,6.33,4.1399999999999997,1.53,38,3.1666666666666665,1.9989473684210528,0.48315789473684212,100]
["1W-2C PED w/CS",null,null,null,59,4.97,4.6399999999999997,2.25,{"$f":"I8+12","v":40},3.3333333333333335,1.4909999999999999,0.67499999999999993,100]
["1W-2C PED w/ CS w/BP",null,null,null,64,8.58,4.8,2.25,{"$f":"I9+12","v":50},4.166666666666667,2.0591999999999997,0.53999999999999992,100]
["1W-3C",null,null,null,37,4.08,4.46,1.53,42,3.5,1.1657142857142857,0.43714285714285717,100]
["1W-3C w/BP",null,null,null,43,8.67,4.68,1.53,52,4.333333333333333,2.0007692307692309,0.35307692307692312,100]
["1W-3C w/CS",null,null,null,69,6.33,5.125,2.25,{"$f":"I12+12","v":54},4.5,1.4066666666666667,0.5,100]
["1W-3C w/CS w/BP",null,null,null,75,10.92,5.35,2.25,{"$f":"I13+12","v":64},5.333333333333333,2.0475000000000003,0.421875,100]
["1W-4C",null,null,null,43,5.44,5.94,1.53,56,4.666666666666667,1.1657142857142857,0.32785714285714285,100]
["1W-4C w/BP",null,null,null,50,11,6.23,1.53,66,5.5,2,0.2781818181818182,100]
["1W-4C w/CS",null,null,null,75,7.69,6.61,2.25,{"$f":"I16+12","v":68},5.666666666666667,1.3570588235294119,0.39705882352941174,100]
["1W-4C w/CS w/BP",null,null,null,82,13.25,6.9,2.25,{"$f":"I17+12","v":78},6.5,2.0384615384615383,0.34615384615384615,100]
["1W-5C (doghouse)",null,null,null,61,6.81,4.46,3.02,42,3.5,1.9457142857142855,0.86285714285714288,100]
["1W-5C (doghouse) w/BP",null,null,null,69,13.72,4.68,3.02,52,4.333333333333333,3.1661538461538465,0.69692307692307698,100]
["1W-5C (doghouse) w/CS",null,null,null,93,9.06,5.125,3.02,{"$f":"I20+12","v":54},4.5,2.0133333333333336,0.6711111111111111,100]
["1W-5C (doghouse) w/CS w/BP",null,null,null,101,15.97,5.35,3.02,{"$f":"I21+12","v":64},5.333333333333333,2.9943750000000002,0.56625000000000003,100]
["1W 12x27 Non-iLL CS",null,null,null,32,2.25,0.67,1.5,12,1,2.25,{"$f":"H24/K24","v":0.66666666666666663},100]
["1W 24x30 Non-iLL CS",null,null,null,45,5,1.33,1.67,24,2,2.5,0.66799999999999993,100]
["1W 24x96 Street Name Sign ",null,null,null,90,14.93,1.29,3.93,24,2,7.4649999999999999,0.52645679839249837,100]
["1W 36x36 Non-iLL CS",null,null,null,63.909090909090914,9,2,2,36,3,3,0.66666666666666663,100]
["1W 12x27 LED CS",null,null,null,41.92,2.25,0.67,1.5,12,1,2.25,0.66666666666666663,100]
["1W 24x30 LED CS",null,null,null,58.95,5,1.33,1.67,24,2,2.5,0.66799999999999993,100]
["1W 36x36 LED CS",null,null,null,83.720909090909103,9,2,2,36,3,3,0.66666666666666663,100]
["Pole Mounted Ped Signal",null,null,null,25,1.778,0.88900000000000001,null,null,null,null,null,100]
["Antenna",null,null,null,20,0.09,{"$f":"F32","v":0.09},{"$f":"K32*L32","v":6.9444444444444441E-3},12.96,{"$f":"I32/12","v":1.08},{"$f":"1/12","v":8.3333333333333329E-2},{"$f":"1/12","v":8.3333333333333329E-2},100]
["GPM Module",null,null,null,30,0.75,{"$f":"F33","v":0.75},{"$f":"F33","v":0.75},10.392304845413264,{"$f":"I33/12","v":0.86602540378443871},{"$f":"SQRT($F$33)","v":0.8660254037844386},{"$f":"SQRT($F$33)","v":0.8660254037844386},100]
["Hemispherical Video Detection",null,null,null,22.4,2.11,2.11,2.02,30,{"$f":"I34/12","v":2.5},1.42,1.42,100]
["Microwave Vehicle Detector",null,null,null,4.2,0.97,{"$f":"F35","v":0.97},{"$f":"F35","v":0.97},11.830807242111588,{"$f":"I35/12","v":0.98590060350929898},{"$f":"SQRT($F$35)","v":0.98488578017961048},{"$f":"SQRT($F$35)","v":0.98488578017961048},100]
["Radar Vehicle Detector",null,null,null,4.2,0.97,{"$f":"F36","v":0.97},{"$f":"F36","v":0.97},11.830807242111588,{"$f":"I36/12","v":0.98590060350929898},{"$f":"SQRT($F$35)","v":0.98488578017961048},{"$f":"SQRT($F$35)","v":0.98488578017961048},100]
[]
[]
[]
[]
["Strain Pole Loading Table*"]
["Span Length","Weight of Generalized Load (lbs)**","Weight of Generalized Load w/ BP (lbs)**","Perp. Wind Area w/o BP (sft)**","Par. Wind Area w/o BP (sft)**","Perp. Wind Area w/ BP (sft)**","Par. Wind Area w/ BP (sft)**"]
["up to 100 ft",151.84,170.56,14.105,13.65,26.39,14.56]
["101 ft to 120 ft",151.84,170.56,14.105,13.65,26.39,14.56]
["121 ft to 150 ft",151.84,170.56,14.105,13.65,26.39,14.56]
["*As Developed from analysis cases run in the 2010 Report + MDOT provided examples."]
["**Weights and Areas include allowance for signals, signs and anything else carried by the cables."]

{"sheet":"Lists","index":16,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
["Yes"]
["No"]
[]
["Yes"]
["No"]
["Unknown"]
[]
["Yes"]
["No"]
["Not Rated"]
[]
["2023 Statewide Special Details"]
["6-Bolt Pole"]
["4-Bolt Pole"]
[]
["Yes"]
["No"]
["Pole 1"]
["Pole 2"]
["Pole 3"]
["Pole 4"]
["Pole 5"]
["Pole 6"]
["Pole 7"]
["Pole 8"]
["Pole 9"]
[]
[]
[{"$f":"CONCATENATE(\"'\",RESULTS!B9,\" Input'!B$2=Lists!A$20\")","v":"'Strain Pole 1 Input'!B$2=Lists!A$20"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B10,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 2 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B11,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 3 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B12,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 4 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B13,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 5 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B14,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 6 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B15,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 7 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B16,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 8 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B17,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 9 Input'!B$2=Lists!A$"}]
[{"$f":"CONCATENATE(\"'\",RESULTS!B18,\" Input'!B$2=Lists!A$\")","v":"'Strain Pole 10 Input'!B$2=Lists!A$"}]