Spreadsheet: 819290d1677391497-limitation-of-characters-in-excel-formula-excel-bug-report
Sheet: Sheet1

COD | D1C | FORMULA | PROFILDIM | RT | RL | DGR | DN1 | DN2 | DN3 | DN1U | DN2U | DN3U | PN1 | PN2 | [NAME] | PN2U | SCH1 | SCH2 | SCH3 | SDR | OD1 | OD2 | OD3 | WT1 | WT2 | WT3 | DIAEX | DIAEX2 | DIAINT | DIAINT2 | DIAC | BORE | DIABOLT | BOLTL | BOLTNO | THREADT | [NAME] | TH1 | TH2 | WID1 | [NAME] | LEN1 | [NAME] | [NAME] | HIG2 | A | B | C | D | E | F | G | PREFAB | TRACKING
THR | ADIABOLT | LET(D1C,[@D1C],IFS(D1C="ADIABOLT",[@DIABOLT],D1C="ADIABOLT*BOLTL",[@DIABOLT]&"X"&[@BOLTL],D1C="ADIAEXT","Ø"&[@DIAEX],D1C="ADN*SCH1*OD1*WT1-BORE",[@OD1]&"x"&[@WT1]&"  ("&[@DN1]&"  "&[@SCH1]&")",D1C="ADN1U*DN2*SCH1*SCH12*OD1*WT1*OD2*WT2",[@OD1]&"x"&[@WT1]&"/"&[@OD2]&"x"&[@WT2]&"  ("&[@DN1]&" "&[@DN2]&"  "&[@SCH1]&"/"&[@SCH1]&")",D1C="ADN1U*DN2*SCH1*SCH12*OD1*WT1*OD2*WT2*PN1",[@OD1]&"x"&[@WT1]&"/"&[@OD2]&"x"&[@WT2]&"  ("&[@DN1]&" "&[@DN2]&"  "&[@SCH1]&"/"&[@SCH1]&"  #"&[NAME] Ø"&[@DIAINT]&"  TH. "&[@TH1],D1C="ADN1U*DIAEXT*DIAINT-BORE",[@DN1U]&"  Ø"&[@DIAEX],D1C="ADN1U*PN1",[@DN1U]&"  PN"&[@PN1],D1C="ADN1U*PN1-DGR",[@DN1U]&"  #"&[@PN1],D1C="ADN1U*PN1-OD1",[@DN1U]&"  #"&[@PN1],D1C="ADN1U*PN1U",[@DN1U]&"  "&[@PN1U],D1C="ADN1U*PN1U*OD1",[@DN1U]&"  "&[@PN1U]&"  ("&[@OD1]&")",D1C="ADN1U*PN1U*OD1-SCH1",[@DN1U]&"  "&[@PN1U]&"  ("&[@OD1]&")",D1C="ADN1U*PN1U*OD1-BORE",[@DN1U]&"  "&[@PN1U],D1C="ADN1U*PN1U*TH1",[@DN1]&"  "&[@PN1U]&"  TH. "&[@TH1],D1C="ALEN",[@LEN1]&"MM",D1C="AOD1*WT1*DN1U*SCH1",[@OD1]&"x"&[@WT1]&"  ("&[@DN1]&"  "&[@SCH1]&")",D1C="APROFIL",[@PROFILDIM],D1C="ART*DN1U*SCH1*OD1*WT1-DGR",[@RT]&"  "&[@OD1]&"x"&[@WT1]&"  ("&[@DN1]&"  "&[@SCH1]&") ",D1C="ART*RL*DN1U*SCH1*OD1*WT2-DGR",[@RT]&[@RL]&"  "&[@OD1]&"x"&[@WT1]&"  ("&[@DN1]&"  "&[@SCH1]&") ",D1C="ATH1","TH. "&[@TH1],D1C="AWID*TH1","WIDTH"&" "&[@WID1]&"  TH. "&[@TH1],D1C="AZAD","ZAD",D1C="ATH1*LEN","TH. "&[@TH1]&" L="&[@LEN1],D1C="ART*OD1&WT1&DN1U*SCH1*PN1U-DGR",[@RT]&"  "&[@OD1]&"x"&[@WT1]&"  ("&[@DN1U]&"  "&[@SCH1]&"  "&[@PN1U]&") ",D1C="ASRD*PN1*DN1U*DN2*OD1*SCH1*WT1*OD2*WT2",[@SDR]&"  #"&[@PN1]&"  "&[@DN1]&"  "&[@DN2]&"  ("&[@OD1]&"X"&[@WT1]&"/"&[@OD2]&"X"&[@WT2]&")",D1C="ASRD*PN1*DN1U*DN2*SCH1*OD1*WT1*OD2*WT2",[@SDR]&"  #"&[@PN1]&"  "&[@DN1]&"  "&[@DN2]&"  ("&[@OD1]&"X"&[@WT1]&"/"&[@OD2]&"X"&[@WT2]&")",D1C="ASRD*PN1*DN1U*SCH1*OD1*WT1",[@SDR]&"  #"&[@PN1]&"  "&[@DN1]&"  ("&[@OD1]&"X"&[@WT1]&")",D1C="ASRD*PN1*DN1U*SCH1",[@SDR]&"  #"&[@PN1]&"  "&[@DN1U],D1C="ADN1*dn2*sch1*od1*od2*wt1",[@DN1]&" - "&[@DN2]&"  "&[@SCH1],D1C="ASRD*PN1*DN1U*SCH1*OD1*WT1-DGR",[@SDR]&"  #"&[@PN1]&"  "&[@DN1]&"  ("&[@OD1]&"X"&[@WT1]&")",D1C="ADIAC"," Ø "&[@DIAC],D1C="OD1*WT1*OD2",[@OD1]&"x"&[@WT1]&" / "&[@OD2],D1C="DIABOLT",[@DIABOLT],D1C="DIABOLT*BOLTL",[@DIABOLT]&"X"&[@BOLTL],D1C="DIAEXT","Ø"&[@DIAEX]&" MM",D1C="DN1U",[@DN1U],D1C="DN1U*DIAEXT*DIAINT*HR",[@DN1U]&"  Ø"&[@DIAEX]& " / Ø"&[@DIAINT]&"  TH. "&[@TH1],D1C="DN1U*DIAEXT*DIAINT-BORE",[@DN1U]&"  DIA "&[@DIAEX],D1C="DN1U*PN1",[@DN1U]&"  PN"&[@PN1],D1C="DN1U*PN1-DGR",[@DN1U]&"  PN"&[@PN1],D1C="DN1U*PN1-OD1",[@DN1U]&"  PN"&[@PN1],D1C="DN1U*PN1U",[@DN1U]&"  "&[@PN1U],D1C="DN1U*PN1U*OD1",[@DN1U]&"  "&[@PN1U]&"  ("&[@OD1]&")",D1C="DN1U*PN1U*OD1-WT1",[@DN1U]&"  "&[@PN1U]&"  ("&[@OD1]&")",D1C="DN1U*PN1U*TH1",[@DN1U]&"  "&[@PN1U]&"  TH "&[[NAME]) ",[NAME][@OD1]&"X"&[@WT1]&"/"&[@OD2]&"X"&[@WT2],D1C="SDR*PN1*OD1*WT1",[@SDR]&"  PN"&[@PN1]&"  "&[@OD1]&"X"&[@WT1],D1C="SRD*PN1*OD1*WT1-DGR",[@SDR]&"  PN"&[@PN1]&"  "&[@OD1]&"X"&[@WT1],D1C="ASRD*PN1*DN1U*SCH1",[@SDR]&"  PN"&[@PN1]&"  "&[@DN1U],D1C="TH1","TH. "&[@TH1],D1C="WID*TH1","WIDTH"&" "&[@WID1]&"  TH. "&[@TH1],D1C="ZAD","ZAD",D1C="DN1U-OD1",[@DN1U],D1C="DIAC"," Ø "&[@DIAC],D1C="WID1*HIGH1*TH1*LEN1",[@WID1]&"x"&[@HIG1]&"x"&[@TH1]&" L="&[@LEN1],D1C="WID1*LEN1",[@WID1]&" L="&[@LEN1],D1C="DIAC*LEN1"," Ø"&[@DIAC]&" L="&[@LEN1],D1C="TH1*WID1*LEN1",[@TH1]&"x"&[@WID1]&"x"&[@LEN1],TRUE,"")) |  | SR | 222 | 90 | 5" | 21/2" |  | 5" |  |  | 300 |  | #300 |  | SCH10 | SCH10" |  | SDR17 | 141.3 | 73.03 |  | 3.4 | 3.05 |  |  |  | 120 |  |  | 100 | 3/4" | 100 | 4 |  |  | 4 |  | 100 |  | 100 | 100 |  | 50