{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["ChangeLog","TestCases","Sheet1","Req Coverage"],"not_rendered":{"macros":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"ChangeLog","index":0,"n_rows":19,"n_cols":3,"rows_kept":19}
[]
[null,"Version","Modification"]
[null,20120314,"Initial release"]
[null,20130502,"Add Requirement coverage counter to help user to define the expected coverage of the Requirement document\nAdd verification of < and > characters in TestCase Name\nAdd auto replacement of double quote character in TestCase Name\nSet importance to Medium for testCases if information is not filled by user\nAdd verification of < and > characters in TestCase Step & Results"]
[null,20130530,"Bug correction in Custom Field generation\nThe way to generate the XML has been reviewed\nAdd Comments on each column header to explain which values can be used"]
[null,20140402,"Add the ability to save TestCases ordered in a tree\nAdd the export log function when something is wrong"]
[null,20140415,"Add the ability to define the 'estimated execution duration' XML tag\nExcel file checks the text length to alert user when max length is reached. If max is reached, each cell is displayed with red background\nTestSuite Name : 75 chars\nTesctCase Name : 100 chars"]
[null,20140724,"Modify the type of custom fields in the XML generation : CDATA is now used (works but is not documented by TestLink)."]
[null,20140819,"Add the ability to import a XML file exported from TestLink to modify Testcase content\nTC# is renamed \"External ID\" and is more specific\nBug correction : values in a hidden column are now used during XML generation"]
[null,20141214,"Better TestLink Import Functions capabilities : you can use & and < char in all columns except A and D"]
[null,20150331,"Bug correction : Unable to import complex tree from TestLink (more than sub-sub-sub tree (level 4). Now the limit is on level 10.\n    Dim TestSuiteName(0 To 10) As String\n    Dim TestSuiteDetails(0 To 10) As String"]
[null,20150817,"Bug correction : Excel advanced filter doesn't provide a good duplicate filter in requirement counter page"]
[null,20151009,"Bug correction : replace FrenchChar in testcase name BEFORE check if forbidden char is present"]
[null,20160219,"Bug correction : Import TestCases is wrong when custom_fields are used"]
[null,20160311,"Add the ability to import and export Status of each testcase\nAdd the ability to import Custom Fields linked to a testcase from XML file\nAdd the ability to import and export keywords linked to a testcase"]
[null,20160331,"Add GUI to display Import progression"]
[null,20161015,"Fix Error Detection problem in TestCases content"]
[null,20170424,"Update defaut values for displayed and hidden cells"]
[null,20180517,"Add Attachments Capabilities"]

{"sheet":"TestCases","index":1,"n_rows":245,"n_cols":19,"rows_kept":245,"merged":[[0,0,0,1],[0,2,0,9],[0,11,0,12],[0,13,0,15],[0,16,0,17]]}
["Test Suite",null,"Test Case",{"$nulls":7},"Attachments","Custom Fields",null,"Steps",null,null,"Coverage",null,"Time Management"]
["Name","Details",null,"Name","Summary","PreConditions","Status","ExecutionType","Importance","Keywords","Number of Attachments",null,null,"Step","Expected Result","StepExec\nType","Spec Title","Document ID","Estimated exec. Duration"]
["Android","Mobile phone test"]
["Set up of Master data","uploading of master data (online)"]
[{"$nulls":3},"on launch master data upload","upload the app with basic data needed to run the app","app is installated but not started yet, internet is available\nEnrolment Officer ID was created on the web application before the master data was downloaded on the IMIS Policy App",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, and you are asked if you would like to download the master data"]
[{"$nulls":13},"Select Yes to downloading the master data","Master data is downloaded and prompt comes to enter your Enrolment Officer ID"]
[{"$nulls":13},"Enter valid enrolment officer ID","You sucessfully login to the app and reach the Home page"]
[{"$nulls":3},"update the master data","in case changes are made to the web application (eg. New product or enrolment officer created) there is a need to update the master data","app is installated, has been used to undertake transactions already, internet is available",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open and takes you to Home page"]
[{"$nulls":13},"go on the sync menu","The Sync page opens with all upload/download options"]
[{"$nulls":13},"Select Download Master Data","Enter valid login credentials of Enrolment Officer to get a message master data was successfully downloaded"]
[{"$nulls":13},"Select Ok"," You will return to Sync page options"]
["Android","Mobile phone test"]
["Set up of Master data","uploading of master data (offline)"]
[{"$nulls":3},"on launch master data upload in offline mode","upload the app with basic data needed to run the app without internet","app is installated but not started yet, internet is not available\nEnrolment Officer ID was created on the web application before the master data was downloaded on the IMIS Policy App",null,null,2,{"$nulls":4},"Login to web application with admin credentials","You willcome to home page of web application"]
[{"$nulls":13},"Go to Tools and then to Extracts page","You will see all download and upload options through Extracts"]
[{"$nulls":13},"Click on Download Master Data","You will see a file download prompt"]
[{"$nulls":13},"Download and Save the file on your computer","The file is downloaded successfully"]
[{"$nulls":13},"Transfer the downloaded master data file from your computer to the IMIS/Database -> Master data folder on your phone","The file is saved in the IMIS folder on the phone"]
[{"$nulls":13},"Open the Enrollment app: IMIS Policy","enrollment app is open, and you are asked if you would like to download the master data"]
[{"$nulls":13},"Select Yes to downloading the master data","Internet is not available and prompt will ask you whether you would like to upload from .txt file"]
[{"$nulls":13},"Select Yes and then navigate to the folder where you downloaded the master data file and select it","Master data will be uploaded and the Policy App will launch asking for Enrolment Officer ID"]
[{"$nulls":13},"Enter valid enrolment officer ID","You sucessfully login to the app and reach the Home page"]
[{"$nulls":3},"update the master data in offline mode","in case changes are made to the web application (eg. New product or enrolment officer created) there is a need to update the master data even if internet is not available","app is installated, has been used to undertake transactions already, internet is not available",null,null,2,{"$nulls":4},"Login to web application with admin credentials","You willcome to home page of web application"]
[{"$nulls":13},"Go to Tools and then to Extracts page","You will see all download and upload options through Extracts"]
[{"$nulls":13},"Click on Download Master Data","You will see a file download prompt"]
[{"$nulls":13},"Download and Save the file on your computer","The file is downloaded successfully"]
[{"$nulls":13},"Transfer the downloaded master data file from your computer to the IMIS/Database -> Master data folder on your phone to replace the old file","The file is saved in the IMIS folder on the phone"]
[{"$nulls":13},"Open the Enrollment app: IMIS Policy","enrollment app is open and takes you to Home page where new master data file is referred to"]
[{"$nulls":13},"go on the sync menu","The Sync page opens with all upload/download options"]
[{"$nulls":13},"Select Download Master Data","You will gert a prompt that Internet connection is not available and whether you would like to import .txt file from Database folder."]
[{"$nulls":13},"Select Yes and navigate to folder where you saved the file and select the file","You will get a succefully downloaded Master data message and return to the Sync page"]
["Android","Mobile phone test"]
["Enquire","testing of the insuree search funcitons"]
[{"$nulls":3},"enquire valid insuree","find out the insuree status","insuree in IMIS and covered",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment officer ID is asked after the master data download"]
[{"$nulls":13},"go on the enquire menu","the login is required"]
[{"$nulls":13},"enter the Insuree ID of the insuree and search","the application should show the insuree situation: covered"]
[{"$nulls":3},"enquire none existing insuree","find out the insuree status (insuree ID not known)","insuree ID not in IMIS",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, "]
[{"$nulls":13},"go on the enquire menu","the login is required"]
[{"$nulls":13},"enter the Insuree ID of the insuree and search","the application should show an error message saying than insuree ID doesn't exist"]
[{"$nulls":3},"enquire invalid insuree","find out the insuree status","insuree in IMIS but not covered",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, "]
[{"$nulls":13},"go on the enquire menu","the login is required"]
[{"$nulls":13},"enter the Insuree ID of the insuree and search","the application should show the insuree situation: not covered"]
["Android","Mobile phone test"]
["enrollment","testing of the enrollment funcitons"]
[{"$nulls":3},"add familly","adding a new familly, its policy, its payment and contributions","familly and its member not in IMIS",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Acquire","acquire page is opened"]
[{"$nulls":13},"enter the Insuree ID of the insuree, take the photo and submit","message saying that the photo is saved should be displayed"]
[{"$nulls":13},"go back to the main menu","main menu is displayed"]
[{"$nulls":13},"Go on enrollment","enrollment page opens"]
[{"$nulls":13},"Click on the plus (top left)","add familly page open"]
[{"$nulls":13},"fill family data and  next","Familly detail screen should be displayed"]
[{"$nulls":13},"fill data for head of household and save","After entering HH ID Photo should apprear (matching insurance ID introduce in Acquire) and after saving data screen comes back to individual list"]
[{"$nulls":13},"Select the familly and click on policies (top right)","policy page shows"]
[{"$nulls":13},"Click on the plus (top left)","Policy detail page shows"]
[{"$nulls":13},"fill policy data and save","Policy shows in policy list with Status Idle"]
[{"$nulls":13},"click 3 dots on the right of the policy line and click on payment","the contribution/ payment page shows"]
[{"$nulls":13},"enter contribution details and Save","payment entered is registered and screen comes back to listed payments"]
[{"$nulls":13},"go back to policy","the policy is displayed as active"]
[{"$nulls":13},"Go to menu and open Sync","The Sync page opens with all upload/download options"]
[{"$nulls":13},"Select upload enrolments","Page to enter Login name and Password open up"]
[{"$nulls":13},"Enter valid credentials of EO and Login","After successful login screen moves back to Sync screen"]
[{"$nulls":13},"Select Upload Enrolments","The family is uploaded and you get a message that Family was uploaded successfully where you click OK and come back to sync screen"]
[{"$nulls":3},"add familly (when offline)","adding a new familly, its policy, its payment and contributions when offline","familly and its member not in IMIS",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Acquire","acquire page is opened"]
[{"$nulls":13},"enter the Insuree ID of the insuree, take the photo and submit","message saying that the photo is saved should be displayed"]
[{"$nulls":13},"go back to the main menu","main menu is displayed"]
[{"$nulls":13},"Go on enrollment","enrollment page opens"]
[{"$nulls":13},"Click on the plus (top left)","add familly page open"]
[{"$nulls":13},"fill family data and  next","Familly detail screen should be displayed"]
[{"$nulls":13},"fill data for head of household and save","After entering HH ID Photo should apprear (matching insurance ID introduce in Acquire) and after saving data screen comes back to individual list"]
[{"$nulls":13},"Select the familly and click on policies (top right)","policy page shows"]
[{"$nulls":13},"Click on the plus (top left)","Policy detail page shows"]
[{"$nulls":13},"fill policy data and save","Policy shows in policy list with Status Idle"]
[{"$nulls":13},"click 3 dots on the right of the policy line and click on payment","the contribution/ payment page shows"]
[{"$nulls":13},"enter contribution details and Save","payment entered is registered and screen comes back to listed payments"]
[{"$nulls":13},"go back to policy","the policy is displayed as active"]
[{"$nulls":13},"Go to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select Create Enrolments XML","You get a message that XML has been created successfully"]
[{"$nulls":13},"Go to folder IMIS -> Enrolment on the phone","You will see a .rar file with the EO code, date and time of creation in the name of the file"]
[{"$nulls":13},"Copy this file and transfer to a computer and go to web application","Web application login page"]
[{"$nulls":13},"Login using Admin credentials to be able to access the Extracts page under Tools","You will get the display page for Extracts with all upload and download options"]
[{"$nulls":13},"Select Browse under Upload Enrolment and select the enrolment extract file saved on your computer","You get a success message with a summary of enrolments uploaded"]
[{"$nulls":3},"modify a member or family  related data","modify a non existent member","insuree ID not in IMIS",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Modify Family","If not logged in Login page appears"]
[{"$nulls":13},"Add login credentials","Modify page is opened"]
[{"$nulls":13},"Enter indiviudals ID and click search whose family data has to be retrieved for modification","Message is given that Insuree number not found"]
[{"$nulls":3},"modify a member or family related data","modify an exising member in the family","insuree ID is existing in IMIS",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Modify Family","If not logged in Login page appears"]
[{"$nulls":13},"Add login credentials","Modify page is opened"]
[{"$nulls":13},"Enter indiviudals ID and click search whose family data has to be retrieved for modification","The Enrolment screen of the app is opened and the family of the ID entered shows in list of families"]
[{"$nulls":13},"Select the family to modify by clicking on dots on right side and selecting Edit","Family is opened with all family members listed"]
[{"$nulls":13},"Select the individual in the family whose details have to be modified  by clicking on dots on right side and selecting Edit","Screen with individuals details opens"]
[{"$nulls":13},"Modify details of the individual where needed and click on save","The modifications are saved and you come back to screen with family members listed"]
[{"$nulls":13},"Select the familly and click on policies (top right)","policy page shows"]
[{"$nulls":13},"Click on the plus (top left)","Policy detail page shows"]
[{"$nulls":13},"fill policy data and save","Policy shows in policy list with Status Idle"]
[{"$nulls":13},"click 3 dots on the right of the policy line and click on payment","the contribution/ payment page shows"]
[{"$nulls":13},"enter contribution details and Save","payment entered is registered and screen comes back to listed payments"]
[{"$nulls":13},"go back to policy","the policy is displayed as active"]
[{"$nulls":13},"Go to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select upload enrolments","Page to enter Login name and Password open up"]
[{"$nulls":13},"Enter valid credentials of EO and Login","After successful login screen moves back to Sync screen"]
[{"$nulls":13},"Select Upload Enrolments","The family is uploaded and you get a message that Family was uploaded successfully where you click OK and come back to sync screen"]
[{"$nulls":3},"Delete an existing member of a family (except household head - done through web app)","Delete an existing family member","insuree ID of a family member is existing in IMIS",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Modify Family","If not logged in Login page appears"]
[{"$nulls":13},"Add login credentials","Modify page is opened"]
[{"$nulls":13},"Enter indiviudals ID and click search whose family data has to be retrieved for modification","The Enrolment screen of the app is opened and the family of the ID entered shows in list of families"]
[{"$nulls":13},"Select the family to modify by clicking on dots on right side and selecting Edit","Family is opened with all family members listed"]
[{"$nulls":13},"Select the individual in the family whose has to be deleted by selecting the three dots on the right side of the name of the individual","Individual is deleted and you come back to the screen with the remeining members of the family listed"]
[{"$nulls":13},"Select the familly and click on policies (top right)","policy page shows"]
[{"$nulls":13},"Click on the plus (top left)","Policy detail page shows"]
[{"$nulls":13},"fill policy data and save","Policy shows in policy list with Status Idle"]
[{"$nulls":13},"click 3 dots on the right of the policy line and click on payment","the contribution/ payment page shows"]
[{"$nulls":13},"enter contribution details and Save","payment entered is registered and screen comes back to listed payments"]
[{"$nulls":13},"go back to policy","the policy is displayed as active"]
[{"$nulls":13},"Go to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select upload enrolments","Page to enter Login name and Password open up"]
[{"$nulls":13},"Enter valid credentials of EO and Login","After successful login screen moves back to Sync screen"]
[{"$nulls":13},"Select Upload Enrolments","The family is uploaded and you get a message that Family was uploaded successfully where you click OK and come back to sync screen"]
[{"$nulls":3},"upload a modified family in offline mode","after any modification is made to a family the changes are uploaded to the web application in a situation without internet connectivity","family to be modified was already downloaded in the app when internet was available",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Enrolment page","If not logged in Login page appears"]
[{"$nulls":13},"Add login credentials","Enrolment page is opened with the list of families currently on the phone including the downloaded family that is to be modified"]
[{"$nulls":13},"Select the family to be modified","Family page opens listing all members of the family"]
[{"$nulls":13},"Make changes to respective section and save the family","Save is successful"]
[{"$nulls":13},"Go to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select Create Enrolments XML","You get a message that XML has been created successfully"]
[{"$nulls":13},"Go to folder IMIS -> Enrolment on the phone","You will see a .rar file with the EO code, date and time of creation in the name of the file"]
[{"$nulls":13},"Copy this file and transfer to a computer and go to web application","Web application login page"]
[{"$nulls":13},"Login using Admin credentials to be able to access the Extracts page under Tools","You will get the display page for Extracts with all upload and download options"]
[{"$nulls":13},"Select Browse under Upload Enrolment and select the enrolment extract file saved on your computer","You get a success message with a summary of enrolments uploaded"]
[{"$nulls":3},"Add a new member to a family","Add a member to a family","insuree ID of a family member is existing in IMIS",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Modify Family","If not logged in Login page appears"]
[{"$nulls":13},"Add login credentials","Modify page is opened"]
[{"$nulls":13},"Enter indiviudals ID and click search whose family data has to be retrieved for modification","The Enrolment screen of the app is opened and the family of the ID entered shows in list of families"]
[{"$nulls":13},"Select the family to modify by clicking on dots on right side and selecting Edit","Family is opened with all family members listed"]
[{"$nulls":13},"Add an indvidual by clicking on top left plus sign","Page opens where details of individual can be added"]
[{"$nulls":13},"Add details of the individual to be added and then Save","Individual is added to he family and screen returns to list of all individuals in the family"]
[{"$nulls":13},"Select the familly and click on policies (top right)","policy page shows"]
[{"$nulls":13},"Click on the plus (top left)","Policy detail page shows"]
[{"$nulls":13},"fill policy data and save","Policy shows in policy list with Status Idle"]
[{"$nulls":13},"click 3 dots on the right of the policy line and click on payment","the contribution/ payment page shows"]
[{"$nulls":13},"enter contribution details and Save","payment entered is registered and screen comes back to listed payments"]
[{"$nulls":13},"go back to policy","the policy is displayed as active"]
[{"$nulls":13},"Go to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select upload enrolments","Page to enter Login name and Password open up"]
[{"$nulls":13},"Enter valid credentials of EO and Login","After successful login screen moves back to Sync screen"]
[{"$nulls":13},"Select Upload Enrolments","The family is uploaded and you get a message that Family was uploaded successfully where you click OK and come back to sync screen"]
["Android","Mobile phone test"]
["Renewal","testing renewal of policy of an enrolled family"]
[{"$nulls":3},"Renewing a person from a server sent list","Renew a family in an existing renewal list","insuree ID of the head of household is in the existing list of renewals downloaded from the server",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Renewal","Renewal screen appears with a list of policies to be renewed and one field for Unlisted Renewal Policies"]
[{"$nulls":13},"Swipe down on the screen to refresh this list from the server","Policies requiring renewals get listed or a message comes indicating No renewals found"]
[{"$nulls":13},"Select the Policy to renew","Screen opens up where contribution details can be entered"]
[{"$nulls":13},"Enter contribution details and Save","Screen comes back to the Renewals page with the remaining list of policies to be renewed"]
[{"$nulls":13},"Go back to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select upload renewals","Page to enter Login name and Password open up"]
[{"$nulls":13},"Enter valid credentials of EO and Login","After successful login screen moves back to Sync screen"]
[{"$nulls":13},"Select Upload Renewals","The renewal is uploaded and you get a message that Upload Successful where you click OK and come back to sync screen"]
[{"$nulls":3},"Indicating a family wants to discontinue their policy instead of renewing","Discontinue a family policy from an existing renewal list","insuree ID of the head of household is in the existing list of renewals downloaded from the server",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Renewal","Renewal screen appears with a list of policies to be renewed and one field for Unlisted Renewal Policies"]
[{"$nulls":13},"Swipe down on the screen to refresh this list from the server","Policies requiring renewals get listed or a message comes indicating No renewals found"]
[{"$nulls":13},"Select the Policy to renew","Screen opens up where contribution details can be entered"]
[{"$nulls":13},"Select Discontinue the policy and Save","Screen comes back to the Renewals page with the remaining list of policies to be renewed"]
[{"$nulls":13},"Go back to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select upload renewals","Page to enter Login name and Password open up"]
[{"$nulls":13},"Enter valid credentials of EO and Login","After successful login screen moves back to Sync screen"]
[{"$nulls":13},"Select Upload Renewals","The renewal is uploaded and you get a message that Upload Successful where you click OK and come back to sync screen"]
[{"$nulls":3},"Renewing a person from outside the list sent by the server","Renew a family not listed in an existing renewal list","insuree ID of the head of household to be renewed is not in the existing list of renewals downloaded from the server",null,null,2,{"$nulls":4},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Renewal","Renewal screen appears with a list of policies to be renewed and one field for Unlisted Renewal Policies"]
[{"$nulls":13},"Select the Unlisted Renewal Policies option","Screen opens up where contribution details can be entered but also an insuree number"]
[{"$nulls":13},"Enter insuree number, product to be renewed, contribution details and Save","A mesage comes indicating File is saved on external storage"]
[{"$nulls":13},"Go back to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select upload renewals","Page to enter Login name and Password open up"]
[{"$nulls":13},"Enter valid credentials of EO and Login","After successful login screen moves back to Sync screen"]
[{"$nulls":13},"Select Upload Renewals","The renewal is uploaded and you get a message that Upload Successful where you click OK and come back to sync screen"]
[{"$nulls":3},"Renew a policy in offline mode","Renew a family in an existing renewal list when app have no internet","insuree ID of the head of household is in the existing list of renewals downloaded from the server\nNo internet is available",null,null,2,{"$nulls":4},"Login to web application using admin credentials","Home page of web application"]
[{"$nulls":13},"Open Extracts page under Tools","Extract page on the web application with all upload and download options"]
[{"$nulls":13},"Under Download Master Data enter the respective Enrolment office code for whom the list of renewals needs to be generated for; and select Download Renewals","You will be provided a message to save a file with the name including the eonrolment officer code "]
[{"$nulls":13},"Save the file on the computer and transfer the file to the phone in the IMIS folder","The file with .rar extension and enrolment officer code is visible in the IMIS folder"]
[{"$nulls":13},"Open the Enrollment app: IMIS Policy","enrollment app is open, Enrollment office ID is asked after the master data download"]
[{"$nulls":13},"open Renewal","Renewal screen appears with a list of policies to be renewed and one field for Unlisted Renewal Policies"]
[{"$nulls":13},"Swipe down on the screen to refresh this list","You will get a message that No internet is available and whether you would like to import .txt file from the IMIS folder"]
[{"$nulls":13},"Select Yes and navigate to folder on the phone where you saved the file and select it","Renewal screen appears with a list of policies to be renewed and one field for Unlisted Renewal Policies"]
[{"$nulls":13},"Select the Policy to renew","Screen opens up where contribution details can be entered"]
[{"$nulls":13},"Enter contribution details and Save","Screen comes back to the Renewals page with the remaining list of policies to be renewed"]
[{"$nulls":13},"Go to menu and open Sync","The Sync page opens with all upload options"]
[{"$nulls":13},"Select Create Renewals XML","You get a message that XML has been created successfully"]
[{"$nulls":13},"Go to folder IMIS -> Enrolment on the phone","You will see a .rar file with the Mater renewal in the name"]
[{"$nulls":13},"Copy this file and transfer to a computer and go to web application","Web application login page"]
[{"$nulls":13},"Login using Admin credentials to be able to access the Extracts page under Tools","You will get the display page for Extracts with all upload and download options"]
[{"$nulls":13},"Select Browse under Upload Renewals and select the enrolment extract file saved on your computer","You get a success message with a summary of enrolments uploaded"]
["Web Application","Web application test"]
["Log in","Log in to the system"]
[{"$nulls":3},"log in to the web application","log in to the web application with given login credentials","valid login credentials are used",null,null,2,{"$nulls":4},"Go to the login page of the web application","Login page opens requesting a User Name and Password"]
[{"$nulls":13},"Enter valid user name and password and click login","Home/Landing page of the application is displayed with the name next to a greeting for the day (as per server set time during the day) and Roles and Locations allocated to the user account listed on the top left as a column. Drop down list of the different modules are also accessible as per access granted to the user."]
["Web Application","Web application test"]
["Enrolment","enrolment of a new housheold using the web application"]
[{"$nulls":3},"enrolment of a new household","A new household is entered directly on the web application","The household does not exist in the system and is enrolling into the system for the first time",null,null,2,{"$nulls":4},"Login to web application with admin credentials","You willcome to home page of web application"]
[{"$nulls":13},"Go to Insurees and Policies and Select Add Families/Group","Page open to allow entry for the head of the household"]
[{"$nulls":13},"Enter atleast mandatory data fields (highlighted in red) and then click on Save","If all entries are entered correctly the housheold head will be saved and you reach the family overview page. Picture will only display if it was sent through the mobile applicaiton against the ID number of the individual being entered."]
[{"$nulls":13},"Under Insurees Select the plus sign to add family members","Page opens to capture data for next family member"]
[{"$nulls":13},"Enter family members details and enter atleast mandatory data fields (highlighted in red) and then click on Save","The family member is saved and you come back to the family overview page wth a message at the bottom of the page indicating that the entered insuree number was added successfully. Picture will only display if it was sent through the mobile applicaiton against the ID number of the individual being entered"]
[{"$nulls":13},"Continue the two steps above till all family members are added to the family overview list and then adda policy by clicking on the plus next to the Policies section.","Page opens up where you can add the Policy details"]
[{"$nulls":13},"Enter all the fields (mandatory in red) and Click Save","You come back to family overview page with the polciy added to list of Policies for the family with a message at the bottom indicating the policy was successfully added"]
[{"$nulls":13},"Enter a payment against the policy by clicking on the plus next to Contributions","Page opens to capture details of payment made"]
[{"$nulls":13},"Enter all information against a payment that was made either partially or fully against the Policy Vallue and click Save","Contribution Category Contributions will include by default total policy value in the field Contribution Paid with Balance calculated as 0."]
[{"$nulls":13},"Select OK to the message that Contribution matches the price of policy.","You return to Family Overview page with a message that Contirbution was added successfully. A family is now fully enrolled through the web application and policy status changed to Active"]
[{"$nulls":3},"Enquire",{"$nulls":4},2,{"$nulls":4},"Login to web application with admin credentials","You will come to home page of web application"]
[{"$nulls":13},"Go to Insuree Enquiry on the top right of the page and enter a valid ID of an individual and press enter","A page opens with a summary of the details of the individuals, their insurance validaty and eligibility details. A picture and some personal details show up on the basis of whcih the individual can be identified"]
[{"$nulls":13},"Select Close","You return to the last screen you were working on"]
[{"$nulls":3},"Modify a family ",{"$nulls":4},2,{"$nulls":4},"Login to web application with admin credentials","You will come to home page of web application"]
[{"$nulls":13},"Go to Insurees under Insurees and Policies","A page opens with multiple search criterias to display searches of an individual on"]
[{"$nulls":13},"Enter an indiviudals ID under Insurance Number field and and click search","Message is given that No Insuree was found and no records where found"]
[{"$nulls":13},"Select Close","You return to the last screen you were working on"]
[{"$nulls":13},"Login to web application with admin credentials","You will come to home page of web application"]
[{"$nulls":13},"Go to Insurees under Insurees and Policies","A page opens with multiple search criterias to display searches of an individual on"]
[{"$nulls":13},"Enter an indiviudals ID under Insurance Number field and and click search","Message is given 1 Insuree was foundt and this insuree is listed below"]
[{"$nulls":13},"Click on ID number of this listed individual","The family page of this individual opens up where the individual in the list of family members is highlighted"]
[{"$nulls":13},"Click on the individuals number","Screen with individuals details opens"]
[{"$nulls":13},"Modify details of the individual where needed and click on save","The modifications are saved and you come back to screen with family overview and message that Insuree with respective number was updated successfully"]
[{"$nulls":13},"Login to web application with admin credentials","You will come to home page of web application"]
[{"$nulls":13},"Go to Insurees under Insurees and Policies","A page opens with multiple search criterias to display searches of an individual on"]
[{"$nulls":13},"Enter an indiviudals ID under Insurance Number field and and click search","Message is given 1 Insuree was foundt and this insuree is listed below"]
[{"$nulls":13},"Click on ID number of this listed individual","The family page of this individual opens up where the individual in the list of family members is highlighted"]
[{"$nulls":13},"Select the individual in the family who has to be deleted by single click on the row that contains the data of this individual","The row with the individuals data is highlighted"]
[{"$nulls":13},"Select the Delete \"cross sign\" icon next to the Insurees section on the page","You get a confirmation that the individual was deleted"]
[{"$nulls":13},"Login to web application with admin credentials","You will come to home page of web application"]
[{"$nulls":13},"Go to Insurees under Insurees and Policies","A page opens with multiple search criterias to display searches of an individual on"]
[{"$nulls":13},"Enter an indiviudals ID under Insurance Number field and and click search","Message is given 1 Insuree was foundt and this insuree is listed below"]
[{"$nulls":13},"Click on ID number of this listed individual","The family page of this individual opens up where the individual in the list of family members is highlighted"]
[{"$nulls":13},"To add a new member Select the plus sign next to Insurees","Page opens to add a new individuals data"]
[{"$nulls":13},"Enter the data for the individual and click on Save","You return to the family overview page and get a message that Individual with respective number was added"]
[{"$nulls":13},"If additional payments have to be added to the family then single click to select the policy against which the payment is to be made and then select the plus sign next to Contributions","Screen shows where payment details can be added"]
[{"$nulls":13},"Enter all information against a payment that was made either partially or fully against the Policy Vallue and click Save","Contribution Category Contributions will include by default total policy value in the field Contribution Paid with Balance calculated as 0."]
[{"$nulls":13},"Select OK to the message that Contribution matches the price of policy.","You return to Family Overview page with a message that Contirbution was added successfully. A family is now fully enrolled through the web application and policy status changed to Active"]
[{"$nulls":3},"Renewal",{"$nulls":4},2,{"$nulls":4},"Login to web application with admin credentials","You will come to home page of web application"]
[{"$nulls":13},"Go to Insurees under Insurees and Policies","A page opens with multiple search criterias to display searches of an individual on"]
[{"$nulls":13},"Enter an indiviudals ID under Insurance Number field and and click search","Message is given 1 Insuree was foundt and this insuree is listed below"]
[{"$nulls":13},"Click on ID number of this listed individual","The family page of this individual opens up where the individual in the list of family members is highlighted"]
[{"$nulls":13},"To renew a policy, select the policy to renew and click the R icon Policies","You will get a message asking whether you would like to renew the policy"]
[{"$nulls":13},"Click Yes to renew the policy","The page where you enter details of policy will open"]
[{"$nulls":13},"Enter all the fields (mandatory in red) and Click Save","You come back to family overview page with the renewed polcy added to list of Policies for the family with a message at the bottom indicating the policy was successfully renewed"]
[{"$nulls":13},"Enter a payment against the policy by clicking on the plus next to Contributions","Page opens to capture details of payment made"]
[{"$nulls":13},"Enter all information against a payment that was made either partially or fully against the Policy Vallue and click Save","Contribution Category Contributions will include by default total policy value in the field Contribution Paid with Balance calculated as 0."]
[{"$nulls":13},"Select OK to the message that Contribution matches the price of policy.","You return to Family Overview page with a message that Contirbution was added successfully. A family is now fully enrolled through the web application and policy status changed to Active"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Req Coverage","index":3,"n_rows":1,"n_cols":3,"rows_kept":1}
["Requirements List","Requirements without duplicates","Occurrences"]