• Apr13

    I’m back with another edition of cool old books I’ve found online. If you have Scottish Ancestry, you may want to flip through this 1850 book entitled (now would be a good time to get a beverage or snack, because you might be here awhile…)

    The Clans of the Highlands of Scotland, An Account of their Annals, Separately and Collectively with Delineations of Their Tartans and Family Arms.
    Edited by Thomas Smibert, Esq.
    Enjoy!


  • Apr8

    Hello Pie Lovers!

    Back in the olden days of 2011 I created an Excel spreadsheet that took the world by… drizzle. But I thought it was cool. This update to my original Ancestry Pie Chart Creator lets you enter the names of you and your ancestors and the names of the countries they came from.

    Ancestry Pie 2 Generation SampleThen you could enter the percentage of each ancestry for your great-great-grandparents and Voila! .. some nice simple pie charts of your tree.

    You can see from the comments on that original blog post a few people used it, like CeCe Moore, which I thought was pretty neat.

    After I posted the first Excel sheet I made a few changes to streamline the look a little, then I let it go dormant. But, I always had a few things in it I didn’t like that were due either to limitations in Excel or to my available time to hack my way through them.

    When I saw J. Paul Hawthorne’s Excel sheet go pretty viral-y last month, I thought now might be a good time to spruce up the old Ancestry Pie recipe. The one thing I really disliked in Excel was the random color selection it chose when creating pie charts, and that you couldn’t use one chart to paint the rest the same colors. I often thought, “I want my Irish green and my Czech Blue, Dabnabit!” and I didn’t want to have to change the colors of 10 countries in 32 charts every time I ran the thing for a different person, with different countries, who wanted different colors.

    Well, with the latest version of Excel, you still can’t paint chart formats. But, I did figure out a way to automate matching the pie chart colors to the ones a user selects for each country. So, without further to do, I have uploaded this latest version of my Excel sheet – it can be downloaded here.

    I will warn folks right now – while I did include some summary info on how to use the sheet, and also included a more detailed “Help!” sheet within the Excel file, there may be a bit of a learning curve if you are not familiar with using Excel. Also, I had to use macros (*sharp intake of breath*) to automate the color painting etc.

    Because of this, when you open the file Excel might warn you that running macros from Internet downloaded files might be dangerous, scare off your kitty and cause premature hair loss. The macros I wrote are fairly benign, but if you are the cautious type, and you think my blog avatar looks slightly shifty, then this file may not be for you.

    I plan to make a video or longer blog post with details on how to use it. But, if you’d like to be the first kid on the block to have some of the newfangled Ancestry Pie (mmmm… pie) then please download it and give it a try. While I can’t promise to offer 24×7 support or any such thing, I welcome comments and suggestions here to help me make it a workable tool for genealogy peoples.


    Ancestry Pie: Part Deux
    Version Updates:
    11 APR 2016
    * Added Last Modified date at bottom of each sheet.
    * Found that the locked sheets were preventing people from changing the country cell colors – fixed.
    * Found that in some cases opening sheet with older versions of Excel (2007 at least), Excel will “forget” formulas that add the names to the pie chart sheets. If this occurs, Excel just keeps the last name that was in the sheet. This does not appear to be happening in later versions, and I will not be fighting this bug at this time.

    26 APR 2016
    * Realized Last Modified Date macro was not being called properly. Fixed.
    * Simplified color scheme on Ancestor Entry Sheet slightly so that each Paternal/Maternal Ancestor section is Blue or Pink. I found it a little busy with the previously alternating colors for each person.

  • Apr8

    I am only a couple of generations removed from my Irish immigrants to the United States, so my own direct Irish ancestors were not here during the American Revolution.
    But, while scanning Chronicling America for interesting things, I happened upon a 1919 newspaper article in The Sun entitled Irishmen In Our Revolution, which is a review of Michael J. O’Brien’s (then) new book A Hidden Phase of American History.

    Irishmen In Our Revolution
    The review itself is an interesting read from a historical perspective – both the role the Irish played in The Revolution, and the 1919 perspective of it all.

    However, perhaps more interesting than this to those researching their Irish family that may have been in America that early is that the book itself has an Appendix entitled Officers of the American Army and Navy of the Revolution of Irish Birth or Descent – with a very long list of names and assignments. And a bonus: he has marked all of those born in Ireland with an asterisk. You can find a full copy of Irishmen In Our Revolution over on The Google Books.

    Who could asterisk for anything more?

  • Apr5

    …and, posting this solely in the name of interesting fun:

     
    Found on Brooklyn Public Library powered by Newspapers.com

  • Mar11

    I’ve just finished watching the documentary One Million Dubliners, which at it’s simplest is a study of Dublin’s Glasnevin Cemetery, the “home” to 1.5 million people of all sorts, including people like Michael Collins and Daniel O’Connell.

    One Million Dubliners PosterWhile I am sure some may find the delivery of the film to be slow, I found the the pace of the film and the multifaceted approach to telling the story were very well done, incorporating both historical and everyday figures, the creation and restoration of the cemetery itself, and perhaps most importantly the inclusion of the more mundane aspects of running a cemetery and the thoughts of those involved.

    While this latter information may fare only slightly higher on many peoples’ lists than watching paint dry, the people interviewed in these daily roles of the cemetery each show a different angle of the goings-on and in sum provide an almost surprisingly philosophical treatise on the process of death and the power surrounding one’s final resting place.

    However, the thread that holds this film together, without question, are the stories and perspectives of the cemetery’s historian Shane MacThomáis. His love of the historical subject matter and of Glasnevin itself is apparent. His wonderful interactions leading cemetery tours for both young people and adults truly draw us in with humor and pathos.

    As you are reading this review on my genealogy blog, it is highly likely at least part of many a day’s thoughts are taken up by the interaction of history, family, lost stories, loss itself, and the task of trying to find meaning in their conjunction. If so, I highly suggest your taking the time to find and watch this film.

    A word of warning: I began watching without any prior knowledge of the film beyond a recent mention online. When soon after I found it available on Hoopla Digital (streaming offered free via my local library), I thought that I had to give it a shot.

    As I got to the end of the film, I truly was more than a bit M. Night Shyamalan-ed. I do not want to say more.

    I would suggest if you know no more than I did, Do Not research the cemetery and names I mention here – just watch. You can always go online later and learn more.