Excel Function to Convert Rupees in Figure to Rupees in Word

Excel Function to Convert Rupees in Figure to Rupees in Word

How to create the sample function Called SpellNumber

1. Start Microsoft Excel.
2. Enable the macro security setting
3. Press ALT+F11 to start the Visual Basic Editor.   or   Right Click on Sheet tab and click "view code" option, visual basic editor will open
4. On the Insert menu, click Module.
5. Type the following code into the module sheet. or copy and past the following codes.

Codes,

Function SpellNumber(amt As Variant) As Variant

Dim FIGURE As Variant

Dim LENFIG As Integer

Dim i As Integer

Dim WORDs(19) As String

Dim tens(9) As String

WORDs(1) = "One"

WORDs(2) = "Two"

WORDs(3) = "Three"

WORDs(4) = "Four"

WORDs(5) = "Five"

WORDs(6) = "Six"

WORDs(7) = "Seven"

WORDs(8) = "Eight"

WORDs(9) = "Nine"

WORDs(10) = "Ten"

WORDs(11) = "Eleven"

WORDs(12) = "Twelve"

WORDs(13) = "Thirteen"

WORDs(14) = "Fourteen"

WORDs(15) = "Fifteen"

WORDs(16) = "Sixteen"

WORDs(17) = "Seventeen"

WORDs(18) = "Eighteen"

WORDs(19) = "Nineteen"

tens(2) = "Twenty"

tens(3) = "Thirty"

tens(4) = "Fourty"

tens(5) = "Fifty"

tens(6) = "Sixty"

tens(7) = "Seventy"

tens(8) = "Eighty"

tens(9) = "Ninety"

FIGURE = amt

FIGURE = Format(FIGURE, "FIXED")

FIGLEN = Len(FIGURE)

If FIGLEN < 12 Then

FIGURE = Space(12 - FIGLEN) & FIGURE

End If

If Val(Left(FIGURE, 9)) > 1 Then

SpellNumber = "Rupees "

ElseIf Val(Left(FIGURE, 9)) = 1 Then

SpellNumber = "Rupee "

End If

For i = 1 To 3

If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then

SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))

ElseIf Val(Left(FIGURE, 2)) > 19 Then

SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))

SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))

End If

If i = 1 And Val(Left(FIGURE, 2)) > 0 Then

SpellNumber = SpellNumber & " Crore "

ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then

SpellNumber = SpellNumber & " Lakh "

ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then

SpellNumber = SpellNumber & " Thousand "

End If

FIGURE = Mid(FIGURE, 3)

Next i

If Val(Left(FIGURE, 1)) > 0 Then

SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " Hundred "

End If

FIGURE = Mid(FIGURE, 2)

If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then

SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))

ElseIf Val(Left(FIGURE, 2)) > 19 Then

SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))

SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))

End If

FIGURE = Mid(FIGURE, 4)

If Val(FIGURE) > 0 Then

SpellNumber = SpellNumber & " Paise "

If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then

SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))

ElseIf Val(Left(FIGURE, 2)) > 19 Then

SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))

SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))

End If

End If

FIGURE = amt

FIGURE = Format(FIGURE, "FIXED")

If Val(FIGURE) > 0 Then

SpellNumber = SpellNumber & " Only "

End If

End Function,

To download codes in *.txt format click : https://goo.gl/LZWtnP

For more details and how to use please click below link (video tutorial) 

Anti-lock braking system or Anti-skid braking system (ABS)

An anti-lock braking system or anti-skid braking system (ABS) is an automobile safety system that allows the wheels on a motor vehicle, to maintain tractive contact with the road surface according to driver inputs while braking,

Preventing the wheels from locking up (ceasing rotation) and avoiding uncontrolled skidding. It is an automated system that uses the principles of threshold braking and cadence braking which were practiced by skillful drivers with previous generation braking systems. It does this at a much faster rate and with better control than many drivers could manage.

ABS generally offers improved vehicle control and decreases stopping distances on dry and slippery surfaces; however, on loose gravel or snow-covered surfaces, ABS can significantly increase braking distance, although still improving vehicle steering control.

Since initial widespread use in production cars, anti-lock braking systems have been improved considerably. Recent versions not only prevent wheel lock under braking, but also electronically control the front-to-rear brake bias. This function, depending on its specific capabilities and implementation, is known as electronic brake force distribution (EBD), traction control system, emergency brake assist, or electronic stability control (ESC).

To subscribe this channel --- https://goo.gl/gbazg2

How to Reduce .PDF file size | Compress PDF file size Less then 1 Mb | -- ONLINE

This videos shows how to reduce or compress PDF file size online.

Easy to use

Just drag-and-drop your PDF file in the box, wait for the compression to complete and download your file

 

Perfect quality

Reduce your scanned PDF files to 144dpi which is perfect for uploading files to the web and through email

Security guaranteed

Your files will be permanently deleted from our server after one hour. No one has access to your files and privacy is 100% guaranteed.

How to Reduce .PDF file size | Compress PDF file size Less then 1 Mb | - OFFLINE

This videos shows how to reduce or compress PDF file size OFFLINE, using Adobe Acrobat Professional 6 and Above.

Adobe Pro 6 : Choose your document and open it. You should see your PDF on the screen, go to file menu and select reduce file size and save

Adobe 10 & Above : Go to File  - Save As Other - Choose Reduced Size PDF, Another box will appear, asking what versions of Adobe Acrobat you’d like to make your file compatible with, Note: the later the version, the smaller you can make your file.

TNPSC Exam General Knowledge (GK) Q&A – Audio Part IV [பொது அறிவு வினா விடை - பகுதி IV]

For TNPSC Exam General Knowledge (GK) Q&A – Audio Part IV [பொது அறிவு வினா விடை - பகுதி IV]
Watch the above video

Security Update | How to prevent your computer (PC) from Wanna Cry Ransomware.

Wanna Cry Ransomware Guidelines to stay safe :

• Be careful to click on harmful links in your emails.
• Be wary of visiting unsafe or unreliable sites.
• Never click on a link that you do not trust on a web page or access to Facebook or messaging applications such as WatSab and other applications.
• If you receive a message from your friend with a link, ask him before opening the link to confirm, (infected machines send random messages with links).
• Keep your files backed up regularly and periodically.
• Be aware of fraudulent e-mail messages that use names similar to popular services such as PayePal instead of PayPal or use popular service names without commas or excessive characters.
• Use anti virus and Always make have the last update.
• Make sure your windows have the last update close the gap.

Update 5/15/2017 : 

The entry of the virus to your device, which is dependent on a gap in the Windows system and the gap is present in all types of Windows is that the feature is open.

if you did no't update your windows just turn off SMP,

There are two methods to turn off SMP manually or Tools . 

Manual update procedure

https://goo.gl/VWu0Pc 

Vehicle Classification (M1 & N1), Sedan, SUV, Station wagon, Hatchbacks, etc..

Vehicle Classification

Category of vehicle as per IS 14272 : 2011

M :   A motor vehicle with at least four wheels used for carrying passengers

M1 : A vehicle used for carriage of passengers, comprising not more than eight seats in addition to the driver’s seat

M2 : A vehicle used for carriage of passengers, comprising nine or more seats in addition to the driver’s seat, and having a maximum GVW not exceeding 5 t

M3 : A vehicle used for the carriage of passengers, comprising nine or more seats in addition to the driver’s seat and having a GVW exceeding 5 t

N : A motor vehicle with at least four wheels used for carrying goods. These vehicles can carry persons in addition to the goods subject to the conditions

N1 : A vehicle used for carriage of goods and having GVW not exceeding 3.5 t
N2 : A vehicle used for the carriage of goods and having a GVW exceeding 3.5 t but not exceeding 12 t

N3 : A vehicle used for the carriage of goods and having GVW exceeding 12 t

G : Off Road Vehicles (Cross Country Vehicles) — Symbol ‘G’ A vehicle of category M or N satisfying the requirements given

• N1 with GVW not exceeding 2 t and 
• M1 Vehicles in category N1 with GVW not exceeding 2 t and vehicles in category M1 are considered to be off road vehicles, if they have followings 
• Have at least one front axle and at least one rear axle designed to be driven simultaneously
• Shall be capable of climbing a 30 present gradient with vehicle in the solo condition
• Have at least one differential locking mechanism or at least one mechanism having similar effect

Micro car

• Micro cars are usually designed and produced for economic purposes
• Less than 3 meters in length and less than 85 cubic feet/2400 litre interior vol.
• Earlier engine capacity were under 1.0 litre
• A small car with very small engines being treated as motor cycles
• Advantage in easy of parking

Sedan (Saloon)

• Type of car design consists of engine compartment, passenger compartment and a separate boot
• A sedan posses fixed roof with fixed B pillar which seats four or more
• Accommodation — 4 or more seats in at least 2 rows
• Most commonly it is a four-door; two-door models are rare

Hatchbacks

• Saloon with a hatch at the rear end of the vehicle.
• An automobile design, consisting of a passenger cabin with an integrated cargo space, accessed from behind the vehicle by a tailgate
• Opening rear tail gate
• The interior design include fold down rear seats, which can be used as a cargo area.
• The rear seat can be folded partially (for instance 1/2, 1/3 or 2/3) or completely to expand the cargo space.

Notchbacks - Sedan

• A Notchback sedan is a three-box sedan, where the passenger volume is very distinct from the trunk volume of the vehicle.
• The roof is on one plane, generally parallel to the ground, the rear window (taillight) at a sharp angle to the roof, and the trunk lid is also parallel to the ground. 

Fastbacks - Sedan

• A fastback sedan is a two-box sedan, with continuous slope from the roof to the base of the deck lid, but excludes the hatch back feature
• Typically this design is chosen for its aero dynamic advantages. Auto makers can no longer afford the penalty in fuel consumption produced by the traditional notchback three box form

Coupe

• While hard tops (without the pillar, and often incorporating a sloping back light) are called coupes
• Body — Closed. Usually, limited rear volume
• Coupe was an enclosed two-seater mainly used in towns and was driven by a coachman.
• Coupes generally two doors, but not necessarily, have two doors, although automobile makers have offered four-door coupes and three doors hatchback coupes, as well.

Convertibles

• Vehicles whose roofs may be showed or who side windows may be completely lowered
• It was activated by pneumatic cylinders, 
• The trunk lid of the convertible should be altered from its parent model
• Space required for stowing the top, because the removal of the roof leads to a significant loss of rigidity
• Need for high static and dynamic stiffness

Station Wagon

• Body — Closed. Rear shape is designed in order to give a larger interior volume
• Body style similar to a sedan but with an extended rear cargo area.
• Station wagons are based on sedan platform, having the main interior area extended to the near-vertical rear window

How Station Wagon Differ From Hatchback?

• A hatchback car would not enjoy the full height of the passenger cabin all the way to the back
• Rear glass of a hatchback being sloped further from vertical, and the hatch tending not to reach fully to the rear bumper, as it commonly would in a station wagon.
• Station wagons also have side windows over the cargo area, where as some hatchbacks have thick C pillars and no cargo area windows.
• 
  

Sport utility vehicle (SUV)

•        An SUV is a passenger vehicle, similar to a station wagon, usually equipped with four-wheel drive for on- or off-road ability, which combines the towing capacity of a pickup truck with the passenger-carrying space of a sedan.
•       They have a power full engine, have sufficient passenger space along with luggage compartment behind the rear row seats and are designed for all terrains.
•       They are non commercial vehicles with the BIW built on the chassis similar to a light truck or a crew cab
•       An off roader needs a long hood and an upright position. That lends the vehicle self- assuredness and power

Ladder Chassis or Body on Frame &

Monocoque or Unibody