How To: Make flash cards using Microsoft Word and Excel

I’ve been trying to figure out how to do this for a while and now that I finally figured it I thought I’d document it 🙂 Hope someone finds this useful! Also a great way to print out cards for board games on both sides This may seem like a very tedious process but it’s nice when you are printing 100-200 cards. Also P.S. my printer messed up a couple of times and I had to re-print some of the words by deleting the messed up prints. Sorting/aligning words and definitions and printing again.

I got a bit of help from the links below
Sources:
Changing layout of word document: https://www.youtube.com/watch?v=NI0MG05OojQ
Using Mailing merge document: https://smallbusiness.chron.com/merge-excel-data-word-documents-54185.html
Center text vertically: https://www.howtogeek.com/240521/how-to-center-text-vertically-on-the-page-in-microsoft-word/

1) Preparing the excel spreadsheet

  • Open a new spreadsheet and on sheet 1 place two columns with headers “front” and “back”
  • Now fill in the corresponding information for front on column 1 and back on column 1

2) Preparing the word document

  • File> New blank document
  • Layout>Page Setup>bottom right corner
  • Margins Tab
    • Change margins to 0.5″
    • change to landscape
  • Paper Tab
    • width: 8″
    • height 5″
  • Layout Tab
    • Change Page Vertical alignment to Center
  • Click OK

3) Import/Auto-fill with Excel words

Mailings Tab> star mail merge >Start Mail Merge> Step by step mail merge wizard
step 1 Select Document –>
Letters
step 2 Select Starting document –> use current document
step 3 Select recipients –> use and existing list and browse for excel sheet (with header in sheet one with one column)
step 4 Write your letter –> click on…more items and select column header and press insert
step 4b –> Now format the text size( ~100) and set align horizontally
step 5 Preview your letters –> Nothing really to change, click next
step 6 complete merge –> Click on “Edit Individual Letters” Merge records, select ALL
* Now fix any of the cards where the text is overflowing into the next card. Highlight and change text size to something smaller.

4) Print front of cards

  • Now you should be able to print these cards in the order they appear in the excel column
  • Note: Also there seems to be a error in the last card with it not being centered. Print a blank card at the end of the list.

5) Back Side

  • Repeat with Column 2 inserting “back” instead of “Front”
  • Generate another set of pages with the back text on all the cards. Font size should be about 30 depending on the index card size and amount of text.
  • Make a note of how your printer is printing relative to how you load the index cards into the paper feed
  • Load the cards in order of how you previously printed the words or the definitions won’t match up
  • Repeat this guide to create a set of cards with the definitions based on the excel sheet.

How to: Get Matlab to recognize visual studio c++ 2017 compilers

First of all, be sure to install c++ compilers 2017 from visual studio, they aren’t automatically selected during the install

If Visual Studio Compilers C++ 2017 aren’t detected you need to add an entry to the registry.

Edit Registry
Matlab Source
Edit Registry

As an admin, edit registry entry:

HKLM\SOFTWARE\WOW6432Node\Microsoft\VisualStudio\SxS\VS7

Add a new “string value” called “15.0” and add a path to the following folder containing visual studio

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\

Start matlab and check that the compiler is found

mex -setup -v

Review/Tips/Installation: Reverse/Backup Car Camera

I’m not great at parallel parking, and telling the dimensions of my car. After watching my brother effortlessly parallel park with his backup camera, I decided I needed one on my car. Unfortunately my car is an old 2007 Honda Accord that doesn’t have a camera by default, and a custom installed camera will be expensive. I decided to do some research on a backup camera and finally install one myself.

Camera:  Generic Camera and Display by seller DoHonestBest






Tips on installing!

  • Install a noise suppressor in case your car’s engine creates noise on the video feed. (Common for older cars) it’s easier to install as your are wiring everything else
  • Before Routing camera through car (this will save you a lot of time)
    • Install camera on license plate
    • Center/calibrate camera’s video feed with display (see video for details)
    • Go to a parking lot and park your car, using button on camera, align/adjust camera guides. You will have to have the display within reach of the cameras adjustment button.
    • Continue routing display wire through the car

How To and Review: Lightworks

Problems and solutions!

  • Multi Cam video out of sync (GoPro and phone video)
    • Convert using Handbrake to Constant frame rate
    • If you make proxies with variable frame rate and import your high quality video, the proxies will still be variable frame rate and wont edit correctly.
  • Constant loading of app, cursor turns to spinning wheel every other second when clicking through clips.
    • Right Click on clip>Media>Create Proxy
    • Click on
  • Switching camears in Multi-cam view not working
    • Switch to flexible layout, multi-cam functionality not possible in fixed layout
  • Move Lucy to a different spot
    • Move preference box to a location you want Lucy to be, right click Lucy and  drag to the place you want her, then let go and quickly click on the “save preferences” Button
  • Sync Multi-Cam video ( Make sure you have Constant Frame Rate on video first!)
    • https://www.youtube.com/watch?v=NjpdVp11MsA
  • Cutting Clips
    • Place red cursor on video and press c or del, then right click and close gap, this doesn’t work on tracks with multiple video!
    • use in-point and out-point, place track where you want to make initial cut, then press “i” then take red cursor to last point and press “o” then press delete
  • Edit audio and adding keyframes
    • Hover over the audio track with your mouse and hold SHIFT. This will let you add keyframes to the audio in order to adjust the levels
  • Using Proxies (for lightning fast editing!)
    • Right click clip>Media>Make Proxies
    • Click on project title>Video>Playback Media Quality>Lowest available
    • https://www.lwks.com/index.php?option=com_kunena&func=view&catid=26&id=122511&Itemid=81

How To: Fix the Soldering Iron Error “S-E” or “5-E” (Kendal 852D++)

I took out my soldering iron ready to soldering random stuff and was very sad to find that it was displayed the error “S-E” or “5-E” instead of the temperature displayed. I quickly googled some stuff quickly realized that the soldering element had gone bad. I’ve had the soldering iron for about 4-5 years and it’s always worked great, never dropped it or was rough with it, but eventually the heating element will go bad.

Read more