Control Sheet Automated.xls
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
A
1
User guide for Excel Control Sheet
2
3
4
Background information
5
Short descriptions of the fields in the Data sheet can be found by selecting the fields in the header (Row 6).
6
The Statistics sheet updates automatically as data is entered in the Data sheet.
7
The Pivot sheet updates after refreshing data in the pivot wizard or upon opening of the file.
8
The statistics (counts) in Row 9 in the data sheet is updated automatically.
9
The Data sheet has 9,999 rows. In case this is not sufficient a new sheet should be created.
10
11
12
Data Entry instruction
13
1. Use the "Data" sheet for data entry of Control Sheet information.
14
2. Start data entry from Row 12. One row represents one family. Always use tab to move between columns.
15
3. Grey Columns: are for Registration Date, Name of Clerk, Location and Serial Number of the paper Control Sheet (if used). This information is found on top of the paper Control Sheet. Type in once and copy down for all households registered on one control sheet.
16
4. Blue Columns: is for the household information. Household total is the total of the numbers typed in for the age/ gender breakdown. After data entry of each family, confirm that the total matches the written total on the hard copy Control Sheet.
17
5. Special needs are recorded by putting a cross against the needs. The description of the needs will show when you are in the column.
18
6. Remarks is a free text field used to record any comments on the household.
19
20
21
TIPs
22
Use the tab to go to next field, this will skip the calculated fields.
23
Go to print preview, before printing the Excel Sheet. Make sure you specify the pages you want to print. Otherwise you will print 176 pages!!
24
25
26
Validation of fields in the Data sheet
27
There are various types of validation rules in the Data sheet:
28
29
Date
30
Format is dd-mmm-yyyy, but can be entered in various ways. The date must be between 01-Jan-2005 and todays date.
31
If there are problems with the date format, make sure the settings of the computer is e.g. English (United Kingdom) or French (France).
32
Some problems can occur if the date format of the computer is set to e.g. English (American) with another date format.
33
This is changed under: Start/Settings/Control Panel/Regional and Language Options
34
35
Card no.
36
If the same card number is entered more than once, the card numbers will be marked with red font.
37
Identify and correct the multiple entries.
38
39
Household Totals
40
These are calculated fields. Use the tab to jump over these fields when entering data.
41
42
Children, Adults, Elderly
43
Enter the family composition according to sex and age. The fields only accepts numbers between 0 and 20.
44
45
Special Needs Type
46
If a family has special needs mark the special needs types by entering an "x" in the appropriate boxes.
47
48
SP Needs
49
This is a calculated field showing "yes" if a household has any special needs marked in the Special Needs Type.
50
51
Remarks
52
This is a text field without validation.
53
54
The sheets are protected to avoid changing formulas, etc. There is no password to unprotect.
55
56
For further assistance, please contact FICSS at HQ.
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
Loading...