Crossing L4A

Combining Cells in Excel

2011-07-25T03:12:00.000-07:00

In Excel we can do much, such as i am gonna show how to combining cells in excel.

combine multiple cell ( minimum with 2 cells ) with &
Example :
cell a1 : Together
cell b1 : Forever
with this formula we can get TogetherForever.
How do you do it ? Heres how, just use this formula =a1 & b1

And You can use space to get Together Forever with this formula = a1 & " " & b1
Interesting isn't it?

Combine text with number too.
example :
cell a1 : 4
cell b1 : Ever
How : ="Together " & a1 & b1 ==> you'll get Together 4ever

combine text with date
="today is : " & today() ; u'll get today is : 40749
to fix this :
="today is : " & text(today();"dddd") ; u'll get today is : monday

For Others :
Format a date
="Payment is due " & TEXT(today(),"dd mmmm yyyy")
result : 25 July 2011

Format number as currency
="Amount due: " & TEXT(2500000;"Rp #.##,##00")& " Idr"
result : Amount due Rp 2.500.000,00 Idr

Format a number as a percentage:
="Your Popularity is " & TEXT(0.8,"0%")
result : Your Popularity is 80%

Format a number as a fraction:
="Hours worked: " &TEXT(5.25,"# ?/?")
result : Hours worked: 5 1/4

thx for reading this blog.

Linux User : What is i386, i586, i686

2011-04-20T18:27:00.000-07:00

I just found out that linux has so many version Hardware than windows.
Windows only have 2 kind version of Hardware, which is x86 (32 bit) or x64 (64 bit).
Linux has 3 version of hardware, and that are i386, i586, and i686.
the differences are :

kernel i686 -> Pentium Pro/Celeron/Pentium II/Pentium III/Pentium IV
kernel i586 -> Pentium-Classic
kernel i386 -> 386/486

linux user can check what kind version of your hardware by type this command :
#cat /proc/cpuinfo ( check your model name )

the sources that i quote from : http://www.linuxquestions.org/questions/linux-hardware-18/what-is-the-meaning-of-i386-i686-and-where-i-can-find-this-information-327233/

HOW TO CPANEL 11 WITH GOOGLE APPS - MAIL

2010-09-22T21:34:00.000-07:00

Here's a some tips how to set cpanel 11 with mail of google apps.

Create an account for your google apps - choose standard (http://www.google.com/apps/intl/en/group/index.html)
Choose your domain ( buy from google or add from existing domain )
Get your domain verified with G-Apps ( in my case : download google88c16fb7xxxxxxx.html and copying to my root www domain )
Now your done registered with g-apps. Just don't forget to add your user email account.
Open your CPANEL and Log In
Go to MX ENTRY
add this :

1 aspmx.l.google.com 74.125.45.27
5 alt1.aspmx.l.google.com 74.125.93.27
5 alt2.aspmx.l.google.com 74.125.113.27
10 aspmx2.googlemail.com 74.125.43.27
10 aspmx3.googlemail.com 72.14.213.27
10 aspmx4.googlemail.com 209.85.229.27
10 aspmx5.googlemail.com 74.125.157.27

and you ready.

If you want to change your url http://mail.google.com/a/mydomain.com to MAILS.MYDOMAIN.COM

Then go to CPANEL
open SIMPLE DNS ZONE EDITOR
ADD A CNAME RECORD
name mail

name : mail.mydomain.com
CNAME : ghs.google.com

and save

Now you can try it on

Best of luck from to you all

How to Check your Power Suppy Unit live of dead

2010-05-02T20:09:00.001-07:00

Here's the tips how to check your the PSU lived or dead.

First, get the a trigonal clips and bend it in to the U shape.

Second, Plugin your PSU

Third, connecting trigonal clips with cable pin (theres 20 pin) of the PSU ( the Green and the Black ).

If the fan is on the the PSU is lived, if not then its dead ( U can throw it away or sell it )

Shorcut for Windows 2000 or XP Management Console

2010-05-02T19:58:00.000-07:00

Here's the list of shortcut for Windows Management Console :

Computer Management : compmgmt.msc

Disk Management : diskmgmt.msc

Device Manager : devmgmt.msc

Disk Defragment : dfrg.msc

Event Viewer : Eventvwr.msc

Shared Folder : fsmgmt.msc

Group Policies : gpedit.msc

Local User and Groups : lurmgr.msc

Performance Monitor : perfmon.msc

Resultant set of Policies : rsop.msc

Local Sevuruty Settings : secpol.msc

services of windows : services.msc

Component Services : comexp.msc

And for bonuses :

If it happens u found this messages "Ntldr is missing" then go with this tricks :

Go Booting with original cd's and re-copy ntldr files from the cd's or u can copy from other computer with the same os.

How to Insert Excel in Word

2010-04-04T23:36:00.000-07:00

There's lots of ways to insert excel in word.

But i'm gonna show u'all how to insert a long excel to one page word.
First open your excel and use page break preview to see your work in 1 page.
Second copy you excel and open your word and go to Edit , Paste Special and Picture (Enhanced Metafile).
Third well your excel become an image and you can move or drag or even resized.

Well believe it or not....

Mencari uang online - Make money Online

2010-03-28T23:30:00.000-07:00

IF YOU ARE LOOKING FOR PAY PER CLICK SITE THAT REALLY PAYS.

GO HERE :

http://pay-per-click-ptc-ppc.blogspot.com/

Remove multiple hyperlink in Excel

2010-03-25T19:58:00.000-07:00

Type the number 1 in a blank cell, and right-click the cell.
Click Copy on the shortcut menu.
While pressing CTRL, select each hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) you want to deactivate.
- To select a cell that has a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross , then release the mouse button.
Click Paste Special on the Edit menu.
Under Operation, click Multiply and then click OK.

Symbol/Codes for Life

2010-03-23T00:12:00.002-07:00

How to Use :

Press Alt + [4 digits Codes]

Common Symbols And Codes

Euro € 0128
Ellipsis … 0133
Dagger † 0134
Double Dagger ‡ 0135
Bullet • 0149
Trademark ™ 0153
Cents ¢ 0162
Pounds £ 0163
Yen ¥ 0165
Copyright © 0169
Registered ® 0174
Plus/Minus ± 0177
Paragraph ¶ 0182
Degree ° 0176

Tips : too check all the symbols or codes in excel : =CHAR(ROW())

The "inverse" of the CHAR function is the CODE function. While CHAR takes a number and returns the actual character, the CODE function takes a character and returns the code number

Learning new Feature #2 of Window 2003 Server

2010-03-22T01:23:00.003-07:00

Distribute File System or DFS, its a system for replicating sharing files between server or between folder.
Heres the concept is a temp folder for sharing copy between folder01 , confuse huh ?
Let me show how then you will understand ( probably ), here we are ...
- Choose Distribute File System from Administrator Tools button and Next
- Create New Domain DFS Root and choose your domain
- Create New DFS Root, and Next ( but b4 that share some folder , sample C:\DFSRoot, if you have 2 server, create both with the same name )
This one is for temp folder, cannot be open to see what inside and create by system
- And your done...but keep reading

- Now you must create a Link DFS, right click on domain DFS, and choose New Link
- Insert Link Name [ART], and Path to Target [//SRV01/folder01]
Comment , Time Value are optional
- If you have two servers host identical information then
Add New Target, Path to Target [//SRV02/folder01]
- And Last thing enabling replication by running Configuration Replication
Choose Master Target [//SRV01/folder01] next ...
Topology [Optional but i choose Ring] and Finish

Now how to use it just run CMD and type net use R: \\Domain.com\ART and dir R:
if there ain't error
You just create your first DFS Root and Link...well done [ i'm just enjoying my self and dont bother me now ]
Please create a comment and have fun...

Learning new Feature #1 of Window 2003 Server

2010-03-22T01:23:00.001-07:00

Friday 18 July 2008,
Learn VSS ( Volume Shadow Copy Service ):
This how to activate VSS - first install shadowcopy from microsoft
second, try to shared a drive on your HD
third, on the client side, install twclient (u can get the file from the server side)
fourth, the last thing try to change a file on the drive you shared, and goto the client side, right click properties and choose previous version...and alakazam there you have the previous file you update and you can choose which file you want to restore.

Monday 21 July 2008,
in the morning i got my server shutdown, bcoz of the power from the central was shutdown. i got panicked a little, but i turn on the server and update the service of the server ( update microsoft if u know what i mean ), after the server uptodate, i enabling the RAS VPN ( this one is annoying bcoz i need to enabling and disabling few times until its up by them self ) but after that, all things was running smoothly.

Tuesday 22 July 2008,
i hate the vendor that repair our computer, bcoz their playing with us. 1 of the computer was restart all the time and becoz still guaranty from the vendor, we called them to check the computer and then they brough with them to their office.
After the send the computer back, they said the reason restarting all over bcoz the fan was disable from the bios to the user ( coz im not there ), well that stupid bcoz fan processor was controlled not from the bios but the cable the plug into the motherboard, now whose stupid to make a reason like that. i hate those L. Well atleast we call'em again bcoz the computer still other have the problem and i told them how stupid the reason...haaaahahah feel better now.

Install XP SP3 and ...

2010-03-22T01:22:00.005-07:00

I just download SP3 for XP, and install them. After that i create an unattended CD of XP from SP2 to SP3.

Heres how i do it :
First : extract or copy the XP SP2 to a folder
Second : use the SP3 files and open Command Prompt and use this command : [WinUpdatefiles] /integrate:[path of XP u extract]
KBSP3.exe /integrate:E:\XP-CD
Third : after a message show that the integration succeded, create an iso with magiciso ( create a boot from the real XP cd ) and try with VMware.
Fouth : ...Done

2010-03-22T01:22:00.003-07:00

Today i just replacing UPS for the servers. And must shutdown the server and start after the UPS is ready, and after that "again" the RRAS - VPn aren't running well.
So i configure again...
Step 1 : go to properties - IP - uncheck Enable IP Routing and Allow IP-based Remote - Apply - check Enable IP Routing and Allow IP-based Remote - Apply
Step 2 : Try to connect for 30 second if it suddenly cannot connect try repeat Step 1.
After the third try....it was running smoothly...

confusing VPN RRAS problem

2010-03-22T01:22:00.001-07:00

Today i'm having problem with my Vpn through RRAS, from 9:30 till 16:40 trying to configure'em.

First my problem was the vpn could not connected and want to redial.
I check the server, router and dsl, and the problem was on the dsl, so i unplug and plug again the dsl. The result i can ping the dns, but still no luck with the Vpn.

Next, i'm disabling the RRAS and enabling again. So i can reconfigure the RRAS, but no luck still couldnot connect the vpn.

and on my lots of attempt, still no luck. After i'm trying to change the ip range from 105 to 104 ( no luck either) and from 104 to 105 ... alakazam....its working....

So...now i confused, i dont know what happen but its working.....thank God...
I am wasting almost a day thinking and reconfigure this but still cannot figure what happen....

Aloha Pos Tips and tricks

2010-03-22T01:21:00.005-07:00

Today im gonna post some tips and tricks for Aloha Pos,

- After installation and setting dont forget to configure the report before anyone using it, if not it will not show the report ( Pmix, sales etc etc )
- How to bypass Password Aloha's :

Launch Aloha Manager.
Go to Login - (before type anything) press Alt-X.
4 sets of numbers will appear.
Use whatever username you want ( im using "admin" ).
Start with every the last digit of the number at the Top Left, Top Right, Bottom Left and Bottom Right and typing this 4 character password.
and type 1=q, 2=w, 3=e,4=r,5=t,6=y,7=u,8=i,9=o,0=p
example : i got 5941 then the password is torq

- How to manage standalone mode Front House :

When it display 'Make FileServer'
Press it, and it will show the two sets of number at the bottom of the screen
Sum them and input it in as the password

- How to setting printer from windows driver

Install driver printer for windows
Setting the printer and choose windows driver from what port you use for the printer
and refresh

- How to make a new item and showing in the menus

Go to Aloha Manager
Go to Maintenance - Menus
Go to Item ( input the new item that means code, name, price, tax, printings, modifier and others details.
Go to Categories ( configure categories for this item )
Go to Submenus ( configure submenus for this item )
Last go to Menus ( configure menus for this item to show in the menus )

- If you cant solve a serious problem and your head gonna explode, do this

Aloha Manager - Utilities - Create Diagnostic files, > then zip the contents of the diag folder
and send it to Aloha Support in US

- Here's two links that can save us about aloha :

Aloha Table Service POS Online Help can be accessed through :http://poshelp.alohaenterprise.com/ts/wwhelp/wwhimpl/js/html/wwhelp.htm
Aloha Quick Service POS Online Help can be accessed through :http://poshelp.alohaenterprise.com/qs/wwhelp/wwhimpl/js/html/wwhelp.htm

( Credit Thanks to Mr. Adhi Nugroho @ intertama )

Lesson number 03 about Aloha Pos

2010-03-22T01:21:00.003-07:00

Next subject are Promo and comps. Promos and comps are depend to categories, thats mean you'll have to configure the categories for the promos and comps before you configure the promo and the comps
First about the Promo, theres some category in the promo such as Coupon, Bogo, Combo, Quick combo and Check Reduction.
Coupon ( for free item or discounts with coupon )
Bogo ( Buy One Get One )
Combo ( a set of food with various price )
Check Reduction ( discounts )

So the theory are :
1. Make sure what kind of promo you gonna make ( names, food, start/end dates, prices )
2. set the categories for promos
3. make the promos

Example :
1. Discount pizza regular 20 %, disc 20 % Pizza R, start/end dates 01/05/2008-31/05/2008
2. make the categories under " pizza R 20" and include all Pizza Regular
3. Build "Check Reduction", choose the categories, and discount 20 in percent
4. Refresh and Done

Second for comps - complimentary is a compliment for guest ( free or discounts )
the theory are the same as promos except the start/end dates :
1. Choose the function and names for the comps
2. make the cats
3. insert the cats and choose for free or discounts and min/max for this comps.

Example :
1. Duty Meal, max : 400.000
2. make cats : dutymeal and include pizza regular and tea only
3. insert this cats and choose amount 0 and max : 400000
4. Refresh and done.

well thats it, next will be tips and tricks

Lesson number 02 about Aloha

2010-03-22T01:21:00.001-07:00

Hii again, and lets continue about aloha...

Before install the pos you should know about the position and the quantity of the computer and especially the printers, you have to decide which ones is for hot cats or cold cats or other categories.

After you install the POS like lesson number 01 ( not clean install bcoz, the data was there before but for the next unit ), then do this :

change the : Revenue Center ( Code) and check use numeric tab names
Maintenance-System-Tables (change the Rev Center only)
Store settings (update/change store information)
Job , Terminal and Order mode ( change the Rev Center )
update the name of the terminal and printers
update the employee, item (item, categories, menus and sub menus)
update the promo and comps

On delivery interface FB preference : Change Area Code, City, Stare or Province, Plan Code (Outlet code), Phone Number Type Form (FreeForm), Historical Order (9999) and Valid Area Codes (phone area codes)

Next : Promo and Comps....

Tips and Tricks (expert only)

2010-03-22T01:20:00.002-07:00

"Im using DBF for my Aloha POS and using Foxpro to make my life better"

Here's some tips :

Fixlog trans.log ( for corrupt trans.log only )

Grind /date yyyymmdd
Grind /date 20070112 ( to grind manually from CMD.EXE)
Grind /date 20070112 /mergetranslogs trans1.log trans2.log ( to grind merging two trans.log into one trans.log - for emergencies only )

eodgrind, ok ==> do not delete
eod => delete, if the grind being waiting or halted

The types :
1 - Payment
4,31,52,63 - total
5 - Comps
6 - Promo
43 - Check
49 - Bill/guest
63 - Tax
71 - Void

If you have to install from zero and have the transaction running do this :
backup the newdata and data, and check the dates and restore'em (99%) and 1 % must input manually again.

Lesson number 01 about Aloha Pos

2010-03-22T01:20:00.001-07:00

This is about the Aloha POS system that learned, so im gonna give some tips... ( Izzi's nomor ... )

So First about the installation...

choose Advanced instead Setup from the cd's bcoz setup is for upgrade to new version of Aloha and advanced is for new installation ( dont forget to plug your dongle or it won't running)
And then choose table services and next ( if not mistakes )
And choose the data you want to use. Use from the sample or newdata.zip/bmp.zip data from before
Then it will install till finish, well your done.
Last thing, dont forget to insert your License number from the vendor that match with you dongle (SEC), well you can insert later after the installation

After that dont forget to install Aloha DS Interface for your delivery/customer process.
Here's the how to : close all the program that running, and install the delivery FB

Well thats it for now about the lesson

Xvid in portable Player

2010-03-22T01:19:00.002-07:00

Hii yoo, its been year since i publish this blogs.

Today is 5 oct 2009,

Here's a new tips for you, if you want to play a movie on your dvd with avi format.
Then u can convert the movie to avi - xvid, its the best way and simple way to play a movie on your dvd machine. With 1 dvd u can put 3 to 20 movie.

Ubuntu 8.10 Error

2010-03-22T01:19:00.001-07:00

I'm using Ubuntu and today i got error :
E: problem parsing dependency recommend.
E: Error occurred while processing libgdl-1-0 (NewVersion1),
E: Problem with MergeList /var/lib/dpkg/status,
E: The package lists or status file could not be parsed or opened.

I cant update my ubuntu or opening synaptic package manager and cannot run aptitude in terminal too.

And i got fix the problem by running this on the terminal :
dpkg --configure -a

thx to mikeyphi ( its a nickname ) (http://ubuntuforums.org/showthread.php?t=1272307)

How to Move Old HDD with OS to new PC

2010-03-22T01:18:00.000-07:00

How to move an old HDD with OS ( Windows base ) to new PC

1. Start you pc with your old HDD
2. Open Device Manager and open IDE ATA/ATAPI controllers
3. Extended and choose beside primary and secondary IDE Channel
4. Right click and update driver
5. select manually to Standard dual channel PCI IDE controller.
6. Reboot/Restart and shutdown
7. Put your old HDD to your new PC and congrats...its your old HDD with windows on ur new pc.

Thx to anonymous