Tag: Excel

  • Prime Ministers of Australia

    Yesterday, the ruling party members voted against Prime Minister Tony Abbot, and brought in Malcolm Turnbull. I am very very new to the country, and have no idea how the Parliament in Australia works; how the parties are managed; what do they stand for etc etc, however I am learning!

    Anyway, there was a comment somewhere about how quickly the PMs in Australia have changed in the last 5 years. This is the 4th Prime Minister that Australia would have in about 2 years time, and that got me thinking if this leadership position was more stable earlier? I assumed it was, and that Prime Ministers were spending more time in the position! That got me to finding the data, start dates, end dates, term and all that! Here is a graph of what I could gather!

    AustraliaPMTurns out that it has been like this forever, and this is NOT a reflection on Australia or its Prime Ministers. This is probably how politics has worked forever!

    Here are some more graphics…

    Party Breakup

     Party Breakup - PMsIts interesting to note that even though Labor had almost 50% more Prime Ministers in the total time starting 1901, they have spent slightly less time than Liberals on the seat. Can be attributed to many reasons, however an interesting statistic anyway!

    The parties have merged and changed shape over years, so this might not be a 100% accurate representation, however still gives a fair idea of how the structure has been!

    Primary source of data : http://australianpolitics.com/lists/prime-ministers-since-1901

  • Pass the “Excel” Parcel…

    I was wondering how Manish, my MIS guru would feel in the situation I was in for a lot of my time today… When Manish used to work on Excel, he would never EVER use the mouse.. he would remember all the shortcuts… and we could hear his keyboard keys clicking in perfect harmony for most of the day…. and I would never feel any less amazed at how and what he would do to make excel work like magic…

    I owe a lot of my excel skills to him… and I see him getting a lot of accolades with his amazing data analysis skills… I learnt how powerful a tool is EXCEL…

    and today… I was doing a Knowledge Transfer to someone who has spent a good 7 years in the industry… and had no clue, absolutely no clue to how excel works… even the smallest of things like selecting cells and copying and pasting information… phew… and I was to pass on my Pivot and Data generation skill on that 10MB, 15000 row excel sheet to the person… I struggled with filters, cell selection, moving around in different worksheets on the same file and what not !!! I could not believe I was in that situation…

    A true test of patience it was today… and I know its not yet over… there is more to come, because I have a feeling that as soon as I leave the supervision part, the data is going to be messed up !!!

    Phew… Uncle God… you listening right? This is critical… I have worked hard on that data and brought it to look like information… cannot afford to lose it…

    anyway… back to Excel… and sea of cells…

    Ta Tu…