User Needs The User Of My Spreadsheet example essay topic

Introduction Spreadsheets are used in all aspects of financial computing. Shop owners, Company chairman and directors all need to know how their businesses are doing and the main way to do this is by using spreadsheets. Spreadsheets are computer models that simulate a real life scenario using data that has to be input by the user. On this occasion, the data is to be for finance; profit / loss figures, so the user has to input financial figures for the spreadsheet to calculate and show what the future holds for the user and their company. There are also labels that are texts with no numerical data to separate the actual financial figures from other numbers.

What The User Needs The user of my spreadsheet is a sport shop owner who needs to collect and distribute data to predict capital income for the future. They need to be able to see the profit / loss of their company and how, if the input into the spreadsheet is altered, the output is changed also. My spreadsheet is a model that simulates the real thing. As a shop owner, the user should be able to record the various categories of income and expense and decide their course of action depending on how the store is doing on the spreadsheet.

It should allow the user to make comparisons of profit / loss for that particular week, month or year. However, I will be going through this product as though I were the user and make references to the actual user of real life at appropriate times. I will be presenting the worksheets over a time span of a month so as not to make it too complex to understand. Data Needed The data needed for my spreadsheet is: . The Names of all my products. The Prices of all my products and how these change depending on the VAT and wholesale price.

Profit and Loss figures made from subtracting expenses from income. The Stock figures of each item. The 'Amount Sold figures fo each item. The amount of VAT on each item I will obtain the primary data (e.g. prices of products) by making it up but I will not make it too extravagant or extortionate by making it similar to prices that I have seen in shops similar to mine. The secondary types of data (profit etc) will be calculated by obtaining information from the primary data using various formulas (mathematical equations used to calculate) and functions that I have stated below. Plan Of project I am going to make 5 worksheets that are to be laid out as shown on my written plan by hand.

One is for income and the various categories that go with that. The others are for expense, Wages (a detailed part of expense), graphs and discounts, (which are again too detailed to be fully fitted on to the expense part of the worksheet). Sheet 1 will be the income side of my spreadsheet, Sheet 2 will be the wages side, Sheet 3 will be the bills (expense), sheets 4 will be the discount part and 5 will be used for graphs. I will explain each aspect of my spreadsheet and all of the functions and formulas that I used with it. The spreadsheet is designed to give data for one particular month rather than weeks or years which are too complex to present.

The functions that I am going to be using are: . = V LOOKUP. = IF for the stock warning level (where stock is reordered automatically), discounts and wages and publicising items... MATCH Function. ABSOLUTE AND RELATIVE CELL REFERENCING. MACRO Function-I will use this to link the worksheets together and this will be explained in detail later on...

MIN and MAX functions to work put what products are doing well and what products are not. This will help me to find put which of my products is the best and worst over a specified range... AVERAGE formula to work out how well I am doing on average for the profit of my company. Setting Up Grids Onto Excel I now was to put all of the information that I had drawn by hand for the income aspect of my spreadsheet on to Excel. This is how I done so: The first part of inserting my spreadsheet on to Excel was putting in all the various forms of information such as the headers and the first parts of figures for my items. Next I would go on to add the rest of the necessary information that can be seen in the screen dump below.

This was to include the total profit I have made from my income for the month and other things like Publicising that will be explained further below. Here is the second part of inputting my spreadsheet onto Excel: The things that I typed into each cell heading containing a formula were: . D 1 = B 2 O. 175 (wholesale price VAT). E 1 = C 2+D 2 (Retail +VAT). H 1 = IF (SK.