Spreadsheet: 480849d1474104774-if-or-true-statement-for-choosing-the-currency-to-calculate-exchange-rates-currency-added-costing-format-2-1
Sheet: GRAND TOTAL

 | CALCULATION OF TOTAL UNIT COST
S/N | [NAME] |  |  | QTY | T1 | T2 | [NAME]
1 | BAG 1 |  |  | 5 | 2215032.75 | 11075163.75 | 12305737.5 | 51273.90625
2 | BAG 2 |  |  | 1 | 2418576.3 | 2418576.3 | 2493377.628865979 | 10389.07345360825
3 | BAG 3 |  |  | 1 | 2821672.35 | 2821672.35 | 2908940.56701031
4 | 0 |  |  | 1 | 0 | 0 | 0
5 | 0 |  |  | 1 | 0 | 0 | 0
6 | 0 |  |  | 1 | 0 | 0 | 0 | 1230573.75
7 | 0 |  |  | 1 | 0 | 0 | 0
8 | 0 |  |  | 1 | 0 | 0 | 0
9 | 0 |  |  | 1 | 0 | 0 | 0 | 0
10 | 0 |  |  | 1 | 0 | 0 | 0 | 0
5 | 0 |  |  | 1 | 0 | 0 | 0 | 0
6 | 0 |  |  | 1 | 0 | 0 | 0 | 0
7 | 0 |  |  | 1 | 0 | 0 | 0 | 0
8 | 0 |  |  | 1 | 0 | 0 | 0 | 0
9 | 0 |  |  | 1 | 0 | 0 | 0 | 0
10 | 0 |  |  | 1 | 0 | 0 | 0 | 0
11 | 0 |  |  | 1 | 0 | 0 | 0 | 0
12 | 0 |  |  | 1 | 0 | 0 | 0 | 0
13 | 0 |  |  | 1 | 0 | 0 | 0 | 0
14 | 0 |  |  | 1 | 0 | 0 | 0 | 0
15 | 0 |  |  | 1 | 0 | 0 | 0 | 0
16 | 0 |  |  | 1 | 0 | 0 | 0 | 0
17 | 0 |  |  | 1 | 0 | 0 | 0
18 | 0 |  |  | 1 | 0 | 0 | 0
1 | FLIR P660 |  |  | 0 | 18961411.6944 | 0 | 0
2 | 0 |  |  | 0 | 0 | 0 | 0
3 | 0 |  |  | 0 | 0 | 0 | 0
4 | 0 |  |  | 0 | 0 | 0 | 0
5 | 0 |  |  | 0 | 0 | 0 | 0
6 | 0 |  |  | 0 | 0 | 0 | 0
7 | 0 |  |  | 0 | 0 | 0 | 0
8 | 0 |  |  | 0 | 0 | 0 | 0
9 | 0 |  |  | 1 | 0 | 0 | 0
10 | 0 |  |  | 1 | 0 | 0 | 0
11 | 0 |  |  | 1 | 0 | 0 | 0
12 | 0 |  |  | 1 | 0 | 0 | 0
13 | 0 |  |  | 1 | 0 | 0 | 0
14 | 0 |  |  | 1 | 0 | 0 | 0
15 | 0 |  |  | 1 | 0 | 0 | 0
16 | 0 |  |  | 1 | 0 | 0 | 0
17 | 0 |  |  | 1 | 0 | 0 | 0
18 | 0 |  |  | 1 | 0 | 0 | 0
19 | 0 |  |  | 1 | 0 | 0 | 0
20 | 0 |  |  | 1 | 0 | 0 | 0
21 | 0 |  |  | 1 | 0 | 0 | 0
22 | 0 |  |  | 1 | 0 | 0 | 0
23 | 0 |  |  | 1 | 0 | 0 | 0
24 | 0 |  |  | 0 | 0 | 0 | 0
1 | SFX 32 |  |  | 0 | 15103023.3585 | 0 | 0
2 | DIGIPHONE PLUS |  |  | 0 | 2239615.0161 | 0 | 0
3 | 0 |  |  | 0 | 0 | 0 | 0
4 | 0 |  |  | 0 | 0 | 0 | 0
5 | 0 |  |  | 6 | 0 | 0 | 0
6 | 0 |  |  | 0 | 0 | 0 | 0
7 | 0 |  |  | 0 | 0 | 0 | 0
8 | 0 |  |  | 0 | 0 | 0 | 0
9 | 0 |  |  | 0 | 0 | 0 | 0
10 | 0 |  |  | 0 | 0 | 0 | 0
11 | 0 |  |  | 1 | 0 | 0 | 0
12 | 0 |  |  | 1 | 0 | 0 | 0
13 | 0 |  |  | 1 | 0 | 0 | 0
14 | 0 |  |  | 1 | 0 | 0 | 0
15 | 0 |  |  | 1 | 0 | 0 | 0
16 | 0 |  |  | 1 | 0 | 0 | 0
17 | 0 |  |  | 1 | 0 | 0 | 0
18 | 0 |  |  | 1 | 0 | 0 | 0
19 | 0 |  |  | 1 | 0 | 0 | 0
20 | 0 |  |  | 1 | 0 | 0 | 0
21 | 0 |  |  | 1 | 0 | 0 | 0
22 | 0 |  |  | 1 | 0 | 0 | 0
#N/A | TEST |  |  | 0 | 9199.334063835617 | 0 | 0
1 | FLUKE 1621 |  |  | 0 | 332224.2 | 0 | 0
2 | FLUKE 177 |  |  | 0 | 147420 | 0 | 0
3 | FLUKE 113 |  |  | 0 | 63201.6 | 0 | 0
4 | FLUKE 376 |  |  | 0 | 219958.2 | 0 | 0
5 | FLUKE 1503 |  |  | 0 | 207484.2 | 0 | 0
6 | 0 |  |  | 0 | 0 | 0 | 0
7 | 0 |  |  | 0 | 0 | 0 | 0
8 | 0 |  |  | 0 | 0 | 0 | 0
9 | 0 |  |  | 0 | 0 | 0 | 0
10 | 0 |  |  | 1 | 0 | 0 | 0
11 | 0 |  |  | 0 | 0 | 0 | 0
12 | 0 |  |  | 1 | 0 | 0 | 0
13 | 0 |  |  | 1 | 0 | 0 | 0
14 | 0 |  |  | 1 | 0 | 0 | 0
15 | 0 |  |  | 1 | 0 | 0 | 0
16 | 0 |  |  | 1 | 0 | 0 | 0
17 | 0 |  |  | 1 | 0 | 0 | 0
18 | 0 |  |  | 1 | 0 | 0 | 0
19 | 0 |  |  | 1 | 0 | 0 | 0
20 | 0 |  |  | 1 | 0 | 0 | 0
21 | 0 |  |  | 1 | 0 | 0 | 0
22 | 0 |  |  | 1 | 0 | 0 | 0
23 | 0 |  |  | 1 | 0 | 0 | 0
24 | TEST |  |  | 0 | 0 | 0 | 0 | 74160.96545454545
 |  |  |  |  | SUB T | 16315412.4 | 17708055.69587629 | 78064.17416267942 |  | 74160.96545454545 | 14455299.7
 |  |  |  |  | VAT | 815770.6200000001 | 531241.6708762887 | 3903.208708133972
 |  |  |  |  | GRAND T | 17131183.02 | -17176814.025 | 81967.3828708134
 |  |  |  |  |  | 2569677.453 | 576872.6758762896
 |  |  |  |  | 0.5 | 8565591.51
 |  |  |  |  | 0.6 | 10278709.812
 |  |  |  |  | 0.7 | 11991828.114 | 119918.28114