iReport - Excel Utility for Mainframes

iReport Excel Tool - Mainframe joblog report generator:(Free Download, scroll to find)
I have been working on IBM Mainframes since 2 years now. There are many things which we feel is quite repetitive and sometimes tedious to do in our day to day work.

So i started building an Excel utility using VBA which could address these problems and could possibly simplify the piece of work. To start with, JOBLOG scan for failed jobs is the one which i felt is repetitive - Now here was the simple solution using an excel tool for mainframes job scan - iReport ('i' means LIVE in iReport).

iReport Tool is a simple tool for mainframes which will scan the job spool in joblogs and then it will generate an excel report. The report will say if there are/is any delays in scanned job(s) or if there are job(s) failure(s).

There are many features built into this tool, a few which i would like to quote is :-
1. An easy to use excel utility.
2.Takes few minutes for the entire job scan.
3.Generate the report and on a click of a button sends the report to the intended mail recipients.
4.Automated, Efficient and Easy to maintain excel tool for mainframes.
5.Delay information, CPU time consumption and many more info on screen at your fingertips.

This is my first excel tool for mainframes, so i wanted to see if i get any response from you people...
-------------------------------------------------------------------------------------------------------
FREE DOWNLOAD: Please mail to: neoprajwal@gmail.com to get this tool for free.
(The tool will be sent within 5 minutes to your email)
-------------------------------------------------------------------------------------------------------
iReport Tool for Mainframes Screenshots:

--------------------------------------------------------------------------------------------
FREE DOWNLOAD: Please mail to: neoprajwal@gmail.com to get this tool for free.
(The tool will be sent within 5 minutes to your email)
--------------------------------------------------------------------------------------------

Prajwal Shetty D
Aikosigns

FREE Julian Date Converter

At times converting a date to julian format becomes a irritating task, so i decided to create a simple converter using Excel VBA.

Download the free PS Multi Utility Julian Date Converter here: CLICK HERE TO DOWNLOAD

Prajwal Shetty D
AIKOSIGNS

Teachings of Life

Written by a 90 year old... This is something we should all read at least once a week!!!!! Make sure you read to the end!!!!!! Written by Regina Brett, 90 years old, of the Plain Dealer, Cleveland, Ohio. "To celebrate growing older, I once wrote the 45 lessons life taught me. It is the most requested column I've ever written. My odometer rolled over to 90 in August, so here is the column once more: Life isn't fair, but it's still good. When in doubt, just take the next small step. Life is too short to waste time hating anyone. Your job won't take care of you when you are sick. Your friends and parents will. Stay in touch. Pay off your credit cards every month. You don't have to win every argument. Agree to disagree. Cry with someone. It's more healing than crying alone. It's OK to get angry with God. He can take it. Save for retirement starting with your first paycheck. When it comes to chocolate, resistance is futile. Make peace with your past so it won't screw up the present. It's OK to let your children see you cry. Don't compare your life to others. You have no idea what their journey is all about. If a relationship has to be a secret, you shouldn't be in it. Everything can change in the blink of an eye. But don't worry; God never blinks. Take a deep breath. It calms the mind. Get rid of anything that isn't useful, beautiful or joyful. Whatever doesn't kill you really does make you stronger. It's never too late to have a happy childhood. But the second one is up to you and no one else. When it comes to going after what you love in life, don't take no for an answer. Burn the candles, use the nice sheets, wear the fancy lingerie. Don't save it for a special occasion. Today is special. Over prepare, then go with the flow. Be eccentric now. Don't wait for old age to wear purple. The most important sex organ is the brain. No one is in charge of your happiness but you. Frame every so-called disaster with these words 'In five years, will this matter?' Always choose life. Forgive everyone everything. What other people think of you is none of your business. Time heals almost everything. Give time time. However good or bad a situation is, it will change. Don't take yourself so seriously. No one else does. Believe in miracles. God loves you because of who God is, not because of anything you did or didn't do. Don't audit life. Show up and make the most of it now. Growing old beats the alternative -- dying young. Your children get only one childhood. All that truly matters in the end is that you loved. Get outside every day. Miracles are waiting everywhere. If we all threw our problems in a pile and saw everyone else's, we'd grab ours back. Envy is a waste of time. You already have all you need. The best is yet to come... No matter how you feel, get up, dress up and show up.   Life isn't tied with a bow, but it's still a gift.

A new angle to look for - Must read!

May be an angle that we have not understood at all.

A teacher teaching Maths to seven-year-old Arnav asked him, “If I give you one apple and one apple and one apple, how many apples will you have?”

With a few seconds Arnav replied confidently, “Four!” The dismayed teacher was expecting an effortless correct answer (three). She was disappointed. “May be the child did not listen properly,” she thought. She repeated, “Arnav, listen carefully. It is very simple. You will be able to do it right if you listen carefully. If I give you one apple and one apple and one apple, how many apples will you have?”

Arnav had seen the disappointment on his teacher’s face. He calculated again on his fingers. But within him he was also searching for the answer that will make his teacher happy. This time hesitatingly he replied, “Four...”   The disappointment stayed on teacher’s face. She remembered Arnav loves strawberries. She thought maybe he doesn’t like apples and that is making him lose focus. This time with exaggerated excitement and twinkling eyes she asked, “If I give you one strawberry and one strawberry and one strawberry, then how many will Arnav have?”  Seeing the teacher happy, young Arnav calculated on his fingers again. There was no pressure on him, but a little on the teacher. She wanted her new approach to succeed. With a hesitating smile young Arnav enquired, “Three?”

The teacher now had a victorious smile. Her approach had succeeded. She wanted to congratulate herself. But one last thing remained. Once again she asked him, “Now if I give you one apple and one apple and one more apple how many will you have?” Promptly Arnav answered, “Four!”

The teacher was aghast. “How Arnav, how?” she demanded in a little stern and irritated voice. In a voice that was low hesitating young Arnav replied, “Because I already have one apple in my bag.”

Moral of the story:

When someone gives us an answer that is different from what we are expecting, not necessarily they are wrong. There may be an angle that we have not understood at all.

Whatever we receive is INFORMATION. Whatever we preserve is KNOWLEDGE. Whatever we use is WISDOM. And HOW & WHEN we use it our INTELLIGENCE.

Interesting & Beautiful Facts of India

The most interesting and 'proud feel' facts and history about India:

• India never invaded any country in her last 100000 years of history.
• When many cultures were only nomadic forest dwellers over 5000 years ago, Indians established Harappan culture in Sindhu Valley (Indus Valley Civilization)
• The name 'India' is derived from the River Indus, the valleys around which were the home of the early settlers. The Aryan worshippers referred to the river Indus as the Sindhu.
• The Persian invaders converted it into Hindu. The name 'Hindustan' combines Sindhu and Hindu and thus refers to the land of the Hindus.
• Chess was invented in India.
• Algebra, Trigonometry and Calculus are studies, which originated in India.
• The 'Place Value System' and the 'Decimal System' were developed in India in 100 B.C.
• The World's First Granite Temple is the Brihadeswara Temple at Tanjavur, Tamil Nadu. The shikhara of the temple is made from a single 80-tonne piece of granite. This magnificent temple was built in just five years, (between 1004 AD and 1009 AD) during the reign of Rajaraja Chola.
• India is the largest democracy in the world, the 7^th largest Country in the world, and one of the most ancient civilizations.
• The game of Snakes & Ladders was created by the 13th century poet saint Gyandev. It was originally called 'Mokshapat'. The ladders in the game represented virtues and the snakes indicated vices. The game was played with cowrie shells and dices. In time, the game underwent several modifications, but its meaning remained the same, i.e. good deeds take people to heaven and evil to a cycle of re-births.
• The world's highest cricket ground is in Chail, Himachal Pradesh. Built in 1893 after leveling a hilltop, this cricket pitch is 2444 meters above sea level.
• India has the largest number of Post Offices in the world.
• The largest employer in India is the Indian Railways, employing over a million people.
• The world's first university was established in Takshila in 700 BC. More than 10,500 students from all over the world studied more than 60 subjects. The University of Nalanda built in the 4th century was one of the greatest achievements of ancient India in the field of education.
• Ayurveda is the earliest school of medicine known to mankind. The Father of Medicine, Charaka, consolidated Ayurveda 2500 years ago.
• India was one of the richest countries till the time of British rule in the early 17th Century. Christopher Columbus, attracted by India's wealth, had come looking for a sea route to India when he discovered America by mistake.
• The Art of Navigation & Navigating was born in the river Sindh over 6000 years ago. The very word Navigation is derived from the Sanskrit word 'NAVGATIH'. The word navy is also derived from the Sanskrit word 'Nou'.
• Bhaskaracharya rightly calculated the time taken by the earth to orbit the Sun hundreds of years before the astronomer Smart. According to his calculation, the time taken by the Earth to orbit the Sun was 365.258756484 days.
• The value of "pi" was first calculated by the Indian Mathematician Budhayana, and he explained the concept of what is known as the Pythagorean Theorem. He discovered this in the 6th century, long before the European mathematicians.
• Algebra, Trigonometry and Calculus also originated in India.Quadratic Equations were used by Sridharacharya in the 11th century. The largest numbers the Greeks and the Romans used were 106 whereas Hindus used numbers as big as 10*53 (i.e. 10 to the power of 53) with specific names as early as 5000 B.C.during the Vedic period.Even today, the largest used number is Terra: 10*12(10 to the power of 12).
• Until 1896, India was the only source of diamonds in the world
  (Source: Gemological Institute of America).
• The Baily Bridge is the highest bridge in the world. It is located in the Ladakh valley between the Dras and Suru rivers in the Himalayan mountains. It was built by the Indian Army in August 1982.
• Sushruta is regarded as the Father of Surgery. Over2600 years ago Sushrata & his team conducted complicated surgeries like cataract, artificial limbs, cesareans, fractures, urinary stones, plastic surgery and brain surgeries.
• Usage of anaesthesia was well known in ancient Indian medicine. Detailed knowledge of anatomy, embryology, digestion, metabolism,physiology, etiology, genetics and immunity is also found in many ancient Indian texts.
• India exports software to 90 countries.
• The four religions born in India - Hinduism, Buddhism, Jainism, and Sikhism, are followed by 25% of the world's population.
• Jainism and Buddhism were founded in India in 600 B.C. and 500 B.C. respectively.
• Islam is India's and the world's second largest religion.
• There are 300,000 active mosques in India, more than in any other country, including the Muslim world.
• The oldest European church and synagogue in India are in the city of Cochin. They were built in 1503 and 1568 respectively.
• Jews and Christians have lived continuously in India since 200 B.C. and 52 A.D. respectively
• The largest religious building in the world is Angkor Wat, a Hindu Temple in Cambodia built at the end of the 11th century.
• The Vishnu Temple in the city of Tirupathi built in the 10th century, is the world's largest religious pilgrimage destination. Larger than either Rome or Mecca, an average of 30,000 visitors donate $6 million (US) to the temple everyday.
• Sikhism originated in the Holy city of Amritsar in Punjab. Famous for housing the Golden Temple, the city was founded in 1577.
• Varanasi, also known as Benaras, was called "the Ancient City" when Lord Buddha visited it in 500 B.C., and is the oldest, continuously inhabited city in the world today.
• India provides safety for more than 300,000 refugees originally from Sri Lanka, Tibet, Bhutan, Afghanistan and Bangladesh, who escaped to flee religious and political persecution.
• His Holiness, the Dalai Lama, the exiled spiritual leader of Tibetan Buddhists, runs his government in exile from Dharmashala in northern India.
• Martial Arts were first created in India, and later spread to Asia by Buddhist missionaries.
• Yoga has its origins in India and has existed for over 5,000 years. 

Be a proud Indian, Love your country for what it was...
  


Prajwal Shetty D
AIKOSIGNS