Replies

I think MS decision to not include DVD playback is strictly businse$$, IMHO. A lot of people will now pay the extra $$ for the Pro version just to get the convenience of DVD playback.

I haven’t used Win 8, have been reading about it just to stay informed. I am very happy with Win 7 Pro, so I will probably not be “upgrading” to Win 8 or Win 8 Pro. It seems MS comes out with good OS’s every other attempt. To get it right 2 times in a row will be a first IMHO.

There are negatives to Win 8. I do not use IE, well ONLY when MS FORCES me to do so (always on a MS web site), i.e. to get the download for XP Mode on my system I had to use Active X and Firefox wasn’t doing it correctly, I geuss. When I used IE it worked. MS is now integrating IE even more into the Windows RT, giving them an advantage. Just one reason I don’t care for IE and MS heavy handedness.

In which version of Excel have you tried this and gotten it to work? I get formula errors since 1:15 in a formula is the range of rows 1 thru 15, 2:19 is the range of rows 2 through 19 and so the formulas are not interpreted correctly as discussed in previous posts…

Steve

Excel 2003. It works with numbers, however, while playing around more with the time format, i.e 1:15, 2:19 etc, it seems the macro doesn’t like just minutes, 0:33 for example. Undoing the total, to clear it, set it to zero, is not easily done when using time format. It works for numbers well, just not for time, so in this case it probably is more trouble for the user than it’s worth.

It’s not really a formula but a macro that stores the cell contents in the comment and adds or subtracts whatever number is entered into that cell with what is in the comment.

It is possible to do add numbers up in one cell, a running total, which sounds like what you want to do. It is possible to add say, a cell with 1:15 in it, then while in that cell, type 2:19 and then type 1:03 and show 4:37 as the total. Is this what you want to do? However, without seeing what you are actually doing with the data in the cells over time, days, weeks, months….. I don’t know if this would be the best solution.

Tim

CD Burner XP will span multiple dvds. Instructions on how this is done click here. I have use CD Burner XP for years and am very please with it.

I have a similar mobo, Asus P4C-800E Deluxe. If memory severs me these were made at about the same time some bad capacitors came out. Check here. The bad caps are swollen, pushed outward, on top. These will be located very close to the CPU. I recently replaced some on a monitor I have and that fixed my monitor.

If you have more than one stick of memory, pull them out, leaving only one. This will help eliminate a bad stick of memory. Make sure the one left is seated. If it still doesn’t work try a different memory stick.
Try using a different PSU.
If the PC has been transported about, make sure the CPU is still seated in place.
I do think the mobo needs a HDD connected, there is an error listing for not having one connected.
Video card seated? CPU fan operating correctly? On an old system check that everything is clean, seated & fans working.

My manual says 4 beeps means “motherboard timer not operational”

I did have to replace the CMOS battery in mine, thing wouldn’t keep the correct time, LOL.

I used a floppy with Dr. Dos to boot and flash my bios.

Good Luck, hope this helps.

Tim

I disagree with the whole premise of the story. The industry is simply doing what all businesses do, deliver a product the consumer wants, in this case the fastest hardware possible. That will not hurt the desktop segment at all. If anything, the high price a very small segment is willing to pay for that extra bit of speed will eventually, faster than in any other industry I would be willing to guess, trickle down to mainstream desktop. Granted there are some components that probably will not, i.e. Extreme Editions of CPUs. I just don’t see how this hurts the desktop pc.

Now if the industry stopped making mainstream / entry desktop pcs to cater solely to the higher paying enthusiasts then you might have something. But, they still make mainstream and entry pcs and maybe just a bit cheaper, lower markup, because some enthusiasts are buying the higher end stuff, higher markup.

You can do a running total in one cell by using the comment section of that cell then do a conditional format to turn the cell red if it exceeds the quoted hours. If you want to “clear” the cell though you will have to either edit the comment or simply subtract the number that is in the cell i.e. cell = 32 then -32 will return zero. Right clicking and choosing “clear contents” will clear the cell but will not reset the comments to zero. A sample sheet with the macro is attached.

Have you tried something like this? Would this work?

Private Sub Worksheet_Change(ByVal Target As Range)

Dim icolor As Integer

If Not Intersect(Target, Range(“A1:A50”)) Is Nothing Then

Select Case Target
Case 100
icolor = 4
Case 95 To 99
icolor = 28
Case 90 To 94
icolor = 6
Case 1 To 89
icolor = 3
Case Else
‘Whatever
End Select

Target.Interior.ColorIndex = icolor

End If

End Sub

Try putting a ‘ , single quote, in front of the date in the formula bar. There seems to be some type of formatting at the beginning of the contents of the cells in column A that is allowing the other cells to format as General and keep the date as you want. The reason I say something is at the beginning, If I go to say, A1 and at the start of the date hit backspace, it will result in what you have in the purple shaded area.

After you put in the single quote you can format the as text and then eliminate the single quote if you want. Then you can format as General and it will keep the date as the other cells. Hope this helps.

Tim M.

This may help you. Wiki

I do have, and probably will still work, on old LS120 drive. Remember those? Now if I am ever in Canada again maybe I can drop it off to ya.

While I’m not doubting your statement regarding Dell designs ( you can only buy components from Dell ) I’m not sure what you mean by “non-standard ATX?”
If it’s non-standard, then it no longer is ATX.
Also not sure of the OP saying he put the system in a non Dell case. Did he reuse the PSU from the Dell or use the PSU in the replacement case?
I think we need more info from the OP.

Quite right, it isn’t ATX. Dell, until around early 2008, used a proprietary pin out on their power supplies and mother boards. While Dell’s parts looked ATX, they weren’t. Dell did this, in their opinion, because the specs were lacking. What really irked builders was it is possible to connect standard ATX psu to a Dell m/b. Dell never bothered to change the connection to something different. Unsuspecting builders were left with charred mother boards.

BobH said he put everything from a Dell case into a new ATX tower case to try and fix an overheating hard drive problem. So, he still is using a Dell psu and wants to replace it with a new one.

Beware! In the past Dell has used non-standard ATX designs. You may need an adapter to plug a standard ATX psu to a Dell motherboard. It is possible to plug a standard ATX psu into the non-standard Dell motherboard connector. Disastrous results will occur if that happens.

Anyone with advice and/or tales of woe on surge protection?

Get a good UPS with enough watts to handle your set-up. One other thing a UPS will do is provide enough power in a brown out, as well as handle spikes. I just went through 2 days without power and when it came back on I was glad to have a UPS on my computer in case of not enough juice or spikes. It also powered a lamp for several hours, long enough to get my generator going. Some people in my area went without power for 11 days. While running on a generator, I am comfortable running electronic devices as long as they are plugged into a UPS.

Is it really worth while investing big bucks or will the minimum investment do?

This you will have to answer yourself. What is your time, data, hardware worth? How much do you have invested in them? Photos, videos, music? Those things can be priceless. Will a good surge protector protect them? Maybe, but it will not provide power for proper shutdown of the computer.

For me, spending $120 on a 1250 watt UPS is money well spent to protect all that I have put into a computer system.

Update: I took out the 75g HD and replaced it with a WD 750g. Storage is rather cheap, so I just eliminated an older SATA I drive. Shrank the 750 to 120 and installed Windows 7 64 Home Premium on the 120g. Couldn’t be happier with Win 7!! Much faster in every way than Vista 64! The problem with the Viewsonic vx922 went away also! I am not usually an adopter of just released OS’s but am glad I did this time.

I am keeping Vista, until I am sure I no longer need the data on that drive. Just yesterday I had to boot vista to get an activation key from the registry.

Two things I have encountered as a “problem” or annoying is Win 7 HP doesn’t allow me to add the snap-in Local Users and Groups and I cannot disable the taskbar thumbnails (I really find the thumbnails annoying).

Would you care to post a snippet or capsule of the problem just in case it would be of some guidance for others?

The problem has to do with my Viewsonic VX922 monitor. At bootup it will not get a signal from the dvi 99% of the time. If I plug in a dvi adapter, adapter only, no cable, into the second dvi on the HD4870 vid card then unplug the first, wait a few seconds, plug it back in and unplug the adapter I can get a signal and monitor works fine. Go figure. I have a better work around. By setting the power options to put the monitor to sleep in 1 minute; when I boot up Vista 64, wait a minute, move mouse, I get a signal and everything is fine. So, I’m guessing it has something to do with Vista 64 not seeing the monitor even though I installed the correct driver for the monitor. Not big problem, more of a nuisance.

Thanks for all the help. I’ve got 16 days off in a couple of days so hoping to be able to install Win 7 then. I will probably just install on the smaller hdd, thinking of maybe just buying another small hdd just to install Win 7 and do dual boot until it proves stable enough to ditch Vista.