Spreadsheet: 181163d1347950575-conditional-formating-advanced-entry
Sheet: Sheet3

S.No | 2012-09-01 00:00:00 | FOREMAN | PROJECT NO |  |  | JS DT | TOTAL HRS | Emp. No. |  | Emp. Name | BASIC | GROSS | PRJ NO | PRJ NAME | Hrs | Location | [NAME] work | Proj. [NAME] | Proj Status | Proj Completion Dt | OT TYPE | OT | REGULAR HRS | CHECK CELL W/O 0 | PRJ COST | RUNNING BALANCE DATE WISE
1 | 2012-09-01 00:00:00 | CHARANJIT | 001 | CHARANJIT | 001 | 2012-09-01 00:00:00 | 12 | SB-103 | 103 | [NAME] HOWLADER | 700 | 800 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 12 |  |  |  |  |  |  | 3 | 9 | 0 | 49 | 12
2 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 10 | SB-113 | 113 | LALCHAND AMARNATH | 800 | 1000 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 0 | 45 | 22
3 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 14 | SB-117 | 117 | NABAB ALI [NAME] | 800 | 1700 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 0 | 116 | 36
4 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 12 | SB-118 | 118 | MOHAMMAD NASER NUR MOHD PATWARI | 700 | 800 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 0 | 49 | 48
5 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 10 | SB-122 | 122 | PRUDIP NONI SARKER | 700 | 800 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 0 | 36 | 58
6 | 1 |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 14 | SB-127 | 127 | KATRAVATH RAVI SEETYA | 1000 | 2700 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 0 | 178 | 72
7 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 12 | SB-130 | 130 | SAPHI AHAMED ABDUL RAHIMAN | 3500 | 10000 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 0 | 544 | 84
8 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 10 | SB-131 | 131 | SAMIM ABDUL LATIF HOWLADE | 700 | 1000 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 0 | 45 | 94
9 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 14 | SB-142 | 142 | [NAME] NEWAZ | 5000 | 5050 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 0 | 399 | 108
10 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 12 | SB-145 | 145 | DAVINDER SINGH GURBACHAN SINGH | 800 | 1000 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 0 | 60 | 120
11 |  |  |  | CHARANJIT | 001 | 2012-09-01 00:00:00 | 10 | SB-147 | 147 | SHAH [NAME] | 800 | 1000 | BIS/001/12 | AHMAD MOHAMMAD AL NAQBI | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 0 | 45 | 130
12 | 2012-09-02 00:00:00 | MANIKANDAN [NAME] | 003 | MANIKANDAN [NAME] | 003 | 2012-09-02 00:00:00 | 14 | SB-149 | 149 | MANIKANDAN [NAME] | 700 | 800 | BIS/003/12 | OMAR AHMAD BASLEEB | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 0 | 61 | 14
13 |  |  |  | MANIKANDAN [NAME] | 003 | 2012-09-02 00:00:00 | 12 | SB-151 | 151 | PANDISELVAM CHINNATH THAMBI | 800 | 1000 | BIS/003/12 | OMAR AHMAD BASLEEB | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 0 | 60 | 26
14 |  |  |  | MANIKANDAN [NAME] | 003 | 2012-09-02 00:00:00 | 10 | SB-152 | 152 | SAFIQUR [NAME] | 800 | 900 | BIS/003/12 | OMAR AHMAD BASLEEB | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 0 | 41 | 36
15 |  |  |  | MANIKANDAN [NAME] | 003 | 2012-09-02 00:00:00 | 14 | SB-153 | 153 | [NAME] | 800 | 900 | BIS/003/12 | OMAR AHMAD BASLEEB | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 0 | 69 | 50
16 | 2012-09-03 00:00:00 |  |  | MANIKANDAN [NAME] | 003 | 2012-09-02 00:00:00 | 12 | SB-154 | 154 | SAEED UL HAQ SO ABDUL MALIK | 1700 | 2100 | BIS/003/12 | OMAR AHMAD BASLEEB | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 0 | 126 | 62