This is the second part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites will be created in PowerPoint and imported in Excel as images. How to make a realistic looking digital clock in MS Excel – Part #3 This part (part #3) demonstrates how to use very… Read More... "How to make a realistic looking digital clock in MS Excel – Part #3 – (create a test “1-digit clock” – mainly VBA)"
This is the second part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. How to make a realistic looking digital clock in MS Excel – Part #2 The sprites will be created in PowerPoint and imported in Excel as images. This part (part #2) demonstrates how to use very… Read More... "How to make a realistic looking digital clock in MS Excel – Part #2 – (how to move shapes with VBA)"
This is the first part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites will be created in PowerPoint and imported in Excel as images. YouTube video – how to make a realistic looking digital clock in MS Excel This part (part #1) deals with creating the digit… Read More... "How to make a realistic looking digital clock in MS Excel – Part #1 – (making the digit sprites)"
About Excel animation and Excel games – an introduction: Hello everyone, in this section we will be talking about sprites and and how to use the sprites in MS Excel to create animation. This is going to be a general discussion, a demonstrative, introductory talk. It shows you what we can do with sprites in Excel. In general language,… Read More... "Sprite Animation – what are sprites and how to use them in Excel animation and Excel games"
This is a preview of a minigun Excel animation, that I developed in MS Office. This animated model could be used in future Excel games. I created the graphics in PowerPoint while the animation is being run 100% by VBA code. Join our group to find out more: https://www.facebook.com/groups/excelunusual/ Enjoy, George Read More... "A minigun animation in MS Excel for Excel games"
This is a model I made quite some years back to model the stability of an air compressor driven by an electric motor. The purpose was also to try to select the motor parameters, transmission ratios, energy loss in the flexible couple. I will make the Excel file available at a later date. Read More... "Electric Motor & Air Compressor Excel Animation – Dynamic simulation demo/preview"
I am including a preview of our next series of tutorials about creating wireframe animations and games in MS Excel. These wireframe animation methods can be used in various engineering Excel models, as well as in scientific models and games in Excel. This training will be about creating a simple internal combustion engine 2D model in MS Excel. Join out… Read More... "How to Create a Wireframe Internal Combustion Engine 2D Animation in MS Excel – Preview"
This is an introductory video about creating, scaling and animating wireframe shapes in MS Excel. The tutorial is made from the ground up starting with a blank workbook. A square is created. Scaling factors are added which can turn the square into a custom size rectangle. The tutorial demonstrate the use of VBA driven spin buttons and also VBA driven… Read More... "How to Create Wire Frame Shapes for Excel Animation – Video Tutorial – Part 1"
Here is a basic sprite tutorial by John Doyle at www.excelcalcs.com You can use this method to create Excel game animation or scientific animation in Excel. Enjoy! Read More... "A simple tutorial of using Excel sprite animation on a 2D scatter chart"
This is an animation of an asynchronous electric motor in Microsoft Excel. You can download the model by clicking on the icon below and trying to run it. What is an electric motor and how does an electric motor work? An electric motor is part of a larger class of devices known as electric machines. In order to define an… Read More... "Animated Asynchronous Electric Motor Model in MS Excel"
This is the second post on Excel speed. This has serious implications in creating usable Excel animations. The first part benchmarked the calculation speed of Excel 2003 versus Excel 2007 for various size arrays of formulas. This part analyzes the effect of formula complexity on the spreadsheet speed. About the speed of animated models in MS Excel – part #2… Read More... "About the Speed of Spreadsheets #2"
This is an Excel animation and an engineering model of a Buck voltage switching regulator. Excel 2003 was used. Besides real time control of common parameters such as switch ON resistance, load current, load capacitance, output voltage (vout), input voltage (vbat) etc, the user can also run very specialized tests in which the output current and “vbat” can be modulated… Read More... "Power Management: An Animated Buck Switching Regulator Model in MS Excel 2003"
This post considers several aspects about improving the speed of spreadsheets in both MS Excel 2003 and 2007. It has significant effects on animations in MS Excel. In this first part, a “stopwatch” macro is described which, when incorporated in any of calculation loop, can measure the frequency your loop is executed. In this first part of the tutorial the… Read More... "About the Speed of Spreadsheets #1"