Spreadsheet: 758457d1638885314-populate-data-based-on-selection-from-dropdown-project-planning
Sheet: Project

S.NO | Code | Duplicated | Project | Client | Region | Location | Site | Coordinate | Remarks | Status | Start | Last date of work | Working Days | Pettycash | Last Scope | Type | meter | Supervisor | JCC# | [NAME] | Invoice #
1 | RYD-1084 | 1 |  | ARABIAN ROCK | Riyadh | RIYADH | RYD-1084 ARABIAN ROCK RIYADH |  |  | Invoiced | 2021-07-15 00:00:00 | 2021-08-09 00:00:00 | 34.5 | 3628 | 006. Pipe Pulling | 200mmx4 | 80 | Rashid | 2360 | 82.5 | 6711
2 | JED-1193 | 1 |  | OJAIMI | MADINA | MADINA | [NAME] |  |  | Invoiced | 2021-07-28 00:00:00 | 2021-08-02 00:00:00 | 7 | 3259 | 006. Pipe Pulling | 200mmx2 | 60 | [NAME] | 1302 | 60 | 6698
3 | JED-1196 | 1 |  | ITC | Thuwal | [NAME] | [NAME] |  |  | Invoiced | 2021-07-29 00:00:00 | 2021-08-12 00:00:00 | 14 | 7721 | 006. Pipe Pulling | 225mmx1 | 414 | [NAME] | 1500 | 414 | 6731
4 | JED-1197 | 1 |  | Anadee | [NAME] | [NAME] | [NAME] |  |  | Invoiced | 2021-07-24 00:00:00 | 2021-08-01 00:00:00 | 9 | 3417 | 006. Pipe Pulling | 160mmx1 | 115 | [NAME] | 1303 | 119 | 6699
5 | JED-1198 | 1 |  | [NAME] | [NAME] | [NAME] | JED-1198 [NAME] |  |  | Invoiced | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 1.9 | 2708 | 006. Pipe Pulling | 200mmx4 | 40 | [NAME] | 1304 | 45 | 6712
6 | JED-1202 | 1 |  | Anadee | [NAME] | [NAME] | [NAME] madina |  |  | Invoiced | 2021-08-08 00:00:00 | 2021-08-11 00:00:00 | 4 | 1811 | 006. Pipe Pulling | 160mmx1 | 65 | [NAME] | 1305 | 70 | 6714
7 | [NAME] | 1 |  | Adil Haloul | jeddah | Khumra | JED-1204 Adil Haloul Khumra |  |  | Invoiced | 2021-08-08 00:00:00 | 2021-08-17 00:00:00 | 10 | 2710 | 006. Pipe Pulling | 200mmx2 | 156 | [NAME] | 1355 | 155 | 6723
8 | JED-1207 | 1 |  | Power Al Azaem | jeddah | jeddah | JED-1207 Power Al Azaem jeddah |  |  | Invoiced | 2021-08-10 00:00:00 | 2021-08-16 00:00:00 | 6.3 | 872 | 006. Pipe Pulling | 200mmx4 | 126 | [NAME] | 1354 | 125 | 6729
9 | RYD-1089 | 1 |  | [NAME] | Riyadh | RIYADH | [NAME] |  |  | Invoiced | 2021-08-11 00:00:00 | 2021-08-16 00:00:00 | 5 | 276 | 006. Pipe Pulling | 315MMX1 | 66 | Rashid | 2361 | 70 | 6726
10 | JED-1208 | 1 |  | Tamimi | JEDDAH | DUBA | [NAME] |  |  | Invoiced | 2021-08-15 00:00:00 | 2021-08-15 00:00:00 | 1 | 1320 | 006. Pipe Pulling | 200mmx1 | 15 | [NAME] | 1352 | 16 | 6725
11 | JED-1210 | 1 |  | Global Trading | Jeddah | duba | JED-1210 Global Trading duba |  |  | Invoiced | 2021-08-17 00:00:00 | 2021-08-17 00:00:00 | 1 | 351 | 006. Pipe Pulling | 110mmx1 | 19 | [NAME] | 2661 | 19 | 6724
12 | JED-1200 | 1 |  | Global Trading | Jeddah | Duba | [NAME] |  |  | Invoiced | 2021-08-18 00:00:00 | 2021-08-18 00:00:00 | 0.6 | 285 | 006. Pipe Pulling | 110mmx2 | 18 | [NAME] | 2661 | 18 | 6724
13 | JED-1212 | 1 |  | Global Trading | Jeddah | neom | JED-1212 Global Trading neom |  |  | Invoiced | 2021-08-18 00:00:00 | 2021-08-18 00:00:00 | 1 | 325 | 006. Pipe Pulling | 110mmx2 | 31 | [NAME] | 2661 | 31 | 6724
14 | JED-1213 | 1 |  | Global Trading | Jeddah | neom | JED-1213 Global Trading neom |  |  | Invoiced | 2021-08-19 00:00:00 | 2021-08-19 00:00:00 | 1 | 343 | 006. Pipe Pulling | 110mmx1 | 35 | [NAME] | 2661 | 35 | 6724
15 | [NAME] | 1 |  | Tamimi | JEDDAH | DUBA | [NAME] |  |  | Invoiced | 2021-08-20 00:00:00 | 2021-08-20 00:00:00 | 1 | 451 | 006. Pipe Pulling | 200mmx1 | 18 | [NAME] | 1352 | 18 | 6725
16 | JED-1216 | 1 |  | Adil Haloul | jeddah | Khumra | [NAME] |  |  | Invoiced | 2021-08-21 00:00:00 | 2021-08-23 00:00:00 | 3 | 620 | 006. Pipe Pulling | 200MMX2 | 53 | [NAME] | 2722 | 52 | 6730
17 | JED-1190 | 1 |  | AL SAHELI | RABIGH | RABIGH | [NAME] |  |  | Invoiced | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2 | 1150 | 006. Pipe Pulling | 200mmx2 | 60 | [NAME] | 1351 | 60 | 6641
18 | RYD-1090 | 1 |  | [NAME] | RIYADH | RIYADH | [NAME] RIYADH |  |  | Invoiced | 2021-08-16 00:00:00 | 2021-08-19 00:00:00 | 6 | 553 | 006. Pipe Pulling | 200mmx2 | 95 | Rashid | 2363 | 94 | 6728
19 | JED-1170 | 1 |  | CCS | jeddah | jeddah | JED-1170 CCS jeddah |  |  | Invoiced | 2021-06-08 00:00:00 | 2021-06-13 00:00:00 | 6 | 2319 | 006. Pipe Pulling | 180mmx1 | 140 | [NAME] | 1499 | 150 | 6733
20 | [NAME] | 1 |  | CCS | JEDDAH | JEDdah | JED-1182 CCS JEDdah |  |  | Invoiced | 2021-06-19 00:00:00 | 2021-06-22 00:00:00 | 4 | 1010 | 006. Pipe Pulling | 180mmx1 | 130 | [NAME] | 2714 | 140 | 6733
21 | JED-1188 | 1 |  | CCS | JEDDAH | JEDDAH | JED-1188 CCS JEDDAH |  |  | Invoiced | 2021-07-03 00:00:00 | 2021-07-06 00:00:00 | 3.5 | 810 | 006. Pipe Pulling | 160mmx1 | 65 | [NAME] | 1301 | 68 | 6733
22 | RYD-1046 |  |  | Badan Agricultural Company | Riyadh | RIYADH | Badan Agricultural Company |  |  | Invoiced | 2021-04-06 00:00:00 | 2021-08-07 00:00:00 | 3 | 0 | 006. Pipe Pulling | 315mmx5 | 58.3 | Rashid | 2483 | 58.3 | 6709
23 | RYD-1047 |  |  | Badan Agricultural Company | Riyadh | RIYADH | Badan Agricultural Company |  |  | Invoiced | 2021-04-10 00:00:00 | 2021-08-07 00:00:00 | 11 | 80 | 006. Pipe Pulling | 315mmx8 | 92 | Rashid | 2485 | 92 | 6708
24 | RYD-1048 |  |  | Badan Agricultural Company | Riyadh | RIYADH | Badan Agricultural Company |  |  | Invoiced | 2021-08-01 00:00:00 | 2021-08-07 00:00:00 | 3 | 60 | 006. Pipe Pulling | 315mmx9 | 101.7 | Rashid | 2484 | 101.7 | 6707
25 | HDPE Pipe Jointing-1 |  |  | Badan Agricultural Company | Riyadh | RIYADH | Badan Agricultural Company |  |  | Invoiced | 2021-08-01 00:00:00 | 2021-08-07 00:00:00 | 3 | 0 |  |  |  |  | 2483 | 5 | 6709-1
26 | HDPE Pipe Jointing-2 |  |  | Badan Agricultural Company | Riyadh | RIYADH | Badan Agricultural Company |  |  | Invoiced | 2021-08-01 00:00:00 | 2021-08-07 00:00:00 | 11 | 80 |  |  |  |  | 2485 | 8 | 6708-1
27 | HDPE Pipe Jointing-3 |  |  | Badan Agricultural Company | Riyadh | RIYADH | Badan Agricultural Company |  |  | Invoiced | 2021-08-01 00:00:00 | 2021-08-07 00:00:00 | 3 | 60 |  |  |  |  | 2484 | 9 | 6707-1
28 | Machine Mobilization-1 |  |  | [NAME]. [NAME] | Riyadh | RIYADH | [NAME]. [NAME] |  |  | Invoiced |  |  | 1 |  |  |  | 1 |  | 1 | 1 | 6698-1
29 | Machine Mobilization-2 |  |  | NASRE AL JAZIRA CONT. CO. | Riyadh | RIYADH | NASRE AL JAZIRA CONT. CO. |  |  | Invoiced |  |  | 1 |  |  |  | 1 |  | 1 | 1 | 6712-1
30 | Machine Mobilization-3 |  |  | Tamimi | Riyadh | RIYADH | Tamimi Global Co Ltd |  |  | Invoiced |  |  | 1 |  |  |  | 1 |  | 1 | 1 | 6725-1
31 | JED-1209 | 1 |  | Tamimi | JEDDAH | [NAME] | JED-1209 [NAME] |  |  | Invoiced | 2021-08-16 00:00:00 | 2021-08-16 00:00:00 | 1 | 420 | 006. Pipe Pulling | 200mmx1 | 13 | [NAME] | 1353 | 13 | 6725