I am conTENT. My work is CONtent.

Archive for the ‘office’ Category

Poll: Email Newsletters or Onesies?

Posted by contentgrrl on April 11, 2010


Posted in citizen, community, marketing, office, persuasion, publishing, reading, tools, Uncategorized, writing | Tagged: , , | Leave a Comment »

wii steps closer to virtual reality in your living room

Posted by contentgrrl on February 1, 2008

o mii gosh! My husband found this video on YouTube, where Johnny Chung Lee, a grad assistant at Carnegie Mellon U’s human-computer interaction department, has adapted the Nintendo Wii remote to serve as a digital whiteboard and head tracking for VR displays.

It’s amazing what he does with some hardware driver programming, a PC, the Wii remote controls, and some basic items you can pick up at your local Radio Shack.

With head tracking turned on, the TV actually looks like an entrance to a real room. Just like in real life, when we move our head around, we can look behind objects. As you look closely, some targets appear to be floating off in front of the screen, reaching into the real world. As we get closer to the screen, we get closer to the objects, and even get behind the ones floating in front of the screen. (Head Tracking for Desktop VR Displays using the WiiRemote on YouTube, 2:43)

Tom Cruise, Minority Report, finger LEDs, computer interfaceThe finger tracking technology is the future now. Remember how Tom Cruise flipped through images on a virtual interface in Minority report?I would love to see some games where you can look around corners like I always want to in a race or a stealth mission.

I’d also love to use that whiteboard, since you can “draw” right on the wall, and it can record your notes for later. Oh, collaboration!

Posted in games, heroes, office, tools | Tagged: , , , , , , , , | 2 Comments »

using DATEDIF to figure years of service in Excel

Posted by contentgrrl on December 19, 2007

For our employee birthdays and anniversaries message, I get the data from HR in a spreadsheet. But it’s pretty raw, a mere list of employee names & their dates of hire. People like to know how many years of service are being celebrated, so I’ve worked out the following formula.

=DATEDIF(VALUE(C4),”1-Jan-2008″,”y”) & ” y “


  • The fomula is by default DATEDIF(startdate,enddate,unit)
  • The start date variable (hire date) is in cell C4. However, since I actually concatenated columns that included Month, Day, and Year into a string, and strings don’t work for calculations, I needed to get the VALUE of C4.
  • The end date for comparison should be the first day of the following month. You could use the variable Now(), which tells the system to use the current date and time, but then the number of years would be off for a few folks.
  • I’m only looking for years of service, so I use the unit code “y”. This is in quotes so as not to be confused with the Y column.
  • To make it clear to readers that this number is a year, I added the string &” y” to the end of the result.
  • This formula is copied down a new column for all employee names & dates.
  • The spreadsheet is sorted by hire date.
  • Then I just copy & paste the cells into a message blast to our employees.

You could also use this formula to calculate age, but I wouldn’t recommend sending that information out to a world where many people prefer not to reveal their age!

You could also use this formula to calculate project time, using the NETWORKDAYS function. For more tips on this and other Date functions in Excel, see

Posted in community, office, project management | Tagged: , , , , , , , , , , , | 3 Comments »