Great Basin, WY. 96 miles of nothing (no water, no people, no trees). |
Just me and a potentially dangerous lightning storm. |
Weird looking overloaded person on a bike. |
Just keep following the yellow shirt! |
Great Basin, WY. 96 miles of nothing (no water, no people, no trees). |
Just me and a potentially dangerous lightning storm. |
Weird looking overloaded person on a bike. |
Just keep following the yellow shirt! |
San Francisco Bay |
I am a very curious person, or so I have been told. Some people like that about me, but I am sure that I annoy the crap out of others by asking too many questions. I just want to get to the meat of things, and if I have a problem to solve, I do not quit until I find the answer. This can lead to some pretty grim rabbit holes, and some frustration on my part, but the maximizer in me will oftentimes not let go. Many times, these searches or questions come because something goes wrong. Other times, it is my need for perfection that drives the search. I will give you examples of both. The first one on my list is the latter, and the second one on the list is the former. The third is one I learned a long time ago, but one that I find useful for blogging or journaling. So read on for what I learned, the computer shortcuts and blogging edition.
Putting a hyperlink in a comment. I wanted to link a pair of shoes for Rick in Nance's blog about buying shoes for her husband, but I did not want that super long annoying link to show up; I just wanted a tidy hyperlink. I have done this before, but it is one of the things I promptly forgot afterwards. One thing that I am trying to do (#lifegoals) more is to keep track of things in an organized way so I can either find them later or use them again or not look up the same thing over and over (definition of insanity, right?) So now I (and you!) will have notes on how to do this right here:
In the area you want the hyperlink, type this: <a href="PUT WEBSITE ADDRESS HERE">PUT WORDS YOU WANT DISPLAYED HERE</a>
For example, you would type: why not hop over to <a href="https://www.travelspot06.blogspot.com">this excellent blog</a> for more information about coding? And what will show up will be --> Why not hop over to this excellent blog for more information about coding? FYI: This will work on both WP and Blogger blogs.
Copy + paste clipboard. Sometimes I am commenting on blogs and when I click submit, I get an error and then sometimes I cannot go back and resubmit, so I have to type out the entire comment again and that is frustrating! So I researched how to get my clipboard (aka previously copied information) and it is super easy on a PC (sorry Mac users, you have to figure out your own issues).
Just click the Windows Button + V, it will ask if you want to start saving your clipboard, say yes. Then what I do is right before I hit submit on the comment, I use CTRL-A, CTRL-C to copy the comment and then if I need to access it again later, I click Windows-V and there I have my list of saved items. To use it, just click on the one you want and voila! No repeating comments or other things. You can also pin ones you use a lot! This also works for clipped snippets (like the Excel clips pasted below!!)
A quick warning though: The Windows clipboard history is available until you restart your computer, except for any items you've pinned. The clipboard history only stores the last 25 items you've copied, and when you copy a new item, the oldest item is deleted.
Excel formula of the week. I love Excel; I use it for travel and packing lists and organization, collecting information, keeping track of things and obviously for adding up costs and doing budgets and things like that. The IF function is one that I use in various forms! You all may know how to use these already, and if so, yay! If not, here they are. And if these seem exciting, just wait until we get to nested IFs! Prepare to be wowed!
SUMIF --> Used to sum by category when you have a list of numbers or costs etc. In the below example, I want to sum up costs by category. I am telling it to sum the list in column C if the category in column B matches the word in cell E3.
COUNTIF --> in the same example, I now want to count how many of each category there are. So basically count how many in column B match cell E3.
IFERROR --> Now that I have my counts, I want to calculate a per day cost. This all well and good but if I remove the word Motel, now I have an error (#DIV/0) for Motel because the count is zero. To fix that, I put the words IFERROR before the formula and then tell it what phrase or number I want it to return if there is an error. In this case I am being silly, but usually I just put 0, or "", which will return a blank.
Once that formula is done, here is the result. Isn't that fun!
Oh you want one more you say? Fine! I also love the shortcut ALT = (ALT and equal key) which is used to sum up a column instead of typing out =SUM(H3:H9). Just put it where you would normally put the formula and you are good to go! Okay, admit it; did your eyes glaze over? Or are you excited to share your favorite Excel tip with me?
Do you use any of these tricks? Or do you have any other shortcuts you use while blogging or commenting? Do you have any fun Excel tricks you want to share? If you are a Mac (or cell phone) user, do you know where to find your clipboard?
This post is part of NaBloPoMo. You can find the rest of my posts for this challenge here. You can find the list of participants and their information here.
Big pictures! Too many ads and Instagram links! |
So much cleaner! See top right for options. |
Hiking the Bomber Traverse |
Picketpost Mountain - AZT |
Headed downhill to Stinson Beach during the Quad Dipsea |
Camping above Lake Aloha |
Pacific coast near Mendocino |
The bike car on Amtrak |
Lisa getting it done! |
A Cruise car with nobody at the wheel. |
High desert of Oregon |
Bolinas Ridge Trail |
Here is Bob, all loaded up and ready for adventure! |
Crossing the Golden Gate Bridge |
View of the Golden Gate Bridge from the headlands |
Dias Ridge Trail |
Getting off the road and back on the trail toward Cardiac/Pantoll |
Ridgecrest Drive |
Bolinas Ridge Trail |
Samuel P. Taylor hiker/biker camping |
View from the top of the hike-a-bike near Kent Reservoir |
Larkspur bike path |
View of the city from Richmond (SF Bay Trail) |
Happy New Year! Each year, a goal of mine is to try new things! This can be going to a new place, trying a new restaurant or food or activity or learning something new. I don't really have a certain number in mind, but I thought it would be fun to talk about 22 of them, in honor of 2022. Here they are, mostly in the order that I did them.
1. Emigrant Wilderness in the snow: I usually go to Emigrant in the summer for hiking but this time we decided to go for some winter sports. We stayed near Pinecrest and spent one day skiing and one day snowshoeing and then one day taking a hike around the lake before going home. It was beautiful and we liked it so much we may go back this year and do a longer snowshoeing trip!
2. I threw out all of my instruction manuals. I know this is not that exciting, but I finally decided that if I need to, I can look up product information or instructions online and I do not need to keep the heavy booklets for everything I have ever bought in my life. It freed up my file cabinet a lot and I have not even missed them! I did take photos of some of the more pertinent details but otherwise I am basically manual-free!
3. I added a few new travel destinations to my list, which also added a LOT of new things which I will not list separately. Austin: Texas BBQ, kayaking on Lady Bird lake and live music! Lost Coast trail: many miles of hiking in the sand, cool shells and creatures and the rising tide! Amsterdam: bikes and canals and legal drugs, oh my! Slovenia: this deserves a post of its own, but hiking and dragons and sausages abound! Mt. Hood: circumnavigation on the Timberline trail. Washington: Enchantments (a must see!) and section L of the Pacific Crest Trail (the most northern of the PCT).
Lost Coast |
4. I tried some new foods. Shakshuka. This is something that never appealed to me since it involves cooked tomatoes, which I did not really like as a kid. However, as an adult, and when REAL tomatoes are used, I realized that they can be pretty good actually! And this includes my favorite breakfast item, the egg! I would eat it again. Cioppino. Same story regarding the tomato, but this is also pretty good. I would still rather have a bowl of creamy New England clam chowder however. Homemade yogurt. This is so easy and so delicious; I actually prefer it to store bought and it is way cheaper. It does take about 24 hours to make yourself, but I think it is worth waiting for!
Yogurt |
5. FODMAP elimination diet. This deserves a post of its own, but the short of it is that I was having some gastric issues and was put on this diet which consists of several weeks of elimination and then several more of reintroduction. I am still not 100% sure what is ailing me, but have a better idea than I did a year ago.
6. Ran through Harvard Yard. I have looked at Harvard from the other side of the Charles but had never been on campus. While visiting friends in Sommerville, I took a run and went and explored Harvard. What a beautiful place! I thoroughly enjoyed it and it also gave me a chance to go inside and use the bathroom! :)
7. Participated in a 30 day fitness challenge. This was a good way to reset my fitness plan, which sometimes gets a little blah. I did this with a few friends and I don't think that any of us actually finished it, but it was really fun trying to! The issue for me was not the exercises themselves, but the regularity of doing it every day. I would find myself forgetting or while in bed at the end of the day realizing I had not done it so then I would tell myself that I would just do two of them the next day....etc.
8. Chopped off and donated my hair. This is not a new thing but I did send it to a different charity than I normally do as I was told that Locks of Love, the one I have sent hair to before, actually sells their wigs! Shame on them! So this time I sent it to Wigs for Kids, which I was told does not profit from my donation. They make it really convenient too; you print out a barcode so you can track where it is in the process after you send it.
9. Tried to sell shoes on Ebay. Total and complete failure. I started with only a few pairs but I did not even get a nibble. I even lowered the price, but still nothing. And then I lost hope and kind of gave up on that project. However, I have a bunch of barely or never worn shoes that I really did not want to just give away. Does anyone have any tips for me about this?
10. Did an almond croissant challenge. While in Brooklyn, I tried all of the almond croissants at all of the bakeries within walking distance from my hotel. I tried about 7 or 8 different ones! Some of them were just meh, but there were a few that I liked and my favorite was from Julien. Shortly after this, I learned that wheat may be a contributor to tummy issues that I am having, so my croissant days may be limited, so I am glad that I lived it up while I could!
11. Went camping at Lake Sonoma. This is so close to where I live, yet I had never gone camping at the lake until 2022. You do have to hike or boat in to some of the spots, but we did both and had a great time. Plus, you have to love the California coast, where you can camp outside in April and even get a little hot!
12. Tried to summit Mt. Whitney in the snow. In April, my brother and I tried to summit Mt. Whitney but there was a late spring snowstorm and we decided to be safe rather than sorry and we turned around early. However, it was really beautiful to see some of the normally bare places covered with snow.
Photo Rock |
13. The year of the bike! In 2022, I waited until everyone who bought a bike during COVID got tired of it and then I bought a used stationary bike. I have used it a handful of times, but now that it is winter and raining, I think it will be getting more use soon. I also bought my first mountain bike and am still dialing in the adjustments and I can't wait to go out on my first ride! I also completed my longest bike ride ever (to date) of 42 miles, surpassing my 2013 record of 40 by two miles!
14. Cowboy camped in the NV desert. On a road trip to Wyoming, we stopped outside of Reno and lay down by the side of the road under the stars! It was a little windy and dusty, but I actually slept great!
Somewhere near Reno, NV |
15. Backpacked in Grand Teton NP. Although permits were a little difficult to get (you have to get online on a certain day at a certain time and know exactly the dates you want and the campsites you want to stay at) once we were there, this was a great experience. It was beautiful and not as crowded as I expected and the views just kept on coming! I have been to Wyoming a few times and this park once before but I have never done any overnights and it did not disappoint!
16. I got a new job. This probably deserves its own post, but basically my whole team went from one firm to another. We are still learning some of the rules and systems and things like that, but we are pretty satisfied with how the whole transition went overall.
17. Summited Mt. Elbert. While not my first Colorado 14er, this is the second tallest mountain in the continental US and the highest in Colorado, so it was fun to check it off my list. Also it was fairly easy (as the 14ers in Colorado sometimes are) logistically. We were staying in Twin Lakes so I just hiked up to the top of the mountain and back down again to our AirBnB! Easy-peasy!
The Collegiates as seen from the summit of Mt. Elbert |
18. Discovered Octowordle. If you love Wordle, you will love Octowordle. You do not need to download an app and it is free and you can play games from the days before, so if you feel like more than one, you can have it! You have to solve eight Wordles at the same time and it is super fun.
19. Got a bidet. I will not go into too much detail here but I bought a Tushy and I love it. The end. Seriously, it is easy to install and it does the job.
My Tushy |
20. Cross country backpacking Emigrant. I always wanted to do this cross country route near Cherry Creek in Emigrant but it was never on the way or convenient and we finally did it in October. It was great because the water was low so we could basically walk on the creek bed which made cross country travel very easy. Plus it was beautiful and we had the place all to ourselves since it was so late in the season.
21. Went to a David Sedaris reading. I have never been to a book reading before and I do love listening to Sedaris books as he is a good narrator, so this was the best of both worlds! I also brought my brother and his girlfriend along, and although neither of them really have read Sedaris, they both enjoyed it.
22. Finished my Death List. Maybe this needs a better name, but it is basically getting all of my "affairs" in order just in case something happens. I have had most things pretty dialed in (advanced directive, POA, beneficiaries) but wanted to put it all on one list so that people can access it easily. I started working on making a more detailed list last year when my grandmother died (nothing like a dose of reality to get you moving, eh?) as her list made it so easy to take care of her affairs after she passed.
Wow, I did not mean to make the last one so dreary, but it is the most recent! Also, happily, I did a lot more than 22 new things in 2022, but I like the sound of 22 in 22 so I will leave it at that! Here's to many more new things in 2023!
What new thing did you learn, place did you go or experience did you have in 2022?