Background
The original sample Excel workbook provided by Bonnie included 12 sheets that require data entry.
The copy available above is an sample Q3 report submitted by VIHA.
The report data is organized in three colored sections besides the facility information:
Detail each section
Index | Table | Session | Field Name | Excel position or Column | Field Type int/ float / string | Calculated Field (specify formula/calculation) | Dependencies (Internal Sources) | Notes |
---|---|---|---|---|---|---|---|---|
1 | Facility Information | Facility Information | Facility Name | |||||
2 | Facility Information | Facility Information | Address | |||||
3 | Facility Information | Facility Information | City | |||||
4 | Facility Information | Facility Information | Postal Code | |||||
5 | Facility Information | Facility Information | Telephone | |||||
6 | Facility Information | Facility Information | FAX | |||||
7 | Facility Information | Facility Information | Facility's website Address | |||||
8 | Facility Information | Facility Information | Site ID # | |||||
9 | Facility Information | Facility Information | Program Type | |||||
10 | Facility Information | Facility Information | Ownership Type | |||||
11 | Facility Information | Facility Information | Legislation | |||||
12 | Facility Information | Facility Information | Accreditation Body | |||||
13 | Facility Information | Facility Information | Accreditation Date | |||||
14 | Facility Information | Facility Information | Accreditation Expiry Date | |||||
15 | Facility Information | Facility Information | Health Authority | |||||
16 | Facility Information | Facility Information | Local Health Authoriy | |||||
17 | Facility Information | |||||||
18 | Facility Information | |||||||
19 | Facility Information | |||||||
20 | ||||||||
21 | ||||||||
22 | ||||||||
23 | ||||||||
24 | ||||||||
25 | ||||||||
26 | ||||||||
27 | ||||||||
28 | ||||||||
29 | ||||||||
30 | ||||||||
31 | ||||||||
32 | ||||||||
33 | ||||||||
34 | ||||||||
35 | ||||||||
36 | ||||||||
37 | ||||||||
38 | ||||||||
39 | ||||||||
40 | ||||||||
41 | ||||||||
42 | ||||||||
43 | ||||||||
44 | ||||||||
45 | ||||||||
46 | ||||||||
47 | ||||||||
48 | ||||||||
49 | ||||||||
50 | ||||||||
51 | ||||||||
52 | ||||||||
53 | ||||||||
54 | ||||||||
55 | ||||||||
56 | ||||||||
57 | ||||||||
58 | ||||||||
59 | ||||||||
60 | ||||||||
61 | ||||||||
62 | ||||||||
63 | ||||||||
64 | ||||||||
65 | ||||||||
66 | ||||||||
67 |