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.
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.
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 64 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.