-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
The data in the images cannot be read into Excel, unless the people who are trying to help retype it for experimenting, formula building, etc.
Upvote
0
Excel Facts
Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Hi Aladin,
Sorry, I do not know how to attach the file. If you don't mind, can you help how to that? Thank you so much.
Upvote
0
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Upvote
0
| Excel Workbook | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | ACTUAL RESULT | |||||||||||
| 2 | WBS | ACT ID | ACT NAME | TOTAL COST | ACTUAL COST | TOTAL COST | ||||||
| 3 | PROJECT BL | 4,515,246.00 | 3,987,296.00 | |||||||||
| 4 | GENERAL | 4,510,246.00 | 3,982,296.00 | |||||||||
| 5 | MILESTONE | 710,000.00 | 585,000.00 | |||||||||
| 6 | GEN-P09-1000 | Commencement Date | 125,000.00 | |||||||||
| 7 | GEN-P09-1630 | Completion Date | 585,000.00 | 585,000.00 | 585,000.00 | |||||||
| 8 | CONTRACTUAL REQUIREMENTS | 3,800,246.00 | 3,397,296.00 | |||||||||
| 9 | GEN-P09-1040 | Performance bond | 498,750.00 | 498,750.00 | 498,750.00 | |||||||
| 10 | GEN-P09-1050 | Insurance of work | 23,750.00 | 23,750.00 | 23,750.00 | |||||||
| 11 | GEN-P09-1060 | Third party insurance | 23,750.00 | |||||||||
| 12 | GEN-P09-1070 | Workmen compensation insurance | 47,500.00 | 47,500.00 | 47,500.00 | |||||||
| 13 | PRELIMINARIES | 1,874,600.00 | 1,854,500.00 | |||||||||
| 14 | GEN-P09-1100 | All obligations and Liabilities in complying with the General & Particular of the Contracts | 47,500.00 | 47,500.00 | 47,500.00 | |||||||
| 15 | GEN-P09-1110 | Providing all necessary superintendence in accordance with the General Conditions of the Contract | 850,000.00 | 850,000.00 | 850,000.00 | |||||||
| 16 | GEN-P09-1120 | Quality Assurance Including Testing of Materials and Work | 925,000.00 | 925,000.00 | 925,000.00 | |||||||
| 17 | GEN-P09-1130 | Contractual Requirements on temporary controls on the environment and coordination | 32,000.00 | 32,000.00 | 32,000.00 | |||||||
| 18 | GEN-P09-1140 | Specified Requirements excluding temporary works, mobilization/demobilization | 20,100.00 | |||||||||
| 19 | PERMITS & APPROVALS | 1,331,896.00 | 972,796.00 | |||||||||
| 20 | PROJECT SIGN BOARD | 421,796.00 | 421,796.00 | |||||||||
| 21 | GEN-P09-1080 | Apply for Signboard permit | 268,900.00 | 268,900.00 | 268,900.00 | |||||||
| 22 | GEN-P09-1230 | Approve Signboard permit | 152,896.00 | 152,896.00 | 152,896.00 | |||||||
| 23 | TEMPORARY OFFICE PERMIT | 732,000.00 | 482,000.00 | |||||||||
| 24 | GEN-P09-1090 | Apply Site office permit | 120,000.00 | 120,000.00 | 120,000.00 | |||||||
| 25 | GEN-P09-1180 | Apply for Environmental permit | 250,000.00 | |||||||||
| 26 | GEN-P09-1190 | Apply for Excavation permit | 362,000.00 | 362,000.00 | 362,000.00 | |||||||
| 27 | HOARDING, SIGNBOARD & ACCESS ROAD | 178,100.00 | 69,000.00 | |||||||||
| 28 | GEN-P09-1310 | Submit drawing for signboard | 6,000.00 | 6,000.00 | 6,000.00 | |||||||
| 29 | GEN-P09-1320 | Installation of fence & Security Post | 109,100.00 | |||||||||
| 30 | GEN-P09-1330 | Access Road Installation to Project Office | 63,000.00 | 63,000.00 | 63,000.00 | |||||||
| 31 | DESIGN & ENGINEERING | 5,000.00 | 5,000.00 | |||||||||
| 32 | SHOP DRAWING | 5,000.00 | 5,000.00 | |||||||||
| 33 | ENG-SP-P09-1000 | Prepare & Submit Baseline programme | 2,500.00 | 2,500.00 | 2,500.00 | |||||||
| 34 | ENG-SP-P09-1010 | Review & Approve Baseline programme | 2,500.00 | 2,500.00 | 2,500.00 | |||||||
Sheet1 | ||||||||||||
Last edited:
Upvote
0
Similar threads
- Solved
