Abstract
Abstract Spreadsheet software is a practical and powerful computing and graphical tool. This study presents a simple way to build a physics simulation in spreadsheet software. The simulation aims to visualise spatial light intensity distribution on an optical fibre core. The simulation can visualise various modes. The mathematical equation in optical fibre is quite complicated. The visualisation may help students in interpreting the mathematical equation and making a connection between theoretical modelling and experiment.
Highlights
Spreadsheet is a powerful computing and graphical tool
Spreadsheet is widely used by people who work in various fields such as economy, engineering, and physics
We construct a simple simulation using spreadsheet to visualise the spatial distribution of light intensity on the optical fibre core for various l and m
Summary
Spreadsheet is a powerful computing and graphical tool. Users can use spreadsheet without requiring complex programming language. Spreadsheet is widely used by people who work in various fields such as economy, engineering, and physics. People use spreadsheet for research and education. It can be used to analyse the research data and display the data in a more communicative form, such as a chart. We can build simple simulations and visualisations when we are discussing a physical equation
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
