View RSS Feed

Recent Blogs Posts

  1. A few updates

    by
    CAM
    , 16th April 2013 at 01:51 PM (100 Grades Per Minute)
    Quite a bit has happened since November...

    First off my Kubuntu install fell apart after most of my games library was locked out regardless of WINE. The titles that did work with WINE were too big a pain to get working again and I just wanted my incredible gaming rig back! Since my Windows 7 CD Key was coming up invalid, I found myself forced to install Windows 8 and after an initial "I hate Metro" period it proved to be quite a usable OS...if you throw Metro out the window. ...

    Updated 16th April 2013 at 01:52 PM by CAM

    Categories
    Uncategorized
  2. Excel Macro to Populate a Range based on Info in Another Area of Workbook

    by , 5th May 2012 at 12:46 AM
    Here is the input:
    Activity, start week, end week

    Based on the above info in the the first three columns of a spreadsheet, put a number or a string in the same row under the appropriate week number. So if an activity happens from week 18 (this week) to week 25, the corresponding columns would be filled with the number 1. So far I have not been able to figure out how to do this using macros. Seems pretty simple but I'm struggling since I have zero experience with Visual Basic ...
    Categories
    Uncategorized
  3. Using Dates in SIMS Reporting

    by
    CAM
    , 4th January 2012 at 06:12 PM (100 Grades Per Minute)
    When you output dates in SIMS with the Reporting tool, the results will come out as text and cannot be converted into a proper date with the number format window. This is a fix used in the SIMS Standard Portrait template to prevent Excel from throwing a fit and entering the data incorrectly. You can modify the template and remove the fix but that is best left to advanced users, there is a simpler option.

    Let's take a date in the format "1 March 2012" in cell C2. You can ...
    Categories
    Work , SIMS , Technical , Office