---
cid: po.bp.de.torque.drag
hub: de
tags: [drilling, torque-and-drag, Johancsik, soft-string, hook-load, pick-up, slack-off, drag, surface-torque, friction-factor, buoyancy, buckling, stretch, overpull]
facets: { discipline: drilling, property: torque-and-drag, method-type: analytical }
title: Soft-String Torque and Drag
summary: "Predicts hook load picking up and slacking off and the torque to rotate along a survey, with a check that the string holds."
slug: po.de.torque.drag
type: worksheet
---

# Soft-String Torque and Drag

## Description

What will the hook read picking up and slacking off, how much torque does the string need to turn, and does it hold? You enter the survey, the drill pipe and collars, the hole, the mud, the rig and the friction factors. You read off the hook load picking up, slacking off, sliding and rotating, the surface torque, the overpull left under the pipe's yield, and whether the drill pipe buckles sliding, with the bit at TD and against bit depth.

**Parameters:**
- **Drill string**: the drill pipe's OD, ID and weight with its tool joints `TQ_DpOD`, `TQ_DpID` (in), `TQ_DpW` (lb/ft), the tool joint OD `TQ_TjOD` (in), the grade's yield `TQ_Yp` (psi), the make-up torque `TQ_MakeUp` (ft·lbf), and the bottomhole assembly's length `TQ_BhaL` (ft) and the collars' OD, ID and weight `TQ_BhaOD`, `TQ_BhaID` (in), `TQ_BhaW` (lb/ft)
- **Hole, mud, rig and friction**: the open hole `TQ_Hole` (in), the mud `TQ_MW` (ppg), the block weight `TQ_Block` and the weight on bit `TQ_WOB` (lbf), the design friction factor `TQ_Mu` and the chart's three `TQ_Mu1`, `TQ_Mu2`, `TQ_Mu3`, the tension design factor `TQ_DFt`, the margin of overpull `TQ_MOP` (lbf) and the share of the make-up torque past which the torque warns `TQ_TorqueWarn`
- **Survey**: measured depth, inclination and azimuth per station, in the `TQ_Survey` table

**How to use it:** The survey is a planned path made up for the example. Overwrite it with the well's survey; for a shorter survey delete rows from both tables, and for a longer one insert rows inside them and copy the formulas down. Take the weights, the tool joints' make-up torque and the grade from the string's data sheets, with the worn pipe's class if it is not new. The friction factors are a fit, not a property: calibrate them to the pick-up, slack-off and rotating weights and the off-bottom torque the rig records on the way in, typically 0.15 to 0.25 in casing and 0.25 to 0.4 in open hole with water-based mud. One table runs the march with the bit at TD at the design friction factor: picking up, slacking off, sliding with the weight on bit, and rotating off bottom, with the torque the rotation builds. A second runs it again with the bit at every station and at three friction factors, and charts the hook load tripping out and in and the surface torque against bit depth. Check that the pick-up leaves the required margin of overpull under the pipe's yield over its design factor, that the surface torque stays under a share of the tool joints' make-up torque (80 % by default) and under the make-up torque itself, that the drill pipe's lowest axial force sliding stays under the sinusoidal buckling load and well clear of the helical one, where it can lock up, and that the string can put the weight on bit down while it still hangs from the hook. The drill pipe's stretch under the required overpull is shown beside the checks.

**Method:** Johancsik's soft-string model treats each course between two stations as an element of string lying on the wall. Each course from station i − 1 to station i has a length ΔL, a mean inclination θ, an inclination change Δθ (upper less lower) and an azimuth change Δα, and a buoyed weight w per foot, the drill pipe's or the collars' as the collars fill the bottom of the string (BF = 1 − ρm/ρs with the same mud inside and out). With F the axial force at the course's foot, the normal force is N = √((F Δα sin θ)² + (F Δθ + w ΔL sin θ)²) and the force at its top is F + w ΔL cos θ ± μ N, + picking up and − slacking off (Johancsik, Friesen and Dawson, 1984). Rotating, no axial friction acts, the force at the top is F + w ΔL cos θ, and the course adds μ N r to the torque at the tool joints, with r the tool joints' (or the collars') radius. The march starts at the bit with 0 for the trips and rotating and minus the weight on bit sliding, and the hook load is the force at surface plus the block weight. With the bit at a shallower station the march starts there with the collars above it, so each row of the bit-depth table runs the march again over the courses from the bit up, reading each course's length and angles from the survey table. Rotating, the force at a course's foot is the buoyed weight below it, so the torque sums each course's moment straight from the vertical depths, and the surface torque at each friction factor is that sum times the factor. The vertical depth is the courses' ΔL cos θ added up. The buckling loads are Dawson and Paslay's for the drill pipe at TD's inclination and √2 times it for the helix, and the force at the collars' top sliding is the weight on bit plus their buoyed weight's axial part less its drag, the collars being straight at the bit's inclination.

**Example:** The drilling family's reference well, the one the pore-pressure, casing-design, cement and surge sheets use, drilled as a directional well, since a vertical hole has no drag: the same casing points by measured depth along a build-and-hold path, vertical to a 2,000 ft kick-off, built at 2°/100 ft to 40° at 4,000 ft while it turns from 45° to 48° azimuth, and held to TD at 13,000 ft (10,738 ft TVD), with a station every 500 ft. The bit is on bottom in the 8½-in. production hole, in the 13.9 ppg mud. The string is 5-in. 19.5 lb/ft G-105 drill pipe (ID 4.276 in., 22.6 lb/ft with its NC50 tool joints of 6⅝ in., yield 105,000 psi, make-up torque 30,000 ft·lbf) over 600 ft of 6½-in. collars (ID 2-13/16 in., 91 lb/ft). The block and top drive weigh 50,000 lbf, the slide puts 25,000 lbf on the bit, the design friction factor is 0.3 and the chart's are 0.2, 0.3 and 0.4. The pick-up has to leave 100,000 lbf of overpull under the yield over a design factor of 1.1.

In 13.9 ppg mud the buoyancy factor is 0.7878, so the drill pipe weighs 17.80 lb/ft and the collars 71.69 lb/ft. With the bit at TD and a friction factor of 0.3 the hook reads 343,450 lbf picking up, 208,285 lbf slacking off and 265,949 lbf rotating off bottom, so the drag is 77,501 lbf out and 57,664 lbf in. Sliding with 25,000 lbf on the bit it reads 188,125 lbf. Rotating off bottom takes 18,429 ft·lbf at surface, 61 % of the 30,000 ft·lbf make-up torque. The pipe body yields at 553,833 lbf, 503,485 lbf over the 1.1 design factor, which leaves 210,034 lbf of overpull, over the 100,000 lbf required. The drill pipe stretches 94.0 in. under that 100,000 lbf. Sliding, the collars take nearly all of the weight on bit and the drill pipe's lowest force is −345 lbf at their top, far under the 30,547 lbf sinusoidal and 43,200 lbf helical buckling loads at 40°. Against bit depth, the three friction factors spread the hook loads from 315,154 lbf out and 225,549 lbf in at 0.2 to 374,431 lbf out and 192,795 lbf in at 0.4, and the surface torque from 12,286 to 24,571 ft·lbf; at 0.4 the torque passes 80 % of the make-up torque. The 2,000 ft build adds nearly half of the torque (8,217 of the 18,429 ft·lbf at 0.3): there the string's tension pulls it into the high side of the curve.

## Validity

Soft string: the string follows the survey's path with no bending stiffness, so the model misses the side forces of stiff collars and casing in doglegs, and a stiff-string model does better in high-dogleg or short-radius wells. Tool joints are not modelled as contact points; their radius only sets the torque arm. One friction factor holds along the whole hole, and the same mud is inside and out, with no viscous drag or circulation. The courses use the average-angle geometry between stations; a sparse survey through a build smooths its doglegs, so survey the curve every 100 ft for the march as for the well path (see the directional survey sheet). Azimuths across north (359° to 1°) need the 360° taken off by hand. The buckling check reads the drill pipe at TD's inclination with the open-hole clearance; inside casing the clearance is larger and the load lower. Buckled pipe drags more than the march gives, and the march carries no lock-up. Sliding is off-bottom static force balance with the bit taking the weight on bit; rotating on bottom and reaming are not modelled. Field units throughout.

## References

- Johancsik, C.A., Friesen, D.B. and Dawson, R. (1984). Torque and Drag in Directional Wells: Prediction and Measurement. *Journal of Petroleum Technology* 36(6), 987–992. SPE-11380-PA.
- Dawson, R. and Paslay, P.R. (1984). Drillpipe Buckling in Inclined Holes. *Journal of Petroleum Technology* 36(10), 1734–1738. SPE-11167-PA.
- Aadnøy, B.S., Fazaelizadeh, M. and Hareland, G. (2010). A 3D Analytical Model for Wellbore Friction. *Journal of Canadian Petroleum Technology* 49(10), 25–36.
- Mitchell, R.F. and Miska, S.Z. (eds.) (2011). *Fundamentals of Drilling Engineering*. SPE Textbook Series Vol. 12, ch. 9 (torque and drag, buckling).
- API RP 7G (1998). *Recommended Practice for Drill Stem Design and Operating Limits*, 16th ed. American Petroleum Institute (drill pipe and collar weights, tool joint make-up torque, margin of overpull).

## Functions used

`PO.DE.TD.Buoyancy`, `PO.DE.Casing.Axial.Yield`, `PO.DE.TD.Stretch`, `PO.DE.TD.Buckling.Sinusoidal`, `PO.DE.TD.Buckling.Helical`

## Spreadsheet: TorqueDrag

|     | A                                                                                                                                                                                                       | B                                                                                                                                                                                                                                                                                                                                                                                                                                          | C                                                                                                                                                                                                                                                                                                                                                                                                                                          | D                                                                                                                                                                                                                                                                                                                                                                                                                                          | E                                                                                                                                                                                                                                                                                                                                                                                                                                          | F                                                                                                                                                                                                                                                                                                                                                                                                                                          | G                                                                                                                                                                                                                                                                                                                                                                                                                                          | H                                                                                                                                                                                                                                                                                                                                                                   | I                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | J                               | K                                                                                                                                | L                                                                                                                                | M                                                                                                                                | N                              | O                                                                                                                                                |
|-----|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------|----------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------|--------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------|
| 1   | Soft-String Torque and Drag                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                            | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 2   | Blue cells on yellow are inputs. Enter the string, the mud, the rig and the friction factors, and overwrite the survey with yours.                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 3   | Drill String                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 4   | Drill pipe outside diameter                                                                                                                                                                             | 5                                                                                                                                                                                                                                                                                                                                                                                                                                          | in                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 5   | Drill pipe inside diameter                                                                                                                                                                              | 4.276                                                                                                                                                                                                                                                                                                                                                                                                                                      | in                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 6   | Drill pipe weight with its tool joints                                                                                                                                                                  | 22.6                                                                                                                                                                                                                                                                                                                                                                                                                                       | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 7   | Tool joint outside diameter (the torque radius)                                                                                                                                                         | 6.625                                                                                                                                                                                                                                                                                                                                                                                                                                      | in                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 8   | Drill pipe grade's minimum yield strength (G-105)                                                                                                                                                       | 105000                                                                                                                                                                                                                                                                                                                                                                                                                                     | psi                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 9   | Tool joints' make-up torque, the torque limit                                                                                                                                                           | 30000                                                                                                                                                                                                                                                                                                                                                                                                                                      | ft·lbf                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 10  | Bottomhole assembly length                                                                                                                                                                              | 600                                                                                                                                                                                                                                                                                                                                                                                                                                        | ft                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 11  | Drill collar outside diameter                                                                                                                                                                           | 6.5                                                                                                                                                                                                                                                                                                                                                                                                                                        | in                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 12  | Drill collar inside diameter                                                                                                                                                                            | 2.8125                                                                                                                                                                                                                                                                                                                                                                                                                                     | in                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 13  | Drill collar weight                                                                                                                                                                                     | 91                                                                                                                                                                                                                                                                                                                                                                                                                                         | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 14  | Hole, Mud, Rig and Friction                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 15  | Open-hole diameter at TD (the buckling clearance)                                                                                                                                                       | 8.5                                                                                                                                                                                                                                                                                                                                                                                                                                        | in                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 16  | Mud weight, inside and outside the string                                                                                                                                                               | 13.9                                                                                                                                                                                                                                                                                                                                                                                                                                       | ppg                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 17  | Travelling block and top drive weight                                                                                                                                                                   | 50000                                                                                                                                                                                                                                                                                                                                                                                                                                      | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 18  | Weight on bit while sliding                                                                                                                                                                             | 25000                                                                                                                                                                                                                                                                                                                                                                                                                                      | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 19  | Friction factor for the string with the bit at TD (the checks)                                                                                                                                          | 0.3                                                                                                                                                                                                                                                                                                                                                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 20  | Lowest chart friction factor (the legend names 0.2)                                                                                                                                                     | 0.2                                                                                                                                                                                                                                                                                                                                                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 21  | Middle chart friction factor (the legend names 0.3)                                                                                                                                                     | 0.3                                                                                                                                                                                                                                                                                                                                                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 22  | Highest chart friction factor (the legend names 0.4)                                                                                                                                                    | 0.4                                                                                                                                                                                                                                                                                                                                                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 23  | Tension design factor on the pipe's yield                                                                                                                                                               | 1.1                                                                                                                                                                                                                                                                                                                                                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 24  | Margin of overpull the pick-up must leave                                                                                                                                                               | 100000                                                                                                                                                                                                                                                                                                                                                                                                                                     | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 25  | Share of the make-up torque past which the torque warns                                                                                                                                                 | 0.8                                                                                                                                                                                                                                                                                                                                                                                                                                        | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 26  | Results with the Bit at TD (at the input friction factor)                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 27  | Buoyancy factor in the mud                                                                                                                                                                              | =INDEX(PO.DE.TD.Buoyancy(TQ_DpW,TQ_DpOD,TQ_DpID,TQ_MW,TQ_MW,TQ_Steel),1,1)                                                                                                                                                                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 28  | Buoyed weight of the drill pipe                                                                                                                                                                         | =INDEX(PO.DE.TD.Buoyancy(TQ_DpW,TQ_DpOD,TQ_DpID,TQ_MW,TQ_MW,TQ_Steel),1,2)                                                                                                                                                                                                                                                                                                                                                                 | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 29  | Buoyed weight of the collars                                                                                                                                                                            | =INDEX(PO.DE.TD.Buoyancy(TQ_BhaW,TQ_BhaOD,TQ_BhaID,TQ_MW,TQ_MW,TQ_Steel),1,2)                                                                                                                                                                                                                                                                                                                                                              | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 30  | Pick-up hook load (tripping out)                                                                                                                                                                        | =K57+TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                              | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 31  | Slack-off hook load (tripping in)                                                                                                                                                                       | =L57+TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                              | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 32  | Rotating off-bottom hook load                                                                                                                                                                           | =N57+TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                              | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 33  | Hook load sliding with the weight on bit                                                                                                                                                                | =M57+TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                              | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 34  | Drag picking up                                                                                                                                                                                         | =TQ_PickUp-TQ_Rotating                                                                                                                                                                                                                                                                                                                                                                                                                     | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 35  | Drag slacking off                                                                                                                                                                                       | =TQ_Rotating-TQ_SlackOff                                                                                                                                                                                                                                                                                                                                                                                                                   | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 36  | Surface torque rotating off bottom                                                                                                                                                                      | =O57                                                                                                                                                                                                                                                                                                                                                                                                                                       | ft·lbf                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 37  | Drill pipe body yield                                                                                                                                                                                   | =PO.DE.Casing.Axial.Yield(TQ_DpOD,(TQ_DpOD-TQ_DpID)/2,TQ_Yp)                                                                                                                                                                                                                                                                                                                                                                               | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 38  | Margin of overpull at the design factor                                                                                                                                                                 | =TQ_Yield/TQ_DFt-(TQ_PickUp-TQ_Block)                                                                                                                                                                                                                                                                                                                                                                                                      | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 39  | Stretch of the drill pipe under the required overpull                                                                                                                                                   | =PO.DE.TD.Stretch(TQ_MOP,0,A83-TQ_BhaL,TQ_DpOD,TQ_DpID,TQ_E)                                                                                                                                                                                                                                                                                                                                                                               | in                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 40  | Inclination at TD                                                                                                                                                                                       | =B83                                                                                                                                                                                                                                                                                                                                                                                                                                       | °                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 41  | Sinusoidal buckling load at TD (Dawson-Paslay)                                                                                                                                                          | =PO.DE.TD.Buckling.Sinusoidal(TQ_DpOD,TQ_DpID,TQ_Hole,TQ_WbDp,TQ_IncTD,TQ_E,0)                                                                                                                                                                                                                                                                                                                                                             | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 42  | Drill pipe helical buckling load at TD                                                                                                                                                                  | =PO.DE.TD.Buckling.Helical(TQ_DpOD,TQ_DpID,TQ_Hole,TQ_WbDp,TQ_IncTD,TQ_E,0)                                                                                                                                                                                                                                                                                                                                                                | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 43  | Axial force at the top of the collars, sliding                                                                                                                                                          | =-TQ_WOB+TQ_WbBha*TQ_BhaL*(COS(RADIANS(TQ_IncTD))-TQ_Mu*SIN(RADIANS(TQ_IncTD)))                                                                                                                                                                                                                                                                                                                                                            | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 44  | Lowest force on the drill pipe, sliding                                                                                                                                                                 | =MIN(TQ_FBha,MINIFS(M57:M83,A57:A83,"<="&(A83-TQ_BhaL)))                                                                                                                                                                                                                                                                                                                                                                                   | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 45  | Tension check                                                                                                                                                                                           | =IF(TQ_Overpull>=TQ_MOP,"PASS","FAIL")                                                                                                                                                                                                                                                                                                                                                                                                     | =IF(TQ_Overpull>=TQ_MOP,"the pick-up leaves "&TEXT(TQ_Overpull,"#,##0")&" lbf of overpull under the yield over its design factor","the pick-up leaves "&TEXT(TQ_Overpull,"#,##0")&" lbf of overpull, under the margin: a stronger grade or a lighter string")                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 46  | Torque check                                                                                                                                                                                            | =IF(TQ_Torque<=TQ_TorqueWarn*TQ_MakeUp,"PASS",IF(TQ_Torque<=TQ_MakeUp,"WARN","FAIL"))                                                                                                                                                                                                                                                                                                                                                      | =IF(TQ_Torque<=TQ_TorqueWarn*TQ_MakeUp,"the surface torque is under "&TEXT(TQ_TorqueWarn,"0%")&" of the make-up torque",IF(TQ_Torque<=TQ_MakeUp,"the surface torque is past "&TEXT(TQ_TorqueWarn,"0%")&" of the make-up torque","the surface torque is over the make-up torque: the joints can make up downhole"))                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 47  | Buckling check                                                                                                                                                                                          | =IF(TQ_Fmin>=-TQ_Fsin,"PASS",IF(TQ_Fmin>=-TQ_Fhel,"WARN","FAIL"))                                                                                                                                                                                                                                                                                                                                                                          | =IF(TQ_Fmin>=-TQ_Fsin,"the drill pipe stays under its sinusoidal buckling load while sliding",IF(TQ_Fmin>=-TQ_Fhel,"the drill pipe buckles sinusoidally while sliding: it drags more","the drill pipe buckles helically while sliding: it can lock up"))                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 48  | Sliding check                                                                                                                                                                                           | =IF(TQ_Sliding>TQ_Block,"PASS","FAIL")                                                                                                                                                                                                                                                                                                                                                                                                     | =IF(TQ_Sliding>TQ_Block,"the string still hangs from the hook while it puts the weight on bit down","the string can't slide the weight on bit down: it hangs up before the hook is slack")                                                                                                                                                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 50  | How to use it: overwrite the survey with the well's, take the weights and the make-up torque from the string's data sheets, and fit the friction factors to the hook loads and torques the rig records. |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 51  | The model is a soft string: no bending stiffness, no tool-joint contact, one friction factor along the whole hole.                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 52  | A shorter survey deletes rows from both tables; a longer one inserts rows inside them and copies the formulas down.                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 55  | Survey and the String with the Bit at TD (Johancsik Soft String)                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 56  | MD (ft)                                                                                                                                                                                                 | Inclination (°)                                                                                                                                                                                                                                                                                                                                                                                                                            | Azimuth (°)                                                                                                                                                                                                                                                                                                                                                                                                                                | Course (ft)                                                                                                                                                                                                                                                                                                                                                                                                                                | Mean inclination (°)                                                                                                                                                                                                                                                                                                                                                                                                                       | Inclination change (°)                                                                                                                                                                                                                                                                                                                                                                                                                     | Azimuth change (°)                                                                                                                                                                                                                                                                                                                                                                                                                         | TVD (ft)                                                                                                                                                                                                                                                                                                                                                            | Collar share (—)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Buoyed weight (lb/ft)           | Picking up (lbf)                                                                                                                 | Slacking off (lbf)                                                                                                               | Sliding (lbf)                                                                                                                    | Rotating (lbf)                 | Torque (ft·lbf)                                                                                                                                  |
| 57  | 0                                                                                                                                                                                                       | 0                                                                                                                                                                                                                                                                                                                                                                                                                                          | 45                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            | 0                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 | =K58+J58*D58*COS(RADIANS(E58))+TQ_Mu*SQRT((K58*RADIANS(G58)*SIN(RADIANS(E58)))^2+(K58*RADIANS(F58)+J58*D58*SIN(RADIANS(E58)))^2) | =L58+J58*D58*COS(RADIANS(E58))-TQ_Mu*SQRT((L58*RADIANS(G58)*SIN(RADIANS(E58)))^2+(L58*RADIANS(F58)+J58*D58*SIN(RADIANS(E58)))^2) | =M58+J58*D58*COS(RADIANS(E58))-TQ_Mu*SQRT((M58*RADIANS(G58)*SIN(RADIANS(E58)))^2+(M58*RADIANS(F58)+J58*D58*SIN(RADIANS(E58)))^2) | =N58+J58*D58*COS(RADIANS(E58)) | =O58+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I58)/TQ_DiaFt*SQRT((N58*RADIANS(G58)*SIN(RADIANS(E58)))^2+(N58*RADIANS(F58)+J58*D58*SIN(RADIANS(E58)))^2) |
| 58  | 500                                                                                                                                                                                                     | 0                                                                                                                                                                                                                                                                                                                                                                                                                                          | 45                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A58-A57                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B57+B58)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B57-B58                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C58-C57                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H57+D58*COS(RADIANS(E58))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D58,TQ_BhaL-(A$83-A58)))/D58                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I58 | =K59+J59*D59*COS(RADIANS(E59))+TQ_Mu*SQRT((K59*RADIANS(G59)*SIN(RADIANS(E59)))^2+(K59*RADIANS(F59)+J59*D59*SIN(RADIANS(E59)))^2) | =L59+J59*D59*COS(RADIANS(E59))-TQ_Mu*SQRT((L59*RADIANS(G59)*SIN(RADIANS(E59)))^2+(L59*RADIANS(F59)+J59*D59*SIN(RADIANS(E59)))^2) | =M59+J59*D59*COS(RADIANS(E59))-TQ_Mu*SQRT((M59*RADIANS(G59)*SIN(RADIANS(E59)))^2+(M59*RADIANS(F59)+J59*D59*SIN(RADIANS(E59)))^2) | =N59+J59*D59*COS(RADIANS(E59)) | =O59+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I59)/TQ_DiaFt*SQRT((N59*RADIANS(G59)*SIN(RADIANS(E59)))^2+(N59*RADIANS(F59)+J59*D59*SIN(RADIANS(E59)))^2) |
| 59  | 1000                                                                                                                                                                                                    | 0                                                                                                                                                                                                                                                                                                                                                                                                                                          | 45                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A59-A58                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B58+B59)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B58-B59                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C59-C58                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H58+D59*COS(RADIANS(E59))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D59,TQ_BhaL-(A$83-A59)))/D59                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I59 | =K60+J60*D60*COS(RADIANS(E60))+TQ_Mu*SQRT((K60*RADIANS(G60)*SIN(RADIANS(E60)))^2+(K60*RADIANS(F60)+J60*D60*SIN(RADIANS(E60)))^2) | =L60+J60*D60*COS(RADIANS(E60))-TQ_Mu*SQRT((L60*RADIANS(G60)*SIN(RADIANS(E60)))^2+(L60*RADIANS(F60)+J60*D60*SIN(RADIANS(E60)))^2) | =M60+J60*D60*COS(RADIANS(E60))-TQ_Mu*SQRT((M60*RADIANS(G60)*SIN(RADIANS(E60)))^2+(M60*RADIANS(F60)+J60*D60*SIN(RADIANS(E60)))^2) | =N60+J60*D60*COS(RADIANS(E60)) | =O60+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I60)/TQ_DiaFt*SQRT((N60*RADIANS(G60)*SIN(RADIANS(E60)))^2+(N60*RADIANS(F60)+J60*D60*SIN(RADIANS(E60)))^2) |
| 60  | 1500                                                                                                                                                                                                    | 0                                                                                                                                                                                                                                                                                                                                                                                                                                          | 45                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A60-A59                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B59+B60)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B59-B60                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C60-C59                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H59+D60*COS(RADIANS(E60))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D60,TQ_BhaL-(A$83-A60)))/D60                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I60 | =K61+J61*D61*COS(RADIANS(E61))+TQ_Mu*SQRT((K61*RADIANS(G61)*SIN(RADIANS(E61)))^2+(K61*RADIANS(F61)+J61*D61*SIN(RADIANS(E61)))^2) | =L61+J61*D61*COS(RADIANS(E61))-TQ_Mu*SQRT((L61*RADIANS(G61)*SIN(RADIANS(E61)))^2+(L61*RADIANS(F61)+J61*D61*SIN(RADIANS(E61)))^2) | =M61+J61*D61*COS(RADIANS(E61))-TQ_Mu*SQRT((M61*RADIANS(G61)*SIN(RADIANS(E61)))^2+(M61*RADIANS(F61)+J61*D61*SIN(RADIANS(E61)))^2) | =N61+J61*D61*COS(RADIANS(E61)) | =O61+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I61)/TQ_DiaFt*SQRT((N61*RADIANS(G61)*SIN(RADIANS(E61)))^2+(N61*RADIANS(F61)+J61*D61*SIN(RADIANS(E61)))^2) |
| 61  | 2000                                                                                                                                                                                                    | 0                                                                                                                                                                                                                                                                                                                                                                                                                                          | 45                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A61-A60                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B60+B61)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B60-B61                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C61-C60                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H60+D61*COS(RADIANS(E61))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D61,TQ_BhaL-(A$83-A61)))/D61                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I61 | =K62+J62*D62*COS(RADIANS(E62))+TQ_Mu*SQRT((K62*RADIANS(G62)*SIN(RADIANS(E62)))^2+(K62*RADIANS(F62)+J62*D62*SIN(RADIANS(E62)))^2) | =L62+J62*D62*COS(RADIANS(E62))-TQ_Mu*SQRT((L62*RADIANS(G62)*SIN(RADIANS(E62)))^2+(L62*RADIANS(F62)+J62*D62*SIN(RADIANS(E62)))^2) | =M62+J62*D62*COS(RADIANS(E62))-TQ_Mu*SQRT((M62*RADIANS(G62)*SIN(RADIANS(E62)))^2+(M62*RADIANS(F62)+J62*D62*SIN(RADIANS(E62)))^2) | =N62+J62*D62*COS(RADIANS(E62)) | =O62+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I62)/TQ_DiaFt*SQRT((N62*RADIANS(G62)*SIN(RADIANS(E62)))^2+(N62*RADIANS(F62)+J62*D62*SIN(RADIANS(E62)))^2) |
| 62  | 2500                                                                                                                                                                                                    | 10                                                                                                                                                                                                                                                                                                                                                                                                                                         | 45.75                                                                                                                                                                                                                                                                                                                                                                                                                                      | =A62-A61                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B61+B62)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B61-B62                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C62-C61                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H61+D62*COS(RADIANS(E62))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D62,TQ_BhaL-(A$83-A62)))/D62                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I62 | =K63+J63*D63*COS(RADIANS(E63))+TQ_Mu*SQRT((K63*RADIANS(G63)*SIN(RADIANS(E63)))^2+(K63*RADIANS(F63)+J63*D63*SIN(RADIANS(E63)))^2) | =L63+J63*D63*COS(RADIANS(E63))-TQ_Mu*SQRT((L63*RADIANS(G63)*SIN(RADIANS(E63)))^2+(L63*RADIANS(F63)+J63*D63*SIN(RADIANS(E63)))^2) | =M63+J63*D63*COS(RADIANS(E63))-TQ_Mu*SQRT((M63*RADIANS(G63)*SIN(RADIANS(E63)))^2+(M63*RADIANS(F63)+J63*D63*SIN(RADIANS(E63)))^2) | =N63+J63*D63*COS(RADIANS(E63)) | =O63+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I63)/TQ_DiaFt*SQRT((N63*RADIANS(G63)*SIN(RADIANS(E63)))^2+(N63*RADIANS(F63)+J63*D63*SIN(RADIANS(E63)))^2) |
| 63  | 3000                                                                                                                                                                                                    | 20                                                                                                                                                                                                                                                                                                                                                                                                                                         | 46.5                                                                                                                                                                                                                                                                                                                                                                                                                                       | =A63-A62                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B62+B63)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B62-B63                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C63-C62                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H62+D63*COS(RADIANS(E63))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D63,TQ_BhaL-(A$83-A63)))/D63                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I63 | =K64+J64*D64*COS(RADIANS(E64))+TQ_Mu*SQRT((K64*RADIANS(G64)*SIN(RADIANS(E64)))^2+(K64*RADIANS(F64)+J64*D64*SIN(RADIANS(E64)))^2) | =L64+J64*D64*COS(RADIANS(E64))-TQ_Mu*SQRT((L64*RADIANS(G64)*SIN(RADIANS(E64)))^2+(L64*RADIANS(F64)+J64*D64*SIN(RADIANS(E64)))^2) | =M64+J64*D64*COS(RADIANS(E64))-TQ_Mu*SQRT((M64*RADIANS(G64)*SIN(RADIANS(E64)))^2+(M64*RADIANS(F64)+J64*D64*SIN(RADIANS(E64)))^2) | =N64+J64*D64*COS(RADIANS(E64)) | =O64+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I64)/TQ_DiaFt*SQRT((N64*RADIANS(G64)*SIN(RADIANS(E64)))^2+(N64*RADIANS(F64)+J64*D64*SIN(RADIANS(E64)))^2) |
| 64  | 3500                                                                                                                                                                                                    | 30                                                                                                                                                                                                                                                                                                                                                                                                                                         | 47.25                                                                                                                                                                                                                                                                                                                                                                                                                                      | =A64-A63                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B63+B64)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B63-B64                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C64-C63                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H63+D64*COS(RADIANS(E64))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D64,TQ_BhaL-(A$83-A64)))/D64                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I64 | =K65+J65*D65*COS(RADIANS(E65))+TQ_Mu*SQRT((K65*RADIANS(G65)*SIN(RADIANS(E65)))^2+(K65*RADIANS(F65)+J65*D65*SIN(RADIANS(E65)))^2) | =L65+J65*D65*COS(RADIANS(E65))-TQ_Mu*SQRT((L65*RADIANS(G65)*SIN(RADIANS(E65)))^2+(L65*RADIANS(F65)+J65*D65*SIN(RADIANS(E65)))^2) | =M65+J65*D65*COS(RADIANS(E65))-TQ_Mu*SQRT((M65*RADIANS(G65)*SIN(RADIANS(E65)))^2+(M65*RADIANS(F65)+J65*D65*SIN(RADIANS(E65)))^2) | =N65+J65*D65*COS(RADIANS(E65)) | =O65+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I65)/TQ_DiaFt*SQRT((N65*RADIANS(G65)*SIN(RADIANS(E65)))^2+(N65*RADIANS(F65)+J65*D65*SIN(RADIANS(E65)))^2) |
| 65  | 4000                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A65-A64                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B64+B65)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B64-B65                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C65-C64                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H64+D65*COS(RADIANS(E65))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D65,TQ_BhaL-(A$83-A65)))/D65                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I65 | =K66+J66*D66*COS(RADIANS(E66))+TQ_Mu*SQRT((K66*RADIANS(G66)*SIN(RADIANS(E66)))^2+(K66*RADIANS(F66)+J66*D66*SIN(RADIANS(E66)))^2) | =L66+J66*D66*COS(RADIANS(E66))-TQ_Mu*SQRT((L66*RADIANS(G66)*SIN(RADIANS(E66)))^2+(L66*RADIANS(F66)+J66*D66*SIN(RADIANS(E66)))^2) | =M66+J66*D66*COS(RADIANS(E66))-TQ_Mu*SQRT((M66*RADIANS(G66)*SIN(RADIANS(E66)))^2+(M66*RADIANS(F66)+J66*D66*SIN(RADIANS(E66)))^2) | =N66+J66*D66*COS(RADIANS(E66)) | =O66+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I66)/TQ_DiaFt*SQRT((N66*RADIANS(G66)*SIN(RADIANS(E66)))^2+(N66*RADIANS(F66)+J66*D66*SIN(RADIANS(E66)))^2) |
| 66  | 4500                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A66-A65                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B65+B66)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B65-B66                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C66-C65                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H65+D66*COS(RADIANS(E66))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D66,TQ_BhaL-(A$83-A66)))/D66                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I66 | =K67+J67*D67*COS(RADIANS(E67))+TQ_Mu*SQRT((K67*RADIANS(G67)*SIN(RADIANS(E67)))^2+(K67*RADIANS(F67)+J67*D67*SIN(RADIANS(E67)))^2) | =L67+J67*D67*COS(RADIANS(E67))-TQ_Mu*SQRT((L67*RADIANS(G67)*SIN(RADIANS(E67)))^2+(L67*RADIANS(F67)+J67*D67*SIN(RADIANS(E67)))^2) | =M67+J67*D67*COS(RADIANS(E67))-TQ_Mu*SQRT((M67*RADIANS(G67)*SIN(RADIANS(E67)))^2+(M67*RADIANS(F67)+J67*D67*SIN(RADIANS(E67)))^2) | =N67+J67*D67*COS(RADIANS(E67)) | =O67+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I67)/TQ_DiaFt*SQRT((N67*RADIANS(G67)*SIN(RADIANS(E67)))^2+(N67*RADIANS(F67)+J67*D67*SIN(RADIANS(E67)))^2) |
| 67  | 5000                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A67-A66                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B66+B67)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B66-B67                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C67-C66                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H66+D67*COS(RADIANS(E67))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D67,TQ_BhaL-(A$83-A67)))/D67                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I67 | =K68+J68*D68*COS(RADIANS(E68))+TQ_Mu*SQRT((K68*RADIANS(G68)*SIN(RADIANS(E68)))^2+(K68*RADIANS(F68)+J68*D68*SIN(RADIANS(E68)))^2) | =L68+J68*D68*COS(RADIANS(E68))-TQ_Mu*SQRT((L68*RADIANS(G68)*SIN(RADIANS(E68)))^2+(L68*RADIANS(F68)+J68*D68*SIN(RADIANS(E68)))^2) | =M68+J68*D68*COS(RADIANS(E68))-TQ_Mu*SQRT((M68*RADIANS(G68)*SIN(RADIANS(E68)))^2+(M68*RADIANS(F68)+J68*D68*SIN(RADIANS(E68)))^2) | =N68+J68*D68*COS(RADIANS(E68)) | =O68+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I68)/TQ_DiaFt*SQRT((N68*RADIANS(G68)*SIN(RADIANS(E68)))^2+(N68*RADIANS(F68)+J68*D68*SIN(RADIANS(E68)))^2) |
| 68  | 5500                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A68-A67                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B67+B68)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B67-B68                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C68-C67                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H67+D68*COS(RADIANS(E68))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D68,TQ_BhaL-(A$83-A68)))/D68                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I68 | =K69+J69*D69*COS(RADIANS(E69))+TQ_Mu*SQRT((K69*RADIANS(G69)*SIN(RADIANS(E69)))^2+(K69*RADIANS(F69)+J69*D69*SIN(RADIANS(E69)))^2) | =L69+J69*D69*COS(RADIANS(E69))-TQ_Mu*SQRT((L69*RADIANS(G69)*SIN(RADIANS(E69)))^2+(L69*RADIANS(F69)+J69*D69*SIN(RADIANS(E69)))^2) | =M69+J69*D69*COS(RADIANS(E69))-TQ_Mu*SQRT((M69*RADIANS(G69)*SIN(RADIANS(E69)))^2+(M69*RADIANS(F69)+J69*D69*SIN(RADIANS(E69)))^2) | =N69+J69*D69*COS(RADIANS(E69)) | =O69+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I69)/TQ_DiaFt*SQRT((N69*RADIANS(G69)*SIN(RADIANS(E69)))^2+(N69*RADIANS(F69)+J69*D69*SIN(RADIANS(E69)))^2) |
| 69  | 6000                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A69-A68                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B68+B69)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B68-B69                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C69-C68                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H68+D69*COS(RADIANS(E69))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D69,TQ_BhaL-(A$83-A69)))/D69                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I69 | =K70+J70*D70*COS(RADIANS(E70))+TQ_Mu*SQRT((K70*RADIANS(G70)*SIN(RADIANS(E70)))^2+(K70*RADIANS(F70)+J70*D70*SIN(RADIANS(E70)))^2) | =L70+J70*D70*COS(RADIANS(E70))-TQ_Mu*SQRT((L70*RADIANS(G70)*SIN(RADIANS(E70)))^2+(L70*RADIANS(F70)+J70*D70*SIN(RADIANS(E70)))^2) | =M70+J70*D70*COS(RADIANS(E70))-TQ_Mu*SQRT((M70*RADIANS(G70)*SIN(RADIANS(E70)))^2+(M70*RADIANS(F70)+J70*D70*SIN(RADIANS(E70)))^2) | =N70+J70*D70*COS(RADIANS(E70)) | =O70+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I70)/TQ_DiaFt*SQRT((N70*RADIANS(G70)*SIN(RADIANS(E70)))^2+(N70*RADIANS(F70)+J70*D70*SIN(RADIANS(E70)))^2) |
| 70  | 6500                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A70-A69                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B69+B70)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B69-B70                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C70-C69                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H69+D70*COS(RADIANS(E70))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D70,TQ_BhaL-(A$83-A70)))/D70                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I70 | =K71+J71*D71*COS(RADIANS(E71))+TQ_Mu*SQRT((K71*RADIANS(G71)*SIN(RADIANS(E71)))^2+(K71*RADIANS(F71)+J71*D71*SIN(RADIANS(E71)))^2) | =L71+J71*D71*COS(RADIANS(E71))-TQ_Mu*SQRT((L71*RADIANS(G71)*SIN(RADIANS(E71)))^2+(L71*RADIANS(F71)+J71*D71*SIN(RADIANS(E71)))^2) | =M71+J71*D71*COS(RADIANS(E71))-TQ_Mu*SQRT((M71*RADIANS(G71)*SIN(RADIANS(E71)))^2+(M71*RADIANS(F71)+J71*D71*SIN(RADIANS(E71)))^2) | =N71+J71*D71*COS(RADIANS(E71)) | =O71+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I71)/TQ_DiaFt*SQRT((N71*RADIANS(G71)*SIN(RADIANS(E71)))^2+(N71*RADIANS(F71)+J71*D71*SIN(RADIANS(E71)))^2) |
| 71  | 7000                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A71-A70                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B70+B71)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B70-B71                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C71-C70                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H70+D71*COS(RADIANS(E71))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D71,TQ_BhaL-(A$83-A71)))/D71                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I71 | =K72+J72*D72*COS(RADIANS(E72))+TQ_Mu*SQRT((K72*RADIANS(G72)*SIN(RADIANS(E72)))^2+(K72*RADIANS(F72)+J72*D72*SIN(RADIANS(E72)))^2) | =L72+J72*D72*COS(RADIANS(E72))-TQ_Mu*SQRT((L72*RADIANS(G72)*SIN(RADIANS(E72)))^2+(L72*RADIANS(F72)+J72*D72*SIN(RADIANS(E72)))^2) | =M72+J72*D72*COS(RADIANS(E72))-TQ_Mu*SQRT((M72*RADIANS(G72)*SIN(RADIANS(E72)))^2+(M72*RADIANS(F72)+J72*D72*SIN(RADIANS(E72)))^2) | =N72+J72*D72*COS(RADIANS(E72)) | =O72+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I72)/TQ_DiaFt*SQRT((N72*RADIANS(G72)*SIN(RADIANS(E72)))^2+(N72*RADIANS(F72)+J72*D72*SIN(RADIANS(E72)))^2) |
| 72  | 7500                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A72-A71                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B71+B72)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B71-B72                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C72-C71                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H71+D72*COS(RADIANS(E72))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D72,TQ_BhaL-(A$83-A72)))/D72                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I72 | =K73+J73*D73*COS(RADIANS(E73))+TQ_Mu*SQRT((K73*RADIANS(G73)*SIN(RADIANS(E73)))^2+(K73*RADIANS(F73)+J73*D73*SIN(RADIANS(E73)))^2) | =L73+J73*D73*COS(RADIANS(E73))-TQ_Mu*SQRT((L73*RADIANS(G73)*SIN(RADIANS(E73)))^2+(L73*RADIANS(F73)+J73*D73*SIN(RADIANS(E73)))^2) | =M73+J73*D73*COS(RADIANS(E73))-TQ_Mu*SQRT((M73*RADIANS(G73)*SIN(RADIANS(E73)))^2+(M73*RADIANS(F73)+J73*D73*SIN(RADIANS(E73)))^2) | =N73+J73*D73*COS(RADIANS(E73)) | =O73+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I73)/TQ_DiaFt*SQRT((N73*RADIANS(G73)*SIN(RADIANS(E73)))^2+(N73*RADIANS(F73)+J73*D73*SIN(RADIANS(E73)))^2) |
| 73  | 8000                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A73-A72                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B72+B73)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B72-B73                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C73-C72                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H72+D73*COS(RADIANS(E73))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D73,TQ_BhaL-(A$83-A73)))/D73                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I73 | =K74+J74*D74*COS(RADIANS(E74))+TQ_Mu*SQRT((K74*RADIANS(G74)*SIN(RADIANS(E74)))^2+(K74*RADIANS(F74)+J74*D74*SIN(RADIANS(E74)))^2) | =L74+J74*D74*COS(RADIANS(E74))-TQ_Mu*SQRT((L74*RADIANS(G74)*SIN(RADIANS(E74)))^2+(L74*RADIANS(F74)+J74*D74*SIN(RADIANS(E74)))^2) | =M74+J74*D74*COS(RADIANS(E74))-TQ_Mu*SQRT((M74*RADIANS(G74)*SIN(RADIANS(E74)))^2+(M74*RADIANS(F74)+J74*D74*SIN(RADIANS(E74)))^2) | =N74+J74*D74*COS(RADIANS(E74)) | =O74+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I74)/TQ_DiaFt*SQRT((N74*RADIANS(G74)*SIN(RADIANS(E74)))^2+(N74*RADIANS(F74)+J74*D74*SIN(RADIANS(E74)))^2) |
| 74  | 8500                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A74-A73                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B73+B74)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B73-B74                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C74-C73                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H73+D74*COS(RADIANS(E74))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D74,TQ_BhaL-(A$83-A74)))/D74                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I74 | =K75+J75*D75*COS(RADIANS(E75))+TQ_Mu*SQRT((K75*RADIANS(G75)*SIN(RADIANS(E75)))^2+(K75*RADIANS(F75)+J75*D75*SIN(RADIANS(E75)))^2) | =L75+J75*D75*COS(RADIANS(E75))-TQ_Mu*SQRT((L75*RADIANS(G75)*SIN(RADIANS(E75)))^2+(L75*RADIANS(F75)+J75*D75*SIN(RADIANS(E75)))^2) | =M75+J75*D75*COS(RADIANS(E75))-TQ_Mu*SQRT((M75*RADIANS(G75)*SIN(RADIANS(E75)))^2+(M75*RADIANS(F75)+J75*D75*SIN(RADIANS(E75)))^2) | =N75+J75*D75*COS(RADIANS(E75)) | =O75+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I75)/TQ_DiaFt*SQRT((N75*RADIANS(G75)*SIN(RADIANS(E75)))^2+(N75*RADIANS(F75)+J75*D75*SIN(RADIANS(E75)))^2) |
| 75  | 9000                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A75-A74                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B74+B75)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B74-B75                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C75-C74                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H74+D75*COS(RADIANS(E75))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D75,TQ_BhaL-(A$83-A75)))/D75                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I75 | =K76+J76*D76*COS(RADIANS(E76))+TQ_Mu*SQRT((K76*RADIANS(G76)*SIN(RADIANS(E76)))^2+(K76*RADIANS(F76)+J76*D76*SIN(RADIANS(E76)))^2) | =L76+J76*D76*COS(RADIANS(E76))-TQ_Mu*SQRT((L76*RADIANS(G76)*SIN(RADIANS(E76)))^2+(L76*RADIANS(F76)+J76*D76*SIN(RADIANS(E76)))^2) | =M76+J76*D76*COS(RADIANS(E76))-TQ_Mu*SQRT((M76*RADIANS(G76)*SIN(RADIANS(E76)))^2+(M76*RADIANS(F76)+J76*D76*SIN(RADIANS(E76)))^2) | =N76+J76*D76*COS(RADIANS(E76)) | =O76+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I76)/TQ_DiaFt*SQRT((N76*RADIANS(G76)*SIN(RADIANS(E76)))^2+(N76*RADIANS(F76)+J76*D76*SIN(RADIANS(E76)))^2) |
| 76  | 9500                                                                                                                                                                                                    | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A76-A75                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B75+B76)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B75-B76                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C76-C75                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H75+D76*COS(RADIANS(E76))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D76,TQ_BhaL-(A$83-A76)))/D76                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I76 | =K77+J77*D77*COS(RADIANS(E77))+TQ_Mu*SQRT((K77*RADIANS(G77)*SIN(RADIANS(E77)))^2+(K77*RADIANS(F77)+J77*D77*SIN(RADIANS(E77)))^2) | =L77+J77*D77*COS(RADIANS(E77))-TQ_Mu*SQRT((L77*RADIANS(G77)*SIN(RADIANS(E77)))^2+(L77*RADIANS(F77)+J77*D77*SIN(RADIANS(E77)))^2) | =M77+J77*D77*COS(RADIANS(E77))-TQ_Mu*SQRT((M77*RADIANS(G77)*SIN(RADIANS(E77)))^2+(M77*RADIANS(F77)+J77*D77*SIN(RADIANS(E77)))^2) | =N77+J77*D77*COS(RADIANS(E77)) | =O77+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I77)/TQ_DiaFt*SQRT((N77*RADIANS(G77)*SIN(RADIANS(E77)))^2+(N77*RADIANS(F77)+J77*D77*SIN(RADIANS(E77)))^2) |
| 77  | 10000                                                                                                                                                                                                   | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A77-A76                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B76+B77)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B76-B77                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C77-C76                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H76+D77*COS(RADIANS(E77))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D77,TQ_BhaL-(A$83-A77)))/D77                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I77 | =K78+J78*D78*COS(RADIANS(E78))+TQ_Mu*SQRT((K78*RADIANS(G78)*SIN(RADIANS(E78)))^2+(K78*RADIANS(F78)+J78*D78*SIN(RADIANS(E78)))^2) | =L78+J78*D78*COS(RADIANS(E78))-TQ_Mu*SQRT((L78*RADIANS(G78)*SIN(RADIANS(E78)))^2+(L78*RADIANS(F78)+J78*D78*SIN(RADIANS(E78)))^2) | =M78+J78*D78*COS(RADIANS(E78))-TQ_Mu*SQRT((M78*RADIANS(G78)*SIN(RADIANS(E78)))^2+(M78*RADIANS(F78)+J78*D78*SIN(RADIANS(E78)))^2) | =N78+J78*D78*COS(RADIANS(E78)) | =O78+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I78)/TQ_DiaFt*SQRT((N78*RADIANS(G78)*SIN(RADIANS(E78)))^2+(N78*RADIANS(F78)+J78*D78*SIN(RADIANS(E78)))^2) |
| 78  | 10500                                                                                                                                                                                                   | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A78-A77                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B77+B78)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B77-B78                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C78-C77                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H77+D78*COS(RADIANS(E78))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D78,TQ_BhaL-(A$83-A78)))/D78                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I78 | =K79+J79*D79*COS(RADIANS(E79))+TQ_Mu*SQRT((K79*RADIANS(G79)*SIN(RADIANS(E79)))^2+(K79*RADIANS(F79)+J79*D79*SIN(RADIANS(E79)))^2) | =L79+J79*D79*COS(RADIANS(E79))-TQ_Mu*SQRT((L79*RADIANS(G79)*SIN(RADIANS(E79)))^2+(L79*RADIANS(F79)+J79*D79*SIN(RADIANS(E79)))^2) | =M79+J79*D79*COS(RADIANS(E79))-TQ_Mu*SQRT((M79*RADIANS(G79)*SIN(RADIANS(E79)))^2+(M79*RADIANS(F79)+J79*D79*SIN(RADIANS(E79)))^2) | =N79+J79*D79*COS(RADIANS(E79)) | =O79+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I79)/TQ_DiaFt*SQRT((N79*RADIANS(G79)*SIN(RADIANS(E79)))^2+(N79*RADIANS(F79)+J79*D79*SIN(RADIANS(E79)))^2) |
| 79  | 11000                                                                                                                                                                                                   | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A79-A78                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B78+B79)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B78-B79                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C79-C78                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H78+D79*COS(RADIANS(E79))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D79,TQ_BhaL-(A$83-A79)))/D79                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I79 | =K80+J80*D80*COS(RADIANS(E80))+TQ_Mu*SQRT((K80*RADIANS(G80)*SIN(RADIANS(E80)))^2+(K80*RADIANS(F80)+J80*D80*SIN(RADIANS(E80)))^2) | =L80+J80*D80*COS(RADIANS(E80))-TQ_Mu*SQRT((L80*RADIANS(G80)*SIN(RADIANS(E80)))^2+(L80*RADIANS(F80)+J80*D80*SIN(RADIANS(E80)))^2) | =M80+J80*D80*COS(RADIANS(E80))-TQ_Mu*SQRT((M80*RADIANS(G80)*SIN(RADIANS(E80)))^2+(M80*RADIANS(F80)+J80*D80*SIN(RADIANS(E80)))^2) | =N80+J80*D80*COS(RADIANS(E80)) | =O80+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I80)/TQ_DiaFt*SQRT((N80*RADIANS(G80)*SIN(RADIANS(E80)))^2+(N80*RADIANS(F80)+J80*D80*SIN(RADIANS(E80)))^2) |
| 80  | 11500                                                                                                                                                                                                   | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A80-A79                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B79+B80)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B79-B80                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C80-C79                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H79+D80*COS(RADIANS(E80))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D80,TQ_BhaL-(A$83-A80)))/D80                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I80 | =K81+J81*D81*COS(RADIANS(E81))+TQ_Mu*SQRT((K81*RADIANS(G81)*SIN(RADIANS(E81)))^2+(K81*RADIANS(F81)+J81*D81*SIN(RADIANS(E81)))^2) | =L81+J81*D81*COS(RADIANS(E81))-TQ_Mu*SQRT((L81*RADIANS(G81)*SIN(RADIANS(E81)))^2+(L81*RADIANS(F81)+J81*D81*SIN(RADIANS(E81)))^2) | =M81+J81*D81*COS(RADIANS(E81))-TQ_Mu*SQRT((M81*RADIANS(G81)*SIN(RADIANS(E81)))^2+(M81*RADIANS(F81)+J81*D81*SIN(RADIANS(E81)))^2) | =N81+J81*D81*COS(RADIANS(E81)) | =O81+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I81)/TQ_DiaFt*SQRT((N81*RADIANS(G81)*SIN(RADIANS(E81)))^2+(N81*RADIANS(F81)+J81*D81*SIN(RADIANS(E81)))^2) |
| 81  | 12000                                                                                                                                                                                                   | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A81-A80                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B80+B81)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B80-B81                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C81-C80                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H80+D81*COS(RADIANS(E81))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D81,TQ_BhaL-(A$83-A81)))/D81                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I81 | =K82+J82*D82*COS(RADIANS(E82))+TQ_Mu*SQRT((K82*RADIANS(G82)*SIN(RADIANS(E82)))^2+(K82*RADIANS(F82)+J82*D82*SIN(RADIANS(E82)))^2) | =L82+J82*D82*COS(RADIANS(E82))-TQ_Mu*SQRT((L82*RADIANS(G82)*SIN(RADIANS(E82)))^2+(L82*RADIANS(F82)+J82*D82*SIN(RADIANS(E82)))^2) | =M82+J82*D82*COS(RADIANS(E82))-TQ_Mu*SQRT((M82*RADIANS(G82)*SIN(RADIANS(E82)))^2+(M82*RADIANS(F82)+J82*D82*SIN(RADIANS(E82)))^2) | =N82+J82*D82*COS(RADIANS(E82)) | =O82+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I82)/TQ_DiaFt*SQRT((N82*RADIANS(G82)*SIN(RADIANS(E82)))^2+(N82*RADIANS(F82)+J82*D82*SIN(RADIANS(E82)))^2) |
| 82  | 12500                                                                                                                                                                                                   | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A82-A81                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B81+B82)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B81-B82                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C82-C81                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H81+D82*COS(RADIANS(E82))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D82,TQ_BhaL-(A$83-A82)))/D82                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I82 | =K83+J83*D83*COS(RADIANS(E83))+TQ_Mu*SQRT((K83*RADIANS(G83)*SIN(RADIANS(E83)))^2+(K83*RADIANS(F83)+J83*D83*SIN(RADIANS(E83)))^2) | =L83+J83*D83*COS(RADIANS(E83))-TQ_Mu*SQRT((L83*RADIANS(G83)*SIN(RADIANS(E83)))^2+(L83*RADIANS(F83)+J83*D83*SIN(RADIANS(E83)))^2) | =M83+J83*D83*COS(RADIANS(E83))-TQ_Mu*SQRT((M83*RADIANS(G83)*SIN(RADIANS(E83)))^2+(M83*RADIANS(F83)+J83*D83*SIN(RADIANS(E83)))^2) | =N83+J83*D83*COS(RADIANS(E83)) | =O83+TQ_Mu*(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*I83)/TQ_DiaFt*SQRT((N83*RADIANS(G83)*SIN(RADIANS(E83)))^2+(N83*RADIANS(F83)+J83*D83*SIN(RADIANS(E83)))^2) |
| 83  | 13000                                                                                                                                                                                                   | 40                                                                                                                                                                                                                                                                                                                                                                                                                                         | 48                                                                                                                                                                                                                                                                                                                                                                                                                                         | =A83-A82                                                                                                                                                                                                                                                                                                                                                                                                                                   | =(B82+B83)/2                                                                                                                                                                                                                                                                                                                                                                                                                               | =B82-B83                                                                                                                                                                                                                                                                                                                                                                                                                                   | =C83-C82                                                                                                                                                                                                                                                                                                                                                                                                                                   | =H82+D83*COS(RADIANS(E83))                                                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(D83,TQ_BhaL-(A$83-A83)))/D83                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TQ_WbDp+(TQ_WbBha-TQ_WbDp)*I83 | =0                                                                                                                               | =0                                                                                                                               | =-TQ_WOB                                                                                                                         | =0                             | =0                                                                                                                                               |
| 86  | Hook Load and Surface Torque by Bit Depth                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 87  | Bit depth MD (ft)                                                                                                                                                                                       | Out, FF 0.2 (lbf)                                                                                                                                                                                                                                                                                                                                                                                                                          | In, FF 0.2 (lbf)                                                                                                                                                                                                                                                                                                                                                                                                                           | Out, FF 0.3 (lbf)                                                                                                                                                                                                                                                                                                                                                                                                                          | In, FF 0.3 (lbf)                                                                                                                                                                                                                                                                                                                                                                                                                           | Out, FF 0.4 (lbf)                                                                                                                                                                                                                                                                                                                                                                                                                          | In, FF 0.4 (lbf)                                                                                                                                                                                                                                                                                                                                                                                                                           | Rotating (lbf)                                                                                                                                                                                                                                                                                                                                                      | Torque per FF (ft·lbf)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Torque, FF 0.2 (ft·lbf)         | Torque, FF 0.3 (ft·lbf)                                                                                                          | Torque, FF 0.4 (ft·lbf)                                                                                                          |                                                                                                                                  |                                |                                                                                                                                                  |
| 88  | =A57                                                                                                                                                                                                    | =TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                                  | =TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                                  | =TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                                  | =TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                                  | =TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                                  | =TQ_Block                                                                                                                                                                                                                                                                                                                                                                                                                                  | =TQ_Block                                                                                                                                                                                                                                                                                                                                                           | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | =TQ_Mu1*I88                     | =TQ_Mu2*I88                                                                                                                      | =TQ_Mu3*I88                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 89  | =A58                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(1),LAMBDA(force,step,LET(elem,1+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(1),LAMBDA(force,step,LET(elem,1+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(1),LAMBDA(force,step,LET(elem,1+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(1),LAMBDA(force,step,LET(elem,1+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(1),LAMBDA(force,step,LET(elem,1+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(1),LAMBDA(force,step,LET(elem,1+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(1),LAMBDA(force,step,LET(elem,1+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(1),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A89-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A89-low<=TQ_BhaL,TQ_WbBha*(H58-INDEX($H$58:$H$83,elem)),H89-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I89                     | =TQ_Mu2*I89                                                                                                                      | =TQ_Mu3*I89                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 90  | =A59                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(2),LAMBDA(force,step,LET(elem,2+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(2),LAMBDA(force,step,LET(elem,2+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(2),LAMBDA(force,step,LET(elem,2+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(2),LAMBDA(force,step,LET(elem,2+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(2),LAMBDA(force,step,LET(elem,2+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(2),LAMBDA(force,step,LET(elem,2+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(2),LAMBDA(force,step,LET(elem,2+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(2),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A90-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A90-low<=TQ_BhaL,TQ_WbBha*(H59-INDEX($H$58:$H$83,elem)),H90-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I90                     | =TQ_Mu2*I90                                                                                                                      | =TQ_Mu3*I90                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 91  | =A60                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(3),LAMBDA(force,step,LET(elem,3+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(3),LAMBDA(force,step,LET(elem,3+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(3),LAMBDA(force,step,LET(elem,3+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(3),LAMBDA(force,step,LET(elem,3+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(3),LAMBDA(force,step,LET(elem,3+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(3),LAMBDA(force,step,LET(elem,3+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(3),LAMBDA(force,step,LET(elem,3+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(3),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A91-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A91-low<=TQ_BhaL,TQ_WbBha*(H60-INDEX($H$58:$H$83,elem)),H91-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I91                     | =TQ_Mu2*I91                                                                                                                      | =TQ_Mu3*I91                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 92  | =A61                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(4),LAMBDA(force,step,LET(elem,4+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(4),LAMBDA(force,step,LET(elem,4+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(4),LAMBDA(force,step,LET(elem,4+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(4),LAMBDA(force,step,LET(elem,4+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(4),LAMBDA(force,step,LET(elem,4+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(4),LAMBDA(force,step,LET(elem,4+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(4),LAMBDA(force,step,LET(elem,4+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(4),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A92-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A92-low<=TQ_BhaL,TQ_WbBha*(H61-INDEX($H$58:$H$83,elem)),H92-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I92                     | =TQ_Mu2*I92                                                                                                                      | =TQ_Mu3*I92                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 93  | =A62                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(5),LAMBDA(force,step,LET(elem,5+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(5),LAMBDA(force,step,LET(elem,5+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(5),LAMBDA(force,step,LET(elem,5+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(5),LAMBDA(force,step,LET(elem,5+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(5),LAMBDA(force,step,LET(elem,5+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(5),LAMBDA(force,step,LET(elem,5+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(5),LAMBDA(force,step,LET(elem,5+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(5),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A93-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A93-low<=TQ_BhaL,TQ_WbBha*(H62-INDEX($H$58:$H$83,elem)),H93-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I93                     | =TQ_Mu2*I93                                                                                                                      | =TQ_Mu3*I93                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 94  | =A63                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(6),LAMBDA(force,step,LET(elem,6+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(6),LAMBDA(force,step,LET(elem,6+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(6),LAMBDA(force,step,LET(elem,6+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(6),LAMBDA(force,step,LET(elem,6+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(6),LAMBDA(force,step,LET(elem,6+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(6),LAMBDA(force,step,LET(elem,6+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(6),LAMBDA(force,step,LET(elem,6+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(6),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A94-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A94-low<=TQ_BhaL,TQ_WbBha*(H63-INDEX($H$58:$H$83,elem)),H94-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I94                     | =TQ_Mu2*I94                                                                                                                      | =TQ_Mu3*I94                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 95  | =A64                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(7),LAMBDA(force,step,LET(elem,7+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(7),LAMBDA(force,step,LET(elem,7+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(7),LAMBDA(force,step,LET(elem,7+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(7),LAMBDA(force,step,LET(elem,7+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(7),LAMBDA(force,step,LET(elem,7+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(7),LAMBDA(force,step,LET(elem,7+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(7),LAMBDA(force,step,LET(elem,7+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(7),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A95-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A95-low<=TQ_BhaL,TQ_WbBha*(H64-INDEX($H$58:$H$83,elem)),H95-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I95                     | =TQ_Mu2*I95                                                                                                                      | =TQ_Mu3*I95                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 96  | =A65                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(8),LAMBDA(force,step,LET(elem,8+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(8),LAMBDA(force,step,LET(elem,8+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(8),LAMBDA(force,step,LET(elem,8+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(8),LAMBDA(force,step,LET(elem,8+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(8),LAMBDA(force,step,LET(elem,8+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(8),LAMBDA(force,step,LET(elem,8+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(8),LAMBDA(force,step,LET(elem,8+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(8),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A96-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A96-low<=TQ_BhaL,TQ_WbBha*(H65-INDEX($H$58:$H$83,elem)),H96-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I96                     | =TQ_Mu2*I96                                                                                                                      | =TQ_Mu3*I96                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 97  | =A66                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(9),LAMBDA(force,step,LET(elem,9+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(9),LAMBDA(force,step,LET(elem,9+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(9),LAMBDA(force,step,LET(elem,9+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(9),LAMBDA(force,step,LET(elem,9+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(9),LAMBDA(force,step,LET(elem,9+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(9),LAMBDA(force,step,LET(elem,9+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))    | =TQ_Block+REDUCE(0,SEQUENCE(9),LAMBDA(force,step,LET(elem,9+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))    | =REDUCE(0,SEQUENCE(9),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A97-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A97-low<=TQ_BhaL,TQ_WbBha*(H66-INDEX($H$58:$H$83,elem)),H97-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))     | =TQ_Mu1*I97                     | =TQ_Mu2*I97                                                                                                                      | =TQ_Mu3*I97                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 98  | =A67                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(10),LAMBDA(force,step,LET(elem,10+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(10),LAMBDA(force,step,LET(elem,10+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(10),LAMBDA(force,step,LET(elem,10+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(10),LAMBDA(force,step,LET(elem,10+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(10),LAMBDA(force,step,LET(elem,10+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(10),LAMBDA(force,step,LET(elem,10+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(10),LAMBDA(force,step,LET(elem,10+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))  | =REDUCE(0,SEQUENCE(10),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A98-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A98-low<=TQ_BhaL,TQ_WbBha*(H67-INDEX($H$58:$H$83,elem)),H98-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))    | =TQ_Mu1*I98                     | =TQ_Mu2*I98                                                                                                                      | =TQ_Mu3*I98                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 99  | =A68                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(11),LAMBDA(force,step,LET(elem,11+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(11),LAMBDA(force,step,LET(elem,11+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(11),LAMBDA(force,step,LET(elem,11+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(11),LAMBDA(force,step,LET(elem,11+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(11),LAMBDA(force,step,LET(elem,11+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(11),LAMBDA(force,step,LET(elem,11+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2))))  | =TQ_Block+REDUCE(0,SEQUENCE(11),LAMBDA(force,step,LET(elem,11+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc))))  | =REDUCE(0,SEQUENCE(11),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A99-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A99-low<=TQ_BhaL,TQ_WbBha*(H68-INDEX($H$58:$H$83,elem)),H99-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2))))    | =TQ_Mu1*I99                     | =TQ_Mu2*I99                                                                                                                      | =TQ_Mu3*I99                                                                                                                      |                                                                                                                                  |                                |                                                                                                                                                  |
| 100 | =A69                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(12),LAMBDA(force,step,LET(elem,12+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(12),LAMBDA(force,step,LET(elem,12+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(12),LAMBDA(force,step,LET(elem,12+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(12),LAMBDA(force,step,LET(elem,12+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(12),LAMBDA(force,step,LET(elem,12+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(12),LAMBDA(force,step,LET(elem,12+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(12),LAMBDA(force,step,LET(elem,12+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(12),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A100-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A100-low<=TQ_BhaL,TQ_WbBha*(H69-INDEX($H$58:$H$83,elem)),H100-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I100                    | =TQ_Mu2*I100                                                                                                                     | =TQ_Mu3*I100                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 101 | =A70                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(13),LAMBDA(force,step,LET(elem,13+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(13),LAMBDA(force,step,LET(elem,13+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(13),LAMBDA(force,step,LET(elem,13+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(13),LAMBDA(force,step,LET(elem,13+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(13),LAMBDA(force,step,LET(elem,13+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(13),LAMBDA(force,step,LET(elem,13+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(13),LAMBDA(force,step,LET(elem,13+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(13),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A101-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A101-low<=TQ_BhaL,TQ_WbBha*(H70-INDEX($H$58:$H$83,elem)),H101-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I101                    | =TQ_Mu2*I101                                                                                                                     | =TQ_Mu3*I101                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 102 | =A71                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(14),LAMBDA(force,step,LET(elem,14+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(14),LAMBDA(force,step,LET(elem,14+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(14),LAMBDA(force,step,LET(elem,14+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(14),LAMBDA(force,step,LET(elem,14+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(14),LAMBDA(force,step,LET(elem,14+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(14),LAMBDA(force,step,LET(elem,14+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(14),LAMBDA(force,step,LET(elem,14+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(14),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A102-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A102-low<=TQ_BhaL,TQ_WbBha*(H71-INDEX($H$58:$H$83,elem)),H102-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I102                    | =TQ_Mu2*I102                                                                                                                     | =TQ_Mu3*I102                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 103 | =A72                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(15),LAMBDA(force,step,LET(elem,15+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(15),LAMBDA(force,step,LET(elem,15+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(15),LAMBDA(force,step,LET(elem,15+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(15),LAMBDA(force,step,LET(elem,15+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(15),LAMBDA(force,step,LET(elem,15+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(15),LAMBDA(force,step,LET(elem,15+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(15),LAMBDA(force,step,LET(elem,15+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(15),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A103-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A103-low<=TQ_BhaL,TQ_WbBha*(H72-INDEX($H$58:$H$83,elem)),H103-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I103                    | =TQ_Mu2*I103                                                                                                                     | =TQ_Mu3*I103                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 104 | =A73                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(16),LAMBDA(force,step,LET(elem,16+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(16),LAMBDA(force,step,LET(elem,16+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(16),LAMBDA(force,step,LET(elem,16+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(16),LAMBDA(force,step,LET(elem,16+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(16),LAMBDA(force,step,LET(elem,16+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(16),LAMBDA(force,step,LET(elem,16+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(16),LAMBDA(force,step,LET(elem,16+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(16),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A104-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A104-low<=TQ_BhaL,TQ_WbBha*(H73-INDEX($H$58:$H$83,elem)),H104-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I104                    | =TQ_Mu2*I104                                                                                                                     | =TQ_Mu3*I104                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 105 | =A74                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(17),LAMBDA(force,step,LET(elem,17+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(17),LAMBDA(force,step,LET(elem,17+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(17),LAMBDA(force,step,LET(elem,17+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(17),LAMBDA(force,step,LET(elem,17+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(17),LAMBDA(force,step,LET(elem,17+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(17),LAMBDA(force,step,LET(elem,17+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(17),LAMBDA(force,step,LET(elem,17+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(17),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A105-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A105-low<=TQ_BhaL,TQ_WbBha*(H74-INDEX($H$58:$H$83,elem)),H105-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I105                    | =TQ_Mu2*I105                                                                                                                     | =TQ_Mu3*I105                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 106 | =A75                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(18),LAMBDA(force,step,LET(elem,18+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(18),LAMBDA(force,step,LET(elem,18+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(18),LAMBDA(force,step,LET(elem,18+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(18),LAMBDA(force,step,LET(elem,18+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(18),LAMBDA(force,step,LET(elem,18+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(18),LAMBDA(force,step,LET(elem,18+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(18),LAMBDA(force,step,LET(elem,18+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(18),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A106-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A106-low<=TQ_BhaL,TQ_WbBha*(H75-INDEX($H$58:$H$83,elem)),H106-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I106                    | =TQ_Mu2*I106                                                                                                                     | =TQ_Mu3*I106                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 107 | =A76                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(19),LAMBDA(force,step,LET(elem,19+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(19),LAMBDA(force,step,LET(elem,19+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(19),LAMBDA(force,step,LET(elem,19+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(19),LAMBDA(force,step,LET(elem,19+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(19),LAMBDA(force,step,LET(elem,19+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(19),LAMBDA(force,step,LET(elem,19+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(19),LAMBDA(force,step,LET(elem,19+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(19),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A107-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A107-low<=TQ_BhaL,TQ_WbBha*(H76-INDEX($H$58:$H$83,elem)),H107-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I107                    | =TQ_Mu2*I107                                                                                                                     | =TQ_Mu3*I107                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 108 | =A77                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(20),LAMBDA(force,step,LET(elem,20+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(20),LAMBDA(force,step,LET(elem,20+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(20),LAMBDA(force,step,LET(elem,20+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(20),LAMBDA(force,step,LET(elem,20+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(20),LAMBDA(force,step,LET(elem,20+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(20),LAMBDA(force,step,LET(elem,20+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(20),LAMBDA(force,step,LET(elem,20+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(20),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A108-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A108-low<=TQ_BhaL,TQ_WbBha*(H77-INDEX($H$58:$H$83,elem)),H108-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I108                    | =TQ_Mu2*I108                                                                                                                     | =TQ_Mu3*I108                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 109 | =A78                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(21),LAMBDA(force,step,LET(elem,21+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(21),LAMBDA(force,step,LET(elem,21+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(21),LAMBDA(force,step,LET(elem,21+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(21),LAMBDA(force,step,LET(elem,21+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(21),LAMBDA(force,step,LET(elem,21+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(21),LAMBDA(force,step,LET(elem,21+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(21),LAMBDA(force,step,LET(elem,21+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(21),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A109-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A109-low<=TQ_BhaL,TQ_WbBha*(H78-INDEX($H$58:$H$83,elem)),H109-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I109                    | =TQ_Mu2*I109                                                                                                                     | =TQ_Mu3*I109                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 110 | =A79                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(22),LAMBDA(force,step,LET(elem,22+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(22),LAMBDA(force,step,LET(elem,22+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(22),LAMBDA(force,step,LET(elem,22+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(22),LAMBDA(force,step,LET(elem,22+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(22),LAMBDA(force,step,LET(elem,22+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(22),LAMBDA(force,step,LET(elem,22+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(22),LAMBDA(force,step,LET(elem,22+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(22),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A110-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A110-low<=TQ_BhaL,TQ_WbBha*(H79-INDEX($H$58:$H$83,elem)),H110-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I110                    | =TQ_Mu2*I110                                                                                                                     | =TQ_Mu3*I110                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 111 | =A80                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(23),LAMBDA(force,step,LET(elem,23+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(23),LAMBDA(force,step,LET(elem,23+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(23),LAMBDA(force,step,LET(elem,23+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(23),LAMBDA(force,step,LET(elem,23+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(23),LAMBDA(force,step,LET(elem,23+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(23),LAMBDA(force,step,LET(elem,23+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(23),LAMBDA(force,step,LET(elem,23+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(23),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A111-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A111-low<=TQ_BhaL,TQ_WbBha*(H80-INDEX($H$58:$H$83,elem)),H111-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I111                    | =TQ_Mu2*I111                                                                                                                     | =TQ_Mu3*I111                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 112 | =A81                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(24),LAMBDA(force,step,LET(elem,24+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(24),LAMBDA(force,step,LET(elem,24+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(24),LAMBDA(force,step,LET(elem,24+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(24),LAMBDA(force,step,LET(elem,24+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(24),LAMBDA(force,step,LET(elem,24+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(24),LAMBDA(force,step,LET(elem,24+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(24),LAMBDA(force,step,LET(elem,24+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(24),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A112-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A112-low<=TQ_BhaL,TQ_WbBha*(H81-INDEX($H$58:$H$83,elem)),H112-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I112                    | =TQ_Mu2*I112                                                                                                                     | =TQ_Mu3*I112                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 113 | =A82                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(25),LAMBDA(force,step,LET(elem,25+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(25),LAMBDA(force,step,LET(elem,25+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(25),LAMBDA(force,step,LET(elem,25+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(25),LAMBDA(force,step,LET(elem,25+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(25),LAMBDA(force,step,LET(elem,25+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(25),LAMBDA(force,step,LET(elem,25+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(25),LAMBDA(force,step,LET(elem,25+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(25),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A113-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A113-low<=TQ_BhaL,TQ_WbBha*(H82-INDEX($H$58:$H$83,elem)),H113-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I113                    | =TQ_Mu2*I113                                                                                                                     | =TQ_Mu3*I113                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 114 | =A83                                                                                                                                                                                                    | =TQ_Block+REDUCE(0,SEQUENCE(26),LAMBDA(force,step,LET(elem,26+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(26),LAMBDA(force,step,LET(elem,26+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu1*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(26),LAMBDA(force,step,LET(elem,26+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(26),LAMBDA(force,step,LET(elem,26+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu2*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(26),LAMBDA(force,step,LET(elem,26+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)+TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(26),LAMBDA(force,step,LET(elem,26+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)-TQ_Mu3*SQRT((force*dazi*SIN(inc))^2+(force*dinc+wt*course*SIN(inc))^2)))) | =TQ_Block+REDUCE(0,SEQUENCE(26),LAMBDA(force,step,LET(elem,26+1-step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),force+wt*course*COS(inc)))) | =REDUCE(0,SEQUENCE(26),LAMBDA(moment,step,LET(elem,step,course,INDEX($D$58:$D$83,elem),low,INDEX($A$58:$A$83,elem),share,MAX(0,MIN(course,TQ_BhaL-(A114-low)))/course,wt,TQ_WbDp+(TQ_WbBha-TQ_WbDp)*share,inc,RADIANS(INDEX($E$58:$E$83,elem)),dinc,RADIANS(INDEX($F$58:$F$83,elem)),dazi,RADIANS(INDEX($G$58:$G$83,elem)),below,IF(A114-low<=TQ_BhaL,TQ_WbBha*(H83-INDEX($H$58:$H$83,elem)),H114-TQ_Block-TQ_WbDp*INDEX($H$58:$H$83,elem)),arm,(TQ_TjOD+(TQ_BhaOD-TQ_TjOD)*share)/TQ_DiaFt,moment+arm*SQRT((below*dazi*SIN(inc))^2+(below*dinc+wt*course*SIN(inc))^2)))) | =TQ_Mu1*I114                    | =TQ_Mu2*I114                                                                                                                     | =TQ_Mu3*I114                                                                                                                     |                                                                                                                                  |                                |                                                                                                                                                  |
| 116 | Constants                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 117 | Density of steel                                                                                                                                                                                        | 65.5                                                                                                                                                                                                                                                                                                                                                                                                                                       | ppg                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 118 | Young's modulus of steel                                                                                                                                                                                | 30000000                                                                                                                                                                                                                                                                                                                                                                                                                                   | psi                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |
| 119 | Inches of diameter in a foot of radius                                                                                                                                                                  | 24                                                                                                                                                                                                                                                                                                                                                                                                                                         | in/ft                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                 |                                                                                                                                  |                                                                                                                                  |                                                                                                                                  |                                |                                                                                                                                                  |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.DE.TD.Buoyancy | =LAMBDA(PipeW_lbft, PipeOD_in, PipeID_in, MWi_ppg, MWo_ppg, RhoSteel_ppg, LET(bf, 1 - (MWo_ppg*PipeOD_in^2 - MWi_ppg*PipeID_in^2) / (RhoSteel_ppg*(PipeOD_in^2 - PipeID_in^2)), HSTACK(bf, PipeW_lbft*bf))) | Buoyancy factor of a pipe with different fluids inside and outside, and its buoyed weight per foot: {BF, lb/ft}. |
| PO.DE.Casing.Axial.Yield | =LAMBDA(BodyOD_in, BodyWall_in, BodyYp_psi, PI()/4*(BodyOD_in^2-(BodyOD_in-2*BodyWall_in)^2)*BodyYp_psi) | API TR 5C3 pipe-body yield strength, Fy = (pi/4)(D^2 - d^2) Yp, [lbf]. |
| PO.DE.TD.Stretch | =LAMBDA(F_lbf, W_lbft, L_ft, OD_in, ID_in, E_psi, 12*L_ft*(F_lbf + W_lbft*L_ft/2) / (E_psi*PI()/4*(OD_in^2 - ID_in^2))) | Hooke stretch of a pipe string, in., under an end load plus its own weight: 12 L (F + w L / 2) / (E As). |
| PO.DE.TD.Buckling.Sinusoidal | =LAMBDA(OD_in, ID_in, Dh_in, Wb_lbft, Inc_deg, E_psi, Mode, LET(mi, PI()/64*(OD_in^4 - ID_in^4), wpi, Wb_lbft/12, IF(Mode=1, 1.94*(E_psi*mi*wpi^2)^(1/3), 2*SQRT(E_psi*mi*wpi*SIN(RADIANS(Inc_deg))/((Dh_in - OD_in)/2))))) | Sinusoidal buckling load, lbf: Dawson-Paslay in an inclined hole (Mode 0) or Lubinski 1.94 (EI w^2)^(1/3) in a vertical one (Mode 1). |
| PO.DE.TD.Buckling.Helical | =LAMBDA(OD_in, ID_in, Dh_in, Wb_lbft, Inc_deg, E_psi, Mode, LET(mi, PI()/64*(OD_in^4 - ID_in^4), wpi, Wb_lbft/12, IF(Mode=1, 5.55*(E_psi*mi*wpi^2)^(1/3), 2*SQRT(2)*SQRT(E_psi*mi*wpi*SIN(RADIANS(Inc_deg))/((Dh_in - OD_in)/2))))) | Helical buckling load, lbf: the square root of 2 times Dawson-Paslay in an inclined hole (Mode 0) or 5.55 (EI w^2)^(1/3) in a vertical one (Mode 1). |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| TQ_DpOD | $B$4 | Drill pipe outside diameter, in |
| TQ_DpID | $B$5 | Drill pipe inside diameter, in |
| TQ_DpW | $B$6 | Drill pipe weight with its tool joints, lb/ft |
| TQ_TjOD | $B$7 | Tool joint outside diameter (the torque radius), in |
| TQ_Yp | $B$8 | Drill pipe grade's minimum yield strength (G-105), psi |
| TQ_MakeUp | $B$9 | Tool joints' make-up torque, the torque limit, ft·lbf |
| TQ_BhaL | $B$10 | Bottomhole assembly length, ft |
| TQ_BhaOD | $B$11 | Drill collar outside diameter, in |
| TQ_BhaID | $B$12 | Drill collar inside diameter, in |
| TQ_BhaW | $B$13 | Drill collar weight, lb/ft |
| TQ_Hole | $B$15 | Open-hole diameter at TD (the buckling clearance), in |
| TQ_MW | $B$16 | Mud weight, inside and outside the string, ppg |
| TQ_Block | $B$17 | Travelling block and top drive weight, lbf |
| TQ_WOB | $B$18 | Weight on bit while sliding, lbf |
| TQ_Mu | $B$19 | Friction factor for the string with the bit at TD (the checks) |
| TQ_Mu1 | $B$20 | Lowest chart friction factor (the legend names 0.2) |
| TQ_Mu2 | $B$21 | Middle chart friction factor (the legend names 0.3) |
| TQ_Mu3 | $B$22 | Highest chart friction factor (the legend names 0.4) |
| TQ_DFt | $B$23 | Tension design factor on the pipe's yield |
| TQ_MOP | $B$24 | Margin of overpull the pick-up must leave, lbf |
| TQ_TorqueWarn | $B$25 | Share of the make-up torque past which the torque warns, % |
| TQ_Inputs | $B$4:$B$25 | The drill pipe, its tool joints, grade and make-up torque, the collars, the hole, the mud, the block weight, the weight on bit, the friction factors, the tension design factor, the margin of overpull and the torque warning share |
| TQ_BF | $B$27 | Buoyancy factor in the mud |
| TQ_WbDp | $B$28 | Buoyed weight of the drill pipe, lb/ft |
| TQ_WbBha | $B$29 | Buoyed weight of the collars, lb/ft |
| TQ_PickUp | $B$30 | Pick-up hook load (tripping out), lbf |
| TQ_SlackOff | $B$31 | Slack-off hook load (tripping in), lbf |
| TQ_Rotating | $B$32 | Rotating off-bottom hook load, lbf |
| TQ_Sliding | $B$33 | Hook load sliding with the weight on bit, lbf |
| TQ_DragOut | $B$34 | Drag picking up, lbf |
| TQ_DragIn | $B$35 | Drag slacking off, lbf |
| TQ_Torque | $B$36 | Surface torque rotating off bottom, ft·lbf |
| TQ_Yield | $B$37 | Drill pipe body yield, lbf |
| TQ_Overpull | $B$38 | Margin of overpull at the design factor, lbf |
| TQ_Stretch | $B$39 | Stretch of the drill pipe under the required overpull, in |
| TQ_IncTD | $B$40 | Inclination at TD, ° |
| TQ_Fsin | $B$41 | Sinusoidal buckling load at TD (Dawson-Paslay), lbf |
| TQ_Fhel | $B$42 | Drill pipe helical buckling load at TD, lbf |
| TQ_FBha | $B$43 | Axial force at the top of the collars, sliding, lbf |
| TQ_Fmin | $B$44 | Lowest force on the drill pipe, sliding, lbf |
| TQ_TensionCheck | $B$45 | Tension check verdict |
| TQ_TensionCheckNote | $C$45 | Tension check comment |
| TQ_TorqueCheck | $B$46 | Torque check verdict |
| TQ_TorqueCheckNote | $C$46 | Torque check comment |
| TQ_BucklingCheck | $B$47 | Buckling check verdict |
| TQ_BucklingCheckNote | $C$47 | Buckling check comment |
| TQ_SlideCheck | $B$48 | Sliding check verdict |
| TQ_SlideCheckNote | $C$48 | Sliding check comment |
| TQ_Results | $B$27:$B$48 | The buoyed weights, the hook loads with the bit at TD, the drags, the surface torque, the pipe's yield and the margin of overpull, the stretch, the buckling loads, the lowest force sliding, and the four checks |
| TQ_Survey | $A$57:$C$83 | Survey stations: measured depth, inclination, azimuth |
| TQ_March | $D$57:$O$83 | Each course's length, angles, vertical depth, collar share and buoyed weight, and the forces and torque with the bit at TD |
| TQ_Curve | $A$88:$L$114 | Each bit depth's hook load tripping out and in at the three friction factors and rotating, its torque per unit friction factor, and its surface torque at the three |
| TQ_Steel | $B$117 | Density of steel, ppg |
| TQ_E | $B$118 | Young's modulus of steel, psi |
| TQ_DiaFt | $B$119 | Inches of diameter in a foot of radius, in/ft |

---

## Related Blueprints
- [Casing Design](/blueprint/po.de.casing.design.md)
- [BOP Accumulator Sizing](/blueprint/po.de.wellcontrol.accumulator.md)
- [Surge and Swab Trip Speed](/blueprint/po.de.surge.swab.md)
- [Hole Cleaning and Solids Control](/blueprint/po.de.holecleaning.solids.md)
- [Well Control Kill Sheet](/blueprint/po.de.wellcontrol.killsheet.md)
- [Primary Cement Job Design](/blueprint/po.de.cement.volumes.md)

