README.md 768 Bytes
Newer Older
Dionysis Dimakopoulos's avatar
Dionysis Dimakopoulos committed
1
# Covid-19 Excel error analysis
2
3
4
5
6
7
8
9
10
This repository contains the following files
* covid_test_data.csv<br>
  This is the dummy CSV file we created to test several scenarios that might have led to the COVID-19 Excel error by NHS Track-and-trace
* modCSVCreator.bas<br>
  This file contains the createCovidTestsCSV() VBA subroutine that was used to create the dummy CSV file above. In order to run it you need the xls file below that contains a worksheet containing random data generated by Excel formulas. 
* RandomCSVCreator.xls<br>
  This Excel workbook contains a worksheet with random data used by modCSVCreator.bas to add in the dummy CSV file.
* modImportLargeCSV.bas<br>
  This Excel VBA module contains the subroutine used to test importing a large CSV using VBA.
Dionysis Dimakopoulos's avatar
Dionysis Dimakopoulos committed
11