Example of ELPo Spreadsheet
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, which will automatically perform the calculations.
| 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.448 | 4.982 |
