Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methods
Background Vector analysis is mandatory for reporting astigmatism and for the evaluation of different refractive procedures. Aim The aim of this study was to describe and evaluate a new spreadsheet calculator for vector analysis of mass astigmatism data and to compare between Alpins and Thibos metho...
Main Authors: | , |
---|---|
Format: | Article |
Language: | English |
Published: |
Wolters Kluwer Medknow Publications
2022-01-01
|
Series: | Delta Journal of Ophthalmology |
Subjects: | |
Online Access: | http://www.djo.eg.net/article.asp?issn=1110-9173;year=2022;volume=23;issue=4;spage=292;epage=297;aulast=Elkadim |
_version_ | 1811177777795170304 |
---|---|
author | Mohamed Elkadim Ahmed El-Shehawy |
author_facet | Mohamed Elkadim Ahmed El-Shehawy |
author_sort | Mohamed Elkadim |
collection | DOAJ |
description | Background Vector analysis is mandatory for reporting astigmatism and for the evaluation of different refractive procedures.
Aim The aim of this study was to describe and evaluate a new spreadsheet calculator for vector analysis of mass astigmatism data and to compare between Alpins and Thibos methods.
Patients and methods Using Microsoft Office Excel 2016, a new astigmatic calculator was designed, based on Alpins and Thibos methods of vector analysis. Mass astigmatic data input involved power in diopters and axis direction in degrees. The calculator was investigated on 20 eyes for which photorefractive keratectomy was performed. Preoperative and postoperative manifest refractions were measured. Comparisons were done between the results of Alpins and Thibos methods of analysis.
Results The mean surgically induced astigmatism (SIA) was 2.547±0.721 D and the change in astigmatism power vector (ΔAPV) calculated with the Thibos method was 1.27±0.36 D. A perfect positive correlation (r=1; P<0.000) was present between SIA and ΔAPV with SIA=2ΔAPV. A perfect positive correlation (r=1; P<0.000) was also present between the index of success and APV ratio.
Conclusion Vector analysis of mass astigmatism data could be performed using the new Excel calculator. Alpins and Thibos methods showed interchangeability between their results. |
first_indexed | 2024-04-11T06:06:52Z |
format | Article |
id | doaj.art-cea50da33e714602bba5f082ed714e22 |
institution | Directory Open Access Journal |
issn | 1110-9173 2090-4835 |
language | English |
last_indexed | 2024-04-11T06:06:52Z |
publishDate | 2022-01-01 |
publisher | Wolters Kluwer Medknow Publications |
record_format | Article |
series | Delta Journal of Ophthalmology |
spelling | doaj.art-cea50da33e714602bba5f082ed714e222022-12-22T04:41:28ZengWolters Kluwer Medknow PublicationsDelta Journal of Ophthalmology1110-91732090-48352022-01-0123429229710.4103/djo.djo_23_22Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methodsMohamed ElkadimAhmed El-ShehawyBackground Vector analysis is mandatory for reporting astigmatism and for the evaluation of different refractive procedures. Aim The aim of this study was to describe and evaluate a new spreadsheet calculator for vector analysis of mass astigmatism data and to compare between Alpins and Thibos methods. Patients and methods Using Microsoft Office Excel 2016, a new astigmatic calculator was designed, based on Alpins and Thibos methods of vector analysis. Mass astigmatic data input involved power in diopters and axis direction in degrees. The calculator was investigated on 20 eyes for which photorefractive keratectomy was performed. Preoperative and postoperative manifest refractions were measured. Comparisons were done between the results of Alpins and Thibos methods of analysis. Results The mean surgically induced astigmatism (SIA) was 2.547±0.721 D and the change in astigmatism power vector (ΔAPV) calculated with the Thibos method was 1.27±0.36 D. A perfect positive correlation (r=1; P<0.000) was present between SIA and ΔAPV with SIA=2ΔAPV. A perfect positive correlation (r=1; P<0.000) was also present between the index of success and APV ratio. Conclusion Vector analysis of mass astigmatism data could be performed using the new Excel calculator. Alpins and Thibos methods showed interchangeability between their results.http://www.djo.eg.net/article.asp?issn=1110-9173;year=2022;volume=23;issue=4;spage=292;epage=297;aulast=Elkadimastigmatismexcelvector analysis |
spellingShingle | Mohamed Elkadim Ahmed El-Shehawy Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methods Delta Journal of Ophthalmology astigmatism excel vector analysis |
title | Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methods |
title_full | Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methods |
title_fullStr | Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methods |
title_full_unstemmed | Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methods |
title_short | Novel Microsoft Excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between Alpins and Thibos methods |
title_sort | novel microsoft excel spreadsheet calculator for vector analysis of mass astigmatism data and comparison between alpins and thibos methods |
topic | astigmatism excel vector analysis |
url | http://www.djo.eg.net/article.asp?issn=1110-9173;year=2022;volume=23;issue=4;spage=292;epage=297;aulast=Elkadim |
work_keys_str_mv | AT mohamedelkadim novelmicrosoftexcelspreadsheetcalculatorforvectoranalysisofmassastigmatismdataandcomparisonbetweenalpinsandthibosmethods AT ahmedelshehawy novelmicrosoftexcelspreadsheetcalculatorforvectoranalysisofmassastigmatismdataandcomparisonbetweenalpinsandthibosmethods |