Spreadsheet: 216985d1361954992-trying-to-return-scores-based-on-three-different-data-points-using-ranges-scrubdata
Sheet: Data

Returned Score | Site | People | Need Rank | Costs Covered 1st Year
 | Site 1 | 1558 | 1 | 0.7631578947368421
 | Site 2 | 1662 | 1 | 0.9473684210526315
 | Site 3 | 749 | 1 | 0.9473684210526315
 | Site 4 | 1731 | 1 | 0.7192982456140351
 | Site 5 | 1398 | 1 | 0.9473684210526315
 | Site 6 | 1848 | 2 | 0.3070175438596491
 | Site 7 | 2591 | 3 | 1.220338983050848
 | Site 8 | 616 | 3 | 0.4035087719298245
 | Site 9 | 1705 | 2 | 1.220338983050848
 | Site 10 | 2106 | 2 | 1.220338983050848
 | Site 11 | 298 | 1 | 0.3771929824561404
 | Site 12 | 1862 | 2 | 0.8771929824561403
 | Site 13 | 1708 | 1 | 0.7280701754385965
 | Site 14 | 1384 | 1 | 0.9473684210526315
 | Site 15 | 2365 | 2 | 0.9661016949152542
 | Site 16 | 1756 | 5 | 0.7982456140350878
 | Site 17 | 1741 | 2 | 0.7543859649122807
 | Site 18 | 435 | 2 | 0.5
 | Site 19 | 900 | 3 | 0.9096045197740112
 | Site 20 | 684 | 3 | 0.9473684210526315
 | Site 21 | 684 | 5 | 0.9473684210526315
 | Site 22 | 1609 | 1 | 0.7982456140350878
 | Site 23 | 1577 | 2 | 0.7105263157894737
 | Site 24 | 2761 | 1 | 0.7807017543859649
 | Site 25 | 3046 | 1 | 1.482456140350877
 | Site 26 | 2861 | 1 | 0.9491525423728814
 | Site 27 | 2839 | 2 | 0.9209039548022598
 | Site 28 | 2563 | 2 | 0.7456140350877193
 | Site 29 | 176 | 1 | 0.1754385964912281
 | Site 30 | 723 | 0 | 0.9473684210526315
 | Site 31 | 917 | 2 | 0.9473684210526315
 | Site 32 | 159 | 0 | 0.2543859649122807
 | Site 33 | 1619 | 2 | 1.146892655367232
 | Site 34 | 2628 | 2 | 0.9473684210526315
 | Site 35 | 2626 | 1 | 0.7627118644067796
 | Site 36 | 1250 | 1 | 1.220338983050848
 | Site 37 | 677 | 3 | 0.9473684210526315
 | Site 38 | 1682 | 2 | 0.9473684210526315
 | Site 39 | 1655 | 2 | 0.903954802259887
 | Site 40 | 1097 | 2 | 0.9473684210526315
 | Site 41 | 878 | 1 | #[NAME]!
 | Site 42 | 1713 | 1 | 1.220338983050848
 | Site 43 | 1146 | 1 | 0.6578947368421053
 | Site 44 | 774 | 1 | 1.19774011299435
 | Site 45 | 811 | 1 | 0.9473684210526315
 | Site 46 | 1666 | 1 | 0.868421052631579
 | Site 47 | 1561 | 5 | 0.6052631578947368
 | Site 48 | 1378 | 3 | 0.1491228070175439
 | Site 49 | 1662 | 3 | 0.8421052631578947
 | Site 50 | 3008 | 2 | 0.8248587570621468
 | Site 51 | 2735 | 1 | 0.6052631578947368
 | Site 52 | 384 | 5 | 0.1491228070175439
 | Site 53 | 1329 | 5 | 0.5877192982456141
 | Site 54 | 1251 | 3 | 0.131578947368421
 | Site 55 | 1183 | 3 | 0.5263157894736842
 | Site 56 | 1251 | 3 | 0.4473684210526316
 | Site 57 | 1241 | 3 | 0.6403508771929824
 | Site 58 | 1229 | 3 | 0.6140350877192983
 | Site 59 | 1475 | 2 | 0.8859649122807017
 | Site 60 | 1482 | 3 | 0.9122807017543859
 | Site 61 | 1738 | 2 | 0.9473684210526315
 | Site 62 | 1611 | 3 | 1.220338983050848
 | Site 63 | 1808 | 3 | 1.220338983050848
 | Site 64 | 1035 | 3 | 0.8070175438596491
 | Site 65 | 1213 | 3 | 0.8245614035087719
 | Site 66 | 2125 | 1 | 0.131578947368421
 | Site 67 | 2575 | 2 | 0.9473684210526315
 | Site 68 | 3693 | 3 | 1.220338983050848
 | Site 69 | 2444 | 3 | 0.9035087719298246
 | Site 70 | 2668 | 5 | 0.9473684210526315
 | Site 71 | 1371 | 2 | 0.9473684210526315
 | Site 72 | 1129 | 2 | 0.9473684210526315
 | Site 73 | 1264 | 1 | 0.9473684210526315
 | Site 74 | 1779 | 3 | 0.9774011299435028
 | Site 75 | 1969 | 1 | 1.220338983050848
 | Site 76 | 2255 | 5 | 1.220338983050848
 | Site 77 | 2719 | 1 | 0.9473684210526315
 | Site 78 | 2825 | 1 | 0.8248587570621468
 | Site 79 | 4762 | 3 | 1.435215946843854
 | Site 80 | 2915 | 1 | 0.9473684210526315
 | Site 81 | 2737 | 1 | 0.9473684210526315
 | Site 82 | 2737 | 1 | 0.9473684210526315
 | Site 83 | 2393 | 1 | 0.8070175438596491
 | Site 84 | 2827 | 3 | 0.9473684210526315
 | Site 85 | 5156 | 2 | 0.9473684210526315
 | Site 86 | 2322 | 3 | 0.631578947368421
 | Site 87 | 2611 | 1 | 0.9473684210526315
 | Site 88 | 5156 | 2 | 1.435215946843854
 | Site 89 | 1388 | 1 | 0.9473684210526315
 | Site 90 | 1993 | 3 | 1.220338983050848
 | Site 91 | 1149 | 2 | 0.543859649122807
 | Site 92 | 2044 | 3 | 1.220338983050848
 | Site 93 | 804 | 5 | 0.3596491228070176
 | Site 94 | 1594 | 3 | 0.9473684210526315
 | Site 95 | 1656 | 5 | 0.9473684210526315
 | Site 96 | 1647 | 3 | 0.9473684210526315
 | Site 97 | 1535 | 3 | 0.9473684210526315
 | Site 98 | 1831 | 2 | 0.9473684210526315
 | Site 99 | 1461 | 3 | 0.868421052631579
 | Site 100 | 867 | 3 | 0.9473684210526315
 | Site 101 | 734 | 2 | 0.9473684210526315
 | Site 102 | 6200 | 3 | 0.9473684210526315
 | Site 103 | 7290 | 3 | 1.220338983050848
 | Site 104 | 6397 | 3 | 0
 | Site 105 | 6280 | 2 | 0.9473684210526315
 | Site 106 | 6812 | 1 | 1.220338983050848
 | Site 107 | 7471 | 3 | 1.220338983050848
 | Site 108 | 6866 | 5 | 1.220338983050848
 | Site 109 | 6283 | 3 | 0.9473684210526315
 | Site 110 | 6410 | 3 | 1.112994350282486
 | Site 111 | 5708 | 0 | #[NAME]!
 | Site 112 | 6341 | 2 | 0.9473684210526315
 | Site 113 | 1433 | 2 | 0.7982456140350878
 | Site 114 | 1814 | 5 | 1.112994350282486
 | Site 115 | 1536 | 2 | 0.9473684210526315