iphone vs Android: which group do you belong ?

I am waiting for iphone 5. Is it worth waiting for ? @__@

"Sorry, the import failed due to a server error. The error code is bX-izedxv".

You received the above error message when trying to export your Wordpress .xml file into Blogger/Blogspot.

Pathetic Page Views

This week's page view :

 

Only 24 page views in total this week (as at 30 Aug 2011).

How pathetic is that.

Should I continue this blog ? =(

How to link data in 2 excel files and combine them into 1 using macro?

FILE 1
data: Column A, B and C

FILE 2
data: Column A, and D

Use FILE 1 as the primary file.

Final Result: should have A , B C and D together in 1 spreadsheet.

Problem : Look up function but seems like it doesn't work well. the data is jumble up. I still to check using True false function. cos what is avai in A may not be found in B. 


Pri file has more information ( in terms of number of names ) than file 2.
name      data1       data2      data3

and in file 2:
name      data1       data2      data3  data4 

Macro - ADD 3 rows & UNDO Macro to undo the addition of 3 rows

To do the following :

a) ADD 3 Rows
 (or even more rows) by prompting user to enter the number of rows they wish to insert.


b) UNDO MACRO:

1. Undo the addition/insertion of rows 

2. when click, it will also prompt: "Do you want to undo adding 3 rows ?" 
> Yes | Cancel
if Yes, macro proceed and if Cancel , macro will not run and remain.

Mathematical Expectation

Question 4.53

Suppose that a grocery store purchases 5 cartons of skim milk at the wholesale price of $1.20 per carton and retails the milk at $1.65 per carton After the expiration date, the unsold milk is removed from the shelf and the grocer receives a credit from the distributor equal to 3/4 of the wholesale price. If the probability distribution of the random variable X, the number of cartons that are sold from this lot is:

x	1	2	3	4	5
f(x)	1/15	2/15	3/15	4/15	5/15

Find the Expected Profit.

Enriching Vocabulary 1

Words beginning with au~:

1. audacious - daring; often to a degree that is considered foolish.
It was audacious of the student to talk back to his principal, especially when he was clearly in the wrong.


2. augment - to cause to become bigger, better, more valuable
To augment the income of the family, he took up several part-time jobs.

3. augur - to  be a sign of something in the future
The lack of lustre in the  stars does not augur well for his fortunes.

4. aura - an effect/feeling that seems to surround / come from a person/place
There was a strangely mysterious aura exuding from the ancient museum.

5. auspices - help, support and favour
This concert was held successfully only because of the auspices of the various organisations.

6. austere - plain, without comfort/enjoyment.

The monks are used to an austere life in the mountains.

7. authentic - genuine
The expert judged this to be an authentic piece of work.


8. auxiliary - providing additonal help/support, especially with lower rank or of less importance.
Auxiliary nurses were called in to cope with the sudden emergencies in the hospital.

9. auburn - reddish-brown
My sister has a nice auburn hair.

10. auspicious - giving, promising or showing signs of future success
The Chinese believe red to be an auspicious colour.

Create a macro to convert multiple .txt file and place all data from text to .xls file

1. Convert multiple .txt files in a folder
2. Delimit the .txt files so that there are headers in each column
3. Format for date (1st column) should be in DD-MM-YY format
4. Place all data from .txt files into 1 .xls file
5. Scan through the data in .xls file
6. Ensure all data are unique (ie. no repeated data in each row)

Error in Renaming Folder in Windows Explorer

Rename a folder but the error states :

Cannot rename ____ : Access is denied.
Make sure the disk is not full or write-protected and that the file is not currently in use.

However, owner is under my name and I have full rights to the folder.
The files in the folder are not even opened.

How ? 

Comparing sets of data (lower and upper limit)

Data set:
0.5, 1.5, 2.1, 0.43, 0.35

condition/base number : 1

Result needed:
To select number nearest to 1 ie.= 0.5 by using macro.

Note: Although 1.5 is also near to 1 (also a 0.5 difference), it must choose the smaller number.
(0.5 is smaller as compared to 1.5) 

Random Variables and Probability Distribution

Question 3.32

The proportion of the budgets for a certain type of industrial company that is allocated to environmental and pollution control is coming under scrutiny. A data collection project determines that the distribution of these proportions is given by:

f (y) = 5 (1-y)^4,  0<=y<=1
          0, elsewhere

a) Verify that the above is a valid density
b) What is the probability that a company chosen at random expends less than 10% of its budget on environmental and pollution controls ?
c) What is the probability that a company selected at random spends more than 50% on environmental and pollution control ?

How do I extract selected text from a string of text?

Data in a cell and need to extract part of it :


Examples:
1. AERO 030405A AUTO 24567AZ 99AM  > Extract 67
2. AERO 030405Z AUTO 25611C22AZ 99BM >  Extract 11 

AS400 / DB2 Programming Tutorial Guide

My favourite guides are :

Tutorial for AS400
http://www.texas400.com/tutas400toc.html


Tutorial/book on DB2
http://publib.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/CCONTENTS

Let me know if you have more to share. 
I am still learning -__-

Probability

Question 2.26

A California study concluded that by following 7 simple health rules a man's life can be extended by 11 years n the average and a woman's life by 7 years. These 7 rules are as follows: no smoking, regular exercise, use alcohol moderately, get 7-8 hours of sleep, maintain proper weight, eat breakfast, and do not eat between meals. In how many ways can a person adopt five of these rules to follow
a) If the person presently violates all 7 rules?
b) If the person never drinks and always eats breakfast?

Why are my database files (.dbf) updated but not the cubes (.mdc) ?

Answer: The cubes are not run/downloaded properly.

(assuming you have scripts to run the cubes)
Double check if the date of the cubes is as at current.
Else do the following :
To click and run the script again - manually
How to run manual:
1. Cognos Powerplay Transformer
2. Open "...... .pyi" (Usually the name is the same as the one in .mdc, just that you have to open the corresponding .pyi file)
3. Click on the cube icon to run the cube.
OR 
If you have scheduled a task to run the script automatically (which will run the cubes), then you might also wish to wait for the next update (depending on your scheduler: Control Panel > Scheduled Tasks) and then check if the cubes are now updated.

Problem logging into windows XP (no password-safemode, blue screen persist)

1)
Try to log into the safe mode and do what was explained/advised in :
http://answers.yahoo.com/question/index?qid=20070409184255AAuAqLp

However, there is no open box for me to type in the passwords in the windows xp blue welcome screen in safe mode.

So i tried ctrl-alt-del and then a dialog box appears with username and password.
Username : administrator
password : control userpasswords2

But the above password doe snot work.
 
 2)
Tried administrator / (password leave blank) , administrator/administrator, etc all kinds of generic combination, but still doesn't log on.

It still goes back to safe mode with 2 avastar showing - 1 for administrator and 1 for user, without any open white box to type in your password. and when clicked on the administrator avastar, it shows "loading personal settings" ...."saving your settings" and then back to original position. --- (a)

And then, if clicked on the user avastar, it will show "logging off....loading personal settings...saving your settings.." and then back to the original position. ---(b)

Previously, prior to logging into safe mode,  scenario (b) happens.
so I tried to copy userinit.exe file from another PC, rename the file to wsaudaptor.exe and then copy this file into the systems32 folder. however, it doesn't solve the problem either.

How to delete unwanted columns via macro for data analysis

1. Place 'X' in Row 2 in whichever columns you would like to delete.

2. Paste the following macro in Module.
(Insert > Module)

Sub del_columns()
Dim ws As Worksheet
Dim lastcolm As Long
Dim i As Long
For Each ws In Worksheets
With ws
lastcolm = .Cells(2, .Cells.Columns.Count).End(xlToLeft).Column
For i = lastcolm To 1 Step -1
If UCase(.Cells(2, i)) = "X" Then
.Columns(i).Delete
End If
Next i
End With
Next ws
End Sub

3. Press Alt+F8.

4. Click Run .

Error in removing adobe illustrator (trial version)

How to remove adobe illustrator CS3 components after installing the downloaded trial version ?
It states "User cancelled payload installation"

Clearing information in PC

How do I delete the historical information (besides deleting cookies, IE history , empty recycle bin) to ensure that my personal information / privacy is protected ?

Besides re-formatting the hard disk, are there any other ways ?

Why can't I open my Cognos impromptu report ?

1. You have not opened the right catalog. > Close the report and the catalog. Open the catalog and make sure the right catalog is selected. Then open the report again.
2. The catalog is corrupted. > Re-do the catalog; check if there is any other catalog that you can use; check if you have a backup.
3. The catalog is at a different location. > See 1.