VBA excel to word

The macro to create individual columns from the an Excel to Word document is:

Sub ExcelToWord()

‘ ExcelToWord Macro

‘Dim objWord As New Word.Application
Dim rng As Range, cell As Range
Set rng = Range(“A1:BB85”) ‘Change values to all columns and rows – this should be changed to count the active columns but it works for now
Set objWord = CreateObject(“Word.Application”)
objWord.Visible = True
objWord.Documents.Open “C:\Users\…\test.docx” ‘Change values as location to save it

For Each cell In rng
‘Copy the range Which you want to paste in a New Word Document
Range(“A1:B85”).Copy ‘Change values

With objWord.ActiveDocument
objWord.Visible = True
End With

Next cell

End Sub

Note: This macro will be copy and pasting from Excel to Word the column A + B where A are the headings and B the answers. It then deletes the B column and C becomes B and so on… be careful to change the number of columns to include or you can have an infinite loop.

Coming up to speed in Java

My promotion from Research Assistant to Research Support Officer brings new responsibilities. One of them is support the development team. So, I decided to ‘refresh’ my Java skills (I haven’t used Java for the last year!) and so I just installed Eclipse and searched for resources to get up to speed!

A good starting point is Oracle Java Documentation. Other resources include:

Online Books

First results in Google Search includes:

Coursera Java Courses

Coursera Search: Java

Sample of Courses available and starting between September 2015 and December 2015:

  • Initiation à la programmation (en Java) – École Polytechnique Fédérale de Lausanne (Started)
  • Object Oriented Programming in Java – UNIVERSITY OF CALIFORNIA, SAN DIEGO (Course starts September 15, 2015)
  • Java Programming: Solving Problems with Software – DUKE UNIVERSITY (Course starts October 2015)
  • Java Programming: Arrays, Lists and Structured Data – DUKE UNIVERSITY (Course starts November 2015)
  • Advanced Data Structures in Java – UNIVERSITY OF CALIFORNIA, SAN DIEGO (Course starts November 2015)
  • Java Programming: Principles of Software Design – DUKE UNIVERSITY (Course starts December 2015)

Just Search them in the Catalog!

Youtube Java

Always handy to check youtube. Some examples:

Java Cheatsheet:

A quick search in Google shows multiple options. For example:

Sure, there are other interesting documents and resources freely available. This is just a starting point!

Irish Residential Property Price Index

This blog is the introduction to the Property Price Index that I am building for the final project of the Higher Diploma in Science – Data Science and Analytic in CIT. Next blogs will explain the data analysis performed and the model created.

Irish Residential Property Background

In the last four years, Residential Property and Property Prices has capture the attention of media and researchers alike in Ireland. The interest on this subject has increased at the same time that the Irish Property Bubble busted in 2010 (Pope, 2015) (Taylor, 2015) (Burke-Kennedy, 2015) (Newenham, 2015) (Hancock, 2014) (McKinley, 2013). From 1990’s to 2007 (Celtic Tiger Period), the number of real estate purchased increased due a positive growing economy. Rapid growth in Ireland was achieved by export-led growth with moderate wage and price inflation and healthy public finances (Honohan, 2009). The positive economy environment created a property bubble where prices increased quickly until 2007 (Gerard Kennedy, 2011). After this year with the financial crisis property prices and approved loans start falling until 2010.  This created unemployment within the construction sector. Property Market is a key element for the Irish economy (Conniffee & Duffy, 1999) (Kenny, 2015) and its relation with the financial sector impacts positively or negatively on the wealth of any household.

Houses sold in Ireland 2010 to 2014

Since early 2013 the prices are increasing again and number of houses purchased as well (Duncan, 2014) (Weston & Sheahan, 2014) (Brophy, 2014). The price evolution and its effect in the economy highlight the importance of property price models.

The importance of Property Price Model

Price (or market value) indices for property markets are important for the following reasons:

  • Individual Benchmarks purposes: property owners and investors can compare average returns on property and other assets such as stocks and bonds. It is an input into an individual citizen’s decision making on whether to buy (or sell) a residential property. Residential properties are seen as a profitable activity (renting, fix house and sell…).(Netzell, 2012) (Eurostats, 2013)
  • International Benchmarks purposes: It allows comparing the economy between different countries. It is used in making inter-area and international comparisons.. Residential Stock is part of the wealth of a country and property price index allow to quantify the value of this. (Eurostats, 2013)
  • Research on property markets and residential construction. Research topics where price indices are used include property cycles and the relationship between property markets and other financial markets. It is input into estimating the value of housing as a component of wealth (Netzell, 2012)(OECD, 2000) (Eurostats, 2013).
  • Allows forecasting the potential future private consumption: House prices affect the wealth position of households and household borrowing. Higher prices reduce the spent of buyers in order to save more to purchase the desired house. It is input into the consumer price index, which in turn is used for wage bargaining and indexation purposes. (Gerard Kennedy, 2011)(OECD, 2000) (CSO, 2015) (Eurostats, 2013).
  • Macro-economic indicator of economic growth: property prices can be useful indicators of demand pressures in the economy and business cycles. There is a positive correlation between economy expansion and rising house pricing (OECD, 2000)(Eurostats, 2013) (Plosser, 2007). For example, Bracke (2011) analyses House cycle and compare them with financial information including Real GDP, interest and inflation rates. (Bracke, 2011)
  • Economic and monetary/financial policy makers’ decisions. It is a measure for financial stability, risk evaluation, borrowing capacity, debt burden and aggregate consumption(Eurostats, 2013)(Plosser, 2007)



Bracke, P. (2011). How Long Do Housing Cycles Last? A Duration Analysis for 19 OECD Countries. Research Department . International Monetary Fund. Retrieved February 25, 2015, from https://www.imf.org/external/pubs/ft/wp/2011/wp11231.pdf

Brophy, D. (2014, July 24). Taoiseach on Dublin house prices: “I don’t accept there’s a bubble”. Retrieved February 26, 2015, from The Journal: http://www.thejournal.ie/house-prices-dublin-enda-1587774-Jul2014/

Burke-Kennedy, E. (2015, January 28). Property price inflation to moderate significantly – report. Retrieved February 20, 2015, from The Irish Times: http://www.irishtimes.com/business/economy/property-price-inflation-to-moderate-significantly-report-1.2081011

Conniffee, D., & Duffy, D. (1999, October). Irish House Price Indices —Methodological Issues*. The Economic and Social Review, Volume 30(No. 4), pp. 403-423. Retrieved February 20, 2015, from http://www.tara.tcd.ie/bitstream/handle/2262/60129/4_Conniffe.pdf?sequence=1

CSO. (2015, February 22). Statistical Product – Consumer Prices Annual Series. Retrieved February 26, 2015, from Central Statistical Office: http://www.cso.ie/px/pxeirestat/Database/eirestat/Consumer%20Prices%20Annual%20Series/Consumer%20Prices%20Annual%20Series_statbank.asp?SP=Consumer%20Prices%20Annual%20Series&Planguage=0

Duncan, P. (2014, November 26). Dublin property prices 24% higher in a year. Retrieved February 26, 2015, from The Irish Times: http://www.irishtimes.com/news/ireland/irish-news/dublin-property-prices-24-higher-in-a-year-1.2015668

Eurostats. (2013). Handbook on Residential Property Prices Indices (RPPIs). Economy and finance. Luxembourg: Publications Office of the European Union. doi:10.2785/34007

Gerard Kennedy, K. M. (2011). Scenarios for Irish House Prices. Central Bank of Ireland.

Hancock, C. (2014, October 7). New mortgage rules mean most buyers to need 20% deposit. Retrieved February 20, 2015, from The Irish Times: http://www.irishtimes.com/business/personal-finance/new-mortgage-rules-mean-most-buyers-to-need-20-deposit-1.1954732

Honohan, P. (2009). WHAT WENT WRONG IN IRELAND? Dublin: Trinity College Dublin.

Kenny, E. (2015, February 19). Interview with An Taoiseach Enda Kenny. (R. News, Interviewer)

McKinley, C. (2013, July 24). Dublin house prices increase 7.7%. Retrieved February 20, 2015, from The Irish Times: http://www.irishtimes.com/business/economy/ireland/dublin-house-prices-increase-7-7-1.1472486

Netzell, O. (2012). A method for combining transaction- and valuation-based data in a property price index. Royal Institute of Technology, Building and Real Estate Economics, Stockholm. Retrieved February 23, 2015, from https://www.kth.se/polopoly_fs/1.448285!/Menu/general/column-content/attachment/A%20method%20for%20property%20price%20index%20construction3b.pdf

Newenham, P. (2015, February 5). S&P: Ireland to see strongest rise in house prices in Europe. Retrieved February 20, 2015, from The Irish Times: http://www.irishtimes.com/business/economy/s-p-ireland-to-see-strongest-rise-in-house-prices-in-europe-1.2092501

OECD. (2000). HOUSE PRICES AND ECONOMIC ACTIVITY. OECD Economic Outlook, Volume: 68, 169-184. Retrieved February 26, 2015, from http://www.oecd.org/eco/outlook/2086136.pdf

Plosser, C. I. (2007, July 11). House Prices and Monetary Policy. Retrieved February 26, 2015, from Federal Reserve Bank of Philadelphia: http://www.philadelphiafed.org/publications/speeches/plosser/2007/07-11-07_euro-econ-finance-centre.cfm

Pope, C. (2015, February 25). Property prices suffer biggest monthly fall in three years. Retrieved February 2015, 2015, from The Irish Times: http://www.irishtimes.com/business/economy/property-prices-suffer-biggest-monthly-fall-in-three-years-1.2116903

Taylor, C. (2015, January 28). Property prices in Dublin up 23% in year to December. Retrieved February 26, 2015, from The Irish Times: http://www.irishtimes.com/business/economy/property-prices-in-dublin-up-23-in-year-to-december-1.2082459

Weston, C., & Sheahan, F. (2014, July 25). Kenny denies bubble despite record surge in the price of homes. Retrieved February 26, 2015, from Independent: http://www.independent.ie/business/personal-finance/property-mortgages/kenny-denies-bubble-despite-record-surge-in-the-price-of-homes-30458800.html