Lowyat.NET: Latest topics by rmy

MS Excel Date Calculation

rmy — Mon, 28 Sep 2015 10:56:13 +0800

I got confused between the maths and logic using an Excel.

Normally when I want to check the difference between two dates, I just simply deduct the recent date to the earlier one like figure below.

[attachmentid=5013570]

So the duration is 10 days. No issue.

After a while I realize that it is logically not correct when I did manual calculation. The difference is 11 and not 10.

[attachmentid=5013571]

Since the Excel file that I deal with involved a lot with money, I'm not sure shall I use manual of keep on using Excel?

LCD screen overheated

rmy — Tue, 24 Mar 2009 18:30:50 +0800

I've purchased Dell WFP248 24" LCD monitor somewhere around last year. After been using it for quite some time, I noticed that the screen seems to be hotter as compared from other LCD with the same size. When I said hot, it means every area on the screen is hot not like at certain area only. I just check with a temperature gun and it shows about 34 degC. Pheww...!!! Due to that heat, it makes me sweating as well everytime I'm using the computer. The rest are OK except for the heat only. Does anybody face such problem like me?

Lastly, I tried to email to Dell about this but it keeps asking about service tag. The problem is, the monitor has serial number only. So how to get some support?

Not enough power?

rmy — Mon, 29 Sep 2008 20:17:26 +0800

I've purchased 250GB WD 2.5" hard disk together with Zynet 2.5" casing for external USB drive. For the first 5 minutes seems to be OK. After that the drive seems responding very slow and suddenly lost the connection. I'm sure the drive still spinning but nothing can be seen when I search for it from My Computer. My friend advised me to buy the new cable that has 2 USB cable instead of one only. He said not enough power for the drive. Again, I tried with two USB plugged together on my laptop. HHmmm....no more issue. My ext drive works perfectly.

My questions:

1. Bigger capacity hard drive (>120GB) requires more power hence external power is required. Is that true?
2. Is the Zynet casing is lauya? I saw my friends used the cap ayam casing with 120GB drive seems to be OK without additional power

Need to install stabilizer bar

rmy — Thu, 08 May 2008 18:20:10 +0800

My friend asked me to install a stabilizer bar for better handling and stability during cornering and driving on normal road. I've seen a lot of people installed the so-called stabilizer bar at the engine compartment and also at the bottom of the car. Sorry lah..don't know what to call that part. My question is, does it really necessary to install one..?? If yes..how much arr..??

BTW, I'm driving MyVI and when at taking a corner at the roundabout, I feel like the car is going to terbalik. Any advice..??

Apply loan on Perodua car

rmy — Mon, 24 Mar 2008 23:03:13 +0800

My friend used to ride a motorbike like me before. He's very desperate to buy a new VIVA since he needs to travel a lot starting next month. He did applied for car loan from RHB and Maybank but it was unsuccessful. Why..?? He had a bad credit history on his credit card payment. Sometimes he pay late but not more than 2 months and sometime on the spot. That's what he said lah..

He was then approached by new salesman and offer him a car loan from Toyota Capital. The salesman said that instead of Toyota brand, the Toyota Capital also cover on Perodua model as well. The interest rate is about 3.88% if take loan to 9 years. He had been asking me about this but...sorry...I oso donno laa... . Is this true..?? or that salesman is just a conman..???

p/s : He said "NO" to Potong...

Parking skill

rmy — Sun, 16 Mar 2008 16:23:43 +0800

Before this I only use motorbike as my primary transport. After got enough money then I bought a new MyVI (auto)recently. Driving is OK but when it comes to parking, my skill a bit lauya. I'm very afraid to park side by side with other car especially in a small parking space and worst in parallel parking. If I got no choice, I will park the car but it gonna takes a long time.

How can I improve the skill arr..???You guys have any good advice..??

Dell laptop DVDROM/CDRW

rmy — Mon, 19 Nov 2007 14:19:53 +0800

Hi guys,

I have a strange behavior of combo drive of DVDROM/CDRW drive. When I boot up the laptop, the device can be detected by the OS. After a while (bout 5mins) it's gone..!!

I try re-seating the drive few times, check the BIOS, installed/uninstalles drivers/etc but the problem still persist. Checked with antivirus/spyware=NONE.

Does anybody kena like me..??Leceh lah ini macam..

Lappy spec:

Dell Latitude 630
C2D 1.8GHz
1GB RAM
i965 mobile mobo
80GB Hitachi mobile HDD
HL something DVD/CDRW combo optical drive (don't know coz the drive is missing while I'm typing this msg)

Dual Network

rmy — Sat, 14 Apr 2007 14:22:14 +0800

A no0b question..I think..!!

I only have 1 connection from the internet something like this

» Click to show Spoiler - click again to hide... «

PC1 has 2 integrated network port (nForce570)- only 1 utilized whereas PC2 only got 1(cheapo NIC)

Is it possible if I make use of PC1 by plugging in another socket from the router and becomes like this

» Click to show Spoiler - click again to hide... «

Possible..?? I got mixed comment from my frens and now confuse oredi..

1. "cannot meh.."
2. "no use oso since the PC1 receive same bandwitdh, so port1=50% port2=50%. It's the same if use single port"
3. "your PC sure hang coz have 2 IP address"
4. "walau eh..!! can teach me ah..??"
5. "where got 2 port network..gila kaa..?" <== I bet he's staying in Gua Niah or something..

And here's nVidia DualNet features

» Click to show Spoiler - click again to hide... «

Dual Network

rmy — Sat, 14 Apr 2007 14:20:41 +0800

A no0b question..I think..!!

I only have 1 connection from the internet something like this

» Click to show Spoiler - click again to hide... «

Funny clip

rmy — Sat, 03 Feb 2007 23:15:07 +0800

Holly Dolly clip

Donno if posted here before. The clip looks OKlah but I like the song heheh..

nForce 570 Ultra chipset

rmy — Mon, 18 Dec 2006 13:49:08 +0800

1. I upgraded my PC recently from aging Pentium II 266MHz to Athlon64 X2 4200+. MSI K9N Ultra was my choice and the installation gone smoothly. Once I installed nVidia monitoring tools found from the CD, the software reported that the chipset temp is 162C..!!!

I thought it might be software error so I just touch the heatsink and DAMN..IT'S SO HOT..!!Once I installed a small fan on it, the temp drops to 80C but it's still hot..I checked with my friend using the same chipset from Asus and Gigabyte. They also faced the same problem that I have.

Is this normal..??Any effect on the mobo..??

2. After using the X2, some of my program won't run correctly and sometimes not responsive once I clicked e.g Regcleaner,TweakXP,StyleXP etc. What did I do wrong..?? Did I installed WinXP wrongly..??

My rig:

A64 X2 4200+
2x1GB Corsair 800MHz DDR2
320WD SATA
MSI K9N Ultra
HIS Ati Radeon 1650 Pro