Spreadsheet: 802196d1666700642-calculate-numbers-backwards-from-total-sum-value-book4
Sheet: Sheet1

 |  |  |  |  |  | Example 1 |  |  | Example 2 |  |  | Example 3 |  |  | Example 4 |  |  | Example 5
Position | Quantity | Price | Total Sum |  |  | Final Price | Total Sum |  | Final Price | Total Sum |  | Final Price | Total Sum |  | Final Price | Total Sum |  | Final Price | Total Sum
Position 1 | 13 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.05 |  |  | 3.02 |  |  | 3.02
Position 2 | 22 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04
Position 3 | 14 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02
Position 4 | 23 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04
Position 5 | 10 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02
Position 6 | 18 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04
Position 7 | 6 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02
Position 8 | 5 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04
Position 9 | 5 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02
Position 10 | 19 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04
Position 11 | 16 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.05
Position 12 | 8 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.07
Position 13 | 20 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02
Position 14 | 20 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04
Position 15 | 10 | 3.02 |  |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02 |  |  | 3.02
Position 16 | 25 | 3.039 |  |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04 |  |  | 3.04
Position 17 | 37 | 3.63 |  |  |  | 3.63 |  |  | 3.67 |  |  | 3.63 |  |  | 3.63 |  |  | 3.63
Position 18 | 37 | 3.63 |  |  |  | 3.63 |  |  | 3.63 |  |  | 3.63 |  |  | 3.67 |  |  | 3.63
Position 19 | 4095 | 0.133 |  |  |  | 0.13 |  |  | 0.13 |  |  | 0.13 |  |  | 0.14 |  |  | 0.13
Position 20 | 3969 | 0.133 |  |  |  | 0.13 |  |  | 0.13 |  |  | 0.13 |  |  | 0.13 |  |  | 0.13
Position 21 | 3807 | 0.133 |  |  |  | 0.13 |  |  | 0.13 |  |  | 0.13 |  |  | 0.13 |  |  | 0.13
Position 22 | 4636 | 0.133 |  |  |  | 0.13 |  |  | 0.13 |  |  | 0.13 |  |  | 0.13 |  |  | 0.14
Position 23 | 4413 | 0.083 |  |  |  | 0.09 |  |  | 0.08 |  |  | 0.08 |  |  | 0.09 |  |  | 0.08
Position 24 | 4367 | 0.083 |  |  |  | 0.08 |  |  | 0.08 |  |  | 0.08 |  |  | 0.08 |  |  | 0.08
Position 25 | 3825 | 0.083 |  |  |  | 0.08 |  |  | 0.08 |  |  | 0.08 |  |  | 0.08 |  |  | 0.08
Position 26 | 4162 | 0.083 |  |  |  | 0.08 |  |  | 0.08 |  |  | 0.08 |  |  | 0.08 |  |  | 0.08
Position 27 | 3528 | 0.163 |  |  |  | 0.16 |  |  | 0.17 |  |  | 0.16 |  |  | 0.16 |  |  | 0.16
Position 28 | 4438 | 0.163 |  |  |  | 0.16 |  |  | 0.16 |  |  | 0.16 |  |  | 0.16 |  |  | 0.16
Position 29 | 4169 | 0.351 |  |  |  | 0.35 |  |  | 0.35 |  |  | 0.35 |  |  | 0.35 |  |  | 0.35
Position 30 | 4842 | 0.351 |  |  |  | 0.35 |  |  | 0.35 |  |  | 0.35 |  |  | 0.35 |  |  | 0.35
Position 31 | 3943 | 0.351 |  |  |  | 0.35 |  |  | 0.32 |  |  | 0.35 |  |  | 0.35 |  |  | 0.35
Position 32 | 4925 | 0.351 |  |  |  | 0.35 |  |  | 0.35 |  |  | 0.35 |  |  | 0.35 |  |  | 0.35
Position 33 | 4816 | 0.429 |  |  |  | 0.43 |  |  | 0.43 |  |  | 0.43 |  |  | 0.43 |  |  | 0.43
Position 34 | 3941 | 0.429 |  |  |  | 0.43 |  |  | 0.43 |  |  | 0.43 |  |  | 0.43 |  |  | 0.43
Position 35 | 4485 | 0.534 |  |  |  | 0.53 |  |  | 0.53 |  |  | 0.53 |  |  | 0.53 |  |  | 0.53
Position 36 | 4718 | 0.534 |  |  |  | 0.53 |  |  | 0.53 |  |  | 0.53 |  |  | 0.53 |  |  | 0.53
Position 37 | 4256 | 0.534 |  |  |  | 0.53 |  |  | 0.53 |  |  | 0.53 |  |  | 0.53 |  |  | 0.53
Position 38 | 4527 | 0.656 |  |  |  | 0.69 |  |  | 0.66 |  |  | 0.66 |  |  | 0.67 |  |  | 0.66
Position 39 | 4393 | 0.656 |  |  |  | 0.66 |  |  | 0.66 |  |  | 0.66 |  |  | 0.66 |  |  | 0.65
Position 40 | 3738 | 0.229 |  |  |  | 0.23 |  |  | 0.23 |  |  | 0.23 |  |  | 0.23 |  |  | 0.23
Position 41 | 3504 | 0.229 |  |  |  | 0.23 |  |  | 0.23 |  |  | 0.23 |  |  | 0.23 |  |  | 0.23
 |  |  |  |  |  |  | 30629.16 |  |  | 30367.69 |  |  | 30449.61 |  |  | 30581.05 |  |  | 30452.37
 |  |  | Initial Grand total sum |  |  |  | Final Grand total sum |  |  | Final Grand total sum |  |  | Final Grand total sum |  |  | Final Grand total sum |  |  | Final Grand total sum