{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BonnetTension","Formatvorlage_fuer Makro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"BonnetTension","index":0,"n_rows":175,"n_cols":8,"rows_kept":175,"cut":false,"hidden":false,"merged":[[1,1,21,1],[22,1,27,1]]}
[{"$f":"MAX(A2:A997)","v":27},null,"Loadcases",{"$f":"MAX(E1:AB1)","v":4},1,2,3,4]
[1,"Input Parameter for calculation","EV Number","[-]","NJU15","NJV15","NJU25","NJV25"]
[{"$f":"IF(ISTEXT(C3),A2+1,\"Platzhalter\")","v":2},null,"Materialnumber","[-]",1,2,3,4]
[{"$f":"IF(ISTEXT(C4),A3+1,\"Platzhalter\")","v":3},null,"Size","[inch]",0.5,0.5,1,1]
[4,null,"Name","[-]","Name1","Name2","Name3","Name4"]
[5,null,"Design Pressure","[Mpa]",2,2,2,2]
[6,null,"Design Temperature","[°C]",233,233,233,233]
[7,null,"Actuator Type","[-]","hand op.","hand op.","hand op.","hand op."]
[8,null,"Test Temperature","[°C]"]
[9,null,"Inside bonnet diameter","[mm]",34,45,435,5435]
[10,null,"Outside bonnet diameter","[mm]",34345,345,5353,61.8]
[11,null,"Recess width","[mm]",345,345,345,45]
[12,null,"Thread length","[mm]",346,455,545,45]
[13,null,"Pitch diameter","[mm]",45,45,45,45]
[14,null,"Number of bolts","[-]",1,1,1,1]
[15,null,"Seat diameter","[mm]"]
[16,null,"Max. Actuator Load","[kN]"]
[17,null,"SyTest","[Mpa]"]
[18,null,"SyDesign","[Mpa]"]
[19,null,"Threat Dimension","[-]"]
[20,null,"Material","[-]"]
[{"$f":"IF(ISTEXT(C22),A21+1,\"Platzhalter\")","v":21},"Results","Test Pressure","[Mpa]",10,10,10,10]
[{"$f":"IF(ISTEXT(C23),A22+1,\"Platzhalter\")","v":22},null,"Allowable Stress","[Mpa]"]
[23,null,"Axial Stress from shutoff pressure","[Mpa]"]
[24,null,"Axial Stress from actuator load","[MPa]"]
[25,null,"Thread Stress","[Mpa]"]
[26,null,"OKNOK Thread Stress","[-]","OK","OK","OK","OK"]
[27,null,"Axial strength due to actuator tension","[-]","OK","OK","OK","OK"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
[{"$f":"IF(ISTEXT(C39),A38+1,\"Platzhalter\")","v":"Platzhalter"}]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,266.66666666666663,1.7095763267128816,0,"OK"]

{"sheet":"Formatvorlage_fuer Makro","index":1,"n_rows":49,"n_cols":28,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,21,1],[22,1,27,1]]}
[{"$f":"MAX(A2:A1001)","v":1},null,"Loadcases",{"$f":"MAX(E1:AB1)","v":1},1,{"$f":"IF(ISTEXT(F13),E1+1,\"Platzhalter\")","v":"Platzhalter"},{"$f":"IF(ISTEXT(G13),F1+1,\"Platzhalter\")","v":"Platzhalter"},{"$f":"IF(ISTEXT(H13),G1+1,\"Platzhalter\")","v":"Platzhalter"},"Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter","Platzhalter"]
[1]
[{"$f":"IF(ISTEXT(C3),A2+1,\"Platzhalter\")","v":"Platzhalter"}]
[{"$f":"IF(ISTEXT(C4),A3+1,\"Platzhalter\")","v":"Platzhalter"}]
[{"$f":"IF(ISTEXT(C5),A4+1,\"Platzhalter\")","v":"Platzhalter"}]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]
["Platzhalter"]