Spreadsheet: 857298d1706300636-pull-data-from-table-with-multiple-criteria-help-radiators
Sheet: Radiator Info

 |  | Nominal | [NAME] | Single Convector (T11) |  |  |  | Double Panel Plus (T21) |  |  |  | Double Convector (T22)
 |  | Height | [NAME] | Watts |  |  |  | Watts |  |  |  | Watts
 |  | Temperature: |  | 30.5 | 31.5 | 34.5 | 36.5 | 30.5 | 31.5 | 34.5 | 36.5 | 30.5 | 31.5 | 34.5 | 36.5
 |  | 300 | 400 | 116.0223842761766 | 121.171031961374 | 136.9535683370823 | 147.7449340574683 | 177.8592150270315 | 185.5028328058116 | 208.8726306439315 | 224.8032957178396 | 233.8813295079048 | 243.9498482852127 | 274.7378286507239 | 295.7286775851338
 |  | 300 | 500 | 145.0279803452207 | 151.4637899517174 | 171.1919604213529 | 184.6811675718354 | 222.3240187837893 | 231.8785410072644 | 261.0907883049144 | 281.0041196472994 | 292.351661884881 | 304.937310356516 | 343.4222858134049 | 369.6608469814173
 |  | 300 | 600 | 174.0335764142648 | 181.7565479420609 | 205.4303525056234 | 221.6174010862025 | 266.7888225405472 | 278.2542492087173 | 313.3089459658973 | 337.2049435767593 | 350.8219942618573 | 365.9247724278192 | 412.1067429760859 | 443.5930163777007
 |  | 300 | 700 | 203.039172483309 | 212.0493059324045 | 239.668744589894 | 258.5536346005696 | 311.2536262973051 | 324.6299574101702 | 365.5271036268801 | 393.4057675062192 | 409.2923266388334 | 426.9122344991223 | 480.7912001387668 | 517.525185773984
 |  | 300 | 800 | 232.0529657480263 | 242.3506248798866 | 273.9168126966391 | 295.5003065673246 | 355.7724496322345 | 371.0620067170096 | 417.8087002915563 | 449.6748689168567 | 467.7018147586992 | 487.8362329868963 | 549.4041842209775 | 591.3804213178228
 |  | 300 | 900 | 261.0503646213973 | 272.6348219130915 | 308.1455287584351 | 332.4261016293038 | 400.1832338108208 | 417.381373813076 | 469.9634189488459 | 505.807415365139 | 526.2329913927858 | 548.8871586417287 | 618.1601144641288 | 665.3895245665509
 |  | 300 | 1000 | 290.0559606904415 | 302.9275799034349 | 342.3839208427057 | 369.3623351436709 | 444.6480375675786 | 463.7570820145289 | 522.1815766098288 | 562.0082392945989 | 584.703323769762 | 609.874620713032 | 686.8445716268099 | 739.3216939628345
 |  | 300 | 1100 | 319.0615567594855 | 333.2203378937784 | 376.6223129269762 | 406.2985686580379 | 489.1128413243365 | 510.1327902159817 | 574.3997342708117 | 618.2090632240588 | 643.1736561467383 | 670.8620827843351 | 755.5290287894908 | 813.253863359118
 |  | 300 | 1200 | 348.0671528285297 | 363.5130958841219 | 410.8607050112468 | 443.234802172405 | 533.5776450810944 | 556.5084984174347 | 626.6178919317946 | 674.4098871535186 | 701.6439885237146 | 731.8495448556383 | 824.2134859521718 | 887.1860327554014
 |  | 300 | 1300 | 377 | 394 | 445 | 480 | 579 | 603 | 679 | 731 | 760 | 793 | 893 | 961
 |  | 300 | 1400 | 406.078344966618 | 424.0986118648089 | 479.337489179788 | 517.1072692011392 | 622.5072525946101 | 649.2599148203404 | 731.0542072537603 | 786.8115350124384 | 818.5846532776668 | 853.8244689982446 | 961.5824002775336 | 1035.050371547968
 |  | 300 | 1600 | 464.0895371047063 | 484.6841278454959 | 547.8142733483292 | 590.9797362298733 | 711.4368601081259 | 742.0113312232462 | 835.490522575726 | 899.2131828713583 | 935.5253180316193 | 975.799393140851 | 1098.951314602896 | 1182.914710340535
 |  | 300 | 1800 | 549.2422468516597 | 573.6156023942771 | 648.32907940211 | 699.4146866479857 | 800.2957438117234 | 834.6889844135759 | 939.8437819355673 | 1011.525440109989 | 1052.482730320989 | 1097.791785795085 | 1236.339902074145 | 1330.800225370265
 |  | 300 | 2000 |  |  |  |  |  |  |  |  | 1169.406647539524 | 1219.749241426064 | 1373.68914325362 | 1478.643387925669
 |  | 400 | 400 | 151.9101208269487 | 158.5745797150599 | 178.984526280638 | 192.9246079105885 | 222.9626644815771 | 232.6189154839008 | 262.1604365618696 | 282.3128064333274 | 292.6847446648076 | 305.4364406592258 | 344.4666574267194 | 371.1069318867072
 |  | 400 | 500 | 189.8876510336859 | 198.2182246438249 | 223.7306578507975 | 241.1557598882356 | 278.7033306019714 | 290.7736443548761 | 327.700545702337 | 352.8910080416592 | 365.8559308310096 | 381.7955508240323 | 430.5833217833993 | 463.8836648583841
 |  | 400 | 600 | 227.8651812404231 | 237.8618695725899 | 268.476789420957 | 289.3869118658827 | 334.4439967223656 | 348.9283732258513 | 393.2406548428044 | 423.4692096499911 | 439.0271169972115 | 458.1546609888387 | 516.6999861400791 | 556.6603978300608
 |  | 400 | 700 | 265.8427114471603 | 277.5055145013548 | 313.2229209911165 | 337.6180638435299 | 390.18466284276 | 407.0831020968265 | 458.7807639832718 | 494.0474112583229 | 512.1983031634134 | 534.513771153645 | 602.8166504967589 | 649.4371308017377
 |  | 400 | 800 | 303.8202416538974 | 317.1491594301198 | 357.969052561276 | 385.849215821177 | 445.9253289631542 | 465.2378309678016 | 524.3208731237391 | 564.6256128666547 | 585.3694893296152 | 610.8728813184515 | 688.9333148534388 | 742.2138637734143
 |  | 400 | 900 | 341.7977718606346 | 356.7928043588848 | 402.7151841314355 | 434.0803677988241 | 501.6659950835485 | 523.392559838777 | 589.8609822642065 | 635.2038144749865 | 658.540675495817 | 687.231991483258 | 775.0499792101185 | 834.9905967450911
 |  | 400 | 1000 | 379.7753020673718 | 396.4364492876498 | 447.461315701595 | 482.3115197764712 | 557.4066612039428 | 581.5472887097521 | 655.401091404674 | 705.7820160833185 | 731.7118616620193 | 763.5911016480645 | 861.1666435667986 | 927.7673297167682
 |  | 400 | 1100 | 417.752832274109 | 436.0800942164148 | 492.2074472717545 | 530.5426717541184 | 613.1473273243371 | 639.7020175807274 | 720.9412005451413 | 776.3602176916503 | 804.883047828221 | 839.9502118128709 | 947.2833079234783 | 1020.544062688445
 |  | 400 | 1200 | 455.7303624808462 | 475.7237391451797 | 536.953578841914 | 578.7738237317654 | 668.8879934447313 | 697.8567464517025 | 786.4813096856087 | 846.9384192999821 | 878.0542339944229 | 916.3093219776773 | 1033.399972280158 | 1113.320795660122
 |  | 400 | 1300 | 494 | 516 | 582 | 627 | 725 | 756 | 852 | 918 | 951 | 993 | 1120 | 1206
 |  | 400 | 1400 | 531.6854228943206 | 555.0110290027096 | 626.445841982233 | 675.2361276870597 | 780.3693256855199 | 814.166204193653 | 917.5615279665436 | 988.0948225166458 | 1024.396606326827 | 1069.02754230729 | 1205.633300993518 | 1298.874261603475
 |  | 400 | 1600 | 607.6404833077947 | 634.2983188602395 | 715.938105122552 | 771.698431642354 | 891.8506579263084 | 930.4756619356033 | 1048.641746247478 | 1129.251225733309 | 1170.73897865923 | 1221.745762636903 | 1377.866629706878 | 1484.427727546829
 |  | 400 | 1800 | 683.5955437212692 | 713.5856087177696 | 805.4303682628711 | 868.1607355976481 | 1003.331990167097 | 1046.785119677554 | 1179.721964528413 | 1270.407628949973 | 1317.081350991634 | 1374.463982966516 | 1550.099958420237 | 1669.981193490182
 |  | 400 | 2000 | 759.5506041347436 | 792.8728985752996 | 894.92263140319 | 964.6230395529424 |  |  |  |  | 1463.423723324039 | 1527.182203296129 | 1722.333287133597 | 1855.534659433536
 |  | 500 | 300 | 139.3582198382888 | 145.4021037739262 | 163.8943305078198 | 176.510851926539 | 198.0550903478587 | 206.6992958024836 | 233.1611600547339 | 251.2258780756391 | 260.4451984900334 | 271.9282230736487 | 307.1093281318666 | 331.1495941091021
 |  | 500 | 400 | 185.8109597843851 | 193.8694716985683 | 218.5257740104265 | 235.3478025687186 | 264.0734537971449 | 275.5990610699782 | 310.8815467396452 | 334.9678374341854 | 347.2602646533778 | 362.5709640981982 | 409.4791041758221 | 441.5327921454694
 |  | 500 | 500 | 232.2636997304814 | 242.3368396232104 | 273.1572175130331 | 294.1847532108983 | 330.0918172464312 | 344.4988263374727 | 388.6019334245565 | 418.7097967927317 | 434.0753308167222 | 453.2137051227479 | 511.8488802197777 | 551.9159901818368
 |  | 500 | 600 | 278.7164396765777 | 290.8042075478525 | 327.7886610156397 | 353.021703853078 | 396.1101806957174 | 413.3985916049672 | 466.3223201094678 | 502.4517561512781 | 520.8903969800667 | 543.8564461472973 | 614.2186562637332 | 662.2991882182042
 |  | 500 | 700 | 325.169179622674 | 339.2715754724946 | 382.4201045182463 | 411.8586544952576 | 462.1285441450037 | 482.2983568724618 | 544.0427067943791 | 586.1937155098244 | 607.7054631434112 | 634.499187171847 | 716.5884323076888 | 772.6823862545716
 |  | 500 | 800 | 371.6219195687703 | 387.7389433971367 | 437.0515480208529 | 470.6956051374373 | 528.1469075942898 | 551.1981221399564 | 621.7630934792904 | 669.9356748683708 | 694.5205293067555 | 725.1419281963964 | 818.9582083516442 | 883.0655842909389
 |  | 500 | 900 | 418.0746595148665 | 436.2063113217787 | 491.6829915234595 | 529.5325557796168 | 594.1652710435761 | 620.097887407451 | 699.4834801642018 | 753.6776342269171 | 781.3355954701 | 815.7846692209461 | 921.3279843955997 | 993.4487823273063
 |  | 500 | 1000 | 464.5273994609628 | 484.6736792464208 | 546.3144350260661 | 588.3695064217966 | 660.1836344928623 | 688.9976526749455 | 777.203866849113 | 837.4195935854634 | 868.1506616334444 | 906.4274102454957 | 1023.697760439555 | 1103.831980363674
 |  | 500 | 1100 | 510.980139407059 | 533.1410471710628 | 600.9458785286727 | 647.2064570639761 | 726.2019979421485 | 757.89741794244 | 854.9242535340243 | 921.1615529440097 | 954.965727796789 | 997.0701512700451 | 1126.067536483511 | 1214.215178400041
 |  | 500 | 1200 | 557.4328793531554 | 581.6084150957049 | 655.5773220312793 | 706.0434077061559 | 792.2203613914347 | 826.7971832099345 | 932.6446402189356 | 1004.903512302556 | 1041.780793960133 | 1087.712892294595 | 1228.437312527466 | 1324.598376436408
 |  | 500 | 1300 | 603.8856192992516 | 630.0757830203471 | 710.208765533886 | 764.8803583483356 | 858 | 896 | 1011 | 1089 | 1128.595860123478 | 1178.355633319144 | 1330.807088571422 | 1434.981574472776
 |  | 500 | 1400 | 650.338359245348 | 678.5431509449892 | 764.8402090364925 | 823.7173089905152 | 924.2570882900073 | 964.5967137449236 | 1088.085413588758 | 1172.387431019649 | 1215.410926286822 | 1268.998374343694 | 1433.176864615378 | 1545.364772509143
 |  | 500 | 1500 | 696.7910991914441 | 727.0105188696311 | 819.4716525390991 | 882.5542596326948 | 990 | 1034 | 1166 | 1256 | 1302.225992450167 | 1359.641115368243 | 1535.546640659333 | 1655.74797054551
 |  | 500 | 1600 | 743.2438391375406 | 775.4778867942733 | 874.1030960417058 | 941.3912102748745 | 1056.29381518858 | 1102.396244279913 | 1243.526186958581 | 1339.871349736742 | 1389.041058613511 | 1450.283856392793 | 1637.916416703288 | 1766.131168581878
 |  | 500 | 1800 | 836.149319029733 | 872.4126226435574 | 983.3659830469189 | 1059.065111559234 | 1188.330542087152 | 1240.195774814902 | 1398.966960328404 | 1507.355268453834 | 1562.6711909402 | 1631.569338441892 | 1842.655968791199 | 1986.897564654613
 |  | 500 | 2000 | 929.0547989219256 | 969.3473584928415 | 1092.628870052132 | 1176.739012843593 |  |  |  |  | 1736.301323266889 | 1812.854820490991 | 2047.395520879111 | 2207.663960727347
 |  | 500 | 2200 |  |  |  |  |  |  |  |  | 1909.931455593578 | 1994.14030254009 | 2252.135072967022 | 2428.430356800082
 |  | 600 | 300 | 163.4264666820258 | 170.431682257449 | 191.8452023914868 | 206.4387957299207 | 226.5739151156476 | 236.5383719482904 | 267.060678619619 | 287.91242268166 | 298.7552335333688 | 312.082356339605 | 352.9525883046582 | 380.911852361334
 |  | 600 | 400 | 217.9019555760344 | 227.242243009932 | 255.793603188649 | 275.2517276398942 | 302 | 316 | 356 | 384 | 398.3403113778251 | 416.1098084528068 | 470.6034510728776 | 507.8824698151121
 |  | 600 | 500 | 272.377444470043 | 284.052803762415 | 319.7420039858113 | 344.0646595498678 | 377.6231918594126 | 394.2306199138172 | 445.1011310326983 | 479.8540378027667 | 497.9253892222814 | 520.1372605660084 | 588.2543138410971 | 634.8530872688902
 |  | 600 | 600 | 326.8529333640516 | 340.8633645148979 | 383.6904047829735 | 412.8775914598413 | 453.1478302312951 | 473.0767438965808 | 534.121357239238 | 575.82484536332 | 597.5104670667375 | 624.1647126792101 | 705.9051766093164 | 761.823704722668
 |  | 600 | 700 | 381.3284222580602 | 397.6739252673809 | 447.6388055801358 | 481.6905233698149 | 528.6724686031777 | 551.9228678793442 | 623.1415834457777 | 671.7956529238735 | 697.095544911194 | 728.1921647924119 | 823.556039377536 | 888.7943221764463
 |  | 600 | 800 | 435.8039111520687 | 454.4844860198639 | 511.5872063772981 | 550.5034552797885 | 604.1971069750601 | 630.7689918621077 | 712.1618096523172 | 767.7664604844267 | 796.6806227556501 | 832.2196169056135 | 941.2069021457553 | 1015.764939630224
 |  | 600 | 900 | 490.2794000460774 | 511.2950467723469 | 575.5356071744603 | 619.3163871897619 | 679.7217453469427 | 709.6151158448711 | 801.1820358588569 | 863.73726804498 | 896.2657006001062 | 936.2470690188152 | 1058.857764913975 | 1142.735557084002
 |  | 600 | 1000 | 544.7548889400861 | 568.1056075248299 | 639.4840079716226 | 688.1293190997355 | 755.2463837188252 | 788.4612398276345 | 890.2022620653966 | 959.7080756055334 | 995.8507784445627 | 1040.274521132017 | 1176.508627682194 | 1269.70617453778
 |  | 600 | 1100 | 599.2303778340946 | 624.916168277313 | 703.432408768785 | 756.9422510097091 | 830.7710220907077 | 867.3073638103979 | 979.2224882719362 | 1055.678883166087 | 1095.435856289019 | 1144.301973245219 | 1294.159490450414 | 1396.676791991559
 |  | 600 | 1200 | 653.7058667281032 | 681.7267290297958 | 767.3808095659471 | 825.7551829196826 | 906.2956604625903 | 946.1534877931615 | 1068.242714478476 | 1151.64969072664 | 1195.020934133475 | 1248.32942535842 | 1411.810353218633 | 1523.647409445336
 |  | 600 | 1300 | 708.1813556221118 | 738.5372897822789 | 831.3292103631093 | 894.5681148296562 | 982 | 1025 | 1157 | 1248 | 1294.606011977931 | 1352.356877471622 | 1529.461215986852 | 1650.618026899114
 |  | 600 | 1400 | 762.6568445161204 | 795.3478505347618 | 895.2776111602716 | 963.3810467396297 | 1057.344937206355 | 1103.845735758688 | 1246.283166891555 | 1343.591305847747 | 1394.191089822388 | 1456.384329584824 | 1647.112078755072 | 1777.588644352893
 |  | 600 | 1500 | 817.1323334101289 | 852.1584112872448 | 959.2260119574338 | 1032.193978649603 | 1132 | 1183 | 1335 | 1440 | 1493.776167666844 | 1560.411781698025 | 1764.762941523291 | 1904.559261806671
 |  | 600 | 1600 | 871.6078223041375 | 908.9689720397279 | 1023.174412754596 | 1101.006910559577 | 1208.39421395012 | 1261.537983724215 | 1424.323619304634 | 1535.532920968853 | 1593.3612455113 | 1664.439233811227 | 1882.413804291511 | 2031.529879260449
 |  | 600 | 1800 | 980.5588000921548 | 1022.590093544694 | 1151.071214348921 | 1238.632774379524 | 1359.443490693885 | 1419.230231689742 | 1602.364071717714 | 1727.47453608996 | 1792.531401200212 | 1872.49413803763 | 2117.715529827949 | 2285.471114168004
 |  | 600 | 2000 | 1089.509777880172 | 1136.21121504966 | 1278.968015943245 | 1376.258638199471 |  |  |  |  | 1991.701556889125 | 2080.549042264034 | 2353.017255364388 | 2539.412349075561
 |  | 600 | 2200 |  |  |  |  |  |  |  |  | 2190.871712578038 | 2288.603946490437 | 2588.318980900827 | 2793.353583983117
 |  | 700 | 300 | 183.3133153744836 | 191.2770811193882 | 215.6468382153705 | 232.2760423994851 |  |  |  |  | 336.9830299530765 | 352.0154502079024 | 398.1153107512003 | 429.65215583219
 |  | 700 | 400 | 244.4199535924293 | 255.0384034841577 | 287.5317053825526 | 309.7041771784889 | 336.8195021003871 | 351.7617764038799 | 397.5643081349518 | 428.8810375010108 | 447.3495885203016 | 467.4440491100515 | 529.1030542515225 | 571.312258108155
 |  | 700 | 500 | 305.5249419905367 | 318.7980043551972 | 359.4146317281907 | 387.1302214731111 | 421.0243776254839 | 439.7022205048499 | 496.9553851686898 | 536.1012968762635 | 559.186985650377 | 584.3050613875643 | 661.3788178144031 | 714.1403226351937
 |  | 700 | 600 | 366.629930388644 | 382.5576052262365 | 431.2975580738289 | 464.5562657677332 | 505.2292531505806 | 527.6426646058198 | 596.3464622024278 | 643.3215562515162 | 671.0243827804526 | 701.1660736650773 | 793.6545813772838 | 856.9683871622326
 |  | 700 | 700 | 427.7349187867513 | 446.317206097276 | 503.180484419467 | 541.9823100623555 | 589.4341286756775 | 615.58310870679 | 695.7375392361657 | 750.5418156267689 | 782.8617799105277 | 818.02708594259 | 925.9303449401644 | 999.7964516892713
 |  | 700 | 800 | 488.8399071848586 | 510.0768069683155 | 575.0634107651052 | 619.4083543569777 | 673.6390042007741 | 703.5235528077599 | 795.1286162699037 | 857.7620750020216 | 894.6991770406032 | 934.888098220103 | 1058.206108503045 | 1142.62451621631
 |  | 700 | 900 | 549.9448955829661 | 573.8364078393549 | 646.9463371107433 | 696.8343986515998 | 757.8438797258709 | 791.4639969087298 | 894.5196933036416 | 964.9823343772742 | 1006.536574170679 | 1051.749110497616 | 1190.481872065926 | 1285.452580743349
 |  | 700 | 1000 | 611.0498839810733 | 637.5960087103944 | 718.8292634563815 | 774.2604429462222 | 842.0487552509678 | 879.4044410096999 | 993.9107703373796 | 1072.202593752527 | 1118.373971300754 | 1168.610122775129 | 1322.757635628806 | 1428.280645270387
 |  | 700 | 1100 | 672.1548723791806 | 701.3556095814337 | 790.7121898020196 | 851.6864872408443 | 926 | 967 | 1094 | 1180 | 1230.21136843083 | 1285.471135052642 | 1455.033399191687 | 1571.108709797426
 |  | 700 | 1200 | 733.2598607772879 | 765.1152104524731 | 862.5951161476578 | 929.1125315354665 | 1010.458506301161 | 1055.28532921164 | 1192.692924404856 | 1286.643112503032 | 1342.048765560905 | 1402.332147330155 | 1587.309162754568 | 1713.936774324465
 |  | 700 | 1400 | 855.4698375735027 | 892.634412194552 | 1006.360968838934 | 1083.964620124711 |  |  |  |  | 1565.723559821055 | 1636.05417188518 | 1851.860689880329 | 1999.592903378543
 |  | 700 | 1600 | 977.6798143697173 | 1020.153613936631 | 1150.12682153021 | 1238.816708713955 |  |  |  |  | 1789.398354081206 | 1869.776196440206 | 2116.41221700609 | 2285.24903243262
 |  | 700 | 1800 | 1099.889791165932 | 1147.67281567871 | 1293.892674221487 | 1393.6687973032 |  |  |  |  | 1973.583118515318 | 2062.234341660015 | 2334.256882362841 | 2520.472259140015
 |  | 700 | 2000 | 1222.099767962147 | 1275.192017420789 | 1437.658526912763 | 1548.520885892444 |  |  |  |  | 2192.870131683686 | 2291.37149073335 | 2593.618758180935 | 2800.524732377794