Please excuse any wrong terms I may use when attempting to ask my question - I'm new to the community 
My goal is to set up an excel spreadsheet that can serve as a database from where I can pull information, in any combination, to perform research, evaluate procedures, etc. Many of these procedures are done at the same time (i.e. in the same surgery setting), so the database needs to be organized and complete enough to allow for easy data manipulation/pulling.
Most of my data is a simple drop down selection menu (i.e patient's sex, type of anesthesia used, grafting locations, etc.) What I'm having trouble with are columns that need multiple combinations as well as manual data entries. For example, the column for "fillers" needs to have the option to select which fillers were used, where they were used, and the volume of how much was used. Multiple areas and multiple fillers can be used in the same session.
Types of fillers: Voluma, Volbella, Vollure, Juvederm, Restylane Lyft, Restylane-L, Restylane Silk, Restylane Refyne, Restylane Defyne, Sculptra, Radiesse
Locations: liquid rhinoplasty, neck, perioral, lip, Temples, upper eyelid, Lateral SOOF, Medial SOOF, Deep Malar, Superficial Malar, nasolabial fold, marionette lines, chin, lips, earlobe, jawline
Volume: manual data entry
Does anyone have any suggestions on how this can be done effectively and still look clean?
My goal is to set up an excel spreadsheet that can serve as a database from where I can pull information, in any combination, to perform research, evaluate procedures, etc. Many of these procedures are done at the same time (i.e. in the same surgery setting), so the database needs to be organized and complete enough to allow for easy data manipulation/pulling.
Most of my data is a simple drop down selection menu (i.e patient's sex, type of anesthesia used, grafting locations, etc.) What I'm having trouble with are columns that need multiple combinations as well as manual data entries. For example, the column for "fillers" needs to have the option to select which fillers were used, where they were used, and the volume of how much was used. Multiple areas and multiple fillers can be used in the same session.
Types of fillers: Voluma, Volbella, Vollure, Juvederm, Restylane Lyft, Restylane-L, Restylane Silk, Restylane Refyne, Restylane Defyne, Sculptra, Radiesse
Locations: liquid rhinoplasty, neck, perioral, lip, Temples, upper eyelid, Lateral SOOF, Medial SOOF, Deep Malar, Superficial Malar, nasolabial fold, marionette lines, chin, lips, earlobe, jawline
Volume: manual data entry
Does anyone have any suggestions on how this can be done effectively and still look clean?
