leeogrady

GoPro search for GPMF data - telemetry

Script to scan directories and tag (macOS) indicating GoPro telemetry present.

Requires

• Exiftool (https://www.sno.phy.queensu.ca/~phil/exiftool/)
• Tag (Brew install tag)

Usage

tag -r GPMF $(exiftool -FileName -ext MP4 -if '$GPSPosition =~ / [E,W]/i' -T .) &&tag -a GPMF $(exiftool -FileName -ext MP4 -if '$GPSPosition =~ / [E,W]/i' -T .)

leeogrady

Just before Log Ship

> t1 <- Sys.time()
> query <- paste0("SELECT TOP 20000 ObservationDate, * 
+                 FROM ValueHolder WHERE ObservationDate IS NOT NULL")
> 
> data <- data.table(
+   sqlQuery(EBConnection,  query = query)
+ )
> t2 <- Sys.time()

leeogrady

• Highlight column A
• Press CTRL + G
• Click Special
• Select Blanks
• Click OK
• Press =
• Press UP Arrow
• Press CTRL + ENTER

leeogrady

// HTML //
<div class="col-md-6">
    <div for='typeId' class="form-group">
      <label for='typeId' class="control-label" >Type</label>
      <select class="form-control" name='typeId' id='typeId' onchange='updateModel()' required >
        <option value=''>Select Type</option>
        <?php
          $qry = "SELECT * FROM trailerType ORDER BY name";
          if(!$res = $dbc->query($qry)) {

leeogrady

- Click anywhere within the data table
- Hit the key combination Alt - d - p to bring up the Pivot Table Wizard (which is not on the ribbon)
- Select "Multiple consolidation ranges" and click Next
- Select "I will create the page fields" and click Next
- Select your data table (in the example it's A1:E11)  and click Next
- Select the location and click Next
Now you will see a pivot table that looks just like your data table
- Click the Pivot table and in the field list uncheck Row and Column (and uncheck any Page Field, if present)
- Now select the cell with the single remaining total number and double click it.
The result is a new sheet with your data laid out one item per row.