def vs_per_skipped_setting_for_references(self, avi_config):
    '\n        This functions defines that Add the skipped setting per VS CSV row\n        :param avi_config: this methode use avi_config for checking vs skipped\n        :return: None\n        '
    global fully_migrated
    global total_count
    global progressbar_count
    fully_migrated = 0
    vs_csv_objects = [row for row in csv_writer_dict_list if ((row['Status'] in [STATUS_PARTIAL, STATUS_SUCCESSFUL]) and (row['Netscaler Command'] in ['add cs vserver', 'add lb vserver']))]
    total_count = (total_count + len(vs_csv_objects))
    for vs_csv_object in vs_csv_objects:
        progressbar_count += 1
        skipped_setting = {}
        virtual_service = self.format_string_to_json(vs_csv_object['AVI Object'])
        self.update_vs_complexity_level(vs_csv_object, virtual_service)
        vs_ref = virtual_service['name']
        repls = (('[', ''), (']', ''))
        skipped_setting_csv = reduce((lambda a, kv: a.replace(*kv)), repls, vs_csv_object['Skipped settings'])
        if skipped_setting_csv:
            skipped_setting['virtual_service'] = [skipped_setting_csv]
        if ('ssl_key_and_certificate_refs' in virtual_service):
            (name, skipped) = self.get_ssl_key_and_cert_refs_skipped(csv_writer_dict_list, virtual_service, vs_ref)
            if skipped:
                skipped_setting['ssl key and cert'] = {}
                skipped_setting['ssl key and cert']['name'] = name
                skipped_setting['ssl key and cert']['skipped_list'] = skipped
        if ('ssl_profile_ref' in virtual_service):
            (name, skipped) = self.get_ssl_profile_skipped(csv_writer_dict_list, virtual_service['ssl_profile_ref'], vs_ref)
            if skipped:
                skipped_setting['ssl profile'] = {}
                skipped_setting['ssl profile']['name'] = name
                skipped_setting['ssl profile']['skipped_list'] = skipped
        if ('pool_group_ref' in virtual_service):
            pool_group_name = self.get_name(virtual_service['pool_group_ref'])
            csv_object = self.get_csv_object_list(csv_writer_dict_list, ['bind lb vserver'])
            self.get_pool_skipped_list(avi_config, pool_group_name, skipped_setting, csv_object, 'pool group', csv_writer_dict_list, vs_ref)
        if ('http_policies' in virtual_service):
            csv_object = self.get_csv_object_list(csv_writer_dict_list, ['add cs policy', 'add responder policy', 'add rewrite policy'])
            for http_ref in virtual_service['http_policies']:
                http_name = self.get_name(http_ref['http_policy_set_ref'])
                skipped_list = self.get_csv_skipped_list(csv_object, http_name, vs_ref)
                if skipped_list:
                    skipped_setting['Httppolicy'] = {}
                    skipped_setting['Httppolicy']['name'] = http_name
                    skipped_setting['Httppolicy']['skipped_list'] = skipped_list
                for each_http_policy in avi_config['HTTPPolicySet']:
                    if (each_http_policy['name'] == http_name):
                        for http_req in each_http_policy['http_request_policy']['rules']:
                            if (http_req.get('switching_action', None) and http_req['switching_action'].get('pool_group_ref', None)):
                                pool_group_name = self.get_name(http_req['switching_action']['pool_group_ref'])
                                self.get_pool_skipped_list(avi_config, pool_group_name, skipped_setting, csv_object, 'Httppolicy', csv_writer_dict_list, vs_ref)
        if (('application_profile_ref' in virtual_service) and ('admin:System' not in virtual_service['application_profile_ref'])):
            (name, skipped) = self.get_application_profile_skipped(csv_writer_dict_list, virtual_service, vs_ref)
            if skipped:
                skipped_setting['Application profile'] = {}
                skipped_setting['Application profile']['name'] = name
                skipped_setting['Application profile']['skipped_list'] = skipped
        if (('network_profile_ref' in virtual_service) and ('admin:System' not in virtual_service['network_profile_ref'])):
            (name, skipped) = self.get_network_profile_skipped(csv_writer_dict_list, virtual_service, vs_ref)
            if skipped:
                skipped_setting['Network profile'] = {}
                skipped_setting['Network profile']['name'] = name
                skipped_setting['Network profile']['skipped_list'] = skipped
        if skipped_setting:
            vs_csv_object.update({'Overall skipped settings': str(skipped_setting)})
        else:
            vs_csv_object.update({'Overall skipped settings': 'FULLY MIGRATION'})
            fully_migrated += 1
        msg = 'Writing excel sheet started...'
        self.print_progress_bar(progressbar_count, total_count, msg, prefix='Progress', suffix='')
    csv_objects = [row for row in csv_writer_dict_list if ((row['Status'] in [STATUS_PARTIAL, STATUS_SUCCESSFUL]) and (row['Netscaler Command'] not in ['add cs vserver', 'add lb vserver']) and (('VS Reference' not in row) or (not row['VS Reference'])))]
    for csv_object in csv_objects:
        csv_object['VS Reference'] = STATUS_NOT_IN_USE
This functions defines that Add the skipped setting per VS CSV row
:param avi_config: this methode use avi_config for checking vs skipped
:return: None
def vs_per_skipped_setting_for_references(self, avi_config):
    '\n        This functions defines that Add the skipped setting per VS CSV row\n        :param avi_config: this methode use avi_config for checking vs skipped\n        :return: None\n        '
    global fully_migrated
    global total_count
    global progressbar_count
    fully_migrated = 0
    vs_csv_objects = [row for row in csv_writer_dict_list if ((row['Status'] in [STATUS_PARTIAL, STATUS_SUCCESSFUL]) and (row['Netscaler Command'] in ['add cs vserver', 'add lb vserver']))]
    total_count = (total_count + len(vs_csv_objects))
    for vs_csv_object in vs_csv_objects:
        progressbar_count += 1
        skipped_setting = {}
        virtual_service = self.format_string_to_json(vs_csv_object['AVI Object'])
        self.update_vs_complexity_level(vs_csv_object, virtual_service)
        vs_ref = virtual_service['name']
        repls = (('[', ), (']', ))
        skipped_setting_csv = reduce((lambda a, kv: a.replace(*kv)), repls, vs_csv_object['Skipped settings'])
        if skipped_setting_csv:
            skipped_setting['virtual_service'] = [skipped_setting_csv]
        if ('ssl_key_and_certificate_refs' in virtual_service):
            (name, skipped) = self.get_ssl_key_and_cert_refs_skipped(csv_writer_dict_list, virtual_service, vs_ref)
            if skipped:
                skipped_setting['ssl key and cert'] = {}
                skipped_setting['ssl key and cert']['name'] = name
                skipped_setting['ssl key and cert']['skipped_list'] = skipped
        if ('ssl_profile_ref' in virtual_service):
            (name, skipped) = self.get_ssl_profile_skipped(csv_writer_dict_list, virtual_service['ssl_profile_ref'], vs_ref)
            if skipped:
                skipped_setting['ssl profile'] = {}
                skipped_setting['ssl profile']['name'] = name
                skipped_setting['ssl profile']['skipped_list'] = skipped
        if ('pool_group_ref' in virtual_service):
            pool_group_name = self.get_name(virtual_service['pool_group_ref'])
            csv_object = self.get_csv_object_list(csv_writer_dict_list, ['bind lb vserver'])
            self.get_pool_skipped_list(avi_config, pool_group_name, skipped_setting, csv_object, 'pool group', csv_writer_dict_list, vs_ref)
        if ('http_policies' in virtual_service):
            csv_object = self.get_csv_object_list(csv_writer_dict_list, ['add cs policy', 'add responder policy', 'add rewrite policy'])
            for http_ref in virtual_service['http_policies']:
                http_name = self.get_name(http_ref['http_policy_set_ref'])
                skipped_list = self.get_csv_skipped_list(csv_object, http_name, vs_ref)
                if skipped_list:
                    skipped_setting['Httppolicy'] = {}
                    skipped_setting['Httppolicy']['name'] = http_name
                    skipped_setting['Httppolicy']['skipped_list'] = skipped_list
                for each_http_policy in avi_config['HTTPPolicySet']:
                    if (each_http_policy['name'] == http_name):
                        for http_req in each_http_policy['http_request_policy']['rules']:
                            if (http_req.get('switching_action', None) and http_req['switching_action'].get('pool_group_ref', None)):
                                pool_group_name = self.get_name(http_req['switching_action']['pool_group_ref'])
                                self.get_pool_skipped_list(avi_config, pool_group_name, skipped_setting, csv_object, 'Httppolicy', csv_writer_dict_list, vs_ref)
        if (('application_profile_ref' in virtual_service) and ('admin:System' not in virtual_service['application_profile_ref'])):
            (name, skipped) = self.get_application_profile_skipped(csv_writer_dict_list, virtual_service, vs_ref)
            if skipped:
                skipped_setting['Application profile'] = {}
                skipped_setting['Application profile']['name'] = name
                skipped_setting['Application profile']['skipped_list'] = skipped
        if (('network_profile_ref' in virtual_service) and ('admin:System' not in virtual_service['network_profile_ref'])):
            (name, skipped) = self.get_network_profile_skipped(csv_writer_dict_list, virtual_service, vs_ref)
            if skipped:
                skipped_setting['Network profile'] = {}
                skipped_setting['Network profile']['name'] = name
                skipped_setting['Network profile']['skipped_list'] = skipped
        if skipped_setting:
            vs_csv_object.update({'Overall skipped settings': str(skipped_setting)})
        else:
            vs_csv_object.update({'Overall skipped settings': 'FULLY MIGRATION'})
            fully_migrated += 1
        msg = 'Writing excel sheet started...'
        self.print_progress_bar(progressbar_count, total_count, msg, prefix='Progress', suffix=)
    csv_objects = [row for row in csv_writer_dict_list if ((row['Status'] in [STATUS_PARTIAL, STATUS_SUCCESSFUL]) and (row['Netscaler Command'] not in ['add cs vserver', 'add lb vserver']) and (('VS Reference' not in row) or (not row['VS Reference'])))]
    for csv_object in csv_objects:
        csv_object['VS Reference'] = STATUS_NOT_IN_USE