Converting CSV files to Excel and Formatting using Excel VBA

Requirements:

1. A Spot Billing Machine which records Monthly Gas Usage in an area downloads the data in CSV files.

Numbers - Solved Examples

Examples

Example 1. Find the largest number which divides 238, 358 and 418 leaving the same remainder in each case.
(A) 60      (B) 120      (C) 45      (D) 90

Numbers - Important Formulae

Important Formulae

1. Prime Numbers - A number which doesn't have any factor apart from one and itself. Ex: 2,3,5, etc.

• Every prime number greater than 3 can be written in the form of (6k + 1) or (6k - 1) where k is an integer.
• To find a number N as prime number or not, let k be the smallest number such that k² ≥ N. Now, test whether N is divisible by any of the prime numbers less than or equal to k.

Percentages, Profile & Loss, Partnerships

Important Formulae

1. Percentage Increase = (Actual Increase / Original Quantity) X 100

    Percentage Decrease = (Actual Decrease / Original Quantity) X 100

Ratio, Proportion & Variation

Important Formulae:

1. If we add a positive integer (x) to both terms of the ratio, we have the following results:

• If a < b then      (a+x) : (b+x) > a : b
• If a > b then      (a+x) : (b+x) < a : b
• If a = b then      (a+x) : (b+x) = a : b

2. If two quantities are in the ratio a : b, then the first quantity will be a / (a+b) times the total of the two quantities and the second quantity will be b / (a+b) times the total of the two quantities.

Create Personal Expense Tracker using basic Excel features

Expense Tracking helps you to write down what you spend and later analyse your spending habits to make decisions to spend your hard earned money more wisely. There are various spreadsheets, apps or software programs for tracking your expenses. But using your own created spreadsheet enhances your enthusiasm to enter the expenses regularly. Besides creating an expense tracker, you can learn few basic concepts of a powerful tool - Excel, which can help to make your life better in performing calculation, analysis and visualisation of data and information.