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

{"sheet":"Tools","index":0,"n_rows":190,"n_cols":14,"rows_kept":190,"cut":false,"hidden":false,"merged":[[10,6,11,13],[60,1,60,2],[76,3,79,3],[11,1,11,2],[14,1,14,2],[82,3,85,3],[25,3,29,3],[32,1,32,2],[65,1,65,2],[93,1,93,2],[34,1,34,2],[45,1,45,2],[58,1,58,2],[1,1,7,2],[155,1,155,2],[96,1,96,2],[68,1,68,2],[126,1,126,2],[145,1,145,2],[82,1,82,2],[106,1,106,2],[88,1,88,2],[10,1,10,2],[59,1,59,2],[76,1,76,2],[25,1,25,2],[46,1,46,2],[116,1,116,2],[107,1,107,2],[118,1,118,2],[122,1,122,2],[127,1,127,2],[146,1,146,2],[135,1,135,2],[137,1,137,2],[141,1,141,2]]}
[]
[null,"ALLMI Lift Planning Calculator v1.1\nThis calculator tool only has full functionality on Microsoft Excel 365 (2019) onwards.\nThis calculator is for guidance only. It should be studied and the information applied with the assistance of expert advice as necessary. Every effort has been made to ensure the accuracy of the information provided, but no legal liability can be accepted by ALLMI for any errors or omissions, nor for any consequences thereof. The specifying of any safety factors, lifting equipment, lifting accessories, mat selection, etc. is the responsibility of the Appointed Person.\n\nShaded boxes are protected from data entry. White boxes may auto-populate from other sections of the tool but may also be overwritten. It is advised that a new version of the tool is opened before each use, rather than re-using saved versions.\n\nThis document uses Macros to resize the 'mouseover' explanatory graphics (which can be viewed by hovering over cells with a red triangle in the corner). If disabled, they may not display correctly, but the tool functionality will otherwise not be affected.\n\nPlease start with 'Step 1' to the right of this tool."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 2: Loader Crane Data\nThis step uses basic loader crane data to calculate the stabiliser loading figure results in Step 3. If any of the information is difficult to source, contact the loader crane installer and / or manufacturer.",null,null,null,null,"Step 1: Rated Capacities\nThis step is to enter loader crane rated capacities from the rated capacity chart. This data can help pre-populate Step 2, and is used to calculate available radii, load weights and utilisation figures in Step 5.\nNote: 'kg' figures must decrease left to right; 'm' figures must increase left to right. \nThis data is set outside of the pre-defined print margins.\n\n\n\nStart from the right by entering the maximum radius figures and work leftwards - for cranes with fewer extensions leave boxes to the left blank"]
[null,"Key decision: Data entered here will determine stabiliser loadings and mat sizes. Initially, it is recommended that the maximum hydraulic radius and rated capacity at the maximum hydraulic radius are used, as this data will provide a 'worst case' stabiliser loading. Load weight figures can be adjusted to the actual load weight for all subsequent steps, independent of the stabiliser loading figures.\n\nImportant: Alternatively, actual hydraulic radius and actual load weight may be entered instead, if sufficient control measures are in place to prevent either from being exceeded during the lift.\n\nImportant: This tool does not account for partial stabiliser deployment / short rigging. Please contact ALLMI for further guidance."]
[null,"Maximum Hydraulic Radius (m)\nActual radius may be used with sufficient control measures",{"$f":"N14","v":0},null,null,null,"kg"]
[null,"Rated Capacity @ Maximum Hydraulic Radius (kg)\nActual load may be used with sufficient control measures",{"$f":"N13","v":0},null,null,null,"m"]
[]
[null,"Radius of the CoG for Dead Weight of the Loader (m)\nInformation from the manufacturer, booms fully extended",0]
[null,"Dead Weight of the Loader Crane (kg)\nOf loader crane only (not the GVW), preferably excluding stabilisers",0]
[null,"Dynamic Co-efficient\nSafety margin between 1.2 and 1.4 - default set to 1.4.\n1.4 is advised as a cautious figure based on industry norms. However, 1.2 might be used on sites where the Appointed Person has assessed a low risk environment, with good data available and with suitable control measures in place.\nEntry restricted to 1.2-1.4 - select from dropdown",1.4]
[null,"Ma = Gross Lifting Moment (kNm)",{"$f":"((C13*C14)+(C16*C17))*C18*9.81/1000","v":0}]
[null,"Span of Crane Stabilisers (m)\nMeasurement between stabiliser foot centres when fully extended",0,null,null,null,"T/M",{"$f":"H13/1000*H14","v":0},0,0,0,0,0,0]
[null,"Span of Auxiliary Stabilisers (m)\nLeave blank if none fitted - measurement between stabiliser foot centres when fully extended",0]
[null,"Offset of Loader Crane Column (m)\nInformation from the manufacturer - typically 0.15 to 0.3m",0,null,null,null,"Fibre Rope"]
[null,"Distance of Auxiliary Stabilisers from Crane Column (m)\nLeave blank if none fitted - information from manufacturer or installer",0,null,null,null,"Webbing"]
[null,null,null,null,null,null,"Round Webbing"]
[null,null,null,null,null,null,"Wire Rope"]
[null,"Optional: Quick Converter - Change between kN/m² and t/m²\nThis tool is for optional use, as Step 3 requires ground bearing strength figures to be entered in kN/m².",null,"Optional",null,null,"Chain"]
[null,"Enter kN/m² value ",0]
[null,"Same Value in t/m²",{"$f":"C27*0.1019","v":0}]
[null,"Enter t/m² value ",0]
[null,"Same Value in kN/m²",{"$f":"C29*9.81","v":0}]
[]
[]
[null,"Step 3: Stabiliser Loadings and Mat Sizes\nThis step provides the user with main and auxiliary stabiliser loading figures, which are then divided by the ground bearing strength to calculate a minimum required mat size."]
[null,"Ground Bearing Strength (kN/m²)\nInformation provided by site - convert from t/m2 using 'Quick Converter' tool, if necessary",0]
[null,"Main Stabilisers"]
[null,"Stabiliser Force (kN)",{"$f":"IFERROR(C19/(C20/2-C22),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Stabiliser Force (t)",{"$f":"IFERROR(C36*0.1019,\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Minimum Required Mat Size (m²)",{"$f":"IFERROR(ROUNDUP(C36/C34,2),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Square Mats (mm x mm)",{"$f":"IFERROR(ROUNDUP(SQRT(C38)*1000,0)&\"mm\",\"TBC\")","v":"TBC"}]
[]
[null,{"$f":"IFERROR(ROUNDUP(SQRT(C38)*1000,0)&\"mm\",\"TBC\")","v":"TBC"}]
[]
[null,"Round Mats (mm x mm)"]
[null,{"$f":"IFERROR(ROUNDUP(((SQRT(C38/3.1415927)*2)),3)*1000&\"mm\",\"TBC\")","v":"TBC"}]
[]
[null,"Dimensions are only illustrative of the minimum mat dimensions required, and should be rounded up to the next size  available."]
[null,"Auxiliary Stabilisers"]
[null,"Stabiliser Force (kN)",{"$f":"IFERROR(C19/SQRT(C23^2+((C21/2)-C22)^2),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Stabiliser Force (t)",{"$f":"IFERROR(C48*0.1019,\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Minimum Required Mat Size (m²)",{"$f":"IFERROR(ROUNDUP(C48/C34,2),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Square Mats (mm x mm)",{"$f":"IFERROR(ROUNDUP(SQRT(C50)*1000,0)&\"mm\",\"TBC\")","v":"TBC"}]
[]
[null,{"$f":"IFERROR(ROUNDUP(SQRT(C50)*1000,0)&\"mm\",\"TBC\")","v":"TBC"}]
[]
[]
[null,"Round Mats (mm x mm)"]
[null,{"$f":"IFERROR(ROUNDUP(((SQRT(C50/3.1415927)*2)),3)*1000&\"mm\",\"TBC\")","v":"TBC"}]
[]
[null,"Dimensions are only illustrative of the minimum mat dimensions required, and should be rounded up to the next size  available."]
[null,"Step 3a: Resultant Imposed Loads\nUsing either the calculated mat size - or an 'as carried' / user specified mat size"]
[null,"Key Decision: The mat size entered below must be at least as large as the minimum required mat size calculated above. If the mat size is too small for the calculated stabiliser loading and given ground bearing strength, a warning is shown.\nNote, from this point onwards this tool assumes all 4 No. mats selected will be the same as those for the main stabilisers.\n\nImportant: The strength and stiffness of mats is dependent upon their material and thickness. If the mat is not rigid enough loads will be concentrated in a smaller area. Mats should have an effective area in contact with the ground of at least the minimum area calculated. \nIf in doubt, contact the mat supplier."]
[null,"Mat Size Area Selected (m²)\nImportant: this must be the area of the mat selected, not the dimensions",0]
[null,"Resultant Bearing Pressure Imposed on the Ground (kN/m²)",{"$f":"IFERROR(C36/C62,\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Resultant Bearing Pressure Imposed on the Ground (t/m²)",{"$f":"IFERROR(C37/C62,\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Using calculated mat size (kN/m²)",{"$f":"C36/C38","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(C63>C34, \"Mat size too small!\",\"Mat size OK\")","v":"Mat size too small!"}]
[]
[]
[null,"Step 4: Total Lift Weight (kg)\nThis step involves inputting all factors that combine to form the total weight to be lifted. Data from this step pre-populates some sections of Step 5 and Step 7. "]
[null,"Load Weight (kg)\nExcluding self weight of attachment and lifting accessories",0]
[null,"Self weight of lifting accessories (kg)\nWeighed, or from manufacturer's information",0]
[null,"Self weight of Lifting Attachment (kg)\nE.g. brick grab - likely n/a for hook",0]
[null,"Load Factor of Safety (%)\nE.g. Additional 20% factor of safety",0]
[null,"Total Lift Weight (kg)",{"$f":"SUM(C70:C72)*(1+C73)","v":0}]
[]
[]
[null,"Optional: Rated Capacity at Required Radius\nThis optional tool calculates the load weight that can be lifted at a required radius entered by the user, with the added option of restricting this to a planned maximum utilisation. Best practice is to plan to no more than 90% of rated capacity, although some sites may have their own rules. This tool does not affect any other steps. Step 5 must still be used.",null,"Optional"]
[null,"Maximum Planned Utilisation (%)\nE.g. restrict the lift to 85% of rated capacity",0]
[null,"Required Radius (m)\nEntry limited to maximum radius",0]
[null,"Rated Capacity Available at Required Radius (kg)",{"$f":"IFERROR((_xlfn.XLOOKUP(C79,G14:N14,G20:N20,,1))/C79*C78*1000, \"Awaiting Data\")","v":"Awaiting Data"}]
[]
[]
[null,"Optional: Available Radius for a Given Load\nThis optional tool calculates the maximum available radius for a given load weight, with the added option of restricting this to a planned maximum utilisation. Best practice is to plan no more than 90% utilisation of rated capacity, although some sites may have their own rules. If used, the 'Maximum Available Radius' result from this tool should be entered as the 'Required Radius' in Step 5.",null,"Optional"]
[null,"Maximum Planned Utilisation (%)\nE.g. restrict the lift to 85% of rated capacity",0]
[null,"Lift Weight (kg)",{"$f":"C74","v":0}]
[null,"Maximum Radius Available (m)",{"$f":"IFERROR(MIN(C84*((_xlfn.XLOOKUP(C85,G13:N13,G20:N20,,1))*1000)/C85,N14),\"Awaiting Data\")","v":"Awaiting Data"}]
[]
[]
[null,"Step 5: Rated Capacity Utilisation\nThis step uses the rated capacity information entered in Step 1 to calculate the rated capacity at the required radius for a given load weight. It also calculates what percentage of rated capacity utilisation is being used. If the load is too heavy for the required radius, a warning is shown."]
[null,"Required Radius (m)\nEntry limited to minimum and maximum radii from the rated capacity chart",0]
[null,"Total Load Weight (kg)",{"$f":"C74","v":0}]
[null,"Rated Capacity Available at Required Radius (kg)",{"$f":"IFERROR((_xlfn.XLOOKUP(C90,G14:N14,G20:N20,,1))/C90*1000,\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Rated Capacity Utilisation (%)",{"$f":"IFERROR(C91/C92,\"Awaiting Data\")","v":"Awaiting Data"}]
[null,{"$f":"IFERROR(IF(C93>100%,\"Load too heavy!\",\"Load within capacity\"),\"Awaiting Data\")","v":"Load too heavy!"}]
[]
[]
[null,"Step 6: Sail Effect of Wind\nThis step uses load weight, sail area (using the dimensions of the largest side) and shape to assess the maximum permissible wind speed the lift may proceed in, which will be typically lower than the manufacturer's permitted operating wind speed with no load."]
[null,"Co-efficient of Resistance\nIn the absence of any specific advice, select the highest co-efficient figure for the shape selected - if this cannot be determined, enter 2.4",0]
[null,"Total Load Weight (kg)",{"$f":"C74","v":0}]
[null,"Load Height on Largest Side (m)",0]
[null,"Load Length on Largest Side (m)",0]
[null,"Sail Area of Load (m²)",{"$f":"C100*C101","v":0}]
[null,"Maximum Operating Wind Speed with no Load (m/s)\nAs published by the loader crane manufacturer, e.g. 13m/s",0]
[null,"Permissible Operating Wind Speed (m/s)\nFor lifts up to 10m total height only\nThe wind speed conditions obtained from a weather forecast, an anemometer or reference to the Beaufort Scale should be multiplied to account for the height of the load, if operating more than 10m above the ground, using a height speed multiplier (hover over this box for a height speed multiplier graphic).\nHover over the results box for a conversion table between m/s, mph and the Beaufort Scale.\nFor further guidance, see ALLMI Guidance Note 021.",{"$f":"IFERROR(MIN(C103*(SQRT((1.2*(C99/1000))/(C102*C98))),C103),\"Awaiting Data\")","v":"Awaiting Data"}]
[]
[]
[null,"Step 7a: 4-Point Load Sling Selector\nSteps 8a to 8c are optional, based on the number of lifting points on the load. They can be used to calculate sling capacities and lengths for a given load size and weight, incorporating the sling configuration used to attach the sling to the load and a user specified factor of safety. The results provided give a choice between multi-leg slings or multiple single-leg slings with bow shackles."]
[null,"Note: Load weight excluding the self-weight of the slings needs to be re-entered for this tool, as the figures are used differently compared to when calculating rated capacities.\nNote: Sling capacities and lengths are given accurately in this tool based on a 90 degree included angle between sling legs. They are then rounded up to the nearest 1000kg / 1m in the 'ALLMI Lift Plan Results' section.\nImportant: Sling Selector tools all assume a balanced load lifted from the top, and are unsuitable for use with unbalanced loads. \nSling configurations that require extra sling length (baskets, chokes, etc.) will require additional sling length calculated by the \nAppointed Person."]
[null,"Sling Type\nSelect","chain"]
[null,"Sling Capacity Factor of Safety (%)\nE.g. Additional 20% factor of safety applied to all accessories",0]
[null,"Distance between Lift Points along Load Length (m)",0]
[null,"Distance between Lift Points along Load Width (m)",0]
[null,"Load Weight (kg)\nExcluding self weight of attachment and lifting accessories",0]
[null,"Sling Configuration Mode Factor\nNote: Image shows examples only - actual mode factor must be taken from the sling label / manufacturer's instructions",0]
[null,"Minimum Sling Leg Length (m)\nUp to 90 degrees included angle",{"$f":"SQRT(SUMSQ(C116,C116))","v":0}]
[null,"Hook Height above Top of Load (m)\nUsing sling length shown above",{"$f":"SQRT((SUMSQ((C111/2),(C112/2))))","v":0}]
[null,"Choose Either"]
[null,"Multi-Leg Slings\n4-leg chain slings minimum WLL (kg)",{"$f":"IFERROR((C113/C114)*(1+C110),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Or"]
[null,"Multiple Single-Leg Slings\n4 No. single-leg slings minimum WLL / SWL (kg)",{"$f":"IFERROR(((C113/2.1)/C114)*(1+C110), \"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Self Weight of Lifting Accessories (kg)\nWeighed, or from manufacturer's information",{"$f":"C71","v":0}]
[null,"Minimum WLL Bow Shackle (kg) - 3 No. Required\nRequired to attach multiple single leg slings to the hook\nCalculated to 70% of bow shackle WLL, assuming slings are 45° from in-line\nNote: for simplicity, all 3 No. bow shackles are listed as the same WLL",{"$f":"ROUNDUP((((C113+C121)*(1+C110)))/0.7,0)","v":0}]
[null,"Plus, if Required"]
[null,"Minimum WLL D-Shackles (kg) - 4 No. Required\nIf required to attach slings to lifting points",{"$f":"(C113/2.1)*(1+C110)","v":0}]
[]
[]
[null,"Step 7b: 2-Point Load Sling Selector"]
[null,"Note: Load weight excluding the self-weight of the slings needs to be re-entered for this tool, as the figures are used differently compared to when calculating rated capacities.\nNote: Sling capacities and lengths are given accurately in this tool based on a 90 degree included angle between sling legs. They are then rounded up to the nearest 1000kg / 1m in the 'ALLMI Lift Plan Results' section.\nImportant: Sling Selector tools all assume a balanced load lifted from the top, and are unsuitable for use with unbalanced loads. \nSling configurations that require extra sling length (baskets, chokes, etc.) will require additional sling length calculated by the \nAppointed Person."]
[null,"Sling Type\nSelect","Webbing"]
[null,"Sling Capacity Factor of Safety (%)\nE.g. Additional 20% factor of safety applied to all accessories",0]
[null,"Distance between Lift Points along Load Length (m)",0]
[null,"Load Weight (kg)\nExcluding self weight of attachment and lifting accessories",{"$f":"C70","v":0}]
[null,"Sling Configuration Mode Factor\nNote: Example only - actual mode factor must be taken from the sling label / manufacturer's instructions",0]
[null,"Hook Height above Top of Load (m)",{"$f":"C131/2","v":0}]
[null,"Minimum Sling Leg Length (m)\nUp to 90 degrees included angle",{"$f":"SQRT(SUMSQ((C131/2),(C131/2)))","v":0}]
[null,"Choose Either"]
[null,"Multi-Leg Slings\n2-leg chain slings minimum WLL / SWL (kg)",{"$f":"IFERROR((C132*(1+C130)/C133), \"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Or"]
[null,"Multiple Single-Leg Slings\n2 No. single-leg slings minimum WLL (kg)",{"$f":"IFERROR(((C132/1.4)/C133)*(1+C130), \"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Self Weight of Lifting Accessories (kg)\nWeighed or from manufacturer's information",{"$f":"C71","v":0}]
[null,"Minimum WLL Bow Shackle (kg) - 1 No. Required\nRequired to attach multiple single leg slings to the hook\nCalculated to 70% of bow shackle WLL, assuming slings are 45° from in-line",{"$f":"ROUNDUP(((C132+C140)*(1+C130))/0.7,0)","v":0}]
[null,"Plus, if Required"]
[null,"Minimum WLL D-Shackles (kg) - 2 No. Required\nIf required to attach slings to lifting points",{"$f":"(C132/1.4)*(1+C130)","v":0}]
[]
[]
[null,"Step 7c: 1-Point Load Sling Selector"]
[null,"Note: Load weight excluding the self-weight of the slings needs to be re-entered for this tool, as the figures are used differently compared to when calculating rated capacities.\nNote: Sling capacities and lengths are given accurately in this tool. They are then rounded up to the nearest 1000kg / 1m in the 'ALLMI Lift Plan Results' section.\nImportant: Sling Selector tools all assume a balanced load lifted from the top, and are unsuitable for use with unbalanced loads. \nSling configurations that required extra sling length (baskets, chokes, etc.) will require additional sling length calculated by the \nAppointed Person."]
[null,"Sling Type\nSelect","Fibre Rope"]
[null,"Sling Capacity Factor of Safety (%)\nE.g. Additional 20% factor of safety applied to all accessories",0]
[null,"Load Weight (kg)\nExcluding self weight of attachment and lifting accessories",{"$f":"C70","v":0}]
[null,"Sling Configuration Mode Factor\nNote: Example only - actual mode factor must be taken from the sling label / manufacturer's instructions",0]
[null,"Single-Leg Sling\nMinimum WLL including 20% safety margin (kg)",{"$f":"IFERROR((C150*(1+C149))/C151, \"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Minimum WLL D-Shackle (kg) - 1 No. Required\nIf required to attach slings to lifting point",{"$f":"C150*(1+C149)","v":0}]
[]
[]
[null,"ALLMI Lift Plan Results\nThe results below are intended to be in a format that is easy to copy into the ALLMI Lift Plan Template. All results must be checked by the Appointed Person for accuracy and relevance."]
[]
[null,"Load Information"]
[null,"Wind Sail Area",{"$f":"C102&\"m²\"","v":"0m²"}]
[null,"Maximum Permissible Windspeed (m/s):",{"$f":"IFERROR(ROUNDUP(C104,2)&\"m/s\",\"Awaiting Data\")","v":"Awaiting Data"}]
[]
[null,"Lifting Points, Attachments and Slinging Arrangements\nSling capacities rounded up to the nearest 1000kg; sling lengths rounded up to the nearest 1m. The Appointed Person must carefully check each element of this section prior to confirming what is to be used in the lift plan."]
[null,"Lifting Accessories (4 point load - multiple single accessories)",{"$f":"IFERROR(CONCATENATE(\"4 No. \", ROUNDUP(C115, 0),\"m EWL \",ROUNDUP(C120, -3),\"kg WLL \",C109,\" slings\"),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,null,{"$f":"CONCATENATE(\"3 No. \",ROUNDUP(C122,-3),\"kg WLL bow shackles\")","v":"3 No. 0kg WLL bow shackles"}]
[null,null,{"$f":"CONCATENATE(\"4 No. \",ROUNDUP(C124,-3),\"kg WLL D-shackles\")","v":"4 No. 0kg WLL D-shackles"}]
[null,"Lifting Accessories (4 point load - multi-leg slings)",{"$f":"IFERROR(CONCATENATE(\"1 No. 4-leg \",ROUNDUP(C115,0),\"m EWL \",ROUNDUP(C118, -3),\"kg WLL \",C109,\" sling\"),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,null,{"$f":"CONCATENATE(\"4 No. \",ROUNDUP(C124,-3),\"kg WLL D-shackles\")","v":"4 No. 0kg WLL D-shackles"}]
[null,"Lifting Accessories (2 point load - multiple single accessories)",{"$f":"IFERROR(CONCATENATE(\"2 No. \",ROUNDUP(C135,0),\"m EWL \",ROUNDUP(C139, -3),\"kg WLL \",C129,\" slings\"),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,null,{"$f":"CONCATENATE(\"1 No. \",ROUNDUP(C141,-3),\"kg WLL bow shackle\")","v":"1 No. 0kg WLL bow shackle"}]
[null,null,{"$f":"CONCATENATE(\"2 No. \",ROUNDUP(C143,-3),\"kg WLL D-shackles\")","v":"2 No. 0kg WLL D-shackles"}]
[null,"Lifting Accessories (2 point load - multi-leg slings)",{"$f":"IFERROR(CONCATENATE(\"1 No. 2-leg \",ROUNDUP(C135,0),\"m EWL \",ROUNDUP(C137, -3),\"kg WLL \",C129,\" sling\"),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,null,{"$f":"CONCATENATE(\"2 No. \",ROUNDUP(C143,-3),\"kg WLL D-shackles\")","v":"2 No. 0kg WLL D-shackles"}]
[null,"Lifting Accessories (1 point load)",{"$f":"IFERROR(CONCATENATE(\"1 No. \", ROUNDUP(C152, -3), \"kg WLL \",C148,\" sling\"),\"Awaiting Data\")","v":"Awaiting Data"}]
[null,null,{"$f":"CONCATENATE(\"1 No. \",ROUNDUP(C153,-3),\"kg WLL D-shackle\")","v":"1 No. 0kg WLL D-shackle"}]
[]
[null,"Total Weight of Lift"]
[null,"Load Weight (kg):",{"$f":"C70&\"kg\"","v":"0kg"}]
[null,"Lifting Accessories (kg):",{"$f":"C71&\"kg\"","v":"0kg"}]
[null,"Lifting Attachments (kg):",{"$f":"C72&\"kg\"","v":"0kg"}]
[null,"Load Factor of Safety:",{"$f":"C73","v":0}]
[null,"Total Lift Weight (kg):",{"$f":"C74&\"kg\"","v":"0kg"}]
[]
[null,"Loader Crane Details"]
[null,"Rated Capacity (kg) at Maximum Radius:",{"$f":"N13&\"kg @ \"&N14&\"m\"","v":"kg @ m"}]
[null,"Rated Capacity (kg) at Required Radius:",{"$f":"IFERROR(ROUNDUP(C92,0)&\"kg @ \"&C90&\"m\",\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Rated Capacity Utilisation (%):",{"$f":"IFERROR(C93,\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Min. Size of Supplementary Stabiliser Mats (dims & area):",{"$f":"IFERROR(C39&\" x \"&C39&\" / \"&ROUNDUP(C38,3)&\"m²\",\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Actual Stabiliser Mat Size (area):",{"$f":"C62&\"m²\"","v":"0m²"}]
[null,"Maximum Stabiliser Load (kN):",{"$f":"IFERROR(ROUNDUP(C36,2)&\"kN point load\",\"Awaiting Data\")","v":"Awaiting Data"}]
[null,"Resultant Bearing Pressure Imposed on the Ground (kN/m2)",{"$f":"IFERROR(ROUNDUP(C63,2)&\"kN/m²\",\"Awaiting Data\")","v":"Awaiting Data"}]