A VBA program honlapja:
Rangszám-különbségek (abszolút értékének) összege (SRD), és érvényesítése (validálása): Rangszámok összehasonlítása véletlen számok rangjaival (CRRN), döntetlenek (ismétlések) nélkül.Computer code for method and model comparison (ranking and grouping, as well).
VBA program's homepage
Sum of (abolute) ranking differences (SRD) and its validation: Compare Ranks with Random Numbers (CRRN ) without ties.
Authors: Dr. Klára Kollár-Hunek and Dr. Károly Héberger
email: kollarne[at]mail.bme.hu and heberger.karoly[at]ttk.mta.hu
Downloadable program, samples for input and output files: CRRN_DNA_V6_S.xls program file
Basic input file sample: Basic_DataSample.xls
Output of basic input file: Basic_DataSample_DNA_V6_CRRN.xls
Special input file sample: DataSample_Freq2.xls
Output of special input file: DataSample_Freq2_DNA_V6_CRRN.xls
SRD with ties without solver (needs xlsx input files)
1. Input InpSampleCV_rPd7AB_SRDrepV6T4_CrV8D.zip
2. SRD-with-ties program SRDrepV6T4_CrossVal_V8D.xlsm
3. User guide (Manual) UserGuide_CrossVal_V8D.pdf
SRD with ties: SRDrep_V5_E10.xlsm program file
1.input sample (xls file with several sheets) ; Output of the 1.input file 2.input sample (xlsx file with one sheet) ; Output of the 2.input file
Warning: The SRD-with-ties program is for Excel-2010, and needs Solver among the VBA Tools (References)
Here you see, how you can check after opening the downloaded SRDrep_V5_E10.xlsm program whether you have the Solver among the VBA Tools (References):
VBA macros for producing SRD-COVAT (Comparison of One Variable at a Time) heatmaps
The xls file for SRD heatmap calculations without repetitions is available for download here.
Please refer to this input example when submitting your calculation.
Important: for heatmap production, the last column of the input file should always be empty with "Read" specified in the header.
If you apply this script in your research, please cite the following articles:
[1] K. Héberger, K. Kollár-Hunek, Sum of ranking differences for method discrimination and its validation:
comparison of ranks with random numbers, J. Chemom. 25 (2011) 151–158. http://onlinelibrary.wiley.com/doi/10.1002/cem.1320/full
[2] F. Andric et al., Multivariate assessment of lipophilicity scales — computational and reversed phase
thin-layer chromatographic indices, J. Pharm. Biomed. Anal. 127 (2016), 81-93. http://dx.doi.org/10.1016/j.jpba.2016.04.001
The xls file for SRD heatmap calculations with repetitions is available for download here.
(This script is recommended if your input matrix contains repeated values, i.e. identical values in the same column. Its current limitation is 40 rows.)
Please refer to this input example when submitting your calculation.
Important: for heatmap production, the last column of the input file should always be empty with "Read" specified in the header.
If you apply this script in your research, please cite the following articles:
[1] K. Kollár-Hunek, K. Héberger, Method and model comparison by sum of ranking differences
in cases of repeated observations (ties), Chemom. Intell. Lab. Syst. 127 (2013) 139–146. http://dx.doi.org/10.1016/j.chemolab.2013.06.007
[2] F. Andric et al., Multivariate assessment of lipophilicity scales — computational and reversed phase
thin-layer chromatographic indices, J. Pharm. Biomed. Anal. 127 (2016), 81-93. http://dx.doi.org/10.1016/j.jpba.2016.04.001