MsgBox ("CUSTOMER INFORMATION HAS BEEN ADDED")
TextBox1 = CLS
End sub
Month sales
What I used on the Month sakes sheets?
What I did is type in what the products names are then type in how many you have ordered, on row C you type in how many you have and then on row D you type in the price.
Row E is a logic formula which says =if(G4=”yes”,D4/3,”Not on Offer”) this means if G4 equals YES then D4 will be divided by 3 other wise it will say that it is not on offer.
Row F is a subtraction it will tell the owner how many have been sold the formula is =B4-C4.
Row G the row that tells you if the product will go on offer is a logic formula which is =IF(F4>=60,”NO”,”YES”) it means if F4 is greater or equal to 60 then it will be NO other wise YES.
Row H tell you that if G is a No then the price will drop, the formula is =IF(G4=”no”,D4/2,”NO”) it means if G4 equals NO then D4 will be divided by 2 other wise it will come up with No
Testing
I’m going to be testing my spreadsheet to see if the formulas and the macros work.
Main Menu:-
Products:-
Offers:-
Checkouts:-
Month sales:-
Programming Language
These are the programming language that I used was VB (Visual Basic)
Below is screen shots of the codes that I in my spreadsheets.
Main Menu: - This is a screen shot of the main menu sheet it shows the VB code used on the buttons. The code makes the buttons go to the sheets you want to go to.
- Products – Command Button1
- Offers – Command Button2
- Checkouts – Command Button3
- Sales\Stock – Command Button4
Products - This is a screen shot of the Products sheet it shows the VB code used on the buttons, text boxes and images boxes. The code makes the buttons, text boxes and image boxes show us the different products that the store has.
- Motherboard – Command Button
- CPU – Command Button
- Hard disk – Command Button
- 3d FX card – Command Button
- Soundcard – Command Button
- Cases – Command Button
- Text box – Textbox2
- Images box – Imagebox1
- Main Menu – Command Button
- Checkouts - Command Button
Offers - This is a screen shot of the offers sheet it shows the VB code used on the buttons, text boxes and images boxes. The code makes the buttons, text boxes and image boxes show us the different products that the store has.
- Motherboard – Command Button1
- CPU – Command Button2
- Hard disk – Command Button3
- 3d FX card – Command Button4
- Soundcard – Command Button5
- Cases – Command Button6
- Text box – Textbox2
- Images box – Imagebox1
- Main Menu – Command Button7
- Checkouts - Command Button8
Checkouts – This is a screen shot of the checkouts sheet it shows the VB code used on the buttons and text boxes. The code makes the buttons and text boxes clear and send a message say that the customer’s information has been sent.
- Textbox – textbox1
- Textbox – textbox2
- Textbox – textbox3
- Textbox – textbox4
- Textbox – textbox5
- Textbox – textbox6
- Textbox – textbox7
- Textbox – textbox8
- Textbox – textbox9
- Message box – Msgbox1
Month Sales - This is a screen shot of the Monthly sales sheet it shows the no VB code but there was Excel formulas were used on the cells. The code makes the cell work out the different prices, if the products should be put on offer and the offer price of the products.
- Offer Price – Formula
- Price Change - Formula
- Will it go on offer - Formula
- How many have been sold -Formula
USER GUIDE
For
PC Stuff Shop
Welcome to the user guide for the Pc Stuff Shop’s. This user guide has been designed for tanning purposes.
First thing you need to run the program. Double click on the desktop icon and load the program. (See screen shot below)
Once the program has loaded it will start on the main menu page. From here we will show you how to navigate the different buttons and use the different tools.
- Products – The products will take you to the different products that are sold in the shop.
- Offers - This will take you to the offers page this is where all you products that are on offer are.
- checkouts – Once your products have been chosen you will be able to scan them on to your till and if the customer wants to they can pay by one of the online banks. The swipe and chip and pin systems can still be used.
- sales stock - This is the stocks sheets, this is where you will now put the figures for the amount of stock you sell and stock that has come in. this will help you calculate the products that should go on offer.
We are now going to use the products sheet. Go to the main menu and click on the products. (see image below)
Once you have clicked on the button you will load a products sheet this will give you the information on each product and show you an image of the product.
Once you have played with the different buttons, click on the main menu button if you have not done so all ready. (See image below)
This will load up the main menu from here we will go to the offers click on the offers button. (See image below)
Once you have clicked on the offers button the offers page will load as you can see the design of the offers page is the same as the main products. (See image below)
This page works the same as the products page the only different is that it will only show the products that are on offer.
Once you have played with this page you may click on the main menu button. Then click on to the checkouts button.
(See image below)
The checkouts page is connected to the till in the shop. Once you have connected it to the till you will be able to use it.. this will link up to the bank and send money directly in to the store account. In order to use this fetcher the customer has to be a member of the listed online banks other wise run the transaction through the old way.
Once the online transaction has been complete click on the send button and the money will be sent to your account. (See image above)
Once you have click on the send and got the conformation message you now may click on to the main menu button (See image below)
Once back on the main menu click on Sales/stock button this will load up the sales and stock figures. (See image below)
Once the Sales\Stock page has loaded you will be able to see all the products that are in stock. You will be able to add in stock and see products that should be on offer. This is done by do a few steps and a bit of information that you will need to enter.
Step 1 – You will need to get a product that is not already on the program.
Step 2 – You now have to enter the name of the product
Step 3 – Now enter the total amount that was sent to the warehouse
Step 4 – Enter the amount that was sent to your store
Step 5 – Enter the price that the product is being sold at
Step 6 - You do not need to enter any think on the offer price cell the computer will do it for you
Step 7 – Enter how much of the product you have sold since the last stock check
Step 8 – The rest of the cells will be filled in by the computer
With the information now on the sheet you will be able to work out if the price needs to be changed or the product needs to be put on offer. (See image below)
The image below shows the formulas used in the stocks program it shows how the computer will calculate the prices.
This is the end of the guide if you require any further help please vast are website
http.\\www.stockcontroal.com