Spreadsheet: 148900d1333609201-how-to-change-the-formulas-in-multiple-sheets-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 | 1 | LS |  | 33844.94701508108 | 33844.94701508108 | 0 | 33844.94701508108 | 33844.94701508108 |  | 1 |  | 1 | 33844.95 | -0.00298491891589947 | 33844.94701508108
1 | 01000 | 216 | Construction of Temporary Nursery | 1 | LS |  | 33844.94701508108 | 33844.94701508108 | 0 | 33844.94701508108 | 33844.94701508108 |  | 1 |  | 1 | 33844.95 | -0.00298491891589947 | 33844.94701508108
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 |  |  | SUB-TOTAL FOR CONSTRUCTION OF TEMPORARY FACILITIES & UTILITIES |  |  |  |  |  | 0 | 8531992.999999998 | 8531992.999999998 |  |  |  |  | 8531993.02 | -0.02000000141561031 | 8531992.999999998