|
|
|
|
|
|
|
|
|
|
|
Experience
With experience of using Excel from its very beginning John Spencer has taught and developed software solutions that have enabled mundane tasks to be automated, while still leaving the powerful data analysis within the hands of the user.
Most of us use Excel to view and analyse tables of data: charts, pivot tables and filtering. Gravitas can help you make the most of some powerful features you may not be aware of or you don't have time to explore:
- Macros
- VBA coding
- Forms and controls
- Advanced Formulae
- Animations based on Mathematical formulae
|
Some Examples
A thermodynamic calculator described in the Carborundum Case Study uses Excel to provide a simple technical sales tool for field engineers to provide quotations for customer based on their requirements.
A menu driven Excel Quality Assurance System only just being replaced by Access after over 10 years of reliable use.
Some fun examples of John's adeptness at providing visual feedback on Mathematical concepts can be seen in the Pendulum and Trigonometric examples which can be viewed in the short video clips below. Both work in standard Excel spreadsheets and are available for download on request.
Sin Curve Animation
 Easy to follow explanation of the Sin Curves relationship to the angle of the circle - also available for Tan and Cos
Path of a Cycloid
 Follow the path prescribed by a point on the edge of a circle as it rolls: the cycloid.
Pendulum Swing
 Follow the tangential swing and acceleration of the Pendulum based on the angle and length of string.
|
|
|