Closed

World DSS application (excel)

This project will be about rugby union results and teams and being able to compare them with results with the other teams. the examples i will give are all very similar to what i [url removed, login to view] appropriate formulas and tools to implement your DSS. You will choose some but not all from the following palette of items covered in class to achieve your outcome:

1. Formulas from:

a) Financial (NPV, IRR….)

o Do not use the PMT formula as it was the class case study!!!

o Ditto re: Invoice

b) Database (DSUM, DMIN….)

c) Lookup & Reference (INDEX, LOOKUP, VLOOKUP, HLOOKUP….)

d) Logical (IF, AND, OR, FALSE….)

e) Statistical (AVERAGE, STDEV, MEDIAN….)

2. Charts

3. Developer Form controls e.g. drop down boxes (combo), option buttons…

4. Data Validation

5. Pivot tables and charts

6. Power Pivot, Power View, Power Map modules and Power BI website

a) Multiple Tables

b) Further chart options

c) Interactive 3D maps

7. Printing and any other macros attached to button(s)

a. Other macros e.g. menu, sort

8. Spreadsheets to be:

a. Fully tested

b. Paginated

c. Protected where appropriate

d. Presented well with logos, pictures and a house style

Skills: C# Programming, Excel, Microsoft Access, SQL, Visual Basic

See more: web application excel sheet, run external application excel, j2ee application excel sql, spreadsheet program before excel, simple data analysis techniques, spreadsheet evolution, when was wordperfect introduced, spreadsheets before computers, what is the most popular spreadsheet application on the market today, what is the name of the first spreadsheet program, a brief history of spreadsheets by d. j. power, web application excel, world countries cities excel sheet, quick mortgage application excel, world war application facebook, best world radio application iphone, mortgage application excel, vbulletin world warcraft application form, paste application excel macro, world warcraft application form

About the Employer:
( 0 reviews ) Castlebar, Ireland

Project ID: #15545101

3 freelancers are bidding on average €23 for this job

€23 EUR in 1 day
(2 Reviews)
2.9
€23 EUR in 1 day
(0 Reviews)
0.0
benjaminshi

Bid for this project Relevant Skills and Experience Working in Microsoft as Data Analyst. I'm proficient in PowerBI/Tableau/excel/python Proposed Milestones €24 EUR - 24

€24 EUR in 1 day
(0 Reviews)
0.0