excel2r
Analyse and convert Excel models using R
The objective of this project is to convert large, complex Excel models into R, using R. The approach is to:
- Read the Excel values and formulae (using the tidyxl package).
- Analyse the Excel sheets for consistency (quite useful in itself).
- Analyse the formulae to identify scalar, vector and matrix regions (these will become R variables).
- Translate the Excel formulae to R syntax.
- Sort the formula into execution order.
- Write the formula as an R script.
Documentation files:
- project_guide.txt (tba)
- outstanding_issues.txt (tba)