Our Data Technology and Tool Kits
The Rancho Tool Kit is a collection of processing and analysis code that accelerates analysis, streamlines the QC process, and encourages the development of professional, consistent, and accessible scientific products.
Rancho has been developing content and tools since 2012. Over the years, we generated a lot of in-house technology that we bring to projects and produce high-quality, efficient results for our clients.

The Fuzzy Logic Tool
Supports rapid, practical data harmonization based on phonetic alignment. When building this term-mapping solution, we found that existing methods are either too restrictive (statistical methods) or too permissive (Soundex method).
Our Fuzzy Tool algorithm has been implemented as an API in addition to an Excel plugin. The implementation provides a two-pronged approach to accelerate the mapping process: first, identifying the best ontologies to map the data and subsequently leveraging an indexed ontology.
SMART Converter
Is a platform to collect data from clinical data sites—simultaneously checks for updates, downloads, and converts data to a format that is FAIR. Minimizes human time spent on data updates and facilitates rapid data ingestion into a platform of choice.

The Rancho Data Crawler
The Rancho Data Crawler is a web-application that given a complex search string, crawls study-level metadata in PubMed, ClinicalTrials.gov, GEO, SRA, EGA, and ArrayExpress and outputs results to an XLSX (Excel) file within minutes. This application is meant to accelerate the data crawling process by putting our proprietary Rancho data crawler scripts at the fingertips of any project team that needs them, no scripting needed.

The Rancho QC Tool
Automatic Quality Control (QC) Tool:
To enhance QC efficiency and ensure consistent QC output standards, Rancho has developed a tool to support and facilitate tabular data QC and streamline quality control measures for data model alignment. This QC tool will enable users to perform data transformations, generate table summaries, and build logical tests using an RShiny interface. Further details on the tool's functions and features, as well as instructions for use, are documented in Rancho KB.
Benefits of Rancho’s QC Tool:
- Clear and user-friendly interface (without coding requirements)
- Faster quality assurance and issue resolution
- Less effort to achieve compliance
- Consistent standards for quality control documentation
- High-quality data model and tabular deliverables
- Streamlined and repeatable