I'm working with an API, for this I'm using this particular call: [URL]
If i use this, I will get all the .price values:
For i = 0 To .bets.Length - 1
With .bets(i)
Print(.price)
End With
Next
Can I calc the average .price value? I will need to sum all the values as well.
I put comments on the average output since I kept getting error messages about that. My out keeps saying:
Maximum value: 33
Minimum value: 33
what am I doing wrong?
Option Explicit On
Option Strict On
[Code]...
Heres my [code]...
For example if I enter in 45, 45 and 89; I should get 55.75. But instead all I get is 55. How do I get the percentage?
"I need to create a program that will allow the user to enter in 10 test grades from a class. I need to store these grades into an array, and use a loop to add up the total. Then I'll need to output the average, and the letter grade for the average using:
90 - 100 A
80 - 89 B
70 - 79 C
60 - 69 D
Below 60 F"
That's all it needs to do. Here is some code that shows you that the only thing I know how to do is (allow the user to enter in 10 test grades from a class.) The rest I'm so lost on and have a crappy instructor. This assignment is due tomorrow, but the instructor is not available over the weekend.
Here is my This is all I have:
Dim MyNumbers(9) As Integer
Dim Total As Integer
Dim i As Integer
[Code]....
I have text1=a, text2=b, text3=c, text4=d, text5=e
Now I want to calculate the average of the values,
Here's a simple way
average=(a+b+c+d+e)/5
But what if i have values only in 3 textboxes, that means the code will still divide the sum of the values into 5, that will not be correct!
My objective: to check the remaining btns in play and obtain the cash prizes in the remaining btns then calculate the average. It may seem simple but it actually isn't.
Here is what i have so far:
Private Sub btncase1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncase1.Click
If usercase = 0 Then
usercase = btncase1.Text
[CODE]...
I have a spreadsheet that has two columns (A and B) - Column A contains Month/Year and column B contains sales. I would like a bit of vba that will look in column A to find the month/year then calculate from column B the average sales for that period. So for example:
Date Sales
Jan 11 500.00
Jan 11 250.00
Mar 11 152.00
Apr 11 116.00
So in other words there can be a number of lines with the same date/year and the code will need to identify these and average all sales from column B associated with that particular date. I would like the output to appear in a summary table showing the total average sales for each particular month - perhaps this could be output to a new sheet?
I'm in a bit of a pickle. I'm new to Visual Basic and I have been writing a simple program to rate movies. I'm stuck on calculating the average from the text file. The text file holds the numbers from 1 - 10 (ratings). I want my program button to add all the values from the text file and display the average from the total amount of ratings and display them into a text box.
[Code]...
Write a program to calculate the average of three exam marks. The input and output should be done by subprograms GetMarks and DisplayAverage respectively. the calculation should be done by a function, CalcAverage. This is my code:
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
Dim student As String, exam1 As Integer, exam2 As Integer, exam3 As Integer
Dim average As Double
lstResult.Items.Clear()
[code]....
I'm trying to write a program that allows the user to enter 10 numbers into an input box and then the program will use a function to calculate the average of those numbers. I'm really illiterate when it comes to Visual Basic.
View 2 RepliesI'm looking for a way to calculate an average from a input integer within a loop. When the user enters something like -90, the average will be calculated using the previously input numbers.
View 4 RepliesI want to calculate the average value of excel table readings 1 hr once... how do i import the sheet and how do i calculate the avg in vb.net?
View 4 RepliesThis is the current incarnation of what I have:
'Program: Ch4E4.6
'Programmer: Jeff Pannell
'Date: October 1, 2009
'Description: This will allow for entry of a worker's name and the number of pieces completed. The program will then calculate a pay rate, but also determine an average and summarize number of pieces made, total pay and an average pay per person.
Public Class PieceworkForm
'Declaration of modular-level constants.
Const PIECE_RATEA_Decimal As Decimal = 0.5D
Const PIECE_RATEB_Decimal As Decimal = 0.55D
Const PIECE_RATEC_Decimal As Decimal = 0.6D
[Code] .....
So, my problem is that whenever the form is executed..a user would type in a worker name, and the amount of pieces made. I get a dollar amount earned and then a total pay, though they seem to be the same. More than likely I've got some sort of bad logic in there mathematically.
For my programm I was told to do a programm to calculate the total and average rainfall. I have done so, but now I am supposed to use two function procedures to calculate the total and average rainfall. I can not seem to figure it out and it is very frustrating.
[Code]...
In vb.net, im using objWriter.Write("playerA= "x"")as you can see im using double quotes inside double quotes, how do i skip it so the error doesnt show up?in php you make an "" to skip the string like ("playerA = "x" ")
View 6 RepliesWrite a program that reads in a set of grades for a class.The program takes in the number of students in the class from the user. When the Get Grades button is clicked the program then reads in a grade (0-100) for each student using an inputbox. The program should then display the percentage of students who pass and the percentage of students who fail.The program should call a function to calculate the average grade for the class. Then finally the result is then displayed.
Public Function GetPassRate(ByVal intGrade As Integer) As String
Do Until gradeCounter >= NumericUpDown1.Text
If intGrade >= 40 Then[code].......
I'm trying to calculate an average no from data imported from a text file using streamreader. I'm not sure how the loop should read, and the result (average) I want to hold in a separate variable for future use.[code]...
View 1 Repliesi am trying to code a program in vb.net that will calculate the predominant or average colour in an image file and then change the fillcolor of a rectangle to that predominant colour. I want to do that by getting the RGB value of each pixel, adding them up and then dividing them by the total number of pixels in the picture. This is the code that I wrote to do that.
[Code]...
I am a beginner programmer so this is basically the second time I fired up VS (not much experience). I searched the internet for the last hour but found nothing that might help me. I made sure every value is positive and changed all numerical variables from integer to decimal and I still get the error.I have absolutely no idea why this doesnt work but if I remove the "for" loop then the line written in bold works just fine.BTW this is my first post so scuze any mystakes I probably made.
I'm trying to calculate the average hours worked from a set of data imported from a text file using streamreader. My problem is counting the number of entries and the total hours worked imported from a text file within a loop[.
[Code]...
So, I have a textbox with the following text.
Code:
TITLE"Hello there"
blah blah blah etc...
I want my program to find the TITLE text, and then put the text in the double quotations in a variable.
Im trying to programme a form to calculate rainfall total,average,maximum, and minimum.how do I create the input box that opens to input the info I cant seem to find it in the tool box. Am i Missing something, and how do I set a array to calculate?
View 2 RepliesI have tried to run below macro in excel 2010, but the error pop up and after press debug button, the line "expected_loss = application.worksheetfunction.average(final_loss)" was highlighted. May I know how to solve this problem?
Sub test ()
'Aim: to store data in array and calculate the average of the data in the array
Dim final_loss(1 to 70000) as double
[code].....
I am trying to figure out how to calculate the number of years it takes to double a user defined number. I have tried to take the number entered and multiply it by twelev and divide by two.
View 2 Repliesi am trying to get the average of an array of numbers. There could be up to 999 indexes (I picked a large array because of the the numbers of entries the array could have). As you can see I have managed to get the program to calculate the Sum of the in the array, but I am struggling with getting the average.Say, for example, I enter three sets of 90's, I get 3. How do I get an average?(BTW I have programmed it so the numbers go into an List Box, so this is why you see no code to make up the array or to where the array is printing the values).
Dim Sum As Integer
Dim SumCount As Integer
Dim AverageCount As Integer
[code].....
In the discussion in this thread: [URL] it was reveiled to me that vb.net, using double, could only calculate values up to 18 digits after decimal.... so I started thinking and came up with this class
Public Class LargeNumber
Private pNumber As String
Public Sub New()
[CODE].............
I want to split the string into a series of doubles.... and than combine them into a large number.... The size of each double component should be 18 digits on a 32 bit computer... so that I will have room to add the last carrier...
i'm working on something to get the average color from an image and the code i have puts all the rgb values into a byte array, so the values are being stored as (r,g,b,r,g,b,r,g,b,r,g,b,r,g,b,etc). how would i loop through each r value to add them to another array to then be able to calculate the average (and so forth for g and b as well).
View 4 Repliestrying to give an average of an array in VB MVS2008. I tried using a sample code online but the averages it gives me are completely off. If I enter three ages (20) it gives me an average of 0.6, instead of 20. Here's the code:
Spoiler
Public Class Form1
Dim Names(100) As String
Dim Ages(100) As Integer
[code]....
I'm still learning visual basic and I'm kind of stuck. I'm getting the wrong output when I test my data. I'm trying to sum array data and get an average from it. When I print out the average it's way above what it should be. When I enter these numbers 32500, 23000, 38210 I should get an average of 31236.67 but the number I get as the average is 46855.
[Code]...
My assignment was to compute design a {Loop, Array } that user inputs grades and calculates the average, Im stuck on the part of computing avg but i
Module Module1
Sub Main()
'Declare Array called Grades with 4 Elements
[code].....
i created an array of 100 cells, and the user inputs the value into them now i have to find the average of the array but not all of the cells are used how do i go to the last value, instead of the last cell? [code]
View 1 Replies