{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Menu Sheet","Rigging Plan","Site Layout","Type 1","Type 2","Type 3","Angle Chart","Face Block Mount","Equipment","Contacts","Rope Chart","Extra Sequence Sheet","Rigging requirements","Credits","Sheet2","Sheet1"],"not_rendered":{"charts":1,"images":15,"macros":1,"external_links":0,"defined_names":12,"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":"Menu Sheet","index":0,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,8,18,9],[35,26,37,30],[8,8,8,9],[9,10,9,12],[10,10,10,12],[23,16,23,17],[23,18,23,19],[23,20,23,21],[22,16,22,17],[22,18,22,19],[17,4,17,6],[14,4,14,6],[11,10,11,12],[12,10,12,12],[13,10,13,12],[17,8,17,9],[17,10,17,12],[12,8,12,9],[13,8,13,9],[14,8,14,9],[16,8,16,9],[53,1,54,13],[11,4,11,6],[9,4,9,6],[16,10,16,12],[14,10,14,12],[21,10,21,12],[18,10,18,12],[19,10,19,12],[20,10,20,12],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,4,12,6],[13,4,13,6],[10,4,10,6],[19,8,19,9],[5,26,6,30],[15,8,15,9],[15,10,15,12],[0,1,0,7],[1,1,1,7],[2,2,2,4],[2,11,2,13],[3,2,3,4],[3,11,3,13],[4,2,4,4],[4,5,4,9],[4,11,4,13],[8,4,8,6],[8,10,8,12],[7,10,7,12],[7,26,34,30]]}
[]
[]
[null,"Contact","Gordon Lyman",null,null,null,null,null,null,null,null,"Bill Griswold"]
[null,"Email","gl@esystemtraining.com ",null,null,null,null,null,null,null,null,"BillGriswold@Live.com"]
[null,"Mobile No"," (210) 410-2091",null,null,"Project Setup Menu",null,null,null,null,null,"(704) 906-9113"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Directions"]
[null,null,null,null,null,"Note: Fields in","Blue","are for input.",null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,"Project Information:",null,null,null,null,null,"Contractor Info:",null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,"1 - Put the Project Information and the Contractor\n     Information into the appropiate cells to the left.\n     This information will appear in the \"Rigging Plan\".\n2 - The Lats and Longs can either be input as Degrees,\n      Minutes and Seconds, or in decimal format in\n      the Degree input cell.  If input in decimal format\n      the numbers in the Min and Sec cells are ignored.\n3 - To ensure the total load lift is attained, the \n      actual load goes into the \"Lifted Load\" cell  and \n      the rigging accessories and overhaul ball go into \n      the \"Ball & Rigging\" cell.\n4 - The weight of the cables and the friction in the\n      sheaves are automatically calculated and \n      included in the forces.\n5 - It is critical that the equipment tab be filled out \n      with your equipment and capacities, then make\n      your selections (See the Equipment Tab for Listing)\n6 - Select the Type of Rigging Scheme (1, 2, or 3) \n      or the Angle Finder by pressing the button \n      under the picture.\n7 - On the Rigging Type Sheet Select the Tower Type\n      and fill in the dimension blocks outlined in BLUE.\n      All of the loading and equipment information\n      will appear on all 3 Lift Types.\n8 - On the Type I and Type III Lift Types you may \n      select either 1, 2 or 3 line parts between the \n      Crown Block and the Load.\n9 - The buttons provide easy navigation between\n      the different sheets of this spreadsheet.\n10 - For further instructions see the \"Rigging Plan\",\n     \"Face Block Mount\" and \"Equipment\" tabs."]
[null,"Date: mm/dd",null,null,null,null,null,null,"Company:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K19,Equipment!B27:C38,2,FALSE)","v":1000}]
[null,"Client Name:",null,null,null,null,null,null,"Address:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K20,Equipment!B27:C38,2,FALSE)","v":1000}]
[null,"Client Job No.:",null,null,null,null,null,null,"City, State, Zip:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K21,Equipment!B11:C22,2,FALSE)","v":770}]
[null,"Site Name:",null,null,null,null,null,null,"Company Contact:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K22,Equipment!B11:C22,2,FALSE)","v":200}]
[null,"Site No.:",null,null,null,null,null,null,"Contact Phone:",null,{"$f":"IF(K12=\"\",\"\",VLOOKUP(K12,Contacts!F4:G12,2,FALSE))","v":""}]
[null,"Site Address:",null,null,null,null,null,null,"Competent Rigger:"]
[null,"Site City, State, Zip:",null,null,null,null,null,null,"Company Job No:"]
[null,"Site Lat: Deg, Min, Sec",null,null,null,null,null,null,"Rigging Plan No.:",null,null,null,null,null,null,null,null,null,{"$f":"INT(E16)","v":0},{"$f":"INT((E16 - S16)*60) + IF(INT(E16)<E16,0,F16)","v":0},{"$f":"ROUND(((E16*60) - INT((E16)*60))*60 + IF(INT(E16)<E16,0,G16),2)","v":0}]
[null,"Site Long: Deg, Min, Sec",null,null,null,null,null,null,"Lifted Load (lbs):",null,null,null,null,null,null,null,null,{"$f":"ABS(E17)","v":0},{"$f":"-INT(R17)","v":0},{"$f":"INT((R17 + S17)*60) + IF(INT(E17)<E17,0,F17)","v":0},{"$f":"ROUND(((R17*60) - INT((R17)*60))*60 + IF(INT(E17)<E17,0,G17),2)","v":0}]
[null,"Force to Class IV",null,null,"No",null,null,null,"Ball & Rigging (lbs):",null,null,null,null,null,null,null,{"$f":"VLOOKUP(K19,Equipment!O26:P37,2,FALSE)","v":1.02}]
[null,null,null,null,null,null,null,null,"Crown Block",null,"Block 1 - 1000",null,null,null,null,null,{"$f":"VLOOKUP(K20,Equipment!O26:P37,2,FALSE)","v":1.02}]
[null,null,null,null,null,null,null,null,"Heel Block",null,"Block 1 - 1000",null,null,null,null,null,{"$f":"VLOOKUP(K21,Equipment!O11:Q22,3,FALSE)","v":0.08}]
[null,null,null,null,null,null,null,null,"Lift Hoist",null,"Capstan - 770",null,null,null,null,{"$f":"VLOOKUP(K21,Equipment!O11:R22,4,FALSE)","v":"Synthetic"},{"$f":"VLOOKUP(K22,Equipment!O11:Q22,3,FALSE)","v":0.08}]
[null,null,null,null,null,null,null,null,"Tag Hoist",null,"Hand",null,null,null,null,{"$f":"VLOOKUP(K22,Equipment!O11:R22,4,FALSE)","v":"Synthetic"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K14","v":0},null,{"$f":"VLOOKUP(Q24,Contacts!B4:D12,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(Q24,Contacts!B4:D12,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If a Drop Down type cell is not working correctly\nRight Mouse Click on the Cell to Activate it."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer:  The information and calculations provided by this document have been developed by a reliable source in compliance with industry standards and are believed to be correct. This information should not be relied upon for a specific application without competent professional examination and verification of its accuracy, suitability, and applicability.  This document may not be adaptable to all situations and should be used at your own risk."]
[]
[null,{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"},null,null,null,null,null,null,null,null,null,null,null,"Developed by Griswold Tower Software, PC"]

{"sheet":"Rigging Plan","index":1,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[42,18,43,18],[0,5,0,9],[1,5,1,9],[2,5,2,9],[3,5,3,9],[4,5,4,9],[10,13,10,14],[21,12,21,13],[20,12,20,14],[17,6,17,7],[16,8,16,9],[17,8,17,9],[15,8,15,9],[5,0,5,6],[42,12,43,12],[42,15,43,15],[42,13,43,13],[42,14,43,14],[42,16,43,16],[42,17,43,17],[19,0,19,9],[20,0,20,1],[41,4,41,5],[5,7,5,9],[18,2,18,3],[16,0,16,2],[17,0,17,2],[15,0,15,2],[9,0,10,1],[12,0,12,1],[10,5,10,6],[11,5,11,6],[10,7,10,9],[11,7,11,9],[16,3,16,5],[17,3,17,5],[16,6,16,7],[10,2,10,4],[11,2,11,4],[9,5,9,6],[9,7,9,9],[9,2,9,4],[12,5,12,6],[11,0,11,1],[12,2,12,4],[12,7,12,9],[14,0,14,2],[15,3,15,5],[6,0,6,9],[7,0,7,1],[8,0,8,1],[7,5,7,6],[8,5,8,6],[7,7,7,9],[8,7,8,9],[7,2,7,4],[8,2,8,4],[24,12,24,13],[12,11,12,12],[29,0,29,3],[58,0,58,9],[44,0,44,1],[44,3,44,4],[44,6,44,8],[46,0,46,9],[45,0,45,1],[45,3,45,4],[45,6,45,8],[30,0,30,9],[35,0,35,1],[32,0,32,1],[36,0,36,1],[37,0,37,1],[35,3,35,4],[36,3,36,4],[37,3,37,4],[35,6,35,8],[36,6,36,8],[37,6,37,8],[43,6,43,8],[47,0,47,1],[59,0,59,9],[51,0,51,9],[52,0,52,1],[53,0,53,1],[52,3,52,4],[53,3,53,4],[52,6,52,8],[53,6,53,8],[56,0,56,9],[57,0,57,9],[54,0,54,9],[55,0,55,9],[21,8,21,9],[31,0,31,1],[47,3,47,4],[48,4,48,5],[48,7,48,9],[29,5,29,6],[29,7,29,8],[22,0,22,9],[23,0,23,3],[23,5,23,8],[47,6,47,8],[33,0,33,1],[40,0,40,9],[38,0,38,1],[43,0,43,1],[43,3,43,4],[13,2,13,3],[14,8,14,9],[14,6,14,7],[14,3,14,5],[15,6,15,7],[21,2,21,3],[25,0,25,3],[24,0,24,3],[38,3,38,4],[38,6,38,8],[28,0,28,3],[26,0,26,3],[24,5,24,8],[25,5,25,8],[26,5,26,8],[18,0,18,1],[18,4,18,9],[21,0,21,1],[20,2,20,4],[20,5,20,7],[21,5,21,7],[20,8,20,9],[33,7,33,8],[31,3,31,5],[29,12,29,13],[29,14,29,15],[29,16,29,17],[30,12,30,13],[30,14,30,15],[30,16,30,17],[0,19,8,21],[61,2,63,7],[61,0,63,1],[61,8,63,9],[0,0,4,4],[32,3,32,5],[33,3,33,5],[32,7,32,8],[31,7,31,8],[39,0,39,1],[39,3,39,4],[39,6,39,8],[60,0,60,9],[41,2,41,3],[34,0,34,9],[49,0,49,9],[50,0,50,9],[42,0,42,9]]}
["Paste Logo\nfrom PowerPoint\nInto this Location",null,null,null,null,{"$f":"'Menu Sheet'!K9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"To put your logo on the Rigging Plan Page, first copy the Logo into PowerPoint.  Press the \"Unlock for Logo Placement\" button.  Then Copy your Logo from PowerPoint and Paste it into the space provided in the Upper Left Corner of this sheet.  Finally, press the \"Relock after Logo Placement\" button."]
[null,null,null,null,null,{"$f":"'Menu Sheet'!K10","v":0}]
[null,null,null,null,null,{"$f":"'Menu Sheet'!K11","v":0}]
[null,null,null,null,null,{"$f":"\"Contact - \"&'Menu Sheet'!K12","v":"Contact - "}]
[null,null,null,null,null,{"$f":"'Menu Sheet'!K13","v":""}]
[{"$f":"\"Rigging Plan No. \"&'Menu Sheet'!K16","v":"Rigging Plan No. "},null,null,null,null,null,null,"Color of All Input Fields"]
["Project Information"]
["Site Name",null,{"$f":"'Menu Sheet'!E12","v":0},null,null,"Date",null,{"$f":"'Menu Sheet'!E9","v":"00:00:00"}]
["Site Number",null,{"$f":"'Menu Sheet'!E13","v":0},null,null,"Customer",null,{"$f":"IF('Menu Sheet'!E10=\"\",\"\",'Menu Sheet'!E10)","v":""},null,null,null,null,null,null,null,"Class I"]
["Site Address",null,{"$f":"'Menu Sheet'!E14","v":0},null,null,"Customer Project #",null,{"$f":"IF('Menu Sheet'!E11=\"\",\"\",'Menu Sheet'!E11)","v":""},null,null,null,null,null,null,null,"Class II"]
[null,null,{"$f":"'Menu Sheet'!E15","v":0},null,null,"Latitude",null,{"$f":"'Menu Sheet'!S16&\" Deg \"&'Menu Sheet'!T16&\" Min \"&'Menu Sheet'!U16&\" Sec\"","v":"0 Deg 0 Min 0 Sec"},null,null,null,null,null,"Engr May Be Req'd",null,"Class III"]
["Project Number",null,{"$f":"'Menu Sheet'!K15","v":0},null,null,"Longitude",null,{"$f":"'Menu Sheet'!S17&\" Deg \"&'Menu Sheet'!T17&\" Min \"&'Menu Sheet'!U17&\" Sec\"","v":"0 Deg 0 Min 0 Sec"},null,null,null,null,null,"E27",{"$f":"IF(E27=\"X\",1,0)","v":0},"Class IV"]
["Rigging Plan Class",null,{"$f":"IF('Menu Sheet'!E18=\"YES\",\"Class IV\",IF(M20>0,\"Class IV\",M24))","v":"Class I"},null,null,"Gross Load (lbs)",null,{"$f":"IF(C42=\"Type I\",Q23,IF(C42=\"Type II\",Q24,Q25))","v":55.074311989685356},null,null,null,"Engr Req'd",null,"E24",{"$f":"IF(E24=\"X\",1,0)","v":0}]
[null,null,null,null,"Lbs.",null,null,null,null,null,null,null,{"$f":"IF(E31=\"X\",1,0)","v":0}]
["Persons Responsible",null,null,"Name",null,null,"Company",null,"Phone",null," ","E26",{"$f":"IF(E26=\"X\",1,0)","v":0},"E29",{"$f":"IF(E29=\"X\",1,0)","v":0},"Monopole"]
["Competent Rigger",null,null,{"$f":"IF('Menu Sheet'!K14=\"\",\"\",'Menu Sheet'!K14)","v":""},null,null,{"$f":"IF(D16=\"\",\"\",'Menu Sheet'!S24)","v":""},null,{"$f":"IF(D16=\"\",\"\",'Menu Sheet'!U24)","v":""},null,null,null,null,"E30",{"$f":"IF(E30=\"X\",1,0)","v":0},"Self Support"]
[{"$f":"\"Qualified Person \"&M25","v":"Qualified Person Not Req'd"},null,null,null,null,null,{"$f":"IF(D17=\"\",\"\",O30)","v":""},null,{"$f":"IF(D17=\"\",\"\",Q30)","v":""},null,null,"G33",{"$f":"IF(G33=\"X\",1,0)","v":0},"J26",{"$f":"IF(J26=\"X\",1,0)","v":0},"Guyed "]
[{"$f":"\"Qualified Engr \"&M21","v":"Qualified Engr Not Req'd"},null,null,null,null,null,{"$f":"IF(D18=\"\",\"\",O31)","v":""},null,{"$f":"IF(D18=\"\",\"\",Q31)","v":""},null,null,"J48",{"$f":"IF(J48=\"X\",1,0)","v":0},"J27",{"$f":"IF(J27=\"X\",1,0)","v":0},"Roof Top"]
["Type of Structure",null,{"$f":"IF(C42=\"Type I\",R23,IF(C42=\"Type II\",R24,R25))","v":"Self Support Tower"},null,null,null,null,null,null,null,null,"H13",{"$f":"IF(H13>2000,1,0)","v":0},"G32",{"$f":"IF(G32=\"X\",1,0)","v":0},"Other"]
["Structure Data",null,null,null,null,null,null,null,null,null,null,"SUM",{"$f":"SUM(M15:M19)","v":0},"SUM",{"$f":"SUM(O12:O19)","v":0}]
["Manufacturer",null,null,null,null,"Height (AGL) feet",null,null,null,null,null,"Engr",{"$f":"IF('Menu Sheet'!E18=\"YES\",\"Req'd\",IF(M24=\"Class IV\",\"Req'd\",IF(M20>0,\"Req'd\",IF(O20>0,\"May Be Req'd\",\"Not Req'd\"))))","v":"Not Req'd"},null,null,"X"]
["Face width @ base",null,null,null,"(feet)","Typical section length (feet)"]
["General Scope of Work (check all that apply)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type I",{"$f":"'Type 1'!G17","v":55.074311989685356},{"$f":"'Type 1'!G18","v":"Self Support Tower"}]
[{"$f":"\"Install new structure \"&IF(M21=\"Req'd\",\"\",IF(E24=\"X\",\"- Engr May Be Req'd\",\"\"))","v":"Install new structure "},null,null,null,null,"Add or remove antennas",null,null,null,null,null,"Weight",{"$f":"IF(H13<351,\"Class I\",IF(H13<501,\"Class II\",IF(H13<2001,\"Class III\",\"Class IV\")))","v":"Class I"},null,null,"Type II",{"$f":"'Type 2'!E17","v":17.03858022254202},{"$f":"'Type 2'!E18","v":"Self Support Tower"}]
["Add or remove coax or cables",null,null,null,null,"Add or remove mounts",null,null,null,null,null,"Person",{"$f":"IF('Menu Sheet'!E18=\"YES\",\"Req'd\",IF(M24=\"Class IV\",\"Req'd\",IF(M24=\"Class III\",\"Req'd\",IF(M20>0,\"Req'd\",IF(O20>0,\"May Be Req'd\",\"Not Req'd\")))))","v":"Not Req'd"},null,null,"Type III",{"$f":"'Type 3'!E17","v":66.876664420673066},{"$f":"'Type 3'!E18","v":"Self Support Tower"}]
["Replace structural members",null,null,null,null,{"$f":"\"Add Reinforcing \"&IF(M21=\"Req'd\",\"\",IF(J26=\"X\",\"- Engr May Be Req'd\",\"\"))","v":"Add Reinforcing "},null,null,null,null,null,null,null,null,null,"Other"]
[{"$f":"\"Replace Guy Wires \"&IF(M21=\"Req'd\",\"\",IF(E27=\"X\",\"- Engr May Be Req'd\",\"\"))","v":"Replace Guy Wires "},null,null,null,null,{"$f":"\"Cutting - Welding \"&IF(M21=\"Req'd\",\"\",IF(J27=\"X\",\"- Engr May Be Req'd\",\"\"))","v":"Cutting - Welding "}]
["Install new foundations",null,null,null,null,"Install mounts/antennas and lines",null,null,null,null,null,null,{"$f":"IF(C13=\"Class IV\",\"FALSE\",IF(E24=\"\",\"FALSE\",\"TRUE\"))","v":"FALSE"}]
[{"$f":"\"Modify Foundations \"&IF(M21=\"Req'd\",\"\",IF(E29=\"X\",\"- Engr May Be Req'd\",\"\"))","v":"Modify Foundations "},null,null,null,null,"Remove mounts/antennas and lines"]
[{"$f":"\"Change Bolts \"&IF(M21=\"Req'd\",\"\",IF(E30=\"X\",\"- Engr May Be Req'd\",\"\"))","v":"Change Bolts "},null,null,null,null,"Other Specify",null,null,null,null,null,null,{"$f":"D17","v":0},null,{"$f":"VLOOKUP(M30,Contacts!B16:D24,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(M30,Contacts!B16:D24,3,FALSE)","v":{"$error":"#N/A"}}]
["Project Primary Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"D18","v":0},null,{"$f":"VLOOKUP(M31,Contacts!B28:D36,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(M31,Contacts!B28:D36,3,FALSE)","v":{"$error":"#N/A"}}]
["Main Hoist",null,null,{"$f":"\"Gin Pole\"&IF(M21=\"Req'd\",\"\",IF(G32=\"X\",\"/ Engr May Be Req'd\",\"\"))","v":"Gin Pole"},null,null,null,"(Other Equip)"]
["Tag Hoist",null,null,"Tower Crane",null,null,null,"(Other Equip)"]
["Guy Pull Hoist",null,null,"Capstan Hoist",null,null,null,"(Other Equip)"]
["Project Rigging Equipment"]
["Tirfors",null,null,"Shackles",null,null,"Blocks"]
["Transit/Theodolite",null,null,"Hooks",null,null,"Inline Overhaul Ball"]
["Tension Meter",null,null,"Tag Rope",null,null,{"$f":"IF(J37=\"X\",\"Ball Weight-lbs\",\"\")","v":""}]
["Load Rope",null,null,"IWRC Slings",null,null,"Counter Weight Overhaul Ball"]
["Preforms",null,null,"Synthethic Slings",null,null,{"$f":"IF(J39=\"X\",\"Ball Weight-lbs\",\"\")","v":""}]
["Lift and Tag Method"]
[null,"Lift Type ","Type I",null,"No. of Parts ",null,{"$f":"IF(C42=\"Type I\",S45,IF(C42=\"Type II\",S46,IF(C42=\"Type III\",S47,\"\")))","v":1}]
["Load Lifting Material and Capacity",null,null,null,null,null,null,null,null,null,null,null,"Crown\nBlock Load","Crown Vertical","Crown Horizontal","Heel\nBlock Load","Tag Load","Hoist Load","No. of \nLine Parts"]
["IWRC",null,null,"KernMantle Rope",null,null,"Double Braid Rope",null,null,null,null,"Type"]
["IWRC WLL",null,null,"KernMantle WLL",null,null,"Double Braid WLL",null,null,null,null,"Type 1",{"$f":"'Type 1'!J25","v":140.90403631180703},{"$f":"'Type 1'!Q26","v":139.06136088829783},{"$f":"'Type 1'!Q24","v":22.713109801469827},null,{"$f":"'Type 1'!P42","v":18.274268779600828},{"$f":"'Type 1'!M37","v":70.452389478782649},{"$f":"'Type 1'!G19","v":1}]
["Block",null,null,"Slings",null,null,"Shackles",null,null,null,null,"Type 2",{"$f":"'Type 2'!G24","v":35.497042130295867},{"$f":"'Type 2'!K22","v":34.07716044508404},{"$f":"'Type 2'!K20","v":10.199999999999999},null,null,{"$f":"'Type 2'!Q44","v":17.03858022254202},1]
["Type of Lift",null,null,null,null,null,null,null,null,null,null,"Type 3",{"$f":"'Type 3'!F23","v":150.61346752183525},{"$f":"'Type 3'!M25","v":150.5664815508959},{"$f":"'Type 3'!M23","v":3.7618123736628593},{"$f":"'Type 3'!E49","v":106.51695098578115},{"$f":"'Type 3'!J41","v":9.166998480838469},{"$f":"'Type 3'!F46","v":75.330234077638721},{"$f":"'Type 3'!E19","v":1}]
["Regular",null,"X","Personnel",null,null,"Special Engineered Lift",null,null,null,null,"Other"]
[{"$f":"H8","v":"00:00:00"},"Job No.",{"$f":"C12","v":0},"Site: ",{"$f":"C8","v":0},null,{"$f":"IF('Menu Sheet'!E10=\"\",\"\",\"Client:\")","v":""},{"$f":"H9","v":""}]
[" Scope/Description of Work"]
[]
["Loads from Calculation Forms"]
["Gross Load Weight",null,{"$f":"H13","v":55.074311989685356},"Tag Force or Load",null,{"$f":"IF(C42=\"Type I\",Q45,IF(C42=\"Type III\",Q47,\"\"))","v":18.274268779600828},"Crown Block Vertical Load",null,null,{"$f":"IF(C42=\"Type I\",N45,IF(C42=\"Type II\",N46,IF(C42=\"Type III\",N47,\"\")))","v":139.06136088829783}]
[{"$f":"IF(C42=\"Type III\",\"Heel Block Load\",\"\")","v":""},null,{"$f":"IF(C42=\"Type III\",'Type 3'!E49,\"\")","v":""},"Hoist Line Pull",null,{"$f":"IF(C42=\"Type I\",R45,IF(C42=\"Type II\",R46,IF(C42=\"Type III\",R47,\"\")))","v":70.452389478782649},"Crown Block Horizontal Load",null,null,{"$f":"IF(C42=\"Type I\",O45,IF(C42=\"Type II\",O46,IF(C42=\"Type III\",O47,\"\")))","v":22.713109801469827}]
[" General Information"]
[]
[" Description of Work Sequence - Use \"Extra Sequence Sheet\" if necessary"]
[]
["Description of  Reinforcing Sequence - Use \"Extra Sequence Sheet\" if necessary"]
[]
["Competent Rigger Signature"]
[]
[]
[]
[{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"}]

{"sheet":"Site Layout","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Type 1","index":3,"n_rows":60,"n_cols":35,"rows_kept":60,"cut":false,"hidden":false,"merged":[[12,6,12,14],[6,17,6,18],[57,1,58,23],[24,9,24,10],[47,27,47,28],[38,2,40,2],[44,12,44,13],[51,21,51,22],[47,21,47,22],[42,21,42,22],[45,12,45,13],[50,11,50,12],[41,15,41,16],[28,13,28,14],[25,9,26,12],[48,27,48,28],[54,1,56,23],[23,16,23,18],[39,7,39,8],[36,12,36,13],[30,14,32,19],[36,15,39,20],[25,16,25,18],[28,11,28,12],[25,22,27,22],[48,11,48,12],[50,17,50,18],[47,18,47,19],[42,8,42,9],[37,12,38,14],[42,19,42,20],[7,6,7,14],[8,6,8,14],[9,6,9,14],[10,6,10,14],[11,6,11,14],[22,14,22,19],[24,14,24,19],[13,16,19,20],[21,14,21,19],[13,6,13,14],[14,6,14,14],[15,6,15,14],[16,6,16,14],[17,6,17,14],[18,6,18,14]]}
[]
[]
[null,"Contact",null,null,"Gordon Lyman",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill Griswold"]
[null,"Email",null,"gl@esystemtraining.com ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BillGriswold@Live.com"]
[null,"Mobile No",null,null," (210) 410-2091",null,null,null,null,null,null,null,null,"Crown Block Only with Straight Tag",null,null,null,null,null,null,null,null,"(704) 906-9113"]
[]
[null,null,null,null,null,null,"Job Information:",null,null,null,null,null,null,null,null,null,"Note: Fields in ","Blue",null," are for input.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monopole Tower"]
[null,"Date:",null,null,null,null,{"$f":"'Menu Sheet'!E9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self Support Tower"]
[null,"Contractor:",null,null,null,null,{"$f":"'Menu Sheet'!K9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guyed Tower"]
[null,"Job No.:",null,null,null,null,{"$f":"'Menu Sheet'!K15","v":0}]
[null,"Competent Rigger:",null,null,null,null,{"$f":"'Menu Sheet'!K14","v":0}]
[null,"Client Name:",null,null,null,null,{"$f":"'Menu Sheet'!E10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Site Name:",null,null,null,null,{"$f":"'Menu Sheet'!E12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Site No.:",null,null,null,null,{"$f":"'Menu Sheet'!E13","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AB24>AB37,\"WARNING - LOAD ANGLE EXCEEDS MAXIMUM!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,3]
[null,"Lifted Load (lbs):",null,null,null,null,{"$f":"'Menu Sheet'!K17 + 'Menu Sheet'!K18","v":0}]
[null,"Lines + Friction (lbs):",null,null,null,null,{"$f":"('Menu Sheet'!K17 + 'Menu Sheet'!K18 + AD43)*(AB45-1) + AD43","v":55.074311989685356}]
[null,"Total Load (lbs):",null,null,null,null,{"$f":"G15+G16","v":55.074311989685356}]
[null,"Tower Type:",null,null,null,null,"Self Support Tower"]
[null,"Number of Parts:",null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes to Engineer",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U19=\"Angle\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"'Menu Sheet'!K19","v":"Block 1 - 1000"},null,null,null,null,null,"Max Horizontal Load on"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tower ",{"$f":"AB30+AB32","v":22.713109801469827},null,null,"lbs.",null,null,null,null,null,null,"Alpha = ",{"$f":"ATAN(H40/(W26-C39))*180/PI()","v":9.0902769208223226},"Lift Angle"]
[null,null,null,null,null,null,null,null,null,{"$f":"AB36","v":140.90403631180703},null," lbs.",null,null,"Max Vertical Load on",null,null,null,null,null,null,null,"ft.",null,null,null,"Beta = ",{"$f":"ATAN(W26/L49)*180/PI()","v":80.537677791974389},"Hoist Angle"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J25>'Menu Sheet'!S9,\"Block Capacity Exceeded\",\"\")","v":""},null,null,null,null,null,"Tower ",{"$f":"(AB29*G19)+AB31","v":139.06136088829783},null,null,"lbs.",null,null,300,null,null,null,"Gamma = ",{"$f":"ATAN(C39/(L51-H40))*180/PI()","v":52.475737385548221},"Tag Angle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loads DO NOT include Impact"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U19=\"Angle\",\"Degrees\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB24","v":9.0902769208223226},null,"Degrees",null,null,{"$f":"IF(U19=\"Distance\",\"Degrees\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"A =",{"$f":"AB48*(1/G19)/(1-TAN(AB24*PI()/180)*TAN(AB26*PI()/180))","v":69.567551986970983},"Line Load - Vertical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B =",{"$f":"AB29*TAN(AB24*PI()/180)*G19","v":11.130808317915358},"Line & Tag Load - Horizontal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L29>10,\"Warning - Load Angle Exceeds 10 degs.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"C =",{"$f":"AB34*SIN(AB25*PI()/180)","v":69.493808901326858},"Hoist Load - Vertical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D =",{"$f":"AB34*COS(AB25*PI()/180)","v":11.58230148355447},"Hoist Load - Horizontal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E =",{"$f":"AB30*TAN(T43*PI()/180)","v":14.493239997285624},"Tag Load - Vertical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Load =",{"$f":"SQRT((AB29^2)+(AB30^2))","v":70.452389478782649},"SQRT(A^2 + B^2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tag Load =",{"$f":"SQRT((AB33^2)+(AB30^2))","v":18.274268779600828},"SQRT(B^2 + E^2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Hoist is \"&'Menu Sheet'!K21","v":"Hoist is Capstan - 770"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Crown Block",{"$f":"SQRT(((AB30+AB32)^2)+(((AB29*G19)+AB31)^2))","v":140.90403631180703},"SQRT((B+D)^2 + (A*G16 + C)^2))"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB34","v":70.452389478782649},null," lbs.",{"$f":"IF(T43>70,\"Warning, Tag Angle Exceeds 70 degs.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Error Angle",{"$f":"ATAN(L51/W26)*180/PI()","v":33.690067525979785}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M37>'Menu Sheet'!S11,\"Capacity Exceeded\",\"\")","v":""}]
[null,null,250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Wt/Ft","Total Wt"]
[null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lift Line",{"$f":"SQRT((W26-C39)^2 + H40^2)*G19","v":50.635955604688654},{"$f":"'Menu Sheet'!Q20","v":0.08},{"$f":"AB40*AC40","v":4.0508764483750923}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoist Line",{"$f":"SQRT(W26^2 + L49^2)","v":304.13812651491099},{"$f":"AC40","v":0.08},{"$f":"AB41*AC41","v":24.331050121192881}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB35","v":18.274268779600828},null,null,null,null,null,null,null,null,null,null,"Tag Line",{"$f":"SQRT(C39^2 + L51^2)","v":320.15621187164243},{"$f":"'Menu Sheet'!Q21","v":0.08},{"$f":"AB42*AC42","v":25.612496949731394}]
[null,null,null,null,null,null,null,null,{"$f":"G15","v":0},null,"lbs.",null,null,null,null,null,null,null,null,{"$f":"AB26","v":52.475737385548221},null,"Degrees",null,null,null,null,null,null,null,{"$f":"SUM(AD40:AD42)","v":53.994423519299367}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB25","v":80.537677791974389},null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheave ",{"$f":"('Menu Sheet'!Q18^G19)*G19*('Menu Sheet'!Q18-1)/(('Menu Sheet'!Q18^G19)-1)","v":1.02}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Degrees",null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB32","v":11.58230148355447},null,null,{"$f":"AB30","v":11.130808317915358},null,"lbs.",null,null,null,{"$f":"'Menu Sheet'!K17 + 'Menu Sheet'!K18 + AB49","v":55.074311989685356}]
[null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('Menu Sheet'!K17 + 'Menu Sheet'!K18 + AD43)*(AB45-1) + AD43","v":55.074311989685356}]
[]
[null,null,null,null,null,null,null,null,null,null,null,200,null,null,null,null,null,{"$f":"AB31","v":69.493808901326858}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB33","v":14.493239997285624},null,"lbs."]
[]
[null,"Project Notes"]
[]
[]
[]
[null,"Disclaimer:  The information and calculations provided by this document have been developed by a reliable source in compliance with industry standards and are believed to be correct. This information should not be relied upon for a specific application without competent professional examination and verification of its accuracy, suitability, and applicability.  This document may not be adaptable to all situations and should be used at your own risk."]
[]
[null,{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Developed by Griswold Tower Software, PC"]

{"sheet":"Type 2","index":4,"n_rows":58,"n_cols":23,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,4,7,7],[8,4,8,7],[9,4,9,7],[10,4,10,7],[11,4,11,7],[55,1,56,11],[49,3,49,7],[23,8,25,8],[21,8,22,8],[26,8,38,8],[37,6,43,7],[24,5,25,6],[42,4,43,5],[44,4,44,7],[52,1,54,11],[17,9,17,11],[17,4,17,6],[22,9,22,11],[8,9,12,11],[41,15,41,16],[12,4,12,7],[13,4,13,7],[14,4,14,7],[15,4,15,7],[16,4,16,7],[4,2,4,4],[4,5,4,8],[3,9,3,11],[4,9,4,11],[0,1,0,7],[1,1,1,7],[2,9,2,11],[2,2,2,4],[3,2,3,4]]}
[]
[]
[null,"Contact","Gordon Lyman",null,null,null,null,null,null,"Bill Griswold"]
[null,"Email","gl@esystemtraining.com ",null,null,null,null,null,null,"BillGriswold@Live.com"]
[null,"Mobile No"," (210) 410-2091",null,null,"Crown Block Only with Trolly System",null,null,null,"(704) 906-9113"]
[]
[null,null,null,null,"Job Information:",null,null,"Note - Fields in ",null,"Blue"," are for input.",null,null,null,null,null,null,null,null,null,null,null,"Monopole Tower"]
[null,"Date:",null,null,{"$f":"'Menu Sheet'!E9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self Support Tower"]
[null,"Contractor:",null,null,{"$f":"'Menu Sheet'!K9","v":0},null,null,null,null,"Note:  The values for this Lift Type Change with Elevation. \nAll Values Shown are Maximums.",null,null,null,null,null,null,null,null,null,null,null,null,"Guyed Tower"]
[null,"Job No.:",null,null,{"$f":"'Menu Sheet'!K15","v":0}]
[null,"Competent Rigger:",null,null,{"$f":"'Menu Sheet'!K14","v":0}]
[null,"Client Name:",null,null,{"$f":"'Menu Sheet'!E10","v":0}]
[null,"Site Name:",null,null,{"$f":"'Menu Sheet'!E12","v":0}]
[null,"Site No.:",null,null,{"$f":"'Menu Sheet'!E13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y = ",100]
[null,"Lifted Load (lbs):",null,null,{"$f":"'Menu Sheet'!K17 + 'Menu Sheet'!K18","v":0}]
[null,"Lines + Friction (lbs):",null,null,{"$f":"Q45","v":17.03858022254202}]
[null,"Total Load (lbs):",null,null,{"$f":"E15+E16","v":17.03858022254202}]
[null,"Tower Type:",null,null,"Self Support Tower",null,null,null,null,"Notes to Engineer:",null,null,null,null,null,null,null,null,null,"αᵒ","X1","Y2"]
[null,null,null,null,null,null,null,null,null,"Max Horizontal Load on",null,null,null,null,null,null,null,null,null,23.555,39.234999999999999,10]
[null,null,null,null,null,null,null,null,null,"Tower",{"$f":"(2*ROUND(F48*Q44/I24,1))","v":10.199999999999999},null,null,null,null,null,null,null,null,21.443999999999999,31.422999999999998,20]
[null,null,null,null,null,null,null,null,null,"Max Vertical Load on",null,null,null,null,null,"α = ",13.282,null,null,19.794,25.192,30]
[null,null,null,null,{"$f":"'Menu Sheet'!K19","v":"Block 1 - 1000"},null,null,null," ft.","Tower",{"$f":"2*Q44","v":34.07716044508404},null,null,null,null,"Y = ",100,null,null,18.434999999999999,20,40]
[null,null,null,null,null,null,null,null,null,"Loads DO NOT include Impact",null,null,null,null,null,"X =",50,null,null,17.280999999999999,15.555999999999999,50]
[null,null,null,null,null,null,{"$f":"INT(2*Q44)/COS(F29*PI()/180)","v":35.497042130295867},null,100,null,null,null,null,null,null,"% of Y =",100,null,null,16.280999999999999,11.683999999999999,60]
[null,null,null,null,null,{"$f":"IF(G24>'Menu Sheet'!S9,\"Block Capacity Exceeded\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"= 0?",{"$f":"(-Q23) + (Q22*Q24/100)*(TAN(2*Q21*PI()/180)) + (Q22*(100-Q24)/100)*(TAN(Q21*PI()/180))","v":-2.2932915923732367E-3},null,null,15.401999999999999,8.2650000000000006,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.62,5.2160000000000002,80]
[null,null,null,null,null,null,null,null,"Height to Attachment to Tower =",null,null,null,null,null,null,"X1 = ",{"$f":"Q23 - (Q28*TAN(Q21*PI()/90))","v":2.2932915923732367E-3},null,null,13.917999999999999,2.476,90]
[null,null,null,null,null,{"$f":"\"Max Lift Angle =  \"","v":"Max Lift Angle =  "},null,{"$f":"ROUND(ATAN(F48/I24)*180/PI(),1)&\" Deg\"","v":"16.7 Deg"},null,null,null,null,null,null,null,"Y2 =",{"$f":"(Q24/100)*Q22","v":100},null,null,13.282,2E-3,100]
[null,null,null,null,null,{"$f":"ATAN(F48/I24)*180/PI()","v":16.699244233993621}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Wt/Ft","Total Wt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lift Line",{"$f":"SQRT((I24)^2 +F48^ 2)","v":104.4030650891055},{"$f":"'Menu Sheet'!Q20","v":0.08},{"$f":"R37*S37*2","v":16.704490414256881}]
[null,null,null,null,null,null,{"$f":"\"Winch Line Pull = \"&INT(G24/2)&\" lbs\"","v":"Winch Line Pull = 17 lbs"}]
[null,null,null,null,null,{"$f":"E15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction",{"$f":"'Menu Sheet'!Q18","v":1.02}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lines + Friction ",null,{"$f":"T37 + (R40 - 1)*(T37 + 'Menu Sheet'!K17 + 'Menu Sheet'!K18)","v":17.03858022254202}]
[null,null,null,null,{"$f":"IF(Q44>'Menu Sheet'!S11,\"Hoist Capacity Exceeded\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu Sheet'!K17 + 'Menu Sheet'!K18 + Q45","v":17.03858022254202}]
[null,null,null,null,{"$f":"\"Hoist is \"&'Menu Sheet'!K21","v":"Hoist is Capstan - 770"},null,null,null,null,null,{"$f":"K20/2","v":5.0999999999999996},null,null,null,null,null,{"$f":"R42","v":17.03858022254202}]
[]
[]
[null,null,null,null,null,30,"ft."]
[]
[null,null,null,"Horizontal Distance to Hoist"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Q44","v":17.03858022254202}]
[null,"Project Notes"]
[]
[]
[]
[null,"Disclaimer:  The information and calculations provided by this document have been developed by a reliable source in compliance with industry standards and are believed to be correct. This information should not be relied upon for a specific application without competent professional examination and verification of its accuracy, suitability, and applicability.  This document may not be adaptable to all situations and should be used at your own risk."]
[]
[null,{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"},null,null,null,null,null,null,null,null,null,"Developed by Griswold Tower Software, PC"]

{"sheet":"Type 3","index":5,"n_rows":60,"n_cols":25,"rows_kept":60,"cut":false,"hidden":false,"merged":[[16,4,16,8],[7,4,7,8],[8,4,8,8],[9,4,9,8],[10,4,10,8],[11,4,11,8],[54,1,56,13],[57,1,58,13],[0,1,0,7],[1,1,1,7],[2,2,2,4],[3,2,3,4],[3,11,3,13],[2,11,2,13],[4,11,4,13],[28,10,29,10],[49,12,50,12],[20,11,20,13],[17,8,19,10],[30,6,32,9],[4,2,4,4],[15,4,15,8],[23,4,24,5],[23,11,23,13],[25,11,25,13],[43,12,44,12],[42,4,43,5],[4,5,4,10],[48,8,49,9],[50,8,50,10],[21,11,21,13],[40,7,41,7],[50,6,50,7],[28,6,28,7],[17,4,17,6],[24,6,26,9],[18,4,18,6],[22,5,22,7],[12,4,12,8],[13,4,13,8],[14,4,14,8],[35,11,38,12],[27,6,27,7]]}
[]
[]
[null,"Contact","Gordon Lyman",null,null,null,null,null,null,null,null,"Bill Griswold"]
[null,"Email","gl@esystemtraining.com ",null,null,null,null,null,null,null,null,"BillGriswold@Live.com"]
[null,"Mobile No"," (210) 410-2091",null,null,"Crown and Heel Blocks with Straight Tag",null,null,null,null,null,"(704) 906-9113"]
[]
[null,null,null,null,"Job Information:",null,null,null,"Note: Fields in","Blue","are for input.",null,null,null,null,null,1,null,null,null,null,null,null,null,"Monopole Tower"]
[null,"Date:",null,null,{"$f":"'Menu Sheet'!E9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,"Self Support Tower"]
[null,"Contractor:",null,null,{"$f":"'Menu Sheet'!K9","v":0},null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,"Guyed Tower"]
[null,"Job No.:",null,null,{"$f":"'Menu Sheet'!K15","v":0}]
[null,"Competent Rigger:",null,null,{"$f":"'Menu Sheet'!K14","v":0}]
[null,"Client Name:",null,null,{"$f":"'Menu Sheet'!E10","v":0},null,null,null,null,null,null,null,null,null,null,null,"Distance"]
[null,"Site Name:",null,null,{"$f":"'Menu Sheet'!E12","v":0},null,null,null,null,null,null,null,null,null,null,null,"Angle"]
[null,"Site No.:",null,null,{"$f":"'Menu Sheet'!E13","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"L19","v":"Distance"}]
[null,"Lifted Load:",null,null,{"$f":"'Menu Sheet'!K17 + 'Menu Sheet'!K18","v":0}]
[null,"Lines + Friction (lbs):",null,null,{"$f":"R47","v":66.876664420673066}]
[null,"Total Load (lbs):",null,null,{"$f":"E15+E16","v":66.876664420673066}]
[null,"Tower Type:",null,null,"Self Support Tower",null,null,null,"Choose Load Line\nAngle or Stand off   \nDistance"]
[null,"Parts:",null,null,1,null,null,null,null,null,null,"Distance",{"$f":"+IF(Q14=\"Angle\",\"Degrees\",\"Feet\")","v":"Feet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q14=\"Distance\",TRUE,FALSE)","v":true}]
[null,null,null,null,null,{"$f":"'Menu Sheet'!K19","v":"Block 1 - 1000"},null,null,null,null,null,"Notes to Engineer:"]
[null,null,null,null,null,null,null,null,null,null,null,"Max Horizontal Load on",null,null,null,null,{"$f":"IF(Q14=\"Angle\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"R33","v":150.61346752183525},null,null,null,null,null,"Tower ",{"$f":"R28","v":3.7618123736628593},"lbs."]
[null,null,null,null,{"$f":"IF(F23>'Menu Sheet'!S9,\"Block Capacity Exceeded\",\"\")","v":""},null,null,null,null,null,null,"Max Vertical Load on",null,null,null,null,"Alpha = ",{"$f":"IF(Q14=\"Angle\",G28,G29)","v":2.8624052261117474}]
[null,null,null,null,null,null,{"$f":"IF(Q14=\"Angle\",IF(G28>10,\"Warning - Load Angle Exceeds 10 degs.\",\"\"),IF(G29>10,\"Warning - Load Angle Exceeds 10 degs.\",\"\"))","v":""},null,null,null,null,"Tower ",{"$f":"E19*R27+R31","v":150.5664815508959},"lbs.",null,null,"Standoff = ",{"$f":"IF(Q14=\"Angle\",E35,E34)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,"Loads DO NOT include Impact",null,null,null,null,"Beta = ",{"$f":"ATAN(H41/(G51-R25))*180/PI()","v":65.772254682045826}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A =",{"$f":"R46*(1/E19)/(1-TAN(R24*PI()/180)*TAN(R26*PI()/180))","v":75.236247473257194},null,"A =","Line Load - Vertical"]
[null,null,null,null,null,null,3,null,{"$f":"IF(Q14=\"Angle\",\"Degrees\",\"\")","v":""},null,null,null,null,null,null,null,"B =",{"$f":"R27*TAN(R24*PI()/180)*E19","v":3.7618123736628593},null,"B =","Line & Tag Load - Horizontal"]
[null,null,null,null,null,null,{"$f":"ATAN((E34)/(K29-H41))*180/PI()","v":2.8624052261117474},null,{"$f":"IF(Q14=\"Distance\",\"Degrees\",\"\")","v":"Degrees"},null,400,null,null,null,null,null,"C =",{"$f":"R28*TAN(R26*PI()/180)","v":8.3595830525841297},null,"C =","Tag Load - Vertical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D =",{"$f":"R28","v":3.7618123736628593},null,"D =","Tag Load - Horizontal"]
[null,null,null,null,null,null,{"$f":"IF(R24>R34,\"WARNING - LOAD ANGLE EXCEEDS MAXIMUM!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Line Load =",{"$f":"SQRT((R27^2)+(R28^2))","v":75.330234077638721},null,"Line Load =","SQRT(A^2 + B^2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tag Load =",{"$f":"SQRT((R29^2)+(R30^2))","v":9.166998480838469},null,"Tag Load =","SQRT(C^2 + D^2)"]
[null,null,null,null,"Standoff",null,null,null,null,null,null,null,null,null,null,null,"Crown Block",{"$f":"SQRT((R28^2)+((R31+(R27*E19))^2))","v":150.61346752183525},null,"Crown Block","SQRT((B^2) + (A*G16 + C)^2)"]
[null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,"Error Angle",{"$f":"ATAN(G51/K29)*180/PI()","v":14.036243467926477}]
[null,null,null,null,{"$f":"(K29-H41)*TAN(G28*PI()/180)","v":10.481555856608239}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J45>70,\"Warning, Tag Angle Exceeds 70 degs.\",\"\")","v":""},null,null,null,null,null,"Length","Wt/Ft","Total Wt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lift Line",{"$f":"SQRT(R25^2 + (K29 - H41)^2)*E19","v":200.24984394500785},{"$f":"'Menu Sheet'!Q20","v":0.08},{"$f":"R37*S37","v":16.019987515600629}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoist Line",{"$f":"K29","v":400},{"$f":"S37","v":0.08},{"$f":"R38*S38","v":32}]
[null,null,null,null,null,{"$f":"E15","v":0},"lbs.",null,null,null,null,null,null,null,null,null,"Tag Line",{"$f":"+SQRT((G51-E34)^2 + H41^2)","v":219.31712199461307},{"$f":"'Menu Sheet'!Q21","v":0.08},{"$f":"R39*S39","v":17.545369759569045}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T37:T39)","v":65.565357275169674}]
[null,null,null,null,null,null,null,200,null,{"$f":"R32","v":9.166998480838469},"lbs.",null,"Tag Hoist"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu Sheet'!K22","v":"Hand"},null,null,null,"Sheave ",{"$f":"('Menu Sheet'!Q18^E19)*E19*('Menu Sheet'!Q18-1)/(('Menu Sheet'!Q18^E19)-1)","v":1.02}]
[null,null,null,null,{"$f":"IF(E49>'Menu Sheet'!S10,\"Block Capacity Exceeded\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(J41>'Menu Sheet'!S12,\"Capacity Exceeded\",\"\")","v":""},null,null,null,"Friction"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Horizontal Tag Load"]
[null,null,null,null,null,null,null,null,null,{"$f":"R26","v":65.772254682045826}]
[null,null,null,null,null,{"$f":"R31","v":75.330234077638721},null,null,null,"Degrees",null,null,{"$f":"R30","v":3.7618123736628593},null,null,null,null,{"$f":"'Menu Sheet'!K17 + 'Menu Sheet'!K18 + R47","v":66.876664420673066}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('Menu Sheet'!K17 + 'Menu Sheet'!K18 + T40)*(R42-1) + T40","v":66.876664420673066}]
[]
[null,null,null,null,{"$f":"1.414*F46","v":106.51695098578115},null,null,null,{"$f":"'Menu Sheet'!K21","v":"Capstan - 770"},null,null,null,{"$f":"R29","v":8.3595830525841297}]
[null,null,null,null,{"$f":"'Menu Sheet'!K20","v":"Block 1 - 1000"},null,null,null,null,null,null,null,"Vertical Tag Load"]
[null,null,null,null,null,null,100,null,{"$f":"IF(F46>'Menu Sheet'!S11,\"Capacity Exceeded\",\"\")","v":""}]
[]
[]
[null,"Project Notes"]
[]
[]
[]
[null,"Disclaimer:  The information and calculations provided by this document have been developed by a reliable source in compliance with industry standards and are believed to be correct. This information should not be relied upon for a specific application without competent professional examination and verification of its accuracy, suitability, and applicability.  This document may not be adaptable to all situations and should be used at your own risk."]
[]
[null,{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"},null,null,null,null,null,null,null,null,null,null,null,"Developed by Griswold Tower Software, PC"]

{"sheet":"Angle Chart","index":6,"n_rows":57,"n_cols":25,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[2,2,2,4],[2,11,2,13],[3,2,3,4],[3,11,3,13],[12,4,12,6],[12,7,12,11],[13,4,13,6],[4,2,4,4],[4,11,4,13],[7,4,7,6],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[4,5,4,9],[14,4,14,6],[54,1,55,13],[13,8,16,11],[24,10,26,10],[51,1,53,13],[24,6,24,7],[22,6,22,7]]}
[]
[]
[null,"Contact","Gordon Lyman",null,null,null,null,null,null,null,null,"Bill Griswold"]
[null,"Email","gl@esystemtraining.com ",null,null,null,null,null,null,null,null,"BillGriswold@Live.com"]
[null,"Mobile No"," (210) 410-2091",null,null,"Angle Finder Tool",null,null,null,null,null,"(704) 906-9113"]
[]
[null,null,null,null,"Job Information:",null,null,null,"Note: Fields in","Blue","are for input.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Monopole Tower"]
[null,"Date:",null,null,{"$f":"'Menu Sheet'!E9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self Support Tower"]
[null,"Contractor:",null,null,{"$f":"'Menu Sheet'!K9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guyed Tower"]
[null,"Job No.:",null,null,{"$f":"'Menu Sheet'!K15","v":0}]
[null,"Competent Rigger:",null,null,{"$f":"'Menu Sheet'!K14","v":0}]
[null,"Client Name:",null,null,{"$f":"'Menu Sheet'!E10","v":0},null,null,null,null,null,null,null,null,null,null,null,"Distance"]
[null,"Site Name:",null,null,{"$f":"'Menu Sheet'!E12","v":0},null,null,null,null,null,null,null,null,null,null,null,"Angle"]
[null,"Site No.:",null,null,{"$f":"'Menu Sheet'!E13","v":0},null,null,null,{"$f":"IF(R21>R31,\"WARNING - LOAD ANGLE EXCEEDS MAXIMUM!\",\"\")","v":""}]
[null,"Tower Type:",null,null,"Self Support Tower"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L16=\"Distance\",TRUE,FALSE)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L16=\"Angle\",TRUE,FALSE)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alpha = ",{"$f":"IF(L16=\"Angle\",G25,F23)","v":9.4623222080256166}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standoff = ",{"$f":"IF(L16=\"Angle\",#REF!,E32)","v":0}]
[null,null,null,null,null,{"$f":"ATAN((F48)/(K25))*180/PI()","v":9.4623222080256166},"Degrees",null,null,null,null,null,null,null,null,null,"Beta = ",{"$f":"ATAN(H37/(F48-R22))*180/PI()","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A =",{"$f":"F36/(1-TAN(R21*PI()/180)*TAN(R23*PI()/180))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L16=\"Angle\",\"Degrees\",\"\")","v":""},null,150,null,null,null,null,null,"B =",{"$f":"R24*TAN(R21*PI()/180)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L16=\"Distance\",\"Degrees\",\"\")","v":""},null,null,null,null,null,null,null,"C =",{"$f":"R25*TAN(R23*PI()/180)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D =",{"$f":"R25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Load =",{"$f":"SQRT((R24^2)+(R25^2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tag Load =",{"$f":"SQRT((R26^2)+(R27^2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crown Block",{"$f":"SQRT((R25^2)+((R28+R24)^2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error Angle",{"$f":"ATAN(F48/K25)*180/PI()","v":9.4623222080256166}]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"90-F23","v":80.537677791974389}]
[null,null,null,null,null,"Degrees"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,25]
[]
[]
[null,"Project Notes"]
[]
[]
[]
[null,"Disclaimer:  The information and calculations provided by this document have been developed by a reliable source in compliance with industry standards and are believed to be correct. This information should not be relied upon for a specific application without competent professional examination and verification of its accuracy, suitability, and applicability.  This document may not be adaptable to all situations and should be used at your own risk."]
[]
[null,{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"},null,null,null,null,null,null,null,null,null,null,null,"Developed by Griswold Tower Software, PC"]

{"sheet":"Face Block Mount","index":7,"n_rows":55,"n_cols":28,"rows_kept":55,"cut":false,"hidden":false,"merged":[[26,6,26,12],[27,6,27,12],[0,1,0,13],[1,1,1,13],[2,4,2,6],[20,6,20,12],[21,6,21,12],[3,3,3,7],[2,27,3,27],[18,19,18,21],[17,2,17,22],[10,6,10,12],[11,6,11,12],[12,6,12,12],[13,6,13,12],[15,6,15,12],[21,19,21,21],[23,16,23,23],[24,15,24,23],[22,19,22,21],[2,20,2,23],[3,20,3,23],[27,19,27,21],[18,6,18,12],[2,26,3,26],[13,15,16,23],[25,2,25,22],[19,6,19,12],[9,6,9,12],[14,6,14,12],[4,4,4,6],[4,9,4,16],[4,20,4,23],[7,6,7,12],[8,6,8,12],[26,19,26,21],[19,19,19,21],[20,19,20,21],[52,1,53,23],[49,1,51,23],[28,19,28,21],[29,19,29,21],[31,16,31,23],[32,15,32,23],[28,6,28,12],[29,6,29,12],[30,19,30,21]]}
[]
[]
[null,"Contact",null,null,"Gordon Lyman",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill Griswold",null,null,null,null,null,"Crown\nBlock Load","Heel\nBlock Load"]
[null,"Email",null,"gl@esystemtraining.com ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BillGriswold@Live.com",null,null,null,null,"Type"]
[null,"Mobile No",null,null," (210) 410-2091",null,null,null,null,"Face Mounted Crown and Heel Blocks",null,null,null,null,null,null,null,null,null,null,"(704) 906-9113",null,null,null,null,"Type 1",{"$f":"'Type 1'!J25","v":140.90403631180703}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 2",{"$f":"'Type 2'!G24","v":35.497042130295867}]
[null,null,null,null,null,null,"Job Information:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 3",{"$f":"'Type 3'!F23","v":150.61346752183525},{"$f":"'Type 3'!E49","v":106.51695098578115}]
[null,"Date:",null,null,null,null,{"$f":"'Menu Sheet'!E9","v":"00:00:00"}]
[null,"Contractor:",null,null,null,null,{"$f":"'Menu Sheet'!K9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Type 1'!G18","v":"Self Support Tower"}]
[null,"Job No.:",null,null,null,null,{"$f":"'Menu Sheet'!K15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Type 2'!E18","v":"Self Support Tower"}]
[null,"Competent Rigger:",null,null,null,null,{"$f":"'Menu Sheet'!K14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Type 3'!E18","v":"Self Support Tower"}]
[null,"Client Name:",null,null,null,null,{"$f":"'Menu Sheet'!E10","v":0}]
[null,"Site Name:",null,null,null,null,{"$f":"'Menu Sheet'!E12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basketed"]
[null,"Site No.:",null,null,null,null,{"$f":"'Menu Sheet'!E13","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(G15=\"Monopole Tower\",\"WARNING - This Page Not Applicable to Monopoles\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Choked"]
[null,"Tower Type:",null,null,null,null,{"$f":"IF(Z16=\"Type 1\",Z9,IF(Z16=\"Type 2\",Z10,IF(Z16=\"Type 3\",Z11,\"\")))","v":"Self Support Tower"},null,null,null,null,null,null,{"$f":"IF(G15=\"Monopole Tower\",\"<----\",\"\")","v":""}]
[null,"Rigging Type",null,null,null,null,"Type 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G16","v":"Type 1"}]
[]
[null,null,"Crown Block Face Attachment"]
[null,"Sling Arrangement",null,null,null,null,"Choked",null,null,null,null,null,null,null,null,"Block Force",null,null,null,{"$f":"IF(Z16=\"Type 1\",AA5,IF(Z16=\"Type 2\",AA6,(IF(Z16=\"Type 3\",AA7,\"\"))))","v":140.90403631180703},null,null,"Lbs",null,null,{"$f":"G19","v":"Choked"}]
[null,"Crown Block Sling",null,null,null,null,"S2 - 16 - 1500",null,null,null,null,null,null,null,null,"Sling Length",null,null,null,{"$f":"IF(Z16=\"\",\"\",VLOOKUP(Z20,Equipment!F11:K24,3,FALSE)*12)","v":192},null,null,"In.",null,null,{"$f":"G20","v":"S2 - 16 - 1500"}]
[null,"Face Width at Crown",null,null,null,null,30,null,null,null,null,null,null,"In.",null,"Sling Capacity",null,null,null,{"$f":"IF(Z16=\"\",\"\",VLOOKUP(Z20,Equipment!F11:K24,5,FALSE))","v":1500},null,null,"Lbs"]
[null,"Leg Size",null,null,null,null,2.5,null,null,null,null,null,null,"In.",null,"Sling Force",null,null,null,{"$f":"IF(Z16=\"\",\"\",IF(Z19=\"Choked\",1,0.5)*(T19/2)/COS(PI()*T23/360))","v":70.686911257826736},null,null,"Lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Included Angle",null,null,null,{"$f":"IF(Z16=\"\",\"\",(360/PI())*ASIN(G21*IF(Z19=\"Choked\",0.5,1)/(T20-3.14*G22)))","v":9.3444467146351826},null,null,"Degrees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"\",\"\",IF(T21>T22,\"Crown Block Sling is Sufficient\",\"Crown Block Sling is Over Capacity\"))","v":"Crown Block Sling is Sufficient"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"\",\"\",IF(G21>IF(Z19=\"Choked\",(T20-3.14*G22),0.5*(T20-3.14*G22)),\"WARNING - Crown Block Sling to Short\",\"\"))","v":""}]
[null,null,{"$f":"IF(Z16=\"Type 3\",\"Heel Block Face Attachment\",\"\")","v":""}]
[null,{"$f":"IF(Z16=\"Type 3\",\"Sling Arrangement\",\"\")","v":""},null,null,null,null,"Choked",null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"Type 3\",\"Block Force\",\"\")","v":""},null,null,null,{"$f":"IF(Z16=\"Type 1\",\"\",IF(Z16=\"Type 2\",\"\",IF(Z16=\"Type 3\",AB7,\"\")))","v":""},null,null,{"$f":"IF(Z16=\"Type 3\",\"Lbs\",\"\")","v":""},null,null,{"$f":"G27","v":"Choked"}]
[null,{"$f":"IF(Z16=\"Type 3\",\"Heel Block Sling\",\"\")","v":""},null,null,null,null,"S3 - 12 - 2000",null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"Type 3\",\"Sling Length\",\"\")","v":""},null,null,null,{"$f":"IF(Z16=\"Type 3\",VLOOKUP(Z28,Equipment!F11:K24,3,FALSE)*12,\"\")","v":""},null,null,{"$f":"IF(Z16=\"Type 3\",\"In.\",\"\")","v":""},null,null,{"$f":"G28","v":"S3 - 12 - 2000"}]
[null,{"$f":"IF(Z16=\"Type 3\",\"Face Width at Heel\",\"\")","v":""},null,null,null,null,30,null,null,null,null,null,null,{"$f":"IF(Z16=\"Type 3\",\"In.\",\"\")","v":""},null,{"$f":"IF(Z16=\"Type 3\",\"Sling Capacity\",\"\")","v":""},null,null,null,{"$f":"IF(Z16=\"Type 3\",VLOOKUP(Z28,Equipment!F11:K24,5,FALSE),\"\")","v":""},null,null,{"$f":"IF(Z16=\"Type 3\",\"Lbs\",\"\")","v":""}]
[null,{"$f":"IF(Z16=\"Type 3\",\"Leg Size\",\"\")","v":""},null,null,null,null,2.5,null,null,null,null,null,null,{"$f":"IF(Z16=\"Type 3\",\"In.\",\"\")","v":""},null,{"$f":"IF(Z16=\"Type 3\",\"Sling Force\",\"\")","v":""},null,null,null,{"$f":"IF(Z16=\"Type 3\",IF(Z27=\"Choked\",1,0.5)*(T27/2)/COS(PI()*T31/360),\"\")","v":""},null,null,{"$f":"IF(Z16=\"Type 3\",\"Lbs\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"Type 3\",\"Included Angle\",\"\")","v":""},null,null,null,{"$f":"IF(Z16=\"Type 3\",(360/PI())*ASIN(G29*IF(Z27=\"Choked\",0.5,1)/(T28-3.14*G30)),\"\")","v":""},null,null,{"$f":"IF(Z16=\"Type 3\",\"Degrees\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"Type 3\",IF(T29>T30,\"Heel Block Sling is Sufficient\",\"Heel Block Sling is Over Capacity\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"Type 3\",IF(G29>IF(Z27=\"Choked\",(T28-3.14*G30),0.5*(T28-3.14*G30)),\"WARNING - Heel Block Sling to Short\",\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   1. Face Width is Out to Out of Tower Legs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   2. Included Angle should be less than 60 Deg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   3. For Round Tower Legs use Diameter of Leg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   4. For Angle Tower Legs use Dimension of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   4. one leg of the Angle - See Above"]
[null,"Project Notes"]
[]
[]
[]
[null,"Disclaimer:  The information and calculations provided by this document have been developed by a reliable source in compliance with industry standards and are believed to be correct. This information should not be relied upon for a specific application without competent professional examination and verification of its accuracy, suitability, and applicability.  This document may not be adaptable to all situations and should be used at your own risk."]
[]
[null,{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Developed by Griswold Tower Software, PC"]

{"sheet":"Equipment","index":8,"n_rows":42,"n_cols":25,"rows_kept":42,"cut":false,"hidden":false,"merged":[[22,5,22,6],[22,7,22,8],[22,9,22,10],[17,7,17,8],[21,7,21,8],[21,9,21,10],[19,5,19,6],[18,7,18,8],[18,9,18,10],[39,1,40,11],[10,5,10,6],[10,7,10,8],[10,9,10,10],[11,5,11,6],[11,7,11,8],[19,7,19,8],[19,9,19,10],[20,5,20,6],[20,7,20,8],[20,9,20,10],[17,5,17,6],[22,1,23,3],[11,9,11,10],[12,5,12,6],[12,7,12,8],[0,3,2,8],[6,19,7,19],[6,20,7,20],[6,21,7,21],[2,9,2,11],[3,9,3,11],[4,9,4,11],[3,3,4,8],[10,24,28,29],[9,24,9,29],[8,1,8,3],[24,1,24,3],[23,5,23,6],[9,5,9,6],[9,7,9,8],[9,9,9,10],[8,5,8,10],[12,9,12,10],[23,7,23,8],[23,9,23,10],[16,5,16,6],[16,7,16,8],[16,9,16,10],[21,5,21,6],[6,22,7,22],[17,9,17,10],[18,5,18,6],[13,9,13,10],[14,5,14,6],[14,7,14,8],[14,9,14,10],[15,5,15,6],[15,7,15,8],[15,9,15,10],[13,5,13,6],[13,7,13,8]]}
[null,null,null,"JOINTLY SERVING\nTHE TOWER INDUSTRY\nwith\nTRAINING and ENGINEERING"]
[]
[null,"Contact","Gordon Lyman",null,null,null,null,null,null,"Bill Griswold"]
[null,"Email","gl@esystemtraining.com ","Listing of Contractor's Equipment",null,null,null,null,null,"BillGriswold@Live.com"]
[null,"Mobile No"," (210) 410-2091",null,null,null,null,null,null,"(704) 906-9113"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cable Designation","Safe Working\nLoad","Min. Breaking\nStrength (lbs)","Weight\n(lbs/ft)"]
[]
[null,"HOIST INFORMATION",null,null,null,"SLING INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"No Cable",0,null,0]
[null,"Hoist Name","Working Capacity (Pounds)","Cable Size and Type",null,"Sling Name",null,"Length (Ft)",null,"Capacity (Pounds)",null,null,null,null,"Hoist Name","Safe\nLoad","Weight\nlbs/ft",null,null,{"$f":"IF('Rope Chart'!B5=\"\",\"\",'Rope Chart'!B5)","v":"1/4\" - 6 x 19"},{"$f":"IF('Rope Chart'!C5=\"\",\"\",'Rope Chart'!C5)","v":1150},{"$f":"IF('Rope Chart'!D5=\"\",\"\",'Rope Chart'!D5)","v":5750},{"$f":"IF('Rope Chart'!E5=\"\",\"\",'Rope Chart'!E5)","v":0.12},{"$f":"IF('Rope Chart'!F5=\"\",\"\",'Rope Chart'!F5)","v":"Wire"},"Directions"]
[null,"Hoist 1 - 1000",1000,"1/4\" - 6 x 19",{"$f":"IF(C11>P11,\"WARNING\",\"\")","v":""},"S1 - 10 - 1000",null,10,null,1000,null,null,null,null,{"$f":"B11","v":"Hoist 1 - 1000"},{"$f":"VLOOKUP(D11,$T$9:$W$55,2,FALSE)","v":1150},{"$f":"VLOOKUP(D11,$T$9:$W$55,4,FALSE)","v":0.12},{"$f":"VLOOKUP(D11,$T$9:$X$55,5,FALSE)","v":"Wire"},null,{"$f":"IF('Rope Chart'!B6=\"\",\"\",'Rope Chart'!B6)","v":"5/16\" - 6 x 19"},{"$f":"IF('Rope Chart'!C6=\"\",\"\",'Rope Chart'!C6)","v":1750},{"$f":"IF('Rope Chart'!D6=\"\",\"\",'Rope Chart'!D6)","v":8750},{"$f":"IF('Rope Chart'!E6=\"\",\"\",'Rope Chart'!E6)","v":0.18},{"$f":"IF('Rope Chart'!F6=\"\",\"\",'Rope Chart'!F6)","v":"Wire"},"\nList all applicable Hoists, Blocks and Slings in the appropriate columns.  If you have several identical hoists, blocks or slings only list them one time.  Also provide the rated working capacity for each of these and the lengths of the slings.  Be sure and save a master copy of this spreadsheet once this information has been input so that you don't have to re-input the information everytime you use it.\n\nWhen starting a new rigging plan choose the hoist(s) and block(s) on the Menu Sheet using the drop down boxes located just below the lifted load input cell.  The names of these pieces of equipment will appear on the Type 1, 2 and 3 Rigging Plan sheets.  If the capacity of one of these pieces of equipment is exceeded a warning will appear in RED LETTERS adjacent to the equipment."]
[null,"Hoist 2 - 1500",1500,"5/16\" - 6 x 19",{"$f":"IF(C12>P12,\"WARNING\",\"\")","v":""},"S2 - 16 - 1500",null,16,null,1500,null,null,null,null,"Hoist 2 - 1500",{"$f":"VLOOKUP(D12,$T$9:$W$55,2,FALSE)","v":1750},{"$f":"VLOOKUP(D12,$T$9:$W$55,4,FALSE)","v":0.18},{"$f":"VLOOKUP(D12,$T$9:$X$55,5,FALSE)","v":"Wire"},null,{"$f":"IF('Rope Chart'!B7=\"\",\"\",'Rope Chart'!B7)","v":"3/8\" - 6 x 19"},{"$f":"IF('Rope Chart'!C7=\"\",\"\",'Rope Chart'!C7)","v":2550},{"$f":"IF('Rope Chart'!D7=\"\",\"\",'Rope Chart'!D7)","v":11250},{"$f":"IF('Rope Chart'!E7=\"\",\"\",'Rope Chart'!E7)","v":0.26},{"$f":"IF('Rope Chart'!F7=\"\",\"\",'Rope Chart'!F7)","v":"Wire"}]
[null,"Hoist 3 - 2000",2000,"3/8\" - 6 x 19","","S3 - 12 - 2000",null,12,null,2000,null,null,null,null,"Hoist 3 - 2000",2550,0.26,"Wire",null,{"$f":"IF('Rope Chart'!B8=\"\",\"\",'Rope Chart'!B8)","v":"7/16\" - 6 x 19"},{"$f":"IF('Rope Chart'!C8=\"\",\"\",'Rope Chart'!C8)","v":3450},{"$f":"IF('Rope Chart'!D8=\"\",\"\",'Rope Chart'!D8)","v":17250},{"$f":"IF('Rope Chart'!E8=\"\",\"\",'Rope Chart'!E8)","v":0.35},{"$f":"IF('Rope Chart'!F8=\"\",\"\",'Rope Chart'!F8)","v":"Wire"}]
[null,"Hoist 4 - 5000",5000,"1/2\" - 6X36 EEIP","","S4 - 18 - 2000",null,18,null,2000,null,null,null,null,"Hoist 4 - 5000",5840,0.46,"Wire",null,{"$f":"IF('Rope Chart'!B9=\"\",\"\",'Rope Chart'!B9)","v":"1/2\" - 6 x 19"},{"$f":"IF('Rope Chart'!C9=\"\",\"\",'Rope Chart'!C9)","v":4700},{"$f":"IF('Rope Chart'!D9=\"\",\"\",'Rope Chart'!D9)","v":23500},{"$f":"IF('Rope Chart'!E9=\"\",\"\",'Rope Chart'!E9)","v":0.46},{"$f":"IF('Rope Chart'!F9=\"\",\"\",'Rope Chart'!F9)","v":"Wire"}]
[null,"Capstan - 770",770,"1/2\" Synthetic Rope","","S5 - 15 - 5000",null,15,null,5000,null,null,null,null,"Capstan - 770",770,0.08,"Synthetic",null,{"$f":"IF('Rope Chart'!B10=\"\",\"\",'Rope Chart'!B10)","v":"9/16\" - 6 x 19"},{"$f":"IF('Rope Chart'!C10=\"\",\"\",'Rope Chart'!C10)","v":5700},{"$f":"IF('Rope Chart'!D10=\"\",\"\",'Rope Chart'!D10)","v":28500},{"$f":"IF('Rope Chart'!E10=\"\",\"\",'Rope Chart'!E10)","v":0.59},{"$f":"IF('Rope Chart'!F10=\"\",\"\",'Rope Chart'!F10)","v":"Wire"}]
[null,"Hand",200,"1/2\" Synthetic Rope","","S6 - 20 - 5000",null,20,null,5000,null,null,null,null,"Hand",770,0.08,"Synthetic",null,{"$f":"IF('Rope Chart'!B11=\"\",\"\",'Rope Chart'!B11)","v":"5/8\" - 6 x 19"},{"$f":"IF('Rope Chart'!C11=\"\",\"\",'Rope Chart'!C11)","v":7100},{"$f":"IF('Rope Chart'!D11=\"\",\"\",'Rope Chart'!D11)","v":35500},{"$f":"IF('Rope Chart'!E11=\"\",\"\",'Rope Chart'!E11)","v":0.72},{"$f":"IF('Rope Chart'!F11=\"\",\"\",'Rope Chart'!F11)","v":"Wire"}]
[null,null,null,"","",null,null,null,null,null,null,null,null,null,0,"","","",null,{"$f":"IF('Rope Chart'!B12=\"\",\"\",'Rope Chart'!B12)","v":"3/4\" - 6 x 19"},{"$f":"IF('Rope Chart'!C12=\"\",\"\",'Rope Chart'!C12)","v":10200},{"$f":"IF('Rope Chart'!D12=\"\",\"\",'Rope Chart'!D12)","v":51000},{"$f":"IF('Rope Chart'!E12=\"\",\"\",'Rope Chart'!E12)","v":1.04},{"$f":"IF('Rope Chart'!F12=\"\",\"\",'Rope Chart'!F12)","v":"Wire"}]
[null,null,null,"","",null,null,null,null,null,null,null,null,null,0,"","","",null,{"$f":"IF('Rope Chart'!B13=\"\",\"\",'Rope Chart'!B13)","v":"7/8\" - 6 x 19"},{"$f":"IF('Rope Chart'!C13=\"\",\"\",'Rope Chart'!C13)","v":13750},{"$f":"IF('Rope Chart'!D13=\"\",\"\",'Rope Chart'!D13)","v":68750},{"$f":"IF('Rope Chart'!E13=\"\",\"\",'Rope Chart'!E13)","v":1.42},{"$f":"IF('Rope Chart'!F13=\"\",\"\",'Rope Chart'!F13)","v":"Wire"}]
[null,null,null,"","",null,null,null,null,null,null,null,null,null,0,"","","",null,{"$f":"IF('Rope Chart'!B14=\"\",\"\",'Rope Chart'!B14)","v":"1\" - 6 x 19"},{"$f":"IF('Rope Chart'!C14=\"\",\"\",'Rope Chart'!C14)","v":17950},{"$f":"IF('Rope Chart'!D14=\"\",\"\",'Rope Chart'!D14)","v":89750},{"$f":"IF('Rope Chart'!E14=\"\",\"\",'Rope Chart'!E14)","v":1.85},{"$f":"IF('Rope Chart'!F14=\"\",\"\",'Rope Chart'!F14)","v":"Wire"}]
[null,null,null,"","",null,null,null,null,null,null,null,null,null,0,"","","",null,{"$f":"IF('Rope Chart'!B15=\"\",\"\",'Rope Chart'!B15)","v":"9/16\" - 6 x 37"},{"$f":"IF('Rope Chart'!C15=\"\",\"\",'Rope Chart'!C15)","v":5350},{"$f":"IF('Rope Chart'!D15=\"\",\"\",'Rope Chart'!D15)","v":26750},{"$f":"IF('Rope Chart'!E15=\"\",\"\",'Rope Chart'!E15)","v":0.59},{"$f":"IF('Rope Chart'!F15=\"\",\"\",'Rope Chart'!F15)","v":"Wire"}]
[null,null,null,"","",null,null,null,null,null,null,null,null,null,0,"","","",null,{"$f":"IF('Rope Chart'!B16=\"\",\"\",'Rope Chart'!B16)","v":"5/8\" - 6 x 37"},{"$f":"IF('Rope Chart'!C16=\"\",\"\",'Rope Chart'!C16)","v":6900},{"$f":"IF('Rope Chart'!D16=\"\",\"\",'Rope Chart'!D16)","v":34500},{"$f":"IF('Rope Chart'!E16=\"\",\"\",'Rope Chart'!E16)","v":0.72},{"$f":"IF('Rope Chart'!F16=\"\",\"\",'Rope Chart'!F16)","v":"Wire"}]
[null,null,null,"","",null,null,null,null,null,null,null,null,null,0,"","","",null,{"$f":"IF('Rope Chart'!B17=\"\",\"\",'Rope Chart'!B17)","v":"3/4\" - 6 x 37"},{"$f":"IF('Rope Chart'!C17=\"\",\"\",'Rope Chart'!C17)","v":9500},{"$f":"IF('Rope Chart'!D17=\"\",\"\",'Rope Chart'!D17)","v":47500},{"$f":"IF('Rope Chart'!E17=\"\",\"\",'Rope Chart'!E17)","v":1.04},{"$f":"IF('Rope Chart'!F17=\"\",\"\",'Rope Chart'!F17)","v":"Wire"}]
[null,"Additional Cable Information may in entered on the \"Wire Rope Chart\" tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Rope Chart'!B18=\"\",\"\",'Rope Chart'!B18)","v":"7/8\" - 6 x 37"},{"$f":"IF('Rope Chart'!C18=\"\",\"\",'Rope Chart'!C18)","v":13000},{"$f":"IF('Rope Chart'!D18=\"\",\"\",'Rope Chart'!D18)","v":65000},{"$f":"IF('Rope Chart'!E18=\"\",\"\",'Rope Chart'!E18)","v":1.42},{"$f":"IF('Rope Chart'!F18=\"\",\"\",'Rope Chart'!F18)","v":"Wire"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Rope Chart'!B19=\"\",\"\",'Rope Chart'!B19)","v":"1\" - 6 x 37"},{"$f":"IF('Rope Chart'!C19=\"\",\"\",'Rope Chart'!C19)","v":17000},{"$f":"IF('Rope Chart'!D19=\"\",\"\",'Rope Chart'!D19)","v":85000},{"$f":"IF('Rope Chart'!E19=\"\",\"\",'Rope Chart'!E19)","v":1.85},{"$f":"IF('Rope Chart'!F19=\"\",\"\",'Rope Chart'!F19)","v":"Wire"}]
[null,"BLOCK INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,"Block Name","Friction\nConstant",null,null,null,{"$f":"IF('Rope Chart'!B20=\"\",\"\",'Rope Chart'!B20)","v":"1/2\" Synthetic Rope"},{"$f":"IF('Rope Chart'!C20=\"\",\"\",'Rope Chart'!C20)","v":770},{"$f":"IF('Rope Chart'!D20=\"\",\"\",'Rope Chart'!D20)","v":7700},{"$f":"IF('Rope Chart'!E20=\"\",\"\",'Rope Chart'!E20)","v":0.08},{"$f":"IF('Rope Chart'!F20=\"\",\"\",'Rope Chart'!F20)","v":"Synthetic"}]
[null,"Block Name","Working Capacity (Pounds)","Sheave Bearing Type",null,null,null,null,null,null,null,null,null,null,{"$f":"B27","v":"Block 1 - 1000"},{"$f":"IF(D27=O$40,1.09,IF(D27=O$41,1.045,IF(D27=O$42,1.02,1.09)))","v":1.02},null,null,null,{"$f":"IF('Rope Chart'!B21=\"\",\"\",'Rope Chart'!B21)","v":"9/16\" Synthetic Rope"},{"$f":"IF('Rope Chart'!C21=\"\",\"\",'Rope Chart'!C21)","v":1020},{"$f":"IF('Rope Chart'!D21=\"\",\"\",'Rope Chart'!D21)","v":10200},{"$f":"IF('Rope Chart'!E21=\"\",\"\",'Rope Chart'!E21)","v":0.10199999999999999},{"$f":"IF('Rope Chart'!F21=\"\",\"\",'Rope Chart'!F21)","v":"Synthetic"}]
[null,"Block 1 - 1000",1000,"Roller Bearings",null,null,null,null,null,null,null,null,null,null,"Block 2 - 2000",1.0449999999999999,null,null,null,{"$f":"IF('Rope Chart'!B22=\"\",\"\",'Rope Chart'!B22)","v":"5/8\" Synthetic Rope"},{"$f":"IF('Rope Chart'!C22=\"\",\"\",'Rope Chart'!C22)","v":1330},{"$f":"IF('Rope Chart'!D22=\"\",\"\",'Rope Chart'!D22)","v":13300},{"$f":"IF('Rope Chart'!E22=\"\",\"\",'Rope Chart'!E22)","v":0.13300000000000001},{"$f":"IF('Rope Chart'!F22=\"\",\"\",'Rope Chart'!F22)","v":"Synthetic"}]
[null,"Block 2 - 2000",2000,"Bronze Bushing",null,null,null,null,null,null,null,null,null,null,"Block 3 - 5000",1.0449999999999999,null,null,null,{"$f":"IF('Rope Chart'!B23=\"\",\"\",'Rope Chart'!B23)","v":"3/4\" Synthetic Rope"},{"$f":"IF('Rope Chart'!C23=\"\",\"\",'Rope Chart'!C23)","v":1720},{"$f":"IF('Rope Chart'!D23=\"\",\"\",'Rope Chart'!D23)","v":17000},{"$f":"IF('Rope Chart'!E23=\"\",\"\",'Rope Chart'!E23)","v":0.18},{"$f":"IF('Rope Chart'!F23=\"\",\"\",'Rope Chart'!F23)","v":"Synthetic"}]
[null,"Block 3 - 5000",5000,"Bronze Bushing",null,null,null,null,null,null,null,null,null,null,"Block 4 - 7500",1.02,null,null,null,{"$f":"IF('Rope Chart'!B24=\"\",\"\",'Rope Chart'!B24)","v":"3/8\" - 6X36 EEIP"},{"$f":"IF('Rope Chart'!C24=\"\",\"\",'Rope Chart'!C24)","v":3320},{"$f":"IF('Rope Chart'!D24=\"\",\"\",'Rope Chart'!D24)","v":16600},{"$f":"IF('Rope Chart'!E24=\"\",\"\",'Rope Chart'!E24)","v":0.26},{"$f":"IF('Rope Chart'!F24=\"\",\"\",'Rope Chart'!F24)","v":"Wire"}]
[null,"Block 4 - 7500",7500,"Roller Bearings",null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B25=\"\",\"\",'Rope Chart'!B25)","v":"1/2\" - 6X36 EEIP"},{"$f":"IF('Rope Chart'!C25=\"\",\"\",'Rope Chart'!C25)","v":5840},{"$f":"IF('Rope Chart'!D25=\"\",\"\",'Rope Chart'!D25)","v":29200},{"$f":"IF('Rope Chart'!E25=\"\",\"\",'Rope Chart'!E25)","v":0.46},{"$f":"IF('Rope Chart'!F25=\"\",\"\",'Rope Chart'!F25)","v":"Wire"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B26=\"\",\"\",'Rope Chart'!B26)","v":"9/16\" - 6X36 EEIP"},{"$f":"IF('Rope Chart'!C26=\"\",\"\",'Rope Chart'!C26)","v":7400},{"$f":"IF('Rope Chart'!D26=\"\",\"\",'Rope Chart'!D26)","v":37000},{"$f":"IF('Rope Chart'!E26=\"\",\"\",'Rope Chart'!E26)","v":0.59},{"$f":"IF('Rope Chart'!F26=\"\",\"\",'Rope Chart'!F26)","v":"Wire"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B27=\"\",\"\",'Rope Chart'!B27)","v":""},{"$f":"IF('Rope Chart'!C27=\"\",\"\",'Rope Chart'!C27)","v":""},{"$f":"IF('Rope Chart'!D27=\"\",\"\",'Rope Chart'!D27)","v":""},{"$f":"IF('Rope Chart'!E27=\"\",\"\",'Rope Chart'!E27)","v":""},{"$f":"IF('Rope Chart'!F27=\"\",\"\",'Rope Chart'!F27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B34=\"\",\"\",'Rope Chart'!B34)","v":""},{"$f":"IF('Rope Chart'!C34=\"\",\"\",'Rope Chart'!C34)","v":""},{"$f":"IF('Rope Chart'!D34=\"\",\"\",'Rope Chart'!D34)","v":""},{"$f":"IF('Rope Chart'!E34=\"\",\"\",'Rope Chart'!E34)","v":""},{"$f":"IF('Rope Chart'!F28=\"\",\"\",'Rope Chart'!F28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B35=\"\",\"\",'Rope Chart'!B35)","v":""},{"$f":"IF('Rope Chart'!C35=\"\",\"\",'Rope Chart'!C35)","v":""},{"$f":"IF('Rope Chart'!D35=\"\",\"\",'Rope Chart'!D35)","v":""},{"$f":"IF('Rope Chart'!E35=\"\",\"\",'Rope Chart'!E35)","v":""},{"$f":"IF('Rope Chart'!F29=\"\",\"\",'Rope Chart'!F29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B36=\"\",\"\",'Rope Chart'!B36)","v":""},{"$f":"IF('Rope Chart'!C36=\"\",\"\",'Rope Chart'!C36)","v":""},{"$f":"IF('Rope Chart'!D36=\"\",\"\",'Rope Chart'!D36)","v":""},{"$f":"IF('Rope Chart'!E36=\"\",\"\",'Rope Chart'!E36)","v":""},{"$f":"IF('Rope Chart'!F30=\"\",\"\",'Rope Chart'!F30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B37=\"\",\"\",'Rope Chart'!B37)","v":""},{"$f":"IF('Rope Chart'!C37=\"\",\"\",'Rope Chart'!C37)","v":""},{"$f":"IF('Rope Chart'!D37=\"\",\"\",'Rope Chart'!D37)","v":""},{"$f":"IF('Rope Chart'!E37=\"\",\"\",'Rope Chart'!E37)","v":""},{"$f":"IF('Rope Chart'!F31=\"\",\"\",'Rope Chart'!F31)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.0900000000000001,null,null,null,{"$f":"IF('Rope Chart'!B38=\"\",\"\",'Rope Chart'!B38)","v":""},{"$f":"IF('Rope Chart'!C38=\"\",\"\",'Rope Chart'!C38)","v":""},{"$f":"IF('Rope Chart'!D38=\"\",\"\",'Rope Chart'!D38)","v":""},{"$f":"IF('Rope Chart'!E38=\"\",\"\",'Rope Chart'!E38)","v":""},{"$f":"IF('Rope Chart'!F32=\"\",\"\",'Rope Chart'!F32)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Rope Chart'!B39=\"\",\"\",'Rope Chart'!B39)","v":""},{"$f":"IF('Rope Chart'!C39=\"\",\"\",'Rope Chart'!C39)","v":""},{"$f":"IF('Rope Chart'!D39=\"\",\"\",'Rope Chart'!D39)","v":""},{"$f":"IF('Rope Chart'!E39=\"\",\"\",'Rope Chart'!E39)","v":""},{"$f":"IF('Rope Chart'!F33=\"\",\"\",'Rope Chart'!F33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing Types",null,null,null,null,{"$f":"IF('Rope Chart'!B40=\"\",\"\",'Rope Chart'!B40)","v":""},{"$f":"IF('Rope Chart'!C40=\"\",\"\",'Rope Chart'!C40)","v":""},{"$f":"IF('Rope Chart'!D40=\"\",\"\",'Rope Chart'!D40)","v":""},{"$f":"IF('Rope Chart'!E40=\"\",\"\",'Rope Chart'!E40)","v":""},{"$f":"IF('Rope Chart'!F34=\"\",\"\",'Rope Chart'!F34)","v":""}]
[null,"Disclaimer:  The information and calculations provided by this document have been developed by a reliable source in compliance with industry standards and are believed to be correct. This information should not be relied upon for a specific application without competent professional examination and verification of its accuracy, suitability, and applicability.  This document may not be adaptable to all situations and should be used at your own risk.",null,null,null,null,null,null,null,null,null,null,null,null,"No Bearings",null,null,null,null,{"$f":"IF('Rope Chart'!B41=\"\",\"\",'Rope Chart'!B41)","v":""},{"$f":"IF('Rope Chart'!C41=\"\",\"\",'Rope Chart'!C41)","v":""},{"$f":"IF('Rope Chart'!D41=\"\",\"\",'Rope Chart'!D41)","v":""},{"$f":"IF('Rope Chart'!E41=\"\",\"\",'Rope Chart'!E41)","v":""},{"$f":"IF('Rope Chart'!F35=\"\",\"\",'Rope Chart'!F35)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bronze Bushing"]
[null,{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"},null,null,null,null,null,null,null,null,null,"Developed by Griswold Tower Software, PC",null,null,"Roller Bearings"]

{"sheet":"Contacts","index":9,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,3],[13,1,13,3],[25,1,25,3],[13,5,13,7],[1,5,1,6],[17,5,23,6]]}
[]
[null,"Competent Rigger",null,null,null,"Contractor Contact / Project Manager"]
[null,"Name","Company","Phone No.",null,"Name","Phone No."]
[null,"Joe Smith","Rigging, Inc.",2235551234,null,"Daniel Boone",2235551212]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Qualified Person"]
[null,"Name","Company","Phone No."]
[null,"Sam Houston","Houston International",3215551212]
[]
[null,null,null,null,null,"Notes:  1.  List people in each of the applicable catagories in order for them to be available on the forms in each of the applicable catagories.\n2.  Input phone numbers without any dashes, spaces, or other special characters."]
[]
[]
[]
[]
[]
[]
[]
[null,"Qualified Engineer"]
[null,"Name","Company","Phone No."]
[null,"William A. Griswold, Jr. PE","GTS, PC",7049069113]

{"sheet":"Rope Chart","index":10,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,0,40,0],[1,5,2,5],[3,8,22,14],[2,8,2,14],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4]]}
[]
[null,"Cable Designation","Safe Working\nLoad","Min. Breaking\nStrength (lbs)","Weight\n(lbs/ft)","Wire/\nSynthetic",null,"Wire"]
[null,null,null,null,null,null,null,"Synthetic","NOTES"]
[null,"No Cable",0,0,0,"Wire",null,null,"The Wire Rope in this chart is based on Independent Wire Rope Core (IWRC) cable with improved plow steel (IPS) and the breaking strength specified is based on catalogue charts which may be lower than the actual specification sheet for a cable. \n\nBoth the Wire and Synthetic Rope values in this chart are based on general nominal values.  We recommend you add your rope values to this chart below based on the manufacturer's specifications.  Rows in White are availble for these additional values.\n\nBe sure and designate either Wire or Synthetic Rope."]
[null,"1/4\" - 6 x 19",1150,5750,0.12,"Wire"]
[null,"5/16\" - 6 x 19",1750,8750,0.18,"Wire"]
[null,"3/8\" - 6 x 19",2550,11250,0.26,"Wire"]
[null,"7/16\" - 6 x 19",3450,17250,0.35,"Wire"]
[null,"1/2\" - 6 x 19",4700,23500,0.46,"Wire"]
[null,"9/16\" - 6 x 19",5700,28500,0.59,"Wire"]
[null,"5/8\" - 6 x 19",7100,35500,0.72,"Wire"]
[null,"3/4\" - 6 x 19",10200,51000,1.04,"Wire"]
[null,"7/8\" - 6 x 19",13750,68750,1.42,"Wire"]
[null,"1\" - 6 x 19",17950,89750,1.85,"Wire"]
[null,"9/16\" - 6 x 37",5350,26750,0.59,"Wire"]
[null,"5/8\" - 6 x 37",6900,34500,0.72,"Wire"]
[null,"3/4\" - 6 x 37",9500,47500,1.04,"Wire"]
[null,"7/8\" - 6 x 37",13000,65000,1.42,"Wire"]
[null,"1\" - 6 x 37",17000,85000,1.85,"Wire"]
[null,"1/2\" Synthetic Rope",770,7700,0.08,"Synthetic"]
[null,"9/16\" Synthetic Rope",1020,10200,0.10199999999999999,"Synthetic"]
[null,"5/8\" Synthetic Rope",1330,13300,0.13300000000000001,"Synthetic"]
[null,"3/4\" Synthetic Rope",1720,17000,0.18,"Synthetic"]
["Space for Additional Rope Data","3/8\" - 6X36 EEIP",3320,16600,0.26,"Wire"]
[null,"1/2\" - 6X36 EEIP",5840,29200,0.46,"Wire"]
[null,"9/16\" - 6X36 EEIP",7400,37000,0.59,"Wire"]

{"sheet":"Extra Sequence Sheet","index":11,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,0,1,9],[2,0,2,9],[3,0,3,9],[0,0,0,9]]}
["Continuation of Description of Work Sequence "]
[]
["Continuation of Description of  Reinforcing Sequence"]
[]
[{"$f":"Credits!B11","v":"Version 5.6 - February 19, 2019"}]

{"sheet":"Rigging requirements","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Credits","index":13,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,1,10,3]]}
[]
["The Equation Development, Drafting and Primary Spreadsheet by William A. Griswold, Jr., PE "]
["Griswold Tower Software, PC"]
[]
["Overview and Editing provided by Gordon Lyman"]
["eSystem Training Solutions"]
[]
["Additional Macro Development provided by James M. Ruedlinger, PE"]
["Electronic Research, Inc."]
[]
["Version","Version 5.6 - February 19, 2019"]
[]
[4.2,"Formatting Improvements"]
[4.3,"Corrected problems with dropdown boxes on the Face Block Mount Tab"]
[4.4000000000000004,"Added Note to Engineer - Reactions do not include an Impact Factor - Fixed \"Angle\" or \"Distance\" dropdown on Type 3 tab."]
[4.5,"Corrected error in the Tag Angle - Type 1 Lift"]
["5.0","Added ability to have 1, 2 or 3 line parts in the lift.  Added Cable Weights and Sheave Friction Coefficients to Total Load.  Corrected equations in Type 2."]
["5.1","Fixed for placement of contractor's logo on the \"Rigging Plan\" tab"]
[5.2,"The Force to Class IV was not working."]
[5.3,"Fixed problem with the bearing selection on the blocks.  Added the \"Contacts\" tab"]
[5.4,"Corrected the Class of Lift.  The Gross Lifted Weight needed to include the weight of the lines and friction in the blocks."]
[5.5,"Formatting Improvements - Added Continuation of Sequence Sheet"]
[5.6,"Added Synthetic Rope and Formating to the Rope Chart"]

{"sheet":"Sheet2","index":14,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":true,"merged":[[1,2,36,4]]}
[]
[null,null,{"$f":"IF(J7=\"Monopole Tower\",\"MP_PIC\",1)","v":"MP_PIC"}]
[null,null,null,null,null,null,null,null,null,"Monopole Tower"]
[null,null,null,null,null,null,null,null,null,"Self Support Tower"]
[null,null,null,null,null,null,null,null,null,"Guyed Tower"]
[]
[null,null,null,null,null,null,null,null,null,"Monopole Tower"]

{"sheet":"Sheet1","index":15,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,"X1","Y2"]
[null,"Alpha = ",7,null,null,null,2E-3,100]
[null,"Beta =",30,null,null,null,2.476,90]
[null,"Load =",300,null,null,null,5.2160000000000002,80]
[null,null,null,null,null,null,8.2650000000000006,70]
[null,"tan(Alpha) = ",{"$f":"TAN(C5*PI()/180)","v":0.1227845609029046},null,null,null,11.683999999999999,60]
[null,"tan(Alpha/2) =",{"$f":"TAN(C5*PI()/360)","v":6.1162620150484306E-2},null,null,null,15.555999999999999,50]
[null,"tan(Beta) = ",{"$f":"TAN(C6*PI()/180)","v":0.57735026918962573},null,null,null,20,40]
[null,null,null,null,null,null,25.192,30]
[null,null,{"$f":"C7*C9","v":36.835368270871378},null,null,null,31.422999999999998,20]
[null,null,{"$f":"C13*C10","v":2.2529476376545081},null,null,null,39.234999999999999,10]
[null,null,{"$f":"C7*(1 - C9*C10)","v":297.74705236234547},null,null,null,50,0]
[null,null,{"$f":"C15*C11","v":171.90434083181773}]