Spreadsheet: 689609d1596550240-excel-alternative-formula-for-a-python-loop-sample
Sheet: Sheet1

Heat | Total cost | Total GWP | Rank | Expected
60.85525959367946 | 152.74930384 | 40.3447136874763 |  | 1
59.93372460496614 | 155.7130961650564 | 51.79482655429346 |  | 0
58.4565237020316 | 158.1414483095259 | 61.17541346174266 |  | 1
57.53372460496614 | 161.1052406345824 | 72.62552632855983 |  | 0
63.03620767494357 | 156.1748715972912 | 40.3447136874763 |  | 0
58.06121896162528 | 159.9811675879007 | 41.09482721451919 |  | 0
57.13932279909707 | 162.9449599129571 | 52.54494008133634 |  | 0
55.66212189616253 | 165.3733120574266 | 61.92552698878556 |  | 0
54.73914221218961 | 168.3371043824831 | 73.37563985560271 |  | 0
51.39142212189616 | 178.4584587842889 | 112.4770394041354 |  | 1
61.45932279909707 | 153.7096323992776 | 40.3447136874763 |  | 0
63.64045146726863 | 157.1352001565688 | 40.3447136874763 |  | 0
60.05905191873589 | 154.7766948554402 | 40.5550015853544 |  | 1
59.13643340857788 | 157.7404871804966 | 52.00511445217155 |  | 0
57.66013544018059 | 160.1688393249661 | 61.38570135962077 |  | 0
56.73625282167043 | 163.1326316500226 | 72.83581422643792 |  | 0
57.26483069977427 | 162.0085586033408 | 41.30511511239729 |  | 1
56.34257336343115 | 164.9723509283973 | 52.75522797921445 |  | 0
54.86573363431151 | 167.4007030728668 | 62.13581488666365 |  | 0
51.5203611738149 | 177.5220574746727 | 101.2372144351964 |  | 0
53.94148984198645 | 170.3644953979232 | 73.58592775348082 |  | 0
50.59250564334086 | 180.4858497997291 | 112.6873273020135 |  | 0
60.65390519187359 | 154.1362914741309 | 40.5550015853544 |  | 0
58.25498871331828 | 159.5284359436569 | 61.38570135962077 |  | 0
57.85968397291197 | 161.3681552220316 | 41.30511511239729 |  | 0
55.46040632054176 | 166.7602996915575 | 62.13581488666365 |  | 0
52.11539503386005 | 176.8816540933634 | 101.2372144351964 |  | 0
61.78943566591422 | 154.7075408568849 | 40.3447136874763 |  | 0
63.97038374717833 | 158.1331086141761 | 40.3447136874763 |  | 0
62.39349887133183 | 155.6678694161625 | 40.3447136874763 |  | 0
64.57462753950338 | 159.0934371734537 | 40.3447136874763 |  | 0
59.21498871331828 | 156.8834224140858 | 40.77351853957562 |  | 1
58.29309255079007 | 159.8472147391422 | 52.22363140639278 |  | 0
56.82257336343115 | 162.2755668836117 | 61.60421831384198 |  | 0
55.89977426636569 | 165.2393592086682 | 73.05433118065915 |  | 0
56.42058690744921 | 164.1152861619865 | 41.52363206661851 |  | 1
55.49905191873589 | 167.0790784870429 | 52.97374493343566 |  | 1
52.15223476297968 | 177.2004328888488 | 92.0751444819684 |  | 0
54.02799097065463 | 169.5074306315124 | 62.35433184088487 |  | 1
50.68279909706546 | 179.6287850333183 | 101.4557313894176 |  | 0
53.10537246049661 | 172.4712229565689 | 73.80444470770203 |  | 0
49.75801354401806 | 182.5925773583747 | 112.9058442562348 |  | 0
59.81887133182844 | 157.8437509733634 | 40.77351853957562 |  | 0
57.02483069977426 | 165.0756147212641 | 41.52363206661851 |  | 0
54.63241534988713 | 170.4677591907901 | 62.35433184088487 |  | 0
51.28686230248307 | 180.5891135925959 | 101.4557313894176 |  | 0
58.41860045146727 | 158.9108134295259 | 40.98380643745372 |  | 1
57.49598194130925 | 161.8746057545824 | 52.43391930427088 |  | 0
56.02654627539503 | 164.3029578990519 | 61.81450621172009 |  | 0
52.6755756207675 | 174.4243123008578 | 100.9159057602528 |  | 0
55.10194130925508 | 167.2667502241084 | 73.26461907853724 |  | 0
51.74772009029346 | 177.3881046259142 | 112.36601862707 |  | 0
55.62437923250565 | 166.1426771774266 | 41.73391996449661 |  | 0
52.28081264108352 | 176.2640315792325 | 80.83531951302935 |  | 0
54.70212189616253 | 169.1064695024831 | 53.18403283131376 |  | 0
51.35404063205418 | 179.227823904289 | 92.2854323798465 |  | 1
53.23214446952596 | 171.5348216469526 | 62.56461973876298 |  | 1
49.8865914221219 | 181.6561760487585 | 101.6660192872957 |  | 0
52.307539503386 | 174.498613972009 | 74.01473260558014 |  | 1
48.95873589164785 | 184.6199683738149 | 113.1161321541129 |  | 1
59.01327313769752 | 158.2704100482167 | 40.98380643745372 |  | 0
56.62121896162528 | 163.6625545177427 | 61.81450621172009 |  | 0
56.21905191873589 | 165.5022737961174 | 41.73391996449661 |  | 0
55.27024830699774 | 168.4660661211738 | 53.18403283131376 |  | 0
51.92198645598194 | 178.5874205229797 | 92.2854323798465 |  | 0
53.82663656884876 | 170.8944182656433 | 62.56461973876298 |  | 0
50.4814446952596 | 181.0157726674492 | 101.6660192872957 |  | 1
52.87584650112867 | 173.8582105906998 | 74.01473260558014 |  | 0
49.52722347629797 | 183.9795649925056 | 113.1161321541129 |  | 0