{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["0_Instructions","1_Inputs","2_Connection","3_Results","4_VME_data plot","4_VME_Plot screen"],"not_rendered":{"charts":3,"defined_names":12},"unopened":[{"sheet":"4_VME_Plot screen","index":5,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"0_Instructions","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"merged":[[1,0,1,3],[17,0,17,3]]}
[]
["CASING DESIGN LIMIT CHECK – based on v6 (Quadratic VME) + revisions + CwD/SET overload cases"]
["Revision 6H | 18 Aug 2026 | Builds on v6 quadratic method, flexible Inputs, casing reminders"]
[]
["METHOD (from v6)"]
["Ellipse generated by solving the von Mises quadratic:  σa² + σh² – σa·σh = Yp²"]
["For each Axial Force, the two ΔP branches (upper & lower) are calculated → classic inclined shape."]
["Connection shown as rectangular cut-offs (factored tension / compression / Pi / Pe) on the same axes."]
["CwD and SET modes amplify the applied loads; Design Factors stay constant. Overload cases are provided that exceed weaker casing/thread envelopes."]
[]
["HOW TO USE"]
["1. Sheet 1_Inputs – select casing (or Custom), set Mode (Standard / CwD / SET), enter base loads and DFs"]
["2. Sheet 2_Connection – select connection or Custom"]
["3. Sheet 3_Results – review SF and PASS/FAIL for pipe and connection"]
["4. Sheet 4_VME_Plot – quadratic points + connection rectangle + overload markers (CwD / SET)"]
["Casing under study is recalled at the top of each calculation sheet."]
[]
["FULL REVISION LOG"]
["Rev","Date","Change attempted","Result / note"]
["FINAL","18 Aug","Screening Excel + classic Python VME plot","Companion tools"]
["7–10","17–18 Aug","Toggle / both-ellipses experiments","Abandoned for production; v6 quadratic kept as reference"]
["6H","18 Aug","THIS FILE – v6 base + revision log + CwD/SET overload cases that exceed weaker envelopes","Current"]
["6","17 Aug","Quadratic VME solution + flexible Inputs","Best mathematical basis; user extended with VLOOKUP-style selection"]
["5","17 Aug","Normalized parametric + Units toggle","Tilt still weak / toggle fragile"]
["4","17 Aug","Parametric inclined ellipse + connection envelope","Ellipse collapsed to line in real units"]
["3","17 Aug","Casing example selector + VME chart","OK"]
["2","17 Aug","Connection tab + typical connections","OK"]
["1","17 Aug","First Design Limit Check (pipe body only)","Baseline"]

{"sheet":"1_Inputs","index":1,"n_rows":56,"n_cols":5,"rows_kept":56,"merged":[[2,0,2,2],[47,0,47,4],[55,0,55,4]]}
["TUBULAR DATA & LOAD CASE"]
[]
["EXAMPLE CASING"]
["Select example","7in 29ppf L80","Changing this updates OD / t / Yp below"]
[]
["Database"]
["Casing","OD (in)","t (in)","Yp (psi)"]
["7in 29ppf L80",{"v":7,"d":"7.000"},0.408,{"v":80000,"d":"80,000"}]
["7in 32ppf P110",{"v":7,"d":"7.000"},0.453,{"v":110000,"d":"110,000"}]
["9-5/8in 47ppf L80",9.625,0.472,{"v":80000,"d":"80,000"}]
["9-5/8in 53.5ppf P110",9.625,0.545,{"v":110000,"d":"110,000"}]
["13-3/8in 68ppf K55",13.375,{"v":0.48,"d":"0.480"},{"v":55000,"d":"55,000"}]
["CUSTOM",{"v":7,"d":"7.000"},0.408,{"v":80000,"d":"80,000"}]
[]
["MODE"]
["Application Mode","Standard"]
["Amplification",{"$f":"IF(B16=\"Standard\",1,IF(B16=\"CwD\",1.35,1.25))","v":{"v":1,"d":"1.00"}},"CwD 1.35 | SET 1.25 (screening hypothesis)"]
[]
["ACTIVE TUBULAR (auto from selector or Custom)",{"$f":"'1_Inputs'!$B$4","v":"7in 29ppf L80"}]
["OD (in)",{"$f":"VLOOKUP($B$4,casingfull,2,0)","v":{"v":7,"d":"7.000"}}]
["t (in)",{"$f":"VLOOKUP($B$4,casingfull,3,0)","v":0.408}]
["ID (in)",{"$f":"B20-2*B21","v":6.184}]
["Yp (psi)",{"$f":"VLOOKUP($B$4,casingfull,4,0)","v":{"v":80000,"d":"80,000"}}]
["Area (in²)",{"$f":"(PI()/4)*(B20^2-B22^2)","v":{"v":8.449426539165279,"d":"8.449"}}]
["Fa_yield (lbf)",{"$f":"B23*B24","v":{"v":675954.1231332223,"d":"675,954"}}]
["pb Barlow (psi)",{"$f":"0.875*2*B23*B21/B20","v":{"v":8159.999999999999,"d":"8,160.0"}}]
[]
["CUSTOM (when Casing = Custom)"]
["Custom OD (in)",{"v":7,"d":"7.000"}]
["Custom t (in)",0.408]
["Custom Yp (psi)",{"v":80000,"d":"80,000"}]
[]
["BASE LOAD CASE +"]
["Axial Force (lbf) [+ = tension]",{"v":150000,"d":"150,000"}]
["Pi (psi)",{"v":5000,"d":"5,000"}]
["Pe (psi)",{"v":2000,"d":"2,000"}]
["ΔP (psi)",{"$f":"B35-B36","v":{"v":3000,"d":"3,000"}}]
["Amplified Axial (lbf)",{"$f":"B34*B17","v":{"v":150000,"d":"150,000"}}]
["Amplified ΔP (psi)",{"$f":"B37*B17","v":{"v":3000,"d":"3,000"}}]
[]
["PIPE DF"]
["DF Burst",{"v":1.1,"d":"1.10"}]
["DF Collapse",{"v":1,"d":"1.00"}]
["DF Axial T",{"v":1.6,"d":"1.60"}]
["DF Axial C",{"v":1.3,"d":"1.30"}]
["DF Triaxial",1.25]
[]
["OVERLOAD CASES (for visualisation – exceed weaker casing/thread)"]
["Case","Fa (lbf)","ΔP (psi)","Amplified Fa","Amplified ΔP"]
["Service – normal",{"v":120000,"d":"120,000"},{"v":4000,"d":"4,000"},{"$f":"B50*$B$17","v":{"v":120000,"d":"120,000"}},{"v":4000,"d":"4,000"}]
["CwD – elevated torque/drag",{"v":320000,"d":"320,000"},{"v":9000,"d":"9,000"},{"v":320000,"d":"320,000"},{"v":9000,"d":"9,000"}]
["CwD – severe (exceeds L80/BTC)",{"v":480000,"d":"480,000"},{"v":12000,"d":"12,000"},{"v":480000,"d":"480,000"},{"v":12000,"d":"12,000"}]
["SET – post-expansion residual",{"v":200000,"d":"200,000"},{"v":7000,"d":"7,000"},{"v":200000,"d":"200,000"},{"v":7000,"d":"7,000"}]
["SET – expansion peak (severe)",{"v":420000,"d":"420,000"},{"v":11000,"d":"11,000"},{"v":420000,"d":"420,000"},{"v":11000,"d":"11,000"}]
[]
["Note: CwD severe and SET expansion peak are sized to fall outside typical L80 + BTC envelopes while remaining inside high-capacity P110 + premium envelopes."]

{"sheet":"2_Connection","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[6,0,6,4]]}
[]
["CONNECTION SELECTION"]
[{"$f":"\"Casing under study: \"&'1_Inputs'!B4","v":"Casing under study: 7in 29ppf L80"}]
[null,{"$f":"'1_Inputs'!$B$4","v":"7in 29ppf L80"}]
["Connection choice","BTC (standard)"]
[]
["TYPICAL DATABASE (illustrative)"]
["Type","Tension (lbf)","Compression (lbf)","Pi (psi)","Pe (psi)"]
["BTC (standard)",{"v":450000,"d":"450,000"},{"v":380000,"d":"380,000"},{"v":5500,"d":"5,500"},{"v":4500,"d":"4,500"}]
["Premium Metal-to-Metal",{"v":580000,"d":"580,000"},{"v":520000,"d":"520,000"},{"v":7500,"d":"7,500"},{"v":6000,"d":"6,000"}]
["High-Torque Expandable",{"v":400000,"d":"400,000"},{"v":360000,"d":"360,000"},{"v":5000,"d":"5,000"},{"v":4000,"d":"4,000"}]
["Custom connection",{"v":500000,"d":"500,000"},{"v":450000,"d":"450,000"},{"v":6500,"d":"6,500"},{"v":5000,"d":"5,000"}]
[]
["ACTIVE VALUES"]
["Tension (lbf)",{"$f":"VLOOKUP($B$5,connectionfull,2,0)","v":{"v":450000,"d":"450,000"}}]
["Compression (lbf)",{"$f":"VLOOKUP($B$5,connectionfull,3,0)","v":{"v":380000,"d":"380,000"}}]
["Pi (psi)",{"$f":"VLOOKUP($B$5,connectionfull,4,0)","v":{"v":5500,"d":"5,500"}}]
["Pe (psi)",{"$f":"VLOOKUP($B$5,connectionfull,5,0)","v":{"v":4500,"d":"4,500"}}]
[]
["CUSTOM"]
["Custom Tension",{"v":500000,"d":"500,000"}]
["Custom Compression",{"v":450000,"d":"450,000"}]
["Custom Pi",{"v":6500,"d":"6,500"}]
["Custom Pe",{"v":5000,"d":"5,000"}]
[]
["CONNECTION DF"]
["DF Tension",{"v":1.6,"d":"1.60"}]
["DF Compression",{"v":1.4,"d":"1.40"}]
["DF Pressure",1.25]

{"sheet":"3_Results","index":3,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[2,0,2,4]]}
[]
["RESULTS – PIPE + CONNECTION"]
[{"$f":"\"Casing under study: \"&'1_Inputs'!B4&\"  |  Mode: \"&'1_Inputs'!B16&\"  |  Connection: \"&'2_Connection'!B5","v":"Casing under study: 7in 29ppf L80  |  Mode: Standard  |  Connection: BTC (standard)"}]
[null,{"$f":"'1_Inputs'!$B$4","v":"7in 29ppf L80"}]
["Pipe Burst (psi)",{"$f":"'1_Inputs'!B26","v":{"v":8159.999999999999,"d":"8,160.0"}}]
["Pipe Axial Yield (lbf)",{"$f":"'1_Inputs'!B25","v":{"v":675954.1231332223,"d":"675,954"}}]
["Amplified Axial",{"$f":"'1_Inputs'!B38","v":{"v":150000,"d":"150,000"}}]
["Amplified ΔP",{"$f":"'1_Inputs'!B39","v":{"v":3000,"d":"3,000"}}]
[]
["PIPE SF"]
["Burst SF",{"$f":"IF(B8=0,\"n/a\",B5/ABS(B8))","v":{"v":2.7199999999999998,"d":"2.72"}},{"$f":"'1_Inputs'!B42","v":1.1},{"$f":"IF(B11=\"n/a\",\"n/a\",IF(B11>=C11,\"PASS\",\"FAIL\"))","v":"PASS"}]
["Axial SF",{"$f":"IF(B7=0,\"n/a\",B6/ABS(B7))","v":{"v":4.5063608208881485,"d":"4.51"}},{"$f":"IF(B7>=0,'1_Inputs'!B44,'1_Inputs'!B45)","v":1.6},{"$f":"IF(B12=\"n/a\",\"n/a\",IF(B12>=C12,\"PASS\",\"FAIL\"))","v":"PASS"}]
[]
["CONNECTION SF",{"$f":"'2_Connection'!$B$5","v":"BTC (standard)"}]
["Conn Tension SF",{"$f":"IF(B7<=0,\"n/a\",'2_Connection'!B15/ABS(B7))","v":{"v":3,"d":"3.00"}},{"$f":"'2_Connection'!B27","v":1.6},{"$f":"IF(B15=\"n/a\",\"n/a\",IF(B15>=C15,\"PASS\",\"FAIL\"))","v":"PASS"}]
["Conn Pressure SF",{"$f":"IF(B8=0,\"n/a\",IF(B8>0,'2_Connection'!B17/ABS(B8),'2_Connection'!B18/ABS(B8)))","v":{"v":1.8333333333333333,"d":"1.83"}},{"$f":"'2_Connection'!B29","v":1.25},{"$f":"IF(B16=\"n/a\",\"n/a\",IF(B16>=C16,\"PASS\",\"FAIL\"))","v":"PASS"}]
[]
["FINAL",{"$f":"IF(AND(OR(D11=\"PASS\",D11=\"n/a\"),OR(D12=\"PASS\",D12=\"n/a\"),OR(D15=\"PASS\",D15=\"n/a\"),OR(D16=\"PASS\",D16=\"n/a\")),\"ACCEPTABLE\",\"NOT ACCEPTABLE\")","v":"ACCEPTABLE"}]

{"sheet":"4_VME_data plot","index":4,"n_rows":89,"n_cols":11,"rows_kept":89,"merged":[[1,0,1,6],[2,0,2,6],[30,2,30,8],[74,2,74,4]]}
[]
["VME DESIGN LIMIT PLOT – Quadratic solution + CwD/SET overload markers"]
[{"$f":"\"Casing: \"&'1_Inputs'!B4&\"  |  Mode: \"&'1_Inputs'!B16&\"  |  Connection: \"&'2_Connection'!B5","v":"Casing: 7in 29ppf L80  |  Mode: Standard  |  Connection: BTC (standard)"}]
[]
["Pipe parameters",{"$f":"'1_Inputs'!$B$4","v":"7in 29ppf L80"}]
["Yp (psi)",{"$f":"'1_Inputs'!B23","v":{"v":80000,"d":"80,000"}}]
["Area (in²)",{"$f":"'1_Inputs'!B24","v":{"v":8.449426539165279,"d":"8.449"}}]
["Fa_yield (lbf)",{"$f":"'1_Inputs'!B25","v":{"v":675954.1231332223,"d":"675,954"}}]
["pb (psi)",{"$f":"'1_Inputs'!B26","v":{"v":8159.999999999999,"d":"8,160.0"}}]
["DF triaxial",{"$f":"'1_Inputs'!B46","v":1.25}]
["OD (in)",{"$f":"'1_Inputs'!B20","v":{"v":7,"d":"7.000"}}]
["t (in)",{"$f":"'1_Inputs'!B21","v":0.408}]
[]
["Connection cut-offs (factored)",{"$f":"'2_Connection'!$B$5","v":"BTC (standard)"}]
["Conn T (lbf)",{"$f":"'2_Connection'!B15/'2_Connection'!B27","v":{"v":281250,"d":"281,250"}}]
["Conn C (lbf)",{"$f":"-'2_Connection'!B16/'2_Connection'!B28","v":{"v":-271428.5714285714,"d":"-271,429"}}]
["Conn Pi (psi)",{"$f":"'2_Connection'!B17/'2_Connection'!B29","v":{"v":4400,"d":"4,400.0"}}]
["Conn Pe (psi)",{"$f":"-'2_Connection'!B18/'2_Connection'!B29","v":{"v":-3600,"d":"-3,600.0"}}]
{"$rows_empty":12}
[null,null,"QUADRATIC VME POINTS (exact solution)"]
[null,null,"i","Fa_lbf","sigma_a","Disc","DP_upper","DP_lower","Fa_DF","DP_up_DF","DP_lo_DF"]
[null,null,{"v":0,"d":"0.0"},{"$f":"-1*$B$8","v":{"v":-675954.1231332223,"d":"-675954.1"}},{"$f":"D33/$B$7","v":{"v":-80000,"d":"-80000.0"}},{"$f":"4*$B$6^2-3*E33^2","v":{"v":6400000000,"d":"6400000000.0"}},{"$f":"IF(F33<0,NA(),((E33+SQRT(F33))/2)*(2*$B$12/$B$11))","v":{"v":0,"d":"0.0"}},{"$f":"IF(F33<0,NA(),((E33-SQRT(F33))/2)*(2*$B$12/$B$11))","v":{"v":-9325.714285714284,"d":"-9325.7"}},{"$f":"D33/$B$10","v":{"v":-540763.2985065778,"d":"-540763.3"}},{"$f":"G33/$B$10","v":{"v":0,"d":"0.0"}},{"$f":"H33/$B$10","v":{"v":-7460.5714285714275,"d":"-7460.6"}}]
[null,null,{"v":1,"d":"1.0"},{"$f":"-0.95*$B$8","v":{"v":-642156.4169765612,"d":"-642156.4"}},{"v":-76000,"d":"-76000.0"},{"v":8272000000,"d":"8272000000.0"},{"v":871.402670134909,"d":"871.4"},{"v":-9730.83124156348,"d":"-9730.8"},{"v":-513725.1335812489,"d":"-513725.1"},{"v":697.1221361079272,"d":"697.1"},{"v":-7784.6649932507835,"d":"-7784.7"}]
[null,null,{"v":2,"d":"2.0"},{"$f":"-0.9*$B$8","v":{"v":-608358.7108199002,"d":"-608358.7"}},{"v":-72000.00000000001,"d":"-72000.0"},{"v":10047999999.999994,"d":"10048000000.0"},{"v":1645.9718253094838,"d":"1646.0"},{"v":-10039.114682452342,"d":"-10039.1"},{"v":-486686.9686559201,"d":"-486687.0"},{"v":1316.777460247587,"d":"1316.8"},{"v":-8031.291745961874,"d":"-8031.3"}]
[null,null,{"v":3,"d":"3.0"},{"$f":"-0.85*$B$8","v":{"v":-574561.004663239,"d":"-574561.0"}},{"v":-68000,"d":"-68000.0"},{"v":11728000000,"d":"11728000000.0"},{"v":2348.6747877003427,"d":"2348.7"},{"v":-10275.531930557485,"d":"-10275.5"},{"v":-459648.8037305912,"d":"-459648.8"},{"v":1878.9398301602741,"d":"1878.9"},{"v":-8220.425544445989,"d":"-8220.4"}]
[null,null,{"v":4,"d":"4.0"},{"$f":"-0.8*$B$8","v":{"v":-540763.2985065778,"d":"-540763.3"}},{"v":-64000,"d":"-64000.0"},{"v":13312000000,"d":"13312000000.0"},{"v":2994.5824932082637,"d":"2994.6"},{"v":-10455.15392177969,"d":"-10455.2"},{"v":-432610.6388052623,"d":"-432610.6"},{"v":2395.665994566611,"d":"2395.7"},{"v":-8364.123137423752,"d":"-8364.1"}]
[null,null,{"v":5,"d":"5.0"},{"$f":"-0.75*$B$8","v":{"v":-506965.59234991675,"d":"-506965.6"}},{"v":-60000.00000000001,"d":"-60000.0"},{"v":14799999999.999996,"d":"14800000000.0"},{"v":3593.6203210333515,"d":"3593.6"},{"v":-10587.906035319067,"d":"-10587.9"},{"v":-405572.4738799334,"d":"-405572.5"},{"v":2874.896256826681,"d":"2874.9"},{"v":-8470.324828255254,"d":"-8470.3"}]
[null,null,{"v":6,"d":"6.0"},{"$f":"-0.7*$B$8","v":{"v":-473167.8861932556,"d":"-473167.9"}},{"v":-56000,"d":"-56000.0"},{"v":16192000000,"d":"16192000000.0"},{"v":4152.728317713647,"d":"4152.7"},{"v":-10680.728317713647,"d":"-10680.7"},{"v":-378534.3089546045,"d":"-378534.3"},{"v":3322.1826541709174,"d":"3322.2"},{"v":-8544.582654170918,"d":"-8544.6"}]
[null,null,{"v":7,"d":"7.0"},{"$f":"-0.65*$B$8","v":{"v":-439370.1800365945,"d":"-439370.2"}},{"v":-52000,"d":"-52000.0"},{"v":17488000000,"d":"17488000000.0"},{"v":4676.974061674455,"d":"4677.0"},{"v":-10738.688347388741,"d":"-10738.7"},{"v":-351496.14402927563,"d":"-351496.1"},{"v":3741.579249339564,"d":"3741.6"},{"v":-8590.950677910992,"d":"-8591.0"}]
[null,null,{"v":8,"d":"8.0"},{"$f":"-0.6*$B$8","v":{"v":-405572.4738799334,"d":"-405572.5"}},{"v":-48000.00000000001,"d":"-48000.0"},{"v":18688000000,"d":"18688000000.0"},{"v":5170.179492776121,"d":"5170.2"},{"v":-10765.60806420469,"d":"-10765.6"},{"v":-324457.9791039467,"d":"-324458.0"},{"v":4136.143594220897,"d":"4136.1"},{"v":-8612.486451363753,"d":"-8612.5"}]
[null,null,{"v":9,"d":"9.0"},{"$f":"-0.55*$B$8","v":{"v":-371774.7677232723,"d":"-371774.8"}},{"v":-44000.00000000001,"d":"-44000.0"},{"v":19792000000,"d":"19792000000.0"},{"v":5635.298515643589,"d":"5635.3"},{"v":-10764.441372786447,"d":"-10764.4"},{"v":-297419.81417861785,"d":"-297419.8"},{"v":4508.238812514871,"d":"4508.2"},{"v":-8611.553098229157,"d":"-8611.6"}]
[null,null,{"v":10,"d":"10.0"},{"$f":"-0.5*$B$8","v":{"v":-337977.06156661117,"d":"-337977.1"}},{"v":-40000,"d":"-40000.0"},{"v":20800000000,"d":"20800000000.0"},{"v":6074.6566879389,"d":"6074.7"},{"v":-10737.513830796042,"d":"-10737.5"},{"v":-270381.6492532889,"d":"-270381.6"},{"v":4859.72535035112,"d":"4859.7"},{"v":-8590.011064636834,"d":"-8590.0"}]
[null,null,{"v":11,"d":"11.0"},{"$f":"-0.449999999999999*$B$8","v":{"v":-304179.3554099494,"d":"-304179.4"}},{"v":-35999.99999999992,"d":"-36000.0"},{"v":21712000000.000015,"d":"21712000000.0"},{"v":6490.109835667088,"d":"6490.1"},{"v":-10686.681264238507,"d":"-10686.7"},{"v":-243343.4843279595,"d":"-243343.5"},{"v":5192.08786853367,"d":"5192.1"},{"v":-8549.345011390806,"d":"-8549.3"}]
[null,null,{"v":12,"d":"12.0"},{"$f":"-0.4*$B$8","v":{"v":-270381.6492532889,"d":"-270381.6"}},{"v":-32000,"d":"-32000.0"},{"v":22528000000,"d":"22528000000.0"},{"v":6883.1525943220995,"d":"6883.2"},{"v":-10613.438308607812,"d":"-10613.4"},{"v":-216305.31940263114,"d":"-216305.3"},{"v":5506.522075457679,"d":"5506.5"},{"v":-8490.75064688625,"d":"-8490.8"}]
[null,null,{"v":13,"d":"13.0"},{"$f":"-0.35*$B$8","v":{"v":-236583.9430966278,"d":"-236583.9"}},{"v":-28000,"d":"-28000.0"},{"v":23248000000,"d":"23248000000.0"},{"v":7254.994707929982,"d":"7255.0"},{"v":-10518.994707929982,"d":"-10519.0"},{"v":-189267.15447730225,"d":"-189267.2"},{"v":5803.995766343985,"d":"5804.0"},{"v":-8415.195766343986,"d":"-8415.2"}]
[null,null,{"v":14,"d":"14.0"},{"$f":"-0.3*$B$8","v":{"v":-202786.2369399667,"d":"-202786.2"}},{"v":-24000.000000000004,"d":"-24000.0"},{"v":23872000000,"d":"23872000000.0"},{"v":7606.615805323211,"d":"7606.6"},{"v":-10404.330091037496,"d":"-10404.3"},{"v":-162228.98955197335,"d":"-162229.0"},{"v":6085.2926442585685,"d":"6085.3"},{"v":-8323.464072829996,"d":"-8323.5"}]
[null,null,{"v":15,"d":"15.0"},{"$f":"-0.25*$B$8","v":{"v":-168988.53078330558,"d":"-168988.5"}},{"v":-20000,"d":"-20000.0"},{"v":24400000000,"d":"24400000000.0"},{"v":7938.805336485471,"d":"7938.8"},{"v":-10270.233907914042,"d":"-10270.2"},{"v":-135190.82462664446,"d":"-135190.8"},{"v":6351.044269188377,"d":"6351.0"},{"v":-8216.187126331233,"d":"-8216.2"}]
[null,null,{"v":16,"d":"16.0"},{"$f":"-0.199999999999999*$B$8","v":{"v":-135190.8246266438,"d":"-135190.8"}},{"v":-15999.999999999922,"d":"-16000.0"},{"v":24832000000.000008,"d":"24832000000.0"},{"v":8252.19196144643,"d":"8252.2"},{"v":-10117.334818589277,"d":"-10117.3"},{"v":-108152.65970131503,"d":"-108152.7"},{"v":6601.753569157144,"d":"6601.8"},{"v":-8093.8678548714215,"d":"-8093.9"}]
[null,null,{"v":17,"d":"17.0"},{"$f":"-0.15*$B$8","v":{"v":-101393.11846998335,"d":"-101393.1"}},{"v":-12000.000000000002,"d":"-12000.0"},{"v":25168000000,"d":"25168000000.0"},{"v":8547.265213875648,"d":"8547.3"},{"v":-9946.122356732789,"d":"-9946.1"},{"v":-81114.49477598668,"d":"-81114.5"},{"v":6837.812171100518,"d":"6837.8"},{"v":-7956.897885386231,"d":"-7956.9"}]
[null,null,{"v":18,"d":"18.0"},{"$f":"-0.0999999999999999*$B$8","v":{"v":-67595.41231332216,"d":"-67595.4"}},{"v":-7999.999999999992,"d":"-8000.0"},{"v":25408000000,"d":"25408000000.0"},{"v":8824.391324377006,"d":"8824.4"},{"v":-9756.962752948433,"d":"-9757.0"},{"v":-54076.32985065773,"d":"-54076.3"},{"v":7059.513059501604,"d":"7059.5"},{"v":-7805.570202358746,"d":"-7805.6"}]
[null,null,{"v":19,"d":"19.0"},{"$f":"-0.05*$B$8","v":{"v":-33797.706156661116,"d":"-33797.7"}},{"v":-4000,"d":"-4000.0"},{"v":25552000000,"d":"25552000000.0"},{"v":9083.8244693677,"d":"9083.8"},{"v":-9550.110183653414,"d":"-9550.1"},{"v":-27038.164925328892,"d":"-27038.2"},{"v":7267.0595754941605,"d":"7267.1"},{"v":-7640.0881469227315,"d":"-7640.1"}]
[null,null,{"v":20,"d":"20.0"},{"$f":"0*$B$8","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":25600000000,"d":"25600000000.0"},{"v":9325.714285714284,"d":"9325.7"},{"v":-9325.714285714284,"d":"-9325.7"},{"v":0,"d":"0.0"},{"v":7460.5714285714275,"d":"7460.6"},{"v":-7460.5714285714275,"d":"-7460.6"}]
[null,null,{"v":21,"d":"21.0"},{"$f":"0.05*$B$8","v":{"v":33797.706156661116,"d":"33797.7"}},{"v":4000,"d":"4000.0"},{"v":25552000000,"d":"25552000000.0"},{"v":9550.110183653414,"d":"9550.1"},{"v":-9083.8244693677,"d":"-9083.8"},{"v":27038.164925328892,"d":"27038.2"},{"v":7640.0881469227315,"d":"7640.1"},{"v":-7267.0595754941605,"d":"-7267.1"}]
[null,null,{"v":22,"d":"22.0"},{"$f":"0.1*$B$8","v":{"v":67595.41231332223,"d":"67595.4"}},{"v":8000,"d":"8000.0"},{"v":25408000000,"d":"25408000000.0"},{"v":9756.962752948433,"d":"9757.0"},{"v":-8824.391324377006,"d":"-8824.4"},{"v":54076.329850657785,"d":"54076.3"},{"v":7805.570202358746,"d":"7805.6"},{"v":-7059.513059501604,"d":"-7059.5"}]
[null,null,{"v":23,"d":"23.0"},{"$f":"0.149999999999999*$B$8","v":{"v":101393.11846998267,"d":"101393.1"}},{"v":11999.99999999992,"d":"12000.0"},{"v":25168000000.000008,"d":"25168000000.0"},{"v":9946.122356732787,"d":"9946.1"},{"v":-8547.265213875653,"d":"-8547.3"},{"v":81114.49477598614,"d":"81114.5"},{"v":7956.89788538623,"d":"7956.9"},{"v":-6837.812171100522,"d":"-6837.8"}]
[null,null,{"v":24,"d":"24.0"},{"$f":"0.199999999999999*$B$8","v":{"v":135190.8246266438,"d":"135190.8"}},{"v":15999.999999999922,"d":"16000.0"},{"v":24832000000.000008,"d":"24832000000.0"},{"v":10117.334818589277,"d":"10117.3"},{"v":-8252.19196144643,"d":"-8252.2"},{"v":108152.65970131503,"d":"108152.7"},{"v":8093.8678548714215,"d":"8093.9"},{"v":-6601.753569157144,"d":"-6601.8"}]
[null,null,{"v":25,"d":"25.0"},{"$f":"0.25*$B$8","v":{"v":168988.53078330558,"d":"168988.5"}},{"v":20000,"d":"20000.0"},{"v":24400000000,"d":"24400000000.0"},{"v":10270.233907914042,"d":"10270.2"},{"v":-7938.805336485471,"d":"-7938.8"},{"v":135190.82462664446,"d":"135190.8"},{"v":8216.187126331233,"d":"8216.2"},{"v":-6351.044269188377,"d":"-6351.0"}]
[null,null,{"v":26,"d":"26.0"},{"$f":"0.3*$B$8","v":{"v":202786.2369399667,"d":"202786.2"}},{"v":24000.000000000004,"d":"24000.0"},{"v":23872000000,"d":"23872000000.0"},{"v":10404.330091037496,"d":"10404.3"},{"v":-7606.615805323211,"d":"-7606.6"},{"v":162228.98955197335,"d":"162229.0"},{"v":8323.464072829996,"d":"8323.5"},{"v":-6085.2926442585685,"d":"-6085.3"}]
[null,null,{"v":27,"d":"27.0"},{"$f":"0.35*$B$8","v":{"v":236583.9430966278,"d":"236583.9"}},{"v":28000,"d":"28000.0"},{"v":23248000000,"d":"23248000000.0"},{"v":10518.994707929982,"d":"10519.0"},{"v":-7254.994707929982,"d":"-7255.0"},{"v":189267.15447730225,"d":"189267.2"},{"v":8415.195766343986,"d":"8415.2"},{"v":-5803.995766343985,"d":"-5804.0"}]
[null,null,{"v":28,"d":"28.0"},{"$f":"0.399999999999999*$B$8","v":{"v":270381.6492532883,"d":"270381.6"}},{"v":31999.999999999927,"d":"32000.0"},{"v":22528000000.000015,"d":"22528000000.0"},{"v":10613.43830860781,"d":"10613.4"},{"v":-6883.152594322107,"d":"-6883.2"},{"v":216305.31940263062,"d":"216305.3"},{"v":8490.750646886248,"d":"8490.8"},{"v":-5506.522075457686,"d":"-5506.5"}]
[null,null,{"v":29,"d":"29.0"},{"$f":"0.449999999999999*$B$8","v":{"v":304179.3554099494,"d":"304179.4"}},{"v":35999.99999999992,"d":"36000.0"},{"v":21712000000.000015,"d":"21712000000.0"},{"v":10686.681264238507,"d":"10686.7"},{"v":-6490.109835667088,"d":"-6490.1"},{"v":243343.4843279595,"d":"243343.5"},{"v":8549.345011390806,"d":"8549.3"},{"v":-5192.08786853367,"d":"-5192.1"}]
[null,null,{"v":30,"d":"30.0"},{"$f":"0.5*$B$8","v":{"v":337977.06156661117,"d":"337977.1"}},{"v":40000,"d":"40000.0"},{"v":20800000000,"d":"20800000000.0"},{"v":10737.513830796042,"d":"10737.5"},{"v":-6074.6566879389,"d":"-6074.7"},{"v":270381.6492532889,"d":"270381.6"},{"v":8590.011064636834,"d":"8590.0"},{"v":-4859.72535035112,"d":"-4859.7"}]
[null,null,{"v":31,"d":"31.0"},{"$f":"0.55*$B$8","v":{"v":371774.7677232723,"d":"371774.8"}},{"v":44000.00000000001,"d":"44000.0"},{"v":19792000000,"d":"19792000000.0"},{"v":10764.441372786447,"d":"10764.4"},{"v":-5635.298515643589,"d":"-5635.3"},{"v":297419.81417861785,"d":"297419.8"},{"v":8611.553098229157,"d":"8611.6"},{"v":-4508.238812514871,"d":"-4508.2"}]
[null,null,{"v":32,"d":"32.0"},{"$f":"0.6*$B$8","v":{"v":405572.4738799334,"d":"405572.5"}},{"v":48000.00000000001,"d":"48000.0"},{"v":18688000000,"d":"18688000000.0"},{"v":10765.60806420469,"d":"10765.6"},{"v":-5170.179492776121,"d":"-5170.2"},{"v":324457.9791039467,"d":"324458.0"},{"v":8612.486451363753,"d":"8612.5"},{"v":-4136.143594220897,"d":"-4136.1"}]
[null,null,{"v":33,"d":"33.0"},{"$f":"0.649999999999999*$B$8","v":{"v":439370.18003659387,"d":"439370.2"}},{"v":51999.99999999993,"d":"52000.0"},{"v":17488000000.000023,"d":"17488000000.0"},{"v":10738.688347388743,"d":"10738.7"},{"v":-4676.974061674465,"d":"-4677.0"},{"v":351496.1440292751,"d":"351496.1"},{"v":8590.950677910994,"d":"8591.0"},{"v":-3741.579249339572,"d":"-3741.6"}]
[null,null,{"v":34,"d":"34.0"},{"$f":"0.7*$B$8","v":{"v":473167.8861932556,"d":"473167.9"}},{"v":56000,"d":"56000.0"},{"v":16192000000,"d":"16192000000.0"},{"v":10680.728317713647,"d":"10680.7"},{"v":-4152.728317713647,"d":"-4152.7"},{"v":378534.3089546045,"d":"378534.3"},{"v":8544.582654170918,"d":"8544.6"},{"v":-3322.1826541709174,"d":"-3322.2"}]
[null,null,{"v":35,"d":"35.0"},{"$f":"0.75*$B$8","v":{"v":506965.59234991675,"d":"506965.6"}},{"v":60000.00000000001,"d":"60000.0"},{"v":14799999999.999996,"d":"14800000000.0"},{"v":10587.906035319067,"d":"10587.9"},{"v":-3593.6203210333515,"d":"-3593.6"},{"v":405572.4738799334,"d":"405572.5"},{"v":8470.324828255254,"d":"8470.3"},{"v":-2874.896256826681,"d":"-2874.9"}]
[null,null,{"v":36,"d":"36.0"},{"$f":"0.8*$B$8","v":{"v":540763.2985065778,"d":"540763.3"}},{"v":64000,"d":"64000.0"},{"v":13312000000,"d":"13312000000.0"},{"v":10455.15392177969,"d":"10455.2"},{"v":-2994.5824932082637,"d":"-2994.6"},{"v":432610.6388052623,"d":"432610.6"},{"v":8364.123137423752,"d":"8364.1"},{"v":-2395.665994566611,"d":"-2395.7"}]
[null,null,{"v":37,"d":"37.0"},{"$f":"0.85*$B$8","v":{"v":574561.004663239,"d":"574561.0"}},{"v":68000,"d":"68000.0"},{"v":11728000000,"d":"11728000000.0"},{"v":10275.531930557485,"d":"10275.5"},{"v":-2348.6747877003427,"d":"-2348.7"},{"v":459648.8037305912,"d":"459648.8"},{"v":8220.425544445989,"d":"8220.4"},{"v":-1878.9398301602741,"d":"-1878.9"}]
[null,null,{"v":38,"d":"38.0"},{"$f":"0.899999999999999*$B$8","v":{"v":608358.7108198995,"d":"608358.7"}},{"v":71999.99999999993,"d":"72000.0"},{"v":10048000000.00003,"d":"10048000000.0"},{"v":10039.114682452348,"d":"10039.1"},{"v":-1645.971825309499,"d":"-1646.0"},{"v":486686.96865591954,"d":"486687.0"},{"v":8031.291745961878,"d":"8031.3"},{"v":-1316.7774602475993,"d":"-1316.8"}]
[null,null,{"v":39,"d":"39.0"},{"$f":"0.95*$B$8","v":{"v":642156.4169765612,"d":"642156.4"}},{"v":76000,"d":"76000.0"},{"v":8272000000,"d":"8272000000.0"},{"v":9730.83124156348,"d":"9730.8"},{"v":-871.402670134909,"d":"-871.4"},{"v":513725.1335812489,"d":"513725.1"},{"v":7784.6649932507835,"d":"7784.7"},{"v":-697.1221361079272,"d":"-697.1"}]
[null,null,{"v":40,"d":"40.0"},{"$f":"1*$B$8","v":{"v":675954.1231332223,"d":"675954.1"}},{"v":80000,"d":"80000.0"},{"v":6400000000,"d":"6400000000.0"},{"v":9325.714285714284,"d":"9325.7"},{"v":0,"d":"0.0"},{"v":540763.2985065778,"d":"540763.3"},{"v":7460.5714285714275,"d":"7460.6"},{"v":0,"d":"0.0"}]
[]
[null,null,"OVERLOAD / SERVICE MARKERS (amplified Fa, ΔP)"]
[null,null,"Case","Fa_amp","ΔP_amp"]
[null,null,{"$f":"'1_Inputs'!A50","v":"Service – normal"},{"$f":"'1_Inputs'!D50","v":{"v":120000,"d":"120,000"}},{"$f":"'1_Inputs'!E50","v":{"v":4000,"d":"4,000"}}]
[null,null,{"$f":"'1_Inputs'!A51","v":"CwD – elevated torque/drag"},{"$f":"'1_Inputs'!D51","v":{"v":320000,"d":"320,000"}},{"$f":"'1_Inputs'!E51","v":{"v":9000,"d":"9,000"}}]
[null,null,{"$f":"'1_Inputs'!A52","v":"CwD – severe (exceeds L80/BTC)"},{"$f":"'1_Inputs'!D52","v":{"v":480000,"d":"480,000"}},{"$f":"'1_Inputs'!E52","v":{"v":12000,"d":"12,000"}}]
[null,null,{"$f":"'1_Inputs'!A53","v":"SET – post-expansion residual"},{"$f":"'1_Inputs'!D53","v":{"v":200000,"d":"200,000"}},{"$f":"'1_Inputs'!E53","v":{"v":7000,"d":"7,000"}}]
[null,null,{"$f":"'1_Inputs'!A54","v":"SET – expansion peak (severe)"},{"$f":"'1_Inputs'!D54","v":{"v":420000,"d":"420,000"}},{"$f":"'1_Inputs'!E54","v":{"v":11000,"d":"11,000"}}]
[]
[null,null,"CONNECTION RECTANGLE"]
[null,null,"Axial","ΔP"]
[null,null,{"$f":"$B$15","v":{"v":281250,"d":"281,250.0"}},{"$f":"$B$17","v":{"v":4400,"d":"4,400.0"}}]
[null,null,{"$f":"$B$15","v":{"v":281250,"d":"281,250.0"}},{"$f":"$B$18","v":{"v":-3600,"d":"-3,600.0"}}]
[null,null,{"$f":"$B$16","v":{"v":-271428.5714285714,"d":"-271,428.6"}},{"$f":"$B$18","v":{"v":-3600,"d":"-3,600.0"}}]
[null,null,{"$f":"$B$16","v":{"v":-271428.5714285714,"d":"-271,428.6"}},{"$f":"$B$17","v":{"v":4400,"d":"4,400.0"}}]
[null,null,{"$f":"$B$15","v":{"v":281250,"d":"281,250.0"}},{"$f":"$B$17","v":{"v":4400,"d":"4,400.0"}}]