Spreadsheet: 99766d1298339400-convert-non-data-base-to-data-base-format-using-formula-emp-unit2-test2
Sheet: TIME SHEET

S.NO | EMP ID | EMP NAME | DATE | PARTICULAR | PRESENT/ABSENT | TIME
1 | 1001 | THOMAS | 2011-01-01 06:45:00 | TIME IN | P | 0.0126714898815069
2 | 1001 | THOMAS | 2011-01-02 06:45:00 | TIME IN | WO | 0.008199920412249232
3 | 1001 | THOMAS | 2011-01-03 06:45:00 | TIME IN | P | 0.009929872842644995
4 | 1001 | THOMAS | 2011-01-04 06:45:00 | TIME IN | P | 0.01052481295154845
5 | 1001 | THOMAS | 2011-01-05 06:45:00 | TIME IN | P | 0.009542175390187084
6 | 1001 | THOMAS | 2011-01-06 06:45:00 | TIME IN | P | 0.009550675797149195
7 | 1001 | THOMAS | 2011-01-07 06:45:00 | TIME IN | P | 0.01605127186799555
8 | 1001 | THOMAS | 2011-01-08 06:45:00 | TIME IN | P | 0.003224580413993437
9 | 1001 | THOMAS | 2011-01-09 06:45:00 | TIME IN | WO | 0.01301844363583513
10 | 1002 | GREIGE | 2011-01-01 06:45:00 | TIME IN | P | 0.01653883678905349
11 | 1002 | GREIGE | 2011-01-02 06:45:00 | TIME IN | WO | 0.009437028778864844
12 | 1002 | GREIGE | 2011-01-03 06:45:00 | TIME IN | P | 0.01312641432728815
13 | 1002 | GREIGE | 2011-01-04 06:45:00 | TIME IN | P | 0.01100082884101592
14 | 1002 | GREIGE | 2011-01-05 06:45:00 | TIME IN | A | 0.003561469551614496
15 | 1002 | GREIGE | 2011-01-06 06:45:00 | TIME IN | P | 0.01377679613205871
16 | 1002 | GREIGE | 2011-01-07 06:45:00 | TIME IN | P | 0.002878112765442067
17 | 1002 | GREIGE | 2011-01-08 06:45:00 | TIME IN | P | 0.00891647946674895
18 | 1002 | GREIGE | 2011-01-09 06:45:00 | TIME IN | WO | 0.008438334197387721
41 | 1003 | [NAME] | 2011-01-01 06:45:00 | TIME IN | P | 0.01284433611823933
42 | 1003 | [NAME] | 2011-01-02 06:45:00 | TIME IN | WO | 0.002099609568785543
43 | 1003 | [NAME] | 2011-01-03 06:45:00 | TIME IN | P | 0.01258398325932039
44 | 1003 | [NAME] | 2011-01-04 06:45:00 | TIME IN | P | 0.0130907477400971
45 | 1003 | [NAME] | 2011-01-05 06:45:00 | TIME IN | P | 0.01203211623722208
46 | 1003 | [NAME] | 2011-01-06 06:45:00 | TIME IN | P | 0.009148053893329103
47 | 1003 | [NAME] | 2011-01-07 06:45:00 | TIME IN | P | 0.01276199352274459
48 | 1003 | [NAME] | 2011-01-08 06:45:00 | TIME IN | P | 0.003693462113314926
49 | 1003 | [NAME] | 2011-01-09 06:45:00 | TIME IN | WO | 0.01699704524460062
72 | 1004 | FERNANDES | 2011-01-01 06:45:00 | TIME IN | P | 0.004951238807713223
73 | 1004 | FERNANDES | 2011-01-02 06:45:00 | TIME IN | WO | 0.01297168386088481
74 | 1004 | FERNANDES | 2011-01-03 06:45:00 | TIME IN | P | 0.01730552640246884
75 | 1004 | FERNANDES | 2011-01-04 06:45:00 | TIME IN | P | 0.004480732137825857
76 | 1004 | FERNANDES | 2011-01-05 06:45:00 | TIME IN | P | 0.009607081893362977
77 | 1004 | FERNANDES | 2011-01-06 06:45:00 | TIME IN | A | 0.0007118419262998139
78 | 1004 | FERNANDES | 2011-01-07 06:45:00 | TIME IN | P | 0.0007459768724708896
79 | 1004 | FERNANDES | 2011-01-08 06:45:00 | TIME IN | P | 0.004502180270938692
80 | 1004 | FERNANDES | 2011-01-09 06:45:00 | TIME IN | WO | 0.0121604555407847
103 | 1005 | MEGAN | 2011-01-01 06:45:00 | TIME IN | P | 0.01714391527541819
104 | 1005 | MEGAN | 2011-01-02 06:45:00 | TIME IN | WO | 0.01019501546369724
105 | 1005 | MEGAN | 2011-01-03 06:45:00 | TIME IN | P | 0.01776260041670394
106 | 1005 | MEGAN | 2011-01-04 06:45:00 | TIME IN | P | 0.004480421764794982
107 | 1005 | MEGAN | 2011-01-05 06:45:00 | TIME IN | P | 0.0146698470078245
108 | 1005 | MEGAN | 2011-01-06 06:45:00 | TIME IN | P | 0.003054063223022183
109 | 1005 | MEGAN | 2011-01-07 06:45:00 | TIME IN | P | 0.01831042548394549
110 | 1005 | MEGAN | 2011-01-08 06:45:00 | TIME IN | A | 0.007605701874889334
111 | 1005 | MEGAN | 2011-01-09 06:45:00 | TIME IN | WO | 0.01705703133924135
134 | 1006 | BRIGITTE | 2011-01-01 06:45:00 | TIME IN | P | 0.01887049692969629
135 | 1006 | BRIGITTE | 2011-01-02 06:45:00 | TIME IN | WO | 0.007552349347031675
136 | 1006 | BRIGITTE | 2011-01-03 06:45:00 | TIME IN | P | 0.001970476876195319
137 | 1006 | BRIGITTE | 2011-01-04 06:45:00 | TIME IN | P | 0.01541359839822242
138 | 1006 | BRIGITTE | 2011-01-05 06:45:00 | TIME IN | P | 0.009748665200925362
139 | 1006 | BRIGITTE | 2011-01-06 06:45:00 | TIME IN | P | 0.01158062657575453
140 | 1006 | BRIGITTE | 2011-01-07 06:45:00 | TIME IN | P | 0.01571785705921771
141 | 1006 | BRIGITTE | 2011-01-08 06:45:00 | TIME IN | P | 0.001837332875864426
142 | 1006 | BRIGITTE | 2011-01-09 06:45:00 | TIME IN | WO | 0.01192094070184827
165 | 1007 | DARREN | 2011-01-01 06:45:00 | TIME IN | P | 0.001010413217192138
166 | 1007 | DARREN | 2011-01-02 06:45:00 | TIME IN | WO | 0.01421265175863956
167 | 1007 | DARREN | 2011-01-03 06:45:00 | TIME IN | P | 0.01049031638518506
168 | 1007 | DARREN | 2011-01-04 06:45:00 | TIME IN | A | 0.00225781512047317
169 | 1007 | DARREN | 2011-01-05 06:45:00 | TIME IN | P | 0.001811433114858105
170 | 1007 | DARREN | 2011-01-06 06:45:00 | TIME IN | P | 0.004084995498038162
171 | 1007 | DARREN | 2011-01-07 06:45:00 | TIME IN | P | 0.006999929912257136
172 | 1007 | DARREN | 2011-01-08 06:45:00 | TIME IN | P | 0.006353789269860683
173 | 1007 | DARREN | 2011-01-09 06:45:00 | TIME IN | WO | 0.01495455380241506
196 | 1008 | TOWEN | 2011-01-01 06:45:00 | TIME IN | P | 0.003510829786852868
197 | 1008 | TOWEN | 2011-01-02 06:45:00 | TIME IN | WO | 0.0163485113034765
198 | 1008 | TOWEN | 2011-01-03 06:45:00 | TIME IN | P | 0.01498352602359421
199 | 1008 | TOWEN | 2011-01-04 06:45:00 | TIME IN | P | 0.004409593946316937
200 | 1008 | TOWEN | 2011-01-05 06:45:00 | TIME IN | P | 0.005388842666946884
201 | 1008 | TOWEN | 2011-01-06 06:45:00 | TIME IN | P | 0.01409515134690138
202 | 1008 | TOWEN | 2011-01-07 06:45:00 | TIME IN | P | 0.01885950675866395
203 | 1008 | TOWEN | 2011-01-08 06:45:00 | TIME IN | P | 0.01085123497324415
204 | 1008 | TOWEN | 2011-01-09 06:45:00 | TIME IN | WO | 0.005451196819242352
227 | 1009 | MORGAN | 2011-01-01 06:45:00 | TIME IN | P | 0.001272516519778339
228 | 1009 | MORGAN | 2011-01-02 06:45:00 | TIME IN | WO | 0.01016260433583382
229 | 1009 | MORGAN | 2011-01-03 06:45:00 | TIME IN | P | 0.01541863336136824
230 | 1009 | MORGAN | 2011-01-04 06:45:00 | TIME IN | P | 0.01802800441681091
231 | 1009 | MORGAN | 2011-01-05 06:45:00 | TIME IN | P | 0.003458669991809398
232 | 1009 | MORGAN | 2011-01-06 06:45:00 | TIME IN | P | 0.01487971088135768
233 | 1009 | MORGAN | 2011-01-07 06:45:00 | TIME IN | P | 0.01204521318159549
234 | 1009 | MORGAN | 2011-01-08 06:45:00 | TIME IN | P | 0.01289883649201589
235 | 1009 | MORGAN | 2011-01-09 06:45:00 | TIME IN | WO | 0.009285960546827555
258 | 1010 | STANLY | 2011-01-01 06:45:00 | TIME IN | P | 0.008679096722280743
259 | 1010 | STANLY | 2011-01-02 06:45:00 | TIME IN | WO | 0.01651938110263486
260 | 1010 | STANLY | 2011-01-03 06:45:00 | TIME IN | P | 0.00833338725072629
261 | 1010 | STANLY | 2011-01-04 06:45:00 | TIME IN | P | 0.01827046276915685
262 | 1010 | STANLY | 2011-01-05 06:45:00 | TIME IN | P | 0.005317021782212984
263 | 1010 | STANLY | 2011-01-06 06:45:00 | TIME IN | P | 0.01720238862926351
264 | 1010 | STANLY | 2011-01-07 06:45:00 | TIME IN | P | 0.01241848380065384
265 | 1010 | STANLY | 2011-01-08 06:45:00 | TIME IN | P | 0.003769507808841968
266 | 1010 | STANLY | 2011-01-09 06:45:00 | TIME IN | WO | 0.01393652922049093
 |  |  |  |  |  | 0.01590365796368749
 |  |  |  |  |  | 0.0178831035787232
 |  |  |  |  |  | 0.01128083966791924
 |  |  |  |  |  | 0.01694363964844925
 |  |  |  |  |  | 0.01154195444059078