Simple Excel Stock Control Spreadsheet

Posted on November 3, 2011 by computergaga_blog

This post contains the download of a stock control spreadsheet. The spreadsheet is used to manage the level of sweets in stock. As more sweets are ordered, and sweets are sold the spreadsheet keeps a record of the stock remaining.

The spreadsheet is unprotected making the formulas and VBA used available to see. The spreadsheet includes the following Excel techniques;

VBA code to perform much of the functionality
A command buttons to initiate the macro to deduct the number of sweets sold, or add the number of sweets ordered
A table to create a dynamic range for future orders and sales. A Total Row has also been used to sum values
Vlookup functions to retrieve the sweet names from the stock sheet after the product code has been entered

Download the Excel Stock Control Sheet.

Simulate a Dice Throw in Excel

Posted on October 18, 2011 by computergaga_blog

The throw of a dice is a popular away of determining an outcome in board games. This random chance of a number between 1 and 6 provides that element of luck to games.

This tutorial demonstrates how to create a simulation of a dice throw in Excel.

Continue reading →

Excel Fixture List Creator

Posted on September 21, 2011 by computergaga_blog

I have recently been working on an Excel fixture list creator as it is something that I have received many requests for. The spreadsheet can create any sports fixture list.

The spreadsheet can handle;

A maximum 50 teams or people.
The teams or people can play each other once or twice throughout the competition. A drop down list is provided to select the desired number.
An odd or even number of teams can be used.
The fixture list is random. Some of the fixtures lists I found on the web produced the same fixtures unless you put the teams in a different order. This fixture list creator will randomise the teams for you. Continue reading →