← Back to branch summary

~mortenoh/+junk/dhis2-detailed-import-export

« back to all changes in this revision

Viewing changes to local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/Jharkhand/jtb-p.jsp

  • Committer: larshelge at gmail
  • Date: 2009-03-03 16:46:36 UTC
  • Revision ID: larshelge@gmail.com-20090303164636-2sjlrquo7ib1gf7r
Initial check-in

Show diffs side-by-side

added added

removed removed

Lines of Context:
local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/Jharkhand/jtb-p.jsp
 
1
 
 
2
<%@ page import="java.sql.*" %>
 
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
4
 
 
5
<%@ page session="true"%>
 
6
 
 
7
<%
 
8
    Connection con=null;
 
9
            
 
10
    // For finding organisationunit name of selected Orgunit based on Orgunit id
 
11
    Statement st1=null;
 
12
    ResultSet rs1=null;
 
13
      
 
14
    // For finding start date of selected period based on period id
 
15
    Statement st2=null;
 
16
    ResultSet rs2=null;
 
17
    
 
18
    //For finding monthly values
 
19
    Statement st3=null;
 
20
    ResultSet rs3=null;
 
21
    
 
22
    //For finding cumulative values
 
23
    Statement st4=null;
 
24
    ResultSet rs4=null;
 
25
       
 
26
    
 
27
    //For finding district name and id
 
28
    Statement st7=null;
 
29
    ResultSet rs7=null;
 
30
    
 
31
    //For finding state name and id
 
32
    Statement st8=null;
 
33
    ResultSet rs8=null;
 
34
    
 
35
    String userName = "dhis";      
 
36
    String password = "";           
 
37
    String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
 
38
          
 
39
 
 
40
        OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
41
 
 
42
        String selectedId = (String) stack.findValue( "orgUnitId" );
 
43
        int selectedOrgUnitID = Integer.parseInt( selectedId );
 
44
        
 
45
//      String selectedPeriodId = (String) stack.findValue( "periodSelect" );
 
46
//      int selectedDataPeriodID =  Integer.parseInt( selectedPeriodId );
 
47
 
 
48
        String startingDate  = (String) stack.findValue( "startingPeriod" );
 
49
        String endingDate  = (String) stack.findValue( "endingPeriod" );
 
50
 
 
51
      
 
52
        String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
53
        int periodTypeID = Integer.parseInt( monthlyPeriodId );
 
54
 
 
55
      
 
56
        String selectedOrgUnitName = "";        
 
57
        String selectedDataPeriodStartDate = "";
 
58
                        
 
59
        String monthlyDataElements[] = {
 
60
                                                                                        // Medications  - Category- 1
 
61
                                                                                        "TB_DE1","TB_DE2","TB_DE3",
 
62
 
 
63
                                                                                        // Medications  - Category- 2
 
64
                                                                                        "TB_DE4","TB_DE5","TB_DE6",
 
65
 
 
66
                                                                                        // Medications  - Category- 3                                                                                   
 
67
                                                                                        "TB_DE7","TB_DE8","TB_DE9",
 
68
                                                                                        
 
69
                                                                                        // Medications  - Pouches of Blister Strips
 
70
                                                                                        "TB_DE10","TB_DE11","TB_DE12","TB_DE13","TB_DE14",
 
71
                                                                                        
 
72
                                                                                        // Medications  - INH-300 mg
 
73
                                                                                        "TB_DE15","TB_DE16","TB_DE17","TB_DE18","TB_DE19",
 
74
                                                                                        
 
75
                                                                                        // Medications  - INH-100 mg
 
76
                                                                                        "TB_DE20","TB_DE21","TB_DE22","TB_DE23","TB_DE24",
 
77
                                                                                        
 
78
                                                                                        // Medications  - Streptomycin 0.75 g
 
79
                                                                                        "TB_DE25","TB_DE26","TB_DE27","TB_DE28","TB_DE29",
 
80
                                                                                        
 
81
                                                                                        // Medications  - Rifampicin 150 mg
 
82
                                                                                        "TB_DE30","TB_DE31","TB_DE32","TB_DE33","TB_DE34",
 
83
                                                                                        
 
84
                                                                                        // Medications  - Pyrazinamide
 
85
                                                                                        "TB_DE35","TB_DE36","TB_DE37","TB_DE38","TB_DE39",
 
86
                                                                                        
 
87
                                                                                        // Medications  - Ethambutol 800 mg     
 
88
                                                                                        "TB_DE40","TB_DE41","TB_DE42","TB_DE43","TB_DE44",
 
89
                                                                                        
 
90
                                                                                        // Staff Position and Training - Medical Officer
 
91
                                                                                        "TB_DE45","TB_DE46","TB_DE47",
 
92
                                                                                        
 
93
                                                                                        // Staff Position and Training - Laboratory Technician
 
94
                                                                                        "TB_DE48","TB_DE49","TB_DE50",
 
95
                                                                                        
 
96
                                                                                        // Staff Position and Training - Pharmacist
 
97
                                                                                        "TB_DE51","TB_DE52","TB_DE53",
 
98
                                                                                        
 
99
                                                                                        // Staff Position and Training - MPH Supervisors
 
100
                                                                                        "TB_DE54","TB_DE55","TB_DE56",
 
101
                                                                                        
 
102
                                                                                        // Staff Position and Training - Multipurpose Health Workers
 
103
                                                                                        "TB_DE57","TB_DE58","TB_DE59",
 
104
                                                                                        
 
105
                                                                                        // Staff Position and Training - TBHV
 
106
                                                                                        "TB_DE60","TB_DE61","TB_DE62",
 
107
                                                                                        
 
108
                                                                                        // Staff Position and Training - STLS
 
109
                                                                                        "TB_DE63","TB_DE64","TB_DE65",
 
110
                                                                                        
 
111
                                                                                        // Referral Activities
 
112
                                                                                        "TB_DE66","TB_DE67",
 
113
                                                                                        
 
114
                                                                                        // Microscopy Activities
 
115
                                                                                        "TB_DE68","TB_DE69","TB_DE70","TB_DE71", 
 
116
                                                                                        
 
117
                                                                                        // Treatment Initiation
 
118
                                                                                        "TB_DE72","TB_DE73","TB_DE74","TB_DE75",
 
119
                                                                                        
 
120
                                                                                        "TB_DE76","TB_DE77",
 
121
                                                                                        
 
122
                                                                                        // Consumables - Sputum Containers
 
123
                                                                                        "TB_DE78","TB_DE79","TB_DE80","TB_DE81","TB_DE82",
 
124
                                                                                        
 
125
                                                                                        // Consumables - Slides
 
126
                                                                                        "TB_DE83","TB_DE84","TB_DE85","TB_DE86","TB_DE87",
 
127
                                                                                        
 
128
                                                                                        // Consumables - Carbon Fuchsin
 
129
                                                                                        "TB_DE88","TB_DE89","TB_DE90","TB_DE91","TB_DE92",                                                                                      
 
130
                                                                                        
 
131
                                                                                        // Consumables - Methylene Blue
 
132
                                                                                        "TB_DE93","TB_DE94","TB_DE95","TB_DE96","TB_DE97",
 
133
                                                                                        
 
134
                                                                                        // Consumables - Sulphuric Acid
 
135
                                                                                        "TB_DE98","TB_DE99","TB_DE100","TB_DE101","TB_DE102",
 
136
                                                                                        
 
137
                                                                                        // Consumables - Phenol
 
138
                                                                                        "TB_DE103","TB_DE104","TB_DE105","TB_DE106","TB_DE107",
 
139
                                                                                        
 
140
                                                                                        // Consumables - Xylene
 
141
                                                                                        "TB_DE108","TB_DE109","TB_DE110","TB_DE111","TB_DE112",
 
142
                                                                                        
 
143
                                                                                        // Consumables - Immersion Oil
 
144
                                                                                        "TB_DE113","TB_DE114","TB_DE115","TB_DE116","TB_DE117",
 
145
                                                                                        
 
146
                                                                                        // Consumables - Methylated Spirit
 
147
                                                                                        "TB_DE118","TB_DE119","TB_DE120","TB_DE121","TB_DE122",
 
148
                                                                                        
 
149
                                                                                        // Equipment in Place - Monocular Microscopes
 
150
                                                                                        "TB_DE123","TB_DE124","TB_DE125",
 
151
                                                                                        
 
152
                                                                                        // Equipment in Place - Binocular Microscopes
 
153
                                                                                        "TB_DE126","TB_DE127","TB_DE128"
 
154
                                                                                        
 
155
                                                                                        
 
156
 
 
157
                                                                                        
 
158
                                                                                };
 
159
                                        
 
160
          int monthlyValues[] = new int[monthlyDataElements.length+5];          
 
161
         
 
162
          
 
163
          int CHCID=0;
 
164
          int TalukID=0;
 
165
          int DistrictID=0;
 
166
          int StateID=0;
 
167
          
 
168
          String CHCName="";
 
169
          String TalukName = "";
 
170
          String  DistrictName = "";
 
171
          String StateName = "";
 
172
 
 
173
          int j=1;       
 
174
          int i=1;       
 
175
          int k=0;       
 
176
          int endcount = 0;
 
177
          int p = 0;     
 
178
          int q = 0;
 
179
        
 
180
          String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September",
 
181
                                                                        "October", "November", "December" };    
 
182
%>
 
183
 
 
184
<%
 
185
 
 
186
     try
 
187
      {
 
188
                Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
189
                con = DriverManager.getConnection (urlForConnection, userName, password);
 
190
        
 
191
                st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
192
                st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
193
                st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
194
                st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);            
 
195
                st7=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
196
                st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);    
 
197
                
 
198
                //rs1 = st1.executeQuery("select shortname from organisationunit  where id = "+selectedOrgUnitID);
 
199
                rs1 = st1.executeQuery("select shortname from organisationunit  where organisationunitid = "+selectedOrgUnitID);        
 
200
                if(rs1.next())        {  selectedOrgUnitName = rs1.getString(1);      }
 
201
                
 
202
//              rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
 
203
//                      if(rs2.next())    {  selectedDataPeriodStartDate =  rs2.getDate(1).toString();  }                 
 
204
 
 
205
                        selectedDataPeriodStartDate = startingDate;
 
206
                                                
 
207
                        //rs7=st7.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
208
                        rs7=st7.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");  
 
209
                        if(rs7.next())  { DistrictID = rs7.getInt(1);DistrictName = rs7.getString(2);  } 
 
210
                        else  {  DistrictID = 0; DistrictName = "";  } 
 
211
 
 
212
                        //rs8=st8.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+DistrictID+")");
 
213
                        rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+DistrictID+")"); 
 
214
                        if(rs8.next())  { StateID = rs8.getInt(1);StateName = rs8.getString(2);  } 
 
215
                        else  {  StateID = 0; StateName = "";  } 
 
216
 
 
217
      } //try block end
 
218
      catch(Exception e)  { out.println(e.getMessage());  }
 
219
      
 
220
     String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
 
221
     int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
222
     int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
223
     int tempForYear = 0;
 
224
     if(tempForMonth1 < 4){   tempForYear = lastYear;  }
 
225
     else  {   tempForYear = lastYear + 1;      }
 
226
     String curYearStart=tempForYear+"-04-01";
 
227
                
 
228
    try
 
229
     {     
 
230
        int count = monthlyDataElements.length;
 
231
        for(i=0;i<count;i++)      
 
232
                        {         
 
233
                                //rs3 = st3.executeQuery("SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period  in (select id from period where startdate between '"+startingDate+"' and '"+startingDate+"')  AND datavalue.source ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[i]+"'");
 
234
                                rs3 = st3.executeQuery("SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid  in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"')  AND datavalue.sourceid ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[i]+"'");                                          
 
235
                        if(rs3.next())          {  monthlyValues[i] =  rs3.getInt(1);   }                                                                       
 
236
                        }
 
237
        } // try block end
 
238
    catch(Exception e)  { out.println(e.getMessage());  }
 
239
    finally
 
240
       {
 
241
                        try
 
242
                        {
 
243
                                if(rs1!=null)  rs1.close();             if(st1!=null)  st1.close();
 
244
                                if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();                             
 
245
                                if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close();                             
 
246
                                if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close();
 
247
                        
 
248
                                if(rs7!=null)  rs7.close();             if(st7!=null)  st7.close();
 
249
                                if(rs8!=null)  rs8.close();             if(st8!=null)  st8.close();
 
250
                                
 
251
                                if(con!=null)  con.close(); 
 
252
                        }
 
253
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
254
       } // finally block end   
 
255
       
 
256
  %>
 
257
 
 
258
 
 
259
<html>
 
260
        <head>
 
261
                <title>REVISED NATIONAL TUBERCULOSIS CONTROL PROGRAMME</title>          
 
262
        </head>
 
263
        <body >
 
264
          <center> 
 
265
            <FONT face="Arial" size="3"><b><u>REVISED NATIONAL TUBERCULOSIS CONTROL PROGRAMME</u>
 
266
                <br>Monthly Report on Logistics and Microscopy
 
267
                <br><br>Peripheral Health Institution Level</b></font>
 
268
         </center>   
 
269
            <br><FONT face="Arial" size="2"><i>Note: All PHCs/CHCs/Referral Hospitals Major Hospitals/Specially Clinics/TB Hospitals/Medical Colleges to submit their monthly reports in this format.</i>
 
270
            <br><br>Name of Peripheral Health Institution :&nbsp;&nbsp;&nbsp;<%=selectedOrgUnitName%>
 
271
            
 
272
            <table cellpadding="0" cellspacing="0" bgcolor="ffffff" align="left" style="border-style:solid; border-width:0; border-collapse: collapse; padding: 0; position:relative; top:10" bordercolor="#ffffff" width="50%"  border="0">
 
273
                        <tr style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding: 0" bordercolor="#111111" width="100%">
 
274
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111"  height="23">
 
275
                                <font face="Arial" size="2">TU :&nbsp;&nbsp;</font>
 
276
                                </td>
 
277
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111"  height="23">
 
278
                                <font face="Arial" size="2">DISTRICT :&nbsp;&nbsp;<%=DistrictName%></font>
 
279
                                </td>   
 
280
                        </tr>
 
281
                        <tr>
 
282
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111" height="19">
 
283
                                <font face="Arial" size="2">Month : &nbsp;&nbsp;<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%></font>
 
284
                                </td>
 
285
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111"  height="19">
 
286
                                <font face="Arial" size="2">Year : &nbsp;&nbsp;<%=partsOfDataPeriodStartDate[0]%></font>
 
287
                                </td>
 
288
                </tr>                           
 
289
                </table>  
 
290
            
 
291
                <br><br><br><br><br>
 
292
                <b>Medications</b></font><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
293
        <tr>
 
294
          <td width="20%" align="center"><FONT face="Arial" size="2"><b>Item</b></font></td>
 
295
          <td width="15%" align="center"><FONT face="Arial" size="2"><b>Unit of Measurement</b></font></td>
 
296
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on first day of month<br>(a)</b></font></td>
 
297
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock received during month<br>(b)</b></font></td>
 
298
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Patients initiated on treatment<br>(c)</b></font></td>
 
299
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on last day of month<br>(d) = a+b+c</b></font></td>
 
300
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Quantity Requested<p>(e) = (cx2)-d</b></font></td>
 
301
        </tr>
 
302
        <tr>
 
303
          <td width="20%"><FONT face="Arial" size="2">Category I</font></td>
 
304
          <td width="15%"><FONT face="Arial" size="2">Boxes</font></td>
 
305
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[0]%></font>&nbsp;</td>
 
306
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[1]%></font>&nbsp;</td>
 
307
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[2]%></font>&nbsp;</td>
 
308
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[0]+monthlyValues[1]-monthlyValues[2])%></font>&nbsp;</td>
 
309
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=((monthlyValues[2]*2)-(monthlyValues[0]+monthlyValues[1]-monthlyValues[2]))%></font>&nbsp;</td>
 
310
        </tr>
 
311
        <tr>
 
312
          <td width="20%"><FONT face="Arial" size="2">Category II</font></td>
 
313
          <td width="15%"><FONT face="Arial" size="2">Boxes</font></td>
 
314
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[3]%></font>&nbsp;</td>
 
315
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[4]%></font>&nbsp;</td>
 
316
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[5]%></font>&nbsp;</td>
 
317
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[3]+monthlyValues[4]-monthlyValues[5])%></font>&nbsp;</td>
 
318
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=((monthlyValues[5]*2)-(monthlyValues[3]+monthlyValues[4]-monthlyValues[5]))%></font>&nbsp;</td>
 
319
        </tr>
 
320
        <tr>
 
321
          <td width="20%"><FONT face="Arial" size="2">Category III</font></td>
 
322
          <td width="15%"><FONT face="Arial" size="2">Boxes</font></td>
 
323
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[6]%></font>&nbsp;</td>
 
324
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[7]%></font>&nbsp;</td>
 
325
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[8]%></font>&nbsp;</td>
 
326
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[6]+monthlyValues[7]-monthlyValues[8])%></font>&nbsp;</td>
 
327
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=((monthlyValues[8]*2)-(monthlyValues[6]+monthlyValues[7]-monthlyValues[8]))%></font>&nbsp;</td>
 
328
        </tr>
 
329
      </table>
 
330
      
 
331
      <br>
 
332
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
333
        <tr>
 
334
          <td width="20%" align="center"><FONT face="Arial" size="2"><b>Item</b></font></td>
 
335
          <td width="15%" align="center"><FONT face="Arial" size="2"><b>Unit of Measurement</b></font></td>
 
336
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on first day of month</b></font></td>
 
337
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock received during month</b></font></td>
 
338
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Consumption during month</b></font></td>
 
339
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on last day of month</b></font></td>
 
340
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Quantity Requested</b></font></td>
 
341
        </tr>
 
342
        <tr>
 
343
          <td width="20%"><FONT face="Arial" size="2">Pouches of blister strips for prolongation of intensive phase</font></td>
 
344
          <td width="15%"><FONT face="Arial" size="2">Pouches each with 12 blister strips</font></td>
 
345
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[9]%></font>&nbsp;</td>
 
346
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[10]%></font>&nbsp;</td>
 
347
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[11]%></font>&nbsp;</td>
 
348
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[12]%></font>&nbsp;</td>
 
349
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[13]%></font>&nbsp;</td>
 
350
        </tr>
 
351
        <tr>
 
352
          <td width="20%"><FONT face="Arial" size="2">INH 300 mg</font></td>
 
353
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
354
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[14]%></font>&nbsp;</td>
 
355
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[15]%></font>&nbsp;</td>
 
356
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[16]%></font>&nbsp;</td>
 
357
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[17]%></font>&nbsp;</td>
 
358
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[18]%></font>&nbsp;</td>
 
359
        </tr>
 
360
        <tr>
 
361
          <td width="20%"><FONT face="Arial" size="2">INH 100 mg</font></td>
 
362
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
363
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[19]%></font>&nbsp;</td>
 
364
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[20]%></font>&nbsp;</td>
 
365
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[21]%></font>&nbsp;</td>
 
366
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[22]%></font>&nbsp;</td>
 
367
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[23]%></font>&nbsp;</td>
 
368
        </tr>
 
369
        <tr>
 
370
          <td width="20%"><FONT face="Arial" size="2">Streptomycin 0.75g</font></td>
 
371
          <td width="15%"><FONT face="Arial" size="2">Vials</font></td>
 
372
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[24]%></font>&nbsp;</td>
 
373
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[25]%></font>&nbsp;</td>
 
374
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[26]%></font>&nbsp;</td>
 
375
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[27]%></font>&nbsp;</td>
 
376
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[28]%></font>&nbsp;</td>
 
377
        </tr>
 
378
        <tr>
 
379
          <td width="20%"><FONT face="Arial" size="2">Rifampicin 150 mg</font></td>
 
380
          <td width="15%"><FONT face="Arial" size="2">Capsules</font></td>
 
381
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[29]%></font>&nbsp;</td>
 
382
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[30]%></font>&nbsp;</td>
 
383
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[31]%></font>&nbsp;</td>
 
384
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[32]%></font>&nbsp;</td>
 
385
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[33]%></font>&nbsp;</td>
 
386
        </tr>
 
387
        <tr>
 
388
          <td width="20%"><FONT face="Arial" size="2">Pyrazinamide 500mg</font></td>
 
389
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
390
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[34]%></font>&nbsp;</td>
 
391
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[35]%></font>&nbsp;</td>
 
392
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[36]%></font>&nbsp;</td>
 
393
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[37]%></font>&nbsp;</td>
 
394
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[38]%></font>&nbsp;</td>
 
395
        </tr>
 
396
        <tr>
 
397
          <td width="20%"><FONT face="Arial" size="2">Ethambutol 800mg</font></td>
 
398
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
399
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[39]%></font>&nbsp;</td>
 
400
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[40]%></font>&nbsp;</td>
 
401
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[41]%></font>&nbsp;</td>
 
402
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[42]%></font>&nbsp;</td>
 
403
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[43]%></font>&nbsp;</td>
 
404
        </tr>
 
405
      </table>
 
406
      
 
407
      <br>
 
408
      <font face="Arial" size="2"><b>Staff Position and Training</b></font>
 
409
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
410
        <tr>
 
411
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>Category of staff</b></font></td>
 
412
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>Sanctioned</b></font></td>
 
413
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>In Place</b></font></td>
 
414
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>Trained in RNTCP</b></font></td>
 
415
        </tr>
 
416
        <tr>
 
417
          <td width="25%"><FONT face="Arial" size="2">Medical Officer</font></td>
 
418
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[44]%></font>&nbsp;</td>
 
419
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[45]%></font>&nbsp;</td>
 
420
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[46]%></font>&nbsp;</td>
 
421
        </tr>
 
422
        <tr>
 
423
          <td width="25%"><FONT face="Arial" size="2">Laboratory Techician</font></td>
 
424
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[47]%></font>&nbsp;</td>
 
425
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[48]%></font>&nbsp;</td>
 
426
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[49]%></font>&nbsp;</td>
 
427
        </tr>
 
428
        <tr>
 
429
          <td width="25%"><FONT face="Arial" size="2">Pharmacist</font></td>
 
430
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[50]%></font>&nbsp;</td>
 
431
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[51]%></font>&nbsp;</td>
 
432
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[52]%></font>&nbsp;</td>
 
433
        </tr>
 
434
        <tr>
 
435
          <td width="25%"><FONT face="Arial" size="2">MPH Supervisors</font></td>
 
436
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[53]%></font>&nbsp;</td>
 
437
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[54]%></font>&nbsp;</td>
 
438
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[55]%></font>&nbsp;</td>
 
439
        </tr>
 
440
        <tr>
 
441
          <td width="25%"><FONT face="Arial" size="2">Multipurpose Health Workers</font></td>
 
442
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[56]%></font>&nbsp;</td>
 
443
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[57]%></font>&nbsp;</td>
 
444
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[58]%></font>&nbsp;</td>
 
445
        </tr>
 
446
        <tr>
 
447
          <td width="25%"><FONT face="Arial" size="2">TBHV</font></td>
 
448
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[59]%></font>&nbsp;</td>
 
449
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[60]%></font>&nbsp;</td>
 
450
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[61]%></font>&nbsp;</td>
 
451
        </tr>
 
452
        <tr>
 
453
          <td width="25%"><FONT face="Arial" size="2">STLS*</font></td>
 
454
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[62]%></font>&nbsp;</td>
 
455
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[63]%></font>&nbsp;</td>
 
456
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[64]%></font>&nbsp;</td>
 
457
        </tr>
 
458
      </table>
 
459
      <FONT face="Arial" size="2">*STLS to be reported by medical colleges only</font>
 
460
      <br><br>
 
461
      <FONT face="Arial" size="2"><b>Referral Activities (To be filled in by all PHIs fom OPD Register)</b></font>
 
462
      
 
463
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
464
        <tr>
 
465
          <td width="80%"><FONT face="Arial" size="2">a. Number of new adult outpatient visits</font></td>
 
466
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[65]%></font>&nbsp;</td>
 
467
        </tr>
 
468
        <tr>
 
469
          <td width="80%"><FONT face="Arial" size="2">b. Out of (a), number of chest symptomatic patients referred for sputum examination</font></td>
 
470
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[66]%></font>&nbsp;</td>
 
471
        </tr>
 
472
      </table>
 
473
      <br><br><br>
 
474
      <FONT face="Arial" size="2"><b>Microscopy Activities (To be filled in by only PHIs which are a DMC from Laboratory Register)</b></font>            
 
475
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
476
        <tr>
 
477
          <td width="80%"><FONT face="Arial" size="2">c. Number of TB suspects whose sputum was examined for diagnosis</font></td>
 
478
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[67]%></font>&nbsp;</td>
 
479
        </tr>
 
480
        <tr>
 
481
          <td width="80%"><FONT face="Arial" size="2">d. Out of (c) number of smear positive patients diagnosed</font></td>
 
482
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[68]%></font>&nbsp;</td>
 
483
        </tr>
 
484
        <tr>
 
485
          <td width="80%"><FONT face="Arial" size="2">e. Number of TB suspects subjected to repeat sputum examination for diagnosis</font></td>
 
486
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[69]%></font>&nbsp;</td>
 
487
        </tr>
 
488
        <tr>
 
489
          <td width="80%"><FONT face="Arial" size="2">f. Out of (e), number of sputum smear positive patients diagnosed</font></td>
 
490
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[70]%></font>&nbsp;</td>
 
491
        </tr>
 
492
        <tr>
 
493
          <td width="80%"><FONT face="Arial" size="2">g. Total number of sputum smear positive patients diagnosed (d + f)</font></td>
 
494
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[68]+monthlyValues[70])%></font>&nbsp;</td>
 
495
        </tr>
 
496
      </table>
 
497
          
 
498
          <br>        
 
499
      <FONT face="Arial" size="2"><b>Treatment Initiation (To be filled in by only PHIs which are a DMC from Laboratory Register and Referral for Treatment</b></font>            
 
500
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
501
        <tr>
 
502
          <td width="80%"><FONT face="Arial" size="2">h. Of the smear-positive patients diagnosed (g), number put on DOTS</font></td>
 
503
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[71]%></font>&nbsp;</td>
 
504
        </tr>
 
505
        <tr>
 
506
          <td width="80%"><FONT face="Arial" size="2">i. Of the number of smear-positive patients diagnosed (g), number put on RNTCP Non-DOTS (ND1 and ND2)</font></td>
 
507
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[72]%></font>&nbsp;</td>
 
508
        </tr>
 
509
        <tr>
 
510
          <td width="80%"><FONT face="Arial" size="2">j. Of the smear-positive patients diagnosed (g), the number referred for treatment to other TUs within the district</font></td>
 
511
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[73]%></font>&nbsp;</td>
 
512
        </tr>
 
513
        <tr>
 
514
          <td width="80%"><FONT face="Arial" size="2">k. Of the smear-positive patients diagnosed (g), the number referred for treatment outside the district</font></td>
 
515
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[74]%></font>&nbsp;</td>
 
516
        </tr>
 
517
      </table>
 
518
      <br>
 
519
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
520
        <tr>
 
521
          <td width="80%"><FONT face="Arial" size="2">Number of smear negative patients residing within the district and put on treatment other than DOTS</font></td>
 
522
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[75]%></font>&nbsp;</td>
 
523
        </tr>
 
524
        <tr>
 
525
          <td width="80%"><FONT face="Arial" size="2">Number of extrapulmonary patients residing within the district and put on treatment other than DOTS</font></td>
 
526
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[76]%></font>&nbsp;</td>
 
527
        </tr>
 
528
          </table>
 
529
          <br>
 
530
      <FONT face="Arial" size="2"><b>Consumables (To be filled in by only PHIs which are a DMC)</b></font>
 
531
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
532
        <tr>
 
533
          <td width="20%" align="center"><FONT face="Arial" size="2"><b>Item</b></font></td>
 
534
          <td width="15%" align="center"><FONT face="Arial" size="2"><b>Unit of Measurement</b></font></td>
 
535
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on first day of Month</b></font></td>
 
536
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock received during Month</b></font></td>
 
537
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Consumption during Month*</b></font></td>
 
538
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on last day of Month</b></font></td>
 
539
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Quantity Requested</b></font></td>
 
540
        </tr>
 
541
        <tr>
 
542
          <td width="20%"><FONT face="Arial" size="2">Sputum containers</font></td>
 
543
          <td width="15%"><FONT face="Arial" size="2">Nos.</font></td>
 
544
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[77]%></font>&nbsp;</td>
 
545
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[78]%></font>&nbsp;</td>
 
546
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[79]%></font>&nbsp;</td>
 
547
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[80]%></font>&nbsp;</td>
 
548
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[81]%></font>&nbsp;</td>
 
549
        </tr>
 
550
        <tr>
 
551
          <td width="20%"><FONT face="Arial" size="2">Slides</font></td>
 
552
          <td width="15%"><FONT face="Arial" size="2">Nos.</font></td>
 
553
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[82]%></font>&nbsp;</td>
 
554
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[83]%></font>&nbsp;</td>
 
555
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[84]%></font>&nbsp;</td>
 
556
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[85]%></font>&nbsp;</td>
 
557
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[86]%></font>&nbsp;</td>
 
558
        </tr>
 
559
        <tr>
 
560
          <td width="20%"><FONT face="Arial" size="2">Carbon Fuchsin</font></td>
 
561
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
562
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[87]%></font>&nbsp;</td>
 
563
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[88]%></font>&nbsp;</td>
 
564
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[89]%></font>&nbsp;</td>
 
565
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[90]%></font>&nbsp;</td>
 
566
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[91]%></font>&nbsp;</td>
 
567
        </tr>
 
568
        <tr>
 
569
          <td width="20%"><FONT face="Arial" size="2">Methylene Blue</font></td>
 
570
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
571
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[92]%></font>&nbsp;</td>
 
572
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[93]%></font>&nbsp;</td>
 
573
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[94]%></font>&nbsp;</td>
 
574
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[95]%></font>&nbsp;</td>
 
575
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[96]%></font>&nbsp;</td>
 
576
        </tr>
 
577
        <tr>
 
578
          <td width="20%"><FONT face="Arial" size="2">Sulphuric Acid</font></td>
 
579
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
580
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[97]%></font>&nbsp;</td>
 
581
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[98]%></font>&nbsp;</td>
 
582
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[99]%></font>&nbsp;</td>
 
583
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[100]%></font>&nbsp;</td>
 
584
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[101]%></font>&nbsp;</td>
 
585
        </tr>
 
586
        <tr>
 
587
          <td width="20%"><FONT face="Arial" size="2">Phenol</font></td>
 
588
          <td width="15%"><FONT face="Arial" size="2">Grams</font></td>
 
589
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[102]%></font>&nbsp;</td>
 
590
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[103]%></font>&nbsp;</td>
 
591
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[104]%></font>&nbsp;</td>
 
592
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[105]%></font>&nbsp;</td>
 
593
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[106]%></font>&nbsp;</td>
 
594
        </tr>
 
595
        <tr>
 
596
          <td width="20%"><FONT face="Arial" size="2">Xylene</font></td>
 
597
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
598
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[107]%></font>&nbsp;</td>
 
599
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[108]%></font>&nbsp;</td>
 
600
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[109]%></font>&nbsp;</td>
 
601
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[110]%></font>&nbsp;</td>
 
602
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[111]%></font>&nbsp;</td>
 
603
        </tr>
 
604
        <tr>
 
605
          <td width="20%"><FONT face="Arial" size="2">Immersion Oil</font></td>
 
606
          <td width="15%"><FONT face="Arial" size="2">ml</font></td>
 
607
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[112]%></font>&nbsp;</td>
 
608
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[113]%></font>&nbsp;</td>
 
609
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[114]%></font>&nbsp;</td>
 
610
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[115]%></font>&nbsp;</td>
 
611
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[116]%></font>&nbsp;</td>
 
612
        </tr>
 
613
        <tr>
 
614
          <td width="20%"><FONT face="Arial" size="2">Methylated Spirit</font></td>
 
615
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
616
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[117]%></font>&nbsp;</td>
 
617
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[118]%></font>&nbsp;</td>
 
618
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[119]%></font>&nbsp;</td>
 
619
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[120]%></font>&nbsp;</td>
 
620
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[121]%></font>&nbsp;</td>
 
621
        </tr>
 
622
          </table>
 
623
          <br>
 
624
          <FONT face="Arial" size="2"><b>Equipment in place</b></font>
 
625
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
626
        <tr>
 
627
          <td width="25%" align="center"><b><font face="Arial" size="2">Item</font></b></td>
 
628
          <td width="25%" align="center"><b><font face="Arial" size="2">Number in place</font></b></td>
 
629
          <td width="25%" align="center"><b><font face="Arial" size="2">In working condition</font></b></td>
 
630
          <td width="25%" align="center"><b><font face="Arial" size="2">Not in working condition</font></b></td>
 
631
        </tr>
 
632
        <tr>
 
633
          <td width="25%"><font face="Arial" size="2">Monocular microscopes</font></td>
 
634
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[122]%></font>&nbsp;</td>
 
635
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[123]%></font>&nbsp;</td>
 
636
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[124]%></font>&nbsp;</td>
 
637
        </tr>
 
638
        <tr>
 
639
          <td width="25%"><font face="Arial" size="2">Binocular microscopes</font></td>
 
640
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[125]%></font>&nbsp;</td>
 
641
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[126]%></font>&nbsp;</td>
 
642
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[127]%></font>&nbsp;</td>
 
643
        </tr>
 
644
          </table>
 
645
          <FONT face="Arial" size="2">*PHIs that are not a DMC, but have been supplied with sputum ontainers, should complete this row.
 
646
          <br><br><br><b>Name of officer reporting (in Capital Letters):
 
647
          <br><br>Signature:
 
648
          <br><br>Date:
 
649
          </b></font>
 
650
        </body>
 
651
</html>
 
 
b'\\ No newline at end of file'