Introduction to spreadsheets

Authors Avatar

Introduction to spreadsheets

For my spreadsheets I am going to make a spreadsheet program that can keep and work out what is in stock and help Mr. Smith put stock on offer to pull in more customers.

User requirements

Mr. Smith is an owner of a small Pc shop based in Woolwich town center. He has a lot of stock going in but not much going out so he wanted to put stock on offer but does not no how to do this.

He wants a program that can keep records of all of his stock and automatically put it on offer. A way to look at the spec of the products.  He also wants and checkout on this program to offer his customers a new way of payment.

I am going to make a program for Mr. Smith that can keep a record of his stock and help work out what stock o put on offer, a new checkout system will also be made.

I am going to use some of the flowing controls o help build my program

  • Logic formulas/formulas
  • Marcos
  • List boxes, command buttons, ECT.


                                         

 

                                 

This is a screenshot of the main menu of the shop computer. It is basic and easy to use.

         


 Main Menu

What I used on the main menu?

  • Marcos
  • Buttons
  • VB code
  • Word art

The buttons I have made here wete with the control tool box. I then added Marcos to make them change work sheets.

How I made the Marco - I went on the forms by right clicking on the on the tool bar and clicking on forms.

I then clicked on the button and lay it out on the worksheet, the Marco popup come up select the Marco you have made then button then click ok which will make that button act when ever you click that button.

Products

What I used on the products sheets?

  • Marcos
  • VB code
  • Buttons
  • Textboxes
  • Image boxes

Marco is made same as the Main Menu sheet. Each one off the buttons shows the products that are sold in the shop.  

Programming language – I have used VB code which was on the buttons to load a picture in the image box and put a bit of text in the textbox.

Some of the code I used -

Private Sub CommandButton1_Click ()

Image1.Picture = LoadPicture("C:\Documents and Settings\Jaswant Dhaliwal\Desktop\Ravs\k8v-d_l.bmp")

TextBox2.Text = "This motherboard is a perfect merge of the latest AMD Athlon 64 processor with the 64 architecture and Via's K8T800 chipset to juice up your system. Enjoy fast performance with Scalable HyperTransport, ASUS Wi-Fi slot, AGP 8x graphics interface, S/PDIF digital audio, IEEE 1394, Dual SATA RAID, and other advanced features."

TextBox2.WordWrap = True

End Sub

Checkouts

What I used on the checkout sheets?

  • VB code
  • Tick boxes
  • Command Buttons
  • Textboxes

On the checkout sheet I have not used any Marcos because I did not need them but I have used VB code, I have used it on the send button and on the text box. On clicking the button you will be able to send your information to the company computer, a messenger box will appear to tell you that the information has been sent. The text boxes will be cleared or all information ready for the next customer.

Private Sub CommandButton1_Click()

Join now!

MsgBox ("CUSTOMER INFORMATION HAS BEEN ADDED")

TextBox1 = CLS

End sub

 

Month sales

What I used on the Month sakes sheets?

  • Logic formula

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 ...

This is a preview of the whole essay