Excel Web Survey vs Google Form

Which number formats are most popular in pivot tables? I have my guess, but wanted to see what other people thought.

So, I decided to create a survey in SkyDrive, using the new survey builder feature. Well, it’s new to me – I can’t remember how long it’s been available. Things didn’t go well, but the survey is included at the end of this article.

Build the SkyDrive Survey

I logged into Skydrive, and found the commands to build the survey. You can start one from the main panel, which is handy.

skydrivesurvey

Or, start a survey from the Excel Web app.

skydrivesurvey03

It was easy to create the questions – the survey builder has a clean layout, with the question setup opening at the side.

skydrivesurvey02

In a few minutes, my survey was ready to share.

Share the Survey

There was a button to create a link to the survey, so I entered that in Firefox, to test the survey.

skydrivesurvey01

It worked well, but the results aren’t date stamped, and there’s no built in charting of the results. Half the fun of taking a survey is in clicking that button, to see how other people have responded.

Also, I couldn’t see a way to create embed code, to put the survey on a blog. There might be a way to do that, but it’s not obvious to me.

So, that SkyDrive survey attempt was a disappointment!

Back to Google Docs

I headed over to Google, where I had created surveys before, and built the same survey in a couple of minutes.

To the Excel Web Survey’s credit, I did find it slightly easy to follow the flow of setting up the survey, and making edits to the questions.

Share the Google Survey

After building the survey, you can create a link, or get the code to embed it in a website. So, I followed the link, and filled in a survey, to make sure it was working correctly.

When you complete the survey, you’re offered the chance to see the results. Nice!

googlesurvey02

And, back in Google Docs, I can see the survey results, and each record has a date/time stamp.

googlesurvey01

I hope they add these features to the Excel Web survey tool soon, because they are deal breakers for me!

Please Take the Number Format Survey

Anyway, here is the completed survey form, so please answer the 3 questions to help me see which number formats are most often used in pivot tables. Thanks!

And here is the link, in case you can’t see the embedded form below.

______________

What I Learned This Week 20130427

What goes well with that first cup of coffee in the morning? Internet articles on my RSS feed! I find Excel stuff, web design ideas, small business tips, and lots more.

On the Contextures blog, I’ve listed a few interesting articles about the Excel formula fiasco. Here are a few other things that I found interesting this week, during my morning read.

Programmer Skill People Rarely Ask About

At the_codeist(), Andrew Wulf writes about an important skill that programmers need these days – the ability to find information online, and select the best option from a wide variety of posted solutions.

“You have to be able to enhance your brain with the collective brains of millions of fellow programmers, yet still pick the right brains to build on.”

Access 2013 Bible

access2013bibleDick Kusleika was too tired to write anything more than, “It’s here”, after he and Mike Alexander finished their epic book – Microsoft Access 2013 Bible.

No wonder Dick is tired – the book runs 1296 pages, and it weighs 1.6 pounds! I’ve written books that were much smaller than that, and am still recovering from exhaustion.

Congratulations to Mike and Dick, and if you buy this resource, I’m sure you’ll get far more than your money’s worth.

14 Ways to Acquire Knowledge

At the Brain Pickings blog, there is a list of 14 ways to acquire knowledge, from a 1936 book, You Can Do Anything! Apparently the author, James Morgan, was a bit eccentric – “in 1948, he publicly claimed to own outer space and went on to found the micronation of Celestia.”

The list has some sound suggestions though, such as “Walk Around It” and “Put in Order”. Of course, Excel is the obvious tool for that, but it hadn’t been invented in 1936.

Dandelions Will Grow Anywhere

Finally, I also learn things when I’m not at the computer. On a walk through the local conservation area yesterday, I learned that dandelions will grow anywhere, even under a rock. And they look pretty, when they’re not in your front lawn.

dandelions20130426

____________________

Solving the Mystery of the Disappearing Disk Space

Last December, I got a new laptop, and have been using it for most of my work since then. I store client files, blog posts, sample Excel files for my Contextures website, and a few too many digital photos.

The laptop has about 1 TB of disk space, so I should be okay for a while – or so I thought.

Almost Out of Space

Last week, I noticed that the C drive was almost at capacity – it was showing a red bar in Windows Explorer. Yikes! I didn’t ever run into that problem in the old laptop, and I used it for a few years.

What was filling up the drive? Had I really taken so many photos that I’d hit the limit?

Then I noticed that my storage space had been split into 4 drives, and the C drive only had 186 GB. So, I moved all the photos, and some of the documents to the other drives, and that temporarily solved the problem.

Can’t Open Outlook

Then, a crisis hit – Outlook wouldn’t open because it didn’t have enough disk space.  I moved a few more files to the other drives, emptied the Recycle Bin, and got Outlook running again. Whew!

But I can’t work like that – I don’t want to be constantly worrying about disk space. What was filling up the disk, and how could I get that stuff into a different drive?

Check the Folder Properties

I started through the folders again, checking each one’s properties, and looking for unusually large items. Was a program taking more that its share of the space? Was Windows 8 the culprit.

Finally, I found one of the Temp folders, in the AppData > Local directory, and it looked pretty full. Sometimes an installation file gets stuck in there, and they can be a few hundred MB in size.

I sorted the list in descending order by file size, and was shocked to see this item at the top of the list. It was a text file, named toolbar_log.txt, and it was 53 GB!

toolbar_log.txt

Of course, Notepad++ couldn’t open it, because it was so huge, so I couldn’t see what was in the file. A Google search showed that it was a file created by the AVG security software, and other people were complaining about its size.

Delete the Rogue File

The online information indicated that it was safe to delete the file, but AVG would just recreate it.

So, I did, and as predicted, the file came back. As I watched in Windows Explorer, the file size increased every few seconds.

I deleted it again, and followed the advice in one of the online comments – I set the file to Read Only.

Problem Solved

So far, so good – the file is about 500 KB, and holding. I haven’t noticed any effects from changing the file to Read Only, except for the benefit of 53 GB of free space on my C drive.

I’ll sort out the folders and files, to spread things around, not that the crisis is over. And I’ll add a few Libraries, to make it easier to get to my files, after they’re moved.

I hope you never run into this problem, but if you have AVG installed, you might want to check for a file named toolbar_log.txt – and make sure it isn’t eating up your space.

___________

Neck Strap for an iPhone

Most of the time, my iPhone is stored safely in my purse or pocket. Sometimes though, I like to use it as a camera, and I worry about dropping it.

For example, I had a nice view of the harbour from the lighthouse on Hilton Head Island, but stayed back from the railing a bit. I didn’t the phone to fall 90 feet to the ground!

IMG_7403

And this week, I held it tightly while shooting this picture from a bridge over a local river. The bridge wasn’t very high, but the landing is a bit wet.

IMG_7865

Looking for a Wrist Strap

I looked online for iPhone wrist straps, and wasn’t impressed with what I saw. Most were plugged in to the cable slot, and didn’t seem too secure.

My point and shoot camera has a little wrist strap, and a small slot on the side where the strap is attached. I didn’t see a slot on the iPad, but there is a small flap with a hole, at the top of the OtterBox iPhone case.

So, I found an old neck strap in my office drawer – it came with a USB drive – and pushed its cord through that hole.

DSC_0006

Then, I looped it over the lanyard strap, and pulled it tight. Perfect!

DSC_0002

Now, when I’m using the phone as a a camera, I can wear the neck strap, and not worry about dropping that very expensive “camera”.

If you’ve found a better solution, please let me know.

________________

Pivot Tables and Productivity

My favourite tweet in yesterday’s Excel Twitter collection was this one:

  • I feel like I know JUST enough about pivot tables to make all of my tasks 30 times harder #Excel #productivity #tcot

Does that ever happen to you? Maybe it’s not pivot tables – it could be another one of Excel’s powerful, but frustrating features.

You start a workbook, then add a bit of code, or a fancy formula, and things suddenly go south. So, you try to troubleshoot the problem, wander over to Google for some research, and before you know it, an hour has passed. Oop! There goes your productivity.

Pivot Table Articles

But, if pivot tables are your problem, I’ve published a couple of articles this week that might help you out.

Block (All) Selections

On my Excel Pivot Tables blog, there is sample code that prevents people from selecting the “(All)” option in a report filter drop down. That can be useful if you’ve got worksheet formulas or links that depend on one item being selected.

Here’s the link to that article: Block Selection of All in Report Filter

vbablockall03

List Pivot Formulas

And on my Contextures Blog, you can find sample code that lets you list all the pivot formulas in the active workbook (calculated items and calculated fields).

Here is the link to that one:  List All Pivot Table Formulas

pivotformulaslist

________________

Problems with Windows Live Writer Videos

Do you use Windows Live Writer (WLW) to write and upload blog posts?

I’ve been using it for a few years, and it’s an efficient way to manage multiple blogs. You can open WLW, select a blog name from a drop down list, and then post an article to that blog.

windowslivewriter01

Video Problems

Since I upgraded to WLW 12, using Windows 8, I’ve had trouble getting videos to upload correctly. I copy the embed code from YouTube, and paste it into WLW, and the video appears.

However, when it’s published on the blog, something has happened between WordPress and WLW, and the videos are stripped out.

To fix the problem, I have to log in to the blog’s dashboard, and paste the embed code in the HTML page there. After that, the video works correctly, but it’s a pain to have to do this for every upload.

If you’ve figured out a better solution, please let me know.

______________

Happy New Year 2013

Would you go for a plunge in the cold Atlantic Ocean on January 1st? Brrrr. I wouldn’t, but this morning I saw a group of teens, who had just come out of the water.

I don’t know how cold that water was, but the air temperature was about 50F, and I was wearing 3 layers of clothes.

IMG_4199

Try New Things

New Year’s Day is a popular time to make resolutions, and set goals for the upcoming year. I’ll try some new things this year, but polar swimming won’t be one of them!

Instead, I’ll focus on activities that won’t cause hypothermia, like

I’ll keep doing some of the old things two, such as working on my Contextures website and blog, and updating some of the older pages with new content and videos.

Happy New Year!

I hope that your new year is off to a good start, and that you look forward to trying a few new things too. Do you have anything exciting planned?

__________________

Turn Off an ASUS Laptop Touchpad

Last week, I got a new laptop, with Windows 8 as the operating system. Every task is taking twice as long as usual, as I fumble about, trying to find things.

I like the laptop though, which is much faster and quieter than the old Dell laptop. I’ve gone back to a 17” screen, after a few years with a 15” screen.

asusn76v

Turn Off the Touchpad

I used to have trouble with the touchpad on the Dell, touching it accidentally, and having strange things happen. However, the problem is much more noticeable on the ASUS, with its gigantic touchpad.

In the middle of doing something, my thumb brushes it, and I end up on the Windows 8 start screen, or in some maximized window, with no obvious escape route.

So, I reluctantly opened the manual, and found a key combination that toggles the touchpad on and off.

Press the Fn key and tap the F9 key.

To help me remember the shortcut, they’ve even put an icon on the F9 key, which you can see in the picture below.

asusfnkeys

Do You Use the Touchpad?

I’ve only used a computer’s touchpad a few times in my life, and never voluntarily, only when a mouse wasn’t available.

Do you ever use the touchpad?

___________________