Staalprofielen tabel (IPE, HEA, HEB, UNP)

Formulas:

• h_fy = if(staalsoort == 's355', 355, if(staalsoort == 's275', 275, 235))
  
• h_eps = sqrt(235 / h_fy)
  
• h_v_med = if(situatie != 'opzoeken', med, 0)
  
• h_zoek_ipe = if(staalsoort == 's355', if(h_v_med <= 8.24, 'ipe80', if(h_v_med <= 13.99, 'ipe100', if(h_v_med <= 21.56, 'ipe120', if(h_v_med <= 31.36, 'ipe140', if(h_v_med <= 43.98, 'ipe160', if(h_v_med <= 59.07, 'ipe180', if(h_v_med <= 78.31, 'ipe200', if(h_v_med <= 101.32, 'ipe220', if(h_v_med <= 130.14, 'ipe240', if(h_v_med <= 171.82, 'ipe270', if(h_v_med <= 223.08, 'ipe300', if(h_v_med <= 285.53, 'ipe330', if(h_v_med <= 361.75, 'ipe360', if(h_v_med <= 463.99, 'ipe400', if(h_v_med <= 604.21, 'ipe450', if(h_v_med <= 778.87, 'ipe500', if(h_v_med <= 989.38, 'ipe550', 'ipe600'))))))))))))))))), if(staalsoort == 's275', if(h_v_med <= 6.39, 'ipe80', if(h_v_med <= 10.84, 'ipe100', if(h_v_med <= 16.7, 'ipe120', if(h_v_med <= 24.29, 'ipe140', if(h_v_med <= 34.07, 'ipe160', if(h_v_med <= 45.76, 'ipe180', if(h_v_med <= 60.66, 'ipe200', if(h_v_med <= 78.48, 'ipe220', if(h_v_med <= 100.81, 'ipe240', if(h_v_med <= 133.1, 'ipe270', if(h_v_med <= 172.81, 'ipe300', if(h_v_med <= 221.18, 'ipe330', if(h_v_med <= 280.23, 'ipe360', if(h_v_med <= 359.43, 'ipe400', if(h_v_med <= 468.05, 'ipe450', if(h_v_med <= 603.35, 'ipe500', if(h_v_med <= 766.42, 'ipe550', 'ipe600'))))))))))))))))), if(h_v_med <= 5.46, 'ipe80', if(h_v_med <= 9.26, 'ipe100', if(h_v_med <= 14.27, 'ipe120', if(h_v_med <= 20.76, 'ipe140', if(h_v_med <= 29.12, 'ipe160', if(h_v_med <= 39.1, 'ipe180', if(h_v_med <= 51.84, 'ipe200', if(h_v_med <= 67.07, 'ipe220', if(h_v_med <= 86.15, 'ipe240', if(h_v_med <= 113.74, 'ipe270', if(h_v_med <= 147.67, 'ipe300', if(h_v_med <= 189.01, 'ipe330', if(h_v_med <= 239.47, 'ipe360', if(h_v_med <= 307.14, 'ipe400', if(h_v_med <= 399.97, 'ipe450', if(h_v_med <= 515.59, 'ipe500', if(h_v_med <= 654.95, 'ipe550', 'ipe600')))))))))))))))))))
  
• h_zoek_hea = if(staalsoort == 's355', if(h_v_med <= 29.47, 'hea100', if(h_v_med <= 42.42, 'hea120', if(h_v_med <= 61.59, 'hea140', if(h_v_med <= 87.01, 'hea160', if(h_v_med <= 115.34, 'hea180', if(h_v_med <= 152.47, 'hea200', if(h_v_med <= 201.82, 'hea220', if(h_v_med <= 264.33, 'hea240', if(h_v_med <= 296.92, 'hea260', if(h_v_med <= 359.62, 'hea280', if(h_v_med <= 447.3, 'hea300', if(h_v_med <= 577.94, 'hea320', if(h_v_med <= 656.75, 'hea340', if(h_v_med <= 741.24, 'hea360', if(h_v_med <= 909.51, 'hea400', if(h_v_med <= 1141.68, 'hea450', if(h_v_med <= 1401.89, 'hea500', if(h_v_med <= 1640.81, 'hea550', 'hea600')))))))))))))))))), if(staalsoort == 's275', if(h_v_med <= 22.83, 'hea100', if(h_v_med <= 32.86, 'hea120', if(h_v_med <= 47.71, 'hea140', if(h_v_med <= 67.4, 'hea160', if(h_v_med <= 89.35, 'hea180', if(h_v_med <= 118.11, 'hea200', if(h_v_med <= 156.34, 'hea220', if(h_v_med <= 204.76, 'hea240', if(h_v_med <= 252.94, 'hea260', if(h_v_med <= 305.8, 'hea280', if(h_v_med <= 380.32, 'hea300', if(h_v_med <= 447.7, 'hea320', if(h_v_med <= 508.75, 'hea340', if(h_v_med <= 574.2, 'hea360', if(h_v_med <= 704.55, 'hea400', if(h_v_med <= 884.4, 'hea450', if(h_v_med <= 1085.97, 'hea500', if(h_v_med <= 1271.05, 'hea550', 'hea600')))))))))))))))))), if(h_v_med <= 19.51, 'hea100', if(h_v_med <= 28.08, 'hea120', if(h_v_med <= 40.77, 'hea140', if(h_v_med <= 57.6, 'hea160', if(h_v_med <= 76.35, 'hea180', if(h_v_med <= 100.93, 'hea200', if(h_v_med <= 133.6, 'hea220', if(h_v_med <= 174.98, 'hea240', if(h_v_med <= 216.15, 'hea260', if(h_v_med <= 261.32, 'hea280', if(h_v_med <= 325, 'hea300', if(h_v_med <= 382.58, 'hea320', if(h_v_med <= 434.75, 'hea340', if(h_v_med <= 490.68, 'hea360', if(h_v_med <= 602.07, 'hea400', if(h_v_med <= 755.76, 'hea450', if(h_v_med <= 928.01, 'hea500', if(h_v_med <= 1086.17, 'hea550', 'hea600'))))))))))))))))))))
  
• h_zoek_heb = if(staalsoort == 's355', if(h_v_med <= 36.99, 'heb100', if(h_v_med <= 58.65, 'heb120', if(h_v_med <= 87.12, 'heb140', if(h_v_med <= 125.67, 'heb160', if(h_v_med <= 170.9, 'heb180', if(h_v_med <= 228.09, 'heb200', if(h_v_med <= 293.58, 'heb220', if(h_v_med <= 373.81, 'heb240', if(h_v_med <= 455.46, 'heb260', if(h_v_med <= 544.57, 'heb280', if(h_v_med <= 663.5, 'heb300', if(h_v_med <= 762.89, 'heb320', if(h_v_med <= 854.84, 'heb340', if(h_v_med <= 952.47, 'heb360', if(h_v_med <= 1147.36, 'heb400', if(h_v_med <= 1413.61, 'heb450', if(h_v_med <= 1709.33, 'heb500', if(h_v_med <= 1984.81, 'heb550', 'heb600')))))))))))))))))), if(staalsoort == 's275', if(h_v_med <= 28.66, 'heb100', if(h_v_med <= 45.43, 'heb120', if(h_v_med <= 67.48, 'heb140', if(h_v_med <= 97.35, 'heb160', if(h_v_med <= 132.38, 'heb180', if(h_v_med <= 176.69, 'heb200', if(h_v_med <= 227.43, 'heb220', if(h_v_med <= 289.57, 'heb240', if(h_v_med <= 352.82, 'heb260', if(h_v_med <= 421.85, 'heb280', if(h_v_med <= 513.98, 'heb300', if(h_v_med <= 590.98, 'heb320', if(h_v_med <= 662.2, 'heb340', if(h_v_med <= 737.83, 'heb360', if(h_v_med <= 888.8, 'heb400', if(h_v_med <= 1095.05, 'heb450', if(h_v_med <= 1324.12, 'heb500', if(h_v_med <= 1537.53, 'heb550', 'heb600')))))))))))))))))), if(h_v_med <= 24.49, 'heb100', if(h_v_med <= 38.82, 'heb120', if(h_v_med <= 57.67, 'heb140', if(h_v_med <= 83.19, 'heb160', if(h_v_med <= 113.13, 'heb180', if(h_v_med <= 150.99, 'heb200', if(h_v_med <= 194.34, 'heb220', if(h_v_med <= 247.46, 'heb240', if(h_v_med <= 301.5, 'heb260', if(h_v_med <= 360.49, 'heb280', if(h_v_med <= 439.21, 'heb300', if(h_v_med <= 505.01, 'heb320', if(h_v_med <= 565.88, 'heb340', if(h_v_med <= 630.5, 'heb360', if(h_v_med <= 759.52, 'heb400', if(h_v_med <= 935.77, 'heb450', if(h_v_med <= 1131.53, 'heb500', if(h_v_med <= 1313.88, 'heb550', 'heb600'))))))))))))))))))))
  
• h_zoek_unp = if(staalsoort == 's355', if(h_v_med <= 11.47, 'unp80', if(h_v_med <= 17.39, 'unp100', if(h_v_med <= 25.77, 'unp120', if(h_v_med <= 36.56, 'unp140', if(h_v_med <= 48.99, 'unp160', if(h_v_med <= 63.55, 'unp180', if(h_v_med <= 80.94, 'unp200', if(h_v_med <= 103.66, 'unp220', if(h_v_med <= 127.09, 'unp240', if(h_v_med <= 156.91, 'unp260', if(h_v_med <= 188.86, 'unp280', if(h_v_med <= 224.36, 'unp300', if(h_v_med <= 293.23, 'unp320', if(h_v_med <= 325.89, 'unp350', if(h_v_med <= 358.55, 'unp380', 'unp400'))))))))))))))), if(staalsoort == 's275', if(h_v_med <= 8.88, 'unp80', if(h_v_med <= 13.47, 'unp100', if(h_v_med <= 19.96, 'unp120', if(h_v_med <= 28.32, 'unp140', if(h_v_med <= 37.95, 'unp160', if(h_v_med <= 49.23, 'unp180', if(h_v_med <= 62.7, 'unp200', if(h_v_med <= 80.3, 'unp220', if(h_v_med <= 98.45, 'unp240', if(h_v_med <= 121.55, 'unp260', if(h_v_med <= 146.3, 'unp280', if(h_v_med <= 173.8, 'unp300', if(h_v_med <= 227.15, 'unp320', if(h_v_med <= 252.45, 'unp350', if(h_v_med <= 277.75, 'unp380', 'unp400'))))))))))))))), if(h_v_med <= 7.59, 'unp80', if(h_v_med <= 11.52, 'unp100', if(h_v_med <= 17.06, 'unp120', if(h_v_med <= 24.2, 'unp140', if(h_v_med <= 32.43, 'unp160', if(h_v_med <= 42.06, 'unp180', if(h_v_med <= 53.58, 'unp200', if(h_v_med <= 68.62, 'unp220', if(h_v_med <= 84.13, 'unp240', if(h_v_med <= 103.87, 'unp260', if(h_v_med <= 125.02, 'unp280', if(h_v_med <= 148.52, 'unp300', if(h_v_med <= 194.11, 'unp320', if(h_v_med <= 215.73, 'unp350', if(h_v_med <= 237.35, 'unp380', 'unp400')))))))))))))))))
  
• h_code = if(situatie == 'zoeken', if(familie == 'ipe', h_zoek_ipe, if(familie == 'hea', h_zoek_hea, if(familie == 'heb', h_zoek_heb, h_zoek_unp))), profiel)
  
• h_h_ipe = if(h_code == 'ipe80', 80, if(h_code == 'ipe100', 100, if(h_code == 'ipe120', 120, if(h_code == 'ipe140', 140, if(h_code == 'ipe160', 160, if(h_code == 'ipe180', 180, if(h_code == 'ipe200', 200, if(h_code == 'ipe220', 220, if(h_code == 'ipe240', 240, if(h_code == 'ipe270', 270, if(h_code == 'ipe300', 300, if(h_code == 'ipe330', 330, if(h_code == 'ipe360', 360, if(h_code == 'ipe400', 400, if(h_code == 'ipe450', 450, if(h_code == 'ipe500', 500, if(h_code == 'ipe550', 550, if(h_code == 'ipe600', 600, 0))))))))))))))))))
  
• h_h_hea = if(h_code == 'hea100', 96, if(h_code == 'hea120', 114, if(h_code == 'hea140', 133, if(h_code == 'hea160', 152, if(h_code == 'hea180', 171, if(h_code == 'hea200', 190, if(h_code == 'hea220', 210, if(h_code == 'hea240', 230, if(h_code == 'hea260', 250, if(h_code == 'hea280', 270, if(h_code == 'hea300', 290, if(h_code == 'hea320', 310, if(h_code == 'hea340', 330, if(h_code == 'hea360', 350, if(h_code == 'hea400', 390, if(h_code == 'hea450', 440, if(h_code == 'hea500', 490, if(h_code == 'hea550', 540, if(h_code == 'hea600', 590, 0)))))))))))))))))))
  
• h_h_heb = if(h_code == 'heb100', 100, if(h_code == 'heb120', 120, if(h_code == 'heb140', 140, if(h_code == 'heb160', 160, if(h_code == 'heb180', 180, if(h_code == 'heb200', 200, if(h_code == 'heb220', 220, if(h_code == 'heb240', 240, if(h_code == 'heb260', 260, if(h_code == 'heb280', 280, if(h_code == 'heb300', 300, if(h_code == 'heb320', 320, if(h_code == 'heb340', 340, if(h_code == 'heb360', 360, if(h_code == 'heb400', 400, if(h_code == 'heb450', 450, if(h_code == 'heb500', 500, if(h_code == 'heb550', 550, if(h_code == 'heb600', 600, 0)))))))))))))))))))
  
• h_h_unp = if(h_code == 'unp80', 80, if(h_code == 'unp100', 100, if(h_code == 'unp120', 120, if(h_code == 'unp140', 140, if(h_code == 'unp160', 160, if(h_code == 'unp180', 180, if(h_code == 'unp200', 200, if(h_code == 'unp220', 220, if(h_code == 'unp240', 240, if(h_code == 'unp260', 260, if(h_code == 'unp280', 280, if(h_code == 'unp300', 300, if(h_code == 'unp320', 320, if(h_code == 'unp350', 350, if(h_code == 'unp380', 380, if(h_code == 'unp400', 400, 0))))))))))))))))
  
• h_h = h_h_ipe + h_h_hea + h_h_heb + h_h_unp
  
• h_b_ipe = if(h_code == 'ipe80', 46, if(h_code == 'ipe100', 55, if(h_code == 'ipe120', 64, if(h_code == 'ipe140', 73, if(h_code == 'ipe160', 82, if(h_code == 'ipe180', 91, if(h_code == 'ipe200', 100, if(h_code == 'ipe220', 110, if(h_code == 'ipe240', 120, if(h_code == 'ipe270', 135, if(h_code == 'ipe300', 150, if(h_code == 'ipe330', 160, if(h_code == 'ipe360', 170, if(h_code == 'ipe400', 180, if(h_code == 'ipe450', 190, if(h_code == 'ipe500', 200, if(h_code == 'ipe550', 210, if(h_code == 'ipe600', 220, 0))))))))))))))))))
  
• h_b_hea = if(h_code == 'hea100', 100, if(h_code == 'hea120', 120, if(h_code == 'hea140', 140, if(h_code == 'hea160', 160, if(h_code == 'hea180', 180, if(h_code == 'hea200', 200, if(h_code == 'hea220', 220, if(h_code == 'hea240', 240, if(h_code == 'hea260', 260, if(h_code == 'hea280', 280, if(h_code == 'hea300', 300, if(h_code == 'hea320', 300, if(h_code == 'hea340', 300, if(h_code == 'hea360', 300, if(h_code == 'hea400', 300, if(h_code == 'hea450', 300, if(h_code == 'hea500', 300, if(h_code == 'hea550', 300, if(h_code == 'hea600', 300, 0)))))))))))))))))))
  
• h_b_heb = if(h_code == 'heb100', 100, if(h_code == 'heb120', 120, if(h_code == 'heb140', 140, if(h_code == 'heb160', 160, if(h_code == 'heb180', 180, if(h_code == 'heb200', 200, if(h_code == 'heb220', 220, if(h_code == 'heb240', 240, if(h_code == 'heb260', 260, if(h_code == 'heb280', 280, if(h_code == 'heb300', 300, if(h_code == 'heb320', 300, if(h_code == 'heb340', 300, if(h_code == 'heb360', 300, if(h_code == 'heb400', 300, if(h_code == 'heb450', 300, if(h_code == 'heb500', 300, if(h_code == 'heb550', 300, if(h_code == 'heb600', 300, 0)))))))))))))))))))
  
• h_b_unp = if(h_code == 'unp80', 45, if(h_code == 'unp100', 50, if(h_code == 'unp120', 55, if(h_code == 'unp140', 60, if(h_code == 'unp160', 65, if(h_code == 'unp180', 70, if(h_code == 'unp200', 75, if(h_code == 'unp220', 80, if(h_code == 'unp240', 85, if(h_code == 'unp260', 90, if(h_code == 'unp280', 95, if(h_code == 'unp300', 100, if(h_code == 'unp320', 100, if(h_code == 'unp350', 100, if(h_code == 'unp380', 102, if(h_code == 'unp400', 110, 0))))))))))))))))
  
• h_b = h_b_ipe + h_b_hea + h_b_heb + h_b_unp
  
• h_tw_ipe = if(h_code == 'ipe80', 3.8, if(h_code == 'ipe100', 4.1, if(h_code == 'ipe120', 4.4, if(h_code == 'ipe140', 4.7, if(h_code == 'ipe160', 5, if(h_code == 'ipe180', 5.3, if(h_code == 'ipe200', 5.6, if(h_code == 'ipe220', 5.9, if(h_code == 'ipe240', 6.2, if(h_code == 'ipe270', 6.6, if(h_code == 'ipe300', 7.1, if(h_code == 'ipe330', 7.5, if(h_code == 'ipe360', 8, if(h_code == 'ipe400', 8.6, if(h_code == 'ipe450', 9.4, if(h_code == 'ipe500', 10.2, if(h_code == 'ipe550', 11.1, if(h_code == 'ipe600', 12, 0))))))))))))))))))
  
• h_tw_hea = if(h_code == 'hea100', 5, if(h_code == 'hea120', 5, if(h_code == 'hea140', 5.5, if(h_code == 'hea160', 6, if(h_code == 'hea180', 6, if(h_code == 'hea200', 6.5, if(h_code == 'hea220', 7, if(h_code == 'hea240', 7.5, if(h_code == 'hea260', 7.5, if(h_code == 'hea280', 8, if(h_code == 'hea300', 8.5, if(h_code == 'hea320', 9, if(h_code == 'hea340', 9.5, if(h_code == 'hea360', 10, if(h_code == 'hea400', 11, if(h_code == 'hea450', 11.5, if(h_code == 'hea500', 12, if(h_code == 'hea550', 12.5, if(h_code == 'hea600', 13, 0)))))))))))))))))))
  
• h_tw_heb = if(h_code == 'heb100', 6, if(h_code == 'heb120', 6.5, if(h_code == 'heb140', 7, if(h_code == 'heb160', 8, if(h_code == 'heb180', 8.5, if(h_code == 'heb200', 9, if(h_code == 'heb220', 9.5, if(h_code == 'heb240', 10, if(h_code == 'heb260', 10, if(h_code == 'heb280', 10.5, if(h_code == 'heb300', 11, if(h_code == 'heb320', 11.5, if(h_code == 'heb340', 12, if(h_code == 'heb360', 12.5, if(h_code == 'heb400', 13.5, if(h_code == 'heb450', 14, if(h_code == 'heb500', 14.5, if(h_code == 'heb550', 15, if(h_code == 'heb600', 15.5, 0)))))))))))))))))))
  
• h_tw_unp = if(h_code == 'unp80', 6, if(h_code == 'unp100', 6, if(h_code == 'unp120', 7, if(h_code == 'unp140', 7, if(h_code == 'unp160', 7.5, if(h_code == 'unp180', 8, if(h_code == 'unp200', 8.5, if(h_code == 'unp220', 9, if(h_code == 'unp240', 9.5, if(h_code == 'unp260', 10, if(h_code == 'unp280', 10, if(h_code == 'unp300', 10, if(h_code == 'unp320', 14, if(h_code == 'unp350', 14, if(h_code == 'unp380', 13.5, if(h_code == 'unp400', 14, 0))))))))))))))))
  
• h_tw = h_tw_ipe + h_tw_hea + h_tw_heb + h_tw_unp
  
• h_tf_ipe = if(h_code == 'ipe80', 5.2, if(h_code == 'ipe100', 5.7, if(h_code == 'ipe120', 6.3, if(h_code == 'ipe140', 6.9, if(h_code == 'ipe160', 7.4, if(h_code == 'ipe180', 8, if(h_code == 'ipe200', 8.5, if(h_code == 'ipe220', 9.2, if(h_code == 'ipe240', 9.8, if(h_code == 'ipe270', 10.2, if(h_code == 'ipe300', 10.7, if(h_code == 'ipe330', 11.5, if(h_code == 'ipe360', 12.7, if(h_code == 'ipe400', 13.5, if(h_code == 'ipe450', 14.6, if(h_code == 'ipe500', 16, if(h_code == 'ipe550', 17.2, if(h_code == 'ipe600', 19, 0))))))))))))))))))
  
• h_tf_hea = if(h_code == 'hea100', 8, if(h_code == 'hea120', 8, if(h_code == 'hea140', 8.5, if(h_code == 'hea160', 9, if(h_code == 'hea180', 9.5, if(h_code == 'hea200', 10, if(h_code == 'hea220', 11, if(h_code == 'hea240', 12, if(h_code == 'hea260', 12.5, if(h_code == 'hea280', 13, if(h_code == 'hea300', 14, if(h_code == 'hea320', 15.5, if(h_code == 'hea340', 16.5, if(h_code == 'hea360', 17.5, if(h_code == 'hea400', 19, if(h_code == 'hea450', 21, if(h_code == 'hea500', 23, if(h_code == 'hea550', 24, if(h_code == 'hea600', 25, 0)))))))))))))))))))
  
• h_tf_heb = if(h_code == 'heb100', 10, if(h_code == 'heb120', 11, if(h_code == 'heb140', 12, if(h_code == 'heb160', 13, if(h_code == 'heb180', 14, if(h_code == 'heb200', 15, if(h_code == 'heb220', 16, if(h_code == 'heb240', 17, if(h_code == 'heb260', 17.5, if(h_code == 'heb280', 18, if(h_code == 'heb300', 19, if(h_code == 'heb320', 20.5, if(h_code == 'heb340', 21.5, if(h_code == 'heb360', 22.5, if(h_code == 'heb400', 24, if(h_code == 'heb450', 26, if(h_code == 'heb500', 28, if(h_code == 'heb550', 29, if(h_code == 'heb600', 30, 0)))))))))))))))))))
  
• h_tf_unp = if(h_code == 'unp80', 8, if(h_code == 'unp100', 8.5, if(h_code == 'unp120', 9, if(h_code == 'unp140', 10, if(h_code == 'unp160', 10.5, if(h_code == 'unp180', 11, if(h_code == 'unp200', 11.5, if(h_code == 'unp220', 12.5, if(h_code == 'unp240', 13, if(h_code == 'unp260', 14, if(h_code == 'unp280', 15, if(h_code == 'unp300', 16, if(h_code == 'unp320', 17.5, if(h_code == 'unp350', 16, if(h_code == 'unp380', 16, if(h_code == 'unp400', 18, 0))))))))))))))))
  
• h_tf = h_tf_ipe + h_tf_hea + h_tf_heb + h_tf_unp
  
• h_r_ipe = if(h_code == 'ipe80', 5, if(h_code == 'ipe100', 7, if(h_code == 'ipe120', 7, if(h_code == 'ipe140', 7, if(h_code == 'ipe160', 9, if(h_code == 'ipe180', 9, if(h_code == 'ipe200', 12, if(h_code == 'ipe220', 12, if(h_code == 'ipe240', 15, if(h_code == 'ipe270', 15, if(h_code == 'ipe300', 15, if(h_code == 'ipe330', 18, if(h_code == 'ipe360', 18, if(h_code == 'ipe400', 21, if(h_code == 'ipe450', 21, if(h_code == 'ipe500', 21, if(h_code == 'ipe550', 24, if(h_code == 'ipe600', 24, 0))))))))))))))))))
  
• h_r_hea = if(h_code == 'hea100', 12, if(h_code == 'hea120', 12, if(h_code == 'hea140', 12, if(h_code == 'hea160', 15, if(h_code == 'hea180', 15, if(h_code == 'hea200', 18, if(h_code == 'hea220', 18, if(h_code == 'hea240', 21, if(h_code == 'hea260', 24, if(h_code == 'hea280', 24, if(h_code == 'hea300', 27, if(h_code == 'hea320', 27, if(h_code == 'hea340', 27, if(h_code == 'hea360', 27, if(h_code == 'hea400', 27, if(h_code == 'hea450', 27, if(h_code == 'hea500', 27, if(h_code == 'hea550', 27, if(h_code == 'hea600', 27, 0)))))))))))))))))))
  
• h_r_heb = if(h_code == 'heb100', 12, if(h_code == 'heb120', 12, if(h_code == 'heb140', 12, if(h_code == 'heb160', 15, if(h_code == 'heb180', 15, if(h_code == 'heb200', 18, if(h_code == 'heb220', 18, if(h_code == 'heb240', 21, if(h_code == 'heb260', 24, if(h_code == 'heb280', 24, if(h_code == 'heb300', 27, if(h_code == 'heb320', 27, if(h_code == 'heb340', 27, if(h_code == 'heb360', 27, if(h_code == 'heb400', 27, if(h_code == 'heb450', 27, if(h_code == 'heb500', 27, if(h_code == 'heb550', 27, if(h_code == 'heb600', 27, 0)))))))))))))))))))
  
• h_r_unp = if(h_code == 'unp80', 8, if(h_code == 'unp100', 9, if(h_code == 'unp120', 9, if(h_code == 'unp140', 10, if(h_code == 'unp160', 11, if(h_code == 'unp180', 11, if(h_code == 'unp200', 12, if(h_code == 'unp220', 13, if(h_code == 'unp240', 13, if(h_code == 'unp260', 14, if(h_code == 'unp280', 15, if(h_code == 'unp300', 16, if(h_code == 'unp320', 18, if(h_code == 'unp350', 16, if(h_code == 'unp380', 16, if(h_code == 'unp400', 18, 0))))))))))))))))
  
• h_r = h_r_ipe + h_r_hea + h_r_heb + h_r_unp
  
• h_g_ipe = if(h_code == 'ipe80', 6, if(h_code == 'ipe100', 8.1, if(h_code == 'ipe120', 10.4, if(h_code == 'ipe140', 12.9, if(h_code == 'ipe160', 15.8, if(h_code == 'ipe180', 18.8, if(h_code == 'ipe200', 22.4, if(h_code == 'ipe220', 26.2, if(h_code == 'ipe240', 30.7, if(h_code == 'ipe270', 36.1, if(h_code == 'ipe300', 42.2, if(h_code == 'ipe330', 49.1, if(h_code == 'ipe360', 57.1, if(h_code == 'ipe400', 66.3, if(h_code == 'ipe450', 77.6, if(h_code == 'ipe500', 90.7, if(h_code == 'ipe550', 105.5, if(h_code == 'ipe600', 122.4, 0))))))))))))))))))
  
• h_g_hea = if(h_code == 'hea100', 16.7, if(h_code == 'hea120', 19.9, if(h_code == 'hea140', 24.7, if(h_code == 'hea160', 30.4, if(h_code == 'hea180', 35.5, if(h_code == 'hea200', 42.3, if(h_code == 'hea220', 50.5, if(h_code == 'hea240', 60.3, if(h_code == 'hea260', 68.2, if(h_code == 'hea280', 76.4, if(h_code == 'hea300', 88.3, if(h_code == 'hea320', 97.6, if(h_code == 'hea340', 104.8, if(h_code == 'hea360', 112.1, if(h_code == 'hea400', 124.8, if(h_code == 'hea450', 139.8, if(h_code == 'hea500', 155.1, if(h_code == 'hea550', 166.2, if(h_code == 'hea600', 177.8, 0)))))))))))))))))))
  
• h_g_heb = if(h_code == 'heb100', 20.4, if(h_code == 'heb120', 26.7, if(h_code == 'heb140', 33.7, if(h_code == 'heb160', 42.6, if(h_code == 'heb180', 51.2, if(h_code == 'heb200', 61.3, if(h_code == 'heb220', 71.5, if(h_code == 'heb240', 83.2, if(h_code == 'heb260', 93, if(h_code == 'heb280', 103.1, if(h_code == 'heb300', 117, if(h_code == 'heb320', 126.7, if(h_code == 'heb340', 134.2, if(h_code == 'heb360', 141.8, if(h_code == 'heb400', 155.3, if(h_code == 'heb450', 171.1, if(h_code == 'heb500', 187.3, if(h_code == 'heb550', 199.4, if(h_code == 'heb600', 211.9, 0)))))))))))))))))))
  
• h_g_unp = if(h_code == 'unp80', 8.64, if(h_code == 'unp100', 10.6, if(h_code == 'unp120', 13.4, if(h_code == 'unp140', 16, if(h_code == 'unp160', 18.8, if(h_code == 'unp180', 22, if(h_code == 'unp200', 25.3, if(h_code == 'unp220', 29.4, if(h_code == 'unp240', 33.2, if(h_code == 'unp260', 37.9, if(h_code == 'unp280', 41.8, if(h_code == 'unp300', 46.2, if(h_code == 'unp320', 59.5, if(h_code == 'unp350', 60.6, if(h_code == 'unp380', 63.1, if(h_code == 'unp400', 71.8, 0))))))))))))))))
  
• h_g = h_g_ipe + h_g_hea + h_g_heb + h_g_unp
  
• h_a_ipe = if(h_code == 'ipe80', 7.64, if(h_code == 'ipe100', 10.32, if(h_code == 'ipe120', 13.21, if(h_code == 'ipe140', 16.43, if(h_code == 'ipe160', 20.09, if(h_code == 'ipe180', 23.95, if(h_code == 'ipe200', 28.48, if(h_code == 'ipe220', 33.37, if(h_code == 'ipe240', 39.12, if(h_code == 'ipe270', 45.95, if(h_code == 'ipe300', 53.81, if(h_code == 'ipe330', 62.61, if(h_code == 'ipe360', 72.73, if(h_code == 'ipe400', 84.46, if(h_code == 'ipe450', 98.82, if(h_code == 'ipe500', 115.5, if(h_code == 'ipe550', 134.4, if(h_code == 'ipe600', 156, 0))))))))))))))))))
  
• h_a_hea = if(h_code == 'hea100', 21.24, if(h_code == 'hea120', 25.34, if(h_code == 'hea140', 31.42, if(h_code == 'hea160', 38.77, if(h_code == 'hea180', 45.25, if(h_code == 'hea200', 53.83, if(h_code == 'hea220', 64.34, if(h_code == 'hea240', 76.84, if(h_code == 'hea260', 86.82, if(h_code == 'hea280', 97.26, if(h_code == 'hea300', 112.5, if(h_code == 'hea320', 124.4, if(h_code == 'hea340', 133.5, if(h_code == 'hea360', 142.8, if(h_code == 'hea400', 159, if(h_code == 'hea450', 178, if(h_code == 'hea500', 197.5, if(h_code == 'hea550', 211.8, if(h_code == 'hea600', 226.5, 0)))))))))))))))))))
  
• h_a_heb = if(h_code == 'heb100', 26.04, if(h_code == 'heb120', 34.01, if(h_code == 'heb140', 42.96, if(h_code == 'heb160', 54.25, if(h_code == 'heb180', 65.25, if(h_code == 'heb200', 78.08, if(h_code == 'heb220', 91.04, if(h_code == 'heb240', 106, if(h_code == 'heb260', 118.4, if(h_code == 'heb280', 131.4, if(h_code == 'heb300', 149.1, if(h_code == 'heb320', 161.3, if(h_code == 'heb340', 170.9, if(h_code == 'heb360', 180.6, if(h_code == 'heb400', 197.8, if(h_code == 'heb450', 218, if(h_code == 'heb500', 238.6, if(h_code == 'heb550', 254.1, if(h_code == 'heb600', 270, 0)))))))))))))))))))
  
• h_a_unp = if(h_code == 'unp80', 11, if(h_code == 'unp100', 13.5, if(h_code == 'unp120', 17, if(h_code == 'unp140', 20.4, if(h_code == 'unp160', 24, if(h_code == 'unp180', 28, if(h_code == 'unp200', 32.2, if(h_code == 'unp220', 37.4, if(h_code == 'unp240', 42.3, if(h_code == 'unp260', 48.3, if(h_code == 'unp280', 53.3, if(h_code == 'unp300', 58.8, if(h_code == 'unp320', 75.8, if(h_code == 'unp350', 77.3, if(h_code == 'unp380', 80.4, if(h_code == 'unp400', 91.5, 0))))))))))))))))
  
• h_a = h_a_ipe + h_a_hea + h_a_heb + h_a_unp
  
• h_iy_ipe = if(h_code == 'ipe80', 80.14, if(h_code == 'ipe100', 171, if(h_code == 'ipe120', 317.8, if(h_code == 'ipe140', 541.2, if(h_code == 'ipe160', 869.3, if(h_code == 'ipe180', 1317, if(h_code == 'ipe200', 1943, if(h_code == 'ipe220', 2772, if(h_code == 'ipe240', 3892, if(h_code == 'ipe270', 5790, if(h_code == 'ipe300', 8356, if(h_code == 'ipe330', 11770, if(h_code == 'ipe360', 16270, if(h_code == 'ipe400', 23130, if(h_code == 'ipe450', 33740, if(h_code == 'ipe500', 48200, if(h_code == 'ipe550', 67120, if(h_code == 'ipe600', 92080, 0))))))))))))))))))
  
• h_iy_hea = if(h_code == 'hea100', 349.2, if(h_code == 'hea120', 606.2, if(h_code == 'hea140', 1033, if(h_code == 'hea160', 1673, if(h_code == 'hea180', 2510, if(h_code == 'hea200', 3692, if(h_code == 'hea220', 5410, if(h_code == 'hea240', 7763, if(h_code == 'hea260', 10450, if(h_code == 'hea280', 13670, if(h_code == 'hea300', 18260, if(h_code == 'hea320', 22930, if(h_code == 'hea340', 27690, if(h_code == 'hea360', 33090, if(h_code == 'hea400', 45070, if(h_code == 'hea450', 63720, if(h_code == 'hea500', 86970, if(h_code == 'hea550', 111900, if(h_code == 'hea600', 141200, 0)))))))))))))))))))
  
• h_iy_heb = if(h_code == 'heb100', 449.5, if(h_code == 'heb120', 864.4, if(h_code == 'heb140', 1509, if(h_code == 'heb160', 2492, if(h_code == 'heb180', 3831, if(h_code == 'heb200', 5696, if(h_code == 'heb220', 8091, if(h_code == 'heb240', 11260, if(h_code == 'heb260', 14920, if(h_code == 'heb280', 19270, if(h_code == 'heb300', 25170, if(h_code == 'heb320', 30820, if(h_code == 'heb340', 36660, if(h_code == 'heb360', 43190, if(h_code == 'heb400', 57680, if(h_code == 'heb450', 79890, if(h_code == 'heb500', 107200, if(h_code == 'heb550', 136700, if(h_code == 'heb600', 171000, 0)))))))))))))))))))
  
• h_iy_unp = if(h_code == 'unp80', 106, if(h_code == 'unp100', 206, if(h_code == 'unp120', 364, if(h_code == 'unp140', 605, if(h_code == 'unp160', 925, if(h_code == 'unp180', 1350, if(h_code == 'unp200', 1910, if(h_code == 'unp220', 2690, if(h_code == 'unp240', 3600, if(h_code == 'unp260', 4820, if(h_code == 'unp280', 6280, if(h_code == 'unp300', 8030, if(h_code == 'unp320', 10870, if(h_code == 'unp350', 12840, if(h_code == 'unp380', 15760, if(h_code == 'unp400', 20350, 0))))))))))))))))
  
• h_iy = h_iy_ipe + h_iy_hea + h_iy_heb + h_iy_unp
  
• h_wely_ipe = if(h_code == 'ipe80', 20.03, if(h_code == 'ipe100', 34.2, if(h_code == 'ipe120', 52.96, if(h_code == 'ipe140', 77.32, if(h_code == 'ipe160', 108.7, if(h_code == 'ipe180', 146.3, if(h_code == 'ipe200', 194.3, if(h_code == 'ipe220', 252, if(h_code == 'ipe240', 324.3, if(h_code == 'ipe270', 428.9, if(h_code == 'ipe300', 557.1, if(h_code == 'ipe330', 713.1, if(h_code == 'ipe360', 903.6, if(h_code == 'ipe400', 1156, if(h_code == 'ipe450', 1500, if(h_code == 'ipe500', 1928, if(h_code == 'ipe550', 2441, if(h_code == 'ipe600', 3069, 0))))))))))))))))))
  
• h_wely_hea = if(h_code == 'hea100', 72.76, if(h_code == 'hea120', 106.3, if(h_code == 'hea140', 155.4, if(h_code == 'hea160', 220.1, if(h_code == 'hea180', 293.6, if(h_code == 'hea200', 388.6, if(h_code == 'hea220', 515.2, if(h_code == 'hea240', 675.1, if(h_code == 'hea260', 836.4, if(h_code == 'hea280', 1013, if(h_code == 'hea300', 1260, if(h_code == 'hea320', 1479, if(h_code == 'hea340', 1678, if(h_code == 'hea360', 1891, if(h_code == 'hea400', 2311, if(h_code == 'hea450', 2896, if(h_code == 'hea500', 3550, if(h_code == 'hea550', 4146, if(h_code == 'hea600', 4787, 0)))))))))))))))))))
  
• h_wely_heb = if(h_code == 'heb100', 89.91, if(h_code == 'heb120', 144.1, if(h_code == 'heb140', 215.6, if(h_code == 'heb160', 311.5, if(h_code == 'heb180', 425.7, if(h_code == 'heb200', 569.6, if(h_code == 'heb220', 735.5, if(h_code == 'heb240', 938.3, if(h_code == 'heb260', 1148, if(h_code == 'heb280', 1376, if(h_code == 'heb300', 1678, if(h_code == 'heb320', 1926, if(h_code == 'heb340', 2156, if(h_code == 'heb360', 2400, if(h_code == 'heb400', 2884, if(h_code == 'heb450', 3551, if(h_code == 'heb500', 4287, if(h_code == 'heb550', 4971, if(h_code == 'heb600', 5701, 0)))))))))))))))))))
  
• h_wely_unp = if(h_code == 'unp80', 26.5, if(h_code == 'unp100', 41.2, if(h_code == 'unp120', 60.7, if(h_code == 'unp140', 86.4, if(h_code == 'unp160', 116, if(h_code == 'unp180', 150, if(h_code == 'unp200', 191, if(h_code == 'unp220', 245, if(h_code == 'unp240', 300, if(h_code == 'unp260', 371, if(h_code == 'unp280', 448, if(h_code == 'unp300', 535, if(h_code == 'unp320', 679, if(h_code == 'unp350', 734, if(h_code == 'unp380', 829, if(h_code == 'unp400', 1020, 0))))))))))))))))
  
• h_wely = h_wely_ipe + h_wely_hea + h_wely_heb + h_wely_unp
  
• h_wply_ipe = if(h_code == 'ipe80', 23.22, if(h_code == 'ipe100', 39.41, if(h_code == 'ipe120', 60.73, if(h_code == 'ipe140', 88.34, if(h_code == 'ipe160', 123.9, if(h_code == 'ipe180', 166.4, if(h_code == 'ipe200', 220.6, if(h_code == 'ipe220', 285.4, if(h_code == 'ipe240', 366.6, if(h_code == 'ipe270', 484, if(h_code == 'ipe300', 628.4, if(h_code == 'ipe330', 804.3, if(h_code == 'ipe360', 1019, if(h_code == 'ipe400', 1307, if(h_code == 'ipe450', 1702, if(h_code == 'ipe500', 2194, if(h_code == 'ipe550', 2787, if(h_code == 'ipe600', 3512, 0))))))))))))))))))
  
• h_wply_hea = if(h_code == 'hea100', 83.01, if(h_code == 'hea120', 119.5, if(h_code == 'hea140', 173.5, if(h_code == 'hea160', 245.1, if(h_code == 'hea180', 324.9, if(h_code == 'hea200', 429.5, if(h_code == 'hea220', 568.5, if(h_code == 'hea240', 744.6, if(h_code == 'hea260', 919.8, if(h_code == 'hea280', 1112, if(h_code == 'hea300', 1383, if(h_code == 'hea320', 1628, if(h_code == 'hea340', 1850, if(h_code == 'hea360', 2088, if(h_code == 'hea400', 2562, if(h_code == 'hea450', 3216, if(h_code == 'hea500', 3949, if(h_code == 'hea550', 4622, if(h_code == 'hea600', 5350, 0)))))))))))))))))))
  
• h_wply_heb = if(h_code == 'heb100', 104.2, if(h_code == 'heb120', 165.2, if(h_code == 'heb140', 245.4, if(h_code == 'heb160', 354, if(h_code == 'heb180', 481.4, if(h_code == 'heb200', 642.5, if(h_code == 'heb220', 827, if(h_code == 'heb240', 1053, if(h_code == 'heb260', 1283, if(h_code == 'heb280', 1534, if(h_code == 'heb300', 1869, if(h_code == 'heb320', 2149, if(h_code == 'heb340', 2408, if(h_code == 'heb360', 2683, if(h_code == 'heb400', 3232, if(h_code == 'heb450', 3982, if(h_code == 'heb500', 4815, if(h_code == 'heb550', 5591, if(h_code == 'heb600', 6425, 0)))))))))))))))))))
  
• h_wply_unp = if(h_code == 'unp80', 32.3, if(h_code == 'unp100', 49, if(h_code == 'unp120', 72.6, if(h_code == 'unp140', 103, if(h_code == 'unp160', 138, if(h_code == 'unp180', 179, if(h_code == 'unp200', 228, if(h_code == 'unp220', 292, if(h_code == 'unp240', 358, if(h_code == 'unp260', 442, if(h_code == 'unp280', 532, if(h_code == 'unp300', 632, if(h_code == 'unp320', 826, if(h_code == 'unp350', 918, if(h_code == 'unp380', 1010, if(h_code == 'unp400', 1240, 0))))))))))))))))
  
• h_wply = h_wply_ipe + h_wply_hea + h_wply_heb + h_wply_unp
  
• h_iz_ipe = if(h_code == 'ipe80', 8.49, if(h_code == 'ipe100', 15.92, if(h_code == 'ipe120', 27.67, if(h_code == 'ipe140', 44.92, if(h_code == 'ipe160', 68.31, if(h_code == 'ipe180', 100.9, if(h_code == 'ipe200', 142.4, if(h_code == 'ipe220', 204.9, if(h_code == 'ipe240', 283.6, if(h_code == 'ipe270', 419.9, if(h_code == 'ipe300', 603.8, if(h_code == 'ipe330', 788.1, if(h_code == 'ipe360', 1043, if(h_code == 'ipe400', 1318, if(h_code == 'ipe450', 1676, if(h_code == 'ipe500', 2142, if(h_code == 'ipe550', 2668, if(h_code == 'ipe600', 3387, 0))))))))))))))))))
  
• h_iz_hea = if(h_code == 'hea100', 133.8, if(h_code == 'hea120', 230.9, if(h_code == 'hea140', 389.3, if(h_code == 'hea160', 615.6, if(h_code == 'hea180', 924.6, if(h_code == 'hea200', 1336, if(h_code == 'hea220', 1955, if(h_code == 'hea240', 2769, if(h_code == 'hea260', 3668, if(h_code == 'hea280', 4763, if(h_code == 'hea300', 6310, if(h_code == 'hea320', 6985, if(h_code == 'hea340', 7436, if(h_code == 'hea360', 7887, if(h_code == 'hea400', 8564, if(h_code == 'hea450', 9465, if(h_code == 'hea500', 10370, if(h_code == 'hea550', 10820, if(h_code == 'hea600', 11270, 0)))))))))))))))))))
  
• h_iz_heb = if(h_code == 'heb100', 167.3, if(h_code == 'heb120', 317.5, if(h_code == 'heb140', 549.7, if(h_code == 'heb160', 889.2, if(h_code == 'heb180', 1363, if(h_code == 'heb200', 2003, if(h_code == 'heb220', 2843, if(h_code == 'heb240', 3923, if(h_code == 'heb260', 5135, if(h_code == 'heb280', 6595, if(h_code == 'heb300', 8563, if(h_code == 'heb320', 9239, if(h_code == 'heb340', 9690, if(h_code == 'heb360', 10140, if(h_code == 'heb400', 10820, if(h_code == 'heb450', 11720, if(h_code == 'heb500', 12620, if(h_code == 'heb550', 13080, if(h_code == 'heb600', 13530, 0)))))))))))))))))))
  
• h_iz_unp = if(h_code == 'unp80', 19.4, if(h_code == 'unp100', 29.3, if(h_code == 'unp120', 43.2, if(h_code == 'unp140', 62.7, if(h_code == 'unp160', 85.3, if(h_code == 'unp180', 114, if(h_code == 'unp200', 148, if(h_code == 'unp220', 197, if(h_code == 'unp240', 248, if(h_code == 'unp260', 317, if(h_code == 'unp280', 399, if(h_code == 'unp300', 495, if(h_code == 'unp320', 597, if(h_code == 'unp350', 570, if(h_code == 'unp380', 615, if(h_code == 'unp400', 846, 0))))))))))))))))
  
• h_iz = h_iz_ipe + h_iz_hea + h_iz_heb + h_iz_unp
  
• h_naam_ipe = if(h_code == 'ipe80', 'IPE 80', if(h_code == 'ipe100', 'IPE 100', if(h_code == 'ipe120', 'IPE 120', if(h_code == 'ipe140', 'IPE 140', if(h_code == 'ipe160', 'IPE 160', if(h_code == 'ipe180', 'IPE 180', if(h_code == 'ipe200', 'IPE 200', if(h_code == 'ipe220', 'IPE 220', if(h_code == 'ipe240', 'IPE 240', if(h_code == 'ipe270', 'IPE 270', if(h_code == 'ipe300', 'IPE 300', if(h_code == 'ipe330', 'IPE 330', if(h_code == 'ipe360', 'IPE 360', if(h_code == 'ipe400', 'IPE 400', if(h_code == 'ipe450', 'IPE 450', if(h_code == 'ipe500', 'IPE 500', if(h_code == 'ipe550', 'IPE 550', if(h_code == 'ipe600', 'IPE 600', ''))))))))))))))))))
  
• h_naam_hea = if(h_code == 'hea100', 'HEA 100', if(h_code == 'hea120', 'HEA 120', if(h_code == 'hea140', 'HEA 140', if(h_code == 'hea160', 'HEA 160', if(h_code == 'hea180', 'HEA 180', if(h_code == 'hea200', 'HEA 200', if(h_code == 'hea220', 'HEA 220', if(h_code == 'hea240', 'HEA 240', if(h_code == 'hea260', 'HEA 260', if(h_code == 'hea280', 'HEA 280', if(h_code == 'hea300', 'HEA 300', if(h_code == 'hea320', 'HEA 320', if(h_code == 'hea340', 'HEA 340', if(h_code == 'hea360', 'HEA 360', if(h_code == 'hea400', 'HEA 400', if(h_code == 'hea450', 'HEA 450', if(h_code == 'hea500', 'HEA 500', if(h_code == 'hea550', 'HEA 550', if(h_code == 'hea600', 'HEA 600', '')))))))))))))))))))
  
• h_naam_heb = if(h_code == 'heb100', 'HEB 100', if(h_code == 'heb120', 'HEB 120', if(h_code == 'heb140', 'HEB 140', if(h_code == 'heb160', 'HEB 160', if(h_code == 'heb180', 'HEB 180', if(h_code == 'heb200', 'HEB 200', if(h_code == 'heb220', 'HEB 220', if(h_code == 'heb240', 'HEB 240', if(h_code == 'heb260', 'HEB 260', if(h_code == 'heb280', 'HEB 280', if(h_code == 'heb300', 'HEB 300', if(h_code == 'heb320', 'HEB 320', if(h_code == 'heb340', 'HEB 340', if(h_code == 'heb360', 'HEB 360', if(h_code == 'heb400', 'HEB 400', if(h_code == 'heb450', 'HEB 450', if(h_code == 'heb500', 'HEB 500', if(h_code == 'heb550', 'HEB 550', if(h_code == 'heb600', 'HEB 600', '')))))))))))))))))))
  
• h_naam_unp = if(h_code == 'unp80', 'UNP 80', if(h_code == 'unp100', 'UNP 100', if(h_code == 'unp120', 'UNP 120', if(h_code == 'unp140', 'UNP 140', if(h_code == 'unp160', 'UNP 160', if(h_code == 'unp180', 'UNP 180', if(h_code == 'unp200', 'UNP 200', if(h_code == 'unp220', 'UNP 220', if(h_code == 'unp240', 'UNP 240', if(h_code == 'unp260', 'UNP 260', if(h_code == 'unp280', 'UNP 280', if(h_code == 'unp300', 'UNP 300', if(h_code == 'unp320', 'UNP 320', if(h_code == 'unp350', 'UNP 350', if(h_code == 'unp380', 'UNP 380', if(h_code == 'unp400', 'UNP 400', ''))))))))))))))))
  
• h_naam = concat(h_naam_ipe, h_naam_hea, h_naam_heb, h_naam_unp)
  
• h_is_unp = if(h_g_unp > 0, 1, 0)
  
• h_cf = if(h_is_unp == 1, h_b - h_tw - h_r, (h_b - h_tw - 2 * h_r) / 2)
  
• h_cw = h_h - 2 * h_tf - 2 * h_r
  
• h_kl_f = if(h_tf > 0, if(h_cf / h_tf <= 9 * h_eps, 1, if(h_cf / h_tf <= 10 * h_eps, 2, if(h_cf / h_tf <= 14 * h_eps, 3, 4))), 0)
  
• h_kl_w = if(h_tw > 0, if(h_cw / h_tw <= 72 * h_eps, 1, if(h_cw / h_tw <= 83 * h_eps, 2, if(h_cw / h_tw <= 124 * h_eps, 3, 4))), 0)
  
• h_klasse = if(h_kl_f > h_kl_w, h_kl_f, h_kl_w)
  
• h_w_rd = if(h_klasse <= 2, h_wply, h_wely)
  
• h_mrd = h_w_rd * h_fy / 1000 / 1
  
• h_uc = if(h_mrd > 0, h_v_med / h_mrd, 0)
  
• h_r_h_g = round(abs(h_g) * 10, 0)
  
• h_t_h_g = concat(if(h_g < 0, '-', ''), if(floor(h_r_h_g / 10) >= 1000000, concat(format(floor(floor(h_r_h_g / 10) / 1000000), '0'), '.', format(floor(floor(h_r_h_g / 10) / 1000) - 1000 * floor(floor(h_r_h_g / 10) / 1000000), '000'), '.', format(floor(h_r_h_g / 10) - 1000 * floor(floor(h_r_h_g / 10) / 1000), '000')), if(floor(h_r_h_g / 10) >= 1000, concat(format(floor(floor(h_r_h_g / 10) / 1000), '0'), '.', format(floor(h_r_h_g / 10) - 1000 * floor(floor(h_r_h_g / 10) / 1000), '000')), format(floor(h_r_h_g / 10), '0'))), ',', format(h_r_h_g - 10 * floor(h_r_h_g / 10), '0'))
  
• h_r_h_v_med = round(abs(h_v_med) * 10, 0)
  
• h_t_h_v_med = concat(if(h_v_med < 0, '-', ''), if(floor(h_r_h_v_med / 10) >= 1000000, concat(format(floor(floor(h_r_h_v_med / 10) / 1000000), '0'), '.', format(floor(floor(h_r_h_v_med / 10) / 1000) - 1000 * floor(floor(h_r_h_v_med / 10) / 1000000), '000'), '.', format(floor(h_r_h_v_med / 10) - 1000 * floor(floor(h_r_h_v_med / 10) / 1000), '000')), if(floor(h_r_h_v_med / 10) >= 1000, concat(format(floor(floor(h_r_h_v_med / 10) / 1000), '0'), '.', format(floor(h_r_h_v_med / 10) - 1000 * floor(floor(h_r_h_v_med / 10) / 1000), '000')), format(floor(h_r_h_v_med / 10), '0'))), ',', format(h_r_h_v_med - 10 * floor(h_r_h_v_med / 10), '0'))
  
• h_r_h_mrd = round(abs(h_mrd) * 10, 0)
  
• h_t_h_mrd = concat(if(h_mrd < 0, '-', ''), if(floor(h_r_h_mrd / 10) >= 1000000, concat(format(floor(floor(h_r_h_mrd / 10) / 1000000), '0'), '.', format(floor(floor(h_r_h_mrd / 10) / 1000) - 1000 * floor(floor(h_r_h_mrd / 10) / 1000000), '000'), '.', format(floor(h_r_h_mrd / 10) - 1000 * floor(floor(h_r_h_mrd / 10) / 1000), '000')), if(floor(h_r_h_mrd / 10) >= 1000, concat(format(floor(floor(h_r_h_mrd / 10) / 1000), '0'), '.', format(floor(h_r_h_mrd / 10) - 1000 * floor(floor(h_r_h_mrd / 10) / 1000), '000')), format(floor(h_r_h_mrd / 10), '0'))), ',', format(h_r_h_mrd - 10 * floor(h_r_h_mrd / 10), '0'))
  
• h_uc100 = round(h_uc * 100, 0)
  
• h_t_uc = concat(format(floor(h_uc100 / 100), '0'), ',', format(h_uc100 - 100 * floor(h_uc100 / 100), '00'))
  
• h_t_staal = if(staalsoort == 's355', 'S355', if(staalsoort == 's275', 'S275', 'S235'))
  
• h_t_w = if(h_klasse <= 2, 'Wpl,y', 'Wel,y')
  
• profiel_txt = if(situatie == 'zoeken', if(h_uc <= 1, concat('Lichtste ', h_naam, ' is genoeg voor ', h_t_h_v_med, ' kNm in ', h_t_staal, ' (', h_t_h_g, ' kg/m).'), concat('Zelfs ', h_naam, ' is te licht voor ', h_t_h_v_med, ' kNm. Kies een andere reeks of een zwaardere staalsoort.')), concat(h_naam, ' in ', h_t_staal, ': doorsnedeklasse ', format(h_klasse, '0'), ', ', h_t_h_g, ' kg/m.'))
  Het profiel waar alle getallen hieronder bij horen. Bij zoeken loopt de tool de reeks van licht naar zwaar door en neemt het eerste profiel met Mc,Rd groter dan of gelijk aan MEd.
• hoogte = h_h
  Totale hoogte van het profiel. Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• breedte = h_b
  Breedte van de flens. Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• lijfdikte = h_tw
  Dikte van het lijf. Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• flensdikte = h_tf
  Dikte van de flens (bij UNP de gemiddelde dikte, de flens loopt taps). Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• gewicht = h_g
  Massa per strekkende meter volgens de ArcelorMittal-tabel.
• totaalgewicht = if(lengte > 0, round(h_g * lengte, 1), 0)
  Gewicht per meter maal de lengte. Handig voor transport, hijsen en de staalprijs per kg.
• oppervlakte = h_a
  Doorsnede-oppervlakte. Nodig voor normaalkracht en knik. Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• iy = h_iy
  Traagheidsmoment om de sterke as (y-as). Nodig voor doorbuiging en knik. Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• wely = h_wely
  Elastisch weerstandsmoment om de y-as: Iy gedeeld door de halve hoogte. Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• wply = h_wply
  Plastisch weerstandsmoment om de y-as. Mag je gebruiken bij doorsnedeklasse 1 en 2. Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• i_y = if(h_a > 0, round(sqrt(h_iy / h_a), 2), 0)
  iy = wortel(Iy / A). Nodig voor de slankheid bij knik om de y-as.
• iz = h_iz
  Traagheidsmoment om de zwakke as (z-as). Bron: ArcelorMittal-profieltabel (afmetingen EN 10365).
• i_z = if(h_a > 0, round(sqrt(h_iz / h_a), 2), 0)
  iz = wortel(Iz / A). Meestal maatgevend voor knik van een kolom.
• klasse = h_klasse
  Volgens NEN-EN 1993-1-1 tabel 5.2 met c/t van flens (grens 9, 10, 14 maal epsilon) en lijf (72, 83, 124 maal epsilon), epsilon = wortel(235/fy). Klasse 1 en 2 mogen plastisch rekenen.
• mcrd = round(h_mrd, 1)
  Mc,Rd = W x fy / gamma M0 met gamma M0 = 1,00 (NEN-EN 1993-1-1, 6.2.5; NB:2016, zoals in Nederlandse constructieberekeningen met Technosoft). W = Wpl,y bij klasse 1 en 2, Wel,y bij klasse 3. Kip en dwarskracht niet getoetst.
• melrd = round(h_wely * h_fy / 1000 / 1, 1)
  Mel,Rd = Wel,y x fy / gamma M0: de veilige elastische waarde. Zo rekent ook Stalen balk profielkeuze indicatie; met dezelfde ArcelorMittal-waarden geven beide tools hetzelfde Wel,y.
• uc = round(h_uc, 2)
  Verhouding tussen rekenmoment en momentcapaciteit. 1,00 of lager voldoet voor de doorsnede.
• oordeel = if(h_v_med <= 0, 'Vul een rekenmoment groter dan 0 in.', if(h_uc <= 1, concat('Voldoet: UC = ', h_t_uc, ' (', h_t_h_v_med, ' kNm tegen Mc,Rd ', h_t_h_mrd, ' kNm met ', h_t_w, '). Kip en doorbuiging apart toetsen.'), concat('Voldoet niet: UC = ', h_t_uc, ' (', h_t_h_v_med, ' kNm tegen Mc,Rd ', h_t_h_mrd, ' kNm). Kies een zwaarder profiel of een hogere staalsoort.')))
  Toets van de doorsnede op buiging volgens NEN-EN 1993-1-1, 6.2.5: MEd gedeeld door Mc,Rd moet 1,0 of lager zijn. Kip (zijdelings uitknikken) en dwarskracht toets je apart; laat een constructeur de definitieve keuze maken.

Berekening informatie

Op jouw website?

<script src="https://ikbenbint.nl/widget.js"
  data-berekening="staalprofielen-tabel-ipe-hea-heb-unp">
</script>