Category Archives: Computers and Internet

Sum By Color in Excel 2013

To sum by color in Excel 2013 (and previous versions) you must create a VBA Module. Don’t worry, it sounds scarier than it is. Follow these steps to create a new function called SumByColor to your workbook. Press ALT+F11 to … Continue reading

Posted in Computers and Internet | 2 Comments

Calculating Length of time in Microsoft Excel

I had a document full of employment start dates in column “A” and end dates in column “B”. Wanted column “C” to calculate length of time in the following format: “1 Year, 2 Months, 3 Days”. I didn’t find a function for … Continue reading

Posted in Computers and Internet | Leave a comment

Frugal Fix Friday: Shattered PSP Screen

I got my PSP for free BECAUSE it looked like the one above. What happened is that it got sat on, dropped or something like that. I saved it from the trash can, spent $25 on a new screen, and … Continue reading

Posted in Computers and Internet | Leave a comment

Frugal Fix Friday: The Car Window

I broke my car window a couple years ago. Well, first the button to make it go up and down broke. I didn’t know that at the time. So, I brought it to my local Ford dealership and asked if … Continue reading

Posted in Computers and Internet | Leave a comment

Invasion of the Log files!

Log files, aren’t they great? When things don’t work, they’ll let you know what’s up! The problem with them is that in IIS, I haven’t found a setting that says only retain log files for x number of days… So, … Continue reading

Posted in Computers and Internet | Tagged , , , , | Leave a comment

SharePoint Post Tonight

I posted on the sharepoint blog tonight. Check it out there… here’s the link: http://sharepointexists.blogspot.com/2011/06/automating-sharepoint-server-warm-up.html It’s a handy setting if you have a SharePoint server! I like to set it on every SharePoint server I set up.

Posted in Computers and Internet | Tagged , , | Leave a comment

I don’t have a post.

But this made me laugh at lunch today…

Posted in Computers and Internet | Leave a comment