Over 1 million tech questions and answers.

help with vba macro average

Q: help with vba macro average

hi i am new to programming and try to make an average function with several variables, but got stuck
can someone help to solve. see attach file

RELEVANCY SCORE 200
Preferred Solution: help with vba macro average

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: help with vba macro average

some additional info for request.
20 colums B, D, F etc.from each column i want average of 2, 3,...., 20 last cells
averages of first column on another worksheet(averages) in E6:W6
averages of second column in E7:W7 etc.

Read other 1 answers
RELEVANCY SCORE 63.6

I have a macro that pulls meteorological data from various sensor data files (txt CSV files) on a network and puts them in a spreadsheet when the button is pushed. The macro reads the data files until the last/newest string is read, as a loop function. For the wind data I would like to take the average of say the last 10 measurements instead of the very last one. Can anyone help me with the best way to do this? Can I do it with a similar loop function?

Here is a sample string of the wind data file:
The values I want to average is the first number just after the $DERIV which is the wind direction

09/08/2011,00:00:05.682,$DERIV,40.47,36.98,38.7990604473582,45.4833040628672,60,
09/08/2011,00:01:05.682,$DERIV,40.89,38.42,38.3839658290715,44.3314055621409,59,
09/08/2011,00:02:05.682,$DERIV,35.3,39.38,34.487867337798,48.7034351812146,60,

Here is the Macro so far. I haven't written in anything for the wind data yet but you can see the functions for the other data:

Const NavDirectory = "GPS_Data\"
Const DriveSpec = "U:\"
Const GPGGAFileSpec = "*GP150-NMEA-GPGGA*"
Const MetDirectory = "Meteorlogic_Data\"
Const SAMOSDirectory = "SAMOS\"
Const SSTFileSpec = "*SAMOS-SST-DA_*"
Const YOUNGFileSpec = "*YOUNG-NMEA-WIXDR_*"
Const SeparatorCharacter = ","
Public Function GetLastString(FileName As String) As String
Dim FileNum As Integer, tLine As String
FileNum = FreeFile ' next file number
On Error... Read more

A:Macro Data Average

Hi Benito,

You should use the code parameters to delimit your code, this will help when copying and pasting
Code:


code here


end of code

You mark this at the beginning using [ code ] (no spacing between the [ ] )
The end mark is [/ code ] again without the spacing

I suggest that in the same loop you add the values of the wind and devide by that number of measurements which will return the average.
 

Read other 1 answers
RELEVANCY SCORE 63.6

Hi, I'm using Excel 2003, and I've built a macro to do various things, one of them to add subtotals based on the change in data. I simply used the function under Data>subtotals to do the summing but I need one column to sum and then divide by the column next to it in order to give a weighted average.

I do not know VBA, but is there an easy way to do this?

Thanks!
 

A:Macro Weighted Average

Hi there,

Do you have a sample of your data? And can you please post your code? If the data is not your data, please make sure the structure is equivalent. But yes, to answer your question, there is a way to do it, and it should be fairly easy.
 

Read other 3 answers
RELEVANCY SCORE 59.6

I am currently trying to build a spreadsheet for calculating an individuals production level based on a few criteria:
Must have worked 18 or more hours for the week, anything under 18 hours can't count toward production

Must be the most recent 4 weeks included in the average (anything in the previous weeks must be ignored)

I will be linking a work in progress workbook with some sample numbers, but here are the basics:
I am attempting to calculate a weighted average for both production (hours for the week vs.% of Standard achieved) level and accuracy (units vs accuracy) in I4 and I5 respectively. Production can only be considered valid if an associate reaches 18 hours in that job function. Each week I have to insert a new set of data identical to the previous week, but with updated values. I don't mind manually updating the very simple formula that would be required to find this value, however this is something that I need to share with several non-excel savvy people in my area.

I am hoping that there is a macro out there that would auto-magically appropriately update each of the averages whenever a new week is added to the spreadsheet.

I am a novice when it comes to macros, but I would appreciate any help. Thanks
 

Read other answers
RELEVANCY SCORE 50.4

I have a Inspirion 15 5558,with i7, 8GB ram,1TB HDD,My average To reach the login screen was around 45 secs.
I was facing LCD issues, the technician came over and checked the LCD and pasted some stickers on i it so that it can be repaired later.
I found that its taking more than 4 minutes to reach the login screen.
When i contacted the technician he said it was an OS problem and that i should downgrade to 8 or 8.1
so if everyone can comment about their boot time it would be helpful in determining the problem.

Thank you 

A:What is the average boot time/average time to reach the login screen of Inspirion 15 5558 Win 10?

" I found that its taking more than 4 minutes to reach the login screen ".

I like to suggest you launch "Startup Repair" in Advanced Startup:
A) Type settings in the (Cortana) search bar, Update & Security, and then Recovery
B) Click Advanced Startup, and then " Restart Now "
C) Troubleshoot, Advanced Options, and then Startup Repairs

I also like to suggest you check Startup in Task Manager.Please disable some of the programs that you don't want running in your startup.
A) Type Task Manager
B) Click Startup

Read other 3 answers
RELEVANCY SCORE 39.6

I am using the MSN Stock Quote addin with MS Excel 2003. Prior knowledge of this should not be necessary, but I just thought I'd provide full context to my issue. I wrote a macro that essentially records daily stock prices. Because I don't want to store old quotes into perpetuity, i need to ensure that the update quotes button has been hit. I use sendkey() to accomplish this, and then the macro copies the quotes and pastes them elsewhere. My main goal is to have the task scheduler open this file daily so i dont ever have to think about this again, and i'm so close. Essentially my problem is that it takes a few seconds after the update button is hit for the add-in to fetch the new prices from the internet, and this process appears to be delayed until the macro is finished. This is a problem because the macro ends up recording un-updated quotes. I have tried the Application.Wait procedure, and I've tried time consuming loops, do while loops, etc. All of these approaches result in the same thing: Can someone please help me with this? I'm too lazy to hand update this spreadsheet every trading day for the rest of my life (or until i quit). Thank you in advance!
 

A:Excel Macro - Allow cells to update query before macro completes

Can't you just put the update macro code in a module of it's own and call it from the main macro?

Regards,
Rollin
 

Read other 1 answers
RELEVANCY SCORE 39.2

How do you keep a macro running until you reach the end of a page? Currently I just hold down the control or Alt keys. I have long documents so holding down the Alt + whatever key is not always practical.

Here is a sample macro. How do I make the macro run until the macro reaches (in this case) the top of the page?

I think the "do until" feature is used in the code but I do not know the syntax for "do until".

Code:
Sub DelimitBoldSentenceOnRightWithATab()
Selection.Find.ClearFormatting
Selection.Find.Font.Bold = True
With Selection.Find
.Text = "*"
.Replacement.Text = ""
.Forward = False
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = True
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
Selection.TypeText Text:=vbTab & vbTab
Selection.MoveUp Unit:=wdParagraph, Count:=1, Extend:=wdExtend
Selection.MoveLeft Unit:=wdCharacter, Count:=1
Selection.TypeText Text:=vbTab & vbTab
Selection.MoveLeft Unit:=wdCharacter, Count:=3
Selection.Find.ClearFormatting

End Sub

Thank you in advance for your replies.
 

A:Word Macro: How to keep macro running until end of page is reached

You can evaluate the current page number using the following property:

Selection.Information(wdActiveEndPageNumber)

Just use a loop and have it execute while Selection.Information(wdActiveEndPageNumber) = 1

Can you post your sample document?
Regards,
Rollin
 

Read other 2 answers
RELEVANCY SCORE 39.2

Hi Im an amatuer photographer and i'm looking to dupe my heap of old 35mm slides using my canon 180mm 3.5f macro lens... I'm wondering if anyone has tried doing so with a macro lens similar ..
I use a 40d digital canon camera. The shortest focusing distance for the lens is just under half a metre.
I also have a 1.4 extender that gives extra magnification but dont think i would need it.
I imaging the idea is to photograph down a piece of pipe (ie fit it to the lens somehow) and have the 35mm slide illuminated from the rear using some sort of slide holder and external flash behind....
The macro lens will do 1to1 life size is made to shoot a fairly flat field and the camera is capable of automatic exposure and bracketing... does that sound like a lot of rot ? or is it a proposition... I havnt seen a commercially made gadget to use on a dslr for this purpose. I copuld buy a dedicated dupe machine but im wondering if the optics and software are any better than the camera i've got?
Maybe someone is already doing it! I'm just new to this forum so a bit inexperienced in this process.... Regards to all
jim t
 

A:anyone tried duplicating 35mm slide via macro a macro lens

Read other 12 answers
RELEVANCY SCORE 38.4

I have set up a macro to print multiple reports. Using the following:
OpenReport
PrintOut
OpenReport
PrintOut etc.

I get a Print Macro Definition message between printing each report that I cannot make go away.

Please, make it go away!!!
 

Read other answers
RELEVANCY SCORE 38.4

hello everyone,

i would like to ask for help,

i already made a macro for mac excel 2011, the macro is only move and copy an active worksheet to the last position of sheets.

however, i found something wierd, suddenly there is code inside the new sheet module. the code is

'True
End

this code makes me un able to run macro anymore, but after i remove that code, i can run again the macro.

could any one help me regarding this problem?

Thankss...

the code i was using as follow

sub test123()

activesheet.copy after:= sheets(sheets.count)

End Sub
 

A:un able run macro in 2011 after adding new sheet by macro

Are you sure thes isn't any code in the source sheet?
 

Read other 3 answers
RELEVANCY SCORE 38.4

Hello!

I've been tasked to compile in a sheet the monthly ending balances (from July to Dec) of customer receivables for 493 CUSTOMERS. That's a lot! I already started, but I know continuing until the end is crazy and even impossible. So please help?

Below is a picture of the first sheet containing the ledger data of the 493 customers dated July to December. I just blocked the center and changed the customer names in an attempt to maintain confidentiality.

As an example, for Customer 1, I need the July, Aug, Sept, Oct, Nov, and Dec ending BALANCES (last column) of the receivables.

(I ALSO ATTACHED FILES OF THE FF 2 PHOTOS WHICH I UPLOADED IN FLICKR JUST IN CASE)

For july 31, since the first entry is already 08.15 or August 15, this implies that the July balance must be 0 which I have to input into the July 31 column in the second sheet as shown in the second picture.

For Customer 1 August 31 2012, the closest date to August 31/8.31 entry indicates a balance of 0 so this must be the August 31 balance.

For customer 1 Sept 31 2012 to November 2012, no entries are inputted for these months (9-11) so the August 31 balance mustn't have changed and is the standing balance as of November 31.

For Customer 1 December 31 2012, the outstanding balance is 0.

Oh, as an added note, just in case, debit adds to the balance and credit deducts from it.

I've had to manually mine the ending balances for 90+ customers so far. HUHUHU. I just know macros and YOU wil... Read more

A:Macro Help: Macro for Copying Certain Values Using Certain Criteria

It will be easier if you make sheet1 like a database table.
That is
Column A is all customer name with no blank rows.
Column B is the invoice date
Debit and Credit can be in 2 col or 1 col.

Try not to "beautify" your source data with empty rows and columns, it makes summarisation difficult.

When all is done, you may use sumif to sum all values before a particular date.
 

Read other 1 answers
RELEVANCY SCORE 37.6

Want to bring the Avg Amount, using IF Formula for the below calculations.
This Sheet 2
ColumnA Column B
Grade Group
Avg Amount
A&B
This Sheet 2
C&D

E&F

G&H

I&J

Total


The below data is on Sheet 3 from where the data needs to be taken for the above function
Employee Code
Employee Name
Grade
Amt
0020
Tom
B
24970
0024
Dick
I
24970
0030
Heera
B
24970
3933
Hari
I
10822
3935
P C
C
10822
3936
Vivek
J
10822
3937
Keni
G
10822
0115
atil
D
24970
3939
Swam
J
10822
0166
Samir
A
24970
3940
Taran
H
10822
3941
Sathya
G
10822
3942
Seem
A
10822
0236
Santos
G
24970​

Can u please help me with the Average if function.
 

A:Average IF

Read other 7 answers
RELEVANCY SCORE 37.6
Q: average

I am using access 2000 and have a query with the length of stay for 14 clients..What is the best and Easiest way to calculate the average
 

RELEVANCY SCORE 37.6

Got the desktop working recently, but I'm a tad concerned, the CPU at idle sits

in the 29-32C range and goes up to about 40C when I'm playing Microsoft Train

Simulator with [email protected] and other apps in the background. The CPU is at stock

speeds and Rambo says his maxes at 45C and his is at 3.03GHz.

Do I need a case fan to help get the air circulating in the tower box?
__________________
Free Offers Stock Market Charts
 

A:Average or hot?

Read other 6 answers
RELEVANCY SCORE 37.6

In my sheet I am using conditional formating to return 4-color traffic lights (using number 0-3). At the bottom of each colum I want the average of all number 1-3, excluding any 0s. I am using the formula =AVERAGEIFS(I3:I8,I3:I8,"<=3",I3:I8,">=1").

This is providing the correct answer unless it is a column of all 0s. How can I have the current formula I am using but also if the answer is #DIV/0! for it to return a zero instead of the error message?

An example of what I am doing is attached. Thanks for your help.
 

A:Average If and #DIV/0!

Read other 6 answers
RELEVANCY SCORE 37.6

I'm trying to make a program to calculate the average of grades, can anyone please explain what I'm doing wrong?

#include <iostream>
using namespace std;
int main(int argc, char* argv[])
{
int x,y;
int *p;
int total=0;
int average= total / x;

cout << "Please insert the number of scores "<<endl;
cin >> x;
p= new int[x];
for (y=0; y<x; y++)
{
cout << "Please enter a score: "<<endl;
cin >> p[y];
}
cout << "The scores are: ";
for (y=0; y<x; y++)
cout << p[y] << ", ";
cout<<"The average is: ";
for (int y=0; y<x; y++)
{
total += p[y];
}
delete[] p;
system("pause");
return 0;
}
 

A:c++ average help

Read other 6 answers
RELEVANCY SCORE 37.2

Is 89C for a NVIDIA GeForce 6800GT a high temperature?
 

A:Average Temp for my GPU?

Read other 6 answers
RELEVANCY SCORE 37.2

Hi all I am using Excel and i am trying to work out how to do the following:
I am doing a Excell excersize for college (to be handed in when we return) and I have to use the 'PMT' function to calculate the monthly repayments of a loan in the spreadsheet - How is this done. MS Online does'nt seem to be very helpful :S

with my calculations () It has came up with -132 per month as payment which is obviously not right can anyone advise on the formula I shound be entering the spreadsheet states:

Loan amount 10,000
No. of Years 10
Annual interest rate 10%
Monthly repament = ?

The other problem with another spreadsheet i am having is I don't know how to get the average of something AND round it to the nearest whole number can anyone advise on how this would be done ?

Thanks
 

A:Help with excel PMT and Average

Read other 13 answers
RELEVANCY SCORE 37.2

Dear HP Computer On November 3, 2016 morning, I sent my HP desktop computer (Windows10 and MS Office installed) to HP Service Center Jakarta.  In front of the HP service personnel, I backed up the data from hard disk as it was the only suggestion given.  The computer was in working condition when HP service personnel took it over. On November 7, HP service officer called and said the computer had no problem, and he just needed to fix some files.  On November 8, I picked up the computer.  At home I found out that the system was "downgraded" to Windows8 and MSOffice was "not properly"installed. As this was a paid service, I think this service was below average of typical services provided by HP. cw  

Read other answers
RELEVANCY SCORE 37.2

My desk top is approx 4 years old , and things are starting to go !

Google Chrome gives me an error and freezes up , Everything else seems to work, so I switched to Yahoo..
IS THIS NORMAL ????

A:Average Life.

No this is not normal, but many people "refresh" their installation after some time (years).
Can you please fill in your System Specs?

Read other 6 answers
RELEVANCY SCORE 37.2

Ok here is my next problem. sorry to be such a bother.

Please look at the sample, the question will be more clear

Ok lets say I have a list of Cities.

Chicago
Des Moines
St. Louis
Indianapolis
Kansas City
Milwaukee
Minneapolis
Philadelphia

Is there a way I can get an average of work times by city without having to break them up and do them individually?
The sample is just a VERY small portion of the worksheet.
 

A:Solved: Getting an average...

Read other 11 answers
RELEVANCY SCORE 37.2

Hi all! Would you all please tell me what is the temperature range that your P50 or P70 typically operates at?   It would also be great if you could measure it under average office use, internet browsing, plus maybe picture/video editing or low-to-mid-level gaming (if you do those sorts of things).  Also, to circumvent potential confusion, please denote what machine you have and in what scale you are getting these temp readings.




-----------IBM T40: XP PRO SP3, 14.1" 4:3 display, 512MB DDR RAM, 40GB HDD, ThinkLight, DVD.Lenovo Ideacentre H215: AMD Athlon II X2 215, 500GB HDD, 4GB DDR3 RAM, 64-bit Win7, AMD 760G.

Read other answers
RELEVANCY SCORE 37.2

Hi:
can anyone figure out why the sum and average isn't displaying based on what the user enters? it runs and i get values of 0 for each sum and average...any help by MIDNIGHT WOULD BE GREAT!

Code:

#include<iostream.h>

int main()
{
int y, i;
double g, m=0, a;
cout << "Please enter number of values to be processed: ";
cin >> y;//receiving number of values
cout << "Please enter the " << y << " values:\n"; //asking for those values
a = m/y;
for(i = 1; i <= y; i++)
{

cin >> g;
g += m;
}

cout << "Sum: " << m << "\n"; cout << "Average: " << a << "\n";
cout << "Thank you come again!";
return 0;
}
 

A:C++ Sum & Average not working

Here ya go.

BTW, I suggest using var names that
give you an idea of what you're doing,
such as "total", "numentries", etc.

int main()
{
int y, i;
double g, m=0, a;
cout << "Please enter number of values to be processed: ";
cin >> y;//receiving number of values
cout << "Please enter the " << y << " values:\n"; //asking for those values
for(i = 1; i <= y; i++)
{
cin >> g;
m += g; // Add entry (g) to total (m).
}
a = m/y; // divide m (total) by y (number of entries)
cout << "Sum: " << m << "\n"; cout << "Average: " << a << "\n";
cout << "Thank you come again!";
return 0;
}
Hope I'm not doing somebody's homework here...
 

Read other 1 answers
RELEVANCY SCORE 37.2

Hello all!

Some of you may know me. Like my software and WinSxS (I love the way WinSxS all fits together!) but am utterly clueless about the hardware. Please forgive me this question!

I have a DESKTOP PC which is NOT overclocked in any way. It is reasonably powerful (see specs) and is a Dell. However, it is used to the extremes of its ability - regularly.

I would just like to ask you what the temperatures you would consider good, warm, and hot for both the GPU and CPU. I know the GPU can get quite hot, but I would please like to know how hot, so that I can learn.

I have a feeling that mine are quite hot. Most of the time I get:

CPU: 52 degrees Centigrade (C)
GPU: 128 C

These seem awfully hot. Putting my hand on the GPU plastic casing after use makes me think that these are not anomalous!

Thanks so much in advance!

Richard

EDIT: All of the fans have been confirmed as working, and it has good airflow all around, and always has had.

A:At what temperature does an average CPU and GPU become too hot?

Hello Richard, I am not really knowledgeable in this area & can only reflect on my own research so that i can monitor my own temps which basically indicates 70 degrees C and below in both cases as being comfortable temps.

In posts i have read concern is usually expressed in 80c+, your CPU looks fine mine runs at 50-65 & max 72c under heavy load. I use Core temp to monitor which also has overheat protection

http://www.alcpu.com/CoreTemp/

The tjmax is the CPU manufacturers max temp (assume critical) & safe temps to be 15c-20c below this.

As far as your GPU it looks extremely hot but i do not have a solution for you other than cleaning & extra cooling which i am sure you are already aware of. (my desktop has settings in the BIOS for the fan)

Here are my temps which are for a laptop;

Read other 23 answers
RELEVANCY SCORE 37.2

What is the average life of a cd drive
 

A:Average life of cd rom

Read other 7 answers
RELEVANCY SCORE 37.2

I did a search and found 2 similar named threads, but neither seemed to pretain, so, I'm starting a new thread.

I'm a computer consultant, but I've run into an interesting situation. I have a WinXP Pro system 3.4ghz LGA processor 1 gig of DDR400 ram, 2 100+ gig HDs, a CD Burner, and a DVD/CD Reader, Nvidia GeForce 5700LE (256) video, SP2, and all latest updates installed.

Many programs installed. I've got Norton AV Corporate 8, AVG Free 7.0.323, Spybot 1.4, Adaware 1.06r1, Spyware Blaster 3.4, with all the lastest updates. Adaware found 7 tracking cookies, Spybot says I'm clean, Blaster is updated with no errors/problems. AVG and Norton run daily and show no virii.

What is occuring is when I leave my system sit with any program running either in the background or foreground, for 20 minutes or more, the system will bog down. When I check the Task Manager, it shows Explorer.exe floating between 48-50%, with memory jumping around. 160,000 - 280,000K, thought it was climbing but watched it and it keeps fluctuating. System.exe is showing 30-40%. It doesn't matter what program I may leave running, from WinMX to MS Word 2003.

The only way to clear it is to log out. I don't have to reboot, just log out of the shell. Logging back in and the system runs great. Now, if I have say WinMX going, typing a report in Word, have IE going doing a search... moving around the system, active, the system seems to run fine, I don't notice any slow-down, but if I leav... Read more

A:Explorer.exe using on average 50% CPU

Think I would try an online virus scan to make sure Norton and AVG have not missed something. I would also try Mirosoft Anti Spyware.

There are indexing programs that run to index the hard drive when it thinks the system is idle. Microsoft Office comes with find fast. Some of the desktop search programs use this also. Check msconfig for these programs and uncheck them.

Read other 9 answers
RELEVANCY SCORE 37.2

Well... I recently notice some lag on my computer and went over to Speedtest.com to check my speed on the computer. With the results calculated, It said that I'm below the average ISP Provider speed and from before tests i have.

My Average Download Speed Before: 17.64 mlbs
ISP Average Download Speed: 7.34 mlbs
My current Average Download Speed:4.08mlbs

My Average Upload Speed Before: 0.48 mlbs
ISP Average Upload Speed: 0.54mlbs
My current Average Upload Speed: 0.41mlbs
-
With these results tests a couple of times it seems like my computer is need some tune up. Help?
-
OS: Windows 7
*Don't suggest buying a new computer because I bought this computer this year
-
Please Reply ASAP, I'm experiencing major slowness and have work to do on the computer, I will check daily if you havn't post anything yet but if you did I will check this thread every minute.
Thanks
-Yamato
 

A:Speedtest Below Average?

Read other 7 answers
RELEVANCY SCORE 37.2

Hello all!

Some of you may know me. Like my software and WinSxS (I love the way WinSxS all fits together!) but am utterly clueless about the hardware. Please forgive me this question!

I have a DESKTOP PC which is NOT overclocked in any way. It is reasonably powerful (see specs) and is a Dell. However, it is used to the extremes of its ability - regularly.

I would just like to ask you what the temperatures you would consider good, warm, and hot for both the GPU and CPU. I know the GPU can get quite hot, but I would please like to know how hot, so that I can learn.

I have a feeling that mine are quite hot. Most of the time I get:

CPU: 52 degrees Centigrade (C)
GPU: 128 C

These seem awfully hot. Putting my hand on the GPU plastic casing after use makes me think that these are not anomalous!

Thanks so much in advance!

Richard

EDIT: All of the fans have been confirmed as working, and it has good airflow all around, and always has had.

A:At what temperature does an average CPU and GPU become too hot?

Hello Richard, I am not really knowledgeable in this area & can only reflect on my own research so that i can monitor my own temps which basically indicates 70 degrees C and below in both cases as being comfortable temps.

In posts i have read concern is usually expressed in 80c+, your CPU looks fine mine runs at 50-65 & max 72c under heavy load. I use Core temp to monitor which also has overheat protection

http://www.alcpu.com/CoreTemp/

The tjmax is the CPU manufacturers max temp (assume critical) & safe temps to be 15c-20c below this.

As far as your GPU it looks extremely hot but i do not have a solution for you other than cleaning & extra cooling which i am sure you are already aware of. (my desktop has settings in the BIOS for the fan)

Here are my temps which are for a laptop;

Read other 23 answers
RELEVANCY SCORE 37.2

I am using 3 column's let's say A B and C using A and B by inputting daily numbers and the total in C by using formula =A1+B1 all the way down to 30 (monthly totals). What I want is the average on a running average from the C column. I have used the =AVERAGE(C1:C30) but all I get is the divx error.
 

A:Average's in excel

Read other 16 answers
RELEVANCY SCORE 37.2

Just recently moved to a new apartment and had to ditch my dsl for cable. I got the highest service available which was 1536kb/512kb. Now when I do the bandwidth tests on websites I can only get anywhere between 150-200kbps. I had a tech com over here and hook it up correctly, or so it seemed, because it was going very slow to start with. He showed me it was working by downloading a 100mb file and the transfer rate was hitting from 150-250 KB. Just wondering why it is that the internet seems soooo utterly slow but most of the downloads are realitively fast. Maybe I am misunderstanding some term or something but I know this cable line should be higher on the BW tests than 150-200 kbps! I have tried 8 seperate tests to check and all were about the same.

Thanks in advance,
Jim
 

A:Why is my speed so below average?

Read other 14 answers
RELEVANCY SCORE 37.2

i have a dell dimension 3000 and i dont know what an average temp is for pc's but its running around 33C (91F) is that good or bad?

i have one fan blowing out with my side panel off and a little 4 inch desk fan i got from walmart blowing in on the side. my pc room stays around 72F or so no dust either i blow my pc out every couple of weeks
 

A:average temp for a pc?

What temp is that case or CPU? If case then what's the CPU temp? Your CPU temp is fine under 65C while under load (gaming, someother heavy processing workout, i.e Prime95). At idle it should be around 30-35C with air cooling and standard room temp. 65C is getting hot and I wouldn't want mine to get any hotter then that, in fact that's the upper safe limit. You really want it no hotter then mid 50's. (under load)
 

Read other 15 answers
RELEVANCY SCORE 37.2

Sup guys i've recently invested in a desktop PC for my son for him to do some light gaming on.

The specs are:

Pentium D [email protected]
2GB DDR2 @ 667MHz
Nvidia GT220 1GB DDR3
160GB 7200RPM

He'll be playing things like World Of Warcraft, Garrys Mod etc, nothing too straining... Will this computer run those games fine?

Thanks
 

A:Average gaming rig?

Well first I want to ask, how much did you pay for it? Passed that I'll say he should be able to play on low to medium settings with okay frame rates.
 

Read other 5 answers
RELEVANCY SCORE 37.2

Hello,
Whats the best PSU to get? I had a 300W one and changed last week for a 450 Low Noise PSU. I know I wont need 450W and it will probubly do me no differernce but is it worth having that extra bit more? I was going to get the 600W one but it was faulty, so I had to take it back and get the 450W one. I think 300W is plenty, What you guys think?
 

A:Average PSU Power

It depends on your system specs. Can you give us your full system specs?

You can check THIS THREAD to help you.
 

Read other 9 answers
RELEVANCY SCORE 37.2

what is the average cpu temp. without getting it too hot when overclocking?
 

A:Average cpu temp.

Way cool!

Check out this thread and this forum
Read Before Asking "Is This Too Hot?"
Should help you find info.... :hotbounce
 

Read other 1 answers
RELEVANCY SCORE 37.2

i'm getting an average of 57FPS when i'm playing Oblivion but still have freezes, each freeze last for about 1 sec or less but it happen frequently and it's so annoying, do u think it's a compatibility issue...
thanx....
 

A:Average of 57 FPS but still a problem

OneZ said:



i'm getting an average of 57FPS when i'm playing Oblivion but still have freezes, each freeze last for about 1 sec or less but it happen frequently and it's so annoying, do u think it's a compatibility issue...
thanx....Click to expand...

You are running a very graphic intense game, remember. How often does this happen? What are your system specs?
 

Read other 7 answers
RELEVANCY SCORE 37.2

Hello all,
I have an Asus motherboard P5Ld2 with Intel socket 775 3.0 hypertreading,3 Gb of ram, 2 Sata hard drive, Asus EN6600 256Mb videocard.standard intel cpu fan with 3 case fan.
My temperature for the board is average 38 degrees C and for my cpu between 50 degrees to 70 degrees.Is this normal?
Lately i noticed that my computer was extremely slow at times.Should i buy a better cpu fan?
If so, any suggestion?
Thank you for answering.
 

A:average cpu temperature

First off, what Intel CPU do you have (sorry, I can't tell what cpu it takes from looking at the model # like some members :unch: )? In some cases this is normal, and in some this isn't. You board temp is fine overall, I just wonder about the cpu.
 

Read other 9 answers
RELEVANCY SCORE 37.2

Hi all I was just wondering what the safe operating temp. on a video card under load with the higher end games and video cards. thanks!
 

A:Average heat on a GPU

That depends on the GPU and the cooling methods used.

If you are looking for comparison figures, it would be helpful if you provided us with the GPU specifications in your machine.
 

Read other 4 answers
RELEVANCY SCORE 37.2

hi i just built my computer it has intel pentium 4 3.4Ghz and intel motherboard and Geforce 6600 graphics card. 1GB ram. now im using a Intel(R) Desktop Utilities. and is telling me that my cpu is around 75C and i dont thing thats normal. i am using the fan for the cpu that came with it which i dont recon is doing a good job. my case has a fan on the side and thats about it. i was thinking about this on ebay http://cgi.ebay.com.au/Copper-Heats...0096127374QQcategoryZ3673QQrdZ1QQcmdZViewItem do you recon that would cool it down alot. Because my pc is ment for gaming and if its runing 75C just using internet explorer then thats a problem to see what it runs on a game. so could you please tell me if that fan will be ok and mabe tell me what tempurature it would be if you could that would be great thank you very much.

or this one http://www.umart.com.au/newindex2.phtml?bid=4 and http://www.umart.com.au/newindex2.phtml?bid=4

thank you very much
 

A:please help new here CPU running 75c average

75c is way too hot to be near-idling at. Is this the first time you've built a computer? I'm betting you installed the HS/F wrong. You're going to need to take off your HS/F, reapply thermal paste, and install the HS/F correctly.
 

Read other 39 answers
RELEVANCY SCORE 37.2

I've been blowing through graphics cards about every 12 months. Even with my new system it's been the same. I do play a lot of graphic intensity games. Could that be the reason for their early demise? The latest casualty is my GTX 560.
 

A:The average life of a GPU

A GPU's lifespan is at least 3-5 years. Hell, if you take care of your components it will last as long as you need it to in most cases. The fact that your GPU's are dieing in a year is strange. If this has indeed happened to all of your GPU's it is safe to say that the operating conditions inside your PC may not be too good. Or, you may just be burning them out? Do you SUPER overclock them or something? What sort of operating temps do you usually get?
 

Read other 27 answers
RELEVANCY SCORE 36.8

What's your average time to copy a ~500mb file over your LAN from a server to a workstation?

I'm getting times between 1.5 and 2:00min which feel rather slow for a 100mbps connection.

Details: Windows 2003 server, XP sp2 worstations with 100mbps cards. 1000MB connection on the server via a 100/1000 dell switch.

3D0g
 

A:Average LAN transfer speed?

Read other 6 answers
RELEVANCY SCORE 36.8

Something is wrong with my registry. I can't start an EXE file. Sometimes it says that I may not have the appropriate permissions, but after using several different versions winXP_reg_fix.reg it now tries to get winzip to open it (doesn't work). I've also tried manually adding it as an application in the file type list of the windows explorer tools, even though there's no 'restore' button.
 

A:not your average EXE registry problem.

Read other 10 answers
RELEVANCY SCORE 36.8

Hi Everyone,

In Excel, if I have a worksheet for each week, what is the best way to keep a running year-to-date average of a value that is in each sheet?

More detail: Each day I am tracking the hours spent on work orders and total hours on the clock. At the end of the week I calculate a "documented hours" percentage. (sum of work order ours/sum of total hours). I want to compare this week with previous weeks and keep a running ytd percentage.

I appreciate any help you can provide!
 

A:Excel Average Across Worksheets

Read other 14 answers
RELEVANCY SCORE 36.8

The below code works fine on my web page. It pulls the data from my database and displays it perfectly. However, the AVG score shows many decimals. Is there a simple way to make this show only 2 decimals.
Note that my database does not have a AVG column. I believe this code creates it so I added that at the bottom.
Thanks, Mitch


$query=mysql_query("SELECT date, name, score, gamesplayed, highgame, sum(score ) as total, sum(score )/ gamesplayed as avg from bowling group by no ORDER BY date ASC")or die(mysql_error());
while($row=mysql_fetch_array($query)){
$id=$row['no'];
?>

<tr>
<td align="center"><?php echo substr($row['date'] , 0, 5), "</td>";?>
<td align="center"><?php echo $row['name'] ?></td>
<td align="center"><?php echo $row['score'] ?></td>
<td align="center"><?php echo $row['gamesplayed'] ?></td>
<td align="center"><?php echo $row['highgame'] ?></td>
<td align="center"><?php echo $row['avg'] ?></td>
 

Read other answers
RELEVANCY SCORE 36.8

Privacy guardian just bleached a portion of my hard drive, apparently following the installation of windows defender. It's only because I use norton goback that I was able to restore the system and undo the changes. I currently have ccleaner for privacy and to clean up unnecessary files, and adaware and spypot S+D for spyware/adware removal. Also have norton antivirus as my antivirus program and spyware blaster to guard against spyware.

What are the most highly recommended free programs for maintaining security on my computer? Am particularly interested in a good privacy programme and a spyware removal programme that actually picks up stuff - adaware never does! Thanks
 

A:free security for the average joe

Read other 6 answers
RELEVANCY SCORE 36.8

Well, I've scheduled an appointment for the ISP to come out. But in the mean time, is there anything you guys reccomend to speed up my connection?
 

A:Cable running at 50% of average

Read other 6 answers
RELEVANCY SCORE 36.8

Im looking for a new graphics card for my old pc:

Athlon 2500+
1 gig of ram
Quadro FX 2000 (very old 128mb card)

Now i know its really old, but it seem to hold out plying alot of new games, the only thing that lets it down is the graphics card when i use system requirements lab.

So im looking for a cheap 256mb card with all the needed features, nothing special, just enough to run a few new games like Company of Heroes. Anyone got anything to recommend?

I had a look at these on play.com

http://www.play.com/PC/PCs/4-/33488...S-256MB-DDR2-PCI-E-Graphics-Card/Product.html

http://www.play.com/PC/PCs/-/668/87...P-Graphics-Card/Product.html?searchtype=genre

http://www.play.com/PC/PCs/-/668/87...6-Graphics-Card/Product.html?searchtype=genre

Which of these is the best? ^

Something around that price, a VERY cheap card i know, prehaps about 40-50 if these are useless.

What you think?
 

A:Looking for a new average graphics card (UK)

well the nvidia 6600 is a good card although on play it 65...of your choice the 7300 is probably the best
 

Read other 1 answers