[jjuneau]

Hi guys/gals, i'm new here. I have a class project that needs the following to be performed:

A form will accept two types of input then perform a calcuation. The two inputs are,

1- How much money a customer owes me
2. How much money the customer paid/tendered

The program must then calculate the change that is due, but it must be displayed in 5 fields..

example -

$5.50 due, customer pays $10
Program must show -

Dollars owed - 4
Quarters owed - 2
Dimes owed - 0
Nickeles owed - 0
Pennies owed - 0

Of course, the input amounts will vary and the program needs to be able to calculate various inputs.

I already have the interface done, but the problem i am having is the coding going into the calculation button..

My problem is trying to figure out how to work with the change portion of the total amount to be paid back..

My program can figure out how to display dollars owed to customer, but I can't figure out how to display the correct change.

Here is my code so far for the calculation button -



Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

'Declaring my variables
Dim decTotalOwed As Decimal
Dim decTotalPaid As Decimal
Dim decPayBack As Decimal
Dim decDollarsOwed As Decimal
Dim decQuartersOwed As Decimal
Dim decDimesOwed As Decimal
Dim decNickelsOwed As Decimal
Dim decPenniesOwed As Decimal
Dim decTemp As Decimal
Dim decPayBack2, intPayBack3, intPayback4 As Decimal

'Assigning some of the variables
decTotalOwed = DueBox.Text
decTotalPaid = PaidBox.Text
decPayBack = decTotalPaid - decTotalOwed



'Assuring the customer didn't short change us with a message box"
If decTotalOwed > decTotalPaid Then
MsgBox("The customer owes you more money, or you did not input amounts correctly!")
End If

'Assigning more values to the variables
decDollarsOwed = decPayBack \ 1
DollarField.Text = decDollarsOwed

decQuartersOwed = (decPayBack - decDollarsOwed) \ 0.25
QuarterField.Text = decQuartersOwed

'Added this code to see what variables are holding what values, 'for testing
totalbox.Text = decPayBack

'Work in progress from below this point
'decDimesOwed = intPayBack Mod 10
'DimeField.Text = intDimesOwed


Please help, even if you have little knowledge.. I can't figure out how to store the change due as a variable and then subdivide it in quarters, nickels, etc..

[KeyWiz]

Dim myChange as Double

'  all your programming code

'
Private Sub MakeChange () ' assumes you have already Calculated Dollars
DIM myQuarters, myDimes, myNickles, myPennies

While MyChange > 0
'As each coin is Calculated the value is removed until you reach 0

	Select Case MyChange
'	   Case = ANY COIN SIZE YOU LIKE OR EVEN DOLLAR VALUES

		Case > 25
			myQuarters += 1
			MyChange -= .25
		Case > 10
			myDimes += 1
			myChange -= .10
		Case > 5
			 ' do nickles
		Case > 1
			 ' do pennies
	End Select
Wend

This post has been edited by KeyWiz: 16 February 2007 - 01:12 PM

[jjuneau]

KeyWiz, on 16 Feb, 2007 - 01:09 PM, said:

Dim myChange as Double

'  all your programming code

'
Private Sub MakeChange () ' assumes you have already Calculated Dollars
DIM myQuarters, myDimes, myNickles, myPennies

While MyChange > 0
'As each coin is Calculated the value is removed until you reach 0

	Select Case MyChange
'	   Case = ANY COIN SIZE YOU LIKE OR EVEN DOLLAR VALUES

		Case > 25
			myQuarters += 1
			MyChange -= .25
		Case > 10
			myDimes += 1
			myChange -= .10
		Case > 5
			 ' do nickles
		Case > 1
			 ' do pennies
	End Select
Wend

Thank you very much!

[jjuneau]

Hi again, I just tried implementing that sample code into my calculate button and nothing happened. None of the textbox fields displayed anything, not even zeroes.. Here is what my code looks like:

	Private Sub Calculate_Button(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

		Dim myChange As Double
		'  all your programming code

		Dim myDollars, myQuarters, myDimes, myNickles, myPennies As Integer

		While myChange > 0
			'As each coin is Calculated the value is removed until you reach 0

			Select Case myChange
				'Case = ANY COIN SIZE YOU LIKE OR EVEN DOLLAR VALUES

				Case Is > 1
					myDollars += 1
					myChange -= 1
					DollarField.Text = myDollars
				Case Is > 0.25
					myQuarters += 1
					myChange -= 0.25
					QuarterField.Text = myQuarters
				Case Is > 0.1
					myDimes += 1
					myChange -= 0.1
					DimeField.Text = myDimes
				Case Is > 0.05
					myNickles += 0.05
					myChange -= 0.05
					NickelField.Text = myNickles
				Case Is > 0.01
					myPennies += 0.01
					myChange -= 0.01
					PennyField.Text = myPennies
			End Select
		End While


	End Sub

[KeyWiz]

Sorry, my bad
I was using .NET code

do it like this -

			Select Case myChange
				'Case = ANY COIN SIZE YOU LIKE OR EVEN DOLLAR VALUES

				Case Is >= 1
					myDollars = myDollars + 1
					myChange = myChange - 1
					DollarField.Text = myDollars
					

Again, sorry

This post has been edited by KeyWiz: 18 February 2007 - 05:31 PM

[jjuneau]

No need to apologize, after all, you are helping me!

My question is this.. I'm not sure how to declare or assign mychangevalue. From the sample code you provided, it's being declared as a double, what does a double variable do as opposed to integer?


Here is my current code, maybe you can help me figure out why it's not working?


Dim myChange As Double
' all your programming code

Dim myDollars, myQuarters, myDimes, myNickles, myPennies As Integer

While myChange > 0
'As each coin is Calculated the value is removed until you reach 0

Select Case myChange
'Case = ANY COIN SIZE YOU LIKE OR EVEN DOLLAR VALUES

Case Is >= 1
myDollars = myDollars + 1
myChange = myChange - 1
DollarField.Text = myDollars


Shouldn't myChange = val(total2payback) ??? I'm not sure though, but i look foward to your helping reply!

[Nightshade]

I'm working on something very similar. However we cannot use Case statements. that being we have not got to them yet.

So I have to use mathmatical funtions to computer each variable step by step. My problem is that I am getting a "devide by 0 exception".

Example is that I have a total of $50.33 with $55.00 tendered. Change Due is $4.67.

To compute "dollars" owed I used "dollarsChange = changeDue \ 1"

That being a division function to return an integer minus it's remainder. This should have returned 4$ (at least that is how the book explains it the function of integer division. However the answer returned was 5$

I am confused as my book states such a division should have dropped the remainder 67 cents not round up to the next whole. Anyone care to point me in the right direction?

[Nightshade]

OK for now I'm doing thus but it still doesn't feel like the "right answer.

changeReminaing = changeDue Mod 1
dollarsChange = changeDue - changeRemaining
Me.xDollarsDueLabel.Text = dollarsChagne.ToString

Of course this still leaves me to do all the others but at least now I get a properly computed integer without any rounding to cause errors.

[Nightshade]

Well I used the mod function throughout and all functions well but it still seams to me that there ought to have been a cleaner method.

I'm still open to suggestions should anyone have any.

[jjuneau]

Nightshade, on 28 Feb, 2007 - 04:26 PM, said:

Well I used the mod function throughout and all functions well but it still seams to me that there ought to have been a cleaner method.

I'm still open to suggestions should anyone have any.

Well after much frustration and with help from another student, I got my project working. Here is the source code for the Calculation Button...

'Declaring my variables
		Dim decAmountDue, decAmountReceived, decChangeDue As Decimal
		Dim intDollars, intQuarters, intDimes, intNickels, intPennies As Integer
		'A variable to temporarily store the change for each calculation
		Dim intTempValue As Integer

		'Calculates the total amount of change due to customer
		decAmountdue = Val(DueBox.Text)
		decAmountReceived = Val(PaidBox.Text)
		decChangeDue = decAmountReceived - decAmountDue

		'Displays a messagebox letting us know the customer didn't give us enough money
		If decAmountReceived < decAmountdue Then
			MessageBox.Show("Customer shortchanged us, or you entered something wrong!", "Hey!")

			'Clears the text fields to start over
			Call Clear()
		End If

		'Formats the proper fields to display numbers as currency format
		DueBox.Text = Format(decAmountDue, "Currency")
		PaidBox.Text = Format(decAmountReceived, "currency")
		totalbox.Text = Format(decChangeDue, "currency")

		'Converts change due value into pennies
		intTempvalue = decChangeDue * 100

		'Calculates our dollars owed field
		intDollars = intTempvalue \ 100
		DollarField.Text = intDollars

		'Calculates quarters owed minus dollars we are going to pay
		intTempValue = intTempValue Mod 100   'Calc Quarters remaining minus dollars paid
		intQuarters = intTempvalue \ 25
		QuarterField.Text = intQuarters

		'Calculate the number of dimes
		intTempValue = intTempValue Mod 25	'Calc dimes remaining minus quarters paid
		intDimes = intTempvalue \ 10
		DimeField.Text = intDimes

		'Calculate nickels
		intTempValue = intTempValue Mod 10	'Calc nickels remaining minus dimes paid
		intNickels = intTempvalue \ 5
		NickelField.Text = intNickels

		'Calculate pennies
		intTempValue = intTempValue Mod 5	 'Calc pennies remaining minus nickels paid
		intPennies = intTempvalue
		PennyField.Text = intPennies

[XJ12L]

First of all: My code isn't exactly VB but very much alike, let's call it a VB derivate.

I created almost the same code, it looks like this:

  For i = 1 To 12
	iTimes = ModInv(dChange, dValue)
	If iTimes Then dChange = dChange - (iTimes * dValue)
  Next i

In turn dValue will be filled with the value of the next banknote or coin (in my case (in €) 50, 20, 10, 5, 2, 1, 0.50, 0.20, 0.10, 0.05, 0.02, 0.01)

The function ModInv I created myself and it looks like this:

Function ModInv(dGetal As Double, dDivideThrough As Double) As Double
  ModInv  = (dGetal - Mod(dGetal, dDivideThrough)) / dDivideThrough
End Function

This all works beautifully but now comes the hard part:
I added checkboxes for each possible dValue in which a cashier can make clear he or she is lacking some coins or bills. Now I want to recalculate the whole traject ... but how?

For example:
I need to return 8 cents but I got no 1 cent coins. So, the code has to stop using the 5 cent coin (that can be arranged) and instead use 4 times a 2 cent coin.

Worse example:
I need to return 11 cents. My code uses a 10 cent coin, skips the 5 and the 2 cent and uses a 1 cent coin. Now I still got no 1 cent coins. So, in this case I have to tell my code NOT to use the 10 cent coin anymore (that can be arranged). Now my code decides to use 2 times a 5 cent coin and still the calculation gets messed up.

This problem intensifies on 'the way up'.
21 cent to return can't use the 20, the 10 (not 2 times that is) nor the 5 cent coin (not 4 times that is).
51 cent to return can't use the 50, the 10 (not 5 times that is) nor the 5 cent coin (not 10 times that is), etc.

This post has been edited by XJ12L: 20 September 2007 - 02:33 AM