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

{"sheet":"Tabelle1","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,1,2,3],[4,1,4,3]]}
[]
[]
[null,"Thermowell Calculator"]
[null,"Introduction:"]
[null,"This thermowell length calculation tool helps you to determine the optimum length for thermowells. By taking into account factors such as the length of the process connection, the sensor type and the process conditions, the tool ensures that the thermowells are perfectly matched to the specific requirements. This allows you to ensure precise measurements and improve the efficiency of your systems."]
[]
[]
[]
[null,"Description:","Please select a value in the light blue fields. "]
[null,null,"Please enter a value in the blue fields. "]
[]
[null,"Sensor type:","PT20S"]
[null,"Process connection:","G 1/4 A DIN 3852-E (BCID: G50)"]
[]
[null,"Length of the process connection in mm:",{"$f":"VLOOKUP(C12&C13,CHOOSE({1,2},Tabelle3!A2:A58&Tabelle3!B2:B58,Tabelle3!D2:D58),2,FALSE)","v":12}]
[]
[null,"Diameter of the measuring tip in mm:",3]
[]
[null,"Length of the measuring rod without process connection in mm:",50]
[null,null,{"$f":"IF(C19 < C17*16, \"The measuring rod is shorter than 16*diameter of the measuring tip. Therefore, the measuring result is not thermally independent.\", \"\")","v":""}]
[]
[null,"Hygienic",{"$f":"VLOOKUP(C12&C13,CHOOSE({1,2},Tabelle3!A2:A58&Tabelle3!B2:B58,Tabelle3!C2:C58),2,FALSE)","v":"no"}]
[null,null,{"$f":"IF(C22=\"Yes\", 0, (C15))","v":12}]
[null,"Thermowell","without Thermowell"]
[]
[null,null,{"$f":"IF(INDEX(Tabelle3!E2:H58, MATCH(C13, Tabelle3!B2:B58, 0), MATCH(C24, Tabelle3!E1:H1, 0)) = \"x\", \"Valid combination\", \"Invalid combination incorrect process connection\")","v":"Valid combination"}]
[]
[null,"Order length in mm:",{"$f":"C23+C19","v":62}]

{"sheet":"Tabelle2","index":1,"n_rows":16,"n_cols":30,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Sensor",null,"TFRN","Hygienisch","Länge","TFRH","Hygienisch","Länge","TCR_6","Hygienisch","Länge","TE_2","Hygienisch","Länge","PT20S","Hygienisch","Länge","PT20H","Hygienisch","Länge","PT_55","Hygienisch","Länge","PT55H","Hygienisch","Länge","TER_8","Hygienisch","Länge"]
[null,"TFRN",null,"Without thread (BCID: T65) ","no",6,"G 1/2 A hygienic (BCID: A03)","Yes",null,"Without thread (BCID: T65)","no",5,"Without thread (BCID: T65)","no",8,"Without thread (BCID: T65) ","no",8,"M12 × 1.5 hygienic (BCID: A02) ","Yes",19,"Without thread (BCID: T65) ","no",8,"M12 × 1.5 hygienic (BCID: A02) ","Yes",19,"G 1/2 A hygienic, front-flush","Yes",36]
[null,"TFRH",null,"G 1/2 A DIN 3852-E (BCID: G51)","no",14,"BHC 3A DN 38 (BCID: B01)","Yes",32,"G 1/2 A ISO 228-1 (BCID: G06) ","no",17,"G 1/2 A ISO 228-1 (BCID: G06)","no",24.5,"G 1/2 A ISO 228-1 (BCID: G06) ","no",16.5,"G 1/2 A hygienic (BCID: A03)","Yes",38,"G 1/2 A ISO 228-1 (BCID: G06) ","no",16.5,"G 1/2 A hygienic (BCID: A03)","Yes",38,"G 1/2 A hygienic, immersion length 20 mm","Yes",36]
[null,"TCR_6",null,"G 1/2 A ISO 228-1 (BCID: G06)","no",17,"Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0,"R 1/2 ISO 7/1 (BCID: R01)","no",17,"G 1/2 A hygienic (BCID: A03)","Yes",36,"G 1/4 A DIN 3852-E (BCID: G50)","no",12,"BHC 3A DN 38 (BCID: B01)","Yes",32,"G 1/4 A DIN 3852-E (BCID: G50)","no",12,"BHC 3A DN 38 (BCID: B01)","Yes",32,"G 1/2 A hygienic, immersion length 50 mm","Yes",36]
[null,"TE_2",null,"R 1/2 ISO 7/1 (BCID: R06)","no",17,"Tri-Clamp Ø 64.0 (BCID: C05)","Yes",0,"M18 × 1.5 ISO 261 / ISO 965 (BCID: M07)","no",17,"M12 × 1.5 hygienic (BCID: A02)","Yes",19,"G 1/2 A DIN 3852-E (BCID: G51)","no",14,"Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0,"G 1/2 A DIN 3852-E (BCID: G51)","no",14,"Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0]
[null,"PT20S",null,"1/2-14 NPT (BCID: N02)","no",22,"Varivent® DN 32 … 125; 1 1/2\" … 6\" (Type N), Ø 68 (BCID: V02)","Yes",0,"M20 × 1.5 ISO 261 / ISO 965 (BCID: M08)","no",17,"M12 × 1.5 hygienic, PEEK cone, tip Ø 3 x 5 mm (BCID: A02)","Yes",19,"1/2-14 NPT (BCID: N02)","no",24,"Tri-Clamp Ø 25 (BCID: C01)","Yes",0,"1/2-14 NPT (BCID: N02)","no",24,"arivent® DN 32 … 125; 1 1/2\" … 6\" (Type N), Ø 68 (BCID: V02)","Yes",0]
[null,"PT20H",null,null,null,null,null,null,null,"1/2-14 NPT (BCID: N02)","no",23,"G 1/8 female thread hygienic (BCID: A01)","Yes"]
[null,"PT_55",null,null,null,null,null,null,null,"Rotating female union G 1/2 A ISO 228-1, (BCID: G23)","no",13,"G 1/4 A DIN 3852-E (BCID: G50)","no",15]
[null,"PT55H",null,null,null,null,null,null,null,"Rotating female union G 3/4 A ISO 228-1, (BCID: G24)","no",15,"Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0]
[null,"TER_8",null,null,null,null,null,null,null,"Rotating male nipple G 1/2 A ISO 228-1 (G06)","no",20,"Tri-Clamp Ø 25 (BCID: C01)","Yes",0]
[null,null,null,null,null,null,null,null,null,"Rotating male nipple G 3/4 A ISO 228-1 (G10)","no",20,"BHC 3A DN 38 (BCID: B01) ","Yes",32]
[null,null,null,null,null,null,null,null,null,"Rotating male nipple G 1 A ISO 228-1 (G11)","no",23,"1/2-14 NPT (BCID: N02)","no",23]
[null,null,null,null,null,null,null,null,null,null,null,null,"1/4-18 NPT (BCID: N01)","no",22]
[null,null,null,null,null,null,null,null,null,null,null,null,"G 1/2 A DIN 3852-E (BCID: G51)","no",21]

{"sheet":"Tabelle3","index":2,"n_rows":58,"n_cols":20,"rows_kept":58,"cut":false,"hidden":true,"merged":[[5,12,5,15]]}
["Sensor","Prozessanschluss","Hygienisch","Länge","without Thermowell","ZPT4","AGF","AGFR","Bild"]
["TFRN","Without thread (BCID: T65) ","no",6,"x"]
["TFRN","G 1/2 A DIN 3852-E (BCID: G51)","no",14,"x","x","x","x",null,null,null,null,"TFRN"]
["TFRN","G 1/2 A ISO 228-1 (BCID: G06)","no",17,"x","x","x","x",null,null,null,null,"R 1/2 ISO 7/1 (BCID: R06)"]
["TFRN","R 1/2 ISO 7/1 (BCID: R06)","no",17,"x",null,"x","x"]
["TFRN","1/2-14 NPT (BCID: N02)","no",22,"x",null,"x","x",null,null,null,null,{"$f":"VLOOKUP(M3&M4,CHOOSE({1,2},A:A&B:B,C:C),2,0)","v":"no"}]
["TFRH","G 1/2 A hygienic (BCID: A03)","Yes",null,"x"]
["TFRH","BHC 3A DN 38 (BCID: B01)","Yes",32,"x"]
["TFRH","Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0,"x"]
["TFRH","Tri-Clamp Ø 64.0 (BCID: C05)","Yes",0,"x"]
["TFRH","Varivent® DN 32 … 125; 1 1/2\" … 6\" (Type N), Ø 68 (BCID: V02)","Yes",0,"x",null,null,null,null,null,null,"TFRN","TFRH","TCR_6","TE_2","PT20S","PT20H","PT_55","PT55H","TER_8"]
["TCR_6","Without thread (BCID: T65)","no",5,"x",null,null,null,null,null,null,4,4,4,3,3,3,4,4,3]
["TCR_6","G 1/2 A ISO 228-1 (BCID: G06) ","no",17,"x","x","x","x",null,null,null,6,6,6,4,6,6,6,6,28]
["TCR_6","R 1/2 ISO 7/1 (BCID: R01)","no",17,"x",null,"x","x",null,null,null,8,8,8,6,null,null,8,8]
["TCR_6","M18 × 1.5 ISO 261 / ISO 965 (BCID: M07)","no",17,"x",null,null,null,null,null,null,null,null,10]
["TCR_6","M20 × 1.5 ISO 261 / ISO 965 (BCID: M08)","no",17,"x"]
["TCR_6","1/2-14 NPT (BCID: N02)","no",23,"x",null,"x","x"]
["TCR_6","Rotating female union G 1/2 A ISO 228-1, (BCID: G23)","no",13,"x"]
["TCR_6","Rotating female union G 3/4 A ISO 228-1, (BCID: G24)","no",15,"x"]
["TCR_6","Rotating male nipple G 1/2 A ISO 228-1 (G06)","no",20,"x","x","x","x"]
["TCR_6","Rotating male nipple G 3/4 A ISO 228-1 (G10)","no",20,"x"]
["TCR_6","Rotating male nipple G 1 A ISO 228-1 (G11)","no",23,"x"]
["TE_2","Without thread (BCID: T65)","no",8,"x"]
["TE_2","G 1/2 A ISO 228-1 (BCID: G06)","Yes",24.5,"x","x","x","x"]
["TE_2","G 1/2 A hygienic (BCID: A03)","Yes",36,"x"]
["TE_2","M12 × 1.5 hygienic (BCID: A02)","Yes",19,"x"]
["TE_2","M12 × 1.5 hygienic, PEEK cone, tip Ø 3 x 5 mm (BCID: A02)","Yes",19,"x"]
["TE_2","G 1/8 female thread hygienic (BCID: A01)","Yes",null,"x"]
["TE_2","G 1/4 A DIN 3852-E (BCID: G50)","Yes",15,"x"]
["TE_2","Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0,"x"]
["TE_2","Tri-Clamp Ø 25 (BCID: C01)","Yes",0,"x"]
["TE_2","BHC 3A DN 38 (BCID: B01) ","Yes",32,"x"]
["TE_2","1/2-14 NPT (BCID: N02)","Yes",23,"x",null,"x","x"]
["TE_2","1/4-18 NPT (BCID: N01)","Yes",22,"x"]
["TE_2","G 1/2 A DIN 3852-E (BCID: G51)","Yes",21,"x","x","x","x"]
["PT20S","Without thread (BCID: T65) ","no",8,"x"]
["PT20S","G 1/2 A ISO 228-1 (BCID: G06) ","no",16.5,"x","x","x","x"]
["PT20S","G 1/4 A DIN 3852-E (BCID: G50)","no",12,"x"]
["PT20S","G 1/2 A DIN 3852-E (BCID: G51)","no",14,"x","x","x","x"]
["PT20S","1/2-14 NPT (BCID: N02)","no",24,"x",null,"x","x"]
["PT20H","M12 × 1.5 hygienic (BCID: A02) ","Yes",19,"x"]
["PT20H","G 1/2 A hygienic (BCID: A03)","Yes",38,"x"]
["PT20H","BHC 3A DN 38 (BCID: B01)","Yes",32,"x"]
["PT20H","Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0,"x"]
["PT20H","Tri-Clamp Ø 25 (BCID: C01)","Yes",0,"x"]
["PT_55","Without thread (BCID: T65) ","no",8,"x"]
["PT_55","G 1/2 A ISO 228-1 (BCID: G06) ","no",16.5,"x","x","x","x"]
["PT_55","G 1/4 A DIN 3852-E (BCID: G50)","no",12,"x"]
["PT_55","G 1/2 A DIN 3852-E (BCID: G51)","no",14,"x","x","x","x"]
["PT_55","1/2-14 NPT (BCID: N02)","no",24,"x",null,"x","x"]
["PT55H","M12 × 1.5 hygienic (BCID: A02) ","Yes",19,"x"]
["PT55H","G 1/2 A hygienic (BCID: A03)","Yes",38,"x"]
["PT55H","BHC 3A DN 38 (BCID: B01)","Yes",32,"x"]
["PT55H","Tri-Clamp Ø 50.5 (BCID: C04)","Yes",0,"x"]
["PT55H","arivent® DN 32 … 125; 1 1/2\" … 6\" (Type N), Ø 68 (BCID: V02)","Yes",0,"x"]
["TER_8","G 1/2 A hygienic, front-flush","Yes",36,"x"]
["TER_8","G 1/2 A hygienic, immersion length 20 mm","Yes",36,"x"]
["TER_8","G 1/2 A hygienic, immersion length 50 mm","Yes",36,"x"]