A NEAT LIST: Search and Location tool (live)

	A	B	C
1	Welcome to A NEAT LIST: search and Location Tool
2
3	Purpose:	The Aotearoa National Essential Antimicrobial Therapeutics (A NEAT) List has been developed by the APhID group with the aim to support equitable access to antimicrobials around the country.
4		This tool (on google sheets) has been developed to help direct you to hospitals that are likely to hold the antimicrobial you are looking for.
5		We recommend reaching out to hospitals that hold the antimicrobial(s) that fall within your region first.
6		Please read the full "A NEAT LIST" guideline for further information inregards to antimicrobial categories and how "regions" are defined.
7
8
9	Regions:	Northern - Whangarei, Waitemata, Auckland, Counties
10		Midland - Waikato, Taranaki, Lakes, Bay of Plenty, Tairāwhiti
11		Central - Hawkes Bay, MidCentral, Whanganui, Wairapa, Capital, Coast and Hutt Valley
12		South Island (upper) - Nelson Marlborough, West Coast, Canterbury
13		South Island (lower) - South Canterbury, Southern
14
15
16	How to use the Search tool?	Step 1)	Use the log in provided (otherwise the search function won't run properly)
17		Step 2)	Type full (or partial) drug name into the white box (cell C3)
18		Step 3)	Click the green cell
19		Step 4)	Click on the 'Search' button to run the list
20		Step 5)	Check the box of the abx you want to find, location will appear on the right.
21
22
23
24	Troubleshooting Tips	Q:	Can't seem to get the search function to work?
25		A:	Try a hard refresh (CTRL + F5)
26
27		Q:	Search function runs but nothing happens?
28		A:	Make sure you are logged in correctly. If you are on your own google account, it won't work.
29
30		Q:	Google is asking for "Authorisation" to run the script attached to the document
31		A:	Read "Using A NEAT LIST for the first time" document for more information
32
33		Q:	Opps, I deleted or broke the sheet....
34		A:	This sheet is not locked, so if you have accidently broken or deleted it, please let me know
35			If there are any errors, amendents or questions, email cli@adhb.govt.nz
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
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