Shareware and Spreadsheets

These spreadsheet models are here for my Business Studies students so they may explore the formulae in the models, improve the models and undertake a range of "what if" exercises (and other convolutations!).

EXE - executable files
Files listed below have been zipped and translated into self-extracting/executable file format. At the DOS prompt or using the Windows/Program Manager/File/Run facility - execute (run) the file and the .EXE version will unzip directly into an XLS format ready for loading into EXCEL.

• Chartist - Flow Charting shareware

Example Spreadsheet Models (MS/EXCEL format)

More to be added soon.

• Simple Break-Even Point Model (CVP Analysis - Dolly Toys)
• A Student Results Spreadsheet for a Course
  
  Illustrates the use of nested =if and simple statistical functions.
• A spreadsheet to track cheque expenditure in a Club
• Generate a Pay slip
  
  This spreadsheet contains text and no formulae. The students' task is to generate the formulae (=if, =vlookup etc) from the rules/data given in the spreadsheet.
• Economic Order Quantity model
• Pareto/ABC Analysis (xls format) - use "Save link as"
  This small stock control data set may be used to create ABC/Pareto graphs of stock by value category.

• Lloyds Bank Business Planner software

For further instructions and - if you need it access to file compression/expansion shareware - Download PKWARE and Instructions OR Winzip