doctor-hill.com

IOL Power Calculations

Cataract Surgery Arizona

Setting Up Your Spreadsheet for
Calculating Average ELPo.

Calculate your average ELPo, for use with intraocular lens power calculation programs, by starting with an average of at least 10 cases, ideally 20 to 30. You can then easily set up your spreadsheet, using the example below, that will make the calculations automatically.

Case # Patient
ID
Op
Eye
IOL
Power
Post-op
K1
Post-op
K2
Post-op
Sph Eq
Axial
Length
Bag
ELPo
Sulcus
ELPo
1 9695 OD +26.50 44.00 42.12 -0.25 22.50 5.506 - - -
2 6789 OD +23.50 45.75 47.75 -0.63 22.05 5.419 - - -
3 8298 OD +17.00 42.75 44.87 -0.88 24.82 5.448 - - -
4 3045 OD +20.00 42.00 42.75 -0.13 23.80 - - - 4.977
5 2044 OS +20.00 41.50 42.75 +0.00 24.33 5.499 - - -
6 6644 OD +24.00 44.62 44.87 -0.13 22.40 5.373 - - -
7 1081 OD +21.50 43.37 43.87 -0.50 23.43 5.227 - - -
8 1109 OS +20.50 45.13 45.75 -0.38 22.85 - - - 4.937
9 5578 OD +18.00 42.50 42.88 -0.75 24.72 - - - 4.968
10 7826 OD +21.50 43.88 45.50 -0.25 22.97 - - 4.892
11 2635 OS +27.50 46.25 46.88 -0.50 21.04 - - - 5.002
12 9534 OS +26.00 46.12 44.00 -0.13 21.92 5.464 - - -
13 9431 OS +29.00 42.12 44.75 +0.50 21.60 5.459 - - -
14 8569 OD +13.50 42.00 43.00 -0.50 26.34 5.519 - - -
15 1162 OS +14.00 41.88 42.62 -0.75 26.41 5.514 - - -
16 2227 OD +18.50 42.88 43.75 +0.25 23.99 - - - 5.103
17 1979 OS +22.00 41.50 41.75 +0.13 23.87 5.366 - - -
18 0821 OD +21.50 42.62 40.75 +0.25 23.99 5.477 - - -
19 9431 OD +21.00 44.63 44.25 +0.00 23.24 5.550 - - -
20 6356 OS 16.00 45.25 46.37 -0.50 23.95 - - - 4.993
              Avg  =5.4484.982