Spreadsheet: 689607d1596548882-excel-alternative-formula-for-a-python-loop-test
Sheet: Sheet1

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