make a excel sheet for the below data collection Column What to enter Patient ID A number you assign (1, 2, 3...) — never use name or NHS number Age Patient's age at diagnosis Tumour Stage I / II / III / IV Date of Biopsy DD/MM/YYYY Date of MDT / First Oncology Clinic DD/MM/YYYY ER Documented? Yes / No ER Result Positive / Negative / Not recorded PR Documented? Yes / No PR Result Positive / Negative / Not recorded HER2 IHC Documented? Yes / No HER2 IHC Result 0 / 1+ / 2+ / 3+ / Not recorded HER2 FISH Done (if IHC 2+)? Yes / No / N/A Ki-67 Documented? Yes / No Ki-67 Value % or "Not recorded" Date of Full Biomarker Report DD/MM/YYYY TAT (days) Calculate: Date of Full Report minus Date of Biopsy CA 15-3 Ordered? Yes / No CA 15-3 Indication Metastatic monitoring / Early disease / Unclear / N/A CEA Ordered? Yes / No CEA Indication Metastatic monitoring / Early disease / Unclear / N/A Treatment Decision Documented at MDT? Yes / No Notes Any comments or unusual circumstances
Breast Cancer Audit Data Collection
Spreadsheet · XLSX
- All 22 columns from your specification, across 50 pre-formatted patient rows
- Dropdown menus on every categorical column (Tumour Stage, ER/PR/HER2/Ki-67 results, CA 15-3 & CEA indications, Yes/No fields) - no free-text errors
- Date validation on the three date columns (DD/MM/YYYY format enforced)
- TAT (days) auto-calculates from "Date of Full Biomarker Report" minus "Date of Biopsy" - just enter the dates and it fills itself
- Notes column highlighted in soft yellow to stand out
- Frozen header row and auto-filter enabled for easy sorting/filtering
- Alternating row shading for readability
- A clean reference table explaining every column's accepted values and instructions - useful for anyone filling in the sheet for the first time
the file is not working
Breast Cancer Biomarker Audit
Spreadsheet · XLSX
is it possible to make a google sheet link to the same?
- Download the
.xlsxfile using the link above - Go to sheets.google.com
- Click File > Import (or drag the file straight onto the Google Sheets homepage)
- Choose "Replace spreadsheet" and click Import data
.xlsx file is opening correctly for you, you can upload it to your Google Drive and it will be viewable/editable as a Google Sheet natively - no conversion step needed.Generate a CSV version for importing to Google Sheets
Breast Cancer Biomarker Audit
CSV File · CSV
- Go to sheets.google.com and open a new blank sheet
- Click File > Import
- Choose the CSV file > set Separator type to "Comma"
- Click Import data