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?