Spreadsheet Report

Authors Avatar

Spreadsheet report

  1. describe what the user needs

The purpose of my spreadsheet is to model the cost of a Limo hiring service. The limos can be hired on a daily basis for a minimum of a day and a maximum of two days there will be a discount for a hiring the limo for more than £50 the discount will be 5% and if the client has hired more than £100 than they will get 10% discount. This means that when it is finished you will be able to see when a limo is being hired, on what date and how long for.

Describe the data needed

For my spreadsheet to be successful it needs to have the following data:

  • Hiring costs
  • Details of limos
  • Details of customers
  •  Prices
  • Discounts

3) Describe the worksheets, formulas and functions you plan to use

I will collect data from the Internet due to the range of sources and data available. I will collect data from theses websites:

Worksheet 1- Limo Details

Worksheet 2- Hirer Details

Join now!

 Worksheet 3- Commissions

The worksheets talk to each other and they talk to the graphs. If I change a figure in a cell which is in the “Hirer Details” sheet then the corresponding cell in the “Commissions” Average of per customer sheet changes as well as the information in the graphs. If I change the names of the limos on the “Limo Details” sheet than in the “Hirer Details” sheets the names of the limos changes, if I change the prices, registration number e.t.c then automatically on the other sheets all the details would ...

This is a preview of the whole essay