Search This Blog

Sunday, September 11, 2011

Tuesday, August 30, 2011

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 ? =(

Monday, August 29, 2011

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
 


Sunday, August 28, 2011

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.




Saturday, August 27, 2011

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.