Employee Summary sheet

[afshan abdul wahid]

I have a sheet of daily manpower attendance. I need to prepare summary sheet with criteria of

1. Category (category to be listed in the summary sheet and mentioned in the attendance sheet)

2. Date (1 cell in summary sheet will be denoting date; so when I change this date, automatically the count of different categories should change, accordingly).

3. Count if , value in array is "W" as working ; "V" as vacation ; "A" as absent

MANPOWER ATTENDANCE REPORT

Sl.No.

Name of Employee

Actual Trade

Reporting As

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

A

Staff (Indirect)

1

Emp 1

Draftsman

Draftsman

W

W

W

W

W

W

W

V

V

V

V

V

V

V

V

V

V

2

Emp 2

General Foreman

Foreman

W

W

3

Emp 3

Surveyor

Land Surveyor

W

W

W

W

W

W

W

W

V

V

V

V

V

V

V

V

V

4

Emp 4

Site Personnel Coordinator

Govt. & PR Officer

W

W

W

W

W

W

W

W

W

W

W

W

W

W

W

W

W

5

Emp 5

Chief Surveyor

Land Surveyor

W

W

W

W

W

W

W

W

V

V

V

V

V

V

V

V

V

<tbody>
</tbody>

Summary Sheet Format (as Below):

MANPOWER LIST				19-Aug-18
Manpower Details	Working	Vacation	Absent	Total
Project Manager	0
Technical Manager
Construction Manager
Planning Engineer				0
Site Engineer
QA/QC Engineer
Draftsman
Foreman
Equipment Coordinator
Govt. & PR Officer
Admin Support Officer
Document Controller
Secretary
Translator
IT Officer
Project Coordinator
Mechanical Technician
Sr. Surveyor
Land Surveyor
Safety Engineer
Safety Officer

<colgroup><col><col span="4"></colgroup><tbody>
</tbody>