{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Welding Parameter Calculation","Processes","SpeedUnits","ROLUnits","TimeUnits","CalculationType","TravelSpeed","Waveform Controlled Calculation","WaveformCalculationType"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Welding Parameter Calculation","index":0,"n_rows":48,"n_cols":44,"rows_kept":48,"cut":false,"hidden":false,"merged":[[8,10,8,22],[8,36,8,43],[8,23,8,35],[31,1,39,8],[47,1,48,8]]}
[]
[]
[null,"Heat input calculator from www.colliewelding.com"]
[null,null,"Heat Input Calculation Type"]
[null,null,"ASME heat input (no efficiency factor)"]
[null,null,"Travel Speed Calculation Type"]
[null,null,"Calculate travel speed"]
[]
[null,null,null,null,null,null,null,null,null,null,"Calculate travel speed",null,null,null,null,null,null,null,null,null,null,null,null,"Use run out length",null,null,null,null,null,null,null,null,null,null,null,null,"Input travel speed directly"]
[null,"Run Number","Process",null,"Process thermal efficiency",null,"Current (A)",null,"Voltage (V)",null,"Weld length","Weld length units",null,"Weld length (mm)",null,"Welding time","Welding time units",null,"Welding time (s)",null,"Travel speed (mm/s)",null,{"$f":"VLOOKUP($C$5,CalculationType!$A$1:$B$2,2,FALSE)","v":"ASME Heat input (kJ/mm)"},"Run out length","Run out length units",null,"Run out length (mm)",null,"Welding time","Welding time units",null,"Welding time (s)",null,"Travel speed (mm/s)",null,{"$f":"VLOOKUP($C$5,CalculationType!$A$1:$B$2,2,FALSE)","v":"ASME Heat input (kJ/mm)"},"Travel speed","Travel speed units",null,"Speed unit factor",null,"Travel speed (mm/s)",null,{"$f":"VLOOKUP($C$5,CalculationType!$A$1:$B$2,2,FALSE)","v":"ASME Heat input (kJ/mm)"}]
[null,1,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C11,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,{"$f":"IF($L11=\"mm\",$K11,IF($L11=\"cm\",$K11*10,$K11*25.4))","v":0},null,null,"minutes",null,{"$f":"IF($Q11=\"seconds\",$P11,$P11*60)","v":0},null,{"$f":"IF($P11=0,0,N11/S11)","v":0},null,{"$f":"IF($U11=0,\"N/A\",(IF($W$10=\"ASME Heat input (kJ/mm)\",(($G11*$I11)/($U11*1000)),(($G11*$I11)/($U11*1000))*$E11)))","v":"N/A"},null,"mm",null,{"$f":"IF($Y11=\"mm\",$X11,IF($Y11=\"cm\",$X11*10,$X11*25.4))","v":0},null,null,"minutes",null,{"$f":"IF($AD11=\"seconds\",$AC11,$AC11*60)","v":0},null,{"$f":"IF($AC11=0,0,AA11/AF11)","v":0},null,{"$f":"IF($AH11=0,\"N/A\",(IF($AJ$10=\"ASME Heat input (kJ/mm)\",(($G11*$I11)/($AH11*1000)),(($G11*$I11)/($AH11*1000))*$E11)))","v":"N/A"},null,"mm/s",null,{"$f":"VLOOKUP($AL11,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,{"$f":"$AK11*$AN11","v":0},null,{"$f":"IF(AP11=0,\"N/A\",(IF($AR$10=\"ASME Heat input (kJ/mm)\",(($G11*$I11)/($AP11*1000)),(($G11*$I11)/($AP11*1000))*$E11)))","v":"N/A"}]
[null,2,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C12,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,{"$f":"IF($P12=0,0,N12/S12)","v":0},null,{"$f":"IF($U12=0,\"N/A\",(IF($W$10=\"ASME Heat input (kJ/mm)\",(($G12*$I12)/($U12*1000)),(($G12*$I12)/($U12*1000))*$E12)))","v":"N/A"},null,"mm",null,{"$f":"IF($Y12=\"mm\",$X12,IF($Y12=\"cm\",$X12*10,$X12*25.4))","v":0},null,null,"minutes",null,{"$f":"IF($AD12=\"seconds\",$AC12,$AC12*60)","v":0},null,{"$f":"IF($AC12=0,0,AA12/AF12)","v":0},null,{"$f":"IF($AH12=0,\"N/A\",(IF($AJ$10=\"ASME Heat input (kJ/mm)\",(($G12*$I12)/($AH12*1000)),(($G12*$I12)/($AH12*1000))*$E12)))","v":"N/A"},null,"mm/s",null,{"$f":"VLOOKUP($AL12,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,{"$f":"$AK12*$AN12","v":0},null,{"$f":"IF(AP12=0,\"N/A\",(IF($AR$10=\"ASME Heat input (kJ/mm)\",(($G12*$I12)/($AP12*1000)),(($G12*$I12)/($AP12*1000))*$E12)))","v":"N/A"}]
[null,3,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C13,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL13,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,4,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C14,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL14,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,5,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C15,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL15,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,6,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C16,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL16,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,7,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C17,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL17,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,8,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C18,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL18,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,9,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C19,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL19,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,10,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C20,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL20,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,11,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C21,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL21,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,12,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C22,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL22,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,13,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C23,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL23,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,14,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C24,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL24,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,15,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C25,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL25,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,16,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C26,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL26,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,17,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C27,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL27,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,18,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C28,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL28,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,19,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C29,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm",null,0,null,null,"minutes",null,0,null,0,null,"N/A",null,"mm/s",null,{"$f":"VLOOKUP($AL29,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,0,null,"N/A"]
[null,20,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C30,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,null,null,"mm",null,0,null,null,"minutes",null,0,null,0,null,{"$f":"IF($U30=0,\"N/A\",(IF($W$10=\"ASME Heat input (kJ/mm)\",(($G30*$I30)/($U30*1000)),(($G30*$I30)/($U30*1000))*$E30)))","v":"N/A"},null,"mm",null,{"$f":"IF($Y30=\"mm\",$X30,IF($Y30=\"cm\",$X30*10,$X30*25.4))","v":0},null,null,"minutes",null,{"$f":"IF($AD30=\"seconds\",$AC30,$AC30*60)","v":0},null,{"$f":"IF($AC30=0,0,AA30/AF30)","v":0},null,{"$f":"IF($AH30=0,\"N/A\",(IF($AJ$10=\"ASME Heat input (kJ/mm)\",(($G30*$I30)/($AH30*1000)),(($G30*$I30)/($AH30*1000))*$E30)))","v":"N/A"},null,"mm/s",null,{"$f":"VLOOKUP($AL30,SpeedUnits!$A$1:$B$6,2,FALSE)","v":1},null,{"$f":"$AK30*$AN30","v":0},null,{"$f":"IF(AP30=0,\"N/A\",(IF($AR$10=\"ASME Heat input (kJ/mm)\",(($G30*$I30)/($AP30*1000)),(($G30*$I30)/($AP30*1000))*$E30)))","v":"N/A"}]
[]
[null,"To use the spreadsheet:\n- Input the relevant values into RED cells\n- Select from the drop-downs in the BLUE cells\n- The spreadsheet will output in the GREEN cells\n- The spreadsheet values can be copy and pasted to other documents if needed\n\nTo change calculation method, simply change the BLUE dropdowns and click the button.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average HI",null,null,null,{"$f":"AVERAGEIF(W11:W30,\"<>0\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Average HI",null,null,null,{"$f":"AVERAGEIF(AJ11:AJ30,\"<>0\")","v":{"$error":"#DIV/0!"}},null,null,null,"Average HI",null,null,null,{"$f":"AVERAGEIF(AR11:AR30,\"<>0\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 Standard Deviation",null,null,null,{"$f":"STDEV(W11:W30)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"1 Standard Deviation",null,null,null,{"$f":"STDEV(AJ11:AJ30)","v":{"$error":"#DIV/0!"}},null,null,null,"1 Standard Deviation",null,null,null,{"$f":"STDEV(AR11:AR30)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum HI",null,null,null,{"$f":"MIN(W11:W30)","v":0},null,null,null,null,null,null,null,null,"Minimum HI",null,null,null,{"$f":"MIN(AJ11:AJ30)","v":0},null,null,null,"Minimum HI",null,null,null,{"$f":"MIN(AR11:AR30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum HI",null,null,null,{"$f":"MAX(W11:W30)","v":0},null,null,null,null,null,null,null,null,"Maximum HI",null,null,null,{"$f":"MAX(AJ11:AJ30)","v":0},null,null,null,"Maximum HI",null,null,null,{"$f":"MAX(AR11:AR30)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",null,null,"Ranges",null,null,null,"Max",null,null,null,null,null,"Min",null,null,"Ranges",null,null,null,"Max","Min",null,null,"Ranges",null,null,null,"Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W34-0.25*W32","v":{"$error":"#DIV/0!"}},null,null,"Min to Max ± 25%",null,null,null,{"$f":"W35+0.25*W32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"AJ34-0.25*AJ32","v":{"$error":"#DIV/0!"}},null,null,"Min to Max ± 25%",null,null,null,{"$f":"AJ35+0.25*AJ32","v":{"$error":"#DIV/0!"}},{"$f":"AR34-0.25*AR32","v":{"$error":"#DIV/0!"}},null,null,"Min to Max ± 25%",null,null,null,{"$f":"AR35+0.25*AR32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.75*W32","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 25%",null,null,null,{"$f":"1.25*W32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"0.75*AJ32","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 25%",null,null,null,{"$f":"1.25*AJ32","v":{"$error":"#DIV/0!"}},{"$f":"0.75*AR32","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 25%",null,null,null,{"$f":"1.25*AR32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.9*(W32-W33)","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD ± 10%",null,null,null,{"$f":"1.1*(W32+W33)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"0.9*(AJ32-AJ33)","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD ± 10%",null,null,null,{"$f":"1.1*(AJ32+AJ33)","v":{"$error":"#DIV/0!"}},{"$f":"0.9*(AR32-AR33)","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD ± 10%",null,null,null,{"$f":"1.1*(AR32+AR33)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W34","v":0},null,null,"Min to Max",null,null,null,{"$f":"W35","v":0},null,null,null,null,null,{"$f":"AJ34","v":0},null,null,"Min to Max",null,null,null,{"$f":"AJ35","v":0},{"$f":"AR34","v":0},null,null,"Min to Max",null,null,null,{"$f":"AR35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W32-W33","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD",null,null,null,{"$f":"W32+W33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"AJ32-AJ33","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD",null,null,null,{"$f":"AJ32+AJ33","v":{"$error":"#DIV/0!"}},{"$f":"AR32-AR33","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD",null,null,null,{"$f":"AR32+AR33","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.9*W32","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 10%",null,null,null,{"$f":"1.1*W32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"0.9*AJ32","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 10%",null,null,null,{"$f":"1.1*AJ32","v":{"$error":"#DIV/0!"}},{"$f":"0.9*AR32","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 10%",null,null,null,{"$f":"1.1*AR32","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,"NOTE: You need to enable macros to begin using this sheet. See the menu bar for \"Options\".\n\nTo begin calculating the heat input, first select your calculation method with the drop-down below. The options are:\n\nHeat Input Calculation Type:\n- Heat input using thermal efficiency, as per BS EN 1011-1\n- Heat not using thermal efficiency (also known as arc energy), as per ASME IX\n\nTravel Speed Calculation Type:\n- If you know the travel speed, you can input it directly\n- If you have a weld length and a welding time, the sheet can calculate speed\n- If you have a run out length and a welding time, the sheet can calculate speed\n\nWhen you have made your selections, press the button."]

{"sheet":"Processes","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Flux cored arc welding (FCAW)",0.8]
["Gas metal arc welding (GMAW)",0.8]
["Gas tungsten arc welding (GTAW)",0.6]
["Manual metal arc welding (MMA)",0.8]
["Metal inert/active gas welding (MIG/MAG)",0.8]
["Plasma arc welding (PAW)",0.6]
["Shielded metal arc welding (SMAW)",0.8]
["Submerged arc welding (SAW)",1]
["Tungsten inert gas welding (TIG)",0.6]

{"sheet":"SpeedUnits","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["mm/s",1]
["mm/min",{"$f":"1/60","v":1.6666666666666666E-2}]
["cm/s",{"$f":"10","v":10}]
["cm/min",{"$f":"1/6","v":0.16666666666666666}]
["inch/s",{"$f":"25.4","v":25.4}]
["inch/min",{"$f":"25.4/60","v":0.42333333333333328}]

{"sheet":"ROLUnits","index":3,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["mm"]
["cm"]
["inches"]

{"sheet":"TimeUnits","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["seconds"]
["minutes"]

{"sheet":"CalculationType","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["ASME heat input (no efficiency factor)","ASME Heat input (kJ/mm)"]
["EN heat input (including thermal efficiency)","EN Heat input (kJ/mm)"]

{"sheet":"TravelSpeed","index":6,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Input travel speed directly"]
["Calculate travel speed"]
["Use run out length"]

{"sheet":"Waveform Controlled Calculation","index":7,"n_rows":50,"n_cols":27,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,14,10,26],[10,6,10,13],[33,2,47,2]]}
[]
[]
[null,null,"Heat input calculator from www.colliewelding.com"]
[]
[null,null,"Energy or Power?"]
[null,null,"Instantaneous Energy"]
[null,null,"Heat Input Calculation Type"]
[null,null,"EN heat input (including thermal efficiency)"]
[]
[]
[null,null,null,null,null,null,"Instantaneous energy",null,null,null,null,null,null,null,"Instantaneous power"]
[null,"Run Number","Process",null,"Process thermal efficiency",null,"Instantaneous energy (J)",null,"Weld bead length","Weld length units",null,"Weld length (mm)",null,{"$f":"VLOOKUP($C$8,CalculationType!$A$1:$B$2,2,FALSE)","v":"EN Heat input (kJ/mm)"},"Instantaneous power (J/s)",null,"Arc time","Arc time units",null,"Arc time (s)",null,"Weld bead length","Weld bead length units",null,"Weld bead length (mm)",null,{"$f":"VLOOKUP($C$8,CalculationType!$A$1:$B$2,2,FALSE)","v":"EN Heat input (kJ/mm)"}]
[null,1,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C13,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,{"$f":"IF($J13=\"mm\",$I13,IF($J13=\"cm\",$I13*10,$I13*25.4))","v":0},null,{"$f":"IF(OR(G13=0,I13=0),\"N/A\",IF(N$12=\"ASME Heat input (kJ/mm)\",G13/(L13*1000),((E13*G13)/(L13*1000))))","v":"N/A"},null,null,null,"seconds",null,{"$f":"IF($R13=\"seconds\",$Q13,$Q13*60)","v":0},null,null,"mm",null,{"$f":"IF($W13=\"mm\",$V13,IF($W13=\"cm\",$V13*10,$V13*25.4))","v":0},null,{"$f":"IF(OR(O13=0,Q13=0,V13=0),\"N/A\",IF(AA$12=\"ASME Heat input (kJ/mm)\",((O13*T13)/(Y13*1000)),((E13*O13*T13)/(Y13*1000))))","v":"N/A"}]
[null,2,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C14,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,{"$f":"IF(OR(G14=0,I14=0),\"N/A\",IF(N$12=\"ASME Heat input (kJ/mm)\",G14/(L14*1000),((E14*G14)/(L14*1000))))","v":"N/A"},null,null,null,"seconds",null,{"$f":"IF($R14=\"seconds\",$Q14,$Q14*60)","v":0},null,null,"mm",null,{"$f":"IF($W14=\"mm\",$V14,IF($W14=\"cm\",$V14*10,$V14*25.4))","v":0},null,{"$f":"IF(OR(O14=0,Q14=0,V14=0),\"N/A\",IF(AA$12=\"ASME Heat input (kJ/mm)\",((O14*T14)/(Y14*1000)),((E14*O14*T14)/(Y14*1000))))","v":"N/A"}]
[null,3,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C15,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,4,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C16,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,5,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C17,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,6,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C18,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,7,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C19,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,8,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C20,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,9,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C21,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,10,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C22,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,{"$f":"IF(OR(G22=0,I22=0),\"N/A\",IF(N$12=\"ASME Heat input (kJ/mm)\",G22/(L22*1000),((E22*G22)/(L22*1000))))","v":"N/A"},null,null,null,"seconds",null,0,null,null,"mm",null,0,null,{"$f":"IF(OR(O22=0,Q22=0,V22=0),\"N/A\",IF(AA$12=\"ASME Heat input (kJ/mm)\",((O22*T22)/(Y22*1000)),((E22*O22*T22)/(Y22*1000))))","v":"N/A"}]
[null,11,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C23,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,12,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C24,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,13,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C25,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,14,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C26,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,15,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C27,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,16,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C28,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,17,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C29,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,18,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C30,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,19,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C31,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[null,20,"Gas metal arc welding (GMAW)",null,{"$f":"VLOOKUP($C32,Processes!$A$1:$B$9,2,FALSE)","v":0.8},null,null,null,null,"mm",null,0,null,"N/A",null,null,null,"seconds",null,0,null,null,"mm",null,0,null,"N/A"]
[]
[null,null,"To use the spreadsheet:\n- Input the relevant values into RED cells\n- Select from the drop-downs in the BLUE cells\n- The spreadsheet will output in the GREEN cells\n- The spreadsheet values can be copy and pasted to other documents if needed\n\nTo change calculation method, simply change the BLUE dropdowns and click the button.",null,null,null,null,null,null,"Average HI",null,null,null,{"$f":"AVERAGEIF(N13:N32,\"<>0\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Average HI",null,null,null,{"$f":"AVERAGEIF(AA13:AA32,\"<>0\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,"1 Standard Deviation",null,null,null,{"$f":"STDEV(N13:N32)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"1 Standard Deviation",null,null,null,{"$f":"STDEV(AA13:AA32)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,"Minimum HI",null,null,null,{"$f":"MIN(N13:N32)","v":0},null,null,null,null,null,null,null,null,"Minimum HI",null,null,null,{"$f":"MIN(AA13:AA32)","v":0}]
[null,null,null,null,null,null,null,null,null,"Maximum HI",null,null,null,{"$f":"MAX(N13:N32)","v":0},null,null,null,null,null,null,null,null,"Maximum HI",null,null,null,{"$f":"MAX(AA13:AA32)","v":0}]
[]
[null,null,null,null,null,null,"Min",null,null,"Ranges",null,null,null,"Max",null,null,null,null,null,null,null,"Min",null,"Ranges",null,null,"Max"]
[null,null,null,null,null,null,{"$f":"N36-(0.25*N34)","v":{"$error":"#DIV/0!"}},null,null,"Min to Max ± 25%",null,null,null,{"$f":"N37+(0.25*N34)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"AA36-(0.25*AA34)","v":{"$error":"#DIV/0!"}},null,"Min to Max ± 25%",null,null,{"$f":"AA37+(0.25*AA34)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"0.75*N34","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 25%",null,null,null,{"$f":"1.25*N34","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"0.75*AA34","v":{"$error":"#DIV/0!"}},null,"Mean ± 25%",null,null,{"$f":"1.25*AA34","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"0.9*(N34-N35)","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD ± 10%",null,null,null,{"$f":"1.1*(N34+N35)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"0.9*(AA34-AA35)","v":{"$error":"#DIV/0!"}},null,"Mean ± 1 SD ± 10%",null,null,{"$f":"1.1*(AA34+AA35)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"N36","v":0},null,null,"Min to Max",null,null,null,{"$f":"N37","v":0},null,null,null,null,null,null,null,{"$f":"AA36","v":0},null,"Min to Max",null,null,{"$f":"AA37","v":0}]
[null,null,null,null,null,null,{"$f":"N34-N35","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 1 SD",null,null,null,{"$f":"N34+N35","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"AA34-AA35","v":{"$error":"#DIV/0!"}},null,"Mean ± 1 SD",null,null,{"$f":"AA34+AA35","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"0.9*N34","v":{"$error":"#DIV/0!"}},null,null,"Mean ± 10%",null,null,null,{"$f":"1.1*N34","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"0.9*AA34","v":{"$error":"#DIV/0!"}},null,"Mean ± 10%",null,null,{"$f":"1.1*AA34","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,"NOTE: You need to enable macros to begin using this sheet. See the menu bar for \"Options\".\n\nTo begin calculating the heat input, first select your calculation method with the drop-down below. The options are:\n\nHeat Input Calculation Type:\n- Heat input using thermal efficiency, as per BS EN 1011-1\n- Heat not using thermal efficiency (also known as arc energy), as per ASME IX\n\nTravel Speed Calculation Type:\n- If you know the travel speed, you can input it directly\n- If you have a weld length and a welding time, the sheet can calculate speed\n- If you have a run out length and a welding time, the sheet can calculate speed\n\nWhen you have made your selections, press the button."]

{"sheet":"WaveformCalculationType","index":8,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Instantaneous Power"]
["Instantaneous Energy"]