Search

Two of 51 Macros from this book are given below: Macros to Encode and Decode the Sheet [Please check both the Macros by copying into VB Editor of Any Excel file. Then RUN the Macro.] Sub Encode_the_Sheet_Selected_Rows_N_Columns() On Error GoTo ERR Dim S1, S2 As Variant Dim change(20), CHANGE2(20), l, M As Integer Dim ic, lc, ir, lr, hello, J, k As Long For I = 1 To 20 If I < 11 Then change(I - 1) = I * I CHANGE2(I - 1) = I * 4 Else change(I - 1) = I * 3 CHANGE2(I - 1) = I * 2 End If Next ic = Int(InputBox("Enter begining Column No from where you want to Encode the Data.")) If ic < 1 Or ic = Empty Then ic = 1 lc = Int(InputBox("Enter Last Column No upto where you want to Encode the Data.")) If lc < ic Or lc = Empty Then hello = lc lc = ic ic = hello End If ir = Int(InputBox("Enter begining Row No from where you want to Encode the Data.")) If ir < 1 Or ir = Empty Then ir = 1 lr = Int(InputBox("Enter Last Row No upto where you want to Encode the Data.")) If lr < ir Or lr = Empty Then hello = lr lr = ir ir = hello End If M = 0 For J = ir To lr For k = ic To lc S1 = "" S1 = """" & Sheets("Sheet1").Cells(J, k).NumberFormat & """" S1 = S1 & Sheets("Sheet1").Cells(J, k).Value Sheets("Sheet1").Cells(J, k).NumberFormat = "General" S2 = """" l = 0 For I = 1 To Len(S1) S2 = S2 & Chr(Asc(Mid(S1, I, 1)) + change(l) + CHANGE2(M)) l = l + 1 If l > 19 Then l = 0 Next M = M + 1 If M > 19 Then M = 0 Sheets("Sheet1").Cells(J, k).Value = S2 Next Next Exit Sub ERR: MsgBox ERR.Number & " " & ERR.Description End Sub Sub Decode_the_Sheet_Selected_Rows_N_Columns() On Error GoTo ERR Dim S1, S2, s3 As Variant Dim change(20), CHANGE2(20), l As Integer Dim ic, lc, ir, lr, hello, J, k As Long For I = 1 To 20 If I < 11 Then change(I - 1) = I * I CHANGE2(I - 1) = I * 4 Else change(I - 1) = I * 3 CHANGE2(I - 1) = I * 2 End If Next MsgBox ("You are required to tell exact Begining and End Columns and Rows Nos. of Encoded Data.") ic = Int(InputBox("Enter begining Column No of the Encoded Data.")) If ic < 1 Or ic = Empty Then ic = 1 lc = Int(InputBox("Enter Last Column No of the Encoded Data.")) If lc < ic Or lc = Empty Then hello = lc lc = ic ic = hello End If ir = Int(InputBox("Enter begining Row No of the Encoded Data.")) If ir < 1 Or ir = Empty Then ir = 1 lr = Int(InputBox("Enter Last Row No of the Encoded Data.")) If lr < ir Or lr = Empty Then hello = lr lr = ir ir = hello End If M = 0 For J = ir To lr For k = ic To lc S1 = "" S1 = Sheets("Sheet1").Cells(J, k).Value S2 = "" l = 0 For I = 2 To Len(S1) S2 = S2 & Chr(Asc(Mid(S1, I, 1)) - (change(l) + CHANGE2(M))) l = l + 1 If l > 19 Then l = 0 Next For I = 2 To Len(S2) If Mid(S2, I, 1) = """" Then s3 = Mid(S2, 2, I - 2) S1 = Right(S2, Len(S2) - I) Exit For End If Next M = M + 1 If M > 19 Then M = 0 If Left(S2, 1) = """" And I <= Len(S2) Then Sheets("Sheet1").Cells(J, k).Value = S1 Sheets("Sheet1").Cells(J, k).Select Selection.NumberFormat = s3 End If Next Next Exit Sub ERR: MsgBox ERR.Number & " " & ERR.Description End Sub

This book contains over 1800 lines of code and easy instructions to create a Fully Functional, Advanced and AI-powered Ludo game in Microsoft excel. This book not only helps in developing Ludo game but is also a source to learn coding, logic building and Excel VBA. Students of Computer Science (class 8 onward) can benefit from this book. Professionals who use Excel will also find it helpful. Therefore, you should buy this book if you are one of them or if such professionals and students are in your family. Additionally, you ought to tell your friends and family about this book. Want to make a Ludo Game in Microsoft Excel and play with friends and computers players? You can do that very easily. You need to create a Macro Enabled Workbook (.xlsm) file in Ms Excel. Then open the Visual Basic Editor by pressing Alt + F11 or by going to the Developer tab and clicking on Visual Basic button. Double click on any sheet in the project explorer of the Visual Basic Editor, which will open the code editor of that sheet. In that code editor, type or copy and paste the complete code provided in this book. And it's just done! Now you can close the Visual Basic Editor. Return to Excel, go to the same sheet and either press Alt + F8 or click the Macros button in the Developer tab. The Excel Ludo board game will be created quickly as you run the "CREATELUDO" macro. This Excel Ludo Board Game can be played by a minimum of one player and a maximum of four players. This game can be played by computer players, by humans, or by both computer and human players together. The computer player will not leave a single chance to kill the pieces of other players. The computer player can also hit two to three pieces simultaneously. If the computer player's die numbers are 6+6+3 and one of its pieces has other players' pieces on its sixth, twelfth and fifteenth house, then the computer player will kill all the three pieces in one move. A computer player can use its various pieces to strike other players' pieces in a move. If in a move several pieces of other players are going to be killed by different pieces of the computer player, then the computer player will select those pieces and kill them which have reached closest to the destination. ActiveX buttons and other ActiveX controls are not used in this game. CREATELUDO Macro is part of the code provided in this book. If Project Explorer is not displayed in Visual Basic Editor, select Project Explorer from the View menu on the main menu. If the Developer tab is hidden then click the Office Button, click Excel Options, select Popular, check the box labelled "Show Developer tab in the Ribbon", and then click OK.

"Five Books in One!" is collection of five books. Those five books are 1- Fitoor, 2-Just for Fun, 3-The Burning Desire, 4-Truth Always Wins and 5- The Face Scratcher. The Face Scratcher is itself collection of 5 exciting & thriller short stories. So this book has total nine stories. They all are unique, entertaining and inspiring. And of course "Five Books in One!" is "FIVE BOOKS" in price of one too! Fitoor: Story of an impractical guy, who learns to become practical after mishandling some superpower. He accidentally gets able to know and manipulate others' mind, but eventually he uses it against self only. Just for Fun: Love story of a careless boy, who turns a boon into a curse and becomes a living hero ghost. The Burning Desire: Story of Love, Hate and Past Life Connections Truth Always Wins: A life-changing story of a common man Amit, who was oblivious to the fact that he was completely under the influence of unknown creatures Rakshak & Bhakshak. The Face Scratcher: Collection of five exciting & thriller short stories The Face Scratcher: The Story of kids’ fight with the mysterious killer creature Shivanand: A rebel who wanted to awaken the hero within the common man. The Truth: The story of a victim of black magic, who mastered Tantra. Antas: The story of a psychologist who was able to transform baddies into good people and whom all the villains wanted to kill at any cost. U R Mine! The story of the lizard-fearing boy Joy, who battles the dreaded ghost Buka and the super-powerful monk Chen for his love. Five Books in One! Namaskar! I am Anurag Pandey (since 1978). I am writer, author, poet, lyricist and computer programmer. My poems have been published in national newspapers and magazines of India like Navbharat Times, Kadambini etc. I have written Story/ Dialogues/ Screenplay for various TV Shows like Lady Inspector, Shaka Laka Boom Boom, Indonesian TV shows etc. At present I live in Bhubaneswar, India. Meditation, yoga, mystery, paranormal, supernatural, love, relationships are some of my favorite topics to read and write.

Fitoor is story of an impractical guy, who learns to become practical after mishandling some superpower. He accidentally gets able to know and manipulate others' mind, but eventually he uses it against self only.

Dear Friends, This book is collection of 5 short stories. They are unique, thriller and exciting. Those stories can be addressed as Science Fiction for teens, Story of Rebels, Supernatural interactions, mental emergence, paranormal activities etc. You will love the book. – Anurag Pandey Excerpts from stories: Muhnochwa (The face scratcher) Many rumors are spread in the area about Muhnochwa. Someone says Muhnochwa is a human-eater animal. Someone says Muhnochwa is a ghost or monster. Someone says he has seen Muhnochwa. Someone says he has fought with Muhnochwa. But none knows the truth that who the hell is Muhnochwa? From where does he come? And where does he go? Due to Muhnochwa, air of fear and suspiciousness is there in the village. Villagers avoid going out after Sunset. They doubt on each other whether he is Muhnochwa? Police is helpless because they still couldn’t catch Muhnochwa. Day by day villagers’ fear is increasing… But there was a person in the village who was unafraid of Muhnochwa. He was drinker Sadanand. He remains intoxicated 24 hours. In fact Sadanand is happy with Muhnochwa because due to Muhnochwa, he is getting his wine easily. If some villager has some urgent work outside in night, he sends Sadanand or takes Sadanand with him. And in back Sadanand gets wine. Thus Sadanand was taking benefit from Muhnochwa. But there were some more peoples, who were taking benefit of Muhnochwa. Like Pandit Sahiram; He was afraid of Muhnochwa, but sells ‘Muhnochwa safety amulet’ to innocent villagers. Like moneylender Dukhiram; He begins to take double interest on given loan as ‘Muhnochwa risk tax’ saying that if the person is killed by Muhnochwa, then his money will be lost. Local thug Gulathi and Lukathi begin to plunder peoples by appearing in Muhnochwa’s getup. Police station in-charge Sherkhan too begins to take benefit of Muhnochwa. Sherkhan is too much scared of Muhnochwa. Brave constable Madhaw tries to encourage him. But Sherkhan exits police station in the name of catching Muhnochwa and comes to village with Madhaw. And he starts troubling villagers by demanding chicken, mutton, wine and money saying that he will free them from Muhnochwa’s terror. Madhaw heartily wants to catch Muhnochwa. But Sherkhan doesn’t allow him to go because Muhnochwa can kill sharekhan in alone. Shivanand 10 years old boy Aditya was in the crowd at that moment. Shivanand’s words had set fire inside him too. Aditya picked a stone and hit the police officer. To see this small rebellion, smile had appeared on Shivanand’s bleeding lips. Shivanand says that he won’t commit the mistake again, what he had committed 15 years back. He will fight his battle, he will continue his mission, but this time he won’t become the hero, he will make the citizens heroes. If there is one hero, he can be ruined easily. But if all citizens become the hero, then none can defeat them. The Truth Sometimes, when he sits for meditation, he feels that something reaches on the back part of his brain by passing through his back bone from lower end and suddenly he feels a flow of some peculiar energy in to his whole body and his flowing existence towards meditation just returns back with a great frustration. Antas Till now Antas had reformed innumerous thieves, goons, loafers, pickpockets, murderers, terrorists… Till now Antas had reformed innumerous corrupt police officers, corrupt public servants and corrupt politicians… and had made them honest, dutiful and loyal to country. Antas’ hypnotism was so wonderful that if once someone comes in his clutch; it was quite impossible for him or her to return without reformation! And it was the reason that criminals, corrupt officers and corrupt politicians were scared even of Antas’ shadow! Because they were fearful that if once Antas got the chance to hypnotize them, he will reform them. And nobody wants to get reformed! U R MINE…! Joy fears from a lizard but if there is a danger on Julie, he can fight with dinosaur. He can’t go alone in darkness but for Julie he can visit the graveyard in no-moon night. He can’t face the local baddy but for Julie he can challenge mafia. Yes, he loves Julie… He keeps trying to express his love to Julie but fails. And Julie, she uses to call Joy ‘Gogo’. …Buka can’t face the power of monks. And so is with Joy. Buka says to Joy –‘I know that you want to rescue Julie from Monks because you love her. And you know that I want to rescue Julie from Monks so that I would take her to jungle and would murder her for my beloved Maya… Later you can try to rescue Julie’s life from me, but our initial mission is one –‘to rescue Julie from monks’. We can’t do it individually because being a ghost, I have limitations, and being a human, you have limitations. But if we are together, we can do it.’ Joy agrees.

"Meditative Moments" are moments beyond moments. They keep you realizing that you are eternal and infinite. They never leave you from your chase. They keep reviving themselves. They go on getting deeper and more mysterious. They start pulling you. You fail to keep yourself uninfluenced by them. Slowly you drown in them. The doors of the inner world start opening one after the other and you feel as if you are an alien on your planet Earth. I am in relationship with 'Meditative Moments' since childhood. Sitting for hours in Padmasana (Lotus posture) on the open terrace in the afternoon and playing the game of Meditation. Inviting spirits using planchette and to marvel at their actual arrival, to be effortlessly in continuous state of witnessing. Then came a period of divagation. But those moments walked with me like a shadow and embraced me again. There is no erudition in this book. If you are interested in experiences related to meditation and you want to delve deeper into those experiences, then this book is for you. It has four chapters. First chapter is about various experiences of the subtle world. How Krishna, Buddha, Jesus, Sai Baba, Goddess Dhoomavati, Vanadevi (Forest Goddess), Osho, Unknown Monk, Avadhoot Baba Sivananda etc met me in the subtle world and inspired me, helped me. Second chapter is detailed explanation of various experiences through which a spiritual practitioner undergoes while practicing meditation. For example the feeling of vastness, the pulsation in the penis, the movement of subtle bodies, the spinning and opening of the chakras, feeling the omnipresence of the consciousness, the unfolding of the past and the future, the manifestation of the inner world etc. Why and how do these experiences knock us? Which experiences are positive and which experiences are dangerous to be drowned in? How can we deepen these experiences? I have tried to put light on these factors as per my experience. Third chapter explains how we can practically use meditation for solving problems. How using meditation we can transform the future, heal physical and mental illness, understand, break and transform thought chains, purify body, mind, intellect and consciousness. And fourth chapter is about the benefits of meditation, how it improves your work skills, helps you set up your goals and so on.

Dear Friends, You may wonder, how using a book, it is possible to make game application just in an hour! Even without proper programming knowledge! I have provided a Demo Video on youtube named Demo of my Book Code & Design of VB Based Game Snake & Ladder - Anurag Pandey. Or you can Copy and Paste this on browser: https://www.youtube.com/embed/Z6u_LHi-xTM Please watch that video. And you would say, yes! Anyone with little Computer knowledge can develop his or her own game application using this book. And this is not only about developing a game. It is more about learning. In the process of developing Snake & Ladder Game using this book, one will learn a lot about designing Forms, writing Coding, applying Logic and methods etc. So this book is in fact a learning book. It is helpful for anyone, who is learning Computer Programming, who is doing Computer Course like Diploma, PGDCA, BCA etc. It is also useful for College/School students, as Computer programming is part of School course. It is also useful for those, who have passion for programming. This book contains complete design guide, all required images and complete Coding for developing Snake & Ladder game. That game will have two auto moving ladders, which shall dramatically send the player up as well as down. However Design and CODING given in this book are complete and need no modification, but you can also improvise the design and CODING as per your wish. If not for you, even then this book may be useful for someone you know. May be your family persons, your relatives, your friends, students etc. I request you to kindly check this book and help this book reach them, who you think can take benefit from this book. Your review and suggestions requested. Thanks, Anurag Pandey Bhubaneswar, India 24-08-2020

प्रिय मित्र! मेरी यह किताब “अधूरी कविताएँ” आपके समक्ष प्रस्तुत है। इस किताब में मेरी 104 रचनाएँ हैं। इन रचनाओं में 70 के आस–पास कविताएँ हैं। लगभग 10 गीत और कमोबेश उतनी ही ग़ज़लें हैं। और बाकी लघु कविताएँ हैं। इन रचनाओं में कुछ तो महज दिनों व महीनों की हैं तो कुछ दो दशक पुरानी भी हैं। लगभग दो दशक पहले मेरे लेखन की शुरूआत कविताओं से ही हुई है। अपनी भावनाओं को व्यक्त करने के लिए यही एकमात्र साधन था मेरे पास, और आज भी है। मेरी कविताएँ नवभारत टाईम्स जैसे अख़बारों तथा कादम्बिनी जैसी पत्रिकाओं में छपा करती थीं। उसके बाद मैं मुंबई शिफ़्ट हो गया। काफी समय तक कविताओं से कटकर रहा। वो लिखने लगा, जिससे पैसे मिलते थे। टीवी के लिए भी लिखा। मगर कविताएँ मेरा पीछा कहाँ छोड़ने वाली थीं! कुछ यूँ हुआ कि मुझे मुंबई छोड़कर भुवनेश्वर शिफ़्ट होना पड़ा। प्राईवेट सेक्टर में नौकरी करने लगा और फ़िलहाल भी कर रहा हूँ। और तब एक बार फिर कविताएँ मेरी दोस्त बन गईं। मैं फिर से कविताएँ लिखने लगा। लेखन के क्षेत्र में ही कुछ करना चाहता हूँ। यह किताब उसी दिशा में मेरा प्रयास है। अपनी पुरानी–नई रचनाओं को समेटकर किताब की शक्ल दे दी है। बेशक इन रचनाओं में कुछ बेहतरीन हैं, तो कुछ सामान्य। मगर मुझे मेरी सभी रचनाएँ प्यारी हैं। उम्मीद है आपको भी उनसे प्यार हो ही जाएगा। अतः आपसे मेरा विनम्र आग्रह है कि मेरी यह किताब “अधूरी कविताएँ” अवश्य पढ़ें। Adhuri Kavitayen has 104 poems on love, desire, loneliness, pain, beautiful waken dreams, social issues, helplessness, blissful heart, joyous heart, dancing heart, state of speechlessness, correlation of body, mind and soul, beyond mind, beyond the limits of Worldly things and so on... They can be addressed as touchy poems, poems on longing and desire, poems on separation, poems on untold love, poems on ultimate feelings, unity with immortal etc. आपका आपसा, अनुराग पाण्डेय भुवनेश्वर 27 फरवरी 2020

Excerpts from the bookI saw the main entrance getting a sharp shock. That moment only in the cow house I saw the cow jumping. All the doors from the main gate to the storeroom were pushed one by one by some invisible power. In the end the storeroom door got a big shock. A wave of air entered the storeroom. The cow had given birth to a calf a few days ago. That calf was tied in the storeroom only. The calf was sleeping. But as the wind entered the room, the calf woke up and started bouncing. We brother and sister got scared. Then only I felt the breeze rotating around my neck with some pressure. I got scared if Guru Akhandanand wants to strangle me?** *She screamed, 'I can't leave A.P.! A.P. is mine only! A.P. is mine! A.P....' I said, 'Say this to that lady!' She said fearfully, 'No! She is scary!' I asked, 'Does she have long teeth or scary face?' She said 'No! She is beautiful. But I am feeling fear from her.' I asked 'How old is that lady?' She said 'About 25 years. She is asking me to leave A.P.** *Then she looked at me and gave me a crooked and mysterious smile. Her face expressions were not of her. It was strange, cold and scary. Doesn't know why I felt a wave of fear running down my spine. I controlled myself and asked to her, 'What happened? Su? (I used to call her Su, short form of Sunita).' She smiled in a way like she was making fun of me. Then she said in a friendly but stone hard, ice cold way, 'You won't be able to save her. I will kill your SU drop by drop like this only.'** *It was Tuesday night. I was practicing meditation by sitting in Padmasana posture. Suddenly I heard anklet's sound around me, like some female came and was walking around me. Without getting scared I kept practicing meditation in the same posture. But after some time anklet's sound came closer to me as if she had stepped on my meditation carpet. Means she had come too near to me. Yet I kept meditating. Then only doesn't know from where a gust of breeze entered the room despite closed door and windows and began to hug me. The touch of the breeze was very ecstatic and it was giving me very deep pleasure.** *Again I felt myself laid in the jungle. Then only I saw an angry wolf stepping towards me, towards my head from 10 feet distance. Wolf's stepping on the dry leaves was producing rattling sound. That wolf came near my left ear, growled fiercely and started entering my body through my left ear hole.** *That night in my half-waken sleep and half-waken dream, suddenly I felt weightlessness. A strange beautiful girl whose colour was unfair and skin was glowing, came in my dream. Her presence was not unfamiliar at all. She took my hand in her hand with love and flown off holding my hand and took me on a high branch of a tree in an unknown place. In my dream, I was realizing that she was a ghost. But yet I had no feeling of fear. I was totally fearless and I was feeling oneness with her. She poured a lot of love on me through her silent presence. When I woke up in the morning, I was feeling deeply contented and light.** *He stepped on the road. As he reached the middle of the road, he became hundreds of feet tall. He was moving towards the field in his front. That field ended to some localities. Just in three steps he crossed the long field, entered some locality and got out of my eyes.** *Life is the most precious gift which the God has given us just for free. We should value it. I was lucky that I was saved despite taking in 78 sleeping pills. But if I was not saved, how could I enjoy my life after the end of those dark days. We should always remember - good days always come and bad days always go.** *Hello! I am Anurag Pandey, author of this book. I live in Bhubaneswar, India. Writing is my passion. Though I am doing job in private sector, I dream to grow as an established writer.I hope you would enjoy reading this book. Your invaluable reviews requested.

Every child takes birth with many qualities which are like diamonds for us, because they are rare to find. Those diamonds were to help the child to grow as a complete man or woman. Those diamonds could help the child to get rooted deep down and to rise above the sky. They could enlarge the personality of child in all dimensions. But we don't realize that how precious those diamonds are. We don't encourage the child to be careful with those diamonds. And unfortunately we make the child to lose those diamonds.Recollecting those diamonds of your childhood will take you back when you were a child and you had all those qualities. It will reopen all the doors of development, which are closed since your childhood. Then you won't be the same you. Then you will desire to discover the real you.In this book I have shared about six of those diamonds, which I had in my childhood. Read this book and you would start looking for your diamonds.Happy reading!Thanks & Regards, Anurag S Pandey[05-07-2020]Bhubaneswar, India