I really like LibreOffice. It’s not just my default office suite because it’s free. I like it because of the control it gives over so many elements of what I do in my day-to-day work. However, this post is one of those where I lament the fact that it is missing a feature that other similar software has had for over a decade: the ability to animate a series or element in a chart or graph. There is a way to do this, but it is extremely clunky and should really be a feature that is added to the software.
Assuming you want to use LibreOffice to animate a series in a graph or chart, here’s the process.
First, create your graph. I created mine in LibreOffice Calc.
Now, copy and paste that into a slide in Impress.
Check to be sure the chart looks exactly how you want it to look, because this next step is going to make it so any future changes to your chart will be really time consuming. What you’re going to do is right-click on the chart and select “Break”.
What the “Break” command does is separate every element of your chart into individual pieces. You can test this once it’s done by clicking on any one piece of the chart and you’ll see that it doesn’t select the chart anymore. It select just the single piece of the chart, as shown in this next image.
So, after “breaking” your chart, you have all the same elements, but they are all broken into individual pieces. What that means is you can now animate every single piece of your chart.
Of course, if your goal is like mine and you want to show change over time by animating a series from left to right, there are a couple more steps.
To animate an entire series, you have to select the whole series. You really need to do this by dragging a selection square around the relevant elements, since there are is an outline of each marker in an element, the fill component, and then the line. Selecting each component individually is basically impossible. So, drag a square around the elements you want to link together like this:
Then right-click on them and select “Group”. Once you’ve got the elements grouped together, you can then “Animate” the group using a Wipe animation from left to right.
Here was my result once you play the slideshow:
LibreOffice programmers, if you’re listening out there. I love the software. But this is a feature that should be included and not require this length of work. Please add it.
I run a network attached storage (NAS) device at home to manage all my media (e.g., music, videos, photos, etc.). I have used various programs over the years to manage the naming and organizing of my music files but just recently discovered tinyMediaManager for managing video files. Since it’s written in Java, it works on any OS, including Linux.
Given my large collection of movies, I have been looking for software that would properly name and organize all of them. tinyMediaManager seemed like the perfect solution, but I immediately hit a snag once I tried to get it running on Kubuntu 18.04 (my current distribution of choice). I couldn’t get the GUI to launch. It took some doing, but I eventually figured out how to make this work on Kubuntu 18.04.
First, download the tar.gz file here. (Note: I couldn’t download it using Chrome, as the tinyMediaManager site only lets you download it using a browser that allows Java and, as of Chrome 45, Chrome doesn’t. I used Firefox, which worked fine.).
Untar that file and move the resulting folder wherever you want it to reside (obviously, somewhere you have access to it, but, otherwise, it doesn’t matter).
Now, the tricky part. According to the tinyMediaManager website, all you need to do to launch the program is use a terminal to navigate to the folder you just untarred and use the command:
cd /home/ryan/tinyMediaManager
./tinyMediaManager.sh
When I tried this, it didn’t work. It seemed like it was trying to do something, but then the GUI wouldn’t open and… nothing. Disappointed, I started looking for answers. I eventually found the “launcher.log” file in the tinyMediaManager folder and that gave me the clue I needed to solve the problem. As it was trying to launch, it was running into a problem with a specific thread and library in the version of Java I had installed by default. Here was the error:
Exception in thread "Getdown" java.awt.AWTError: Assistive Technology not found:
It turns out, tinyMediaManager has not been updated to work with newer versions of Java. So, here’s what you can do.
First, install the Open Java Development Kit version 8 which is the latest version it works with:
sudo apt-get install openjdk-8-jdk
It turns out, you can have multiple openjdk’s installed at the same time. I was running as my default openjdk 11. Now, in order to switch to the openjdk 8 environment, type in the following command at the terminal:
sudo update-alternatives --config java
You’ll then be given the chance to choose which openjdk you want to use, like in this screenshot:
Choose openjdk 8 as your default. Then try running tinyMediaManager again. If the software gods are smiling upon you, the GUI will launch:
(plus our guides – Travis and Matt – and two other clients – Drew Herdener and Olivier Colle)
Trip Report
While I do a fair amount of hiking, mountains like Mt. Rainier are really at the upper end of the types of hikes that interest me. Given that it is snow-capped and covered with glaciers and I have only climbed one such mountain before (Mt. Hood in 2016), the most logical approach to climbing this mountain was to hire guides.
For anyone interested in hiring guides, there are three main companies that guide on the mountain: RMI, IMG, and Alpine Ascents. Since I used Alpine Ascents on my previous climb like this and had a good experience, I decided to use Alpine Ascents again. I think that was the right call as will be made clear in this trip report. I’ll note one other thing for others considering climbing Mt. Rainier with guides. Most of these companies list their hikes almost a year in advance and the hikes sell out quickly. If you’re interested in climbing Mt. Rainier, I’d strongly encourage you to sign up for the newsletter for the company you want to go with almost two years before you plan to hike Mt. Rainier. You’ll then get a notification when the hikes are listed on their website so you can book your hike. If you wait until even 6 months before the hike date, it’s likely the hikes will all be sold out.
Pre-Hike Day
My trip began with a flight to Seattle on July 28th. With flight delays and such, I ended up arriving the same time as my hiking buddy, Tom. We then hopped on the train from the airport into Seattle and finally caught a bus to get us to our hotel, the Marqueen Hotel, which is just a block or so from the headquarters of Alpine Ascents. Our hotel room wasn’t ready so we grabbed a bite to eat then headed to the Alpine Ascents office with all our gear.
We had a gear check at 2:00 pm. The gear check involved going through all the equipment we brought based on their gear list and then renting any remaining equipment we needed. Given the technical aspects of the climb, crampons, harnesses, ice axes, helmets, and avalanche beacons were all required gear (along with standard cold weather clothing and such). The gear check included some instructional videos about climbing on Mt. Rainier. By the time we had our packs largely ready, the gear check took us at least 2 hours.
We still needed to pick up some food for the next few days – mostly snacks, but also some more substantial food as Alpine Ascents provided breakfasts and dinners but not lunches on the mountain. (As one of the guides said at one point, “There are no lunches on the mountain, just constant snacking between breakfast and dinner.”) We found a nearby grocery store, stocked up, then headed back to the Marqueen Hotel where we had dinner and finished getting everything ready.
Day One
We met back at the Alpine Ascents office the next day at 4:45 am. We left our suitcases with anything we didn’t need to take on the hike at the office, put our packs into a trailer, then hopped on a van. We had 8 clients to begin with, two of whom drove themselves from Seattle to the trailhead. The rest of us rode in the van. We stopped at a bakery on the way to grab breakfast. Then, just outside of the Mount Rainier National Park we stopped to pick up our three main guides – Robin, Matt, and Travis. (Our fourth guide, Towner, was already on the mountain at Camp Muir.) For this climb, Alpine Ascents likes a 2 to 1 ratio of clients to guides.
The Paradise parking area was where our hike began and our car ride ended. Here, our guides took over (previously, other staff from Alpine Ascents had been providing us with instructions). They went over our plan for the day. We then geared up, splitting up the food from Alpine Ascents among our packs. We had one issue with a backpack (a missing buckle) that the guides were able to solve with a buckle hack. Otherwise, we seemed to be ready to go.
Ryan and Tom before the hike started at Paradise.
I will note at this point that I had some issues with the big backpack. I do a lot of hiking, but most of my hiking is day hikes with, at most, a 20 to 30-pound pack (if I’m with others, I usually carry their water as that amount of weight doesn’t affect me). The big backpack I have is a 65+10 liter pack. It’s a bit on the small end for hikes like this. I also have a sleeping bag that is a bit older and therefore a bit bigger than most and didn’t have a compression bag for it. Finally, I probably over-packed slightly on gear and food. All told, I’m guessing my pack weighed closer to 50 to 60 pounds. I had not trained with a pack that heavy and it was a bit of an issue for me.
The hike started on the paved trails at Paradise and followed those trails up until the paving disappeared.
some of our team on the lower trail
It then continued on unpaved trails until we hit the Muir snowfield. Just before we hit the Muir snowfield, we lost our first hiker. One of the people on our hike had broken his ankle a couple of years before and he wasn’t sure whether he was going to be able to do the hike but wanted to try. Turns out, he hadn’t completely healed. The pain was too much given the weight of our packs and the pace at which we were hiking. He pulled off to the side and told a guide. He was led back down to the trailhead where he waited for the Alpine Ascents group that was coming down the mountain so he could get a ride back to Seattle. (Sidenote: When he called his wife to let her know, she reportedly – according to one of the guides – said, “I told you so. You’re a pussy.”)
Once we reached the Muir snowfield, we stopped and switched from our hiking boots or shoes into our mountaineering boots with a hard shell (that we’d be using with crampons) since we’d be hiking the rest of the way to Camp Muir in snow. The views of the glaciers at this point were pretty cool.
We could see this waterfall from the Muir Snowfield.
Returning to my pack issue… I was doing fine on the paved and dirt trails with the heavier pack. It was a bit uncomfortable, but not a serious issue. However, once we switched to hiking on snow, the weight really started to get to me.
We hiked for several hours up the snowfield, which, once you are on it, really doesn’t seem like it is ever going to end. We started hiking around 10:30, covered just under 5 miles (4.79 per my watch), and it took about 5 hours and 15 minutes.
With my heavy pack and the trudging in soft snow, I struggled. Don’t get me wrong. I’m a pretty strong hiker and I was one of the first to make it to Camp Muir right behind the guides. But, when I arrived, I was exhausted and, mentally, was wondering whether I was going to be able to complete this hike. Without the very heavy pack, I would have been fine. But those extra 20 or so pounds really got to me.
We arrived at Camp Muir around 4:00. We had a couple of hours to get settled into the shelter that would be our home for the night. Camp Muir is an interesting place. It’s clear that it is an established camp that serves as the launching point for most attempts to summit Mt. Rainier (in fact, RMI makes their summit attempts from Camp Muir, not the Ingraham Flats, adding an extra mile to the summit attempt). The camp sits largely on a rock outcropping that separates the Muir snowfield from a glacier, though a number of people actually camp on the glacier. There were a number of wood and rock buildings used by the forest service and the professional guide companies. There are also several toilets and a few other buildings. (I use toilets here in the sense that they are actual toilets, but, they are not the most sanitary toilets you’ll ever see or use. There are a lot of people at Camp Muir, toilet paper and wipes are at a premium, and where the human waste goes is, well, a bit of a mystery. Don’t expect 5-star accommodations and toilets at Camp Muir, but be glad you have something to sit on.)
I took a photosphere at Camp Muir that helps illustrate what it is like:
After what I thought was a fairly grueling hike up the Muir snowfield, I was happy to take a couple of hours to organize my gear inside our hut. Alpine Ascents provided some basic air pads and we were able to put our pads on top of those then lay out our sleeping bags. Given our numbers, we all basically had room to spread out a bit. Here’s a look at the inside of the hut:
We stayed in a wooden hut with shelves for bunks the first night at Camp Muir.
My buddy, Tom, really can’t sit still. He somehow managed to get connected with the forest service people and was helping them install some new solar cells and wiring in a building they were working on by the time we were supposed to go to dinner.
We had really amazing burritos for dinner. At dinner, our guides went over the plan for the next day and rounded out the evening with advice on getting as much sleep as we could and trying not to wake up our fellow climbers by going to the bathroom in the middle of the night. After dinner, we all headed back to the hut and went to bed. Given the challenging hike that day, I slept pretty well.
Day Two
Alpine Ascents’ approach to climbing Mt. Rainier (in this 3-day package) is different from RMI’s approach (but the same as IMG’s, with whom they share the hut and some other equipment). On day two, after a hearty breakfast, we spent the morning in snow school, learning how to walk in crampons, how to walk roped together, how to use ice axes, and how to do self-arrests on glaciers. Tom and I had done all of this before on Hood but it was a good refresher course.
Before snow school, we made sure we had all the stuff we were taking up to our high camp on the Ingraham Flats. If we wanted to leave some stuff at Camp Muir, we could. I had already pulled out the food for the entire group, which dropped my pack weight by 6 to 10 pounds. I also left my hiking shoes and my inflatable pad at Camp Muir in order to cut some more weight from my backpack (about another 5 to 8 pounds). With that weight gone, my backpack was probably closer to 40 pounds and was a much more comfortable weight for me.
After a quick lunch, we geared up and hiked the about one mile to the upper camp at Ingraham Flats. It didn’t take very long – close to an hour. However, it did involve crossing some areas with fairly active rockfall, which was when most of us realized that this hike was pretty serious.
This was also a chance to get a sense – both by Tom and me but also the guides – who the stronger hikers on a rope line were. It turns out, there were several strong hikers in our group, but perhaps the strongest (even stronger than Tom and I), was a Microsoft employee from France, Olivier. He was less experienced than Tom and I but, physically, he was moving well and seemed quite comfortable on the mountain. We didn’t know how many people we’d have on a rope team the next day when we attempted to summit the mountain but we wanted to make sure we’d have a solid team and Olivier seemed like he’d be a strong team member.
We were also dealing with another issue. The previous two teams from Alpine Ascents had made it to Ingraham Flats but had not summitted Mt. Rainier because the route that had been established was too dangerous. Basically, a massive ice fall had collapsed onto the trail up above the Disappointment Cleaver and more ice was hanging over the trail. Teams from RMI had pushed right over the fallen ice, which really wasn’t being held up by anything and could collapse at any time. They were also walking under the ice that was hanging over the trail as well. For Alpine Ascents, that level of risk was unacceptable as it basically put clients and guides into a very dangerous area not for a minute or two (like the rockfall we crossed this day) but for about 20 to 40 minutes. That was too dangerous.
Our guides were constantly talking with other guides about the trail. We didn’t overhear all the conversations but could tell that our odds of making it to the summit were pretty low. In fact, after dinner on the first night, I asked our head guide, Travis, what our odds were of going up to the summit. He didn’t answer at first, but when I gave him some numbers, he finally nodded at around 10% to 20%. That was a bit of a downer for most of our team, but we were still going to get to go up to Ingraham Flats and potentially to the top of Disappointment Cleaver (which is a rock outcropping you climb on the way up).
Our guides split up in the morning. Two – Robin and Towner – stayed with us for snow school training while the other two – Matt and Travis – headed up the mountain to see how dangerous the current trail was for themselves and to see if there was a way around the dangerous ice fall.
After we arrived at Ingraham Flats, we had a couple of hours to just kind of hang out. I had a book on my phone and a backup charger for my phone, so I sat and relaxed, reading and resting. Some of the other clients tried to get some sleep. I also took this photosphere of the camp, which shows just how amazing the views were there.
Around 6:00 or so, Robin and Towner called us to the mess tent for dinner. We enjoyed some turkey burgers (again, we ate pretty well on the mountain) and talked. We could actually hear Matt and Travis coming down Disappointment Cleaver but couldn’t see them. We finished dinner and were all wondering whether we were going to go up the mountain the next day. About 20 minutes after we finished dinner, Matt and Travis returned to camp and we headed out of the mess tent to hear the news.
They actually did a very good job of leading us on. Travis started at the beginning of their adventure that day, explaining that they found the dangerous section of the trail and it really was an accident waiting to happen. He wouldn’t want to cross it himself let alone with clients. He and Matt then tried to find a route around that section. They had several false starts, found an okay route, then ran into an almost vertical wall that they were able to cut some steps into, had to walk along the edge of several crevasses, and did a lot of searching, but… By the end, they had carved out a trail that bypassed the ice fall and would allow us to go the summit. It took Travis a good five minutes to get to the part we all wanted to hear – we had a safe route up the mountain. We all cheered – at least, as much cheering as you can do when you’re standing on a glacier and it’s really cold outside.
Our guides gave us the last advice of the night. Try to sleep and don’t set an alarm. They would wake us up when they thought it was the right time to start up the mountain – somewhere between 11:00 pm and 1:00 am. The idea is to make it up in the dark while the ice is solid so you reduce the risk of ice melting and falling. We all headed to our tents and tried to sleep – most of us to little avail. I know I managed to get in a few hours because the time passed pretty quickly.
Day Three
Our guides ended up waking us up around 1:00 am. We had a quick breakfast of hot drinks and oatmeal. We also found out at breakfast that one member of our group, Ford, had decided he didn’t want to continue. He was feeling okay but was realizing that this kind of hiking was really not for him. He opted, instead, to stay at Ingraham Flats and wait for us to return. One of the guides, Towner, would stay with him.
That left us with three teams – Tom and I with Matt, Olivier and Drew with Travis, and Leli and Thomas with Robin. Leli also noted that she wasn’t feeling all that well and suggested that she may not be able to make it all the way but she was going to try.
After our quick breakfast, we geared up and headed out around 1:45. We made decent time crossing the Ingraham Flats to Disappointment Cleaver then worked our way up the Cleaver. Our first break was at the top of the Cleaver at the spot where our guides had forged a new trail. We stopped there and Leli indicated that she was going to keep going but was feeling worse.
After that first break, we were off the trail all the other hikers were on, forging a new trail. Luckily, Matt and Travis have great mountain sense and had a clear sense of the trail they had blazed the day before. We could tell that there wasn’t much of a trail, so we tried to help make one as we went and Matt dropped flags to help guide us on the way back. Once we reached the very steep section that involved connecting ourselves with a carabiner to a fixed line, Leli indicated she had enough and didn’t think she could make it back down that section. Her team turned around while the rest of us continued.
The new section was a bit rugged but the more exciting aspect was that we could tell we were climbing on some pretty crazy stuff as there were several spots where our headlamps disappeared into darkness and other spots where we knew we were hiking along a knife’s edge or ridge with steep drops on either side. But, in the dark, we really couldn’t tell what we were climbing. That may have been best, since it was pretty crazy terrain, as we realized on the way down. Here’s a photo from the new section showing me on a ridge with a crevasse on the right on a steep drop on the left:
Part of the new section with steep drops on either side.
The two teams continued through the new section, then reconnected with the standard route and took one more break fairly high on the mountain. After that last break, the guides said we were going to push from there to the crater. Not knowing how far that was, we all agreed.
Just below the crater was a particularly steep section. I was just behind our guide, Matt, on my rope team, with Tom behind me. Our guides had said that we had to be able to push at a certain speed and, if we couldn’t, then they were likely to turn us around as we had to be off the mountain at a certain point. With my much lighter pack, I was able to move pretty fast. However, that last really steep section was brutal. There were three or four times on that section that I was struggling to catch my breath and it was all I could do to put one foot in front of the other to keep up with Matt. Turns out, I wasn’t the only one who was struggling to keep the pace – Tom said he did as well. But, I wasn’t going to say anything about a quick break because we were so close to the summit and I didn’t want our guides to turn us around.
It was only about 20 to 30 minutes of the grueling pace on that steep section before Matt called out that he could see the crater. Another 5 minutes or so and we dropped into the southeast side of the crater where we took a solid 10-minute break. From there, all we had to do was walk across the crater, climb up a small section of loose rock, and we’d be at the summit. Here’s a photosphere from inside the crater where we took our break:
After a 10-minute break or so, we left our heavy packs on the far side of the crater and walked to the summit (a 20 minute walk). Given the forest fires in the area, the view wasn’t amazing. And the summit really just looks flat, as you can see in the media below. It was also very windy and very cold. We stayed long enough to snap some photos then headed back to the shelter of the crater. Here’s the summit in a photosphere:
Here’s a video panorama of the summit. Tom (left) and me (right) on the summit
Just as we dropped into the crater, I started to notice that I felt a little… funny. It was as if about 10% to 20% of my brain had shut down. I was also having a hard time focusing on anything except what was directly in front of me (e.g., tunnel vision). Given what was happening to me, it took me until we got to the summit before I realized that I was actually suffering from altitude sickness. It was very mild and I was still able to function, but not as well as normal. This was the first time I had ever experienced this. I wonder to what extent it was related to the quick rate of our ascent. We had started the day at just over 11,000 feet and had climbed to almost 14,400 feet in 5 hours. Those 3,000 feet made a difference for me. I had been to higher elevations (e.g., Mount Whitney in California) without similar symptoms. I’m not entirely sure if it was the pace or something else, but I did let the guides know that I was feeling some of the symptoms of altitude sickness as we were walking back across the crater. They both agreed with my assessment and smartly said, “Well, there’s only one way to treat that – we’ve got to go down.”
I felt like I was moving a little slower gearing back up, but once we got back on our ropes and started walking, I was able to keep up. About 20 minutes from the summit, my symptoms cleared and I was fine again.
We pushed a good pace down from the summit until we reached the new section of trail. On the new section, our guides asked us to help “kick in” the new trail so the next group from Alpine Ascents would know where to go. We spent a good 45 minutes along the new section with the guides shoveling and the clients kicking in steps and trails with our crampons and cutting what we could with our ice axes.
We stopped one more time just above the cleaver for a quick break. On a typical hike of this distance and this elevation gain (but at a much lower elevation when it less technical), I would probably consume fewer than 500 calories (I don’t need a lot of calories). To this point on our summit attempt, I had consumed 3 Snickers bars, among other snacks, which was over 750 calories (probably over 1,000 with everything else I had eaten). We were moving fast enough that I knew I needed energy. We made one final push down Disappointment Cleaver and then to our camp. Here’s our route from Ingraham Flats to the summit and back:
At the camp, the other two guides had been busy. They had dug out a new location for the mess tent as they have to move it every few weeks. It is on a glacier which is moving down the mountain, which opens a new crevasse regularly. So, they have to move the tent or it will go into the “REI crevasse” with all the other gear people have lost in there. However, we used the new tent location for something else first. Leli and Thomas were engaged and had hoped to get married on the summit. Since they had turned around, they opted, instead, to get married at our high camp. Honestly, the high camp marriage with Mt. Rainier in the background was a better location. The top of the mountain was kind of flat and, because of wildfires, didn’t have a great view. Plus, it was super windy and you couldn’t hear well. At our high camp, there was no wind.
Travis, the lead guide, had gotten registered as a Universal Life Church minister just for this. He performed a really sweet, mountain themed wedding ceremony for Leli and Thomas with the rest of us looking on as the guests. I even got to be the ring-bearer. The wedding was a great way to cap off our time on the mountain.
After the ceremony, we took about 20 minutes to get all of our gear loaded up into our packs again so we could head down. I also wrapped up my toes, which were getting blisters going down the mountain. We moved quickly from Ingraham Flats to Camp Muir where we took another break to eat some snacks, get a drink, and load up the gear we had left at Camp Muir. Most of us also took advantage of having a toilet again (above Camp Muir, you are issued waste bags; you carry your solid waste off the mountain). Here’s our route:
Our stop at Camp Muir was pretty quick. With all of our equipment, we then started the descent on the Muir snowfield. My pack was lighter than on the way up as most of my food was gone, but I was also going down the snow, not up, which was much, much easier. I did my best to boot ski with Robin as much as I could and we made very quick time down the snowfield. There are spots on the snowfield where you can even sit and slide, as Tom did:
Tom sliding down the last section of the Muir Snowfield.
We stopped at the bottom of the snowfield to change out of our mountaineering boots (which was nice, since I developed two blisters under each of my big toes coming off the summit). We then pushed down to the lodge and parking area where Alpine Ascents had a van with a trailer waiting for us. We also had some fresh clothes there (we had largely been wearing the same clothes for the last three days). We changed and then grabbed one of the complimentary drinks Alpine Ascents had waiting for us. Here’s the route from Camp Muir to Paradise:
From there, we stopped at a restaurant just outside of the National Park for a late lunch/early dinner with our crew and the guides. It was nice to celebrate with all of them what we had done. After our meal, Alpine Ascents took us back to Seattle to their headquarters where we returned our rental equipment and said our goodbyes. Tom and I had another hotel lined up for that evening. We checked into the hotel, took much-needed showers, and did our best to clean up before collapsing into our beds for a deep (but short) sleep before our early flights home the next morning.
I’ll end with some brief thoughts on the hike. This was a tough hike. Without those extra 20 to 30 pounds in my backpack, I think I would have been fine on this hike. But hauling a 60 pound pack up the Muir Snowfield did come close to breaking me and I’ll admit that. Better packing and training with a heavier pack would have helped with this. I spent about an hour in the tent the second night meditating and using positive psychology and affirmations to convince myself that I could climb Mt. Rainier with the lighter pack. This is also a pretty technical climb with some really dangerous parts of the mountain. If the route was laid out and not at all dangerous, this would be doable with crampons, axes, and helmets. But, not knowing the condition of the route, the best way to do this hike is with good, reliable, and cautious guides, like those of Alpine Ascents. RMI was willing to take too many risks. I like climbing mountains, but see no reason to take such extreme risks. What’s the point of climbing these mountains if you don’t live to tell about the adventure?
This is definitely a hike that requires the right gear and solid preparation. It’s a beautiful, invigorating hike, but not for everyone.
For my work, a colleague and I decided to propose a new travel study course that would involve a combination of our interests – sociology of sport (hiking, specifically) and exercise science. Our original course proposal wasn’t approved, but our International Programs Office agreed to fund us to scout out a trek in Peru to improve our application and fill in details for the second time we propose the course. As a result, a colleague (Abe) and I spent a week in Peru in August of 2018. We spent a few days in Cuzco acclimating before heading out on the (Super) Salkantay Trek which covers about 34 miles (64 kilometers) in 3 days, ending in Aguas Calientes. The following day we took a bus to Macchu Picchu. This post is a brief summary of the trek.
We flew from Tampa to Miami on a Saturday afternoon and then from Miami to Lima that evening, arriving around 9:30. In retrospect, we should have spent the night in Lima and then caught a flight to Cuzco the next day after getting a good night’s sleep. Instead, we spent about 5 hours in the Lima airport (me trying to sleep; Abe pacing the airport) until our 3:50 am flight to Cuzco. The travel agency that arranged our trip included an airport transfer to our hotel which, unfortunately, wasn’t ready when we arrived at around 5:30 am. So, we kind of slept on couches in their lobby until our room was ready around 8:30. By that time, daylight was upon us so we went out exploring in Cuzco. We spent a couple of days in Cuzco exploring the city and the cuisine while acclimating to the elevation (Cuzco is at just over 11,000 feet). We visited some museums, tried a few restaurants, and even did a trial hike up to the Temple of the Moon, Q’Engo Chico, el Cristo Blanco, and Saqsaywaman.
Here’s the route we took:
Despite having spent a day in Cuzco, we could still feel the elevation as we hiked and knew it would take a little while to acclimate to this elevation.
In the afternoon on our second day in Cuzco, we met up with the rest of our group for the (Super) Salkantay Hike at the headquarters of G Adventures and met our guide, Ever. There were 16 of us total: 3 from the US, 1 from Canada, 2 from Switzerland, 2 from Denmark, 2 from South Africa, 2 from Wales, and 4 from England. We had a briefing session, had a chance to rent any gear we needed, and then were given duffels that would carry our sleeping bags and pads and any extra gear as we would only have to carry day packs during the day. Porters (using donkeys) would carry the duffels, tents, and food from campsite to campsite. Having just completed a serious climb of Mt. Rainier in Washington, this seemed like a walk in the park – let someone else carry all the heavy stuff and I just have to get myself from point A to point B every day. Elevation aside, I wasn’t expecting a particularly challenging hike.
On August 6th, we got up around 5:00 am, had a quick bite to eat at our hotel, then hopped aboard a bus that drove us out to the beginning of our hike (stopping for a more substantial breakfast on the way). We started hiking around 10:30. It quickly became apparent that we had different levels of hikers in our group, with several quickly falling behind. I tried to stay at the front as I didn’t want to get caught behind a slow hiker. Our guide, Ever, set a pretty good pace. About 30 minutes in, we started to have light rain and everyone donned their rain gear (for many, this was just light ponchos; luckily, I have complete rain gear for hiking – top and bottom). As we continued, we started to gain some elevation. The rain also started to get a little harder. As we got higher up in elevation, the rain started to transition into sleet. Eventually, it became snow. Basically, we were caught in a snowstorm on our way to Salkantay Pass, which is over 15,000 feet in elevation.
We continued our ascent and the snow got thicker. We stopped about an hour from the pass for lunch. The porters had set up a tent on about 6 inches of snow for us to dine in and had already prepared hot water so we could have tea and hot chocolate. They also made us a hot meal (soup and chicken tenders with rice). It was still freezing cold in the tent but we were largely out of the wind. I was generally warm with all my layers on (except for my hands in my light gloves), but there were many in our group who were much less prepared (one guy was in shorts the whole time). Additionally, one member of our group was slow enough that they had her ride a horse part of the way up the mountain.
After lunch, we continued up the mountain, eventually making it to the pass where most of us huddled behind a large rock to get out of the wind as best we could while we waited for the rest of our group to make it to the top. Our huddle reminded us of a bunch of penguins trying to avoid the cold.
A bunch of people in our group huddled together for warmth.
We stayed on the summit until everyone had made it to the highest point of our hike then began our descent down the other side. It didn’t take long before the wind died down. Then we descended below the snow line and were hiking in mud and light rain. We hiked until just after 6:00 pm when the first wave of us made it to the camp for the night just as it got dark enough to warrant headlamps. It was very cold and raining at the camp but the camp had some buildings with tin roofs (where we ate and the porters slept) and our tents were already set up. The stragglers took another 30 to 45 minutes to arrive in the dark with flashlights.
Here’s the route from the first day of the hike:
Per my watch, we covered 8.84 miles. Our starting elevation was about 12,562 feet; our peak elevation was 15,175 feet (highest I’ve ever hiked). The total elevation gained during the hike was 3,006 feet.
We had about 45 minutes to get our sleeping bags and pads set up before dinner. At dinner, we once again had warm drinks (which were a delight) and ate well. The guide also laid out the plan for the next day, which was the longest hiking day.
We went to bed around 9:00 but the hot drinks worked a number on our bladders. Abe got up to pee four times. I had to get up once, around 10:00 pm, to pee. Given the urgency, I didn’t put my pants back on and was caught in someone else’s headlamp in my underwear taking a piss. When you got to pee, you got to pee!
We were up again around 5:00. We packed up and were met with warm water to make tea and hot chocolate or coffee again. After our meal, we finished gearing up and getting ready for our longest day of hiking. Here’s a photosphere of the campsite:
Since we arrived when it was nearly dark, we really couldn’t see the amazing mountains that surrounded our campsite. In the morning, we had a few breaks in the clouds and realized just how amazing the location was. Alas, we only saw it for about 30 minutes before we headed down.
We had a lot of hiking ahead of us – all day. However, it was also all down hill. As we descended, we crossed from a high altitude mountain region into a wooded area and eventually into the rainforest. It was actually quite interesting as our guide said that we would know when we were in the jungle when we saw bamboo and palm trees, both of which I have in my backyard in Tampa, Florida – I guess I live in the jungle.
I tracked our hike from morning until we stopped for lunch (when I had to recharge my watch). Here’s the route:
We did 6.58 miles before lunch, descending about 4,000 feet.
We stopped for lunch for a bit over an hour. I made the poor decision to take my socks off to air out my feet to try to prevent blisters only to get bit about a dozen times by black flies in the 5 minutes I had my socks off. Terrible idea. My feet itched nonstop for the next three days!
Anyway, after a yummy lunch, we hit the trail again (though, at this point, three members of our group opted to take a van down to our campsite for the night). We hiked through a beautiful area surrounded by mountains and began passing plantation after plantation – corn, avocado, passion fruit, and squash were the major crops. We even stopped at one to break into a passion fruit:
We were hiking next to the Santa Teresa River for most of the afternoon. There was a road on one side of the river but people lived on the other side. In order to cross it, they built cable bridges and would pull themselves across, like the man in this video did:
Towards the end of the day, I was getting tired. It wasn’t hard hiking like the day before but we just kept going and going. We finally reached our campsite just as it was getting dark around 6:00 pm after hiking another 10.53 miles. Here’s the route:
Our campsite this night was basically at the far end of a town, La Playa Sahuayaco, and even had a small bar near our campsite (where we could get beer and pisco sours, which we, of course, got). There was also a hot shower here. We had another 45 minutes to set up our sleeping bags in the pre-arranged tents before dinner. After dinner, our guide explained that our porters would be headed back over the mountain the next day to prepare for the next group of hikers and from here on our gear would be transported by vehicle. He also explained what our hike would be like the next day – a steep climb up a mountain until we overlooked Macchu Picchu followed by a steep descent then a bit of a march to the train station where we’d catch a train to Aguas Calientes and spend the night in a hotel.
Our third day of trekking was as described. We had a relatively steep ascent up a mountain but it was definitely worth it. On the way, we stopped at one break area that had a pretty cool rope swing that allowed you to swing out over the mountain:
It was a short distance after this that we made it to Mirador Llactapata, which is an Incan ruin as well as a lookout spot over Macchu Picchu.
We stayed here for a bit then began our descent down the mountain. It was close to two hours of a steep descent. At the bottom, we crossed another rope bridge then walked for a bit to a train station where we had a late lunch then boarded our train to Aguas Calientes. After three days, we got to take a shower and sleep in comfortable beds. It was nice getting back to civilization. Total mileage for the day: 8.59 miles.
Our total mileage from the hike: 34.54 miles spread over three days.
One of the tasks I have to do regularly as part of my job is to compare two lists to see which items are missing on one list but not the other. I have been doing this by hand but figured there had to be a way to do this in Excel. I finally figured it out but don’t want to forget how to do it. So, I’m documenting it here so I can draw on this whenever I need to do it again.
Here’s the scenario. I have a list of “items” but every month or so I receive an updated list of “items” from someone else. During that month, some of the items on my list have been taken off and some have been added to it. Likewise, the same has happened to the other list that this other person sends me (I’m being really vague here because I work at a university and there are laws that govern academic records).
My list and the other list have to be kept synchronized but we have two separate databases that are used for this because… (argh, yeah). Anyway, what that means is that I have to compare the two lists and quickly find the items on one list but not the other and vice versa. Here’s how to do it quickly in LibreOffice Calc.
Here are two lists:
(NOTE: You can actually do this in two separate Calc sheets or within the same one.)
LIST 1 is in Column A and List 2 is in Column C.
In Column B I am going to create a function that allows me to search all of Column C to see which of the items in LIST 1 show up in LIST 2. Click in Row 2 of Column B then click on the Function Wizard (or start typing):
In the Function Wizard dialogue box, you’ll see this:
Search for VLOOKUP then double-click it and you’ll see this:
You now need to build the function. This is where I got confused, so I’m going to try to explain this carefully.
The first box is the “Search criterion.” Basically, this is what you want to find. In our example, let’s say that we want to see which items in List 1 are in List 2 (Hint: It’s apples and grapes.). So, we are going to put in the Search criterion that we want the software to search the items in column A or LIST 1. We do this by simply selecting cell A2 (you can do this by typing it in or by selecting it by clicking the button to the right of the box and then selecting A2 like I did below):
Next is the “Array” box. This is the content through which you want the software to search to find the items in LIST 1. Again, you can type this in or select it using the button to the right. However, there is an important change that you need to make here. If you select the array with your mouse and leave it as is, the values will change as you drag this formula down in Column B as it will assume you want to adjust the array as well. Since we don’t want to adjust the array but rather want to search through the same items in LIST 2, we need to put dollar signs before the letters and numbers in the Array which will lock the boundaries of the array into place so they don’t change when we copy the formula to other cells, as shown below:
The next part is the part that threw me off for a long time in figuring this out. The “Index” is the column in the Array you want to compare to the Search Criterion. In this case, all you need to do is specify “1” since there is only one column. But, presumably, you could have an array made up of multiple columns and want to choose just the 4th column (so you would enter 4 in the Index). Here’s how this looks:
Finally, the last box that is part of our function is the “Sort order” box. This tells the software whether the lists are ordered alphabetically or not. If they are not, enter zero (“0”). If they are, enter “1.” If you leave this blank, LibreOffice Calc thinks the lists are ordered. So, make sure you fill this out.
Once you’ve got that all entered, your formula should look like what I have above. Hit “OK” and it will search the Array C2:C7 for “bananas.” If it finds it, it will return “bananas.” If it doesn’t, it will return “#N/A” as shown below:
You can then, of course, drag this formula down. When it finds the item from LIST 1 in LIST 2 it returns that item. When it doesn’t, you get #N/A.
And there you have it. A LibreOffice Calc function for searching a list for a target and returning an indicator.
(NOTE: What I typically do after I have run this function is sort by the column where the function is located so I know which items are missing from LIST 1 and which are missing from LIST 2.)
