Lowyat.NET: Latest topics by sunakujiro^^

WTS > GoPro MAX 360

sunakujiro^^ — Mon, 02 Dec 2024 15:24:41 +0800

Item(s): GoPro MAX 360

Package includes: only just the camera itself

Price: RM800 (Negotiable)

Warranty: none

Dealing method: COD

Location: KL, Selangor

Contact method/details: Whatsapp +62 812 9592 3659
---

Item(s) conditions: Good condition

Picture:

Reason for sale: Helping a friend from Indonesia to sell his personal item as he needs money for his studies in Malaysia.

Excel Calculation

sunakujiro^^ — Mon, 17 Dec 2018 13:48:18 +0800

Hi, I have a form that calculates each item as YES, NO, NA.

From the attached excel, I have 18 items under parameter BS.

How the calculation should works:

If all 18 Items are either YES or NO, it should sum and divide by 18 items.

But Im trying to figure out, if out of 18 items, 8 items are categorized as N/A, then the calculation should be Sum and Divide 10 items. (18 items: 10 items = Yes, 8 = N/A , total = 100%)

Any item categorized as N/A should not be counted.

Could you kindly guide me how I can do that?

WTB Monster Hunter World PS4 R3

sunakujiro^^ — Thu, 01 Feb 2018 02:47:08 +0800

WTB Monster Hunter World PS4 R3

SUBANG JAYA/SUNWAY

Need help to improvise my Excel Table

sunakujiro^^ — Wed, 10 Jan 2018 13:12:14 +0800

Hi guys,

I need your opinion to improvise my excel table so it looks more readable and tidy.

As you can see, the table list is enormous, because I need to include each months and repeating the same name.

Is there a way to make it easier by not repeating ROW A B and improvise ROW C D

that means

Attachment

> <WTS> Samsung S6 32GB Gold color RM1k

sunakujiro^^ — Thu, 25 May 2017 15:09:00 +0800

Item(s): Samsung S6 32GB GOLD COLOR

Package includes: Phone, earphone and charger cable

Price: (!!!NOTICE!!!: Sellers are required to display the exact selling prices of their products. Failure to do so will result in the deletion of the topic) RM1050

Warranty: -

Dealing method: COD

Location: Shah Alam/Cyberjaya

Contact method/details: 012-2373725
---

Item(s) conditions: Pristine 9/10

Picture:

Reason for sale: Upgrading

Ryu & Chun-Li Figure from BANDAI

sunakujiro^^ — Tue, 16 May 2017 00:58:21 +0800

Item(s):
Ryu & Chun-Li figures
* S.H.Figuarts
* Original from BANDAI
* Japan Version
* 1/12 scale figures

Package includes:

* Main figure
* Optional expression parts x2 types
* Optional hands left & right x3 types
* Hyakuretsukyaku effect
* Effect support part
* Background sheet

Price: RM300 each

Dealing method: COD Subang Jaya/Kelana Jaya

Location of seller: Subang Jaya

Contact method/details: PM

Age of item: New, sealed and unpacked.

---

Item(s) conditions: New, sealed and unpacked.

Picture:

Reason for sale: Extras

<WTS> Samsung S6 32GB Gold color

sunakujiro^^ — Mon, 15 May 2017 23:42:50 +0800

Item(s): Samsung S6 32GB Gold color

Package includes: Earphone, Cable charger and Wireless Charging pad.

Price: RM1350

Warranty: None

Dealing method: COD Shah Alam, Cyberjaya

Location of seller: Shah Alam

Contact method/details: 0122373725

Age of item: 12 months

---

Item(s) conditions: 9.5/10

Picture:

Reason for sale: Upgrading

WTS Charles & Keith Handbags

sunakujiro^^ — Mon, 03 Apr 2017 00:45:48 +0800

Item(s): Charles & Keith Handbags

Price: RM200 (Blue and Pink) , RM220 (Peach, makeup bag included)

Package Include: Long strap

Color: Blue, Pink and Peach

Dealing method: COD : Putrajaya, Cyberjaya (Weekdays), Subang Jaya, USJ, Sunway (Weekends) RM10 postage Peninsular, RM12 E.Malaysia

Location of seller: Subang Jaya Selangor

Contact method/details: PM me for Whatsapp

Age of item: New

---

Item(s) conditions: New

Retail Price: RM430

Reason for sale: Money

AVAILABLE BLUE & PINK CREAM

PEACH SOLD

Updated: Peach SOLD, Blue and Pink cream available

WTS [NEW] ZARA Women footwear

sunakujiro^^ — Mon, 20 Mar 2017 23:53:47 +0800

Item(s): ZARA Women Leather Buckled Ankle Boots

Package includes:

Price: RM150

Warranty: NA
Dealing method: COD
Cyberjaya/Putrajaya (Weekdays)
Subang Jaya, Sunway (Weekend)

Poslaju (RM10 Peninsular, RM12 East)

Location of seller: Subang Jaya/Sunway/USJ/KJ

Contact method/details: PM Me

Age of item:NEW

Color : Dark brown
Size: 35
Condition: 10/10
Reason for sale: Need money
---

-------------------------------------------------------------------------------------------------------------

Item(s): ZARA Women Sneakers Shoes

Package includes: Original Price RM269

Price: RM190

Warranty: NA
Dealing method: COD
Cyberjaya/Putrajaya (Weekdays)
Subang Jaya, Sunway (Weekend)

Poslaju (RM10 Peninsular, RM12 East)

Location of seller: Subang Jaya/Sunway/USJ/KJ

Contact method/details: PM Me

Age of item:NEW

Color : White with black stripes
Size: 38
Condition: 10/10

WTS Garmin Forerunner 25

sunakujiro^^ — Tue, 28 Feb 2017 01:22:38 +0800

Item(s): Garmin Forerunner 25

Package includes: Watch and Charger

Price: 650

Dealing method: COD

Location: Kuala Lumpur/Selangor

Contact method/details: PM me

Item(s) conditions: Brand new, redeemed from company points.

Age of item: 2 weeks

Reason for sale: I dont' jog and need money.

Picture:

Excel sumif need help Formula

sunakujiro^^ — Fri, 26 Aug 2016 15:50:19 +0800

Hi

I have a workbook that contain 8 questions

each questions have different points.. example:

Q1 -> Q8 their points will be [ 17, 20, 13, 15, 16, 11, 4, 4] = 100%

user can use the dropdown button -> YES/NO/NA

condition:

If user select all YES , total will be = 100
If user select NO, total will be deducted.
If user select 7 Yes, 1 NA = point should be 100% as well
If user select 4 YES, 4 NA = point still 100%

I use a formula =SUMIF(XX:XX,"Yes",XX:XX)

problem is, it works fine if all questions are answered only YES and NO, however if a mixed of YES, NO and NA, i wont be able to get 100%

Can anyone shed some light?

EXCEL - Send email in VBA excel to Outlook

sunakujiro^^ — Tue, 01 Mar 2016 22:52:42 +0800

Hi Excel Master

I have a template ready in my workbook that look like below, and I need to generate an email with the subject and attachment for the workbook that I'm currently doing it.

The purpose of SEND EMAIL button as illustrate above, will draft email with the following criteria:

The Email Subject should retrieve - items highlighted in Yellow (Notification - Ref / Title/ Time)
TO and CC field - should have multiple recipients name
Body - Header starts with "Hi All " followed by the template B4:G8

I've tried the following code , but didn't produce the result I want. Instead of drafting - the macro automatically sends an email to recipient.

CODE

Sub Send_Range()

' Select the range of cells on the active worksheet.
ActiveSheet.Range("B4:G8").Select

' Show the envelope on the ActiveWorkbook.
ActiveWorkbook.EnvelopeVisible = True

' Set the optional introduction field thats adds
' some header text to the email body. It also sets
' the To and Subject lines. Finally the message
' is sent.
With ActiveSheet.MailEnvelope
.Introduction = "Hi All" & vbNewLine &
.Item.To = "abc@abc.com"
.Item.Subject = ""
.Item.Send
End With
End Sub

WTB Rainbow Six Siege

sunakujiro^^ — Fri, 05 Feb 2016 23:32:16 +0800

WTB Rainbow Six Siege

COD : Subang Jaya/Damansara/Sunway/Puchong

Reasonable price please

Myvi rattle screeching noise coming from front

sunakujiro^^ — Wed, 26 Aug 2015 17:20:30 +0800

Hi, I'm using Myvi 2007 and past 3 days, I've been experiencing this rattling, screeching noise. coming from car hood. I dont know how to explain to the workshop..its the kind of annoying screeching noise..and when I pressed the brake pedal, the noise became more obvious.

It happens sporadically at certain period of time regardless whether the car is accelerating or at constant speed and then the noise will go away.
I dont know whats the problem, but in summary:

1. I drive for 10-15 mins . No noise
2. After a while, the noise can be heard from hood.
3. I decelerate and step on the brake pedal the noise became more obvious
4. the noise gone.. but will come back again after a while.

I'm posting a video, the noise can be hear from the very beginning, and it became more obvious after 11secs above as I stepped on the brake pedal. PLEASE CAN SOMEONE tell me the problem and good mechanics around subang, puchong, seri kembangan, shah alam or anywhere.

Incase the embedded youtube not working https://www.youtube.com/watch?v=RxNTHsuVobI

[YOUTUBE]www.youtube.com/watch?v=RxNTHsuVobI[/YOUTUBE]

WTS Sony Z3 Copper CHEAP

sunakujiro^^ — Tue, 28 Jul 2015 04:42:44 +0800

Item(s):SONY Z3 D6653 Copper

Package includes: Phone itself, tampered glass front, condom casing (black)

Price: RM700

Warranty: Till Oct 2015

Dealing method: COD

Location of seller: Weekdays - Cyber, weekend - Subang Jaya

Contact method/details: PM me here

Age of item: Bought Oct 2014, go figure.

---

Item(s) conditions: Functional with following issue:

1. Back Panel hairline crack
2. Screen display not fully intact. If you take a closer look at the side of the screen, you can see a light beneath it. Solution: Push back the screen, or glue it with M3 adhesive glue
3. Can't pull down notification bar except at Lock Screen or landscape mode (go chrome, tilt your phone sideways, can pull down notification)
4. Speaker sound abit pecah if play music too loud

Picture: Better see it for yourself

Reason for sale: I love sony Z3, but with these kind of problem everytime, I think I better off using cheap phone. Was thinking to smash it on the floor, but I could use some cash

WTB Watch Dogs PS3 WTB

sunakujiro^^ — Sun, 17 May 2015 15:09:22 +0800

Area: Sunway/Subang Jaya/ Kelana Jaya
COD : Today (while i still have the hype to buy and play)

Z3 apps crashed

sunakujiro^^ — Mon, 15 Dec 2014 11:23:56 +0800

Hi

I just bought Sony Xperia Z3. Problem if I have few apps crashing.
For example Instagram.

After login to instagram, the application crashed with error "unfortunately Instagram has stopped working".
If I click on Instagram again, it will last for 4-5 secs before crashing with the same error again.

Another application is called ANKIDROID

I can't even get to the menu. It stopped working as soon as I click the Icon.

Some user suggest that I uninstall anti-virus , but I dont even have one on my phone..

Can anyone shed some light?

boo yah

sunakujiro^^ — Wed, 29 Oct 2014 12:25:18 +0800

5 sa

myvi side mirror..need advicd

sunakujiro^^ — Mon, 01 Sep 2014 01:30:35 +0800

Hi guys i need advice bout myvi side mirror at drive side.
Mine was broken last night.. the bracket already patah, but the side mirror still intact and functioning.. signal indicator and mirror aut adjust are still working..

If i send to workshop, do you think i need to replace the side mirror or jst the bracket.. .

Any idea how much the total cost might be? I searched the forum for this issue but the thread dated 4 years ago..

Forthe mean tkme can i just cut the wire? Will it effect any electronics part?

Thank you kindly.

[WTB] Assassin Creed 2 PS3

sunakujiro^^ — Sun, 03 Aug 2014 01:05:08 +0800

[WTB] Assassin Creed 2 PS3

COD: Subang Jaya, USJ, Sunway, Puchong, Putrajaya/Cyberjaya

Now. Or Sunday 3rd August.