Eight married couples meet to lend one another some books. Couples have the same surname, employment, and car. Each couple has a favourite colour. Furthermore, we know the following facts:

Daniella Black and her husband work as Shop$-$Assistants.

The book "The Seadog" was written by a couple who drive a Fiat and love the color red.

Owen and his wife Victoria like the colour brown.

Stan Horricks and his wife Hannah like the colour white.

Jenny Smith and her husband work as Warehouse Managers and they drive a Wartburg.

Monica and her husband Alexander borrowed the book "Grandfather Joseph".

Mathew and his wife like the colour pink and brought the book "Mulatka Gabriela".

Irene and her husband Oto work as Accountants.

The book $"$We Were Five" was borrowed by a couple driving a Trabant.

The Cermaks are both Ticket$-$Collectors who brought the book "Shed Stoat".

Mr and Mrs Kuril are both Doctors who borrowed the book "Slovacko Judge".

Paul and his wife like the colour green.

Veronica Dvorak and her husband like the colour blue.

Rick and his wife brought the book "Slovacko Judge" and they drive a Ziguli.

One couple brought the book "Dame Commissar" and borrowed the book "Mulatka Gabriela".

The couple who drive a Dacia, love the colour violet.

The couple who work as Teachers borrowed the book "Dame Commissar".

The couple who work as Agriculturalists drive a Moskvic.

Pamela and her husband drive a Renault and brought the book "Grandfather Joseph".

Pamela and her husband borrowed the book that Mr and Mrs Zajac brought.

Robert and his wife like the colour yellow and borrowed the book "The Modern Comedy".

Mr and Mrs Swain work as Shoppers.

"The Modern Comedy" was brought by a couple driving a Skoda.

Who likes Violet? And can you find out everything about everyone from this? What approach will be to solve this problem programmatically, using any programming language or MS Excel? Someone please solve this using Excel. AND MOST IMPORTANTLY I NEED THE EXCEL SHEET AND THE EXACT FORMULAS.