Spreadsheet: 768414d1644952765-distribute-a-number-from-a-cell-across-others-based-on-the-percentage-of-another-cell-fruit-redacted-
Sheet: RED POP %

FRUIT | FRUIT AVAILABLE | FRUIT ALLOCATED | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TEAM 5 | TEAM 6 | TEAM 7 | TEAM 8 | TEAM 9 | TEAM 10 | TEAM 11 | TEAM 12 | TEAM 13 | TEAM 14 | TEAM 15 | TEAM 16 | TEAM 17 | TEAM 18 | TEAM 19 | TEAM 20 | TEAM 21 | TEAM 22 | TEAM 23 | TEAM 24 | TEAM 25 | TEAM 26 | TEAM 27 | TOTAL |  | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TEAM 5 | TEAM 6 | TEAM 7 | TEAM 8 | TEAM 9 | TEAM 10 | TEAM 11 | TEAM 12 | TEAM 13 | TEAM 14 | TEAM 15 | TEAM 16 | TEAM 17 | TEAM 18 | TEAM 19 | TEAM 20 | TEAM 21 | TEAM 22 | TEAM 23 | TEAM 24 | TEAM 25 | TEAM 26 | TEAM 27 | TOTAL | DELTA | UNDER ASSIGNED |  |  |  | OVER ASSIGNED
FRUIT | FRT AVAL | FRT ALC | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TEAM 5 | TEAM 6 | TEAM 7 | TEAM 8 | TEAM 9 | TEAM 10 | TEAM 11 | TEAM 12 | TEAM 13 | TEAM 14 | TEAM 15 | TEAM 16 | TEAM 17 | TEAM 18 | TEAM 19 | TEAM 20 | TEAM 21 | TEAM 22 | TEAM 23 | TEAM 24 | TEAM 25 | TEAM 26 | TEAM 27 |  |  | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TEAM 5 | TEAM 6 | TEAM 7 | TEAM 8 | TEAM 9 | TEAM 10 | TEAM 11 | TEAM 12 | TEAM 13 | TEAM 14 | TEAM 15 | TEAM 16 | TEAM 17 | TEAM 18 | TEAM 19 | TEAM 20 | TEAM 21 | TEAM 22 | TEAM 23 | TEAM 24 | TEAM 25 | TEAM 26 | TEAM 27 | TOTAL | DELTA
FRUIT 1 |  | 231
FRUIT 2 |  | 15
FRUIT 4 |  | 85
FRUIT 6 |  | 10
FRUIT 8 |  | 466
FRUIT 9 |  | 35
FRUIT 10 |  | 70
FRUIT 11 |  | 83
FRUIT 12 |  | 74
FRUIT 13 |  | 52
FRUIT 19 |  | 44
FRUIT 20 |  | 67
FRUIT 21 |  | 14
FRUIT 22 |  | 58
FRUIT 24 |  | 9
FRUIT 26 |  | 275
FRUIT 27 |  | 46
FRUIT 29 |  | 135
FRUIT 31 |  | 160
FRUIT 35 |  | 92
FRUIT 36 |  | 14
FRUIT 37 |  | 26
FRUIT 38 |  | 9
FRUIT 40 |  | 33
FRUIT 42 |  | 20
FRUIT 43 |  | 30
FRUIT 44 |  | 16
FRUIT 46 |  | 20
FRUIT 47 |  | 8
FRUIT 48 |  | 36
FRUIT 49 |  | 41
FRUIT 51 |  | 5
FRUIT 52 |  | 102
FRUIT 53 |  | 60
FRUIT 57 |  | 0
FRUIT 58 |  | 66
FRUIT 60 |  | 60
FRUIT 61 |  | 9
FRUIT 62 |  | 20
FRUIT 63 |  | 0
FRUIT 64 |  | 25
FRUIT 66 |  | 11
FRUIT 67 |  | 21
FRUIT 69 |  | 68
FRUIT 71 |  | 1
FRUIT 72 |  | 26
FRUIT 74 |  | 8
FRUIT 75 |  | 33
FRUIT 76 |  | 27
FRUIT 79 |  | 22
FRUIT 80 |  | 90
FRUIT 81 |  | 41
FRUIT 83 |  | 2
FRUIT 85 |  | 4
FRUIT 87 |  | 150
FRUIT 89 |  | 72
FRUIT 90 |  | 26
FRUIT 91 |  | 8
FRUIT 92 |  | 75
FRUIT 93 |  | 33
FRUIT 94 |  | 14
FRUIT 95 |  | 194
FRUIT 97 |  | 265
FRUIT 100 |  | 19
FRUIT 101 |  | 10
FRUIT 102 |  | 12
FRUIT 103 |  | 12
FRUIT 106 |  | 0
FRUIT 107 |  | 8
FRUIT 108 |  | 38
FRUIT 109 |  | 35
FRUIT 111 |  | 82
FRUIT 113 |  | 20
FRUIT 114 |  | 13
FRUIT 115 |  | 10
FRUIT 116 |  | 5
FRUIT 117 |  | 5
FRUIT 118 |  | 11
FRUIT 119 |  | 12
FRUIT 121 |  | 11
FRUIT 122 |  | 11
FRUIT 125 |  | 14
FRUIT 126 |  | 54
FRUIT 127 |  | 37
FRUIT 128 |  | 11
FRUIT 129 |  | 31
FRUIT 130 |  | 6
FRUIT 131 |  | 20
FRUIT 132 |  | 0
FRUIT 133 |  | 16
FRUIT 134 |  | 14
FRUIT 135 |  | 19
FRUIT 136 |  | 6
FRUIT 137 |  | 5
FRUIT 138 |  | 6
FRUIT 139 |  | 24
FRUIT 140 |  | 19
FRUIT 141 |  | 34
FRUIT 142 |  | 10
FRUIT 143 |  | 9
FRUIT 144 |  | 23
FRUIT 145 |  | 8
FRUIT 147 |  | 10
FRUIT 148 |  | 8
FRUIT 149 |  | 61
FRUIT 150 |  | 2
FRUIT 152 |  | 5
FRUIT 153 |  | 0
FRUIT 154 |  | 7
FRUIT 156 |  | 6
FRUIT 157 |  | 13
FRUIT 158 |  | 35
FRUIT 159 |  | 19
FRUIT 161 |  | 2
FRUIT 163 |  | 3
FRUIT 164 |  | 3
FRUIT 165 |  | 13
FRUIT 167 |  | 6
FRUIT 168 |  | 4
FRUIT 169 |  | 10
FRUIT 170 |  | 18
FRUIT 171 |  | 25
FRUIT 172 |  | 30
FRUIT 173 |  | 7
FRUIT 175 |  | 5
FRUIT 176 |  | 7
FRUIT 177 |  | 54
FRUIT 180 |  | 8
FRUIT 181 |  | 13
FRUIT 182 |  | 23
FRUIT 183 |  | 22
FRUIT 184 |  | 17
FRUIT 185 |  | 10
FRUIT 186 |  | 61
FRUIT 187 |  | 41
FRUIT 189 |  | 72
FRUIT 190 |  | 21
FRUIT 191 |  | 16
FRUIT 192 |  | 12
FRUIT 193 |  | 25
FRUIT 194 |  | 42
FRUIT 195 |  | 28
FRUIT 196 |  | 10
FRUIT 197 |  | 12
FRUIT 198 |  | 0
FRUIT 199 |  | 32
FRUIT 201 |  | 8
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
RANK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RANK