Ассоциации

[BoNik]

вдова ханта-подайте сироте 5копеек на хлебушек

[Elvic]

подайте сироте 5копеек на хлебушек ===> новис-попрошайка

[BoNik]

новис-попрошайка-нупка неграмотный

[Elvic]

нупка неграмотный ===> все мы в памперсах бегали

[BoNik]

все мы в памперсах бегали-эх когда это было

[мдя]

эх когда это было - ностальгия

[BoNik]

ностальгия-амнезия...

[Chainer]

амнезия - откат

[Darkarchangel]

Амнезия --- ПОШЛИ ВЫ ВСЕ НАХУЙ, ЕСЛИ НАХУЙ БАНИТЬ НАХУЙ ХАТИТЕ НАХУЙ ТО БАНТЕ НАХУЙ БЛЯТЬ НАХУЙ А АССОЦИАЦИИ ВАШИ ЗАААААЕЕЕБББААЛЛЛИИИИ ФЛУУУДЕРЫ БЛЯТЬ НАХУЙ ПОШЛИ ВСЕ ВЫ НАХУЙ И СПАКА С СОБОЙ ЗАХВАТИТЕ НАХУЙ!

[Chainer]

ыыыы

[Darkarchangel]

бЛЯ)=весь мат перекрыло)=

[Elvic]

ыыыы ===> ГыыыыыыЪ

[BoNik]

ГыыыыыыЪ-мхахах лол (флуд)

[Darkarchangel]

ЗАТКНИТЕСЬ!! ВСЁ НЕТУ АССОСОСИНАХ УЙ АЦИЙЙ БЛЯТЬ ПОКА МЯ НЕ ЗАБАННЯТ ПОШЛИ НАХЕР СИДЕТЬ БЛЯ!! ЗАЕБАЛ МЯ ЭТОТ ТОП УЖЕ ГОД ЕГО ТЕРПЛЮ БЛЯ ФЛДУДЕРЫ ВАШУ МАТЬ!

[BoNik]

маразм крепчал)))

[Sindaer]

Darkarchangel, - не нравится - чего читаешь?

мхахах лол (флуд) ==> никогда не кончается

[Darkarchangel]

DDDD:

DDDDDDD:

DDDDDDDDDDDDDD:

DDDDDDDDDDDDDDDDDDDDDDD:

DDDDDDDDDDDDDDDDDDDDDDDDDDDDDD:

Specification
I have been asked by a company named “One&one ltd.” to create a database on a spreadsheet for them.

This company sells such goods as digital TVs, Computers, Different parts of computers like memory cards, video cards etc. The company also sells CDs and DVDs. They also want to know what profit they will make over they after they sell all the possible items. They also want to provide a look up system so they can see weather they have a certain product in the stock or not.

The company expects from the new electrical system database of all the stock in the shop how much it costs to buy and sell the stock and how much they have in the stock. They also want invoices and purchase forms with the price of the stock how many they want and what the total comes to, on the invoice they need to know what the price of the stock will come to after Vat and if the customers gets a discount or not.

Plan
The system I have designed consists of the following:

Main Menu
I will create a main page with macros on it which will have control keys which will link them to other pages in the workbook.

Database
The data base will give information on the stock which includes all the services the company providing and the prices. The database will also be used for v-lookup.

Invoices
To show how much each customer owes the company and what they want to buy, this will template and formulae which will be created using the vlookup table and functions which automatically calculate when data is input.

Purchase order
This is to show what the company needs in respects to stock ad how much it will cost to order the sock.

Product lookup
To help find products easily and quickly using a V-lookup of the company’s database.

Main Page

This page will help to give access to the other pages in the system using macros.

Database

Invoices

                   Cash

                   Cheque

                   Debit

                   Credit Card

Purchase order

Product lookup

Stock add system

This information will be shown through the v-lookup() which will be created on this sheet.

The six complex facilities I will use in my excel system will be the following:
1.) List and tables
2.) Drop down boxes to select data for entry
3.) Macro buttons
4.) Validation boxes
5.) Multiple sheets with links between them
6.) Form templates

User Guide
Getting started:

Here I will describe how to open the company system in easy and understandable steps.
First of all
Turn on your computer and wait for the windows screen to load up. When the computer has loaded you will see this screen:

Once you have this screen you will have to double click the excel icon shown below:

Once you have double clicked on the icon the computer will automatically load up excel, wait until you have got this screen on your computer:

Once you have done this your screen will look like this, you then need to open necessary files to open the system.

When you have clicked on the open icon you will have this on your screen:

Once you have this screen you will need to select the ‘Electronic database’ file by clicking on it, then you have to press ‘Open button’.

Once you have opened the electronic database for One&One Ltd. you will see the screen like this:

Now you will be able to learn how to use the function of the system in the next chapter: such as the macro buttons and the V-lookup function.

Now you will learn how to use each of the different pages in the system.

Once you have loaded the system, you are now ready to learn how to use different functions on the different pages.

If the system is loaded properly you should have the main page on the screen:

As you may notice there are six macro buttons on the page, which will take you to the different pages in the system as, shown above.

To open a different page in the system you will have to click on one of the buttons we suggest for tanning purposes you should click on the database button.

Database

Once you have clicked on the database button on the main menu you should now have this screen on your computer:

Here you can change Items’ names, ID code, put your quantity of the items in stock and put cost price.
Warning: do not change information of other columns.

If you accidentally put ID codes in the wrong order just press ‘Sort Data’:

There are also some macros on the bottom of the sheet:

The ‘Print’ button is use to print current sheet. The ‘Save’ button is used to save entire worksheet. The refresh button resets all old values in the database.

Purchase form

When you open Purchase form it should look like this:

The bottom of the sheet contains the purchase form:

This form has everything you need to make the right purchase.

Product lookup

Product lookup is used to check if you have some specific item or not.
When you open the ‘Product lookup’ sheet it has to look like this:

You can choose any ID code and the Item, Amount in stock, Cost price and Sale price of the product will be displayed automatically.

Invoice form

The invoice form is used by the customers to order company’s products. My invoice form has the address of the customer and the company, company’s logo and contact details, it also has today’s date:

I also designed a table for invoice form:

As you have already noticed, the customer will be able to get a 5% discount on everything if he/she bye more then 5 items. I also have to mention that if customer’s city is London the delivery will be just £20.

Total Selling price graph and Total profit graph

I also have two graphs which show the total selling price of the products and the total profit:

I have completed the description and now you are completely ready to work with it alone.

Documentation
Unit 3

In this document I will explain how I created the macro buttons, the v-lookup on both the purchase order form and the invoice form, I will also explain several other formulas I used for this assignment.

Main Menu
I have 6 macro buttons which link to the different pages of the system.
1st one is Purchase form macro;
2nd one is Product lookup macro;
3rd one is Invoice macro;
4th one is Database macro;
5th one is Profit macro;
6th one is Total selling price macro.
I recorded each macro by opening tools tab and choosing Record new macro in macro menu. I opened the correct page for each macro and stopped recording. Afterwards I created 6 buttons and put the right macro in each button.

Database
On the database there are number of a different formulas, which are need on the spreadsheet. I have total price formula which is (Amount * Selling Price), total price formula including VAT (Amount * Selling Price + Amount * Selling Price * 17.5%), formula for selling price which is 10% bigger then Cost price (Cost Price + Cost Price * * 10%), Profit per item (Selling Price – Cost Price), Total Profit (Profit Per Item * Amount).

I also have a lot of macros. 1st returns you to the main page. I recorded it the same way as I recorded the macros in main page. The 2nd one sorts the data; I recorded it by using sort data from the data tab. The function of this macro is to sort numbers if they are in the wrong order. I also have refresh function which resets all the values on the database page to zero. I also have macro which prints page, I recorded it by pressing print button and stopping the recording. I recorded the save macro in the same way as I recorded print macro --- just by pressing save while recording a macro.

Invoice and Purchase forms, Product lookup
For these pages I used very important formula. Vlookup is usually used for electronic databases. Its function is to show products from database when the specific code is selected. Vlookup function in the invoice looks like this: =VLOOKUP(C19,Database!$B$8:$J$17,2)
It means that for specific value of sell C19 Vlookup has to look into the database and copy the right value from Item column.

The macros refresh, print, save, return to main page were recorded in the same way as they were on the Database page.

I also have ‘If’ function on the invoice page on the discount page. It means if the quantity of bought items more then 5 then customer will receive a 5% discount.

I also have two graphs which show total selling price and profit. I have created them by using a chart wizard.

Testing

Macros

Testing ‘Database Macro’ on the main page:

Macro is working and it opens database when we press the ‘Database’ button.

Testing ‘Sort data’ macro on the database page:

This macro doesn’t work because an error has occurred. We will have to fix it. I will delete the current button with macro by pressing on it with right button and pressing delete on the keyboard. To record a new macro I will have to choose ‘Record new macro’ from the tools panel.
Now when recording is in progress we will have to press ‘Sort data’ button in the Data panel. After this we have to choose sort by ID code and set Ascending order. The last thing we have to do is to press ‘Stop recording’ button.
Now we have to create a new ‘Sort data’ button.

Testing new ‘Sort data’ button:

The macro is working and we don’t receive any error reports.

Formulas

Database formulas:

I used a lot of formulas in this assignment. For sale price I had to use this formula: $I$2*E8+E8. Sell I2 is the absolute because it shows how much bigger Sale price from the cost price.
So the formula is ‘Percentage * Cost price + Cost price = Sale price’.

Total selling price = Amount in stock * Selling price.
This is very common formula.

Total selling price with VAT = Total selling price + Total selling price * 17.5%.
This formula means that Total selling price with VAT supposed to be bigger on 17.5% from Total selling price.

Profit shows how much profit you will get from selling one unit of current goods.
The formula is ‘Sale price - Cost price’.

Total profit shows how much profit you will get from selling the whole stock.
Total profit = Profit * Amount in stock.

For this assignment I also used an ‘If’ function. For example:

This function means that if cell G12 equals “London” (we have to put quotation mark to show Microsoft Excel that data is a text data) then the delivery costs only £20.00, but if cell G12 equals to any other value then delivery costs £100.00. Cell G12 is in customer details and it shows customer’s city.

I also used ‘If’ function for discount:

If customer buys more then any 5 items he gets a 5% discount on everything he buys. This formula is a little bit complex then the previous one. It shows that if sum of the quantity column is higher then 5 then discount equals 5% from total. We are going to use this in subtotal. To find the subtotal we have to find the sum of Total, VAT and Delivery and extract the price of discount.

For this assignment I also used a ‘Vlookup’ function:

‘Vlookup’ function shows information from other sheets of the same document using the information it has. For example: under ID code 2 we have Sony Media player which costs £149.99 and the current amount of Sony Vaio Media players in the stock is 50. ‘Vlookup’ function used the information from database.

Evaluation
For this assignment I used a lot of techniques like Macros, different formulas, shading, I used different fonts and combined colors and tables. I tested all of macros and formulas and pleased with their work. At this point everything works properly.

[Elvic]

мхахах лол (флуд)====> спам и флуд все перетрут

[BoNik]

спам и флуд все перетрут-оксиома

[Darkarchangel]

Я вас всё равно перефлужу...

Report Update

Results

I thought this work is going to be very hard because I will have to deal with a lot of people and help them to solve their problems. I was not very confident with this work at the beginning. I had a task to complete at least 60 pieces of support. After the first few weeks I was very confident with my work. I had done a lot of supports and I was able to solve almost all of them immediately. I had few problems I could not solve, that is why I had to use manual. I used manual from the document’s menu in ‘Help’ toolbar. Sometimes I had to read throw a lot of problems to find mine, but sometimes I was not been able to solve the problem even after I read the manual. In this case I consulted technical personnel. I had some users unable to solve some problems in Dreamweaver, Front page, Fireworks, etc. When I was not been able to solve problems with this software, I consulted technical documentation to help them. I manage to make my support very effective.

I had been able to solve almost all the problems immediately and I was doing my best when I could not solve the problem in a short term.

After I finished providing support I realized that I have learned a lot of useful information from using manuals and helping people. I am glad I could help a lot of people effectively and teach them how to solve their everyday problems. I’m also glad I have learned a lot from them.

Index of regular problems

I have noticed that a lot of people have the same problem. It was easy for me to solve them because I solved them sometimes more than ten times, but because a lot of people asked me to help them with the same problem it started getting really annoying. That is why I think it would be better if I will help a lot of students by creating index of regular problems. It supposed to be a sheet with the most common problems and the explanation on how to solve them.

The first thing I have to do is to find the most common problems. I have to check my logs and make a list of all problems and check how many times they had occurred. The point is to find 3 or 4 most common problems which occurred more often then the others. After this I plan to create very simple and friendly support sheet with the good explanations on how to solve the most common problems.

I found the most common problems and I am now ready to create a help sheet for them. As I have already told – the help sheet is probably going to be near almost each computer in the Whitehall Suite, so anyone can find the answers for the most common problems. The second thing is the title. It supposed to be very eye catching, so anyone could notice it and look inside. That is why I used ‘Insert WordArt’ button and typed: Are you stuck? Look here! May be you will find the solution! I also used fireworks to create a nice notices and I also inserted few images from Clip Art.

The next thing I have to take care of is nice layout and presentation of each problem and explanation to it. I tried to use all the space on the page, so the help sheet is going to look very accurate, simple and presentable.

I have managed to create an accurate index of regular problems and their solution that enables efficient and rapid response to such problems.

I hope everyone will find the solution for his/her problem using my support sheet. I also hope college can try to improve support for programs that are used all the time. For example: creating manual for the beginners with the basic description of the program and its functions. However every time you login, Windows asks you if you need help with adjusting to IT.

Dealing with users

I provided most of my support face to face. At first I found it hard to communicate with the people I don’t know, and to help them with the problems, but in one week time I used to it. It is easier for me to provide help face to face because I can see what the problem is and I don’t have to guess. Usually my support was very efficient.

Providing support on telephone was much harder. Sometimes it was very hard to understand a person. So I had to be very patient and calm to solve them. I had to check that everything is fine, so I had sometimes to ask very easy questions like: is the computer turned on? But in general I tried to effectively solve the majority of problems.

Helpsheets

For this assignment I had to create 2 helpsheets that can provide a nice description and help on working with important software. One of the helpsheets had to be created for the beginners with friendly language, and a lot of graphs for explanations. The second one had to be much more professional for the experienced users. It had to include more technical language and it had to have graphs only there where it was necessary.

Simple Helpsheet
One of the documents I had to create for this assignment was Simple Helpsheet. Simple means that it was mostly for beginners. It was not hard for me to create such helpsheet, but I had to keep in my mind that this helpsheet is for beginners and the language must use very clear and friendly language for this helpsheet.

Complex Helpsheet
The second helpsheet had to be for experienced with IT users, that is why I used less graphs, and more explanation in this helpsheet. It also had to be clear, accurate and well presented. I had to use more technical language to explain my point.

I managed to design clear, accurate, well presented and easily understood by users training materials.

Evaluation

From the beginning of my assignment I had to show my IT knowledge a lot. I had to be able to deal with majority of windows software when I had to create forms, graphs, technical documents, etc.

At first I had to prepare suitable forms and documents for providing support. I used Microsoft Word to design two forms which I used to keep the record of my support. I am spending a lot of time every day working with computers. I think this helped me greatly to complete my assignment, because I had to help experienced users as well. Usually their problems were not hard for me, and I managed to deal with them very rapidly and efficiently.

When I was providing telephone support, I had to listen to the problem very carefully to understand it. A lot of times I was capable to guess what the problem was, because when I was inexperienced with this problem I described it the same way as my customer on the telephone. I understood and have been able to solve almost all problems my customers have had.

I had to keep up with my plan, that is why I had to finish providing supports on the specific date. I had to create few important documents after providing the support. I had to use almost all of the windows software to create those documents. They had to include analyzes, graphs, information about the most common problems, some of customers’ details and a lot of information about the support I provided. Forms and different documents I have designed before providing support helped me greatly to design those documents.

I was not very confident in my skills before starting this assignment, but I found myself very useful for a lot of people. I became much more confident in my skills after I managed to complete providing support before the deadline in my plan.