Merge lp:~graeme-acm/sahana-eden/RMS into lp:sahana-eden

[Graeme Foster]

Import of spreadsheet within ADAT

minor fixes and tweaks

=== modified file 'controllers/survey.py'
--- controllers/survey.py	2011-11-04 05:47:13 +0000
+++ controllers/survey.py	2011-11-13 16:54:25 +0000
@@ -24,6 +24,7 @@
     from StringIO import StringIO
 
 import base64
+import math
 
 from gluon.contenttype import contenttype
 from s3survey import S3AnalysisPriority, \
@@ -323,7 +324,10 @@
                 col = startcol
             elif action == "columns":
                 row = startrow
-                col = endcol
+                if endcol == 0:
+                    col = 0
+                else:
+                    col = endcol+1
             # If the rule is a list then step through each element
             if isinstance(element,list):
                 if action == "rows":
@@ -339,12 +343,7 @@
                 nextrow = endrow
             if endcol > nextcol:
                 nextcol = endcol
-
-#                if len(line) > 1:
-#                    matrix.boxRange(startrow, startcol, nextrow, endcol)
-#            row = nextrow
-#            col = 0
-        return (nextrow, nextcol+1)
+        return (nextrow, nextcol)
 
     def processDict(series_id, rules, row, col, matrix, matrixAnswer, action="rows"):
         startcol = col
@@ -398,24 +397,44 @@
         return (endrow, endcol)
 
     row = 0
+    col = 0
     matrix = DataMatrix()
     matrixAnswers = DataMatrix()
+    template = response.s3.survey_getTemplateFromSeries(series_id)
+    series = response.s3.survey_getSeries(series_id)
+    logo = os.path.join(request.folder,
+                        "static",
+                        "img",
+                        "logo",
+                        series.logo
+                        )
+    if os.path.exists(logo) and os.path.isfile(logo):
+        cell = MatrixElement(0,col,"", style=["styleText"])
+        cell.merge(vertical=2)
+        matrix.addElement(cell)
+        col = 2
+        row += 1
+    else:
+        logo = None
+    title = template.description
+    cell = MatrixElement(0,col,title, style="styleHeader")
+    cell.merge(vertical=1, horizontal=4)
+    matrix.addElement(cell)
+    row += 2
 
-    sectionName = ""
     for section in sectionList:
         col = 0
-        if sectionName != "":
-            row += 1
-        sectionName = section["name"]
-        rules =  layout[sectionName]
+        row += 1
+        rules =  layout[section["name"]]
         cell = MatrixElement(row,col,section["name"], style="styleHeader")
         try:
             matrix.addElement(cell)
         except Exception as msg:
             print msg
         row += 1
+        startrow = row
         (row, col) = processRule(series_id, rules, row, col, matrix, matrixAnswers)
-
+        matrix.boxRange(startrow, 0, row, col-1)
 
     ######################################################################
     #
@@ -431,21 +450,20 @@
         # Wrap text and calculate the row width and height
         characters_in_cell = float(width)
         twips_per_row = 255 #default row height for 10 point font
-#        if cell.merged():
-#            sheet.write_merge(cell.row,
-#                              cell.row + cell.mergeV,
-#                              cell.col,
-#                              cell.col + cell.mergeH,
-#                              unicode(cell.text),
-#                              style
-#                             )
-#            rows = math.ceil((len(unicode(text)) / characters_in_cell) / (1 + cell.mergeH))
-#            new_row_height = int(rows * twips_per_row)
-#            new_col_width = characters_in_cell * COL_WIDTH_MULTIPLIER
-#            sheet.row(row).height = new_row_height 
-#            sheet.col(col).width = new_col_width
-#        else:
-        if True:
+        if cell.merged():
+            sheet.write_merge(cell.row,
+                              cell.row + cell.mergeV,
+                              cell.col,
+                              cell.col + cell.mergeH,
+                              unicode(cell.text),
+                              style
+                             )
+            rows = math.ceil((len(unicode(text)) / characters_in_cell) / (1 + cell.mergeH))
+            new_row_height = int(rows * twips_per_row)
+            new_col_width = characters_in_cell * COL_WIDTH_MULTIPLIER
+            sheet.row(row).height = new_row_height 
+            sheet.col(col).width = new_col_width
+        else:
             sheet.write(cell.row,
                         cell.col,
                         unicode(cell.text),
@@ -458,8 +476,11 @@
             sheet.col(col).width = new_col_width
 
     def mergeStyles(listTemplate, styleList):
-        # @todo: merge all styles adding differences from a newly created style
-        #        need to step through every property in the style object
+        """
+            Take a list of styles and return a single style object with
+            all the differences from a newly created object added to the
+            resultant style.
+        """
         if len(styleList) == 0:
             finalStyle = xlwt.XFStyle()
         elif len(styleList) == 1:
@@ -546,6 +567,10 @@
     shadedFill.pattern_fore_colour = 0x16 # 25% Grey
     shadedFill.pattern_back_colour = 0x08 # Black
     
+    styleTitle =  xlwt.XFStyle()
+    styleTitle.font.height = 0x0140 # 320 twips, 16 points
+    styleTitle.font.bold = True
+    styleTitle.alignment = alignBase
     styleHeader = xlwt.XFStyle()
     styleHeader.font.height = 0x00F0 # 240 twips, 12 points
     styleHeader.font.bold = True
@@ -563,52 +588,51 @@
     styleInput.borders = borders
     styleInput.protection = noProtection
     styleInput.pattern = shadedFill
-    boxTL = xlwt.XFStyle()
-    boxTL.borders = borderTL
     boxL = xlwt.XFStyle()
     boxL.borders = borderL
     boxT = xlwt.XFStyle()
     boxT.borders = borderT
-    boxTR = xlwt.XFStyle()
-    boxTR.borders = borderTR
     boxR = xlwt.XFStyle()
     boxR.borders = borderR
-    boxBL = xlwt.XFStyle()
-    boxBL.borders = borderBL
     boxB = xlwt.XFStyle()
     boxB.borders = borderB
-    boxBR = xlwt.XFStyle()
-    boxBR.borders = borderBR
     styleList = {}
+    styleList["styleTitle"] = styleTitle
     styleList["styleHeader"] = styleHeader
     styleList["styleSubHeader"] = styleSubHeader
     styleList["styleText"] = styleText
     styleList["styleInput"] = styleInput
-    styleList["boxTL"] = boxTL
     styleList["boxL"] = boxL
     styleList["boxT"] = boxT
-    styleList["boxTR"] = boxTR
     styleList["boxR"] = boxR
-    styleList["boxBL"] = boxBL
     styleList["boxB"] = boxB
-    styleList["boxBR"] = boxBR
     
-    sheet1 = book.add_sheet(T("Sections"))
-    sheetA = book.add_sheet(T("Assignment"))
+    sheet1 = book.add_sheet(T("Assessment"))
+    sheetA = book.add_sheet(T("Metadata"))
     for cell in matrix.matrix.values():
+        if cell.joined():
+            continue
         style = mergeStyles(styleList, cell.styleList)
         if (style.alignment.wrap == style.alignment.WRAP_AT_RIGHT):
-            wrapText(sheet1, cell, style)
+            # get all the styles from the joined cells
+            # and merge these styles in.
+            joinedStyles = matrix.joinedElementStyles(cell)
+            joinedStyle =  mergeStyles(styleList, joinedStyles)
+            wrapText(sheet1, cell, joinedStyle)
         else:
-#            if cell.merged():
-#                sheet1.write_merge(cell.row,
-#                                   cell.row + cell.mergeV,
-#                                   cell.col,
-#                                   cell.col + cell.mergeH,
-#                                   unicode(cell.text),
-#                                   style
-#                                   )
-#            else:
+            if cell.merged():
+                # get all the styles from the joined cells
+                # and merge these styles in.
+                joinedStyles = matrix.joinedElementStyles(cell)
+                joinedStyle =  mergeStyles(styleList, joinedStyles)
+                sheet1.write_merge(cell.row,
+                                   cell.row + cell.mergeV,
+                                   cell.col,
+                                   cell.col + cell.mergeH,
+                                   unicode(cell.text),
+                                   joinedStyle
+                                   )
+            else:
                 sheet1.write(cell.row,
                              cell.col,
                              unicode(cell.text),
@@ -617,7 +641,8 @@
 
     sheetA.write(0, 0, "Question Code")
     sheetA.write(0, 1, "Response Count")
-    sheetA.write(0, 2, "Cell Address")
+    sheetA.write(0, 2, "Values")
+    sheetA.write(0, 3, "Cell Address")
     for cell in matrixAnswers.matrix.values():
         style = mergeStyles(styleList, cell.styleList)
         sheetA.write(cell.row,
@@ -626,6 +651,9 @@
                      style
                     )
 
+    if logo != None:
+        sheet1.insert_bitmap(logo, 0, 0)
+
     sheet1.protect = True
     sheetA.protect = True
     for i in range(26):
@@ -967,7 +995,7 @@
                     analysisTool.advancedResults()
                 else:
                     analysisTool = None
-                if analysisTool != None:
+                if analysisTool != None and not math.isnan(analysisTool.mean):
                     priorityObj = S3AnalysisPriority(range=[-.66,.66],
                                                      colour={-1:"#888888", # grey
                                                              0:"#000080", # blue
@@ -987,7 +1015,7 @@
                                                       zero = True)
                     pBand = analysisTool.priorityBand(priorityObj)
                     legend = TABLE(
-                               TR (TH(T("Marker Priority Levels"),_colspan=3)),
+                               TR (TH(T("Marker Levels"),_colspan=3)),
                                )
                     for key in priorityObj.image.keys():
                         tr = TR( TD(priorityObj.imageURL(request.application,key)),
@@ -1030,7 +1058,10 @@
             if bounds == {}:
                 bounds = gis.get_bounds()
             map = gis.show_map(feature_queries = feature_queries,
+                               height = 600,
+                               width = 800,
                                bbox = bounds,
+                               collapsed = True,
                               )
             allQuestions = response.s3.survey_get_series_questions(series_id)
             numericTypeList = ("Numeric")
@@ -1043,11 +1074,11 @@
             table = TABLE()
 
             priorityQstn = SELECT(numQstns, _name="pqstn_name", value=pqstn_name)
-            table.append(TR(TH(T("Priority Question:")), _class="survey_question"))
+            table.append(TR(TH(T("Question to set the Marker Levels:")), _class="survey_question"))
             table.append(priorityQstn)
             form.append(table)
 
-            button = INPUT(_type="submit", _name="Chart", _value=T("Select the Priority Question"))
+            button = INPUT(_type="submit", _name="Chart", _value=T("Select the Question"))
             form.append(button)
 
             output["title"] = crud_strings.title_map
@@ -1197,6 +1228,12 @@
         if r.interactive:
             if "vars" in current.request and len(current.request.vars) > 0:
                 dummy, series_id = current.request.vars.viewing.split(".")
+            else:
+                # The URL is bad, without a series id we're lost so list all series
+                redirect(URL(c="survey",
+                             f="series",
+                             args=[],
+                             vars = {}))
             if "post_vars" in current.request and len(current.request.post_vars) > 0:
                 id = response.s3.survey_save_answers_for_series(series_id,
                                                                 None, # Insert
@@ -1205,21 +1242,32 @@
         return True
 
     def postp(r, output):
-        T = current.T
-        response.s3.survey_answerlist_dataTable_post(r)
-        tablename, series_id = current.request.vars.viewing.split(".")
-        form = response.s3.survey_buildQuestionnaireFromSeries(series_id, None)
-        urlform=URL(c=module,
-                     f="series_export_formatted",
-                     args=[series_id])
-        urlbasic=URL(c=module,
-                     f="series_export_basic",
-                     args=[series_id])
-        buttons = DIV (A(T("Export Assessment as a Formatted Spreadsheet"), _href=urlform, _id="Excel-export", _class="action-btn"),
-                       A(T("Export Assessment as a Spreadsheet"), _href=urlbasic, _id="Excel-export", _class="action-btn")
-                      )
-        output["subtitle"] = buttons
-        output["form"] = form
+        if r.interactive:
+            if "vars" in current.request and len(current.request.vars) > 0:
+                tablename, series_id = current.request.vars.viewing.split(".")
+            if output["form"] == None:
+                # The user is not authorised to create so switch to read
+                redirect(URL(c="survey",
+                             f="series",
+                             args=[series_id,"read"],
+                             vars = {}))
+            response.s3.survey_answerlist_dataTable_post(r)
+            form = response.s3.survey_buildQuestionnaireFromSeries(series_id, None)
+            urlexport = URL(c=module,
+                            f="series_export_formatted",
+                            args=[series_id]
+                            )
+            urlimport = URL(c=module,
+                            f="complete",
+                            args=[series_id,"import.xml"],
+                            vars = {"extra_data":True}
+                            )
+            T = current.T
+            buttons = DIV (A(T("Export Assessment as a Formatted Spreadsheet"), _href=urlexport, _id="Excel-export", _class="action-btn"),
+                           A(T("Import Spreadsheet as an Assessment"), _href=urlimport, _id="Excel-import", _class="action-btn"),
+                          )
+            output["subtitle"] = buttons
+            output["form"] = form
         return output
 
     response.s3.prep = prep
@@ -1230,7 +1278,8 @@
                                 rheader=response.s3.survey_series_rheader
                                )
     return output
-
+        
+    
 def complete():
     """ RESTful CRUD controller """
     # Load Model
@@ -1262,11 +1311,70 @@
             response.s3.survey_answerlist_dataTable_post(r)
         return output
 
+    def import_xls(uploadFile):
+        openFile = StringIO()
+        try:
+            import xlrd
+            from xlwt.Utils import cell_to_rowcol2
+        except ImportError:
+            print >> sys.stderr, "ERROR: xlrd & xlwt modules are needed for importing spreadsheets"
+            return None
+        workbook = xlrd.open_workbook(filename=uploadFile)
+        sheetR = workbook.sheet_by_name("Assessment")
+        sheetM = workbook.sheet_by_name("Metadata")
+        header = '"Series"'
+        body = '"PMI Test"'
+        for row in xrange(1, sheetM.nrows):
+            header += ',"%s"' % sheetM.cell_value(row, 0)
+            count = sheetM.cell_value(row, 1)
+            if count != "":
+                count = int(count)
+                optionList = sheetM.cell_value(row, 2).split("|#|")
+            else:
+                count = 1
+                optionList = None
+            answerList = ''
+            for col in range(count):
+                cell = sheetM.cell_value(row, 3+col)
+                (rowR, colR) = cell_to_rowcol2(cell)
+                try:
+                    response = sheetR.cell_value(rowR, colR)
+                except IndexError:
+                    response = ""
+                if response != "":
+                    if optionList != None:
+                        answerList = optionList[col]
+                    else:
+                        answerList += "%s" % response
+            body += ',"%s"' % answerList
+        openFile.write(header)
+        openFile.write("\n")
+        openFile.write(body)
+        openFile.seek(0)
+        return openFile
+ 
+    def importerPrep():
+        try:
+            series_id = current.request.args[0]
+            series_name = response.s3.survey_getSeriesName(series_id)
+            if series_name == "":
+                return dict()
+            data = dict(
+                        Label = "Series",
+                        Default = series_name,
+                       )
+            return data
+        except:
+            return dict()
+
+    response.s3.importerPrep = importerPrep
+    
     s3mgr.configure("survey_complete",
                     listadd=False,
                     deletable=False)
     response.s3.prep = prep
     response.s3.postp = postp
+    response.s3.xls_parser = import_xls
     output = s3_rest_controller(prefix, resourcename)
     return output
 

=== modified file 'models/08_inv.py'
--- models/08_inv.py	2011-10-13 23:49:18 +0000
+++ models/08_inv.py	2011-11-13 16:54:25 +0000
@@ -183,7 +183,7 @@
                         comment=T("Search for an item by text."),
                         field=[ "item_id$name",
                                 #"item_id$category_id$name",
-                                "site_id$name"
+                                #"site_id$name"
                                 ]
                       ),
                       s3base.S3SearchOptionsWidget(

=== modified file 'models/survey.py'
--- models/survey.py	2011-11-07 19:55:13 +0000
+++ models/survey.py	2011-11-13 16:54:25 +0000
@@ -615,6 +615,23 @@
             row = query.select(table.name, limitby=(0, 1)).first()
             return row.name
 
+        def series_onaccept(form):
+            """
+                Ensure that the template status is set to Active 
+            """
+            table = db.survey_template
+
+            if form.vars.template_id:
+                template_id = form.vars.template_id
+            else:
+                return
+            db(table.id == template_id).update(status = 2)
+
+
+        s3mgr.configure(tablename,
+                        onaccept = series_onaccept,
+                        )
+
         s3mgr.model.add_component(table, survey_template="template_id")
 
         #**********************************************************************
@@ -768,7 +785,9 @@
                 function to return the series from a series id
             """
             record = getSeries(series_id)
-            return record.name
+            if record != None:
+                return record.name
+            return ""
 
 
         #**********************************************************************
@@ -1017,7 +1036,7 @@
 
                     sectionTable = db["survey_section"]
                     qlistTable = db["survey_question_list"]
-                    if "vars" in current.request and len(current.request.vars) > 0:
+                    if "vars" in current.request and "viewing" in current.request.vars:
                         dummy, template_id = current.request.vars.viewing.split(".")
                     else:
                         template_id = r.id
@@ -1740,6 +1759,8 @@
 
         return_dict = dict(
             survey_updateMetaData = updateMetaData,
+            survey_getTemplateFromSeries = getTemplateFromSeries,
+            survey_getSeries = getSeries,
             survey_getSeriesName = getSeriesName,
             survey_getAllSeries = getAllSeries,
             survey_getAllSectionsForSeries = getAllSectionsForSeries,

=== modified file 'modules/s3/s3import.py'
--- modules/s3/s3import.py	2011-11-09 07:33:20 +0000
+++ modules/s3/s3import.py	2011-11-13 16:54:25 +0000
@@ -383,7 +383,8 @@
             # @todo: use the request extension as file format?
             #uploadFileFormat = request.vars.file.type.split("/")[1]
             uploadFileFormat = uploadFilename.split(".").pop()
-            if uploadFileFormat not in ["csv"]:
+            if uploadFileFormat not in ["csv", "xls"]:
+                response.flash = None # clear the success message & display the error
                 response.error = self.messages.invalid_file_format
                 return self.upload()
             path = table.file.uploadfolder
@@ -394,8 +395,18 @@
                           #"imports",
                           uploadFilename
                          )
-            openUploadFile = open(uploadFile, "rb")
-
+            openUploadFile = None
+            if uploadFileFormat == "xls":
+                if "xls_parser" in response.s3:
+                    openUploadFile = response.s3.xls_parser(uploadFile)
+                    uploadFileFormat = "csv"
+            else:
+                openUploadFile = open(uploadFile, "rb")
+            if openUploadFile == None:
+                response.flash = None # clear the success message & display the error
+                response.error = self.messages.invalid_file_format
+                return self.upload()
+                
             query = (table.file == uploadFilename)
             row = db(query).select(table.id,
                                    limitby=(0, 1)).first()
@@ -935,8 +946,8 @@
         db = current.db
 
         extraData = response.s3.importerPrep()
-        if "extra_data" in request.vars and request.vars.extra_data != "":
-            value = request.vars.extra_data
+        if "extra_data" in request.post_vars and request.post_vars.extra_data != "":
+            value = request.post_vars.extra_data
             # If we have a lookup defined change the value to the right one in the table
             if "Lookup" in extraData:
                 query = extraData["Lookup"] == value
@@ -946,18 +957,17 @@
             # Now add the extra column
             firstLine = True
             newcsv = tempfile.TemporaryFile()
-            with openFile as f:
-                for line in f:
-                    line = line.strip()
-                    if line == "":
-                        continue
-                    if firstLine:
-                        line += ',"%s"\n' % extraData["Label"]
-                        firstLine = False
-                    else:
-                        line += ',"%s"\n' % value
-                    _debug(line.strip())
-                    newcsv.write(line)
+            for line in openFile:
+                line = line.strip()
+                if line == "":
+                    continue
+                if firstLine:
+                    line += ',"%s"\n' % extraData["Label"]
+                    firstLine = False
+                else:
+                    line += ',"%s"\n' % value
+                _debug(line.strip())
+                newcsv.write(line)
             openFile = newcsv
             openFile.flush()
             openFile.seek(0)

=== modified file 'modules/s3/s3survey.py'
--- modules/s3/s3survey.py	2011-11-12 19:49:07 +0000
+++ modules/s3/s3survey.py	2011-11-13 16:54:25 +0000
@@ -94,105 +94,81 @@
             msg = "Attempting to add data %s at posn %s. This is already taken with data %s" %(element, posn, self.matrix[posn])
             raise Exception(msg)
         self.matrix[posn] = element
+        element.parents.append(self)
+        if element.merged():
+            self.joinElements(element)
         if element.row > self.lastRow:
             self.lastRow = element.row 
 
+    def joinedElementStyles(self, rootElement):
+        """
+            return a list of all the styles used by all the elements joined
+            to the root element
+        """
+        styleList = []
+        row = rootElement.row
+        col = rootElement.col
+        for v in range(rootElement.mergeV+1):
+            for h in range(rootElement.mergeH+1):
+                newPosn = "%s,%s" % (row+v,col+h)
+                styleList += self.matrix[newPosn].styleList
+        return styleList
+
+    def joinElements(self, rootElement):
+        """
+            This will set the joinedWith property to the posn of rootElement
+            for all the elements that rootElement joins with to make a single
+            large merged element.
+        """
+        row = rootElement.row
+        col = rootElement.col
+        posn = rootElement.posn()
+        for v in range(rootElement.mergeV+1):
+            for h in range(rootElement.mergeH+1):
+                newPosn = "%s,%s" % (row+v,col+h)
+                if newPosn == posn:
+                    continue
+                if newPosn in self.matrix:
+                    if self.matrix[newPosn].joinedWith == posn:
+                        continue
+                    msg = "Attempting to merge element at posn %s. The following data will be lost %s" %(newPosn, self.matrix[newPosn])
+                    self.matrix[newPosn].joinedWith = posn
+                else:
+                    childElement = MatrixElement(row,col,"",[])
+                    childElement.joinedWith = posn
+                    self.matrix[newPosn] = childElement
+
     def boxRange(self, startrow, startcol, endrow, endcol):
         """
-            Function to add a bounding box around the cells contained by
-            the cells (startrow, startcol) and (endrow, endcol)
+            Function to add a bounding box around the elements contained by
+            the elements (startrow, startcol) and (endrow, endcol)
 
-            This uses the standard style names (in anti-clockwise direction):
-            boxTL, boxL, boxBL, boxB, boxBR, boxR, boxTR, boxT
-            
-            ###################################################################
-            ***NOTE***
-            Some fairly complex adjustments are needed for merged cells.
-            For a spreadsheet (xlwt) if a cell that has been merged is then
-            written to an exception is thrown. This will happen when a box
-            is drawn around a merged cell so the various merge counters are
-            used to jump the processing. This is appropriate for xlwt but may
-            need to be removed for other output types.
-            
-            Additionally this has not been tested with a vertically merged cell
-            in the bottom corner. This situation may cause some odd results. 
-            ###################################################################
+            This uses standard style names:
+            boxL, boxB, boxR, boxT
+            for Left, Bottom, Right and Top borders respectively
         """
-        mergeCntL = 0
-        mergeCntR = 0
-        mergeCntT = 0
-        mergeCntB = 0
         for r in range(startrow, endrow):
-            if mergeCntL > 0:
-                mergeCntL -= 1
-            else:
-                posn = "%s,%s" % (r,startcol)
-                if r == startrow:
-                    if posn in self.matrix:
-                        self.matrix[posn].styleList.append("boxTL")
-                        element = self.matrix[posn]
-                        mergeCntL = element.mergeV
-                        mergeCntT = element.mergeH
-                    else:
-                        self.addElement(MatrixElement(r,startcol,"","boxTL"))
-                elif r == endrow-1:
-                    if posn in self.matrix:
-                        self.matrix[posn].styleList.append("boxBL")
-                    else:
-                        self.addElement(MatrixElement(r,startcol,"","boxBL"))
-                else:
-                    if posn in self.matrix:
-                        self.matrix[posn].styleList.append("boxL")
-                        element = self.matrix[posn]
-                        mergeCntL = element.mergeV
-                    else:
-                        self.addElement(MatrixElement(r,startcol,"","boxL"))
-            if mergeCntR > 0:
-                mergeCntR -= 1
-            else:
-                posn = "%s,%s" % (r,endcol)
-                if r == startrow:
-                    if posn in self.matrix:
-                        self.matrix[posn].styleList.append("boxTR")
-                        element = self.matrix[posn]
-                        mergeCntR = element.mergeV
-                        mergeCntB = element.mergeH
-                    else:
-                        self.addElement(MatrixElement(r,endcol,"","boxTR"))
-                elif r == endrow-1:
-                    if posn in self.matrix:
-                        self.matrix[posn].styleList.append("boxBR")
-                    else:
-                        self.addElement(MatrixElement(r,endcol,"","boxBR"))
-                else:
-                    if posn in self.matrix:
-                        self.matrix[posn].styleList.append("boxR")
-                        element = self.matrix[posn]
-                        mergeCntR = element.mergeV
-                    else:
-                        self.addElement(MatrixElement(r,endcol,"","boxR"))
-        for c in range(startcol+1, endcol):
-            if mergeCntT > 0:
-                mergeCntT -= 1
-            else:
-                posn = "%s,%s" % (startrow,c)
-                if posn in self.matrix:
-                    self.matrix[posn].styleList.append("boxT")
-                    element = self.matrix[posn]
-                    mergeCntT = element.mergeH
-                else:
-                    self.addElement(MatrixElement(startrow,c,"","boxT"))
-
-            if mergeCntB > 0:
-                mergeCntB -= 1
-            else:
-                posn = "%s,%s" % (endrow-1,c)
-                if posn in self.matrix:
-                    self.matrix[posn].styleList.append("boxB")
-                    element = self.matrix[posn]
-                    mergeCntB = element.mergeH
-                else:
-                    self.addElement(MatrixElement(endrow-1,c,"","boxB"))
+            posn = "%s,%s" % (r,startcol)
+            if posn in self.matrix:
+                self.matrix[posn].styleList.append("boxL")
+            else:
+                self.addElement(MatrixElement(r,startcol,"","boxL"))
+            posn = "%s,%s" % (r,endcol)
+            if posn in self.matrix:
+                self.matrix[posn].styleList.append("boxR")
+            else:
+                self.addElement(MatrixElement(r,endcol,"","boxR"))
+        for c in range(startcol, endcol+1):
+            posn = "%s,%s" % (startrow,c)
+            if posn in self.matrix:
+                self.matrix[posn].styleList.append("boxT")
+            else:
+                self.addElement(MatrixElement(startrow,c,"","boxT"))
+            posn = "%s,%s" % (endrow-1,c)
+            if posn in self.matrix:
+                self.matrix[posn].styleList.append("boxB")
+            else:
+                self.addElement(MatrixElement(endrow-1,c,"","boxB"))
 
 
 class MatrixElement():
@@ -209,6 +185,8 @@
         self.text = data
         self.mergeH = 0
         self.mergeV = 0
+        self.joinedWith = None
+        self.parents = []
         if isinstance(style, list):
             self.styleList = style
         else:
@@ -220,6 +198,8 @@
     def merge(self, horizontal=0, vertical=0):
         self.mergeH = horizontal
         self.mergeV = vertical
+        for parent in self.parents:
+            parent.joinElements(self)
 
     def posn(self):
         """ Standard representation of the position """
@@ -236,6 +216,12 @@
             return True
         return False
 
+    def joined(self):
+        if self.joinedWith == None:
+            return False
+        else:
+            return True
+
 # Question Types
 def survey_stringType(question_id = None):
     return S3QuestionTypeStringWidget(question_id)
@@ -495,7 +481,7 @@
 
     def type_represent(self):
         """
-            Display the type in a DIV for displayiong on the screen
+            Display the type in a DIV for displaying on the screen
         """
         return DIV(self.typeDescription, _class="surveyWidgetType")
 
@@ -525,7 +511,7 @@
             answerRow = answerMatrix.lastRow+1
             cell = MatrixElement(answerRow,0,self.question["code"], style="styleSubHeader")
             answerMatrix.addElement(cell)
-            cell = MatrixElement(answerRow,2,rowcol_to_cell(row, col), style="styleText")
+            cell = MatrixElement(answerRow,3,rowcol_to_cell(row, col), style="styleText")
             answerMatrix.addElement(cell)
         return (row+1, col+1)
 
@@ -897,14 +883,16 @@
             answerMatrix.addElement(cell)
             cell = MatrixElement(answerRow,1,len(list), style="styleSubHeader")
             answerMatrix.addElement(cell)
-            answerCol = 2
+            cell = MatrixElement(answerRow,2,"|#|".join(list), style="styleSubHeader")
+            answerMatrix.addElement(cell)
+            answerCol = 3
         for option in list:
             cell = MatrixElement(row,col,option, style="styleText")
             matrix.addElement(cell)
             cell = MatrixElement(row,col+1,"", style="styleInput")
             matrix.addElement(cell)
             if answerMatrix != None:
-                cell = MatrixElement(answerRow,answerCol,rowcol_to_cell(row, col), style="styleText")
+                cell = MatrixElement(answerRow,answerCol,rowcol_to_cell(row, col+1), style="styleText")
                 answerMatrix.addElement(cell)
                 answerCol += 1
             row += 1
@@ -954,8 +942,9 @@
         self.qstn_metadata["Length"] = 2
 
     def getList(self):
-        T = current.T
-        return [T("Yes"), T("No")]
+        return ["Yes", "No"]
+#        T = current.T
+#        return [T("Yes"), T("No")]
 
 
 ##########################################################################
@@ -982,8 +971,9 @@
         self.qstn_metadata["Length"] = 3
 
     def getList(self):
-        T = current.T
-        return [T("Yes"), T("No"), T("Don't Know")]
+        return ["Yes", "No", "Don't Know"]
+#        T = current.T
+#        return [T("Yes"), T("No"), T("Don't Know")]
 
 
 ##########################################################################
@@ -1012,14 +1002,8 @@
         self.typeDescription = T("Option Other")
 
     def getList(self):
-        T = current.T
-        list = []
-        length = self.get("Length")
-        if length == None:
-            raise Exception("Need to have the options specified")
-        for i in range(int(length)):
-            list.append(self.get(str(i+1)))
-        list[i]=T("Other")
+        list = S3QuestionTypeOptionWidget.getList(self)
+        list.append("Other")
         return list
 
 
@@ -1352,7 +1336,6 @@
                         type = childWidget.get("Type")
                         realWidget = survey_question_type[type](childWidget.id)
                         (endrow, col) = realWidget.writeToMatrix(matrix, row, col, answerMatrix, style)
-
                     if endrow > nextrow:
                         nextrow = endrow
                 posn += 1
@@ -2260,7 +2243,7 @@
         try:
             # Create a figure for the chart to be drawn to
             self.fig = plt.figure()
-        except:
+        except NameError:
             msg = "matplotlib Library not installed"
             output = StringIO()
             output.write(msg)
@@ -2272,6 +2255,8 @@
         self.asInt = True
 
     def survey_hist(self, title, data, bins, min, max, xlabel=None, ylabel=None):
+        if not hasattr(self,"fig"):
+            return
         # draw the histogram
         self.ax = self.fig.add_subplot(111)
         self.ax.hist(data, bins=bins, range=(min,max))
@@ -2287,6 +2272,8 @@
         savefig(self.response.body)
     
     def survey_pie(self, title, data, label):
+        if not hasattr(self,"fig"):
+            return
         # draw a pie chart
         self.ax = self.fig.add_subplot(111)
         self.ax.pie(data, labels=label)
@@ -2295,6 +2282,8 @@
         savefig(self.response.body)
     
     def survey_bar(self, title, data, label, legendLabels):
+        if not hasattr(self,"fig"):
+            return
         # draw a bar chart
         if not isinstance(data[0],list):
             dataList = [data]

=== modified file 'private/prepopulate/demo/ADAT/24H_response.csv'
--- private/prepopulate/demo/ADAT/24H_response.csv	2011-11-04 06:12:33 +0000
+++ private/prepopulate/demo/ADAT/24H_response.csv	2011-11-13 16:54:25 +0000
@@ -1,1 +1,143 @@
-Template,Series,24H-BI-1,24H-BI-2,24H-BI-3,24H-BI-4,24H-BI-5,24H-BI-6,24H-BI-7,24H-BI-8,24H-BI-9,24H-BI-10,24H-BI-11,24H-BI-12,24H-BI-13,24H-H-1,24H-H-2,24H-H-3,24H-H-4,24H-H-5,24H-H-6,24H-H-7,24H-I-1,24H-I-10,24H-I-11,24H-I-12,24H-I-13,24H-I-14,24H-I-15,24H-I-2,24H-I-3,24H-I-4,24H-I-5,24H-I-6,24H-I-7,24H-I-8,24H-I-9,24H-L-1,24H-L-2,24H-L-3,24H-L-4,24H-L-5,24H-L-6,24H-L-7,24H-Re-1,24H-Re-2,24H-Re-3,24H-Re-4,24H-Re-5,24H-Ri-1,24H-Ri-2,24H-Ri-3,24H-Ri-4,24H-Ri-5,24H-S-1,24H-S-2,24H-S-3,24H-S-4,24H-S-5,24H-S-6,24H-S-7,24H-S-8,24H-S-9
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Nembadi,110,,,,,,0,nil,,50,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,2,,,2,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Sariri,40,,,,,,8,1,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,5,,,5,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Ginei,50,,,,,,2,nil,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,4,,,4,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Ungoda,30,,,,,,23,4,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Gora,80,,,,,,57,8,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Bareji,100,,,,,,21,,,800,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Pongani,250,,,,,,56,,,2352,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,55,,,55,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Songade,120,,,,,,29,8,,119,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,16,,,16,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Emo,340,,,,,,149,9,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,34,,,34,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Bandari,150,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,2,,,2,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Beama,680,,,,,,0,,,833,,,,,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,12,,,12,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Kopure,390,,,,,,302,34,,412,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,23,,,23,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Eroro,60,,,,,,21,,,1078,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,6,,,6,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Dombada,560,,,,,,69,1,,499,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,Yes,No,No,No,,1,,,1,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Embogo,600,,,,,,401,87,,800,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,Yes,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Embi,210,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Yes,,,,Rural,Yes,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Barisari,800,,,,,,289,3,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,0,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Siremi,340,,,,,,192,4,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,25,,,some,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Buna,660,,,,,,442,97,,800,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,25,,,some,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Sanananda,540,,,,,,458,24,,600,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,0,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Garara,110,,,,,,67,1,,136,,,,,,,,,,,,,,,,,,,,50,,,,,,Don't Know,,,,Rural,No,No,No,No,,28,,,28,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Killerton,340,,,,,,194,4,,301,,,,,,,,,,,,,,,,,,,,100,,,,,,No,,,,Rural,No,No,No,No,,0,,,nil,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Bagou,220,,,,,,96,7,,227,,,,,,,,,,,,,,,,,,,,149,,,,,,Don't Know,,,,Rural,No,No,No,No,,0,,,nil,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Bepore*,190,,,,,,128,7,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Kurou,340,,,,,,250,54,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Bakubari,450,,,,,,135,5,nil,,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Fufuda,280,,,,,,131,5,nil,,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Batari,180,,,,,,65,1,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Katuna & Kome,570,,,,,,70,1,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Kurereda,370,,,,,,195,3,,,,,,,,,,,,,,,,,,,,,,all,,,,,,Yes,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Ope,70,,,,,,41,3,,357,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Beanga,190,,,,,,8,,,401,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Mora,160,,,,,,0,,,367,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Ambasi,220,,,,,,164,1,,723,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Kainde,380,,,,,,0,,,684,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Oro Bay Rural,24300,Bindari,190,,,,,,137,1,,835,,,,,,,,,,,,,,,,,,,,all,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Kewansasap,340,,,,,,34,3,,290,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,58,,,58,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Reaga,150,,,,,,47,5,,0,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,4,,,4,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Gegerawa,270,,,,,,29,6,,190,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,16,,,16,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Airara,250,,,,,,172,,,0,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,12,,,12,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Sinapa,150,,,,,,69,,,30,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,Yes,No,No,,4,,,4,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Marua,70,,,,,,17,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Uiaku,610,,,,,,371,54,,0,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,5,,,5,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Ganjiga,380,,,,,,0,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,Yes,water source contaminated,10,,,10,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Yuayu,210,,,,,,108,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,Yes,water source contaminated,6,,,6,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Komabun,130,,,,,,56,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,Yes,water source contaminated,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Oreresan,120,,,,,,0,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,Yes,water source contaminated,0,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Rainu,90,,,,,,3,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,Yes,water source contaminated,0,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Wanigela (Sarad Miss/Stn),440,,,,,,61,,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,Yes,water source contaminated,8,,,8,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Waiug,180,,,,,,144,56,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,Yes,water source contaminated,0,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Fofo,110,,,,,,3,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,Yes,water source contaminated,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Inaram,90,,,,,,0,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,0,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Tekwakwan,60,,,,,,31,21,,,,,,"Air,boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,0,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Utan,240,,,,,,147,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,0,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Koreaf,160,,,,,,115,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Naukwate,310,,,,,,124,65,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Ajoa,450,,,,,,27,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Marakof,140,,,,,,47,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,2,,,2,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Uwe,240,,,,,,0,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Orotoaba,200,,,,,,67,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,2,,,2,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Sinei,100,,,,,,1,,,,,,,"Air,boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,1,,,1,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Tumari,230,,,,,,146,4,,30,,,,,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Fofoma,60,,,,,,32,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Berebona,280,,,,,,7,,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,6,,,6,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Founa,140,,,,,,74,,,75,,,,boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,8,,,8,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Ilamaroro,30,,,,,,19,,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,5,,,5,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Ako,260,,,,,,0,,,115,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,2,,,2,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Gobe,210,,,,,,163,3,,30,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,3,,,3,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Bendorode,100,,,,,,7,nil,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,3,,,3,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Foru 1,240,,,,,,36,nil,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,25,,,some,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Foru 2,200,,,,,,122,nil,,,,,,,,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,No,No,,25,,,some,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Sebaga,180,,,,,,122,,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,Yes,No,,27,,,27,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Badaide,70,,,,,,38,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,Yes,No,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Karaisa,260,,,,,,96,nil,,,,,,boat ,,,,,,,,,,,,,,,,,,,,,,No,,,,Rural,No,No,Yes,Yes,Outbreak of Yaws reported,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Moiavi,90,,,,,,70,nil,,,,,,sea,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,Yes,Yes,Outbreak of Yaws reported,4,,,4,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Momoiogo,160,,,,,,33,,,,,,,boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,Yes,Yes,Outbreak of Yaws reported,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Kinjaki,200,,,,,,0,,,,,,,"boat ,air ",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,Yes,Yes,Outbreak of Yaws reported,57,,,57,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Korara,100,,,,,,0,,,,,,,Boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,Yes,Yes,Outbreak of Yaws reported,23,,,23,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Botewari,90,,,,,,35,,,,,,,Air,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,Yes,No,,0,,,nil,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Guruguru,120,,,,,,28,,,,,,,Boat,,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,Yes,No,,0,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,Yes,Cyclone Guba,,Cape Nelson,17460,Embesa,300,,,,,,0,,,,,,,"Air, ",,,,,,,,,,,,,,,,,,,,,,Don't Know,,,,Rural,No,No,No,No,,18,,,18,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Afore,130,,,,29-Nov,,72,,,37,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,0,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Afore Blocks,250,,,,29-Nov,,70,,,230,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Afore Govt. Station,230,,,,29-Nov,,119,23,,56,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Sila,220,,,,1-Dec,,69,,,36,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,100,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Sakarina,60,,,,29-Nov,,9,20,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,18,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Dea,310,,,,,,21,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,3,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Tabuane,470,,,,,,244,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,13,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Siribu,530,,,,,,333,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Gora,250,,,,,,31,,,700,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,56,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Gorabuna,280,,,,,,0,,,600,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,all,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Tahama,370,,,,,,291,6,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Umbawara,190,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Kokoro,160,,,,,,107,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Kuai,180,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Itokama,460,,,,1-Dec,,266,,,5577,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Aiari*,140,,,,,,60,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Sinua*,80,,,,,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Koira,150,,,,,,76,nil,,143,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,7,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Moro (Urodi),150,,,,27-Nov,,97,4,,145,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,9,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Umauma*,80,,,,,,24,4,,108,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,5,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Urumbai (Uriobo),110,,,,,,29,nil,,30,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,5,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Noura,60,,,,,,29,nil,,92,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,16,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Oure,30,,,,,,0,nil,,45,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,9,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Dibau,80,,,,,,63,nil,,95,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,22,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Kasirawa No. 2,40,,,,,,16,nil,,40,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Bibira No. 2,130,,,,29-Nov,,45,nil,,256,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,20,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Fonotaime (Yauri),100,,,,29-Nov,,0,nil,,124,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,2,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Bibira No. 1,110,,,,29-Nov,,50,nil,,108,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,9,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Domara,100,,,,,,0,nil,,266,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,23,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Safia*,180,,,,27-Nov,,47,1,,4038,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,60,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Obea,250,,,,28-Nov,,113,34,,505,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,4,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Silididi,80,,,,,,46,nil,,21,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,12,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Bare,70,,,,,,49,nil,,81,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,8,,,,,
24 Hour B,Cyclone Guba (Oro Province),No,No,Cyclone Guba,,Afore,16860,Ubo,90,,,,,,11,nil,,17,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,17,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,Gewetto,260,,,,,,10,,,229,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,Kopurahambo (Kope),190,,,,,,154,,,149,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,Soputa,330,,,,,,37,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,Inonda,20,,,,,,9,nil,,60,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,5,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,Haruro,170,,,,,,0,,,194,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,Puhemo,160,,,,,,22,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,5,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,Huvivi,260,,,,,,210,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Popondetta Urban LLG,24200,East Embogo Blocks,780,,,,,,649,34,,1236,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,2,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Asimba,110,,,,,,40,0,0,286,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,some,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Kovelo,170,,,,,,6,0,0,815,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,some,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Amada,160,,,,,,52,0,0,882,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,some,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Kokoda Pltn Portion,140,,,,,,55,0,0,625,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,nil,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Kamondo,160,,,,,,13,0,0,1680,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,nil,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Abuari,60,,,,,,38,4,0,430,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,nil,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Alola,70,,,,,,42,0,0,309,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,few,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Hojavahambo,320,,,,,,60,0,0,3000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,52,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Ilimo,370,,,,,,71,0,0,9000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,52,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Papaki,510,,,,,,0,0,0,900,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Hamara,,,,,,,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Rural,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Ombisusu,510,,,,,,197,8,0,547,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Peri-Urban,,,,,,,,,22,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Asisi,220,,,,,,20,0,0,186,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Peri-Urban,,,,,,,,,1,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Sirorata,240,,,,,,179,0,0,236,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Peri-Urban,,,,,,,,,6,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Asafa*,320,,,,,,206,8,0,1000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Peri-Urban,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Emo 1,150,,,,,,51,0,0,168,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Peri-Urban,,,,,,,,,31,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Emo 2,80,,,,,,0,0,0,62,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Peri-Urban,,,,,,,,,10,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Tetebedi,180,,,,,,136,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Peri-Urban,,,,,,,,,,,,,,
24 Hour B,Cyclone Guba (Oro Province),Yes,Yes,Cyclone Guba,,Kokoda Rural LLG,19170,Kokoda Station,120,,,,,,53,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Urban,,,,,,,,,,,,,,
\ No newline at end of file
+"Template","Series","Organisation","24H-BI-1","24H-BI-2","24H-BI-3","24H-BI-4","24H-BI-5","24H-BI-6","24H-BI-7","24H-BI-8","24H-BI-9","24H-BI-10","24H-BI-11","24H-BI-12","24H-BI-13","24H-H-1","24H-H-2","24H-H-3","24H-H-4","24H-H-5","24H-H-6","24H-H-7","24H-I-1","24H-I-10","24H-I-11","24H-I-12","24H-I-13","24H-I-14","24H-I-15","24H-I-2","24H-I-3","24H-I-4","24H-I-5","24H-I-6","24H-I-7","24H-I-8","24H-I-9","24H-L-1","24H-L-2","24H-L-3","24H-L-4","24H-L-5","24H-L-6","24H-L-7","24H-Re-1","24H-Re-2","24H-Re-3","24H-Re-4","24H-Re-5","24H-Ri-1","24H-Ri-2","24H-Ri-3","24H-Ri-4","24H-Ri-5","24H-S-1","24H-S-2","24H-S-3","24H-S-4","24H-S-5","24H-S-6","24H-S-7","24H-S-8","24H-S-9"
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Nembadi",110,,,,,,0,"nil",,50,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,2,,,2,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Sariri",40,,,,,,8,1,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,5,,,5,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Ginei",50,,,,,,2,"nil",,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,4,,,4,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Ungoda",30,,,,,,23,4,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Gora",80,,,,,,57,8,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Bareji",100,,,,,,21,,,800,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Pongani",250,,,,,,56,,,2352,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,55,,,55,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Songade",120,,,,,,29,8,,119,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,16,,,16,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Emo",340,,,,,,149,9,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,34,,,34,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Bandari",150,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,2,,,2,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Beama",680,,,,,,0,,,833,,,,,,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,12,,,12,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Kopure",390,,,,,,302,34,,412,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,23,,,23,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Eroro",60,,,,,,21,,,1078,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,6,,,6,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Dombada",560,,,,,,69,1,,499,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","Yes","No","No","No",,1,,,1,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Embogo",600,,,,,,401,87,,800,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","Yes","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Embi",210,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Yes",,,,"Rural","Yes","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Barisari",800,,,,,,289,3,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,0,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Siremi",340,,,,,,192,4,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,25,,,"some",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Buna",660,,,,,,442,97,,800,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,25,,,"some",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Sanananda",540,,,,,,458,24,,600,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,0,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Garara",110,,,,,,67,1,,136,,,,,,,,,,,,,,,,,,,,50,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,28,,,28,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Killerton",340,,,,,,194,4,,301,,,,,,,,,,,,,,,,,,,,100,,,,,,"No",,,,"Rural","No","No","No","No",,0,,,"nil",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Bagou",220,,,,,,96,7,,227,,,,,,,,,,,,,,,,,,,,149,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,0,,,"nil",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Bepore*",190,,,,,,128,7,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Kurou",340,,,,,,250,54,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Bakubari",450,,,,,,135,5,"nil",,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Fufuda",280,,,,,,131,5,"nil",,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Batari",180,,,,,,65,1,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Katuna & Kome",570,,,,,,70,1,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Kurereda",370,,,,,,195,3,,,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Yes",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Ope",70,,,,,,41,3,,357,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Beanga",190,,,,,,8,,,401,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Mora",160,,,,,,0,,,367,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Ambasi",220,,,,,,164,1,,723,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Kainde",380,,,,,,0,,,684,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Oro Bay Rural",24300,"Bindari",190,,,,,,137,1,,835,,,,,,,,,,,,,,,,,,,,"all",,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Kewansasap",340,,,,,,34,3,,290,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,58,,,58,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Reaga",150,,,,,,47,5,,0,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,4,,,4,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Gegerawa",270,,,,,,29,6,,190,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,16,,,16,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Airara",250,,,,,,172,,,0,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,12,,,12,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Sinapa",150,,,,,,69,,,30,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","Yes","No","No",,4,,,4,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Marua",70,,,,,,17,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Uiaku",610,,,,,,371,54,,0,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,5,,,5,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Ganjiga",380,,,,,,0,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","Yes","water source contaminated",10,,,10,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Yuayu",210,,,,,,108,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","Yes","water source contaminated",6,,,6,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Komabun",130,,,,,,56,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","Yes","water source contaminated",,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Oreresan",120,,,,,,0,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","Yes","water source contaminated",0,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Rainu",90,,,,,,3,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","Yes","water source contaminated",0,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Wanigela (Sarad Miss/Stn)",440,,,,,,61,,,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","Yes","water source contaminated",8,,,8,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Waiug",180,,,,,,144,56,,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","Yes","water source contaminated",0,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Fofo",110,,,,,,3,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","Yes","water source contaminated",,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Inaram",90,,,,,,0,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,0,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Tekwakwan",60,,,,,,31,21,,,,,,"Air,boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,0,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Utan",240,,,,,,147,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,0,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Koreaf",160,,,,,,115,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Naukwate",310,,,,,,124,65,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Ajoa",450,,,,,,27,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Marakof",140,,,,,,47,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,2,,,2,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Uwe",240,,,,,,0,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Orotoaba",200,,,,,,67,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,2,,,2,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Sinei",100,,,,,,1,,,,,,,"Air,boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,1,,,1,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Tumari",230,,,,,,146,4,,30,,,,,,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Fofoma",60,,,,,,32,,,,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Berebona",280,,,,,,7,,,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,6,,,6,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Founa",140,,,,,,74,,,75,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,8,,,8,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Ilamaroro",30,,,,,,19,,,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,5,,,5,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Ako",260,,,,,,0,,,115,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,2,,,2,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Gobe",210,,,,,,163,3,,30,,,,"Air, boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,3,,,3,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Bendorode",100,,,,,,7,"nil",,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,3,,,3,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Foru 1",240,,,,,,36,"nil",,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,25,,,"some",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Foru 2",200,,,,,,122,"nil",,,,,,,,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","No","No",,25,,,"some",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Sebaga",180,,,,,,122,,,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","Yes","No",,27,,,27,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Badaide",70,,,,,,38,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","Yes","No",,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Karaisa",260,,,,,,96,"nil",,,,,,"boat ",,,,,,,,,,,,,,,,,,,,,,"No",,,,"Rural","No","No","Yes","Yes","Outbreak of Yaws reported",,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Moiavi",90,,,,,,70,"nil",,,,,,"sea",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","Yes","Yes","Outbreak of Yaws reported",4,,,4,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Momoiogo",160,,,,,,33,,,,,,,"boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","Yes","Yes","Outbreak of Yaws reported",,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Kinjaki",200,,,,,,0,,,,,,,"boat ,air ",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","Yes","Yes","Outbreak of Yaws reported",57,,,57,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Korara",100,,,,,,0,,,,,,,"Boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","Yes","Yes","Outbreak of Yaws reported",23,,,23,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Botewari",90,,,,,,35,,,,,,,"Air",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","Yes","No",,0,,,"nil",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Guruguru",120,,,,,,28,,,,,,,"Boat",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","Yes","No",,0,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","Yes","Cyclone Guba",,"Cape Nelson",17460,"Embesa",300,,,,,,0,,,,,,,"Air, ",,,,,,,,,,,,,,,,,,,,,,"Don't Know",,,,"Rural","No","No","No","No",,18,,,18,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Afore",130,,,,"29-Nov",,72,,,37,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,0,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Afore Blocks",250,,,,"29-Nov",,70,,,230,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Afore Govt. Station",230,,,,"29-Nov",,119,23,,56,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Sila",220,,,,"1-Dec",,69,,,36,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,100,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Sakarina",60,,,,"29-Nov",,9,20,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,18,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Dea",310,,,,,,21,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,3,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Tabuane",470,,,,,,244,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,13,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Siribu",530,,,,,,333,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Gora",250,,,,,,31,,,700,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,56,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Gorabuna",280,,,,,,0,,,600,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"all",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Tahama",370,,,,,,291,6,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Umbawara",190,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Kokoro",160,,,,,,107,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Kuai",180,,,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Itokama",460,,,,"1-Dec",,266,,,5577,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Aiari*",140,,,,,,60,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Sinua*",80,,,,,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Koira",150,,,,,,76,"nil",,143,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,7,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Moro (Urodi)",150,,,,"27-Nov",,97,4,,145,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,9,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Umauma*",80,,,,,,24,4,,108,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,5,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Urumbai (Uriobo)",110,,,,,,29,"nil",,30,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,5,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Noura",60,,,,,,29,"nil",,92,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,16,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Oure",30,,,,,,0,"nil",,45,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,9,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Dibau",80,,,,,,63,"nil",,95,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,22,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Kasirawa No. 2",40,,,,,,16,"nil",,40,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Bibira No. 2",130,,,,"29-Nov",,45,"nil",,256,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,20,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Fonotaime (Yauri)",100,,,,"29-Nov",,0,"nil",,124,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,2,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Bibira No. 1",110,,,,"29-Nov",,50,"nil",,108,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,9,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Domara",100,,,,,,0,"nil",,266,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,23,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Safia*",180,,,,"27-Nov",,47,1,,4038,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,60,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Obea",250,,,,"28-Nov",,113,34,,505,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,4,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Silididi",80,,,,,,46,"nil",,21,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,12,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Bare",70,,,,,,49,"nil",,81,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,8,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","No","No","Cyclone Guba",,"Afore",16860,"Ubo",90,,,,,,11,"nil",,17,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,17,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"Gewetto",260,,,,,,10,,,229,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"Kopurahambo (Kope)",190,,,,,,154,,,149,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"Soputa",330,,,,,,37,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"Inonda",20,,,,,,9,"nil",,60,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,5,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"Haruro",170,,,,,,0,,,194,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"Puhemo",160,,,,,,22,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,5,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"Huvivi",260,,,,,,210,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Popondetta Urban LLG",24200,"East Embogo Blocks",780,,,,,,649,34,,1236,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,2,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Asimba",110,,,,,,40,0,0,286,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"some",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Kovelo",170,,,,,,6,0,0,815,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"some",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Amada",160,,,,,,52,0,0,882,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"some",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Kokoda Pltn Portion",140,,,,,,55,0,0,625,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"nil",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Kamondo",160,,,,,,13,0,0,1680,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"nil",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Abuari",60,,,,,,38,4,0,430,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"nil",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Alola",70,,,,,,42,0,0,309,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,"few",,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Hojavahambo",320,,,,,,60,0,0,3000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,52,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Ilimo",370,,,,,,71,0,0,9000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,52,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Papaki",510,,,,,,0,0,0,900,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Hamara",,,,,,,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Rural",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Ombisusu",510,,,,,,197,8,0,547,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Peri-Urban",,,,,,,,,22,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Asisi",220,,,,,,20,0,0,186,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Peri-Urban",,,,,,,,,1,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Sirorata",240,,,,,,179,0,0,236,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Peri-Urban",,,,,,,,,6,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Asafa*",320,,,,,,206,8,0,1000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Peri-Urban",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Emo 1",150,,,,,,51,0,0,168,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Peri-Urban",,,,,,,,,31,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Emo 2",80,,,,,,0,0,0,62,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Peri-Urban",,,,,,,,,10,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Tetebedi",180,,,,,,136,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Peri-Urban",,,,,,,,,,,,,,
+"24 Hour B","Cyclone Guba (Oro Province)","Papua New Guinea Red Cross Society","Yes","Yes","Cyclone Guba",,"Kokoda Rural LLG",19170,"Kokoda Station",120,,,,,,53,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Urban",,,,,,,,,,,,,,

=== modified file 'private/prepopulate/demo/ADAT/layoutPMI.csv'
--- private/prepopulate/demo/ADAT/layoutPMI.csv	2011-11-01 14:38:26 +0000
+++ private/prepopulate/demo/ADAT/layoutPMI.csv	2011-11-13 16:54:25 +0000
@@ -5,5 +5,12 @@
 "PMI","Transportation access",1,"[['PMI-Tra-1', 'PMI-Tra-2'], ['PMI-Tra-3']]"
 "PMI","Shelter",1,"[['PMI-Shl-', 'PMI-Shl-7', 'PMI-Shl-8', 'PMI-Shl-9'], ['PMI-Shl-10']]"
 "PMI","Water and Sanitation",1,"[['PMI-WASH-A-'],['PMI-WASH-B-','PMI-WASH-51','PMI-WASH-52','PMI-WASH-53','PMI-WASH-54'],['PMI-WASH-55','PMI-WASH-56','PMI-WASH-57'],['PMI-WASH-58'],['PMI-WASH-59'],['PMI-WASH-60'],['PMI-WASH-61','PMI-WASH-62','PMI-WASH-63','PMI-WASH-64'],['PMI-WASH-65','PMI-WASH-66','PMI-WASH-67','PMI-WASH-68','PMI-WASH-69','PMI-WASH-70'],['PMI-WASH-71'],['PMI-WASH-72'],['PMI-WASH-73'],['PMI-WASH-74','PMI-WASH-75','PMI-WASH-76','PMI-WASH-77','PMI-WASH-78','PMI-WASH-79','PMI-WASH-80'],['PMI-WASH-81','PMI-WASH-82','PMI-WASH-83'],['PMI-WASH-84','PMI-WASH-85']]"
-"PMI","Food",1,
-"PMI","Health",1,
+"PMI","Food",1,"[[{'columns':[['PMI-Food-1', 'PMI-Food-2', 'PMI-Food-3', 'PMI-Food-4', 'PMI-Food-5', 'PMI-Food-6', 'PMI-Food-7', 'PMI-Food-8'],['PMI-Food-9', 'PMI-Food-10', 'PMI-Food-11', 'PMI-Food-12', 'PMI-Food-13']]}]]"
+"PMI","Health",1,"[[{'columns':[['PMI-Health-1', 'PMI-Health-2', 'PMI-Health-3'],['PMI-Health-4'],['PMI-Health-A-']]}],[{'columns':[['PMI-Health-B-'],['PMI-Health-33', 'PMI-Health-34'],[{'heading':'Baseline data'},'PMI-Health-35', 'PMI-Health-36']]}],[{'columns':[['PMI-Health-37', 'PMI-Health-38'],['PMI-Health-39']]}]]"
+"PMI","Restoring Family Links",1,"[['PMI-RFI-1',{'columns':[['PMI-RFI-2', 'PMI-RFI-3']]},['PMI-RFI-A-']],[[{'columns':[['PMI-RFI-B-', 'PMI-RFI-18', 'PMI-RFI-19']]}],{'columns':[[{'heading':'For those who died'}, 'PMI-RFI-14', 'PMI-RFI-15', 'PMI-RFI-16','PMI-RFI-17']]}]]"
+"PMI","Psychosocial support",1,"[['PMI-PSP-1', 'PMI-PSP-2', 'PMI-PSP-3'], [{'columns':[['PMI-PSP-4', 'PMI-PSP-5']]}, 'PMI-PSP-6', 'PMI-PSP-7']]"
+"PMI","Non-Food Items",1,"[['PMI-NFI1', 'PMI-NFI-2','PMI-NFI-3']]"
+"PMI","Logistic information ",1,"[['PMI-Log-1', 'PMI-Log-2', 'PMI-Log-3', 'PMI-Log-4']]"
+"PMI","IT Telecom",1,"[[{'columns':[['PMI-ICT-1', 'PMI-ICT-2', 'PMI-ICT-3', 'PMI-ICT-4', 'PMI-ICT-5', 'PMI-ICT-6', 'PMI-ICT-7', 'PMI-ICT-8']]}, 'PMI-ICT-9', 'PMI-ICT-10']]"
+"PMI","PMI action and other organisation",1,
+"PMI","Recommendations",1,

=== modified file 'private/prepopulate/demo/ADAT/questionnairePMI.csv'
--- private/prepopulate/demo/ADAT/questionnairePMI.csv	2011-11-04 05:47:13 +0000
+++ private/prepopulate/demo/ADAT/questionnairePMI.csv	2011-11-13 16:54:25 +0000
@@ -1,94 +1,133 @@
 "Template","Template Description","Complete Question","Date Question","Time Question","Location Question","Priority Question","Section","Section Position","Question","Question Type","Question Notes","Question Position","Question Code","Meta Data"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Assessment data",1,"Date","Date",,1,"PMI-Ass-1",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Assessment data",1,"Type of assessment","OptionOther",,2,"PMI-Ass-2","{'Length':'3','1':'Early','2':'Continue','Other':'String'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Assessment data",1,"Location","Option",,3,"PMI-Ass-3","{'Length':'5','1':'Where the disaster happened','2':'IDPs camp','3':'Relocation camp','4':'Return to origin place','5':'Local community - in situ'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"Province","Location",,4,"PMI-Gen-1",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"District","Location",,5,"PMI-Gen-2",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"Sub District","Location",,6,"PMI-Gen-3",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"Village","Location",,7,"PMI-Gen-4",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"Sub Village","Location",,8,"PMI-Gen-5",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"Name of Location","Location",,9,"PMI-Gen-6",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"Type of disaster event","OptionOther",,10,"PMI-Gen-7","{'Length':'4','1':'Natural Disaster','2':'Conflict','3':'Accident','Other':'String'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"Cause of the catastrophic event","String",,11,"PMI-Gen-8",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"General",2,"When it happened","String",,12,"PMI-Gen-9",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"No of Households","Numeric",,13,"PMI-Dem-1",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"No of Individuals","Numeric",,14,"PMI-Dem-2",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"Population","Grid",,15,"PMI-Dem-","{'Subtitle':'Population','QuestionNo':'3','col-cnt':'2','row-cnt':'6','columns': ['Male','Female'],'rows': ['No of Babies 0-5 years old','No of Children 6-12 years old','No of Age  12-20 years old','No of Age 21-60 years old','No of Elderly >60 years old','No of Disabled people'],'data': [['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric']]}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"No of Pregnant Women","Numeric",,28,"PMI-Dem-15",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"No of Lactating Mothers","Numeric",,29,"PMI-Dem-16",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"No of Women as head of household","Numeric",,30,"PMI-Dem-17",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"Name","String",,31,"PMI-Dem-18",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"Organisation","String",,32,"PMI-Dem-19",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"Contact Details","String",,33,"PMI-Dem-20",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Demographic data",3,"Comment","Text",,34,"PMI-Dem-21",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Transportation access",4,"Access to location","MultiOption",,35,"PMI-Tra-1","{'Length':'3','1':'Land','2':'Water','3':'Air'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Transportation access",4,"Type of vehicle that works","String",,36,"PMI-Tra-2",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Transportation access",4,"Comment (condition of the access with influence of the coming climate event) ","Text",,37,"PMI-Tra-3",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Shelter",5,"Type","Grid",,38,"PMI-Shl-","{'Subtitle':'Type','QuestionNo':'1','col-cnt':'2','row-cnt':'3','columns':['Number of Units','Total IDPs'],'rows':['temporary','semi permanent','permanent'],'data':[['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric']]}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Shelter",5,"Materials","MultiOption",,45,"PMI-Shl-7","{'Length':'5','1':'Family tent','2':'Platoon','3':'Tent tarpaulin','4':'Roof leafs','5':'Other'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Shelter",5,"Location","MultiOption",,46,"PMI-Shl-8","{'Length':'5','1':'Soccer field','2':'Worship building','3':'Office building','4':'Roof leafs','5':'Other'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Shelter",5,"Source of information","String",,47,"PMI-Shl-9",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Shelter",5,"Comment on surrounding condition","Text",,48,"PMI-Shl-10",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Water Source","Grid",,49,"PMI-WASH-A-","{'Subtitle':'Water - Water supply','QuestionNo':'1','col-cnt':'6','row-cnt':'7','columns':['How many','Covered','Colour?','Smell?','Taste?','Quantity'],'rows':['Water Spring','Well','Rain Water','River','Water Canal','Government Water','Other...'],'data':[['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option']],'PMI-WASH-A-6':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-12':{'Length':'2','1':'Enough','2':'Not Enough'}, 'PMI-WASH-A-18':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-24':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-30':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-36':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-42':{'Length':'2','1':'Enough','2':'Not Enough'}}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Water Container ","Grid",,92,"PMI-WASH-B-","{'Subtitle':'Water Container','QuestionNo':'43','col-cnt':'2','row-cnt':'4','columns':['Number of item','Capacity- litres'],'rows':['Water Tank','Water Container','Water Bucket','Jerry Can'],'data':[['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric']]}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Distance in Km","Numeric",,101,"PMI-WASH-51",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Time to reach by foot","Numeric",,102,"PMI-WASH-52",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Time to reach by vehicle","Numeric",,103,"PMI-WASH-53",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"In need of Repair","YesNo",,104,"PMI-WASH-54",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Treatment needed toward water quality","Option",,105,"PMI-WASH-55","{'Length':'3','1':'Water purifier','2':'Container cleaning','3':'Cover'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Treatment to water storage","Option",,106,"PMI-WASH-56","{'Length':'2','1':'Open','2':'Covered'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Treatment to water use","Option",,107,"PMI-WASH-57","{'Length':'2','1':'hygienic','2':'un-hygienic'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Community’s expectation ","Text",,108,"PMI-WASH-58",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Recommendations","Text",,109,"PMI-WASH-59",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Sanitation ","MultiOption",,110,"PMI-WASH-60","{'Length':'4','1':'Open space','2':'Covered','3':'Public','4':'Family Owned, Private'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Specific toilets for male and female","YesNo",,111,"PMI-WASH-61",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Distance in meters","Numeric",,112,"PMI-WASH-62",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Duration to reach in minutes","Numeric",,113,"PMI-WASH-63",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Type of Toilet","Option",,114,"PMI-WASH-64","{'Length':'3','1':'Semi permanent','2':'Permanent','3':'Emergency'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Likelihood to pollute water source ","YesNo",,115,"PMI-WASH-65",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Liklihood to become the source of diseases ","YesNo",,116,"PMI-WASH-66",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Are these available?","MultiOption",,117,"PMI-WASH-67","{'Length':'3','1':'Water','2':'Soap','3':'Clean up tools'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Grey water soakaway","Option",,118,"PMI-WASH-68","{'Length':'2','1':'Septic Tank','2':'Traditional'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Need support","YesNo",,119,"PMI-WASH-69",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Type of support?","String",,120,"PMI-WASH-70",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Number of toilets","Numeric",,121,"PMI-WASH-71",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Community’s expectation ","Text",,122,"PMI-WASH-72",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"More comments?","Text",,123,"PMI-WASH-73",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Source of garbage","Option",,124,"PMI-WASH-74","{'Length':'3','1':'Household','2':'Field Kitchen','3':'Hospital'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Type of collection","OptionOther",,125,"PMI-WASH-75","{'Length':'2','1':'Specific Container','2':'Drum'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Transportation","OptionOther",,126,"PMI-WASH-76","{'Length':'2','1':'Cart','2':'Trucks'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Do they differentiate between organic and non organic ?","YesNo",,127,"PMI-WASH-77",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Treatment","MultiOption",,128,"PMI-WASH-78","{'Length':'5','1':'Buried','2':'Burned out','3':'Incinerator','4':'Transported to garbage collection area','5':'Other'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Temporary garbage collection area nearby","YesNo",,129,"PMI-WASH-79",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"If available what capacity","Numeric",,130,"PMI-WASH-80",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Disease vectors that might be triggered by this situation ","MultiOption",,131,"PMI-WASH-81","{'Length':'6','1':'Mouse','2':'Mosquito','3':'Flea','4':'Fly','5':'Cockroach','6':'Other'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Need vector control?","YesNo",,132,"PMI-WASH-82",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"If yes what type of vector control?","String",,133,"PMI-WASH-83",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Health promotion within the IDPs camp? ","YesNo",,134,"PMI-WASH-84",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Water and Sanitation",6,"Source of information ","String",,135,"PMI-WASH-85",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Cattle/food stocks","YesNo",,136,"PMI-Food-1",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Agriculture","YesNo",,137,"PMI-Food-2",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Fishery","YesNo",,138,"PMI-Food-3",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Gather","YesNo",,139,"PMI-Food-4",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Aid","YesNo",,140,"PMI-Food-5",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Barter","YesNo",,141,"PMI-Food-6",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Purchase","YesNo",,142,"PMI-Food-7",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Others","String",,143,"PMI-Food-8",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Type of staple food","String",,144,"PMI-Food-9",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"General challenges on the food access?","String",,145,"PMI-Food-10",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"How frequent the meal per day","Option",,146,"PMI-Food-11","{'Length':'3','1':'1 times','2':'2 times','3':'3 times'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Comments","String",,147,"PMI-Food-12",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Food",7,"Source of information ","String",,148,"PMI-Food-13",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Heavily Injured","Numeric",,149,"PMI-Health-1",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Medium Injured","Numeric",,150,"PMI-Health-2",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Death","Numeric",,151,"PMI-Health-3",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Health facility","MultiOption",,152,"PMI-Health-4","{'Length':'8','1':'Hospital','2':'Puskesmas','3':'Pustu','4':'Polindes','5':'Private clinic','6':'Field clinic','7':'Satelite clinic','8':'Other'}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Frequent diseases","Grid",,153,"PMI-Health-A-","{'QuestionNo':'5','col-cnt':'2','row-cnt':'9','columns': ['Occurance','Number of cases'],'rows': ['Diarrhoea','ARI','Skin diseases','Malaria','Plague','Malnutrition','DHF','TB','Other'],'data': [['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['String','Numeric']]}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Health personnel","Grid",,171,"PMI-Health-B-","{'QuestionNo':'23','col-cnt':'2','row-cnt':'5','columns': ['Employed','Number'],'rows': ['Doctor','Nurse','Midwives','Pharmacist','Environmentalist'],'data': [['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric']]}"
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Ambulance","YesNo",,181,"PMI-Health-33",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Medicine available","YesNo",,182,"PMI-Health-34",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Birth Rate","Numeric",,183,"PMI-Health-35",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Mortality rate","Numeric",,184,"PMI-Health-36",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Health issues identified?","String",,185,"PMI-Health-37",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Other health related urgent needs?","String",,186,"PMI-Health-38",
-"PMI","Emergency assessment form PMI",,"PMI-Ass-1",,"PMI-Gen-6",,"Health",8,"Source of information","String",,187,"PMI-Health-39",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Assessment data",1,"Date","Date",,1,"PMI-Ass-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Assessment data",1,"Type of assessment","OptionOther",,2,"PMI-Ass-2","{'Length':'2','1':'Early','2':'Continue'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Assessment data",1,"Location","Option",,3,"PMI-Ass-3","{'Length':'5','1':'Where the disaster happened','2':'IDPs camp','3':'Relocation camp','4':'Return to origin place','5':'Local community - in situ'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"Province","Location",,4,"PMI-Gen-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"District","Location",,5,"PMI-Gen-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"Sub District","Location",,6,"PMI-Gen-3",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"Village","Location",,7,"PMI-Gen-4",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"Sub Village","Location",,8,"PMI-Gen-5",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"Name of Location","Location",,9,"PMI-Gen-6",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"Type of disaster event","OptionOther",,10,"PMI-Gen-7","{'Length':'3','1':'Natural Disaster','2':'Conflict','3':'Accident'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"Cause of the catastrophic event","String",,11,"PMI-Gen-8",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","General",2,"When it happened","String",,12,"PMI-Gen-9",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"No of Households","Numeric",,13,"PMI-Dem-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"No of Individuals","Numeric",,14,"PMI-Dem-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"Population","Grid",,15,"PMI-Dem-","{'Subtitle':'Population','QuestionNo':'3','col-cnt':'2','row-cnt':'6','columns': ['Male','Female'],'rows': ['No of Babies 0-5 years old','No of Children 6-12 years old','No of Age  12-20 years old','No of Age 21-60 years old','No of Elderly >60 years old','No of Disabled people'],'data': [['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric']]}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"No of Pregnant Women","Numeric",,28,"PMI-Dem-15",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"No of Lactating Mothers","Numeric",,29,"PMI-Dem-16",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"No of Women as head of household","Numeric",,30,"PMI-Dem-17",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"Name","String",,31,"PMI-Dem-18",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"Organisation","String",,32,"PMI-Dem-19",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"Contact Details","String",,33,"PMI-Dem-20",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Demographic data",3,"Comment","Text",,34,"PMI-Dem-21",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Transportation access",4,"Access to location","MultiOption",,35,"PMI-Tra-1","{'Length':'3','1':'Land','2':'Water','3':'Air'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Transportation access",4,"Type of vehicle that works","String",,36,"PMI-Tra-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Transportation access",4,"Comment (condition of the access with influence of the coming climate event) ","Text",,37,"PMI-Tra-3",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Shelter",5,"Type","Grid",,38,"PMI-Shl-","{'Subtitle':'Type','QuestionNo':'1','col-cnt':'2','row-cnt':'3','columns':['Number of Units','Total IDPs'],'rows':['temporary','semi permanent','permanent'],'data':[['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric']]}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Shelter",5,"Materials","MultiOption",,45,"PMI-Shl-7","{'Length':'5','1':'Family tent','2':'Platoon','3':'Tent tarpaulin','4':'Roof leafs','5':'Other'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Shelter",5,"Location","MultiOption",,46,"PMI-Shl-8","{'Length':'5','1':'Soccer field','2':'Worship building','3':'Office building','4':'Roof leafs','5':'Other'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Shelter",5,"Source of information","String",,47,"PMI-Shl-9",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Shelter",5,"Comment on surrounding condition","Text",,48,"PMI-Shl-10",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Water Source","Grid",,49,"PMI-WASH-A-","{'Subtitle':'Water - Water supply','QuestionNo':'1','col-cnt':'6','row-cnt':'7','columns':['How many','Covered','Colour?','Smell?','Taste?','Quantity'],'rows':['Water Spring','Well','Rain Water','River','Water Canal','Government Water','Other...'],'data':[['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option'], ['Numeric','YesNo','String','String','String','Option']],'PMI-WASH-A-6':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-12':{'Length':'2','1':'Enough','2':'Not Enough'}, 'PMI-WASH-A-18':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-24':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-30':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-36':{'Length':'2','1':'Enough','2':'Not Enough'},'PMI-WASH-A-42':{'Length':'2','1':'Enough','2':'Not Enough'}}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Water Container ","Grid",,92,"PMI-WASH-B-","{'Subtitle':'Water Container','QuestionNo':'43','col-cnt':'2','row-cnt':'4','columns':['Number of item','Capacity- litres'],'rows':['Water Tank','Water Container','Water Bucket','Jerry Can'],'data':[['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric'], ['Numeric','Numeric']]}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Distance in Km","Numeric",,101,"PMI-WASH-51",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Time to reach by foot","Numeric",,102,"PMI-WASH-52",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Time to reach by vehicle","Numeric",,103,"PMI-WASH-53",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"In need of Repair","YesNo",,104,"PMI-WASH-54",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Treatment needed toward water quality","Option",,105,"PMI-WASH-55","{'Length':'3','1':'Water purifier','2':'Container cleaning','3':'Cover'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Treatment to water storage","Option",,106,"PMI-WASH-56","{'Length':'2','1':'Open','2':'Covered'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Treatment to water use","Option",,107,"PMI-WASH-57","{'Length':'2','1':'hygienic','2':'un-hygienic'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Community’s expectation ","Text",,108,"PMI-WASH-58",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Recommendations","Text",,109,"PMI-WASH-59",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Sanitation ","MultiOption",,110,"PMI-WASH-60","{'Length':'4','1':'Open space','2':'Covered','3':'Public','4':'Family Owned, Private'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Specific toilets for male and female","YesNo",,111,"PMI-WASH-61",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Distance in meters","Numeric",,112,"PMI-WASH-62",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Duration to reach in minutes","Numeric",,113,"PMI-WASH-63",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Type of Toilet","Option",,114,"PMI-WASH-64","{'Length':'3','1':'Semi permanent','2':'Permanent','3':'Emergency'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Likelihood to pollute water source ","YesNo",,115,"PMI-WASH-65",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Liklihood to become the source of diseases ","YesNo",,116,"PMI-WASH-66",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Are these available?","MultiOption",,117,"PMI-WASH-67","{'Length':'3','1':'Water','2':'Soap','3':'Clean up tools'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Grey water soakaway","Option",,118,"PMI-WASH-68","{'Length':'2','1':'Septic Tank','2':'Traditional'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Need support","YesNo",,119,"PMI-WASH-69",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Type of support?","String",,120,"PMI-WASH-70",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Number of toilets","Numeric",,121,"PMI-WASH-71",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Community’s expectation ","Text",,122,"PMI-WASH-72",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"More comments?","Text",,123,"PMI-WASH-73",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Source of garbage","Option",,124,"PMI-WASH-74","{'Length':'3','1':'Household','2':'Field Kitchen','3':'Hospital'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Type of collection","OptionOther",,125,"PMI-WASH-75","{'Length':'2','1':'Specific Container','2':'Drum'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Transportation","OptionOther",,126,"PMI-WASH-76","{'Length':'2','1':'Cart','2':'Trucks'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Do they differentiate between organic and non organic ?","YesNo",,127,"PMI-WASH-77",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Treatment","MultiOption",,128,"PMI-WASH-78","{'Length':'5','1':'Buried','2':'Burned out','3':'Incinerator','4':'Transported to garbage collection area','5':'Other'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Temporary garbage collection area nearby","YesNo",,129,"PMI-WASH-79",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"If available what capacity","Numeric",,130,"PMI-WASH-80",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Disease vectors that might be triggered by this situation ","MultiOption",,131,"PMI-WASH-81","{'Length':'6','1':'Mouse','2':'Mosquito','3':'Flea','4':'Fly','5':'Cockroach','6':'Other'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Need vector control?","YesNo",,132,"PMI-WASH-82",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"If yes what type of vector control?","String",,133,"PMI-WASH-83",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Health promotion within the IDPs camp? ","YesNo",,134,"PMI-WASH-84",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Water and Sanitation",6,"Source of information ","String",,135,"PMI-WASH-85",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Cattle/food stocks","YesNo",,136,"PMI-Food-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Agriculture","YesNo",,137,"PMI-Food-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Fishery","YesNo",,138,"PMI-Food-3",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Gather","YesNo",,139,"PMI-Food-4",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Aid","YesNo",,140,"PMI-Food-5",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Barter","YesNo",,141,"PMI-Food-6",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Purchase","YesNo",,142,"PMI-Food-7",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Others","String",,143,"PMI-Food-8",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Type of staple food","String",,144,"PMI-Food-9",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"General challenges on the food access?","String",,145,"PMI-Food-10",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"How frequent the meal per day","Option",,146,"PMI-Food-11","{'Length':'3','1':'1 times','2':'2 times','3':'3 times'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Comments","String",,147,"PMI-Food-12",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Food",7,"Source of information ","String",,148,"PMI-Food-13",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Heavily Injured","Numeric",,149,"PMI-Health-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Medium Injured","Numeric",,150,"PMI-Health-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Death","Numeric",,151,"PMI-Health-3",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Health facility","MultiOption",,152,"PMI-Health-4","{'Length':'8','1':'Hospital','2':'Puskesmas','3':'Pustu','4':'Polindes','5':'Private clinic','6':'Field clinic','7':'Satelite clinic','8':'Other'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Frequent diseases","Grid",,153,"PMI-Health-A-","{'QuestionNo':'5','col-cnt':'2','row-cnt':'9','columns': ['Occurance','Number of cases'],'rows': ['Diarrhoea','ARI','Skin diseases','Malaria','Plague','Malnutrition','DHF','TB','Other'],'data': [['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['String','Numeric']]}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Health personnel","Grid",,171,"PMI-Health-B-","{'QuestionNo':'23','col-cnt':'2','row-cnt':'5','columns': ['Employed','Number'],'rows': ['Doctor','Nurse','Midwives','Pharmacist','Environmentalist'],'data': [['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric']]}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Ambulance","YesNo",,181,"PMI-Health-33",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Medicine available","YesNo",,182,"PMI-Health-34",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Birth Rate","Numeric",,183,"PMI-Health-35",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Mortality rate","Numeric",,184,"PMI-Health-36",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Health issues identified?","String",,185,"PMI-Health-37",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Other health related urgent needs?","String",,186,"PMI-Health-38",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Health",8,"Source of information","String",,187,"PMI-Health-39",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Are there any victim that lost contact with his/her relatives?","YesNo",,188,"PMI-RFI-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Communication access","Option",,189,"PMI-RFI-2","{'Length':'2','1':'Easy','2':'Difficult'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"If difficult why?","String",,190,"PMI-RFI-3",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Vulnerable groups separated with their families","Grid",,191,"PMI-RFI-A-","{'QuestionNo':'4','col-cnt':'1','row-cnt':'4','columns': ['Separated'],'rows': ['Children < 18','Elderly','Disabled','Pregnant mothers'],'data': [['YesNo'], ['YesNo'], ['YesNo'], ['YesNo']]}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Any RFL support need at these areas","Grid",,195,"PMI-RFI-B-","{'QuestionNo':'8','col-cnt':'2','row-cnt':'3','columns': ['Support Needed','Number'],'rows': ['IDP camps','Orphanage','Other'],'data': [['YesNo','Numeric'], ['YesNo','Numeric'], ['YesNo','Numeric']]}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Evacuated to hospital","YesNo",,201,"PMI-RFI-14",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Taken by family","YesNo",,202,"PMI-RFI-15",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Other","String",,203,"PMI-RFI-16",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"Referral hospital for victims who died","String",,204,"PMI-RFI-17",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"RFL contact person","Option",,205,"PMI-RFI-18","{'Length':'2','1':'Available','2':'Not Available'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Restoring Family Links",9,"If available, contact details:","String",,206,"PMI-RFI-19",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Psychosocial support",10,"Any significant changes of community/personal behaviour after the disaster?","YesNo",,207,"PMI-PSP-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Psychosocial support",10,"Daily activity before the disaster?","String",,208,"PMI-PSP-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Psychosocial support",10,"Daily activity after the disaster?","String",,209,"PMI-PSP-3",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Psychosocial support",10,"Potential human resource to run PSP","Option",,210,"PMI-PSP-4","{'Length':'2','1':'Available','2':'Not Available'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Psychosocial support",10,"If available, who","String",,211,"PMI-PSP-5",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Psychosocial support",10,"Type of PSP activities recommended:","String",,212,"PMI-PSP-6",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Psychosocial support",10,"Source of info:","String",,213,"PMI-PSP-7",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Non-Food Items",11,"Do they need these?","MultiOption",,214,"PMI-NFI1","{'Length':'10','1':'Kitchen kits','2':'Sleeping mat','3':'Blanket','4':'Clothes','5':'Hygiene kits','6':'Jerry can','7':'Tarpaulin','8':'Baby kits','9':'Female needs','10':'Others'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Non-Food Items",11,"More comments","Text",,215,"PMI-NFI-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Non-Food Items",11,"Source of info:","String",,216,"PMI-NFI-3",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Logistic information ",12,"Economic activity ","Option",,217,"PMI-Log-1","{'Length':'2','1':'Normal','2':'Not Normal'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Logistic information ",12,"Market still functioning","YesNo",,218,"PMI-Log-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Logistic information ",12,"Access of transportation ","Option",,219,"PMI-Log-3","{'Length':'2','1':'Functioning','2':'Not Functioning'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Logistic information ",12,"Any storage nearby","YesNo",,220,"PMI-Log-4",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Telephone","Option",,221,"PMI-ICT-1","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Mobile phone","Option",,222,"PMI-ICT-2","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Communication Radio ","Option",,223,"PMI-ICT-3","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Internet","Option",,224,"PMI-ICT-4","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Fax","Option",,225,"PMI-ICT-5","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Telex","Option",,226,"PMI-ICT-6","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Telegram","Option",,227,"PMI-ICT-7","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Postal services ","Option",,228,"PMI-ICT-8","{'Length':'4','1':'Fully Functioning','2':'Partially Functioning','3':'Not Functioning','4':'Non Existent'}"
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"Source of info:","String",,229,"PMI-ICT-9",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","IT Telecom",13,"More comments","String",,230,"PMI-ICT-10",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","PMI action and other organisation",14,"PMI","Text",,231,"PMI-PMI-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","PMI action and other organisation",14,"Other organisations","Text",,232,"PMI-PMI-2",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Recommendations",15,"Required neeeds for further action:","Text",,233,"PMI-Rec-1",
+"PMI","Emergency assessment form PMI","PMI-Dem-18","PMI-Ass-1",,"PMI-Gen-6","PMI-Health-2","Recommendations",15,"Signature of assessor / Position:","String",,234,"PMI-Rec-2",

=== added file 'static/formats/s3csv/Updated_List'
--- static/formats/s3csv/Updated_List	1970-01-01 00:00:00 +0000
+++ static/formats/s3csv/Updated_List	2011-11-13 16:54:25 +0000
@@ -0,0 +1,59 @@
+On 6th November 2011 work was started to standardise the names used in the xsl files.
+This is recording the progress of that work
+
+Files Completed
+===============
+
+
+Files yet to be changed
+=======================
+asset/asset.xsl
+auth/user.xsl
+gis/location.xsl
+hrm/competency_rating.xsl
+hrm/person.xsl
+hrm/skill.xsl
+inv_item.xsl
+inv/recv_item.xsl
+inv/send_item.xsl
+inv/warehouse.xsl *** probably should be deprecated ***
+org/office.xsl
+org/organisation.xsl
+org/sector.xsl
+req/req.xsl
+req/req_item.xsl
+supply/eric.xsl
+supply/eric_supply_item_category.xsl
+supply/supply_items.xsl
+survey/complete.xsl
+survey/formatter.xsl
+survey/question_list.xsl
+
+Header name changes
+*******************
+
+For file asset/asset.xsl
+
+Old Name                    New Name
+========                    ========
+id                          used for tuid
+Organisation                asset_log.organisation_id.name
+Acronym                     asset_log.organisation_id.acronym
+Office                      asset_log.site_id
+Code                        asset_log.site_id.code
+Catalog                     supply_catalog_item.catalog_id
+Asset No                    number
+Type                        type
+Category                    supply_catalog_item.item_category_id
+Name                        supply_item.name
+Location                    asset_log.room_id
+Assigned To                 pr_person.first_name
+Brand                       supply_brand.brand_id
+Model                       supply_item.model
+SN                          sn
+Supplier                    supplier
+Date                        purchase_date
+Price                       purchase_price
+Comments                    comments
+
+

=== modified file 'static/formats/s3csv/org/organisation.xsl'
--- static/formats/s3csv/org/organisation.xsl	2011-11-11 08:37:00 +0000
+++ static/formats/s3csv/org/organisation.xsl	2011-11-13 16:54:25 +0000
@@ -32,6 +32,7 @@
 
     *********************************************************************** -->
     <xsl:include href="../../../../static/formats/xml/countries.xsl"/>
+    <xsl:include href="../../../../static/formats/xml/functions.xsl"/>
 
 	<!-- Template to create an org_sector resource from the value passed in -->
 	<xsl:template name="resource">
@@ -54,6 +55,7 @@
                 <xsl:variable name="sector" select="col[@field='sector']"/>
     			<xsl:call-template name="splitList">
     				 <xsl:with-param name="list" select="$sector"/>
+    				 <xsl:with-param name="splitsep" select="string(',')"/>
     			</xsl:call-template>
 
                 <!-- Create the Organisation -->
@@ -104,6 +106,8 @@
                     <xsl:variable name="qlist">
             			<xsl:call-template name="quoteList">
             				 <xsl:with-param name="list" select="$sector"/>
+            				 <xsl:with-param name="splitsep" select="string(',')"/>
+            				 <xsl:with-param name="joinsep" select="string(',')"/>
             			</xsl:call-template>
         			</xsl:variable>
                     <reference field="sector_id" resource="org_sector">

=== modified file 'static/formats/s3csv/survey/complete.xsl'
--- static/formats/s3csv/survey/complete.xsl	2011-11-11 00:02:42 +0000
+++ static/formats/s3csv/survey/complete.xsl	2011-11-13 16:54:25 +0000
@@ -78,7 +78,7 @@
                         </xsl:when>
                         <xsl:otherwise>
                             <xsl:if test=".!=''">
-                                <xsl:value-of select="concat('&quot;', @field, '&quot;,&quot;',.,$newline)"/>
+                                <xsl:value-of select="concat('&quot;', @field, '&quot;,&quot;',.,'&quot;',$newline)"/>
                             </xsl:if>
                         </xsl:otherwise>
                     </xsl:choose>

=== added directory 'static/img/logo'
=== added file 'static/img/logo/ifrc_logo.bmp'
Binary files static/img/logo/ifrc_logo.bmp	1970-01-01 00:00:00 +0000 and static/img/logo/ifrc_logo.bmp	2011-11-13 16:54:25 +0000 differ