Over 1 million tech questions and answers.

Explorer.exe using on average 50% CPU

Q: Explorer.exe using on average 50% CPU

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 leave it for a lenght of time, when I come back to it, its pushing 90%+ on the processor...

I don't have a screen saver, as I turn off the monitor when I leave the system. I've recently wiped out the system and re-installed it from scratch, I haven't even loaded all the programs I need and the system is still doing this.

I've tested the hardware, originally I found that my old 40 gig HD was showing bad sectors, so replaced it with a 160 gig drive, only to have the same problem. I thought maybe the memory, so bought a gig and replaced the original memory. That didn't fix it. Decided to replace the motherboard. Still doing it. I've got 5 other systems sitting here ranging from a 3.2ghz to a 1.1 duron, this is the only system doing this. I'm considering changing out the case and power supply... I mean, those are the only 2 things left.

Anyone have any other ideas? Are their any known situations like this? Its not that bad... Although I do log into a server and this takes a minute or 2, so the time lost in logging out and back in is starting to piss me off.

Thanks for your time.

RELEVANCY SCORE 200
Preferred Solution: Explorer.exe using on average 50% CPU

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: 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 53.2

First of all, I would just like to extend my utmost gratitude towards anyone who is able to help me. I am willing to answer any questions that people may have and am grateful enough to put forth the effort in replying promptly and quickly.

Basically my problem is as stated in the topic field. explorer.exe runs, on average, from 25,000k to 30,000k; sometimes exceeding well over that threshold. Would anyone be able to help me find myself in the right place in pin-pointing and hopefully solving this issue? Thanks again in advance.

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

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

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

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

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

What is the average life of a cd drive
 

A:Average life of cd rom

Read other 7 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

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

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

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

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

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

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

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

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

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

A:Average Temp for my GPU?

Read other 6 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

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

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

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

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

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

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

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

Chassis fan? Power fan? CPU fan?
 

A:Whats the average RPM of fans?

Read other 9 answers
RELEVANCY SCORE 36.8

Just was wondering what the average cpu temp is in game with a 3.0g p4.Mine is currently running between 40c-49c
 

A:average cpu temp in-game

I don't think it is anything to worry about at 49*C.

Hell my Ahtlon 3200+ hits 55.
 

Read other 1 answers
RELEVANCY SCORE 36.8

Hi,
Is the a way to have an Average [=average(...)] formula not include cells that have no value and are outside a parameter. For example: I have a column of numbers with some cells blank and some cells either too high or too low, that I don't want to include in the average.

15
16
15
14

16
14
23
15
14
2

I don't want the blank cell and the high cell(23) and the low cell (2) included in the average. The high and low numbers will be varaible

Mike
 

A:Solved: Average formula

Read other 12 answers
RELEVANCY SCORE 36.8

In excel I would like to calculate the value of Column A ($) / Column B(# of years) across the row, one result per column for each number of years.

Any suggestions would be greatly appreciated

Example:
7 $2,800 $400 $400 $400 $400 $400 $400 $400
5 $364 $73 $73 $73 $73 $73
3 $150 $50 $50 $50
2 $200 $100 $100
3 $250 $83 $83 $83
2 $210 $105 $105
2 $210 $105 $105
2 $200 $100 $100
2 $100 $50 $50
1 $140 $140
 

A:Solved: Calculate an average

The ideal way would probably be to use macros. However if you put this in every box that may hold the results (i.e. every box with a 400 in your first example, for the maximum number of columns you'll have years) it should work
Code:
=IF(COLUMN()-2<=A1,B1/A1,"")

 

Read other 2 answers
RELEVANCY SCORE 36.8

Hello,

I have a large database on excel (20 000 rows), and need to calculate an average which excludes some values. I tried to use the filter tool and the auto subtotals, but it is too tedious since I need a precise summary day by day for each genre and I have too many lines to do it by hand.

Here is the format of my data :
ASIN - Date - Rank - genre

ASIN contains a product identifier, Date the date when the data was taken, rank the value to be computed and genre is a classifier. I want to automatically compute the average rank of a given genre day by day. Any idea how I could do that?

Here is enclosed a sample data if you want (two days included, bear in mind that the number of product by day may change).
Thanks,
Ataraxiste
 

A:Difficult average on excel

Read other 16 answers
RELEVANCY SCORE 36.8

First, I wanted to say hello to the forum. I am new, and I'm looking forward to participating in here.
 
I have posted this in other forums in the past with no luck. I have also spent a fair amount of time changing up keywords while doing google searches, with no luck either.
 
What I'm looking for is really just a basic Moving Average program. I want a program where I can imput numbers on a daily basis, which will give me a running / moving average. IE: If I put ten numbers in, I'll get the average for all ten numbers. As I include additional numbers, the average should then change. I don't want to run Excel or anything like that, so I'm hoping there's something out there that I'm missing.
 
I'm looking for something that will give me the average times of my daily runs. I am aware that there are dozens of them out there for Smart Phones, but I need one for a Desktop.
 
Any help is VERY much appreciated, as I have looked and looked to no avail.
 
TIA
b1rd
 
 

A:Looking For A Moving Average Program

I did some Googling. I don't have any experience with this software and I don't know if this is what you were looking for. I am not sure if it calculates moving averages.
 
It supports up to Windows 8. Not sure about Windows 10. You need to have .Net Framework installed if you use XP. $35
 
http://www.runnersstudio.com/features.aspx 
 
 I could not find anything that will calculate a moving average other than a spreadsheet. There are free ones out there and setting up the formula is not difficult. 

Read other 3 answers
RELEVANCY SCORE 36.8

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

What is the average ADSL speed?
 

Read other answers
RELEVANCY SCORE 36.8

Hello, this might be a tough one but here is what i am trying to accomplish.

My goal is to show the price we bought item A, by month, over a long period of time. i want to show an accurate average price for each month and i figured weighted average would be an accurate way using qty bought and the price per unit. I have the data for qty bought and price per unit. I don't want to use the average because there is alot of outliers and it doesn't take into acccount how many we bought.

So my question, is there anyway to show weighted average per month, with a pivot table.
 

A:Weighted average in Pivot

you could set a custom formula in the pivot and
do a sum(price)/sum(qty)

http://www.mrexcel.com/archive/Pivot/10389.html
http://office.microsoft.com/en-us/e...ottable-or-pivotchart-report-HP005199482.aspx
http://www.mrexcel.com/archive/Pivot/index.html
 

Read other 1 answers
RELEVANCY SCORE 36.8

so pretty much I wanna know what temperatures should they be around. At least when I see it getting to some point I can clean it out. once it hits what ever temperatures would be dangerous.

Oh and also is it normal for the CPU randomly go form 1-4C to 30-32C?

A:What temperatures are average? What are the dangerous ones?

Hello, i can either move this to Internal hardware or I can delete this one anf keep th same one you have in General Chat.

http://www.bleepingcomputer.com/forums/topic447500.html/page__p__2642000#entry2642000

would you prefer?

Read other 1 answers
RELEVANCY SCORE 36.8

Ok so this is probably stupid easy... but I just don't use Excel to it's potential. I have a order history log and in A1-x1 I have month/day/year (mm/dd/yyyy) I want to know the average of days between orders.

ex
A1 is 10/04/2006
B1 is 10/10/2006 (6 days later)
C1 is 10/12/2006 (2 days later)
D1 is 10/17/2006 (5 days later)
etc

How do I find the average of elapsed days (6+2+5=13/3=4.3333)?

Happy Holidays!
 

A:Solved: Average between dates

Hi
Dates can be subtracted from each other, and the result is given in days.
I would use this approach:

Code:
B2=B1-A1
C2=C1-B1
.
.
X2=X1-W1
these are the elapsed days, and finally

Code:
Y2 = AVG ("B2:X2")
Is this what you need?
 

Read other 2 answers
RELEVANCY SCORE 36.8

Hey

I have Windows 7 x86 RC on an older HP dx6100 (Pentium 4 3.2Ghz).

The current problem is it ignores its sleep setting (Never) and puts itself to sleep all the time.

I've changed the profiles to High Performance, back to Balanced, changed the profile myself and saved all the settings, but it continues to sleep.

Anyone seen similar symptoms?

Cheers

A:Not your average sleep problem

Open an elevated command prompt. Copy and paste the following then hit enter:

powercfg -h off

Read other 3 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

I've heard that CD's have blown apart and was wondering just how fast is the thing turning..meaning, the CD drive?? On a average...that is.
 

A:Average CD drive speed is..??

Read other 9 answers