Tag Archive for 'Excel'

…AC/DC rocks your Excel spreadsheets?

ACDC Excel

Phil Clandillon and Steve Milbourne have created what they call “the world’s first music video in Excel format” for AC/DC’s Rock N Roll Train.

By creating the entire video in Excel, the two are able to bypass and subvert even the most restrictive of corporate firewalls, allowing you to rock out any time you want.

If you’d like to download the original (Windows only) Excel file, it’s available at the AC/DC Rocks site, or you can view it in YouTube format here:

[AC/DC Rocks - Excel]

…The Facebook Page is growing?

Facebook

Last week I announced the launch of the DidntYouHear.com Facebook Page, and since then, 25 people have already signed up to be fans, which is fantastic, so a big thanks to everyone who joined!

I also announced that I would be picking out one fan at random and giving them a $10 Amazon Gift Card, so thanks to the magic of Excel’s =rand() function, Alice Chang has been selected. Congratulations!

If you haven’t already done so, then check out the Facebook Page and click “Become a Fan”. I’ll be doing exclusive content and contests there just for the Facebook Fans, as well as adding games and more to interact with on the page, so it should be fun.

See you there!

[Facebok - DidntYouHear.com]

…iPaper is a PDF killer?

iPaper

Apparently the web world is fed up with PDFs, because alternatives are popping up left and right.

The latest entry into this world is iPaper, which aims to entirely replace the PDF.

The basic idea is that, like a YouTube video, iPaper documents can be embedded into any existing web page through a Flash widget, and can display PDF, Word, PowerPoint, Excel, and other document formats without the need for separate readers.

Features include viewing documents without downloading any additional software, monetizing documents with integrated advertisements, social aspects with a built in share functionality, enhanced security, and easy integration.

Edit: Box.net, a free online storage and file sharing site, is one of the first sites to embrace the iPaper technology. You can now view any of your PDF, Word, Excel, or Power Point documents that you have stored on Box.net using iPaper.

iPaper Comparison Chart

[Scribd - iPaper]

…The Swag Bag winner has been announced?

The Swag Bag

And the winner is…

wendy_q420

Congratulations!

Just to clarify my methods, I put each name that entered the contest into an Excel spreadsheet (there were 6 names) in the order that they commented. (stephen first, superdude4agze second, etc.)

Then, I created a formula to randomly pick a number between 1 and 7 (1.00->6.99). The formula was RAND()*(7-1) 1. The number that it came up with was 4.1001456. Thus, since the whole digit was 4, wendy_q420 was the winner, as she was the fourth person to comment.

If anyone sees any fault with the above logic, please let me know, and I’ll draw again. Otherwise, keep an eye out for the next Swag Bag giveaway!

…Some small annoyances need to be fixed?

There are a few minor things on my computer (PowerBook G4) that have been bothering me for a while now, so I finally decided to sit down and figure out what needed to be done to fix them. If you share my annoyances, here’s what to do:

First, when you install Adobe Acrobat Professional, it puts a PDF Toolbar in Excel, PowerPoint and Word that automatically pops up when you open each program.

PDF Toolbar

I never use either button on the toolbar, and when I want to make a PDF I just use the “Save As” option, so I wanted to get rid of the toolbar entirely. Unfortunately, you can’t just deselect the toolbar in the View/Toolbars menu, since it just comes back the next time you start the program, so you need to:

  1. Go to: /Applications/Microsoft Office/Office/Startup/
  2. Open the Excel folder
  3. Trash PDFMaker.xla
  4. Open the PowerPoint folder
  5. Trash PDFMaker.xla
  6. Open the Word folder
  7. Trash PDFMaker.xla

That should solve the recurring toolbar problem once and for all.

Second, when you install Adobe Creative Suite, it a bunch of .exe droplets that can be used to quickly edit photos and documents with common changes. Each of these .exe droplets shows up in my “Open With” menu when I go to open a photo (I use a variety of photo editing programs to edit photos for DYH, so I do this a log). Again, I never use any of the droplets, and they just make it harder to find the program that I really want, so I decided to get rid of the droplets entirely. Unfortunately, you can’t edit what shows up in the “Open With” menu (Dear Apple, I would love this function), so you need to:

  1. Quit all running applications
  2. Use Finder’s search funcion to find all .exe programs
  3. Delete the Adobe ones that you don’t use
  4. Go to /Macintosh HD/Library/Caches/
  5. Trash com.apple.LaunchServices-0140.csstore
  6. Trash com.apple.LaunchServices-014xxx.csstore (xxx is your uid number)
  7. Restart your computer
  8. Empty the Trash

For some reason, Adobe doesn’t play nicely with user customizable options. It would be nice to just disable certain options, but if you can’t do it the easy way, there’s usually a hard way that gets the job done. Just make sure to create backup copys of each file if you’re worried about bricking your computer.

Sometimes it’s the little things that can make all the difference.

[Removing PDF Toolbar via: Kassblog]

[Resetting Launch Services via: The X Lab]




Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 License.