Wednesday, 14 August 2019

How to post-process videos using Shotcut and Audacity (2019)


A. PowerPoint

Create slides for the video. Use the right template - match the colour to the topic.

B. Snagit

  1. Record video.
  2. Export each video as MP3.
Notes:
  • Use slides for the title, and each section. Use screen demo where possible. 
  • Do not capture video from the camera.
  • Pause recording (SHIFT-F9) when switching between slide and screen demo.
  • Keep each video to less than 5 minutes.

C. Shotcut

  1. Create a Shotcut project.
  2. Import MP3.
  3. Save the project.
  4. Cut out any fillers and dead time by splitting and removing. See Shotcut: Split a video.
  5. Save the project again.
  6. Export audio as WAV.

D. Audacity

Don't bother creating or saving an Audacity project.
  1. Import WAV.
  2. Save the project.
  3. Find any really loud noises (e.g. coughs, bangs) and replace them with silence. To do this, select the sound and click Generate, Silence.
  4. Run these effects:
    • Noise Reduction
    • Normalise (-1 dB)
    • Equalise
    • Compress
    • Normalise again
  5. Export as WAV, and put _cleaned in the filename.

E. Shotcut again

  1. Open the Shotcut project.
  2. Add the WAV file to the Playlist.
  3. Save the project.
  4. Add an audio track.
  5. Move the WAV file from the playlist to the audio track.
  6. Mute the audio on the video track.
  7. Export the entire thing as a video, using the default H.264 encoder and the MP3 format.

Shotcut: Split a video

See the last comment: https://forum.shotcut.org/t/easy-guide-to-split-videos/5085/7. From April 2018.


  1. Load the file into the timeline.
  2. Choose where you want to split it on the timeline, you’ll see a line. 
  3. Hit ‘S’ on the keyboard. 
  4. Select the part you want gone. 
  5. Right-click, Remove.
  6. Export tab. Choose your settings, then Export File.
  7. Back to Timeline
  8. CRTL + Z
  9. Select the other half to delete. 
  10. Right click, Remove.
  11. Export tab. Choose your settings, then Export File.

Tuesday, 6 August 2019

How to post-process videos using Shotcut and Audacity (2015)

This page lists the steps to prepare a training video. 

I created these steps while working on Symphony, in 2015 and 2016. Audacity & Shotcut have both changed since then, plus I'm not so concerned about file size. I'll set up a second set of instructions that work in 2019.

A. Set up the sub-folders


For your new recording session, set up a single folder that contains the following sub-folders:
  1. Snagit
  2. Audacity
  3. Shotcut
As you manipulate files with the various tools, save the output into the appropriate sub-folders.

B. Take the video

  • Take video using Snagit or any other tool.
Snagit can product MP4 files only, not MOV. Apparently MP4 is not great for editing. You can convert it using Shotcut.

C. Save the audio component as a separate file (Shotcut)

  1. Open the MOV file in Shotcut.
  2. Move the file to the Playlist, and then to the V1 video track.
  3. In the Encode panel, open the STOCK list then choose the WAV option.
  4. On the Audio tab, check the following:
    • Codec: pcm_s16le
    • Rate control: Quality-based VBR
    • Quality: 100%
  5. Click Encode File.
  6. Save the file in the Audacity folder. Name the file something sensible.








D. Clean up the audio track (Audacity)

  1. Open the new WAV file in Audacity.
  2. Check that it plays.
  3. If the track starts with a clap sound, select the sound and Normalize it to -22.0 dB.
  4. Run the following effects for the whole clip:
    1. Noise Reduction
    2. Normalize (to -2.0 dB)
    3. Equalize (use the 100Hz rumble filter, plus reduce the treble as shown on the right).
    4. Compress
    5. Normalize again
  5. Save the file as a new WAV file with -cleaned in the filename.

D. Merge the cleaned audio with the original video (Shotcut)

  1. Return to Shotcut.
  2. Ensure that the original MOV file is in the V1 video track.
  3. Open the cleaned WAV file.
  4. Move the WAV file to the Playlist, and then to the A1 video track.

E. Save the video for further editing (Shotcut)

If the video is now ready for release, skip this step, and jump down to G. Publish the video, which shows how to publish a video with a lower filesize but still acceptable quality.
If, however, you need to edit the video in Shotcut, save it first with a lossless encoder. You'll publish later.
  1. In the Encode panel, set up the video parameters:
    • STOCK: lossless/H.264
    • Format: mp4
  2. In the Video tab:
    • Resolution: 1920 x 1080.
  3. In the Codec tab
    • Rate Control: Quality-based VBR
    • Quality: 100%
  4. Click Encode File, and save the file into the Shotcut folder.
    Ensure that the new filename has the extension mp4.
Wait for a while as Shotcut encodes your file.

F. Edit the video (Shotcut)

Now that you have an MP4 video with clean audio, you can edit it. This includes deleting sections to remove "um"s etc, and shifting cuts around.
To sync the audio and the video:
  1. Open the Properties panel.
  2. In the Audio tab, use the Sync slider.


G. Publish the video (Shotcut)

  1. In the Encode panel, set up the video parameters:
    • STOCK: lossless/H.264
    • Format: mp4
  2. In the Video tab:
    • Resolution: 640 x 360
    • Frames/sec: 25
    • Scan mode: Progressive
  3. In the Codec tab:
    • Rate Control: Quality-based VBR
    • Quality: 65%
    • GOP: 180
    • B frames: 4
    • Codec threads: 2 (if you have a dual core machine)
  4. Click Encode File, and ensure that the new filename has the extension mp4.
Wait for a while as Shotcut encodes your file.

Monday, 7 January 2019

Identify the full folder path of an email in Outlook 2013

Open the email, then use CTRL-SHIFT-F to open the Advanced Find dialog. The Browse button reveals the full folder path.

Source: https://www.msoutlook.info/question/846

Monday, 1 August 2016

Visio: Horizontal scrolling with SHIFT-scroll

Visio can do cool things with the mouse scroll-wheel.

Here's what I like:

  • scroll only: Pan vertically
  • CRTL-scroll: Zoom
  • SHIFT-scroll: Pan horizontally
By default, Visio interprets SHIFT-scroll as zooming. To switch it to my preferred behaviour, do this:


  1. Select Tools, Options, Advanced.
  2. In the Editing section, deselect Zoom on roll with IntelliMouse.

Tuesday, 19 July 2016

Visio: Create an enormous org chart on a huge page

Visio has a lovely wizard that lets you automatically create an org chart from an Excel spreadsheet, or directly from Exchange.

However, if you have a large number of people, the wizard likes to chop up your tree into many pages, based on its own understanding of what will fit.

I actually want one single enormous tree on one enormous page. The wizard does not appear to handle, this, but it's actually really possible.
  1. Create a dummy org chart:
    1. Click New.
    2. Choose the template named Organization Chart Wizard, then click Create.
    3. Follow the steps to create the org chart from your data source.
  2. Delete the org chart that was created.
  3. Click Design, Size, than choose the page size and orientation that you want. For example, switch to A3 landscape.
  4. Create the real org chart:
    1. Click the Org Chart tab.
    2. Click Import to open the Org Chart Wizard again.
    3. On the penultimate wizard page, choose I want to specify how much of my organization to display on each page.
    4. On the last wizard page, ensure that only the most senior person appears in the Employee at Top of Page table.
    5. Click Finish.

Wednesday, 18 May 2016

Confluence: Find pages that use a particular macro

Here are the instructions fro Sarah Maddox: https://ffeathers.wordpress.com/2011/11/04/how-to-search-confluence-for-usage-of-a-macro/

It works in Confluence 5.8.

You search for the following, where x is the macro name:
macroName: x
For example:
macroName: excerpt-include