This template is to calculate BCA concentrations with set up BSA standards
Please have a check on file "Library.txt" before running for this template If it is first time running for this template Then please install those packages by copy to your R terminal
install.packages(c("readxl", "summarytools", "skimr", "ggplot2"))You can drag and drop your xlsx file to run.bat if you have setup R and all packages locally. These files will be generated:
- BCA_Graph.jpg
- output.log
- Rplots.pdf
Use run-portable.bat if you have the R installed on a thumb drive. It supports R 4.1.3 on Windows 7 (32 bit) and up.
In this template, we have 0.05g/l, 0.1g/l, 0.2g/l and 0.4g/l standard to form linear regression models If you are having those four standard concentrations please proceed without modification
In this template, we setup 96-well plate in .xlsx style which is:
A1 for each variables name
A2~C2 for each blanks
A3~C3 for each 0.05g/l standard
A4~C4 for each 0.1g/l standard
A5~C5 for each 0.2g/l standard
A6~C6 for each 0.4g/l standard
Ax~Cx for each unknown proteins
If plate setup followed in that way, then delete all the other empty column The "Sample.xlsx" and "Sample.csv" will be shown in this folder
Remember that this template is only having two unknown proteins If we are having more than 2 unknown proteins Then you need to add another 'Unk3', 'Unk4 etc.
Remember to add in each line that related to 'Unk_x'
This template is only to use for calculating of BCA results Do not respond for any self-examination of validity of data Please check R-square and p-value themselves in terminal as the command has been added in this template