Excel Password Generator

key

Many websites require passwords 🔑. And, it’s not a good idea to use the same password on each site.
Some suggest changing your passwords every month – that’s fine if you’ve only got a few passwords to change.
Some also suggest password phrases which is fine if that website allows password phrases. And there are pins and facial recognition and fingerprint and iris recognition – but we’ve all seen the movie where they stole the President’s eye.

On to more pleasant thoughts!

Create a new Excel Spreadsheet. In the first cell type =CHAR(RANDBETWEEN(65,90)). This gives you a capital/uppercase letter.
In the second =RANDBETWEEN(1,9). This gives you a number.
In the third =CHAR(RANDBETWEEN(35,37)). This gives you a special character – #, $, %. Some websites allow other special characters in the password.
In the fourth =CHAR(RANDBETWEEN(97,122)). This gives you a lowercase letter.
You can choose any pattern of password you want using any number of characters. If you want an uppercase letter last, place that equation last. Just keep entering these formulas from left to right until you have the number of characters you want in your password.
In the second row type =A1&B1&C1&D1&E1&F1&G1&H1 keep adding &x1 until you get to the last cell in the first row where you entered formulas.

The second row will contain your password. To generate a new one press Ctrl+Alt+Shift+F9. Or simply type anything in another cell and press Tab.

Consider storing your passwords in an encrypted password protected Excel file. (File, Info, Protect Workbook, Encrypt with Password)
Speaking of Excel, I created a random password generator in Excel.

The Rumbling in Your Heart

heart drawn in the sand

I know a secret!

Shhhh!

I’ll share it with you!

There’s a rumbling in your heart. And no it’s not the pizza you had for supper last night. That might be the rumbling in your stomach, but it’s not the one in your heart. At least it’s not the one I’m talking about!

Your heart is swelling, about to burst.

Your heart wants to be free to express all the joy that is in it!

It’s true!

Sure, it’s hard to let my heart be free. Especially when I think that I’m surrounded by accusers and abusers. (Hey, it happens to the best of us.) But they’re not the reason I keep the murmurings of my heart to a low rumble. I villain is moi-même (my very own self). I through doubt, and “Stop That!”, and I short-circuit the realization that “Hey, my heart really really wants to be happy all the time!” to my brain.
I just need to relax and breathe and let that drumbeat in my heart turn into a percussion symphony. With maybe a few horns thrown in. And every time I try to stifle it, just swipe that thought away and return to enjoying what’s happening deep within my soul.

Fantastic Stories for You

teddy bear reading book

I started a new website http://fantasticstoriesforyou.com/ because I couldn’t find books 📚 I wanted to read. Most bookstores only carried Best Sellers – most of which were too formulaic – if you’ve read one, you’ve read them all. I’m not into a lot of sex and violence and swearing which seems to be the sole content of many books. And most run on and on forever. And they often left me worse off at the end – aka Not a happy bookworm. I needed a place to promote my own stories. And I figured others would be looking for the same thing. And I wanted more than just books to entertain me and make my life better. I also wanted movies🎥, music🎹, art🎨, etc. Poems, puzzles, plays, whatever form the story takes.

What a Fantastic Story is:

Fantastic Stories come in various formats – Books, Movies, Music, Art, …
Fantastic Stories are great! They intrigue you at the beginning and stay strong until the end. They are decent, usually short, and they leave you in a better place than when you started the story.

Fantastic Stories are not formulaic, boring, full of sex and violence, weak stories that you wish would end soon. They don’t leave you wondering why you ever started the story in the first place.


So, if you’ve got a fantastic story to share or if you’d like to read a fantastic story, please visit my new website.

Strawberry Cheesecake Applesauce

I got an idea for making Blackberry Forest Applesauce.
Blackberries, Dark Chocolate, Blackstrap Molasses and anything else black I could find to put into it to go along with the Blackberry Forest theme.
So I googled Black Foods – Squid Ink was all I found. Blackberry juice is purple, not black.

What to do? What to do?

I thought about Black Chia Seeds which would only be black until added. And I thought about Black Vanilla Bean – not sure how edible that is other than for extracting vanilla. I thought about Black Walnuts which I really love and I could get from Nuts.com. But the texture seemed to be calling more for Pecans. Besides, it was to be a  Thank You gift for my neighbors and he’s from Georgia and loves PeThank Youcans.

So, I went to the grocery store for blackberries – frozen, since it was winter. The closest thing they had was frozen mulberries – close enough. I didn’t have molasses at home, but I did have coconut syrup which was pretty dark and would be a good substitute (unless you really want molasses flavor). Dark Chocolate – check. Frozen Apples = Check. Buy Pecans.

The mulberries made the applesauce too runny, so I ended up adding Chia after all. After it thickened up, I added the pecans, placed it in a jar and placed 3 pecans on top for show. It was a big hit.

For more of my Gourmet Applesauce recipes, see my book Strawberry Cheesecake Applesauce.

Finding Commonly Misspelled Words

books

Find Commonly Misspelled Words that Microsoft Word’s Spell Checker won’t catch.

What if you used to when you meant to use too? Their instead of there?

So, you need to check your Word document for typos like these. When Clicking Spelling and Grammar in the Review Tab doesn’t catch them, what to do?

The typos I make most often include homonyms, and words I type instead of other words.

There are many, many homonyms (words that sound the same but mean different things), but I only commonly misspell the following:
There, Their, They’re
To, Too, Two
Than, Then
Wonder, Wander
Lets, Let’s
Your, You’re
Capitol, Capital
Its, It’s
Principle, Principal
Whose, Who’s

I often type The for Them, That, Then, …
I often type You for Your, You’re
And I often wrongly interchange Though and Through.

To find this list of words, I could write a Word Macro – go ahead if you’re so inclined. Just go through the document, selecting each word as you go. Stop if that word matches one in your list. Stop when you get to the end of the document.

Or, I could possibly purchase a Word Addin or possibly find a free one in the Office Store. I looked. Didn’t find anything I wanted.

You could maybe to contextual proofing, but that’s not an option I can find in my version of Word.

When I realized my list was rather short, I decided to check my document manually. It wasn’t very long. If you’re checking a novel, you may want to take a few chapters at a time and come back and do a few more the next day.

Before you do any manual checking, click the down arrow on the Quick Access Ribbon and select More Commands…. Select All Commands, check Find (the one with the magnifying glass that says Navigation and Dialog when highlighted) and Find Next (Magnifying glass with right arrow). Click Add, then OK.
If you don’t see the Quick Access Toolbar above the Manu Bar (File, Home, Insert, …), select File, Options. Then select Quick Access Toolbar. Then Uncheck to show it below the ribbon. Click OK.

Now, click on the Magnifying Glass. Enter the first word in the homonym list (there). Click More. Check Find Whole Words and check Sounds Like. Click Find Next. Close the Find Dialog box. To Refind, Click the Magnifying Glass with the Right Arrow (Find Next). Correct errors as you find them. There will match There, They’re, Their.
To will match To, Too, Two, Do, Day – don’t ask about those last two, just ignore them when found.

When you’re done with the Homonyms, uncheck Sounds Like. Then find all occurrences of the other words you want to check.

Happy Proofing!