LosslessCut: Join/Merge Multiple Video Clips Almost Instantly

Let’s say you have a bunch of video clips and you want to simply join them together without any fancy transitions or anything. The clips could be from a bunch of short videos you took on your phone, action cam, or maybe even your security camera. In my case, I had 2 Wyze cam security cameras that recorded 24/7 footage to an SD card. Each video clip was one-minute long grouped by folder indicating the hour of the day and then grouped by day of the year.

Your first thought might be to drag all video clips to a video editing tool like Adobe Premiere or Corel VideoStudio and render one combined video. I tried that using VideoStudio but it had to reencode all clips which took a long time. Also, the resulting file size was huge because the lowest encoding settings available were much higher than the source audio and video settings.

LosslessCut

LosslessCut describes itself as the swiss army knife of lossless video/audio editing.

 The main feature is lossless trimming and cutting of video and audio files, which is great for saving space by rough-cutting your large video files taken from a video camera, GoPro, drone, etc. It lets you quickly extract the good parts from your videos and discard many gigabytes of data without doing a slow re-encode and thereby losing quality. Or you can add a music or subtitle track to your video without needing to encode. Everything is extremely fast because it does an almost direct data copy.

Download LosslessCut

The thing I hate the most about video editing is how long it takes. I tried LosslessCut to join 60 video clips and it completed almost instantly. Drag the files to the window.

LosslessCut will allow you to sort the files. Just drag a file to the position where you want it to go. Check the “Include all streams?” checkbox and click “Merge!”

Missing Audio

In my case, I couldn’t use LosslessCut directly with the mp4 files from Wyze Cam. I would get this error.

I then converted each file to MOV and then I was able to merge each MOV file. But, when I imported the MOV file into Corel VideoStudio, there was no sound. This seems to be a common issue for many people. Apparently, the audio codec used by Wyze Cam is some unknown one. To remedy this, I first batch converted all video clips using HandBrake while keeping the audio and video quality almost the same. In the screenshot below, you can see the audio is being converted from “1 Unknown” to “160 kbps AAC).

After batch encoding all video clips, I was able to merge them instantly using LosslessCut.

Free Topic-Based Communication Tool for Small Groups Like HOAs

I’ve used many enterprise-level productivity tools like Atlassian Jira, Confluence (Wiki), Microsoft Teams, Asana, and, of course, email. Asana seems to be the best for managing large projects that have multiple tasks and deadlines. Microsoft Teams is great for having discussions separated by topic and sharing documents related to each discussion. As the president of an HOA (Homeowner’s Association) that pays an experienced property manager, it’s interesting that we’re still communicating by email because so often we’d have a hard time finding specific information and documents. Microsoft Teams would be a big improvement but the free version doesn’t come with some useful features available in the paid version. Of all the tools I’ve used, it looks like Slack fits the bill because 1) there is no bill (pun intended – there’s a free version) and 2) it comes with features similar to the ones in the paid version of Microsoft Teams. This post will explain some of Slack’s features that could be beneficial for small groups like an HOA.

Separate Discussions By Topic

One of the problems with a simple chat tool is different topics get lost in one super long chat. At my HOA, we have different topics to talk about, e.g. landscaping, security cameras, parking, etc. With Slack, you can create multiple channels to represent these topics. Each channel is a separate chat discussion as you can see in the screenshot below.

In the screenshot above, you can see:

  • Group Name: Antoine Ct Landlords
  • Channels: These are discussion topics:
    • landscaping-cleaning
    • security-cameras
    • vehicles-and-parking
  • Direct messages: this shows you who is in the group and allows you to send a message directly to one specific person
  • Apps: you can see the list of apps you’ve integrated with Slack such as a polling app

In the screenshot above, the chat in view is the one for the landscaping-cleaning channel.

Apps

Slack allows you to integrate many apps for a seamless experience. Below are some of the apps you can integrate.

One thing we often do as an HOA is conduct polls. You can add a polling app and then create a poll in a channel. For example, I added the Simple Poll app and created a poll in the landscaping-cleaning channel. In the screenshot below, the simple poll asks if everyone wants to hire one landscaper for all units and split the cost. The answer options are simply yes and no.

Of course, if there is too much chatter, the poll can get buried in the history of chat messages. If that happens, you can pin the poll to the top. It then shows up in the bar at the top of the channel like this:

Chatting is useful, but eventually you’re going to need other productivity tools like documents, spreadsheets, presentations, etc. In the chat field, you can click the + button to insert things other than text, e.g. create a post.

A post in Slack is like a Google or Word doc.

If you prefer to use a different tool like Google Docs, you can link the Google Doc to your Slack channel. Just copy the Google Doc share URL and paste it into the chat and, optionally, pin it to the top as I did for the poll example above. Or, you can create folders in the bar at the top of the channel to organize documents and chat messages. In the screenshot below, I clicked the + button to add two folders: Documents and Photos.

I then hovered over the Documents folder link and clicked Add to bookmark to add links to external resources:

  • Test Document 1 (link to a shared Google Doc)
  • Association Website (link to a WordPress site)

Multiple Teams

If you are part of multiple groups or teams of people, you can create a separate Slack group (called Workspaces). In the screenshot below of the Slack homepage, I see the workspace for the example HOA group mentioned above called “Antoine Ct Landlords”. There is also a button to create a new workspace.

If you are part of a small (or large) group of people and need to discuss many topics and don’t want to pay a monthly fee, you may want to give Slack a try.

Calculate Frequency of Unique Values in Google Sheets

I’m often finding myself needing to calculate the frequency of unique values in a spreadsheet. It turns out it’s a 2-step process. For example, if you have a column of data as shown below and you want to know how many times the numbers 1, 2, and 3 occur, you need to first add a column containing the unique values in column 1. Then, you can use the frequency function to calculate frequency.

1. Get Unique Values

In column 2, get the unique values in column one using the unique function:

=UNIQUE(A2:A7)

If you want, you can also sort the values as follows.

=SORT(UNIQUE(A2:A7))

2. Get Value Frequency

In column 3, get the value frequency using the frequency function. The data is in column 1 and the classes are in column 2.

FREQUENCY(data, classes)

=FREQUENCY(A2:A7, B2:B4)

Google Sheets seems to want to add an extra row with the value 0. I just ignore that.