{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["BUSINESS VERIFICATION","COMBINED OUTPUT","COUNTRY CODE","HELP"],"not_rendered":{"charts":1,"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"BUSINESS VERIFICATION","index":0,"n_rows":18,"n_cols":14,"rows_kept":18,"merged":[[1,7,1,9],[4,11,5,13],[6,11,6,13]]}
[]
[null,"BUSINESS VERIFICATION",{"$nulls":5},"COMBINED OUTPUT",null,null,"HELP"]
[]
[]
[null,null,"TOTAL RECORDS","UNMATCHED / DATA QUALITY ERRORS",null,null,"CONFIDENCE CODE >= 8",null,null,"CONFIDENCE CODE <= 7",null,"The Confidence Code (0-10) provides an understanding of the quality of the match. The Match Grade (A,B,F or Z) provides the evaluation of each component of the match. Used together, the Match Grade and Confidence Code will provide granular feedback on the match result."]
[null,null,{"$f":"COUNTA(tblBusVerify[COMPANY\nNAME*]) + COUNTBLANK(tblBusVerify[COMPANY\nNAME*])","v":7},{"$f":"C6-COUNTIFS(tblBusVerify[DUNS \nNUMBER],\"<>\")","v":1},null,null,{"$f":"COUNTIFS(tblBusVerify[CONFIDENCE\nCODE], \">=8\",tblBusVerify[DUNS \nNUMBER],\"<>\")","v":5},null,null,{"$f":"COUNTIFS(tblBusVerify[CONFIDENCE\nCODE], \"<=7\",tblBusVerify[DUNS \nNUMBER],\"<>\")","v":1}]
[{"$nulls":11},"To get more details on D&B's Confidence Code and Match Grade, please click here to access the Field Definition Guide."]
[]
[]
[null,"ID","COMPANY\nNAME*","STREET\nADDRESS","CITY","STATE","ZIP CODE","COUNTRY*","PHONE","STATUS","DUNS \nNUMBER","CONFIDENCE\nCODE","MATCH GRADE","REMARKS"]
[null,"ID","COMPANY\nNAME*","STREET\nADDRESS","CITY","STATE","ZIP CODE","COUNTRY*","PHONE","STATUS","DUNS \nNUMBER","CONFIDENCE\nCODE","MATCH GRADE","REMARKS"]
[null,"RECORD_ID1","GORMAN MANUFACTURING COMPANY, INC.","492 KOLLER ST","SAN FRANCISCO","CA",94110,"US",6505550000,"MATCHED",804735132,10,"AAAAAZAAFFZ"]
[null,"RECORD_ID2","GORMAN MANUFACTURING COMPANY, INC.","1073 S BOYLE AVE","LOS ANGELES","CA",90023,"US",6505550000,"MATCHED",{"v":38732116,"d":"038732116"},10,"AAAAAZAAFFZ"]
[null,"RECORD_ID3","GORMAN POSTER PRINTING INC","492 KOLLER ST","SAN FRANCISCO","CA",94110,null,6505550000,"DATA ERROR",{"$nulls":3},"Country Code is mandatory. "]
[null,"RECORD_ID4","GORMAN CATALOG PRINTING INC","492 KOLLER ST","SAN FRANCISCO","CA",94110,"US",6505550000,"MATCHED",{"v":59633730,"d":"059633730"},10,"AAAAAZAAFBA"]
[null,"RECORD_ID5","US TEST COMPANY 738","899 EATON AVE","BETHLEHEM","PA",18025,"US",6108820002,"MATCHED",362241452,10,"AAAAAZAAZAF"]
[null,"RECORD_ID6","D & B SAMPLE CO LTD","MARLOW INTERNATIONAL PARKWAY","MARLOW",null,"SL7 1AJ","GB",1628492260,"MATCHED",214567885,6,"AZZZZZZZZAF"]
[null,"RECORD_ID7","MUEBLES ARELL, S.A. DE C.V.","AV. REFORMA NO. 589","GUADALAJARA",null,44100,"MX",3333868688,"MATCHED",811761659,10,"AAAAZZA"]

{"sheet":"COMBINED OUTPUT","index":1,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,9,1,11],[4,1,4,2],[5,1,5,2]]}
[]
[null,"COMBINED OUTPUT",{"$nulls":7},"BUSINESS VERIFICATION",null,null,"HELP"]
[]
[]
[null,"The Combined Output sheet combines the data entered on the Business Verification sheet and the verified data in a single view. After running Business Verification, scroll to the right to view the verified data. "]
[]
[null,"INPUT DATA",{"$nulls":7},"VERIFIED DATA"]
[null,"ID","COMPANY\nNAME","STREET\nADDRESS","CITY","STATE","ZIP CODE","COUNTRY","PHONE","STATUS","DUNS \nNUMBER","CONFIDENCE CODE","MATCH GRADE","REMARKS","DNB \nCOMPANY NAME","DNB \nSTREET ADDRESS","DNB \nCITY","DNB \nSTATE","DNB \nZIP CODE","DNB \nCOUNTRY","DNB \nPHONE"]
[null,"ID","COMPANY\nNAME","STREET\nADDRESS","CITY","STATE","ZIP CODE","COUNTRY","PHONE","STATUS","DUNS \nNUMBER","CONFIDENCE CODE","MATCH GRADE","REMARKS","DNB \nCOMPANY NAME","DNB \nSTREET ADDRESS","DNB \nCITY","DNB \nSTATE","DNB \nZIP CODE","DNB \nCOUNTRY","DNB \nPHONE"]
[null,"RECORD_ID1","GORMAN MANUFACTURING COMPANY, INC.","492 KOLLER ST","SAN FRANCISCO","CA",94110,"US",6505550000,"MATCHED",804735132,10,"AAAAAZAAFFZ",null,"GORMAN MANUFACTURING COMPANY, INC.","492 KOLLER ST","SAN FRANCISCO","CA",94110,"US",6505550000]
[null,"RECORD_ID2","GORMAN MANUFACTURING COMPANY, INC.","1073 S BOYLE AVE","LOS ANGELES","CA",90023,"US",6505550000,"MATCHED",38732116,10,"AAAAAZAAFFZ",null,"GORMAN MANUFACTURING COMPANY, INC.","1073 S BOYLE AVE","LOS ANGELES","CA",90023,"US",6505550000]
[null,"RECORD_ID3","GORMAN POSTER PRINTING INC","492 KOLLER ST","SAN FRANCISCO","CA",94110,null,6505550000,"DATA ERROR",{"$nulls":3},"Country Code is mandatory. "]
[null,"RECORD_ID4","GORMAN CATALOG PRINTING INC","492 KOLLER ST","SAN FRANCISCO","CA",94110,"US",6505550000,"MATCHED",59633730,10,"AAAAAZAAFBA",null,"GORMAN CATALOG PRINTING INC","492 KOLLER ST","SAN FRANCISCO","CA",94110,"US",6505550000]
[null,"RECORD_ID5","US TEST COMPANY 738","899 EATON AVE","BETHLEHEM","PA",18025,"US",6108820002,"MATCHED",362241452,10,"AAAAAZAAZAF",null,"US TEST COMPANY 738","899 EATON AVE","BETHLEHEM","PA",18025,"US",6108820002]
[null,"RECORD_ID6","D & B SAMPLE CO LTD",{"$nulls":4},"GB",null,"MATCHED",214567885,6,"AZZZZZZZZAF",null,"D & B SAMPLE CO LTD","MARLOW INTERNATIONAL PARKWAY","MARLOW",null,"SL7 1AJ","GB",1628492260]
[null,"RECORD_ID7","MUEBLES ARELL, S.A. DE C.V.","AV. REFORMA NO. 589","GUADALAJARA",null,44100,"MX",3333868688,"MATCHED",811761659,10,"AAAAZZA",null,"MUEBLES ARELL, S.A. DE C.V.","AV. REFORMA NO. 589","GUADALAJARA",null,44100,"MX",3333868688]

{"sheet":"COUNTRY CODE","index":2,"n_rows":235,"n_cols":5,"rows_kept":235}
[]
[null,"COUNTRY CODE",null,"BUSINESS VERIFICATION","HELP"]
[]
[]
[null,"COUNTRY NAME","ISO ALPHA 2\nCODE"]
[null,"Albania","AL"]
[null,"Algeria","DZ"]
[null,"American Samoa","AS"]
[null,"Andorra","AD"]
[null,"Angola","AO"]
[null,"Anguilla","AI"]
[null,"Antigua and Barbuda","AG"]
[null,"Argentina","AR"]
[null,"Armenia","AM"]
[null,"Aruba","AW"]
[null,"Australia","AU"]
[null,"Austria","AT"]
[null,"Azerbaijan","AZ"]
[null,"Bahamas","BS"]
[null,"Bahrain","BH"]
[null,"Bangladesh","BD"]
[null,"Barbados","BB"]
[null,"Belarus","BY"]
[null,"Belgium","BE"]
[null,"Belize","BZ"]
[null,"Benin","BJ"]
[null,"Bermuda","BM"]
[null,"Bhutan","BT"]
[null,"Bolivia, Plurinational State of","BO"]
[null,"Bosnia and Herzegovina","BA"]
[null,"Botswana","BW"]
[null,"Brazil","BR"]
[null,"Brunei Darussalam","BN"]
[null,"Bulgaria","BG"]
[null,"Burkina Faso","BF"]
[null,"Burundi","BI"]
[null,"Cambodia","KH"]
[null,"Cameroon","CM"]
[null,"Canada","CA"]
[null,"Cape Verde","CV"]
[null,"Cayman Islands","KY"]
[null,"Central African Republic","CF"]
[null,"Chad","TD"]
[null,"Chile","CL"]
[null,"China","CN"]
[null,"Christmas Island","CX"]
[null,"Colombia","CO"]
[null,"Comoros","KM"]
[null,"Congo","CG"]
[null,"Congo, the Democratic Republic of the","CD"]
[null,"Cook Islands","CK"]
[null,"Costa Rica","CR"]
[null,"Côte d'Ivoire","CI"]
[null,"Croatia","HR"]
[null,"Cuba","CU"]
[null,"Cyprus","CY"]
[null,"Czech Republic","CZ"]
[null,"Denmark","DK"]
[null,"Djibouti","DJ"]
[null,"Dominica","DM"]
[null,"Dominican Republic","DO"]
[null,"Ecuador","EC"]
[null,"Egypt","EG"]
[null,"El Salvador","SV"]
[null,"Equatorial Guinea","GQ"]
[null,"Eritrea","ER"]
[null,"Estonia","EE"]
[null,"Ethiopia","ET"]
[null,"Falkland Islands (Malvinas)","FK"]
[null,"Faroe Islands","FO"]
[null,"Fiji","FJ"]
[null,"Finland","FI"]
[null,"France","FR"]
[null,"French Guiana","GF"]
[null,"French Polynesia","PF"]
[null,"Gabon","GA"]
[null,"Gambia","GM"]
[null,"Georgia","GE"]
[null,"Germany","DE"]
[null,"Ghana","GH"]
[null,"Gibraltar","GI"]
[null,"Greece","GR"]
[null,"Greenland","GL"]
[null,"Grenada","GD"]
[null,"Guadeloupe","GP"]
[null,"Guam","GU"]
[null,"Guatemala","GT"]
[null,"Guinea","GN"]
[null,"Guinea-Bissau","GW"]
[null,"Guyana","GY"]
[null,"Haiti","HT"]
[null,"Holy See (Vatican City State)","VA"]
[null,"Honduras","HN"]
[null,"Hong Kong","HK"]
[null,"Hungary","HU"]
[null,"Iceland","IS"]
[null,"India","IN"]
[null,"Indonesia","ID"]
[null,"Iran, Islamic Republic of","IR"]
[null,"Iraq","IQ"]
[null,"Ireland","IE"]
[null,"Israel","IL"]
[null,"Italy","IT"]
[null,"Jamaica","JM"]
[null,"Japan","JP"]
[null,"Jordan","JO"]
[null,"Kazakhstan","KZ"]
[null,"Kenya","KE"]
[null,"Kiribati","KI"]
[null,"Korea, Democratic People's Republic of","KP"]
[null,"Korea, Republic of","KR"]
[null,"Kuwait","KW"]
[null,"Kyrgyzstan","KG"]
[null,"Lao People's Democratic Republic","LA"]
[null,"Latvia","LV"]
[null,"Lebanon","LB"]
[null,"Lesotho","LS"]
[null,"Liberia","LR"]
[null,"Libyan Arab Jamahiriya","LY"]
[null,"Liechtenstein","LI"]
[null,"Lithuania","LT"]
[null,"Luxembourg","LU"]
[null,"Macao","MO"]
[null,"Macedonia, the former Yugoslav Republic of","MK"]
[null,"Madagascar","MG"]
[null,"Malawi","MW"]
[null,"Malaysia","MY"]
[null,"Maldives","MV"]
[null,"Mali","ML"]
[null,"Malta","MT"]
[null,"Marshall Islands","MH"]
[null,"Martinique","MQ"]
[null,"Mauritania","MR"]
[null,"Mauritius","MU"]
[null,"Mayotte","YT"]
[null,"Mexico","MX"]
[null,"Micronesia, Federated States of","FM"]
[null,"Moldova, Republic of","MD"]
[null,"Monaco","MC"]
[null,"Mongolia","MN"]
[null,"Montenegro","ME"]
[null,"Montserrat","MS"]
[null,"Morocco","MA"]
[null,"Mozambique","MZ"]
[null,"Myanmar","MM"]
[null,"Namibia","NA"]
[null,"Nauru","NR"]
[null,"Nepal","NP"]
[null,"Netherlands","NL"]
[null,"Netherlands Antilles","AN"]
[null,"New Caledonia","NC"]
[null,"New Zealand","NZ"]
[null,"Nicaragua","NI"]
[null,"Niger","NE"]
[null,"Nigeria","NG"]
[null,"Niue","NU"]
[null,"Norfolk Island","NF"]
[null,"Northern Mariana Islands","MP"]
[null,"Norway","NO"]
[null,"Oman","OM"]
[null,"Pakistan","PK"]
[null,"Palau","PW"]
[null,"Panama","PA"]
[null,"Papua New Guinea","PG"]
[null,"Paraguay","PY"]
[null,"Peru","PE"]
[null,"Philippines","PH"]
[null,"Poland","PL"]
[null,"Portugal","PT"]
[null,"Puerto Rico","PR"]
[null,"Qatar","QA"]
[null,"Réunion","RE"]
[null,"Romania","RO"]
[null,"Russian Federation","RU"]
[null,"Rwanda","RW"]
[null,"Saint Helena, Ascension and Tristan da Cunha","SH"]
[null,"Saint Kitts and Nevis","KN"]
[null,"Saint Lucia","LC"]
[null,"Saint Pierre and Miquelon","PM"]
[null,"Saint Vincent and the Grenadines","VC"]
[null,"Samoa","WS"]
[null,"San Marino","SM"]
[null,"Sao Tome and Principe","ST"]
[null,"Saudi Arabia","SA"]
[null,"Senegal","SN"]
[null,"Serbia","RS"]
[null,"Serbia & Montenegro","CS"]
[null,"Seychelles","SC"]
[null,"Sierra Leone","SL"]
[null,"Singapore","SG"]
[null,"Slovakia","SK"]
[null,"Slovenia","SI"]
[null,"Solomon Islands","SB"]
[null,"Somalia","SO"]
[null,"South Africa","ZA"]
[null,"South Georgia and the South Sandwich Islands","GS"]
[null,"Spain","ES"]
[null,"Sri Lanka","LK"]
[null,"Sudan","SD"]
[null,"Suriname","SR"]
[null,"Swaziland","SZ"]
[null,"Sweden","SE"]
[null,"Switzerland","CH"]
[null,"Syrian Arab Republic","SY"]
[null,"Taiwan, Province of China","TW"]
[null,"Tajikistan","TJ"]
[null,"Tanzania, United Republic of","TZ"]
[null,"Thailand","TH"]
[null,"Timor-Leste","TL"]
[null,"Togo","TG"]
[null,"Tokelau","TK"]
[null,"Tonga","TO"]
[null,"Trinidad and Tobago","TT"]
[null,"Tunisia","TN"]
[null,"Turkey","TR"]
[null,"Turkmenistan","TM"]
[null,"Turks and Caicos Islands","TC"]
[null,"Tuvalu","TV"]
[null,"Uganda","UG"]
[null,"Ukraine","UA"]
[null,"United Arab Emirates","AE"]
[null,"United Kingdom","GB"]
[null,"United States","US"]
[null,"United States Minor Outlying Islands","UM"]
[null,"Uruguay","UY"]
[null,"Uzbekistan","UZ"]
[null,"Vanuatu","VU"]
[null,"Venezuela, Bolivarian Republic of","VE"]
[null,"Vietnam","VN"]
[null,"Virgin Islands, British","VG"]
[null,"Virgin Islands, U.S.","VI"]
[null,"Wallis and Futuna","WF"]
[null,"Yemen","YE"]
[null,"Zambia","ZM"]
[null,"Zimbabwe","ZW"]

{"sheet":"HELP","index":3,"n_rows":34,"n_cols":3,"rows_kept":34,"merged":[[5,1,5,2],[6,1,6,2],[7,1,7,2],[9,1,9,2],[10,1,10,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
[]
[null,"HELP GUIDE","BUSINESS VERIFICATION"]
[]
[]
[null,"What is the Business Verification App for Excel?"]
[]
[null,"The D&B Business Verification App validates, standardizes, and matches company names and addresses against D&B’s continually updated Global Reference Database of 225+ million businesses right in Excel."]
[]
[null,"What is required to run the Business Verification App?"]
[]
[null,"There are 3 required steps to configure the App:"]
[null,"1. Start the App, if required, after downloading the template. "]
[null,"2. Log in to Windows Azure Marketplace and subscribe to the Business Verification offer."]
[null,"Note: Customers can use the FREE 100 records for one month Business Verification offer embedded in this App to test run this offer & App before making a purchase decision."]
[null,"3. Replace the sample business data on the Business Verfication sheet with your own and run Business Verfication."]
[null,"Tip: To add additional rows to the table, enter the business data directly below the last table entry.  "]
[]
[null,"How do I use this App? How do I add records?"]
[]
[null,"Click on the ? icon in the bottom left corner of the App pane to download the Business Verification App Guide.\nOr"]
[null,"Click here to access the App Guide"]
[]
[null,"Are there any best practice tips for using this App template?"]
[]
[null,"Click here to access the Best Practice Guide"]
[]
[null,"Where can I get details on the template fields and definitions ?"]
[]
[null,"Click here to access the Template Fields and Definitions"]
[]
[null,"I have questions which are not covered in this help section; who should I contact in D&B?"]
[]
[null,"Please contact us by clicking on the below link for any feedback or queries"]
[null,"Support Link"]