Spreadsheet: 148914d1333615279-change-formula-if-number-format-changes-test-1
Sheet: Bill 1

 | MONTHLY STATEMENT No. 53 FOR THE PERIOD OF FEBRUARY AND MARCH 2012
 |  | CODE | [NAME]. 1: GENERAL REQUIREMENTS |  |  | UNIT RATES |  |  | TOTAL |  |  |  | QUANTITY |  |  | AMOUNT
 | SECTION | ITEM |  | QTY | UNIT
 | NO. | NO. | [NAME]
 |  |  |  |  |  | SUPPLY | INSTALL | TOTAL | SUPPLY | INSTALL | TOTAL |  | PREVIOUS | CURRENT | TO DATE | PREVIOUS | CURRENT | TO DATE
 |  |  |  |  |  | QAR | QAR | QAR | QAR | QAR | QAR
 |  |  |  | a |  | b | c | d=b+c | e=a*b | f=a*c | g=e+f
1
1 | 01000 | 200 | CONSTRUCTION OF TEMPORARY FACILITIES & UTILITIES
1
1 | 01000 | 201 | Temporary  offices for contractor | 1 | LS |  | 1631484.389212979 | 1631484.389212979 | 0 | 1631484.389212979 | 1631484.389212979 |  | 1 |  | 1 | 1631484.39 | -0.0007870213594287634 | 1631484.389212979
1 | 01000 | 202 | Canteen/ First Aid clinic | 1 | LS |  | 129513.3305777103 | 129513.3305777103 | 0 | 129513.3305777103 | 129513.3305777103 |  | 1 |  | 1 | 129513.33 | 0.0005777102778665721 | 129513.3305777103
1 | 01000 | 203 | Marina/handling facilities | 1 | LS |  | 45126.59602010811 | 45126.59602010811 | 0 | 45126.59602010811 | 45126.59602010811 |  | 1 |  | 1 | 45126.6 | -0.003979891887865961 | 45126.59602010811
1 | 01000 | 204 | Tool Houses & Area Shacks | 1 | LS |  | 39485.7715175946 | 39485.7715175946 | 0 | 39485.7715175946 | 39485.7715175946 |  | 1 |  | 1 | 39485.77 | 0.001517594602773897 | 39485.7715175946
1 | 01000 | 205 | Saw Sheds, carpentry shops, fabrication facilities | 1 | LS |  | 338449.4701508108 | 338449.4701508108 | 0 | 338449.4701508108 | 338449.4701508108 |  | 1 |  | 1 | 338449.47 | 0.0001508108689449728 | 338449.4701508108
1 | 01000 | 206 | Warehouses [Rent outside of job site] | 1 | LS |  | 97473.44740343351 | 97473.44740343351 | 0 | 97473.44740343351 | 97473.44740343351 |  | 1 |  | 1 | 97473.45 | -0.002596566482679918 | 97473.44740343351
1 | 01000 | 207 | Rent, Buildings & Land | 1 | LS |  | 338449.4701508108 | 338449.4701508108 | 0 | 338449.4701508108 | 338449.4701508108 |  | 1 |  | 1 | 338449.47 | 0.0001508108689449728 | 338449.4701508108
1 | 01000 | 208 | Fabrication Facilities | 1 | LS |  | 56408.24502513514 | 56408.24502513514 | 0 | 56408.24502513514 | 56408.24502513514 |  | 1 |  | 1 | 56408.25 | -0.004974864859832451 | 56408.24502513514
1 | 01000 | 209 | Power & Lights, installation | 1 | LS |  | 16245.57456723892 | 16245.57456723892 | 0 | 16245.57456723892 | 16245.57456723892 |  | 1 |  | 1 | 16245.57 | 0.004567238920571981 | 16245.57456723892
1 | 01000 | 210 | Potable Water - Installation | 1 | LS |  | 56408.24502513514 | 56408.24502513514 | 0 | 56408.24502513514 | 56408.24502513514 |  | 1 |  | 1 | 56408.25 | -0.004974864859832451 | 56408.24502513514
1 | 01000 | 211 | Construction Water - installation | 1 | LS |  | 112816.4900502703 | 112816.4900502703 | 0 | 112816.4900502703 | 112816.4900502703 |  | 1 |  | 1 | 112816.49 | 5.027027509640902e-05 | 112816.4900502703
1 | 01000 | 212 | Sanitary Fac. - Installation | 1 | LS |  | 338449.4701508108 | 338449.4701508108 | 0 | 338449.4701508108 | 338449.4701508108 |  | 1 |  | 1 | 338449.47 | 0.0001508108689449728 | 338449.4701508108
1 | 01000 | 213 | Construction Labor Camp | 1 | LS |  | 5207584.361092665 | 5207584.361092665 | 0 | 5207584.361092665 | 5207584.361092665 |  | 1 |  | 1 | 5207584.36 | 0.001092664897441864 | 5207584.361092665
1 | 01000 | 214 | Temporary Roads / Access ways | 1 | LS |  | 56408.24502513514 | 56408.24502513514 | 0 | 56408.24502513514 | 56408.24502513514 |  | 1 |  | 1 | 56408.25 | -0.004974864859832451 | 56408.24502513514
1 | 01000 | 215 | Backup power supply | 3 | LS |  | 33844.94701508108 | 33844.94701508108 | 0 | 101534.8410452432 | 101534.8410452432 |  | 1 |  | 1 | 33844.95 | 67689.89104524325 | 101534.8410452432
1 | 01000 | 216 | Construction of Temporary Nursery | 2 | LS |  | 33844.94701508108 | 33844.94701508108 | 0 | 67689.89403016216 | 67689.89403016216 |  | 1 |  | 1 | 33844.95 | 33844.94403016217 | 67689.89403016216
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 |  |  | SUB-TOTAL FOR CONSTRUCTION OF TEMPORARY FACILITIES & UTILITIES |  |  |  |  |  | 0 | 8633527.841045244 | 8633527.841045244 |  |  |  |  | 8531993.02 | 101534.8210452441 | 8633527.841045244