How to use the Calclated coloumns at MOSS list

ok, just have learn new some litter knowledge at MOSS list then want to document it so just document it at here to share.

example you have one list as below:

Number in rom (for user to edit)	Number in English (this is calculated type column)
1	One
2	Two
3	Three

what you need to do is just create the column at the list with name Number in english, type in the formula as below:
=IF([Number in rom]="1","One",IF([Number in rom]="2","Two"), IF([Number in rom]="3","Three"))

Done!!

so user every time edit the data at Number in rom , the second column will auto change.

some usefull resouce about MOSS video traning

this is one of the example for enable Excel services :

http://tw.youtube.com/watch?v=fVG9UTag_cE&feature=related

Groove installation problem with not Defualt SQL instance

i have facing some problem during installtion Groove server 2007, the main reasons is my SQL server instance is not using local instance and the SQL server have installed SQL2000 and SQL2005.

you have 2 solution for this problem, one is setup the SQL2000 with local instance name in standalone server (not mixed with SQL2005)

second solution is change the alias name from web front end server to simple name , try not to sue the special character. (hi hi, try in error with the alias name)

these is what i have do for my lab installation.