Randomization for clinical research: An easy‐to‐use spreadsheet method

Abstract

In this article, we illustrate a new method for random selection and random assignment that we developed in a pilot study for a randomized clinical trial. The randomization database is supported by a commonly available spreadsheet. Formulas were written for randomizing participants and for creating a "shadow" system to verify integrity of the randomization. Advantages of this method are that it is easy to use, effective, and portable, allowing it to be shared among multiple investigators at multiple study sites. Clinical researchers may find the method useful for research projects that are pilot studies or conducted with limited funding.