Create a Slideshow of Excel Images

This article will cover the steps of how to assemble and export such a file to YouTube in an Apple iMac/Performa platform environment will be covered in this article. Watch by tapping the green font link of the video slideshow, "Electron Eggies Spiritual Adventure" below in YouTube before proceeding, and then in YouTube use the browser's back button to return here.

Steps

  • Get to know the main image:

The Tutorial

  1. Click on the green text to watch the slideshow video and press ESC or your Back Button to return here: Electron Eggies Spiritual Adventure
  2. Create the story's images. See Tips below for the storyboard progression for this video.
  3. Save the images as JPG files by doing Copy Picture and Paste Picture in Excel, then Copy and open the application Preview and do File New From Clipboard. Then export as JPGs to a unique file folder.
  4. Open iPhoto and Import all the JPGs in their correct storyboard order insofar as possible. Do Import to Library, and collect all the JPGs from Preview into iPhoto. Open the Last Import folder if not already open and your pictures are showing. Select each photo in its proper storyboard order and set its keyword to a consecutive numeric order, e.g. 001, 002, 003, etc, Select all and sort by keyword. Do Create Slideshow with the button at the bottom right. Copy and paste any JPGs that appear twice in the storyboard order in the upper storyboard frame, and any JPGs that need to appear for double the standard duration per the narration.
  5. Set the Settings and Music to fit taste and idea. If adding music, be aware that YouTube may consider the music that Apple provides with iPhoto to be copyright-protected, and fail the import on that account. So be sure to have the rights or permission to the music, if any, being added. Dissolving from one frame to the next may be preferable. If narrative is added in iMovie, set Music to None. It would certainly be wise to choose to create a new album and store a copy of all the photos altogether in it.
  6. Set the Theme. Ken Burns may be preferred; others work as well. Experiment until satisfied.
  7. Export via the bottom center button. Choose Medium typically and to Automatically send it to iTunes, which then quit when it opens.
  8. Go to Finder on the Desktop and open Applications; open iMovie. Do New Project. Select the project type in the upper left, No Theme, with the house as it gives the most creative freedom.
  9. import the stills per the Camera Icon at middle far right, from iPhoto's Imported Slideshows folder. Select a picture then do Select All and drag them over to the Projects frames. The way to set up is with Projects on the bottom and Events on the top, preferably, and there's a two-arrow flip button to exchange the two in the far left middle of the iMovie app screen.
  10. Double-click on the microphone icon in the center Editing bar and set the microphone settings. If you will use the built-in microphone for input, block out about 65% of the background noise, especially if living by a freeway and the trucks sometimes honk at each other, plus, there are a lot of convalescent hospital nearby so there's also a lot of ambulance sirens, not to mention the noisy terrier across the street! In other words, carefully gauge the background noise likely to affect the recording and adjust for it.
  11. Play the video several times with the microphone off and do a mock voiceover until comfortable what will be said and when it will be said are known. Then, when ready, tap the mic icon and begin speaking after just a half-second or so.
  12. Finalize the project by selecting that option from the File menu.
  13. Open YouTube in the browser and click on Upload File when the home page is reached, else set up a home page first in YouTube. Drag and drop the iMovie file from its file folder into the YouTube import box and wait while it uploads the file. If it's going to be over an hour, the file may exceed YouTube's 15 minute size requirement / allowance, so then pare it down with selective editing (this may be an outdated limit). Name the file and watch it to make sure it uploaded correctly with the sound intact, etc. But wait and see if it uploads anyway even if it's long: importing about 63 photos has been successful. You're done!

Storyboard Progression

  • Storyboard progression of the video: In the story of Electron Eggies Going On A Spiritual Adventure, the story is narrated from the viewpoint of a Math Professor who visits their Mother Planet just as the Eggies return. Given this idea to go by a spiritual inspiration, carried by friendly electrons, he goes through a portal called a Tekeporter and then through their Tekeporter. He come upon a bright radiant star-planet which converts itself chemically into a cloud-covered shy moon-like planet and then opens a receptacle in herself to receive her children and a Father Photon, which makes the relatives all jump for joy (as in the picture above). The Electron Eggies are in the 4th Dimension and flatten out to join their relatives in the 3rd Dimension of space-time as they return. Then they enter their Mother, align, and everyone aligns, and the receptacle closes as a new stage of Life begins for them. Lessons are given on electron theory and math along the way and on the square root of 1 being seemingly unequal to 1 squared and 1 cubed. Returning to Earth to document the trip by making the slideshow video, the images are mostly formed from the Garthwaite Curve, which is a ring of spheroids, much like the lighter yellow ring in the background of the picture above, via a series of duplications and random placements or spiral formations, etc. The planet as a star and moon-star are made from the same curve, as are the teleporters / tekeporters, and also the lessons. By following this single theme, the story gains a certain oneness of identity and clarity in its mythology.
  • More Excel animation can be found in the Related WikiHows below in the article How to Create Floral and Other Images with Trig and Neutral Operations.

Helpful Guidance

  1. Make use of helper articles when proceeding through this tutorial:
    • See the article How to Create a Spirallic Spin Particle Path or Necklace Form or Spherical Border for a list of articles related to Excel, Geometric and/or Trigonometric Art, Charting/Diagramming and Algebraic Formulation.
    • For more art charts and graphs, you might also want to click on Microsoft Excel Imagery, Mathematics, Spreadsheets or Graphics to view many Excel worksheets and charts where Trigonometry, Geometry and Calculus have been turned into Art, or simply click on the category as appears in the upper right white portion of this page, or at the bottom left of the page.

Related Articles

Sources and Citations

  • "CRC Standard Curves and Surfaces", David von Seggern, 1993, CRC Press Inc., Boca Raton, FL. ISBN 0-8493-0196-3, Library of Congress Card Number 92-33596, [pp. 264 7.1.4 Spherical Helix]
  • The source workbook for this article is " EGGIES.xlsx", including spaces.