Normally IF function in Microsoft excel by default you will see only for one statement true and false.
If the statement is match, then the condition is TRUE.
If the statement is not match, then the condition is FALSE.

TRUE or FALSE can be value, formula, or text.

Problem : What if the we need more option/conditions…
Let say, below my excel file.

I need to manipulate my cell on E23 with IF.
The condition has to be :
1. If the D23 is similar to D16, then E23 will show text “128 Kbps”
2. If the D23 is similar to E16, then E23 will show text “256 Kbps”
3. If the D23 is similar to F16, then E23 will show text “392 Kbps”
4. If the D23 is similar to G16, then E23 will show text “512 Kbps”
5. If the D23 is similar to H16, then E23 will show text “1024 Kbps”
2. If the D23 is similar to I16, then E23 will show text “2048 Kbps”

So the IF function would be :
=IF(D23=D16,”128 Kbps”,IF(D23=E16,”256 Kbps”, IF(D23=F16,”392 Kbps”, IF(D23=G16,”512 Kbps”, IF(D23=H16,”1024 Kbps”, IF(D23=I16,”2048 Kbps”))))))

I don’t have any idea, how the maximum if function can be extend that way.

Lately I Found, “128 Kbps” we can replace with D14 without ” ” etc…

a. rahman isnaini r.sutan

Quoted from Gnawgnu’s Realm Blog the similar thing also happened on my laptop while trying to connect to a 3G mobile network.

Symantec End Point Uninstallation has stopped Remote Access Connection Manager and dialing to Mobile Network APN, gave me the “Connection Terminated” pop up box. Googling somewhere on Huawei website in which the 3G modem being used, they said that Remote Access Connection Manager supposed to be Started.

Looking at my windows XP services, thie Remote Access Connection Manager is stopped. Trying to start the service, it returns with error “Access Denied”.

For me I have done only deleting Key “88″ at RASMAN on regedit.

Quoted :

Endpoint kills remote access connection manager (Error 5: Access is denied)

To add to the fun, the uninstaller for Endpoint doesn’t always get rid of all the problems that came with it. In one case, all the remote access services crapped out so VPN’s were unavailable. If you try to create a new VPN, the window options all gray out. I saw a solution on the symantec boards which recommend doing a full manual uninstall.
https://forums.symantec.com/syment/board/message?board.id=endpointcust&thread.id=1844
Uninstall instructions:
http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2007073018014248?Open&src=ent_gold_nam
One user did comment on this blog that reinstalling Endpoint resolved issues that another admin he knew was experiencing. You may want to try that or a combination of a full uninstall/reinstall, etc.

Posted by Gnawgnu at 18:26

Anonymous said…

Even after Endpoint was successfully uninstalled, and the Microsoft KB article http://support.microsoft.com/?kbid=329441 was followed, there was an additional RASMAN\PPP\EAP key that needed to be deleted. You must delete 25 and 26 as in the KB, as well as the Symantec Endpoint subkey 17. Then Remote Access Connection Manager will again start.

Event Viewer Error [From Mufti Blog]

• Remote Access Connection Manager failed to start because it could
  not create buffers. Restart the computer. Access is denied. (Error,
  Source: RasMan)
• The Remote Access Connection Manager service was successfully sent a
  start control. (Information, Source: Service Control Manager)
• The Remote Access Connection Manager service entered the stopped
  state. (Information, Source: Service Control Manager)
• The Remote Access Connection Manager service terminated with the
  following error: Access is denied. (Information, Source: Service
  Control Manager)

a. rahman isnaini r.sutan

Animated Presentation is very attractive to the audiences.
They can understand easily even in detail how a process is being done step by step.

But anyway,
When you work with customized Animation features and doing this kind of ‘beautiful’ PPT Movie
it might be you have a need to stop for a while during an animated text/image or what ever is being played / showed…

Many suggestion to stop/pause the presentation, like :
- pressing W [white screen]
- pressing B [black screen]
- pressing any number keys.

They didn’t give me a good solution.
What I have done for a better pausing process is : RIGHT CLICK

Yes the annoying box will appear then right away, but that’s fine.
And to start / continue it again just do : LEFT CLICK at any place of the screen except the right click box ;).

There you go, you don’t have to start it all over again and again…
As the audience may got bored with the same movie

a. rahman isnaini r.sutan

Lately my laptop goes slow.
All resource has been checked and non of significantly & higly in used by a specific service.
Even idle process percentage is more than enough to some more applications.

Using DU Meter, I have been noticing a suspicious & continious Outgoing traffic.
Never aware of this thing out before since I’m working on the High Speed of LAN Connection.
All Internet Connection keeps going on ‘Normaly’.

Till I shocked & found that my Volume Based 3G Service was reached end of blood
It takes less than two weeks to vanish my Quota.

Suspicious things are :
- Virus that generates attack to Port TCP 445 [MICROSOFT DS]
- Virus that generates attack to Port TCP 25 [SMTP]

Both of them are realy damn tough :).
Microsoft DS Virus is pretty much easier to handle rather than SMTP Virus [google everywhere].
This SMTP Virus is generated by Windows Original Services Ran by : “generic host process for win32 services” under SVCHOST.EXE

I even cannot find and edit such file that SVCHOST.EXE running to stop Generic Host Process For Win32 Services at the start up.
It was realy an integrated things.

What I Have done so far and stops this SMTP Virus :

1. Check Their Activity [NETSTAT -AN]

The attempts is starting by Sending numbers of SYN_SENT to the nearest neighbor till computers at the edge of the world once upon you ready have your internet connection is up [Clever huh ?].
It’s Establish the SMTP connection to some/many of IPs.
And You realy know you didn’t send anything at all, nor any of Mail Client Opens / Runs.

netstat -an | more

Active Connections

Proto  Local Address          Foreign Address        State
TCP    0.0.0.0:135            0.0.0.0:0              LISTENING
TCP    0.0.0.0:445            0.0.0.0:0              LISTENING
TCP    0.0.0.0:3389           0.0.0.0:0              LISTENING
TCP    127.0.0.1:1043         127.0.0.1:1044         ESTABLISHED
TCP    127.0.0.1:1044         127.0.0.1:1043         ESTABLISHED
TCP    127.0.0.1:1047         0.0.0.0:0              LISTENING
TCP    202.159.104.3:139      0.0.0.0:0              LISTENING
TCP    202.159.104.3:17068    203.190.241.43:25      SYN_SENT
TCP    202.159.104.3:17070    203.190.241.44:25      SYN_SENT
TCP    202.159.104.3:17072    203.190.241.45:25      SYN_SENT
TCP    202.159.104.3:17073    203.190.241.46:25      SYN_SENT
TCP    202.159.104.3:17074    203.190.241.47:25      SYN_SENT
TCP    202.159.104.3:17075    203.190.241.48:25      SYN_SENT
UDP    0.0.0.0:445            *:*
UDP    0.0.0.0:500            *:*
UDP    0.0.0.0:1025           *:*
UDP    0.0.0.0:1033           *:*
UDP    0.0.0.0:1110           *:*
UDP    0.0.0.0:1132           *:*
UDP    0.0.0.0:2894           *:*
UDP    0.0.0.0:4500           *:*

2. Download & Install Advance Task Manager

This software shows you, all activities in your computer.
Include all hidden process that you have never seen on a Windows Standard Task Manager.
Check at “Internet Connection” Tab and have a good look carefuly at box below “Internet Connections from or to the Programs on Your Computer”.

You should see in the coloumn Address “[IP Adderess Destination]:SMTP”.
That’s It !.
The Process on the left is : “svchost.exe”.
Double click this row, Advance Task Manager brings you to Programs Tab… with Coloumn “Process|PID|…”
And Higlights “Generic host process for win32 services”… Now CHECK & REMEMBER the PID.

3. Open Windows Default Task Manager

Match the PID & the Process “svchost.exe”. [note PID is realy Important]
Once you found the correct process svchost.exe & PID, do End Process
Now, You are Free !.. but only for a While.

4. Anyway, pls do Re-Patch your “Generic host process for win32 services”.

Ask Google Please

– a. rahman isnaini r.sutan

Gigabit LAN should give you a faster file transfer speed and less of time need.
The condition, all work station with Gig NIC connected to a Gigabit Switch.
Last night thing what we expected not happening.

Default NIC configuration in TCP/IP Properties Link Mode for both PCs
Link Mode & Speed : Auto
Result : File transfer Speed up to 200 Mbps

What we have done :

1./
Set NIC configuration in TCP/IP Properties Link Mode for both PCs
Before : Auto
After  : AutoNegotiate 1000
Result : Speed raised up to 300 Mbps

2./
Enforce Gigabit Switch to FullDuplex/1000TX
Result : Nothing ! still limited up to 300 Mbps.

Note : Some NICs don’t have a choice to be set to 1000TX & Full Duplex.
So, you have to be carefull with Gigabit switch.
Set Gigabit Switch Port to Auto is the best thing to deal with, among connected multi vendors NIC - Gig computers/servers.

File transferring using Microsoft Network doesn’t satisfy us then
Idea, use an FTP scheme.
What we have done :

- NIC enforce to AutoNegotiate 1000
- Gigabit Switch Port to Auto
- Install Filezilla Server & Client [depens on with PC/Servers needed to be download].

Note : Why Download ?
We didn’t see Upload speed from time to time more than 100 Mbps.

- Configure your Filezilla server for Server where file needed to be downloaded.
- Configure your Filezilla client for Server where you need to save the file.

Result  ?
- Download Speed up to 850 Mbps.
- Transfering file is realy fast.

Another setting ?
- Adjusting TCP Windows Size in Registry gives us nothing !.
- Adjusting TCP Option so does nothing.

Note :

- File transferring also depends on your Server/PC Resources such Processor & Memory
- Low Resources of course give you low speed.
- Other thing, speed of download will not Always be continuously stable.
- It swings depends on your file numbers, Server/PC resources, HDD Backplane and ect.

Try that !

– a. rahman isnaini r.sutan & IPP

Lately I work a lot with chart.
There’s no Issue using SQL Database & PHP Script plus Chart Libraries
What if I don’t have this ?

Here what I have done :

- Import All TXT log in to a XLS 2003 Office Format.
Problem : some logs above 65535 rows ?!
Excel 2003 will never support this
Break in to 2 sheets.
[Forget it !]

- Upgrade to Office 2007
Limited Supported Rows Solved.
A ha.. I got 1 million more rows..

- Parsing & Cutting some unwanted fields…
- Converting in to Chart..
Problem : support only to 4000 rows to be converted.
Or converted separately in the interval of 4000 rows.

:))
Finally…
I only charting the summarize of the total log.
The detail ?..
Open TXT files…
Ha ha..

Chart o.. Chart.

a. rahman isnaini r.sutan

Office 2007 pretty nice look with better features.
Lately I have this error message :

“This Error Occurs if you try to open a Microsoft Office Document and the file type for that document has been blocked by a registry policy setting. To Help to secure your computer , Microsoft or the administrator of this computer implemented a registry policy setting that prevents opening this type of file”

Here how to solve very fast [compared if,  you have to click the link and brings you to not directly solution :

a. Try to Save File
b. Choose Directory : “C:\Program Files\Microsoft Office\Templates\YOURDOC.doc”

Why ? you have to move or save file in that called “trusted directory” by Microsoft.
Enjoy it.

rgs
a. rahman isnaini r.sutan

=============================================
Nice Free Software For Remote Your Desktop TeamViewer [Here..]
And Control Your Remote Desktop Using Remoteus [Here..]
Securing Remote Access Using IPSec Equinux [Here..]
=============================================

A quick step to enable your laptop to be remotely managed using Remote Desktop from another client.

1. Go to Start
2. Right Click My Computer.
3. Go to Remote Tab
4. Select Remote Desktop
5. Select Allow users to Connectly to This COmputer
6. Choose & Set which user can connect.

Try it, from others

a. rahman isnaini r.sutan

=================================
Traffic Monitoring on Your PC : TrafMeter [Here],
=================================

Last weekend my laptop suffered by a Powerful Trojan.
I was not realy sure what type of trojan.
All it works was : Attacking Many IPs outside on TCP Port 445.
Here a captured log :

TCP    192.168.0.222:2011     69.63.176.195:445    SYN_SENT
TCP    192.168.0.222:2018     66.163.181.168:445   SYN_SENT
TCP    192.168.0.222:2020     202.158.66.24:445    SYN_SENT

TCP    192.168.0.222:2011     129.13.1.55:445    SYN_SENT
TCP    192.168.0.222:2018     10.10.10.56:445   SYN_SENT
TCP    192.168.0.222:2020     77.58.1.45:445    SYN_SENT

Below antivirus software wouldn’t work :

- NOD32
- Kapersky
- Symantec
- AVG 8.0
- MalwareBytes [Anti Malware]

Symantec detected worms, couldn’t clean it out.
This kind of annoying attack also didn’t let you browse any of site.
DNS lookup & ping was Fine.

What I’ve suspect was an Active X application enabled became hole to this trojan to get in last week.
I’ve checked in Task Manager process, this service has been hijacked by the trojan :

WMISVR.EXE > Security Update
WMISVMGR.EXE > Part of WMISVR ? nope sure.

Ending those process manually would gave you 1 minute connection to internet.
Some of site said that I need to manually remove from REGEDIT this kind of process.
It didn’t work since trojan also blocked prompt action to eliminate this by either changing value, rename or even deletion.s

Finally, I’ve re install my laptop.
With NOD32 installed in.
Shocked me, it’s still appears - ATTACK 445.

Last weapon !, by this new fresh registry set…
I can rename the WMISVR.EXE in HKEY_Local_Machine particularly : ControlSet…
Here :

No more 445 …
==============
ALTERNATIVE !!!
==============

Use Directory Opus 9.0 to reveal what really files hidden by microsoft.
In order to find & delete those trojans.
[Thanks Endrik SimangunSong a Wireless & Roof Team]

a. rahman isnaini r.sutan

Lately I found it was really annoy me to wait my Windows start up process.
It takes time to long to really get “ready to use” condition.
I’m thinking all of software & application has been installed properly based on needs only.

Using CC Cleaner [1 version late], trying to re-tighten the needs.
And eventually I have uninstalled some of not really need / rare to use application softwares.
Still not satisfy my waiting time

Not stop there, I should have a look in “Start Up” application of my Windows XP always did once this laptop power up.
All I found is : Antivirus, Adobe Acrobat, Logitech Application, Yahoo tray and others that I don’t think I need at Windows Up.
Once again using CC Cleaner ‘Delete Entry’ located at tools, all of above not really needed to start applications has been removed from start along with the Windows Up

All finally I need is to start listed below :

And now I have a quick Windows Start Up.
If I need antivirus, still can go to Windows Program.

a. rahman isnaini r.sutan