A Simple Simulation of Surface Plasmon Resonance in The Kretschmann Configuration Using Google Sheets

N. K. Quang, N. P. Q. Anh, H. C. Hieu


This article describes a simple numerical simulation of three-layer surface plasmon resonance (SPR) in the Kretschmann configuration. The calculation was performed in Google Sheets, a web-based spreadsheet environment that functions similarly to Microsoft Excel where it is easily accessible for students via the internet. Specifically, Fresnel’s equations were utilized to calculate the intensity of the reflected light for the p-polarized incident light on a three-layer system. The complex functions were utilized to plot the SPR curves. We examined the change of the resonance angle by the influence of the incident wavelength. The simulation was also performed for different thicknesses of the gold film layer. To demonstrate the sensitivity, we obtained the SPR curves with the variation of the refractive index in the sensitive medium. The SPR accuracy was analysed by comparing our obtained result with the published work. It is intended to incorporate into undergraduate instrumental analysis courses.


google sheets, surface plasmon resonance; kretschmann configuration

Full Text:



Abell, M. L. L. & Braselton, J. P. (2009). Mathematica by Example. Academic Press.

Adhi, A., Sismanto & Setiawan, A. (2019). Invers Model-ing Gravity Data for Semi-Infinite Slab Using Matlab. Jurnal Pendidikan Fisika Indonesia 15 (2) (2019) 107-113. https://doi.org/10.15294/jpfi.v15i2.21937.

Azzam, R. M. A. & Bashara, N. M. (1977). Ellipsometry and Polarized Light, North Holland.

Bhavsar K. & Prabhu, R. (2019). Investigations on sensitivity enhancement of SPR biosensor using tunable wavelength and graphene layers. IOP conference Series: Materials Science and Engineering, 499, 012008. https://doi.org/10.1088/1757-899X/499/1/012008.

Brahmachari, K. & Ray, M. (2013). Effect of prism mate-rial on design of surface plasmon resonance sensor by admittance loci method. Frontiers of Optoelectronics, 6, 185-193. https://doi.org/10.1007/s12200-013-0313-2.

Chen, H., Lee, L., Choi, S., Kim, J.-H., Choi, H.-J., Kim S.-H., Lee J., & Koh K. (2007). Comparative study of protein immobilization properties on Calixarene monolayers. Sensors, 7 (7), 1091-1107. https://doi.org/10.3390/s7071091.

Dai, X., Liang, Y., Zhao, Y., Gan, S., Jia, Y., & Xiang, Y. (2019). Sensitivity enhancement of a surface plasmon resonance with Tin Selenide (SnSe) allotropes. Sensors, 19 (1), 172. https://doi.org/10.3390/s19010173.

Driscoll, T. A. (2009). Learning MATLAB. Society for Industrial and Applied Mathematics.

Fontana, E. (2006). Thickness optimization of metal films for the development of surface-plasmon-based sensors for nonabsorbing media. Applied Optics, 45 (29), 7632-7642. https://doi.org/10.1364/AO.45.007632.

Fujiwara, H. (2007). Spectroscopic Ellipsometry: Princi-ples and Applications, Wiley.

Homola, J. (2006). Surface Plasmon Resonance Based Sensors. Springer.




Lavine, B. K., Westover, D. J., Oxenford, L., Mirjankar, N., & Kaval, N. (2007). Construction of an inex-pensive surface plasmon resonance instrument for use in teaching and research. Microchemical Journal, 86 (2), 147-155. https://doi.org/10.1016/j.microc.2007.02.003.

Maurya, J. B., Prajapati, Y. K., & Tripathi, R. (2018). Effect of molybdenum disulfide layer on surface plasmon resonance biosensor for the detection of bacteria. Silicon, 10 (2), 245-256. https://doi.org/10.1007/s12633-016-9431-y.

Novotny, L. & Hecht, B. (2012). Principles of Nano-Optics, Cambridge University Press.

Oliveira, M. C. & Nápoles, S. (2010). Using a spread-sheet to study the oscillatory movement of a mass-spring system. Spreadsheets in Education, 3 (3), 2. Retrieved from https://sie.scholasticahq.com/article/4563.

Raether, H. (1988). Surface Plasmons on Smooth and Rough Surfaces and on Gratings, Springer.

Sadowski, J. W., Korhonen, I. K. J. & Peltonen, J. P. K. (1995). Characterization of thin films and their structures in surface plasmon resonance measurements. Optical Engineering, 34 (9), 2581-2586. https://doi.org/10.1117/12.208083.

Sarid, D. & Challener, W. A. (2010). Modern Introduction to Surface Plasmons: Theory, Mathematica Modeling, and Applications, Cambridge University Press.

Shank-Retzlaff, M.-L. & Sligar, S. G. (2000). Analyte gradient-surface plasmon resonance: a one-step method for determining kinetic rates and macromolecular binding affinities. Analytical Chemistry, 72 (17), 4212-4220. https://doi.org/10.1021/ac0001030.

Singh, I., Khun, K. K. & Kaur, B. (2018). Simulating Fraunhofer diffraction of waves using Microsoft excel spreadsheet. Physics Education, 53, 055010.https:/doi.org/10.1088/1361- 552/aacd82.

Tang, Y., Zeng X., & Liang, J. (2010). Surface plasmon resonance: an introduction to a surface spectroscopy technique. Journal of Chemical Education, 87 (7), 742-746. https://doi.org/10.1021/ed100186y.

Uddin, Z., Ahsanuddin, M. & Khan, D. A. (2017). Teach-ing physics using Microsoft excel. Physics Edu-cation, 52, 053001. https://doi.org/10.1088/1361-6552/aa7919.

Verma, R, Gupta, B. D., & RajanJh (2011). Sensitivity enhancement of a surface plasmon resonance based biomolecules sensor using graphene and silicon layers. Sensor and Actuators, 160 (1), 623-631. https://doi.org/10.3390/s20010131.

Widayanti & Abraha, K. (2016). Study on the effect of nanoparticle bimetallic coreshell Au-Ag for sensitivity enhancement of biosensor based on surface plasmon resonance. Journal of Physics: Conference Series, 694, 012075. https://doi.org/10.1088/1742-6596/694/1/012075.

Yamamoto, M. (2010). Surface plasmon resonance (SPR) theory: tutorial. J-STAGE, 48 (3), 209-237. https://doi.org/10.5189/revpolarography.48.209.

Zhao, X., Huang, T., Ping, P. S., Wu, X. Huang, Pan, J. Cheng, P. (2018). Sensitivity enhancement in surface plasmon resonance biochemical sensor based on transition metal dichalcogeni-des/graphene heterostructure. Sensors, 18 (7), 2056. https://doi.org/10.3390/s18072056.

DOI: https://doi.org/10.15294/jpfi.v16i2.24753


  • There are currently no refbacks.

Creative Commons License
Jurnal Pendidikan Fisika Indonesia is licensed under a Creative Commons Attribution 4.0 International Licensep-ISSN 1693-1246 e-ISSN 2355-3812