Lowyat.NET: Latest topics by shanky

［WTS］used iPhone X 64GB space grey(Apple MY set)

shanky — Tue, 23 Jul 2019 09:31:13 +0800

Item(s): Iphone x 64gb Space grey

Package includes: as per box, cable. Charger. Earphone (unused). Tempered glass front & camera lense (applied)

Price: RM 2600

Warranty: still under Apple MY. Phone activated Dec 2018. Not a telco set

Dealing method: COD

Location:COD Old town cyberjaya weekdays- after 6pm
Weekend - KL or PD

Contact method/details: PM
---

Item(s) conditions:. 99% GREAT CONDITION. Not a heavy user as have another android phone.

Picture:

Reason for sale:.my soul not match with apple ios

[WTS] Swatch White Rebel *sold

shanky — Sun, 03 Jan 2016 18:16:54 +0800

Item(s): 1 Swatch White Rebel

Package includes:everthing as per box

Price:sold to forumer

Warranty: Swatch.Bought at One Utama. Purchase date 14 Dec 2015

Dealing method:COD preferred. other mode please PM

Location of seller:Cyberjaya ~ Melawati ~ Lukut

Contact method/details:PM

Age of item:still new

---

Item(s) conditions:Great

Picture:

Reason for sale:i still got my smartwatch

[WTS] Shell Ferrari Cars

shanky — Sat, 02 Jan 2016 23:42:09 +0800

Item(s):as per picture. only 5 cars.

Package includes: each car with box

Price:RM30 per car/box

Warranty:as it is

Dealing method:COD preferred. other mode please PM

Location of seller:Cyberjaya ~ Melawati ~ Lukut

Contact method/details:PM

Age of item: few years

---

Item(s) conditions:good. in box on cabinet

Picture:

Reason for sale:need to take space

[WTS]James Bond exclusive Shell collection 2008

shanky — Fri, 01 Jan 2016 17:12:47 +0800

Item(s): as per title

Package includes: full set as picture with case

Price:sold to non forum member

Warranty: as it is

Dealing method:COD preferred. other mode please PM

Location of seller:Cyberjaya ~ Melawati ~ Lukut

Contact method/details:PM

Age of item:new as it is in storage room

---

Item(s) conditions:great

Picture:

Reason for sale:need space

[WTS] Shell Lego Tanker

shanky — Fri, 01 Jan 2016 13:57:57 +0800

Item(s):Shell Lego Tanker

Package includes:1 pack sealed

Price:RM 60 per pack

Warranty: none once receive as it is sealed packing

Dealing method:COD preferred. other mode please PM

Location of seller: Cyberjaya ~ Melawati ~ Lukut

Contact method/details:PM

Age of item:New

---

Item(s) conditions:Sealed

Picture:

Reason for sale:Extras

sold ed* Apple TV 3rd Gen MD199ZP/A, unopen box

shanky — Sun, 13 Dec 2015 20:58:36 +0800

Item(s): Apple TV 3rd Gen MD199ZP/A

Package includes:All in box. unopen.

Price:RM230

Warranty:Apple

Dealing method:Preferred COD. Other methods, please discuss

Location of seller:Cyberjaya
Contact method/details:PM

Age of item:New

---

Item(s) conditions:great

Picture:

Reason for sale: not using

google SMTP using streamyx line

shanky — Sun, 01 Feb 2015 02:03:39 +0800

Hi all,
Anyone can help me as i need to setup my ip camera to trigger email to my gmail account but got error, can not connect SMTP server.

Tried 465 , 587, 25 port . SSL , TLS .. all the options. Still cannot.
reset the ip camera - DCS 933L . Setup all over. Still cannot.
reboot n recheck my modem router DSL 2640T . Still cannot.
google around, cant find the solution...

Anybody can guide me?

*the ip camera is functioning; test with YES line, can send email out .hmmm.

Thank you in advance.

Excel function for counting days

shanky — Fri, 22 Jul 2011 10:12:50 +0800

Hi All,

Please advise as I am unable to find a specific function/formula for counting total days excluding Sunday , within a given range of date (within 2 dates given).

I am only able to find ,there is networkdays() , but it will exclude both saturdays and sundays within that date range.

so , I have created a formula, but it is so long... (need to press shift+alt+enter once put the formula)

B5 = first date
C5 = Second date

for total days :
=SUM((DATEDIF(B5, C5,"d"))+1)

for counting sunday :
=SUM(IF(WEEKDAY(B5-1+ROW(INDIRECT("1:"&TRUNC(C5-B5)+1)))=1,1,0))

for counting total days excluding sunday :
=SUM((SUM(DATEDIF(B5,C5,"d"))+1)-(SUM(IF(WEEKDAY(B5-1+ROW(INDIRECT("1:"&TRUNC(C5-B5)+1)))=1,1,0))))

Is there is anyway to make the formula shorter ? appreciate your help !

Thanks !