Excel spreadsheet model assignment

This is a brief of what is required from excel spreadsheet model. Each sheet should also be briefly described, stating its purpose and any key data/calculations or outputs on the sheet. Use further comments or text in the sheets themselves if required. Input sheet One or more input sheet with raw data. This data can be manually input or imported from an external source. If imported then indicate the source of the data. You should include at least one input sheet designed to be used by a lookup function (e.g. customer details, product details, employee details etc.) Calculation Sheet One or more interim calculation sheets. For example, tax workings, stock summary sheet, sales per employee etc. Depending on the complexity of your model, these sheets may also contain key Outputs. Output Sheet One or more output sheets containing model results. These may be graphical (i.e. charts) or numeric. You should include at least one chart, at least one sheet that allows for user interaction (pivot) and at least one sheet that shows a range of scenarios, a What If analysis or a Goal Seek analysis. Names of each Tab: – input tab or multiple – documentation tab ( how you evolved model) – calculations tab - results tab – testing tab in different colours Summary of technical requirements: 1. Multi sheet 2. Lookup’s, IF’s, etc. 3. Pivot 4. Chart 5. What If/Scenario Manager/ Goal Seek/Macro The subject of the model is on the Irish language. I have the data. I have an example of what it should look like (see attached) . and a spec of what i intend to do