- Home
- how to
OEE Solution – Querying Various Sheets
In this post we will pull together formulas that we’ve seen in these posts Formula to get first, second and third highest values Formula to get last row number http://blog.thejaytray.com/excels-indirect-function/ Data Validation Lists COUNTIF Function Before continuing, if you are not familiar with the above posts or functions I would recommend reading them. Although I […]
Continue readingPareto Chart In Excel
Although there are Excel add-ons and more recent versions of Excel make it easier, for a lot of people Pareto charts are still awkward to put together. A pareto chart is a type of chart that contains both bars and a line graph. The bars show the individual order of items in descending order and […]
Continue readingFormula to get first second and third highest values
In this post I will show you how to look up the first, second, third and so on values. This formula can also be used to create Pareto charts which I will also go through in the next post. In previous posts I touched on the idea of having a file that could quickly query […]
Continue readingFORMULA TO GET LAST ROW NUMBER
In Excel, you can write a formula to get the last row number containing data. At first, it’s not an obvious formula, but using Excel’s own logic and lookup function can give you the answer. When i was first asked by somebody for a formula to get the last row number I almost immediately saw […]
Continue readingExcel Option Buttons
It’s been a while since I posted about Excel macros, so I think it’s time I touched on this subject again. In this post we will add Option Buttons to a sheet and have that sheet change based on the selected option. With Option Buttons, only one option can be selected at a time. If […]
Continue readingExcels INDIRECT Function
The INDIRECT “function returns the reference specified by a text string”. What does this mean and why would I use it? I have seen people have problems with amending formula to reference different sheets in particular, most of them just recreate the formula rather than trying to amend it. One of the ways around this […]
Continue readingSpeedomoter For Excel Dashboard
Help creating the speedometer chart for displaying information is becoming a more common request I receive. As the information available to us increases, so too does the reporting requirements. Dashboards are becoming increasingly common and while there is a lot of great software out there for displaying information in a dashboard format, there is no […]
Continue readingCanvas Sprite Sheet Animation
Having gone through moving shapes around screen, let’s bring our retro game tutorials up to date by about 10 years and look at sprite sheet animation. If you have been following the series of posts linked below, then this will add to what you have done so far and you will see some things being […]
Continue readingCanvas Snake Game Tutorial
Feeling nostalgic and looking to create your own phone game Snake? This game tutorial will show you how to create it using just a simple text editor and web browser. If you have been following the series of posts linked below, then this will add to what you have done so far and you will […]
Continue readingCanvas Basics – Arkanoid Game Tutorial
Whether you know it as Breakout, Arkanoid or any of the many names the game is known as, this tutorial will show you how to create Arkanoid using just a simple text editor and web browser. Over the last few posts, we have been looking at elements of code for gaming and we even created […]
Continue readingCanvas Basics – 09 More On Arrays
This is the ninth post in this series looking at the <canvas> element in HTML5. Each post will give a new element of snippet of code that can be put together to create your own games. So far we have covered the main elements needed to create a basic Pong-style tennis game. In this post, […]
Continue readingCanvas Game Tutorial Pong
After several posts about Canvas and game code, we are finally ready to put together our first game, Pong in this game tutorial. For those of you too young to remember 2d games or why it was so important for Marty McFly’s parents to kiss at the dance…. Pong is a basic tennis-style game. The […]
Continue readingCanvas Basics – 08 Bouncing And Deflecting
This is the eighth post in this series looking at the <canvas> element in HTML5. Each post will give a new element of snippet of code that can be put together to create your own games. So far we have displayed text on screen, looked at the mouse’s X and Y co-ordinates on the canvas, […]
Continue readingCanvas Basics – 07 Random Positions
This is the seventh post in this series looking at the <canvas> element in HTML5. Each post will give a new element of snippet of code that can be put together to create your own games. So far we have displayed text on screen, looked at the mouse’s X and Y co-ordinates on the canvas, […]
Continue readingCanvas Basics – 06 Collision Detection
This is the sixth post in this series looking at the <canvas> element in HTML5. Each post will give a new element of snippet of code that can be put together to create your own games. So far we have displayed text on screen, looked at the mouse’s X and Y co-ordinates on the canvas, […]
Continue reading