Spreadsheet: 586483d1534414493-looking-up-data-matching-data-data-matching-kevin
Sheet: hiddenSheet

account:mFvxy6MI+8lntMB3ZLt5RVgRiZWmGMLKNtmGDsrFiHe8KKVgPIlxpHQugtpQMBiDOCKldsZO1JaWLLMPPSZ3CA==:accountid=%28Do%20Not%20Modify%29%20Account&checksumLogicalName=%28Do%20Not%20Modify%29%20Row%20Checksum&modifiedon=%28Do%20Not%20Modify%29%20Modified%20On&name=Account%20Name&primarycontactid=Primary%20Contact&telephone1=Main%20Phone&flex_locationprimaryinspectioncategory=Provider%20Primary%20Inspection%20Category&accountnumber=Account%20Number&accountratingcode=Account%20Rating&cdi_accountscore=Account%20Score&address1_composite=Address%201&address1_addresstypecode=Address%201%3a%20Address%20Type&address1_city=Address%201%3a%20City&address1_country=Address%201%3a%20Country%2fRegion&address1_county=Address%201%3a%20County&address1_fax=Address%201%3a%20Fax&address1_freighttermscode=Address%201%3a%20Freight%20Terms&address1_latitude=Address%201%3a%20Latitude&address1_longitude=Address%201%3a%20Longitude&address1_name=Address%201%3a%20Name&address1_postofficebox=Address%201%3a%20Post%20Office%20Box&address1_primarycontactname=Address%201%3a%20Primary%20Contact%20Name&address1_shippingmethodcode=Address%201%3a%20Shipping%20Method&address1_stateorprovince=Address%201%3a%20State%2fProvince&address1_line1=Address%201%3a%20Street%201&address1_line2=Address%201%3a%20Street%202&address1_line3=Address%201%3a%20Street%203&address1_telephone2=Address%201%3a%20Telephone%202&address1_telephone3=Address%201%3a%20Telephone%203&address1_upszone=Address%201%3a%20UPS%20Zone&address1_utcoffset=Address%201%3a%20UTC%20Offset&address1_postalcode=Address%201%3a%20ZIP%2fPostal%20Code&address2_composite=Address%202&address2_addresstypecode=Address%202%3a%20Address%20Type&address2_city=Address%202%3a%20City&address2_country=Address%202%3a%20Country%2fRegion&address2_county=Address%202%3a%20County&address2_fax=Address%202%3a%20Fax&address2_freighttermscode=Address%202%3a%20Freight%20Terms&address2_latitude=Address%202%3a%20Latitude&address2_longitude=Address%202%3a%20Longitude&address2_name=Address%202%3a%20Name&address2_postofficebox=Address%202%3a%20Post%20Office%20Box&address2_primarycontactname=Address%202%3a%20Primary%20Contact%20Name&address2_shippingmethodcode=Address%202%3a%20Shipping%20Method&address2_stateorprovince=Address%202%3a%20State%2fProvince&address2_line1=Address%202%3a%20Street%201&address2_line2=Address%202%3a%20Street%202&address2_line3=Address%202%3a%20Street%203&address2_telephone1=Address%202%3a%20Telephone%201&address2_telephone2=Address%202%3a%20Telephone%202&address2_telephone3=Address%202%3a%20Telephone%203&address2_upszone=Address%202%3a%20UPS%20Zone&address2_utcoffset=Address%202%3a%20UTC%20Offset&address2_postalcode=Address%202%3a%20ZIP%2fPostal%20Code&address1_telephone1=Address%20Phone&aging30=Aging%2030&aging30_base=Aging%2030%20%28Base%29&aging60=Aging%2060&aging60_base=Aging%2060%20%28Base%29&aging90=Aging%2090&aging90_base=Aging%2090%20%28Base%29&cdi_allowtextmessages=Allow%20Text%20Messages&flex_alsoknownas=Also%20Known%20As&revenue=Annual%20Revenue&revenue_base=Annual%20Revenue%20%28Base%29&flex_brandopportunity=Brand%20Opportunity%3f&flex_budgetamount=Budget%20Amount&flex_budgetamount_base=Budget%20Amount%20%28Base%29&businesstypecode=Business%20Type&flex_careenglandmember=Care%20England%20Member&flex_carehome=Care%20Home%3f&flex_cashatbankperiod1=Cash%20at%20Bank%20Period%201&flex_cashatbankperiod1_base=Cash%20at%20Bank%20Period%201%20%28Base%29&accountcategorycode=Category&flex_ceocontactid=CEO&flex_charitynumber=Charity%20Number&accountclassificationcode=Classification&flex_clinicalcommissioninggroup=Clinical%20Commissioning%20Group&flex_commissioningclinicalcommissioninggroup=Commissioning%20Clinical%20Commissioning%20Group&flex_companieshousenumber=Companies%20House%20Number&flex_providercount=Company%20Count&flex_companytype=Company%20Type&flex_constituency=Constituency&flex_contractvalueannual=Contract%20value%20-%20Annual%20%28%c2%a3%29&flex_contractvalueannual_base=Contract%20value%20-%20Annual%20%28%c2%a3%29%20%28Base%29&flex_cqcid=CQC%20ID&flex_cqcreporturl=CQC%20Report%20URL&createdby=Created%20By&createdonbehalfby=Created%20By%20%28Delegate%29&createdbyexternalparty=[NAME]Created%20On&creditonhold=Credit%20Hold&creditlimit=Credit%20Limit&creditlimit_base=Credit%20Limit%20%28Base%29&transactioncurrencyid=Currency&customersizecode=Customer%20Size&flex_datefoirequestsent=Date%20FOI%20request%20sent&flex_deregistrationdate=Deregistration%20Date&description=Description&donotbulkemail=Do%20not%20allow%20Bulk%20Emails&donotbulkpostalmail=Do%20not%20allow%20Bulk%20Mails&donotemail=Do%20not%20allow%20Emails&donotfax=Do%20not%20allow%20Faxes&donotpostalmail=Do%20not%20allow%20Mails&donotphone=Do%20not%20allow%20Phone%20Calls&flex_ebitdaperiod1=Ebitda%20Period%201&flex_ebitdaperiod1_base=Ebitda%20Period%201%20%28Base%29&emailaddress1=Email&emailaddress2=Email%20Address%202&emailaddress3=Email%20Address%203&flex_employeesperiod1=Employees%20Period%201&flex_engagementscore=Engagement%20Score&exchangerate=Exchange%20Rate&fax=Fax&flex_fitsrequirementsaffordability=Fits%20Requirements%20%2f%20Affordability%3f&flex_foiemailrequestsent=FOI%20-%20Email%20request%20Sent&flex_foiresponsereceieved=FOI%20-%20Response%20Receieved&flex_foiresponsedetails=FOI%20response%20details&followemail=Follow%20Email%20Activity&ftpsiteurl=FTP%20Site&flex_good=Good%20%28%25%29&flex_goodcount=Good%20Count&flex_inadequate=Inadequate%20%28%25%29&flex_inadequatecount=Inadequate%20Count&flex_incidentandriskcontracts=Incident%20%26%20Risk%20Contracts&industrycode=Industry&flex_infusionsoftid=Infusionsoft%20ID&flex_ircontractrenewaldate=IR%20Contract%20Renewal%20Date&flex_ircontracttermyrs=IR%20Contract%20Term%20%20-%20Yrs&flex_ircontractvalueterm=IR%20Contract%20Value%20-%20Term%20%20%28%c2%a3%29&flex_ircontractvalueterm_base=IR%20Contract%20Value%20-%20Term%20%20%28%c2%a3%29%20%28Base%29&flex_isrelevant=Is%20Relevant%3f&flex_itsystemscontactid=IT%2fSystems&flex_keycontactsidentified=Key%20Contacts%20Identified%3f&lastusedincampaign=Last%20Date%20Included%20in%20Campaign&flex_lastinspectiondate=Last%20Inspection%20Date&lastonholdtime=Last%20On%20Hold%20Time&flex_liveprojectidentified=Live%20Project%20Identified%3f&flex_localauthority=Local%20Authority&flex_locationtype=Location%20Type%20%2f%20Sector&marketcap=Market%20Capitalization&marketcap_base=Market%20Capitalization%20%28Base%29&flex_marketvalue=Market%20Value&flex_marketvalue_base=Market%20Value%20%28Base%29&marketingonly=Marketing%20Only&modifiedby=Modified%20By&modifiedonbehalfby[NAME]=[NAME]Modified%20On&flex_ncfmember=NCF%20Member&flex_nopublishedrating=No%20Published%20Rating%20%28%25%29&flex_nopublishedratingcount=No%20Published%20Rating%20Count&flex_numberofbeds=Number%20of%20Beds&numberofemployees=Number%20of%20Employees&onholdtime=On%20Hold%20Time%20%28Minutes%29&opendeals=Open%20Deals&openrevenue=Open%20Revenue&openrevenue_base=Open%20Revenue%20%28Base%29&flex_operationscontactid=Operations&originatingleadid=Originating%20Lead&telephone2=Other%20Phone&flex_outstanding=Outstanding%20%28%25%29&flex_outstandingcount=Outstanding%20Count&ownerid=Owner&ownershipcode=Ownership&parentaccountid=Parent%20Account&paymenttermscode=Payment%20Terms&preferredappointmentdaycode=Preferred%20Day&preferredequipmentid=Preferred%20Facility%2fEquipment&preferredcontactmethodcode=Preferred%20Method%20of%20Contact&preferredserviceid=Preferred%20Service&preferredappointmenttimecode=Preferred%20Time&preferredsystemuserid=Preferred%20User&defaultpricelevelid=Price%20List&primarysatoriid=Primary%20Satori%20ID&primarytwitterid=Primary%20Twitter%20ID&processid=Process&stageid=Process%20Stage&flex_productunderstood=Product%20Understood%3f&flex_locationinspectiondirectorate=Provider%20Inspection%20Directorate&flex_qmcontractrenewaldate=QM%20Contract%20Renewal%20date&flex_qmcontracttermyrs=QM%20Contract%20Term%20-%20Yrs&flex_qmcontractvalue=QM%20Contract%20Value%20%28%c2%a3k%29&flex_qmcontractvalue_base=QM%20Contract%20Value%20%28%c2%a3k%29%20%28Base%29&flex_qualificationstatus=Qualification%20Status&flex_qualityandcompliancecontactid=Quality%20and%20Compliance&flex_qualitymanagementcontracts=Quality%20Management%20Contracts&overriddencreatedon=Record%20Created%20On&flex_region=Region&flex_registeredmanagerabsentdate=Registered%20Manager%20Absent%20Date&flex_registrationdate=Registration%20Date&flex_registrationstatus=Registration%20Status&customertypecode=Relationship%20Type&flex_requiresimprovement[NAME]Requires%20Improvement%20%28%25%29&flex_requiresimprovementcount=Requires%20Improvement%20Count&donotsendmm=Send%20Marketing%20Materials&flex_servicecount=Service%20Count&sharesoutstanding=Shares%20Outstanding&shippingmethodcode=Shipping%20Method&sic=SIC%20Code&slaid=SLA&statecode=Status&statuscode=Status%20Reason&flex_steadcrossowner=Steadcross%20Owner&stockexchange=Stock%20Exchange&telephone3=Telephone%203&territoryid=Territory&territorycode=Territory%20Code&tickersymbol=Ticker%20Symbol&timespentbymeonemailandmeetings=Time%20Spent%20by%20me&flex_twitterlist=Twitter%20List&flex_type=Type&flex_ukhcamember=UKHCA%20Member&websiteurl=Website&yominame=Yomi%20Account%20Name
Acute hospital - Independent non-specialist | Acute hospital - Independent specialist | Acute hospital - NHS non-specialist | Acute hospital - NHS specialist | Ambulance service | Community based adult social care services | Community health - NHS & Independent | Community substance misuse | Dentists | GP Practices | Hospice services | Independent consulting doctors | Mental health - community & hospital - independent | Mental health - community & residential - NHS | No Primary Ticked | Out of hours | [NAME] | Remote clinical advice | Residential social care | Residential substance misuse | Slimming Clinics | Unspecified | Urgent care services & mobile doctors
Default Value
[NAME] | Ship To | Primary | Other
FOB | No Charge
Airborne | DHL | FedEx | UPS | Postal Mail | [NAME] | Will Call
Default Value
Default Value
Default Value
No | Yes
No | Yes
Default Value | #REF! | Acute hospital - NHS non-specialist | Acute hospital - NHS specialist | Ambulance service | Community health - NHS & Independent | Health Care Support Organisations | Mental health - community & residential - NHS | Acute hospital - Independent non-specialist | Acute hospital - Independent specialist | Acute Services - Non Hospital | Community based adult social care services | Community substance misuse | Dentists | GP Practices | Hospice services | Independent consulting doctors | Mental health - community & hospital - independent | No Primary Ticked | Out of hours | [NAME] | Remote clinical advice | Residential social care | Residential substance misuse | Slimming Clinics | Social Care Org | Unspecified | Urgent care services & mobile doctors
No | Yes
No | Yes
Preferred Customer | Standard | Healthcare | Consultant | Provider | NHS | Commissioner | Strategic Partner
Default Value
Healthcare | Non-CQC Healthcare | Healthcare Recruitment | Healthcare Consultant | Non-Healthcare Recruitment | Non-Healthcare Consultant | Non-Healthcare Other
Yes | No
Default Value
Allow | Do Not Allow
No | Yes
Allow | Do Not Allow
Allow | Do Not Allow
Allow | Do Not Allow
Allow | Do Not Allow
No | Yes
No | Yes
No | Yes
Do Not Allow | Allow
Accounting | Agriculture and Non-petrol Natural Resource Extraction | Broadcasting Printing and Publishing | Brokers | Building Supply Retail | Business Services | Consulting | Consumer Services | Design, Direction and Creative Management | Distributors, Dispatchers and Processors | Doctor's Offices and Clinics | Durable Manufacturing | Eating and Drinking Places | Entertainment Retail | Equipment Rental and Leasing | Financial | Food and Tobacco Processing | Inbound Capital Intensive Processing | Inbound Repair and Services | Insurance | Legal Services | Non-Durable Merchandise Retail | Outbound Consumer Service | Petrochemical Extraction and Distribution | Service Retail | SIG Affiliations | Social Services | Special Outbound Trade Contractors | Specialty Realty | Transportation | Utility Creation and Distribution | [NAME] | Wholesale
No | Yes
No | Yes
No | Yes
Independent Ambulance | Independent Healthcare Org | NHS Healthcare Organisation | Primary Dental Care | Primary Medical Services | Social Care Org
No | Yes
No | Yes
Public | Private | Subsidiary | Other
Net 30 | 2% 10, Net 30 | Net 45 | Net 60
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Any | [NAME] | Phone | Fax | Mail
Morning | Afternoon | Evening
No | Yes
Adult social care | Hospitals | Primary medical services | Unspecified
Registered
Competitor | Consultant | Customer | Investor | Partner | Influencer | Press | Prospect | Reseller | Supplier | Vendor | Other | Potential Customer | Strategic Partner | Consultant | Investor Opportunity | SPAM
Send | Do Not Send
Default Value
Active | Inactive
Active | Inactive
Default Value
No | Yes
Account | Brand | Company | Service
No | Yes