Lowyat.NET: Latest topics by utopian86

MYOB help

utopian86 — Tue, 30 Jul 2013 11:01:52 +0800

Hi everyone
Just a quick question for MYOB

Let's say a company is providing consultation and service only, in MYOB software it will be charge as Sales service and the double entry affected will be Account Receivable right?

DR Acc Receivable
CR Sales service

Correct?

Earth Empires

utopian86 — Fri, 31 May 2013 10:38:28 +0800

Anyone play this game before? Its quite fun when we kill people's country.
This clan usually goes for war. http://sol.ghqnet.com/

http://www.earthempires.com/

Photo effect

utopian86 — Thu, 11 Apr 2013 00:53:06 +0800

http://imageshack.us/photo/my-images/15/85...c56a5405fb.jpg/

how do you guys archive this color effect?
i want to learn something like this

thanks

Excel formula help

utopian86 — Thu, 24 Jan 2013 23:09:20 +0800

Hi everyone

I need help in excel formula

Anyone know how formulate % of diminishing return?

First $1million gives a max of 26%
Second million give a max 18%
Third Million give a max of 5%

Let say if i were to invest $3million i would get 49% (26+18+50)
If $1.5m =35% (26+9)

CODE

First $1m
=IF(N6>1000,26,26/1000*N6)

Second $1m
=IF(P6>0,18/1000*P6,0)

The problem arise when i reach more than $2, where i dont know how to set a max 18%

Is there any more simple way to calculate without using First, second, third $m cell by combining it into 1 cell?

car rental in melaka

utopian86 — Sun, 09 Dec 2012 07:01:29 +0800

Anyone know any car rental service in melaka?

Bakul Sia

utopian86 — Mon, 28 May 2012 13:42:21 +0800

Anyone know where i can purchase bakul sia in melaka?

Streamyx Dlink 2640B

utopian86 — Wed, 16 Nov 2011 13:49:45 +0800

Anyone able to login to the modem website?
i tried going to 192.168.1.1 but fail to open the web
Im not sure how the contractor install it. it seems a lot of my wifi devices cant access the internet at all unless i use cable.

lcct bus station

utopian86 — Sun, 06 Nov 2011 21:19:15 +0800

Hey everyone
is the lcct bus station area for klia express still the same?
which is next to the kfc building outside?

Excel range help

utopian86 — Mon, 28 Mar 2011 19:57:48 +0800

[attachmentid=2122186]

I'm stuck with this excel. i'm not sure how to do this.
I have to let B14 to B22 on "Order Form" worksheet(left) to only accept the item id listed in Mustard Products.
Can anyone guide me please? from EX006: till below, i created a define name Item_IDs
I keep getting #REF! error.

Samsung ML 1665

utopian86 — Thu, 06 Jan 2011 11:48:09 +0800

Anyone know which shop got sell the toner?

The toner model MLT D104S

Gaming Pc

utopian86 — Tue, 09 Nov 2010 22:27:23 +0800

Hi everyone

My friend would like to build a gaming pc. his budget is around 1.5k

He wants to use this processor Phenom II X6 1055T

HD: 500gb - He bought his HD already
Others his not sure what to buy.

Motherboard: ??
Ram: 4GB kingston
PSU:??
GC: ??
Cooler: ??

Passport

utopian86 — Sat, 15 May 2010 22:07:05 +0800

Anyone know where to make passport in kl?

proxy

utopian86 — Wed, 28 Apr 2010 23:12:02 +0800

Anyone got any proxy to share?
can load most of the website atm..

N95 update

utopian86 — Tue, 06 Apr 2010 22:08:22 +0800

Hi everyone
I just update my phone just now.
Its my first time updating the phone.
after i update, all my contacts msg all gone.. May i know how do i get it back?

How do i setup DSL 520B modem to dial from router?

utopian86 — Mon, 29 Mar 2010 14:23:21 +0800

Anyone know how to do this?

WTA- N95 button

utopian86 — Mon, 15 Mar 2010 21:41:48 +0800

Hi
My N95 volume button is spoiled. I can only decrease the sound but cant increase the sound.
May i know how much to replace it?

Nikon website

utopian86 — Fri, 22 Jan 2010 11:49:02 +0800

Anyone can access the website?

I can't access using the normal method.. but can access using web proxy

Mug printing

utopian86 — Tue, 05 Jan 2010 21:04:32 +0800

Anyone know where can do mug printing?
Is there any online website?

Celcom bb

utopian86 — Tue, 22 Dec 2009 09:01:17 +0800

Is it possible to set up this?

Celcom BB use on a laptop and the laptop can still broadcast to other laptop to use the broadband acting as a wireless router?

dell sales service

utopian86 — Sun, 06 Dec 2009 23:05:28 +0800

Anyone ever buy a spoilt product from dell?
I receive the adapter yesterday after i order on friday but inside is a spoilt adapter.

Anyone purchase product from dell recently?
What is the "Order Type" printed on your box?
I got mine replenishment printed on it.