This post is to show the formulas used in this video.
To find duplicate rows:
=IF(COUNTIFS(A2:A$2,A2,B2:B$2,B2,C2:C$2,C2)>1,"Duplicate","")
To find duplicate cells:
=VLOOKUP(A2,'West Storage-1'::A$2:A$11,1,FALSE)
Category: Cloud Software
Software that operates, at least partially, online
Extracting GPS Data from GoPro Videos
Did you know that GoPro videos contain embedded GPS data? You can use this data to track your location and speed during your activities. In this article, we’ll show you how to extract GPS data from GoPro videos using the Telemetry Extractor software.
Step 1: Import your GoPro videos
Find the video with the GPS data you want on the GoPro. Open the Telemetry Extractor software and drag your GoPro videos onto the main window.
Step 2: Merge your videos
If you have multiple GoPro videos that you want to extract GPS data from, you can merge them together into a single file. To do this, click the "Merge" button and select the videos that you want to merge.
Step 3: Extract the GPS data
Click the "Extract" button to start extracting the GPS data from your videos. The software will create a new file for each video, with the GPS data saved in a GPX format.
Step 4: Export the GPS data
Once the GPS data has been extracted, you can export it to a variety of different formats, including GPX, CSV, and KML. To do this, click the "Export" button and select the desired format.
TripTally
Get distances between hundreds of locations
Using the GPS data in After Effects
You can also export the GPS data to an After Effects file. This allows you to overlay the GPS data on your videos in After Effects. To do this, select the "After Effects" format when exporting the GPS data.
Conclusion
That's it! You have now successfully extracted the GPS data from your GoPro videos. You can now use this data to track your location and speed, or to overlay on your videos in After Effects.# Sample Markdown
Find and Work with Distances in Google Sheets – TripTally
Google Sheets is a versatile platform that can be enhanced with add-ons to increase productivity and provide users with valuable tools. One such add-on, TripTally, is an efficient solution for managing and tracking travel distances and times using Google Maps. In this article, we’ll explore how to use TripTally to streamline the process of tracking travel distances and times in Google Sheets.
The first step to using TripTally is to install the add-on from the Google Workspace Marketplace. Once installed, TripTally will appear as an option in the Google Sheets sidebar.
To get started with TripTally, you need starting and ending locations in separate columns. These columns will form the basis for tracking your travel distances and times.
Give the add-on the location of your addresses and click Run. TripTally will retrieve the distance and time for your trip from Google Maps and populate the corresponding cells in the “Distance” and “Time” columns.
TripTally also offers customization options to fit your specific needs. For example, you can add additional columns to the sheet with a link to the route or the mode of transportation used.
Overall, TripTally is a valuable tool for anyone who needs to keep track of travel distances and times. By simplifying the process of retrieving and organizing this information from Google Maps, TripTally allows users to focus on their travel plans and ensure they are staying on schedule.
Watch the videos
Special Characters in Google Sheets Formulas
Hey all. I wanted to correct the content of this video. I said that special characters couldn’t be used directly in formulas. That’s not the case. You just need to surround them in quotes like any other string. This was not the video’s main point, so hopefully you still found it helpful!
– Adam Steinfurth
Visualizing Changes in Stock Data Using Google Sheets
We imported stock data using the GOOGLEFINANCE function in our previous post; now we’re creating visuals with that data. The historical stock prices and changes in those stock prices are shown in this table.
As we are only interested in the change over time, let’s clean up this table a bit. We’ll delete the stock prices and keep the percentages of change. Before you delete the prices, copy the percentages and paste thems as values. That way, the percentages will no longer rely on the formulas being deleted.
Now you can safely delete the columns with the stock prices. Our data is cleaned up and ready to go.
Using a Chart to Visualize Stock Data
The obvious tool to visualize changes is a chart. You can create a chart using the Insert menu, but we’ll choose the easy way. Google Sheets has a tool called Explore. This tool anticipates the most useful graphical insights and offers them in a sidebar. You can pick from the options and insert them into your spreadsheet. Using Explore will significantly reduce the steps needed to create a chart. First, we’ll highlight the range we want, including the headers, then click the Explore button.
Let’s use this chart suggested by the Explore tool. It helps us see the changes in share price over time for each of the four stocks. Insert this chart by dragging it with your mouse into the spreadsheet. Now let’s look at another method to see the data.
Custom Formatting to Show Changes
We are familiar with charts but can also illustrate change through custom number formatting. One advantage of custom formatting is that it sits inside the cells. This allows the illustration to be contained within the data. Also, custom formatting scales better as it can be used in as many rows as needed when a chart gets too busy with lots of data.
First, let’s highlight the cells to be formatted then go to the Format menu, choose Number, then Custom number format. This brings up the Custom formatting options.
Once you choose Custom number format, you will get another window. This window is where we tell Google Sheets how to format numbers when negative and positive. Since we can differentiate, we can make the formats look different depending on the direction of change – negative for down and positive for up.
Custom Formatting Syntax
Let’s use the input box of the Custom number formats window to create a new custom number formatting rule. We will start with the basics.
Input
0; -0; “-”
Output
Formats a positive number as 0
Formats a negative number as -0
Shows zero as a dash (“-“).
Add Color to Custom Number Formatting
As stated earlier, you can add colors to your numbers for easy understanding.
To achieve customized color for your data, type the following syntax:
0[Green]; -0[Red]; ‘-‘[Black]
NOTE: The name of the color for each number format will come after each of the numbers in parentheses. Make sure you enclose the color for each cell in square brackets. The name for positive numbers is GREEN. Negative numbers are assigned RED. Zero will appear in BLACK.
How to Insert Special Characters in Your Data in Google Sheets
We’ll add arrows to the formatting to emphasize the direction of change. However, there is no built-in option to insert special characters.
To achieve this
- Go to the Google Workspace Marketplace and grab a copy of the Insert Special Characters Add-On.
- Install the add-on and use the new sidebar to select and insert the characters.
Use these triangles in the custom format rules with a triangle pointing up to show and increase and down to show a decrease.
Now apply the completed rules to the table of percentages. You can see the trends more clearly now with the help of colors and arrows.
In conclusion, the techniques shown in the article will help you tell the story of your data in the most compelling way possible.